pgBadger-
Global information
- Generated on Thu Nov 6 09:14:20 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=05/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=05/h=23/m=00/PT1H.log
- Parsed 5,278 log entries in 52s
- Log start from 2025-11-05 00:15:03 to 2025-11-05 22:45:03
-
Overview
Global Stats
- 70 Number of unique normalized queries
- 69 Number of queries
- 20m20s Total query duration
- 2025-11-05 01:00:25 First query
- 2025-11-05 20:41:58 Last query
- 3 queries/s at 2025-11-05 20:41:18 Query peak
- 20m20s Total query duration
- 0ms Prepare/parse total duration
- 6s148ms Bind total duration
- 20m14s Execute total duration
- 991 Number of events
- 37 Number of unique normalized events
- 921 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
- 189 Number temporary file
- 967.95 MiB Max size of temporary file
- 20.73 MiB Average size of temporary file
- 992 Total number of sessions
- 71 sessions at 2025-11-05 19:50:37 Session peak
- 4d13h9m32s Total duration of sessions
- 6m36s Average duration of sessions
- 0 Average queries per session
- 1s230ms Average queries duration per session
- 6m34s Average idle time per session
- 985 Total number of connections
- 19 connections/s at 2025-11-05 14:44:27 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-05 20:41:18 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-05 11:05:06 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-05 20:41:18 Date
Queries duration
Key values
- 20m20s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 5s98ms 5s98ms 0ms 0ms 5s98ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 5 0ms 6s384ms 5s844ms 0ms 12s741ms 16s481ms 08 2 0ms 6s977ms 6s942ms 0ms 6s908ms 6s977ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 3 0ms 10s371ms 7s515ms 5s110ms 7s65ms 10s371ms 11 6 0ms 3m26s 43s981ms 5s602ms 34s13ms 3m26s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 19 40 0ms 2m50s 19s878ms 2m6s 2m31s 2m50s 20 12 0ms 11s547ms 7s32ms 12s773ms 25s257ms 46s362ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 05 00 0 0 0ms 0ms 0ms 0ms 01 1 0 5s98ms 0ms 0ms 5s98ms 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 1 0 7s65ms 0ms 0ms 7s65ms 11 4 0 5s861ms 0ms 0ms 17s843ms 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) Nov 05 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 1 0 0 5s52ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 1 0 5s110ms 0ms 0ms 0ms 11 0 0 1 0 34s13ms 0ms 0ms 0ms 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 0 0 0ms 0ms 0ms 0ms 19 0 0 0 7 26s985ms 0ms 8s626ms 38s857ms 20 2 0 0 0 8s437ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 05 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 5 5.00 0.00% 08 0 2 2.00 0.00% 09 0 0 0.00 0.00% 10 0 3 3.00 0.00% 11 0 6 6.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 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 12 12.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 05 00 32 0.01/s 01 38 0.01/s 02 49 0.01/s 03 45 0.01/s 04 42 0.01/s 05 34 0.01/s 06 34 0.01/s 07 52 0.01/s 08 38 0.01/s 09 44 0.01/s 10 46 0.01/s 11 44 0.01/s 12 31 0.01/s 13 36 0.01/s 14 79 0.02/s 15 66 0.02/s 16 36 0.01/s 17 21 0.01/s 18 31 0.01/s 19 65 0.02/s 20 31 0.01/s 21 33 0.01/s 22 38 0.01/s 23 20 0.01/s Day Hour Count Average Duration Average idle time Nov 05 00 36 2m28s 2m28s 01 38 3m3s 3m2s 02 49 2m34s 2m34s 03 41 2m28s 2m28s 04 46 2m32s 2m32s 05 34 2m34s 2m34s 06 34 2m51s 2m51s 07 51 2m16s 2m16s 08 39 2m57s 2m57s 09 44 2m55s 2m55s 10 40 2m47s 2m47s 11 43 4m4s 3m57s 12 33 10m57s 10m57s 13 40 3m35s 3m35s 14 71 2m52s 2m52s 15 65 4m6s 4m6s 16 46 19m1s 19m1s 17 21 1m19s 1m19s 18 31 1h29m16s 1h29m16s 19 65 3m13s 3m 20 34 2m2s 2m 21 33 4m3s 4m3s 22 38 2m12s 2m12s 23 20 1m14s 1m14s -
Connections
Established Connections
Key values
- 19 connections Connection Peak
- 2025-11-05 14:44:27 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 985 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 985 connections Total
-
Sessions
Simultaneous sessions
Key values
- 71 sessions Session Peak
- 2025-11-05 19:50:37 Date
Histogram of session times
Key values
- 802 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 992 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 992 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 992 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 992 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 1 1h49m20s 1h49m20s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 1 1h49m20s 1h49m20s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 1 1h49m5s 1h49m5s IntelliJ IDEA 2024.3.5 12 6h56m6s 34m40s PostgreSQL JDBC Driver 893 4d8m49s 6m27s [unknown] 75 10s193ms 135ms pg_restore 4 33m49s 8m27s psql 5 2m50s 34s144ms -
Temporary Files
Size of temporary files
Key values
- 392.82 MiB Temp Files size Peak
- 2025-11-05 19:32:23 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-11-05 19:34:06 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 05 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 3 9.36 MiB 3.12 MiB 11 22 99.47 MiB 4.52 MiB 12 0 0 0 13 1 4.19 MiB 4.19 MiB 14 1 4.19 MiB 4.19 MiB 15 2 8.38 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 160 3.70 GiB 23.71 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 3 848.34 MiB 107.07 MiB 609.69 MiB 282.78 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:30:55 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 3 13.15 MiB 3.36 MiB 5.54 MiB 4.38 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-11-05 19:36:21 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 3 48.67 MiB 3.33 MiB 40.00 MiB 16.22 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-11-05 19:35:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 163.71 MiB 24.84 MiB 103.54 MiB 54.57 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-05 19:35:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 64.41 MiB 4.05 MiB 56.01 MiB 21.47 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2025-11-05 19:36:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 280.03 MiB 51.02 MiB 177.99 MiB 93.34 MiB add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);-
ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 19:34:56 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 152.41 MiB 13.48 MiB 117.31 MiB 50.80 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-11-05 19:35:02 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 170.93 MiB 3.68 MiB 163.10 MiB 56.98 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-11-05 19:33:32 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 394.66 MiB 30.97 MiB 331.88 MiB 131.55 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-05 19:30:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 78.81 MiB 20.52 MiB 30.77 MiB 26.27 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-11-05 19:35:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3 35.84 MiB 10.03 MiB 13.78 MiB 11.95 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-05 19:35:51 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3 15.59 MiB 4.59 MiB 5.82 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-11-05 19:34:46 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2 11.68 MiB 1.97 MiB 9.71 MiB 5.84 MiB add constraint pk_pe_consumption_hourly primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_hourly PRIMARY KEY (consumption_num_id);
Date: 2025-11-05 19:36:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 4.88 MiB 2.09 MiB 2.79 MiB 2.44 MiB add constraint pk_l_notification_user primary key (nous_user_num_id, nous_noti_id);-
ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);
Date: 2025-11-05 19:33:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 94.95 MiB 94.95 MiB 94.95 MiB 94.95 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-05 19:33:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 967.95 MiB 967.95 MiB 967.95 MiB 967.95 MiB add constraint fk_relation_creator foreign key (relation_creator) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_relation_creator FOREIGN KEY (relation_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-05 19:30:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 42.84 MiB 42.84 MiB 42.84 MiB 42.84 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2025-11-05 19:36:04 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 298.35 MiB 298.35 MiB 298.35 MiB 298.35 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-05 19:33:33 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 967.95 MiB ADD CONSTRAINT fk_relation_creator FOREIGN KEY (relation_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-05 19:30:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 609.69 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-05 19:30:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 331.88 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-05 19:30:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 298.35 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-05 19:33:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 177.99 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-05 19:34:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 163.10 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-11-05 19:33:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 131.58 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-05 19:32:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 117.31 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-05 19:35:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 107.07 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-05 19:32:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 103.54 MiB ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-11-05 19:35:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 94.95 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-11-05 19:33:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 56.01 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-11-05 19:36:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 51.02 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-05 19:34:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 51.02 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-05 19:34:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 42.84 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-11-05 19:36:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 40.00 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-05 19:35:58 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 35.34 MiB ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-11-05 19:35:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 31.80 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-05 19:31:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 30.97 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-05 19:31:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 30.77 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2025-11-05 19:35:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 05 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
- 6 Total read queries
- 60 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 69 Requests
- 20m14s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 69 Requests
User Request type Count Duration a3dsupervisor Total 69 20m14s copy from 7 3m8s ddl 32 7m15s delete 2 39s124ms insert 2 16s874ms others 3 6m27s select 6 35s610ms tcl 16 1m45s update 1 5s52ms Duration by user
Key values
- 20m14s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 69 20m14s copy from 7 3m8s ddl 32 7m15s delete 2 39s124ms insert 2 16s874ms others 3 6m27s select 6 35s610ms tcl 16 1m45s update 1 5s52ms Queries by host
Key values
- 10.3.0.4 Main host
- 69 Requests
- 20m14s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 39 Requests
- 10m24s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-05 21:00:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 41 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m26s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-05 11:03:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 2m50s VACUUM ANALYSE;[ Date: 2025-11-05 19:49:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m5s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-11-05 19:30:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 38s857ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;[ Date: 2025-11-05 19:33:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 34s149ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;[ Date: 2025-11-05 19:29:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 34s13ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-05 11:08:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 31s573ms ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-05 19:32:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 30s252ms CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2025-11-05 19:34:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 27s902ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-11-05 19:30:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 24s825ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);[ Date: 2025-11-05 19:30:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 24s130ms CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-05 19:31:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 23s299ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;[ Date: 2025-11-05 19:32:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 21s983ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-05 19:34:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 19s439ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-11-05 19:30:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 18s453ms CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);[ Date: 2025-11-05 19:31:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 18s404ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);[ Date: 2025-11-05 19:33:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 16s856ms 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-11-05 19:31:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 14s839ms ALTER TABLE ONLY public.gtp_monthly_history;[ Date: 2025-11-05 19:34:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 14s339ms ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-05 19:31:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 14s167ms CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);[ Date: 2025-11-05 19:31:30 - 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 3m26s 1 3m26s 3m26s 3m26s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 05 12 1 3m26s 3m26s [ User: a3dsupervisor - Total duration: 3m26s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m26s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-05 11:03:21 Duration: 3m26s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m50s 1 2m50s 2m50s 2m50s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 05 20 1 2m50s 2m50s [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 1 ]
[ Application: psql - Total duration: 2m50s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 19:49:15 Duration: 2m50s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m45s 16 5s214ms 11s547ms 6s598ms commit;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 05 08 4 24s170ms 6s42ms 09 2 13s885ms 6s942ms 21 10 1m7s 6s751ms [ User: a3dsupervisor - Total duration: 1m45s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m45s - Times executed: 16 ]
-
COMMIT;
Date: 2025-11-05 20:41:58 Duration: 11s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-05 20:40:50 Duration: 7s680ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-05 08:06:38 Duration: 6s977ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1m5s 1 1m5s 1m5s 1m5s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 05 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-05 19:30:25 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 39s124ms 2 5s110ms 34s13ms 19s562ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 05 11 1 5s110ms 5s110ms 12 1 34s13ms 34s13ms [ User: a3dsupervisor - Total duration: 39s124ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s124ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-05 11:08:38 Duration: 34s13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-05 10:06:03 Duration: 5s110ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 38s857ms 1 38s857ms 38s857ms 38s857ms 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 Nov 05 20 1 38s857ms 38s857ms [ User: a3dsupervisor - Total duration: 38s857ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s857ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-05 19:33:05 Duration: 38s857ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 34s149ms 1 34s149ms 34s149ms 34s149ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 05 20 1 34s149ms 34s149ms [ User: a3dsupervisor - Total duration: 34s149ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s149ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-05 19:29:53 Duration: 34s149ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 31s573ms 1 31s573ms 31s573ms 31s573ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 05 20 1 31s573ms 31s573ms [ User: a3dsupervisor - Total duration: 31s573ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s573ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:32:23 Duration: 31s573ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 30s252ms 1 30s252ms 30s252ms 30s252ms 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 #9
Day Hour Count Duration Avg duration Nov 05 20 1 30s252ms 30s252ms [ User: a3dsupervisor - Total duration: 30s252ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s252ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 19:34:36 Duration: 30s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 27s902ms 1 27s902ms 27s902ms 27s902ms 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 Nov 05 20 1 27s902ms 27s902ms [ User: a3dsupervisor - Total duration: 27s902ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s902ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-05 19:30:55 Duration: 27s902ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 24s825ms 1 24s825ms 24s825ms 24s825ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 05 20 1 24s825ms 24s825ms [ User: a3dsupervisor - Total duration: 24s825ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s825ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-05 19:30:19 Duration: 24s825ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 24s130ms 1 24s130ms 24s130ms 24s130ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 05 20 1 24s130ms 24s130ms [ User: a3dsupervisor - Total duration: 24s130ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s130ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:31:33 Duration: 24s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 23s299ms 1 23s299ms 23s299ms 23s299ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 05 20 1 23s299ms 23s299ms [ User: a3dsupervisor - Total duration: 23s299ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s299ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-05 19:32:47 Duration: 23s299ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 21s983ms 1 21s983ms 21s983ms 21s983ms 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 #14
Day Hour Count Duration Avg duration Nov 05 20 1 21s983ms 21s983ms [ User: a3dsupervisor - Total duration: 21s983ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s983ms - 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-11-05 19:34:43 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 19s439ms 1 19s439ms 19s439ms 19s439ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 05 20 1 19s439ms 19s439ms [ User: a3dsupervisor - Total duration: 19s439ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 19s439ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-05 19:30:44 Duration: 19s439ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 18s453ms 1 18s453ms 18s453ms 18s453ms create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 05 20 1 18s453ms 18s453ms [ User: a3dsupervisor - Total duration: 18s453ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s453ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-05 19:31:52 Duration: 18s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 18s404ms 1 18s404ms 18s404ms 18s404ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 05 20 1 18s404ms 18s404ms [ User: a3dsupervisor - Total duration: 18s404ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s404ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-11-05 19:33:06 Duration: 18s404ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 16s874ms 2 8s436ms 8s437ms 8s437ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 05 21 2 16s874ms 8s437ms [ User: a3dsupervisor - Total duration: 16s874ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s874ms - Times executed: 2 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s437ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s436ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 16s856ms 1 16s856ms 16s856ms 16s856ms 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 #19
Day Hour Count Duration Avg duration Nov 05 20 1 16s856ms 16s856ms [ User: a3dsupervisor - Total duration: 16s856ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s856ms - 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-11-05 19:31:47 Duration: 16s856ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 14s839ms 1 14s839ms 14s839ms 14s839ms alter table only public.gtp_monthly_history;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 05 20 1 14s839ms 14s839ms [ User: a3dsupervisor - Total duration: 14s839ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s839ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history;
Date: 2025-11-05 19:34:21 Duration: 14s839ms 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 16 1m45s 5s214ms 11s547ms 6s598ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 05 08 4 24s170ms 6s42ms 09 2 13s885ms 6s942ms 21 10 1m7s 6s751ms [ User: a3dsupervisor - Total duration: 1m45s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m45s - Times executed: 16 ]
-
COMMIT;
Date: 2025-11-05 20:41:58 Duration: 11s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-05 20:40:50 Duration: 7s680ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-05 08:06:38 Duration: 6s977ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2 39s124ms 5s110ms 34s13ms 19s562ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 05 11 1 5s110ms 5s110ms 12 1 34s13ms 34s13ms [ User: a3dsupervisor - Total duration: 39s124ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s124ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-05 11:08:38 Duration: 34s13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-05 10:06:03 Duration: 5s110ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2 16s874ms 8s436ms 8s437ms 8s437ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 05 21 2 16s874ms 8s437ms [ User: a3dsupervisor - Total duration: 16s874ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s874ms - Times executed: 2 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s437ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s436ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 3m26s 3m26s 3m26s 3m26s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 05 12 1 3m26s 3m26s [ User: a3dsupervisor - Total duration: 3m26s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m26s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-05 11:03:21 Duration: 3m26s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1 2m50s 2m50s 2m50s 2m50s vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 05 20 1 2m50s 2m50s [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 1 ]
[ Application: psql - Total duration: 2m50s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 19:49:15 Duration: 2m50s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1 1m5s 1m5s 1m5s 1m5s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 05 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-05 19:30:25 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1 38s857ms 38s857ms 38s857ms 38s857ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 05 20 1 38s857ms 38s857ms [ User: a3dsupervisor - Total duration: 38s857ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s857ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-05 19:33:05 Duration: 38s857ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 34s149ms 34s149ms 34s149ms 34s149ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 05 20 1 34s149ms 34s149ms [ User: a3dsupervisor - Total duration: 34s149ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s149ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-05 19:29:53 Duration: 34s149ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 31s573ms 31s573ms 31s573ms 31s573ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 05 20 1 31s573ms 31s573ms [ User: a3dsupervisor - Total duration: 31s573ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s573ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:32:23 Duration: 31s573ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 30s252ms 30s252ms 30s252ms 30s252ms 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 #10
Day Hour Count Duration Avg duration Nov 05 20 1 30s252ms 30s252ms [ User: a3dsupervisor - Total duration: 30s252ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s252ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 19:34:36 Duration: 30s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 27s902ms 27s902ms 27s902ms 27s902ms 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 Nov 05 20 1 27s902ms 27s902ms [ User: a3dsupervisor - Total duration: 27s902ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s902ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-05 19:30:55 Duration: 27s902ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 24s825ms 24s825ms 24s825ms 24s825ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 05 20 1 24s825ms 24s825ms [ User: a3dsupervisor - Total duration: 24s825ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s825ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-05 19:30:19 Duration: 24s825ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 24s130ms 24s130ms 24s130ms 24s130ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 05 20 1 24s130ms 24s130ms [ User: a3dsupervisor - Total duration: 24s130ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s130ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:31:33 Duration: 24s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 23s299ms 23s299ms 23s299ms 23s299ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 05 20 1 23s299ms 23s299ms [ User: a3dsupervisor - Total duration: 23s299ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s299ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-05 19:32:47 Duration: 23s299ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 21s983ms 21s983ms 21s983ms 21s983ms 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 #15
Day Hour Count Duration Avg duration Nov 05 20 1 21s983ms 21s983ms [ User: a3dsupervisor - Total duration: 21s983ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s983ms - 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-11-05 19:34:43 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 19s439ms 19s439ms 19s439ms 19s439ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 05 20 1 19s439ms 19s439ms [ User: a3dsupervisor - Total duration: 19s439ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 19s439ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-05 19:30:44 Duration: 19s439ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 18s453ms 18s453ms 18s453ms 18s453ms create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 05 20 1 18s453ms 18s453ms [ User: a3dsupervisor - Total duration: 18s453ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s453ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-05 19:31:52 Duration: 18s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 18s404ms 18s404ms 18s404ms 18s404ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 05 20 1 18s404ms 18s404ms [ User: a3dsupervisor - Total duration: 18s404ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s404ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-11-05 19:33:06 Duration: 18s404ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 16s856ms 16s856ms 16s856ms 16s856ms 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 #19
Day Hour Count Duration Avg duration Nov 05 20 1 16s856ms 16s856ms [ User: a3dsupervisor - Total duration: 16s856ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s856ms - 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-11-05 19:31:47 Duration: 16s856ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 14s839ms 14s839ms 14s839ms 14s839ms alter table only public.gtp_monthly_history;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 05 20 1 14s839ms 14s839ms [ User: a3dsupervisor - Total duration: 14s839ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s839ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history;
Date: 2025-11-05 19:34:21 Duration: 14s839ms 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 3m26s 3m26s 3m26s 1 3m26s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 05 12 1 3m26s 3m26s [ User: a3dsupervisor - Total duration: 3m26s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m26s - Times executed: 1 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-05 11:03:21 Duration: 3m26s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2m50s 2m50s 2m50s 1 2m50s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 05 20 1 2m50s 2m50s [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 1 ]
[ Application: psql - Total duration: 2m50s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 19:49:15 Duration: 2m50s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m5s 1m5s 1m5s 1 1m5s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 05 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m5s - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-05 19:30:25 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 38s857ms 38s857ms 38s857ms 1 38s857ms 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 #4
Day Hour Count Duration Avg duration Nov 05 20 1 38s857ms 38s857ms [ User: a3dsupervisor - Total duration: 38s857ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s857ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-05 19:33:05 Duration: 38s857ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 34s149ms 34s149ms 34s149ms 1 34s149ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 05 20 1 34s149ms 34s149ms [ User: a3dsupervisor - Total duration: 34s149ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s149ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-05 19:29:53 Duration: 34s149ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 31s573ms 31s573ms 31s573ms 1 31s573ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 05 20 1 31s573ms 31s573ms [ User: a3dsupervisor - Total duration: 31s573ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s573ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:32:23 Duration: 31s573ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 30s252ms 30s252ms 30s252ms 1 30s252ms 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 #7
Day Hour Count Duration Avg duration Nov 05 20 1 30s252ms 30s252ms [ User: a3dsupervisor - Total duration: 30s252ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 30s252ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 19:34:36 Duration: 30s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 27s902ms 27s902ms 27s902ms 1 27s902ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 05 20 1 27s902ms 27s902ms [ User: a3dsupervisor - Total duration: 27s902ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 27s902ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-05 19:30:55 Duration: 27s902ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 24s825ms 24s825ms 24s825ms 1 24s825ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 05 20 1 24s825ms 24s825ms [ User: a3dsupervisor - Total duration: 24s825ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s825ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-05 19:30:19 Duration: 24s825ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 24s130ms 24s130ms 24s130ms 1 24s130ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 05 20 1 24s130ms 24s130ms [ User: a3dsupervisor - Total duration: 24s130ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s130ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:31:33 Duration: 24s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 23s299ms 23s299ms 23s299ms 1 23s299ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 05 20 1 23s299ms 23s299ms [ User: a3dsupervisor - Total duration: 23s299ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s299ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-05 19:32:47 Duration: 23s299ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 21s983ms 21s983ms 21s983ms 1 21s983ms 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 #12
Day Hour Count Duration Avg duration Nov 05 20 1 21s983ms 21s983ms [ User: a3dsupervisor - Total duration: 21s983ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 21s983ms - 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-11-05 19:34:43 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5s110ms 34s13ms 19s562ms 2 39s124ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 05 11 1 5s110ms 5s110ms 12 1 34s13ms 34s13ms [ User: a3dsupervisor - Total duration: 39s124ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s124ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-05 11:08:38 Duration: 34s13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-05 10:06:03 Duration: 5s110ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 19s439ms 19s439ms 19s439ms 1 19s439ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 05 20 1 19s439ms 19s439ms [ User: a3dsupervisor - Total duration: 19s439ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 19s439ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-05 19:30:44 Duration: 19s439ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 18s453ms 18s453ms 18s453ms 1 18s453ms create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 05 20 1 18s453ms 18s453ms [ User: a3dsupervisor - Total duration: 18s453ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s453ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-05 19:31:52 Duration: 18s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 18s404ms 18s404ms 18s404ms 1 18s404ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 05 20 1 18s404ms 18s404ms [ User: a3dsupervisor - Total duration: 18s404ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 18s404ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-11-05 19:33:06 Duration: 18s404ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 16s856ms 16s856ms 16s856ms 1 16s856ms 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 Nov 05 20 1 16s856ms 16s856ms [ User: a3dsupervisor - Total duration: 16s856ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 16s856ms - 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-11-05 19:31:47 Duration: 16s856ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 14s839ms 14s839ms 14s839ms 1 14s839ms alter table only public.gtp_monthly_history;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 05 20 1 14s839ms 14s839ms [ User: a3dsupervisor - Total duration: 14s839ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 14s839ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history;
Date: 2025-11-05 19:34:21 Duration: 14s839ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 8s436ms 8s437ms 8s437ms 2 16s874ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 05 21 2 16s874ms 8s437ms [ User: a3dsupervisor - Total duration: 16s874ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s874ms - Times executed: 2 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s437ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s436ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s214ms 11s547ms 6s598ms 16 1m45s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 05 08 4 24s170ms 6s42ms 09 2 13s885ms 6s942ms 21 10 1m7s 6s751ms [ User: a3dsupervisor - Total duration: 1m45s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m45s - Times executed: 16 ]
-
COMMIT;
Date: 2025-11-05 20:41:58 Duration: 11s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-05 20:40:50 Duration: 7s680ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-05 08:06:38 Duration: 6s977ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 4,218 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 977 ERROR entries
- 14 WARNING entries
Most Frequent Errors/Events
Key values
- 921 Max number of times the same event was reported
- 991 Total events found
Rank Times reported Error 1 921 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 05 01 30 02 9 21 420 22 100 23 295 00 67 2 22 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 05 13 2 14 2 16 10 17 5 19 3 3 8 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 05 12 8 4 6 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 05 12 6 5 2 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 05 12 2 6 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 05 12 1 7 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_relation
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 05 20 1 8 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 05 20 1 9 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 #9
Day Hour Count Nov 05 12 1 10 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msinsert into BATCH_GROUP (...) values (...)
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 05 11 1 11 1 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 05 12 1 12 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_TIME_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 05 12 1 13 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 #13
Day Hour Count Nov 05 20 1 14 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 #14
Day Hour Count Nov 05 12 1 15 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 05 12 1 16 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (...)
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 05 20 1 17 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 05 12 1 18 1 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 05 12 1 19 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 #19
Day Hour Count Nov 05 20 1 20 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 #20
Day Hour Count Nov 05 12 1 21 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 #21
Day Hour Count Nov 05 20 1 22 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 #22
Day Hour Count Nov 05 20 1 23 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 05 12 1 24 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 #24
Day Hour Count Nov 05 20 1 25 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #25
Day Hour Count Nov 05 12 1 26 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #26
Day Hour Count Nov 05 20 1 27 1 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #27
Day Hour Count Nov 05 12 1 28 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 #28
Day Hour Count Nov 05 12 1 29 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 #29
Day Hour Count Nov 05 12 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 Nov 05 20 1 31 1 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #31
Day Hour Count Nov 05 12 1 32 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #32
Day Hour Count Nov 05 20 1 33 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 #33
Day Hour Count Nov 05 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 Nov 05 12 1 35 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #35
Day Hour Count Nov 05 20 1 36 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #36
Day Hour Count Nov 05 12 1 37 1 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #37
Day Hour Count Nov 05 12 1