explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hOX

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 761.875 ↓ 3.0 3 1

Unique (cost=117,443.54..117,443.70 rows=1 width=2,518) (actual time=761.863..761.875 rows=3 loops=1)

2. 0.256 761.862 ↓ 3.0 3 1

Sort (cost=117,443.54..117,443.54 rows=1 width=2,518) (actual time=761.861..761.862 rows=3 loops=1)

  • Sort Key: ba_artico.arcatomo DESC, ba_artmod.arcodart, ba_artmod.tcdesprw, ba_artico.arflgart, ba_artico.arkeyart, ba_artmod.aralias, ba_artico.arflgblo, gsec_fsearch_item.category, gsec_fsearch_item.nccatalogid, (btrim((rtrim((CASE COALESCE(char_l (...)
  • Sort Method: quicksort Memory: 26kB
3. 0.478 761.606 ↓ 3.0 3 1

Nested Loop Left Join (cost=117,372.41..117,443.53 rows=1 width=2,518) (actual time=747.086..761.606 rows=3 loops=1)

  • Join Filter: ((zcme_przclisite.pzflgart = ba_artico.arflgart) AND ((zcme_przclisite.pzkeyart)::text = (ba_artico.arkeyart)::text) AND ((tc_cattco.ctcodcat)::text = (gsec_fsearch_item.nccatalogid)::text))
  • Rows Removed by Join Filter: 981
4. 0.015 34.288 ↓ 3.0 3 1

Nested Loop Left Join (cost=487.38..558.28 rows=1 width=2,387) (actual time=30.966..34.288 rows=3 loops=1)

5. 0.014 34.249 ↓ 3.0 3 1

Nested Loop Left Join (cost=487.23..553.33 rows=1 width=2,355) (actual time=30.942..34.249 rows=3 loops=1)

6. 0.011 34.199 ↓ 3.0 3 1

Nested Loop Left Join (cost=487.09..550.29 rows=1 width=2,351) (actual time=30.908..34.199 rows=3 loops=1)

  • Join Filter: (gsec_fsearch_item.category = ec_favourite.facategory)
7. 0.012 34.134 ↓ 3.0 3 1

Nested Loop (cost=486.95..549.26 rows=1 width=2,347) (actual time=30.867..34.134 rows=3 loops=1)

8. 0.027 34.086 ↓ 3.0 3 1

Nested Loop Left Join (cost=486.68..541.67 rows=1 width=2,347) (actual time=30.840..34.086 rows=3 loops=1)

  • Join Filter: (((ec_nav_cat_price.npnationid)::text = (ec_catalog_list.clnationid)::text) AND ((gsec_fsearch_item.nccatalogid)::text = (ec_catalog_list.clcatalogid)::text))
  • Rows Removed by Join Filter: 15
9. 0.018 33.990 ↓ 3.0 3 1

Nested Loop Left Join (cost=486.68..537.53 rows=1 width=2,313) (actual time=30.795..33.990 rows=3 loops=1)

10. 0.164 33.546 ↓ 3.0 3 1

Nested Loop Left Join (cost=486.26..521.95 rows=1 width=2,289) (actual time=30.669..33.546 rows=3 loops=1)

11. 0.013 33.301 ↓ 3.0 3 1

Nested Loop Left Join (cost=485.98..521.65 rows=1 width=2,248) (actual time=30.451..33.301 rows=3 loops=1)

12. 0.018 33.207 ↓ 3.0 3 1

Nested Loop Left Join (cost=485.69..513.34 rows=1 width=2,206) (actual time=30.391..33.207 rows=3 loops=1)

  • Join Filter: ((gsec_fsearch_item.ncuniecom)::text = (ba_unimis.umcodumi)::text)
13. 0.043 33.174 ↓ 3.0 3 1

Nested Loop Left Join (cost=485.69..512.32 rows=1 width=2,083) (actual time=30.374..33.174 rows=3 loops=1)

  • Join Filter: ((gsec_fsearch_item.nccatalogid)::text = (ba_catalog_def.ctcatalogid)::text)
  • Rows Removed by Join Filter: 27
14. 0.013 29.555 ↓ 3.0 3 1

Nested Loop Left Join (cost=484.50..499.65 rows=1 width=1,733) (actual time=28.901..29.555 rows=3 loops=1)

15. 0.016 29.422 ↓ 3.0 3 1

Nested Loop Left Join (cost=484.10..491.85 rows=1 width=926) (actual time=28.818..29.422 rows=3 loops=1)

16. 0.011 29.343 ↓ 3.0 3 1

Nested Loop Left Join (cost=483.82..491.54 rows=1 width=966) (actual time=28.786..29.343 rows=3 loops=1)

17. 0.014 29.290 ↓ 3.0 3 1

Nested Loop Left Join (cost=483.69..491.38 rows=1 width=868) (actual time=28.752..29.290 rows=3 loops=1)

18. 0.024 29.225 ↓ 3.0 3 1

Nested Loop Left Join (cost=483.57..491.22 rows=1 width=790) (actual time=28.707..29.225 rows=3 loops=1)

19. 0.360 29.057 ↓ 3.0 3 1

Merge Join (cost=483.28..483.48 rows=1 width=332) (actual time=28.630..29.057 rows=3 loops=1)

  • Merge Cond: (((ba_artico.arkeyart)::text = (gsec_fsearch_item.arkeyart)::text) AND (((ba_artico.arflgart)::numeric) = gsec_fsearch_item.arflgart))
20. 8.279 10.123 ↓ 25.3 354 1

Sort (cost=46.05..46.08 rows=14 width=206) (actual time=10.022..10.123 rows=354 loops=1)

  • Sort Key: ba_artico.arkeyart, ((ba_artico.arflgart)::numeric)
  • Sort Method: quicksort Memory: 192kB
21. 1.647 1.844 ↓ 74.5 1,043 1

Bitmap Heap Scan on ba_artico001 ba_artico (cost=4.39..45.78 rows=14 width=206) (actual time=0.239..1.844 rows=1,043 loops=1)

  • Recheck Cond: ((arwebpub)::text = 'S'::text)
  • Heap Blocks: exact=47
22. 0.197 0.197 ↓ 74.9 1,048 1

Bitmap Index Scan on ba_artico0012 (cost=0.00..4.39 rows=14 width=0) (actual time=0.197..0.197 rows=1,048 loops=1)

  • Index Cond: ((arwebpub)::text = 'S'::text)
23. 0.027 18.574 ↑ 1.7 3 1

Sort (cost=437.24..437.25 rows=5 width=126) (actual time=18.572..18.574 rows=3 loops=1)

  • Sort Key: gsec_fsearch_item.arkeyart, gsec_fsearch_item.arflgart
  • Sort Method: quicksort Memory: 25kB
24. 0.004 18.547 ↑ 1.7 3 1

Subquery Scan on gsec_fsearch_item (cost=436.93..437.18 rows=5 width=126) (actual time=18.422..18.547 rows=3 loops=1)

25. 0.147 18.543 ↑ 1.7 3 1

GroupAggregate (cost=436.93..437.13 rows=5 width=134) (actual time=18.420..18.543 rows=3 loops=1)

  • Group Key: ba_nav_cat.ncflgart, ba_nav_cat.nckeyart, ba_nav_cat.nccategory
26. 0.203 18.396 ↓ 18.2 91 1

Sort (cost=436.93..436.94 rows=5 width=98) (actual time=18.372..18.396 rows=91 loops=1)

  • Sort Key: ba_nav_cat.ncflgart, ba_nav_cat.nckeyart, ba_nav_cat.nccategory
  • Sort Method: quicksort Memory: 37kB
27. 4.477 18.193 ↓ 18.2 91 1

Nested Loop Left Join (cost=0.29..436.87 rows=5 width=98) (actual time=0.398..18.193 rows=91 loops=1)

  • Join Filter: (((ba_nav_cat.nckeyart)::text = (ba_salart.sakeyart)::text) AND (ba_nav_cat.ncflgart = (ba_salart.saflg (...)
  • Rows Removed by Join Filter: 9272
  • -> Seq Scan on ba_nav_cat001 ba_nav_cat (cost=0.00..57.29 rows=5 width=58) (actual time=0.114..0.750 rows=3 loops= (...)
  • Filter: (((ncsite)::text = 'MET'::text) AND ((nccatcontid)::numeric = 138.0))
  • Rows Removed by Filter: 928
28. 13.716 13.716 ↓ 3,121.0 3,121 3

Materialize (cost=0.29..379.48 rows=1 width=82) (actual time=0.028..4.572 rows=3,121 loops=3)

  • -> Index Scan using ba_salart0012 on ba_salart001 ba_salart (cost=0.29..379.48 rows=1 width=82) (actual time (...)
  • Index Cond: ((satipmag = 2) AND ((sacodmag)::text = '501'::text))
29. 0.144 0.144 ↑ 1.0 1 3

Index Scan using pk_ba_artmod on ba_artmod (cost=0.28..7.73 rows=1 width=458) (actual time=0.048..0.048 rows=1 loops=3)

  • Index Cond: ((ba_artico.arflgart = arflgart) AND ((ba_artico.arkeyart)::text = (arkeyart)::text))
30. 0.051 0.051 ↑ 1.0 1 3

Index Scan using pk_ba_unimis on ba_unimis ba_unimis1 (cost=0.13..0.14 rows=1 width=126) (actual time=0.017..0.017 rows=1 loops=3)

  • Index Cond: ((ba_artmod.arunimis)::text = (umcodumi)::text)
31. 0.042 0.042 ↑ 1.0 1 3

Index Scan using pk_ba_marche on ba_marche (cost=0.13..0.15 rows=1 width=136) (actual time=0.014..0.014 rows=1 loops=3)

  • Index Cond: ((macodice)::text = (ba_artmod.arcodmar)::text)
32. 0.063 0.063 ↑ 1.0 1 3

Index Scan using pk_tc_artmod001 on tc_artmod001 tc_artmod (cost=0.28..0.31 rows=1 width=17) (actual time=0.021..0.021 rows=1 loops=3)

  • Index Cond: ((ba_artmod.arflgart = tcflgart) AND ((ba_artmod.arkeyart)::text = (tckeyart)::text))
33. 0.015 0.120 ↑ 1.0 1 3

Nested Loop Left Join (cost=0.41..7.79 rows=1 width=811) (actual time=0.036..0.040 rows=1 loops=3)

34. 0.069 0.069 ↑ 1.0 1 3

Index Scan using pk_cs_content_category on cs_content_category cs_content_category_1 (cost=0.27..7.49 rows=1 width=21) (actual time=0.020..0.023 rows=1 loops=3)

  • Index Cond: (gsec_fsearch_item.category = ccid)
35. 0.036 0.036 ↓ 0.0 0 3

Index Scan using l_pk_cs_content_cat_trans on cs_content_cat_trans (cost=0.14..0.22 rows=1 width=794) (actual time=0.012..0.012 rows=0 loops=3)

  • Index Cond: (cs_content_category_1.ccid = ctcategory)
  • Filter: ((ctlanguage)::text = 'ITA'::text)
36. 0.123 3.576 ↓ 10.0 10 3

Nested Loop Left Join (cost=1.19..12.66 rows=1 width=388) (actual time=0.186..1.192 rows=10 loops=3)

  • Join Filter: (((ec_catalog_def.ctsite)::text = (cs_page_translation.ptsite)::text) AND ((ec_catalog_def.ctpageart)::text = (cs_page_translation.ptpage)::text))
37. 0.054 3.303 ↓ 10.0 10 3

Nested Loop Left Join (cost=1.19..11.51 rows=1 width=572) (actual time=0.168..1.101 rows=10 loops=3)

38. 0.150 3.219 ↓ 10.0 10 3

Nested Loop (cost=1.04..11.04 rows=1 width=606) (actual time=0.160..1.073 rows=10 loops=3)

  • Join Filter: ((ec_catalog_def.ctcatalogid)::text = (ba_catalog_def.ctcatalogid)::text)
  • Rows Removed by Join Filter: 45
39. 0.222 2.949 ↓ 10.0 10 3

Nested Loop Left Join (cost=1.04..9.81 rows=1 width=606) (actual time=0.149..0.983 rows=10 loops=3)

  • Join Filter: ((ec_catalog_def.ctstore)::text = (ec_store.ststoreid)::text)
  • Rows Removed by Join Filter: 10
40. 0.057 0.057 ↓ 10.0 10 3

Seq Scan on ec_catalog_def001 ec_catalog_def (cost=0.00..1.13 rows=1 width=332) (actual time=0.012..0.019 rows=10 loops=3)

  • Filter: ((ctsite)::text = 'MET'::text)
41. 1.462 2.670 ↑ 1.0 2 30

Hash Right Join (cost=1.04..8.66 rows=2 width=348) (actual time=0.083..0.089 rows=2 loops=30)

  • Hash Cond: ((ba_caudoc.cdcodcau)::text = (ec_store.stcaudocpriv)::text)
42. 1.170 1.170 ↑ 1.0 116 30

Seq Scan on ba_caudoc (cost=0.00..7.16 rows=116 width=76) (actual time=0.003..0.039 rows=116 loops=30)

43. 0.020 0.038 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=272) (actual time=0.038..0.038 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
44. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on ec_store001 ec_store (cost=0.00..1.02 rows=2 width=272) (actual time=0.014..0.018 rows=2 loops=1)

45. 0.120 0.120 ↑ 1.7 6 30

Seq Scan on ba_catalog_def001 ba_catalog_def (cost=0.00..1.10 rows=10 width=70) (actual time=0.003..0.004 rows=6 loops=30)

46. 0.030 0.030 ↓ 0.0 0 30

Index Scan using pk_ba_spedoc001 on ba_spedoc001 ba_spedoc (cost=0.14..0.47 rows=1 width=42) (actual time=0.001..0.001 rows=0 loops=30)

  • Index Cond: ((ba_caudoc.cdcodcau)::text = (sdcaudoc)::text)
47. 0.150 0.150 ↓ 0.0 0 30

Seq Scan on cs_page_translation (cost=0.00..1.12 rows=1 width=334) (actual time=0.005..0.005 rows=0 loops=30)

  • Filter: (((ptlanguage)::text = 'ITA'::text) AND ((ptsite)::text = 'MET'::text))
  • Rows Removed by Filter: 8
48. 0.015 0.015 ↑ 1.0 1 3

Seq Scan on ba_unimis (cost=0.00..1.01 rows=1 width=126) (actual time=0.005..0.005 rows=1 loops=3)

49. 0.081 0.081 ↑ 1.0 1 3

Index Scan using pk_dm_vfiles on dm_vfiles (cost=0.29..8.31 rows=1 width=53) (actual time=0.027..0.027 rows=1 loops=3)

  • Index Cond: (gsec_fsearch_item.nciddoc = vfcodiceid)
50. 0.081 0.081 ↑ 1.0 1 3

Index Scan using pk_dm_vfolders on dm_vfolders (cost=0.28..0.30 rows=1 width=51) (actual time=0.027..0.027 rows=1 loops=3)

  • Index Cond: (dm_vfiles.vfparent = vfcodiceid)
51. 0.426 0.426 ↓ 0.0 0 3

Index Scan using ec_nav_cat_price0012 on ec_nav_cat_price001 ec_nav_cat_price (cost=0.42..15.57 rows=1 width=64) (actual time=0.142..0.142 rows=0 loops=3)

  • Index Cond: ((gsec_fsearch_item.arflgart = npflgart) AND ((gsec_fsearch_item.arkeyart)::text = (npkeyart)::text) AND (gsec_fsearch_item.nccategory = npcategory) AND ((npnationid)::text = 'ITA'::text))
  • Filter: (((COALESCE(tccodcol, '##########'::character varying))::text = ''::text) AND ((COALESCE(tcnumera, '##########'::character varying))::text = ''::text))
  • Rows Removed by Filter: 73
52. 0.069 0.069 ↓ 5.0 5 3

Seq Scan on ec_catalog_list001 ec_catalog_list (cost=0.00..4.13 rows=1 width=92) (actual time=0.016..0.023 rows=5 loops=3)

  • Filter: ((clnationid)::text = 'ITA'::text)
  • Rows Removed by Filter: 20
53. 0.036 0.036 ↑ 1.0 1 3

Index Scan using pk_cs_content_category on cs_content_category (cost=0.27..7.49 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=3)

  • Index Cond: (ccid = gsec_fsearch_item.category)
  • Filter: (ccnavig = 1)
54. 0.054 0.054 ↓ 0.0 0 3

Index Scan using l_pk_ec_favourite on ec_favourite (cost=0.14..1.02 rows=1 width=46) (actual time=0.018..0.018 rows=0 loops=3)

  • Index Cond: ((fauserid = 123) AND (ba_artico.arflgart = faflgart))
  • Filter: ((ba_artico.arkeyart)::text = (fakeyart)::text)
  • Rows Removed by Filter: 3
55. 0.036 0.036 ↓ 0.0 0 3

Index Only Scan using pk_ec_compare on ec_compare (cost=0.15..3.03 rows=1 width=42) (actual time=0.012..0.012 rows=0 loops=3)

  • Index Cond: ((cosessionid = 'bjvzsatxod'::text) AND (coflgart = ba_artico.arflgart) AND (cokeyart = (ba_artico.arkeyart)::text))
  • Heap Fetches: 0
56. 0.024 0.024 ↓ 0.0 0 3

Index Scan using pk_ec_nav_cat_attrib001 on ec_nav_cat_attrib001 ec_nav_cat_attrib (cost=0.15..3.03 rows=1 width=86) (actual time=0.008..0.008 rows=0 loops=3)

  • Index Cond: (((ba_artico.arflgart)::numeric = naflgart) AND ((ba_artico.arkeyart)::text = (nakeyart)::text) AND ((nalang)::text = 'ITA'::text))
57. 9.078 726.840 ↓ 328.0 328 3

GroupAggregate (cost=116,885.03..116,885.06 rows=1 width=178) (actual time=238.656..242.280 rows=328 loops=3)

  • Group Key: zcme_przclisite.pztipsog, zcme_przclisite.pzcodsog, zcme_przclisite.pzflgart, zcme_przclisite.pzkeyart, tc_cattco.ctcodcat
58. 17.921 717.762 ↓ 2,862.0 2,862 3

Sort (cost=116,885.03..116,885.03 rows=1 width=166) (actual time=238.625..239.254 rows=2,862 loops=3)

  • Sort Key: zcme_przclisite.pzflgart, zcme_przclisite.pzkeyart, tc_cattco.ctcodcat
  • Sort Method: quicksort Memory: 320kB
59. 87.647 699.841 ↓ 2,862.0 2,862 1

Gather (cost=1,000.29..116,885.02 rows=1 width=166) (actual time=446.188..699.841 rows=2,862 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
60. 44.979 612.194 ↓ 954.0 954 3

Nested Loop (cost=0.29..115,884.92 rows=1 width=166) (actual time=359.823..612.194 rows=954 loops=3)

61. 567.044 567.044 ↓ 3.9 257 3

Parallel Seq Scan on zcme_przclisite (cost=0.00..115,474.15 rows=66 width=204) (actual time=359.542..567.044 rows=257 loops=3)

  • Filter: ((pzprezzo <> '0'::numeric) AND ((pztipsog)::text = 'CLI'::text) AND ((pzcodsog)::text = 'RIV_ITA'::text))
  • Rows Removed by Filter: 464701
62. 0.171 0.171 ↓ 4.0 4 772

Index Scan using tc_cattco0012 on tc_cattco001 tc_cattco (cost=0.29..6.21 rows=1 width=156) (actual time=0.050..0.171 rows=4 loops=772)

  • Index Cond: ((ctflgart = zcme_przclisite.pzflgart) AND ((ctkeyart)::text = (zcme_przclisite.pzkeyart)::text))
  • Filter: (((zcme_przclisite.pzcolore)::text = (ctcolore)::text) AND ((zcme_przclisite.pztaglia)::text = (cttaglia)::text))
  • Rows Removed by Filter: 240
Planning time : 113.410 ms
Execution time : 764.848 ms