explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xy9E

Settings
# exclusive inclusive rows x rows loops node
1. 0.161 71,473.002 ↑ 1.0 1 1

Nested Loop (cost=19,436.16..56,391,214,370.04 rows=1 width=10,608) (actual time=71,448.352..71,473.002 rows=1 loops=1)

2. 0.015 22,510.252 ↑ 1.0 1 1

Hash Left Join (cost=19,436.16..36,919.26 rows=1 width=3,804) (actual time=22,485.620..22,510.252 rows=1 loops=1)

  • Hash Cond: (ss.smstylesupplierid = (nsr.long_)::numeric)
3. 0.006 109.489 ↑ 1.0 1 1

Nested Loop Left Join (cost=15,524.61..33,007.68 rows=1 width=3,796) (actual time=84.861..109.489 rows=1 loops=1)

4. 0.004 109.455 ↑ 1.0 1 1

Nested Loop Left Join (cost=15,524.18..33,007.16 rows=1 width=3,252) (actual time=84.828..109.455 rows=1 loops=1)

5. 0.007 109.450 ↑ 1.0 1 1

Nested Loop (cost=15,524.04..33,007.00 rows=1 width=3,214) (actual time=84.824..109.450 rows=1 loops=1)

6. 0.004 109.418 ↑ 1.0 1 1

Nested Loop Left Join (cost=15,523.76..32,998.68 rows=1 width=2,940) (actual time=84.797..109.418 rows=1 loops=1)

7. 0.005 109.410 ↑ 1.0 1 1

Nested Loop (cost=15,523.61..32,998.40 rows=1 width=2,768) (actual time=84.791..109.410 rows=1 loops=1)

8. 0.010 109.390 ↑ 1.0 1 1

Nested Loop Left Join (cost=15,523.34..32,990.10 rows=1 width=2,686) (actual time=84.774..109.390 rows=1 loops=1)

  • Join Filter: (s.clientid = d.clientid)
9. 0.006 109.357 ↑ 1.0 1 1

Nested Loop Left Join (cost=15,523.05..32,989.78 rows=1 width=2,578) (actual time=84.746..109.357 rows=1 loops=1)

10. 0.007 109.335 ↑ 1.0 1 1

Nested Loop (cost=15,522.91..32,989.61 rows=1 width=2,406) (actual time=84.728..109.335 rows=1 loops=1)

11. 0.026 109.304 ↑ 1.0 1 1

Nested Loop Left Join (cost=15,522.62..32,989.29 rows=1 width=2,328) (actual time=84.701..109.304 rows=1 loops=1)

12. 0.003 109.277 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,470.28..27,936.89 rows=1 width=2,308) (actual time=84.675..109.277 rows=1 loops=1)

13. 0.007 109.273 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,470.00..27,936.59 rows=1 width=2,308) (actual time=84.672..109.273 rows=1 loops=1)

14. 0.005 109.265 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,469.57..27,935.94 rows=1 width=2,256) (actual time=84.666..109.265 rows=1 loops=1)

15. 0.005 109.259 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,469.15..27,935.38 rows=1 width=2,038) (actual time=84.662..109.259 rows=1 loops=1)

16. 0.006 109.253 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,469.00..27,935.21 rows=1 width=2,038) (actual time=84.657..109.253 rows=1 loops=1)

17. 0.052 109.246 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,468.86..27,935.03 rows=1 width=2,038) (actual time=84.652..109.246 rows=1 loops=1)

18. 0.002 109.191 ↑ 1.0 1 1

Nested Loop (cost=345.39..17,811.47 rows=1 width=1,132) (actual time=84.599..109.191 rows=1 loops=1)

19. 0.015 109.158 ↑ 1.0 1 1

Nested Loop (cost=345.39..17,808.33 rows=1 width=1,080) (actual time=84.569..109.158 rows=1 loops=1)

20. 34.180 109.098 ↑ 1.0 1 1

Bitmap Heap Scan on dbsmstyle s (cost=184.26..278.57 rows=1 width=824) (actual time=84.514..109.098 rows=1 loops=1)

  • Recheck Cond: ((clientid = '300000'::numeric) AND (istemplate = 0))
  • Filter: ((seasonclientid = '5513075500'::numeric) AND ((styleno)::text = '02-36654-20190430-002'::text))
  • Rows Removed by Filter: 8,089
  • Heap Blocks: exact=5,792
21. 0.936 74.918 ↓ 0.0 0 1

BitmapAnd (cost=184.26..184.26 rows=24 width=0) (actual time=74.917..74.918 rows=0 loops=1)

22. 1.680 1.680 ↓ 1.9 9,077 1

Bitmap Index Scan on ixfk_smstyle09 (cost=0.00..92.00 rows=4,744 width=0) (actual time=1.679..1.680 rows=9,077 loops=1)

  • Index Cond: (clientid = '300000'::numeric)
23. 72.302 72.302 ↓ 198.5 941,625 1

Bitmap Index Scan on ix_stl_istemplate (cost=0.00..92.00 rows=4,744 width=0) (actual time=72.301..72.302 rows=941,625 loops=1)

  • Index Cond: (istemplate = 0)
24. 0.012 0.045 ↑ 6,767.0 1 1

Bitmap Heap Scan on dbsmstylesupplier ss (cost=161.13..17,462.08 rows=6,767 width=296) (actual time=0.043..0.045 rows=1 loops=1)

  • Recheck Cond: (smstyleid = s.smstyleid)
  • Filter: ((proposalstatus IS NULL) OR ((proposalstatus)::text <> 'DRAFT'::text))
  • Heap Blocks: exact=1
25. 0.033 0.033 ↑ 6,801.0 1 1

Bitmap Index Scan on ixfk_smstylesupplier01 (cost=0.00..159.44 rows=6,801 width=0) (actual time=0.032..0.033 rows=1 loops=1)

  • Index Cond: (smstyleid = s.smstyleid)
26. 0.031 0.031 ↑ 1.0 1 1

Seq Scan on dbclient c (cost=0.00..3.14 rows=1 width=52) (actual time=0.028..0.031 rows=1 loops=1)

  • Filter: (clientid = '300000'::numeric)
  • Rows Removed by Filter: 90
27. 0.000 0.003 ↓ 0.0 0 1

Index Scan using ixpk_smsampleevalpage01 on dbsmsampleevalpage se (cost=10,123.47..10,123.55 rows=1 width=906) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (smsampleevalpageid = (SubPlan 51))
28.          

SubPlan (for Index Scan)

29. 0.002 0.044 ↓ 0.0 0 1

Limit (cost=10,123.04..10,123.05 rows=1 width=28) (actual time=0.044..0.044 rows=0 loops=1)

30. 0.012 0.042 ↓ 0.0 0 1

Sort (cost=10,123.04..10,133.69 rows=4,260 width=28) (actual time=0.042..0.042 rows=0 loops=1)

  • Sort Key: dbsmsampleevalpage.samplingby_date DESC
  • Sort Method: quicksort Memory: 25kB
31. 0.004 0.030 ↓ 0.0 0 1

Bitmap Heap Scan on dbsmsampleevalpage (cost=101.44..10,101.74 rows=4,260 width=28) (actual time=0.029..0.030 rows=0 loops=1)

  • Recheck Cond: (smstylesupplierid = ss.smstylesupplierid)
32. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on fk_smplvlpg_stls_1435 (cost=0.00..100.38 rows=4,260 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
33. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using pk_sampletype on dbsmsampletype sty (cost=0.14..0.16 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (smsampletypeid = se.smsampletypeid)
  • Heap Fetches: 0
34. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using pk_vltnstts on dbsmevaluationstatus sta (cost=0.14..0.16 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (smevaluationstatusid = se.smevaluatuinstatusid)
  • Heap Fetches: 0
35. 0.001 0.001 ↓ 0.0 0 1

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

  • Index Cond: (se.smstylesetcomponentid = smstylesetcomponentid)
36. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_stmsmnt on dbsmstylemeasurement sm (cost=0.43..0.63 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (se.smstylemeasurementid = smstylemeasurementid)
37. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using pk_sizerange on dbsmsizerange sr (cost=0.28..0.30 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (smsizerangeid = sm.smsizerangeid)
  • Heap Fetches: 0
38. 0.000 0.001 ↓ 0.0 0 1

Index Only Scan using pk_pdpage on dbpdpage pdp (cost=5,052.34..5,052.39 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (pdpageid = (SubPlan 52))
  • Heap Fetches: 0
39.          

SubPlan (for Index Only Scan)

40. 0.001 0.019 ↓ 0.0 0 1

Limit (cost=5,051.91..5,051.91 rows=1 width=28) (actual time=0.018..0.019 rows=0 loops=1)

41. 0.004 0.018 ↓ 0.0 0 1

Sort (cost=5,051.91..5,056.96 rows=2,020 width=28) (actual time=0.017..0.018 rows=0 loops=1)

  • Sort Key: dbpdpage.editdate DESC
  • Sort Method: quicksort Memory: 25kB
42. 0.005 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdpage (cost=48.08..5,041.81 rows=2,020 width=28) (actual time=0.012..0.014 rows=0 loops=1)

  • Recheck Cond: (smstylesupplierid = ss.smstylesupplierid)
43. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
44. 0.024 0.024 ↑ 1.0 1 1

Index Scan using pk_clients on dbclientsupplier cs (cost=0.29..0.31 rows=1 width=118) (actual time=0.022..0.024 rows=1 loops=1)

  • Index Cond: (clientsupplierid = ss.clientsupplierid)
  • Filter: (supplierid = '5520500494'::numeric)
45. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pk_office on dboffice o2 (cost=0.14..0.16 rows=1 width=192) (actual time=0.014..0.016 rows=1 loops=1)

  • Index Cond: (ss.clientofficeid = officeid)
46. 0.023 0.023 ↑ 1.0 1 1

Index Scan using pk_department on dbdepartment d (cost=0.29..0.31 rows=1 width=148) (actual time=0.021..0.023 rows=1 loops=1)

  • Index Cond: (ss.departmentid = departmentid)
  • Filter: (clientid = '300000'::numeric)
47. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_ssnclnt on dbseasonclient sc (cost=0.28..8.29 rows=1 width=102) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: (seasonclientid = '5513075500'::numeric)
48. 0.004 0.004 ↑ 1.0 1 1

Index Scan using pk_office on dboffice o1 (cost=0.14..0.27 rows=1 width=192) (actual time=0.002..0.004 rows=1 loops=1)

  • Index Cond: (cs.officeid = officeid)
49. 0.025 0.025 ↑ 1.0 1 1

Index Scan using pk_supplier on dbsupplier p (cost=0.29..8.30 rows=1 width=294) (actual time=0.023..0.025 rows=1 loops=1)

  • Index Cond: (supplierid = '5520500494'::numeric)
50. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_sstatus on dbsmsupplierstatus sst (cost=0.14..0.15 rows=1 width=78) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (ss.smsupplierstatusid = smsupplierstatusid)
51. 0.028 0.028 ↓ 0.0 0 1

Index Scan using pk_smstylesupplieriteminfo on dbsmstylesupplieriteminfo ssi (cost=0.43..0.51 rows=1 width=564) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (ss.smstylesupplierid = smstylesupplierid)
52. 4.751 22,400.748 ↓ 297.1 8,023 1

Hash (cost=3,911.22..3,911.22 rows=27 width=16) (actual time=22,400.748..22,400.748 rows=8,023 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 441kB
53. 6.329 22,395.997 ↓ 297.1 8,023 1

Subquery Scan on nsr (cost=3,910.82..3,911.22 rows=27 width=16) (actual time=22,378.588..22,395.997 rows=8,023 loops=1)

54. 6.891 22,389.668 ↓ 297.1 8,023 1

Unique (cost=3,910.82..3,910.95 rows=27 width=162) (actual time=22,378.586..22,389.668 rows=8,023 loops=1)

55. 13.867 22,382.777 ↓ 334.2 9,024 1

Sort (cost=3,910.82..3,910.88 rows=27 width=162) (actual time=22,378.575..22,382.777 rows=9,024 loops=1)

  • Sort Key: nsrv2.long_
  • Sort Method: quicksort Memory: 808kB
56. 23.827 22,368.910 ↓ 334.2 9,024 1

Nested Loop Left Join (cost=117.69..3,910.17 rows=27 width=162) (actual time=272.559..22,368.910 rows=9,024 loops=1)

57. 31.454 22,209.723 ↓ 3,008.0 9,024 1

Nested Loop (cost=117.27..3,762.83 rows=3 width=154) (actual time=272.538..22,209.723 rows=9,024 loops=1)

58. 39.822 764.317 ↓ 9,024.0 9,024 1

Nested Loop (cost=41.87..3,652.36 rows=1 width=146) (actual time=270.155..764.317 rows=9,024 loops=1)

  • Join Filter: ((nsre.proc_def_id_)::text = (nsrp.id_)::text)
  • Rows Removed by Join Filter: 63,168
59. 0.063 0.063 ↓ 8.0 8 1

Seq Scan on act_re_procdef nsrp (cost=0.00..1.32 rows=1 width=146) (actual time=0.037..0.063 rows=8 loops=1)

  • Filter: ((key_)::text = 'SampleRequest'::text)
  • Rows Removed by Filter: 18
60. 149.632 724.432 ↓ 1,002.7 9,024 8

Nested Loop (cost=41.87..3,650.92 rows=9 width=292) (actual time=2.522..90.554 rows=9,024 loops=8)

61. 126.912 141.648 ↓ 1,002.7 9,024 8

Bitmap Heap Scan on act_ru_variable nsrv (cost=41.58..3,576.06 rows=9 width=292) (actual time=2.507..17.706 rows=9,024 loops=8)

  • Recheck Cond: ((name_)::text = 'sampleId'::text)
  • Filter: (long_ IS NULL)
  • Rows Removed by Filter: 8,324
  • Heap Blocks: exact=38,304
62. 14.736 14.736 ↓ 9.9 17,350 8

Bitmap Index Scan on act_idx_var_name (cost=0.00..41.58 rows=1,754 width=0) (actual time=1.842..1.842 rows=17,350 loops=8)

  • Index Cond: ((name_)::text = 'sampleId'::text)
63. 433.152 433.152 ↑ 1.0 1 72,192

Index Scan using act_ru_execution_pkey on act_ru_execution nsre (cost=0.29..8.31 rows=1 width=292) (actual time=0.006..0.006 rows=1 loops=72,192)

  • Index Cond: ((id_)::text = (nsrv.execution_id_)::text)
64. 36.096 21,413.952 ↑ 9.0 1 9,024

Bitmap Heap Scan on act_ru_variable nsrv2 (cost=75.40..110.39 rows=9 width=154) (actual time=2.372..2.373 rows=1 loops=9,024)

  • Recheck Cond: (((proc_inst_id_)::text = (nsrv.proc_inst_id_)::text) AND ((name_)::text = 'productId'::text))
  • Heap Blocks: exact=9,024
65. 27.072 21,377.856 ↓ 0.0 0 9,024

BitmapAnd (cost=75.40..75.40 rows=9 width=0) (actual time=2.369..2.369 rows=0 loops=9,024)

66. 90.240 90.240 ↑ 125.3 14 9,024

Bitmap Index Scan on act_idx_var_procinst (cost=0.00..33.13 rows=1,754 width=0) (actual time=0.010..0.010 rows=14 loops=9,024)

  • Index Cond: ((proc_inst_id_)::text = (nsrv.proc_inst_id_)::text)
67. 21,260.544 21,260.544 ↓ 13.8 24,137 9,024

Bitmap Index Scan on act_idx_var_name (cost=0.00..41.58 rows=1,754 width=0) (actual time=2.356..2.356 rows=24,137 loops=9,024)

  • Index Cond: ((name_)::text = 'productId'::text)
68. 135.360 135.360 ↑ 9.0 1 9,024

Index Scan using act_idx_var_procinst on act_ru_variable nsrv3 (cost=0.42..49.02 rows=9 width=154) (actual time=0.011..0.015 rows=1 loops=9,024)

  • Index Cond: ((proc_inst_id_)::text = (nsrv2.proc_inst_id_)::text)
  • Filter: ((name_)::text = 'sampleTypeId'::text)
  • Rows Removed by Filter: 13
69. 0.038 0.038 ↑ 1.0 1 1

Seq Scan on dblanguage lang (cost=0.00..3.10 rows=1 width=78) (actual time=0.022..0.038 rows=1 loops=1)

  • Filter: (((languageisocode)::text = ANY ('{en,de}'::text[])) AND ((languageisocode)::text = 'de'::text))
  • Rows Removed by Filter: 139
70.          

SubPlan (for Nested Loop)

71. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=3.59..59.90 rows=11 width=32) (actual time=0.003..0.003 rows=0 loops=1)

72.          

Initplan (for Nested Loop)

73. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
74. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_smassortmt on dbsmassortment a (cost=0.27..8.29 rows=1 width=78) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (smassortmentid = s.smassortmentid)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18 (cost=0.57..48.69 rows=11 width=536) (never executed)

  • Index Cond: ((rid = s.smassortmentid) AND (languageid = $0) AND ((descriptionkey)::text = 'Description'::text))
76. 0.003 0.004 ↓ 0.0 0 1

Nested Loop (cost=3.59..59.90 rows=11 width=32) (actual time=0.003..0.004 rows=0 loops=1)

77.          

Initplan (for Nested Loop)

78. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
79. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_smasmtsubg on dbsmassortmentsubgroup ag (cost=0.28..8.29 rows=1 width=78) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (smassortmentsubgroupid = s.smassortmentsubgroupid)
80. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_1 (cost=0.57..48.69 rows=11 width=536) (never executed)

  • Index Cond: ((rid = s.smassortmentsubgroupid) AND (languageid = $2) AND ((descriptionkey)::text = 'Description'::text))
81. 0.003 0.004 ↓ 0.0 0 1

Nested Loop (cost=3.60..59.91 rows=11 width=32) (actual time=0.003..0.004 rows=0 loops=1)

82.          

Initplan (for Nested Loop)

83. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
84. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_smprodgrp on dbsmproductgroup p_1 (cost=0.28..8.30 rows=1 width=78) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (smproductgroupid = s.smproductgroupid)
85. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_2 (cost=0.57..48.69 rows=11 width=536) (never executed)

  • Index Cond: ((rid = s.smproductgroupid) AND (languageid = $4) AND ((descriptionkey)::text = 'Description'::text))
86. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ldpsrmppng on dbldapusermapping ldapuserm (cost=0.29..8.31 rows=1 width=32) (never executed)

  • Index Cond: (ldapusermappingid = ss.responsibleid)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ldpsrmppng on dbldapusermapping ldapuserm_1 (cost=0.29..8.31 rows=1 width=32) (never executed)

  • Index Cond: (ldapusermappingid = ss.marketqaldapusermappingid)
88. 0.000 0.001 ↓ 0.0 0 1

Index Scan using pk_18ndscrptn on dbi18ndescription i18_3 (cost=3.32..51.44 rows=11 width=516) (actual time=0.001..0.001 rows=0 loops=1)

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

Initplan (for Index Scan)

90. 0.018 0.018 ↑ 1.0 1 1

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

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

Index Scan using pk_18ndscrptn on dbi18ndescription i18_4 (cost=3.32..51.44 rows=11 width=32) (actual time=0.000..0.000 rows=0 loops=1)

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

Initplan (for Index Scan)

93. 0.016 0.016 ↑ 1.0 1 1

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

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

Index Scan using pk_18ndscrptn on dbi18ndescription i18_5 (cost=0.57..48.69 rows=11 width=32) (never executed)

  • Index Cond: ((rid = sr.smsizerangeid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
95. 0.000 0.000 ↓ 0.0 0

Unique (cost=25.30..25.30 rows=1 width=32) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Sort (cost=25.30..25.30 rows=1 width=32) (never executed)

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

Nested Loop (cost=1.13..25.29 rows=1 width=32) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.76 rows=1 width=1,580) (never executed)

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

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

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

Index Scan using pk_ldpsrmppng on dbldapusermapping u (cost=0.29..8.31 rows=1 width=1,064) (never executed)

  • Index Cond: (ldapusermappingid = ss.buyerid)
  • Filter: (isactive = '1'::numeric)
101. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixauthuser9006 on dbauthuser90 auf (cost=0.42..8.51 rows=1 width=516) (never executed)

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

Unique (cost=25.30..25.30 rows=1 width=32) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Sort (cost=25.30..25.30 rows=1 width=32) (never executed)

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

Nested Loop (cost=1.13..25.29 rows=1 width=32) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.76 rows=1 width=1,580) (never executed)

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

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

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

Index Scan using pk_ldpsrmppng on dbldapusermapping u_1 (cost=0.29..8.31 rows=1 width=1,064) (never executed)

  • Index Cond: (ldapusermappingid = ss.buyerid2)
  • Filter: (isactive = '1'::numeric)
108. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixauthuser9006 on dbauthuser90 auf_1 (cost=0.42..8.51 rows=1 width=516) (never executed)

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

Index Scan using pk_18ndscrptn on dbi18ndescription i18_6 (cost=3.32..51.47 rows=11 width=118) (actual time=0.001..0.002 rows=0 loops=1)

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

Initplan (for Index Scan)

111. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on dblanguage dblanguage_5 (cost=0.00..2.75 rows=1 width=20) (actual time=0.007..0.018 rows=1 loops=1)

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
112. 0.002 1.809 ↓ 0.0 0 1

Nested Loop (cost=974,445.99..1,121,946.08 rows=8 width=516) (actual time=1.808..1.809 rows=0 loops=1)

113. 0.015 1.807 ↓ 0.0 0 1

Hash Join (cost=974,445.43..1,121,909.24 rows=1 width=20) (actual time=1.807..1.807 rows=0 loops=1)

  • Hash Cond: (pda.pdattributeid = atr.pdattributeid)
114. 0.012 1.743 ↓ 0.0 0 1

Hash Join (cost=974,401.52..1,121,864.77 rows=149 width=40) (actual time=1.742..1.743 rows=0 loops=1)

  • Hash Cond: (pdv.pdattributedataid = pda.pdattributedataid)
115. 0.012 0.012 ↑ 6,848,928.0 1 1

Seq Scan on dbpdattributedatavalue pdv (cost=0.00..121,778.28 rows=6,848,928 width=40) (actual time=0.011..0.012 rows=1 loops=1)

116. 0.003 1.719 ↓ 0.0 0 1

Hash (cost=974,390.94..974,390.94 rows=847 width=40) (actual time=1.718..1.719 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
117. 0.014 1.716 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=40) (actual time=1.715..1.716 rows=0 loops=1)

  • Hash Cond: (pda.pdsectionid = pds.pdsectionid)
118. 0.012 0.012 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata pda (cost=0.00..825,719.36 rows=38,855,236 width=60) (actual time=0.012..0.012 rows=1 loops=1)

119. 0.004 1.690 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.689..1.690 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
120. 0.004 1.686 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.686..1.686 rows=0 loops=1)

121. 0.075 0.075 ↑ 2.0 1 1

Seq Scan on dbsection sec (cost=0.00..9.74 rows=2 width=20) (actual time=0.061..0.075 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_status'::text)
  • Rows Removed by Filter: 458
122. 0.005 1.607 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.607..1.607 rows=0 loops=1)

  • Recheck Cond: ((sectionid = sec.sectionid) AND (pdpageid = pdp.pdpageid))
123. 0.210 1.602 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.602..1.602 rows=0 loops=1)

124. 1.391 1.391 ↑ 3.1 7,310 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.391..1.391 rows=7,310 loops=1)

  • Index Cond: (sectionid = sec.sectionid)
125. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
126. 0.005 0.049 ↑ 10.5 2 1

Hash (cost=43.64..43.64 rows=21 width=20) (actual time=0.049..0.049 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
127. 0.018 0.044 ↑ 10.5 2 1

Bitmap Heap Scan on dbpdattribute atr (cost=4.45..43.64 rows=21 width=20) (actual time=0.037..0.044 rows=2 loops=1)

  • Recheck Cond: ((xmlname)::text = 'attr_status_care_label'::text)
  • Heap Blocks: exact=2
128. 0.026 0.026 ↑ 10.5 2 1

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (actual time=0.026..0.026 rows=2 loops=1)

  • Index Cond: ((xmlname)::text = 'attr_status_care_label'::text)
129. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_7 (cost=0.57..36.73 rows=11 width=536) (never executed)

  • Index Cond: ((rid = pdv.referencevalueid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
130. 0.001 1.567 ↓ 0.0 0 1

Nested Loop (cost=974,445.99..1,121,946.08 rows=8 width=516) (actual time=1.566..1.567 rows=0 loops=1)

131. 0.016 1.566 ↓ 0.0 0 1

Hash Join (cost=974,445.43..1,121,909.24 rows=1 width=20) (actual time=1.565..1.566 rows=0 loops=1)

  • Hash Cond: (pda_1.pdattributeid = atr_1.pdattributeid)
132. 0.016 1.524 ↓ 0.0 0 1

Hash Join (cost=974,401.52..1,121,864.77 rows=149 width=40) (actual time=1.523..1.524 rows=0 loops=1)

  • Hash Cond: (pdv_1.pdattributedataid = pda_1.pdattributedataid)
133. 0.005 0.005 ↑ 6,848,928.0 1 1

Seq Scan on dbpdattributedatavalue pdv_1 (cost=0.00..121,778.28 rows=6,848,928 width=40) (actual time=0.005..0.005 rows=1 loops=1)

134. 0.002 1.503 ↓ 0.0 0 1

Hash (cost=974,390.94..974,390.94 rows=847 width=40) (actual time=1.503..1.503 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
135. 0.011 1.501 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=40) (actual time=1.501..1.501 rows=0 loops=1)

  • Hash Cond: (pda_1.pdsectionid = pds_1.pdsectionid)
136. 0.006 0.006 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata pda_1 (cost=0.00..825,719.36 rows=38,855,236 width=60) (actual time=0.005..0.006 rows=1 loops=1)

137. 0.000 1.484 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.484..1.484 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
138. 0.002 1.484 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.483..1.484 rows=0 loops=1)

139. 0.042 0.042 ↑ 2.0 1 1

Seq Scan on dbsection sec_1 (cost=0.00..9.74 rows=2 width=20) (actual time=0.032..0.042 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_status'::text)
  • Rows Removed by Filter: 458
140. 0.006 1.440 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds_1 (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.439..1.440 rows=0 loops=1)

  • Recheck Cond: ((sectionid = sec_1.sectionid) AND (pdpageid = pdp.pdpageid))
141. 0.211 1.434 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.433..1.434 rows=0 loops=1)

142. 1.221 1.221 ↑ 3.1 7,310 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.220..1.221 rows=7,310 loops=1)

  • Index Cond: (sectionid = sec_1.sectionid)
143. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
144. 0.008 0.026 ↑ 10.5 2 1

Hash (cost=43.64..43.64 rows=21 width=20) (actual time=0.025..0.026 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
145. 0.005 0.018 ↑ 10.5 2 1

Bitmap Heap Scan on dbpdattribute atr_1 (cost=4.45..43.64 rows=21 width=20) (actual time=0.016..0.018 rows=2 loops=1)

  • Recheck Cond: ((xmlname)::text = 'attr_status_fabric'::text)
  • Heap Blocks: exact=2
146. 0.013 0.013 ↑ 10.5 2 1

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (actual time=0.013..0.013 rows=2 loops=1)

  • Index Cond: ((xmlname)::text = 'attr_status_fabric'::text)
147. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_8 (cost=0.57..36.73 rows=11 width=536) (never executed)

  • Index Cond: ((rid = pdv_1.referencevalueid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
148. 0.001 1.556 ↓ 0.0 0 1

Nested Loop (cost=974,445.99..1,121,946.08 rows=8 width=516) (actual time=1.556..1.556 rows=0 loops=1)

149. 0.014 1.555 ↓ 0.0 0 1

Hash Join (cost=974,445.43..1,121,909.24 rows=1 width=20) (actual time=1.555..1.555 rows=0 loops=1)

  • Hash Cond: (pda_2.pdattributeid = atr_2.pdattributeid)
150. 0.017 1.523 ↓ 0.0 0 1

Hash Join (cost=974,401.52..1,121,864.77 rows=149 width=40) (actual time=1.523..1.523 rows=0 loops=1)

  • Hash Cond: (pdv_2.pdattributedataid = pda_2.pdattributedataid)
151. 0.004 0.004 ↑ 6,848,928.0 1 1

Seq Scan on dbpdattributedatavalue pdv_2 (cost=0.00..121,778.28 rows=6,848,928 width=40) (actual time=0.004..0.004 rows=1 loops=1)

152. 0.002 1.502 ↓ 0.0 0 1

Hash (cost=974,390.94..974,390.94 rows=847 width=40) (actual time=1.502..1.502 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
153. 0.010 1.500 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=40) (actual time=1.500..1.500 rows=0 loops=1)

  • Hash Cond: (pda_2.pdsectionid = pds_2.pdsectionid)
154. 0.005 0.005 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata pda_2 (cost=0.00..825,719.36 rows=38,855,236 width=60) (actual time=0.005..0.005 rows=1 loops=1)

155. 0.002 1.485 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.485..1.485 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
156. 0.001 1.483 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.482..1.483 rows=0 loops=1)

157. 0.044 0.044 ↑ 2.0 1 1

Seq Scan on dbsection sec_2 (cost=0.00..9.74 rows=2 width=20) (actual time=0.033..0.044 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_status'::text)
  • Rows Removed by Filter: 458
158. 0.005 1.438 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds_2 (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.437..1.438 rows=0 loops=1)

  • Recheck Cond: ((sectionid = sec_2.sectionid) AND (pdpageid = pdp.pdpageid))
159. 0.208 1.433 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.432..1.433 rows=0 loops=1)

160. 1.224 1.224 ↑ 3.1 7,310 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.224..1.224 rows=7,310 loops=1)

  • Index Cond: (sectionid = sec_2.sectionid)
161. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
162. 0.007 0.018 ↑ 21.0 1 1

Hash (cost=43.64..43.64 rows=21 width=20) (actual time=0.018..0.018 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
163. 0.005 0.011 ↑ 21.0 1 1

Bitmap Heap Scan on dbpdattribute atr_2 (cost=4.45..43.64 rows=21 width=20) (actual time=0.011..0.011 rows=1 loops=1)

  • Recheck Cond: ((xmlname)::text = 'attr_status_lab_dips'::text)
  • Heap Blocks: exact=1
164. 0.006 0.006 ↑ 21.0 1 1

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((xmlname)::text = 'attr_status_lab_dips'::text)
165. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_9 (cost=0.57..36.73 rows=11 width=536) (never executed)

  • Index Cond: ((rid = pdv_2.referencevalueid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
166. 0.001 1.539 ↓ 0.0 0 1

Nested Loop (cost=974,445.99..1,121,946.08 rows=8 width=516) (actual time=1.539..1.539 rows=0 loops=1)

167. 0.021 1.538 ↓ 0.0 0 1

Hash Join (cost=974,445.43..1,121,909.24 rows=1 width=20) (actual time=1.538..1.538 rows=0 loops=1)

  • Hash Cond: (pda_3.pdattributeid = atr_3.pdattributeid)
168. 0.012 1.501 ↓ 0.0 0 1

Hash Join (cost=974,401.52..1,121,864.77 rows=149 width=40) (actual time=1.501..1.501 rows=0 loops=1)

  • Hash Cond: (pdv_3.pdattributedataid = pda_3.pdattributedataid)
169. 0.004 0.004 ↑ 6,848,928.0 1 1

Seq Scan on dbpdattributedatavalue pdv_3 (cost=0.00..121,778.28 rows=6,848,928 width=40) (actual time=0.004..0.004 rows=1 loops=1)

170. 0.002 1.485 ↓ 0.0 0 1

Hash (cost=974,390.94..974,390.94 rows=847 width=40) (actual time=1.485..1.485 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
171. 0.010 1.483 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=40) (actual time=1.482..1.483 rows=0 loops=1)

  • Hash Cond: (pda_3.pdsectionid = pds_3.pdsectionid)
172. 0.004 0.004 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata pda_3 (cost=0.00..825,719.36 rows=38,855,236 width=60) (actual time=0.003..0.004 rows=1 loops=1)

173. 0.002 1.469 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.468..1.469 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
174. 0.003 1.467 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.466..1.467 rows=0 loops=1)

175. 0.040 0.040 ↑ 2.0 1 1

Seq Scan on dbsection sec_3 (cost=0.00..9.74 rows=2 width=20) (actual time=0.031..0.040 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_status'::text)
  • Rows Removed by Filter: 458
176. 0.009 1.424 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds_3 (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.423..1.424 rows=0 loops=1)

  • Recheck Cond: ((sectionid = sec_3.sectionid) AND (pdpageid = pdp.pdpageid))
177. 0.208 1.415 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.414..1.415 rows=0 loops=1)

178. 1.206 1.206 ↑ 3.1 7,310 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.206..1.206 rows=7,310 loops=1)

  • Index Cond: (sectionid = sec_3.sectionid)
179. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
180. 0.006 0.016 ↑ 21.0 1 1

Hash (cost=43.64..43.64 rows=21 width=20) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
181. 0.003 0.010 ↑ 21.0 1 1

Bitmap Heap Scan on dbpdattribute atr_3 (cost=4.45..43.64 rows=21 width=20) (actual time=0.009..0.010 rows=1 loops=1)

  • Recheck Cond: ((xmlname)::text = 'attr_status_strike_offs'::text)
  • Heap Blocks: exact=1
182. 0.007 0.007 ↑ 21.0 1 1

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((xmlname)::text = 'attr_status_strike_offs'::text)
183. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_10 (cost=0.57..36.73 rows=11 width=536) (never executed)

  • Index Cond: ((rid = pdv_3.referencevalueid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
184. 0.002 1.562 ↓ 0.0 0 1

Nested Loop (cost=974,445.99..1,121,946.08 rows=8 width=516) (actual time=1.562..1.562 rows=0 loops=1)

185. 0.014 1.560 ↓ 0.0 0 1

Hash Join (cost=974,445.43..1,121,909.24 rows=1 width=20) (actual time=1.560..1.560 rows=0 loops=1)

  • Hash Cond: (pda_4.pdattributeid = atr_4.pdattributeid)
186. 0.009 1.528 ↓ 0.0 0 1

Hash Join (cost=974,401.52..1,121,864.77 rows=149 width=40) (actual time=1.527..1.528 rows=0 loops=1)

  • Hash Cond: (pdv_4.pdattributedataid = pda_4.pdattributedataid)
187. 0.008 0.008 ↑ 6,848,928.0 1 1

Seq Scan on dbpdattributedatavalue pdv_4 (cost=0.00..121,778.28 rows=6,848,928 width=40) (actual time=0.007..0.008 rows=1 loops=1)

188. 0.003 1.511 ↓ 0.0 0 1

Hash (cost=974,390.94..974,390.94 rows=847 width=40) (actual time=1.510..1.511 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
189. 0.012 1.508 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=40) (actual time=1.507..1.508 rows=0 loops=1)

  • Hash Cond: (pda_4.pdsectionid = pds_4.pdsectionid)
190. 0.003 0.003 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata pda_4 (cost=0.00..825,719.36 rows=38,855,236 width=60) (actual time=0.003..0.003 rows=1 loops=1)

191. 0.002 1.493 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.493..1.493 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
192. 0.004 1.491 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.491..1.491 rows=0 loops=1)

193. 0.042 0.042 ↑ 2.0 1 1

Seq Scan on dbsection sec_4 (cost=0.00..9.74 rows=2 width=20) (actual time=0.032..0.042 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_status'::text)
  • Rows Removed by Filter: 458
194. 0.008 1.445 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds_4 (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.445..1.445 rows=0 loops=1)

  • Recheck Cond: ((sectionid = sec_4.sectionid) AND (pdpageid = pdp.pdpageid))
195. 0.207 1.437 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.437..1.437 rows=0 loops=1)

196. 1.228 1.228 ↑ 3.1 7,310 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.227..1.228 rows=7,310 loops=1)

  • Index Cond: (sectionid = sec_4.sectionid)
197. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
198. 0.008 0.018 ↑ 21.0 1 1

Hash (cost=43.64..43.64 rows=21 width=20) (actual time=0.017..0.018 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
199. 0.002 0.010 ↑ 21.0 1 1

Bitmap Heap Scan on dbpdattribute atr_4 (cost=4.45..43.64 rows=21 width=20) (actual time=0.009..0.010 rows=1 loops=1)

  • Recheck Cond: ((xmlname)::text = 'attr_status_trims'::text)
  • Heap Blocks: exact=1
200. 0.008 0.008 ↑ 21.0 1 1

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: ((xmlname)::text = 'attr_status_trims'::text)
201. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_11 (cost=0.57..36.73 rows=11 width=536) (never executed)

  • Index Cond: ((rid = pdv_4.referencevalueid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
202. 0.017 1.673 ↑ 1.0 1 1

Aggregate (cost=1,122,059.36..1,122,059.37 rows=1 width=32) (actual time=1.672..1.673 rows=1 loops=1)

203. 0.002 1.656 ↓ 0.0 0 1

Nested Loop Left Join (cost=974,445.99..1,122,059.24 rows=47 width=520) (actual time=1.656..1.656 rows=0 loops=1)

204. 0.015 1.654 ↓ 0.0 0 1

Hash Join (cost=974,445.43..1,121,911.89 rows=4 width=24) (actual time=1.654..1.654 rows=0 loops=1)

  • Hash Cond: (ad.pdattributeid = a_1.pdattributeid)
205. 0.011 1.623 ↓ 0.0 0 1

Hash Right Join (cost=974,401.52..1,121,864.77 rows=847 width=44) (actual time=1.623..1.623 rows=0 loops=1)

  • Hash Cond: (adv.pdattributedataid = ad.pdattributedataid)
206. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

207. 0.003 1.612 ↓ 0.0 0 1

Hash (cost=974,390.94..974,390.94 rows=847 width=44) (actual time=1.611..1.612 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
208. 0.009 1.609 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=44) (actual time=1.609..1.609 rows=0 loops=1)

  • Hash Cond: (ad.pdsectionid = pds_5.pdsectionid)
209. 0.005 0.005 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata ad (cost=0.00..825,719.36 rows=38,855,236 width=64) (actual time=0.004..0.005 rows=1 loops=1)

210. 0.003 1.595 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.594..1.595 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
211. 0.002 1.592 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.591..1.592 rows=0 loops=1)

212. 0.062 0.062 ↑ 2.0 1 1

Seq Scan on dbsection s_1 (cost=0.00..9.74 rows=2 width=20) (actual time=0.059..0.062 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_fabrics'::text)
  • Rows Removed by Filter: 458
213. 0.008 1.528 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds_5 (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.527..1.528 rows=0 loops=1)

  • Recheck Cond: ((sectionid = s_1.sectionid) AND (pdpageid = pdp.pdpageid))
214. 0.207 1.520 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.519..1.520 rows=0 loops=1)

215. 1.313 1.313 ↑ 3.1 7,179 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.313..1.313 rows=7,179 loops=1)

  • Index Cond: (sectionid = s_1.sectionid)
216. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
217. 0.006 0.016 ↑ 21.0 1 1

Hash (cost=43.64..43.64 rows=21 width=20) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
218. 0.004 0.010 ↑ 21.0 1 1

Bitmap Heap Scan on dbpdattribute a_1 (cost=4.45..43.64 rows=21 width=20) (actual time=0.009..0.010 rows=1 loops=1)

  • Recheck Cond: ((xmlname)::text = 'attr_fabric_type'::text)
  • Heap Blocks: exact=1
219. 0.006 0.006 ↑ 21.0 1 1

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((xmlname)::text = 'attr_fabric_type'::text)
220. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription vi (cost=0.57..36.73 rows=11 width=536) (never executed)

  • Index Cond: ((rid = adv.referencevalueid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
221. 0.011 1.479 ↑ 1.0 1 1

Aggregate (cost=4,519,698.49..4,519,698.50 rows=1 width=32) (actual time=1.479..1.479 rows=1 loops=1)

222. 0.002 1.468 ↓ 0.0 0 1

Nested Loop (cost=2,956.25..974,655.63 rows=4 width=540) (actual time=1.468..1.468 rows=0 loops=1)

223. 0.012 1.466 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=560) (actual time=1.466..1.466 rows=0 loops=1)

  • Hash Cond: (ad_1.pdsectionid = pds_6.pdsectionid)
224. 0.004 0.004 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata ad_1 (cost=0.00..825,719.36 rows=38,855,236 width=580) (actual time=0.004..0.004 rows=1 loops=1)

225. 0.001 1.450 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.450..1.450 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
226. 0.002 1.449 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.449..1.449 rows=0 loops=1)

227. 0.038 0.038 ↑ 2.0 1 1

Seq Scan on dbsection s_1_1 (cost=0.00..9.74 rows=2 width=20) (actual time=0.035..0.038 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_fabrics'::text)
  • Rows Removed by Filter: 458
228. 0.007 1.409 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds_6 (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.409..1.409 rows=0 loops=1)

  • Recheck Cond: ((sectionid = s_1_1.sectionid) AND (pdpageid = pdp.pdpageid))
229. 0.216 1.402 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.402..1.402 rows=0 loops=1)

230. 1.183 1.183 ↑ 3.1 7,179 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.183..1.183 rows=7,179 loops=1)

  • Index Cond: (sectionid = s_1_1.sectionid)
231. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
232. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_attribute on dbpdattribute a_2 (cost=0.28..0.30 rows=1 width=20) (never executed)

  • Index Cond: (pdattributeid = ad_1.pdattributeid)
  • Filter: ((xmlname)::text = 'attr_material_composition'::text)
233.          

SubPlan (for Aggregate)

234. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=886,260.69..886,260.71 rows=1 width=32) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=59,164.05..884,391.77 rows=373,784 width=552) (never executed)

  • Hash Cond: (vi_1.rid = adv_1.referencevalueid)
236. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbi18ndescription vi_1 (cost=8,067.73..820,208.92 rows=2,183 width=536) (never executed)

  • Recheck Cond: (languageid = '3064863'::numeric)
  • Filter: ((descriptionkey)::text = 'Description'::text)
237. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_i18ndescription01 (cost=0.00..8,067.19 rows=436,616 width=0) (never executed)

  • Index Cond: (languageid = '3064863'::numeric)
238. 0.000 0.000 ↓ 0.0 0

Hash (cost=50,668.25..50,668.25 rows=34,245 width=56) (never executed)

239. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattributedatavalue adv_1 (cost=793.83..50,668.25 rows=34,245 width=56) (never executed)

  • Recheck Cond: (ad_1.pdattributedataid = pdattributedataid)
240. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_ttrbtdtvl_ttrbtdt_1195 (cost=0.00..785.27 rows=34,245 width=0) (never executed)

  • Index Cond: (ad_1.pdattributedataid = pdattributedataid)
241. 0.003 1.636 ↓ 0.0 0 1

Nested Loop Left Join (cost=974,445.99..1,122,059.24 rows=47 width=516) (actual time=1.636..1.636 rows=0 loops=1)

242. 0.014 1.633 ↓ 0.0 0 1

Hash Join (cost=974,445.43..1,121,911.89 rows=4 width=20) (actual time=1.633..1.633 rows=0 loops=1)

  • Hash Cond: (ad_2.pdattributeid = a_3.pdattributeid)
243. 0.013 1.603 ↓ 0.0 0 1

Hash Right Join (cost=974,401.52..1,121,864.77 rows=847 width=40) (actual time=1.603..1.603 rows=0 loops=1)

  • Hash Cond: (adv_2.pdattributedataid = ad_2.pdattributedataid)
244. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_2 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

245. 0.002 1.590 ↓ 0.0 0 1

Hash (cost=974,390.94..974,390.94 rows=847 width=40) (actual time=1.590..1.590 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
246. 0.010 1.588 ↓ 0.0 0 1

Hash Join (cost=2,955.97..974,390.94 rows=847 width=40) (actual time=1.588..1.588 rows=0 loops=1)

  • Hash Cond: (ad_2.pdsectionid = pds_7.pdsectionid)
247. 0.004 0.004 ↑ 38,855,236.0 1 1

Seq Scan on dbpdattributedata ad_2 (cost=0.00..825,719.36 rows=38,855,236 width=60) (actual time=0.004..0.004 rows=1 loops=1)

248. 0.002 1.574 ↓ 0.0 0 1

Hash (cost=2,954.75..2,954.75 rows=98 width=20) (actual time=1.574..1.574 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
249. 0.003 1.572 ↓ 0.0 0 1

Nested Loop (cost=1,040.05..2,954.75 rows=98 width=20) (actual time=1.572..1.572 rows=0 loops=1)

250. 0.040 0.040 ↑ 2.0 1 1

Seq Scan on dbsection s_1_2 (cost=0.00..9.74 rows=2 width=20) (actual time=0.038..0.040 rows=1 loops=1)

  • Filter: ((xmlname)::text = 'sec_care_label'::text)
  • Rows Removed by Filter: 458
251. 0.011 1.529 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdsection pds_7 (cost=1,040.05..1,471.38 rows=112 width=40) (actual time=1.529..1.529 rows=0 loops=1)

  • Recheck Cond: ((sectionid = s_1_2.sectionid) AND (pdpageid = pdp.pdpageid))
252. 0.208 1.518 ↓ 0.0 0 1

BitmapAnd (cost=1,040.05..1,040.05 rows=112 width=0) (actual time=1.518..1.518 rows=0 loops=1)

253. 1.309 1.309 ↑ 3.1 7,177 1

Bitmap Index Scan on ixpdsection02 (cost=0.00..517.08 rows=22,486 width=0) (actual time=1.309..1.309 rows=7,177 loops=1)

  • Index Cond: (sectionid = s_1_2.sectionid)
254. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on ixpdsection01 (cost=0.00..517.08 rows=22,486 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (pdpageid = pdp.pdpageid)
255. 0.006 0.016 ↑ 21.0 1 1

Hash (cost=43.64..43.64 rows=21 width=20) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
256. 0.003 0.010 ↑ 21.0 1 1

Bitmap Heap Scan on dbpdattribute a_3 (cost=4.45..43.64 rows=21 width=20) (actual time=0.010..0.010 rows=1 loops=1)

  • Recheck Cond: ((xmlname)::text = 'attr_made_in'::text)
  • Heap Blocks: exact=1
257. 0.007 0.007 ↑ 21.0 1 1

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((xmlname)::text = 'attr_made_in'::text)
258. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription vi_2 (cost=0.57..36.73 rows=11 width=536) (never executed)

  • Index Cond: ((rid = adv_2.referencevalueid) AND (languageid = '3064863'::numeric) AND ((descriptionkey)::text = 'Description'::text))
259. 0.032 78.561 ↓ 0.0 0 1

Nested Loop (cost=41.87..3,661.13 rows=1 width=146) (actual time=78.560..78.561 rows=0 loops=1)

  • Join Filter: ((sre.proc_def_id_)::text = (srp.id_)::text)
260. 0.025 0.025 ↓ 8.0 8 1

Seq Scan on act_re_procdef srp (cost=0.00..1.32 rows=1 width=146) (actual time=0.009..0.025 rows=8 loops=1)

  • Filter: ((key_)::text = 'SampleRequest'::text)
  • Rows Removed by Filter: 18
261. 0.016 78.504 ↓ 0.0 0 8

Nested Loop (cost=41.87..3,659.69 rows=9 width=146) (actual time=9.813..9.813 rows=0 loops=8)

262. 65.168 78.488 ↓ 0.0 0 8

Bitmap Heap Scan on act_ru_variable srv (cost=41.58..3,584.83 rows=9 width=146) (actual time=9.811..9.811 rows=0 loops=8)

  • Recheck Cond: ((name_)::text = 'sampleId'::text)
  • Filter: ((long_)::numeric = se.smsampleevalpageid)
  • Rows Removed by Filter: 17,348
  • Heap Blocks: exact=38,304
263. 13.320 13.320 ↓ 9.9 17,350 8

Bitmap Index Scan on act_idx_var_name (cost=0.00..41.58 rows=1,754 width=0) (actual time=1.665..1.665 rows=17,350 loops=8)

  • Index Cond: ((name_)::text = 'sampleId'::text)
264. 0.000 0.000 ↓ 0.0 0

Index Scan using act_ru_execution_pkey on act_ru_execution sre (cost=0.29..8.31 rows=1 width=292) (never executed)

  • Index Cond: ((id_)::text = (srv.execution_id_)::text)
265. 0.002 19,251.991 ↓ 0.0 0 1

Limit (cost=116.83..1,237.81 rows=1 width=146) (actual time=19,251.990..19,251.991 rows=0 loops=1)

266. 0.004 19,251.989 ↓ 0.0 0 1

Nested Loop Left Join (cost=116.83..4,600.75 rows=4 width=146) (actual time=19,251.988..19,251.989 rows=0 loops=1)

  • Join Filter: ((sre_1.proc_def_id_)::text = (srp_1.id_)::text)
267. 0.004 19,251.985 ↓ 0.0 0 1

Nested Loop Left Join (cost=116.83..4,599.36 rows=4 width=146) (actual time=19,251.985..19,251.985 rows=0 loops=1)

268. 21.201 19,251.981 ↓ 0.0 0 1

Nested Loop Semi Join (cost=116.54..4,566.09 rows=4 width=146) (actual time=19,251.981..19,251.981 rows=0 loops=1)

269. 16.815 18.684 ↓ 1,002.7 9,024 1

Bitmap Heap Scan on act_ru_variable srv_1 (cost=41.58..3,576.06 rows=9 width=292) (actual time=2.540..18.684 rows=9,024 loops=1)

  • Recheck Cond: ((name_)::text = 'sampleId'::text)
  • Filter: (long_ IS NULL)
  • Rows Removed by Filter: 8,324
  • Heap Blocks: exact=4,788
270. 1.869 1.869 ↓ 9.9 17,350 1

Bitmap Index Scan on act_idx_var_name (cost=0.00..41.58 rows=1,754 width=0) (actual time=1.869..1.869 rows=17,350 loops=1)

  • Index Cond: ((name_)::text = 'sampleId'::text)
271. 27.072 19,212.096 ↓ 0.0 0 9,024

Bitmap Heap Scan on act_ru_variable (cost=74.96..109.99 rows=1 width=146) (actual time=2.129..2.129 rows=0 loops=9,024)

  • Recheck Cond: (((proc_inst_id_)::text = (srv_1.proc_inst_id_)::text) AND ((name_)::text = 'productId'::text))
  • Filter: ((long_)::numeric = ss.smstylesupplierid)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=9,024
272. 27.072 19,185.024 ↓ 0.0 0 9,024

BitmapAnd (cost=74.96..74.96 rows=9 width=0) (actual time=2.126..2.126 rows=0 loops=9,024)

273. 81.216 81.216 ↑ 125.3 14 9,024

Bitmap Index Scan on act_idx_var_procinst (cost=0.00..33.13 rows=1,754 width=0) (actual time=0.009..0.009 rows=14 loops=9,024)

  • Index Cond: ((proc_inst_id_)::text = (srv_1.proc_inst_id_)::text)
274. 19,076.736 19,076.736 ↓ 13.8 24,137 9,024

Bitmap Index Scan on act_idx_var_name (cost=0.00..41.58 rows=1,754 width=0) (actual time=2.114..2.114 rows=24,137 loops=9,024)

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

Index Scan using act_ru_execution_pkey on act_ru_execution sre_1 (cost=0.29..8.31 rows=1 width=292) (never executed)

  • Index Cond: ((id_)::text = (srv_1.execution_id_)::text)
276. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.33 rows=1 width=146) (never executed)

277. 0.000 0.000 ↓ 0.0 0

Seq Scan on act_re_procdef srp_1 (cost=0.00..1.32 rows=1 width=146) (never executed)

  • Filter: ((key_)::text = 'SampleRequest'::text)
278. 0.037 117.956 ↓ 0.0 0 1

Nested Loop (cost=41.87..3,661.13 rows=1 width=146) (actual time=117.956..117.956 rows=0 loops=1)

  • Join Filter: ((pae.proc_def_id_)::text = (pap.id_)::text)
279. 0.031 0.031 ↓ 8.0 8 1

Seq Scan on act_re_procdef pap (cost=0.00..1.32 rows=1 width=146) (actual time=0.017..0.031 rows=8 loops=1)

  • Filter: ((key_)::text = 'PrototypeApproval'::text)
  • Rows Removed by Filter: 18
280. 0.008 117.888 ↓ 0.0 0 8

Nested Loop (cost=41.87..3,659.69 rows=9 width=146) (actual time=14.736..14.736 rows=0 loops=8)

281. 100.872 117.880 ↓ 0.0 0 8

Bitmap Heap Scan on act_ru_variable pav (cost=41.58..3,584.83 rows=9 width=146) (actual time=14.735..14.735 rows=0 loops=8)

  • Recheck Cond: ((name_)::text = 'productId'::text)
  • Filter: ((long_)::numeric = ss.smstylesupplierid)
  • Rows Removed by Filter: 24,136
  • Heap Blocks: exact=39,712
282. 17.008 17.008 ↓ 13.8 24,137 8

Bitmap Index Scan on act_idx_var_name (cost=0.00..41.58 rows=1,754 width=0) (actual time=2.126..2.126 rows=24,137 loops=8)

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

Index Scan using act_ru_execution_pkey on act_ru_execution pae (cost=0.29..8.31 rows=1 width=292) (never executed)

  • Index Cond: ((id_)::text = (pav.execution_id_)::text)
284. 0.003 0.038 ↓ 0.0 0 1

Nested Loop (cost=3.32..53.33 rows=11 width=32) (actual time=0.037..0.038 rows=0 loops=1)

285.          

Initplan (for Nested Loop)

286. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
287. 0.035 0.035 ↓ 0.0 0 1

Seq Scan on dbsmkeyfield3 dkf (cost=0.00..1.77 rows=1 width=20) (actual time=0.035..0.035 rows=0 loops=1)

  • Filter: (smkeyfieldid = ss.keyfield3)
  • Rows Removed by Filter: 62
288. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_12 (cost=0.57..48.69 rows=11 width=536) (never executed)

  • Index Cond: ((rid = ss.keyfield3) AND (languageid = $54) AND ((descriptionkey)::text = 'Description'::text))
289. 0.003 0.040 ↓ 0.0 0 1

Nested Loop (cost=3.32..56.37 rows=11 width=32) (actual time=0.039..0.040 rows=0 loops=1)

290.          

Initplan (for Nested Loop)

291. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
292. 0.037 0.037 ↓ 0.0 0 1

Seq Scan on dbsmkeyfield2 dkf_1 (cost=0.00..4.76 rows=1 width=78) (actual time=0.037..0.037 rows=0 loops=1)

  • Filter: (smkeyfieldid = ss.keyfield2)
  • Rows Removed by Filter: 221
293. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_13 (cost=0.57..48.69 rows=11 width=536) (never executed)

  • Index Cond: ((rid = ss.keyfield2) AND (languageid = $56) AND ((descriptionkey)::text = 'Description'::text))
294. 0.003 29,495.407 ↓ 0.0 0 1

Limit (cost=5,025.83..5,025.84 rows=1 width=8) (actual time=29,495.406..29,495.407 rows=0 loops=1)

295. 0.017 29,495.404 ↓ 0.0 0 1

Sort (cost=5,025.83..5,025.84 rows=1 width=8) (actual time=29,495.404..29,495.404 rows=0 loops=1)

  • Sort Key: m.due_date
  • Sort Method: quicksort Memory: 25kB
296. 0.002 29,495.387 ↓ 0.0 0 1

Nested Loop Anti Join (cost=77.12..5,025.82 rows=1 width=8) (actual time=29,495.387..29,495.387 rows=0 loops=1)

297. 0.001 29,495.385 ↓ 0.0 0 1

Nested Loop (cost=76.69..5,014.33 rows=1 width=154) (actual time=29,495.384..29,495.385 rows=0 loops=1)

  • Join Filter: ((ahp.proc_def_id_)::text = (arp.id_)::text)
298. 26.440 29,495.384 ↓ 0.0 0 1

Nested Loop (cost=76.69..5,013.00 rows=1 width=300) (actual time=29,495.383..29,495.384 rows=0 loops=1)

299. 43.408 29,313.352 ↓ 17,288.0 17,288 1

Nested Loop (cost=76.27..5,010.47 rows=1 width=312) (actual time=5.079..29,313.352 rows=17,288 loops=1)

300. 57.386 29,165.856 ↓ 17,348.0 17,348 1

Nested Loop (cost=75.85..5,008.27 rows=1 width=300) (actual time=2.726..29,165.856 rows=17,348 loops=1)

301. 94.400 94.400 ↓ 17,510.0 17,510 1

Seq Scan on act_hi_procinst ahp (cost=0.00..4,897.35 rows=1 width=292) (actual time=0.024..94.400 rows=17,510 loops=1)

  • Filter: ((end_act_id_ IS NULL) AND ((proc_def_id_)::text ~~* 'SampleRequest:%'::text))
  • Rows Removed by Filter: 97,158
302. 70.040 29,014.070 ↑ 9.0 1 17,510

Bitmap Heap Scan on act_ru_variable ahv_sample_request (cost=75.85..110.83 rows=9 width=154) (actual time=1.656..1.657 rows=1 loops=17,510)

  • Recheck Cond: (((proc_inst_id_)::text = (ahp.proc_inst_id_)::text) AND ((name_)::text = 'sampleRequestId'::text))
  • Heap Blocks: exact=17,348
303. 40.804 28,944.030 ↓ 0.0 0 17,510

BitmapAnd (cost=75.85..75.85 rows=9 width=0) (actual time=1.653..1.653 rows=0 loops=17,510)

304. 157.590 157.590 ↑ 125.3 14 17,510

Bitmap Index Scan on act_idx_var_procinst (cost=0.00..33.58 rows=1,754 width=0) (actual time=0.009..0.009 rows=14 loops=17,510)

  • Index Cond: ((proc_inst_id_)::text = (ahp.proc_inst_id_)::text)
305. 28,745.636 28,745.636 ↓ 9.9 17,349 17,348

Bitmap Index Scan on act_idx_var_name (cost=0.00..41.58 rows=1,754 width=0) (actual time=1.657..1.657 rows=17,349 loops=17,348)

  • Index Cond: ((name_)::text = 'sampleRequestId'::text)
306. 104.088 104.088 ↑ 1.0 1 17,348

Index Scan using pk_smplrqst on dbsmsamplerequest sr_1 (cost=0.42..2.18 rows=1 width=40) (actual time=0.005..0.006 rows=1 loops=17,348)

  • Index Cond: (smsamplerequestid = (ahv_sample_request.long_)::numeric)
307. 155.592 155.592 ↓ 0.0 0 17,288

Index Scan using pk_smmessage on dbsmmessage m (cost=0.43..2.52 rows=1 width=28) (actual time=0.009..0.009 rows=0 loops=17,288)

  • Index Cond: (smmessageid = sr_1.smmessageid)
  • Filter: (smstylesupplierid = ss.smstylesupplierid)
  • Rows Removed by Filter: 1
308. 0.000 0.000 ↓ 0.0 0

Seq Scan on act_re_procdef arp (cost=0.00..1.32 rows=1 width=146) (never executed)

  • Filter: ((key_)::text = 'SampleRequest'::text)
309. 0.000 0.000 ↓ 0.0 0

Index Scan using act_idx_hi_procvar_proc_inst on act_hi_varinst ahv_sample (cost=0.43..261.84 rows=47 width=146) (never executed)

  • Index Cond: ((proc_inst_id_)::text = (ahv_sample_request.proc_inst_id_)::text)
  • Filter: ((long_ IS NOT NULL) AND ((name_)::text = 'sampleId'::text))
310. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on dbsmffpdecision ffpd (cost=0.00..2.08 rows=1 width=32) (actual time=0.017..0.018 rows=0 loops=1)

  • Filter: (smffpdecisionid = ss.ffpdecision)
  • Rows Removed by Filter: 86
311. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=3.32..53.63 rows=11 width=32) (actual time=0.010..0.010 rows=0 loops=1)

312.          

Initplan (for Nested Loop)

313. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
314. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on dbsmffpdecision ffpd_1 (cost=0.00..2.08 rows=1 width=20) (actual time=0.009..0.010 rows=0 loops=1)

  • Filter: (smffpdecisionid = ss.ffpdecision)
  • Rows Removed by Filter: 86
315. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i18_14 (cost=0.57..48.69 rows=11 width=536) (never executed)

  • Index Cond: ((rid = ss.ffpdecision) AND (languageid = $64) AND ((descriptionkey)::text = 'Description'::text))
316. 0.011 5.517 ↓ 0.0 0 1

Group (cost=79.09..54,689,549,749.85 rows=20,000 width=72) (actual time=5.517..5.517 rows=0 loops=1)

  • Group Key: st.smstylesupplierid, l.languageid
317. 0.004 5.506 ↓ 0.0 0 1

Nested Loop (cost=79.09..1,184,583.67 rows=430,379 width=40) (actual time=5.506..5.506 rows=0 loops=1)

318. 0.041 0.041 ↑ 1.0 1 1

Index Scan using pk_language on dblanguage la (cost=0.14..14.59 rows=1 width=20) (actual time=0.019..0.041 rows=1 loops=1)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
319. 0.002 5.461 ↓ 0.0 0 1

Nested Loop (cost=78.94..1,181,556.53 rows=301,254 width=40) (actual time=5.461..5.461 rows=0 loops=1)

320. 5.459 5.459 ↓ 0.0 0 1

Seq Scan on dbsmentitystatus st (cost=0.00..576.51 rows=138 width=40) (actual time=5.459..5.459 rows=0 loops=1)

  • Filter: (smstylesupplierid = ss.smstylesupplierid)
  • Rows Removed by Filter: 27,641
321. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbi18ndescription l (cost=78.94..8,536.00 rows=2,183 width=40) (never executed)

  • Recheck Cond: ((rid = st.smstatusid) AND (languageid = la.languageid))
322. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_18ndscrptn (cost=0.00..78.40 rows=2,183 width=0) (never executed)

  • Index Cond: ((rid = st.smstatusid) AND (languageid = la.languageid))
323.          

SubPlan (for Group)

324. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=834,233.60..834,235.60 rows=200 width=516) (never executed)

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

Hash Join (cost=10,685.82..833,480.44 rows=301,265 width=516) (never executed)

  • Hash Cond: (lang_1.rid = es.smstatusid)
326. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbi18ndescription lang_1 (cost=8,176.34..819,225.99 rows=436,616 width=536) (never executed)

  • Recheck Cond: (languageid = l.languageid)
327. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_i18ndescription01 (cost=0.00..8,067.19 rows=436,616 width=0) (never executed)

  • Index Cond: (languageid = l.languageid)
328. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,507.76..2,507.76 rows=138 width=20) (never executed)

329. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..2,507.76 rows=138 width=20) (never executed)

330. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..1,744.34 rows=138 width=40) (never executed)

331. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

Group (cost=1,061,427.96..1,065,946.94 rows=301,265 width=784) (never executed)

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

Sort (cost=1,061,427.96..1,062,181.13 rows=301,265 width=752) (never executed)

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

Hash Join (cost=11,451.22..834,245.83 rows=301,265 width=752) (never executed)

  • Hash Cond: (lang_1_1.rid = es_1.smstatusid)
337. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbi18ndescription lang_1_1 (cost=8,176.34..819,225.99 rows=436,616 width=536) (never executed)

  • Recheck Cond: (languageid = l.languageid)
338. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_i18ndescription01 (cost=0.00..8,067.19 rows=436,616 width=0) (never executed)

  • Index Cond: (languageid = l.languageid)
339. 0.000 0.000 ↓ 0.0 0

Hash (cost=3,273.15..3,273.15 rows=138 width=256) (never executed)

340. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.30..3,273.15 rows=138 width=256) (never executed)

341. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..2,513.09 rows=138 width=98) (never executed)

342. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..1,744.34 rows=138 width=40) (never executed)

343. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

HashAggregate (cost=834,233.60..834,235.60 rows=200 width=516) (never executed)

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

Hash Join (cost=10,685.82..833,480.44 rows=301,265 width=516) (never executed)

  • Hash Cond: (lang_1_2.rid = es_2.smstatusid)
349. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbi18ndescription lang_1_2 (cost=8,176.34..819,225.99 rows=436,616 width=536) (never executed)

  • Recheck Cond: (languageid = l.languageid)
350. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_i18ndescription01 (cost=0.00..8,067.19 rows=436,616 width=0) (never executed)

  • Index Cond: (languageid = l.languageid)
351. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,507.76..2,507.76 rows=138 width=20) (never executed)

352. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..2,507.76 rows=138 width=20) (never executed)

353. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..1,744.34 rows=138 width=40) (never executed)

354. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: (smskuid = ssk_2.smskuid)
  • Heap Fetches: 0
357. 0.003 0.066 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,853.25 rows=16 width=516) (actual time=0.066..0.066 rows=0 loops=1)

358. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on dblanguage l_2 (cost=0.00..2.75 rows=1 width=20) (actual time=0.009..0.020 rows=1 loops=1)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
359. 0.002 0.043 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,850.39 rows=11 width=536) (actual time=0.043..0.043 rows=0 loops=1)

360. 0.009 0.041 ↓ 0.0 0 1

Hash Join (cost=987,935.35..422,307,801.59 rows=1 width=20) (actual time=0.040..0.041 rows=0 loops=1)

  • Hash Cond: (s_3.pdpageid = p_3.pdpageid)
  • Join Filter: ((SubPlan 42) = p_3.editdate)
361. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=982,868.29..1,447,781.07 rows=34,842 width=258) (never executed)

362. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=982,867.86..1,244,644.04 rows=34,842 width=258) (never executed)

  • Hash Cond: (adv_4.pdattributedataid = ad_4.pdattributedataid)
363. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_4 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

364. 0.000 0.000 ↓ 0.0 0

Hash (cost=973,447.05..973,447.05 rows=197,665 width=258) (never executed)

365. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=43.90..973,447.05 rows=197,665 width=258) (never executed)

  • Hash Cond: (ad_4.pdattributeid = at_1.pdattributeid)
366. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_4 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

367. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=238) (never executed)

368. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at_1 (cost=4.45..43.64 rows=21 width=238) (never executed)

  • Recheck Cond: ((xmlname)::text = 'attr_status_care_label'::text)
369. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = 'attr_status_care_label'::text)
370. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_pdsection on dbpdsection s_3 (cost=0.43..5.82 rows=1 width=40) (never executed)

  • Index Cond: (pdsectionid = ad_4.pdsectionid)
371. 0.004 0.032 ↓ 0.0 0 1

Hash (cost=5,041.81..5,041.81 rows=2,020 width=48) (actual time=0.031..0.032 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
372. 0.007 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdpage p_3 (cost=48.08..5,041.81 rows=2,020 width=48) (actual time=0.027..0.028 rows=0 loops=1)

  • Recheck Cond: (smstylesupplierid = ss.smstylesupplierid)
373. 0.021 0.021 ↓ 0.0 0 1

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
374.          

SubPlan (for Hash Join)

375. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2,418,705.86..2,418,705.87 rows=1 width=8) (never executed)

376. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,079,124.08..2,417,756.22 rows=379,856 width=8) (never executed)

377. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,079,123.52..1,226,587.02 rows=174 width=28) (never executed)

  • Hash Cond: (adv_3.pdattributedataid = ad_3.pdattributedataid)
378. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_3 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

379. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,079,111.17..1,079,111.17 rows=988 width=28) (never executed)

380. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=105,003.87..1,079,111.17 rows=988 width=28) (never executed)

  • Hash Cond: (ad_3.pdattributeid = at.pdattributeid)
381. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=104,959.96..1,078,328.95 rows=194,249 width=48) (never executed)

  • Hash Cond: (ad_3.pdsectionid = s_2.pdsectionid)
382. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_3 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

383. 0.000 0.000 ↓ 0.0 0

Hash (cost=104,678.93..104,678.93 rows=22,483 width=28) (never executed)

384. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5,067.06..104,678.93 rows=22,483 width=28) (never executed)

  • Hash Cond: (s_2.pdpageid = p_2.pdpageid)
385. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdsection s_2 (cost=0.00..82,522.39 rows=4,497,239 width=40) (never executed)

386. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,041.81..5,041.81 rows=2,020 width=28) (never executed)

387. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdpage p_2 (cost=48.08..5,041.81 rows=2,020 width=28) (never executed)

  • Recheck Cond: (smstylesupplierid = p_3.smstylesupplierid)
388. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (never executed)

  • Index Cond: (smstylesupplierid = p_3.smstylesupplierid)
389. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=20) (never executed)

390. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at (cost=4.45..43.64 rows=21 width=20) (never executed)

  • Recheck Cond: ((xmlname)::text = (at_1.xmlname)::text)
391. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = (at_1.xmlname)::text)
392. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..6,830.40 rows=1,540 width=20) (never executed)

393. 0.000 0.000 ↓ 0.0 0

Seq Scan on dblanguage l_1 (cost=0.00..2.40 rows=140 width=20) (never executed)

394. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_18ndscrptn on dbi18ndescription i (cost=0.57..48.66 rows=11 width=40) (never executed)

  • Index Cond: ((rid = adv_3.referencevalueid) AND (languageid = l_1.languageid) AND (descriptionkey = 'Description'::text))
  • Heap Fetches: 0
395. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_1 (cost=0.57..48.69 rows=11 width=556) (never executed)

  • Index Cond: ((rid = adv_4.referencevalueid) AND (languageid = l_2.languageid) AND ((descriptionkey)::text = 'Description'::text))
396. 0.004 0.038 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,853.25 rows=16 width=516) (actual time=0.037..0.038 rows=0 loops=1)

397. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on dblanguage l_4 (cost=0.00..2.75 rows=1 width=20) (actual time=0.007..0.018 rows=1 loops=1)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
398. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,850.39 rows=11 width=536) (actual time=0.015..0.016 rows=0 loops=1)

399. 0.006 0.014 ↓ 0.0 0 1

Hash Join (cost=987,935.35..422,307,801.59 rows=1 width=20) (actual time=0.013..0.014 rows=0 loops=1)

  • Hash Cond: (s_5.pdpageid = p_5.pdpageid)
  • Join Filter: ((SubPlan 44) = p_5.editdate)
400. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=982,868.29..1,447,781.07 rows=34,842 width=258) (never executed)

401. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=982,867.86..1,244,644.04 rows=34,842 width=258) (never executed)

  • Hash Cond: (adv_6.pdattributedataid = ad_6.pdattributedataid)
402. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_6 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

403. 0.000 0.000 ↓ 0.0 0

Hash (cost=973,447.05..973,447.05 rows=197,665 width=258) (never executed)

404. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=43.90..973,447.05 rows=197,665 width=258) (never executed)

  • Hash Cond: (ad_6.pdattributeid = at_3.pdattributeid)
405. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_6 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

406. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=238) (never executed)

407. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at_3 (cost=4.45..43.64 rows=21 width=238) (never executed)

  • Recheck Cond: ((xmlname)::text = 'attr_status_details'::text)
408. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = 'attr_status_details'::text)
409. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_pdsection on dbpdsection s_5 (cost=0.43..5.82 rows=1 width=40) (never executed)

  • Index Cond: (pdsectionid = ad_6.pdsectionid)
410. 0.001 0.008 ↓ 0.0 0 1

Hash (cost=5,041.81..5,041.81 rows=2,020 width=48) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
411. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdpage p_5 (cost=48.08..5,041.81 rows=2,020 width=48) (actual time=0.006..0.007 rows=0 loops=1)

  • Recheck Cond: (smstylesupplierid = ss.smstylesupplierid)
412. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
413.          

SubPlan (for Hash Join)

414. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2,418,705.86..2,418,705.87 rows=1 width=8) (never executed)

415. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,079,124.08..2,417,756.22 rows=379,856 width=8) (never executed)

416. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,079,123.52..1,226,587.02 rows=174 width=28) (never executed)

  • Hash Cond: (adv_5.pdattributedataid = ad_5.pdattributedataid)
417. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_5 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

418. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,079,111.17..1,079,111.17 rows=988 width=28) (never executed)

419. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=105,003.87..1,079,111.17 rows=988 width=28) (never executed)

  • Hash Cond: (ad_5.pdattributeid = at_2.pdattributeid)
420. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=104,959.96..1,078,328.95 rows=194,249 width=48) (never executed)

  • Hash Cond: (ad_5.pdsectionid = s_4.pdsectionid)
421. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_5 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

422. 0.000 0.000 ↓ 0.0 0

Hash (cost=104,678.93..104,678.93 rows=22,483 width=28) (never executed)

423. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5,067.06..104,678.93 rows=22,483 width=28) (never executed)

  • Hash Cond: (s_4.pdpageid = p_4.pdpageid)
424. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdsection s_4 (cost=0.00..82,522.39 rows=4,497,239 width=40) (never executed)

425. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,041.81..5,041.81 rows=2,020 width=28) (never executed)

426. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdpage p_4 (cost=48.08..5,041.81 rows=2,020 width=28) (never executed)

  • Recheck Cond: (smstylesupplierid = p_5.smstylesupplierid)
427. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (never executed)

  • Index Cond: (smstylesupplierid = p_5.smstylesupplierid)
428. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=20) (never executed)

429. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at_2 (cost=4.45..43.64 rows=21 width=20) (never executed)

  • Recheck Cond: ((xmlname)::text = (at_3.xmlname)::text)
430. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = (at_3.xmlname)::text)
431. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..6,830.40 rows=1,540 width=20) (never executed)

432. 0.000 0.000 ↓ 0.0 0

Seq Scan on dblanguage l_3 (cost=0.00..2.40 rows=140 width=20) (never executed)

433. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_18ndscrptn on dbi18ndescription i_2 (cost=0.57..48.66 rows=11 width=40) (never executed)

  • Index Cond: ((rid = adv_5.referencevalueid) AND (languageid = l_3.languageid) AND (descriptionkey = 'Description'::text))
  • Heap Fetches: 0
434. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_3 (cost=0.57..48.69 rows=11 width=556) (never executed)

  • Index Cond: ((rid = adv_6.referencevalueid) AND (languageid = l_4.languageid) AND ((descriptionkey)::text = 'Description'::text))
435. 0.001 0.035 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,853.25 rows=16 width=516) (actual time=0.035..0.035 rows=0 loops=1)

436. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on dblanguage l_6 (cost=0.00..2.75 rows=1 width=20) (actual time=0.007..0.019 rows=1 loops=1)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
437. 0.003 0.015 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,850.39 rows=11 width=536) (actual time=0.014..0.015 rows=0 loops=1)

438. 0.004 0.012 ↓ 0.0 0 1

Hash Join (cost=987,935.35..422,307,801.59 rows=1 width=20) (actual time=0.011..0.012 rows=0 loops=1)

  • Hash Cond: (s_7.pdpageid = p_7.pdpageid)
  • Join Filter: ((SubPlan 46) = p_7.editdate)
439. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=982,868.29..1,447,781.07 rows=34,842 width=258) (never executed)

440. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=982,867.86..1,244,644.04 rows=34,842 width=258) (never executed)

  • Hash Cond: (adv_8.pdattributedataid = ad_8.pdattributedataid)
441. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_8 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

442. 0.000 0.000 ↓ 0.0 0

Hash (cost=973,447.05..973,447.05 rows=197,665 width=258) (never executed)

443. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=43.90..973,447.05 rows=197,665 width=258) (never executed)

  • Hash Cond: (ad_8.pdattributeid = at_5.pdattributeid)
444. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_8 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

445. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=238) (never executed)

446. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at_5 (cost=4.45..43.64 rows=21 width=238) (never executed)

  • Recheck Cond: ((xmlname)::text = 'attr_status_fabric'::text)
447. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = 'attr_status_fabric'::text)
448. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_pdsection on dbpdsection s_7 (cost=0.43..5.82 rows=1 width=40) (never executed)

  • Index Cond: (pdsectionid = ad_8.pdsectionid)
449. 0.003 0.008 ↓ 0.0 0 1

Hash (cost=5,041.81..5,041.81 rows=2,020 width=48) (actual time=0.007..0.008 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
450. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdpage p_7 (cost=48.08..5,041.81 rows=2,020 width=48) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (smstylesupplierid = ss.smstylesupplierid)
451. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
452.          

SubPlan (for Hash Join)

453. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2,418,705.86..2,418,705.87 rows=1 width=8) (never executed)

454. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,079,124.08..2,417,756.22 rows=379,856 width=8) (never executed)

455. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,079,123.52..1,226,587.02 rows=174 width=28) (never executed)

  • Hash Cond: (adv_7.pdattributedataid = ad_7.pdattributedataid)
456. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_7 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

457. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,079,111.17..1,079,111.17 rows=988 width=28) (never executed)

458. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=105,003.87..1,079,111.17 rows=988 width=28) (never executed)

  • Hash Cond: (ad_7.pdattributeid = at_4.pdattributeid)
459. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=104,959.96..1,078,328.95 rows=194,249 width=48) (never executed)

  • Hash Cond: (ad_7.pdsectionid = s_6.pdsectionid)
460. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_7 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

461. 0.000 0.000 ↓ 0.0 0

Hash (cost=104,678.93..104,678.93 rows=22,483 width=28) (never executed)

462. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5,067.06..104,678.93 rows=22,483 width=28) (never executed)

  • Hash Cond: (s_6.pdpageid = p_6.pdpageid)
463. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdsection s_6 (cost=0.00..82,522.39 rows=4,497,239 width=40) (never executed)

464. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,041.81..5,041.81 rows=2,020 width=28) (never executed)

465. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdpage p_6 (cost=48.08..5,041.81 rows=2,020 width=28) (never executed)

  • Recheck Cond: (smstylesupplierid = p_7.smstylesupplierid)
466. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (never executed)

  • Index Cond: (smstylesupplierid = p_7.smstylesupplierid)
467. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=20) (never executed)

468. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at_4 (cost=4.45..43.64 rows=21 width=20) (never executed)

  • Recheck Cond: ((xmlname)::text = (at_5.xmlname)::text)
469. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = (at_5.xmlname)::text)
470. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..6,830.40 rows=1,540 width=20) (never executed)

471. 0.000 0.000 ↓ 0.0 0

Seq Scan on dblanguage l_5 (cost=0.00..2.40 rows=140 width=20) (never executed)

472. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_18ndscrptn on dbi18ndescription i_4 (cost=0.57..48.66 rows=11 width=40) (never executed)

  • Index Cond: ((rid = adv_7.referencevalueid) AND (languageid = l_5.languageid) AND (descriptionkey = 'Description'::text))
  • Heap Fetches: 0
473. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_5 (cost=0.57..48.69 rows=11 width=556) (never executed)

  • Index Cond: ((rid = adv_8.referencevalueid) AND (languageid = l_6.languageid) AND ((descriptionkey)::text = 'Description'::text))
474. 0.001 0.034 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,853.25 rows=16 width=516) (actual time=0.033..0.034 rows=0 loops=1)

475. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on dblanguage l_8 (cost=0.00..2.75 rows=1 width=20) (actual time=0.007..0.019 rows=1 loops=1)

  • Filter: ((languageisocode)::text = (lang.languageisocode)::text)
  • Rows Removed by Filter: 139
476. 0.004 0.014 ↓ 0.0 0 1

Nested Loop (cost=987,935.92..422,307,850.39 rows=11 width=536) (actual time=0.013..0.014 rows=0 loops=1)

477. 0.003 0.010 ↓ 0.0 0 1

Hash Join (cost=987,935.35..422,307,801.59 rows=1 width=20) (actual time=0.010..0.010 rows=0 loops=1)

  • Hash Cond: (s_9.pdpageid = p_9.pdpageid)
  • Join Filter: ((SubPlan 48) = p_9.editdate)
478. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=982,868.29..1,447,781.07 rows=34,842 width=258) (never executed)

479. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=982,867.86..1,244,644.04 rows=34,842 width=258) (never executed)

  • Hash Cond: (adv_10.pdattributedataid = ad_10.pdattributedataid)
480. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_10 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

481. 0.000 0.000 ↓ 0.0 0

Hash (cost=973,447.05..973,447.05 rows=197,665 width=258) (never executed)

482. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=43.90..973,447.05 rows=197,665 width=258) (never executed)

  • Hash Cond: (ad_10.pdattributeid = at_7.pdattributeid)
483. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_10 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

484. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=238) (never executed)

485. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at_7 (cost=4.45..43.64 rows=21 width=238) (never executed)

  • Recheck Cond: ((xmlname)::text = 'attr_status_others'::text)
486. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = 'attr_status_others'::text)
487. 0.000 0.000 ↓ 0.0 0

Index Scan using ixpk_pdsection on dbpdsection s_9 (cost=0.43..5.82 rows=1 width=40) (never executed)

  • Index Cond: (pdsectionid = ad_10.pdsectionid)
488. 0.003 0.007 ↓ 0.0 0 1

Hash (cost=5,041.81..5,041.81 rows=2,020 width=48) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 16kB
489. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on dbpdpage p_9 (cost=48.08..5,041.81 rows=2,020 width=48) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (smstylesupplierid = ss.smstylesupplierid)
490. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
491.          

SubPlan (for Hash Join)

492. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2,418,705.86..2,418,705.87 rows=1 width=8) (never executed)

493. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,079,124.08..2,417,756.22 rows=379,856 width=8) (never executed)

494. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,079,123.52..1,226,587.02 rows=174 width=28) (never executed)

  • Hash Cond: (adv_9.pdattributedataid = ad_9.pdattributedataid)
495. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedatavalue adv_9 (cost=0.00..121,778.28 rows=6,848,928 width=40) (never executed)

496. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,079,111.17..1,079,111.17 rows=988 width=28) (never executed)

497. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=105,003.87..1,079,111.17 rows=988 width=28) (never executed)

  • Hash Cond: (ad_9.pdattributeid = at_6.pdattributeid)
498. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=104,959.96..1,078,328.95 rows=194,249 width=48) (never executed)

  • Hash Cond: (ad_9.pdsectionid = s_8.pdsectionid)
499. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdattributedata ad_9 (cost=0.00..825,719.36 rows=38,855,236 width=60) (never executed)

500. 0.000 0.000 ↓ 0.0 0

Hash (cost=104,678.93..104,678.93 rows=22,483 width=28) (never executed)

501. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5,067.06..104,678.93 rows=22,483 width=28) (never executed)

  • Hash Cond: (s_8.pdpageid = p_8.pdpageid)
502. 0.000 0.000 ↓ 0.0 0

Seq Scan on dbpdsection s_8 (cost=0.00..82,522.39 rows=4,497,239 width=40) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,041.81..5,041.81 rows=2,020 width=28) (never executed)

504. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdpage p_8 (cost=48.08..5,041.81 rows=2,020 width=28) (never executed)

  • Recheck Cond: (smstylesupplierid = p_9.smstylesupplierid)
505. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fk_pdpage_stls (cost=0.00..47.57 rows=2,020 width=0) (never executed)

  • Index Cond: (smstylesupplierid = p_9.smstylesupplierid)
506. 0.000 0.000 ↓ 0.0 0

Hash (cost=43.64..43.64 rows=21 width=20) (never executed)

507. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dbpdattribute at_6 (cost=4.45..43.64 rows=21 width=20) (never executed)

  • Recheck Cond: ((xmlname)::text = (at_7.xmlname)::text)
508. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_xmlname (cost=0.00..4.44 rows=21 width=0) (never executed)

  • Index Cond: ((xmlname)::text = (at_7.xmlname)::text)
509. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..6,830.40 rows=1,540 width=20) (never executed)

510. 0.000 0.000 ↓ 0.0 0

Seq Scan on dblanguage l_7 (cost=0.00..2.40 rows=140 width=20) (never executed)

511. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_18ndscrptn on dbi18ndescription i_6 (cost=0.57..48.66 rows=11 width=40) (never executed)

  • Index Cond: ((rid = adv_9.referencevalueid) AND (languageid = l_7.languageid) AND (descriptionkey = 'Description'::text))
  • Heap Fetches: 0
512. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_18ndscrptn on dbi18ndescription i_7 (cost=0.57..48.69 rows=11 width=556) (never executed)

  • Index Cond: ((rid = adv_10.referencevalueid) AND (languageid = l_8.languageid) AND ((descriptionkey)::text = 'Description'::text))
513. 0.005 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on dbi18ndescription i18n (cost=78.94..8,536.00 rows=2,183 width=516) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((rid = s.smfitid) AND (languageid = lang.languageid))
514. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on pk_18ndscrptn (cost=0.00..78.40 rows=2,183 width=0) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: ((rid = s.smfitid) AND (languageid = lang.languageid))
Planning time : 38.765 ms
Execution time : 71,477.638 ms