Skip to content






PostgreSQL & psql Reference — meta-commands, admin queries, pg_dump, EXPLAIN, and tuning


🐘 PostgreSQL & psql Reference

psql meta-commands, connection strings, admin queries (pg_stat_activity, locks, table bloat), EXPLAIN ANALYZE, pg_dump/pg_restore, VACUUM, and user/role management.



🔍 Free tool: PyPI Package Health Checker — check psycopg2, asyncpg, SQLAlchemy, and other PostgreSQL Python packages for known CVEs and latest versions.