Times Reported Time consuming queries #1

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 234ms - 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-24 09:41:48
Duration: 14ms
Database: autotest719
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-24 10:41:52
Duration: 7ms
Database: autotest719
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-24 10:11:50
Duration: 7ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: a3dsupervisor - Total duration: 155ms - Times executed: 11 ]

x Hide

[ Application: [unknown] - Total duration: 155ms - Times executed: 11 ]

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-24 07:13:57
Duration: 19ms
Database: autotest719
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-24 10:11:42
Duration: 18ms
Database: autotest719
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-24 07:27:42
Duration: 13ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: a3dsupervisor - Total duration: 104ms - Times executed: 11 ]

x Hide

[ Application: [unknown] - Total duration: 104ms - Times executed: 11 ]

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-24 10:11:42
Duration: 18ms
Database: autotest719
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-24 07:13:56
Duration: 16ms
Database: autotest719
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-24 08:53:11
Duration: 8ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: a3dsupervisor - Total duration: 89ms - Times executed: 11 ]

x Hide

[ Application: [unknown] - Total duration: 89ms - Times executed: 11 ]

x Hide

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-09-24 07:13:56
Duration: 13ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-09-24 10:11:42
Duration: 13ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

Date: 2025-09-24 07:20:13
Duration: 10ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

[ User: a3dsupervisor - Total duration: 72ms - Times executed: 11 ]

x Hide

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

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-24 07:13:56
Duration: 9ms
Database: autotest719
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-24 07:52:05
Duration: 7ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.1.6
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-24 08:29:41
Duration: 6ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: azuresu - Total duration: 58ms - Times executed: 1 ]

x Hide

[ Application: [unknown] - Total duration: 58ms - Times executed: 1 ]

x Hide

SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;

Date: 2025-09-24 10:41:52
Duration: 58ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: a3dsupervisor - Total duration: 5ms - Times executed: 11 ]

x Hide

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

x Hide

SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();

Date: 2025-09-24 09:32:53
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();

Date: 2025-09-24 07:53:53
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.1.6
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();

Date: 2025-09-24 08:29:41
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: a3dsupervisor - Total duration: 4ms - Times executed: 11 ]

x Hide

[ Application: [unknown] - Total duration: 4ms - Times executed: 11 ]

x Hide

SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';

Date: 2025-09-24 10:11:42
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';

Date: 2025-09-24 07:13:56
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';

Date: 2025-09-24 07:52:41
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.1.6
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #9

x Hide

[ User: azuresu - Total duration: 3ms - Times executed: 24 ]

x Hide

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

x Hide

SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;

Date: 2025-09-24 10:41:52
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;

Date: 2025-09-24 18:42:23
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;

Date: 2025-09-24 07:41:40
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #10

x Hide

[ User: a3dsupervisor - Total duration: 3ms - Times executed: 11 ]

x Hide

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

x Hide

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

Date: 2025-09-24 07:13:56
Duration: 1ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

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

Date: 2025-09-24 10:11:42
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

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

Date: 2025-09-24 08:53:11
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #11

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-09-24 13:12:01
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 60000;

Date: 2025-09-24 06:11:34
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 120000;

Date: 2025-09-24 15:42:10
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #12

x Hide

[ User: a3dsupervisor - Total duration: 2ms - Times executed: 11 ]

x Hide

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

x Hide

SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-09-24 08:29:41
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-09-24 08:53:11
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;

Date: 2025-09-24 07:13:56
Duration: 0ms
Database: autotest719
User: a3dsupervisor
Remote: 10.3.0.4
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #1

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-09-24 13:12:01
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 60000;

Date: 2025-09-24 06:11:34
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 120000;

Date: 2025-09-24 15:42:10
Duration: 0ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #2

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 234ms - 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-24 09:41:48
Duration: 14ms
Database: autotest719
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-24 10:41:52
Duration: 7ms
Database: autotest719
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-24 10:11:50
Duration: 7ms
Database: autotest719
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes