Redshift Observatory

System Table Tracker

System view pg_catalog.svv_lwlocks version 1.0.59117 / 2023-11-08

schema	name	column	data type
pg_catalog	svv_lwlocks	exclusive_holder_pid	int4
pg_catalog	svv_lwlocks	last_change	timestamp
pg_catalog	svv_lwlocks	lock_id	int4
pg_catalog	svv_lwlocks	lock_name	name
pg_catalog	svv_lwlocks	num_shared_holders	int2
pg_catalog	svv_lwlocks	release_ok	bool

View Text

SELECT l.id AS lock_id,
       l.name AS lock_name,
       l.release_ok,
       l.shared AS num_shared_holders,
       l.exclusive AS exclusive_holder_pid,
       l.last_change
FROM stl_lwlock_status() AS l(id integer,
                              name name,
                              release_ok boolean,
                              shared smallint,
                              exclusive integer,
                              last_change timestamp)

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