explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jItf : 2.0

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

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

2. 0.002 0.519 ↑ 1.0 1 1

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

3. 0.002 0.508 ↑ 1.0 1 1

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

4. 0.002 0.490 ↑ 1.0 1 1

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

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_type_programmeid = sm001000_pi2_concerne_14ext.sm001000_pi9_type_programmeid)
5. 0.002 0.480 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.15..103.58 rows=1 width=3,966) (actual time=0.469..0.480 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.002 0.475 ↑ 1.0 1 1

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

7. 0.004 0.467 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..94.27 rows=1 width=3,887) (actual time=0.457..0.467 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.001 0.458 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..92.55 rows=1 width=3,855) (actual time=0.448..0.458 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.002 0.454 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..91.48 rows=1 width=3,823) (actual time=0.444..0.454 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.002 0.446 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..90.41 rows=1 width=3,791) (actual time=0.436..0.446 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.002 0.441 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..89.32 rows=1 width=3,759) (actual time=0.431..0.441 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.001 0.435 ↑ 1.0 1 1

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

13. 0.003 0.429 ↑ 1.0 1 1

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

14. 0.002 0.397 ↑ 1.0 1 1

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

15. 0.004 0.383 ↑ 1.0 1 1

Nested Loop Left Join (cost=40.89..63.04 rows=1 width=3,677) (actual time=0.374..0.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.002 0.375 ↑ 1.0 1 1

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

17. 0.002 0.369 ↑ 1.0 1 1

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

18. 0.054 0.360 ↑ 1.0 1 1

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

  • Hash Cond: (sm001000_pi2_concerne_12ext.sm001000_pi1_voletid = sm001000_pi2_projet_infrastructure.sm001000_pi1_voletid)
19. 0.009 0.009 ↑ 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.003..0.009 rows=40 loops=1)

20. 0.010 0.297 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
21. 0.003 0.287 ↑ 1.0 1 1

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

22. 0.031 0.273 ↑ 1.0 1 1

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

  • Hash Cond: (sm001000_pi2_concerne_13ext.sm001000_pi1_sous_voletid = sm001000_pi2_projet_infrastructure.sm001000_pi1_sous_voletid)
23. 0.017 0.017 ↑ 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.004..0.017 rows=53 loops=1)

24. 0.012 0.225 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
25. 0.002 0.213 ↑ 1.0 1 1

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

26. 0.002 0.188 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..15.95 rows=1 width=3,471) (actual time=0.185..0.188 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.003 0.172 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..14.86 rows=1 width=3,439) (actual time=0.169..0.172 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.003 0.158 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..13.75 rows=1 width=3,407) (actual time=0.155..0.158 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.004 0.151 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..12.34 rows=1 width=3,375) (actual time=0.148..0.151 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.023 0.127 ↑ 1.0 1 1

Hash Right Join (cost=9.74..11.19 rows=1 width=3,343) (actual time=0.125..0.127 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.003 0.003 ↑ 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.002..0.003 rows=32 loops=1)

32. 0.013 0.101 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
33. 0.026 0.088 ↑ 1.0 1 1

Hash Right Join (cost=8.32..9.72 rows=1 width=3,311) (actual time=0.085..0.088 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.016 0.016 ↑ 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.014..0.016 rows=32 loops=1)

35. 0.014 0.046 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
36. 0.032 0.032 ↑ 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.031..0.032 rows=1 loops=1)

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

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

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

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

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

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

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi2_projet_infrastructureid_actf = sm001000_pi2_projet_infrastructureid)
43. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi_ni_orgn_mand = accountid)
44. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (sm001000_pi2_projet_infrastructure.sm001000_pi_ni_orgn_arrn = accountid)
45. 0.004 0.004 ↑ 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.004..0.004 rows=11 loops=1)

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

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

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

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

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

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

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

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

54. 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_infrastructure.sm001000_pi1_etape_realisation_projetid = sm001000_pi1_etape_realisation_projetid)
55. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

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

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

  • Index Cond: (sm001000_pi2_projet_infrastructure.createdby = systemuserid)
58. 0.009 0.009 ↑ 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.009..0.009 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 : 38.466 ms
Execution time : 2.677 ms