Redshift Observatory

System Table Tracker

System view pg_catalog.stl_lwlock version 1.0.56754 / 2023-09-21

schema	name	column	data type
pg_catalog	stl_lwlock	acquire_wait_us	int8
pg_catalog	stl_lwlock	hold_time_us	int8
pg_catalog	stl_lwlock	log_time	timestamp
pg_catalog	stl_lwlock	lwlockid	int4
pg_catalog	stl_lwlock	lwlock_name	char(50)
pg_catalog	stl_lwlock	mode	char(25)
pg_catalog	stl_lwlock	num_spinlock_waits	int8
pg_catalog	stl_lwlock	pid	int4
pg_catalog	stl_lwlock	spinlock_max_wait_us	int8

View Text

SELECT stll_lwlock.log_time,
       stll_lwlock.pid,
       stll_lwlock.lwlockid,
       stll_lwlock.lwlock_name,
       stll_lwlock.mode,
       stll_lwlock.acquire_wait_us,
       stll_lwlock.spinlock_max_wait_us,
       stll_lwlock.num_spinlock_waits,
       stll_lwlock.hold_time_us
FROM stll_lwlock

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