Times Reported Time consuming queries #1

x Hide

[ User: a3dsupervisor - Total duration: 34s434ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 34s434ms - Times executed: 1 ]

x Hide

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-10 06:53:23
Duration: 34s434ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: a3dsupervisor - Total duration: 29s547ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 29s547ms - Times executed: 1 ]

x Hide

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-10 06:52:06
Duration: 29s547ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: a3dsupervisor - Total duration: 16s566ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 16s566ms - Times executed: 1 ]

x Hide

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-10 06:52:38
Duration: 16s566ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: a3dsupervisor - Total duration: 15s164ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 15s164ms - Times executed: 1 ]

x Hide

COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;

Date: 2025-10-10 06:51:36
Duration: 15s164ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: a3dsupervisor - Total duration: 12s846ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 12s846ms - Times executed: 1 ]

x Hide

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-10 06:52:21
Duration: 12s846ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: a3dsupervisor - Total duration: 8s456ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 8s456ms - Times executed: 1 ]

x Hide

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-10 06:51:19
Duration: 8s456ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: a3dsupervisor - Total duration: 8s107ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 8s107ms - Times executed: 1 ]

x Hide

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-10 06:52:48
Duration: 8s107ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: a3dsupervisor - Total duration: 1s284ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 1s284ms - Times executed: 1 ]

x Hide

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-10 06:53:25
Duration: 1s284ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: a3dsupervisor - Total duration: 877ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 877ms - Times executed: 1 ]

x Hide

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-10 06:53:27
Duration: 877ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #10

x Hide

[ User: a3dsupervisor - Total duration: 572ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 572ms - Times executed: 1 ]

x Hide

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-10 06:52:40
Duration: 572ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #11

x Hide

[ User: a3dsupervisor - Total duration: 500ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 500ms - Times executed: 1 ]

x Hide

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-10 06:52:07
Duration: 500ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #12

x Hide

[ User: a3dsupervisor - Total duration: 386ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 386ms - Times executed: 1 ]

x Hide

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-10 06:51:20
Duration: 386ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #13

x Hide

[ User: a3dsupervisor - Total duration: 385ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 385ms - Times executed: 1 ]

x Hide

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-10 06:53:23
Duration: 385ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #14

x Hide

[ User: a3dsupervisor - Total duration: 326ms - Times executed: 6 ]

x Hide

[ Application: [unknown] - Total duration: 326ms - Times executed: 6 ]

x Hide

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-10-10 13:34:45
Duration: 55ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-10-10 08:53:39
Duration: 55ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-10-10 15:29:39
Duration: 54ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #15

x Hide

[ User: a3dsupervisor - Total duration: 325ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 325ms - Times executed: 1 ]

x Hide

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-10 06:52:39
Duration: 325ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #16

x Hide

[ User: a3dsupervisor - Total duration: 302ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 302ms - Times executed: 1 ]

x Hide

COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;

Date: 2025-10-10 06:52:07
Duration: 302ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #17

x Hide

[ User: a3dsupervisor - Total duration: 241ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 241ms - Times executed: 1 ]

x Hide

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-10 06:52:08
Duration: 241ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #18

x Hide

[ User: azuresu - Total duration: 240ms - Times executed: 48 ]

x Hide

[ Application: [unknown] - Total duration: 240ms - Times executed: 48 ]

x Hide

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-10 05:34:33
Duration: 14ms
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-10 07:04:39
Duration: 7ms
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-10 06:34:37
Duration: 7ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #19

x Hide

[ User: a3dsupervisor - Total duration: 236ms - Times executed: 6 ]

x Hide

[ Application: [unknown] - Total duration: 236ms - Times executed: 6 ]

x Hide

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-10-10 14:32:59
Duration: 41ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-10-10 08:53:39
Duration: 39ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';

Date: 2025-10-10 15:29:39
Duration: 39ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #20

x Hide

[ User: a3dsupervisor - Total duration: 204ms - Times executed: 6 ]

x Hide

[ Application: [unknown] - Total duration: 204ms - Times executed: 6 ]

x Hide

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-10-10 08:53:39
Duration: 68ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-10-10 13:34:45
Duration: 27ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');

Date: 2025-10-10 15:29:39
Duration: 27ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: a3dsupervisor - Total duration: 26ms - Times executed: 164 ]

x Hide

[ Application: pg_dump - Total duration: 26ms - Times executed: 164 ]

x Hide

SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2648852'::oid;

Date: 2025-10-10 06:19:20
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 = '2465753'::oid;

Date: 2025-10-10 06:19:20
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 = '2466640'::oid;

Date: 2025-10-10 06:19:20
Duration: 0ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: a3dsupervisor - Total duration: 23ms - Times executed: 126 ]

x Hide

[ Application: pg_dump - Total duration: 23ms - Times executed: 126 ]

x Hide

EXECUTE dumpFunc ('16579');

Date: 2025-10-10 06:19:19
Duration: 1ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

EXECUTE dumpFunc ('16538');

Date: 2025-10-10 06:19:19
Duration: 1ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

EXECUTE dumpFunc ('16564');

Date: 2025-10-10 06:19:19
Duration: 0ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: azuresu - Total duration: 2ms - Times executed: 72 ]

x Hide

[ Application: [unknown] - Total duration: 2ms - Times executed: 72 ]

x Hide

set session statement_timeout to 60000;

Date: 2025-10-10 12:34:58
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-10 19:05:22
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-10 19:35:23
Duration: 0ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: a3dsupervisor - Total duration: 14ms - Times executed: 55 ]

x Hide

[ Application: [unknown] - Total duration: 14ms - Times executed: 55 ]

x Hide

SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;

Date: 2025-10-10 08:48:54
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-10 06:54:37
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-10 07:38:03
Duration: 0ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: azuresu - Total duration: 240ms - Times executed: 48 ]

x Hide

[ Application: [unknown] - Total duration: 240ms - Times executed: 48 ]

x Hide

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-10 05:34:33
Duration: 14ms
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-10 07:04:39
Duration: 7ms
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-10 06:34:37
Duration: 7ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes