All Visualizers

PostgreSQL Visualizer

Relational model, query planner, MVCC transactions, and index internals — all visualized

Relational Model

Data is organized in tables with a fixed schema. Each row is a record, each column is a typed attribute.

users

idnameemailrole
1Alice Chenalice@dev.ioadmin
2Bob Smithbob@dev.iouser
3Carol Licarol@dev.iouser

orders

iduser_idproducttotal
1011Pro Plan$29.00
1022Starter$9.00
1031Add-on$5.00

user_id in orders references id in users — this is a foreign key