Redshift Observatory

System Table Tracker

schema	name	column	data type	NN
pg_catalog	stcs_query_detail	alert	char(1024)	NN
pg_catalog	stcs_query_detail	blocks_read	int8	NN
pg_catalog	stcs_query_detail	blocks_write	int8	NN
pg_catalog	stcs_query_detail	child_query_id	int4	NN
pg_catalog	stcs_query_detail	child_query_sequence	int4	NN
pg_catalog	stcs_query_detail	__cluster_type	char(4)	NN
pg_catalog	stcs_query_detail	cpu_time	int8	NN
pg_catalog	stcs_query_detail	endtime	int8	NN
pg_catalog	stcs_query_detail	input_bytes	int8	NN
pg_catalog	stcs_query_detail	input_rows	int8	NN
pg_catalog	stcs_query_detail	internal_query	char(1)	NN
pg_catalog	stcs_query_detail	is_rrscan	char(1)	NN
pg_catalog	stcs_query_detail	local_read_io	int8	NN
pg_catalog	stcs_query_detail	__log_generated_date	char(8)	NN
pg_catalog	stcs_query_detail	output_bytes	int8	NN
pg_catalog	stcs_query_detail	output_rows	int8	NN
pg_catalog	stcs_query_detail	__path	varchar(2050)	NN
pg_catalog	stcs_query_detail	query_id	int8	NN
pg_catalog	stcs_query_detail	remote_read_io	int8	NN
pg_catalog	stcs_query_detail	segment_id	int4	NN
pg_catalog	stcs_query_detail	__size	int8	NN
pg_catalog	stcs_query_detail	slice	int4	NN
pg_catalog	stcs_query_detail	source	char(64)	NN
pg_catalog	stcs_query_detail	__spectrum_oid	varchar(128)	NN
pg_catalog	stcs_query_detail	starttime	int8	NN
pg_catalog	stcs_query_detail	step_id	int4	NN
pg_catalog	stcs_query_detail	step_name	int4	NN
pg_catalog	stcs_query_detail	stream_id	int4	NN
pg_catalog	stcs_query_detail	table_id	int4	NN
pg_catalog	stcs_query_detail	table_name	char(136)	NN
pg_catalog	stcs_query_detail	user_id	int4	NN