pgBadger-
Global information
- Generated on Thu Sep 25 09:06:19 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=24/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=24/h=23/m=00/PT1H.log
- Parsed 56,624 log entries in 52s
- Log start from 2025-09-24 10:33:15 to 2025-09-24 19:17:32
-
Overview
Global Stats
- 74 Number of unique normalized queries
- 108 Number of queries
- 49m20s Total query duration
- 2025-09-24 10:30:54 First query
- 2025-09-24 19:01:39 Last query
- 2 queries/s at 2025-09-24 10:35:14 Query peak
- 49m20s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 49m20s Execute total duration
- 27,228 Number of events
- 48 Number of unique normalized events
- 26,976 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
- 453 Number temporary file
- 1022.31 MiB Max size of temporary file
- 19.27 MiB Average size of temporary file
- 495 Total number of sessions
- 28 sessions at 2025-09-24 10:51:00 Session peak
- 1d22h55m45s Total duration of sessions
- 5m41s Average duration of sessions
- 0 Average queries per session
- 5s980ms Average queries duration per session
- 5m35s Average idle time per session
- 495 Total number of connections
- 10 connections/s at 2025-09-24 10:50:46 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-24 10:35:14 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-09-24 17:30:06 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-24 10:35:14 Date
Queries duration
Key values
- 49m20s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 10 41 0ms 2m5s 19s175ms 1m56s 2m5s 2m35s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 16 0ms 4m2s 41s601ms 19s732ms 44s472ms 4m2s 14 3 0ms 57s520ms 26s886ms 0ms 9s691ms 57s520ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 13 0ms 3m47s 48s942ms 18s137ms 1m19s 3m47s 18 34 0ms 1m17s 17s451ms 1m45s 1m59s 2m31s 19 1 0ms 3m18s 3m18s 3m18s 3m18s 3m18s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 9 0 12s361ms 0ms 10s23ms 19s732ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 6 0 10s956ms 0ms 6s274ms 22s330ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 10 0 0 0 6 31s861ms 0ms 11s581ms 1m17s 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 2 0 26s563ms 0ms 0ms 0ms 14 0 0 2 0 33s605ms 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 1m19s 0ms 0ms 0ms 18 0 0 0 6 32s44ms 0ms 0ms 49s602ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 24 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 16 16.00 0.00% 14 0 3 3.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 13 13.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 24 10 45 0.01/s 11 25 0.01/s 12 43 0.01/s 13 90 0.03/s 14 40 0.01/s 15 87 0.02/s 16 113 0.03/s 17 27 0.01/s 18 15 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Sep 24 10 42 1m17s 58s601ms 11 25 1m11s 1m11s 12 41 1m14s 1m14s 13 86 1m7s 59s459ms 14 42 3m24s 3m22s 15 88 1m11s 1m11s 16 108 1m50s 1m50s 17 33 55m24s 55m5s 18 19 15m17s 14m46s 19 3 6m23s 5m17s 20 2 74ms 74ms 21 2 71ms 71ms 22 2 71ms 71ms 23 2 71ms 71ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-09-24 10:50:46 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 495 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 495 connections Total
-
Sessions
Simultaneous sessions
Key values
- 28 sessions Session Peak
- 2025-09-24 10:51:00 Date
Histogram of session times
Key values
- 283 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 495 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 495 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 495 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 495 sessions Total
Application Count Total Duration Average Duration DBeaver 24.2.1 - Main 'autotest_feat_batch' 2 3h36m6s 1h48m3s DBeaver 24.2.1 - Metadata 'autotest_feat_batch' 1 3h36m5s 3h36m5s DBeaver 24.2.1 - SQLEditor 'Script-420.sql' 1 3h35m57s 3h35m57s PostgreSQL JDBC Driver 446 1d10h35m33s 4m39s [unknown] 27 2s409ms 89ms pg_restore 8 1h10m43s 8m50s psql 10 21m17s 2m7s -
Temporary Files
Size of temporary files
Key values
- 387.04 MiB Temp Files size Peak
- 2025-09-24 18:43:55 Date
Number of temporary files
Key values
- 9 per second Temp Files Peak
- 2025-09-24 18:47:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 24 10 175 4.07 GiB 23.84 MiB 11 0 0 0 12 0 0 0 13 49 211.55 MiB 4.32 MiB 14 0 0 0 15 1 4.19 MiB 4.19 MiB 16 5 20.94 MiB 4.19 MiB 17 48 208.57 MiB 4.35 MiB 18 175 4.02 GiB 23.50 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 15 106.87 MiB 2.48 MiB 28.86 MiB 7.12 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('202001021355', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021355', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-09-24 13:55:55 Duration: 9s916ms 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('202001021316', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021316', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-09-24 13:16:24 Duration: 8s174ms 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('202001021729', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021729', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-09-24 17:30:06 Duration: 6s274ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 7 17.51 MiB 2.24 MiB 2.93 MiB 2.50 MiB select goc.obj_num_id from gtp_obj_composition goc where position(? in goc.obj_compo_value) <> ?;-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;
Date: 2025-09-24 13:55:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 6 135.77 MiB 4.08 MiB 56.31 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-09-24 18:47:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 6 757.40 MiB 28.41 MiB 326.12 MiB 126.23 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-24 18:44:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 6 50.35 MiB 3.64 MiB 25.89 MiB 8.39 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-09-24 18:46:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 6 616.53 MiB 20.21 MiB 363.03 MiB 102.76 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-24 18:45:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 6 70.35 MiB 2.15 MiB 34.01 MiB 11.73 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2025-09-24 18:43:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 6 356.20 MiB 50.92 MiB 72.57 MiB 59.37 MiB add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);-
ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-24 18:45:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 6 157.63 MiB 15.16 MiB 48.46 MiB 26.27 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-24 18:46:57 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 6 1.17 GiB 35.30 MiB 697.77 MiB 199.44 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 18:42:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 6 611.48 MiB 11.06 MiB 454.34 MiB 101.91 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-09-24 18:45:30 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 6 285.70 MiB 28.02 MiB 132.13 MiB 47.62 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-24 18:46:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 6 110.45 MiB 3.51 MiB 46.84 MiB 18.41 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-09-24 18:44:03 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 6 31.19 MiB 4.38 MiB 6.27 MiB 5.20 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-09-24 18:43:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 6 214.98 MiB 8.31 MiB 84.94 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-09-24 18:46:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 6 1.46 GiB 117.16 MiB 479.72 MiB 248.42 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 18:43:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 6 31.62 MiB 2.20 MiB 9.53 MiB 5.27 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-09-24 18:46:03 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 4 728.64 MiB 2.12 MiB 670.44 MiB 182.16 MiB add constraint pk_l_notification_user primary key (nous_user_num_id, nous_noti_id);-
ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);
Date: 2025-09-24 18:47:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 3 43.86 MiB 2.19 MiB 31.39 MiB 14.62 MiB add constraint pk_pe_consumption_hourly primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_hourly PRIMARY KEY (consumption_num_id);
Date: 2025-09-24 18:47:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2 11.35 MiB 2.56 MiB 8.79 MiB 5.68 MiB select count(*) from gtp_obj_rel_vt;-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:27:08 Duration: 22s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 13:52:31 Duration: 21s312ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:50:11 Duration: 18s137ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
21 2 1.00 GiB 4.12 MiB 1022.31 MiB 513.22 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-09-24 18:41:30 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 1022.31 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-09-24 18:41:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 697.77 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-24 10:31:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 670.44 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-09-24 10:32:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 479.72 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 10:33:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 475.34 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 18:43:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 454.34 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-24 10:35:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 363.03 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-24 18:45:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 330.97 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-24 18:42:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 326.12 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-24 10:34:14 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 311.23 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-24 18:44:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 162.46 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-24 10:35:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 148.36 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 10:33:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 138.66 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 18:43:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 132.13 MiB ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-09-24 18:46:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 131.24 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 18:43:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 117.16 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 10:33:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 85.88 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-24 18:45:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 84.94 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-09-24 18:46:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 83.44 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-09-24 10:37:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 72.57 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-24 18:45:59 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 24 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 7 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
- 15 Total read queries
- 79 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 108 Requests
- 49m20s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 108 Requests
User Request type Count Duration a3dsupervisor Total 108 49m20s copy from 12 6m23s ddl 60 14m19s delete 5 3m19s others 14 22m9s select 15 2m56s tcl 2 11s832ms Duration by user
Key values
- 49m20s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 108 49m20s copy from 12 6m23s ddl 60 14m19s delete 5 3m19s others 14 22m9s select 15 2m56s tcl 2 11s832ms Queries by host
Key values
- 10.3.0.4 Main host
- 108 Requests
- 49m20s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 74 Requests
- 23m2s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-24 15:44:45 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 71 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 4m2s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-24 13:14:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 3m47s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-24 17:49:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 3m41s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-24 13:51:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 3m37s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-09-24 17:26:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 3m18s VACUUM ANALYSE;[ Date: 2025-09-24 19:01:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 2m5s VACUUM ANALYSE;[ Date: 2025-09-24 10:50:00 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 1m19s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-24 17:57:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 1m17s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-09-24 18:41:46 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 1m17s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-09-24 10:31:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 57s520ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-24 14:00:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 44s472ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-09-24 13:19:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 37s687ms ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 18:43:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 37s259ms ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-24 10:33:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 35s972ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;[ Date: 2025-09-24 18:41:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 35s970ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;[ Date: 2025-09-24 10:30:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 30s33ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-09-24 18:42:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 29s371ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;[ Date: 2025-09-24 18:44:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 28s330ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);[ Date: 2025-09-24 10:31:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 28s231ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;[ Date: 2025-09-24 10:34:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 26s582ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-09-24 10:32:02 - 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 15m8s 4 3m37s 4m2s 3m47s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 15 2 7m43s 3m51s 19 2 7m24s 3m42s [ User: a3dsupervisor - Total duration: 15m8s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m8s - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 13:14:16 Duration: 4m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 17:49:42 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 13:51:57 Duration: 3m41s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5m23s 2 2m5s 3m18s 2m41s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 12 1 2m5s 2m5s 21 1 3m18s 3m18s [ User: a3dsupervisor - Total duration: 5m23s - Times executed: 2 ]
[ Application: psql - Total duration: 5m23s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 19:01:39 Duration: 3m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-24 10:50:00 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 3m1s 3 44s472ms 1m19s 1m delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 15 1 44s472ms 44s472ms 16 1 57s520ms 57s520ms 19 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 3m1s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m1s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 17:57:36 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 14:00:16 Duration: 57s520ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 13:19:36 Duration: 44s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 2m34s 2 1m17s 1m17s 1m17s 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 Sep 24 12 1 1m17s 1m17s 20 1 1m17s 1m17s [ User: a3dsupervisor - Total duration: 2m34s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m34s - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-24 18:41:46 Duration: 1m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-24 10:31:35 Duration: 1m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m14s 2 37s259ms 37s687ms 37s473ms 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 Sep 24 12 1 37s259ms 37s259ms 20 1 37s687ms 37s687ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m14s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 18:43:57 Duration: 37s687ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:33:53 Duration: 37s259ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m11s 2 35s970ms 35s972ms 35s971ms 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 Sep 24 12 1 35s970ms 35s970ms 20 1 35s972ms 35s972ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m11s - Times executed: 2 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-09-24 18:41:04 Duration: 35s972ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-09-24 10:30:54 Duration: 35s970ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m1s 3 18s137ms 22s330ms 20s593ms select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 15 1 21s312ms 21s312ms 19 2 40s468ms 20s234ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m1s - Times executed: 3 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:27:08 Duration: 22s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 13:52:31 Duration: 21s312ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:50:11 Duration: 18s137ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1m 4 13s449ms 18s983ms 15s220ms call pack_gtp_trigger.p_trigger_del_line_att_tab (,);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 15 1 18s983ms 18s983ms 16 1 13s449ms 13s449ms 19 2 28s450ms 14s225ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m - Times executed: 4 ]
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 13:18:28 Duration: 18s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 17:55:43 Duration: 14s846ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 17:32:46 Duration: 13s603ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 57s602ms 2 28s231ms 29s371ms 28s801ms 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 Sep 24 12 1 28s231ms 28s231ms 20 1 29s371ms 29s371ms [ User: a3dsupervisor - Total duration: 57s602ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 57s602ms - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 18:44:52 Duration: 29s371ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 10:34:55 Duration: 28s231ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 56s616ms 2 26s582ms 30s33ms 28s308ms 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 Sep 24 12 1 26s582ms 26s582ms 20 1 30s33ms 30s33ms [ User: a3dsupervisor - Total duration: 56s616ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 56s616ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-24 18:42:16 Duration: 30s33ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-24 10:32:02 Duration: 26s582ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 53s504ms 2 25s173ms 28s330ms 26s752ms 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 Sep 24 12 1 28s330ms 28s330ms 20 1 25s173ms 25s173ms [ User: a3dsupervisor - Total duration: 53s504ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 53s504ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-09-24 10:31:23 Duration: 28s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-09-24 18:41:30 Duration: 25s173ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 50s344ms 2 24s695ms 25s648ms 25s172ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 12 1 24s695ms 24s695ms 20 1 25s648ms 25s648ms [ User: a3dsupervisor - Total duration: 50s344ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 50s344ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-24 18:42:26 Duration: 25s648ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-24 10:32:25 Duration: 24s695ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 43s798ms 2 17s794ms 26s4ms 21s899ms 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 Sep 24 12 1 26s4ms 26s4ms 20 1 17s794ms 17s794ms [ User: a3dsupervisor - Total duration: 43s798ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 43s798ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-24 10:32:01 Duration: 26s4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-24 18:42:01 Duration: 17s794ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 43s384ms 2 20s950ms 22s433ms 21s692ms 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 #14
Day Hour Count Duration Avg duration Sep 24 12 1 20s950ms 20s950ms 20 1 22s433ms 22s433ms [ User: a3dsupervisor - Total duration: 43s384ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 43s384ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 18:45:15 Duration: 22s433ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 10:35:35 Duration: 20s950ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 40s858ms 2 20s231ms 20s626ms 20s429ms 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 #15
Day Hour Count Duration Avg duration Sep 24 12 1 20s626ms 20s626ms 20 1 20s231ms 20s231ms [ User: a3dsupervisor - Total duration: 40s858ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s858ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 10:34:36 Duration: 20s626ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 18:44:34 Duration: 20s231ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 40s666ms 2 18s682ms 21s983ms 20s333ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 12 1 21s983ms 21s983ms 20 1 18s682ms 18s682ms [ User: a3dsupervisor - Total duration: 40s666ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s666ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 10:32:47 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 18:42:47 Duration: 18s682ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 37s245ms 2 17s812ms 19s432ms 18s622ms 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 #17
Day Hour Count Duration Avg duration Sep 24 12 1 17s812ms 17s812ms 20 1 19s432ms 19s432ms [ User: a3dsupervisor - Total duration: 37s245ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 37s245ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 18:43:02 Duration: 19s432ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:32:59 Duration: 17s812ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 36s443ms 4 9s42ms 9s253ms 9s110ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 15 2 18s305ms 9s152ms 19 2 18s137ms 9s68ms [ User: a3dsupervisor - Total duration: 36s443ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s443ms - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 13:48:11 Duration: 9s253ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 17:45:49 Duration: 9s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 13:10:07 Duration: 9s52ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 35s538ms 2 16s909ms 18s629ms 17s769ms 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 #19
Day Hour Count Duration Avg duration Sep 24 12 1 16s909ms 16s909ms 20 1 18s629ms 18s629ms [ User: a3dsupervisor - Total duration: 35s538ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s538ms - Times executed: 2 ]
-
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-09-24 18:43:05 Duration: 18s629ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-09-24 10:33:04 Duration: 16s909ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 33s294ms 2 12s91ms 21s202ms 16s647ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 12 1 21s202ms 21s202ms 20 1 12s91ms 12s91ms [ User: a3dsupervisor - Total duration: 33s294ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 33s294ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-24 10:32:23 Duration: 21s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-24 18:42:28 Duration: 12s91ms 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 4 15m8s 3m37s 4m2s 3m47s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 15 2 7m43s 3m51s 19 2 7m24s 3m42s [ User: a3dsupervisor - Total duration: 15m8s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m8s - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 13:14:16 Duration: 4m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 17:49:42 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 13:51:57 Duration: 3m41s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4 1m 13s449ms 18s983ms 15s220ms call pack_gtp_trigger.p_trigger_del_line_att_tab (,);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 15 1 18s983ms 18s983ms 16 1 13s449ms 13s449ms 19 2 28s450ms 14s225ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m - Times executed: 4 ]
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 13:18:28 Duration: 18s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 17:55:43 Duration: 14s846ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 17:32:46 Duration: 13s603ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 4 36s443ms 9s42ms 9s253ms 9s110ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 15 2 18s305ms 9s152ms 19 2 18s137ms 9s68ms [ User: a3dsupervisor - Total duration: 36s443ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s443ms - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 13:48:11 Duration: 9s253ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 17:45:49 Duration: 9s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 13:10:07 Duration: 9s52ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 4 32s387ms 6s467ms 9s815ms 8s96ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 15 2 19s206ms 9s603ms 19 2 13s181ms 6s590ms [ User: a3dsupervisor - Total duration: 32s387ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 32s387ms - Times executed: 4 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-24 13:55:08 Duration: 9s815ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-24 13:15:54 Duration: 9s390ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-09-24 17:52:28 Duration: 6s713ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 4 30s180ms 5s815ms 9s916ms 7s545ms 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 Sep 24 15 2 18s90ms 9s45ms 19 2 12s90ms 6s45ms [ User: a3dsupervisor - Total duration: 30s180ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 30s180ms - Times executed: 4 ]
-
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('202001021355', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021355', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-09-24 13:55:55 Duration: 9s916ms 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('202001021316', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021316', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-09-24 13:16:24 Duration: 8s174ms 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('202001021729', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021729', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-09-24 17:30:06 Duration: 6s274ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 3 3m1s 44s472ms 1m19s 1m delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 15 1 44s472ms 44s472ms 16 1 57s520ms 57s520ms 19 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 3m1s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m1s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 17:57:36 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 14:00:16 Duration: 57s520ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 13:19:36 Duration: 44s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 3 1m1s 18s137ms 22s330ms 20s593ms select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 15 1 21s312ms 21s312ms 19 2 40s468ms 20s234ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m1s - Times executed: 3 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:27:08 Duration: 22s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 13:52:31 Duration: 21s312ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:50:11 Duration: 18s137ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 2 5m23s 2m5s 3m18s 2m41s vacuum analyse;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 12 1 2m5s 2m5s 21 1 3m18s 3m18s [ User: a3dsupervisor - Total duration: 5m23s - Times executed: 2 ]
[ Application: psql - Total duration: 5m23s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 19:01:39 Duration: 3m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-24 10:50:00 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 2 2m34s 1m17s 1m17s 1m17s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 12 1 1m17s 1m17s 20 1 1m17s 1m17s [ User: a3dsupervisor - Total duration: 2m34s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m34s - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-24 18:41:46 Duration: 1m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-24 10:31:35 Duration: 1m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2 1m14s 37s259ms 37s687ms 37s473ms 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 #10
Day Hour Count Duration Avg duration Sep 24 12 1 37s259ms 37s259ms 20 1 37s687ms 37s687ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m14s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 18:43:57 Duration: 37s687ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:33:53 Duration: 37s259ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2 1m11s 35s970ms 35s972ms 35s971ms 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 #11
Day Hour Count Duration Avg duration Sep 24 12 1 35s970ms 35s970ms 20 1 35s972ms 35s972ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m11s - Times executed: 2 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-09-24 18:41:04 Duration: 35s972ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-09-24 10:30:54 Duration: 35s970ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 2 57s602ms 28s231ms 29s371ms 28s801ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 12 1 28s231ms 28s231ms 20 1 29s371ms 29s371ms [ User: a3dsupervisor - Total duration: 57s602ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 57s602ms - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 18:44:52 Duration: 29s371ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 10:34:55 Duration: 28s231ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2 56s616ms 26s582ms 30s33ms 28s308ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 12 1 26s582ms 26s582ms 20 1 30s33ms 30s33ms [ User: a3dsupervisor - Total duration: 56s616ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 56s616ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-24 18:42:16 Duration: 30s33ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-24 10:32:02 Duration: 26s582ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 53s504ms 25s173ms 28s330ms 26s752ms 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 Sep 24 12 1 28s330ms 28s330ms 20 1 25s173ms 25s173ms [ User: a3dsupervisor - Total duration: 53s504ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 53s504ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-09-24 10:31:23 Duration: 28s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-09-24 18:41:30 Duration: 25s173ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2 50s344ms 24s695ms 25s648ms 25s172ms 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 Sep 24 12 1 24s695ms 24s695ms 20 1 25s648ms 25s648ms [ User: a3dsupervisor - Total duration: 50s344ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 50s344ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-24 18:42:26 Duration: 25s648ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-24 10:32:25 Duration: 24s695ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 43s798ms 17s794ms 26s4ms 21s899ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 12 1 26s4ms 26s4ms 20 1 17s794ms 17s794ms [ User: a3dsupervisor - Total duration: 43s798ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 43s798ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-24 10:32:01 Duration: 26s4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-24 18:42:01 Duration: 17s794ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 43s384ms 20s950ms 22s433ms 21s692ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 12 1 20s950ms 20s950ms 20 1 22s433ms 22s433ms [ User: a3dsupervisor - Total duration: 43s384ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 43s384ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 18:45:15 Duration: 22s433ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 10:35:35 Duration: 20s950ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 40s858ms 20s231ms 20s626ms 20s429ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 12 1 20s626ms 20s626ms 20 1 20s231ms 20s231ms [ User: a3dsupervisor - Total duration: 40s858ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s858ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 10:34:36 Duration: 20s626ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 18:44:34 Duration: 20s231ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2 40s666ms 18s682ms 21s983ms 20s333ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 12 1 21s983ms 21s983ms 20 1 18s682ms 18s682ms [ User: a3dsupervisor - Total duration: 40s666ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s666ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 10:32:47 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 18:42:47 Duration: 18s682ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2 37s245ms 17s812ms 19s432ms 18s622ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 12 1 17s812ms 17s812ms 20 1 19s432ms 19s432ms [ User: a3dsupervisor - Total duration: 37s245ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 37s245ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 18:43:02 Duration: 19s432ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:32:59 Duration: 17s812ms 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 3m37s 4m2s 3m47s 4 15m8s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 15 2 7m43s 3m51s 19 2 7m24s 3m42s [ User: a3dsupervisor - Total duration: 15m8s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m8s - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 13:14:16 Duration: 4m2s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 17:49:42 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-09-24 13:51:57 Duration: 3m41s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m5s 3m18s 2m41s 2 5m23s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 12 1 2m5s 2m5s 21 1 3m18s 3m18s [ User: a3dsupervisor - Total duration: 5m23s - Times executed: 2 ]
[ Application: psql - Total duration: 5m23s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 19:01:39 Duration: 3m18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-24 10:50:00 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m17s 1m17s 1m17s 2 2m34s 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 Sep 24 12 1 1m17s 1m17s 20 1 1m17s 1m17s [ User: a3dsupervisor - Total duration: 2m34s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m34s - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-24 18:41:46 Duration: 1m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-24 10:31:35 Duration: 1m17s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 44s472ms 1m19s 1m 3 3m1s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 15 1 44s472ms 44s472ms 16 1 57s520ms 57s520ms 19 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 3m1s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m1s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 17:57:36 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 14:00:16 Duration: 57s520ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-09-24 13:19:36 Duration: 44s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 37s259ms 37s687ms 37s473ms 2 1m14s 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 Sep 24 12 1 37s259ms 37s259ms 20 1 37s687ms 37s687ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m14s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 18:43:57 Duration: 37s687ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:33:53 Duration: 37s259ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 35s970ms 35s972ms 35s971ms 2 1m11s 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 Sep 24 12 1 35s970ms 35s970ms 20 1 35s972ms 35s972ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m11s - Times executed: 2 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-09-24 18:41:04 Duration: 35s972ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-09-24 10:30:54 Duration: 35s970ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 28s231ms 29s371ms 28s801ms 2 57s602ms 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 Sep 24 12 1 28s231ms 28s231ms 20 1 29s371ms 29s371ms [ User: a3dsupervisor - Total duration: 57s602ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 57s602ms - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 18:44:52 Duration: 29s371ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 10:34:55 Duration: 28s231ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 26s582ms 30s33ms 28s308ms 2 56s616ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 12 1 26s582ms 26s582ms 20 1 30s33ms 30s33ms [ User: a3dsupervisor - Total duration: 56s616ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 56s616ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-24 18:42:16 Duration: 30s33ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-24 10:32:02 Duration: 26s582ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 25s173ms 28s330ms 26s752ms 2 53s504ms 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 #9
Day Hour Count Duration Avg duration Sep 24 12 1 28s330ms 28s330ms 20 1 25s173ms 25s173ms [ User: a3dsupervisor - Total duration: 53s504ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 53s504ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-09-24 10:31:23 Duration: 28s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-09-24 18:41:30 Duration: 25s173ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 24s695ms 25s648ms 25s172ms 2 50s344ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 12 1 24s695ms 24s695ms 20 1 25s648ms 25s648ms [ User: a3dsupervisor - Total duration: 50s344ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 50s344ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-24 18:42:26 Duration: 25s648ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-24 10:32:25 Duration: 24s695ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 17s794ms 26s4ms 21s899ms 2 43s798ms 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 #11
Day Hour Count Duration Avg duration Sep 24 12 1 26s4ms 26s4ms 20 1 17s794ms 17s794ms [ User: a3dsupervisor - Total duration: 43s798ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 43s798ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-24 10:32:01 Duration: 26s4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-24 18:42:01 Duration: 17s794ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 20s950ms 22s433ms 21s692ms 2 43s384ms 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 #12
Day Hour Count Duration Avg duration Sep 24 12 1 20s950ms 20s950ms 20 1 22s433ms 22s433ms [ User: a3dsupervisor - Total duration: 43s384ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 43s384ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 18:45:15 Duration: 22s433ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 10:35:35 Duration: 20s950ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 18s137ms 22s330ms 20s593ms 3 1m1s select count(*) from gtp_obj_rel_vt;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 15 1 21s312ms 21s312ms 19 2 40s468ms 20s234ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m1s - Times executed: 3 ]
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:27:08 Duration: 22s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 13:52:31 Duration: 21s312ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select count(*) from GTP_OBJ_REL_VT;
Date: 2025-09-24 17:50:11 Duration: 18s137ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 20s231ms 20s626ms 20s429ms 2 40s858ms 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 #14
Day Hour Count Duration Avg duration Sep 24 12 1 20s626ms 20s626ms 20 1 20s231ms 20s231ms [ User: a3dsupervisor - Total duration: 40s858ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s858ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 10:34:36 Duration: 20s626ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 18:44:34 Duration: 20s231ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 18s682ms 21s983ms 20s333ms 2 40s666ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 12 1 21s983ms 21s983ms 20 1 18s682ms 18s682ms [ User: a3dsupervisor - Total duration: 40s666ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s666ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 10:32:47 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 18:42:47 Duration: 18s682ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 17s812ms 19s432ms 18s622ms 2 37s245ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 12 1 17s812ms 17s812ms 20 1 19s432ms 19s432ms [ User: a3dsupervisor - Total duration: 37s245ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 37s245ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 18:43:02 Duration: 19s432ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-24 10:32:59 Duration: 17s812ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 16s909ms 18s629ms 17s769ms 2 35s538ms 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 Sep 24 12 1 16s909ms 16s909ms 20 1 18s629ms 18s629ms [ User: a3dsupervisor - Total duration: 35s538ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s538ms - Times executed: 2 ]
-
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-09-24 18:43:05 Duration: 18s629ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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-09-24 10:33:04 Duration: 16s909ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 12s91ms 21s202ms 16s647ms 2 33s294ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 12 1 21s202ms 21s202ms 20 1 12s91ms 12s91ms [ User: a3dsupervisor - Total duration: 33s294ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 33s294ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-24 10:32:23 Duration: 21s202ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-24 18:42:28 Duration: 12s91ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 13s449ms 18s983ms 15s220ms 4 1m call pack_gtp_trigger.p_trigger_del_line_att_tab (,);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 15 1 18s983ms 18s983ms 16 1 13s449ms 13s449ms 19 2 28s450ms 14s225ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m - Times executed: 4 ]
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 13:18:28 Duration: 18s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 17:55:43 Duration: 14s846ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call PACK_GTP_TRIGGER.P_TRIGGER_DEL_LINE_ATT_TAB (,);
Date: 2025-09-24 17:32:46 Duration: 13s603ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 9s42ms 9s253ms 9s110ms 4 36s443ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 15 2 18s305ms 9s152ms 19 2 18s137ms 9s68ms [ User: a3dsupervisor - Total duration: 36s443ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 36s443ms - Times executed: 4 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 13:48:11 Duration: 9s253ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 17:45:49 Duration: 9s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-09-24 13:10:07 Duration: 9s52ms 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
- 29,288 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 27170 ERROR entries
- 56 WARNING entries
Most Frequent Errors/Events
Key values
- 26,976 Max number of times the same event was reported
- 27,228 Total events found
Rank Times reported Error 1 26,976 ERROR: operator does not exist: smallint = character varying
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 24 12 420 13 3,600 14 3,600 15 3,600 16 3,600 17 3,647 18 3,802 19 3,283 20 1,424 2 41 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 24 15 2 16 2 18 35 19 2 3 38 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 24 16 1 17 4 18 22 19 8 20 2 21 1 4 32 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 24 15 16 19 16 5 24 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 24 15 12 19 12 6 9 ERROR: null value in column "..." of relation "..." violates not-null constraintINSERT INTO MAPPING(...) VALUES(...)
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 24 15 3 16 3 19 3 7 8 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 24 15 4 19 4 8 4 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 24 15 2 19 2 9 4 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 24 15 2 19 2 10 4 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 24 15 2 19 2 11 4 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 24 15 2 19 2 12 4 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 24 15 2 19 2 13 4 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 24 15 2 19 2 14 4 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 #14
Day Hour Count Sep 24 15 2 19 2 15 4 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 Sep 24 15 2 19 2 16 4 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 24 15 2 19 2 17 4 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 24 15 2 19 2 18 4 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 #18
Day Hour Count Sep 24 15 2 19 2 19 4 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #19
Day Hour Count Sep 24 15 2 19 2 20 4 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #20
Day Hour Count Sep 24 15 2 19 2 21 4 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #21
Day Hour Count Sep 24 15 2 19 2 22 4 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 #22
Day Hour Count Sep 24 15 2 19 2 23 4 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #23
Day Hour Count Sep 24 15 2 19 2 24 4 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #24
Day Hour Count Sep 24 15 2 19 2 25 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #25
Day Hour Count Sep 24 17 3 26 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #26
Day Hour Count Sep 24 15 1 17 1 27 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #27
Day Hour Count Sep 24 12 1 20 1 28 2 FATAL: connection to client lostdelete from GTP_WORKSPACE where WORKSPACE_NUM_ID=
Times Reported Most Frequent Error / Event #28
Day Hour Count Sep 24 15 1 16 1 29 2 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #29
Day Hour Count Sep 24 20 2 30 2 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 #30
Day Hour Count Sep 24 19 2 31 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #31
Day Hour Count Sep 24 12 1 17 1 32 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 #32
Day Hour Count Sep 24 12 1 33 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 #33
Day Hour Count Sep 24 12 1 34 1 ERROR: Erreur: duplicate key value violates unique constraint "..."DO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := 'ACTIVE3D_RQM-17843_init_batch_process'; BEGIN raise debug 'START %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); DECLARE l_grpId INTEGER; l_scnId INTEGER; l_processId INTEGER; l_processId_2 INTEGER; l_mappingId INTEGER; BEGIN select nextval(...) into l_grpId; select nextval(...) into l_scnId; select nextval(...) into l_processId; select nextval(...) into l_processId_2; select nextval(...) into l_mappingId; INSERT INTO "..." (...) VALUES(...); INSERT INTO batch_group (...) VALUES(...); INSERT INTO batch_scenario (...) VALUES(...); INSERT INTO batch_process (...) VALUES(...); EXCEPTION WHEN OTHERS THEN RAISE EXCEPTION 'Erreur: %', SQLERRM; ROLLBACK; END; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET validated = true WHERE type = 'postInstallation' AND name = L_SCRIPT_NAME AND RELEASE = '7.22.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise notice 'END %', L_SCRIPT_NAME; EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #34
Day Hour Count Sep 24 17 1 35 1 LOG: could not send data to client: Connection reset by peerdelete from GTP_WORKSPACE where WORKSPACE_NUM_ID=
Times Reported Most Frequent Error / Event #35
Day Hour Count Sep 24 16 1 36 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #36
Day Hour Count Sep 24 12 1 37 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 #37
Day Hour Count Sep 24 12 1 38 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 #38
Day Hour Count Sep 24 12 1 39 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #39
Day Hour Count Sep 24 12 1 40 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #40
Day Hour Count Sep 24 12 1 41 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 #41
Day Hour Count Sep 24 12 1 42 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msCREATE STATISTICS public.stat_dep_obj_compo_att (...) ON att_template_category_num_id, att_template_num_id FROM public.gtp_obj_composition
Times Reported Most Frequent Error / Event #42
Day Hour Count Sep 24 20 1 43 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #43
Day Hour Count Sep 24 12 1 44 1 LOG: could not send data to client: Broken pipedelete from GTP_WORKSPACE where WORKSPACE_NUM_ID=
Times Reported Most Frequent Error / Event #44
Day Hour Count Sep 24 15 1 45 1 ERROR: schema "..." does not exist
Times Reported Most Frequent Error / Event #45
Day Hour Count Sep 24 17 1 46 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 #46
Day Hour Count Sep 24 12 1 47 1 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #47
Day Hour Count Sep 24 15 1 48 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 #48
Day Hour Count Sep 24 12 1