Redshift Observatory

System Table Tracker

System view pg_catalog.stl_user_vacuum_history version 1.0.71912 / 2024-08-02

schema name column data type
pg_catalog stl_user_vacuum_history database_name char(128)
pg_catalog stl_user_vacuum_history duration int8
pg_catalog stl_user_vacuum_history end_time timestamp
pg_catalog stl_user_vacuum_history query_id int8
pg_catalog stl_user_vacuum_history reclaimable_rows int8
pg_catalog stl_user_vacuum_history reclaimed_blocks int8
pg_catalog stl_user_vacuum_history reclaimed_rows int8
pg_catalog stl_user_vacuum_history record_time timestamp
pg_catalog stl_user_vacuum_history rows_before_vacuum int8
pg_catalog stl_user_vacuum_history schema_name char(128)
pg_catalog stl_user_vacuum_history size_before_vacuum int8
pg_catalog stl_user_vacuum_history sortedrows_after_vacuum int8
pg_catalog stl_user_vacuum_history sortedrows_before_vacuum int8
pg_catalog stl_user_vacuum_history start_time timestamp
pg_catalog stl_user_vacuum_history status char(30)
pg_catalog stl_user_vacuum_history table_id int4
pg_catalog stl_user_vacuum_history table_name char(136)
pg_catalog stl_user_vacuum_history transaction_id int8
pg_catalog stl_user_vacuum_history user_id int4
pg_catalog stl_user_vacuum_history vacuum_type char(30)

View Text

SELECT stll_user_vacuum_history.user_id,
       stll_user_vacuum_history.transaction_id,
       stll_user_vacuum_history.query_id,
       stll_user_vacuum_history.database_name,
       stll_user_vacuum_history.schema_name,
       stll_user_vacuum_history.table_name,
       stll_user_vacuum_history.table_id,
       stll_user_vacuum_history.vacuum_type,
       stll_user_vacuum_history.status,
       stll_user_vacuum_history.start_time,
       stll_user_vacuum_history.end_time,
       stll_user_vacuum_history.record_time,
       stll_user_vacuum_history.duration,
       stll_user_vacuum_history.rows_before_vacuum,
       stll_user_vacuum_history.size_before_vacuum,
       stll_user_vacuum_history.reclaimable_rows,
       stll_user_vacuum_history.reclaimed_rows,
       stll_user_vacuum_history.reclaimed_blocks,
       stll_user_vacuum_history.sortedrows_before_vacuum,
       stll_user_vacuum_history.sortedrows_after_vacuum
FROM stll_user_vacuum_history


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