Redshift Research Project

System Table Tracker

System view pg_catalog.stl_disks_blocks_stats version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_disks_blocks_stats allocated_blks int8
pg_catalog stl_disks_blocks_stats local_backedup_blks int8
pg_catalog stl_disks_blocks_stats local_cap int8
pg_catalog stl_disks_blocks_stats logtime timestamp
pg_catalog stl_disks_blocks_stats mirror_allocated_blks int8
pg_catalog stl_disks_blocks_stats mirror_rerep_blks int4
pg_catalog stl_disks_blocks_stats node int4
pg_catalog stl_disks_blocks_stats num_mirror_reserved int8
pg_catalog stl_disks_blocks_stats num_primary_reserved int8
pg_catalog stl_disks_blocks_stats perm_blks int8
pg_catalog stl_disks_blocks_stats primary_allocated_blks int8
pg_catalog stl_disks_blocks_stats primary_rerep_blks int4
pg_catalog stl_disks_blocks_stats sb_cap int8
pg_catalog stl_disks_blocks_stats temp_blks int8
pg_catalog stl_disks_blocks_stats to_backup_blks int8

View Text

SELECT stll_disks_blocks_stats.node,
       stll_disks_blocks_stats.logtime,
       stll_disks_blocks_stats.local_cap,
       stll_disks_blocks_stats.sb_cap,
       stll_disks_blocks_stats.allocated_blks,
       stll_disks_blocks_stats.primary_allocated_blks,
       stll_disks_blocks_stats.mirror_allocated_blks,
       stll_disks_blocks_stats.perm_blks,
       stll_disks_blocks_stats.to_backup_blks,
       stll_disks_blocks_stats.temp_blks,
       stll_disks_blocks_stats.local_backedup_blks,
       stll_disks_blocks_stats.primary_rerep_blks,
       stll_disks_blocks_stats.mirror_rerep_blks,
       stll_disks_blocks_stats.num_primary_reserved,
       stll_disks_blocks_stats.num_mirror_reserved
FROM stll_disks_blocks_stats


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