pgBadger-
Global information
- Generated on Fri Nov 14 09:08:42 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=13/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=13/h=23/m=00/PT1H.log
- Parsed 6,340 log entries in 1m4s
- Log start from 2025-11-13 08:15:21 to 2025-11-13 19:57:18
-
Overview
Global Stats
- 82 Number of unique normalized queries
- 119 Number of queries
- 1h4m22s Total query duration
- 2025-11-13 01:01:04 First query
- 2025-11-13 19:55:44 Last query
- 3 queries/s at 2025-11-13 07:47:51 Query peak
- 1h4m22s Total query duration
- 6s884ms Prepare/parse total duration
- 0ms Bind total duration
- 1h4m15s Execute total duration
- 1,382 Number of events
- 38 Number of unique normalized events
- 1,263 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
- 376 Number temporary file
- 720.55 MiB Max size of temporary file
- 21.24 MiB Average size of temporary file
- 989 Total number of sessions
- 134 sessions at 2025-11-13 19:57:23 Session peak
- 3d18h12m45s Total duration of sessions
- 5m28s Average duration of sessions
- 0 Average queries per session
- 3s905ms Average queries duration per session
- 5m24s Average idle time per session
- 981 Total number of connections
- 14 connections/s at 2025-11-13 10:04:05 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-13 07:47:51 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-13 13:57:27 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-13 07:47:51 Date
Queries duration
Key values
- 1h4m22s 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) Nov 13 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 7s387ms 7s387ms 0ms 0ms 7s387ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 07 14 0ms 20s915ms 7s929ms 12s233ms 33s337ms 42s296ms 08 56 0ms 1m18s 15s404ms 1m46s 1m56s 2m58s 09 2 0ms 27m13s 13m55s 0ms 37s331ms 27m13s 10 4 0ms 3m34s 1m8s 0ms 9s391ms 3m34s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 4 0ms 2m44s 46s384ms 6s9ms 9s201ms 2m44s 14 1 0ms 37s350ms 37s350ms 0ms 0ms 37s350ms 15 1 0ms 5s124ms 5s124ms 0ms 0ms 5s124ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 36 0ms 2m25s 19s491ms 1m56s 2m20s 2m25s 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) Nov 13 00 0 0 0ms 0ms 0ms 0ms 01 1 0 7s387ms 0ms 0ms 7s387ms 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 1 0 12s233ms 0ms 0ms 12s233ms 08 8 0 6s330ms 5s548ms 11s896ms 13s679ms 09 0 0 0ms 0ms 0ms 0ms 10 1 0 7s329ms 0ms 0ms 7s329ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 2 0 6s17ms 0ms 0ms 6s25ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 5s124ms 0ms 0ms 5s124ms 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) Nov 13 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 1 0 0 20s915ms 0ms 0ms 0ms 08 2 0 0 6 31s849ms 0ms 17s812ms 1m18s 09 0 0 1 0 37s331ms 0ms 0ms 0ms 10 0 0 1 0 43s74ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 1 0 37s350ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 6 31s10ms 0ms 0ms 53s917ms 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 Nov 13 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 1 14 14.00 7.14% 08 0 4 4.00 0.00% 09 0 1 1.00 0.00% 10 0 4 4.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 4 4.00 0.00% 14 0 1 1.00 0.00% 15 0 1 1.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 Nov 13 00 45 0.01/s 01 34 0.01/s 02 49 0.01/s 03 45 0.01/s 04 30 0.01/s 05 46 0.01/s 06 42 0.01/s 07 46 0.01/s 08 13 0.00/s 09 80 0.02/s 10 76 0.02/s 11 72 0.02/s 12 46 0.01/s 13 43 0.01/s 14 42 0.01/s 15 62 0.02/s 16 53 0.01/s 17 61 0.02/s 18 31 0.01/s 19 53 0.01/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Nov 13 00 46 1m53s 1m53s 01 34 1m56s 1m56s 02 48 1m54s 1m54s 03 43 1m57s 1m57s 04 34 2m16s 2m16s 05 46 1m46s 1m46s 06 42 2m15s 2m15s 07 41 2m6s 2m3s 08 20 1h33m5s 1h32m21s 09 78 1m57s 1m36s 10 72 2m3s 2m 11 79 2m40s 2m40s 12 46 2m8s 2m8s 13 41 2m39s 2m34s 14 41 3m7s 3m6s 15 63 6m10s 6m10s 16 42 1m56s 1m56s 17 74 2m7s 2m7s 18 32 37m30s 37m30s 19 55 3m42s 3m29s 20 3 100ms 100ms 21 3 79ms 79ms 22 3 76ms 76ms 23 3 76ms 76ms -
Connections
Established Connections
Key values
- 14 connections Connection Peak
- 2025-11-13 10:04:05 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 981 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 981 connections Total
-
Sessions
Simultaneous sessions
Key values
- 134 sessions Session Peak
- 2025-11-13 19:57:23 Date
Histogram of session times
Key values
- 814 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 989 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 989 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 989 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 989 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 2 1h54m48s 57m24s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 2 1h54m47s 57m23s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 2 1h54m46s 57m23s IntelliJ IDEA 2024.3.5 3 10m32s 3m30s PostgreSQL JDBC Driver 884 3d10h19m37s 5m35s [unknown] 78 9s257ms 118ms pg_restore 8 1h28m23s 11m2s psql 10 29m40s 2m58s -
Temporary Files
Size of temporary files
Key values
- 400.82 MiB Temp Files size Peak
- 2025-11-13 19:39:49 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-11-13 19:39:36 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 13 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 1 4.19 MiB 4.19 MiB 08 166 3.81 GiB 23.53 MiB 09 1 4.19 MiB 4.19 MiB 10 25 106.85 MiB 4.27 MiB 11 2 8.38 MiB 4.19 MiB 12 0 0 0 13 25 106.91 MiB 4.28 MiB 14 0 0 0 15 0 0 0 16 1 4.19 MiB 4.19 MiB 17 1 4.19 MiB 4.19 MiB 18 0 0 0 19 154 3.75 GiB 24.95 MiB 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 15 106.91 MiB 2.48 MiB 28.90 MiB 7.13 MiB select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) 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('202001021357', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021357', '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-11-13 13:57:27 Duration: 6s9ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 6 26.30 MiB 3.45 MiB 5.84 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-11-13 19:42:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 6 285.70 MiB 27.95 MiB 129.50 MiB 47.62 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-11-13 19:41:42 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 6 573.98 MiB 50.93 MiB 273.83 MiB 95.66 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-11-13 19:39:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 6 277.64 MiB 10.22 MiB 220.08 MiB 46.27 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-11-13 19:42:37 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 6 207.97 MiB 28.25 MiB 52.59 MiB 34.66 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-11-13 19:39:36 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 6 651.47 MiB 3.91 MiB 625.75 MiB 108.58 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-11-13 19:39:40 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 6 1.83 GiB 114.52 MiB 720.55 MiB 311.74 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
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-11-13 19:38:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 6 208.55 MiB 21.46 MiB 76.85 MiB 34.76 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-11-13 19:42:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 6 415.26 MiB 4.92 MiB 336.88 MiB 69.21 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-11-13 19:40:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 6 393.23 MiB 3.78 MiB 315.60 MiB 65.54 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-11-13 19:39:23 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 6 411.01 MiB 21.57 MiB 294.83 MiB 68.50 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-11-13 19:41:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 6 1.23 GiB 30.80 MiB 643.86 MiB 210.60 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-11-13 19:37:53 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 6 541.92 MiB 13.13 MiB 260.31 MiB 90.32 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-11-13 19:40:50 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3 106.02 MiB 2.05 MiB 95.67 MiB 35.34 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-11-13 19:40:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 3 109.73 MiB 2.34 MiB 104.54 MiB 36.58 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-11-13 08:24:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 3 14.72 MiB 4.69 MiB 5.12 MiB 4.91 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-11-13 19:42:46 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 34.50 MiB 8.76 MiB 25.74 MiB 17.25 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-11-13 19:42:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2 47.53 MiB 20.67 MiB 26.86 MiB 23.77 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-13 19:39:45 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 14.68 MiB 14.68 MiB 14.68 MiB 14.68 MiB add constraint fk_gtp_obj_rel_vt_rel foreign key (relation_num_id) references public.gtp_relation (relation_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_rel FOREIGN KEY (relation_num_id) REFERENCES public.gtp_relation (relation_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-13 19:41:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 254.19 MiB 254.19 MiB 254.19 MiB 254.19 MiB add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-13 08:21:33 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 720.55 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-11-13 19:38:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 643.86 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-13 19:37:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 632.30 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-13 08:19:28 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 625.75 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-13 08:18:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 494.02 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-13 08:18:07 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 336.88 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-11-13 19:40:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 315.60 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-11-13 19:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 294.83 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-13 08:22:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 273.83 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-11-13 19:39:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 260.31 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-13 19:40:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 254.19 MiB ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-13 08:21:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 220.08 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-11-13 08:23:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 219.42 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-13 08:23:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 147.72 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-11-13 08:20:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 129.50 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-11-13 19:41:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 128.62 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-11-13 19:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 126.70 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-11-13 19:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 114.52 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-11-13 08:20:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 104.54 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-11-13 08:24:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 95.67 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-11-13 19:40:34 - 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 Nov 13 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
- 5 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
- 14 Total read queries
- 99 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 119 Requests
- 1h4m15s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 119 Requests
User Request type Count Duration a3dsupervisor Total 119 1h4m15s copy from 12 7m8s ddl 67 15m14s delete 3 1m57s insert 2 12s353ms others 6 36m15s select 14 1m34s tcl 14 1m31s update 1 20s915ms Duration by user
Key values
- 1h4m15s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 119 1h4m15s copy from 12 7m8s ddl 67 15m14s delete 3 1m57s insert 2 12s353ms others 6 36m15s select 14 1m34s tcl 14 1m31s update 1 20s915ms Queries by host
Key values
- 10.3.0.4 Main host
- 119 Requests
- 1h4m15s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 87 Requests
- 29m39s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-13 10:17:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 63 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 27m13s VACUUM ANALYSE;[ Date: 2025-11-13 09:11:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 3m34s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-13 10:12:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 2m44s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-13 13:55:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 2m25s VACUUM ANALYSE;[ Date: 2025-11-13 19:55:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 1m18s 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-11-13 08:18:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 1m5s 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-11-13 19:37:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 44s373ms 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-11-13 08:21:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 43s644ms 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-11-13 08:20:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 43s74ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-13 10:16:59 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 42s542ms 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-11-13 08:17:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 37s350ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-13 14:00:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 37s331ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-13 09:16:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 35s577ms 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-11-13 19:37:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 35s390ms 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-11-13 19:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 35s292ms 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-11-13 19:40:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 34s57ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;[ Date: 2025-11-13 08:21:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 32s916ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-11-13 08:18:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 31s869ms CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-13 08:19:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 30s536ms CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-13 08:22:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 27s700ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-11-13 19:38:22 - 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 29m39s 2 2m25s 27m13s 14m49s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 10 1 27m13s 27m13s 20 1 2m25s 2m25s [ User: a3dsupervisor - Total duration: 29m39s - Times executed: 2 ]
[ Application: psql - Total duration: 29m39s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:11:53 Duration: 27m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 19:55:44 Duration: 2m25s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 6m18s 2 2m44s 3m34s 3m9s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 13 11 1 3m34s 3m34s 14 1 2m44s 2m44s [ User: a3dsupervisor - Total duration: 6m18s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m18s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-13 10:12:38 Duration: 3m34s 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-11-13 13:55:34 Duration: 2m44s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m24s 2 1m5s 1m18s 1m12s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 13 09 1 1m18s 1m18s 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 2 ]
-
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-11-13 08:18:19 Duration: 1m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:37:45 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m57s 3 37s331ms 43s74ms 39s252ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 10 1 37s331ms 37s331ms 11 1 43s74ms 43s74ms 15 1 37s350ms 37s350ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m57s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-13 10:16:59 Duration: 43s74ms 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-11-13 14:00:01 Duration: 37s350ms 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-11-13 09:16:03 Duration: 37s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m31s 14 5s10ms 9s163ms 6s513ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 13 08 12 1m17s 6s489ms 09 2 13s323ms 6s661ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 14 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m24s - Times executed: 13 ]
[ Application: pg_restore - Total duration: 6s710ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s163ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s23ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1m19s 2 35s292ms 44s373ms 39s833ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 13 09 1 44s373ms 44s373ms 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-11-13 08:21:34 Duration: 44s373ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:40:35 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m19s 2 35s390ms 43s644ms 39s517ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 13 09 1 43s644ms 43s644ms 20 1 35s390ms 35s390ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-11-13 08:20:49 Duration: 43s644ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:39:49 Duration: 35s390ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m18s 2 35s577ms 42s542ms 39s60ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 13 09 1 42s542ms 42s542ms 20 1 35s577ms 35s577ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m18s - Times executed: 2 ]
-
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-11-13 08:17:42 Duration: 42s542ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:37:15 Duration: 35s577ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m 2 27s700ms 32s916ms 30s308ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 13 09 1 32s916ms 32s916ms 20 1 27s700ms 27s700ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 08:18:55 Duration: 32s916ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 19:38:22 Duration: 27s700ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 52s681ms 2 18s624ms 34s57ms 26s340ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 13 09 1 34s57ms 34s57ms 20 1 18s624ms 18s624ms [ User: a3dsupervisor - Total duration: 52s681ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 52s681ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-13 08:21:23 Duration: 34s57ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-13 19:40:09 Duration: 18s624ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 48s381ms 2 23s753ms 24s628ms 24s190ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 13 09 1 24s628ms 24s628ms 20 1 23s753ms 23s753ms [ User: a3dsupervisor - Total duration: 48s381ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 48s381ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 08:18:07 Duration: 24s628ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 19:37:39 Duration: 23s753ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 46s823ms 2 14s953ms 31s869ms 23s411ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 13 09 1 31s869ms 31s869ms 20 1 14s953ms 14s953ms [ User: a3dsupervisor - Total duration: 46s823ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s823ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-13 08:19:43 Duration: 31s869ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-13 19:38:52 Duration: 14s953ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 43s462ms 7 5s443ms 7s636ms 6s208ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 13 09 7 43s462ms 6s208ms [ User: a3dsupervisor - Total duration: 43s462ms - Times executed: 7 ]
[ Application: pg_restore - Total duration: 43s462ms - Times executed: 7 ]
-
SELECT pg_catalog.lo_create('2804486');
Date: 2025-11-13 08:33:07 Duration: 7s636ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804017');
Date: 2025-11-13 08:30:32 Duration: 6s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804341');
Date: 2025-11-13 08:32:02 Duration: 6s304ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 40s802ms 2 16s95ms 24s706ms 20s401ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 13 09 1 24s706ms 24s706ms 20 1 16s95ms 16s95ms [ User: a3dsupervisor - Total duration: 40s802ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s802ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 08:19:11 Duration: 24s706ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 19:38:28 Duration: 16s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 38s172ms 2 18s48ms 20s123ms 19s86ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 13 09 1 18s48ms 18s48ms 20 1 20s123ms 20s123ms [ User: a3dsupervisor - Total duration: 38s172ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 38s172ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 19:38:05 Duration: 20s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 08:18:37 Duration: 18s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 36s408ms 2 17s48ms 19s360ms 18s204ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 13 09 1 17s48ms 17s48ms 20 1 19s360ms 19s360ms [ User: a3dsupervisor - Total duration: 36s408ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s408ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 19:39:11 Duration: 19s360ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 08:20:00 Duration: 17s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 35s901ms 2 13s18ms 22s883ms 17s950ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 13 09 1 22s883ms 22s883ms 20 1 13s18ms 13s18ms [ User: a3dsupervisor - Total duration: 35s901ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s901ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-13 08:23:45 Duration: 22s883ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-13 19:41:59 Duration: 13s18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 35s330ms 2 17s189ms 18s140ms 17s665ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 13 09 1 18s140ms 18s140ms 20 1 17s189ms 17s189ms [ User: a3dsupervisor - Total duration: 35s330ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s330ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-13 08:19:29 Duration: 18s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-13 19:38:45 Duration: 17s189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 34s395ms 2 15s648ms 18s746ms 17s197ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 13 09 1 18s746ms 18s746ms 20 1 15s648ms 15s648ms [ User: a3dsupervisor - Total duration: 34s395ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 34s395ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-13 08:22:55 Duration: 18s746ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-13 19:41:26 Duration: 15s648ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 32s657ms 2 14s845ms 17s812ms 16s328ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 13 09 1 17s812ms 17s812ms 20 1 14s845ms 14s845ms [ User: a3dsupervisor - Total duration: 32s657ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 32s657ms - Times executed: 2 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-11-13 08:24:21 Duration: 17s812ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-11-13 19:42:27 Duration: 14s845ms 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 14 1m31s 5s10ms 9s163ms 6s513ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 08 12 1m17s 6s489ms 09 2 13s323ms 6s661ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 14 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m24s - Times executed: 13 ]
[ Application: pg_restore - Total duration: 6s710ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s163ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s23ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 7 43s462ms 5s443ms 7s636ms 6s208ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 13 09 7 43s462ms 6s208ms [ User: a3dsupervisor - Total duration: 43s462ms - Times executed: 7 ]
[ Application: pg_restore - Total duration: 43s462ms - Times executed: 7 ]
-
SELECT pg_catalog.lo_create('2804486');
Date: 2025-11-13 08:33:07 Duration: 7s636ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804017');
Date: 2025-11-13 08:30:32 Duration: 6s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804341');
Date: 2025-11-13 08:32:02 Duration: 6s304ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 3 1m57s 37s331ms 43s74ms 39s252ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 13 10 1 37s331ms 37s331ms 11 1 43s74ms 43s74ms 15 1 37s350ms 37s350ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m57s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-13 10:16:59 Duration: 43s74ms 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-11-13 14:00:01 Duration: 37s350ms 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-11-13 09:16:03 Duration: 37s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 3 25s587ms 6s25ms 12s233ms 8s529ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 08 1 12s233ms 12s233ms 11 1 7s329ms 7s329ms 14 1 6s25ms 6s25ms [ User: a3dsupervisor - Total duration: 25s587ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 25s587ms - Times executed: 3 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-13 07:35:45 Duration: 12s233ms 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-11-13 10:13:53 Duration: 7s329ms 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-11-13 13:56:57 Duration: 6s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 2 29m39s 2m25s 27m13s 14m49s vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 13 10 1 27m13s 27m13s 20 1 2m25s 2m25s [ User: a3dsupervisor - Total duration: 29m39s - Times executed: 2 ]
[ Application: psql - Total duration: 29m39s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:11:53 Duration: 27m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 19:55:44 Duration: 2m25s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 2 6m18s 2m44s 3m34s 3m9s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 13 11 1 3m34s 3m34s 14 1 2m44s 2m44s [ User: a3dsupervisor - Total duration: 6m18s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m18s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-13 10:12:38 Duration: 3m34s 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-11-13 13:55:34 Duration: 2m44s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 2 2m24s 1m5s 1m18s 1m12s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 13 09 1 1m18s 1m18s 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 2 ]
-
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-11-13 08:18:19 Duration: 1m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:37:45 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 2 1m19s 35s292ms 44s373ms 39s833ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 13 09 1 44s373ms 44s373ms 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-11-13 08:21:34 Duration: 44s373ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:40:35 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 2 1m19s 35s390ms 43s644ms 39s517ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 13 09 1 43s644ms 43s644ms 20 1 35s390ms 35s390ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-11-13 08:20:49 Duration: 43s644ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:39:49 Duration: 35s390ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2 1m18s 35s577ms 42s542ms 39s60ms 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 #10
Day Hour Count Duration Avg duration Nov 13 09 1 42s542ms 42s542ms 20 1 35s577ms 35s577ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m18s - Times executed: 2 ]
-
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-11-13 08:17:42 Duration: 42s542ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:37:15 Duration: 35s577ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2 1m 27s700ms 32s916ms 30s308ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 13 09 1 32s916ms 32s916ms 20 1 27s700ms 27s700ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 08:18:55 Duration: 32s916ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 19:38:22 Duration: 27s700ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 2 52s681ms 18s624ms 34s57ms 26s340ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 13 09 1 34s57ms 34s57ms 20 1 18s624ms 18s624ms [ User: a3dsupervisor - Total duration: 52s681ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 52s681ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-13 08:21:23 Duration: 34s57ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-13 19:40:09 Duration: 18s624ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2 48s381ms 23s753ms 24s628ms 24s190ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 13 09 1 24s628ms 24s628ms 20 1 23s753ms 23s753ms [ User: a3dsupervisor - Total duration: 48s381ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 48s381ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 08:18:07 Duration: 24s628ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 19:37:39 Duration: 23s753ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 46s823ms 14s953ms 31s869ms 23s411ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 13 09 1 31s869ms 31s869ms 20 1 14s953ms 14s953ms [ User: a3dsupervisor - Total duration: 46s823ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s823ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-13 08:19:43 Duration: 31s869ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-13 19:38:52 Duration: 14s953ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2 40s802ms 16s95ms 24s706ms 20s401ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 13 09 1 24s706ms 24s706ms 20 1 16s95ms 16s95ms [ User: a3dsupervisor - Total duration: 40s802ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s802ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 08:19:11 Duration: 24s706ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 19:38:28 Duration: 16s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 38s172ms 18s48ms 20s123ms 19s86ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 13 09 1 18s48ms 18s48ms 20 1 20s123ms 20s123ms [ User: a3dsupervisor - Total duration: 38s172ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 38s172ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 19:38:05 Duration: 20s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 08:18:37 Duration: 18s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 36s408ms 17s48ms 19s360ms 18s204ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 13 09 1 17s48ms 17s48ms 20 1 19s360ms 19s360ms [ User: a3dsupervisor - Total duration: 36s408ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s408ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 19:39:11 Duration: 19s360ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 08:20:00 Duration: 17s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 35s901ms 13s18ms 22s883ms 17s950ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 13 09 1 22s883ms 22s883ms 20 1 13s18ms 13s18ms [ User: a3dsupervisor - Total duration: 35s901ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s901ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-13 08:23:45 Duration: 22s883ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-13 19:41:59 Duration: 13s18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2 35s330ms 17s189ms 18s140ms 17s665ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 13 09 1 18s140ms 18s140ms 20 1 17s189ms 17s189ms [ User: a3dsupervisor - Total duration: 35s330ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s330ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-13 08:19:29 Duration: 18s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-13 19:38:45 Duration: 17s189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2 34s395ms 15s648ms 18s746ms 17s197ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 13 09 1 18s746ms 18s746ms 20 1 15s648ms 15s648ms [ User: a3dsupervisor - Total duration: 34s395ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 34s395ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-13 08:22:55 Duration: 18s746ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-13 19:41:26 Duration: 15s648ms 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 2m25s 27m13s 14m49s 2 29m39s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 10 1 27m13s 27m13s 20 1 2m25s 2m25s [ User: a3dsupervisor - Total duration: 29m39s - Times executed: 2 ]
[ Application: psql - Total duration: 29m39s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:11:53 Duration: 27m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 19:55:44 Duration: 2m25s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m44s 3m34s 3m9s 2 6m18s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 13 11 1 3m34s 3m34s 14 1 2m44s 2m44s [ User: a3dsupervisor - Total duration: 6m18s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m18s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-13 10:12:38 Duration: 3m34s 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-11-13 13:55:34 Duration: 2m44s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1m5s 1m18s 1m12s 2 2m24s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 13 09 1 1m18s 1m18s 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 2 ]
-
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-11-13 08:18:19 Duration: 1m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:37:45 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 35s292ms 44s373ms 39s833ms 2 1m19s 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 #4
Day Hour Count Duration Avg duration Nov 13 09 1 44s373ms 44s373ms 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-11-13 08:21:34 Duration: 44s373ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:40:35 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 35s390ms 43s644ms 39s517ms 2 1m19s alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 13 09 1 43s644ms 43s644ms 20 1 35s390ms 35s390ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-11-13 08:20:49 Duration: 43s644ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:39:49 Duration: 35s390ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 37s331ms 43s74ms 39s252ms 3 1m57s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 13 10 1 37s331ms 37s331ms 11 1 43s74ms 43s74ms 15 1 37s350ms 37s350ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m57s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-13 10:16:59 Duration: 43s74ms 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-11-13 14:00:01 Duration: 37s350ms 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-11-13 09:16:03 Duration: 37s331ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 35s577ms 42s542ms 39s60ms 2 1m18s 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 #7
Day Hour Count Duration Avg duration Nov 13 09 1 42s542ms 42s542ms 20 1 35s577ms 35s577ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m18s - Times executed: 2 ]
-
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-11-13 08:17:42 Duration: 42s542ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-11-13 19:37:15 Duration: 35s577ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 27s700ms 32s916ms 30s308ms 2 1m create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 13 09 1 32s916ms 32s916ms 20 1 27s700ms 27s700ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 08:18:55 Duration: 32s916ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 19:38:22 Duration: 27s700ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 18s624ms 34s57ms 26s340ms 2 52s681ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 13 09 1 34s57ms 34s57ms 20 1 18s624ms 18s624ms [ User: a3dsupervisor - Total duration: 52s681ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 52s681ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-13 08:21:23 Duration: 34s57ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-13 19:40:09 Duration: 18s624ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 23s753ms 24s628ms 24s190ms 2 48s381ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 13 09 1 24s628ms 24s628ms 20 1 23s753ms 23s753ms [ User: a3dsupervisor - Total duration: 48s381ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 48s381ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 08:18:07 Duration: 24s628ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 19:37:39 Duration: 23s753ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 14s953ms 31s869ms 23s411ms 2 46s823ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 13 09 1 31s869ms 31s869ms 20 1 14s953ms 14s953ms [ User: a3dsupervisor - Total duration: 46s823ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s823ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-13 08:19:43 Duration: 31s869ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-13 19:38:52 Duration: 14s953ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 16s95ms 24s706ms 20s401ms 2 40s802ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 13 09 1 24s706ms 24s706ms 20 1 16s95ms 16s95ms [ User: a3dsupervisor - Total duration: 40s802ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s802ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 08:19:11 Duration: 24s706ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 19:38:28 Duration: 16s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 18s48ms 20s123ms 19s86ms 2 38s172ms 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 Nov 13 09 1 18s48ms 18s48ms 20 1 20s123ms 20s123ms [ User: a3dsupervisor - Total duration: 38s172ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 38s172ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 19:38:05 Duration: 20s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 08:18:37 Duration: 18s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 17s48ms 19s360ms 18s204ms 2 36s408ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 13 09 1 17s48ms 17s48ms 20 1 19s360ms 19s360ms [ User: a3dsupervisor - Total duration: 36s408ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s408ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 19:39:11 Duration: 19s360ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 08:20:00 Duration: 17s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 13s18ms 22s883ms 17s950ms 2 35s901ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 13 09 1 22s883ms 22s883ms 20 1 13s18ms 13s18ms [ User: a3dsupervisor - Total duration: 35s901ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s901ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-13 08:23:45 Duration: 22s883ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-13 19:41:59 Duration: 13s18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 17s189ms 18s140ms 17s665ms 2 35s330ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 13 09 1 18s140ms 18s140ms 20 1 17s189ms 17s189ms [ User: a3dsupervisor - Total duration: 35s330ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s330ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-13 08:19:29 Duration: 18s140ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-13 19:38:45 Duration: 17s189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 15s648ms 18s746ms 17s197ms 2 34s395ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 13 09 1 18s746ms 18s746ms 20 1 15s648ms 15s648ms [ User: a3dsupervisor - Total duration: 34s395ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 34s395ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-13 08:22:55 Duration: 18s746ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-13 19:41:26 Duration: 15s648ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 14s845ms 17s812ms 16s328ms 2 32s657ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 13 09 1 17s812ms 17s812ms 20 1 14s845ms 14s845ms [ User: a3dsupervisor - Total duration: 32s657ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 32s657ms - Times executed: 2 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-11-13 08:24:21 Duration: 17s812ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-11-13 19:42:27 Duration: 14s845ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 6s25ms 12s233ms 8s529ms 3 25s587ms 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 Nov 13 08 1 12s233ms 12s233ms 11 1 7s329ms 7s329ms 14 1 6s25ms 6s25ms [ User: a3dsupervisor - Total duration: 25s587ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 25s587ms - Times executed: 3 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-13 07:35:45 Duration: 12s233ms 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-11-13 10:13:53 Duration: 7s329ms 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-11-13 13:56:57 Duration: 6s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s10ms 9s163ms 6s513ms 14 1m31s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 13 08 12 1m17s 6s489ms 09 2 13s323ms 6s661ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 14 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m24s - Times executed: 13 ]
[ Application: pg_restore - Total duration: 6s710ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s163ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-13 07:47:51 Duration: 9s23ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 4,839 Log entries
Events distribution
Key values
- 0 PANIC entries
- 6 FATAL entries
- 1348 ERROR entries
- 28 WARNING entries
Most Frequent Errors/Events
Key values
- 1,263 Max number of times the same event was reported
- 1,382 Total events found
Rank Times reported Error 1 1,263 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 13 10 51 11 276 12 140 13 241 14 550 15 2 16 1 18 2 2 16 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 13 11 8 14 8 3 13 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 13 12 6 18 4 19 3 4 12 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 13 11 6 14 6 5 11 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 13 10 1 14 8 15 2 6 4 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 13 11 2 14 2 7 3 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 13 09 3 8 3 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 13 18 3 9 2 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 13 11 1 14 1 10 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 13 09 1 20 1 11 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 13 11 1 14 1 12 2 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 13 11 1 14 1 13 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 13 11 1 14 1 14 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 13 10 1 20 1 15 2 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 13 11 1 14 1 16 2 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 13 11 1 14 1 17 2 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 #17
Day Hour Count Nov 13 11 1 14 1 18 2 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 #18
Day Hour Count Nov 13 10 1 20 1 19 2 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 #19
Day Hour Count Nov 13 10 1 20 1 20 2 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 #20
Day Hour Count Nov 13 10 1 20 1 21 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #21
Day Hour Count Nov 13 10 1 20 1 22 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 13 10 1 20 1 23 2 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 #23
Day Hour Count Nov 13 11 1 14 1 24 2 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 #24
Day Hour Count Nov 13 11 1 14 1 25 2 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #25
Day Hour Count Nov 13 11 1 14 1 26 2 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #26
Day Hour Count Nov 13 11 1 14 1 27 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #27
Day Hour Count Nov 13 11 1 14 1 28 2 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 #28
Day Hour Count Nov 13 11 1 14 1 29 2 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 Nov 13 10 1 20 1 30 2 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 #30
Day Hour Count Nov 13 10 1 20 1 31 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #31
Day Hour Count Nov 13 11 1 14 1 32 2 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #32
Day Hour Count Nov 13 11 1 14 1 33 2 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 #33
Day Hour Count Nov 13 11 1 14 1 34 2 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 #34
Day Hour Count Nov 13 11 1 14 1 35 2 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #35
Day Hour Count Nov 13 10 1 20 1 36 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #36
Day Hour Count Nov 13 20 1 37 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #37
Day Hour Count Nov 13 09 1 38 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #38
Day Hour Count Nov 13 09 1