op: order-report

65 events · 9.91 ms wall · 6.94 ms DB (70%) · 2.98 ms non-DB (30%)

DB 6.94 msnon-DB 2.98 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.

#	duration	reads	max idle	outcome	longest template
1	4.56 ms	1	—	autocommit	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`
2	97.50 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
3	14.70 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
4	18.30 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
5	23.90 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
6	20.40 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
7	20.50 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
8	21.60 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
9	18.90 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
10	18.90 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`
11	17.80 us	1	—	autocommit	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers 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	2.07 ms	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
2.16 ms	89.60 us	EXECUTE_QUERY	4.56 ms	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	`[1] 10`	`fi.vesas.jdbclens.sample.service.OrderReportService.topCustomersBySpend:40`
6.79 ms	68.00 us	NEXT	1.70 us	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.20 ms	2.40 ms	NEXT	1.00 us	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.20 ms	3.40 us	NEXT	0 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.20 ms	1.10 us	NEXT	100 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.20 ms	800 ns	NEXT	200 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.20 ms	900 ns	NEXT	100 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.21 ms	800 ns	NEXT	100 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.21 ms	800 ns	NEXT	200 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.21 ms	800 ns	NEXT	0 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.21 ms	2.90 us	NEXT	100 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.21 ms	800 ns	NEXT	400 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.21 ms	1.50 us	CLOSE	900 ns	`SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o…`	—	`stack[-1]`
9.22 ms	3.20 us	CLOSE	1.80 us	—	—	`stack[-1]`
9.23 ms	10.40 us	PREPARE	4.90 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.33 ms	92.80 us	EXECUTE_QUERY	97.50 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 169`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.45 ms	23.70 us	NEXT	200 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.45 ms	2.90 us	CLOSE	200 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.45 ms	200 ns	CLOSE	300 ns	—	—	`stack[-1]`
9.45 ms	900 ns	PREPARE	800 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.47 ms	12.80 us	EXECUTE_QUERY	14.70 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 162`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.49 ms	7.00 us	NEXT	200 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.49 ms	1.80 us	CLOSE	200 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.49 ms	100 ns	CLOSE	200 ns	—	—	`stack[-1]`
9.49 ms	500 ns	PREPARE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.50 ms	9.20 us	EXECUTE_QUERY	18.30 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 155`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.53 ms	7.20 us	NEXT	100 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.53 ms	1.60 us	CLOSE	200 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.53 ms	100 ns	CLOSE	100 ns	—	—	`stack[-1]`
9.53 ms	500 ns	PREPARE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.54 ms	11.30 us	EXECUTE_QUERY	23.90 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 148`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.58 ms	13.30 us	NEXT	700 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.58 ms	1.60 us	CLOSE	200 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.58 ms	100 ns	CLOSE	100 ns	—	—	`stack[-1]`
9.58 ms	900 ns	PREPARE	2.90 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.60 ms	13.20 us	EXECUTE_QUERY	20.40 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 141`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.63 ms	12.70 us	NEXT	1.10 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.64 ms	3.50 us	CLOSE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.64 ms	400 ns	CLOSE	600 ns	—	—	`stack[-1]`
9.64 ms	500 ns	PREPARE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.65 ms	15.50 us	EXECUTE_QUERY	20.50 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 134`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.69 ms	13.60 us	NEXT	100 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.69 ms	5.60 us	CLOSE	100 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.69 ms	200 ns	CLOSE	200 ns	—	—	`stack[-1]`
9.69 ms	500 ns	PREPARE	3.10 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.71 ms	15.60 us	EXECUTE_QUERY	21.60 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 127`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.75 ms	14.20 us	NEXT	200 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.75 ms	4.10 us	CLOSE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.75 ms	500 ns	CLOSE	300 ns	—	—	`stack[-1]`
9.75 ms	500 ns	PREPARE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.77 ms	15.20 us	EXECUTE_QUERY	18.90 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 120`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.80 ms	13.50 us	NEXT	300 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.80 ms	2.10 us	CLOSE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.81 ms	500 ns	CLOSE	900 ns	—	—	`stack[-1]`
9.81 ms	1.10 us	PREPARE	600 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.82 ms	16.20 us	EXECUTE_QUERY	18.90 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 113`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.86 ms	12.00 us	NEXT	400 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.86 ms	4.30 us	CLOSE	100 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.86 ms	100 ns	CLOSE	200 ns	—	—	`stack[-1]`
9.86 ms	400 ns	PREPARE	500 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
9.88 ms	16.80 us	EXECUTE_QUERY	17.80 us	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	`[1] 106`	`fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41`
9.91 ms	13.10 us	NEXT	300 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.91 ms	2.60 us	CLOSE	900 ns	`SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ?`	—	`stack[-1]`
9.91 ms	400 ns	CLOSE	300 ns	—	—	`stack[-1]`