explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N9av

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 6.935 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.98..129.54 rows=1 width=4,063) (actual time=6.922..6.935 rows=1 loops=1)

2. 0.004 6.916 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.70..121.24 rows=1 width=4,034) (actual time=6.903..6.916 rows=1 loops=1)

3. 0.005 6.902 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.42..112.93 rows=1 width=4,016) (actual time=6.889..6.902 rows=1 loops=1)

4. 0.006 6.695 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.15..104.62 rows=1 width=3,998) (actual time=6.682..6.695 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_type_programmeid = sm001000_pi2_concerne_14ext.sm001000_pi9_type_programmeid)
5. 0.004 6.678 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.15..103.58 rows=1 width=3,966) (actual time=6.665..6.678 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_entite_budgetaireid = sm001000_pi2_est_finance_1ext.sm001000_pi9_entite_budgetaireid)
6. 0.004 6.670 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.15..102.53 rows=1 width=3,934) (actual time=6.658..6.670 rows=1 loops=1)

7. 0.005 6.663 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..94.27 rows=1 width=3,887) (actual time=6.651..6.663 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_indicateur_controle_compid = sm001000_pi2_evalue_1ext.sm001000_pi9_indicateur_controle_compid)
  • Rows Removed by Join Filter: 32
8. 0.005 6.654 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..92.55 rows=1 width=3,855) (actual time=6.641..6.654 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_niveau_risqueid = sm001000_pi2_est_associe_6ext.sm001000_pi9_niveau_risqueid)
  • Rows Removed by Join Filter: 3
9. 0.005 6.645 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..91.48 rows=1 width=3,823) (actual time=6.633..6.645 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_periode_financement_bas_fedid = sm001000_pi2_concerne_3ext.sm001000_pi9_periode_financement_bas_fedid)
  • Rows Removed by Join Filter: 3
10. 0.005 6.636 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..90.41 rows=1 width=3,791) (actual time=6.624..6.636 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_condition_protocoleid = sm001000_pi2_concerne_2ext.sm001000_pi9_condition_protocoleid)
  • Rows Removed by Join Filter: 4
11. 0.006 6.627 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..89.32 rows=1 width=3,759) (actual time=6.615..6.627 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_autorite_priorisanteid = sm001000_pi2_priorise_parext.sm001000_pi9_autorite_priorisanteid)
  • Rows Removed by Join Filter: 5
12. 0.005 6.614 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..88.21 rows=1 width=3,727) (actual time=6.602..6.614 rows=1 loops=1)

13. 0.006 6.421 ↑ 1.0 1 1

Nested Loop Left Join (cost=41.59..79.78 rows=1 width=3,711) (actual time=6.409..6.421 rows=1 loops=1)

14. 0.005 6.401 ↑ 1.0 1 1

Nested Loop Left Join (cost=41.17..71.35 rows=1 width=3,695) (actual time=6.389..6.401 rows=1 loops=1)

15. 0.009 6.383 ↑ 1.0 1 1

Nested Loop Left Join (cost=40.89..63.04 rows=1 width=3,677) (actual time=6.372..6.383 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi1_programmeid = sm001000_pi2_concerne_11ext.sm001000_pi1_programmeid)
  • Rows Removed by Join Filter: 10
16. 0.004 6.368 ↑ 1.0 1 1

Nested Loop Left Join (cost=40.89..60.50 rows=1 width=3,645) (actual time=6.357..6.368 rows=1 loops=1)

17. 0.005 6.358 ↑ 1.0 1 1

Nested Loop Left Join (cost=40.61..52.19 rows=1 width=3,616) (actual time=6.347..6.358 rows=1 loops=1)

18. 0.931 6.350 ↑ 1.0 1 1

Hash Right Join (cost=40.33..43.89 rows=1 width=3,587) (actual time=6.340..6.350 rows=1 loops=1)

  • Hash Cond: (sm001000_pi2_concerne_12ext.sm001000_pi1_voletid = sm001000_pi2_projet_infrastructure.sm001000_pi1_voletid)
19. 0.016 0.016 ↑ 1.0 40 1

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

20. 0.008 5.403 ↑ 1.0 1 1

Hash (cost=40.32..40.32 rows=1 width=3,555) (actual time=5.403..5.403 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
21. 0.006 5.395 ↑ 1.0 1 1

Nested Loop Left Join (cost=24.56..40.32 rows=1 width=3,555) (actual time=5.371..5.395 rows=1 loops=1)

22. 0.421 4.304 ↑ 1.0 1 1

Hash Right Join (cost=24.27..32.01 rows=1 width=3,521) (actual time=4.280..4.304 rows=1 loops=1)

  • Hash Cond: (sm001000_pi2_concerne_13ext.sm001000_pi1_sous_voletid = sm001000_pi2_projet_infrastructure.sm001000_pi1_sous_voletid)
23. 0.201 0.201 ↑ 1.0 53 1

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

24. 0.224 3.682 ↑ 1.0 1 1

Hash (cost=24.26..24.26 rows=1 width=3,489) (actual time=3.682..3.682 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
25. 0.007 3.458 ↑ 1.0 1 1

Nested Loop Left Join (cost=10.01..24.26 rows=1 width=3,489) (actual time=3.454..3.458 rows=1 loops=1)

26. 0.004 3.213 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..15.95 rows=1 width=3,471) (actual time=3.210..3.213 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_direction_responsable_dossid = sm001000_pi1_identifie_2ext.sm001000_pi9_direction_responsable_dossid)
  • Rows Removed by Join Filter: 1
27. 0.005 3.204 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..14.86 rows=1 width=3,439) (actual time=3.201..3.204 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_echeance_amortissementid = sm001000_pi2_est_associe_3ext.sm001000_pi9_echeance_amortissementid)
  • Rows Removed by Join Filter: 3
28. 0.006 3.194 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..13.75 rows=1 width=3,407) (actual time=3.191..3.194 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_motif_non_admissibiliteid = sm001000_pi2_explique_1ext.sm001000_pi9_motif_non_admissibiliteid)
  • Rows Removed by Join Filter: 18
29. 0.011 3.182 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..12.34 rows=1 width=3,375) (actual time=3.179..3.182 rows=1 loops=1)

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_motif_arret_versementid = sm001000_pi2_explique_3ext.sm001000_pi9_motif_arret_versementid)
  • Rows Removed by Join Filter: 7
30. 0.410 3.166 ↑ 1.0 1 1

Hash Right Join (cost=9.74..11.19 rows=1 width=3,343) (actual time=3.164..3.166 rows=1 loops=1)

  • Hash Cond: (sm001000_pi2_evalue_2ext.sm001000_pi9_indicateur_controle_compid = sm001000_pi2_projet_infrastructure.sm001000_pi9_indicateur_controle_comp2id)
31. 0.007 0.007 ↑ 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.005..0.007 rows=32 loops=1)

32. 0.223 2.749 ↑ 1.0 1 1

Hash (cost=9.72..9.72 rows=1 width=3,311) (actual time=2.749..2.749 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
33. 1.635 2.526 ↑ 1.0 1 1

Hash Right Join (cost=8.32..9.72 rows=1 width=3,311) (actual time=2.522..2.526 rows=1 loops=1)

  • Hash Cond: (sm001000_pi2_evalue_3ext.sm001000_pi9_indicateur_controle_compid = sm001000_pi2_projet_infrastructure.sm001000_pi9_indicateur_controle_comp3id)
34. 0.020 0.020 ↑ 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.018..0.020 rows=32 loops=1)

35. 0.210 0.871 ↑ 1.0 1 1

Hash (cost=8.31..8.31 rows=1 width=3,279) (actual time=0.871..0.871 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
36. 0.661 0.661 ↑ 1.0 1 1

Index Scan using ndx_pi2_projet_infrastructurebase_pi2_projet_infrastructureid on sm001000_pi2_projet_infrastructurebase sm001000_pi2_projet_infrastructure (cost=0.29..8.31 rows=1 width=3,279) (actual time=0.658..0.661 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructureid = 'd8579ed5-f7cd-4d22-8608-f0299a504404'::uuid)
37. 0.005 0.005 ↑ 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.005..0.005 rows=7 loops=1)

38. 0.006 0.006 ↑ 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.005..0.006 rows=18 loops=1)

39. 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.005..0.005 rows=4 loops=1)

40. 0.005 0.005 ↑ 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.005..0.005 rows=2 loops=1)

41. 0.238 0.238 ↑ 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.238..0.238 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi_ni_util_revs = systemuserid)
42. 1.085 1.085 ↓ 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=1.085..1.085 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi2_projet_infrastructureid_actf = sm001000_pi2_projet_infrastructureid)
43. 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_infrastructure.sm001000_pi_ni_orgn_mand = accountid)
44. 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_infrastructure.sm001000_pi_ni_orgn_arrn = accountid)
45. 0.006 0.006 ↑ 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.006..0.006 rows=11 loops=1)

46. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi_ni_util_resp = systemuserid)
47. 0.014 0.014 ↑ 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=0.014..0.014 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi_ni_repn_reqr = contactid)
48. 0.188 0.188 ↓ 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.188..0.188 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi_ni_repn_mand = contactid)
49. 0.007 0.007 ↑ 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.007 rows=5 loops=1)

50. 0.004 0.004 ↑ 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.004..0.004 rows=4 loops=1)

51. 0.004 0.004 ↑ 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.004..0.004 rows=3 loops=1)

52. 0.004 0.004 ↑ 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.004..0.004 rows=3 loops=1)

53. 0.004 0.004 ↑ 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.002..0.004 rows=32 loops=1)

54. 0.003 0.003 ↓ 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.003..0.003 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi1_etape_realisation_projetid = sm001000_pi1_etape_realisation_projetid)
55. 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)

56. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

57. 0.202 0.202 ↑ 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.202..0.202 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.createdby = systemuserid)
58. 0.010 0.010 ↑ 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.010..0.010 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.modifiedby = systemuserid)
59. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi_ni_orgn_reqr = accountid)
Planning time : 153.268 ms