| schema | name | column | data type |
|---|---|---|---|
| pg_catalog | stl_scan | bytes | int8 |
| pg_catalog | stl_scan | checksum | int8 |
| pg_catalog | stl_scan | consumed_scan_ranges | int8 |
| pg_catalog | stl_scan | endtime | timestamp |
| pg_catalog | stl_scan | fetches | int8 |
| pg_catalog | stl_scan | is_delayed_scan | char(1) |
| pg_catalog | stl_scan | is_rlf_scan | char(1) |
| pg_catalog | stl_scan | is_rlf_scan_reason | int4 |
| pg_catalog | stl_scan | is_rrscan | char(1) |
| pg_catalog | stl_scan | is_rrscan_expr | char(1) |
| pg_catalog | stl_scan | is_vectorized_scan | char(1) |
| pg_catalog | stl_scan | is_vectorized_scan_reason | int4 |
| pg_catalog | stl_scan | num_em_blocks | int4 |
| pg_catalog | stl_scan | num_sortkey_as_predicate | int4 |
| pg_catalog | stl_scan | perm_table_name | char(136) |
| pg_catalog | stl_scan | query | int4 |
| pg_catalog | stl_scan | row_fetcher_reason | int8 |
| pg_catalog | stl_scan | row_fetcher_state | int4 |
| pg_catalog | stl_scan | rows | int8 |
| pg_catalog | stl_scan | rows_pre_filter | int8 |
| pg_catalog | stl_scan | rows_pre_user_filter | int8 |
| pg_catalog | stl_scan | runtime_filtering | char(1) |
| pg_catalog | stl_scan | scanned_mega_value | char(1) |
| pg_catalog | stl_scan | scan_region | int4 |
| pg_catalog | stl_scan | segment | int4 |
| pg_catalog | stl_scan | slice | int4 |
| pg_catalog | stl_scan | starttime | timestamp |
| pg_catalog | stl_scan | step | int4 |
| pg_catalog | stl_scan | tasknum | int4 |
| pg_catalog | stl_scan | tbl | int4 |
| pg_catalog | stl_scan | topology_signature | int8 |
| pg_catalog | stl_scan | type | int4 |
| pg_catalog | stl_scan | use_fwd_mtx_opt | char(1) |
| pg_catalog | stl_scan | userid | int4 |
| pg_catalog | stl_scan | use_tpm_partition | char(1) |
| pg_catalog | stl_scan | work_stealing_reason | int8 |
SELECT stll_scan.userid,
stll_scan.query,
stll_scan.slice,
stll_scan.segment,
stll_scan.step,
stll_scan.starttime,
stll_scan.endtime,
stll_scan.tasknum,
stll_scan.rows,
stll_scan.bytes,
stll_scan.fetches,
stll_scan.type,
stll_scan.tbl,
stll_scan.is_rrscan,
stll_scan.is_delayed_scan,
stll_scan.rows_pre_filter,
stll_scan.rows_pre_user_filter,
stll_scan.perm_table_name,
stll_scan.is_rlf_scan,
stll_scan.is_rlf_scan_reason,
stll_scan.num_em_blocks,
stll_scan.checksum,
stll_scan.runtime_filtering,
stll_scan.scan_region,
stll_scan.num_sortkey_as_predicate,
stll_scan.row_fetcher_state,
stll_scan.consumed_scan_ranges,
stll_scan.work_stealing_reason,
stll_scan.is_vectorized_scan,
stll_scan.is_vectorized_scan_reason,
stll_scan.row_fetcher_reason,
stll_scan.topology_signature,
stll_scan.use_tpm_partition,
stll_scan.is_rrscan_expr,
stll_scan.use_fwd_mtx_opt,
stll_scan.scanned_mega_value
FROM stll_scan 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