APM & Services
/
Services - APM
Tomcat
Database issues
Databases are connected but need alerts to monitor issues.
Top 20 database operations

By most time consumingView full table

  1. Postgres order_items select
    36.56%
  2. Postgres orders select
    36.07%
  3. Postgres customers select
    17.08%
  4. MySQL order_items select
    5.4%
  5. MySQL orders select
    3.32%
  6. MySQL customers select
    1.58%
Postgres order_items select
17.8Query time (average, milliseconds)
1.43 kThroughput (count, queries per minute)

Query time

6:35pm 6:40pm 6:45pm 6:50pm 6:55pm 7:00pm 7:05pm 7:10pm 0 0 5 5 10 10 15 15 20 20 25 25
  • Postgres order_items select

Postgres order_items select

18.2 from 6:42pm to 6:43pm
Click to learn more

Throughput

6:35pm 6:40pm 6:45pm 6:50pm 6:55pm 7:00pm 7:05pm 7:10pm 0 0 200 200 400 400 600 600 800 800 1 k 1 k 1.2 k 1.2 k 1.4 k 1.4 k 1.6 k 1.6 k
  • Postgres order_items select

Time consumption by caller

Click on the chart to jump to a transaction

Database operation callers (762.882 ms)
  • runSQL.jsp
    762.882 ms
    100%
Slow SQL traces
The slowest database queries in your transactions during this time window
7:04pm5 minutes ago
select count(*) from order_items...select count(*) from order_items
Postgres order_items select964 ms
7:04pm5 minutes ago
select avg(a.items) items_per_order FROM (SELECT order_id, count(*) items from order_items group by order_id) a...select avg(a.items) items_per_order FROM (SEL... items from order_items group by order_id) a
Postgres order_items select641 ms
6:49pm20 minutes ago
select count(*) from order_items...select count(*) from order_items
Postgres order_items select744 ms
6:49pm20 minutes ago
select avg(a.items) items_per_order FROM (SELECT order_id, count(*) items from order_items group by order_id) a...select avg(a.items) items_per_order FROM (SEL... items from order_items group by order_id) a
Postgres order_items select545 ms

Postgres order_items select

Timestamp:   Thu Dec 07 2023 19:04:36:117 GMT+0000 (Greenwich Mean Time)     |     Duration:   964 ms     |     Database name:   bikestore     |     Database instance:   ip-172-30-0-10.eu-west-1.compute.internal:11118    

Transaction:   runSQL.jsp

Query

Copy to clipboard

select count(*) from order_items

Query analysis

Copy to clipboard
Node Type
Aggregate
Parallel Aware
?
Partial Mode
?
Plan Rows
1
Plan Width
8
Plans
[{"Alias":"order_items","Node Type":"Seq Scan","Parallel Aware":"?","Parent Relationship":"Outer","Plan Rows":4682,"Plan Width":0,"Relation Name":"order_items","Startup Cost":0,"Total Cost":81.82}]
Startup Cost
93.52
Strategy
Plain
Total Cost
93.53

Stack trace

Show framework code Copy to clipboard