Redshift Observatory

System Table Tracker

System view pg_catalog.stl_catalog_bloat version 1.0.52931 / 2023-07-07

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