Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-11-21 6:57:54.18.
Server version: WI-V3.0.2.32630 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE |
DB_NAME |
FORCED_WRITES |
SWEEP_INT |
PAGE_BUFFERS |
PAGE_SIZE |
SuperServer 3.0.2 |
D:\OLTP-EMUL\OLTP30-SMALL.FDB |
ON |
0 |
786432 |
8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME |
PARAM_VALUE |
fbc |
E:\FB30.TMPINSTANCE |
dbnm |
D:\OLTP-EMUL\oltp30-small.fdb |
host |
localhost |
port |
3333 |
usr |
SYSDBA |
pwd |
masterkey |
tmpdir |
e:\temp\logs.oltp30 |
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 |
ak30 |
upload_report |
1 |
max_snapshots_to_store |
180 |
replace_instance |
1 |
FINISH_STATE |
DTS_END |
FB_GDSCODE |
FB_MNEMONA |
STACK |
IP |
TRN_ID |
ATT_ID |
EXC_UNIT |
NORMAL: TEST_TIME EXPIRED. |
2016-11-21 06:55:59.6330 |
-1 |
<null> |
|
::1/57847 |
340734 |
5004 |
2 |
CATEGORY |
SETTING |
VAL |
COMMON |
TRACED_UNITS |
,, |
COMMON |
HALT_TEST_ON_ERRORS |
,CK, |
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 |
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: |
5207.06 |
7122 |
942478 |
2016-11-21 03:55 |
2016-11-21 06:56 |
customer order: creation |
400.81 |
1037 |
72547 |
2016-11-21 03:55 |
2016-11-21 06:56 |
customer order: refuse |
32.41 |
76 |
5801 |
2016-11-21 03:55 |
2016-11-21 06:56 |
order to supplier: creation |
103.67 |
7341 |
18661 |
2016-11-21 03:55 |
2016-11-21 06:56 |
order to supplier: removal |
2.31 |
78892 |
412 |
2016-11-21 03:55 |
2016-11-21 06:56 |
invoice (draft): creation |
103.99 |
11431 |
18823 |
2016-11-21 03:55 |
2016-11-21 06:56 |
invoice (draft): removal |
35.29 |
2435 |
6282 |
2016-11-21 03:55 |
2016-11-21 06:56 |
invoice accept: apply |
63.61 |
22072 |
11386 |
2016-11-21 03:55 |
2016-11-21 06:56 |
invoice accept: cancel |
16.32 |
5067 |
2938 |
2016-11-21 03:55 |
2016-11-21 06:56 |
customer reserve: creation |
3086.49 |
380 |
555568 |
2016-11-21 03:55 |
2016-11-21 06:56 |
customer reserve: removal |
846.41 |
138 |
151508 |
2016-11-21 03:55 |
2016-11-21 06:56 |
realization accept: apply |
186.28 |
327 |
33530 |
2016-11-21 03:55 |
2016-11-21 06:56 |
realization accept: cancel |
51.54 |
218 |
9225 |
2016-11-21 03:55 |
2016-11-21 06:56 |
payment from customer: creation |
134.63 |
318 |
24099 |
2016-11-21 03:55 |
2016-11-21 06:56 |
payment from customer: removal |
12.56 |
98 |
2249 |
2016-11-21 03:55 |
2016-11-21 06:56 |
payment to supplier: creation |
111.32 |
695 |
20038 |
2016-11-21 03:55 |
2016-11-21 06:56 |
payment to supplier: removal |
7.86 |
148 |
1407 |
2016-11-21 03:55 |
2016-11-21 06:56 |
service: total inventory turnovers |
20.72 |
1401 |
3729 |
2016-11-21 03:55 |
2016-11-21 06:56 |
service: total monetary turnovers |
23.82 |
62 |
4263 |
2016-11-21 03:55 |
2016-11-21 06:56 |
service: refresh index statistics |
0.07 |
3187 |
12 |
2016-11-21 03:55 |
2016-11-21 06:56 |
Done for 35110 ms, from 6:58:56.13 to 6:59:31.24.
ACTION |
ITRV_NO |
CNT_OK_PER_MINUTE |
CNT_ALL |
CNT_OK |
CNT_ERR |
ERR_PRC |
ITRV_BEG |
ITRV_END |
interval # 1, overall |
1 |
3947 |
76126 |
71038 |
5088 |
6.68 |
03:56:00 |
04:14:00 |
interval # 2, overall |
2 |
5400 |
102591 |
97203 |
5388 |
5.25 |
04:14:01 |
04:32:01 |
interval # 3, overall |
3 |
5407 |
102168 |
97330 |
4838 |
4.74 |
04:32:02 |
04:50:02 |
interval # 4, overall |
4 |
5351 |
104322 |
96325 |
7997 |
7.67 |
04:50:03 |
05:08:03 |
interval # 5, overall |
5 |
5664 |
110124 |
101944 |
8180 |
7.43 |
05:08:04 |
05:26:04 |
interval # 6, overall |
6 |
5371 |
101580 |
96675 |
4905 |
4.83 |
05:26:05 |
05:44:05 |
interval # 7, overall |
7 |
5453 |
104731 |
98148 |
6583 |
6.29 |
05:44:06 |
06:02:06 |
interval # 8, overall |
8 |
5350 |
103570 |
96294 |
7276 |
7.03 |
06:02:07 |
06:20:07 |
interval # 9, overall |
9 |
5330 |
100572 |
95947 |
4625 |
4.60 |
06:20:08 |
06:38:08 |
interval # 10, overall |
10 |
5087 |
97396 |
91574 |
5822 |
5.98 |
06:38:09 |
06:56:09 |
Done for 147850 ms, from 7:01:54.44 to 7:04:22.29.
TEST_PHASE |
MINUTE_SINCE_TEST_START |
AVG_ESTIMATED |
MIN_TO_AVG_RATIO |
MAX_TO_AVG_RATIO |
ROWS_AGGREGATED |
DISTINCT_ATTACHMENTS |
WARM_TIME |
1 |
2500.80 |
0.0003 |
1.9433 |
3595 |
47 |
WARM_TIME |
2 |
3102.56 |
0.7833 |
1.2114 |
2654 |
85 |
WARM_TIME |
3 |
2880.29 |
0.8700 |
1.1300 |
1865 |
63 |
WARM_TIME |
4 |
2618.94 |
0.9322 |
1.0727 |
1220 |
48 |
WARM_TIME |
5 |
2414.32 |
0.9310 |
1.0629 |
1185 |
45 |
WARM_TIME |
6 |
2248.67 |
0.9510 |
1.0498 |
1009 |
39 |
WARM_TIME |
7 |
2123.45 |
0.9529 |
1.0484 |
912 |
40 |
WARM_TIME |
8 |
2045.25 |
0.9525 |
1.0478 |
981 |
43 |
WARM_TIME |
9 |
1991.12 |
0.9568 |
1.0522 |
846 |
49 |
WARM_TIME |
10 |
1978.58 |
0.9530 |
1.0482 |
875 |
42 |
TEST_TIME |
11 |
2004.02 |
0.9408 |
1.0547 |
1159 |
56 |
TEST_TIME |
12 |
2045.69 |
0.9471 |
1.0621 |
1174 |
66 |
TEST_TIME |
13 |
2121.51 |
0.9454 |
1.0542 |
1338 |
68 |
TEST_TIME |
14 |
2184.90 |
0.9506 |
1.0508 |
1405 |
82 |
TEST_TIME |
15 |
2254.63 |
0.9505 |
1.0561 |
1310 |
85 |
TEST_TIME |
16 |
2354.87 |
0.9480 |
1.0492 |
1458 |
87 |
TEST_TIME |
17 |
2430.01 |
0.9570 |
1.0405 |
1544 |
88 |
TEST_TIME |
18 |
2502.46 |
0.9543 |
1.0381 |
1427 |
94 |
TEST_TIME |
19 |
2590.04 |
0.9503 |
1.0455 |
1750 |
97 |
TEST_TIME |
20 |
2684.23 |
0.9584 |
1.0352 |
1557 |
96 |
TEST_TIME |
21 |
2771.32 |
0.9549 |
1.0525 |
1758 |
98 |
TEST_TIME |
22 |
2888.85 |
0.9638 |
1.0376 |
1556 |
99 |
TEST_TIME |
23 |
2977.83 |
0.9628 |
1.0360 |
1527 |
96 |
TEST_TIME |
24 |
3042.34 |
0.9718 |
1.0267 |
1349 |
98 |
TEST_TIME |
25 |
3105.30 |
0.9656 |
1.0277 |
1498 |
97 |
TEST_TIME |
26 |
3123.83 |
0.9823 |
1.0238 |
1254 |
92 |
TEST_TIME |
27 |
3187.75 |
0.9661 |
1.0346 |
1593 |
96 |
TEST_TIME |
28 |
3259.15 |
0.9758 |
1.0171 |
1348 |
91 |
TEST_TIME |
29 |
3278.50 |
0.9763 |
1.0264 |
1310 |
87 |
TEST_TIME |
30 |
3342.56 |
0.9732 |
1.0283 |
1658 |
96 |
TEST_TIME |
31 |
3407.79 |
0.9760 |
1.0234 |
1490 |
93 |
TEST_TIME |
32 |
3461.55 |
0.9761 |
1.0236 |
1564 |
93 |
TEST_TIME |
33 |
3498.38 |
0.9822 |
1.0165 |
1368 |
96 |
TEST_TIME |
34 |
3543.52 |
0.9741 |
1.0247 |
1819 |
99 |
TEST_TIME |
35 |
3626.81 |
0.9726 |
1.0257 |
1740 |
98 |
TEST_TIME |
36 |
3708.52 |
0.9754 |
1.0222 |
1717 |
97 |
TEST_TIME |
37 |
3765.90 |
0.9794 |
1.0224 |
1900 |
95 |
TEST_TIME |
38 |
3840.52 |
0.9761 |
1.0166 |
1700 |
98 |
TEST_TIME |
39 |
3862.79 |
0.9849 |
1.0172 |
1563 |
94 |
TEST_TIME |
40 |
3914.86 |
0.9785 |
1.0158 |
1696 |
95 |
TEST_TIME |
41 |
3951.56 |
0.9819 |
1.0169 |
1609 |
95 |
TEST_TIME |
42 |
3980.70 |
0.9854 |
1.0138 |
1405 |
94 |
TEST_TIME |
43 |
3994.35 |
0.9868 |
1.0183 |
1473 |
96 |
TEST_TIME |
44 |
4024.34 |
0.9877 |
1.0126 |
1220 |
94 |
TEST_TIME |
45 |
4045.77 |
0.9849 |
1.0142 |
1379 |
96 |
TEST_TIME |
46 |
4064.38 |
0.9876 |
1.0129 |
1444 |
95 |
TEST_TIME |
47 |
4081.87 |
0.9871 |
1.0128 |
1241 |
94 |
TEST_TIME |
48 |
4097.15 |
0.9880 |
1.0111 |
1405 |
92 |
TEST_TIME |
49 |
4126.95 |
0.9833 |
1.0144 |
1829 |
93 |
TEST_TIME |
50 |
4162.16 |
0.9857 |
1.0164 |
1628 |
95 |
TEST_TIME |
51 |
4202.23 |
0.9870 |
1.0184 |
1544 |
96 |
TEST_TIME |
52 |
4246.22 |
0.9885 |
1.0135 |
1286 |
98 |
TEST_TIME |
53 |
4284.68 |
0.9854 |
1.0141 |
1376 |
98 |
TEST_TIME |
54 |
4320.22 |
0.9872 |
1.0124 |
1586 |
95 |
TEST_TIME |
55 |
4340.36 |
0.9894 |
1.0112 |
1423 |
90 |
TEST_TIME |
56 |
4358.22 |
0.9894 |
1.0124 |
1332 |
94 |
TEST_TIME |
57 |
4380.53 |
0.9895 |
1.0117 |
1298 |
96 |
TEST_TIME |
58 |
4393.45 |
0.9913 |
1.0116 |
1240 |
92 |
TEST_TIME |
59 |
4402.41 |
0.9925 |
1.0087 |
1191 |
94 |
TEST_TIME |
60 |
4400.65 |
0.9923 |
1.0089 |
1281 |
93 |
TEST_TIME |
61 |
4397.14 |
0.9931 |
1.0065 |
1154 |
86 |
TEST_TIME |
62 |
4392.65 |
0.9913 |
1.0120 |
1091 |
92 |
TEST_TIME |
63 |
4407.21 |
0.9926 |
1.0062 |
1062 |
94 |
TEST_TIME |
64 |
4413.87 |
0.9890 |
1.0089 |
1579 |
94 |
TEST_TIME |
65 |
4444.13 |
0.9866 |
1.0104 |
1491 |
96 |
TEST_TIME |
66 |
4458.99 |
0.9918 |
1.0121 |
1322 |
94 |
TEST_TIME |
67 |
4476.80 |
0.9930 |
1.0075 |
1244 |
90 |
TEST_TIME |
68 |
4494.79 |
0.9887 |
1.0095 |
1593 |
94 |
TEST_TIME |
69 |
4514.38 |
0.9905 |
1.0091 |
1543 |
94 |
TEST_TIME |
70 |
4526.70 |
0.9920 |
1.0082 |
1397 |
91 |
TEST_TIME |
71 |
4534.39 |
0.9923 |
1.0078 |
1272 |
90 |
TEST_TIME |
72 |
4535.93 |
0.9935 |
1.0061 |
1310 |
90 |
TEST_TIME |
73 |
4542.64 |
0.9909 |
1.0089 |
1199 |
93 |
TEST_TIME |
74 |
4552.24 |
0.9932 |
1.0067 |
1028 |
90 |
TEST_TIME |
75 |
4559.10 |
0.9918 |
1.0082 |
1245 |
94 |
TEST_TIME |
76 |
4569.70 |
0.9926 |
1.0064 |
1241 |
91 |
TEST_TIME |
77 |
4570.54 |
0.9932 |
1.0089 |
1229 |
95 |
TEST_TIME |
78 |
4576.99 |
0.9946 |
1.0054 |
1133 |
93 |
TEST_TIME |
79 |
4582.96 |
0.9914 |
1.0077 |
1388 |
95 |
TEST_TIME |
80 |
4599.78 |
0.9914 |
1.0087 |
1348 |
95 |
TEST_TIME |
81 |
4617.55 |
0.9924 |
1.0063 |
1558 |
90 |
TEST_TIME |
82 |
4623.32 |
0.9928 |
1.0066 |
1546 |
92 |
TEST_TIME |
83 |
4621.63 |
0.9950 |
1.0053 |
1136 |
90 |
TEST_TIME |
84 |
4628.33 |
0.9919 |
1.0066 |
1250 |
91 |
TEST_TIME |
85 |
4637.61 |
0.9928 |
1.0066 |
1458 |
92 |
TEST_TIME |
86 |
4646.17 |
0.9930 |
1.0071 |
1370 |
90 |
TEST_TIME |
87 |
4654.96 |
0.9936 |
1.0058 |
1358 |
92 |
TEST_TIME |
88 |
4654.38 |
0.9945 |
1.0070 |
1306 |
95 |
TEST_TIME |
89 |
4662.50 |
0.9939 |
1.0045 |
1361 |
91 |
TEST_TIME |
90 |
4671.65 |
0.9914 |
1.0133 |
1198 |
100 |
TEST_TIME |
91 |
4697.49 |
0.9967 |
1.0040 |
1247 |
99 |
TEST_TIME |
92 |
4690.46 |
0.9945 |
1.0070 |
1330 |
95 |
TEST_TIME |
93 |
4704.32 |
0.9932 |
1.0071 |
1386 |
93 |
TEST_TIME |
94 |
4722.18 |
0.9926 |
1.0073 |
1637 |
93 |
TEST_TIME |
95 |
4749.58 |
0.9910 |
1.0071 |
1850 |
92 |
TEST_TIME |
96 |
4759.86 |
0.9945 |
1.0048 |
1674 |
90 |
TEST_TIME |
97 |
4771.19 |
0.9921 |
1.0058 |
1605 |
90 |
TEST_TIME |
98 |
4781.43 |
0.9934 |
1.0067 |
1538 |
91 |
TEST_TIME |
99 |
4797.14 |
0.9933 |
1.0055 |
1490 |
92 |
TEST_TIME |
100 |
4797.28 |
0.9954 |
1.0054 |
1501 |
91 |
TEST_TIME |
101 |
4816.63 |
0.9914 |
1.0069 |
1355 |
94 |
TEST_TIME |
102 |
4830.63 |
0.9942 |
1.0061 |
1273 |
93 |
TEST_TIME |
103 |
4841.21 |
0.9941 |
1.0044 |
1219 |
94 |
TEST_TIME |
104 |
4840.62 |
0.9948 |
1.0052 |
1414 |
92 |
TEST_TIME |
105 |
4838.79 |
0.9960 |
1.0036 |
1319 |
89 |
TEST_TIME |
106 |
4830.98 |
0.9958 |
1.0037 |
1211 |
90 |
TEST_TIME |
107 |
4825.78 |
0.9953 |
1.0045 |
1271 |
93 |
TEST_TIME |
108 |
4821.37 |
0.9961 |
1.0040 |
1213 |
90 |
TEST_TIME |
109 |
4820.31 |
0.9950 |
1.0051 |
1540 |
93 |
TEST_TIME |
110 |
4817.85 |
0.9965 |
1.0044 |
1478 |
93 |
TEST_TIME |
111 |
4818.03 |
0.9953 |
1.0052 |
1403 |
88 |
TEST_TIME |
112 |
4822.11 |
0.9954 |
1.0042 |
1464 |
90 |
TEST_TIME |
113 |
4832.34 |
0.9932 |
1.0050 |
1331 |
91 |
TEST_TIME |
114 |
4839.40 |
0.9948 |
1.0059 |
1345 |
92 |
TEST_TIME |
115 |
4853.08 |
0.9943 |
1.0053 |
1416 |
94 |
TEST_TIME |
116 |
4864.99 |
0.9942 |
1.0049 |
1166 |
92 |
TEST_TIME |
117 |
4867.42 |
0.9960 |
1.0045 |
1167 |
91 |
TEST_TIME |
118 |
4870.61 |
0.9954 |
1.0049 |
1250 |
92 |
TEST_TIME |
119 |
4877.45 |
0.9950 |
1.0057 |
1197 |
92 |
TEST_TIME |
120 |
4882.32 |
0.9963 |
1.0035 |
1253 |
94 |
TEST_TIME |
121 |
4885.98 |
0.9944 |
1.0054 |
1247 |
93 |
TEST_TIME |
122 |
4893.68 |
0.9956 |
1.0024 |
888 |
82 |
TEST_TIME |
123 |
4886.61 |
0.9957 |
1.0034 |
1127 |
91 |
TEST_TIME |
124 |
4890.81 |
0.9945 |
1.0052 |
1491 |
94 |
TEST_TIME |
125 |
4902.51 |
0.9948 |
1.0048 |
1606 |
91 |
TEST_TIME |
126 |
4924.90 |
0.9928 |
1.0029 |
1330 |
91 |
TEST_TIME |
127 |
4923.28 |
0.9953 |
1.0045 |
1380 |
89 |
TEST_TIME |
128 |
4928.80 |
0.9955 |
1.0056 |
1413 |
92 |
TEST_TIME |
129 |
4938.21 |
0.9959 |
1.0032 |
1186 |
92 |
TEST_TIME |
130 |
4932.17 |
0.9967 |
1.0038 |
1143 |
87 |
TEST_TIME |
131 |
4931.19 |
0.9963 |
1.0039 |
1301 |
93 |
TEST_TIME |
132 |
4934.95 |
0.9955 |
1.0038 |
1299 |
95 |
TEST_TIME |
133 |
4938.37 |
0.9956 |
1.0049 |
1282 |
94 |
TEST_TIME |
134 |
4943.03 |
0.9965 |
1.0041 |
1143 |
93 |
TEST_TIME |
135 |
4944.25 |
0.9965 |
1.0038 |
1233 |
88 |
TEST_TIME |
136 |
4949.68 |
0.9953 |
1.0050 |
1159 |
92 |
TEST_TIME |
137 |
4951.00 |
0.9974 |
1.0029 |
1099 |
90 |
TEST_TIME |
138 |
4941.56 |
0.9975 |
1.0028 |
1165 |
85 |
TEST_TIME |
139 |
4940.54 |
0.9958 |
1.0037 |
1368 |
89 |
TEST_TIME |
140 |
4939.92 |
0.9966 |
1.0039 |
1328 |
87 |
TEST_TIME |
141 |
4947.03 |
0.9953 |
1.0059 |
1317 |
89 |
TEST_TIME |
142 |
4974.01 |
0.9934 |
1.0046 |
1250 |
93 |
TEST_TIME |
143 |
4982.34 |
0.9959 |
1.0040 |
1241 |
96 |
TEST_TIME |
144 |
4980.87 |
0.9973 |
1.0030 |
1253 |
91 |
TEST_TIME |
145 |
4982.06 |
0.9959 |
1.0052 |
1328 |
96 |
TEST_TIME |
146 |
4990.56 |
0.9966 |
1.0029 |
1239 |
94 |
TEST_TIME |
147 |
4993.24 |
0.9955 |
1.0043 |
1393 |
92 |
TEST_TIME |
148 |
4997.92 |
0.9966 |
1.0031 |
1418 |
92 |
TEST_TIME |
149 |
4996.73 |
0.9966 |
1.0031 |
1285 |
89 |
TEST_TIME |
150 |
4994.66 |
0.9969 |
1.0041 |
1282 |
88 |
TEST_TIME |
151 |
4999.72 |
0.9965 |
1.0037 |
1157 |
90 |
TEST_TIME |
152 |
4999.89 |
0.9971 |
1.0024 |
1172 |
90 |
TEST_TIME |
153 |
4995.79 |
0.9967 |
1.0031 |
1090 |
90 |
TEST_TIME |
154 |
4995.68 |
0.9966 |
1.0026 |
1391 |
88 |
TEST_TIME |
155 |
4994.78 |
0.9964 |
1.0035 |
1421 |
88 |
TEST_TIME |
156 |
5004.53 |
0.9951 |
1.0044 |
1444 |
91 |
TEST_TIME |
157 |
5009.99 |
0.9969 |
1.0047 |
1232 |
90 |
TEST_TIME |
158 |
5015.76 |
0.9972 |
1.0031 |
1366 |
91 |
TEST_TIME |
159 |
5017.30 |
0.9965 |
1.0028 |
1297 |
89 |
TEST_TIME |
160 |
5015.13 |
0.9970 |
1.0030 |
1321 |
89 |
TEST_TIME |
161 |
5017.94 |
0.9962 |
1.0034 |
1207 |
89 |
TEST_TIME |
162 |
5020.98 |
0.9966 |
1.0029 |
1193 |
89 |
TEST_TIME |
163 |
5016.64 |
0.9976 |
1.0025 |
1185 |
92 |
TEST_TIME |
164 |
5015.22 |
0.9967 |
1.0031 |
1186 |
87 |
TEST_TIME |
165 |
5016.53 |
0.9967 |
1.0023 |
1203 |
86 |
TEST_TIME |
166 |
5010.42 |
0.9974 |
1.0027 |
1037 |
90 |
TEST_TIME |
167 |
5029.18 |
0.9929 |
1.0035 |
1020 |
97 |
TEST_TIME |
168 |
5026.08 |
0.9982 |
1.0021 |
1024 |
95 |
TEST_TIME |
169 |
5021.48 |
0.9971 |
1.0025 |
1420 |
93 |
TEST_TIME |
170 |
5021.88 |
0.9966 |
1.0031 |
1224 |
89 |
TEST_TIME |
171 |
5021.40 |
0.9974 |
1.0030 |
1225 |
89 |
TEST_TIME |
172 |
5026.98 |
0.9961 |
1.0043 |
1209 |
93 |
TEST_TIME |
173 |
5031.98 |
0.9975 |
1.0021 |
1272 |
92 |
TEST_TIME |
174 |
5029.53 |
0.9968 |
1.0029 |
1186 |
92 |
TEST_TIME |
175 |
5028.84 |
0.9973 |
1.0034 |
1076 |
92 |
TEST_TIME |
176 |
5037.06 |
0.9960 |
1.0028 |
1114 |
90 |
TEST_TIME |
177 |
5038.33 |
0.9968 |
1.0032 |
1320 |
92 |
TEST_TIME |
178 |
5044.85 |
0.9963 |
1.0025 |
1165 |
93 |
TEST_TIME |
179 |
5043.91 |
0.9971 |
1.0021 |
1216 |
92 |
TEST_TIME |
180 |
5042.55 |
0.9968 |
1.0023 |
1165 |
91 |
TEST_TIME |
181 |
5040.35 |
0.9972 |
1.0027 |
1185 |
90 |
TEST_TIME |
182 |
5039.29 |
0.9973 |
1.0022 |
1246 |
93 |
TEST_TIME |
183 |
5032.05 |
0.9982 |
1.0019 |
1182 |
90 |
TEST_TIME |
184 |
5029.09 |
0.9970 |
1.0031 |
1476 |
92 |
TEST_TIME |
185 |
5035.61 |
0.9964 |
1.0073 |
1313 |
96 |
TEST_TIME |
186 |
5051.12 |
0.9988 |
1.0022 |
1411 |
91 |
TEST_TIME |
187 |
5047.22 |
0.9976 |
1.0023 |
1259 |
89 |
TEST_TIME |
188 |
5046.57 |
0.9971 |
1.0042 |
1195 |
90 |
TEST_TIME |
189 |
5057.47 |
0.9967 |
1.0029 |
1137 |
94 |
TEST_TIME |
190 |
5057.66 |
0.9976 |
1.0027 |
1226 |
89 |
TEST_TIME |
191 |
5048.77 |
0.9992 |
1.0018 |
92 |
92 |
Done for 11520 ms, from 7:04:24.24 to 7:04:35.76.
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 |
2262 |
6861 |
5685 |
<null> |
5723 |
4446 |
11023 |
<null> |
6979 |
4016 |
5463 |
4278 |
20778 |
3712 |
49674 |
3741 |
429001 |
346693 |
<null> |
03:56:00 |
04:14:00 |
fetches per second |
2 |
2084 |
7162 |
4101 |
<null> |
4155 |
<null> |
9974 |
5464 |
15653 |
6098 |
5396 |
3894 |
22735 |
4457 |
32598 |
3411 |
285453 |
233714 |
<null> |
04:14:01 |
04:32:01 |
fetches per second |
3 |
2017 |
9745 |
4866 |
<null> |
4865 |
<null> |
11801 |
5508 |
26448 |
<null> |
5399 |
5892 |
47282 |
5475 |
29928 |
5038 |
488676 |
285571 |
<null> |
04:32:02 |
04:50:02 |
fetches per second |
4 |
1871 |
7362 |
5071 |
<null> |
5566 |
<null> |
12117 |
4092 |
21530 |
4550 |
3452 |
3496 |
28539 |
4358 |
36455 |
2699 |
402934 |
320552 |
<null> |
04:50:03 |
05:08:03 |
fetches per second |
5 |
2159 |
6091 |
4623 |
5071 |
4654 |
<null> |
13950 |
42299 |
38975 |
4701 |
4757 |
4300 |
45070 |
4723 |
24336 |
5455 |
388175 |
196457 |
<null> |
05:08:04 |
05:26:04 |
fetches per second |
6 |
1759 |
6157 |
5702 |
<null> |
6461 |
<null> |
15401 |
4700 |
34808 |
3896 |
5585 |
3761 |
42105 |
3148 |
31183 |
<null> |
437388 |
358579 |
<null> |
05:26:05 |
05:44:05 |
fetches per second |
7 |
1837 |
4112 |
5750 |
6092 |
6128 |
<null> |
13923 |
<null> |
28659 |
<null> |
10994 |
2551 |
43142 |
5357 |
19421 |
<null> |
<null> |
353082 |
<null> |
05:44:06 |
06:02:06 |
fetches per second |
8 |
1981 |
6162 |
5668 |
4736 |
5990 |
4118 |
11313 |
4164 |
22591 |
4159 |
6782 |
3146 |
33291 |
3578 |
37427 |
4009 |
512642 |
251865 |
<null> |
06:02:07 |
06:20:07 |
fetches per second |
9 |
1931 |
6904 |
6188 |
<null> |
7184 |
<null> |
14260 |
5135 |
16748 |
4383 |
5210 |
3581 |
34913 |
3863 |
29135 |
3714 |
497621 |
317191 |
<null> |
06:20:08 |
06:38:08 |
fetches per second |
10 |
1894 |
6472 |
5027 |
<null> |
5539 |
2403 |
14741 |
3705 |
12059 |
3070 |
4862 |
3552 |
36127 |
4415 |
23289 |
3538 |
454807 |
274550 |
<null> |
06:38:09 |
06:56:09 |
marks per second |
1 |
369 |
599 |
290 |
<null> |
300 |
706 |
393 |
<null> |
267 |
391 |
481 |
404 |
482 |
477 |
503 |
418 |
1290 |
391 |
<null> |
03:56:00 |
04:14:00 |
marks per second |
2 |
342 |
592 |
288 |
<null> |
316 |
<null> |
413 |
513 |
506 |
558 |
486 |
418 |
507 |
443 |
541 |
323 |
1504 |
1489 |
<null> |
04:14:01 |
04:32:01 |
marks per second |
3 |
328 |
886 |
268 |
<null> |
295 |
<null> |
416 |
492 |
409 |
<null> |
501 |
621 |
409 |
504 |
443 |
634 |
1320 |
821 |
<null> |
04:32:02 |
04:50:02 |
marks per second |
4 |
306 |
639 |
283 |
<null> |
279 |
<null> |
354 |
403 |
382 |
455 |
400 |
351 |
454 |
421 |
438 |
346 |
1258 |
627 |
<null> |
04:50:03 |
05:08:03 |
marks per second |
5 |
354 |
546 |
294 |
577 |
289 |
<null> |
407 |
3734 |
474 |
538 |
433 |
383 |
565 |
457 |
507 |
490 |
1552 |
505 |
<null> |
05:08:04 |
05:26:04 |
marks per second |
6 |
289 |
585 |
269 |
<null> |
281 |
<null> |
409 |
420 |
2833 |
382 |
394 |
354 |
420 |
320 |
430 |
<null> |
1170 |
677 |
<null> |
05:26:05 |
05:44:05 |
marks per second |
7 |
292 |
384 |
263 |
505 |
328 |
<null> |
371 |
<null> |
402 |
<null> |
416 |
274 |
357 |
501 |
391 |
<null> |
<null> |
2179 |
<null> |
05:44:06 |
06:02:06 |
marks per second |
8 |
315 |
568 |
289 |
405 |
369 |
727 |
348 |
356 |
472 |
370 |
423 |
477 |
389 |
332 |
1003 |
556 |
1357 |
1170 |
<null> |
06:02:07 |
06:20:07 |
marks per second |
9 |
307 |
629 |
271 |
<null> |
300 |
<null> |
363 |
462 |
318 |
447 |
382 |
353 |
352 |
366 |
377 |
314 |
1034 |
564 |
<null> |
06:20:08 |
06:38:08 |
marks per second |
10 |
306 |
558 |
263 |
<null> |
276 |
292 |
389 |
348 |
377 |
338 |
382 |
348 |
394 |
407 |
363 |
414 |
1071 |
391 |
<null> |
06:38:09 |
06:56:09 |
reads/fetches*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
03:56:00 |
04:14:00 |
reads/fetches*100 |
2 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:14:01 |
04:32:01 |
reads/fetches*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:32:02 |
04:50:02 |
reads/fetches*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
04:50:03 |
05:08:03 |
reads/fetches*100 |
5 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
05:08:04 |
05:26:04 |
reads/fetches*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
<null> |
05:26:05 |
05:44:05 |
reads/fetches*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
05:44:06 |
06:02:06 |
reads/fetches*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:02:07 |
06:20:07 |
reads/fetches*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:20:08 |
06:38:08 |
reads/fetches*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<null> |
06:38:09 |
06:56:09 |
writes/marks*100 |
1 |
0 |
0 |
0 |
<null> |
0 |
1 |
0 |
<null> |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
03:56:00 |
04:14:00 |
writes/marks*100 |
2 |
1 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
04:14:01 |
04:32:01 |
writes/marks*100 |
3 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
<null> |
0 |
0 |
0 |
0 |
0 |
3 |
4 |
4 |
<null> |
04:32:02 |
04:50:02 |
writes/marks*100 |
4 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
<null> |
04:50:03 |
05:08:03 |
writes/marks*100 |
5 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
05:08:04 |
05:26:04 |
writes/marks*100 |
6 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
<null> |
4 |
0 |
<null> |
05:26:05 |
05:44:05 |
writes/marks*100 |
7 |
0 |
0 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
0 |
0 |
<null> |
<null> |
0 |
<null> |
05:44:06 |
06:02:06 |
writes/marks*100 |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
06:02:07 |
06:20:07 |
writes/marks*100 |
9 |
0 |
0 |
0 |
<null> |
0 |
<null> |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
<null> |
06:20:08 |
06:38:08 |
writes/marks*100 |
10 |
0 |
0 |
0 |
<null> |
0 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
0 |
<null> |
06:38:09 |
06:56:09 |
Done for 9720 ms, from 7:04:36.94 to 7:04:46.66.
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 |
1592944 |
1541372 |
51572 |
3.23 |
0 |
17160 |
27 |
51572 |
2016-11-21 03:55 |
2016-11-21 06:56 |
doc_list_biud |
1593340 |
1541370 |
51970 |
3.26 |
0 |
10327 |
43 |
51970 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_add_invoice_to_stock |
17508 |
11386 |
6122 |
34.96 |
78 |
205764 |
22072 |
6122 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_adding_invoice |
3585 |
2938 |
647 |
18.04 |
16 |
143910 |
5067 |
647 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_client_order |
6101 |
5801 |
300 |
4.91 |
0 |
577 |
76 |
300 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_customer_reserve |
198870 |
151508 |
47362 |
23.81 |
0 |
3011 |
138 |
47362 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_pay_from_customer |
2264 |
2249 |
15 |
0.66 |
0 |
1528 |
98 |
15 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_pay_to_supplier |
1438 |
1407 |
31 |
2.15 |
15 |
749 |
148 |
31 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_supplier_invoice |
7626 |
6282 |
1344 |
17.62 |
0 |
10686 |
2435 |
1344 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_supplier_order |
1346 |
412 |
934 |
69.39 |
765 |
419534 |
78892 |
934 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_cancel_write_off |
12253 |
9225 |
3028 |
24.71 |
0 |
6084 |
218 |
3028 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_client_order |
72547 |
72547 |
0 |
0.00 |
0 |
4774 |
1037 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_customer_reserve |
555568 |
555568 |
0 |
0.00 |
0 |
28548 |
380 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_fill_shopping_cart |
110031 |
110031 |
0 |
0.00 |
0 |
11139 |
222 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_fill_shopping_cart_clo_res |
555569 |
555569 |
0 |
0.00 |
0 |
1435 |
1 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_get_clo_for_invoice |
11387 |
11387 |
0 |
0.00 |
0 |
8814 |
1043 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_kill_cost_storno |
19264 |
15819 |
3445 |
17.88 |
0 |
5117 |
79 |
3445 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_kill_qstorno_ret_qs2qd |
417300 |
318935 |
98365 |
23.57 |
0 |
10311 |
107 |
98365 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_kill_qty_storno |
272962 |
221082 |
51880 |
19.00 |
0 |
10311 |
296 |
51880 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_lock_selected_doc |
71672 |
62538 |
9134 |
12.74 |
0 |
234 |
3 |
9134 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_make_cost_storno |
89055 |
89055 |
0 |
0.00 |
0 |
16942 |
264 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_multiply_rows_for_pdistr |
89055 |
89055 |
0 |
0.00 |
0 |
858 |
147 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_multiply_rows_for_qdistr |
72547 |
72547 |
0 |
0.00 |
0 |
4212 |
767 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_pay_from_customer |
24099 |
24099 |
0 |
0.00 |
31 |
3681 |
318 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_pay_to_supplier |
20038 |
20038 |
0 |
0.00 |
0 |
17644 |
695 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_payment_common |
44137 |
44137 |
0 |
0.00 |
0 |
8128 |
35 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_qd_handle_on_cancel_clo |
6101 |
5801 |
300 |
4.91 |
0 |
452 |
52 |
300 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_qd_handle_on_invoice_upd_sts |
14820 |
14324 |
496 |
3.34 |
0 |
8112 |
1818 |
496 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_qd_handle_on_reserve_upd_sts |
33530 |
33530 |
0 |
0.00 |
0 |
2325 |
123 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_reserve_write_off |
34449 |
33530 |
919 |
2.66 |
0 |
14336 |
327 |
919 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_supplier_invoice |
18823 |
18823 |
0 |
0.00 |
31 |
53477 |
11431 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
sp_supplier_order |
18661 |
18661 |
0 |
0.00 |
62 |
23213 |
7341 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
srv_find_qd_qs_mism |
908873 |
857349 |
51524 |
5.66 |
0 |
2840 |
2 |
51524 |
2016-11-21 03:55 |
2016-11-21 06:56 |
srv_make_invnt_saldo |
3729 |
3729 |
0 |
0.00 |
187 |
40155 |
1401 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
srv_make_money_saldo |
4263 |
4263 |
0 |
0.00 |
15 |
3729 |
62 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
2215 |
4118 |
3187 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_add_invoice_to_stock |
6122 |
6122 |
0 |
0.00 |
0 |
858 |
142 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_adding_invoice |
464 |
464 |
0 |
0.00 |
78 |
2559 |
1164 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_client_order |
300 |
300 |
0 |
0.00 |
78 |
422 |
226 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_customer_reserve |
65 |
65 |
0 |
0.00 |
63 |
265 |
131 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_pay_from_customer |
15 |
15 |
0 |
0.00 |
140 |
281 |
219 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_pay_to_supplier |
31 |
31 |
0 |
0.00 |
140 |
421 |
231 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_supplier_invoice |
501 |
501 |
0 |
0.00 |
0 |
359 |
137 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_supplier_order |
6395 |
6395 |
0 |
0.00 |
0 |
3058 |
1480 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_cancel_write_off |
61 |
61 |
0 |
0.00 |
63 |
297 |
150 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-abend:sp_reserve_write_off |
919 |
919 |
0 |
0.00 |
0 |
406 |
143 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_add_invoice_to_stock |
11458 |
11458 |
0 |
0.00 |
0 |
42354 |
10337 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_adding_invoice |
1231 |
1231 |
0 |
0.00 |
63 |
29718 |
8669 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_client_order |
5801 |
5801 |
0 |
0.00 |
0 |
811 |
251 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_customer_reserve |
2340 |
2340 |
0 |
0.00 |
0 |
780 |
276 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_pay_from_customer |
2249 |
2249 |
0 |
0.00 |
0 |
608 |
195 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_pay_to_supplier |
1407 |
1407 |
0 |
0.00 |
0 |
655 |
190 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_supplier_invoice |
920 |
920 |
0 |
0.00 |
0 |
671 |
251 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_supplier_order |
412 |
412 |
0 |
0.00 |
46 |
326765 |
46192 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_cancel_write_off |
3262 |
3262 |
0 |
0.00 |
0 |
827 |
277 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_client_order |
72548 |
72548 |
0 |
0.00 |
0 |
1217 |
333 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_customer_reserve |
3492 |
3492 |
0 |
0.00 |
0 |
748 |
185 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_pay_from_customer |
24099 |
24099 |
0 |
0.00 |
0 |
1170 |
225 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_pay_to_supplier |
20038 |
20038 |
0 |
0.00 |
0 |
749 |
225 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_reserve_write_off |
33531 |
33531 |
0 |
0.00 |
0 |
1217 |
307 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_supplier_invoice |
18832 |
18832 |
0 |
0.00 |
0 |
1295 |
333 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:sp_supplier_order |
18665 |
18665 |
0 |
0.00 |
0 |
1217 |
334 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:srv_make_invnt_saldo |
3729 |
3729 |
0 |
0.00 |
0 |
156 |
28 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:srv_make_money_saldo |
4263 |
4263 |
0 |
0.00 |
0 |
203 |
30 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
t$perf-norm:srv_recalc_idx_stat |
12 |
12 |
0 |
0.00 |
468 |
1607 |
1133 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_add_invoice_to_stock |
35016 |
22772 |
12244 |
34.96 |
0 |
422 |
5 |
12244 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_all_customers |
109200 |
109200 |
0 |
0.00 |
0 |
296 |
5 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_all_suppliers |
76942 |
76942 |
0 |
0.00 |
0 |
188 |
6 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_all_wares |
145094 |
145094 |
0 |
0.00 |
0 |
203 |
9 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_adding_invoice |
2834 |
2462 |
372 |
13.12 |
0 |
671 |
59 |
372 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_client_order |
12202 |
11602 |
600 |
4.91 |
0 |
140 |
4 |
600 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_customer_prepayment |
4528 |
4498 |
30 |
0.66 |
0 |
312 |
5 |
30 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_customer_reserve |
4810 |
4680 |
130 |
2.70 |
0 |
125 |
6 |
130 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_payment_to_supplier |
2876 |
2814 |
62 |
2.15 |
0 |
203 |
6 |
62 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_supplier_invoice |
2842 |
1840 |
1002 |
35.25 |
0 |
110 |
6 |
1002 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_supplier_order |
2692 |
824 |
1868 |
69.39 |
0 |
63 |
6 |
1868 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_cancel_write_off |
6646 |
6524 |
122 |
1.83 |
0 |
561 |
30 |
122 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_max_id_clo_ord |
18661 |
18661 |
0 |
0.00 |
0 |
1498 |
17 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_max_id_clo_res |
3491 |
3491 |
0 |
0.00 |
0 |
250 |
22 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_max_id_ord_sup |
18823 |
18823 |
0 |
0.00 |
0 |
265 |
15 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_max_non_paid_invoice |
19051 |
19051 |
0 |
0.00 |
0 |
281 |
9 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_max_non_paid_realizn |
24099 |
24099 |
0 |
0.00 |
0 |
140 |
6 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_min_id_clo_ord |
18661 |
18661 |
0 |
0.00 |
0 |
421 |
12 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_min_id_clo_res |
3491 |
3491 |
0 |
0.00 |
0 |
1046 |
10 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_min_id_ord_sup |
18823 |
18823 |
0 |
0.00 |
0 |
983 |
12 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_min_non_paid_invoice |
20038 |
20038 |
0 |
0.00 |
0 |
8112 |
27 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_min_non_paid_realizn |
24099 |
24099 |
0 |
0.00 |
0 |
234 |
5 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_our_firm |
35894 |
35894 |
0 |
0.00 |
0 |
140 |
5 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
v_reserve_write_off |
68898 |
67060 |
1838 |
2.66 |
0 |
312 |
5 |
1838 |
2016-11-21 03:55 |
2016-11-21 06:56 |
x_lock_depdocs_on_canc_invoice |
12506 |
8300 |
4206 |
33.63 |
0 |
1186 |
10 |
4206 |
2016-11-21 03:55 |
2016-11-21 06:56 |
x_lock_depdocs_on_canc_sup_ord |
1343 |
412 |
931 |
69.32 |
0 |
110 |
6 |
931 |
2016-11-21 03:55 |
2016-11-21 06:56 |
x_make_qstorno_1000_1200 |
18661 |
18661 |
0 |
0.00 |
31 |
21949 |
6772 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
x_make_qstorno_1200_2000 |
18823 |
18823 |
0 |
0.00 |
15 |
52838 |
10909 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
x_make_qstorno_2100_3300 |
555569 |
555569 |
0 |
0.00 |
0 |
28532 |
377 |
0 |
2016-11-21 03:55 |
2016-11-21 06:56 |
Done for 300920 ms, from 7:09:43.47 to 7:14:44.39.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
DTS_BEG |
DTS_END |
deadlock |
137 |
sp_kill_cost_storno |
335544336 |
2016-11-21 03:56 |
2016-11-21 06:55 |
deadlock |
7 |
sp_kill_qstorno_ret_qs2qd |
335544336 |
2016-11-21 04:04 |
2016-11-21 06:00 |
deadlock |
126 |
sp_lock_selected_doc |
335544336 |
2016-11-21 03:59 |
2016-11-21 06:55 |
deadlock |
300 |
sp_qd_handle_on_cancel_clo |
335544336 |
2016-11-21 03:56 |
2016-11-21 06:55 |
deadlock |
67 |
sp_qd_handle_on_invoice_upd_sts |
335544336 |
2016-11-21 03:57 |
2016-11-21 06:54 |
concurrent_transaction |
7570 |
sp_lock_selected_doc |
335544878 |
2016-11-21 03:56 |
2016-11-21 06:56 |
concurrent_transaction |
398 |
x_lock_depdocs_on_canc_invoice |
335544878 |
2016-11-21 03:56 |
2016-11-21 06:55 |
concurrent_transaction |
530 |
x_lock_depdocs_on_canc_sup_ord |
335544878 |
2016-11-21 03:56 |
2016-11-21 06:55 |
Done for 9430 ms, from 7:14:51.98 to 7:15:01.41.
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 341304
MON$OLDEST_ACTIVE 341305
MON$OLDEST_SNAPSHOT 341305
MON$NEXT_TRANSACTION 341305
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 2015-12-11 13:07:49.8140
MON$PAGES 697600
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.2.32630 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.2.32630 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.2.32630 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.2.32630 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 12.0
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 341644
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 341306
Oldest active 341307
Oldest snapshot 341307
Next transaction 341308
Sequence number 0
Next attachment ID 5174
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
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: 34.24, 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.05
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: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, 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.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
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: 103.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: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
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.16, total records: 1695021
Average version length: 47.75, total versions: 7081, 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: 12, data page slots: 18760
Data pages: 18760, average fill: 71%
Primary pages: 18760, secondary pages: 0, swept pages: 12909
Empty pages: 2, full pages: 9562
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 75
60 - 79% = 18679
80 - 99% = 0
Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 7788, nodes: 1695021
Average node length: 19.94, total dup: 0, max dup: 0
Average key length: 16.99, compression ratio: 1.59
Average prefix length: 13.00, average data length: 14.00
Clustering factor: 675609, ratio: 0.40
Fill distribution:
0 - 19% = 265
20 - 39% = 415
40 - 59% = 5034
60 - 79% = 1418
80 - 99% = 656
Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 6004, nodes: 1695021
Average node length: 11.60, total dup: 0, max dup: 0
Average key length: 8.66, compression ratio: 1.04
Average prefix length: 3.34, average data length: 5.66
Clustering factor: 619913, ratio: 0.37
Fill distribution:
0 - 19% = 0
20 - 39% = 2783
40 - 59% = 3221
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Root page: 161776, depth: 3, leaf buckets: 3145, nodes: 1695021
Average node length: 7.14, total dup: 1158980, max dup: 49
Average key length: 4.20, compression ratio: 2.14
Average prefix length: 7.11, average data length: 1.89
Clustering factor: 633274, ratio: 0.37
Fill distribution:
0 - 19% = 71
20 - 39% = 592
40 - 59% = 2189
60 - 79% = 80
80 - 99% = 213
DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.10, total records: 586280
Average version length: 36.32, total versions: 3179, max versions: 4
Average fragment length: 7.28, total fragments: 39, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.60
Pointer pages: 5, data page slots: 7592
Data pages: 7592, average fill: 74%
Primary pages: 7584, secondary pages: 8, swept pages: 6917
Empty pages: 1, full pages: 5193
Fill distribution:
0 - 19% = 9
20 - 39% = 2
40 - 59% = 65
60 - 79% = 7456
80 - 99% = 60
Index DOC_LIST_ID_DESC (1)
Root page: 225207, depth: 3, leaf buckets: 2232, nodes: 586280
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.07, average data length: 5.93
Clustering factor: 180821, ratio: 0.31
Fill distribution:
0 - 19% = 0
20 - 39% = 1391
40 - 59% = 841
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 637, nodes: 586280
Average node length: 4.86, total dup: 586230, max dup: 45131
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 277874, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 563
60 - 79% = 52
80 - 99% = 22
Index PK_DOC_LIST (0)
Root page: 246142, depth: 3, leaf buckets: 2119, nodes: 586280
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.08, average data length: 5.92
Clustering factor: 180821, ratio: 0.31
Fill distribution:
0 - 19% = 66
20 - 39% = 1083
40 - 59% = 891
60 - 79% = 4
80 - 99% = 75
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: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 66.66, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 19.98, total fragments: 396, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.56
Pointer pages: 3, data page slots: 1470
Data pages: 28, average fill: 25%
Primary pages: 8, secondary pages: 20, swept pages: 4
Empty pages: 11, full pages: 3
Fill distribution:
0 - 19% = 16
20 - 39% = 6
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3
Index PK_INVNT_SALDO (0)
Root page: 281, 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: 262, ratio: 0.66
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: 24.79, total records: 12817
Average version length: 71.17, total versions: 8359, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 3.87
Pointer pages: 4, data page slots: 4872
Data pages: 1341, average fill: 14%
Primary pages: 1340, secondary pages: 1, swept pages: 973
Empty pages: 499, full pages: 57
Fill distribution:
0 - 19% = 1013
20 - 39% = 225
40 - 59% = 37
60 - 79% = 21
80 - 99% = 45
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 997, depth: 2, leaf buckets: 56, nodes: 12817
Average node length: 14.52, total dup: 620, max dup: 2
Average key length: 11.99, compression ratio: 2.25
Average prefix length: 17.96, average data length: 9.04
Clustering factor: 11027, ratio: 0.86
Fill distribution:
0 - 19% = 1
20 - 39% = 27
40 - 59% = 21
60 - 79% = 6
80 - 99% = 1
MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.08, 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.12
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% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MONEY_SALDO (0)
Root page: 272, 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: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 10.43, total records: 276
Average version length: 46.88, total versions: 216, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 6.14
Pointer pages: 1, data page slots: 136
Data pages: 57, average fill: 7%
Primary pages: 57, secondary pages: 0, swept pages: 44
Empty pages: 28, full pages: 1
Fill distribution:
0 - 19% = 54
20 - 39% = 1
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 95107, depth: 2, leaf buckets: 1, nodes: 276
Average node length: 6.89, total dup: 222, max dup: 60
Average key length: 4.90, compression ratio: 3.88
Average prefix length: 16.29, average data length: 2.71
Clustering factor: 144, ratio: 0.52
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, 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: 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_GDSCODE (2)
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
Index MON_LOG_ROWSET_DESC (1)
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
Index MON_LOG_UNIT (3)
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 PK_MON_LOG (0)
Root page: 359, 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 (165)
Primary pointer page: 364, Index root page: 365
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: 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_GDSCODE (2)
Root page: 368, 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: 367, 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: 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
Index PK_MON_LOG_TABLE_STATS (0)
Root page: 366, 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.44, total records: 274060
Average version length: 30.43, total versions: 8888, max versions: 8
Average fragment length: 33.31, total fragments: 39, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.54
Pointer pages: 3, data page slots: 3824
Data pages: 3824, average fill: 55%
Primary pages: 3772, secondary pages: 52, swept pages: 3166
Empty pages: 40, full pages: 280
Fill distribution:
0 - 19% = 238
20 - 39% = 445
40 - 59% = 1224
60 - 79% = 1895
80 - 99% = 22
Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 259, nodes: 274060
Average node length: 4.67, total dup: 274011, max dup: 11187
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 39390, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 95
60 - 79% = 107
80 - 99% = 33
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 328, nodes: 274060
Average node length: 5.64, total dup: 246621, max dup: 53
Average key length: 2.98, compression ratio: 7.37
Average prefix length: 21.12, average data length: 0.88
Clustering factor: 46425, ratio: 0.17
Fill distribution:
0 - 19% = 3
20 - 39% = 38
40 - 59% = 140
60 - 79% = 105
80 - 99% = 42
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 322, nodes: 274060
Average node length: 5.64, total dup: 246621, max dup: 53
Average key length: 2.98, compression ratio: 7.38
Average prefix length: 21.12, average data length: 0.88
Clustering factor: 46584, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 38
40 - 59% = 132
60 - 79% = 103
80 - 99% = 47
Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 336, nodes: 274060
Average node length: 5.42, total dup: 246621, max dup: 53
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 46661, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 45
40 - 59% = 187
60 - 79% = 75
80 - 99% = 28
PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 257269
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: 2200
Data pages: 2200, average fill: 64%
Primary pages: 2200, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 2198
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2198
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 692033, depth: 2, leaf buckets: 201, nodes: 257269
Average node length: 4.50, total dup: 257078, max dup: 3594
Average key length: 2.00, compression ratio: 1.30
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 29609, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 58
60 - 79% = 82
80 - 99% = 61
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 (162)
Primary pointer page: 348, Index root page: 349
Total formats: 2, used formats: 2
Average record length: 147.71, total records: 9377451
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: 1440.13, compression ratio: 9.75
Pointer pages: 134, data page slots: 218040
Data pages: 218040, average fill: 87%
Primary pages: 218040, secondary pages: 0, swept pages: 3
Empty pages: 1, full pages: 218038
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 218038
Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 9527, nodes: 9377451
Average node length: 5.58, total dup: 8287837, max dup: 96
Average key length: 2.23, compression ratio: 3.58
Average prefix length: 7.81, average data length: 0.18
Clustering factor: 6123434, ratio: 0.65
Fill distribution:
0 - 19% = 17
20 - 39% = 0
40 - 59% = 3455
60 - 79% = 3814
80 - 99% = 2241
Index PERF_LOG_GDSCODE (3)
Root page: 162728, depth: 3, leaf buckets: 9000, nodes: 9377451
Average node length: 4.40, total dup: 9377446, max dup: 8955248
Average key length: 1.05, compression ratio: 0.22
Average prefix length: 0.22, average data length: 0.00
Clustering factor: 367128, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 8972
60 - 79% = 0
80 - 99% = 28
Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 10386, nodes: 9377451
Average node length: 5.59, total dup: 9074825, max dup: 13420
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 4522580, ratio: 0.48
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 6201
60 - 79% = 2323
80 - 99% = 1855
Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 10695, nodes: 9377451
Average node length: 5.44, total dup: 9332648, max dup: 1390324
Average key length: 2.09, compression ratio: 18.01
Average prefix length: 37.58, average data length: 0.09
Clustering factor: 5688048, ratio: 0.61
Fill distribution:
0 - 19% = 22
20 - 39% = 2
40 - 59% = 8371
60 - 79% = 705
80 - 99% = 1595
PHRASES (145)
Primary pointer page: 265, Index root page: 266
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: 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_NAME (2)
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 PHRASES_UNQ (1)
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
Index PK_PHRASES (0)
Root page: 276, 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.38, total records: 311301
Average version length: 55.70, total versions: 3808, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.47
Pointer pages: 3, data page slots: 3808
Data pages: 3808, average fill: 73%
Primary pages: 3808, secondary pages: 0, swept pages: 2437
Empty pages: 8, full pages: 2854
Fill distribution:
0 - 19% = 16
20 - 39% = 22
40 - 59% = 99
60 - 79% = 3655
80 - 99% = 16
Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 411, nodes: 311301
Average node length: 5.95, total dup: 258805, max dup: 452
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 33045, ratio: 0.11
Fill distribution:
0 - 19% = 8
20 - 39% = 17
40 - 59% = 248
60 - 79% = 106
80 - 99% = 32
Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 332, nodes: 311301
Average node length: 5.51, total dup: 278195, max dup: 276
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 64670, ratio: 0.21
Fill distribution:
0 - 19% = 2
20 - 39% = 6
40 - 59% = 137
60 - 79% = 133
80 - 99% = 54
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.32, 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: 81%
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.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
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 (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, 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: 358, 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 (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 54.32, total records: 2843
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: 136.00, compression ratio: 2.50
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 62%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 33
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 33
80 - 99% = 0
WARES (144)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 77.53, 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.78
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
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: 374, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 64
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: 273, 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: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_ID_DESC (2)
Root page: 275, 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: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index WARES_NUMB_UNQ (1)
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 52.95, total dup: 0, max dup: 0
Average key length: 51.92, compression ratio: 0.99
Average prefix length: 2.65, average data length: 48.95
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2
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 (259)
Primary pointer page: 254, Index root page: 284
Total formats: 1, used formats: 1
Average record length: 24.31, total records: 6743
Average version length: 72.06, total versions: 4468, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 5.60
Pointer pages: 5, data page slots: 4648
Data pages: 664, average fill: 14%
Primary pages: 663, secondary pages: 1, swept pages: 497
Empty pages: 371, full pages: 15
Fill distribution:
0 - 19% = 498
20 - 39% = 69
40 - 59% = 57
60 - 79% = 32
80 - 99% = 8
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1235, depth: 2, leaf buckets: 15, nodes: 6743
Average node length: 7.48, total dup: 5833, max dup: 14
Average key length: 4.66, compression ratio: 7.95
Average prefix length: 34.48, average data length: 2.52
Clustering factor: 1156, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 6
60 - 79% = 2
80 - 99% = 0
XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 70.65, total records: 1368196
Average version length: 71.75, total versions: 28800, 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: 14, data page slots: 21960
Data pages: 21960, average fill: 69%
Primary pages: 21960, secondary pages: 0, swept pages: 13969
Empty pages: 28, full pages: 11734
Fill distribution:
0 - 19% = 97
20 - 39% = 507
40 - 59% = 2911
60 - 79% = 18296
80 - 99% = 149
Index XQD_1000_3300_DOC (1)
Root page: 190263, depth: 3, leaf buckets: 1780, nodes: 1368196
Average node length: 5.15, total dup: 1332557, max dup: 120
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 303151, ratio: 0.22
Fill distribution:
0 - 19% = 37
20 - 39% = 114
40 - 59% = 1515
60 - 79% = 93
80 - 99% = 21
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 118663, depth: 3, leaf buckets: 2041, nodes: 1368196
Average node length: 6.28, total dup: 1193784, max dup: 29
Average key length: 3.33, compression ratio: 11.11
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 376714, ratio: 0.28
Fill distribution:
0 - 19% = 24
20 - 39% = 212
40 - 59% = 1558
60 - 79% = 136
80 - 99% = 111
XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 23.08, total records: 44921
Average version length: 71.95, total versions: 30497, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 5.89
Pointer pages: 8, data page slots: 8888
Data pages: 3104, average fill: 19%
Primary pages: 3102, secondary pages: 2, swept pages: 2227
Empty pages: 1555, full pages: 366
Fill distribution:
0 - 19% = 2152
20 - 39% = 336
40 - 59% = 168
60 - 79% = 240
80 - 99% = 208
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 120421, depth: 3, leaf buckets: 97, nodes: 44921
Average node length: 6.63, total dup: 38499, max dup: 49
Average key length: 3.76, compression ratio: 9.84
Average prefix length: 35.38, average data length: 1.62
Clustering factor: 8793, ratio: 0.20
Fill distribution:
0 - 19% = 2
20 - 39% = 61
40 - 59% = 26
60 - 79% = 7
80 - 99% = 1
XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 66.83, total records: 1576402
Average version length: 72.03, total versions: 116976, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.03
Pointer pages: 20, data page slots: 32584
Data pages: 32559, average fill: 55%
Primary pages: 32559, secondary pages: 0, swept pages: 22634
Empty pages: 247, full pages: 5947
Fill distribution:
0 - 19% = 1229
20 - 39% = 5500
40 - 59% = 11161
60 - 79% = 13574
80 - 99% = 1095
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 109591, depth: 3, leaf buckets: 2496, nodes: 1576402
Average node length: 5.62, total dup: 1481278, max dup: 99
Average key length: 2.66, compression ratio: 13.91
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 456112, ratio: 0.29
Fill distribution:
0 - 19% = 24
20 - 39% = 1165
40 - 59% = 918
60 - 79% = 262
80 - 99% = 127
XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 13.00, total records: 23528
Average version length: 71.53, total versions: 19108, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 10.46
Pointer pages: 5, data page slots: 7696
Data pages: 2222, average fill: 14%
Primary pages: 2222, secondary pages: 0, swept pages: 1513
Empty pages: 1322, full pages: 125
Fill distribution:
0 - 19% = 1680
20 - 39% = 219
40 - 59% = 135
60 - 79% = 98
80 - 99% = 90
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 50, nodes: 23528
Average node length: 6.74, total dup: 20287, max dup: 65
Average key length: 3.95, compression ratio: 9.37
Average prefix length: 35.19, average data length: 1.81
Clustering factor: 3695, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 13
60 - 79% = 6
80 - 99% = 1
XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 70.01, total records: 2150428
Average version length: 71.01, total versions: 47250, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.94
Pointer pages: 20, data page slots: 32416
Data pages: 32416, average fill: 73%
Primary pages: 32416, secondary pages: 0, swept pages: 23266
Empty pages: 18, full pages: 20138
Fill distribution:
0 - 19% = 68
20 - 39% = 129
40 - 59% = 1695
60 - 79% = 29591
80 - 99% = 933
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4615, nodes: 2150428
Average node length: 6.97, total dup: 1718454, max dup: 25
Average key length: 4.00, compression ratio: 9.24
Average prefix length: 35.20, average data length: 1.80
Clustering factor: 605689, ratio: 0.28
Fill distribution:
0 - 19% = 4
20 - 39% = 2732
40 - 59% = 1570
60 - 79% = 194
80 - 99% = 115
XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.75, total records: 3810397
Average version length: 84.17, total versions: 18462, 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: 37, data page slots: 59576
Data pages: 59576, average fill: 79%
Primary pages: 59576, secondary pages: 0, swept pages: 29621
Empty pages: 10, full pages: 57480
Fill distribution:
0 - 19% = 11
20 - 39% = 4
40 - 59% = 67
60 - 79% = 28357
80 - 99% = 31137
Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3728, nodes: 3810397
Average node length: 5.16, total dup: 3722220, max dup: 132
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 878006, ratio: 0.23
Fill distribution:
0 - 19% = 11
20 - 39% = 50
40 - 59% = 1430
60 - 79% = 1515
80 - 99% = 722
Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 5067, nodes: 3810397
Average node length: 5.65, total dup: 3435311, max dup: 49
Average key length: 2.67, compression ratio: 3.37
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 591932, ratio: 0.16
Fill distribution:
0 - 19% = 55
20 - 39% = 154
40 - 59% = 4004
60 - 79% = 378
80 - 99% = 476
Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4206, nodes: 3810397
Average node length: 5.79, total dup: 3332810, max dup: 29
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 927937, ratio: 0.24
Fill distribution:
0 - 19% = 8
20 - 39% = 87
40 - 59% = 1728
60 - 79% = 1479
80 - 99% = 904
XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 81.25, total records: 1553857
Average version length: 83.16, total versions: 36220, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.67
Pointer pages: 16, data page slots: 25152
Data pages: 25152, average fill: 76%
Primary pages: 25152, secondary pages: 0, swept pages: 17092
Empty pages: 15, full pages: 20194
Fill distribution:
0 - 19% = 58
20 - 39% = 115
40 - 59% = 839
60 - 79% = 14733
80 - 99% = 9407
Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1712, nodes: 1553857
Average node length: 5.14, total dup: 1517263, max dup: 221
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 323475, ratio: 0.21
Fill distribution:
0 - 19% = 2
20 - 39% = 28
40 - 59% = 1070
60 - 79% = 488
80 - 99% = 124
Index XQS_1000_3300_RCV_ID (2)
Root page: 128018, depth: 3, leaf buckets: 3005, nodes: 1553857
Average node length: 6.29, total dup: 1260461, max dup: 14
Average key length: 3.33, compression ratio: 2.70
Average prefix length: 7.86, average data length: 1.14
Clustering factor: 239164, ratio: 0.15
Fill distribution:
0 - 19% = 53
20 - 39% = 1669
40 - 59% = 1018
60 - 79% = 216
80 - 99% = 49
Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1911, nodes: 1553857
Average node length: 5.78, total dup: 1362060, max dup: 44
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 349417, ratio: 0.22
Fill distribution:
0 - 19% = 5
20 - 39% = 36
40 - 59% = 1158
60 - 79% = 557
80 - 99% = 155
XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 81.95, total records: 4158725
Average version length: 85.33, total versions: 112828, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 43, data page slots: 68688
Data pages: 68680, average fill: 76%
Primary pages: 68680, secondary pages: 0, swept pages: 33810
Empty pages: 32, full pages: 52426
Fill distribution:
0 - 19% = 72
20 - 39% = 536
40 - 59% = 3636
60 - 79% = 38053
80 - 99% = 26383
Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4704, nodes: 4158725
Average node length: 5.04, total dup: 4134785, max dup: 572
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1105128, ratio: 0.27
Fill distribution:
0 - 19% = 5
20 - 39% = 404
40 - 59% = 2945
60 - 79% = 1104
80 - 99% = 246
Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5866, nodes: 4158725
Average node length: 5.49, total dup: 3852973, max dup: 49
Average key length: 2.51, compression ratio: 3.59
Average prefix length: 8.56, average data length: 0.44
Clustering factor: 856762, ratio: 0.21
Fill distribution:
0 - 19% = 50
20 - 39% = 2072
40 - 59% = 2752
60 - 79% = 454
80 - 99% = 538
Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5231, nodes: 4158725
Average node length: 5.62, total dup: 3768165, max dup: 94
Average key length: 2.64, compression ratio: 3.41
Average prefix length: 8.45, average data length: 0.55
Clustering factor: 1170987, ratio: 0.28
Fill distribution:
0 - 19% = 5
20 - 39% = 367
40 - 59% = 3405
60 - 79% = 1129
80 - 99% = 325
XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
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: 760, 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: 762, 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: 761, 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 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 82.42, total records: 2628535
Average version length: 84.31, total versions: 46484, 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: 27, data page slots: 42904
Data pages: 42904, average fill: 76%
Primary pages: 42904, secondary pages: 0, swept pages: 29358
Empty pages: 11, full pages: 33208
Fill distribution:
0 - 19% = 65
20 - 39% = 104
40 - 59% = 1088
60 - 79% = 27142
80 - 99% = 14505
Index XQS_2100_3300_DOC_ID (0)
Root page: 93547, depth: 3, leaf buckets: 2885, nodes: 2628535
Average node length: 5.02, total dup: 2615234, max dup: 1007
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 691899, ratio: 0.26
Fill distribution:
0 - 19% = 17
20 - 39% = 399
40 - 59% = 1406
60 - 79% = 742
80 - 99% = 321
Index XQS_2100_3300_RCV_ID (2)
Root page: 94425, depth: 3, leaf buckets: 5352, nodes: 2628535
Average node length: 6.32, total dup: 2125445, max dup: 14
Average key length: 3.34, compression ratio: 2.69
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 564214, ratio: 0.21
Fill distribution:
0 - 19% = 194
20 - 39% = 3087
40 - 59% = 1755
60 - 79% = 228
80 - 99% = 88
Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3093, nodes: 2628535
Average node length: 5.54, total dup: 2415042, max dup: 92
Average key length: 2.57, compression ratio: 3.51
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 725461, ratio: 0.28
Fill distribution:
0 - 19% = 6
20 - 39% = 298
40 - 59% = 1520
60 - 79% = 940
80 - 99% = 329
XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 488790
Average version length: 69.30, total versions: 9917, 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: 5, data page slots: 6992
Data pages: 6992, average fill: 74%
Primary pages: 6992, secondary pages: 0, swept pages: 5064
Empty pages: 4, full pages: 5826
Fill distribution:
0 - 19% = 30
20 - 39% = 117
40 - 59% = 305
60 - 79% = 6313
80 - 99% = 227
Index XQS_3300_3400_DOC_ID (0)
Root page: 351663, depth: 3, leaf buckets: 544, nodes: 488790
Average node length: 5.38, total dup: 454820, max dup: 133
Average key length: 2.53, compression ratio: 3.55
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 45257, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 48
40 - 59% = 240
60 - 79% = 185
80 - 99% = 70
Index XQS_3300_3400_SND_ID (1)
Root page: 207397, depth: 3, leaf buckets: 606, nodes: 488790
Average node length: 5.94, total dup: 415288, max dup: 29
Average key length: 3.10, compression ratio: 2.90
Average prefix length: 8.05, average data length: 0.95
Clustering factor: 52056, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 52
40 - 59% = 278
60 - 79% = 207
80 - 99% = 67
ZDOC_DATA (229)
Primary pointer page: 632, Index root page: 633
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 (228)
Primary pointer page: 630, Index root page: 631
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 (230)
Primary pointer page: 634, Index root page: 635
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 (233)
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
Index ZPDISTR_ID (0)
Root page: 650, 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 (234)
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
Index ZPSTORNED_ID (0)
Root page: 651, 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 (231)
Primary pointer page: 636, Index root page: 637
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: 644, 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: 645, 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 (232)
Primary pointer page: 638, Index root page: 639
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: 647, 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: 646, 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: 649, 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: 648, 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 (227)
Primary pointer page: 628, Index root page: 629
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 (226)
Primary pointer page: 625, Index root page: 626
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: 267, Index root page: 268
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: 280, 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
Done for 111910 ms, from 7:15:01.77 to 7:16:53.68.
TABLE_NAME |
TOTAL_RECS |
TOTAL_VERS |
VERS_PERCENT |
AGENTS |
50 |
0 |
0.0000 |
BUSINESS_OPS |
19 |
0 |
0.0000 |
DOC_DATA |
1695021 |
7081 |
0.4177 |
DOC_LIST |
586280 |
3179 |
0.5422 |
DOC_STATES |
4 |
0 |
0.0000 |
FB_ERRORS |
758 |
0 |
0.0000 |
INVNT_SALDO |
400 |
0 |
0.0000 |
INVNT_TURNOVER_LOG |
12817 |
8359 |
65.2180 |
MONEY_SALDO |
49 |
0 |
0.0000 |
MONEY_TURNOVER_LOG |
276 |
216 |
78.2608 |
OPTYPES |
9 |
0 |
0.0000 |
PDISTR |
274060 |
8888 |
3.2430 |
PERF_ESTIMATED |
257269 |
0 |
0.0000 |
PERF_LOG |
9377451 |
0 |
0.0000 |
PSTORNED |
311301 |
3808 |
1.2232 |
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 |
2843 |
0 |
0.0000 |
WARES |
400 |
0 |
0.0000 |
WARE_GROUPS |
8 |
0 |
0.0000 |
XQD_1000_1200 |
6743 |
4468 |
66.2613 |
XQD_1000_3300 |
1368196 |
28800 |
2.1049 |
XQD_1200_2000 |
44921 |
30497 |
67.8902 |
XQD_2000_3300 |
1576402 |
116976 |
7.4204 |
XQD_2100_3300 |
23528 |
19108 |
81.2138 |
XQD_3300_3400 |
2150428 |
47250 |
2.1972 |
XQS_1000_1200 |
3810397 |
18462 |
0.4845 |
XQS_1000_3300 |
1553857 |
36220 |
2.3309 |
XQS_1200_2000 |
4158725 |
112828 |
2.7130 |
XQS_2100_3300 |
2628535 |
46484 |
1.7684 |
XQS_3300_3400 |
488790 |
9917 |
2.0288 |
Z_USED_VIEWS |
29 |
0 |
0.0000 |
Done for 2190 ms, from 7:17:05.64 to 7:17:07.83.
07:17:07.90 Validation started
07:17:07.92 Relation 140 (DOC_LIST)
07:17:07.92 process pointer page 0 of 5
07:17:08.00 process pointer page 1 of 5
07:17:08.09 process pointer page 2 of 5
07:17:08.20 process pointer page 3 of 5
07:17:08.31 process pointer page 4 of 5
07:17:08.37 Index 1 (PK_DOC_LIST)
07:17:08.64 Index 2 (DOC_LIST_ID_DESC)
07:17:08.90 Index 3 (FK_DOC_LIST_AGENTS)
07:17:09.15 Relation 140 (DOC_LIST) is ok
07:17:09.15 Relation 141 (DOC_DATA)
07:17:09.15 process pointer page 0 of 12
07:17:09.25 process pointer page 1 of 12
07:17:09.31 process pointer page 2 of 12
07:17:09.35 process pointer page 3 of 12
07:17:09.45 process pointer page 4 of 12
07:17:09.54 process pointer page 5 of 12
07:17:09.64 process pointer page 6 of 12
07:17:09.73 process pointer page 7 of 12
07:17:09.81 process pointer page 8 of 12
07:17:09.90 process pointer page 9 of 12
07:17:09.99 process pointer page 10 of 12
07:17:10.09 process pointer page 11 of 12
07:17:10.10 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:17:10.95 Index 3 (DOC_DATA_ID_DESC)
07:17:11.76 Index 4 (FK_DOC_DATA_DOC_LIST)
07:17:12.43 Relation 141 (DOC_DATA) is ok
07:17:12.43 Relation 147 (INVNT_SALDO)
07:17:12.43 process pointer page 0 of 3
07:17:12.43 process pointer page 1 of 3
07:17:12.43 process pointer page 2 of 3
07:17:12.43 Index 1 (PK_INVNT_SALDO)
07:17:12.43 Relation 147 (INVNT_SALDO) is ok
07:17:12.43 Relation 150 (PDISTR)
07:17:12.43 process pointer page 0 of 3
07:17:12.51 process pointer page 1 of 3
07:17:12.54 process pointer page 2 of 3
07:17:12.55 Index 2 (PDISTR_SND_ID)
07:17:12.65 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:17:12.71 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:17:12.76 Index 5 (PDISTR_AGENT_ID)
07:17:12.79 Relation 150 (PDISTR) is ok
07:17:12.79 Relation 151 (PSTORNED)
07:17:12.79 process pointer page 0 of 3
07:17:12.83 process pointer page 1 of 3
07:17:12.93 process pointer page 2 of 3
07:17:12.94 Index 2 (PSTORNED_SND_ID)
07:17:13.05 Index 3 (PSTORNED_RCV_ID)
07:17:13.15 Relation 151 (PSTORNED) is ok
07:17:13.15 Relation 156 (SEMAPHORES)
07:17:13.15 process pointer page 0 of 1
07:17:13.15 Index 1 (PK_SEMAPHORES)
07:17:13.15 Index 2 (SEMAPHORES_TASK_UNQ)
07:17:13.15 Relation 156 (SEMAPHORES) is ok
07:17:13.15 Relation 157 (INVNT_TURNOVER_LOG)
07:17:13.15 process pointer page 0 of 4
07:17:13.18 process pointer page 1 of 4
07:17:13.18 process pointer page 2 of 4
07:17:13.19 process pointer page 3 of 4
07:17:13.21 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:17:13.21 Relation 157 (INVNT_TURNOVER_LOG) is ok
07:17:13.21 Relation 160 (PERF_ESTIMATED)
07:17:13.21 process pointer page 0 of 2
07:17:13.30 process pointer page 1 of 2
07:17:13.33 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:17:13.41 Relation 160 (PERF_ESTIMATED) is ok
07:17:13.41 Relation 161 (PERF_ISQL_STAT)
07:17:13.41 process pointer page 0 of 1
07:17:13.41 Index 1 (PERF_ISQL_STAT_TRN)
07:17:13.41 Relation 161 (PERF_ISQL_STAT) is ok
07:17:13.41 Relation 162 (PERF_LOG)
07:17:13.41 process pointer page 0 of 134
07:17:13.49 process pointer page 1 of 134
07:17:13.57 process pointer page 2 of 134
07:17:13.64 process pointer page 3 of 134
07:17:13.72 process pointer page 4 of 134
07:17:13.80 process pointer page 5 of 134
07:17:13.88 process pointer page 6 of 134
07:17:13.96 process pointer page 7 of 134
07:17:14.03 process pointer page 8 of 134
07:17:14.11 process pointer page 9 of 134
07:17:14.14 process pointer page 10 of 134
07:17:14.21 process pointer page 11 of 134
07:17:14.28 process pointer page 12 of 134
07:17:14.36 process pointer page 13 of 134
07:17:14.39 process pointer page 14 of 134
07:17:14.44 process pointer page 15 of 134
07:17:14.52 process pointer page 16 of 134
07:17:14.60 process pointer page 17 of 134
07:17:14.67 process pointer page 18 of 134
07:17:14.75 process pointer page 19 of 134
07:17:14.83 process pointer page 20 of 134
07:17:14.91 process pointer page 21 of 134
07:17:14.99 process pointer page 22 of 134
07:17:15.06 process pointer page 23 of 134
07:17:15.13 process pointer page 24 of 134
07:17:15.20 process pointer page 25 of 134
07:17:15.28 process pointer page 26 of 134
07:17:15.36 process pointer page 27 of 134
07:17:15.44 process pointer page 28 of 134
07:17:15.52 process pointer page 29 of 134
07:17:15.59 process pointer page 30 of 134
07:17:15.67 process pointer page 31 of 134
07:17:15.75 process pointer page 32 of 134
07:17:15.81 process pointer page 33 of 134
07:17:15.84 process pointer page 34 of 134
07:17:15.88 process pointer page 35 of 134
07:17:15.91 process pointer page 36 of 134
07:17:15.98 process pointer page 37 of 134
07:17:16.03 process pointer page 38 of 134
07:17:16.08 process pointer page 39 of 134
07:17:16.16 process pointer page 40 of 134
07:17:16.23 process pointer page 41 of 134
07:17:16.31 process pointer page 42 of 134
07:17:16.39 process pointer page 43 of 134
07:17:16.47 process pointer page 44 of 134
07:17:16.55 process pointer page 45 of 134
07:17:16.62 process pointer page 46 of 134
07:17:16.70 process pointer page 47 of 134
07:17:16.78 process pointer page 48 of 134
07:17:16.86 process pointer page 49 of 134
07:17:16.94 process pointer page 50 of 134
07:17:17.01 process pointer page 51 of 134
07:17:17.09 process pointer page 52 of 134
07:17:17.15 process pointer page 53 of 134
07:17:17.19 process pointer page 54 of 134
07:17:17.23 process pointer page 55 of 134
07:17:17.31 process pointer page 56 of 134
07:17:17.39 process pointer page 57 of 134
07:17:17.47 process pointer page 58 of 134
07:17:17.54 process pointer page 59 of 134
07:17:17.61 process pointer page 60 of 134
07:17:17.64 process pointer page 61 of 134
07:17:17.67 process pointer page 62 of 134
07:17:17.70 process pointer page 63 of 134
07:17:17.78 process pointer page 64 of 134
07:17:17.84 process pointer page 65 of 134
07:17:17.92 process pointer page 66 of 134
07:17:18.00 process pointer page 67 of 134
07:17:18.07 process pointer page 68 of 134
07:17:18.15 process pointer page 69 of 134
07:17:18.23 process pointer page 70 of 134
07:17:18.31 process pointer page 71 of 134
07:17:18.39 process pointer page 72 of 134
07:17:18.46 process pointer page 73 of 134
07:17:18.54 process pointer page 74 of 134
07:17:18.62 process pointer page 75 of 134
07:17:18.70 process pointer page 76 of 134
07:17:18.78 process pointer page 77 of 134
07:17:18.85 process pointer page 78 of 134
07:17:18.93 process pointer page 79 of 134
07:17:19.01 process pointer page 80 of 134
07:17:19.03 process pointer page 81 of 134
07:17:19.09 process pointer page 82 of 134
07:17:19.17 process pointer page 83 of 134
07:17:19.24 process pointer page 84 of 134
07:17:19.32 process pointer page 85 of 134
07:17:19.39 process pointer page 86 of 134
07:17:19.46 process pointer page 87 of 134
07:17:19.54 process pointer page 88 of 134
07:17:19.62 process pointer page 89 of 134
07:17:19.70 process pointer page 90 of 134
07:17:19.78 process pointer page 91 of 134
07:17:19.85 process pointer page 92 of 134
07:17:19.93 process pointer page 93 of 134
07:17:20.01 process pointer page 94 of 134
07:17:20.09 process pointer page 95 of 134
07:17:20.17 process pointer page 96 of 134
07:17:20.24 process pointer page 97 of 134
07:17:20.32 process pointer page 98 of 134
07:17:20.40 process pointer page 99 of 134
07:17:20.46 process pointer page 100 of 134
07:17:20.54 process pointer page 101 of 134
07:17:20.62 process pointer page 102 of 134
07:17:20.70 process pointer page 103 of 134
07:17:20.77 process pointer page 104 of 134
07:17:20.85 process pointer page 105 of 134
07:17:20.93 process pointer page 106 of 134
07:17:21.01 process pointer page 107 of 134
07:17:21.09 process pointer page 108 of 134
07:17:21.16 process pointer page 109 of 134
07:17:21.24 process pointer page 110 of 134
07:17:21.32 process pointer page 111 of 134
07:17:21.40 process pointer page 112 of 134
07:17:21.48 process pointer page 113 of 134
07:17:21.55 process pointer page 114 of 134
07:17:21.63 process pointer page 115 of 134
07:17:21.71 process pointer page 116 of 134
07:17:21.79 process pointer page 117 of 134
07:17:21.85 process pointer page 118 of 134
07:17:21.93 process pointer page 119 of 134
07:17:22.01 process pointer page 120 of 134
07:17:22.08 process pointer page 121 of 134
07:17:22.16 process pointer page 122 of 134
07:17:22.24 process pointer page 123 of 134
07:17:22.32 process pointer page 124 of 134
07:17:22.40 process pointer page 125 of 134
07:17:22.47 process pointer page 126 of 134
07:17:22.55 process pointer page 127 of 134
07:17:22.63 process pointer page 128 of 134
07:17:22.71 process pointer page 129 of 134
07:17:22.79 process pointer page 130 of 134
07:17:22.83 process pointer page 131 of 134
07:17:22.86 process pointer page 132 of 134
07:17:22.90 process pointer page 133 of 134
07:17:22.91 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:17:27.50 Index 2 (PERF_LOG_UNIT)
07:17:32.77 Index 3 (PERF_LOG_TRN_DESC)
07:17:36.62 Index 4 (PERF_LOG_GDSCODE)
07:17:38.71 Relation 162 (PERF_LOG) is ok
07:17:38.71 Relation 166 (V_STOPTEST)
07:17:38.71 Relation 166 (V_STOPTEST) is ok
07:17:38.71 Relation 183 (V_QDISTR_SOURCE)
07:17:38.71 Relation 183 (V_QDISTR_SOURCE) is ok
07:17:38.71 Relation 184 (V_QSTORNED_SOURCE)
07:17:38.71 Relation 184 (V_QSTORNED_SOURCE) is ok
07:17:38.71 Relation 259 (XQD_1000_1200)
07:17:38.73 process pointer page 0 of 5
07:17:38.73 process pointer page 1 of 5
07:17:38.74 process pointer page 2 of 5
07:17:38.74 process pointer page 3 of 5
07:17:38.74 process pointer page 4 of 5
07:17:38.74 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:17:38.76 Relation 259 (XQD_1000_1200) is ok
07:17:38.76 Relation 260 (XQD_1200_2000)
07:17:38.76 process pointer page 0 of 8
07:17:38.79 process pointer page 1 of 8
07:17:38.84 process pointer page 2 of 8
07:17:38.85 process pointer page 3 of 8
07:17:38.90 process pointer page 4 of 8
07:17:38.92 process pointer page 5 of 8
07:17:38.92 process pointer page 6 of 8
07:17:38.92 process pointer page 7 of 8
07:17:38.92 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:17:38.93 Relation 260 (XQD_1200_2000) is ok
07:17:38.93 Relation 261 (XQD_1000_3300)
07:17:38.93 process pointer page 0 of 14
07:17:39.03 process pointer page 1 of 14
07:17:39.10 process pointer page 2 of 14
07:17:39.20 process pointer page 3 of 14
07:17:39.26 process pointer page 4 of 14
07:17:39.29 process pointer page 5 of 14
07:17:39.34 process pointer page 6 of 14
07:17:39.40 process pointer page 7 of 14
07:17:39.48 process pointer page 8 of 14
07:17:39.57 process pointer page 9 of 14
07:17:39.67 process pointer page 10 of 14
07:17:39.74 process pointer page 11 of 14
07:17:39.84 process pointer page 12 of 14
07:17:39.91 process pointer page 13 of 14
07:17:39.96 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:17:40.55 Index 2 (XQD_1000_3300_DOC)
07:17:41.02 Relation 261 (XQD_1000_3300) is ok
07:17:41.02 Relation 262 (XQD_2000_3300)
07:17:41.02 process pointer page 0 of 20
07:17:41.12 process pointer page 1 of 20
07:17:41.21 process pointer page 2 of 20
07:17:41.29 process pointer page 3 of 20
07:17:41.38 process pointer page 4 of 20
07:17:41.47 process pointer page 5 of 20
07:17:41.57 process pointer page 6 of 20
07:17:41.66 process pointer page 7 of 20
07:17:41.76 process pointer page 8 of 20
07:17:41.83 process pointer page 9 of 20
07:17:41.93 process pointer page 10 of 20
07:17:42.01 process pointer page 11 of 20
07:17:42.08 process pointer page 12 of 20
07:17:42.16 process pointer page 13 of 20
07:17:42.24 process pointer page 14 of 20
07:17:42.33 process pointer page 15 of 20
07:17:42.41 process pointer page 16 of 20
07:17:42.50 process pointer page 17 of 20
07:17:42.60 process pointer page 18 of 20
07:17:42.66 process pointer page 19 of 20
07:17:42.69 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:17:43.33 Relation 262 (XQD_2000_3300) is ok
07:17:43.33 Relation 263 (XQD_2100_3300)
07:17:43.33 process pointer page 0 of 5
07:17:43.35 process pointer page 1 of 5
07:17:43.38 process pointer page 2 of 5
07:17:43.39 process pointer page 3 of 5
07:17:43.39 process pointer page 4 of 5
07:17:43.44 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:17:43.44 Relation 263 (XQD_2100_3300) is ok
07:17:43.44 Relation 264 (XQD_3300_3400)
07:17:43.44 process pointer page 0 of 20
07:17:43.49 process pointer page 1 of 20
07:17:43.52 process pointer page 2 of 20
07:17:43.55 process pointer page 3 of 20
07:17:43.60 process pointer page 4 of 20
07:17:43.66 process pointer page 5 of 20
07:17:43.75 process pointer page 6 of 20
07:17:43.85 process pointer page 7 of 20
07:17:43.92 process pointer page 8 of 20
07:17:44.02 process pointer page 9 of 20
07:17:44.11 process pointer page 10 of 20
07:17:44.20 process pointer page 11 of 20
07:17:44.28 process pointer page 12 of 20
07:17:44.38 process pointer page 13 of 20
07:17:44.47 process pointer page 14 of 20
07:17:44.56 process pointer page 15 of 20
07:17:44.64 process pointer page 16 of 20
07:17:44.74 process pointer page 17 of 20
07:17:44.83 process pointer page 18 of 20
07:17:44.91 process pointer page 19 of 20
07:17:44.98 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:17:45.76 Relation 264 (XQD_3300_3400) is ok
07:17:45.76 Relation 265 (XQS_1000_1200)
07:17:45.76 process pointer page 0 of 37
07:17:45.81 process pointer page 1 of 37
07:17:45.91 process pointer page 2 of 37
07:17:46.00 process pointer page 3 of 37
07:17:46.08 process pointer page 4 of 37
07:17:46.17 process pointer page 5 of 37
07:17:46.26 process pointer page 6 of 37
07:17:46.36 process pointer page 7 of 37
07:17:46.44 process pointer page 8 of 37
07:17:46.53 process pointer page 9 of 37
07:17:46.62 process pointer page 10 of 37
07:17:46.70 process pointer page 11 of 37
07:17:46.79 process pointer page 12 of 37
07:17:46.89 process pointer page 13 of 37
07:17:46.97 process pointer page 14 of 37
07:17:47.06 process pointer page 15 of 37
07:17:47.14 process pointer page 16 of 37
07:17:47.23 process pointer page 17 of 37
07:17:47.32 process pointer page 18 of 37
07:17:47.40 process pointer page 19 of 37
07:17:47.50 process pointer page 20 of 37
07:17:47.53 process pointer page 21 of 37
07:17:47.59 process pointer page 22 of 37
07:17:47.68 process pointer page 23 of 37
07:17:47.76 process pointer page 24 of 37
07:17:47.86 process pointer page 25 of 37
07:17:47.95 process pointer page 26 of 37
07:17:48.03 process pointer page 27 of 37
07:17:48.12 process pointer page 28 of 37
07:17:48.20 process pointer page 29 of 37
07:17:48.29 process pointer page 30 of 37
07:17:48.32 process pointer page 31 of 37
07:17:48.39 process pointer page 32 of 37
07:17:48.48 process pointer page 33 of 37
07:17:48.56 process pointer page 34 of 37
07:17:48.62 process pointer page 35 of 37
07:17:48.65 process pointer page 36 of 37
07:17:48.68 Index 1 (XQS_1000_1200_DOC_ID)
07:17:49.93 Index 2 (XQS_1000_1200_SND_ID)
07:17:51.22 Index 3 (XQS_1000_1200_RCV_ID)
07:17:52.38 Relation 265 (XQS_1000_1200) is ok
07:17:52.38 Relation 266 (XQS_1200_2000)
07:17:52.38 process pointer page 0 of 43
07:17:52.47 process pointer page 1 of 43
07:17:52.57 process pointer page 2 of 43
07:17:52.60 process pointer page 3 of 43
07:17:52.66 process pointer page 4 of 43
07:17:52.69 process pointer page 5 of 43
07:17:52.77 process pointer page 6 of 43
07:17:52.86 process pointer page 7 of 43
07:17:52.96 process pointer page 8 of 43
07:17:53.05 process pointer page 9 of 43
07:17:53.14 process pointer page 10 of 43
07:17:53.24 process pointer page 11 of 43
07:17:53.33 process pointer page 12 of 43
07:17:53.41 process pointer page 13 of 43
07:17:53.50 process pointer page 14 of 43
07:17:53.60 process pointer page 15 of 43
07:17:53.69 process pointer page 16 of 43
07:17:53.77 process pointer page 17 of 43
07:17:53.80 process pointer page 18 of 43
07:17:53.89 process pointer page 19 of 43
07:17:53.97 process pointer page 20 of 43
07:17:54.06 process pointer page 21 of 43
07:17:54.16 process pointer page 22 of 43
07:17:54.25 process pointer page 23 of 43
07:17:54.34 process pointer page 24 of 43
07:17:54.44 process pointer page 25 of 43
07:17:54.52 process pointer page 26 of 43
07:17:54.61 process pointer page 27 of 43
07:17:54.70 process pointer page 28 of 43
07:17:54.80 process pointer page 29 of 43
07:17:54.89 process pointer page 30 of 43
07:17:54.98 process pointer page 31 of 43
07:17:55.08 process pointer page 32 of 43
07:17:55.17 process pointer page 33 of 43
07:17:55.27 process pointer page 34 of 43
07:17:55.36 process pointer page 35 of 43
07:17:55.44 process pointer page 36 of 43
07:17:55.53 process pointer page 37 of 43
07:17:55.62 process pointer page 38 of 43
07:17:55.72 process pointer page 39 of 43
07:17:55.81 process pointer page 40 of 43
07:17:55.89 process pointer page 41 of 43
07:17:55.98 process pointer page 42 of 43
07:17:55.98 Index 1 (XQS_1200_2000_DOC_ID)
07:17:57.59 Index 2 (XQS_1200_2000_SND_ID)
07:17:59.02 Index 3 (XQS_1200_2000_RCV_ID)
07:18:00.38 Relation 266 (XQS_1200_2000) is ok
07:18:00.38 Relation 267 (XQS_1000_3300)
07:18:00.38 process pointer page 0 of 16
07:18:00.48 process pointer page 1 of 16
07:18:00.57 process pointer page 2 of 16
07:18:00.66 process pointer page 3 of 16
07:18:00.76 process pointer page 4 of 16
07:18:00.85 process pointer page 5 of 16
07:18:00.94 process pointer page 6 of 16
07:18:01.02 process pointer page 7 of 16
07:18:01.12 process pointer page 8 of 16
07:18:01.22 process pointer page 9 of 16
07:18:01.32 process pointer page 10 of 16
07:18:01.43 process pointer page 11 of 16
07:18:01.54 process pointer page 12 of 16
07:18:01.63 process pointer page 13 of 16
07:18:01.74 process pointer page 14 of 16
07:18:01.82 process pointer page 15 of 16
07:18:01.83 Index 1 (XQS_1000_3300_DOC_ID)
07:18:02.33 Index 2 (XQS_1000_3300_SND_ID)
07:18:02.96 Index 3 (XQS_1000_3300_RCV_ID)
07:18:03.50 Relation 267 (XQS_1000_3300) is ok
07:18:03.50 Relation 268 (XQS_2000_3300)
07:18:03.50 process pointer page 0 of 1
07:18:03.50 Index 1 (XQS_2000_3300_DOC_ID)
07:18:03.50 Index 2 (XQS_2000_3300_SND_ID)
07:18:03.50 Index 3 (XQS_2000_3300_RCV_ID)
07:18:03.50 Relation 268 (XQS_2000_3300) is ok
07:18:03.50 Relation 269 (XQS_2100_3300)
07:18:03.50 process pointer page 0 of 27
07:18:03.60 process pointer page 1 of 27
07:18:03.70 process pointer page 2 of 27
07:18:03.81 process pointer page 3 of 27
07:18:03.91 process pointer page 4 of 27
07:18:04.02 process pointer page 5 of 27
07:18:04.08 process pointer page 6 of 27
07:18:04.16 process pointer page 7 of 27
07:18:04.25 process pointer page 8 of 27
07:18:04.36 process pointer page 9 of 27
07:18:04.45 process pointer page 10 of 27
07:18:04.56 process pointer page 11 of 27
07:18:04.67 process pointer page 12 of 27
07:18:04.77 process pointer page 13 of 27
07:18:04.86 process pointer page 14 of 27
07:18:04.97 process pointer page 15 of 27
07:18:05.06 process pointer page 16 of 27
07:18:05.11 process pointer page 17 of 27
07:18:05.14 process pointer page 18 of 27
07:18:05.23 process pointer page 19 of 27
07:18:05.34 process pointer page 20 of 27
07:18:05.44 process pointer page 21 of 27
07:18:05.55 process pointer page 22 of 27
07:18:05.64 process pointer page 23 of 27
07:18:05.75 process pointer page 24 of 27
07:18:05.84 process pointer page 25 of 27
07:18:05.95 process pointer page 26 of 27
07:18:05.97 Index 1 (XQS_2100_3300_DOC_ID)
07:18:06.98 Index 2 (XQS_2100_3300_SND_ID)
07:18:08.03 Index 3 (XQS_2100_3300_RCV_ID)
07:18:09.01 Relation 269 (XQS_2100_3300) is ok
07:18:09.01 Relation 270 (XQS_3300_3400)
07:18:09.01 process pointer page 0 of 5
07:18:09.10 process pointer page 1 of 5
07:18:09.21 process pointer page 2 of 5
07:18:09.27 process pointer page 3 of 5
07:18:09.35 process pointer page 4 of 5
07:18:09.37 Index 1 (XQS_3300_3400_DOC_ID)
07:18:09.52 Index 2 (XQS_3300_3400_SND_ID)
07:18:09.68 Relation 270 (XQS_3300_3400) is ok
07:18:09.68 Relation 276 (TRACE_STAT)
07:18:09.68 process pointer page 0 of 1
07:18:09.68 Relation 276 (TRACE_STAT) is ok
07:18:09.68 Validation finished
Done for 61860 ms, from 7:17:07.84 to 7:18:09.70.
Differences between old and current firebird.log
7:18:10.90. 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:
2016-11-21 07:18 504 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 Mon Nov 21 07:17:07 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Mon Nov 21 07:18:09 2016
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.
2016-11-21 7:18:21.79 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html