pgBadger-
Global information
- Generated on Thu Sep 25 09:06:24 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=24/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=24/h=23/m=00/PT1H.log
- Parsed 49,203 log entries in 57s
- Log start from 2025-09-24 00:05:02 to 2025-09-24 10:15:22
-
Overview
Global Stats
- 25 Number of unique normalized queries
- 47 Number of queries
- 7m58s Total query duration
- 2025-09-24 06:23:05 First query
- 2025-09-24 20:33:44 Last query
- 4 queries/s at 2025-09-24 06:51:09 Query peak
- 7m58s Total query duration
- 14s974ms Prepare/parse total duration
- 6s163ms Bind total duration
- 7m36s Execute total duration
- 21,986 Number of events
- 15 Number of unique normalized events
- 20,706 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
- 198 Number temporary file
- 2.29 GiB Max size of temporary file
- 16.46 MiB Average size of temporary file
- 1,648 Total number of sessions
- 30 sessions at 2025-09-24 06:30:00 Session peak
- 4d9h17m44s Total duration of sessions
- 3m50s Average duration of sessions
- 0 Average queries per session
- 290ms Average queries duration per session
- 3m49s Average idle time per session
- 1,644 Total number of connections
- 11 connections/s at 2025-09-24 06:29:48 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-09-24 06:51:09 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-09-24 19:42:49 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-09-24 07:36:21 Date
Queries duration
Key values
- 7m58s 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) Sep 24 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 23 0ms 52s503ms 12s197ms 32s884ms 52s156ms 1m25s 07 10 0ms 7s514ms 6s241ms 0ms 6s95ms 31s861ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 3 0ms 13s808ms 8s744ms 0ms 0ms 26s232ms 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 5 0ms 5s408ms 5s181ms 0ms 5s10ms 15s854ms 19 5 0ms 7s466ms 6s247ms 0ms 6s871ms 24s363ms 20 1 0ms 30s564ms 30s564ms 0ms 0ms 30s564ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 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) Sep 24 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 1 4 10s406ms 0ms 0ms 46s697ms 07 0 0 0ms 0ms 0ms 0ms 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 1 0 5s290ms 0ms 0ms 5s290ms 20 1 0 30s564ms 0ms 0ms 30s564ms 21 0 0 0ms 0ms 0ms 0ms 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) Sep 24 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 1 0 0 0 5s492ms 0ms 0ms 0ms 07 1 0 0 0 6s95ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 1 0 0 13s808ms 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 1 0 0 0 5s334ms 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 Sep 24 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 4 4.00 0.00% 07 2 10 5.00 20.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 3 3.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 5 5.00 0.00% 19 0 5 5.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 24 00 52 0.01/s 01 40 0.01/s 02 64 0.02/s 03 65 0.02/s 04 56 0.02/s 05 37 0.01/s 06 356 0.10/s 07 46 0.01/s 08 70 0.02/s 09 59 0.02/s 10 66 0.02/s 11 56 0.02/s 12 62 0.02/s 13 51 0.01/s 14 73 0.02/s 15 59 0.02/s 16 41 0.01/s 17 37 0.01/s 18 60 0.02/s 19 47 0.01/s 20 69 0.02/s 21 73 0.02/s 22 56 0.02/s 23 49 0.01/s Day Hour Count Average Duration Average idle time Sep 24 00 54 1m30s 1m30s 01 42 1m32s 1m32s 02 64 1m26s 1m26s 03 62 1m23s 1m23s 04 59 1m19s 1m19s 05 40 58m11s 58m11s 06 350 24s694ms 23s892ms 07 49 2m14s 2m13s 08 69 1m57s 1m57s 09 59 1m48s 1m48s 10 66 1m54s 1m53s 11 57 1m24s 1m24s 12 62 1m24s 1m24s 13 51 1m30s 1m30s 14 73 1m19s 1m19s 15 55 1m25s 1m25s 16 45 1m33s 1m33s 17 37 52m30s 52m30s 18 59 1m22s 1m21s 19 48 2m2s 2m2s 20 69 1m28s 1m27s 21 70 1m25s 1m25s 22 59 1m23s 1m23s 23 49 1m27s 1m27s -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-09-24 06:29:48 Date
Connections per database
Key values
- reftk Main Database
- 1,644 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,644 connections Total
-
Sessions
Simultaneous sessions
Key values
- 30 sessions Session Peak
- 2025-09-24 06:30:00 Date
Histogram of session times
Key values
- 1,266 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 1,648 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,648 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,648 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 1,648 sessions Total
Application Count Total Duration Average Duration DBeaver 25.0.5 - Main 'reftk' 2 35m41s 17m50s DBeaver 25.0.5 - Metadata 'reftk' 3 1h5m58s 21m59s DBeaver 25.0.5 - Read PostgreSQL database list 2 1s283ms 641ms DBeaver 25.0.5 - SQLEditor 'Script-10.sql' 1 1m 1m PostgreSQL JDBC Driver 1,281 4d6h38m49s 4m48s [unknown] 67 9s17ms 134ms pg_dump 3 42m20s 14m6s psql 289 13m43s 2s850ms -
Temporary Files
Size of temporary files
Key values
- 207.70 MiB Temp Files size Peak
- 2025-09-24 06:25:03 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-09-24 06:23:53 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 24 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 198 3.18 GiB 16.46 MiB 07 0 0 0 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 Sep 24 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
- 3 Total read queries
- 42 Total write queries
Queries by database
Key values
- reftk Main database
- 47 Requests
- 7m36s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 47 Requests
User Request type Count Duration a3dsupervisor Total 47 7m36s copy to 4 46s697ms ddl 13 2m3s insert 3 16s922ms others 2 1m25s select 3 41s188ms tcl 21 2m8s update 1 13s808ms Duration by user
Key values
- 7m36s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 47 7m36s copy to 4 46s697ms ddl 13 2m3s insert 3 16s922ms others 2 1m25s select 3 41s188ms tcl 21 2m8s update 1 13s808ms Queries by host
Key values
- 10.3.0.4 Main host
- 47 Requests
- 7m36s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 28 Requests
- 3m29s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-24 03:11:58 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 38 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 52s503ms VACUUM ANALYZE;[ Date: 2025-09-24 06:28:03 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 33s106ms VACUUM ANALYSE;[ Date: 2025-09-24 06:28:45 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 30s564ms 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: 2025-09-24 20:33:44 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 20s277ms 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: 2025-09-24 06:38:25 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 18s701ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-24 06:25:51 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 17s645ms 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: 2025-09-24 06:26:16 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 13s808ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');[ Date: 2025-09-24 10:33:54 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 11s 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: 2025-09-24 06:24:25 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 10s301ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2025-09-24 06:25:03 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 9s848ms CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);[ Date: 2025-09-24 06:25:13 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 9s644ms 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: 2025-09-24 06:38:35 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 9s521ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-09-24 06:24:53 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 9s469ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-09-24 06:23:05 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 9s160ms 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: 2025-09-24 06:38:45 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 7s615ms 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: 2025-09-24 06:38:52 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 7s514ms COMMIT;[ Date: 2025-09-24 07:36:00 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 7s466ms COMMIT;[ Date: 2025-09-24 19:42:48 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 7s414ms COMMIT;[ Date: 2025-09-24 07:33:44 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 7s412ms COMMIT;[ Date: 2025-09-24 06:51:09 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 7s355ms COMMIT;[ Date: 2025-09-24 07:36:00 - 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 2m8s 21 5s10ms 7s514ms 6s139ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 08 2 13s682ms 6s841ms 09 9 56s314ms 6s257ms 12 2 12s423ms 6s211ms 20 5 25s905ms 5s181ms 21 3 20s609ms 6s869ms [ User: a3dsupervisor - Total duration: 2m8s - Times executed: 21 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m8s - Times executed: 21 ]
-
COMMIT;
Date: 2025-09-24 07:36:00 Duration: 7s514ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-24 19:42:48 Duration: 7s466ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-24 07:33:44 Duration: 7s414ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 52s503ms 1 52s503ms 52s503ms 52s503ms vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 08 1 52s503ms 52s503ms [ User: a3dsupervisor - Total duration: 52s503ms - Times executed: 1 ]
[ Application: psql - Total duration: 52s503ms - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 06:28:03 Duration: 52s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 33s106ms 1 33s106ms 33s106ms 33s106ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 08 1 33s106ms 33s106ms [ User: a3dsupervisor - Total duration: 33s106ms - Times executed: 1 ]
[ Application: psql - Total duration: 33s106ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 06:28:45 Duration: 33s106ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 30s564ms 1 30s564ms 30s564ms 30s564ms 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 #4
Day Hour Count Duration Avg duration Sep 24 22 1 30s564ms 30s564ms [ User: a3dsupervisor - Total duration: 30s564ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 30s564ms - 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: 2025-09-24 20:33:44 Duration: 30s564ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 20s277ms 1 20s277ms 20s277ms 20s277ms 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 Sep 24 08 1 20s277ms 20s277ms [ User: a3dsupervisor - Total duration: 20s277ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s277ms - 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: 2025-09-24 06:38:25 Duration: 20s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 18s701ms 1 18s701ms 18s701ms 18s701ms 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 Sep 24 08 1 18s701ms 18s701ms [ User: a3dsupervisor - Total duration: 18s701ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s701ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 06:25:51 Duration: 18s701ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 17s645ms 1 17s645ms 17s645ms 17s645ms 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 #7
Day Hour Count Duration Avg duration Sep 24 08 1 17s645ms 17s645ms [ User: a3dsupervisor - Total duration: 17s645ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s645ms - 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: 2025-09-24 06:26:16 Duration: 17s645ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 13s808ms 1 13s808ms 13s808ms 13s808ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 12 1 13s808ms 13s808ms [ User: a3dsupervisor - Total duration: 13s808ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s808ms - Times executed: 1 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-24 10:33:54 Duration: 13s808ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 11s 1 11s 11s 11s 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 #9
Day Hour Count Duration Avg duration Sep 24 08 1 11s 11s [ User: a3dsupervisor - Total duration: 11s - Times executed: 1 ]
[ Application: psql - Total duration: 11s - 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: 2025-09-24 06:24:25 Duration: 11s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 10s827ms 2 5s334ms 5s492ms 5s413ms 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 #10
Day Hour Count Duration Avg duration Sep 24 08 1 5s492ms 5s492ms 21 1 5s334ms 5s334ms [ User: a3dsupervisor - Total duration: 10s827ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s827ms - Times executed: 2 ]
-
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: 2025-09-24 06:51:09 Duration: 5s492ms 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: 2025-09-24 19:42:49 Duration: 5s334ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 10s623ms 2 5s290ms 5s332ms 5s311ms 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 #11
Day Hour Count Duration Avg duration Sep 24 08 1 5s332ms 5s332ms 21 1 5s290ms 5s290ms [ User: a3dsupervisor - Total duration: 10s623ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s623ms - Times executed: 2 ]
-
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: 2025-09-24 06:51:09 Duration: 5s332ms 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: 2025-09-24 19:42:49 Duration: 5s290ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 10s301ms 1 10s301ms 10s301ms 10s301ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 08 1 10s301ms 10s301ms [ User: a3dsupervisor - Total duration: 10s301ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s301ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-24 06:25:03 Duration: 10s301ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 9s848ms 1 9s848ms 9s848ms 9s848ms 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 Sep 24 08 1 9s848ms 9s848ms [ User: a3dsupervisor - Total duration: 9s848ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s848ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-24 06:25:13 Duration: 9s848ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 9s644ms 1 9s644ms 9s644ms 9s644ms 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 Sep 24 08 1 9s644ms 9s644ms [ User: a3dsupervisor - Total duration: 9s644ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s644ms - 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: 2025-09-24 06:38:35 Duration: 9s644ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 9s521ms 1 9s521ms 9s521ms 9s521ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 08 1 9s521ms 9s521ms [ User: a3dsupervisor - Total duration: 9s521ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s521ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 06:24:53 Duration: 9s521ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 9s469ms 1 9s469ms 9s469ms 9s469ms 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 #16
Day Hour Count Duration Avg duration Sep 24 08 1 9s469ms 9s469ms [ User: a3dsupervisor - Total duration: 9s469ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s469ms - 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: 2025-09-24 06:23:05 Duration: 9s469ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 9s160ms 1 9s160ms 9s160ms 9s160ms 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 #17
Day Hour Count Duration Avg duration Sep 24 08 1 9s160ms 9s160ms [ User: a3dsupervisor - Total duration: 9s160ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s160ms - 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: 2025-09-24 06:38:45 Duration: 9s160ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 7s615ms 1 7s615ms 7s615ms 7s615ms 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;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 08 1 7s615ms 7s615ms [ User: a3dsupervisor - Total duration: 7s615ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s615ms - Times executed: 1 ]
-
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: 2025-09-24 06:38:52 Duration: 7s615ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 7s220ms 1 7s220ms 7s220ms 7s220ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 08 1 7s220ms 7s220ms [ User: a3dsupervisor - Total duration: 7s220ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s220ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-24 06:25:30 Duration: 7s220ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 6s598ms 1 6s598ms 6s598ms 6s598ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 08 1 6s598ms 6s598ms [ User: a3dsupervisor - Total duration: 6s598ms - Times executed: 1 ]
[ Application: psql - Total duration: 6s598ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-24 06:24:14 Duration: 6s598ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 21 2m8s 5s10ms 7s514ms 6s139ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 08 2 13s682ms 6s841ms 09 9 56s314ms 6s257ms 12 2 12s423ms 6s211ms 20 5 25s905ms 5s181ms 21 3 20s609ms 6s869ms [ User: a3dsupervisor - Total duration: 2m8s - Times executed: 21 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m8s - Times executed: 21 ]
-
COMMIT;
Date: 2025-09-24 07:36:00 Duration: 7s514ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-24 19:42:48 Duration: 7s466ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-24 07:33:44 Duration: 7s414ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2 10s827ms 5s334ms 5s492ms 5s413ms 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 Sep 24 08 1 5s492ms 5s492ms 21 1 5s334ms 5s334ms [ User: a3dsupervisor - Total duration: 10s827ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s827ms - Times executed: 2 ]
-
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: 2025-09-24 06:51:09 Duration: 5s492ms 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: 2025-09-24 19:42:49 Duration: 5s334ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2 10s623ms 5s290ms 5s332ms 5s311ms 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 #3
Day Hour Count Duration Avg duration Sep 24 08 1 5s332ms 5s332ms 21 1 5s290ms 5s290ms [ User: a3dsupervisor - Total duration: 10s623ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s623ms - Times executed: 2 ]
-
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: 2025-09-24 06:51:09 Duration: 5s332ms 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: 2025-09-24 19:42:49 Duration: 5s290ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 52s503ms 52s503ms 52s503ms 52s503ms vacuum analyze;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 08 1 52s503ms 52s503ms [ User: a3dsupervisor - Total duration: 52s503ms - Times executed: 1 ]
[ Application: psql - Total duration: 52s503ms - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 06:28:03 Duration: 52s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 33s106ms 33s106ms 33s106ms 33s106ms vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 08 1 33s106ms 33s106ms [ User: a3dsupervisor - Total duration: 33s106ms - Times executed: 1 ]
[ Application: psql - Total duration: 33s106ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 06:28:45 Duration: 33s106ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1 30s564ms 30s564ms 30s564ms 30s564ms 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 #6
Day Hour Count Duration Avg duration Sep 24 22 1 30s564ms 30s564ms [ User: a3dsupervisor - Total duration: 30s564ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 30s564ms - 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: 2025-09-24 20:33:44 Duration: 30s564ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 1 20s277ms 20s277ms 20s277ms 20s277ms 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 #7
Day Hour Count Duration Avg duration Sep 24 08 1 20s277ms 20s277ms [ User: a3dsupervisor - Total duration: 20s277ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s277ms - 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: 2025-09-24 06:38:25 Duration: 20s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1 18s701ms 18s701ms 18s701ms 18s701ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 08 1 18s701ms 18s701ms [ User: a3dsupervisor - Total duration: 18s701ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s701ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 06:25:51 Duration: 18s701ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1 17s645ms 17s645ms 17s645ms 17s645ms 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 #9
Day Hour Count Duration Avg duration Sep 24 08 1 17s645ms 17s645ms [ User: a3dsupervisor - Total duration: 17s645ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s645ms - 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: 2025-09-24 06:26:16 Duration: 17s645ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1 13s808ms 13s808ms 13s808ms 13s808ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 12 1 13s808ms 13s808ms [ User: a3dsupervisor - Total duration: 13s808ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s808ms - Times executed: 1 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-24 10:33:54 Duration: 13s808ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 1 11s 11s 11s 11s 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 #11
Day Hour Count Duration Avg duration Sep 24 08 1 11s 11s [ User: a3dsupervisor - Total duration: 11s - Times executed: 1 ]
[ Application: psql - Total duration: 11s - 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: 2025-09-24 06:24:25 Duration: 11s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1 10s301ms 10s301ms 10s301ms 10s301ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 08 1 10s301ms 10s301ms [ User: a3dsupervisor - Total duration: 10s301ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s301ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-24 06:25:03 Duration: 10s301ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1 9s848ms 9s848ms 9s848ms 9s848ms 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 Sep 24 08 1 9s848ms 9s848ms [ User: a3dsupervisor - Total duration: 9s848ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s848ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-24 06:25:13 Duration: 9s848ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1 9s644ms 9s644ms 9s644ms 9s644ms 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 Sep 24 08 1 9s644ms 9s644ms [ User: a3dsupervisor - Total duration: 9s644ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s644ms - 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: 2025-09-24 06:38:35 Duration: 9s644ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 1 9s521ms 9s521ms 9s521ms 9s521ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 08 1 9s521ms 9s521ms [ User: a3dsupervisor - Total duration: 9s521ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s521ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 06:24:53 Duration: 9s521ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 1 9s469ms 9s469ms 9s469ms 9s469ms 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 #16
Day Hour Count Duration Avg duration Sep 24 08 1 9s469ms 9s469ms [ User: a3dsupervisor - Total duration: 9s469ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s469ms - 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: 2025-09-24 06:23:05 Duration: 9s469ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 1 9s160ms 9s160ms 9s160ms 9s160ms 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 #17
Day Hour Count Duration Avg duration Sep 24 08 1 9s160ms 9s160ms [ User: a3dsupervisor - Total duration: 9s160ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s160ms - 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: 2025-09-24 06:38:45 Duration: 9s160ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 1 7s615ms 7s615ms 7s615ms 7s615ms 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;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 08 1 7s615ms 7s615ms [ User: a3dsupervisor - Total duration: 7s615ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s615ms - Times executed: 1 ]
-
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: 2025-09-24 06:38:52 Duration: 7s615ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 1 7s220ms 7s220ms 7s220ms 7s220ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 08 1 7s220ms 7s220ms [ User: a3dsupervisor - Total duration: 7s220ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s220ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-24 06:25:30 Duration: 7s220ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 1 6s598ms 6s598ms 6s598ms 6s598ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 08 1 6s598ms 6s598ms [ User: a3dsupervisor - Total duration: 6s598ms - Times executed: 1 ]
[ Application: psql - Total duration: 6s598ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-24 06:24:14 Duration: 6s598ms 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 52s503ms 52s503ms 52s503ms 1 52s503ms vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 08 1 52s503ms 52s503ms [ User: a3dsupervisor - Total duration: 52s503ms - Times executed: 1 ]
[ Application: psql - Total duration: 52s503ms - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 06:28:03 Duration: 52s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 33s106ms 33s106ms 33s106ms 1 33s106ms vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 08 1 33s106ms 33s106ms [ User: a3dsupervisor - Total duration: 33s106ms - Times executed: 1 ]
[ Application: psql - Total duration: 33s106ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 06:28:45 Duration: 33s106ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 30s564ms 30s564ms 30s564ms 1 30s564ms 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 #3
Day Hour Count Duration Avg duration Sep 24 22 1 30s564ms 30s564ms [ User: a3dsupervisor - Total duration: 30s564ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 30s564ms - 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: 2025-09-24 20:33:44 Duration: 30s564ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 20s277ms 20s277ms 20s277ms 1 20s277ms 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 #4
Day Hour Count Duration Avg duration Sep 24 08 1 20s277ms 20s277ms [ User: a3dsupervisor - Total duration: 20s277ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s277ms - 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: 2025-09-24 06:38:25 Duration: 20s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 18s701ms 18s701ms 18s701ms 1 18s701ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 08 1 18s701ms 18s701ms [ User: a3dsupervisor - Total duration: 18s701ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s701ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 06:25:51 Duration: 18s701ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 17s645ms 17s645ms 17s645ms 1 17s645ms 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 #6
Day Hour Count Duration Avg duration Sep 24 08 1 17s645ms 17s645ms [ User: a3dsupervisor - Total duration: 17s645ms - Times executed: 1 ]
[ Application: psql - Total duration: 17s645ms - 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: 2025-09-24 06:26:16 Duration: 17s645ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 13s808ms 13s808ms 13s808ms 1 13s808ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 12 1 13s808ms 13s808ms [ User: a3dsupervisor - Total duration: 13s808ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s808ms - Times executed: 1 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-24 10:33:54 Duration: 13s808ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 11s 11s 11s 1 11s 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 #8
Day Hour Count Duration Avg duration Sep 24 08 1 11s 11s [ User: a3dsupervisor - Total duration: 11s - Times executed: 1 ]
[ Application: psql - Total duration: 11s - 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: 2025-09-24 06:24:25 Duration: 11s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 10s301ms 10s301ms 10s301ms 1 10s301ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 08 1 10s301ms 10s301ms [ User: a3dsupervisor - Total duration: 10s301ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s301ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-24 06:25:03 Duration: 10s301ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 9s848ms 9s848ms 9s848ms 1 9s848ms 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 Sep 24 08 1 9s848ms 9s848ms [ User: a3dsupervisor - Total duration: 9s848ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s848ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-24 06:25:13 Duration: 9s848ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 9s644ms 9s644ms 9s644ms 1 9s644ms 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 #11
Day Hour Count Duration Avg duration Sep 24 08 1 9s644ms 9s644ms [ User: a3dsupervisor - Total duration: 9s644ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s644ms - 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: 2025-09-24 06:38:35 Duration: 9s644ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 9s521ms 9s521ms 9s521ms 1 9s521ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 08 1 9s521ms 9s521ms [ User: a3dsupervisor - Total duration: 9s521ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s521ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 06:24:53 Duration: 9s521ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 9s469ms 9s469ms 9s469ms 1 9s469ms 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 #13
Day Hour Count Duration Avg duration Sep 24 08 1 9s469ms 9s469ms [ User: a3dsupervisor - Total duration: 9s469ms - Times executed: 1 ]
[ Application: psql - Total duration: 9s469ms - 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: 2025-09-24 06:23:05 Duration: 9s469ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 9s160ms 9s160ms 9s160ms 1 9s160ms 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 #14
Day Hour Count Duration Avg duration Sep 24 08 1 9s160ms 9s160ms [ User: a3dsupervisor - Total duration: 9s160ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s160ms - 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: 2025-09-24 06:38:45 Duration: 9s160ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 7s615ms 7s615ms 7s615ms 1 7s615ms 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;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 08 1 7s615ms 7s615ms [ User: a3dsupervisor - Total duration: 7s615ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s615ms - Times executed: 1 ]
-
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: 2025-09-24 06:38:52 Duration: 7s615ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 7s220ms 7s220ms 7s220ms 1 7s220ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 08 1 7s220ms 7s220ms [ User: a3dsupervisor - Total duration: 7s220ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s220ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-24 06:25:30 Duration: 7s220ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 6s598ms 6s598ms 6s598ms 1 6s598ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 08 1 6s598ms 6s598ms [ User: a3dsupervisor - Total duration: 6s598ms - Times executed: 1 ]
[ Application: psql - Total duration: 6s598ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-24 06:24:14 Duration: 6s598ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5s10ms 7s514ms 6s139ms 21 2m8s commit;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 08 2 13s682ms 6s841ms 09 9 56s314ms 6s257ms 12 2 12s423ms 6s211ms 20 5 25s905ms 5s181ms 21 3 20s609ms 6s869ms [ User: a3dsupervisor - Total duration: 2m8s - Times executed: 21 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m8s - Times executed: 21 ]
-
COMMIT;
Date: 2025-09-24 07:36:00 Duration: 7s514ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-24 19:42:48 Duration: 7s466ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-24 07:33:44 Duration: 7s414ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 5s334ms 5s492ms 5s413ms 2 10s827ms 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 Sep 24 08 1 5s492ms 5s492ms 21 1 5s334ms 5s334ms [ User: a3dsupervisor - Total duration: 10s827ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s827ms - Times executed: 2 ]
-
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: 2025-09-24 06:51:09 Duration: 5s492ms 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: 2025-09-24 19:42:49 Duration: 5s334ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s290ms 5s332ms 5s311ms 2 10s623ms 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 #20
Day Hour Count Duration Avg duration Sep 24 08 1 5s332ms 5s332ms 21 1 5s290ms 5s290ms [ User: a3dsupervisor - Total duration: 10s623ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s623ms - Times executed: 2 ]
-
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: 2025-09-24 06:51:09 Duration: 5s332ms 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: 2025-09-24 19:42:49 Duration: 5s290ms 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
- 27,170 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 21970 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 20,706 Max number of times the same event was reported
- 21,986 Total events found
Rank Times reported Error 1 20,706 ERROR: operator does not exist: smallint = character varying
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 24 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 2,706 2 1,243 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 24 08 100 09 228 10 754 11 135 12 26 3 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 24 08 16 4 7 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 24 10 3 11 1 19 3 5 3 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 24 08 2 15 1 6 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 24 08 1 10 1 7 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 24 08 1 8 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 #8
Day Hour Count Sep 24 08 1 9 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 #9
Day Hour Count Sep 24 08 1 10 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 #10
Day Hour Count Sep 24 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 Sep 24 08 1 12 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 #12
Day Hour Count Sep 24 08 1 13 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 24 08 1 14 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 #14
Day Hour Count Sep 24 08 1 15 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 24 08 1