Как отловить и оптимизировать запросы в PostgreSQL

How to catch and optimize problematic queries in PostgreSQL #databases If you work with PostgreSQL, you've likely run into performance issues at some point — especially as your database grows. Things may have been running smoothly at first, but as your client database expanded, queries started slowing down. Sound familiar? Here's a guide to help you identify and fix problematic queries, so you can get your PostgreSQL database running at peak performance again.

link