pgBadger-
Global information
- Generated on Mon Oct 6 09:34:26 2025
- Log file: ././A3D-RND-REF/y=2025/m=10/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=10/d=04/h=23/m=00/PT1H.log
- Parsed 937,433 log entries in 3m26s
- Log start from 2025-09-29 09:05:56 to 2025-10-03 18:22:57
-
Overview
Global Stats
- 739 Number of unique normalized queries
- 5,448 Number of queries
- 6m3s Total query duration
- 2025-09-29 09:05:56 First query
- 2025-10-03 18:22:57 Last query
- 224 queries/s at 2025-10-01 18:24:22 Query peak
- 6m3s Total query duration
- 520ms Prepare/parse total duration
- 371ms Bind total duration
- 6m2s 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
- 26 Total number of sessions
- 2 sessions at 2025-09-29 18:24:42 Session peak
- 2h42m34s Total duration of sessions
- 6m15s Average duration of sessions
- 209 Average queries per session
- 13s983ms Average queries duration per session
- 6m1s Average idle time per session
- 26 Total number of connections
- 2 connections/s at 2025-10-01 18:24:24 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 224 queries/s Query Peak
- 2025-10-01 18:24:22 Date
SELECT Traffic
Key values
- 208 queries/s Query Peak
- 2025-09-30 18:24:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 109 queries/s Query Peak
- 2025-09-30 18:30:26 Date
Queries duration
Key values
- 6m3s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 29 09 8 0ms 58ms 14ms 118ms 118ms 118ms 18 1,072 0ms 22s3ms 69ms 34s864ms 37s418ms 37s418ms Sep 30 09 8 0ms 17ms 6ms 49ms 49ms 49ms 18 1,072 0ms 21s607ms 66ms 27s354ms 42s929ms 42s929ms Oct 01 07 8 0ms 19ms 6ms 53ms 53ms 53ms 09 8 0ms 12ms 4ms 33ms 33ms 33ms 10 8 0ms 12ms 4ms 34ms 34ms 34ms 15 8 0ms 15ms 4ms 36ms 36ms 36ms 18 1,072 0ms 22s708ms 67ms 963ms 1m10s 1m10s Oct 02 07 8 0ms 16ms 6ms 51ms 51ms 51ms 08 8 0ms 12ms 4ms 37ms 37ms 37ms 14 24 0ms 13ms 4ms 107ms 107ms 107ms 18 1,072 0ms 22s839ms 69ms 21s583ms 52s483ms 52s483ms Oct 03 18 1,072 0ms 20s935ms 66ms 581ms 1m10s 1m10s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 29 09 8 0 14ms 118ms 118ms 118ms 18 430 242 109ms 1s649ms 34s863ms 37s396ms Sep 30 09 8 0 6ms 49ms 49ms 49ms 18 430 242 105ms 552ms 27s333ms 42s928ms Oct 01 07 8 0 6ms 53ms 53ms 53ms 09 8 0 4ms 33ms 33ms 33ms 10 8 0 4ms 34ms 34ms 34ms 15 8 0 4ms 36ms 36ms 36ms 18 430 242 106ms 515ms 946ms 1m10s Oct 02 07 8 0 6ms 51ms 51ms 51ms 08 8 0 4ms 37ms 37ms 37ms 14 24 0 4ms 107ms 107ms 107ms 18 430 242 110ms 547ms 21s560ms 52s482ms Oct 03 18 430 242 105ms 0ms 545ms 1m10s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 29 09 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Sep 30 09 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Oct 01 07 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Oct 02 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Oct 03 18 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 29 09 8 8 1.00 100.00% 18 3 116 38.67 0.44% Sep 30 09 8 8 1.00 100.00% 18 3 116 38.67 0.44% Oct 01 07 8 8 1.00 100.00% 09 8 8 1.00 100.00% 10 8 8 1.00 100.00% 15 8 8 1.00 100.00% 18 3 116 38.67 0.44% Oct 02 07 8 8 1.00 100.00% 08 8 8 1.00 100.00% 14 24 24 1.00 100.00% 18 3 116 38.67 0.44% Oct 03 18 3 116 38.67 0.44% Day Hour Count Average / Second Sep 29 09 1 0.00/s 18 3 0.00/s Sep 30 09 1 0.00/s 18 3 0.00/s Oct 01 07 1 0.00/s 09 1 0.00/s 10 1 0.00/s 15 1 0.00/s 18 3 0.00/s Oct 02 07 1 0.00/s 08 1 0.00/s 14 3 0.00/s 18 3 0.00/s Oct 03 18 3 0.00/s Day Hour Count Average Duration Average idle time Sep 29 09 1 830ms 711ms 18 3 10m25s 10m Sep 30 09 1 414ms 364ms 18 3 10m26s 10m2s Oct 01 07 1 378ms 324ms 09 1 268ms 234ms 10 1 280ms 245ms 15 1 265ms 228ms 18 3 11m4s 10m40s Oct 02 07 1 247ms 195ms 08 1 285ms 247ms 14 3 288ms 252ms 18 3 11m29s 11m4s Oct 03 18 3 10m44s 10m20s -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2025-10-01 18:24:24 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 26 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 26 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2025-09-29 18:24:42 Date
Histogram of session times
Key values
- 15 600000-1800000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 26 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 26 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 26 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 Sep 29 09 0 0 0 18 0 0 0 Sep 30 09 0 0 0 18 0 0 0 Oct 01 07 0 0 0 09 0 0 0 10 0 0 0 15 0 0 0 18 0 0 0 Oct 02 07 0 0 0 08 0 0 0 14 0 0 0 18 0 0 0 Oct 03 18 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 29 09 0 0 18 0 0 Sep 30 09 0 0 18 0 0 Oct 01 07 0 0 09 0 0 10 0 0 15 0 0 18 0 0 Oct 02 07 0 0 08 0 0 14 0 0 18 0 0 Oct 03 18 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,238 Total read queries
- 1,230 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 5,448 Requests
- 6m2s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 5,448 Requests
User Request type Count Duration a3dsupervisor Total 5,448 6m2s copy to 1,210 5m58s cte 5 16ms others 1,980 297ms select 2,238 4s334ms tcl 15 0ms Duration by user
Key values
- 6m2s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 5,448 6m2s copy to 1,210 5m58s cte 5 16ms others 1,980 297ms select 2,238 4s334ms tcl 15 0ms Queries by host
Key values
- 10.3.0.4 Main host
- 5,440 Requests
- 6m2s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 5,360 Requests
- 6m2s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-29 18:28:35 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,241 0-1ms duration
Slowest individual queries
Rank Duration Query 1 22s839ms 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-02 18:29:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 22s708ms 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-01 18:30:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 22s3ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-09-29 18:29:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 21s607ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-09-30 18:29:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 20s935ms 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-03 18:22:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 12s860ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-29 18:29:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 12s640ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-30 18:29:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 12s587ms 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-02 18:29:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 12s586ms 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-03 18:22:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 12s525ms 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-01 18:30:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 8s707ms 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-03 18:22:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 8s687ms 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-02 18:29:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 8s680ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-09-30 18:29:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 8s636ms 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-01 18:30:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 8s552ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-09-29 18:30:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 8s501ms 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-09-30 18:30:04 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 8s380ms 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-09-29 18:30:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 8s370ms 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-03 18:22:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 8s368ms 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-02 18:29:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 8s299ms 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-01 18:30:39 - 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 1m50s 5 20s935ms 22s839ms 22s18ms 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 Sep 29 20 1 22s3ms 22s3ms Sep 30 20 1 21s607ms 21s607ms Oct 01 20 1 22s708ms 22s708ms Oct 02 20 1 22s839ms 22s839ms Oct 03 20 1 20s935ms 20s935ms [ User: a3dsupervisor - Total duration: 1m50s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m50s - 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-02 18:29:24 Duration: 22s839ms 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-01 18:30:09 Duration: 22s708ms 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-09-29 18:29:42 Duration: 22s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 1m3s 5 12s525ms 12s860ms 12s639ms 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 Sep 29 20 1 12s860ms 12s860ms Sep 30 20 1 12s640ms 12s640ms Oct 01 20 1 12s525ms 12s525ms Oct 02 20 1 12s587ms 12s587ms Oct 03 20 1 12s586ms 12s586ms [ 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-09-29 18:29:55 Duration: 12s860ms 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-09-30 18:29:47 Duration: 12s640ms 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-02 18:29:36 Duration: 12s587ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 43s265ms 5 8s552ms 8s707ms 8s653ms 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 Sep 29 20 1 8s552ms 8s552ms Sep 30 20 1 8s680ms 8s680ms Oct 01 20 1 8s636ms 8s636ms Oct 02 20 1 8s687ms 8s687ms Oct 03 20 1 8s707ms 8s707ms [ User: a3dsupervisor - Total duration: 43s265ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 43s265ms - 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-03 18:22:24 Duration: 8s707ms 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-02 18:29:45 Duration: 8s687ms 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-09-30 18:29:55 Duration: 8s680ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 41s921ms 5 8s299ms 8s501ms 8s384ms 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 Sep 29 20 1 8s380ms 8s380ms Sep 30 20 1 8s501ms 8s501ms Oct 01 20 1 8s299ms 8s299ms Oct 02 20 1 8s368ms 8s368ms Oct 03 20 1 8s370ms 8s370ms [ User: a3dsupervisor - Total duration: 41s921ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 41s921ms - 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-09-30 18:30:04 Duration: 8s501ms 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-09-29 18:30:12 Duration: 8s380ms 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-03 18:22:32 Duration: 8s370ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 32s624ms 5 5s926ms 7s207ms 6s524ms 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 Sep 29 20 1 5s926ms 5s926ms Sep 30 20 1 5s937ms 5s937ms Oct 01 20 1 6s967ms 6s967ms Oct 02 20 1 7s207ms 7s207ms Oct 03 20 1 6s585ms 6s585ms [ User: a3dsupervisor - Total duration: 32s624ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 32s624ms - 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-02 18:30:01 Duration: 7s207ms 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-01 18:30:46 Duration: 6s967ms 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-03 18:22:39 Duration: 6s585ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 25s958ms 5 4s655ms 6s924ms 5s191ms 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 Sep 29 20 1 5s3ms 5s3ms Sep 30 20 1 4s687ms 4s687ms Oct 01 20 1 4s655ms 4s655ms Oct 02 20 1 6s924ms 6s924ms Oct 03 20 1 4s688ms 4s688ms [ User: a3dsupervisor - Total duration: 25s958ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 25s958ms - 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-02 18:30:08 Duration: 6s924ms 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-09-29 18:30:23 Duration: 5s3ms 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-03 18:22:44 Duration: 4s688ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 6s287ms 5 1s186ms 1s357ms 1s257ms 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 Sep 29 20 1 1s186ms 1s186ms Sep 30 20 1 1s275ms 1s275ms Oct 01 20 1 1s228ms 1s228ms Oct 02 20 1 1s357ms 1s357ms Oct 03 20 1 1s238ms 1s238ms [ User: a3dsupervisor - Total duration: 6s287ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 6s287ms - 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-02 18:30:09 Duration: 1s357ms 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-09-30 18:30:16 Duration: 1s275ms 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-03 18:22:45 Duration: 1s238ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 5s157ms 5 969ms 1s73ms 1s31ms 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 Sep 29 20 1 969ms 969ms Sep 30 20 1 1s21ms 1s21ms Oct 01 20 1 1s60ms 1s60ms Oct 02 20 1 1s73ms 1s73ms Oct 03 20 1 1s31ms 1s31ms [ User: a3dsupervisor - Total duration: 5s157ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s157ms - 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-02 18:30:12 Duration: 1s73ms 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-01 18:30:55 Duration: 1s60ms 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-03 18:22:48 Duration: 1s31ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 5s105ms 5 966ms 1s158ms 1s21ms 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 Sep 29 20 1 1s158ms 1s158ms Sep 30 20 1 976ms 976ms Oct 01 20 1 997ms 997ms Oct 02 20 1 966ms 966ms Oct 03 20 1 1s5ms 1s5ms [ User: a3dsupervisor - Total duration: 5s105ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s105ms - 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-09-29 18:30:26 Duration: 1s158ms 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-03 18:22:47 Duration: 1s5ms 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-01 18:30:54 Duration: 997ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 3s776ms 5 633ms 802ms 755ms 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 Sep 29 20 1 802ms 802ms Sep 30 20 1 795ms 795ms Oct 01 20 1 754ms 754ms Oct 02 20 1 633ms 633ms Oct 03 20 1 790ms 790ms [ User: a3dsupervisor - Total duration: 3s776ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s776ms - 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-09-29 18:30:28 Duration: 802ms 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-09-30 18:30:19 Duration: 795ms 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-03 18:22:49 Duration: 790ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 3s295ms 5 601ms 693ms 659ms 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 Sep 29 20 1 657ms 657ms Sep 30 20 1 683ms 683ms Oct 01 20 1 693ms 693ms Oct 02 20 1 601ms 601ms Oct 03 20 1 658ms 658ms [ User: a3dsupervisor - Total duration: 3s295ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s295ms - 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-01 18:30:56 Duration: 693ms 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-09-30 18:30:20 Duration: 683ms 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-03 18:22:49 Duration: 658ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 2s178ms 5 326ms 512ms 435ms 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 Sep 29 20 1 465ms 465ms Sep 30 20 1 410ms 410ms Oct 01 20 1 326ms 326ms Oct 02 20 1 512ms 512ms Oct 03 20 1 462ms 462ms [ User: a3dsupervisor - Total duration: 2s178ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s178ms - 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-02 18:30:16 Duration: 512ms 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-09-29 18:30:32 Duration: 465ms 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-03 18:22:53 Duration: 462ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 1s871ms 5 252ms 502ms 374ms 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 Sep 29 20 1 502ms 502ms Sep 30 20 1 481ms 481ms Oct 01 20 1 316ms 316ms Oct 02 20 1 252ms 252ms Oct 03 20 1 318ms 318ms [ User: a3dsupervisor - Total duration: 1s871ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s871ms - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-29 18:30:29 Duration: 502ms 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-09-30 18:30:21 Duration: 481ms 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-03 18:22:50 Duration: 318ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 1s482ms 5 245ms 396ms 296ms 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 #14
Day Hour Count Duration Avg duration Sep 29 20 1 290ms 290ms Sep 30 20 1 289ms 289ms Oct 01 20 1 245ms 245ms Oct 02 20 1 261ms 261ms Oct 03 20 1 396ms 396ms [ User: a3dsupervisor - Total duration: 1s482ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s482ms - 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-03 18:22:51 Duration: 396ms 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-09-29 18:30:30 Duration: 290ms 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-09-30 18:30:22 Duration: 289ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 1s462ms 5 157ms 778ms 292ms 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 #15
Day Hour Count Duration Avg duration Sep 29 20 1 172ms 172ms Sep 30 20 1 169ms 169ms Oct 01 20 1 185ms 185ms Oct 02 20 1 157ms 157ms Oct 03 20 1 778ms 778ms [ User: a3dsupervisor - Total duration: 1s462ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s462ms - 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-03 18:22:52 Duration: 778ms 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-01 18:30:58 Duration: 185ms 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-09-29 18:30:31 Duration: 172ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 1s450ms 5 202ms 390ms 290ms 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 #16
Day Hour Count Duration Avg duration Sep 29 20 1 384ms 384ms Sep 30 20 1 390ms 390ms Oct 01 20 1 232ms 232ms Oct 02 20 1 202ms 202ms Oct 03 20 1 240ms 240ms [ User: a3dsupervisor - Total duration: 1s450ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s450ms - 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-09-30 18:30:21 Duration: 390ms 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-09-29 18:30:30 Duration: 384ms 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-03 18:22:51 Duration: 240ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 1s288ms 5 159ms 389ms 257ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 20 1 376ms 376ms Sep 30 20 1 389ms 389ms Oct 01 20 1 171ms 171ms Oct 02 20 1 159ms 159ms Oct 03 20 1 191ms 191ms [ User: a3dsupervisor - Total duration: 1s288ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s288ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-09-30 18:30:21 Duration: 389ms 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-09-29 18:30:30 Duration: 376ms 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-03 18:22:50 Duration: 191ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 956ms 5 185ms 195ms 191ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 20 1 185ms 185ms Sep 30 20 1 195ms 195ms Oct 01 20 1 189ms 189ms Oct 02 20 1 189ms 189ms Oct 03 20 1 195ms 195ms [ User: a3dsupervisor - Total duration: 956ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 956ms - Times executed: 5 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-09-30 18:30:22 Duration: 195ms 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-03 18:22:52 Duration: 195ms 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-01 18:30:58 Duration: 189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 680ms 5 110ms 207ms 136ms 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 Sep 29 20 1 207ms 207ms Sep 30 20 1 141ms 141ms Oct 01 20 1 110ms 110ms Oct 02 20 1 110ms 110ms Oct 03 20 1 110ms 110ms [ User: a3dsupervisor - Total duration: 680ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 680ms - 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-09-29 18:30:31 Duration: 207ms 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-09-30 18:30:22 Duration: 141ms 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-03 18:22:52 Duration: 110ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 467ms 5 78ms 148ms 93ms 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 Sep 29 20 1 148ms 148ms Sep 30 20 1 78ms 78ms Oct 01 20 1 82ms 82ms Oct 02 20 1 78ms 78ms Oct 03 20 1 78ms 78ms [ User: a3dsupervisor - Total duration: 467ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 467ms - 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-09-29 18:30:32 Duration: 148ms 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-01 18:31:00 Duration: 82ms 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-03 18:22:53 Duration: 78ms 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 163ms 0ms 14ms 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 Sep 29 20 164 40ms 0ms Sep 30 20 164 28ms 0ms Oct 01 20 164 27ms 0ms Oct 02 20 164 30ms 0ms Oct 03 20 164 36ms 0ms [ User: a3dsupervisor - Total duration: 163ms - Times executed: 820 ]
[ Application: pg_dump - Total duration: 163ms - 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-09-29 18:24:29 Duration: 14ms 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-03 18:16:39 Duration: 11ms 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-01 18:24:22 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 545 111ms 0ms 6ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 20 109 29ms 0ms Sep 30 20 109 21ms 0ms Oct 01 20 109 20ms 0ms Oct 02 20 109 20ms 0ms Oct 03 20 109 19ms 0ms [ User: a3dsupervisor - Total duration: 111ms - Times executed: 545 ]
[ Application: pg_dump - Total duration: 111ms - Times executed: 545 ]
-
EXECUTE dumpFunc ('2818849');
Date: 2025-09-29 18:24:29 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818867');
Date: 2025-09-29 18:24:29 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818849');
Date: 2025-09-30 18:24:11 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 95 10ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 20 19 1ms 0ms Sep 30 20 19 1ms 0ms Oct 01 20 19 1ms 0ms Oct 02 20 19 2ms 0ms Oct 03 20 19 1ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 95 ]
[ Application: pg_dump - Total duration: 10ms - Times executed: 95 ]
-
SELECT pg_catalog.format_type('2818841'::pg_catalog.oid, NULL);
Date: 2025-10-02 18:23:45 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2818841'::pg_catalog.oid, NULL);
Date: 2025-10-01 18:24:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2818836'::pg_catalog.oid, NULL);
Date: 2025-10-03 18:16:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 70 7ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 20 14 1ms 0ms Sep 30 20 14 1ms 0ms Oct 01 20 14 1ms 0ms Oct 02 20 14 1ms 0ms Oct 03 20 14 1ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 70 ]
[ Application: pg_dump - Total duration: 7ms - Times executed: 70 ]
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819023'::pg_catalog.oid);
Date: 2025-09-30 18:24:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819013'::pg_catalog.oid);
Date: 2025-09-30 18:24:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819016'::pg_catalog.oid);
Date: 2025-09-30 18:24:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 30 29ms 0ms 9ms 0ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 20 6 11ms 1ms Sep 30 20 6 3ms 0ms Oct 01 20 6 3ms 0ms Oct 02 20 6 2ms 0ms Oct 03 20 6 8ms 1ms [ User: a3dsupervisor - Total duration: 29ms - Times executed: 30 ]
[ Application: pg_dump - Total duration: 29ms - Times executed: 30 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-29 18:24:27 Duration: 9ms 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-03 18:16:38 Duration: 7ms 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-01 18:24:24 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 30 20ms 0ms 3ms 0ms execute dumpcompositetype (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 20 6 6ms 1ms Sep 30 20 6 3ms 0ms Oct 01 20 6 3ms 0ms Oct 02 20 6 3ms 0ms Oct 03 20 6 3ms 0ms [ User: a3dsupervisor - Total duration: 20ms - Times executed: 30 ]
[ Application: pg_dump - Total duration: 20ms - Times executed: 30 ]
-
EXECUTE dumpCompositeType ('2818836');
Date: 2025-09-29 18:24:29 Duration: 3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2818836');
Date: 2025-09-30 18:24:11 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2818836');
Date: 2025-10-02 18:23:44 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 15 66ms 1ms 17ms 4ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 29 20 3 21ms 7ms Sep 30 20 3 8ms 2ms Oct 01 20 3 8ms 2ms Oct 02 20 3 9ms 3ms Oct 03 20 3 18ms 6ms [ User: a3dsupervisor - Total duration: 66ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 66ms - Times executed: 15 ]
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-09-29 18:24:27 Duration: 17ms 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-03 18:16:38 Duration: 14ms 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-02 18:23:44 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 15 12ms 0ms 5ms 0ms select pg_catalog.pg_is_in_recovery();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 20 3 6ms 2ms Sep 30 20 3 1ms 0ms Oct 01 20 3 1ms 0ms Oct 02 20 3 1ms 0ms Oct 03 20 3 2ms 0ms [ User: a3dsupervisor - Total duration: 12ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 12ms - Times executed: 15 ]
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-09-29 18:24:27 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-09-30 18:24:10 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-03 18:16:38 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 15 1ms 0ms 0ms 0ms set datestyle = iso;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 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-09-29 18:24:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-10-03 18:16:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-10-02 18:23:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 15 1ms 0ms 0ms 0ms set statement_timeout = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 15 ]
-
SET statement_timeout = 0;
Date: 2025-10-03 18:16:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-09-29 18:24:31 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-10-02 18:23:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 15 1ms 0ms 0ms 0ms set row_security = off;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 15 ]
-
SET row_security = off;
Date: 2025-10-02 18:23:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET row_security = off;
Date: 2025-10-03 18:16:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET row_security = off;
Date: 2025-09-29 18:24:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 15 0ms 0ms 0ms 0ms set extra_float_digits to ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 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-02 18:23:47 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-01 18:24:24 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-03 18:16:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 15 0ms 0ms 0ms 0ms set intervalstyle = postgres;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET INTERVALSTYLE = POSTGRES;
Date: 2025-09-30 18:24:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET INTERVALSTYLE = POSTGRES;
Date: 2025-09-29 18:24:31 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET INTERVALSTYLE = POSTGRES;
Date: 2025-10-02 18:23:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 15 0ms 0ms 0ms 0ms set idle_in_transaction_session_timeout = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET idle_in_transaction_session_timeout = 0;
Date: 2025-10-03 18:16:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET idle_in_transaction_session_timeout = 0;
Date: 2025-09-30 18:24:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET idle_in_transaction_session_timeout = 0;
Date: 2025-10-03 18:16:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 15 0ms 0ms 0ms 0ms set transaction_timeout = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET transaction_timeout = 0;
Date: 2025-10-03 18:16:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET transaction_timeout = 0;
Date: 2025-09-30 18:24:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET transaction_timeout = 0;
Date: 2025-09-30 18:24:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 15 0ms 0ms 0ms 0ms set lock_timeout = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET lock_timeout = 0;
Date: 2025-09-30 18:24:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET lock_timeout = 0;
Date: 2025-10-01 18:24:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET lock_timeout = 0;
Date: 2025-10-03 18:16:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 15 0ms 0ms 0ms 0ms set transaction isolation level repeatable read, read only;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ, READ ONLY;
Date: 2025-10-03 18:16:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ, READ ONLY;
Date: 2025-10-03 18:16:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ, READ ONLY;
Date: 2025-10-01 18:24:21 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 15 0ms 0ms 0ms 0ms set synchronize_seqscans to off;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET synchronize_seqscans TO off;
Date: 2025-09-30 18:24:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET synchronize_seqscans TO off;
Date: 2025-10-01 18:24:24 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET synchronize_seqscans TO off;
Date: 2025-10-03 18:16:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 15 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 20 3 0ms 0ms Sep 30 20 3 0ms 0ms Oct 01 20 3 0ms 0ms Oct 02 20 3 0ms 0ms Oct 03 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
BEGIN;
Date: 2025-10-03 18:16:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
BEGIN;
Date: 2025-10-01 18:24:21 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
BEGIN;
Date: 2025-09-29 18:24:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 11 189ms 12ms 42ms 17ms 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 #20
Day Hour Count Duration Avg duration Sep 29 11 1 42ms 42ms Sep 30 11 1 17ms 17ms Oct 01 09 1 19ms 19ms 11 1 12ms 12ms 12 1 12ms 12ms 17 1 15ms 15ms Oct 02 09 1 16ms 16ms 10 1 12ms 12ms 16 3 40ms 13ms [ User: a3dsupervisor - Total duration: 189ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 189ms - Times executed: 11 ]
-
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-09-29 09:05:57 Duration: 42ms 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-01 07:43:18 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-09-30 09:57:13 Duration: 17ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 20s935ms 22s839ms 22s18ms 5 1m50s 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 Sep 29 20 1 22s3ms 22s3ms Sep 30 20 1 21s607ms 21s607ms Oct 01 20 1 22s708ms 22s708ms Oct 02 20 1 22s839ms 22s839ms Oct 03 20 1 20s935ms 20s935ms [ User: a3dsupervisor - Total duration: 1m50s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m50s - 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-02 18:29:24 Duration: 22s839ms 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-01 18:30:09 Duration: 22s708ms 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-09-29 18:29:42 Duration: 22s3ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 12s525ms 12s860ms 12s639ms 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 Sep 29 20 1 12s860ms 12s860ms Sep 30 20 1 12s640ms 12s640ms Oct 01 20 1 12s525ms 12s525ms Oct 02 20 1 12s587ms 12s587ms Oct 03 20 1 12s586ms 12s586ms [ 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-09-29 18:29:55 Duration: 12s860ms 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-09-30 18:29:47 Duration: 12s640ms 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-02 18:29:36 Duration: 12s587ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 8s552ms 8s707ms 8s653ms 5 43s265ms 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 Sep 29 20 1 8s552ms 8s552ms Sep 30 20 1 8s680ms 8s680ms Oct 01 20 1 8s636ms 8s636ms Oct 02 20 1 8s687ms 8s687ms Oct 03 20 1 8s707ms 8s707ms [ User: a3dsupervisor - Total duration: 43s265ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 43s265ms - 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-03 18:22:24 Duration: 8s707ms 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-02 18:29:45 Duration: 8s687ms 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-09-30 18:29:55 Duration: 8s680ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 8s299ms 8s501ms 8s384ms 5 41s921ms 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 Sep 29 20 1 8s380ms 8s380ms Sep 30 20 1 8s501ms 8s501ms Oct 01 20 1 8s299ms 8s299ms Oct 02 20 1 8s368ms 8s368ms Oct 03 20 1 8s370ms 8s370ms [ User: a3dsupervisor - Total duration: 41s921ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 41s921ms - 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-09-30 18:30:04 Duration: 8s501ms 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-09-29 18:30:12 Duration: 8s380ms 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-03 18:22:32 Duration: 8s370ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5s926ms 7s207ms 6s524ms 5 32s624ms 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 Sep 29 20 1 5s926ms 5s926ms Sep 30 20 1 5s937ms 5s937ms Oct 01 20 1 6s967ms 6s967ms Oct 02 20 1 7s207ms 7s207ms Oct 03 20 1 6s585ms 6s585ms [ User: a3dsupervisor - Total duration: 32s624ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 32s624ms - 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-02 18:30:01 Duration: 7s207ms 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-01 18:30:46 Duration: 6s967ms 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-03 18:22:39 Duration: 6s585ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 4s655ms 6s924ms 5s191ms 5 25s958ms 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 Sep 29 20 1 5s3ms 5s3ms Sep 30 20 1 4s687ms 4s687ms Oct 01 20 1 4s655ms 4s655ms Oct 02 20 1 6s924ms 6s924ms Oct 03 20 1 4s688ms 4s688ms [ User: a3dsupervisor - Total duration: 25s958ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 25s958ms - 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-02 18:30:08 Duration: 6s924ms 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-09-29 18:30:23 Duration: 5s3ms 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-03 18:22:44 Duration: 4s688ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 1s186ms 1s357ms 1s257ms 5 6s287ms 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 Sep 29 20 1 1s186ms 1s186ms Sep 30 20 1 1s275ms 1s275ms Oct 01 20 1 1s228ms 1s228ms Oct 02 20 1 1s357ms 1s357ms Oct 03 20 1 1s238ms 1s238ms [ User: a3dsupervisor - Total duration: 6s287ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 6s287ms - 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-02 18:30:09 Duration: 1s357ms 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-09-30 18:30:16 Duration: 1s275ms 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-03 18:22:45 Duration: 1s238ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 969ms 1s73ms 1s31ms 5 5s157ms 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 Sep 29 20 1 969ms 969ms Sep 30 20 1 1s21ms 1s21ms Oct 01 20 1 1s60ms 1s60ms Oct 02 20 1 1s73ms 1s73ms Oct 03 20 1 1s31ms 1s31ms [ User: a3dsupervisor - Total duration: 5s157ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s157ms - 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-02 18:30:12 Duration: 1s73ms 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-01 18:30:55 Duration: 1s60ms 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-03 18:22:48 Duration: 1s31ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 966ms 1s158ms 1s21ms 5 5s105ms 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 Sep 29 20 1 1s158ms 1s158ms Sep 30 20 1 976ms 976ms Oct 01 20 1 997ms 997ms Oct 02 20 1 966ms 966ms Oct 03 20 1 1s5ms 1s5ms [ User: a3dsupervisor - Total duration: 5s105ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5s105ms - 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-09-29 18:30:26 Duration: 1s158ms 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-03 18:22:47 Duration: 1s5ms 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-01 18:30:54 Duration: 997ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 633ms 802ms 755ms 5 3s776ms 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 Sep 29 20 1 802ms 802ms Sep 30 20 1 795ms 795ms Oct 01 20 1 754ms 754ms Oct 02 20 1 633ms 633ms Oct 03 20 1 790ms 790ms [ User: a3dsupervisor - Total duration: 3s776ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s776ms - 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-09-29 18:30:28 Duration: 802ms 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-09-30 18:30:19 Duration: 795ms 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-03 18:22:49 Duration: 790ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 601ms 693ms 659ms 5 3s295ms 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 Sep 29 20 1 657ms 657ms Sep 30 20 1 683ms 683ms Oct 01 20 1 693ms 693ms Oct 02 20 1 601ms 601ms Oct 03 20 1 658ms 658ms [ User: a3dsupervisor - Total duration: 3s295ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s295ms - 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-01 18:30:56 Duration: 693ms 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-09-30 18:30:20 Duration: 683ms 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-03 18:22:49 Duration: 658ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 326ms 512ms 435ms 5 2s178ms 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 Sep 29 20 1 465ms 465ms Sep 30 20 1 410ms 410ms Oct 01 20 1 326ms 326ms Oct 02 20 1 512ms 512ms Oct 03 20 1 462ms 462ms [ User: a3dsupervisor - Total duration: 2s178ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s178ms - 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-02 18:30:16 Duration: 512ms 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-09-29 18:30:32 Duration: 465ms 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-03 18:22:53 Duration: 462ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 252ms 502ms 374ms 5 1s871ms 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 Sep 29 20 1 502ms 502ms Sep 30 20 1 481ms 481ms Oct 01 20 1 316ms 316ms Oct 02 20 1 252ms 252ms Oct 03 20 1 318ms 318ms [ User: a3dsupervisor - Total duration: 1s871ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s871ms - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-29 18:30:29 Duration: 502ms 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-09-30 18:30:21 Duration: 481ms 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-03 18:22:50 Duration: 318ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 245ms 396ms 296ms 5 1s482ms 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 #14
Day Hour Count Duration Avg duration Sep 29 20 1 290ms 290ms Sep 30 20 1 289ms 289ms Oct 01 20 1 245ms 245ms Oct 02 20 1 261ms 261ms Oct 03 20 1 396ms 396ms [ User: a3dsupervisor - Total duration: 1s482ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s482ms - 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-03 18:22:51 Duration: 396ms 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-09-29 18:30:30 Duration: 290ms 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-09-30 18:30:22 Duration: 289ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 157ms 778ms 292ms 5 1s462ms 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 #15
Day Hour Count Duration Avg duration Sep 29 20 1 172ms 172ms Sep 30 20 1 169ms 169ms Oct 01 20 1 185ms 185ms Oct 02 20 1 157ms 157ms Oct 03 20 1 778ms 778ms [ User: a3dsupervisor - Total duration: 1s462ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s462ms - 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-03 18:22:52 Duration: 778ms 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-01 18:30:58 Duration: 185ms 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-09-29 18:30:31 Duration: 172ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 202ms 390ms 290ms 5 1s450ms 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 #16
Day Hour Count Duration Avg duration Sep 29 20 1 384ms 384ms Sep 30 20 1 390ms 390ms Oct 01 20 1 232ms 232ms Oct 02 20 1 202ms 202ms Oct 03 20 1 240ms 240ms [ User: a3dsupervisor - Total duration: 1s450ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s450ms - 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-09-30 18:30:21 Duration: 390ms 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-09-29 18:30:30 Duration: 384ms 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-03 18:22:51 Duration: 240ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 159ms 389ms 257ms 5 1s288ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 20 1 376ms 376ms Sep 30 20 1 389ms 389ms Oct 01 20 1 171ms 171ms Oct 02 20 1 159ms 159ms Oct 03 20 1 191ms 191ms [ User: a3dsupervisor - Total duration: 1s288ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s288ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-09-30 18:30:21 Duration: 389ms 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-09-29 18:30:30 Duration: 376ms 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-03 18:22:50 Duration: 191ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 185ms 195ms 191ms 5 956ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 20 1 185ms 185ms Sep 30 20 1 195ms 195ms Oct 01 20 1 189ms 189ms Oct 02 20 1 189ms 189ms Oct 03 20 1 195ms 195ms [ User: a3dsupervisor - Total duration: 956ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 956ms - Times executed: 5 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-09-30 18:30:22 Duration: 195ms 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-03 18:22:52 Duration: 195ms 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-01 18:30:58 Duration: 189ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 110ms 207ms 136ms 5 680ms 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 Sep 29 20 1 207ms 207ms Sep 30 20 1 141ms 141ms Oct 01 20 1 110ms 110ms Oct 02 20 1 110ms 110ms Oct 03 20 1 110ms 110ms [ User: a3dsupervisor - Total duration: 680ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 680ms - 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-09-29 18:30:31 Duration: 207ms 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-09-30 18:30:22 Duration: 141ms 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-03 18:22:52 Duration: 110ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 78ms 148ms 93ms 5 467ms 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 Sep 29 20 1 148ms 148ms Sep 30 20 1 78ms 78ms Oct 01 20 1 82ms 82ms Oct 02 20 1 78ms 78ms Oct 03 20 1 78ms 78ms [ User: a3dsupervisor - Total duration: 467ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 467ms - 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-09-29 18:30:32 Duration: 148ms 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-01 18:31:00 Duration: 82ms 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-03 18:22:53 Duration: 78ms 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 208ms 11 1ms 112ms 18ms 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 03 11 1 112ms 112ms Oct 03 11 1 23ms 23ms Oct 03 09 1 32ms 32ms 11 1 1ms 1ms 12 1 1ms 1ms 17 1 1ms 1ms Oct 03 09 1 27ms 27ms 10 1 1ms 1ms 16 3 4ms 1ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 11 ]
-
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-09-29 09:05:56 Duration: 112ms 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-01 07:43:18 Duration: 32ms 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-02 07:59:08 Duration: 27ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
2 118ms 11 0ms 79ms 10ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 09 1 79ms 79ms 09 1 11ms 11ms 07 1 10ms 10ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 12ms 12ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 84ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 84ms - Times executed: 11 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-29 09:05:56 Duration: 79ms 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-02 07:59:08 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-30 09:57:12 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 82ms 11 0ms 42ms 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 prepare #3
Day Hour Count Duration Avg duration 09 1 42ms 42ms 09 1 11ms 11ms 07 1 10ms 10ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 12ms 12ms 08 1 0ms 0ms 14 3 2ms 0ms [ User: a3dsupervisor - Total duration: 161ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 161ms - Times executed: 11 ]
-
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-09-29 09:05:56 Duration: 42ms 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-02 07:59:08 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 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-09-30 09:57:13 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 45ms 11 0ms 23ms 4ms 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 09 1 23ms 23ms 09 1 5ms 5ms 07 1 9ms 9ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 5ms 5ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 69ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 69ms - Times executed: 11 ]
-
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-09-29 09:05:57 Duration: 23ms 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-01 07:43:18 Duration: 9ms 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-02 07:59:08 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
5 24ms 11 0ms 6ms 2ms 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 09 1 6ms 6ms 09 1 4ms 4ms 07 1 4ms 4ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 4ms 4ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 11 ]
-
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-09-29 09:05:57 Duration: 6ms 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-02 07:59:08 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 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-09-30 09:57:13 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 20ms 11 0ms 7ms 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 09 1 7ms 7ms 09 1 4ms 4ms 07 1 3ms 3ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 3ms 3ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 11 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-29 09:05:56 Duration: 7ms 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-09-30 09:57:13 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-02 07:59:08 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
7 19ms 11 0ms 11ms 1ms 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 09 1 11ms 11ms 09 1 2ms 2ms 07 1 2ms 2ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 2ms 2ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 189ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 189ms - Times executed: 11 ]
-
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-09-29 09:05:57 Duration: 11ms 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-09-30 09:57:13 Duration: 2ms 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-02 07:59:08 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
8 1ms 11 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 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 11 ]
-
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-01 15:26:31 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-01 07:43:18 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-09-29 09:05:56 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 118ms 11 0ms 70ms 10ms 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 03 11 1 70ms 70ms Oct 03 11 1 13ms 13ms Oct 03 09 1 12ms 12ms 11 1 1ms 1ms 12 1 0ms 0ms 17 1 1ms 1ms Oct 03 09 1 14ms 14ms 10 1 1ms 1ms 16 3 2ms 0ms [ User: a3dsupervisor - Total duration: 161ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 161ms - Times executed: 11 ]
-
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-09-29 09:05:57 Duration: 70ms 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-02 07:59:08 Duration: 14ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 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-09-30 09:57:13 Duration: 13ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 109ms 11 1ms 65ms 9ms 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 09 1 65ms 65ms 09 1 12ms 12ms 07 1 11ms 11ms 09 1 1ms 1ms 10 1 1ms 1ms 15 1 1ms 1ms 07 1 12ms 12ms 08 1 1ms 1ms 14 3 3ms 1ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 11 ]
-
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-09-29 09:05:56 Duration: 65ms 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-02 07:59:08 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 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-09-30 09:57:13 Duration: 12ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 61ms 11 0ms 38ms 5ms 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 09 1 38ms 38ms 09 1 6ms 6ms 07 1 7ms 7ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 6ms 6ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 189ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 189ms - Times executed: 11 ]
-
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-09-29 09:05:57 Duration: 38ms 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-01 07:43:18 Duration: 7ms 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-02 07:59:08 Duration: 6ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
4 49ms 11 0ms 24ms 4ms 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 09 1 24ms 24ms 09 1 6ms 6ms 07 1 8ms 8ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 6ms 6ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 11 ]
-
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-09-29 09:05:57 Duration: 24ms 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-01 07:43:18 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-09-30 09:57:13 Duration: 6ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 22ms 11 0ms 14ms 2ms 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 09 1 14ms 14ms 09 1 2ms 2ms 07 1 2ms 2ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 1ms 1ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 11 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-29 09:05:56 Duration: 14ms 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-09-30 09:57:13 Duration: 2ms 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-01 07:43:18 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 7ms 11 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 09 1 3ms 3ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 69ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 69ms - Times executed: 11 ]
-
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-09-29 09:05:57 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-09-30 09:57:13 Duration: 0ms 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-02 07:59:08 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
7 1ms 11 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 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 84ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 84ms - Times executed: 11 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-02 08:36:53 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-01 09:48:05 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-01 10:34:44 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 1ms 11 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 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 11 ]
-
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-09-29 09:05:56 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-09-30 09:57:13 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-01 09:48:05 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