pgBadger-
Global information
- Generated on Wed Oct 22 09:06:32 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=21/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=21/h=23/m=00/PT1H.log
- Parsed 11,769 log entries in 1m
- Log start from 2025-10-21 06:12:18 to 2025-10-21 23:58:14
-
Overview
Global Stats
- 26 Number of unique normalized queries
- 31 Number of queries
- 7m47s Total query duration
- 2025-10-21 06:20:56 First query
- 2025-10-21 20:33:38 Last query
- 3 queries/s at 2025-10-21 19:46:23 Query peak
- 7m47s Total query duration
- 9s500ms Prepare/parse total duration
- 32s673ms Bind total duration
- 7m4s Execute total duration
- 3,004 Number of events
- 17 Number of unique normalized events
- 2,928 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
- 204 Number temporary file
- 2.37 GiB Max size of temporary file
- 16.53 MiB Average size of temporary file
- 1,824 Total number of sessions
- 30 sessions at 2025-10-21 06:28:01 Session peak
- 6d1h30m26s Total duration of sessions
- 4m47s Average duration of sessions
- 0 Average queries per session
- 256ms Average queries duration per session
- 4m46s Average idle time per session
- 1,824 Total number of connections
- 10 connections/s at 2025-10-21 06:27:49 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-21 19:46:23 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-21 20:33:38 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-21 18:32:04 Date
Queries duration
Key values
- 7m47s 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) Oct 21 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 21 0ms 52s916ms 16s13ms 35s9ms 53s279ms 1m33s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 1 0ms 16s158ms 16s158ms 0ms 0ms 16s158ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 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 1 0ms 5s59ms 5s59ms 0ms 0ms 5s59ms 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 4 0ms 5s779ms 5s507ms 0ms 0ms 22s28ms 19 3 0ms 5s9ms 5s7ms 0ms 0ms 15s21ms 20 1 0ms 30s413ms 30s413ms 0ms 0ms 30s413ms 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) Oct 21 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 4 22s635ms 0ms 0ms 1m1s 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 1 0 5s59ms 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 5s2ms 0ms 0ms 5s2ms 20 1 0 30s413ms 0ms 0ms 30s413ms 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) Oct 21 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 10s204ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 16s158ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 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 2 0 0 0 5s9ms 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 Oct 21 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 1 1 1.00 5.26% 07 0 0 0.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 1 1.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 4 4.00 0.00% 19 0 3 3.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 Oct 21 00 44 0.01/s 01 31 0.01/s 02 52 0.01/s 03 49 0.01/s 04 42 0.01/s 05 35 0.01/s 06 361 0.10/s 07 56 0.02/s 08 104 0.03/s 09 127 0.04/s 10 87 0.02/s 11 52 0.01/s 12 126 0.04/s 13 108 0.03/s 14 50 0.01/s 15 59 0.02/s 16 90 0.03/s 17 34 0.01/s 18 44 0.01/s 19 60 0.02/s 20 59 0.02/s 21 55 0.02/s 22 48 0.01/s 23 51 0.01/s Day Hour Count Average Duration Average idle time Oct 21 00 38 1m12s 1m12s 01 37 1m14s 1m14s 02 52 1m15s 1m15s 03 49 1m14s 1m14s 04 42 1m10s 1m10s 05 38 1h6s 1h6s 06 354 26s671ms 25s721ms 07 58 1m51s 1m51s 08 96 1m26s 1m26s 09 127 1m26s 1m26s 10 97 7m15s 7m15s 11 47 1m16s 1m16s 12 127 2m19s 2m19s 13 107 2m51s 2m51s 14 55 8m56s 8m56s 15 59 1m16s 1m16s 16 90 1m17s 1m17s 17 31 1h2m4s 1h2m4s 18 43 1m29s 1m29s 19 64 1m26s 1m26s 20 59 1m20s 1m19s 21 55 1m20s 1m20s 22 48 1m19s 1m19s 23 51 24m23s 24m23s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-10-21 06:27:49 Date
Connections per database
Key values
- reftk Main Database
- 1,824 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,824 connections Total
-
Sessions
Simultaneous sessions
Key values
- 30 sessions Session Peak
- 2025-10-21 06:28:01 Date
Histogram of session times
Key values
- 1,406 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 1,824 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,824 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,824 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 1,824 sessions Total
Application Count Total Duration Average Duration DBeaver 25.0.5 - Main 'reftk' 2 5h1m40s 2h30m50s DBeaver 25.0.5 - Metadata 'reftk' 2 5h1m18s 2h30m39s DBeaver 25.0.5 - Read PostgreSQL database list 2 1s331ms 665ms IntelliJ IDEA 2025.2.3 1 11s185ms 11s185ms PostgreSQL JDBC Driver 1,455 5d14h25m31s 5m32s [unknown] 70 6s621ms 94ms pg_dump 3 47m27s 15m49s psql 289 14m9s 2s939ms -
Temporary Files
Size of temporary files
Key values
- 237.52 MiB Temp Files size Peak
- 2025-10-21 06:23:01 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-10-21 06:21:41 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 21 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 200 3.28 GiB 16.77 MiB 07 0 0 0 08 1 4.33 MiB 4.33 MiB 09 0 0 0 10 0 0 0 11 1 4.33 MiB 4.33 MiB 12 2 8.66 MiB 4.33 MiB 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 Oct 21 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
- 26 Total write queries
Queries by database
Key values
- reftk Main database
- 31 Requests
- 7m4s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 31 Requests
User Request type Count Duration a3dsupervisor Total 31 7m4s copy to 4 1m30s ddl 14 2m21s delete 2 26s362ms insert 2 10s18ms others 2 1m33s select 3 40s475ms tcl 4 22s28ms Duration by user
Key values
- 7m4s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 31 7m4s copy to 4 1m30s ddl 14 2m21s delete 2 26s362ms insert 2 10s18ms others 2 1m33s select 3 40s475ms tcl 4 22s28ms Queries by host
Key values
- 10.3.0.4 Main host
- 31 Requests
- 7m4s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 16 Requests
- 3m55s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-21 15:16:18 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 17 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 52s916ms VACUUM ANALYZE;[ Date: 2025-10-21 06:26:09 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 40s935ms VACUUM ANALYSE;[ Date: 2025-10-21 06:26:58 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 30s990ms 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-10-21 06:38:05 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 30s413ms 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-10-21 20:33:38 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 28s577ms 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-10-21 06:36:54 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 23s840ms 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-10-21 06:38:29 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 19s716ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-21 06:23:51 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 18s846ms 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-10-21 06:24:16 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 16s158ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-21 08:41:43 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 15s436ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-21 06:22:49 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 12s423ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2025-10-21 06:23:01 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 11s464ms 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-10-21 06:22:15 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 10s666ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-10-21 06:20:56 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 10s204ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-21 06:30:47 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 8s551ms ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-10-21 06:24:30 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 8s108ms CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));[ Date: 2025-10-21 06:22:04 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 7s805ms ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-21 06:23:27 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 7s359ms CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);[ Date: 2025-10-21 06:23:09 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 7s134ms COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;[ Date: 2025-10-21 06:38:36 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 5s975ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-21 06:23:58 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 52s916ms 1 52s916ms 52s916ms 52s916ms vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 21 08 1 52s916ms 52s916ms [ User: a3dsupervisor - Total duration: 52s916ms - Times executed: 1 ]
[ Application: psql - Total duration: 52s916ms - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-10-21 06:26:09 Duration: 52s916ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 40s935ms 1 40s935ms 40s935ms 40s935ms vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 08 1 40s935ms 40s935ms [ User: a3dsupervisor - Total duration: 40s935ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s935ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-21 06:26:58 Duration: 40s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 30s990ms 1 30s990ms 30s990ms 30s990ms 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 #3
Day Hour Count Duration Avg duration Oct 21 08 1 30s990ms 30s990ms [ User: a3dsupervisor - Total duration: 30s990ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 30s990ms - 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-10-21 06:38:05 Duration: 30s990ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 30s413ms 1 30s413ms 30s413ms 30s413ms 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 Oct 21 22 1 30s413ms 30s413ms [ User: a3dsupervisor - Total duration: 30s413ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 30s413ms - 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-10-21 20:33:38 Duration: 30s413ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 28s577ms 1 28s577ms 28s577ms 28s577ms 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 Oct 21 08 1 28s577ms 28s577ms [ User: a3dsupervisor - Total duration: 28s577ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s577ms - 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-10-21 06:36:54 Duration: 28s577ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 26s362ms 2 10s204ms 16s158ms 13s181ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 21 08 1 10s204ms 10s204ms 10 1 16s158ms 16s158ms [ User: a3dsupervisor - Total duration: 26s362ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26s362ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 08:41:43 Duration: 16s158ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 06:30:47 Duration: 10s204ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 23s840ms 1 23s840ms 23s840ms 23s840ms 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 #7
Day Hour Count Duration Avg duration Oct 21 08 1 23s840ms 23s840ms [ User: a3dsupervisor - Total duration: 23s840ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 23s840ms - 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-10-21 06:38:29 Duration: 23s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 22s28ms 4 5s191ms 5s779ms 5s507ms commit;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 21 20 4 22s28ms 5s507ms [ User: a3dsupervisor - Total duration: 22s28ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22s28ms - Times executed: 4 ]
-
COMMIT;
Date: 2025-10-21 18:32:05 Duration: 5s779ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 18:32:05 Duration: 5s761ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 18:32:04 Duration: 5s295ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 19s716ms 1 19s716ms 19s716ms 19s716ms 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 Oct 21 08 1 19s716ms 19s716ms [ User: a3dsupervisor - Total duration: 19s716ms - Times executed: 1 ]
[ Application: psql - Total duration: 19s716ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-21 06:23:51 Duration: 19s716ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 18s846ms 1 18s846ms 18s846ms 18s846ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 21 08 1 18s846ms 18s846ms [ User: a3dsupervisor - Total duration: 18s846ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s846ms - 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-10-21 06:24:16 Duration: 18s846ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 15s436ms 1 15s436ms 15s436ms 15s436ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 21 08 1 15s436ms 15s436ms [ User: a3dsupervisor - Total duration: 15s436ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s436ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-21 06:22:49 Duration: 15s436ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 12s423ms 1 12s423ms 12s423ms 12s423ms 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 Oct 21 08 1 12s423ms 12s423ms [ User: a3dsupervisor - Total duration: 12s423ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s423ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-21 06:23:01 Duration: 12s423ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 11s464ms 1 11s464ms 11s464ms 11s464ms 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 Oct 21 08 1 11s464ms 11s464ms [ User: a3dsupervisor - Total duration: 11s464ms - Times executed: 1 ]
[ Application: psql - Total duration: 11s464ms - 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-10-21 06:22:15 Duration: 11s464ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 10s666ms 1 10s666ms 10s666ms 10s666ms 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 #14
Day Hour Count Duration Avg duration Oct 21 08 1 10s666ms 10s666ms [ User: a3dsupervisor - Total duration: 10s666ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s666ms - 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-10-21 06:20:56 Duration: 10s666ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 10s18ms 2 5s9ms 5s9ms 5s9ms 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 #15
Day Hour Count Duration Avg duration Oct 21 21 2 10s18ms 5s9ms [ User: a3dsupervisor - Total duration: 10s18ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s18ms - 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-10-21 19:46:23 Duration: 5s9ms 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-10-21 19:46:23 Duration: 5s9ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 8s551ms 1 8s551ms 8s551ms 8s551ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 08 1 8s551ms 8s551ms [ User: a3dsupervisor - Total duration: 8s551ms - Times executed: 1 ]
[ Application: psql - Total duration: 8s551ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-21 06:24:30 Duration: 8s551ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 8s108ms 1 8s108ms 8s108ms 8s108ms 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 Oct 21 08 1 8s108ms 8s108ms [ User: a3dsupervisor - Total duration: 8s108ms - Times executed: 1 ]
[ Application: psql - Total duration: 8s108ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-21 06:22:04 Duration: 8s108ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 7s805ms 1 7s805ms 7s805ms 7s805ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 08 1 7s805ms 7s805ms [ User: a3dsupervisor - Total duration: 7s805ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s805ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-21 06:23:27 Duration: 7s805ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 7s359ms 1 7s359ms 7s359ms 7s359ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 21 08 1 7s359ms 7s359ms [ User: a3dsupervisor - Total duration: 7s359ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s359ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-21 06:23:09 Duration: 7s359ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 7s134ms 1 7s134ms 7s134ms 7s134ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 21 08 1 7s134ms 7s134ms [ User: a3dsupervisor - Total duration: 7s134ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s134ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-21 06:38:36 Duration: 7s134ms 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 4 22s28ms 5s191ms 5s779ms 5s507ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 21 20 4 22s28ms 5s507ms [ User: a3dsupervisor - Total duration: 22s28ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22s28ms - Times executed: 4 ]
-
COMMIT;
Date: 2025-10-21 18:32:05 Duration: 5s779ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 18:32:05 Duration: 5s761ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 18:32:04 Duration: 5s295ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2 26s362ms 10s204ms 16s158ms 13s181ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 08 1 10s204ms 10s204ms 10 1 16s158ms 16s158ms [ User: a3dsupervisor - Total duration: 26s362ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26s362ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 08:41:43 Duration: 16s158ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 06:30:47 Duration: 10s204ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2 10s18ms 5s9ms 5s9ms 5s9ms 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 #3
Day Hour Count Duration Avg duration Oct 21 21 2 10s18ms 5s9ms [ User: a3dsupervisor - Total duration: 10s18ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s18ms - 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-10-21 19:46:23 Duration: 5s9ms 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-10-21 19:46:23 Duration: 5s9ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 52s916ms 52s916ms 52s916ms 52s916ms vacuum analyze;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 21 08 1 52s916ms 52s916ms [ User: a3dsupervisor - Total duration: 52s916ms - Times executed: 1 ]
[ Application: psql - Total duration: 52s916ms - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-10-21 06:26:09 Duration: 52s916ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 40s935ms 40s935ms 40s935ms 40s935ms vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 21 08 1 40s935ms 40s935ms [ User: a3dsupervisor - Total duration: 40s935ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s935ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-21 06:26:58 Duration: 40s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1 30s990ms 30s990ms 30s990ms 30s990ms 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 #6
Day Hour Count Duration Avg duration Oct 21 08 1 30s990ms 30s990ms [ User: a3dsupervisor - Total duration: 30s990ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 30s990ms - 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-10-21 06:38:05 Duration: 30s990ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 1 30s413ms 30s413ms 30s413ms 30s413ms 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 #7
Day Hour Count Duration Avg duration Oct 21 22 1 30s413ms 30s413ms [ User: a3dsupervisor - Total duration: 30s413ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 30s413ms - 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-10-21 20:33:38 Duration: 30s413ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1 28s577ms 28s577ms 28s577ms 28s577ms 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 Oct 21 08 1 28s577ms 28s577ms [ User: a3dsupervisor - Total duration: 28s577ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s577ms - 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-10-21 06:36:54 Duration: 28s577ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1 23s840ms 23s840ms 23s840ms 23s840ms 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 #9
Day Hour Count Duration Avg duration Oct 21 08 1 23s840ms 23s840ms [ User: a3dsupervisor - Total duration: 23s840ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 23s840ms - 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-10-21 06:38:29 Duration: 23s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 1 19s716ms 19s716ms 19s716ms 19s716ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 21 08 1 19s716ms 19s716ms [ User: a3dsupervisor - Total duration: 19s716ms - Times executed: 1 ]
[ Application: psql - Total duration: 19s716ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-21 06:23:51 Duration: 19s716ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1 18s846ms 18s846ms 18s846ms 18s846ms 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 Oct 21 08 1 18s846ms 18s846ms [ User: a3dsupervisor - Total duration: 18s846ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s846ms - 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-10-21 06:24:16 Duration: 18s846ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1 15s436ms 15s436ms 15s436ms 15s436ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 21 08 1 15s436ms 15s436ms [ User: a3dsupervisor - Total duration: 15s436ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s436ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-21 06:22:49 Duration: 15s436ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1 12s423ms 12s423ms 12s423ms 12s423ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 21 08 1 12s423ms 12s423ms [ User: a3dsupervisor - Total duration: 12s423ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s423ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-21 06:23:01 Duration: 12s423ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1 11s464ms 11s464ms 11s464ms 11s464ms 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 #14
Day Hour Count Duration Avg duration Oct 21 08 1 11s464ms 11s464ms [ User: a3dsupervisor - Total duration: 11s464ms - Times executed: 1 ]
[ Application: psql - Total duration: 11s464ms - 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-10-21 06:22:15 Duration: 11s464ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1 10s666ms 10s666ms 10s666ms 10s666ms 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 Oct 21 08 1 10s666ms 10s666ms [ User: a3dsupervisor - Total duration: 10s666ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s666ms - 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-10-21 06:20:56 Duration: 10s666ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 1 8s551ms 8s551ms 8s551ms 8s551ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 08 1 8s551ms 8s551ms [ User: a3dsupervisor - Total duration: 8s551ms - Times executed: 1 ]
[ Application: psql - Total duration: 8s551ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-21 06:24:30 Duration: 8s551ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 1 8s108ms 8s108ms 8s108ms 8s108ms 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 Oct 21 08 1 8s108ms 8s108ms [ User: a3dsupervisor - Total duration: 8s108ms - Times executed: 1 ]
[ Application: psql - Total duration: 8s108ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-21 06:22:04 Duration: 8s108ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 1 7s805ms 7s805ms 7s805ms 7s805ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 08 1 7s805ms 7s805ms [ User: a3dsupervisor - Total duration: 7s805ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s805ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-21 06:23:27 Duration: 7s805ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 1 7s359ms 7s359ms 7s359ms 7s359ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 21 08 1 7s359ms 7s359ms [ User: a3dsupervisor - Total duration: 7s359ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s359ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-21 06:23:09 Duration: 7s359ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 1 7s134ms 7s134ms 7s134ms 7s134ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 21 08 1 7s134ms 7s134ms [ User: a3dsupervisor - Total duration: 7s134ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s134ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-21 06:38:36 Duration: 7s134ms 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 52s916ms 52s916ms 52s916ms 1 52s916ms vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 21 08 1 52s916ms 52s916ms [ User: a3dsupervisor - Total duration: 52s916ms - Times executed: 1 ]
[ Application: psql - Total duration: 52s916ms - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-10-21 06:26:09 Duration: 52s916ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 40s935ms 40s935ms 40s935ms 1 40s935ms vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 08 1 40s935ms 40s935ms [ User: a3dsupervisor - Total duration: 40s935ms - Times executed: 1 ]
[ Application: psql - Total duration: 40s935ms - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-21 06:26:58 Duration: 40s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 30s990ms 30s990ms 30s990ms 1 30s990ms 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 #3
Day Hour Count Duration Avg duration Oct 21 08 1 30s990ms 30s990ms [ User: a3dsupervisor - Total duration: 30s990ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 30s990ms - 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-10-21 06:38:05 Duration: 30s990ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 30s413ms 30s413ms 30s413ms 1 30s413ms 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 Oct 21 22 1 30s413ms 30s413ms [ User: a3dsupervisor - Total duration: 30s413ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 30s413ms - 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-10-21 20:33:38 Duration: 30s413ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 28s577ms 28s577ms 28s577ms 1 28s577ms 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 Oct 21 08 1 28s577ms 28s577ms [ User: a3dsupervisor - Total duration: 28s577ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s577ms - 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-10-21 06:36:54 Duration: 28s577ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 23s840ms 23s840ms 23s840ms 1 23s840ms 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 #6
Day Hour Count Duration Avg duration Oct 21 08 1 23s840ms 23s840ms [ User: a3dsupervisor - Total duration: 23s840ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 23s840ms - 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-10-21 06:38:29 Duration: 23s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 19s716ms 19s716ms 19s716ms 1 19s716ms 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 Oct 21 08 1 19s716ms 19s716ms [ User: a3dsupervisor - Total duration: 19s716ms - Times executed: 1 ]
[ Application: psql - Total duration: 19s716ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-21 06:23:51 Duration: 19s716ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 18s846ms 18s846ms 18s846ms 1 18s846ms 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 #8
Day Hour Count Duration Avg duration Oct 21 08 1 18s846ms 18s846ms [ User: a3dsupervisor - Total duration: 18s846ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s846ms - 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-10-21 06:24:16 Duration: 18s846ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 15s436ms 15s436ms 15s436ms 1 15s436ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 21 08 1 15s436ms 15s436ms [ User: a3dsupervisor - Total duration: 15s436ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s436ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-21 06:22:49 Duration: 15s436ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 10s204ms 16s158ms 13s181ms 2 26s362ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 21 08 1 10s204ms 10s204ms 10 1 16s158ms 16s158ms [ User: a3dsupervisor - Total duration: 26s362ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26s362ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 08:41:43 Duration: 16s158ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-21 06:30:47 Duration: 10s204ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 12s423ms 12s423ms 12s423ms 1 12s423ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 21 08 1 12s423ms 12s423ms [ User: a3dsupervisor - Total duration: 12s423ms - Times executed: 1 ]
[ Application: psql - Total duration: 12s423ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-21 06:23:01 Duration: 12s423ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 11s464ms 11s464ms 11s464ms 1 11s464ms 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 Oct 21 08 1 11s464ms 11s464ms [ User: a3dsupervisor - Total duration: 11s464ms - Times executed: 1 ]
[ Application: psql - Total duration: 11s464ms - 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-10-21 06:22:15 Duration: 11s464ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 10s666ms 10s666ms 10s666ms 1 10s666ms 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 Oct 21 08 1 10s666ms 10s666ms [ User: a3dsupervisor - Total duration: 10s666ms - Times executed: 1 ]
[ Application: psql - Total duration: 10s666ms - 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-10-21 06:20:56 Duration: 10s666ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 8s551ms 8s551ms 8s551ms 1 8s551ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 21 08 1 8s551ms 8s551ms [ User: a3dsupervisor - Total duration: 8s551ms - Times executed: 1 ]
[ Application: psql - Total duration: 8s551ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-21 06:24:30 Duration: 8s551ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 8s108ms 8s108ms 8s108ms 1 8s108ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 21 08 1 8s108ms 8s108ms [ User: a3dsupervisor - Total duration: 8s108ms - Times executed: 1 ]
[ Application: psql - Total duration: 8s108ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-21 06:22:04 Duration: 8s108ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 7s805ms 7s805ms 7s805ms 1 7s805ms 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 Oct 21 08 1 7s805ms 7s805ms [ User: a3dsupervisor - Total duration: 7s805ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s805ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-21 06:23:27 Duration: 7s805ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 7s359ms 7s359ms 7s359ms 1 7s359ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 21 08 1 7s359ms 7s359ms [ User: a3dsupervisor - Total duration: 7s359ms - Times executed: 1 ]
[ Application: psql - Total duration: 7s359ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-21 06:23:09 Duration: 7s359ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 7s134ms 7s134ms 7s134ms 1 7s134ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 08 1 7s134ms 7s134ms [ User: a3dsupervisor - Total duration: 7s134ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s134ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-21 06:38:36 Duration: 7s134ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 5s191ms 5s779ms 5s507ms 4 22s28ms commit;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 21 20 4 22s28ms 5s507ms [ User: a3dsupervisor - Total duration: 22s28ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22s28ms - Times executed: 4 ]
-
COMMIT;
Date: 2025-10-21 18:32:05 Duration: 5s779ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 18:32:05 Duration: 5s761ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 18:32:04 Duration: 5s295ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s9ms 5s9ms 5s9ms 2 10s18ms 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 #20
Day Hour Count Duration Avg duration Oct 21 21 2 10s18ms 5s9ms [ User: a3dsupervisor - Total duration: 10s18ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s18ms - 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-10-21 19:46:23 Duration: 5s9ms 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-10-21 19:46:23 Duration: 5s9ms 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
- 8,734 Log entries
Events distribution
Key values
- 0 PANIC entries
- 22 FATAL entries
- 2966 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 2,928 Max number of times the same event was reported
- 3,004 Total events found
Rank Times reported Error 1 2,928 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 21 08 94 09 240 10 641 11 121 12 401 13 766 14 204 15 226 16 15 17 200 18 20 2 26 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 21 12 6 14 11 16 2 19 7 3 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 21 08 16 4 13 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 21 01 13 5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 21 01 9 6 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 #6
Day Hour Count Oct 21 08 1 7 1 ERROR: canceling statement due to lock timeoutselect LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 21 12 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 Oct 21 08 1 9 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 21 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 Oct 21 08 1 11 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 #11
Day Hour Count Oct 21 08 1 12 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 21 12 1 13 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 #13
Day Hour Count Oct 21 08 1 14 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 21 08 1 15 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 #15
Day Hour Count Oct 21 08 1 16 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 21 08 1 17 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 #17
Day Hour Count Oct 21 08 1