PostgreSQL Reference: EXPLAIN ANALYZE, Covering Indexes, pg_stat_activity, and Safe DDL Migrations

PostgreSQL diagnostics and the patterns you need before you're staring at production slow queries. psql meta-commands — faster than any GUI \l -- list databases \c mydb -- connect to database \dt -- list tabl...