Redshift Observatory

System Table Tracker

System view pg_catalog.stl_hash version 1.0.57864 / 2023-10-14

schema name column data type
pg_catalog stl_hash build_global_hash_table char(1)
pg_catalog stl_hash bytes int8
pg_catalog stl_hash checksum int8
pg_catalog stl_hash endtime timestamp
pg_catalog stl_hash est_rows int8
pg_catalog stl_hash is_diskbased char(1)
pg_catalog stl_hash is_hashed_subplan char(1)
pg_catalog stl_hash maxlength int4
pg_catalog stl_hash max_runtime_filter_size int4
pg_catalog stl_hash memory_usage_ratio int4
pg_catalog stl_hash num_blocks_permitted int4
pg_catalog stl_hash num_parts int4
pg_catalog stl_hash occupied int4
pg_catalog stl_hash query int4
pg_catalog stl_hash resizes int4
pg_catalog stl_hash rows int8
pg_catalog stl_hash runtime_filter_size int4
pg_catalog stl_hash runtime_filter_type int4
pg_catalog stl_hash segment int4
pg_catalog stl_hash slice int4
pg_catalog stl_hash slots int4
pg_catalog stl_hash starttime timestamp
pg_catalog stl_hash step int4
pg_catalog stl_hash tasknum int4
pg_catalog stl_hash tbl int4
pg_catalog stl_hash used_mega_block char(1)
pg_catalog stl_hash used_prefetching char(1)
pg_catalog stl_hash userid int4
pg_catalog stl_hash workmem int8

View Text

SELECT stll_hash.userid,
       stll_hash.query,
       stll_hash.slice,
       stll_hash.segment,
       stll_hash.step,
       stll_hash.starttime,
       stll_hash.endtime,
       stll_hash.tasknum,
       stll_hash.rows,
       stll_hash.bytes,
       stll_hash.slots,
       stll_hash.occupied,
       stll_hash.maxlength,
       stll_hash.tbl,
       stll_hash.is_diskbased,
       stll_hash.workmem,
       stll_hash.num_parts,
       stll_hash.est_rows,
       stll_hash.num_blocks_permitted,
       stll_hash.resizes,
       stll_hash.checksum,
       stll_hash.used_prefetching,
       stll_hash.runtime_filter_size,
       stll_hash.max_runtime_filter_size,
       stll_hash.runtime_filter_type,
       stll_hash.is_hashed_subplan,
       stll_hash.build_global_hash_table,
       stll_hash.used_mega_block,
       stll_hash.memory_usage_ratio
FROM stll_hash


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