Redshift Research Project

System Table Tracker

System view pg_catalog.stl_vacuum version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_vacuum blocks int4
pg_catalog stl_vacuum cutoff_xid int8
pg_catalog stl_vacuum eventtime timestamp
pg_catalog stl_vacuum is_recluster int4
pg_catalog stl_vacuum max_merge_partitions int4
pg_catalog stl_vacuum reclaimable_rows int8
pg_catalog stl_vacuum reclaimable_space_mb int8
pg_catalog stl_vacuum rows int8
pg_catalog stl_vacuum sortedrows int8
pg_catalog stl_vacuum status char(30)
pg_catalog stl_vacuum table_id int4
pg_catalog stl_vacuum userid int4
pg_catalog stl_vacuum xid int8

View Text

SELECT stll_vacuum.userid,
       stll_vacuum.xid,
       stll_vacuum.table_id,
       stll_vacuum.status,
       stll_vacuum.rows,
       stll_vacuum.sortedrows,
       stll_vacuum.blocks,
       stll_vacuum.max_merge_partitions,
       stll_vacuum.eventtime,
       stll_vacuum.reclaimable_rows,
       stll_vacuum.reclaimable_space_mb,
       stll_vacuum.cutoff_xid,
       stll_vacuum.is_recluster
FROM stll_vacuum


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