Redshift Observatory

System Table Tracker

System view pg_catalog.stl_hash version 1.0.78160 / 2024-11-17

schema	name	column	data type
pg_catalog	stl_hash	build_global_hash_table	char(1)
pg_catalog	stl_hash	bytes	int8
pg_catalog	stl_hash	checksum	int8
pg_catalog	stl_hash	endtime	timestamp
pg_catalog	stl_hash	est_rows	int8
pg_catalog	stl_hash	is_diskbased	char(1)
pg_catalog	stl_hash	is_hashed_subplan	char(1)
pg_catalog	stl_hash	logtime	timestamp
pg_catalog	stl_hash	maxlength	int4
pg_catalog	stl_hash	max_runtime_filter_size	int4
pg_catalog	stl_hash	memory_usage_ratio	int4
pg_catalog	stl_hash	num_blocks_permitted	int4
pg_catalog	stl_hash	num_parts	int4
pg_catalog	stl_hash	occupied	int4
pg_catalog	stl_hash	query	int4
pg_catalog	stl_hash	resizes	int4
pg_catalog	stl_hash	rows	int8
pg_catalog	stl_hash	runtime_filter_size	int4
pg_catalog	stl_hash	runtime_filter_type	int4
pg_catalog	stl_hash	segment	int4
pg_catalog	stl_hash	slice	int4
pg_catalog	stl_hash	slots	int4
pg_catalog	stl_hash	starttime	timestamp
pg_catalog	stl_hash	step	int4
pg_catalog	stl_hash	tasknum	int4
pg_catalog	stl_hash	tbl	int4
pg_catalog	stl_hash	used_mega_block	char(1)
pg_catalog	stl_hash	used_prefetching	char(1)
pg_catalog	stl_hash	userid	int4
pg_catalog	stl_hash	workmem	int8

View Text

SELECT stll_hash.userid,
       stll_hash.query,
       stll_hash.slice,
       stll_hash.segment,
       stll_hash.step,
       stll_hash.starttime,
       stll_hash.endtime,
       stll_hash.tasknum,
       stll_hash.rows,
       stll_hash.bytes,
       stll_hash.slots,
       stll_hash.occupied,
       stll_hash.maxlength,
       stll_hash.tbl,
       stll_hash.is_diskbased,
       stll_hash.workmem,
       stll_hash.num_parts,
       stll_hash.est_rows,
       stll_hash.num_blocks_permitted,
       stll_hash.resizes,
       stll_hash.checksum,
       stll_hash.used_prefetching,
       stll_hash.runtime_filter_size,
       stll_hash.max_runtime_filter_size,
       stll_hash.runtime_filter_type,
       stll_hash.is_hashed_subplan,
       stll_hash.build_global_hash_table,
       stll_hash.used_mega_block,
       stll_hash.memory_usage_ratio,
       stll_hash.logtime
FROM stll_hash
WHERE stll_hash.access_control = 0
   OR stll_hash.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Replacement System Tables System Table Tracker The Known Universe Twitter White Papers