Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

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 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 num_tables int4
pg_catalog stl_backup_leader partial 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 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
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