pgBadger-
Global information
- Generated on Wed Oct 22 09:04:17 2025
- Log file: ././A3D-RND-REF/y=2025/m=10/d=21/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=10/d=21/h=23/m=00/PT1H.log
- Parsed 624,332 log entries in 3m11s
- Log start from 2025-10-21 00:20:17 to 2025-10-21 23:33:16
-
Overview
Global Stats
- 862 Number of unique normalized queries
- 1,500 Number of queries
- 3m29s Total query duration
- 2025-10-21 00:20:17 First query
- 2025-10-21 23:33:16 Last query
- 176 queries/s at 2025-10-21 06:19:30 Query peak
- 3m29s Total query duration
- 337ms Prepare/parse total duration
- 502ms Bind total duration
- 3m29s 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
- 81 Total number of sessions
- 4 sessions at 2025-10-21 09:35:39 Session peak
- 1h36m Total duration of sessions
- 1m11s Average duration of sessions
- 18 Average queries per session
- 2s592ms Average queries duration per session
- 1m8s Average idle time per session
- 81 Total number of connections
- 2 connections/s at 2025-10-21 06:19:32 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 176 queries/s Query Peak
- 2025-10-21 06:19:30 Date
SELECT Traffic
Key values
- 169 queries/s Query Peak
- 2025-10-21 06:19:31 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 43 queries/s Query Peak
- 2025-10-21 06:50:39 Date
Queries duration
Key values
- 3m29s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 21 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 5ms 5ms 5ms 03 6 0ms 5ms 1ms 5ms 5ms 5ms 04 6 0ms 4ms 1ms 5ms 5ms 5ms 05 6 0ms 6ms 1ms 6ms 6ms 6ms 06 1,109 0ms 53s299ms 186ms 624ms 53s299ms 1m55s 07 6 0ms 4ms 1ms 5ms 5ms 5ms 08 33 0ms 78ms 3ms 103ms 103ms 103ms 09 197 0ms 842ms 8ms 1s427ms 1s427ms 1s427ms 10 7 0ms 4ms 1ms 5ms 5ms 5ms 11 6 0ms 4ms 1ms 4ms 4ms 4ms 12 7 0ms 4ms 1ms 5ms 5ms 5ms 13 16 0ms 53ms 8ms 129ms 129ms 129ms 14 8 0ms 4ms 1ms 4ms 4ms 4ms 15 7 0ms 4ms 1ms 4ms 4ms 4ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 1ms 6ms 6ms 6ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 4ms 1ms 4ms 4ms 4ms 21 15 0ms 41ms 6ms 85ms 85ms 85ms 22 13 0ms 67ms 8ms 105ms 105ms 105ms 23 10 0ms 5ms 1ms 6ms 6ms 6ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 21 00 3 0 3ms 4ms 4ms 4ms 01 3 0 3ms 4ms 4ms 4ms 02 3 0 3ms 4ms 4ms 4ms 03 3 0 3ms 5ms 5ms 5ms 04 3 0 3ms 4ms 4ms 4ms 05 3 0 3ms 6ms 6ms 6ms 06 436 245 303ms 0ms 571ms 1m55s 07 3 0 3ms 5ms 5ms 5ms 08 22 0 5ms 4ms 101ms 101ms 09 127 0 12ms 178ms 1s392ms 1s392ms 10 4 0 2ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 4 0 2ms 5ms 5ms 5ms 13 13 0 10ms 129ms 129ms 129ms 14 5 0 2ms 4ms 4ms 4ms 15 4 0 2ms 4ms 4ms 4ms 16 3 0 3ms 4ms 4ms 4ms 17 3 0 3ms 4ms 4ms 4ms 18 3 0 3ms 6ms 6ms 6ms 19 3 0 3ms 4ms 4ms 4ms 20 3 0 3ms 4ms 4ms 4ms 21 8 0 11ms 85ms 85ms 85ms 22 7 0 15ms 105ms 105ms 105ms 23 5 0 2ms 6ms 6ms 6ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 21 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 1 3 0 0 7ms 0ms 6ms 22ms 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 Oct 21 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 6 6 1.00 200.00% 08 33 33 1.00 150.00% 09 169 181 1.07 100.00% 10 7 7 1.00 175.00% 11 6 6 1.00 200.00% 12 7 7 1.00 175.00% 13 16 16 1.00 123.08% 14 8 8 1.00 160.00% 15 7 7 1.00 175.00% 16 6 6 1.00 200.00% 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 14 14 1.00 175.00% 22 12 12 1.00 171.43% 23 10 10 1.00 200.00% Day Hour Count Average / Second Oct 21 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 2 0.00/s 08 11 0.00/s 09 15 0.00/s 10 3 0.00/s 11 2 0.00/s 12 3 0.00/s 13 5 0.00/s 14 4 0.00/s 15 3 0.00/s 16 2 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 Oct 21 00 2 85ms 80ms 01 2 76ms 71ms 02 2 73ms 68ms 03 2 75ms 70ms 04 2 72ms 67ms 05 2 75ms 69ms 06 5 19m5s 18m24s 07 2 80ms 75ms 08 11 1s35ms 1s25ms 09 15 1s44ms 927ms 10 3 70ms 66ms 11 2 73ms 68ms 12 3 82ms 79ms 13 5 143ms 115ms 14 4 67ms 64ms 15 3 72ms 69ms 16 2 77ms 72ms 17 2 73ms 68ms 18 2 101ms 96ms 19 2 74ms 69ms 20 2 91ms 86ms 21 2 145ms 100ms 22 2 154ms 98ms 23 2 76ms 70ms -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2025-10-21 06:19:32 Date
Connections per database
Key values
- cnrs Main Database
- 81 connections Total
Connections per user
Key values
- azuresu Main User
- 81 connections Total
-
Sessions
Simultaneous sessions
Key values
- 4 sessions Session Peak
- 2025-10-21 09:35:39 Date
Histogram of session times
Key values
- 72 0-500ms duration
Sessions per database
Key values
- cnrs Main Database
- 81 sessions Total
Sessions per user
Key values
- azuresu Main User
- 81 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 81 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 81 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 21 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
- public.gtp_etat_v2_data (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 Oct 21 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 1 10 0 0 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
- 674 Total read queries
- 291 Total write queries
Queries by database
Key values
- cnrs Main database
- 1,500 Requests
- 3m29s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 1,336 Requests
User Request type Count Duration a3dsupervisor Total 1,336 3m28s copy to 245 3m26s cte 8 44ms ddl 3 78ms insert 1 6ms others 454 104ms select 591 2s395ms tcl 31 11ms update 3 22ms azuresu Total 164 423ms others 81 5ms select 83 418ms Duration by user
Key values
- 3m28s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 1,336 3m28s copy to 245 3m26s cte 8 44ms ddl 3 78ms insert 1 6ms others 454 104ms select 591 2s395ms tcl 31 11ms update 3 22ms azuresu Total 164 423ms others 81 5ms select 83 418ms Queries by host
Key values
- 10.3.0.4 Main host
- 1,336 Requests
- 3m28s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 1,103 Requests
- 3m26s (pg_dump)
- Main time consuming application
Application Request type Count Duration DBeaver 23.2.0 - Main 'cnrs' Total 6 7ms others 2 0ms select 4 7ms DBeaver 23.2.0 - Metadata 'cnrs' Total 8 94ms others 2 0ms select 6 93ms IntelliJ IDEA 2025.2.3 Total 81 1s427ms cte 7 34ms others 4 0ms select 70 1s392ms PostgreSQL JDBC Driver Total 92 137ms ddl 3 78ms insert 1 6ms others 19 1ms select 38 16ms tcl 28 11ms update 3 22ms [unknown] Total 210 738ms others 87 6ms select 123 732ms pg_dump Total 1,103 3m26s copy to 245 3m26s cte 1 10ms others 421 101ms select 433 571ms tcl 3 0ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-21 06:34:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,149 0-1ms duration
Slowest individual queries
Rank Duration Query 1 53s299ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2025-10-21 06:51:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 41s184ms COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;[ Date: 2025-10-21 06:50:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 27s234ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-10-21 06:50:31 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 23s204ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-10-21 06:49:41 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 20s916ms COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;[ Date: 2025-10-21 06:50:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 16s426ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-21 06:50:26 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 9s953ms COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;[ Date: 2025-10-21 06:49:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 2s423ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-10-21 06:50:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 1s702ms COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;[ Date: 2025-10-21 06:50:38 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 1s114ms 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-10-21 06:50:09 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 842ms select name, is_dst from pg_catalog.pg_timezone_namesunion distinctselect abbrev as name, is_dst from pg_catalog.pg_timezone_abbrevs;[ Date: 2025-10-21 09:35:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: IntelliJ IDEA 2025.2.3 - Bind query: yes ]
12 770ms COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;[ Date: 2025-10-21 06:49:42 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 687ms COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;[ Date: 2025-10-21 06:50:07 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 673ms COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;[ Date: 2025-10-21 06:50:32 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 603ms COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;[ Date: 2025-10-21 06:49:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 537ms COPY public.a3d_log (log_num_id, user_num_id, software_code, log_type_code, log_date, log_desc, log_return, log_ip, log_session_id) TO stdout;[ Date: 2025-10-21 06:49:16 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 377ms COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;[ Date: 2025-10-21 06:50:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 371ms select E.oid as id, E.xmin as state_number, extname as name, extversion as version, extnamespace as schema_id, nspname as schema_name, array ( select unnest from unnest(available_versions) where unnest > extversion) as available_updates from pg_catalog.pg_extension E join pg_namespace N on E.extnamespace = N.oid left join ( select name, array_agg(version) as available_versions from pg_available_extension_versions() group by name) V on E.extname = V.name -- where pg_catalog.age(E.xmin) <= #TXAGE;[ Date: 2025-10-21 09:35:41 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: IntelliJ IDEA 2025.2.3 - Bind query: yes ]
19 308ms COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;[ Date: 2025-10-21 06:50:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 293ms COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;[ Date: 2025-10-21 06:49:43 - 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 53s299ms 1 53s299ms 53s299ms 53s299ms 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 Oct 21 08 1 53s299ms 53s299ms [ User: a3dsupervisor - Total duration: 53s299ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 53s299ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-21 06:51:20 Duration: 53s299ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 41s184ms 1 41s184ms 41s184ms 41s184ms 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 #2
Day Hour Count Duration Avg duration Oct 21 08 1 41s184ms 41s184ms [ User: a3dsupervisor - Total duration: 41s184ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 41s184ms - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-21 06:50:06 Duration: 41s184ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 27s234ms 1 27s234ms 27s234ms 27s234ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 21 08 1 27s234ms 27s234ms [ User: a3dsupervisor - Total duration: 27s234ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 27s234ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-21 06:50:31 Duration: 27s234ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 23s204ms 1 23s204ms 23s204ms 23s204ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 21 08 1 23s204ms 23s204ms [ User: a3dsupervisor - Total duration: 23s204ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 23s204ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-21 06:49:41 Duration: 23s204ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 20s916ms 1 20s916ms 20s916ms 20s916ms 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 #5
Day Hour Count Duration Avg duration Oct 21 08 1 20s916ms 20s916ms [ User: a3dsupervisor - Total duration: 20s916ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s916ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-21 06:50:04 Duration: 20s916ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 16s426ms 1 16s426ms 16s426ms 16s426ms 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 #6
Day Hour Count Duration Avg duration Oct 21 08 1 16s426ms 16s426ms [ User: a3dsupervisor - Total duration: 16s426ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s426ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-21 06:50:26 Duration: 16s426ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 9s953ms 1 9s953ms 9s953ms 9s953ms 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 Oct 21 08 1 9s953ms 9s953ms [ User: a3dsupervisor - Total duration: 9s953ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s953ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-21 06:49:25 Duration: 9s953ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 2s423ms 1 2s423ms 2s423ms 2s423ms 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 Oct 21 08 1 2s423ms 2s423ms [ User: a3dsupervisor - Total duration: 2s423ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2s423ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-21 06:50:35 Duration: 2s423ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1s702ms 1 1s702ms 1s702ms 1s702ms 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 Oct 21 08 1 1s702ms 1s702ms [ User: a3dsupervisor - Total duration: 1s702ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s702ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-21 06:50:38 Duration: 1s702ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 1s114ms 1 1s114ms 1s114ms 1s114ms 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 Oct 21 08 1 1s114ms 1s114ms [ User: a3dsupervisor - Total duration: 1s114ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s114ms - 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-10-21 06:50:09 Duration: 1s114ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 842ms 1 842ms 842ms 842ms select name, is_dst from pg_catalog.pg_timezone_namesunion distinctselect abbrev as name, is_dst from pg_catalog.pg_timezone_abbrevs;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 21 11 1 842ms 842ms [ User: a3dsupervisor - Total duration: 842ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 842ms - Times executed: 1 ]
-
select name, is_dst from pg_catalog.pg_timezone_namesunion distinctselect abbrev as name, is_dst from pg_catalog.pg_timezone_abbrevs;
Date: 2025-10-21 09:35:40 Duration: 842ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: IntelliJ IDEA 2025.2.3 Bind query: yes
12 770ms 1 770ms 770ms 770ms 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 #12
Day Hour Count Duration Avg duration Oct 21 08 1 770ms 770ms [ User: a3dsupervisor - Total duration: 770ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 770ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-21 06:49:42 Duration: 770ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 687ms 1 687ms 687ms 687ms 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 #13
Day Hour Count Duration Avg duration Oct 21 08 1 687ms 687ms [ User: a3dsupervisor - Total duration: 687ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 687ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-21 06:50:07 Duration: 687ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 673ms 1 673ms 673ms 673ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 21 08 1 673ms 673ms [ User: a3dsupervisor - Total duration: 673ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 673ms - Times executed: 1 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-21 06:50:32 Duration: 673ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 603ms 1 603ms 603ms 603ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 21 08 1 603ms 603ms [ User: a3dsupervisor - Total duration: 603ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 603ms - Times executed: 1 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-21 06:49:15 Duration: 603ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 537ms 1 537ms 537ms 537ms copy public.a3d_log (log_num_id, user_num_id, software_code, log_type_code, log_date, log_desc, log_return, log_ip, log_session_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 08 1 537ms 537ms [ User: a3dsupervisor - Total duration: 537ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 537ms - Times executed: 1 ]
-
COPY public.a3d_log (log_num_id, user_num_id, software_code, log_type_code, log_date, log_desc, log_return, log_ip, log_session_id) TO stdout;
Date: 2025-10-21 06:49:16 Duration: 537ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 377ms 1 377ms 377ms 377ms 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 #17
Day Hour Count Duration Avg duration Oct 21 08 1 377ms 377ms [ User: a3dsupervisor - Total duration: 377ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 377ms - 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-10-21 06:50:35 Duration: 377ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 371ms 1 371ms 371ms 371ms select e.oid as id, e.xmin as state_number, extname as name, extversion as version, extnamespace as schema_id, nspname as schema_name, array ( select unnest from unnest(available_versions) where unnest > extversion) as available_updates from pg_catalog.pg_extension e join pg_namespace n on e.extnamespace = n.oid left join ( select name, array_agg(version) as available_versions from pg_available_extension_versions() group by name) v on e.extname = v.name -- where pg_catalog.age(e.xmin) <= #txage;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 11 1 371ms 371ms [ User: a3dsupervisor - Total duration: 371ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 371ms - Times executed: 1 ]
-
select E.oid as id, E.xmin as state_number, extname as name, extversion as version, extnamespace as schema_id, nspname as schema_name, array ( select unnest from unnest(available_versions) where unnest > extversion) as available_updates from pg_catalog.pg_extension E join pg_namespace N on E.extnamespace = N.oid left join ( select name, array_agg(version) as available_versions from pg_available_extension_versions() group by name) V on E.extname = V.name -- where pg_catalog.age(E.xmin) <= #TXAGE;
Date: 2025-10-21 09:35:41 Duration: 371ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: IntelliJ IDEA 2025.2.3 Bind query: yes
19 308ms 1 308ms 308ms 308ms 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 Oct 21 08 1 308ms 308ms [ User: a3dsupervisor - Total duration: 308ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 308ms - Times executed: 1 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-21 06:50:39 Duration: 308ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 293ms 1 293ms 293ms 293ms copy public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 21 08 1 293ms 293ms [ User: a3dsupervisor - Total duration: 293ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 293ms - Times executed: 1 ]
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-10-21 06:49:43 Duration: 293ms 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 26ms 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 Oct 21 08 164 26ms 0ms [ User: a3dsupervisor - Total duration: 26ms - Times executed: 164 ]
[ Application: pg_dump - Total duration: 26ms - Times executed: 164 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2648852'::oid;
Date: 2025-10-21 06:19:30 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 = '2466593'::oid;
Date: 2025-10-21 06:19:30 Duration: 0ms 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 = '2466676'::oid;
Date: 2025-10-21 06:19:30 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 126 23ms 0ms 1ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 08 126 23ms 0ms [ User: a3dsupervisor - Total duration: 23ms - Times executed: 126 ]
[ Application: pg_dump - Total duration: 23ms - Times executed: 126 ]
-
EXECUTE dumpFunc ('16538');
Date: 2025-10-21 06:19:29 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('16579');
Date: 2025-10-21 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('16593');
Date: 2025-10-21 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 81 5ms 0ms 0ms 0ms set session statement_timeout to ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 21 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 7 0ms 0ms 00 6 0ms 0ms 01 5 0ms 0ms [ User: azuresu - Total duration: 5ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 5ms - Times executed: 81 ]
-
set session statement_timeout to 60000;
Date: 2025-10-21 10:50:55 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 120000;
Date: 2025-10-21 02:20:24 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 60000;
Date: 2025-10-21 04:50:33 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 48 231ms 4ms 11ms 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 ? 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 #4
Day Hour Count Duration Avg duration Oct 21 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 10ms 5ms 08 2 16ms 8ms 09 2 8ms 4ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 10ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 8ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms [ User: azuresu - Total duration: 231ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 231ms - 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-10-21 06:50:41 Duration: 11ms 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-10-21 05:20:35 Duration: 6ms 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-10-21 18:51:24 Duration: 6ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
5 25 3ms 0ms 0ms 0ms select extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition from pg_catalog.pg_extension;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 21 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 2 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms [ User: azuresu - Total duration: 3ms - Times executed: 25 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 25 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-10-21 07:20:42 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-10-21 22:03:10 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-10-21 19:21:25 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
6 22 6ms 0ms 0ms 0ms select version from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 21 10 7 2ms 0ms 11 8 2ms 0ms 12 1 0ms 0ms 14 1 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 1 0ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 22 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 22 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-21 08:11:32 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-10-21 14:27:47 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-10-21 09:51:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
7 22 2ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 21 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('2465437'::pg_catalog.oid, NULL);
Date: 2025-10-21 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('1114'::pg_catalog.oid, NULL);
Date: 2025-10-21 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('3220'::pg_catalog.oid, NULL);
Date: 2025-10-21 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 17 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 21 08 3 0ms 0ms 11 14 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 17 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 14 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 3 ]
-
BEGIN;
Date: 2025-10-21 09:33:36 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-21 09:33:36 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
BEGIN;
Date: 2025-10-21 09:33:37 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
9 14 1ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 21 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-10-21 06:19:31 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17231'::pg_catalog.oid);
Date: 2025-10-21 06:19:32 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17224'::pg_catalog.oid);
Date: 2025-10-21 06:19:31 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 12 0ms 0ms 0ms 0ms show search_path;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 21 10 2 0ms 0ms 11 10 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 12 ]
[ Application: DBeaver 23.2.0 - Metadata 'cnrs' - Total duration: 0ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 10 ]
[ Application: DBeaver 23.2.0 - Main 'cnrs' - Total duration: 0ms - Times executed: 1 ]
-
SHOW search_path;
Date: 2025-10-21 08:17:58 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 23.2.0 - Metadata 'cnrs' Bind query: yes
-
SHOW search_path;
Date: 2025-10-21 08:17:58 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 23.2.0 - Main 'cnrs' Bind query: yes
-
SHOW SEARCH_PATH;
Date: 2025-10-21 09:33:22 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 10 1ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 21 10 4 0ms 0ms 11 6 0ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 10 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 2 ]
[ Application: DBeaver 23.2.0 - Metadata 'cnrs' - Total duration: 0ms - Times executed: 1 ]
[ Application: DBeaver 23.2.0 - Main 'cnrs' - Total duration: 0ms - Times executed: 1 ]
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-10-21 09:33:21 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-10-21 09:33:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
SET application_name = '';
Date: 2025-10-21 09:35:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
12 7 9ms 0ms 3ms 1ms commit;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 21 11 7 9ms 1ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9ms - Times executed: 7 ]
-
COMMIT;
Date: 2025-10-21 09:33:36 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 09:33:36 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-21 09:33:36 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 7 0ms 0ms 0ms 0ms rollback;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 21 11 7 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 7 ]
-
ROLLBACK;
Date: 2025-10-21 09:33:22 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
ROLLBACK;
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
ROLLBACK;
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 7 0ms 0ms 0ms 0ms select version();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 21 10 1 0ms 0ms 11 6 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
[ Application: DBeaver 23.2.0 - Metadata 'cnrs' - Total duration: 0ms - Times executed: 1 ]
-
select version();
Date: 2025-10-21 09:33:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select version();
Date: 2025-10-21 09:35:38 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT version();
Date: 2025-10-21 08:17:58 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 23.2.0 - Metadata 'cnrs' Bind query: yes
15 6 5ms 0ms 1ms 0ms execute dumpcompositetype (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 21 08 6 5ms 0ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 5ms - Times executed: 6 ]
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-10-21 06:19:29 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465426');
Date: 2025-10-21 06:19:29 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465438');
Date: 2025-10-21 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 6 3ms 0ms 1ms 0ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 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-10-21 06:19:28 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-21 06:19:32 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-21 06:19:32 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 6 2ms 0ms 1ms 0ms execute getcolumnacls (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 21 08 6 2ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 2ms - Times executed: 6 ]
-
EXECUTE getColumnACLs ('12339');
Date: 2025-10-21 06:19:30 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('12130');
Date: 2025-10-21 06:19:30 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('6100');
Date: 2025-10-21 06:19:30 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 6 0ms 0ms 0ms 0ms select count(*) from databasechangeloglock;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 11 6 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 6 ]
-
SELECT COUNT(*) FROM databasechangeloglock;
Date: 2025-10-21 09:33:22 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT COUNT(*) FROM databasechangeloglock;
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT COUNT(*) FROM databasechangeloglock;
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 5 0ms 0ms 0ms 0ms select typinput = ?::regproc as is_array, typtype, typname, pg_type.oid from pg_catalog.pg_type left join ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(?, array_upper(current_schemas(false), ?)) as s (r)) as r using (nspname)) as sp on sp.nspoid = typnamespace where pg_type.oid = order by sp.r, pg_type.oid desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 21 10 1 0ms 0ms 11 4 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 5 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 4 ]
[ Application: DBeaver 23.2.0 - Main 'cnrs' - Total duration: 0ms - Times executed: 1 ]
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 09:35:44 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: IntelliJ IDEA 2025.2.3 Bind query: yes
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 08:17:58 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 23.2.0 - Main 'cnrs' Bind query: yes
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 09:35:40 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: IntelliJ IDEA 2025.2.3 Bind query: yes
20 5 0ms 0ms 0ms 0ms set search_path to public, "$user", "public";Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 21 11 5 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 5 ]
-
SET SEARCH_PATH TO public, "$user", "public";
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SET SEARCH_PATH TO public, "$user", "public";
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SET SEARCH_PATH TO public, "$user", "public";
Date: 2025-10-21 09:33:23 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 53s299ms 53s299ms 53s299ms 1 53s299ms 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 Oct 21 08 1 53s299ms 53s299ms [ User: a3dsupervisor - Total duration: 53s299ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 53s299ms - Times executed: 1 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-21 06:51:20 Duration: 53s299ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 41s184ms 41s184ms 41s184ms 1 41s184ms 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 #2
Day Hour Count Duration Avg duration Oct 21 08 1 41s184ms 41s184ms [ User: a3dsupervisor - Total duration: 41s184ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 41s184ms - Times executed: 1 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-10-21 06:50:06 Duration: 41s184ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 27s234ms 27s234ms 27s234ms 1 27s234ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 21 08 1 27s234ms 27s234ms [ User: a3dsupervisor - Total duration: 27s234ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 27s234ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-21 06:50:31 Duration: 27s234ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 23s204ms 23s204ms 23s204ms 1 23s204ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 21 08 1 23s204ms 23s204ms [ User: a3dsupervisor - Total duration: 23s204ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 23s204ms - Times executed: 1 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-10-21 06:49:41 Duration: 23s204ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 20s916ms 20s916ms 20s916ms 1 20s916ms 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 #5
Day Hour Count Duration Avg duration Oct 21 08 1 20s916ms 20s916ms [ User: a3dsupervisor - Total duration: 20s916ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 20s916ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-21 06:50:04 Duration: 20s916ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 16s426ms 16s426ms 16s426ms 1 16s426ms 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 #6
Day Hour Count Duration Avg duration Oct 21 08 1 16s426ms 16s426ms [ User: a3dsupervisor - Total duration: 16s426ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 16s426ms - Times executed: 1 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-21 06:50:26 Duration: 16s426ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 9s953ms 9s953ms 9s953ms 1 9s953ms 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 Oct 21 08 1 9s953ms 9s953ms [ User: a3dsupervisor - Total duration: 9s953ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 9s953ms - Times executed: 1 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-21 06:49:25 Duration: 9s953ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 2s423ms 2s423ms 2s423ms 1 2s423ms 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 Oct 21 08 1 2s423ms 2s423ms [ User: a3dsupervisor - Total duration: 2s423ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2s423ms - Times executed: 1 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-21 06:50:35 Duration: 2s423ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1s702ms 1s702ms 1s702ms 1 1s702ms 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 Oct 21 08 1 1s702ms 1s702ms [ User: a3dsupervisor - Total duration: 1s702ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s702ms - Times executed: 1 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-21 06:50:38 Duration: 1s702ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 1s114ms 1s114ms 1s114ms 1 1s114ms 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 Oct 21 08 1 1s114ms 1s114ms [ User: a3dsupervisor - Total duration: 1s114ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1s114ms - 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-10-21 06:50:09 Duration: 1s114ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 842ms 842ms 842ms 1 842ms select name, is_dst from pg_catalog.pg_timezone_namesunion distinctselect abbrev as name, is_dst from pg_catalog.pg_timezone_abbrevs;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 21 11 1 842ms 842ms [ User: a3dsupervisor - Total duration: 842ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 842ms - Times executed: 1 ]
-
select name, is_dst from pg_catalog.pg_timezone_namesunion distinctselect abbrev as name, is_dst from pg_catalog.pg_timezone_abbrevs;
Date: 2025-10-21 09:35:40 Duration: 842ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: IntelliJ IDEA 2025.2.3 Bind query: yes
12 770ms 770ms 770ms 1 770ms 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 #12
Day Hour Count Duration Avg duration Oct 21 08 1 770ms 770ms [ User: a3dsupervisor - Total duration: 770ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 770ms - Times executed: 1 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-21 06:49:42 Duration: 770ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 687ms 687ms 687ms 1 687ms 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 #13
Day Hour Count Duration Avg duration Oct 21 08 1 687ms 687ms [ User: a3dsupervisor - Total duration: 687ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 687ms - Times executed: 1 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-10-21 06:50:07 Duration: 687ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 673ms 673ms 673ms 1 673ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 21 08 1 673ms 673ms [ User: a3dsupervisor - Total duration: 673ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 673ms - Times executed: 1 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-10-21 06:50:32 Duration: 673ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 603ms 603ms 603ms 1 603ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 21 08 1 603ms 603ms [ User: a3dsupervisor - Total duration: 603ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 603ms - Times executed: 1 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-10-21 06:49:15 Duration: 603ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 537ms 537ms 537ms 1 537ms copy public.a3d_log (log_num_id, user_num_id, software_code, log_type_code, log_date, log_desc, log_return, log_ip, log_session_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 21 08 1 537ms 537ms [ User: a3dsupervisor - Total duration: 537ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 537ms - Times executed: 1 ]
-
COPY public.a3d_log (log_num_id, user_num_id, software_code, log_type_code, log_date, log_desc, log_return, log_ip, log_session_id) TO stdout;
Date: 2025-10-21 06:49:16 Duration: 537ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 377ms 377ms 377ms 1 377ms 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 #17
Day Hour Count Duration Avg duration Oct 21 08 1 377ms 377ms [ User: a3dsupervisor - Total duration: 377ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 377ms - 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-10-21 06:50:35 Duration: 377ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 371ms 371ms 371ms 1 371ms select e.oid as id, e.xmin as state_number, extname as name, extversion as version, extnamespace as schema_id, nspname as schema_name, array ( select unnest from unnest(available_versions) where unnest > extversion) as available_updates from pg_catalog.pg_extension e join pg_namespace n on e.extnamespace = n.oid left join ( select name, array_agg(version) as available_versions from pg_available_extension_versions() group by name) v on e.extname = v.name -- where pg_catalog.age(e.xmin) <= #txage;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 11 1 371ms 371ms [ User: a3dsupervisor - Total duration: 371ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 371ms - Times executed: 1 ]
-
select E.oid as id, E.xmin as state_number, extname as name, extversion as version, extnamespace as schema_id, nspname as schema_name, array ( select unnest from unnest(available_versions) where unnest > extversion) as available_updates from pg_catalog.pg_extension E join pg_namespace N on E.extnamespace = N.oid left join ( select name, array_agg(version) as available_versions from pg_available_extension_versions() group by name) V on E.extname = V.name -- where pg_catalog.age(E.xmin) <= #TXAGE;
Date: 2025-10-21 09:35:41 Duration: 371ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: IntelliJ IDEA 2025.2.3 Bind query: yes
19 308ms 308ms 308ms 1 308ms 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 Oct 21 08 1 308ms 308ms [ User: a3dsupervisor - Total duration: 308ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 308ms - Times executed: 1 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-10-21 06:50:39 Duration: 308ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 293ms 293ms 293ms 1 293ms copy public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 21 08 1 293ms 293ms [ User: a3dsupervisor - Total duration: 293ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 293ms - Times executed: 1 ]
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-10-21 06:49:43 Duration: 293ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 133ms 48 0ms 29ms 2ms 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 Oct 21 02 2 2ms 1ms 03 2 2ms 1ms 04 2 2ms 1ms 05 2 3ms 1ms 06 2 2ms 1ms 07 2 2ms 1ms 08 2 31ms 15ms 09 2 3ms 1ms 10 2 2ms 1ms 11 2 2ms 1ms 12 2 3ms 1ms 13 2 2ms 1ms 14 2 3ms 1ms 15 2 5ms 2ms 16 2 2ms 1ms 17 2 3ms 1ms 18 2 2ms 1ms 19 2 3ms 1ms 20 2 27ms 13ms 21 2 3ms 1ms 22 2 3ms 1ms 23 2 2ms 1ms 00 2 9ms 4ms 01 2 2ms 1ms [ User: azuresu - Total duration: 231ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 231ms - 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-10-21 06:50:41 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-10-21 18:51:24 Duration: 25ms 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-10-21 22:03:10 Duration: 8ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 26ms 1 26ms 26ms 26ms SELECT count(*) FROM information_schema.columns where upper(table_name) = 'GTP_ETAT_V2_DATA' and upper(column_name) = 'MAIN' and data_type = 'boolean';Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 09 1 26ms 26ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5ms - Times executed: 1 ]
-
SELECT count(*) FROM information_schema.columns where upper(table_name) = 'GTP_ETAT_V2_DATA' and upper(column_name) = 'MAIN' and data_type = 'boolean';
Date: 2025-10-21 09:33:36 Duration: 26ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
3 24ms 22 0ms 2ms 1ms SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 08 7 8ms 1ms 09 8 8ms 1ms 10 1 0ms 0ms 12 1 0ms 0ms 13 2 2ms 1ms 14 2 2ms 1ms 15 1 0ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 22 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 22 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-21 08:11:32 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-10-21 09:51:27 Duration: 1ms 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-10-21 09:15:52 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 19ms 2 2ms 16ms 9ms SELECT pg_type.oid, typname FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE typname = $1 ORDER BY sp.r, pg_type.oid DESC LIMIT 1;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 08 2 19ms 9ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
SELECT pg_type.oid, typname FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE typname = $1 ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
Date: 2025-10-21 08:17:57 Duration: 16ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
SELECT pg_type.oid, typname FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE typname = $1 ORDER BY sp.r, pg_type.oid DESC LIMIT 1;
Date: 2025-10-21 08:17:58 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
5 15ms 2 5ms 9ms 7ms SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 21 1 9ms 9ms 22 1 5ms 5ms [ User: azuresu - Total duration: 70ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 70ms - Times executed: 2 ]
-
SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;
Date: 2025-10-21 21:44:40 Duration: 9ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;
Date: 2025-10-21 22:03:10 Duration: 5ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
6 11ms 25 0ms 2ms 0ms 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 0ms 0ms 07 1 2ms 2ms 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 1ms 1ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms [ User: azuresu - Total duration: 3ms - Times executed: 25 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 25 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-10-21 07:20:42 Duration: 2ms 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-10-21 19:21:25 Duration: 1ms 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-10-21 09:20:49 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
7 5ms 3 0ms 4ms 1ms select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 08 1 4ms 4ms 09 2 1ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
[ Application: DBeaver 23.2.0 - Metadata 'cnrs' - Total duration: 0ms - Times executed: 1 ]
-
select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);
Date: 2025-10-21 08:17:58 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: DBeaver 23.2.0 - Metadata 'cnrs'
-
select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);
Date: 2025-10-21 09:33:33 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select string_agg(word, ',') from pg_catalog.pg_get_keywords() where word <> ALL ('{a,abs,absolute,action,ada,add,admin,after,all,allocate,alter,always,and,any,are,array,as,asc,asensitive,assertion,assignment,asymmetric,at,atomic,attribute,attributes,authorization,avg,before,begin,bernoulli,between,bigint,binary,blob,boolean,both,breadth,by,c,call,called,cardinality,cascade,cascaded,case,cast,catalog,catalog_name,ceil,ceiling,chain,char,char_length,character,character_length,character_set_catalog,character_set_name,character_set_schema,characteristics,characters,check,checked,class_origin,clob,close,coalesce,cobol,code_units,collate,collation,collation_catalog,collation_name,collation_schema,collect,column,column_name,command_function,command_function_code,commit,committed,condition,condition_number,connect,connection_name,constraint,constraint_catalog,constraint_name,constraint_schema,constraints,constructors,contains,continue,convert,corr,corresponding,count,covar_pop,covar_samp,create,cross,cube,cume_dist,current,current_collation,current_date,current_default_transform_group,current_path,current_role,current_time,current_timestamp,current_transform_group_for_type,current_user,cursor,cursor_name,cycle,data,date,datetime_interval_code,datetime_interval_precision,day,deallocate,dec,decimal,declare,default,defaults,deferrable,deferred,defined,definer,degree,delete,dense_rank,depth,deref,derived,desc,describe,descriptor,deterministic,diagnostics,disconnect,dispatch,distinct,domain,double,drop,dynamic,dynamic_function,dynamic_function_code,each,element,else,end,end-exec,equals,escape,every,except,exception,exclude,excluding,exec,execute,exists,exp,external,extract,false,fetch,filter,final,first,float,floor,following,for,foreign,fortran,found,free,from,full,function,fusion,g,general,get,global,go,goto,grant,granted,group,grouping,having,hierarchy,hold,hour,identity,immediate,implementation,in,including,increment,indicator,initially,inner,inout,input,insensitive,insert,instance,instantiable,int,integer,intersect,intersection,interval,into,invoker,is,isolation,join,k,key,key_member,key_type,language,large,last,lateral,leading,left,length,level,like,ln,local,localtime,localtimestamp,locator,lower,m,map,match,matched,max,maxvalue,member,merge,message_length,message_octet_length,message_text,method,min,minute,minvalue,mod,modifies,module,month,more,multiset,mumps,name,names,national,natural,nchar,nclob,nesting,new,next,no,none,normalize,normalized,not,"null",nullable,nullif,nulls,number,numeric,object,octet_length,octets,of,old,on,only,open,option,options,or,order,ordering,ordinality,others,out,outer,output,over,overlaps,overlay,overriding,pad,parameter,parameter_mode,parameter_name,parameter_ordinal_position,parameter_specific_catalog,parameter_specific_name,parameter_specific_schema,partial,partition,pascal,path,percent_rank,percentile_cont,percentile_disc,placing,pli,position,power,preceding,precision,prepare,preserve,primary,prior,privileges,procedure,public,range,rank,read,reads,real,recursive,ref,references,referencing,regr_avgx,regr_avgy,regr_count,regr_intercept,regr_r2,regr_slope,regr_sxx,regr_sxy,regr_syy,relative,release,repeatable,restart,result,return,returned_cardinality,returned_length,returned_octet_length,returned_sqlstate,returns,revoke,right,role,rollback,rollup,routine,routine_catalog,routine_name,routine_schema,row,row_count,row_number,rows,savepoint,scale,schema,schema_name,scope_catalog,scope_name,scope_schema,scroll,search,second,section,security,select,self,sensitive,sequence,serializable,server_name,session,session_user,set,sets,similar,simple,size,smallint,some,source,space,specific,specific_name,specifictype,sql,sqlexception,sqlstate,sqlwarning,sqrt,start,state,statement,static,stddev_pop,stddev_samp,structure,style,subclass_origin,submultiset,substring,sum,symmetric,system,system_user,table,table_name,tablesample,temporary,then,ties,time,timestamp,timezone_hour,timezone_minute,to,top_level_count,trailing,transaction,transaction_active,transactions_committed,transactions_rolled_back,transform,transforms,translate,translation,treat,trigger,trigger_catalog,trigger_name,trigger_schema,trim,true,type,uescape,unbounded,uncommitted,under,union,unique,unknown,unnamed,unnest,update,upper,usage,user,user_defined_type_catalog,user_defined_type_code,user_defined_type_name,user_defined_type_schema,using,value,values,var_pop,var_samp,varchar,varying,view,when,whenever,where,width_bucket,window,with,within,without,work,write,year,zone}'::text[]);
Date: 2025-10-21 09:33:21 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
8 5ms 5 0ms 3ms 1ms SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 08 1 3ms 3ms 09 4 2ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 5 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 4 ]
[ Application: DBeaver 23.2.0 - Main 'cnrs' - Total duration: 0ms - Times executed: 1 ]
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 08:17:58 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: DBeaver 23.2.0 - Main 'cnrs'
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 09:35:39 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 09:35:44 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
9 5ms 2 1ms 3ms 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 #9
Day Hour Count Duration Avg duration 09 1 3ms 3ms 13 1 1ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-10-21 09:34:15 Duration: 3ms 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-10-21 13:20:57 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
10 4ms 1 4ms 4ms 4ms select umid as id, ;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 09 1 4ms 4ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 1 ]
-
select umid as id, ;
Date: 2025-10-21 09:35:41 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
11 4ms 3 0ms 2ms 1ms SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 21 1 2ms 2ms 22 1 1ms 1ms 23 1 0ms 0ms [ User: azuresu - Total duration: 3ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 3 ]
-
SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');
Date: 2025-10-21 21:44:40 Duration: 2ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');
Date: 2025-10-21 22:03:10 Duration: 1ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');
Date: 2025-10-21 23:03:14 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
12 4ms 3 0ms 2ms 1ms SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 21 1 1ms 1ms 22 1 2ms 2ms 23 1 0ms 0ms [ User: azuresu - Total duration: 0ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 3 ]
-
SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;
Date: 2025-10-21 22:03:10 Duration: 2ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;
Date: 2025-10-21 21:44:40 Duration: 1ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;
Date: 2025-10-21 23:03:14 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
13 3ms 2 1ms 1ms 1ms SELECT current_database() AS "TABLE_CAT", n.nspname AS "TABLE_SCHEM", c.relname AS "TABLE_NAME", CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'P' then 'PARTITIONED INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS "TABLE_TYPE", d.description AS "REMARKS", '' as "TYPE_CAT", '' as "TYPE_SCHEM", '' as "TYPE_NAME", '' AS "SELF_REFERENCING_COL_NAME", '' AS "REF_GENERATION" FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0 and d.classoid = 'pg_class'::regclass) WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema') OR (c.relkind = 'p' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME";Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 09 2 3ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
SELECT current_database() AS "TABLE_CAT", n.nspname AS "TABLE_SCHEM", c.relname AS "TABLE_NAME", CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'P' then 'PARTITIONED INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS "TABLE_TYPE", d.description AS "REMARKS", '' as "TYPE_CAT", '' as "TYPE_SCHEM", '' as "TYPE_NAME", '' AS "SELF_REFERENCING_COL_NAME", '' AS "REF_GENERATION" FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0 and d.classoid = 'pg_class'::regclass) WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema') OR (c.relkind = 'p' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME";
Date: 2025-10-21 09:33:22 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
SELECT current_database() AS "TABLE_CAT", n.nspname AS "TABLE_SCHEM", c.relname AS "TABLE_NAME", CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'P' then 'PARTITIONED INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS "TABLE_TYPE", d.description AS "REMARKS", '' as "TYPE_CAT", '' as "TYPE_SCHEM", '' as "TYPE_NAME", '' AS "SELF_REFERENCING_COL_NAME", '' AS "REF_GENERATION" FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0 and d.classoid = 'pg_class'::regclass) WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema') OR (c.relkind = 'p' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME";
Date: 2025-10-21 09:33:35 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
14 3ms 50 0ms 0ms 0ms set session statement_timeout to 60000;Times Reported Time consuming prepare #14
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 3 0ms 0ms 22 3 0ms 0ms 23 2 0ms 0ms [ User: azuresu - Total duration: 3ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 50 ]
-
set session statement_timeout to 60000;
Date: 2025-10-21 02:50:26 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-10-21 13:51:05 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-10-21 18:51:23 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
15 3ms 1 3ms 3ms 3ms select * from pg_catalog.pg_settings;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 08 1 3ms 3ms [ User: a3dsupervisor - Total duration: 13ms - Times executed: 1 ]
[ Application: DBeaver 23.2.0 - Metadata 'cnrs' - Total duration: 13ms - Times executed: 1 ]
-
select * from pg_catalog.pg_settings;
Date: 2025-10-21 08:17:58 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: DBeaver 23.2.0 - Metadata 'cnrs'
16 2ms 1 2ms 2ms 2ms select L.transactionid::varchar::bigint as transaction_id;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 09 1 2ms 2ms [ User: a3dsupervisor - Total duration: 45ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 45ms - Times executed: 1 ]
-
select L.transactionid::varchar::bigint as transaction_id;
Date: 2025-10-21 09:35:38 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
17 2ms 31 0ms 0ms 0ms set session statement_timeout to 120000;Times Reported Time consuming prepare #17
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 4 0ms 0ms 22 3 0ms 0ms 23 3 0ms 0ms [ User: azuresu - Total duration: 1ms - Times executed: 31 ]
[ Application: [unknown] - Total duration: 1ms - Times executed: 31 ]
-
set session statement_timeout to 120000;
Date: 2025-10-21 07:20:42 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-10-21 16:21:14 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-10-21 10:20:53 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
18 2ms 2 0ms 1ms 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 #18
Day Hour Count Duration Avg duration 09 1 1ms 1ms 13 1 0ms 0ms [ User: a3dsupervisor - Total duration: 105ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 105ms - Times executed: 2 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-21 09:34:15 Duration: 1ms 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-10-21 13:20:57 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
19 2ms 6 0ms 0ms 0ms select version();Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 09 6 2ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 2 ]
-
select version();
Date: 2025-10-21 09:33:33 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select version();
Date: 2025-10-21 09:35:38 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
select version();
Date: 2025-10-21 09:33:21 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
20 2ms 2 0ms 1ms 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 #20
Day Hour Count Duration Avg duration 09 1 1ms 1ms 13 1 0ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 2 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-21 09:34:15 Duration: 1ms 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-10-21 13:20:57 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 152ms 48 1ms 23ms 3ms 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 Oct 21 02 2 5ms 2ms 03 2 4ms 2ms 04 2 4ms 2ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 4ms 2ms 08 2 24ms 12ms 09 2 4ms 2ms 10 2 4ms 2ms 11 2 4ms 2ms 12 2 4ms 2ms 13 2 4ms 2ms 14 2 4ms 2ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 4ms 2ms 18 2 4ms 2ms 19 2 5ms 2ms 20 2 25ms 12ms 21 2 4ms 2ms 22 2 5ms 2ms 23 2 3ms 1ms 00 2 8ms 4ms 01 2 3ms 1ms [ User: azuresu - Total duration: 231ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 231ms - 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-10-21 18:51:24 Duration: 23ms 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-10-21 06:50:41 Duration: 21ms 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-10-21 22:03:10 Duration: 6ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 35ms 1 35ms 35ms 35ms SELECT count(*) FROM information_schema.columns where upper(table_name) = 'GTP_ETAT_V2_DATA' and upper(column_name) = 'MAIN' and data_type = 'boolean';Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 09 1 35ms 35ms [ User: a3dsupervisor - Total duration: 5ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5ms - Times executed: 1 ]
-
SELECT count(*) FROM information_schema.columns where upper(table_name) = 'GTP_ETAT_V2_DATA' and upper(column_name) = 'MAIN' and data_type = 'boolean';
Date: 2025-10-21 09:33:36 Duration: 35ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
3 29ms 1 29ms 29ms 29ms update GTP_ETAT_V2_DATA gevd set main = ( case when main_old = false then 0::smallint else 1::smallint end);Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 09 1 29ms 29ms [ User: a3dsupervisor - Total duration: 20ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 20ms - Times executed: 1 ]
-
update GTP_ETAT_V2_DATA gevd set main = ( case when main_old = false then 0::smallint else 1::smallint end);
Date: 2025-10-21 09:33:36 Duration: 29ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
4 25ms 25 0ms 3ms 1ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 1ms 1ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 3ms 3ms 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 1ms 1ms 16 1 0ms 0ms 17 1 1ms 1ms 18 1 0ms 0ms 19 1 2ms 2ms 20 1 0ms 0ms 21 2 1ms 0ms 22 1 2ms 2ms 23 1 0ms 0ms [ User: azuresu - Total duration: 3ms - Times executed: 25 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 25 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-10-21 07:20:42 Duration: 3ms 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-10-21 19:21:25 Duration: 2ms 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-10-21 22:03:10 Duration: 2ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
5 17ms 1 17ms 17ms 17ms SELECT n.oid, n.*, d.description FROM pg_catalog.pg_namespace n;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 08 1 17ms 17ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 1 ]
[ Application: DBeaver 23.2.0 - Main 'cnrs' - Total duration: 7ms - Times executed: 1 ]
-
SELECT n.oid, n.*, d.description FROM pg_catalog.pg_namespace n;
Date: 2025-10-21 08:17:58 Duration: 17ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: DBeaver 23.2.0 - Main 'cnrs'
6 16ms 1 16ms 16ms 16ms select member id, roleid role_id, admin_option;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 09 1 16ms 16ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 1 ]
-
select member id, roleid role_id, admin_option;
Date: 2025-10-21 09:35:40 Duration: 16ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
7 13ms 22 0ms 2ms 0ms SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 08 7 5ms 0ms 09 8 3ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 13 2 1ms 0ms 14 2 1ms 0ms 15 1 0ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 22 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 22 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-21 08:11:32 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-10-21 14:27:47 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-10-21 13:07:06 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 12ms 1 12ms 12ms 12ms select umid as id, ;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 09 1 12ms 12ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 1 ]
-
select umid as id, ;
Date: 2025-10-21 09:35:41 Duration: 12ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
9 9ms 2 4ms 5ms 4ms SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 21 1 5ms 5ms 22 1 4ms 4ms [ User: azuresu - Total duration: 70ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 70ms - Times executed: 2 ]
-
SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;
Date: 2025-10-21 21:44:40 Duration: 5ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;
Date: 2025-10-21 22:03:10 Duration: 4ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
10 9ms 6 0ms 7ms 1ms SELECT COUNT(*) FROM databasechangeloglock;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 09 6 9ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 6 ]
-
SELECT COUNT(*) FROM databasechangeloglock;
Date: 2025-10-21 09:33:22 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
SELECT COUNT(*) FROM databasechangeloglock;
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
SELECT COUNT(*) FROM databasechangeloglock;
Date: 2025-10-21 09:33:35 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
11 8ms 2 0ms 8ms 4ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 09 1 8ms 8ms 13 1 0ms 0ms [ User: a3dsupervisor - Total duration: 105ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 105ms - Times executed: 2 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-10-21 09:34:15 Duration: 8ms 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-10-21 13:20:57 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 8ms 2 3ms 5ms 4ms SELECT * FROM ( SELECT current_database() AS current_database, n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, t.typtypmod, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif (a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind in ('r', 'p', 'v', 'f', 'm') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog') c WHERE true AND attname LIKE '%' ORDER BY nspname, c.relname, attnum;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 09 2 8ms 4ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
SELECT * FROM ( SELECT current_database() AS current_database, n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, t.typtypmod, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif (a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind in ('r', 'p', 'v', 'f', 'm') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog') c WHERE true AND attname LIKE '%' ORDER BY nspname, c.relname, attnum;
Date: 2025-10-21 09:33:22 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
SELECT * FROM ( SELECT current_database() AS current_database, n.nspname, c.relname, a.attname, a.atttypid, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull) AS attnotnull, a.atttypmod, a.attlen, t.typtypmod, row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif (a.attidentity, '') as attidentity,nullif(a.attgenerated, '') as attgenerated, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc, dsc.description, t.typbasetype, t.typtype FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid = c.oid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid = dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid = dsc.classoid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace = dn.oid AND dn.nspname = 'pg_catalog') WHERE c.relkind in ('r', 'p', 'v', 'f', 'm') and a.attnum > 0 AND NOT a.attisdropped AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog') c WHERE true AND attname LIKE '%' ORDER BY nspname, c.relname, attnum;
Date: 2025-10-21 09:33:35 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
13 8ms 2 3ms 5ms 4ms select T.oid as oid, ;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 09 2 8ms 4ms [ User: a3dsupervisor - Total duration: 19ms - Times executed: 2 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 19ms - Times executed: 2 ]
-
select T.oid as oid, ;
Date: 2025-10-21 09:35:41 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
-
select T.oid as oid, ;
Date: 2025-10-21 09:35:41 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
14 8ms 2 0ms 7ms 4ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 09 1 7ms 7ms 13 1 0ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 2 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-10-21 09:34:15 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-10-21 13:20:57 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
15 5ms 2 2ms 3ms 2ms SELECT current_database() AS "TABLE_CAT", n.nspname AS "TABLE_SCHEM", c.relname AS "TABLE_NAME", CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'P' then 'PARTITIONED INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS "TABLE_TYPE", d.description AS "REMARKS", '' as "TYPE_CAT", '' as "TYPE_SCHEM", '' as "TYPE_NAME", '' AS "SELF_REFERENCING_COL_NAME", '' AS "REF_GENERATION" FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0 and d.classoid = 'pg_class'::regclass) WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema') OR (c.relkind = 'p' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME";Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 09 2 5ms 2ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 0ms - Times executed: 2 ]
-
SELECT current_database() AS "TABLE_CAT", n.nspname AS "TABLE_SCHEM", c.relname AS "TABLE_NAME", CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'P' then 'PARTITIONED INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS "TABLE_TYPE", d.description AS "REMARKS", '' as "TYPE_CAT", '' as "TYPE_SCHEM", '' as "TYPE_NAME", '' AS "SELF_REFERENCING_COL_NAME", '' AS "REF_GENERATION" FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0 and d.classoid = 'pg_class'::regclass) WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema') OR (c.relkind = 'p' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME";
Date: 2025-10-21 09:33:22 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
SELECT current_database() AS "TABLE_CAT", n.nspname AS "TABLE_SCHEM", c.relname AS "TABLE_NAME", CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'P' then 'PARTITIONED INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS "TABLE_TYPE", d.description AS "REMARKS", '' as "TYPE_CAT", '' as "TYPE_SCHEM", '' as "TYPE_NAME", '' AS "SELF_REFERENCING_COL_NAME", '' AS "REF_GENERATION" FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0 and d.classoid = 'pg_class'::regclass) WHERE c.relnamespace = n.oid AND n.nspname LIKE 'public' AND c.relname LIKE 'databasechangelog' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema') OR (c.relkind = 'p' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY "TABLE_TYPE", "TABLE_SCHEM", "TABLE_NAME";
Date: 2025-10-21 09:33:35 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
16 5ms 3 0ms 3ms 1ms select O.oid as id, ;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 09 3 5ms 1ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 3 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 3 ]
-
select O.oid as id, ;
Date: 2025-10-21 09:35:43 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
-
select O.oid as id, ;
Date: 2025-10-21 09:35:42 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
-
select O.oid as id, ;
Date: 2025-10-21 09:35:42 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
17 5ms 1 5ms 5ms 5ms select l.oid as id, l.xmin state_number, lanname as name, lanpltrusted as trusted, ;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 09 1 5ms 5ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 1 ]
-
select l.oid as id, l.xmin state_number, lanname as name, lanpltrusted as trusted, ;
Date: 2025-10-21 09:35:41 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
18 4ms 1 4ms 4ms 4ms select fdw.oid as id, ;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 09 1 4ms 4ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 1 ]
-
select fdw.oid as id, ;
Date: 2025-10-21 09:35:40 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
19 4ms 1 4ms 4ms 4ms select C.oid, ;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 09 1 4ms 4ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 1 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 3ms - Times executed: 1 ]
-
select C.oid, ;
Date: 2025-10-21 09:35:41 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
20 4ms 5 0ms 1ms 0ms SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 08 1 1ms 1ms 09 4 2ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 5 ]
[ Application: IntelliJ IDEA 2025.2.3 - Total duration: 0ms - Times executed: 4 ]
[ Application: DBeaver 23.2.0 - Main 'cnrs' - Total duration: 0ms - Times executed: 1 ]
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 08:17:58 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: DBeaver 23.2.0 - Main 'cnrs'
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 09:35:39 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
-
SELECT typinput = 'pg_catalog.array_in'::regproc as is_array, typtype, typname, pg_type.oid FROM pg_catalog.pg_type LEFT JOIN ( select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s (r)) as r using (nspname)) as sp ON sp.nspoid = typnamespace WHERE pg_type.oid = $1 ORDER BY sp.r, pg_type.oid DESC;
Date: 2025-10-21 09:35:44 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: IntelliJ IDEA 2025.2.3
-
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