explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HxIV

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

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

2. 0.001 0.272 ↑ 1.0 1 1

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

3. 0.003 0.267 ↑ 1.0 1 1

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

4. 0.002 0.258 ↑ 1.0 1 1

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

  • Join Filter: (sm001000_pi2_projet_infrastructure.sm001000_pi9_type_programmeid = sm001000_pi2_concerne_14ext.sm001000_pi9_type_programmeid)
5. 0.001 0.251 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.15..103.58 rows=1 width=3,966) (actual time=0.240..0.251 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.001 0.247 ↑ 1.0 1 1

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

7. 0.004 0.244 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..94.27 rows=1 width=3,887) (actual time=0.233..0.244 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.002 0.237 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..92.55 rows=1 width=3,855) (actual time=0.226..0.237 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.001 0.232 ↑ 1.0 1 1

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

Nested Loop Left Join (cost=42.00..90.41 rows=1 width=3,791) (actual time=0.217..0.228 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.003 0.223 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.00..89.32 rows=1 width=3,759) (actual time=0.213..0.223 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.002 0.217 ↑ 1.0 1 1

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

13. 0.002 0.214 ↑ 1.0 1 1

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

14. 0.002 0.206 ↑ 1.0 1 1

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

15. 0.004 0.199 ↑ 1.0 1 1

Nested Loop Left Join (cost=40.89..63.04 rows=1 width=3,677) (actual time=0.190..0.199 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.001 0.191 ↑ 1.0 1 1

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

17. 0.002 0.189 ↑ 1.0 1 1

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

18. 0.020 0.185 ↑ 1.0 1 1

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

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

20. 0.005 0.155 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
21. 0.002 0.150 ↑ 1.0 1 1

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

22. 0.020 0.147 ↑ 1.0 1 1

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

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

24. 0.005 0.112 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
25. 0.002 0.107 ↑ 1.0 1 1

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

26. 0.002 0.098 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..15.95 rows=1 width=3,471) (actual time=0.095..0.098 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.002 0.093 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..14.86 rows=1 width=3,439) (actual time=0.090..0.093 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.004 0.088 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..13.75 rows=1 width=3,407) (actual time=0.085..0.088 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.003 0.080 ↑ 1.0 1 1

Nested Loop Left Join (cost=9.74..12.34 rows=1 width=3,375) (actual time=0.078..0.080 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.012 0.073 ↑ 1.0 1 1

Hash Right Join (cost=9.74..11.19 rows=1 width=3,343) (actual time=0.071..0.073 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.001..0.003 rows=32 loops=1)

32. 0.005 0.058 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
33. 0.014 0.053 ↑ 1.0 1 1

Hash Right Join (cost=8.32..9.72 rows=1 width=3,311) (actual time=0.050..0.053 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.013 0.013 ↑ 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.011..0.013 rows=32 loops=1)

35. 0.008 0.026 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
36. 0.018 0.018 ↑ 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.017..0.018 rows=1 loops=1)

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

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

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

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

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

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

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

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

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

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

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

54. 0.002 0.002 ↓ 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.002..0.002 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.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

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

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

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

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