Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_scan_metrics version 1.0.75672 / 2024-09-28

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	toast_num_dead_tups	int8
pg_catalog	stl_catalog_scan_metrics	toast_num_live_tups	int8
pg_catalog	stl_catalog_scan_metrics	total_dead_tup_sz	int8
pg_catalog	stl_catalog_scan_metrics	total_live_tup_sz	int8
pg_catalog	stl_catalog_scan_metrics	total_toast_dead_tup_sz	int8
pg_catalog	stl_catalog_scan_metrics	total_toast_live_tup_sz	int8
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,
       stll_catalog_scan_metrics.total_live_tup_sz,
       stll_catalog_scan_metrics.total_dead_tup_sz,
       stll_catalog_scan_metrics.toast_num_live_tups,
       stll_catalog_scan_metrics.toast_num_dead_tups,
       stll_catalog_scan_metrics.total_toast_live_tup_sz,
       stll_catalog_scan_metrics.total_toast_dead_tup_sz
FROM stll_catalog_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