Detail – Trace: GET /bikestore/runSQL.jsp – Analytics: Calls

Analytics

Calls

Live

9,303 Calls

select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:01 299,727ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:02 298,735ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:03 298,288ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:03 297,944ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:05 295,694ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:09 292,158ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:09 292,082ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:13 288,202ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:15 286,348ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:15 286,058ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:16 284,691ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:18 283,212ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:19 282,401ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:19 281,616ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:24 277,475ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:24 276,876ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:26 275,441ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:28 273,069ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:29 271,509ms
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a2024-03-21, 14:15:31 269,902ms

GET /bikestore/runSQL.jsp

Trace ID: af2f51f6a6ed0675

Download Analyze Calls of this Trace

Sub Calls

Erroneous Calls

Error Logs

Warn Logs

Duration

5.00min

Timeline

Colorize by

Started: 2024-03-21, 14:15:01

5.00min

GET /bikestore/runSQL.jsp

CONNECT

select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a

select distinct order_status from orders

select c.customer_id, c.first_name, c.last_name, o.order_status from customers c, orders o where c.customer_id = o.customer_id and o.order_status = 1

select count(*) from order_items

select avg(a.items) items_per_order FROM (SELECT order_id, count(*) items from order_items group by order_id) a

Calls

Colorize by

Started: 2024-03-21, 14:15:01

Root call latency 5.00min

5.00min

GET /bikestore/runSQL.jspHTTP

300,001ms

ToGET /bikestoreofBikeStore

CONNECTDATABASE

75ms

ToCONNECTofordersdb

select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) aDATABASE

299,727ms

Toordersofordersdb

select distinct order_status from ordersDATABASE

141ms

Toordersofordersdb

select c.customer_id, c.first_name, c.last_name, o.order_status from customers c, orders o where c.customer_id = o.customer_id and o.order_status = 1DATABASE

8ms

Tocustomersofordersdb

select count(*) from order_itemsDATABASE

45ms

Toorder_itemsofordersdb

select avg(a.items) items_per_order FROM (SELECT order_id, count(*) items from order_items group by order_id) aDATABASE

5ms

Toorder_itemsofordersdb

Service Endpoint List

Service	Endpoint	Aggregated Time	Calls
BikeStore	GET /bikestore	300,001ms	1
ordersdb	orders	299,868ms	2
ordersdb	CONNECT	75ms	1
ordersdb	order_items	50ms	2
ordersdb	customers	8ms	1