pgBadger-
Global information
- Generated on Mon Nov 10 09:12:56 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=07/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=07/h=23/m=00/PT1H.log
- Parsed 6,292 log entries in 52s
- Log start from 2025-11-07 00:00:02 to 2025-11-07 23:08:32
-
Overview
Global Stats
- 70 Number of unique normalized queries
- 77 Number of queries
- 21m37s Total query duration
- 2025-11-07 01:00:46 First query
- 2025-11-07 20:50:13 Last query
- 4 queries/s at 2025-11-07 20:50:13 Query peak
- 21m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 21m37s Execute total duration
- 1,268 Number of events
- 39 Number of unique normalized events
- 1,136 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
- 205 Number temporary file
- 1.41 GiB Max size of temporary file
- 19.70 MiB Average size of temporary file
- 1,129 Total number of sessions
- 142 sessions at 2025-11-07 19:57:30 Session peak
- 5d13h38m10s Total duration of sessions
- 7m6s Average duration of sessions
- 0 Average queries per session
- 1s149ms Average queries duration per session
- 7m4s Average idle time per session
- 1,129 Total number of connections
- 10 connections/s at 2025-11-07 19:57:15 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-07 20:50:13 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-07 07:56:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-07 20:50:13 Date
Queries duration
Key values
- 21m37s 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 07 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 5s939ms 5s939ms 0ms 0ms 5s939ms 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 13 0ms 9s163ms 7s320ms 9s163ms 25s318ms 39s279ms 08 10 0ms 6s821ms 6s277ms 0ms 18s194ms 44s583ms 09 2 0ms 6s918ms 6s14ms 0ms 5s109ms 6s918ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 6 0ms 3m17s 1m5s 5s30ms 10s526ms 5m22s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 37 0ms 1m54s 17s770ms 1m40s 1m54s 2m49s 20 8 0ms 12s733ms 9s262ms 7s971ms 20s81ms 46s44ms 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 07 00 0 0 0ms 0ms 0ms 0ms 01 1 0 5s939ms 0ms 0ms 5s939ms 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 2 0 7s97ms 0ms 0ms 14s195ms 08 1 0 6s227ms 0ms 0ms 6s227ms 09 1 0 5s109ms 0ms 0ms 5s109ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 2 0 6s25ms 0ms 0ms 7s21ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 07 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 1 1 0 0 8s637ms 0ms 0ms 8s112ms 08 0 0 1 0 6s229ms 0ms 0ms 6s229ms 09 0 0 1 0 6s918ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 1 1 0 1m25s 0ms 0ms 45s398ms 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 30s163ms 0ms 0ms 54s290ms 20 1 0 0 0 12s733ms 0ms 0ms 12s733ms 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 07 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 0 13 13.00 0.00% 08 0 10 10.00 0.00% 09 0 2 2.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 6 6.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 8 8.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 07 00 30 0.01/s 01 36 0.01/s 02 30 0.01/s 03 38 0.01/s 04 37 0.01/s 05 39 0.01/s 06 15 0.00/s 07 37 0.01/s 08 43 0.01/s 09 74 0.02/s 10 84 0.02/s 11 90 0.03/s 12 60 0.02/s 13 53 0.01/s 14 119 0.03/s 15 52 0.01/s 16 60 0.02/s 17 43 0.01/s 18 29 0.01/s 19 62 0.02/s 20 20 0.01/s 21 30 0.01/s 22 27 0.01/s 23 21 0.01/s Day Hour Count Average Duration Average idle time Nov 07 00 26 2m43s 2m43s 01 40 2m40s 2m40s 02 30 3m22s 3m22s 03 38 2m31s 2m31s 04 37 2m18s 2m18s 05 38 2m44s 2m44s 06 16 4m3s 4m3s 07 40 2m41s 2m39s 08 36 4m1s 4m 09 73 1m51s 1m51s 10 87 7m56s 7m56s 11 89 4m8s 4m8s 12 57 7m50s 7m50s 13 57 5m39s 5m39s 14 122 29m38s 29m34s 15 56 6m21s 6m21s 16 60 4m32s 4m32s 17 40 2m 2m 18 30 9m33s 9m33s 19 60 3m38s 3m27s 20 23 4m2s 3m59s 21 30 2m59s 2m59s 22 27 2m55s 2m55s 23 17 4m41s 4m41s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-11-07 19:57:15 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 1,129 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,129 connections Total
-
Sessions
Simultaneous sessions
Key values
- 142 sessions Session Peak
- 2025-11-07 19:57:30 Date
Histogram of session times
Key values
- 871 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 1,129 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,129 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,129 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 1,129 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 2 7h3m10s 3h31m35s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 2 6h57m16s 3h28m38s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 3 7h2m7s 2h20m42s DBeaver 25.1.0 - Main 'autotest_feat_batch' 1 1h50m31s 1h50m31s DBeaver 25.1.0 - Metadata 'autotest_feat_batch' 1 1h50m30s 1h50m30s DBeaver 25.1.0 - SQLEditor 'Script-1.sql' 1 1h50m29s 1h50m29s IntelliJ IDEA 2024.3.5 5 5h19m48s 1h3m57s PostgreSQL JDBC Driver 1,012 4d5h8m56s 5m59s [unknown] 93 10s332ms 111ms pg_restore 4 33m15s 8m18s psql 5 1m54s 22s927ms -
Temporary Files
Size of temporary files
Key values
- 392.78 MiB Temp Files size Peak
- 2025-11-07 19:40:16 Date
Number of temporary files
Key values
- 9 per second Temp Files Peak
- 2025-11-07 19:43:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 2 8.38 MiB 4.19 MiB 10 2 8.38 MiB 4.19 MiB 11 4 16.75 MiB 4.19 MiB 12 2 8.38 MiB 4.19 MiB 13 2 8.38 MiB 4.19 MiB 14 28 119.50 MiB 4.27 MiB 15 2 8.38 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 163 3.77 GiB 23.68 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 80.34 MiB 2.30 MiB 15.63 MiB 5.36 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('202001021430', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021430', '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-07 14:30:55 Duration: 5s30ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 8 26.59 MiB 2.24 MiB 8.79 MiB 3.32 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-07 14:27:52 Duration: 3m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 3 151.65 MiB 17.02 MiB 116.09 MiB 50.55 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-07 19:42:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 642.80 MiB 31.44 MiB 578.13 MiB 214.27 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-07 19:39:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 229.86 MiB 29.62 MiB 164.94 MiB 76.62 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-07 19:41:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 67.88 MiB 5.27 MiB 57.19 MiB 22.63 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2025-11-07 19:42:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 13.15 MiB 3.46 MiB 5.77 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-07 19:43:08 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 51.68 MiB 3.34 MiB 44.54 MiB 17.23 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-07 19:39:40 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 180.42 MiB 17.86 MiB 142.02 MiB 60.14 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-07 19:41:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 13.81 MiB 4.08 MiB 5.62 MiB 4.60 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-07 19:42:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 35.84 MiB 8.73 MiB 13.67 MiB 11.95 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-07 19:42:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 246.60 MiB 50.98 MiB 119.42 MiB 82.20 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-07 19:41:09 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3 92.05 MiB 27.49 MiB 32.58 MiB 30.68 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-07 19:42:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 21.20 MiB 3.59 MiB 17.61 MiB 10.60 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-07 19:43:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2 68.50 MiB 34.00 MiB 34.50 MiB 34.25 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-07 19:41:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 1.41 GiB 1.41 GiB 1.41 GiB 1.41 GiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
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-07 19:38:12 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 321.90 MiB 321.90 MiB 321.90 MiB 321.90 MiB add constraint fk_gtp_month_histo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-07 19:41:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 195.96 MiB 195.96 MiB 195.96 MiB 195.96 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-07 19:40:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 10.18 MiB 10.18 MiB 10.18 MiB 10.18 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-07 19:43:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.41 GiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-07 19:38:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 578.13 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-07 19:39:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 321.90 MiB ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-07 19:41:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 195.96 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-11-07 19:40:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 164.94 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-07 19:41:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 142.02 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2025-11-07 19:41:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 119.42 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-07 19:41:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 116.09 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-07 19:42:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 76.20 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-07 19:41:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 57.19 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-11-07 19:42:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 50.98 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-07 19:41:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 44.54 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-07 19:39:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 35.30 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-07 19:41:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 34.50 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-07 19:41:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 34.00 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-07 19:41:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 33.23 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-07 19:39:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 32.58 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-07 19:42:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 31.98 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-07 19:42:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 31.44 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-07 19:39:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 29.62 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-07 19:41:05 - 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 07 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
- ShareRowExclusiveLock 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
- 7 Total read queries
- 67 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 77 Requests
- 21m37s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 77 Requests
User Request type Count Duration a3dsupervisor Total 77 21m37s copy from 6 3m ddl 30 6m2s delete 3 58s546ms insert 2 20s846ms others 3 5m22s select 7 43s524ms tcl 24 2m55s update 2 2m14s Duration by user
Key values
- 21m37s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 77 21m37s copy from 6 3m ddl 30 6m2s delete 3 58s546ms insert 2 20s846ms others 3 5m22s select 7 43s524ms tcl 24 2m55s update 2 2m14s Queries by host
Key values
- 10.3.0.4 Main host
- 77 Requests
- 21m37s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 40 Requests
- 10m40s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-07 09:11:22 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 45 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m17s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-07 14:27:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 2m5s UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;[ Date: 2025-11-07 14:27:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 1m54s VACUUM ANALYSE;[ Date: 2025-11-07 19:56:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 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-07 19:38:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 45s398ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-07 14:34:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 34s725ms 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-07 19:37:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 32s419ms 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-07 19:40:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 31s617ms 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-07 19:40:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 27s131ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);[ Date: 2025-11-07 19:38:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 23s996ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-11-07 19:38:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 22s672ms 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-07 19:40:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 21s172ms 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-07 19:39:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 16s589ms 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-07 19:39:14 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 16s551ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-11-07 19:38:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 15s847ms CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);[ Date: 2025-11-07 19:39:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 14s499ms CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);[ Date: 2025-11-07 19:38:28 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 13s697ms 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-07 19:42:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 13s449ms CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);[ Date: 2025-11-07 19:39:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 13s179ms 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-07 19:42:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 13s163ms 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-07 19:41:42 - 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 3m17s 1 3m17s 3m17s 3m17s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 07 15 1 3m17s 3m17s [ User: a3dsupervisor - Total duration: 3m17s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m17s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-07 14:27:52 Duration: 3m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m55s 24 5s14ms 11s107ms 7s307ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 07 08 9 1m3s 7s76ms 09 8 50s320ms 6s290ms 21 7 1m1s 8s766ms [ User: a3dsupervisor - Total duration: 2m55s - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m55s - Times executed: 24 ]
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s107ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s103ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s100ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m5s 1 2m5s 2m5s 2m5s update log_session set session_status = where session_status = and server_id =;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 07 15 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m5s - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;
Date: 2025-11-07 14:27:52 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1m54s 1 1m54s 1m54s 1m54s vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 07 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 1 ]
[ Application: psql - Total duration: 1m54s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-07 19:56:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1m5s 1 1m5s 1m5s 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;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 07 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-07 19:38:16 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 52s317ms 2 6s918ms 45s398ms 26s158ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 07 10 1 6s918ms 6s918ms 15 1 45s398ms 45s398ms [ User: a3dsupervisor - Total duration: 52s317ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52s317ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 14:34:48 Duration: 45s398ms 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-07 09:20:08 Duration: 6s918ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 34s725ms 1 34s725ms 34s725ms 34s725ms 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 07 20 1 34s725ms 34s725ms [ User: a3dsupervisor - Total duration: 34s725ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s725ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-07 19:37:45 Duration: 34s725ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 32s419ms 1 32s419ms 32s419ms 32s419ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 07 20 1 32s419ms 32s419ms [ User: a3dsupervisor - Total duration: 32s419ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s419ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:40:16 Duration: 32s419ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 31s617ms 1 31s617ms 31s617ms 31s617ms 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 #9
Day Hour Count Duration Avg duration Nov 07 20 1 31s617ms 31s617ms [ User: a3dsupervisor - Total duration: 31s617ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s617ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-07 19:40:50 Duration: 31s617ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 27s131ms 1 27s131ms 27s131ms 27s131ms 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 07 20 1 27s131ms 27s131ms [ User: a3dsupervisor - Total duration: 27s131ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s131ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-07 19:38:13 Duration: 27s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 23s996ms 1 23s996ms 23s996ms 23s996ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 07 20 1 23s996ms 23s996ms [ User: a3dsupervisor - Total duration: 23s996ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s996ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-07 19:38:40 Duration: 23s996ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 22s672ms 1 22s672ms 22s672ms 22s672ms 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 07 20 1 22s672ms 22s672ms [ User: a3dsupervisor - Total duration: 22s672ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 22s672ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-07 19:40:38 Duration: 22s672ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 21s172ms 1 21s172ms 21s172ms 21s172ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 07 20 1 21s172ms 21s172ms [ User: a3dsupervisor - Total duration: 21s172ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s172ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:39:23 Duration: 21s172ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 16s589ms 1 16s589ms 16s589ms 16s589ms 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 #14
Day Hour Count Duration Avg duration Nov 07 20 1 16s589ms 16s589ms [ User: a3dsupervisor - Total duration: 16s589ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s589ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-07 19:39:14 Duration: 16s589ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 16s551ms 1 16s551ms 16s551ms 16s551ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 07 20 1 16s551ms 16s551ms [ User: a3dsupervisor - Total duration: 16s551ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s551ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-07 19:38:44 Duration: 16s551ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 15s847ms 1 15s847ms 15s847ms 15s847ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 07 20 1 15s847ms 15s847ms [ User: a3dsupervisor - Total duration: 15s847ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s847ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-11-07 19:39:30 Duration: 15s847ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 14s499ms 1 14s499ms 14s499ms 14s499ms create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 07 20 1 14s499ms 14s499ms [ User: a3dsupervisor - Total duration: 14s499ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s499ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-11-07 19:38:28 Duration: 14s499ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 13s697ms 1 13s697ms 13s697ms 13s697ms 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 07 20 1 13s697ms 13s697ms [ User: a3dsupervisor - Total duration: 13s697ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s697ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-11-07 19:42:43 Duration: 13s697ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 13s449ms 1 13s449ms 13s449ms 13s449ms create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 07 20 1 13s449ms 13s449ms [ User: a3dsupervisor - Total duration: 13s449ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s449ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-07 19:39:43 Duration: 13s449ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 13s179ms 1 13s179ms 13s179ms 13s179ms 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 #20
Day Hour Count Duration Avg duration Nov 07 20 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 13s179ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s179ms - Times executed: 1 ]
-
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-07 19:42:15 Duration: 13s179ms 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 24 2m55s 5s14ms 11s107ms 7s307ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 07 08 9 1m3s 7s76ms 09 8 50s320ms 6s290ms 21 7 1m1s 8s766ms [ User: a3dsupervisor - Total duration: 2m55s - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m55s - Times executed: 24 ]
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s107ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s103ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s100ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2 52s317ms 6s918ms 45s398ms 26s158ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 07 10 1 6s918ms 6s918ms 15 1 45s398ms 45s398ms [ User: a3dsupervisor - Total duration: 52s317ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52s317ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 14:34:48 Duration: 45s398ms 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-07 09:20:08 Duration: 6s918ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1 3m17s 3m17s 3m17s 3m17s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 07 15 1 3m17s 3m17s [ User: a3dsupervisor - Total duration: 3m17s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m17s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-07 14:27:52 Duration: 3m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 2m5s 2m5s 2m5s 2m5s update log_session set session_status = where session_status = and server_id =;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 07 15 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m5s - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;
Date: 2025-11-07 14:27:52 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1 1m54s 1m54s 1m54s 1m54s vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 07 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 1 ]
[ Application: psql - Total duration: 1m54s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-07 19:56:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1 1m5s 1m5s 1m5s 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;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 07 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-07 19:38:16 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1 34s725ms 34s725ms 34s725ms 34s725ms 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 07 20 1 34s725ms 34s725ms [ User: a3dsupervisor - Total duration: 34s725ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s725ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-07 19:37:45 Duration: 34s725ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 32s419ms 32s419ms 32s419ms 32s419ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 07 20 1 32s419ms 32s419ms [ User: a3dsupervisor - Total duration: 32s419ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s419ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:40:16 Duration: 32s419ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 31s617ms 31s617ms 31s617ms 31s617ms 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 #9
Day Hour Count Duration Avg duration Nov 07 20 1 31s617ms 31s617ms [ User: a3dsupervisor - Total duration: 31s617ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s617ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-07 19:40:50 Duration: 31s617ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 27s131ms 27s131ms 27s131ms 27s131ms 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 07 20 1 27s131ms 27s131ms [ User: a3dsupervisor - Total duration: 27s131ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s131ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-07 19:38:13 Duration: 27s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 23s996ms 23s996ms 23s996ms 23s996ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 07 20 1 23s996ms 23s996ms [ User: a3dsupervisor - Total duration: 23s996ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s996ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-07 19:38:40 Duration: 23s996ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 22s672ms 22s672ms 22s672ms 22s672ms 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 07 20 1 22s672ms 22s672ms [ User: a3dsupervisor - Total duration: 22s672ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 22s672ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-07 19:40:38 Duration: 22s672ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 21s172ms 21s172ms 21s172ms 21s172ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 07 20 1 21s172ms 21s172ms [ User: a3dsupervisor - Total duration: 21s172ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s172ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:39:23 Duration: 21s172ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 16s589ms 16s589ms 16s589ms 16s589ms 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 #14
Day Hour Count Duration Avg duration Nov 07 20 1 16s589ms 16s589ms [ User: a3dsupervisor - Total duration: 16s589ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s589ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-07 19:39:14 Duration: 16s589ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 16s551ms 16s551ms 16s551ms 16s551ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 07 20 1 16s551ms 16s551ms [ User: a3dsupervisor - Total duration: 16s551ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s551ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-07 19:38:44 Duration: 16s551ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 15s847ms 15s847ms 15s847ms 15s847ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 07 20 1 15s847ms 15s847ms [ User: a3dsupervisor - Total duration: 15s847ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s847ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-11-07 19:39:30 Duration: 15s847ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 14s499ms 14s499ms 14s499ms 14s499ms create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 07 20 1 14s499ms 14s499ms [ User: a3dsupervisor - Total duration: 14s499ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s499ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-11-07 19:38:28 Duration: 14s499ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 13s697ms 13s697ms 13s697ms 13s697ms 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 07 20 1 13s697ms 13s697ms [ User: a3dsupervisor - Total duration: 13s697ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s697ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-11-07 19:42:43 Duration: 13s697ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 13s449ms 13s449ms 13s449ms 13s449ms create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 07 20 1 13s449ms 13s449ms [ User: a3dsupervisor - Total duration: 13s449ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s449ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-07 19:39:43 Duration: 13s449ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 13s179ms 13s179ms 13s179ms 13s179ms 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 #20
Day Hour Count Duration Avg duration Nov 07 20 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 13s179ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s179ms - Times executed: 1 ]
-
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-07 19:42:15 Duration: 13s179ms 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 3m17s 3m17s 3m17s 1 3m17s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 07 15 1 3m17s 3m17s [ User: a3dsupervisor - Total duration: 3m17s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m17s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-07 14:27:52 Duration: 3m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m5s 2m5s 2m5s 1 2m5s update log_session set session_status = where session_status = and server_id =;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 07 15 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m5s - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;
Date: 2025-11-07 14:27:52 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1m54s 1m54s 1m54s 1 1m54s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 07 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 1 ]
[ Application: psql - Total duration: 1m54s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-07 19:56:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1m5s 1m5s 1m5s 1 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 07 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-07 19:38:16 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 34s725ms 34s725ms 34s725ms 1 34s725ms 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 #5
Day Hour Count Duration Avg duration Nov 07 20 1 34s725ms 34s725ms [ User: a3dsupervisor - Total duration: 34s725ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s725ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-07 19:37:45 Duration: 34s725ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 32s419ms 32s419ms 32s419ms 1 32s419ms 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 #6
Day Hour Count Duration Avg duration Nov 07 20 1 32s419ms 32s419ms [ User: a3dsupervisor - Total duration: 32s419ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s419ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:40:16 Duration: 32s419ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 31s617ms 31s617ms 31s617ms 1 31s617ms 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 #7
Day Hour Count Duration Avg duration Nov 07 20 1 31s617ms 31s617ms [ User: a3dsupervisor - Total duration: 31s617ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s617ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-07 19:40:50 Duration: 31s617ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 27s131ms 27s131ms 27s131ms 1 27s131ms 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 #8
Day Hour Count Duration Avg duration Nov 07 20 1 27s131ms 27s131ms [ User: a3dsupervisor - Total duration: 27s131ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s131ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-07 19:38:13 Duration: 27s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 6s918ms 45s398ms 26s158ms 2 52s317ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 07 10 1 6s918ms 6s918ms 15 1 45s398ms 45s398ms [ User: a3dsupervisor - Total duration: 52s317ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 52s317ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 14:34:48 Duration: 45s398ms 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-07 09:20:08 Duration: 6s918ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 23s996ms 23s996ms 23s996ms 1 23s996ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 07 20 1 23s996ms 23s996ms [ User: a3dsupervisor - Total duration: 23s996ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s996ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-07 19:38:40 Duration: 23s996ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 22s672ms 22s672ms 22s672ms 1 22s672ms 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 #11
Day Hour Count Duration Avg duration Nov 07 20 1 22s672ms 22s672ms [ User: a3dsupervisor - Total duration: 22s672ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 22s672ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-07 19:40:38 Duration: 22s672ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 21s172ms 21s172ms 21s172ms 1 21s172ms 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 07 20 1 21s172ms 21s172ms [ User: a3dsupervisor - Total duration: 21s172ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s172ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:39:23 Duration: 21s172ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 16s589ms 16s589ms 16s589ms 1 16s589ms 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 #13
Day Hour Count Duration Avg duration Nov 07 20 1 16s589ms 16s589ms [ User: a3dsupervisor - Total duration: 16s589ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s589ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-11-07 19:39:14 Duration: 16s589ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 16s551ms 16s551ms 16s551ms 1 16s551ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 07 20 1 16s551ms 16s551ms [ User: a3dsupervisor - Total duration: 16s551ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s551ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-07 19:38:44 Duration: 16s551ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 15s847ms 15s847ms 15s847ms 1 15s847ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 07 20 1 15s847ms 15s847ms [ User: a3dsupervisor - Total duration: 15s847ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s847ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-11-07 19:39:30 Duration: 15s847ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 14s499ms 14s499ms 14s499ms 1 14s499ms create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 07 20 1 14s499ms 14s499ms [ User: a3dsupervisor - Total duration: 14s499ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s499ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-11-07 19:38:28 Duration: 14s499ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 13s697ms 13s697ms 13s697ms 1 13s697ms 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 #17
Day Hour Count Duration Avg duration Nov 07 20 1 13s697ms 13s697ms [ User: a3dsupervisor - Total duration: 13s697ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s697ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-11-07 19:42:43 Duration: 13s697ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 13s449ms 13s449ms 13s449ms 1 13s449ms create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 07 20 1 13s449ms 13s449ms [ User: a3dsupervisor - Total duration: 13s449ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s449ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-07 19:39:43 Duration: 13s449ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 13s179ms 13s179ms 13s179ms 1 13s179ms 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 #19
Day Hour Count Duration Avg duration Nov 07 20 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 13s179ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 13s179ms - Times executed: 1 ]
-
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-07 19:42:15 Duration: 13s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5s14ms 11s107ms 7s307ms 24 2m55s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 07 08 9 1m3s 7s76ms 09 8 50s320ms 6s290ms 21 7 1m1s 8s766ms [ User: a3dsupervisor - Total duration: 2m55s - Times executed: 24 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m55s - Times executed: 24 ]
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s107ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s103ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-07 20:50:13 Duration: 11s100ms 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,947 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1254 ERROR entries
- 14 WARNING entries
Most Frequent Errors/Events
Key values
- 1,136 Max number of times the same event was reported
- 1,268 Total events found
Rank Times reported Error 1 1,136 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 07 01 10 21 106 22 227 23 245 00 548 2 74 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 07 10 2 11 7 12 16 13 4 14 14 15 18 16 7 17 3 19 3 3 8 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 07 15 8 4 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 07 10 3 11 3 5 6 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 07 15 6 6 3 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 07 15 3 7 2 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 07 15 2 8 2 ERROR: canceling statement due to lock timeoutselect LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 07 15 2 9 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 07 15 1 10 1 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 07 15 1 11 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 07 15 1 12 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_TIME_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 07 15 1 13 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 07 15 1 14 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 07 15 1 15 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 07 20 1 16 1 ERROR: canceling statement due to lock timeoutselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 07 15 1 17 1 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 07 20 1 18 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 07 20 1 19 1 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #19
Day Hour Count Nov 07 20 1 20 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (...) REFERENCES public.gtp_rel_template(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #20
Day Hour Count Nov 07 20 1 21 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #21
Day Hour Count Nov 07 20 1 22 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 07 15 1 23 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 07 20 1 24 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 07 20 1 25 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #25
Day Hour Count Nov 07 15 1 26 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #26
Day Hour Count Nov 07 15 1 27 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #27
Day Hour Count Nov 07 15 1 28 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #28
Day Hour Count Nov 07 20 1 29 1 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #29
Day Hour Count Nov 07 15 1 30 1 ERROR: null value in column "..." of relation "..." violates not-null constraintSELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #30
Day Hour Count Nov 07 15 1 31 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #31
Day Hour Count Nov 07 20 1 32 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msUPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =
Times Reported Most Frequent Error / Event #32
Day Hour Count Nov 07 15 1 33 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #33
Day Hour Count Nov 07 15 1 34 1 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #34
Day Hour Count Nov 07 20 1 35 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #35
Day Hour Count Nov 07 15 1 36 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #36
Day Hour Count Nov 07 20 1 37 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #37
Day Hour Count Nov 07 15 1 38 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history
Times Reported Most Frequent Error / Event #38
Day Hour Count Nov 07 20 1 39 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #39
Day Hour Count Nov 07 20 1