Times Reported Time consuming queries #1

x Hide

[ User: a3dsupervisor - Total duration: 39s572ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 39s572ms - 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-09-26 06:52:55
Duration: 39s572ms
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: 27s888ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 27s888ms - 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-09-26 06:52:24
Duration: 27s888ms
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: 24s594ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 24s594ms - 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-09-26 06:51:41
Duration: 24s594ms
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: 16s378ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 16s378ms - 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-09-26 06:52:15
Duration: 16s378ms
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: 14s422ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 14s422ms - 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-09-26 06:51:17
Duration: 14s422ms
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: 12s445ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 12s445ms - 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-09-26 06:51:56
Duration: 12s445ms
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: 8s434ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 8s434ms - 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-09-26 06:51:00
Duration: 8s434ms
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: 2s398ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 2s398ms - 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-09-26 06:52:27
Duration: 2s398ms
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: 1s603ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 1s603ms - 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-09-26 06:52:30
Duration: 1s603ms
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: 1s74ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 1s74ms - 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-09-26 06:51:58
Duration: 1s74ms
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: 640ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 640ms - 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-09-26 06:52:24
Duration: 640ms
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: 632ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 632ms - 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-09-26 06:51:57
Duration: 632ms
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: 437ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 437ms - 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-09-26 06:52:27
Duration: 437ms
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: 428ms - Times executed: 8 ]

x Hide

[ Application: [unknown] - Total duration: 428ms - Times executed: 8 ]

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-09-26 14:47:20
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-09-26 08:51:45
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-09-26 14:41:24
Duration: 53ms
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: 401ms - Times executed: 1 ]

x Hide

[ Application: pg_dump - Total duration: 401ms - 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-09-26 06:51:43
Duration: 401ms
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: 326ms - Times executed: 8 ]

x Hide

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

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-09-26 12:25:50
Duration: 48ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

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

Date: 2025-09-26 14:41:24
Duration: 40ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

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

Date: 2025-09-26 14:47:20
Duration: 40ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #17

x Hide

[ User: a3dsupervisor - Total duration: 286ms - Times executed: 8 ]

x Hide

[ Application: [unknown] - Total duration: 286ms - Times executed: 8 ]

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-09-26 08:51:45
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-09-26 14:41:24
Duration: 32ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

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

Date: 2025-09-26 08:52:19
Duration: 32ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #18

x Hide

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

x Hide

[ Application: pg_dump - Total duration: 284ms - 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-09-26 06:52:31
Duration: 284ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #19

x Hide

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

x Hide

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

x Hide

COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;

Date: 2025-09-26 06:51:59
Duration: 253ms
Database: cnrs
User: a3dsupervisor
Remote: 10.3.0.4
Application: pg_dump

x Hide

Times Reported Time consuming queries #20

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 226ms - 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-09-26 07:14:34
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-09-26 06:44:33
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-09-26 18:45:16
Duration: 6ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

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

x Hide

[ Application: pg_dump - Total duration: 25ms - 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-09-26 06:19:35
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 = '2466584'::oid;

Date: 2025-09-26 06:19:35
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 = '2466622'::oid;

Date: 2025-09-26 06:19:36
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: 22ms - Times executed: 126 ]

x Hide

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

x Hide

EXECUTE dumpFunc ('16538');

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

EXECUTE dumpFunc ('16579');

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

EXECUTE dumpFunc ('16564');

Date: 2025-09-26 06:19:35
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: 72 ]

x Hide

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

x Hide

set session statement_timeout to 120000;

Date: 2025-09-26 02:44:18
Duration: 0ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 60000;

Date: 2025-09-26 15:15:03
Duration: 0ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 60000;

Date: 2025-09-26 07:14:34
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: 226ms - Times executed: 48 ]

x Hide

[ Application: [unknown] - Total duration: 226ms - 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-09-26 07:14:34
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-09-26 06:44:33
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-09-26 18:45:16
Duration: 6ms
Database: cnrs
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes