explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mJju : 1.0

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.626 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.50..130.87 rows=1 width=4,063) (actual time=1.621..1.626 rows=1 loops=1)

2. 0.003 1.619 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..122.56 rows=1 width=4,029) (actual time=1.614..1.619 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_autorite_priorisanteid = sm001000_pi2_priorise_parext.sm001000_pi9_autorite_priorisanteid)
  • Rows Removed by Join Filter: 5
3. 0.002 1.610 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..121.45 rows=1 width=3,997) (actual time=1.606..1.610 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_motif_arret_versementid = sm001000_pi2_explique_3ext.sm001000_pi9_motif_arret_versementid)
  • Rows Removed by Join Filter: 7
4. 0.004 1.605 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..120.29 rows=1 width=3,965) (actual time=1.601..1.605 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_motif_non_admissibiliteid = sm001000_pi2_explique_1ext.sm001000_pi9_motif_non_admissibiliteid)
  • Rows Removed by Join Filter: 18
5. 0.004 1.593 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..118.89 rows=1 width=3,933) (actual time=1.589..1.593 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_indicateur_controle_comp3id = sm001000_pi2_evalue_3ext.sm001000_pi9_indicateur_controle_compid)
  • Rows Removed by Join Filter: 32
6. 0.004 1.586 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..117.17 rows=1 width=3,901) (actual time=1.582..1.586 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_indicateur_controle_comp2id = sm001000_pi2_evalue_2ext.sm001000_pi9_indicateur_controle_compid)
  • Rows Removed by Join Filter: 32
7. 0.004 1.577 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..115.45 rows=1 width=3,869) (actual time=1.573..1.577 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_indicateur_controle_compid = sm001000_pi2_evalue_1ext.sm001000_pi9_indicateur_controle_compid)
  • Rows Removed by Join Filter: 32
8. 0.003 1.564 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..113.73 rows=1 width=3,837) (actual time=1.560..1.564 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_entite_budgetaireid = sm001000_pi2_est_finance_1ext.sm001000_pi9_entite_budgetaireid)
9. 0.002 1.557 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.21..112.68 rows=1 width=3,805) (actual time=1.554..1.557 rows=1 loops=1)

10. 0.001 1.549 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..104.42 rows=1 width=3,758) (actual time=1.546..1.549 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_niveau_risqueid = sm001000_pi2_est_associe_6ext.sm001000_pi9_niveau_risqueid)
  • Rows Removed by Join Filter: 3
11. 0.002 1.541 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..103.35 rows=1 width=3,726) (actual time=1.537..1.541 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_echeance_amortissementid = sm001000_pi2_est_associe_3ext.sm001000_pi9_echeance_amortissementid)
  • Rows Removed by Join Filter: 3
12. 0.002 1.534 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..102.24 rows=1 width=3,694) (actual time=1.530..1.534 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_periode_financement_bas_fedid = sm001000_pi2_concerne_3ext.sm001000_pi9_periode_financement_bas_fedid)
  • Rows Removed by Join Filter: 3
13. 0.002 1.524 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..101.17 rows=1 width=3,662) (actual time=1.520..1.524 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_condition_protocoleid = sm001000_pi2_concerne_2ext.sm001000_pi9_condition_protocoleid)
  • Rows Removed by Join Filter: 4
14. 0.002 1.515 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..100.08 rows=1 width=3,630) (actual time=1.512..1.515 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_type_programmeid = sm001000_pi2_concerne_14ext.sm001000_pi9_type_programmeid)
15. 0.006 1.506 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..99.04 rows=1 width=3,598) (actual time=1.503..1.506 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi1_sous_voletid = sm001000_pi2_concerne_13ext.sm001000_pi1_sous_voletid)
  • Rows Removed by Join Filter: 19
16. 0.006 1.487 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..90.85 rows=1 width=3,566) (actual time=1.484..1.487 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi1_voletid = sm001000_pi2_concerne_12ext.sm001000_pi1_voletid)
  • Rows Removed by Join Filter: 20
17. 0.005 1.471 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..86.95 rows=1 width=3,534) (actual time=1.468..1.471 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi1_programmeid = sm001000_pi2_concerne_11ext.sm001000_pi1_programmeid)
  • Rows Removed by Join Filter: 10
18. 0.003 1.457 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..84.41 rows=1 width=3,502) (actual time=1.455..1.457 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructurebase.sm001000_pi9_direction_responsable_dossid = sm001000_pi1_identifie_2ext.sm001000_pi9_direction_responsable_dossid)
  • Rows Removed by Join Filter: 1
19. 0.001 1.441 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.07..83.32 rows=1 width=3,470) (actual time=1.439..1.441 rows=1 loops=1)

20. 0.002 1.422 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.79..75.01 rows=1 width=3,452) (actual time=1.419..1.422 rows=1 loops=1)

21. 0.004 1.404 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.51..66.70 rows=1 width=3,434) (actual time=1.402..1.404 rows=1 loops=1)

22. 0.003 1.381 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.23..58.40 rows=1 width=3,405) (actual time=1.379..1.381 rows=1 loops=1)

23. 0.001 0.097 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.82..49.96 rows=1 width=3,389) (actual time=0.095..0.097 rows=1 loops=1)

24. 0.002 0.089 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.41..41.53 rows=1 width=3,373) (actual time=0.087..0.089 rows=1 loops=1)

25. 0.002 0.084 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.12..33.23 rows=1 width=3,344) (actual time=0.082..0.084 rows=1 loops=1)

26. 0.003 0.076 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.84..24.93 rows=1 width=3,315) (actual time=0.074..0.076 rows=1 loops=1)

27. 0.006 0.061 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=3,297) (actual time=0.060..0.061 rows=1 loops=1)

28. 0.030 0.030 ↑ 1.0 1 1

Index Scan using ndx_pi2_projet_infrastructurebase_pi2_projet_infrastructureid on sm001000_pi2_projet_infrastructurebase (cost=0.29..8.31 rows=1 width=3,295) (actual time=0.029..0.030 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructureid = 'd8579ed5-f7cd-4d22-8608-f0299a504404'::uuid)
29. 0.025 0.025 ↑ 1.0 1 1

Index Scan using pk_1954106002_cndx_primarykey_systemuser on systemuserbase lk_sm001000_pi2_projet_infrastructure_createdby (cost=0.28..8.29 rows=1 width=34) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.createdby = systemuserid)
30. 0.012 0.012 ↑ 1.0 1 1

Index Scan using pk_1954106002_cndx_primarykey_systemuser on systemuserbase lk_sm001000_pi2_projet_infrastructure_modifiedby (cost=0.28..8.29 rows=1 width=34) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.modifiedby = systemuserid)
31. 0.006 0.006 ↓ 0.0 0 1

Index Scan using pk_2073058421_cndx_primarykey_account on accountbase sm001000_pi2_arrondissement_projet (cost=0.28..8.30 rows=1 width=45) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_orgn_arrn = accountid)
32. 0.003 0.003 ↓ 0.0 0 1

Index Scan using pk_2073058421_cndx_primarykey_account on accountbase sm001000_pi2_mandataire_projet (cost=0.28..8.30 rows=1 width=45) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_orgn_mand = accountid)
33. 0.007 0.007 ↓ 0.0 0 1

Index Scan using pk_693577509_cndx_primarykey_contact on contactbase sm001000_pi2_repondant_mandataire_projet (cost=0.41..8.43 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_repn_mand = contactid)
34. 1.281 1.281 ↑ 1.0 1 1

Index Scan using pk_693577509_cndx_primarykey_contact on contactbase sm001000_pi2_repondant_requerant_projet (cost=0.41..8.43 rows=1 width=32) (actual time=1.281..1.281 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_repn_reqr = contactid)
35. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pk_2073058421_cndx_primarykey_account on accountbase sm001000_pi2_requerant_projet (cost=0.28..8.30 rows=1 width=45) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_orgn_reqr = accountid)
36. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pk_1954106002_cndx_primarykey_systemuser on systemuserbase sm001000_pi2_responsable_1 (cost=0.28..8.29 rows=1 width=34) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_util_resp = systemuserid)
37. 0.018 0.018 ↑ 1.0 1 1

Index Scan using pk_1954106002_cndx_primarykey_systemuser on systemuserbase sm001000_pi2_reviseur (cost=0.28..8.29 rows=1 width=34) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi_ni_util_revs = systemuserid)
38. 0.013 0.013 ↑ 2.0 2 1

Seq Scan on sm001000_pi9_direction_responsable_dossbase sm001000_pi1_identifie_2ext (cost=0.00..1.04 rows=4 width=48) (actual time=0.013..0.013 rows=2 loops=1)

39. 0.009 0.009 ↑ 2.2 11 1

Seq Scan on sm001000_pi1_programmebase sm001000_pi2_concerne_11ext (cost=0.00..2.24 rows=24 width=48) (actual time=0.009..0.009 rows=11 loops=1)

40. 0.010 0.010 ↑ 1.9 21 1

Seq Scan on sm001000_pi1_voletbase sm001000_pi2_concerne_12ext (cost=0.00..3.40 rows=40 width=48) (actual time=0.007..0.010 rows=21 loops=1)

41. 0.013 0.013 ↑ 2.6 20 1

Seq Scan on sm001000_pi1_sous_voletbase sm001000_pi2_concerne_13ext (cost=0.00..7.53 rows=53 width=48) (actual time=0.005..0.013 rows=20 loops=1)

42. 0.007 0.007 ↑ 2.0 1 1

Seq Scan on sm001000_pi9_type_programmebase sm001000_pi2_concerne_14ext (cost=0.00..1.02 rows=2 width=48) (actual time=0.007..0.007 rows=1 loops=1)

43. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on sm001000_pi9_condition_protocolebase sm001000_pi2_concerne_2ext (cost=0.00..1.04 rows=4 width=48) (actual time=0.006..0.007 rows=4 loops=1)

44. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on sm001000_pi9_periode_financement_bas_fedbase sm001000_pi2_concerne_3ext (cost=0.00..1.03 rows=3 width=48) (actual time=0.008..0.008 rows=3 loops=1)

45. 0.005 0.005 ↑ 1.2 4 1

Seq Scan on sm001000_pi9_echeance_amortissementbase sm001000_pi2_est_associe_3ext (cost=0.00..1.05 rows=5 width=48) (actual time=0.004..0.005 rows=4 loops=1)

46. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on sm001000_pi9_niveau_risquebase sm001000_pi2_est_associe_6ext (cost=0.00..1.03 rows=3 width=48) (actual time=0.006..0.007 rows=3 loops=1)

47. 0.006 0.006 ↓ 0.0 0 1

Index Scan using pk_1709470110_pk_sm001000_pi1_etape_realisation_projetbase on sm001000_pi1_etape_realisation_projetbase sm001000_pi2_est_etapeext (cost=0.14..8.16 rows=1 width=63) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi1_etape_realisation_projetid = sm001000_pi1_etape_realisation_projetid)
48. 0.004 0.004 ↑ 2.0 1 1

Seq Scan on sm001000_pi9_entite_budgetairebase sm001000_pi2_est_finance_1ext (cost=0.00..1.02 rows=2 width=48) (actual time=0.004..0.004 rows=1 loops=1)

49. 0.009 0.009 ↑ 1.0 32 1

Seq Scan on sm001000_pi9_indicateur_controle_compbase sm001000_pi2_evalue_1ext (cost=0.00..1.32 rows=32 width=48) (actual time=0.007..0.009 rows=32 loops=1)

50. 0.005 0.005 ↑ 1.0 32 1

Seq Scan on sm001000_pi9_indicateur_controle_compbase sm001000_pi2_evalue_2ext (cost=0.00..1.32 rows=32 width=48) (actual time=0.003..0.005 rows=32 loops=1)

51. 0.003 0.003 ↑ 1.0 32 1

Seq Scan on sm001000_pi9_indicateur_controle_compbase sm001000_pi2_evalue_3ext (cost=0.00..1.32 rows=32 width=48) (actual time=0.001..0.003 rows=32 loops=1)

52. 0.008 0.008 ↑ 1.0 18 1

Seq Scan on sm001000_pi9_motif_non_admissibilitebase sm001000_pi2_explique_1ext (cost=0.00..1.18 rows=18 width=48) (actual time=0.007..0.008 rows=18 loops=1)

53. 0.003 0.003 ↑ 1.0 7 1

Seq Scan on sm001000_pi9_motif_arret_versementbase sm001000_pi2_explique_3ext (cost=0.00..1.07 rows=7 width=48) (actual time=0.003..0.003 rows=7 loops=1)

54. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on sm001000_pi9_autorite_priorisantebase sm001000_pi2_priorise_parext (cost=0.00..1.05 rows=5 width=48) (actual time=0.006..0.006 rows=5 loops=1)

55. 0.005 0.005 ↓ 0.0 0 1

Index Scan using ndx_pi2_projet_infrastructurebase_pi2_projet_infrastructureid on sm001000_pi2_projet_infrastructurebase sm001000_pi2_version_projetext (cost=0.29..8.31 rows=1 width=50) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructurebase.sm001000_pi2_projet_infrastructureid_actf = sm001000_pi2_projet_infrastructureid)
Planning time : 48.915 ms
Execution time : 3.860 ms