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
Release :
Component : APM Agents
Clearing 14K Autodiscovered transactions