pgBadger-
Global information
- Generated on Wed Oct 1 09:05:40 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=30/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=30/h=23/m=00/PT1H.log
- Parsed 5,125 log entries in 52s
- Log start from 2025-09-30 07:58:01 to 2025-09-30 22:45:23
-
Overview
Global Stats
- 74 Number of unique normalized queries
- 88 Number of queries
- 1h4m42s Total query duration
- 2025-09-30 00:01:21 First query
- 2025-09-30 18:54:25 Last query
- 2 queries/s at 2025-09-30 18:40:07 Query peak
- 1h4m42s Total query duration
- 6s Prepare/parse total duration
- 0ms Bind total duration
- 1h4m36s Execute total duration
- 1,077 Number of events
- 40 Number of unique normalized events
- 866 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
- 301 Number temporary file
- 701.45 MiB Max size of temporary file
- 15.86 MiB Average size of temporary file
- 829 Total number of sessions
- 30 sessions at 2025-09-30 12:15:08 Session peak
- 5d13h18m10s Total duration of sessions
- 9m38s Average duration of sessions
- 0 Average queries per session
- 4s683ms Average queries duration per session
- 9m34s Average idle time per session
- 827 Total number of connections
- 10 connections/s at 2025-09-30 18:55:13 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-30 18:40:07 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-09-30 07:50:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-30 18:40:07 Date
Queries duration
Key values
- 1h4m42s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 30 00 1 0ms 5s398ms 5s398ms 0ms 5s398ms 5s398ms 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 4 0ms 11s590ms 6s998ms 5s409ms 5s989ms 11s590ms 07 9 0ms 4m24s 1m4s 14s367ms 27s614ms 8m2s 08 6 0ms 8m56s 2m12s 11s897ms 1m3s 11m27s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 8 0ms 4m14s 1m10s 9s122ms 56s884ms 7m50s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 8 0ms 4m1s 47s80ms 9s234ms 1m14s 4m20s 13 6 0ms 4m4s 59s191ms 9s200ms 1m5s 4m25s 14 8 0ms 4m43s 51s194ms 20s495ms 53s581ms 4m43s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 38 0ms 2m23s 20s129ms 1m37s 2m23s 2m35s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 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) Sep 30 00 1 0 5s398ms 0ms 0ms 5s398ms 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 3 0 15s128ms 0ms 0ms 22s87ms 08 2 0 5s948ms 0ms 0ms 11s897ms 09 0 0 0ms 0ms 0ms 0ms 10 4 0 14s974ms 0ms 7s533ms 32s879ms 11 0 0 0ms 0ms 0ms 0ms 12 5 0 10s184ms 0ms 0ms 26s471ms 13 3 0 12s6ms 0ms 6s969ms 21s331ms 14 5 0 12s562ms 0ms 14s378ms 20s495ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 30 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 11s590ms 0ms 0ms 0ms 07 0 1 1 0 18s85ms 0ms 0ms 8s555ms 08 0 0 3 0 3m30s 0ms 0ms 1m3s 09 0 0 0 0 0ms 0ms 0ms 0ms 10 1 0 1 0 1m59s 0ms 0ms 56s884ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 1 0 1m14s 0ms 0ms 0ms 13 0 0 1 0 1m5s 0ms 0ms 0ms 14 0 0 1 0 53s581ms 0ms 0ms 53s581ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 6 32s973ms 0ms 0ms 58s410ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 30 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 4 4.00 33.33% 07 0 9 9.00 0.00% 08 0 6 6.00 0.00% 09 0 0 0.00 0.00% 10 0 8 8.00 0.00% 11 0 0 0.00 0.00% 12 0 8 8.00 0.00% 13 0 6 6.00 0.00% 14 0 8 8.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 30 00 25 0.01/s 01 18 0.01/s 02 15 0.00/s 03 22 0.01/s 04 12 0.00/s 05 23 0.01/s 06 30 0.01/s 07 68 0.02/s 08 43 0.01/s 09 84 0.02/s 10 46 0.01/s 11 21 0.01/s 12 69 0.02/s 13 52 0.01/s 14 36 0.01/s 15 15 0.00/s 16 22 0.01/s 17 32 0.01/s 18 63 0.02/s 19 22 0.01/s 20 27 0.01/s 21 18 0.01/s 22 41 0.01/s 23 23 0.01/s Day Hour Count Average Duration Average idle time Sep 30 00 27 2m47s 2m47s 01 18 2m50s 2m50s 02 15 6m55s 6m55s 03 22 4m7s 4m7s 04 12 5m41s 5m41s 05 23 3m7s 3m7s 06 29 3m5s 3m4s 07 61 1m28s 1m19s 08 45 10m47s 10m29s 09 84 3m2s 3m2s 10 47 7m29s 7m17s 11 18 15m5s 15m5s 12 72 2m56s 2m51s 13 51 3m45s 3m38s 14 33 8m24s 8m11s 15 24 1h13m39s 1h13m39s 16 22 5m24s 5m24s 17 30 1h30m33s 1h30m33s 18 65 3m16s 3m5s 19 22 4m4s 4m4s 20 25 3m38s 3m38s 21 20 3m43s 3m43s 22 39 4m6s 4m6s 23 25 3m9s 3m9s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-09-30 18:55:13 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 827 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 827 connections Total
-
Sessions
Simultaneous sessions
Key values
- 30 sessions Session Peak
- 2025-09-30 12:15:08 Date
Histogram of session times
Key values
- 603 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 829 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 829 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 829 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 829 sessions Total
Application Count Total Duration Average Duration DBeaver 24.2.1 - Main 'autotest_feat_batch' 1 7h52m47s 7h52m47s DBeaver 24.2.1 - Metadata 'autotest_feat_batch' 1 7h52m46s 7h52m46s DBeaver 24.2.1 - SQLEditor 'Script-420.sql' 1 7h52m44s 7h52m44s DBeaver 24.2.1 - View Lock item 8 2s309ms 288ms DBeaver 24.2.1 - View Locks 1 296ms 296ms DBeaver 24.2.1 - View sessions 1 275ms 275ms IntelliJ IDEA 2024.3.5 6 4h1m42s 40m17s PostgreSQL JDBC Driver 752 4d9h3m7s 8m22s [unknown] 49 5s192ms 105ms pg_restore 4 32m30s 8m7s psql 5 2m23s 28s735ms -
Temporary Files
Size of temporary files
Key values
- 252.98 MiB Temp Files size Peak
- 2025-09-30 18:38:50 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-09-30 18:42:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 30 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 10 28.40 MiB 2.84 MiB 08 18 89.14 MiB 4.95 MiB 09 3 12.56 MiB 4.19 MiB 10 25 106.89 MiB 4.28 MiB 11 1 4.19 MiB 4.19 MiB 12 25 106.96 MiB 4.28 MiB 13 25 106.89 MiB 4.28 MiB 14 25 106.92 MiB 4.28 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 169 4.11 GiB 24.93 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 38 220.17 MiB 2.32 MiB 28.92 MiB 5.79 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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-30 10:35:20 Duration: 10s361ms 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('202001021436', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021436', '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-09-30 14:36:15 Duration: 8s633ms 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('202001021250', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021250', '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-09-30 12:50:48 Duration: 7s667ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 19 59.21 MiB 2.24 MiB 13.59 MiB 3.12 MiB select goc.obj_num_id from gtp_obj_composition goc where position(? in goc.obj_compo_value) <> ?;-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;
Date: 2025-09-30 14:35:50 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 4 22.70 MiB 2.56 MiB 8.79 MiB 5.68 MiB select count(*) from gtp_obj_rel_vt;-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 10:32:57 Duration: 32s879ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 13:35:59 Duration: 21s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 14:34:02 Duration: 20s495ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
4 3 185.70 MiB 29.19 MiB 125.20 MiB 61.90 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-09-30 18:39:56 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 107.51 MiB 11.43 MiB 84.54 MiB 35.84 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-09-30 18:41:40 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 47.66 MiB 3.41 MiB 40.48 MiB 15.89 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-09-30 18:38:57 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 510.47 MiB 20.72 MiB 468.77 MiB 170.16 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-09-30 18:39:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 17.72 MiB 3.85 MiB 7.69 MiB 5.91 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-09-30 18:38:51 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 524.97 MiB 11.51 MiB 486.97 MiB 174.99 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-09-30 18:40:23 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 778.55 MiB 37.95 MiB 701.45 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-09-30 18:36:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 745.24 MiB 119.23 MiB 491.98 MiB 248.41 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-09-30 18:37:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 78.82 MiB 17.80 MiB 41.02 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-09-30 18:41:51 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3 13.14 MiB 3.31 MiB 4.92 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-09-30 18:42:20 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3 92.04 MiB 22.27 MiB 36.48 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-09-30 18:41:25 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3 56.32 MiB 3.73 MiB 46.62 MiB 18.77 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-09-30 18:42:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 670.66 MiB 670.66 MiB 670.66 MiB 670.66 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-09-30 18:37:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 67.88 MiB 67.88 MiB 67.88 MiB 67.88 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-09-30 18:41:55 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 178.09 MiB 178.09 MiB 178.09 MiB 178.09 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-09-30 18:40:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 12.87 MiB 12.87 MiB 12.87 MiB 12.87 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-09-30 18:42:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 27.82 MiB 27.82 MiB 27.82 MiB 27.82 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-09-30 18:38:54 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 701.45 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-30 18:36:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 670.66 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-09-30 18:37:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 491.98 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-09-30 18:37:59 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 486.97 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-30 18:40:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 468.77 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-30 18:39:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 178.09 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-09-30 18:40:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 134.03 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-09-30 18:38:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 125.20 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-30 18:39:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 119.23 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-09-30 18:38:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 84.54 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-09-30 18:41:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 67.88 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-09-30 18:41:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 46.62 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-09-30 18:42:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 41.02 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2025-09-30 18:41:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 40.48 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-09-30 18:38:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 39.16 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-30 18:37:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 37.95 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-30 18:37:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 36.48 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-09-30 18:41:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 33.28 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-09-30 18:41:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 31.31 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-30 18:40:07 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 29.19 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-30 18:40:07 - 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 Sep 30 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
- 6 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
- 23 Total read queries
- 52 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 88 Requests
- 1h4m36s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 88 Requests
User Request type Count Duration a3dsupervisor Total 88 1h4m36s copy from 6 3m17s ddl 30 6m57s delete 8 15m8s insert 1 3m2s others 13 28m25s select 23 4m32s tcl 5 2m52s update 2 20s146ms Duration by user
Key values
- 1h4m36s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 88 1h4m36s copy from 6 3m17s ddl 30 6m57s delete 8 15m8s insert 1 3m2s others 13 28m25s select 23 4m32s tcl 5 2m52s update 2 20s146ms Queries by host
Key values
- 10.3.0.4 Main host
- 88 Requests
- 1h4m36s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 49 Requests
- 48m13s (PostgreSQL JDBC Driver)
- Main time consuming application
Application Request type Count Duration DBeaver 24.2.1 - SQLEditor 'Script-420.sql' Total 1 3m37s others 1 3m37s PostgreSQL JDBC Driver Total 49 48m13s delete 8 15m8s insert 1 3m2s others 11 22m23s select 23 4m32s tcl 4 2m46s update 2 20s146ms pg_restore Total 37 10m21s copy from 6 3m17s ddl 30 6m57s tcl 1 6s3ms psql Total 1 2m23s others 1 2m23s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-30 15:45:02 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 8m56s delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;[ Date: 2025-09-30 08:17:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 4m43s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 14:33:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 4m24s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 07:58:00 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 4m14s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 10:32:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 4m4s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 13:35:28 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 4m1s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-30 12:48:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 3m37s --liquibase formatted sql--changeset active3d:7.22.0.0-postgresql-optional-ACTIVE3D_RQM-17843_init_batch_process dbms:postgresql encoding:UTF-8 endDelimiter:/DO $body$DECLARE L_SCRIPT_NAME CONSTANT TEXT := 'ACTIVE3D_RQM-17843_init_batch_process';BEGIN raise debug 'START %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [START]', '7.22.0.0'); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval('s_batch_group_num_id') into l_grpId; select nextval('s_batch_scenario_num_id') into l_scnId; select nextval('s_batch_process_num_id') into l_processId; select nextval('s_batch_process_num_id') into l_processId_2; select nextval('s_mapping_num_id') into l_mappingId; select nextval('s_mapping_num_id') into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId, '02.01_batch01', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch01'); INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId2, '02.01_batch02', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch02'); INSERT INTO batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_grpId, '02_group', '02_group', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_scnId, l_grpId, '02_scenario_01', '02_scenario_01', '', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId, l_scnId, '02.01_batch01', '02.01_batch01', 8, 1, '', '{"mappingNumId":'||l_mappingId||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId_2, l_scnId, '02.01_batch02', '02.01_batch02', 8, 2, '', '{"mappingNumId":'||l_mappingId2||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); EXCEPTION WHEN OTHERS THEN RAISE EXCEPTION 'Erreur: %', SQLERRM; ROLLBACK; END; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET validated = true WHERE type = 'postInstallation' AND name = L_SCRIPT_NAME AND RELEASE = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [SUCCESS]', '7.22.0.0'); raise notice 'END %', L_SCRIPT_NAME;EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [ERROR]', '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.22.0.0'); RAISE;END $body$;[ Date: 2025-09-30 07:58:00 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' - Bind query: yes ]
8 3m2s insert into BATCH_PROCESS (BATCH_PROCESS_COMMENT, CREATION_DATE, CREATOR_NUM_ID, BATCH_PROCESS_EXECUTION_ORDER, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_PROCESS_NAME, BATCH_SCENARIO_NUM_ID, BATCH_PROCESS_SETTINGS, BATCH_PROCESS_TYPE_CODE, BATCH_PROCESS_UNIQUE_CODE, BATCH_PROCESS_NUM_ID) values (,,,,,,,,,,,);[ Date: 2025-09-30 10:32:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 2m30s COMMIT;[ Date: 2025-09-30 08:17:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 2m23s VACUUM ANALYSE;[ Date: 2025-09-30 18:54:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 1m16s 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-09-30 18:36:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 1m14s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-30 12:54:14 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 1m5s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-30 13:41:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 1m3s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-30 08:03:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 56s884ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-30 10:38:28 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 53s581ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-30 14:39:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 38s659ms 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-09-30 18:38:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 35s641ms 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-09-30 18:35:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 35s105ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-09-30 18:37:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 33s862ms 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-09-30 18:39:48 - 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 21m30s 5 4m1s 4m43s 4m18s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 30 09 1 4m24s 4m24s 12 1 4m14s 4m14s 14 1 4m1s 4m1s 15 1 4m4s 4m4s 16 1 4m43s 4m43s [ User: a3dsupervisor - Total duration: 21m30s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21m30s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-30 14:33:34 Duration: 4m43s 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-09-30 07:58:00 Duration: 4m24s 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-09-30 10:32:17 Duration: 4m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 8m56s 1 8m56s 8m56s 8m56s delete from gtp_workspace where workspace_num_id =;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 30 10 1 8m56s 8m56s [ User: a3dsupervisor - Total duration: 8m56s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m56s - Times executed: 1 ]
-
delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;
Date: 2025-09-30 08:17:13 Duration: 8m56s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5m41s 6 27s614ms 1m14s 56s973ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 30 09 1 27s614ms 27s614ms 10 1 1m3s 1m3s 12 1 56s884ms 56s884ms 14 1 1m14s 1m14s 15 1 1m5s 1m5s 16 1 53s581ms 53s581ms [ User: a3dsupervisor - Total duration: 5m41s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m41s - Times executed: 6 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-30 12:54:14 Duration: 1m14s 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-09-30 13:41:12 Duration: 1m5s 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-09-30 08:03:34 Duration: 1m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 3m37s 1 3m37s 3m37s 3m37s --liquibase formatted sql--changeset active3d:?.?.?.?-postgresql-optional-active3d_rqm-17843_init_batch_process dbms:postgresql encoding:utf-8 enddelimiter:/do $body$declare l_script_name constant text := ?;begin raise debug ?, l_script_name; -- ne pas supprimer cette ligne : initialisation de la validation du passage du script de post-installation insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); declare l_grpid integer; l_scnid integer; l_processid integer; l_processid_2 integer; l_mappingid integer; l_mappingid2 integer; begin select nextval(?) into l_grpid; select nextval(?) into l_scnid; select nextval(?) into l_processid; select nextval(?) into l_processid_2; select nextval(?) into l_mappingid; select nextval(?) into l_mappingid2; update gtp_workspace set workspace_name_fr = ?; insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid2, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_grpid, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_scnid, l_grpid, ?, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid||?, current_timestamp, ?, null, null); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid_2, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid2||?, current_timestamp, ?, null, null); exception when others then raise exception ?, sqlerrm; rollback; end; -- ne pas supprimer cette ligne : validation du passage du script de post-installation update a3d_migration_tracking set validated = true where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); raise notice ?, l_script_name;exception when others then call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); call pack_gtp_utils.p_trace_error(? || l_script_name, sqlerrm, ?); raise;end $body$;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 30 09 1 3m37s 3m37s [ User: a3dsupervisor - Total duration: 3m37s - Times executed: 1 ]
[ Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' - Total duration: 3m37s - Times executed: 1 ]
-
--liquibase formatted sql--changeset active3d:7.22.0.0-postgresql-optional-ACTIVE3D_RQM-17843_init_batch_process dbms:postgresql encoding:UTF-8 endDelimiter:/DO $body$DECLARE L_SCRIPT_NAME CONSTANT TEXT := 'ACTIVE3D_RQM-17843_init_batch_process';BEGIN raise debug 'START %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [START]', '7.22.0.0'); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval('s_batch_group_num_id') into l_grpId; select nextval('s_batch_scenario_num_id') into l_scnId; select nextval('s_batch_process_num_id') into l_processId; select nextval('s_batch_process_num_id') into l_processId_2; select nextval('s_mapping_num_id') into l_mappingId; select nextval('s_mapping_num_id') into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId, '02.01_batch01', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch01'); INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId2, '02.01_batch02', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch02'); INSERT INTO batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_grpId, '02_group', '02_group', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_scnId, l_grpId, '02_scenario_01', '02_scenario_01', '', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId, l_scnId, '02.01_batch01', '02.01_batch01', 8, 1, '', '{"mappingNumId":'||l_mappingId||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId_2, l_scnId, '02.01_batch02', '02.01_batch02', 8, 2, '', '{"mappingNumId":'||l_mappingId2||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); EXCEPTION WHEN OTHERS THEN RAISE EXCEPTION 'Erreur: %', SQLERRM; ROLLBACK; END; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET validated = true WHERE type = 'postInstallation' AND name = L_SCRIPT_NAME AND RELEASE = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [SUCCESS]', '7.22.0.0'); raise notice 'END %', L_SCRIPT_NAME;EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [ERROR]', '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.22.0.0'); RAISE;END $body$;
Date: 2025-09-30 07:58:00 Duration: 3m37s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' Bind query: yes
5 3m2s 1 3m2s 3m2s 3m2s insert into batch_process (batch_process_comment, creation_date, creator_num_id, batch_process_execution_order, modification_date, modifier_num_id, batch_process_name, batch_scenario_num_id, batch_process_settings, batch_process_type_code, batch_process_unique_code, batch_process_num_id) values (,,,,,,,,,,,);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 30 12 1 3m2s 3m2s [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m2s - Times executed: 1 ]
-
insert into BATCH_PROCESS (BATCH_PROCESS_COMMENT, CREATION_DATE, CREATOR_NUM_ID, BATCH_PROCESS_EXECUTION_ORDER, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_PROCESS_NAME, BATCH_SCENARIO_NUM_ID, BATCH_PROCESS_SETTINGS, BATCH_PROCESS_TYPE_CODE, BATCH_PROCESS_UNIQUE_CODE, BATCH_PROCESS_NUM_ID) values (,,,,,,,,,,,);
Date: 2025-09-30 10:32:17 Duration: 3m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 2m52s 5 5s4ms 2m30s 34s514ms commit;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 30 08 2 10s994ms 5s497ms 09 1 5s112ms 5s112ms 10 1 2m30s 2m30s 20 1 6s3ms 6s3ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m46s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6s3ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-09-30 08:17:13 Duration: 2m30s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-30 18:38:28 Duration: 6s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COMMIT;
Date: 2025-09-30 06:36:16 Duration: 5s989ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 2m23s 1 2m23s 2m23s 2m23s vacuum analyse;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 30 20 1 2m23s 2m23s [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 1 ]
[ Application: psql - Total duration: 2m23s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-30 18:54:25 Duration: 2m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 1m41s 5 7s533ms 32s879ms 20s268ms select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 30 12 2 40s412ms 20s206ms 14 1 19s103ms 19s103ms 15 1 21s331ms 21s331ms 16 1 20s495ms 20s495ms [ User: a3dsupervisor - Total duration: 1m41s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m41s - Times executed: 5 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 10:32:57 Duration: 32s879ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 13:35:59 Duration: 21s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 14:34:02 Duration: 20s495ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 1m16s 1 1m16s 1m16s 1m16s 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 #9
Day Hour Count Duration Avg duration Sep 30 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - 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-09-30 18:36:31 Duration: 1m16s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 48s595ms 5 7s717ms 11s888ms 9s719ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 30 09 1 8s930ms 8s930ms 12 1 9s122ms 9s122ms 14 1 10s937ms 10s937ms 15 1 7s717ms 7s717ms 16 1 11s888ms 11s888ms [ User: a3dsupervisor - Total duration: 48s595ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s595ms - Times executed: 5 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-30 14:35:44 Duration: 11s888ms 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-09-30 12:50:17 Duration: 10s937ms 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-09-30 10:34:46 Duration: 9s122ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 48s172ms 5 9s81ms 11s488ms 9s634ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 30 09 1 11s488ms 11s488ms 12 1 9s81ms 9s81ms 14 1 9s234ms 9s234ms 15 1 9s200ms 9s200ms 16 1 9s168ms 9s168ms [ User: a3dsupervisor - Total duration: 48s172ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s172ms - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-30 07:53:22 Duration: 11s488ms 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-09-30 12:44:05 Duration: 9s234ms 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-09-30 13:31:18 Duration: 9s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 39s856ms 5 6s224ms 10s361ms 7s971ms 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 #12
Day Hour Count Duration Avg duration Sep 30 10 1 6s224ms 6s224ms 12 1 10s361ms 10s361ms 14 1 7s667ms 7s667ms 15 1 6s969ms 6s969ms 16 1 8s633ms 8s633ms [ User: a3dsupervisor - Total duration: 39s856ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s856ms - 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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-30 10:35:20 Duration: 10s361ms 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('202001021436', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021436', '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-09-30 14:36:15 Duration: 8s633ms 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('202001021250', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021250', '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-09-30 12:50:48 Duration: 7s667ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 38s659ms 1 38s659ms 38s659ms 38s659ms 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 #13
Day Hour Count Duration Avg duration Sep 30 20 1 38s659ms 38s659ms [ User: a3dsupervisor - Total duration: 38s659ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s659ms - 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-09-30 18:38:51 Duration: 38s659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 36s465ms 2 14s378ms 22s87ms 18s232ms select goc.obj_compo_value from gtp_att_template gat inner join gtp_obj_composition goc on (gat.att_template_num_id = goc.att_template_num_id) inner join gtp_obj go on (goc.obj_num_id = go.obj_num_id) where gat.att_template_num_id = and go.obj_state is null and goc.obj_compo_value is not null group by goc.obj_compo_value having count(goc.obj_compo_value) > ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 30 09 1 22s87ms 22s87ms 16 1 14s378ms 14s378ms [ User: a3dsupervisor - Total duration: 36s465ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s465ms - Times executed: 2 ]
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-09-30 07:50:25 Duration: 22s87ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-09-30 14:25:54 Duration: 14s378ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 35s641ms 1 35s641ms 35s641ms 35s641ms 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 #15
Day Hour Count Duration Avg duration Sep 30 20 1 35s641ms 35s641ms [ User: a3dsupervisor - Total duration: 35s641ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s641ms - 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-09-30 18:35:51 Duration: 35s641ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 35s105ms 1 35s105ms 35s105ms 35s105ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 30 20 1 35s105ms 35s105ms [ User: a3dsupervisor - Total duration: 35s105ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s105ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-30 18:37:22 Duration: 35s105ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 33s862ms 1 33s862ms 33s862ms 33s862ms 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 Sep 30 20 1 33s862ms 33s862ms [ User: a3dsupervisor - Total duration: 33s862ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s862ms - 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-09-30 18:39:48 Duration: 33s862ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 30s227ms 1 30s227ms 30s227ms 30s227ms 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 Sep 30 20 1 30s227ms 30s227ms [ User: a3dsupervisor - Total duration: 30s227ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s227ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-30 18:37:01 Duration: 30s227ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 29s591ms 1 29s591ms 29s591ms 29s591ms delete from gtp_att_template_category where att_template_category_num_id =;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 30 10 1 29s591ms 29s591ms [ User: a3dsupervisor - Total duration: 29s591ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s591ms - Times executed: 1 ]
-
delete from GTP_ATT_TEMPLATE_CATEGORY where ATT_TEMPLATE_CATEGORY_NUM_ID =;
Date: 2025-09-30 08:07:37 Duration: 29s591ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 25s130ms 1 25s130ms 25s130ms 25s130ms 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 #20
Day Hour Count Duration Avg duration Sep 30 20 1 25s130ms 25s130ms [ User: a3dsupervisor - Total duration: 25s130ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s130ms - 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-09-30 18:36:16 Duration: 25s130ms 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 6 5m41s 27s614ms 1m14s 56s973ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 30 09 1 27s614ms 27s614ms 10 1 1m3s 1m3s 12 1 56s884ms 56s884ms 14 1 1m14s 1m14s 15 1 1m5s 1m5s 16 1 53s581ms 53s581ms [ User: a3dsupervisor - Total duration: 5m41s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m41s - Times executed: 6 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-30 12:54:14 Duration: 1m14s 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-09-30 13:41:12 Duration: 1m5s 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-09-30 08:03:34 Duration: 1m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5 21m30s 4m1s 4m43s 4m18s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 30 09 1 4m24s 4m24s 12 1 4m14s 4m14s 14 1 4m1s 4m1s 15 1 4m4s 4m4s 16 1 4m43s 4m43s [ User: a3dsupervisor - Total duration: 21m30s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21m30s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-30 14:33:34 Duration: 4m43s 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-09-30 07:58:00 Duration: 4m24s 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-09-30 10:32:17 Duration: 4m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5 2m52s 5s4ms 2m30s 34s514ms commit;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 30 08 2 10s994ms 5s497ms 09 1 5s112ms 5s112ms 10 1 2m30s 2m30s 20 1 6s3ms 6s3ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m46s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6s3ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-09-30 08:17:13 Duration: 2m30s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-30 18:38:28 Duration: 6s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COMMIT;
Date: 2025-09-30 06:36:16 Duration: 5s989ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 5 1m41s 7s533ms 32s879ms 20s268ms select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 30 12 2 40s412ms 20s206ms 14 1 19s103ms 19s103ms 15 1 21s331ms 21s331ms 16 1 20s495ms 20s495ms [ User: a3dsupervisor - Total duration: 1m41s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m41s - Times executed: 5 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 10:32:57 Duration: 32s879ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 13:35:59 Duration: 21s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 14:34:02 Duration: 20s495ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 5 48s595ms 7s717ms 11s888ms 9s719ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 30 09 1 8s930ms 8s930ms 12 1 9s122ms 9s122ms 14 1 10s937ms 10s937ms 15 1 7s717ms 7s717ms 16 1 11s888ms 11s888ms [ User: a3dsupervisor - Total duration: 48s595ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s595ms - Times executed: 5 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-30 14:35:44 Duration: 11s888ms 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-09-30 12:50:17 Duration: 10s937ms 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-09-30 10:34:46 Duration: 9s122ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 5 48s172ms 9s81ms 11s488ms 9s634ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 30 09 1 11s488ms 11s488ms 12 1 9s81ms 9s81ms 14 1 9s234ms 9s234ms 15 1 9s200ms 9s200ms 16 1 9s168ms 9s168ms [ User: a3dsupervisor - Total duration: 48s172ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s172ms - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-30 07:53:22 Duration: 11s488ms 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-09-30 12:44:05 Duration: 9s234ms 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-09-30 13:31:18 Duration: 9s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 5 39s856ms 6s224ms 10s361ms 7s971ms 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 #7
Day Hour Count Duration Avg duration Sep 30 10 1 6s224ms 6s224ms 12 1 10s361ms 10s361ms 14 1 7s667ms 7s667ms 15 1 6s969ms 6s969ms 16 1 8s633ms 8s633ms [ User: a3dsupervisor - Total duration: 39s856ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s856ms - 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('202001021035', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021035', '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-09-30 10:35:20 Duration: 10s361ms 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('202001021436', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021436', '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-09-30 14:36:15 Duration: 8s633ms 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('202001021250', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021250', '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-09-30 12:50:48 Duration: 7s667ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 2 36s465ms 14s378ms 22s87ms 18s232ms select goc.obj_compo_value from gtp_att_template gat inner join gtp_obj_composition goc on (gat.att_template_num_id = goc.att_template_num_id) inner join gtp_obj go on (goc.obj_num_id = go.obj_num_id) where gat.att_template_num_id = and go.obj_state is null and goc.obj_compo_value is not null group by goc.obj_compo_value having count(goc.obj_compo_value) > ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 30 09 1 22s87ms 22s87ms 16 1 14s378ms 14s378ms [ User: a3dsupervisor - Total duration: 36s465ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s465ms - Times executed: 2 ]
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-09-30 07:50:25 Duration: 22s87ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-09-30 14:25:54 Duration: 14s378ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 2 20s146ms 8s555ms 11s590ms 10s73ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 30 08 1 11s590ms 11s590ms 09 1 8s555ms 8s555ms [ User: a3dsupervisor - Total duration: 20s146ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 20s146ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-30 06:57:02 Duration: 11s590ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-30 07:04:41 Duration: 8s555ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 2 15s286ms 7s419ms 7s867ms 7s643ms select distinct (server_id) from gtp_log_ehcache;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 30 14 1 7s867ms 7s867ms 16 1 7s419ms 7s419ms [ User: a3dsupervisor - Total duration: 15s286ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s286ms - Times executed: 2 ]
-
select distinct (SERVER_ID) from GTP_LOG_EHCACHE;
Date: 2025-09-30 12:50:06 Duration: 7s867ms 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-09-30 14:35:32 Duration: 7s419ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 1 8m56s 8m56s 8m56s 8m56s delete from gtp_workspace where workspace_num_id =;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 30 10 1 8m56s 8m56s [ User: a3dsupervisor - Total duration: 8m56s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m56s - Times executed: 1 ]
-
delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;
Date: 2025-09-30 08:17:13 Duration: 8m56s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 1 3m37s 3m37s 3m37s 3m37s --liquibase formatted sql--changeset active3d:?.?.?.?-postgresql-optional-active3d_rqm-17843_init_batch_process dbms:postgresql encoding:utf-8 enddelimiter:/do $body$declare l_script_name constant text := ?;begin raise debug ?, l_script_name; -- ne pas supprimer cette ligne : initialisation de la validation du passage du script de post-installation insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); declare l_grpid integer; l_scnid integer; l_processid integer; l_processid_2 integer; l_mappingid integer; l_mappingid2 integer; begin select nextval(?) into l_grpid; select nextval(?) into l_scnid; select nextval(?) into l_processid; select nextval(?) into l_processid_2; select nextval(?) into l_mappingid; select nextval(?) into l_mappingid2; update gtp_workspace set workspace_name_fr = ?; insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid2, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_grpid, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_scnid, l_grpid, ?, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid||?, current_timestamp, ?, null, null); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid_2, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid2||?, current_timestamp, ?, null, null); exception when others then raise exception ?, sqlerrm; rollback; end; -- ne pas supprimer cette ligne : validation du passage du script de post-installation update a3d_migration_tracking set validated = true where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); raise notice ?, l_script_name;exception when others then call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); call pack_gtp_utils.p_trace_error(? || l_script_name, sqlerrm, ?); raise;end $body$;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 30 09 1 3m37s 3m37s [ User: a3dsupervisor - Total duration: 3m37s - Times executed: 1 ]
[ Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' - Total duration: 3m37s - Times executed: 1 ]
-
--liquibase formatted sql--changeset active3d:7.22.0.0-postgresql-optional-ACTIVE3D_RQM-17843_init_batch_process dbms:postgresql encoding:UTF-8 endDelimiter:/DO $body$DECLARE L_SCRIPT_NAME CONSTANT TEXT := 'ACTIVE3D_RQM-17843_init_batch_process';BEGIN raise debug 'START %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [START]', '7.22.0.0'); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval('s_batch_group_num_id') into l_grpId; select nextval('s_batch_scenario_num_id') into l_scnId; select nextval('s_batch_process_num_id') into l_processId; select nextval('s_batch_process_num_id') into l_processId_2; select nextval('s_mapping_num_id') into l_mappingId; select nextval('s_mapping_num_id') into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId, '02.01_batch01', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch01'); INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId2, '02.01_batch02', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch02'); INSERT INTO batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_grpId, '02_group', '02_group', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_scnId, l_grpId, '02_scenario_01', '02_scenario_01', '', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId, l_scnId, '02.01_batch01', '02.01_batch01', 8, 1, '', '{"mappingNumId":'||l_mappingId||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId_2, l_scnId, '02.01_batch02', '02.01_batch02', 8, 2, '', '{"mappingNumId":'||l_mappingId2||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); EXCEPTION WHEN OTHERS THEN RAISE EXCEPTION 'Erreur: %', SQLERRM; ROLLBACK; END; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET validated = true WHERE type = 'postInstallation' AND name = L_SCRIPT_NAME AND RELEASE = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [SUCCESS]', '7.22.0.0'); raise notice 'END %', L_SCRIPT_NAME;EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [ERROR]', '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.22.0.0'); RAISE;END $body$;
Date: 2025-09-30 07:58:00 Duration: 3m37s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' Bind query: yes
13 1 3m2s 3m2s 3m2s 3m2s insert into batch_process (batch_process_comment, creation_date, creator_num_id, batch_process_execution_order, modification_date, modifier_num_id, batch_process_name, batch_scenario_num_id, batch_process_settings, batch_process_type_code, batch_process_unique_code, batch_process_num_id) values (,,,,,,,,,,,);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 30 12 1 3m2s 3m2s [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m2s - Times executed: 1 ]
-
insert into BATCH_PROCESS (BATCH_PROCESS_COMMENT, CREATION_DATE, CREATOR_NUM_ID, BATCH_PROCESS_EXECUTION_ORDER, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_PROCESS_NAME, BATCH_SCENARIO_NUM_ID, BATCH_PROCESS_SETTINGS, BATCH_PROCESS_TYPE_CODE, BATCH_PROCESS_UNIQUE_CODE, BATCH_PROCESS_NUM_ID) values (,,,,,,,,,,,);
Date: 2025-09-30 10:32:17 Duration: 3m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 1 2m23s 2m23s 2m23s 2m23s vacuum analyse;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 30 20 1 2m23s 2m23s [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 1 ]
[ Application: psql - Total duration: 2m23s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-30 18:54:25 Duration: 2m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1 1m16s 1m16s 1m16s 1m16s 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 #15
Day Hour Count Duration Avg duration Sep 30 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - 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-09-30 18:36:31 Duration: 1m16s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 38s659ms 38s659ms 38s659ms 38s659ms 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 #16
Day Hour Count Duration Avg duration Sep 30 20 1 38s659ms 38s659ms [ User: a3dsupervisor - Total duration: 38s659ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s659ms - 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-09-30 18:38:51 Duration: 38s659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 35s641ms 35s641ms 35s641ms 35s641ms 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 #17
Day Hour Count Duration Avg duration Sep 30 20 1 35s641ms 35s641ms [ User: a3dsupervisor - Total duration: 35s641ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s641ms - 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-09-30 18:35:51 Duration: 35s641ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 35s105ms 35s105ms 35s105ms 35s105ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 30 20 1 35s105ms 35s105ms [ User: a3dsupervisor - Total duration: 35s105ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s105ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-30 18:37:22 Duration: 35s105ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 33s862ms 33s862ms 33s862ms 33s862ms 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 #19
Day Hour Count Duration Avg duration Sep 30 20 1 33s862ms 33s862ms [ User: a3dsupervisor - Total duration: 33s862ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s862ms - 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-09-30 18:39:48 Duration: 33s862ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 30s227ms 30s227ms 30s227ms 30s227ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 30 20 1 30s227ms 30s227ms [ User: a3dsupervisor - Total duration: 30s227ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s227ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-30 18:37:01 Duration: 30s227ms 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 8m56s 8m56s 8m56s 1 8m56s delete from gtp_workspace where workspace_num_id =;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 30 10 1 8m56s 8m56s [ User: a3dsupervisor - Total duration: 8m56s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m56s - Times executed: 1 ]
-
delete from GTP_WORKSPACE where WORKSPACE_NUM_ID =;
Date: 2025-09-30 08:17:13 Duration: 8m56s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4m1s 4m43s 4m18s 5 21m30s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 30 09 1 4m24s 4m24s 12 1 4m14s 4m14s 14 1 4m1s 4m1s 15 1 4m4s 4m4s 16 1 4m43s 4m43s [ User: a3dsupervisor - Total duration: 21m30s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21m30s - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-30 14:33:34 Duration: 4m43s 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-09-30 07:58:00 Duration: 4m24s 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-09-30 10:32:17 Duration: 4m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 3m37s 3m37s 3m37s 1 3m37s --liquibase formatted sql--changeset active3d:?.?.?.?-postgresql-optional-active3d_rqm-17843_init_batch_process dbms:postgresql encoding:utf-8 enddelimiter:/do $body$declare l_script_name constant text := ?;begin raise debug ?, l_script_name; -- ne pas supprimer cette ligne : initialisation de la validation du passage du script de post-installation insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); declare l_grpid integer; l_scnid integer; l_processid integer; l_processid_2 integer; l_mappingid integer; l_mappingid2 integer; begin select nextval(?) into l_grpid; select nextval(?) into l_scnid; select nextval(?) into l_processid; select nextval(?) into l_processid_2; select nextval(?) into l_mappingid; select nextval(?) into l_mappingid2; update gtp_workspace set workspace_name_fr = ?; insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) values(l_mappingid2, ?, ?, ?, ?, ?, null, ?, null, ?, ?, null, null, null, ?); insert into batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_grpid, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_scnid, l_grpid, ?, ?, ?, current_timestamp, ?, current_timestamp, ?); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid||?, current_timestamp, ?, null, null); insert into batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) values(l_processid_2, l_scnid, ?, ?, ?, ?, ?, ?||l_mappingid2||?, current_timestamp, ?, null, null); exception when others then raise exception ?, sqlerrm; rollback; end; -- ne pas supprimer cette ligne : validation du passage du script de post-installation update a3d_migration_tracking set validated = true where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); raise notice ?, l_script_name;exception when others then call pack_gtp_utils.p_trace_log_post_install(l_script_name || ?, ?); call pack_gtp_utils.p_trace_error(? || l_script_name, sqlerrm, ?); raise;end $body$;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 30 09 1 3m37s 3m37s [ User: a3dsupervisor - Total duration: 3m37s - Times executed: 1 ]
[ Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' - Total duration: 3m37s - Times executed: 1 ]
-
--liquibase formatted sql--changeset active3d:7.22.0.0-postgresql-optional-ACTIVE3D_RQM-17843_init_batch_process dbms:postgresql encoding:UTF-8 endDelimiter:/DO $body$DECLARE L_SCRIPT_NAME CONSTANT TEXT := 'ACTIVE3D_RQM-17843_init_batch_process';BEGIN raise debug 'START %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [START]', '7.22.0.0'); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval('s_batch_group_num_id') into l_grpId; select nextval('s_batch_scenario_num_id') into l_scnId; select nextval('s_batch_process_num_id') into l_processId; select nextval('s_batch_process_num_id') into l_processId_2; select nextval('s_mapping_num_id') into l_mappingId; select nextval('s_mapping_num_id') into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId, '02.01_batch01', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch01'); INSERT INTO "mapping" (mapping_num_id, mapping_name, mapping_type, mapping_status, mapping_data_name, mapping_data, mapping_model_id, obj_template_num_id, mapping_comment, mapping_creation_date, mapping_creator_num_id, mapping_modification_date, mapping_modifier_num_id, mapping_data_filter, unique_code) VALUES(l_mappingId2, '02.01_batch02', 8, 1, '01_scenario_01_ExportA3D.xml', '<ROOT isUniqueCode="true" persistentViewType="false" deleteViewType="true" isFilesByRootNode="false" nbObjLimitForSearch="500" nbObjBeforeFlush="500" fileformat="xml" statut="false" a3dId="false" creationDate="false" modificationDate="false" workspaceId="1" addDate="false" dateFormat="yyyyMMdd"><OBJECTS><OBJECT isFiltred="true" objId="PORT" src="PORT" isAllAttributes="true"><ATTRIBUTES><ATTRIBUTE attId="A3D_LIBELLE" catId="A3D_IDENTITE" src="A3D_LIBELLE"/></ATTRIBUTES><RELATIONS/><ASSOCIATED_OBJECTS/><ACTIONS_CONTENU/></OBJECT></OBJECTS></ROOT>', NULL, 1, NULL, '2025-09-24 17:26:07.000', 6, NULL, NULL, NULL, '02.01_batch02'); INSERT INTO batch_group (batch_group_num_id, batch_group_name, batch_group_unique_code, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_grpId, '02_group', '02_group', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_scenario (batch_scenario_num_id, batch_group_num_id, batch_scenario_name, batch_scenario_unique_code, batch_scenario_comment, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_scnId, l_grpId, '02_scenario_01', '02_scenario_01', '', current_timestamp, 6, current_timestamp, 6); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId, l_scnId, '02.01_batch01', '02.01_batch01', 8, 1, '', '{"mappingNumId":'||l_mappingId||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); INSERT INTO batch_process (batch_process_num_id, batch_scenario_num_id, batch_process_name, batch_process_unique_code, batch_process_type_code, batch_process_execution_order, batch_process_comment, batch_process_settings, creation_date, creator_num_id, modification_date, modifier_num_id) VALUES(l_processId_2, l_scnId, '02.01_batch02', '02.01_batch02', 8, 2, '', '{"mappingNumId":'||l_mappingId2||',"directoryPath":"aaa","fileName":"Export_XML_02.01_batch01","logLevel":"Info","viewTemplateUniqueCode":"VUE_TYPE_REFERENTIEL_PATRIMOINE","encoding":"UTF-8","filter":[],"filterAsString":"","encodingAsEnum":"UTF_8"}', current_timestamp, 6, NULL, NULL); EXCEPTION WHEN OTHERS THEN RAISE EXCEPTION 'Erreur: %', SQLERRM; ROLLBACK; END; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET validated = true WHERE type = 'postInstallation' AND name = L_SCRIPT_NAME AND RELEASE = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [SUCCESS]', '7.22.0.0'); raise notice 'END %', L_SCRIPT_NAME;EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(L_SCRIPT_NAME || ' [ERROR]', '7.22.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.22.0.0'); RAISE;END $body$;
Date: 2025-09-30 07:58:00 Duration: 3m37s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 24.2.1 - SQLEditor 'Script-420.sql' Bind query: yes
4 3m2s 3m2s 3m2s 1 3m2s insert into batch_process (batch_process_comment, creation_date, creator_num_id, batch_process_execution_order, modification_date, modifier_num_id, batch_process_name, batch_scenario_num_id, batch_process_settings, batch_process_type_code, batch_process_unique_code, batch_process_num_id) values (,,,,,,,,,,,);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 30 12 1 3m2s 3m2s [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m2s - Times executed: 1 ]
-
insert into BATCH_PROCESS (BATCH_PROCESS_COMMENT, CREATION_DATE, CREATOR_NUM_ID, BATCH_PROCESS_EXECUTION_ORDER, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_PROCESS_NAME, BATCH_SCENARIO_NUM_ID, BATCH_PROCESS_SETTINGS, BATCH_PROCESS_TYPE_CODE, BATCH_PROCESS_UNIQUE_CODE, BATCH_PROCESS_NUM_ID) values (,,,,,,,,,,,);
Date: 2025-09-30 10:32:17 Duration: 3m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 2m23s 2m23s 2m23s 1 2m23s vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 30 20 1 2m23s 2m23s [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 1 ]
[ Application: psql - Total duration: 2m23s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-30 18:54:25 Duration: 2m23s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1m16s 1m16s 1m16s 1 1m16s 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 #6
Day Hour Count Duration Avg duration Sep 30 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - 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-09-30 18:36:31 Duration: 1m16s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 27s614ms 1m14s 56s973ms 6 5m41s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 30 09 1 27s614ms 27s614ms 10 1 1m3s 1m3s 12 1 56s884ms 56s884ms 14 1 1m14s 1m14s 15 1 1m5s 1m5s 16 1 53s581ms 53s581ms [ User: a3dsupervisor - Total duration: 5m41s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m41s - Times executed: 6 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-30 12:54:14 Duration: 1m14s 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-09-30 13:41:12 Duration: 1m5s 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-09-30 08:03:34 Duration: 1m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 38s659ms 38s659ms 38s659ms 1 38s659ms 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 #8
Day Hour Count Duration Avg duration Sep 30 20 1 38s659ms 38s659ms [ User: a3dsupervisor - Total duration: 38s659ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s659ms - 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-09-30 18:38:51 Duration: 38s659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 35s641ms 35s641ms 35s641ms 1 35s641ms 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 #9
Day Hour Count Duration Avg duration Sep 30 20 1 35s641ms 35s641ms [ User: a3dsupervisor - Total duration: 35s641ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s641ms - 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-09-30 18:35:51 Duration: 35s641ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 35s105ms 35s105ms 35s105ms 1 35s105ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 30 20 1 35s105ms 35s105ms [ User: a3dsupervisor - Total duration: 35s105ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s105ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-30 18:37:22 Duration: 35s105ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5s4ms 2m30s 34s514ms 5 2m52s commit;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 30 08 2 10s994ms 5s497ms 09 1 5s112ms 5s112ms 10 1 2m30s 2m30s 20 1 6s3ms 6s3ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m46s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6s3ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-09-30 08:17:13 Duration: 2m30s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-30 18:38:28 Duration: 6s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COMMIT;
Date: 2025-09-30 06:36:16 Duration: 5s989ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 33s862ms 33s862ms 33s862ms 1 33s862ms 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 #12
Day Hour Count Duration Avg duration Sep 30 20 1 33s862ms 33s862ms [ User: a3dsupervisor - Total duration: 33s862ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s862ms - 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-09-30 18:39:48 Duration: 33s862ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 30s227ms 30s227ms 30s227ms 1 30s227ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 30 20 1 30s227ms 30s227ms [ User: a3dsupervisor - Total duration: 30s227ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s227ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-30 18:37:01 Duration: 30s227ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 29s591ms 29s591ms 29s591ms 1 29s591ms delete from gtp_att_template_category where att_template_category_num_id =;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 30 10 1 29s591ms 29s591ms [ User: a3dsupervisor - Total duration: 29s591ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s591ms - Times executed: 1 ]
-
delete from GTP_ATT_TEMPLATE_CATEGORY where ATT_TEMPLATE_CATEGORY_NUM_ID =;
Date: 2025-09-30 08:07:37 Duration: 29s591ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 25s130ms 25s130ms 25s130ms 1 25s130ms 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 Sep 30 20 1 25s130ms 25s130ms [ User: a3dsupervisor - Total duration: 25s130ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s130ms - 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-09-30 18:36:16 Duration: 25s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 7s533ms 32s879ms 20s268ms 5 1m41s select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 30 12 2 40s412ms 20s206ms 14 1 19s103ms 19s103ms 15 1 21s331ms 21s331ms 16 1 20s495ms 20s495ms [ User: a3dsupervisor - Total duration: 1m41s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m41s - Times executed: 5 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 10:32:57 Duration: 32s879ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 13:35:59 Duration: 21s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-30 14:34:02 Duration: 20s495ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 14s378ms 22s87ms 18s232ms 2 36s465ms select goc.obj_compo_value from gtp_att_template gat inner join gtp_obj_composition goc on (gat.att_template_num_id = goc.att_template_num_id) inner join gtp_obj go on (goc.obj_num_id = go.obj_num_id) where gat.att_template_num_id = and go.obj_state is null and goc.obj_compo_value is not null group by goc.obj_compo_value having count(goc.obj_compo_value) > ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 30 09 1 22s87ms 22s87ms 16 1 14s378ms 14s378ms [ User: a3dsupervisor - Total duration: 36s465ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s465ms - Times executed: 2 ]
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-09-30 07:50:25 Duration: 22s87ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-09-30 14:25:54 Duration: 14s378ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 8s555ms 11s590ms 10s73ms 2 20s146ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 30 08 1 11s590ms 11s590ms 09 1 8s555ms 8s555ms [ User: a3dsupervisor - Total duration: 20s146ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 20s146ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-30 06:57:02 Duration: 11s590ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-09-30 07:04:41 Duration: 8s555ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 7s717ms 11s888ms 9s719ms 5 48s595ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 30 09 1 8s930ms 8s930ms 12 1 9s122ms 9s122ms 14 1 10s937ms 10s937ms 15 1 7s717ms 7s717ms 16 1 11s888ms 11s888ms [ User: a3dsupervisor - Total duration: 48s595ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s595ms - Times executed: 5 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-30 14:35:44 Duration: 11s888ms 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-09-30 12:50:17 Duration: 10s937ms 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-09-30 10:34:46 Duration: 9s122ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 9s81ms 11s488ms 9s634ms 5 48s172ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 30 09 1 11s488ms 11s488ms 12 1 9s81ms 9s81ms 14 1 9s234ms 9s234ms 15 1 9s200ms 9s200ms 16 1 9s168ms 9s168ms [ User: a3dsupervisor - Total duration: 48s172ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 48s172ms - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-30 07:53:22 Duration: 11s488ms 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-09-30 12:44:05 Duration: 9s234ms 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-09-30 13:31:18 Duration: 9s200ms 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
- 3,960 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 1006 ERROR entries
- 70 WARNING entries
Most Frequent Errors/Events
Key values
- 866 Max number of times the same event was reported
- 1,077 Total events found
Rank Times reported Error 1 866 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 30 21 95 22 370 23 91 00 310 2 40 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 30 09 8 12 8 14 8 15 8 16 8 3 30 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 30 09 6 12 6 14 6 15 6 16 6 4 16 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 30 10 3 11 6 13 2 17 2 19 3 5 10 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 30 09 2 12 2 14 2 15 2 16 2 6 10 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 #6
Day Hour Count Sep 30 12 1 14 2 15 3 16 4 7 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 #7
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 8 5 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 9 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 10 5 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 11 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 #11
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 12 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 13 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 #13
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 14 5 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 15 5 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 16 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 #16
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 17 5 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 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 Sep 30 09 1 12 1 14 1 15 1 16 1 19 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 #19
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 20 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #20
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 21 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 #21
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 22 5 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #22
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 23 5 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #23
Day Hour Count Sep 30 09 1 12 1 14 1 15 1 16 1 24 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msinsert into BATCH_PROCESS (...) values (...)
Times Reported Most Frequent Error / Event #24
Day Hour Count Sep 30 12 2 25 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms--liquibase formatted sql --changeset active3d:7.22.0.0-postgresql-optional-ACTIVE3D_RQM-17843_init_batch_process dbms:postgresql encoding:UTF-8 endDelimiter:/ DO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := 'ACTIVE3D_RQM-17843_init_batch_process'; BEGIN raise debug 'START %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; l_mappingId2 INTEGER; BEGIN select nextval(...) into l_grpId; select nextval(...) into l_scnId; select nextval(...) into l_processId; select nextval(...) into l_processId_2; select nextval(...) into l_mappingId; select nextval(...) into l_mappingId2; update GTP_WORKSPACE set WORKSPACE_NAME_FR = 'AUTOTEST'; INSERT INTO "..." (...) VALUES(...); INSERT INTO "..." (...) VALUES(...); INSERT INTO batch_group (...) VALUES(...); INSERT INTO batch_scenario (...) VALUES(...); INSERT INTO batch_process (...) VALUES(...); EXCEPTION WHEN OTHERS THEN RAISE EXCEPTION 'Erreur: %', SQLERRM; ROLLBACK; END; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET validated = true WHERE type = 'postInstallation' AND name = L_SCRIPT_NAME AND RELEASE = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise notice 'END %', L_SCRIPT_NAME; EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #25
Day Hour Count Sep 30 09 2 26 2 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #26
Day Hour Count Sep 30 20 2 27 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #27
Day Hour Count Sep 30 20 1 28 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 #28
Day Hour Count Sep 30 20 1 29 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 #29
Day Hour Count Sep 30 20 1 30 1 FATAL: connection to client lostdelete from GTP_WORKSPACE where WORKSPACE_NUM_ID=
Times Reported Most Frequent Error / Event #30
Day Hour Count Sep 30 10 1 31 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 #31
Day Hour Count Sep 30 20 1 32 1 LOG: could not send data to client: Connection reset by peerdelete from GTP_WORKSPACE where WORKSPACE_NUM_ID=
Times Reported Most Frequent Error / Event #32
Day Hour Count Sep 30 10 1 33 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msCOMMIT
Times Reported Most Frequent Error / Event #33
Day Hour Count Sep 30 10 1 34 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #34
Day Hour Count Sep 30 20 1 35 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 #35
Day Hour Count Sep 30 20 1 36 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #36
Day Hour Count Sep 30 20 1 37 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #37
Day Hour Count Sep 30 20 1 38 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 #38
Day Hour Count Sep 30 20 1 39 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 #39
Day Hour Count Sep 30 20 1 40 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 #40
Day Hour Count Sep 30 20 1