Redshift Observatory

System Table Tracker

System view pg_catalog.stl_guid_cache_stats version 1.0.78160 / 2024-11-17

schema	name	column	data type
pg_catalog	stl_guid_cache_stats	deletes	int8
pg_catalog	stl_guid_cache_stats	ds_hits	int8
pg_catalog	stl_guid_cache_stats	ds_lookups	int8
pg_catalog	stl_guid_cache_stats	entries	int8
pg_catalog	stl_guid_cache_stats	hits	int8
pg_catalog	stl_guid_cache_stats	inserts	int8
pg_catalog	stl_guid_cache_stats	lookups	int8
pg_catalog	stl_guid_cache_stats	mode	int4
pg_catalog	stl_guid_cache_stats	node	int4
pg_catalog	stl_guid_cache_stats	record_time	timestamp
pg_catalog	stl_guid_cache_stats	resets	int8
pg_catalog	stl_guid_cache_stats	stale_hits	int8

View Text

SELECT stll_guid_cache_stats.node,
       stll_guid_cache_stats.record_time,
       stll_guid_cache_stats.mode,
       stll_guid_cache_stats.entries,
       stll_guid_cache_stats.lookups,
       stll_guid_cache_stats.hits,
       stll_guid_cache_stats.inserts,
       stll_guid_cache_stats.deletes,
       stll_guid_cache_stats.resets,
       stll_guid_cache_stats.stale_hits,
       stll_guid_cache_stats.ds_lookups,
       stll_guid_cache_stats.ds_hits
FROM stll_guid_cache_stats

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Replacement System Tables System Table Tracker The Known Universe Twitter White Papers