explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.026 618.749 ↑ 10.7 55 1

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

  • Group Key: echangearticle_labelechart_id
2. 0.000 618.723 ↑ 8.5 139 1

Sort (cost=1,200,841.64..1,200,844.58 rows=1,178 width=12) (actual time=618.716..618.723 rows=139 loops=1)

  • Sort Key: echangearticle_labelechart_id
  • Sort Method: quicksort Memory: 31kB
3. 94.843 708.758 ↑ 8.5 139 1

Gather (cost=1,200,657.86..1,200,781.55 rows=1,178 width=12) (actual time=617.504..708.758 rows=139 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 82.733 613.915 ↑ 12.8 46 3

Partial HashAggregate (cost=1,199,657.86..1,199,663.75 rows=589 width=12) (actual time=613.902..613.915 rows=46 loops=3)

  • Group Key: echangearticle_labelechart_id
5. 402.715 531.182 ↓ 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=163.277..531.182 rows=563,807 loops=3)

  • Recheck Cond: ((echangearticle_dossier_id = 148) AND (echangearticle_etattraitement = 0))
  • Rows Removed by Index Recheck: 37950
  • Heap Blocks: exact=58388 lossy=37013
6. 128.467 128.467 ↓ 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=128.467..128.467 rows=1,696,545 loops=1)

  • Index Cond: ((echangearticle_dossier_id = 148) AND (echangearticle_etattraitement = 0))