APM & Services
/
Services - APM
Tomcat
Transaction overview

100 %

Most time consuming

168 ms

Slowest avg response time

<0.01 %

Highest error rate

905 rpm

Highest throughput

100 %

Apdex by most dissatisfying

Top 20 transactions

By most time consumingView full table

  1. runSQL.jsp
    100%

Time consumed by top Web transactions

Percent of wall clock time, top 5 by most time consuming

6:25pm 6:30pm 6:35pm 6:40pm 6:45pm 6:50pm 6:55pm 7:00pm 0% 0% 50% 50% 100% 100% 150% 150% 200% 200% 250% 250% 300% 300% 350% 350% 400% 400% 450% 450%
    runSQL.jsp
  • runSQL.jsp

Throughput

Request per minute
6:25pm 6:30pm 6:35pm 6:40pm 6:45pm 6:50pm 6:55pm 7:00pm 0 0 200 200 400 400 600 600 800 800 1 k 1 k 1.2 k 1.2 k
    Web
  • Web

Per-host CPU usage

Per-host memory usage

Transaction traces
Sample performance details
Only show results with:  
6:56pm2 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,081 ms
6:54pm4 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,849 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp3,733 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,904 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,439 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,617 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,988 ms
6:42pm16 minutes agorunSQL.jsp/bikestore/runSQL.jsp3,734 ms
6:41pm17 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,875 ms
6:41pm17 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,874 ms
6:41pm17 minutes agorunSQL.jsp/bikestore/runSQL.jsp3,671 ms
6:32pm26 minutes agorunSQL.jsp/bikestore/runSQL.jsp43 ms
Show 92 more

WebTransaction/JSP/runSQL.jsp

Entity: Tomcat

168 ms

Average response time

80.8 ms

Median response time

508 ms

95th percentile response time

1.05 s

99th percentile response time

0.97

Apdex score

<0.01 %

Average error rate

905 rpm

Average throughput

Segment breakdown

Throughput

Request per minute
6:25pm 6:30pm 6:35pm 6:40pm 6:45pm 6:50pm 6:55pm 7:00pm 0 0 200 200 400 400 600 600 800 800 1 k 1 k 1.2 k 1.2 k
    WebTransaction/JSP/runSQL.jsp
  • WebTransaction/JSP/runSQL.jsp
Breakdown table
JsprunSQL.jsp56.281.0094.5 ms
Database
Postgres order_items select...Postgres order_items select
13.871.3323.3 ms
Database
Postgres orders select...Postgres orders select
13.701.3323 ms
Database
Postgres customers select...Postgres customers select
6.500.66610.9 ms
Show 6 more segments
Transaction traces
Sample performance details
Only show results with:  
6:56pm2 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,081 ms
6:54pm4 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,849 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp3,733 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,904 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,439 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,617 ms
6:49pm9 minutes agorunSQL.jsp/bikestore/runSQL.jsp2,988 ms
6:42pm16 minutes agorunSQL.jsp/bikestore/runSQL.jsp3,734 ms
6:41pm17 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,875 ms
6:41pm17 minutes agorunSQL.jsp/bikestore/runSQL.jsp1,874 ms
6:41pm17 minutes agorunSQL.jsp/bikestore/runSQL.jsp3,671 ms
6:32pm26 minutes agorunSQL.jsp/bikestore/runSQL.jsp43 ms
Show 92 more
WebTransaction/JSP/runSQL.jsp
Host: ip-172-30-0-10.eu-west-1.compute.internal| Language: java | Entity: Tomcat | Thu Dec 07 2023 18:56:35:822 GMT+00:00 (Greenwich Mean Time)
DT Trace ID: | TT Trace ID: 58596d52-9532-11ee-9d00-7eed3a34de5b_0_2039
https://localhost:8080/bikestore/runSQL.jsp
RESPONSE TIME
2.08 s
App CodeDatabase CallsExternals Calls
Duration (s)Duration (%)
  • 0 ms
  • 416 ms
  • 832 ms
  • 1249 ms
  • 1665 ms
  • 2081 ms
11
runSQL.jsp
2.08 s
100%
10
Java/javax.servlet.ServletRequestListener/requestInitialized
2.08 s
100%
9
Filter/org.apache.tomcat.websocket.server.WsFilter/doFilter
2.08 s
100%
8
Servlet/org.apache.jasper.servlet.JspServlet/service
2.08 s
100%
7
Servlet/org.apache.jsp.runSQL_jsp/service
2.08 s
100%
6
Jsp/runSQL.jsp
2.08 s
100%
Application code in (Jsp/runSQL.jsp)
1.71 s
82.22%
Postgres orders select
65 ms
3.12%
Postgres orders select
55 ms
2.64%
Postgres customers select
52 ms
2.50%
Postgres order_items select
113 ms
5.43%
Postgres order_items select
85 ms
4.08%

Postgres orders select

Transaction name
WebTransaction/JSP/runSQL.jsp

Database instance
ip-172-30-0-10.eu-west-1.compute.internal

Duration
65 ms

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

Parameters