Redshift Observatory

System Table Tracker

System view pg_catalog.stl_hashjoin version 1.0.39278 / 2022-07-23

schema name column data type
pg_catalog stl_hashjoin checksum int8
pg_catalog stl_hashjoin distribution int4
pg_catalog stl_hashjoin endtime timestamp
pg_catalog stl_hashjoin hash_looped char(1)
pg_catalog stl_hashjoin hash_segment int4
pg_catalog stl_hashjoin hash_step int4
pg_catalog stl_hashjoin is_externalized char(1)
pg_catalog stl_hashjoin join_type int4
pg_catalog stl_hashjoin num_parts int4
pg_catalog stl_hashjoin query int4
pg_catalog stl_hashjoin rows int8
pg_catalog stl_hashjoin segment int4
pg_catalog stl_hashjoin slice int4
pg_catalog stl_hashjoin starttime timestamp
pg_catalog stl_hashjoin step int4
pg_catalog stl_hashjoin switched_parts char(1)
pg_catalog stl_hashjoin tasknum int4
pg_catalog stl_hashjoin tbl int4
pg_catalog stl_hashjoin used_prefetching char(1)
pg_catalog stl_hashjoin userid int4

View Text

SELECT stll_hashjoin.userid,
       stll_hashjoin.query,
       stll_hashjoin.slice,
       stll_hashjoin.segment,
       stll_hashjoin.step,
       stll_hashjoin.starttime,
       stll_hashjoin.endtime,
       stll_hashjoin.tasknum,
       stll_hashjoin.rows,
       stll_hashjoin.tbl,
       stll_hashjoin.num_parts,
       stll_hashjoin.join_type,
       stll_hashjoin.hash_looped,
       stll_hashjoin.switched_parts,
       stll_hashjoin.used_prefetching,
       stll_hashjoin.hash_segment,
       stll_hashjoin.hash_step,
       stll_hashjoin.checksum,
       stll_hashjoin.distribution,
       stll_hashjoin.is_externalized
FROM stll_hashjoin


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