explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 267.674 ↑ 5.8 101 1

Finalize GroupAggregate (cost=1,000.46..182,979.65 rows=589 width=12) (actual time=4.218..267.674 rows=101 loops=1)

  • Group Key: echangearticle_labelechart_id
2. 0.000 292.518 ↑ 7.1 167 1

Gather Merge (cost=1,000.46..182,967.87 rows=1,178 width=12) (actual time=4.204..292.518 rows=167 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 180.231 561.567 ↑ 10.5 56 3

Partial GroupAggregate (cost=0.43..181,831.88 rows=589 width=12) (actual time=0.130..187.189 rows=56 loops=3)

  • Group Key: echangearticle_labelechart_id
4. 381.336 381.336 ↑ 1.1 564,928 3

Parallel Index Only Scan using echangearticle_labelechart_sk on echangearticle (cost=0.43..178,663.36 rows=632,527 width=4) (actual time=0.022..127.112 rows=564,928 loops=3)

  • Index Cond: (echangearticle_dossier_id = 148)
  • Heap Fetches: 505