Redshift Observatory

System Table Tracker

schema	name	column	data type	NN
pg_catalog	stcs_backup_leader	backup_id	char(256)	NN
pg_catalog	stcs_backup_leader	backup_superblock_format	int4	NN
pg_catalog	stcs_backup_leader	backup_superblock_method	int4	NN
pg_catalog	stcs_backup_leader	cluster_id	char(256)	NN
pg_catalog	stcs_backup_leader	__cluster_type	char(4)	NN
pg_catalog	stcs_backup_leader	currenttime	int8	NN
pg_catalog	stcs_backup_leader	enc_key_hash_base64	char(44)	NN
pg_catalog	stcs_backup_leader	error_code	int4	NN
pg_catalog	stcs_backup_leader	error_msg	char(256)	NN
pg_catalog	stcs_backup_leader	inc_no_backup	int8	NN
pg_catalog	stcs_backup_leader	inc_resize_lock_mandatory	int4	NN
pg_catalog	stcs_backup_leader	inc_resize_lock_optional	int4	NN
pg_catalog	stcs_backup_leader	in_progress	int4	NN
pg_catalog	stcs_backup_leader	__log_generated_date	char(8)	NN
pg_catalog	stcs_backup_leader	num_tables	int4	NN
pg_catalog	stcs_backup_leader	partial	int4	NN
pg_catalog	stcs_backup_leader	__path	varchar(2050)	NN
pg_catalog	stcs_backup_leader	sb_version	int8	NN
pg_catalog	stcs_backup_leader	sb_version_stage3	int8	NN
pg_catalog	stcs_backup_leader	__size	int8	NN
pg_catalog	stcs_backup_leader	__spectrum_oid	varchar(128)	NN
pg_catalog	stcs_backup_leader	starttime	int8	NN
pg_catalog	stcs_backup_leader	time_hold_commit_lock	int8	NN
pg_catalog	stcs_backup_leader	time_spent_commit_transaction	int8	NN
pg_catalog	stcs_backup_leader	time_wait_commit_lock	int8	NN
pg_catalog	stcs_backup_leader	tlr_metadata_error_msg	char(256)	NN
pg_catalog	stcs_backup_leader	tlr_metadata_successful	int4	NN
pg_catalog	stcs_backup_leader	tlr_metadata_time	int8	NN