Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_scan_metrics version 1.0.40467 / 2022-08-08

schema	name	column	data type
pg_catalog	stl_catalog_scan_metrics	database	int4
pg_catalog	stl_catalog_scan_metrics	duration_msec	int8
pg_catalog	stl_catalog_scan_metrics	num_dead_tups	int8
pg_catalog	stl_catalog_scan_metrics	num_live_tups	int8
pg_catalog	stl_catalog_scan_metrics	starttime	timestamp
pg_catalog	stl_catalog_scan_metrics	table_name	char(128)
pg_catalog	stl_catalog_scan_metrics	xid	int8

View Text

SELECT stll_catalog_scan_metrics.xid,
       stll_catalog_scan_metrics.database,
       stll_catalog_scan_metrics.table_name,
       stll_catalog_scan_metrics.starttime,
       stll_catalog_scan_metrics.duration_msec,
       stll_catalog_scan_metrics.num_live_tups,
       stll_catalog_scan_metrics.num_dead_tups
FROM stll_catalog_scan_metrics

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