explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WJCO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.103 252,457.382 ↓ 123.0 123 1

Unique (cost=847,346.57..847,346.59 rows=1 width=585) (actual time=252,457.206..252,457.382 rows=123 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: 385
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 31.686 ms, Inlining 125.571 ms, Optimization 1691.539 ms, Emission 960.740 ms, Total 2809.536 ms
  • Execution Time: 252604.299 msEXPLAIN
2.          

Initplan (for Unique)

3. 0.011 0.011 ↑ 1.0 1 1

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

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

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

  • Output: adminpricing_typecode.id
  • Filter: ((adminpricing_typecode.libelle)::text = 'EAN'::text)
  • Rows Removed by Filter: 2
5. 0.004 0.004 ↑ 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.004 rows=1 loops=1)

  • Output: adminpricing_typecode_1.id
  • Filter: ((adminpricing_typecode_1.libelle)::text = 'ISBN'::text)
  • Rows Removed by Filter: 2
6. 2.384 252,457.243 ↓ 984.0 984 1

Sort (cost=847,342.99..847,342.99 rows=1 width=585) (actual time=252,457.205..252,457.243 rows=984 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: 142kB
7. 3.929 252,454.859 ↓ 984.0 984 1

Nested Loop Left Join (cost=37,298.60..847,342.98 rows=1 width=585) (actual time=2,304.812..252,454.859 rows=984 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)
8. 1,003.080 252,440.106 ↓ 984.0 984 1

Nested Loop Anti Join (cost=37,298.04..847,341.44 rows=1 width=74) (actual time=2,304.752..252,440.106 rows=984 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: 7516416
9. 2,658.483 166,310.658 ↓ 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=1,325.867..166,310.658 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
10. 0.000 142,370.583 ↓ 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=1,325.855..142,370.583 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
11. 842.702 93,686.631 ↓ 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=1,325.729..93,686.631 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
12. 2,903.200 64,468.473 ↓ 7,093,864.0 7,093,864 1

Nested Loop (cost=37,295.76..847,334.17 rows=1 width=40) (actual time=1,325.499..64,468.473 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
13. 8,789.129 26,095.953 ↓ 7,093,864.0 7,093,864 1

Nested Loop (cost=37,295.61..847,333.71 rows=1 width=56) (actual time=1,325.471..26,095.953 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
14. 0.064 0.064 ↑ 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.008..0.064 rows=24 loops=1)

  • Output: pl_vente.plateforme_id, pl_vente.actif
  • Heap Fetches: 0
15. 14,729.170 17,306.760 ↓ 7,093,864.0 7,093,864 24

Materialize (cost=37,295.47..847,330.66 rows=1 width=52) (actual time=55.231..721.115 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
16. 0.000 2,577.590 ↓ 7,093,864.0 7,093,864 1

Gather (cost=37,295.47..847,330.65 rows=1 width=52) (actual time=1,325.448..2,577.590 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: 106
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 8.983 ms, Inlining 39.045 ms, Optimization 454.509 ms, Emission 246.823 ms, Total 749.359 ms
  • JIT for worker 1:
  • Functions: 106
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 8.569 ms, Inlining 40.121 ms, Optimization 425.982 ms, Emission 248.566 ms, Total 723.237 ms
17. 389.187 2,959.132 ↓ 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,071.364..2,959.132 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=868.746..868.746 rows=0 loops=1
  • Worker 1: actual time=1020.788..6684.093 rows=7093864 loops=1
18. 269.987 2,568.817 ↑ 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,070.222..2,568.817 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=868.745..868.745 rows=0 loops=1
  • Worker 1: actual time=1017.364..5513.148 rows=7093864 loops=1
19. 299.761 2,298.799 ↑ 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,070.188..2,298.799 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=868.745..868.745 rows=0 loops=1
  • Worker 1: actual time=1017.262..4703.096 rows=7093864 loops=1
20. 38.996 1,890.932 ↑ 2.4 295,578 3 / 3

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

  • Output: p.produit_id, p.code, p.asin, c.template_pricing_categorie_id_fk
  • Worker 0: actual time=868.744..868.744 rows=0 loops=1
  • Worker 1: actual time=1013.161..3479.498 rows=886733 loops=1
21. 973.183 973.183 ↓ 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=973.173..973.183 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=868.742..868.743 rows=0 loops=1
  • Worker 1: actual time=726.223..726.251 rows=1 loops=1
22. 793.937 878.753 ↑ 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=286.915..2,636.260 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 1: actual time=286.915..2636.260 rows=886733 loops=1
23. 84.816 84.816 ↑ 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=254.448..254.448 rows=886,733 loops=1)

  • Index Cond: ((p.categorie_id_fk = 36381) AND (p.deleted = 0))
  • Worker 1: actual time=254.448..254.448 rows=886733 loops=1
24. 107.043 108.106 ↓ 3,726.0 7,094,397 1 / 3

Sort (cost=273.90..278.66 rows=1,904 width=30) (actual time=4.031..324.317 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 1: Sort Method: quicksort Memory: 414kB
  • Worker 1: actual time=4.031..324.317 rows=7094397 loops=1
25. 0.191 1.063 ↓ 2.1 4,066 1 / 3

Hash Join (cost=14.79..170.19 rows=1,904 width=30) (actual time=0.429..3.188 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 1: actual time=0.429..3.188 rows=4066 loops=1
26. 0.159 0.829 ↓ 2.1 4,066 1 / 3

Hash Join (cost=8.15..158.42 rows=1,904 width=34) (actual time=0.152..2.487 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 1: actual time=0.152..2.487 rows=4066 loops=1
27. 0.148 0.662 ↓ 2.0 4,066 1 / 3

Hash Join (cost=6.40..150.59 rows=2,036 width=30) (actual time=0.121..1.987 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 1: actual time=0.121..1.987 rows=4066 loops=1
28. 0.154 0.506 ↑ 1.0 4,066 1 / 3

Hash Join (cost=4.95..136.56 rows=4,071 width=20) (actual time=0.086..1.517 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 1: actual time=0.086..1.517 rows=4066 loops=1
29. 0.335 0.335 ↑ 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..1.005 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 1: actual time=0.025..1.005 rows=4066 loops=1
30. 0.006 0.017 ↑ 1.0 158 1 / 3

Hash (cost=2.98..2.98 rows=158 width=12) (actual time=0.051..0.051 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 1: actual time=0.051..0.051 rows=158 loops=1
31. 0.011 0.011 ↑ 1.0 158 1 / 3

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

  • Output: i.itineraire_id, i.plateforme_achat_id_fk, i.plateforme_vente_id_fk
  • Filter: (i.actif = 1)
  • Worker 1: actual time=0.019..0.034 rows=158 loops=1
32. 0.002 0.009 ↑ 1.1 11 1 / 3

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

  • Output: pl.nom_plateforme, pl.plateforme_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Worker 1: actual time=0.025..0.026 rows=11 loops=1
33. 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 1: actual time=0.016..0.021 rows=11 loops=1
34. 0.002 0.007 ↓ 1.1 31 1 / 3

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

  • Output: s.societe_id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Worker 1: actual time=0.022..0.022 rows=31 loops=1
35. 0.005 0.005 ↓ 1.1 31 1 / 3

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

  • Output: s.societe_id
  • Filter: (s.active = 1)
  • Worker 1: actual time=0.011..0.016 rows=31 loops=1
36. 0.006 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 1: actual time=0.128..0.128 rows=162 loops=1
37. 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.045..0.109 rows=162 loops=1)

  • Output: ap.algorithme_pricing_id
  • Heap Fetches: 45
  • Worker 1: actual time=0.045..0.109 rows=162 loops=1
38. 0.031 0.031 ↑ 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.036..0.094 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 1: actual time=0.036..0.094 rows=55 loops=1
39. 0.402 1.128 ↓ 1.0 13,472 1 / 3

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

  • Output: ps.produit_id, ps.id
  • Buckets: 16384 Batches: 1 Memory Usage: 655kB
  • Worker 1: actual time=3.385..3.385 rows=13472 loops=1
40. 0.726 0.726 ↓ 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.027..2.179 rows=13,472 loops=1)

  • Output: ps.produit_id, ps.id
  • Worker 1: actual time=0.027..2.179 rows=13472 loops=1
41. 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
42. 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)
43. 49,657.048 49,657.048 ↑ 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.007..0.007 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
44. 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
45. 85,126.368 85,126.368 ↑ 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.008..0.012 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
46. 10.824 10.824 ↓ 0.0 0 984

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.011..0.011 rows=0 loops=984)

  • 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")
Planning time : 32.885 ms