Redshift Observatory

System Table Tracker

System view pg_catalog.stl_insert version 1.0.70695 / 2024-07-11

schema name column data type
pg_catalog stl_insert endtime timestamp
pg_catalog stl_insert inserted_mega_value char(1)
pg_catalog stl_insert query int4
pg_catalog stl_insert reserve_rowid int4
pg_catalog stl_insert rows int8
pg_catalog stl_insert segment int4
pg_catalog stl_insert slice int4
pg_catalog stl_insert starttime timestamp
pg_catalog stl_insert step int4
pg_catalog stl_insert tasknum int4
pg_catalog stl_insert tbl int4
pg_catalog stl_insert userid int4
pg_catalog stl_insert use_staging_table char(1)
pg_catalog stl_insert write_xid int8

View Text

SELECT stll_insert.userid,
       stll_insert.query,
       stll_insert.slice,
       stll_insert.segment,
       stll_insert.step,
       stll_insert.starttime,
       stll_insert.endtime,
       stll_insert.tasknum,
       stll_insert.rows,
       stll_insert.tbl,
       stll_insert.inserted_mega_value,
       stll_insert.use_staging_table,
       stll_insert.write_xid,
       stll_insert.reserve_rowid
FROM stll_insert
WHERE stll_insert.access_control = 0
   OR stll_insert.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