explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LOoQ

Settings
# exclusive inclusive rows x rows loops node
1. 2.876 364.160 ↑ 1.0 1 1

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

2. 2.266 361.284 ↓ 65.1 29,438 1

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

3. 0.037 0.037 ↑ 1.0 1 1

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

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

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

  • Hash Cond: (ebmarchand0_.x_eb_demande = ebdemande1_.eb_demande_num)
5. 5.394 5.394 ↑ 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.018..5.394 rows=45,299 loops=1)

6. 10.999 335.501 ↓ 65.4 29,368 1

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

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

Seq Scan on eb_demande ebdemande1_ (cost=0.00..38,189.16 rows=449 width=36) (actual time=2.826..324.502 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 : 2.052 ms