An interactive 3D city that shows how Postgres actually works

You can now walk through an interactive 3D city where every building is a Postgres process and every road carries memory pages.

NikolayS released PGSimCity, an open-source interactive 3D visualizer for PostgreSQL internals that picked up 437 stars on GitHub this week. It turns a Postgres cluster into a city you can inspect directly in your browser with zero installation. You can trace query execution, watch memory buffers swap pages, and trigger database scenarios in real time.

Why it matters: Many developers write SQL daily without seeing what happens under the hood when latency spikes or table bloat strikes. PGSimCity makes abstract architecture—like shared_buffers, WAL writes, and autovacuum workers—visible and simple to understand.

Here's the gist: open the live web demo and press T for a 14-chapter guided tour, or hit G to walk through the streets at eye level. You can trigger scenarios like "Checkpoint storm" or "Cache thrash" to see how systems behave under pressure. Keep in mind it is an early 0.x educational model with scaled numbers for human viewing, not a full PostgreSQL emulator running native source code.

Database operations get much easier to understand when you can physically watch a forgotten transaction clog the memory district.