Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

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