[bbojan]

Start with EXPLAIN ANALYZE then work from there. You can use tools where you paste the output of it and it shows you the data in a more easy to understand format.

[vberg]

I am using https://explain.dalibo.com/ for that exact purpose and it does a great job highlighting the perfs issues.