Explores PostgreSQL's internal catalog system, which stores metadata about the database itself. Covers essential psql commands (like \d, \di, \dx), key system views (pg_stat_activity, pg_stat_statements, pg_locks), and underlying catalog tables (pg_class, pg_type, pg_proc). Demonstrates practical queries for troubleshooting performance issues, identifying unused indexes, checking locks, and understanding database configuration. Includes tips for using ECHO_HIDDEN to reveal the SQL behind psql commands.
Table of contents
psql’s catalog informationImportant Postgres catalog viewsPostgres catalog tablesExploring system tables with ECHO_HIDDEN or -EGetting to Postgres internals3.7K Impressions