explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nnlP

Settings
# exclusive inclusive rows x rows loops node
1. 50.881 1,313.151 ↑ 15.7 1,229 1

HashAggregate (cost=98,543.76..98,736.51 rows=19,275 width=29) (actual time=1,312.716..1,313.151 rows=1,229 loops=1)

  • Group Key: a.code
  • Buffers: shared hit=50979
2. 42.655 1,262.270 ↓ 1.8 176,221 1

Hash Join (cost=2,027.37..97,538.23 rows=100,553 width=15) (actual time=17.152..1,262.270 rows=176,221 loops=1)

  • Hash Cond: (lass.article_id = a.id)
  • Buffers: shared hit=50979
3. 23.331 1,207.223 ↓ 1.8 176,221 1

Nested Loop (cost=848.68..96,095.54 rows=100,553 width=18) (actual time=4.585..1,207.223 rows=176,221 loops=1)

  • Buffers: shared hit=50234
4. 0.080 0.080 ↑ 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.074..0.080 rows=1 loops=1)

  • Index Cond: (id = 2)
  • Heap Fetches: 1
  • Buffers: shared hit=6
5. 563.292 1,183.812 ↓ 1.8 176,221 1

Hash Right Join (cost=848.40..95,081.71 rows=100,553 width=26) (actual time=4.507..1,183.812 rows=176,221 loops=1)

  • Hash Cond: (p.ligne_assortiment_id = lass.id)
  • Buffers: shared hit=50228
6. 616.068 616.068 ↑ 1.0 3,524,571 1

Seq Scan on param_ligne_assortiment_magasin p (cost=0.00..84,979.42 rows=3,524,942 width=18) (actual time=0.018..616.068 rows=3,524,571 loops=1)

  • Buffers: shared hit=49730
7. 0.265 4.452 ↓ 1.0 1,229 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
  • Buffers: shared hit=495
8. 3.974 4.187 ↓ 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.293..4.187 rows=1,229 loops=1)

  • Recheck Cond: (assortiment_id = 2)
  • Heap Blocks: exact=490
  • Buffers: shared hit=495
9. 0.213 0.213 ↓ 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.213..0.213 rows=1,229 loops=1)

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

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

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

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

  • Buffers: shared hit=745
Planning time : 2.876 ms
Execution time : 1,314.248 ms