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:29 - Database: autotest718 - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] ]

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 - Database: autotest718 - User: azuresu - Remote: [local] - Application: [unknown] ]

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:31 - Database: autotest718 - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]

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-17 10:30:11 - Database: autotest718 - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]

SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;

[ Date: 2025-09-17 10:03:47 - Database: autotest718 - User: a3dsupervisor - Remote: 10.3.0.4 - Application: [unknown] - Bind query: yes ]

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:29 - Database: autotest718 - User: azuresu - Remote: 169.254.128.1 - 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;