PGSIMCITY / MACHINE ROOM 01

THE MACHINE

REAL POSTGRESQL LEFT VIA PGLITE BY ELECTRICSQL — POSTGRESQL COMPILED TO WEBASSEMBLY. SOURCE. THE CITY'S ARCHITECTURE + MODELLED INTERIOR RIGHT.

PostgreSQL 18.4 model · PGlite 18.3 engine

Model and explanations: PostgreSQL 18.4 · PGlite engine: PostgreSQL 18.3 (PGlite 0.5.4), checked separately with SELECT version().

← Back to city

Legal

PGSimCity is an independent, non-commercial educational visualization of PostgreSQL internals. It is not affiliated with, sponsored, endorsed, or approved by Electronic Arts Inc. SimCity is a trademark of Electronic Arts Inc. PGlite is by ElectricSQL (Electric DB Limited), copyright Electric DB Limited and licensed under Apache-2.0. It contains PostgreSQL code compiled to WebAssembly; PostgreSQL and modifications to it are distributed under the PostgreSQL License. Source.

P POSTGRESQL REPORT M MODELLED RHYTHM

NOT LOADED · FIRST QUERY MAY START IT

00.0 / 36s MODEL

VIEW 1×

PSQL / PGLITE BY ELECTRICSQL · SINGLE CONNECTION OFFLINE

psql workbench
Type SQL directly. Up/Down recalls history.
Available: \d  \dt  \d+ table  \timing
IN-MEMORY, SINGLE-CONNECTION RUNTIME.
NO CONCURRENCY, LOCK CONTENTION, REPLICATION, STANDBY, OR REAL DEVICE I/O.
EACH SUBMITTED STATEMENT EXECUTES ONCE; DISPLAYED ROWS COME FROM THAT EXECUTION.

NO STATEMENT VIEW RUNNING

This prototype needs a browser with Canvas 2D support.

THE MACHINE

FROM SELECT 1 TO AN ACCESS PATH

ONE P EXECUTION. TWO M COMMIT POLICIES.