search cancel

BT list slowness

book

Article ID: 134059

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE

Issue/Introduction

We are still experience a particular slowness, clicking on “administration” on CEM console. It takes some time (30 seconds and more) to visualize the BT list.

We have a production environment 10.5 (with the same BS/BT configuration) and it takes 5 – 6 seconds to see the bt list.

 

I saw the Postgres logs just after clicking the “administration” webpage.

 

[30000-cemdb-admin-2019-06-25 14:08:13.354 CEST]LOG:  disconnection: session time: 0:29:33.488 user=admin database=cemdb host=172.30.137.197 port=50304

[30492-cemdb-admin-2019-06-25 14:08:19.568 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_vertex_filter  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.568 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_vertex_filter2  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.569 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_filter   (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.569 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_edge_filter  (source_id INTEGER, target_id INTEGER, transaction_id INTEGER, backend_id INTEGER,   start_time TIMESTAMP, end_time TIMESTAMP,   PRIMARY KEY (source_id, target_id, transaction_id, backend_id, start_time))  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.569 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_edge_filter2  (source_id INTEGER, target_id INTEGER, transaction_id INTEGER, backend_id INTEGER,   start_time TIMESTAMP, end_time TIMESTAMP,   PRIMARY KEY (source_id, target_id, transaction_id, backend_id, start_time))  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.570 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_filter_or  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.570 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_filter_fu  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.570 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_bt_filter  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:19.571 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_all_edge_filter  (source_id INTEGER, target_id INTEGER, transaction_id INTEGER, backend_id INTEGER,   start_time TIMESTAMP, end_time TIMESTAMP,   PRIMARY KEY (source_id, target_id, transaction_id, backend_id, start_time))  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.168 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_vertex_filter  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.168 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_vertex_filter2  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.168 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_filter   (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.169 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_edge_filter  (source_id INTEGER, target_id INTEGER, transaction_id INTEGER, backend_id INTEGER,   start_time TIMESTAMP, end_time TIMESTAMP,   PRIMARY KEY (source_id, target_id, transaction_id, backend_id, start_time))  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.169 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_edge_filter2  (source_id INTEGER, target_id INTEGER, transaction_id INTEGER, backend_id INTEGER,   start_time TIMESTAMP, end_time TIMESTAMP,   PRIMARY KEY (source_id, target_id, transaction_id, backend_id, start_time))  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.170 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_filter_or  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.170 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_filter_fu  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.170 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_bt_filter  (vertex_id INTEGER, start_time TIMESTAMP, PRIMARY KEY (vertex_id, start_time) )  ON COMMIT DELETE ROWS

[30492-cemdb-admin-2019-06-25 14:08:20.171 CEST]LOG:  execute <unnamed>: CREATE TEMPORARY TABLE IF NOT EXISTS appmap_all_edge_filter  (source_id INTEGER, target_id INTEGER, transaction_id INTEGER, backend_id INTEGER,   start_time TIMESTAMP, end_time TIMESTAMP,   PRIMARY KEY (source_id, target_id, transaction_id, backend_id, start_time))  ON COMMIT DELETE ROWS

[30313-cemdb-admin-2019-06-25 14:08:38.474 CEST]LOG:  disconnection: session time: 0:12:29.996 user=admin database=cemdb host=172.30.136.172 port=48564

[30513-[unknown]-[unknown]-2019-06-25 14:08:38.484 CEST]LOG:  connection received: host=172.30.136.172 port=48650

[30513-cemdb-admin-2019-06-25 14:08:38.485 CEST]LOG:  connection authorized: user=admin database=cemdb

[30514-[unknown]-[unknown]-2019-06-25 14:08:39.877 CEST]LOG:  connection received: host=172.30.137.197 port=60230

[30514-cemdb-admin-2019-06-25 14:08:39.878 CEST]LOG:  connection authorized: user=admin database=cemdb

[30410-cemdb-admin-2019-06-25 14:08:51.656 CEST]LOG:  duration: 37772.660 ms  execute <unnamed>: select this_.ts_id as ts1_111_0_, this_.version_info as version2_111_0_, this_.ts_transet_id as ts3_111_0_, this_.ts_sequence_number as ts4_111_0_, this_.ts_name as ts5_111_0_, this_.ts_description as ts6_111_0_, this_.ts_collect_trancomp_stats as ts7_111_0_, this_.ts_included as ts8_111_0_, this_.ts_optional as ts9_111_0_, this_.ts_identifying as ts10_111_0_, this_.ts_success_rate_sla as ts11_111_0_, this_.ts_success_sla_inherited as ts12_111_0_, this_.ts_sigma_sla as ts13_111_0_, this_.ts_sigma_sla_inherited as ts14_111_0_, this_.ts_tran_time_sla as ts15_111_0_, this_.ts_tran_time_sla_inherited as ts16_111_0_, this_.ts_soft_delete as ts17_111_0_, (select t1.ts_name from ts_transets t2, ts_transets t1, ts_tranunits tu                where t2.ts_request_base_id = t1.ts_id                and t2.ts_id = tu.ts_transet_id                     and tu.ts_id = this_.ts_id) as formula9_0_ from ts_tranunits this_ where this_.ts_soft_delete=$1 order by this_.ts_name asc

[30410-cemdb-admin-2019-06-25 14:08:51.656 CEST]DETAIL:  parameters: $1 = 'f'

 

Is there a way to fix it ?

Thanks

Environment

Release :

Component : APM Agents

Resolution

Clearing 14K Autodiscovered transactions