explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k5Vw

Settings
# exclusive inclusive rows x rows loops node
1. 18.405 33.443 ↓ 2.6 3,594 1

Hash Join (cost=4,101.36..4,166.19 rows=1,374 width=2,040) (actual time=9.050..33.443 rows=3,594 loops=1)

  • Hash Cond: ((polygons.boundary_id)::text = (boundaries.boundary_id)::text)
2.          

CTE boundaries

3. 3.513 3.513 ↓ 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.042..3.513 rows=3,214 loops=1)

  • Index Cond: (org_id = 481,703)
4.          

CTE polygons

5. 3.788 3.788 ↓ 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=748) (actual time=0.024..3.788 rows=3,594 loops=1)

  • Index Cond: (org_id = 481,703)
6. 6.044 6.044 ↓ 4.7 3,594 1

CTE Scan on polygons (cost=0.00..15.14 rows=757 width=494) (actual time=0.027..6.044 rows=3,594 loops=1)

7. 1.860 8.994 ↓ 8.9 3,214 1

Hash (cost=7.26..7.26 rows=363 width=1,546) (actual time=8.994..8.994 rows=3,214 loops=1)

  • Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,349kB
8. 7.134 7.134 ↓ 8.9 3,214 1

CTE Scan on boundaries (cost=0.00..7.26 rows=363 width=1,546) (actual time=0.045..7.134 rows=3,214 loops=1)