explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jvuY

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1,133,611.917 ↓ 0.0 0 1

GroupAggregate (cost=18,839.82..18,842.45 rows=1 width=1,258) (actual time=1,133,611.917..1,133,611.917 rows=0 loops=1)

  • Group Key: soc.soc_id, groupe_part.groupe_part_id, tranches_1.no_tranches, tranches_gen.tx_int_dero, tranches_gen.tx_int_applique, ((tranches_gen.flag_amort_indirect)::integer), tranches_gen.dte_fin_sus, tranches_gen.type_tx_int, pret_estimation.etat_locatif_annualise1, pret_estimation.etat_locatif_annualise2, tranches_gen.dte_echeance, pret_gages_immobiliers.rue, pret_gages_immobiliers.no_rue, pret_gages_immobiliers.localite, prod.desc_courte, part.nom_part, part.prenom_part, tranches.type_rang, ((SubPlan 1)), dossier.dossier_id, tranches_gen.tx_avance, (((btrim((COALESCE(a1_hyp_part_pret.nom_part, ''::character varying))::text) || ' '::text) || btrim((COALESCE(a1_hyp_part_pret.prenom_part, ''::character varying))::text))), fam_prod.desc_courte, pret_estimation.annee_est_rachat, pret.pret_id, ((SubPlan 2)), type_gage_niv2.libelle, (sum(re_ch_histo.mnt)), pret_gen.frequence_annuite
2. 0.118 1,133,611.912 ↓ 0.0 0 1

Sort (cost=18,839.82..18,839.83 rows=1 width=1,098) (actual time=1,133,611.912..1,133,611.912 rows=0 loops=1)

  • Sort Key: soc.soc_id, tranches_1.no_tranches, tranches_gen.tx_int_dero, tranches_gen.tx_int_applique, ((tranches_gen.flag_amort_indirect)::integer), tranches_gen.dte_fin_sus, tranches_gen.type_tx_int, pret_estimation.etat_locatif_annualise1, pret_estimation.etat_locatif_annualise2, tranches_gen.dte_echeance, pret_gages_immobiliers.rue, pret_gages_immobiliers.no_rue, pret_gages_immobiliers.localite, prod.desc_courte, part.nom_part, part.prenom_part, tranches.type_rang, ((SubPlan 1)), dossier.dossier_id, tranches_gen.tx_avance, (((btrim((COALESCE(a1_hyp_part_pret.nom_part, ''::character varying))::text) || ' '::text) || btrim((COALESCE(a1_hyp_part_pret.prenom_part, ''::character varying))::text))), fam_prod.desc_courte, pret_estimation.annee_est_rachat, pret.pret_id, ((SubPlan 2)), type_gage_niv2.libelle, (sum(re_ch_histo.mnt)), pret_gen.frequence_annuite
  • Sort Method: quicksort Memory: 25kB
3. 0.003 1,133,611.794 ↓ 0.0 0 1

Nested Loop (cost=8,540.57..18,839.81 rows=1 width=1,098) (actual time=1,133,611.794..1,133,611.794 rows=0 loops=1)

  • Join Filter: (dossier.dossier_id = mut_dossier.dossier_id)
4. 0.000 1,133,611.791 ↓ 0.0 0 1

Nested Loop (cost=8,027.82..17,991.55 rows=1 width=543) (actual time=1,133,611.791..1,133,611.791 rows=0 loops=1)

5. 0.007 1,133,611.791 ↓ 0.0 0 1

Nested Loop (cost=8,027.40..17,991.06 rows=1 width=543) (actual time=1,133,611.791..1,133,611.791 rows=0 loops=1)

6. 0.054 0.054 ↑ 1.0 1 1

Index Scan using p_key_gro_par on groupe_part (cost=0.14..2.36 rows=1 width=14) (actual time=0.045..0.054 rows=1 loops=1)

  • Index Cond: (groupe_part_id = 27)
7. 0.001 1,133,611.730 ↓ 0.0 0 1

Nested Loop (cost=8,027.26..17,988.69 rows=1 width=533) (actual time=1,133,611.730..1,133,611.730 rows=0 loops=1)

8. 338.252 1,133,611.729 ↓ 0.0 0 1

Nested Loop (cost=8,026.97..17,986.19 rows=1 width=519) (actual time=1,133,611.729..1,133,611.729 rows=0 loops=1)

9. 602.030 1,128,289.685 ↓ 553,754.7 1,661,264 1

Hash Join (cost=8,026.55..17,984.81 rows=3 width=515) (actual time=78,423.454..1,128,289.685 rows=1,661,264 loops=1)

  • Hash Cond: (pret.dn_produit_dp_id = prod.pro_id)
10. 771.928 1,127,686.822 ↓ 553,754.7 1,661,264 1

Nested Loop (cost=8,016.16..17,974.38 rows=3 width=407) (actual time=78,422.593..1,127,686.822 rows=1,661,264 loops=1)

11. 909.551 1,125,253.630 ↓ 553,754.7 1,661,264 1

Nested Loop (cost=8,015.88..17,973.48 rows=3 width=403) (actual time=78,422.544..1,125,253.630 rows=1,661,264 loops=1)

12. 699,267.468 1,120,119.911 ↓ 528,021.0 528,021 1

Nested Loop (cost=8,015.45..17,970.35 rows=1 width=403) (actual time=9,999.425..1,120,119.911 rows=528,021 loops=1)

  • Join Filter: (tranches_1.tranches_id = tranches_gen.tranches_id)
  • Rows Removed by Join Filter: 9,756,946,181
13. 405.677 6,854.187 ↓ 10,561.2 528,059 1

Nested Loop (cost=7,359.89..13,907.24 rows=50 width=379) (actual time=119.172..6,854.187 rows=528,059 loops=1)

14. 341.862 4,583.942 ↓ 10,594.1 233,071 1

Nested Loop (cost=7,359.47..13,893.82 rows=22 width=331) (actual time=119.152..4,583.942 rows=233,071 loops=1)

15. 490.560 3,347.408 ↓ 10,650.9 223,668 1

Nested Loop Left Join (cost=7,359.05..13,883.87 rows=21 width=327) (actual time=119.119..3,347.408 rows=223,668 loops=1)

16. 0.000 396.500 ↓ 10,650.9 223,668 1

Gather (cost=7,358.63..13,852.30 rows=21 width=185) (actual time=118.431..396.500 rows=223,668 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
17. 74.908 1,571.198 ↓ 9,319.5 111,834 2 / 2

Nested Loop Left Join (cost=6,358.63..12,850.20 rows=12 width=185) (actual time=112.363..1,571.198 rows=111,834 loops=2)

18. 21.611 1,160.788 ↓ 9,319.5 111,834 2 / 2

Nested Loop Left Join (cost=6,358.34..12,843.34 rows=12 width=157) (actual time=111.504..1,160.788 rows=111,834 loops=2)

19. 24.262 1,027.343 ↓ 9,319.5 111,834 2 / 2

Nested Loop Left Join (cost=6,358.20..12,841.45 rows=12 width=43) (actual time=111.098..1,027.343 rows=111,834 loops=2)

20. 69.126 667.579 ↓ 9,319.5 111,834 2 / 2

Nested Loop (cost=6,357.78..12,835.77 rows=12 width=24) (actual time=111.042..667.579 rows=111,834 loops=2)

21. 109.482 256.873 ↓ 127.9 113,860 2 / 2

Parallel Hash Left Join (cost=6,357.35..12,350.77 rows=890 width=16) (actual time=110.670..256.873 rows=113,860 loops=2)

  • Hash Cond: (dossier_gen.dossier_gen_id = pret_gages.dossier_gen_id)
  • Filter: ((pret_gages.flag_principal IS NULL) OR ((pret_gages.flag_principal)::integer = 1))
  • Rows Removed by Filter: 39,482
22. 39.202 39.202 ↑ 1.2 113,860 2 / 2

Parallel Seq Scan on dossier_gen (cost=0.00..4,377.64 rows=134,264 width=8) (actual time=0.054..39.202 rows=113,860 loops=2)

23. 47.815 108.189 ↓ 1.2 150,500 2 / 2

Parallel Hash (cost=4,781.60..4,781.60 rows=126,060 width=13) (actual time=108.189..108.189 rows=150,500 loops=2)

  • Buckets: 524,288 Batches: 1 Memory Usage: 18,272kB
24. 60.374 60.374 ↓ 1.2 150,500 2 / 2

Parallel Seq Scan on pret_gages (cost=0.00..4,781.60 rows=126,060 width=13) (actual time=0.039..60.374 rows=150,500 loops=2)

25. 341.580 341.580 ↑ 1.0 1 227,720 / 2

Index Scan using idx_pret_roles_dossier_gen_id on pret_roles (cost=0.42..0.53 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=227,720)

  • Index Cond: (dossier_gen_id = dossier_gen.dossier_gen_id)
  • Filter: ((flag_principal)::integer = 1)
  • Rows Removed by Filter: 2
26. 335.502 335.502 ↑ 1.0 1 223,668 / 2

Index Scan using idx4fk_f_pre_gag_est on pret_estimation (cost=0.42..0.46 rows=1 width=23) (actual time=0.002..0.003 rows=1 loops=223,668)

  • Index Cond: (pret_gages_id = pret_gages.pret_gages_id)
27. 111.834 111.834 ↑ 1.0 1 223,668 / 2

Index Scan using p_key_gage_niv2 on type_gage_niv2 (cost=0.14..0.16 rows=1 width=122) (actual time=0.001..0.001 rows=1 loops=223,668)

  • Index Cond: (type_gage_niv2_id = pret_gages.gage_niv2_id)
28. 335.502 335.502 ↑ 1.0 1 223,668 / 2

Index Scan using p_key_partenaire on part a1_hyp_part_pret (cost=0.29..0.57 rows=1 width=36) (actual time=0.003..0.003 rows=1 loops=223,668)

  • Index Cond: (part_id = pret_roles.part_id)
29. 2,019.390 2,460.348 ↑ 1.0 1 223,668

Index Scan using a_pret_gages_immobiliers_pret_gages_id on pret_gages_immobiliers (cost=0.42..1.50 rows=1 width=150) (actual time=0.011..0.011 rows=1 loops=223,668)

  • Index Cond: (pret_gages_id = pret_gages.pret_gages_id)
30.          

SubPlan (for Index Scan)

31. 440.958 440.958 ↓ 0.0 0 220,479

Seq Scan on cate_rating a_1 (cost=0.00..1.05 rows=1 width=118) (actual time=0.002..0.002 rows=0 loops=220,479)

  • Filter: (cate_rating_id = pret_gages_immobiliers.dn_cate_rating_dp_id)
  • Rows Removed by Filter: 4
32. 894.672 894.672 ↑ 1.0 1 223,668

Index Scan using idx4fk_f_dos_gen_pret_gen on pret_gen (cost=0.42..0.46 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=223,668)

  • Index Cond: (dossier_gen_id = dossier_gen.dossier_gen_id)
33. 1,864.568 1,864.568 ↑ 2.0 2 233,071

Index Scan using idx4fk_f_pre_gen_tra_gen on tranches_gen (cost=0.42..0.57 rows=4 width=56) (actual time=0.004..0.008 rows=2 loops=233,071)

  • Index Cond: (pret_gen_id = pret_gen.pret_gen_id)
34. 404,045.010 413,998.256 ↓ 1,679.8 18,478 528,059

Materialize (cost=655.56..4,054.88 rows=11 width=32) (actual time=0.000..0.784 rows=18,478 loops=528,059)

35. 5.796 9,953.246 ↓ 1,679.8 18,478 1

Hash Join (cost=655.56..4,054.83 rows=11 width=32) (actual time=84.149..9,953.246 rows=18,478 loops=1)

  • Hash Cond: ((tranches_1.dn_tranches_dp_id = tranches.tranches_id) AND ((SubPlan 3) = tranches.prod_id))
36. 58.212 9,873.047 ↓ 330.0 18,478 1

Hash Right Join (cost=651.18..4,043.16 rows=56 width=36) (actual time=83.593..9,873.047 rows=18,478 loops=1)

  • Hash Cond: (plan_finan_chan.tranches_id = tranches_1.tranches_id)
  • Filter: ((ecritures.ecritures_id = (SubPlan 5)) OR (ecritures.ecritures_id IS NULL))
  • Rows Removed by Filter: 40,299
37. 13.885 44.963 ↓ 1.0 40,623 1

Hash Right Join (cost=15.49..3,055.39 rows=40,597 width=21) (actual time=0.570..44.963 rows=40,623 loops=1)

  • Hash Cond: (ecritures.plan_finan_chan_id = plan_finan_chan.plan_finan_chan_id)
38. 30.550 30.550 ↓ 1.0 40,623 1

Seq Scan on ecritures (cost=0.00..2,931.97 rows=40,597 width=21) (actual time=0.009..30.550 rows=40,623 loops=1)

39. 0.055 0.528 ↓ 1.0 334 1

Hash (cost=11.33..11.33 rows=333 width=8) (actual time=0.528..0.528 rows=334 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
40. 0.473 0.473 ↓ 1.0 334 1

Seq Scan on plan_finan_chan (cost=0.00..11.33 rows=333 width=8) (actual time=0.010..0.473 rows=334 loops=1)

41. 4.352 12.890 ↑ 1.0 18,488 1

Hash (cost=403.64..403.64 rows=18,564 width=23) (actual time=12.890..12.890 rows=18,488 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,268kB
42. 8.538 8.538 ↑ 1.0 18,488 1

Seq Scan on tranches tranches_1 (cost=0.00..403.64 rows=18,564 width=23) (actual time=0.011..8.538 rows=18,488 loops=1)

43.          

SubPlan (for Hash Right Join)

44. 0.000 9,756.982 ↑ 1.0 1 58,777

Aggregate (cost=122.73..122.74 rows=1 width=4) (actual time=0.166..0.166 rows=1 loops=58,777)

45.          

Initplan (for Aggregate)

46. 649.968 6,255.942 ↑ 1.0 1 40,623

Aggregate (cost=61.94..61.95 rows=1 width=4) (actual time=0.154..0.154 rows=1 loops=40,623)

47. 893.706 5,605.974 ↓ 2.5 290 40,623

Nested Loop (cost=0.72..61.65 rows=117 width=4) (actual time=0.007..0.138 rows=290 loops=40,623)

48. 0.000 121.869 ↑ 1.0 1 40,623

Nested Loop (cost=0.43..4.88 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=40,623)

49. 40.623 40.623 ↑ 1.0 1 40,623

Index Scan using idx4fk_f_tra_pla_fin on plan_finan_chan p_1 (cost=0.15..2.37 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=40,623)

  • Index Cond: (tranches_id = tranches_1.tranches_id)
50. 81.246 81.246 ↑ 1.0 1 40,623

Index Only Scan using p_key_tranches on tranches t (cost=0.29..2.51 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=40,623)

  • Index Cond: (tranches_id = tranches_1.tranches_id)
  • Heap Fetches: 40,623
51. 4,590.399 4,590.399 ↓ 2.5 290 40,623

Index Scan using idx4fk_f_pla_fin_cha_ecr on ecritures a_2 (cost=0.29..55.59 rows=118 width=8) (actual time=0.004..0.113 rows=290 loops=40,623)

  • Index Cond: (plan_finan_chan_id = p_1.plan_finan_chan_id)
  • Filter: ((dte_valeur <= '2020-06-30'::date) AND ((statut)::text = 'VALI'::text))
  • Rows Removed by Filter: 10
52. 78.025 9,756.982 ↓ 2.0 2 58,777

Nested Loop (cost=0.72..60.78 rows=1 width=4) (actual time=0.120..0.166 rows=2 loops=58,777)

53. 16.092 9,580.651 ↓ 2.0 2 58,777

Nested Loop (cost=0.44..58.27 rows=1 width=8) (actual time=0.118..0.163 rows=2 loops=58,777)

54. 58.777 58.777 ↑ 1.0 1 58,777

Index Scan using idx4fk_f_tra_pla_fin on plan_finan_chan c (cost=0.15..2.37 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=58,777)

  • Index Cond: (tranches_id = tranches_1.tranches_id)
55. 9,505.782 9,505.782 ↓ 2.0 2 40,623

Index Scan using idx4fk_f_pla_fin_cha_ecr on ecritures b (cost=0.29..55.89 rows=1 width=8) (actual time=0.169..0.234 rows=2 loops=40,623)

  • Index Cond: (plan_finan_chan_id = c.plan_finan_chan_id)
  • Filter: ((dte_valeur <= '2020-06-30'::date) AND (dte_valeur = $5) AND ((statut)::text = 'VALI'::text))
  • Rows Removed by Filter: 297
56. 98.306 98.306 ↑ 1.0 1 98,306

Index Only Scan using p_key_tranches on tranches d (cost=0.29..2.51 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=98,306)

  • Index Cond: (tranches_id = tranches_1.tranches_id)
  • Heap Fetches: 98,306
57. 0.034 0.491 ↑ 1.0 95 1

Hash (cost=2.95..2.95 rows=95 width=12) (actual time=0.491..0.491 rows=95 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
58. 0.457 0.457 ↑ 1.0 95 1

Seq Scan on tranches (cost=0.00..2.95 rows=95 width=12) (actual time=0.425..0.457 rows=95 loops=1)

59.          

SubPlan (for Hash Join)

60. 73.912 73.912 ↑ 1.0 1 36,956

Index Scan using p_key_pret on pret p (cost=0.28..2.50 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=36,956)

  • Index Cond: (tranches_1.pret_id = pret_id)
61. 4,224.168 4,224.168 ↑ 32.0 3 528,021

Index Scan using idx4fk_f_tra_gen_lie_eng on lien_tra_engag_gro_part (cost=0.43..2.17 rows=96 width=8) (actual time=0.003..0.008 rows=3 loops=528,021)

  • Index Cond: (tranches_gen_id = tranches_gen.tranches_gen_id)
62. 1,661.264 1,661.264 ↑ 1.0 1 1,661,264

Index Scan using p_key_pret on pret (cost=0.28..0.30 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,661,264)

  • Index Cond: (pret_id = pret_gen.pret_id)
63. 0.042 0.833 ↑ 1.0 146 1

Hash (cost=8.56..8.56 rows=146 width=116) (actual time=0.833..0.833 rows=146 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
64. 0.054 0.791 ↑ 1.0 146 1

Hash Join (cost=3.06..8.56 rows=146 width=116) (actual time=0.694..0.791 rows=146 loops=1)

  • Hash Cond: (fam_prod.soc_id = soc.soc_id)
65. 0.063 0.135 ↑ 1.0 146 1

Hash Join (cost=1.90..6.79 rows=146 width=38) (actual time=0.066..0.135 rows=146 loops=1)

  • Hash Cond: (prod.fam_id = fam_prod.fam_id)
66. 0.040 0.040 ↑ 1.0 146 1

Seq Scan on prod (cost=0.00..4.46 rows=146 width=29) (actual time=0.010..0.040 rows=146 loops=1)

67. 0.019 0.032 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=17) (actual time=0.032..0.032 rows=40 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
68. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on fam_prod (cost=0.00..1.40 rows=40 width=17) (actual time=0.008..0.013 rows=40 loops=1)

69. 0.013 0.602 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=82) (actual time=0.602..0.602 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
70. 0.589 0.589 ↑ 1.0 7 1

Seq Scan on soc (cost=0.00..1.07 rows=7 width=82) (actual time=0.588..0.589 rows=7 loops=1)

71. 4,983.792 4,983.792 ↓ 0.0 0 1,661,264

Index Scan using p_key_eng_gro_par on engage_lien_groupe_part (cost=0.42..0.45 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=1,661,264)

  • Index Cond: (engage_lien_groupe_part_id = lien_tra_engag_gro_part.engage_lien_groupe_part_id)
  • Filter: ((groupe_part_id = 27) AND (dte = '2020-06-30'::date))
  • Rows Removed by Filter: 1
72. 0.000 0.000 ↓ 0.0 0

Index Scan using p_key_partenaire on part (cost=0.29..2.51 rows=1 width=22) (never executed)

  • Index Cond: (part_id = engage_lien_groupe_part.part_id)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using p_key_mut_dos on mut_dossier (cost=0.42..0.49 rows=1 width=8) (never executed)

  • Index Cond: (mut_dossier_id = dossier_gen.mut_dossier_id)
74. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=512.75..734.32 rows=8,915 width=40) (never executed)

  • Hash Cond: (dossier.dossier_id = lien_rev_cha_dossier.dossier_id)
75. 0.000 0.000 ↓ 0.0 0

Seq Scan on dossier (cost=0.00..198.15 rows=8,915 width=8) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Hash (cost=512.74..512.74 rows=1 width=36) (never executed)

77. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=512.71..512.73 rows=1 width=36) (never executed)

  • Group Key: lien_rev_cha_dossier.dossier_id
78. 0.000 0.000 ↓ 0.0 0

Sort (cost=512.71..512.71 rows=1 width=11) (never executed)

  • Sort Key: lien_rev_cha_dossier.dossier_id
79. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..512.70 rows=1 width=11) (never executed)

  • Join Filter: (re_ch.revenus_charges_id = re_ch_histo.revenus_charges_id)
80. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..375.34 rows=48 width=12) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Seq Scan on revenus_charges re_ch (cost=0.00..281.77 rows=53 width=4) (never executed)

  • Filter: ((flag_revenu_proven_gage)::integer = 1)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_lien_rev_cha_dossier_revenus_charges_id on lien_rev_cha_dossier (cost=0.29..1.76 rows=1 width=8) (never executed)

  • Index Cond: (revenus_charges_id = re_ch.revenus_charges_id)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_revenus_charges_historique_revenus_charges_id on revenus_charges_historique re_ch_histo (cost=0.29..2.85 rows=1 width=11) (never executed)

  • Index Cond: (revenus_charges_id = lien_rev_cha_dossier.revenus_charges_id)
  • Filter: ((date_fin_validite = '2999-12-31'::date) AND (revenus_charges_historique_id = (SubPlan 6)))
84.          

SubPlan (for Index Scan)

85. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2.51..2.52 rows=1 width=4) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_revenus_charges_historique_revenus_charges_id on revenus_charges_historique a_3 (cost=0.29..2.51 rows=1 width=4) (never executed)

  • Index Cond: (revenus_charges_id = re_ch_histo.revenus_charges_id)
  • Filter: (date_debut_validite <= '2020-06-30'::date)
87.          

SubPlan (for Nested Loop)

88. 0.000 0.000 ↓ 0.0 0

Index Scan using bi_code_pkey on bi_code a (cost=0.28..2.50 rows=1 width=16) (never executed)

  • Index Cond: (((code_type)::text = 'TypeAtlasTauxInterets'::text) AND ((tranches_gen.type_tx_int)::text = (code_cle)::text))
  • Filter: ((cde_lan)::text = 'FR'::text)
Planning time : 233.643 ms
Execution time : 1,133,618.229 ms