pgBadger-
Global information
- Generated on Mon Oct 27 09:05:02 2025
- Log file: ././A3D-RND-REF/y=2025/m=10/d=24/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=10/d=24/h=23/m=00/PT1H.log
- Parsed 188,811 log entries in 3m45s
- Log start from 2025-10-24 05:05:37 to 2025-10-24 18:24:51
-
Overview
Global Stats
- 739 Number of unique normalized queries
- 1,336 Number of queries
- 1m12s Total query duration
- 2025-10-24 05:05:37 First query
- 2025-10-24 18:24:51 Last query
- 197 queries/s at 2025-10-24 18:24:50 Query peak
- 1m12s Total query duration
- 387ms Prepare/parse total duration
- 287ms Bind total duration
- 1m11s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 36 Total number of sessions
- 3 sessions at 2025-10-24 06:42:11 Session peak
- 35m50s Total duration of sessions
- 59s736ms Average duration of sessions
- 37 Average queries per session
- 2s13ms Average queries duration per session
- 57s722ms Average idle time per session
- 36 Total number of connections
- 2 connections/s at 2025-10-24 18:18:01 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 197 queries/s Query Peak
- 2025-10-24 18:24:50 Date
SELECT Traffic
Key values
- 186 queries/s Query Peak
- 2025-10-24 18:18:00 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 98 queries/s Query Peak
- 2025-10-24 18:24:50 Date
Queries duration
Key values
- 1m12s 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 24 05 80 0ms 19ms 4ms 71ms 71ms 71ms 06 56 0ms 19ms 5ms 104ms 104ms 104ms 07 8 0ms 16ms 6ms 52ms 52ms 52ms 08 8 0ms 13ms 4ms 34ms 34ms 34ms 09 8 0ms 13ms 4ms 34ms 34ms 34ms 10 8 0ms 18ms 5ms 40ms 40ms 40ms 12 8 0ms 13ms 4ms 34ms 34ms 34ms 13 24 0ms 15ms 4ms 109ms 109ms 109ms 14 24 0ms 14ms 4ms 36ms 36ms 36ms 15 40 0ms 13ms 4ms 105ms 105ms 105ms 18 1,072 0ms 20s949ms 65ms 20s949ms 48s958ms 48s958ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 24 05 80 0 4ms 69ms 71ms 71ms 06 56 0 5ms 104ms 104ms 104ms 07 8 0 6ms 52ms 52ms 52ms 08 8 0 4ms 34ms 34ms 34ms 09 8 0 4ms 34ms 34ms 34ms 10 8 0 5ms 40ms 40ms 40ms 12 8 0 4ms 34ms 34ms 34ms 13 24 0 4ms 109ms 109ms 109ms 14 24 0 4ms 36ms 36ms 36ms 15 40 0 4ms 105ms 105ms 105ms 18 430 242 104ms 399ms 20s949ms 48s936ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 24 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 24 05 80 80 1.00 100.00% 06 56 56 1.00 100.00% 07 8 8 1.00 100.00% 08 8 8 1.00 100.00% 09 8 8 1.00 100.00% 10 8 8 1.00 100.00% 12 8 8 1.00 100.00% 13 24 24 1.00 100.00% 14 24 24 1.00 100.00% 15 40 40 1.00 100.00% 18 3 116 38.67 0.44% Day Hour Count Average / Second Oct 24 05 10 0.00/s 06 7 0.00/s 07 1 0.00/s 08 1 0.00/s 09 1 0.00/s 10 1 0.00/s 12 1 0.00/s 13 3 0.00/s 14 3 0.00/s 15 5 0.00/s 18 3 0.00/s Day Hour Count Average Duration Average idle time Oct 24 05 10 284ms 247ms 06 7 345ms 298ms 07 1 408ms 355ms 08 1 481ms 446ms 09 1 264ms 229ms 10 1 280ms 239ms 12 1 294ms 259ms 13 3 285ms 249ms 14 3 278ms 243ms 15 5 274ms 239ms 18 3 11m53s 11m29s -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2025-10-24 18:18:01 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 36 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 36 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2025-10-24 06:42:11 Date
Histogram of session times
Key values
- 33 0-500ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 36 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 36 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 36 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 24 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 18 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 24 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 12 0 0 13 0 0 14 0 0 15 0 0 18 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 694 Total read queries
- 246 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 1,336 Requests
- 1m11s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 1,336 Requests
User Request type Count Duration a3dsupervisor Total 1,336 1m11s copy to 242 1m9s cte 1 3ms others 396 55ms select 694 1s864ms tcl 3 0ms Duration by user
Key values
- 1m11s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 1,336 1m11s copy to 242 1m9s cte 1 3ms others 396 55ms select 694 1s864ms tcl 3 0ms Queries by host
Key values
- 10.3.0.4 Main host
- 1,336 Requests
- 1m11s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 1,072 Requests
- 1m10s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-24 18:23:29 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 989 0-1ms duration
Slowest individual queries
Rank Duration Query 1 20s949ms 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-24 18:23:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 12s517ms 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-24 18:24:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 8s707ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-10-24 18:24:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 8s67ms 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-24 18:24:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 7s530ms 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-24 18:24:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 4s704ms 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-24 18:24:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 1s251ms 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-24 18:24:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 993ms 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-24 18:24:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 980ms 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-24 18:24:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 920ms 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-24 18:24:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 593ms 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-24 18:24:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 465ms 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-24 18:24:46 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 237ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-10-24 18:24:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 213ms 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-24 18:24:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 193ms COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;[ Date: 2025-10-24 18:24:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 165ms 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-24 18:24:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 163ms COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;[ Date: 2025-10-24 18:24:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 119ms COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;[ Date: 2025-10-24 18:24:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 108ms COPY public.gtp_log_jvm (log_jvm_num_id, server_id, log_date, max_memory, total_memory_min, total_memory_average, total_memory_max, used_memory_min, used_memory_average, used_memory_max) TO stdout;[ Date: 2025-10-24 18:24:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 85ms COPY public.bdc_history_right_action (history_right_num_id, user_num_id, action_date, action_type, target_num_id, target_type, context, element_num_id, element_type, right_mode, accept_future_elements) TO stdout;[ Date: 2025-10-24 18:24:47 - 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 20s949ms 1 20s949ms 20s949ms 20s949ms 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 24 20 1 20s949ms 20s949ms [ User: a3dsupervisor - Total duration: 20s949ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s949ms - 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-24 18:23:55 Duration: 20s949ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 12s517ms 1 12s517ms 12s517ms 12s517ms 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 24 20 1 12s517ms 12s517ms [ User: a3dsupervisor - Total duration: 12s517ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s517ms - 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-24 18:24:08 Duration: 12s517ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 8s707ms 1 8s707ms 8s707ms 8s707ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 24 20 1 8s707ms 8s707ms [ User: a3dsupervisor - Total duration: 8s707ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s707ms - 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-24 18:24:16 Duration: 8s707ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 8s67ms 1 8s67ms 8s67ms 8s67ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 24 20 1 8s67ms 8s67ms [ User: a3dsupervisor - Total duration: 8s67ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s67ms - 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-24 18:24:25 Duration: 8s67ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 7s530ms 1 7s530ms 7s530ms 7s530ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 24 20 1 7s530ms 7s530ms [ User: a3dsupervisor - Total duration: 7s530ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s530ms - 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-24 18:24:32 Duration: 7s530ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 4s704ms 1 4s704ms 4s704ms 4s704ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 24 20 1 4s704ms 4s704ms [ User: a3dsupervisor - Total duration: 4s704ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s704ms - 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-24 18:24:37 Duration: 4s704ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 1s251ms 1 1s251ms 1s251ms 1s251ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 24 20 1 1s251ms 1s251ms [ User: a3dsupervisor - Total duration: 1s251ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s251ms - 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-24 18:24:39 Duration: 1s251ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 993ms 1 993ms 993ms 993ms 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 24 20 1 993ms 993ms [ User: a3dsupervisor - Total duration: 993ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 993ms - 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-24 18:24:40 Duration: 993ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 980ms 1 980ms 980ms 980ms 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 #9
Day Hour Count Duration Avg duration Oct 24 20 1 980ms 980ms [ User: a3dsupervisor - Total duration: 980ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 980ms - 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-24 18:24:41 Duration: 980ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 920ms 1 920ms 920ms 920ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 24 20 1 920ms 920ms [ User: a3dsupervisor - Total duration: 920ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 920ms - 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-24 18:24:42 Duration: 920ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 593ms 1 593ms 593ms 593ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 24 20 1 593ms 593ms [ User: a3dsupervisor - Total duration: 593ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 593ms - 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-24 18:24:43 Duration: 593ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 469ms 33 12ms 19ms 14ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 24 07 10 141ms 14ms 08 7 107ms 15ms 09 1 15ms 15ms 10 1 13ms 13ms 11 1 13ms 13ms 12 1 18ms 18ms 14 1 13ms 13ms 15 3 41ms 13ms 16 3 40ms 13ms 17 5 64ms 12ms [ User: a3dsupervisor - Total duration: 469ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 469ms - Times executed: 33 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:05:38 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:30:15 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
13 465ms 1 465ms 465ms 465ms 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 #13
Day Hour Count Duration Avg duration Oct 24 20 1 465ms 465ms [ User: a3dsupervisor - Total duration: 465ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 465ms - 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-24 18:24:46 Duration: 465ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 295ms 33 6ms 19ms 8ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 24 07 10 87ms 8ms 08 7 77ms 11ms 09 1 16ms 16ms 10 1 7ms 7ms 11 1 7ms 7ms 12 1 8ms 8ms 14 1 7ms 7ms 15 3 23ms 7ms 16 3 21ms 7ms 17 5 38ms 7ms [ User: a3dsupervisor - Total duration: 295ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 295ms - Times executed: 33 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 06:42:09 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 05:05:38 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 06:30:15 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
15 272ms 33 6ms 18ms 8ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 24 07 10 69ms 6ms 08 7 88ms 12ms 09 1 11ms 11ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 14 1 6ms 6ms 15 3 21ms 7ms 16 3 20ms 6ms 17 5 34ms 6ms [ User: a3dsupervisor - Total duration: 272ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 272ms - Times executed: 33 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:23:18 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:31:03 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:30:15 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
16 237ms 1 237ms 237ms 237ms 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 24 20 1 237ms 237ms [ User: a3dsupervisor - Total duration: 237ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 237ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-24 18:24:44 Duration: 237ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 213ms 1 213ms 213ms 213ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 24 20 1 213ms 213ms [ User: a3dsupervisor - Total duration: 213ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 213ms - 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-24 18:24:45 Duration: 213ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 205ms 33 5ms 7ms 6ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 24 07 10 60ms 6ms 08 7 46ms 6ms 09 1 6ms 6ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 14 1 5ms 5ms 15 3 19ms 6ms 16 3 18ms 6ms 17 5 30ms 6ms [ User: a3dsupervisor - Total duration: 205ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 205ms - Times executed: 33 ]
-
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-24 06:23:18 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-24 13:55:30 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-24 06:14:04 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
19 193ms 1 193ms 193ms 193ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 24 20 1 193ms 193ms [ User: a3dsupervisor - Total duration: 193ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 193ms - Times executed: 1 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-24 18:24:45 Duration: 193ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 165ms 1 165ms 165ms 165ms 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 #20
Day Hour Count Duration Avg duration Oct 24 20 1 165ms 165ms [ User: a3dsupervisor - Total duration: 165ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 165ms - 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-24 18:24:45 Duration: 165ms 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 164 26ms 0ms 2ms 0ms select format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle from pg_catalog.pg_sequence where seqrelid = ?::oid;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 24 20 164 26ms 0ms [ User: a3dsupervisor - Total duration: 26ms - Times executed: 164 ]
[ Application: pg_dump - Total duration: 26ms - Times executed: 164 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2800421'::oid;
Date: 2025-10-24 18:17:59 Duration: 2ms 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 = '2800496'::oid;
Date: 2025-10-24 18:18:00 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 = '2800460'::oid;
Date: 2025-10-24 18:18:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 109 21ms 0ms 2ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 24 20 109 21ms 0ms [ User: a3dsupervisor - Total duration: 21ms - Times executed: 109 ]
[ Application: pg_dump - Total duration: 21ms - Times executed: 109 ]
-
EXECUTE dumpFunc ('2818849');
Date: 2025-10-24 18:17:59 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818912');
Date: 2025-10-24 18:17:59 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('2818867');
Date: 2025-10-24 18:17:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 33 469ms 12ms 19ms 14ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 24 07 10 141ms 14ms 08 7 107ms 15ms 09 1 15ms 15ms 10 1 13ms 13ms 11 1 13ms 13ms 12 1 18ms 18ms 14 1 13ms 13ms 15 3 41ms 13ms 16 3 40ms 13ms 17 5 64ms 12ms [ User: a3dsupervisor - Total duration: 469ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 469ms - Times executed: 33 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:05:38 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:30:15 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
4 33 295ms 6ms 19ms 8ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 24 07 10 87ms 8ms 08 7 77ms 11ms 09 1 16ms 16ms 10 1 7ms 7ms 11 1 7ms 7ms 12 1 8ms 8ms 14 1 7ms 7ms 15 3 23ms 7ms 16 3 21ms 7ms 17 5 38ms 7ms [ User: a3dsupervisor - Total duration: 295ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 295ms - Times executed: 33 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 06:42:09 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 05:05:38 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 06:30:15 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
5 33 272ms 6ms 18ms 8ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 24 07 10 69ms 6ms 08 7 88ms 12ms 09 1 11ms 11ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 14 1 6ms 6ms 15 3 21ms 7ms 16 3 20ms 6ms 17 5 34ms 6ms [ User: a3dsupervisor - Total duration: 272ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 272ms - Times executed: 33 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:23:18 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:31:03 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:30:15 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
6 33 205ms 5ms 7ms 6ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 24 07 10 60ms 6ms 08 7 46ms 6ms 09 1 6ms 6ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 14 1 5ms 5ms 15 3 19ms 6ms 16 3 18ms 6ms 17 5 30ms 6ms [ User: a3dsupervisor - Total duration: 205ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 205ms - Times executed: 33 ]
-
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-24 06:23:18 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-24 13:55:30 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-24 06:14:04 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
7 33 17ms 0ms 0ms 0ms select count(*) as database_nb_active_session from pg_stat_activity where upper(state) is not null and datname = and pid <> pg_backend_pid();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 24 07 10 5ms 0ms 08 7 3ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 3 2ms 0ms 16 3 1ms 0ms 17 5 2ms 0ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 33 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-10-24 12:02:31 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-10-24 13:55:30 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-10-24 13:55:21 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
8 33 9ms 0ms 2ms 0ms select version as application_release from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 24 07 10 3ms 0ms 08 7 3ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 5 0ms 0ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 9ms - Times executed: 33 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:05:37 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 2ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 07:22:53 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
9 33 7ms 0ms 0ms 0ms select count(*) as application_nb_user_not_anonymise from a3d_user where upper(user_login) not like ? and user_login not in (...) and user_login not like ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 24 07 10 2ms 0ms 08 7 2ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 5 1ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 33 ]
-
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-24 06:30:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-24 07:22:53 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-24 05:05:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
10 33 2ms 0ms 0ms 0ms select commentaire_version as application_last_comment from ( select commentaire_version from gtp_a3d_version where commentaire_version is not null order by date_version desc) fetch next ? rows only;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 24 07 10 0ms 0ms 08 7 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 5 0ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 33 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 14:38:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:42:53 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:33:35 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
11 19 1ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 24 20 19 1ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 19 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 19 ]
-
SELECT pg_catalog.format_type('16'::pg_catalog.oid, NULL);
Date: 2025-10-24 18:17:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2801266'::pg_catalog.oid, NULL);
Date: 2025-10-24 18:17:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2818836'::pg_catalog.oid, NULL);
Date: 2025-10-24 18:17:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 14 1ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 24 20 14 1ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 14 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 14 ]
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819023'::pg_catalog.oid);
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819015'::pg_catalog.oid);
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('2819022'::pg_catalog.oid);
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 6 3ms 0ms 1ms 0ms execute dumpcompositetype (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 24 20 6 3ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3ms - Times executed: 6 ]
-
EXECUTE dumpCompositeType ('2818836');
Date: 2025-10-24 18:17:59 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2818842');
Date: 2025-10-24 18:17:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2818839');
Date: 2025-10-24 18:17:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 6 2ms 0ms 1ms 0ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 24 20 6 2ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 2ms - Times executed: 6 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-24 18:17:58 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 3 8ms 1ms 4ms 2ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 24 20 3 8ms 2ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 8ms - Times executed: 3 ]
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-10-24 18:17:58 Duration: 4ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-10-24 18:18:01 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-10-24 18:18:01 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 3 1ms 0ms 1ms 0ms select pg_catalog.pg_is_in_recovery();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 24 20 3 1ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 3 ]
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-24 18:17:58 Duration: 1ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 3 0ms 0ms 0ms 0ms set transaction_timeout = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 24 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 3 ]
-
SET transaction_timeout = 0;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET transaction_timeout = 0;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET transaction_timeout = 0;
Date: 2025-10-24 18:17:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 3 0ms 0ms 0ms 0ms set datestyle = iso;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 24 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 3 ]
-
SET DATESTYLE = ISO;
Date: 2025-10-24 18:17:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 3 0ms 0ms 0ms 0ms set statement_timeout = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 24 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 3 ]
-
SET statement_timeout = 0;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-10-24 18:17:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 3 0ms 0ms 0ms 0ms set extra_float_digits to ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 24 20 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 3 ]
-
SET extra_float_digits TO 3;
Date: 2025-10-24 18:17:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET extra_float_digits TO 3;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET extra_float_digits TO 3;
Date: 2025-10-24 18:18:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 20s949ms 20s949ms 20s949ms 1 20s949ms 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 24 20 1 20s949ms 20s949ms [ User: a3dsupervisor - Total duration: 20s949ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s949ms - 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-24 18:23:55 Duration: 20s949ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 12s517ms 12s517ms 12s517ms 1 12s517ms 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 24 20 1 12s517ms 12s517ms [ User: a3dsupervisor - Total duration: 12s517ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 12s517ms - 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-24 18:24:08 Duration: 12s517ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 8s707ms 8s707ms 8s707ms 1 8s707ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 24 20 1 8s707ms 8s707ms [ User: a3dsupervisor - Total duration: 8s707ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s707ms - 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-24 18:24:16 Duration: 8s707ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 8s67ms 8s67ms 8s67ms 1 8s67ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 24 20 1 8s67ms 8s67ms [ User: a3dsupervisor - Total duration: 8s67ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s67ms - 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-24 18:24:25 Duration: 8s67ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 7s530ms 7s530ms 7s530ms 1 7s530ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 24 20 1 7s530ms 7s530ms [ User: a3dsupervisor - Total duration: 7s530ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s530ms - 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-24 18:24:32 Duration: 7s530ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 4s704ms 4s704ms 4s704ms 1 4s704ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 24 20 1 4s704ms 4s704ms [ User: a3dsupervisor - Total duration: 4s704ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4s704ms - 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-24 18:24:37 Duration: 4s704ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 1s251ms 1s251ms 1s251ms 1 1s251ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 24 20 1 1s251ms 1s251ms [ User: a3dsupervisor - Total duration: 1s251ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s251ms - 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-24 18:24:39 Duration: 1s251ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 993ms 993ms 993ms 1 993ms 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 24 20 1 993ms 993ms [ User: a3dsupervisor - Total duration: 993ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 993ms - 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-24 18:24:40 Duration: 993ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 980ms 980ms 980ms 1 980ms 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 #9
Day Hour Count Duration Avg duration Oct 24 20 1 980ms 980ms [ User: a3dsupervisor - Total duration: 980ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 980ms - 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-24 18:24:41 Duration: 980ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 920ms 920ms 920ms 1 920ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 24 20 1 920ms 920ms [ User: a3dsupervisor - Total duration: 920ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 920ms - 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-24 18:24:42 Duration: 920ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 593ms 593ms 593ms 1 593ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 24 20 1 593ms 593ms [ User: a3dsupervisor - Total duration: 593ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 593ms - 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-24 18:24:43 Duration: 593ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 465ms 465ms 465ms 1 465ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 24 20 1 465ms 465ms [ User: a3dsupervisor - Total duration: 465ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 465ms - 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-24 18:24:46 Duration: 465ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 237ms 237ms 237ms 1 237ms 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 24 20 1 237ms 237ms [ User: a3dsupervisor - Total duration: 237ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 237ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-24 18:24:44 Duration: 237ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 213ms 213ms 213ms 1 213ms 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 #14
Day Hour Count Duration Avg duration Oct 24 20 1 213ms 213ms [ User: a3dsupervisor - Total duration: 213ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 213ms - 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-24 18:24:45 Duration: 213ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 193ms 193ms 193ms 1 193ms copy public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 24 20 1 193ms 193ms [ User: a3dsupervisor - Total duration: 193ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 193ms - Times executed: 1 ]
-
COPY public.l_notification_user (nous_user_num_id, nous_noti_id, nous_read) TO stdout;
Date: 2025-10-24 18:24:45 Duration: 193ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 165ms 165ms 165ms 1 165ms copy public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 24 20 1 165ms 165ms [ User: a3dsupervisor - Total duration: 165ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 165ms - 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-24 18:24:45 Duration: 165ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 12ms 19ms 14ms 33 469ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 24 07 10 141ms 14ms 08 7 107ms 15ms 09 1 15ms 15ms 10 1 13ms 13ms 11 1 13ms 13ms 12 1 18ms 18ms 14 1 13ms 13ms 15 3 41ms 13ms 16 3 40ms 13ms 17 5 64ms 12ms [ User: a3dsupervisor - Total duration: 469ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 469ms - Times executed: 33 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:05:38 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:30:15 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
18 6ms 19ms 8ms 33 295ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 24 07 10 87ms 8ms 08 7 77ms 11ms 09 1 16ms 16ms 10 1 7ms 7ms 11 1 7ms 7ms 12 1 8ms 8ms 14 1 7ms 7ms 15 3 23ms 7ms 16 3 21ms 7ms 17 5 38ms 7ms [ User: a3dsupervisor - Total duration: 295ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 295ms - Times executed: 33 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 06:42:09 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 05:05:38 Duration: 19ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-10-24 06:30:15 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
19 6ms 18ms 8ms 33 272ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 24 07 10 69ms 6ms 08 7 88ms 12ms 09 1 11ms 11ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 14 1 6ms 6ms 15 3 21ms 7ms 16 3 20ms 6ms 17 5 34ms 6ms [ User: a3dsupervisor - Total duration: 272ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 272ms - Times executed: 33 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:23:18 Duration: 18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:31:03 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-10-24 06:30:15 Duration: 13ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
20 5ms 7ms 6ms 33 205ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 24 07 10 60ms 6ms 08 7 46ms 6ms 09 1 6ms 6ms 10 1 6ms 6ms 11 1 6ms 6ms 12 1 6ms 6ms 14 1 5ms 5ms 15 3 19ms 6ms 16 3 18ms 6ms 17 5 30ms 6ms [ User: a3dsupervisor - Total duration: 205ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 205ms - Times executed: 33 ]
-
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-24 06:23:18 Duration: 7ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-24 13:55:30 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-24 06:14:04 Duration: 6ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 157ms 33 1ms 28ms 4ms 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 24 07 10 42ms 4ms 08 7 64ms 9ms 09 1 26ms 26ms 10 1 1ms 1ms 11 1 1ms 1ms 12 1 1ms 1ms 14 1 1ms 1ms 15 3 5ms 1ms 16 3 4ms 1ms 17 5 7ms 1ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 33 ]
-
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-24 06:42:09 Duration: 28ms 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-24 05:05:37 Duration: 27ms 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-24 06:30:15 Duration: 26ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 72ms 33 0ms 14ms 2ms 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 #2
Day Hour Count Duration Avg duration 05 10 17ms 1ms 06 7 30ms 4ms 07 1 12ms 12ms 08 1 0ms 0ms 09 1 1ms 1ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 2ms 0ms 14 3 2ms 0ms 15 5 3ms 0ms [ User: a3dsupervisor - Total duration: 295ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 295ms - Times executed: 33 ]
-
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-24 06:42:09 Duration: 14ms 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-24 07:22:53 Duration: 12ms 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-24 06:30:15 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 58ms 33 0ms 11ms 1ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 05 10 14ms 1ms 06 7 25ms 3ms 07 1 11ms 11ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 1ms 0ms 14 3 1ms 0ms 15 5 2ms 0ms [ User: a3dsupervisor - Total duration: 272ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 272ms - Times executed: 33 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-24 06:42:09 Duration: 11ms 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-24 06:30:15 Duration: 11ms 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-24 07:22:53 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 30ms 33 0ms 4ms 0ms 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 #4
Day Hour Count Duration Avg duration 05 10 6ms 0ms 06 7 12ms 1ms 07 1 3ms 3ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 1ms 0ms 14 3 1ms 0ms 15 5 2ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 33 ]
-
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-24 06:42:09 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-24 06:30:15 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-24 07:22:53 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 26ms 33 0ms 6ms 0ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 05 10 5ms 0ms 06 7 10ms 1ms 07 1 6ms 6ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 5 1ms 0ms [ User: a3dsupervisor - Total duration: 205ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 205ms - Times executed: 33 ]
-
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-24 07:22:53 Duration: 6ms 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-24 06:30:15 Duration: 5ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-10-24 06:42:09 Duration: 4ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 21ms 33 0ms 3ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 05 10 5ms 0ms 06 7 8ms 1ms 07 1 2ms 2ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 1ms 0ms 14 3 1ms 0ms 15 5 1ms 0ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 9ms - Times executed: 33 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 07:22:53 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:30:15 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 16ms 33 0ms 2ms 0ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 05 10 2ms 0ms 06 7 7ms 1ms 07 1 2ms 2ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 5 1ms 0ms [ User: a3dsupervisor - Total duration: 469ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 469ms - Times executed: 33 ]
-
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-24 06:30:15 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-24 07:22:53 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-24 06:42:09 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 2ms 33 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 05 10 0ms 0ms 06 7 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 5 0ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 33 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:42:53 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 13:55:48 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 86ms 33 0ms 14ms 2ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 24 07 10 23ms 2ms 08 7 33ms 4ms 09 1 14ms 14ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 3 2ms 0ms 16 3 2ms 0ms 17 5 4ms 0ms [ User: a3dsupervisor - Total duration: 295ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 295ms - Times executed: 33 ]
-
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-24 07:22:53 Duration: 14ms 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-24 05:05:37 Duration: 14ms 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-24 06:42:09 Duration: 14ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
2 77ms 33 0ms 15ms 2ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 05 10 21ms 2ms 06 7 30ms 4ms 07 1 11ms 11ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 1ms 1ms 13 3 2ms 0ms 14 3 2ms 0ms 15 5 4ms 0ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 33 ]
-
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-24 06:42:09 Duration: 15ms 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-24 05:05:37 Duration: 13ms 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-24 07:22:53 Duration: 11ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 46ms 33 0ms 11ms 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 bind #3
Day Hour Count Duration Avg duration 05 10 9ms 0ms 06 7 21ms 3ms 07 1 7ms 7ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 1ms 0ms 14 3 1ms 0ms 15 5 2ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 33 ]
-
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-24 06:30:15 Duration: 11ms 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-24 07:22:53 Duration: 7ms 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-24 06:42:09 Duration: 6ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 43ms 33 0ms 9ms 1ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 05 10 12ms 1ms 06 7 18ms 2ms 07 1 6ms 6ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 1ms 0ms 14 3 1ms 0ms 15 5 1ms 0ms [ User: a3dsupervisor - Total duration: 469ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 469ms - Times executed: 33 ]
-
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-24 05:05:38 Duration: 9ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-24 06:30:15 Duration: 7ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-10-24 06:42:09 Duration: 7ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 15ms 33 0ms 3ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 05 10 3ms 0ms 06 7 6ms 0ms 07 1 1ms 1ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 5 0ms 0ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 9ms - Times executed: 33 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 3ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:05:37 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:30:15 Duration: 2ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 9ms 33 0ms 0ms 0ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 05 10 2ms 0ms 06 7 3ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 5 1ms 0ms [ User: a3dsupervisor - Total duration: 205ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 205ms - Times executed: 33 ]
-
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-24 07:22:53 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-24 05:05:38 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-24 06:42:09 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 4ms 33 0ms 0ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 05 10 1ms 0ms 06 7 1ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 5 0ms 0ms [ User: a3dsupervisor - Total duration: 272ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 272ms - Times executed: 33 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-24 06:30:15 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-24 14:38:49 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-24 05:33:35 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 4ms 33 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 05 10 1ms 0ms 06 7 1ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 5 0ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 33 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 33 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:42:09 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 06:23:39 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-24 05:19:16 Duration: 0ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
Events
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET