pgBadger-
Global information
- Generated on Thu Sep 25 09:06:19 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=24/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=24/h=23/m=00/PT1H.log
- Parsed 1,359 log entries in 52s
- Log start from 2025-09-24 06:41:08 to 2025-09-24 07:11:08
-
Overview
Global Stats
- 39 Number of unique normalized queries
- 39 Number of queries
- 20m56s Total query duration
- 2025-09-24 06:48:38 First query
- 2025-09-24 07:14:19 Last query
- 1 queries/s at 2025-09-24 06:55:56 Query peak
- 20m56s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 20m56s Execute total duration
- 17 Number of events
- 2 Number of unique normalized events
- 16 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
- 199 Number temporary file
- 3.14 GiB Max size of temporary file
- 22.18 MiB Average size of temporary file
- 349 Total number of sessions
- 17 sessions at 2025-09-24 07:20:12 Session peak
- 49m4s Total duration of sessions
- 8s435ms Average duration of sessions
- 0 Average queries per session
- 3s601ms Average queries duration per session
- 4s834ms Average idle time per session
- 349 Total number of connections
- 10 connections/s at 2025-09-24 06:47:48 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-09-24 06:55:56 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-09-24 06:55:56 Date
Queries duration
Key values
- 20m56s 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 24 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 30 0ms 1m16s 15s704ms 53s420ms 1m16s 1m16s 07 9 0ms 7m23s 1m27s 3m4s 7m23s 7m23s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 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 6 25s79ms 17s251ms 46s478ms 1m9s 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 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 0 0ms 0ms 0ms 0ms 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 Sep 24 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 Sep 24 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 283 0.08/s 07 17 0.00/s 08 5 0.00/s 09 3 0.00/s 10 3 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 Sep 24 00 2 71ms 71ms 01 2 71ms 71ms 02 2 73ms 73ms 03 2 79ms 79ms 04 2 74ms 74ms 05 2 76ms 76ms 06 282 3s265ms 1s595ms 07 18 1m52s 1m8s 08 5 202ms 202ms 09 3 157ms 157ms 10 3 155ms 155ms 11 2 72ms 72ms 12 2 72ms 72ms 13 2 156ms 156ms 14 2 115ms 115ms 15 2 98ms 98ms 16 2 73ms 73ms 17 2 218ms 218ms 18 2 124ms 124ms 19 2 120ms 120ms 20 2 75ms 75ms 21 2 76ms 76ms 22 2 73ms 73ms 23 2 71ms 71ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-09-24 06:47:48 Date
Connections per database
Key values
- autotest Main Database
- 349 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 349 connections Total
-
Sessions
Simultaneous sessions
Key values
- 17 sessions Session Peak
- 2025-09-24 07:20:12 Date
Histogram of session times
Key values
- 313 0-500ms duration
Sessions per database
Key values
- autotest Main Database
- 349 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 349 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 349 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 387.02 MiB Temp Files size Peak
- 2025-09-24 06:55:55 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-09-24 06:56:34 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 24 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 199 4.31 GiB 22.18 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
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 24 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
- ShareLock Main Lock Type
- 1 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
- 37 Total write queries
Queries by database
Key values
- autotest Main database
- 39 Requests
- 20m56s (autotest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 39 Requests
User Request type Count Duration a3dsupervisor Total 39 20m56s copy to 6 2m30s ddl 31 8m16s others 2 10m10s Duration by user
Key values
- 20m56s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 39 20m56s copy to 6 2m30s ddl 31 8m16s others 2 10m10s Queries by host
Key values
- 10.3.0.4 Main host
- 39 Requests
- 20m56s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 33 Requests
- 18m26s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-24 06:56:34 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 29 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 7m23s VACUUM ANALYZE;[ Date: 2025-09-24 07:08:10 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 2m46s VACUUM ANALYSE;[ Date: 2025-09-24 07:11:08 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m16s ALTER TABLE gtp_obj_rel_vt 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-24 06:55:56 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 46s478ms 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) TO stdout;[ Date: 2025-09-24 07:12:46 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 39s148ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-24 07:13:57 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 27s778ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-09-24 06:52:25 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 26s925ms ALTER TABLE 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-24 06:54:14 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 26s710ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-09-24 06:59:01 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 24s935ms ALTER TABLE pe_consumption_10min ADD CONSTRAINT fk_pe_consumption_10min_cp FOREIGN KEY (counting_point_num_id) REFERENCES gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-09-24 07:00:10 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 22s535ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-24 06:53:24 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 21s324ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);[ Date: 2025-09-24 06:49:13 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 18s992ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-09-24 06:48:38 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 18s680ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-09-24 06:58:29 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 18s350ms CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);[ Date: 2025-09-24 06:51:43 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 17s251ms 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) TO stdout;[ Date: 2025-09-24 07:14:19 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 17s187ms 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) TO stdout;[ Date: 2025-09-24 07:11:53 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 16s803ms 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) TO stdout;[ Date: 2025-09-24 07:13:18 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 15s450ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-24 06:53:47 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 14s502ms CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2025-09-24 06:50:35 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 14s366ms ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-09-24 06:57:08 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 7m23s 1 7m23s 7m23s 7m23s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 09 1 7m23s 7m23s [ User: a3dsupervisor - Total duration: 7m23s - Times executed: 1 ]
[ Application: psql - Total duration: 7m23s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 07:08:10 Duration: 7m23s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m46s 1 2m46s 2m46s 2m46s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 09 1 2m46s 2m46s [ User: a3dsupervisor - Total duration: 2m46s - Times executed: 1 ]
[ Application: psql - Total duration: 2m46s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 07:11:08 Duration: 2m46s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m16s 1 1m16s 1m16s 1m16s alter table gtp_obj_rel_vt 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);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 08 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: psql - Total duration: 1m16s - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt 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-24 06:55:56 Duration: 1m16s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 46s478ms 1 46s478ms 46s478ms 46s478ms 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 09 1 46s478ms 46s478ms [ User: a3dsupervisor - Total duration: 46s478ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 46s478ms - 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) TO stdout;
Date: 2025-09-24 07:12:46 Duration: 46s478ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 39s148ms 1 39s148ms 39s148ms 39s148ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 09 1 39s148ms 39s148ms [ User: a3dsupervisor - Total duration: 39s148ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 39s148ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 07:13:57 Duration: 39s148ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 27s778ms 1 27s778ms 27s778ms 27s778ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 08 1 27s778ms 27s778ms [ User: a3dsupervisor - Total duration: 27s778ms - Times executed: 1 ]
[ Application: psql - Total duration: 27s778ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 06:52:25 Duration: 27s778ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 26s925ms 1 26s925ms 26s925ms 26s925ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 08 1 26s925ms 26s925ms [ User: a3dsupervisor - Total duration: 26s925ms - Times executed: 1 ]
[ Application: psql - Total duration: 26s925ms - Times executed: 1 ]
-
ALTER TABLE 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-24 06:54:14 Duration: 26s925ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 26s710ms 1 26s710ms 26s710ms 26s710ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 08 1 26s710ms 26s710ms [ User: a3dsupervisor - Total duration: 26s710ms - Times executed: 1 ]
[ Application: psql - Total duration: 26s710ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:59:01 Duration: 26s710ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 24s935ms 1 24s935ms 24s935ms 24s935ms alter table pe_consumption_10min add constraint fk_pe_consumption_10min_cp foreign key (counting_point_num_id) references gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 09 1 24s935ms 24s935ms [ User: a3dsupervisor - Total duration: 24s935ms - Times executed: 1 ]
[ Application: psql - Total duration: 24s935ms - Times executed: 1 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT fk_pe_consumption_10min_cp FOREIGN KEY (counting_point_num_id) REFERENCES gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 07:00:10 Duration: 24s935ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 22s535ms 1 22s535ms 22s535ms 22s535ms alter table 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 24 08 1 22s535ms 22s535ms [ User: a3dsupervisor - Total duration: 22s535ms - Times executed: 1 ]
[ Application: psql - Total duration: 22s535ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 06:53:24 Duration: 22s535ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 21s324ms 1 21s324ms 21s324ms 21s324ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 08 1 21s324ms 21s324ms [ User: a3dsupervisor - Total duration: 21s324ms - Times executed: 1 ]
[ Application: psql - Total duration: 21s324ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-24 06:49:13 Duration: 21s324ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 18s992ms 1 18s992ms 18s992ms 18s992ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 08 1 18s992ms 18s992ms [ User: a3dsupervisor - Total duration: 18s992ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s992ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-24 06:48:38 Duration: 18s992ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 18s680ms 1 18s680ms 18s680ms 18s680ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_objt foreign key (obj_template_num_id) references gtp_obj_template (obj_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 08 1 18s680ms 18s680ms [ User: a3dsupervisor - Total duration: 18s680ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s680ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:58:29 Duration: 18s680ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 18s350ms 1 18s350ms 18s350ms 18s350ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 08 1 18s350ms 18s350ms [ User: a3dsupervisor - Total duration: 18s350ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s350ms - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-24 06:51:43 Duration: 18s350ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 17s251ms 1 17s251ms 17s251ms 17s251ms 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) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 09 1 17s251ms 17s251ms [ User: a3dsupervisor - Total duration: 17s251ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 17s251ms - Times executed: 1 ]
-
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) TO stdout;
Date: 2025-09-24 07:14:19 Duration: 17s251ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 17s187ms 1 17s187ms 17s187ms 17s187ms 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) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 09 1 17s187ms 17s187ms [ User: a3dsupervisor - Total duration: 17s187ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 17s187ms - 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) TO stdout;
Date: 2025-09-24 07:11:53 Duration: 17s187ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 16s803ms 1 16s803ms 16s803ms 16s803ms 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) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 09 1 16s803ms 16s803ms [ User: a3dsupervisor - Total duration: 16s803ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s803ms - 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) TO stdout;
Date: 2025-09-24 07:13:18 Duration: 16s803ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 15s450ms 1 15s450ms 15s450ms 15s450ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 08 1 15s450ms 15s450ms [ User: a3dsupervisor - Total duration: 15s450ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s450ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-24 06:53:47 Duration: 15s450ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 14s502ms 1 14s502ms 14s502ms 14s502ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 08 1 14s502ms 14s502ms [ User: a3dsupervisor - Total duration: 14s502ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s502ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 06:50:35 Duration: 14s502ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 14s366ms 1 14s366ms 14s366ms 14s366ms alter table gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 08 1 14s366ms 14s366ms [ User: a3dsupervisor - Total duration: 14s366ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s366ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:57:08 Duration: 14s366ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1 7m23s 7m23s 7m23s 7m23s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 09 1 7m23s 7m23s [ User: a3dsupervisor - Total duration: 7m23s - Times executed: 1 ]
[ Application: psql - Total duration: 7m23s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 07:08:10 Duration: 7m23s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1 2m46s 2m46s 2m46s 2m46s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 09 1 2m46s 2m46s [ User: a3dsupervisor - Total duration: 2m46s - Times executed: 1 ]
[ Application: psql - Total duration: 2m46s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 07:11:08 Duration: 2m46s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1 1m16s 1m16s 1m16s 1m16s alter table gtp_obj_rel_vt 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);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 08 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: psql - Total duration: 1m16s - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt 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-24 06:55:56 Duration: 1m16s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1 46s478ms 46s478ms 46s478ms 46s478ms 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 09 1 46s478ms 46s478ms [ User: a3dsupervisor - Total duration: 46s478ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 46s478ms - 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) TO stdout;
Date: 2025-09-24 07:12:46 Duration: 46s478ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 1 39s148ms 39s148ms 39s148ms 39s148ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 09 1 39s148ms 39s148ms [ User: a3dsupervisor - Total duration: 39s148ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 39s148ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 07:13:57 Duration: 39s148ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 1 27s778ms 27s778ms 27s778ms 27s778ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 08 1 27s778ms 27s778ms [ User: a3dsupervisor - Total duration: 27s778ms - Times executed: 1 ]
[ Application: psql - Total duration: 27s778ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 06:52:25 Duration: 27s778ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1 26s925ms 26s925ms 26s925ms 26s925ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 08 1 26s925ms 26s925ms [ User: a3dsupervisor - Total duration: 26s925ms - Times executed: 1 ]
[ Application: psql - Total duration: 26s925ms - Times executed: 1 ]
-
ALTER TABLE 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-24 06:54:14 Duration: 26s925ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 1 26s710ms 26s710ms 26s710ms 26s710ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 08 1 26s710ms 26s710ms [ User: a3dsupervisor - Total duration: 26s710ms - Times executed: 1 ]
[ Application: psql - Total duration: 26s710ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:59:01 Duration: 26s710ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1 24s935ms 24s935ms 24s935ms 24s935ms alter table pe_consumption_10min add constraint fk_pe_consumption_10min_cp foreign key (counting_point_num_id) references gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 09 1 24s935ms 24s935ms [ User: a3dsupervisor - Total duration: 24s935ms - Times executed: 1 ]
[ Application: psql - Total duration: 24s935ms - Times executed: 1 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT fk_pe_consumption_10min_cp FOREIGN KEY (counting_point_num_id) REFERENCES gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 07:00:10 Duration: 24s935ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1 22s535ms 22s535ms 22s535ms 22s535ms alter table 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 24 08 1 22s535ms 22s535ms [ User: a3dsupervisor - Total duration: 22s535ms - Times executed: 1 ]
[ Application: psql - Total duration: 22s535ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 06:53:24 Duration: 22s535ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1 21s324ms 21s324ms 21s324ms 21s324ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 08 1 21s324ms 21s324ms [ User: a3dsupervisor - Total duration: 21s324ms - Times executed: 1 ]
[ Application: psql - Total duration: 21s324ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-24 06:49:13 Duration: 21s324ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1 18s992ms 18s992ms 18s992ms 18s992ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 08 1 18s992ms 18s992ms [ User: a3dsupervisor - Total duration: 18s992ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s992ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-24 06:48:38 Duration: 18s992ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1 18s680ms 18s680ms 18s680ms 18s680ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_objt foreign key (obj_template_num_id) references gtp_obj_template (obj_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 08 1 18s680ms 18s680ms [ User: a3dsupervisor - Total duration: 18s680ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s680ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:58:29 Duration: 18s680ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1 18s350ms 18s350ms 18s350ms 18s350ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 08 1 18s350ms 18s350ms [ User: a3dsupervisor - Total duration: 18s350ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s350ms - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-24 06:51:43 Duration: 18s350ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1 17s251ms 17s251ms 17s251ms 17s251ms 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) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 09 1 17s251ms 17s251ms [ User: a3dsupervisor - Total duration: 17s251ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 17s251ms - Times executed: 1 ]
-
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) TO stdout;
Date: 2025-09-24 07:14:19 Duration: 17s251ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 1 17s187ms 17s187ms 17s187ms 17s187ms 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) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 09 1 17s187ms 17s187ms [ User: a3dsupervisor - Total duration: 17s187ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 17s187ms - 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) TO stdout;
Date: 2025-09-24 07:11:53 Duration: 17s187ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 1 16s803ms 16s803ms 16s803ms 16s803ms 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) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 09 1 16s803ms 16s803ms [ User: a3dsupervisor - Total duration: 16s803ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s803ms - 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) TO stdout;
Date: 2025-09-24 07:13:18 Duration: 16s803ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 1 15s450ms 15s450ms 15s450ms 15s450ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 08 1 15s450ms 15s450ms [ User: a3dsupervisor - Total duration: 15s450ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s450ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-24 06:53:47 Duration: 15s450ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 1 14s502ms 14s502ms 14s502ms 14s502ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 08 1 14s502ms 14s502ms [ User: a3dsupervisor - Total duration: 14s502ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s502ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 06:50:35 Duration: 14s502ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 1 14s366ms 14s366ms 14s366ms 14s366ms alter table gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 08 1 14s366ms 14s366ms [ User: a3dsupervisor - Total duration: 14s366ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s366ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:57:08 Duration: 14s366ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 7m23s 7m23s 7m23s 1 7m23s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 09 1 7m23s 7m23s [ User: a3dsupervisor - Total duration: 7m23s - Times executed: 1 ]
[ Application: psql - Total duration: 7m23s - Times executed: 1 ]
-
VACUUM ANALYZE;
Date: 2025-09-24 07:08:10 Duration: 7m23s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m46s 2m46s 2m46s 1 2m46s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 09 1 2m46s 2m46s [ User: a3dsupervisor - Total duration: 2m46s - Times executed: 1 ]
[ Application: psql - Total duration: 2m46s - Times executed: 1 ]
-
VACUUM ANALYSE;
Date: 2025-09-24 07:11:08 Duration: 2m46s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m16s 1m16s 1m16s 1 1m16s alter table gtp_obj_rel_vt 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);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 08 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 1 ]
[ Application: psql - Total duration: 1m16s - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt 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-24 06:55:56 Duration: 1m16s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 46s478ms 46s478ms 46s478ms 1 46s478ms 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 09 1 46s478ms 46s478ms [ User: a3dsupervisor - Total duration: 46s478ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 46s478ms - 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) TO stdout;
Date: 2025-09-24 07:12:46 Duration: 46s478ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 39s148ms 39s148ms 39s148ms 1 39s148ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 09 1 39s148ms 39s148ms [ User: a3dsupervisor - Total duration: 39s148ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 39s148ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 07:13:57 Duration: 39s148ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 27s778ms 27s778ms 27s778ms 1 27s778ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 08 1 27s778ms 27s778ms [ User: a3dsupervisor - Total duration: 27s778ms - Times executed: 1 ]
[ Application: psql - Total duration: 27s778ms - Times executed: 1 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-24 06:52:25 Duration: 27s778ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 26s925ms 26s925ms 26s925ms 1 26s925ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 08 1 26s925ms 26s925ms [ User: a3dsupervisor - Total duration: 26s925ms - Times executed: 1 ]
[ Application: psql - Total duration: 26s925ms - Times executed: 1 ]
-
ALTER TABLE 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-24 06:54:14 Duration: 26s925ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 26s710ms 26s710ms 26s710ms 1 26s710ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 08 1 26s710ms 26s710ms [ User: a3dsupervisor - Total duration: 26s710ms - Times executed: 1 ]
[ Application: psql - Total duration: 26s710ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:59:01 Duration: 26s710ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 24s935ms 24s935ms 24s935ms 1 24s935ms alter table pe_consumption_10min add constraint fk_pe_consumption_10min_cp foreign key (counting_point_num_id) references gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 09 1 24s935ms 24s935ms [ User: a3dsupervisor - Total duration: 24s935ms - Times executed: 1 ]
[ Application: psql - Total duration: 24s935ms - Times executed: 1 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT fk_pe_consumption_10min_cp FOREIGN KEY (counting_point_num_id) REFERENCES gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 07:00:10 Duration: 24s935ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 22s535ms 22s535ms 22s535ms 1 22s535ms alter table 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 24 08 1 22s535ms 22s535ms [ User: a3dsupervisor - Total duration: 22s535ms - Times executed: 1 ]
[ Application: psql - Total duration: 22s535ms - Times executed: 1 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-24 06:53:24 Duration: 22s535ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 21s324ms 21s324ms 21s324ms 1 21s324ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 08 1 21s324ms 21s324ms [ User: a3dsupervisor - Total duration: 21s324ms - Times executed: 1 ]
[ Application: psql - Total duration: 21s324ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-24 06:49:13 Duration: 21s324ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 18s992ms 18s992ms 18s992ms 1 18s992ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 08 1 18s992ms 18s992ms [ User: a3dsupervisor - Total duration: 18s992ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s992ms - Times executed: 1 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-24 06:48:38 Duration: 18s992ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 18s680ms 18s680ms 18s680ms 1 18s680ms alter table gtp_obj_rel_vt add constraint fk_gtp_obj_rel_vt_objt foreign key (obj_template_num_id) references gtp_obj_template (obj_template_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 08 1 18s680ms 18s680ms [ User: a3dsupervisor - Total duration: 18s680ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s680ms - Times executed: 1 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:58:29 Duration: 18s680ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 18s350ms 18s350ms 18s350ms 1 18s350ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 08 1 18s350ms 18s350ms [ User: a3dsupervisor - Total duration: 18s350ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s350ms - Times executed: 1 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-24 06:51:43 Duration: 18s350ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 17s251ms 17s251ms 17s251ms 1 17s251ms 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) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 09 1 17s251ms 17s251ms [ User: a3dsupervisor - Total duration: 17s251ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 17s251ms - Times executed: 1 ]
-
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) TO stdout;
Date: 2025-09-24 07:14:19 Duration: 17s251ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 17s187ms 17s187ms 17s187ms 1 17s187ms 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) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 09 1 17s187ms 17s187ms [ User: a3dsupervisor - Total duration: 17s187ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 17s187ms - 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) TO stdout;
Date: 2025-09-24 07:11:53 Duration: 17s187ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 16s803ms 16s803ms 16s803ms 1 16s803ms 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) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 09 1 16s803ms 16s803ms [ User: a3dsupervisor - Total duration: 16s803ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s803ms - 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) TO stdout;
Date: 2025-09-24 07:13:18 Duration: 16s803ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 15s450ms 15s450ms 15s450ms 1 15s450ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 08 1 15s450ms 15s450ms [ User: a3dsupervisor - Total duration: 15s450ms - Times executed: 1 ]
[ Application: psql - Total duration: 15s450ms - Times executed: 1 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-24 06:53:47 Duration: 15s450ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 14s502ms 14s502ms 14s502ms 1 14s502ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 08 1 14s502ms 14s502ms [ User: a3dsupervisor - Total duration: 14s502ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s502ms - Times executed: 1 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-24 06:50:35 Duration: 14s502ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 14s366ms 14s366ms 14s366ms 1 14s366ms alter table gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 08 1 14s366ms 14s366ms [ User: a3dsupervisor - Total duration: 14s366ms - Times executed: 1 ]
[ Application: psql - Total duration: 14s366ms - Times executed: 1 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-24 06:57:08 Duration: 14s366ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
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
- 1,303 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 16 WARNING entries
Most Frequent Errors/Events
Key values
- 16 Max number of times the same event was reported
- 17 Total events found
Rank Times reported Error 1 16 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 24 08 16 2 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 24 08 1