ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 180 minutes: |
5966.99 |
5226 |
1074058 |
2018-05-16 03:46 |
2018-05-16 06:46 |
customer order: creation |
469.91 |
558 |
84583 |
2018-05-16 03:46 |
2018-05-16 06:46 |
customer order: refuse |
38.12 |
293 |
6862 |
2018-05-16 03:46 |
2018-05-16 06:46 |
order to supplier: creation |
119.84 |
2522 |
21571 |
2018-05-16 03:46 |
2018-05-16 06:46 |
order to supplier: removal |
3.03 |
32870 |
545 |
2018-05-16 03:46 |
2018-05-16 06:46 |
invoice (draft): creation |
120.25 |
3880 |
21645 |
2018-05-16 03:46 |
2018-05-16 06:46 |
invoice (draft): removal |
41.75 |
795 |
7515 |
2018-05-16 03:46 |
2018-05-16 06:46 |
invoice accept: apply |
68.44 |
19225 |
12320 |
2018-05-16 03:46 |
2018-05-16 06:46 |
invoice accept: cancel |
18.07 |
4215 |
3235 |
2018-05-16 03:46 |
2018-05-16 06:46 |
customer reserve: creation |
3465.94 |
324 |
623869 |
2018-05-16 03:46 |
2018-05-16 06:46 |
customer reserve: removal |
983.95 |
109 |
177111 |
2018-05-16 03:46 |
2018-05-16 06:46 |
realization accept: apply |
214.77 |
727 |
38658 |
2018-05-16 03:46 |
2018-05-16 06:46 |
realization accept: cancel |
85.53 |
213 |
15395 |
2018-05-16 03:46 |
2018-05-16 06:46 |
payment from customer: creation |
156.58 |
1155 |
28185 |
2018-05-16 03:46 |
2018-05-16 06:46 |
payment from customer: removal |
15.09 |
146 |
2701 |
2018-05-16 03:46 |
2018-05-16 06:46 |
payment to supplier: creation |
129.21 |
1265 |
23257 |
2018-05-16 03:46 |
2018-05-16 06:46 |
payment to supplier: removal |
8.87 |
150 |
1588 |
2018-05-16 03:46 |
2018-05-16 06:46 |
service: total inventory turnovers |
6.34 |
6490 |
1142 |
2018-05-16 03:46 |
2018-05-16 06:46 |
service: total monetary turnovers |
21.47 |
64 |
3864 |
2018-05-16 03:46 |
2018-05-16 06:46 |
service: refresh index statistics |
0.07 |
24295 |
12 |
2018-05-16 03:46 |
2018-05-16 06:46 |
Done for 61620 ms, from 6:49:06.70 to 6:50:08.32.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
5227 |
109059 |
94081 |
14978 |
13.73 |
03:46:50 |
04:04:50 |
interval # 2, overall |
2 |
5493 |
106533 |
98876 |
7657 |
7.19 |
04:04:51 |
04:22:51 |
interval # 3, overall |
3 |
5871 |
116950 |
105673 |
11277 |
9.64 |
04:22:52 |
04:40:52 |
interval # 4, overall |
4 |
6221 |
124595 |
111975 |
12620 |
10.13 |
04:40:53 |
04:58:53 |
interval # 5, overall |
5 |
5570 |
112492 |
100255 |
12237 |
10.88 |
04:58:54 |
05:16:54 |
interval # 6, overall |
6 |
6292 |
120808 |
113263 |
7545 |
6.25 |
05:16:55 |
05:34:55 |
interval # 7, overall |
7 |
6188 |
127556 |
111387 |
16169 |
12.68 |
05:34:56 |
05:52:56 |
interval # 8, overall |
8 |
6090 |
125785 |
109614 |
16171 |
12.86 |
05:52:57 |
06:10:57 |
interval # 9, overall |
9 |
6669 |
128870 |
120046 |
8824 |
6.85 |
06:10:58 |
06:28:58 |
interval # 10, overall |
10 |
6049 |
124077 |
108888 |
15189 |
12.24 |
06:28:59 |
06:46:59 |
Done for 193230 ms, from 6:53:18.59 to 6:56:31.82.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
TEST_TIME |
1 |
2640.54 |
0.0886 |
1.8098 |
2806 |
24 |
TEST_TIME |
2 |
3439.74 |
0.6948 |
1.3470 |
1639 |
99 |
TEST_TIME |
3 |
3718.97 |
0.8346 |
1.1617 |
1853 |
100 |
TEST_TIME |
4 |
3799.73 |
0.8532 |
1.1263 |
1665 |
100 |
TEST_TIME |
5 |
3876.10 |
0.8833 |
1.1068 |
1839 |
100 |
TEST_TIME |
6 |
3986.53 |
0.8968 |
1.0893 |
1984 |
100 |
TEST_TIME |
7 |
4071.63 |
0.9153 |
1.0965 |
1860 |
100 |
TEST_TIME |
8 |
4242.63 |
0.9207 |
1.0430 |
1956 |
100 |
TEST_TIME |
9 |
4149.97 |
0.9479 |
1.0633 |
2015 |
98 |
TEST_TIME |
10 |
4255.13 |
0.9334 |
1.0694 |
1688 |
100 |
TEST_TIME |
11 |
4400.37 |
0.9401 |
1.0542 |
1881 |
100 |
TEST_TIME |
12 |
4491.01 |
0.9480 |
1.0470 |
1718 |
100 |
TEST_TIME |
13 |
4557.29 |
0.9538 |
1.0426 |
1608 |
100 |
TEST_TIME |
14 |
4659.19 |
0.9470 |
1.0418 |
1594 |
100 |
TEST_TIME |
15 |
4725.98 |
0.9587 |
1.0372 |
1624 |
100 |
TEST_TIME |
16 |
4819.58 |
0.9535 |
1.0383 |
2042 |
100 |
TEST_TIME |
17 |
4917.13 |
0.9579 |
1.0519 |
2135 |
100 |
TEST_TIME |
18 |
5045.20 |
0.9682 |
1.0395 |
2009 |
100 |
TEST_TIME |
19 |
5045.32 |
0.9848 |
1.0166 |
1731 |
73 |
TEST_TIME |
20 |
5001.58 |
0.9742 |
1.0262 |
1588 |
63 |
TEST_TIME |
21 |
5066.20 |
0.9648 |
1.0276 |
1904 |
63 |
TEST_TIME |
22 |
5108.23 |
0.9729 |
1.0274 |
1622 |
71 |
TEST_TIME |
23 |
5167.20 |
0.9715 |
1.0224 |
1469 |
100 |
TEST_TIME |
24 |
5145.57 |
0.9839 |
1.0254 |
2028 |
97 |
TEST_TIME |
25 |
5165.84 |
0.9806 |
1.0316 |
1940 |
97 |
TEST_TIME |
26 |
5215.00 |
0.9826 |
1.0207 |
1624 |
100 |
TEST_TIME |
27 |
5259.24 |
0.9747 |
1.0295 |
1497 |
100 |
TEST_TIME |
28 |
5333.92 |
0.9788 |
1.0225 |
1658 |
100 |
TEST_TIME |
29 |
5359.63 |
0.9827 |
1.0127 |
1551 |
100 |
TEST_TIME |
30 |
5361.99 |
0.9785 |
1.0154 |
1460 |
100 |
TEST_TIME |
31 |
5302.17 |
0.9938 |
1.0094 |
1633 |
91 |
TEST_TIME |
32 |
5241.05 |
0.9893 |
1.0120 |
1753 |
81 |
TEST_TIME |
33 |
5228.91 |
0.9837 |
1.0253 |
1686 |
94 |
TEST_TIME |
34 |
5257.73 |
0.9897 |
1.0123 |
1815 |
92 |
TEST_TIME |
35 |
5244.07 |
0.9860 |
1.0221 |
1384 |
98 |
TEST_TIME |
36 |
5271.52 |
0.9886 |
1.0146 |
2021 |
97 |
TEST_TIME |
37 |
5294.95 |
0.9828 |
1.0236 |
1922 |
98 |
TEST_TIME |
38 |
5356.27 |
0.9852 |
1.0131 |
1700 |
100 |
TEST_TIME |
39 |
5362.49 |
0.9860 |
1.0123 |
1842 |
93 |
TEST_TIME |
40 |
5391.71 |
0.9877 |
1.0171 |
1483 |
100 |
TEST_TIME |
41 |
5387.63 |
0.9930 |
1.0112 |
1933 |
98 |
TEST_TIME |
42 |
5396.61 |
0.9855 |
1.0112 |
1620 |
97 |
TEST_TIME |
43 |
5415.25 |
0.9843 |
1.0178 |
1463 |
99 |
TEST_TIME |
44 |
5406.15 |
0.9964 |
1.0042 |
1369 |
92 |
TEST_TIME |
45 |
5338.92 |
0.9943 |
1.0071 |
1256 |
74 |
TEST_TIME |
46 |
5330.86 |
0.9867 |
1.0131 |
1594 |
91 |
TEST_TIME |
47 |
5366.16 |
0.9851 |
1.0133 |
2284 |
97 |
TEST_TIME |
48 |
5371.26 |
0.9912 |
1.0097 |
1971 |
90 |
TEST_TIME |
49 |
5407.24 |
0.9825 |
1.0121 |
1738 |
97 |
TEST_TIME |
50 |
5425.43 |
0.9886 |
1.0107 |
1749 |
99 |
TEST_TIME |
51 |
5436.66 |
0.9888 |
1.0083 |
1762 |
100 |
TEST_TIME |
52 |
5428.26 |
0.9904 |
1.0110 |
1596 |
95 |
TEST_TIME |
53 |
5473.04 |
0.9839 |
1.0070 |
1569 |
100 |
TEST_TIME |
54 |
5461.98 |
0.9904 |
1.0107 |
1907 |
99 |
TEST_TIME |
55 |
5484.91 |
0.9882 |
1.0113 |
1511 |
100 |
TEST_TIME |
56 |
5488.07 |
0.9927 |
1.0089 |
1511 |
100 |
TEST_TIME |
57 |
5501.77 |
0.9888 |
1.0101 |
1586 |
100 |
TEST_TIME |
58 |
5502.77 |
0.9925 |
1.0073 |
1633 |
99 |
TEST_TIME |
59 |
5521.96 |
0.9868 |
1.0097 |
1299 |
98 |
TEST_TIME |
60 |
5516.52 |
0.9939 |
1.0056 |
1594 |
98 |
TEST_TIME |
61 |
5525.07 |
0.9876 |
1.0068 |
1753 |
98 |
TEST_TIME |
62 |
5523.91 |
0.9907 |
1.0102 |
2250 |
92 |
TEST_TIME |
63 |
5560.99 |
0.9875 |
1.0124 |
2062 |
96 |
TEST_TIME |
64 |
5586.16 |
0.9921 |
1.0098 |
1853 |
92 |
TEST_TIME |
65 |
5599.56 |
0.9919 |
1.0099 |
1843 |
94 |
TEST_TIME |
66 |
5627.61 |
0.9896 |
1.0083 |
1686 |
94 |
TEST_TIME |
67 |
5623.37 |
0.9940 |
1.0070 |
1644 |
96 |
TEST_TIME |
68 |
5630.19 |
0.9910 |
1.0116 |
1584 |
99 |
TEST_TIME |
69 |
5647.06 |
0.9940 |
1.0059 |
1483 |
95 |
TEST_TIME |
70 |
5642.81 |
0.9923 |
1.0062 |
1472 |
86 |
TEST_TIME |
71 |
5640.90 |
0.9924 |
1.0056 |
1340 |
93 |
TEST_TIME |
72 |
5634.72 |
0.9927 |
1.0132 |
1305 |
98 |
TEST_TIME |
73 |
5654.33 |
0.9959 |
1.0030 |
1402 |
100 |
TEST_TIME |
74 |
5621.35 |
0.9953 |
1.0057 |
1441 |
95 |
TEST_TIME |
75 |
5602.96 |
0.9955 |
1.0053 |
1395 |
92 |
TEST_TIME |
76 |
5609.45 |
0.9909 |
1.0067 |
1707 |
98 |
TEST_TIME |
77 |
5619.94 |
0.9918 |
1.0071 |
1817 |
99 |
TEST_TIME |
78 |
5627.61 |
0.9928 |
1.0084 |
1778 |
98 |
TEST_TIME |
79 |
5624.53 |
0.9962 |
1.0051 |
1856 |
92 |
TEST_TIME |
80 |
5621.32 |
0.9931 |
1.0077 |
1652 |
92 |
TEST_TIME |
81 |
5645.42 |
0.9910 |
1.0061 |
1563 |
98 |
TEST_TIME |
82 |
5631.53 |
0.9963 |
1.0039 |
1637 |
88 |
TEST_TIME |
83 |
5612.32 |
0.9952 |
1.0053 |
1552 |
85 |
TEST_TIME |
84 |
5632.23 |
0.9898 |
1.0076 |
1427 |
99 |
TEST_TIME |
85 |
5633.46 |
0.9956 |
1.0061 |
1741 |
100 |
TEST_TIME |
86 |
5637.49 |
0.9937 |
1.0043 |
1417 |
91 |
TEST_TIME |
87 |
5628.30 |
0.9944 |
1.0054 |
1497 |
90 |
TEST_TIME |
88 |
5639.18 |
0.9921 |
1.0043 |
1372 |
95 |
TEST_TIME |
89 |
5635.84 |
0.9936 |
1.0076 |
1392 |
98 |
TEST_TIME |
90 |
5634.87 |
0.9966 |
1.0059 |
1356 |
98 |
TEST_TIME |
91 |
5625.30 |
0.9966 |
1.0039 |
1396 |
94 |
TEST_TIME |
92 |
5645.40 |
0.9897 |
1.0109 |
2047 |
97 |
TEST_TIME |
93 |
5674.73 |
0.9948 |
1.0047 |
1702 |
96 |
TEST_TIME |
94 |
5675.60 |
0.9939 |
1.0060 |
1714 |
96 |
TEST_TIME |
95 |
5681.63 |
0.9943 |
1.0071 |
1679 |
85 |
TEST_TIME |
96 |
5689.81 |
0.9952 |
1.0038 |
1634 |
87 |
TEST_TIME |
97 |
5688.43 |
0.9937 |
1.0060 |
1402 |
82 |
TEST_TIME |
98 |
5718.81 |
0.9904 |
1.0079 |
1258 |
99 |
TEST_TIME |
99 |
5721.33 |
0.9972 |
1.0031 |
1090 |
94 |
TEST_TIME |
100 |
5719.55 |
0.9935 |
1.0057 |
1333 |
99 |
TEST_TIME |
101 |
5724.20 |
0.9949 |
1.0069 |
1268 |
89 |
TEST_TIME |
102 |
5745.75 |
0.9954 |
1.0035 |
1527 |
95 |
TEST_TIME |
103 |
5732.92 |
0.9960 |
1.0037 |
1406 |
93 |
TEST_TIME |
104 |
5730.67 |
0.9945 |
1.0046 |
1312 |
91 |
TEST_TIME |
105 |
5721.01 |
0.9967 |
1.0035 |
1292 |
95 |
TEST_TIME |
106 |
5728.69 |
0.9927 |
1.0044 |
1769 |
97 |
TEST_TIME |
107 |
5726.24 |
0.9954 |
1.0055 |
1657 |
98 |
TEST_TIME |
108 |
5732.53 |
0.9951 |
1.0054 |
2007 |
96 |
TEST_TIME |
109 |
5747.49 |
0.9935 |
1.0047 |
1779 |
94 |
TEST_TIME |
110 |
5755.91 |
0.9942 |
1.0086 |
1638 |
99 |
TEST_TIME |
111 |
5780.66 |
0.9952 |
1.0066 |
1381 |
100 |
TEST_TIME |
112 |
5787.78 |
0.9966 |
1.0027 |
1718 |
100 |
TEST_TIME |
113 |
5765.53 |
0.9977 |
1.0024 |
1098 |
75 |
TEST_TIME |
114 |
5744.81 |
0.9972 |
1.0034 |
1188 |
76 |
TEST_TIME |
115 |
5755.68 |
0.9928 |
1.0031 |
1332 |
97 |
TEST_TIME |
116 |
5739.60 |
0.9972 |
1.0031 |
1580 |
89 |
TEST_TIME |
117 |
5742.60 |
0.9940 |
1.0046 |
1419 |
91 |
TEST_TIME |
118 |
5752.96 |
0.9942 |
1.0055 |
1177 |
100 |
TEST_TIME |
119 |
5757.87 |
0.9962 |
1.0044 |
1286 |
100 |
TEST_TIME |
120 |
5744.26 |
0.9984 |
1.0026 |
1332 |
96 |
TEST_TIME |
121 |
5758.73 |
0.9918 |
1.0041 |
1961 |
99 |
TEST_TIME |
122 |
5766.05 |
0.9946 |
1.0051 |
2007 |
91 |
TEST_TIME |
123 |
5777.86 |
0.9949 |
1.0054 |
1821 |
87 |
TEST_TIME |
124 |
5799.55 |
0.9963 |
1.0030 |
1844 |
96 |
TEST_TIME |
125 |
5788.52 |
0.9969 |
1.0033 |
1570 |
89 |
TEST_TIME |
126 |
5803.77 |
0.9928 |
1.0045 |
1592 |
96 |
TEST_TIME |
127 |
5817.26 |
0.9943 |
1.0058 |
1543 |
96 |
TEST_TIME |
128 |
5820.88 |
0.9973 |
1.0036 |
1782 |
91 |
TEST_TIME |
129 |
5819.81 |
0.9960 |
1.0054 |
1497 |
92 |
TEST_TIME |
130 |
5825.76 |
0.9967 |
1.0028 |
1455 |
95 |
TEST_TIME |
131 |
5815.72 |
0.9969 |
1.0045 |
1363 |
97 |
TEST_TIME |
132 |
5817.93 |
0.9965 |
1.0037 |
1492 |
94 |
TEST_TIME |
133 |
5813.88 |
0.9968 |
1.0029 |
1309 |
90 |
TEST_TIME |
134 |
5808.01 |
0.9965 |
1.0033 |
1256 |
94 |
TEST_TIME |
135 |
5801.81 |
0.9969 |
1.0028 |
1251 |
89 |
TEST_TIME |
136 |
5794.96 |
0.9966 |
1.0055 |
1073 |
96 |
TEST_TIME |
137 |
5812.96 |
0.9951 |
1.0050 |
1814 |
98 |
TEST_TIME |
138 |
5817.65 |
0.9969 |
1.0048 |
1760 |
89 |
TEST_TIME |
139 |
5832.98 |
0.9949 |
1.0045 |
1400 |
98 |
TEST_TIME |
140 |
5825.87 |
0.9986 |
1.0019 |
1426 |
91 |
TEST_TIME |
141 |
5826.57 |
0.9946 |
1.0043 |
1307 |
96 |
TEST_TIME |
142 |
5833.10 |
0.9961 |
1.0034 |
1453 |
98 |
TEST_TIME |
143 |
5831.53 |
0.9967 |
1.0028 |
1298 |
95 |
TEST_TIME |
144 |
5835.37 |
0.9952 |
1.0027 |
1365 |
98 |
TEST_TIME |
145 |
5837.83 |
0.9954 |
1.0035 |
1422 |
94 |
TEST_TIME |
146 |
5842.76 |
0.9958 |
1.0032 |
1429 |
95 |
TEST_TIME |
147 |
5851.05 |
0.9949 |
1.0030 |
1343 |
94 |
TEST_TIME |
148 |
5845.31 |
0.9972 |
1.0045 |
1303 |
99 |
TEST_TIME |
149 |
5843.59 |
0.9981 |
1.0019 |
1361 |
99 |
TEST_TIME |
150 |
5847.90 |
0.9945 |
1.0034 |
1180 |
97 |
TEST_TIME |
151 |
5844.22 |
0.9973 |
1.0024 |
1221 |
95 |
TEST_TIME |
152 |
5853.93 |
0.9941 |
1.0046 |
1702 |
94 |
TEST_TIME |
153 |
5853.07 |
0.9981 |
1.0028 |
1517 |
85 |
TEST_TIME |
154 |
5850.77 |
0.9968 |
1.0041 |
1590 |
87 |
TEST_TIME |
155 |
5865.85 |
0.9950 |
1.0052 |
1530 |
87 |
TEST_TIME |
156 |
5877.73 |
0.9967 |
1.0035 |
1476 |
87 |
TEST_TIME |
157 |
5889.51 |
0.9951 |
1.0042 |
1323 |
97 |
TEST_TIME |
158 |
5893.74 |
0.9971 |
1.0031 |
1044 |
99 |
TEST_TIME |
159 |
5899.10 |
0.9959 |
1.0033 |
1375 |
99 |
TEST_TIME |
160 |
5902.03 |
0.9965 |
1.0042 |
1285 |
97 |
TEST_TIME |
161 |
5916.40 |
0.9956 |
1.0036 |
1312 |
98 |
TEST_TIME |
162 |
5930.02 |
0.9951 |
1.0038 |
1332 |
99 |
TEST_TIME |
163 |
5939.09 |
0.9962 |
1.0030 |
1092 |
100 |
TEST_TIME |
164 |
5953.06 |
0.9946 |
1.0046 |
1064 |
100 |
TEST_TIME |
165 |
5967.22 |
0.9962 |
1.0015 |
1270 |
100 |
TEST_TIME |
166 |
5963.01 |
0.9962 |
1.0021 |
1491 |
98 |
TEST_TIME |
167 |
5965.74 |
0.9957 |
1.0034 |
1699 |
90 |
TEST_TIME |
168 |
5973.96 |
0.9960 |
1.0029 |
1194 |
97 |
TEST_TIME |
169 |
5979.45 |
0.9961 |
1.0025 |
1396 |
94 |
TEST_TIME |
170 |
5977.55 |
0.9969 |
1.0030 |
1537 |
94 |
TEST_TIME |
171 |
5983.89 |
0.9962 |
1.0033 |
1489 |
90 |
TEST_TIME |
172 |
5992.89 |
0.9961 |
1.0011 |
1292 |
92 |
TEST_TIME |
173 |
5975.06 |
0.9983 |
1.0018 |
1043 |
83 |
TEST_TIME |
174 |
5968.90 |
0.9971 |
1.0032 |
1049 |
84 |
TEST_TIME |
175 |
5974.81 |
0.9965 |
1.0024 |
1278 |
86 |
TEST_TIME |
176 |
5977.22 |
0.9963 |
1.0020 |
947 |
92 |
TEST_TIME |
177 |
5966.39 |
0.9981 |
1.0019 |
1270 |
97 |
TEST_TIME |
178 |
5959.49 |
0.9974 |
1.0037 |
919 |
96 |
TEST_TIME |
179 |
5968.49 |
0.9967 |
1.0026 |
918 |
98 |
TEST_TIME |
180 |
5959.18 |
0.9986 |
1.0013 |
1193 |
97 |
Done for 9160 ms, from 6:56:33.05 to 6:56:42.21.
TRACED_DATA |
ITRV_NO |
SP_CLIENT_ORDER |
SP_CANCEL_CLIENT_ORDER |
SP_SUPPLIER_ORDER |
SP_CANCEL_SUPPLIER_ORDER |
SP_SUPPLIER_INVOICE |
SP_CANCEL_SUPPLIER_INVOICE |
SP_ADD_INVOICE_TO_STOCK |
SP_CANCEL_ADDING_INVOICE |
SP_CUSTOMER_RESERVE |
SP_CANCEL_CUSTOMER_RESERVE |
SP_RESERVE_WRITE_OFF |
SP_CANCEL_WRITE_OFF |
SP_PAY_FROM_CUSTOMER |
SP_CANCEL_PAY_FROM_CUSTOMER |
SP_PAY_TO_SUPPLIER |
SP_CANCEL_PAY_TO_SUPPLIER |
SRV_MAKE_INVNT_SALDO |
SRV_MAKE_MONEY_SALDO |
SRV_RECALC_IDX_STAT |
ITRV_BEG |
ITRV_END |
fetches per second |
1 |
69026 |
80394 |
68090 |
81686 |
68671 |
125280 |
76035 |
132316 |
61455 |
118415 |
64722 |
87351 |
89403 |
83739 |
171708 |
84427 |
234765 |
463413 |
<null> |
03:46:50 |
04:04:50 |
fetches per second |
2 |
19759 |
10315 |
7141 |
<null> |
24952 |
<null> |
38062 |
75744 |
5570 |
3091 |
20131 |
7498 |
36883 |
14624 |
36514 |
18480 |
<null> |
482504 |
<null> |
04:04:51 |
04:22:51 |
fetches per second |
3 |
7423 |
4368 |
8622 |
<null> |
8768 |
<null> |
9707 |
22039 |
2354 |
10829 |
12065 |
2920 |
13055 |
4443 |
16971 |
3387 |
<null> |
21182 |
<null> |
04:22:52 |
04:40:52 |
fetches per second |
4 |
7969 |
5522 |
9386 |
<null> |
12555 |
7536 |
17146 |
6369 |
6319 |
14028 |
10526 |
11222 |
20696 |
8546 |
14890 |
<null> |
30262 |
188226 |
<null> |
04:40:53 |
04:58:53 |
fetches per second |
5 |
4126 |
24291 |
8667 |
<null> |
8124 |
3931 |
8400 |
<null> |
1819 |
2766 |
12138 |
1799 |
22480 |
3339 |
17994 |
<null> |
<null> |
226379 |
<null> |
04:58:54 |
05:16:54 |
fetches per second |
6 |
3357 |
9470 |
6454 |
<null> |
3809 |
<null> |
7528 |
<null> |
10841 |
10586 |
5023 |
1573 |
9114 |
2996 |
13198 |
11963 |
<null> |
321824 |
<null> |
05:16:55 |
05:34:55 |
fetches per second |
7 |
12991 |
2826 |
19042 |
<null> |
8118 |
<null> |
18001 |
<null> |
<null> |
2360 |
11873 |
2470 |
8653 |
<null> |
33285 |
9460 |
30137 |
35663 |
<null> |
05:34:56 |
05:52:56 |
fetches per second |
8 |
3854 |
9454 |
11997 |
11890 |
5366 |
4459 |
8193 |
3139 |
15834 |
3986 |
4090 |
2151 |
9133 |
2068 |
15991 |
7756 |
9036 |
<null> |
<null> |
05:52:57 |
06:10:57 |
fetches per second |
9 |
4228 |
5348 |
4303 |
<null> |
11968 |
2581 |
13381 |
<null> |
1692 |
3059 |
5012 |
1953 |
12645 |
2018 |
7613 |
4613 |
<null> |
523590 |
<null> |
06:10:58 |
06:28:58 |
fetches per second |
10 |
6631 |
22520 |
6688 |
32047 |
9540 |
<null> |
47527 |
<null> |
8055 |
4607 |
24479 |
1515 |
10885 |
<null> |
11127 |
<null> |
132694 |
32157 |
<null> |
06:28:59 |
06:46:59 |
marks per second |
1 |
14749 |
10548 |
15090 |
15324 |
15192 |
26320 |
8833 |
25228 |
7530 |
23039 |
12868 |
15813 |
7727 |
15147 |
6821 |
11873 |
15322 |
60157 |
<null> |
03:46:50 |
04:04:50 |
marks per second |
2 |
3956 |
1424 |
1516 |
<null> |
5270 |
<null> |
6940 |
12295 |
654 |
620 |
2913 |
1216 |
2228 |
2249 |
1597 |
3634 |
<null> |
45862 |
<null> |
04:04:51 |
04:22:51 |
marks per second |
3 |
1603 |
566 |
1407 |
<null> |
1706 |
<null> |
1039 |
3584 |
302 |
1917 |
2079 |
530 |
517 |
768 |
767 |
472 |
<null> |
961 |
<null> |
04:22:52 |
04:40:52 |
marks per second |
4 |
1669 |
748 |
1620 |
<null> |
2199 |
1881 |
1697 |
870 |
748 |
2225 |
925 |
1920 |
710 |
1432 |
420 |
<null> |
1211 |
1750 |
<null> |
04:40:53 |
04:58:53 |
marks per second |
5 |
804 |
3246 |
996 |
<null> |
1153 |
882 |
662 |
<null> |
224 |
454 |
1236 |
272 |
605 |
472 |
425 |
<null> |
<null> |
3076 |
<null> |
04:58:54 |
05:16:54 |
marks per second |
6 |
710 |
1281 |
1005 |
<null> |
553 |
<null> |
654 |
<null> |
2629 |
1750 |
768 |
237 |
275 |
494 |
575 |
1939 |
<null> |
2714 |
<null> |
05:16:55 |
05:34:55 |
marks per second |
7 |
2673 |
388 |
2351 |
<null> |
1150 |
<null> |
1726 |
<null> |
<null> |
408 |
2349 |
460 |
261 |
<null> |
1431 |
1263 |
733 |
728 |
<null> |
05:34:56 |
05:52:56 |
marks per second |
8 |
808 |
1156 |
1243 |
1715 |
749 |
993 |
732 |
417 |
1490 |
592 |
433 |
285 |
289 |
309 |
622 |
1743 |
269 |
<null> |
<null> |
05:52:57 |
06:10:57 |
marks per second |
9 |
832 |
697 |
544 |
<null> |
1179 |
562 |
1286 |
<null> |
91 |
472 |
858 |
294 |
399 |
408 |
361 |
678 |
<null> |
6368 |
<null> |
06:10:58 |
06:28:58 |
marks per second |
10 |
1300 |
2848 |
1028 |
4599 |
1633 |
<null> |
7687 |
<null> |
601 |
712 |
838 |
224 |
242 |
<null> |
776 |
<null> |
18028 |
712 |
<null> |
06:28:59 |
06:46:59 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:46:50 |
04:04:50 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
04:04:51 |
04:22:51 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
04:22:52 |
04:40:52 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
04:40:53 |
04:58:53 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
04:58:54 |
05:16:54 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:16:55 |
05:34:55 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
<null> |
05:34:56 |
05:52:56 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
05:52:57 |
06:10:57 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:10:58 |
06:28:58 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
<null> |
06:28:59 |
06:46:59 |
writes/marks*100 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
6 |
0 |
<null> |
03:46:50 |
04:04:50 |
writes/marks*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
04:04:51 |
04:22:51 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
04:22:52 |
04:40:52 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
<null> |
3 |
0 |
<null> |
04:40:53 |
04:58:53 |
writes/marks*100 |
5 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
1 |
<null> |
04:58:54 |
05:16:54 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
05:16:55 |
05:34:55 |
writes/marks*100 |
7 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
<null> |
2 |
0 |
1 |
0 |
<null> |
0 |
0 |
2 |
0 |
<null> |
05:34:56 |
05:52:56 |
writes/marks*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
3 |
<null> |
<null> |
05:52:57 |
06:10:57 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
06:10:58 |
06:28:58 |
writes/marks*100 |
10 |
0 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
1 |
1 |
0 |
0 |
0 |
<null> |
0 |
<null> |
3 |
0 |
<null> |
06:28:59 |
06:46:59 |
Done for 8830 ms, from 6:56:43.27 to 6:56:52.10.
UNIT |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
OK_MIN_MS |
OK_MAX_MS |
OK_AVG_MS |
CNT_LK_CONFL |
JOB_BEG |
JOB_END |
doc_list_aiud |
1858732 |
1748118 |
110614 |
5.95 |
0 |
13291 |
78 |
110614 |
2018-05-16 03:46 |
2018-05-16 06:46 |
doc_list_biud |
1859195 |
1748118 |
111077 |
5.97 |
0 |
17487 |
25 |
111077 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_add_invoice_to_stock |
20330 |
12320 |
8010 |
39.39 |
15 |
204985 |
19225 |
8010 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_adding_invoice |
4054 |
3235 |
819 |
20.20 |
0 |
104083 |
4215 |
819 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_client_order |
7013 |
6862 |
151 |
2.15 |
0 |
4555 |
293 |
151 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_customer_reserve |
277101 |
177111 |
99990 |
36.08 |
0 |
14633 |
109 |
99990 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_pay_from_customer |
2716 |
2701 |
15 |
0.55 |
0 |
2355 |
146 |
15 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_pay_to_supplier |
1594 |
1588 |
6 |
0.37 |
0 |
4103 |
150 |
6 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_supplier_invoice |
9815 |
7515 |
2300 |
23.43 |
0 |
12355 |
795 |
2300 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_supplier_order |
1607 |
545 |
1062 |
66.08 |
15 |
327648 |
32870 |
1062 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_cancel_write_off |
24080 |
15395 |
8685 |
36.06 |
0 |
13478 |
213 |
8685 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_client_order |
84583 |
84583 |
0 |
0.00 |
0 |
12542 |
558 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_customer_reserve |
623869 |
623869 |
0 |
0.00 |
0 |
15303 |
324 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_fill_shopping_cart |
128051 |
127799 |
252 |
0.19 |
0 |
3697 |
114 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_fill_shopping_cart_clo_res |
623869 |
623869 |
0 |
0.00 |
0 |
13884 |
24 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_get_clo_for_invoice |
12320 |
12320 |
0 |
0.00 |
0 |
20218 |
445 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_kill_cost_storno |
32077 |
22919 |
9158 |
28.55 |
0 |
12604 |
22 |
9158 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_kill_qstorno_ret_qs2qd |
587655 |
377677 |
209978 |
35.73 |
0 |
14602 |
42 |
209978 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_kill_qty_storno |
372633 |
261641 |
110992 |
29.78 |
0 |
17487 |
114 |
110992 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_lock_selected_doc |
83036 |
71403 |
11633 |
14.00 |
0 |
1154 |
8 |
11633 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_make_cost_storno |
102420 |
102420 |
0 |
0.00 |
0 |
12340 |
691 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_multiply_rows_for_pdistr |
102420 |
102420 |
0 |
0.00 |
0 |
4087 |
55 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_multiply_rows_for_qdistr |
84583 |
84583 |
0 |
0.00 |
0 |
3510 |
184 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_pay_from_customer |
28185 |
28185 |
0 |
0.00 |
0 |
10234 |
1155 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_pay_to_supplier |
23257 |
23257 |
0 |
0.00 |
0 |
12433 |
1265 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_payment_common |
51442 |
51442 |
0 |
0.00 |
0 |
5242 |
68 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_qd_handle_on_cancel_clo |
7008 |
6862 |
146 |
2.08 |
0 |
2434 |
129 |
146 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_qd_handle_on_invoice_upd_sts |
16197 |
15555 |
642 |
3.96 |
0 |
17487 |
461 |
642 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_qd_handle_on_reserve_upd_sts |
38658 |
38658 |
0 |
0.00 |
0 |
4540 |
59 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_reserve_write_off |
40035 |
38658 |
1377 |
3.43 |
0 |
8315 |
727 |
1377 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_supplier_invoice |
21740 |
21645 |
95 |
0.43 |
0 |
29968 |
3880 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
sp_supplier_order |
21728 |
21571 |
157 |
0.72 |
0 |
21574 |
2522 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
srv_find_qd_qs_mism |
1087632 |
977014 |
110618 |
10.17 |
0 |
13213 |
41 |
110618 |
2018-05-16 03:46 |
2018-05-16 06:46 |
srv_make_invnt_saldo |
1142 |
1142 |
0 |
0.00 |
15 |
33540 |
6490 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
srv_make_money_saldo |
3864 |
3864 |
0 |
0.00 |
0 |
889 |
64 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2121 |
48563 |
24295 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_add_invoice_to_stock |
8010 |
8010 |
0 |
0.00 |
0 |
10280 |
93 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_adding_invoice |
784 |
784 |
0 |
0.00 |
0 |
2464 |
251 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_client_order |
151 |
151 |
0 |
0.00 |
0 |
811 |
112 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_customer_reserve |
91 |
91 |
0 |
0.00 |
0 |
374 |
53 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_pay_from_customer |
15 |
15 |
0 |
0.00 |
0 |
203 |
43 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_pay_to_supplier |
6 |
6 |
0 |
0.00 |
16 |
203 |
59 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_supplier_invoice |
638 |
638 |
0 |
0.00 |
0 |
2012 |
92 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_supplier_order |
12723 |
12723 |
0 |
0.00 |
0 |
9547 |
204 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_cancel_write_off |
34 |
34 |
0 |
0.00 |
0 |
468 |
74 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_reserve_write_off |
1377 |
1377 |
0 |
0.00 |
0 |
1451 |
68 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_supplier_invoice |
95 |
95 |
0 |
0.00 |
0 |
656 |
88 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-abend:sp_supplier_order |
157 |
157 |
0 |
0.00 |
0 |
1747 |
96 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_add_invoice_to_stock |
12320 |
12320 |
0 |
0.00 |
0 |
21700 |
909 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_adding_invoice |
1371 |
1371 |
0 |
0.00 |
0 |
18813 |
967 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_client_order |
6862 |
6862 |
0 |
0.00 |
0 |
6147 |
59 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_customer_reserve |
2560 |
2560 |
0 |
0.00 |
0 |
1622 |
60 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_pay_from_customer |
2701 |
2701 |
0 |
0.00 |
0 |
1326 |
50 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_pay_to_supplier |
1588 |
1588 |
0 |
0.00 |
0 |
1232 |
50 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_supplier_invoice |
965 |
965 |
0 |
0.00 |
0 |
1841 |
73 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_supplier_order |
545 |
545 |
0 |
0.00 |
0 |
36145 |
3038 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_cancel_write_off |
3833 |
3833 |
0 |
0.00 |
0 |
1295 |
63 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_client_order |
84583 |
84583 |
0 |
0.00 |
0 |
15943 |
76 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_customer_reserve |
3807 |
3807 |
0 |
0.00 |
0 |
4851 |
53 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_pay_from_customer |
28185 |
28185 |
0 |
0.00 |
0 |
12184 |
65 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_pay_to_supplier |
23257 |
23257 |
0 |
0.00 |
0 |
12168 |
64 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_reserve_write_off |
38658 |
38658 |
0 |
0.00 |
0 |
12605 |
72 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_supplier_invoice |
21645 |
21645 |
0 |
0.00 |
0 |
17394 |
78 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:sp_supplier_order |
21571 |
21571 |
0 |
0.00 |
0 |
17051 |
78 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:srv_make_invnt_saldo |
1142 |
1142 |
0 |
0.00 |
0 |
1185 |
25 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:srv_make_money_saldo |
3864 |
3864 |
0 |
0.00 |
0 |
3869 |
25 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
0 |
1451 |
291 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_add_invoice_to_stock |
40660 |
24640 |
16020 |
39.39 |
0 |
14867 |
69 |
16020 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_all_customers |
126700 |
126700 |
0 |
0.00 |
0 |
578 |
6 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_all_suppliers |
86936 |
86432 |
504 |
0.57 |
0 |
561 |
6 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_all_wares |
169166 |
169166 |
0 |
0.00 |
0 |
608 |
5 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_adding_invoice |
3240 |
2742 |
498 |
15.37 |
0 |
4166 |
196 |
498 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_client_order |
14026 |
13724 |
302 |
2.15 |
0 |
3915 |
7 |
302 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_customer_prepayment |
5432 |
5402 |
30 |
0.55 |
0 |
733 |
8 |
30 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_customer_reserve |
5302 |
5120 |
182 |
3.43 |
0 |
655 |
9 |
182 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_payment_to_supplier |
3188 |
3176 |
12 |
0.37 |
0 |
4056 |
10 |
12 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_supplier_invoice |
3206 |
1930 |
1276 |
39.80 |
0 |
8751 |
73 |
1276 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_supplier_order |
3214 |
1090 |
2124 |
66.08 |
0 |
359 |
10 |
2124 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_cancel_write_off |
7734 |
7666 |
68 |
0.87 |
0 |
2621 |
109 |
68 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_max_id_clo_ord |
21728 |
21571 |
157 |
0.72 |
0 |
562 |
6 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_max_id_clo_res |
3807 |
3807 |
0 |
0.00 |
0 |
3697 |
23 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_max_id_ord_sup |
21740 |
21645 |
95 |
0.43 |
0 |
967 |
7 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_max_non_paid_invoice |
23257 |
23257 |
0 |
0.00 |
0 |
1935 |
6 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_max_non_paid_realizn |
28185 |
28185 |
0 |
0.00 |
0 |
983 |
6 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_min_id_clo_ord |
21728 |
21571 |
157 |
0.72 |
0 |
811 |
7 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_min_id_clo_res |
3807 |
3807 |
0 |
0.00 |
0 |
1264 |
10 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_min_id_ord_sup |
21740 |
21645 |
95 |
0.43 |
0 |
1560 |
8 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_min_non_paid_invoice |
23257 |
23257 |
0 |
0.00 |
0 |
2168 |
9 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_min_non_paid_realizn |
28185 |
28185 |
0 |
0.00 |
0 |
1981 |
9 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_our_firm |
42466 |
42466 |
0 |
0.00 |
0 |
936 |
6 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
v_reserve_write_off |
80070 |
77316 |
2754 |
3.43 |
0 |
8174 |
9 |
2754 |
2018-05-16 03:46 |
2018-05-16 06:46 |
x_lock_depdocs_on_canc_invoice |
17528 |
9785 |
7743 |
44.17 |
0 |
2137 |
48 |
7743 |
2018-05-16 03:46 |
2018-05-16 06:46 |
x_lock_depdocs_on_canc_sup_ord |
1603 |
545 |
1058 |
66.00 |
0 |
1341 |
78 |
1058 |
2018-05-16 03:46 |
2018-05-16 06:46 |
x_make_qstorno_1000_1200 |
21728 |
21571 |
157 |
0.72 |
0 |
21153 |
2276 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
x_make_qstorno_1200_2000 |
21740 |
21645 |
95 |
0.43 |
0 |
28564 |
3628 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
x_make_qstorno_2100_3300 |
623869 |
623869 |
0 |
0.00 |
0 |
15225 |
275 |
0 |
2018-05-16 03:46 |
2018-05-16 06:46 |
Done for 298270 ms, from 7:01:49.56 to 7:06:47.83.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
99 |
sp_kill_cost_storno |
335544336 |
2018-05-16 03:47 |
2018-05-16 06:42 |
deadlock |
105 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2018-05-16 03:48 |
2018-05-16 06:46 |
deadlock |
10171 |
sp_lock_selected_doc |
335544336 |
2018-05-16 03:46 |
2018-05-16 06:46 |
deadlock |
146 |
sp_qd_handle_on_cancel_clo |
335544336 |
2018-05-16 03:49 |
2018-05-16 06:45 |
deadlock |
162 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2018-05-16 03:47 |
2018-05-16 06:45 |
deadlock |
623 |
x_lock_depdocs_on_canc_invoice |
335544336 |
2018-05-16 03:47 |
2018-05-16 06:46 |
deadlock |
321 |
x_lock_depdocs_on_canc_sup_ord |
335544336 |
2018-05-16 03:48 |
2018-05-16 06:45 |
user_exc |
157 |
x_make_qstorno_1000_1200 |
335544517 |
2018-05-16 03:47 |
2018-05-16 06:45 |
user_exc |
95 |
x_make_qstorno_1200_2000 |
335544517 |
2018-05-16 03:47 |
2018-05-16 06:46 |
Done for 8720 ms, from 7:06:55.12 to 7:07:03.84.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 442330
MON$OLDEST_ACTIVE 442331
MON$OLDEST_SNAPSHOT 442331
MON$NEXT_TRANSACTION 442331
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:12:20.4040
MON$PAGES 836288
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.4.32972 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.4.32972 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.4.32972 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.4.32972 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Gstat execution time Wed May 16 07:07:04 2018
Database header page information:
Flags 0
Generation 442551
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 442332
Oldest active 442333
Oldest snapshot 442333
Next transaction 442334
Sequence number 0
Next attachment ID 9553
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.06, total records: 2210538
Average version length: 47.77, total versions: 5610, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 24064
Data pages: 24064, average fill: 72%
Primary pages: 24064, secondary pages: 0, swept pages: 15684
Empty pages: 6, full pages: 18522
Fill distribution:
0 - 19% = 8
20 - 39% = 7
40 - 59% = 68
60 - 79% = 23978
80 - 99% = 3
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 10753, nodes: 2210538
Average node length: 19.38, total dup: 0, max dup: 0
Average key length: 16.42, compression ratio: 1.64
Average prefix length: 13.57, average data length: 13.43
Clustering factor: 544318, ratio: 0.25
Fill distribution:
0 - 19% = 591
20 - 39% = 2070
40 - 59% = 5875
60 - 79% = 913
80 - 99% = 1304
Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7948, nodes: 2210538
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.31, average data length: 5.69
Clustering factor: 495400, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 3779
40 - 59% = 4146
60 - 79% = 22
80 - 99% = 1
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 174585, depth: 3, leaf buckets: 4005, nodes: 2210538
Average node length: 6.85, total dup: 1598287, max dup: 49
Average key length: 3.90, compression ratio: 2.31
Average prefix length: 7.38, average data length: 1.62
Clustering factor: 504683, ratio: 0.23
Fill distribution:
0 - 19% = 135
20 - 39% = 1344
40 - 59% = 1903
60 - 79% = 120
80 - 99% = 503
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.26, total records: 678994
Average version length: 36.00, total versions: 3277, max versions: 4
Average fragment length: 12.00, total fragments: 8, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8616
Data pages: 8616, average fill: 75%
Primary pages: 8613, secondary pages: 3, swept pages: 7411
Empty pages: 3, full pages: 7703
Fill distribution:
0 - 19% = 7
20 - 39% = 3
40 - 59% = 15
60 - 79% = 8560
80 - 99% = 31
Index DOC_LIST_ID_DESC (1)
Root page: 254389, depth: 3, leaf buckets: 2536, nodes: 678994
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 179961, ratio: 0.27
Fill distribution:
0 - 19% = 0
20 - 39% = 1500
40 - 59% = 1024
60 - 79% = 11
80 - 99% = 1
Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 714, nodes: 678994
Average node length: 4.88, total dup: 678944, max dup: 44977
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 312283, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 609
60 - 79% = 76
80 - 99% = 28
Index PK_DOC_LIST (0)
Root page: 314834, depth: 3, leaf buckets: 2261, nodes: 678994
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 179961, ratio: 0.27
Fill distribution:
0 - 19% = 143
20 - 39% = 948
40 - 59% = 845
60 - 79% = 119
80 - 99% = 206
DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 63.56, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.65, total fragments: 380, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.64
Pointer pages: 2, data page slots: 349
Data pages: 20, average fill: 31%
Primary pages: 7, secondary pages: 13, swept pages: 4
Empty pages: 8, full pages: 3
Fill distribution:
0 - 19% = 10
20 - 39% = 4
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 34.05, total records: 5795
Average version length: 70.97, total versions: 3023, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 2.82
Pointer pages: 2, data page slots: 2160
Data pages: 304, average fill: 25%
Primary pages: 303, secondary pages: 1, swept pages: 161
Empty pages: 63, full pages: 4
Fill distribution:
0 - 19% = 138
20 - 39% = 85
40 - 59% = 61
60 - 79% = 19
80 - 99% = 1
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 27, nodes: 5795
Average node length: 15.49, total dup: 134, max dup: 1
Average key length: 12.85, compression ratio: 2.10
Average prefix length: 17.12, average data length: 9.88
Clustering factor: 5265, ratio: 0.91
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 9
60 - 79% = 4
80 - 99% = 0
MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 15.02, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.13
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 13.10, total records: 226
Average version length: 46.28, total versions: 162, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 4.88
Pointer pages: 1, data page slots: 72
Data pages: 48, average fill: 6%
Primary pages: 46, secondary pages: 2, swept pages: 31
Empty pages: 32, full pages: 1
Fill distribution:
0 - 19% = 43
20 - 39% = 3
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 251317, depth: 2, leaf buckets: 1, nodes: 226
Average node length: 7.59, total dup: 174, max dup: 29
Average key length: 5.58, compression ratio: 3.40
Average prefix length: 15.64, average data length: 3.36
Clustering factor: 120, ratio: 0.53
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (165)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (166)
Primary pointer page: 366, Index root page: 367
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 41.94, total records: 256489
Average version length: 28.37, total versions: 6862, max versions: 9
Average fragment length: 33.87, total fragments: 15, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.53
Pointer pages: 2, data page slots: 3128
Data pages: 3128, average fill: 62%
Primary pages: 3094, secondary pages: 34, swept pages: 2456
Empty pages: 13, full pages: 703
Fill distribution:
0 - 19% = 61
20 - 39% = 239
40 - 59% = 570
60 - 79% = 2246
80 - 99% = 12
Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 240, nodes: 256489
Average node length: 4.61, total dup: 256440, max dup: 11443
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 39914, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 17
40 - 59% = 100
60 - 79% = 101
80 - 99% = 21
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 298, nodes: 256489
Average node length: 5.56, total dup: 231258, max dup: 64
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 49344, ratio: 0.19
Fill distribution:
0 - 19% = 2
20 - 39% = 19
40 - 59% = 146
60 - 79% = 96
80 - 99% = 35
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 280, nodes: 256489
Average node length: 5.55, total dup: 231258, max dup: 64
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 49404, ratio: 0.19
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 112
60 - 79% = 99
80 - 99% = 52
Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 288, nodes: 256489
Average node length: 5.34, total dup: 231258, max dup: 64
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 49458, ratio: 0.19
Fill distribution:
0 - 19% = 1
20 - 39% = 38
40 - 59% = 122
60 - 79% = 86
80 - 99% = 41
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 280614
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2400
Data pages: 2400, average fill: 64%
Primary pages: 2400, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 2398
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2398
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 249069, depth: 2, leaf buckets: 224, nodes: 280614
Average node length: 4.54, total dup: 280433, max dup: 2805
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 58363, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 84
60 - 79% = 66
80 - 99% = 73
PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.85, total records: 11403581
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.17
Pointer pages: 166, data page slots: 270560
Data pages: 270560, average fill: 87%
Primary pages: 270560, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 270553
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 270553
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 12455, nodes: 11403581
Average node length: 5.66, total dup: 10535823, max dup: 150
Average key length: 2.18, compression ratio: 3.66
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 5844617, ratio: 0.51
Fill distribution:
0 - 19% = 18
20 - 39% = 0
40 - 59% = 6032
60 - 79% = 4381
80 - 99% = 2024
Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11240, nodes: 11403581
Average node length: 4.55, total dup: 11403577, max dup: 10572437
Average key length: 1.07, compression ratio: 0.34
Average prefix length: 0.36, average data length: 0.00
Clustering factor: 351366, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 11234
60 - 79% = 3
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 13476, nodes: 11403581
Average node length: 5.72, total dup: 11027244, max dup: 23973
Average key length: 2.24, compression ratio: 4.01
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 1142260, ratio: 0.10
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 9205
60 - 79% = 2310
80 - 99% = 1956
Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13925, nodes: 11403581
Average node length: 5.55, total dup: 11372817, max dup: 1278307
Average key length: 2.07, compression ratio: 18.20
Average prefix length: 37.67, average data length: 0.07
Clustering factor: 7406628, ratio: 0.65
Fill distribution:
0 - 19% = 22
20 - 39% = 2
40 - 59% = 11995
60 - 79% = 684
80 - 99% = 1222
PHRASES (145)
Primary pointer page: 266, Index root page: 267
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.86, total records: 437175
Average version length: 55.72, total versions: 1559, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 4, data page slots: 5224
Data pages: 5224, average fill: 74%
Primary pages: 5224, secondary pages: 0, swept pages: 3768
Empty pages: 6, full pages: 4458
Fill distribution:
0 - 19% = 8
20 - 39% = 2
40 - 59% = 29
60 - 79% = 5185
80 - 99% = 0
Index PSTORNED_RCV_ID (2)
Root page: 631883, depth: 3, leaf buckets: 608, nodes: 437175
Average node length: 6.03, total dup: 362353, max dup: 763
Average key length: 3.24, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 59712, ratio: 0.14
Fill distribution:
0 - 19% = 17
20 - 39% = 25
40 - 59% = 412
60 - 79% = 114
80 - 99% = 40
Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 459, nodes: 437175
Average node length: 5.59, total dup: 390601, max dup: 130
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 106381, ratio: 0.24
Fill distribution:
0 - 19% = 2
20 - 39% = 9
40 - 59% = 169
60 - 79% = 185
80 - 99% = 94
RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.94, total records: 2672
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.49
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 61%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 1
40 - 59% = 0
60 - 79% = 32
80 - 99% = 0
WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 49.49, total records: 6336
Average version length: 72.21, total versions: 1994, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.75
Pointer pages: 2, data page slots: 2552
Data pages: 608, average fill: 14%
Primary pages: 607, secondary pages: 1, swept pages: 448
Empty pages: 265, full pages: 32
Fill distribution:
0 - 19% = 469
20 - 39% = 65
40 - 59% = 33
60 - 79% = 38
80 - 99% = 3
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 15, nodes: 6336
Average node length: 7.44, total dup: 5470, max dup: 14
Average key length: 4.66, compression ratio: 7.94
Average prefix length: 34.48, average data length: 2.52
Clustering factor: 1050, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 8
40 - 59% = 4
60 - 79% = 1
80 - 99% = 1
XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.65, total records: 1353233
Average version length: 71.82, total versions: 9938, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 13, data page slots: 21168
Data pages: 21136, average fill: 71%
Primary pages: 21136, secondary pages: 0, swept pages: 13698
Empty pages: 231, full pages: 15050
Fill distribution:
0 - 19% = 442
20 - 39% = 672
40 - 59% = 1613
60 - 79% = 18321
80 - 99% = 88
Index XQD_1000_3300_DOC (1)
Root page: 345398, depth: 3, leaf buckets: 1573, nodes: 1353233
Average node length: 5.13, total dup: 1319283, max dup: 132
Average key length: 2.19, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 150685, ratio: 0.11
Fill distribution:
0 - 19% = 22
20 - 39% = 92
40 - 59% = 1203
60 - 79% = 48
80 - 99% = 208
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 238152, depth: 3, leaf buckets: 1995, nodes: 1353233
Average node length: 6.26, total dup: 1182845, max dup: 19
Average key length: 3.31, compression ratio: 11.17
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 258194, ratio: 0.19
Fill distribution:
0 - 19% = 34
20 - 39% = 171
40 - 59% = 1554
60 - 79% = 149
80 - 99% = 87
XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 51.12, total records: 27600
Average version length: 72.15, total versions: 8030, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.66
Pointer pages: 4, data page slots: 5320
Data pages: 2321, average fill: 15%
Primary pages: 2316, secondary pages: 5, swept pages: 1737
Empty pages: 1127, full pages: 113
Fill distribution:
0 - 19% = 1669
20 - 39% = 338
40 - 59% = 143
60 - 79% = 132
80 - 99% = 39
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 60, nodes: 27600
Average node length: 6.51, total dup: 24396, max dup: 48
Average key length: 3.58, compression ratio: 10.34
Average prefix length: 35.53, average data length: 1.47
Clustering factor: 3570, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 22
60 - 79% = 4
80 - 99% = 0
XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 68.14, total records: 1717808
Average version length: 71.89, total versions: 96202, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.00
Pointer pages: 18, data page slots: 29128
Data pages: 29056, average fill: 66%
Primary pages: 29055, secondary pages: 1, swept pages: 18197
Empty pages: 332, full pages: 15373
Fill distribution:
0 - 19% = 875
20 - 39% = 1900
40 - 59% = 4890
60 - 79% = 19822
80 - 99% = 1569
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 196318, depth: 3, leaf buckets: 2723, nodes: 1717808
Average node length: 5.61, total dup: 1615254, max dup: 63
Average key length: 2.65, compression ratio: 13.94
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 249024, ratio: 0.14
Fill distribution:
0 - 19% = 22
20 - 39% = 1218
40 - 59% = 1072
60 - 79% = 266
80 - 99% = 145
XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 10.90, total records: 5018
Average version length: 70.38, total versions: 4243, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 12.48
Pointer pages: 4, data page slots: 4216
Data pages: 720, average fill: 10%
Primary pages: 716, secondary pages: 4, swept pages: 469
Empty pages: 467, full pages: 24
Fill distribution:
0 - 19% = 608
20 - 39% = 41
40 - 59% = 28
60 - 79% = 29
80 - 99% = 14
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 15, nodes: 5018
Average node length: 8.82, total dup: 3972, max dup: 38
Average key length: 5.83, compression ratio: 6.34
Average prefix length: 33.37, average data length: 3.63
Clustering factor: 805, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 4
60 - 79% = 1
80 - 99% = 0
XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.77, total records: 2792299
Average version length: 71.21, total versions: 32206, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 25, data page slots: 40672
Data pages: 40672, average fill: 75%
Primary pages: 40672, secondary pages: 0, swept pages: 30827
Empty pages: 11, full pages: 33249
Fill distribution:
0 - 19% = 52
20 - 39% = 172
40 - 59% = 1061
60 - 79% = 38719
80 - 99% = 668
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5687, nodes: 2792299
Average node length: 6.89, total dup: 2259262, max dup: 19
Average key length: 3.92, compression ratio: 9.45
Average prefix length: 35.27, average data length: 1.73
Clustering factor: 596865, ratio: 0.21
Fill distribution:
0 - 19% = 10
20 - 39% = 2913
40 - 59% = 2314
60 - 79% = 270
80 - 99% = 180
XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.76, total records: 4844254
Average version length: 84.23, total versions: 3747, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 46, data page slots: 74568
Data pages: 74568, average fill: 80%
Primary pages: 74568, secondary pages: 0, swept pages: 29695
Empty pages: 8, full pages: 73846
Fill distribution:
0 - 19% = 11
20 - 39% = 5
40 - 59% = 40
60 - 79% = 22523
80 - 99% = 51989
Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4933, nodes: 4844254
Average node length: 5.16, total dup: 4733724, max dup: 132
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 787153, ratio: 0.16
Fill distribution:
0 - 19% = 22
20 - 39% = 78
40 - 59% = 2126
60 - 79% = 2128
80 - 99% = 579
Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5718, nodes: 4844254
Average node length: 5.69, total dup: 4339040, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 287098, ratio: 0.06
Fill distribution:
0 - 19% = 54
20 - 39% = 195
40 - 59% = 3843
60 - 79% = 238
80 - 99% = 1388
Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5490, nodes: 4844254
Average node length: 5.81, total dup: 4239034, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 844205, ratio: 0.17
Fill distribution:
0 - 19% = 26
20 - 39% = 86
40 - 59% = 2360
60 - 79% = 2170
80 - 99% = 848
XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.53, total records: 2308021
Average version length: 83.44, total versions: 17709, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 23, data page slots: 36552
Data pages: 36552, average fill: 78%
Primary pages: 36552, secondary pages: 0, swept pages: 27385
Empty pages: 16, full pages: 32947
Fill distribution:
0 - 19% = 70
20 - 39% = 217
40 - 59% = 616
60 - 79% = 17502
80 - 99% = 18147
Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2470, nodes: 2308021
Average node length: 5.15, total dup: 2254137, max dup: 188
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 359624, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 46
40 - 59% = 1455
60 - 79% = 730
80 - 99% = 238
Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4130, nodes: 2308021
Average node length: 6.21, total dup: 1898352, max dup: 14
Average key length: 3.24, compression ratio: 2.78
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 253649, ratio: 0.11
Fill distribution:
0 - 19% = 107
20 - 39% = 1862
40 - 59% = 1621
60 - 79% = 386
80 - 99% = 154
Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2851, nodes: 2308021
Average node length: 5.81, total dup: 2020044, max dup: 36
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 428149, ratio: 0.19
Fill distribution:
0 - 19% = 22
20 - 39% = 45
40 - 59% = 1776
60 - 79% = 757
80 - 99% = 251
XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.17, total records: 5160293
Average version length: 85.61, total versions: 45284, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 51, data page slots: 81808
Data pages: 81808, average fill: 78%
Primary pages: 81808, secondary pages: 0, swept pages: 30953
Empty pages: 163, full pages: 73559
Fill distribution:
0 - 19% = 337
20 - 39% = 711
40 - 59% = 2317
60 - 79% = 22855
80 - 99% = 55588
Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5588, nodes: 5160293
Average node length: 5.04, total dup: 5130259, max dup: 685
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 805357, ratio: 0.16
Fill distribution:
0 - 19% = 7
20 - 39% = 332
40 - 59% = 3271
60 - 79% = 1485
80 - 99% = 493
Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6579, nodes: 5160293
Average node length: 5.53, total dup: 4751840, max dup: 49
Average key length: 2.54, compression ratio: 3.54
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 351967, ratio: 0.07
Fill distribution:
0 - 19% = 84
20 - 39% = 1993
40 - 59% = 2737
60 - 79% = 543
80 - 99% = 1222
Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 6302, nodes: 5160293
Average node length: 5.68, total dup: 4634795, max dup: 98
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 887807, ratio: 0.17
Fill distribution:
0 - 19% = 5
20 - 39% = 320
40 - 59% = 3788
60 - 79% = 1667
80 - 99% = 522
XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_DOC_ID (0)
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.05, total records: 3517301
Average version length: 84.10, total versions: 24673, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 35, data page slots: 55840
Data pages: 55840, average fill: 78%
Primary pages: 55840, secondary pages: 0, swept pages: 41805
Empty pages: 22, full pages: 50070
Fill distribution:
0 - 19% = 93
20 - 39% = 178
40 - 59% = 844
60 - 79% = 26747
80 - 99% = 27978
Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3758, nodes: 3517301
Average node length: 5.03, total dup: 3499461, max dup: 1278
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 806233, ratio: 0.23
Fill distribution:
0 - 19% = 33
20 - 39% = 306
40 - 59% = 1988
60 - 79% = 980
80 - 99% = 451
Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 6581, nodes: 3517301
Average node length: 6.24, total dup: 2881263, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 451415, ratio: 0.13
Fill distribution:
0 - 19% = 260
20 - 39% = 3168
40 - 59% = 2419
60 - 79% = 507
80 - 99% = 227
Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 4120, nodes: 3517301
Average node length: 5.60, total dup: 3205271, max dup: 91
Average key length: 2.62, compression ratio: 3.44
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 841061, ratio: 0.24
Fill distribution:
0 - 19% = 9
20 - 39% = 335
40 - 59% = 2074
60 - 79% = 1184
80 - 99% = 518
XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.04, total records: 736782
Average version length: 69.64, total versions: 4247, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 7, data page slots: 10368
Data pages: 10368, average fill: 75%
Primary pages: 10368, secondary pages: 0, swept pages: 8025
Empty pages: 10, full pages: 9353
Fill distribution:
0 - 19% = 63
20 - 39% = 134
40 - 59% = 252
60 - 79% = 9818
80 - 99% = 101
Index XQS_3300_3400_DOC_ID (0)
Root page: 176808, depth: 3, leaf buckets: 863, nodes: 736782
Average node length: 5.30, total dup: 697534, max dup: 119
Average key length: 2.41, compression ratio: 3.74
Average prefix length: 8.65, average data length: 0.35
Clustering factor: 57991, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 162
40 - 59% = 366
60 - 79% = 242
80 - 99% = 93
Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 982, nodes: 736782
Average node length: 5.93, total dup: 631400, max dup: 29
Average key length: 3.03, compression ratio: 2.97
Average prefix length: 8.11, average data length: 0.89
Clustering factor: 63694, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 211
40 - 59% = 402
60 - 79% = 273
80 - 99% = 93
ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (229)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 646, Index root page: 647
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (234)
Primary pointer page: 652, Index root page: 653
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (235)
Primary pointer page: 654, Index root page: 655
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (232)
Primary pointer page: 648, Index root page: 649
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (233)
Primary pointer page: 650, Index root page: 651
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (228)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (227)
Primary pointer page: 614, Index root page: 615
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Z_USED_VIEWS (146)
Primary pointer page: 268, Index root page: 269
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Gstat completion time Wed May 16 07:10:09 2018
Done for 185600 ms, from 7:07:04.19 to 7:10:09.79.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
2210538 |
5610 |
0.2537 |
DOC_LIST |
678994 |
3277 |
0.4826 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
5795 |
3023 |
52.1656 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
226 |
162 |
71.6814 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
256489 |
6862 |
2.6753 |
PERF_ESTIMATED |
280614 |
0 |
0.0000 |
PERF_LOG |
11403581 |
0 |
0.0000 |
PSTORNED |
437175 |
1559 |
0.3566 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
0 |
0.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
2672 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
6336 |
1994 |
31.4709 |
XQD_1000_3300 |
1353233 |
9938 |
0.7343 |
XQD_1200_2000 |
27600 |
8030 |
29.0942 |
XQD_2000_3300 |
1717808 |
96202 |
5.6002 |
XQD_2100_3300 |
5018 |
4243 |
84.5555 |
XQD_3300_3400 |
2792299 |
32206 |
1.1533 |
XQS_1000_1200 |
4844254 |
3747 |
0.0773 |
XQS_1000_3300 |
2308021 |
17709 |
0.7672 |
XQS_1200_2000 |
5160293 |
45284 |
0.8775 |
XQS_2100_3300 |
3517301 |
24673 |
0.7014 |
XQS_3300_3400 |
736782 |
4247 |
0.5764 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2030 ms, from 7:10:21.72 to 7:10:23.75.
07:10:23.83 Validation started
07:10:23.83 Relation 140 (DOC_LIST)
07:10:23.83 process pointer page 0 of 6
07:10:23.89 process pointer page 1 of 6
07:10:24.00 process pointer page 2 of 6
07:10:24.11 process pointer page 3 of 6
07:10:24.22 process pointer page 4 of 6
07:10:24.33 process pointer page 5 of 6
07:10:24.36 Index 1 (PK_DOC_LIST)
07:10:24.51 Index 2 (DOC_LIST_ID_DESC)
07:10:24.62 Index 3 (FK_DOC_LIST_AGENTS)
07:10:24.70 Relation 140 (DOC_LIST) is ok
07:10:24.70 Relation 141 (DOC_DATA)
07:10:24.70 process pointer page 0 of 15
07:10:24.73 process pointer page 1 of 15
07:10:24.76 process pointer page 2 of 15
07:10:24.78 process pointer page 3 of 15
07:10:24.81 process pointer page 4 of 15
07:10:24.84 process pointer page 5 of 15
07:10:24.86 process pointer page 6 of 15
07:10:24.89 process pointer page 7 of 15
07:10:24.94 process pointer page 8 of 15
07:10:24.97 process pointer page 9 of 15
07:10:25.00 process pointer page 10 of 15
07:10:25.01 process pointer page 11 of 15
07:10:25.04 process pointer page 12 of 15
07:10:25.08 process pointer page 13 of 15
07:10:25.09 process pointer page 14 of 15
07:10:25.12 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:10:26.04 Index 3 (DOC_DATA_ID_DESC)
07:10:26.53 Index 4 (FK_DOC_DATA_DOC_LIST)
07:10:27.06 Relation 141 (DOC_DATA) is ok
07:10:27.06 Relation 147 (INVNT_SALDO)
07:10:27.07 process pointer page 0 of 2
07:10:27.07 process pointer page 1 of 2
07:10:27.07 Index 1 (PK_INVNT_SALDO)
07:10:27.07 Relation 147 (INVNT_SALDO) is ok
07:10:27.07 Relation 150 (PDISTR)
07:10:27.07 process pointer page 0 of 2
07:10:27.12 process pointer page 1 of 2
07:10:27.15 Index 2 (PDISTR_SND_ID)
07:10:27.18 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:10:27.21 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:10:27.24 Index 5 (PDISTR_AGENT_ID)
07:10:27.26 Relation 150 (PDISTR) is ok
07:10:27.26 Relation 151 (PSTORNED)
07:10:27.26 process pointer page 0 of 4
07:10:27.31 process pointer page 1 of 4
07:10:27.40 process pointer page 2 of 4
07:10:27.45 process pointer page 3 of 4
07:10:27.46 Index 2 (PSTORNED_SND_ID)
07:10:27.51 Index 3 (PSTORNED_RCV_ID)
07:10:27.56 Relation 151 (PSTORNED) is ok
07:10:27.56 Relation 156 (SEMAPHORES)
07:10:27.56 process pointer page 0 of 1
07:10:27.56 Index 1 (PK_SEMAPHORES)
07:10:27.56 Index 2 (SEMAPHORES_TASK_UNQ)
07:10:27.56 Relation 156 (SEMAPHORES) is ok
07:10:27.56 Relation 157 (INVNT_TURNOVER_LOG)
07:10:27.56 process pointer page 0 of 2
07:10:27.57 process pointer page 1 of 2
07:10:27.57 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:10:27.57 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:10:27.57 Relation 160 (PERF_ESTIMATED)
07:10:27.57 process pointer page 0 of 2
07:10:27.65 process pointer page 1 of 2
07:10:27.70 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:10:27.79 Relation 160 (PERF_ESTIMATED) is ok
07:10:27.79 Relation 161 (PERF_ISQL_STAT)
07:10:27.79 process pointer page 0 of 1
07:10:27.79 Index 1 (PERF_ISQL_STAT_TRN)
07:10:27.79 Relation 161 (PERF_ISQL_STAT) is ok
07:10:27.79 Relation 162 (TRACE_STAT)
07:10:27.79 process pointer page 0 of 1
07:10:27.79 Relation 162 (TRACE_STAT) is ok
07:10:27.79 Relation 163 (PERF_LOG)
07:10:27.79 process pointer page 0 of 166
07:10:27.87 process pointer page 1 of 166
07:10:27.95 process pointer page 2 of 166
07:10:28.02 process pointer page 3 of 166
07:10:28.07 process pointer page 4 of 166
07:10:28.10 process pointer page 5 of 166
07:10:28.13 process pointer page 6 of 166
07:10:28.21 process pointer page 7 of 166
07:10:28.29 process pointer page 8 of 166
07:10:28.37 process pointer page 9 of 166
07:10:28.46 process pointer page 10 of 166
07:10:28.54 process pointer page 11 of 166
07:10:28.62 process pointer page 12 of 166
07:10:28.70 process pointer page 13 of 166
07:10:28.77 process pointer page 14 of 166
07:10:28.87 process pointer page 15 of 166
07:10:28.94 process pointer page 16 of 166
07:10:29.02 process pointer page 17 of 166
07:10:29.09 process pointer page 18 of 166
07:10:29.12 process pointer page 19 of 166
07:10:29.19 process pointer page 20 of 166
07:10:29.27 process pointer page 21 of 166
07:10:29.35 process pointer page 22 of 166
07:10:29.40 process pointer page 23 of 166
07:10:29.43 process pointer page 24 of 166
07:10:29.46 process pointer page 25 of 166
07:10:29.49 process pointer page 26 of 166
07:10:29.52 process pointer page 27 of 166
07:10:29.55 process pointer page 28 of 166
07:10:29.57 process pointer page 29 of 166
07:10:29.60 process pointer page 30 of 166
07:10:29.63 process pointer page 31 of 166
07:10:29.65 process pointer page 32 of 166
07:10:29.68 process pointer page 33 of 166
07:10:29.71 process pointer page 34 of 166
07:10:29.72 process pointer page 35 of 166
07:10:29.74 process pointer page 36 of 166
07:10:29.77 process pointer page 37 of 166
07:10:29.79 process pointer page 38 of 166
07:10:29.82 process pointer page 39 of 166
07:10:29.83 process pointer page 40 of 166
07:10:29.87 process pointer page 41 of 166
07:10:29.88 process pointer page 42 of 166
07:10:29.91 process pointer page 43 of 166
07:10:29.93 process pointer page 44 of 166
07:10:29.94 process pointer page 45 of 166
07:10:29.97 process pointer page 46 of 166
07:10:29.99 process pointer page 47 of 166
07:10:30.02 process pointer page 48 of 166
07:10:30.04 process pointer page 49 of 166
07:10:30.07 process pointer page 50 of 166
07:10:30.08 process pointer page 51 of 166
07:10:30.11 process pointer page 52 of 166
07:10:30.13 process pointer page 53 of 166
07:10:30.16 process pointer page 54 of 166
07:10:30.18 process pointer page 55 of 166
07:10:30.19 process pointer page 56 of 166
07:10:30.22 process pointer page 57 of 166
07:10:30.24 process pointer page 58 of 166
07:10:30.27 process pointer page 59 of 166
07:10:30.30 process pointer page 60 of 166
07:10:30.33 process pointer page 61 of 166
07:10:30.41 process pointer page 62 of 166
07:10:30.44 process pointer page 63 of 166
07:10:30.47 process pointer page 64 of 166
07:10:30.50 process pointer page 65 of 166
07:10:30.57 process pointer page 66 of 166
07:10:30.65 process pointer page 67 of 166
07:10:30.72 process pointer page 68 of 166
07:10:30.80 process pointer page 69 of 166
07:10:30.88 process pointer page 70 of 166
07:10:30.96 process pointer page 71 of 166
07:10:31.04 process pointer page 72 of 166
07:10:31.13 process pointer page 73 of 166
07:10:31.21 process pointer page 74 of 166
07:10:31.28 process pointer page 75 of 166
07:10:31.36 process pointer page 76 of 166
07:10:31.44 process pointer page 77 of 166
07:10:31.47 process pointer page 78 of 166
07:10:31.50 process pointer page 79 of 166
07:10:31.53 process pointer page 80 of 166
07:10:31.57 process pointer page 81 of 166
07:10:31.60 process pointer page 82 of 166
07:10:31.61 process pointer page 83 of 166
07:10:31.71 process pointer page 84 of 166
07:10:31.75 process pointer page 85 of 166
07:10:31.78 process pointer page 86 of 166
07:10:31.82 process pointer page 87 of 166
07:10:31.88 process pointer page 88 of 166
07:10:31.96 process pointer page 89 of 166
07:10:32.05 process pointer page 90 of 166
07:10:32.10 process pointer page 91 of 166
07:10:32.13 process pointer page 92 of 166
07:10:32.16 process pointer page 93 of 166
07:10:32.19 process pointer page 94 of 166
07:10:32.22 process pointer page 95 of 166
07:10:32.25 process pointer page 96 of 166
07:10:32.28 process pointer page 97 of 166
07:10:32.33 process pointer page 98 of 166
07:10:32.41 process pointer page 99 of 166
07:10:32.45 process pointer page 100 of 166
07:10:32.49 process pointer page 101 of 166
07:10:32.52 process pointer page 102 of 166
07:10:32.55 process pointer page 103 of 166
07:10:32.58 process pointer page 104 of 166
07:10:32.61 process pointer page 105 of 166
07:10:32.64 process pointer page 106 of 166
07:10:32.67 process pointer page 107 of 166
07:10:32.70 process pointer page 108 of 166
07:10:32.74 process pointer page 109 of 166
07:10:32.77 process pointer page 110 of 166
07:10:32.83 process pointer page 111 of 166
07:10:32.86 process pointer page 112 of 166
07:10:32.89 process pointer page 113 of 166
07:10:32.92 process pointer page 114 of 166
07:10:32.99 process pointer page 115 of 166
07:10:33.02 process pointer page 116 of 166
07:10:33.11 process pointer page 117 of 166
07:10:33.19 process pointer page 118 of 166
07:10:33.22 process pointer page 119 of 166
07:10:33.25 process pointer page 120 of 166
07:10:33.28 process pointer page 121 of 166
07:10:33.31 process pointer page 122 of 166
07:10:33.36 process pointer page 123 of 166
07:10:33.44 process pointer page 124 of 166
07:10:33.52 process pointer page 125 of 166
07:10:33.61 process pointer page 126 of 166
07:10:33.69 process pointer page 127 of 166
07:10:33.77 process pointer page 128 of 166
07:10:33.84 process pointer page 129 of 166
07:10:33.92 process pointer page 130 of 166
07:10:34.00 process pointer page 131 of 166
07:10:34.05 process pointer page 132 of 166
07:10:34.08 process pointer page 133 of 166
07:10:34.11 process pointer page 134 of 166
07:10:34.14 process pointer page 135 of 166
07:10:34.17 process pointer page 136 of 166
07:10:34.20 process pointer page 137 of 166
07:10:34.23 process pointer page 138 of 166
07:10:34.26 process pointer page 139 of 166
07:10:34.30 process pointer page 140 of 166
07:10:34.33 process pointer page 141 of 166
07:10:34.34 process pointer page 142 of 166
07:10:34.37 process pointer page 143 of 166
07:10:34.40 process pointer page 144 of 166
07:10:34.45 process pointer page 145 of 166
07:10:34.53 process pointer page 146 of 166
07:10:34.56 process pointer page 147 of 166
07:10:34.59 process pointer page 148 of 166
07:10:34.62 process pointer page 149 of 166
07:10:34.65 process pointer page 150 of 166
07:10:34.69 process pointer page 151 of 166
07:10:34.72 process pointer page 152 of 166
07:10:34.76 process pointer page 153 of 166
07:10:34.79 process pointer page 154 of 166
07:10:34.83 process pointer page 155 of 166
07:10:34.86 process pointer page 156 of 166
07:10:34.92 process pointer page 157 of 166
07:10:34.98 process pointer page 158 of 166
07:10:35.01 process pointer page 159 of 166
07:10:35.09 process pointer page 160 of 166
07:10:35.12 process pointer page 161 of 166
07:10:35.15 process pointer page 162 of 166
07:10:35.18 process pointer page 163 of 166
07:10:35.22 process pointer page 164 of 166
07:10:35.23 process pointer page 165 of 166
07:10:35.26 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:10:39.05 Index 2 (PERF_LOG_UNIT)
07:10:42.63 Index 3 (PERF_LOG_TRN_DESC)
07:10:43.91 Index 4 (PERF_LOG_GDSCODE)
07:10:45.36 Relation 163 (PERF_LOG) is ok
07:10:45.36 Relation 167 (V_STOPTEST)
07:10:45.36 Relation 167 (V_STOPTEST) is ok
07:10:45.36 Relation 184 (V_QDISTR_SOURCE)
07:10:45.36 Relation 184 (V_QDISTR_SOURCE) is ok
07:10:45.36 Relation 185 (V_QSTORNED_SOURCE)
07:10:45.36 Relation 185 (V_QSTORNED_SOURCE) is ok
07:10:45.36 Relation 260 (XQD_1000_1200)
07:10:45.36 process pointer page 0 of 2
07:10:45.37 process pointer page 1 of 2
07:10:45.37 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:10:45.37 Relation 260 (XQD_1000_1200) is ok
07:10:45.37 Relation 261 (XQD_1200_2000)
07:10:45.37 process pointer page 0 of 4
07:10:45.39 process pointer page 1 of 4
07:10:45.39 process pointer page 2 of 4
07:10:45.40 process pointer page 3 of 4
07:10:45.42 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:10:45.42 Relation 261 (XQD_1200_2000) is ok
07:10:45.42 Relation 262 (XQD_1000_3300)
07:10:45.42 process pointer page 0 of 13
07:10:45.45 process pointer page 1 of 13
07:10:45.48 process pointer page 2 of 13
07:10:45.51 process pointer page 3 of 13
07:10:45.54 process pointer page 4 of 13
07:10:45.57 process pointer page 5 of 13
07:10:45.61 process pointer page 6 of 13
07:10:45.64 process pointer page 7 of 13
07:10:45.65 process pointer page 8 of 13
07:10:45.68 process pointer page 9 of 13
07:10:45.71 process pointer page 10 of 13
07:10:45.73 process pointer page 11 of 13
07:10:45.76 process pointer page 12 of 13
07:10:45.78 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:10:45.92 Index 2 (XQD_1000_3300_DOC)
07:10:46.09 Relation 262 (XQD_1000_3300) is ok
07:10:46.09 Relation 263 (XQD_2000_3300)
07:10:46.09 process pointer page 0 of 18
07:10:46.18 process pointer page 1 of 18
07:10:46.28 process pointer page 2 of 18
07:10:46.35 process pointer page 3 of 18
07:10:46.40 process pointer page 4 of 18
07:10:46.45 process pointer page 5 of 18
07:10:46.48 process pointer page 6 of 18
07:10:46.53 process pointer page 7 of 18
07:10:46.56 process pointer page 8 of 18
07:10:46.60 process pointer page 9 of 18
07:10:46.70 process pointer page 10 of 18
07:10:46.79 process pointer page 11 of 18
07:10:46.88 process pointer page 12 of 18
07:10:46.96 process pointer page 13 of 18
07:10:47.06 process pointer page 14 of 18
07:10:47.10 process pointer page 15 of 18
07:10:47.13 process pointer page 16 of 18
07:10:47.18 process pointer page 17 of 18
07:10:47.20 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:10:47.52 Relation 263 (XQD_2000_3300) is ok
07:10:47.52 Relation 264 (XQD_2100_3300)
07:10:47.52 process pointer page 0 of 4
07:10:47.52 process pointer page 1 of 4
07:10:47.52 process pointer page 2 of 4
07:10:47.54 process pointer page 3 of 4
07:10:47.54 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:10:47.54 Relation 264 (XQD_2100_3300) is ok
07:10:47.54 Relation 265 (XQD_3300_3400)
07:10:47.54 process pointer page 0 of 25
07:10:47.57 process pointer page 1 of 25
07:10:47.65 process pointer page 2 of 25
07:10:47.68 process pointer page 3 of 25
07:10:47.71 process pointer page 4 of 25
07:10:47.74 process pointer page 5 of 25
07:10:47.77 process pointer page 6 of 25
07:10:47.87 process pointer page 7 of 25
07:10:47.93 process pointer page 8 of 25
07:10:47.98 process pointer page 9 of 25
07:10:48.01 process pointer page 10 of 25
07:10:48.04 process pointer page 11 of 25
07:10:48.07 process pointer page 12 of 25
07:10:48.10 process pointer page 13 of 25
07:10:48.13 process pointer page 14 of 25
07:10:48.16 process pointer page 15 of 25
07:10:48.23 process pointer page 16 of 25
07:10:48.32 process pointer page 17 of 25
07:10:48.41 process pointer page 18 of 25
07:10:48.49 process pointer page 19 of 25
07:10:48.59 process pointer page 20 of 25
07:10:48.66 process pointer page 21 of 25
07:10:48.76 process pointer page 22 of 25
07:10:48.85 process pointer page 23 of 25
07:10:48.93 process pointer page 24 of 25
07:10:49.01 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:10:49.96 Relation 265 (XQD_3300_3400) is ok
07:10:49.96 Relation 266 (XQS_1000_1200)
07:10:49.97 process pointer page 0 of 46
07:10:50.05 process pointer page 1 of 46
07:10:50.10 process pointer page 2 of 46
07:10:50.16 process pointer page 3 of 46
07:10:50.24 process pointer page 4 of 46
07:10:50.33 process pointer page 5 of 46
07:10:50.41 process pointer page 6 of 46
07:10:50.50 process pointer page 7 of 46
07:10:50.60 process pointer page 8 of 46
07:10:50.68 process pointer page 9 of 46
07:10:50.72 process pointer page 10 of 46
07:10:50.78 process pointer page 11 of 46
07:10:50.86 process pointer page 12 of 46
07:10:50.96 process pointer page 13 of 46
07:10:51.00 process pointer page 14 of 46
07:10:51.03 process pointer page 15 of 46
07:10:51.08 process pointer page 16 of 46
07:10:51.11 process pointer page 17 of 46
07:10:51.17 process pointer page 18 of 46
07:10:51.27 process pointer page 19 of 46
07:10:51.30 process pointer page 20 of 46
07:10:51.36 process pointer page 21 of 46
07:10:51.46 process pointer page 22 of 46
07:10:51.53 process pointer page 23 of 46
07:10:51.63 process pointer page 24 of 46
07:10:51.69 process pointer page 25 of 46
07:10:51.72 process pointer page 26 of 46
07:10:51.78 process pointer page 27 of 46
07:10:51.81 process pointer page 28 of 46
07:10:51.91 process pointer page 29 of 46
07:10:51.99 process pointer page 30 of 46
07:10:52.08 process pointer page 31 of 46
07:10:52.11 process pointer page 32 of 46
07:10:52.14 process pointer page 33 of 46
07:10:52.17 process pointer page 34 of 46
07:10:52.25 process pointer page 35 of 46
07:10:52.30 process pointer page 36 of 46
07:10:52.33 process pointer page 37 of 46
07:10:52.38 process pointer page 38 of 46
07:10:52.44 process pointer page 39 of 46
07:10:52.50 process pointer page 40 of 46
07:10:52.53 process pointer page 41 of 46
07:10:52.56 process pointer page 42 of 46
07:10:52.59 process pointer page 43 of 46
07:10:52.64 process pointer page 44 of 46
07:10:52.67 process pointer page 45 of 46
07:10:52.69 Index 1 (XQS_1000_1200_DOC_ID)
07:10:53.95 Index 2 (XQS_1000_1200_SND_ID)
07:10:54.56 Index 3 (XQS_1000_1200_RCV_ID)
07:10:54.92 Relation 266 (XQS_1000_1200) is ok
07:10:54.92 Relation 267 (XQS_1200_2000)
07:10:54.92 process pointer page 0 of 51
07:10:54.93 process pointer page 1 of 51
07:10:54.97 process pointer page 2 of 51
07:10:54.98 process pointer page 3 of 51
07:10:55.01 process pointer page 4 of 51
07:10:55.04 process pointer page 5 of 51
07:10:55.07 process pointer page 6 of 51
07:10:55.12 process pointer page 7 of 51
07:10:55.15 process pointer page 8 of 51
07:10:55.20 process pointer page 9 of 51
07:10:55.25 process pointer page 10 of 51
07:10:55.31 process pointer page 11 of 51
07:10:55.37 process pointer page 12 of 51
07:10:55.40 process pointer page 13 of 51
07:10:55.45 process pointer page 14 of 51
07:10:55.50 process pointer page 15 of 51
07:10:55.53 process pointer page 16 of 51
07:10:55.57 process pointer page 17 of 51
07:10:55.61 process pointer page 18 of 51
07:10:55.64 process pointer page 19 of 51
07:10:55.67 process pointer page 20 of 51
07:10:55.78 process pointer page 21 of 51
07:10:55.81 process pointer page 22 of 51
07:10:55.85 process pointer page 23 of 51
07:10:55.93 process pointer page 24 of 51
07:10:56.00 process pointer page 25 of 51
07:10:56.04 process pointer page 26 of 51
07:10:56.07 process pointer page 27 of 51
07:10:56.12 process pointer page 28 of 51
07:10:56.21 process pointer page 29 of 51
07:10:56.31 process pointer page 30 of 51
07:10:56.42 process pointer page 31 of 51
07:10:56.46 process pointer page 32 of 51
07:10:56.51 process pointer page 33 of 51
07:10:56.54 process pointer page 34 of 51
07:10:56.59 process pointer page 35 of 51
07:10:56.62 process pointer page 36 of 51
07:10:56.65 process pointer page 37 of 51
07:10:56.70 process pointer page 38 of 51
07:10:56.73 process pointer page 39 of 51
07:10:56.76 process pointer page 40 of 51
07:10:56.79 process pointer page 41 of 51
07:10:56.82 process pointer page 42 of 51
07:10:57.01 process pointer page 43 of 51
07:10:57.31 process pointer page 44 of 51
07:10:57.65 process pointer page 45 of 51
07:10:58.07 process pointer page 46 of 51
07:10:58.37 process pointer page 47 of 51
07:10:58.74 process pointer page 48 of 51
07:10:59.07 process pointer page 49 of 51
07:10:59.44 process pointer page 50 of 51
07:10:59.51 Index 1 (XQS_1200_2000_DOC_ID)
07:11:02.38 Index 2 (XQS_1200_2000_SND_ID)
07:11:04.87 Index 3 (XQS_1200_2000_RCV_ID)
07:11:07.52 Relation 267 (XQS_1200_2000) is ok
07:11:07.52 Relation 268 (XQS_1000_3300)
07:11:07.52 process pointer page 0 of 23
07:11:08.01 process pointer page 1 of 23
07:11:08.51 process pointer page 2 of 23
07:11:09.02 process pointer page 3 of 23
07:11:09.50 process pointer page 4 of 23
07:11:10.00 process pointer page 5 of 23
07:11:10.50 process pointer page 6 of 23
07:11:11.00 process pointer page 7 of 23
07:11:11.50 process pointer page 8 of 23
07:11:12.00 process pointer page 9 of 23
07:11:12.50 process pointer page 10 of 23
07:11:13.00 process pointer page 11 of 23
07:11:13.48 process pointer page 12 of 23
07:11:13.98 process pointer page 13 of 23
07:11:14.47 process pointer page 14 of 23
07:11:14.93 process pointer page 15 of 23
07:11:15.43 process pointer page 16 of 23
07:11:15.92 process pointer page 17 of 23
07:11:16.40 process pointer page 18 of 23
07:11:16.88 process pointer page 19 of 23
07:11:17.38 process pointer page 20 of 23
07:11:17.79 process pointer page 21 of 23
07:11:18.09 process pointer page 22 of 23
07:11:18.23 Index 1 (XQS_1000_3300_DOC_ID)
07:11:19.54 Index 2 (XQS_1000_3300_SND_ID)
07:11:20.83 Index 3 (XQS_1000_3300_RCV_ID)
07:11:22.44 Relation 268 (XQS_1000_3300) is ok
07:11:22.44 Relation 269 (XQS_2000_3300)
07:11:22.44 process pointer page 0 of 1
07:11:22.44 Index 1 (XQS_2000_3300_DOC_ID)
07:11:22.44 Index 2 (XQS_2000_3300_SND_ID)
07:11:22.44 Index 3 (XQS_2000_3300_RCV_ID)
07:11:22.44 Relation 269 (XQS_2000_3300) is ok
07:11:22.44 Relation 270 (XQS_2100_3300)
07:11:22.44 process pointer page 0 of 35
07:11:22.92 process pointer page 1 of 35
07:11:23.42 process pointer page 2 of 35
07:11:23.94 process pointer page 3 of 35
07:11:24.43 process pointer page 4 of 35
07:11:24.93 process pointer page 5 of 35
07:11:25.43 process pointer page 6 of 35
07:11:25.93 process pointer page 7 of 35
07:11:26.43 process pointer page 8 of 35
07:11:26.93 process pointer page 9 of 35
07:11:27.43 process pointer page 10 of 35
07:11:27.93 process pointer page 11 of 35
07:11:28.43 process pointer page 12 of 35
07:11:28.82 process pointer page 13 of 35
07:11:29.32 process pointer page 14 of 35
07:11:29.75 process pointer page 15 of 35
07:11:30.22 process pointer page 16 of 35
07:11:30.71 process pointer page 17 of 35
07:11:31.22 process pointer page 18 of 35
07:11:31.70 process pointer page 19 of 35
07:11:32.19 process pointer page 20 of 35
07:11:32.67 process pointer page 21 of 35
07:11:33.15 process pointer page 22 of 35
07:11:33.62 process pointer page 23 of 35
07:11:34.11 process pointer page 24 of 35
07:11:34.59 process pointer page 25 of 35
07:11:35.06 process pointer page 26 of 35
07:11:35.54 process pointer page 27 of 35
07:11:36.06 process pointer page 28 of 35
07:11:36.51 process pointer page 29 of 35
07:11:36.93 process pointer page 30 of 35
07:11:37.38 process pointer page 31 of 35
07:11:37.83 process pointer page 32 of 35
07:11:38.24 process pointer page 33 of 35
07:11:38.52 process pointer page 34 of 35
07:11:38.60 Index 1 (XQS_2100_3300_DOC_ID)
07:11:40.38 Index 2 (XQS_2100_3300_SND_ID)
07:11:42.23 Index 3 (XQS_2100_3300_RCV_ID)
07:11:44.64 Relation 270 (XQS_2100_3300) is ok
07:11:44.64 Relation 271 (XQS_3300_3400)
07:11:44.64 process pointer page 0 of 7
07:11:45.10 process pointer page 1 of 7
07:11:45.59 process pointer page 2 of 7
07:11:46.06 process pointer page 3 of 7
07:11:46.54 process pointer page 4 of 7
07:11:47.01 process pointer page 5 of 7
07:11:47.48 process pointer page 6 of 7
07:11:47.63 Index 1 (XQS_3300_3400_DOC_ID)
07:11:48.07 Index 2 (XQS_3300_3400_SND_ID)
07:11:48.52 Relation 271 (XQS_3300_3400) is ok
07:11:48.57 Validation finished
Done for 84860 ms, from 7:10:23.77 to 7:11:48.63.
Differences between old and current firebird.log
7:11:50.60. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2018-05-16 07:11 471 oltp30_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed May 16 07:10:23 2018
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed May 16 07:11:48 2018
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2018-05-16 7:11:58.05 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html