explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DjGd

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

Nested Loop (cost=0.00..348,515,302.64 rows=23,490 width=22,310) (actual rows= loops=)

  • Join Filter: (internal_order.proj_id = p.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on internal_order (cost=0.00..348,406,746.03 rows=32,117 width=5,340) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
3.          

SubPlan (forSeq Scan)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..10,779.14 rows=27,476 width=516) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on new_io (cost=0.00..8,816.76 rows=27,476 width=516) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..29.99 rows=226 width=16,970) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on proj p (cost=0.00..28.86 rows=226 width=16,970) (actual rows= loops=)

  • Filter: (proj_type = 'LOW_RISE'::proj_type)