Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-08-28 2:28:26.60.
Server version: WI-V2.5.7.27025 Firebird 2.5
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
Classic 2.5.7 |
D:\OLTP-EMUL\OLTP25-SMALL.FDB |
ON |
0 |
384 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp25_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB25.TMPINSTANCE\bin\ |
dbnm |
D:\OLTP-EMUL\oltp25-small.fdb |
host |
localhost |
port |
3255 |
usr |
SYSDBA |
pwd |
masterke |
tmpdir |
e:\temp\logs.oltp25 |
working_mode |
small_03 |
warm_time |
10 |
test_time |
180 |
idle_time |
0 |
use_mtee |
0 |
is_embed |
0 |
remove_isql_logs |
if_no_severe_errors |
no_auto_undo |
1 |
detailed_info |
0 |
mon_unit_perf |
0 |
trc_unit_perf |
1 |
init_buff |
32768 |
create_with_fw |
sync |
create_with_sweep |
0 |
wait_if_not_exists |
0 |
wait_after_create |
0 |
init_docs |
0 |
wait_for_copy |
0 |
create_with_debug_objects |
1 |
create_with_split_heavy_tabs |
1 |
create_with_separate_qdistr_idx |
0 |
create_with_compound_columns_order |
most_selective_first |
make_html |
1 |
run_db_statistics |
1 |
run_db_validation |
1 |
file_name_with_test_params |
regular |
file_name_this_host_info |
ak25 |
upload_report |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-08-28 02:27:50.2530 |
-1 |
<null> |
|
127.0.0.1 |
77633 |
4208 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
LOG_PK_VIOLATION |
0 |
COMMON |
QMISM_VERIFY_BITSET |
1 |
COMMON |
RECALC_IDX_MIN_INTERVAL |
15 |
COMMON |
ENABLE_RESERVES_WHEN_ADD_INVOICE |
1 |
COMMON |
ORDER_FOR_OUR_FIRM_PERCENT |
25 |
COMMON |
ENABLE_FILL_PHRASES |
0 |
COMMON |
RANDOM_SEEK_VIA_ROWS_LIMIT |
0 |
COMMON |
C_INVOICE_MIN_PURCHASE |
1000 |
COMMON |
C_INVOICE_MAX_PURCHASE |
2000 |
COMMON |
C_INVOICE_MIN_PROFIT_PRC |
35 |
COMMON |
C_INVOICE_MAX_PROFIT_PRC |
80 |
COMMON |
C_MIN_COST_TO_BE_SPLITTED |
1000 |
COMMON |
C_ROWS_TO_MULTIPLY |
10 |
COMMON |
C_PAYMENT_FROM_CLIENT_MIN_TOTAL |
1000 |
COMMON |
C_PAYMENT_FROM_CLIENT_MAX_TOTAL |
5000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MIN_TOTAL |
2000 |
COMMON |
C_PAYMENT_TO_SUPPLIER_MAX_TOTAL |
15000 |
COMMON |
BUILD_WITH_SPLIT_HEAVY_TABS |
1 |
COMMON |
BUILD_WITH_SEPAR_QDISTR_IDX |
0 |
COMMON |
BUILD_WITH_QD_COMPOUND_ORDR |
MOST_SELECTIVE_FIRST |
COMMON |
ENABLE_MON_QUERY |
0 |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
SMALL_03 |
C_WARES_MAX_ID |
400 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_ROWS |
10 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_ROWS |
50 |
SMALL_03 |
C_CUSTOMER_DOC_MAX_QTY |
15 |
SMALL_03 |
C_SUPPLIER_DOC_MAX_QTY |
50 |
SMALL_03 |
C_NUMBER_OF_AGENTS |
50 |
TAB_NAME |
IDX_NAME |
IDX_KEY |
XQD_1000_1200 |
XQD_1000_1200_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1000_3300 |
XQD_1000_3300_DOC |
DOC_ID |
XQD_1000_3300 |
XQD_1000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_1200_2000 |
XQD_1200_2000_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2000_3300 |
XQD_2000_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_2100_3300 |
XQD_2100_3300_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
XQD_3300_3400 |
XQD_3300_3400_WARE_SOP_ROP_SND |
WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
JOB_BEG |
JOB_END |
*** OVERALL *** for 181 minutes: |
103.13 |
231885 |
18667 |
2016-08-27 23:27 |
2016-08-28 02:28 |
customer order: creation |
10.80 |
1571 |
1933 |
2016-08-27 23:27 |
2016-08-28 02:28 |
customer order: refuse |
0.79 |
78 |
139 |
2016-08-27 23:27 |
2016-08-28 02:28 |
order to supplier: creation |
2.63 |
15823 |
462 |
2016-08-27 23:27 |
2016-08-28 02:28 |
order to supplier: removal |
0.03 |
25743 |
5 |
2016-08-27 23:27 |
2016-08-28 02:28 |
invoice (draft): creation |
2.84 |
2974 |
508 |
2016-08-27 23:27 |
2016-08-28 02:28 |
invoice (draft): removal |
0.17 |
166 |
29 |
2016-08-27 23:27 |
2016-08-28 02:28 |
invoice accept: apply |
0.43 |
4304828 |
78 |
2016-08-27 23:27 |
2016-08-28 02:28 |
invoice accept: cancel |
0.12 |
3042 |
20 |
2016-08-27 23:27 |
2016-08-28 02:28 |
customer reserve: creation |
66.11 |
43723 |
11966 |
2016-08-27 23:27 |
2016-08-28 02:28 |
customer reserve: removal |
3.69 |
348 |
649 |
2016-08-27 23:27 |
2016-08-28 02:28 |
realization accept: apply |
5.15 |
109 |
921 |
2016-08-27 23:27 |
2016-08-28 02:28 |
realization accept: cancel |
1.97 |
65 |
346 |
2016-08-27 23:27 |
2016-08-28 02:28 |
payment from customer: creation |
3.75 |
190 |
667 |
2016-08-27 23:27 |
2016-08-28 02:28 |
payment from customer: removal |
0.39 |
32 |
69 |
2016-08-27 23:27 |
2016-08-28 02:28 |
payment to supplier: creation |
3.19 |
457 |
562 |
2016-08-27 23:27 |
2016-08-28 02:28 |
payment to supplier: removal |
0.17 |
46 |
29 |
2016-08-27 23:27 |
2016-08-28 02:28 |
service: total inventory turnovers |
0.84 |
4915 |
148 |
2016-08-27 23:27 |
2016-08-28 02:28 |
service: total monetary turnovers |
0.72 |
14 |
127 |
2016-08-27 23:27 |
2016-08-28 02:28 |
service: refresh index statistics |
0.06 |
1683 |
9 |
2016-08-27 23:27 |
2016-08-28 02:28 |
Done for 4010 ms, from 2:28:42.06 to 2:28:46.07.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
338 |
8532 |
6080 |
2452 |
28.74 |
23:27:50 |
23:45:48 |
interval # 2, overall |
2 |
109 |
2629 |
1957 |
672 |
25.56 |
23:45:49 |
00:03:47 |
interval # 3, overall |
3 |
80 |
1979 |
1446 |
533 |
26.93 |
00:03:48 |
00:21:46 |
interval # 4, overall |
4 |
75 |
1360 |
1353 |
7 |
0.51 |
00:21:47 |
00:39:45 |
interval # 5, overall |
5 |
63 |
1250 |
1133 |
117 |
9.36 |
00:39:46 |
00:57:44 |
interval # 6, overall |
6 |
92 |
1691 |
1647 |
44 |
2.60 |
00:57:45 |
01:15:43 |
interval # 7, overall |
7 |
90 |
1635 |
1619 |
16 |
0.98 |
01:15:44 |
01:33:42 |
interval # 8, overall |
8 |
93 |
1798 |
1666 |
132 |
7.34 |
01:33:43 |
01:51:41 |
interval # 9, overall |
9 |
55 |
1208 |
996 |
212 |
17.55 |
01:51:42 |
02:09:40 |
interval # 10, overall |
10 |
43 |
805 |
770 |
35 |
4.35 |
02:09:41 |
02:27:39 |
Done for 5680 ms, from 2:28:48.78 to 2:28:54.46.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
1090.18 |
0.0742 |
1.9327 |
1796 |
49 |
WARM_TIME |
2 |
1310.87 |
0.8040 |
1.2129 |
1058 |
91 |
WARM_TIME |
3 |
1159.38 |
0.9145 |
1.0942 |
582 |
74 |
WARM_TIME |
4 |
1017.06 |
0.9357 |
1.0672 |
364 |
60 |
WARM_TIME |
5 |
950.95 |
0.9134 |
1.0553 |
256 |
49 |
WARM_TIME |
6 |
850.42 |
0.9836 |
1.0157 |
175 |
39 |
WARM_TIME |
7 |
787.83 |
0.9400 |
1.0466 |
285 |
47 |
WARM_TIME |
8 |
747.95 |
0.9647 |
1.0351 |
250 |
45 |
WARM_TIME |
9 |
709.47 |
0.9702 |
1.0292 |
282 |
44 |
WARM_TIME |
10 |
686.65 |
0.9572 |
1.0520 |
255 |
40 |
TEST_TIME |
11 |
672.14 |
0.9771 |
1.0283 |
274 |
42 |
TEST_TIME |
12 |
643.92 |
0.9840 |
1.0168 |
271 |
37 |
TEST_TIME |
13 |
617.63 |
0.9786 |
1.0207 |
333 |
37 |
TEST_TIME |
14 |
599.17 |
0.9771 |
1.0259 |
319 |
35 |
TEST_TIME |
15 |
588.96 |
0.9742 |
1.0255 |
430 |
37 |
TEST_TIME |
16 |
583.06 |
0.9712 |
1.0282 |
582 |
29 |
TEST_TIME |
17 |
582.76 |
0.9684 |
1.0378 |
465 |
17 |
TEST_TIME |
18 |
573.89 |
0.9954 |
1.0044 |
103 |
3 |
TEST_TIME |
19 |
554.37 |
0.9943 |
1.0053 |
77 |
4 |
TEST_TIME |
20 |
533.66 |
0.9972 |
1.0028 |
66 |
2 |
TEST_TIME |
21 |
517.60 |
0.9972 |
1.0028 |
66 |
2 |
TEST_TIME |
22 |
499.51 |
0.9920 |
1.0045 |
100 |
2 |
TEST_TIME |
23 |
481.36 |
0.9971 |
1.0029 |
72 |
1 |
TEST_TIME |
24 |
464.17 |
0.9968 |
1.0018 |
36 |
2 |
TEST_TIME |
25 |
448.67 |
0.9951 |
1.0049 |
114 |
2 |
TEST_TIME |
27 |
418.67 |
0.9992 |
1.0007 |
19 |
1 |
TEST_TIME |
28 |
409.77 |
0.9860 |
1.0039 |
71 |
3 |
TEST_TIME |
29 |
401.71 |
0.9887 |
1.0056 |
39 |
4 |
TEST_TIME |
30 |
392.74 |
0.9969 |
1.0018 |
41 |
1 |
TEST_TIME |
31 |
391.94 |
0.9784 |
1.0064 |
9 |
2 |
TEST_TIME |
33 |
373.43 |
0.9961 |
1.0086 |
37 |
2 |
TEST_TIME |
34 |
365.68 |
0.9998 |
1.0002 |
6 |
1 |
TEST_TIME |
40 |
312.43 |
0.9988 |
1.0011 |
30 |
1 |
TEST_TIME |
42 |
300.60 |
0.9926 |
1.0039 |
40 |
2 |
TEST_TIME |
43 |
294.92 |
0.9997 |
1.0002 |
7 |
1 |
TEST_TIME |
44 |
288.47 |
0.9996 |
1.0003 |
10 |
1 |
TEST_TIME |
45 |
283.41 |
0.9985 |
1.0013 |
41 |
1 |
TEST_TIME |
46 |
277.66 |
0.9999 |
1.0000 |
2 |
1 |
TEST_TIME |
50 |
256.61 |
0.9994 |
1.0005 |
16 |
1 |
TEST_TIME |
51 |
251.89 |
0.9994 |
1.0006 |
17 |
1 |
TEST_TIME |
52 |
247.77 |
0.9977 |
1.0034 |
45 |
1 |
TEST_TIME |
55 |
238.09 |
0.9994 |
1.0005 |
16 |
1 |
TEST_TIME |
59 |
222.73 |
0.9992 |
1.0045 |
11 |
1 |
TEST_TIME |
60 |
220.03 |
1.0000 |
1.0000 |
1 |
1 |
TEST_TIME |
61 |
220.56 |
0.9911 |
1.0126 |
60 |
3 |
TEST_TIME |
62 |
219.80 |
0.9998 |
1.0001 |
5 |
1 |
TEST_TIME |
66 |
207.91 |
0.9996 |
1.0003 |
10 |
1 |
TEST_TIME |
67 |
205.68 |
0.9961 |
1.0032 |
27 |
2 |
TEST_TIME |
68 |
204.76 |
0.9996 |
1.0003 |
11 |
1 |
TEST_TIME |
70 |
200.83 |
0.9999 |
1.0000 |
2 |
1 |
TEST_TIME |
71 |
199.07 |
0.9989 |
1.0011 |
34 |
1 |
TEST_TIME |
72 |
196.61 |
0.9996 |
1.0003 |
10 |
1 |
TEST_TIME |
77 |
185.63 |
0.9988 |
1.0012 |
36 |
1 |
TEST_TIME |
78 |
184.64 |
0.9993 |
1.0007 |
23 |
2 |
TEST_TIME |
80 |
181.63 |
0.9996 |
1.0003 |
13 |
1 |
TEST_TIME |
81 |
179.72 |
0.9985 |
1.0015 |
46 |
1 |
TEST_TIME |
82 |
178.91 |
0.9999 |
1.0000 |
3 |
1 |
TEST_TIME |
84 |
175.01 |
0.9998 |
1.0001 |
7 |
1 |
TEST_TIME |
85 |
173.03 |
0.9998 |
1.0002 |
7 |
1 |
TEST_TIME |
86 |
172.35 |
0.9997 |
1.0003 |
11 |
1 |
TEST_TIME |
87 |
170.66 |
0.9995 |
1.0005 |
17 |
2 |
TEST_TIME |
88 |
168.83 |
0.9999 |
1.0000 |
2 |
1 |
TEST_TIME |
97 |
155.19 |
0.9995 |
1.0004 |
15 |
1 |
TEST_TIME |
98 |
153.91 |
0.9985 |
1.0015 |
47 |
1 |
TEST_TIME |
99 |
152.71 |
0.9992 |
1.0007 |
26 |
1 |
TEST_TIME |
100 |
152.57 |
0.9987 |
1.0011 |
42 |
1 |
TEST_TIME |
101 |
151.50 |
0.9982 |
1.0013 |
7 |
1 |
TEST_TIME |
102 |
150.67 |
0.9970 |
1.0034 |
41 |
2 |
TEST_TIME |
107 |
145.42 |
0.9984 |
1.0015 |
51 |
1 |
TEST_TIME |
109 |
143.32 |
0.9997 |
1.0002 |
9 |
1 |
TEST_TIME |
110 |
142.10 |
0.9997 |
1.0002 |
9 |
1 |
TEST_TIME |
111 |
140.87 |
1.0000 |
1.0000 |
1 |
1 |
TEST_TIME |
115 |
137.75 |
0.9996 |
1.0004 |
16 |
2 |
TEST_TIME |
117 |
137.27 |
0.9997 |
1.0001 |
8 |
1 |
TEST_TIME |
118 |
136.27 |
0.9990 |
1.0071 |
11 |
2 |
TEST_TIME |
119 |
137.68 |
0.9925 |
1.0032 |
35 |
2 |
TEST_TIME |
120 |
137.16 |
0.9987 |
1.0043 |
19 |
2 |
TEST_TIME |
121 |
136.73 |
0.9991 |
1.0008 |
30 |
1 |
TEST_TIME |
122 |
136.86 |
0.9997 |
1.0002 |
11 |
1 |
TEST_TIME |
123 |
135.98 |
0.9986 |
1.0013 |
48 |
1 |
TEST_TIME |
124 |
136.51 |
0.9991 |
1.0010 |
35 |
1 |
TEST_TIME |
125 |
136.60 |
0.9999 |
1.0000 |
4 |
1 |
TEST_TIME |
130 |
133.85 |
0.9909 |
1.0033 |
58 |
2 |
TEST_TIME |
131 |
133.40 |
0.9991 |
1.0008 |
35 |
1 |
TEST_TIME |
133 |
133.92 |
0.9902 |
1.0109 |
31 |
3 |
TEST_TIME |
134 |
134.42 |
0.9997 |
1.0002 |
11 |
1 |
TEST_TIME |
135 |
134.57 |
0.9995 |
1.0005 |
18 |
1 |
TEST_TIME |
136 |
133.67 |
0.9999 |
1.0001 |
5 |
1 |
TEST_TIME |
138 |
133.07 |
0.9993 |
1.0006 |
25 |
1 |
TEST_TIME |
139 |
132.41 |
0.9984 |
1.0015 |
58 |
1 |
TEST_TIME |
140 |
132.92 |
1.0000 |
1.0001 |
4 |
1 |
TEST_TIME |
141 |
132.08 |
0.9993 |
1.0006 |
28 |
2 |
TEST_TIME |
142 |
131.43 |
0.9984 |
1.0100 |
42 |
3 |
TEST_TIME |
143 |
133.15 |
0.9995 |
1.0006 |
24 |
3 |
TEST_TIME |
144 |
132.36 |
0.9996 |
1.0005 |
20 |
1 |
TEST_TIME |
145 |
132.82 |
0.9902 |
1.0075 |
162 |
2 |
TEST_TIME |
146 |
132.93 |
0.9998 |
1.0001 |
7 |
1 |
TEST_TIME |
147 |
134.25 |
0.9929 |
1.0038 |
27 |
2 |
TEST_TIME |
148 |
133.88 |
0.9999 |
1.0002 |
7 |
1 |
TEST_TIME |
149 |
134.03 |
0.9997 |
1.0003 |
13 |
1 |
TEST_TIME |
150 |
136.21 |
0.9875 |
1.0138 |
111 |
3 |
TEST_TIME |
151 |
138.34 |
0.9916 |
1.0022 |
69 |
3 |
TEST_TIME |
152 |
138.11 |
0.9973 |
1.0064 |
7 |
2 |
TEST_TIME |
153 |
139.95 |
0.9867 |
1.0105 |
88 |
4 |
TEST_TIME |
154 |
141.69 |
0.9998 |
1.0002 |
9 |
1 |
TEST_TIME |
159 |
139.65 |
0.9922 |
1.0116 |
111 |
4 |
TEST_TIME |
160 |
140.41 |
0.9999 |
1.0001 |
5 |
1 |
TEST_TIME |
161 |
141.02 |
0.9896 |
1.0028 |
91 |
2 |
TEST_TIME |
162 |
141.99 |
0.9997 |
1.0004 |
18 |
1 |
TEST_TIME |
164 |
142.05 |
0.9919 |
1.0017 |
6 |
2 |
TEST_TIME |
165 |
142.61 |
0.9917 |
1.0162 |
55 |
4 |
TEST_TIME |
168 |
143.83 |
0.9993 |
1.0007 |
34 |
1 |
TEST_TIME |
169 |
144.51 |
0.9994 |
1.0007 |
34 |
2 |
TEST_TIME |
170 |
143.99 |
0.9984 |
1.0015 |
69 |
2 |
TEST_TIME |
171 |
143.39 |
0.9998 |
1.0002 |
11 |
1 |
TEST_TIME |
175 |
140.51 |
0.9996 |
1.0004 |
19 |
1 |
TEST_TIME |
176 |
139.88 |
0.9992 |
1.0008 |
43 |
1 |
TEST_TIME |
177 |
140.72 |
0.9996 |
1.0004 |
25 |
1 |
TEST_TIME |
178 |
141.13 |
0.9920 |
1.0029 |
33 |
2 |
TEST_TIME |
179 |
141.39 |
0.9992 |
1.0008 |
48 |
1 |
TEST_TIME |
181 |
140.05 |
0.9994 |
1.0006 |
35 |
1 |
TEST_TIME |
182 |
140.76 |
1.0000 |
1.0001 |
4 |
1 |
TEST_TIME |
183 |
140.02 |
0.9999 |
1.0001 |
7 |
1 |
TEST_TIME |
184 |
140.91 |
0.9981 |
1.0105 |
84 |
2 |
TEST_TIME |
185 |
143.22 |
0.9986 |
1.0096 |
9 |
2 |
TEST_TIME |
186 |
145.75 |
0.9867 |
1.0111 |
133 |
4 |
TEST_TIME |
187 |
146.83 |
0.9983 |
1.0017 |
102 |
4 |
TEST_TIME |
188 |
146.32 |
0.9999 |
1.0001 |
6 |
1 |
TEST_TIME |
189 |
145.81 |
0.9999 |
1.0001 |
8 |
1 |
TEST_TIME |
190 |
145.06 |
1.0000 |
1.0000 |
22 |
22 |
TEST_TIME |
191 |
144.78 |
0.9966 |
1.0029 |
78 |
78 |
Done for 8080 ms, from 2:28:54.93 to 2:29:03.01.
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 |
1497 |
<null> |
1081 |
<null> |
5764 |
<null> |
3410 |
<null> |
1282 |
<null> |
12728 |
<null> |
14863 |
6717 |
50150 |
<null> |
<null> |
<null> |
<null> |
23:27:50 |
23:45:48 |
fetches per second |
10 |
72297 |
123005 |
83778 |
<null> |
<null> |
<null> |
738 |
3185 |
337 |
<null> |
99491 |
73092 |
116032 |
118818 |
399784 |
111600 |
78167 |
2330627 |
<null> |
02:09:41 |
02:27:39 |
marks per second |
1 |
286 |
<null> |
115 |
<null> |
463 |
<null> |
496 |
<null> |
197 |
<null> |
2028 |
<null> |
610 |
736 |
1124 |
<null> |
<null> |
<null> |
<null> |
23:27:50 |
23:45:48 |
marks per second |
10 |
12344 |
11738 |
6071 |
<null> |
<null> |
<null> |
83 |
289 |
34 |
<null> |
18349 |
7651 |
6426 |
15090 |
9700 |
10300 |
376 |
11463 |
<null> |
02:09:41 |
02:27:39 |
reads/fetches*100 |
1 |
19 |
<null> |
20 |
<null> |
9 |
<null> |
12 |
<null> |
19 |
<null> |
8 |
<null> |
7 |
5 |
3 |
<null> |
<null> |
<null> |
<null> |
23:27:50 |
23:45:48 |
reads/fetches*100 |
10 |
4 |
3 |
8 |
<null> |
<null> |
<null> |
16 |
3 |
21 |
<null> |
8 |
5 |
5 |
1 |
3 |
4 |
26 |
0 |
<null> |
02:09:41 |
02:27:39 |
writes/marks*100 |
1 |
6 |
<null> |
1 |
<null> |
8 |
<null> |
1 |
<null> |
2 |
<null> |
6 |
<null> |
3 |
0 |
1 |
<null> |
<null> |
<null> |
<null> |
23:27:50 |
23:45:48 |
writes/marks*100 |
10 |
17 |
12 |
7 |
<null> |
<null> |
<null> |
0 |
5 |
2 |
<null> |
8 |
11 |
5 |
0 |
3 |
0 |
49 |
0 |
<null> |
02:09:41 |
02:27:39 |
Done for 5640 ms, from 2:29:03.40 to 2:29:09.04.
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 |
20840 |
16984 |
3856 |
18.50 |
0 |
3822 |
39 |
3856 |
2016-08-27 23:27 |
2016-08-28 02:28 |
doc_list_biud |
20880 |
16984 |
3896 |
18.65 |
0 |
58703 |
26 |
3896 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_add_invoice_to_stock |
355 |
78 |
277 |
78.02 |
56924 |
10449506 |
4304828 |
277 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_adding_invoice |
61 |
20 |
41 |
67.21 |
110 |
19859 |
3042 |
41 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_client_order |
153 |
139 |
14 |
9.15 |
0 |
1326 |
78 |
14 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_customer_reserve |
3186 |
649 |
2537 |
79.62 |
0 |
15038 |
348 |
2537 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_pay_from_customer |
69 |
69 |
0 |
0.00 |
0 |
234 |
32 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_pay_to_supplier |
31 |
29 |
2 |
6.45 |
0 |
266 |
46 |
2 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_supplier_invoice |
55 |
29 |
26 |
47.27 |
15 |
561 |
166 |
26 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_supplier_order |
22 |
5 |
17 |
77.27 |
31 |
59857 |
25743 |
17 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_cancel_write_off |
1648 |
346 |
1302 |
79.00 |
0 |
1092 |
65 |
1302 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_client_order |
1933 |
1933 |
0 |
0.00 |
0 |
42729 |
1571 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_customer_reserve |
11966 |
11966 |
0 |
0.00 |
484 |
155018 |
43723 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_fill_shopping_cart |
2903 |
2903 |
0 |
0.00 |
0 |
34148 |
990 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_fill_shopping_cart_clo_res |
11966 |
11966 |
0 |
0.00 |
0 |
280 |
5 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_get_clo_for_invoice |
78 |
78 |
0 |
0.00 |
0 |
624 |
106 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_kill_cost_storno |
1772 |
464 |
1308 |
73.81 |
0 |
998 |
18 |
1308 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_kill_qstorno_ret_qs2qd |
8047 |
1678 |
6369 |
79.14 |
0 |
58703 |
174 |
6369 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_kill_qty_storno |
6067 |
2187 |
3880 |
63.95 |
0 |
58703 |
198 |
3880 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_lock_selected_doc |
1773 |
1409 |
364 |
20.53 |
0 |
31 |
1 |
364 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_make_cost_storno |
2228 |
2228 |
0 |
0.00 |
0 |
3650 |
148 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_multiply_rows_for_pdistr |
2228 |
2228 |
0 |
0.00 |
0 |
718 |
27 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_multiply_rows_for_qdistr |
1933 |
1933 |
0 |
0.00 |
0 |
41793 |
1462 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_pay_from_customer |
667 |
667 |
0 |
0.00 |
31 |
1794 |
190 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_pay_to_supplier |
562 |
562 |
0 |
0.00 |
16 |
3978 |
457 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_payment_common |
1229 |
1229 |
0 |
0.00 |
0 |
468 |
30 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_qd_handle_on_cancel_clo |
153 |
139 |
14 |
9.15 |
0 |
1248 |
52 |
14 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_qd_handle_on_invoice_upd_sts |
133 |
98 |
35 |
26.31 |
0 |
12168 |
1080 |
35 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_qd_handle_on_reserve_upd_sts |
921 |
921 |
0 |
0.00 |
0 |
343 |
30 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_reserve_write_off |
925 |
921 |
4 |
0.43 |
0 |
874 |
109 |
4 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_supplier_invoice |
508 |
508 |
0 |
0.00 |
16 |
34164 |
2974 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
sp_supplier_order |
462 |
462 |
0 |
0.00 |
31 |
147436 |
15823 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
srv_find_qd_qs_mism |
12798 |
8952 |
3846 |
30.05 |
0 |
1045 |
27 |
3846 |
2016-08-27 23:27 |
2016-08-28 02:28 |
srv_make_invnt_saldo |
148 |
148 |
0 |
0.00 |
1794 |
10577 |
4915 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
srv_make_money_saldo |
127 |
127 |
0 |
0.00 |
0 |
47 |
14 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
srv_recalc_idx_stat |
9 |
9 |
0 |
0.00 |
1279 |
2059 |
1683 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_add_invoice_to_stock |
277 |
277 |
0 |
0.00 |
0 |
218 |
17 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_cancel_adding_invoice |
138 |
138 |
0 |
0.00 |
0 |
515 |
75 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_cancel_client_order |
14 |
14 |
0 |
0.00 |
0 |
62 |
25 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_cancel_customer_reserve |
1 |
1 |
0 |
0.00 |
47 |
47 |
47 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_cancel_pay_to_supplier |
2 |
2 |
0 |
0.00 |
15 |
16 |
15 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_cancel_supplier_invoice |
20 |
20 |
0 |
0.00 |
0 |
62 |
13 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_cancel_supplier_order |
366 |
366 |
0 |
0.00 |
0 |
468 |
72 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_cancel_write_off |
1 |
1 |
0 |
0.00 |
0 |
0 |
0 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-abend:sp_reserve_write_off |
4 |
4 |
0 |
0.00 |
0 |
0 |
0 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_add_invoice_to_stock |
118 |
118 |
0 |
0.00 |
16 |
1030 |
307 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_adding_invoice |
10 |
10 |
0 |
0.00 |
31 |
765 |
217 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_client_order |
139 |
139 |
0 |
0.00 |
0 |
156 |
21 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_customer_reserve |
54 |
54 |
0 |
0.00 |
0 |
265 |
37 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_pay_from_customer |
69 |
69 |
0 |
0.00 |
0 |
234 |
23 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_pay_to_supplier |
29 |
29 |
0 |
0.00 |
0 |
219 |
23 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_supplier_invoice |
14 |
14 |
0 |
0.00 |
0 |
93 |
19 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_supplier_order |
5 |
5 |
0 |
0.00 |
0 |
2621 |
883 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_cancel_write_off |
90 |
90 |
0 |
0.00 |
0 |
172 |
20 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_client_order |
1946 |
1946 |
0 |
0.00 |
0 |
484 |
33 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_customer_reserve |
84 |
84 |
0 |
0.00 |
0 |
125 |
23 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_pay_from_customer |
667 |
667 |
0 |
0.00 |
0 |
219 |
22 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_pay_to_supplier |
562 |
562 |
0 |
0.00 |
0 |
219 |
20 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_reserve_write_off |
921 |
921 |
0 |
0.00 |
0 |
327 |
29 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_supplier_invoice |
508 |
508 |
0 |
0.00 |
0 |
312 |
31 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:sp_supplier_order |
502 |
502 |
0 |
0.00 |
0 |
374 |
38 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:srv_make_invnt_saldo |
148 |
148 |
0 |
0.00 |
0 |
47 |
3 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:srv_make_money_saldo |
127 |
127 |
0 |
0.00 |
0 |
47 |
6 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
t$perf-norm:srv_recalc_idx_stat |
9 |
9 |
0 |
0.00 |
0 |
31 |
15 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_add_invoice_to_stock |
710 |
156 |
554 |
78.02 |
0 |
31 |
4 |
554 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_all_customers |
2888 |
2888 |
0 |
0.00 |
0 |
16 |
0 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_all_suppliers |
1940 |
1940 |
0 |
0.00 |
0 |
16 |
1 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_all_wares |
3866 |
3866 |
0 |
0.00 |
0 |
16 |
1 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_adding_invoice |
76 |
20 |
56 |
73.68 |
0 |
31 |
7 |
56 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_client_order |
306 |
278 |
28 |
9.15 |
0 |
16 |
1 |
28 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_customer_prepayment |
138 |
138 |
0 |
0.00 |
0 |
16 |
1 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_customer_reserve |
110 |
108 |
2 |
1.81 |
0 |
16 |
2 |
2 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_payment_to_supplier |
62 |
58 |
4 |
6.45 |
0 |
32 |
2 |
4 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_supplier_invoice |
68 |
28 |
40 |
58.82 |
0 |
16 |
3 |
40 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_supplier_order |
44 |
10 |
34 |
77.27 |
0 |
16 |
4 |
34 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_cancel_write_off |
182 |
180 |
2 |
1.09 |
0 |
16 |
2 |
2 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_max_id_clo_ord |
463 |
463 |
0 |
0.00 |
0 |
2496 |
165 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_max_id_clo_res |
84 |
84 |
0 |
0.00 |
0 |
31 |
4 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_max_id_ord_sup |
508 |
508 |
0 |
0.00 |
0 |
266 |
12 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_max_non_paid_invoice |
562 |
562 |
0 |
0.00 |
0 |
202 |
8 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_max_non_paid_realizn |
667 |
667 |
0 |
0.00 |
0 |
78 |
7 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_min_id_clo_ord |
462 |
462 |
0 |
0.00 |
0 |
1217 |
157 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_min_id_clo_res |
84 |
84 |
0 |
0.00 |
0 |
16 |
2 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_min_id_ord_sup |
508 |
508 |
0 |
0.00 |
0 |
1217 |
56 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_min_non_paid_invoice |
562 |
562 |
0 |
0.00 |
0 |
203 |
13 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_min_non_paid_realizn |
667 |
667 |
0 |
0.00 |
0 |
110 |
17 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_our_firm |
978 |
978 |
0 |
0.00 |
0 |
16 |
1 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
v_reserve_write_off |
1850 |
1842 |
8 |
0.43 |
0 |
109 |
2 |
8 |
2016-08-27 23:27 |
2016-08-28 02:28 |
x_lock_depdocs_on_canc_invoice |
132 |
35 |
97 |
73.48 |
0 |
31 |
9 |
97 |
2016-08-27 23:27 |
2016-08-28 02:28 |
x_lock_depdocs_on_canc_sup_ord |
22 |
5 |
17 |
77.27 |
0 |
16 |
6 |
17 |
2016-08-27 23:27 |
2016-08-28 02:28 |
x_make_qstorno_1000_1200 |
468 |
468 |
0 |
0.00 |
0 |
147265 |
12573 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
x_make_qstorno_1200_2000 |
508 |
508 |
0 |
0.00 |
0 |
12199 |
1089 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
x_make_qstorno_2100_3300 |
11966 |
11966 |
0 |
0.00 |
484 |
154987 |
43710 |
0 |
2016-08-27 23:27 |
2016-08-28 02:28 |
Done for 14300 ms, from 2:29:14.18 to 2:29:28.48.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
lock_conflict |
2 |
sp_kill_cost_storno |
335544345 |
2016-08-27 23:32 |
2016-08-28 01:48 |
lock_conflict |
303 |
sp_lock_selected_doc |
335544345 |
2016-08-27 23:28 |
2016-08-28 02:26 |
lock_conflict |
14 |
sp_qd_handle_on_cancel_clo |
335544345 |
2016-08-27 23:28 |
2016-08-28 01:56 |
lock_conflict |
28 |
sp_qd_handle_on_invoice_upd_sts |
335544345 |
2016-08-27 23:27 |
2016-08-28 02:06 |
lock_conflict |
9 |
x_lock_depdocs_on_canc_invoice |
335544345 |
2016-08-27 23:29 |
2016-08-28 02:23 |
lock_conflict |
9 |
x_lock_depdocs_on_canc_sup_ord |
335544345 |
2016-08-27 23:28 |
2016-08-28 02:07 |
Done for 2420 ms, from 2:29:29.07 to 2:29:31.49.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 80157
MON$OLDEST_ACTIVE 80158
MON$OLDEST_SNAPSHOT 80158
MON$NEXT_TRANSACTION 80158
MON$PAGE_BUFFERS 384
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 2015-12-11 10:02:47.3010
MON$PAGES 136362
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.7.27025 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.7.27025 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.7.27025 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.7.27025 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2
Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 84612
Page size 8192
ODS version 11.2
Oldest transaction 80159
Oldest active 80160
Oldest snapshot 80160
Next transaction 80161
Bumped transaction 1
Sequence number 0
Next attachment ID 4419
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file
Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 44.97, total records: 406418
Average version length: 46.04, total versions: 9632, max versions: 1
Data pages: 4347, data page slots: 4347, average fill: 73%
Fill distribution:
0 - 19% = 2
20 - 39% = 21
40 - 59% = 87
60 - 79% = 4201
80 - 99% = 36
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 1242, nodes: 406418
Average data length: 11.60, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 129
20 - 39% = 54
40 - 59% = 339
60 - 79% = 70
80 - 99% = 650
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1202, nodes: 406418
Average data length: 6.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 33
40 - 59% = 1169
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 2, leaf buckets: 355, nodes: 406418
Average data length: 0.82, total dup: 354386, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 88
60 - 79% = 7
80 - 99% = 229
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 58.83, total records: 64520
Average version length: 52.31, total versions: 4725, max versions: 5
Data pages: 827, data page slots: 827, average fill: 78%
Fill distribution:
0 - 19% = 3
20 - 39% = 23
40 - 59% = 60
60 - 79% = 231
80 - 99% = 510
Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 189, nodes: 64520
Average data length: 6.30, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 20
40 - 59% = 169
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 56, nodes: 64520
Average data length: 0.01, total dup: 64470, max dup: 15789
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 43
60 - 79% = 6
80 - 99% = 7
Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 118, nodes: 64520
Average data length: 6.30, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 16
40 - 59% = 28
60 - 79% = 0
80 - 99% = 72
DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7
Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 61.96, total records: 400
Average version length: 13.70, total versions: 47972, max versions: 150
Data pages: 193, data page slots: 193, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 193
Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 0.32, total records: 95475
Average version length: 68.36, total versions: 95034, max versions: 1
Data pages: 1442, data page slots: 1448, average fill: 83%
Fill distribution:
0 - 19% = 16
20 - 39% = 38
40 - 59% = 99
60 - 79% = 172
80 - 99% = 1117
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 250, nodes: 95475
Average data length: 8.66, total dup: 8543, max dup: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 94
60 - 79% = 113
80 - 99% = 43
MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 14.98, total records: 49
Average version length: 9.00, total versions: 2435, max versions: 184
Data pages: 10, data page slots: 10, average fill: 80%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 8
Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 0.16, total records: 4509
Average version length: 44.16, total versions: 4493, max versions: 1
Data pages: 49, data page slots: 49, average fill: 88%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 5
80 - 99% = 43
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 4, nodes: 4509
Average data length: 0.21, total dup: 4418, max dup: 958
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 2
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 26.12, total records: 110545
Average version length: 31.69, total versions: 67384, max versions: 9
Data pages: 1161, data page slots: 1161, average fill: 85%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 327
80 - 99% = 831
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 86, nodes: 110545
Average data length: 0.01, total dup: 110496, max dup: 22472
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 43
60 - 79% = 21
80 - 99% = 20
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 111, nodes: 110545
Average data length: 0.91, total dup: 99261, max dup: 30
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 64
60 - 79% = 22
80 - 99% = 22
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 115, nodes: 110545
Average data length: 0.91, total dup: 99261, max dup: 30
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 63
60 - 79% = 31
80 - 99% = 18
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 102, nodes: 110545
Average data length: 0.68, total dup: 99261, max dup: 30
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 42
60 - 79% = 37
80 - 99% = 19
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.34, total records: 11884
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 107, data page slots: 107, average fill: 60%
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 0
60 - 79% = 98
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 8, nodes: 11884
Average data length: 0.01, total dup: 11752, max dup: 1795
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 3
80 - 99% = 3
PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 142.94, total records: 956803
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 21674, data page slots: 21674, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 21673
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 1246, nodes: 956803
Average data length: 0.62, total dup: 495171, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1074
60 - 79% = 109
80 - 99% = 63
Index PERF_LOG_GDSCODE (3)
Depth: 2, leaf buckets: 946, nodes: 956803
Average data length: 0.00, total dup: 956798, max dup: 909133
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 944
60 - 79% = 0
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 1242, nodes: 956803
Average data length: 0.43, total dup: 893755, max dup: 4268
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1139
60 - 79% = 61
80 - 99% = 42
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 1063, nodes: 956803
Average data length: 0.29, total dup: 930846, max dup: 107252
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 777
60 - 79% = 134
80 - 99% = 151
PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 51.91, total records: 79755
Average version length: 54.46, total versions: 4031, max versions: 1
Data pages: 929, data page slots: 929, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 5
60 - 79% = 894
80 - 99% = 28
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 97, nodes: 79755
Average data length: 1.07, total dup: 66905, max dup: 199
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 90
60 - 79% = 2
80 - 99% = 4
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 74, nodes: 79755
Average data length: 0.62, total dup: 72617, max dup: 69
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 40
60 - 79% = 28
80 - 99% = 6
RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 518, max versions: 288
Data pages: 2, data page slots: 2, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
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: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.54, total records: 134
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 63%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2
Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0
WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 0.25, total records: 146062
Average version length: 69.40, total versions: 145551, max versions: 1
Data pages: 1968, data page slots: 1968, average fill: 94%
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 1
60 - 79% = 5
80 - 99% = 1952
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 164, nodes: 146062
Average data length: 1.31, total dup: 127817, max dup: 29
Fill distribution:
0 - 19% = 3
20 - 39% = 5
40 - 59% = 54
60 - 79% = 65
80 - 99% = 37
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 44.86, total records: 165875
Average version length: 69.16, total versions: 58614, max versions: 1
Data pages: 2340, data page slots: 2486, average fill: 81%
Fill distribution:
0 - 19% = 51
20 - 39% = 61
40 - 59% = 55
60 - 79% = 782
80 - 99% = 1391
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 163, nodes: 165875
Average data length: 0.15, total dup: 162275, max dup: 217
Fill distribution:
0 - 19% = 2
20 - 39% = 20
40 - 59% = 94
60 - 79% = 11
80 - 99% = 36
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 203, nodes: 165875
Average data length: 1.30, total dup: 145312, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 95
60 - 79% = 85
80 - 99% = 16
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 0.20, total records: 165983
Average version length: 69.36, total versions: 165503, max versions: 1
Data pages: 2226, data page slots: 2226, average fill: 94%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2224
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 172, nodes: 165983
Average data length: 1.02, total dup: 150193, max dup: 105
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 55
60 - 79% = 68
80 - 99% = 46
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 14.56, total records: 870482
Average version length: 68.15, total versions: 687342, max versions: 1
Data pages: 11720, data page slots: 11720, average fill: 90%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2251
80 - 99% = 9468
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1129, nodes: 870482
Average data length: 1.16, total dup: 766889, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 874
60 - 79% = 143
80 - 99% = 111
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 6.38, total records: 191942
Average version length: 68.51, total versions: 174183, max versions: 1
Data pages: 3026, data page slots: 3437, average fill: 79%
Fill distribution:
0 - 19% = 123
20 - 39% = 106
40 - 59% = 105
60 - 79% = 538
80 - 99% = 2154
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 277, nodes: 191942
Average data length: 1.47, total dup: 163618, max dup: 51
Fill distribution:
0 - 19% = 0
20 - 39% = 40
40 - 59% = 151
60 - 79% = 78
80 - 99% = 8
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 41.25, total records: 643423
Average version length: 68.23, total versions: 256710, max versions: 1
Data pages: 9244, data page slots: 9305, average fill: 79%
Fill distribution:
0 - 19% = 147
20 - 39% = 200
40 - 59% = 421
60 - 79% = 4036
80 - 99% = 4440
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 903, nodes: 643423
Average data length: 1.29, total dup: 559614, max dup: 44
Fill distribution:
0 - 19% = 0
20 - 39% = 39
40 - 59% = 596
60 - 79% = 163
80 - 99% = 105
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 78.96, total records: 855248
Average version length: 80.18, total versions: 14331, max versions: 1
Data pages: 12746, data page slots: 12746, average fill: 80%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6815
80 - 99% = 5930
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 948, nodes: 855248
Average data length: 0.16, total dup: 835870, max dup: 139
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 700
60 - 79% = 195
80 - 99% = 46
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 682, nodes: 855248
Average data length: 0.74, total dup: 751695, max dup: 49
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 117
60 - 79% = 16
80 - 99% = 546
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1084, nodes: 855248
Average data length: 0.76, total dup: 748825, max dup: 29
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 813
60 - 79% = 215
80 - 99% = 47
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 71.73, total records: 593370
Average version length: 80.05, total versions: 62426, max versions: 1
Data pages: 9021, data page slots: 9032, average fill: 80%
Fill distribution:
0 - 19% = 61
20 - 39% = 82
40 - 59% = 141
60 - 79% = 5281
80 - 99% = 3456
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 626, nodes: 593370
Average data length: 0.15, total dup: 580417, max dup: 326
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 403
60 - 79% = 181
80 - 99% = 36
Index XQS_1000_3300_RCV_ID (2)
Depth: 2, leaf buckets: 470, nodes: 593370
Average data length: 0.81, total dup: 516799, max dup: 14
Fill distribution:
0 - 19% = 5
20 - 39% = 4
40 - 59% = 56
60 - 79% = 9
80 - 99% = 396
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 747, nodes: 593370
Average data length: 0.74, total dup: 522846, max dup: 44
Fill distribution:
0 - 19% = 30
20 - 39% = 6
40 - 59% = 480
60 - 79% = 191
80 - 99% = 40
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 78.56, total records: 871355
Average version length: 80.27, total versions: 19184, max versions: 1
Data pages: 12987, data page slots: 12987, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 7242
80 - 99% = 5744
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 915, nodes: 871355
Average data length: 0.05, total dup: 866023, max dup: 898
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 638
60 - 79% = 210
80 - 99% = 67
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 657, nodes: 871355
Average data length: 0.72, total dup: 767634, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 57
60 - 79% = 1
80 - 99% = 596
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1045, nodes: 871355
Average data length: 0.73, total dup: 767861, max dup: 105
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 675
60 - 79% = 275
80 - 99% = 90
XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 73.85, total records: 708405
Average version length: 80.02, total versions: 57133, max versions: 1
Data pages: 11082, data page slots: 11103, average fill: 77%
Fill distribution:
0 - 19% = 123
20 - 39% = 272
40 - 59% = 466
60 - 79% = 5931
80 - 99% = 4290
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 653, nodes: 708405
Average data length: 0.05, total dup: 704217, max dup: 637
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 230
60 - 79% = 277
80 - 99% = 133
Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 668, nodes: 708405
Average data length: 0.83, total dup: 615773, max dup: 14
Fill distribution:
0 - 19% = 12
20 - 39% = 44
40 - 59% = 209
60 - 79% = 10
80 - 99% = 393
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 752, nodes: 708405
Average data length: 0.72, total dup: 625138, max dup: 62
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 248
60 - 79% = 357
80 - 99% = 141
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 61.43, total records: 294005
Average version length: 68.18, total versions: 29446, max versions: 1
Data pages: 3957, data page slots: 3957, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 1
60 - 79% = 3200
80 - 99% = 754
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 265, nodes: 294005
Average data length: 0.22, total dup: 284868, max dup: 213
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 98
60 - 79% = 102
80 - 99% = 65
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 307, nodes: 294005
Average data length: 0.82, total dup: 255815, max dup: 32
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 120
60 - 79% = 120
80 - 99% = 67
ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Done for 4620 ms, from 2:29:32.18 to 2:29:36.80.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
406418 |
9632 |
2.3699 |
DOC_LIST |
64520 |
4725 |
7.3233 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
47972 |
11993.0000 |
INVNT_TURNOVER_LOG |
95475 |
95034 |
99.5380 |
MONEY_SALDO |
49 |
2435 |
4969.3877 |
MONEY_TURNOVER_LOG |
4509 |
4493 |
99.6451 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
110545 |
67384 |
60.9561 |
PERF_ESTIMATED |
11884 |
2 |
0.0168 |
PERF_LOG |
956803 |
1 |
0.0001 |
PSTORNED |
79755 |
4031 |
5.0542 |
RULES_FOR_PDISTR |
4 |
0 |
0.0000 |
RULES_FOR_QDISTR |
7 |
0 |
0.0000 |
SEMAPHORES |
4 |
518 |
12950.0000 |
SETTINGS |
114 |
0 |
0.0000 |
TRACE_STAT |
134 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
146062 |
145551 |
99.6501 |
XQD_1000_3300 |
165875 |
58614 |
35.3362 |
XQD_1200_2000 |
165983 |
165503 |
99.7108 |
XQD_2000_3300 |
870482 |
687342 |
78.9610 |
XQD_2100_3300 |
191942 |
174183 |
90.7477 |
XQD_3300_3400 |
643423 |
256710 |
39.8975 |
XQS_1000_1200 |
855248 |
14331 |
1.6756 |
XQS_1000_3300 |
593370 |
62426 |
10.5205 |
XQS_1200_2000 |
871355 |
19184 |
2.2016 |
XQS_2100_3300 |
708405 |
57133 |
8.0650 |
XQS_3300_3400 |
294005 |
29446 |
10.0154 |
Z_USED_VIEWS |
32 |
0 |
0.0000 |
Done for 3920 ms, from 2:29:48.70 to 2:29:52.62.
02:29:52.90 Validation started
02:29:52.90 Relation 140 (DOC_LIST)
02:29:52.90 process pointer page 0 of 1
02:29:52.93 Index 1 (PK_DOC_LIST)
02:29:52.94 Index 2 (DOC_LIST_ID_DESC)
02:29:52.94 Index 3 (FK_DOC_LIST_AGENTS)
02:29:52.96 Relation 140 (DOC_LIST) is ok
02:29:52.96 Relation 141 (DOC_DATA)
02:29:52.96 process pointer page 0 of 3
02:29:53.01 process pointer page 1 of 3
02:29:53.04 process pointer page 2 of 3
02:29:53.05 Index 2 (DOC_DATA_DOC_WARE_UNQ)
02:29:53.11 Index 3 (DOC_DATA_ID_DESC)
02:29:53.16 Index 4 (FK_DOC_DATA_DOC_LIST)
02:29:53.19 Relation 141 (DOC_DATA) is ok
02:29:53.19 Relation 147 (INVNT_SALDO)
02:29:53.19 process pointer page 0 of 1
02:29:53.22 Index 1 (PK_INVNT_SALDO)
02:29:53.22 Relation 147 (INVNT_SALDO) is ok
02:29:53.22 Relation 150 (PDISTR)
02:29:53.22 process pointer page 0 of 1
02:29:53.27 Index 2 (PDISTR_SND_ID)
02:29:53.30 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
02:29:53.33 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
02:29:53.35 Index 5 (PDISTR_AGENT_ID)
02:29:53.38 Relation 150 (PDISTR) is ok
02:29:53.38 Relation 151 (PSTORNED)
02:29:53.38 process pointer page 0 of 1
02:29:53.44 Index 2 (PSTORNED_SND_ID)
02:29:53.46 Index 3 (PSTORNED_RCV_ID)
02:29:53.47 Relation 151 (PSTORNED) is ok
02:29:53.47 Relation 156 (SEMAPHORES)
02:29:53.47 process pointer page 0 of 1
02:29:53.47 Index 1 (PK_SEMAPHORES)
02:29:53.47 Index 2 (SEMAPHORES_TASK_UNQ)
02:29:53.47 Relation 156 (SEMAPHORES) is ok
02:29:53.47 Relation 157 (INVNT_TURNOVER_LOG)
02:29:53.47 process pointer page 0 of 1
02:29:53.60 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
02:29:53.66 Relation 157 (INVNT_TURNOVER_LOG) is ok
02:29:53.66 Relation 160 (PERF_ESTIMATED)
02:29:53.66 process pointer page 0 of 1
02:29:53.66 Index 1 (PERF_EST_MINUTE_SINCE_START)
02:29:53.66 Relation 160 (PERF_ESTIMATED) is ok
02:29:53.66 Relation 161 (PERF_ISQL_STAT)
02:29:53.66 process pointer page 0 of 1
02:29:53.66 Index 1 (PERF_ISQL_STAT_TRN)
02:29:53.66 Relation 161 (PERF_ISQL_STAT) is ok
02:29:53.66 Relation 162 (PERF_LOG)
02:29:53.66 process pointer page 0 of 12
02:29:53.74 process pointer page 1 of 12
02:29:53.82 process pointer page 2 of 12
02:29:53.89 process pointer page 3 of 12
02:29:53.97 process pointer page 4 of 12
02:29:54.05 process pointer page 5 of 12
02:29:54.11 process pointer page 6 of 12
02:29:54.19 process pointer page 7 of 12
02:29:54.27 process pointer page 8 of 12
02:29:54.35 process pointer page 9 of 12
02:29:54.42 process pointer page 10 of 12
02:29:54.44 process pointer page 11 of 12
02:29:54.46 Index 1 (PERF_LOG_DTS_BEG_DESC)
02:29:54.74 Index 2 (PERF_LOG_UNIT)
02:29:55.24 Index 3 (PERF_LOG_TRN_DESC)
02:29:55.52 Index 4 (PERF_LOG_GDSCODE)
02:29:55.75 Relation 162 (PERF_LOG) is ok
02:29:55.75 Relation 166 (V_STOPTEST)
02:29:55.75 Relation 166 (V_STOPTEST) is ok
02:29:55.75 Relation 183 (V_QDISTR_SOURCE)
02:29:55.75 Relation 183 (V_QDISTR_SOURCE) is ok
02:29:55.75 Relation 184 (V_QSTORNED_SOURCE)
02:29:55.75 Relation 184 (V_QSTORNED_SOURCE) is ok
02:29:55.75 Relation 258 (XQD_1000_1200)
02:29:55.75 process pointer page 0 of 2
02:29:55.86 process pointer page 1 of 2
02:29:55.86 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
02:29:55.88 Relation 258 (XQD_1000_1200) is ok
02:29:55.88 Relation 259 (XQD_1200_2000)
02:29:55.88 process pointer page 0 of 2
02:29:56.00 process pointer page 1 of 2
02:29:56.03 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
02:29:56.08 Relation 259 (XQD_1200_2000) is ok
02:29:56.08 Relation 260 (XQD_1000_3300)
02:29:56.08 process pointer page 0 of 2
02:29:56.22 process pointer page 1 of 2
02:29:56.23 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
02:29:56.28 Index 2 (XQD_1000_3300_DOC)
02:29:56.33 Relation 260 (XQD_1000_3300) is ok
02:29:56.33 Relation 261 (XQD_2000_3300)
02:29:56.33 process pointer page 0 of 7
02:29:56.50 process pointer page 1 of 7
02:29:56.69 process pointer page 2 of 7
02:29:56.86 process pointer page 3 of 7
02:29:57.05 process pointer page 4 of 7
02:29:57.20 process pointer page 5 of 7
02:29:57.30 process pointer page 6 of 7
02:29:57.31 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
02:29:57.59 Relation 261 (XQD_2000_3300) is ok
02:29:57.59 Relation 262 (XQD_2100_3300)
02:29:57.59 process pointer page 0 of 2
02:29:57.76 process pointer page 1 of 2
02:29:57.84 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
02:29:57.89 Relation 262 (XQD_2100_3300) is ok
02:29:57.89 Relation 263 (XQD_3300_3400)
02:29:57.89 process pointer page 0 of 5
02:29:57.98 process pointer page 1 of 5
02:29:58.12 process pointer page 2 of 5
02:29:58.25 process pointer page 3 of 5
02:29:58.36 process pointer page 4 of 5
02:29:58.43 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
02:29:58.65 Relation 263 (XQD_3300_3400) is ok
02:29:58.65 Relation 264 (XQS_1000_1200)
02:29:58.65 process pointer page 0 of 7
02:29:58.75 process pointer page 1 of 7
02:29:58.84 process pointer page 2 of 7
02:29:58.93 process pointer page 3 of 7
02:29:59.01 process pointer page 4 of 7
02:29:59.10 process pointer page 5 of 7
02:29:59.20 process pointer page 6 of 7
02:29:59.26 Index 1 (XQS_1000_1200_DOC_ID)
02:29:59.51 Index 2 (XQS_1000_1200_SND_ID)
02:29:59.78 Index 3 (XQS_1000_1200_RCV_ID)
02:29:59.98 Relation 264 (XQS_1000_1200) is ok
02:29:59.98 Relation 265 (XQS_1200_2000)
02:29:59.98 process pointer page 0 of 7
02:30:00.07 process pointer page 1 of 7
02:30:00.17 process pointer page 2 of 7
02:30:00.24 process pointer page 3 of 7
02:30:00.34 process pointer page 4 of 7
02:30:00.43 process pointer page 5 of 7
02:30:00.52 process pointer page 6 of 7
02:30:00.60 Index 1 (XQS_1200_2000_DOC_ID)
02:30:00.79 Index 2 (XQS_1200_2000_SND_ID)
02:30:00.93 Index 3 (XQS_1200_2000_RCV_ID)
02:30:01.13 Relation 265 (XQS_1200_2000) is ok
02:30:01.13 Relation 266 (XQS_1000_3300)
02:30:01.13 process pointer page 0 of 5
02:30:01.24 process pointer page 1 of 5
02:30:01.34 process pointer page 2 of 5
02:30:01.43 process pointer page 3 of 5
02:30:01.54 process pointer page 4 of 5
02:30:01.60 Index 1 (XQS_1000_3300_DOC_ID)
02:30:01.76 Index 2 (XQS_1000_3300_SND_ID)
02:30:01.93 Index 3 (XQS_1000_3300_RCV_ID)
02:30:02.07 Relation 266 (XQS_1000_3300) is ok
02:30:02.07 Relation 267 (XQS_2000_3300)
02:30:02.07 process pointer page 0 of 1
02:30:02.07 Index 1 (XQS_2000_3300_DOC_ID)
02:30:02.07 Index 2 (XQS_2000_3300_SND_ID)
02:30:02.07 Index 3 (XQS_2000_3300_RCV_ID)
02:30:02.07 Relation 267 (XQS_2000_3300) is ok
02:30:02.07 Relation 268 (XQS_2100_3300)
02:30:02.07 process pointer page 0 of 6
02:30:02.16 process pointer page 1 of 6
02:30:02.24 process pointer page 2 of 6
02:30:02.27 process pointer page 3 of 6
02:30:02.30 process pointer page 4 of 6
02:30:02.35 process pointer page 5 of 6
02:30:02.37 Index 1 (XQS_2100_3300_DOC_ID)
02:30:02.60 Index 2 (XQS_2100_3300_SND_ID)
02:30:02.85 Index 3 (XQS_2100_3300_RCV_ID)
02:30:03.02 Relation 268 (XQS_2100_3300) is ok
02:30:03.02 Relation 269 (XQS_3300_3400)
02:30:03.02 process pointer page 0 of 3
02:30:03.13 process pointer page 1 of 3
02:30:03.24 process pointer page 2 of 3
02:30:03.24 Index 1 (XQS_3300_3400_DOC_ID)
02:30:03.30 Index 2 (XQS_3300_3400_SND_ID)
02:30:03.38 Relation 269 (XQS_3300_3400) is ok
02:30:03.38 Relation 276 (TRACE_STAT)
02:30:03.38 process pointer page 0 of 1
02:30:03.38 Relation 276 (TRACE_STAT) is ok
02:30:03.38 Validation finished
Done for 10860 ms, from 2:29:52.69 to 2:30:03.55.
Differences between old and current firebird.log
2:30:04.58. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 8 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-08-28 02:30 360 oltp25_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log
4: Server version: WI-V2.5.7.27025 Firebird 2.5
5: Server version: WI-V2.5.7.27025 Firebird 2.5
***** E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
4: Server version: WI-V2.5.7.27025 Firebird 2.5
5:
6: WIN-2BE1UI8LGDL Sun Aug 28 02:27:58 2016
7: SERVER/process_packet: broken port, server exiting
8:
9:
*****
+++ 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.oltp25\oltp25_*.*:
ERRORS_CHECKING_RESULT |
NO_SEVERE_ERRORS_FOUND |
ISQL logs are removed because no severe errors occured during test.
2016-08-28 2:30:08.17 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html