Redshift Research Project

System Table Tracker

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

schema name column data type
pg_catalog stl_ght_hash_partitions lds int4
pg_catalog stl_ght_hash_partitions mem_resident int4
pg_catalog stl_ght_hash_partitions num_blocks int4
pg_catalog stl_ght_hash_partitions occupied int4
pg_catalog stl_ght_hash_partitions part_num int4
pg_catalog stl_ght_hash_partitions query int4
pg_catalog stl_ght_hash_partitions resizes int4
pg_catalog stl_ght_hash_partitions rows int8
pg_catalog stl_ght_hash_partitions segment int4
pg_catalog stl_ght_hash_partitions slice int4
pg_catalog stl_ght_hash_partitions slots int4
pg_catalog stl_ght_hash_partitions step int4

View Text

SELECT stll_ght_hash_partitions.query,
       stll_ght_hash_partitions.slice,
       stll_ght_hash_partitions.segment,
       stll_ght_hash_partitions.step,
       stll_ght_hash_partitions.lds,
       stll_ght_hash_partitions.part_num,
       stll_ght_hash_partitions.num_blocks,
       stll_ght_hash_partitions.mem_resident,
       stll_ght_hash_partitions.rows,
       stll_ght_hash_partitions.slots,
       stll_ght_hash_partitions.occupied,
       stll_ght_hash_partitions.resizes
FROM stll_ght_hash_partitions


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