explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nT7B : v_product_overview_sizeset_approval

Settings
# exclusive inclusive rows x rows loops node
1. 131.555 126,258.195 ↓ 695.5 1,391 1

Nested Loop (cost=16.84..187,869.33 rows=2 width=621) (actual time=185.054..126,258.195 rows=1,391 loops=1)

2. 0.048 0.048 ↑ 1.0 1 1

Seq Scan on dblanguage lang (cost=0.00..3.10 rows=1 width=8) (actual time=0.025..0.048 rows=1 loops=1)

  • Filter: (((languageisocode)::text = ANY ('{en,de}'::text[])) AND ((languageisocode)::text = 'en'::text))
  • Rows Removed by Filter: 139
3. 5.271 1,522.372 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=16.84..67,559.43 rows=2 width=613) (actual time=8.690..1,522.372 rows=1,391 loops=1)

4. 4.146 1,508.755 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=16.70..67,559.08 rows=2 width=610) (actual time=8.677..1,508.755 rows=1,391 loops=1)

5. 4.165 1,472.616 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=16.27..67,542.17 rows=2 width=565) (actual time=8.629..1,472.616 rows=1,391 loops=1)

6. 4.338 1,462.887 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=16.14..67,541.60 rows=2 width=568) (actual time=8.615..1,462.887 rows=1,391 loops=1)

7. 4.155 1,450.203 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.85..67,540.86 rows=2 width=547) (actual time=8.603..1,450.203 rows=1,391 loops=1)

8. 140.099 1,441.875 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.70..67,540.51 rows=2 width=523) (actual time=8.591..1,441.875 rows=1,391 loops=1)

  • Join Filter: (sc.seasonclientid = s.seasonclientid)
  • Rows Removed by Join Filter: 815126
9. 5.516 1,257.264 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.70..67,509.57 rows=2 width=517) (actual time=8.105..1,257.264 rows=1,391 loops=1)

  • Join Filter: (s.clientid = d.clientid)
10. 4.238 1,242.011 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.42..67,500.12 rows=2 width=503) (actual time=8.079..1,242.011 rows=1,391 loops=1)

11. 4.057 1,232.209 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.27..67,499.29 rows=2 width=479) (actual time=8.071..1,232.209 rows=1,391 loops=1)

12. 409.526 1,217.024 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.98..67,484.76 rows=2 width=466) (actual time=8.053..1,217.024 rows=1,391 loops=1)

  • Join Filter: (sm.smsizerangeid = sr.smsizerangeid)
  • Rows Removed by Join Filter: 2484424
13. 3.191 686.481 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.98..67,394.81 rows=2 width=467) (actual time=7.669..686.481 rows=1,391 loops=1)

14. 4.679 676.335 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.84..67,394.47 rows=2 width=467) (actual time=7.650..676.335 rows=1,391 loops=1)

15. 3.713 664.701 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.69..67,394.12 rows=2 width=467) (actual time=7.631..664.701 rows=1,391 loops=1)

16. 3.224 637.341 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.27..67,392.83 rows=2 width=452) (actual time=7.602..637.341 rows=1,391 loops=1)

17. 75.354 632.726 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=13.84..67,391.70 rows=2 width=445) (actual time=7.599..632.726 rows=1,391 loops=1)

18. 1.368 544.853 ↓ 695.5 1,391 1

Nested Loop (cost=0.42..67,348.90 rows=2 width=302) (actual time=7.483..544.853 rows=1,391 loops=1)

19. 0.060 0.060 ↑ 1.0 1 1

Seq Scan on dbclient c (cost=0.00..3.82 rows=1 width=12) (actual time=0.054..0.060 rows=1 loops=1)

  • Filter: ((clientid = 2041999::numeric) AND (clientid = ANY ('{8731597,2042000,14638,5234784780,2042001,2041999}'::numeric[])))
  • Rows Removed by Filter: 90
20. 7.330 543.425 ↓ 695.5 1,391 1

Nested Loop (cost=0.42..67,345.06 rows=2 width=290) (actual time=7.426..543.425 rows=1,391 loops=1)

21. 502.711 502.711 ↓ 14.1 1,391 1

Seq Scan on dbsmstylesupplier ss (cost=0.00..66,511.52 rows=99 width=176) (actual time=7.371..502.711 rows=1,391 loops=1)

  • Filter: (((proposalstatus IS NULL) OR ((proposalstatus)::text <> 'DRAFT'::text)) AND (createdby_date >= '2018-04-01 00:00:00'::timestamp without time zone) AND (createdby_date <= '2018-12-31 23:59:59'::timestamp without time zone) AND (iscancelled = 0) AND (keyfield3 = 5394904599::numeric))
  • Rows Removed by Filter: 1342568
22. 33.384 33.384 ↑ 1.0 1 1,391

Index Scan using pk_smstyle on dbsmstyle s (cost=0.42..8.41 rows=1 width=122) (actual time=0.023..0.024 rows=1 loops=1,391)

  • Index Cond: (smstyleid = ss.smstyleid)
  • Filter: ((istemplate = 0) AND (clientid = 2041999::numeric))
23. 0.000 12.519 ↑ 1.0 1 1,391

Index Scan using ixpk_smsampleevalpage01 on dbsmsampleevalpage se (cost=13.41..21.39 rows=1 width=143) (actual time=0.008..0.009 rows=1 loops=1,391)

  • Index Cond: (smsampleevalpageid = (SubPlan 46))
24.          

SubPlan (for Index Scan)

25. 4.173 65.377 ↑ 1.0 1 1,391

Limit (cost=12.99..12.99 rows=1 width=16) (actual time=0.047..0.047 rows=1 loops=1,391)

26. 22.256 61.204 ↑ 3.0 1 1,391

Sort (cost=12.99..12.99 rows=3 width=16) (actual time=0.044..0.044 rows=1 loops=1,391)

  • Sort Key: dbsmsampleevalpage.samplingby_date
  • Sort Method: top-N heapsort Memory: 25kB
27. 38.948 38.948 ↓ 1.3 4 1,391

Index Scan using fk_smplvlpg_stls_1435 on dbsmsampleevalpage (cost=0.42..12.97 rows=3 width=16) (actual time=0.015..0.028 rows=4 loops=1,391)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
28. 4.173 65.377 ↑ 1.0 1 1,391

Limit (cost=12.99..12.99 rows=1 width=16) (actual time=0.047..0.047 rows=1 loops=1,391)

29. 22.256 61.204 ↑ 3.0 1 1,391

Sort (cost=12.99..12.99 rows=3 width=16) (actual time=0.044..0.044 rows=1 loops=1,391)

  • Sort Key: dbsmsampleevalpage.samplingby_date
  • Sort Method: top-N heapsort Memory: 25kB
30. 38.948 38.948 ↓ 1.3 4 1,391

Index Scan using fk_smplvlpg_stls_1435 on dbsmsampleevalpage (cost=0.42..12.97 rows=3 width=16) (actual time=0.015..0.028 rows=4 loops=1,391)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
31. 1.391 1.391 ↓ 0.0 0 1,391

Index Scan using pk_stlstcpnnt on dbsmstylesetcomponent ssc (cost=0.43..0.55 rows=1 width=15) (actual time=0.001..0.001 rows=0 loops=1,391)

  • Index Cond: (se.smstylesetcomponentid = smstylesetcomponentid)
32. 23.647 23.647 ↑ 1.0 1 1,391

Index Scan using pk_stmsmnt on dbsmstylemeasurement sm (cost=0.43..0.63 rows=1 width=23) (actual time=0.016..0.017 rows=1 loops=1,391)

  • Index Cond: (se.smstylemeasurementid = smstylemeasurementid)
33. 6.955 6.955 ↑ 1.0 1 1,391

Index Only Scan using pk_sampletype on dbsmsampletype sty (cost=0.14..0.16 rows=1 width=9) (actual time=0.005..0.005 rows=1 loops=1,391)

  • Index Cond: (smsampletypeid = se.smsampletypeid)
  • Heap Fetches: 1295
34. 6.955 6.955 ↑ 1.0 1 1,391

Index Only Scan using pk_vltnstts on dbsmevaluationstatus sta (cost=0.14..0.16 rows=1 width=9) (actual time=0.003..0.005 rows=1 loops=1,391)

  • Index Cond: (smevaluationstatusid = se.smevaluatuinstatusid)
  • Heap Fetches: 1295
35. 120.565 121.017 ↑ 1.0 1,787 1,391

Materialize (cost=0.00..40.80 rows=1,787 width=8) (actual time=0.000..0.087 rows=1,787 loops=1,391)

36. 0.452 0.452 ↑ 1.0 1,787 1

Seq Scan on dbsmsizerange sr (cost=0.00..31.87 rows=1,787 width=8) (actual time=0.017..0.452 rows=1,787 loops=1)

37. 11.128 11.128 ↑ 1.0 1 1,391

Index Scan using pk_clients on dbclientsupplier cs (cost=0.29..7.26 rows=1 width=29) (actual time=0.007..0.008 rows=1 loops=1,391)

  • Index Cond: (ss.clientsupplierid = clientsupplierid)
38. 5.564 5.564 ↑ 1.0 1 1,391

Index Scan using pk_office on dboffice o2 (cost=0.14..0.40 rows=1 width=31) (actual time=0.004..0.004 rows=1 loops=1,391)

  • Index Cond: (ss.clientofficeid = officeid)
39. 9.737 9.737 ↑ 1.0 1 1,391

Index Scan using pk_department on dbdepartment d (cost=0.29..4.71 rows=1 width=29) (actual time=0.006..0.007 rows=1 loops=1,391)

  • Index Cond: (ss.departmentid = departmentid)
  • Filter: (clientid = 2041999::numeric)
40. 44.322 44.512 ↑ 1.0 587 1,391

Materialize (cost=0.00..14.81 rows=587 width=14) (actual time=0.000..0.032 rows=587 loops=1,391)

41. 0.190 0.190 ↑ 1.0 587 1

Seq Scan on dbseasonclient sc (cost=0.00..11.87 rows=587 width=14) (actual time=0.006..0.190 rows=587 loops=1)

42. 4.173 4.173 ↑ 1.0 1 1,391

Index Scan using pk_office on dboffice o1 (cost=0.14..0.16 rows=1 width=31) (actual time=0.002..0.003 rows=1 loops=1,391)

  • Index Cond: (cs.officeid = officeid)
43. 8.346 8.346 ↑ 1.0 1 1,391

Index Scan using pk_supplier on dbsupplier p (cost=0.29..0.36 rows=1 width=29) (actual time=0.005..0.006 rows=1 loops=1,391)

  • Index Cond: (cs.supplierid = supplierid)
44. 5.564 5.564 ↑ 1.0 1 1,391

Index Scan using pk_sstatus on dbsmsupplierstatus sst (cost=0.14..0.27 rows=1 width=15) (actual time=0.003..0.004 rows=1 loops=1,391)

  • Index Cond: (ss.smsupplierstatusid = smsupplierstatusid)
45. 31.993 31.993 ↑ 1.0 1 1,391

Index Scan using pk_smstylesupplieriteminfo on dbsmstylesupplieriteminfo ssi (cost=0.43..8.45 rows=1 width=53) (actual time=0.022..0.023 rows=1 loops=1,391)

  • Index Cond: (ss.smstylesupplierid = smstylesupplierid)
46. 8.346 8.346 ↑ 1.0 1 1,391

Index Scan using pk_smosidentification on dbsmosidentification oi (cost=0.14..0.16 rows=1 width=12) (actual time=0.004..0.006 rows=1 loops=1,391)

  • Index Cond: (s.osidentification = smosidentificationid)
47.          

SubPlan (for Nested Loop)

48. 25.002 25.038 ↑ 13.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18n (cost=3.32..43.78 rows=13 width=24) (actual time=0.017..0.018 rows=1 loops=1,391)

  • Index Cond: ((rid = oi.smosidentificationid) AND (languageid = $1) AND ((descriptionkey)::text = 'Description'::text))
49.          

Initplan (for Index Scan)

50. 0.036 0.036 ↑ 1.0 1 1

Seq Scan on dblanguage (cost=0.00..2.75 rows=1 width=6) (actual time=0.013..0.036 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
51. 6.920 29.211 ↑ 13.0 1 1,391

Nested Loop (cost=3.59..52.20 rows=13 width=27) (actual time=0.020..0.021 rows=1 loops=1,391)

52.          

Initplan (for Nested Loop)

53. 0.035 0.035 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_1 (cost=0.00..2.75 rows=1 width=6) (actual time=0.011..0.035 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
54. 6.955 6.955 ↑ 1.0 1 1,391

Index Scan using pk_smassortmt on dbsmassortment a (cost=0.27..8.29 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=1,391)

  • Index Cond: (smassortmentid = s.smassortmentid)
55. 15.301 15.301 ↑ 13.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18 (cost=0.57..40.96 rows=13 width=32) (actual time=0.010..0.011 rows=1 loops=1,391)

  • Index Cond: ((rid = s.smassortmentid) AND (languageid = $3) AND ((descriptionkey)::text = 'Description'::text))
56. 5.528 23.647 ↑ 13.0 1 1,391

Nested Loop (cost=3.59..52.20 rows=13 width=26) (actual time=0.017..0.017 rows=1 loops=1,391)

57.          

Initplan (for Nested Loop)

58. 0.036 0.036 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_2 (cost=0.00..2.75 rows=1 width=6) (actual time=0.012..0.036 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
59. 6.955 6.955 ↑ 1.0 1 1,391

Index Scan using pk_smasmtsubg on dbsmassortmentsubgroup ag (cost=0.28..8.29 rows=1 width=11) (actual time=0.005..0.005 rows=1 loops=1,391)

  • Index Cond: (smassortmentsubgroupid = s.smassortmentsubgroupid)
60. 11.128 11.128 ↑ 13.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_1 (cost=0.57..40.96 rows=13 width=32) (actual time=0.007..0.008 rows=1 loops=1,391)

  • Index Cond: ((rid = s.smassortmentsubgroupid) AND (languageid = $5) AND ((descriptionkey)::text = 'Description'::text))
61. 6.919 25.038 ↑ 13.0 1 1,391

Nested Loop (cost=3.60..52.21 rows=13 width=28) (actual time=0.017..0.018 rows=1 loops=1,391)

62.          

Initplan (for Nested Loop)

63. 0.036 0.036 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_3 (cost=0.00..2.75 rows=1 width=6) (actual time=0.012..0.036 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
64. 6.955 6.955 ↑ 1.0 1 1,391

Index Scan using pk_smprodgrp on dbsmproductgroup p_1 (cost=0.28..8.30 rows=1 width=13) (actual time=0.005..0.005 rows=1 loops=1,391)

  • Index Cond: (smproductgroupid = s.smproductgroupid)
65. 11.128 11.128 ↑ 13.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_2 (cost=0.57..40.96 rows=13 width=32) (actual time=0.008..0.008 rows=1 loops=1,391)

  • Index Cond: ((rid = s.smproductgroupid) AND (languageid = $7) AND ((descriptionkey)::text = 'Description'::text))
66. 11.128 11.128 ↑ 1.0 1 1,391

Index Scan using pk_ldpsrmppng on dbldapusermapping ldapuserm (cost=0.29..8.31 rows=1 width=28) (actual time=0.008..0.008 rows=1 loops=1,391)

  • Index Cond: (ldapusermappingid = ss.responsibleid)
67. 7.650 7.650 ↑ 1.0 1 1,275

Index Scan using pk_ldpsrmppng on dbldapusermapping ldapuserm_1 (cost=0.29..8.31 rows=1 width=28) (actual time=0.006..0.006 rows=1 loops=1,275)

  • Index Cond: (ldapusermappingid = ss.marketqaldapusermappingid)
68. 6.920 41.730 ↑ 13.0 1 1,391

Nested Loop (cost=3.32..45.62 rows=13 width=24) (actual time=0.026..0.030 rows=1 loops=1,391)

69.          

Initplan (for Nested Loop)

70. 0.035 0.035 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_4 (cost=0.00..2.75 rows=1 width=6) (actual time=0.012..0.035 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
71. 19.474 19.474 ↑ 1.0 1 1,391

Seq Scan on dbsmkeyfield3 dkf (cost=0.00..1.77 rows=1 width=9) (actual time=0.011..0.014 rows=1 loops=1,391)

  • Filter: (smkeyfieldid = ss.keyfield3)
  • Rows Removed by Filter: 61
72. 15.301 15.301 ↑ 13.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_3 (cost=0.57..40.96 rows=13 width=32) (actual time=0.010..0.011 rows=1 loops=1,391)

  • Index Cond: ((rid = ss.keyfield3) AND (languageid = $11) AND ((descriptionkey)::text = 'Description'::text))
73. 13.877 13.910 ↑ 13.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_4 (cost=3.32..43.71 rows=13 width=24) (actual time=0.009..0.010 rows=1 loops=1,391)

  • Index Cond: ((rid = sta.smevaluationstatusid) AND (languageid = $13) AND ((descriptionkey)::text = 'Description'::text))
74.          

Initplan (for Index Scan)

75. 0.033 0.033 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_5 (cost=0.00..2.75 rows=1 width=6) (actual time=0.011..0.033 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
76. 12.485 12.519 ↑ 13.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_5 (cost=3.32..43.71 rows=13 width=24) (actual time=0.009..0.009 rows=1 loops=1,391)

  • Index Cond: ((rid = sty.smsampletypeid) AND (languageid = $15) AND ((descriptionkey)::text = 'Description'::text))
77.          

Initplan (for Index Scan)

78. 0.034 0.034 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_6 (cost=0.00..2.75 rows=1 width=6) (actual time=0.011..0.034 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
79. 12.930 12.930 ↑ 39.0 1 1,293

Index Scan using pk_18ndscrptn on dbi18ndescription i18_6 (cost=0.57..111.10 rows=39 width=24) (actual time=0.010..0.010 rows=1 loops=1,293)

  • Index Cond: ((rid = sr.smsizerangeid) AND (languageid = 3064863::numeric) AND ((descriptionkey)::text = 'Description'::text))
80. 2.762 24,809.876 ↓ 0.0 0 1,391

Hash Join (cost=520.01..6,517.90 rows=17 width=22) (actual time=17.562..17.836 rows=0 loops=1,391)

  • Hash Cond: ((sre.proc_def_id_)::text = (srp.id_)::text)
81. 12.054 24,807.094 ↑ 113.0 1 1,391

Nested Loop (cost=518.64..6,515.94 rows=113 width=27) (actual time=14.394..17.834 rows=1 loops=1,391)

82. 20,080.476 24,777.883 ↑ 113.0 1 1,391

Bitmap Heap Scan on act_ru_variable srv (cost=518.35..5,707.78 rows=113 width=7) (actual time=14.378..17.813 rows=1 loops=1,391)

  • Recheck Cond: ((name_)::text = 'productId'::text)
  • Filter: ((long_)::numeric = ss.smstylesupplierid)
  • Rows Removed by Filter: 23198
  • Heap Blocks: exact=6667063
83. 4,697.407 4,697.407 ↓ 1.0 23,199 1,391

Bitmap Index Scan on act_idx_var_name (cost=0.00..518.32 rows=22,653 width=0) (actual time=3.377..3.377 rows=23,199 loops=1,391)

  • Index Cond: ((name_)::text = 'productId'::text)
84. 17.157 17.157 ↑ 1.0 1 903

Index Scan using act_ru_execution_pkey on act_ru_execution sre (cost=0.29..7.14 rows=1 width=34) (actual time=0.018..0.019 rows=1 loops=903)

  • Index Cond: ((id_)::text = (srv.execution_id_)::text)
85. 0.007 0.020 ↑ 1.0 4 1

Hash (cost=1.32..1.32 rows=4 width=22) (actual time=0.020..0.020 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
86. 0.013 0.013 ↑ 1.0 4 1

Seq Scan on act_re_procdef srp (cost=0.00..1.32 rows=4 width=22) (actual time=0.011..0.013 rows=4 loops=1)

  • Filter: ((key_)::text = 'SizeSetSampleApproval'::text)
  • Rows Removed by Filter: 22
87. 2.741 2.782 ↓ 0.0 0 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_7 (cost=3.32..43.74 rows=13 width=24) (actual time=0.002..0.002 rows=0 loops=1,391)

  • Index Cond: ((rid = se.smconclusionid) AND (languageid = $20) AND ((descriptionkey)::text = 'Description'::text))
88.          

Initplan (for Index Scan)

89. 0.041 0.041 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_7 (cost=0.00..2.75 rows=1 width=6) (actual time=0.018..0.041 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
90. 5.564 11.128 ↓ 0.0 0 1,391

Nested Loop (cost=3.32..44.94 rows=13 width=24) (actual time=0.008..0.008 rows=0 loops=1,391)

91.          

Initplan (for Nested Loop)

92. 0.000 0.000 ↓ 0.0 0

Seq Scan on dblanguage dblanguage_8 (cost=0.00..2.75 rows=1 width=6) (never executed)

  • Filter: ((languageisocode)::text = 'en'::text)
93. 5.564 5.564 ↓ 0.0 0 1,391

Seq Scan on dbsmtimeline dtl (cost=0.00..1.10 rows=1 width=9) (actual time=0.004..0.004 rows=0 loops=1,391)

  • Filter: (smtimelineid = s.timeline)
  • Rows Removed by Filter: 8
94. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_8 (cost=0.57..40.96 rows=13 width=32) (never executed)

  • Index Cond: ((rid = s.timeline) AND (languageid = $22) AND ((descriptionkey)::text = 'Description'::text))
95. 22.256 22.256 ↑ 1.0 1 1,391

Seq Scan on dbsmffpdecision ffpd (cost=0.00..2.08 rows=1 width=2) (actual time=0.010..0.016 rows=1 loops=1,391)

  • Filter: (smffpdecisionid = ss.ffpdecision)
  • Rows Removed by Filter: 85
96. 2.975 40.339 ↑ 13.0 1 1,391

Nested Loop (cost=3.32..45.92 rows=13 width=24) (actual time=0.021..0.029 rows=1 loops=1,391)

97.          

Initplan (for Nested Loop)

98. 0.035 0.035 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_9 (cost=0.00..2.75 rows=1 width=6) (actual time=0.012..0.035 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
99. 20.865 20.865 ↑ 1.0 1 1,391

Seq Scan on dbsmffpdecision ffpd_1 (cost=0.00..2.08 rows=1 width=9) (actual time=0.008..0.015 rows=1 loops=1,391)

  • Filter: (smffpdecisionid = ss.ffpdecision)
  • Rows Removed by Filter: 85
100. 16.464 16.464 ↑ 13.0 1 1,029

Index Scan using pk_18ndscrptn on dbi18ndescription i18_9 (cost=0.57..40.96 rows=13 width=32) (actual time=0.015..0.016 rows=1 loops=1,029)

  • Index Cond: ((rid = ss.ffpdecision) AND (languageid = $25) AND ((descriptionkey)::text = 'Description'::text))
101. 2.782 41.730 ↑ 1.0 1 1,391

Limit (cost=0.43..3.59 rows=1 width=4) (actual time=0.030..0.030 rows=1 loops=1,391)

102. 38.948 38.948 ↑ 74.0 1 1,391

Index Scan using ixfk_smsku04 on dbsmsku sku (cost=0.43..233.86 rows=74 width=4) (actual time=0.028..0.028 rows=1 loops=1,391)

  • Index Cond: (smstyleid = s.smstyleid)
  • Filter: (isekrdelete <> 99::numeric)
103. 1.391 11.128 ↑ 1.0 1 1,391

Limit (cost=0.43..3.59 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1,391)

104. 9.737 9.737 ↑ 74.0 1 1,391

Index Scan using ixfk_smsku04 on dbsmsku sku_1 (cost=0.43..233.86 rows=74 width=16) (actual time=0.007..0.007 rows=1 loops=1,391)

  • Index Cond: (smstyleid = s.smstyleid)
  • Filter: (isekrdelete <> 99::numeric)
105. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=25.01..25.03 rows=1 width=14) (never executed)

  • Group Key: (((u.surname)::text || ', '::text) || (u.givenname)::text)
106. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..25.01 rows=1 width=14) (never executed)

  • Join Filter: ((auc.userid)::text = (u.ldapuid)::text)
107. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..16.90 rows=1 width=40) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixauthuser9006 on dbauthuser90 auc (cost=0.42..8.44 rows=1 width=20) (never executed)

  • Index Cond: ((ldapfunction = 'ap.ext'::text) AND (oidcolumn = 'ClientID'::text) AND (actorid = s.clientid))
  • Heap Fetches: 0
109. 0.000 0.000 ↓ 0.0 0

Index Scan using ixauthuser9005 on dbauthuser90 auf (cost=0.42..8.45 rows=1 width=20) (never executed)

  • Index Cond: (((userid)::text = (auc.userid)::text) AND ((ldapfunction)::text = 'ap.isbuyer'::text))
  • Filter: (((ldapfunction)::text ~~ 'ap.is%'::text) AND ((oidcolumn)::text = 'SIMPLEFUNCTION'::text))
110. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_ldapusermapping on dbldapusermapping u (cost=0.29..8.09 rows=1 width=28) (never executed)

  • Index Cond: ((ldapuid)::text = (auf.userid)::text)
  • Filter: ((isactive = 1::numeric) AND (ldapusermappingid = ss.buyerid))
111. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=25.01..25.03 rows=1 width=14) (never executed)

  • Group Key: (((u_1.surname)::text || ', '::text) || (u_1.givenname)::text)
112. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..25.01 rows=1 width=14) (never executed)

  • Join Filter: ((auc_1.userid)::text = (u_1.ldapuid)::text)
113. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..16.90 rows=1 width=40) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixauthuser9006 on dbauthuser90 auc_1 (cost=0.42..8.44 rows=1 width=20) (never executed)

  • Index Cond: ((ldapfunction = 'ap.ext'::text) AND (oidcolumn = 'ClientID'::text) AND (actorid = s.clientid))
  • Heap Fetches: 0
115. 0.000 0.000 ↓ 0.0 0

Index Scan using ixauthuser9005 on dbauthuser90 auf_1 (cost=0.42..8.45 rows=1 width=20) (never executed)

  • Index Cond: (((userid)::text = (auc_1.userid)::text) AND ((ldapfunction)::text = 'ap.isbuyer'::text))
  • Filter: (((ldapfunction)::text ~~ 'ap.is%'::text) AND ((oidcolumn)::text = 'SIMPLEFUNCTION'::text))
116. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_ldapusermapping on dbldapusermapping u_1 (cost=0.29..8.09 rows=1 width=28) (never executed)

  • Index Cond: ((ldapuid)::text = (auf_1.userid)::text)
  • Filter: ((isactive = 1::numeric) AND (ldapusermappingid = ss.buyerid2))
117. 2.782 7,473.843 ↓ 0.0 0 1,391

HashAggregate (cost=1,224.14..44,105.54 rows=10 width=15) (actual time=5.373..5.373 rows=0 loops=1,391)

  • Group Key: st.smstylesupplierid, l.languageid
118. 4.173 7,471.061 ↓ 0.0 0 1,391

Nested Loop (cost=0.57..1,224.07 rows=13 width=15) (actual time=5.371..5.371 rows=0 loops=1,391)

119. 33.384 33.384 ↑ 1.0 1 1,391

Seq Scan on dblanguage la (cost=0.00..2.75 rows=1 width=6) (actual time=0.009..0.024 rows=1 loops=1,391)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
120. 2.782 7,433.504 ↓ 0.0 0 1,391

Nested Loop (cost=0.57..1,219.24 rows=208 width=15) (actual time=5.344..5.344 rows=0 loops=1,391)

121. 7,430.722 7,430.722 ↓ 0.0 0 1,391

Seq Scan on dbsmentitystatus st (cost=0.00..576.51 rows=13 width=17) (actual time=5.342..5.342 rows=0 loops=1,391)

  • Filter: (smstylesupplierid = ss.smstylesupplierid)
  • Rows Removed by Filter: 27641
122. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_18ndscrptn on dbi18ndescription l (cost=0.57..49.28 rows=16 width=15) (never executed)

  • Index Cond: ((rid = st.smstatusid) AND (languageid = la.languageid))
  • Heap Fetches: 0
123.          

SubPlan (for HashAggregate)

124. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,400.64..1,402.71 rows=207 width=24) (never executed)

  • Group Key: lang_1.description
125. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.44..1,400.12 rows=207 width=24) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..757.92 rows=13 width=9) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..686.56 rows=13 width=17) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbsmentitystatus es (cost=0.00..576.51 rows=13 width=17) (never executed)

  • Filter: (smstylesupplierid = st.smstylesupplierid)
129. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_stlssku on dbsmstylesuppliersku ssk (cost=0.43..8.46 rows=1 width=16) (never executed)

  • Index Cond: (smstylesupplierskuid = es.smstylesupplierskuid)
130. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixpk_dbsmsku on dbsmsku sk (cost=0.43..5.48 rows=1 width=8) (never executed)

  • Index Cond: (smskuid = ssk.smskuid)
  • Heap Fetches: 0
131. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription lang_1 (cost=0.57..49.24 rows=16 width=32) (never executed)

  • Index Cond: ((rid = es.smstatusid) AND (languageid = l.languageid))
132. 0.000 0.000 ↓ 0.0 0

Group (cost=1,479.59..1,482.70 rows=207 width=41) (never executed)

  • Group Key: sk_1.itemno, sc_1.description, lang_1_1.description
133. 0.000 0.000 ↓ 0.0 0

Sort (cost=1,479.59..1,480.11 rows=207 width=41) (never executed)

  • Sort Key: sk_1.itemno, sc_1.description, lang_1_1.description
134. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.87..1,471.63 rows=207 width=41) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.30..829.42 rows=13 width=26) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..758.42 rows=13 width=25) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..686.56 rows=13 width=17) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbsmentitystatus es_1 (cost=0.00..576.51 rows=13 width=17) (never executed)

  • Filter: (smstylesupplierid = st.smstylesupplierid)
139. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_stlssku on dbsmstylesuppliersku ssk_1 (cost=0.43..8.46 rows=1 width=16) (never executed)

  • Index Cond: (smstylesupplierskuid = es_1.smstylesupplierskuid)
140. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_dbsmsku on dbsmsku sk_1 (cost=0.43..5.52 rows=1 width=24) (never executed)

  • Index Cond: (smskuid = ssk_1.smskuid)
141. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_dbsmstylecolor on dbsmstylecolor sc_1 (cost=0.43..5.45 rows=1 width=17) (never executed)

  • Index Cond: (sk_1.smstylecolourid = smstylecolorid)
142. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription lang_1_1 (cost=0.57..49.24 rows=16 width=32) (never executed)

  • Index Cond: ((rid = es_1.smstatusid) AND (languageid = l.languageid))
143. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,400.64..1,402.71 rows=207 width=24) (never executed)

  • Group Key: lang_1_2.description
144. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.44..1,400.12 rows=207 width=24) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..757.92 rows=13 width=9) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..686.56 rows=13 width=17) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbsmentitystatus es_2 (cost=0.00..576.51 rows=13 width=17) (never executed)

  • Filter: (smstylesupplierid = st.smstylesupplierid)
148. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_stlssku on dbsmstylesuppliersku ssk_2 (cost=0.43..8.46 rows=1 width=16) (never executed)

  • Index Cond: (smstylesupplierskuid = es_2.smstylesupplierskuid)
149. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixpk_dbsmsku on dbsmsku sk_2 (cost=0.43..5.48 rows=1 width=8) (never executed)

  • Index Cond: (smskuid = ssk_2.smskuid)
  • Heap Fetches: 0
150. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription lang_1_2 (cost=0.57..49.24 rows=16 width=32) (never executed)

  • Index Cond: ((rid = es_2.smstatusid) AND (languageid = l.languageid))
151. 5.564 488.241 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..402.57 rows=1 width=24) (actual time=0.351..0.351 rows=0 loops=1,391)

152. 30.602 30.602 ↑ 1.0 1 1,391

Seq Scan on dblanguage l_2 (cost=0.00..2.75 rows=1 width=6) (actual time=0.007..0.022 rows=1 loops=1,391)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
153. 1.391 452.075 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..399.69 rows=13 width=31) (actual time=0.325..0.325 rows=0 loops=1,391)

154. 1.391 450.684 ↓ 0.0 0 1,391

Nested Loop (cost=2.13..358.54 rows=1 width=8) (actual time=0.324..0.324 rows=0 loops=1,391)

155. 0.000 449.293 ↓ 0.0 0 1,391

Nested Loop (cost=1.70..352.69 rows=1 width=8) (actual time=0.323..0.323 rows=0 loops=1,391)

156. 2.782 449.293 ↓ 0.0 0 1,391

Nested Loop (cost=1.14..344.09 rows=1 width=16) (actual time=0.323..0.323 rows=0 loops=1,391)

157. 10.422 446.511 ↓ 0.0 0 1,391

Nested Loop (cost=0.70..334.92 rows=1 width=16) (actual time=0.321..0.321 rows=0 loops=1,391)

  • Join Filter: ((SubPlan 34) = p_3.editdate)
  • Rows Removed by Join Filter: 2
158. 20.865 20.865 ↑ 1.0 1 1,391

Index Scan using fk_pdpage_stls on dbpdpage p_3 (cost=0.42..8.44 rows=1 width=24) (actual time=0.014..0.015 rows=1 loops=1,391)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
159. 19.908 19.908 ↓ 2.0 2 1,422

Index Scan using ix_xmlname on dbpdattribute at_1 (cost=0.28..8.30 rows=1 width=22) (actual time=0.013..0.014 rows=2 loops=1,422)

  • Index Cond: ((xmlname)::text = 'attr_status_care_label'::text)
160.          

SubPlan (for Nested Loop)

161. 2.844 395.316 ↑ 1.0 1 2,844

Aggregate (cost=318.16..318.17 rows=1 width=8) (actual time=0.139..0.139 rows=1 loops=2,844)

162. 2.734 392.472 ↓ 0.0 0 2,844

Hash Join (cost=6.85..317.86 rows=117 width=8) (actual time=0.138..0.138 rows=0 loops=2,844)

  • Hash Cond: (i.languageid = l_1.languageid)
163. 2.844 389.628 ↓ 0.0 0 2,844

Nested Loop (cost=2.70..312.10 rows=117 width=15) (actual time=0.137..0.137 rows=0 loops=2,844)

164. 0.000 386.784 ↓ 0.0 0 2,844

Nested Loop (cost=2.13..126.47 rows=1 width=16) (actual time=0.136..0.136 rows=0 loops=2,844)

165. 8.532 386.784 ↓ 0.0 0 2,844

Nested Loop (cost=1.70..120.62 rows=1 width=16) (actual time=0.136..0.136 rows=0 loops=2,844)

166. 25.596 25.596 ↓ 2.0 2 2,844

Index Scan using ix_xmlname on dbpdattribute at (cost=0.28..8.30 rows=1 width=8) (actual time=0.008..0.009 rows=2 loops=2,844)

  • Index Cond: ((xmlname)::text = (at_1.xmlname)::text)
167. 25.928 352.656 ↓ 0.0 0 5,688

Nested Loop (cost=1.42..112.21 rows=11 width=24) (actual time=0.062..0.062 rows=0 loops=5,688)

168. 14.248 85.320 ↑ 1.0 11 5,688

Nested Loop (cost=0.85..17.61 rows=11 width=16) (actual time=0.010..0.015 rows=11 loops=5,688)

169. 22.752 22.752 ↑ 1.0 1 5,688

Index Scan using fk_pdpage_stls on dbpdpage p_2 (cost=0.42..8.44 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=5,688)

  • Index Cond: (smstylesupplierid = p_3.smstylesupplierid)
170. 48.320 48.320 ↑ 1.5 10 6,040

Index Scan using ixpdsection01 on dbpdsection s_1 (cost=0.43..9.02 rows=15 width=16) (actual time=0.005..0.008 rows=10 loops=6,040)

  • Index Cond: (pdpageid = p_2.pdpageid)
171. 241.408 241.408 ↓ 0.0 0 60,352

Index Scan using ixpdattributedata01 on dbpdattributedata ad (cost=0.56..8.59 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=60,352)

  • Index Cond: ((pdsectionid = s_1.pdsectionid) AND (pdattributeid = at.pdattributeid))
172. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad.pdattributedataid)
173. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_i18ndescription04 on dbi18ndescription i (cost=0.57..184.46 rows=118 width=15) (never executed)

  • Index Cond: (rid = adv.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
174. 0.066 0.110 ↑ 1.0 140 1

Hash (cost=2.40..2.40 rows=140 width=6) (actual time=0.110..0.110 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
175. 0.044 0.044 ↑ 1.0 140 1

Seq Scan on dblanguage l_1 (cost=0.00..2.40 rows=140 width=6) (actual time=0.007..0.044 rows=140 loops=1)

176. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdsection01 on dbpdsection s_2 (cost=0.43..9.02 rows=15 width=16) (never executed)

  • Index Cond: (pdpageid = p_3.pdpageid)
177. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdattributedata01 on dbpdattributedata ad_1 (cost=0.56..8.59 rows=1 width=24) (never executed)

  • Index Cond: ((pdsectionid = s_2.pdsectionid) AND (pdattributeid = at_1.pdattributeid))
178. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv_1 (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad_1.pdattributedataid)
179. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_1 (cost=0.57..41.03 rows=13 width=39) (never executed)

  • Index Cond: ((rid = adv_1.referencevalueid) AND (languageid = l_2.languageid) AND ((descriptionkey)::text = 'Description'::text))
180. 4.173 169.702 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..402.57 rows=1 width=24) (actual time=0.122..0.122 rows=0 loops=1,391)

181. 29.211 29.211 ↑ 1.0 1 1,391

Seq Scan on dblanguage l_4 (cost=0.00..2.75 rows=1 width=6) (actual time=0.007..0.021 rows=1 loops=1,391)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
182. 1.391 136.318 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..399.69 rows=13 width=31) (actual time=0.098..0.098 rows=0 loops=1,391)

183. 1.391 134.927 ↓ 0.0 0 1,391

Nested Loop (cost=2.13..358.54 rows=1 width=8) (actual time=0.097..0.097 rows=0 loops=1,391)

184. 0.000 133.536 ↓ 0.0 0 1,391

Nested Loop (cost=1.70..352.69 rows=1 width=8) (actual time=0.096..0.096 rows=0 loops=1,391)

185. 2.782 133.536 ↓ 0.0 0 1,391

Nested Loop (cost=1.14..344.09 rows=1 width=16) (actual time=0.096..0.096 rows=0 loops=1,391)

186. 5.742 130.754 ↓ 0.0 0 1,391

Nested Loop (cost=0.70..334.92 rows=1 width=16) (actual time=0.094..0.094 rows=0 loops=1,391)

  • Join Filter: ((SubPlan 36) = p_5.editdate)
  • Rows Removed by Join Filter: 1
187. 5.564 5.564 ↑ 1.0 1 1,391

Index Scan using fk_pdpage_stls on dbpdpage p_5 (cost=0.42..8.44 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=1,391)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
188. 12.798 12.798 ↑ 1.0 1 1,422

Index Scan using ix_xmlname on dbpdattribute at_3 (cost=0.28..8.30 rows=1 width=22) (actual time=0.008..0.009 rows=1 loops=1,422)

  • Index Cond: ((xmlname)::text = 'attr_status_details'::text)
189.          

SubPlan (for Nested Loop)

190. 2.844 106.650 ↑ 1.0 1 1,422

Aggregate (cost=318.16..318.17 rows=1 width=8) (actual time=0.075..0.075 rows=1 loops=1,422)

191. 1.315 103.806 ↓ 0.0 0 1,422

Hash Join (cost=6.85..317.86 rows=117 width=8) (actual time=0.073..0.073 rows=0 loops=1,422)

  • Hash Cond: (i_2.languageid = l_3.languageid)
192. 0.000 102.384 ↓ 0.0 0 1,422

Nested Loop (cost=2.70..312.10 rows=117 width=15) (actual time=0.072..0.072 rows=0 loops=1,422)

193. 1.422 102.384 ↓ 0.0 0 1,422

Nested Loop (cost=2.13..126.47 rows=1 width=16) (actual time=0.072..0.072 rows=0 loops=1,422)

194. 2.844 100.962 ↓ 0.0 0 1,422

Nested Loop (cost=1.70..120.62 rows=1 width=16) (actual time=0.071..0.071 rows=0 loops=1,422)

195. 11.376 11.376 ↑ 1.0 1 1,422

Index Scan using ix_xmlname on dbpdattribute at_2 (cost=0.28..8.30 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1,422)

  • Index Cond: ((xmlname)::text = (at_3.xmlname)::text)
196. 5.060 86.742 ↓ 0.0 0 1,422

Nested Loop (cost=1.42..112.21 rows=11 width=24) (actual time=0.061..0.061 rows=0 loops=1,422)

197. 5.072 21.330 ↑ 1.0 11 1,422

Nested Loop (cost=0.85..17.61 rows=11 width=16) (actual time=0.011..0.015 rows=11 loops=1,422)

198. 5.688 5.688 ↑ 1.0 1 1,422

Index Scan using fk_pdpage_stls on dbpdpage p_4 (cost=0.42..8.44 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=1,422)

  • Index Cond: (smstylesupplierid = p_5.smstylesupplierid)
199. 10.570 10.570 ↑ 1.5 10 1,510

Index Scan using ixpdsection01 on dbpdsection s_3 (cost=0.43..9.02 rows=15 width=16) (actual time=0.004..0.007 rows=10 loops=1,510)

  • Index Cond: (pdpageid = p_4.pdpageid)
200. 60.352 60.352 ↓ 0.0 0 15,088

Index Scan using ixpdattributedata01 on dbpdattributedata ad_2 (cost=0.56..8.59 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=15,088)

  • Index Cond: ((pdsectionid = s_3.pdsectionid) AND (pdattributeid = at_2.pdattributeid))
201. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv_2 (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad_2.pdattributedataid)
202. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_i18ndescription04 on dbi18ndescription i_2 (cost=0.57..184.46 rows=118 width=15) (never executed)

  • Index Cond: (rid = adv_2.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
203. 0.062 0.107 ↑ 1.0 140 1

Hash (cost=2.40..2.40 rows=140 width=6) (actual time=0.107..0.107 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
204. 0.045 0.045 ↑ 1.0 140 1

Seq Scan on dblanguage l_3 (cost=0.00..2.40 rows=140 width=6) (actual time=0.006..0.045 rows=140 loops=1)

205. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdsection01 on dbpdsection s_4 (cost=0.43..9.02 rows=15 width=16) (never executed)

  • Index Cond: (pdpageid = p_5.pdpageid)
206. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdattributedata01 on dbpdattributedata ad_3 (cost=0.56..8.59 rows=1 width=24) (never executed)

  • Index Cond: ((pdsectionid = s_4.pdsectionid) AND (pdattributeid = at_3.pdattributeid))
207. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv_3 (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad_3.pdattributedataid)
208. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_3 (cost=0.57..41.03 rows=13 width=39) (never executed)

  • Index Cond: ((rid = adv_3.referencevalueid) AND (languageid = l_4.languageid) AND ((descriptionkey)::text = 'Description'::text))
209. 2.782 422.864 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..402.57 rows=1 width=24) (actual time=0.304..0.304 rows=0 loops=1,391)

210. 29.211 29.211 ↑ 1.0 1 1,391

Seq Scan on dblanguage l_6 (cost=0.00..2.75 rows=1 width=6) (actual time=0.007..0.021 rows=1 loops=1,391)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
211. 1.391 390.871 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..399.69 rows=13 width=31) (actual time=0.281..0.281 rows=0 loops=1,391)

212. 1.391 389.480 ↓ 0.0 0 1,391

Nested Loop (cost=2.13..358.54 rows=1 width=8) (actual time=0.280..0.280 rows=0 loops=1,391)

213. 1.391 388.089 ↓ 0.0 0 1,391

Nested Loop (cost=1.70..352.69 rows=1 width=8) (actual time=0.279..0.279 rows=0 loops=1,391)

214. 2.782 386.698 ↓ 0.0 0 1,391

Nested Loop (cost=1.14..344.09 rows=1 width=16) (actual time=0.278..0.278 rows=0 loops=1,391)

215. 8.632 383.916 ↓ 0.0 0 1,391

Nested Loop (cost=0.70..334.92 rows=1 width=16) (actual time=0.276..0.276 rows=0 loops=1,391)

  • Join Filter: ((SubPlan 38) = p_7.editdate)
  • Rows Removed by Join Filter: 2
216. 5.564 5.564 ↑ 1.0 1 1,391

Index Scan using fk_pdpage_stls on dbpdpage p_7 (cost=0.42..8.44 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=1,391)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
217. 11.376 11.376 ↓ 2.0 2 1,422

Index Scan using ix_xmlname on dbpdattribute at_5 (cost=0.28..8.30 rows=1 width=22) (actual time=0.008..0.008 rows=2 loops=1,422)

  • Index Cond: ((xmlname)::text = 'attr_status_fabric'::text)
218.          

SubPlan (for Nested Loop)

219. 2.844 358.344 ↑ 1.0 1 2,844

Aggregate (cost=318.16..318.17 rows=1 width=8) (actual time=0.126..0.126 rows=1 loops=2,844)

220. 2.740 355.500 ↓ 0.0 0 2,844

Hash Join (cost=6.85..317.86 rows=117 width=8) (actual time=0.125..0.125 rows=0 loops=2,844)

  • Hash Cond: (i_4.languageid = l_5.languageid)
221. 0.000 352.656 ↓ 0.0 0 2,844

Nested Loop (cost=2.70..312.10 rows=117 width=15) (actual time=0.124..0.124 rows=0 loops=2,844)

222. 2.844 352.656 ↓ 0.0 0 2,844

Nested Loop (cost=2.13..126.47 rows=1 width=16) (actual time=0.124..0.124 rows=0 loops=2,844)

223. 2.844 349.812 ↓ 0.0 0 2,844

Nested Loop (cost=1.70..120.62 rows=1 width=16) (actual time=0.123..0.123 rows=0 loops=2,844)

224. 22.752 22.752 ↓ 2.0 2 2,844

Index Scan using ix_xmlname on dbpdattribute at_4 (cost=0.28..8.30 rows=1 width=8) (actual time=0.007..0.008 rows=2 loops=2,844)

  • Index Cond: ((xmlname)::text = (at_5.xmlname)::text)
225. 8.864 324.216 ↓ 0.0 0 5,688

Nested Loop (cost=1.42..112.21 rows=11 width=24) (actual time=0.057..0.057 rows=0 loops=5,688)

226. 20.640 73.944 ↑ 1.0 11 5,688

Nested Loop (cost=0.85..17.61 rows=11 width=16) (actual time=0.009..0.013 rows=11 loops=5,688)

227. 17.064 17.064 ↑ 1.0 1 5,688

Index Scan using fk_pdpage_stls on dbpdpage p_6 (cost=0.42..8.44 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=5,688)

  • Index Cond: (smstylesupplierid = p_7.smstylesupplierid)
228. 36.240 36.240 ↑ 1.5 10 6,040

Index Scan using ixpdsection01 on dbpdsection s_5 (cost=0.43..9.02 rows=15 width=16) (actual time=0.004..0.006 rows=10 loops=6,040)

  • Index Cond: (pdpageid = p_6.pdpageid)
229. 241.408 241.408 ↓ 0.0 0 60,352

Index Scan using ixpdattributedata01 on dbpdattributedata ad_4 (cost=0.56..8.59 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=60,352)

  • Index Cond: ((pdsectionid = s_5.pdsectionid) AND (pdattributeid = at_4.pdattributeid))
230. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv_4 (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad_4.pdattributedataid)
231. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_i18ndescription04 on dbi18ndescription i_4 (cost=0.57..184.46 rows=118 width=15) (never executed)

  • Index Cond: (rid = adv_4.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
232. 0.064 0.104 ↑ 1.0 140 1

Hash (cost=2.40..2.40 rows=140 width=6) (actual time=0.104..0.104 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
233. 0.040 0.040 ↑ 1.0 140 1

Seq Scan on dblanguage l_5 (cost=0.00..2.40 rows=140 width=6) (actual time=0.007..0.040 rows=140 loops=1)

234. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdsection01 on dbpdsection s_6 (cost=0.43..9.02 rows=15 width=16) (never executed)

  • Index Cond: (pdpageid = p_7.pdpageid)
235. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdattributedata01 on dbpdattributedata ad_5 (cost=0.56..8.59 rows=1 width=24) (never executed)

  • Index Cond: ((pdsectionid = s_6.pdsectionid) AND (pdattributeid = at_5.pdattributeid))
236. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv_5 (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad_5.pdattributedataid)
237. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_5 (cost=0.57..41.03 rows=13 width=39) (never executed)

  • Index Cond: ((rid = adv_5.referencevalueid) AND (languageid = l_6.languageid) AND ((descriptionkey)::text = 'Description'::text))
238. 2.782 166.920 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..402.57 rows=1 width=24) (actual time=0.120..0.120 rows=0 loops=1,391)

239. 29.211 29.211 ↑ 1.0 1 1,391

Seq Scan on dblanguage l_8 (cost=0.00..2.75 rows=1 width=6) (actual time=0.007..0.021 rows=1 loops=1,391)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
240. 1.391 134.927 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..399.69 rows=13 width=31) (actual time=0.097..0.097 rows=0 loops=1,391)

241. 1.391 133.536 ↓ 0.0 0 1,391

Nested Loop (cost=2.13..358.54 rows=1 width=8) (actual time=0.096..0.096 rows=0 loops=1,391)

242. 0.000 132.145 ↓ 0.0 0 1,391

Nested Loop (cost=1.70..352.69 rows=1 width=8) (actual time=0.095..0.095 rows=0 loops=1,391)

243. 2.782 132.145 ↓ 0.0 0 1,391

Nested Loop (cost=1.14..344.09 rows=1 width=16) (actual time=0.095..0.095 rows=0 loops=1,391)

244. 7.195 129.363 ↓ 0.0 0 1,391

Nested Loop (cost=0.70..334.92 rows=1 width=16) (actual time=0.093..0.093 rows=0 loops=1,391)

  • Join Filter: ((SubPlan 40) = p_9.editdate)
  • Rows Removed by Join Filter: 1
245. 5.564 5.564 ↑ 1.0 1 1,391

Index Scan using fk_pdpage_stls on dbpdpage p_9 (cost=0.42..8.44 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=1,391)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
246. 11.376 11.376 ↑ 1.0 1 1,422

Index Scan using ix_xmlname on dbpdattribute at_7 (cost=0.28..8.30 rows=1 width=22) (actual time=0.008..0.008 rows=1 loops=1,422)

  • Index Cond: ((xmlname)::text = 'attr_status_others'::text)
247.          

SubPlan (for Nested Loop)

248. 1.422 105.228 ↑ 1.0 1 1,422

Aggregate (cost=318.16..318.17 rows=1 width=8) (actual time=0.074..0.074 rows=1 loops=1,422)

249. 1.317 103.806 ↓ 0.0 0 1,422

Hash Join (cost=6.85..317.86 rows=117 width=8) (actual time=0.073..0.073 rows=0 loops=1,422)

  • Hash Cond: (i_6.languageid = l_7.languageid)
250. 1.422 102.384 ↓ 0.0 0 1,422

Nested Loop (cost=2.70..312.10 rows=117 width=15) (actual time=0.072..0.072 rows=0 loops=1,422)

251. 1.422 100.962 ↓ 0.0 0 1,422

Nested Loop (cost=2.13..126.47 rows=1 width=16) (actual time=0.071..0.071 rows=0 loops=1,422)

252. 2.844 99.540 ↓ 0.0 0 1,422

Nested Loop (cost=1.70..120.62 rows=1 width=16) (actual time=0.070..0.070 rows=0 loops=1,422)

253. 9.954 9.954 ↑ 1.0 1 1,422

Index Scan using ix_xmlname on dbpdattribute at_6 (cost=0.28..8.30 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1,422)

  • Index Cond: ((xmlname)::text = (at_7.xmlname)::text)
254. 5.060 86.742 ↓ 0.0 0 1,422

Nested Loop (cost=1.42..112.21 rows=11 width=24) (actual time=0.061..0.061 rows=0 loops=1,422)

255. 5.072 21.330 ↑ 1.0 11 1,422

Nested Loop (cost=0.85..17.61 rows=11 width=16) (actual time=0.011..0.015 rows=11 loops=1,422)

256. 5.688 5.688 ↑ 1.0 1 1,422

Index Scan using fk_pdpage_stls on dbpdpage p_8 (cost=0.42..8.44 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=1,422)

  • Index Cond: (smstylesupplierid = p_9.smstylesupplierid)
257. 10.570 10.570 ↑ 1.5 10 1,510

Index Scan using ixpdsection01 on dbpdsection s_7 (cost=0.43..9.02 rows=15 width=16) (actual time=0.004..0.007 rows=10 loops=1,510)

  • Index Cond: (pdpageid = p_8.pdpageid)
258. 60.352 60.352 ↓ 0.0 0 15,088

Index Scan using ixpdattributedata01 on dbpdattributedata ad_6 (cost=0.56..8.59 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=15,088)

  • Index Cond: ((pdsectionid = s_7.pdsectionid) AND (pdattributeid = at_6.pdattributeid))
259. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv_6 (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad_6.pdattributedataid)
260. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_i18ndescription04 on dbi18ndescription i_6 (cost=0.57..184.46 rows=118 width=15) (never executed)

  • Index Cond: (rid = adv_6.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
261. 0.066 0.105 ↑ 1.0 140 1

Hash (cost=2.40..2.40 rows=140 width=6) (actual time=0.105..0.105 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
262. 0.039 0.039 ↑ 1.0 140 1

Seq Scan on dblanguage l_7 (cost=0.00..2.40 rows=140 width=6) (actual time=0.005..0.039 rows=140 loops=1)

263. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdsection01 on dbpdsection s_8 (cost=0.43..9.02 rows=15 width=16) (never executed)

  • Index Cond: (pdpageid = p_9.pdpageid)
264. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpdattributedata01 on dbpdattributedata ad_7 (cost=0.56..8.59 rows=1 width=24) (never executed)

  • Index Cond: ((pdsectionid = s_8.pdsectionid) AND (pdattributeid = at_7.pdattributeid))
265. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_ttrbtdtvl_ttrbtdt_1195 on dbpdattributedatavalue adv_7 (cost=0.43..5.83 rows=2 width=16) (never executed)

  • Index Cond: (pdattributedataid = ad_7.pdattributedataid)
266. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_7 (cost=0.57..41.03 rows=13 width=39) (never executed)

  • Index Cond: ((rid = adv_7.referencevalueid) AND (languageid = l_8.languageid) AND ((descriptionkey)::text = 'Description'::text))
267. 3.752 64,919.477 ↓ 0.0 0 1,141

Nested Loop (cost=0.29..11,511.45 rows=17 width=0) (actual time=56.897..56.897 rows=0 loops=1,141)

  • Join Filter: ((sre_1.proc_def_id_)::text = (srp_1.id_)::text)
  • Rows Removed by Join Filter: 3
268. 7.063 64,914.913 ↑ 113.0 1 1,141

Nested Loop (cost=0.29..11,503.33 rows=113 width=27) (actual time=41.722..56.893 rows=1 loops=1,141)

269. 64,893.234 64,893.234 ↑ 113.0 1 1,141

Seq Scan on act_ru_variable srv_1 (cost=0.00..10,695.17 rows=113 width=7) (actual time=41.708..56.874 rows=1 loops=1,141)

  • Filter: (((name_)::text = 'productId'::text) AND ((long_)::numeric = ss.smstylesupplierid))
  • Rows Removed by Filter: 328862
270. 14.616 14.616 ↑ 1.0 1 812

Index Scan using act_ru_execution_pkey on act_ru_execution sre_1 (cost=0.29..7.14 rows=1 width=34) (actual time=0.017..0.018 rows=1 loops=812)

  • Index Cond: ((id_)::text = (srv_1.execution_id_)::text)
271. 0.799 0.812 ↑ 1.0 4 812

Materialize (cost=0.00..1.34 rows=4 width=22) (actual time=0.001..0.001 rows=4 loops=812)

272. 0.013 0.013 ↑ 1.0 4 1

Seq Scan on act_re_procdef srp_1 (cost=0.00..1.32 rows=4 width=22) (actual time=0.010..0.013 rows=4 loops=1)

  • Filter: ((key_)::text = 'SizeSetSampleApproval'::text)
  • Rows Removed by Filter: 22
273. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2,792.88..8,224.08 rows=3,485 width=8) (never executed)

  • Hash Cond: ((srv_2.execution_id_)::text = (sre_2.id_)::text)
274. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on act_ru_variable srv_2 (cost=523.98..5,600.15 rows=22,653 width=15) (never executed)

  • Recheck Cond: ((name_)::text = 'productId'::text)
275. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on act_idx_var_name (cost=0.00..518.32 rows=22,653 width=0) (never executed)

  • Index Cond: ((name_)::text = 'productId'::text)
276. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,159.90..2,159.90 rows=8,720 width=7) (never executed)

277. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.38..2,159.90 rows=8,720 width=7) (never executed)

  • Hash Cond: ((sre_2.proc_def_id_)::text = (srp_2.id_)::text)
278. 0.000 0.000 ↓ 0.0 0

Seq Scan on act_ru_execution sre_2 (cost=0.00..1,858.78 rows=56,678 width=34) (never executed)

279. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.32..1.32 rows=4 width=22) (never executed)

280. 0.000 0.000 ↓ 0.0 0

Seq Scan on act_re_procdef srp_2 (cost=0.00..1.32 rows=4 width=22) (never executed)

  • Filter: ((key_)::text = 'SizeSetSampleApproval'::text)
281. 2.782 2.782 ↓ 0.0 0 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18n_1 (cost=0.57..49.20 rows=16 width=24) (actual time=0.002..0.002 rows=0 loops=1,391)

  • Index Cond: ((rid = s.smfitid) AND (languageid = lang.languageid))
282. 3.848 25,818.351 ↓ 0.0 0 1,391

Nested Loop (cost=520.44..6,537.91 rows=7 width=8) (actual time=18.267..18.561 rows=0 loops=1,391)

283. 4.153 25,812.787 ↓ 0.0 0 1,391

Hash Join (cost=520.01..6,517.90 rows=17 width=14) (actual time=18.263..18.557 rows=0 loops=1,391)

  • Hash Cond: ((sre_3.proc_def_id_)::text = (srp_3.id_)::text)
284. 16.569 25,808.614 ↑ 113.0 1 1,391

Nested Loop (cost=518.64..6,515.94 rows=113 width=41) (actual time=14.937..18.554 rows=1 loops=1,391)

285. 21,054.176 25,779.403 ↑ 113.0 1 1,391

Bitmap Heap Scan on act_ru_variable srv_3 (cost=518.35..5,707.78 rows=113 width=7) (actual time=14.918..18.533 rows=1 loops=1,391)

  • Recheck Cond: ((name_)::text = 'productId'::text)
  • Filter: ((long_)::numeric = ss.smstylesupplierid)
  • Rows Removed by Filter: 23198
  • Heap Blocks: exact=6667063
286. 4,725.227 4,725.227 ↓ 1.0 23,199 1,391

Bitmap Index Scan on act_idx_var_name (cost=0.00..518.32 rows=22,653 width=0) (actual time=3.397..3.397 rows=23,199 loops=1,391)

  • Index Cond: ((name_)::text = 'productId'::text)
287. 12.642 12.642 ↑ 1.0 1 903

Index Scan using act_ru_execution_pkey on act_ru_execution sre_3 (cost=0.29..7.14 rows=1 width=34) (actual time=0.013..0.014 rows=1 loops=903)

  • Index Cond: ((id_)::text = (srv_3.execution_id_)::text)
288. 0.006 0.020 ↑ 1.0 4 1

Hash (cost=1.32..1.32 rows=4 width=22) (actual time=0.020..0.020 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
289. 0.014 0.014 ↑ 1.0 4 1

Seq Scan on act_re_procdef srp_3 (cost=0.00..1.32 rows=4 width=22) (actual time=0.011..0.014 rows=4 loops=1)

  • Filter: ((key_)::text = 'SizeSetSampleApproval'::text)
  • Rows Removed by Filter: 22
290. 1.716 1.716 ↑ 1.0 1 52

Index Scan using act_idx_var_exe on act_ru_variable srv2 (cost=0.42..1.16 rows=1 width=15) (actual time=0.030..0.033 rows=1 loops=52)

  • Index Cond: ((execution_id_)::text = (sre_3.id_)::text)
  • Filter: ((name_)::text = 'remindDate'::text)
  • Rows Removed by Filter: 13
Planning time : 115.018 ms
Execution time : 126,264.902 ms