explain.depesz.com

PostgreSQL's explain analyze made readable

Result: THKf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=24,407.54..24,407.92 rows=150 width=128) (actual rows= loops=)

  • Sort Key: organisati2_.lib_nom
2. 0.000 0.000 ↓ 0.0

Group (cost=24,400.62..24,402.12 rows=150 width=128) (actual rows= loops=)

  • Group Key: organisati2_.id_organisation
3. 0.000 0.000 ↓ 0.0

Sort (cost=24,400.62..24,401.37 rows=300 width=128) (actual rows= loops=)

  • Sort Key: organisati2_.id_organisation
4. 0.000 0.000 ↓ 0.0

Gather (cost=24,356.78..24,388.28 rows=300 width=128) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=23,356.78..23,358.28 rows=150 width=128) (actual rows= loops=)

  • Group Key: organisati2_.id_organisation
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=54.75..23,154.18 rows=81,038 width=128) (actual rows= loops=)

  • Hash Cond: (dossier0_.id_client = organisati2_.id_organisation)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=27.38..22,108.50 rows=81,038 width=33) (actual rows= loops=)

  • Hash Cond: (dossier0_.id_prestataire = organisati1_.id_organisation)
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on t_dossier dossier0_ (cost=0.00..21,059.38 rows=81,038 width=66) (actual rows= loops=)

  • Filter: ((NOT boo_supprime) AND (NOT boo_en_migration))
9. 0.000 0.000 ↓ 0.0

Hash (cost=25.50..25.50 rows=150 width=33) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on t_organisation organisati1_ (cost=0.00..25.50 rows=150 width=33) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=25.50..25.50 rows=150 width=128) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on t_organisation organisati2_ (cost=0.00..25.50 rows=150 width=128) (actual rows= loops=)