Redshift Observatory

System Table Tracker

System view pg_catalog.stl_file_scan version 1.0.39009 / 2022-06-08

schema	name	column	data type
pg_catalog	stl_file_scan	bytes	int8
pg_catalog	stl_file_scan	curtime	timestamp
pg_catalog	stl_file_scan	is_partial	int4
pg_catalog	stl_file_scan	lines	int8
pg_catalog	stl_file_scan	loadtime	int8
pg_catalog	stl_file_scan	name	char(90)
pg_catalog	stl_file_scan	query	int4
pg_catalog	stl_file_scan	slice	int4
pg_catalog	stl_file_scan	start_offset	int8
pg_catalog	stl_file_scan	userid	int4

View Text

SELECT stll_file_scan.userid,
       stll_file_scan.query,
       stll_file_scan.slice,
       stll_file_scan.name,
       stll_file_scan.lines,
       stll_file_scan.bytes,
       stll_file_scan.loadtime,
       stll_file_scan.curtime,
       stll_file_scan.is_partial,
       stll_file_scan.start_offset
FROM stll_file_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