·3 min read
The 5 Queries I Run First When Postgres Is Slow
Five read-only PostgreSQL queries that find the usual causes of a production slowdown: lock chains, idle transactions, connection exhaustion, unindexed foreign keys and integer IDs running out.