Redshift Observatory

System Table Tracker

System view pg_catalog.stl_dead_tuples_stats version 1.0.70890 / 2024-07-14

schema	name	column	data type
pg_catalog	stl_dead_tuples_stats	dead_tuples_accurate	int8
pg_catalog	stl_dead_tuples_stats	dead_tuples_stats	int8
pg_catalog	stl_dead_tuples_stats	eventtime	timestamp
pg_catalog	stl_dead_tuples_stats	num_visible_rows	int8
pg_catalog	stl_dead_tuples_stats	table_id	int4
pg_catalog	stl_dead_tuples_stats	xid	int8

View Text

SELECT stll_dead_tuples_stats.eventtime,
       stll_dead_tuples_stats.xid,
       stll_dead_tuples_stats.table_id,
       stll_dead_tuples_stats.num_visible_rows,
       stll_dead_tuples_stats.dead_tuples_accurate,
       stll_dead_tuples_stats.dead_tuples_stats
FROM stll_dead_tuples_stats

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