Redshift Observatory

System Table Tracker

System view pg_catalog.stl_file_scan version 1.0.74159 / 2024-09-10

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	num_large_rows	int8
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,
       stll_file_scan.num_large_rows
FROM stll_file_scan
WHERE stll_file_scan.access_control = 0
   OR stll_file_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