Times Reported Time consuming queries #1

x Hide

[ User: azuresu - Total duration: 295ms - Times executed: 2 ]

x Hide

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

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-09-17 10:00:26
Duration: 283ms
Database: template1
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-09-17 10:18:03
Duration: 11ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]

x Hide

Times Reported Time consuming queries #2

x Hide

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

x Hide

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

x Hide

WITH RECURSIVE oids AS ( SELECT t.oid FROM pg_catalog.pg_type t LEFT JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE typtype = 'c' AND (t.oid < 16384 OR nspname = 'information_schema') UNION ALL SELECT * FROM ( WITH x AS ( SELECT oid FROM oids ) SELECT t.oid FROM pg_catalog.pg_type t, x WHERE typbasetype = x.oid AND typtype = 'd' UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, x WHERE typelem = x.oid AND typtype = 'b' UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, pg_catalog.pg_class c, pg_catalog.pg_attribute a, x WHERE t.typtype = 'c' AND t.oid = c.reltype AND c.oid = a.attrelid AND NOT a.attisdropped AND a.atttypid = x.oid UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, pg_catalog.pg_range r, x WHERE t.typtype = 'r' AND r.rngtypid = t.oid AND r.rngsubtype = x.oid) foo ) SELECT n.nspname, c.relname, a.attname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n, pg_catalog.pg_attribute a WHERE c.oid = a.attrelid AND NOT a.attisdropped AND a.atttypid IN ( SELECT oid FROM oids) AND c.relkind IN ('r', 'm', 'i') AND c.relnamespace = n.oid AND n.nspname !~ '^pg_temp_' AND n.nspname !~ '^pg_toast_temp_' AND n.nspname NOT IN ('pg_catalog', 'information_schema');

Date: 2025-09-17 10:06:19
Duration: 24ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #3

x Hide

[ User: azuresu - Total duration: 17ms - Times executed: 4 ]

x Hide

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

x Hide

SELECT extension.name, extension.installed_version IS NOT NULL AS installed, extension.default_version, extension.installed_version, current_database() as databaseFROM pg_available_extensions extensionORDER BY extension.name ASC;

Date: 2025-09-17 10:00:26
Duration: 6ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT extension.name, extension.installed_version IS NOT NULL AS installed, extension.default_version, extension.installed_version, current_database() as databaseFROM pg_available_extensions extensionORDER BY extension.name ASC;

Date: 2025-09-17 10:18:04
Duration: 3ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT extension.name, extension.installed_version IS NOT NULL AS installed, extension.default_version, extension.installed_version, current_database() as databaseFROM pg_available_extensions extensionORDER BY extension.name ASC;

Date: 2025-09-17 10:00:30
Duration: 3ms
Database: template1
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: 15ms - Times executed: 1 ]

x Hide

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

x Hide

SELECT count(*) FROM pg_catalog.pg_class class, pg_catalog.pg_attribute attr, pg_catalog.pg_namespace ns, pg_catalog.pg_roles rolWHERE attr.atttypid IN ('pg_catalog.regcollation'::pg_catalog.regtype, 'pg_catalog.regconfig'::pg_catalog.regtype, 'pg_catalog.regdictionary'::pg_catalog.regtype, 'pg_catalog.regnamespace'::pg_catalog.regtype, 'pg_catalog.regoper'::pg_catalog.regtype, 'pg_catalog.regoperator'::pg_catalog.regtype, 'pg_catalog.regproc'::pg_catalog.regtype, 'pg_catalog.regprocedure'::pg_catalog.regtype) AND ns.nspname NOT IN ('pg_catalog', 'information_schema') AND class.oid = attr.attrelid AND class.relnamespace = ns.oid AND rol.oid = class.relowner AND NOT attr.attisdropped AND NOT (class.relname IN ('pg_masking_rules', 'pg_masks') and rol.rolname = 'azuresu' and atttypid = 'pg_catalog.regnamespace'::pg_catalog.regtype);

Date: 2025-09-17 10:00:26
Duration: 15ms
Database: template1
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: 11ms - Times executed: 1 ]

x Hide

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

x Hide

WITH target_oids AS ( SELECT oid FROM pg_class WHERE relname = 'pg_stat_activity' ) SELECT COUNT(*) OVER () AS total_count, c.relname AS view_name, n.nspname AS schema_name, current_database() AS database_nameFROM pg_depend dJOIN pg_rewrite r ON d.objid = r.oidJOIN pg_class c ON r.ev_class = c.oidJOIN pg_namespace n ON c.relnamespace = n.oidWHERE d.refobjid IN ( SELECT oid FROM target_oids) AND c.relkind = 'v' AND n.nspname NOT IN ('pg_catalog', 'information_schema');

Date: 2025-09-17 10:00:30
Duration: 11ms
Database: template1
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: 11ms - Times executed: 1 ]

x Hide

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

x Hide

WITH regular_heap ( reloid, indtable, toastheap ) AS ( SELECT c.oid, 0::oid, 0::oid FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid WHERE relkind IN ('r', 'm') AND ((n.nspname !~ '^pg_temp_' AND n.nspname !~ '^pg_toast_temp_' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'binary_upgrade', 'pg_toast') AND c.oid >= 16384::pg_catalog.oid) OR (n.nspname = 'pg_catalog' AND relname IN ('pg_largeobject'))) ), toast_heap ( reloid, indtable, toastheap ) AS ( SELECT c.reltoastrelid, 0::oid, c.oid FROM regular_heap JOIN pg_catalog.pg_class c ON regular_heap.reloid = c.oid WHERE c.reltoastrelid != 0 ), all_index ( reloid, indtable, toastheap ) AS ( SELECT indexrelid, indrelid, 0::oid FROM pg_catalog.pg_index WHERE indisvalid AND indisready AND indrelid IN ( SELECT reloid FROM regular_heap UNION ALL SELECT reloid FROM toast_heap)) SELECT all_rels.*, n.nspname, c.relname, c.relfilenode, c.reltablespace, pg_catalog.pg_tablespace_location(t.oid) AS spclocation FROM ( SELECT * FROM regular_heap UNION ALL SELECT * FROM toast_heap UNION ALL SELECT * FROM all_index) all_rels JOIN pg_catalog.pg_class c ON all_rels.reloid = c.oid JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid LEFT OUTER JOIN pg_catalog.pg_tablespace t ON c.reltablespace = t.oid ORDER BY 1;

Date: 2025-09-17 10:06:18
Duration: 11ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #7

x Hide

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

x Hide

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

x Hide

WITH init_privs AS ( SELECT DISTINCT classoid, objoid, objsubid, /* * initprivs is an array, with elements in format: * '[$user]=$Perm/$grantor', where $grantor could be double-quoted. * Therefore we first unnest, then extract grantor using regexp (it * also handles first and last double-quote symbols, if there are * any), and finally replace two double-quotes with a single one. */ replace((regexp_matches(unnest(initprivs)::text, '.*/"{0,1}(.*?)"{0,1}'))[1], '""', '"') as grantor FROM pg_init_privs WHERE privtype = 'e' /* we are interested only in extension objects */ ), all_privs AS ( /* * Depending on classoid we need to join with respective catalog tables to * find the object owner. List of tables is taken from getAdditionalACLs() * function in pg_dump.c file. * Besides that we extract a schema OID from the object, to check later * that required grantor from pg_init_privs has access to the schema. */ SELECT c.relnamespace AS namespace, i.*, relowner AS owner FROM init_privs i JOIN pg_class AS c ON i.classoid = 1259 AND c.oid = i.objoid UNION ALL SELECT t.typnamespace, i.*, t.typowner FROM init_privs i JOIN pg_type AS t ON i.classoid = 1247 AND t.oid = i.objoid UNION ALL SELECT 0, i.*, fdw.fdwowner FROM init_privs i JOIN pg_foreign_data_wrapper AS fdw ON i.classoid = 2328 AND fdw.oid = i.objoid UNION ALL SELECT 0, i.*, fs.srvowner FROM init_privs i JOIN pg_foreign_server AS fs ON i.classoid = 1417 AND fs.oid = i.objoid UNION ALL SELECT p.pronamespace, i.*, p.proowner FROM init_privs i JOIN pg_proc AS p ON i.classoid = 1255 AND p.oid = i.objoid UNION ALL SELECT 0, i.*, l.lanowner FROM init_privs i JOIN pg_language AS l ON i.classoid = 2612 AND l.oid = i.objoid UNION ALL SELECT 0, i.*, n.nspowner FROM init_privs i JOIN pg_namespace n ON i.classoid = 2615 AND n.oid = i.objoid ) SELECT pg_describe_object(classoid, objoid, objsubid), current_database() as database FROM all_privs /* * pg_dump/pg_restore creates an object and immediately changes the owner. * Later, when pg_init_privs are restored, the following happens: * ``` * SELECT pg_catalog.binary_upgrade_set_record_init_privs(true); * REVOKE ALL ON $object FROM $user; * SET SESSION AUTHORIZATION $grantor; * GRANT $permission ON $object TO $grantee;; * RESET SESSION AUTHORIZATION; * SELECT pg_catalog.binary_upgrade_set_record_init_privs(false); * ``` * Therefore we need to check only two things: * - $grantor has role privilege of object owner * - $grantor has USAGE on SCHEMA where object exists */ WHERE NOT pg_has_role(grantor, owner, 'USAGE') OR namespace <> 0 AND NOT has_schema_privilege(grantor, namespace, 'USAGE');

Date: 2025-09-17 10:00:26
Duration: 9ms
Database: template1
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: 9ms - Times executed: 1 ]

x Hide

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

x Hide

SELECT d.oid, d.datname, d.encoding, d.datcollate, d.datctype, datlocprovider, daticulocale AS datlocale, pg_catalog.pg_tablespace_location(t.oid) AS spclocation FROM pg_catalog.pg_database d LEFT OUTER JOIN pg_catalog.pg_tablespace t ON d.dattablespace = t.oid WHERE d.datallowconn = true ORDER BY 1;

Date: 2025-09-17 10:06:18
Duration: 9ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #9

x Hide

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

x Hide

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

x Hide

WITH RECURSIVE oids AS ( SELECT oid FROM pg_catalog.pg_type t WHERE t.typnamespace = ( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = 'pg_catalog') AND t.typname IN ('regcollation', 'regconfig', 'regdictionary', 'regnamespace', 'regoper', 'regoperator', 'regproc', 'regprocedure') UNION ALL SELECT * FROM ( WITH x AS ( SELECT oid FROM oids ) SELECT t.oid FROM pg_catalog.pg_type t, x WHERE typbasetype = x.oid AND typtype = 'd' UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, x WHERE typelem = x.oid AND typtype = 'b' UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, pg_catalog.pg_class c, pg_catalog.pg_attribute a, x WHERE t.typtype = 'c' AND t.oid = c.reltype AND c.oid = a.attrelid AND NOT a.attisdropped AND a.atttypid = x.oid UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, pg_catalog.pg_range r, x WHERE t.typtype = 'r' AND r.rngtypid = t.oid AND r.rngsubtype = x.oid) foo ) SELECT n.nspname, c.relname, a.attname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n, pg_catalog.pg_attribute a WHERE c.oid = a.attrelid AND NOT a.attisdropped AND a.atttypid IN ( SELECT oid FROM oids) AND c.relkind IN ('r', 'm', 'i') AND c.relnamespace = n.oid AND n.nspname !~ '^pg_temp_' AND n.nspname !~ '^pg_toast_temp_' AND n.nspname NOT IN ('pg_catalog', 'information_schema');

Date: 2025-09-17 10:06:19
Duration: 7ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #10

x Hide

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

x Hide

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

x Hide

SELECT * FROM pg_catalog.pg_prepared_xacts;

Date: 2025-09-17 10:06:19
Duration: 6ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #11

x Hide

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

x Hide

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

x Hide

SELECT pg_catalog.set_config('search_path', '', false);

Date: 2025-09-17 10:06:18
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

SELECT pg_catalog.set_config('search_path', '', false);

Date: 2025-09-17 10:06:18
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

SELECT pg_catalog.set_config('search_path', '', false);

Date: 2025-09-17 10:06:19
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #12

x Hide

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

x Hide

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

x Hide

SELECT DISTINCT probin FROM pg_catalog.pg_proc WHERE prolang = 13 AND probin IS NOT NULL AND oid >= 16384;

Date: 2025-09-17 10:06:19
Duration: 3ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #13

x Hide

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

x Hide

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

x Hide

SELECT rolsuper, oid FROM pg_catalog.pg_roles WHERE rolname = current_user AND rolname !~ '^pg_';

Date: 2025-09-17 10:06:19
Duration: 1ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #14

x Hide

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

x Hide

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

x Hide

ALTER EXTENSION "plpgsql" UPDATE;

Date: 2025-09-17 10:18:04
Duration: 0ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

ALTER EXTENSION "plpgsql" UPDATE;

Date: 2025-09-17 10:00:55
Duration: 0ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #15

x Hide

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

x Hide

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

x Hide

SELECT encoding, datlocprovider, datcollate, datctype, daticulocale AS datlocale FROM pg_catalog.pg_database WHERE datname = 'template0';

Date: 2025-09-17 10:06:18
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #16

x Hide

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

x Hide

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

x Hide

SELECT pg_catalog.pg_tablespace_location(oid) AS spclocation FROM pg_catalog.pg_tablespace WHERE spcname != 'pg_default' AND spcname != 'pg_global';

Date: 2025-09-17 10:06:19
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #17

x Hide

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

x Hide

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

x Hide

SELECT e.extname AS name, n.nspname AS schema, current_database() as databaseFROM pg_extension eJOIN pg_namespace n ON e.extnamespace = n.oidWHERE e.extname LIKE 'postgis%' or e.extname LIKE 'address%' or e.extname LIKE 'fuzzystrmatch';

Date: 2025-09-17 10:00:26
Duration: 0ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #18

x Hide

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

x Hide

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

x Hide

SELECT datname, datallowconn FROM pg_catalog.pg_database;

Date: 2025-09-17 10:06:19
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #19

x Hide

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

x Hide

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

x Hide

SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_';

Date: 2025-09-17 10:06:19
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #20

x Hide

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

x Hide

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

x Hide

SELECT count(*) AS count, current_database() AS datname FROM pg_catalog.pg_event_trigger pgevtJOIN pg_roles pgr on pgevt.evtowner = pgr.oidWHERE pgr.rolsuper = 'f';

Date: 2025-09-17 10:00:26
Duration: 0ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

x Hide

Times Reported Time consuming queries #1

x Hide

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

x Hide

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

x Hide

SELECT pg_catalog.set_config('search_path', '', false);

Date: 2025-09-17 10:06:18
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

SELECT pg_catalog.set_config('search_path', '', false);

Date: 2025-09-17 10:06:18
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

SELECT pg_catalog.set_config('search_path', '', false);

Date: 2025-09-17 10:06:19
Duration: 0ms
Database: template1
User: azuresu
Remote: [local]
Application: [unknown]

x Hide

Times Reported Time consuming queries #2

x Hide

[ User: azuresu - Total duration: 17ms - Times executed: 4 ]

x Hide

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

x Hide

SELECT extension.name, extension.installed_version IS NOT NULL AS installed, extension.default_version, extension.installed_version, current_database() as databaseFROM pg_available_extensions extensionORDER BY extension.name ASC;

Date: 2025-09-17 10:00:26
Duration: 6ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT extension.name, extension.installed_version IS NOT NULL AS installed, extension.default_version, extension.installed_version, current_database() as databaseFROM pg_available_extensions extensionORDER BY extension.name ASC;

Date: 2025-09-17 10:18:04
Duration: 3ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]
Bind query: yes

SELECT extension.name, extension.installed_version IS NOT NULL AS installed, extension.default_version, extension.installed_version, current_database() as databaseFROM pg_available_extensions extensionORDER BY extension.name ASC;

Date: 2025-09-17 10:00:30
Duration: 3ms
Database: template1
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: 295ms - Times executed: 2 ]

x Hide

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

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-09-17 10:00:26
Duration: 283ms
Database: template1
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-09-17 10:18:03
Duration: 11ms
Database: template1
User: azuresu
Remote: 169.254.128.1
Application: [unknown]