op: render-hot-item

50 events · 5.30 ms wall · 4.88 ms DB (92%) · 422.20 us non-DB (8%)
DB 4.88 ms

Transactions

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

#durationreadswritesmax idleoutcomelongest template
12.44 ms10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
2125.70 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
315.00 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
410.00 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
58.60 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
68.10 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
77.90 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
88.20 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
98.70 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_id = ?
1012.10 us10—autocommitSELECT COUNT(*) FROM orders WHERE customer_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.

+offsetgapeventdurationtemplateparamscall-site
0 ns—PREPARE2.22 msSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.31 ms89.70 usEXECUTE_QUERY2.44 msSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
4.82 ms71.10 usNEXT1.20 usSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
4.86 ms39.10 usCLOSE900 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
4.86 ms1.20 usCLOSE1.10 us——stack[-1]
4.86 ms1.20 usPREPARE3.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
4.90 ms30.10 usEXECUTE_QUERY125.70 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.04 ms12.70 usNEXT300 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.04 ms1.40 usCLOSE200 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.04 ms300 nsCLOSE300 ns——stack[-1]
5.04 ms600 nsPREPARE1.00 usSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.06 ms15.50 usEXECUTE_QUERY15.00 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.08 ms11.40 usNEXT100 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.08 ms900 nsCLOSE100 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.08 ms200 nsCLOSE200 ns——stack[-1]
5.08 ms400 nsPREPARE800 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.10 ms11.40 usEXECUTE_QUERY10.00 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.11 ms7.70 usNEXT200 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.11 ms600 nsCLOSE100 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.11 ms200 nsCLOSE200 ns——stack[-1]
5.12 ms200 nsPREPARE600 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.13 ms9.90 usEXECUTE_QUERY8.60 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.14 ms7.50 usNEXT200 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.14 ms800 nsCLOSE100 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.14 ms200 nsCLOSE100 ns——stack[-1]
5.14 ms300 nsPREPARE600 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.15 ms10.00 usEXECUTE_QUERY8.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.17 ms7.50 usNEXT200 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.17 ms600 nsCLOSE100 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.17 ms300 nsCLOSE100 ns——stack[-1]
5.17 ms300 nsPREPARE400 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.18 ms9.40 usEXECUTE_QUERY7.90 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.20 ms7.30 usNEXT300 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.20 ms700 nsCLOSE0 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.20 ms200 nsCLOSE200 ns——stack[-1]
5.20 ms300 nsPREPARE500 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.21 ms11.00 usEXECUTE_QUERY8.20 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.23 ms14.30 usNEXT200 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.23 ms700 nsCLOSE100 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.23 ms200 nsCLOSE200 ns——stack[-1]
5.23 ms300 nsPREPARE600 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.24 ms10.20 usEXECUTE_QUERY8.70 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.26 ms7.90 usNEXT200 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.26 ms900 nsCLOSE100 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.26 ms300 nsCLOSE300 ns——stack[-1]
5.26 ms300 nsPREPARE700 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
5.28 ms13.10 usEXECUTE_QUERY12.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55
5.30 ms10.80 usNEXT300 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.30 ms800 nsCLOSE200 nsSELECT COUNT(*) FROM orders WHERE customer_id = ?—stack[-1]
5.30 ms200 nsCLOSE200 ns——stack[-1]