PostgreSQL CLI Essentials

psql commands for incident response.

Connect

psql -h host -U user dbname.

\\? for help.

Inspect

\\dt lists tables. \\d table describes a table.

\\du shows users.

Perf

EXPLAIN ANALYZE for query plans.

\\timing on shows query times.