explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9TZE : boundary

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.033 ↓ 0.0 0 1

Merge Join (cost=1,290.38..4,108.71 rows=1 width=1,434) (actual time=0.033..0.033 rows=0 loops=1)

  • Merge Cond: ((boundary.boundary_id)::text = (polygon.boundary_id)::text)
2. 0.019 0.032 ↓ 0.0 0 1

Sort (cost=1,289.82..1,290.73 rows=363 width=719) (actual time=0.032..0.032 rows=0 loops=1)

  • Sort Key: boundary.boundary_id
  • Sort Method: quicksort Memory: 25kB
3. 0.013 0.013 ↓ 0.0 0 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.013..0.013 rows=0 loops=1)

  • Index Cond: (org_id = 459,079)
4. 0.000 0.000 ↓ 0.0 0

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) (never executed)

  • Index Cond: (org_id = 459,079)
Planning time : 1.056 ms