Redshift Observatory

System Table Tracker

System view pg_catalog.stl_rehydration_metrics version 1.0.50708 / 2023-05-19

schema	name	column	data type
pg_catalog	stl_rehydration_metrics	avg_rerep_reqs	int4
pg_catalog	stl_rehydration_metrics	end_time	timestamp
pg_catalog	stl_rehydration_metrics	in_progress	int4
pg_catalog	stl_rehydration_metrics	mirror_read_latency	int4
pg_catalog	stl_rehydration_metrics	mirror_reads	int8
pg_catalog	stl_rehydration_metrics	mirror_write_latency	int4
pg_catalog	stl_rehydration_metrics	mirror_writes	int8
pg_catalog	stl_rehydration_metrics	node	int4
pg_catalog	stl_rehydration_metrics	primary_read_latency	int4
pg_catalog	stl_rehydration_metrics	primary_reads	int8
pg_catalog	stl_rehydration_metrics	primary_write_latency	int4
pg_catalog	stl_rehydration_metrics	primary_writes	int8
pg_catalog	stl_rehydration_metrics	rehydrated_blocks	int8
pg_catalog	stl_rehydration_metrics	s3_read_latency	int4
pg_catalog	stl_rehydration_metrics	s3_reads	int8
pg_catalog	stl_rehydration_metrics	s3_write_latency	int4
pg_catalog	stl_rehydration_metrics	s3_writes	int8
pg_catalog	stl_rehydration_metrics	start_time	timestamp

View Text

SELECT stll_rehydration_metrics.start_time,
       stll_rehydration_metrics.end_time,
       stll_rehydration_metrics.rehydrated_blocks,
       stll_rehydration_metrics.primary_reads,
       stll_rehydration_metrics.primary_read_latency,
       stll_rehydration_metrics.mirror_reads,
       stll_rehydration_metrics.mirror_read_latency,
       stll_rehydration_metrics.s3_reads,
       stll_rehydration_metrics.s3_read_latency,
       stll_rehydration_metrics.primary_writes,
       stll_rehydration_metrics.primary_write_latency,
       stll_rehydration_metrics.mirror_writes,
       stll_rehydration_metrics.mirror_write_latency,
       stll_rehydration_metrics.in_progress,
       stll_rehydration_metrics.node,
       stll_rehydration_metrics.avg_rerep_reqs,
       stll_rehydration_metrics.s3_writes,
       stll_rehydration_metrics.s3_write_latency
FROM stll_rehydration_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