op: heartbeat

90 events · 3.00 ms wall · 2.28 ms DB (76%) · 718.50 us non-DB (24%)

DB 2.28 msnon-DB 718.50 us

Transactions

Autocommit mode — every statement was its own transaction. Group related writes in one explicit transaction (and reads outside it) to cut round-trips.

#	duration	writes	max idle	outcome	longest template
1	88.60 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
2	50.40 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
3	18.40 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
4	47.10 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
5	36.10 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
6	19.40 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
7	17.60 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
8	15.90 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
9	33.70 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
10	36.50 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
11	44.80 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
12	18.80 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
13	22.40 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
14	23.00 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
15	24.80 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
16	15.90 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
17	16.20 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
18	19.00 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
19	16.10 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
20	20.20 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
21	18.30 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
22	15.80 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
23	15.80 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
24	15.80 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
25	15.20 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
26	21.00 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
27	16.20 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
28	17.30 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
29	66.10 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`
30	41.20 us	1	—	autocommit	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`

Timeline

gap is idle time since the previous event on the same thread — highlighted rows had noticeably more app/non-DB time before them than the rest. Follow those to find where the op lost its wall-clock time outside the database.

+offset	gap	event	duration	template	params	call-site
0 ns	—	PREPARE	1.43 ms	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.49 ms	69.20 us	EXECUTE_UPDATE	88.60 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 1`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.62 ms	32.80 us	CLOSE	400 ns	—	—	`stack[-1]`
1.62 ms	700 ns	PREPARE	1.20 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.63 ms	12.60 us	EXECUTE_UPDATE	50.40 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 2`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.69 ms	9.70 us	CLOSE	200 ns	—	—	`stack[-1]`
1.69 ms	500 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.70 ms	10.70 us	EXECUTE_UPDATE	18.40 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 3`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.73 ms	8.50 us	CLOSE	200 ns	—	—	`stack[-1]`
1.73 ms	300 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.74 ms	10.10 us	EXECUTE_UPDATE	47.10 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 4`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.80 ms	9.50 us	CLOSE	200 ns	—	—	`stack[-1]`
1.80 ms	400 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.81 ms	10.70 us	EXECUTE_UPDATE	36.10 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 5`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.86 ms	9.10 us	CLOSE	300 ns	—	—	`stack[-1]`
1.86 ms	400 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.87 ms	10.40 us	EXECUTE_UPDATE	19.40 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 6`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.90 ms	14.20 us	CLOSE	200 ns	—	—	`stack[-1]`
1.90 ms	400 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.91 ms	10.60 us	EXECUTE_UPDATE	17.60 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 7`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.94 ms	8.00 us	CLOSE	200 ns	—	—	`stack[-1]`
1.94 ms	300 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.95 ms	9.80 us	EXECUTE_UPDATE	15.90 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 8`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
1.97 ms	7.70 us	CLOSE	300 ns	—	—	`stack[-1]`
1.97 ms	300 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
1.98 ms	10.30 us	EXECUTE_UPDATE	33.70 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 9`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.03 ms	11.10 us	CLOSE	200 ns	—	—	`stack[-1]`
2.03 ms	600 ns	PREPARE	800 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.05 ms	18.80 us	EXECUTE_UPDATE	36.50 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 10`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.10 ms	10.60 us	CLOSE	400 ns	—	—	`stack[-1]`
2.10 ms	500 ns	PREPARE	800 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.12 ms	19.80 us	EXECUTE_UPDATE	44.80 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 11`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.17 ms	9.70 us	CLOSE	300 ns	—	—	`stack[-1]`
2.17 ms	500 ns	PREPARE	800 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.18 ms	10.40 us	EXECUTE_UPDATE	18.80 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 12`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.21 ms	9.00 us	CLOSE	300 ns	—	—	`stack[-1]`
2.21 ms	400 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.22 ms	9.90 us	EXECUTE_UPDATE	22.40 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 13`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.26 ms	10.90 us	CLOSE	400 ns	—	—	`stack[-1]`
2.26 ms	600 ns	PREPARE	900 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.27 ms	15.30 us	EXECUTE_UPDATE	23.00 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 14`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.31 ms	11.80 us	CLOSE	400 ns	—	—	`stack[-1]`
2.31 ms	600 ns	PREPARE	800 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.32 ms	11.20 us	EXECUTE_UPDATE	24.80 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 15`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.35 ms	8.10 us	CLOSE	300 ns	—	—	`stack[-1]`
2.36 ms	300 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.37 ms	11.00 us	EXECUTE_UPDATE	15.90 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 16`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.39 ms	7.80 us	CLOSE	200 ns	—	—	`stack[-1]`
2.39 ms	300 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.40 ms	10.30 us	EXECUTE_UPDATE	16.20 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 17`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.43 ms	7.90 us	CLOSE	200 ns	—	—	`stack[-1]`
2.43 ms	300 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.44 ms	9.90 us	EXECUTE_UPDATE	19.00 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 18`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.46 ms	8.00 us	CLOSE	200 ns	—	—	`stack[-1]`
2.46 ms	300 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.48 ms	10.40 us	EXECUTE_UPDATE	16.10 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 19`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.50 ms	8.00 us	CLOSE	200 ns	—	—	`stack[-1]`
2.50 ms	300 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.51 ms	10.80 us	EXECUTE_UPDATE	20.20 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 20`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.54 ms	11.60 us	CLOSE	400 ns	—	—	`stack[-1]`
2.54 ms	600 ns	PREPARE	800 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.56 ms	11.90 us	EXECUTE_UPDATE	18.30 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 21`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.58 ms	8.20 us	CLOSE	200 ns	—	—	`stack[-1]`
2.58 ms	400 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.59 ms	9.50 us	EXECUTE_UPDATE	15.80 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 22`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.62 ms	9.60 us	CLOSE	200 ns	—	—	`stack[-1]`
2.62 ms	400 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.63 ms	10.60 us	EXECUTE_UPDATE	15.80 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 23`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.66 ms	8.00 us	CLOSE	200 ns	—	—	`stack[-1]`
2.66 ms	300 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.67 ms	16.00 us	EXECUTE_UPDATE	15.80 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 24`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.70 ms	7.90 us	CLOSE	200 ns	—	—	`stack[-1]`
2.70 ms	300 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.71 ms	9.60 us	EXECUTE_UPDATE	15.20 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 25`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.73 ms	8.90 us	CLOSE	300 ns	—	—	`stack[-1]`
2.73 ms	400 ns	PREPARE	900 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.75 ms	13.20 us	EXECUTE_UPDATE	21.00 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 26`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.78 ms	9.30 us	CLOSE	300 ns	—	—	`stack[-1]`
2.78 ms	400 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.79 ms	10.60 us	EXECUTE_UPDATE	16.20 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 27`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.81 ms	9.40 us	CLOSE	200 ns	—	—	`stack[-1]`
2.81 ms	400 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.83 ms	10.30 us	EXECUTE_UPDATE	17.30 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 28`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.85 ms	7.80 us	CLOSE	200 ns	—	—	`stack[-1]`
2.85 ms	400 ns	PREPARE	600 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.86 ms	9.60 us	EXECUTE_UPDATE	66.10 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 29`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
2.94 ms	9.30 us	CLOSE	300 ns	—	—	`stack[-1]`
2.94 ms	400 ns	PREPARE	700 ns	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.95 ms	10.10 us	EXECUTE_UPDATE	41.20 us	`UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?`	`[1] 30`	`fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13`
3.00 ms	10.50 us	CLOSE	200 ns	—	—	`stack[-1]`