"PGSimCity" visualizes how the database "PostgreSQL" actually works internally in a SimCity-like 3D view

PGSimCity is a web app that visualizes PostgreSQL internals as a SimCity-like 3D city.

It explains connection handling, SQL execution plans, shared_buffers, WAL, checkpoints, MVCC, and VACUUM visually.

The app also makes replication flows and roles like postmaster, autovacuum, checkpointer, walsender, and walreceiver easier to grasp.

It is presented as a useful tool for understanding PostgreSQL performance bottlenecks and internal processing.