Redshift Observatory

System Table Tracker

System view pg_catalog.stl_file_scan version 1.0.77028 / 2024-10-24

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