Times Reported Time consuming queries #1

x Hide

[ User: a3dsupervisor - Total duration: 45s627ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 45s627ms - 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-24 06:53:42
Duration: 45s627ms
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: 43s345ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 43s345ms - 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-24 06:54:32
Duration: 43s345ms
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: 25s820ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 25s820ms - 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-24 06:53:46
Duration: 25s820ms
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: 17s274ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 17s274ms - 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-24 06:53:02
Duration: 17s274ms
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: 16s56ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 16s56ms - 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-24 06:53:21
Duration: 16s56ms
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: 12s992ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 12s992ms - 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-24 06:53:59
Duration: 12s992ms
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: 11s827ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 11s827ms - 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-24 06:52:41
Duration: 11s827ms
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: 2s401ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 2s401ms - 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-24 06:54:02
Duration: 2s401ms
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: 1s918ms - Times executed: 33 ]

x Hide

[ Application: [unknown] - Total duration: 1s918ms - Times executed: 33 ]

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-24 05:33:36
Duration: 80ms
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-24 05:05:39
Duration: 72ms
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-24 06:42:10
Duration: 70ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

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

x Hide

[ Application: pg_dump - Total duration: 1s631ms - 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-24 06:54:06
Duration: 1s631ms
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: 1s308ms - Times executed: 33 ]

x Hide

[ Application: [unknown] - Total duration: 1s308ms - Times executed: 33 ]

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-24 06:31:04
Duration: 45ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

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

Date: 2025-10-24 06:42:12
Duration: 44ms
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-24 06:30:17
Duration: 41ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #12

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 1s164ms - Times executed: 33 ]

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-24 07:22:54
Duration: 84ms
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-24 06:42:10
Duration: 83ms
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-24 06:30:17
Duration: 72ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #13

x Hide

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

x Hide

[ Application: pg_dump - Total duration: 795ms - 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-24 06:53:03
Duration: 795ms
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: 720ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 720ms - 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-24 06:54:00
Duration: 720ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #15

x Hide

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

x Hide

[ Application: pg_dump - Total duration: 484ms - 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-24 06:53:45
Duration: 484ms
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: 431ms - Times executed: 1 ]

x Hide

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

x Hide

COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;

Date: 2025-10-24 06:54:03
Duration: 431ms
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: 342ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 342ms - 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-24 06:53:03
Duration: 342ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #18

x Hide

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

x Hide

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

x Hide

COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;

Date: 2025-10-24 06:54:07
Duration: 280ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #19

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 225ms - 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-24 06:36:32
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-24 07:06:33
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-24 17:07:09
Duration: 6ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #20

x Hide

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

x Hide

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

x Hide

COPY public.gtp_log_thread (log_thread_num_id, server_id, log_date, new_min, new_average, new_max, runnable_min, runnable_average, runnable_max, blocked_min, blocked_average, blocked_max, waiting_min, waiting_average, waiting_max, timed_waiting_min, timed_waiting_average, timed_waiting_max, terminated_min, terminated_average, terminated_max) TO stdout;

Date: 2025-10-24 06:53:48
Duration: 224ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #1

x Hide

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

x Hide

[ Application: pg_dump - Total duration: 29ms - 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-24 06:19:25
Duration: 7ms
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 = '2466568'::oid;

Date: 2025-10-24 06:19:25
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 = '2466679'::oid;

Date: 2025-10-24 06:19:26
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: 21ms - Times executed: 126 ]

x Hide

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

x Hide

EXECUTE dumpFunc ('16538');

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

EXECUTE dumpFunc ('16610');

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

EXECUTE dumpFunc ('16564');

Date: 2025-10-24 06:19:24
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: 3ms - Times executed: 120 ]

x Hide

[ Application: [unknown] - Total duration: 3ms - Times executed: 120 ]

x Hide

set session statement_timeout to 120000;

Date: 2025-10-24 12:06:52
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-24 20:07:20
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-24 23:37:32
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: azuresu - Total duration: 225ms - Times executed: 48 ]

x Hide

[ Application: [unknown] - Total duration: 225ms - 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-24 06:36:32
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-24 07:06:33
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-24 17:07:09
Duration: 6ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes