Re:Nine ways to shoot yourself in the foot with PostgreSQL
by Zanfa on Tuesday April 25, 2023 @05:23AM
(#35698204)
I don't have any other good recommendations other than learning how to read and use EXPLAIN [1]. This should typically be the first tool when you have a slow query.
[1] https://www.postgresql.org/docs/current/sql-explain.html