explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KVTb

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 48,324.211 ↑ 1.0 1 1

Nested Loop (cost=10,471.14..47,172.60 rows=1 width=4,744) (actual time=48,299.472..48,324.211 rows=1 loops=1)

2. 0.004 103.503 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,471.14..27,953.77 rows=1 width=3,462) (actual time=78.783..103.503 rows=1 loops=1)

3. 0.005 103.479 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,470.71..27,953.25 rows=1 width=2,918) (actual time=78.762..103.479 rows=1 loops=1)

4. 0.002 103.472 ↑ 1.0 1 1

Nested Loop (cost=10,470.57..27,953.09 rows=1 width=2,880) (actual time=78.757..103.472 rows=1 loops=1)

5. 0.007 103.452 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,470.29..27,944.77 rows=1 width=2,606) (actual time=78.739..103.452 rows=1 loops=1)

6. 0.004 103.441 ↑ 1.0 1 1

Nested Loop (cost=10,470.14..27,944.49 rows=1 width=2,434) (actual time=78.732..103.441 rows=1 loops=1)

7. 0.008 103.425 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,469.87..27,936.19 rows=1 width=2,352) (actual time=78.719..103.425 rows=1 loops=1)

  • Join Filter: (s.clientid = d.clientid)
8. 0.005 103.399 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,469.58..27,935.87 rows=1 width=2,244) (actual time=78.697..103.399 rows=1 loops=1)

9. 0.005 103.382 ↑ 1.0 1 1

Nested Loop (cost=10,469.44..27,935.70 rows=1 width=2,072) (actual time=78.683..103.382 rows=1 loops=1)

10. 0.005 103.358 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,469.15..27,935.38 rows=1 width=1,994) (actual time=78.662..103.358 rows=1 loops=1)

11. 0.005 103.351 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,469.00..27,935.21 rows=1 width=1,994) (actual time=78.658..103.351 rows=1 loops=1)

12. 0.044 103.344 ↑ 1.0 1 1

Nested Loop Left Join (cost=10,468.86..27,935.03 rows=1 width=1,994) (actual time=78.652..103.344 rows=1 loops=1)

13. 0.006 103.299 ↑ 1.0 1 1

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

14. 0.012 103.266 ↑ 1.0 1 1

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

15. 31.722 103.223 ↑ 1.0 1 1

Bitmap Heap Scan on dbsmstyle s (cost=184.26..278.57 rows=1 width=824) (actual time=78.541..103.223 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: 8089
  • Heap Blocks: exact=5792
16. 0.895 71.501 ↓ 0.0 0 1

BitmapAnd (cost=184.26..184.26 rows=24 width=0) (actual time=71.500..71.501 rows=0 loops=1)

17. 1.483 1.483 ↓ 1.9 9,077 1

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

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

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

  • Index Cond: (istemplate = 0)
19. 0.009 0.031 ↑ 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.030..0.031 rows=1 loops=1)

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

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

  • Index Cond: (smstyleid = s.smstyleid)
21. 0.027 0.027 ↑ 1.0 1 1

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

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

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

  • Index Cond: (smsampleevalpageid = (SubPlan 25))
23.          

SubPlan (for Index Scan)

24. 0.001 0.035 ↓ 0.0 0 1

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

25. 0.012 0.034 ↓ 0.0 0 1

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

  • Sort Key: dbsmsampleevalpage.samplingby_date DESC
  • Sort Method: quicksort Memory: 25kB
26. 0.001 0.022 ↓ 0.0 0 1

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

  • Recheck Cond: (smstylesupplierid = ss.smstylesupplierid)
27. 0.021 0.021 ↓ 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.019..0.021 rows=0 loops=1)

  • Index Cond: (smstylesupplierid = ss.smstylesupplierid)
28. 0.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Index Cond: (smsampletypeid = se.smsampletypeid)
  • Heap Fetches: 0
29. 0.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Index Cond: (smevaluationstatusid = se.smevaluatuinstatusid)
  • Heap Fetches: 0
30. 0.019 0.019 ↑ 1.0 1 1

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

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

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

  • Index Cond: (ss.clientofficeid = officeid)
32. 0.018 0.018 ↑ 1.0 1 1

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

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

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

  • Index Cond: (seasonclientid = '5513075500'::numeric)
34. 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)
35. 0.018 0.018 ↑ 1.0 1 1

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

  • Index Cond: (supplierid = '5520500494'::numeric)
36. 0.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Index Cond: (ss.smsupplierstatusid = smsupplierstatusid)
37. 0.020 0.020 ↓ 0.0 0 1

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

  • Index Cond: (ss.smstylesupplierid = smstylesupplierid)
38. 0.032 0.032 ↑ 1.0 1 1

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

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

SubPlan (for Nested Loop)

40. 0.002 0.004 ↓ 0.0 0 1

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

41.          

Initplan (for Nested Loop)

42. 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)
43. 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.001..0.002 rows=0 loops=1)

  • Index Cond: (smassortmentid = s.smassortmentid)
44. 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))
45. 0.000 0.002 ↓ 0.0 0 1

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

46.          

Initplan (for Nested Loop)

47. 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)
48. 0.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Index Cond: (smassortmentsubgroupid = s.smassortmentsubgroupid)
49. 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))
50. 0.001 0.002 ↓ 0.0 0 1

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

51.          

Initplan (for Nested Loop)

52. 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)
53. 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)
54. 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))
55. 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)
56. 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)
57. 0.000 0.000 ↓ 0.0 0

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

58. 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))
59. 0.000 0.000 ↓ 0.0 0

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

60. 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)
61. 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
62. 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)
63. 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
64. 0.000 0.000 ↓ 0.0 0

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

65. 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))
66. 0.000 0.000 ↓ 0.0 0

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

67. 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)
68. 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
69. 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)
70. 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
71. 0.000 0.001 ↓ 0.0 0 1

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

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

Initplan (for Index Scan)

73. 0.017 0.017 ↑ 1.0 1 1

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

  • Filter: ((languageisocode)::text = 'en'::text)
  • Rows Removed by Filter: 139
74. 0.042 74.918 ↓ 0.0 0 1

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

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

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

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

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

77. 61.848 74.824 ↓ 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.353..9.353 rows=0 loops=8)

  • Recheck Cond: ((name_)::text = 'sampleId'::text)
  • Filter: ((long_)::numeric = se.smsampleevalpageid)
  • Rows Removed by Filter: 17348
  • Heap Blocks: exact=38304
78. 12.976 12.976 ↓ 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.622..1.622 rows=17,350 loops=8)

  • Index Cond: ((name_)::text = 'sampleId'::text)
79. 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)
80. 0.001 19,096.578 ↓ 0.0 0 1

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

81. 0.004 19,096.577 ↓ 0.0 0 1

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

  • Join Filter: ((sre_1.proc_def_id_)::text = (srp_1.id_)::text)
82. 0.003 19,096.573 ↓ 0.0 0 1

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

83. 19.594 19,096.570 ↓ 0.0 0 1

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

84. 16.584 18.288 ↓ 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.374..18.288 rows=9,024 loops=1)

  • Recheck Cond: ((name_)::text = 'sampleId'::text)
  • Filter: (long_ IS NULL)
  • Rows Removed by Filter: 8324
  • Heap Blocks: exact=4788
85. 1.704 1.704 ↓ 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.704..1.704 rows=17,350 loops=1)

  • Index Cond: ((name_)::text = 'sampleId'::text)
86. 36.096 19,058.688 ↓ 0.0 0 9,024

Bitmap Heap Scan on act_ru_variable (cost=74.96..109.99 rows=1 width=146) (actual time=2.112..2.112 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=9024
87. 18.048 19,022.592 ↓ 0.0 0 9,024

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

88. 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 = (srv_1.proc_inst_id_)::text)
89. 18,914.304 18,914.304 ↓ 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.096..2.096 rows=24,137 loops=9,024)

  • Index Cond: ((name_)::text = 'productId'::text)
90. 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)
91. 0.000 0.000 ↓ 0.0 0

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

92. 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)
93. 0.036 116.477 ↓ 0.0 0 1

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

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

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

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

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

96. 99.448 116.400 ↓ 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.550..14.550 rows=0 loops=8)

  • Recheck Cond: ((name_)::text = 'productId'::text)
  • Filter: ((long_)::numeric = ss.smstylesupplierid)
  • Rows Removed by Filter: 24136
  • Heap Blocks: exact=39712
97. 16.952 16.952 ↓ 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.119..2.119 rows=24,137 loops=8)

  • Index Cond: ((name_)::text = 'productId'::text)
98. 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)
99. 0.001 0.066 ↓ 0.0 0 1

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

100.          

Initplan (for Nested Loop)

101. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
102. 0.065 0.065 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((rid = ss.keyfield3) AND (languageid = $23) AND ((descriptionkey)::text = 'Description'::text))
104. 0.001 0.047 ↓ 0.0 0 1

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

105.          

Initplan (for Nested Loop)

106. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((languageisocode)::text = 'en'::text)
107. 0.046 0.046 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((rid = ss.keyfield2) AND (languageid = $25) AND ((descriptionkey)::text = 'Description'::text))
109. 0.004 28,932.475 ↓ 0.0 0 1

Limit (cost=1,655.85..1,655.86 rows=1 width=8) (actual time=28,932.474..28,932.475 rows=0 loops=1)

110. 0.014 28,932.471 ↓ 0.0 0 1

Sort (cost=1,655.85..1,655.86 rows=1 width=8) (actual time=28,932.471..28,932.471 rows=0 loops=1)

  • Sort Key: m.due_date
  • Sort Method: quicksort Memory: 25kB
111. 0.002 28,932.457 ↓ 0.0 0 1

Nested Loop Anti Join (cost=97.84..1,655.84 rows=1 width=8) (actual time=28,932.457..28,932.457 rows=0 loops=1)

112. 19.272 28,932.455 ↓ 0.0 0 1

Nested Loop (cost=97.41..1,644.35 rows=1 width=154) (actual time=28,932.454..28,932.455 rows=0 loops=1)

113. 53.832 28,774.879 ↓ 17,288.0 17,288 1

Nested Loop (cost=96.98..1,641.82 rows=1 width=166) (actual time=3.412..28,774.879 rows=17,288 loops=1)

114. 62.504 28,634.307 ↓ 17,348.0 17,348 1

Nested Loop (cost=96.56..1,639.63 rows=1 width=154) (actual time=3.396..28,634.307 rows=17,348 loops=1)

115. 16.131 100.543 ↓ 17,510.0 17,510 1

Nested Loop (cost=20.72..1,528.71 rows=1 width=146) (actual time=0.073..100.543 rows=17,510 loops=1)

116. 0.028 0.028 ↓ 8.0 8 1

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

  • Filter: ((key_)::text = 'SampleRequest'::text)
  • Rows Removed by Filter: 18
117. 78.752 84.384 ↓ 2,189.0 2,189 8

Bitmap Heap Scan on act_hi_procinst ahp (cost=20.72..1,527.37 rows=1 width=292) (actual time=0.771..10.548 rows=2,189 loops=8)

  • Recheck Cond: ((proc_def_id_)::text = (arp.id_)::text)
  • Filter: ((end_act_id_ IS NULL) AND ((proc_def_id_)::text ~~* 'SampleRequest:%'::text))
  • Rows Removed by Filter: 5218
  • Heap Blocks: exact=3719
118. 5.632 5.632 ↓ 12.9 7,406 8

Bitmap Index Scan on act_idx_hi_pro_i_procdef (cost=0.00..20.71 rows=573 width=0) (actual time=0.704..0.704 rows=7,406 loops=8)

  • Index Cond: ((proc_def_id_)::text = (arp.id_)::text)
119. 52.530 28,471.260 ↑ 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.626..1.626 rows=1 loops=17,510)

  • Recheck Cond: (((proc_inst_id_)::text = (ahp.proc_inst_id_)::text) AND ((name_)::text = 'sampleRequestId'::text))
  • Heap Blocks: exact=17348
120. 53.292 28,418.730 ↓ 0.0 0 17,510

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

121. 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)
122. 28,207.848 28,207.848 ↓ 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.626..1.626 rows=17,349 loops=17,348)

  • Index Cond: ((name_)::text = 'sampleRequestId'::text)
123. 86.740 86.740 ↑ 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.005 rows=1 loops=17,348)

  • Index Cond: (smsamplerequestid = (ahv_sample_request.long_)::numeric)
124. 138.304 138.304 ↓ 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.008..0.008 rows=0 loops=17,288)

  • Index Cond: (smmessageid = sr_1.smmessageid)
  • Filter: (smstylesupplierid = ss.smstylesupplierid)
  • Rows Removed by Filter: 1
125. 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))
126. 0.021 0.021 ↓ 0.0 0 1

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

  • Filter: (smffpdecisionid = ss.ffpdecision)
  • Rows Removed by Filter: 86
127. 0.002 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)

128.          

Initplan (for Nested Loop)

129. 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)
130. 0.008 0.008 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((rid = ss.ffpdecision) AND (languageid = $34) AND ((descriptionkey)::text = 'Description'::text))
132. 0.004 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.004..0.005 rows=0 loops=1)

  • Recheck Cond: ((rid = s.smfitid) AND (languageid = lang.languageid))
133. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on pk_18ndscrptn (cost=0.00..78.40 rows=2,183 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: ((rid = s.smfitid) AND (languageid = lang.languageid))
Planning time : 8.258 ms
Execution time : 48,325.081 ms