explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6iKn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=187,184.59..187,184.73 rows=56 width=27) (actual rows= loops=)

  • Sort Key: a.name
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=187,182.40..187,182.96 rows=56 width=27) (actual rows= loops=)

  • Group Key: a.name, a.area_id, a.type
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.88..37,554.08 rows=19,950,443 width=27) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on area a (cost=0.00..9.56 rows=56 width=25,244) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on policy_data pd (cost=12.88..669.84 rows=60 width=32) (actual rows= loops=)

  • Recheck Cond: (point_geom_4326 && a.polygon_4326)
  • Filter: ((internal_company_id = 14) AND _st_intersects(point_geom_4326, a.polygon_4326))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on policy_data_geometry_gix (cost=0.00..12.87 rows=327 width=0) (actual rows= loops=)

  • Index Cond: (point_geom_4326 && a.polygon_4326)