| 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 |
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