If you have a query that takes 10 hours to execute, that doesn't necessarily mean that it's slow - It could be normal for your system.

There is no set in stone threshold for what's good and what's bad - It depends on your system, you need to know what is abnormal/normal for your system.

Read those articles, it will show you which columns to look out for.