Times Reported Time consuming queries #1

x Hide

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

x Hide

[ Application: [unknown] - Total duration: 218ms - 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-11-11 07:32:23
Duration: 7ms
Database: autotest721
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-11-11 08:02:25
Duration: 6ms
Database: autotest721
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-11-11 21:03:12
Duration: 5ms
Database: autotest721
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: 42ms - Times executed: 1 ]

x Hide

[ Application: [unknown] - Total duration: 42ms - 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-11-11 22:33:18
Duration: 42ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #3

x Hide

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

x Hide

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

x Hide

SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');

Date: 2025-11-11 07:32:23
Duration: 1ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');

Date: 2025-11-11 21:33:14
Duration: 1ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT name AS parameter, setting AS value, min_val AS minimum_value, max_val AS maximum_value, reset_val AS reset_value, pending_restart AS pending_restart, unit AS unit, sourcefile AS source_file FROM pg_settings WHERE name IN ('pgaudit.log', 'pgaudit.log_level', 'pgaudit.log_statement', 'pgaudit.log_statement_once', 'log_checkpoints', 'log_connections', 'log_disconnections', 'password_encryption', 'log_line_prefix', 'require_secure_transport', 'shared_preload_libraries');

Date: 2025-11-11 23:33:21
Duration: 1ms
Database: autotest721
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: 4ms - Times executed: 121 ]

x Hide

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

x Hide

set session statement_timeout to 120000;

Date: 2025-11-11 21:33:14
Duration: 0ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 60000;

Date: 2025-11-11 01:01:59
Duration: 0ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 120000;

Date: 2025-11-11 07:32:23
Duration: 0ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #5

x Hide

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

x Hide

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

x Hide

SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;

Date: 2025-11-11 18:33:03
Duration: 0ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;

Date: 2025-11-11 01:32:01
Duration: 0ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT 'database_access_privilege' AS parameter, has_database_privilege('public', 'postgres', 'CONNECT') AS value UNION ALL SELECT 'schema_access_privilege' AS parameter, has_schema_privilege('public', 'public', 'USAGE') AS value;

Date: 2025-11-11 08:32:28
Duration: 0ms
Database: autotest721
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #6