explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gbbG

Settings

Optimization(s) for this plan:

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

HashAggregate (cost=85,572,638.34..85,572,638.40 rows=6 width=59) (actual rows= loops=)

  • Group Key: ord_proc_state.status_name
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..85,571,299.59 rows=19,125 width=59) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..85,528,487.64 rows=19,128 width=51) (actual rows= loops=)

  • Join Filter: ((ord_obj.ord_proc_state_guid)::text = (ord_proc_state.ord_proc_state_guid)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on ord_obj (cost=0.00..85,504,955.72 rows=33,372 width=73) (actual rows= loops=)

  • Filter: (((SubPlan 1))::text = 'AUSTIN'::text)
5.          

SubPlan (for Seq Scan)

6. 0.000 0.000 ↓ 0.0

Function Scan on ancestors_by_ord_obj_guid (cost=0.25..12.75 rows=5 width=32) (actual rows= loops=)

  • Filter: (level_rank = 200)
7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..4.77 rows=47 width=50) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on ord_proc_state (cost=0.00..4.54 rows=47 width=50) (actual rows= loops=)

  • Filter: ((status_name)::text = ANY ('{Hold,"Need INSTALLS inc Action",Prescheduled,Scheduled,Unscheduled,"Waiting Client Action","Waiting Customer Action"}'::text[]))
9. 0.000 0.000 ↓ 0.0

Index Scan using ord_dates_ord_obj_guid_key on ord_dates (cost=0.56..2.23 rows=1 width=45) (actual rows= loops=)

  • Index Cond: ((ord_obj_guid)::text = (ord_obj.ord_obj_guid)::text)