explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HG74

Settings
# exclusive inclusive rows x rows loops node
1. 46.747 1,049.518 ↑ 15.7 1,229 1

HashAggregate (cost=98,528.22..98,720.97 rows=19,275 width=29) (actual time=1,049.130..1,049.518 rows=1,229 loops=1)

  • Group Key: a.code
  • Buffers: shared hit=50965
2. 39.219 1,002.771 ↓ 1.8 176,263 1

Hash Join (cost=2,027.37..97,522.86 rows=100,536 width=15) (actual time=9.984..1,002.771 rows=176,263 loops=1)

  • Hash Cond: (lass.article_id = a.id)
  • Buffers: shared hit=50965
3. 22.629 955.300 ↓ 1.8 176,263 1

Nested Loop (cost=848.68..96,080.21 rows=100,536 width=18) (actual time=1.668..955.300 rows=176,263 loops=1)

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

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

  • Index Cond: (id = 2)
  • Heap Fetches: 1
  • Buffers: shared hit=3
5. 539.246 932.651 ↓ 1.8 176,263 1

Hash Right Join (cost=848.40..95,066.55 rows=100,536 width=26) (actual time=1.650..932.651 rows=176,263 loops=1)

  • Hash Cond: (p.ligne_assortiment_id = lass.id)
  • Buffers: shared hit=50217
6. 391.779 391.779 ↓ 1.0 3,524,614 1

Seq Scan on param_ligne_assortiment_magasin p (cost=0.00..84,965.75 rows=3,524,375 width=18) (actual time=0.009..391.779 rows=3,524,614 loops=1)

  • Buffers: shared hit=49722
7. 0.215 1.626 ↓ 1.0 1,229 1

Hash (cost=833.14..833.14 rows=1,221 width=24) (actual time=1.625..1.626 rows=1,229 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
  • Buffers: shared hit=495
8. 1.281 1.411 ↓ 1.0 1,229 1

Bitmap Heap Scan on ligne_assortiment lass (cost=25.75..833.14 rows=1,221 width=24) (actual time=0.194..1.411 rows=1,229 loops=1)

  • Recheck Cond: (assortiment_id = 2)
  • Heap Blocks: exact=490
  • Buffers: shared hit=495
9. 0.130 0.130 ↓ 1.0 1,229 1

Bitmap Index Scan on ligne_assortiment_assortiment_id_idx (cost=0.00..25.45 rows=1,221 width=0) (actual time=0.130..0.130 rows=1,229 loops=1)

  • Index Cond: (assortiment_id = 2)
  • Buffers: shared hit=5
10. 3.209 8.252 ↑ 1.0 19,275 1

Hash (cost=937.75..937.75 rows=19,275 width=13) (actual time=8.252..8.252 rows=19,275 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1160kB
  • Buffers: shared hit=745
11. 5.043 5.043 ↑ 1.0 19,275 1

Seq Scan on article a (cost=0.00..937.75 rows=19,275 width=13) (actual time=0.006..5.043 rows=19,275 loops=1)

  • Buffers: shared hit=745
Planning time : 0.544 ms
Execution time : 1,049.837 ms