explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ttTI

Settings
# exclusive inclusive rows x rows loops node
1. 487.967 131,339.155 ↑ 1,021.3 23 1

Nested Loop (cost=0.00..348,515,302.64 rows=23,490 width=22,310) (actual time=53,129.367..131,339.155 rows=23 loops=1)

  • Join Filter: (internal_order.proj_id = p.id)
  • Rows Removed by Join Filter: 8303030
2. 85,941.970 130,520.366 ↓ 1.1 36,758 1

Seq Scan on internal_order (cost=0.00..348,406,746.03 rows=32,117 width=5,340) (actual time=20,040.089..130,520.366 rows=36,758 loops=1)

  • Filter: (NOT (SubPlan 1))
  • Rows Removed by Filter: 27476
3.          

SubPlan (forSeq Scan)

4. 44,508.300 44,578.396 ↑ 1.3 21,600 64,234

Materialize (cost=0.00..10,779.14 rows=27,476 width=516) (actual time=0.000..0.694 rows=21,600 loops=64,234)

5. 70.096 70.096 ↑ 1.0 27,476 1

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

6. 330.748 330.822 ↑ 1.0 226 36,758

Materialize (cost=0.00..29.99 rows=226 width=16,970) (actual time=0.000..0.009 rows=226 loops=36,758)

7. 0.074 0.074 ↑ 1.0 226 1

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

  • Filter: (proj_type = 'LOW_RISE'::proj_type)
  • Rows Removed by Filter: 83