explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d4TD

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 388.737 ↑ 1.0 1 1

Finalize Aggregate (cost=72,326.12..72,326.13 rows=1 width=8) (actual time=388.736..388.737 rows=1 loops=1)

  • Buffers: shared hit=51303
2. 16.285 399.513 ↓ 1.5 3 1

Gather (cost=72,325.90..72,326.11 rows=2 width=8) (actual time=388.538..399.513 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=51303
3. 4.257 383.228 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=71,325.90..71,325.91 rows=1 width=8) (actual time=383.228..383.228 rows=1 loops=3)

  • Buffers: shared hit=51303
4. 184.354 378.971 ↓ 1.4 58,739 3 / 3

Hash Join (cost=877.21..71,221.16 rows=41,897 width=0) (actual time=4.326..378.971 rows=58,739 loops=3)

  • Hash Cond: (p.ligne_assortiment_id = lass.id)
  • Buffers: shared hit=51303
5. 190.420 190.420 ↑ 1.3 1,174,857 3 / 3

Parallel Seq Scan on param_ligne_assortiment_magasin p (cost=0.00..64,417.26 rows=1,468,726 width=8) (actual time=0.014..190.420 rows=1,174,857 loops=3)

  • Buffers: shared hit=49730
6. 0.237 4.197 ↓ 1.0 1,229 3 / 3

Hash (cost=861.95..861.95 rows=1,221 width=8) (actual time=4.197..4.197 rows=1,229 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
  • Buffers: shared hit=1515
7. 0.199 3.960 ↓ 1.0 1,229 3 / 3

Nested Loop (cost=26.31..861.95 rows=1,221 width=8) (actual time=0.398..3.960 rows=1,229 loops=3)

  • Buffers: shared hit=1515
8. 0.003 0.115 ↑ 1.0 1 3 / 3

Nested Loop (cost=0.55..16.60 rows=1 width=8) (actual time=0.111..0.115 rows=1 loops=3)

  • Buffers: shared hit=28
9. 0.058 0.058 ↑ 1.0 1 3 / 3

Index Only Scan using infos_commande_ac_assortiment_idx on infos_commande_ac ica (cost=0.27..8.29 rows=1 width=8) (actual time=0.057..0.058 rows=1 loops=3)

  • Index Cond: (assortiment_id = 2)
  • Heap Fetches: 3
  • Buffers: shared hit=17
10. 0.054 0.054 ↑ 1.0 1 3 / 3

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

  • Index Cond: (id = 2)
  • Heap Fetches: 3
  • Buffers: shared hit=11
11. 3.434 3.646 ↓ 1.0 1,229 3 / 3

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

  • Recheck Cond: (assortiment_id = 2)
  • Heap Blocks: exact=490
  • Buffers: shared hit=1487
12. 0.212 0.212 ↓ 1.0 1,229 3 / 3

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

  • Index Cond: (assortiment_id = 2)
  • Buffers: shared hit=17
Planning time : 0.481 ms
Execution time : 399.653 ms