Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_bloat version 1.0.41194 / 2022-09-03

schema	name	column	data type
pg_catalog	stl_catalog_bloat	database_id	int4
pg_catalog	stl_catalog_bloat	logtime	timestamp
pg_catalog	stl_catalog_bloat	num_deletes	int4
pg_catalog	stl_catalog_bloat	num_inserts	int4
pg_catalog	stl_catalog_bloat	num_updates	int4
pg_catalog	stl_catalog_bloat	pid	int8
pg_catalog	stl_catalog_bloat	table_id	int4
pg_catalog	stl_catalog_bloat	total_delete_size	int4
pg_catalog	stl_catalog_bloat	total_insert_size	int4
pg_catalog	stl_catalog_bloat	total_update_size	int4
pg_catalog	stl_catalog_bloat	userid	int4

View Text

SELECT stll_catalog_bloat.database_id,
       stll_catalog_bloat.userid,
       stll_catalog_bloat.pid,
       stll_catalog_bloat.logtime,
       stll_catalog_bloat.table_id,
       stll_catalog_bloat.num_inserts,
       stll_catalog_bloat.num_updates,
       stll_catalog_bloat.num_deletes,
       stll_catalog_bloat.total_insert_size,
       stll_catalog_bloat.total_update_size,
       stll_catalog_bloat.total_delete_size
FROM stll_catalog_bloat

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