explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BMBI : Optimization for: Optimization for: plan #8gct; plan #4W3b

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.037 962.345 ↓ 1.7 101 1

Hash Right Join (cost=1,200,931.39..1,200,953.55 rows=60 width=140) (actual time=962.285..962.345 rows=101 loops=1)

  • Hash Cond: (echangearticle.echangearticle_labelechart_id = labelechart.labelechart_id)
2. 0.027 961.919 ↑ 10.7 55 1

Finalize GroupAggregate (cost=1,200,841.64..1,200,856.36 rows=589 width=12) (actual time=961.891..961.919 rows=55 loops=1)

  • Group Key: echangearticle.echangearticle_labelechart_id
3. 0.000 961.892 ↑ 8.7 136 1

Sort (cost=1,200,841.64..1,200,844.58 rows=1,178 width=12) (actual time=961.885..961.892 rows=136 loops=1)

  • Sort Key: echangearticle.echangearticle_labelechart_id
  • Sort Method: quicksort Memory: 31kB
4. 100.560 1,050.635 ↑ 8.7 136 1

Gather (cost=1,200,657.86..1,200,781.55 rows=1,178 width=12) (actual time=957.231..1,050.635 rows=136 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 120.137 950.075 ↑ 13.1 45 3

Partial HashAggregate (cost=1,199,657.86..1,199,663.75 rows=589 width=12) (actual time=950.065..950.075 rows=45 loops=3)

  • Group Key: echangearticle.echangearticle_labelechart_id
6. 693.586 829.938 ↓ 2.3 563,807 3

Parallel Bitmap Heap Scan on echangearticle (cost=14,853.71..1,198,428.33 rows=245,905 width=4) (actual time=172.931..829.938 rows=563,807 loops=3)

  • Recheck Cond: ((echangearticle_dossier_id = 148) AND (echangearticle_etattraitement = 0))
  • Rows Removed by Index Recheck: 37950
  • Heap Blocks: exact=42320 lossy=27498
7. 136.352 136.352 ↓ 2.9 1,696,545 1

Bitmap Index Scan on echangearticle_etattraitement_sk (cost=0.00..14,706.16 rows=590,173 width=0) (actual time=136.352..136.352 rows=1,696,545 loops=1)

  • Index Cond: ((echangearticle_dossier_id = 148) AND (echangearticle_etattraitement = 0))
8. 0.011 0.389 ↓ 1.7 101 1

Hash (cost=89.00..89.00 rows=60 width=128) (actual time=0.389..0.389 rows=101 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
9. 0.378 0.378 ↓ 1.7 101 1

Seq Scan on labelechart (cost=0.00..89.00 rows=60 width=128) (actual time=0.009..0.378 rows=101 loops=1)

  • Filter: (labelechart_dossier_id = 148)
  • Rows Removed by Filter: 3052