pgBadger-
Global information
- Generated on Mon Sep 22 15:59:36 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=19/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=19/h=23/m=00/PT1H.log
- Parsed 9,451 log entries in 2m27s
- Log start from 2025-09-19 15:52:33 to 2025-09-19 17:59:24
-
Overview
Global Stats
- 55 Number of unique normalized queries
- 62 Number of queries
- 16m28s Total query duration
- 2025-09-19 15:33:14 First query
- 2025-09-19 17:57:27 Last query
- 2 queries/s at 2025-09-19 15:34:33 Query peak
- 16m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 16m28s Execute total duration
- 4,297 Number of events
- 17 Number of unique normalized events
- 4,264 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
- 343 Number temporary file
- 611.12 MiB Max size of temporary file
- 17.46 MiB Average size of temporary file
- 128 Total number of sessions
- 29 sessions at 2025-09-19 16:14:45 Session peak
- 4h30m3s Total duration of sessions
- 2m6s Average duration of sessions
- 0 Average queries per session
- 7s721ms Average queries duration per session
- 1m58s Average idle time per session
- 128 Total number of connections
- 10 connections/s at 2025-09-19 16:12:26 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-19 15:34:33 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-19 15:34:33 Date
Queries duration
Key values
- 16m28s 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) Sep 19 15 34 0ms 1m34s 16s736ms 1m55s 2m19s 2m19s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 28 0ms 57s511ms 14s975ms 1m53s 2m11s 2m11s 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) Sep 19 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) Sep 19 15 0 0 0 7 23s560ms 0ms 20s575ms 1m28s 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 6 26s165ms 0ms 12s342ms 1m26s 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 Sep 19 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 Sep 19 15 10 0.00/s 16 86 0.02/s 17 20 0.01/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 Sep 19 15 10 3m40s 2m43s 16 84 52s171ms 52s171ms 17 20 5m38s 5m17s 18 4 11m53s 11m53s 19 2 69ms 69ms 20 2 104ms 104ms 21 2 69ms 69ms 22 2 68ms 68ms 23 2 68ms 68ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-09-19 16:12:26 Date
Connections per database
Key values
- reftk_feat_batch Main Database
- 128 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 128 connections Total
-
Sessions
Simultaneous sessions
Key values
- 29 sessions Session Peak
- 2025-09-19 16:14:45 Date
Histogram of session times
Key values
- 53 1000-30000ms duration
Sessions per database
Key values
- reftk_feat_batch Main Database
- 128 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 128 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 128 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 202.19 MiB Temp Files size Peak
- 2025-09-19 15:34:30 Date
Number of temporary files
Key values
- 8 per second Temp Files Peak
- 2025-09-19 17:57:35 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 19 15 175 3.02 GiB 17.70 MiB 16 1 4.33 MiB 4.33 MiB 17 167 2.82 GiB 17.30 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 6 134.59 MiB 4.90 MiB 66.67 MiB 22.43 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-09-19 17:57:23 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 6 813.91 MiB 37.66 MiB 327.27 MiB 135.65 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 17:54:13 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 6 179.16 MiB 10.30 MiB 84.22 MiB 29.86 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-09-19 17:57:13 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 6 827.12 MiB 30.66 MiB 348.02 MiB 137.85 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-19 17:53:24 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 6 50.91 MiB 3.80 MiB 25.95 MiB 8.48 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-09-19 17:57:33 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 6 1.22 GiB 25.07 MiB 611.12 MiB 207.99 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-19 17:54:52 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 6 398.36 MiB 56.69 MiB 80.06 MiB 66.39 MiB add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);-
ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-19 17:56:08 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 6 562.67 MiB 4.05 MiB 493.75 MiB 93.78 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2025-09-19 17:54:21 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 6 198.28 MiB 4.55 MiB 89.53 MiB 33.05 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-19 17:57:31 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 6 223.54 MiB 32.30 MiB 40.65 MiB 37.26 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-19 17:56:49 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 6 410.38 MiB 17.92 MiB 196.57 MiB 68.40 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-09-19 17:56:31 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 6 26.30 MiB 2.53 MiB 6.06 MiB 4.38 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-09-19 17:57:42 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 44.68 MiB 2.19 MiB 23.71 MiB 8.94 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2025-09-19 17:57:35 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3 36.16 MiB 2.81 MiB 24.49 MiB 12.05 MiB add constraint pk_pe_consumption_hourly primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_hourly PRIMARY KEY (consumption_num_id);
Date: 2025-09-19 17:57:38 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3 78.82 MiB 22.70 MiB 29.44 MiB 26.27 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-19 15:37:38 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 3 17.59 MiB 4.12 MiB 8.23 MiB 5.86 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-09-19 15:37:00 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 540.15 MiB 540.15 MiB 540.15 MiB 540.15 MiB add constraint uk_setting_code_user unique (setting_code, user_num_id);-
ADD CONSTRAINT uk_setting_code_user UNIQUE (setting_code, user_num_id);
Date: 2025-09-19 15:34:59 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 67.16 MiB 67.16 MiB 67.16 MiB 67.16 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-09-19 15:36:25 Duration: 0ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 611.12 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-19 17:54:52 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 540.15 MiB ADD CONSTRAINT uk_setting_code_user UNIQUE (setting_code, user_num_id);[ Date: 2025-09-19 15:34:59 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 533.50 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-19 15:34:30 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 493.75 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-09-19 17:54:21 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 348.02 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-19 15:33:24 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 344.39 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-19 17:53:24 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 327.27 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-19 17:54:13 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 326.28 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-19 15:34:13 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 196.57 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-19 15:36:26 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 136.60 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-19 17:56:31 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 89.53 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-19 17:57:31 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 87.07 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-19 15:37:05 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 84.22 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-09-19 17:57:13 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 80.06 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-19 17:56:08 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 72.80 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-19 15:36:18 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 69.70 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-19 15:36:18 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 67.16 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-09-19 15:36:25 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 66.67 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-09-19 17:57:23 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 60.50 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-19 17:56:08 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 58.62 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-19 17:56:08 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 19 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
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 0 Total read queries
- 61 Total write queries
Queries by database
Key values
- reftk_feat_batch Main database
- 62 Requests
- 16m28s (reftk_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 124 Requests
User Request type Count Duration a3dsupervisor Total 124 32m56s copy from 26 10m43s ddl 96 19m3s others 2 3m9s Duration by user
Key values
- 32m56s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 124 32m56s copy from 26 10m43s ddl 96 19m3s others 2 3m9s Queries by host
Key values
- 10.3.0.4 Main host
- 124 Requests
- 32m56s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 61 Requests
- 14m53s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-19 16:47:42 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 33 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 1m34s VACUUM ANALYSE;[ Date: 2025-09-19 15:52:33 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 59s209ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-09-19 15:33:44 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 57s511ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-09-19 17:53:45 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 30s743ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;[ Date: 2025-09-19 17:55:14 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 30s444ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-09-19 15:34:33 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 29s562ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;[ Date: 2025-09-19 15:35:22 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 29s69ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;[ Date: 2025-09-19 15:33:14 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 29s62ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-09-19 15:34:13 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 28s940ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;[ Date: 2025-09-19 17:53:17 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 28s86ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-09-19 17:54:13 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 23s933ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-19 17:56:08 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 22s446ms ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-19 15:36:19 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 21s521ms COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;[ Date: 2025-09-19 17:54:42 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 21s107ms ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-19 17:54:05 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 21s83ms ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-19 15:34:02 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 19s956ms CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);[ Date: 2025-09-19 15:34:33 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 19s544ms ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-19 15:34:53 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 19s94ms COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;[ Date: 2025-09-19 15:34:52 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 16s681ms CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2025-09-19 17:56:31 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 16s539ms ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-19 17:54:46 - Database: reftk_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1m56s 2 57s511ms 59s209ms 58s360ms 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 #1
Day Hour Count Duration Avg duration Sep 19 17 1 59s209ms 59s209ms 19 1 57s511ms 57s511ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m56s - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-19 15:33:44 Duration: 59s209ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-19 17:53:45 Duration: 57s511ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 1m34s 1 1m34s 1m34s 1m34s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 19 17 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-19 15:52:33 Duration: 1m34s Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m 2 29s562ms 30s743ms 30s153ms 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 #3
Day Hour Count Duration Avg duration Sep 19 17 1 29s562ms 29s562ms 19 1 30s743ms 30s743ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-19 17:55:14 Duration: 30s743ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-19 15:35:22 Duration: 29s562ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 58s10ms 2 28s940ms 29s69ms 29s5ms 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 #4
Day Hour Count Duration Avg duration Sep 19 17 1 29s69ms 29s69ms 19 1 28s940ms 28s940ms [ User: a3dsupervisor - Total duration: 58s10ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 58s10ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-19 15:33:14 Duration: 29s69ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-19 17:53:17 Duration: 28s940ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 57s149ms 2 28s86ms 29s62ms 28s574ms 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 Sep 19 17 1 29s62ms 29s62ms 19 1 28s86ms 28s86ms [ User: a3dsupervisor - Total duration: 57s149ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 57s149ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-19 15:34:13 Duration: 29s62ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-19 17:54:13 Duration: 28s86ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 46s379ms 2 22s446ms 23s933ms 23s189ms 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 Sep 19 17 1 22s446ms 22s446ms 19 1 23s933ms 23s933ms [ User: a3dsupervisor - Total duration: 46s379ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s379ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-19 17:56:08 Duration: 23s933ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-19 15:36:19 Duration: 22s446ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 46s32ms 2 15s588ms 30s444ms 23s16ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 17 1 30s444ms 30s444ms 19 1 15s588ms 15s588ms [ User: a3dsupervisor - Total duration: 46s32ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s32ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-19 15:34:33 Duration: 30s444ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-19 17:54:21 Duration: 15s588ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 42s191ms 2 21s83ms 21s107ms 21s95ms alter table only public.gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 19 17 1 21s83ms 21s83ms 19 1 21s107ms 21s107ms [ User: a3dsupervisor - Total duration: 42s191ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 42s191ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-19 17:54:05 Duration: 21s107ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-19 15:34:02 Duration: 21s83ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 40s615ms 2 19s94ms 21s521ms 20s307ms 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 #9
Day Hour Count Duration Avg duration Sep 19 17 1 19s94ms 19s94ms 19 1 21s521ms 21s521ms [ User: a3dsupervisor - Total duration: 40s615ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s615ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-19 17:54:42 Duration: 21s521ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-19 15:34:52 Duration: 19s94ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 36s84ms 2 16s539ms 19s544ms 18s42ms 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 Sep 19 17 1 19s544ms 19s544ms 19 1 16s539ms 16s539ms [ User: a3dsupervisor - Total duration: 36s84ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s84ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 15:34:53 Duration: 19s544ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 17:54:46 Duration: 16s539ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 35s786ms 2 15s830ms 19s956ms 17s893ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 19 17 1 19s956ms 19s956ms 19 1 15s830ms 15s830ms [ User: a3dsupervisor - Total duration: 35s786ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s786ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-19 15:34:33 Duration: 19s956ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-19 17:54:29 Duration: 15s830ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 32s242ms 2 15s561ms 16s681ms 16s121ms 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 #12
Day Hour Count Duration Avg duration Sep 19 17 1 15s561ms 15s561ms 19 1 16s681ms 16s681ms [ User: a3dsupervisor - Total duration: 32s242ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 32s242ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-19 17:56:31 Duration: 16s681ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-19 15:36:42 Duration: 15s561ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 28s372ms 2 13s957ms 14s415ms 14s186ms 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 #13
Day Hour Count Duration Avg duration Sep 19 17 1 13s957ms 13s957ms 19 1 14s415ms 14s415ms [ User: a3dsupervisor - Total duration: 28s372ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 28s372ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-09-19 17:56:26 Duration: 14s415ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-09-19 15:36:39 Duration: 13s957ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 23s872ms 2 11s529ms 12s342ms 11s936ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 19 17 1 11s529ms 11s529ms 19 1 12s342ms 12s342ms [ User: a3dsupervisor - Total duration: 23s872ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 23s872ms - Times executed: 2 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-09-19 17:57:10 Duration: 12s342ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-09-19 15:37:20 Duration: 11s529ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 23s99ms 2 10s243ms 12s856ms 11s549ms alter table only public.gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 17 1 12s856ms 12s856ms 19 1 10s243ms 10s243ms [ User: a3dsupervisor - Total duration: 23s99ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 23s99ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-19 15:37:02 Duration: 12s856ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-19 17:56:50 Duration: 10s243ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 20s137ms 2 9s654ms 10s482ms 10s68ms create index i_history_compo_obj on public.gtp_history_obj_compo using btree (obj_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 17 1 9s654ms 9s654ms 19 1 10s482ms 10s482ms [ User: a3dsupervisor - Total duration: 20s137ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 20s137ms - Times executed: 2 ]
-
CREATE INDEX i_history_compo_obj ON public.gtp_history_obj_compo USING btree (obj_num_id);
Date: 2025-09-19 17:53:44 Duration: 10s482ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_obj ON public.gtp_history_obj_compo USING btree (obj_num_id);
Date: 2025-09-19 15:33:41 Duration: 9s654ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 19s620ms 2 8s39ms 11s581ms 9s810ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 17 1 11s581ms 11s581ms 19 1 8s39ms 8s39ms [ User: a3dsupervisor - Total duration: 19s620ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 19s620ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-19 15:35:56 Duration: 11s581ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-19 17:55:44 Duration: 8s39ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 17s519ms 2 6s937ms 10s581ms 8s759ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 17 1 10s581ms 10s581ms 19 1 6s937ms 6s937ms [ User: a3dsupervisor - Total duration: 17s519ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 17s519ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-09-19 15:33:25 Duration: 10s581ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-09-19 17:53:24 Duration: 6s937ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 17s281ms 2 6s373ms 10s907ms 8s640ms create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 17 1 6s373ms 6s373ms 19 1 10s907ms 10s907ms [ User: a3dsupervisor - Total duration: 17s281ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 17s281ms - Times executed: 2 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-09-19 17:55:33 Duration: 10s907ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-09-19 15:35:40 Duration: 6s373ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 16s445ms 2 7s41ms 9s403ms 8s222ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 17 1 7s41ms 7s41ms 19 1 9s403ms 9s403ms [ User: a3dsupervisor - Total duration: 16s445ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 16s445ms - Times executed: 2 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-19 17:53:34 Duration: 9s403ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-19 15:33:32 Duration: 7s41ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 1m56s 57s511ms 59s209ms 58s360ms 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 #1
Day Hour Count Duration Avg duration Sep 19 17 1 59s209ms 59s209ms 19 1 57s511ms 57s511ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m56s - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-19 15:33:44 Duration: 59s209ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-19 17:53:45 Duration: 57s511ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 2 1m 29s562ms 30s743ms 30s153ms 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 #2
Day Hour Count Duration Avg duration Sep 19 17 1 29s562ms 29s562ms 19 1 30s743ms 30s743ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-19 17:55:14 Duration: 30s743ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-19 15:35:22 Duration: 29s562ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 2 58s10ms 28s940ms 29s69ms 29s5ms 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 #3
Day Hour Count Duration Avg duration Sep 19 17 1 29s69ms 29s69ms 19 1 28s940ms 28s940ms [ User: a3dsupervisor - Total duration: 58s10ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 58s10ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-19 15:33:14 Duration: 29s69ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-19 17:53:17 Duration: 28s940ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 2 57s149ms 28s86ms 29s62ms 28s574ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 19 17 1 29s62ms 29s62ms 19 1 28s86ms 28s86ms [ User: a3dsupervisor - Total duration: 57s149ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 57s149ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-19 15:34:13 Duration: 29s62ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-19 17:54:13 Duration: 28s86ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 2 46s379ms 22s446ms 23s933ms 23s189ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 19 17 1 22s446ms 22s446ms 19 1 23s933ms 23s933ms [ User: a3dsupervisor - Total duration: 46s379ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s379ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-19 17:56:08 Duration: 23s933ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-19 15:36:19 Duration: 22s446ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 2 46s32ms 15s588ms 30s444ms 23s16ms 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 Sep 19 17 1 30s444ms 30s444ms 19 1 15s588ms 15s588ms [ User: a3dsupervisor - Total duration: 46s32ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s32ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-19 15:34:33 Duration: 30s444ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-19 17:54:21 Duration: 15s588ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 2 42s191ms 21s83ms 21s107ms 21s95ms alter table only public.gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 17 1 21s83ms 21s83ms 19 1 21s107ms 21s107ms [ User: a3dsupervisor - Total duration: 42s191ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 42s191ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-19 17:54:05 Duration: 21s107ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-19 15:34:02 Duration: 21s83ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 2 40s615ms 19s94ms 21s521ms 20s307ms 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 #8
Day Hour Count Duration Avg duration Sep 19 17 1 19s94ms 19s94ms 19 1 21s521ms 21s521ms [ User: a3dsupervisor - Total duration: 40s615ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s615ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-19 17:54:42 Duration: 21s521ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-19 15:34:52 Duration: 19s94ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 2 36s84ms 16s539ms 19s544ms 18s42ms 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 Sep 19 17 1 19s544ms 19s544ms 19 1 16s539ms 16s539ms [ User: a3dsupervisor - Total duration: 36s84ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s84ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 15:34:53 Duration: 19s544ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 17:54:46 Duration: 16s539ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2 35s786ms 15s830ms 19s956ms 17s893ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 19 17 1 19s956ms 19s956ms 19 1 15s830ms 15s830ms [ User: a3dsupervisor - Total duration: 35s786ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s786ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-19 15:34:33 Duration: 19s956ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-19 17:54:29 Duration: 15s830ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2 32s242ms 15s561ms 16s681ms 16s121ms 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 #11
Day Hour Count Duration Avg duration Sep 19 17 1 15s561ms 15s561ms 19 1 16s681ms 16s681ms [ User: a3dsupervisor - Total duration: 32s242ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 32s242ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-19 17:56:31 Duration: 16s681ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-19 15:36:42 Duration: 15s561ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 2 28s372ms 13s957ms 14s415ms 14s186ms 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 #12
Day Hour Count Duration Avg duration Sep 19 17 1 13s957ms 13s957ms 19 1 14s415ms 14s415ms [ User: a3dsupervisor - Total duration: 28s372ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 28s372ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-09-19 17:56:26 Duration: 14s415ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-09-19 15:36:39 Duration: 13s957ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2 23s872ms 11s529ms 12s342ms 11s936ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 19 17 1 11s529ms 11s529ms 19 1 12s342ms 12s342ms [ User: a3dsupervisor - Total duration: 23s872ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 23s872ms - Times executed: 2 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-09-19 17:57:10 Duration: 12s342ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-09-19 15:37:20 Duration: 11s529ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 23s99ms 10s243ms 12s856ms 11s549ms alter table only public.gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 19 17 1 12s856ms 12s856ms 19 1 10s243ms 10s243ms [ User: a3dsupervisor - Total duration: 23s99ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 23s99ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-19 15:37:02 Duration: 12s856ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-19 17:56:50 Duration: 10s243ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2 20s137ms 9s654ms 10s482ms 10s68ms create index i_history_compo_obj on public.gtp_history_obj_compo using btree (obj_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 17 1 9s654ms 9s654ms 19 1 10s482ms 10s482ms [ User: a3dsupervisor - Total duration: 20s137ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 20s137ms - Times executed: 2 ]
-
CREATE INDEX i_history_compo_obj ON public.gtp_history_obj_compo USING btree (obj_num_id);
Date: 2025-09-19 17:53:44 Duration: 10s482ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_obj ON public.gtp_history_obj_compo USING btree (obj_num_id);
Date: 2025-09-19 15:33:41 Duration: 9s654ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 19s620ms 8s39ms 11s581ms 9s810ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 17 1 11s581ms 11s581ms 19 1 8s39ms 8s39ms [ User: a3dsupervisor - Total duration: 19s620ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 19s620ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-19 15:35:56 Duration: 11s581ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-19 17:55:44 Duration: 8s39ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 17s519ms 6s937ms 10s581ms 8s759ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 17 1 10s581ms 10s581ms 19 1 6s937ms 6s937ms [ User: a3dsupervisor - Total duration: 17s519ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 17s519ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-09-19 15:33:25 Duration: 10s581ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-09-19 17:53:24 Duration: 6s937ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 17s281ms 6s373ms 10s907ms 8s640ms create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 17 1 6s373ms 6s373ms 19 1 10s907ms 10s907ms [ User: a3dsupervisor - Total duration: 17s281ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 17s281ms - Times executed: 2 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-09-19 17:55:33 Duration: 10s907ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-09-19 15:35:40 Duration: 6s373ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2 16s445ms 7s41ms 9s403ms 8s222ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 17 1 7s41ms 7s41ms 19 1 9s403ms 9s403ms [ User: a3dsupervisor - Total duration: 16s445ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 16s445ms - Times executed: 2 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-19 17:53:34 Duration: 9s403ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-19 15:33:32 Duration: 7s41ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2 15s922ms 7s636ms 8s286ms 7s961ms alter table only public.gtp_obj_composition add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 17 1 7s636ms 7s636ms 19 1 8s286ms 8s286ms [ User: a3dsupervisor - Total duration: 15s922ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 15s922ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-09-19 17:56:39 Duration: 8s286ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-09-19 15:36:50 Duration: 7s636ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1m34s 1m34s 1m34s 1 1m34s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 19 17 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 1 ]
[ Application: psql - Total duration: 1m34s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-19 15:52:33 Duration: 1m34s Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 57s511ms 59s209ms 58s360ms 2 1m56s 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 #2
Day Hour Count Duration Avg duration Sep 19 17 1 59s209ms 59s209ms 19 1 57s511ms 57s511ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m56s - Times executed: 2 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-19 15:33:44 Duration: 59s209ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-09-19 17:53:45 Duration: 57s511ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 29s562ms 30s743ms 30s153ms 2 1m 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 #3
Day Hour Count Duration Avg duration Sep 19 17 1 29s562ms 29s562ms 19 1 30s743ms 30s743ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-19 17:55:14 Duration: 30s743ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-19 15:35:22 Duration: 29s562ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 28s940ms 29s69ms 29s5ms 2 58s10ms 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 #4
Day Hour Count Duration Avg duration Sep 19 17 1 29s69ms 29s69ms 19 1 28s940ms 28s940ms [ User: a3dsupervisor - Total duration: 58s10ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 58s10ms - Times executed: 2 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-19 15:33:14 Duration: 29s69ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-19 17:53:17 Duration: 28s940ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 28s86ms 29s62ms 28s574ms 2 57s149ms 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 Sep 19 17 1 29s62ms 29s62ms 19 1 28s86ms 28s86ms [ User: a3dsupervisor - Total duration: 57s149ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 57s149ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-19 15:34:13 Duration: 29s62ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-09-19 17:54:13 Duration: 28s86ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 22s446ms 23s933ms 23s189ms 2 46s379ms 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 Sep 19 17 1 22s446ms 22s446ms 19 1 23s933ms 23s933ms [ User: a3dsupervisor - Total duration: 46s379ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s379ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-19 17:56:08 Duration: 23s933ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-19 15:36:19 Duration: 22s446ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 15s588ms 30s444ms 23s16ms 2 46s32ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 17 1 30s444ms 30s444ms 19 1 15s588ms 15s588ms [ User: a3dsupervisor - Total duration: 46s32ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s32ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-19 15:34:33 Duration: 30s444ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-09-19 17:54:21 Duration: 15s588ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 21s83ms 21s107ms 21s95ms 2 42s191ms alter table only public.gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 19 17 1 21s83ms 21s83ms 19 1 21s107ms 21s107ms [ User: a3dsupervisor - Total duration: 42s191ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 42s191ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-19 17:54:05 Duration: 21s107ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-19 15:34:02 Duration: 21s83ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 19s94ms 21s521ms 20s307ms 2 40s615ms 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 #9
Day Hour Count Duration Avg duration Sep 19 17 1 19s94ms 19s94ms 19 1 21s521ms 21s521ms [ User: a3dsupervisor - Total duration: 40s615ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s615ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-19 17:54:42 Duration: 21s521ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-19 15:34:52 Duration: 19s94ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 16s539ms 19s544ms 18s42ms 2 36s84ms 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 Sep 19 17 1 19s544ms 19s544ms 19 1 16s539ms 16s539ms [ User: a3dsupervisor - Total duration: 36s84ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s84ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 15:34:53 Duration: 19s544ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 17:54:46 Duration: 16s539ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 15s830ms 19s956ms 17s893ms 2 35s786ms create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 19 17 1 19s956ms 19s956ms 19 1 15s830ms 15s830ms [ User: a3dsupervisor - Total duration: 35s786ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s786ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-19 15:34:33 Duration: 19s956ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2025-09-19 17:54:29 Duration: 15s830ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 15s561ms 16s681ms 16s121ms 2 32s242ms 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 #12
Day Hour Count Duration Avg duration Sep 19 17 1 15s561ms 15s561ms 19 1 16s681ms 16s681ms [ User: a3dsupervisor - Total duration: 32s242ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 32s242ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-19 17:56:31 Duration: 16s681ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-19 15:36:42 Duration: 15s561ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 13s957ms 14s415ms 14s186ms 2 28s372ms 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 #13
Day Hour Count Duration Avg duration Sep 19 17 1 13s957ms 13s957ms 19 1 14s415ms 14s415ms [ User: a3dsupervisor - Total duration: 28s372ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 28s372ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-09-19 17:56:26 Duration: 14s415ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2025-09-19 15:36:39 Duration: 13s957ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 11s529ms 12s342ms 11s936ms 2 23s872ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 19 17 1 11s529ms 11s529ms 19 1 12s342ms 12s342ms [ User: a3dsupervisor - Total duration: 23s872ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 23s872ms - Times executed: 2 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-09-19 17:57:10 Duration: 12s342ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-09-19 15:37:20 Duration: 11s529ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 10s243ms 12s856ms 11s549ms 2 23s99ms alter table only public.gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 17 1 12s856ms 12s856ms 19 1 10s243ms 10s243ms [ User: a3dsupervisor - Total duration: 23s99ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 23s99ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-19 15:37:02 Duration: 12s856ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-09-19 17:56:50 Duration: 10s243ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 9s654ms 10s482ms 10s68ms 2 20s137ms create index i_history_compo_obj on public.gtp_history_obj_compo using btree (obj_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 17 1 9s654ms 9s654ms 19 1 10s482ms 10s482ms [ User: a3dsupervisor - Total duration: 20s137ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 20s137ms - Times executed: 2 ]
-
CREATE INDEX i_history_compo_obj ON public.gtp_history_obj_compo USING btree (obj_num_id);
Date: 2025-09-19 17:53:44 Duration: 10s482ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_obj ON public.gtp_history_obj_compo USING btree (obj_num_id);
Date: 2025-09-19 15:33:41 Duration: 9s654ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 8s39ms 11s581ms 9s810ms 2 19s620ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 17 1 11s581ms 11s581ms 19 1 8s39ms 8s39ms [ User: a3dsupervisor - Total duration: 19s620ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 19s620ms - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-19 15:35:56 Duration: 11s581ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-19 17:55:44 Duration: 8s39ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 6s937ms 10s581ms 8s759ms 2 17s519ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 17 1 10s581ms 10s581ms 19 1 6s937ms 6s937ms [ User: a3dsupervisor - Total duration: 17s519ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 17s519ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-09-19 15:33:25 Duration: 10s581ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2025-09-19 17:53:24 Duration: 6s937ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 6s373ms 10s907ms 8s640ms 2 17s281ms create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 17 1 6s373ms 6s373ms 19 1 10s907ms 10s907ms [ User: a3dsupervisor - Total duration: 17s281ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 17s281ms - Times executed: 2 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-09-19 17:55:33 Duration: 10s907ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-09-19 15:35:40 Duration: 6s373ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 7s41ms 9s403ms 8s222ms 2 16s445ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 17 1 7s41ms 7s41ms 19 1 9s403ms 9s403ms [ User: a3dsupervisor - Total duration: 16s445ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 16s445ms - Times executed: 2 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-19 17:53:34 Duration: 9s403ms Database: reftk_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-19 15:33:32 Duration: 7s41ms Database: reftk_feat_batch 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
Log levels
Key values
- 5,092 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 4295 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 4,264 Max number of times the same event was reported
- 4,297 Total events found
Rank Times reported Error 1 4,264 ERROR: operator does not exist: smallint = character varying
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 19 18 2,590 19 1,674 2 5 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 19 19 3 20 2 3 3 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 19 17 1 19 2 4 2 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 #4
Day Hour Count Sep 19 18 2 5 2 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 #5
Day Hour Count Sep 19 18 2 6 2 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 19 18 2 7 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 19 18 2 8 2 ERROR: permission denied for table ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 19 18 2 9 2 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 19 18 2 10 2 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 #10
Day Hour Count Sep 19 18 2 11 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 19 18 2 12 2 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 19 18 2 13 2 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 19 18 2 14 2 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 #14
Day Hour Count Sep 19 18 2 15 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 19 17 1 16 1 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 19 18 1 17 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 19 18 1