explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RNdQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.061 0.536 ↑ 1.0 1 1

Aggregate (cost=3,433.71..3,433.72 rows=1 width=8) (actual time=0.536..0.536 rows=1 loops=1)

  • Buffers: shared hit=99
2. 0.099 0.475 ↓ 2.1 853 1

Nested Loop (cost=1.00..3,432.68 rows=412 width=0) (actual time=0.046..0.475 rows=853 loops=1)

  • Buffers: shared hit=99
3. 0.004 0.040 ↑ 1.2 4 1

Nested Loop (cost=0.57..27.14 rows=5 width=8) (actual time=0.030..0.040 rows=4 loops=1)

  • Buffers: shared hit=9
4. 0.016 0.016 ↑ 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.016 rows=1 loops=1)

  • Index Cond: (id = 3)
  • Heap Fetches: 1
  • Buffers: shared hit=3
5. 0.020 0.020 ↑ 1.2 4 1

Index Scan using ligne_assortiment_assortiment_id_idx on ligne_assortiment lass (cost=0.29..18.79 rows=5 width=16) (actual time=0.012..0.020 rows=4 loops=1)

  • Index Cond: (assortiment_id = 3)
  • Buffers: shared hit=6
6. 0.336 0.336 ↓ 1.1 213 4

Index Only Scan using param_ligne_assortiment_magasin_ligne_ass_idx on param_ligne_assortiment_magasin p (cost=0.43..679.10 rows=201 width=8) (actual time=0.013..0.084 rows=213 loops=4)

  • Index Cond: (ligne_assortiment_id = lass.id)
  • Heap Fetches: 853
  • Buffers: shared hit=90
Planning time : 0.376 ms
Execution time : 0.611 ms