pgBadger-
Global information
- Generated on Thu Oct 16 09:08:07 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=15/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=15/h=23/m=00/PT1H.log
- Parsed 4,772 log entries in 1m16s
- Log start from 2025-10-15 10:28:09 to 2025-10-15 21:30:02
-
Overview
Global Stats
- 65 Number of unique normalized queries
- 66 Number of queries
- 25m54s Total query duration
- 2025-10-15 00:01:21 First query
- 2025-10-15 19:39:41 Last query
- 3 queries/s at 2025-10-15 06:22:06 Query peak
- 25m54s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 25m54s Execute total duration
- 967 Number of events
- 36 Number of unique normalized events
- 879 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
- 208 Number temporary file
- 1.06 GiB Max size of temporary file
- 20.76 MiB Average size of temporary file
- 831 Total number of sessions
- 34 sessions at 2025-10-15 13:44:13 Session peak
- 5d7h17m56s Total duration of sessions
- 9m11s Average duration of sessions
- 0 Average queries per session
- 1s870ms Average queries duration per session
- 9m9s Average idle time per session
- 829 Total number of connections
- 11 connections/s at 2025-10-15 18:57:08 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-15 06:22:06 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-15 12:39:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-15 06:22:06 Date
Queries duration
Key values
- 25m54s 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) Oct 15 00 1 0ms 5s731ms 5s731ms 0ms 5s731ms 5s731ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 18 0ms 7s746ms 6s42ms 18s178ms 28s807ms 34s217ms 07 1 0ms 6s118ms 6s118ms 0ms 0ms 6s118ms 08 1 0ms 20s465ms 20s465ms 0ms 0ms 20s465ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 7 0ms 4m8s 50s651ms 14s330ms 1m1s 4m8s 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 1 0ms 4m36s 4m36s 0ms 0ms 4m36s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 36 0ms 2m12s 21s581ms 2m1s 2m12s 2m50s 19 1 0ms 5s12ms 5s12ms 0ms 5s12ms 5s12ms 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) Oct 15 00 1 0 5s731ms 0ms 0ms 5s731ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 4 0 8s281ms 0ms 6s37ms 14s330ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 15 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 20s465ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 1 0 1m1s 0ms 0ms 1m1s 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 1 0 0 4m36s 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 7 29s53ms 0ms 8s442ms 39s126ms 19 1 0 0 0 5s12ms 0ms 0ms 5s12ms 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 Oct 15 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 18 18.00 0.00% 07 0 1 1.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 7 7.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.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 Oct 15 00 19 0.01/s 01 20 0.01/s 02 27 0.01/s 03 23 0.01/s 04 21 0.01/s 05 23 0.01/s 06 30 0.01/s 07 25 0.01/s 08 67 0.02/s 09 36 0.01/s 10 71 0.02/s 11 33 0.01/s 12 23 0.01/s 13 76 0.02/s 14 49 0.01/s 15 65 0.02/s 16 25 0.01/s 17 28 0.01/s 18 62 0.02/s 19 12 0.00/s 20 17 0.00/s 21 31 0.01/s 22 21 0.01/s 23 25 0.01/s Day Hour Count Average Duration Average idle time Oct 15 00 21 1m58s 1m57s 01 20 4m25s 4m25s 02 27 4m3s 4m3s 03 20 4m 4m 04 24 2m45s 2m45s 05 23 2m19s 2m19s 06 29 3m22s 3m18s 07 26 6m22s 6m22s 08 63 2m31s 2m30s 09 35 2m34s 2m34s 10 64 8m24s 8m24s 11 36 3m9s 3m9s 12 27 25m 24m47s 13 69 8m29s 8m29s 14 55 13m54s 13m54s 15 71 8m48s 8m44s 16 25 2m48s 2m48s 17 28 1h37m37s 1h37m37s 18 59 3m41s 3m27s 19 15 1m48s 1m48s 20 17 7m32s 7m32s 21 31 2m45s 2m45s 22 21 3m5s 3m5s 23 25 2m13s 2m13s -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-10-15 18:57:08 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 829 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 829 connections Total
-
Sessions
Simultaneous sessions
Key values
- 34 sessions Session Peak
- 2025-10-15 13:44:13 Date
Histogram of session times
Key values
- 595 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 831 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 831 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 831 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 404.25 MiB Temp Files size Peak
- 2025-10-15 18:40:10 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-10-15 12:40:19 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 2 8.38 MiB 4.19 MiB 09 0 0 0 10 2 8.38 MiB 4.19 MiB 11 0 0 0 12 26 111.06 MiB 4.27 MiB 13 2 8.38 MiB 4.19 MiB 14 0 0 0 15 3 12.56 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 173 4.07 GiB 24.10 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 14 78.03 MiB 2.48 MiB 15.63 MiB 5.57 MiB select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = ? and ceahp1_0.alert_type_a3d_id = ? and ceahp1_1.obj_template_a3d_id = ? and ceahp1_1.obj_num_id = ? order by ceahp1_1.history_date desc;-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = $1 and ceahp1_0.ALERT_TYPE_A3D_ID = $2 and ceahp1_1.OBJ_TEMPLATE_A3D_ID = $3 and ceahp1_1.OBJ_NUM_ID = $4 order by ceahp1_1.HISTORY_DATE desc;
Date: 2025-10-15 12:40:14 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 6 15.17 MiB 2.24 MiB 2.93 MiB 2.53 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-10-15 12:39:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 3 39.59 MiB 4.04 MiB 30.34 MiB 13.20 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-10-15 18:43:20 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 203.20 MiB 14.04 MiB 169.63 MiB 67.73 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-10-15 18:42:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 47.68 MiB 3.75 MiB 39.44 MiB 15.89 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-10-15 18:40:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 67.91 MiB 3.88 MiB 56.19 MiB 22.64 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-10-15 18:43:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 46.49 MiB 3.00 MiB 40.16 MiB 15.50 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-10-15 18:43:37 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 107.50 MiB 8.38 MiB 88.34 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-10-15 18:42:56 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 418.12 MiB 35.32 MiB 331.10 MiB 139.37 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-10-15 18:38:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 1.31 GiB 120.56 MiB 1.06 GiB 447.22 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-10-15 18:37:30 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 92.05 MiB 24.67 MiB 36.49 MiB 30.68 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-15 18:42:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 185.67 MiB 28.73 MiB 127.07 MiB 61.89 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-10-15 18:41:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3 486.75 MiB 1.95 MiB 482.22 MiB 162.25 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-10-15 18:39:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3 78.81 MiB 23.34 MiB 28.35 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-10-15 18:43:08 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3 178.10 MiB 54.45 MiB 65.91 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-10-15 18:42:12 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 11.35 MiB 2.56 MiB 8.79 MiB 5.68 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
17 1 205.51 MiB 205.51 MiB 205.51 MiB 205.51 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-15 18:41:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 437.35 MiB 437.35 MiB 437.35 MiB 437.35 MiB add constraint fk_dependence_obj_type_compo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_dependence_obj_type_compo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-15 18:41:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 2.32 MiB 2.32 MiB 2.32 MiB 2.32 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('202001021239', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021239', '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-10-15 12:39:56 Duration: 6s272ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
20 1 9.90 MiB 9.90 MiB 9.90 MiB 9.90 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-10-15 18:43:36 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 12.09 MiB 12.09 MiB 12.09 MiB 12.09 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-10-15 18:43:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.06 GiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-15 18:37:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 482.22 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-10-15 18:39:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 437.35 MiB ADD CONSTRAINT fk_dependence_obj_type_compo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-15 18:41:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 331.10 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-15 18:38:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 205.51 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-15 18:41:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 169.63 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-15 18:42:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 137.22 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-10-15 18:40:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 127.07 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-15 18:41:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 120.56 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-10-15 18:40:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 88.34 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-10-15 18:42:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 65.91 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-10-15 18:42:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 57.74 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-10-15 18:42:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 56.19 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-10-15 18:43:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 54.45 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-10-15 18:42:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 51.70 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-15 18:38:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 40.16 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-15 18:43:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 39.44 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-10-15 18:40:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 36.49 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-10-15 18:42:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 35.32 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-15 18:38:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 30.89 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-10-15 18:42:44 - 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 Oct 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 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
- 5 Total read queries
- 58 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 66 Requests
- 25m54s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 66 Requests
User Request type Count Duration a3dsupervisor Total 66 25m54s copy from 7 3m38s ddl 27 6m51s delete 3 1m35s insert 1 5s12ms others 3 6m32s select 5 38s857ms tcl 19 1m54s update 1 4m36s Duration by user
Key values
- 25m54s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 66 25m54s copy from 7 3m38s ddl 27 6m51s delete 3 1m35s insert 1 5s12ms others 3 6m32s select 5 38s857ms tcl 19 1m54s update 1 4m36s Queries by host
Key values
- 10.3.0.4 Main host
- 66 Requests
- 25m54s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 34 Requests
- 13m11s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-15 21:31:17 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 36 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 4m36s update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;[ Date: 2025-10-15 15:19:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 4m8s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-15 12:36:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 2m12s VACUUM ANALYSE;[ Date: 2025-10-15 18:55:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 1m19s 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-10-15 18:37:46 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 1m1s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-15 12:44:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 39s344ms 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-10-15 18:40:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 39s126ms 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-10-15 18:41:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 36s677ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-10-15 18:38:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 35s402ms 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-10-15 18:37:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 34s906ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-10-15 18:38:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 30s125ms 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-10-15 18:40:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 29s391ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);[ Date: 2025-10-15 18:37:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 28s69ms 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-10-15 18:39:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 22s500ms 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-10-15 18:42:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 20s465ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-15 08:06:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 20s276ms COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;[ Date: 2025-10-15 18:38:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 18s612ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-10-15 18:42:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 18s498ms CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);[ Date: 2025-10-15 18:39:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 17s26ms ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-15 18:38:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 14s330ms select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;[ Date: 2025-10-15 12:23:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4m36s 1 4m36s 4m36s 4m36s update gtp_background_task set canceling_user_num_id =, export_file_name =, server_id =, source_file_name =, source_obj_num_id =, task_active_status =, task_create_date =, task_current_progress =, task_current_step =, task_end_date =, task_error_message =, task_last_update =, task_log =, task_max_progress =, task_max_step =, task_origin =, task_parameters =, task_report =, task_service_name =, task_start_date =, task_state =, task_status =, task_sub_type =, user_num_id = where task_num_id =;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 15 17 1 4m36s 4m36s [ User: a3dsupervisor - Total duration: 4m36s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m36s - Times executed: 1 ]
-
update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;
Date: 2025-10-15 15:19:50 Duration: 4m36s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4m8s 1 4m8s 4m8s 4m8s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 15 14 1 4m8s 4m8s [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m8s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m12s 1 2m12s 2m12s 2m12s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 15 20 1 2m12s 2m12s [ User: a3dsupervisor - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - Total duration: 2m12s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-15 18:55:42 Duration: 2m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1m54s 19 5s350ms 7s746ms 6s46ms commit;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 15 08 18 1m48s 6s42ms 09 1 6s118ms 6s118ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m54s - Times executed: 19 ]
-
COMMIT;
Date: 2025-10-15 06:47:46 Duration: 7s746ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-15 06:47:47 Duration: 7s193ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-15 06:47:47 Duration: 7s134ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m35s 3 13s975ms 1m1s 31s893ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 15 10 1 20s465ms 20s465ms 14 1 1m1s 1m1s 20 1 13s975ms 13s975ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m35s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-15 12:44:31 Duration: 1m1s 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-10-15 08:06:17 Duration: 20s465ms 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-10-15 18:58:40 Duration: 13s975ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1m19s 1 1m19s 1m19s 1m19s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 15 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-15 18:37:46 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 39s344ms 1 39s344ms 39s344ms 39s344ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 15 20 1 39s344ms 39s344ms [ User: a3dsupervisor - Total duration: 39s344ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 39s344ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 18:40:10 Duration: 39s344ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 39s126ms 1 39s126ms 39s126ms 39s126ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 15 20 1 39s126ms 39s126ms [ User: a3dsupervisor - Total duration: 39s126ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 39s126ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-15 18:41:04 Duration: 39s126ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 36s677ms 1 36s677ms 36s677ms 36s677ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 15 20 1 36s677ms 36s677ms [ User: a3dsupervisor - Total duration: 36s677ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s677ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-15 18:38:22 Duration: 36s677ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 35s402ms 1 35s402ms 35s402ms 35s402ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 15 20 1 35s402ms 35s402ms [ User: a3dsupervisor - Total duration: 35s402ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s402ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-15 18:37:01 Duration: 35s402ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 34s906ms 1 34s906ms 34s906ms 34s906ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 15 20 1 34s906ms 34s906ms [ User: a3dsupervisor - Total duration: 34s906ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s906ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-15 18:38:32 Duration: 34s906ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 30s125ms 1 30s125ms 30s125ms 30s125ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 15 20 1 30s125ms 30s125ms [ User: a3dsupervisor - Total duration: 30s125ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s125ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-10-15 18:40:52 Duration: 30s125ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 29s391ms 1 29s391ms 29s391ms 29s391ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 15 20 1 29s391ms 29s391ms [ User: a3dsupervisor - Total duration: 29s391ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s391ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-15 18:37:31 Duration: 29s391ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 28s69ms 1 28s69ms 28s69ms 28s69ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 15 20 1 28s69ms 28s69ms [ User: a3dsupervisor - Total duration: 28s69ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 28s69ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 18:39:20 Duration: 28s69ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 22s500ms 1 22s500ms 22s500ms 22s500ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 15 20 1 22s500ms 22s500ms [ User: a3dsupervisor - Total duration: 22s500ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 22s500ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-15 18:42:05 Duration: 22s500ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 20s276ms 1 20s276ms 20s276ms 20s276ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 15 20 1 20s276ms 20s276ms [ User: a3dsupervisor - Total duration: 20s276ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s276ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-10-15 18:38:52 Duration: 20s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 18s612ms 1 18s612ms 18s612ms 18s612ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 15 20 1 18s612ms 18s612ms [ User: a3dsupervisor - Total duration: 18s612ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s612ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 18:42:12 Duration: 18s612ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 18s498ms 1 18s498ms 18s498ms 18s498ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 15 20 1 18s498ms 18s498ms [ User: a3dsupervisor - Total duration: 18s498ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s498ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-10-15 18:39:24 Duration: 18s498ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 17s26ms 1 17s26ms 17s26ms 17s26ms 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 Oct 15 20 1 17s26ms 17s26ms [ User: a3dsupervisor - Total duration: 17s26ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s26ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-15 18:38:52 Duration: 17s26ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 14s330ms 1 14s330ms 14s330ms 14s330ms select cehp1_0.history_num_id, case when cehp1_1.history_num_id is not null then ? when cehp1_0.history_num_id is not null then ? end, cehp1_0.history_action, cehp1_0.history_date, cehp1_0.obj_num_id, cehp1_0.obj_template_a3d_id, cehp1_1.alert_src_num_id, cehp1_1.alert_type_a3d_id from gtp_cw_eng_history cehp1_0 left join gtp_cw_eng_alert cehp1_1 on cehp1_0.history_num_id = cehp1_1.history_num_id where cehp1_0.history_action = and cehp1_0.obj_template_a3d_id = and cehp1_0.obj_num_id = order by cehp1_0.history_date desc fetch first rows only;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 15 14 1 14s330ms 14s330ms [ User: a3dsupervisor - Total duration: 14s330ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s330ms - Times executed: 1 ]
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-15 12:23:23 Duration: 14s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 19 1m54s 5s350ms 7s746ms 6s46ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 15 08 18 1m48s 6s42ms 09 1 6s118ms 6s118ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m54s - Times executed: 19 ]
-
COMMIT;
Date: 2025-10-15 06:47:46 Duration: 7s746ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-15 06:47:47 Duration: 7s193ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-15 06:47:47 Duration: 7s134ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3 1m35s 13s975ms 1m1s 31s893ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 15 10 1 20s465ms 20s465ms 14 1 1m1s 1m1s 20 1 13s975ms 13s975ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m35s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-15 12:44:31 Duration: 1m1s 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-10-15 08:06:17 Duration: 20s465ms 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-10-15 18:58:40 Duration: 13s975ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1 4m36s 4m36s 4m36s 4m36s update gtp_background_task set canceling_user_num_id =, export_file_name =, server_id =, source_file_name =, source_obj_num_id =, task_active_status =, task_create_date =, task_current_progress =, task_current_step =, task_end_date =, task_error_message =, task_last_update =, task_log =, task_max_progress =, task_max_step =, task_origin =, task_parameters =, task_report =, task_service_name =, task_start_date =, task_state =, task_status =, task_sub_type =, user_num_id = where task_num_id =;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 15 17 1 4m36s 4m36s [ User: a3dsupervisor - Total duration: 4m36s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m36s - Times executed: 1 ]
-
update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;
Date: 2025-10-15 15:19:50 Duration: 4m36s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 4m8s 4m8s 4m8s 4m8s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 15 14 1 4m8s 4m8s [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m8s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1 2m12s 2m12s 2m12s 2m12s vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 15 20 1 2m12s 2m12s [ User: a3dsupervisor - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - Total duration: 2m12s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-15 18:55:42 Duration: 2m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1 1m19s 1m19s 1m19s 1m19s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 15 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-15 18:37:46 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1 39s344ms 39s344ms 39s344ms 39s344ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 15 20 1 39s344ms 39s344ms [ User: a3dsupervisor - Total duration: 39s344ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 39s344ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 18:40:10 Duration: 39s344ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 39s126ms 39s126ms 39s126ms 39s126ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 15 20 1 39s126ms 39s126ms [ User: a3dsupervisor - Total duration: 39s126ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 39s126ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-15 18:41:04 Duration: 39s126ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 36s677ms 36s677ms 36s677ms 36s677ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 15 20 1 36s677ms 36s677ms [ User: a3dsupervisor - Total duration: 36s677ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s677ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-15 18:38:22 Duration: 36s677ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 35s402ms 35s402ms 35s402ms 35s402ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 15 20 1 35s402ms 35s402ms [ User: a3dsupervisor - Total duration: 35s402ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s402ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-15 18:37:01 Duration: 35s402ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 34s906ms 34s906ms 34s906ms 34s906ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 15 20 1 34s906ms 34s906ms [ User: a3dsupervisor - Total duration: 34s906ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s906ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-15 18:38:32 Duration: 34s906ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 30s125ms 30s125ms 30s125ms 30s125ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 15 20 1 30s125ms 30s125ms [ User: a3dsupervisor - Total duration: 30s125ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s125ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-10-15 18:40:52 Duration: 30s125ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 29s391ms 29s391ms 29s391ms 29s391ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 15 20 1 29s391ms 29s391ms [ User: a3dsupervisor - Total duration: 29s391ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s391ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-15 18:37:31 Duration: 29s391ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 28s69ms 28s69ms 28s69ms 28s69ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 15 20 1 28s69ms 28s69ms [ User: a3dsupervisor - Total duration: 28s69ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 28s69ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 18:39:20 Duration: 28s69ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 22s500ms 22s500ms 22s500ms 22s500ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 15 20 1 22s500ms 22s500ms [ User: a3dsupervisor - Total duration: 22s500ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 22s500ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-15 18:42:05 Duration: 22s500ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 20s276ms 20s276ms 20s276ms 20s276ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 15 20 1 20s276ms 20s276ms [ User: a3dsupervisor - Total duration: 20s276ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s276ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-10-15 18:38:52 Duration: 20s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 18s612ms 18s612ms 18s612ms 18s612ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 15 20 1 18s612ms 18s612ms [ User: a3dsupervisor - Total duration: 18s612ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s612ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 18:42:12 Duration: 18s612ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 18s498ms 18s498ms 18s498ms 18s498ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 15 20 1 18s498ms 18s498ms [ User: a3dsupervisor - Total duration: 18s498ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s498ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-10-15 18:39:24 Duration: 18s498ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 17s26ms 17s26ms 17s26ms 17s26ms 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 Oct 15 20 1 17s26ms 17s26ms [ User: a3dsupervisor - Total duration: 17s26ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s26ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-15 18:38:52 Duration: 17s26ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 14s330ms 14s330ms 14s330ms 14s330ms select cehp1_0.history_num_id, case when cehp1_1.history_num_id is not null then ? when cehp1_0.history_num_id is not null then ? end, cehp1_0.history_action, cehp1_0.history_date, cehp1_0.obj_num_id, cehp1_0.obj_template_a3d_id, cehp1_1.alert_src_num_id, cehp1_1.alert_type_a3d_id from gtp_cw_eng_history cehp1_0 left join gtp_cw_eng_alert cehp1_1 on cehp1_0.history_num_id = cehp1_1.history_num_id where cehp1_0.history_action = and cehp1_0.obj_template_a3d_id = and cehp1_0.obj_num_id = order by cehp1_0.history_date desc fetch first rows only;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 15 14 1 14s330ms 14s330ms [ User: a3dsupervisor - Total duration: 14s330ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s330ms - Times executed: 1 ]
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-15 12:23:23 Duration: 14s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 4m36s 4m36s 4m36s 1 4m36s update gtp_background_task set canceling_user_num_id =, export_file_name =, server_id =, source_file_name =, source_obj_num_id =, task_active_status =, task_create_date =, task_current_progress =, task_current_step =, task_end_date =, task_error_message =, task_last_update =, task_log =, task_max_progress =, task_max_step =, task_origin =, task_parameters =, task_report =, task_service_name =, task_start_date =, task_state =, task_status =, task_sub_type =, user_num_id = where task_num_id =;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 15 17 1 4m36s 4m36s [ User: a3dsupervisor - Total duration: 4m36s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m36s - Times executed: 1 ]
-
update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;
Date: 2025-10-15 15:19:50 Duration: 4m36s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4m8s 4m8s 4m8s 1 4m8s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 15 14 1 4m8s 4m8s [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m8s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m12s 2m12s 2m12s 1 2m12s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 15 20 1 2m12s 2m12s [ User: a3dsupervisor - Total duration: 2m12s - Times executed: 1 ]
[ Application: psql - Total duration: 2m12s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-15 18:55:42 Duration: 2m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1m19s 1m19s 1m19s 1 1m19s 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 Oct 15 20 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-15 18:37:46 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 39s344ms 39s344ms 39s344ms 1 39s344ms 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 Oct 15 20 1 39s344ms 39s344ms [ User: a3dsupervisor - Total duration: 39s344ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 39s344ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 18:40:10 Duration: 39s344ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 39s126ms 39s126ms 39s126ms 1 39s126ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 15 20 1 39s126ms 39s126ms [ User: a3dsupervisor - Total duration: 39s126ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 39s126ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-15 18:41:04 Duration: 39s126ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 36s677ms 36s677ms 36s677ms 1 36s677ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 15 20 1 36s677ms 36s677ms [ User: a3dsupervisor - Total duration: 36s677ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s677ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-15 18:38:22 Duration: 36s677ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 35s402ms 35s402ms 35s402ms 1 35s402ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 15 20 1 35s402ms 35s402ms [ User: a3dsupervisor - Total duration: 35s402ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s402ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-10-15 18:37:01 Duration: 35s402ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 34s906ms 34s906ms 34s906ms 1 34s906ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 15 20 1 34s906ms 34s906ms [ User: a3dsupervisor - Total duration: 34s906ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s906ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-15 18:38:32 Duration: 34s906ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 13s975ms 1m1s 31s893ms 3 1m35s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 15 10 1 20s465ms 20s465ms 14 1 1m1s 1m1s 20 1 13s975ms 13s975ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m35s - Times executed: 3 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-15 12:44:31 Duration: 1m1s 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-10-15 08:06:17 Duration: 20s465ms 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-10-15 18:58:40 Duration: 13s975ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 30s125ms 30s125ms 30s125ms 1 30s125ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 15 20 1 30s125ms 30s125ms [ User: a3dsupervisor - Total duration: 30s125ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s125ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-10-15 18:40:52 Duration: 30s125ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 29s391ms 29s391ms 29s391ms 1 29s391ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 15 20 1 29s391ms 29s391ms [ User: a3dsupervisor - Total duration: 29s391ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s391ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-15 18:37:31 Duration: 29s391ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 28s69ms 28s69ms 28s69ms 1 28s69ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 15 20 1 28s69ms 28s69ms [ User: a3dsupervisor - Total duration: 28s69ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 28s69ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 18:39:20 Duration: 28s69ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 22s500ms 22s500ms 22s500ms 1 22s500ms 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 Oct 15 20 1 22s500ms 22s500ms [ User: a3dsupervisor - Total duration: 22s500ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 22s500ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-15 18:42:05 Duration: 22s500ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 20s276ms 20s276ms 20s276ms 1 20s276ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 15 20 1 20s276ms 20s276ms [ User: a3dsupervisor - Total duration: 20s276ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s276ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-10-15 18:38:52 Duration: 20s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 18s612ms 18s612ms 18s612ms 1 18s612ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 15 20 1 18s612ms 18s612ms [ User: a3dsupervisor - Total duration: 18s612ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s612ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 18:42:12 Duration: 18s612ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 18s498ms 18s498ms 18s498ms 1 18s498ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 15 20 1 18s498ms 18s498ms [ User: a3dsupervisor - Total duration: 18s498ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s498ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-10-15 18:39:24 Duration: 18s498ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 17s26ms 17s26ms 17s26ms 1 17s26ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 15 20 1 17s26ms 17s26ms [ User: a3dsupervisor - Total duration: 17s26ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s26ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-15 18:38:52 Duration: 17s26ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 14s330ms 14s330ms 14s330ms 1 14s330ms select cehp1_0.history_num_id, case when cehp1_1.history_num_id is not null then ? when cehp1_0.history_num_id is not null then ? end, cehp1_0.history_action, cehp1_0.history_date, cehp1_0.obj_num_id, cehp1_0.obj_template_a3d_id, cehp1_1.alert_src_num_id, cehp1_1.alert_type_a3d_id from gtp_cw_eng_history cehp1_0 left join gtp_cw_eng_alert cehp1_1 on cehp1_0.history_num_id = cehp1_1.history_num_id where cehp1_0.history_action = and cehp1_0.obj_template_a3d_id = and cehp1_0.obj_num_id = order by cehp1_0.history_date desc fetch first rows only;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 15 14 1 14s330ms 14s330ms [ User: a3dsupervisor - Total duration: 14s330ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14s330ms - Times executed: 1 ]
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-15 12:23:23 Duration: 14s330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s350ms 7s746ms 6s46ms 19 1m54s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 15 08 18 1m48s 6s42ms 09 1 6s118ms 6s118ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m54s - Times executed: 19 ]
-
COMMIT;
Date: 2025-10-15 06:47:46 Duration: 7s746ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-15 06:47:47 Duration: 7s193ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-15 06:47:47 Duration: 7s134ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 3,739 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 953 ERROR entries
- 14 WARNING entries
Most Frequent Errors/Events
Key values
- 879 Max number of times the same event was reported
- 967 Total events found
Rank Times reported Error 1 879 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 15 02 1 05 1 21 92 22 364 23 251 00 168 01 2 2 40 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 15 10 2 12 9 14 2 15 4 17 20 19 3 3 8 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 15 14 8 4 6 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 15 14 6 5 2 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 15 14 2 6 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID=,EXPORT_FILE_NAME=,SERVER_ID=,SOURCE_FILE_NAME=,SOURCE_OBJ_NUM_ID=,TASK_ACTIVE_STATUS=,TASK_CREATE_DATE=,TASK_CURRENT_PROGRESS=,TASK_CURRENT_STEP=,TASK_END_DATE=,TASK_ERROR_MESSAGE=,TASK_LAST_UPDATE=,TASK_LOG=,TASK_MAX_PROGRESS=,TASK_MAX_STEP=,TASK_ORIGIN=,TASK_PARAMETERS=,TASK_REPORT=,TASK_SERVICE_NAME=,TASK_START_DATE=,TASK_STATE=,TASK_STATUS=,TASK_SUB_TYPE=,USER_NUM_ID= where TASK_NUM_ID=
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 15 17 2 7 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 #7
Day Hour Count Oct 15 20 1 8 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 15 14 1 9 1 ERROR: canceling statement due to lock timeoutselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 15 14 1 10 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 #10
Day Hour Count Oct 15 20 1 11 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 #11
Day Hour Count Oct 15 20 1 12 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 15 20 1 13 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 15 20 1 14 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 15 14 1 15 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #15
Day Hour Count Oct 15 14 1 16 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 15 14 1 17 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 15 20 1 18 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 #18
Day Hour Count Oct 15 20 1 19 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #19
Day Hour Count Oct 15 14 1 20 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #20
Day Hour Count Oct 15 20 1 21 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #21
Day Hour Count Oct 15 14 1 22 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #22
Day Hour Count Oct 15 20 1 23 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #23
Day Hour Count Oct 15 14 1 24 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #24
Day Hour Count Oct 15 14 1 25 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 #25
Day Hour Count Oct 15 20 1 26 1 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #26
Day Hour Count Oct 15 14 1 27 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 #27
Day Hour Count Oct 15 20 1 28 1 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #28
Day Hour Count Oct 15 14 1 29 1 ERROR: null value in column "..." of relation "..." violates not-null constraintSELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #29
Day Hour Count Oct 15 14 1 30 1 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #30
Day Hour Count Oct 15 20 1 31 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_TIME_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #31
Day Hour Count Oct 15 14 1 32 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #32
Day Hour Count Oct 15 14 1 33 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #33
Day Hour Count Oct 15 14 1 34 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #34
Day Hour Count Oct 15 14 1 35 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #35
Day Hour Count Oct 15 14 1 36 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #36
Day Hour Count Oct 15 20 1