Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_superblock active_log int4
pg_catalog stl_superblock bloat int4
pg_catalog stl_superblock crc int4
pg_catalog stl_superblock defrag_version int8
pg_catalog stl_superblock flags int4
pg_catalog stl_superblock freelist_size int4
pg_catalog stl_superblock fs_version int8
pg_catalog stl_superblock high_qid int8
pg_catalog stl_superblock is_extended_superblock int4
pg_catalog stl_superblock node int4
pg_catalog stl_superblock num_blocks int4
pg_catalog stl_superblock num_uncommitted int8
pg_catalog stl_superblock perm_blocks int4
pg_catalog stl_superblock record_time timestamp
pg_catalog stl_superblock sb_version int8
pg_catalog stl_superblock superblock_capacity int8

View Text

SELECT stll_superblock.node,
       stll_superblock.record_time,
       stll_superblock.fs_version,
       stll_superblock.sb_version,
       stll_superblock.defrag_version,
       stll_superblock.num_blocks,
       stll_superblock.high_qid,
       stll_superblock.crc,
       stll_superblock.flags,
       stll_superblock.num_uncommitted,
       stll_superblock.active_log,
       stll_superblock.is_extended_superblock,
       stll_superblock.superblock_capacity,
       stll_superblock.perm_blocks,
       stll_superblock.freelist_size,
       stll_superblock.bloat
FROM stll_superblock


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