explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xDwC : Optimization for: plan #BuXr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 445.012 ↑ 15.7 1,226 1

Finalize HashAggregate (cost=78,948.86..79,141.61 rows=19,275 width=29) (actual time=444.687..445.012 rows=1,226 loops=1)

  • Group Key: a.code
  • Buffers: shared hit=54973
2. 14.444 452.070 ↑ 12.3 3,144 1

Gather (cost=74,515.61..78,563.36 rows=38,550 width=29) (actual time=442.675..452.070 rows=3,144 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=54973
3. 17.495 437.626 ↑ 18.4 1,048 3 / 3

Partial HashAggregate (cost=73,515.61..73,708.36 rows=19,275 width=29) (actual time=437.221..437.626 rows=1,048 loops=3)

  • Group Key: a.code
  • Buffers: shared hit=54973
4. 265.751 420.131 ↓ 1.4 58,598 3 / 3

Hash Join (cost=2,162.81..73,097.25 rows=41,836 width=15) (actual time=13.513..420.131 rows=58,598 loops=3)

  • Hash Cond: (p.ligne_assortiment_id = lass.id)
  • Buffers: shared hit=54973
5. 140.948 140.948 ↑ 1.2 1,175,422 3 / 3

Parallel Seq Scan on param_ligne_assortiment_magasin p (cost=0.00..65,011.88 rows=1,467,788 width=18) (actual time=0.012..140.948 rows=1,175,422 loops=3)

  • Buffers: shared hit=50334
6. 0.253 13.432 ↓ 1.0 1,228 3 / 3

Hash (cost=2,147.56..2,147.56 rows=1,220 width=13) (actual time=13.432..13.432 rows=1,228 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=4615
7. 0.166 13.179 ↓ 1.0 1,228 3 / 3

Nested Loop (cost=868.99..2,147.56 rows=1,220 width=13) (actual time=3.415..13.179 rows=1,228 loops=3)

  • Buffers: shared hit=4615
8. 0.057 0.057 ↑ 1.0 1 3 / 3

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

  • Index Cond: (id = 2)
  • Heap Fetches: 0
  • Buffers: shared hit=17
9. 3.668 12.956 ↓ 1.0 1,228 3 / 3

Hash Join (cost=868.70..2,131.06 rows=1,220 width=21) (actual time=3.356..12.956 rows=1,228 loops=3)

  • Hash Cond: (a.id = lass.article_id)
  • Buffers: shared hit=4598
10. 5.972 5.972 ↓ 1.0 19,278 3 / 3

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

  • Buffers: shared hit=3057
11. 0.281 3.316 ↓ 1.0 1,228 3 / 3

Hash (cost=853.45..853.45 rows=1,220 width=24) (actual time=3.315..3.316 rows=1,228 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
  • Buffers: shared hit=1541
12. 2.798 3.035 ↓ 1.0 1,228 3 / 3

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

  • Recheck Cond: (assortiment_id = 2)
  • Heap Blocks: exact=501
  • Buffers: shared hit=1541
13. 0.237 0.237 ↓ 1.0 1,228 3 / 3

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

  • Index Cond: (assortiment_id = 2)
  • Buffers: shared hit=38
Planning time : 0.493 ms
Execution time : 453.868 ms