Dashboard

AxiomDB v0.1 · localhost:3306

Connected

Queries / sec

2,847

avg 8.3ms

↑ 12% from yesterday

Connections

12 / 50

24% utilized

Database size

1.2 GB

WAL: 48 MB

Cache hit rate

94.2%

Buffer pool

↑ 2.1% this hour

Uptime

14d 6h 23m

Query throughput

Active connections

Recent querieslast 5

Query	Duration	Rows	Time	Status
SELECT * FROM users WHERE active = TRUE LIMIT 100	4ms	100	18:45:03	ok
SELECT COUNT(*) FROM orders WHERE status = 'pending'	2ms	1	18:44:51	ok
UPDATE users SET active = FALSE WHERE last_login < NOW() - INTERVAL '90 days'	143ms	234	18:43:22	ok
SELECT u.name, SUM(o.amount) FROM users u JOIN orders o ON u.id = o.user_id GROUP BY u.name	28ms	1,847	18:41:09	ok
INSERT INTO orders (user_id, amount, status) VALUES (42, 99.99, 'pending')	6ms	1	18:40:33	ok

Slow Queries>100ms

Query	Table	Duration	Time
SELECT u.*, COUNT(o.id) FROM users u LEFT JOIN orders o ON u.id = o.user_id GROUP BY u.id ORDER BY created_at DESC	users	342ms	18:39:11
UPDATE orders SET status = 'archived' WHERE created_at < NOW() - INTERVAL '365 days'	orders	187ms	18:31:55
SELECT * FROM orders o JOIN users u ON o.user_id = u.id WHERE o.amount > 1000 AND u.active = TRUE	orders	124ms	18:22:03