pgBadger-
Global information
- Generated on Wed Nov 19 09:09:12 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=18/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=18/h=23/m=00/PT1H.log
- Parsed 160,201 log entries in 55s
- Log start from 2025-11-18 00:04:05 to 2025-11-18 23:59:58
-
Overview
Global Stats
- 58 Number of unique normalized queries
- 51 Number of queries
- 45m41s Total query duration
- 2025-11-18 07:59:36 First query
- 2025-11-18 20:49:53 Last query
- 3 queries/s at 2025-11-18 20:49:53 Query peak
- 45m41s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 45m41s Execute total duration
- 78,186 Number of events
- 18 Number of unique normalized events
- 78,161 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
- 162 Number temporary file
- 1.17 GiB Max size of temporary file
- 36.61 MiB Average size of temporary file
- 1,184 Total number of sessions
- 39 sessions at 2025-11-18 12:56:24 Session peak
- 2d19h52m16s Total duration of sessions
- 3m26s Average duration of sessions
- 0 Average queries per session
- 2s315ms Average queries duration per session
- 3m24s Average idle time per session
- 1,183 Total number of connections
- 11 connections/s at 2025-11-18 09:05:58 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-18 20:49:53 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-18 08:45:35 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-18 20:49:53 Date
Queries duration
Key values
- 45m41s 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 18 00 0 0ms 0ms 0ms 0ms 0ms 0ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 07 2 0ms 1m39s 1m37s 0ms 0ms 3m14s 08 38 0ms 2m20s 40s709ms 2m26s 3m14s 4m9s 09 1 0ms 15m36s 15m36s 0ms 0ms 15m36s 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 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 1 0ms 6s231ms 6s231ms 0ms 0ms 6s231ms 20 9 0ms 8s53ms 6s401ms 0ms 5s91ms 39s58ms 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 18 00 0 0 0ms 0ms 0ms 0ms 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 2 0 8s100ms 0ms 0ms 16s201ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 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 18 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 2 1m37s 0ms 0ms 0ms 08 0 0 0 5 37s806ms 0ms 0ms 46s113ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 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 0 0ms 0ms 0ms 0ms 20 0 0 1 0 5s413ms 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 18 00 0 0 0.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 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 2 2.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 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 1 1.00 0.00% 20 0 9 9.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 18 00 35 0.01/s 01 38 0.01/s 02 33 0.01/s 03 44 0.01/s 04 39 0.01/s 05 50 0.01/s 06 45 0.01/s 07 19 0.01/s 08 18 0.01/s 09 100 0.03/s 10 68 0.02/s 11 47 0.01/s 12 43 0.01/s 13 87 0.02/s 14 70 0.02/s 15 69 0.02/s 16 44 0.01/s 17 60 0.02/s 18 28 0.01/s 19 49 0.01/s 20 49 0.01/s 21 47 0.01/s 22 51 0.01/s 23 50 0.01/s Day Hour Count Average Duration Average idle time Nov 18 00 33 1m17s 1m17s 01 40 1m26s 1m26s 02 33 1m18s 1m18s 03 42 1m18s 1m18s 04 41 1m18s 1m18s 05 50 1m15s 1m15s 06 44 1m21s 1m21s 07 21 1h15m3s 1h14m53s 08 19 5m28s 4m6s 09 99 51s691ms 42s232ms 10 68 51s477ms 51s477ms 11 47 1m19s 1m19s 12 43 1m18s 1m18s 13 87 6m42s 6m42s 14 70 47s644ms 47s644ms 15 69 49s474ms 49s474ms 16 44 1m18s 1m18s 17 60 1m17s 1m17s 18 28 20m59s 20m59s 19 48 1m31s 1m31s 20 50 1m26s 1m25s 21 47 1m15s 1m15s 22 51 1m16s 1m16s 23 50 1m18s 1m18s -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-11-18 09:05:58 Date
Connections per database
Key values
- cnrs Main Database
- 1,183 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,183 connections Total
-
Sessions
Simultaneous sessions
Key values
- 39 sessions Session Peak
- 2025-11-18 12:56:24 Date
Histogram of session times
Key values
- 915 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 1,184 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,184 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,184 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 714.08 MiB Temp Files size Peak
- 2025-11-18 08:04:55 Date
Number of temporary files
Key values
- 5 per second Temp Files Peak
- 2025-11-18 08:15:16 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 18 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 161 5.79 GiB 36.81 MiB 09 1 3.66 MiB 3.66 MiB 10 0 0 0 11 0 0 0 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 0 0 0 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 3 552.09 MiB 14.09 MiB 523.58 MiB 184.03 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-18 08:10:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 3 19.84 MiB 2.38 MiB 13.34 MiB 6.61 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-18 08:06:04 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 3 159.00 MiB 50.21 MiB 55.04 MiB 53.00 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-18 08:12:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 714.08 MiB 225.68 MiB 255.82 MiB 238.03 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-18 08:04:55 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 1.05 GiB 142.11 MiB 791.85 MiB 359.48 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-18 08:08:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 149.71 MiB 27.32 MiB 82.08 MiB 49.90 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-18 08:05:42 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 52.53 MiB 15.93 MiB 20.63 MiB 17.51 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-18 08:05:55 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 248.49 MiB 10.02 MiB 211.45 MiB 82.83 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-18 08:14:39 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 567.84 MiB 41.96 MiB 478.79 MiB 189.28 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-18 08:07:12 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3 1.34 GiB 74.64 MiB 1.17 GiB 457.76 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-18 08:01:21 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2 8.88 MiB 2.18 MiB 6.70 MiB 4.44 MiB add constraint pk_history_obj_old_qsp primary key (history_old_qsp_id);-
ADD CONSTRAINT pk_history_obj_old_qsp PRIMARY KEY (history_old_qsp_id);
Date: 2025-11-18 08:15:13 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 2 27.53 MiB 3.09 MiB 24.45 MiB 13.77 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-18 08:05:22 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 2.34 MiB 2.34 MiB 2.34 MiB 2.34 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-18 08:06:05 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 29.95 MiB 29.95 MiB 29.95 MiB 29.95 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-18 08:05:26 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 45.44 MiB 45.44 MiB 45.44 MiB 45.44 MiB add constraint fk_gtp_month_history_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:15:16 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 860.57 MiB 860.57 MiB 860.57 MiB 860.57 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-18 08:01:34 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.17 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-18 08:01:21 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 860.57 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-11-18 08:01:34 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 791.85 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-18 08:08:51 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 523.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-18 08:10:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 478.79 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-18 08:07:12 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 255.82 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-18 08:04:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 232.58 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-18 08:04:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 225.68 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-18 08:04:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 211.45 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-18 08:14:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 144.49 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-18 08:10:17 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 142.11 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-18 08:10:17 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 100.61 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-18 08:03:14 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 82.08 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-18 08:05:42 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 74.64 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-18 08:03:14 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 55.04 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-18 08:12:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 53.75 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-18 08:12:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 50.21 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-18 08:12:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 47.09 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-18 08:08:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 45.44 MiB ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-18 08:15:16 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 41.96 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-18 08:08:00 - Database: cnrs - 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 18 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
- ExclusiveLock Main Lock Type
- 11 locks Total
Type Object Count Total Duration Average Duration (s) AccessShareLock 2 4s614ms 2s307ms relation 2 4s614ms 2s307ms ExclusiveLock 4 6s78ms 1s519ms extension 4 6s78ms 1s519ms RowExclusiveLock 1 1s832ms 1s832ms relation 1 1s832ms 1s832ms ShareRowExclusiveLock 3 7s544ms 2s514ms relation 3 7s544ms 2s514ms ShareUpdateExclusiveLock 1 1s3ms 1s3ms relation 1 1s3ms 1s3ms Total 11 21s73ms 1s915ms 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
- 2 Total read queries
- 48 Total write queries
Queries by database
Key values
- cnrs Main database
- 51 Requests
- 45m41s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 51 Requests
User Request type Count Duration a3dsupervisor Total 51 45m41s copy from 7 6m23s ddl 31 22m21s delete 1 5s413ms others 1 15m36s select 2 16s201ms tcl 9 58s434ms Duration by user
Key values
- 45m41s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 51 45m41s copy from 7 6m23s ddl 31 22m21s delete 1 5s413ms others 1 15m36s select 2 16s201ms tcl 9 58s434ms Queries by host
Key values
- 10.3.0.4 Main host
- 51 Requests
- 45m41s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 38 Requests
- 28m45s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-18 04:28:43 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 36 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 15m36s VACUUM ANALYSE;[ Date: 2025-11-18 09:05:31 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 2m20s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-18 08:07:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1m56s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-11-18 08:01:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1m45s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-18 08:01:21 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 1m40s 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-18 08:04:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 1m39s COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;[ Date: 2025-11-18 07:59:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 1m34s 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-18 07:59:36 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 1m33s ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-18 08:14:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 1m32s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-18 08:10:54 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 1m4s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-18 08:08:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 1m1s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-18 08:09:22 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 1m1s COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;[ Date: 2025-11-18 08:03:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 56s354ms ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-18 08:10:17 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 50s341ms CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);[ Date: 2025-11-18 08:08:52 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 46s113ms 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-11-18 08:04:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 45s617ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-18 08:16:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 37s127ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);[ Date: 2025-11-18 08:11:32 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 36s585ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-18 08:03:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 36s36ms 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-18 08:06:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 31s790ms ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-18 08:12:35 - Database: cnrs - 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 15m36s 1 15m36s 15m36s 15m36s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 18 10 1 15m36s 15m36s [ User: a3dsupervisor - Total duration: 15m36s - Times executed: 1 ]
[ Application: psql - Total duration: 15m36s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-18 09:05:31 Duration: 15m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m20s 1 2m20s 2m20s 2m20s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att_cat foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 18 09 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:07:15 Duration: 2m20s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1m56s 1 1m56s 1m56s 1m56s create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 18 09 1 1m56s 1m56s [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m56s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-11-18 08:01:37 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m45s 1 1m45s 1m45s 1m45s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 18 09 1 1m45s 1m45s [ User: a3dsupervisor - Total duration: 1m45s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m45s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-18 08:01:21 Duration: 1m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m40s 1 1m40s 1m40s 1m40s 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 #5
Day Hour Count Duration Avg duration Nov 18 09 1 1m40s 1m40s [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m40s - 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-18 08:04:55 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m39s 1 1m39s 1m39s 1m39s copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 08 1 1m39s 1m39s [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-11-18 07:59:40 Duration: 1m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m34s 1 1m34s 1m34s 1m34s 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 18 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m34s - 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-18 07:59:36 Duration: 1m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m33s 1 1m33s 1m33s 1m33s alter table only public.gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 09 1 1m33s 1m33s [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m33s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:14:08 Duration: 1m33s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m32s 1 1m32s 1m32s 1m32s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 18 09 1 1m32s 1m32s [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m32s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:10:54 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1m4s 1 1m4s 1m4s 1m4s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 09 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m4s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:08:20 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1m1s 1 1m1s 1m1s 1m1s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:09:22 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1m1s 1 1m1s 1m1s 1m1s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-18 08:03:33 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 58s434ms 9 5s91ms 8s53ms 6s492ms commit;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 20 1 6s231ms 6s231ms 21 8 52s203ms 6s525ms [ User: a3dsupervisor - Total duration: 58s434ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 58s434ms - Times executed: 9 ]
-
COMMIT;
Date: 2025-11-18 20:48:01 Duration: 8s53ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 20:49:21 Duration: 7s149ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 20:49:53 Duration: 6s962ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 56s354ms 1 56s354ms 56s354ms 56s354ms alter table only public.ged_right_user add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 09 1 56s354ms 56s354ms [ User: a3dsupervisor - Total duration: 56s354ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 56s354ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-11-18 08:10:17 Duration: 56s354ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 50s341ms 1 50s341ms 50s341ms 50s341ms create index i_fk_ged_right_user_ged_node on public.ged_right_user using btree (project_num_id, node_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 09 1 50s341ms 50s341ms [ User: a3dsupervisor - Total duration: 50s341ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 50s341ms - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-11-18 08:08:52 Duration: 50s341ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 46s113ms 1 46s113ms 46s113ms 46s113ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 09 1 46s113ms 46s113ms [ User: a3dsupervisor - Total duration: 46s113ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 46s113ms - 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-11-18 08:04:20 Duration: 46s113ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 45s617ms 1 45s617ms 45s617ms 45s617ms alter table only public.gtp_monthly_history add constraint fk_gtp_month_history_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 18 09 1 45s617ms 45s617ms [ User: a3dsupervisor - Total duration: 45s617ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 45s617ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:16:08 Duration: 45s617ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 37s127ms 1 37s127ms 37s127ms 37s127ms alter table only public.gtp_monthly_history add constraint fk_gtp_monthly_history_tab_id foreign key (histo_num_id_tab) references public.gtp_monthly_history (histo_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 09 1 37s127ms 37s127ms [ User: a3dsupervisor - Total duration: 37s127ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s127ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-11-18 08:11:32 Duration: 37s127ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 36s585ms 1 36s585ms 36s585ms 36s585ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 09 1 36s585ms 36s585ms [ User: a3dsupervisor - Total duration: 36s585ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s585ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-18 08:03:15 Duration: 36s585ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 36s36ms 1 36s36ms 36s36ms 36s36ms 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 #20
Day Hour Count Duration Avg duration Nov 18 09 1 36s36ms 36s36ms [ User: a3dsupervisor - Total duration: 36s36ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s36ms - 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-18 08:06:48 Duration: 36s36ms Database: cnrs 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 58s434ms 5s91ms 8s53ms 6s492ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 18 20 1 6s231ms 6s231ms 21 8 52s203ms 6s525ms [ User: a3dsupervisor - Total duration: 58s434ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 58s434ms - Times executed: 9 ]
-
COMMIT;
Date: 2025-11-18 20:48:01 Duration: 8s53ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 20:49:21 Duration: 7s149ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-18 20:49:53 Duration: 6s962ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 2 16s201ms 8s99ms 8s101ms 8s100ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 18 09 2 16s201ms 8s100ms [ User: a3dsupervisor - Total duration: 16s201ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 16s201ms - Times executed: 2 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 08:45:35 Duration: 8s101ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 08:45:35 Duration: 8s99ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
3 1 15m36s 15m36s 15m36s 15m36s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 18 10 1 15m36s 15m36s [ User: a3dsupervisor - Total duration: 15m36s - Times executed: 1 ]
[ Application: psql - Total duration: 15m36s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-18 09:05:31 Duration: 15m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1 2m20s 2m20s 2m20s 2m20s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att_cat foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 18 09 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:07:15 Duration: 2m20s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1 1m56s 1m56s 1m56s 1m56s create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 18 09 1 1m56s 1m56s [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m56s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-11-18 08:01:37 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1 1m45s 1m45s 1m45s 1m45s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 09 1 1m45s 1m45s [ User: a3dsupervisor - Total duration: 1m45s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m45s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-18 08:01:21 Duration: 1m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1 1m40s 1m40s 1m40s 1m40s 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 #7
Day Hour Count Duration Avg duration Nov 18 09 1 1m40s 1m40s [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m40s - 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-18 08:04:55 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 1m39s 1m39s 1m39s 1m39s copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 08 1 1m39s 1m39s [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-11-18 07:59:40 Duration: 1m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 1m34s 1m34s 1m34s 1m34s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 18 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m34s - 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-18 07:59:36 Duration: 1m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 1m33s 1m33s 1m33s 1m33s alter table only public.gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 09 1 1m33s 1m33s [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m33s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:14:08 Duration: 1m33s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 1m32s 1m32s 1m32s 1m32s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 09 1 1m32s 1m32s [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m32s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:10:54 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 1m4s 1m4s 1m4s 1m4s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 09 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m4s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:08:20 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 1m1s 1m1s 1m1s 1m1s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:09:22 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 1m1s 1m1s 1m1s 1m1s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-18 08:03:33 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 56s354ms 56s354ms 56s354ms 56s354ms alter table only public.ged_right_user add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 09 1 56s354ms 56s354ms [ User: a3dsupervisor - Total duration: 56s354ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 56s354ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-11-18 08:10:17 Duration: 56s354ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 50s341ms 50s341ms 50s341ms 50s341ms create index i_fk_ged_right_user_ged_node on public.ged_right_user using btree (project_num_id, node_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 09 1 50s341ms 50s341ms [ User: a3dsupervisor - Total duration: 50s341ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 50s341ms - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-11-18 08:08:52 Duration: 50s341ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 46s113ms 46s113ms 46s113ms 46s113ms 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 Nov 18 09 1 46s113ms 46s113ms [ User: a3dsupervisor - Total duration: 46s113ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 46s113ms - 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-11-18 08:04:20 Duration: 46s113ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 45s617ms 45s617ms 45s617ms 45s617ms alter table only public.gtp_monthly_history add constraint fk_gtp_month_history_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 09 1 45s617ms 45s617ms [ User: a3dsupervisor - Total duration: 45s617ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 45s617ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:16:08 Duration: 45s617ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 37s127ms 37s127ms 37s127ms 37s127ms alter table only public.gtp_monthly_history add constraint fk_gtp_monthly_history_tab_id foreign key (histo_num_id_tab) references public.gtp_monthly_history (histo_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 18 09 1 37s127ms 37s127ms [ User: a3dsupervisor - Total duration: 37s127ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s127ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-11-18 08:11:32 Duration: 37s127ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 36s585ms 36s585ms 36s585ms 36s585ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 18 09 1 36s585ms 36s585ms [ User: a3dsupervisor - Total duration: 36s585ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s585ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-18 08:03:15 Duration: 36s585ms Database: cnrs 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 15m36s 15m36s 15m36s 1 15m36s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 18 10 1 15m36s 15m36s [ User: a3dsupervisor - Total duration: 15m36s - Times executed: 1 ]
[ Application: psql - Total duration: 15m36s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-11-18 09:05:31 Duration: 15m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m20s 2m20s 2m20s 1 2m20s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att_cat foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 18 09 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:07:15 Duration: 2m20s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1m56s 1m56s 1m56s 1 1m56s create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 18 09 1 1m56s 1m56s [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m56s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-11-18 08:01:37 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m45s 1m45s 1m45s 1 1m45s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 18 09 1 1m45s 1m45s [ User: a3dsupervisor - Total duration: 1m45s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m45s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-18 08:01:21 Duration: 1m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m40s 1m40s 1m40s 1 1m40s 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 #5
Day Hour Count Duration Avg duration Nov 18 09 1 1m40s 1m40s [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m40s - 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-18 08:04:55 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m39s 1m39s 1m39s 1 1m39s copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 18 08 1 1m39s 1m39s [ User: a3dsupervisor - Total duration: 1m39s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m39s - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-11-18 07:59:40 Duration: 1m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m34s 1m34s 1m34s 1 1m34s 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 18 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m34s - 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-18 07:59:36 Duration: 1m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m33s 1m33s 1m33s 1 1m33s alter table only public.gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 18 09 1 1m33s 1m33s [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m33s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:14:08 Duration: 1m33s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m32s 1m32s 1m32s 1 1m32s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 18 09 1 1m32s 1m32s [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m32s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:10:54 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1m4s 1m4s 1m4s 1 1m4s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 18 09 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m4s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:08:20 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1m1s 1m1s 1m1s 1 1m1s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 18 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:09:22 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1m1s 1m1s 1m1s 1 1m1s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 18 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-18 08:03:33 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 56s354ms 56s354ms 56s354ms 1 56s354ms alter table only public.ged_right_user add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 18 09 1 56s354ms 56s354ms [ User: a3dsupervisor - Total duration: 56s354ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 56s354ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-11-18 08:10:17 Duration: 56s354ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 50s341ms 50s341ms 50s341ms 1 50s341ms create index i_fk_ged_right_user_ged_node on public.ged_right_user using btree (project_num_id, node_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 18 09 1 50s341ms 50s341ms [ User: a3dsupervisor - Total duration: 50s341ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 50s341ms - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-11-18 08:08:52 Duration: 50s341ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 46s113ms 46s113ms 46s113ms 1 46s113ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 18 09 1 46s113ms 46s113ms [ User: a3dsupervisor - Total duration: 46s113ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 46s113ms - 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-11-18 08:04:20 Duration: 46s113ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 45s617ms 45s617ms 45s617ms 1 45s617ms alter table only public.gtp_monthly_history add constraint fk_gtp_month_history_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 18 09 1 45s617ms 45s617ms [ User: a3dsupervisor - Total duration: 45s617ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 45s617ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-18 08:16:08 Duration: 45s617ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 37s127ms 37s127ms 37s127ms 1 37s127ms alter table only public.gtp_monthly_history add constraint fk_gtp_monthly_history_tab_id foreign key (histo_num_id_tab) references public.gtp_monthly_history (histo_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 18 09 1 37s127ms 37s127ms [ User: a3dsupervisor - Total duration: 37s127ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s127ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-11-18 08:11:32 Duration: 37s127ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 36s585ms 36s585ms 36s585ms 1 36s585ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 18 09 1 36s585ms 36s585ms [ User: a3dsupervisor - Total duration: 36s585ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s585ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-18 08:03:15 Duration: 36s585ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 36s36ms 36s36ms 36s36ms 1 36s36ms 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 #19
Day Hour Count Duration Avg duration Nov 18 09 1 36s36ms 36s36ms [ User: a3dsupervisor - Total duration: 36s36ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s36ms - 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-18 08:06:48 Duration: 36s36ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 8s99ms 8s101ms 8s100ms 2 16s201ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 18 09 2 16s201ms 8s100ms [ User: a3dsupervisor - Total duration: 16s201ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 16s201ms - Times executed: 2 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 08:45:35 Duration: 8s101ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-11-18 08:45:35 Duration: 8s99ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] 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
- 81,964 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 78186 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 78,161 Max number of times the same event was reported
- 78,186 Total events found
Rank Times reported Error 1 78,161 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 18 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,148 10 1,800 11 3,600 12 3,600 13 3,600 14 3,598 15 3,600 16 3,600 17 3,600 18 3,600 19 3,215 20 3,600 21 3,600 22 3,600 23 3,600 00 3,600 2 5 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 18 14 3 19 2 3 4 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 18 09 4 4 2 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 18 20 2 5 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 18 10 1 6 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 #6
Day Hour Count Nov 18 10 1 7 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 #7
Day Hour Count Nov 18 10 1 8 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 #8
Day Hour Count Nov 18 10 1 9 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 #9
Day Hour Count Nov 18 10 1 10 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 #10
Day Hour Count Nov 18 10 1 11 1 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... msinsert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 18 20 1 12 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (...) REFERENCES public.gtp_history_obj_action(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 18 09 1 13 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 18 09 1 14 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 #14
Day Hour Count Nov 18 10 1 15 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 18 09 1 16 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msCREATE TRIGGER t_bef_ins_er_gtp_obj_compo BEFORE INSERT ON public.gtp_obj_composition FOR EACH ROW EXECUTE FUNCTION public.trigger_fct_t_bef_ins_er_gtp_obj_compo()
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 18 09 1 17 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 18 10 1 18 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 18 10 1