pgBadger-
Global information
- Generated on Mon Oct 20 09:06:14 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=17/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=17/h=23/m=00/PT1H.log
- Parsed 4,737 log entries in 50s
- Log start from 2025-10-17 07:06:51 to 2025-10-17 23:30:28
-
Overview
Global Stats
- 61 Number of unique normalized queries
- 54 Number of queries
- 20m18s Total query duration
- 2025-10-17 00:00:34 First query
- 2025-10-17 18:58:03 Last query
- 3 queries/s at 2025-10-17 06:26:56 Query peak
- 20m18s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 20m18s Execute total duration
- 1,132 Number of events
- 37 Number of unique normalized events
- 1,070 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
- 192 Number temporary file
- 1014.33 MiB Max size of temporary file
- 21.63 MiB Average size of temporary file
- 724 Total number of sessions
- 26 sessions at 2025-10-17 18:56:46 Session peak
- 3d10h17m38s Total duration of sessions
- 6m49s Average duration of sessions
- 0 Average queries per session
- 1s682ms Average queries duration per session
- 6m47s Average idle time per session
- 721 Total number of connections
- 10 connections/s at 2025-10-17 12:54:13 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-17 06:26:56 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-17 11:30:55 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-17 06:26:56 Date
Queries duration
Key values
- 20m18s 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 17 00 1 0ms 5s993ms 5s993ms 0ms 5s993ms 5s993ms 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 7 0ms 8s57ms 6s224ms 8s57ms 13s699ms 15s720ms 07 1 0ms 5s956ms 5s956ms 0ms 0ms 5s956ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 7 0ms 4m3s 57s562ms 1m6s 4m3s 4m3s 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 38 0ms 1m54s 19s996ms 1m54s 2m 3m 19 0 0ms 0ms 0ms 0ms 0ms 0ms 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 17 00 1 0 5s993ms 0ms 0ms 5s993ms 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 4 0 20s389ms 0ms 13s668ms 55s176ms 12 0 0 0ms 0ms 0ms 0ms 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 17 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 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 1 0 1m6s 0ms 0ms 1m6s 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 6 31s100ms 0ms 14s44ms 1m 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 Oct 17 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 7 7.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 7 7.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.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 Oct 17 00 16 0.00/s 01 20 0.01/s 02 28 0.01/s 03 27 0.01/s 04 27 0.01/s 05 15 0.00/s 06 30 0.01/s 07 32 0.01/s 08 21 0.01/s 09 26 0.01/s 10 32 0.01/s 11 19 0.01/s 12 34 0.01/s 13 37 0.01/s 14 34 0.01/s 15 44 0.01/s 16 34 0.01/s 17 35 0.01/s 18 64 0.02/s 19 24 0.01/s 20 34 0.01/s 21 24 0.01/s 22 36 0.01/s 23 28 0.01/s Day Hour Count Average Duration Average idle time Oct 17 00 20 3m57s 3m57s 01 20 2m36s 2m36s 02 28 3m58s 3m58s 03 26 3m29s 3m29s 04 28 3m1s 3m1s 05 15 3m52s 3m52s 06 27 1m39s 1m37s 07 35 46m44s 46m44s 08 21 3m25s 3m25s 09 26 3m 3m 10 31 3m8s 3m8s 11 20 4m6s 3m46s 12 34 4m30s 4m30s 13 36 2m38s 2m38s 14 35 2m37s 2m37s 15 44 24m20s 24m20s 16 34 2m24s 2m24s 17 35 7m56s 7m56s 18 59 3m51s 3m38s 19 26 3m13s 3m13s 20 37 2m35s 2m35s 21 24 3m41s 3m41s 22 36 2m35s 2m35s 23 27 3m20s 3m20s -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-10-17 12:54:13 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 721 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 721 connections Total
-
Sessions
Simultaneous sessions
Key values
- 26 sessions Session Peak
- 2025-10-17 18:56:46 Date
Histogram of session times
Key values
- 544 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 724 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 724 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 724 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 387.02 MiB Temp Files size Peak
- 2025-10-17 18:39:16 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-10-17 18:42:11 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 17 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 25 106.87 MiB 4.27 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 167 3.95 GiB 24.23 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-17 11:44:18 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 9 28.84 MiB 2.24 MiB 8.79 MiB 3.20 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-17 11:40:55 Duration: 4m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 3 318.47 MiB 3.57 MiB 310.02 MiB 106.16 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-17 18:41:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 178.09 MiB 50.93 MiB 76.19 MiB 59.36 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-17 18:40:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 596.73 MiB 20.02 MiB 553.08 MiB 198.91 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-17 18:39:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 253.27 MiB 16.09 MiB 220.73 MiB 84.42 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-17 18:41:02 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 745.26 MiB 116.98 MiB 504.46 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-10-17 18:38:32 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 95.02 MiB 29.27 MiB 35.77 MiB 31.67 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-17 18:41:29 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 13.15 MiB 3.63 MiB 5.88 MiB 4.38 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-10-17 18:42:20 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 418.12 MiB 36.00 MiB 332.52 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-17 18:37:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 21.77 MiB 2.30 MiB 16.55 MiB 7.26 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-17 18:42:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 15.59 MiB 4.57 MiB 6.22 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-10-17 18:41:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 35.83 MiB 35.83 MiB 35.83 MiB 35.83 MiB add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:41:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 7.40 MiB 7.40 MiB 7.40 MiB 7.40 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-17 18:42:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 209.32 MiB 209.32 MiB 209.32 MiB 209.32 MiB add constraint fk_gtp_obj_rel_vt_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:40:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 1014.33 MiB 1014.33 MiB 1014.33 MiB 1014.33 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-17 18:36:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 68.50 MiB 68.50 MiB 68.50 MiB 68.50 MiB add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:40:17 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 1014.33 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-17 18:36:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 553.08 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-17 18:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 504.46 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-17 18:38:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 332.52 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-17 18:37:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 310.02 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-10-17 18:41:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 220.73 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-17 18:41:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 209.32 MiB ADD CONSTRAINT fk_gtp_obj_rel_vt_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-17 18:40:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 123.81 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-17 18:39:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 116.98 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-17 18:39:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 76.19 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-17 18:40:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 68.50 MiB ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-17 18:40:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 50.98 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-10-17 18:40:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 50.93 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-17 18:40:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 49.60 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-17 18:38:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 36.00 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-17 18:38:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 35.83 MiB ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-17 18:41:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 35.77 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-17 18:41:29 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 29.98 MiB ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-10-17 18:41:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 29.27 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-17 18:41:35 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 23.62 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-17 18:40:30 - 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 17 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareRowExclusiveLock Main Lock Type
- 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
- 5 Total read queries
- 46 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 54 Requests
- 20m18s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 54 Requests
User Request type Count Duration a3dsupervisor Total 54 20m18s copy from 6 3m23s ddl 29 7m1s delete 2 1m20s others 3 6m9s select 5 1m27s tcl 9 55s792ms Duration by user
Key values
- 20m18s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 54 20m18s copy from 6 3m23s ddl 29 7m1s delete 2 1m20s others 3 6m9s select 5 1m27s tcl 9 55s792ms Queries by host
Key values
- 10.3.0.4 Main host
- 54 Requests
- 20m18s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 36 Requests
- 10m31s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-17 18:38:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 31 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 4m3s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-17 11:40:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 1m54s VACUUM ANALYSE;[ Date: 2025-10-17 18:55:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m16s 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-17 18:37:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1m6s delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-17 11:48:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 55s176ms SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;[ Date: 2025-10-17 11:30:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 36s180ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-10-17 18:37:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 35s292ms 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-17 18:36:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 33s252ms 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-17 18:39:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 32s545ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-10-17 18:37:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 32s34ms 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-17 18:39:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 32s7ms ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-17 18:40:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 26s775ms 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-17 18:39:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 25s341ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);[ Date: 2025-10-17 18:36:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 25s195ms 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-17 18:38:29 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 21s200ms ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-17 18:38:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 18s527ms 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-10-17 18:38:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 17s385ms 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-17 18:38:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 15s35ms ALTER TABLE ONLY public.gtp_history_obj_compo;[ Date: 2025-10-17 18:40:14 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 14s568ms COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;[ Date: 2025-10-17 18:41:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 14s463ms 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-17 18:41:19 - 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 4m3s 1 4m3s 4m3s 4m3s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 17 13 1 4m3s 4m3s [ User: a3dsupervisor - Total duration: 4m3s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m3s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-17 11:40:55 Duration: 4m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1m54s 1 1m54s 1m54s 1m54s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 17 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 1 ]
[ Application: psql - Total duration: 1m54s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-17 18:55:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m20s 2 14s44ms 1m6s 40s299ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 17 13 1 1m6s 1m6s 20 1 14s44ms 14s44ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m20s - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-17 11:48:32 Duration: 1m6s 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-17 18:58:03 Duration: 14s44ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1m16s 1 1m16s 1m16s 1m16s 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 17 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - 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-17 18:37:05 Duration: 1m16s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 55s792ms 9 5s237ms 8s57ms 6s199ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 17 08 7 43s574ms 6s224ms 09 1 5s956ms 5s956ms 20 1 6s261ms 6s261ms [ User: a3dsupervisor - Total duration: 55s792ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s530ms - Times executed: 8 ]
[ Application: pg_restore - Total duration: 6s261ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-10-17 06:27:24 Duration: 8s57ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-17 06:49:11 Duration: 7s586ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-17 18:39:04 Duration: 6s261ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 55s176ms 1 55s176ms 55s176ms 55s176ms select goc.obj_compo_value from gtp_att_template gat inner join gtp_obj_composition goc on (gat.att_template_num_id = goc.att_template_num_id) inner join gtp_obj go on (goc.obj_num_id = go.obj_num_id) where gat.att_template_num_id = and go.obj_state is null and goc.obj_compo_value is not null group by goc.obj_compo_value having count(goc.obj_compo_value) > ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 17 13 1 55s176ms 55s176ms [ User: a3dsupervisor - Total duration: 55s176ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s176ms - Times executed: 1 ]
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-10-17 11:30:55 Duration: 55s176ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 36s180ms 1 36s180ms 36s180ms 36s180ms 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 17 20 1 36s180ms 36s180ms [ User: a3dsupervisor - Total duration: 36s180ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s180ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-17 18:37:41 Duration: 36s180ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 35s292ms 1 35s292ms 35s292ms 35s292ms 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 17 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 35s292ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s292ms - 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-17 18:36:24 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 33s252ms 1 33s252ms 33s252ms 33s252ms 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 Oct 17 20 1 33s252ms 33s252ms [ User: a3dsupervisor - Total duration: 33s252ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s252ms - 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-17 18:39:50 Duration: 33s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 32s545ms 1 32s545ms 32s545ms 32s545ms 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 Oct 17 20 1 32s545ms 32s545ms [ User: a3dsupervisor - Total duration: 32s545ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s545ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-17 18:37:45 Duration: 32s545ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 32s34ms 1 32s34ms 32s34ms 32s34ms 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 #11
Day Hour Count Duration Avg duration Oct 17 20 1 32s34ms 32s34ms [ User: a3dsupervisor - Total duration: 32s34ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s34ms - 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-17 18:39:16 Duration: 32s34ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 32s7ms 1 32s7ms 32s7ms 32s7ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 17 20 1 32s7ms 32s7ms [ User: a3dsupervisor - Total duration: 32s7ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s7ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:40:53 Duration: 32s7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 26s775ms 1 26s775ms 26s775ms 26s775ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 17 20 1 26s775ms 26s775ms [ User: a3dsupervisor - Total duration: 26s775ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s775ms - 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-17 18:39:43 Duration: 26s775ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 25s341ms 1 25s341ms 25s341ms 25s341ms 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 Oct 17 20 1 25s341ms 25s341ms [ User: a3dsupervisor - Total duration: 25s341ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s341ms - 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-17 18:36:50 Duration: 25s341ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 25s195ms 1 25s195ms 25s195ms 25s195ms 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 #15
Day Hour Count Duration Avg duration Oct 17 20 1 25s195ms 25s195ms [ User: a3dsupervisor - Total duration: 25s195ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s195ms - 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-17 18:38:29 Duration: 25s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 21s200ms 1 21s200ms 21s200ms 21s200ms 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 Oct 17 20 1 21s200ms 21s200ms [ User: a3dsupervisor - Total duration: 21s200ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s200ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-17 18:38:15 Duration: 21s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 18s527ms 1 18s527ms 18s527ms 18s527ms 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 Oct 17 20 1 18s527ms 18s527ms [ User: a3dsupervisor - Total duration: 18s527ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s527ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-17 18:38:33 Duration: 18s527ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 17s385ms 1 17s385ms 17s385ms 17s385ms 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 #18
Day Hour Count Duration Avg duration Oct 17 20 1 17s385ms 17s385ms [ User: a3dsupervisor - Total duration: 17s385ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s385ms - 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-17 18:38:03 Duration: 17s385ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 15s35ms 1 15s35ms 15s35ms 15s35ms alter table only public.gtp_history_obj_compo;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 17 20 1 15s35ms 15s35ms [ User: a3dsupervisor - Total duration: 15s35ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s35ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo;
Date: 2025-10-17 18:40:14 Duration: 15s35ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 14s568ms 1 14s568ms 14s568ms 14s568ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 17 20 1 14s568ms 14s568ms [ User: a3dsupervisor - Total duration: 14s568ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s568ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-17 18:41:52 Duration: 14s568ms 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 9 55s792ms 5s237ms 8s57ms 6s199ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 17 08 7 43s574ms 6s224ms 09 1 5s956ms 5s956ms 20 1 6s261ms 6s261ms [ User: a3dsupervisor - Total duration: 55s792ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s530ms - Times executed: 8 ]
[ Application: pg_restore - Total duration: 6s261ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-10-17 06:27:24 Duration: 8s57ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-17 06:49:11 Duration: 7s586ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-17 18:39:04 Duration: 6s261ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 2 1m20s 14s44ms 1m6s 40s299ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 17 13 1 1m6s 1m6s 20 1 14s44ms 14s44ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m20s - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-17 11:48:32 Duration: 1m6s 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-17 18:58:03 Duration: 14s44ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1 4m3s 4m3s 4m3s 4m3s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 17 13 1 4m3s 4m3s [ User: a3dsupervisor - Total duration: 4m3s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m3s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-17 11:40:55 Duration: 4m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 1m54s 1m54s 1m54s 1m54s vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 17 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 1 ]
[ Application: psql - Total duration: 1m54s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-17 18:55:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 1m16s 1m16s 1m16s 1m16s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 17 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - 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-17 18:37:05 Duration: 1m16s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1 55s176ms 55s176ms 55s176ms 55s176ms select goc.obj_compo_value from gtp_att_template gat inner join gtp_obj_composition goc on (gat.att_template_num_id = goc.att_template_num_id) inner join gtp_obj go on (goc.obj_num_id = go.obj_num_id) where gat.att_template_num_id = and go.obj_state is null and goc.obj_compo_value is not null group by goc.obj_compo_value having count(goc.obj_compo_value) > ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 17 13 1 55s176ms 55s176ms [ User: a3dsupervisor - Total duration: 55s176ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s176ms - Times executed: 1 ]
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-10-17 11:30:55 Duration: 55s176ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 1 36s180ms 36s180ms 36s180ms 36s180ms 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 17 20 1 36s180ms 36s180ms [ User: a3dsupervisor - Total duration: 36s180ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s180ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-17 18:37:41 Duration: 36s180ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 35s292ms 35s292ms 35s292ms 35s292ms 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 17 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 35s292ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s292ms - 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-17 18:36:24 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 33s252ms 33s252ms 33s252ms 33s252ms 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 Oct 17 20 1 33s252ms 33s252ms [ User: a3dsupervisor - Total duration: 33s252ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s252ms - 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-17 18:39:50 Duration: 33s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 32s545ms 32s545ms 32s545ms 32s545ms 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 Oct 17 20 1 32s545ms 32s545ms [ User: a3dsupervisor - Total duration: 32s545ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s545ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-17 18:37:45 Duration: 32s545ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 32s34ms 32s34ms 32s34ms 32s34ms 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 #11
Day Hour Count Duration Avg duration Oct 17 20 1 32s34ms 32s34ms [ User: a3dsupervisor - Total duration: 32s34ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s34ms - 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-17 18:39:16 Duration: 32s34ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 32s7ms 32s7ms 32s7ms 32s7ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 17 20 1 32s7ms 32s7ms [ User: a3dsupervisor - Total duration: 32s7ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s7ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:40:53 Duration: 32s7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 26s775ms 26s775ms 26s775ms 26s775ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 17 20 1 26s775ms 26s775ms [ User: a3dsupervisor - Total duration: 26s775ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s775ms - 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-17 18:39:43 Duration: 26s775ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 25s341ms 25s341ms 25s341ms 25s341ms 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 Oct 17 20 1 25s341ms 25s341ms [ User: a3dsupervisor - Total duration: 25s341ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s341ms - 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-17 18:36:50 Duration: 25s341ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 25s195ms 25s195ms 25s195ms 25s195ms 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 #15
Day Hour Count Duration Avg duration Oct 17 20 1 25s195ms 25s195ms [ User: a3dsupervisor - Total duration: 25s195ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s195ms - 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-17 18:38:29 Duration: 25s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 21s200ms 21s200ms 21s200ms 21s200ms 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 Oct 17 20 1 21s200ms 21s200ms [ User: a3dsupervisor - Total duration: 21s200ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s200ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-17 18:38:15 Duration: 21s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 18s527ms 18s527ms 18s527ms 18s527ms 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 Oct 17 20 1 18s527ms 18s527ms [ User: a3dsupervisor - Total duration: 18s527ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s527ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-17 18:38:33 Duration: 18s527ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 17s385ms 17s385ms 17s385ms 17s385ms 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 #18
Day Hour Count Duration Avg duration Oct 17 20 1 17s385ms 17s385ms [ User: a3dsupervisor - Total duration: 17s385ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s385ms - 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-17 18:38:03 Duration: 17s385ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 15s35ms 15s35ms 15s35ms 15s35ms alter table only public.gtp_history_obj_compo;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 17 20 1 15s35ms 15s35ms [ User: a3dsupervisor - Total duration: 15s35ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s35ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo;
Date: 2025-10-17 18:40:14 Duration: 15s35ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 14s568ms 14s568ms 14s568ms 14s568ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 17 20 1 14s568ms 14s568ms [ User: a3dsupervisor - Total duration: 14s568ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s568ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-17 18:41:52 Duration: 14s568ms 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 4m3s 4m3s 4m3s 1 4m3s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 17 13 1 4m3s 4m3s [ User: a3dsupervisor - Total duration: 4m3s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m3s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-17 11:40:55 Duration: 4m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1m54s 1m54s 1m54s 1 1m54s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 17 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 1 ]
[ Application: psql - Total duration: 1m54s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-17 18:55:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m16s 1m16s 1m16s 1 1m16s 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 Oct 17 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - 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-17 18:37:05 Duration: 1m16s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 55s176ms 55s176ms 55s176ms 1 55s176ms select goc.obj_compo_value from gtp_att_template gat inner join gtp_obj_composition goc on (gat.att_template_num_id = goc.att_template_num_id) inner join gtp_obj go on (goc.obj_num_id = go.obj_num_id) where gat.att_template_num_id = and go.obj_state is null and goc.obj_compo_value is not null group by goc.obj_compo_value having count(goc.obj_compo_value) > ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 17 13 1 55s176ms 55s176ms [ User: a3dsupervisor - Total duration: 55s176ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 55s176ms - Times executed: 1 ]
-
SELECT goc.OBJ_COMPO_VALUE FROM GTP_ATT_TEMPLATE gat INNER JOIN GTP_OBJ_COMPOSITION goc ON (gat.att_template_num_id = goc.att_template_num_id) INNER JOIN GTP_OBJ go ON (goc.OBJ_NUM_ID = go.OBJ_NUM_ID) WHERE gat.att_template_num_id = AND go.OBJ_STATE IS NULL AND goc.OBJ_COMPO_VALUE is not NULL GROUP BY goc.OBJ_COMPO_VALUE HAVING COUNT(goc.OBJ_COMPO_VALUE) > 1;
Date: 2025-10-17 11:30:55 Duration: 55s176ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 14s44ms 1m6s 40s299ms 2 1m20s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 17 13 1 1m6s 1m6s 20 1 14s44ms 14s44ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m20s - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-17 11:48:32 Duration: 1m6s 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-17 18:58:03 Duration: 14s44ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 36s180ms 36s180ms 36s180ms 1 36s180ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 17 20 1 36s180ms 36s180ms [ User: a3dsupervisor - Total duration: 36s180ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s180ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-17 18:37:41 Duration: 36s180ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 35s292ms 35s292ms 35s292ms 1 35s292ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 17 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 35s292ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s292ms - 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-17 18:36:24 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 33s252ms 33s252ms 33s252ms 1 33s252ms 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 17 20 1 33s252ms 33s252ms [ User: a3dsupervisor - Total duration: 33s252ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 33s252ms - 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-17 18:39:50 Duration: 33s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 32s545ms 32s545ms 32s545ms 1 32s545ms 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 17 20 1 32s545ms 32s545ms [ User: a3dsupervisor - Total duration: 32s545ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s545ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-17 18:37:45 Duration: 32s545ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 32s34ms 32s34ms 32s34ms 1 32s34ms 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 Oct 17 20 1 32s34ms 32s34ms [ User: a3dsupervisor - Total duration: 32s34ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s34ms - 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-17 18:39:16 Duration: 32s34ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 32s7ms 32s7ms 32s7ms 1 32s7ms alter table only public.gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 17 20 1 32s7ms 32s7ms [ User: a3dsupervisor - Total duration: 32s7ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s7ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:40:53 Duration: 32s7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 26s775ms 26s775ms 26s775ms 1 26s775ms 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 17 20 1 26s775ms 26s775ms [ User: a3dsupervisor - Total duration: 26s775ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 26s775ms - 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-17 18:39:43 Duration: 26s775ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 25s341ms 25s341ms 25s341ms 1 25s341ms 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 17 20 1 25s341ms 25s341ms [ User: a3dsupervisor - Total duration: 25s341ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s341ms - 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-17 18:36:50 Duration: 25s341ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 25s195ms 25s195ms 25s195ms 1 25s195ms 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 17 20 1 25s195ms 25s195ms [ User: a3dsupervisor - Total duration: 25s195ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s195ms - 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-17 18:38:29 Duration: 25s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 21s200ms 21s200ms 21s200ms 1 21s200ms 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 Oct 17 20 1 21s200ms 21s200ms [ User: a3dsupervisor - Total duration: 21s200ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s200ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-17 18:38:15 Duration: 21s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 18s527ms 18s527ms 18s527ms 1 18s527ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 17 20 1 18s527ms 18s527ms [ User: a3dsupervisor - Total duration: 18s527ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s527ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-17 18:38:33 Duration: 18s527ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 17s385ms 17s385ms 17s385ms 1 17s385ms 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 #17
Day Hour Count Duration Avg duration Oct 17 20 1 17s385ms 17s385ms [ User: a3dsupervisor - Total duration: 17s385ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 17s385ms - 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-17 18:38:03 Duration: 17s385ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 15s35ms 15s35ms 15s35ms 1 15s35ms alter table only public.gtp_history_obj_compo;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 17 20 1 15s35ms 15s35ms [ User: a3dsupervisor - Total duration: 15s35ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 15s35ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo;
Date: 2025-10-17 18:40:14 Duration: 15s35ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 14s568ms 14s568ms 14s568ms 1 14s568ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 17 20 1 14s568ms 14s568ms [ User: a3dsupervisor - Total duration: 14s568ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s568ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-17 18:41:52 Duration: 14s568ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5s237ms 8s57ms 6s199ms 9 55s792ms commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 17 08 7 43s574ms 6s224ms 09 1 5s956ms 5s956ms 20 1 6s261ms 6s261ms [ User: a3dsupervisor - Total duration: 55s792ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 49s530ms - Times executed: 8 ]
[ Application: pg_restore - Total duration: 6s261ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-10-17 06:27:24 Duration: 8s57ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-17 06:49:11 Duration: 7s586ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-17 18:39:04 Duration: 6s261ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
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,551 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 1117 ERROR entries
- 14 WARNING entries
Most Frequent Errors/Events
Key values
- 1,070 Max number of times the same event was reported
- 1,132 Total events found
Rank Times reported Error 1 1,070 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 17 02 2 03 1 04 2 21 96 22 369 23 159 00 277 01 164 2 11 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 17 09 5 17 3 19 3 3 8 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 17 13 8 4 6 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 17 13 6 5 3 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 17 20 3 6 2 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 17 13 2 7 2 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 17 20 2 8 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 #8
Day Hour Count Oct 17 20 1 9 1 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 17 13 1 10 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 17 20 1 11 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 17 20 1 12 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 #12
Day Hour Count Oct 17 20 1 13 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 17 13 1 14 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 17 13 1 15 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 #15
Day Hour Count Oct 17 13 1 16 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 17 13 1 17 1 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 17 11 1 18 1 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 17 13 1 19 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 #19
Day Hour Count Oct 17 13 1 20 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 #20
Day Hour Count Oct 17 13 1 21 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #21
Day Hour Count Oct 17 13 1 22 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #22
Day Hour Count Oct 17 13 1 23 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #23
Day Hour Count Oct 17 13 1 24 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 #24
Day Hour Count Oct 17 20 1 25 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #25
Day Hour Count Oct 17 20 1 26 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 #26
Day Hour Count Oct 17 20 1 27 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 #27
Day Hour Count Oct 17 20 1 28 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #28
Day Hour Count Oct 17 20 1 29 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 #29
Day Hour Count Oct 17 13 1 30 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 #30
Day Hour Count Oct 17 13 1 31 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #31
Day Hour Count Oct 17 13 1 32 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #32
Day Hour Count Oct 17 13 1 33 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #33
Day Hour Count Oct 17 20 1 34 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #34
Day Hour Count Oct 17 13 1 35 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 #35
Day Hour Count Oct 17 13 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 17 20 1 37 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 #37
Day Hour Count Oct 17 20 1