Times Reported Time consuming queries #1

x Hide

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

x Hide

[ Application: pg_dump - Total duration: 43s631ms - 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-08 06:51:22
Duration: 43s631ms
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: 43s269ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 43s269ms - 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-08 06:52:08
Duration: 43s269ms
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: 22s575ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 22s575ms - 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-08 06:51:23
Duration: 22s575ms
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: 17s797ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 17s797ms - 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-08 06:51:00
Duration: 17s797ms
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: 15s186ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 15s186ms - 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-08 06:50:39
Duration: 15s186ms
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: 14s587ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 14s587ms - 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-08 06:51:39
Duration: 14s587ms
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: 9s464ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 9s464ms - 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-08 06:50:21
Duration: 9s464ms
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: 2s323ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 2s323ms - 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-08 06:51:42
Duration: 2s323ms
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: 1s694ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 1s694ms - 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-08 06:51:48
Duration: 1s694ms
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: 1s65ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 1s65ms - 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-08 06:50:41
Duration: 1s65ms
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: 668ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 668ms - 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-08 06:51:39
Duration: 668ms
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: 633ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 633ms - 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-08 06:51:24
Duration: 633ms
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: 452ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 452ms - 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-08 06:50:40
Duration: 452ms
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: 386ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 386ms - 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-08 06:51:43
Duration: 386ms
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: 360ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 360ms - 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-08 06:51:23
Duration: 360ms
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: 301ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 301ms - 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-08 06:51:49
Duration: 301ms
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: 294ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 294ms - 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-08 06:50:42
Duration: 294ms
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: 270ms - Times executed: 5 ]

x Hide

[ Application: [unknown] - Total duration: 270ms - Times executed: 5 ]

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-08 07:42:13
Duration: 54ms
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-08 07:43:06
Duration: 54ms
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-08 08:49:56
Duration: 54ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #19

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 236ms - 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-08 04:31:38
Duration: 8ms
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-08 16:32:21
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-08 12:02:05
Duration: 7ms
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: 205ms - Times executed: 5 ]

x Hide

[ Application: [unknown] - Total duration: 205ms - Times executed: 5 ]

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-08 07:41:40
Duration: 82ms
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-08 07:42:13
Duration: 30ms
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-08 09:52:39
Duration: 30ms
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-08 06:19:26
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 = '2466571'::oid;

Date: 2025-10-08 06:19:26
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 = '2466653'::oid;

Date: 2025-10-08 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: 24ms - Times executed: 126 ]

x Hide

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

x Hide

EXECUTE dumpFunc ('16579');

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

EXECUTE dumpFunc ('16538');

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

EXECUTE dumpFunc ('16564');

Date: 2025-10-08 06:19:25
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: 73 ]

x Hide

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

x Hide

set session statement_timeout to 60000;

Date: 2025-10-08 11:32:04
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-08 15:02:16
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-08 10:31:59
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: 236ms - Times executed: 48 ]

x Hide

[ Application: [unknown] - Total duration: 236ms - 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-08 04:31:38
Duration: 8ms
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-08 16:32:21
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-08 12:02:05
Duration: 7ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #5