explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZiVG

Settings
# exclusive inclusive rows x rows loops node
1. 0.589 10,089.770 ↑ 1.0 1 1

Aggregate (cost=552,161.5..552,161.51 rows=1 width=8) (actual time=10,089.77..10,089.77 rows=1 loops=1)

  • Buffers: shared hit=291,446
2. 6.203 10,089.181 ↑ 1.3 12,881 1

Sort (cost=551,919.34..551,959.7 rows=16,144 width=7,579) (actual time=10,088.488..10,089.181 rows=12,881 loops=1)

  • Sort Key: sous.sousou_date_creation DESC
  • Sort Method: quicksort Memory: 4,235kB
  • Buffers: shared hit=291,446
3.          

CTE liencodepere

4. 0.768 92.241 ↓ 95.9 6,140 1

Result (cost=0.29..147,769.38 rows=64 width=14) (actual time=0.126..92.241 rows=6,140 loops=1)

  • Buffers: shared hit=65,243
5. 1.239 91.473 ↓ 95.9 6,140 1

Unique (cost=0.29..147,769.38 rows=64 width=14) (actual time=0.123..91.473 rows=6,140 loops=1)

  • Buffers: shared hit=65,243
6. 13.686 90.234 ↓ 95.9 6,140 1

Index Only Scan using idx_crmhav_triplet on crmhav_crm_hierarchie_apporteur_materialized_view liensuperieur (cost=0.29..147,769.06 rows=64 width=14) (actual time=0.122..90.234 rows=6,140 loops=1)

  • Filter: (liensuperieur.distance = (SubPlan 1))
  • Heap Fetches: 12,758
  • Buffers: shared hit=65,243
7.          

SubPlan (for Index Only Scan)

8. 12.758 76.548 ↑ 1.0 1 12,758

GroupAggregate (cost=4.3..11.51 rows=1 width=11) (actual time=0.006..0.006 rows=1 loops=12,758)

  • Group Key: hierachieapp.codeapporteur
  • Buffers: shared hit=52,520
9. 25.516 63.790 ↑ 1.0 1 12,758

Bitmap Heap Scan on crmhav_crm_hierarchie_apporteur_materialized_view hierachieapp (cost=4.3..11.5 rows=1 width=11) (actual time=0.004..0.005 rows=1 loops=12,758)

  • Filter: ((hierachieapp.codesuperieur)::text <> ALL ('{AXV07011,AXV01144,AXV09077,AXV09088,AXV09140}'::text[]))
  • Heap Blocks: exact=26,934
  • Buffers: shared hit=52,520
10. 38.274 38.274 ↑ 1.0 2 12,758

Bitmap Index Scan on idx_crmhav_triplet (cost=0..4.3 rows=2 width=0) (actual time=0.003..0.003 rows=2 loops=12,758)

  • Index Cond: ((hierachieapp.codeapporteur)::text = (liensuperieur.codeapporteur)::text)
  • Buffers: shared hit=25,586
11.          

CTE operationissub2b2c

12. 1.113 29.463 ↓ 5.0 7,763 1

Nested Loop (cost=37.95..12,187.88 rows=1,559 width=24) (actual time=0.683..29.463 rows=7,763 loops=1)

  • Buffers: shared hit=32,220
13. 4.247 4.797 ↓ 4.7 7,851 1

Bitmap Heap Scan on crmodc_crm_operation_donnees_complementaires crmdonnees (cost=37.53..1,988.65 rows=1,669 width=9) (actual time=0.648..4.797 rows=7,851 loops=1)

  • Filter: (crmdonnees.crmodc_issu_fonctionnalite_en_ligne IS TRUE)
  • Heap Blocks: exact=783
  • Buffers: shared hit=816
14. 0.550 0.550 ↓ 4.7 7,851 1

Bitmap Index Scan on idx_crmodc_fonctionnalite_en_ligne_numero_proposition (cost=0..37.11 rows=1,669 width=0) (actual time=0.55..0.55 rows=7,851 loops=1)

  • Index Cond: ((crmdonnees.crmodc_issu_fonctionnalite_en_ligne = true) AND (crmdonnees.crmodc_fonctionnalite_en_ligne_numero_proposition IS NOT NULL))
  • Buffers: shared hit=33
15. 23.553 23.553 ↑ 1.0 1 7,851

Index Scan using ifk_crmopt_donnees_complementaires on crmopt_crm_operation crmoperation (cost=0.42..6.1 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=7,851)

  • Index Cond: (crmoperation.crmopt_donnees_complementaires = crmdonnees.crmodc_id)
  • Filter: ((crmoperation.crmopt_statut)::text <> ALL ('{OPERATION_ANNULEE,SANS_SUITE}'::text[]))
  • Buffers: shared hit=31,404
16. 5.465 10,082.978 ↑ 1.3 12,881 1

Unique (cost=337,143.92..338,354.72 rows=16,144 width=7,579) (actual time=10,076.781..10,082.978 rows=12,881 loops=1)

  • Buffers: shared hit=291,446
17. 41.716 10,077.513 ↑ 1.3 12,881 1

Sort (cost=337,143.92..337,184.28 rows=16,144 width=7,579) (actual time=10,076.769..10,077.513 rows=12,881 loops=1)

  • Sort Key: sous.sousou_numero_projet_contrat, ('AFFAIRE_NOUVELLE'::text), (NULL::character varying), sous.propro_code_produit, ((SubPlan 4)), ((SubPlan 5)), pvcassure.pervic_code, (COALESCE(perassure.perper_denomination_sociale, perassure.perper_autre_nom, ((((perassure.perper_nom)::text || ' '::text) || (perassure.perper_prenom)::text))::character varying)), (COALESCE(perassure.perper_denomination_sociale, perassure.perper_autre_nom, perassure.perper_nom)), (COALESCE(perassure.perper_prenom)), pvccoassure.pervic_code, (COALESCE(percoassure.perper_denomination_sociale, percoassure.perper_autre_nom, ((((percoassure.perper_nom)::text || ' '::text) || (percoassure.perper_prenom)::text))::character varying)), (COALESCE(percoassure.perper_denomination_sociale, percoassure.perper_autre_nom, percoassure.perper_nom)), (COALESCE(percoassure.perper_prenom)), sous.sousou_date_creation, sous.sousou_date_validation_saisie, pvcapp.pervic_code_apporteur, pvcpere.pervic_code_apporteur, pvcapp.pervic_code_reseau, vi.verini_montant_brut, (COALESCE(vi.verini_montant_brut, '0'::numeric)), (CASE WHEN (NOT sous.sousou_est_sauvegarde) THEN true ELSE false END), signsous.sgesao_etat, (CASE WHEN ((signsous.sgesao_etat)::text = 'FINALISE'::text) THEN true ELSE false END), (CASE WHEN ((signsous.sgesao_etat)::text = 'FINALISE'::text) THEN 'OUI'::text ELSE 'NON'::text END), (CASE WHEN ((NOT sous.sousou_est_sauvegarde) AND ((signsous.sgesao_etat IS NULL) OR ((signsous.sgesao_etat)::text <> ALL ('{A_SIGNER,FINALISE,VALIDATION_MANUELLE_PIECE}'::text[]))) AND (crmop.crmopt_numero_chrono IS NULL)) THEN true ELSE false END), crmop.crmopt_numero_chrono, crmop.crmopt_etat, crmop.crmopt_statut
  • Sort Method: quicksort Memory: 4,235kB
  • Buffers: shared hit=291,446
18. 1.441 10,035.797 ↑ 1.3 12,881 1

Append (cost=12,799.4..283,536.56 rows=16,144 width=7,579) (actual time=9,376.436..10,035.797 rows=12,881 loops=1)

  • Buffers: shared hit=291,446
19. 8.983 9,426.828 ↓ 1.0 4,823 1

Nested Loop (cost=12,799.4..95,163.69 rows=4,740 width=3,529) (actual time=9,376.426..9,426.828 rows=4,823 loops=1)

  • Buffers: shared hit=158,473
20. 1.072 9,379.261 ↓ 1.0 4,823 1

Hash Join (cost=12,798.98..13,863.04 rows=4,740 width=1,270) (actual time=9,376.31..9,379.261 rows=4,823 loops=1)

  • Buffers: shared hit=110,467
21. 0.071 2.006 ↑ 1.0 110 1

Nested Loop (cost=0.83..1,063.4 rows=110 width=72) (actual time=0.09..2.006 rows=110 loops=1)

  • Buffers: shared hit=934
22. 0.063 1.495 ↑ 1.0 110 1

Nested Loop (cost=0.42..1,005.84 rows=110 width=34) (actual time=0.059..1.495 rows=110 loops=1)

  • Buffers: shared hit=494
23. 0.662 0.662 ↑ 1.0 110 1

Seq Scan on intint_intervenant coassure (cost=0..117.99 rows=110 width=35) (actual time=0.025..0.662 rows=110 loops=1)

  • Filter: ((coassure.intint_role)::text = 'COSOUSCRIPTEUR'::text)
  • Buffers: shared hit=54
24. 0.770 0.770 ↑ 1.0 1 110

Index Scan using pervic_code_uk on pervic_personne_vision_courtier pvccoassure (cost=0.42..8.07 rows=1 width=30) (actual time=0.007..0.007 rows=1 loops=110)

  • Index Cond: ((pvccoassure.pervic_code)::text = (coassure.intint_code_vision_courtier)::text)
  • Buffers: shared hit=440
25. 0.440 0.440 ↑ 1.0 1 110

Index Scan using perper_id_pkey on perper_personne percoassure (cost=0.42..0.52 rows=1 width=46) (actual time=0.004..0.004 rows=1 loops=110)

  • Index Cond: (percoassure.perper_id = pvccoassure.pervic_personne_id)
  • Buffers: shared hit=440
26. 1.783 9,376.183 ↓ 1.0 4,823 1

Hash (cost=12,738.9..12,738.9 rows=4,740 width=1,206) (actual time=9,376.183..9,376.183 rows=4,823 loops=1)

  • Buffers: shared hit=109,533
27. 2.576 9,374.400 ↓ 1.0 4,823 1

Hash Join (cost=12,686.55..12,738.9 rows=4,740 width=1,206) (actual time=9,339.788..9,374.4 rows=4,823 loops=1)

  • Buffers: shared hit=109,533
28. 32.835 32.835 ↓ 5.0 7,763 1

CTE Scan on operationissub2b2c crmop (cost=0..31.18 rows=1,559 width=1,138) (actual time=0.693..32.835 rows=7,763 loops=1)

  • Buffers: shared hit=32,220
29. 1.828 9,338.989 ↓ 1.0 4,823 1

Hash (cost=12,627.3..12,627.3 rows=4,740 width=126) (actual time=9,338.988..9,338.989 rows=4,823 loops=1)

  • Buffers: shared hit=77,313
30. 2.285 9,337.161 ↓ 1.0 4,823 1

Hash Join (cost=11,521.71..12,627.3 rows=4,740 width=126) (actual time=9,320.35..9,337.161 rows=4,823 loops=1)

  • Buffers: shared hit=77,313
31. 1.397 9,282.220 ↓ 1.0 4,823 1

Hash Join (cost=6,238.69..7,331.83 rows=4,740 width=127) (actual time=9,267.007..9,282.22 rows=4,823 loops=1)

  • Buffers: shared hit=74,500
32. 1.181 9,245.285 ↓ 1.0 4,823 1

Hash Join (cost=955.66..1,888.83 rows=4,740 width=637) (actual time=9,231.209..9,245.285 rows=4,823 loops=1)

  • Buffers: shared hit=71,687
33. 1.218 9,243.073 ↓ 1.0 4,823 1

Hash Join (cost=801.6..1,722.31 rows=4,740 width=627) (actual time=9,230.159..9,243.073 rows=4,823 loops=1)

  • Buffers: shared hit=71,592
34. 2.499 9,240.786 ↓ 1.0 4,823 1

Merge Join (cost=662.08..1,570.34 rows=4,740 width=626) (actual time=9,229.064..9,240.786 rows=4,823 loops=1)

  • Buffers: shared hit=71,561
35. 2.653 9,141.692 ↓ 1.0 4,823 1

Merge Join (cost=658.88..1,554.94 rows=4,740 width=110) (actual time=9,133.053..9,141.692 rows=4,823 loops=1)

  • Buffers: shared hit=6,318
36. 9,130.236 9,130.236 ↑ 17.6 6,146 1

Index Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcapp (cost=0.42..14,058.48 rows=107,891 width=21) (actual time=9,124.614..9,130.236 rows=6,146 loops=1)

  • Filter: (NOT pvcapp.pervic_doublon)
  • Buffers: shared hit=6,148
37. 4.900 8.803 ↑ 1.0 4,823 1

Sort (cost=650.09..662.15 rows=4,823 width=96) (actual time=8.249..8.803 rows=4,823 loops=1)

  • Sort Key: sous.prdpro_apporteur
  • Sort Method: quicksort Memory: 871kB
  • Buffers: shared hit=170
38. 1.039 3.903 ↑ 1.0 4,823 1

Hash Join (cost=224.52..355.03 rows=4,823 width=96) (actual time=2.17..3.903 rows=4,823 loops=1)

  • Buffers: shared hit=170
39. 0.746 0.746 ↑ 1.0 4,767 1

Seq Scan on intint_intervenant assure (cost=0..117.99 rows=4,767 width=35) (actual time=0.017..0.746 rows=4,767 loops=1)

  • Filter: ((assure.intint_role)::text = 'SOUSCRIPTEUR'::text)
  • Buffers: shared hit=54
40. 0.930 2.118 ↑ 1.0 4,823 1

Hash (cost=164.23..164.23 rows=4,823 width=65) (actual time=2.117..2.118 rows=4,823 loops=1)

  • Buffers: shared hit=116
41. 1.188 1.188 ↑ 1.0 4,823 1

Seq Scan on sousou_souscription sous (cost=0..164.23 rows=4,823 width=65) (actual time=0.027..1.188 rows=4,823 loops=1)

  • Buffers: shared hit=116
42. 2.174 96.595 ↓ 162.1 10,377 1

Sort (cost=3.2..3.36 rows=64 width=1,032) (actual time=95.981..96.595 rows=10,377 loops=1)

  • Sort Key: liencodepere.codeapporteur
  • Sort Method: quicksort Memory: 483kB
  • Buffers: shared hit=65,243
43. 94.421 94.421 ↓ 95.9 6,140 1

CTE Scan on liencodepere liencodepere (cost=0..1.28 rows=64 width=1,032) (actual time=0.138..94.421 rows=6,140 loops=1)

  • Buffers: shared hit=65,243
44. 0.585 1.069 ↑ 1.0 4,823 1

Hash (cost=79.23..79.23 rows=4,823 width=9) (actual time=1.069..1.069 rows=4,823 loops=1)

  • Buffers: shared hit=31
45. 0.484 0.484 ↑ 1.0 4,823 1

Seq Scan on verini_versement_initial vi (cost=0..79.23 rows=4,823 width=9) (actual time=0.018..0.484 rows=4,823 loops=1)

  • Buffers: shared hit=31
46. 0.451 1.031 ↑ 1.0 2,625 1

Hash (cost=121.25..121.25 rows=2,625 width=21) (actual time=1.03..1.031 rows=2,625 loops=1)

  • Buffers: shared hit=95
47. 0.580 0.580 ↑ 1.0 2,625 1

Seq Scan on sgesao_signature_electronique_souscription signsous (cost=0..121.25 rows=2,625 width=21) (actual time=0.014..0.58 rows=2,625 loops=1)

  • Buffers: shared hit=95
48. 5.599 35.538 ↑ 17.9 6,148 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=7) (actual time=35.538..35.538 rows=6,148 loops=1)

  • Buffers: shared hit=2,813
49. 29.939 29.939 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcpere (cost=0..3,910.79 rows=109,779 width=7) (actual time=0.012..29.939 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
50. 19.315 52.656 ↑ 1.0 109,779 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=30) (actual time=52.656..52.656 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
51. 33.341 33.341 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcassure (cost=0..3,910.79 rows=109,779 width=30) (actual time=0.016..33.341 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
52. 9.646 9.646 ↑ 1.0 1 4,823

Index Scan using perper_id_pkey on perper_personne perassure (cost=0.42..0.52 rows=1 width=46) (actual time=0.002..0.002 rows=1 loops=4,823)

  • Index Cond: (perassure.perper_id = pvcassure.pervic_personne_id)
  • Buffers: shared hit=19,068
53.          

SubPlan (for Nested Loop)

54. 4.823 14.469 ↑ 1.0 1 4,823

Aggregate (cost=8.29..8.3 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=4,823)

  • Buffers: shared hit=14,469
55. 9.646 9.646 ↑ 1.0 1 4,823

Index Scan using prdpro_pk on prdpro_produit prd (cost=0.27..8.29 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=4,823)

  • Index Cond: (((prd.prdpro_code_produit)::text = (sous.propro_code_produit)::text) AND ((prd.prdpro_version_cg)::text = (sous.prdpro_version_cg)::text))
  • Buffers: shared hit=14,469
56. 4.823 14.469 ↑ 1.0 1 4,823

Aggregate (cost=8.29..8.3 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=4,823)

  • Buffers: shared hit=14,469
57. 9.646 9.646 ↑ 1.0 1 4,823

Index Scan using prdpro_pk on prdpro_produit prd_1 (cost=0.27..8.29 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=4,823)

  • Index Cond: (((prd_1.prdpro_code_produit)::text = (sous.propro_code_produit)::text) AND ((prd_1.prdpro_version_cg)::text = (sous.prdpro_version_cg)::text))
  • Buffers: shared hit=14,469
58. 0.805 246.078 ↓ 1.0 5,369 1

Subquery Scan on *SELECT* 2 (cost=20,510.76..132,649.8 rows=5,277 width=3,516) (actual time=197.676..246.078 rows=5,369 loops=1)

  • Buffers: shared hit=74,793
59. 6.336 245.273 ↓ 1.0 5,369 1

Nested Loop (cost=20,510.76..132,597.03 rows=5,277 width=3,493) (actual time=197.669..245.273 rows=5,369 loops=1)

  • Buffers: shared hit=74,793
60. 2.510 201.354 ↓ 1.0 5,369 1

Hash Join (cost=20,510.34..20,562.69 rows=5,277 width=1,291) (actual time=197.549..201.354 rows=5,369 loops=1)

  • Buffers: shared hit=36,197
61. 1.327 1.327 ↓ 5.0 7,763 1

CTE Scan on operationissub2b2c crmop_1 (cost=0..31.18 rows=1,559 width=1,138) (actual time=0.002..1.327 rows=7,763 loops=1)

62. 3.154 197.517 ↓ 1.0 5,369 1

Hash (cost=20,444.38..20,444.38 rows=5,277 width=211) (actual time=197.517..197.517 rows=5,369 loops=1)

  • Buffers: shared hit=36,197
63. 1.761 194.363 ↓ 1.0 5,369 1

Hash Join (cost=16,549.99..20,444.38 rows=5,277 width=211) (actual time=159.278..194.363 rows=5,369 loops=1)

  • Buffers: shared hit=36,197
64. 5.008 136.177 ↓ 1.0 5,369 1

Nested Loop (cost=11,266.96..15,147.5 rows=5,277 width=207) (actual time=102.176..136.177 rows=5,369 loops=1)

  • Buffers: shared hit=33,384
65. 2.669 120.431 ↓ 1.0 5,369 1

Hash Join (cost=11,266.54..12,386.12 rows=5,277 width=169) (actual time=102.128..120.431 rows=5,369 loops=1)

  • Buffers: shared hit=11,908
66. 2.146 63.119 ↓ 1.0 5,369 1

Hash Join (cost=5,983.51..7,089.24 rows=5,277 width=165) (actual time=46.801..63.119 rows=5,369 loops=1)

  • Buffers: shared hit=9,095
67. 1.360 24.900 ↓ 1.0 5,369 1

Hash Join (cost=700.49..1,628.11 rows=5,277 width=675) (actual time=10.043..24.9 rows=5,369 loops=1)

  • Buffers: shared hit=6,282
68. 2.862 22.537 ↓ 1.0 5,369 1

Merge Join (cost=575.24..1,468.12 rows=5,277 width=667) (actual time=9.02..22.537 rows=5,369 loops=1)

  • Buffers: shared hit=6,191
69. 3.162 17.122 ↓ 1.0 5,369 1

Merge Join (cost=572.04..1,451.38 rows=5,277 width=158) (actual time=7.188..17.122 rows=5,369 loops=1)

  • Buffers: shared hit=6,191
70. 5.933 5.933 ↑ 17.9 6,011 1

Index Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcapp_1 (cost=0.42..14,058.48 rows=107,891 width=21) (actual time=0.019..5.933 rows=6,011 loops=1)

  • Filter: (NOT pvcapp_1.pervic_doublon)
  • Buffers: shared hit=6,014
71. 6.155 8.027 ↑ 1.0 5,370 1

Sort (cost=563.39..576.82 rows=5,370 width=137) (actual time=7.14..8.027 rows=5,370 loops=1)

  • Sort Key: op.b2b2cp_code_apporteur
  • Sort Method: quicksort Memory: 1,600kB
  • Buffers: shared hit=177
72. 1.872 1.872 ↑ 1.0 5,370 1

Seq Scan on b2b2cp_proposition_arbitrage op (cost=0..230.7 rows=5,370 width=137) (actual time=0.015..1.872 rows=5,370 loops=1)

  • Buffers: shared hit=177
73. 2.032 2.553 ↓ 170.0 10,880 1

Sort (cost=3.2..3.36 rows=64 width=1,032) (actual time=1.818..2.553 rows=10,880 loops=1)

  • Sort Key: liencodepere_1.codeapporteur
  • Sort Method: quicksort Memory: 483kB
74. 0.521 0.521 ↓ 95.9 6,140 1

CTE Scan on liencodepere liencodepere_1 (cost=0..1.28 rows=64 width=1,032) (actual time=0.002..0.521 rows=6,140 loops=1)

75. 0.296 1.003 ↑ 1.0 1,522 1

Hash (cost=106.22..106.22 rows=1,522 width=19) (actual time=1.003..1.003 rows=1,522 loops=1)

  • Buffers: shared hit=91
76. 0.707 0.707 ↑ 1.0 1,522 1

Seq Scan on seobbc_signature_electronique_op_b2b2c signop (cost=0..106.22 rows=1,522 width=19) (actual time=0.012..0.707 rows=1,522 loops=1)

  • Buffers: shared hit=91
77. 5.471 36.073 ↑ 17.9 6,148 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=7) (actual time=36.072..36.073 rows=6,148 loops=1)

  • Buffers: shared hit=2,813
78. 30.602 30.602 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcpere_1 (cost=0..3,910.79 rows=109,779 width=7) (actual time=0.013..30.602 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
79. 22.779 54.643 ↑ 1.0 109,779 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=30) (actual time=54.643..54.643 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
80. 31.864 31.864 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcassure_1 (cost=0..3,910.79 rows=109,779 width=30) (actual time=0.012..31.864 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
81. 10.738 10.738 ↑ 1.0 1 5,369

Index Scan using perper_id_pkey on perper_personne perassure_1 (cost=0.42..0.52 rows=1 width=46) (actual time=0.002..0.002 rows=1 loops=5,369)

  • Index Cond: (perassure_1.perper_id = pvcassure_1.pervic_personne_id)
  • Buffers: shared hit=21,476
82. 23.066 56.425 ↑ 1.0 109,779 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=30) (actual time=56.425..56.425 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
83. 33.359 33.359 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvccoassure_1 (cost=0..3,910.79 rows=109,779 width=30) (actual time=0.014..33.359 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
84. 0.000 0.000 ↓ 0.0 0 5,369

Index Scan using perper_id_pkey on perper_personne percoassure_1 (cost=0.42..0.52 rows=1 width=46) (actual time=0..0 rows=0 loops=5,369)

  • Index Cond: (percoassure_1.perper_id = pvccoassure_1.pervic_personne_id)
  • Buffers: shared hit=1,980
85.          

SubPlan (for Nested Loop)

86. 5.369 21.476 ↑ 1.0 1 5,369

Aggregate (cost=10.33..10.34 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=5,369)

  • Buffers: shared hit=18,308
87. 16.107 16.107 ↑ 1.0 2 5,369

Index Scan using ifk_b2b2cs_proposition_id on b2b2cs_supports_arbitrage b2b2cs_supports_arbitrage (cost=0.29..10.32 rows=2 width=7) (actual time=0.002..0.003 rows=2 loops=5,369)

  • Index Cond: (b2b2cs_supports_arbitrage.b2b2cs_proposition_id = op.b2b2cp_id)
  • Filter: ((b2b2cs_supports_arbitrage.b2b2cs_discriminant)::text = 'DESINVEST'::text)
  • Buffers: shared hit=18,308
88. 5.369 16.107 ↑ 1.0 1 5,369

Aggregate (cost=10.33..10.34 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=5,369)

  • Buffers: shared hit=18,308
89. 10.738 10.738 ↑ 1.0 2 5,369

Index Scan using ifk_b2b2cs_proposition_id on b2b2cs_supports_arbitrage b2b2cs_supports_arbitrage_1 (cost=0.29..10.32 rows=2 width=7) (actual time=0.001..0.002 rows=2 loops=5,369)

  • Index Cond: (b2b2cs_supports_arbitrage_1.b2b2cs_proposition_id = op.b2b2cp_id)
  • Filter: ((b2b2cs_supports_arbitrage_1.b2b2cs_discriminant)::text = 'DESINVEST'::text)
  • Buffers: shared hit=18,308
90. 0.117 177.094 ↑ 1.7 925 1

Subquery Scan on *SELECT* 3 (cost=17,888.42..17,992.47 rows=1,532 width=3,492) (actual time=175.098..177.094 rows=925 loops=1)

  • Buffers: shared hit=18,473
91. 1.307 176.977 ↑ 1.7 925 1

Hash Join (cost=17,888.42..17,977.15 rows=1,532 width=3,469) (actual time=175.091..176.977 rows=925 loops=1)

  • Buffers: shared hit=18,473
92. 0.787 0.787 ↓ 5.0 7,763 1

CTE Scan on operationissub2b2c crmop_2 (cost=0..31.18 rows=1,559 width=1,138) (actual time=0.003..0.787 rows=7,763 loops=1)

93. 0.576 174.883 ↓ 1.0 925 1

Hash (cost=17,877.06..17,877.06 rows=909 width=245) (actual time=174.883..174.883 rows=925 loops=1)

  • Buffers: shared hit=18,473
94. 0.531 174.307 ↓ 1.0 925 1

Nested Loop (cost=16,074.26..17,877.06 rows=909 width=245) (actual time=161.083..174.307 rows=925 loops=1)

  • Buffers: shared hit=18,473
95. 0.896 173.776 ↓ 1.0 925 1

Hash Join (cost=16,073.84..17,401.39 rows=909 width=207) (actual time=161.059..173.776 rows=925 loops=1)

  • Buffers: shared hit=18,281
96. 1.021 113.197 ↓ 1.0 925 1

Nested Loop (cost=10,790.81..12,115.98 rows=909 width=203) (actual time=100.667..113.197 rows=925 loops=1)

  • Buffers: shared hit=15,468
97. 1.093 109.401 ↓ 1.0 925 1

Hash Join (cost=10,790.4..11,640.31 rows=909 width=165) (actual time=100.627..109.401 rows=925 loops=1)

  • Buffers: shared hit=11,768
98. 0.974 50.572 ↓ 1.0 925 1

Hash Join (cost=5,507.37..6,354.9 rows=909 width=161) (actual time=42.179..50.572 rows=925 loops=1)

  • Buffers: shared hit=8,955
99. 0.327 12.055 ↓ 1.0 925 1

Hash Join (cost=224.34..1,041.19 rows=909 width=671) (actual time=3.95..12.055 rows=925 loops=1)

  • Buffers: shared hit=6,142
100. 1.626 10.456 ↓ 1.0 925 1

Merge Join (cost=222.26..1,035.69 rows=909 width=162) (actual time=2.66..10.456 rows=925 loops=1)

  • Buffers: shared hit=6,142
101. 6.056 6.056 ↑ 17.9 6,011 1

Index Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcapp_2 (cost=0.42..14,058.48 rows=107,891 width=21) (actual time=0.016..6.056 rows=6,011 loops=1)

  • Filter: (NOT pvcapp_2.pervic_doublon)
  • Buffers: shared hit=6,014
102. 1.148 2.774 ↑ 1.0 925 1

Sort (cost=213.61..215.92 rows=925 width=141) (actual time=2.621..2.774 rows=925 loops=1)

  • Sort Key: op_1.b2brcp_code_apporteur
  • Sort Method: quicksort Memory: 241kB
  • Buffers: shared hit=128
103. 0.698 1.626 ↑ 1.0 925 1

Hash Join (cost=57.81..168.04 rows=925 width=141) (actual time=0.576..1.626 rows=925 loops=1)

  • Buffers: shared hit=128
104. 0.381 0.381 ↑ 1.0 1,522 1

Seq Scan on seobbc_signature_electronique_op_b2b2c signop_1 (cost=0..106.22 rows=1,522 width=19) (actual time=0.009..0.381 rows=1,522 loops=1)

  • Buffers: shared hit=91
105. 0.253 0.547 ↑ 1.0 925 1

Hash (cost=46.25..46.25 rows=925 width=133) (actual time=0.547..0.547 rows=925 loops=1)

  • Buffers: shared hit=37
106. 0.294 0.294 ↑ 1.0 925 1

Seq Scan on b2brcp_proposition_rachat_partiel op_1 (cost=0..46.25 rows=925 width=133) (actual time=0.017..0.294 rows=925 loops=1)

  • Buffers: shared hit=37
107. 0.774 1.272 ↓ 95.9 6,140 1

Hash (cost=1.28..1.28 rows=64 width=1,032) (actual time=1.271..1.272 rows=6,140 loops=1)

108. 0.498 0.498 ↓ 95.9 6,140 1

CTE Scan on liencodepere liencodepere_2 (cost=0..1.28 rows=64 width=1,032) (actual time=0.002..0.498 rows=6,140 loops=1)

109. 6.015 37.543 ↑ 17.9 6,148 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=7) (actual time=37.543..37.543 rows=6,148 loops=1)

  • Buffers: shared hit=2,813
110. 31.528 31.528 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcpere_2 (cost=0..3,910.79 rows=109,779 width=7) (actual time=0.012..31.528 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
111. 23.683 57.736 ↑ 1.0 109,779 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=30) (actual time=57.735..57.736 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
112. 34.053 34.053 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcassure_2 (cost=0..3,910.79 rows=109,779 width=30) (actual time=0.013..34.053 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
113. 2.775 2.775 ↑ 1.0 1 925

Index Scan using perper_id_pkey on perper_personne perassure_2 (cost=0.42..0.52 rows=1 width=46) (actual time=0.003..0.003 rows=1 loops=925)

  • Index Cond: (perassure_2.perper_id = pvcassure_2.pervic_personne_id)
  • Buffers: shared hit=3,700
114. 23.196 59.683 ↑ 1.0 109,779 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=30) (actual time=59.683..59.683 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
115. 36.487 36.487 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvccoassure_2 (cost=0..3,910.79 rows=109,779 width=30) (actual time=0.017..36.487 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
116. 0.000 0.000 ↓ 0.0 0 925

Index Scan using perper_id_pkey on perper_personne percoassure_2 (cost=0.42..0.52 rows=1 width=46) (actual time=0..0 rows=0 loops=925)

  • Index Cond: (percoassure_2.perper_id = pvccoassure_2.pervic_personne_id)
  • Buffers: shared hit=192
117. 0.103 152.482 ↑ 1.5 1,031 1

Subquery Scan on *SELECT* 4 (cost=18,072.67..18,176.73 rows=1,532 width=3,493) (actual time=150.551..152.482 rows=1,031 loops=1)

  • Buffers: shared hit=18,778
118. 1.255 152.379 ↑ 1.5 1,031 1

Hash Join (cost=18,072.67..18,161.41 rows=1,532 width=3,470) (actual time=150.546..152.379 rows=1,031 loops=1)

  • Buffers: shared hit=18,778
119. 0.760 0.760 ↓ 5.0 7,763 1

CTE Scan on operationissub2b2c crmop_3 (cost=0..31.18 rows=1,559 width=1,138) (actual time=0.004..0.76 rows=7,763 loops=1)

120. 0.645 150.364 ↓ 1.0 1,031 1

Hash (cost=18,060.01..18,060.01 rows=1,013 width=246) (actual time=150.364..150.364 rows=1,031 loops=1)

  • Buffers: shared hit=18,778
121. 0.549 149.719 ↓ 1.0 1,031 1

Nested Loop (cost=11,664.18..18,060.01 rows=1,013 width=246) (actual time=102.526..149.719 rows=1,031 loops=1)

  • Buffers: shared hit=18,778
122. 0.923 149.170 ↓ 1.0 1,031 1

Hash Join (cost=11,663.77..17,529.92 rows=1,013 width=208) (actual time=102.508..149.17 rows=1,031 loops=1)

  • Buffers: shared hit=18,646
123. 0.307 92.212 ↓ 1.0 1,031 1

Nested Loop (cost=6,380.74..12,244.24 rows=1,013 width=204) (actual time=45.784..92.212 rows=1,031 loops=1)

  • Buffers: shared hit=15,833
124. 1.074 87.781 ↓ 1.0 1,031 1

Hash Join (cost=6,380.32..11,714.15 rows=1,013 width=166) (actual time=45.753..87.781 rows=1,031 loops=1)

  • Buffers: shared hit=11,709
125. 0.384 51.021 ↓ 1.0 1,031 1

Hash Join (cost=1,097.29..6,396.93 rows=1,013 width=676) (actual time=9.351..51.021 rows=1,031 loops=1)

  • Buffers: shared hit=8,896
126. 0.316 49.229 ↓ 1.0 1,031 1

Hash Join (cost=1,095.21..6,391.04 rows=1,013 width=167) (actual time=7.927..49.229 rows=1,031 loops=1)

  • Buffers: shared hit=8,896
127. 20.519 48.598 ↓ 1.0 1,031 1

Hash Join (cost=1,052.02..6,345.17 rows=1,013 width=166) (actual time=7.594..48.598 rows=1,031 loops=1)

  • Buffers: shared hit=8,876
128. 20.553 20.553 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcassure_3 (cost=0..3,910.79 rows=109,779 width=30) (actual time=0.011..20.553 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
129. 0.492 7.526 ↓ 1.0 1,031 1

Hash (cost=1,039.35..1,039.35 rows=1,013 width=162) (actual time=7.526..7.526 rows=1,031 loops=1)

  • Buffers: shared hit=6,063
130. 1.388 7.034 ↓ 1.0 1,031 1

Merge Join (cost=227.68..1,039.35 rows=1,013 width=162) (actual time=2.929..7.034 rows=1,031 loops=1)

  • Buffers: shared hit=6,063
131. 2.697 2.697 ↑ 18.2 5,931 1

Index Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcapp_3 (cost=0.42..14,058.48 rows=107,891 width=21) (actual time=0.018..2.697 rows=5,931 loops=1)

  • Filter: (NOT pvcapp_3.pervic_doublon)
  • Buffers: shared hit=5,938
132. 1.165 2.949 ↑ 1.0 1,031 1

Sort (cost=219.02..221.6 rows=1,031 width=141) (actual time=2.884..2.949 rows=1,031 loops=1)

  • Sort Key: op_2.b2bvlo_code_apporteur
  • Sort Method: quicksort Memory: 301kB
  • Buffers: shared hit=125
133. 0.740 1.784 ↑ 1.0 1,031 1

Hash Join (cost=57.2..167.42 rows=1,031 width=141) (actual time=0.684..1.784 rows=1,031 loops=1)

  • Buffers: shared hit=125
134. 0.393 0.393 ↑ 1.0 1,522 1

Seq Scan on seobbc_signature_electronique_op_b2b2c signop_2 (cost=0..106.22 rows=1,522 width=19) (actual time=0.009..0.393 rows=1,522 loops=1)

  • Buffers: shared hit=91
135. 0.387 0.651 ↑ 1.0 1,031 1

Hash (cost=44.31..44.31 rows=1,031 width=133) (actual time=0.651..0.651 rows=1,031 loops=1)

  • Buffers: shared hit=34
136. 0.264 0.264 ↑ 1.0 1,031 1

Seq Scan on b2bvlo_proposition_versement_libre op_2 (cost=0..44.31 rows=1,031 width=133) (actual time=0.016..0.264 rows=1,031 loops=1)

  • Buffers: shared hit=34
137. 0.169 0.315 ↑ 1.0 1,031 1

Hash (cost=30.31..30.31 rows=1,031 width=9) (actual time=0.315..0.315 rows=1,031 loops=1)

  • Buffers: shared hit=20
138. 0.146 0.146 ↑ 1.0 1,031 1

Seq Scan on b2bvlc_proposition_vl_caracteristiques opcaract (cost=0..30.31 rows=1,031 width=9) (actual time=0.012..0.146 rows=1,031 loops=1)

  • Buffers: shared hit=20
139. 0.852 1.408 ↓ 95.9 6,140 1

Hash (cost=1.28..1.28 rows=64 width=1,032) (actual time=1.408..1.408 rows=6,140 loops=1)

140. 0.556 0.556 ↓ 95.9 6,140 1

CTE Scan on liencodepere liencodepere_3 (cost=0..1.28 rows=64 width=1,032) (actual time=0.003..0.556 rows=6,140 loops=1)

141. 6.116 35.686 ↑ 17.9 6,148 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=7) (actual time=35.686..35.686 rows=6,148 loops=1)

  • Buffers: shared hit=2,813
142. 29.570 29.570 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvcpere_3 (cost=0..3,910.79 rows=109,779 width=7) (actual time=0.007..29.57 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
143. 4.124 4.124 ↑ 1.0 1 1,031

Index Scan using perper_id_pkey on perper_personne perassure_3 (cost=0.42..0.52 rows=1 width=46) (actual time=0.004..0.004 rows=1 loops=1,031)

  • Index Cond: (perassure_3.perper_id = pvcassure_3.pervic_personne_id)
  • Buffers: shared hit=4,124
144. 24.155 56.035 ↑ 1.0 109,779 1

Hash (cost=3,910.79..3,910.79 rows=109,779 width=30) (actual time=56.035..56.035 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
145. 31.880 31.880 ↑ 1.0 109,779 1

Seq Scan on pervic_personne_vision_courtier pvccoassure_3 (cost=0..3,910.79 rows=109,779 width=30) (actual time=0.009..31.88 rows=109,779 loops=1)

  • Buffers: shared hit=2,813
146. 0.000 0.000 ↓ 0.0 0 1,031

Index Scan using perper_id_pkey on perper_personne percoassure_3 (cost=0.42..0.52 rows=1 width=46) (actual time=0..0 rows=0 loops=1,031)

  • Index Cond: (percoassure_3.perper_id = pvccoassure_3.pervic_personne_id)
  • Buffers: shared hit=132
147. 0.056 16.087 ↑ 5.5 277 1

Subquery Scan on *SELECT* 5 (cost=242.19..7,798.59 rows=1,531 width=3,506) (actual time=5.326..16.087 rows=277 loops=1)

  • Buffers: shared hit=9,445
148. 0.257 16.031 ↑ 5.5 277 1

Hash Join (cost=242.19..7,783.28 rows=1,531 width=3,483) (actual time=5.32..16.031 rows=277 loops=1)

  • Buffers: shared hit=9,445
149. 0.173 13.960 ↓ 1.0 277 1

Nested Loop (cost=191.52..7,565.98 rows=272 width=276) (actual time=3.463..13.96 rows=277 loops=1)

  • Buffers: shared hit=9,445
150. 0.223 13.787 ↓ 1.0 277 1

Nested Loop (cost=191.11..7,423.65 rows=272 width=238) (actual time=3.446..13.787 rows=277 loops=1)

  • Buffers: shared hit=9,401
151. 0.188 13.564 ↓ 1.0 277 1

Nested Loop (cost=190.69..5,365 rows=272 width=234) (actual time=3.431..13.564 rows=277 loops=1)

  • Buffers: shared hit=9,357
152. 0.154 12.545 ↓ 1.0 277 1

Nested Loop (cost=190.27..5,222.66 rows=272 width=196) (actual time=3.388..12.545 rows=277 loops=1)

  • Buffers: shared hit=8,249
153. 0.050 10.729 ↓ 1.0 277 1

Nested Loop (cost=189.85..3,164.01 rows=272 width=192) (actual time=3.362..10.729 rows=277 loops=1)

  • Buffers: shared hit=7,141
154. 0.071 9.571 ↓ 1.0 277 1

Hash Join (cost=189.44..968.97 rows=272 width=702) (actual time=3.332..9.571 rows=277 loops=1)

  • Buffers: shared hit=6,033
155. 0.086 9.476 ↓ 1.0 277 1

Hash Join (cost=187.87..966.68 rows=272 width=701) (actual time=3.293..9.476 rows=277 loops=1)

  • Buffers: shared hit=6,032
156. 0.100 9.319 ↓ 1.0 277 1

Hash Join (cost=178.51..956.59 rows=272 width=700) (actual time=3.207..9.319 rows=277 loops=1)

  • Buffers: shared hit=6,027
157. 0.100 9.112 ↓ 1.0 277 1

Hash Join (cost=169.28..946.64 rows=272 width=669) (actual time=3.082..9.112 rows=277 loops=1)

  • Buffers: shared hit=6,024
158. 1.206 7.640 ↓ 1.0 277 1

Merge Join (cost=167.2..943.53 rows=272 width=160) (actual time=1.696..7.64 rows=277 loops=1)

  • Buffers: shared hit=6,024
159. 4.966 4.966 ↑ 18.2 5,916 1

Index Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcapp_4 (cost=0.42..14,058.48 rows=107,891 width=21) (actual time=0.021..4.966 rows=5,916 loops=1)

  • Filter: (NOT pvcapp_4.pervic_doublon)
  • Buffers: shared hit=5,923
160. 0.323 1.468 ↑ 1.0 277 1

Sort (cost=137.7..138.39 rows=277 width=139) (actual time=1.44..1.468 rows=277 loops=1)

  • Sort Key: op_3.b2bapo_code_apporteur
  • Sort Method: quicksort Memory: 89kB
  • Buffers: shared hit=101
161. 0.572 1.145 ↑ 1.0 277 1

Hash Join (cost=16.23..126.46 rows=277 width=139) (actual time=0.225..1.145 rows=277 loops=1)

  • Buffers: shared hit=101
162. 0.380 0.380 ↑ 1.0 1,522 1

Seq Scan on seobbc_signature_electronique_op_b2b2c signop_3 (cost=0..106.22 rows=1,522 width=19) (actual time=0.009..0.38 rows=1,522 loops=1)

  • Buffers: shared hit=91
163. 0.100 0.193 ↑ 1.0 277 1

Hash (cost=12.77..12.77 rows=277 width=131) (actual time=0.193..0.193 rows=277 loops=1)

  • Buffers: shared hit=10
164. 0.093 0.093 ↑ 1.0 277 1

Seq Scan on b2bapo_proposition_actes_programmes op_3 (cost=0..12.77 rows=277 width=131) (actual time=0.017..0.093 rows=277 loops=1)

  • Buffers: shared hit=10
165. 0.864 1.372 ↓ 95.9 6,140 1

Hash (cost=1.28..1.28 rows=64 width=1,032) (actual time=1.372..1.372 rows=6,140 loops=1)

166. 0.508 0.508 ↓ 95.9 6,140 1

CTE Scan on liencodepere liencodepere_4 (cost=0..1.28 rows=64 width=1,032) (actual time=0.001..0.508 rows=6,140 loops=1)

167. 0.063 0.107 ↑ 1.0 277 1

Hash (cost=5.77..5.77 rows=277 width=39) (actual time=0.107..0.107 rows=277 loops=1)

  • Buffers: shared hit=3
168. 0.044 0.044 ↑ 1.0 277 1

Seq Scan on b2bapc_proposition_ap_caracteristiques opcaract_1 (cost=0..5.77 rows=277 width=39) (actual time=0.016..0.044 rows=277 loops=1)

  • Buffers: shared hit=3
169. 0.035 0.071 ↑ 1.0 194 1

Hash (cost=6.94..6.94 rows=194 width=9) (actual time=0.071..0.071 rows=194 loops=1)

  • Buffers: shared hit=5
170. 0.036 0.036 ↑ 1.0 194 1

Seq Scan on b2bapv_caracteristiques_ap_vlp opcaractvlp (cost=0..6.94 rows=194 width=9) (actual time=0.012..0.036 rows=194 loops=1)

  • Buffers: shared hit=5
171. 0.011 0.024 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=9) (actual time=0.024..0.024 rows=25 loops=1)

  • Buffers: shared hit=1
172. 0.013 0.013 ↑ 1.0 25 1

Seq Scan on b2bapr_caracteristiques_ap_rpp opcaractrpp (cost=0..1.25 rows=25 width=9) (actual time=0.011..0.013 rows=25 loops=1)

  • Buffers: shared hit=1
173. 1.108 1.108 ↑ 1.0 1 277

Index Only Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcpere_4 (cost=0.42..8.06 rows=1 width=7) (actual time=0.003..0.004 rows=1 loops=277)

  • Index Cond: (pvcpere_4.pervic_code_apporteur = (liencodepere_4.codesuperieur)::text)
  • Heap Fetches: 277
  • Buffers: shared hit=1,108
174. 1.662 1.662 ↑ 1.0 1 277

Index Scan using pervic_code_uk on pervic_personne_vision_courtier pvcassure_4 (cost=0.42..7.57 rows=1 width=30) (actual time=0.006..0.006 rows=1 loops=277)

  • Index Cond: ((pvcassure_4.pervic_code)::text = (op_3.b2bapo_assure_code_vision)::text)
  • Buffers: shared hit=1,108
175. 0.831 0.831 ↑ 1.0 1 277

Index Scan using perper_id_pkey on perper_personne perassure_4 (cost=0.42..0.52 rows=1 width=46) (actual time=0.003..0.003 rows=1 loops=277)

  • Index Cond: (perassure_4.perper_id = pvcassure_4.pervic_personne_id)
  • Buffers: shared hit=1,108
176. 0.000 0.000 ↓ 0.0 0 277

Index Scan using pervic_code_uk on pervic_personne_vision_courtier pvccoassure_4 (cost=0.42..7.57 rows=1 width=30) (actual time=0..0 rows=0 loops=277)

  • Index Cond: ((pvccoassure_4.pervic_code)::text = (op_3.b2bapo_coassure_code_vision)::text)
  • Buffers: shared hit=44
177. 0.000 0.000 ↓ 0.0 0 277

Index Scan using perper_id_pkey on perper_personne percoassure_4 (cost=0.42..0.52 rows=1 width=46) (actual time=0..0 rows=0 loops=277)

  • Index Cond: (percoassure_4.perper_id = pvccoassure_4.pervic_personne_id)
  • Buffers: shared hit=44
178. 1.201 1.814 ↓ 5.0 7,763 1

Hash (cost=31.18..31.18 rows=1,559 width=1,138) (actual time=1.814..1.814 rows=7,763 loops=1)

179. 0.613 0.613 ↓ 5.0 7,763 1

CTE Scan on operationissub2b2c crmop_4 (cost=0..31.18 rows=1,559 width=1,138) (actual time=0.001..0.613 rows=7,763 loops=1)

180. 0.139 15.787 ↑ 3.4 456 1

Subquery Scan on *SELECT* 6 (cost=224.34..11,627.16 rows=1,532 width=4,006) (actual time=4.536..15.787 rows=456 loops=1)

  • Buffers: shared hit=11,484
181. 0.284 15.648 ↑ 3.4 456 1

Hash Join (cost=224.34..11,608.01 rows=1,532 width=3,955) (actual time=4.51..15.648 rows=456 loops=1)

  • Buffers: shared hit=11,484
182. 0.206 13.533 ↓ 1.0 456 1

Nested Loop (cost=173.68..11,417.16 rows=448 width=727) (actual time=2.651..13.533 rows=456 loops=1)

  • Buffers: shared hit=11,484
183. 0.215 13.327 ↓ 1.0 456 1

Nested Loop (cost=173.26..11,182.72 rows=448 width=689) (actual time=2.64..13.327 rows=456 loops=1)

  • Buffers: shared hit=11,484
184. 0.393 13.112 ↓ 1.0 456 1

Nested Loop (cost=172.84..7,994.49 rows=448 width=685) (actual time=2.626..13.112 rows=456 loops=1)

  • Buffers: shared hit=11,484
185. 0.020 11.351 ↓ 1.0 456 1

Nested Loop (cost=172.42..7,760.06 rows=448 width=647) (actual time=2.603..11.351 rows=456 loops=1)

  • Buffers: shared hit=9,660
186. 0.414 8.595 ↓ 1.0 456 1

Nested Loop (cost=172.01..4,578.51 rows=448 width=643) (actual time=2.578..8.595 rows=456 loops=1)

  • Buffers: shared hit=7,836
187. 0.149 6.813 ↓ 1.0 456 1

Hash Join (cost=171.59..963.15 rows=448 width=1,153) (actual time=2.558..6.813 rows=456 loops=1)

  • Buffers: shared hit=6,012
188. 1.345 5.415 ↓ 1.0 456 1

Merge Join (cost=169.51..959.38 rows=448 width=644) (actual time=1.291..5.415 rows=456 loops=1)

  • Buffers: shared hit=6,012
189. 2.849 2.849 ↑ 18.3 5,902 1

Index Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcapp_5 (cost=0.42..14,058.48 rows=107,891 width=21) (actual time=0.015..2.849 rows=5,902 loops=1)

  • Filter: (NOT pvcapp_5.pervic_doublon)
  • Buffers: shared hit=5,909
190. 0.524 1.221 ↑ 1.0 456 1

Sort (cost=152.63..153.77 rows=456 width=623) (actual time=1.182..1.221 rows=456 loops=1)

  • Sort Key: op_4.b2bmad_code_apporteur
  • Sort Method: quicksort Memory: 90kB
  • Buffers: shared hit=103
191. 0.284 0.697 ↑ 1.0 456 1

Hash Join (cost=22.26..132.49 rows=456 width=623) (actual time=0.292..0.697 rows=456 loops=1)

  • Buffers: shared hit=103
192. 0.158 0.158 ↑ 1.0 1,522 1

Seq Scan on seobbc_signature_electronique_op_b2b2c signop_4 (cost=0..106.22 rows=1,522 width=19) (actual time=0.003..0.158 rows=1,522 loops=1)

  • Buffers: shared hit=91
193. 0.140 0.255 ↑ 1.0 456 1

Hash (cost=16.56..16.56 rows=456 width=615) (actual time=0.255..0.255 rows=456 loops=1)

  • Buffers: shared hit=12
194. 0.115 0.115 ↑ 1.0 456 1

Seq Scan on b2bmad_proposition_modification_administrative op_4 (cost=0..16.56 rows=456 width=615) (actual time=0.018..0.115 rows=456 loops=1)

  • Buffers: shared hit=12
195. 0.781 1.249 ↓ 95.9 6,140 1

Hash (cost=1.28..1.28 rows=64 width=1,032) (actual time=1.249..1.249 rows=6,140 loops=1)

196. 0.468 0.468 ↓ 95.9 6,140 1

CTE Scan on liencodepere liencodepere_5 (cost=0..1.28 rows=64 width=1,032) (actual time=0.001..0.468 rows=6,140 loops=1)

197. 1.368 1.368 ↑ 1.0 1 456

Index Only Scan using idx_pervic_code_apporteur on pervic_personne_vision_courtier pvcpere_5 (cost=0.42..8.06 rows=1 width=7) (actual time=0.003..0.003 rows=1 loops=456)

  • Index Cond: (pvcpere_5.pervic_code_apporteur = (liencodepere_5.codesuperieur)::text)
  • Heap Fetches: 456
  • Buffers: shared hit=1,824
198. 2.736 2.736 ↑ 1.0 1 456

Index Scan using pervic_code_uk on pervic_personne_vision_courtier pvcassure_5 (cost=0.42..7.1 rows=1 width=30) (actual time=0.006..0.006 rows=1 loops=456)

  • Index Cond: ((pvcassure_5.pervic_code)::text = (op_4.b2bmad_assure_code_vision)::text)
  • Buffers: shared hit=1,824
199. 1.368 1.368 ↑ 1.0 1 456

Index Scan using perper_id_pkey on perper_personne perassure_5 (cost=0.42..0.52 rows=1 width=46) (actual time=0.003..0.003 rows=1 loops=456)

  • Index Cond: (perassure_5.perper_id = pvcassure_5.pervic_personne_id)
  • Buffers: shared hit=1,824
200. 0.000 0.000 ↓ 0.0 0 456

Index Scan using pervic_code_uk on pervic_personne_vision_courtier pvccoassure_5 (cost=0.42..7.1 rows=1 width=30) (actual time=0..0 rows=0 loops=456)

  • Index Cond: ((pvccoassure_5.pervic_code)::text = (op_4.b2bmad_coassure_code_vision)::text)
201. 0.000 0.000 ↓ 0.0 0 456

Index Scan using perper_id_pkey on perper_personne percoassure_5 (cost=0.42..0.52 rows=1 width=46) (actual time=0..0 rows=0 loops=456)

  • Index Cond: (percoassure_5.perper_id = pvccoassure_5.pervic_personne_id)
202. 1.219 1.831 ↓ 5.0 7,763 1

Hash (cost=31.18..31.18 rows=1,559 width=1,138) (actual time=1.831..1.831 rows=7,763 loops=1)

203. 0.612 0.612 ↓ 5.0 7,763 1

CTE Scan on operationissub2b2c crmop_5 (cost=0..31.18 rows=1,559 width=1,138) (actual time=0..0.612 rows=7,763 loops=1)

Planning time : 26.447 ms
Execution time : 10,166.502 ms