pgBadger-
Global information
- Generated on Fri Mar 6 09:01:13 2026
- Log file: ././A3D-RND-PIC/y=2026/m=03/d=05/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2026/m=03/d=05/h=23/m=00/PT1H.log
- Parsed 566 log entries in 54s
- Log start from 2026-03-05 08:10:19 to 2026-03-05 09:43:05
-
Overview
Global Stats
- 70 Number of unique normalized queries
- 87 Number of queries
- 1h29m53s Total query duration
- 2026-03-05 08:02:57 First query
- 2026-03-05 09:43:46 Last query
- 2 queries/s at 2026-03-05 08:16:49 Query peak
- 1h29m53s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h29m53s Execute total duration
- 2 Number of events
- 2 Number of unique normalized events
- 1 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
- 172 Number temporary file
- 1.32 GiB Max size of temporary file
- 24.56 MiB Average size of temporary file
- 64 Total number of sessions
- 27 sessions at 2026-03-05 08:56:30 Session peak
- 2h53m55s Total duration of sessions
- 2m43s Average duration of sessions
- 1 Average queries per session
- 1m24s Average queries duration per session
- 1m18s Average idle time per session
- 64 Total number of connections
- 2 connections/s at 2026-03-05 08:02:29 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-05 08:16:49 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-05 08:40:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-05 08:16:49 Date
Queries duration
Key values
- 1h29m53s 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 05 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 0 0ms 0ms 0ms 0ms 0ms 0ms 08 84 0ms 4m16s 21s859ms 2m43s 4m16s 8m15s 09 3 0ms 35m24s 19m45s 23m52s 35m24s 35m24s 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 05 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 28 0 5s160ms 8s136ms 11s787ms 40s490ms 09 0 1 4s524ms 0ms 0ms 4s524ms 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 05 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 8 34s272ms 0ms 0ms 44s790ms 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 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 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 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 05 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 2 0.00/s 07 2 0.00/s 08 9 0.00/s 09 7 0.00/s 10 6 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Mar 05 00 2 57ms 57ms 01 2 52ms 52ms 02 2 60ms 60ms 03 2 56ms 56ms 04 2 53ms 53ms 05 2 58ms 58ms 06 2 100ms 100ms 07 2 138ms 138ms 08 8 10m24s 6m35s 09 7 8m28s 431ms 10 7 4m27s 4m27s 11 2 52ms 52ms 12 2 58ms 58ms 13 2 55ms 55ms 14 2 54ms 54ms 15 2 56ms 56ms 16 2 62ms 62ms 17 2 53ms 53ms 18 2 59ms 59ms 19 2 63ms 63ms 20 2 57ms 57ms 21 2 53ms 53ms 22 2 55ms 55ms 23 2 67ms 67ms -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2026-03-05 08:02:29 Date
Connections per database
Key values
- reftkbim Main Database
- 64 connections Total
Connections per user
Key values
- azuresu Main User
- 64 connections Total
-
Sessions
Simultaneous sessions
Key values
- 27 sessions Session Peak
- 2026-03-05 08:56:30 Date
Histogram of session times
Key values
- 51 0-500ms duration
Sessions per database
Key values
- reftkbim Main Database
- 64 sessions Total
Sessions per user
Key values
- azuresu Main User
- 64 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 64 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 294.66 MiB Temp Files size Peak
- 2026-03-05 08:08:50 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-03-05 09:39:45 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 78 2.81 GiB 36.86 MiB 09 94 1.32 GiB 14.36 MiB 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 2 111.85 MiB 45.32 MiB 66.53 MiB 55.93 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-05 08:17:51 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 2 594.59 MiB 88.82 MiB 505.77 MiB 297.29 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-05 08:08:34 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 2 20.34 MiB 10.06 MiB 10.27 MiB 10.17 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-05 08:15:47 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 2 413.91 MiB 55.93 MiB 357.98 MiB 206.96 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-05 08:03:53 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 2 234.82 MiB 25.98 MiB 208.84 MiB 117.41 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-05 08:16:41 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 2 174.92 MiB 3.66 MiB 171.27 MiB 87.46 MiB add constraint pk_l_notification_user primary key (nous_user_num_id, nous_noti_id);-
ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);
Date: 2026-03-05 08:18:09 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 2 78.81 MiB 32.18 MiB 46.63 MiB 39.41 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-05 08:15:30 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 35.84 MiB 35.84 MiB 35.84 MiB 35.84 MiB add constraint fk_gtp_cw_eng_alert foreign key (history_num_id) references public.gtp_cw_eng_history (history_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_cw_eng_alert FOREIGN KEY (history_num_id) REFERENCES public.gtp_cw_eng_history (history_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:15:50 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 199.16 MiB 199.16 MiB 199.16 MiB 199.16 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-05 08:15:59 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 294.66 MiB 294.66 MiB 294.66 MiB 294.66 MiB add constraint fk_gtp_relation_rel_template foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_relation_rel_template FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:08:50 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 536.27 MiB 536.27 MiB 536.27 MiB 536.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-05 08:14:49 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 536.27 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-03-05 08:14:49 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 505.77 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-05 08:08:34 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 357.98 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-05 08:03:53 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 294.66 MiB ADD CONSTRAINT fk_gtp_relation_rel_template FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-05 08:08:50 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 208.84 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-03-05 08:16:41 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 199.16 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-05 08:15:59 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 171.27 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2026-03-05 08:18:09 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 88.82 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-05 08:14:13 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 66.53 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-05 08:17:51 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 55.93 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-05 08:04:38 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 46.63 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2026-03-05 08:15:30 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 45.32 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-05 08:17:51 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 35.84 MiB ADD CONSTRAINT fk_gtp_cw_eng_alert FOREIGN KEY (history_num_id) REFERENCES public.gtp_cw_eng_history (history_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-05 08:15:50 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 32.18 MiB ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);[ Date: 2026-03-05 08:15:30 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 25.98 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-03-05 08:17:32 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 10.27 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2026-03-05 08:15:47 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 10.06 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2026-03-05 08:15:47 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 3.66 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2026-03-05 08:18:32 - Database: reftkbim - 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 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareUpdateExclusiveLock Main Lock Type
- 2 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
- 28 Total read queries
- 57 Total write queries
Queries by database
Key values
- reftkbim Main database
- 87 Requests
- 1h29m53s (reftkbim)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 87 Requests
User Request type Count Duration a3dsupervisor Total 87 1h29m53s copy from 8 4m34s copy to 1 4s524ms ddl 46 23m26s others 2 59m12s select 28 2m24s tcl 2 10s537ms Duration by user
Key values
- 1h29m53s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 87 1h29m53s copy from 8 4m34s copy to 1 4s524ms ddl 46 23m26s others 2 59m12s select 28 2m24s tcl 2 10s537ms Queries by host
Key values
- 10.3.0.4 Main host
- 87 Requests
- 1h29m53s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 84 Requests
- 59m12s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-05 08:11:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 55 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 35m24s DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;[ Date: 2026-03-05 09:19:16 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 23m47s VACUUM FULL;[ Date: 2026-03-05 09:43:05 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 4m16s CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);[ Date: 2026-03-05 08:12:51 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 4m10s CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2026-03-05 08:08:50 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 4m4s CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2026-03-05 08:08:34 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 2m 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: 2026-03-05 08:04:29 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 1m34s ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_gtp_obj_compo_history_new_unit FOREIGN KEY (obj_compo_new_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-05 08:14:52 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 1m21s ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-05 08:14:13 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 59s18ms ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_unit FOREIGN KEY (obj_compo_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-05 08:13:18 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 44s790ms 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-05 08:03:45 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 31s670ms COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;[ Date: 2026-03-05 08:09:22 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 29s404ms CREATE INDEX i_gtp_cw_eng_date ON public.gtp_cw_eng_history USING btree (history_date);[ Date: 2026-03-05 08:11:09 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 28s390ms 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-05 08:02:57 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 25s440ms CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2026-03-05 08:17:23 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 25s440ms 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-05 08:14:41 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 24s317ms 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: 2026-03-05 08:15:16 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 23s350ms 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-05 08:15:59 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 20s765ms CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));[ Date: 2026-03-05 08:17:14 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 20s335ms ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-05 08:04:39 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 17s979ms ALTER TABLE ONLY public.gtp_cw_eng_history ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2026-03-05 08:15:48 - Database: reftkbim - 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 35m24s 1 35m24s 35m24s 35m24s do $$ declare v_start time; v_stop time; l_anonymize_flags integer := current_setting(?); l_reduce_history integer := current_setting(?); l_truncate integer := current_setting(?); l_anonymize_list text[] := array[?, ?, ?, ?, ?, ?, ?, ?]; i int; begin raise notice ?; raise notice ?, l_anonymize_flags; raise notice ?, l_reduce_history; call pack_gtp_utils.p_trace_log (?, ?); v_start := clock_timestamp()::time; if (l_truncate > ?) then raise notice ?; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice ?; end if; for i in ?..array_length(l_anonymize_list, ?) loop if (l_anonymize_flags & (? << (i - ?))) = (? << (i - ?)) then raise notice ?, l_anonymize_list[i]; execute ? || l_anonymize_list[i] || ?; raise notice ?, l_anonymize_list[i]; end if; end loop; if (l_reduce_history > ?) then raise notice ?; delete from gtp_history_obj_action where action_date < current_date - ?; delete from gtp_monthly_history where histo_dcre < current_date - ?; raise notice ?; end if; v_stop := clock_timestamp()::time; raise notice ?, extract(millisecond from (v_stop - v_start)); raise notice ?; call pack_gtp_utils.p_trace_log (?, ?); exception when others then raise notice ?, sqlstate, sqlerrm; call pack_gtp_utils.p_trace_error (?, sqlerrm); end $$;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 05 10 1 35m24s 35m24s [ User: a3dsupervisor - Total duration: 35m24s - Times executed: 1 ]
[ Application: psql - Total duration: 35m24s - Times executed: 1 ]
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-05 09:19:16 Duration: 35m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 23m47s 1 23m47s 23m47s 23m47s vacuum full;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 05 10 1 23m47s 23m47s [ User: a3dsupervisor - Total duration: 23m47s - Times executed: 1 ]
[ Application: psql - Total duration: 23m47s - Times executed: 1 ]
-
VACUUM FULL;
Date: 2026-03-05 09:43:05 Duration: 23m47s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4m16s 1 4m16s 4m16s 4m16s create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 05 09 1 4m16s 4m16s [ User: a3dsupervisor - Total duration: 4m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m16s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-05 08:12:51 Duration: 4m16s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 4m10s 1 4m10s 4m10s 4m10s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 05 09 1 4m10s 4m10s [ User: a3dsupervisor - Total duration: 4m10s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m10s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-05 08:08:50 Duration: 4m10s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 4m4s 1 4m4s 4m4s 4m4s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 05 09 1 4m4s 4m4s [ User: a3dsupervisor - Total duration: 4m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m4s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-05 08:08:34 Duration: 4m4s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 2m24s 28 3s5ms 10s590ms 5s160ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 05 09 28 2m24s 5s160ms [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 28 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 28 ]
-
SELECT pg_catalog.lo_create('2396933');
Date: 2026-03-05 08:35:18 Duration: 10s590ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2396802');
Date: 2026-03-05 08:34:24 Duration: 8s42ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2397007');
Date: 2026-03-05 08:35:51 Duration: 6s694ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 2m 1 2m 2m 2m 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 #7
Day Hour Count Duration Avg duration Mar 05 09 1 2m 2m [ User: a3dsupervisor - Total duration: 2m - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m - 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: 2026-03-05 08:04:29 Duration: 2m Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m34s 1 1m34s 1m34s 1m34s alter table only public.gtp_history_obj_compo add constraint fk_gtp_obj_compo_history_new_unit foreign key (obj_compo_new_unit_num_id) references public.gtp_att_unit (att_unit_num_id) deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 05 09 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m34s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_gtp_obj_compo_history_new_unit FOREIGN KEY (obj_compo_new_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:14:52 Duration: 1m34s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m21s 1 1m21s 1m21s 1m21s alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 05 09 1 1m21s 1m21s [ User: a3dsupervisor - Total duration: 1m21s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m21s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-05 08:14:13 Duration: 1m21s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 59s18ms 1 59s18ms 59s18ms 59s18ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_unit foreign key (obj_compo_unit_num_id) references public.gtp_att_unit (att_unit_num_id) deferrable initially deferred;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 05 09 1 59s18ms 59s18ms [ User: a3dsupervisor - Total duration: 59s18ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 59s18ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_unit FOREIGN KEY (obj_compo_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:13:18 Duration: 59s18ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 44s790ms 1 44s790ms 44s790ms 44s790ms 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 05 09 1 44s790ms 44s790ms [ User: a3dsupervisor - Total duration: 44s790ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 44s790ms - 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-05 08:03:45 Duration: 44s790ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 31s670ms 1 31s670ms 31s670ms 31s670ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 05 09 1 31s670ms 31s670ms [ User: a3dsupervisor - Total duration: 31s670ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s670ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2026-03-05 08:09:22 Duration: 31s670ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 29s404ms 1 29s404ms 29s404ms 29s404ms create index i_gtp_cw_eng_date on public.gtp_cw_eng_history using btree (history_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 05 09 1 29s404ms 29s404ms [ User: a3dsupervisor - Total duration: 29s404ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s404ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_cw_eng_date ON public.gtp_cw_eng_history USING btree (history_date);
Date: 2026-03-05 08:11:09 Duration: 29s404ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 28s390ms 1 28s390ms 28s390ms 28s390ms 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 #14
Day Hour Count Duration Avg duration Mar 05 09 1 28s390ms 28s390ms [ User: a3dsupervisor - Total duration: 28s390ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 28s390ms - 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-05 08:02:57 Duration: 28s390ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 25s440ms 1 25s440ms 25s440ms 25s440ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 25s440ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s440ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 08:17:23 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 25s440ms 1 25s440ms 25s440ms 25s440ms 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 #16
Day Hour Count Duration Avg duration Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 25s440ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s440ms - 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-05 08:14:41 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 24s317ms 1 24s317ms 24s317ms 24s317ms 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 #17
Day Hour Count Duration Avg duration Mar 05 09 1 24s317ms 24s317ms [ User: a3dsupervisor - Total duration: 24s317ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s317ms - 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: 2026-03-05 08:15:16 Duration: 24s317ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 23s350ms 1 23s350ms 23s350ms 23s350ms 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 #18
Day Hour Count Duration Avg duration Mar 05 09 1 23s350ms 23s350ms [ User: a3dsupervisor - Total duration: 23s350ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s350ms - 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-05 08:15:59 Duration: 23s350ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 20s765ms 1 20s765ms 20s765ms 20s765ms create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 05 09 1 20s765ms 20s765ms [ User: a3dsupervisor - Total duration: 20s765ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s765ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-05 08:17:14 Duration: 20s765ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 20s335ms 1 20s335ms 20s335ms 20s335ms alter table only public.gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 05 09 1 20s335ms 20s335ms [ User: a3dsupervisor - Total duration: 20s335ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s335ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-05 08:04:39 Duration: 20s335ms Database: reftkbim 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 28 2m24s 3s5ms 10s590ms 5s160ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 05 09 28 2m24s 5s160ms [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 28 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 28 ]
-
SELECT pg_catalog.lo_create('2396933');
Date: 2026-03-05 08:35:18 Duration: 10s590ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2396802');
Date: 2026-03-05 08:34:24 Duration: 8s42ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2397007');
Date: 2026-03-05 08:35:51 Duration: 6s694ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 2 10s537ms 4s369ms 6s168ms 5s268ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 05 09 2 10s537ms 5s268ms [ User: a3dsupervisor - Total duration: 10s537ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 10s537ms - Times executed: 2 ]
-
COMMIT;
Date: 2026-03-05 08:36:28 Duration: 6s168ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COMMIT;
Date: 2026-03-05 08:17:37 Duration: 4s369ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1 35m24s 35m24s 35m24s 35m24s do $$ declare v_start time; v_stop time; l_anonymize_flags integer := current_setting(?); l_reduce_history integer := current_setting(?); l_truncate integer := current_setting(?); l_anonymize_list text[] := array[?, ?, ?, ?, ?, ?, ?, ?]; i int; begin raise notice ?; raise notice ?, l_anonymize_flags; raise notice ?, l_reduce_history; call pack_gtp_utils.p_trace_log (?, ?); v_start := clock_timestamp()::time; if (l_truncate > ?) then raise notice ?; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice ?; end if; for i in ?..array_length(l_anonymize_list, ?) loop if (l_anonymize_flags & (? << (i - ?))) = (? << (i - ?)) then raise notice ?, l_anonymize_list[i]; execute ? || l_anonymize_list[i] || ?; raise notice ?, l_anonymize_list[i]; end if; end loop; if (l_reduce_history > ?) then raise notice ?; delete from gtp_history_obj_action where action_date < current_date - ?; delete from gtp_monthly_history where histo_dcre < current_date - ?; raise notice ?; end if; v_stop := clock_timestamp()::time; raise notice ?, extract(millisecond from (v_stop - v_start)); raise notice ?; call pack_gtp_utils.p_trace_log (?, ?); exception when others then raise notice ?, sqlstate, sqlerrm; call pack_gtp_utils.p_trace_error (?, sqlerrm); end $$;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 05 10 1 35m24s 35m24s [ User: a3dsupervisor - Total duration: 35m24s - Times executed: 1 ]
[ Application: psql - Total duration: 35m24s - Times executed: 1 ]
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-05 09:19:16 Duration: 35m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1 23m47s 23m47s 23m47s 23m47s vacuum full;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 05 10 1 23m47s 23m47s [ User: a3dsupervisor - Total duration: 23m47s - Times executed: 1 ]
[ Application: psql - Total duration: 23m47s - Times executed: 1 ]
-
VACUUM FULL;
Date: 2026-03-05 09:43:05 Duration: 23m47s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1 4m16s 4m16s 4m16s 4m16s create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 05 09 1 4m16s 4m16s [ User: a3dsupervisor - Total duration: 4m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m16s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-05 08:12:51 Duration: 4m16s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1 4m10s 4m10s 4m10s 4m10s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 05 09 1 4m10s 4m10s [ User: a3dsupervisor - Total duration: 4m10s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m10s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-05 08:08:50 Duration: 4m10s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1 4m4s 4m4s 4m4s 4m4s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 05 09 1 4m4s 4m4s [ User: a3dsupervisor - Total duration: 4m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m4s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-05 08:08:34 Duration: 4m4s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1 2m 2m 2m 2m 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 #8
Day Hour Count Duration Avg duration Mar 05 09 1 2m 2m [ User: a3dsupervisor - Total duration: 2m - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m - 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: 2026-03-05 08:04:29 Duration: 2m Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1 1m34s 1m34s 1m34s 1m34s alter table only public.gtp_history_obj_compo add constraint fk_gtp_obj_compo_history_new_unit foreign key (obj_compo_new_unit_num_id) references public.gtp_att_unit (att_unit_num_id) deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 05 09 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m34s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_gtp_obj_compo_history_new_unit FOREIGN KEY (obj_compo_new_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:14:52 Duration: 1m34s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1 1m21s 1m21s 1m21s 1m21s alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 05 09 1 1m21s 1m21s [ User: a3dsupervisor - Total duration: 1m21s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m21s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-05 08:14:13 Duration: 1m21s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1 59s18ms 59s18ms 59s18ms 59s18ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_unit foreign key (obj_compo_unit_num_id) references public.gtp_att_unit (att_unit_num_id) deferrable initially deferred;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 05 09 1 59s18ms 59s18ms [ User: a3dsupervisor - Total duration: 59s18ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 59s18ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_unit FOREIGN KEY (obj_compo_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:13:18 Duration: 59s18ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1 44s790ms 44s790ms 44s790ms 44s790ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 05 09 1 44s790ms 44s790ms [ User: a3dsupervisor - Total duration: 44s790ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 44s790ms - 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-05 08:03:45 Duration: 44s790ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1 31s670ms 31s670ms 31s670ms 31s670ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 05 09 1 31s670ms 31s670ms [ User: a3dsupervisor - Total duration: 31s670ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s670ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2026-03-05 08:09:22 Duration: 31s670ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1 29s404ms 29s404ms 29s404ms 29s404ms create index i_gtp_cw_eng_date on public.gtp_cw_eng_history using btree (history_date);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 05 09 1 29s404ms 29s404ms [ User: a3dsupervisor - Total duration: 29s404ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s404ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_cw_eng_date ON public.gtp_cw_eng_history USING btree (history_date);
Date: 2026-03-05 08:11:09 Duration: 29s404ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1 28s390ms 28s390ms 28s390ms 28s390ms 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 #15
Day Hour Count Duration Avg duration Mar 05 09 1 28s390ms 28s390ms [ User: a3dsupervisor - Total duration: 28s390ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 28s390ms - 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-05 08:02:57 Duration: 28s390ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1 25s440ms 25s440ms 25s440ms 25s440ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 25s440ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s440ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 08:17:23 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 25s440ms 25s440ms 25s440ms 25s440ms 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 #17
Day Hour Count Duration Avg duration Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 25s440ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s440ms - 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-05 08:14:41 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 24s317ms 24s317ms 24s317ms 24s317ms 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 #18
Day Hour Count Duration Avg duration Mar 05 09 1 24s317ms 24s317ms [ User: a3dsupervisor - Total duration: 24s317ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s317ms - 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: 2026-03-05 08:15:16 Duration: 24s317ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 23s350ms 23s350ms 23s350ms 23s350ms 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 #19
Day Hour Count Duration Avg duration Mar 05 09 1 23s350ms 23s350ms [ User: a3dsupervisor - Total duration: 23s350ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s350ms - 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-05 08:15:59 Duration: 23s350ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 20s765ms 20s765ms 20s765ms 20s765ms create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 05 09 1 20s765ms 20s765ms [ User: a3dsupervisor - Total duration: 20s765ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s765ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-05 08:17:14 Duration: 20s765ms Database: reftkbim 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 35m24s 35m24s 35m24s 1 35m24s do $$ declare v_start time; v_stop time; l_anonymize_flags integer := current_setting(?); l_reduce_history integer := current_setting(?); l_truncate integer := current_setting(?); l_anonymize_list text[] := array[?, ?, ?, ?, ?, ?, ?, ?]; i int; begin raise notice ?; raise notice ?, l_anonymize_flags; raise notice ?, l_reduce_history; call pack_gtp_utils.p_trace_log (?, ?); v_start := clock_timestamp()::time; if (l_truncate > ?) then raise notice ?; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice ?; end if; for i in ?..array_length(l_anonymize_list, ?) loop if (l_anonymize_flags & (? << (i - ?))) = (? << (i - ?)) then raise notice ?, l_anonymize_list[i]; execute ? || l_anonymize_list[i] || ?; raise notice ?, l_anonymize_list[i]; end if; end loop; if (l_reduce_history > ?) then raise notice ?; delete from gtp_history_obj_action where action_date < current_date - ?; delete from gtp_monthly_history where histo_dcre < current_date - ?; raise notice ?; end if; v_stop := clock_timestamp()::time; raise notice ?, extract(millisecond from (v_stop - v_start)); raise notice ?; call pack_gtp_utils.p_trace_log (?, ?); exception when others then raise notice ?, sqlstate, sqlerrm; call pack_gtp_utils.p_trace_error (?, sqlerrm); end $$;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 05 10 1 35m24s 35m24s [ User: a3dsupervisor - Total duration: 35m24s - Times executed: 1 ]
[ Application: psql - Total duration: 35m24s - Times executed: 1 ]
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-05 09:19:16 Duration: 35m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 23m47s 23m47s 23m47s 1 23m47s vacuum full;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 05 10 1 23m47s 23m47s [ User: a3dsupervisor - Total duration: 23m47s - Times executed: 1 ]
[ Application: psql - Total duration: 23m47s - Times executed: 1 ]
-
VACUUM FULL;
Date: 2026-03-05 09:43:05 Duration: 23m47s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4m16s 4m16s 4m16s 1 4m16s create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 05 09 1 4m16s 4m16s [ User: a3dsupervisor - Total duration: 4m16s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m16s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-05 08:12:51 Duration: 4m16s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 4m10s 4m10s 4m10s 1 4m10s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 05 09 1 4m10s 4m10s [ User: a3dsupervisor - Total duration: 4m10s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m10s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-05 08:08:50 Duration: 4m10s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 4m4s 4m4s 4m4s 1 4m4s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 05 09 1 4m4s 4m4s [ User: a3dsupervisor - Total duration: 4m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 4m4s - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-05 08:08:34 Duration: 4m4s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 2m 2m 2m 1 2m copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 05 09 1 2m 2m [ User: a3dsupervisor - Total duration: 2m - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m - 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: 2026-03-05 08:04:29 Duration: 2m Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m34s 1m34s 1m34s 1 1m34s alter table only public.gtp_history_obj_compo add constraint fk_gtp_obj_compo_history_new_unit foreign key (obj_compo_new_unit_num_id) references public.gtp_att_unit (att_unit_num_id) deferrable initially deferred;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 05 09 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m34s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_gtp_obj_compo_history_new_unit FOREIGN KEY (obj_compo_new_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:14:52 Duration: 1m34s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m21s 1m21s 1m21s 1 1m21s alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 05 09 1 1m21s 1m21s [ User: a3dsupervisor - Total duration: 1m21s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 1m21s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-05 08:14:13 Duration: 1m21s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 59s18ms 59s18ms 59s18ms 1 59s18ms alter table only public.gtp_obj_composition add constraint fk_gtp_obj_compo_unit foreign key (obj_compo_unit_num_id) references public.gtp_att_unit (att_unit_num_id) deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 05 09 1 59s18ms 59s18ms [ User: a3dsupervisor - Total duration: 59s18ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 59s18ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_unit FOREIGN KEY (obj_compo_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:13:18 Duration: 59s18ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 44s790ms 44s790ms 44s790ms 1 44s790ms 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 #10
Day Hour Count Duration Avg duration Mar 05 09 1 44s790ms 44s790ms [ User: a3dsupervisor - Total duration: 44s790ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 44s790ms - 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-05 08:03:45 Duration: 44s790ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 31s670ms 31s670ms 31s670ms 1 31s670ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 05 09 1 31s670ms 31s670ms [ User: a3dsupervisor - Total duration: 31s670ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 31s670ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2026-03-05 08:09:22 Duration: 31s670ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 29s404ms 29s404ms 29s404ms 1 29s404ms create index i_gtp_cw_eng_date on public.gtp_cw_eng_history using btree (history_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 05 09 1 29s404ms 29s404ms [ User: a3dsupervisor - Total duration: 29s404ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 29s404ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_cw_eng_date ON public.gtp_cw_eng_history USING btree (history_date);
Date: 2026-03-05 08:11:09 Duration: 29s404ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 28s390ms 28s390ms 28s390ms 1 28s390ms 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 #13
Day Hour Count Duration Avg duration Mar 05 09 1 28s390ms 28s390ms [ User: a3dsupervisor - Total duration: 28s390ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 28s390ms - 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-05 08:02:57 Duration: 28s390ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 25s440ms 25s440ms 25s440ms 1 25s440ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 25s440ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s440ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 08:17:23 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 25s440ms 25s440ms 25s440ms 1 25s440ms 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 #15
Day Hour Count Duration Avg duration Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 25s440ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 25s440ms - 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-05 08:14:41 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 24s317ms 24s317ms 24s317ms 1 24s317ms 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 #16
Day Hour Count Duration Avg duration Mar 05 09 1 24s317ms 24s317ms [ User: a3dsupervisor - Total duration: 24s317ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 24s317ms - 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: 2026-03-05 08:15:16 Duration: 24s317ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 23s350ms 23s350ms 23s350ms 1 23s350ms 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 #17
Day Hour Count Duration Avg duration Mar 05 09 1 23s350ms 23s350ms [ User: a3dsupervisor - Total duration: 23s350ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 23s350ms - 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-05 08:15:59 Duration: 23s350ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 20s765ms 20s765ms 20s765ms 1 20s765ms create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 05 09 1 20s765ms 20s765ms [ User: a3dsupervisor - Total duration: 20s765ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s765ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-05 08:17:14 Duration: 20s765ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 20s335ms 20s335ms 20s335ms 1 20s335ms alter table only public.gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 05 09 1 20s335ms 20s335ms [ User: a3dsupervisor - Total duration: 20s335ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 20s335ms - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-05 08:04:39 Duration: 20s335ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 4s369ms 6s168ms 5s268ms 2 10s537ms commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 05 09 2 10s537ms 5s268ms [ User: a3dsupervisor - Total duration: 10s537ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 10s537ms - Times executed: 2 ]
-
COMMIT;
Date: 2026-03-05 08:36:28 Duration: 6s168ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COMMIT;
Date: 2026-03-05 08:17:37 Duration: 4s369ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 2 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 2 Total events found
Rank Times reported Error 1 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msCREATE STATISTICS public.stat_mcv_obj_compo_att (...) ON att_template_category_num_id, att_template_num_id FROM public.gtp_obj_composition
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 05 09 1 2 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msCREATE STATISTICS public.stat_dep_obj_compo_att (...) ON att_template_category_num_id, att_template_num_id FROM public.gtp_obj_composition
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 05 09 1