Redshift Observatory

System Table Tracker

System view pg_catalog.stl_file_scan version 1.0.52931 / 2023-07-07

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


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