Redshift Observatory

System Table Tracker

System view pg_catalog.stl_backup_compute version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	stl_backup_compute	backup_id	char(256)
pg_catalog	stl_backup_compute	backup_manifest_available	int4
pg_catalog	stl_backup_compute	blocks_to_upload	int8
pg_catalog	stl_backup_compute	blocks_uploaded	int8
pg_catalog	stl_backup_compute	blocks_validated	int8
pg_catalog	stl_backup_compute	currenttime	timestamp
pg_catalog	stl_backup_compute	distall_blocks	int8
pg_catalog	stl_backup_compute	inc_no_backup	int8
pg_catalog	stl_backup_compute	metadata_read_from_backup	int4
pg_catalog	stl_backup_compute	nobackup_blocks	int8
pg_catalog	stl_backup_compute	node_num	int4
pg_catalog	stl_backup_compute	non_distall_blocks	int8
pg_catalog	stl_backup_compute	num_blocks	int8
pg_catalog	stl_backup_compute	num_failures	int8
pg_catalog	stl_backup_compute	num_modified_superblock_segments	int8
pg_catalog	stl_backup_compute	permanent_blocks	int8
pg_catalog	stl_backup_compute	perm_blocks_in_s3	int8
pg_catalog	stl_backup_compute	sb_segments_available	int4
pg_catalog	stl_backup_compute	sb_version	int8
pg_catalog	stl_backup_compute	starttime	timestamp
pg_catalog	stl_backup_compute	state	char(256)
pg_catalog	stl_backup_compute	superblock_size	int8
pg_catalog	stl_backup_compute	time_spent_copy_segments	int8
pg_catalog	stl_backup_compute	time_spent_read_sb_header	int8
pg_catalog	stl_backup_compute	time_spent_set_in_s3_bits	int8
pg_catalog	stl_backup_compute	time_spent_stage1	int8
pg_catalog	stl_backup_compute	time_spent_stage2	int8
pg_catalog	stl_backup_compute	total_num_superblock_segments	int8

View Text

SELECT stll_backup_compute.currenttime,
       stll_backup_compute.node_num,
       stll_backup_compute.state,
       stll_backup_compute.backup_id,
       stll_backup_compute.sb_version,
       stll_backup_compute.starttime,
       stll_backup_compute.num_blocks,
       stll_backup_compute.superblock_size,
       stll_backup_compute.permanent_blocks,
       stll_backup_compute.blocks_to_upload,
       stll_backup_compute.blocks_uploaded,
       stll_backup_compute.num_failures,
       stll_backup_compute.num_modified_superblock_segments,
       stll_backup_compute.total_num_superblock_segments,
       stll_backup_compute.time_spent_stage1,
       stll_backup_compute.time_spent_read_sb_header,
       stll_backup_compute.time_spent_copy_segments,
       stll_backup_compute.time_spent_stage2,
       stll_backup_compute.time_spent_set_in_s3_bits,
       stll_backup_compute.inc_no_backup,
       stll_backup_compute.nobackup_blocks,
       stll_backup_compute.distall_blocks,
       stll_backup_compute.non_distall_blocks,
       stll_backup_compute.perm_blocks_in_s3,
       stll_backup_compute.metadata_read_from_backup,
       stll_backup_compute.blocks_validated,
       stll_backup_compute.sb_segments_available,
       stll_backup_compute.backup_manifest_available
FROM stll_backup_compute

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