pgBadger-
Global information
- Generated on Wed Nov 5 09:20:00 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=04/h=23/m=00/PT1H.log
- Parsed 7,822 log entries in 1m7s
- Log start from 2025-11-04 10:56:34 to 2025-11-04 23:30:02
-
Overview
Global Stats
- 61 Number of unique normalized queries
- 75 Number of queries
- 24m49s Total query duration
- 2025-11-04 01:01:11 First query
- 2025-11-04 20:35:57 Last query
- 4 queries/s at 2025-11-04 07:58:45 Query peak
- 24m49s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 24m49s Execute total duration
- 1,504 Number of events
- 41 Number of unique normalized events
- 1,319 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
- 246 Number temporary file
- 824.22 MiB Max size of temporary file
- 17.35 MiB Average size of temporary file
- 1,465 Total number of sessions
- 91 sessions at 2025-11-04 18:52:24 Session peak
- 5d11h26m58s Total duration of sessions
- 5m23s Average duration of sessions
- 0 Average queries per session
- 1s16ms Average queries duration per session
- 5m21s Average idle time per session
- 1,467 Total number of connections
- 10 connections/s at 2025-11-04 13:07:02 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-04 07:58:45 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-04 13:10:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-04 07:58:45 Date
Queries duration
Key values
- 24m49s 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 04 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 6s490ms 6s490ms 0ms 0ms 6s490ms 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 9s422ms 7s383ms 0ms 24s695ms 54s467ms 08 10 0ms 15s900ms 8s554ms 0ms 18s976ms 49s708ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 1 0ms 6s979ms 6s979ms 0ms 0ms 6s979ms 13 5 0ms 3m14s 59s9ms 0ms 11s837ms 4m9s 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 5 0ms 3m45s 55s341ms 0ms 14s185ms 3m45s 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 34 0ms 2m6s 20s226ms 2m5s 2m6s 2m39s 20 6 0ms 6s662ms 5s846ms 0ms 0ms 35s76ms 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 04 00 0 0 0ms 0ms 0ms 0ms 01 1 0 6s490ms 0ms 0ms 6s490ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 1 0 6s979ms 0ms 0ms 6s979ms 13 1 0 6s223ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 2 0 7s92ms 0ms 0ms 14s185ms 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 04 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 0 0 0 0ms 0ms 0ms 0ms 08 2 0 0 0 10s456ms 0ms 0ms 5s12ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 1 0 27s412ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 1 0 27s893ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 6 30s484ms 0ms 0ms 59s179ms 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 04 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 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 1 1.00 0.00% 13 0 5 5.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 6 6.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 04 00 43 0.01/s 01 41 0.01/s 02 54 0.01/s 03 40 0.01/s 04 49 0.01/s 05 39 0.01/s 06 47 0.01/s 07 43 0.01/s 08 44 0.01/s 09 51 0.01/s 10 101 0.03/s 11 67 0.02/s 12 65 0.02/s 13 123 0.03/s 14 85 0.02/s 15 92 0.03/s 16 153 0.04/s 17 44 0.01/s 18 37 0.01/s 19 61 0.02/s 20 38 0.01/s 21 48 0.01/s 22 44 0.01/s 23 58 0.02/s Day Hour Count Average Duration Average idle time Nov 04 00 43 2m2s 2m2s 01 39 2m16s 2m16s 02 53 1m43s 1m43s 03 44 1m58s 1m58s 04 48 1m56s 1m56s 05 40 2m14s 2m14s 06 46 1m50s 1m50s 07 44 2m17s 2m15s 08 45 2m25s 2m24s 09 52 1m47s 1m47s 10 93 1m14s 1m14s 11 70 2m51s 2m51s 12 57 4m21s 4m20s 13 122 24m44s 24m41s 14 88 3m36s 3m36s 15 96 14m57s 14m57s 16 155 3m13s 3m13s 17 48 2m28s 2m23s 18 37 9m27s 9m27s 19 58 3m47s 3m35s 20 40 2m4s 2m3s 21 49 3m4s 3m4s 22 44 2m19s 2m19s 23 54 1m53s 1m53s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-11-04 13:07:02 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 1,467 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,467 connections Total
-
Sessions
Simultaneous sessions
Key values
- 91 sessions Session Peak
- 2025-11-04 18:52:24 Date
Histogram of session times
Key values
- 1,229 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 1,465 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,465 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,465 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 1,465 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 1 38m35s 38m35s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 1 38m34s 38m34s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 1 38m29s 38m29s DBeaver 24.0.0 - Main 'autotest_feat_batch' 1 9m24s 9m24s DBeaver 24.0.0 - Metadata 'autotest_feat_batch' 1 9m23s 9m23s IntelliJ IDEA 2024.3.5 26 20h34m27s 47m28s PostgreSQL JDBC Driver 1,360 4d12h4m6s 4m46s [unknown] 65 9s13ms 138ms pg_restore 4 31m41s 7m55s psql 5 2m6s 25s350ms -
Temporary Files
Size of temporary files
Key values
- 400.84 MiB Temp Files size Peak
- 2025-11-04 19:40:35 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-11-04 13:10:16 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 2 8.38 MiB 4.19 MiB 11 1 4.19 MiB 4.19 MiB 12 0 0 0 13 31 130.13 MiB 4.20 MiB 14 3 12.56 MiB 4.19 MiB 15 5 20.94 MiB 4.19 MiB 16 6 25.12 MiB 4.19 MiB 17 26 109.19 MiB 4.20 MiB 18 0 0 0 19 172 3.86 GiB 23.01 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 3 78.82 MiB 21.78 MiB 34.47 MiB 26.27 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-11-04 19:43:21 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 3 251.04 MiB 3.88 MiB 241.88 MiB 83.68 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-04 19:40:37 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 3 26.74 MiB 4.49 MiB 16.13 MiB 8.91 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-11-04 19:40:29 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 46.38 MiB 4.04 MiB 38.19 MiB 15.46 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-04 19:43:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 185.69 MiB 30.95 MiB 123.29 MiB 61.90 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-04 19:41:23 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 894.52 MiB 131.28 MiB 625.84 MiB 298.17 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-04 19:39:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 107.50 MiB 11.52 MiB 82.05 MiB 35.83 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-04 19:43:12 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 72.44 MiB 3.88 MiB 63.74 MiB 24.15 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-04 19:40:31 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 13.15 MiB 2.57 MiB 7.63 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-04 19:43:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 205.52 MiB 22.49 MiB 157.08 MiB 68.51 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-04 19:41:45 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 369.87 MiB 15.27 MiB 339.12 MiB 123.29 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-04 19:42:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 230.62 MiB 29.39 MiB 169.81 MiB 76.88 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-04 19:38:52 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3 92.05 MiB 28.08 MiB 32.55 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-04 19:43:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 62.25 MiB 31.13 MiB 31.13 MiB 31.13 MiB select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) 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('202001021309', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021309', '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-04 13:10:01 Duration: 6s223ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021708', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021708', '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-04 17:08:45 Duration: 6s99ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
15 2 178.10 MiB 78.51 MiB 99.59 MiB 89.05 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-04 19:42:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 824.22 MiB 824.22 MiB 824.22 MiB 824.22 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-04 19:38:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 13.30 MiB 13.30 MiB 13.30 MiB 13.30 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-04 19:43:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 236.21 MiB 236.21 MiB 236.21 MiB 236.21 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-04 19:41:34 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 824.22 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-11-04 19:38:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 625.84 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-04 19:39:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 339.12 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-04 19:42:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 241.88 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-11-04 19:40:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 236.21 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;[ Date: 2025-11-04 19:41:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 169.81 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-04 19:38:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 157.08 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-04 19:41:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 137.41 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-04 19:40:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 131.28 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-04 19:40:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 123.29 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-04 19:41:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 99.59 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-04 19:42:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 82.05 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-11-04 19:43:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 78.51 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-04 19:42:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 63.74 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-11-04 19:40:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 38.19 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-04 19:43:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 34.47 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2025-11-04 19:43:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 32.55 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-04 19:43:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 31.45 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-04 19:41:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 31.42 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-04 19:39:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 31.41 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-04 19:43:00 - 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 04 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
- AccessShareLock Main Lock Type
- 7 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 1 55s75ms 55s75ms relation 1 55s75ms 55s75ms AccessShareLock 2 6s346ms 3s173ms relation 2 6s346ms 3s173ms ShareLock 2 3s426ms 1s713ms relation 1 1s260ms 1s260ms transaction 1 2s165ms 2s165ms ShareRowExclusiveLock 1 1s4ms 1s4ms relation 1 1s4ms 1s4ms ShareUpdateExclusiveLock 1 1s15ms 1s15ms relation 1 1s15ms 1s15ms Total 7 1m6s 9s552ms 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
- 5 Total read queries
- 64 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 75 Requests
- 24m49s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 75 Requests
User Request type Count Duration a3dsupervisor Total 75 24m49s copy from 6 3m2s ddl 26 6m12s delete 2 55s305ms insert 2 20s912ms others 6 10m22s select 5 33s879ms tcl 28 3m21s Duration by user
Key values
- 24m49s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 75 24m49s copy from 6 3m2s ddl 26 6m12s delete 2 55s305ms insert 2 20s912ms others 6 10m22s select 5 33s879ms tcl 28 3m21s Queries by host
Key values
- 10.3.0.4 Main host
- 75 Requests
- 24m49s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 41 Requests
- 13m21s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-04 14:35:20 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 44 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m45s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-04 17:07:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 3m14s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-04 13:08:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 2m6s VACUUM ANALYSE;[ Date: 2025-11-04 19:55:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 1m6s 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-04 19:38:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 55s77ms -- REVOKE ALL ON FUNCTION a3d_gtp_reftk.touppernoaccent (p_string text) FROM PUBLIC;DROP TRIGGER IF EXISTS t_bef_ins_er_gtp_obj ON gtp_obj CASCADE;[ Date: 2025-11-04 13:08:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 38s668ms 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-04 19:40:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 34s877ms 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-04 19:37:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 32s693ms 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-04 19:41:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 32s515ms 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-04 19:39:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 27s893ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-04 17:11:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 27s412ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-04 13:12:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 26s486ms 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-04 19:41:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 25s485ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);[ Date: 2025-11-04 19:38:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 23s481ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-11-04 19:38:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 20s297ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-11-04 19:38:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 18s510ms 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-04 19:39:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 16s840ms 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-04 19:39:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 16s1ms CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);[ Date: 2025-11-04 19:38:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 15s900ms insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);[ Date: 2025-11-04 08:00:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 15s829ms 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-04 19:39:56 - 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 6m59s 2 3m14s 3m45s 3m29s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 04 14 1 3m14s 3m14s 18 1 3m45s 3m45s [ User: a3dsupervisor - Total duration: 6m59s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m59s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-04 17:07:01 Duration: 3m45s 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-04 13:08:05 Duration: 3m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3m21s 28 5s71ms 13s469ms 7s195ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 04 08 13 1m35s 7s383ms 09 8 1m4s 8s78ms 20 1 5s782ms 5s782ms 21 6 35s76ms 5s846ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 28 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m15s - Times executed: 27 ]
[ Application: pg_restore - Total duration: 5s782ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 13s469ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 11s886ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 07:58:45 Duration: 9s422ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m6s 1 2m6s 2m6s 2m6s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 04 20 1 2m6s 2m6s [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 1 ]
[ Application: psql - Total duration: 2m6s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-04 19:55:38 Duration: 2m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1m6s 1 1m6s 1m6s 1m6s 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 04 20 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m6s - 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-04 19:38:22 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 55s305ms 2 27s412ms 27s893ms 27s652ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 04 14 1 27s412ms 27s412ms 18 1 27s893ms 27s893ms [ User: a3dsupervisor - Total duration: 55s305ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s305ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-04 17:11:21 Duration: 27s893ms 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-04 13:12:52 Duration: 27s412ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 55s77ms 1 55s77ms 55s77ms 55s77ms -- revoke all on function a3d_gtp_reftk.touppernoaccent (p_string text) from public;drop trigger if exists t_bef_ins_er_gtp_obj on gtp_obj cascade;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 04 14 1 55s77ms 55s77ms [ User: a3dsupervisor - Total duration: 55s77ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s77ms - Times executed: 1 ]
-
-- REVOKE ALL ON FUNCTION a3d_gtp_reftk.touppernoaccent (p_string text) FROM PUBLIC;DROP TRIGGER IF EXISTS t_bef_ins_er_gtp_obj ON gtp_obj CASCADE;
Date: 2025-11-04 13:08:05 Duration: 55s77ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 38s668ms 1 38s668ms 38s668ms 38s668ms 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 04 20 1 38s668ms 38s668ms [ User: a3dsupervisor - Total duration: 38s668ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s668ms - 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-04 19:40:35 Duration: 38s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 34s877ms 1 34s877ms 34s877ms 34s877ms 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 04 20 1 34s877ms 34s877ms [ User: a3dsupervisor - Total duration: 34s877ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s877ms - 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-04 19:37:50 Duration: 34s877ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 32s693ms 1 32s693ms 32s693ms 32s693ms 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 04 20 1 32s693ms 32s693ms [ User: a3dsupervisor - Total duration: 32s693ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s693ms - 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-04 19:41:15 Duration: 32s693ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 32s515ms 1 32s515ms 32s515ms 32s515ms 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 #10
Day Hour Count Duration Avg duration Nov 04 20 1 32s515ms 32s515ms [ User: a3dsupervisor - Total duration: 32s515ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s515ms - 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-04 19:39:39 Duration: 32s515ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 26s486ms 1 26s486ms 26s486ms 26s486ms 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 04 20 1 26s486ms 26s486ms [ User: a3dsupervisor - Total duration: 26s486ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s486ms - 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-04 19:41:04 Duration: 26s486ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 25s485ms 1 25s485ms 25s485ms 25s485ms 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 #12
Day Hour Count Duration Avg duration Nov 04 20 1 25s485ms 25s485ms [ User: a3dsupervisor - Total duration: 25s485ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s485ms - 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-04 19:38:16 Duration: 25s485ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 23s481ms 1 23s481ms 23s481ms 23s481ms 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 04 20 1 23s481ms 23s481ms [ User: a3dsupervisor - Total duration: 23s481ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s481ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-04 19:38:45 Duration: 23s481ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 21s17ms 2 9s179ms 11s837ms 10s508ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 04 14 1 11s837ms 11s837ms 18 1 9s179ms 9s179ms [ User: a3dsupervisor - Total duration: 21s17ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21s17ms - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 13:04:38 Duration: 11s837ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 17:03:10 Duration: 9s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 20s297ms 1 20s297ms 20s297ms 20s297ms 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 04 20 1 20s297ms 20s297ms [ User: a3dsupervisor - Total duration: 20s297ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s297ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-04 19:38:52 Duration: 20s297ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 18s510ms 1 18s510ms 18s510ms 18s510ms 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 04 20 1 18s510ms 18s510ms [ User: a3dsupervisor - Total duration: 18s510ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s510ms - 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-04 19:39:40 Duration: 18s510ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 16s840ms 1 16s840ms 16s840ms 16s840ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 04 20 1 16s840ms 16s840ms [ User: a3dsupervisor - Total duration: 16s840ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s840ms - 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-04 19:39:22 Duration: 16s840ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 16s1ms 1 16s1ms 16s1ms 16s1ms 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 #18
Day Hour Count Duration Avg duration Nov 04 20 1 16s1ms 16s1ms [ User: a3dsupervisor - Total duration: 16s1ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s1ms - 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-04 19:38:32 Duration: 16s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 15s900ms 1 15s900ms 15s900ms 15s900ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 04 09 1 15s900ms 15s900ms [ User: a3dsupervisor - Total duration: 15s900ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s900ms - Times executed: 1 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-04 08:00:19 Duration: 15s900ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 15s829ms 1 15s829ms 15s829ms 15s829ms 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 #20
Day Hour Count Duration Avg duration Nov 04 20 1 15s829ms 15s829ms [ User: a3dsupervisor - Total duration: 15s829ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s829ms - 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-04 19:39:56 Duration: 15s829ms 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 28 3m21s 5s71ms 13s469ms 7s195ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 04 08 13 1m35s 7s383ms 09 8 1m4s 8s78ms 20 1 5s782ms 5s782ms 21 6 35s76ms 5s846ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 28 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m15s - Times executed: 27 ]
[ Application: pg_restore - Total duration: 5s782ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 13s469ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 11s886ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 07:58:45 Duration: 9s422ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2 6m59s 3m14s 3m45s 3m29s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 04 14 1 3m14s 3m14s 18 1 3m45s 3m45s [ User: a3dsupervisor - Total duration: 6m59s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m59s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-04 17:07:01 Duration: 3m45s 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-04 13:08:05 Duration: 3m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2 55s305ms 27s412ms 27s893ms 27s652ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 04 14 1 27s412ms 27s412ms 18 1 27s893ms 27s893ms [ User: a3dsupervisor - Total duration: 55s305ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s305ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-04 17:11:21 Duration: 27s893ms 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-04 13:12:52 Duration: 27s412ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 2 21s17ms 9s179ms 11s837ms 10s508ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 04 14 1 11s837ms 11s837ms 18 1 9s179ms 9s179ms [ User: a3dsupervisor - Total duration: 21s17ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21s17ms - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 13:04:38 Duration: 11s837ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 17:03:10 Duration: 9s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 2 12s323ms 6s99ms 6s223ms 6s161ms select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 04 14 1 6s223ms 6s223ms 18 1 6s99ms 6s99ms [ User: a3dsupervisor - Total duration: 12s323ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12s323ms - Times executed: 2 ]
-
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('202001021309', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021309', '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-04 13:10:01 Duration: 6s223ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021708', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021708', '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-04 17:08:45 Duration: 6s99ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1 2m6s 2m6s 2m6s 2m6s vacuum analyse;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 04 20 1 2m6s 2m6s [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 1 ]
[ Application: psql - Total duration: 2m6s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-04 19:55:38 Duration: 2m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1 1m6s 1m6s 1m6s 1m6s 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 04 20 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m6s - 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-04 19:38:22 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 55s77ms 55s77ms 55s77ms 55s77ms -- revoke all on function a3d_gtp_reftk.touppernoaccent (p_string text) from public;drop trigger if exists t_bef_ins_er_gtp_obj on gtp_obj cascade;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 04 14 1 55s77ms 55s77ms [ User: a3dsupervisor - Total duration: 55s77ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s77ms - Times executed: 1 ]
-
-- REVOKE ALL ON FUNCTION a3d_gtp_reftk.touppernoaccent (p_string text) FROM PUBLIC;DROP TRIGGER IF EXISTS t_bef_ins_er_gtp_obj ON gtp_obj CASCADE;
Date: 2025-11-04 13:08:05 Duration: 55s77ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 1 38s668ms 38s668ms 38s668ms 38s668ms 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 04 20 1 38s668ms 38s668ms [ User: a3dsupervisor - Total duration: 38s668ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s668ms - 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-04 19:40:35 Duration: 38s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 34s877ms 34s877ms 34s877ms 34s877ms 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 04 20 1 34s877ms 34s877ms [ User: a3dsupervisor - Total duration: 34s877ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s877ms - 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-04 19:37:50 Duration: 34s877ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 32s693ms 32s693ms 32s693ms 32s693ms 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 #11
Day Hour Count Duration Avg duration Nov 04 20 1 32s693ms 32s693ms [ User: a3dsupervisor - Total duration: 32s693ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s693ms - 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-04 19:41:15 Duration: 32s693ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 32s515ms 32s515ms 32s515ms 32s515ms 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 04 20 1 32s515ms 32s515ms [ User: a3dsupervisor - Total duration: 32s515ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s515ms - 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-04 19:39:39 Duration: 32s515ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 26s486ms 26s486ms 26s486ms 26s486ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 04 20 1 26s486ms 26s486ms [ User: a3dsupervisor - Total duration: 26s486ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s486ms - 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-04 19:41:04 Duration: 26s486ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 25s485ms 25s485ms 25s485ms 25s485ms 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 #14
Day Hour Count Duration Avg duration Nov 04 20 1 25s485ms 25s485ms [ User: a3dsupervisor - Total duration: 25s485ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s485ms - 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-04 19:38:16 Duration: 25s485ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 23s481ms 23s481ms 23s481ms 23s481ms 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 04 20 1 23s481ms 23s481ms [ User: a3dsupervisor - Total duration: 23s481ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s481ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-04 19:38:45 Duration: 23s481ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 20s297ms 20s297ms 20s297ms 20s297ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 04 20 1 20s297ms 20s297ms [ User: a3dsupervisor - Total duration: 20s297ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s297ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-04 19:38:52 Duration: 20s297ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 18s510ms 18s510ms 18s510ms 18s510ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 04 20 1 18s510ms 18s510ms [ User: a3dsupervisor - Total duration: 18s510ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s510ms - 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-04 19:39:40 Duration: 18s510ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 16s840ms 16s840ms 16s840ms 16s840ms 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 04 20 1 16s840ms 16s840ms [ User: a3dsupervisor - Total duration: 16s840ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s840ms - 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-04 19:39:22 Duration: 16s840ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 16s1ms 16s1ms 16s1ms 16s1ms 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 #19
Day Hour Count Duration Avg duration Nov 04 20 1 16s1ms 16s1ms [ User: a3dsupervisor - Total duration: 16s1ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s1ms - 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-04 19:38:32 Duration: 16s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 15s900ms 15s900ms 15s900ms 15s900ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 04 09 1 15s900ms 15s900ms [ User: a3dsupervisor - Total duration: 15s900ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s900ms - Times executed: 1 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-04 08:00:19 Duration: 15s900ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m14s 3m45s 3m29s 2 6m59s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 04 14 1 3m14s 3m14s 18 1 3m45s 3m45s [ User: a3dsupervisor - Total duration: 6m59s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m59s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-04 17:07:01 Duration: 3m45s 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-04 13:08:05 Duration: 3m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m6s 2m6s 2m6s 1 2m6s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 04 20 1 2m6s 2m6s [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 1 ]
[ Application: psql - Total duration: 2m6s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-04 19:55:38 Duration: 2m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m6s 1m6s 1m6s 1 1m6s 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 04 20 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m6s - 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-04 19:38:22 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 55s77ms 55s77ms 55s77ms 1 55s77ms -- revoke all on function a3d_gtp_reftk.touppernoaccent (p_string text) from public;drop trigger if exists t_bef_ins_er_gtp_obj on gtp_obj cascade;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 04 14 1 55s77ms 55s77ms [ User: a3dsupervisor - Total duration: 55s77ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s77ms - Times executed: 1 ]
-
-- REVOKE ALL ON FUNCTION a3d_gtp_reftk.touppernoaccent (p_string text) FROM PUBLIC;DROP TRIGGER IF EXISTS t_bef_ins_er_gtp_obj ON gtp_obj CASCADE;
Date: 2025-11-04 13:08:05 Duration: 55s77ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 38s668ms 38s668ms 38s668ms 1 38s668ms 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 04 20 1 38s668ms 38s668ms [ User: a3dsupervisor - Total duration: 38s668ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s668ms - 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-04 19:40:35 Duration: 38s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 34s877ms 34s877ms 34s877ms 1 34s877ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 04 20 1 34s877ms 34s877ms [ User: a3dsupervisor - Total duration: 34s877ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s877ms - 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-04 19:37:50 Duration: 34s877ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 32s693ms 32s693ms 32s693ms 1 32s693ms 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 04 20 1 32s693ms 32s693ms [ User: a3dsupervisor - Total duration: 32s693ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s693ms - 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-04 19:41:15 Duration: 32s693ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 32s515ms 32s515ms 32s515ms 1 32s515ms 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 #8
Day Hour Count Duration Avg duration Nov 04 20 1 32s515ms 32s515ms [ User: a3dsupervisor - Total duration: 32s515ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s515ms - 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-04 19:39:39 Duration: 32s515ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 27s412ms 27s893ms 27s652ms 2 55s305ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 04 14 1 27s412ms 27s412ms 18 1 27s893ms 27s893ms [ User: a3dsupervisor - Total duration: 55s305ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s305ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-04 17:11:21 Duration: 27s893ms 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-04 13:12:52 Duration: 27s412ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 26s486ms 26s486ms 26s486ms 1 26s486ms 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 04 20 1 26s486ms 26s486ms [ User: a3dsupervisor - Total duration: 26s486ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s486ms - 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-04 19:41:04 Duration: 26s486ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 25s485ms 25s485ms 25s485ms 1 25s485ms 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 04 20 1 25s485ms 25s485ms [ User: a3dsupervisor - Total duration: 25s485ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s485ms - 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-04 19:38:16 Duration: 25s485ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 23s481ms 23s481ms 23s481ms 1 23s481ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 04 20 1 23s481ms 23s481ms [ User: a3dsupervisor - Total duration: 23s481ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s481ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-04 19:38:45 Duration: 23s481ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 20s297ms 20s297ms 20s297ms 1 20s297ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 04 20 1 20s297ms 20s297ms [ User: a3dsupervisor - Total duration: 20s297ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s297ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-04 19:38:52 Duration: 20s297ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 18s510ms 18s510ms 18s510ms 1 18s510ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 04 20 1 18s510ms 18s510ms [ User: a3dsupervisor - Total duration: 18s510ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s510ms - 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-04 19:39:40 Duration: 18s510ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 16s840ms 16s840ms 16s840ms 1 16s840ms 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 #15
Day Hour Count Duration Avg duration Nov 04 20 1 16s840ms 16s840ms [ User: a3dsupervisor - Total duration: 16s840ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s840ms - 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-04 19:39:22 Duration: 16s840ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 16s1ms 16s1ms 16s1ms 1 16s1ms 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 04 20 1 16s1ms 16s1ms [ User: a3dsupervisor - Total duration: 16s1ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s1ms - 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-04 19:38:32 Duration: 16s1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 15s900ms 15s900ms 15s900ms 1 15s900ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 04 09 1 15s900ms 15s900ms [ User: a3dsupervisor - Total duration: 15s900ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s900ms - Times executed: 1 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-11-04 08:00:19 Duration: 15s900ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 15s829ms 15s829ms 15s829ms 1 15s829ms 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 04 20 1 15s829ms 15s829ms [ User: a3dsupervisor - Total duration: 15s829ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s829ms - 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-04 19:39:56 Duration: 15s829ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 9s179ms 11s837ms 10s508ms 2 21s17ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 04 14 1 11s837ms 11s837ms 18 1 9s179ms 9s179ms [ User: a3dsupervisor - Total duration: 21s17ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21s17ms - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 13:04:38 Duration: 11s837ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 17:03:10 Duration: 9s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s71ms 13s469ms 7s195ms 28 3m21s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 04 08 13 1m35s 7s383ms 09 8 1m4s 8s78ms 20 1 5s782ms 5s782ms 21 6 35s76ms 5s846ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 28 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m15s - Times executed: 27 ]
[ Application: pg_restore - Total duration: 5s782ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 13s469ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 11s886ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 07:58:45 Duration: 9s422ms 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
- 6,243 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1476 ERROR entries
- 28 WARNING entries
Most Frequent Errors/Events
Key values
- 1,319 Max number of times the same event was reported
- 1,504 Total events found
Rank Times reported Error 1 1,319 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 04 21 90 22 486 23 98 00 645 2 85 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 04 11 7 12 3 13 5 14 5 15 11 16 29 17 22 19 3 3 16 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 04 14 8 18 8 4 12 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 04 14 6 18 6 5 4 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 04 14 2 18 2 6 3 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 04 18 3 7 3 ERROR: function length(...) does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 04 14 1 17 2 8 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 #8
Day Hour Count Nov 04 14 1 18 1 9 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 04 14 1 18 1 10 2 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 04 14 1 18 1 11 2 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 04 08 2 12 2 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 04 14 1 18 1 13 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms -- REVOKE ALL ON FUNCTION a3d_gtp_reftk.touppernoaccent (...) FROM PUBLIC; DROP TRIGGER IF EXISTS t_bef_ins_er_gtp_obj ON gtp_obj CASCADE
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 04 14 2 14 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 #14
Day Hour Count Nov 04 14 1 20 1 15 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 #15
Day Hour Count Nov 04 14 1 18 1 16 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 #16
Day Hour Count Nov 04 14 1 18 1 17 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 04 14 1 20 1 18 2 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 04 14 1 18 1 19 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #19
Day Hour Count Nov 04 14 1 20 1 20 2 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #20
Day Hour Count Nov 04 14 1 18 1 21 2 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #21
Day Hour Count Nov 04 14 1 18 1 22 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 #22
Day Hour Count Nov 04 14 1 20 1 23 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 04 14 1 18 1 24 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 04 14 1 20 1 25 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 #25
Day Hour Count Nov 04 14 1 20 1 26 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #26
Day Hour Count Nov 04 14 1 18 1 27 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 #27
Day Hour Count Nov 04 14 1 18 1 28 2 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #28
Day Hour Count Nov 04 14 1 18 1 29 2 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #29
Day Hour Count Nov 04 14 1 18 1 30 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 #30
Day Hour Count Nov 04 14 1 20 1 31 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #31
Day Hour Count Nov 04 14 1 18 1 32 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 #32
Day Hour Count Nov 04 14 1 20 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 04 14 1 18 1 34 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 #34
Day Hour Count Nov 04 14 1 18 1 35 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 #35
Day Hour Count Nov 04 14 1 20 1 36 1 ERROR: column "..." is of type oid but expression is of type bytea
Times Reported Most Frequent Error / Event #36
Day Hour Count Nov 04 14 1 37 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #37
Day Hour Count Nov 04 20 1 38 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (...)
Times Reported Most Frequent Error / Event #38
Day Hour Count Nov 04 20 1 39 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate gtp_cache_host set last_seen = current_timestamp where host = and port =
Times Reported Most Frequent Error / Event #39
Day Hour Count Nov 04 18 1 40 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #40
Day Hour Count Nov 04 20 1 41 1 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 #41
Day Hour Count Nov 04 20 1