pgBadger-
Global information
- Generated on Wed Oct 15 09:07:26 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=14/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=14/h=23/m=00/PT1H.log
- Parsed 7,020 log entries in 59s
- Log start from 2025-10-14 10:39:49 to 2025-10-14 23:45:03
-
Overview
Global Stats
- 72 Number of unique normalized queries
- 90 Number of queries
- 53m36s Total query duration
- 2025-10-14 00:00:45 First query
- 2025-10-14 19:38:54 Last query
- 4 queries/s at 2025-10-14 15:41:11 Query peak
- 53m36s Total query duration
- 17s516ms Prepare/parse total duration
- 0ms Bind total duration
- 53m18s Execute total duration
- 2,037 Number of events
- 44 Number of unique normalized events
- 1,628 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
- 308 Number temporary file
- 714.15 MiB Max size of temporary file
- 15.26 MiB Average size of temporary file
- 810 Total number of sessions
- 29 sessions at 2025-10-14 06:43:53 Session peak
- 4d2h17s Total duration of sessions
- 7m15s Average duration of sessions
- 0 Average queries per session
- 3s970ms Average queries duration per session
- 7m11s Average idle time per session
- 812 Total number of connections
- 10 connections/s at 2025-10-14 18:43:34 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-10-14 15:41:11 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-14 15:42:57 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-14 06:27:33 Date
Queries duration
Key values
- 53m36s 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 14 00 1 0ms 5s735ms 5s735ms 0ms 5s735ms 5s735ms 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 7 0ms 12s599ms 6s890ms 7s249ms 12s644ms 15s739ms 07 1 0ms 5s254ms 5s254ms 0ms 0ms 5s254ms 08 1 0ms 17s850ms 17s850ms 0ms 0ms 17s850ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 9 0ms 4m 42s434ms 32s802ms 50s528ms 4m 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 5 0ms 3m24s 1m17s 0ms 9s326ms 6m12s 13 12 0ms 3m47s 50s545ms 28s196ms 1m8s 7m10s 14 5 0ms 3m39s 1m3s 9s434ms 1m15s 3m39s 15 11 0ms 3m42s 1m1s 36s291ms 47s46ms 9m17s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 35 0ms 2m20s 21s76ms 2m23s 2m46s 2m46s 19 3 0ms 6s574ms 5s974ms 0ms 0ms 17s924ms 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 14 00 1 0 5s735ms 0ms 0ms 5s735ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 6 0 13s354ms 0ms 13s948ms 32s802ms 11 0 0 0ms 0ms 0ms 0ms 12 1 0 7s123ms 0ms 0ms 7s123ms 13 7 0 10s547ms 0ms 7s860ms 24s925ms 14 2 0 6s217ms 0ms 0ms 12s434ms 15 5 0 11s587ms 0ms 6s117ms 36s291ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 1 0 5s439ms 0ms 0ms 5s439ms 19 1 0 5s343ms 0ms 0ms 5s343ms 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 14 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 1 0 0 12s599ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 17s850ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 1 0 50s528ms 0ms 0ms 50s528ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 1 1 0 0 1m24s 0ms 0ms 9s48ms 13 1 0 3 0 2m5s 0ms 0ms 3m5s 14 0 0 1 0 1m15s 0ms 0ms 0ms 15 0 0 1 0 47s46ms 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 30s351ms 0ms 17s529ms 1m19s 19 1 0 0 0 6s5ms 0ms 0ms 6s5ms 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 14 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 7 7.00 14.29% 07 0 1 1.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 9 9.00 0.00% 11 0 0 0.00 0.00% 12 0 5 5.00 0.00% 13 0 12 12.00 0.00% 14 0 5 5.00 0.00% 15 0 11 11.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 1 3 3.00 33.33% 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 14 00 27 0.01/s 01 11 0.00/s 02 16 0.00/s 03 21 0.01/s 04 25 0.01/s 05 14 0.00/s 06 48 0.01/s 07 29 0.01/s 08 56 0.02/s 09 49 0.01/s 10 36 0.01/s 11 23 0.01/s 12 68 0.02/s 13 59 0.02/s 14 57 0.02/s 15 26 0.01/s 16 22 0.01/s 17 32 0.01/s 18 47 0.01/s 19 26 0.01/s 20 30 0.01/s 21 37 0.01/s 22 28 0.01/s 23 25 0.01/s Day Hour Count Average Duration Average idle time Oct 14 00 27 4m10s 4m9s 01 11 6m30s 6m30s 02 16 3m27s 3m27s 03 21 3m17s 3m17s 04 25 3m12s 3m12s 05 14 5m39s 5m39s 06 46 2m48s 2m47s 07 29 4m58s 4m58s 08 56 2m14s 2m13s 09 48 5m4s 5m4s 10 36 3m42s 3m32s 11 26 2m46s 2m46s 12 62 3m11s 3m5s 13 62 6m9s 5m59s 14 57 4m1s 3m55s 15 29 10m9s 9m45s 16 22 5m36s 5m36s 17 32 1h24m56s 1h24m56s 18 47 3m4s 2m49s 19 26 2m26s 2m25s 20 30 4m26s 4m26s 21 37 2m 2m 22 28 4m11s 4m11s 23 23 3m45s 3m45s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-10-14 18:43:34 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 812 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 812 connections Total
-
Sessions
Simultaneous sessions
Key values
- 29 sessions Session Peak
- 2025-10-14 06:43:53 Date
Histogram of session times
Key values
- 622 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 810 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 810 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 810 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 387.02 MiB Temp Files size Peak
- 2025-10-14 18:26:33 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-10-14 15:43:43 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 14 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 1 4.19 MiB 4.19 MiB 09 1 4.19 MiB 4.19 MiB 10 25 106.86 MiB 4.27 MiB 11 0 0 0 12 29 122.31 MiB 4.22 MiB 13 24 105.91 MiB 4.41 MiB 14 25 108.79 MiB 4.35 MiB 15 26 109.16 MiB 4.20 MiB 16 0 0 0 17 0 0 0 18 177 4.04 GiB 23.38 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 4 107.94 MiB 23.69 MiB 31.13 MiB 26.98 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('202001021042', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021042', '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-14 10:42:32 Duration: 12s873ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
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('202001021543', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021543', '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-14 15:43:28 Duration: 8s842ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
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('202001021258', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021258', '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-14 12:58:37 Duration: 7s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 3 107.49 MiB 11.43 MiB 84.00 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-14 18:29:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 3 68.51 MiB 20.06 MiB 27.92 MiB 22.84 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-14 18:28:14 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 15.59 MiB 4.35 MiB 5.71 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-14 18:26:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 48.41 MiB 2.45 MiB 43.52 MiB 16.14 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-14 18:26:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 13.15 MiB 2.25 MiB 8.62 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-14 18:30:18 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 78.81 MiB 23.36 MiB 30.12 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-14 18:29:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 27.61 MiB 3.64 MiB 18.91 MiB 9.20 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-14 18:30:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 67.88 MiB 4.98 MiB 57.88 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-14 18:29:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 178.10 MiB 50.95 MiB 65.43 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-14 18:28:31 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 981.19 MiB 122.27 MiB 714.15 MiB 327.06 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-14 18:24:51 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 778.55 MiB 35.29 MiB 707.97 MiB 259.52 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-14 18:24:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3 507.27 MiB 11.68 MiB 473.81 MiB 169.09 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-14 18:28:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3 39.25 MiB 3.35 MiB 29.43 MiB 13.08 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-14 18:30:09 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3 92.05 MiB 25.89 MiB 33.52 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-14 18:29:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 13.60 MiB 2.55 MiB 11.05 MiB 6.80 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-14 18:30:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 92.85 MiB 92.85 MiB 92.85 MiB 92.85 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-14 18:27:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 44.38 MiB 44.38 MiB 44.38 MiB 44.38 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-14 18:30:19 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 427.72 MiB 427.72 MiB 427.72 MiB 427.72 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-10-14 18:25:41 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 714.15 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-14 18:24:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 707.97 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-14 18:24:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 473.81 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-14 18:28:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 427.72 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-10-14 18:25:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 144.77 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-14 18:26:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 122.27 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-14 18:26:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 92.85 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-14 18:27:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 84.00 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-10-14 18:29:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 65.43 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-14 18:28:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 61.72 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-14 18:28:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 57.88 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-10-14 18:29:58 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 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-14 18:28:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 44.38 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-10-14 18:30:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 43.52 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-10-14 18:26:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 35.29 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-14 18:25:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 35.29 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-14 18:25:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 33.52 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);[ Date: 2025-10-14 18:29:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 32.64 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);[ Date: 2025-10-14 18:29:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 31.13 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 (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('202001021543', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021543', '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-14 15:34:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver ]
20 30.12 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2025-10-14 18:29:54 - 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 14 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
- 11 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
- 24 Total read queries
- 56 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 90 Requests
- 53m18s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 90 Requests
User Request type Count Duration a3dsupervisor Total 90 53m18s copy from 6 3m17s ddl 26 6m19s delete 8 8m insert 3 6m32s others 10 18m16s select 24 4m7s tcl 11 6m22s update 2 21s647ms Duration by user
Key values
- 53m18s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 90 53m18s copy from 6 3m17s ddl 26 6m19s delete 8 8m insert 3 6m32s others 10 18m16s select 24 4m7s tcl 11 6m22s update 2 21s647ms Queries by host
Key values
- 10.3.0.4 Main host
- 90 Requests
- 53m18s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 56 Requests
- 41m16s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-14 20:00:22 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 50 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 4m call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 10:39:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 3m47s insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);[ Date: 2025-10-14 13:05:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 3m42s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 15:41:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 3m39s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 14:38:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 3m33s COMMIT;[ Date: 2025-10-14 15:41:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 3m24s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 12:56:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 3m5s delete from GTP_LOG_CONNECTION where LOG_DATE <;[ Date: 2025-10-14 13:05:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 2m38s insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);[ Date: 2025-10-14 12:56:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 2m20s VACUUM ANALYSE;[ Date: 2025-10-14 18:42:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 1m45s COMMIT;[ Date: 2025-10-14 15:41:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 1m19s 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-14 18:24:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 1m15s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-14 14:44:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 1m8s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-14 13:14:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 50s528ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-14 10:45:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 47s46ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-14 15:46:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 36s240ms 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-14 18:26:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 35s472ms 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-14 18:23:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 31s228ms 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-14 18:27:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 31s59ms call pack_gtp_dba.p_anonymization_ged ();[ Date: 2025-10-14 13:00:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 27s456ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-10-14 18:24:51 - 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 14m46s 4 3m24s 4m 3m41s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 14 12 1 4m 4m 14 1 3m24s 3m24s 16 1 3m39s 3m39s 17 1 3m42s 3m42s [ User: a3dsupervisor - Total duration: 14m46s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m46s - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 10:39:48 Duration: 4m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 15:41:11 Duration: 3m42s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 14:38:26 Duration: 3m39s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 6m26s 2 2m38s 3m47s 3m13s insert into batch_scenario_run (creation_date, creator_num_id, end_date, modification_date, modifier_num_id, batch_scenario_num_id, start_date, state, status, batch_scenario_run_id) values (,,,,,,,,,);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 14 14 1 2m38s 2m38s 15 1 3m47s 3m47s [ User: a3dsupervisor - Total duration: 6m26s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m26s - Times executed: 2 ]
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 13:05:36 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 12:56:25 Duration: 2m38s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 6m22s 11 5s73ms 3m33s 34s797ms commit;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 08 6 35s633ms 5s938ms 09 1 5s254ms 5s254ms 17 3 5m35s 1m51s 21 1 6s574ms 6s574ms [ User: a3dsupervisor - Total duration: 6m22s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m22s - Times executed: 11 ]
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 3m33s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 1m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 15s567ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 4m55s 7 15s28ms 1m15s 42s155ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 14 10 1 17s850ms 17s850ms 12 1 50s528ms 50s528ms 15 2 1m28s 44s341ms 16 1 1m15s 1m15s 17 1 47s46ms 47s46ms 20 1 15s28ms 15s28ms [ User: a3dsupervisor - Total duration: 4m55s - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m55s - Times executed: 7 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 14:44:09 Duration: 1m15s 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-14 13:14:22 Duration: 1m8s 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-14 10:45:51 Duration: 50s528ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 3m5s 1 3m5s 3m5s 3m5s delete from gtp_log_connection where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 14 15 1 3m5s 3m5s [ User: a3dsupervisor - Total duration: 3m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m5s - Times executed: 1 ]
-
delete from GTP_LOG_CONNECTION where LOG_DATE <;
Date: 2025-10-14 13:05:36 Duration: 3m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 2m20s 1 2m20s 2m20s 2m20s vacuum analyse;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 20 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: psql - Total duration: 2m20s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-14 18:42:13 Duration: 2m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1m19s 1 1m19s 1m19s 1m19s 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 14 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - 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-14 18:24:24 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m9s 5 9s145ms 31s59ms 13s993ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 14 12 1 11s1ms 11s1ms 14 1 9s326ms 9s326ms 15 1 31s59ms 31s59ms 16 1 9s434ms 9s434ms 17 1 9s145ms 9s145ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m9s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 13:00:23 Duration: 31s59ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 10:35:36 Duration: 11s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 14:34:47 Duration: 9s434ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 49s496ms 2 23s735ms 25s761ms 24s748ms select distinct (server_id) from gtp_log_ehcache;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 14 12 1 23s735ms 23s735ms 17 1 25s761ms 25s761ms [ User: a3dsupervisor - Total duration: 49s496ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s496ms - Times executed: 2 ]
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-10-14 15:42:46 Duration: 25s761ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-10-14 10:41:43 Duration: 23s735ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 48s390ms 3 6s117ms 24s925ms 16s130ms select count(?) from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 14 15 2 42s273ms 21s136ms 17 1 6s117ms 6s117ms [ User: a3dsupervisor - Total duration: 48s390ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s390ms - Times executed: 3 ]
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 13:13:14 Duration: 24s925ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 13:05:54 Duration: 17s347ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 15:45:38 Duration: 6s117ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 42s215ms 5 6s669ms 12s873ms 8s443ms 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 (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 14 12 1 12s873ms 12s873ms 14 1 7s123ms 7s123ms 15 1 6s707ms 6s707ms 16 1 6s669ms 6s669ms 17 1 8s842ms 8s842ms [ User: a3dsupervisor - Total duration: 42s215ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 42s215ms - Times executed: 5 ]
-
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('202001021042', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021042', '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-14 10:42:32 Duration: 12s873ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021543', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021543', '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-14 15:43:28 Duration: 8s842ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021258', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021258', '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-14 12:58:37 Duration: 7s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 36s240ms 1 36s240ms 36s240ms 36s240ms 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 #12
Day Hour Count Duration Avg duration Oct 14 20 1 36s240ms 36s240ms [ User: a3dsupervisor - Total duration: 36s240ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s240ms - 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-14 18:26:35 Duration: 36s240ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 35s472ms 1 35s472ms 35s472ms 35s472ms 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 #13
Day Hour Count Duration Avg duration Oct 14 20 1 35s472ms 35s472ms [ User: a3dsupervisor - Total duration: 35s472ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s472ms - 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-14 18:23:40 Duration: 35s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 31s665ms 4 5s765ms 10s529ms 7s916ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 14 12 1 9s66ms 9s66ms 15 1 6s303ms 6s303ms 16 1 5s765ms 5s765ms 17 1 10s529ms 10s529ms [ User: a3dsupervisor - Total duration: 31s665ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31s665ms - Times executed: 4 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 15:42:57 Duration: 10s529ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 10:41:52 Duration: 9s66ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 13:07:04 Duration: 6s303ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 31s228ms 1 31s228ms 31s228ms 31s228ms 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 #15
Day Hour Count Duration Avg duration Oct 14 20 1 31s228ms 31s228ms [ User: a3dsupervisor - Total duration: 31s228ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s228ms - 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-14 18:27:30 Duration: 31s228ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 27s456ms 1 27s456ms 27s456ms 27s456ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 14 20 1 27s456ms 27s456ms [ User: a3dsupervisor - Total duration: 27s456ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s456ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-14 18:24:51 Duration: 27s456ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 26s157ms 1 26s157ms 26s157ms 26s157ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 14 20 1 26s157ms 26s157ms [ User: a3dsupervisor - Total duration: 26s157ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s157ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-14 18:25:07 Duration: 26s157ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 24s799ms 1 24s799ms 24s799ms 24s799ms 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 #18
Day Hour Count Duration Avg duration Oct 14 20 1 24s799ms 24s799ms [ User: a3dsupervisor - Total duration: 24s799ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s799ms - 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-14 18:27:21 Duration: 24s799ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 24s554ms 1 24s554ms 24s554ms 24s554ms 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 #19
Day Hour Count Duration Avg duration Oct 14 20 1 24s554ms 24s554ms [ User: a3dsupervisor - Total duration: 24s554ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s554ms - 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-14 18:24:05 Duration: 24s554ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 23s141ms 1 23s141ms 23s141ms 23s141ms 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 #20
Day Hour Count Duration Avg duration Oct 14 20 1 23s141ms 23s141ms [ User: a3dsupervisor - Total duration: 23s141ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s141ms - 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-14 18:25:46 Duration: 23s141ms 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 11 6m22s 5s73ms 3m33s 34s797ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 14 08 6 35s633ms 5s938ms 09 1 5s254ms 5s254ms 17 3 5m35s 1m51s 21 1 6s574ms 6s574ms [ User: a3dsupervisor - Total duration: 6m22s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m22s - Times executed: 11 ]
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 3m33s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 1m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 15s567ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 7 4m55s 15s28ms 1m15s 42s155ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 14 10 1 17s850ms 17s850ms 12 1 50s528ms 50s528ms 15 2 1m28s 44s341ms 16 1 1m15s 1m15s 17 1 47s46ms 47s46ms 20 1 15s28ms 15s28ms [ User: a3dsupervisor - Total duration: 4m55s - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m55s - Times executed: 7 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 14:44:09 Duration: 1m15s 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-14 13:14:22 Duration: 1m8s 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-14 10:45:51 Duration: 50s528ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5 1m9s 9s145ms 31s59ms 13s993ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 12 1 11s1ms 11s1ms 14 1 9s326ms 9s326ms 15 1 31s59ms 31s59ms 16 1 9s434ms 9s434ms 17 1 9s145ms 9s145ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m9s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 13:00:23 Duration: 31s59ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 10:35:36 Duration: 11s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 14:34:47 Duration: 9s434ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 5 42s215ms 6s669ms 12s873ms 8s443ms 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 (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 14 12 1 12s873ms 12s873ms 14 1 7s123ms 7s123ms 15 1 6s707ms 6s707ms 16 1 6s669ms 6s669ms 17 1 8s842ms 8s842ms [ User: a3dsupervisor - Total duration: 42s215ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 42s215ms - Times executed: 5 ]
-
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('202001021042', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021042', '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-14 10:42:32 Duration: 12s873ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021543', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021543', '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-14 15:43:28 Duration: 8s842ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021258', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021258', '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-14 12:58:37 Duration: 7s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 4 14m46s 3m24s 4m 3m41s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 14 12 1 4m 4m 14 1 3m24s 3m24s 16 1 3m39s 3m39s 17 1 3m42s 3m42s [ User: a3dsupervisor - Total duration: 14m46s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m46s - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 10:39:48 Duration: 4m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 15:41:11 Duration: 3m42s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 14:38:26 Duration: 3m39s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 4 31s665ms 5s765ms 10s529ms 7s916ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 12 1 9s66ms 9s66ms 15 1 6s303ms 6s303ms 16 1 5s765ms 5s765ms 17 1 10s529ms 10s529ms [ User: a3dsupervisor - Total duration: 31s665ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31s665ms - Times executed: 4 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 15:42:57 Duration: 10s529ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 10:41:52 Duration: 9s66ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 13:07:04 Duration: 6s303ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 3 48s390ms 6s117ms 24s925ms 16s130ms select count(?) from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 14 15 2 42s273ms 21s136ms 17 1 6s117ms 6s117ms [ User: a3dsupervisor - Total duration: 48s390ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s390ms - Times executed: 3 ]
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 13:13:14 Duration: 24s925ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 13:05:54 Duration: 17s347ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 15:45:38 Duration: 6s117ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 2 6m26s 2m38s 3m47s 3m13s insert into batch_scenario_run (creation_date, creator_num_id, end_date, modification_date, modifier_num_id, batch_scenario_num_id, start_date, state, status, batch_scenario_run_id) values (,,,,,,,,,);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 14 14 1 2m38s 2m38s 15 1 3m47s 3m47s [ User: a3dsupervisor - Total duration: 6m26s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m26s - Times executed: 2 ]
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 13:05:36 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 12:56:25 Duration: 2m38s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 2 49s496ms 23s735ms 25s761ms 24s748ms select distinct (server_id) from gtp_log_ehcache;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 14 12 1 23s735ms 23s735ms 17 1 25s761ms 25s761ms [ User: a3dsupervisor - Total duration: 49s496ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s496ms - Times executed: 2 ]
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-10-14 15:42:46 Duration: 25s761ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-10-14 10:41:43 Duration: 23s735ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 2 13s294ms 6s607ms 6s687ms 6s647ms 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;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 14 12 1 6s607ms 6s607ms 17 1 6s687ms 6s687ms [ User: a3dsupervisor - Total duration: 13s294ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 13s294ms - Times executed: 2 ]
-
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;
Date: 2025-10-14 15:43:37 Duration: 6s687ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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;
Date: 2025-10-14 10:42:46 Duration: 6s607ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 2 10s684ms 5s138ms 5s546ms 5s342ms select * from pack_gtp_dba.f_test_p_anonymize_att_value (,,,,,,) as result;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 14 15 2 10s684ms 5s342ms [ User: a3dsupervisor - Total duration: 10s684ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s684ms - Times executed: 2 ]
-
select * from pack_gtp_dba.f_test_p_anonymize_att_value (,,,,,,) as result;
Date: 2025-10-14 13:00:40 Duration: 5s546ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select * from pack_gtp_dba.f_test_p_anonymize_att_value (,,,,,,) as result;
Date: 2025-10-14 13:00:34 Duration: 5s138ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 1 3m5s 3m5s 3m5s 3m5s delete from gtp_log_connection where log_date <;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 14 15 1 3m5s 3m5s [ User: a3dsupervisor - Total duration: 3m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m5s - Times executed: 1 ]
-
delete from GTP_LOG_CONNECTION where LOG_DATE <;
Date: 2025-10-14 13:05:36 Duration: 3m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 1 2m20s 2m20s 2m20s 2m20s vacuum analyse;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 14 20 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: psql - Total duration: 2m20s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-14 18:42:13 Duration: 2m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1 1m19s 1m19s 1m19s 1m19s 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 #14
Day Hour Count Duration Avg duration Oct 14 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - 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-14 18:24:24 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 36s240ms 36s240ms 36s240ms 36s240ms 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 #15
Day Hour Count Duration Avg duration Oct 14 20 1 36s240ms 36s240ms [ User: a3dsupervisor - Total duration: 36s240ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s240ms - 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-14 18:26:35 Duration: 36s240ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 35s472ms 35s472ms 35s472ms 35s472ms 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 #16
Day Hour Count Duration Avg duration Oct 14 20 1 35s472ms 35s472ms [ User: a3dsupervisor - Total duration: 35s472ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s472ms - 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-14 18:23:40 Duration: 35s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 31s228ms 31s228ms 31s228ms 31s228ms 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 #17
Day Hour Count Duration Avg duration Oct 14 20 1 31s228ms 31s228ms [ User: a3dsupervisor - Total duration: 31s228ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s228ms - 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-14 18:27:30 Duration: 31s228ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 27s456ms 27s456ms 27s456ms 27s456ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 14 20 1 27s456ms 27s456ms [ User: a3dsupervisor - Total duration: 27s456ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s456ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-14 18:24:51 Duration: 27s456ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 26s157ms 26s157ms 26s157ms 26s157ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 14 20 1 26s157ms 26s157ms [ User: a3dsupervisor - Total duration: 26s157ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s157ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-14 18:25:07 Duration: 26s157ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 24s799ms 24s799ms 24s799ms 24s799ms 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 #20
Day Hour Count Duration Avg duration Oct 14 20 1 24s799ms 24s799ms [ User: a3dsupervisor - Total duration: 24s799ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s799ms - 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-14 18:27:21 Duration: 24s799ms 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 3m24s 4m 3m41s 4 14m46s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 14 12 1 4m 4m 14 1 3m24s 3m24s 16 1 3m39s 3m39s 17 1 3m42s 3m42s [ User: a3dsupervisor - Total duration: 14m46s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m46s - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 10:39:48 Duration: 4m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 15:41:11 Duration: 3m42s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 14:38:26 Duration: 3m39s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m38s 3m47s 3m13s 2 6m26s insert into batch_scenario_run (creation_date, creator_num_id, end_date, modification_date, modifier_num_id, batch_scenario_num_id, start_date, state, status, batch_scenario_run_id) values (,,,,,,,,,);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 14 14 1 2m38s 2m38s 15 1 3m47s 3m47s [ User: a3dsupervisor - Total duration: 6m26s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m26s - Times executed: 2 ]
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 13:05:36 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 12:56:25 Duration: 2m38s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 3m5s 3m5s 3m5s 1 3m5s delete from gtp_log_connection where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 15 1 3m5s 3m5s [ User: a3dsupervisor - Total duration: 3m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m5s - Times executed: 1 ]
-
delete from GTP_LOG_CONNECTION where LOG_DATE <;
Date: 2025-10-14 13:05:36 Duration: 3m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 2m20s 2m20s 2m20s 1 2m20s vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 14 20 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: psql - Total duration: 2m20s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-14 18:42:13 Duration: 2m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1m19s 1m19s 1m19s 1 1m19s 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 #5
Day Hour Count Duration Avg duration Oct 14 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - 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-14 18:24:24 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 15s28ms 1m15s 42s155ms 7 4m55s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 10 1 17s850ms 17s850ms 12 1 50s528ms 50s528ms 15 2 1m28s 44s341ms 16 1 1m15s 1m15s 17 1 47s46ms 47s46ms 20 1 15s28ms 15s28ms [ User: a3dsupervisor - Total duration: 4m55s - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m55s - Times executed: 7 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 14:44:09 Duration: 1m15s 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-14 13:14:22 Duration: 1m8s 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-14 10:45:51 Duration: 50s528ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 36s240ms 36s240ms 36s240ms 1 36s240ms 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 14 20 1 36s240ms 36s240ms [ User: a3dsupervisor - Total duration: 36s240ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s240ms - 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-14 18:26:35 Duration: 36s240ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 35s472ms 35s472ms 35s472ms 1 35s472ms 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 14 20 1 35s472ms 35s472ms [ User: a3dsupervisor - Total duration: 35s472ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s472ms - 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-14 18:23:40 Duration: 35s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5s73ms 3m33s 34s797ms 11 6m22s commit;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 14 08 6 35s633ms 5s938ms 09 1 5s254ms 5s254ms 17 3 5m35s 1m51s 21 1 6s574ms 6s574ms [ User: a3dsupervisor - Total duration: 6m22s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m22s - Times executed: 11 ]
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 3m33s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 1m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 15s567ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 31s228ms 31s228ms 31s228ms 1 31s228ms 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 14 20 1 31s228ms 31s228ms [ User: a3dsupervisor - Total duration: 31s228ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s228ms - 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-14 18:27:30 Duration: 31s228ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 27s456ms 27s456ms 27s456ms 1 27s456ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 14 20 1 27s456ms 27s456ms [ User: a3dsupervisor - Total duration: 27s456ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s456ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-14 18:24:51 Duration: 27s456ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 26s157ms 26s157ms 26s157ms 1 26s157ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 14 20 1 26s157ms 26s157ms [ User: a3dsupervisor - Total duration: 26s157ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s157ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-14 18:25:07 Duration: 26s157ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 24s799ms 24s799ms 24s799ms 1 24s799ms 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 #13
Day Hour Count Duration Avg duration Oct 14 20 1 24s799ms 24s799ms [ User: a3dsupervisor - Total duration: 24s799ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s799ms - 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-14 18:27:21 Duration: 24s799ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 23s735ms 25s761ms 24s748ms 2 49s496ms select distinct (server_id) from gtp_log_ehcache;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 14 12 1 23s735ms 23s735ms 17 1 25s761ms 25s761ms [ User: a3dsupervisor - Total duration: 49s496ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s496ms - Times executed: 2 ]
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-10-14 15:42:46 Duration: 25s761ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-10-14 10:41:43 Duration: 23s735ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 24s554ms 24s554ms 24s554ms 1 24s554ms 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 #15
Day Hour Count Duration Avg duration Oct 14 20 1 24s554ms 24s554ms [ User: a3dsupervisor - Total duration: 24s554ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s554ms - 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-14 18:24:05 Duration: 24s554ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 23s141ms 23s141ms 23s141ms 1 23s141ms 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 #16
Day Hour Count Duration Avg duration Oct 14 20 1 23s141ms 23s141ms [ User: a3dsupervisor - Total duration: 23s141ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s141ms - 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-14 18:25:46 Duration: 23s141ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 6s117ms 24s925ms 16s130ms 3 48s390ms select count(?) from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 14 15 2 42s273ms 21s136ms 17 1 6s117ms 6s117ms [ User: a3dsupervisor - Total duration: 48s390ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s390ms - Times executed: 3 ]
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 13:13:14 Duration: 24s925ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 13:05:54 Duration: 17s347ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT count(1) FROM GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 15:45:38 Duration: 6s117ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 9s145ms 31s59ms 13s993ms 5 1m9s call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 14 12 1 11s1ms 11s1ms 14 1 9s326ms 9s326ms 15 1 31s59ms 31s59ms 16 1 9s434ms 9s434ms 17 1 9s145ms 9s145ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m9s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 13:00:23 Duration: 31s59ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 10:35:36 Duration: 11s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 14:34:47 Duration: 9s434ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 6s669ms 12s873ms 8s443ms 5 42s215ms 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 (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 14 12 1 12s873ms 12s873ms 14 1 7s123ms 7s123ms 15 1 6s707ms 6s707ms 16 1 6s669ms 6s669ms 17 1 8s842ms 8s842ms [ User: a3dsupervisor - Total duration: 42s215ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 42s215ms - Times executed: 5 ]
-
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('202001021042', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021042', '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-14 10:42:32 Duration: 12s873ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021543', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021543', '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-14 15:43:28 Duration: 8s842ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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('202001021258', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021258', '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-14 12:58:37 Duration: 7s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s765ms 10s529ms 7s916ms 4 31s665ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 14 12 1 9s66ms 9s66ms 15 1 6s303ms 6s303ms 16 1 5s765ms 5s765ms 17 1 10s529ms 10s529ms [ User: a3dsupervisor - Total duration: 31s665ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31s665ms - Times executed: 4 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 15:42:57 Duration: 10s529ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 10:41:52 Duration: 9s66ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-14 13:07:04 Duration: 6s303ms 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 NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 4,893 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 1965 ERROR entries
- 70 WARNING entries
Most Frequent Errors/Events
Key values
- 1,628 Max number of times the same event was reported
- 2,037 Total events found
Rank Times reported Error 1 1,628 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 14 21 101 22 740 23 89 00 670 01 28 2 195 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 14 12 39 14 5 15 73 16 39 17 39 3 40 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 14 12 8 14 8 15 8 16 8 17 8 4 30 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 14 12 6 14 6 15 6 16 6 17 6 5 17 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 14 11 4 14 4 15 2 16 2 17 2 19 3 6 10 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 14 12 2 14 2 15 2 16 2 17 2 7 6 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 14 14 1 15 1 17 4 8 5 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 #8
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 9 5 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 #9
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 10 5 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 #10
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 11 5 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 #11
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 12 5 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 #12
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 13 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 14 5 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 15 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #15
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 16 5 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 17 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 18 5 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 19 5 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #19
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 20 5 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #20
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 21 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #21
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 22 5 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 #22
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 23 5 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #23
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 24 5 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #24
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 25 3 LOG: process ... still waiting for ShareLock on transaction ... after ... msinsert into BATCH_SCENARIO_RUN (...) values (...)
Times Reported Most Frequent Error / Event #25
Day Hour Count Oct 14 14 2 15 1 26 3 LOG: process ... still waiting for ShareLock on transaction ... after ... msCOMMIT
Times Reported Most Frequent Error / Event #26
Day Hour Count Oct 14 17 3 27 2 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #27
Day Hour Count Oct 14 15 2 28 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msdelete from GTP_LOG_CONNECTION where LOG_DATE <
Times Reported Most Frequent Error / Event #28
Day Hour Count Oct 14 15 2 29 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #29
Day Hour Count Oct 14 20 1 30 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #30
Day Hour Count Oct 14 20 1 31 1 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #31
Day Hour Count Oct 14 20 1 32 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #32
Day Hour Count Oct 14 20 1 33 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #33
Day Hour Count Oct 14 20 1 34 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 #34
Day Hour Count Oct 14 20 1 35 1 ERROR: deadlock detectedcall pack_gtp_dba.p_anonymize_dcp()
Times Reported Most Frequent Error / Event #35
Day Hour Count Oct 14 15 1 - ERROR: deadlock detectedcall pack_gtp_dba.p_anonymize_dcp()
Date: 2025-10-14 13:05:36 Database: autotest_feat_batch Application: PostgreSQL JDBC Driver User: a3dsupervisor Remote: 10.3.0.4
36 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 #36
Day Hour Count Oct 14 20 1 37 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #37
Day Hour Count Oct 14 20 1 38 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msCREATE STATISTICS public.stat_dep_obj_compo_att (...) ON att_template_category_num_id, att_template_num_id FROM public.gtp_obj_composition
Times Reported Most Frequent Error / Event #38
Day Hour Count Oct 14 20 1 39 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 #39
Day Hour Count Oct 14 20 1 40 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 #40
Day Hour Count Oct 14 20 1 41 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 #41
Day Hour Count Oct 14 20 1 42 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msUPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =
Times Reported Most Frequent Error / Event #42
Day Hour Count Oct 14 14 1 43 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 #43
Day Hour Count Oct 14 20 1 44 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 #44
Day Hour Count Oct 14 20 1