explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MLxZ

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

CTE Scan on geography_closure_cte (cost=7,057.42..10,312.25 rows=723 width=580) (actual rows= loops=)

  • Filter: ((COALESCE(parent_id, '0'::character varying))::text = 'SOUTHEASTC2'::text)
2.          

CTE geography_closure_cte

3. 0.000 0.000 ↓ 0.0

Recursive Union (cost=0.00..7,057.42 rows=144,659 width=527) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on geography_hierarchy (cost=0.00..10.49 rows=549 width=20) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.35..415.38 rows=14,411 width=527) (actual rows= loops=)

  • Hash Cond: ((cte.parent_id)::text = (gh.parent_id)::text)
6. 0.000 0.000 ↓ 0.0

WorkTable Scan on geography_closure_cte cte (cost=0.00..109.80 rows=5,490 width=1,032) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=10.49..10.49 rows=549 width=20) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on geography_hierarchy gh (cost=0.00..10.49 rows=549 width=20) (actual rows= loops=)