SQL Academy · Lesson

Identifying and Fixing Slow Queries

Use pg_stat_statements, log_min_duration_statement, and EXPLAIN to find slow queries and apply targeted fixes.

Step 1: Find the Slow Ones

Don't optimise blind. Use:

Enable the extension and configure shared_preload_libraries:

-- postgresql.conf
shared_preload_libraries = 'pg_stat_statements'

-- After restart:
CREATE EXTENSION pg_stat_statements;