heroku-pg-extras icon indicating copy to clipboard operation
heroku-pg-extras copied to clipboard
verified publisher icon heroku

pg:bloat misreporting gist indexes as tables

Open BradleyJohnson opened this issue 8 years ago • 0 comments

Does what it says on the box:

 type  | schemaname |                           object_name                           | bloat |   waste    
-------+------------+-----------------------------------------------------------------+-------+------------
 table | public     | an_index_on_some_table                                          | 512.0 | 3573 MB
 index | public     | some_table::an_index_on_some_table                              |  91.2 | 3541 MB

Indexes:
    "an_index_on_some_table" gist (array_offer_ids gist__intbig_ops, point(latitude::double precision, longitude::double precision))

BradleyJohnson avatar Aug 14 '17 23:08 BradleyJohnson