Redshift Observatory

System Table Tracker

System view pg_catalog.stl_lock version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_lock	block_num	int8
pg_catalog	stl_lock	class_oid	int8
pg_catalog	stl_lock	db_oid	int8
pg_catalog	stl_lock	hold_time_us	int8
pg_catalog	stl_lock	lock_method_id	int4
pg_catalog	stl_lock	lock_mode	int4
pg_catalog	stl_lock	lock_obj_type	int4
pg_catalog	stl_lock	lock_xid	int8
pg_catalog	stl_lock	log_time	timestamp
pg_catalog	stl_lock	object_oid	int8
pg_catalog	stl_lock	object_subid	int4
pg_catalog	stl_lock	pid	int8
pg_catalog	stl_lock	process_type	char(20)
pg_catalog	stl_lock	queue_length	int4
pg_catalog	stl_lock	rel_oid	int8
pg_catalog	stl_lock	wait_time_us	int8
pg_catalog	stl_lock	xid	int8

View Text

SELECT stll_lock.log_time,
       stll_lock.pid,
       stll_lock.process_type,
       stll_lock.xid,
       stll_lock.wait_time_us,
       stll_lock.hold_time_us,
       stll_lock.queue_length,
       stll_lock.lock_mode,
       stll_lock.lock_obj_type,
       stll_lock.lock_method_id,
       stll_lock.db_oid,
       stll_lock.rel_oid,
       stll_lock.block_num,
       stll_lock.lock_xid,
       stll_lock.class_oid,
       stll_lock.object_oid,
       stll_lock.object_subid
FROM stll_lock

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