index_size, 100-pgstatindex(relname).avg_leaf_density AS leaf_density FROM pg_class; relname | index_size | leaf_density -----------------------------------------------+------------+------------- test_inventory_id_idx | 376832 | 89.75 test_pkey | 376832 | 89.75 test_rental_date_inventory_id_customer_id_idx | 524288 | 89.27 relname | index_size | leaf_density -----------------------------------------------+------------+------------- test_inventory_id_idx | 745472 | 45.52 test_pkey | 737280 | 46.02 test_rental_date_inventory_id_customer_id_idx | 925696 | 51.04 UPDATE 50% of Rows in Table: Index Size Doubled, 50% Bloated