Redshift Observatory

System Table Tracker

System view pg_catalog.pg_locks version 1.0.50708 / 2023-05-19

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