Redshift Observatory

System Table Tracker

System view pg_catalog.stl_skr_scan_metrics version 1.0.40325 / 2022-07-29

schema	name	column	data type
pg_catalog	stl_skr_scan_metrics	col	int4
pg_catalog	stl_skr_scan_metrics	estimated_rows_filtered	int8
pg_catalog	stl_skr_scan_metrics	observation_type	int4
pg_catalog	stl_skr_scan_metrics	observed_post_rrscan_rows_filtered	int8
pg_catalog	stl_skr_scan_metrics	observed_rrscan_rows_filtered	int8
pg_catalog	stl_skr_scan_metrics	query	int4
pg_catalog	stl_skr_scan_metrics	recordtime	timestamp
pg_catalog	stl_skr_scan_metrics	segment	int4
pg_catalog	stl_skr_scan_metrics	slice	int4
pg_catalog	stl_skr_scan_metrics	tbl	int4

View Text

SELECT stll_skr_scan_metrics.query,
       stll_skr_scan_metrics.segment,
       stll_skr_scan_metrics.tbl,
       stll_skr_scan_metrics.slice,
       stll_skr_scan_metrics.col,
       stll_skr_scan_metrics.observed_rrscan_rows_filtered,
       stll_skr_scan_metrics.observed_post_rrscan_rows_filtered,
       stll_skr_scan_metrics.estimated_rows_filtered,
       stll_skr_scan_metrics.observation_type,
       stll_skr_scan_metrics.recordtime
FROM stll_skr_scan_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