Redshift Observatory

System Table Tracker

System view pg_catalog.stl_vacuum_scan_query_usage version 1.0.60140 / 2023-11-19

schema	name	column	data type
pg_catalog	stl_vacuum_scan_query_usage	bucket0_10	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket10_20	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket20_30	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket30_40	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket40_50	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket50_60	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket60_70	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket70_80	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket80_90	int8
pg_catalog	stl_vacuum_scan_query_usage	bucket90_100	int8
pg_catalog	stl_vacuum_scan_query_usage	eventtime	timestamp
pg_catalog	stl_vacuum_scan_query_usage	node	int8
pg_catalog	stl_vacuum_scan_query_usage	no_loss_query_count	int8

View Text

SELECT stll_vacuum_scan_query_usage.eventtime,
       stll_vacuum_scan_query_usage.node,
       stll_vacuum_scan_query_usage.bucket0_10,
       stll_vacuum_scan_query_usage.bucket10_20,
       stll_vacuum_scan_query_usage.bucket20_30,
       stll_vacuum_scan_query_usage.bucket30_40,
       stll_vacuum_scan_query_usage.bucket40_50,
       stll_vacuum_scan_query_usage.bucket50_60,
       stll_vacuum_scan_query_usage.bucket60_70,
       stll_vacuum_scan_query_usage.bucket70_80,
       stll_vacuum_scan_query_usage.bucket80_90,
       stll_vacuum_scan_query_usage.bucket90_100,
       stll_vacuum_scan_query_usage.no_loss_query_count
FROM stll_vacuum_scan_query_usage

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