Redshift Observatory

System Table Tracker

System view pg_catalog.sys_vacuum_history version 1.0.57864 / 2023-10-14

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

View Text

Error: describing system view <sys_vacuum_history> is disabled.

Note the AWS are as you see here censoring the SQL of more recent system tables views. This is problematic, as the docs are no good, and so it's not uncommon to need to view the text to make sense of the output. I am of the view AWS, at least as far as Redshift are concerned, has a culture of secrecy and I see this as more of the same. I can see absolutely no reason or benefit, for users, for censoring the view text.



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