Redshift Observatory

System Table Tracker

System view pg_catalog.stl_vacuum_lock_time version 1.0.68540 / 2024-06-05

schema	name	column	data type
pg_catalog	stl_vacuum_lock_time	endtime	timestamp
pg_catalog	stl_vacuum_lock_time	lock_type	int4
pg_catalog	stl_vacuum_lock_time	num_cols	int4
pg_catalog	stl_vacuum_lock_time	optimized	int4
pg_catalog	stl_vacuum_lock_time	query	int4
pg_catalog	stl_vacuum_lock_time	starttime	timestamp
pg_catalog	stl_vacuum_lock_time	tbl_id	int4
pg_catalog	stl_vacuum_lock_time	vac_type	int4
pg_catalog	stl_vacuum_lock_time	xid	int8

View Text

SELECT stll_vacuum_lock_time.xid,
       stll_vacuum_lock_time.query,
       stll_vacuum_lock_time.tbl_id,
       stll_vacuum_lock_time.lock_type,
       stll_vacuum_lock_time.vac_type,
       stll_vacuum_lock_time.starttime,
       stll_vacuum_lock_time.endtime,
       stll_vacuum_lock_time.num_cols,
       stll_vacuum_lock_time.optimized
FROM stll_vacuum_lock_time

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