pgBadger-
Global information
- Generated on Tue Oct 28 09:10:47 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=27/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=27/h=23/m=00/PT1H.log
- Parsed 134,069 log entries in 1m54s
- Log start from 2025-10-27 06:34:38 to 2025-10-27 23:59:11
-
Overview
Global Stats
- 61 Number of unique normalized queries
- 54 Number of queries
- 28m52s Total query duration
- 2025-10-27 07:11:16 First query
- 2025-10-27 20:42:06 Last query
- 3 queries/s at 2025-10-27 07:18:16 Query peak
- 28m52s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 28m52s Execute total duration
- 65,711 Number of events
- 16 Number of unique normalized events
- 65,684 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
- 156 Number temporary file
- 1.16 GiB Max size of temporary file
- 39.37 MiB Average size of temporary file
- 790 Total number of sessions
- 56 sessions at 2025-10-27 20:46:12 Session peak
- 2d10h11m41s Total duration of sessions
- 4m25s Average duration of sessions
- 0 Average queries per session
- 2s193ms Average queries duration per session
- 4m22s Average idle time per session
- 794 Total number of connections
- 12 connections/s at 2025-10-27 08:41:57 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-27 07:18:16 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-27 07:18:16 Date
Queries duration
Key values
- 28m52s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 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 23 0ms 2m11s 38s201ms 1m54s 3m20s 4m4s 08 26 0ms 2m45s 31s646ms 1m56s 2m45s 3m17s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 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 0 0ms 0ms 0ms 0ms 0ms 0ms 20 5 0ms 8s385ms 6s304ms 0ms 0ms 26s520ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 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 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 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 1 0 6 4 29s735ms 0ms 0ms 54s43ms 08 0 0 0 3 47s893ms 0ms 0ms 1m1s 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 4 0 6s630ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 27 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 9 9.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 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 0 0.00 0.00% 20 0 5 5.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 27 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 21 0.01/s 07 24 0.01/s 08 45 0.01/s 09 54 0.01/s 10 40 0.01/s 11 43 0.01/s 12 52 0.01/s 13 60 0.02/s 14 48 0.01/s 15 48 0.01/s 16 43 0.01/s 17 37 0.01/s 18 36 0.01/s 19 56 0.02/s 20 43 0.01/s 21 49 0.01/s 22 41 0.01/s 23 42 0.01/s Day Hour Count Average Duration Average idle time Oct 27 00 2 89ms 89ms 01 2 85ms 85ms 02 2 78ms 78ms 03 2 90ms 90ms 04 2 77ms 77ms 05 2 72ms 72ms 06 18 1m1s 1m1s 07 25 6m42s 6m7s 08 43 2m39s 2m20s 09 53 1m12s 1m12s 10 40 1m18s 1m18s 11 45 1m21s 1m21s 12 49 1m17s 1m17s 13 59 4m19s 4m19s 14 47 1m9s 1m9s 15 46 1m20s 1m20s 16 43 1m17s 1m17s 17 39 13m41s 13m41s 18 39 42m43s 42m43s 19 54 1m18s 1m18s 20 44 1m34s 1m33s 21 50 1m24s 1m24s 22 41 1m22s 1m22s 23 43 1m19s 1m19s -
Connections
Established Connections
Key values
- 12 connections Connection Peak
- 2025-10-27 08:41:57 Date
Connections per database
Key values
- cnrs Main Database
- 794 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 794 connections Total
-
Sessions
Simultaneous sessions
Key values
- 56 sessions Session Peak
- 2025-10-27 20:46:12 Date
Histogram of session times
Key values
- 665 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 790 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 790 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 790 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 790 sessions Total
Application Count Total Duration Average Duration DBeaver 25.0.5 - Main 'cnrs' 1 2h47m49s 2h47m49s DBeaver 25.0.5 - Metadata 'cnrs' 1 2h47m48s 2h47m48s DBeaver 25.0.5 - SQLEditor 'Script-10.sql' 1 2h47m49s 2h47m49s DBeaver 25.1.0 - Main 'cnrs' 1 5m21s 5m21s DBeaver 25.1.0 - Metadata 'cnrs' 3 5h46m29s 1h55m29s DBeaver 25.1.0 - SQLEditor 'Script-1.sql' 3 5h46m28s 1h55m29s PostgreSQL JDBC Driver 696 1d12h37m46s 3m9s [unknown] 75 10s329ms 137ms pg_restore 4 1h29m11s 22m17s psql 5 2m45s 33s162ms -
Temporary Files
Size of temporary files
Key values
- 714.08 MiB Temp Files size Peak
- 2025-10-27 07:59:53 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2025-10-27 07:59:54 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 27 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 39 2.93 GiB 77.04 MiB 08 117 3.06 GiB 26.82 MiB 09 0 0 0 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 6 309.89 MiB 47.71 MiB 55.55 MiB 51.65 MiB 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;-
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-10-27 08:06:47 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 3 248.50 MiB 16.48 MiB 214.79 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-10-27 08:04:45 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 3 714.08 MiB 225.23 MiB 246.04 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-10-27 07:59:53 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3 761.25 MiB 145.76 MiB 464.32 MiB 253.75 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-10-27 08:03:02 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 3 80.05 MiB 13.02 MiB 53.79 MiB 26.68 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-27 07:59:54 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 3 1.34 GiB 87.55 MiB 1.16 GiB 457.74 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-27 07:56:39 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3 283.91 MiB 42.03 MiB 184.99 MiB 94.64 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-27 08:00:40 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3 10.88 MiB 2.30 MiB 4.69 MiB 3.62 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-10-27 08:05:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3 860.30 MiB 15.12 MiB 824.87 MiB 286.77 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-10-27 08:00:26 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2 14.17 MiB 2.08 MiB 12.09 MiB 7.09 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2025-10-27 08:00:00 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2 5.59 MiB 2.70 MiB 2.90 MiB 2.80 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-10-27 07:59:54 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 5.69 MiB 5.69 MiB 5.69 MiB 5.69 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-10-27 08:05:31 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 98.36 MiB 98.36 MiB 98.36 MiB 98.36 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-10-27 08:05:04 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 317.16 MiB 317.16 MiB 317.16 MiB 317.16 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-27 08:03:01 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 823.95 MiB 823.95 MiB 823.95 MiB 823.95 MiB add constraint fk_gtp_obj_compo_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-27 07:56:59 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 7.56 MiB 7.56 MiB 7.56 MiB 7.56 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2025-10-27 07:59:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 158.98 MiB 158.98 MiB 158.98 MiB 158.98 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-10-27 08:05:50 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.16 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-27 07:56:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 824.87 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-27 08:00:26 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 823.95 MiB ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-27 07:56:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 464.32 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-27 08:03:02 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 317.16 MiB ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-10-27 08:03:01 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 246.04 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-10-27 07:59:53 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 242.81 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-10-27 07:59:53 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 225.23 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-10-27 07:59:53 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 214.79 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-27 08:04:45 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 184.99 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-27 08:00:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 158.98 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-10-27 08:05:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 151.17 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-27 08:04:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 145.76 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-27 08:04:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 100.23 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-27 07:58:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 98.36 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-10-27 08:05:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 87.55 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-27 07:58:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 56.88 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-27 08:00:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 55.55 MiB 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-10-27 08:06:49 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 55.53 MiB 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-10-27 08:06:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 55.52 MiB 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-10-27 08:06:47 - 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 Oct 27 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
- AccessExclusiveLock Main Lock Type
- 5 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 1 1s349ms 1s349ms relation 1 1s349ms 1s349ms AccessShareLock 1 1s553ms 1s553ms relation 1 1s553ms 1s553ms ExclusiveLock 1 1s52ms 1s52ms extension 1 1s52ms 1s52ms ShareRowExclusiveLock 1 1s844ms 1s844ms relation 1 1s844ms 1s844ms ShareUpdateExclusiveLock 1 1s1ms 1s1ms relation 1 1s1ms 1s1ms Total 5 6s801ms 1s360ms 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
- 0 Total read queries
- 53 Total write queries
Queries by database
Key values
- cnrs Main database
- 54 Requests
- 28m52s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 54 Requests
User Request type Count Duration a3dsupervisor Total 54 28m52s copy from 7 6m51s ddl 32 17m34s delete 10 1m20s insert 1 5s7ms others 1 2m45s tcl 3 16s348ms Duration by user
Key values
- 28m52s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 54 28m52s copy from 7 6m51s ddl 32 17m34s delete 10 1m20s insert 1 5s7ms others 1 2m45s tcl 3 16s348ms Queries by host
Key values
- 10.3.0.4 Main host
- 54 Requests
- 28m52s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 39 Requests
- 24m25s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-27 23:48:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 31 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 2m45s VACUUM ANALYSE;[ Date: 2025-10-27 08:40:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 2m11s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-10-27 07:56:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1m53s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-10-27 07:56:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1m43s COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;[ Date: 2025-10-27 07:54:29 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 1m36s 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-10-27 07:54:22 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 1m19s CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);[ Date: 2025-10-27 08:03:02 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 1m16s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-10-27 07:59:53 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 1m14s CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);[ Date: 2025-10-27 08:03:01 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 1m4s 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-10-27 08:04:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 1m1s COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) FROM stdin;[ Date: 2025-10-27 08:05:05 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 58s949ms 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-10-27 08:06:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 47s332ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;[ Date: 2025-10-27 08:01:42 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 47s64ms ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-27 07:59:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 45s67ms ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-10-27 08:05:51 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 40s67ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;[ Date: 2025-10-27 07:55:05 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 37s238ms ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-10-27 08:03:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 36s958ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-27 07:58:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 34s877ms CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);[ Date: 2025-10-27 07:57:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 34s599ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-10-27 08:04:41 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 33s488ms CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);[ Date: 2025-10-27 07:57:39 - 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 2m45s 1 2m45s 2m45s 2m45s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 27 09 1 2m45s 2m45s [ User: a3dsupervisor - Total duration: 2m45s - Times executed: 1 ]
[ Application: psql - Total duration: 2m45s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-27 08:40:48 Duration: 2m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m11s 1 2m11s 2m11s 2m11s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 27 08 1 2m11s 2m11s [ User: a3dsupervisor - Total duration: 2m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m11s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-10-27 07:56:40 Duration: 2m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1m53s 1 1m53s 1m53s 1m53s 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 Oct 27 08 1 1m53s 1m53s [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m53s - 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-10-27 07:56:59 Duration: 1m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m43s 1 1m43s 1m43s 1m43s 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 Oct 27 08 1 1m43s 1m43s [ User: a3dsupervisor - Total duration: 1m43s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m43s - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-27 07:54:29 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m36s 1 1m36s 1m36s 1m36s 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 #5
Day Hour Count Duration Avg duration Oct 27 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 1m36s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m36s - 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-10-27 07:54:22 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m19s 1 1m19s 1m19s 1m19s 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 #6
Day Hour Count Duration Avg duration Oct 27 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - 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-10-27 08:03:02 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m16s 1 1m16s 1m16s 1m16s 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 Oct 27 08 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-27 07:59:53 Duration: 1m16s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m14s 1 1m14s 1m14s 1m14s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 27 09 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m14s - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-10-27 08:03:01 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m4s 1 1m4s 1m4s 1m4s 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 #9
Day Hour Count Duration Avg duration Oct 27 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.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-10-27 08:04:06 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1m1s 1 1m1s 1m1s 1m1s copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 27 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) FROM stdin;
Date: 2025-10-27 08:05:05 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 58s949ms 1 58s949ms 58s949ms 58s949ms 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 #11
Day Hour Count Duration Avg duration Oct 27 09 1 58s949ms 58s949ms [ User: a3dsupervisor - Total duration: 58s949ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 58s949ms - 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-10-27 08:06:50 Duration: 58s949ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 54s722ms 6 6s150ms 13s341ms 9s120ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 27 08 3 33s362ms 11s120ms 21 3 21s360ms 7s120ms [ User: a3dsupervisor - Total duration: 54s722ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 54s722ms - Times executed: 6 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 13s341ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 10s90ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 9s930ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 47s332ms 1 47s332ms 47s332ms 47s332ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 27 09 1 47s332ms 47s332ms [ User: a3dsupervisor - Total duration: 47s332ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s332ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-10-27 08:01:42 Duration: 47s332ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 47s64ms 1 47s64ms 47s64ms 47s64ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 27 08 1 47s64ms 47s64ms [ User: a3dsupervisor - Total duration: 47s64ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s64ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-27 07:59:50 Duration: 47s64ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 45s67ms 1 45s67ms 45s67ms 45s67ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 27 09 1 45s67ms 45s67ms [ User: a3dsupervisor - Total duration: 45s67ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 45s67ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-10-27 08:05:51 Duration: 45s67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 40s67ms 1 40s67ms 40s67ms 40s67ms 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 #16
Day Hour Count Duration Avg duration Oct 27 08 1 40s67ms 40s67ms [ User: a3dsupervisor - Total duration: 40s67ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 40s67ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-10-27 07:55:05 Duration: 40s67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 37s238ms 1 37s238ms 37s238ms 37s238ms alter table only public.gtp_obj_composition 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);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 27 09 1 37s238ms 37s238ms [ User: a3dsupervisor - Total duration: 37s238ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s238ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-27 08:03:39 Duration: 37s238ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 36s958ms 1 36s958ms 36s958ms 36s958ms 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 Oct 27 08 1 36s958ms 36s958ms [ User: a3dsupervisor - Total duration: 36s958ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s958ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-27 07:58:37 Duration: 36s958ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 34s877ms 1 34s877ms 34s877ms 34s877ms create index i_fk_monthly_history_histo_num_id_tab on public.gtp_monthly_history using btree (histo_num_id_tab);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 27 08 1 34s877ms 34s877ms [ User: a3dsupervisor - Total duration: 34s877ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s877ms - Times executed: 1 ]
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2025-10-27 07:57:55 Duration: 34s877ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 34s599ms 1 34s599ms 34s599ms 34s599ms 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 #20
Day Hour Count Duration Avg duration Oct 27 09 1 34s599ms 34s599ms [ User: a3dsupervisor - Total duration: 34s599ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s599ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-27 08:04:41 Duration: 34s599ms 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 6 54s722ms 6s150ms 13s341ms 9s120ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 27 08 3 33s362ms 11s120ms 21 3 21s360ms 7s120ms [ User: a3dsupervisor - Total duration: 54s722ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 54s722ms - Times executed: 6 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 13s341ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 10s90ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 9s930ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4 25s841ms 5s160ms 6s935ms 6s460ms delete from gtp_background_task task where task.task_num_id in ( select task.task_num_id from gtp_background_task task where task.task_service_name = and (task.task_start_date + interval ? * ?) < current_timestamp and task.task_status = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 27 08 3 20s680ms 6s893ms 21 1 5s160ms 5s160ms [ User: a3dsupervisor - Total duration: 25s841ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 25s841ms - Times executed: 4 ]
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = AND (task.TASK_START_DATE + interval '1 day' * 7) < current_timestamp AND task.TASK_STATUS = 4);
Date: 2025-10-27 07:18:24 Duration: 6s935ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = AND (task.TASK_START_DATE + interval '1 day' * 7) < current_timestamp AND task.TASK_STATUS = 4);
Date: 2025-10-27 07:18:24 Duration: 6s934ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = AND (task.TASK_START_DATE + interval '1 day' * 7) < current_timestamp AND task.TASK_STATUS = 4);
Date: 2025-10-27 07:18:24 Duration: 6s810ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 3 16s348ms 5s3ms 5s733ms 5s449ms commit;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 27 08 2 11s344ms 5s672ms 21 1 5s3ms 5s3ms [ User: a3dsupervisor - Total duration: 16s348ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 16s348ms - Times executed: 3 ]
-
COMMIT;
Date: 2025-10-27 07:11:16 Duration: 5s733ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 07:13:01 Duration: 5s610ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-27 20:42:06 Duration: 5s3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 2m45s 2m45s 2m45s 2m45s vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 27 09 1 2m45s 2m45s [ User: a3dsupervisor - Total duration: 2m45s - Times executed: 1 ]
[ Application: psql - Total duration: 2m45s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-27 08:40:48 Duration: 2m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 2m11s 2m11s 2m11s 2m11s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 27 08 1 2m11s 2m11s [ User: a3dsupervisor - Total duration: 2m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m11s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-10-27 07:56:40 Duration: 2m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1 1m53s 1m53s 1m53s 1m53s 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 #6
Day Hour Count Duration Avg duration Oct 27 08 1 1m53s 1m53s [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m53s - 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-10-27 07:56:59 Duration: 1m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1 1m43s 1m43s 1m43s 1m43s 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 Oct 27 08 1 1m43s 1m43s [ User: a3dsupervisor - Total duration: 1m43s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m43s - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-27 07:54:29 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 1m36s 1m36s 1m36s 1m36s 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 Oct 27 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 1m36s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m36s - 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-10-27 07:54:22 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 1m19s 1m19s 1m19s 1m19s 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 #9
Day Hour Count Duration Avg duration Oct 27 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - 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-10-27 08:03:02 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 1m16s 1m16s 1m16s 1m16s 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 #10
Day Hour Count Duration Avg duration Oct 27 08 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-27 07:59:53 Duration: 1m16s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 1m14s 1m14s 1m14s 1m14s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 27 09 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m14s - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-10-27 08:03:01 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 1m4s 1m4s 1m4s 1m4s 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 #12
Day Hour Count Duration Avg duration Oct 27 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.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-10-27 08:04:06 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 1m1s 1m1s 1m1s 1m1s copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 27 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) FROM stdin;
Date: 2025-10-27 08:05:05 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 58s949ms 58s949ms 58s949ms 58s949ms 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 #14
Day Hour Count Duration Avg duration Oct 27 09 1 58s949ms 58s949ms [ User: a3dsupervisor - Total duration: 58s949ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 58s949ms - 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-10-27 08:06:50 Duration: 58s949ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 47s332ms 47s332ms 47s332ms 47s332ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 27 09 1 47s332ms 47s332ms [ User: a3dsupervisor - Total duration: 47s332ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s332ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-10-27 08:01:42 Duration: 47s332ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 47s64ms 47s64ms 47s64ms 47s64ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_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 Oct 27 08 1 47s64ms 47s64ms [ User: a3dsupervisor - Total duration: 47s64ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s64ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-27 07:59:50 Duration: 47s64ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 45s67ms 45s67ms 45s67ms 45s67ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 27 09 1 45s67ms 45s67ms [ User: a3dsupervisor - Total duration: 45s67ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 45s67ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-10-27 08:05:51 Duration: 45s67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 40s67ms 40s67ms 40s67ms 40s67ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 27 08 1 40s67ms 40s67ms [ User: a3dsupervisor - Total duration: 40s67ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 40s67ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-10-27 07:55:05 Duration: 40s67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 37s238ms 37s238ms 37s238ms 37s238ms alter table only public.gtp_obj_composition 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);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 27 09 1 37s238ms 37s238ms [ User: a3dsupervisor - Total duration: 37s238ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s238ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-27 08:03:39 Duration: 37s238ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 36s958ms 36s958ms 36s958ms 36s958ms 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 Oct 27 08 1 36s958ms 36s958ms [ User: a3dsupervisor - Total duration: 36s958ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s958ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-27 07:58:37 Duration: 36s958ms 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 2m45s 2m45s 2m45s 1 2m45s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 27 09 1 2m45s 2m45s [ User: a3dsupervisor - Total duration: 2m45s - Times executed: 1 ]
[ Application: psql - Total duration: 2m45s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-10-27 08:40:48 Duration: 2m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m11s 2m11s 2m11s 1 2m11s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 27 08 1 2m11s 2m11s [ User: a3dsupervisor - Total duration: 2m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m11s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-10-27 07:56:40 Duration: 2m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1m53s 1m53s 1m53s 1 1m53s 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 Oct 27 08 1 1m53s 1m53s [ User: a3dsupervisor - Total duration: 1m53s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m53s - 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-10-27 07:56:59 Duration: 1m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m43s 1m43s 1m43s 1 1m43s 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 Oct 27 08 1 1m43s 1m43s [ User: a3dsupervisor - Total duration: 1m43s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m43s - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-27 07:54:29 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m36s 1m36s 1m36s 1 1m36s 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 #5
Day Hour Count Duration Avg duration Oct 27 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 1m36s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m36s - 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-10-27 07:54:22 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m19s 1m19s 1m19s 1 1m19s 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 #6
Day Hour Count Duration Avg duration Oct 27 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m19s - 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-10-27 08:03:02 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m16s 1m16s 1m16s 1 1m16s 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 Oct 27 08 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m16s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-27 07:59:53 Duration: 1m16s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m14s 1m14s 1m14s 1 1m14s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 27 09 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m14s - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-10-27 08:03:01 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m4s 1m4s 1m4s 1 1m4s 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 #9
Day Hour Count Duration Avg duration Oct 27 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.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-10-27 08:04:06 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1m1s 1m1s 1m1s 1 1m1s copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 27 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - Times executed: 1 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) FROM stdin;
Date: 2025-10-27 08:05:05 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 58s949ms 58s949ms 58s949ms 1 58s949ms 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 #11
Day Hour Count Duration Avg duration Oct 27 09 1 58s949ms 58s949ms [ User: a3dsupervisor - Total duration: 58s949ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 58s949ms - 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-10-27 08:06:50 Duration: 58s949ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 47s332ms 47s332ms 47s332ms 1 47s332ms 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 Oct 27 09 1 47s332ms 47s332ms [ User: a3dsupervisor - Total duration: 47s332ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s332ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-10-27 08:01:42 Duration: 47s332ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 47s64ms 47s64ms 47s64ms 1 47s64ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 27 08 1 47s64ms 47s64ms [ User: a3dsupervisor - Total duration: 47s64ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s64ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-27 07:59:50 Duration: 47s64ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 45s67ms 45s67ms 45s67ms 1 45s67ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 27 09 1 45s67ms 45s67ms [ User: a3dsupervisor - Total duration: 45s67ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 45s67ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-10-27 08:05:51 Duration: 45s67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 40s67ms 40s67ms 40s67ms 1 40s67ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 27 08 1 40s67ms 40s67ms [ User: a3dsupervisor - Total duration: 40s67ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 40s67ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-10-27 07:55:05 Duration: 40s67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 37s238ms 37s238ms 37s238ms 1 37s238ms alter table only public.gtp_obj_composition 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);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 27 09 1 37s238ms 37s238ms [ User: a3dsupervisor - Total duration: 37s238ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s238ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-27 08:03:39 Duration: 37s238ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 36s958ms 36s958ms 36s958ms 1 36s958ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 27 08 1 36s958ms 36s958ms [ User: a3dsupervisor - Total duration: 36s958ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 36s958ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-27 07:58:37 Duration: 36s958ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 34s877ms 34s877ms 34s877ms 1 34s877ms create index i_fk_monthly_history_histo_num_id_tab on public.gtp_monthly_history using btree (histo_num_id_tab);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 27 08 1 34s877ms 34s877ms [ User: a3dsupervisor - Total duration: 34s877ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s877ms - Times executed: 1 ]
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2025-10-27 07:57:55 Duration: 34s877ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 34s599ms 34s599ms 34s599ms 1 34s599ms 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 #19
Day Hour Count Duration Avg duration Oct 27 09 1 34s599ms 34s599ms [ User: a3dsupervisor - Total duration: 34s599ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s599ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-10-27 08:04:41 Duration: 34s599ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 6s150ms 13s341ms 9s120ms 6 54s722ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 27 08 3 33s362ms 11s120ms 21 3 21s360ms 7s120ms [ User: a3dsupervisor - Total duration: 54s722ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 54s722ms - Times executed: 6 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 13s341ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 10s90ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2025-10-27 07:18:16 Duration: 9s930ms Database: cnrs 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
- 68,304 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 65711 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 65,684 Max number of times the same event was reported
- 65,711 Total events found
Rank Times reported Error 1 65,684 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 27 07 5,066 08 7,003 10 3,600 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,610 17 3,600 18 3,600 19 3,221 20 3,600 21 3,584 22 3,600 23 3,600 00 3,600 2 13 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 27 08 3 14 2 18 2 19 6 3 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 27 09 1 4 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 27 08 1 5 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 #5
Day Hour Count Oct 27 09 1 6 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 27 09 1 7 1 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect glmp1_0.LOG_METRIC_NUM_ID,glmp1_0.LOG_DATE,glmp1_0.METRIC_AVERAGE_VALUE,glmp1_0.METRIC_MAX_VALUE,glmp1_0.METRIC_MIN_VALUE,glmp1_0.METRIC_NAME,glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between and and (...)
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 27 21 1 8 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 27 09 1 9 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 27 09 1 10 1 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 27 09 1 11 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 #11
Day Hour Count Oct 27 09 1 12 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 27 09 1 13 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 #13
Day Hour Count Oct 27 09 1 14 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 #14
Day Hour Count Oct 27 09 1 15 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 #15
Day Hour Count Oct 27 09 1 16 1 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 27 09 1