pgBadger-
Global information
- Generated on Mon Nov 3 09:42:46 2025
- Log file: ././A3D-RND-REF/y=2025/m=11/d=01/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=11/d=01/h=23/m=00/PT1H.log
- Parsed 777,188 log entries in 11m3s
- Log start from 2025-10-27 06:44:30 to 2025-10-31 19:32:00
-
Overview
Global Stats
- 946 Number of unique normalized queries
- 13,198 Number of queries
- 5m21s Total query duration
- 2025-10-27 06:44:30 First query
- 2025-10-31 19:32:00 Last query
- 207 queries/s at 2025-10-29 19:24:49 Query peak
- 5m21s Total query duration
- 1s191ms Prepare/parse total duration
- 3s38ms Bind total duration
- 5m17s Execute total duration
- 16 Number of events
- 2 Number of unique normalized events
- 14 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 2 Number temporary file
- 4.19 MiB Max size of temporary file
- 4.19 MiB Average size of temporary file
- 60 Total number of sessions
- 3 sessions at 2025-10-28 12:49:16 Session peak
- 3h14m6s Total duration of sessions
- 3m14s Average duration of sessions
- 219 Average queries per session
- 5s364ms Average queries duration per session
- 3m8s Average idle time per session
- 60 Total number of connections
- 5 connections/s at 2025-10-29 11:00:19 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 207 queries/s Query Peak
- 2025-10-29 19:24:49 Date
SELECT Traffic
Key values
- 206 queries/s Query Peak
- 2025-10-30 19:28:26 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 101 queries/s Query Peak
- 2025-10-28 19:23:50 Date
Queries duration
Key values
- 5m21s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 06 8 0ms 17ms 6ms 50ms 50ms 50ms 09 32 0ms 20ms 5ms 89ms 89ms 89ms 13 32 0ms 13ms 4ms 68ms 68ms 68ms Oct 28 07 16 0ms 18ms 5ms 56ms 56ms 56ms 10 64 0ms 16ms 4ms 111ms 111ms 111ms 11 16 0ms 13ms 4ms 36ms 36ms 36ms 12 8 0ms 12ms 4ms 36ms 36ms 36ms 19 1,072 0ms 21s151ms 67ms 21s151ms 50s258ms 50s258ms Oct 29 08 16 0ms 19ms 6ms 96ms 96ms 96ms 10 8 0ms 13ms 4ms 35ms 35ms 35ms 11 8,622 0ms 21s940ms 3ms 886ms 23s76ms 23s76ms 14 40 0ms 21ms 5ms 94ms 94ms 94ms 19 1,072 0ms 20s912ms 66ms 20s912ms 49s304ms 49s304ms Oct 30 13 48 0ms 20ms 4ms 103ms 103ms 103ms 19 1,072 0ms 21s768ms 67ms 1s50ms 1m10s 1m10s Oct 31 19 1,072 0ms 22s807ms 69ms 1s291ms 1m13s 1m13s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 06 8 0 6ms 50ms 50ms 50ms 09 32 0 5ms 89ms 89ms 89ms 13 32 0 4ms 68ms 68ms 68ms Oct 28 07 16 0 5ms 56ms 56ms 56ms 10 64 0 4ms 111ms 111ms 111ms 11 16 0 4ms 36ms 36ms 36ms 12 8 0 4ms 36ms 36ms 36ms 19 430 242 107ms 910ms 21s151ms 50s235ms Oct 29 08 16 0 6ms 96ms 96ms 96ms 10 8 0 4ms 35ms 35ms 35ms 11 3,050 0 0ms 86ms 369ms 732ms 14 40 0 5ms 94ms 94ms 94ms 19 430 242 105ms 700ms 20s912ms 49s277ms Oct 30 13 48 0 4ms 103ms 103ms 103ms 19 430 242 107ms 788ms 1s15ms 1m10s Oct 31 19 430 242 110ms 3ms 1s245ms 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 27 06 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms Oct 28 07 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms Oct 29 08 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 264 16 32 0 74ms 9ms 145ms 21s979ms 14 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms Oct 30 13 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms Oct 31 19 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 27 06 8 8 1.00 100.00% 09 32 32 1.00 100.00% 13 32 32 1.00 100.00% Oct 28 07 16 16 1.00 100.00% 10 64 64 1.00 100.00% 11 16 16 1.00 100.00% 12 8 8 1.00 100.00% 19 3 116 38.67 0.44% Oct 29 08 16 16 1.00 100.00% 10 8 8 1.00 100.00% 11 1,060 4,687 4.42 17.67% 14 40 40 1.00 100.00% 19 3 116 38.67 0.44% Oct 30 13 48 48 1.00 100.00% 19 3 116 38.67 0.44% Oct 31 19 3 116 38.67 0.44% Day Hour Count Average / Second Oct 27 06 1 0.00/s 09 4 0.00/s 13 4 0.00/s Oct 28 07 2 0.00/s 10 8 0.00/s 11 2 0.00/s 12 1 0.00/s 19 3 0.00/s Oct 29 08 2 0.00/s 10 1 0.00/s 11 12 0.00/s 14 5 0.00/s 19 3 0.00/s Oct 30 13 6 0.00/s 19 3 0.00/s Oct 31 19 3 0.00/s Day Hour Count Average Duration Average idle time Oct 27 06 1 472ms 421ms 09 4 370ms 329ms 13 4 283ms 248ms Oct 28 07 2 366ms 321ms 10 8 311ms 274ms 11 2 286ms 250ms 12 1 290ms 253ms 19 3 10m58s 10m34s Oct 29 08 2 498ms 450ms 10 1 278ms 242ms 11 12 4m56s 4m54s 14 5 285ms 238ms 19 3 11m39s 11m16s Oct 30 13 6 363ms 324ms 19 3 11m22s 10m58s Oct 31 19 3 10m51s 10m27s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2025-10-29 11:00:19 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 60 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 60 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2025-10-28 12:49:16 Date
Histogram of session times
Key values
- 34 0-500ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 60 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 60 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 60 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 4.19 MiB Temp Files size Peak
- 2025-10-29 11:13:43 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2025-10-29 11:13:43 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 27 06 0 0 0 09 0 0 0 13 0 0 0 Oct 28 07 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 19 0 0 0 Oct 29 08 0 0 0 10 0 0 0 11 2 8.38 MiB 4.19 MiB 14 0 0 0 19 0 0 0 Oct 30 13 0 0 0 19 0 0 0 Oct 31 19 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
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- public.gtp_log_ehcache (1) Main table analyzed (database autotest_feat_batch)
- 1 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 27 06 0 0 09 0 0 13 0 0 Oct 28 07 0 0 10 0 0 11 0 0 12 0 0 19 0 0 Oct 29 08 0 0 10 0 0 11 0 1 14 0 0 19 0 0 Oct 30 13 0 0 19 0 0 Oct 31 19 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
- 5,058 Total read queries
- 3,934 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 13,198 Requests
- 5m17s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 13,198 Requests
User Request type Count Duration a3dsupervisor Total 13,198 5m17s copy to 968 4m45s cte 8 11ms delete 32 21s991ms insert 264 292ms others 1,599 389ms select 5,058 7s40ms tcl 2,646 804ms update 16 1s36ms Duration by user
Key values
- 5m17s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 13,198 5m17s copy to 968 4m45s cte 8 11ms delete 32 21s991ms insert 264 292ms others 1,599 389ms select 5,058 7s40ms tcl 2,646 804ms update 16 1s36ms Queries by host
Key values
- 10.3.0.4 Main host
- 13,198 Requests
- 5m17s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 8,614 Requests
- 4m50s (pg_dump)
- Main time consuming application
Application Request type Count Duration PostgreSQL JDBC Driver Total 8,614 26s36ms cte 4 0ms delete 32 21s991ms insert 264 292ms others 15 153ms select 3,042 1s678ms tcl 2,634 804ms update 16 1s36ms [unknown] Total 296 1s490ms select 296 1s490ms pg_dump Total 4,288 4m50s copy to 968 4m45s cte 4 10ms others 1,584 235ms select 1,720 3s872ms tcl 12 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-28 19:26:46 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 11,868 0-1ms duration
Slowest individual queries
Rank Duration Query 1 22s807ms 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-31 19:31:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 21s940ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-29 11:01:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 21s768ms 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-30 19:34:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 21s151ms 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-28 19:22:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 20s912ms 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-29 19:30:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 12s910ms 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-31 19:31:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 12s592ms 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-28 19:23:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 12s554ms 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-29 19:31:02 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 12s375ms 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-30 19:34:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 8s714ms 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-28 19:23:17 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 8s677ms 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-30 19:34:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 8s613ms 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-29 19:31:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 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-10-31 19:31:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 8s379ms 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-28 19:23:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 8s364ms 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-30 19:34:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 8s358ms 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-29 19:31:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 8s346ms 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-31 19:31:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 6s492ms 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-28 19:23:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 6s160ms 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-30 19:34:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 6s46ms 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-31 19:31:42 - 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 1m26s 4 20s912ms 22s807ms 21s659ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 28 20 1 21s151ms 21s151ms Oct 29 20 1 20s912ms 20s912ms Oct 30 20 1 21s768ms 21s768ms Oct 31 20 1 22s807ms 22s807ms [ User: a3dsupervisor - Total duration: 1m26s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 4 ]
-
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-31 19:31:06 Duration: 22s807ms 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-30 19:34:09 Duration: 21s768ms 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-28 19:22:56 Duration: 21s151ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 50s432ms 4 12s375ms 12s910ms 12s608ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 28 20 1 12s592ms 12s592ms Oct 29 20 1 12s554ms 12s554ms Oct 30 20 1 12s375ms 12s375ms Oct 31 20 1 12s910ms 12s910ms [ User: a3dsupervisor - Total duration: 50s432ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s432ms - Times executed: 4 ]
-
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-31 19:31:19 Duration: 12s910ms 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-28 19:23:08 Duration: 12s592ms 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-29 19:31:02 Duration: 12s554ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 34s558ms 4 8s552ms 8s714ms 8s639ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 28 20 1 8s714ms 8s714ms Oct 29 20 1 8s613ms 8s613ms Oct 30 20 1 8s677ms 8s677ms Oct 31 20 1 8s552ms 8s552ms [ User: a3dsupervisor - Total duration: 34s558ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 34s558ms - Times executed: 4 ]
-
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-28 19:23:17 Duration: 8s714ms 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-30 19:34:30 Duration: 8s677ms 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-29 19:31:11 Duration: 8s613ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 33s449ms 4 8s346ms 8s379ms 8s362ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 28 20 1 8s379ms 8s379ms Oct 29 20 1 8s358ms 8s358ms Oct 30 20 1 8s364ms 8s364ms Oct 31 20 1 8s346ms 8s346ms [ User: a3dsupervisor - Total duration: 33s449ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 33s449ms - Times executed: 4 ]
-
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-28 19:23:25 Duration: 8s379ms 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-30 19:34:38 Duration: 8s364ms 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-29 19:31:19 Duration: 8s358ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 24s497ms 4 5s798ms 6s492ms 6s124ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 28 20 1 6s492ms 6s492ms Oct 29 20 1 5s798ms 5s798ms Oct 30 20 1 6s160ms 6s160ms Oct 31 20 1 6s46ms 6s46ms [ User: a3dsupervisor - Total duration: 24s497ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 24s497ms - Times executed: 4 ]
-
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-28 19:23:32 Duration: 6s492ms 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-30 19:34:45 Duration: 6s160ms 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-31 19:31:42 Duration: 6s46ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 21s940ms 2 0ms 21s940ms 10s970ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 29 12 2 21s940ms 10s970ms [ User: a3dsupervisor - Total duration: 21s940ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21s940ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-29 11:01:31 Duration: 21s940ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-29 11:14:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 19s458ms 4 4s768ms 4s961ms 4s864ms 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 #7
Day Hour Count Duration Avg duration Oct 28 20 1 4s789ms 4s789ms Oct 29 20 1 4s961ms 4s961ms Oct 30 20 1 4s768ms 4s768ms Oct 31 20 1 4s939ms 4s939ms [ User: a3dsupervisor - Total duration: 19s458ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 19s458ms - Times executed: 4 ]
-
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-29 19:31:30 Duration: 4s961ms 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-31 19:31:47 Duration: 4s939ms 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-28 19:23:37 Duration: 4s789ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 4s821ms 4 1s143ms 1s314ms 1s205ms 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 #8
Day Hour Count Duration Avg duration Oct 28 20 1 1s179ms 1s179ms Oct 29 20 1 1s143ms 1s143ms Oct 30 20 1 1s183ms 1s183ms Oct 31 20 1 1s314ms 1s314ms [ User: a3dsupervisor - Total duration: 4s821ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 4s821ms - Times executed: 4 ]
-
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-31 19:31:48 Duration: 1s314ms 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-30 19:34:51 Duration: 1s183ms 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-28 19:23:38 Duration: 1s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 4s576ms 4 1s108ms 1s165ms 1s144ms copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 28 20 1 1s157ms 1s157ms Oct 29 20 1 1s165ms 1s165ms Oct 30 20 1 1s108ms 1s108ms Oct 31 20 1 1s144ms 1s144ms [ User: a3dsupervisor - Total duration: 4s576ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 4s576ms - Times executed: 4 ]
-
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-29 19:31:33 Duration: 1s165ms 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-28 19:23:40 Duration: 1s157ms 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-31 19:31:49 Duration: 1s144ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 3s953ms 4 930ms 1s37ms 988ms 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 #10
Day Hour Count Duration Avg duration Oct 28 20 1 1s37ms 1s37ms Oct 29 20 1 1s16ms 1s16ms Oct 30 20 1 930ms 930ms Oct 31 20 1 969ms 969ms [ User: a3dsupervisor - Total duration: 3s953ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3s953ms - Times executed: 4 ]
-
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-28 19:23:41 Duration: 1s37ms 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-29 19:31:34 Duration: 1s16ms 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-31 19:31:50 Duration: 969ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 3s270ms 4 806ms 835ms 817ms 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 #11
Day Hour Count Duration Avg duration Oct 28 20 1 815ms 815ms Oct 29 20 1 835ms 835ms Oct 30 20 1 806ms 806ms Oct 31 20 1 813ms 813ms [ User: a3dsupervisor - Total duration: 3s270ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3s270ms - Times executed: 4 ]
-
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-29 19:31:35 Duration: 835ms 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-28 19:23:42 Duration: 815ms 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-31 19:31:51 Duration: 813ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 2s685ms 4 651ms 693ms 671ms 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 #12
Day Hour Count Duration Avg duration Oct 28 20 1 651ms 651ms Oct 29 20 1 681ms 681ms Oct 30 20 1 659ms 659ms Oct 31 20 1 693ms 693ms [ User: a3dsupervisor - Total duration: 2s685ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s685ms - Times executed: 4 ]
-
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-31 19:31:52 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-10-29 19:31:35 Duration: 681ms 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-30 19:34:55 Duration: 659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 1s914ms 4 453ms 514ms 478ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 28 20 1 457ms 457ms Oct 29 20 1 488ms 488ms Oct 30 20 1 453ms 453ms Oct 31 20 1 514ms 514ms [ User: a3dsupervisor - Total duration: 1s914ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s914ms - Times executed: 4 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-31 19:31:53 Duration: 514ms 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-29 19:31:36 Duration: 488ms 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-28 19:23:43 Duration: 457ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 1s666ms 4 336ms 473ms 416ms 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 #14
Day Hour Count Duration Avg duration Oct 28 20 1 448ms 448ms Oct 29 20 1 407ms 407ms Oct 30 20 1 336ms 336ms Oct 31 20 1 473ms 473ms [ User: a3dsupervisor - Total duration: 1s666ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s666ms - Times executed: 4 ]
-
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-31 19:31:55 Duration: 473ms 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-28 19:23:46 Duration: 448ms 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-29 19:31:38 Duration: 407ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 1s543ms 4 365ms 416ms 385ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 28 20 1 416ms 416ms Oct 29 20 1 365ms 365ms Oct 30 20 1 379ms 379ms Oct 31 20 1 382ms 382ms [ User: a3dsupervisor - Total duration: 1s543ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s543ms - Times executed: 4 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-28 19:23:44 Duration: 416ms 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-31 19:31:53 Duration: 382ms 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-30 19:34:56 Duration: 379ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 1s415ms 4 275ms 401ms 353ms 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 Oct 28 20 1 354ms 354ms Oct 29 20 1 275ms 275ms Oct 30 20 1 383ms 383ms Oct 31 20 1 401ms 401ms [ User: a3dsupervisor - Total duration: 1s415ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s415ms - Times executed: 4 ]
-
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-31 19:31:53 Duration: 401ms 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-30 19:34:56 Duration: 383ms 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-28 19:23:44 Duration: 354ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 1s127ms 4 277ms 289ms 281ms 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 #17
Day Hour Count Duration Avg duration Oct 28 20 1 279ms 279ms Oct 29 20 1 281ms 281ms Oct 30 20 1 277ms 277ms Oct 31 20 1 289ms 289ms [ User: a3dsupervisor - Total duration: 1s127ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s127ms - Times executed: 4 ]
-
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-31 19:31:54 Duration: 289ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-29 19:31:37 Duration: 281ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-28 19:23:44 Duration: 279ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 854ms 4 188ms 253ms 213ms 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 #18
Day Hour Count Duration Avg duration Oct 28 20 1 199ms 199ms Oct 29 20 1 253ms 253ms Oct 30 20 1 188ms 188ms Oct 31 20 1 213ms 213ms [ User: a3dsupervisor - Total duration: 854ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 854ms - Times executed: 4 ]
-
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-29 19:31:38 Duration: 253ms 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-31 19:31:54 Duration: 213ms 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-28 19:23:45 Duration: 199ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 774ms 4 180ms 206ms 193ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 28 20 1 180ms 180ms Oct 29 20 1 206ms 206ms Oct 30 20 1 193ms 193ms Oct 31 20 1 194ms 194ms [ User: a3dsupervisor - Total duration: 774ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 774ms - Times executed: 4 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-29 19:31:37 Duration: 206ms 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-31 19:31:54 Duration: 194ms 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-30 19:34:57 Duration: 193ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 767ms 2 70ms 696ms 383ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 29 12 2 767ms 383ms [ User: a3dsupervisor - Total duration: 767ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 767ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-10-29 11:02:09 Duration: 696ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-10-29 11:15:00 Duration: 70ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,303 729ms 0ms 425ms 0ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 29 12 1,303 729ms 0ms [ User: a3dsupervisor - Total duration: 729ms - Times executed: 1303 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 729ms - Times executed: 1303 ]
-
COMMIT;
Date: 2025-10-29 11:01:31 Duration: 425ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-29 11:01:28 Duration: 128ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-29 11:01:28 Duration: 9ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1,066 63ms 0ms 0ms 0ms begin read only;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 29 12 1,066 63ms 0ms [ User: a3dsupervisor - Total duration: 63ms - Times executed: 1066 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 63ms - Times executed: 1066 ]
-
BEGIN READ ONLY;
Date: 2025-10-29 11:02:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-29 11:13:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
BEGIN READ ONLY;
Date: 2025-10-29 11:13:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
3 656 124ms 0ms 9ms 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 #3
Day Hour Count Duration Avg duration Oct 28 20 164 33ms 0ms Oct 29 20 164 23ms 0ms Oct 30 20 164 35ms 0ms Oct 31 20 164 32ms 0ms [ User: a3dsupervisor - Total duration: 124ms - Times executed: 656 ]
[ Application: pg_dump - Total duration: 124ms - Times executed: 656 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;
Date: 2025-10-28 19:17:25 Duration: 9ms 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-31 19:25:24 Duration: 9ms 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-30 19:28:25 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 436 78ms 0ms 1ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 28 20 109 20ms 0ms Oct 29 20 109 20ms 0ms Oct 30 20 109 19ms 0ms Oct 31 20 109 19ms 0ms [ User: a3dsupervisor - Total duration: 78ms - Times executed: 436 ]
[ Application: pg_dump - Total duration: 78ms - Times executed: 436 ]
-
EXECUTE dumpFunc ('2818849');
Date: 2025-10-28 19:17:25 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818912');
Date: 2025-10-31 19:25:24 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818849');
Date: 2025-10-31 19:25:24 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 404 56ms 0ms 1ms 0ms select gatp1_0.att_template_num_id, gatp1_0.att_activated_unit, gatp1_0.att_template_a3d_num_id, gatp1_0.att_template_bim_activated, gatp1_0.att_template_creator, gatp1_0.att_template_date_format, gatp1_0.att_template_dcre, gatp1_0.att_template_default_value, gatp1_0.att_template_dmaj, gatp1_0.att_template_domain_code, gatp1_0.att_template_enum_num_id, gatp1_0.att_template_enum_parent, gatp1_0.att_template_line_wrap, gatp1_0.att_template_max, gatp1_0.att_template_min, gatp1_0.att_template_modifiable, gatp1_0.att_template_modifier, gatp1_0.att_template_name_fr, gatp1_0.att_template_obligatoire, gatp1_0.att_template_scale, gatp1_0.att_template_size, gatp1_0.att_template_tooltip, gatp1_0.att_template_unique_value, gatp1_0.att_unit_num_id, gatp1_0.unique_code, gatp1_0.workspace_num_id from gtp_att_template gatp1_0 where gatp1_0.att_template_a3d_num_id = and gatp1_0.workspace_num_id =;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 29 12 404 56ms 0ms [ User: a3dsupervisor - Total duration: 56ms - Times executed: 404 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 56ms - Times executed: 404 ]
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = and gatp1_0.WORKSPACE_NUM_ID =;
Date: 2025-10-29 11:00:37 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = and gatp1_0.WORKSPACE_NUM_ID =;
Date: 2025-10-29 11:13:59 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = and gatp1_0.WORKSPACE_NUM_ID =;
Date: 2025-10-29 11:00:37 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 346 26ms 0ms 2ms 0ms select gotrcap1_0.att_template_category_num_id, gotrcap1_0.obj_template_num_id, gotrcap1_0.obj_template_rel_cat_att_order from gtp_obj_template_rel_cat_att gotrcap1_0 where gotrcap1_0.obj_template_num_id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 29 12 346 26ms 0ms [ User: a3dsupervisor - Total duration: 26ms - Times executed: 346 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26ms - Times executed: 346 ]
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ();
Date: 2025-10-29 11:01:03 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ();
Date: 2025-10-29 11:01:18 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ();
Date: 2025-10-29 11:01:19 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 263 11ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 28 20 3 0ms 0ms Oct 29 12 251 10ms 0ms 20 3 0ms 0ms Oct 30 20 3 0ms 0ms Oct 31 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 11ms - Times executed: 263 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10ms - Times executed: 251 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 12 ]
-
BEGIN;
Date: 2025-10-29 11:14:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-29 11:17:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-29 11:01:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
8 250 38ms 0ms 12ms 0ms select nextval(?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 29 12 250 38ms 0ms [ User: a3dsupervisor - Total duration: 38ms - Times executed: 250 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38ms - Times executed: 250 ]
-
select nextval('GTP_LOG_EHCACHE_NUM_ID_SEQ');
Date: 2025-10-29 11:04:59 Duration: 12ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('S_LOG_SESSION_ID');
Date: 2025-10-29 11:01:27 Duration: 8ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select nextval('GTP_LOG_CONNECTION_NUM_ID_SEQ');
Date: 2025-10-29 11:05:06 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 242 90ms 0ms 1ms 0ms insert into gtp_log_ehcache (element_count_average, element_count_max, element_count_min, hit_count, log_date, max_memory, miss_count, region_name, server_id, used_memory_average, used_memory_max, used_memory_min, log_ehcache_num_id) values (,,,,,,,,,,,,);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 29 12 242 90ms 0ms [ User: a3dsupervisor - Total duration: 90ms - Times executed: 242 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 90ms - Times executed: 242 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-10-29 11:20:02 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-10-29 11:20:01 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values (,,,,,,,,,,,,);
Date: 2025-10-29 11:20:05 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 218 6ms 0ms 0ms 0ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 29 12 218 6ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 218 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6ms - Times executed: 218 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-10-29 11:23:28 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-10-29 11:23:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-10-29 11:17:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 161 5ms 0ms 0ms 0ms select pp1_0.property_name, pp1_0.property_comment, pp1_0.property_creator, pp1_0.property_dcre, pp1_0.property_dmaj, pp1_0.property_domain, pp1_0.property_modifier, pp1_0.property_value from property pp1_0 where pp1_0.property_name =;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 29 12 161 5ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 161 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5ms - Times executed: 161 ]
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME =;
Date: 2025-10-29 11:00:35 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME =;
Date: 2025-10-29 11:01:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME =;
Date: 2025-10-29 11:01:25 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 142 19ms 0ms 4ms 0ms select brp1_0.right_num_id, brp1_0.accept_future_elements, brp1_0.context_num_id, brp1_0.element_type, brp1_0.right_creator, brp1_0.right_dcre, brp1_0.right_dmaj, brp1_0.right_modifier, brp1_0.target_num_id, brp1_0.target_type from bdc_right brp1_0 where brp1_0.target_num_id = and brp1_0.target_type = and brp1_0.element_type =;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 29 12 142 19ms 0ms [ User: a3dsupervisor - Total duration: 19ms - Times executed: 142 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 19ms - Times executed: 142 ]
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = and brp1_0.TARGET_TYPE = and brp1_0.ELEMENT_TYPE =;
Date: 2025-10-29 11:01:27 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = and brp1_0.TARGET_TYPE = and brp1_0.ELEMENT_TYPE =;
Date: 2025-10-29 11:03:14 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = and brp1_0.TARGET_TYPE = and brp1_0.ELEMENT_TYPE =;
Date: 2025-10-29 11:03:17 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 134 17ms 0ms 1ms 0ms select gotp1_0.obj_template_num_id, gotp1_0.component_num_id, gotp1_0.obj_template_b_valid, gotp1_0.obj_template_a3d_num_id, gotp1_0.obj_template_compo_version, gotp1_0.obj_template_creator, gotp1_0.obj_template_dcre, gotp1_0.obj_template_dmaj, gotp1_0.obj_template_icon_num_id, gotp1_0.obj_templ_instance_icon_num_id, gotp1_0.obj_template_modifier, gotp1_0.obj_template_name_fr, gotp1_0.obj_template_version, gotp1_0.unique_code, gotp1_0.workspace_num_id from gtp_obj_template gotp1_0 where gotp1_0.obj_template_a3d_num_id = and gotp1_0.workspace_num_id =;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 29 12 134 17ms 0ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 134 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17ms - Times executed: 134 ]
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = and gotp1_0.WORKSPACE_NUM_ID =;
Date: 2025-10-29 11:00:38 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = and gotp1_0.WORKSPACE_NUM_ID =;
Date: 2025-10-29 11:00:37 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = and gotp1_0.WORKSPACE_NUM_ID =;
Date: 2025-10-29 11:00:37 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 132 5ms 0ms 0ms 0ms select gbtp1_0.task_num_id, gbtp1_0.canceling_user_num_id, gbtp1_0.export_file_name, gbtp1_0.server_id, gbtp1_0.source_file_name, gbtp1_0.source_obj_num_id, gbtp1_0.task_active_status, gbtp1_0.task_create_date, gbtp1_0.task_current_progress, gbtp1_0.task_current_step, gbtp1_0.task_end_date, gbtp1_0.task_error_message, gbtp1_0.task_last_update, gbtp1_0.task_log, gbtp1_0.task_max_progress, gbtp1_0.task_max_step, gbtp1_0.task_origin, gbtp1_0.task_parameters, gbtp1_0.task_report, gbtp1_0.task_service_name, gbtp1_0.task_start_date, gbtp1_0.task_state, gbtp1_0.task_status, gbtp1_0.task_sub_type, gbtp1_0.user_num_id from gtp_background_task gbtp1_0 where gbtp1_0.task_status = and gbtp1_0.canceling_user_num_id is not null order by gbtp1_0.task_num_id desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 29 12 132 5ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 132 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5ms - Times executed: 132 ]
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-29 11:06:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-29 11:14:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2025-10-29 11:22:55 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 110 4ms 0ms 0ms 0ms select fp1_0.functionality_num_id, fp1_0.functionality_auth_type, fp1_0.is_a3d, fp1_0.functionality_link, fp1_0.functionality_name, fp1_0.functionality_token, fp1_0.unique_code from functionality fp1_0 where fp1_0.functionality_num_id =;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 29 12 110 4ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 110 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 110 ]
-
select fp1_0.FUNCTIONALITY_NUM_ID, fp1_0.FUNCTIONALITY_AUTH_TYPE, fp1_0.IS_A3D, fp1_0.FUNCTIONALITY_LINK, fp1_0.FUNCTIONALITY_NAME, fp1_0.FUNCTIONALITY_TOKEN, fp1_0.UNIQUE_CODE from FUNCTIONALITY fp1_0 where fp1_0.FUNCTIONALITY_NUM_ID =;
Date: 2025-10-29 11:03:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select fp1_0.FUNCTIONALITY_NUM_ID, fp1_0.FUNCTIONALITY_AUTH_TYPE, fp1_0.IS_A3D, fp1_0.FUNCTIONALITY_LINK, fp1_0.FUNCTIONALITY_NAME, fp1_0.FUNCTIONALITY_TOKEN, fp1_0.UNIQUE_CODE from FUNCTIONALITY fp1_0 where fp1_0.FUNCTIONALITY_NUM_ID =;
Date: 2025-10-29 11:03:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select fp1_0.FUNCTIONALITY_NUM_ID, fp1_0.FUNCTIONALITY_AUTH_TYPE, fp1_0.IS_A3D, fp1_0.FUNCTIONALITY_LINK, fp1_0.FUNCTIONALITY_NAME, fp1_0.FUNCTIONALITY_TOKEN, fp1_0.UNIQUE_CODE from FUNCTIONALITY fp1_0 where fp1_0.FUNCTIONALITY_NUM_ID =;
Date: 2025-10-29 11:03:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 100 224ms 0ms 108ms 2ms select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 29 12 100 224ms 2ms [ User: a3dsupervisor - Total duration: 224ms - Times executed: 100 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 224ms - Times executed: 100 ]
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49801;
Date: 2025-10-29 11:00:48 Duration: 108ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49801;
Date: 2025-10-29 11:13:41 Duration: 62ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select obj_num_id from ( select gob.obj_num_id from gtp_obj gob order by gob.obj_dmaj desc) LIMIT 49801;
Date: 2025-10-29 11:13:42 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 76 6ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 28 20 19 1ms 0ms Oct 29 20 19 1ms 0ms Oct 30 20 19 1ms 0ms Oct 31 20 19 1ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 76 ]
[ Application: pg_dump - Total duration: 6ms - Times executed: 76 ]
-
SELECT pg_catalog.format_type('2801243'::pg_catalog.oid, NULL);
Date: 2025-10-29 19:24:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2801266'::pg_catalog.oid, NULL);
Date: 2025-10-29 19:24:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2818844'::pg_catalog.oid, NULL);
Date: 2025-10-29 19:24:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 68 136ms 0ms 18ms 2ms select bcep1_0.element_num_id, bcep1_0.right_num_id, bcep1_0.right_mode, bcep1_0.update_date, bcep1_0.update_user_num_id from bdc_concerned_element bcep1_0 where bcep1_0.right_num_id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 29 12 68 136ms 2ms [ User: a3dsupervisor - Total duration: 136ms - Times executed: 68 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 136ms - Times executed: 68 ]
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in ();
Date: 2025-10-29 11:03:09 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in ();
Date: 2025-10-29 11:03:09 Duration: 15ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select bcep1_0.ELEMENT_NUM_ID, bcep1_0.RIGHT_NUM_ID, bcep1_0.RIGHT_MODE, bcep1_0.UPDATE_DATE, bcep1_0.UPDATE_USER_NUM_ID from BDC_CONCERNED_ELEMENT bcep1_0 where bcep1_0.RIGHT_NUM_ID in ();
Date: 2025-10-29 11:03:18 Duration: 12ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 59 1ms 0ms 0ms 0ms select gocp1_0.obj_num_id, gocp1_0.creation_date, gocp1_0.creator, gocp1_0.latitude, gocp1_0.longitude, gocp1_0.modification_date, gocp1_0.modifier from gtp_obj_coordinates gocp1_0 where gocp1_0.obj_num_id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 29 12 59 1ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 59 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1ms - Times executed: 59 ]
-
select gocp1_0.OBJ_NUM_ID, gocp1_0.CREATION_DATE, gocp1_0.CREATOR, gocp1_0.LATITUDE, gocp1_0.LONGITUDE, gocp1_0.MODIFICATION_DATE, gocp1_0.MODIFIER from GTP_OBJ_COORDINATES gocp1_0 where gocp1_0.OBJ_NUM_ID in (,,);
Date: 2025-10-29 11:03:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gocp1_0.OBJ_NUM_ID, gocp1_0.CREATION_DATE, gocp1_0.CREATOR, gocp1_0.LATITUDE, gocp1_0.LONGITUDE, gocp1_0.MODIFICATION_DATE, gocp1_0.MODIFIER from GTP_OBJ_COORDINATES gocp1_0 where gocp1_0.OBJ_NUM_ID in (,,);
Date: 2025-10-29 11:15:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gocp1_0.OBJ_NUM_ID, gocp1_0.CREATION_DATE, gocp1_0.CREATOR, gocp1_0.LATITUDE, gocp1_0.LONGITUDE, gocp1_0.MODIFICATION_DATE, gocp1_0.MODIFIER from GTP_OBJ_COORDINATES gocp1_0 where gocp1_0.OBJ_NUM_ID in (,,);
Date: 2025-10-29 11:03:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 56 5ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 28 20 14 1ms 0ms Oct 29 20 14 1ms 0ms Oct 30 20 14 1ms 0ms Oct 31 20 14 1ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 56 ]
[ Application: pg_dump - Total duration: 5ms - Times executed: 56 ]
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819023'::pg_catalog.oid);
Date: 2025-10-31 19:25:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819025'::pg_catalog.oid);
Date: 2025-10-28 19:17:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819023'::pg_catalog.oid);
Date: 2025-10-28 19:17:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 20s912ms 22s807ms 21s659ms 4 1m26s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 28 20 1 21s151ms 21s151ms Oct 29 20 1 20s912ms 20s912ms Oct 30 20 1 21s768ms 21s768ms Oct 31 20 1 22s807ms 22s807ms [ User: a3dsupervisor - Total duration: 1m26s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 4 ]
-
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-31 19:31:06 Duration: 22s807ms 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-30 19:34:09 Duration: 21s768ms 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-28 19:22:56 Duration: 21s151ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 12s375ms 12s910ms 12s608ms 4 50s432ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 28 20 1 12s592ms 12s592ms Oct 29 20 1 12s554ms 12s554ms Oct 30 20 1 12s375ms 12s375ms Oct 31 20 1 12s910ms 12s910ms [ User: a3dsupervisor - Total duration: 50s432ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 50s432ms - Times executed: 4 ]
-
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-31 19:31:19 Duration: 12s910ms 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-28 19:23:08 Duration: 12s592ms 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-29 19:31:02 Duration: 12s554ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 0ms 21s940ms 10s970ms 2 21s940ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 29 12 2 21s940ms 10s970ms [ User: a3dsupervisor - Total duration: 21s940ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 21s940ms - Times executed: 2 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-29 11:01:31 Duration: 21s940ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-29 11:14:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 8s552ms 8s714ms 8s639ms 4 34s558ms 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 #4
Day Hour Count Duration Avg duration Oct 28 20 1 8s714ms 8s714ms Oct 29 20 1 8s613ms 8s613ms Oct 30 20 1 8s677ms 8s677ms Oct 31 20 1 8s552ms 8s552ms [ User: a3dsupervisor - Total duration: 34s558ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 34s558ms - Times executed: 4 ]
-
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-28 19:23:17 Duration: 8s714ms 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-30 19:34:30 Duration: 8s677ms 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-29 19:31:11 Duration: 8s613ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 8s346ms 8s379ms 8s362ms 4 33s449ms 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 #5
Day Hour Count Duration Avg duration Oct 28 20 1 8s379ms 8s379ms Oct 29 20 1 8s358ms 8s358ms Oct 30 20 1 8s364ms 8s364ms Oct 31 20 1 8s346ms 8s346ms [ User: a3dsupervisor - Total duration: 33s449ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 33s449ms - Times executed: 4 ]
-
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-28 19:23:25 Duration: 8s379ms 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-30 19:34:38 Duration: 8s364ms 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-29 19:31:19 Duration: 8s358ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 5s798ms 6s492ms 6s124ms 4 24s497ms 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 #6
Day Hour Count Duration Avg duration Oct 28 20 1 6s492ms 6s492ms Oct 29 20 1 5s798ms 5s798ms Oct 30 20 1 6s160ms 6s160ms Oct 31 20 1 6s46ms 6s46ms [ User: a3dsupervisor - Total duration: 24s497ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 24s497ms - Times executed: 4 ]
-
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-28 19:23:32 Duration: 6s492ms 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-30 19:34:45 Duration: 6s160ms 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-31 19:31:42 Duration: 6s46ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 4s768ms 4s961ms 4s864ms 4 19s458ms 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 #7
Day Hour Count Duration Avg duration Oct 28 20 1 4s789ms 4s789ms Oct 29 20 1 4s961ms 4s961ms Oct 30 20 1 4s768ms 4s768ms Oct 31 20 1 4s939ms 4s939ms [ User: a3dsupervisor - Total duration: 19s458ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 19s458ms - Times executed: 4 ]
-
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-29 19:31:30 Duration: 4s961ms 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-31 19:31:47 Duration: 4s939ms 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-28 19:23:37 Duration: 4s789ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1s143ms 1s314ms 1s205ms 4 4s821ms 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 #8
Day Hour Count Duration Avg duration Oct 28 20 1 1s179ms 1s179ms Oct 29 20 1 1s143ms 1s143ms Oct 30 20 1 1s183ms 1s183ms Oct 31 20 1 1s314ms 1s314ms [ User: a3dsupervisor - Total duration: 4s821ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 4s821ms - Times executed: 4 ]
-
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-31 19:31:48 Duration: 1s314ms 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-30 19:34:51 Duration: 1s183ms 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-28 19:23:38 Duration: 1s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1s108ms 1s165ms 1s144ms 4 4s576ms copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 28 20 1 1s157ms 1s157ms Oct 29 20 1 1s165ms 1s165ms Oct 30 20 1 1s108ms 1s108ms Oct 31 20 1 1s144ms 1s144ms [ User: a3dsupervisor - Total duration: 4s576ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 4s576ms - Times executed: 4 ]
-
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-29 19:31:33 Duration: 1s165ms 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-28 19:23:40 Duration: 1s157ms 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-31 19:31:49 Duration: 1s144ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 930ms 1s37ms 988ms 4 3s953ms 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 #10
Day Hour Count Duration Avg duration Oct 28 20 1 1s37ms 1s37ms Oct 29 20 1 1s16ms 1s16ms Oct 30 20 1 930ms 930ms Oct 31 20 1 969ms 969ms [ User: a3dsupervisor - Total duration: 3s953ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3s953ms - Times executed: 4 ]
-
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-28 19:23:41 Duration: 1s37ms 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-29 19:31:34 Duration: 1s16ms 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-31 19:31:50 Duration: 969ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 806ms 835ms 817ms 4 3s270ms 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 #11
Day Hour Count Duration Avg duration Oct 28 20 1 815ms 815ms Oct 29 20 1 835ms 835ms Oct 30 20 1 806ms 806ms Oct 31 20 1 813ms 813ms [ User: a3dsupervisor - Total duration: 3s270ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3s270ms - Times executed: 4 ]
-
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-29 19:31:35 Duration: 835ms 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-28 19:23:42 Duration: 815ms 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-31 19:31:51 Duration: 813ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 651ms 693ms 671ms 4 2s685ms 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 #12
Day Hour Count Duration Avg duration Oct 28 20 1 651ms 651ms Oct 29 20 1 681ms 681ms Oct 30 20 1 659ms 659ms Oct 31 20 1 693ms 693ms [ User: a3dsupervisor - Total duration: 2s685ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s685ms - Times executed: 4 ]
-
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-31 19:31:52 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-10-29 19:31:35 Duration: 681ms 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-30 19:34:55 Duration: 659ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 453ms 514ms 478ms 4 1s914ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 28 20 1 457ms 457ms Oct 29 20 1 488ms 488ms Oct 30 20 1 453ms 453ms Oct 31 20 1 514ms 514ms [ User: a3dsupervisor - Total duration: 1s914ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s914ms - Times executed: 4 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-31 19:31:53 Duration: 514ms 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-29 19:31:36 Duration: 488ms 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-28 19:23:43 Duration: 457ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 336ms 473ms 416ms 4 1s666ms 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 #14
Day Hour Count Duration Avg duration Oct 28 20 1 448ms 448ms Oct 29 20 1 407ms 407ms Oct 30 20 1 336ms 336ms Oct 31 20 1 473ms 473ms [ User: a3dsupervisor - Total duration: 1s666ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s666ms - Times executed: 4 ]
-
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-31 19:31:55 Duration: 473ms 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-28 19:23:46 Duration: 448ms 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-29 19:31:38 Duration: 407ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 365ms 416ms 385ms 4 1s543ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 28 20 1 416ms 416ms Oct 29 20 1 365ms 365ms Oct 30 20 1 379ms 379ms Oct 31 20 1 382ms 382ms [ User: a3dsupervisor - Total duration: 1s543ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s543ms - Times executed: 4 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-28 19:23:44 Duration: 416ms 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-31 19:31:53 Duration: 382ms 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-30 19:34:56 Duration: 379ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 70ms 696ms 383ms 2 767ms update ged_document gd set del_action_num_id = ?, document_content_to_remove = ? where gd.project_num_id = ? and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga on gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = to_char(gd.document_num_id) where gat.att_template_domain_code = ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 29 12 2 767ms 383ms [ User: a3dsupervisor - Total duration: 767ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 767ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-10-29 11:02:09 Duration: 696ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-10-29 11:15:00 Duration: 70ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 275ms 401ms 353ms 4 1s415ms 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 #17
Day Hour Count Duration Avg duration Oct 28 20 1 354ms 354ms Oct 29 20 1 275ms 275ms Oct 30 20 1 383ms 383ms Oct 31 20 1 401ms 401ms [ User: a3dsupervisor - Total duration: 1s415ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s415ms - Times executed: 4 ]
-
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-31 19:31:53 Duration: 401ms 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-30 19:34:56 Duration: 383ms 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-28 19:23:44 Duration: 354ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 277ms 289ms 281ms 4 1s127ms 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 #18
Day Hour Count Duration Avg duration Oct 28 20 1 279ms 279ms Oct 29 20 1 281ms 281ms Oct 30 20 1 277ms 277ms Oct 31 20 1 289ms 289ms [ User: a3dsupervisor - Total duration: 1s127ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s127ms - Times executed: 4 ]
-
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-31 19:31:54 Duration: 289ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-29 19:31:37 Duration: 281ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;
Date: 2025-10-28 19:23:44 Duration: 279ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 188ms 253ms 213ms 4 854ms copy public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 28 20 1 199ms 199ms Oct 29 20 1 253ms 253ms Oct 30 20 1 188ms 188ms Oct 31 20 1 213ms 213ms [ User: a3dsupervisor - Total duration: 854ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 854ms - Times executed: 4 ]
-
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-29 19:31:38 Duration: 253ms 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-31 19:31:54 Duration: 213ms 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-28 19:23:45 Duration: 199ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 180ms 206ms 193ms 4 774ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 28 20 1 180ms 180ms Oct 29 20 1 206ms 206ms Oct 30 20 1 193ms 193ms Oct 31 20 1 194ms 194ms [ User: a3dsupervisor - Total duration: 774ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 774ms - Times executed: 4 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-29 19:31:37 Duration: 206ms 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-31 19:31:54 Duration: 194ms 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-30 19:34:57 Duration: 193ms 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 360ms 37 1ms 107ms 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 prepare #1
Day Hour Count Duration Avg duration Oct 31 07 1 26ms 26ms 10 4 30ms 7ms 14 4 6ms 1ms Oct 31 08 2 27ms 13ms 11 8 36ms 4ms 12 2 3ms 1ms 13 1 1ms 1ms Oct 31 09 2 101ms 50ms 11 1 1ms 1ms 12 1 1ms 1ms 15 5 7ms 1ms Oct 31 14 6 115ms 19ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 37 ]
-
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-30 13:45:23 Duration: 107ms 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-29 08:33:20 Duration: 99ms 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-27 06:44:30 Duration: 26ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 173ms 37 0ms 57ms 4ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 06 1 9ms 9ms 09 4 13ms 3ms 13 4 1ms 0ms 07 2 11ms 5ms 10 8 13ms 1ms 11 2 1ms 0ms 12 1 0ms 0ms 08 2 58ms 29ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms 13 6 59ms 9ms [ User: a3dsupervisor - Total duration: 266ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 266ms - Times executed: 37 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-29 08:33:20 Duration: 57ms 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-30 13:45:23 Duration: 57ms 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-27 09:07:40 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 122ms 37 0ms 29ms 3ms 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 06 1 9ms 9ms 09 4 12ms 3ms 13 4 3ms 0ms 07 2 11ms 5ms 10 8 17ms 2ms 11 2 2ms 1ms 12 1 1ms 1ms 08 2 30ms 15ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 3ms 0ms 13 6 28ms 4ms [ User: a3dsupervisor - Total duration: 423ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 423ms - Times executed: 37 ]
-
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-29 08:33:20 Duration: 29ms 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-30 13:45:23 Duration: 24ms 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-28 10:41:03 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 77ms 37 0ms 24ms 2ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 06 1 5ms 5ms 09 4 8ms 2ms 13 4 0ms 0ms 07 2 5ms 2ms 10 8 6ms 0ms 11 2 0ms 0ms 12 1 0ms 0ms 08 2 23ms 11ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 1ms 0ms 13 6 25ms 4ms [ User: a3dsupervisor - Total duration: 230ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 230ms - Times executed: 37 ]
-
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-30 13:45:23 Duration: 24ms 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-29 08:33:20 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-27 09:07:41 Duration: 7ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 40ms 37 0ms 4ms 1ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 06 1 1ms 1ms 09 4 6ms 1ms 13 4 2ms 0ms 07 2 5ms 2ms 10 8 7ms 0ms 11 2 1ms 0ms 12 1 0ms 0ms 08 2 5ms 2ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms 13 6 6ms 1ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 37 ]
-
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-28 07:40:43 Duration: 4ms 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-29 08:33:20 Duration: 4ms 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-27 09:07:41 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 36ms 37 0ms 11ms 0ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 06 1 0ms 0ms 09 4 11ms 2ms 13 4 0ms 0ms 07 2 4ms 2ms 10 8 4ms 0ms 11 2 0ms 0ms 12 1 0ms 0ms 08 2 5ms 2ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 1ms 0ms 13 6 7ms 1ms [ User: a3dsupervisor - Total duration: 521ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 521ms - Times executed: 37 ]
-
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-27 09:07:41 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-10-30 13:45:24 Duration: 5ms 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-29 08:33:20 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 35ms 37 0ms 6ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 06 1 1ms 1ms 09 4 5ms 1ms 13 4 1ms 0ms 07 2 3ms 1ms 10 8 6ms 0ms 11 2 0ms 0ms 12 1 0ms 0ms 08 2 6ms 3ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms 13 6 7ms 1ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 8ms - Times executed: 37 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-29 08:33:20 Duration: 6ms 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-30 13:45:23 Duration: 6ms 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-27 09:07:41 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 16ms 2 0ms 15ms 8ms select * from information_schema.sequences;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 11 2 16ms 8ms [ User: a3dsupervisor - Total duration: 39ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39ms - Times executed: 2 ]
-
select * from information_schema.sequences;
Date: 2025-10-29 11:00:23 Duration: 15ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select * from information_schema.sequences;
Date: 2025-10-29 11:13:18 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
9 10ms 2 1ms 9ms 5ms select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 11 2 10ms 5ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1ms - Times executed: 2 ]
-
select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);
Date: 2025-10-29 11:00:20 Duration: 9ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);
Date: 2025-10-29 11:13:16 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
10 8ms 22 0ms 3ms 0ms select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 11 22 8ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 22 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1ms - Times executed: 22 ]
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-10-29 11:00:35 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-10-29 11:13:28 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-10-29 11:00:35 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
11 6ms 4 0ms 5ms 1ms select gwp1_0.WORKSPACE_NUM_ID, gwp1_0.USER_NUM_ID, gwp1_0.WORKSPACE_B_VALID, gwp1_0.WORKSPACE_DCRE, gwp1_0.WORKSPACE_NAME_FR, gwp1_0.WORKSPACE_SHORTNAME from GTP_WORKSPACE gwp1_0;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 11 4 6ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 4 ]
-
select gwp1_0.WORKSPACE_NUM_ID, gwp1_0.USER_NUM_ID, gwp1_0.WORKSPACE_B_VALID, gwp1_0.WORKSPACE_DCRE, gwp1_0.WORKSPACE_NAME_FR, gwp1_0.WORKSPACE_SHORTNAME from GTP_WORKSPACE gwp1_0;
Date: 2025-10-29 11:00:36 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gwp1_0.WORKSPACE_NUM_ID, gwp1_0.USER_NUM_ID, gwp1_0.WORKSPACE_B_VALID, gwp1_0.WORKSPACE_DCRE, gwp1_0.WORKSPACE_NAME_FR, gwp1_0.WORKSPACE_SHORTNAME from GTP_WORKSPACE gwp1_0;
Date: 2025-10-29 11:00:36 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gwp1_0.WORKSPACE_NUM_ID, gwp1_0.USER_NUM_ID, gwp1_0.WORKSPACE_B_VALID, gwp1_0.WORKSPACE_DCRE, gwp1_0.WORKSPACE_NAME_FR, gwp1_0.WORKSPACE_SHORTNAME from GTP_WORKSPACE gwp1_0;
Date: 2025-10-29 11:13:29 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
12 6ms 8 0ms 4ms 0ms select lup1_0.USER_NUM_ID, lup1_0.COMPANY_NUM_ID, lup1_0.ANONYMIZED, lup1_0.USER_CIVILITY, lup1_0.CREATION_DATE, lup1_0.USER_NUM_ID_CREATOR, lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME || ' (' || lup1_0.USER_LOGIN || ')', lup1_0.LAST_CONNECTION_DATE, lup1_0.USER_NAME, lup1_0.MODIFICATION_DATE, lup1_0.MODIFIER_NUM_ID, lup1_0.POLICY_VERSION, lup1_0.OBJ_NUM_ID, lup1_0.USER_ADDRESS, lup1_0.USER_AUTHENTICATION, lup1_0.USER_CITY, lup1_0.USER_COUNTRY, lup1_0.USER_DELETED, lup1_0.USER_FAX, lup1_0.USER_GUID, lup1_0.USER_LOGIN, lup1_0.USER_MAIL, lup1_0.USER_CELULAR, lup1_0.USER_PASSWORD, lup1_0.USER_PHONE, lup1_0.USER_POSTAL_CODE, lup1_0.USER_BOK from A3D_USER lup1_0 where lower(lup1_0.USER_LOGIN) = $1;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 11 8 6ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 8 ]
-
select lup1_0.USER_NUM_ID, lup1_0.COMPANY_NUM_ID, lup1_0.ANONYMIZED, lup1_0.USER_CIVILITY, lup1_0.CREATION_DATE, lup1_0.USER_NUM_ID_CREATOR, lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME || ' (' || lup1_0.USER_LOGIN || ')', lup1_0.LAST_CONNECTION_DATE, lup1_0.USER_NAME, lup1_0.MODIFICATION_DATE, lup1_0.MODIFIER_NUM_ID, lup1_0.POLICY_VERSION, lup1_0.OBJ_NUM_ID, lup1_0.USER_ADDRESS, lup1_0.USER_AUTHENTICATION, lup1_0.USER_CITY, lup1_0.USER_COUNTRY, lup1_0.USER_DELETED, lup1_0.USER_FAX, lup1_0.USER_GUID, lup1_0.USER_LOGIN, lup1_0.USER_MAIL, lup1_0.USER_CELULAR, lup1_0.USER_PASSWORD, lup1_0.USER_PHONE, lup1_0.USER_POSTAL_CODE, lup1_0.USER_BOK from A3D_USER lup1_0 where lower(lup1_0.USER_LOGIN) = $1;
Date: 2025-10-29 11:01:24 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select lup1_0.USER_NUM_ID, lup1_0.COMPANY_NUM_ID, lup1_0.ANONYMIZED, lup1_0.USER_CIVILITY, lup1_0.CREATION_DATE, lup1_0.USER_NUM_ID_CREATOR, lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME || ' (' || lup1_0.USER_LOGIN || ')', lup1_0.LAST_CONNECTION_DATE, lup1_0.USER_NAME, lup1_0.MODIFICATION_DATE, lup1_0.MODIFIER_NUM_ID, lup1_0.POLICY_VERSION, lup1_0.OBJ_NUM_ID, lup1_0.USER_ADDRESS, lup1_0.USER_AUTHENTICATION, lup1_0.USER_CITY, lup1_0.USER_COUNTRY, lup1_0.USER_DELETED, lup1_0.USER_FAX, lup1_0.USER_GUID, lup1_0.USER_LOGIN, lup1_0.USER_MAIL, lup1_0.USER_CELULAR, lup1_0.USER_PASSWORD, lup1_0.USER_PHONE, lup1_0.USER_POSTAL_CODE, lup1_0.USER_BOK from A3D_USER lup1_0 where lower(lup1_0.USER_LOGIN) = $1;
Date: 2025-10-29 11:15:25 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select lup1_0.USER_NUM_ID, lup1_0.COMPANY_NUM_ID, lup1_0.ANONYMIZED, lup1_0.USER_CIVILITY, lup1_0.CREATION_DATE, lup1_0.USER_NUM_ID_CREATOR, lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME, lup1_0.USER_NAME || ' ' || lup1_0.USER_FIRSTNAME || ' (' || lup1_0.USER_LOGIN || ')', lup1_0.LAST_CONNECTION_DATE, lup1_0.USER_NAME, lup1_0.MODIFICATION_DATE, lup1_0.MODIFIER_NUM_ID, lup1_0.POLICY_VERSION, lup1_0.OBJ_NUM_ID, lup1_0.USER_ADDRESS, lup1_0.USER_AUTHENTICATION, lup1_0.USER_CITY, lup1_0.USER_COUNTRY, lup1_0.USER_DELETED, lup1_0.USER_FAX, lup1_0.USER_GUID, lup1_0.USER_LOGIN, lup1_0.USER_MAIL, lup1_0.USER_CELULAR, lup1_0.USER_PASSWORD, lup1_0.USER_PHONE, lup1_0.USER_POSTAL_CODE, lup1_0.USER_BOK from A3D_USER lup1_0 where lower(lup1_0.USER_LOGIN) = $1;
Date: 2025-10-29 11:01:24 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
13 6ms 33 0ms 1ms 0ms select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 11 33 6ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 33 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 33 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-10-29 11:13:28 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-10-29 11:00:35 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2025-10-29 11:13:33 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
14 6ms 4 0ms 6ms 1ms select current_schema();Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 11 4 6ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 4 ]
-
select current_schema();
Date: 2025-10-29 11:00:20 Duration: 6ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select current_schema();
Date: 2025-10-29 11:13:16 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select current_schema();
Date: 2025-10-29 11:13:16 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
15 6ms 18 0ms 2ms 0ms select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 11 18 6ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 18 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7ms - Times executed: 18 ]
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:00:36 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:13:32 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:00:38 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
16 5ms 20 0ms 1ms 0ms select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 11 20 5ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 20 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7ms - Times executed: 20 ]
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:00:37 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:13:48 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:13:30 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
17 5ms 2 0ms 5ms 2ms select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 11 2 5ms 2ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;
Date: 2025-10-29 11:00:36 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;
Date: 2025-10-29 11:13:29 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
18 5ms 2 0ms 5ms 2ms call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID ($1, $2);Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 11 2 5ms 2ms [ User: a3dsupervisor - Total duration: 149ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 149ms - Times executed: 2 ]
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID ($1, $2);
Date: 2025-10-29 11:02:08 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID ($1, $2);
Date: 2025-10-29 11:15:00 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
19 5ms 2 2ms 3ms 2ms SELECT ef.FILE_SRC_MD5, ef.FILE_SRC, ef.FILE_BIM6D FROM ENG_FILE ef WHERE FILE_SRC IS NOT NULL AND FILE_BIM6D IS NOT NULL AND FILE_SRC_MD5 NOT IN ( SELECT FILE_SRC_MD5 FROM ENG_DATA ed WHERE ef.FILE_SRC_MD5 = ed.FILE_SRC_MD5) ORDER BY ef.CONSULT_DATE DESC;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 11 2 5ms 2ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 2 ]
-
SELECT ef.FILE_SRC_MD5, ef.FILE_SRC, ef.FILE_BIM6D FROM ENG_FILE ef WHERE FILE_SRC IS NOT NULL AND FILE_BIM6D IS NOT NULL AND FILE_SRC_MD5 NOT IN ( SELECT FILE_SRC_MD5 FROM ENG_DATA ed WHERE ef.FILE_SRC_MD5 = ed.FILE_SRC_MD5) ORDER BY ef.CONSULT_DATE DESC;
Date: 2025-10-29 11:02:08 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
SELECT ef.FILE_SRC_MD5, ef.FILE_SRC, ef.FILE_BIM6D FROM ENG_FILE ef WHERE FILE_SRC IS NOT NULL AND FILE_BIM6D IS NOT NULL AND FILE_SRC_MD5 NOT IN ( SELECT FILE_SRC_MD5 FROM ENG_DATA ed WHERE ef.FILE_SRC_MD5 = ed.FILE_SRC_MD5) ORDER BY ef.CONSULT_DATE DESC;
Date: 2025-10-29 11:15:00 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
20 5ms 15 0ms 3ms 0ms select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 11 15 5ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 15 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7ms - Times executed: 15 ]
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;
Date: 2025-10-29 11:01:27 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;
Date: 2025-10-29 11:03:08 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;
Date: 2025-10-29 11:15:28 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 212ms 37 0ms 68ms 5ms 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 31 07 1 15ms 15ms 10 4 16ms 4ms 14 4 3ms 0ms Oct 31 08 2 15ms 7ms 11 8 19ms 2ms 12 2 1ms 0ms 13 1 0ms 0ms Oct 31 09 2 69ms 34ms 11 1 0ms 0ms 12 1 0ms 0ms 15 5 4ms 0ms Oct 31 14 6 63ms 10ms [ User: a3dsupervisor - Total duration: 423ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 423ms - Times executed: 37 ]
-
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-29 08:33:20 Duration: 68ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-30 13:45:23 Duration: 59ms 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-27 06:44:30 Duration: 15ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 194ms 37 0ms 57ms 5ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 06 1 13ms 13ms 09 4 16ms 4ms 13 4 3ms 0ms 07 2 16ms 8ms 10 8 20ms 2ms 11 2 2ms 1ms 12 1 0ms 0ms 08 2 51ms 25ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 4ms 0ms 13 6 62ms 10ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 37 ]
-
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-30 13:45:23 Duration: 57ms 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-29 08:33:20 Duration: 50ms 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-28 07:40:43 Duration: 15ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 97ms 2 2ms 94ms 48ms select * from information_schema.sequences;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 11 2 97ms 48ms [ User: a3dsupervisor - Total duration: 39ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39ms - Times executed: 2 ]
-
select * from information_schema.sequences;
Date: 2025-10-29 11:00:23 Duration: 94ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select * from information_schema.sequences;
Date: 2025-10-29 11:13:18 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
4 92ms 37 0ms 26ms 2ms 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 #4
Day Hour Count Duration Avg duration 06 1 7ms 7ms 09 4 9ms 2ms 13 4 1ms 0ms 07 2 7ms 3ms 10 8 8ms 1ms 11 2 0ms 0ms 12 1 0ms 0ms 08 2 26ms 13ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms 13 6 26ms 4ms [ User: a3dsupervisor - Total duration: 521ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 521ms - Times executed: 37 ]
-
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-29 08:33:20 Duration: 26ms 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-30 13:45:24 Duration: 24ms 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-27 09:07:41 Duration: 8ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 86ms 37 0ms 23ms 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 bind #5
Day Hour Count Duration Avg duration 06 1 5ms 5ms 09 4 8ms 2ms 13 4 1ms 0ms 07 2 6ms 3ms 10 8 11ms 1ms 11 2 1ms 0ms 12 1 0ms 0ms 08 2 21ms 10ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 3ms 0ms 13 6 25ms 4ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 37 ]
-
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-30 13:45:24 Duration: 23ms 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-29 08:33:20 Duration: 20ms 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-28 10:41:03 Duration: 7ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 84ms 404 0ms 46ms 0ms select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 11 404 84ms 0ms [ User: a3dsupervisor - Total duration: 56ms - Times executed: 404 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 56ms - Times executed: 404 ]
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:00:37 Duration: 46ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:13:30 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gatp1_0.ATT_TEMPLATE_NUM_ID, gatp1_0.ATT_ACTIVATED_UNIT, gatp1_0.ATT_TEMPLATE_A3D_NUM_ID, gatp1_0.ATT_TEMPLATE_BIM_ACTIVATED, gatp1_0.ATT_TEMPLATE_CREATOR, gatp1_0.ATT_TEMPLATE_DATE_FORMAT, gatp1_0.ATT_TEMPLATE_DCRE, gatp1_0.ATT_TEMPLATE_DEFAULT_VALUE, gatp1_0.ATT_TEMPLATE_DMAJ, gatp1_0.ATT_TEMPLATE_DOMAIN_CODE, gatp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatp1_0.ATT_TEMPLATE_ENUM_PARENT, gatp1_0.ATT_TEMPLATE_LINE_WRAP, gatp1_0.ATT_TEMPLATE_MAX, gatp1_0.ATT_TEMPLATE_MIN, gatp1_0.ATT_TEMPLATE_MODIFIABLE, gatp1_0.ATT_TEMPLATE_MODIFIER, gatp1_0.ATT_TEMPLATE_NAME_FR, gatp1_0.ATT_TEMPLATE_OBLIGATOIRE, gatp1_0.ATT_TEMPLATE_SCALE, gatp1_0.ATT_TEMPLATE_SIZE, gatp1_0.ATT_TEMPLATE_TOOLTIP, gatp1_0.ATT_TEMPLATE_UNIQUE_VALUE, gatp1_0.ATT_UNIT_NUM_ID, gatp1_0.UNIQUE_CODE, gatp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE gatp1_0 where gatp1_0.ATT_TEMPLATE_A3D_NUM_ID = $1 and gatp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:13:54 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
7 77ms 2 3ms 73ms 38ms select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 11 2 77ms 38ms [ User: a3dsupervisor - Total duration: 31ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31ms - Times executed: 2 ]
-
select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;
Date: 2025-10-29 11:00:48 Duration: 73ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select distinct obj_num_id from gtp_rel_template grt inner join gtp_contenu_rel_template gcrt on gcrt.rel_template_num_id = grt.rel_template_num_id inner join gtp_obj gob on gob.obj_template_num_id = gcrt.obj_template_num_id where grt.rel_template_a3d_num_id in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) and gob.obj_status = 1 LIMIT 50000;
Date: 2025-10-29 11:13:41 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
8 65ms 8 1ms 53ms 8ms select gobContent.obj_num_id from gtp_obj gobContent inner join gtp_relation gcr on GCR.CONTENT_NUM_ID = GOBCONTENT.OBJ_NUM_ID inner join gtp_obj_template got on gobContent.obj_template_num_id = got.obj_template_num_id inner join gtp_rel_template grt on (grt.REL_TEMPLATE_NUM_ID = gcr.REL_TEMPLATE_NUM_ID AND grt.REL_TEMPLATE_A3D_NUM_ID = $1) where GOBCONTENT.OBJ_B_VALID = 1 and gcr.container_num_id = $2 and gobContent.OBJ_STATE IS NULL and gobContent.OBJ_STATUS = $3 and got.obj_template_a3d_num_id in (18);Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 11 8 65ms 8ms [ User: a3dsupervisor - Total duration: 11ms - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 11ms - Times executed: 8 ]
-
select gobContent.obj_num_id from gtp_obj gobContent inner join gtp_relation gcr on GCR.CONTENT_NUM_ID = GOBCONTENT.OBJ_NUM_ID inner join gtp_obj_template got on gobContent.obj_template_num_id = got.obj_template_num_id inner join gtp_rel_template grt on (grt.REL_TEMPLATE_NUM_ID = gcr.REL_TEMPLATE_NUM_ID AND grt.REL_TEMPLATE_A3D_NUM_ID = $1) where GOBCONTENT.OBJ_B_VALID = 1 and gcr.container_num_id = $2 and gobContent.OBJ_STATE IS NULL and gobContent.OBJ_STATUS = $3 and got.obj_template_a3d_num_id in (18);
Date: 2025-10-29 11:03:10 Duration: 53ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gobContent.obj_num_id from gtp_obj gobContent inner join gtp_relation gcr on GCR.CONTENT_NUM_ID = GOBCONTENT.OBJ_NUM_ID inner join gtp_obj_template got on gobContent.obj_template_num_id = got.obj_template_num_id inner join gtp_rel_template grt on (grt.REL_TEMPLATE_NUM_ID = gcr.REL_TEMPLATE_NUM_ID AND grt.REL_TEMPLATE_A3D_NUM_ID = $1) where GOBCONTENT.OBJ_B_VALID = 1 and gcr.container_num_id = $2 and gobContent.OBJ_STATE IS NULL and gobContent.OBJ_STATUS = $3 and got.obj_template_a3d_num_id in (18);
Date: 2025-10-29 11:15:42 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gobContent.obj_num_id from gtp_obj gobContent inner join gtp_relation gcr on GCR.CONTENT_NUM_ID = GOBCONTENT.OBJ_NUM_ID inner join gtp_obj_template got on gobContent.obj_template_num_id = got.obj_template_num_id inner join gtp_rel_template grt on (grt.REL_TEMPLATE_NUM_ID = gcr.REL_TEMPLATE_NUM_ID AND grt.REL_TEMPLATE_A3D_NUM_ID = $1) where GOBCONTENT.OBJ_B_VALID = 1 and gcr.container_num_id = $2 and gobContent.OBJ_STATE IS NULL and gobContent.OBJ_STATUS = $3 and got.obj_template_a3d_num_id in (18);
Date: 2025-10-29 11:15:43 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
9 62ms 134 0ms 44ms 0ms select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 11 134 62ms 0ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 134 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17ms - Times executed: 134 ]
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:00:37 Duration: 44ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:13:30 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotp1_0.OBJ_TEMPLATE_NUM_ID, gotp1_0.COMPONENT_NUM_ID, gotp1_0.OBJ_TEMPLATE_B_VALID, gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID, gotp1_0.OBJ_TEMPLATE_COMPO_VERSION, gotp1_0.OBJ_TEMPLATE_CREATOR, gotp1_0.OBJ_TEMPLATE_DCRE, gotp1_0.OBJ_TEMPLATE_DMAJ, gotp1_0.OBJ_TEMPLATE_ICON_NUM_ID, gotp1_0.OBJ_TEMPL_INSTANCE_ICON_NUM_ID, gotp1_0.OBJ_TEMPLATE_MODIFIER, gotp1_0.OBJ_TEMPLATE_NAME_FR, gotp1_0.OBJ_TEMPLATE_VERSION, gotp1_0.UNIQUE_CODE, gotp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE gotp1_0 where gotp1_0.OBJ_TEMPLATE_A3D_NUM_ID = $1 and gotp1_0.WORKSPACE_NUM_ID = $2;
Date: 2025-10-29 11:13:32 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
10 47ms 2 0ms 47ms 23ms select gnttp1_0.NODE_TREE_TYPE_NUM_ID, gnttp1_0.VIEW_TEMPLATE_NUM_ID, gnttp1_0.LNK_TEMPLATE_NUM_ID, gnttp1_0.NODE_TREE_TYPE_A3D_NUM_ID, gnttp1_0.NODE_TREE_TYPE_NUM_ID_P, gnttp1_0.NODE_TREE_TYPE_POSITION, gnttp1_0.OBJ_TEMPLATE_NUM_ID, gnttp1_0.REL_SENS, gnttp1_0.REL_TEMPLATE_NUM_ID, gnttp1_0.REQUETE_V2_NUM_ID, gnttp1_0.TYPE_NODE_CODE from GTP_NODE_TREE_TYPE gnttp1_0;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 11 2 47ms 23ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3ms - Times executed: 2 ]
-
select gnttp1_0.NODE_TREE_TYPE_NUM_ID, gnttp1_0.VIEW_TEMPLATE_NUM_ID, gnttp1_0.LNK_TEMPLATE_NUM_ID, gnttp1_0.NODE_TREE_TYPE_A3D_NUM_ID, gnttp1_0.NODE_TREE_TYPE_NUM_ID_P, gnttp1_0.NODE_TREE_TYPE_POSITION, gnttp1_0.OBJ_TEMPLATE_NUM_ID, gnttp1_0.REL_SENS, gnttp1_0.REL_TEMPLATE_NUM_ID, gnttp1_0.REQUETE_V2_NUM_ID, gnttp1_0.TYPE_NODE_CODE from GTP_NODE_TREE_TYPE gnttp1_0;
Date: 2025-10-29 11:00:39 Duration: 47ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gnttp1_0.NODE_TREE_TYPE_NUM_ID, gnttp1_0.VIEW_TEMPLATE_NUM_ID, gnttp1_0.LNK_TEMPLATE_NUM_ID, gnttp1_0.NODE_TREE_TYPE_A3D_NUM_ID, gnttp1_0.NODE_TREE_TYPE_NUM_ID_P, gnttp1_0.NODE_TREE_TYPE_POSITION, gnttp1_0.OBJ_TEMPLATE_NUM_ID, gnttp1_0.REL_SENS, gnttp1_0.REL_TEMPLATE_NUM_ID, gnttp1_0.REQUETE_V2_NUM_ID, gnttp1_0.TYPE_NODE_CODE from GTP_NODE_TREE_TYPE gnttp1_0;
Date: 2025-10-29 11:13:32 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
11 46ms 2 0ms 46ms 23ms select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 11 2 46ms 23ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;
Date: 2025-10-29 11:00:36 Duration: 46ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotcp1_0.OBJ_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.OBJ_TEMP_CATEGORY_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_B_VALID, gotcp1_0.OBJ_TEMPLATE_CATEGORY_CREATOR, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DCRE, gotcp1_0.OBJ_TEMPLATE_CATEGORY_DMAJ, gotcp1_0.OBJ_TEMPLATE_CATEGORY_MODIFIER, gotcp1_0.OBJ_TEMPLATE_CATEGORY_NAME_FR, gotcp1_0.UNIQUE_CODE, gotcp1_0.WORKSPACE_NUM_ID from GTP_OBJ_TEMPLATE_CATEGORY gotcp1_0;
Date: 2025-10-29 11:13:29 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
12 43ms 37 0ms 16ms 1ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 06 1 1ms 1ms 09 4 3ms 0ms 13 4 0ms 0ms 07 2 2ms 1ms 10 8 3ms 0ms 11 2 0ms 0ms 12 1 0ms 0ms 08 2 16ms 8ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 0ms 0ms 13 6 13ms 2ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 37 ]
[ Application: [unknown] - Total duration: 8ms - Times executed: 37 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-29 08:33:20 Duration: 16ms 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-30 13:45:23 Duration: 12ms 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-27 09:07:41 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
13 40ms 2 0ms 39ms 20ms select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 11 2 40ms 20ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;
Date: 2025-10-29 11:00:36 Duration: 39ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gatcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gatcp1_0.ATT_TEMP_CATEGORY_A3D_NUM_ID, gatcp1_0.ATT_TEMPLATE_CATEGORY_B_VALID, gatcp1_0.ATT_TEMPLATE_CATEGORY_CREATOR, gatcp1_0.ATT_TEMPLATE_CATEGORY_DCRE, gatcp1_0.ATT_TEMPLATE_CATEGORY_DMAJ, gatcp1_0.ATT_TEMPLATE_CATEGORY_MODIFIER, gatcp1_0.ATT_TEMPLATE_CATEGORY_NAME_FR, gatcp1_0.UNIQUE_CODE, gatcp1_0.WORKSPACE_NUM_ID from GTP_ATT_TEMPLATE_CATEGORY gatcp1_0;
Date: 2025-10-29 11:13:29 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
14 38ms 2 0ms 37ms 19ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 11 2 38ms 19ms [ User: a3dsupervisor - Total duration: 767ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 767ms - Times executed: 2 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-10-29 11:02:08 Duration: 37ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-10-29 11:15:00 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
15 37ms 142 0ms 25ms 0ms select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 11 142 37ms 0ms [ User: a3dsupervisor - Total duration: 19ms - Times executed: 142 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 19ms - Times executed: 142 ]
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;
Date: 2025-10-29 11:01:27 Duration: 25ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;
Date: 2025-10-29 11:03:08 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select brp1_0.RIGHT_NUM_ID, brp1_0.ACCEPT_FUTURE_ELEMENTS, brp1_0.CONTEXT_NUM_ID, brp1_0.ELEMENT_TYPE, brp1_0.RIGHT_CREATOR, brp1_0.RIGHT_DCRE, brp1_0.RIGHT_DMAJ, brp1_0.RIGHT_MODIFIER, brp1_0.TARGET_NUM_ID, brp1_0.TARGET_TYPE from BDC_RIGHT brp1_0 where brp1_0.TARGET_NUM_ID = $1 and brp1_0.TARGET_TYPE = $2 and brp1_0.ELEMENT_TYPE = $3;
Date: 2025-10-29 11:01:27 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
16 36ms 161 0ms 22ms 0ms select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 11 161 36ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 161 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5ms - Times executed: 161 ]
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-10-29 11:00:35 Duration: 22ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-10-29 11:13:28 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select pp1_0.PROPERTY_NAME, pp1_0.PROPERTY_COMMENT, pp1_0.PROPERTY_CREATOR, pp1_0.PROPERTY_DCRE, pp1_0.PROPERTY_DMAJ, pp1_0.PROPERTY_DOMAIN, pp1_0.PROPERTY_MODIFIER, pp1_0.PROPERTY_VALUE from PROPERTY pp1_0 where pp1_0.PROPERTY_NAME = $1;
Date: 2025-10-29 11:01:25 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
17 35ms 2 0ms 35ms 17ms select gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_LIST_ORDER, gatevp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatevp1_0.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID, gatevp1_0.ICON_FILE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_IS_DEF, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_PARENT, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_STATUS, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_VALUE, gatevp1_0.EXT_CODE, gatevp1_0.UNIQUE_CODE from GTP_ATT_TEMPLATE_ENUM_VALUE gatevp1_0;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 11 2 35ms 17ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 2 ]
-
select gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_LIST_ORDER, gatevp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatevp1_0.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID, gatevp1_0.ICON_FILE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_IS_DEF, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_PARENT, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_STATUS, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_VALUE, gatevp1_0.EXT_CODE, gatevp1_0.UNIQUE_CODE from GTP_ATT_TEMPLATE_ENUM_VALUE gatevp1_0;
Date: 2025-10-29 11:00:37 Duration: 35ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_LIST_ORDER, gatevp1_0.ATT_TEMPLATE_ENUM_NUM_ID, gatevp1_0.ATT_TEMP_ENUM_VALUE_A3D_NUM_ID, gatevp1_0.ICON_FILE_NUM_ID, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_IS_DEF, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_PARENT, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_STATUS, gatevp1_0.ATT_TEMPLATE_ENUM_VALUE_VALUE, gatevp1_0.EXT_CODE, gatevp1_0.UNIQUE_CODE from GTP_ATT_TEMPLATE_ENUM_VALUE gatevp1_0;
Date: 2025-10-29 11:13:30 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
18 32ms 1,303 0ms 1ms 0ms COMMIT;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 11 1,303 32ms 0ms [ User: a3dsupervisor - Total duration: 729ms - Times executed: 1303 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 729ms - Times executed: 1303 ]
-
COMMIT;
Date: 2025-10-29 11:15:10 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-10-29 11:00:52 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
COMMIT;
Date: 2025-10-29 11:00:59 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
19 29ms 344 0ms 11ms 0ms select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 11 344 29ms 0ms [ User: a3dsupervisor - Total duration: 26ms - Times executed: 344 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 26ms - Times executed: 344 ]
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);
Date: 2025-10-29 11:01:03 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);
Date: 2025-10-29 11:13:53 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotrcap1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_NUM_ID, gotrcap1_0.OBJ_TEMPLATE_REL_CAT_ATT_ORDER from GTP_OBJ_TEMPLATE_REL_CAT_ATT gotrcap1_0 where gotrcap1_0.OBJ_TEMPLATE_NUM_ID in ($1);
Date: 2025-10-29 11:01:50 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
20 27ms 2 0ms 26ms 13ms select gotcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.ATT_TEMPLATE_NUM_ID, gotcp1_0.OBJ_TEMPLATE_NUM_ID, gotcp1_0.ATT_TEMPLATE_REFERENCE, gotcp1_0.IMPORT_TYPE, gotcp1_0.MONTHLY_HISTORIZED, gotcp1_0.OBJ_TEMP_COMPO_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_ORDER, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_VALID, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_VISIB, gotcp1_0.ROW_HEIGHT, gotcp1_0.SENSITIVE_DATA, gotcp1_0.TOOLTIP, gotcp1_0.TOOLTIP_ICON_ID from GTP_OBJ_TEMPLATE_COMPOSITION gotcp1_0;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 11 2 27ms 13ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4ms - Times executed: 2 ]
-
select gotcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.ATT_TEMPLATE_NUM_ID, gotcp1_0.OBJ_TEMPLATE_NUM_ID, gotcp1_0.ATT_TEMPLATE_REFERENCE, gotcp1_0.IMPORT_TYPE, gotcp1_0.MONTHLY_HISTORIZED, gotcp1_0.OBJ_TEMP_COMPO_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_ORDER, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_VALID, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_VISIB, gotcp1_0.ROW_HEIGHT, gotcp1_0.SENSITIVE_DATA, gotcp1_0.TOOLTIP, gotcp1_0.TOOLTIP_ICON_ID from GTP_OBJ_TEMPLATE_COMPOSITION gotcp1_0;
Date: 2025-10-29 11:00:41 Duration: 26ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gotcp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcp1_0.ATT_TEMPLATE_NUM_ID, gotcp1_0.OBJ_TEMPLATE_NUM_ID, gotcp1_0.ATT_TEMPLATE_REFERENCE, gotcp1_0.IMPORT_TYPE, gotcp1_0.MONTHLY_HISTORIZED, gotcp1_0.OBJ_TEMP_COMPO_A3D_NUM_ID, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_ORDER, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_VALID, gotcp1_0.OBJ_TEMPLATE_COMPOSITION_VISIB, gotcp1_0.ROW_HEIGHT, gotcp1_0.SENSITIVE_DATA, gotcp1_0.TOOLTIP, gotcp1_0.TOOLTIP_ICON_ID from GTP_OBJ_TEMPLATE_COMPOSITION gotcp1_0;
Date: 2025-10-29 11:13:34 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 763,678 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 16 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 14 Max number of times the same event was reported
- 16 Total events found