I now run a service which helps you diagnose slow queries in PostgreSQL. It makes a diagram from the query planner output, helping you see which bit is slow.
https://dbatley.com/blog/2019/06/dbplanview.html #postgres #sql