explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BuXr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 52.106 1,177.529 ↑ 15.7 1,228 1

HashAggregate (cost=99,406.31..99,599.06 rows=19,275 width=29) (actual time=1,177.177..1,177.529 rows=1,228 loops=1)

  • Group Key: a.code
  • Buffers: shared hit=51869
2. 43.657 1,125.423 ↓ 1.8 175,795 1

Hash Join (cost=2,321.67..98,402.25 rows=100,406 width=15) (actual time=10.580..1,125.423 rows=175,795 loops=1)

  • Hash Cond: (lass.article_id = a.id)
  • Buffers: shared hit=51869
3. 23.635 1,072.823 ↓ 1.8 175,795 1

Nested Loop (cost=868.99..96,685.94 rows=100,406 width=18) (actual time=1.493..1,072.823 rows=175,795 loops=1)

  • Buffers: shared hit=50850
4. 0.020 0.020 ↑ 1.0 1 1

Index Only Scan using param_assortiment_magasin_assortiment_idx on assortiment ass (cost=0.28..4.30 rows=1 width=8) (actual time=0.017..0.020 rows=1 loops=1)

  • Index Cond: (id = 2)
  • Heap Fetches: 0
  • Buffers: shared hit=3
5. 712.376 1,049.168 ↓ 1.8 175,795 1

Hash Right Join (cost=868.70..95,677.58 rows=100,406 width=26) (actual time=1.474..1,049.168 rows=175,795 loops=1)

  • Hash Cond: (p.ligne_assortiment_id = lass.id)
  • Buffers: shared hit=50847
6. 335.348 335.348 ↓ 1.0 3,526,266 1

Seq Scan on param_ligne_assortiment_magasin p (cost=0.00..85,560.90 rows=3,522,690 width=18) (actual time=0.006..335.348 rows=3,526,266 loops=1)

  • Buffers: shared hit=50334
7. 0.226 1.444 ↓ 1.0 1,228 1

Hash (cost=853.45..853.45 rows=1,220 width=24) (actual time=1.443..1.444 rows=1,228 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
  • Buffers: shared hit=513
8. 1.056 1.218 ↓ 1.0 1,228 1

Bitmap Heap Scan on ligne_assortiment lass (cost=29.74..853.45 rows=1,220 width=24) (actual time=0.238..1.218 rows=1,228 loops=1)

  • Recheck Cond: (assortiment_id = 2)
  • Heap Blocks: exact=501
  • Buffers: shared hit=513
9. 0.162 0.162 ↓ 1.0 1,228 1

Bitmap Index Scan on ligne_assortiment_assortiment_id_idx (cost=0.00..29.44 rows=1,220 width=0) (actual time=0.162..0.162 rows=1,228 loops=1)

  • Index Cond: (assortiment_id = 2)
  • Buffers: shared hit=12
10. 3.595 8.943 ↓ 1.0 19,278 1

Hash (cost=1,211.75..1,211.75 rows=19,275 width=13) (actual time=8.943..8.943 rows=19,278 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1160kB
  • Buffers: shared hit=1019
11. 5.348 5.348 ↓ 1.0 19,278 1

Seq Scan on article a (cost=0.00..1,211.75 rows=19,275 width=13) (actual time=0.004..5.348 rows=19,278 loops=1)

  • Buffers: shared hit=1019
Planning time : 0.548 ms
Execution time : 1,178.147 ms