Redshift Observatory

System Table Tracker

System view pg_catalog.stl_scan version 1.0.70695 / 2024-07-11

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

View Text

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
WHERE stll_scan.access_control = 0
   OR stll_scan.access_control IS NULL
   OR NOT is_seclog_downgrade_enabled()

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