Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_backup_compute backup_id char(256)
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_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
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