pgBadger-
Global information
- Generated on Thu Oct 23 09:10:13 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=22/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=22/h=23/m=00/PT1H.log
- Parsed 4,899 log entries in 1m2s
- Log start from 2025-10-22 10:08:15 to 2025-10-22 20:45:02
-
Overview
Global Stats
- 69 Number of unique normalized queries
- 71 Number of queries
- 21m6s Total query duration
- 2025-10-22 00:00:55 First query
- 2025-10-22 19:48:44 Last query
- 3 queries/s at 2025-10-22 06:49:03 Query peak
- 21m6s Total query duration
- 7s288ms Prepare/parse total duration
- 0ms Bind total duration
- 20m59s Execute total duration
- 1,021 Number of events
- 35 Number of unique normalized events
- 956 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
- 214 Number temporary file
- 1.06 GiB Max size of temporary file
- 20.22 MiB Average size of temporary file
- 831 Total number of sessions
- 27 sessions at 2025-10-22 18:54:46 Session peak
- 3d22h54m22s Total duration of sessions
- 6m51s Average duration of sessions
- 0 Average queries per session
- 1s524ms Average queries duration per session
- 6m49s Average idle time per session
- 833 Total number of connections
- 10 connections/s at 2025-10-22 18:54:31 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-22 06:49:03 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-22 06:56:19 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-22 19:48:09 Date
Queries duration
Key values
- 21m6s 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 22 00 1 0ms 5s344ms 5s344ms 5s344ms 5s344ms 5s344ms 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 22 0ms 22s38ms 9s148ms 28s217ms 40s875ms 1m2s 07 2 0ms 6s659ms 6s136ms 0ms 0ms 12s273ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 8 0ms 3m45s 39s123ms 12s494ms 15s921ms 3m45s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 34 0ms 2m11s 20s719ms 2m11s 2m13s 2m35s 19 4 0ms 6s82ms 5s797ms 0ms 23s191ms 23s191ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 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 22 00 1 0 5s344ms 0ms 5s344ms 5s344ms 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 6 0 7s978ms 0ms 6s848ms 16s260ms 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 5 0 8s358ms 0ms 0ms 15s921ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 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 22 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 3 1 0 0 7s923ms 0ms 0ms 9s211ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 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 1 0 34s557ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 6 30s335ms 0ms 15s566ms 50s675ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 22 00 0 1 1.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 22 22.00 4.55% 07 0 2 2.00 0.00% 08 0 0 0.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 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 8 8.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 4 4.00 0.00% 20 0 0 0.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 22 00 15 0.00/s 01 16 0.00/s 02 13 0.00/s 03 17 0.00/s 04 24 0.01/s 05 17 0.00/s 06 34 0.01/s 07 52 0.01/s 08 24 0.01/s 09 35 0.01/s 10 24 0.01/s 11 14 0.00/s 12 45 0.01/s 13 83 0.02/s 14 93 0.03/s 15 63 0.02/s 16 49 0.01/s 17 40 0.01/s 18 62 0.02/s 19 20 0.01/s 20 27 0.01/s 21 27 0.01/s 22 19 0.01/s 23 20 0.01/s Day Hour Count Average Duration Average idle time Oct 22 00 13 1m4s 1m4s 01 16 1m9s 1m9s 02 13 1m7s 1m7s 03 15 1m10s 1m10s 04 23 1m13s 1m13s 05 20 1m11s 1m11s 06 30 1m9s 1m2s 07 53 1m33s 1m33s 08 23 1m19s 1m19s 09 36 1m13s 1m13s 10 27 26m20s 26m20s 11 14 1m7s 1m7s 12 38 1m11s 1m11s 13 85 11m53s 11m53s 14 97 6m 6m 15 63 2m41s 2m36s 16 51 2m3s 2m3s 17 39 53m49s 53m49s 18 62 3m36s 3m24s 19 20 4m33s 4m32s 20 25 3m24s 3m24s 21 27 3m9s 3m9s 22 17 3m29s 3m29s 23 24 4m14s 4m14s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-10-22 18:54:31 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 833 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 833 connections Total
-
Sessions
Simultaneous sessions
Key values
- 27 sessions Session Peak
- 2025-10-22 18:54:46 Date
Histogram of session times
Key values
- 702 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 831 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 831 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 831 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 831 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 1 3h48m51s 3h48m51s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 1 3h47m37s 3h47m37s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 1 3h48m24s 3h48m24s IntelliJ IDEA 2024.3.5 3 4h52m23s 1h37m27s PostgreSQL JDBC Driver 760 3d6h2m51s 6m9s [unknown] 56 8s125ms 145ms pg_restore 4 31m54s 7m58s psql 5 2m12s 26s432ms -
Temporary Files
Size of temporary files
Key values
- 395.63 MiB Temp Files size Peak
- 2025-10-22 18:38:35 Date
Number of temporary files
Key values
- 5 per second Temp Files Peak
- 2025-10-22 18:42:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 22 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 1 4.19 MiB 4.19 MiB 13 2 8.38 MiB 4.19 MiB 14 3 12.56 MiB 4.19 MiB 15 27 113.35 MiB 4.20 MiB 16 0 0 0 17 0 0 0 18 181 4.09 GiB 23.14 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 6 23.57 MiB 2.48 MiB 5.39 MiB 3.93 MiB 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_0.alert_type_a3d_id = ? and ceahp1_1.obj_template_a3d_id = ? and ceahp1_1.obj_num_id = ? order by ceahp1_1.history_date desc;-
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 = $1 and ceahp1_0.ALERT_TYPE_A3D_ID = $2 and ceahp1_1.OBJ_TEMPLATE_A3D_ID = $3 and ceahp1_1.OBJ_NUM_ID = $4 order by ceahp1_1.HISTORY_DATE desc;
Date: 2025-10-22 15:23:25 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 3 45.85 MiB 2.23 MiB 41.16 MiB 15.28 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2025-10-22 18:38:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 3 1.31 GiB 110.74 MiB 1.06 GiB 447.21 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:36:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 205.52 MiB 22.30 MiB 158.86 MiB 68.51 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-22 18:39:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 67.89 MiB 3.70 MiB 59.53 MiB 22.63 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2025-10-22 18:41:55 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 107.50 MiB 11.77 MiB 82.91 MiB 35.83 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-10-22 18:41:42 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 418.10 MiB 41.50 MiB 334.33 MiB 139.37 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-22 18:36:51 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 52.74 MiB 3.12 MiB 44.12 MiB 17.58 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-10-22 18:42:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 178.10 MiB 50.95 MiB 76.19 MiB 59.37 MiB 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);-
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-22 18:40:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 78.82 MiB 20.93 MiB 34.77 MiB 26.27 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-10-22 18:41:52 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 15.59 MiB 4.73 MiB 5.57 MiB 5.20 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-10-22 18:38:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 13.15 MiB 3.82 MiB 5.45 MiB 4.38 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-10-22 18:42:12 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3 92.04 MiB 30.12 MiB 31.27 MiB 30.68 MiB 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);-
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-22 18:41:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3 55.22 MiB 4.02 MiB 46.44 MiB 18.41 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-10-22 18:38:45 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3 371.37 MiB 30.70 MiB 309.94 MiB 123.79 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-22 18:39:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 3 507.56 MiB 16.90 MiB 473.39 MiB 169.19 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-10-22 18:40:36 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 41.07 MiB 2.13 MiB 38.94 MiB 20.54 MiB add constraint pk_l_notification_user primary key (nous_user_num_id, nous_noti_id);-
ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);
Date: 2025-10-22 18:42:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 13.20 MiB 2.30 MiB 10.91 MiB 6.60 MiB add constraint pk_pe_consumption_hourly primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_hourly PRIMARY KEY (consumption_num_id);
Date: 2025-10-22 18:42:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 431.73 MiB 431.73 MiB 431.73 MiB 431.73 MiB add constraint fk_uml_relation_ua_id foreign key (ur_ua_id) references public.uml_attribute (ua_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_uml_relation_ua_id FOREIGN KEY (ur_ua_id) REFERENCES public.uml_attribute (ua_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:37:45 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 31.12 MiB 31.12 MiB 31.12 MiB 31.12 MiB select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021523', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021523', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-10-22 15:23:09 Duration: 8s86ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
21 1 10.50 MiB 10.50 MiB 10.50 MiB 10.50 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-10-22 18:38:23 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.06 GiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-22 18:36:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 473.39 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-22 18:40:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 431.73 MiB ADD CONSTRAINT fk_uml_relation_ua_id FOREIGN KEY (ur_ua_id) REFERENCES public.uml_attribute (ua_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-22 18:37:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 334.33 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-22 18:36:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 309.94 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-22 18:39:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 158.86 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-22 18:39:58 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 148.30 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-22 18:38:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 110.74 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-22 18:38:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 82.91 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-10-22 18:41:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 76.19 MiB 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-22 18:40:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 59.53 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-10-22 18:41:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 50.97 MiB 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-22 18:40:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 50.95 MiB 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-22 18:40:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 46.44 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-10-22 18:38:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 44.12 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-10-22 18:42:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 42.27 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-22 18:37:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 41.50 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-22 18:37:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 41.16 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-10-22 18:38:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 38.94 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-10-22 18:42:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 34.77 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2025-10-22 18:41:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
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 22 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
- ShareLock Main Lock Type
- 2 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
- 12 Total read queries
- 56 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 71 Requests
- 20m59s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 71 Requests
User Request type Count Duration a3dsupervisor Total 71 20m59s copy from 6 3m15s ddl 26 6m delete 2 51s468ms insert 3 24s846ms others 3 6m8s select 12 1m35s tcl 18 2m37s update 1 6s847ms Duration by user
Key values
- 20m59s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 71 20m59s copy from 6 3m15s ddl 26 6m delete 2 51s468ms insert 3 24s846ms others 3 6m8s select 12 1m35s tcl 18 2m37s update 1 6s847ms Queries by host
Key values
- 10.3.0.4 Main host
- 71 Requests
- 20m59s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 38 Requests
- 9m31s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-22 07:26:41 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 37 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m45s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-22 15:21:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 2m11s VACUUM ANALYSE;[ Date: 2025-10-22 18:53:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m15s 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) FROM stdin;[ Date: 2025-10-22 18:36:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 35s932ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;[ Date: 2025-10-22 18:35:46 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 34s557ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-22 15:25:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 33s579ms ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-22 18:38:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 29s478ms 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) FROM stdin;[ Date: 2025-10-22 18:39:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 29s190ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-10-22 18:37:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 26s140ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-10-22 18:36:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 24s987ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);[ Date: 2025-10-22 18:36:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 24s525ms CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-22 18:37:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 22s38ms COMMIT;[ Date: 2025-10-22 06:58:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 21s196ms 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) FROM stdin;[ Date: 2025-10-22 18:39:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 18s765ms CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);[ Date: 2025-10-22 18:37:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 18s698ms CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);[ Date: 2025-10-22 18:37:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 18s209ms 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) FROM stdin;[ Date: 2025-10-22 18:41:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 17s475ms ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-22 18:38:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 16s910ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-22 18:56:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 16s690ms CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);[ Date: 2025-10-22 18:36:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 16s677ms ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-22 18:37:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3m45s 1 3m45s 3m45s 3m45s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 22 17 1 3m45s 3m45s [ User: a3dsupervisor - Total duration: 3m45s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m45s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-22 15:21:13 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m37s 18 5s224ms 22s38ms 8s731ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 22 08 12 2m1s 10s142ms 09 2 12s273ms 6s136ms 21 4 23s191ms 5s797ms [ User: a3dsupervisor - Total duration: 2m37s - Times executed: 18 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m37s - Times executed: 18 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s38ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:41 Duration: 14s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:57:14 Duration: 12s573ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m11s 1 2m11s 2m11s 2m11s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 22 20 1 2m11s 2m11s [ User: a3dsupervisor - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - Total duration: 2m11s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-22 18:53:24 Duration: 2m11s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1m15s 1 1m15s 1m15s 1m15s 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) from stdin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 22 20 1 1m15s 1m15s [ User: a3dsupervisor - Total duration: 1m15s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m15s - 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) FROM stdin;
Date: 2025-10-22 18:36:25 Duration: 1m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 51s468ms 2 16s910ms 34s557ms 25s734ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 22 17 1 34s557ms 34s557ms 20 1 16s910ms 16s910ms [ User: a3dsupervisor - Total duration: 51s468ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s468ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-22 15:25:53 Duration: 34s557ms Database: autotest_feat_batch 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-22 18:56:04 Duration: 16s910ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 35s932ms 1 35s932ms 35s932ms 35s932ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 22 20 1 35s932ms 35s932ms [ User: a3dsupervisor - Total duration: 35s932ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s932ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-22 18:35:46 Duration: 35s932ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 33s579ms 1 33s579ms 33s579ms 33s579ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 22 20 1 33s579ms 33s579ms [ User: a3dsupervisor - Total duration: 33s579ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s579ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:38:35 Duration: 33s579ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 29s478ms 1 29s478ms 29s478ms 29s478ms 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) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 22 20 1 29s478ms 29s478ms [ User: a3dsupervisor - Total duration: 29s478ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s478ms - 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) FROM stdin;
Date: 2025-10-22 18:39:34 Duration: 29s478ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 29s190ms 1 29s190ms 29s190ms 29s190ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 22 20 1 29s190ms 29s190ms [ User: a3dsupervisor - Total duration: 29s190ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s190ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-22 18:37:10 Duration: 29s190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 26s140ms 1 26s140ms 26s140ms 26s140ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 22 20 1 26s140ms 26s140ms [ User: a3dsupervisor - Total duration: 26s140ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s140ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-22 18:36:51 Duration: 26s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 24s987ms 1 24s987ms 24s987ms 24s987ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 22 20 1 24s987ms 24s987ms [ User: a3dsupervisor - Total duration: 24s987ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s987ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-22 18:36:11 Duration: 24s987ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 24s846ms 3 6s251ms 9s382ms 8s282ms 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 #12
Day Hour Count Duration Avg duration Oct 22 08 3 24s846ms 8s282ms [ User: a3dsupervisor - Total duration: 24s846ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24s846ms - Times executed: 3 ]
-
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-22 06:57:14 Duration: 9s382ms Database: autotest_feat_batch 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-22 06:49:03 Duration: 9s211ms Database: autotest_feat_batch 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-22 06:56:19 Duration: 6s251ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 24s525ms 1 24s525ms 24s525ms 24s525ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 22 20 1 24s525ms 24s525ms [ User: a3dsupervisor - Total duration: 24s525ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s525ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:37:50 Duration: 24s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 21s196ms 1 21s196ms 21s196ms 21s196ms 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) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 22 20 1 21s196ms 21s196ms [ User: a3dsupervisor - Total duration: 21s196ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s196ms - 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) FROM stdin;
Date: 2025-10-22 18:39:17 Duration: 21s196ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 20s206ms 3 5s843ms 7s514ms 6s735ms 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 #15
Day Hour Count Duration Avg duration Oct 22 08 3 20s206ms 6s735ms [ User: a3dsupervisor - Total duration: 20s206ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 20s206ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-10-22 06:49:03 Duration: 7s514ms Database: autotest_feat_batch 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-10-22 06:57:14 Duration: 6s848ms Database: autotest_feat_batch 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-10-22 06:56:19 Duration: 5s843ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 18s765ms 1 18s765ms 18s765ms 18s765ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 22 20 1 18s765ms 18s765ms [ User: a3dsupervisor - Total duration: 18s765ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s765ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-10-22 18:37:10 Duration: 18s765ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 18s698ms 1 18s698ms 18s698ms 18s698ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 22 20 1 18s698ms 18s698ms [ User: a3dsupervisor - Total duration: 18s698ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s698ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-22 18:37:45 Duration: 18s698ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 18s209ms 1 18s209ms 18s209ms 18s209ms 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) from stdin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 22 20 1 18s209ms 18s209ms [ User: a3dsupervisor - Total duration: 18s209ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s209ms - 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) FROM stdin;
Date: 2025-10-22 18:41:38 Duration: 18s209ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 17s475ms 1 17s475ms 17s475ms 17s475ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 22 20 1 17s475ms 17s475ms [ User: a3dsupervisor - Total duration: 17s475ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s475ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:38:54 Duration: 17s475ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 16s690ms 1 16s690ms 16s690ms 16s690ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 22 20 1 16s690ms 16s690ms [ User: a3dsupervisor - Total duration: 16s690ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s690ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-22 18:36:41 Duration: 16s690ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 18 2m37s 5s224ms 22s38ms 8s731ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 22 08 12 2m1s 10s142ms 09 2 12s273ms 6s136ms 21 4 23s191ms 5s797ms [ User: a3dsupervisor - Total duration: 2m37s - Times executed: 18 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m37s - Times executed: 18 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s38ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:41 Duration: 14s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:57:14 Duration: 12s573ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3 24s846ms 6s251ms 9s382ms 8s282ms 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 Oct 22 08 3 24s846ms 8s282ms [ User: a3dsupervisor - Total duration: 24s846ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24s846ms - Times executed: 3 ]
-
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-22 06:57:14 Duration: 9s382ms Database: autotest_feat_batch 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-22 06:49:03 Duration: 9s211ms Database: autotest_feat_batch 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-22 06:56:19 Duration: 6s251ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 3 20s206ms 5s843ms 7s514ms 6s735ms 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 Oct 22 08 3 20s206ms 6s735ms [ User: a3dsupervisor - Total duration: 20s206ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 20s206ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-10-22 06:49:03 Duration: 7s514ms Database: autotest_feat_batch 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-10-22 06:57:14 Duration: 6s848ms Database: autotest_feat_batch 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-10-22 06:56:19 Duration: 5s843ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 2 51s468ms 16s910ms 34s557ms 25s734ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 22 17 1 34s557ms 34s557ms 20 1 16s910ms 16s910ms [ User: a3dsupervisor - Total duration: 51s468ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s468ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-22 15:25:53 Duration: 34s557ms Database: autotest_feat_batch 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-22 18:56:04 Duration: 16s910ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1 3m45s 3m45s 3m45s 3m45s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 22 17 1 3m45s 3m45s [ User: a3dsupervisor - Total duration: 3m45s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m45s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-22 15:21:13 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1 2m11s 2m11s 2m11s 2m11s vacuum analyse;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 22 20 1 2m11s 2m11s [ User: a3dsupervisor - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - Total duration: 2m11s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-22 18:53:24 Duration: 2m11s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1 1m15s 1m15s 1m15s 1m15s 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) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 22 20 1 1m15s 1m15s [ User: a3dsupervisor - Total duration: 1m15s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m15s - 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) FROM stdin;
Date: 2025-10-22 18:36:25 Duration: 1m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 35s932ms 35s932ms 35s932ms 35s932ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 22 20 1 35s932ms 35s932ms [ User: a3dsupervisor - Total duration: 35s932ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s932ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-22 18:35:46 Duration: 35s932ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 33s579ms 33s579ms 33s579ms 33s579ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 22 20 1 33s579ms 33s579ms [ User: a3dsupervisor - Total duration: 33s579ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s579ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:38:35 Duration: 33s579ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 29s478ms 29s478ms 29s478ms 29s478ms 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) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 22 20 1 29s478ms 29s478ms [ User: a3dsupervisor - Total duration: 29s478ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s478ms - 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) FROM stdin;
Date: 2025-10-22 18:39:34 Duration: 29s478ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 29s190ms 29s190ms 29s190ms 29s190ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 22 20 1 29s190ms 29s190ms [ User: a3dsupervisor - Total duration: 29s190ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s190ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-22 18:37:10 Duration: 29s190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 26s140ms 26s140ms 26s140ms 26s140ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 22 20 1 26s140ms 26s140ms [ User: a3dsupervisor - Total duration: 26s140ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s140ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-22 18:36:51 Duration: 26s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 24s987ms 24s987ms 24s987ms 24s987ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 22 20 1 24s987ms 24s987ms [ User: a3dsupervisor - Total duration: 24s987ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s987ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-22 18:36:11 Duration: 24s987ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 24s525ms 24s525ms 24s525ms 24s525ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 22 20 1 24s525ms 24s525ms [ User: a3dsupervisor - Total duration: 24s525ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s525ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:37:50 Duration: 24s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 21s196ms 21s196ms 21s196ms 21s196ms 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) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 22 20 1 21s196ms 21s196ms [ User: a3dsupervisor - Total duration: 21s196ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s196ms - 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) FROM stdin;
Date: 2025-10-22 18:39:17 Duration: 21s196ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 18s765ms 18s765ms 18s765ms 18s765ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 22 20 1 18s765ms 18s765ms [ User: a3dsupervisor - Total duration: 18s765ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s765ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-10-22 18:37:10 Duration: 18s765ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 18s698ms 18s698ms 18s698ms 18s698ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 22 20 1 18s698ms 18s698ms [ User: a3dsupervisor - Total duration: 18s698ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s698ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-22 18:37:45 Duration: 18s698ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 18s209ms 18s209ms 18s209ms 18s209ms 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) from stdin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 22 20 1 18s209ms 18s209ms [ User: a3dsupervisor - Total duration: 18s209ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s209ms - 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) FROM stdin;
Date: 2025-10-22 18:41:38 Duration: 18s209ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 17s475ms 17s475ms 17s475ms 17s475ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 22 20 1 17s475ms 17s475ms [ User: a3dsupervisor - Total duration: 17s475ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s475ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:38:54 Duration: 17s475ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 16s690ms 16s690ms 16s690ms 16s690ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 22 20 1 16s690ms 16s690ms [ User: a3dsupervisor - Total duration: 16s690ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s690ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-22 18:36:41 Duration: 16s690ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m45s 3m45s 3m45s 1 3m45s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 22 17 1 3m45s 3m45s [ User: a3dsupervisor - Total duration: 3m45s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m45s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-22 15:21:13 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m11s 2m11s 2m11s 1 2m11s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 22 20 1 2m11s 2m11s [ User: a3dsupervisor - Total duration: 2m11s - Times executed: 1 ]
[ Application: psql - Total duration: 2m11s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-22 18:53:24 Duration: 2m11s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m15s 1m15s 1m15s 1 1m15s 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) from stdin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 22 20 1 1m15s 1m15s [ User: a3dsupervisor - Total duration: 1m15s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m15s - 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) FROM stdin;
Date: 2025-10-22 18:36:25 Duration: 1m15s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 35s932ms 35s932ms 35s932ms 1 35s932ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 22 20 1 35s932ms 35s932ms [ User: a3dsupervisor - Total duration: 35s932ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s932ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-22 18:35:46 Duration: 35s932ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 33s579ms 33s579ms 33s579ms 1 33s579ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 22 20 1 33s579ms 33s579ms [ User: a3dsupervisor - Total duration: 33s579ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s579ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:38:35 Duration: 33s579ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 29s478ms 29s478ms 29s478ms 1 29s478ms 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) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 22 20 1 29s478ms 29s478ms [ User: a3dsupervisor - Total duration: 29s478ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s478ms - 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) FROM stdin;
Date: 2025-10-22 18:39:34 Duration: 29s478ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 29s190ms 29s190ms 29s190ms 1 29s190ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 22 20 1 29s190ms 29s190ms [ User: a3dsupervisor - Total duration: 29s190ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s190ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-22 18:37:10 Duration: 29s190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 26s140ms 26s140ms 26s140ms 1 26s140ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 22 20 1 26s140ms 26s140ms [ User: a3dsupervisor - Total duration: 26s140ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s140ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-22 18:36:51 Duration: 26s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 16s910ms 34s557ms 25s734ms 2 51s468ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 22 17 1 34s557ms 34s557ms 20 1 16s910ms 16s910ms [ User: a3dsupervisor - Total duration: 51s468ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s468ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-22 15:25:53 Duration: 34s557ms Database: autotest_feat_batch 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-22 18:56:04 Duration: 16s910ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 24s987ms 24s987ms 24s987ms 1 24s987ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 22 20 1 24s987ms 24s987ms [ User: a3dsupervisor - Total duration: 24s987ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s987ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-22 18:36:11 Duration: 24s987ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 24s525ms 24s525ms 24s525ms 1 24s525ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 22 20 1 24s525ms 24s525ms [ User: a3dsupervisor - Total duration: 24s525ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s525ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-22 18:37:50 Duration: 24s525ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 21s196ms 21s196ms 21s196ms 1 21s196ms 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) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 22 20 1 21s196ms 21s196ms [ User: a3dsupervisor - Total duration: 21s196ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s196ms - 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) FROM stdin;
Date: 2025-10-22 18:39:17 Duration: 21s196ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 18s765ms 18s765ms 18s765ms 1 18s765ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 22 20 1 18s765ms 18s765ms [ User: a3dsupervisor - Total duration: 18s765ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s765ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-10-22 18:37:10 Duration: 18s765ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 18s698ms 18s698ms 18s698ms 1 18s698ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 22 20 1 18s698ms 18s698ms [ User: a3dsupervisor - Total duration: 18s698ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s698ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-22 18:37:45 Duration: 18s698ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 18s209ms 18s209ms 18s209ms 1 18s209ms 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) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 22 20 1 18s209ms 18s209ms [ User: a3dsupervisor - Total duration: 18s209ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s209ms - 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) FROM stdin;
Date: 2025-10-22 18:41:38 Duration: 18s209ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 17s475ms 17s475ms 17s475ms 1 17s475ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 22 20 1 17s475ms 17s475ms [ User: a3dsupervisor - Total duration: 17s475ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s475ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-22 18:38:54 Duration: 17s475ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 16s690ms 16s690ms 16s690ms 1 16s690ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 22 20 1 16s690ms 16s690ms [ User: a3dsupervisor - Total duration: 16s690ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s690ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-22 18:36:41 Duration: 16s690ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5s224ms 22s38ms 8s731ms 18 2m37s commit;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 22 08 12 2m1s 10s142ms 09 2 12s273ms 6s136ms 21 4 23s191ms 5s797ms [ User: a3dsupervisor - Total duration: 2m37s - Times executed: 18 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m37s - Times executed: 18 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s38ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:41 Duration: 14s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:57:14 Duration: 12s573ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 6s251ms 9s382ms 8s282ms 3 24s846ms 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 Oct 22 08 3 24s846ms 8s282ms [ User: a3dsupervisor - Total duration: 24s846ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 24s846ms - Times executed: 3 ]
-
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-22 06:57:14 Duration: 9s382ms Database: autotest_feat_batch 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-22 06:49:03 Duration: 9s211ms Database: autotest_feat_batch 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-22 06:56:19 Duration: 6s251ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s843ms 7s514ms 6s735ms 3 20s206ms 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 Oct 22 08 3 20s206ms 6s735ms [ User: a3dsupervisor - Total duration: 20s206ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 20s206ms - Times executed: 3 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-10-22 06:49:03 Duration: 7s514ms Database: autotest_feat_batch 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-10-22 06:57:14 Duration: 6s848ms Database: autotest_feat_batch 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-10-22 06:56:19 Duration: 5s843ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 7s288ms 1 7s288ms 7s288ms 7s288ms select nextval('S_BACKGROUND_TASK');Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Oct 22 08 1 7s288ms 7s288ms [ User: a3dsupervisor - Total duration: 16s260ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s260ms - Times executed: 1 ]
-
select nextval('S_BACKGROUND_TASK');
Date: 2025-10-22 06:58:35 Duration: 7s288ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 3,807 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1007 ERROR entries
- 14 WARNING entries
Most Frequent Errors/Events
Key values
- 956 Max number of times the same event was reported
- 1,021 Total events found
Rank Times reported Error 1 956 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 22 21 96 22 420 23 200 00 238 01 2 2 19 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 22 12 3 15 5 16 6 18 2 19 3 3 8 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 22 17 8 4 6 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 22 17 6 5 2 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 22 17 2 6 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 22 20 1 7 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 22 17 1 8 1 ERROR: canceling statement due to lock timeoutselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 22 17 1 9 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 22 17 1 10 1 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 22 17 1 11 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 #11
Day Hour Count Oct 22 20 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 22 17 1 13 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 22 17 1 14 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 22 17 1 15 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 #15
Day Hour Count Oct 22 20 1 16 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 22 17 1 17 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 22 20 1 18 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 22 20 1 19 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #19
Day Hour Count Oct 22 17 1 20 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #20
Day Hour Count Oct 22 17 1 21 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #21
Day Hour Count Oct 22 17 1 22 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #22
Day Hour Count Oct 22 17 1 23 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #23
Day Hour Count Oct 22 20 1 24 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 #24
Day Hour Count Oct 22 20 1 25 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #25
Day Hour Count Oct 22 20 1 26 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_TIME_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #26
Day Hour Count Oct 22 17 1 27 1 ERROR: syntax error at or near "..."mapping"..."1.0"..."UTF-8"..."yes"..."true"..."false"..."true"..."false"..."500"..."500"..."xml"..."false"..."false"..."false"..."false"..."1"..."false"..."yyyyMMdd"..."true"..."PORT"..."PORT"..."true"..."A3D_LIBELLE"..."A3D_IDENTITE"..."A3D_LIBELLE"..."mapping"..."1.0"..."UTF-8"..."yes"..."true"..."false"..."true"..."false"..."500"..."500"..."xml"..."false"..."false"..."false"..."false"..."1"..."false"..."yyyyMMdd"..."true"..."PORT"..."PORT"..."true"..."A3D_LIBELLE"..."A3D_IDENTITE"..."A3D_LIBELLE"..."mappingNumId"..."directoryPath"..."aaa"..."fileName"..."Export_XML_02.01_batch01"..."logLevel"..."Info"..."viewTemplateUniqueCode"..."VUE_TYPE_REFERENTIEL_PATRIMOINE"..."encoding"..."UTF-8"..."filter"..."filterAsString"...""..."encodingAsEnum"..."UTF_8"..."mappingNumId"..."directoryPath"..."aaa"..."fileName"..."Export_XML_02.01_batch01"..."logLevel"..."Info"..."viewTemplateUniqueCode"..."VUE_TYPE_REFERENTIEL_PATRIMOINE"..."encoding"..."UTF-8"..."filter"..."filterAsString"...""..."encodingAsEnum"..."UTF_8"..."
Times Reported Most Frequent Error / Event #27
Day Hour Count Oct 22 08 1 28 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 #28
Day Hour Count Oct 22 20 1 29 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #29
Day Hour Count Oct 22 20 1 30 1 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #30
Day Hour Count Oct 22 17 1 31 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #31
Day Hour Count Oct 22 17 1 32 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 #32
Day Hour Count Oct 22 20 1 33 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #33
Day Hour Count Oct 22 17 1 34 1 ERROR: null value in column "..." of relation "..." violates not-null constraintSELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #34
Day Hour Count Oct 22 17 1 35 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 #35
Day Hour Count Oct 22 20 1