pgBadger-
Global information
- Generated on Thu Oct 30 09:11:20 2025
- Log file: ././A3D-RND-REF/y=2025/m=10/d=29/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=10/d=29/h=23/m=00/PT1H.log
- Parsed 213,808 log entries in 9m7s
- Log start from 2025-10-29 08:33:20 to 2025-10-29 19:31:43
-
Overview
Global Stats
- 946 Number of unique normalized queries
- 9,758 Number of queries
- 1m40s Total query duration
- 2025-10-29 08:33:20 First query
- 2025-10-29 19:31:43 Last query
- 207 queries/s at 2025-10-29 19:24:49 Query peak
- 1m40s Total query duration
- 604ms Prepare/parse total duration
- 2s599ms Bind total duration
- 1m37s 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
- 23 Total number of sessions
- 2 sessions at 2025-10-29 19:34:26 Session peak
- 1h34m17s Total duration of sessions
- 4m5s Average duration of sessions
- 424 Average queries per session
- 4s374ms Average queries duration per session
- 4m1s Average idle time per session
- 23 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
- 195 queries/s Query Peak
- 2025-10-29 19:24:49 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 86 queries/s Query Peak
- 2025-10-29 19:31:43 Date
Queries duration
Key values
- 1m40s 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 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 Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 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 Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare 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% Day Hour Count Average / Second 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 Day Hour Count Average Duration Average idle time Oct 29 08 2 498ms 450ms 10 1 278ms 242ms 11 12 4m56s 4m54s 14 5 285ms 238ms 19 3 11m39s 11m16s -
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
- 23 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 23 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2025-10-29 19:34:26 Date
Histogram of session times
Key values
- 10 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 23 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 23 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 23 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 4.19 MiB Temp Files size Peak
- 2025-10-29 11:00:50 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2025-10-29 11:00:50 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size 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 -
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 29 08 0 0 10 0 0 11 0 1 14 0 0 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
- 3,544 Total read queries
- 3,196 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 9,758 Requests
- 1m37s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 9,758 Requests
User Request type Count Duration a3dsupervisor Total 9,758 1m37s copy to 242 1m10s cte 5 3ms delete 32 21s991ms insert 264 292ms others 411 209ms select 3,544 2s794ms tcl 2,637 804ms update 16 1s36ms Duration by user
Key values
- 1m37s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 9,758 1m37s copy to 242 1m10s cte 5 3ms delete 32 21s991ms insert 264 292ms others 411 209ms select 3,544 2s794ms tcl 2,637 804ms update 16 1s36ms Queries by host
Key values
- 10.3.0.4 Main host
- 9,758 Requests
- 1m37s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 8,614 Requests
- 1m10s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-29 19:26:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 9,246 0-1ms duration
Slowest individual queries
Rank Duration Query 1 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 ]
2 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 ]
3 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 ]
4 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 ]
5 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 ]
6 5s798ms 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-29 19:31:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 4s961ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 1s165ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 1s143ms 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-29 19:31:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 1s16ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 835ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 696ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 681ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 488ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 425ms COMMIT;[ 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 ]
16 407ms 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 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 365ms COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;[ Date: 2025-10-29 19:31:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 334ms select grvp1_0.REQUETE_V2_NUM_ID, grvp1_0.USER_NUM_ID, grvp1_0.USER_NUM_ID_MODIFIER, grvp1_0.REQUETE_V2_DATE_CREATION, grvp1_0.OBJ_TEMPLATE_NUM_ID, grvp1_0.REQUETE_V2_A3D_NUM_ID, grvp1_0.REQUETE_V2_COMMENT, grvp1_0.REQUETE_V2_GROUP_NUM_ID, grvp1_0.REQUETE_V2_HAVE_USER_CONDITION, grvp1_0.REQUETE_V2_NOM, grvp1_0.REQUETE_V2_VALUE, grvp1_0.UNIQUE_CODE, grvp1_0.REQUETE_V2_LAST_MODIF, grvp1_0.WORKSPACE_NUM_ID from GTP_REQUETE_V2 grvp1_0;[ Date: 2025-10-29 11:00:46 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 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;[ Date: 2025-10-29 19:31:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 275ms 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-29 19:31:37 - 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 21s940ms 2 0ms 21s940ms 10s970ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #1
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
2 20s912ms 1 20s912ms 20s912ms 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;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 29 20 1 20s912ms 20s912ms [ User: a3dsupervisor - Total duration: 20s912ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s912ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-29 19:30:49 Duration: 20s912ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 12s554ms 1 12s554ms 12s554ms 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;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 29 20 1 12s554ms 12s554ms [ User: a3dsupervisor - Total duration: 12s554ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s554ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-29 19:31:02 Duration: 12s554ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 8s613ms 1 8s613ms 8s613ms 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 29 20 1 8s613ms 8s613ms [ User: a3dsupervisor - Total duration: 8s613ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s613ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-29 19:31:11 Duration: 8s613ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 8s358ms 1 8s358ms 8s358ms 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;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 29 20 1 8s358ms 8s358ms [ User: a3dsupervisor - Total duration: 8s358ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s358ms - Times executed: 1 ]
-
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 1 5s798ms 5s798ms 5s798ms 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 29 20 1 5s798ms 5s798ms [ User: a3dsupervisor - Total duration: 5s798ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s798ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-29 19:31:25 Duration: 5s798ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 4s961ms 1 4s961ms 4s961ms 4s961ms 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 29 20 1 4s961ms 4s961ms [ User: a3dsupervisor - Total duration: 4s961ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s961ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-29 19:31:30 Duration: 4s961ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1s165ms 1 1s165ms 1s165ms 1s165ms 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 #8
Day Hour Count Duration Avg duration Oct 29 20 1 1s165ms 1s165ms [ User: a3dsupervisor - Total duration: 1s165ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s165ms - Times executed: 1 ]
-
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
9 1s143ms 1 1s143ms 1s143ms 1s143ms 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 #9
Day Hour Count Duration Avg duration Oct 29 20 1 1s143ms 1s143ms [ User: a3dsupervisor - Total duration: 1s143ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s143ms - Times executed: 1 ]
-
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-29 19:31:31 Duration: 1s143ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 1s16ms 1 1s16ms 1s16ms 1s16ms 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 29 20 1 1s16ms 1s16ms [ User: a3dsupervisor - Total duration: 1s16ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s16ms - Times executed: 1 ]
-
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
11 835ms 1 835ms 835ms 835ms 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 29 20 1 835ms 835ms [ User: a3dsupervisor - Total duration: 835ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 835ms - Times executed: 1 ]
-
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
12 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 #12
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
13 729ms 1,303 0ms 425ms 0ms commit;Times Reported Time consuming queries #13
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
14 681ms 1 681ms 681ms 681ms 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 #14
Day Hour Count Duration Avg duration Oct 29 20 1 681ms 681ms [ User: a3dsupervisor - Total duration: 681ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 681ms - Times executed: 1 ]
-
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
15 494ms 2 160ms 334ms 247ms select grvp1_0.requete_v2_num_id, grvp1_0.user_num_id, grvp1_0.user_num_id_modifier, grvp1_0.requete_v2_date_creation, grvp1_0.obj_template_num_id, grvp1_0.requete_v2_a3d_num_id, grvp1_0.requete_v2_comment, grvp1_0.requete_v2_group_num_id, grvp1_0.requete_v2_have_user_condition, grvp1_0.requete_v2_nom, grvp1_0.requete_v2_value, grvp1_0.unique_code, grvp1_0.requete_v2_last_modif, grvp1_0.workspace_num_id from gtp_requete_v2 grvp1_0;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 29 12 2 494ms 247ms [ User: a3dsupervisor - Total duration: 494ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 494ms - Times executed: 2 ]
-
select grvp1_0.REQUETE_V2_NUM_ID, grvp1_0.USER_NUM_ID, grvp1_0.USER_NUM_ID_MODIFIER, grvp1_0.REQUETE_V2_DATE_CREATION, grvp1_0.OBJ_TEMPLATE_NUM_ID, grvp1_0.REQUETE_V2_A3D_NUM_ID, grvp1_0.REQUETE_V2_COMMENT, grvp1_0.REQUETE_V2_GROUP_NUM_ID, grvp1_0.REQUETE_V2_HAVE_USER_CONDITION, grvp1_0.REQUETE_V2_NOM, grvp1_0.REQUETE_V2_VALUE, grvp1_0.UNIQUE_CODE, grvp1_0.REQUETE_V2_LAST_MODIF, grvp1_0.WORKSPACE_NUM_ID from GTP_REQUETE_V2 grvp1_0;
Date: 2025-10-29 11:00:46 Duration: 334ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select grvp1_0.REQUETE_V2_NUM_ID, grvp1_0.USER_NUM_ID, grvp1_0.USER_NUM_ID_MODIFIER, grvp1_0.REQUETE_V2_DATE_CREATION, grvp1_0.OBJ_TEMPLATE_NUM_ID, grvp1_0.REQUETE_V2_A3D_NUM_ID, grvp1_0.REQUETE_V2_COMMENT, grvp1_0.REQUETE_V2_GROUP_NUM_ID, grvp1_0.REQUETE_V2_HAVE_USER_CONDITION, grvp1_0.REQUETE_V2_NOM, grvp1_0.REQUETE_V2_VALUE, grvp1_0.UNIQUE_CODE, grvp1_0.REQUETE_V2_LAST_MODIF, grvp1_0.WORKSPACE_NUM_ID from GTP_REQUETE_V2 grvp1_0;
Date: 2025-10-29 11:13:38 Duration: 160ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
16 488ms 1 488ms 488ms 488ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 29 20 1 488ms 488ms [ User: a3dsupervisor - Total duration: 488ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 488ms - Times executed: 1 ]
-
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
17 407ms 1 407ms 407ms 407ms 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 #17
Day Hour Count Duration Avg duration Oct 29 20 1 407ms 407ms [ User: a3dsupervisor - Total duration: 407ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 407ms - Times executed: 1 ]
-
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
18 365ms 1 365ms 365ms 365ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 29 20 1 365ms 365ms [ User: a3dsupervisor - Total duration: 365ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 365ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-29 19:31:36 Duration: 365ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 281ms 1 281ms 281ms 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 #19
Day Hour Count Duration Avg duration Oct 29 20 1 281ms 281ms [ User: a3dsupervisor - Total duration: 281ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 281ms - Times executed: 1 ]
-
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
20 275ms 1 275ms 275ms 275ms 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 #20
Day Hour Count Duration Avg duration Oct 29 20 1 275ms 275ms [ User: a3dsupervisor - Total duration: 275ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 275ms - Times executed: 1 ]
-
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-29 19:31:37 Duration: 275ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 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 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 #3
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
4 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 #4
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
5 254 11ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 29 12 251 10ms 0ms 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 11ms - Times executed: 254 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10ms - Times executed: 251 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 3 ]
-
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
6 250 38ms 0ms 12ms 0ms select nextval(?);Times Reported Time consuming queries #6
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
7 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 #7
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
8 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 #8
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
9 164 23ms 0ms 0ms 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 #9
Day Hour Count Duration Avg duration Oct 29 20 164 23ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 164 ]
[ Application: pg_dump - Total duration: 23ms - Times executed: 164 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800427'::oid;
Date: 2025-10-29 19:24:49 Duration: 0ms 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-29 19:24:49 Duration: 0ms 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 = '2800554'::oid;
Date: 2025-10-29 19:24:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 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 #10
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
11 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 #11
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
12 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 #12
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
13 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 #13
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
14 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 #14
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
15 109 20ms 0ms 1ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 29 20 109 20ms 0ms [ User: a3dsupervisor - Total duration: 20ms - Times executed: 109 ]
[ Application: pg_dump - Total duration: 20ms - Times executed: 109 ]
-
EXECUTE dumpFunc ('2818912');
Date: 2025-10-29 19:24:48 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818849');
Date: 2025-10-29 19:24:48 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818867');
Date: 2025-10-29 19:24:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
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 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 #17
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
18 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 #18
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
19 48 37ms 0ms 10ms 0ms 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 =) where gobcontent.obj_b_valid = ? and gcr.container_num_id = and gobcontent.obj_state is null and got.obj_template_a3d_num_id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 29 12 48 37ms 0ms [ User: a3dsupervisor - Total duration: 37ms - Times executed: 48 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 37ms - Times executed: 48 ]
-
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 =) where GOBCONTENT.OBJ_B_VALID = 1 and gcr.container_num_id = and gobContent.OBJ_STATE IS NULL and got.obj_template_a3d_num_id in (564);
Date: 2025-10-29 11:03:10 Duration: 10ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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 =) where GOBCONTENT.OBJ_B_VALID = 1 and gcr.container_num_id = and gobContent.OBJ_STATE IS NULL and got.obj_template_a3d_num_id in (19);
Date: 2025-10-29 11:03:10 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
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 =) where GOBCONTENT.OBJ_B_VALID = 1 and gcr.container_num_id = and gobContent.OBJ_STATE IS NULL and got.obj_template_a3d_num_id in (584);
Date: 2025-10-29 11:03:12 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 48 31ms 0ms 4ms 0ms select gobcontent.obj_num_id as contentid, gcr.container_num_id as parentid from gtp_obj gobcontent inner join gtp_relation gcr on gcr.content_num_id = gobcontent.obj_num_id inner join gtp_rel_template grt on grt.rel_template_num_id = gcr.rel_template_num_id where gobcontent.obj_b_valid = ? and grt.rel_template_a3d_num_id = and gcr.container_num_id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 29 12 48 31ms 0ms [ User: a3dsupervisor - Total duration: 31ms - Times executed: 48 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 31ms - Times executed: 48 ]
-
select gobContent.obj_num_id as contentId, gcr.container_num_id as parentId from gtp_obj gobContent inner join gtp_relation gcr on gcr.content_num_id = GOBCONTENT.OBJ_NUM_ID inner join gtp_rel_template grt on GRT.REL_TEMPLATE_NUM_ID = gcr.REL_TEMPLATE_NUM_ID where GOBCONTENT.OBJ_B_VALID = 1 and GRT.REL_TEMPLATE_A3D_NUM_ID = AND gcr.container_num_id IN (385669);
Date: 2025-10-29 11:03:10 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gobContent.obj_num_id as contentId, gcr.container_num_id as parentId from gtp_obj gobContent inner join gtp_relation gcr on gcr.content_num_id = GOBCONTENT.OBJ_NUM_ID inner join gtp_rel_template grt on GRT.REL_TEMPLATE_NUM_ID = gcr.REL_TEMPLATE_NUM_ID where GOBCONTENT.OBJ_B_VALID = 1 and GRT.REL_TEMPLATE_A3D_NUM_ID = AND gcr.container_num_id IN (55158);
Date: 2025-10-29 11:03:12 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select gobContent.obj_num_id as contentId, gcr.container_num_id as parentId from gtp_obj gobContent inner join gtp_relation gcr on gcr.content_num_id = GOBCONTENT.OBJ_NUM_ID inner join gtp_rel_template grt on GRT.REL_TEMPLATE_NUM_ID = gcr.REL_TEMPLATE_NUM_ID where GOBCONTENT.OBJ_B_VALID = 1 and GRT.REL_TEMPLATE_A3D_NUM_ID = AND gcr.container_num_id IN (119866);
Date: 2025-10-29 11:03:10 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 20s912ms 20s912ms 20s912ms 1 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;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 29 20 1 20s912ms 20s912ms [ User: a3dsupervisor - Total duration: 20s912ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s912ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-29 19:30:49 Duration: 20s912ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 12s554ms 12s554ms 12s554ms 1 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;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 29 20 1 12s554ms 12s554ms [ User: a3dsupervisor - Total duration: 12s554ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s554ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-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 8s613ms 8s613ms 8s613ms 1 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 29 20 1 8s613ms 8s613ms [ User: a3dsupervisor - Total duration: 8s613ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s613ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-29 19:31:11 Duration: 8s613ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 8s358ms 8s358ms 8s358ms 1 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;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 29 20 1 8s358ms 8s358ms [ User: a3dsupervisor - Total duration: 8s358ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s358ms - Times executed: 1 ]
-
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 5s798ms 5s798ms 1 5s798ms 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 29 20 1 5s798ms 5s798ms [ User: a3dsupervisor - Total duration: 5s798ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 5s798ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-29 19:31:25 Duration: 5s798ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 4s961ms 4s961ms 4s961ms 1 4s961ms 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 29 20 1 4s961ms 4s961ms [ User: a3dsupervisor - Total duration: 4s961ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s961ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-29 19:31:30 Duration: 4s961ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1s165ms 1s165ms 1s165ms 1 1s165ms 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 #8
Day Hour Count Duration Avg duration Oct 29 20 1 1s165ms 1s165ms [ User: a3dsupervisor - Total duration: 1s165ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s165ms - Times executed: 1 ]
-
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
9 1s143ms 1s143ms 1s143ms 1 1s143ms 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 #9
Day Hour Count Duration Avg duration Oct 29 20 1 1s143ms 1s143ms [ User: a3dsupervisor - Total duration: 1s143ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s143ms - Times executed: 1 ]
-
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-29 19:31:31 Duration: 1s143ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 1s16ms 1s16ms 1s16ms 1 1s16ms 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 29 20 1 1s16ms 1s16ms [ User: a3dsupervisor - Total duration: 1s16ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s16ms - Times executed: 1 ]
-
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
11 835ms 835ms 835ms 1 835ms 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 29 20 1 835ms 835ms [ User: a3dsupervisor - Total duration: 835ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 835ms - Times executed: 1 ]
-
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
12 681ms 681ms 681ms 1 681ms 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 29 20 1 681ms 681ms [ User: a3dsupervisor - Total duration: 681ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 681ms - Times executed: 1 ]
-
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
13 488ms 488ms 488ms 1 488ms 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 29 20 1 488ms 488ms [ User: a3dsupervisor - Total duration: 488ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 488ms - Times executed: 1 ]
-
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
14 407ms 407ms 407ms 1 407ms 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 29 20 1 407ms 407ms [ User: a3dsupervisor - Total duration: 407ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 407ms - Times executed: 1 ]
-
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 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 #15
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
16 365ms 365ms 365ms 1 365ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 29 20 1 365ms 365ms [ User: a3dsupervisor - Total duration: 365ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 365ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-29 19:31:36 Duration: 365ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 281ms 281ms 281ms 1 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 29 20 1 281ms 281ms [ User: a3dsupervisor - Total duration: 281ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 281ms - Times executed: 1 ]
-
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
18 275ms 275ms 275ms 1 275ms 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 #18
Day Hour Count Duration Avg duration Oct 29 20 1 275ms 275ms [ User: a3dsupervisor - Total duration: 275ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 275ms - Times executed: 1 ]
-
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-29 19:31:37 Duration: 275ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 160ms 334ms 247ms 2 494ms select grvp1_0.requete_v2_num_id, grvp1_0.user_num_id, grvp1_0.user_num_id_modifier, grvp1_0.requete_v2_date_creation, grvp1_0.obj_template_num_id, grvp1_0.requete_v2_a3d_num_id, grvp1_0.requete_v2_comment, grvp1_0.requete_v2_group_num_id, grvp1_0.requete_v2_have_user_condition, grvp1_0.requete_v2_nom, grvp1_0.requete_v2_value, grvp1_0.unique_code, grvp1_0.requete_v2_last_modif, grvp1_0.workspace_num_id from gtp_requete_v2 grvp1_0;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 29 12 2 494ms 247ms [ User: a3dsupervisor - Total duration: 494ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 494ms - Times executed: 2 ]
-
select grvp1_0.REQUETE_V2_NUM_ID, grvp1_0.USER_NUM_ID, grvp1_0.USER_NUM_ID_MODIFIER, grvp1_0.REQUETE_V2_DATE_CREATION, grvp1_0.OBJ_TEMPLATE_NUM_ID, grvp1_0.REQUETE_V2_A3D_NUM_ID, grvp1_0.REQUETE_V2_COMMENT, grvp1_0.REQUETE_V2_GROUP_NUM_ID, grvp1_0.REQUETE_V2_HAVE_USER_CONDITION, grvp1_0.REQUETE_V2_NOM, grvp1_0.REQUETE_V2_VALUE, grvp1_0.UNIQUE_CODE, grvp1_0.REQUETE_V2_LAST_MODIF, grvp1_0.WORKSPACE_NUM_ID from GTP_REQUETE_V2 grvp1_0;
Date: 2025-10-29 11:00:46 Duration: 334ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select grvp1_0.REQUETE_V2_NUM_ID, grvp1_0.USER_NUM_ID, grvp1_0.USER_NUM_ID_MODIFIER, grvp1_0.REQUETE_V2_DATE_CREATION, grvp1_0.OBJ_TEMPLATE_NUM_ID, grvp1_0.REQUETE_V2_A3D_NUM_ID, grvp1_0.REQUETE_V2_COMMENT, grvp1_0.REQUETE_V2_GROUP_NUM_ID, grvp1_0.REQUETE_V2_HAVE_USER_CONDITION, grvp1_0.REQUETE_V2_NOM, grvp1_0.REQUETE_V2_VALUE, grvp1_0.UNIQUE_CODE, grvp1_0.REQUETE_V2_LAST_MODIF, grvp1_0.WORKSPACE_NUM_ID from GTP_REQUETE_V2 grvp1_0;
Date: 2025-10-29 11:13:38 Duration: 160ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 0ms 108ms 2ms 100 224ms 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 #20
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
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 112ms 9 1ms 99ms 12ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Oct 29 09 2 101ms 50ms 11 1 1ms 1ms 12 1 1ms 1ms 15 5 7ms 1ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 9 ]
-
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-29 10:46:43 Duration: 1ms 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:26 Duration: 1ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 62ms 9 0ms 57ms 6ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 08 2 58ms 29ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms [ User: a3dsupervisor - Total duration: 67ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 67ms - Times executed: 9 ]
-
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-29 14:18:05 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-29 14:47:56 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 36ms 9 0ms 29ms 4ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 08 2 30ms 15ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 3ms 0ms [ User: a3dsupervisor - Total duration: 154ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 154ms - Times executed: 9 ]
-
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-29 08:33:26 Duration: 1ms 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-29 10:46:43 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 25ms 9 0ms 23ms 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 08 2 23ms 11ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 1ms 0ms [ User: a3dsupervisor - Total duration: 54ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 54ms - Times executed: 9 ]
-
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-29 08:33:26 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-29 14:44:07 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 16ms 2 0ms 15ms 8ms select * from information_schema.sequences;Times Reported Time consuming prepare #5
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
6 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 #6
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
7 9ms 9 0ms 6ms 1ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 08 2 6ms 3ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1ms - Times executed: 9 ]
-
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-29 14:44:07 Duration: 0ms 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-29 08:33:26 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 9ms 9 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 #8
Day Hour Count Duration Avg duration 08 2 5ms 2ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 9 ]
-
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-29 14:44:07 Duration: 0ms 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 14:47:56 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
9 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 #9
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
10 7ms 9 0ms 5ms 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 #10
Day Hour Count Duration Avg duration 08 2 5ms 2ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 1ms 0ms [ User: a3dsupervisor - Total duration: 124ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 124ms - Times executed: 9 ]
-
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]
-
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 14:47:59 Duration: 0ms 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 14:55:16 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
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 97ms 2 2ms 94ms 48ms select * from information_schema.sequences;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 29 12 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
2 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 #2
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
3 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 #3
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
4 75ms 9 0ms 68ms 8ms 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 #4
Day Hour Count Duration Avg duration 08 2 69ms 34ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 4ms 0ms [ User: a3dsupervisor - Total duration: 154ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 154ms - Times executed: 9 ]
-
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-29 14:18:05 Duration: 1ms 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-29 08:33:26 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 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 #5
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
6 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 #6
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
7 57ms 9 0ms 50ms 6ms 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 #7
Day Hour Count Duration Avg duration 08 2 51ms 25ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 4ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 9 ]
-
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-29 14:55:16 Duration: 0ms 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:26 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 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 #8
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
9 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 #9
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
10 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 #10
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
11 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 #11
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
12 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 #12
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
13 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 #13
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
14 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 #14
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
15 32ms 1,303 0ms 1ms 0ms COMMIT;Times Reported Time consuming bind #15
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
16 29ms 9 0ms 26ms 3ms 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 #16
Day Hour Count Duration Avg duration 08 2 26ms 13ms 10 1 0ms 0ms 11 1 0ms 0ms 14 5 2ms 0ms [ User: a3dsupervisor - Total duration: 124ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 124ms - Times executed: 9 ]
-
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-29 14:47:56 Duration: 0ms 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 11:24:14 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
17 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 #17
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
18 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 #18
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
19 26ms 2 0ms 26ms 13ms select gaup1_0.ATT_UNIT_NUM_ID, gaup1_0.ATT_UNIT_A3D_NUM_ID, gaup1_0.ATT_UNIT_B_VALID, gaup1_0.ATT_UNIT_CATEGORY_NUM_ID, gaup1_0.ATT_UNIT_INFO, gaup1_0.ATT_UNIT_NAME, gaup1_0.ATT_UNIT_REF_FACTOR, gaup1_0.ATT_UNIT_REF_UNIT_NUM_ID, gaup1_0.UNIQUE_CODE, gaup1_0.WORKSPACE_NUM_ID from GTP_ATT_UNIT gaup1_0;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 11 2 26ms 13ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
select gaup1_0.ATT_UNIT_NUM_ID, gaup1_0.ATT_UNIT_A3D_NUM_ID, gaup1_0.ATT_UNIT_B_VALID, gaup1_0.ATT_UNIT_CATEGORY_NUM_ID, gaup1_0.ATT_UNIT_INFO, gaup1_0.ATT_UNIT_NAME, gaup1_0.ATT_UNIT_REF_FACTOR, gaup1_0.ATT_UNIT_REF_UNIT_NUM_ID, gaup1_0.UNIQUE_CODE, gaup1_0.WORKSPACE_NUM_ID from GTP_ATT_UNIT gaup1_0;
Date: 2025-10-29 11:00:37 Duration: 26ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select gaup1_0.ATT_UNIT_NUM_ID, gaup1_0.ATT_UNIT_A3D_NUM_ID, gaup1_0.ATT_UNIT_B_VALID, gaup1_0.ATT_UNIT_CATEGORY_NUM_ID, gaup1_0.ATT_UNIT_INFO, gaup1_0.ATT_UNIT_NAME, gaup1_0.ATT_UNIT_REF_FACTOR, gaup1_0.ATT_UNIT_REF_UNIT_NUM_ID, gaup1_0.UNIQUE_CODE, gaup1_0.WORKSPACE_NUM_ID from GTP_ATT_UNIT gaup1_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
20 26ms 218 0ms 9ms 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 bind #20
Day Hour Count Duration Avg duration 11 218 26ms 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:00:35 Duration: 9ms 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:05:05 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:18:48 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
- 203,962 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