explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lfdC

Settings
# exclusive inclusive rows x rows loops node
1. 11.940 993.559 ↑ 1.0 1 1

Aggregate (cost=96,346.92..96,346.93 rows=1 width=8) (actual time=993.552..993.559 rows=1 loops=1)

  • Buffers: shared hit=50228
2. 18.469 981.619 ↓ 1.8 176,221 1

Nested Loop (cost=848.68..96,095.54 rows=100,553 width=0) (actual time=1.682..981.619 rows=176,221 loops=1)

  • Buffers: shared hit=50228
3. 0.019 0.019 ↑ 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.019 rows=1 loops=1)

  • Index Cond: (id = 2)
  • Heap Fetches: 1
  • Buffers: shared hit=3
4. 547.127 963.131 ↓ 1.8 176,221 1

Hash Right Join (cost=848.40..95,081.71 rows=100,553 width=8) (actual time=1.665..963.131 rows=176,221 loops=1)

  • Hash Cond: (p.ligne_assortiment_id = lass.id)
  • Buffers: shared hit=50225
5. 414.362 414.362 ↑ 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=8) (actual time=0.009..414.362 rows=3,524,571 loops=1)

  • Buffers: shared hit=49730
6. 0.209 1.642 ↓ 1.0 1,229 1

Hash (cost=833.14..833.14 rows=1,221 width=16) (actual time=1.641..1.642 rows=1,229 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 74kB
  • Buffers: shared hit=495
7. 1.299 1.433 ↓ 1.0 1,229 1

Bitmap Heap Scan on ligne_assortiment lass (cost=25.75..833.14 rows=1,221 width=16) (actual time=0.210..1.433 rows=1,229 loops=1)

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

  • Index Cond: (assortiment_id = 2)
  • Buffers: shared hit=5
Planning time : 0.396 ms
Execution time : 993.637 ms