How to find slow queries in PostgreSQL
A practical guide to finding slow PostgreSQL queries with pg_stat_activity, pg_stat_statements, log_min_duration_statement and auto_explain.
Blog
PostgreSQL, in practice
Hands-on articles about finding and fixing performance problems in PostgreSQL.