Find slow queries

The queries using the most total time (needs the pg_stat_statements extension).

sql advanced #postgres#performance#monitoring
Abrir no playground
sql-pg-stat-statements.sql
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

SELECT round(total_exec_time::numeric, 1) AS total_ms,
       calls,
       round(mean_exec_time::numeric, 2) AS mean_ms,
       left(query, 120) AS query
FROM pg_stat_statements
ORDER BY total_exec_time DESC
LIMIT 10;