explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nk8o

Settings
# exclusive inclusive rows x rows loops node
1. 25.876 41.811 ↓ 3,594.0 3,594 1

Merge Join (cost=1,290.38..4,108.71 rows=1 width=1,434) (actual time=12.002..41.811 rows=3,594 loops=1)

  • Merge Cond: ((boundary.boundary_id)::text = (polygon.boundary_id)::text)
2. 9.127 12.666 ↓ 8.9 3,214 1

Sort (cost=1,289.82..1,290.73 rows=363 width=719) (actual time=11.969..12.666 rows=3,214 loops=1)

  • Sort Key: boundary.boundary_id
  • Sort Method: quicksort Memory: 3,356kB
3. 3.539 3.539 ↓ 8.9 3,214 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.049..3.539 rows=3,214 loops=1)

  • Index Cond: (org_id = 481,703)
4. 3.269 3.269 ↓ 4.7 3,594 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.016..3.269 rows=3,594 loops=1)

  • Index Cond: (org_id = 481,703)