Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_scan_metrics version 1.0.39009 / 2022-06-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 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