-- Enable extension
CREATE EXTENSION pg_stat_statements;
-- Top 10 slowest queries
SELECT query, calls, mean_exec_time, total_exec_time
FROM pg_stat_statements
ORDER BY mean_exec_time DESC
LIMIT 10;This extension is the #1 tool for identifying queries to optimize.