Query Analytics
PROD-DB-CLUSTER · POSTGRESQL 15
Active Connections1,240 / 2000
Queries / Sec18.4k
P99 Query Latency
450ms
Deadlocks (1h)
12
Cache Hit Ratio
94.2%
Slowest Queries (By Total Wait Time)
| Query ID | SQL Snippet | Avg Time | P99 | Count | Load % |
|---|---|---|---|---|---|
| q_1a2b | SELECTSELECT * FROM inventory WHERE status = 'AVAILABLE' AND ... | 1.2s | 4.5s | 12,450 | 45% |
| q_8f9c | UPDATEUPDATE users SET last_login = NOW() WHERE id = $1 | 45ms | 120ms | 85,120 | 12% |
| q_3e4d | AGGREGATESELECT SUM(amount) FROM transactions WHERE date > $1 G... | 8.4s | 15.2s | 450 | 28% |
| q_7b6a | INSERTINSERT INTO sessions (id, data, expires) VALUES ($1...) | 12ms | 35ms | 145,000 | 8% |
| q_5c8d | JOINSELECT products.*, categories.name FROM products LE... | 450ms | 1.8s | 32,100 | 7% |