Total execution time
Query audit
pg_stat_statements audit for slow PostgreSQL queries
Query-level performance work is stronger when pg_stat_statements is enabled. PostgresAudit uses those metrics to rank problems before proposing next diagnostics.
Mean execution time
Temp block writes
Shared block reads
What pg_stat_statements adds
It gives aggregate query statistics, making it easier to separate a one-off slow query from repeated high-cost workload.
How findings are prioritized
PostgresAudit ranks expensive queries by total time, mean time, temp writes, rows, and read pressure, then connects each finding to known evidence.
Safe next steps
The report prefers EXPLAIN (ANALYZE, BUFFERS), staging tests, and before/after comparison over direct production changes.