Redshift Observatory

System Table Tracker

System view pg_catalog.svv_rls_applied_policy version 1.0.70890 / 2024-07-14

View Text

SELECT rtrim(CAST(pgu.usename AS text)) AS username,
       pqm.query,
       rap.xid,
       rap.pid,
       rap.recordtime,
       rap.command,
       rtrim(CAST(pgd.datname AS text)) AS datname,
       rtrim(CAST(pgn.nspname AS text)) AS relschema,
       rtrim(CAST(pgc.relname AS text)) AS relname,
       rtrim(CAST(pgp.polname AS text)) AS polname,
       rtrim(CAST(rap.poldefault AS text)) AS poldefault,
       rtrim(CAST(rap.relkind AS text)) AS relkind
FROM stl_rls_applied_policy AS rap
     LEFT JOIN pg_class AS pgc ON pgc.oid = CAST(rap.relid AS oid)
     LEFT JOIN pg_namespace AS pgn ON pgn.oid = pgc.relnamespace
     LEFT JOIN pg_policy AS pgp ON pgp.polid = CAST(rap.polid AS oid)
     LEFT JOIN pg_user AS pgu ON pgu.usesysid = rap.userid
     LEFT JOIN pg_database AS pgd ON pgd.oid = CAST(rap.dbid AS oid)
     LEFT JOIN stl_plan_qid_map AS pqm ON pqm.plan_qid = rap.plan_qid
WHERE lower(CAST(rap.policy_provider AS text)) = CAST('redshift' AS text)
   OR rap.policy_provider IS NULL

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers