Times Reported Time consuming queries #1

x Hide

[ User: azuresu - Total duration: 3s487ms - Times executed: 48 ]

x Hide

[ Application: [unknown] - Total duration: 3s487ms - Times executed: 48 ]

x Hide

SELECT pg_catalog.pg_database.datname AS database_name, pg_catalog.pg_database.oid AS database_oid, pg_catalog.pg_database_size(pg_catalog.pg_database.datname) AS database_size_bytes, pg_encoding_to_char(encoding) AS encoding, datcollate, datctype, CASE datlocprovider WHEN 'c' THEN 'libc' WHEN 'i' THEN 'icu' END AS datlocprovider FROM pg_catalog.pg_database;

Date: 2025-10-21 22:03:10
Duration: 213ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT pg_catalog.pg_database.datname AS database_name, pg_catalog.pg_database.oid AS database_oid, pg_catalog.pg_database_size(pg_catalog.pg_database.datname) AS database_size_bytes, pg_encoding_to_char(encoding) AS encoding, datcollate, datctype, CASE datlocprovider WHEN 'c' THEN 'libc' WHEN 'i' THEN 'icu' END AS datlocprovider FROM pg_catalog.pg_database;

Date: 2025-10-21 06:26:44
Duration: 148ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT pg_catalog.pg_database.datname AS database_name, pg_catalog.pg_database.oid AS database_oid, pg_catalog.pg_database_size(pg_catalog.pg_database.datname) AS database_size_bytes, pg_encoding_to_char(encoding) AS encoding, datcollate, datctype, CASE datlocprovider WHEN 'c' THEN 'libc' WHEN 'i' THEN 'icu' END AS datlocprovider FROM pg_catalog.pg_database;

Date: 2025-10-21 18:27:09
Duration: 148ms
Database: postgres
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: 2s174ms - Times executed: 20782 ]

x Hide

[ Application: [unknown] - Total duration: 2s174ms - Times executed: 20782 ]

x Hide

DISCARD ALL;

Date: 2025-10-21 08:23:15
Duration: 3ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]

DISCARD ALL;

Date: 2025-10-21 01:10:59
Duration: 3ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]

DISCARD ALL;

Date: 2025-10-21 09:40:51
Duration: 2ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: azuresu - Total duration: 1s687ms - Times executed: 12718 ]

x Hide

[ Application: psql - Total duration: 1s400ms - Times executed: 3861 ]

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

x Hide

select 1;

Date: 2025-10-21 10:00:19
Duration: 9ms
Database: postgres
User: azuresu
Remote: [local]
Application: psql

select 1;

Date: 2025-10-21 19:50:22
Duration: 4ms
Database: postgres
User: azuresu
Remote: [local]
Application: psql

select 1;

Date: 2025-10-21 23:21:24
Duration: 4ms
Database: postgres
User: azuresu
Remote: [local]
Application: psql

x Hide

Times Reported Time consuming queries #4

x Hide

[ User: azuresu - Total duration: 525ms - Times executed: 528 ]

x Hide

[ Application: [unknown] - Total duration: 525ms - Times executed: 528 ]

x Hide

SELECT name, setting FROM pg_catalog.pg_file_settings where sourcefile =;

Date: 2025-10-21 18:34:24
Duration: 8ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT name, setting FROM pg_catalog.pg_file_settings where sourcefile =;

Date: 2025-10-21 06:34:05
Duration: 8ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT name, setting FROM pg_catalog.pg_file_settings where sourcefile =;

Date: 2025-10-21 07:04:05
Duration: 7ms
Database: postgres
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: 435ms - Times executed: 2801 ]

x Hide

[ Application: [unknown] - Total duration: 435ms - Times executed: 2801 ]

x Hide

SELECT COALESCE(SUM(numbackends), 0) as active_connections FROM pg_catalog.pg_stat_database;

Date: 2025-10-21 14:35:58
Duration: 5ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT COALESCE(SUM(numbackends), 0) as active_connections FROM pg_catalog.pg_stat_database;

Date: 2025-10-21 02:25:52
Duration: 1ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT COALESCE(SUM(numbackends), 0) as active_connections FROM pg_catalog.pg_stat_database;

Date: 2025-10-21 17:53:25
Duration: 1ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #6

x Hide

[ User: azuresu - Total duration: 348ms - Times executed: 289 ]

x Hide

[ Application: [unknown] - Total duration: 348ms - Times executed: 289 ]

x Hide

WITH max_con AS ( SELECT setting::numeric FROM pg_catalog.pg_settings WHERE name = 'max_connections' ) SELECT COALESCE(SUM(numbackends), 0) as active_connections, ROUND(SUM(numbackends) / MAX(setting), 4) AS pct_connections, MAX(setting) AS max_connections FROM pg_catalog.pg_stat_database, max_con;

Date: 2025-10-21 04:51:41
Duration: 3ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

WITH max_con AS ( SELECT setting::numeric FROM pg_catalog.pg_settings WHERE name = 'max_connections' ) SELECT COALESCE(SUM(numbackends), 0) as active_connections, ROUND(SUM(numbackends) / MAX(setting), 4) AS pct_connections, MAX(setting) AS max_connections FROM pg_catalog.pg_stat_database, max_con;

Date: 2025-10-21 22:23:11
Duration: 2ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

WITH max_con AS ( SELECT setting::numeric FROM pg_catalog.pg_settings WHERE name = 'max_connections' ) SELECT COALESCE(SUM(numbackends), 0) as active_connections, ROUND(SUM(numbackends) / MAX(setting), 4) AS pct_connections, MAX(setting) AS max_connections FROM pg_catalog.pg_stat_database, max_con;

Date: 2025-10-21 14:22:00
Duration: 2ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #7

x Hide

[ User: azuresu - Total duration: 243ms - Times executed: 14394 ]

x Hide

[ Application: [unknown] - Total duration: 243ms - Times executed: 14394 ]

x Hide

set session statement_timeout to 10000;

Date: 2025-10-21 14:18:24
Duration: 3ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 10000;

Date: 2025-10-21 10:41:25
Duration: 3ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

set session statement_timeout to 10000;

Date: 2025-10-21 12:01:56
Duration: 3ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #8

x Hide

[ User: azuresu - Total duration: 209ms - Times executed: 8 ]

x Hide

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

x Hide

SELECT version(); SELECT ns.nspname, t.oid, t.typname, t.typtype, t.typnotnull, t.elemtypoid FROM ( -- Arrays have typtype=b - this subquery identifies them by their typreceive and converts their typtype to a -- We first do this for the type (innerest-most subquery), and then for its element type -- This also returns the array element, range subtype and domain base type as elemtypoid SELECT typ.oid, typ.typnamespace, typ.typname, typ.typtype, typ.typrelid, typ.typnotnull, typ.relkind, elemtyp.oid AS elemtypoid, elemtyp.typname AS elemtypname, elemcls.relkind AS elemrelkind, CASE WHEN elemproc.proname = 'array_recv' THEN 'a' ELSE elemtyp.typtype END AS elemtyptype FROM ( SELECT typ.oid, typnamespace, typname, typrelid, typnotnull, relkind, typelem AS elemoid, CASE WHEN proc.proname = 'array_recv' THEN 'a' ELSE typ.typtype END AS typtype, CASE WHEN proc.proname = 'array_recv' THEN typ.typelem WHEN typ.typtype = 'r' THEN rngsubtype WHEN typ.typtype = 'm' THEN ( SELECT rngtypid FROM pg_range WHERE rngmultitypid = typ.oid) WHEN typ.typtype = 'd' THEN typ.typbasetype END AS elemtypoid FROM pg_type AS typ LEFT JOIN pg_class AS cls ON (cls.oid = typ.typrelid) LEFT JOIN pg_proc AS proc ON proc.oid = typ.typreceive LEFT JOIN pg_range ON (pg_range.rngtypid = typ.oid)) AS typ LEFT JOIN pg_type AS elemtyp ON elemtyp.oid = elemtypoid LEFT JOIN pg_class AS elemcls ON (elemcls.oid = elemtyp.typrelid) LEFT JOIN pg_proc AS elemproc ON elemproc.oid = elemtyp.typreceive) AS t JOIN pg_namespace AS ns ON (ns.oid = typnamespace) WHERE typtype IN ('b', 'r', 'm', 'e', 'd') OR -- Base, range, multirange, enum, domain (typtype = 'c' AND relkind = 'c') OR -- User-defined free-standing composites (not table composites) by default (typtype = 'p' AND typname IN ('record', 'void')) OR -- Some special supported pseudo-types (typtype = 'a' AND ( -- Array of... elemtyptype IN ('b', 'r', 'm', 'e', 'd') OR -- Array of base, range, multirange, enum, domain (elemtyptype = 'p' AND elemtypname IN ('record', 'void')) OR -- Arrays of special supported pseudo-types (elemtyptype = 'c' AND elemrelkind = 'c') -- Array of user-defined free-standing composites (not table composites) by default )) ORDER BY CASE WHEN typtype IN ('b', 'e', 'p') THEN 0 -- First base types, enums, pseudo-types WHEN typtype = 'r' THEN 1 -- Ranges after WHEN typtype = 'm' THEN 2 -- Multiranges after WHEN typtype = 'c' THEN 3 -- Composites after WHEN typtype = 'd' AND elemtyptype <> 'a' THEN 4 -- Domains over non-arrays after WHEN typtype = 'a' THEN 5 -- Arrays after WHEN typtype = 'd' AND elemtyptype = 'a' THEN 6 -- Domains over arrays last END; -- Load field definitions for (free-standing) composite types SELECT typ.oid, att.attname, att.atttypid FROM pg_type AS typ JOIN pg_namespace AS ns ON (ns.oid = typ.typnamespace) JOIN pg_class AS cls ON (cls.oid = typ.typrelid) JOIN pg_attribute AS att ON (att.attrelid = typ.typrelid) WHERE (typ.typtype = 'c' AND cls.relkind = 'c') AND attnum > 0 AND -- Don't load system attributes NOT attisdropped ORDER BY typ.oid, att.attnum; -- Load enum fields SELECT pg_type.oid, enumlabel FROM pg_enum JOIN pg_type ON pg_type.oid = enumtypid ORDER BY oid, enumsortorder;

Date: 2025-10-21 21:42:41
Duration: 105ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]

SELECT version(); SELECT ns.nspname, t.oid, t.typname, t.typtype, t.typnotnull, t.elemtypoid FROM ( -- Arrays have typtype=b - this subquery identifies them by their typreceive and converts their typtype to a -- We first do this for the type (innerest-most subquery), and then for its element type -- This also returns the array element, range subtype and domain base type as elemtypoid SELECT typ.oid, typ.typnamespace, typ.typname, typ.typtype, typ.typrelid, typ.typnotnull, typ.relkind, elemtyp.oid AS elemtypoid, elemtyp.typname AS elemtypname, elemcls.relkind AS elemrelkind, CASE WHEN elemproc.proname = 'array_recv' THEN 'a' ELSE elemtyp.typtype END AS elemtyptype FROM ( SELECT typ.oid, typnamespace, typname, typrelid, typnotnull, relkind, typelem AS elemoid, CASE WHEN proc.proname = 'array_recv' THEN 'a' ELSE typ.typtype END AS typtype, CASE WHEN proc.proname = 'array_recv' THEN typ.typelem WHEN typ.typtype = 'r' THEN rngsubtype WHEN typ.typtype = 'm' THEN ( SELECT rngtypid FROM pg_range WHERE rngmultitypid = typ.oid) WHEN typ.typtype = 'd' THEN typ.typbasetype END AS elemtypoid FROM pg_type AS typ LEFT JOIN pg_class AS cls ON (cls.oid = typ.typrelid) LEFT JOIN pg_proc AS proc ON proc.oid = typ.typreceive LEFT JOIN pg_range ON (pg_range.rngtypid = typ.oid)) AS typ LEFT JOIN pg_type AS elemtyp ON elemtyp.oid = elemtypoid LEFT JOIN pg_class AS elemcls ON (elemcls.oid = elemtyp.typrelid) LEFT JOIN pg_proc AS elemproc ON elemproc.oid = elemtyp.typreceive) AS t JOIN pg_namespace AS ns ON (ns.oid = typnamespace) WHERE typtype IN ('b', 'r', 'm', 'e', 'd') OR -- Base, range, multirange, enum, domain (typtype = 'c' AND relkind = 'c') OR -- User-defined free-standing composites (not table composites) by default (typtype = 'p' AND typname IN ('record', 'void')) OR -- Some special supported pseudo-types (typtype = 'a' AND ( -- Array of... elemtyptype IN ('b', 'r', 'm', 'e', 'd') OR -- Array of base, range, multirange, enum, domain (elemtyptype = 'p' AND elemtypname IN ('record', 'void')) OR -- Arrays of special supported pseudo-types (elemtyptype = 'c' AND elemrelkind = 'c') -- Array of user-defined free-standing composites (not table composites) by default )) ORDER BY CASE WHEN typtype IN ('b', 'e', 'p') THEN 0 -- First base types, enums, pseudo-types WHEN typtype = 'r' THEN 1 -- Ranges after WHEN typtype = 'm' THEN 2 -- Multiranges after WHEN typtype = 'c' THEN 3 -- Composites after WHEN typtype = 'd' AND elemtyptype <> 'a' THEN 4 -- Domains over non-arrays after WHEN typtype = 'a' THEN 5 -- Arrays after WHEN typtype = 'd' AND elemtyptype = 'a' THEN 6 -- Domains over arrays last END; -- Load field definitions for (free-standing) composite types SELECT typ.oid, att.attname, att.atttypid FROM pg_type AS typ JOIN pg_namespace AS ns ON (ns.oid = typ.typnamespace) JOIN pg_class AS cls ON (cls.oid = typ.typrelid) JOIN pg_attribute AS att ON (att.attrelid = typ.typrelid) WHERE (typ.typtype = 'c' AND cls.relkind = 'c') AND attnum > 0 AND -- Don't load system attributes NOT attisdropped ORDER BY typ.oid, att.attnum; -- Load enum fields SELECT pg_type.oid, enumlabel FROM pg_enum JOIN pg_type ON pg_type.oid = enumtypid ORDER BY oid, enumsortorder;

Date: 2025-10-21 22:03:08
Duration: 28ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]

SELECT version(); SELECT ns.nspname, t.oid, t.typname, t.typtype, t.typnotnull, t.elemtypoid FROM ( -- Arrays have typtype=b - this subquery identifies them by their typreceive and converts their typtype to a -- We first do this for the type (innerest-most subquery), and then for its element type -- This also returns the array element, range subtype and domain base type as elemtypoid SELECT typ.oid, typ.typnamespace, typ.typname, typ.typtype, typ.typrelid, typ.typnotnull, typ.relkind, elemtyp.oid AS elemtypoid, elemtyp.typname AS elemtypname, elemcls.relkind AS elemrelkind, CASE WHEN elemproc.proname = 'array_recv' THEN 'a' ELSE elemtyp.typtype END AS elemtyptype FROM ( SELECT typ.oid, typnamespace, typname, typrelid, typnotnull, relkind, typelem AS elemoid, CASE WHEN proc.proname = 'array_recv' THEN 'a' ELSE typ.typtype END AS typtype, CASE WHEN proc.proname = 'array_recv' THEN typ.typelem WHEN typ.typtype = 'r' THEN rngsubtype WHEN typ.typtype = 'm' THEN ( SELECT rngtypid FROM pg_range WHERE rngmultitypid = typ.oid) WHEN typ.typtype = 'd' THEN typ.typbasetype END AS elemtypoid FROM pg_type AS typ LEFT JOIN pg_class AS cls ON (cls.oid = typ.typrelid) LEFT JOIN pg_proc AS proc ON proc.oid = typ.typreceive LEFT JOIN pg_range ON (pg_range.rngtypid = typ.oid)) AS typ LEFT JOIN pg_type AS elemtyp ON elemtyp.oid = elemtypoid LEFT JOIN pg_class AS elemcls ON (elemcls.oid = elemtyp.typrelid) LEFT JOIN pg_proc AS elemproc ON elemproc.oid = elemtyp.typreceive) AS t JOIN pg_namespace AS ns ON (ns.oid = typnamespace) WHERE typtype IN ('b', 'r', 'm', 'e', 'd') OR -- Base, range, multirange, enum, domain (typtype = 'c' AND relkind = 'c') OR -- User-defined free-standing composites (not table composites) by default (typtype = 'p' AND typname IN ('record', 'void')) OR -- Some special supported pseudo-types (typtype = 'a' AND ( -- Array of... elemtyptype IN ('b', 'r', 'm', 'e', 'd') OR -- Array of base, range, multirange, enum, domain (elemtyptype = 'p' AND elemtypname IN ('record', 'void')) OR -- Arrays of special supported pseudo-types (elemtyptype = 'c' AND elemrelkind = 'c') -- Array of user-defined free-standing composites (not table composites) by default )) ORDER BY CASE WHEN typtype IN ('b', 'e', 'p') THEN 0 -- First base types, enums, pseudo-types WHEN typtype = 'r' THEN 1 -- Ranges after WHEN typtype = 'm' THEN 2 -- Multiranges after WHEN typtype = 'c' THEN 3 -- Composites after WHEN typtype = 'd' AND elemtyptype <> 'a' THEN 4 -- Domains over non-arrays after WHEN typtype = 'a' THEN 5 -- Arrays after WHEN typtype = 'd' AND elemtyptype = 'a' THEN 6 -- Domains over arrays last END; -- Load field definitions for (free-standing) composite types SELECT typ.oid, att.attname, att.atttypid FROM pg_type AS typ JOIN pg_namespace AS ns ON (ns.oid = typ.typnamespace) JOIN pg_class AS cls ON (cls.oid = typ.typrelid) JOIN pg_attribute AS att ON (att.attrelid = typ.typrelid) WHERE (typ.typtype = 'c' AND cls.relkind = 'c') AND attnum > 0 AND -- Don't load system attributes NOT attisdropped ORDER BY typ.oid, att.attnum; -- Load enum fields SELECT pg_type.oid, enumlabel FROM pg_enum JOIN pg_type ON pg_type.oid = enumtypid ORDER BY oid, enumsortorder;

Date: 2025-10-21 22:03:09
Duration: 26ms
Database: postgres
User: azuresu
Remote: 169.254.128.1
Application: [unknown]