explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8mLv

Settings
# exclusive inclusive rows x rows loops node
1. 3.145 604.919 ↑ 1.0 1 1

Aggregate (cost=42,541.06..42,541.07 rows=1 width=8) (actual time=604.919..604.919 rows=1 loops=1)

2. 3.471 601.774 ↓ 65.1 29,438 1

Nested Loop (cost=38,194.78..42,539.93 rows=452 width=0) (actual time=562.639..601.774 rows=29,438 loops=1)

3. 0.042 0.042 ↑ 1.0 1 1

Seq Scan on eb_compagnie ebcompagni6_ (cost=0.00..1.73 rows=1 width=4) (actual time=0.041..0.042 rows=1 loops=1)

  • Filter: (eb_compagnie_num = 58)
  • Rows Removed by Filter: 57
4. 28.390 598.261 ↓ 65.1 29,438 1

Hash Join (cost=38,194.78..42,533.69 rows=452 width=4) (actual time=562.595..598.261 rows=29,438 loops=1)

  • Hash Cond: (ebmarchand0_.x_eb_demande = ebdemande1_.eb_demande_num)
5. 7.316 7.316 ↑ 1.0 45,299 1

Seq Scan on eb_marchandise ebmarchand0_ (cost=0.00..4,219.99 rows=45,299 width=4) (actual time=0.017..7.316 rows=45,299 loops=1)

6. 19.210 562.555 ↓ 65.4 29,368 1

Hash (cost=38,189.16..38,189.16 rows=449 width=36) (actual time=562.555..562.555 rows=29,368 loops=1)

  • Buckets: 32,768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,275kB
7. 543.345 543.345 ↓ 65.4 29,368 1

Seq Scan on eb_demande ebdemande1_ (cost=0.00..38,189.16 rows=449 width=36) (actual time=2.529..543.345 rows=29,368 loops=1)

  • Filter: ((x_eb_compagnie = 58) AND ((lower((scenario)::text) = '7'::text) OR (lower((scenario)::text) = '1'::text)))
  • Rows Removed by Filter: 15,402
Planning time : 1.480 ms