Connect / Sync
🔄 DEMO MODE (no live connection)
demo dataset
pg_stat_activity · Wait events
PID
STATE
WAIT EVENT
QUERY (trunc)
DURATION
Wait event analyzer active.
Top SQL (pg_stat_statements)
QUERY ID
CALLS
MEAN TIME
I/O HIT
ROWS
Throughput & Checkpoint
checkpoints_req:
6
/hour
buffers_checkpoint:
2.3
GB
Query planner & live index advisor
SELECT * FROM invoices WHERE status = 'pending' AND due_date < now();
AI recommendation: create index on due_date, status.
pg_locks & replication stats
LOCK TYPE
RELATION
MODE
GRANTED
REPLICATION LAG