|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 179 minutes:  | 
 6044.89  | 
 3722  | 
 1082036  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  customer order: creation  | 
 448.89  | 
 515  | 
 80352  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  customer order: refuse  | 
 36.10  | 
 264  | 
 6462  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  order to supplier: creation  | 
 113.96  | 
 2281  | 
 20399  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  order to supplier: removal  | 
 3.07  | 
 21890  | 
 550  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  invoice (draft): creation  | 
 112.85  | 
 3394  | 
 20201  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  invoice (draft): removal  | 
 42.33  | 
 491  | 
 7577  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  invoice accept: apply  | 
 64.56  | 
 12619  | 
 11557  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  invoice accept: cancel  | 
 19.16  | 
 2799  | 
 3429  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  customer reserve: creation  | 
 3487.31  | 
 193  | 
 624229  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  customer reserve: removal  | 
 1104.23  | 
 70  | 
 197657  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  realization accept: apply  | 
 203.96  | 
 601  | 
 36509  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  realization accept: cancel  | 
 87.56  | 
 171  | 
 15674  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  payment from customer: creation  | 
 149.61  | 
 978  | 
 26780  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  payment from customer: removal  | 
 13.11  | 
 146  | 
 2346  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  payment to supplier: creation  | 
 123.77  | 
 761  | 
 22155  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  payment to supplier: removal  | 
 8.44  | 
 161  | 
 1511  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  service: total inventory turnovers  | 
 8.44  | 
 3474  | 
 1511  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  service: total monetary turnovers  | 
 17.46  | 
 70  | 
 3125  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 19849  | 
 12  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
 
Done for 103220 ms, from  6:49:36.21 to  6:51:19.43.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4569  | 
 95345  | 
 82236  | 
 13109  | 
 13.75  | 
 03:46:49  | 
 04:04:49  | 
|  interval #   2, overall  | 
 2  | 
 5617  | 
 114163  | 
 101103  | 
 13060  | 
 11.44  | 
 04:04:50  | 
 04:22:50  | 
|  interval #   3, overall  | 
 3  | 
 5694  | 
 113309  | 
 102493  | 
 10816  | 
 9.55  | 
 04:22:51  | 
 04:40:51  | 
|  interval #   4, overall  | 
 4  | 
 6094  | 
 122652  | 
 109697  | 
 12955  | 
 10.56  | 
 04:40:52  | 
 04:58:52  | 
|  interval #   5, overall  | 
 5  | 
 6632  | 
 137522  | 
 119372  | 
 18150  | 
 13.20  | 
 04:58:53  | 
 05:16:53  | 
|  interval #   6, overall  | 
 6  | 
 6599  | 
 136112  | 
 118789  | 
 17323  | 
 12.73  | 
 05:16:54  | 
 05:34:54  | 
|  interval #   7, overall  | 
 7  | 
 6139  | 
 120239  | 
 110494  | 
 9745  | 
 8.10  | 
 05:34:55  | 
 05:52:55  | 
|  interval #   8, overall  | 
 8  | 
 6624  | 
 132980  | 
 119235  | 
 13745  | 
 10.34  | 
 05:52:56  | 
 06:10:56  | 
|  interval #   9, overall  | 
 9  | 
 6395  | 
 129703  | 
 115112  | 
 14591  | 
 11.25  | 
 06:10:57  | 
 06:28:57  | 
|  interval #  10, overall  | 
 10  | 
 5750  | 
 111879  | 
 103505  | 
 8374  | 
 7.48  | 
 06:28:58  | 
 06:46:58  | 
 
Done for 222780 ms, from  6:55:05.98 to  6:58:48.76.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 1852.83  | 
 0.0005  | 
 2.0622  | 
 3155  | 
 25  | 
|  TEST_TIME  | 
 2  | 
 2836.69  | 
 0.6736  | 
 1.2844  | 
 1540  | 
 100  | 
|  TEST_TIME  | 
 3  | 
 3038.02  | 
 0.7996  | 
 1.2339  | 
 1793  | 
 100  | 
|  TEST_TIME  | 
 4  | 
 3239.60  | 
 0.8685  | 
 1.1223  | 
 1477  | 
 100  | 
|  TEST_TIME  | 
 5  | 
 3246.74  | 
 0.8960  | 
 1.1149  | 
 1236  | 
 100  | 
|  TEST_TIME  | 
 6  | 
 3377.57  | 
 0.8937  | 
 1.0869  | 
 1711  | 
 100  | 
|  TEST_TIME  | 
 7  | 
 3421.43  | 
 0.9200  | 
 1.0865  | 
 1461  | 
 100  | 
|  TEST_TIME  | 
 8  | 
 3534.56  | 
 0.9224  | 
 1.0700  | 
 1645  | 
 100  | 
|  TEST_TIME  | 
 9  | 
 3683.33  | 
 0.9233  | 
 1.0666  | 
 1861  | 
 100  | 
|  TEST_TIME  | 
 10  | 
 3805.94  | 
 0.9298  | 
 1.0709  | 
 1861  | 
 100  | 
|  TEST_TIME  | 
 11  | 
 3967.91  | 
 0.9338  | 
 1.0518  | 
 1756  | 
 100  | 
|  TEST_TIME  | 
 12  | 
 4013.89  | 
 0.9531  | 
 1.0473  | 
 1412  | 
 100  | 
|  TEST_TIME  | 
 13  | 
 4076.34  | 
 0.9520  | 
 1.0518  | 
 1525  | 
 100  | 
|  TEST_TIME  | 
 14  | 
 4164.13  | 
 0.9562  | 
 1.0433  | 
 1433  | 
 100  | 
|  TEST_TIME  | 
 15  | 
 4312.62  | 
 0.9416  | 
 1.0388  | 
 1966  | 
 100  | 
|  TEST_TIME  | 
 16  | 
 4429.49  | 
 0.9481  | 
 1.0436  | 
 2028  | 
 100  | 
|  TEST_TIME  | 
 17  | 
 4482.43  | 
 0.9708  | 
 1.0171  | 
 1784  | 
 100  | 
|  TEST_TIME  | 
 18  | 
 4409.34  | 
 0.9766  | 
 1.0429  | 
 1230  | 
 98  | 
|  TEST_TIME  | 
 19  | 
 4528.17  | 
 0.9621  | 
 1.0355  | 
 1728  | 
 100  | 
|  TEST_TIME  | 
 20  | 
 4553.27  | 
 0.9783  | 
 1.0146  | 
 1737  | 
 100  | 
|  TEST_TIME  | 
 21  | 
 4461.91  | 
 0.9861  | 
 1.0350  | 
 1318  | 
 98  | 
|  TEST_TIME  | 
 22  | 
 4487.96  | 
 0.9822  | 
 1.0290  | 
 1727  | 
 100  | 
|  TEST_TIME  | 
 23  | 
 4507.80  | 
 0.9799  | 
 1.0296  | 
 1474  | 
 100  | 
|  TEST_TIME  | 
 24  | 
 4559.96  | 
 0.9754  | 
 1.0275  | 
 1792  | 
 100  | 
|  TEST_TIME  | 
 25  | 
 4604.55  | 
 0.9770  | 
 1.0258  | 
 1651  | 
 100  | 
|  TEST_TIME  | 
 26  | 
 4655.16  | 
 0.9762  | 
 1.0270  | 
 1311  | 
 100  | 
|  TEST_TIME  | 
 27  | 
 4698.51  | 
 0.9799  | 
 1.0167  | 
 1506  | 
 100  | 
|  TEST_TIME  | 
 28  | 
 4721.53  | 
 0.9756  | 
 1.0193  | 
 1364  | 
 100  | 
|  TEST_TIME  | 
 29  | 
 4746.66  | 
 0.9790  | 
 1.0190  | 
 1401  | 
 100  | 
|  TEST_TIME  | 
 30  | 
 4782.66  | 
 0.9787  | 
 1.0246  | 
 2008  | 
 99  | 
|  TEST_TIME  | 
 31  | 
 4841.04  | 
 0.9800  | 
 1.0157  | 
 1736  | 
 100  | 
|  TEST_TIME  | 
 32  | 
 4824.47  | 
 0.9873  | 
 1.0137  | 
 2020  | 
 93  | 
|  TEST_TIME  | 
 33  | 
 4813.88  | 
 0.9852  | 
 1.0258  | 
 1705  | 
 91  | 
|  TEST_TIME  | 
 34  | 
 4932.11  | 
 0.9723  | 
 1.0230  | 
 1636  | 
 100  | 
|  TEST_TIME  | 
 35  | 
 4984.07  | 
 0.9834  | 
 1.0148  | 
 1691  | 
 100  | 
|  TEST_TIME  | 
 36  | 
 5022.89  | 
 0.9790  | 
 1.0153  | 
 1599  | 
 100  | 
|  TEST_TIME  | 
 37  | 
 5043.65  | 
 0.9837  | 
 1.0137  | 
 1604  | 
 98  | 
|  TEST_TIME  | 
 38  | 
 5044.07  | 
 0.9869  | 
 1.0122  | 
 1221  | 
 99  | 
|  TEST_TIME  | 
 39  | 
 5008.07  | 
 0.9933  | 
 1.0078  | 
 1476  | 
 98  | 
|  TEST_TIME  | 
 40  | 
 5001.28  | 
 0.9840  | 
 1.0131  | 
 1404  | 
 98  | 
|  TEST_TIME  | 
 41  | 
 4986.36  | 
 0.9914  | 
 1.0181  | 
 1340  | 
 100  | 
|  TEST_TIME  | 
 42  | 
 5029.69  | 
 0.9853  | 
 1.0163  | 
 1225  | 
 100  | 
|  TEST_TIME  | 
 43  | 
 5042.13  | 
 0.9902  | 
 1.0141  | 
 1480  | 
 100  | 
|  TEST_TIME  | 
 44  | 
 5052.84  | 
 0.9890  | 
 1.0115  | 
 1289  | 
 100  | 
|  TEST_TIME  | 
 45  | 
 5056.21  | 
 0.9884  | 
 1.0098  | 
 1963  | 
 99  | 
|  TEST_TIME  | 
 46  | 
 5066.96  | 
 0.9858  | 
 1.0184  | 
 2196  | 
 97  | 
|  TEST_TIME  | 
 47  | 
 5104.45  | 
 0.9894  | 
 1.0097  | 
 2201  | 
 98  | 
|  TEST_TIME  | 
 48  | 
 5106.61  | 
 0.9882  | 
 1.0129  | 
 1929  | 
 98  | 
|  TEST_TIME  | 
 49  | 
 5143.50  | 
 0.9851  | 
 1.0117  | 
 1499  | 
 99  | 
|  TEST_TIME  | 
 50  | 
 5153.96  | 
 0.9894  | 
 1.0176  | 
 1786  | 
 100  | 
|  TEST_TIME  | 
 51  | 
 5193.79  | 
 0.9905  | 
 1.0075  | 
 1704  | 
 100  | 
|  TEST_TIME  | 
 52  | 
 5180.51  | 
 0.9907  | 
 1.0101  | 
 1752  | 
 99  | 
|  TEST_TIME  | 
 53  | 
 5207.49  | 
 0.9859  | 
 1.0095  | 
 1529  | 
 100  | 
|  TEST_TIME  | 
 54  | 
 5249.68  | 
 0.9851  | 
 1.0108  | 
 1419  | 
 100  | 
|  TEST_TIME  | 
 55  | 
 5256.97  | 
 0.9911  | 
 1.0096  | 
 1270  | 
 100  | 
|  TEST_TIME  | 
 56  | 
 5261.08  | 
 0.9910  | 
 1.0114  | 
 1429  | 
 100  | 
|  TEST_TIME  | 
 57  | 
 5265.19  | 
 0.9929  | 
 1.0115  | 
 1241  | 
 100  | 
|  TEST_TIME  | 
 58  | 
 5277.33  | 
 0.9918  | 
 1.0119  | 
 1335  | 
 100  | 
|  TEST_TIME  | 
 59  | 
 5284.34  | 
 0.9934  | 
 1.0073  | 
 1267  | 
 100  | 
|  TEST_TIME  | 
 60  | 
 5269.93  | 
 0.9935  | 
 1.0106  | 
 1250  | 
 100  | 
|  TEST_TIME  | 
 61  | 
 5284.09  | 
 0.9914  | 
 1.0111  | 
 1971  | 
 99  | 
|  TEST_TIME  | 
 62  | 
 5307.83  | 
 0.9904  | 
 1.0104  | 
 1782  | 
 97  | 
|  TEST_TIME  | 
 63  | 
 5332.70  | 
 0.9897  | 
 1.0119  | 
 1393  | 
 100  | 
|  TEST_TIME  | 
 64  | 
 5352.30  | 
 0.9925  | 
 1.0072  | 
 1843  | 
 99  | 
|  TEST_TIME  | 
 65  | 
 5350.94  | 
 0.9919  | 
 1.0098  | 
 1855  | 
 97  | 
|  TEST_TIME  | 
 66  | 
 5374.95  | 
 0.9900  | 
 1.0125  | 
 1628  | 
 100  | 
|  TEST_TIME  | 
 67  | 
 5421.54  | 
 0.9892  | 
 1.0081  | 
 1371  | 
 100  | 
|  TEST_TIME  | 
 68  | 
 5437.06  | 
 0.9905  | 
 1.0087  | 
 1415  | 
 100  | 
|  TEST_TIME  | 
 69  | 
 5459.21  | 
 0.9901  | 
 1.0105  | 
 1438  | 
 100  | 
|  TEST_TIME  | 
 70  | 
 5479.69  | 
 0.9924  | 
 1.0069  | 
 1385  | 
 100  | 
|  TEST_TIME  | 
 71  | 
 5462.45  | 
 0.9958  | 
 1.0045  | 
 1557  | 
 99  | 
|  TEST_TIME  | 
 72  | 
 5447.31  | 
 0.9934  | 
 1.0061  | 
 1391  | 
 97  | 
|  TEST_TIME  | 
 73  | 
 5476.66  | 
 0.9891  | 
 1.0066  | 
 1171  | 
 100  | 
|  TEST_TIME  | 
 74  | 
 5483.98  | 
 0.9917  | 
 1.0064  | 
 1286  | 
 100  | 
|  TEST_TIME  | 
 75  | 
 5484.14  | 
 0.9929  | 
 1.0059  | 
 2125  | 
 100  | 
|  TEST_TIME  | 
 76  | 
 5514.15  | 
 0.9873  | 
 1.0109  | 
 1693  | 
 100  | 
|  TEST_TIME  | 
 77  | 
 5551.65  | 
 0.9922  | 
 1.0071  | 
 1740  | 
 100  | 
|  TEST_TIME  | 
 78  | 
 5547.80  | 
 0.9949  | 
 1.0099  | 
 1615  | 
 99  | 
|  TEST_TIME  | 
 79  | 
 5571.36  | 
 0.9929  | 
 1.0087  | 
 1640  | 
 100  | 
|  TEST_TIME  | 
 80  | 
 5590.32  | 
 0.9927  | 
 1.0057  | 
 1717  | 
 100  | 
|  TEST_TIME  | 
 81  | 
 5573.91  | 
 0.9963  | 
 1.0062  | 
 1568  | 
 95  | 
|  TEST_TIME  | 
 82  | 
 5564.68  | 
 0.9956  | 
 1.0063  | 
 1592  | 
 89  | 
|  TEST_TIME  | 
 83  | 
 5597.01  | 
 0.9885  | 
 1.0081  | 
 1076  | 
 99  | 
|  TEST_TIME  | 
 84  | 
 5621.99  | 
 0.9928  | 
 1.0073  | 
 1118  | 
 100  | 
|  TEST_TIME  | 
 85  | 
 5629.98  | 
 0.9941  | 
 1.0065  | 
 1414  | 
 100  | 
|  TEST_TIME  | 
 86  | 
 5639.75  | 
 0.9931  | 
 1.0078  | 
 1257  | 
 100  | 
|  TEST_TIME  | 
 87  | 
 5657.65  | 
 0.9931  | 
 1.0060  | 
 1170  | 
 100  | 
|  TEST_TIME  | 
 88  | 
 5656.66  | 
 0.9947  | 
 1.0061  | 
 1158  | 
 100  | 
|  TEST_TIME  | 
 89  | 
 5659.17  | 
 0.9944  | 
 1.0053  | 
 1222  | 
 100  | 
|  TEST_TIME  | 
 90  | 
 5677.21  | 
 0.9910  | 
 1.0088  | 
 2045  | 
 100  | 
|  TEST_TIME  | 
 91  | 
 5718.54  | 
 0.9905  | 
 1.0093  | 
 1841  | 
 100  | 
|  TEST_TIME  | 
 92  | 
 5749.64  | 
 0.9929  | 
 1.0070  | 
 1886  | 
 99  | 
|  TEST_TIME  | 
 93  | 
 5750.68  | 
 0.9960  | 
 1.0062  | 
 1815  | 
 96  | 
|  TEST_TIME  | 
 94  | 
 5758.94  | 
 0.9945  | 
 1.0069  | 
 1441  | 
 98  | 
|  TEST_TIME  | 
 95  | 
 5759.08  | 
 0.9963  | 
 1.0059  | 
 1523  | 
 100  | 
|  TEST_TIME  | 
 96  | 
 5752.10  | 
 0.9966  | 
 1.0057  | 
 1411  | 
 98  | 
|  TEST_TIME  | 
 97  | 
 5746.45  | 
 0.9967  | 
 1.0074  | 
 1369  | 
 100  | 
|  TEST_TIME  | 
 98  | 
 5756.03  | 
 0.9955  | 
 1.0030  | 
 1479  | 
 99  | 
|  TEST_TIME  | 
 99  | 
 5767.24  | 
 0.9954  | 
 1.0048  | 
 1085  | 
 100  | 
|  TEST_TIME  | 
 100  | 
 5748.47  | 
 0.9980  | 
 1.0024  | 
 1349  | 
 99  | 
|  TEST_TIME  | 
 101  | 
 5734.39  | 
 0.9950  | 
 1.0035  | 
 1303  | 
 92  | 
|  TEST_TIME  | 
 102  | 
 5740.42  | 
 0.9926  | 
 1.0044  | 
 1076  | 
 97  | 
|  TEST_TIME  | 
 103  | 
 5762.31  | 
 0.9942  | 
 1.0044  | 
 1125  | 
 100  | 
|  TEST_TIME  | 
 104  | 
 5755.92  | 
 0.9958  | 
 1.0054  | 
 1028  | 
 99  | 
|  TEST_TIME  | 
 105  | 
 5770.57  | 
 0.9933  | 
 1.0075  | 
 1578  | 
 100  | 
|  TEST_TIME  | 
 106  | 
 5794.49  | 
 0.9941  | 
 1.0055  | 
 1976  | 
 100  | 
|  TEST_TIME  | 
 107  | 
 5823.28  | 
 0.9927  | 
 1.0041  | 
 1770  | 
 100  | 
|  TEST_TIME  | 
 108  | 
 5822.41  | 
 0.9949  | 
 1.0089  | 
 1620  | 
 99  | 
|  TEST_TIME  | 
 109  | 
 5850.86  | 
 0.9948  | 
 1.0033  | 
 1626  | 
 100  | 
|  TEST_TIME  | 
 110  | 
 5873.37  | 
 0.9904  | 
 1.0050  | 
 1579  | 
 100  | 
|  TEST_TIME  | 
 111  | 
 5867.22  | 
 0.9970  | 
 1.0040  | 
 1688  | 
 97  | 
|  TEST_TIME  | 
 112  | 
 5860.82  | 
 0.9961  | 
 1.0043  | 
 1485  | 
 94  | 
|  TEST_TIME  | 
 113  | 
 5881.11  | 
 0.9920  | 
 1.0066  | 
 1173  | 
 99  | 
|  TEST_TIME  | 
 114  | 
 5879.17  | 
 0.9981  | 
 1.0027  | 
 1309  | 
 99  | 
|  TEST_TIME  | 
 115  | 
 5872.40  | 
 0.9951  | 
 1.0056  | 
 1327  | 
 98  | 
|  TEST_TIME  | 
 116  | 
 5869.34  | 
 0.9975  | 
 1.0035  | 
 1358  | 
 97  | 
|  TEST_TIME  | 
 117  | 
 5857.00  | 
 0.9970  | 
 1.0038  | 
 1222  | 
 89  | 
|  TEST_TIME  | 
 118  | 
 5855.02  | 
 0.9957  | 
 1.0060  | 
 962  | 
 94  | 
|  TEST_TIME  | 
 119  | 
 5861.60  | 
 0.9964  | 
 1.0017  | 
 1139  | 
 100  | 
|  TEST_TIME  | 
 120  | 
 5854.60  | 
 0.9946  | 
 1.0030  | 
 1712  | 
 99  | 
|  TEST_TIME  | 
 121  | 
 5857.09  | 
 0.9943  | 
 1.0056  | 
 1650  | 
 93  | 
|  TEST_TIME  | 
 122  | 
 5872.47  | 
 0.9948  | 
 1.0039  | 
 1593  | 
 95  | 
|  TEST_TIME  | 
 123  | 
 5878.01  | 
 0.9948  | 
 1.0045  | 
 1482  | 
 94  | 
|  TEST_TIME  | 
 124  | 
 5873.00  | 
 0.9973  | 
 1.0043  | 
 1158  | 
 96  | 
|  TEST_TIME  | 
 125  | 
 5868.16  | 
 0.9971  | 
 1.0060  | 
 1522  | 
 95  | 
|  TEST_TIME  | 
 126  | 
 5871.46  | 
 0.9974  | 
 1.0039  | 
 1292  | 
 96  | 
|  TEST_TIME  | 
 127  | 
 5891.09  | 
 0.9926  | 
 1.0042  | 
 1099  | 
 100  | 
|  TEST_TIME  | 
 128  | 
 5896.12  | 
 0.9955  | 
 1.0054  | 
 1274  | 
 100  | 
|  TEST_TIME  | 
 129  | 
 5907.74  | 
 0.9957  | 
 1.0041  | 
 1311  | 
 100  | 
|  TEST_TIME  | 
 130  | 
 5914.00  | 
 0.9953  | 
 1.0061  | 
 1226  | 
 100  | 
|  TEST_TIME  | 
 131  | 
 5930.75  | 
 0.9959  | 
 1.0038  | 
 1121  | 
 100  | 
|  TEST_TIME  | 
 132  | 
 5938.17  | 
 0.9950  | 
 1.0053  | 
 1018  | 
 99  | 
|  TEST_TIME  | 
 133  | 
 5947.56  | 
 0.9961  | 
 1.0040  | 
 1062  | 
 100  | 
|  TEST_TIME  | 
 134  | 
 5950.41  | 
 0.9960  | 
 1.0034  | 
 1132  | 
 100  | 
|  TEST_TIME  | 
 135  | 
 5953.53  | 
 0.9955  | 
 1.0065  | 
 1368  | 
 100  | 
|  TEST_TIME  | 
 136  | 
 5969.88  | 
 0.9964  | 
 1.0037  | 
 1647  | 
 98  | 
|  TEST_TIME  | 
 137  | 
 5979.10  | 
 0.9948  | 
 1.0046  | 
 1278  | 
 99  | 
|  TEST_TIME  | 
 138  | 
 5997.74  | 
 0.9942  | 
 1.0035  | 
 1571  | 
 100  | 
|  TEST_TIME  | 
 139  | 
 5990.26  | 
 0.9975  | 
 1.0032  | 
 1522  | 
 92  | 
|  TEST_TIME  | 
 140  | 
 5995.02  | 
 0.9953  | 
 1.0056  | 
 1385  | 
 98  | 
|  TEST_TIME  | 
 141  | 
 6001.10  | 
 0.9975  | 
 1.0039  | 
 1464  | 
 98  | 
|  TEST_TIME  | 
 142  | 
 6009.59  | 
 0.9954  | 
 1.0021  | 
 1338  | 
 99  | 
|  TEST_TIME  | 
 143  | 
 5984.26  | 
 0.9993  | 
 1.0007  | 
 907  | 
 71  | 
|  TEST_TIME  | 
 144  | 
 5977.11  | 
 0.9962  | 
 1.0016  | 
 1409  | 
 90  | 
|  TEST_TIME  | 
 145  | 
 5963.79  | 
 0.9969  | 
 1.0051  | 
 1048  | 
 92  | 
|  TEST_TIME  | 
 146  | 
 5961.28  | 
 0.9986  | 
 1.0032  | 
 1122  | 
 99  | 
|  TEST_TIME  | 
 147  | 
 5950.86  | 
 0.9981  | 
 1.0016  | 
 1368  | 
 100  | 
|  TEST_TIME  | 
 148  | 
 5945.05  | 
 0.9958  | 
 1.0036  | 
 1032  | 
 98  | 
|  TEST_TIME  | 
 149  | 
 5971.45  | 
 0.9925  | 
 1.0026  | 
 969  | 
 100  | 
|  TEST_TIME  | 
 150  | 
 5975.03  | 
 0.9953  | 
 1.0037  | 
 1865  | 
 100  | 
|  TEST_TIME  | 
 151  | 
 5974.82  | 
 0.9971  | 
 1.0034  | 
 1820  | 
 91  | 
|  TEST_TIME  | 
 152  | 
 6000.55  | 
 0.9946  | 
 1.0030  | 
 1449  | 
 92  | 
|  TEST_TIME  | 
 153  | 
 5998.71  | 
 0.9968  | 
 1.0047  | 
 1503  | 
 87  | 
|  TEST_TIME  | 
 154  | 
 6010.77  | 
 0.9962  | 
 1.0023  | 
 1577  | 
 95  | 
|  TEST_TIME  | 
 155  | 
 6016.34  | 
 0.9961  | 
 1.0037  | 
 1231  | 
 99  | 
|  TEST_TIME  | 
 156  | 
 6017.29  | 
 0.9971  | 
 1.0019  | 
 1406  | 
 99  | 
|  TEST_TIME  | 
 157  | 
 6010.35  | 
 0.9967  | 
 1.0061  | 
 1345  | 
 100  | 
|  TEST_TIME  | 
 158  | 
 6026.91  | 
 0.9970  | 
 1.0021  | 
 1344  | 
 99  | 
|  TEST_TIME  | 
 159  | 
 6015.51  | 
 0.9977  | 
 1.0053  | 
 1244  | 
 100  | 
|  TEST_TIME  | 
 160  | 
 6034.22  | 
 0.9959  | 
 1.0037  | 
 1384  | 
 100  | 
|  TEST_TIME  | 
 161  | 
 6037.07  | 
 0.9970  | 
 1.0028  | 
 1293  | 
 100  | 
|  TEST_TIME  | 
 162  | 
 6026.88  | 
 0.9983  | 
 1.0015  | 
 1465  | 
 99  | 
|  TEST_TIME  | 
 163  | 
 6012.45  | 
 0.9977  | 
 1.0052  | 
 1085  | 
 97  | 
|  TEST_TIME  | 
 164  | 
 6017.17  | 
 0.9983  | 
 1.0021  | 
 1185  | 
 97  | 
|  TEST_TIME  | 
 165  | 
 6018.66  | 
 0.9958  | 
 1.0026  | 
 1768  | 
 95  | 
|  TEST_TIME  | 
 166  | 
 6014.53  | 
 0.9972  | 
 1.0035  | 
 1847  | 
 93  | 
|  TEST_TIME  | 
 167  | 
 6017.44  | 
 0.9970  | 
 1.0030  | 
 1505  | 
 92  | 
|  TEST_TIME  | 
 168  | 
 6013.99  | 
 0.9976  | 
 1.0032  | 
 1775  | 
 98  | 
|  TEST_TIME  | 
 169  | 
 6017.89  | 
 0.9967  | 
 1.0041  | 
 1444  | 
 96  | 
|  TEST_TIME  | 
 170  | 
 6038.87  | 
 0.9948  | 
 1.0061  | 
 1237  | 
 100  | 
|  TEST_TIME  | 
 171  | 
 6058.54  | 
 0.9970  | 
 1.0016  | 
 1366  | 
 97  | 
|  TEST_TIME  | 
 172  | 
 6049.10  | 
 0.9973  | 
 1.0027  | 
 1163  | 
 98  | 
|  TEST_TIME  | 
 173  | 
 6047.35  | 
 0.9972  | 
 1.0032  | 
 1257  | 
 96  | 
|  TEST_TIME  | 
 174  | 
 6046.20  | 
 0.9977  | 
 1.0019  | 
 1280  | 
 91  | 
|  TEST_TIME  | 
 175  | 
 6048.88  | 
 0.9957  | 
 1.0021  | 
 1083  | 
 93  | 
|  TEST_TIME  | 
 176  | 
 6039.53  | 
 0.9979  | 
 1.0019  | 
 1140  | 
 86  | 
|  TEST_TIME  | 
 177  | 
 6033.67  | 
 0.9972  | 
 1.0035  | 
 985  | 
 95  | 
|  TEST_TIME  | 
 178  | 
 6026.27  | 
 0.9991  | 
 1.0012  | 
 1307  | 
 97  | 
|  TEST_TIME  | 
 179  | 
 6010.78  | 
 0.9982  | 
 1.0019  | 
 1182  | 
 86  | 
|  TEST_TIME  | 
 180  | 
 5999.95  | 
 0.9981  | 
 1.0018  | 
 1017  | 
 94  | 
 
Done for 9840 ms, from  6:58:50.09 to  6:58:59.93.  
 
 
|  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  | 
 54685  | 
 52759  | 
 61222  | 
 76096  | 
 55991  | 
 <null>  | 
 42273  | 
 164739  | 
 85663  | 
 10249  | 
 69175  | 
 66374  | 
 76986  | 
 97007  | 
 100233  | 
 89836  | 
 102726  | 
 330462  | 
 <null>  | 
 03:46:49  | 
 04:04:49  | 
|  fetches per second  | 
 2  | 
 24017  | 
 20804  | 
 34130  | 
 3971  | 
 20684  | 
 9010  | 
 18961  | 
 81701  | 
 <null>  | 
 19237  | 
 41778  | 
 31946  | 
 51169  | 
 2356  | 
 58231  | 
 91000  | 
 27484  | 
 30047  | 
 <null>  | 
 04:04:50  | 
 04:22:50  | 
|  fetches per second  | 
 3  | 
 16393  | 
 16022  | 
 5976  | 
 <null>  | 
 11044  | 
 13840  | 
 41073  | 
 7812  | 
 3003  | 
 59503  | 
 6864  | 
 14207  | 
 17656  | 
 4594  | 
 22205  | 
 34919  | 
 37564  | 
 120797  | 
 <null>  | 
 04:22:51  | 
 04:40:51  | 
|  fetches per second  | 
 4  | 
 13915  | 
 20012  | 
 19586  | 
 <null>  | 
 21111  | 
 8310  | 
 24496  | 
 <null>  | 
 70062  | 
 35763  | 
 22882  | 
 4712  | 
 28996  | 
 20916  | 
 42537  | 
 7626  | 
 142237  | 
 161511  | 
 <null>  | 
 04:40:52  | 
 04:58:52  | 
|  fetches per second  | 
 5  | 
 23131  | 
 59092  | 
 26335  | 
 18359  | 
 35125  | 
 111663  | 
 54704  | 
 5251  | 
 30236  | 
 <null>  | 
 18056  | 
 50966  | 
 40672  | 
 4913  | 
 73097  | 
 6831  | 
 <null>  | 
 90670  | 
 <null>  | 
 04:58:53  | 
 05:16:53  | 
|  fetches per second  | 
 6  | 
 17176  | 
 48404  | 
 12792  | 
 <null>  | 
 20082  | 
 <null>  | 
 22451  | 
 110725  | 
 71452  | 
 3672  | 
 12529  | 
 9079  | 
 18957  | 
 2474  | 
 46385  | 
 2854  | 
 137812  | 
 141172  | 
 <null>  | 
 05:16:54  | 
 05:34:54  | 
|  fetches per second  | 
 7  | 
 5884  | 
 3535  | 
 9262  | 
 <null>  | 
 8423  | 
 <null>  | 
 26875  | 
 <null>  | 
 8734  | 
 3119  | 
 14032  | 
 1193  | 
 17083  | 
 <null>  | 
 14804  | 
 2982  | 
 <null>  | 
 97593  | 
 <null>  | 
 05:34:55  | 
 05:52:55  | 
|  fetches per second  | 
 8  | 
 13364  | 
 42730  | 
 9336  | 
 56735  | 
 18646  | 
 2433  | 
 39694  | 
 55722  | 
 2928  | 
 169714  | 
 18167  | 
 2012  | 
 40125  | 
 2928  | 
 17988  | 
 <null>  | 
 <null>  | 
 59045  | 
 <null>  | 
 05:52:56  | 
 06:10:56  | 
|  fetches per second  | 
 9  | 
 12347  | 
 22166  | 
 17679  | 
 8313  | 
 8349  | 
 <null>  | 
 72439  | 
 60958  | 
 3061  | 
 48963  | 
 13790  | 
 6253  | 
 33689  | 
 35904  | 
 8292  | 
 98562  | 
 44268  | 
 30987  | 
 <null>  | 
 06:10:57  | 
 06:28:57  | 
|  fetches per second  | 
 10  | 
 4658  | 
 2057  | 
 5536  | 
 9724  | 
 8581  | 
 <null>  | 
 8034  | 
 4097  | 
 10343  | 
 <null>  | 
 5745  | 
 2433  | 
 11153  | 
 3150  | 
 20479  | 
 <null>  | 
 <null>  | 
 95956  | 
 <null>  | 
 06:28:58  | 
 06:46:58  | 
|  marks per second  | 
 1  | 
 11921  | 
 6358  | 
 12986  | 
 12984  | 
 12153  | 
 <null>  | 
 5352  | 
 30872  | 
 10772  | 
 2134  | 
 14071  | 
 11653  | 
 5697  | 
 14570  | 
 4340  | 
 17398  | 
 8494  | 
 20458  | 
 <null>  | 
 03:46:49  | 
 04:04:49  | 
|  marks per second  | 
 2  | 
 4978  | 
 2319  | 
 6732  | 
 940  | 
 4514  | 
 1874  | 
 2791  | 
 12255  | 
 <null>  | 
 4357  | 
 5580  | 
 5208  | 
 3027  | 
 367  | 
 2423  | 
 17100  | 
 1577  | 
 2337  | 
 <null>  | 
 04:04:50  | 
 04:22:50  | 
|  marks per second  | 
 3  | 
 3401  | 
 2277  | 
 1207  | 
 <null>  | 
 2177  | 
 3652  | 
 5357  | 
 1360  | 
 405  | 
 6543  | 
 1068  | 
 2281  | 
 1217  | 
 1036  | 
 1331  | 
 5837  | 
 2197  | 
 6465  | 
 <null>  | 
 04:22:51  | 
 04:40:51  | 
|  marks per second  | 
 4  | 
 2858  | 
 2128  | 
 4232  | 
 <null>  | 
 4264  | 
 1847  | 
 3125  | 
 <null>  | 
 9684  | 
 5154  | 
 3156  | 
 830  | 
 1458  | 
 4001  | 
 2718  | 
 1653  | 
 37533  | 
 1715  | 
 <null>  | 
 04:40:52  | 
 04:58:52  | 
|  marks per second  | 
 5  | 
 4928  | 
 6943  | 
 5401  | 
 4683  | 
 7590  | 
 25507  | 
 5891  | 
 716  | 
 2920  | 
 <null>  | 
 2613  | 
 9506  | 
 1749  | 
 842  | 
 4922  | 
 1812  | 
 <null>  | 
 8492  | 
 <null>  | 
 04:58:53  | 
 05:16:53  | 
|  marks per second  | 
 6  | 
 3633  | 
 6475  | 
 2620  | 
 <null>  | 
 3455  | 
 <null>  | 
 2285  | 
 17455  | 
 16044  | 
 539  | 
 1628  | 
 1218  | 
 1356  | 
 416  | 
 3387  | 
 468  | 
 8740  | 
 3689  | 
 <null>  | 
 05:16:54  | 
 05:34:54  | 
|  marks per second  | 
 7  | 
 1259  | 
 434  | 
 1647  | 
 <null>  | 
 1431  | 
 <null>  | 
 2378  | 
 <null>  | 
 980  | 
 451  | 
 1651  | 
 158  | 
 551  | 
 <null>  | 
 837  | 
 478  | 
 <null>  | 
 786  | 
 <null>  | 
 05:34:55  | 
 05:52:55  | 
|  marks per second  | 
 8  | 
 2611  | 
 6354  | 
 1751  | 
 7870  | 
 3129  | 
 585  | 
 4905  | 
 7776  | 
 341  | 
 29285  | 
 2944  | 
 316  | 
 1841  | 
 446  | 
 1652  | 
 <null>  | 
 <null>  | 
 1349  | 
 <null>  | 
 05:52:56  | 
 06:10:56  | 
|  marks per second  | 
 9  | 
 2517  | 
 3052  | 
 3438  | 
 2098  | 
 1743  | 
 <null>  | 
 8123  | 
 8379  | 
 495  | 
 7651  | 
 1241  | 
 939  | 
 1467  | 
 5203  | 
 971  | 
 12875  | 
 1194  | 
 845  | 
 <null>  | 
 06:10:57  | 
 06:28:57  | 
|  marks per second  | 
 10  | 
 931  | 
 273  | 
 815  | 
 1542  | 
 1247  | 
 <null>  | 
 701  | 
 575  | 
 1454  | 
 <null>  | 
 688  | 
 390  | 
 265  | 
 620  | 
 1969  | 
 <null>  | 
 <null>  | 
 976  | 
 <null>  | 
 06:28:58  | 
 06:46:58  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 03:46:49  | 
 04:04:49  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:04:50  | 
 04:22:50  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:22:51  | 
 04:40:51  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:40:52  | 
 04:58:52  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 04:58:53  | 
 05:16:53  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:16:54  | 
 05:34:54  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:34:55  | 
 05:52:55  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 05:52:56  | 
 06:10:56  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:10:57  | 
 06:28:57  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 06:28:58  | 
 06:46:58  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 7  | 
 0  | 
 <null>  | 
 03:46:49  | 
 04:04:49  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:04:50  | 
 04:22:50  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 04:22:51  | 
 04:40:51  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 04:40:52  | 
 04:58:52  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 04:58:53  | 
 05:16:53  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 05:16:54  | 
 05:34:54  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:34:55  | 
 05:52:55  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 05:52:56  | 
 06:10:56  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:10:57  | 
 06:28:57  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 06:28:58  | 
 06:46:58  | 
 
Done for 9620 ms, from  6:59:00.96 to  6:59:10.58.  
 
 
|  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  | 
 1872193  | 
 1751831  | 
 120362  | 
 6.42  | 
 0  | 
 7691  | 
 53  | 
 120362  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  doc_list_biud  | 
 1872610  | 
 1751831  | 
 120779  | 
 6.44  | 
 0  | 
 6692  | 
 18  | 
 120779  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_add_invoice_to_stock  | 
 19246  | 
 11557  | 
 7689  | 
 39.95  | 
 15  | 
 165766  | 
 12619  | 
 7689  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_adding_invoice  | 
 4301  | 
 3429  | 
 872  | 
 20.27  | 
 0  | 
 91418  | 
 2799  | 
 872  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_client_order  | 
 6623  | 
 6462  | 
 161  | 
 2.43  | 
 0  | 
 2699  | 
 264  | 
 161  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_customer_reserve  | 
 309516  | 
 197657  | 
 111859  | 
 36.13  | 
 0  | 
 5304  | 
 70  | 
 111859  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2362  | 
 2346  | 
 16  | 
 0.67  | 
 0  | 
 2277  | 
 146  | 
 16  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1516  | 
 1511  | 
 5  | 
 0.32  | 
 0  | 
 1919  | 
 161  | 
 5  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_supplier_invoice  | 
 9554  | 
 7577  | 
 1977  | 
 20.69  | 
 0  | 
 7488  | 
 491  | 
 1977  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_supplier_order  | 
 1577  | 
 550  | 
 1027  | 
 65.12  | 
 31  | 
 186872  | 
 21890  | 
 1027  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_cancel_write_off  | 
 22426  | 
 15674  | 
 6752  | 
 30.10  | 
 0  | 
 6942  | 
 171  | 
 6752  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_client_order  | 
 80352  | 
 80352  | 
 0  | 
 0.00  | 
 0  | 
 5117  | 
 515  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_customer_reserve  | 
 624229  | 
 624229  | 
 0  | 
 0.00  | 
 0  | 
 6833  | 
 193  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_fill_shopping_cart  | 
 121202  | 
 120952  | 
 250  | 
 0.20  | 
 0  | 
 5133  | 
 101  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 624229  | 
 624229  | 
 0  | 
 0.00  | 
 0  | 
 2387  | 
 14  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_get_clo_for_invoice  | 
 11557  | 
 11557  | 
 0  | 
 0.00  | 
 0  | 
 5335  | 
 354  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_kill_cost_storno  | 
 30257  | 
 22960  | 
 7297  | 
 24.11  | 
 0  | 
 2371  | 
 20  | 
 7297  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 650641  | 
 419115  | 
 231526  | 
 35.58  | 
 0  | 
 6676  | 
 26  | 
 231526  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_kill_qty_storno  | 
 400131  | 
 279415  | 
 120716  | 
 30.16  | 
 0  | 
 6692  | 
 80  | 
 120716  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_lock_selected_doc  | 
 78553  | 
 67437  | 
 11116  | 
 14.15  | 
 0  | 
 1232  | 
 8  | 
 11116  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_make_cost_storno  | 
 97001  | 
 97001  | 
 0  | 
 0.00  | 
 0  | 
 7441  | 
 473  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 97001  | 
 97001  | 
 0  | 
 0.00  | 
 0  | 
 2496  | 
 61  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 80352  | 
 80352  | 
 0  | 
 0.00  | 
 0  | 
 4414  | 
 171  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_pay_from_customer  | 
 26780  | 
 26780  | 
 0  | 
 0.00  | 
 0  | 
 7753  | 
 978  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_pay_to_supplier  | 
 22155  | 
 22155  | 
 0  | 
 0.00  | 
 0  | 
 8019  | 
 761  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_payment_common  | 
 48935  | 
 48935  | 
 0  | 
 0.00  | 
 0  | 
 2387  | 
 68  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 6619  | 
 6462  | 
 157  | 
 2.37  | 
 0  | 
 1934  | 
 114  | 
 157  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 15694  | 
 14986  | 
 708  | 
 4.51  | 
 0  | 
 5710  | 
 388  | 
 708  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 36509  | 
 36509  | 
 0  | 
 0.00  | 
 0  | 
 2574  | 
 56  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_reserve_write_off  | 
 37769  | 
 36509  | 
 1260  | 
 3.33  | 
 0  | 
 8065  | 
 601  | 
 1260  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_supplier_invoice  | 
 20288  | 
 20201  | 
 87  | 
 0.42  | 
 0  | 
 32151  | 
 3394  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  sp_supplier_order  | 
 20562  | 
 20399  | 
 163  | 
 0.79  | 
 0  | 
 14554  | 
 2281  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  srv_find_qd_qs_mism  | 
 1109585  | 
 989227  | 
 120358  | 
 10.84  | 
 0  | 
 4275  | 
 28  | 
 120358  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  srv_make_invnt_saldo  | 
 1511  | 
 1511  | 
 0  | 
 0.00  | 
 0  | 
 27799  | 
 3474  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  srv_make_money_saldo  | 
 3125  | 
 3125  | 
 0  | 
 0.00  | 
 0  | 
 3900  | 
 70  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 3214  | 
 47627  | 
 19849  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 7689  | 
 7689  | 
 0  | 
 0.00  | 
 0  | 
 2558  | 
 101  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 701  | 
 701  | 
 0  | 
 0.00  | 
 0  | 
 2574  | 
 211  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 161  | 
 161  | 
 0  | 
 0.00  | 
 0  | 
 1092  | 
 136  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 86  | 
 86  | 
 0  | 
 0.00  | 
 0  | 
 468  | 
 54  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 16  | 
 16  | 
 0  | 
 0.00  | 
 0  | 
 842  | 
 214  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 5  | 
 5  | 
 0  | 
 0.00  | 
 0  | 
 187  | 
 90  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 614  | 
 614  | 
 0  | 
 0.00  | 
 0  | 
 1778  | 
 84  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 13867  | 
 13867  | 
 0  | 
 0.00  | 
 0  | 
 3370  | 
 132  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 29  | 
 29  | 
 0  | 
 0.00  | 
 0  | 
 390  | 
 49  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1260  | 
 1260  | 
 0  | 
 0.00  | 
 0  | 
 1467  | 
 75  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 87  | 
 87  | 
 0  | 
 0.00  | 
 0  | 
 842  | 
 108  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 163  | 
 163  | 
 0  | 
 0.00  | 
 0  | 
 1045  | 
 81  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 11557  | 
 11557  | 
 0  | 
 0.00  | 
 0  | 
 11747  | 
 661  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1324  | 
 1324  | 
 0  | 
 0.00  | 
 0  | 
 10483  | 
 758  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6462  | 
 6462  | 
 0  | 
 0.00  | 
 0  | 
 1903  | 
 72  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2393  | 
 2393  | 
 0  | 
 0.00  | 
 0  | 
 1841  | 
 70  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2346  | 
 2346  | 
 0  | 
 0.00  | 
 0  | 
 1732  | 
 58  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1511  | 
 1511  | 
 0  | 
 0.00  | 
 0  | 
 1279  | 
 60  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 967  | 
 967  | 
 0  | 
 0.00  | 
 0  | 
 1748  | 
 74  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 550  | 
 550  | 
 0  | 
 0.00  | 
 0  | 
 30326  | 
 1978  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3818  | 
 3818  | 
 0  | 
 0.00  | 
 0  | 
 1763  | 
 74  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_client_order  | 
 80352  | 
 80352  | 
 0  | 
 0.00  | 
 0  | 
 3619  | 
 83  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 3630  | 
 3630  | 
 0  | 
 0.00  | 
 0  | 
 1685  | 
 59  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 26780  | 
 26780  | 
 0  | 
 0.00  | 
 0  | 
 3370  | 
 73  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 22155  | 
 22155  | 
 0  | 
 0.00  | 
 0  | 
 1872  | 
 68  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 36509  | 
 36509  | 
 0  | 
 0.00  | 
 0  | 
 3650  | 
 80  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 20201  | 
 20201  | 
 0  | 
 0.00  | 
 0  | 
 2933  | 
 74  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 20399  | 
 20399  | 
 0  | 
 0.00  | 
 0  | 
 2933  | 
 78  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1511  | 
 1511  | 
 0  | 
 0.00  | 
 0  | 
 858  | 
 30  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 3125  | 
 3125  | 
 0  | 
 0.00  | 
 0  | 
 1638  | 
 34  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 3822  | 
 412  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_add_invoice_to_stock  | 
 38492  | 
 23114  | 
 15378  | 
 39.95  | 
 0  | 
 1887  | 
 17  | 
 15378  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_all_customers  | 
 120874  | 
 120874  | 
 0  | 
 0.00  | 
 0  | 
 1170  | 
 6  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_all_suppliers  | 
 82154  | 
 81654  | 
 500  | 
 0.60  | 
 0  | 
 780  | 
 6  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_all_wares  | 
 160704  | 
 160704  | 
 0  | 
 0.00  | 
 0  | 
 733  | 
 5  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_adding_invoice  | 
 3106  | 
 2648  | 
 458  | 
 14.74  | 
 0  | 
 3339  | 
 176  | 
 458  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_client_order  | 
 13246  | 
 12924  | 
 322  | 
 2.43  | 
 0  | 
 1716  | 
 7  | 
 322  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_customer_prepayment  | 
 4724  | 
 4692  | 
 32  | 
 0.67  | 
 0  | 
 827  | 
 9  | 
 32  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_customer_reserve  | 
 4958  | 
 4786  | 
 172  | 
 3.46  | 
 0  | 
 1888  | 
 11  | 
 172  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_payment_to_supplier  | 
 3032  | 
 3022  | 
 10  | 
 0.32  | 
 0  | 
 718  | 
 10  | 
 10  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_supplier_invoice  | 
 3162  | 
 1934  | 
 1228  | 
 38.83  | 
 0  | 
 1622  | 
 16  | 
 1228  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_supplier_order  | 
 3154  | 
 1100  | 
 2054  | 
 65.12  | 
 0  | 
 905  | 
 11  | 
 2054  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_cancel_write_off  | 
 7694  | 
 7636  | 
 58  | 
 0.75  | 
 0  | 
 2839  | 
 106  | 
 58  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_max_id_clo_ord  | 
 20562  | 
 20399  | 
 163  | 
 0.79  | 
 0  | 
 827  | 
 6  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_max_id_clo_res  | 
 3630  | 
 3630  | 
 0  | 
 0.00  | 
 0  | 
 1232  | 
 20  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_max_id_ord_sup  | 
 20288  | 
 20201  | 
 87  | 
 0.42  | 
 0  | 
 843  | 
 6  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_max_non_paid_invoice  | 
 21928  | 
 21928  | 
 0  | 
 0.00  | 
 0  | 
 1029  | 
 6  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_max_non_paid_realizn  | 
 26780  | 
 26780  | 
 0  | 
 0.00  | 
 0  | 
 1607  | 
 6  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_min_id_clo_ord  | 
 20562  | 
 20399  | 
 163  | 
 0.79  | 
 0  | 
 655  | 
 7  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_min_id_clo_res  | 
 3630  | 
 3630  | 
 0  | 
 0.00  | 
 0  | 
 1607  | 
 12  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_min_id_ord_sup  | 
 20288  | 
 20201  | 
 87  | 
 0.42  | 
 0  | 
 1935  | 
 7  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_min_non_paid_invoice  | 
 22155  | 
 22155  | 
 0  | 
 0.00  | 
 0  | 
 1919  | 
 11  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_min_non_paid_realizn  | 
 26780  | 
 26780  | 
 0  | 
 0.00  | 
 0  | 
 1934  | 
 10  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_our_firm  | 
 39830  | 
 39830  | 
 0  | 
 0.00  | 
 0  | 
 640  | 
 6  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  v_reserve_write_off  | 
 75538  | 
 73018  | 
 2520  | 
 3.33  | 
 0  | 
 2870  | 
 9  | 
 2520  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 18180  | 
 10039  | 
 8141  | 
 44.77  | 
 0  | 
 2932  | 
 36  | 
 8141  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1575  | 
 550  | 
 1025  | 
 65.07  | 
 0  | 
 1139  | 
 64  | 
 1025  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  x_make_qstorno_1000_1200  | 
 20562  | 
 20399  | 
 163  | 
 0.79  | 
 0  | 
 13931  | 
 2056  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  x_make_qstorno_1200_2000  | 
 20288  | 
 20201  | 
 87  | 
 0.42  | 
 0  | 
 31684  | 
 3163  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
|  x_make_qstorno_2100_3300  | 
 624229  | 
 624229  | 
 0  | 
 0.00  | 
 0  | 
 6567  | 
 162  | 
 0  | 
 2018-03-05 03:46  | 
 2018-03-05 06:46  | 
 
Done for 343170 ms, from  7:04:38.42 to  7:10:21.59.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 85  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2018-03-05 03:47  | 
 2018-03-05 06:42  | 
|  deadlock  | 
 86  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2018-03-05 03:51  | 
 2018-03-05 06:43  | 
|  deadlock  | 
 9691  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  deadlock  | 
 157  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2018-03-05 03:51  | 
 2018-03-05 06:46  | 
|  deadlock  | 
 161  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2018-03-05 03:47  | 
 2018-03-05 06:43  | 
|  deadlock  | 
 630  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
|  deadlock  | 
 302  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2018-03-05 03:49  | 
 2018-03-05 06:46  | 
|  user_exc  | 
 163  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2018-03-05 03:47  | 
 2018-03-05 06:45  | 
|  user_exc  | 
 87  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2018-03-05 03:47  | 
 2018-03-05 06:46  | 
 
Done for 11120 ms, from  7:10:30.51 to  7:10:41.63.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          428074
 
MON$OLDEST_ACTIVE               428075
 
MON$OLDEST_SNAPSHOT             428075
 
MON$NEXT_TRANSACTION            428075
 
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                       819904
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.4.32924 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.4.32924 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.4.32924 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.4.32924 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Gstat execution time Mon Mar 05 07:10:42 2018 
 
 
Database header page information: 
 
Flags			0 
 
Generation		428238 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	428076 
 
Oldest active		428077 
 
Oldest snapshot		428077 
 
Next transaction	428078 
 
Sequence number		0 
 
Next attachment ID	9501 
 
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.09, total records: 2118429 
 
Average version length: 47.77, total versions: 2082, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.36 
 
Pointer pages: 15, data page slots: 23048 
 
Data pages: 23048, average fill: 72% 
 
Primary pages: 23048, secondary pages: 0, swept pages: 15030 
 
Empty pages: 1, full pages: 17998 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 11 
 
40 - 59% = 133 
 
60 - 79% = 22902 
 
80 - 99% = 1 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10292, nodes: 2118429 
 
Average node length: 19.37, total dup: 0, max dup: 0 
 
Average key length: 16.41, compression ratio: 1.65 
 
Average prefix length: 13.59, average data length: 13.41 
 
Clustering factor: 464196, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 643 
 
20 - 39% = 2376 
 
40 - 59% = 4801 
 
60 - 79% = 1069 
 
80 - 99% = 1403 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7630, nodes: 2118429 
 
Average node length: 11.65, total dup: 0, max dup: 0 
 
Average key length: 8.70, compression ratio: 1.03 
 
Average prefix length: 3.30, average data length: 5.70 
 
Clustering factor: 437936, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 3652 
 
40 - 59% = 3901 
 
60 - 79% = 71 
 
80 - 99% = 6 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 176075, depth: 3, leaf buckets: 3779, nodes: 2118429 
 
Average node length: 6.85, total dup: 1534105, max dup: 49 
 
Average key length: 3.89, compression ratio: 2.31 
 
Average prefix length: 7.38, average data length: 1.62 
 
Clustering factor: 426785, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 146 
 
20 - 39% = 1324 
 
40 - 59% = 1564 
 
60 - 79% = 219 
 
80 - 99% = 526 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.42, total records: 649253 
 
Average version length: 36.09, total versions: 282, max versions: 2 
 
Average fragment length: 20.67, total fragments: 3, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8280 
 
Data pages: 8280, average fill: 75% 
 
Primary pages: 8277, secondary pages: 3, swept pages: 7958 
 
Empty pages: 6, full pages: 7050 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 13 
 
40 - 59% = 58 
 
60 - 79% = 8189 
 
80 - 99% = 9 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 253683, depth: 3, leaf buckets: 2413, nodes: 649253 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.82, compression ratio: 1.02 
 
Average prefix length: 3.18, average data length: 5.82 
 
Clustering factor: 159771, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1381 
 
40 - 59% = 990 
 
60 - 79% = 38 
 
80 - 99% = 2 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 684, nodes: 649253 
 
Average node length: 4.88, total dup: 649203, max dup: 43041 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 297990, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 585 
 
60 - 79% = 76 
 
80 - 99% = 22 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 322235, depth: 3, leaf buckets: 1992, nodes: 649253 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.82, compression ratio: 1.02 
 
Average prefix length: 3.18, average data length: 5.82 
 
Clustering factor: 159771, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 156 
 
20 - 39% = 663 
 
40 - 59% = 678 
 
60 - 79% = 226 
 
80 - 99% = 269 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 270, Index root page: 271 
 
Total formats: 1, used formats: 1 
 
Average record length: 63.51, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 16.85, total fragments: 355, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.64 
 
Pointer pages: 1, data page slots: 608 
 
Data pages: 36, average fill: 19% 
 
Primary pages: 4, secondary pages: 32, swept pages: 4 
 
Empty pages: 17, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 9 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.66, total records: 2967 
 
Average version length: 71.12, total versions: 66, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.38 
 
Pointer pages: 2, data page slots: 1928 
 
Data pages: 376, average fill: 11% 
 
Primary pages: 376, secondary pages: 0, swept pages: 339 
 
Empty pages: 34, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 324 
 
20 - 39% = 27 
 
40 - 59% = 14 
 
60 - 79% = 10 
 
80 - 99% = 1 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 15, nodes: 2967 
 
Average node length: 16.78, total dup: 112, max dup: 1 
 
Average key length: 13.80, compression ratio: 1.96 
 
Average prefix length: 16.16, average data length: 10.84 
 
Clustering factor: 2745, ratio: 0.93 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 8 
 
40 - 59% = 4 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.00, total records: 49 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.13 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 20% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 260, Index root page: 261 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.17, total records: 134 
 
Average version length: 45.87, total versions: 90, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 4.22 
 
Pointer pages: 1, data page slots: 64 
 
Data pages: 24, average fill: 7% 
 
Primary pages: 24, secondary pages: 0, swept pages: 20 
 
Empty pages: 15, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 1 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 250189, depth: 2, leaf buckets: 1, nodes: 134 
 
Average node length: 8.70, total dup: 93, max dup: 27 
 
Average key length: 6.69, compression ratio: 2.84 
 
Average prefix length: 14.60, average data length: 4.40 
 
Clustering factor: 44, ratio: 0.33 
 
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: 42.38, total records: 221582 
 
Average version length: 28.17, total versions: 1101, max versions: 5 
 
Average fragment length: 33.40, total fragments: 5, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.51 
 
Pointer pages: 2, data page slots: 2720 
 
Data pages: 2720, average fill: 61% 
 
Primary pages: 2696, secondary pages: 24, swept pages: 2604 
 
Empty pages: 26, full pages: 335 
 
Fill distribution: 
 
0 - 19% = 86 
 
20 - 39% = 218 
 
40 - 59% = 429 
 
60 - 79% = 1980 
 
80 - 99% = 7 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 203, nodes: 221582 
 
Average node length: 4.56, total dup: 221533, max dup: 9491 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 37483, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 7 
 
40 - 59% = 96 
 
60 - 79% = 79 
 
80 - 99% = 21 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 247, nodes: 221582 
 
Average node length: 5.49, total dup: 200042, max dup: 46 
 
Average key length: 2.94, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 48375, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 16 
 
40 - 59% = 112 
 
60 - 79% = 88 
 
80 - 99% = 30 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 250, nodes: 221582 
 
Average node length: 5.49, total dup: 200042, max dup: 46 
 
Average key length: 2.94, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 48397, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 25 
 
40 - 59% = 92 
 
60 - 79% = 100 
 
80 - 99% = 32 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 254, nodes: 221582 
 
Average node length: 5.28, total dup: 200042, max dup: 46 
 
Average key length: 2.74, compression ratio: 3.29 
 
Average prefix length: 8.36, average data length: 0.64 
 
Clustering factor: 48423, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 27 
 
40 - 59% = 128 
 
60 - 79% = 78 
 
80 - 99% = 20 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.98, total records: 265898 
 
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: 2280 
 
Data pages: 2280, average fill: 64% 
 
Primary pages: 2280, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 2272 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 2272 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 117308, depth: 2, leaf buckets: 205, nodes: 265898 
 
Average node length: 4.52, total dup: 265718, max dup: 3154 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 30657, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 58 
 
60 - 79% = 74 
 
80 - 99% = 73 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 1, used formats: 1 
 
Average record length: 151.64, total records: 11469512 
 
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.18 
 
Pointer pages: 167, data page slots: 272008 
 
Data pages: 272008, average fill: 87% 
 
Primary pages: 272008, secondary pages: 0, swept pages: 3 
 
Empty pages: 6, full pages: 272001 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 272001 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 12728, nodes: 11469512 
 
Average node length: 5.66, total dup: 10621099, max dup: 161 
 
Average key length: 2.18, compression ratio: 3.67 
 
Average prefix length: 7.86, average data length: 0.13 
 
Clustering factor: 4410964, ratio: 0.38 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 0 
 
40 - 59% = 6656 
 
60 - 79% = 4030 
 
80 - 99% = 2032 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 11326, nodes: 11469512 
 
Average node length: 4.56, total dup: 11469508, max dup: 10571669 
 
Average key length: 1.08, compression ratio: 0.36 
 
Average prefix length: 0.39, average data length: 0.00 
 
Clustering factor: 338453, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 11320 
 
60 - 79% = 3 
 
80 - 99% = 2 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 13814, nodes: 11469512 
 
Average node length: 5.71, total dup: 11107543, max dup: 18753 
 
Average key length: 2.23, compression ratio: 4.03 
 
Average prefix length: 8.80, average data length: 0.20 
 
Clustering factor: 981876, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 2 
 
40 - 59% = 10082 
 
60 - 79% = 2003 
 
80 - 99% = 1724 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 13825, nodes: 11469512 
 
Average node length: 5.55, total dup: 11440418, max dup: 1500309 
 
Average key length: 2.07, compression ratio: 18.24 
 
Average prefix length: 37.72, average data length: 0.07 
 
Clustering factor: 6561179, ratio: 0.57 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 1 
 
40 - 59% = 11759 
 
60 - 79% = 587 
 
80 - 99% = 1454 
 
 
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: 55.00, total records: 437431 
 
Average version length: 55.89, total versions: 692, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.45 
 
Pointer pages: 4, data page slots: 5224 
 
Data pages: 5224, average fill: 74% 
 
Primary pages: 5224, secondary pages: 0, swept pages: 3921 
 
Empty pages: 2, full pages: 4504 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 6 
 
40 - 59% = 39 
 
60 - 79% = 5174 
 
80 - 99% = 2 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 655712, depth: 3, leaf buckets: 577, nodes: 437431 
 
Average node length: 5.95, total dup: 367096, max dup: 815 
 
Average key length: 3.17, compression ratio: 2.84 
 
Average prefix length: 7.99, average data length: 1.01 
 
Clustering factor: 55281, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 29 
 
40 - 59% = 347 
 
60 - 79% = 141 
 
80 - 99% = 49 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 462, nodes: 437431 
 
Average node length: 5.60, total dup: 389849, max dup: 109 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 105225, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 10 
 
40 - 59% = 176 
 
60 - 79% = 178 
 
80 - 99% = 98 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 3% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.31, total records: 114 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1347.00, compression ratio: 13.70 
 
Pointer pages: 1, data page slots: 2 
 
Data pages: 2, average fill: 80% 
 
Primary pages: 2, secondary pages: 0, swept pages: 2 
 
Empty pages: 0, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index SETTINGS_MODE_CODE (0) 
 
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.11, total dup: 0, max dup: 0 
 
Average key length: 26.10, compression ratio: 1.70 
 
Average prefix length: 21.18, average data length: 23.11 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (162) 
 
Primary pointer page: 347, Index root page: 348 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.78, total records: 2695 
 
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.51 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 62% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 32 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 264, Index root page: 265 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.23, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.73 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 78% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 67 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.86, total dup: 0, max dup: 0 
 
Average key length: 51.84, compression ratio: 1.00 
 
Average prefix length: 2.73, average data length: 48.86 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (260) 
 
Primary pointer page: 292, Index root page: 295 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.42, total records: 5929 
 
Average version length: 71.82, total versions: 1210, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.37 
 
Pointer pages: 2, data page slots: 2304 
 
Data pages: 376, average fill: 19% 
 
Primary pages: 375, secondary pages: 1, swept pages: 333 
 
Empty pages: 198, full pages: 44 
 
Fill distribution: 
 
0 - 19% = 265 
 
20 - 39% = 35 
 
40 - 59% = 22 
 
60 - 79% = 39 
 
80 - 99% = 15 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 16, nodes: 5929 
 
Average node length: 7.52, total dup: 5148, max dup: 14 
 
Average key length: 4.71, compression ratio: 7.85 
 
Average prefix length: 34.42, average data length: 2.58 
 
Clustering factor: 884, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 11 
 
40 - 59% = 5 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 72.02, total records: 1086877 
 
Average version length: 71.16, total versions: 2291, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.89 
 
Pointer pages: 11, data page slots: 17040 
 
Data pages: 17032, average fill: 70% 
 
Primary pages: 17032, secondary pages: 0, swept pages: 12514 
 
Empty pages: 126, full pages: 10929 
 
Fill distribution: 
 
0 - 19% = 307 
 
20 - 39% = 460 
 
40 - 59% = 1454 
 
60 - 79% = 14778 
 
80 - 99% = 33 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 384964, depth: 3, leaf buckets: 1234, nodes: 1086877 
 
Average node length: 5.12, total dup: 1059117, max dup: 126 
 
Average key length: 2.19, compression ratio: 4.11 
 
Average prefix length: 8.84, average data length: 0.16 
 
Clustering factor: 123998, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 88 
 
40 - 59% = 895 
 
60 - 79% = 41 
 
80 - 99% = 194 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 251211, depth: 3, leaf buckets: 1629, nodes: 1086877 
 
Average node length: 6.25, total dup: 949874, max dup: 22 
 
Average key length: 3.31, compression ratio: 11.17 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 210574, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 214 
 
40 - 59% = 1207 
 
60 - 79% = 142 
 
80 - 99% = 50 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 49.43, total records: 21317 
 
Average version length: 71.00, total versions: 6681, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.75 
 
Pointer pages: 4, data page slots: 3656 
 
Data pages: 1072, average fill: 24% 
 
Primary pages: 1072, secondary pages: 0, swept pages: 836 
 
Empty pages: 577, full pages: 161 
 
Fill distribution: 
 
0 - 19% = 683 
 
20 - 39% = 67 
 
40 - 59% = 94 
 
60 - 79% = 158 
 
80 - 99% = 70 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 46, nodes: 21317 
 
Average node length: 6.69, total dup: 18398, max dup: 44 
 
Average key length: 3.94, compression ratio: 9.38 
 
Average prefix length: 35.19, average data length: 1.81 
 
Clustering factor: 2406, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 26 
 
40 - 59% = 14 
 
60 - 79% = 5 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.50, total records: 1577899 
 
Average version length: 71.57, total versions: 37019, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.93 
 
Pointer pages: 17, data page slots: 26296 
 
Data pages: 26280, average fill: 67% 
 
Primary pages: 26280, secondary pages: 0, swept pages: 18377 
 
Empty pages: 333, full pages: 14183 
 
Fill distribution: 
 
0 - 19% = 791 
 
20 - 39% = 1475 
 
40 - 59% = 4282 
 
60 - 79% = 18949 
 
80 - 99% = 783 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 195932, depth: 3, leaf buckets: 2431, nodes: 1577899 
 
Average node length: 5.59, total dup: 1487688, max dup: 59 
 
Average key length: 2.63, compression ratio: 14.08 
 
Average prefix length: 36.43, average data length: 0.57 
 
Clustering factor: 213154, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 975 
 
40 - 59% = 1072 
 
60 - 79% = 248 
 
80 - 99% = 120 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 41.61, total records: 1816 
 
Average version length: 71.08, total versions: 739, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 3.27 
 
Pointer pages: 3, data page slots: 3176 
 
Data pages: 520, average fill: 5% 
 
Primary pages: 520, secondary pages: 0, swept pages: 481 
 
Empty pages: 373, full pages: 10 
 
Fill distribution: 
 
0 - 19% = 492 
 
20 - 39% = 11 
 
40 - 59% = 5 
 
60 - 79% = 5 
 
80 - 99% = 7 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 8, nodes: 1816 
 
Average node length: 10.17, total dup: 1331, max dup: 47 
 
Average key length: 7.50, compression ratio: 4.93 
 
Average prefix length: 31.76, average data length: 5.24 
 
Clustering factor: 326, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 5 
 
40 - 59% = 2 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.21, total records: 2713144 
 
Average version length: 71.24, total versions: 12485, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.91 
 
Pointer pages: 25, data page slots: 39296 
 
Data pages: 39296, average fill: 75% 
 
Primary pages: 39296, secondary pages: 0, swept pages: 30469 
 
Empty pages: 31, full pages: 32934 
 
Fill distribution: 
 
0 - 19% = 102 
 
20 - 39% = 144 
 
40 - 59% = 1020 
 
60 - 79% = 37743 
 
80 - 99% = 287 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5617, nodes: 2713144 
 
Average node length: 6.87, total dup: 2199291, max dup: 17 
 
Average key length: 3.89, compression ratio: 9.51 
 
Average prefix length: 35.30, average data length: 1.70 
 
Clustering factor: 520181, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 2958 
 
40 - 59% = 2231 
 
60 - 79% = 276 
 
80 - 99% = 144 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.66, total records: 4665875 
 
Average version length: 83.39, total versions: 1603, 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: 45, data page slots: 71816 
 
Data pages: 71816, average fill: 80% 
 
Primary pages: 71816, secondary pages: 0, swept pages: 27756 
 
Empty pages: 0, full pages: 70805 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 18 
 
40 - 59% = 80 
 
60 - 79% = 21816 
 
80 - 99% = 49894 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4749, nodes: 4665875 
 
Average node length: 5.15, total dup: 4559437, max dup: 128 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 751294, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 77 
 
40 - 59% = 2096 
 
60 - 79% = 1924 
 
80 - 99% = 629 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 5255, nodes: 4665875 
 
Average node length: 5.69, total dup: 4180250, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 258938, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 65 
 
20 - 39% = 191 
 
40 - 59% = 3126 
 
60 - 79% = 263 
 
80 - 99% = 1610 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5286, nodes: 4665875 
 
Average node length: 5.81, total dup: 4082381, max dup: 29 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 806085, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 89 
 
40 - 59% = 2312 
 
60 - 79% = 1993 
 
80 - 99% = 867 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.89, total records: 2437240 
 
Average version length: 83.00, total versions: 11164, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.64 
 
Pointer pages: 24, data page slots: 38416 
 
Data pages: 38416, average fill: 78% 
 
Primary pages: 38416, secondary pages: 0, swept pages: 27987 
 
Empty pages: 23, full pages: 35358 
 
Fill distribution: 
 
0 - 19% = 80 
 
20 - 39% = 183 
 
40 - 59% = 675 
 
60 - 79% = 16665 
 
80 - 99% = 20813 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2604, nodes: 2437240 
 
Average node length: 5.15, total dup: 2379968, max dup: 191 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 379279, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 48 
 
40 - 59% = 1508 
 
60 - 79% = 786 
 
80 - 99% = 259 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4120, nodes: 2437240 
 
Average node length: 6.22, total dup: 2002282, max dup: 14 
 
Average key length: 3.25, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 246859, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 102 
 
20 - 39% = 1620 
 
40 - 59% = 1631 
 
60 - 79% = 513 
 
80 - 99% = 254 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 2985, nodes: 2437240 
 
Average node length: 5.81, total dup: 2132077, max dup: 30 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 453320, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 19 
 
20 - 39% = 59 
 
40 - 59% = 1782 
 
60 - 79% = 867 
 
80 - 99% = 258 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.54, total records: 4939484 
 
Average version length: 85.25, total versions: 16490, 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: 48, data page slots: 77760 
 
Data pages: 77728, average fill: 79% 
 
Primary pages: 77728, secondary pages: 0, swept pages: 24747 
 
Empty pages: 266, full pages: 71874 
 
Fill distribution: 
 
0 - 19% = 440 
 
20 - 39% = 565 
 
40 - 59% = 1734 
 
60 - 79% = 19159 
 
80 - 99% = 55830 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5279, nodes: 4939484 
 
Average node length: 5.04, total dup: 4910667, max dup: 658 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 750673, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 248 
 
40 - 59% = 3142 
 
60 - 79% = 1391 
 
80 - 99% = 491 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 6184, nodes: 4939484 
 
Average node length: 5.52, total dup: 4554621, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.55 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 289008, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 83 
 
20 - 39% = 1819 
 
40 - 59% = 2475 
 
60 - 79% = 579 
 
80 - 99% = 1228 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5933, nodes: 4939484 
 
Average node length: 5.68, total dup: 4434616, max dup: 74 
 
Average key length: 2.70, compression ratio: 3.34 
 
Average prefix length: 8.41, average data length: 0.59 
 
Clustering factor: 829199, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 198 
 
40 - 59% = 3572 
 
60 - 79% = 1603 
 
80 - 99% = 555 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (270) 
 
Primary pointer page: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.31, total records: 3392420 
 
Average version length: 83.50, total versions: 11383, 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: 33, data page slots: 53528 
 
Data pages: 53528, average fill: 78% 
 
Primary pages: 53528, secondary pages: 0, swept pages: 38728 
 
Empty pages: 38, full pages: 49303 
 
Fill distribution: 
 
0 - 19% = 121 
 
20 - 39% = 190 
 
40 - 59% = 743 
 
60 - 79% = 22634 
 
80 - 99% = 29840 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3706, nodes: 3392420 
 
Average node length: 5.03, total dup: 3375741, max dup: 1350 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 713262, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 349 
 
40 - 59% = 2069 
 
60 - 79% = 867 
 
80 - 99% = 397 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5881, nodes: 3392420 
 
Average node length: 6.24, total dup: 2781671, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 387947, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 202 
 
20 - 39% = 2442 
 
40 - 59% = 2215 
 
60 - 79% = 656 
 
80 - 99% = 366 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4072, nodes: 3392420 
 
Average node length: 5.59, total dup: 3095380, max dup: 83 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 754639, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 401 
 
40 - 59% = 2150 
 
60 - 79% = 1071 
 
80 - 99% = 443 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.15, total records: 682824 
 
Average version length: 69.41, total versions: 2446, 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: 9448 
 
Data pages: 9448, average fill: 77% 
 
Primary pages: 9448, secondary pages: 0, swept pages: 6841 
 
Empty pages: 10, full pages: 8996 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 36 
 
40 - 59% = 116 
 
60 - 79% = 9208 
 
80 - 99% = 63 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 172712, depth: 3, leaf buckets: 827, nodes: 682824 
 
Average node length: 5.29, total dup: 646139, max dup: 116 
 
Average key length: 2.41, compression ratio: 3.73 
 
Average prefix length: 8.64, average data length: 0.36 
 
Clustering factor: 54663, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 209 
 
40 - 59% = 332 
 
60 - 79% = 203 
 
80 - 99% = 82 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 952, nodes: 682824 
 
Average node length: 5.92, total dup: 585145, max dup: 21 
 
Average key length: 3.03, compression ratio: 2.97 
 
Average prefix length: 8.11, average data length: 0.89 
 
Clustering factor: 58604, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 245 
 
40 - 59% = 413 
 
60 - 79% = 204 
 
80 - 99% = 85 
 
 
ZDOC_DATA (230) 
 
Primary pointer page: 644, Index root page: 645 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (229) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (231) 
 
Primary pointer page: 646, Index root page: 647 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (234) 
 
Primary pointer page: 652, Index root page: 653 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (235) 
 
Primary pointer page: 654, Index root page: 655 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (232) 
 
Primary pointer page: 648, Index root page: 649 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (233) 
 
Primary pointer page: 650, Index root page: 651 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (228) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (227) 
 
Primary pointer page: 614, Index root page: 615 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 268, Index root page: 269 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Gstat completion time Mon Mar 05 07:13:55 2018 
 
 
Done for 193140 ms, from  7:10:42.04 to  7:13:55.18. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2118429  | 
 2082  | 
 0.0982  | 
|  DOC_LIST  | 
 649253  | 
 282  | 
 0.0434  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 2967  | 
 66  | 
 2.2244  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 134  | 
 90  | 
 67.1641  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 221582  | 
 1101  | 
 0.4968  | 
|  PERF_ESTIMATED  | 
 265898  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 11469512  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 437431  | 
 692  | 
 0.1581  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 0  | 
 0.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2695  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 5929  | 
 1210  | 
 20.4081  | 
|  XQD_1000_3300  | 
 1086877  | 
 2291  | 
 0.2107  | 
|  XQD_1200_2000  | 
 21317  | 
 6681  | 
 31.3411  | 
|  XQD_2000_3300  | 
 1577899  | 
 37019  | 
 2.3460  | 
|  XQD_2100_3300  | 
 1816  | 
 739  | 
 40.6938  | 
|  XQD_3300_3400  | 
 2713144  | 
 12485  | 
 0.4601  | 
|  XQS_1000_1200  | 
 4665875  | 
 1603  | 
 0.0343  | 
|  XQS_1000_3300  | 
 2437240  | 
 11164  | 
 0.4580  | 
|  XQS_1200_2000  | 
 4939484  | 
 16490  | 
 0.3338  | 
|  XQS_2100_3300  | 
 3392420  | 
 11383  | 
 0.3355  | 
|  XQS_3300_3400  | 
 682824  | 
 2446  | 
 0.3582  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2160 ms, from  7:14:06.42 to  7:14:08.58.  
07:14:08.69 Validation started 
 
 
07:14:08.69 Relation 140 (DOC_LIST) 
 
07:14:08.69   process pointer page    0 of    6 
 
07:14:08.82   process pointer page    1 of    6 
 
07:14:08.93   process pointer page    2 of    6 
 
07:14:09.02   process pointer page    3 of    6 
 
07:14:09.08   process pointer page    4 of    6 
 
07:14:09.15   process pointer page    5 of    6 
 
07:14:09.15 Index 1 (PK_DOC_LIST) 
 
07:14:09.36 Index 2 (DOC_LIST_ID_DESC) 
 
07:14:09.66 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:14:09.93 Relation 140 (DOC_LIST) is ok 
 
 
07:14:09.93 Relation 141 (DOC_DATA) 
 
07:14:09.93   process pointer page    0 of   15 
 
07:14:10.00   process pointer page    1 of   15 
 
07:14:10.10   process pointer page    2 of   15 
 
07:14:10.19   process pointer page    3 of   15 
 
07:14:10.28   process pointer page    4 of   15 
 
07:14:10.33   process pointer page    5 of   15 
 
07:14:10.36   process pointer page    6 of   15 
 
07:14:10.39   process pointer page    7 of   15 
 
07:14:10.42   process pointer page    8 of   15 
 
07:14:10.52   process pointer page    9 of   15 
 
07:14:10.60   process pointer page   10 of   15 
 
07:14:10.63   process pointer page   11 of   15 
 
07:14:10.69   process pointer page   12 of   15 
 
07:14:10.74   process pointer page   13 of   15 
 
07:14:10.77   process pointer page   14 of   15 
 
07:14:10.77 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:14:11.72 Index 3 (DOC_DATA_ID_DESC) 
 
07:14:12.48 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:14:13.14 Relation 141 (DOC_DATA) is ok 
 
 
07:14:13.14 Relation 147 (INVNT_SALDO) 
 
07:14:13.14   process pointer page    0 of    1 
 
07:14:13.14 Index 1 (PK_INVNT_SALDO) 
 
07:14:13.14 Relation 147 (INVNT_SALDO) is ok 
 
 
07:14:13.14 Relation 150 (PDISTR) 
 
07:14:13.14   process pointer page    0 of    2 
 
07:14:13.23   process pointer page    1 of    2 
 
07:14:13.26 Index 2 (PDISTR_SND_ID) 
 
07:14:13.29 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:14:13.31 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:14:13.34 Index 5 (PDISTR_AGENT_ID) 
 
07:14:13.37 Relation 150 (PDISTR) is ok 
 
 
07:14:13.37 Relation 151 (PSTORNED) 
 
07:14:13.37   process pointer page    0 of    4 
 
07:14:13.40   process pointer page    1 of    4 
 
07:14:13.44   process pointer page    2 of    4 
 
07:14:13.51   process pointer page    3 of    4 
 
07:14:13.53 Index 2 (PSTORNED_SND_ID) 
 
07:14:13.68 Index 3 (PSTORNED_RCV_ID) 
 
07:14:13.83 Relation 151 (PSTORNED) is ok 
 
 
07:14:13.83 Relation 156 (SEMAPHORES) 
 
07:14:13.83   process pointer page    0 of    1 
 
07:14:13.83 Index 1 (PK_SEMAPHORES) 
 
07:14:13.83 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:14:13.83 Relation 156 (SEMAPHORES) is ok 
 
 
07:14:13.83 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:14:13.83   process pointer page    0 of    2 
 
07:14:13.83   process pointer page    1 of    2 
 
07:14:13.84 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:14:13.84 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:14:13.84 Relation 160 (PERF_ESTIMATED) 
 
07:14:13.84   process pointer page    0 of    2 
 
07:14:13.93   process pointer page    1 of    2 
 
07:14:13.95 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:14:13.98 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:14:13.98 Relation 161 (PERF_ISQL_STAT) 
 
07:14:13.98   process pointer page    0 of    1 
 
07:14:13.98 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:14:13.98 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:14:13.98 Relation 162 (TRACE_STAT) 
 
07:14:13.98   process pointer page    0 of    1 
 
07:14:13.98 Relation 162 (TRACE_STAT) is ok 
 
 
07:14:13.98 Relation 163 (PERF_LOG) 
 
07:14:13.98   process pointer page    0 of  167 
 
07:14:14.04   process pointer page    1 of  167 
 
07:14:14.14   process pointer page    2 of  167 
 
07:14:14.22   process pointer page    3 of  167 
 
07:14:14.26   process pointer page    4 of  167 
 
07:14:14.29   process pointer page    5 of  167 
 
07:14:14.32   process pointer page    6 of  167 
 
07:14:14.37   process pointer page    7 of  167 
 
07:14:14.40   process pointer page    8 of  167 
 
07:14:14.51   process pointer page    9 of  167 
 
07:14:14.59   process pointer page   10 of  167 
 
07:14:14.67   process pointer page   11 of  167 
 
07:14:14.76   process pointer page   12 of  167 
 
07:14:14.84   process pointer page   13 of  167 
 
07:14:14.93   process pointer page   14 of  167 
 
07:14:14.96   process pointer page   15 of  167 
 
07:14:15.01   process pointer page   16 of  167 
 
07:14:15.04   process pointer page   17 of  167 
 
07:14:15.07   process pointer page   18 of  167 
 
07:14:15.10   process pointer page   19 of  167 
 
07:14:15.14   process pointer page   20 of  167 
 
07:14:15.17   process pointer page   21 of  167 
 
07:14:15.20   process pointer page   22 of  167 
 
07:14:15.23   process pointer page   23 of  167 
 
07:14:15.26   process pointer page   24 of  167 
 
07:14:15.29   process pointer page   25 of  167 
 
07:14:15.32   process pointer page   26 of  167 
 
07:14:15.34   process pointer page   27 of  167 
 
07:14:15.37   process pointer page   28 of  167 
 
07:14:15.43   process pointer page   29 of  167 
 
07:14:15.49   process pointer page   30 of  167 
 
07:14:15.53   process pointer page   31 of  167 
 
07:14:15.60   process pointer page   32 of  167 
 
07:14:15.70   process pointer page   33 of  167 
 
07:14:15.78   process pointer page   34 of  167 
 
07:14:15.81   process pointer page   35 of  167 
 
07:14:15.84   process pointer page   36 of  167 
 
07:14:15.93   process pointer page   37 of  167 
 
07:14:16.01   process pointer page   38 of  167 
 
07:14:16.09   process pointer page   39 of  167 
 
07:14:16.17   process pointer page   40 of  167 
 
07:14:16.24   process pointer page   41 of  167 
 
07:14:16.34   process pointer page   42 of  167 
 
07:14:16.41   process pointer page   43 of  167 
 
07:14:16.49   process pointer page   44 of  167 
 
07:14:16.52   process pointer page   45 of  167 
 
07:14:16.60   process pointer page   46 of  167 
 
07:14:16.68   process pointer page   47 of  167 
 
07:14:16.76   process pointer page   48 of  167 
 
07:14:16.84   process pointer page   49 of  167 
 
07:14:16.93   process pointer page   50 of  167 
 
07:14:17.01   process pointer page   51 of  167 
 
07:14:17.09   process pointer page   52 of  167 
 
07:14:17.16   process pointer page   53 of  167 
 
07:14:17.26   process pointer page   54 of  167 
 
07:14:17.34   process pointer page   55 of  167 
 
07:14:17.41   process pointer page   56 of  167 
 
07:14:17.49   process pointer page   57 of  167 
 
07:14:17.57   process pointer page   58 of  167 
 
07:14:17.66   process pointer page   59 of  167 
 
07:14:17.74   process pointer page   60 of  167 
 
07:14:17.82   process pointer page   61 of  167 
 
07:14:17.90   process pointer page   62 of  167 
 
07:14:17.97   process pointer page   63 of  167 
 
07:14:18.07   process pointer page   64 of  167 
 
07:14:18.15   process pointer page   65 of  167 
 
07:14:18.22   process pointer page   66 of  167 
 
07:14:18.30   process pointer page   67 of  167 
 
07:14:18.40   process pointer page   68 of  167 
 
07:14:18.47   process pointer page   69 of  167 
 
07:14:18.55   process pointer page   70 of  167 
 
07:14:18.63   process pointer page   71 of  167 
 
07:14:18.72   process pointer page   72 of  167 
 
07:14:18.80   process pointer page   73 of  167 
 
07:14:18.88   process pointer page   74 of  167 
 
07:14:18.96   process pointer page   75 of  167 
 
07:14:19.04   process pointer page   76 of  167 
 
07:14:19.08   process pointer page   77 of  167 
 
07:14:19.11   process pointer page   78 of  167 
 
07:14:19.14   process pointer page   79 of  167 
 
07:14:19.22   process pointer page   80 of  167 
 
07:14:19.32   process pointer page   81 of  167 
 
07:14:19.39   process pointer page   82 of  167 
 
07:14:19.47   process pointer page   83 of  167 
 
07:14:19.55   process pointer page   84 of  167 
 
07:14:19.63   process pointer page   85 of  167 
 
07:14:19.72   process pointer page   86 of  167 
 
07:14:19.80   process pointer page   87 of  167 
 
07:14:19.88   process pointer page   88 of  167 
 
07:14:19.96   process pointer page   89 of  167 
 
07:14:20.03   process pointer page   90 of  167 
 
07:14:20.11   process pointer page   91 of  167 
 
07:14:20.21   process pointer page   92 of  167 
 
07:14:20.28   process pointer page   93 of  167 
 
07:14:20.36   process pointer page   94 of  167 
 
07:14:20.46   process pointer page   95 of  167 
 
07:14:20.53   process pointer page   96 of  167 
 
07:14:20.61   process pointer page   97 of  167 
 
07:14:20.69   process pointer page   98 of  167 
 
07:14:20.72   process pointer page   99 of  167 
 
07:14:20.75   process pointer page  100 of  167 
 
07:14:20.78   process pointer page  101 of  167 
 
07:14:20.85   process pointer page  102 of  167 
 
07:14:20.91   process pointer page  103 of  167 
 
07:14:20.94   process pointer page  104 of  167 
 
07:14:21.00   process pointer page  105 of  167 
 
07:14:21.03   process pointer page  106 of  167 
 
07:14:21.06   process pointer page  107 of  167 
 
07:14:21.13   process pointer page  108 of  167 
 
07:14:21.20   process pointer page  109 of  167 
 
07:14:21.30   process pointer page  110 of  167 
 
07:14:21.38   process pointer page  111 of  167 
 
07:14:21.45   process pointer page  112 of  167 
 
07:14:21.53   process pointer page  113 of  167 
 
07:14:21.61   process pointer page  114 of  167 
 
07:14:21.70   process pointer page  115 of  167 
 
07:14:21.78   process pointer page  116 of  167 
 
07:14:21.86   process pointer page  117 of  167 
 
07:14:21.95   process pointer page  118 of  167 
 
07:14:22.03   process pointer page  119 of  167 
 
07:14:22.11   process pointer page  120 of  167 
 
07:14:22.19   process pointer page  121 of  167 
 
07:14:22.28   process pointer page  122 of  167 
 
07:14:22.34   process pointer page  123 of  167 
 
07:14:22.37   process pointer page  124 of  167 
 
07:14:22.41   process pointer page  125 of  167 
 
07:14:22.44   process pointer page  126 of  167 
 
07:14:22.51   process pointer page  127 of  167 
 
07:14:22.56   process pointer page  128 of  167 
 
07:14:22.59   process pointer page  129 of  167 
 
07:14:22.62   process pointer page  130 of  167 
 
07:14:22.70   process pointer page  131 of  167 
 
07:14:22.78   process pointer page  132 of  167 
 
07:14:22.86   process pointer page  133 of  167 
 
07:14:22.90   process pointer page  134 of  167 
 
07:14:22.94   process pointer page  135 of  167 
 
07:14:23.01   process pointer page  136 of  167 
 
07:14:23.09   process pointer page  137 of  167 
 
07:14:23.19   process pointer page  138 of  167 
 
07:14:23.26   process pointer page  139 of  167 
 
07:14:23.31   process pointer page  140 of  167 
 
07:14:23.34   process pointer page  141 of  167 
 
07:14:23.37   process pointer page  142 of  167 
 
07:14:23.42   process pointer page  143 of  167 
 
07:14:23.51   process pointer page  144 of  167 
 
07:14:23.59   process pointer page  145 of  167 
 
07:14:23.67   process pointer page  146 of  167 
 
07:14:23.76   process pointer page  147 of  167 
 
07:14:23.84   process pointer page  148 of  167 
 
07:14:23.92   process pointer page  149 of  167 
 
07:14:24.00   process pointer page  150 of  167 
 
07:14:24.07   process pointer page  151 of  167 
 
07:14:24.17   process pointer page  152 of  167 
 
07:14:24.25   process pointer page  153 of  167 
 
07:14:24.32   process pointer page  154 of  167 
 
07:14:24.40   process pointer page  155 of  167 
 
07:14:24.43   process pointer page  156 of  167 
 
07:14:24.50   process pointer page  157 of  167 
 
07:14:24.53   process pointer page  158 of  167 
 
07:14:24.56   process pointer page  159 of  167 
 
07:14:24.60   process pointer page  160 of  167 
 
07:14:24.68   process pointer page  161 of  167 
 
07:14:24.76   process pointer page  162 of  167 
 
07:14:24.85   process pointer page  163 of  167 
 
07:14:24.93   process pointer page  164 of  167 
 
07:14:25.01   process pointer page  165 of  167 
 
07:14:25.10   process pointer page  166 of  167 
 
07:14:25.15 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:14:27.97 Index 2 (PERF_LOG_UNIT) 
 
07:14:33.18 Index 3 (PERF_LOG_TRN_DESC) 
 
07:14:36.37 Index 4 (PERF_LOG_GDSCODE) 
 
07:14:37.88 Relation 163 (PERF_LOG) is ok 
 
 
07:14:37.88 Relation 167 (V_STOPTEST) 
 
07:14:37.88 Relation 167 (V_STOPTEST) is ok 
 
 
07:14:37.88 Relation 184 (V_QDISTR_SOURCE) 
 
07:14:37.88 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:14:37.88 Relation 185 (V_QSTORNED_SOURCE) 
 
07:14:37.88 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:14:37.88 Relation 260 (XQD_1000_1200) 
 
07:14:37.88   process pointer page    0 of    2 
 
07:14:37.88   process pointer page    1 of    2 
 
07:14:37.88 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:14:37.90 Relation 260 (XQD_1000_1200) is ok 
 
 
07:14:37.90 Relation 261 (XQD_1200_2000) 
 
07:14:37.90   process pointer page    0 of    4 
 
07:14:37.91   process pointer page    1 of    4 
 
07:14:37.91   process pointer page    2 of    4 
 
07:14:37.93   process pointer page    3 of    4 
 
07:14:37.94 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:14:37.94 Relation 261 (XQD_1200_2000) is ok 
 
 
07:14:37.94 Relation 262 (XQD_1000_3300) 
 
07:14:37.94   process pointer page    0 of   11 
 
07:14:38.04   process pointer page    1 of   11 
 
07:14:38.13   process pointer page    2 of   11 
 
07:14:38.21   process pointer page    3 of   11 
 
07:14:38.30   process pointer page    4 of   11 
 
07:14:38.38   process pointer page    5 of   11 
 
07:14:38.47   process pointer page    6 of   11 
 
07:14:38.57   process pointer page    7 of   11 
 
07:14:38.61   process pointer page    8 of   11 
 
07:14:38.64   process pointer page    9 of   11 
 
07:14:38.68   process pointer page   10 of   11 
 
07:14:38.72 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:14:39.14 Index 2 (XQD_1000_3300_DOC) 
 
07:14:39.32 Relation 262 (XQD_1000_3300) is ok 
 
 
07:14:39.32 Relation 263 (XQD_2000_3300) 
 
07:14:39.32   process pointer page    0 of   17 
 
07:14:39.39   process pointer page    1 of   17 
 
07:14:39.47   process pointer page    2 of   17 
 
07:14:39.57   process pointer page    3 of   17 
 
07:14:39.66   process pointer page    4 of   17 
 
07:14:39.71   process pointer page    5 of   17 
 
07:14:39.74   process pointer page    6 of   17 
 
07:14:39.78   process pointer page    7 of   17 
 
07:14:39.81   process pointer page    8 of   17 
 
07:14:39.85   process pointer page    9 of   17 
 
07:14:39.88   process pointer page   10 of   17 
 
07:14:39.91   process pointer page   11 of   17 
 
07:14:39.96   process pointer page   12 of   17 
 
07:14:40.03   process pointer page   13 of   17 
 
07:14:40.11   process pointer page   14 of   17 
 
07:14:40.20   process pointer page   15 of   17 
 
07:14:40.28   process pointer page   16 of   17 
 
07:14:40.30 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:14:40.88 Relation 263 (XQD_2000_3300) is ok 
 
 
07:14:40.88 Relation 264 (XQD_2100_3300) 
 
07:14:40.88   process pointer page    0 of    3 
 
07:14:40.88   process pointer page    1 of    3 
 
07:14:40.89   process pointer page    2 of    3 
 
07:14:40.89 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:14:40.89 Relation 264 (XQD_2100_3300) is ok 
 
 
07:14:40.89 Relation 265 (XQD_3300_3400) 
 
07:14:40.89   process pointer page    0 of   25 
 
07:14:40.98   process pointer page    1 of   25 
 
07:14:41.08   process pointer page    2 of   25 
 
07:14:41.16   process pointer page    3 of   25 
 
07:14:41.25   process pointer page    4 of   25 
 
07:14:41.34   process pointer page    5 of   25 
 
07:14:41.42   process pointer page    6 of   25 
 
07:14:41.52   process pointer page    7 of   25 
 
07:14:41.61   process pointer page    8 of   25 
 
07:14:41.69   process pointer page    9 of   25 
 
07:14:41.78   process pointer page   10 of   25 
 
07:14:41.87   process pointer page   11 of   25 
 
07:14:41.95   process pointer page   12 of   25 
 
07:14:42.01   process pointer page   13 of   25 
 
07:14:42.05   process pointer page   14 of   25 
 
07:14:42.08   process pointer page   15 of   25 
 
07:14:42.12   process pointer page   16 of   25 
 
07:14:42.15   process pointer page   17 of   25 
 
07:14:42.17   process pointer page   18 of   25 
 
07:14:42.23   process pointer page   19 of   25 
 
07:14:42.33   process pointer page   20 of   25 
 
07:14:42.36   process pointer page   21 of   25 
 
07:14:42.42   process pointer page   22 of   25 
 
07:14:42.51   process pointer page   23 of   25 
 
07:14:42.56   process pointer page   24 of   25 
 
07:14:42.56 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:14:43.48 Relation 265 (XQD_3300_3400) is ok 
 
 
07:14:43.48 Relation 266 (XQS_1000_1200) 
 
07:14:43.48   process pointer page    0 of   45 
 
07:14:43.51   process pointer page    1 of   45 
 
07:14:43.54   process pointer page    2 of   45 
 
07:14:43.59   process pointer page    3 of   45 
 
07:14:43.68   process pointer page    4 of   45 
 
07:14:43.76   process pointer page    5 of   45 
 
07:14:43.86   process pointer page    6 of   45 
 
07:14:43.95   process pointer page    7 of   45 
 
07:14:44.01   process pointer page    8 of   45 
 
07:14:44.04   process pointer page    9 of   45 
 
07:14:44.09   process pointer page   10 of   45 
 
07:14:44.18   process pointer page   11 of   45 
 
07:14:44.29   process pointer page   12 of   45 
 
07:14:44.40   process pointer page   13 of   45 
 
07:14:44.49   process pointer page   14 of   45 
 
07:14:44.70   process pointer page   15 of   45 
 
07:14:45.15   process pointer page   16 of   45 
 
07:14:45.56   process pointer page   17 of   45 
 
07:14:45.95   process pointer page   18 of   45 
 
07:14:46.38   process pointer page   19 of   45 
 
07:14:46.79   process pointer page   20 of   45 
 
07:14:47.18   process pointer page   21 of   45 
 
07:14:47.66   process pointer page   22 of   45 
 
07:14:48.07   process pointer page   23 of   45 
 
07:14:48.52   process pointer page   24 of   45 
 
07:14:48.97   process pointer page   25 of   45 
 
07:14:49.32   process pointer page   26 of   45 
 
07:14:49.71   process pointer page   27 of   45 
 
07:14:50.10   process pointer page   28 of   45 
 
07:14:50.56   process pointer page   29 of   45 
 
07:14:51.02   process pointer page   30 of   45 
 
07:14:51.47   process pointer page   31 of   45 
 
07:14:51.92   process pointer page   32 of   45 
 
07:14:52.37   process pointer page   33 of   45 
 
07:14:52.86   process pointer page   34 of   45 
 
07:14:53.31   process pointer page   35 of   45 
 
07:14:53.71   process pointer page   36 of   45 
 
07:14:54.17   process pointer page   37 of   45 
 
07:14:54.60   process pointer page   38 of   45 
 
07:14:55.02   process pointer page   39 of   45 
 
07:14:55.46   process pointer page   40 of   45 
 
07:14:55.87   process pointer page   41 of   45 
 
07:14:56.18   process pointer page   42 of   45 
 
07:14:56.52   process pointer page   43 of   45 
 
07:14:56.85   process pointer page   44 of   45 
 
07:14:56.85 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:14:59.36 Index 2 (XQS_1000_1200_SND_ID) 
 
07:15:01.72 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:15:04.01 Relation 266 (XQS_1000_1200) is ok 
 
 
07:15:04.01 Relation 267 (XQS_1200_2000) 
 
07:15:04.01   process pointer page    0 of   48 
 
07:15:04.40   process pointer page    1 of   48 
 
07:15:04.81   process pointer page    2 of   48 
 
07:15:05.21   process pointer page    3 of   48 
 
07:15:05.63   process pointer page    4 of   48 
 
07:15:06.04   process pointer page    5 of   48 
 
07:15:06.46   process pointer page    6 of   48 
 
07:15:06.85   process pointer page    7 of   48 
 
07:15:07.26   process pointer page    8 of   48 
 
07:15:07.66   process pointer page    9 of   48 
 
07:15:08.08   process pointer page   10 of   48 
 
07:15:08.50   process pointer page   11 of   48 
 
07:15:08.91   process pointer page   12 of   48 
 
07:15:09.35   process pointer page   13 of   48 
 
07:15:09.75   process pointer page   14 of   48 
 
07:15:10.11   process pointer page   15 of   48 
 
07:15:10.56   process pointer page   16 of   48 
 
07:15:11.01   process pointer page   17 of   48 
 
07:15:11.47   process pointer page   18 of   48 
 
07:15:11.95   process pointer page   19 of   48 
 
07:15:12.42   process pointer page   20 of   48 
 
07:15:12.93   process pointer page   21 of   48 
 
07:15:13.32   process pointer page   22 of   48 
 
07:15:13.79   process pointer page   23 of   48 
 
07:15:14.26   process pointer page   24 of   48 
 
07:15:14.76   process pointer page   25 of   48 
 
07:15:15.21   process pointer page   26 of   48 
 
07:15:15.68   process pointer page   27 of   48 
 
07:15:16.15   process pointer page   28 of   48 
 
07:15:16.60   process pointer page   29 of   48 
 
07:15:17.05   process pointer page   30 of   48 
 
07:15:17.50   process pointer page   31 of   48 
 
07:15:17.96   process pointer page   32 of   48 
 
07:15:18.42   process pointer page   33 of   48 
 
07:15:18.89   process pointer page   34 of   48 
 
07:15:19.35   process pointer page   35 of   48 
 
07:15:19.80   process pointer page   36 of   48 
 
07:15:20.27   process pointer page   37 of   48 
 
07:15:20.72   process pointer page   38 of   48 
 
07:15:21.15   process pointer page   39 of   48 
 
07:15:21.62   process pointer page   40 of   48 
 
07:15:22.04   process pointer page   41 of   48 
 
07:15:22.48   process pointer page   42 of   48 
 
07:15:22.93   process pointer page   43 of   48 
 
07:15:23.37   process pointer page   44 of   48 
 
07:15:23.76   process pointer page   45 of   48 
 
07:15:24.15   process pointer page   46 of   48 
 
07:15:24.59   process pointer page   47 of   48 
 
07:15:24.81 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:15:27.47 Index 2 (XQS_1200_2000_SND_ID) 
 
07:15:30.39 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:15:33.21 Relation 267 (XQS_1200_2000) is ok 
 
 
07:15:33.21 Relation 268 (XQS_1000_3300) 
 
07:15:33.21   process pointer page    0 of   24 
 
07:15:33.67   process pointer page    1 of   24 
 
07:15:34.15   process pointer page    2 of   24 
 
07:15:34.62   process pointer page    3 of   24 
 
07:15:35.10   process pointer page    4 of   24 
 
07:15:35.57   process pointer page    5 of   24 
 
07:15:35.99   process pointer page    6 of   24 
 
07:15:36.43   process pointer page    7 of   24 
 
07:15:36.83   process pointer page    8 of   24 
 
07:15:37.30   process pointer page    9 of   24 
 
07:15:37.77   process pointer page   10 of   24 
 
07:15:38.24   process pointer page   11 of   24 
 
07:15:38.75   process pointer page   12 of   24 
 
07:15:39.22   process pointer page   13 of   24 
 
07:15:39.69   process pointer page   14 of   24 
 
07:15:40.16   process pointer page   15 of   24 
 
07:15:40.62   process pointer page   16 of   24 
 
07:15:41.09   process pointer page   17 of   24 
 
07:15:41.54   process pointer page   18 of   24 
 
07:15:42.01   process pointer page   19 of   24 
 
07:15:42.46   process pointer page   20 of   24 
 
07:15:42.93   process pointer page   21 of   24 
 
07:15:43.38   process pointer page   22 of   24 
 
07:15:43.82   process pointer page   23 of   24 
 
07:15:44.01 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:15:45.37 Index 2 (XQS_1000_3300_SND_ID) 
 
07:15:46.94 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:15:48.47 Relation 268 (XQS_1000_3300) is ok 
 
 
07:15:48.47 Relation 269 (XQS_2000_3300) 
 
07:15:48.47   process pointer page    0 of    1 
 
07:15:48.47 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:15:48.47 Index 2 (XQS_2000_3300_SND_ID) 
 
07:15:48.47 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:15:48.47 Relation 269 (XQS_2000_3300) is ok 
 
 
07:15:48.47 Relation 270 (XQS_2100_3300) 
 
07:15:48.47   process pointer page    0 of   33 
 
07:15:48.94   process pointer page    1 of   33 
 
07:15:49.41   process pointer page    2 of   33 
 
07:15:49.87   process pointer page    3 of   33 
 
07:15:50.36   process pointer page    4 of   33 
 
07:15:50.84   process pointer page    5 of   33 
 
07:15:51.31   process pointer page    6 of   33 
 
07:15:51.79   process pointer page    7 of   33 
 
07:15:52.26   process pointer page    8 of   33 
 
07:15:52.74   process pointer page    9 of   33 
 
07:15:53.21   process pointer page   10 of   33 
 
07:15:53.68   process pointer page   11 of   33 
 
07:15:54.15   process pointer page   12 of   33 
 
07:15:54.62   process pointer page   13 of   33 
 
07:15:55.08   process pointer page   14 of   33 
 
07:15:55.55   process pointer page   15 of   33 
 
07:15:56.02   process pointer page   16 of   33 
 
07:15:56.47   process pointer page   17 of   33 
 
07:15:56.94   process pointer page   18 of   33 
 
07:15:57.41   process pointer page   19 of   33 
 
07:15:57.88   process pointer page   20 of   33 
 
07:15:58.35   process pointer page   21 of   33 
 
07:15:58.81   process pointer page   22 of   33 
 
07:15:59.27   process pointer page   23 of   33 
 
07:15:59.70   process pointer page   24 of   33 
 
07:16:00.11   process pointer page   25 of   33 
 
07:16:00.58   process pointer page   26 of   33 
 
07:16:01.03   process pointer page   27 of   33 
 
07:16:01.50   process pointer page   28 of   33 
 
07:16:01.95   process pointer page   29 of   33 
 
07:16:02.40   process pointer page   30 of   33 
 
07:16:02.84   process pointer page   31 of   33 
 
07:16:03.26   process pointer page   32 of   33 
 
07:16:03.53 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:16:05.69 Index 2 (XQS_2100_3300_SND_ID) 
 
07:16:07.92 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:16:10.25 Relation 270 (XQS_2100_3300) is ok 
 
 
07:16:10.25 Relation 271 (XQS_3300_3400) 
 
07:16:10.25   process pointer page    0 of    6 
 
07:16:10.70   process pointer page    1 of    6 
 
07:16:11.17   process pointer page    2 of    6 
 
07:16:11.58   process pointer page    3 of    6 
 
07:16:12.01   process pointer page    4 of    6 
 
07:16:12.50   process pointer page    5 of    6 
 
07:16:12.84 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:16:13.23 Index 2 (XQS_3300_3400_SND_ID) 
 
07:16:13.65 Relation 271 (XQS_3300_3400) is ok 
 
 
07:16:13.67 Validation finished 
 
Done for 125130 ms, from  7:14:08.60 to  7:16:13.73. 
 
 Differences between old and current firebird.log 
7:16:15.69. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2018-03-05  07:16               471 oltp30_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Mon Mar 05 07:14:08 2018 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Mon Mar 05 07:16:13 2018 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 401 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2018-03-05  7:16:23.71 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html