π PostgreSQL Database Internals
PostgreSQL is the world's most advanced open-source relational database. These interactive visualizations help you understand its internals β from MVCC and vacuum to query planning and replication.
β¦ Live
MVCC & Vacuum
Multi-version concurrency, dead tuples, bloat, and autovacuum
Coming soon
WAL & Replication
Write-ahead logging, streaming replication, and recovery
Coming soon
Query Planner
How PostgreSQL chooses execution plans and when it gets it wrong
Coming soon
Index Internals
B-tree, GiST, GIN, BRIN β structure and use cases
Coming soon
Buffer Cache & I/O
Shared buffers, checkpointing, and OS page cache interaction
Coming soon
Lock Management
Row locks, table locks, advisory locks, and deadlock detection
Coming soon
Connection Pooling
PgBouncer, pgpool, and built-in connection management
Coming soon
Partitioning
Declarative partitioning, partition pruning, and maintenance