PostgreSQL management dashboard mockup with space usage, locking, and running queries panes

Space usage per database
total
analytics
148 GB
warehouse
83 GB
app_prod
49 GB
staging
36 GB

Click a database to inspect table usage →

analytics top 20 tables + other
Database locks live
PID Database Relation Lock type Mode Status Duration
18432analyticsevents relationShareLock waiting00:02:14
18401analyticsevents relationExclusiveLock blocking00:02:45
18510app_prodorders rowRowShareLock granted00:00:03
18523app_produsers relationAccessShareLock granted00:00:01
18599warehousefact_sales relationShareLock waiting00:00:48

Query: pg_locks JOIN pg_stat_activity

Running queries pg_stat_activity
PID ↕ Database ↕ User ↕ Duration ↕ State Query Wait event ↕