Redshift Observatory

System Table Tracker

schema	name	column	data type	NN
pg_catalog	stcs_hash	access_control	int4	NN
pg_catalog	stcs_hash	build_global_hash_table	char(1)	NN
pg_catalog	stcs_hash	bytes	int8	NN
pg_catalog	stcs_hash	checksum	int8	NN
pg_catalog	stcs_hash	__cluster_type	char(4)	NN
pg_catalog	stcs_hash	endtime	int8	NN
pg_catalog	stcs_hash	est_rows	int8	NN
pg_catalog	stcs_hash	is_diskbased	char(1)	NN
pg_catalog	stcs_hash	is_hashed_subplan	char(1)	NN
pg_catalog	stcs_hash	__log_generated_date	char(8)	NN
pg_catalog	stcs_hash	logtime	int8	NN
pg_catalog	stcs_hash	maxlength	int4	NN
pg_catalog	stcs_hash	max_runtime_filter_size	int4	NN
pg_catalog	stcs_hash	memory_usage_ratio	int4	NN
pg_catalog	stcs_hash	num_blocks_permitted	int4	NN
pg_catalog	stcs_hash	num_parts	int4	NN
pg_catalog	stcs_hash	occupied	int4	NN
pg_catalog	stcs_hash	__path	varchar(2050)	NN
pg_catalog	stcs_hash	query	int4	NN
pg_catalog	stcs_hash	resizes	int4	NN
pg_catalog	stcs_hash	rows	int8	NN
pg_catalog	stcs_hash	runtime_filter_size	int4	NN
pg_catalog	stcs_hash	runtime_filter_type	int4	NN
pg_catalog	stcs_hash	segment	int4	NN
pg_catalog	stcs_hash	__size	int8	NN
pg_catalog	stcs_hash	slice	int4	NN
pg_catalog	stcs_hash	slots	int4	NN
pg_catalog	stcs_hash	__spectrum_oid	varchar(128)	NN
pg_catalog	stcs_hash	starttime	int8	NN
pg_catalog	stcs_hash	step	int4	NN
pg_catalog	stcs_hash	tasknum	int4	NN
pg_catalog	stcs_hash	tbl	int4	NN
pg_catalog	stcs_hash	used_mega_block	char(1)	NN
pg_catalog	stcs_hash	used_prefetching	char(1)	NN
pg_catalog	stcs_hash	userid	int4	NN
pg_catalog	stcs_hash	workmem	int8	NN