Database Performance
Query throughput, slow query analysis, connection pool saturation, and index utilization for PostgreSQL primary.
Queries / sec
4,182
+8%vs 1h ago
Avg Query Time
4.2ms
-12%vs prev
Slow Queries (>200ms)
142
+18%vs prev
Active Connections
84 / 100
0%of pool
Query Throughput
Queries per second over the past 24 hours
Request Volume
Slowest Queries
Ranked by average execution time over the last 24h.
Query | Avg ms | Max ms | Calls (24h) | Total Time |
|---|---|---|---|---|
SELECT * FROM invoices WHERE org_id = $1 AND created_at > $2 ORDER BY created_at DESC | 1240 | 3820 | 1,840 | 38m |
SELECT u.*, s.* FROM users u LEFT JOIN sessions s ON s.user_id = u.id WHERE u.tenant_id = $1 | 820 | 2104 | 4,280 | 58m |
SELECT COUNT(*) FROM events WHERE metadata->>'source' = $1 AND created_at > NOW() - INTERVAL '30 days' | 642 | 1820 | 9,200 | 1.6h |
UPDATE ledger_entries SET reconciled = true WHERE batch_id = $1 AND reconciled = false | 480 | 1240 | 320 | 3m |
SELECT order_id, SUM(amount) FROM payments WHERE status = 'completed' GROUP BY order_id HAVING SUM(amount) > $1 | 380 | 920 | 1,840 | 12m |
SELECT * FROM audit_log WHERE actor_id = $1 AND action LIKE '%delete%' ORDER BY timestamp DESC LIMIT 100 | 312 | 820 | 6,800 | 35m |
Showing 1-6 of 8
1 / 2
Connection Pool
PgBouncer pool utilization
Active84 / 100
Idle12 / 100
Waiting4
Max Lifetime (s)1800
Pool modetransaction
Avg wait time2.4ms
Pool hits98.2%
Index Usage Stats
Scans, size, and utilization per index (sorted by usage).
invoices_org_created_idx248 MBtable:
invoices184,200 scansusers_tenant_id_idx82 MBtable:
users142,800 scansevents_metadata_gin1.2 GBtable:
events92,400 scanspayments_status_idx156 MBtable:
payments64,800 scansledger_entries_batch_idx44 MBtable:
ledger_entries18,200 scansaudit_log_actor_idx92 MBtable:
audit_log12,400 scanswebhook_deliveries_url_idx12 MBtable:
webhook_deliveries2,400 scansapi_keys_expires_idx2 MBtable:
api_keys820 scans