Skip to main content

PostGIS health

The PostGIS Health tab monitors spatial indexes, geometry column configuration, and PostGIS settings on the connected instance. It is always visible in the sidebar but shows a "not installed" card when PostGIS is not present.

What it checks​

  • Spatial indexes — GiST/GIN indexes on geometry/geography columns, usage statistics, and bloat
  • Column quality — geometry type, SRID presence, and dimensionality per column
  • Configuration — PostGIS version, installed extensions (postgis, postgis_raster, postgis_topology)
  • Index bloat — estimated bloat on spatial indexes with reclaim recommendations

Requirements​

PostGIS must be installed. The tab detects PostGIS availability from pg_available_extensions and avoids unnecessary API calls when absent.

Connection to Index Advisor​

Spatial index analysis integrates with the broader index recommendation engine, which can suggest GIN/GiST indexes for geometry columns alongside B-tree, BRIN, and other index types.