explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mFUy

Settings
# exclusive inclusive rows x rows loops node
1. 0.300 0.533 ↓ 47.0 47 1

Merge Join (cost=1,290.38..4,108.71 rows=1 width=1,434) (actual time=0.187..0.533 rows=47 loops=1)

  • Merge Cond: ((boundary.boundary_id)::text = (polygon.boundary_id)::text)
2. 0.097 0.168 ↑ 7.7 47 1

Sort (cost=1,289.82..1,290.73 rows=363 width=719) (actual time=0.164..0.168 rows=47 loops=1)

  • Sort Key: boundary.boundary_id
  • Sort Method: quicksort Memory: 71kB
3. 0.071 0.071 ↑ 7.7 47 1

Index Scan using land_boundary_orgid_index_v4 on boundary_v4 boundary (cost=0.43..1,274.39 rows=363 width=719) (actual time=0.022..0.071 rows=47 loops=1)

  • Index Cond: (org_id = 144,330)
4. 0.065 0.065 ↑ 16.1 47 1

Index Scan using land_polygon_v4_org_id_boundary_id_index on polygon_v4 polygon (cost=0.56..2,815.17 rows=757 width=756) (actual time=0.020..0.065 rows=47 loops=1)

  • Index Cond: (org_id = 144,330)