Redshift Research Project

System Table Tracker

System view pg_catalog.stl_mem_heavy_hitters version 1.0.40182 / 2022-07-23

schema	name	column	data type
pg_catalog	stl_mem_heavy_hitters	hex_addresses	char(128)
pg_catalog	stl_mem_heavy_hitters	mem_operation	char(16)
pg_catalog	stl_mem_heavy_hitters	memory_type	char(16)
pg_catalog	stl_mem_heavy_hitters	node	int4
pg_catalog	stl_mem_heavy_hitters	now	timestamp
pg_catalog	stl_mem_heavy_hitters	process_type	char(32)
pg_catalog	stl_mem_heavy_hitters	shared_mem_type	char(32)
pg_catalog	stl_mem_heavy_hitters	since	timestamp

View Text

SELECT stll_mem_heavy_hitters.since,
       stll_mem_heavy_hitters.now,
       stll_mem_heavy_hitters.node,
       stll_mem_heavy_hitters.memory_type,
       stll_mem_heavy_hitters.mem_operation,
       stll_mem_heavy_hitters.shared_mem_type,
       stll_mem_heavy_hitters.process_type,
       stll_mem_heavy_hitters.hex_addresses
FROM stll_mem_heavy_hitters

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