Redshift Observatory

System Table Tracker

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

schema name column data type
pg_catalog stl_load_commits byte_offset int4
pg_catalog stl_load_commits copy_job_id int8
pg_catalog stl_load_commits curtime timestamp
pg_catalog stl_load_commits errors int4
pg_catalog stl_load_commits file_format char(16)
pg_catalog stl_load_commits filename char(256)
pg_catalog stl_load_commits is_partial int4
pg_catalog stl_load_commits lines_scanned int4
pg_catalog stl_load_commits name char(256)
pg_catalog stl_load_commits query int4
pg_catalog stl_load_commits slice int4
pg_catalog stl_load_commits start_offset int8
pg_catalog stl_load_commits status int4
pg_catalog stl_load_commits userid int4

View Text

SELECT stll_load_commits.userid,
       stll_load_commits.query,
       stll_load_commits.slice,
       stll_load_commits.name,
       stll_load_commits.filename,
       stll_load_commits.byte_offset,
       stll_load_commits.lines_scanned,
       stll_load_commits.errors,
       stll_load_commits.status,
       stll_load_commits.curtime,
       stll_load_commits.file_format,
       stll_load_commits.is_partial,
       stll_load_commits.start_offset,
       stll_load_commits.copy_job_id
FROM stll_load_commits


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