explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QS73 : v_product_overview_sizeset_approval_sample_request

Settings
# exclusive inclusive rows x rows loops node
1. 142.966 133,531.216 ↓ 695.5 1,391 1

Hash Left Join (cost=34,101.83..223,330.23 rows=2 width=663) (actual time=1,115.157..133,531.216 rows=1,391 loops=1)

  • Hash Cond: (ss.smstylesupplierid = nsr2.smstylesupplierid)
2. 7.471 6,948.801 ↓ 695.5 1,391 1

Hash Left Join (cost=20,724.08..93,848.44 rows=2 width=655) (actual time=335.215..6,948.801 rows=1,391 loops=1)

  • Hash Cond: (ss.smstylesupplierid = (nsr.long_)::numeric)
3. 4.353 6,708.928 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=2,849.22..75,973.33 rows=2 width=625) (actual time=102.790..6,708.928 rows=1,391 loops=1)

4. 4.253 6,694.838 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=2,849.07..75,972.98 rows=2 width=622) (actual time=102.783..6,694.838 rows=1,391 loops=1)

5. 5.694 6,666.938 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=2,848.64..75,956.15 rows=2 width=592) (actual time=102.760..6,666.938 rows=1,391 loops=1)

6. 4,021.422 6,650.116 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=2,848.51..75,955.59 rows=2 width=595) (actual time=102.744..6,650.116 rows=1,391 loops=1)

  • Join Filter: ((srv.long_)::numeric = se.smsampleevalpageid)
  • Rows Removed by Join Filter: 23062682
7. 1.787 1,447.735 ↓ 695.5 1,391 1

Nested Loop (cost=16.08..67,680.51 rows=2 width=573) (actual time=8.022..1,447.735 rows=1,391 loops=1)

8. 0.047 0.047 ↑ 1.0 1 1

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

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

Nested Loop Left Join (cost=16.08..67,677.39 rows=2 width=565) (actual time=7.992..1,445.901 rows=1,391 loops=1)

10. 3.833 1,431.442 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.80..67,676.64 rows=2 width=544) (actual time=7.983..1,431.442 rows=1,391 loops=1)

11. 142.196 1,423.436 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.65..67,676.29 rows=2 width=520) (actual time=7.975..1,423.436 rows=1,391 loops=1)

  • Join Filter: (sc.seasonclientid = s.seasonclientid)
  • Rows Removed by Join Filter: 815126
12. 4.558 1,238.119 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.65..67,645.35 rows=2 width=514) (actual time=7.547..1,238.119 rows=1,391 loops=1)

  • Join Filter: (s.clientid = d.clientid)
13. 3.293 1,222.433 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.37..67,636.26 rows=2 width=500) (actual time=7.533..1,222.433 rows=1,391 loops=1)

14. 4.557 1,212.185 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=15.22..67,635.45 rows=2 width=476) (actual time=7.526..1,212.185 rows=1,391 loops=1)

15. 399.491 1,196.500 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.93..67,621.03 rows=2 width=463) (actual time=7.503..1,196.500 rows=1,391 loops=1)

  • Join Filter: (sm.smsizerangeid = sr.smsizerangeid)
  • Rows Removed by Join Filter: 2484424
16. 3.348 680.165 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.93..67,531.08 rows=2 width=464) (actual time=7.226..680.165 rows=1,391 loops=1)

17. 4.213 669.862 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.79..67,530.73 rows=2 width=464) (actual time=7.213..669.862 rows=1,391 loops=1)

18. 3.992 658.694 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.64..67,530.39 rows=2 width=464) (actual time=7.204..658.694 rows=1,391 loops=1)

19. 3.476 632.446 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=14.21..67,529.10 rows=2 width=449) (actual time=7.184..632.446 rows=1,391 loops=1)

20. 72.477 627.579 ↓ 695.5 1,391 1

Nested Loop Left Join (cost=13.79..67,527.97 rows=2 width=442) (actual time=7.182..627.579 rows=1,391 loops=1)

21. 1.469 541.192 ↓ 695.5 1,391 1

Nested Loop (cost=0.42..67,485.27 rows=2 width=301) (actual time=7.085..541.192 rows=1,391 loops=1)

22. 0.049 0.049 ↑ 1.0 1 1

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

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

Nested Loop (cost=0.42..67,481.43 rows=2 width=289) (actual time=7.039..539.674 rows=1,391 loops=1)

24. 500.820 500.820 ↓ 13.2 1,391 1

Seq Scan on dbsmstylesupplier ss (cost=0.00..66,597.13 rows=105 width=174) (actual time=7.006..500.820 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: 1344212
25. 31.993 31.993 ↑ 1.0 1 1,391

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

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

Index Scan using ixpk_smsampleevalpage01 on dbsmsampleevalpage se (cost=13.36..21.34 rows=1 width=141) (actual time=0.009..0.010 rows=1 loops=1,391)

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

SubPlan (for Index Scan)

28. 4.173 63.986 ↑ 1.0 1 1,391

Limit (cost=12.93..12.94 rows=1 width=16) (actual time=0.046..0.046 rows=1 loops=1,391)

29. 22.256 59.813 ↑ 3.0 1 1,391

Sort (cost=12.93..12.94 rows=3 width=16) (actual time=0.043..0.043 rows=1 loops=1,391)

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

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

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

Limit (cost=12.93..12.94 rows=1 width=16) (actual time=0.046..0.046 rows=1 loops=1,391)

32. 22.256 59.813 ↑ 3.0 1 1,391

Sort (cost=12.93..12.94 rows=3 width=16) (actual time=0.043..0.043 rows=1 loops=1,391)

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

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

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
34. 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)
35. 22.256 22.256 ↑ 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.015..0.016 rows=1 loops=1,391)

  • Index Cond: (se.smstylemeasurementid = smstylemeasurementid)
36. 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.004..0.005 rows=1 loops=1,391)

  • Index Cond: (smsampletypeid = se.smsampletypeid)
  • Heap Fetches: 1295
37. 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
38. 116.514 116.844 ↑ 1.0 1,787 1,391

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

39. 0.330 0.330 ↑ 1.0 1,787 1

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

40. 11.128 11.128 ↑ 1.0 1 1,391

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

  • Index Cond: (ss.clientsupplierid = clientsupplierid)
41. 6.955 6.955 ↑ 1.0 1 1,391

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

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

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

  • Index Cond: (ss.departmentid = departmentid)
  • Filter: (clientid = 2041999::numeric)
43. 42.952 43.121 ↑ 1.0 587 1,391

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

44. 0.169 0.169 ↑ 1.0 587 1

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

45. 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)
46. 9.737 9.737 ↑ 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.006..0.007 rows=1 loops=1,391)

  • Index Cond: (cs.supplierid = supplierid)
47. 1,094.908 1,180.959 ↓ 3.4 16,580 1,391

Materialize (cost=2,832.43..8,118.31 rows=4,824 width=30) (actual time=0.042..0.849 rows=16,580 loops=1,391)

48. 17.925 86.051 ↓ 3.4 16,580 1

Hash Join (cost=2,832.43..8,094.19 rows=4,824 width=30) (actual time=58.455..86.051 rows=16,580 loops=1)

  • Hash Cond: ((srv.execution_id_)::text = (sre.id_)::text)
49. 10.970 15.850 ↓ 1.1 16,580 1

Bitmap Heap Scan on act_ru_variable srv (cost=365.92..5,363.88 rows=15,677 width=15) (actual time=6.152..15.850 rows=16,580 loops=1)

  • Recheck Cond: ((name_)::text = 'sampleId'::text)
  • Heap Blocks: exact=4583
50. 4.880 4.880 ↓ 1.1 16,580 1

Bitmap Index Scan on act_idx_var_name (cost=0.00..362.00 rows=15,677 width=0) (actual time=4.880..4.880 rows=16,580 loops=1)

  • Index Cond: ((name_)::text = 'sampleId'::text)
51. 10.613 52.276 ↓ 1.6 27,147 1

Hash (cost=2,248.45..2,248.45 rows=17,445 width=29) (actual time=52.276..52.276 rows=27,147 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1669kB
52. 26.804 41.663 ↓ 1.6 27,147 1

Hash Join (cost=1.43..2,248.45 rows=17,445 width=29) (actual time=0.040..41.663 rows=27,147 loops=1)

  • Hash Cond: ((sre.proc_def_id_)::text = (srp.id_)::text)
53. 14.839 14.839 ↑ 1.0 56,696 1

Seq Scan on act_ru_execution sre (cost=0.00..1,859.96 rows=56,696 width=34) (actual time=0.011..14.839 rows=56,696 loops=1)

54. 0.005 0.020 ↑ 1.0 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
55. 0.015 0.015 ↑ 1.0 8 1

Seq Scan on act_re_procdef srp (cost=0.00..1.32 rows=8 width=22) (actual time=0.007..0.015 rows=8 loops=1)

  • Filter: ((key_)::text = 'SampleRequest'::text)
  • Rows Removed by Filter: 18
56. 11.128 11.128 ↑ 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.007..0.008 rows=1 loops=1,391)

  • Index Cond: (ss.smsupplierstatusid = smsupplierstatusid)
57. 23.647 23.647 ↑ 1.0 1 1,391

Index Scan using pk_smstylesupplieriteminfo on dbsmstylesupplieriteminfo ssi (cost=0.43..8.41 rows=1 width=38) (actual time=0.016..0.017 rows=1 loops=1,391)

  • Index Cond: (ss.smstylesupplierid = smstylesupplierid)
58. 9.737 9.737 ↑ 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.007 rows=1 loops=1,391)

  • Index Cond: (s.osidentification = smosidentificationid)
59. 2.459 232.402 ↓ 16.5 7,853 1

Hash (cost=17,868.90..17,868.90 rows=477 width=38) (actual time=232.402..232.402 rows=7,853 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 553kB
60. 1.058 229.943 ↓ 16.5 7,853 1

Subquery Scan on nsr (cost=17,852.84..17,868.90 rows=477 width=38) (actual time=226.440..229.943 rows=7,853 loops=1)

61. 1.595 228.885 ↓ 16.5 7,853 1

Unique (cost=17,852.84..17,864.13 rows=477 width=38) (actual time=226.438..228.885 rows=7,853 loops=1)

62. 5.035 227.290 ↓ 3.9 8,870 1

Sort (cost=17,852.84..17,858.48 rows=2,257 width=38) (actual time=226.437..227.290 rows=8,870 loops=1)

  • Sort Key: nsrv2.long_
  • Sort Method: quicksort Memory: 1077kB
63. 6.985 222.255 ↓ 3.9 8,870 1

Nested Loop Left Join (cost=8,730.42..17,727.12 rows=2,257 width=38) (actual time=52.187..222.255 rows=8,870 loops=1)

64. 8.317 82.220 ↓ 4.2 8,870 1

Hash Join (cost=8,730.00..14,064.77 rows=2,105 width=37) (actual time=52.139..82.220 rows=8,870 loops=1)

  • Hash Cond: ((nsrv.proc_inst_id_)::text = (nsrv2.proc_inst_id_)::text)
65. 12.750 52.910 ↓ 4.4 8,870 1

Hash Join (cost=2,830.15..7,938.84 rows=2,025 width=29) (actual time=31.122..52.910 rows=8,870 loops=1)

  • Hash Cond: ((nsrv.execution_id_)::text = (nsre.id_)::text)
66. 9.793 12.340 ↓ 1.3 8,870 1

Bitmap Heap Scan on act_ru_variable nsrv (cost=363.64..5,361.61 rows=6,580 width=14) (actual time=3.285..12.340 rows=8,870 loops=1)

  • Recheck Cond: ((name_)::text = 'sampleId'::text)
  • Filter: (long_ IS NULL)
  • Rows Removed by Filter: 7710
  • Heap Blocks: exact=4583
67. 2.547 2.547 ↓ 1.1 16,580 1

Bitmap Index Scan on act_idx_var_name (cost=0.00..362.00 rows=15,677 width=0) (actual time=2.547..2.547 rows=16,580 loops=1)

  • Index Cond: ((name_)::text = 'sampleId'::text)
68. 5.995 27.820 ↓ 1.6 27,147 1

Hash (cost=2,248.45..2,248.45 rows=17,445 width=29) (actual time=27.820..27.820 rows=27,147 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1669kB
69. 15.310 21.825 ↓ 1.6 27,147 1

Hash Join (cost=1.43..2,248.45 rows=17,445 width=29) (actual time=0.024..21.825 rows=27,147 loops=1)

  • Hash Cond: ((nsre.proc_def_id_)::text = (nsrp.id_)::text)
70. 6.500 6.500 ↑ 1.0 56,696 1

Seq Scan on act_ru_execution nsre (cost=0.00..1,859.96 rows=56,696 width=34) (actual time=0.004..6.500 rows=56,696 loops=1)

71. 0.003 0.015 ↑ 1.0 8 1

Hash (cost=1.32..1.32 rows=8 width=22) (actual time=0.015..0.015 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
72. 0.012 0.012 ↑ 1.0 8 1

Seq Scan on act_re_procdef nsrp (cost=0.00..1.32 rows=8 width=22) (actual time=0.006..0.012 rows=8 loops=1)

  • Filter: ((key_)::text = 'SampleRequest'::text)
  • Rows Removed by Filter: 18
73. 4.723 20.993 ↓ 1.0 23,234 1

Hash (cost=5,615.33..5,615.33 rows=22,761 width=15) (actual time=20.993..20.993 rows=23,234 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1087kB
74. 12.832 16.270 ↓ 1.0 23,234 1

Bitmap Heap Scan on act_ru_variable nsrv2 (cost=528.82..5,615.33 rows=22,761 width=15) (actual time=4.224..16.270 rows=23,234 loops=1)

  • Recheck Cond: ((name_)::text = 'productId'::text)
  • Heap Blocks: exact=4802
75. 3.438 3.438 ↓ 1.0 23,234 1

Bitmap Index Scan on act_idx_var_name (cost=0.00..523.13 rows=22,761 width=0) (actual time=3.438..3.438 rows=23,234 loops=1)

  • Index Cond: ((name_)::text = 'productId'::text)
76. 133.050 133.050 ↑ 1.0 1 8,870

Index Scan using act_idx_var_procinst on act_ru_variable nsrv3 (cost=0.42..1.73 rows=1 width=15) (actual time=0.012..0.015 rows=1 loops=8,870)

  • Index Cond: ((proc_inst_id_)::text = (nsrv2.proc_inst_id_)::text)
  • Filter: ((name_)::text = 'sampleTypeId'::text)
  • Rows Removed by Filter: 13
77. 1.983 663.411 ↓ 135.4 7,853 1

Hash (cost=13,377.03..13,377.03 rows=58 width=16) (actual time=663.411..663.411 rows=7,853 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 376kB
78. 0.853 661.428 ↓ 135.4 7,853 1

Subquery Scan on nsr2 (cost=13,375.87..13,377.03 rows=58 width=16) (actual time=658.910..661.428 rows=7,853 loops=1)

79. 12.852 660.575 ↓ 135.4 7,853 1

HashAggregate (cost=13,375.87..13,376.45 rows=58 width=16) (actual time=658.909..660.575 rows=7,853 loops=1)

  • Group Key: m.smstylesupplierid
80. 6.777 647.723 ↓ 152.9 8,870 1

Nested Loop (cost=5,090.70..13,375.58 rows=58 width=16) (actual time=80.117..647.723 rows=8,870 loops=1)

81. 8.723 569.986 ↓ 152.9 8,870 1

Nested Loop (cost=5,090.28..13,222.83 rows=58 width=8) (actual time=80.086..569.986 rows=8,870 loops=1)

82. 15.102 516.913 ↓ 152.9 8,870 1

Nested Loop (cost=5,089.86..13,179.65 rows=58 width=8) (actual time=80.058..516.913 rows=8,870 loops=1)

83. 34.340 138.239 ↓ 46.9 16,526 1

Hash Join (cost=5,089.43..10,177.74 rows=352 width=22) (actual time=80.009..138.239 rows=16,526 loops=1)

  • Hash Cond: ((ahv_sample_request.proc_inst_id_)::text = (ahp.proc_inst_id_)::text)
84. 24.635 27.579 ↓ 1.7 16,526 1

Bitmap Heap Scan on act_ru_variable ahv_sample_request (cost=388.71..5,400.48 rows=9,737 width=15) (actual time=3.675..27.579 rows=16,526 loops=1)

  • Recheck Cond: ((name_)::text = 'sampleRequestId'::text)
  • Filter: (long_ IS NOT NULL)
  • Rows Removed by Filter: 54
  • Heap Blocks: exact=4608
85. 2.944 2.944 ↑ 1.0 16,580 1

Bitmap Index Scan on act_idx_var_name (cost=0.00..386.28 rows=16,781 width=0) (actual time=2.944..2.944 rows=16,580 loops=1)

  • Index Cond: ((name_)::text = 'sampleRequestId'::text)
86. 4.305 76.320 ↓ 4.3 16,742 1

Hash (cost=4,652.40..4,652.40 rows=3,865 width=7) (actual time=76.320..76.320 rows=16,742 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 652kB
87. 6.377 72.015 ↓ 4.3 16,742 1

Hash Join (cost=1.43..4,652.40 rows=3,865 width=7) (actual time=0.040..72.015 rows=16,742 loops=1)

  • Hash Cond: ((ahp.proc_def_id_)::text = (arp.id_)::text)
88. 65.625 65.625 ↓ 1.3 16,742 1

Seq Scan on act_hi_procinst ahp (cost=0.00..4,565.23 rows=12,561 width=33) (actual time=0.021..65.625 rows=16,742 loops=1)

  • Filter: ((end_act_id_ IS NULL) AND ((proc_def_id_)::text ~~* 'SampleRequest:%'::text))
  • Rows Removed by Filter: 90076
89. 0.005 0.013 ↑ 1.0 8 1

Hash (cost=1.32..1.32 rows=8 width=22) (actual time=0.013..0.013 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
90. 0.008 0.008 ↑ 1.0 8 1

Seq Scan on act_re_procdef arp (cost=0.00..1.32 rows=8 width=22) (actual time=0.005..0.008 rows=8 loops=1)

  • Filter: ((key_)::text = 'SampleRequest'::text)
  • Rows Removed by Filter: 18
91. 363.572 363.572 ↑ 1.0 1 16,526

Index Scan using act_idx_hi_procvar_proc_inst on act_hi_varinst ahv_sample (cost=0.43..8.52 rows=1 width=7) (actual time=0.021..0.022 rows=1 loops=16,526)

  • Index Cond: ((proc_inst_id_)::text = (ahp.proc_inst_id_)::text)
  • Filter: ((long_ IS NULL) AND ((name_)::text = 'sampleId'::text))
  • Rows Removed by Filter: 14
92. 44.350 44.350 ↑ 1.0 1 8,870

Index Scan using pk_smplrqst on dbsmsamplerequest sr_1 (cost=0.42..0.73 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=8,870)

  • Index Cond: (smsamplerequestid = (ahv_sample_request.long_)::numeric)
93. 70.960 70.960 ↑ 1.0 1 8,870

Index Scan using pk_smmessage on dbsmmessage m (cost=0.43..2.62 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=8,870)

  • Index Cond: (smmessageid = sr_1.smmessageid)
94.          

SubPlan (for Hash Left Join)

95. 26.404 26.429 ↑ 14.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18n (cost=3.32..46.78 rows=14 width=24) (actual time=0.018..0.019 rows=1 loops=1,391)

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

Initplan (for Index Scan)

97. 0.025 0.025 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
98. 6.934 27.820 ↑ 14.0 1 1,391

Nested Loop (cost=3.59..55.21 rows=14 width=27) (actual time=0.020..0.020 rows=1 loops=1,391)

99.          

Initplan (for Nested Loop)

100. 0.021 0.021 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
101. 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)
102. 13.910 13.910 ↑ 14.0 1 1,391

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

  • Index Cond: ((rid = s.smassortmentid) AND (languageid = $3) AND ((descriptionkey)::text = 'Description'::text))
103. 6.933 25.038 ↑ 14.0 1 1,391

Nested Loop (cost=3.59..55.21 rows=14 width=26) (actual time=0.017..0.018 rows=1 loops=1,391)

104.          

Initplan (for Nested Loop)

105. 0.022 0.022 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
106. 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)
107. 11.128 11.128 ↑ 14.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_1 (cost=0.57..43.96 rows=14 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))
108. 5.543 25.038 ↑ 14.0 1 1,391

Nested Loop (cost=3.60..55.22 rows=14 width=28) (actual time=0.018..0.018 rows=1 loops=1,391)

109.          

Initplan (for Nested Loop)

110. 0.021 0.021 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
111. 8.346 8.346 ↑ 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.006 rows=1 loops=1,391)

  • Index Cond: (smproductgroupid = s.smproductgroupid)
112. 11.128 11.128 ↑ 14.0 1 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_2 (cost=0.57..43.96 rows=14 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))
113. 12.519 12.519 ↑ 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.009 rows=1 loops=1,391)

  • Index Cond: (ldapusermappingid = ss.responsibleid)
114. 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)
115. 8.326 43.121 ↑ 14.0 1 1,391

Nested Loop (cost=3.32..48.62 rows=14 width=24) (actual time=0.027..0.031 rows=1 loops=1,391)

116.          

Initplan (for Nested Loop)

117. 0.020 0.020 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
118. 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
119. 15.301 15.301 ↑ 14.0 1 1,391

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

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

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

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

Initplan (for Index Scan)

122. 0.021 0.021 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
123. 13.889 13.910 ↑ 14.0 1 1,391

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

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

Initplan (for Index Scan)

125. 0.021 0.021 ↑ 1.0 1 1

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

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

Index Scan using pk_18ndscrptn on dbi18ndescription i18_6 (cost=0.57..109.25 rows=38 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))
127. 4.156 25,563.798 ↓ 0.0 0 1,391

Hash Join (cost=524.82..6,537.94 rows=18 width=22) (actual time=18.089..18.378 rows=0 loops=1,391)

  • Hash Cond: ((sre_1.proc_def_id_)::text = (srp_1.id_)::text)
128. 12.542 25,559.625 ↑ 114.0 1 1,391

Nested Loop (cost=523.45..6,535.96 rows=114 width=27) (actual time=14.809..18.375 rows=1 loops=1,391)

129. 20,775.976 25,529.023 ↑ 114.0 1 1,391

Bitmap Heap Scan on act_ru_variable srv_1 (cost=523.16..5,723.48 rows=114 width=7) (actual time=14.792..18.353 rows=1 loops=1,391)

  • Recheck Cond: ((name_)::text = 'productId'::text)
  • Filter: ((long_)::numeric = ss.smstylesupplierid)
  • Rows Removed by Filter: 23233
  • Heap Blocks: exact=6679582
130. 4,753.047 4,753.047 ↓ 1.0 23,234 1,391

Bitmap Index Scan on act_idx_var_name (cost=0.00..523.13 rows=22,761 width=0) (actual time=3.417..3.417 rows=23,234 loops=1,391)

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

Index Scan using act_ru_execution_pkey on act_ru_execution sre_1 (cost=0.29..7.12 rows=1 width=34) (actual time=0.020..0.020 rows=1 loops=903)

  • Index Cond: ((id_)::text = (srv_1.execution_id_)::text)
132. 0.001 0.017 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
133. 0.016 0.016 ↑ 1.0 4 1

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

  • Filter: ((key_)::text = 'SizeSetSampleApproval'::text)
  • Rows Removed by Filter: 22
134. 23.647 23.647 ↑ 1.0 1 1,391

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

  • Filter: (smffpdecisionid = ss.ffpdecision)
  • Rows Removed by Filter: 85
135. 4.378 41.730 ↑ 14.0 1 1,391

Nested Loop (cost=3.32..48.92 rows=14 width=24) (actual time=0.023..0.030 rows=1 loops=1,391)

136.          

Initplan (for Nested Loop)

137. 0.023 0.023 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
138. 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
139. 16.464 16.464 ↑ 14.0 1 1,029

Index Scan using pk_18ndscrptn on dbi18ndescription i18_7 (cost=0.57..43.96 rows=14 width=32) (actual time=0.016..0.016 rows=1 loops=1,029)

  • Index Cond: ((rid = ss.ffpdecision) AND (languageid = $21) AND ((descriptionkey)::text = 'Description'::text))
140. 1.370 1.391 ↓ 0.0 0 1,391

Index Scan using pk_18ndscrptn on dbi18ndescription i18_8 (cost=3.32..46.74 rows=14 width=24) (actual time=0.001..0.001 rows=0 loops=1,391)

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

Initplan (for Index Scan)

142. 0.021 0.021 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
143. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=25.02..25.04 rows=1 width=14) (never executed)

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

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

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

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

146. 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
147. 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))
148. 0.000 0.000 ↓ 0.0 0

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

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

HashAggregate (cost=25.02..25.04 rows=1 width=14) (never executed)

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

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

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

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

152. 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
153. 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))
154. 0.000 0.000 ↓ 0.0 0

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

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

HashAggregate (cost=1,300.24..41,956.04 rows=9 width=15) (actual time=5.377..5.377 rows=0 loops=1,391)

  • Group Key: st.smstylesupplierid, l.languageid
156. 5.564 7,476.625 ↓ 0.0 0 1,391

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

157. 31.993 31.993 ↑ 1.0 1 1,391

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

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

Nested Loop (cost=0.57..1,295.09 rows=234 width=15) (actual time=5.348..5.348 rows=0 loops=1,391)

159. 7,436.286 7,436.286 ↓ 0.0 0 1,391

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

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

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

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

SubPlan (for HashAggregate)

162. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,476.50..1,478.77 rows=227 width=24) (never executed)

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

Nested Loop (cost=1.44..1,475.93 rows=227 width=24) (never executed)

164. 0.000 0.000 ↓ 0.0 0

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

165. 0.000 0.000 ↓ 0.0 0

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

166. 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)
167. 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)
168. 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
169. 0.000 0.000 ↓ 0.0 0

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

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

Group (cost=1,556.34..1,559.75 rows=227 width=41) (never executed)

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

Sort (cost=1,556.34..1,556.91 rows=227 width=41) (never executed)

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

Nested Loop (cost=1.87..1,547.46 rows=227 width=41) (never executed)

173. 0.000 0.000 ↓ 0.0 0

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

174. 0.000 0.000 ↓ 0.0 0

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

175. 0.000 0.000 ↓ 0.0 0

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

176. 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)
177. 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)
178. 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)
179. 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)
180. 0.000 0.000 ↓ 0.0 0

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

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

HashAggregate (cost=1,476.50..1,478.77 rows=227 width=24) (never executed)

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

Nested Loop (cost=1.44..1,475.93 rows=227 width=24) (never executed)

183. 0.000 0.000 ↓ 0.0 0

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

184. 0.000 0.000 ↓ 0.0 0

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

185. 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)
186. 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)
187. 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
188. 0.000 0.000 ↓ 0.0 0

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

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

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

190. 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
191. 1.391 474.331 ↓ 0.0 0 1,391

Nested Loop (cost=2.70..401.94 rows=14 width=31) (actual time=0.341..0.341 rows=0 loops=1,391)

192. 0.000 472.940 ↓ 0.0 0 1,391

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

193. 1.391 472.940 ↓ 0.0 0 1,391

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

194. 2.782 471.549 ↓ 0.0 0 1,391

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

195. 10.019 468.767 ↓ 0.0 0 1,391

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

  • Join Filter: ((SubPlan 30) = p_3.editdate)
  • Rows Removed by Join Filter: 2
196. 25.038 25.038 ↑ 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.018..0.018 rows=1 loops=1,391)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
197. 18.486 18.486 ↓ 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.013 rows=2 loops=1,422)

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

SubPlan (for Nested Loop)

199. 5.688 415.224 ↑ 1.0 1 2,844

Aggregate (cost=317.37..317.38 rows=1 width=8) (actual time=0.146..0.146 rows=1 loops=2,844)

200. 2.782 409.536 ↓ 0.0 0 2,844

Hash Join (cost=6.85..317.08 rows=114 width=8) (actual time=0.144..0.144 rows=0 loops=2,844)

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

Nested Loop (cost=2.70..311.36 rows=114 width=15) (actual time=0.143..0.143 rows=0 loops=2,844)

202. 0.000 403.848 ↓ 0.0 0 2,844

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

203. 8.532 403.848 ↓ 0.0 0 2,844

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

204. 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.009..0.009 rows=2 loops=2,844)

  • Index Cond: ((xmlname)::text = (at_1.xmlname)::text)
205. 31.616 369.720 ↓ 0.0 0 5,688

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

206. 19.584 96.696 ↑ 1.0 11 5,688

Nested Loop (cost=0.85..17.68 rows=11 width=16) (actual time=0.012..0.017 rows=11 loops=5,688)

207. 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)
208. 54.360 54.360 ↑ 1.5 10 6,040

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

  • Index Cond: (pdpageid = p_2.pdpageid)
209. 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))
210. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (rid = adv.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
212. 0.038 0.062 ↑ 1.0 140 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
213. 0.024 0.024 ↑ 1.0 140 1

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

214. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (pdpageid = p_3.pdpageid)
215. 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))
216. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

219. 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
220. 1.391 136.318 ↓ 0.0 0 1,391

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

221. 0.000 134.927 ↓ 0.0 0 1,391

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

222. 1.391 134.927 ↓ 0.0 0 1,391

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

223. 2.782 133.536 ↓ 0.0 0 1,391

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

224. 5.742 130.754 ↓ 0.0 0 1,391

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

  • Join Filter: ((SubPlan 32) = p_5.editdate)
  • Rows Removed by Join Filter: 1
225. 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)
226. 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.009..0.009 rows=1 loops=1,422)

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

SubPlan (for Nested Loop)

228. 2.844 106.650 ↑ 1.0 1 1,422

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

229. 0.000 103.806 ↓ 0.0 0 1,422

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

  • Hash Cond: (i_2.languageid = l_3.languageid)
230. 1.422 103.806 ↓ 0.0 0 1,422

Nested Loop (cost=2.70..311.36 rows=114 width=15) (actual time=0.073..0.073 rows=0 loops=1,422)

231. 1.422 102.384 ↓ 0.0 0 1,422

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

232. 2.844 100.962 ↓ 0.0 0 1,422

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

233. 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)
234. 3.638 86.742 ↓ 0.0 0 1,422

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

235. 6.494 22.752 ↑ 1.0 11 1,422

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

236. 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.003..0.004 rows=1 loops=1,422)

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

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

  • Index Cond: (pdpageid = p_4.pdpageid)
238. 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))
239. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (rid = adv_2.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
241. 0.028 0.048 ↑ 1.0 140 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
242. 0.020 0.020 ↑ 1.0 140 1

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

243. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (pdpageid = p_5.pdpageid)
244. 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))
245. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

248. 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
249. 1.391 390.871 ↓ 0.0 0 1,391

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

250. 1.391 389.480 ↓ 0.0 0 1,391

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

251. 1.391 388.089 ↓ 0.0 0 1,391

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

252. 1.391 386.698 ↓ 0.0 0 1,391

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

253. 8.601 385.307 ↓ 0.0 0 1,391

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

  • Join Filter: ((SubPlan 34) = p_7.editdate)
  • Rows Removed by Join Filter: 2
254. 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)
255. 12.798 12.798 ↓ 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.009 rows=2 loops=1,422)

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

SubPlan (for Nested Loop)

257. 2.844 358.344 ↑ 1.0 1 2,844

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

258. 2.785 355.500 ↓ 0.0 0 2,844

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

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

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

260. 2.844 352.656 ↓ 0.0 0 2,844

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

261. 2.844 349.812 ↓ 0.0 0 2,844

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

262. 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)
263. 8.864 324.216 ↓ 0.0 0 5,688

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

264. 20.640 73.944 ↑ 1.0 11 5,688

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

265. 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)
266. 36.240 36.240 ↑ 1.5 10 6,040

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

  • Index Cond: (pdpageid = p_6.pdpageid)
267. 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))
268. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (rid = adv_4.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
270. 0.041 0.059 ↑ 1.0 140 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
271. 0.018 0.018 ↑ 1.0 140 1

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

272. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (pdpageid = p_7.pdpageid)
273. 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))
274. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

277. 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
278. 1.391 136.318 ↓ 0.0 0 1,391

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

279. 1.391 134.927 ↓ 0.0 0 1,391

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

280. 1.391 133.536 ↓ 0.0 0 1,391

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

281. 2.782 132.145 ↓ 0.0 0 1,391

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

282. 5.773 129.363 ↓ 0.0 0 1,391

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

  • Join Filter: ((SubPlan 36) = p_9.editdate)
  • Rows Removed by Join Filter: 1
283. 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)
284. 12.798 12.798 ↑ 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.009 rows=1 loops=1,422)

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

SubPlan (for Nested Loop)

286. 1.422 105.228 ↑ 1.0 1 1,422

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

287. 1.358 103.806 ↓ 0.0 0 1,422

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

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

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

289. 1.422 100.962 ↓ 0.0 0 1,422

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

290. 4.266 99.540 ↓ 0.0 0 1,422

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

291. 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)
292. 3.638 85.320 ↓ 0.0 0 1,422

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

293. 5.072 21.330 ↑ 1.0 11 1,422

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

294. 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)
295. 10.570 10.570 ↑ 1.5 10 1,510

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

  • Index Cond: (pdpageid = p_8.pdpageid)
296. 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))
297. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (rid = adv_6.referencevalueid)
  • Filter: ((descriptionkey)::text = 'Description'::text)
299. 0.044 0.064 ↑ 1.0 140 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
300. 0.020 0.020 ↑ 1.0 140 1

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

301. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (pdpageid = p_9.pdpageid)
302. 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))
303. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Nested Loop (cost=0.29..11,535.34 rows=18 width=0) (actual time=56.928..56.928 rows=0 loops=1,141)

  • Join Filter: ((sre_2.proc_def_id_)::text = (srp_2.id_)::text)
  • Rows Removed by Join Filter: 3
306. 7.063 64,951.425 ↑ 114.0 1 1,141

Nested Loop (cost=0.29..11,527.17 rows=114 width=27) (actual time=41.757..56.925 rows=1 loops=1,141)

307. 64,929.746 64,929.746 ↑ 114.0 1 1,141

Seq Scan on act_ru_variable srv_2 (cost=0.00..10,714.69 rows=114 width=7) (actual time=41.743..56.906 rows=1 loops=1,141)

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

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

  • Index Cond: ((id_)::text = (srv_2.execution_id_)::text)
309. 0.802 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)

310. 0.010 0.010 ↑ 1.0 4 1

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

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

Hash Join (cost=2,799.01..8,242.26 rows=3,502 width=8) (never executed)

  • Hash Cond: ((srv_3.execution_id_)::text = (sre_3.id_)::text)
312. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on act_ru_variable srv_3 (cost=528.82..5,615.33 rows=22,761 width=15) (never executed)

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

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

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

Hash (cost=2,161.16..2,161.16 rows=8,722 width=7) (never executed)

315. 0.000 0.000 ↓ 0.0 0

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

  • Hash Cond: ((sre_3.proc_def_id_)::text = (srp_3.id_)::text)
316. 0.000 0.000 ↓ 0.0 0

Seq Scan on act_ru_execution sre_3 (cost=0.00..1,859.96 rows=56,696 width=34) (never executed)

317. 0.000 0.000 ↓ 0.0 0

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

318. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((key_)::text = 'SizeSetSampleApproval'::text)
319. 6.955 11.128 ↓ 0.0 0 1,391

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

320.          

Initplan (for Nested Loop)

321. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using pk_18ndscrptn on dbi18ndescription i18_9 (cost=0.57..43.96 rows=14 width=32) (never executed)

  • Index Cond: ((rid = s.timeline) AND (languageid = $116) AND ((descriptionkey)::text = 'Description'::text))
324. 2.782 2.782 ↓ 0.0 0 1,391

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

  • Index Cond: ((rid = s.smfitid) AND (languageid = lang.languageid))
325. 4.173 47.294 ↑ 1.0 1 1,391

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

326. 43.121 43.121 ↑ 73.0 1 1,391

Index Scan using ixfk_smsku04 on dbsmsku sku (cost=0.43..234.40 rows=73 width=4) (actual time=0.031..0.031 rows=1 loops=1,391)

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

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

328. 9.737 9.737 ↑ 73.0 1 1,391

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

  • Index Cond: (smstyleid = s.smstyleid)
  • Filter: (isekrdelete <> 99::numeric)
329. 2.613 26,157.755 ↓ 0.0 0 1,391

Nested Loop (cost=525.25..6,559.13 rows=7 width=8) (actual time=18.506..18.805 rows=0 loops=1,391)

330. 4.160 26,153.582 ↓ 0.0 0 1,391

Hash Join (cost=524.82..6,537.94 rows=18 width=14) (actual time=18.502..18.802 rows=0 loops=1,391)

  • Hash Cond: ((sre_4.proc_def_id_)::text = (srp_4.id_)::text)
331. 14.690 26,149.409 ↑ 114.0 1 1,391

Nested Loop (cost=523.45..6,535.96 rows=114 width=41) (actual time=15.132..18.799 rows=1 loops=1,391)

332. 21,333.767 26,122.980 ↑ 114.0 1 1,391

Bitmap Heap Scan on act_ru_variable srv_4 (cost=523.16..5,723.48 rows=114 width=7) (actual time=15.116..18.780 rows=1 loops=1,391)

  • Recheck Cond: ((name_)::text = 'productId'::text)
  • Filter: ((long_)::numeric = ss.smstylesupplierid)
  • Rows Removed by Filter: 23233
  • Heap Blocks: exact=6679582
333. 4,789.213 4,789.213 ↓ 1.0 23,234 1,391

Bitmap Index Scan on act_idx_var_name (cost=0.00..523.13 rows=22,761 width=0) (actual time=3.443..3.443 rows=23,234 loops=1,391)

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

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

  • Index Cond: ((id_)::text = (srv_4.execution_id_)::text)
335. 0.004 0.013 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
336. 0.009 0.009 ↑ 1.0 4 1

Seq Scan on act_re_procdef srp_4 (cost=0.00..1.32 rows=4 width=22) (actual time=0.007..0.009 rows=4 loops=1)

  • Filter: ((key_)::text = 'SizeSetSampleApproval'::text)
  • Rows Removed by Filter: 22
337. 1.560 1.560 ↑ 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.027..0.030 rows=1 loops=52)

  • Index Cond: ((execution_id_)::text = (sre_4.id_)::text)
  • Filter: ((name_)::text = 'remindDate'::text)
  • Rows Removed by Filter: 13
Planning time : 117.113 ms
Execution time : 133,535.816 ms