Redshift Observatory

System Table Tracker

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

schema name column data type
pg_catalog stl_save bytes int8
pg_catalog stl_save endtime timestamp
pg_catalog stl_save is_diskbased char(1)
pg_catalog stl_save is_save_rtf char(1)
pg_catalog stl_save memory_usage_ratio int4
pg_catalog stl_save query int4
pg_catalog stl_save rows int8
pg_catalog stl_save segment int4
pg_catalog stl_save slice int4
pg_catalog stl_save starttime timestamp
pg_catalog stl_save step int4
pg_catalog stl_save tasknum int4
pg_catalog stl_save tbl int4
pg_catalog stl_save used_mega_block char(1)
pg_catalog stl_save userid int4
pg_catalog stl_save workmem int8

View Text

SELECT stll_save.userid,
       stll_save.query,
       stll_save.slice,
       stll_save.segment,
       stll_save.step,
       stll_save.starttime,
       stll_save.endtime,
       stll_save.tasknum,
       stll_save.rows,
       stll_save.bytes,
       stll_save.tbl,
       stll_save.is_diskbased,
       stll_save.workmem,
       stll_save.is_save_rtf,
       stll_save.used_mega_block,
       stll_save.memory_usage_ratio
FROM stll_save


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