explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s8G7

Settings
# exclusive inclusive rows x rows loops node
1. 631.809 4,164.884 ↑ 40.6 14,322 1

GroupAggregate (cost=36,811,994.96..39,095,481.36 rows=581,000 width=436) (actual time=3,327.783..4,164.884 rows=14,322 loops=1)

  • Group Key: rapport.programme_acronyme, rapport.projet_no_dossier, exercice_financier.exercice_financier, rapport.programme_id, rapport.programme_nom, rapport.volet_id, rapport.volet_acronyme, rapport.sous_volet_id, rapport.sous_volet_acronyme, rapport.projet_id, rapport.organisme_id, rapport.organisme_nom, rapport.type_pvsv
2. 3,468.993 3,533.075 ↑ 238.9 165,420 1

Sort (cost=36,811,994.96..36,910,771.76 rows=39,510,720 width=436) (actual time=3,327.631..3,533.075 rows=165,420 loops=1)

  • Sort Key: rapport.programme_acronyme, rapport.projet_no_dossier, exercice_financier.exercice_financier, rapport.programme_id, rapport.programme_nom, rapport.volet_id, rapport.volet_acronyme, rapport.sous_volet_id, rapport.sous_volet_acronyme, rapport.projet_id, rapport.organisme_id, rapport.organisme_nom, rapport.type_pvsv
  • Sort Method: external merge Disk: 37,544kB
3. 45.686 64.082 ↑ 238.9 165,420 1

Nested Loop (cost=0.00..495,815.52 rows=39,510,720 width=436) (actual time=0.062..64.082 rows=165,420 loops=1)

4. 18.396 18.396 ↓ 1.9 55,140 1

Seq Scan on rapport (cost=0.00..1,904.52 rows=29,052 width=404) (actual time=0.046..18.396 rows=55,140 loops=1)

5. 0.000 0.000 ↑ 453.3 3 55,140

Materialize (cost=0.00..30.40 rows=1,360 width=32) (actual time=0.000..0.000 rows=3 loops=55,140)

6. 0.004 0.004 ↑ 453.3 3 1

Seq Scan on exercice_financier (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.003..0.004 rows=3 loops=1)