Firebird 3.0 Performance Logs

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 5488.02 4704 987844 2017-07-12 03:46 2017-07-12 06:46
customer order: creation 435.94 623 78469 2017-07-12 03:46 2017-07-12 06:46
customer order: refuse 36.18 324 6513 2017-07-12 03:46 2017-07-12 06:46
order to supplier: creation 111.27 2798 20028 2017-07-12 03:46 2017-07-12 06:46
order to supplier: removal 2.72 31648 490 2017-07-12 03:46 2017-07-12 06:46
invoice (draft): creation 111.23 4135 20021 2017-07-12 03:46 2017-07-12 06:46
invoice (draft): removal 38.55 689 6939 2017-07-12 03:46 2017-07-12 06:46
invoice accept: apply 61.41 18270 11054 2017-07-12 03:46 2017-07-12 06:46
invoice accept: cancel 17.72 3843 3190 2017-07-12 03:46 2017-07-12 06:46
customer reserve: creation 3132.27 302 563808 2017-07-12 03:46 2017-07-12 06:46
customer reserve: removal 950.22 103 171040 2017-07-12 03:46 2017-07-12 06:46
realization accept: apply 195.76 731 35237 2017-07-12 03:46 2017-07-12 06:46
realization accept: cancel 82.06 221 14770 2017-07-12 03:46 2017-07-12 06:46
payment from customer: creation 143.63 1176 25853 2017-07-12 03:46 2017-07-12 06:46
payment from customer: removal 13.33 172 2399 2017-07-12 03:46 2017-07-12 06:46
payment to supplier: creation 121.32 1539 21838 2017-07-12 03:46 2017-07-12 06:46
payment to supplier: removal 8.06 167 1451 2017-07-12 03:46 2017-07-12 06:46
service: total inventory turnovers 7.21 5047 1298 2017-07-12 03:46 2017-07-12 06:46
service: total monetary turnovers 19.08 71 3434 2017-07-12 03:46 2017-07-12 06:46
service: refresh index statistics 0.07 17512 12 2017-07-12 03:46 2017-07-12 06:46
Done for 63700 ms, from 6:51:30.50 to 6:52:34.20.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 4369 91972 78644 13328 14.49 03:46:46 04:04:46
interval # 2, overall 2 4898 101504 88165 13339 13.14 04:04:47 04:22:47
interval # 3, overall 3 5681 110582 102256 8326 7.53 04:22:48 04:40:48
interval # 4, overall 4 5603 110712 100860 9852 8.90 04:40:49 04:58:49
interval # 5, overall 5 5368 105980 96617 9363 8.83 04:58:50 05:16:50
interval # 6, overall 6 5452 106433 98138 8295 7.79 05:16:51 05:34:51
interval # 7, overall 7 5745 110953 103408 7545 6.80 05:34:52 05:52:52
interval # 8, overall 8 5995 117950 107909 10041 8.51 05:52:53 06:10:53
interval # 9, overall 9 5801 115712 104426 11286 9.75 06:10:54 06:28:54
interval # 10, overall 10 5968 121653 107421 14232 11.70 06:28:55 06:46:55
Done for 147110 ms, from 6:55:05.28 to 6:57:32.39.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
TEST_TIME 1 2456.39 0.3680 1.7525 2237 49
TEST_TIME 2 3081.28 0.6985 1.3036 2053 53
TEST_TIME 3 3354.86 0.7984 1.2297 1501 55
TEST_TIME 4 3519.87 0.8792 1.1298 1585 100
TEST_TIME 5 3515.97 0.9048 1.0991 1484 100
TEST_TIME 6 3549.23 0.9073 1.0770 1592 100
TEST_TIME 7 3588.27 0.9132 1.0888 1663 100
TEST_TIME 8 3721.72 0.9186 1.0861 1925 100
TEST_TIME 9 3825.46 0.9394 1.0586 1874 100
TEST_TIME 10 3945.83 0.9592 1.0398 1545 100
TEST_TIME 11 3919.51 0.9516 1.0456 1643 95
TEST_TIME 12 4021.82 0.9341 1.0437 1415 100
TEST_TIME 13 4045.92 0.9577 1.0408 1465 100
TEST_TIME 14 4093.24 0.9553 1.0341 1394 100
TEST_TIME 15 4099.85 0.9636 1.0314 1350 100
TEST_TIME 16 4181.63 0.9481 1.0324 2154 100
TEST_TIME 17 4181.84 0.9717 1.0448 2181 99
TEST_TIME 18 4275.21 0.9695 1.0301 1942 99
TEST_TIME 19 4288.66 0.9728 1.0196 1690 96
TEST_TIME 20 4269.38 0.9730 1.0262 1765 98
TEST_TIME 21 4317.93 0.9664 1.0230 1541 100
TEST_TIME 22 4334.12 0.9728 1.0127 1485 97
TEST_TIME 23 4279.64 0.9810 1.0247 1295 97
TEST_TIME 24 4247.04 0.9895 1.0103 1500 91
TEST_TIME 25 4174.24 0.9869 1.0128 1283 77
TEST_TIME 26 4141.59 0.9816 1.0206 1277 78
TEST_TIME 27 4180.81 0.9736 1.0358 1244 100
TEST_TIME 28 4271.28 0.9778 1.0257 1495 100
TEST_TIME 29 4320.38 0.9796 1.0187 1556 100
TEST_TIME 30 4328.42 0.9832 1.0172 1083 100
TEST_TIME 31 4368.44 0.9753 1.0275 2111 100
TEST_TIME 32 4439.08 0.9796 1.0191 2116 100
TEST_TIME 33 4476.66 0.9799 1.0164 1763 97
TEST_TIME 34 4518.97 0.9827 1.0117 1557 99
TEST_TIME 35 4521.75 0.9822 1.0169 1618 100
TEST_TIME 36 4572.93 0.9776 1.0181 1240 100
TEST_TIME 37 4597.38 0.9854 1.0116 1736 100
TEST_TIME 38 4617.22 0.9807 1.0167 1477 100
TEST_TIME 39 4665.55 0.9817 1.0193 1353 100
TEST_TIME 40 4694.47 0.9878 1.0097 1494 100
TEST_TIME 41 4697.71 0.9844 1.0137 1421 99
TEST_TIME 42 4715.00 0.9860 1.0129 1292 99
TEST_TIME 43 4723.09 0.9877 1.0144 1220 100
TEST_TIME 44 4748.43 0.9861 1.0157 1420 100
TEST_TIME 45 4792.43 0.9840 1.0128 1317 100
TEST_TIME 46 4813.19 0.9866 1.0110 2043 100
TEST_TIME 47 4832.66 0.9856 1.0170 2089 96
TEST_TIME 48 4877.52 0.9866 1.0090 1647 96
TEST_TIME 49 4904.02 0.9831 1.0070 1600 100
TEST_TIME 50 4877.36 0.9922 1.0100 1655 88
TEST_TIME 51 4889.35 0.9878 1.0116 1678 96
TEST_TIME 52 4935.36 0.9829 1.0160 1395 100
TEST_TIME 53 4947.92 0.9943 1.0063 1474 99
TEST_TIME 54 4917.24 0.9938 1.0067 1390 89
TEST_TIME 55 4948.52 0.9821 1.0062 1109 100
TEST_TIME 56 4933.12 0.9913 1.0056 1424 99
TEST_TIME 57 4911.98 0.9922 1.0078 1417 93
TEST_TIME 58 4929.21 0.9870 1.0062 1312 100
TEST_TIME 59 4928.59 0.9893 1.0087 1218 100
TEST_TIME 60 4931.64 0.9913 1.0102 1320 100
TEST_TIME 61 4958.03 0.9883 1.0139 1970 100
TEST_TIME 62 5001.53 0.9910 1.0086 2108 100
TEST_TIME 63 5011.19 0.9906 1.0125 1935 99
TEST_TIME 64 5040.60 0.9909 1.0128 1634 98
TEST_TIME 65 5091.96 0.9871 1.0087 1354 100
TEST_TIME 66 5090.53 0.9937 1.0048 1829 99
TEST_TIME 67 5069.05 0.9940 1.0062 1559 93
TEST_TIME 68 5075.39 0.9902 1.0083 1486 96
TEST_TIME 69 5080.56 0.9926 1.0102 1407 97
TEST_TIME 70 5098.52 0.9932 1.0041 1421 100
TEST_TIME 71 5082.03 0.9932 1.0064 1374 96
TEST_TIME 72 5078.10 0.9932 1.0071 1224 87
TEST_TIME 73 5074.69 0.9940 1.0042 1114 88
TEST_TIME 74 5048.70 0.9957 1.0041 959 76
TEST_TIME 75 5038.12 0.9928 1.0080 670 100
TEST_TIME 76 5036.42 0.9951 1.0065 1537 99
TEST_TIME 77 5049.21 0.9912 1.0129 1745 99
TEST_TIME 78 5080.77 0.9937 1.0061 1565 96
TEST_TIME 79 5093.00 0.9909 1.0111 1439 100
TEST_TIME 80 5116.05 0.9940 1.0048 1688 100
TEST_TIME 81 5103.72 0.9948 1.0064 1510 93
TEST_TIME 82 5114.23 0.9921 1.0069 1334 92
TEST_TIME 83 5123.16 0.9930 1.0060 1454 94
TEST_TIME 84 5131.61 0.9924 1.0026 1319 94
TEST_TIME 85 5108.07 0.9953 1.0079 1177 97
TEST_TIME 86 5108.94 0.9971 1.0051 1324 98
TEST_TIME 87 5103.04 0.9947 1.0081 1052 98
TEST_TIME 88 5130.63 0.9913 1.0093 995 100
TEST_TIME 89 5149.54 0.9944 1.0062 1272 100
TEST_TIME 90 5149.82 0.9951 1.0056 1332 100
TEST_TIME 91 5164.87 0.9916 1.0048 1671 100
TEST_TIME 92 5166.67 0.9936 1.0088 1575 99
TEST_TIME 93 5190.82 0.9934 1.0102 1682 99
TEST_TIME 94 5200.35 0.9976 1.0023 1504 97
TEST_TIME 95 5184.08 0.9948 1.0057 1234 99
TEST_TIME 96 5187.02 0.9947 1.0066 1194 98
TEST_TIME 97 5196.97 0.9943 1.0074 1285 96
TEST_TIME 98 5195.75 0.9974 1.0037 1420 97
TEST_TIME 99 5184.65 0.9957 1.0046 1349 94
TEST_TIME 100 5184.70 0.9945 1.0052 968 100
TEST_TIME 101 5195.84 0.9945 1.0027 1021 100
TEST_TIME 102 5173.28 0.9973 1.0031 1355 96
TEST_TIME 103 5188.50 0.9904 1.0038 1082 100
TEST_TIME 104 5179.83 0.9958 1.0046 1220 100
TEST_TIME 105 5170.41 0.9969 1.0068 1103 98
TEST_TIME 106 5172.26 0.9969 1.0061 1292 100
TEST_TIME 107 5176.57 0.9959 1.0052 1676 99
TEST_TIME 108 5197.54 0.9919 1.0056 1586 98
TEST_TIME 109 5196.67 0.9966 1.0033 1351 89
TEST_TIME 110 5187.16 0.9961 1.0050 1298 87
TEST_TIME 111 5198.31 0.9938 1.0075 1409 99
TEST_TIME 112 5203.21 0.9976 1.0059 1491 99
TEST_TIME 113 5209.07 0.9971 1.0030 1668 100
TEST_TIME 114 5203.84 0.9952 1.0054 1604 98
TEST_TIME 115 5206.12 0.9962 1.0061 1463 97
TEST_TIME 116 5212.22 0.9977 1.0031 1567 95
TEST_TIME 117 5213.97 0.9941 1.0083 1296 99
TEST_TIME 118 5240.65 0.9947 1.0035 1100 97
TEST_TIME 119 5226.59 0.9978 1.0029 1267 93
TEST_TIME 120 5221.10 0.9956 1.0067 1285 99
TEST_TIME 121 5226.99 0.9972 1.0044 1384 96
TEST_TIME 122 5233.11 0.9950 1.0044 1671 97
TEST_TIME 123 5236.81 0.9955 1.0045 1441 91
TEST_TIME 124 5240.96 0.9956 1.0053 1308 94
TEST_TIME 125 5257.46 0.9941 1.0037 1325 99
TEST_TIME 126 5271.71 0.9930 1.0050 1332 100
TEST_TIME 127 5286.78 0.9947 1.0036 1427 98
TEST_TIME 128 5294.56 0.9943 1.0030 1547 99
TEST_TIME 129 5288.58 0.9963 1.0049 1443 93
TEST_TIME 130 5293.30 0.9963 1.0031 1320 94
TEST_TIME 131 5301.45 0.9939 1.0035 1373 93
TEST_TIME 132 5297.56 0.9967 1.0030 1257 94
TEST_TIME 133 5315.27 0.9927 1.0063 1080 100
TEST_TIME 134 5321.78 0.9976 1.0022 1331 99
TEST_TIME 135 5312.70 0.9964 1.0041 1232 99
TEST_TIME 136 5319.46 0.9955 1.0026 1640 99
TEST_TIME 137 5322.60 0.9947 1.0059 1633 97
TEST_TIME 138 5341.43 0.9951 1.0047 1688 99
TEST_TIME 139 5359.17 0.9942 1.0041 1566 94
TEST_TIME 140 5360.38 0.9967 1.0062 1364 92
TEST_TIME 141 5369.14 0.9974 1.0024 1787 92
TEST_TIME 142 5364.39 0.9963 1.0047 1332 96
TEST_TIME 143 5378.04 0.9981 1.0012 1402 100
TEST_TIME 144 5375.24 0.9948 1.0019 1185 97
TEST_TIME 145 5365.03 0.9969 1.0030 1421 96
TEST_TIME 146 5365.80 0.9960 1.0055 1276 96
TEST_TIME 147 5367.15 0.9985 1.0022 1368 98
TEST_TIME 148 5369.52 0.9950 1.0027 1226 98
TEST_TIME 149 5366.88 0.9965 1.0029 1222 100
TEST_TIME 150 5357.18 0.9980 1.0022 1359 90
TEST_TIME 151 5354.37 0.9961 1.0048 1307 94
TEST_TIME 152 5372.19 0.9949 1.0042 1515 96
TEST_TIME 153 5380.93 0.9960 1.0033 1602 95
TEST_TIME 154 5378.09 0.9973 1.0036 1546 94
TEST_TIME 155 5384.16 0.9960 1.0029 1393 96
TEST_TIME 156 5388.44 0.9957 1.0029 1044 95
TEST_TIME 157 5388.71 0.9964 1.0053 1278 100
TEST_TIME 158 5400.84 0.9967 1.0018 1540 100
TEST_TIME 159 5402.04 0.9978 1.0050 1242 99
TEST_TIME 160 5413.43 0.9966 1.0015 1313 100
TEST_TIME 161 5401.48 0.9975 1.0036 1176 95
TEST_TIME 162 5417.33 0.9951 1.0016 1198 100
TEST_TIME 163 5416.04 0.9957 1.0024 1063 99
TEST_TIME 164 5412.19 0.9977 1.0026 1272 99
TEST_TIME 165 5406.85 0.9977 1.0014 1299 95
TEST_TIME 166 5399.59 0.9967 1.0017 1289 96
TEST_TIME 167 5411.36 0.9936 1.0045 1301 100
TEST_TIME 168 5422.58 0.9965 1.0021 1537 100
TEST_TIME 169 5418.96 0.9969 1.0035 1571 96
TEST_TIME 170 5424.40 0.9966 1.0034 1472 93
TEST_TIME 171 5432.49 0.9961 1.0059 1294 97
TEST_TIME 172 5445.18 0.9978 1.0035 1553 94
TEST_TIME 173 5445.48 0.9976 1.0049 1357 84
TEST_TIME 174 5463.25 0.9959 1.0030 1009 97
TEST_TIME 175 5459.57 0.9982 1.0016 1346 98
TEST_TIME 176 5456.24 0.9965 1.0050 1282 100
TEST_TIME 177 5466.14 0.9978 1.0045 1289 99
TEST_TIME 178 5469.10 0.9983 1.0018 1256 95
TEST_TIME 179 5468.88 0.9963 1.0050 1108 98
TEST_TIME 180 5475.33 0.9983 1.0023 872 98
Done for 9080 ms, from 6:57:33.62 to 6:57:42.70.

Performance from TRACE for ISQL instance #1:

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 40559 66953 36718 <null> 29590 155971 47671 <null> 46470 88780 45247 30171 48394 63724 84352 19426 85125 68318 <null> 03:46:46 04:04:46
fetches per second 2 18053 42054 11107 <null> 15602 4415 21831 5413 19395 52437 27533 3824 19230 97308 23722 32818 43138 90670 <null> 04:04:47 04:22:47
fetches per second 3 13488 38889 25437 <null> 17154 <null> 22386 4516 4761 88410 17076 28050 20128 5007 25919 2984 175167 259572 <null> 04:22:48 04:40:48
fetches per second 4 8684 10105 9429 <null> 17041 <null> 17271 6599 63182 2519 7436 1824 14851 1317 33866 2810 16931 13806 <null> 04:40:49 04:58:49
fetches per second 5 18960 9446 16552 <null> 9629 <null> 15935 3093 3989 20000 18742 1246 54602 8341 7295 <null> 9340 380711 <null> 04:58:50 05:16:50
fetches per second 6 3022 3823 11174 <null> 11802 6707 16484 3320 1030 17439 7885 23326 11088 1915 9232 2557 31980 39956 <null> 05:16:51 05:34:51
fetches per second 7 3625 16594 4906 8567 17000 3124 9062 5855 21261 8651 3544 2583 15722 4728 12821 <null> 31030 99915 <null> 05:34:52 05:52:52
fetches per second 8 5156 5474 8264 <null> 8581 8269 19082 <null> 85355 5805 11653 3557 18320 5675 48500 4617 15645 57429 <null> 05:52:53 06:10:53
fetches per second 9 5552 2750 14621 5983 7747 1541 20873 11736 <null> 1903 14861 4928 12873 <null> 7101 <null> 21741 <null> <null> 06:10:54 06:28:54
fetches per second 10 3119 7136 5455 <null> 6922 22894 9454 3323 5306 <null> 11292 3666 19379 3257 13372 4894 71674 30323 <null> 06:28:55 06:46:55
marks per second 1 8624 8491 8027 <null> 6505 35057 5987 <null> 4458 16763 6635 4753 4525 10067 3705 2862 26887 1435 <null> 03:46:46 04:04:46
marks per second 2 3948 5791 2094 <null> 3107 1097 2837 842 2372 9500 4243 899 1304 15108 857 6685 721 1625 <null> 04:04:47 04:22:47
marks per second 3 2841 5100 5173 <null> 3543 <null> 2712 662 613 16217 1892 4930 1180 907 760 501 8865 14725 <null> 04:22:48 04:40:48
marks per second 4 1803 1264 1772 <null> 3417 <null> 2048 1020 4916 402 912 313 495 180 1143 377 2413 596 <null> 04:40:49 04:58:49
marks per second 5 3817 1231 2705 <null> 1818 <null> 1366 459 876 3970 2433 182 2575 1364 153 <null> 370 31904 <null> 04:58:50 05:16:50
marks per second 6 623 431 1767 <null> 2030 963 1562 445 134 3055 756 3630 415 262 204 424 919 395 <null> 05:16:51 05:34:51
marks per second 7 749 2403 752 1222 2005 787 829 743 2161 1371 377 378 509 714 338 <null> 573 989 <null> 05:34:52 05:52:52
marks per second 8 1106 722 1288 <null> 1281 1644 1831 <null> 7289 927 1511 514 354 858 1685 660 2943 1222 <null> 05:52:53 06:10:53
marks per second 9 1132 367 2246 1544 1142 338 2279 1572 <null> 310 1414 754 510 <null> 446 <null> 661 <null> <null> 06:10:54 06:28:54
marks per second 10 654 829 772 <null> 1098 5939 782 465 597 <null> 1695 526 579 768 1658 682 4854 489 <null> 06:28:55 06:46:55
reads/fetches*100 1 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 03:46:46 04:04:46
reads/fetches*100 2 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:04:47 04:22:47
reads/fetches*100 3 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:22:48 04:40:48
reads/fetches*100 4 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:40:49 04:58:49
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 04:58:50 05:16:50
reads/fetches*100 6 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:16:51 05:34:51
reads/fetches*100 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 05:34:52 05:52:52
reads/fetches*100 8 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 05:52:53 06:10:53
reads/fetches*100 9 0 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 0 <null> 0 <null> <null> 06:10:54 06:28:54
reads/fetches*100 10 0 0 0 <null> 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> 06:28:55 06:46:55
writes/marks*100 1 0 0 0 <null> 0 0 0 <null> 0 0 0 1 0 0 0 0 1 0 <null> 03:46:46 04:04:46
writes/marks*100 2 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 4 0 <null> 04:04:47 04:22:47
writes/marks*100 3 0 0 0 <null> 0 <null> 0 0 1 0 0 0 0 0 0 0 2 0 <null> 04:22:48 04:40:48
writes/marks*100 4 1 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 2 0 <null> 04:40:49 04:58:49
writes/marks*100 5 0 1 0 <null> 0 <null> 0 0 0 0 0 0 0 0 1 <null> 7 0 <null> 04:58:50 05:16:50
writes/marks*100 6 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:16:51 05:34:51
writes/marks*100 7 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 <null> 5 0 <null> 05:34:52 05:52:52
writes/marks*100 8 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 2 0 <null> 05:52:53 06:10:53
writes/marks*100 9 0 0 0 0 0 0 0 0 <null> 1 0 0 0 <null> 0 <null> 4 <null> <null> 06:10:54 06:28:54
writes/marks*100 10 0 0 1 <null> 0 0 0 0 1 <null> 0 0 0 0 0 0 1 0 <null> 06:28:55 06:46:55
Done for 7870 ms, from 6:57:43.62 to 6:57:51.49.

Performance in DETAILS:

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 1692572 1598452 94120 5.56 0 9298 79 94120 2017-07-12 03:46 2017-07-12 06:46
doc_list_biud 1693001 1598452 94549 5.58 0 7909 24 94549 2017-07-12 03:46 2017-07-12 06:46
sp_add_invoice_to_stock 18621 11054 7567 40.63 15 202021 18270 7567 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_adding_invoice 3925 3190 735 18.72 0 119012 3843 735 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_client_order 6669 6513 156 2.33 0 4259 324 156 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_customer_reserve 256607 171040 85567 33.34 0 5101 103 85567 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_pay_from_customer 2413 2399 14 0.58 0 3027 172 14 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_pay_to_supplier 1455 1451 4 0.27 0 1684 167 4 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_supplier_invoice 8686 6939 1747 20.11 0 9844 689 1747 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_supplier_order 1522 490 1032 67.80 63 258352 31648 1032 2017-07-12 03:46 2017-07-12 06:46
sp_cancel_write_off 21919 14770 7149 32.61 0 3775 221 7149 2017-07-12 03:46 2017-07-12 06:46
sp_client_order 78469 78469 0 0.00 0 6255 623 0 2017-07-12 03:46 2017-07-12 06:46
sp_customer_reserve 563808 563808 0 0.00 0 9001 302 0 2017-07-12 03:46 2017-07-12 06:46
sp_fill_shopping_cart 118772 118518 254 0.21 0 4976 121 0 2017-07-12 03:46 2017-07-12 06:46
sp_fill_shopping_cart_clo_res 563808 563808 0 0.00 0 4882 21 0 2017-07-12 03:46 2017-07-12 06:46
sp_get_clo_for_invoice 11054 11054 0 0.00 0 8314 424 0 2017-07-12 03:46 2017-07-12 06:46
sp_kill_cost_storno 29345 21810 7535 25.67 0 2433 28 7535 2017-07-12 03:46 2017-07-12 06:46
sp_kill_qstorno_ret_qs2qd 543410 364279 179131 32.96 0 7878 39 179131 2017-07-12 03:46 2017-07-12 06:46
sp_kill_qty_storno 343683 249233 94450 27.48 0 7894 111 94450 2017-07-12 03:46 2017-07-12 06:46
sp_lock_selected_doc 76400 65308 11092 14.51 0 2169 9 11092 2017-07-12 03:46 2017-07-12 06:46
sp_make_cost_storno 93982 93982 0 0.00 0 9094 720 0 2017-07-12 03:46 2017-07-12 06:46
sp_multiply_rows_for_pdistr 93982 93982 0 0.00 0 3651 78 0 2017-07-12 03:46 2017-07-12 06:46
sp_multiply_rows_for_qdistr 78469 78469 0 0.00 0 3916 210 0 2017-07-12 03:46 2017-07-12 06:46
sp_pay_from_customer 25853 25853 0 0.00 0 7597 1176 0 2017-07-12 03:46 2017-07-12 06:46
sp_pay_to_supplier 21838 21838 0 0.00 0 9594 1539 0 2017-07-12 03:46 2017-07-12 06:46
sp_payment_common 47691 47691 0 0.00 0 3510 76 0 2017-07-12 03:46 2017-07-12 06:46
sp_qd_handle_on_cancel_clo 6665 6513 152 2.28 0 3900 146 152 2017-07-12 03:46 2017-07-12 06:46
sp_qd_handle_on_invoice_upd_sts 14828 14244 584 3.93 0 5164 458 584 2017-07-12 03:46 2017-07-12 06:46
sp_qd_handle_on_reserve_upd_sts 35237 35237 0 0.00 0 3978 73 0 2017-07-12 03:46 2017-07-12 06:46
sp_reserve_write_off 36619 35237 1382 3.77 0 7520 731 1382 2017-07-12 03:46 2017-07-12 06:46
sp_supplier_invoice 20130 20021 109 0.54 0 28017 4135 0 2017-07-12 03:46 2017-07-12 06:46
sp_supplier_order 20173 20028 145 0.71 0 16302 2798 0 2017-07-12 03:46 2017-07-12 06:46
srv_find_qd_qs_mism 992156 898072 94084 9.48 0 4009 39 94084 2017-07-12 03:46 2017-07-12 06:46
srv_make_invnt_saldo 1298 1298 0 0.00 47 30155 5047 0 2017-07-12 03:46 2017-07-12 06:46
srv_make_money_saldo 3434 3434 0 0.00 0 6817 71 0 2017-07-12 03:46 2017-07-12 06:46
srv_recalc_idx_stat 12 12 0 0.00 2138 34320 17512 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_add_invoice_to_stock 7567 7567 0 0.00 0 2230 127 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_adding_invoice 705 705 0 0.00 0 2605 308 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_client_order 156 156 0 0.00 0 2122 164 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_customer_reserve 85 85 0 0.00 0 920 69 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_pay_from_customer 14 14 0 0.00 0 1498 165 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 0 281 93 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_supplier_invoice 598 598 0 0.00 0 2371 138 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_supplier_order 10925 10925 0 0.00 0 3307 186 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_cancel_write_off 28 28 0 0.00 0 827 113 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_reserve_write_off 1382 1382 0 0.00 0 1498 96 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_supplier_invoice 109 109 0 0.00 0 749 107 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-abend:sp_supplier_order 145 145 0 0.00 0 1108 111 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_add_invoice_to_stock 11054 11054 0 0.00 0 13510 945 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_adding_invoice 1253 1253 0 0.00 0 10140 1100 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_client_order 6513 6513 0 0.00 0 1872 94 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_customer_reserve 2373 2373 0 0.00 0 2091 100 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_pay_from_customer 2399 2399 0 0.00 0 1825 72 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_pay_to_supplier 1451 1451 0 0.00 0 1419 70 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_supplier_invoice 947 947 0 0.00 0 1872 107 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_supplier_order 490 490 0 0.00 0 66425 3421 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_cancel_write_off 3591 3591 0 0.00 0 2122 100 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_client_order 78469 78469 0 0.00 0 3073 111 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_customer_reserve 3670 3670 0 0.00 0 1778 78 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_pay_from_customer 25853 25853 0 0.00 0 2855 100 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_pay_to_supplier 21838 21838 0 0.00 0 2574 101 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_reserve_write_off 35237 35237 0 0.00 0 3058 107 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_supplier_invoice 20021 20021 0 0.00 0 2496 104 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:sp_supplier_order 20028 20028 0 0.00 0 2590 106 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:srv_make_invnt_saldo 1298 1298 0 0.00 0 1107 48 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:srv_make_money_saldo 3434 3434 0 0.00 0 1373 40 0 2017-07-12 03:46 2017-07-12 06:46
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 998 233 0 2017-07-12 03:46 2017-07-12 06:46
v_add_invoice_to_stock 37242 22108 15134 40.63 0 9719 101 15134 2017-07-12 03:46 2017-07-12 06:46
v_all_customers 117610 117610 0 0.00 0 1170 7 0 2017-07-12 03:46 2017-07-12 06:46
v_all_suppliers 80606 80098 508 0.63 0 1903 7 0 2017-07-12 03:46 2017-07-12 06:46
v_all_wares 156938 156938 0 0.00 0 1934 6 0 2017-07-12 03:46 2017-07-12 06:46
v_cancel_adding_invoice 2958 2506 452 15.28 0 2481 186 452 2017-07-12 03:46 2017-07-12 06:46
v_cancel_client_order 13338 13026 312 2.33 0 2169 8 312 2017-07-12 03:46 2017-07-12 06:46
v_cancel_customer_prepayment 4826 4798 28 0.58 0 1388 10 28 2017-07-12 03:46 2017-07-12 06:46
v_cancel_customer_reserve 4916 4746 170 3.45 0 999 12 170 2017-07-12 03:46 2017-07-12 06:46
v_cancel_payment_to_supplier 2910 2902 8 0.27 0 1170 9 8 2017-07-12 03:46 2017-07-12 06:46
v_cancel_supplier_invoice 3090 1894 1196 38.70 0 9501 99 1196 2017-07-12 03:46 2017-07-12 06:46
v_cancel_supplier_order 3044 980 2064 67.80 0 530 10 2064 2017-07-12 03:46 2017-07-12 06:46
v_cancel_write_off 7238 7182 56 0.77 0 3027 117 56 2017-07-12 03:46 2017-07-12 06:46
v_max_id_clo_ord 20173 20028 145 0.71 0 1045 7 0 2017-07-12 03:46 2017-07-12 06:46
v_max_id_clo_res 3670 3670 0 0.00 0 2122 25 0 2017-07-12 03:46 2017-07-12 06:46
v_max_id_ord_sup 20130 20021 109 0.54 0 1685 7 0 2017-07-12 03:46 2017-07-12 06:46
v_max_non_paid_invoice 21838 21838 0 0.00 0 1716 7 0 2017-07-12 03:46 2017-07-12 06:46
v_max_non_paid_realizn 25853 25853 0 0.00 0 1201 7 0 2017-07-12 03:46 2017-07-12 06:46
v_min_id_clo_ord 20173 20028 145 0.71 0 1108 9 0 2017-07-12 03:46 2017-07-12 06:46
v_min_id_clo_res 3670 3670 0 0.00 0 843 11 0 2017-07-12 03:46 2017-07-12 06:46
v_min_id_ord_sup 20130 20021 109 0.54 0 1170 9 0 2017-07-12 03:46 2017-07-12 06:46
v_min_non_paid_invoice 21838 21838 0 0.00 0 2200 12 0 2017-07-12 03:46 2017-07-12 06:46
v_min_non_paid_realizn 25853 25853 0 0.00 0 3027 11 0 2017-07-12 03:46 2017-07-12 06:46
v_our_firm 39328 39328 0 0.00 0 1124 7 0 2017-07-12 03:46 2017-07-12 06:46
v_reserve_write_off 73238 70474 2764 3.77 0 2137 10 2764 2017-07-12 03:46 2017-07-12 06:46
x_lock_depdocs_on_canc_invoice 16087 9182 6905 42.92 0 2216 45 6905 2017-07-12 03:46 2017-07-12 06:46
x_lock_depdocs_on_canc_sup_ord 1518 490 1028 67.72 0 1170 85 1028 2017-07-12 03:46 2017-07-12 06:46
x_make_qstorno_1000_1200 20173 20028 145 0.71 0 14554 2526 0 2017-07-12 03:46 2017-07-12 06:46
x_make_qstorno_1200_2000 20130 20021 109 0.54 0 27752 3864 0 2017-07-12 03:46 2017-07-12 06:46
x_make_qstorno_2100_3300 563808 563808 0 0.00 0 8970 256 0 2017-07-12 03:46 2017-07-12 06:46
Done for 226500 ms, from 7:01:30.71 to 7:05:17.21.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 83 sp_kill_cost_storno 335544336 2017-07-12 03:47 2017-07-12 06:39
deadlock 84 sp_kill_qstorno_ret_qs2qd 335544336 2017-07-12 03:47 2017-07-12 06:46
deadlock 9680 sp_lock_selected_doc 335544336 2017-07-12 03:46 2017-07-12 06:46
deadlock 152 sp_qd_handle_on_cancel_clo 335544336 2017-07-12 03:50 2017-07-12 06:45
deadlock 170 sp_qd_handle_on_invoice_upd_sts 335544336 2017-07-12 03:47 2017-07-12 06:46
deadlock 626 x_lock_depdocs_on_canc_invoice 335544336 2017-07-12 03:47 2017-07-12 06:46
deadlock 293 x_lock_depdocs_on_canc_sup_ord 335544336 2017-07-12 03:47 2017-07-12 06:46
user_exc 145 x_make_qstorno_1000_1200 335544517 2017-07-12 03:47 2017-07-12 06:41
user_exc 109 x_make_qstorno_1200_2000 335544517 2017-07-12 03:48 2017-07-12 06:43
Done for 6990 ms, from 7:05:22.01 to 7:05:29.00.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 418928
MON$OLDEST_ACTIVE 418929
MON$OLDEST_SNAPSHOT 418929
MON$NEXT_TRANSACTION 418929
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:12:20.4040
MON$PAGES 770720
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32749 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32749 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32749 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32749 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 419095
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 418930
Oldest active 418931
Oldest snapshot 418931
Next transaction 418932
Sequence number 0
Next attachment ID 9484
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.04, total records: 2071064
Average version length: 47.70, total versions: 3006, 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: 14, data page slots: 22432
Data pages: 22432, average fill: 73%
Primary pages: 22432, secondary pages: 0, swept pages: 13587
Empty pages: 0, full pages: 18388
Fill distribution:
0 - 19% = 2
20 - 39% = 7
40 - 59% = 60
60 - 79% = 22361
80 - 99% = 2

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9812, nodes: 2071064
Average node length: 19.24, total dup: 0, max dup: 0
Average key length: 16.29, compression ratio: 1.66
Average prefix length: 13.71, average data length: 13.29
Clustering factor: 493161, ratio: 0.24
Fill distribution:
0 - 19% = 552
20 - 39% = 1876
40 - 59% = 5104
60 - 79% = 920
80 - 99% = 1360

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7401, nodes: 2071064
Average node length: 11.66, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.29, average data length: 5.71
Clustering factor: 453239, ratio: 0.22
Fill distribution:
0 - 19% = 2
20 - 39% = 3424
40 - 59% = 3930
60 - 79% = 39
80 - 99% = 6

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175185, depth: 3, leaf buckets: 3643, nodes: 2071064
Average node length: 6.78, total dup: 1520033, max dup: 49
Average key length: 3.83, compression ratio: 2.35
Average prefix length: 7.44, average data length: 1.56
Clustering factor: 454972, ratio: 0.22
Fill distribution:
0 - 19% = 112
20 - 39% = 1262
40 - 59% = 1643
60 - 79% = 115
80 - 99% = 511

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.26, total records: 614782
Average version length: 35.51, total versions: 1132, max versions: 3
Average fragment length: 11.00, total fragments: 8, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7808
Data pages: 7808, average fill: 75%
Primary pages: 7805, secondary pages: 3, swept pages: 7127
Empty pages: 5, full pages: 6837
Fill distribution:
0 - 19% = 10
20 - 39% = 4
40 - 59% = 38
60 - 79% = 7737
80 - 99% = 19

Index DOC_LIST_ID_DESC (1)
Root page: 256855, depth: 3, leaf buckets: 2289, nodes: 614782
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 160914, ratio: 0.26
Fill distribution:
0 - 19% = 0
20 - 39% = 1350
40 - 59% = 923
60 - 79% = 15
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 643, nodes: 614782
Average node length: 4.87, total dup: 614732, max dup: 43796
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 280989, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 551
60 - 79% = 65
80 - 99% = 27

Index PK_DOC_LIST (0)
Root page: 31589, depth: 3, leaf buckets: 1988, nodes: 614782
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 160914, ratio: 0.26
Fill distribution:
0 - 19% = 129
20 - 39% = 834
40 - 59% = 675
60 - 79% = 139
80 - 99% = 211

DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 64.74, total records: 400
Average version length: 21.56, total versions: 104659, max versions: 931
Average fragment length: 17.79, total fragments: 376, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.61
Pointer pages: 2, data page slots: 1712
Data pages: 1712, average fill: 36%
Primary pages: 10, secondary pages: 1702, swept pages: 2
Empty pages: 6, full pages: 4
Fill distribution:
0 - 19% = 6
20 - 39% = 1532
40 - 59% = 169
60 - 79% = 1
80 - 99% = 4

Index PK_INVNT_SALDO (0)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 4.04, total records: 67203
Average version length: 71.13, total versions: 63394, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 23.77
Pointer pages: 2, data page slots: 1456
Data pages: 1008, average fill: 85%
Primary pages: 1007, secondary pages: 1, swept pages: 0
Empty pages: 11, full pages: 892
Fill distribution:
0 - 19% = 25
20 - 39% = 11
40 - 59% = 37
60 - 79% = 108
80 - 99% = 827

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 173, nodes: 67203
Average node length: 13.46, total dup: 3043, max dup: 3
Average key length: 11.45, compression ratio: 2.36
Average prefix length: 18.51, average data length: 8.49
Clustering factor: 57446, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 70
60 - 79% = 67
80 - 99% = 35

MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.92, 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.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 19%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MONEY_SALDO (0)
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 45.49, total records: 118
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: 64.00, compression ratio: 1.41
Pointer pages: 1, data page slots: 48
Data pages: 16, average fill: 7%
Primary pages: 16, secondary pages: 0, swept pages: 12
Empty pages: 11, full pages: 0
Fill distribution:
0 - 19% = 14
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 237071, depth: 2, leaf buckets: 1, nodes: 118
Average node length: 9.16, total dup: 78, max dup: 22
Average key length: 7.17, compression ratio: 2.65
Average prefix length: 14.16, average data length: 4.84
Clustering factor: 51, ratio: 0.43
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (166)
Primary pointer page: 366, Index root page: 367
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 239, Index root page: 240
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 38.96, total records: 234313
Average version length: 31.90, total versions: 31588, max versions: 8
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.64
Pointer pages: 2, data page slots: 2464
Data pages: 2464, average fill: 73%
Primary pages: 2460, secondary pages: 4, swept pages: 236
Empty pages: 4, full pages: 2306
Fill distribution:
0 - 19% = 14
20 - 39% = 54
40 - 59% = 72
60 - 79% = 2094
80 - 99% = 230

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 202, nodes: 234313
Average node length: 4.55, total dup: 234264, max dup: 9696
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 39588, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 77
60 - 79% = 80
80 - 99% = 41

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 259, nodes: 234313
Average node length: 5.51, total dup: 210843, max dup: 43
Average key length: 2.97, compression ratio: 7.40
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 51367, ratio: 0.22
Fill distribution:
0 - 19% = 3
20 - 39% = 20
40 - 59% = 111
60 - 79% = 81
80 - 99% = 44

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 255, nodes: 234313
Average node length: 5.51, total dup: 210843, max dup: 43
Average key length: 2.97, compression ratio: 7.40
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 51623, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 101
60 - 79% = 87
80 - 99% = 50

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 261, nodes: 234313
Average node length: 5.29, total dup: 210843, max dup: 43
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 51511, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 27
40 - 59% = 112
60 - 79% = 92
80 - 99% = 30

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.97, total records: 259792
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: 2224
Data pages: 2224, average fill: 64%
Primary pages: 2224, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 2219
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2219
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 302353, depth: 2, leaf buckets: 207, nodes: 259792
Average node length: 4.51, total dup: 259611, max dup: 2236
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 65327, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 65
60 - 79% = 89
80 - 99% = 52

PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.51, total records: 10542615
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.19
Pointer pages: 154, data page slots: 249744
Data pages: 249744, average fill: 87%
Primary pages: 249744, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 249743
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 249743

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 11569, nodes: 10542615
Average node length: 5.63, total dup: 9683546, max dup: 145
Average key length: 2.19, compression ratio: 3.64
Average prefix length: 7.85, average data length: 0.14
Clustering factor: 4937232, ratio: 0.47
Fill distribution:
0 - 19% = 13
20 - 39% = 0
40 - 59% = 5949
60 - 79% = 3682
80 - 99% = 1925

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 10282, nodes: 10542615
Average node length: 4.50, total dup: 10542611, max dup: 9829632
Average key length: 1.07, compression ratio: 0.32
Average prefix length: 0.34, average data length: 0.00
Clustering factor: 312982, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 10279
60 - 79% = 0
80 - 99% = 2

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 12479, nodes: 10542615
Average node length: 5.68, total dup: 10186357, max dup: 16504
Average key length: 2.25, compression ratio: 4.00
Average prefix length: 8.78, average data length: 0.22
Clustering factor: 1055621, ratio: 0.10
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 8759
60 - 79% = 1972
80 - 99% = 1746

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 12683, nodes: 10542615
Average node length: 5.51, total dup: 10510868, max dup: 1244378
Average key length: 2.08, compression ratio: 18.17
Average prefix length: 37.66, average data length: 0.07
Clustering factor: 6606676, ratio: 0.63
Fill distribution:
0 - 19% = 18
20 - 39% = 0
40 - 59% = 10767
60 - 79% = 711
80 - 99% = 1187

PHRASES (145)
Primary pointer page: 266, Index root page: 267
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.60, total records: 415916
Average version length: 56.10, total versions: 3449, 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: 4, data page slots: 4912
Data pages: 4912, average fill: 75%
Primary pages: 4912, secondary pages: 0, swept pages: 2694
Empty pages: 0, full pages: 4862
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 4899
80 - 99% = 10

Index PSTORNED_RCV_ID (2)
Root page: 645705, depth: 3, leaf buckets: 581, nodes: 415916
Average node length: 6.01, total dup: 344909, max dup: 316
Average key length: 3.24, compression ratio: 2.78
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 56326, ratio: 0.14
Fill distribution:
0 - 19% = 17
20 - 39% = 26
40 - 59% = 405
60 - 79% = 97
80 - 99% = 36

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 431, nodes: 415916
Average node length: 5.57, total dup: 371658, max dup: 105
Average key length: 2.80, compression ratio: 3.21
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 102629, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 162
60 - 79% = 171
80 - 99% = 92

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: 9.00, total versions: 3255, max versions: 2270
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: 16
Data pages: 16, average fill: 65%
Primary pages: 4, secondary pages: 12, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 11

Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 207, Index root page: 224
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 227, Index root page: 228
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 205, Index root page: 206
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$RESULT_SET (130)
Primary pointer page: 201, Index root page: 202
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 193, Index root page: 194
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.96, total records: 2391
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.49
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 69%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 28
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 29
80 - 99% = 0

WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 3.52, total records: 77586
Average version length: 72.17, total versions: 73807, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 38.59
Pointer pages: 2, data page slots: 1448
Data pages: 1088, average fill: 92%
Primary pages: 1087, secondary pages: 1, swept pages: 0
Empty pages: 7, full pages: 1079
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 34
80 - 99% = 1046

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 83, nodes: 77586
Average node length: 5.45, total dup: 67822, max dup: 14
Average key length: 3.39, compression ratio: 10.91
Average prefix length: 35.73, average data length: 1.27
Clustering factor: 12710, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 31
60 - 79% = 26
80 - 99% = 21

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 68.93, total records: 1285789
Average version length: 71.41, total versions: 57950, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 12, data page slots: 18480
Data pages: 18464, average fill: 77%
Primary pages: 18464, secondary pages: 0, swept pages: 6501
Empty pages: 48, full pages: 17931
Fill distribution:
0 - 19% = 74
20 - 39% = 58
40 - 59% = 122
60 - 79% = 16264
80 - 99% = 1946

Index XQD_1000_3300_DOC (1)
Root page: 355369, depth: 3, leaf buckets: 1505, nodes: 1285789
Average node length: 5.14, total dup: 1250846, max dup: 127
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 148458, ratio: 0.12
Fill distribution:
0 - 19% = 22
20 - 39% = 93
40 - 59% = 1154
60 - 79% = 55
80 - 99% = 181

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 244390, depth: 3, leaf buckets: 1820, nodes: 1285789
Average node length: 6.26, total dup: 1122254, max dup: 27
Average key length: 3.32, compression ratio: 11.13
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 247684, ratio: 0.19
Fill distribution:
0 - 19% = 21
20 - 39% = 121
40 - 59% = 1390
60 - 79% = 143
80 - 99% = 145

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 8.91, total records: 149457
Average version length: 71.87, total versions: 130989, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.27
Pointer pages: 3, data page slots: 3304
Data pages: 2176, average fill: 87%
Primary pages: 2172, secondary pages: 4, swept pages: 0
Empty pages: 36, full pages: 2081
Fill distribution:
0 - 19% = 48
20 - 39% = 13
40 - 59% = 22
60 - 79% = 195
80 - 99% = 1898

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 172, nodes: 149457
Average node length: 5.95, total dup: 133019, max dup: 67
Average key length: 3.23, compression ratio: 11.47
Average prefix length: 35.88, average data length: 1.12
Clustering factor: 18877, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 75
60 - 79% = 60
80 - 99% = 36

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 65.70, total records: 1788509
Average version length: 71.99, total versions: 160803, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.07
Pointer pages: 17, data page slots: 26752
Data pages: 26736, average fill: 75%
Primary pages: 26736, secondary pages: 0, swept pages: 7619
Empty pages: 140, full pages: 22414
Fill distribution:
0 - 19% = 334
20 - 39% = 528
40 - 59% = 1363
60 - 79% = 20107
80 - 99% = 4404

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197261, depth: 3, leaf buckets: 2808, nodes: 1788509
Average node length: 5.62, total dup: 1680410, max dup: 78
Average key length: 2.66, compression ratio: 13.90
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 256528, ratio: 0.14
Fill distribution:
0 - 19% = 13
20 - 39% = 1235
40 - 59% = 1220
60 - 79% = 172
80 - 99% = 168

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 0.83, total records: 108810
Average version length: 71.84, total versions: 107536, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 164.13
Pointer pages: 3, data page slots: 2704
Data pages: 1816, average fill: 78%
Primary pages: 1814, secondary pages: 2, swept pages: 0
Empty pages: 97, full pages: 1442
Fill distribution:
0 - 19% = 130
20 - 39% = 73
40 - 59% = 112
60 - 79% = 188
80 - 99% = 1313

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 135, nodes: 108810
Average node length: 5.39, total dup: 99244, max dup: 91
Average key length: 3.07, compression ratio: 12.06
Average prefix length: 36.02, average data length: 0.98
Clustering factor: 13077, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 77
60 - 79% = 39
80 - 99% = 4

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 69.87, total records: 2564467
Average version length: 71.60, total versions: 56906, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.95
Pointer pages: 23, data page slots: 36264
Data pages: 36264, average fill: 77%
Primary pages: 36264, secondary pages: 0, swept pages: 17256
Empty pages: 8, full pages: 34867
Fill distribution:
0 - 19% = 11
20 - 39% = 31
40 - 59% = 219
60 - 79% = 34326
80 - 99% = 1677

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5215, nodes: 2564467
Average node length: 6.87, total dup: 2079011, max dup: 15
Average key length: 3.90, compression ratio: 9.48
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 535257, ratio: 0.21
Fill distribution:
0 - 19% = 7
20 - 39% = 2791
40 - 59% = 1996
60 - 79% = 248
80 - 99% = 173

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.46, total records: 4590776
Average version length: 84.66, total versions: 9340, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 44, data page slots: 70440
Data pages: 70440, average fill: 80%
Primary pages: 70440, secondary pages: 0, swept pages: 26085
Empty pages: 4, full pages: 70435
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 20434
80 - 99% = 50001

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4669, nodes: 4590776
Average node length: 5.15, total dup: 4486000, max dup: 145
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 747934, ratio: 0.16
Fill distribution:
0 - 19% = 22
20 - 39% = 68
40 - 59% = 2062
60 - 79% = 1917
80 - 99% = 600

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5375, nodes: 4590776
Average node length: 5.70, total dup: 4112436, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 274785, ratio: 0.06
Fill distribution:
0 - 19% = 68
20 - 39% = 163
40 - 59% = 3534
60 - 79% = 256
80 - 99% = 1354

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5193, nodes: 4590776
Average node length: 5.81, total dup: 4016583, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 802213, ratio: 0.17
Fill distribution:
0 - 19% = 25
20 - 39% = 80
40 - 59% = 2270
60 - 79% = 1990
80 - 99% = 828

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 81.61, total records: 2252390
Average version length: 84.26, total versions: 36536, 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: 22, data page slots: 35112
Data pages: 35112, average fill: 79%
Primary pages: 35112, secondary pages: 0, swept pages: 21544
Empty pages: 6, full pages: 33509
Fill distribution:
0 - 19% = 13
20 - 39% = 55
40 - 59% = 304
60 - 79% = 14882
80 - 99% = 19858

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2422, nodes: 2252390
Average node length: 5.15, total dup: 2200074, max dup: 201
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 342468, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 41
40 - 59% = 1466
60 - 79% = 683
80 - 99% = 227

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3938, nodes: 2252390
Average node length: 6.20, total dup: 1856243, max dup: 14
Average key length: 3.23, compression ratio: 2.79
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 238522, ratio: 0.11
Fill distribution:
0 - 19% = 108
20 - 39% = 1661
40 - 59% = 1590
60 - 79% = 432
80 - 99% = 147

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2776, nodes: 2252390
Average node length: 5.81, total dup: 1972454, max dup: 38
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 410391, ratio: 0.18
Fill distribution:
0 - 19% = 24
20 - 39% = 42
40 - 59% = 1737
60 - 79% = 712
80 - 99% = 261

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 82.47, total records: 4914575
Average version length: 85.61, total versions: 76051, 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: 47, data page slots: 76400
Data pages: 76384, average fill: 80%
Primary pages: 76384, secondary pages: 0, swept pages: 19465
Empty pages: 100, full pages: 73638
Fill distribution:
0 - 19% = 237
20 - 39% = 322
40 - 59% = 769
60 - 79% = 17788
80 - 99% = 57268

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5246, nodes: 4914575
Average node length: 5.04, total dup: 4886058, max dup: 757
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 749464, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 242
40 - 59% = 3072
60 - 79% = 1449
80 - 99% = 478

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6171, nodes: 4914575
Average node length: 5.54, total dup: 4521141, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 320313, ratio: 0.07
Fill distribution:
0 - 19% = 67
20 - 39% = 1708
40 - 59% = 2683
60 - 79% = 541
80 - 99% = 1172

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5873, nodes: 4914575
Average node length: 5.67, total dup: 4417449, max dup: 95
Average key length: 2.69, compression ratio: 3.35
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 829781, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 205
40 - 59% = 3495
60 - 79% = 1590
80 - 99% = 579

XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_DOC_ID (0)
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 82.20, total records: 3256203
Average version length: 85.03, total versions: 46659, 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: 32, data page slots: 50928
Data pages: 50928, average fill: 79%
Primary pages: 50928, secondary pages: 0, swept pages: 30205
Empty pages: 10, full pages: 48371
Fill distribution:
0 - 19% = 22
20 - 39% = 72
40 - 59% = 363
60 - 79% = 21191
80 - 99% = 29280

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3478, nodes: 3256203
Average node length: 5.03, total dup: 3239665, max dup: 1077
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 728096, ratio: 0.22
Fill distribution:
0 - 19% = 16
20 - 39% = 303
40 - 59% = 1820
60 - 79% = 932
80 - 99% = 407

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5898, nodes: 3256203
Average node length: 6.23, total dup: 2673324, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 401849, ratio: 0.12
Fill distribution:
0 - 19% = 197
20 - 39% = 2778
40 - 59% = 2119
60 - 79% = 572
80 - 99% = 232

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3830, nodes: 3256203
Average node length: 5.61, total dup: 2962717, max dup: 91
Average key length: 2.63, compression ratio: 3.42
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 763242, ratio: 0.23
Fill distribution:
0 - 19% = 12
20 - 39% = 314
40 - 59% = 1918
60 - 79% = 1125
80 - 99% = 461

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 68.93, total records: 706610
Average version length: 70.02, total versions: 4627, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9680
Data pages: 9680, average fill: 77%
Primary pages: 9680, secondary pages: 0, swept pages: 6656
Empty pages: 2, full pages: 9518
Fill distribution:
0 - 19% = 5
20 - 39% = 11
40 - 59% = 32
60 - 79% = 9507
80 - 99% = 125

Index XQS_3300_3400_DOC_ID (0)
Root page: 172543, depth: 3, leaf buckets: 840, nodes: 706610
Average node length: 5.28, total dup: 670072, max dup: 165
Average key length: 2.40, compression ratio: 3.76
Average prefix length: 8.66, average data length: 0.34
Clustering factor: 55319, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 179
40 - 59% = 349
60 - 79% = 225
80 - 99% = 85

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 938, nodes: 706610
Average node length: 5.91, total dup: 606452, max dup: 29
Average key length: 3.02, compression ratio: 2.98
Average prefix length: 8.12, average data length: 0.88
Clustering factor: 59784, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 236
40 - 59% = 338
60 - 79% = 242
80 - 99% = 119

ZDOC_DATA (230)
Primary pointer page: 644, Index root page: 645
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (229)
Primary pointer page: 642, Index root page: 643
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 646, Index root page: 647
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (234)
Primary pointer page: 652, Index root page: 653
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (235)
Primary pointer page: 654, Index root page: 655
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (232)
Primary pointer page: 648, Index root page: 649
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (233)
Primary pointer page: 650, Index root page: 651
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (228)
Primary pointer page: 640, Index root page: 641
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (227)
Primary pointer page: 614, Index root page: 615
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Z_USED_VIEWS (146)
Primary pointer page: 268, Index root page: 269
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 75470 ms, from 7:05:29.44 to 7:06:44.91.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 2071064 3006 0.1451
DOC_LIST 614782 1132 0.1841
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 104659 26164.7500
INVNT_TURNOVER_LOG 67203 63394 94.3320
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 118 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 234313 31588 13.4811
PERF_ESTIMATED 259792 0 0.0000
PERF_LOG 10542615 0 0.0000
PSTORNED 415916 3449 0.8292
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 3255 81375.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2391 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 77586 73807 95.1292
XQD_1000_3300 1285789 57950 4.5069
XQD_1200_2000 149457 130989 87.6432
XQD_2000_3300 1788509 160803 8.9908
XQD_2100_3300 108810 107536 98.8291
XQD_3300_3400 2564467 56906 2.2190
XQS_1000_1200 4590776 9340 0.2034
XQS_1000_3300 2252390 36536 1.6220
XQS_1200_2000 4914575 76051 1.5474
XQS_2100_3300 3256203 46659 1.4329
XQS_3300_3400 706610 4627 0.6548
Z_USED_VIEWS 29 0 0.0000
Done for 1710 ms, from 7:06:58.49 to 7:07:00.20.

Database validation

07:07:00.28 Validation started

07:07:00.31 Relation 140 (DOC_LIST)
07:07:00.31 process pointer page 0 of 5
07:07:00.36 process pointer page 1 of 5
07:07:00.39 process pointer page 2 of 5
07:07:00.44 process pointer page 3 of 5
07:07:00.47 process pointer page 4 of 5
07:07:00.50 Index 1 (PK_DOC_LIST)
07:07:00.56 Index 2 (DOC_LIST_ID_DESC)
07:07:00.67 Index 3 (FK_DOC_LIST_AGENTS)
07:07:00.75 Relation 140 (DOC_LIST) is ok

07:07:00.75 Relation 141 (DOC_DATA)
07:07:00.75 process pointer page 0 of 14
07:07:00.78 process pointer page 1 of 14
07:07:00.81 process pointer page 2 of 14
07:07:00.87 process pointer page 3 of 14
07:07:00.92 process pointer page 4 of 14
07:07:00.95 process pointer page 5 of 14
07:07:00.98 process pointer page 6 of 14
07:07:01.01 process pointer page 7 of 14
07:07:01.04 process pointer page 8 of 14
07:07:01.08 process pointer page 9 of 14
07:07:01.11 process pointer page 10 of 14
07:07:01.14 process pointer page 11 of 14
07:07:01.17 process pointer page 12 of 14
07:07:01.18 process pointer page 13 of 14
07:07:01.22 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:07:01.54 Index 3 (DOC_DATA_ID_DESC)
07:07:02.18 Index 4 (FK_DOC_DATA_DOC_LIST)
07:07:02.57 Relation 141 (DOC_DATA) is ok

07:07:02.57 Relation 147 (INVNT_SALDO)
07:07:02.57 process pointer page 0 of 2
07:07:02.90 process pointer page 1 of 2
07:07:02.90 Index 1 (PK_INVNT_SALDO)
07:07:02.90 Relation 147 (INVNT_SALDO) is ok

07:07:02.90 Relation 150 (PDISTR)
07:07:02.90 process pointer page 0 of 2
07:07:03.03 process pointer page 1 of 2
07:07:03.09 Index 2 (PDISTR_SND_ID)
07:07:03.17 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:07:03.23 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:07:03.26 Index 5 (PDISTR_AGENT_ID)
07:07:03.29 Relation 150 (PDISTR) is ok

07:07:03.29 Relation 151 (PSTORNED)
07:07:03.29 process pointer page 0 of 4
07:07:03.32 process pointer page 1 of 4
07:07:03.42 process pointer page 2 of 4
07:07:03.51 process pointer page 3 of 4
07:07:03.51 Index 2 (PSTORNED_SND_ID)
07:07:03.57 Index 3 (PSTORNED_RCV_ID)
07:07:03.62 Relation 151 (PSTORNED) is ok

07:07:03.62 Relation 156 (SEMAPHORES)
07:07:03.62 process pointer page 0 of 1
07:07:03.62 Index 1 (PK_SEMAPHORES)
07:07:03.62 Index 2 (SEMAPHORES_TASK_UNQ)
07:07:03.62 Relation 156 (SEMAPHORES) is ok

07:07:03.62 Relation 157 (INVNT_TURNOVER_LOG)
07:07:03.62 process pointer page 0 of 2
07:07:03.68 process pointer page 1 of 2
07:07:03.68 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:07:03.70 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:07:03.70 Relation 160 (PERF_ESTIMATED)
07:07:03.70 process pointer page 0 of 2
07:07:03.73 process pointer page 1 of 2
07:07:03.73 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:07:03.76 Relation 160 (PERF_ESTIMATED) is ok

07:07:03.76 Relation 161 (PERF_ISQL_STAT)
07:07:03.76 process pointer page 0 of 1
07:07:03.76 Index 1 (PERF_ISQL_STAT_TRN)
07:07:03.76 Relation 161 (PERF_ISQL_STAT) is ok

07:07:03.76 Relation 162 (TRACE_STAT)
07:07:03.76 process pointer page 0 of 1
07:07:03.76 Relation 162 (TRACE_STAT) is ok

07:07:03.76 Relation 163 (PERF_LOG)
07:07:03.76 process pointer page 0 of 154
07:07:03.79 process pointer page 1 of 154
07:07:03.82 process pointer page 2 of 154
07:07:03.84 process pointer page 3 of 154
07:07:03.88 process pointer page 4 of 154
07:07:03.91 process pointer page 5 of 154
07:07:03.96 process pointer page 6 of 154
07:07:04.02 process pointer page 7 of 154
07:07:04.05 process pointer page 8 of 154
07:07:04.12 process pointer page 9 of 154
07:07:04.20 process pointer page 10 of 154
07:07:04.27 process pointer page 11 of 154
07:07:04.35 process pointer page 12 of 154
07:07:04.43 process pointer page 13 of 154
07:07:04.52 process pointer page 14 of 154
07:07:04.60 process pointer page 15 of 154
07:07:04.68 process pointer page 16 of 154
07:07:04.76 process pointer page 17 of 154
07:07:04.83 process pointer page 18 of 154
07:07:04.93 process pointer page 19 of 154
07:07:05.01 process pointer page 20 of 154
07:07:05.08 process pointer page 21 of 154
07:07:05.13 process pointer page 22 of 154
07:07:05.18 process pointer page 23 of 154
07:07:05.19 process pointer page 24 of 154
07:07:05.26 process pointer page 25 of 154
07:07:05.33 process pointer page 26 of 154
07:07:05.41 process pointer page 27 of 154
07:07:05.44 process pointer page 28 of 154
07:07:05.47 process pointer page 29 of 154
07:07:05.52 process pointer page 30 of 154
07:07:05.57 process pointer page 31 of 154
07:07:05.65 process pointer page 32 of 154
07:07:05.74 process pointer page 33 of 154
07:07:05.82 process pointer page 34 of 154
07:07:05.85 process pointer page 35 of 154
07:07:05.90 process pointer page 36 of 154
07:07:05.94 process pointer page 37 of 154
07:07:05.99 process pointer page 38 of 154
07:07:06.07 process pointer page 39 of 154
07:07:06.15 process pointer page 40 of 154
07:07:06.22 process pointer page 41 of 154
07:07:06.30 process pointer page 42 of 154
07:07:06.39 process pointer page 43 of 154
07:07:06.47 process pointer page 44 of 154
07:07:06.54 process pointer page 45 of 154
07:07:06.57 process pointer page 46 of 154
07:07:06.60 process pointer page 47 of 154
07:07:06.63 process pointer page 48 of 154
07:07:06.66 process pointer page 49 of 154
07:07:06.69 process pointer page 50 of 154
07:07:06.72 process pointer page 51 of 154
07:07:06.74 process pointer page 52 of 154
07:07:06.77 process pointer page 53 of 154
07:07:06.80 process pointer page 54 of 154
07:07:06.83 process pointer page 55 of 154
07:07:06.85 process pointer page 56 of 154
07:07:06.88 process pointer page 57 of 154
07:07:06.89 process pointer page 58 of 154
07:07:06.93 process pointer page 59 of 154
07:07:06.96 process pointer page 60 of 154
07:07:06.99 process pointer page 61 of 154
07:07:07.00 process pointer page 62 of 154
07:07:07.03 process pointer page 63 of 154
07:07:07.05 process pointer page 64 of 154
07:07:07.08 process pointer page 65 of 154
07:07:07.10 process pointer page 66 of 154
07:07:07.13 process pointer page 67 of 154
07:07:07.14 process pointer page 68 of 154
07:07:07.17 process pointer page 69 of 154
07:07:07.19 process pointer page 70 of 154
07:07:07.21 process pointer page 71 of 154
07:07:07.24 process pointer page 72 of 154
07:07:07.25 process pointer page 73 of 154
07:07:07.28 process pointer page 74 of 154
07:07:07.30 process pointer page 75 of 154
07:07:07.33 process pointer page 76 of 154
07:07:07.35 process pointer page 77 of 154
07:07:07.38 process pointer page 78 of 154
07:07:07.41 process pointer page 79 of 154
07:07:07.49 process pointer page 80 of 154
07:07:07.52 process pointer page 81 of 154
07:07:07.55 process pointer page 82 of 154
07:07:07.58 process pointer page 83 of 154
07:07:07.61 process pointer page 84 of 154
07:07:07.64 process pointer page 85 of 154
07:07:07.67 process pointer page 86 of 154
07:07:07.69 process pointer page 87 of 154
07:07:07.72 process pointer page 88 of 154
07:07:07.75 process pointer page 89 of 154
07:07:07.77 process pointer page 90 of 154
07:07:07.80 process pointer page 91 of 154
07:07:07.83 process pointer page 92 of 154
07:07:07.85 process pointer page 93 of 154
07:07:07.88 process pointer page 94 of 154
07:07:07.91 process pointer page 95 of 154
07:07:07.99 process pointer page 96 of 154
07:07:08.05 process pointer page 97 of 154
07:07:08.08 process pointer page 98 of 154
07:07:08.11 process pointer page 99 of 154
07:07:08.14 process pointer page 100 of 154
07:07:08.17 process pointer page 101 of 154
07:07:08.20 process pointer page 102 of 154
07:07:08.24 process pointer page 103 of 154
07:07:08.27 process pointer page 104 of 154
07:07:08.28 process pointer page 105 of 154
07:07:08.31 process pointer page 106 of 154
07:07:08.34 process pointer page 107 of 154
07:07:08.38 process pointer page 108 of 154
07:07:08.41 process pointer page 109 of 154
07:07:08.44 process pointer page 110 of 154
07:07:08.52 process pointer page 111 of 154
07:07:08.59 process pointer page 112 of 154
07:07:08.69 process pointer page 113 of 154
07:07:08.75 process pointer page 114 of 154
07:07:08.78 process pointer page 115 of 154
07:07:08.81 process pointer page 116 of 154
07:07:08.84 process pointer page 117 of 154
07:07:08.91 process pointer page 118 of 154
07:07:08.95 process pointer page 119 of 154
07:07:08.98 process pointer page 120 of 154
07:07:09.02 process pointer page 121 of 154
07:07:09.06 process pointer page 122 of 154
07:07:09.09 process pointer page 123 of 154
07:07:09.11 process pointer page 124 of 154
07:07:09.14 process pointer page 125 of 154
07:07:09.17 process pointer page 126 of 154
07:07:09.20 process pointer page 127 of 154
07:07:09.23 process pointer page 128 of 154
07:07:09.25 process pointer page 129 of 154
07:07:09.28 process pointer page 130 of 154
07:07:09.30 process pointer page 131 of 154
07:07:09.33 process pointer page 132 of 154
07:07:09.34 process pointer page 133 of 154
07:07:09.36 process pointer page 134 of 154
07:07:09.39 process pointer page 135 of 154
07:07:09.42 process pointer page 136 of 154
07:07:09.48 process pointer page 137 of 154
07:07:09.56 process pointer page 138 of 154
07:07:09.64 process pointer page 139 of 154
07:07:09.70 process pointer page 140 of 154
07:07:09.73 process pointer page 141 of 154
07:07:09.81 process pointer page 142 of 154
07:07:09.89 process pointer page 143 of 154
07:07:09.97 process pointer page 144 of 154
07:07:10.05 process pointer page 145 of 154
07:07:10.12 process pointer page 146 of 154
07:07:10.20 process pointer page 147 of 154
07:07:10.29 process pointer page 148 of 154
07:07:10.37 process pointer page 149 of 154
07:07:10.45 process pointer page 150 of 154
07:07:10.53 process pointer page 151 of 154
07:07:10.61 process pointer page 152 of 154
07:07:10.68 process pointer page 153 of 154
07:07:10.68 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:07:12.98 Index 2 (PERF_LOG_UNIT)
07:07:15.72 Index 3 (PERF_LOG_TRN_DESC)
07:07:17.14 Index 4 (PERF_LOG_GDSCODE)
07:07:18.50 Relation 163 (PERF_LOG) is ok

07:07:18.50 Relation 167 (V_STOPTEST)
07:07:18.50 Relation 167 (V_STOPTEST) is ok

07:07:18.50 Relation 184 (V_QDISTR_SOURCE)
07:07:18.50 Relation 184 (V_QDISTR_SOURCE) is ok

07:07:18.50 Relation 185 (V_QSTORNED_SOURCE)
07:07:18.50 Relation 185 (V_QSTORNED_SOURCE) is ok

07:07:18.50 Relation 260 (XQD_1000_1200)
07:07:18.52 process pointer page 0 of 2
07:07:18.66 process pointer page 1 of 2
07:07:18.66 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:07:18.69 Relation 260 (XQD_1000_1200) is ok

07:07:18.69 Relation 261 (XQD_1200_2000)
07:07:18.69 process pointer page 0 of 3
07:07:18.72 process pointer page 1 of 3
07:07:18.80 process pointer page 2 of 3
07:07:18.81 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:07:18.83 Relation 261 (XQD_1200_2000) is ok

07:07:18.83 Relation 262 (XQD_1000_3300)
07:07:18.83 process pointer page 0 of 12
07:07:18.86 process pointer page 1 of 12
07:07:18.91 process pointer page 2 of 12
07:07:18.97 process pointer page 3 of 12
07:07:19.02 process pointer page 4 of 12
07:07:19.05 process pointer page 5 of 12
07:07:19.12 process pointer page 6 of 12
07:07:19.23 process pointer page 7 of 12
07:07:19.31 process pointer page 8 of 12
07:07:19.41 process pointer page 9 of 12
07:07:19.50 process pointer page 10 of 12
07:07:19.58 process pointer page 11 of 12
07:07:19.62 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:07:19.84 Index 2 (XQD_1000_3300_DOC)
07:07:19.97 Relation 262 (XQD_1000_3300) is ok

07:07:19.97 Relation 263 (XQD_2000_3300)
07:07:19.97 process pointer page 0 of 17
07:07:20.00 process pointer page 1 of 17
07:07:20.03 process pointer page 2 of 17
07:07:20.06 process pointer page 3 of 17
07:07:20.09 process pointer page 4 of 17
07:07:20.12 process pointer page 5 of 17
07:07:20.17 process pointer page 6 of 17
07:07:20.20 process pointer page 7 of 17
07:07:20.23 process pointer page 8 of 17
07:07:20.28 process pointer page 9 of 17
07:07:20.31 process pointer page 10 of 17
07:07:20.34 process pointer page 11 of 17
07:07:20.37 process pointer page 12 of 17
07:07:20.40 process pointer page 13 of 17
07:07:20.43 process pointer page 14 of 17
07:07:20.47 process pointer page 15 of 17
07:07:20.48 process pointer page 16 of 17
07:07:20.50 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:07:20.67 Relation 263 (XQD_2000_3300) is ok

07:07:20.67 Relation 264 (XQD_2100_3300)
07:07:20.67 process pointer page 0 of 3
07:07:20.73 process pointer page 1 of 3
07:07:20.75 process pointer page 2 of 3
07:07:20.75 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:07:20.75 Relation 264 (XQD_2100_3300) is ok

07:07:20.75 Relation 265 (XQD_3300_3400)
07:07:20.75 process pointer page 0 of 23
07:07:20.78 process pointer page 1 of 23
07:07:20.81 process pointer page 2 of 23
07:07:20.84 process pointer page 3 of 23
07:07:20.86 process pointer page 4 of 23
07:07:20.89 process pointer page 5 of 23
07:07:20.92 process pointer page 6 of 23
07:07:20.93 process pointer page 7 of 23
07:07:20.97 process pointer page 8 of 23
07:07:21.00 process pointer page 9 of 23
07:07:21.03 process pointer page 10 of 23
07:07:21.06 process pointer page 11 of 23
07:07:21.09 process pointer page 12 of 23
07:07:21.12 process pointer page 13 of 23
07:07:21.15 process pointer page 14 of 23
07:07:21.17 process pointer page 15 of 23
07:07:21.20 process pointer page 16 of 23
07:07:21.23 process pointer page 17 of 23
07:07:21.25 process pointer page 18 of 23
07:07:21.28 process pointer page 19 of 23
07:07:21.31 process pointer page 20 of 23
07:07:21.34 process pointer page 21 of 23
07:07:21.36 process pointer page 22 of 23
07:07:21.37 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:07:21.92 Relation 265 (XQD_3300_3400) is ok

07:07:21.92 Relation 266 (XQS_1000_1200)
07:07:21.92 process pointer page 0 of 44
07:07:21.95 process pointer page 1 of 44
07:07:21.98 process pointer page 2 of 44
07:07:22.03 process pointer page 3 of 44
07:07:22.06 process pointer page 4 of 44
07:07:22.09 process pointer page 5 of 44
07:07:22.12 process pointer page 6 of 44
07:07:22.15 process pointer page 7 of 44
07:07:22.18 process pointer page 8 of 44
07:07:22.21 process pointer page 9 of 44
07:07:22.24 process pointer page 10 of 44
07:07:22.28 process pointer page 11 of 44
07:07:22.31 process pointer page 12 of 44
07:07:22.34 process pointer page 13 of 44
07:07:22.37 process pointer page 14 of 44
07:07:22.40 process pointer page 15 of 44
07:07:22.43 process pointer page 16 of 44
07:07:22.46 process pointer page 17 of 44
07:07:22.49 process pointer page 18 of 44
07:07:22.51 process pointer page 19 of 44
07:07:22.54 process pointer page 20 of 44
07:07:22.57 process pointer page 21 of 44
07:07:22.60 process pointer page 22 of 44
07:07:22.63 process pointer page 23 of 44
07:07:22.67 process pointer page 24 of 44
07:07:22.70 process pointer page 25 of 44
07:07:22.73 process pointer page 26 of 44
07:07:22.76 process pointer page 27 of 44
07:07:22.79 process pointer page 28 of 44
07:07:22.82 process pointer page 29 of 44
07:07:22.85 process pointer page 30 of 44
07:07:22.88 process pointer page 31 of 44
07:07:22.92 process pointer page 32 of 44
07:07:22.96 process pointer page 33 of 44
07:07:23.04 process pointer page 34 of 44
07:07:23.13 process pointer page 35 of 44
07:07:23.27 process pointer page 36 of 44
07:07:23.55 process pointer page 37 of 44
07:07:23.85 process pointer page 38 of 44
07:07:24.13 process pointer page 39 of 44
07:07:24.40 process pointer page 40 of 44
07:07:24.72 process pointer page 41 of 44
07:07:25.04 process pointer page 42 of 44
07:07:25.36 process pointer page 43 of 44
07:07:25.41 Index 1 (XQS_1000_1200_DOC_ID)
07:07:27.39 Index 2 (XQS_1000_1200_SND_ID)
07:07:29.26 Index 3 (XQS_1000_1200_RCV_ID)
07:07:31.17 Relation 266 (XQS_1000_1200) is ok

07:07:31.17 Relation 267 (XQS_1200_2000)
07:07:31.17 process pointer page 0 of 47
07:07:31.53 process pointer page 1 of 47
07:07:31.76 process pointer page 2 of 47
07:07:32.03 process pointer page 3 of 47
07:07:32.35 process pointer page 4 of 47
07:07:32.74 process pointer page 5 of 47
07:07:33.16 process pointer page 6 of 47
07:07:33.45 process pointer page 7 of 47
07:07:33.79 process pointer page 8 of 47
07:07:34.15 process pointer page 9 of 47
07:07:34.57 process pointer page 10 of 47
07:07:35.04 process pointer page 11 of 47
07:07:35.46 process pointer page 12 of 47
07:07:35.89 process pointer page 13 of 47
07:07:36.32 process pointer page 14 of 47
07:07:36.72 process pointer page 15 of 47
07:07:37.14 process pointer page 16 of 47
07:07:37.59 process pointer page 17 of 47
07:07:38.06 process pointer page 18 of 47
07:07:38.45 process pointer page 19 of 47
07:07:38.87 process pointer page 20 of 47
07:07:39.20 process pointer page 21 of 47
07:07:39.64 process pointer page 22 of 47
07:07:40.03 process pointer page 23 of 47
07:07:40.34 process pointer page 24 of 47
07:07:40.78 process pointer page 25 of 47
07:07:41.25 process pointer page 26 of 47
07:07:41.62 process pointer page 27 of 47
07:07:42.09 process pointer page 28 of 47
07:07:42.54 process pointer page 29 of 47
07:07:43.01 process pointer page 30 of 47
07:07:43.48 process pointer page 31 of 47
07:07:43.94 process pointer page 32 of 47
07:07:44.38 process pointer page 33 of 47
07:07:44.79 process pointer page 34 of 47
07:07:45.13 process pointer page 35 of 47
07:07:45.52 process pointer page 36 of 47
07:07:45.99 process pointer page 37 of 47
07:07:46.47 process pointer page 38 of 47
07:07:46.95 process pointer page 39 of 47
07:07:47.34 process pointer page 40 of 47
07:07:47.75 process pointer page 41 of 47
07:07:48.05 process pointer page 42 of 47
07:07:48.39 process pointer page 43 of 47
07:07:48.80 process pointer page 44 of 47
07:07:49.11 process pointer page 45 of 47
07:07:49.45 process pointer page 46 of 47
07:07:49.73 Index 1 (XQS_1200_2000_DOC_ID)
07:07:52.29 Index 2 (XQS_1200_2000_SND_ID)
07:07:54.71 Index 3 (XQS_1200_2000_RCV_ID)
07:07:56.77 Relation 267 (XQS_1200_2000) is ok

07:07:56.77 Relation 268 (XQS_1000_3300)
07:07:56.77 process pointer page 0 of 22
07:07:57.19 process pointer page 1 of 22
07:07:57.61 process pointer page 2 of 22
07:07:58.09 process pointer page 3 of 22
07:07:58.48 process pointer page 4 of 22
07:07:58.89 process pointer page 5 of 22
07:07:59.36 process pointer page 6 of 22
07:07:59.86 process pointer page 7 of 22
07:08:00.28 process pointer page 8 of 22
07:08:00.78 process pointer page 9 of 22
07:08:01.12 process pointer page 10 of 22
07:08:01.53 process pointer page 11 of 22
07:08:01.99 process pointer page 12 of 22
07:08:02.46 process pointer page 13 of 22
07:08:02.94 process pointer page 14 of 22
07:08:03.43 process pointer page 15 of 22
07:08:03.91 process pointer page 16 of 22
07:08:04.40 process pointer page 17 of 22
07:08:04.88 process pointer page 18 of 22
07:08:05.35 process pointer page 19 of 22
07:08:05.80 process pointer page 20 of 22
07:08:06.21 process pointer page 21 of 22
07:08:06.41 Index 1 (XQS_1000_3300_DOC_ID)
07:08:07.33 Index 2 (XQS_1000_3300_SND_ID)
07:08:08.59 Index 3 (XQS_1000_3300_RCV_ID)
07:08:10.20 Relation 268 (XQS_1000_3300) is ok

07:08:10.20 Relation 269 (XQS_2000_3300)
07:08:10.20 process pointer page 0 of 1
07:08:10.20 Index 1 (XQS_2000_3300_DOC_ID)
07:08:10.20 Index 2 (XQS_2000_3300_SND_ID)
07:08:10.20 Index 3 (XQS_2000_3300_RCV_ID)
07:08:10.20 Relation 269 (XQS_2000_3300) is ok

07:08:10.20 Relation 270 (XQS_2100_3300)
07:08:10.20 process pointer page 0 of 32
07:08:10.70 process pointer page 1 of 32
07:08:11.18 process pointer page 2 of 32
07:08:11.67 process pointer page 3 of 32
07:08:12.16 process pointer page 4 of 32
07:08:12.65 process pointer page 5 of 32
07:08:13.16 process pointer page 6 of 32
07:08:13.60 process pointer page 7 of 32
07:08:14.04 process pointer page 8 of 32
07:08:14.43 process pointer page 9 of 32
07:08:14.85 process pointer page 10 of 32
07:08:15.32 process pointer page 11 of 32
07:08:15.78 process pointer page 12 of 32
07:08:16.28 process pointer page 13 of 32
07:08:16.75 process pointer page 14 of 32
07:08:17.09 process pointer page 15 of 32
07:08:17.56 process pointer page 16 of 32
07:08:18.06 process pointer page 17 of 32
07:08:18.42 process pointer page 18 of 32
07:08:18.93 process pointer page 19 of 32
07:08:19.32 process pointer page 20 of 32
07:08:19.79 process pointer page 21 of 32
07:08:20.28 process pointer page 22 of 32
07:08:20.76 process pointer page 23 of 32
07:08:21.29 process pointer page 24 of 32
07:08:21.68 process pointer page 25 of 32
07:08:22.05 process pointer page 26 of 32
07:08:22.49 process pointer page 27 of 32
07:08:22.94 process pointer page 28 of 32
07:08:23.40 process pointer page 29 of 32
07:08:23.85 process pointer page 30 of 32
07:08:24.22 process pointer page 31 of 32
07:08:24.30 Index 1 (XQS_2100_3300_DOC_ID)
07:08:25.77 Index 2 (XQS_2100_3300_SND_ID)
07:08:27.22 Index 3 (XQS_2100_3300_RCV_ID)
07:08:29.20 Relation 270 (XQS_2100_3300) is ok

07:08:29.20 Relation 271 (XQS_3300_3400)
07:08:29.20 process pointer page 0 of 6
07:08:29.65 process pointer page 1 of 6
07:08:30.06 process pointer page 2 of 6
07:08:30.53 process pointer page 3 of 6
07:08:31.04 process pointer page 4 of 6
07:08:31.52 process pointer page 5 of 6
07:08:31.96 Index 1 (XQS_3300_3400_DOC_ID)
07:08:32.38 Index 2 (XQS_3300_3400_SND_ID)
07:08:32.82 Relation 271 (XQS_3300_3400) is ok

07:08:32.85 Validation finished
Done for 92700 ms, from 7:07:00.23 to 7:08:32.93.

Differences between old and current firebird.log

7:08:34.94. 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:
2017-07-12 07:08 471 oltp30_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Jul 12 07:07:00 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Jul 12 07:08:32 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp30


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.
2017-07-12 7:08:41.27 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html