explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3lsQ

Settings
# exclusive inclusive rows x rows loops node
1. 3.581 624.187 ↑ 1.0 1 1

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

2. 4.273 620.606 ↓ 65.1 29,438 1

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

3. 0.048 0.048 ↑ 1.0 1 1

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

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

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

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

6. 19.337 567.958 ↓ 65.4 29,368 1

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

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

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