pgBadger-
Global information
- Generated on Mon Sep 22 15:55:32 2025
- Log file: ././A3D-RND-REF/y=2025/m=09/d=19/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=09/d=19/h=23/m=00/PT1H.log
- Parsed 625,591 log entries in 7m6s
- Log start from 2025-09-19 00:02:20 to 2025-09-19 23:35:31
-
Overview
Global Stats
- 749 Number of unique normalized queries
- 1,675 Number of queries
- 2m51s Total query duration
- 2025-09-19 00:02:20 First query
- 2025-09-19 23:35:31 Last query
- 189 queries/s at 2025-09-19 06:19:19 Query peak
- 2m51s Total query duration
- 649ms Prepare/parse total duration
- 548ms Bind total duration
- 2m50s 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
- 1 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 122 Total number of sessions
- 2 sessions at 2025-09-19 09:13:38 Session peak
- 1h38m16s Total duration of sessions
- 48s327ms Average duration of sessions
- 13 Average queries per session
- 1s406ms Average queries duration per session
- 46s921ms Average idle time per session
- 122 Total number of connections
- 3 connections/s at 2025-09-19 12:32:45 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 189 queries/s Query Peak
- 2025-09-19 06:19:19 Date
SELECT Traffic
Key values
- 185 queries/s Query Peak
- 2025-09-19 06:19:19 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 54 queries/s Query Peak
- 2025-09-19 06:51:26 Date
Queries duration
Key values
- 2m51s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 6 0ms 5ms 1ms 5ms 5ms 5ms 01 6 0ms 5ms 1ms 5ms 5ms 5ms 02 6 0ms 5ms 1ms 5ms 5ms 5ms 03 6 0ms 6ms 1ms 6ms 6ms 6ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 5ms 1ms 7ms 7ms 7ms 06 1,109 0ms 37s819ms 147ms 549ms 41s742ms 1m51s 07 46 0ms 68ms 15ms 317ms 317ms 317ms 08 22 0ms 55ms 12ms 134ms 134ms 134ms 09 126 0ms 70ms 15ms 272ms 526ms 526ms 10 146 0ms 67ms 15ms 271ms 538ms 538ms 11 6 0ms 10ms 3ms 10ms 10ms 10ms 12 43 0ms 81ms 14ms 198ms 198ms 198ms 13 63 0ms 58ms 15ms 408ms 408ms 408ms 14 14 0ms 54ms 10ms 138ms 138ms 138ms 15 6 0ms 6ms 2ms 7ms 7ms 7ms 16 16 0ms 75ms 12ms 188ms 188ms 188ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 2ms 7ms 7ms 7ms 19 6 0ms 5ms 1ms 5ms 5ms 5ms 20 6 0ms 4ms 1ms 4ms 4ms 4ms 21 6 0ms 4ms 1ms 4ms 4ms 4ms 22 6 0ms 5ms 1ms 5ms 5ms 5ms 23 6 0ms 4ms 1ms 5ms 5ms 5ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 3 0 3ms 5ms 5ms 5ms 01 3 0 3ms 5ms 5ms 5ms 02 3 0 3ms 5ms 5ms 5ms 03 3 0 3ms 6ms 6ms 6ms 04 3 0 3ms 4ms 4ms 4ms 05 3 0 3ms 6ms 6ms 6ms 06 436 245 239ms 0ms 503ms 1m51s 07 43 0 17ms 137ms 317ms 317ms 08 19 0 14ms 134ms 134ms 134ms 09 123 0 15ms 147ms 272ms 526ms 10 143 0 15ms 266ms 271ms 538ms 11 3 0 6ms 10ms 10ms 10ms 12 40 0 15ms 142ms 198ms 198ms 13 60 0 15ms 408ms 408ms 408ms 14 11 0 13ms 138ms 138ms 138ms 15 3 0 4ms 7ms 7ms 7ms 16 13 0 15ms 188ms 188ms 188ms 17 3 0 3ms 4ms 4ms 4ms 18 3 0 4ms 6ms 6ms 6ms 19 3 0 3ms 5ms 5ms 5ms 20 3 0 3ms 4ms 4ms 4ms 21 3 0 3ms 4ms 4ms 4ms 22 3 0 3ms 5ms 5ms 5ms 23 3 0 3ms 5ms 5ms 5ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 19 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 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 11 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 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 19 00 6 6 1.00 200.00% 01 6 6 1.00 200.00% 02 6 6 1.00 200.00% 03 6 6 1.00 200.00% 04 6 6 1.00 200.00% 05 6 6 1.00 200.00% 06 9 144 16.00 1.31% 07 46 46 1.00 106.98% 08 22 22 1.00 115.79% 09 126 126 1.00 102.44% 10 146 146 1.00 102.10% 11 6 6 1.00 200.00% 12 43 43 1.00 107.50% 13 63 63 1.00 105.00% 14 14 14 1.00 127.27% 15 6 6 1.00 200.00% 16 16 16 1.00 123.08% 17 6 6 1.00 200.00% 18 6 6 1.00 200.00% 19 6 6 1.00 200.00% 20 6 6 1.00 200.00% 21 6 6 1.00 200.00% 22 6 6 1.00 200.00% 23 6 6 1.00 200.00% Day Hour Count Average / Second Sep 19 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 5 0.00/s 07 7 0.00/s 08 4 0.00/s 09 24 0.01/s 10 23 0.01/s 11 2 0.00/s 12 11 0.00/s 13 10 0.00/s 14 3 0.00/s 15 2 0.00/s 16 5 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Sep 19 00 2 72ms 67ms 01 2 74ms 69ms 02 2 73ms 68ms 03 2 76ms 70ms 04 2 68ms 63ms 05 2 75ms 69ms 06 5 19m33s 19m1s 07 7 338ms 233ms 08 4 233ms 163ms 09 24 272ms 193ms 10 23 316ms 217ms 11 2 133ms 123ms 12 11 212ms 157ms 13 10 313ms 218ms 14 3 191ms 141ms 15 2 104ms 97ms 16 5 164ms 124ms 17 2 78ms 73ms 18 2 104ms 97ms 19 2 72ms 67ms 20 2 74ms 69ms 21 2 71ms 66ms 22 2 70ms 65ms 23 2 71ms 66ms -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2025-09-19 12:32:45 Date
Connections per database
Key values
- cnrs Main Database
- 122 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 122 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2025-09-19 09:13:38 Date
Histogram of session times
Key values
- 117 0-500ms duration
Sessions per database
Key values
- cnrs Main Database
- 122 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 122 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 122 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 19 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- pg_catalog.pg_shdepend (1) Main table analyzed (database cnrs)
- 1 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 19 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 1 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 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
- 933 Total read queries
- 249 Total write queries
Queries by database
Key values
- cnrs Main database
- 1,675 Requests
- 2m50s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 1,531 Requests
User Request type Count Duration a3dsupervisor Total 1,531 2m50s copy to 245 2m42s cte 1 8ms others 421 147ms select 861 7s519ms tcl 3 0ms azuresu Total 144 260ms others 72 4ms select 72 256ms Duration by user
Key values
- 2m50s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 1,531 2m50s copy to 245 2m42s cte 1 8ms others 421 147ms select 861 7s519ms tcl 3 0ms azuresu Total 144 260ms others 72 4ms select 72 256ms Queries by host
Key values
- 10.3.0.4 Main host
- 1,531 Requests
- 2m50s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 1,103 Requests
- 2m43s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-19 06:47:22 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,200 0-1ms duration
Slowest individual queries
Rank Duration Query 1 37s819ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2025-09-19 06:51:56 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 28s339ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-09-19 06:51:17 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 25s631ms COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;[ Date: 2025-09-19 06:50:41 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 20s30ms COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;[ Date: 2025-09-19 06:51:03 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 15s335ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-09-19 06:51:22 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 15s227ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-09-19 06:50:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 8s726ms 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-09-19 06:49:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 2s358ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-19 06:51:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 1s642ms COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;[ Date: 2025-09-19 06:51:28 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 1s61ms COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;[ Date: 2025-09-19 06:51:05 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 741ms COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;[ Date: 2025-09-19 06:51:26 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 693ms COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;[ Date: 2025-09-19 06:51:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 684ms COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;[ Date: 2025-09-19 06:51:22 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 417ms COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;[ Date: 2025-09-19 06:50:42 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 286ms COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;[ Date: 2025-09-19 06:51:29 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 286ms COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;[ Date: 2025-09-19 06:51:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 208ms COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;[ Date: 2025-09-19 06:49:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 192ms COPY public.pe_consumption_daily (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, invoice_line_id) TO stdout;[ Date: 2025-09-19 06:51:29 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 182ms COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;[ Date: 2025-09-19 06:51:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 179ms COPY public.gtp_history_obj_concerned (action_num_id, obj_num_id) TO stdout;[ Date: 2025-09-19 06:51:03 - Database: cnrs - 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 37s819ms 1 37s819ms 37s819ms 37s819ms 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 #1
Day Hour Count Duration Avg duration Sep 19 08 1 37s819ms 37s819ms [ User: a3dsupervisor - Total duration: 37s819ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 37s819ms - 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-09-19 06:51:56 Duration: 37s819ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 28s339ms 1 28s339ms 28s339ms 28s339ms 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 #2
Day Hour Count Duration Avg duration Sep 19 08 1 28s339ms 28s339ms [ User: a3dsupervisor - Total duration: 28s339ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s339ms - 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-09-19 06:51:17 Duration: 28s339ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 25s631ms 1 25s631ms 25s631ms 25s631ms 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 #3
Day Hour Count Duration Avg duration Sep 19 08 1 25s631ms 25s631ms [ User: a3dsupervisor - Total duration: 25s631ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 25s631ms - 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-09-19 06:50:41 Duration: 25s631ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 20s30ms 1 20s30ms 20s30ms 20s30ms 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 #4
Day Hour Count Duration Avg duration Sep 19 08 1 20s30ms 20s30ms [ User: a3dsupervisor - Total duration: 20s30ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s30ms - 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-09-19 06:51:03 Duration: 20s30ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 15s335ms 1 15s335ms 15s335ms 15s335ms 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 #5
Day Hour Count Duration Avg duration Sep 19 08 1 15s335ms 15s335ms [ User: a3dsupervisor - Total duration: 15s335ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s335ms - 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-09-19 06:51:22 Duration: 15s335ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 15s227ms 1 15s227ms 15s227ms 15s227ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 08 1 15s227ms 15s227ms [ User: a3dsupervisor - Total duration: 15s227ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s227ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-19 06:50:15 Duration: 15s227ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 8s726ms 1 8s726ms 8s726ms 8s726ms 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 #7
Day Hour Count Duration Avg duration Sep 19 08 1 8s726ms 8s726ms [ User: a3dsupervisor - Total duration: 8s726ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s726ms - 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-09-19 06:49:58 Duration: 8s726ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 2s836ms 51 53ms 70ms 55ms 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 #8
Day Hour Count Duration Avg duration Sep 19 09 5 268ms 53ms 10 2 110ms 55ms 11 14 779ms 55ms 12 17 937ms 55ms 14 4 229ms 57ms 15 7 395ms 56ms 16 1 54ms 54ms 18 1 61ms 61ms [ User: a3dsupervisor - Total duration: 2s836ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s836ms - Times executed: 51 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:35:32 Duration: 70ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 10:31:11 Duration: 67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 12:00:07 Duration: 65ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
9 2s358ms 1 2s358ms 2s358ms 2s358ms 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 #9
Day Hour Count Duration Avg duration Sep 19 08 1 2s358ms 2s358ms [ User: a3dsupervisor - Total duration: 2s358ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2s358ms - 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-09-19 06:51:25 Duration: 2s358ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 2s39ms 51 38ms 45ms 39ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 19 09 5 203ms 40ms 10 2 79ms 39ms 11 14 558ms 39ms 12 17 673ms 39ms 14 4 159ms 39ms 15 7 283ms 40ms 16 1 42ms 42ms 18 1 39ms 39ms [ User: a3dsupervisor - Total duration: 2s39ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s39ms - Times executed: 51 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 09:53:56 Duration: 45ms Database: cnrs 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-09-19 13:20:48 Duration: 42ms Database: cnrs 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-09-19 14:45:42 Duration: 42ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
11 1s720ms 51 28ms 81ms 33ms 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 #11
Day Hour Count Duration Avg duration Sep 19 09 5 190ms 38ms 10 2 64ms 32ms 11 14 430ms 30ms 12 17 536ms 31ms 14 4 173ms 43ms 15 7 215ms 30ms 16 1 34ms 34ms 18 1 75ms 75ms [ User: a3dsupervisor - Total duration: 1s720ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 1s720ms - Times executed: 51 ]
-
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-09-19 12:00:06 Duration: 81ms Database: cnrs 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-09-19 16:41:14 Duration: 75ms Database: cnrs 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-09-19 07:17:19 Duration: 68ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
12 1s642ms 1 1s642ms 1s642ms 1s642ms 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 #12
Day Hour Count Duration Avg duration Sep 19 08 1 1s642ms 1s642ms [ User: a3dsupervisor - Total duration: 1s642ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s642ms - 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-09-19 06:51:28 Duration: 1s642ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 1s61ms 1 1s61ms 1s61ms 1s61ms copy public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 19 08 1 1s61ms 1s61ms [ User: a3dsupervisor - Total duration: 1s61ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s61ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-19 06:51:05 Duration: 1s61ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 741ms 1 741ms 741ms 741ms copy public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 19 08 1 741ms 741ms [ User: a3dsupervisor - Total duration: 741ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 741ms - Times executed: 1 ]
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-19 06:51:26 Duration: 741ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 693ms 1 693ms 693ms 693ms 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 #15
Day Hour Count Duration Avg duration Sep 19 08 1 693ms 693ms [ User: a3dsupervisor - Total duration: 693ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 693ms - 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-09-19 06:51:04 Duration: 693ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 684ms 1 684ms 684ms 684ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 08 1 684ms 684ms [ User: a3dsupervisor - Total duration: 684ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 684ms - 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-09-19 06:51:22 Duration: 684ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 417ms 1 417ms 417ms 417ms 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 #17
Day Hour Count Duration Avg duration Sep 19 08 1 417ms 417ms [ User: a3dsupervisor - Total duration: 417ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 417ms - 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-09-19 06:50:42 Duration: 417ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 334ms 51 5ms 12ms 6ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 09 5 47ms 9ms 10 2 11ms 5ms 11 14 90ms 6ms 12 17 103ms 6ms 14 4 24ms 6ms 15 7 41ms 5ms 16 1 5ms 5ms 18 1 8ms 8ms [ User: a3dsupervisor - Total duration: 334ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 334ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:41:30 Duration: 12ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:19 Duration: 11ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:51 Duration: 11ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
19 286ms 1 286ms 286ms 286ms 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 #19
Day Hour Count Duration Avg duration Sep 19 08 1 286ms 286ms [ User: a3dsupervisor - Total duration: 286ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 286ms - 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-09-19 06:51:29 Duration: 286ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 286ms 1 286ms 286ms 286ms copy public.gtp_log (log_date, log_type, log_info, log_release, log_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 08 1 286ms 286ms [ User: a3dsupervisor - Total duration: 286ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 286ms - Times executed: 1 ]
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-09-19 06:51:06 Duration: 286ms Database: cnrs 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 27ms 0ms 1ms 0ms select format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle from pg_catalog.pg_sequence where seqrelid = ?::oid;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 19 08 164 27ms 0ms [ User: a3dsupervisor - Total duration: 27ms - Times executed: 164 ]
[ Application: pg_dump - Total duration: 27ms - Times executed: 164 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2648852'::oid;
Date: 2025-09-19 06:19:19 Duration: 1ms Database: cnrs 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 = '2466660'::oid;
Date: 2025-09-19 06:19:19 Duration: 1ms Database: cnrs 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 = '2466640'::oid;
Date: 2025-09-19 06:19:19 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 126 25ms 0ms 3ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 19 08 126 25ms 0ms [ User: a3dsupervisor - Total duration: 25ms - Times executed: 126 ]
[ Application: pg_dump - Total duration: 25ms - Times executed: 126 ]
-
EXECUTE dumpFunc ('16579');
Date: 2025-09-19 06:19:18 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('6004');
Date: 2025-09-19 06:19:18 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('16538');
Date: 2025-09-19 06:19:18 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 72 4ms 0ms 0ms 0ms set session statement_timeout to ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 19 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 3 0ms 0ms 00 3 0ms 0ms 01 3 0ms 0ms [ User: azuresu - Total duration: 4ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 72 ]
-
set session statement_timeout to 60000;
Date: 2025-09-19 05:32:39 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 120000;
Date: 2025-09-19 16:35:07 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 60000;
Date: 2025-09-19 07:02:45 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 51 2s836ms 53ms 70ms 55ms 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 #4
Day Hour Count Duration Avg duration Sep 19 09 5 268ms 53ms 10 2 110ms 55ms 11 14 779ms 55ms 12 17 937ms 55ms 14 4 229ms 57ms 15 7 395ms 56ms 16 1 54ms 54ms 18 1 61ms 61ms [ User: a3dsupervisor - Total duration: 2s836ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s836ms - Times executed: 51 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:35:32 Duration: 70ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 10:31:11 Duration: 67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 12:00:07 Duration: 65ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
5 51 2s39ms 38ms 45ms 39ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 19 09 5 203ms 40ms 10 2 79ms 39ms 11 14 558ms 39ms 12 17 673ms 39ms 14 4 159ms 39ms 15 7 283ms 40ms 16 1 42ms 42ms 18 1 39ms 39ms [ User: a3dsupervisor - Total duration: 2s39ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s39ms - Times executed: 51 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 09:53:56 Duration: 45ms Database: cnrs 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-09-19 13:20:48 Duration: 42ms Database: cnrs 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-09-19 14:45:42 Duration: 42ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
6 51 1s720ms 28ms 81ms 33ms 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 #6
Day Hour Count Duration Avg duration Sep 19 09 5 190ms 38ms 10 2 64ms 32ms 11 14 430ms 30ms 12 17 536ms 31ms 14 4 173ms 43ms 15 7 215ms 30ms 16 1 34ms 34ms 18 1 75ms 75ms [ User: a3dsupervisor - Total duration: 1s720ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 1s720ms - Times executed: 51 ]
-
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-09-19 12:00:06 Duration: 81ms Database: cnrs 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-09-19 16:41:14 Duration: 75ms Database: cnrs 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-09-19 07:17:19 Duration: 68ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
7 51 334ms 5ms 12ms 6ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 19 09 5 47ms 9ms 10 2 11ms 5ms 11 14 90ms 6ms 12 17 103ms 6ms 14 4 24ms 6ms 15 7 41ms 5ms 16 1 5ms 5ms 18 1 8ms 8ms [ User: a3dsupervisor - Total duration: 334ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 334ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:41:30 Duration: 12ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:19 Duration: 11ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:51 Duration: 11ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
8 51 34ms 0ms 2ms 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 #8
Day Hour Count Duration Avg duration Sep 19 09 5 4ms 0ms 10 2 1ms 0ms 11 14 8ms 0ms 12 17 9ms 0ms 14 4 4ms 1ms 15 7 2ms 0ms 16 1 0ms 0ms 18 1 2ms 2ms [ User: a3dsupervisor - Total duration: 34ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 34ms - Times executed: 51 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 12:00:06 Duration: 2ms Database: cnrs 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-09-19 16:41:14 Duration: 2ms Database: cnrs 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-09-19 07:17:19 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
9 51 32ms 0ms 5ms 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 #9
Day Hour Count Duration Avg duration Sep 19 09 5 2ms 0ms 10 2 1ms 0ms 11 14 7ms 0ms 12 17 8ms 0ms 14 4 6ms 1ms 15 7 3ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms [ User: a3dsupervisor - Total duration: 32ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 32ms - Times executed: 51 ]
-
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-09-19 12:32:37 Duration: 5ms Database: cnrs 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-09-19 09:57:31 Duration: 0ms Database: cnrs 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-09-19 13:20:26 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
10 51 10ms 0ms 1ms 0ms select version as application_release from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 19 09 5 1ms 0ms 10 2 0ms 0ms 11 14 2ms 0ms 12 17 4ms 0ms 14 4 1ms 0ms 15 7 1ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 51 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 10:15:06 Duration: 1ms Database: cnrs 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-09-19 07:17:19 Duration: 0ms Database: cnrs 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-09-19 12:00:06 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
11 51 3ms 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 #11
Day Hour Count Duration Avg duration Sep 19 09 5 0ms 0ms 10 2 0ms 0ms 11 14 0ms 0ms 12 17 1ms 0ms 14 4 0ms 0ms 15 7 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 51 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 14:45:42 Duration: 0ms Database: cnrs 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-09-19 10:03:17 Duration: 0ms Database: cnrs 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-09-19 10:29:06 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
12 48 251ms 4ms 10ms 5ms select schemaname, sum(n_live_tup) as n_live_tup, sum(n_dead_tup) as n_dead_tup, sum(seq_scan) as seq_scan, sum(seq_tup_read) as seq_tup_read, sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as idx_tup_fetch, sum(n_tup_ins) as n_tup_ins, sum(n_tup_upd) as n_tup_upd, sum(n_tup_del) as n_tup_del, sum(n_tup_hot_upd) as n_tup_hot_upd, sum(n_mod_since_analyze) as n_mod_since_analyze, sum(vacuum_count) as vacuum_count, sum(autovacuum_count) as autovacuum_count, sum(analyze_count) as analyze_count, sum(autoanalyze_count) as autoanalyze_count, count(relid) as tables_counter, sum( case when last_vacuum is not null then ? else ? end)::bigint as tables_vacuumed, sum( case when last_autovacuum is not null then ? else ? end)::bigint as tables_autovacuumed, sum( case when last_analyze is not null then ? else ? end)::bigint as tables_analyzed, sum( case when last_autoanalyze is not null then ? else ? end)::bigint as tables_autoanalyzed from pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 19 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 11ms 5ms 06 2 9ms 4ms 07 2 10ms 5ms 08 2 12ms 6ms 09 2 12ms 6ms 10 2 9ms 4ms 11 2 14ms 7ms 12 2 8ms 4ms 13 2 18ms 9ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 8ms 4ms 17 2 12ms 6ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 12ms 6ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 9ms 4ms 01 2 9ms 4ms [ User: azuresu - Total duration: 251ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 251ms - Times executed: 48 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 11:04:47 Duration: 10ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 09:02:52 Duration: 9ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 11:34:49 Duration: 8ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
13 24 4ms 0ms 1ms 0ms select extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition from pg_catalog.pg_extension;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 19 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 1ms 1ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms [ User: azuresu - Total duration: 4ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 24 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 15:35:03 Duration: 1ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 07:32:47 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 06:32:42 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
14 22 2ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 19 08 22 2ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 22 ]
[ Application: pg_dump - Total duration: 2ms - Times executed: 22 ]
-
SELECT pg_catalog.format_type('2465531'::pg_catalog.oid, NULL);
Date: 2025-09-19 06:19:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('3802'::pg_catalog.oid, NULL);
Date: 2025-09-19 06:19:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2465423'::pg_catalog.oid, NULL);
Date: 2025-09-19 06:19:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 20 4ms 0ms 0ms 0ms select version from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 19 11 8 1ms 0ms 12 4 1ms 0ms 14 5 0ms 0ms 15 1 0ms 0ms 18 2 0ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 20 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 16:15:39 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 10:01:44 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:44:55 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
16 14 1ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 08 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 ('17218'::pg_catalog.oid);
Date: 2025-09-19 06:19:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17219'::pg_catalog.oid);
Date: 2025-09-19 06:19:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17220'::pg_catalog.oid);
Date: 2025-09-19 06:19:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 6 3ms 0ms 1ms 0ms execute dumpcompositetype (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 19 08 6 3ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3ms - Times executed: 6 ]
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-09-19 06:19:18 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465426');
Date: 2025-09-19 06:19:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465429');
Date: 2025-09-19 06:19:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 6 3ms 0ms 1ms 0ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 19 08 6 3ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3ms - Times executed: 6 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-19 06:19:20 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-19 06:19:17 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-19 06:19:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 6 3ms 0ms 1ms 0ms execute getcolumnacls (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 19 08 6 3ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3ms - Times executed: 6 ]
-
EXECUTE getColumnACLs ('12339');
Date: 2025-09-19 06:19:19 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('12130');
Date: 2025-09-19 06:19:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('12114');
Date: 2025-09-19 06:19:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 3 6ms 1ms 2ms 2ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 08 3 6ms 2ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 6ms - Times executed: 3 ]
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-09-19 06:19:21 Duration: 2ms Database: cnrs 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-09-19 06:19:17 Duration: 2ms Database: cnrs 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-09-19 06:19:21 Duration: 1ms Database: cnrs 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 37s819ms 37s819ms 37s819ms 1 37s819ms 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 #1
Day Hour Count Duration Avg duration Sep 19 08 1 37s819ms 37s819ms [ User: a3dsupervisor - Total duration: 37s819ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 37s819ms - 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-09-19 06:51:56 Duration: 37s819ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 28s339ms 28s339ms 28s339ms 1 28s339ms 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 #2
Day Hour Count Duration Avg duration Sep 19 08 1 28s339ms 28s339ms [ User: a3dsupervisor - Total duration: 28s339ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 28s339ms - 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-09-19 06:51:17 Duration: 28s339ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 25s631ms 25s631ms 25s631ms 1 25s631ms 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 #3
Day Hour Count Duration Avg duration Sep 19 08 1 25s631ms 25s631ms [ User: a3dsupervisor - Total duration: 25s631ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 25s631ms - 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-09-19 06:50:41 Duration: 25s631ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 20s30ms 20s30ms 20s30ms 1 20s30ms 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 #4
Day Hour Count Duration Avg duration Sep 19 08 1 20s30ms 20s30ms [ User: a3dsupervisor - Total duration: 20s30ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s30ms - 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-09-19 06:51:03 Duration: 20s30ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 15s335ms 15s335ms 15s335ms 1 15s335ms 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 #5
Day Hour Count Duration Avg duration Sep 19 08 1 15s335ms 15s335ms [ User: a3dsupervisor - Total duration: 15s335ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s335ms - 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-09-19 06:51:22 Duration: 15s335ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 15s227ms 15s227ms 15s227ms 1 15s227ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 19 08 1 15s227ms 15s227ms [ User: a3dsupervisor - Total duration: 15s227ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s227ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-19 06:50:15 Duration: 15s227ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 8s726ms 8s726ms 8s726ms 1 8s726ms 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 #7
Day Hour Count Duration Avg duration Sep 19 08 1 8s726ms 8s726ms [ User: a3dsupervisor - Total duration: 8s726ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s726ms - 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-09-19 06:49:58 Duration: 8s726ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 2s358ms 2s358ms 2s358ms 1 2s358ms 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 #8
Day Hour Count Duration Avg duration Sep 19 08 1 2s358ms 2s358ms [ User: a3dsupervisor - Total duration: 2s358ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2s358ms - 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-09-19 06:51:25 Duration: 2s358ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1s642ms 1s642ms 1s642ms 1 1s642ms 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 #9
Day Hour Count Duration Avg duration Sep 19 08 1 1s642ms 1s642ms [ User: a3dsupervisor - Total duration: 1s642ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s642ms - 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-09-19 06:51:28 Duration: 1s642ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 1s61ms 1s61ms 1s61ms 1 1s61ms copy public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 19 08 1 1s61ms 1s61ms [ User: a3dsupervisor - Total duration: 1s61ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s61ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-19 06:51:05 Duration: 1s61ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 741ms 741ms 741ms 1 741ms copy public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 19 08 1 741ms 741ms [ User: a3dsupervisor - Total duration: 741ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 741ms - Times executed: 1 ]
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-19 06:51:26 Duration: 741ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 693ms 693ms 693ms 1 693ms 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 #12
Day Hour Count Duration Avg duration Sep 19 08 1 693ms 693ms [ User: a3dsupervisor - Total duration: 693ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 693ms - 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-09-19 06:51:04 Duration: 693ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 684ms 684ms 684ms 1 684ms 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 #13
Day Hour Count Duration Avg duration Sep 19 08 1 684ms 684ms [ User: a3dsupervisor - Total duration: 684ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 684ms - 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-09-19 06:51:22 Duration: 684ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 417ms 417ms 417ms 1 417ms 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 #14
Day Hour Count Duration Avg duration Sep 19 08 1 417ms 417ms [ User: a3dsupervisor - Total duration: 417ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 417ms - 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-09-19 06:50:42 Duration: 417ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 286ms 286ms 286ms 1 286ms 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 #15
Day Hour Count Duration Avg duration Sep 19 08 1 286ms 286ms [ User: a3dsupervisor - Total duration: 286ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 286ms - 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-09-19 06:51:29 Duration: 286ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 286ms 286ms 286ms 1 286ms copy public.gtp_log (log_date, log_type, log_info, log_release, log_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 19 08 1 286ms 286ms [ User: a3dsupervisor - Total duration: 286ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 286ms - Times executed: 1 ]
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-09-19 06:51:06 Duration: 286ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 53ms 70ms 55ms 51 2s836ms 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 Sep 19 09 5 268ms 53ms 10 2 110ms 55ms 11 14 779ms 55ms 12 17 937ms 55ms 14 4 229ms 57ms 15 7 395ms 56ms 16 1 54ms 54ms 18 1 61ms 61ms [ User: a3dsupervisor - Total duration: 2s836ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s836ms - Times executed: 51 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:35:32 Duration: 70ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 10:31:11 Duration: 67ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 12:00:07 Duration: 65ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
18 38ms 45ms 39ms 51 2s39ms 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 Sep 19 09 5 203ms 40ms 10 2 79ms 39ms 11 14 558ms 39ms 12 17 673ms 39ms 14 4 159ms 39ms 15 7 283ms 40ms 16 1 42ms 42ms 18 1 39ms 39ms [ User: a3dsupervisor - Total duration: 2s39ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s39ms - Times executed: 51 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 09:53:56 Duration: 45ms Database: cnrs 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-09-19 13:20:48 Duration: 42ms Database: cnrs 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-09-19 14:45:42 Duration: 42ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
19 28ms 81ms 33ms 51 1s720ms 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 #19
Day Hour Count Duration Avg duration Sep 19 09 5 190ms 38ms 10 2 64ms 32ms 11 14 430ms 30ms 12 17 536ms 31ms 14 4 173ms 43ms 15 7 215ms 30ms 16 1 34ms 34ms 18 1 75ms 75ms [ User: a3dsupervisor - Total duration: 1s720ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 1s720ms - Times executed: 51 ]
-
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-09-19 12:00:06 Duration: 81ms Database: cnrs 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-09-19 16:41:14 Duration: 75ms Database: cnrs 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-09-19 07:17:19 Duration: 68ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
20 5ms 12ms 6ms 51 334ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 19 09 5 47ms 9ms 10 2 11ms 5ms 11 14 90ms 6ms 12 17 103ms 6ms 14 4 24ms 6ms 15 7 41ms 5ms 16 1 5ms 5ms 18 1 8ms 8ms [ User: a3dsupervisor - Total duration: 334ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 334ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:41:30 Duration: 12ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:19 Duration: 11ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-19 07:17:51 Duration: 11ms Database: cnrs 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 224ms 48 1ms 40ms 4ms SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 19 02 2 2ms 1ms 03 2 2ms 1ms 04 2 3ms 1ms 05 2 2ms 1ms 06 2 2ms 1ms 07 2 2ms 1ms 08 2 30ms 15ms 09 2 26ms 13ms 10 2 3ms 1ms 11 2 2ms 1ms 12 2 2ms 1ms 13 2 55ms 27ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 2ms 1ms 17 2 24ms 12ms 18 2 4ms 2ms 19 2 2ms 1ms 20 2 30ms 15ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 3ms 1ms [ User: azuresu - Total duration: 251ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 251ms - Times executed: 48 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 11:04:47 Duration: 40ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 18:05:12 Duration: 29ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 06:32:42 Duration: 29ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 110ms 51 1ms 9ms 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 prepare #2
Day Hour Count Duration Avg duration 07 5 16ms 3ms 08 2 3ms 1ms 09 14 25ms 1ms 10 17 28ms 1ms 12 4 14ms 3ms 13 7 11ms 1ms 14 1 1ms 1ms 16 1 8ms 8ms [ User: a3dsupervisor - Total duration: 32ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 32ms - Times executed: 51 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-19 12:00:06 Duration: 9ms Database: cnrs User: cnrs 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-09-19 07:17:19 Duration: 9ms Database: cnrs User: cnrs 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-09-19 16:41:14 Duration: 8ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 77ms 51 0ms 16ms 1ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 07 5 9ms 1ms 08 2 1ms 0ms 09 14 12ms 0ms 10 17 15ms 0ms 12 4 19ms 4ms 13 7 6ms 0ms 14 1 1ms 1ms 16 1 11ms 11ms [ User: a3dsupervisor - Total duration: 1s720ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 1s720ms - Times executed: 51 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-19 12:00:06 Duration: 16ms Database: cnrs User: cnrs 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-09-19 16:41:14 Duration: 11ms Database: cnrs User: cnrs 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-09-19 07:17:19 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 55ms 51 0ms 10ms 1ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 07 5 5ms 1ms 08 2 1ms 0ms 09 14 9ms 0ms 10 17 11ms 0ms 12 4 11ms 2ms 13 7 4ms 0ms 14 1 0ms 0ms 16 1 10ms 10ms [ User: a3dsupervisor - Total duration: 34ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 34ms - Times executed: 51 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 16:41:14 Duration: 10ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 12:00:06 Duration: 9ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 07:17:19 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 50ms 51 0ms 4ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 07 5 4ms 0ms 08 2 1ms 0ms 09 14 13ms 0ms 10 17 15ms 0ms 12 4 4ms 1ms 13 7 5ms 0ms 14 1 0ms 0ms 16 1 4ms 4ms [ User: a3dsupervisor - Total duration: 334ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 334ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 16:41:14 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 09:48:54 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 07:17:19 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 28ms 24 0ms 8ms 1ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 7ms 7ms 07 1 1ms 1ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 4ms 4ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 8ms 8ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: azuresu - Total duration: 4ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 24 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 15:35:03 Duration: 8ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 06:32:42 Duration: 7ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 11:34:49 Duration: 4ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
7 22ms 20 0ms 3ms 1ms SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 09 8 9ms 1ms 10 4 3ms 0ms 12 5 4ms 0ms 13 1 0ms 0ms 16 2 4ms 2ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 20 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 16:15:39 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:49:27 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 12:22:45 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 22ms 51 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 #8
Day Hour Count Duration Avg duration 07 5 2ms 0ms 08 2 0ms 0ms 09 14 4ms 0ms 10 17 6ms 0ms 12 4 4ms 1ms 13 7 2ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 51 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 12:00:06 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 07:17:19 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 13:12:32 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
9 22ms 51 0ms 3ms 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 #9
Day Hour Count Duration Avg duration 07 5 1ms 0ms 08 2 0ms 0ms 09 14 4ms 0ms 10 17 5ms 0ms 12 4 3ms 0ms 13 7 2ms 0ms 14 1 0ms 0ms 16 1 3ms 3ms [ User: a3dsupervisor - Total duration: 2s836ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s836ms - Times executed: 51 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-19 16:41:14 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-19 12:00:06 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-19 13:20:48 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
10 21ms 51 0ms 3ms 0ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 07 5 3ms 0ms 08 2 0ms 0ms 09 14 3ms 0ms 10 17 4ms 0ms 12 4 4ms 1ms 13 7 2ms 0ms 14 1 0ms 0ms 16 1 2ms 2ms [ User: a3dsupervisor - Total duration: 2s39ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s39ms - Times executed: 51 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 12:00:06 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 16:41:14 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 07:17:19 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
11 5ms 51 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 #11
Day Hour Count Duration Avg duration 07 5 0ms 0ms 08 2 0ms 0ms 09 14 1ms 0ms 10 17 1ms 0ms 12 4 0ms 0ms 13 7 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 51 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 07:41:30 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 13:20:48 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:57:07 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 3ms 48 0ms 0ms 0ms set session statement_timeout to 60000;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms [ User: azuresu - Total duration: 2ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 48 ]
-
set session statement_timeout to 60000;
Date: 2025-09-19 21:35:24 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-19 19:05:15 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-19 18:05:12 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
13 2ms 24 0ms 0ms 0ms set session statement_timeout to 120000;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: azuresu - Total duration: 1ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 1ms - Times executed: 24 ]
-
set session statement_timeout to 120000;
Date: 2025-09-19 11:34:49 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-19 22:35:27 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-19 10:32:57 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 230ms 48 1ms 26ms 4ms SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 19 02 2 4ms 2ms 03 2 4ms 2ms 04 2 4ms 2ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 4ms 2ms 08 2 25ms 12ms 09 2 24ms 12ms 10 2 4ms 2ms 11 2 7ms 3ms 12 2 4ms 2ms 13 2 47ms 23ms 14 2 3ms 1ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 23ms 11ms 18 2 4ms 2ms 19 2 4ms 2ms 20 2 23ms 11ms 21 2 5ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 4ms 2ms [ User: azuresu - Total duration: 251ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 251ms - Times executed: 48 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 11:04:47 Duration: 26ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 06:32:42 Duration: 22ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-19 18:05:12 Duration: 22ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 77ms 51 0ms 14ms 1ms 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 #2
Day Hour Count Duration Avg duration 07 5 17ms 3ms 08 2 1ms 0ms 09 14 11ms 0ms 10 17 15ms 0ms 12 4 10ms 2ms 13 7 6ms 0ms 14 1 0ms 0ms 16 1 12ms 12ms [ User: a3dsupervisor - Total duration: 1s720ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 1s720ms - Times executed: 51 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-19 07:17:19 Duration: 14ms Database: cnrs User: cnrs 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-09-19 16:41:14 Duration: 12ms Database: cnrs User: cnrs 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-09-19 12:00:06 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 58ms 51 0ms 2ms 1ms 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 #3
Day Hour Count Duration Avg duration 07 5 6ms 1ms 08 2 2ms 1ms 09 14 15ms 1ms 10 17 17ms 1ms 12 4 5ms 1ms 13 7 7ms 1ms 14 1 0ms 0ms 16 1 2ms 2ms [ User: a3dsupervisor - Total duration: 32ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 32ms - Times executed: 51 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-19 12:00:06 Duration: 2ms Database: cnrs User: cnrs 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-09-19 16:41:14 Duration: 2ms Database: cnrs User: cnrs 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-09-19 07:17:19 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 54ms 51 0ms 8ms 1ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 07 5 10ms 2ms 08 2 1ms 0ms 09 14 9ms 0ms 10 17 10ms 0ms 12 4 8ms 2ms 13 7 5ms 0ms 14 1 0ms 0ms 16 1 7ms 7ms [ User: a3dsupervisor - Total duration: 34ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 34ms - Times executed: 51 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 07:17:19 Duration: 8ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 16:41:14 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-19 12:00:06 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 41ms 24 0ms 8ms 1ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 1ms 1ms 06 1 8ms 8ms 07 1 3ms 3ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 4ms 4ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 8ms 8ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 4ms 4ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: azuresu - Total duration: 4ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 24 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 15:35:03 Duration: 8ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 06:32:42 Duration: 8ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-19 11:34:49 Duration: 4ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
6 33ms 51 0ms 4ms 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 bind #6
Day Hour Count Duration Avg duration 07 5 4ms 0ms 08 2 0ms 0ms 09 14 7ms 0ms 10 17 7ms 0ms 12 4 5ms 1ms 13 7 3ms 0ms 14 1 0ms 0ms 16 1 3ms 3ms [ User: a3dsupervisor - Total duration: 2s836ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s836ms - Times executed: 51 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-19 12:00:06 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-19 16:41:14 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-19 07:17:19 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 14ms 51 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 #7
Day Hour Count Duration Avg duration 07 5 1ms 0ms 08 2 0ms 0ms 09 14 3ms 0ms 10 17 3ms 0ms 12 4 1ms 0ms 13 7 2ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms [ User: a3dsupervisor - Total duration: 2s39ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 2s39ms - Times executed: 51 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 12:00:06 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 13:12:28 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-19 07:17:19 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 12ms 51 0ms 1ms 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 #8
Day Hour Count Duration Avg duration 07 5 1ms 0ms 08 2 0ms 0ms 09 14 2ms 0ms 10 17 3ms 0ms 12 4 1ms 0ms 13 7 1ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 51 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 12:00:06 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 13:20:26 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:22:25 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
9 9ms 20 0ms 0ms 0ms SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 09 8 3ms 0ms 10 4 1ms 0ms 12 5 2ms 0ms 13 1 0ms 0ms 16 2 1ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 20 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 12:29:52 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 16:15:39 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 10:00:57 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
10 9ms 51 0ms 0ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 07 5 0ms 0ms 08 2 0ms 0ms 09 14 2ms 0ms 10 17 2ms 0ms 12 4 1ms 0ms 13 7 1ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms [ User: a3dsupervisor - Total duration: 334ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 334ms - Times executed: 51 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 12:32:37 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 09:22:25 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-19 10:34:25 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
11 6ms 51 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 #11
Day Hour Count Duration Avg duration 07 5 0ms 0ms 08 2 0ms 0ms 09 14 1ms 0ms 10 17 2ms 0ms 12 4 0ms 0ms 13 7 0ms 0ms 14 1 0ms 0ms 16 1 0ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 51 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 07:20:07 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 09:53:05 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-19 07:17:19 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 0ms 24 0ms 0ms 0ms set session statement_timeout to 120000;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: azuresu - Total duration: 1ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 1ms - Times executed: 24 ]
-
set session statement_timeout to 120000;
Date: 2025-09-19 17:35:10 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-19 23:35:31 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-19 18:35:14 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
13 0ms 48 0ms 0ms 0ms set session statement_timeout to 60000;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms [ User: azuresu - Total duration: 2ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 48 ]
-
set session statement_timeout to 60000;
Date: 2025-09-19 12:04:51 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-19 00:02:20 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-19 18:05:12 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 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