Redshift Observatory

System Table Tracker

System view pg_catalog.stl_guid_cache_metrics version 1.0.58814 / 2023-10-31

schema	name	column	data type
pg_catalog	stl_guid_cache_metrics	entries_tracked	int8
pg_catalog	stl_guid_cache_metrics	lookups	int8
pg_catalog	stl_guid_cache_metrics	node	int4
pg_catalog	stl_guid_cache_metrics	record_time	timestamp
pg_catalog	stl_guid_cache_metrics	staleness_count	int8
pg_catalog	stl_guid_cache_metrics	staleness_percent	int8
pg_catalog	stl_guid_cache_metrics	unknown_count	int8
pg_catalog	stl_guid_cache_metrics	unknown_percent	int8

View Text

SELECT stll_guid_cache_metrics.node,
       stll_guid_cache_metrics.record_time,
       stll_guid_cache_metrics.entries_tracked,
       stll_guid_cache_metrics.staleness_percent,
       stll_guid_cache_metrics.unknown_percent,
       stll_guid_cache_metrics.lookups,
       stll_guid_cache_metrics.staleness_count,
       stll_guid_cache_metrics.unknown_count
FROM stll_guid_cache_metrics

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