# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 2.889 | 1,158.340 | ↓ 50.1 | 1,502 | 1 |
→
Sort (cost=9,498.04..9,498.12 rows=30 width=257) (actual time=1,157.903..1,158.340 rows=1,502 loops=1)
|
2. |
Initplan (forSort) |
|||||
3. | 0.003 | 0.013 | ↑ 1.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.55..16.62 rows=1 width=4) (actual time=0.011..0.013 rows=1 loops=1) |
4. | 0.007 | 0.007 | ↑ 1.0 | 1 | 1 |
→
Index Scan using ixpk_userorganization_t on userorganization_t userorganization_t_1 (cost=0.28..8.29 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=1)
|
5. | 0.003 | 0.003 | ↑ 1.0 | 1 | 1 |
→
Index Scan using ixpk_organization_t on organization_t organization_t_1 (cost=0.27..8.29 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)
|
6. | 9.249 | 1,155.438 | ↓ 50.1 | 1,502 | 1 |
→
Nested Loop (cost=5.50..9,480.68 rows=30 width=257) (actual time=6.486..1,155.438 rows=1,502 loops=1) |
7. | 10.071 | 40.717 | ↓ 50.1 | 1,502 | 1 |
→
Nested Loop (cost=5.22..219.43 rows=30 width=122) (actual time=5.552..40.717 rows=1,502 loops=1) |
8. | 12.350 | 21.726 | ↓ 52.5 | 8,920 | 1 |
→
Nested Loop (cost=4.94..158.14 rows=170 width=53) (actual time=0.292..21.726 rows=8,920 loops=1) |
9. | 0.203 | 1.546 | ↓ 29.0 | 290 | 1 |
→
Nested Loop (cost=4.65..68.11 rows=10 width=18) (actual time=0.065..1.546 rows=290 loops=1) |
10. | 0.190 | 0.763 | ↓ 29.0 | 290 | 1 |
→
Nested Loop (cost=4.37..64.79 rows=10 width=8) (actual time=0.061..0.763 rows=290 loops=1) |
11. | 0.133 | 0.133 | ↓ 20.0 | 40 | 1 |
→
Seq Scan on organization_t (cost=0.00..13.09 rows=2 width=4) (actual time=0.053..0.133 rows=40 loops=1)
|
12. | 0.320 | 0.440 | ↑ 1.7 | 7 | 40 |
→
Bitmap Heap Scan on userorganization_t (cost=4.37..25.73 rows=12 width=12) (actual time=0.005..0.011 rows=7 loops=40)
|
13. | 0.120 | 0.120 | ↑ 1.7 | 7 | 40 |
→
Bitmap Index Scan on ixf03_orguid (cost=0.00..4.37 rows=12 width=0) (actual time=0.003..0.003 rows=7 loops=40)
|
14. | 0.580 | 0.580 | ↑ 1.0 | 1 | 290 |
→
Index Scan using ixpk_dcpsuser_t on dcpsuser_t (cost=0.28..0.33 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=290)
|
15. | 7.830 | 7.830 | ↑ 5.1 | 31 | 290 |
→
Index Scan using ixf03_dcpscase_t_user_org on dcpscase_t (cost=0.29..7.42 rows=158 width=43) (actual time=0.002..0.027 rows=31 loops=290)
|
16. | 8.920 | 8.920 | ↓ 0.0 | 0 | 8,920 |
→
Index Scan using ix_ceappt_t_dcps_case_uid on ceappt_t (cost=0.29..0.35 rows=1 width=69) (actual time=0.001..0.001 rows=0 loops=8,920)
|
17. | 6.008 | 6.008 | ↑ 1.0 | 1 | 1,502 |
→
Index Scan using ixf02_pin on dcpsuser_t dcpsuser_t_1 (cost=0.28..0.31 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=1,502)
|
18. |
SubPlan (forNested Loop) |
|||||
19. | 4.506 | 33.044 | ↑ 1.0 | 1 | 1,502 |
→
Result (cost=16.99..17.00 rows=1 width=32) (actual time=0.022..0.022 rows=1 loops=1,502) |
20. |
Initplan (forResult) |
|||||
21. | 10.078 | 28.538 | ↓ 2.0 | 2 | 1,502 |
→
Nested Loop (cost=0.85..16.99 rows=1 width=32) (actual time=0.013..0.019 rows=2 loops=1,502) |
22. | 2.568 | 13.518 | ↓ 2.0 | 2 | 1,502 |
→
Nested Loop (cost=0.57..16.60 rows=1 width=12) (actual time=0.006..0.009 rows=2 loops=1,502) |
23. | 6.008 | 6.008 | ↓ 2.0 | 2 | 1,502 |
→
Index Scan using ixf01_ceapptitem_t on ceapptitem_t (cost=0.29..8.30 rows=1 width=8) (actual time=0.003..0.004 rows=2 loops=1,502)
|
24. | 4.942 | 4.942 | ↑ 1.0 | 1 | 2,471 |
→
Index Scan using catalog_product_uid_pkey on stcatlgprod_t (cost=0.28..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=2,471)
|
25. | 4.942 | 4.942 | ↑ 1.0 | 1 | 2,471 |
→
Index Scan using prod_uid_pkey on product_t (cost=0.28..0.38 rows=1 width=39) (actual time=0.002..0.002 rows=1 loops=2,471)
|
26. | 6.751 | 30.040 | ↑ 1.0 | 1 | 1,502 |
→
Nested Loop (cost=0.42..13.01 rows=1 width=32) (actual time=0.014..0.020 rows=1 loops=1,502)
|
27. | 10.514 | 10.514 | ↑ 1.0 | 1 | 1,502 |
→
Index Scan using ixf03_rqstuid on corrtrkg_t (cost=0.42..8.44 rows=1 width=13) (actual time=0.005..0.007 rows=1 loops=1,502)
|
28. | 12.775 | 12.775 | ↑ 1.0 | 1 | 1,825 |
→
Seq Scan on pkg_t (cost=0.00..4.55 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=1,825)
|
29. | 3.004 | 1,009.344 | ↑ 1.0 | 1 | 1,502 |
→
Result (cost=274.49..274.50 rows=1 width=32) (actual time=0.672..0.672 rows=1 loops=1,502) |
30. |
Initplan (forResult) |
|||||
31. | 1.502 | 1,006.340 | ↓ 0.0 | 0 | 1,502 |
→
Subquery Scan on t (cost=274.47..274.49 rows=1 width=32) (actual time=0.670..0.670 rows=0 loops=1,502) |
32. | 3.004 | 1,004.838 | ↓ 0.0 | 0 | 1,502 |
→
Sort (cost=274.47..274.47 rows=1 width=94) (actual time=0.669..0.669 rows=0 loops=1,502)
|
33. | 1,001.190 | 1,001.834 | ↓ 0.0 | 0 | 1,502 |
→
Seq Scan on ceappt_t ceappt_t_1 (cost=0.00..274.46 rows=1 width=94) (actual time=0.662..0.667 rows=0 loops=1,502)
|
34. |
SubPlan (forSeq Scan) |
|||||
35. | 0.112 | 0.644 | ↑ 1.0 | 1 | 28 |
→
Result (cost=16.99..17.00 rows=1 width=32) (actual time=0.023..0.023 rows=1 loops=28) |
36. |
Initplan (forResult) |
|||||
37. | 0.206 | 0.532 | ↑ 1.0 | 1 | 28 |
→
Nested Loop (cost=0.85..16.99 rows=1 width=32) (actual time=0.015..0.019 rows=1 loops=28) |
38. | 0.094 | 0.252 | ↑ 1.0 | 1 | 28 |
→
Nested Loop (cost=0.57..16.60 rows=1 width=12) (actual time=0.008..0.009 rows=1 loops=28) |
39. | 0.084 | 0.084 | ↑ 1.0 | 1 | 28 |
→
Index Scan using ixf01_ceapptitem_t on ceapptitem_t ceapptitem_t_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=28)
|
40. | 0.074 | 0.074 | ↑ 1.0 | 1 | 37 |
→
Index Scan using catalog_product_uid_pkey on stcatlgprod_t stcatlgprod_t_1 (cost=0.28..8.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=37)
|
41. | 0.074 | 0.074 | ↑ 1.0 | 1 | 37 |
→
Index Scan using prod_uid_pkey on product_t product_t_1 (cost=0.28..0.38 rows=1 width=39) (actual time=0.002..0.002 rows=1 loops=37)
|
42. | 3.004 | 27.036 | ↑ 1.0 | 1 | 1,502 |
→
Result (cost=3.88..3.89 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=1,502) |
43. |
Initplan (forResult) |
|||||
44. | 0.000 | 24.032 | ↓ 0.0 | 0 | 1,502 |
→
Sort (cost=3.88..3.88 rows=2 width=4) (actual time=0.016..0.016 rows=0 loops=1,502)
|
45. |
Initplan (forSort) |
|||||
46. | 9.012 | 9.012 | ↓ 0.0 | 0 | 1,502 |
→
Seq Scan on rltdceappt_t (cost=0.00..1.85 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1,502)
|
47. | 21.028 | 21.028 | ↓ 0.0 | 0 | 1,502 |
→
Seq Scan on rltdceappt_t rltdceappt_t_1 (cost=0.00..2.02 rows=2 width=4) (actual time=0.013..0.014 rows=0 loops=1,502)
|