Redshift Observatory

System Table Tracker

System view pg_catalog.stl_rlf_scan version 1.0.47470 / 2023-03-11

schema	name	column	data type
pg_catalog	stl_rlf_scan	blocks_opened	int8
pg_catalog	stl_rlf_scan	materialized_columns	char(300)
pg_catalog	stl_rlf_scan	max_time	int8
pg_catalog	stl_rlf_scan	min_time	int8
pg_catalog	stl_rlf_scan	query	int4
pg_catalog	stl_rlf_scan	rows	int8
pg_catalog	stl_rlf_scan	section	int4
pg_catalog	stl_rlf_scan	segment	int4
pg_catalog	stl_rlf_scan	slice	int4
pg_catalog	stl_rlf_scan	step	int4
pg_catalog	stl_rlf_scan	total_time	int8
pg_catalog	stl_rlf_scan	windows_processed	int8

View Text

SELECT stll_rlf_scan.query,
       stll_rlf_scan.slice,
       stll_rlf_scan.segment,
       stll_rlf_scan.step,
       stll_rlf_scan.section,
       stll_rlf_scan.total_time,
       stll_rlf_scan.min_time,
       stll_rlf_scan.max_time,
       stll_rlf_scan.windows_processed,
       stll_rlf_scan.blocks_opened,
       stll_rlf_scan.rows,
       stll_rlf_scan.materialized_columns
FROM stll_rlf_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