Redshift Observatory

System Table Tracker

System view pg_catalog.stl_backup_leader version 1.0.76832 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_backup_leader	backup_id	char(256)
pg_catalog	stl_backup_leader	backup_superblock_format	int4
pg_catalog	stl_backup_leader	backup_superblock_method	int4
pg_catalog	stl_backup_leader	cluster_id	char(256)
pg_catalog	stl_backup_leader	currenttime	timestamp
pg_catalog	stl_backup_leader	db_metadata_size	int4
pg_catalog	stl_backup_leader	enc_key_hash_base64	char(44)
pg_catalog	stl_backup_leader	error_code	int4
pg_catalog	stl_backup_leader	error_msg	char(256)
pg_catalog	stl_backup_leader	inc_no_backup	int8
pg_catalog	stl_backup_leader	inc_resize_lock_mandatory	int4
pg_catalog	stl_backup_leader	inc_resize_lock_optional	int4
pg_catalog	stl_backup_leader	in_progress	int4
pg_catalog	stl_backup_leader	manifest_compress_level	int4
pg_catalog	stl_backup_leader	num_tables	int4
pg_catalog	stl_backup_leader	partial	int4
pg_catalog	stl_backup_leader	s3commit_aware_backup	int4
pg_catalog	stl_backup_leader	sb_version	int8
pg_catalog	stl_backup_leader	sb_version_stage3	int8
pg_catalog	stl_backup_leader	starttime	timestamp
pg_catalog	stl_backup_leader	table_schema_size	int4
pg_catalog	stl_backup_leader	time_hold_commit_lock	int8
pg_catalog	stl_backup_leader	time_spent_commit_transaction	int8
pg_catalog	stl_backup_leader	time_wait_commit_lock	int8
pg_catalog	stl_backup_leader	tlr_metadata_error_msg	char(256)
pg_catalog	stl_backup_leader	tlr_metadata_successful	int4
pg_catalog	stl_backup_leader	tlr_metadata_time	int8

View Text

SELECT stll_backup_leader.currenttime,
       stll_backup_leader.backup_id,
       stll_backup_leader.sb_version,
       stll_backup_leader.starttime,
       stll_backup_leader.in_progress,
       stll_backup_leader.error_code,
       stll_backup_leader.error_msg,
       stll_backup_leader.enc_key_hash_base64,
       stll_backup_leader.tlr_metadata_successful,
       stll_backup_leader.tlr_metadata_time,
       stll_backup_leader.tlr_metadata_error_msg,
       stll_backup_leader.partial,
       stll_backup_leader.backup_superblock_format,
       stll_backup_leader.time_wait_commit_lock,
       stll_backup_leader.time_hold_commit_lock,
       stll_backup_leader.time_spent_commit_transaction,
       stll_backup_leader.inc_no_backup,
       stll_backup_leader.sb_version_stage3,
       stll_backup_leader.backup_superblock_method,
       stll_backup_leader.num_tables,
       stll_backup_leader.inc_resize_lock_optional,
       stll_backup_leader.inc_resize_lock_mandatory,
       stll_backup_leader.cluster_id,
       stll_backup_leader.s3commit_aware_backup,
       stll_backup_leader.manifest_compress_level,
       stll_backup_leader.table_schema_size,
       stll_backup_leader.db_metadata_size
FROM stll_backup_leader

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