Get under the hood of Postgres by looking at psql, system views, and internal tables.

CrunchyData's platform is a central hub for PostgreSQL professionals and database administrators, offering insights into PostgreSQL deployment, administration, and optimization. Through articles, tutorials, and case studies, CrunchyData offers insights into PostgreSQL features, replication strategies, and high availability architectures. Readers can learn about database performance tuning, backup and recovery procedures, and security best practices to ensure the reliability and security of their PostgreSQL deployments.

Crunchy Data

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.

Postgres Internals Hiding in Plain Sight

Exploring system tables with ECHO_HIDDEN or -E