explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KaXH

Settings
# exclusive inclusive rows x rows loops node
1. 294.302 404,981.176 ↓ 1,086,969.0 2,173,938 1

Unique (cost=2,200,359.81..2,200,359.85 rows=2 width=1,298) (actual time=404,498.897..404,981.176 rows=2,173,938 loops=1)

  • Output: p.produit_id, (COALESCE(cp_ean.valeur, cp_isbn.valeur, p.code)), p.asin, pl.nom_plateforme, ('achat'::text), (COALESCE(pt.ttl, $0, 172800)), apt.date_updated
  • JIT:
  • Functions: 822
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 64.050 ms, Inlining 194.653 ms, Optimization 3387.430 ms, Emission 2020.164 ms, Total 5666.296 ms
  • Execution Time: 405641.666 msEXPLAIN
2. 1,451.125 404,686.874 ↓ 1,086,969.0 2,173,938 1

Sort (cost=2,200,359.81..2,200,359.82 rows=2 width=1,298) (actual time=404,498.896..404,686.874 rows=2,173,938 loops=1)

  • Output: p.produit_id, (COALESCE(cp_ean.valeur, cp_isbn.valeur, p.code)), p.asin, pl.nom_plateforme, ('achat'::text), (COALESCE(pt.ttl, $0, 172800)), apt.date_updated
  • Sort Key: p.produit_id, (COALESCE(cp_ean.valeur, cp_isbn.valeur, p.code)), p.asin, pl.nom_plateforme, ('achat'::text), (COALESCE(pt.ttl, $0, 172800)), apt.date_updated
  • Sort Method: external merge Disk: 131984kB
3. 101.658 403,235.749 ↓ 1,086,969.0 2,173,938 1

Append (cost=847,346.57..2,200,359.80 rows=2 width=1,298) (actual time=237,590.569..403,235.749 rows=2,173,938 loops=1)

4. 1.161 237,592.241 ↓ 925.0 925 1

Unique (cost=847,346.57..847,346.59 rows=1 width=585) (actual time=237,590.567..237,592.241 rows=925 loops=1)

  • Output: p.produit_id, (COALESCE(cp_ean.valeur, cp_isbn.valeur, p.code)), p.asin, pl.nom_plateforme, 'achat'::text, (COALESCE(pt.ttl, $0, 172800)), apt.date_updated
5.          

Initplan (for Unique)

6. 0.027 0.027 ↑ 1.0 1 1

Seq Scan on public.param (cost=0.00..1.51 rows=1 width=4) (actual time=0.026..0.027 rows=1 loops=1)

  • Output: param.valeur_int
  • Filter: ((param.name)::text = 'ttl_defaut_achat'::text)
  • Rows Removed by Filter: 40
7. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on public.adminpricing_typecode (cost=0.00..1.04 rows=1 width=4) (actual time=0.018..0.018 rows=1 loops=1)

  • Output: adminpricing_typecode.id
  • Filter: ((adminpricing_typecode.libelle)::text = 'EAN'::text)
  • Rows Removed by Filter: 2
8. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on public.adminpricing_typecode adminpricing_typecode_1 (cost=0.00..1.04 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: adminpricing_typecode_1.id
  • Filter: ((adminpricing_typecode_1.libelle)::text = 'ISBN'::text)
  • Rows Removed by Filter: 2
9. 14.972 237,591.032 ↓ 7,400.0 7,400 1

Sort (cost=847,342.99..847,342.99 rows=1 width=585) (actual time=237,590.566..237,591.032 rows=7,400 loops=1)

  • Output: p.produit_id, (COALESCE(cp_ean.valeur, cp_isbn.valeur, p.code)), p.asin, pl.nom_plateforme, 'achat'::text, (COALESCE(pt.ttl, $0, 172800)), apt.date_updated
  • Sort Key: p.produit_id, (COALESCE(cp_ean.valeur, cp_isbn.valeur, p.code)), p.asin, pl.nom_plateforme, (COALESCE(pt.ttl, $0, 172800)), apt.date_updated
  • Sort Method: quicksort Memory: 1135kB
10. 23.092 237,576.060 ↓ 7,400.0 7,400 1

Nested Loop Left Join (cost=37,298.60..847,342.98 rows=1 width=585) (actual time=2,598.926..237,576.060 rows=7,400 loops=1)

  • Output: p.produit_id, COALESCE(cp_ean.valeur, cp_isbn.valeur, p.code), p.asin, pl.nom_plateforme, 'achat'::text, COALESCE(pt.ttl, $0, 172800), apt.date_updated
  • Inner Unique: true
  • Join Filter: (nep.marketplace_id = pl.plateforme_id)
  • Rows Removed by Join Filter: 8
  • Filter: (nep.nonexistent_product_id IS NULL)
11. 2,399.576 237,486.368 ↓ 7,400.0 7,400 1

Nested Loop Anti Join (cost=37,298.04..847,341.44 rows=1 width=74) (actual time=2,598.827..237,486.368 rows=7,400 loops=1)

  • Output: p.produit_id, p.code, p.asin, pl.nom_plateforme, pl.plateforme_id, pt.ttl, cp_ean.valeur, cp_isbn.valeur, apt.date_updated
  • Join Filter: (apt.plateforme_id_fk = pl.plateforme_id)
  • Rows Removed by Join Filter: 7532744
12. 1,527.468 164,148.152 ↓ 7,093,864.0 7,093,864 1

Nested Loop Left Join (cost=37,297.47..847,337.46 rows=1 width=66) (actual time=2,579.047..164,148.152 rows=7,093,864 loops=1)

  • Output: p.produit_id, p.code, p.asin, pl.nom_plateforme, pl.plateforme_id, pt.ttl, cp_ean.valeur, cp_isbn.valeur
  • Inner Unique: true
13. 5,494.894 141,339.092 ↓ 7,093,864.0 7,093,864 1

Nested Loop Left Join (cost=37,296.90..847,336.68 rows=1 width=55) (actual time=2,579.036..141,339.092 rows=7,093,864 loops=1)

  • Output: p.produit_id, p.code, p.asin, pl.nom_plateforme, pl.plateforme_id, pt.ttl, cp_ean.valeur
  • Inner Unique: true
14. 252.461 93,281.014 ↓ 7,093,864.0 7,093,864 1

Nested Loop Left Join (cost=37,296.32..847,335.90 rows=1 width=44) (actual time=2,578.930..93,281.014 rows=7,093,864 loops=1)

  • Output: p.produit_id, p.code, p.asin, pl.nom_plateforme, pl.plateforme_id, pt.ttl
  • Inner Unique: true
  • Join Filter: (pt.marketplace_id = pl.plateforme_id)
  • Rows Removed by Join Filter: 73080
15. 2,251.052 64,653.097 ↓ 7,093,864.0 7,093,864 1

Nested Loop (cost=37,295.76..847,334.17 rows=1 width=40) (actual time=2,578.838..64,653.097 rows=7,093,864 loops=1)

  • Output: p.produit_id, p.code, p.asin, pl.nom_plateforme, pl.plateforme_id
  • Join Filter: ((s.societe_id = psa.societe_id_fk) AND (pl_vente.plateforme_id = psa.plateforme_id_fk))
  • Rows Removed by Join Filter: 44336650
16. 8,545.026 26,932.725 ↓ 7,093,864.0 7,093,864 1

Nested Loop (cost=37,295.61..847,333.71 rows=1 width=56) (actual time=2,578.808..26,932.725 rows=7,093,864 loops=1)

  • Output: p.produit_id, p.code, p.asin, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id, pl_vente.plateforme_id
  • Join Filter: (i.plateforme_vente_id_fk = pl_vente.plateforme_id)
  • Rows Removed by Join Filter: 163158872
17. 0.075 0.075 ↑ 1.0 24 1

Index Only Scan using plateforme_plateforme_id_actif_idx on public.plateforme pl_vente (cost=0.14..2.70 rows=24 width=4) (actual time=0.010..0.075 rows=24 loops=1)

  • Output: pl_vente.plateforme_id, pl_vente.actif
  • Heap Fetches: 0
18. 14,556.633 18,387.624 ↓ 7,093,864.0 7,093,864 24

Materialize (cost=37,295.47..847,330.66 rows=1 width=52) (actual time=107.453..766.151 rows=7,093,864 loops=24)

  • Output: p.produit_id, p.code, p.asin, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
19. 608.334 3,830.991 ↓ 7,093,864.0 7,093,864 1

Gather (cost=37,295.47..847,330.65 rows=1 width=52) (actual time=2,578.785..3,830.991 rows=7,093,864 loops=1)

  • Output: p.produit_id, p.code, p.asin, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Workers Planned: 2
  • Workers Launched: 2
  • JIT for worker 0:
  • Functions: 118
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 8.844 ms, Inlining 36.996 ms, Optimization 428.770 ms, Emission 261.665 ms, Total 736.275 ms
  • JIT for worker 1:
  • Functions: 118
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 8.836 ms, Inlining 37.044 ms, Optimization 429.829 ms, Emission 261.047 ms, Total 736.756 ms
20. 372.065 3,222.657 ↓ 2,364,621.0 2,364,621 3 / 3

Hash Left Join (cost=36,295.47..846,330.55 rows=1 width=52) (actual time=1,499.069..3,222.657 rows=2,364,621 loops=3)

  • Output: p.produit_id, p.code, p.asin, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Inner Unique: true
  • Hash Cond: (p.produit_id = ps.produit_id)
  • Filter: (ps.id IS NULL)
  • Worker 0: actual time=1056.298..6227.063 rows=7093864 loops=1
  • Worker 1: actual time=863.141..863.141 rows=0 loops=1
21. 256.713 2,849.517 ↑ 1.3 2,364,621 3 / 3

Merge Join (cost=35,853.92..838,101.69 rows=2,966,595 width=52) (actual time=1,497.979..2,849.517 rows=2,364,621 loops=3)

  • Output: p.produit_id, p.code, p.asin, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Inner Unique: true
  • Merge Cond: (c.template_pricing_categorie_id_fk = tpc.template_pricing_categorie_id)
  • Worker 0: actual time=1053.030..5107.644 rows=7093864 loops=1
  • Worker 1: actual time=863.140..863.140 rows=0 loops=1
22. 294.741 2,592.770 ↑ 1.2 2,364,621 3 / 3

Merge Join (cost=35,848.28..1,149,758.54 rows=2,925,684 width=60) (actual time=1,497.941..2,592.770 rows=2,364,621 loops=3)

  • Output: p.produit_id, p.code, p.asin, c.template_pricing_categorie_id_fk, iapfps.template_pricing_categorie_id_fk, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Merge Cond: (c.template_pricing_categorie_id_fk = iapfps.template_pricing_categorie_id_fk)
  • Worker 0: actual time=1052.918..4337.403 rows=7093864 loops=1
  • Worker 1: actual time=863.139..863.139 rows=0 loops=1
23. 36.380 2,192.589 ↑ 2.4 295,578 3 / 3

Nested Loop (cost=35,567.78..1,561,736.98 rows=694,730 width=30) (actual time=1,496.573..2,192.589 rows=295,578 loops=3)

  • Output: p.produit_id, p.code, p.asin, c.template_pricing_categorie_id_fk
  • Worker 0: actual time=1048.815..3136.861 rows=886733 loops=1
  • Worker 1: actual time=863.138..863.138 rows=0 loops=1
24. 1,391.978 1,391.978 ↓ 0.0 0 3 / 3

Parallel Index Scan using categorie_template_id_fk_active_ix_2 on public.categorie c (cost=0.42..16,011.08 rows=1 width=8) (actual time=1,391.969..1,391.978 rows=0 loops=3)

  • Output: c.categorie_id, c.template_pricing_categorie_id_fk
  • Index Cond: (c.active = 1)
  • Filter: ((c.nb_produit > 0) AND (c.categorie_id = 36381) AND (c.is_selling = 1))
  • Rows Removed by Filter: 43836
  • Worker 0: actual time=735.004..735.033 rows=1 loops=1
  • Worker 1: actual time=863.137..863.137 rows=0 loops=1
25. 670.906 764.231 ↑ 1.9 886,733 1 / 3

Bitmap Heap Scan on public.produit p (cost=35,567.36..1,529,052.39 rows=1,667,351 width=30) (actual time=313.788..2,292.692 rows=886,733 loops=1)

  • Output: p.produit_id, p.code, p.asin, p.categorie_id_fk, p.date_created, p.date_updated, p.deleted, p.poids
  • Recheck Cond: ((p.categorie_id_fk = 36381) AND (p.deleted = 0))
  • Worker 0: actual time=313.788..2292.692 rows=886733 loops=1
26. 93.325 93.325 ↑ 1.9 886,733 1 / 3

Bitmap Index Scan on produit_categorie_deleted_ix (cost=0.00..35,150.52 rows=1,667,351 width=0) (actual time=279.975..279.975 rows=886,733 loops=1)

  • Index Cond: ((p.categorie_id_fk = 36381) AND (p.deleted = 0))
  • Worker 0: actual time=279.975..279.975 rows=886733 loops=1
27. 104.370 105.440 ↓ 3,726.0 7,094,397 1 / 3

Sort (cost=273.90..278.66 rows=1,904 width=30) (actual time=4.033..316.320 rows=7,094,397 loops=1)

  • Output: iapfps.template_pricing_categorie_id_fk, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Sort Key: iapfps.template_pricing_categorie_id_fk
  • Worker 0: Sort Method: quicksort Memory: 414kB
  • Worker 0: actual time=4.033..316.320 rows=7094397 loops=1
28. 0.191 1.070 ↓ 2.1 4,066 1 / 3

Hash Join (cost=14.79..170.19 rows=1,904 width=30) (actual time=0.436..3.210 rows=4,066 loops=1)

  • Output: iapfps.template_pricing_categorie_id_fk, iapfps.societe_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Inner Unique: true
  • Hash Cond: (iapfps.algorithme_pricing_id_fk = ap.algorithme_pricing_id)
  • Worker 0: actual time=0.436..3.210 rows=4066 loops=1
29. 0.164 0.836 ↓ 2.1 4,066 1 / 3

Hash Join (cost=8.15..158.42 rows=1,904 width=34) (actual time=0.162..2.509 rows=4,066 loops=1)

  • Output: iapfps.template_pricing_categorie_id_fk, iapfps.societe_id_fk, iapfps.algorithme_pricing_id_fk, s.societe_id, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Inner Unique: true
  • Hash Cond: (iapfps.societe_id_fk = s.societe_id)
  • Worker 0: actual time=0.162..2.509 rows=4066 loops=1
30. 0.149 0.663 ↓ 2.0 4,066 1 / 3

Hash Join (cost=6.40..150.59 rows=2,036 width=30) (actual time=0.125..1.990 rows=4,066 loops=1)

  • Output: iapfps.template_pricing_categorie_id_fk, iapfps.societe_id_fk, iapfps.algorithme_pricing_id_fk, i.plateforme_vente_id_fk, pl.nom_plateforme, pl.plateforme_id
  • Inner Unique: true
  • Hash Cond: (i.plateforme_achat_id_fk = pl.plateforme_id)
  • Worker 0: actual time=0.125..1.990 rows=4066 loops=1
31. 0.159 0.506 ↑ 1.0 4,066 1 / 3

Hash Join (cost=4.95..136.56 rows=4,071 width=20) (actual time=0.092..1.518 rows=4,066 loops=1)

  • Output: iapfps.template_pricing_categorie_id_fk, iapfps.societe_id_fk, iapfps.algorithme_pricing_id_fk, i.plateforme_achat_id_fk, i.plateforme_vente_id_fk
  • Inner Unique: true
  • Hash Cond: (iapfps.itineraire_id_fk = i.itineraire_id)
  • Worker 0: actual time=0.092..1.518 rows=4066 loops=1
32. 0.327 0.327 ↑ 1.0 4,066 1 / 3

Seq Scan on public.itineraire_algorithme_pricing_fdp_poids_set iapfps (cost=0.00..120.64 rows=4,071 width=16) (actual time=0.025..0.982 rows=4,066 loops=1)

  • Output: iapfps.template_pricing_categorie_id_fk, iapfps.societe_id_fk, iapfps.itineraire_id_fk, iapfps.algorithme_pricing_id_fk
  • Filter: (iapfps.actif = 1)
  • Rows Removed by Filter: 865
  • Worker 0: actual time=0.025..0.982 rows=4066 loops=1
33. 0.006 0.019 ↑ 1.0 158 1 / 3

Hash (cost=2.98..2.98 rows=158 width=12) (actual time=0.058..0.058 rows=158 loops=1)

  • Output: i.itineraire_id, i.plateforme_achat_id_fk, i.plateforme_vente_id_fk
  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Worker 0: actual time=0.058..0.058 rows=158 loops=1
34. 0.013 0.013 ↑ 1.0 158 1 / 3

Seq Scan on public.itineraire i (cost=0.00..2.98 rows=158 width=12) (actual time=0.020..0.040 rows=158 loops=1)

  • Output: i.itineraire_id, i.plateforme_achat_id_fk, i.plateforme_vente_id_fk
  • Filter: (i.actif = 1)
  • Worker 0: actual time=0.020..0.040 rows=158 loops=1
35. 0.001 0.008 ↑ 1.1 11 1 / 3

Hash (cost=1.30..1.30 rows=12 width=14) (actual time=0.025..0.025 rows=11 loops=1)

  • Output: pl.nom_plateforme, pl.plateforme_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Worker 0: actual time=0.025..0.025 rows=11 loops=1
36. 0.007 0.007 ↑ 1.1 11 1 / 3

Seq Scan on public.plateforme pl (cost=0.00..1.30 rows=12 width=14) (actual time=0.016..0.021 rows=11 loops=1)

  • Output: pl.nom_plateforme, pl.plateforme_id
  • Filter: (pl.calcul_prix_achat = 1)
  • Rows Removed by Filter: 13
  • Worker 0: actual time=0.016..0.021 rows=11 loops=1
37. 0.002 0.009 ↓ 1.1 31 1 / 3

Hash (cost=1.39..1.39 rows=29 width=4) (actual time=0.027..0.027 rows=31 loops=1)

  • Output: s.societe_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Worker 0: actual time=0.027..0.027 rows=31 loops=1
38. 0.007 0.007 ↓ 1.1 31 1 / 3

Seq Scan on public.societe s (cost=0.00..1.39 rows=29 width=4) (actual time=0.016..0.021 rows=31 loops=1)

  • Output: s.societe_id
  • Filter: (s.active = 1)
  • Worker 0: actual time=0.016..0.021 rows=31 loops=1
39. 0.007 0.043 ↓ 1.0 162 1 / 3

Hash (cost=4.69..4.69 rows=156 width=4) (actual time=0.128..0.128 rows=162 loops=1)

  • Output: ap.algorithme_pricing_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
  • Worker 0: actual time=0.128..0.128 rows=162 loops=1
40. 0.036 0.036 ↓ 1.0 162 1 / 3

Index Only Scan using algorithme_pricing_id_pkey on public.algorithme_pricing ap (cost=0.14..4.69 rows=156 width=4) (actual time=0.055..0.108 rows=162 loops=1)

  • Output: ap.algorithme_pricing_id
  • Heap Fetches: 45
  • Worker 0: actual time=0.055..0.108 rows=162 loops=1
41. 0.034 0.034 ↑ 5.6 55 1 / 3

Index Scan using template_pricing_categorie_id_pkey on public.template_pricing_categorie tpc (cost=0.27..26.37 rows=307 width=4) (actual time=0.038..0.101 rows=55 loops=1)

  • Output: tpc.template_pricing_categorie_id, tpc.nom, tpc.active, tpc.date_created, tpc.tva_achat, tpc.type_code_id, tpc.commentaires, tpc.modele_decision_id_fk, tpc.customer_service_fee, tpc.it_service_fee, tpc.logistics_fee, tpc.packing_fee, tpc.sourcing_fee, tpc.indirect_costs, tpc.ships_domestically_only, tpc.options
  • Filter: (tpc.active = 1)
  • Rows Removed by Filter: 20
  • Worker 0: actual time=0.038..0.101 rows=55 loops=1
42. 0.401 1.075 ↓ 1.0 13,472 1 / 3

Hash (cost=275.69..275.69 rows=13,269 width=8) (actual time=3.226..3.226 rows=13,472 loops=1)

  • Output: ps.produit_id, ps.id
  • Buckets: 16384 Batches: 1 Memory Usage: 655kB
  • Worker 0: actual time=3.226..3.226 rows=13472 loops=1
43. 0.675 0.675 ↓ 1.0 13,472 1 / 3

Seq Scan on public.adminpricing_produitstock ps (cost=0.00..275.69 rows=13,269 width=8) (actual time=0.019..2.024 rows=13,472 loops=1)

  • Output: ps.produit_id, ps.id
  • Worker 0: actual time=0.019..2.024 rows=13472 loops=1
44. 35,469.320 35,469.320 ↓ 1.8 7 7,093,864

Index Scan using plateforme_societe_account_ix_2 on public.plateforme_societe_account psa (cost=0.15..0.40 rows=4 width=8) (actual time=0.001..0.005 rows=7 loops=7,093,864)

  • Output: psa.plateforme_societe_account_id, psa.credentials, psa.plateforme_id_fk, psa.societe_id_fk, psa.actif, psa.principal, psa.date_last_block, psa.date_last_used, psa.is_pricing, psa.accept_orders, psa.min_sent_feeds_count, psa.is_in_iota, psa.fixed_commission, psa.variable_commission, psa.tn_with_accept_orders, psa.last_refeed_update
  • Index Cond: (psa.societe_id_fk = iapfps.societe_id_fk)
  • Filter: ((psa.actif = 1) AND (psa.principal = 1))
  • Rows Removed by Filter: 3
45. 28,375.456 28,375.456 ↓ 0.0 0 7,093,864

Index Scan using produit_ttl_produit_id_fk_5c472ea5 on public.produit_ttl pt (cost=0.56..1.48 rows=20 width=12) (actual time=0.004..0.004 rows=0 loops=7,093,864)

  • Output: pt.produit_ttl_id, pt.produit_id_fk, pt.ttl, pt.marketplace_id
  • Index Cond: (p.produit_id = pt.produit_id_fk)
46. 42,563.184 42,563.184 ↑ 11.0 1 7,093,864

Index Scan using adminpricing_codeproduit_8eb6132c on public.adminpricing_codeproduit cp_ean (cost=0.57..2.85 rows=11 width=15) (actual time=0.006..0.006 rows=1 loops=7,093,864)

  • Output: cp_ean.id, cp_ean.valeur, cp_ean.produit_id, cp_ean.type_code_id
  • Index Cond: (cp_ean.produit_id = p.produit_id)
  • Filter: (cp_ean.type_code_id = $1)
  • Rows Removed by Filter: 1
47. 21,281.592 21,281.592 ↑ 11.0 1 7,093,864

Index Scan using adminpricing_codeproduit_8eb6132c on public.adminpricing_codeproduit cp_isbn (cost=0.57..2.85 rows=11 width=15) (actual time=0.003..0.003 rows=1 loops=7,093,864)

  • Output: cp_isbn.id, cp_isbn.valeur, cp_isbn.produit_id, cp_isbn.type_code_id
  • Index Cond: (cp_isbn.produit_id = p.produit_id)
  • Filter: (cp_isbn.type_code_id = $2)
  • Rows Removed by Filter: 2
48. 70,938.640 70,938.640 ↑ 2.5 2 7,093,864

Index Scan using adminpricing_pricingtracking_produit_id_fk_285101c9 on public.adminpricing_pricingtracking apt (cost=0.57..3.92 rows=5 width=16) (actual time=0.007..0.010 rows=2 loops=7,093,864)

  • Output: apt.id, apt.date_updated, apt.plateforme_id_fk, apt.produit_id_fk
  • Index Cond: (apt.produit_id_fk = p.produit_id)
  • Filter: (((timezone('EDT'::text, now()))::timestamp with time zone - apt.date_updated) <= '7 days'::interval)
  • Rows Removed by Filter: 0
49. 66.600 66.600 ↓ 0.0 0 7,400

Index Scan using adminpricing_nonexistent_produit_id_marketplace_i_a17d1865_uniq on public.adminpricing_nonexistentproducts nep (cost=0.56..1.51 rows=2 width=16) (actual time=0.009..0.009 rows=0 loops=7,400)

  • Output: nep.nonexistent_product_id, nep."exists", nep.date_created, nep.marketplace_id, nep.produit_id
  • Index Cond: (nep.produit_id = p.produit_id)
  • Filter: (NOT nep."exists")
50. 274.322 165,541.850 ↓ 2,173,013.0 2,173,013 1

Unique (cost=1,353,013.16..1,353,013.18 rows=1 width=585) (actual time=164,966.225..165,541.850 rows=2,173,013 loops=1)

  • Output: p_1.produit_id, (COALESCE(cp_ean_1.valeur, cp_isbn_1.valeur, p_1.code)), p_1.asin, pl_1.nom_plateforme, 'vente'::text, (COALESCE(pt_1.ttl, $3, 172800)), apt_1.date_updated
51.          

Initplan (for Unique)

52. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on public.param param_1 (cost=0.00..1.51 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=1)

  • Output: param_1.valeur_int
  • Filter: ((param_1.name)::text = 'ttl_defaut_vente'::text)
  • Rows Removed by Filter: 40
53. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on public.adminpricing_typecode adminpricing_typecode_2 (cost=0.00..1.04 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Output: adminpricing_typecode_2.id
  • Filter: ((adminpricing_typecode_2.libelle)::text = 'EAN'::text)
  • Rows Removed by Filter: 2
54. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on public.adminpricing_typecode adminpricing_typecode_3 (cost=0.00..1.04 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1)

  • Output: adminpricing_typecode_3.id
  • Filter: ((adminpricing_typecode_3.libelle)::text = 'ISBN'::text)
  • Rows Removed by Filter: 2
55. 3,331.022 165,267.504 ↓ 2,173,013.0 2,173,013 1

Sort (cost=1,353,009.57..1,353,009.58 rows=1 width=585) (actual time=164,966.223..165,267.504 rows=2,173,013 loops=1)

  • Output: p_1.produit_id, (COALESCE(cp_ean_1.valeur, cp_isbn_1.valeur, p_1.code)), p_1.asin, pl_1.nom_plateforme, 'vente'::text, (COALESCE(pt_1.ttl, $3, 172800)), apt_1.date_updated
  • Sort Key: p_1.produit_id, (COALESCE(cp_ean_1.valeur, cp_isbn_1.valeur, p_1.code)), p_1.asin, pl_1.nom_plateforme, (COALESCE(pt_1.ttl, $3, 172800)), apt_1.date_updated
  • Sort Method: external merge Disk: 131928kB
56. 496.802 161,936.482 ↓ 2,173,013.0 2,173,013 1

Nested Loop Left Join (cost=372,862.15..1,353,009.56 rows=1 width=585) (actual time=8,592.915..161,936.482 rows=2,173,013 loops=1)

  • Output: p_1.produit_id, COALESCE(cp_ean_1.valeur, cp_isbn_1.valeur, p_1.code), p_1.asin, pl_1.nom_plateforme, 'vente'::text, COALESCE(pt_1.ttl, $3, 172800), apt_1.date_updated
  • Inner Unique: true
57. 1,323.057 154,920.641 ↓ 2,173,013.0 2,173,013 1

Nested Loop Left Join (cost=372,861.58..1,353,008.78 rows=1 width=59) (actual time=8,592.890..154,920.641 rows=2,173,013 loops=1)

  • Output: p_1.produit_id, p_1.code, p_1.asin, pl_1.nom_plateforme, pt_1.ttl, cp_ean_1.valeur, apt_1.date_updated
  • Inner Unique: true
58. 792.923 140,559.506 ↓ 2,173,013.0 2,173,013 1

Nested Loop (cost=372,861.01..1,353,008.00 rows=1 width=48) (actual time=8,592.858..140,559.506 rows=2,173,013 loops=1)

  • Output: p_1.produit_id, p_1.code, p_1.asin, pl_1.nom_plateforme, pt_1.ttl, apt_1.date_updated
  • Join Filter: ((s_1.societe_id = psc.societe_id_fk) AND (pl_1.plateforme_id = psc.plateforme_id_fk))
  • Rows Removed by Join Filter: 11990435
59. 65.731 128,901.518 ↓ 2,173,013.0 2,173,013 1

Nested Loop Anti Join (cost=372,860.86..1,353,007.54 rows=1 width=64) (actual time=8,592.831..128,901.518 rows=2,173,013 loops=1)

  • Output: p_1.produit_id, p_1.code, p_1.asin, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id, pt_1.ttl, apt_1.date_updated
  • Join Filter: (apt_1.plateforme_id_fk = pl_1.plateforme_id)
  • Rows Removed by Join Filter: 17507134
60. 262.719 61,451.463 ↓ 4,813,166.0 4,813,166 1

Nested Loop (cost=372,860.29..1,353,003.56 rows=1 width=56) (actual time=8,592.776..61,451.463 rows=4,813,166 loops=1)

  • Output: p_1.produit_id, p_1.code, p_1.asin, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id, pt_1.ttl
61. 446.798 32,838.888 ↓ 7,087,464.0 7,087,464 1

Nested Loop Left Join (cost=372,859.72..1,353,001.48 rows=1 width=56) (actual time=8,592.693..32,838.888 rows=7,087,464 loops=1)

  • Output: p_1.produit_id, p_1.code, p_1.asin, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id, pt_1.ttl
  • Inner Unique: true
  • Join Filter: (pt_1.marketplace_id = pl_1.plateforme_id)
  • Rows Removed by Join Filter: 2505123
62. 0.000 11,129.698 ↓ 7,087,464.0 7,087,464 1

Gather (cost=372,859.16..1,352,999.75 rows=1 width=52) (actual time=8,592.667..11,129.698 rows=7,087,464 loops=1)

  • Output: p_1.produit_id, p_1.code, p_1.asin, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Workers Planned: 2
  • Workers Launched: 2
  • JIT for worker 0:
  • Functions: 122
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 9.485 ms, Inlining 37.528 ms, Optimization 471.482 ms, Emission 277.951 ms, Total 796.446 ms
  • JIT for worker 1:
  • Functions: 122
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 9.491 ms, Inlining 37.520 ms, Optimization 471.690 ms, Emission 277.698 ms, Total 796.398 ms
63. 7,169.270 11,466.754 ↓ 2,362,488.0 2,362,488 3 / 3

Parallel Hash Left Join (cost=371,859.16..1,351,999.65 rows=1 width=52) (actual time=9,007.327..11,466.754 rows=2,362,488 loops=3)

  • Output: p_1.produit_id, p_1.code, p_1.asin, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Inner Unique: true
  • Hash Cond: ((p_1.produit_id = nep_1.produit_id) AND (pl_1.plateforme_id = nep_1.marketplace_id))
  • Filter: (nep_1.nonexistent_product_id IS NULL)
  • Rows Removed by Filter: 2133
  • Worker 0: actual time=9211.547..12719.476 rows=2658716 loops=1
  • Worker 1: actual time=9218.800..13050.158 rows=4403037 loops=1
64. 247.918 1,222.856 ↑ 2.1 2,364,621 3 / 3

Merge Join (cost=35,942.38..873,421.17 rows=4,944,325 width=52) (actual time=137.364..1,222.856 rows=2,364,621 loops=3)

  • Output: p_1.produit_id, p_1.code, p_1.asin, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Inner Unique: true
  • Merge Cond: (c_1.template_pricing_categorie_id_fk = tpc_1.template_pricing_categorie_id)
  • Worker 0: actual time=76.963..76.963 rows=0 loops=1
  • Worker 1: actual time=76.973..76.973 rows=0 loops=1
65. 273.564 974.918 ↑ 2.1 2,364,621 3 / 3

Merge Join (cost=35,936.66..1,179,093.36 rows=4,876,140 width=60) (actual time=137.337..974.918 rows=2,364,621 loops=3)

  • Output: p_1.produit_id, p_1.code, p_1.asin, c_1.template_pricing_categorie_id_fk, iapfps_1.template_pricing_categorie_id_fk, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Merge Cond: (c_1.template_pricing_categorie_id_fk = iapfps_1.template_pricing_categorie_id_fk)
  • Worker 0: actual time=76.962..76.962 rows=0 loops=1
  • Worker 1: actual time=76.964..76.964 rows=0 loops=1
66. 31.845 608.935 ↑ 2.4 295,578 3 / 3

Nested Loop (cost=35,567.78..1,561,736.98 rows=694,730 width=30) (actual time=136.080..608.935 rows=295,578 loops=3)

  • Output: p_1.produit_id, p_1.code, p_1.asin, c_1.template_pricing_categorie_id_fk
  • Worker 0: actual time=76.960..76.961 rows=0 loops=1
  • Worker 1: actual time=76.962..76.962 rows=0 loops=1
67. 51.976 51.976 ↓ 0.0 0 3 / 3

Parallel Index Scan using categorie_template_id_fk_active_ix_2 on public.categorie c_1 (cost=0.42..16,011.08 rows=1 width=8) (actual time=51.968..51.976 rows=0 loops=3)

  • Output: c_1.categorie_id, c_1.template_pricing_categorie_id_fk
  • Index Cond: (c_1.active = 1)
  • Filter: ((c_1.nb_produit > 0) AND (c_1.categorie_id = 36381) AND (c_1.is_selling = 1))
  • Rows Removed by Filter: 43836
  • Worker 0: actual time=76.959..76.959 rows=0 loops=1
  • Worker 1: actual time=76.960..76.960 rows=0 loops=1
68. 453.876 525.114 ↑ 1.9 886,733 1 / 3

Bitmap Heap Scan on public.produit p_1 (cost=35,567.36..1,529,052.39 rows=1,667,351 width=30) (actual time=252.307..1,575.343 rows=886,733 loops=1)

  • Output: p_1.produit_id, p_1.code, p_1.asin, p_1.categorie_id_fk, p_1.date_created, p_1.date_updated, p_1.deleted, p_1.poids
  • Recheck Cond: ((p_1.categorie_id_fk = 36381) AND (p_1.deleted = 0))
  • Heap Blocks: exact=169697
69. 71.238 71.238 ↑ 1.9 886,733 1 / 3

Bitmap Index Scan on produit_categorie_deleted_ix (cost=0.00..35,150.52 rows=1,667,351 width=0) (actual time=213.714..213.714 rows=886,733 loops=1)

  • Index Cond: ((p_1.categorie_id_fk = 36381) AND (p_1.deleted = 0))
70. 91.479 92.419 ↓ 2,235.9 7,094,397 1 / 3

Sort (cost=362.28..370.21 rows=3,173 width=30) (actual time=3.684..277.256 rows=7,094,397 loops=1)

  • Output: iapfps_1.template_pricing_categorie_id_fk, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Sort Key: iapfps_1.template_pricing_categorie_id_fk
  • Sort Method: quicksort Memory: 414kB
71. 0.160 0.940 ↓ 1.3 4,066 1 / 3

Hash Join (cost=14.89..177.74 rows=3,173 width=30) (actual time=0.207..2.819 rows=4,066 loops=1)

  • Output: iapfps_1.template_pricing_categorie_id_fk, iapfps_1.societe_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Inner Unique: true
  • Hash Cond: (iapfps_1.algorithme_pricing_id_fk = ap_1.algorithme_pricing_id)
72. 0.162 0.759 ↓ 1.3 4,066 1 / 3

Hash Join (cost=8.25..162.56 rows=3,173 width=34) (actual time=0.131..2.276 rows=4,066 loops=1)

  • Output: iapfps_1.template_pricing_categorie_id_fk, iapfps_1.societe_id_fk, iapfps_1.algorithme_pricing_id_fk, s_1.societe_id, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Inner Unique: true
  • Hash Cond: (iapfps_1.societe_id_fk = s_1.societe_id)
73. 0.169 0.589 ↓ 1.2 4,066 1 / 3

Hash Join (cost=6.50..150.69 rows=3,392 width=30) (actual time=0.094..1.768 rows=4,066 loops=1)

  • Output: iapfps_1.template_pricing_categorie_id_fk, iapfps_1.societe_id_fk, iapfps_1.algorithme_pricing_id_fk, i_1.plateforme_vente_id_fk, pl_1.nom_plateforme, pl_1.plateforme_id
  • Inner Unique: true
  • Hash Cond: (i_1.plateforme_vente_id_fk = pl_1.plateforme_id)
74. 0.175 0.413 ↑ 1.0 4,066 1 / 3

Hash Join (cost=4.95..136.56 rows=4,071 width=16) (actual time=0.062..1.240 rows=4,066 loops=1)

  • Output: iapfps_1.template_pricing_categorie_id_fk, iapfps_1.societe_id_fk, iapfps_1.algorithme_pricing_id_fk, i_1.plateforme_vente_id_fk
  • Inner Unique: true
  • Hash Cond: (iapfps_1.itineraire_id_fk = i_1.itineraire_id)
75. 0.224 0.224 ↑ 1.0 4,066 1 / 3

Seq Scan on public.itineraire_algorithme_pricing_fdp_poids_set iapfps_1 (cost=0.00..120.64 rows=4,071 width=16) (actual time=0.010..0.673 rows=4,066 loops=1)

  • Output: iapfps_1.template_pricing_categorie_id_fk, iapfps_1.societe_id_fk, iapfps_1.itineraire_id_fk, iapfps_1.algorithme_pricing_id_fk
  • Filter: (iapfps_1.actif = 1)
  • Rows Removed by Filter: 865
76. 0.006 0.014 ↑ 1.0 158 1 / 3

Hash (cost=2.98..2.98 rows=158 width=8) (actual time=0.043..0.043 rows=158 loops=1)

  • Output: i_1.itineraire_id, i_1.plateforme_vente_id_fk
  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
77. 0.009 0.009 ↑ 1.0 158 1 / 3

Seq Scan on public.itineraire i_1 (cost=0.00..2.98 rows=158 width=8) (actual time=0.010..0.026 rows=158 loops=1)

  • Output: i_1.itineraire_id, i_1.plateforme_vente_id_fk
  • Filter: (i_1.actif = 1)
78. 0.002 0.007 ↑ 1.0 20 1 / 3

Hash (cost=1.30..1.30 rows=20 width=14) (actual time=0.020..0.020 rows=20 loops=1)

  • Output: pl_1.nom_plateforme, pl_1.plateforme_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
79. 0.005 0.005 ↑ 1.0 20 1 / 3

Seq Scan on public.plateforme pl_1 (cost=0.00..1.30 rows=20 width=14) (actual time=0.009..0.015 rows=20 loops=1)

  • Output: pl_1.nom_plateforme, pl_1.plateforme_id
  • Filter: (pl_1.actif = 1)
  • Rows Removed by Filter: 4
80. 0.002 0.008 ↓ 1.1 31 1 / 3

Hash (cost=1.39..1.39 rows=29 width=4) (actual time=0.023..0.023 rows=31 loops=1)

  • Output: s_1.societe_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
81. 0.005 0.005 ↓ 1.1 31 1 / 3

Seq Scan on public.societe s_1 (cost=0.00..1.39 rows=29 width=4) (actual time=0.009..0.016 rows=31 loops=1)

  • Output: s_1.societe_id
  • Filter: (s_1.active = 1)
82. 0.007 0.021 ↓ 1.0 162 1 / 3

Hash (cost=4.69..4.69 rows=156 width=4) (actual time=0.062..0.062 rows=162 loops=1)

  • Output: ap_1.algorithme_pricing_id
  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
83. 0.014 0.014 ↓ 1.0 162 1 / 3

Index Only Scan using algorithme_pricing_id_pkey on public.algorithme_pricing ap_1 (cost=0.14..4.69 rows=156 width=4) (actual time=0.012..0.042 rows=162 loops=1)

  • Output: ap_1.algorithme_pricing_id
  • Heap Fetches: 45
84. 0.020 0.020 ↑ 5.6 55 1 / 3

Index Scan using template_pricing_categorie_id_pkey on public.template_pricing_categorie tpc_1 (cost=0.27..26.37 rows=307 width=4) (actual time=0.013..0.061 rows=55 loops=1)

  • Output: tpc_1.template_pricing_categorie_id, tpc_1.nom, tpc_1.active, tpc_1.date_created, tpc_1.tva_achat, tpc_1.type_code_id, tpc_1.commentaires, tpc_1.modele_decision_id_fk, tpc_1.customer_service_fee, tpc_1.it_service_fee, tpc_1.logistics_fee, tpc_1.packing_fee, tpc_1.sourcing_fee, tpc_1.indirect_costs, tpc_1.ships_domestically_only, tpc_1.options
  • Filter: (tpc_1.active = 1)
  • Rows Removed by Filter: 20
85. 1,198.459 3,074.628 ↓ 1.7 6,955,967 3 / 3

Parallel Hash (cost=253,933.11..253,933.11 rows=4,123,311 width=16) (actual time=3,074.627..3,074.628 rows=6,955,967 loops=3)

  • Output: nep_1.produit_id, nep_1.marketplace_id, nep_1.nonexistent_product_id
  • Buckets: 8388608 Batches: 8 Memory Usage: 188032kB
  • Worker 0: actual time=3070.579..3070.580 rows=6066385 loops=1
  • Worker 1: actual time=3070.569..3070.570 rows=5966278 loops=1
86. 1,876.169 1,876.169 ↓ 1.7 6,955,967 3 / 3

Parallel Seq Scan on public.adminpricing_nonexistentproducts nep_1 (cost=0.00..253,933.11 rows=4,123,311 width=16) (actual time=525.346..1,876.169 rows=6,955,967 loops=3)

  • Output: nep_1.produit_id, nep_1.marketplace_id, nep_1.nonexistent_product_id
  • Worker 0: actual time=788.034..2031.739 rows=6066385 loops=1
  • Worker 1: actual time=787.958..2033.025 rows=5966278 loops=1
87. 21,262.392 21,262.392 ↓ 0.0 0 7,087,464

Index Scan using produit_ttl_produit_id_fk_5c472ea5 on public.produit_ttl pt_1 (cost=0.56..1.48 rows=20 width=12) (actual time=0.003..0.003 rows=0 loops=7,087,464)

  • Output: pt_1.produit_ttl_id, pt_1.produit_id_fk, pt_1.ttl, pt_1.marketplace_id
  • Index Cond: (p_1.produit_id = pt_1.produit_id_fk)
88. 28,349.856 28,349.856 ↑ 3.0 1 7,087,464

Index Scan using produit_prix_achat_produit_id_fk_58af2e0289034a16_uniq on public.produit_prix_achat ppa (cost=0.56..2.05 rows=3 width=4) (actual time=0.004..0.004 rows=1 loops=7,087,464)

  • Output: ppa.produit_prix_achat_id, ppa.plateforme_id_fk, ppa.produit_id_fk, ppa.prix_achat, ppa.date_created, ppa.date_updated, ppa.sellerid, ppa.shipping_time_id_fk, ppa.fulfillmentchannel, ppa.meta_meta_etat_id, ppa.meta_etat_id
  • Index Cond: (ppa.produit_id_fk = p_1.produit_id)
  • Filter: (ppa.prix_achat > '0'::numeric)
89. 67,384.324 67,384.324 ↑ 1.2 4 4,813,166

Index Scan using adminpricing_pricingtracking_produit_id_fk_285101c9 on public.adminpricing_pricingtracking apt_1 (cost=0.57..3.92 rows=5 width=16) (actual time=0.005..0.014 rows=4 loops=4,813,166)

  • Output: apt_1.id, apt_1.date_updated, apt_1.plateforme_id_fk, apt_1.produit_id_fk
  • Index Cond: (apt_1.produit_id_fk = p_1.produit_id)
  • Filter: (((timezone('EDT'::text, now()))::timestamp with time zone - apt_1.date_updated) <= '7 days'::interval)
  • Rows Removed by Filter: 2
90. 10,865.065 10,865.065 ↓ 1.8 7 2,173,013

Index Scan using plateforme_societe_account_ix_2 on public.plateforme_societe_account psc (cost=0.15..0.40 rows=4 width=8) (actual time=0.001..0.005 rows=7 loops=2,173,013)

  • Output: psc.plateforme_societe_account_id, psc.credentials, psc.plateforme_id_fk, psc.societe_id_fk, psc.actif, psc.principal, psc.date_last_block, psc.date_last_used, psc.is_pricing, psc.accept_orders, psc.min_sent_feeds_count, psc.is_in_iota, psc.fixed_commission, psc.variable_commission, psc.tn_with_accept_orders, psc.last_refeed_update
  • Index Cond: (psc.societe_id_fk = iapfps_1.societe_id_fk)
  • Filter: ((psc.actif = 1) AND (psc.principal = 1))
  • Rows Removed by Filter: 2
91. 13,038.078 13,038.078 ↑ 11.0 1 2,173,013

Index Scan using adminpricing_codeproduit_8eb6132c on public.adminpricing_codeproduit cp_ean_1 (cost=0.57..2.85 rows=11 width=15) (actual time=0.006..0.006 rows=1 loops=2,173,013)

  • Output: cp_ean_1.id, cp_ean_1.valeur, cp_ean_1.produit_id, cp_ean_1.type_code_id
  • Index Cond: (cp_ean_1.produit_id = p_1.produit_id)
  • Filter: (cp_ean_1.type_code_id = $4)
  • Rows Removed by Filter: 1
92. 6,519.039 6,519.039 ↑ 11.0 1 2,173,013

Index Scan using adminpricing_codeproduit_8eb6132c on public.adminpricing_codeproduit cp_isbn_1 (cost=0.57..2.85 rows=11 width=15) (actual time=0.003..0.003 rows=1 loops=2,173,013)

  • Output: cp_isbn_1.id, cp_isbn_1.valeur, cp_isbn_1.produit_id, cp_isbn_1.type_code_id
  • Index Cond: (cp_isbn_1.produit_id = p_1.produit_id)
  • Filter: (cp_isbn_1.type_code_id = $5)
  • Rows Removed by Filter: 2
Planning time : 54.024 ms