Redshift Observatory

System Table Tracker

System view pg_catalog.stl_lwlock version 1.0.75672 / 2024-09-28

schema name column data type
pg_catalog stl_lwlock acquire_wait_us int8
pg_catalog stl_lwlock blocked_by 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 queue_depth int8
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,
       stll_lwlock.blocked_by,
       stll_lwlock.queue_depth
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