pgBadger-
Global information
- Generated on Mon Mar 9 09:01:05 2026
- Log file: ././A3D-RND-PIC/y=2026/m=03/d=06/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2026/m=03/d=06/h=23/m=00/PT1H.log
- Parsed 1,097 log entries in 50s
- Log start from 2026-03-06 08:01:42 to 2026-03-06 18:01:07
-
Overview
Global Stats
- 78 Number of unique normalized queries
- 66 Number of queries
- 37m41s Total query duration
- 2026-03-06 06:37:53 First query
- 2026-03-06 08:55:14 Last query
- 2 queries/s at 2026-03-06 08:06:40 Query peak
- 37m41s Total query duration
- 10s237ms Prepare/parse total duration
- 3s508ms Bind total duration
- 37m28s Execute total duration
- 42 Number of events
- 15 Number of unique normalized events
- 24 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
- 107 Number temporary file
- 954.66 MiB Max size of temporary file
- 53.75 MiB Average size of temporary file
- 248 Total number of sessions
- 22 sessions at 2026-03-06 08:51:05 Session peak
- 2d3h44m17s Total duration of sessions
- 12m31s Average duration of sessions
- 0 Average queries per session
- 9s120ms Average queries duration per session
- 12m21s Average idle time per session
- 248 Total number of connections
- 8 connections/s at 2026-03-06 08:51:02 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-06 08:06:40 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-06 08:32:28 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-06 08:06:40 Date
Queries duration
Key values
- 37m41s 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) Mar 06 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 13 0ms 6s108ms 4s199ms 12s268ms 16s368ms 16s368ms 07 6 0ms 2m20s 1m27s 4m21s 4m21s 4m21s 08 47 0ms 7m22s 35s506ms 2m31s 3m2s 7m22s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 06 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 1 0 4s259ms 0ms 0ms 4s259ms 07 0 0 0ms 0ms 0ms 0ms 08 1 0 3s713ms 0ms 0ms 3s713ms 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) Mar 06 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 4 0 3 0 4s528ms 0ms 3s896ms 10s893ms 07 0 0 0 3 1m18s 0ms 1m53s 2m2s 08 0 0 1 5 21s914ms 0ms 0ms 32s995ms 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 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 06 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 1 13 13.00 7.69% 07 1 0 0.00 16.67% 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 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 06 00 5 0.00/s 01 9 0.00/s 02 8 0.00/s 03 3 0.00/s 04 12 0.00/s 05 5 0.00/s 06 10 0.00/s 07 10 0.00/s 08 35 0.01/s 09 9 0.00/s 10 9 0.00/s 11 14 0.00/s 12 10 0.00/s 13 11 0.00/s 14 7 0.00/s 15 6 0.00/s 16 19 0.01/s 17 13 0.00/s 18 12 0.00/s 19 11 0.00/s 20 8 0.00/s 21 4 0.00/s 22 5 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Mar 06 00 5 36s776ms 36s776ms 01 9 16m14s 16m14s 02 8 3m25s 3m25s 03 3 38m43s 38m43s 04 12 4m29s 4m29s 05 5 49s165ms 49s165ms 06 10 14m37s 14m31s 07 10 1h21m29s 1h20m37s 08 35 5m9s 4m21s 09 6 54s819ms 54s819ms 10 12 9m53s 9m53s 11 14 52s75ms 52s75ms 12 10 58s697ms 58s697ms 13 11 43s18ms 43s18ms 14 7 50s586ms 50s586ms 15 6 45s538ms 45s538ms 16 18 48m59s 48m59s 17 14 1m7s 1m7s 18 12 19m46s 19m46s 19 11 57s779ms 57s779ms 20 8 57s560ms 57s560ms 21 4 46m34s 46m34s 22 5 18m44s 18m44s 23 13 1m5s 1m5s -
Connections
Established Connections
Key values
- 8 connections Connection Peak
- 2026-03-06 08:51:02 Date
Connections per database
Key values
- cnrs Main Database
- 248 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 248 connections Total
-
Sessions
Simultaneous sessions
Key values
- 22 sessions Session Peak
- 2026-03-06 08:51:05 Date
Histogram of session times
Key values
- 167 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 248 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 248 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 248 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 248 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'cnrs' 1 2m38s 2m38s DBeaver 23.2.0 - Metadata 'cnrs' 1 2m37s 2m37s DBeaver 26.0.0 - Main 'cnrs' 1 35m41s 35m41s DBeaver 26.0.0 - Metadata 'cnrs' 1 35m40s 35m40s DBeaver 26.0.0 - SQLEditor 'Script-13.sql' 1 35m38s 35m38s PostgreSQL JDBC Driver 183 2d9m4s 15m47s [unknown] 51 3s853ms 75ms pg_restore 4 1h35m28s 23m52s psql 5 7m23s 1m28s -
Temporary Files
Size of temporary files
Key values
- 498.59 MiB Temp Files size Peak
- 2026-03-06 08:06:40 Date
Number of temporary files
Key values
- 5 per second Temp Files Peak
- 2026-03-06 08:06:40 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 06 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 5 691.22 MiB 138.24 MiB 08 102 4.94 GiB 49.61 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 2 1.07 GiB 143.89 MiB 954.66 MiB 549.27 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-03-06 08:00:05 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 2 80.68 MiB 17.48 MiB 63.20 MiB 40.34 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: 2026-03-06 08:08:34 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 2 714.08 MiB 345.76 MiB 368.32 MiB 357.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);-
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: 2026-03-06 08:03:32 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 2 788.46 MiB 26.55 MiB 761.91 MiB 394.23 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: 2026-03-06 08:04:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 2 131.27 MiB 26.08 MiB 105.20 MiB 65.64 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-06 08:08:28 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 2 64.62 MiB 2.55 MiB 62.06 MiB 32.31 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: 2026-03-06 08:07:48 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 2 761.21 MiB 235.86 MiB 525.35 MiB 380.61 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: 2026-03-06 08:05:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 2 97.17 MiB 44.27 MiB 52.90 MiB 48.59 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: 2026-03-06 08:06:47 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 2 7.09 MiB 2.30 MiB 4.79 MiB 3.55 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: 2026-03-06 08:08:47 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2 425.83 MiB 73.96 MiB 351.87 MiB 212.91 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-06 08:03:50 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2 159.00 MiB 78.68 MiB 80.32 MiB 79.50 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-03-06 08:07:46 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 2 43.33 MiB 6.56 MiB 36.77 MiB 21.66 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: 2026-03-06 08:08:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 17.71 MiB 17.71 MiB 17.71 MiB 17.71 MiB add constraint pk_bdc_right primary key (right_num_id);-
ADD CONSTRAINT pk_bdc_right PRIMARY KEY (right_num_id);
Date: 2026-03-06 08:06:42 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 2.08 MiB 2.08 MiB 2.08 MiB 2.08 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2026-03-06 08:06:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 22.62 MiB 22.62 MiB 22.62 MiB 22.62 MiB add constraint fk_gtp_monthly_history_unit foreign key (att_unit_num_id) references public.gtp_att_unit (att_unit_num_id);-
ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);
Date: 2026-03-06 08:07:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 41.69 MiB 41.69 MiB 41.69 MiB 41.69 MiB add constraint fk_history_doc_deleted_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_doc_deleted_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-06 08:08:00 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 12.77 MiB 12.77 MiB 12.77 MiB 12.77 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: 2026-03-06 08:08:42 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 549.27 MiB 549.27 MiB 549.27 MiB 549.27 MiB add constraint fk_gtp_obj_compo_template foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-06 08:00:06 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 2.02 MiB 2.02 MiB 2.02 MiB 2.02 MiB add constraint pk_eng_gtp_datalink_objdid primary key (obj_num_id, eng_data_id);-
ADD CONSTRAINT pk_eng_gtp_datalink_objdid PRIMARY KEY (obj_num_id, eng_data_id);
Date: 2026-03-06 08:06:40 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 12.53 MiB 12.53 MiB 12.53 MiB 12.53 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: 2026-03-06 08:08: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 954.66 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-03-06 08:00:05 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 761.91 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-03-06 08:04:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 549.27 MiB ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-06 08:00:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 525.35 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2026-03-06 08:05:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 368.32 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: 2026-03-06 08:03:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 351.87 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-06 08:03:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 345.76 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: 2026-03-06 08:03:32 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 235.86 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2026-03-06 08:06:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 143.89 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-03-06 08:02:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 105.20 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-06 08:08:28 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 80.32 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2026-03-06 08:07:46 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 78.68 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2026-03-06 08:07:46 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 73.96 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-06 08:04:19 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 63.20 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: 2026-03-06 08:08:34 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 62.06 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2026-03-06 08:07:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 52.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);[ Date: 2026-03-06 08:06:47 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 44.27 MiB ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2026-03-06 08:06:47 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 41.69 MiB ADD CONSTRAINT fk_history_doc_deleted_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-06 08:08:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 36.77 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2026-03-06 08:08:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 26.55 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-03-06 08:06:40 - 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 Mar 06 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
- 27 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 2 Total read queries
- 62 Total write queries
Queries by database
Key values
- cnrs Main database
- 66 Requests
- 37m28s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 66 Requests
User Request type Count Duration a3dsupervisor Total 66 37m28s copy from 8 5m55s ddl 40 19m56s delete 4 25s27ms insert 4 19s56ms others 2 10m22s select 2 7s972ms tcl 6 21s865ms Duration by user
Key values
- 37m28s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 66 37m28s copy from 8 5m55s ddl 40 19m56s delete 4 25s27ms insert 4 19s56ms others 2 10m22s select 2 7s972ms tcl 6 21s865ms Queries by host
Key values
- 10.3.0.4 Main host
- 66 Requests
- 37m28s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 50 Requests
- 25m58s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-06 08:01:39 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 35 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 7m22s VACUUM ANALYSE;[ Date: 2026-03-06 08:50:11 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 3m DO $body$ DECLARE L_SCRIPT_NAME CONSTANT text := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID, ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (ga.att_template_num_id = gat.att_template_num_id) INNER JOIN GED_DOCUMENT ge ON (ga.OBJ_COMPO_VALUE::varchar = ge.document_num_id::varchar) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (tab.OBJ_COMPO_NUM_ID = ga.obj_compo_num_id_tab) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId varchar(100); cNewGedId bigint; BEGIN INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [START]', '7.23.0.0'); raise debug 'START %', L_SCRIPT_NAME; OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; EXIT WHEN NOT FOUND; SELECT gd.document_num_id INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (gei.node_num_id = gd.node_num_id) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id::varchar = cOldGedId; UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId::varchar WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; raise notice 'END %', L_SCRIPT_NAME; UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = true WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [SUCCESS]', '7.23.0.0'); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [ERROR]', '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR ('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.23.0.0'); RAISE; END $body$;[ Date: 2026-03-06 08:54:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 2m20s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2026-03-06 07:59:23 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 2m2s 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: 2026-03-06 07:57:03 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 2m CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2026-03-06 07:59:26 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 1m24s 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: 2026-03-06 08:03:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 1m11s 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: 2026-03-06 08:06:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 1m9s CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);[ Date: 2026-03-06 08:03:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 1m1s 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, batch_process_num_id) FROM stdin;[ Date: 2026-03-06 07:56:03 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 56s395ms CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);[ Date: 2026-03-06 08:01:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 52s56ms 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: 2026-03-06 07:56:57 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 47s750ms 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: 2026-03-06 08:07:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 47s600ms CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);[ Date: 2026-03-06 08:05:28 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 43s98ms CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);[ Date: 2026-03-06 08:00:07 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 40s241ms CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);[ Date: 2026-03-06 08:00:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 38s308ms CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);[ Date: 2026-03-06 08:05:24 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 37s590ms CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);[ Date: 2026-03-06 08:00:44 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 35s316ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-03-06 08:02:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 34s754ms ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-06 08:02:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 32s995ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;[ Date: 2026-03-06 08:04:38 - 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 7m22s 1 7m22s 7m22s 7m22s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 09 1 7m22s 7m22s [ User: a3dsupervisor - Total duration: 7m22s - Times executed: 1 ]
[ Application: psql - Total duration: 7m22s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-06 08:50:11 Duration: 7m22s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 3m 1 3m 3m 3m do $body$ declare l_script_name constant text := ?; cursel cursor for select distinct ga.obj_compo_num_id, ga.obj_num_id, ga.obj_compo_value from gtp_obj_composition ga inner join gtp_att_template gat on (ga.att_template_num_id = gat.att_template_num_id) inner join ged_document ge on (ga.obj_compo_value::varchar = ge.document_num_id::varchar) left join gtp_obj_composition tab on (tab.obj_compo_num_id = ga.obj_compo_num_id_tab) where gat.att_template_domain_code = ?; ccomponumid bigint; cobjid bigint; coldgedid varchar(?); cnewgedid bigint; begin insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); raise debug ?, l_script_name; open cursel; loop fetch next from "..." into ccomponumid, cobjid, coldgedid; exit when not found; select gd.document_num_id into cnewgedid from ged_document gd inner join ged_document gei on (gei.node_num_id = gd.node_num_id) where gd.document_num_id_version is null and gei.document_num_id::varchar = coldgedid; update gtp_obj_composition set obj_compo_value = cnewgedid::varchar where obj_compo_num_id = ccomponumid and obj_num_id = cobjid; end loop; close "..." raise notice ?, l_script_name; update a3d_migration_tracking set validated = true where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); exception when others then call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); call pack_gtp_utils.p_trace_error (? || l_script_name, sqlerrm, ?); raise; end $body$;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 09 1 3m 3m [ User: a3dsupervisor - Total duration: 3m - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m - Times executed: 1 ]
-
DO $body$ DECLARE L_SCRIPT_NAME CONSTANT text := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID, ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (ga.att_template_num_id = gat.att_template_num_id) INNER JOIN GED_DOCUMENT ge ON (ga.OBJ_COMPO_VALUE::varchar = ge.document_num_id::varchar) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (tab.OBJ_COMPO_NUM_ID = ga.obj_compo_num_id_tab) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId varchar(100); cNewGedId bigint; BEGIN INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [START]', '7.23.0.0'); raise debug 'START %', L_SCRIPT_NAME; OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; EXIT WHEN NOT FOUND; SELECT gd.document_num_id INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (gei.node_num_id = gd.node_num_id) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id::varchar = cOldGedId; UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId::varchar WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; raise notice 'END %', L_SCRIPT_NAME; UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = true WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [SUCCESS]', '7.23.0.0'); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [ERROR]', '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR ('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.23.0.0'); RAISE; END $body$;
Date: 2026-03-06 08:54:18 Duration: 3m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m20s 1 2m20s 2m20s 2m20s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 06 08 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-06 07:59:23 Duration: 2m20s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 2m2s 1 2m2s 2m2s 2m2s 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 Mar 06 08 1 2m2s 2m2s [ User: a3dsupervisor - Total duration: 2m2s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m2s - 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: 2026-03-06 07:57:03 Duration: 2m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 2m 1 2m 2m 2m 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 Mar 06 08 1 2m 2m [ User: a3dsupervisor - Total duration: 2m - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-06 07:59:26 Duration: 2m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m24s 1 1m24s 1m24s 1m24s 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 #6
Day Hour Count Duration Avg duration Mar 06 09 1 1m24s 1m24s [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m24s - 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: 2026-03-06 08:03:33 Duration: 1m24s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m11s 1 1m11s 1m11s 1m11s 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 #7
Day Hour Count Duration Avg duration Mar 06 09 1 1m11s 1m11s [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m11s - 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: 2026-03-06 08:06:40 Duration: 1m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m9s 1 1m9s 1m9s 1m9s create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 06 09 1 1m9s 1m9s [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m9s - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-06 08:03:50 Duration: 1m9s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m1s 1 1m1s 1m1s 1m1s 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, batch_process_num_id) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 06 08 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - 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, batch_process_num_id) FROM stdin;
Date: 2026-03-06 07:56:03 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 56s395ms 1 56s395ms 56s395ms 56s395ms create index i_fk_monthly_history_unit on public.gtp_monthly_history using btree (att_unit_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 06 09 1 56s395ms 56s395ms [ User: a3dsupervisor - Total duration: 56s395ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 56s395ms - Times executed: 1 ]
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-03-06 08:01:33 Duration: 56s395ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 52s56ms 1 52s56ms 52s56ms 52s56ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 06 08 1 52s56ms 52s56ms [ User: a3dsupervisor - Total duration: 52s56ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 52s56ms - 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: 2026-03-06 07:56:57 Duration: 52s56ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 47s750ms 1 47s750ms 47s750ms 47s750ms 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 #12
Day Hour Count Duration Avg duration Mar 06 09 1 47s750ms 47s750ms [ User: a3dsupervisor - Total duration: 47s750ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s750ms - 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: 2026-03-06 08:07:40 Duration: 47s750ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 47s600ms 1 47s600ms 47s600ms 47s600ms 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 #13
Day Hour Count Duration Avg duration Mar 06 09 1 47s600ms 47s600ms [ User: a3dsupervisor - Total duration: 47s600ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s600ms - 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: 2026-03-06 08:05:28 Duration: 47s600ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 43s98ms 1 43s98ms 43s98ms 43s98ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 06 09 1 43s98ms 43s98ms [ User: a3dsupervisor - Total duration: 43s98ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 43s98ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-03-06 08:00:07 Duration: 43s98ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 40s241ms 1 40s241ms 40s241ms 40s241ms create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 06 09 1 40s241ms 40s241ms [ User: a3dsupervisor - Total duration: 40s241ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 40s241ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-03-06 08:00:06 Duration: 40s241ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 38s308ms 1 38s308ms 38s308ms 38s308ms create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 06 09 1 38s308ms 38s308ms [ User: a3dsupervisor - Total duration: 38s308ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s308ms - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-03-06 08:05:24 Duration: 38s308ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 37s590ms 1 37s590ms 37s590ms 37s590ms 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 #17
Day Hour Count Duration Avg duration Mar 06 09 1 37s590ms 37s590ms [ User: a3dsupervisor - Total duration: 37s590ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s590ms - 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: 2026-03-06 08:00:44 Duration: 37s590ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 35s316ms 1 35s316ms 35s316ms 35s316ms 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 Mar 06 09 1 35s316ms 35s316ms [ User: a3dsupervisor - Total duration: 35s316ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s316ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-03-06 08:02:08 Duration: 35s316ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 34s754ms 1 34s754ms 34s754ms 34s754ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_template foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) deferrable initially deferred;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 06 09 1 34s754ms 34s754ms [ User: a3dsupervisor - Total duration: 34s754ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s754ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-06 08:02:40 Duration: 34s754ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 32s995ms 1 32s995ms 32s995ms 32s995ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 06 09 1 32s995ms 32s995ms [ User: a3dsupervisor - Total duration: 32s995ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s995ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2026-03-06 08:04:38 Duration: 32s995ms 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 21s865ms 3s70ms 4s259ms 3s644ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 07 5 18s631ms 3s726ms 09 1 3s233ms 3s233ms [ User: a3dsupervisor - Total duration: 21s865ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 18s631ms - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3s233ms - Times executed: 1 ]
-
COMMIT;
Date: 2026-03-06 06:50:05 Duration: 4s259ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:50:22 Duration: 4s256ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-06 06:50:04 Duration: 3s956ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3 15s159ms 4s265ms 5s449ms 5s53ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 07 3 15s159ms 5s53ms [ User: a3dsupervisor - Total duration: 15s159ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15s159ms - Times executed: 3 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-06 06:37:53 Duration: 5s449ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-06 06:37:53 Duration: 5s444ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2026-03-06 06:38:26 Duration: 4s265ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2 9s306ms 3s198ms 6s108ms 4s653ms 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 #3
Day Hour Count Duration Avg duration Mar 06 07 2 9s306ms 4s653ms [ User: a3dsupervisor - Total duration: 9s306ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s306ms - Times executed: 2 ]
-
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: 2026-03-06 06:49:34 Duration: 6s108ms 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: 2026-03-06 06:39:31 Duration: 3s198ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 1 7m22s 7m22s 7m22s 7m22s vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 06 09 1 7m22s 7m22s [ User: a3dsupervisor - Total duration: 7m22s - Times executed: 1 ]
[ Application: psql - Total duration: 7m22s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-06 08:50:11 Duration: 7m22s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 3m 3m 3m 3m do $body$ declare l_script_name constant text := ?; cursel cursor for select distinct ga.obj_compo_num_id, ga.obj_num_id, ga.obj_compo_value from gtp_obj_composition ga inner join gtp_att_template gat on (ga.att_template_num_id = gat.att_template_num_id) inner join ged_document ge on (ga.obj_compo_value::varchar = ge.document_num_id::varchar) left join gtp_obj_composition tab on (tab.obj_compo_num_id = ga.obj_compo_num_id_tab) where gat.att_template_domain_code = ?; ccomponumid bigint; cobjid bigint; coldgedid varchar(?); cnewgedid bigint; begin insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); raise debug ?, l_script_name; open cursel; loop fetch next from "..." into ccomponumid, cobjid, coldgedid; exit when not found; select gd.document_num_id into cnewgedid from ged_document gd inner join ged_document gei on (gei.node_num_id = gd.node_num_id) where gd.document_num_id_version is null and gei.document_num_id::varchar = coldgedid; update gtp_obj_composition set obj_compo_value = cnewgedid::varchar where obj_compo_num_id = ccomponumid and obj_num_id = cobjid; end loop; close "..." raise notice ?, l_script_name; update a3d_migration_tracking set validated = true where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); exception when others then call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); call pack_gtp_utils.p_trace_error (? || l_script_name, sqlerrm, ?); raise; end $body$;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 06 09 1 3m 3m [ User: a3dsupervisor - Total duration: 3m - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m - Times executed: 1 ]
-
DO $body$ DECLARE L_SCRIPT_NAME CONSTANT text := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID, ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (ga.att_template_num_id = gat.att_template_num_id) INNER JOIN GED_DOCUMENT ge ON (ga.OBJ_COMPO_VALUE::varchar = ge.document_num_id::varchar) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (tab.OBJ_COMPO_NUM_ID = ga.obj_compo_num_id_tab) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId varchar(100); cNewGedId bigint; BEGIN INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [START]', '7.23.0.0'); raise debug 'START %', L_SCRIPT_NAME; OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; EXIT WHEN NOT FOUND; SELECT gd.document_num_id INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (gei.node_num_id = gd.node_num_id) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id::varchar = cOldGedId; UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId::varchar WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; raise notice 'END %', L_SCRIPT_NAME; UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = true WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [SUCCESS]', '7.23.0.0'); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [ERROR]', '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR ('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.23.0.0'); RAISE; END $body$;
Date: 2026-03-06 08:54:18 Duration: 3m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1 2m20s 2m20s 2m20s 2m20s 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 Mar 06 08 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-06 07:59:23 Duration: 2m20s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1 2m2s 2m2s 2m2s 2m2s 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 Mar 06 08 1 2m2s 2m2s [ User: a3dsupervisor - Total duration: 2m2s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m2s - 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: 2026-03-06 07:57:03 Duration: 2m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 2m 2m 2m 2m 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 #8
Day Hour Count Duration Avg duration Mar 06 08 1 2m 2m [ User: a3dsupervisor - Total duration: 2m - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-06 07:59:26 Duration: 2m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 1m24s 1m24s 1m24s 1m24s 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 #9
Day Hour Count Duration Avg duration Mar 06 09 1 1m24s 1m24s [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m24s - 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: 2026-03-06 08:03:33 Duration: 1m24s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 1m11s 1m11s 1m11s 1m11s 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 #10
Day Hour Count Duration Avg duration Mar 06 09 1 1m11s 1m11s [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m11s - 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: 2026-03-06 08:06:40 Duration: 1m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 1m9s 1m9s 1m9s 1m9s create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 06 09 1 1m9s 1m9s [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m9s - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-06 08:03:50 Duration: 1m9s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 1m1s 1m1s 1m1s 1m1s 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, batch_process_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 06 08 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - 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, batch_process_num_id) FROM stdin;
Date: 2026-03-06 07:56:03 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 56s395ms 56s395ms 56s395ms 56s395ms create index i_fk_monthly_history_unit on public.gtp_monthly_history using btree (att_unit_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 06 09 1 56s395ms 56s395ms [ User: a3dsupervisor - Total duration: 56s395ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 56s395ms - Times executed: 1 ]
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-03-06 08:01:33 Duration: 56s395ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 52s56ms 52s56ms 52s56ms 52s56ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 06 08 1 52s56ms 52s56ms [ User: a3dsupervisor - Total duration: 52s56ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 52s56ms - 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: 2026-03-06 07:56:57 Duration: 52s56ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 47s750ms 47s750ms 47s750ms 47s750ms 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 #15
Day Hour Count Duration Avg duration Mar 06 09 1 47s750ms 47s750ms [ User: a3dsupervisor - Total duration: 47s750ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s750ms - 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: 2026-03-06 08:07:40 Duration: 47s750ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 47s600ms 47s600ms 47s600ms 47s600ms 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 Mar 06 09 1 47s600ms 47s600ms [ User: a3dsupervisor - Total duration: 47s600ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s600ms - 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: 2026-03-06 08:05:28 Duration: 47s600ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 43s98ms 43s98ms 43s98ms 43s98ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 06 09 1 43s98ms 43s98ms [ User: a3dsupervisor - Total duration: 43s98ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 43s98ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-03-06 08:00:07 Duration: 43s98ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 40s241ms 40s241ms 40s241ms 40s241ms create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 06 09 1 40s241ms 40s241ms [ User: a3dsupervisor - Total duration: 40s241ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 40s241ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-03-06 08:00:06 Duration: 40s241ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 38s308ms 38s308ms 38s308ms 38s308ms create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 06 09 1 38s308ms 38s308ms [ User: a3dsupervisor - Total duration: 38s308ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s308ms - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-03-06 08:05:24 Duration: 38s308ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 37s590ms 37s590ms 37s590ms 37s590ms 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 #20
Day Hour Count Duration Avg duration Mar 06 09 1 37s590ms 37s590ms [ User: a3dsupervisor - Total duration: 37s590ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s590ms - 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: 2026-03-06 08:00:44 Duration: 37s590ms 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 7m22s 7m22s 7m22s 1 7m22s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 09 1 7m22s 7m22s [ User: a3dsupervisor - Total duration: 7m22s - Times executed: 1 ]
[ Application: psql - Total duration: 7m22s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2026-03-06 08:50:11 Duration: 7m22s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 3m 3m 3m 1 3m do $body$ declare l_script_name constant text := ?; cursel cursor for select distinct ga.obj_compo_num_id, ga.obj_num_id, ga.obj_compo_value from gtp_obj_composition ga inner join gtp_att_template gat on (ga.att_template_num_id = gat.att_template_num_id) inner join ged_document ge on (ga.obj_compo_value::varchar = ge.document_num_id::varchar) left join gtp_obj_composition tab on (tab.obj_compo_num_id = ga.obj_compo_num_id_tab) where gat.att_template_domain_code = ?; ccomponumid bigint; cobjid bigint; coldgedid varchar(?); cnewgedid bigint; begin insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); raise debug ?, l_script_name; open cursel; loop fetch next from "..." into ccomponumid, cobjid, coldgedid; exit when not found; select gd.document_num_id into cnewgedid from ged_document gd inner join ged_document gei on (gei.node_num_id = gd.node_num_id) where gd.document_num_id_version is null and gei.document_num_id::varchar = coldgedid; update gtp_obj_composition set obj_compo_value = cnewgedid::varchar where obj_compo_num_id = ccomponumid and obj_num_id = cobjid; end loop; close "..." raise notice ?, l_script_name; update a3d_migration_tracking set validated = true where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); exception when others then call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); call pack_gtp_utils.p_trace_error (? || l_script_name, sqlerrm, ?); raise; end $body$;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 09 1 3m 3m [ User: a3dsupervisor - Total duration: 3m - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m - Times executed: 1 ]
-
DO $body$ DECLARE L_SCRIPT_NAME CONSTANT text := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID, ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (ga.att_template_num_id = gat.att_template_num_id) INNER JOIN GED_DOCUMENT ge ON (ga.OBJ_COMPO_VALUE::varchar = ge.document_num_id::varchar) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (tab.OBJ_COMPO_NUM_ID = ga.obj_compo_num_id_tab) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId varchar(100); cNewGedId bigint; BEGIN INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [START]', '7.23.0.0'); raise debug 'START %', L_SCRIPT_NAME; OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; EXIT WHEN NOT FOUND; SELECT gd.document_num_id INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (gei.node_num_id = gd.node_num_id) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id::varchar = cOldGedId; UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId::varchar WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; raise notice 'END %', L_SCRIPT_NAME; UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = true WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0'; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [SUCCESS]', '7.23.0.0'); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [ERROR]', '7.23.0.0'); CALL PACK_GTP_UTILS.P_TRACE_ERROR ('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.23.0.0'); RAISE; END $body$;
Date: 2026-03-06 08:54:18 Duration: 3m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m20s 2m20s 2m20s 1 2m20s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 06 08 1 2m20s 2m20s [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-06 07:59:23 Duration: 2m20s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 2m2s 2m2s 2m2s 1 2m2s 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 Mar 06 08 1 2m2s 2m2s [ User: a3dsupervisor - Total duration: 2m2s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m2s - 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: 2026-03-06 07:57:03 Duration: 2m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 2m 2m 2m 1 2m 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 Mar 06 08 1 2m 2m [ User: a3dsupervisor - Total duration: 2m - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-06 07:59:26 Duration: 2m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m24s 1m24s 1m24s 1 1m24s 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 #6
Day Hour Count Duration Avg duration Mar 06 09 1 1m24s 1m24s [ User: a3dsupervisor - Total duration: 1m24s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m24s - 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: 2026-03-06 08:03:33 Duration: 1m24s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m11s 1m11s 1m11s 1 1m11s 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 #7
Day Hour Count Duration Avg duration Mar 06 09 1 1m11s 1m11s [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m11s - 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: 2026-03-06 08:06:40 Duration: 1m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m9s 1m9s 1m9s 1 1m9s create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 06 09 1 1m9s 1m9s [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m9s - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-06 08:03:50 Duration: 1m9s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m1s 1m1s 1m1s 1 1m1s 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, batch_process_num_id) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 06 08 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m1s - 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, batch_process_num_id) FROM stdin;
Date: 2026-03-06 07:56:03 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 56s395ms 56s395ms 56s395ms 1 56s395ms create index i_fk_monthly_history_unit on public.gtp_monthly_history using btree (att_unit_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 06 09 1 56s395ms 56s395ms [ User: a3dsupervisor - Total duration: 56s395ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 56s395ms - Times executed: 1 ]
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-03-06 08:01:33 Duration: 56s395ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 52s56ms 52s56ms 52s56ms 1 52s56ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 06 08 1 52s56ms 52s56ms [ User: a3dsupervisor - Total duration: 52s56ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 52s56ms - 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: 2026-03-06 07:56:57 Duration: 52s56ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 47s750ms 47s750ms 47s750ms 1 47s750ms 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 #12
Day Hour Count Duration Avg duration Mar 06 09 1 47s750ms 47s750ms [ User: a3dsupervisor - Total duration: 47s750ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s750ms - 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: 2026-03-06 08:07:40 Duration: 47s750ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 47s600ms 47s600ms 47s600ms 1 47s600ms 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 #13
Day Hour Count Duration Avg duration Mar 06 09 1 47s600ms 47s600ms [ User: a3dsupervisor - Total duration: 47s600ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 47s600ms - 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: 2026-03-06 08:05:28 Duration: 47s600ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 43s98ms 43s98ms 43s98ms 1 43s98ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 06 09 1 43s98ms 43s98ms [ User: a3dsupervisor - Total duration: 43s98ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 43s98ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-03-06 08:00:07 Duration: 43s98ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 40s241ms 40s241ms 40s241ms 1 40s241ms create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 06 09 1 40s241ms 40s241ms [ User: a3dsupervisor - Total duration: 40s241ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 40s241ms - Times executed: 1 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-03-06 08:00:06 Duration: 40s241ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 38s308ms 38s308ms 38s308ms 1 38s308ms create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 06 09 1 38s308ms 38s308ms [ User: a3dsupervisor - Total duration: 38s308ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 38s308ms - Times executed: 1 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-03-06 08:05:24 Duration: 38s308ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 37s590ms 37s590ms 37s590ms 1 37s590ms 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 #17
Day Hour Count Duration Avg duration Mar 06 09 1 37s590ms 37s590ms [ User: a3dsupervisor - Total duration: 37s590ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 37s590ms - 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: 2026-03-06 08:00:44 Duration: 37s590ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 35s316ms 35s316ms 35s316ms 1 35s316ms 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 Mar 06 09 1 35s316ms 35s316ms [ User: a3dsupervisor - Total duration: 35s316ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 35s316ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-03-06 08:02:08 Duration: 35s316ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 34s754ms 34s754ms 34s754ms 1 34s754ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_template foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) deferrable initially deferred;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 06 09 1 34s754ms 34s754ms [ User: a3dsupervisor - Total duration: 34s754ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 34s754ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-06 08:02:40 Duration: 34s754ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 32s995ms 32s995ms 32s995ms 1 32s995ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 06 09 1 32s995ms 32s995ms [ User: a3dsupervisor - Total duration: 32s995ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 32s995ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2026-03-06 08:04:38 Duration: 32s995ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s774ms 1 5s774ms 5s774ms 5s774ms select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = $1 order by gsbp1_0.SETTING_NUM_ID desc;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Mar 06 07 1 5s774ms 5s774ms [ User: a3dsupervisor - Total duration: 3s70ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s70ms - Times executed: 1 ]
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2026-03-06 06:47:52 Duration: 5s774ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 989 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 40 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 24 Max number of times the same event was reported
- 42 Total events found
Rank Times reported Error 1 24 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 06 09 24 2 4 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 06 17 2 19 2 3 2 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 06 12 2 4 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 06 09 1 5 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (...) REFERENCES public.gtp_obj(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 06 09 1 6 1 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 06 09 1 7 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 #7
Day Hour Count Mar 06 09 1 8 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 #8
Day Hour Count Mar 06 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 Mar 06 09 1 10 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_doc_deleted
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 06 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 Mar 06 09 1 12 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 #12
Day Hour Count Mar 06 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 Mar 06 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 Mar 06 09 1 15 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 #15
Day Hour Count Mar 06 09 1