pgBadger-
Global information
- Generated on Fri Mar 6 09:01:11 2026
- Log file: ././A3D-RND-PIC/y=2026/m=03/d=05/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2026/m=03/d=05/h=23/m=00/PT1H.log
- Parsed 76,624 log entries in 52s
- Log start from 2026-03-05 00:00:03 to 2026-03-05 23:36:18
-
Overview
Global Stats
- 45 Number of unique normalized queries
- 334 Number of queries
- 33m30s Total query duration
- 2026-03-05 06:33:50 First query
- 2026-03-05 21:32:57 Last query
- 5 queries/s at 2026-03-05 09:11:49 Query peak
- 33m30s Total query duration
- 1m2s Prepare/parse total duration
- 33s151ms Bind total duration
- 31m54s Execute total duration
- 36,266 Number of events
- 14 Number of unique normalized events
- 36,236 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 145 Number temporary file
- 2.52 GiB Max size of temporary file
- 24.49 MiB Average size of temporary file
- 1,089 Total number of sessions
- 30 sessions at 2026-03-05 07:40:40 Session peak
- 3d13h21m25s Total duration of sessions
- 4m42s Average duration of sessions
- 0 Average queries per session
- 1s845ms Average queries duration per session
- 4m40s Average idle time per session
- 1,086 Total number of connections
- 8 connections/s at 2026-03-05 07:40:27 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-03-05 09:11:49 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-05 09:11:49 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-03-05 09:29:06 Date
Queries duration
Key values
- 33m30s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 18 0ms 4s572ms 3s880ms 13s658ms 17s858ms 18s570ms 07 37 0ms 1m34s 14s183ms 59s566ms 1m4s 1m34s 08 119 0ms 15s972ms 4s958ms 21s551ms 45s926ms 2m10s 09 159 0ms 10s449ms 4s487ms 31s319ms 42s617ms 49s792ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 1 0ms 16s477ms 16s477ms 0ms 0ms 16s477ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 05 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 6 12s73ms 0ms 0ms 57s167ms 08 3 0 5s735ms 0ms 0ms 0ms 09 5 0 4s555ms 0ms 0ms 9s742ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 1 0 16s477ms 0ms 0ms 16s477ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 05 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 1 0 33s438ms 0ms 0ms 0ms 08 3 0 5 0 5s841ms 0ms 0ms 5s755ms 09 4 0 0 0 4s579ms 0ms 0ms 4s608ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 18 18.00 0.00% 07 0 3 3.00 0.00% 08 9 119 13.22 7.56% 09 1 159 159.00 0.63% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 05 00 31 0.01/s 01 34 0.01/s 02 20 0.01/s 03 50 0.01/s 04 36 0.01/s 05 31 0.01/s 06 33 0.01/s 07 339 0.09/s 08 40 0.01/s 09 25 0.01/s 10 35 0.01/s 11 44 0.01/s 12 40 0.01/s 13 40 0.01/s 14 44 0.01/s 15 33 0.01/s 16 19 0.01/s 17 17 0.00/s 18 33 0.01/s 19 23 0.01/s 20 40 0.01/s 21 28 0.01/s 22 31 0.01/s 23 20 0.01/s Day Hour Count Average Duration Average idle time Mar 05 00 31 3m55s 3m55s 01 34 2m55s 2m55s 02 20 1m27s 1m27s 03 50 3m14s 3m14s 04 37 2m42s 2m42s 05 30 1m39s 1m39s 06 39 41m34s 41m32s 07 333 13s930ms 12s354ms 08 40 3m44s 3m30s 09 28 4m16s 3m51s 10 35 5m51s 5m51s 11 44 2m37s 2m37s 12 39 2m31s 2m31s 13 41 2m13s 2m13s 14 44 2m26s 2m26s 15 33 2m24s 2m24s 16 19 4m1s 4m1s 17 17 1m13s 1m13s 18 30 45m47s 45m47s 19 26 1m27s 1m27s 20 41 3m30s 3m30s 21 26 2m49s 2m48s 22 32 2m14s 2m14s 23 20 4m45s 4m45s -
Connections
Established Connections
Key values
- 8 connections Connection Peak
- 2026-03-05 07:40:27 Date
Connections per database
Key values
- reftk Main Database
- 1,086 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,086 connections Total
-
Sessions
Simultaneous sessions
Key values
- 30 sessions Session Peak
- 2026-03-05 07:40:40 Date
Histogram of session times
Key values
- 677 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 1,089 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,089 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,089 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 294.67 MiB Temp Files size Peak
- 2026-03-05 07:34:08 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-03-05 07:31:38 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 145 3.47 GiB 24.49 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 9 Total read queries
- 321 Total write queries
Queries by database
Key values
- reftk Main database
- 334 Requests
- 31m54s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 334 Requests
User Request type Count Duration a3dsupervisor Total 334 31m54s copy to 6 1m12s ddl 25 3m58s delete 6 56s988ms insert 7 41s500ms others 4 2m57s select 9 56s459ms tcl 277 21m11s Duration by user
Key values
- 31m54s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 334 31m54s copy to 6 1m12s ddl 25 3m58s delete 6 56s988ms insert 7 41s500ms others 4 2m57s select 9 56s459ms tcl 277 21m11s Queries by host
Key values
- 10.3.0.4 Main host
- 334 Requests
- 31m54s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 300 Requests
- 23m50s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-05 00:55:56 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 314 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m34s VACUUM ANALYZE;[ Date: 2026-03-05 07:38:16 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m4s VACUUM ANALYSE;[ Date: 2026-03-05 07:39:30 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 33s438ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2026-03-05 07:43:44 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 29s571ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2026-03-05 07:34:08 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 29s383ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2026-03-05 07:31:28 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 27s139ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2026-03-05 07:50:18 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 25s609ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2026-03-05 07:33:39 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 21s105ms CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);[ Date: 2026-03-05 07:34:29 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 16s477ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2026-03-05 21:32:57 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 16s86ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2026-03-05 07:35:37 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 15s972ms COMMIT;[ Date: 2026-03-05 08:35:18 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 15s972ms COMMIT;[ Date: 2026-03-05 08:35:18 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 15s908ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-05 07:35:12 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 14s461ms VACUUM FULL GTP_BACKGROUND_TASK;[ Date: 2026-03-05 07:30:50 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 12s487ms CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2026-03-05 07:32:50 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 10s857ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2026-03-05 07:50:29 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 10s449ms COMMIT;[ Date: 2026-03-05 09:39:31 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 10s435ms COMMIT;[ Date: 2026-03-05 09:39:31 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 10s434ms COMMIT;[ Date: 2026-03-05 09:39:31 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 10s97ms insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);[ Date: 2026-03-05 08:35:15 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 21m11s 277 3s3ms 15s972ms 4s590ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 05 07 18 1m9s 3s880ms 08 1 3s64ms 3s64ms 09 108 8m46s 4s871ms 10 150 11m12s 4s483ms [ User: a3dsupervisor - Total duration: 21m11s - Times executed: 277 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21m11s - Times executed: 277 ]
-
COMMIT;
Date: 2026-03-05 08:35:18 Duration: 15s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-05 08:35:18 Duration: 15s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-05 09:39:31 Duration: 10s449ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1m34s 1 1m34s 1m34s 1m34s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 05 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2026-03-05 07:38:16 Duration: 1m34s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m4s 1 1m4s 1m4s 1m4s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 05 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 1 ]
[ Application: psql - Total duration: 1m4s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-05 07:39:30 Duration: 1m4s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 33s438ms 1 33s438ms 33s438ms 33s438ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 05 08 1 33s438ms 33s438ms [ User: a3dsupervisor - Total duration: 33s438ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 33s438ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-05 07:43:44 Duration: 33s438ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 29s571ms 1 29s571ms 29s571ms 29s571ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 05 08 1 29s571ms 29s571ms [ User: a3dsupervisor - Total duration: 29s571ms - Times executed: 1 ]
[ Application: psql - Total duration: 29s571ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-05 07:34:08 Duration: 29s571ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 29s383ms 1 29s383ms 29s383ms 29s383ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 05 08 1 29s383ms 29s383ms [ User: a3dsupervisor - Total duration: 29s383ms - Times executed: 1 ]
[ Application: psql - Total duration: 29s383ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2026-03-05 07:31:28 Duration: 29s383ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 27s464ms 5 3s146ms 10s97ms 5s492ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 05 09 2 13s243ms 6s621ms 10 3 14s221ms 4s740ms [ User: a3dsupervisor - Total duration: 27s464ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s464ms - Times executed: 5 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 08:35:15 Duration: 10s97ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 09:11:49 Duration: 6s4ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 09:15:21 Duration: 4s608ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 27s139ms 1 27s139ms 27s139ms 27s139ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 05 08 1 27s139ms 27s139ms [ User: a3dsupervisor - Total duration: 27s139ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 27s139ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2026-03-05 07:50:18 Duration: 27s139ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 25s609ms 1 25s609ms 25s609ms 25s609ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 05 08 1 25s609ms 25s609ms [ User: a3dsupervisor - Total duration: 25s609ms - Times executed: 1 ]
[ Application: psql - Total duration: 25s609ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-05 07:33:39 Duration: 25s609ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 21s105ms 1 21s105ms 21s105ms 21s105ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 05 08 1 21s105ms 21s105ms [ User: a3dsupervisor - Total duration: 21s105ms - Times executed: 1 ]
[ Application: psql - Total duration: 21s105ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-05 07:34:29 Duration: 21s105ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 17s860ms 3 3s687ms 9s556ms 5s953ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 05 09 2 14s173ms 7s86ms 10 1 3s687ms 3s687ms [ User: a3dsupervisor - Total duration: 17s860ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s860ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 08:35:15 Duration: 9s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 08:35:50 Duration: 4s617ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 09:11:49 Duration: 3s687ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 17s518ms 4 3s58ms 5s755ms 4s379ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 05 09 4 17s518ms 4s379ms [ User: a3dsupervisor - Total duration: 17s518ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s518ms - Times executed: 4 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:34:16 Duration: 5s755ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:39:15 Duration: 5s276ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:09:14 Duration: 3s427ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 16s477ms 1 16s477ms 16s477ms 16s477ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 05 22 1 16s477ms 16s477ms [ User: a3dsupervisor - Total duration: 16s477ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s477ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2026-03-05 21:32:57 Duration: 16s477ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 16s86ms 1 16s86ms 16s86ms 16s86ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 05 08 1 16s86ms 16s86ms [ User: a3dsupervisor - Total duration: 16s86ms - Times executed: 1 ]
[ Application: psql - Total duration: 16s86ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-03-05 07:35:37 Duration: 16s86ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 15s908ms 1 15s908ms 15s908ms 15s908ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 05 08 1 15s908ms 15s908ms [ User: a3dsupervisor - Total duration: 15s908ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s908ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-05 07:35:12 Duration: 15s908ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 14s461ms 1 14s461ms 14s461ms 14s461ms vacuum full gtp_background_task;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 05 08 1 14s461ms 14s461ms [ User: a3dsupervisor - Total duration: 14s461ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s461ms - Times executed: 1 ]
-
VACUUM FULL GTP_BACKGROUND_TASK;
Date: 2026-03-05 07:30:50 Duration: 14s461ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 14s35ms 2 4s98ms 9s936ms 7s17ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 05 09 1 9s936ms 9s936ms 10 1 4s98ms 4s98ms [ User: a3dsupervisor - Total duration: 14s35ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s35ms - Times executed: 2 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2026-03-05 08:35:12 Duration: 9s936ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2026-03-05 09:20:12 Duration: 4s98ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 13s862ms 3 3s472ms 5s873ms 4s620ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 05 10 3 13s862ms 4s620ms [ User: a3dsupervisor - Total duration: 13s862ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s862ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:11:49 Duration: 5s873ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:15:21 Duration: 4s516ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:12:57 Duration: 3s472ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 12s487ms 1 12s487ms 12s487ms 12s487ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 05 08 1 12s487ms 12s487ms [ User: a3dsupervisor - Total duration: 12s487ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s487ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 07:32:50 Duration: 12s487ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 10s857ms 1 10s857ms 10s857ms 10s857ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 05 08 1 10s857ms 10s857ms [ User: a3dsupervisor - Total duration: 10s857ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 10s857ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2026-03-05 07:50:29 Duration: 10s857ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 277 21m11s 3s3ms 15s972ms 4s590ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 05 07 18 1m9s 3s880ms 08 1 3s64ms 3s64ms 09 108 8m46s 4s871ms 10 150 11m12s 4s483ms [ User: a3dsupervisor - Total duration: 21m11s - Times executed: 277 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21m11s - Times executed: 277 ]
-
COMMIT;
Date: 2026-03-05 08:35:18 Duration: 15s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-05 08:35:18 Duration: 15s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-05 09:39:31 Duration: 10s449ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5 27s464ms 3s146ms 10s97ms 5s492ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 05 09 2 13s243ms 6s621ms 10 3 14s221ms 4s740ms [ User: a3dsupervisor - Total duration: 27s464ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s464ms - Times executed: 5 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 08:35:15 Duration: 10s97ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 09:11:49 Duration: 6s4ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 09:15:21 Duration: 4s608ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 4 17s518ms 3s58ms 5s755ms 4s379ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 05 09 4 17s518ms 4s379ms [ User: a3dsupervisor - Total duration: 17s518ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s518ms - Times executed: 4 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:34:16 Duration: 5s755ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:39:15 Duration: 5s276ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:09:14 Duration: 3s427ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 3 17s860ms 3s687ms 9s556ms 5s953ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 05 09 2 14s173ms 7s86ms 10 1 3s687ms 3s687ms [ User: a3dsupervisor - Total duration: 17s860ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s860ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 08:35:15 Duration: 9s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 08:35:50 Duration: 4s617ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 09:11:49 Duration: 3s687ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 3 13s862ms 3s472ms 5s873ms 4s620ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 05 10 3 13s862ms 4s620ms [ User: a3dsupervisor - Total duration: 13s862ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s862ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:11:49 Duration: 5s873ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:15:21 Duration: 4s516ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:12:57 Duration: 3s472ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 2 14s35ms 4s98ms 9s936ms 7s17ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 05 09 1 9s936ms 9s936ms 10 1 4s98ms 4s98ms [ User: a3dsupervisor - Total duration: 14s35ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s35ms - Times executed: 2 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2026-03-05 08:35:12 Duration: 9s936ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2026-03-05 09:20:12 Duration: 4s98ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 2 8s258ms 3s32ms 5s226ms 4s129ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 05 09 1 3s32ms 3s32ms 10 1 5s226ms 5s226ms [ User: a3dsupervisor - Total duration: 8s258ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s258ms - Times executed: 2 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-05 09:15:21 Duration: 5s226ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-05 08:35:41 Duration: 3s32ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1 1m34s 1m34s 1m34s 1m34s vacuum analyze;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 05 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2026-03-05 07:38:16 Duration: 1m34s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1 1m4s 1m4s 1m4s 1m4s vacuum analyse;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 05 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 1 ]
[ Application: psql - Total duration: 1m4s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-05 07:39:30 Duration: 1m4s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1 33s438ms 33s438ms 33s438ms 33s438ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 05 08 1 33s438ms 33s438ms [ User: a3dsupervisor - Total duration: 33s438ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 33s438ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-05 07:43:44 Duration: 33s438ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 1 29s571ms 29s571ms 29s571ms 29s571ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 05 08 1 29s571ms 29s571ms [ User: a3dsupervisor - Total duration: 29s571ms - Times executed: 1 ]
[ Application: psql - Total duration: 29s571ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-05 07:34:08 Duration: 29s571ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1 29s383ms 29s383ms 29s383ms 29s383ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 05 08 1 29s383ms 29s383ms [ User: a3dsupervisor - Total duration: 29s383ms - Times executed: 1 ]
[ Application: psql - Total duration: 29s383ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2026-03-05 07:31:28 Duration: 29s383ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1 27s139ms 27s139ms 27s139ms 27s139ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 05 08 1 27s139ms 27s139ms [ User: a3dsupervisor - Total duration: 27s139ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 27s139ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2026-03-05 07:50:18 Duration: 27s139ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 1 25s609ms 25s609ms 25s609ms 25s609ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 05 08 1 25s609ms 25s609ms [ User: a3dsupervisor - Total duration: 25s609ms - Times executed: 1 ]
[ Application: psql - Total duration: 25s609ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-05 07:33:39 Duration: 25s609ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1 21s105ms 21s105ms 21s105ms 21s105ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 05 08 1 21s105ms 21s105ms [ User: a3dsupervisor - Total duration: 21s105ms - Times executed: 1 ]
[ Application: psql - Total duration: 21s105ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-05 07:34:29 Duration: 21s105ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 1 16s477ms 16s477ms 16s477ms 16s477ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 05 22 1 16s477ms 16s477ms [ User: a3dsupervisor - Total duration: 16s477ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s477ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2026-03-05 21:32:57 Duration: 16s477ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 1 16s86ms 16s86ms 16s86ms 16s86ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 05 08 1 16s86ms 16s86ms [ User: a3dsupervisor - Total duration: 16s86ms - Times executed: 1 ]
[ Application: psql - Total duration: 16s86ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-03-05 07:35:37 Duration: 16s86ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 1 15s908ms 15s908ms 15s908ms 15s908ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 05 08 1 15s908ms 15s908ms [ User: a3dsupervisor - Total duration: 15s908ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s908ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-05 07:35:12 Duration: 15s908ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 1 14s461ms 14s461ms 14s461ms 14s461ms vacuum full gtp_background_task;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 05 08 1 14s461ms 14s461ms [ User: a3dsupervisor - Total duration: 14s461ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s461ms - Times executed: 1 ]
-
VACUUM FULL GTP_BACKGROUND_TASK;
Date: 2026-03-05 07:30:50 Duration: 14s461ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 1 12s487ms 12s487ms 12s487ms 12s487ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 05 08 1 12s487ms 12s487ms [ User: a3dsupervisor - Total duration: 12s487ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s487ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 07:32:50 Duration: 12s487ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m34s 1m34s 1m34s 1 1m34s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 05 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2026-03-05 07:38:16 Duration: 1m34s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m4s 1m4s 1m4s 1 1m4s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 05 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 1 ]
[ Application: psql - Total duration: 1m4s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-05 07:39:30 Duration: 1m4s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 33s438ms 33s438ms 33s438ms 1 33s438ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 05 08 1 33s438ms 33s438ms [ User: a3dsupervisor - Total duration: 33s438ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 33s438ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-05 07:43:44 Duration: 33s438ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 29s571ms 29s571ms 29s571ms 1 29s571ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 05 08 1 29s571ms 29s571ms [ User: a3dsupervisor - Total duration: 29s571ms - Times executed: 1 ]
[ Application: psql - Total duration: 29s571ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-05 07:34:08 Duration: 29s571ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 29s383ms 29s383ms 29s383ms 1 29s383ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 05 08 1 29s383ms 29s383ms [ User: a3dsupervisor - Total duration: 29s383ms - Times executed: 1 ]
[ Application: psql - Total duration: 29s383ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2026-03-05 07:31:28 Duration: 29s383ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 27s139ms 27s139ms 27s139ms 1 27s139ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 05 08 1 27s139ms 27s139ms [ User: a3dsupervisor - Total duration: 27s139ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 27s139ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2026-03-05 07:50:18 Duration: 27s139ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 25s609ms 25s609ms 25s609ms 1 25s609ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 05 08 1 25s609ms 25s609ms [ User: a3dsupervisor - Total duration: 25s609ms - Times executed: 1 ]
[ Application: psql - Total duration: 25s609ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-05 07:33:39 Duration: 25s609ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 21s105ms 21s105ms 21s105ms 1 21s105ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 05 08 1 21s105ms 21s105ms [ User: a3dsupervisor - Total duration: 21s105ms - Times executed: 1 ]
[ Application: psql - Total duration: 21s105ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-05 07:34:29 Duration: 21s105ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 16s477ms 16s477ms 16s477ms 1 16s477ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 05 22 1 16s477ms 16s477ms [ User: a3dsupervisor - Total duration: 16s477ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s477ms - Times executed: 1 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2026-03-05 21:32:57 Duration: 16s477ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 16s86ms 16s86ms 16s86ms 1 16s86ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 05 08 1 16s86ms 16s86ms [ User: a3dsupervisor - Total duration: 16s86ms - Times executed: 1 ]
[ Application: psql - Total duration: 16s86ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-03-05 07:35:37 Duration: 16s86ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 15s908ms 15s908ms 15s908ms 1 15s908ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 05 08 1 15s908ms 15s908ms [ User: a3dsupervisor - Total duration: 15s908ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s908ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-05 07:35:12 Duration: 15s908ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 14s461ms 14s461ms 14s461ms 1 14s461ms vacuum full gtp_background_task;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 05 08 1 14s461ms 14s461ms [ User: a3dsupervisor - Total duration: 14s461ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s461ms - Times executed: 1 ]
-
VACUUM FULL GTP_BACKGROUND_TASK;
Date: 2026-03-05 07:30:50 Duration: 14s461ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 12s487ms 12s487ms 12s487ms 1 12s487ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 05 08 1 12s487ms 12s487ms [ User: a3dsupervisor - Total duration: 12s487ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s487ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 07:32:50 Duration: 12s487ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 10s857ms 10s857ms 10s857ms 1 10s857ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 05 08 1 10s857ms 10s857ms [ User: a3dsupervisor - Total duration: 10s857ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 10s857ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2026-03-05 07:50:29 Duration: 10s857ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 4s98ms 9s936ms 7s17ms 2 14s35ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 05 09 1 9s936ms 9s936ms 10 1 4s98ms 4s98ms [ User: a3dsupervisor - Total duration: 14s35ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s35ms - Times executed: 2 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2026-03-05 08:35:12 Duration: 9s936ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2026-03-05 09:20:12 Duration: 4s98ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 3s687ms 9s556ms 5s953ms 3 17s860ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 05 09 2 14s173ms 7s86ms 10 1 3s687ms 3s687ms [ User: a3dsupervisor - Total duration: 17s860ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s860ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 08:35:15 Duration: 9s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 08:35:50 Duration: 4s617ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 09:11:49 Duration: 3s687ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 3s146ms 10s97ms 5s492ms 5 27s464ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 05 09 2 13s243ms 6s621ms 10 3 14s221ms 4s740ms [ User: a3dsupervisor - Total duration: 27s464ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s464ms - Times executed: 5 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 08:35:15 Duration: 10s97ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 09:11:49 Duration: 6s4ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-05 09:15:21 Duration: 4s608ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 3s472ms 5s873ms 4s620ms 3 13s862ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 05 10 3 13s862ms 4s620ms [ User: a3dsupervisor - Total duration: 13s862ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s862ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:11:49 Duration: 5s873ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:15:21 Duration: 4s516ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2026-03-05 09:12:57 Duration: 3s472ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 3s3ms 15s972ms 4s590ms 277 21m11s commit;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 05 07 18 1m9s 3s880ms 08 1 3s64ms 3s64ms 09 108 8m46s 4s871ms 10 150 11m12s 4s483ms [ User: a3dsupervisor - Total duration: 21m11s - Times executed: 277 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21m11s - Times executed: 277 ]
-
COMMIT;
Date: 2026-03-05 08:35:18 Duration: 15s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-05 08:35:18 Duration: 15s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-05 09:39:31 Duration: 10s449ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 3s58ms 5s755ms 4s379ms 4 17s518ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 05 09 4 17s518ms 4s379ms [ User: a3dsupervisor - Total duration: 17s518ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17s518ms - Times executed: 4 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:34:16 Duration: 5s755ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:39:15 Duration: 5s276ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:09:14 Duration: 3s427ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s169ms 1 5s169ms 5s169ms 5s169ms select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = $1 order by gsbp1_0.SETTING_NUM_ID desc;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Mar 05 10 1 5s169ms 5s169ms [ User: a3dsupervisor - Total duration: 3s687ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s687ms - Times executed: 1 ]
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2026-03-05 09:08:17 Duration: 5s169ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
2 5s98ms 1 5s98ms 5s98ms 5s98ms insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 08 1 5s98ms 5s98ms [ User: a3dsupervisor - Total duration: 3s814ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s814ms - Times executed: 1 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);
Date: 2026-03-05 08:30:08 Duration: 5s98ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
3 3s979ms 1 3s979ms 3s979ms 3s979ms select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 08 1 3s979ms 3s979ms [ User: a3dsupervisor - Total duration: 10s97ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s97ms - Times executed: 1 ]
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2026-03-05 08:34:21 Duration: 3s979ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
4 3s879ms 1 3s879ms 3s879ms 3s879ms select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 08 1 3s879ms 3s879ms [ User: a3dsupervisor - Total duration: 3s782ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s782ms - Times executed: 1 ]
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0;
Date: 2026-03-05 08:16:41 Duration: 3s879ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s605ms 1 5s605ms 5s605ms 5s605ms select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Mar 05 10 1 5s605ms 5s605ms [ User: a3dsupervisor - Total duration: 3s147ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s147ms - Times executed: 1 ]
-
select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);
Date: 2026-03-05 09:08:17 Duration: 5s605ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
2 4s390ms 1 4s390ms 4s390ms 4s390ms delete from GTP_BACKGROUND_TASK task where task.task_service_name = $1 AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = $2 AND task.task_status = 3 order by task_start_date desc LIMIT 10));Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 08 1 4s390ms 4s390ms [ User: a3dsupervisor - Total duration: 3s916ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s916ms - Times executed: 1 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = $1 AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = $2 AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:49:15 Duration: 4s390ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
3 3s936ms 1 3s936ms 3s936ms 3s936ms select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 08 1 3s936ms 3s936ms [ User: a3dsupervisor - Total duration: 10s97ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s97ms - Times executed: 1 ]
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2026-03-05 08:34:25 Duration: 3s936ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
4 3s395ms 1 3s395ms 3s395ms 3s395ms SELECT DISTINCT (OBJ_TEMPLATE_NUM_ID) FROM GTP_NODE_TREE_TYPE WHERE OBJ_TEMPLATE_NUM_ID IS NOT NULL AND VIEW_TEMPLATE_NUM_ID = $1;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 08 1 3s395ms 3s395ms [ User: a3dsupervisor - Total duration: 3s814ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s814ms - Times executed: 1 ]
-
SELECT DISTINCT (OBJ_TEMPLATE_NUM_ID) FROM GTP_NODE_TREE_TYPE WHERE OBJ_TEMPLATE_NUM_ID IS NOT NULL AND VIEW_TEMPLATE_NUM_ID = $1;
Date: 2026-03-05 08:26:32 Duration: 3s395ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
5 3s113ms 1 3s113ms 3s113ms 3s113ms select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 09 1 3s113ms 3s113ms [ User: a3dsupervisor - Total duration: 5s562ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s562ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 09:19:39 Duration: 3s113ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 40,024 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 36250 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 36,236 Max number of times the same event was reported
- 36,266 Total events found
Rank Times reported Error 1 36,236 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 05 01 3,126 02 2,107 03 3,599 04 1,842 05 1,681 06 2,699 07 339 08 49 09 1,177 10 2,267 11 2,245 12 999 13 942 14 1,890 15 7 16 906 17 1,370 18 985 19 443 20 2,291 21 530 22 936 23 1,770 00 2,036 2 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 05 08 16 3 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 05 19 3 4 1 ERROR: duplicate key value violates unique constraint "..." call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID(...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 05 08 1 5 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 05 08 1 6 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 05 08 1 7 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 05 08 1 8 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 05 08 1 9 1 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 05 08 1 10 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 05 08 1 11 1 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #11
Day Hour Count Mar 05 08 1 12 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #12
Day Hour Count Mar 05 08 1 13 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #13
Day Hour Count Mar 05 08 1 14 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #14
Day Hour Count Mar 05 08 1