pgBadger-
Global information
- Generated on Thu Mar 5 09:01:11 2026
- Log file: ././A3D-RND-PIC/y=2026/m=03/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2026/m=03/d=04/h=23/m=00/PT1H.log
- Parsed 74,897 log entries in 52s
- Log start from 2026-03-04 00:00:02 to 2026-03-04 23:59:58
-
Overview
Global Stats
- 43 Number of unique normalized queries
- 166 Number of queries
- 17m49s Total query duration
- 2026-03-04 06:33:57 First query
- 2026-03-04 21:33:28 Last query
- 4 queries/s at 2026-03-04 06:34:29 Query peak
- 17m49s Total query duration
- 4s595ms Prepare/parse total duration
- 0ms Bind total duration
- 17m44s Execute total duration
- 35,290 Number of events
- 17 Number of unique normalized events
- 35,256 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
- 144 Number temporary file
- 2.52 GiB Max size of temporary file
- 24.64 MiB Average size of temporary file
- 1,279 Total number of sessions
- 28 sessions at 2026-03-04 08:55:42 Session peak
- 3d17h17m36s Total duration of sessions
- 4m11s Average duration of sessions
- 0 Average queries per session
- 836ms Average queries duration per session
- 4m10s Average idle time per session
- 1,279 Total number of connections
- 9 connections/s at 2026-03-04 07:38:23 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-03-04 06:34:29 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-04 06:36:57 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-03-04 06:34:29 Date
Queries duration
Key values
- 17m49s 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 04 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 20 0ms 5s988ms 3s814ms 9s446ms 19s977ms 25s635ms 07 36 0ms 1m40s 14s338ms 56s847ms 1m2s 1m40s 08 54 0ms 8s146ms 4s67ms 15s470ms 23s812ms 26s287ms 09 55 0ms 7s972ms 4s317ms 18s695ms 21s661ms 58s320ms 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 15s148ms 15s148ms 0ms 0ms 15s148ms 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 04 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 2 0 3s324ms 0ms 0ms 3s458ms 07 0 6 11s291ms 0ms 0ms 1m2s 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 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 15s148ms 0ms 0ms 15s148ms 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 04 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 1 0 3s191ms 0ms 0ms 0ms 07 0 0 1 0 35s622ms 0ms 0ms 0ms 08 4 0 1 0 3s590ms 0ms 0ms 4s80ms 09 1 0 2 0 3s682ms 0ms 0ms 3s502ms 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 04 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 20 20.00 0.00% 07 0 1 1.00 0.00% 08 0 54 54.00 0.00% 09 1 55 55.00 1.82% 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 04 00 22 0.01/s 01 44 0.01/s 02 28 0.01/s 03 35 0.01/s 04 41 0.01/s 05 37 0.01/s 06 26 0.01/s 07 352 0.10/s 08 48 0.01/s 09 28 0.01/s 10 36 0.01/s 11 49 0.01/s 12 44 0.01/s 13 61 0.02/s 14 46 0.01/s 15 41 0.01/s 16 48 0.01/s 17 51 0.01/s 18 15 0.00/s 19 48 0.01/s 20 45 0.01/s 21 54 0.01/s 22 46 0.01/s 23 34 0.01/s Day Hour Count Average Duration Average idle time Mar 04 00 23 4m32s 4m32s 01 43 2m24s 2m24s 02 28 2m12s 2m12s 03 35 3m36s 3m36s 04 41 2m23s 2m23s 05 37 2m7s 2m7s 06 29 54m27s 54m24s 07 349 22s809ms 21s330ms 08 47 1m53s 1m49s 09 27 4m58s 4m49s 10 36 5m47s 5m47s 11 48 2m38s 2m38s 12 47 2m44s 2m44s 13 61 1m58s 1m58s 14 46 3m10s 3m10s 15 41 2m35s 2m35s 16 48 2m21s 2m21s 17 51 2m36s 2m36s 18 15 1h24m21s 1h24m21s 19 48 2m43s 2m43s 20 45 2m4s 2m4s 21 54 2m2s 2m1s 22 47 2m17s 2m17s 23 33 1m46s 1m46s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-03-04 07:38:23 Date
Connections per database
Key values
- reftk Main Database
- 1,279 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,279 connections Total
-
Sessions
Simultaneous sessions
Key values
- 28 sessions Session Peak
- 2026-03-04 08:55:42 Date
Histogram of session times
Key values
- 894 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 1,279 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,279 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,279 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 293.55 MiB Temp Files size Peak
- 2026-03-04 07:32:07 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-03-04 07:29:18 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 04 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 144 3.46 GiB 24.64 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 04 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
- AccessExclusiveLock Main Lock Type
- 3 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
- 3 Total read queries
- 160 Total write queries
Queries by database
Key values
- reftk Main database
- 166 Requests
- 17m44s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 166 Requests
User Request type Count Duration a3dsupervisor Total 166 17m44s copy to 6 1m7s ddl 26 4m2s delete 5 49s627ms insert 5 18s188ms others 3 2m50s select 3 21s797ms tcl 118 8m14s Duration by user
Key values
- 17m44s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 166 17m44s copy to 6 1m7s ddl 26 4m2s delete 5 49s627ms insert 5 18s188ms others 3 2m50s select 3 21s797ms tcl 118 8m14s Queries by host
Key values
- 10.3.0.4 Main host
- 166 Requests
- 17m44s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 131 Requests
- 9m44s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-04 00:02:12 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 152 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m40s VACUUM ANALYZE;[ Date: 2026-03-04 07:36:28 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m2s VACUUM ANALYSE;[ Date: 2026-03-04 07:37:37 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 40s669ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2026-03-04 07:31:46 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 35s622ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2026-03-04 07:41:31 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 25s503ms 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-04 07:47:16 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 22s103ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-04 07:33:15 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 20s729ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2026-03-04 07:32:07 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 15s963ms ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-04 07:32:49 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 15s148ms 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-04 21:33:28 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 14s556ms 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-04 07:30:43 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 12s647ms 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-04 07:33:41 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 12s427ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-03-04 07:33:28 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 12s419ms CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);[ Date: 2026-03-04 07:32:20 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 10s86ms 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-04 07:47:26 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 9s830ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2026-03-04 07:29:03 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 9s284ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2026-03-04 07:47:36 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 8s892ms COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;[ Date: 2026-03-04 07:47:55 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 8s696ms COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2026-03-04 07:47:46 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 8s146ms COMMIT;[ Date: 2026-03-04 08:43:28 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 7s996ms COMMIT;[ Date: 2026-03-04 08:43:28 - 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 8m14s 118 3s6ms 8s146ms 4s191ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 04 07 17 1m6s 3s908ms 09 49 3m21s 4s116ms 10 52 3m46s 4s354ms [ User: a3dsupervisor - Total duration: 8m14s - Times executed: 118 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m14s - Times executed: 118 ]
-
COMMIT;
Date: 2026-03-04 08:43:28 Duration: 8s146ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-04 08:43:28 Duration: 7s996ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-04 09:34:39 Duration: 7s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1m40s 1 1m40s 1m40s 1m40s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 04 08 1 1m40s 1m40s [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 1 ]
[ Application: psql - Total duration: 1m40s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2026-03-04 07:36:28 Duration: 1m40s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m2s 1 1m2s 1m2s 1m2s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 04 08 1 1m2s 1m2s [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 1 ]
[ Application: psql - Total duration: 1m2s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-04 07:37:37 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 40s669ms 1 40s669ms 40s669ms 40s669ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 04 08 1 40s669ms 40s669ms [ User: a3dsupervisor - Total duration: 40s669ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s669ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-04 07:31:46 Duration: 40s669ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 35s622ms 1 35s622ms 35s622ms 35s622ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 04 08 1 35s622ms 35s622ms [ User: a3dsupervisor - Total duration: 35s622ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s622ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-04 07:41:31 Duration: 35s622ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 25s503ms 1 25s503ms 25s503ms 25s503ms 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 04 08 1 25s503ms 25s503ms [ User: a3dsupervisor - Total duration: 25s503ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 25s503ms - 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-04 07:47:16 Duration: 25s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 22s103ms 1 22s103ms 22s103ms 22s103ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 04 08 1 22s103ms 22s103ms [ User: a3dsupervisor - Total duration: 22s103ms - Times executed: 1 ]
[ Application: psql - Total duration: 22s103ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 07:33:15 Duration: 22s103ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 20s729ms 1 20s729ms 20s729ms 20s729ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 04 08 1 20s729ms 20s729ms [ User: a3dsupervisor - Total duration: 20s729ms - Times executed: 1 ]
[ Application: psql - Total duration: 20s729ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-04 07:32:07 Duration: 20s729ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 18s188ms 5 3s111ms 4s80ms 3s637ms 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 #9
Day Hour Count Duration Avg duration Mar 04 09 4 14s281ms 3s570ms 10 1 3s907ms 3s907ms [ User: a3dsupervisor - Total duration: 18s188ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s188ms - 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-04 08:48:07 Duration: 4s80ms 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-04 09:34:48 Duration: 3s907ms 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-04 08:42:36 Duration: 3s548ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 15s963ms 1 15s963ms 15s963ms 15s963ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 04 08 1 15s963ms 15s963ms [ User: a3dsupervisor - Total duration: 15s963ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s963ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-04 07:32:49 Duration: 15s963ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 15s148ms 1 15s148ms 15s148ms 15s148ms 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 #11
Day Hour Count Duration Avg duration Mar 04 22 1 15s148ms 15s148ms [ User: a3dsupervisor - Total duration: 15s148ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s148ms - 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-04 21:33:28 Duration: 15s148ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 14s556ms 1 14s556ms 14s556ms 14s556ms 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 #12
Day Hour Count Duration Avg duration Mar 04 08 1 14s556ms 14s556ms [ User: a3dsupervisor - Total duration: 14s556ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s556ms - 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-04 07:30:43 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 12s647ms 1 12s647ms 12s647ms 12s647ms 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 #13
Day Hour Count Duration Avg duration Mar 04 08 1 12s647ms 12s647ms [ User: a3dsupervisor - Total duration: 12s647ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s647ms - 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-04 07:33:41 Duration: 12s647ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 12s427ms 1 12s427ms 12s427ms 12s427ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 04 08 1 12s427ms 12s427ms [ User: a3dsupervisor - Total duration: 12s427ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s427ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-03-04 07:33:28 Duration: 12s427ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 12s419ms 1 12s419ms 12s419ms 12s419ms 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 04 08 1 12s419ms 12s419ms [ User: a3dsupervisor - Total duration: 12s419ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s419ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-04 07:32:20 Duration: 12s419ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 10s813ms 3 3s502ms 3s673ms 3s604ms 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 #16
Day Hour Count Duration Avg duration Mar 04 09 1 3s673ms 3s673ms 10 2 7s140ms 3s570ms [ User: a3dsupervisor - Total duration: 10s813ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s813ms - Times executed: 3 ]
-
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-04 08:16:58 Duration: 3s673ms 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-04 09:12:02 Duration: 3s637ms 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-04 09:36:58 Duration: 3s502ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 10s86ms 1 10s86ms 10s86ms 10s86ms 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 #17
Day Hour Count Duration Avg duration Mar 04 08 1 10s86ms 10s86ms [ User: a3dsupervisor - Total duration: 10s86ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 10s86ms - 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-04 07:47:26 Duration: 10s86ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 9s830ms 1 9s830ms 9s830ms 9s830ms 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 #18
Day Hour Count Duration Avg duration Mar 04 08 1 9s830ms 9s830ms [ User: a3dsupervisor - Total duration: 9s830ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s830ms - 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-04 07:29:03 Duration: 9s830ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 9s284ms 1 9s284ms 9s284ms 9s284ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 04 08 1 9s284ms 9s284ms [ User: a3dsupervisor - Total duration: 9s284ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s284ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2026-03-04 07:47:36 Duration: 9s284ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 8s892ms 1 8s892ms 8s892ms 8s892ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 04 08 1 8s892ms 8s892ms [ User: a3dsupervisor - Total duration: 8s892ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s892ms - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-04 07:47:55 Duration: 8s892ms 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 118 8m14s 3s6ms 8s146ms 4s191ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 04 07 17 1m6s 3s908ms 09 49 3m21s 4s116ms 10 52 3m46s 4s354ms [ User: a3dsupervisor - Total duration: 8m14s - Times executed: 118 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m14s - Times executed: 118 ]
-
COMMIT;
Date: 2026-03-04 08:43:28 Duration: 8s146ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-04 08:43:28 Duration: 7s996ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-04 09:34:39 Duration: 7s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5 18s188ms 3s111ms 4s80ms 3s637ms 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 04 09 4 14s281ms 3s570ms 10 1 3s907ms 3s907ms [ User: a3dsupervisor - Total duration: 18s188ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s188ms - 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-04 08:48:07 Duration: 4s80ms 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-04 09:34:48 Duration: 3s907ms 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-04 08:42:36 Duration: 3s548ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 3 10s813ms 3s502ms 3s673ms 3s604ms 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 04 09 1 3s673ms 3s673ms 10 2 7s140ms 3s570ms [ User: a3dsupervisor - Total duration: 10s813ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s813ms - Times executed: 3 ]
-
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-04 08:16:58 Duration: 3s673ms 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-04 09:12:02 Duration: 3s637ms 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-04 09:36:58 Duration: 3s502ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 1m40s 1m40s 1m40s 1m40s vacuum analyze;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 04 08 1 1m40s 1m40s [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 1 ]
[ Application: psql - Total duration: 1m40s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2026-03-04 07:36:28 Duration: 1m40s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 1m2s 1m2s 1m2s 1m2s vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 04 08 1 1m2s 1m2s [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 1 ]
[ Application: psql - Total duration: 1m2s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-04 07:37:37 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1 40s669ms 40s669ms 40s669ms 40s669ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 04 08 1 40s669ms 40s669ms [ User: a3dsupervisor - Total duration: 40s669ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s669ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-04 07:31:46 Duration: 40s669ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1 35s622ms 35s622ms 35s622ms 35s622ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 04 08 1 35s622ms 35s622ms [ User: a3dsupervisor - Total duration: 35s622ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s622ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-04 07:41:31 Duration: 35s622ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1 25s503ms 25s503ms 25s503ms 25s503ms 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 04 08 1 25s503ms 25s503ms [ User: a3dsupervisor - Total duration: 25s503ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 25s503ms - 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-04 07:47:16 Duration: 25s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1 22s103ms 22s103ms 22s103ms 22s103ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 04 08 1 22s103ms 22s103ms [ User: a3dsupervisor - Total duration: 22s103ms - Times executed: 1 ]
[ Application: psql - Total duration: 22s103ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 07:33:15 Duration: 22s103ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1 20s729ms 20s729ms 20s729ms 20s729ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 04 08 1 20s729ms 20s729ms [ User: a3dsupervisor - Total duration: 20s729ms - Times executed: 1 ]
[ Application: psql - Total duration: 20s729ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-04 07:32:07 Duration: 20s729ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1 15s963ms 15s963ms 15s963ms 15s963ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 04 08 1 15s963ms 15s963ms [ User: a3dsupervisor - Total duration: 15s963ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s963ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-04 07:32:49 Duration: 15s963ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1 15s148ms 15s148ms 15s148ms 15s148ms 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 #12
Day Hour Count Duration Avg duration Mar 04 22 1 15s148ms 15s148ms [ User: a3dsupervisor - Total duration: 15s148ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s148ms - 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-04 21:33:28 Duration: 15s148ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 1 14s556ms 14s556ms 14s556ms 14s556ms 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 04 08 1 14s556ms 14s556ms [ User: a3dsupervisor - Total duration: 14s556ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s556ms - 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-04 07:30:43 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1 12s647ms 12s647ms 12s647ms 12s647ms 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 04 08 1 12s647ms 12s647ms [ User: a3dsupervisor - Total duration: 12s647ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s647ms - 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-04 07:33:41 Duration: 12s647ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1 12s427ms 12s427ms 12s427ms 12s427ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 04 08 1 12s427ms 12s427ms [ User: a3dsupervisor - Total duration: 12s427ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s427ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-03-04 07:33:28 Duration: 12s427ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 1 12s419ms 12s419ms 12s419ms 12s419ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 04 08 1 12s419ms 12s419ms [ User: a3dsupervisor - Total duration: 12s419ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s419ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-04 07:32:20 Duration: 12s419ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 1 10s86ms 10s86ms 10s86ms 10s86ms 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 #17
Day Hour Count Duration Avg duration Mar 04 08 1 10s86ms 10s86ms [ User: a3dsupervisor - Total duration: 10s86ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 10s86ms - 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-04 07:47:26 Duration: 10s86ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 1 9s830ms 9s830ms 9s830ms 9s830ms 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 #18
Day Hour Count Duration Avg duration Mar 04 08 1 9s830ms 9s830ms [ User: a3dsupervisor - Total duration: 9s830ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s830ms - 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-04 07:29:03 Duration: 9s830ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 1 9s284ms 9s284ms 9s284ms 9s284ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 04 08 1 9s284ms 9s284ms [ User: a3dsupervisor - Total duration: 9s284ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s284ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2026-03-04 07:47:36 Duration: 9s284ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 1 8s892ms 8s892ms 8s892ms 8s892ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 04 08 1 8s892ms 8s892ms [ User: a3dsupervisor - Total duration: 8s892ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s892ms - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-04 07:47:55 Duration: 8s892ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m40s 1m40s 1m40s 1 1m40s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 04 08 1 1m40s 1m40s [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 1 ]
[ Application: psql - Total duration: 1m40s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2026-03-04 07:36:28 Duration: 1m40s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m2s 1m2s 1m2s 1 1m2s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 04 08 1 1m2s 1m2s [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 1 ]
[ Application: psql - Total duration: 1m2s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-04 07:37:37 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 40s669ms 40s669ms 40s669ms 1 40s669ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 04 08 1 40s669ms 40s669ms [ User: a3dsupervisor - Total duration: 40s669ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s669ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-04 07:31:46 Duration: 40s669ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 35s622ms 35s622ms 35s622ms 1 35s622ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 04 08 1 35s622ms 35s622ms [ User: a3dsupervisor - Total duration: 35s622ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s622ms - Times executed: 1 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-04 07:41:31 Duration: 35s622ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 25s503ms 25s503ms 25s503ms 1 25s503ms 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 #5
Day Hour Count Duration Avg duration Mar 04 08 1 25s503ms 25s503ms [ User: a3dsupervisor - Total duration: 25s503ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 25s503ms - 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-04 07:47:16 Duration: 25s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 22s103ms 22s103ms 22s103ms 1 22s103ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 04 08 1 22s103ms 22s103ms [ User: a3dsupervisor - Total duration: 22s103ms - Times executed: 1 ]
[ Application: psql - Total duration: 22s103ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 07:33:15 Duration: 22s103ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 20s729ms 20s729ms 20s729ms 1 20s729ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 04 08 1 20s729ms 20s729ms [ User: a3dsupervisor - Total duration: 20s729ms - Times executed: 1 ]
[ Application: psql - Total duration: 20s729ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-04 07:32:07 Duration: 20s729ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 15s963ms 15s963ms 15s963ms 1 15s963ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 04 08 1 15s963ms 15s963ms [ User: a3dsupervisor - Total duration: 15s963ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s963ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-04 07:32:49 Duration: 15s963ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 15s148ms 15s148ms 15s148ms 1 15s148ms 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 04 22 1 15s148ms 15s148ms [ User: a3dsupervisor - Total duration: 15s148ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s148ms - 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-04 21:33:28 Duration: 15s148ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 14s556ms 14s556ms 14s556ms 1 14s556ms 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 #10
Day Hour Count Duration Avg duration Mar 04 08 1 14s556ms 14s556ms [ User: a3dsupervisor - Total duration: 14s556ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s556ms - 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-04 07:30:43 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 12s647ms 12s647ms 12s647ms 1 12s647ms 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 #11
Day Hour Count Duration Avg duration Mar 04 08 1 12s647ms 12s647ms [ User: a3dsupervisor - Total duration: 12s647ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s647ms - 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-04 07:33:41 Duration: 12s647ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 12s427ms 12s427ms 12s427ms 1 12s427ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 04 08 1 12s427ms 12s427ms [ User: a3dsupervisor - Total duration: 12s427ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s427ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-03-04 07:33:28 Duration: 12s427ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 12s419ms 12s419ms 12s419ms 1 12s419ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 04 08 1 12s419ms 12s419ms [ User: a3dsupervisor - Total duration: 12s419ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s419ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-04 07:32:20 Duration: 12s419ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 10s86ms 10s86ms 10s86ms 1 10s86ms 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 04 08 1 10s86ms 10s86ms [ User: a3dsupervisor - Total duration: 10s86ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 10s86ms - 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-04 07:47:26 Duration: 10s86ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 9s830ms 9s830ms 9s830ms 1 9s830ms 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 #15
Day Hour Count Duration Avg duration Mar 04 08 1 9s830ms 9s830ms [ User: a3dsupervisor - Total duration: 9s830ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s830ms - 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-04 07:29:03 Duration: 9s830ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 9s284ms 9s284ms 9s284ms 1 9s284ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 04 08 1 9s284ms 9s284ms [ User: a3dsupervisor - Total duration: 9s284ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s284ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2026-03-04 07:47:36 Duration: 9s284ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 8s892ms 8s892ms 8s892ms 1 8s892ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 04 08 1 8s892ms 8s892ms [ User: a3dsupervisor - Total duration: 8s892ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s892ms - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-04 07:47:55 Duration: 8s892ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 3s6ms 8s146ms 4s191ms 118 8m14s commit;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 04 07 17 1m6s 3s908ms 09 49 3m21s 4s116ms 10 52 3m46s 4s354ms [ User: a3dsupervisor - Total duration: 8m14s - Times executed: 118 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m14s - Times executed: 118 ]
-
COMMIT;
Date: 2026-03-04 08:43:28 Duration: 8s146ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-04 08:43:28 Duration: 7s996ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-04 09:34:39 Duration: 7s972ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 3s111ms 4s80ms 3s637ms 5 18s188ms 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 #19
Day Hour Count Duration Avg duration Mar 04 09 4 14s281ms 3s570ms 10 1 3s907ms 3s907ms [ User: a3dsupervisor - Total duration: 18s188ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s188ms - 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-04 08:48:07 Duration: 4s80ms 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-04 09:34:48 Duration: 3s907ms 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-04 08:42:36 Duration: 3s548ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 3s502ms 3s673ms 3s604ms 3 10s813ms 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 04 09 1 3s673ms 3s673ms 10 2 7s140ms 3s570ms [ User: a3dsupervisor - Total duration: 10s813ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s813ms - Times executed: 3 ]
-
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-04 08:16:58 Duration: 3s673ms 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-04 09:12:02 Duration: 3s637ms 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-04 09:36:58 Duration: 3s502ms 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 NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 39,441 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 35274 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 35,256 Max number of times the same event was reported
- 35,290 Total events found
Rank Times reported Error 1 35,256 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 04 01 3,320 02 2,391 03 2,271 04 2,754 05 1,380 06 1,143 07 1,791 08 49 09 956 10 2,834 11 1,344 12 1,475 13 906 14 2,353 15 13 16 910 17 464 18 2,144 19 1,568 20 326 21 264 22 940 23 1,861 00 1,799 2 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 04 08 16 3 4 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 04 19 4 4 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 04 08 1 5 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 #5
Day Hour Count Mar 04 08 1 6 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (...)
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 04 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 04 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 04 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 04 08 1 10 1 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... msinsert into APPLICATIVE_LOCK (...) values (...)
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 04 09 1 11 1 ERROR: duplicate key value violates unique constraint "..." call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID(...)
Times Reported Most Frequent Error / Event #11
Day Hour Count Mar 04 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 04 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 04 08 1 14 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (...)
Times Reported Most Frequent Error / Event #14
Day Hour Count Mar 04 08 1 15 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 #15
Day Hour Count Mar 04 08 1 16 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #16
Day Hour Count Mar 04 08 1 17 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #17
Day Hour Count Mar 04 08 1