pgBadger-
Global information
- Generated on Mon Oct 20 09:33:26 2025
- Log file: ././A3D-RND-REF/y=2025/m=10/d=18/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=10/d=18/h=23/m=00/PT1H.log
- Parsed 912,153 log entries in 2m38s
- Log start from 2025-10-13 18:23:54 to 2025-10-18 15:08:27
-
Overview
Global Stats
- 739 Number of unique normalized queries
- 5,480 Number of queries
- 6m2s Total query duration
- 2025-10-13 18:23:54 First query
- 2025-10-18 15:08:27 Last query
- 216 queries/s at 2025-10-15 18:25:00 Query peak
- 6m2s Total query duration
- 486ms Prepare/parse total duration
- 405ms Bind total duration
- 6m1s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 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
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 30 Total number of sessions
- 2 sessions at 2025-10-15 18:25:23 Session peak
- 2h47m46s Total duration of sessions
- 5m35s Average duration of sessions
- 182 Average queries per session
- 12s93ms Average queries duration per session
- 5m23s Average idle time per session
- 30 Total number of connections
- 2 connections/s at 2025-10-17 18:24:28 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 216 queries/s Query Peak
- 2025-10-15 18:25:00 Date
SELECT Traffic
Key values
- 191 queries/s Query Peak
- 2025-10-15 18:25:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 106 queries/s Query Peak
- 2025-10-15 18:31:18 Date
Queries duration
Key values
- 6m2s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 13 18 1,072 0ms 21s343ms 69ms 29s449ms 43s24ms 43s24ms Oct 14 18 1,072 0ms 21s531ms 65ms 21s531ms 48s317ms 48s317ms Oct 15 18 1,072 0ms 21s304ms 65ms 18s941ms 51s57ms 51s57ms Oct 16 12 8 0ms 20ms 7ms 56ms 56ms 56ms 13 24 0ms 13ms 4ms 36ms 36ms 36ms 18 1,072 0ms 21s110ms 65ms 21s111ms 48s762ms 48s762ms Oct 17 14 8 0ms 19ms 7ms 57ms 57ms 57ms 15 8 0ms 12ms 4ms 35ms 35ms 35ms 16 16 0ms 12ms 4ms 34ms 34ms 34ms 17 24 0ms 13ms 4ms 68ms 68ms 68ms 18 1,072 0ms 22s938ms 70ms 22s939ms 50s768ms 50s768ms Oct 18 09 16 0ms 18ms 5ms 46ms 46ms 46ms 15 16 0ms 13ms 4ms 38ms 38ms 38ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 13 18 430 242 110ms 1s772ms 29s426ms 43s24ms Oct 14 18 430 242 104ms 603ms 21s531ms 48s297ms Oct 15 18 430 242 104ms 389ms 18s921ms 51s56ms Oct 16 12 8 0 7ms 56ms 56ms 56ms 13 24 0 4ms 36ms 36ms 36ms 18 430 242 104ms 541ms 21s110ms 48s739ms Oct 17 14 8 0 7ms 57ms 57ms 57ms 15 8 0 4ms 35ms 35ms 35ms 16 16 0 4ms 34ms 34ms 34ms 17 24 0 4ms 68ms 68ms 68ms 18 430 242 112ms 1s687ms 22s938ms 50s745ms Oct 18 09 16 0 5ms 46ms 46ms 46ms 15 16 0 4ms 38ms 38ms 38ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 13 18 0 0 0 0 0ms 0ms 0ms 0ms Oct 14 18 0 0 0 0 0ms 0ms 0ms 0ms Oct 15 18 0 0 0 0 0ms 0ms 0ms 0ms Oct 16 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Oct 17 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 Oct 18 09 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 13 18 3 116 38.67 0.44% Oct 14 18 3 116 38.67 0.44% Oct 15 18 3 116 38.67 0.44% Oct 16 12 8 8 1.00 100.00% 13 24 24 1.00 100.00% 18 3 116 38.67 0.44% Oct 17 14 8 8 1.00 100.00% 15 8 8 1.00 100.00% 16 16 16 1.00 100.00% 17 24 24 1.00 100.00% 18 3 116 38.67 0.44% Oct 18 09 16 16 1.00 100.00% 15 16 16 1.00 100.00% Day Hour Count Average / Second Oct 13 18 3 0.00/s Oct 14 18 3 0.00/s Oct 15 18 3 0.00/s Oct 16 12 1 0.00/s 13 3 0.00/s 18 3 0.00/s Oct 17 14 1 0.00/s 15 1 0.00/s 16 2 0.00/s 17 3 0.00/s 18 3 0.00/s Oct 18 09 2 0.00/s 15 2 0.00/s Day Hour Count Average Duration Average idle time Oct 13 18 3 11m24s 11m Oct 14 18 3 11m19s 10m56s Oct 15 18 3 10m48s 10m25s Oct 16 12 1 471ms 414ms 13 3 271ms 236ms 18 3 11m45s 11m22s Oct 17 14 1 790ms 732ms 15 1 280ms 244ms 16 2 282ms 247ms 17 3 254ms 219ms 18 3 10m34s 10m9s Oct 18 09 2 304ms 264ms 15 2 237ms 201ms -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2025-10-17 18:24:28 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 30 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 30 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2025-10-15 18:25:23 Date
Histogram of session times
Key values
- 15 600000-1800000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 30 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 30 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 30 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 13 18 0 0 0 Oct 14 18 0 0 0 Oct 15 18 0 0 0 Oct 16 12 0 0 0 13 0 0 0 18 0 0 0 Oct 17 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 Oct 18 09 0 0 0 15 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 Oct 13 18 0 0 Oct 14 18 0 0 Oct 15 18 0 0 Oct 16 12 0 0 13 0 0 18 0 0 Oct 17 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 Oct 18 09 0 0 15 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 2,270 Total read queries
- 1,230 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 5,480 Requests
- 6m1s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 5,512 Requests
User Request type Count Duration a3dsupervisor Total 5,512 6m2s copy to 1,210 5m55s cte 5 18ms others 1,980 334ms select 2,302 5s919ms tcl 15 0ms Duration by user
Key values
- 6m2s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 5,512 6m2s copy to 1,210 5m55s cte 5 18ms others 1,980 334ms select 2,302 5s919ms tcl 15 0ms Queries by host
Key values
- 10.3.0.4 Main host
- 5,512 Requests
- 6m2s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 5,360 Requests
- 6m1s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-14 18:11:40 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,986 0-1ms duration
Slowest individual queries
Rank Duration Query 1 22s938ms 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-10-17 18:29:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 21s531ms 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-10-14 18:16:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 21s343ms 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-10-13 18:29:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 21s304ms 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-10-15 18:30:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 21s110ms 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-10-16 18:28:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 12s748ms 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-10-17 18:30:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 12s629ms 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-10-15 18:30:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 12s611ms 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-10-13 18:29:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 12s544ms 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-10-14 18:17:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 12s522ms 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-10-16 18:29:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 9s69ms 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-10-13 18:29:58 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 8s711ms 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-10-15 18:30:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 8s650ms 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-10-14 18:17:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 8s609ms 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-10-16 18:29:14 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 8s559ms 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) TO stdout;[ Date: 2025-10-13 18:30:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 8s476ms 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-10-17 18:30:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 8s447ms 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) TO stdout;[ Date: 2025-10-17 18:30:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 8s410ms 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) TO stdout;[ Date: 2025-10-15 18:30:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 8s341ms 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) TO stdout;[ Date: 2025-10-14 18:17:18 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 8s269ms 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) TO stdout;[ Date: 2025-10-16 18:29:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1m48s 5 21s110ms 22s938ms 21s645ms 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 #1
Day Hour Count Duration Avg duration Oct 13 20 1 21s343ms 21s343ms Oct 14 20 1 21s531ms 21s531ms Oct 15 20 1 21s304ms 21s304ms Oct 16 20 1 21s110ms 21s110ms Oct 17 20 1 22s938ms 22s938ms [ User: a3dsupervisor - Total duration: 1m48s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 5 ]
-
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-10-17 18:29:50 Duration: 22s938ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-14 18:16:49 Duration: 21s531ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-13 18:29:36 Duration: 21s343ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 1m3s 5 12s522ms 12s748ms 12s611ms 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 #2
Day Hour Count Duration Avg duration Oct 13 20 1 12s611ms 12s611ms Oct 14 20 1 12s544ms 12s544ms Oct 15 20 1 12s629ms 12s629ms Oct 16 20 1 12s522ms 12s522ms Oct 17 20 1 12s748ms 12s748ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 5 ]
-
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-10-17 18:30:03 Duration: 12s748ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-15 18:30:39 Duration: 12s629ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-13 18:29:49 Duration: 12s611ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 43s517ms 5 8s476ms 9s69ms 8s703ms 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 #3
Day Hour Count Duration Avg duration Oct 13 20 1 9s69ms 9s69ms Oct 14 20 1 8s650ms 8s650ms Oct 15 20 1 8s711ms 8s711ms Oct 16 20 1 8s609ms 8s609ms Oct 17 20 1 8s476ms 8s476ms [ User: a3dsupervisor - Total duration: 43s517ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 43s517ms - Times executed: 5 ]
-
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-10-13 18:29:58 Duration: 9s69ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-15 18:30:48 Duration: 8s711ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-14 18:17:10 Duration: 8s650ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 42s29ms 5 8s269ms 8s559ms 8s405ms 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 20 1 8s559ms 8s559ms Oct 14 20 1 8s341ms 8s341ms Oct 15 20 1 8s410ms 8s410ms Oct 16 20 1 8s269ms 8s269ms Oct 17 20 1 8s447ms 8s447ms [ User: a3dsupervisor - Total duration: 42s29ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 42s29ms - Times executed: 5 ]
-
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) TO stdout;
Date: 2025-10-13 18:30:06 Duration: 8s559ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-17 18:30:20 Duration: 8s447ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-15 18:30:56 Duration: 8s410ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 30s826ms 5 5s938ms 6s665ms 6s165ms 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 #5
Day Hour Count Duration Avg duration Oct 13 20 1 5s938ms 5s938ms Oct 14 20 1 5s965ms 5s965ms Oct 15 20 1 6s17ms 6s17ms Oct 16 20 1 6s665ms 6s665ms Oct 17 20 1 6s240ms 6s240ms [ User: a3dsupervisor - Total duration: 30s826ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 30s826ms - Times executed: 5 ]
-
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-10-16 18:29:29 Duration: 6s665ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-17 18:30:26 Duration: 6s240ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-15 18:31:02 Duration: 6s17ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 24s400ms 5 4s610ms 5s173ms 4s880ms 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 #6
Day Hour Count Duration Avg duration Oct 13 20 1 5s154ms 5s154ms Oct 14 20 1 4s786ms 4s786ms Oct 15 20 1 4s675ms 4s675ms Oct 16 20 1 4s610ms 4s610ms Oct 17 20 1 5s173ms 5s173ms [ User: a3dsupervisor - Total duration: 24s400ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 24s400ms - Times executed: 5 ]
-
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-10-17 18:30:31 Duration: 5s173ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-13 18:30:18 Duration: 5s154ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-14 18:17:29 Duration: 4s786ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 5s934ms 5 1s58ms 1s369ms 1s186ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 20 1 1s163ms 1s163ms Oct 14 20 1 1s159ms 1s159ms Oct 15 20 1 1s369ms 1s369ms Oct 16 20 1 1s58ms 1s58ms Oct 17 20 1 1s182ms 1s182ms [ User: a3dsupervisor - Total duration: 5s934ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s934ms - Times executed: 5 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-15 18:31:08 Duration: 1s369ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-17 18:30:32 Duration: 1s182ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-13 18:30:19 Duration: 1s163ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 5s376ms 5 955ms 1s289ms 1s75ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 20 1 971ms 971ms Oct 14 20 1 1s117ms 1s117ms Oct 15 20 1 1s43ms 1s43ms Oct 16 20 1 1s289ms 1s289ms Oct 17 20 1 955ms 955ms [ User: a3dsupervisor - Total duration: 5s376ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s376ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-16 18:29:38 Duration: 1s289ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-14 18:17:33 Duration: 1s117ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-15 18:31:11 Duration: 1s43ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 5s259ms 5 959ms 1s189ms 1s51ms copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 20 1 1s189ms 1s189ms Oct 14 20 1 959ms 959ms Oct 15 20 1 976ms 976ms Oct 16 20 1 968ms 968ms Oct 17 20 1 1s166ms 1s166ms [ User: a3dsupervisor - Total duration: 5s259ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s259ms - Times executed: 5 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-13 18:30:21 Duration: 1s189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-17 18:30:34 Duration: 1s166ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-15 18:31:10 Duration: 976ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 3s887ms 5 649ms 899ms 777ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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 #10
Day Hour Count Duration Avg duration Oct 13 20 1 848ms 848ms Oct 14 20 1 711ms 711ms Oct 15 20 1 778ms 778ms Oct 16 20 1 649ms 649ms Oct 17 20 1 899ms 899ms [ User: a3dsupervisor - Total duration: 3s887ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s887ms - Times executed: 5 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-10-17 18:30:36 Duration: 899ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-10-13 18:30:22 Duration: 848ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-10-15 18:31:11 Duration: 778ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 3s277ms 5 549ms 695ms 655ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 20 1 676ms 676ms Oct 14 20 1 664ms 664ms Oct 15 20 1 691ms 691ms Oct 16 20 1 549ms 549ms Oct 17 20 1 695ms 695ms [ User: a3dsupervisor - Total duration: 3s277ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s277ms - Times executed: 5 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-17 18:30:37 Duration: 695ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-15 18:31:12 Duration: 691ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-13 18:30:23 Duration: 676ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 2s233ms 5 422ms 493ms 446ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 20 1 442ms 442ms Oct 14 20 1 427ms 427ms Oct 15 20 1 422ms 422ms Oct 16 20 1 447ms 447ms Oct 17 20 1 493ms 493ms [ User: a3dsupervisor - Total duration: 2s233ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s233ms - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-17 18:30:39 Duration: 493ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-16 18:29:43 Duration: 447ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-13 18:30:26 Duration: 442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 2s154ms 5 251ms 528ms 430ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 20 1 528ms 528ms Oct 14 20 1 477ms 477ms Oct 15 20 1 415ms 415ms Oct 16 20 1 251ms 251ms Oct 17 20 1 480ms 480ms [ User: a3dsupervisor - Total duration: 2s154ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s154ms - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-13 18:30:24 Duration: 528ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-17 18:30:37 Duration: 480ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-14 18:17:35 Duration: 477ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 2s84ms 5 365ms 556ms 416ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 20 1 387ms 387ms Oct 14 20 1 379ms 379ms Oct 15 20 1 394ms 394ms Oct 16 20 1 556ms 556ms Oct 17 20 1 365ms 365ms [ User: a3dsupervisor - Total duration: 2s84ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s84ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-16 18:29:41 Duration: 556ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-15 18:31:13 Duration: 394ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-13 18:30:24 Duration: 387ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 1s984ms 5 356ms 488ms 396ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 20 1 377ms 377ms Oct 14 20 1 356ms 356ms Oct 15 20 1 381ms 381ms Oct 16 20 1 488ms 488ms Oct 17 20 1 379ms 379ms [ User: a3dsupervisor - Total duration: 1s984ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s984ms - Times executed: 5 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 488ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 381ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-17 18:30:38 Duration: 379ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 1s500ms 5 287ms 330ms 300ms copy public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 20 1 290ms 290ms Oct 14 20 1 290ms 290ms Oct 15 20 1 287ms 287ms Oct 16 20 1 330ms 330ms Oct 17 20 1 300ms 300ms [ User: a3dsupervisor - Total duration: 1s500ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s500ms - Times executed: 5 ]
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-17 18:30:38 Duration: 300ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-13 18:30:25 Duration: 290ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 932ms 5 180ms 192ms 186ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 13 20 1 180ms 180ms Oct 14 20 1 192ms 192ms Oct 15 20 1 190ms 190ms Oct 16 20 1 187ms 187ms Oct 17 20 1 181ms 181ms [ User: a3dsupervisor - Total duration: 932ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 932ms - Times executed: 5 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-14 18:17:37 Duration: 192ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 187ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 861ms 5 159ms 189ms 172ms copy public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 20 1 161ms 161ms Oct 14 20 1 163ms 163ms Oct 15 20 1 186ms 186ms Oct 16 20 1 189ms 189ms Oct 17 20 1 159ms 159ms [ User: a3dsupervisor - Total duration: 861ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 861ms - Times executed: 5 ]
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 186ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-10-14 18:17:36 Duration: 163ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 811ms 5 129ms 209ms 162ms copy public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 20 1 209ms 209ms Oct 14 20 1 129ms 129ms Oct 15 20 1 138ms 138ms Oct 16 20 1 130ms 130ms Oct 17 20 1 203ms 203ms [ User: a3dsupervisor - Total duration: 811ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 811ms - Times executed: 5 ]
-
COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;
Date: 2025-10-13 18:30:25 Duration: 209ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;
Date: 2025-10-17 18:30:39 Duration: 203ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 138ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 540ms 5 77ms 157ms 108ms copy public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 20 1 157ms 157ms Oct 14 20 1 81ms 81ms Oct 15 20 1 77ms 77ms Oct 16 20 1 78ms 78ms Oct 17 20 1 145ms 145ms [ User: a3dsupervisor - Total duration: 540ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 540ms - Times executed: 5 ]
-
COPY public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) TO stdout;
Date: 2025-10-13 18:30:26 Duration: 157ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) TO stdout;
Date: 2025-10-17 18:30:40 Duration: 145ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) TO stdout;
Date: 2025-10-14 18:17:38 Duration: 81ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 820 172ms 0ms 15ms 0ms select format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle from pg_catalog.pg_sequence where seqrelid = ?::oid;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 20 164 39ms 0ms Oct 14 20 164 32ms 0ms Oct 15 20 164 30ms 0ms Oct 16 20 164 29ms 0ms Oct 17 20 164 41ms 0ms [ User: a3dsupervisor - Total duration: 172ms - Times executed: 820 ]
[ Application: pg_dump - Total duration: 172ms - Times executed: 820 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;
Date: 2025-10-17 18:24:26 Duration: 15ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;
Date: 2025-10-13 18:23:56 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;
Date: 2025-10-14 18:11:06 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 545 119ms 0ms 8ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 20 109 26ms 0ms Oct 14 20 109 21ms 0ms Oct 15 20 109 20ms 0ms Oct 16 20 109 21ms 0ms Oct 17 20 109 30ms 0ms [ User: a3dsupervisor - Total duration: 119ms - Times executed: 545 ]
[ Application: pg_dump - Total duration: 119ms - Times executed: 545 ]
-
EXECUTE dumpFunc ('2818849');
Date: 2025-10-17 18:24:25 Duration: 8ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818849');
Date: 2025-10-13 18:23:56 Duration: 5ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818867');
Date: 2025-10-17 18:24:25 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 95 8ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 20 19 1ms 0ms Oct 14 20 19 1ms 0ms Oct 15 20 19 1ms 0ms Oct 16 20 19 1ms 0ms Oct 17 20 19 1ms 0ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 95 ]
[ Application: pg_dump - Total duration: 8ms - Times executed: 95 ]
-
SELECT pg_catalog.format_type('2801266'::pg_catalog.oid, NULL);
Date: 2025-10-16 18:22:50 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('1043'::pg_catalog.oid, NULL);
Date: 2025-10-13 18:23:56 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2818847'::pg_catalog.oid, NULL);
Date: 2025-10-17 18:24:25 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 70 8ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 20 14 1ms 0ms Oct 14 20 14 1ms 0ms Oct 15 20 14 1ms 0ms Oct 16 20 14 1ms 0ms Oct 17 20 14 1ms 0ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 70 ]
[ Application: pg_dump - Total duration: 8ms - Times executed: 70 ]
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819015'::pg_catalog.oid);
Date: 2025-10-15 18:25:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819023'::pg_catalog.oid);
Date: 2025-10-16 18:22:52 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819022'::pg_catalog.oid);
Date: 2025-10-16 18:22:52 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 30 102ms 0ms 62ms 3ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 20 6 63ms 10ms Oct 14 20 6 10ms 1ms Oct 15 20 6 12ms 2ms Oct 16 20 6 3ms 0ms Oct 17 20 6 13ms 2ms [ User: a3dsupervisor - Total duration: 102ms - Times executed: 30 ]
[ Application: pg_dump - Total duration: 102ms - Times executed: 30 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-13 18:23:54 Duration: 62ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-17 18:24:24 Duration: 11ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-15 18:24:58 Duration: 10ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 30 22ms 0ms 3ms 0ms execute dumpcompositetype (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 13 20 6 6ms 1ms Oct 14 20 6 3ms 0ms Oct 15 20 6 3ms 0ms Oct 16 20 6 3ms 0ms Oct 17 20 6 5ms 0ms [ User: a3dsupervisor - Total duration: 22ms - Times executed: 30 ]
[ Application: pg_dump - Total duration: 22ms - Times executed: 30 ]
-
EXECUTE dumpCompositeType ('2818836');
Date: 2025-10-13 18:23:56 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2818836');
Date: 2025-10-17 18:24:25 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2818836');
Date: 2025-10-15 18:24:59 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 15 207ms 12ms 20ms 13ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 16 14 1 20ms 20ms 15 3 39ms 13ms Oct 17 16 1 19ms 19ms 17 1 12ms 12ms 18 2 25ms 12ms 19 3 38ms 12ms Oct 18 11 2 25ms 12ms 17 2 26ms 13ms [ User: a3dsupervisor - Total duration: 207ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 207ms - Times executed: 15 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-16 12:52:34 Duration: 20ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 14:53:01 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-16 13:51:28 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
8 15 148ms 1ms 67ms 9ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 20 3 71ms 23ms Oct 14 20 3 19ms 6ms Oct 15 20 3 20ms 6ms Oct 16 20 3 7ms 2ms Oct 17 20 3 29ms 9ms [ User: a3dsupervisor - Total duration: 148ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 148ms - Times executed: 15 ]
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-10-13 18:23:54 Duration: 67ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-10-17 18:24:24 Duration: 25ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-10-15 18:24:59 Duration: 16ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 15 141ms 7ms 18ms 9ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 16 14 1 16ms 16ms 15 3 22ms 7ms Oct 17 16 1 16ms 16ms 17 1 7ms 7ms 18 2 15ms 7ms 19 3 22ms 7ms Oct 18 11 2 25ms 12ms 17 2 15ms 7ms [ User: a3dsupervisor - Total duration: 141ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 141ms - Times executed: 15 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-18 09:54:24 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-17 14:53:01 Duration: 16ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-16 12:52:34 Duration: 16ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
10 15 108ms 6ms 10ms 7ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 16 14 1 6ms 6ms 15 3 20ms 6ms Oct 17 16 1 7ms 7ms 17 1 7ms 7ms 18 2 14ms 7ms 19 3 20ms 6ms Oct 18 11 2 14ms 7ms 17 2 17ms 8ms [ User: a3dsupervisor - Total duration: 108ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 108ms - Times executed: 15 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-18 15:03:29 Duration: 10ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-17 15:01:05 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-16 13:51:28 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
11 15 93ms 5ms 6ms 6ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 16 14 1 6ms 6ms 15 3 18ms 6ms Oct 17 16 1 6ms 6ms 17 1 6ms 6ms 18 2 12ms 6ms 19 3 18ms 6ms Oct 18 11 2 12ms 6ms 17 2 12ms 6ms [ User: a3dsupervisor - Total duration: 93ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 93ms - Times executed: 15 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-17 14:53:01 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-16 13:51:28 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-16 13:12:42 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
12 15 21ms 0ms 8ms 1ms select pg_catalog.pg_is_in_recovery();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 20 3 8ms 2ms Oct 14 20 3 1ms 0ms Oct 15 20 3 3ms 1ms Oct 16 20 3 1ms 0ms Oct 17 20 3 5ms 1ms [ User: a3dsupervisor - Total duration: 21ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 21ms - Times executed: 15 ]
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-13 18:23:54 Duration: 8ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-17 18:24:24 Duration: 5ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-15 18:24:58 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 15 12ms 0ms 5ms 0ms select count(*) as application_nb_user_not_anonymise from a3d_user where upper(user_login) not like ? and user_login not in (...) and user_login not like ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 16 14 1 5ms 5ms 15 3 0ms 0ms Oct 17 16 1 4ms 4ms 17 1 0ms 0ms 18 2 0ms 0ms 19 3 0ms 0ms Oct 18 11 2 0ms 0ms 17 2 0ms 0ms [ User: a3dsupervisor - Total duration: 12ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 12ms - Times executed: 15 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-16 12:52:34 Duration: 5ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-17 14:53:01 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-18 09:54:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
14 15 8ms 0ms 0ms 0ms select count(*) as database_nb_active_session from pg_stat_activity where upper(state) is not null and datname = and pid <> pg_backend_pid();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 16 14 1 0ms 0ms 15 3 1ms 0ms Oct 17 16 1 0ms 0ms 17 1 0ms 0ms 18 2 0ms 0ms 19 3 1ms 0ms Oct 18 11 2 1ms 0ms 17 2 0ms 0ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 8ms - Times executed: 15 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-10-18 09:54:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-10-18 09:57:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-10-17 14:53:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
15 15 5ms 0ms 1ms 0ms select version as application_release from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 16 14 1 1ms 1ms 15 3 0ms 0ms Oct 17 16 1 1ms 1ms 17 1 0ms 0ms 18 2 0ms 0ms 19 3 0ms 0ms Oct 18 11 2 0ms 0ms 17 2 0ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 15 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 15 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 14:53:01 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-16 12:52:34 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 15:01:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
16 15 2ms 0ms 1ms 0ms set synchronize_seqscans to off;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 20 3 0ms 0ms Oct 14 20 3 0ms 0ms Oct 15 20 3 0ms 0ms Oct 16 20 3 0ms 0ms Oct 17 20 3 1ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 2ms - Times executed: 15 ]
-
SET synchronize_seqscans TO off;
Date: 2025-10-17 18:24:28 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET synchronize_seqscans TO off;
Date: 2025-10-17 18:24:28 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET synchronize_seqscans TO off;
Date: 2025-10-16 18:22:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 15 1ms 0ms 0ms 0ms set datestyle = iso;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 13 20 3 0ms 0ms Oct 14 20 3 0ms 0ms Oct 15 20 3 0ms 0ms Oct 16 20 3 0ms 0ms Oct 17 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 15 ]
-
SET DATESTYLE = ISO;
Date: 2025-10-14 18:11:04 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-10-16 18:22:52 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-10-17 18:24:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 15 0ms 0ms 0ms 0ms set extra_float_digits to ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 20 3 0ms 0ms Oct 14 20 3 0ms 0ms Oct 15 20 3 0ms 0ms Oct 16 20 3 0ms 0ms Oct 17 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET extra_float_digits TO 3;
Date: 2025-10-15 18:25:02 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET extra_float_digits TO 3;
Date: 2025-10-15 18:25:02 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET extra_float_digits TO 3;
Date: 2025-10-13 18:23:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 15 0ms 0ms 0ms 0ms set row_security = off;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 20 3 0ms 0ms Oct 14 20 3 0ms 0ms Oct 15 20 3 0ms 0ms Oct 16 20 3 0ms 0ms Oct 17 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET row_security = off;
Date: 2025-10-14 18:11:08 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET row_security = off;
Date: 2025-10-15 18:24:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET row_security = off;
Date: 2025-10-15 18:25:02 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 15 0ms 0ms 0ms 0ms set statement_timeout = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 20 3 0ms 0ms Oct 14 20 3 0ms 0ms Oct 15 20 3 0ms 0ms Oct 16 20 3 0ms 0ms Oct 17 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET statement_timeout = 0;
Date: 2025-10-16 18:22:52 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-10-13 18:23:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-10-17 18:24:28 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 21s110ms 22s938ms 21s645ms 5 1m48s 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 #1
Day Hour Count Duration Avg duration Oct 13 20 1 21s343ms 21s343ms Oct 14 20 1 21s531ms 21s531ms Oct 15 20 1 21s304ms 21s304ms Oct 16 20 1 21s110ms 21s110ms Oct 17 20 1 22s938ms 22s938ms [ User: a3dsupervisor - Total duration: 1m48s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 5 ]
-
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-10-17 18:29:50 Duration: 22s938ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-14 18:16:49 Duration: 21s531ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-13 18:29:36 Duration: 21s343ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 12s522ms 12s748ms 12s611ms 5 1m3s 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 #2
Day Hour Count Duration Avg duration Oct 13 20 1 12s611ms 12s611ms Oct 14 20 1 12s544ms 12s544ms Oct 15 20 1 12s629ms 12s629ms Oct 16 20 1 12s522ms 12s522ms Oct 17 20 1 12s748ms 12s748ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m3s - Times executed: 5 ]
-
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-10-17 18:30:03 Duration: 12s748ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-15 18:30:39 Duration: 12s629ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-13 18:29:49 Duration: 12s611ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 8s476ms 9s69ms 8s703ms 5 43s517ms 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 #3
Day Hour Count Duration Avg duration Oct 13 20 1 9s69ms 9s69ms Oct 14 20 1 8s650ms 8s650ms Oct 15 20 1 8s711ms 8s711ms Oct 16 20 1 8s609ms 8s609ms Oct 17 20 1 8s476ms 8s476ms [ User: a3dsupervisor - Total duration: 43s517ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 43s517ms - Times executed: 5 ]
-
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-10-13 18:29:58 Duration: 9s69ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-15 18:30:48 Duration: 8s711ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-14 18:17:10 Duration: 8s650ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 8s269ms 8s559ms 8s405ms 5 42s29ms 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 20 1 8s559ms 8s559ms Oct 14 20 1 8s341ms 8s341ms Oct 15 20 1 8s410ms 8s410ms Oct 16 20 1 8s269ms 8s269ms Oct 17 20 1 8s447ms 8s447ms [ User: a3dsupervisor - Total duration: 42s29ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 42s29ms - Times executed: 5 ]
-
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) TO stdout;
Date: 2025-10-13 18:30:06 Duration: 8s559ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-17 18:30:20 Duration: 8s447ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-15 18:30:56 Duration: 8s410ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5s938ms 6s665ms 6s165ms 5 30s826ms 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 #5
Day Hour Count Duration Avg duration Oct 13 20 1 5s938ms 5s938ms Oct 14 20 1 5s965ms 5s965ms Oct 15 20 1 6s17ms 6s17ms Oct 16 20 1 6s665ms 6s665ms Oct 17 20 1 6s240ms 6s240ms [ User: a3dsupervisor - Total duration: 30s826ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 30s826ms - Times executed: 5 ]
-
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-10-16 18:29:29 Duration: 6s665ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-17 18:30:26 Duration: 6s240ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-15 18:31:02 Duration: 6s17ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 4s610ms 5s173ms 4s880ms 5 24s400ms 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 #6
Day Hour Count Duration Avg duration Oct 13 20 1 5s154ms 5s154ms Oct 14 20 1 4s786ms 4s786ms Oct 15 20 1 4s675ms 4s675ms Oct 16 20 1 4s610ms 4s610ms Oct 17 20 1 5s173ms 5s173ms [ User: a3dsupervisor - Total duration: 24s400ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 24s400ms - Times executed: 5 ]
-
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-10-17 18:30:31 Duration: 5s173ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-13 18:30:18 Duration: 5s154ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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-10-14 18:17:29 Duration: 4s786ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 1s58ms 1s369ms 1s186ms 5 5s934ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 20 1 1s163ms 1s163ms Oct 14 20 1 1s159ms 1s159ms Oct 15 20 1 1s369ms 1s369ms Oct 16 20 1 1s58ms 1s58ms Oct 17 20 1 1s182ms 1s182ms [ User: a3dsupervisor - Total duration: 5s934ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s934ms - Times executed: 5 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-15 18:31:08 Duration: 1s369ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-17 18:30:32 Duration: 1s182ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-13 18:30:19 Duration: 1s163ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 955ms 1s289ms 1s75ms 5 5s376ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 20 1 971ms 971ms Oct 14 20 1 1s117ms 1s117ms Oct 15 20 1 1s43ms 1s43ms Oct 16 20 1 1s289ms 1s289ms Oct 17 20 1 955ms 955ms [ User: a3dsupervisor - Total duration: 5s376ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s376ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-16 18:29:38 Duration: 1s289ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-14 18:17:33 Duration: 1s117ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-15 18:31:11 Duration: 1s43ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 959ms 1s189ms 1s51ms 5 5s259ms copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 20 1 1s189ms 1s189ms Oct 14 20 1 959ms 959ms Oct 15 20 1 976ms 976ms Oct 16 20 1 968ms 968ms Oct 17 20 1 1s166ms 1s166ms [ User: a3dsupervisor - Total duration: 5s259ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s259ms - Times executed: 5 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-13 18:30:21 Duration: 1s189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-17 18:30:34 Duration: 1s166ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-15 18:31:10 Duration: 976ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 649ms 899ms 777ms 5 3s887ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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 #10
Day Hour Count Duration Avg duration Oct 13 20 1 848ms 848ms Oct 14 20 1 711ms 711ms Oct 15 20 1 778ms 778ms Oct 16 20 1 649ms 649ms Oct 17 20 1 899ms 899ms [ User: a3dsupervisor - Total duration: 3s887ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s887ms - Times executed: 5 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-10-17 18:30:36 Duration: 899ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-10-13 18:30:22 Duration: 848ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, 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-10-15 18:31:11 Duration: 778ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 549ms 695ms 655ms 5 3s277ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 20 1 676ms 676ms Oct 14 20 1 664ms 664ms Oct 15 20 1 691ms 691ms Oct 16 20 1 549ms 549ms Oct 17 20 1 695ms 695ms [ User: a3dsupervisor - Total duration: 3s277ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s277ms - Times executed: 5 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-17 18:30:37 Duration: 695ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-15 18:31:12 Duration: 691ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-13 18:30:23 Duration: 676ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 422ms 493ms 446ms 5 2s233ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 20 1 442ms 442ms Oct 14 20 1 427ms 427ms Oct 15 20 1 422ms 422ms Oct 16 20 1 447ms 447ms Oct 17 20 1 493ms 493ms [ User: a3dsupervisor - Total duration: 2s233ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s233ms - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-17 18:30:39 Duration: 493ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-16 18:29:43 Duration: 447ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-13 18:30:26 Duration: 442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 251ms 528ms 430ms 5 2s154ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 20 1 528ms 528ms Oct 14 20 1 477ms 477ms Oct 15 20 1 415ms 415ms Oct 16 20 1 251ms 251ms Oct 17 20 1 480ms 480ms [ User: a3dsupervisor - Total duration: 2s154ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s154ms - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-13 18:30:24 Duration: 528ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-17 18:30:37 Duration: 480ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-14 18:17:35 Duration: 477ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 365ms 556ms 416ms 5 2s84ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 20 1 387ms 387ms Oct 14 20 1 379ms 379ms Oct 15 20 1 394ms 394ms Oct 16 20 1 556ms 556ms Oct 17 20 1 365ms 365ms [ User: a3dsupervisor - Total duration: 2s84ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s84ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-16 18:29:41 Duration: 556ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-15 18:31:13 Duration: 394ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-13 18:30:24 Duration: 387ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 356ms 488ms 396ms 5 1s984ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 20 1 377ms 377ms Oct 14 20 1 356ms 356ms Oct 15 20 1 381ms 381ms Oct 16 20 1 488ms 488ms Oct 17 20 1 379ms 379ms [ User: a3dsupervisor - Total duration: 1s984ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s984ms - Times executed: 5 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 488ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 381ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-17 18:30:38 Duration: 379ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 287ms 330ms 300ms 5 1s500ms copy public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 20 1 290ms 290ms Oct 14 20 1 290ms 290ms Oct 15 20 1 287ms 287ms Oct 16 20 1 330ms 330ms Oct 17 20 1 300ms 300ms [ User: a3dsupervisor - Total duration: 1s500ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s500ms - Times executed: 5 ]
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 330ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-17 18:30:38 Duration: 300ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-13 18:30:25 Duration: 290ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 180ms 192ms 186ms 5 932ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 13 20 1 180ms 180ms Oct 14 20 1 192ms 192ms Oct 15 20 1 190ms 190ms Oct 16 20 1 187ms 187ms Oct 17 20 1 181ms 181ms [ User: a3dsupervisor - Total duration: 932ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 932ms - Times executed: 5 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-14 18:17:37 Duration: 192ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 190ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 187ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 159ms 189ms 172ms 5 861ms copy public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 20 1 161ms 161ms Oct 14 20 1 163ms 163ms Oct 15 20 1 186ms 186ms Oct 16 20 1 189ms 189ms Oct 17 20 1 159ms 159ms [ User: a3dsupervisor - Total duration: 861ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 861ms - Times executed: 5 ]
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-10-16 18:29:42 Duration: 189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 186ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-10-14 18:17:36 Duration: 163ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 129ms 209ms 162ms 5 811ms copy public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 20 1 209ms 209ms Oct 14 20 1 129ms 129ms Oct 15 20 1 138ms 138ms Oct 16 20 1 130ms 130ms Oct 17 20 1 203ms 203ms [ User: a3dsupervisor - Total duration: 811ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 811ms - Times executed: 5 ]
-
COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;
Date: 2025-10-13 18:30:25 Duration: 209ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;
Date: 2025-10-17 18:30:39 Duration: 203ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;
Date: 2025-10-15 18:31:14 Duration: 138ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 77ms 157ms 108ms 5 540ms copy public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 20 1 157ms 157ms Oct 14 20 1 81ms 81ms Oct 15 20 1 77ms 77ms Oct 16 20 1 78ms 78ms Oct 17 20 1 145ms 145ms [ User: a3dsupervisor - Total duration: 540ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 540ms - Times executed: 5 ]
-
COPY public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) TO stdout;
Date: 2025-10-13 18:30:26 Duration: 157ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) TO stdout;
Date: 2025-10-17 18:30:40 Duration: 145ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) TO stdout;
Date: 2025-10-14 18:17:38 Duration: 81ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 236ms 19 1ms 121ms 12ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Oct 18 14 1 38ms 38ms 15 3 4ms 1ms Oct 18 16 1 121ms 121ms 17 1 1ms 1ms 18 2 3ms 1ms 19 3 4ms 1ms Oct 18 11 4 54ms 13ms 17 4 6ms 1ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 19 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-10-17 14:53:01 Duration: 121ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-10-16 12:52:34 Duration: 38ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-10-18 09:54:24 Duration: 25ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 125ms 19 0ms 77ms 6ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 12 1 12ms 12ms 13 3 1ms 0ms 14 1 77ms 77ms 15 1 0ms 0ms 16 2 1ms 0ms 17 3 1ms 0ms 09 4 28ms 7ms 15 4 2ms 0ms [ User: a3dsupervisor - Total duration: 139ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 139ms - Times executed: 19 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-17 14:53:01 Duration: 77ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-18 09:54:24 Duration: 13ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-16 12:52:34 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 89ms 19 0ms 41ms 4ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 12 1 11ms 11ms 13 3 2ms 0ms 14 1 41ms 41ms 15 1 0ms 0ms 16 2 1ms 0ms 17 3 2ms 0ms 09 4 25ms 6ms 15 4 3ms 0ms [ User: a3dsupervisor - Total duration: 183ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 183ms - Times executed: 19 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-17 14:53:01 Duration: 41ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-18 09:54:24 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-16 12:52:34 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 45ms 19 0ms 25ms 2ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 12 1 4ms 4ms 13 3 0ms 0ms 14 1 25ms 25ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 09 4 12ms 3ms 15 4 0ms 0ms [ User: a3dsupervisor - Total duration: 118ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 118ms - Times executed: 19 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-17 14:53:01 Duration: 25ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-18 09:54:24 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-16 12:52:34 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 23ms 19 0ms 8ms 1ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 12 1 3ms 3ms 13 3 1ms 0ms 14 1 8ms 8ms 15 1 0ms 0ms 16 2 1ms 0ms 17 3 1ms 0ms 09 4 4ms 1ms 15 4 2ms 0ms [ User: a3dsupervisor - Total duration: 14ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 14ms - Times executed: 19 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-17 14:53:01 Duration: 8ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-16 12:52:34 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-18 09:54:24 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 21ms 19 0ms 8ms 1ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 12 1 8ms 8ms 13 3 1ms 0ms 14 1 4ms 4ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 1ms 0ms 09 4 2ms 0ms 15 4 1ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 19 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-16 12:52:34 Duration: 8ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 14:53:01 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-18 09:54:24 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 17ms 19 0ms 9ms 0ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 12 1 3ms 3ms 13 3 0ms 0ms 14 1 9ms 9ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 09 4 1ms 0ms 15 4 1ms 0ms [ User: a3dsupervisor - Total duration: 259ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 259ms - Times executed: 19 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-17 14:53:01 Duration: 9ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-16 12:52:34 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-17 15:01:05 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 2ms 19 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 12 1 0ms 0ms 13 3 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 09 4 0ms 0ms 15 4 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 19 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 17:43:51 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 15:01:05 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 14:53:01 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 143ms 19 0ms 68ms 7ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 18 14 1 32ms 32ms 15 3 2ms 0ms Oct 18 16 1 68ms 68ms 17 1 1ms 1ms 18 2 2ms 1ms 19 3 2ms 0ms Oct 18 11 4 30ms 7ms 17 4 3ms 0ms [ User: a3dsupervisor - Total duration: 183ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 183ms - Times executed: 19 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-17 14:53:01 Duration: 68ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-16 12:52:34 Duration: 32ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-18 09:54:24 Duration: 14ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 113ms 19 0ms 61ms 5ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 12 1 11ms 11ms 13 3 3ms 1ms 14 1 61ms 61ms 15 1 1ms 1ms 16 2 2ms 1ms 17 3 2ms 0ms 09 4 26ms 6ms 15 4 4ms 1ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 19 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-10-17 14:53:01 Duration: 61ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-10-18 09:54:24 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-10-16 12:52:34 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 85ms 19 0ms 37ms 4ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 12 1 30ms 30ms 13 3 1ms 0ms 14 1 37ms 37ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 1ms 0ms 09 4 11ms 2ms 15 4 1ms 0ms [ User: a3dsupervisor - Total duration: 259ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 259ms - Times executed: 19 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-17 14:53:01 Duration: 37ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-16 12:52:34 Duration: 30ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-18 09:54:24 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 73ms 19 0ms 31ms 3ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 12 1 31ms 31ms 13 3 1ms 0ms 14 1 26ms 26ms 15 1 0ms 0ms 16 2 1ms 0ms 17 3 1ms 0ms 09 4 9ms 2ms 15 4 1ms 0ms [ User: a3dsupervisor - Total duration: 14ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 14ms - Times executed: 19 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-16 12:52:34 Duration: 31ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-17 14:53:01 Duration: 26ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-18 09:54:24 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 22ms 19 0ms 13ms 1ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 12 1 3ms 3ms 13 3 0ms 0ms 14 1 13ms 13ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 09 4 3ms 0ms 15 4 0ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 19 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 14:53:01 Duration: 13ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-16 12:52:34 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-18 09:54:24 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 11ms 19 0ms 3ms 0ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 12 1 1ms 1ms 13 3 0ms 0ms 14 1 3ms 3ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 09 4 3ms 0ms 15 4 0ms 0ms [ User: a3dsupervisor - Total duration: 118ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 118ms - Times executed: 19 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-17 14:53:01 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-18 09:54:24 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-16 12:52:34 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 3ms 19 0ms 0ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 12 1 0ms 0ms 13 3 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 09 4 0ms 0ms 15 4 1ms 0ms [ User: a3dsupervisor - Total duration: 139ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 139ms - Times executed: 19 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-18 15:08:27 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-18 15:03:29 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-18 09:54:24 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 2ms 19 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 12 1 0ms 0ms 13 3 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 2 0ms 0ms 17 3 0ms 0ms 09 4 0ms 0ms 15 4 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 19 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 19 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 15:01:05 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-17 14:53:01 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-16 13:12:42 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
Events
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET