explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yAIR

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

Nested Loop (cost=0.72..901,015.80 rows=287 width=276) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..894,389.86 rows=287 width=83) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..679,952.32 rows=32,132 width=20) (actual rows= loops=)

  • Join Filter: (p.nature_decision_id = nd.nature_decision_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on proposition p (cost=0.00..677,541.36 rows=53,553 width=28) (actual rows= loops=)

  • Filter: (date_attribution IS NULL)
5. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.08 rows=3 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on nature_decision nd (cost=0.00..1.07 rows=3 width=8) (actual rows= loops=)

  • Filter: ((code)::text = ANY ('{ACCORD,ACCORD_PRESC,ACCORD_TACITE}'::text[]))
7. 0.000 0.000 ↓ 0.0

Index Scan using pk_dossier on dossier d (cost=0.43..6.66 rows=1 width=71) (actual rows= loops=)

  • Index Cond: (dossier_id = p.dossier_id)
  • Filter: ((platau_id IS NOT NULL) AND (NOT si_supprime) AND (centre_instructeur_id = ANY ('{3643,3781,1044,3820,3761,3740,3780,3720,3644,3700}'::bigint[])))
8. 0.000 0.000 ↓ 0.0

Index Scan using pk_commune on commune c (cost=0.29..4.13 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (commune_id = d.commune_id)
9.          

SubPlan (for Nested Loop)

10. 0.000 0.000 ↓ 0.0

Index Scan using pk_commune_reference on commune_reference cr (cost=0.29..8.31 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (commune_reference_id = c.commune_reference_id)
11. 0.000 0.000 ↓ 0.0

Seq Scan on type_dossier td (cost=0.00..1.09 rows=1 width=78) (actual rows= loops=)

  • Filter: (type_dossier_id = d.type_dossier_id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on type_dossier td_1 (cost=0.00..1.09 rows=1 width=32) (actual rows= loops=)

  • Filter: (type_dossier_id = d.type_dossier_id)
13. 0.000 0.000 ↓ 0.0

Index Scan using fk_possede_les_demandeurs on demandeur dem (cost=0.43..8.46 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (dossier_id = d.dossier_id)
  • Filter: si_demandeur_designe