Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog pg_locks database oid
pg_catalog pg_locks granted bool
pg_catalog pg_locks mode varchar(256)
pg_catalog pg_locks pid int4
pg_catalog pg_locks relation oid
pg_catalog pg_locks transaction xid

View Text

SELECT l.relation,
       l.database,
       l.transaction,
       l.pid,
       l.mode,
       l.granted
FROM pg_lock_status() AS l(relation oid,
                           database oid,
                           transaction xid,
                           pid integer,
                           mode varchar,
                           granted boolean)


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