Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_scan_metrics version 1.0.39278 / 2022-07-23

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 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