|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 6090.38  | 
 3830  | 
 1096268  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  customer order: creation  | 
 475.43  | 
 524  | 
 85578  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  customer order: refuse  | 
 37.80  | 
 266  | 
 6804  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  order to supplier: creation  | 
 122.26  | 
 2304  | 
 22006  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  order to supplier: removal  | 
 3.11  | 
 22993  | 
 560  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  invoice (draft): creation  | 
 121.83  | 
 3495  | 
 21929  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  invoice (draft): removal  | 
 44.26  | 
 536  | 
 7966  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  invoice accept: apply  | 
 66.29  | 
 13104  | 
 11932  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  invoice accept: cancel  | 
 18.49  | 
 2990  | 
 3309  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  customer reserve: creation  | 
 3492.16  | 
 206  | 
 628588  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  customer reserve: removal  | 
 1054.58  | 
 75  | 
 189824  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  realization accept: apply  | 
 218.08  | 
 592  | 
 39254  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  realization accept: cancel  | 
 92.48  | 
 171  | 
 16647  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  payment from customer: creation  | 
 159.33  | 
 918  | 
 28679  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  payment from customer: removal  | 
 15.19  | 
 153  | 
 2735  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  payment to supplier: creation  | 
 131.12  | 
 727  | 
 23601  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  payment to supplier: removal  | 
 8.99  | 
 154  | 
 1618  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  service: total inventory turnovers  | 
 9.04  | 
 3490  | 
 1628  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  service: total monetary turnovers  | 
 19.99  | 
 67  | 
 3599  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 20014  | 
 11  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
 
Done for 65460 ms, from  6:49:06.04 to  6:50:11.50.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4994  | 
 103857  | 
 89886  | 
 13971  | 
 13.45  | 
 03:46:43  | 
 04:04:43  | 
|  interval #   2, overall  | 
 2  | 
 5888  | 
 118379  | 
 105975  | 
 12404  | 
 10.48  | 
 04:04:44  | 
 04:22:44  | 
|  interval #   3, overall  | 
 3  | 
 5996  | 
 121095  | 
 107923  | 
 13172  | 
 10.88  | 
 04:22:45  | 
 04:40:45  | 
|  interval #   4, overall  | 
 4  | 
 6363  | 
 128365  | 
 114534  | 
 13831  | 
 10.77  | 
 04:40:46  | 
 04:58:46  | 
|  interval #   5, overall  | 
 5  | 
 6174  | 
 124055  | 
 111127  | 
 12928  | 
 10.42  | 
 04:58:47  | 
 05:16:47  | 
|  interval #   6, overall  | 
 6  | 
 6663  | 
 135526  | 
 119930  | 
 15596  | 
 11.51  | 
 05:16:48  | 
 05:34:48  | 
|  interval #   7, overall  | 
 7  | 
 6114  | 
 121145  | 
 110058  | 
 11087  | 
 9.15  | 
 05:34:49  | 
 05:52:49  | 
|  interval #   8, overall  | 
 8  | 
 6306  | 
 128556  | 
 113507  | 
 15049  | 
 11.71  | 
 05:52:50  | 
 06:10:50  | 
|  interval #   9, overall  | 
 9  | 
 6253  | 
 131140  | 
 112547  | 
 18593  | 
 14.18  | 
 06:10:51  | 
 06:28:51  | 
|  interval #  10, overall  | 
 10  | 
 6155  | 
 118431  | 
 110781  | 
 7650  | 
 6.46  | 
 06:28:52  | 
 06:46:52  | 
 
Done for 188730 ms, from  6:53:19.68 to  6:56:28.41.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 3243.34  | 
 0.1245  | 
 1.6335  | 
 2883  | 
 19  | 
|  TEST_TIME  | 
 2  | 
 3520.70  | 
 0.7525  | 
 1.1977  | 
 1626  | 
 22  | 
|  TEST_TIME  | 
 3  | 
 3178.26  | 
 0.8846  | 
 1.1324  | 
 1258  | 
 21  | 
|  TEST_TIME  | 
 4  | 
 3152.24  | 
 0.8564  | 
 1.1437  | 
 1280  | 
 21  | 
|  TEST_TIME  | 
 5  | 
 3229.38  | 
 0.8931  | 
 1.1240  | 
 1645  | 
 28  | 
|  TEST_TIME  | 
 6  | 
 3291.30  | 
 0.9192  | 
 1.1002  | 
 1508  | 
 27  | 
|  TEST_TIME  | 
 7  | 
 3409.59  | 
 0.9104  | 
 1.1001  | 
 1757  | 
 41  | 
|  TEST_TIME  | 
 8  | 
 3555.56  | 
 0.9231  | 
 1.0762  | 
 1717  | 
 100  | 
|  TEST_TIME  | 
 9  | 
 3710.88  | 
 0.9181  | 
 1.0843  | 
 1780  | 
 100  | 
|  TEST_TIME  | 
 10  | 
 3897.31  | 
 0.9292  | 
 1.0644  | 
 2115  | 
 100  | 
|  TEST_TIME  | 
 11  | 
 4028.57  | 
 0.9369  | 
 1.0603  | 
 2139  | 
 100  | 
|  TEST_TIME  | 
 12  | 
 4136.16  | 
 0.9467  | 
 1.0403  | 
 1563  | 
 100  | 
|  TEST_TIME  | 
 13  | 
 4163.85  | 
 0.9539  | 
 1.0417  | 
 1684  | 
 100  | 
|  TEST_TIME  | 
 14  | 
 4267.24  | 
 0.9439  | 
 1.0518  | 
 1563  | 
 100  | 
|  TEST_TIME  | 
 15  | 
 4415.18  | 
 0.9488  | 
 1.0533  | 
 1963  | 
 100  | 
|  TEST_TIME  | 
 16  | 
 4605.60  | 
 0.9466  | 
 1.0630  | 
 2361  | 
 100  | 
|  TEST_TIME  | 
 17  | 
 4780.23  | 
 0.9639  | 
 1.0508  | 
 2024  | 
 100  | 
|  TEST_TIME  | 
 18  | 
 4899.91  | 
 0.9682  | 
 1.0410  | 
 1978  | 
 100  | 
|  TEST_TIME  | 
 19  | 
 5011.10  | 
 0.9644  | 
 1.0367  | 
 1759  | 
 100  | 
|  TEST_TIME  | 
 20  | 
 5129.34  | 
 0.9623  | 
 1.0367  | 
 1624  | 
 100  | 
|  TEST_TIME  | 
 21  | 
 5227.20  | 
 0.9689  | 
 1.0337  | 
 1884  | 
 100  | 
|  TEST_TIME  | 
 22  | 
 5297.99  | 
 0.9738  | 
 1.0179  | 
 1695  | 
 100  | 
|  TEST_TIME  | 
 23  | 
 5237.97  | 
 0.9848  | 
 1.0199  | 
 1580  | 
 97  | 
|  TEST_TIME  | 
 24  | 
 5272.73  | 
 0.9710  | 
 1.0093  | 
 1273  | 
 99  | 
|  TEST_TIME  | 
 25  | 
 5212.20  | 
 0.9816  | 
 1.0074  | 
 1218  | 
 96  | 
|  TEST_TIME  | 
 26  | 
 5206.94  | 
 0.9696  | 
 1.0208  | 
 1273  | 
 100  | 
|  TEST_TIME  | 
 27  | 
 5219.38  | 
 0.9806  | 
 1.0203  | 
 1291  | 
 100  | 
|  TEST_TIME  | 
 28  | 
 5172.74  | 
 0.9928  | 
 1.0143  | 
 1419  | 
 98  | 
|  TEST_TIME  | 
 29  | 
 5191.35  | 
 0.9759  | 
 1.0172  | 
 1266  | 
 100  | 
|  TEST_TIME  | 
 30  | 
 5205.36  | 
 0.9806  | 
 1.0142  | 
 2268  | 
 100  | 
|  TEST_TIME  | 
 31  | 
 5222.44  | 
 0.9783  | 
 1.0213  | 
 1737  | 
 98  | 
|  TEST_TIME  | 
 32  | 
 5320.91  | 
 0.9711  | 
 1.0156  | 
 2178  | 
 100  | 
|  TEST_TIME  | 
 33  | 
 5332.26  | 
 0.9827  | 
 1.0214  | 
 2261  | 
 97  | 
|  TEST_TIME  | 
 34  | 
 5362.76  | 
 0.9857  | 
 1.0156  | 
 2006  | 
 96  | 
|  TEST_TIME  | 
 35  | 
 5386.21  | 
 0.9823  | 
 1.0191  | 
 1565  | 
 97  | 
|  TEST_TIME  | 
 36  | 
 5407.99  | 
 0.9868  | 
 1.0059  | 
 1564  | 
 100  | 
|  TEST_TIME  | 
 37  | 
 5403.95  | 
 0.9871  | 
 1.0088  | 
 1408  | 
 99  | 
|  TEST_TIME  | 
 38  | 
 5382.17  | 
 0.9862  | 
 1.0090  | 
 1550  | 
 100  | 
|  TEST_TIME  | 
 39  | 
 5376.08  | 
 0.9842  | 
 1.0155  | 
 1551  | 
 100  | 
|  TEST_TIME  | 
 40  | 
 5388.85  | 
 0.9878  | 
 1.0177  | 
 1470  | 
 100  | 
|  TEST_TIME  | 
 41  | 
 5423.18  | 
 0.9870  | 
 1.0082  | 
 1395  | 
 100  | 
|  TEST_TIME  | 
 42  | 
 5409.88  | 
 0.9866  | 
 1.0186  | 
 1322  | 
 100  | 
|  TEST_TIME  | 
 43  | 
 5439.50  | 
 0.9895  | 
 1.0123  | 
 1311  | 
 100  | 
|  TEST_TIME  | 
 44  | 
 5420.89  | 
 0.9927  | 
 1.0097  | 
 1218  | 
 99  | 
|  TEST_TIME  | 
 45  | 
 5417.07  | 
 0.9880  | 
 1.0108  | 
 2194  | 
 100  | 
|  TEST_TIME  | 
 46  | 
 5442.06  | 
 0.9842  | 
 1.0095  | 
 2033  | 
 99  | 
|  TEST_TIME  | 
 47  | 
 5440.51  | 
 0.9883  | 
 1.0187  | 
 1864  | 
 98  | 
|  TEST_TIME  | 
 48  | 
 5489.59  | 
 0.9886  | 
 1.0132  | 
 1805  | 
 100  | 
|  TEST_TIME  | 
 49  | 
 5512.27  | 
 0.9885  | 
 1.0106  | 
 1853  | 
 100  | 
|  TEST_TIME  | 
 50  | 
 5524.45  | 
 0.9885  | 
 1.0129  | 
 1850  | 
 100  | 
|  TEST_TIME  | 
 51  | 
 5559.54  | 
 0.9867  | 
 1.0083  | 
 1857  | 
 99  | 
|  TEST_TIME  | 
 52  | 
 5563.95  | 
 0.9881  | 
 1.0103  | 
 1758  | 
 100  | 
|  TEST_TIME  | 
 53  | 
 5570.97  | 
 0.9900  | 
 1.0094  | 
 1639  | 
 100  | 
|  TEST_TIME  | 
 54  | 
 5583.78  | 
 0.9884  | 
 1.0149  | 
 1576  | 
 100  | 
|  TEST_TIME  | 
 55  | 
 5624.47  | 
 0.9892  | 
 1.0095  | 
 1514  | 
 100  | 
|  TEST_TIME  | 
 56  | 
 5615.01  | 
 0.9932  | 
 1.0096  | 
 1429  | 
 100  | 
|  TEST_TIME  | 
 57  | 
 5627.67  | 
 0.9897  | 
 1.0076  | 
 1488  | 
 100  | 
|  TEST_TIME  | 
 58  | 
 5624.36  | 
 0.9908  | 
 1.0106  | 
 1279  | 
 100  | 
|  TEST_TIME  | 
 59  | 
 5633.18  | 
 0.9919  | 
 1.0074  | 
 1275  | 
 100  | 
|  TEST_TIME  | 
 60  | 
 5607.71  | 
 0.9954  | 
 1.0053  | 
 1603  | 
 100  | 
|  TEST_TIME  | 
 61  | 
 5613.80  | 
 0.9878  | 
 1.0100  | 
 1957  | 
 100  | 
|  TEST_TIME  | 
 62  | 
 5638.81  | 
 0.9893  | 
 1.0082  | 
 2121  | 
 98  | 
|  TEST_TIME  | 
 63  | 
 5638.34  | 
 0.9923  | 
 1.0085  | 
 2062  | 
 99  | 
|  TEST_TIME  | 
 64  | 
 5672.38  | 
 0.9868  | 
 1.0095  | 
 1832  | 
 100  | 
|  TEST_TIME  | 
 65  | 
 5688.02  | 
 0.9913  | 
 1.0071  | 
 2057  | 
 100  | 
|  TEST_TIME  | 
 66  | 
 5692.03  | 
 0.9911  | 
 1.0075  | 
 1821  | 
 99  | 
|  TEST_TIME  | 
 67  | 
 5702.93  | 
 0.9906  | 
 1.0097  | 
 1608  | 
 100  | 
|  TEST_TIME  | 
 68  | 
 5715.88  | 
 0.9926  | 
 1.0064  | 
 1673  | 
 100  | 
|  TEST_TIME  | 
 69  | 
 5740.01  | 
 0.9876  | 
 1.0107  | 
 1431  | 
 100  | 
|  TEST_TIME  | 
 70  | 
 5763.54  | 
 0.9922  | 
 1.0080  | 
 1442  | 
 100  | 
|  TEST_TIME  | 
 71  | 
 5783.54  | 
 0.9904  | 
 1.0083  | 
 1396  | 
 100  | 
|  TEST_TIME  | 
 72  | 
 5785.32  | 
 0.9940  | 
 1.0068  | 
 1447  | 
 100  | 
|  TEST_TIME  | 
 73  | 
 5781.00  | 
 0.9937  | 
 1.0075  | 
 1446  | 
 100  | 
|  TEST_TIME  | 
 74  | 
 5779.65  | 
 0.9941  | 
 1.0036  | 
 1415  | 
 100  | 
|  TEST_TIME  | 
 75  | 
 5772.21  | 
 0.9915  | 
 1.0060  | 
 1850  | 
 99  | 
|  TEST_TIME  | 
 76  | 
 5795.23  | 
 0.9888  | 
 1.0058  | 
 1746  | 
 100  | 
|  TEST_TIME  | 
 77  | 
 5787.63  | 
 0.9940  | 
 1.0089  | 
 1265  | 
 100  | 
|  TEST_TIME  | 
 78  | 
 5786.23  | 
 0.9962  | 
 1.0085  | 
 1948  | 
 97  | 
|  TEST_TIME  | 
 79  | 
 5800.90  | 
 0.9932  | 
 1.0059  | 
 1803  | 
 97  | 
|  TEST_TIME  | 
 80  | 
 5811.64  | 
 0.9915  | 
 1.0055  | 
 1733  | 
 99  | 
|  TEST_TIME  | 
 81  | 
 5810.71  | 
 0.9932  | 
 1.0080  | 
 1452  | 
 100  | 
|  TEST_TIME  | 
 82  | 
 5828.68  | 
 0.9926  | 
 1.0035  | 
 1474  | 
 100  | 
|  TEST_TIME  | 
 83  | 
 5825.56  | 
 0.9919  | 
 1.0094  | 
 1370  | 
 100  | 
|  TEST_TIME  | 
 84  | 
 5849.12  | 
 0.9934  | 
 1.0038  | 
 1589  | 
 100  | 
|  TEST_TIME  | 
 85  | 
 5828.58  | 
 0.9955  | 
 1.0047  | 
 1550  | 
 96  | 
|  TEST_TIME  | 
 86  | 
 5822.21  | 
 0.9941  | 
 1.0058  | 
 1509  | 
 94  | 
|  TEST_TIME  | 
 87  | 
 5818.53  | 
 0.9948  | 
 1.0048  | 
 1467  | 
 94  | 
|  TEST_TIME  | 
 88  | 
 5821.94  | 
 0.9928  | 
 1.0051  | 
 1247  | 
 100  | 
|  TEST_TIME  | 
 89  | 
 5828.15  | 
 0.9928  | 
 1.0051  | 
 1382  | 
 100  | 
|  TEST_TIME  | 
 90  | 
 5845.20  | 
 0.9911  | 
 1.0069  | 
 2458  | 
 100  | 
|  TEST_TIME  | 
 91  | 
 5864.31  | 
 0.9926  | 
 1.0088  | 
 2114  | 
 98  | 
|  TEST_TIME  | 
 92  | 
 5895.71  | 
 0.9926  | 
 1.0085  | 
 1756  | 
 99  | 
|  TEST_TIME  | 
 93  | 
 5919.15  | 
 0.9937  | 
 1.0063  | 
 1655  | 
 100  | 
|  TEST_TIME  | 
 94  | 
 5930.56  | 
 0.9937  | 
 1.0038  | 
 1660  | 
 100  | 
|  TEST_TIME  | 
 95  | 
 5928.87  | 
 0.9935  | 
 1.0033  | 
 1734  | 
 100  | 
|  TEST_TIME  | 
 96  | 
 5921.40  | 
 0.9941  | 
 1.0043  | 
 1422  | 
 99  | 
|  TEST_TIME  | 
 97  | 
 5909.11  | 
 0.9960  | 
 1.0039  | 
 1569  | 
 88  | 
|  TEST_TIME  | 
 98  | 
 5920.06  | 
 0.9918  | 
 1.0052  | 
 1362  | 
 100  | 
|  TEST_TIME  | 
 99  | 
 5916.80  | 
 0.9956  | 
 1.0047  | 
 1458  | 
 99  | 
|  TEST_TIME  | 
 100  | 
 5935.87  | 
 0.9915  | 
 1.0032  | 
 1377  | 
 100  | 
|  TEST_TIME  | 
 101  | 
 5916.80  | 
 0.9964  | 
 1.0080  | 
 1329  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 5941.64  | 
 0.9940  | 
 1.0057  | 
 1301  | 
 100  | 
|  TEST_TIME  | 
 103  | 
 5953.68  | 
 0.9939  | 
 1.0068  | 
 1286  | 
 100  | 
|  TEST_TIME  | 
 104  | 
 5965.93  | 
 0.9952  | 
 1.0023  | 
 1296  | 
 100  | 
|  TEST_TIME  | 
 105  | 
 5961.29  | 
 0.9936  | 
 1.0046  | 
 1907  | 
 100  | 
|  TEST_TIME  | 
 106  | 
 5976.19  | 
 0.9927  | 
 1.0036  | 
 1852  | 
 97  | 
|  TEST_TIME  | 
 107  | 
 5965.36  | 
 0.9960  | 
 1.0050  | 
 1640  | 
 88  | 
|  TEST_TIME  | 
 108  | 
 5984.53  | 
 0.9925  | 
 1.0051  | 
 1704  | 
 99  | 
|  TEST_TIME  | 
 109  | 
 5990.52  | 
 0.9949  | 
 1.0055  | 
 1708  | 
 98  | 
|  TEST_TIME  | 
 110  | 
 5990.76  | 
 0.9964  | 
 1.0044  | 
 1653  | 
 93  | 
|  TEST_TIME  | 
 111  | 
 5997.10  | 
 0.9943  | 
 1.0071  | 
 1523  | 
 96  | 
|  TEST_TIME  | 
 112  | 
 6026.33  | 
 0.9932  | 
 1.0040  | 
 1223  | 
 100  | 
|  TEST_TIME  | 
 113  | 
 6028.67  | 
 0.9947  | 
 1.0045  | 
 1431  | 
 100  | 
|  TEST_TIME  | 
 114  | 
 6013.86  | 
 0.9981  | 
 1.0022  | 
 1570  | 
 98  | 
|  TEST_TIME  | 
 115  | 
 6011.36  | 
 0.9940  | 
 1.0040  | 
 1307  | 
 99  | 
|  TEST_TIME  | 
 116  | 
 6020.16  | 
 0.9939  | 
 1.0040  | 
 1359  | 
 100  | 
|  TEST_TIME  | 
 117  | 
 6020.66  | 
 0.9954  | 
 1.0024  | 
 1296  | 
 98  | 
|  TEST_TIME  | 
 118  | 
 6014.74  | 
 0.9949  | 
 1.0038  | 
 1269  | 
 99  | 
|  TEST_TIME  | 
 119  | 
 5997.38  | 
 0.9983  | 
 1.0019  | 
 1355  | 
 98  | 
|  TEST_TIME  | 
 120  | 
 5976.65  | 
 0.9970  | 
 1.0028  | 
 1355  | 
 95  | 
|  TEST_TIME  | 
 121  | 
 5989.21  | 
 0.9924  | 
 1.0062  | 
 1773  | 
 97  | 
|  TEST_TIME  | 
 122  | 
 5991.20  | 
 0.9976  | 
 1.0027  | 
 1774  | 
 93  | 
|  TEST_TIME  | 
 123  | 
 6003.50  | 
 0.9927  | 
 1.0054  | 
 1675  | 
 98  | 
|  TEST_TIME  | 
 124  | 
 6000.80  | 
 0.9978  | 
 1.0027  | 
 1872  | 
 95  | 
|  TEST_TIME  | 
 125  | 
 6008.15  | 
 0.9934  | 
 1.0046  | 
 1460  | 
 98  | 
|  TEST_TIME  | 
 126  | 
 6003.24  | 
 0.9975  | 
 1.0027  | 
 1691  | 
 99  | 
|  TEST_TIME  | 
 127  | 
 6006.25  | 
 0.9943  | 
 1.0056  | 
 1510  | 
 100  | 
|  TEST_TIME  | 
 128  | 
 6018.42  | 
 0.9958  | 
 1.0043  | 
 1348  | 
 100  | 
|  TEST_TIME  | 
 129  | 
 6016.36  | 
 0.9968  | 
 1.0024  | 
 1660  | 
 100  | 
|  TEST_TIME  | 
 130  | 
 6012.83  | 
 0.9953  | 
 1.0049  | 
 1376  | 
 98  | 
|  TEST_TIME  | 
 131  | 
 6022.79  | 
 0.9956  | 
 1.0073  | 
 1275  | 
 100  | 
|  TEST_TIME  | 
 132  | 
 6039.62  | 
 0.9969  | 
 1.0021  | 
 1344  | 
 100  | 
|  TEST_TIME  | 
 133  | 
 6025.25  | 
 0.9969  | 
 1.0033  | 
 1275  | 
 100  | 
|  TEST_TIME  | 
 134  | 
 6008.53  | 
 0.9986  | 
 1.0041  | 
 1110  | 
 96  | 
|  TEST_TIME  | 
 135  | 
 6025.94  | 
 0.9937  | 
 1.0049  | 
 1401  | 
 100  | 
|  TEST_TIME  | 
 136  | 
 6036.81  | 
 0.9958  | 
 1.0046  | 
 2031  | 
 98  | 
|  TEST_TIME  | 
 137  | 
 6038.50  | 
 0.9970  | 
 1.0035  | 
 1849  | 
 97  | 
|  TEST_TIME  | 
 138  | 
 6047.30  | 
 0.9947  | 
 1.0031  | 
 1773  | 
 92  | 
|  TEST_TIME  | 
 139  | 
 6044.29  | 
 0.9964  | 
 1.0048  | 
 1584  | 
 92  | 
|  TEST_TIME  | 
 140  | 
 6049.76  | 
 0.9967  | 
 1.0028  | 
 1601  | 
 96  | 
|  TEST_TIME  | 
 141  | 
 6047.25  | 
 0.9961  | 
 1.0027  | 
 1517  | 
 99  | 
|  TEST_TIME  | 
 142  | 
 6040.38  | 
 0.9968  | 
 1.0054  | 
 1267  | 
 100  | 
|  TEST_TIME  | 
 143  | 
 6053.27  | 
 0.9969  | 
 1.0023  | 
 1458  | 
 100  | 
|  TEST_TIME  | 
 144  | 
 6039.68  | 
 0.9976  | 
 1.0028  | 
 1546  | 
 98  | 
|  TEST_TIME  | 
 145  | 
 6048.39  | 
 0.9945  | 
 1.0036  | 
 1416  | 
 100  | 
|  TEST_TIME  | 
 146  | 
 6055.27  | 
 0.9956  | 
 1.0035  | 
 1283  | 
 100  | 
|  TEST_TIME  | 
 147  | 
 6050.85  | 
 0.9974  | 
 1.0023  | 
 1551  | 
 99  | 
|  TEST_TIME  | 
 148  | 
 6041.32  | 
 0.9971  | 
 1.0049  | 
 1407  | 
 99  | 
|  TEST_TIME  | 
 149  | 
 6050.27  | 
 0.9967  | 
 1.0020  | 
 1151  | 
 100  | 
|  TEST_TIME  | 
 150  | 
 6051.07  | 
 0.9952  | 
 1.0031  | 
 1768  | 
 99  | 
|  TEST_TIME  | 
 151  | 
 6062.22  | 
 0.9946  | 
 1.0056  | 
 1531  | 
 99  | 
|  TEST_TIME  | 
 152  | 
 6068.72  | 
 0.9980  | 
 1.0029  | 
 1916  | 
 94  | 
|  TEST_TIME  | 
 153  | 
 6064.54  | 
 0.9970  | 
 1.0030  | 
 1659  | 
 92  | 
|  TEST_TIME  | 
 154  | 
 6074.74  | 
 0.9948  | 
 1.0025  | 
 1640  | 
 96  | 
|  TEST_TIME  | 
 155  | 
 6068.16  | 
 0.9971  | 
 1.0048  | 
 1544  | 
 94  | 
|  TEST_TIME  | 
 156  | 
 6073.94  | 
 0.9974  | 
 1.0024  | 
 1557  | 
 97  | 
|  TEST_TIME  | 
 157  | 
 6073.44  | 
 0.9960  | 
 1.0026  | 
 1476  | 
 93  | 
|  TEST_TIME  | 
 158  | 
 6079.49  | 
 0.9971  | 
 1.0029  | 
 1353  | 
 98  | 
|  TEST_TIME  | 
 159  | 
 6075.40  | 
 0.9973  | 
 1.0025  | 
 1419  | 
 91  | 
|  TEST_TIME  | 
 160  | 
 6067.38  | 
 0.9975  | 
 1.0024  | 
 1328  | 
 93  | 
|  TEST_TIME  | 
 161  | 
 6060.72  | 
 0.9973  | 
 1.0024  | 
 1178  | 
 88  | 
|  TEST_TIME  | 
 162  | 
 6053.19  | 
 0.9975  | 
 1.0027  | 
 1247  | 
 87  | 
|  TEST_TIME  | 
 163  | 
 6050.65  | 
 0.9969  | 
 1.0026  | 
 1268  | 
 92  | 
|  TEST_TIME  | 
 164  | 
 6045.32  | 
 0.9974  | 
 1.0025  | 
 1328  | 
 92  | 
|  TEST_TIME  | 
 165  | 
 6035.83  | 
 0.9980  | 
 1.0025  | 
 1214  | 
 95  | 
|  TEST_TIME  | 
 166  | 
 6038.35  | 
 0.9960  | 
 1.0057  | 
 1640  | 
 95  | 
|  TEST_TIME  | 
 167  | 
 6061.10  | 
 0.9959  | 
 1.0024  | 
 1638  | 
 100  | 
|  TEST_TIME  | 
 168  | 
 6060.70  | 
 0.9965  | 
 1.0023  | 
 1729  | 
 95  | 
|  TEST_TIME  | 
 169  | 
 6057.91  | 
 0.9968  | 
 1.0032  | 
 1698  | 
 95  | 
|  TEST_TIME  | 
 170  | 
 6065.64  | 
 0.9974  | 
 1.0020  | 
 1646  | 
 94  | 
|  TEST_TIME  | 
 171  | 
 6062.88  | 
 0.9966  | 
 1.0028  | 
 1494  | 
 91  | 
|  TEST_TIME  | 
 172  | 
 6063.42  | 
 0.9969  | 
 1.0039  | 
 1447  | 
 94  | 
|  TEST_TIME  | 
 173  | 
 6066.24  | 
 0.9976  | 
 1.0055  | 
 1250  | 
 98  | 
|  TEST_TIME  | 
 174  | 
 6077.15  | 
 0.9981  | 
 1.0025  | 
 1636  | 
 99  | 
|  TEST_TIME  | 
 175  | 
 6075.17  | 
 0.9971  | 
 1.0020  | 
 1355  | 
 100  | 
|  TEST_TIME  | 
 176  | 
 6069.62  | 
 0.9972  | 
 1.0022  | 
 1259  | 
 97  | 
|  TEST_TIME  | 
 177  | 
 6071.42  | 
 0.9963  | 
 1.0036  | 
 1323  | 
 97  | 
|  TEST_TIME  | 
 178  | 
 6070.96  | 
 0.9981  | 
 1.0025  | 
 1244  | 
 94  | 
|  TEST_TIME  | 
 179  | 
 6087.95  | 
 0.9941  | 
 1.0036  | 
 984  | 
 99  | 
|  TEST_TIME  | 
 180  | 
 6080.88  | 
 0.9992  | 
 1.0015  | 
 1037  | 
 98  | 
 
Done for 9810 ms, from  6:56:29.94 to  6:56:39.75.  
 
 
|  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  | 
 38304  | 
 49364  | 
 34442  | 
 <null>  | 
 37671  | 
 8413  | 
 44217  | 
 <null>  | 
 46675  | 
 14870  | 
 37584  | 
 50006  | 
 70891  | 
 68147  | 
 98590  | 
 25753  | 
 213278  | 
 223636  | 
 <null>  | 
 03:46:43  | 
 04:04:43  | 
|  fetches per second  | 
 2  | 
 22038  | 
 52085  | 
 30595  | 
 <null>  | 
 32064  | 
 4749  | 
 54480  | 
 4856  | 
 73230  | 
 60934  | 
 30562  | 
 18144  | 
 25127  | 
 61017  | 
 33908  | 
 5335  | 
 357926  | 
 160923  | 
 <null>  | 
 04:04:44  | 
 04:22:44  | 
|  fetches per second  | 
 3  | 
 13579  | 
 10377  | 
 11367  | 
 4879  | 
 13039  | 
 46561  | 
 28515  | 
 <null>  | 
 22689  | 
 54470  | 
 25451  | 
 4962  | 
 27106  | 
 3043  | 
 72761  | 
 13028  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:22:45  | 
 04:40:45  | 
|  fetches per second  | 
 4  | 
 22029  | 
 46091  | 
 24203  | 
 <null>  | 
 17963  | 
 25890  | 
 39990  | 
 7871  | 
 27971  | 
 89461  | 
 28493  | 
 27342  | 
 57415  | 
 974  | 
 33244  | 
 <null>  | 
 15740  | 
 229475  | 
 <null>  | 
 04:40:46  | 
 04:58:46  | 
|  fetches per second  | 
 5  | 
 12814  | 
 67298  | 
 10017  | 
 <null>  | 
 17897  | 
 127613  | 
 30097  | 
 45838  | 
 46058  | 
 5954  | 
 15134  | 
 4423  | 
 29797  | 
 46426  | 
 64362  | 
 36467  | 
 50375  | 
 40673  | 
 <null>  | 
 04:58:47  | 
 05:16:47  | 
|  fetches per second  | 
 6  | 
 11077  | 
 25933  | 
 17025  | 
 38818  | 
 21374  | 
 43071  | 
 28576  | 
 174504  | 
 44972  | 
 7876  | 
 26432  | 
 11237  | 
 45606  | 
 4305  | 
 43395  | 
 3907  | 
 25827  | 
 22445  | 
 <null>  | 
 05:16:48  | 
 05:34:48  | 
|  fetches per second  | 
 7  | 
 11674  | 
 5747  | 
 7424  | 
 49519  | 
 16949  | 
 <null>  | 
 25755  | 
 3942  | 
 5894  | 
 3011  | 
 17089  | 
 6585  | 
 33677  | 
 9774  | 
 21380  | 
 5294  | 
 16276  | 
 66540  | 
 <null>  | 
 05:34:49  | 
 05:52:49  | 
|  fetches per second  | 
 8  | 
 7539  | 
 5311  | 
 5438  | 
 8737  | 
 11764  | 
 <null>  | 
 29733  | 
 6280  | 
 108237  | 
 3991  | 
 7581  | 
 2344  | 
 10350  | 
 4245  | 
 19435  | 
 8194  | 
 139974  | 
 133748  | 
 <null>  | 
 05:52:50  | 
 06:10:50  | 
|  fetches per second  | 
 9  | 
 5703  | 
 3521  | 
 27681  | 
 5304  | 
 5242  | 
 7515  | 
 32398  | 
 <null>  | 
 9132  | 
 75432  | 
 9027  | 
 18571  | 
 14310  | 
 <null>  | 
 39882  | 
 12032  | 
 <null>  | 
 291662  | 
 <null>  | 
 06:10:51  | 
 06:28:51  | 
|  fetches per second  | 
 10  | 
 8370  | 
 4160  | 
 3617  | 
 <null>  | 
 5717  | 
 5297  | 
 19636  | 
 5017  | 
 7450  | 
 15344  | 
 6981  | 
 1846  | 
 30803  | 
 4902  | 
 22138  | 
 175250  | 
 39869  | 
 18016  | 
 <null>  | 
 06:28:52  | 
 06:46:52  | 
|  marks per second  | 
 1  | 
 8390  | 
 6593  | 
 7224  | 
 <null>  | 
 7998  | 
 2239  | 
 6338  | 
 <null>  | 
 6189  | 
 3096  | 
 5987  | 
 8750  | 
 5646  | 
 10913  | 
 4403  | 
 3707  | 
 12490  | 
 4999  | 
 <null>  | 
 03:46:43  | 
 04:04:43  | 
|  marks per second  | 
 2  | 
 4560  | 
 6416  | 
 6503  | 
 <null>  | 
 7370  | 
 969  | 
 9269  | 
 748  | 
 15280  | 
 10220  | 
 4010  | 
 3105  | 
 1938  | 
 10335  | 
 3170  | 
 1000  | 
 44442  | 
 12082  | 
 <null>  | 
 04:04:44  | 
 04:22:44  | 
|  marks per second  | 
 3  | 
 2810  | 
 1267  | 
 2203  | 
 858  | 
 2346  | 
 10193  | 
 3449  | 
 <null>  | 
 2721  | 
 8453  | 
 3536  | 
 813  | 
 1645  | 
 466  | 
 4398  | 
 2126  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:22:45  | 
 04:40:45  | 
|  marks per second  | 
 4  | 
 4331  | 
 5578  | 
 4975  | 
 <null>  | 
 3750  | 
 6177  | 
 5073  | 
 1067  | 
 1239  | 
 15076  | 
 3210  | 
 2919  | 
 2694  | 
 146  | 
 2404  | 
 <null>  | 
 1537  | 
 11636  | 
 <null>  | 
 04:40:46  | 
 04:58:46  | 
|  marks per second  | 
 5  | 
 2632  | 
 9210  | 
 1815  | 
 <null>  | 
 3875  | 
 27260  | 
 2880  | 
 6373  | 
 3512  | 
 892  | 
 2968  | 
 653  | 
 1200  | 
 7114  | 
 3693  | 
 7851  | 
 1371  | 
 1429  | 
 <null>  | 
 04:58:47  | 
 05:16:47  | 
|  marks per second  | 
 6  | 
 2333  | 
 3674  | 
 3222  | 
 5564  | 
 3847  | 
 10380  | 
 3795  | 
 24083  | 
 7073  | 
 1355  | 
 2922  | 
 1315  | 
 1586  | 
 706  | 
 2098  | 
 538  | 
 1714  | 
 732  | 
 <null>  | 
 05:16:48  | 
 05:34:48  | 
|  marks per second  | 
 7  | 
 2457  | 
 740  | 
 1027  | 
 6971  | 
 3410  | 
 <null>  | 
 2679  | 
 547  | 
 728  | 
 615  | 
 1391  | 
 1099  | 
 1378  | 
 1464  | 
 1560  | 
 895  | 
 267  | 
 1462  | 
 <null>  | 
 05:34:49  | 
 05:52:49  | 
|  marks per second  | 
 8  | 
 1463  | 
 696  | 
 849  | 
 1192  | 
 1838  | 
 <null>  | 
 3113  | 
 872  | 
 2536  | 
 646  | 
 691  | 
 341  | 
 340  | 
 644  | 
 990  | 
 1651  | 
 3222  | 
 887  | 
 <null>  | 
 05:52:50  | 
 06:10:50  | 
|  marks per second  | 
 9  | 
 1193  | 
 461  | 
 5478  | 
 810  | 
 755  | 
 1656  | 
 3610  | 
 <null>  | 
 563  | 
 12492  | 
 1703  | 
 2492  | 
 704  | 
 <null>  | 
 5022  | 
 1664  | 
 <null>  | 
 8573  | 
 <null>  | 
 06:10:51  | 
 06:28:51  | 
|  marks per second  | 
 10  | 
 1494  | 
 513  | 
 521  | 
 <null>  | 
 788  | 
 1244  | 
 1398  | 
 697  | 
 480  | 
 2857  | 
 721  | 
 276  | 
 717  | 
 751  | 
 973  | 
 22250  | 
 13055  | 
 518  | 
 <null>  | 
 06:28:52  | 
 06:46:52  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 03:46:43  | 
 04:04:43  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:04:44  | 
 04:22:44  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:22:45  | 
 04:40:45  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:40:46  | 
 04:58:46  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:58:47  | 
 05:16:47  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:16:48  | 
 05:34:48  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:34:49  | 
 05:52:49  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:52:50  | 
 06:10:50  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:10:51  | 
 06:28:51  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:28:52  | 
 06:46:52  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 1  | 
 0  | 
 1  | 
 3  | 
 0  | 
 <null>  | 
 03:46:43  | 
 04:04:43  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 04:04:44  | 
 04:22:44  | 
|  writes/marks*100  | 
 3  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 <null>  | 
 04:22:45  | 
 04:40:45  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:40:46  | 
 04:58:46  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:58:47  | 
 05:16:47  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:16:48  | 
 05:34:48  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 5  | 
 0  | 
 <null>  | 
 05:34:49  | 
 05:52:49  | 
|  writes/marks*100  | 
 8  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 3  | 
 0  | 
 <null>  | 
 05:52:50  | 
 06:10:50  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 2  | 
 1  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:10:51  | 
 06:28:51  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:28:52  | 
 06:46:52  | 
 
Done for 8370 ms, from  6:56:40.72 to  6:56:49.09.  
 
 
|  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  | 
 1899146  | 
 1777621  | 
 121525  | 
 6.39  | 
 0  | 
 12855  | 
 55  | 
 121525  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  doc_list_biud  | 
 1899580  | 
 1777621  | 
 121959  | 
 6.42  | 
 0  | 
 8705  | 
 19  | 
 121959  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_add_invoice_to_stock  | 
 20584  | 
 11932  | 
 8652  | 
 42.03  | 
 15  | 
 289084  | 
 13104  | 
 8652  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_adding_invoice  | 
 4247  | 
 3309  | 
 938  | 
 22.08  | 
 0  | 
 64085  | 
 2990  | 
 938  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_client_order  | 
 6960  | 
 6804  | 
 156  | 
 2.24  | 
 0  | 
 2293  | 
 266  | 
 156  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_customer_reserve  | 
 302490  | 
 189824  | 
 112666  | 
 37.24  | 
 0  | 
 4680  | 
 75  | 
 112666  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2748  | 
 2735  | 
 13  | 
 0.47  | 
 0  | 
 2870  | 
 153  | 
 13  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1622  | 
 1618  | 
 4  | 
 0.24  | 
 0  | 
 2917  | 
 154  | 
 4  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_supplier_invoice  | 
 10200  | 
 7966  | 
 2234  | 
 21.90  | 
 0  | 
 12183  | 
 536  | 
 2234  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_supplier_order  | 
 1656  | 
 560  | 
 1096  | 
 66.18  | 
 31  | 
 205624  | 
 22993  | 
 1096  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_cancel_write_off  | 
 23608  | 
 16647  | 
 6961  | 
 29.48  | 
 0  | 
 6256  | 
 171  | 
 6961  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_client_order  | 
 85578  | 
 85578  | 
 0  | 
 0.00  | 
 0  | 
 4743  | 
 524  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_customer_reserve  | 
 628588  | 
 628588  | 
 0  | 
 0.00  | 
 0  | 
 7285  | 
 206  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_fill_shopping_cart  | 
 129773  | 
 129513  | 
 260  | 
 0.20  | 
 0  | 
 4898  | 
 104  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 628588  | 
 628588  | 
 0  | 
 0.00  | 
 0  | 
 4680  | 
 15  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_get_clo_for_invoice  | 
 11932  | 
 11932  | 
 0  | 
 0.00  | 
 0  | 
 6754  | 
 364  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_kill_cost_storno  | 
 31825  | 
 24309  | 
 7516  | 
 23.61  | 
 0  | 
 2605  | 
 24  | 
 7516  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 638325  | 
 404821  | 
 233504  | 
 36.58  | 
 0  | 
 8175  | 
 29  | 
 233504  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_kill_qty_storno  | 
 398172  | 
 276296  | 
 121876  | 
 30.60  | 
 0  | 
 8674  | 
 86  | 
 121876  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_lock_selected_doc  | 
 84219  | 
 71864  | 
 12355  | 
 14.67  | 
 0  | 
 2153  | 
 8  | 
 12355  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_make_cost_storno  | 
 103466  | 
 103466  | 
 0  | 
 0.00  | 
 0  | 
 12698  | 
 453  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 103466  | 
 103466  | 
 0  | 
 0.00  | 
 0  | 
 3963  | 
 61  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 85578  | 
 85578  | 
 0  | 
 0.00  | 
 0  | 
 3151  | 
 175  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_pay_from_customer  | 
 28679  | 
 28679  | 
 0  | 
 0.00  | 
 0  | 
 13463  | 
 918  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_pay_to_supplier  | 
 23601  | 
 23601  | 
 0  | 
 0.00  | 
 0  | 
 11169  | 
 727  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_payment_common  | 
 52280  | 
 52280  | 
 0  | 
 0.00  | 
 0  | 
 3385  | 
 64  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 6957  | 
 6804  | 
 153  | 
 2.19  | 
 0  | 
 2262  | 
 116  | 
 153  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 15990  | 
 15241  | 
 749  | 
 4.68  | 
 0  | 
 8642  | 
 394  | 
 749  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 39254  | 
 39254  | 
 0  | 
 0.00  | 
 0  | 
 2933  | 
 55  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_reserve_write_off  | 
 40555  | 
 39254  | 
 1301  | 
 3.20  | 
 0  | 
 12027  | 
 592  | 
 1301  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_supplier_invoice  | 
 22031  | 
 21929  | 
 102  | 
 0.46  | 
 0  | 
 30685  | 
 3495  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  sp_supplier_order  | 
 22164  | 
 22006  | 
 158  | 
 0.71  | 
 0  | 
 14539  | 
 2304  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  srv_find_qd_qs_mism  | 
 1120150  | 
 998642  | 
 121508  | 
 10.84  | 
 0  | 
 10203  | 
 31  | 
 121508  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  srv_make_invnt_saldo  | 
 1628  | 
 1628  | 
 0  | 
 0.00  | 
 46  | 
 28626  | 
 3490  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  srv_make_money_saldo  | 
 3599  | 
 3599  | 
 0  | 
 0.00  | 
 0  | 
 2340  | 
 67  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  srv_recalc_idx_stat  | 
 11  | 
 11  | 
 0  | 
 0.00  | 
 1856  | 
 54522  | 
 20014  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 8652  | 
 8652  | 
 0  | 
 0.00  | 
 0  | 
 1684  | 
 103  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 763  | 
 763  | 
 0  | 
 0.00  | 
 0  | 
 2059  | 
 225  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 156  | 
 156  | 
 0  | 
 0.00  | 
 0  | 
 1716  | 
 108  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 93  | 
 93  | 
 0  | 
 0.00  | 
 0  | 
 873  | 
 86  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 13  | 
 13  | 
 0  | 
 0.00  | 
 0  | 
 889  | 
 152  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 4  | 
 4  | 
 0  | 
 0.00  | 
 0  | 
 140  | 
 58  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 740  | 
 740  | 
 0  | 
 0.00  | 
 0  | 
 982  | 
 98  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 14024  | 
 14024  | 
 0  | 
 0.00  | 
 0  | 
 2839  | 
 143  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 35  | 
 35  | 
 0  | 
 0.00  | 
 0  | 
 811  | 
 53  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1301  | 
 1301  | 
 0  | 
 0.00  | 
 0  | 
 1233  | 
 81  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 102  | 
 102  | 
 0  | 
 0.00  | 
 0  | 
 1607  | 
 117  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 158  | 
 158  | 
 0  | 
 0.00  | 
 0  | 
 1404  | 
 107  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 11932  | 
 11932  | 
 0  | 
 0.00  | 
 0  | 
 22137  | 
 706  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1337  | 
 1337  | 
 0  | 
 0.00  | 
 0  | 
 9735  | 
 821  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6804  | 
 6804  | 
 0  | 
 0.00  | 
 0  | 
 1810  | 
 74  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2667  | 
 2667  | 
 0  | 
 0.00  | 
 0  | 
 1872  | 
 73  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2735  | 
 2735  | 
 0  | 
 0.00  | 
 0  | 
 1482  | 
 62  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1618  | 
 1618  | 
 0  | 
 0.00  | 
 0  | 
 1497  | 
 50  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 1000  | 
 1000  | 
 0  | 
 0.00  | 
 0  | 
 1701  | 
 86  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 560  | 
 560  | 
 0  | 
 0.00  | 
 0  | 
 43649  | 
 2230  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3957  | 
 3957  | 
 0  | 
 0.00  | 
 0  | 
 2636  | 
 76  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_client_order  | 
 85578  | 
 85578  | 
 0  | 
 0.00  | 
 0  | 
 3058  | 
 89  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 4174  | 
 4174  | 
 0  | 
 0.00  | 
 0  | 
 1779  | 
 65  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 28679  | 
 28679  | 
 0  | 
 0.00  | 
 0  | 
 2636  | 
 77  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 23601  | 
 23601  | 
 0  | 
 0.00  | 
 0  | 
 1653  | 
 69  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 39254  | 
 39254  | 
 0  | 
 0.00  | 
 0  | 
 2433  | 
 82  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 21929  | 
 21929  | 
 0  | 
 0.00  | 
 0  | 
 2138  | 
 77  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 22006  | 
 22006  | 
 0  | 
 0.00  | 
 0  | 
 2620  | 
 83  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1628  | 
 1628  | 
 0  | 
 0.00  | 
 0  | 
 1388  | 
 34  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 3599  | 
 3599  | 
 0  | 
 0.00  | 
 0  | 
 1139  | 
 28  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 11  | 
 11  | 
 0  | 
 0.00  | 
 0  | 
 1716  | 
 327  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_add_invoice_to_stock  | 
 41168  | 
 23864  | 
 17304  | 
 42.03  | 
 0  | 
 1716  | 
 19  | 
 17304  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_all_customers  | 
 128504  | 
 128504  | 
 0  | 
 0.00  | 
 0  | 
 592  | 
 6  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_all_suppliers  | 
 88414  | 
 87894  | 
 520  | 
 0.58  | 
 0  | 
 795  | 
 6  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_all_wares  | 
 171156  | 
 171156  | 
 0  | 
 0.00  | 
 0  | 
 1170  | 
 5  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_adding_invoice  | 
 3204  | 
 2674  | 
 530  | 
 16.54  | 
 0  | 
 3136  | 
 172  | 
 530  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_client_order  | 
 13920  | 
 13608  | 
 312  | 
 2.24  | 
 0  | 
 952  | 
 7  | 
 312  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_customer_prepayment  | 
 5496  | 
 5470  | 
 26  | 
 0.47  | 
 0  | 
 952  | 
 9  | 
 26  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_customer_reserve  | 
 5520  | 
 5334  | 
 186  | 
 3.36  | 
 0  | 
 1217  | 
 10  | 
 186  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_payment_to_supplier  | 
 3244  | 
 3236  | 
 8  | 
 0.24  | 
 0  | 
 1388  | 
 10  | 
 8  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_supplier_invoice  | 
 3480  | 
 2000  | 
 1480  | 
 42.52  | 
 0  | 
 951  | 
 22  | 
 1480  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_supplier_order  | 
 3312  | 
 1120  | 
 2192  | 
 66.18  | 
 0  | 
 515  | 
 10  | 
 2192  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_cancel_write_off  | 
 7984  | 
 7914  | 
 70  | 
 0.87  | 
 0  | 
 3712  | 
 107  | 
 70  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_max_id_clo_ord  | 
 22164  | 
 22006  | 
 158  | 
 0.71  | 
 0  | 
 842  | 
 6  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_max_id_clo_res  | 
 4174  | 
 4174  | 
 0  | 
 0.00  | 
 0  | 
 1077  | 
 19  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_max_id_ord_sup  | 
 22031  | 
 21929  | 
 102  | 
 0.46  | 
 0  | 
 671  | 
 6  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_max_non_paid_invoice  | 
 23589  | 
 23589  | 
 0  | 
 0.00  | 
 0  | 
 780  | 
 6  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_max_non_paid_realizn  | 
 28679  | 
 28679  | 
 0  | 
 0.00  | 
 0  | 
 874  | 
 6  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_min_id_clo_ord  | 
 22164  | 
 22006  | 
 158  | 
 0.71  | 
 0  | 
 1295  | 
 8  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_min_id_clo_res  | 
 4174  | 
 4174  | 
 0  | 
 0.00  | 
 0  | 
 764  | 
 10  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_min_id_ord_sup  | 
 22031  | 
 21929  | 
 102  | 
 0.46  | 
 0  | 
 1342  | 
 8  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_min_non_paid_invoice  | 
 23601  | 
 23601  | 
 0  | 
 0.00  | 
 0  | 
 2574  | 
 11  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_min_non_paid_realizn  | 
 28679  | 
 28679  | 
 0  | 
 0.00  | 
 0  | 
 1435  | 
 9  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_our_firm  | 
 42652  | 
 42652  | 
 0  | 
 0.00  | 
 0  | 
 1170  | 
 6  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  v_reserve_write_off  | 
 81110  | 
 78508  | 
 2602  | 
 3.20  | 
 0  | 
 2059  | 
 9  | 
 2602  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 18940  | 
 10275  | 
 8665  | 
 45.74  | 
 0  | 
 1700  | 
 35  | 
 8665  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1650  | 
 560  | 
 1090  | 
 66.06  | 
 0  | 
 1061  | 
 63  | 
 1090  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  x_make_qstorno_1000_1200  | 
 22164  | 
 22006  | 
 158  | 
 0.71  | 
 0  | 
 13963  | 
 2073  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  x_make_qstorno_1200_2000  | 
 22031  | 
 21929  | 
 102  | 
 0.46  | 
 0  | 
 29905  | 
 3261  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  x_make_qstorno_2100_3300  | 
 628588  | 
 628588  | 
 0  | 
 0.00  | 
 0  | 
 7004  | 
 174  | 
 0  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
 
Done for 291300 ms, from  7:01:31.86 to  7:06:23.16.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 99  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2017-11-16 03:47  | 
 2017-11-16 06:42  | 
|  deadlock  | 
 75  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2017-11-16 03:47  | 
 2017-11-16 06:44  | 
|  deadlock  | 
 10847  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2017-11-16 03:46  | 
 2017-11-16 06:46  | 
|  deadlock  | 
 153  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2017-11-16 03:47  | 
 2017-11-16 06:45  | 
|  deadlock  | 
 167  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2017-11-16 03:47  | 
 2017-11-16 06:45  | 
|  deadlock  | 
 696  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2017-11-16 03:47  | 
 2017-11-16 06:46  | 
|  deadlock  | 
 309  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2017-11-16 03:56  | 
 2017-11-16 06:46  | 
|  user_exc  | 
 158  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2017-11-16 03:48  | 
 2017-11-16 06:43  | 
|  user_exc  | 
 102  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2017-11-16 03:48  | 
 2017-11-16 06:40  | 
 
Done for 8580 ms, from  7:06:29.43 to  7:06:38.01.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          448837
 
MON$OLDEST_ACTIVE               448838
 
MON$OLDEST_SNAPSHOT             448838
 
MON$NEXT_TRANSACTION            448838
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2017-01-11 15:12:20.4040
 
MON$PAGES                       836288
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.3.32837 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32837 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32837 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32837 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Gstat execution time Thu Nov 16 07:06:38 2017 
 
 
Database header page information: 
 
Flags			0 
 
Generation		449044 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	448839 
 
Oldest active		448840 
 
Oldest snapshot		448840 
 
Next transaction	448841 
 
Sequence number		0 
 
Next attachment ID	9572 
 
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.13, total records: 2212272 
 
Average version length: 47.86, total versions: 4100, 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: 24048 
 
Data pages: 24048, average fill: 72% 
 
Primary pages: 24048, secondary pages: 0, swept pages: 14246 
 
Empty pages: 6, full pages: 20128 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 8 
 
40 - 59% = 113 
 
60 - 79% = 23918 
 
80 - 99% = 2 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10785, nodes: 2212272 
 
Average node length: 19.34, total dup: 0, max dup: 0 
 
Average key length: 16.38, compression ratio: 1.65 
 
Average prefix length: 13.62, average data length: 13.38 
 
Clustering factor: 506581, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 642 
 
20 - 39% = 2432 
 
40 - 59% = 5199 
 
60 - 79% = 1124 
 
80 - 99% = 1388 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7966, nodes: 2212272 
 
Average node length: 11.63, total dup: 0, max dup: 0 
 
Average key length: 8.68, compression ratio: 1.04 
 
Average prefix length: 3.32, average data length: 5.68 
 
Clustering factor: 475654, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 3863 
 
40 - 59% = 4033 
 
60 - 79% = 63 
 
80 - 99% = 6 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 176368, depth: 3, leaf buckets: 4003, nodes: 2212272 
 
Average node length: 6.83, total dup: 1606890, max dup: 49 
 
Average key length: 3.88, compression ratio: 2.32 
 
Average prefix length: 7.39, average data length: 1.61 
 
Clustering factor: 465873, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 158 
 
20 - 39% = 1382 
 
40 - 59% = 1783 
 
60 - 79% = 165 
 
80 - 99% = 515 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.33, total records: 672941 
 
Average version length: 36.25, total versions: 2030, max versions: 4 
 
Average fragment length: 4.17, total fragments: 6, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8552 
 
Data pages: 8552, average fill: 75% 
 
Primary pages: 8550, secondary pages: 2, swept pages: 7730 
 
Empty pages: 2, full pages: 7587 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 11 
 
40 - 59% = 35 
 
60 - 79% = 8468 
 
80 - 99% = 31 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 249265, depth: 3, leaf buckets: 2490, nodes: 672941 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 169231, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1417 
 
40 - 59% = 1033 
 
60 - 79% = 35 
 
80 - 99% = 4 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 707, nodes: 672941 
 
Average node length: 4.88, total dup: 672891, max dup: 46364 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 308808, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 603 
 
60 - 79% = 79 
 
80 - 99% = 25 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 317935, depth: 3, leaf buckets: 2083, nodes: 672941 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 169231, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 149 
 
20 - 39% = 687 
 
40 - 59% = 776 
 
60 - 79% = 217 
 
80 - 99% = 254 
 
 
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: 65.65, total records: 400 
 
Average version length: 20.85, total versions: 91836, max versions: 1442 
 
Average fragment length: 18.72, total fragments: 377, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.58 
 
Pointer pages: 1, data page slots: 1632 
 
Data pages: 1632, average fill: 34% 
 
Primary pages: 7, secondary pages: 1625, swept pages: 2 
 
Empty pages: 3, full pages: 4 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 1586 
 
40 - 59% = 38 
 
60 - 79% = 1 
 
80 - 99% = 4 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 12.23, total records: 19567 
 
Average version length: 71.14, total versions: 16209, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 7.85 
 
Pointer pages: 2, data page slots: 1416 
 
Data pages: 688, average fill: 38% 
 
Primary pages: 685, secondary pages: 3, swept pages: 53 
 
Empty pages: 157, full pages: 120 
 
Fill distribution: 
 
0 - 19% = 244 
 
20 - 39% = 117 
 
40 - 59% = 153 
 
60 - 79% = 87 
 
80 - 99% = 87 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 71, nodes: 19567 
 
Average node length: 13.76, total dup: 909, max dup: 1 
 
Average key length: 11.73, compression ratio: 2.30 
 
Average prefix length: 18.22, average data length: 8.78 
 
Clustering factor: 15102, ratio: 0.77 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 24 
 
40 - 59% = 35 
 
60 - 79% = 11 
 
80 - 99% = 1 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 14.98, 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.14 
 
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: 42.90, total records: 63 
 
Average version length: 45.17, total versions: 6, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.49 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 7% 
 
Primary pages: 16, secondary pages: 0, swept pages: 13 
 
Empty pages: 5, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 266924, depth: 2, leaf buckets: 1, nodes: 63 
 
Average node length: 12.52, total dup: 30, max dup: 5 
 
Average key length: 10.89, compression ratio: 1.74 
 
Average prefix length: 10.62, average data length: 8.38 
 
Clustering factor: 44, ratio: 0.70 
 
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: 41.31, total records: 222008 
 
Average version length: 32.94, total versions: 10194, max versions: 7 
 
Average fragment length: 33.00, total fragments: 3, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.55 
 
Pointer pages: 2, data page slots: 2536 
 
Data pages: 2536, average fill: 66% 
 
Primary pages: 2530, secondary pages: 6, swept pages: 880 
 
Empty pages: 10, full pages: 1016 
 
Fill distribution: 
 
0 - 19% = 30 
 
20 - 39% = 105 
 
40 - 59% = 347 
 
60 - 79% = 2030 
 
80 - 99% = 24 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 208, nodes: 222008 
 
Average node length: 4.53, total dup: 221959, max dup: 11920 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 36617, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 20 
 
40 - 59% = 89 
 
60 - 79% = 77 
 
80 - 99% = 22 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 244, nodes: 222008 
 
Average node length: 5.48, total dup: 200022, max dup: 45 
 
Average key length: 2.96, compression ratio: 7.43 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 47680, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 10 
 
40 - 59% = 108 
 
60 - 79% = 81 
 
80 - 99% = 43 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 246, nodes: 222008 
 
Average node length: 5.48, total dup: 200022, max dup: 45 
 
Average key length: 2.96, compression ratio: 7.43 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 47778, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 14 
 
40 - 59% = 104 
 
60 - 79% = 95 
 
80 - 99% = 32 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 232, nodes: 222008 
 
Average node length: 5.27, total dup: 200022, max dup: 45 
 
Average key length: 2.75, compression ratio: 3.28 
 
Average prefix length: 8.35, average data length: 0.65 
 
Clustering factor: 47762, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 16 
 
40 - 59% = 99 
 
60 - 79% = 79 
 
80 - 99% = 38 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.97, total records: 285102 
 
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: 2440 
 
Data pages: 2440, average fill: 64% 
 
Primary pages: 2440, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 2435 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 2435 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 350620, depth: 2, leaf buckets: 228, nodes: 285102 
 
Average node length: 4.55, total dup: 284921, max dup: 2882 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 61883, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 92 
 
60 - 79% = 62 
 
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.57, total records: 11662296 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1696.00, compression ratio: 11.19 
 
Pointer pages: 170, data page slots: 276424 
 
Data pages: 276424, average fill: 87% 
 
Primary pages: 276424, secondary pages: 0, swept pages: 3 
 
Empty pages: 2, full pages: 276421 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 276421 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 12898, nodes: 11662296 
 
Average node length: 5.66, total dup: 10808656, max dup: 152 
 
Average key length: 2.18, compression ratio: 3.67 
 
Average prefix length: 7.86, average data length: 0.13 
 
Clustering factor: 4711057, ratio: 0.40 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 0 
 
40 - 59% = 6652 
 
60 - 79% = 4180 
 
80 - 99% = 2055 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 11538, nodes: 11662296 
 
Average node length: 4.56, total dup: 11662292, max dup: 10750792 
 
Average key length: 1.08, compression ratio: 0.36 
 
Average prefix length: 0.39, average data length: 0.00 
 
Clustering factor: 347904, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 11534 
 
60 - 79% = 0 
 
80 - 99% = 3 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 14005, nodes: 11662296 
 
Average node length: 5.73, total dup: 11281616, max dup: 26498 
 
Average key length: 2.24, compression ratio: 4.02 
 
Average prefix length: 8.79, average data length: 0.21 
 
Clustering factor: 1064908, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 1 
 
40 - 59% = 10022 
 
60 - 79% = 2162 
 
80 - 99% = 1818 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 14197, nodes: 11662296 
 
Average node length: 5.56, total dup: 11633200, max dup: 1492711 
 
Average key length: 2.07, compression ratio: 18.23 
 
Average prefix length: 37.70, average data length: 0.07 
 
Clustering factor: 6840949, ratio: 0.59 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 2 
 
40 - 59% = 12193 
 
60 - 79% = 681 
 
80 - 99% = 1300 
 
 
PHRASES (145) 
 
Primary pointer page: 266, Index root page: 267 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.86, total records: 471591 
 
Average version length: 56.12, total versions: 2315, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.46 
 
Pointer pages: 4, data page slots: 5584 
 
Data pages: 5584, average fill: 75% 
 
Primary pages: 5584, secondary pages: 0, swept pages: 3331 
 
Empty pages: 2, full pages: 5410 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 8 
 
60 - 79% = 5564 
 
80 - 99% = 7 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 616239, depth: 3, leaf buckets: 629, nodes: 471591 
 
Average node length: 5.95, total dup: 396957, max dup: 953 
 
Average key length: 3.15, compression ratio: 2.86 
 
Average prefix length: 8.01, average data length: 0.99 
 
Clustering factor: 62841, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 32 
 
40 - 59% = 374 
 
60 - 79% = 163 
 
80 - 99% = 44 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 799842, depth: 3, leaf buckets: 504, nodes: 471591 
 
Average node length: 5.60, total dup: 420918, max dup: 106 
 
Average key length: 2.80, compression ratio: 3.21 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 117043, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 13 
 
40 - 59% = 205 
 
60 - 79% = 190 
 
80 - 99% = 95 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 9.00, total versions: 2295, max versions: 1627 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 46% 
 
Primary pages: 7, secondary pages: 9, swept pages: 0 
 
Empty pages: 7, full pages: 8 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 7 
 
 
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.86, total records: 2696 
 
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.50 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 62% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 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: 12.91, total records: 27347 
 
Average version length: 72.18, total versions: 22453, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 10.53 
 
Pointer pages: 2, data page slots: 1632 
 
Data pages: 552, average fill: 63% 
 
Primary pages: 551, secondary pages: 1, swept pages: 51 
 
Empty pages: 84, full pages: 328 
 
Fill distribution: 
 
0 - 19% = 107 
 
20 - 39% = 34 
 
40 - 59% = 51 
 
60 - 79% = 90 
 
80 - 99% = 270 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 41, nodes: 27347 
 
Average node length: 6.19, total dup: 23917, max dup: 14 
 
Average key length: 3.62, compression ratio: 10.23 
 
Average prefix length: 35.51, average data length: 1.49 
 
Clustering factor: 4256, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 7 
 
40 - 59% = 20 
 
60 - 79% = 10 
 
80 - 99% = 3 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.05, total records: 1272881 
 
Average version length: 71.79, total versions: 19691, 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: 12, data page slots: 18632 
 
Data pages: 18632, average fill: 75% 
 
Primary pages: 18632, secondary pages: 0, swept pages: 7801 
 
Empty pages: 41, full pages: 16729 
 
Fill distribution: 
 
0 - 19% = 117 
 
20 - 39% = 152 
 
40 - 59% = 426 
 
60 - 79% = 17591 
 
80 - 99% = 346 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 373062, depth: 3, leaf buckets: 1506, nodes: 1272881 
 
Average node length: 5.14, total dup: 1239237, max dup: 131 
 
Average key length: 2.20, compression ratio: 4.10 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 146542, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 108 
 
40 - 59% = 1138 
 
60 - 79% = 72 
 
80 - 99% = 166 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 236266, depth: 3, leaf buckets: 1805, nodes: 1272881 
 
Average node length: 6.26, total dup: 1111658, max dup: 22 
 
Average key length: 3.32, compression ratio: 11.16 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 246293, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 32 
 
20 - 39% = 155 
 
40 - 59% = 1313 
 
60 - 79% = 131 
 
80 - 99% = 174 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 26.80, total records: 75579 
 
Average version length: 71.91, total versions: 47513, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 5.07 
 
Pointer pages: 4, data page slots: 4144 
 
Data pages: 2096, average fill: 45% 
 
Primary pages: 2096, secondary pages: 0, swept pages: 183 
 
Empty pages: 423, full pages: 636 
 
Fill distribution: 
 
0 - 19% = 636 
 
20 - 39% = 300 
 
40 - 59% = 333 
 
60 - 79% = 327 
 
80 - 99% = 500 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 747796, depth: 3, leaf buckets: 130, nodes: 75579 
 
Average node length: 5.80, total dup: 66558, max dup: 48 
 
Average key length: 3.40, compression ratio: 10.88 
 
Average prefix length: 35.72, average data length: 1.28 
 
Clustering factor: 9953, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 68 
 
40 - 59% = 42 
 
60 - 79% = 13 
 
80 - 99% = 4 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 68.21, total records: 1793917 
 
Average version length: 71.91, total versions: 98875, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.99 
 
Pointer pages: 18, data page slots: 27784 
 
Data pages: 27768, average fill: 72% 
 
Primary pages: 27767, secondary pages: 1, swept pages: 11777 
 
Empty pages: 202, full pages: 20581 
 
Fill distribution: 
 
0 - 19% = 477 
 
20 - 39% = 867 
 
40 - 59% = 2399 
 
60 - 79% = 21882 
 
80 - 99% = 2143 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 198687, depth: 3, leaf buckets: 2780, nodes: 1793917 
 
Average node length: 5.61, total dup: 1686938, max dup: 70 
 
Average key length: 2.65, compression ratio: 13.95 
 
Average prefix length: 36.41, average data length: 0.59 
 
Clustering factor: 244816, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 1223 
 
40 - 59% = 1139 
 
60 - 79% = 226 
 
80 - 99% = 181 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 5.88, total records: 32545 
 
Average version length: 71.73, total versions: 29832, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 23.11 
 
Pointer pages: 4, data page slots: 2824 
 
Data pages: 1086, average fill: 40% 
 
Primary pages: 1085, secondary pages: 1, swept pages: 106 
 
Empty pages: 271, full pages: 263 
 
Fill distribution: 
 
0 - 19% = 410 
 
20 - 39% = 158 
 
40 - 59% = 178 
 
60 - 79% = 133 
 
80 - 99% = 207 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 57, nodes: 32545 
 
Average node length: 5.42, total dup: 29353, max dup: 73 
 
Average key length: 3.39, compression ratio: 10.92 
 
Average prefix length: 35.71, average data length: 1.29 
 
Clustering factor: 3994, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 38 
 
40 - 59% = 13 
 
60 - 79% = 6 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.53, total records: 2826059 
 
Average version length: 71.71, total versions: 42320, 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: 25, data page slots: 40352 
 
Data pages: 40352, average fill: 76% 
 
Primary pages: 40352, secondary pages: 0, swept pages: 24392 
 
Empty pages: 13, full pages: 37110 
 
Fill distribution: 
 
0 - 19% = 29 
 
20 - 39% = 56 
 
40 - 59% = 456 
 
60 - 79% = 38735 
 
80 - 99% = 1076 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5760, nodes: 2826059 
 
Average node length: 6.87, total dup: 2289570, max dup: 15 
 
Average key length: 3.90, compression ratio: 9.50 
 
Average prefix length: 35.29, average data length: 1.71 
 
Clustering factor: 560221, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 2960 
 
40 - 59% = 2330 
 
60 - 79% = 278 
 
80 - 99% = 184 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.84, total records: 4888796 
 
Average version length: 84.86, total versions: 4459, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.62 
 
Pointer pages: 47, data page slots: 75112 
 
Data pages: 75112, average fill: 80% 
 
Primary pages: 75112, secondary pages: 0, swept pages: 27755 
 
Empty pages: 0, full pages: 75061 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 5 
 
60 - 79% = 21014 
 
80 - 99% = 54091 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4981, nodes: 4888796 
 
Average node length: 5.16, total dup: 4777343, max dup: 131 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 794103, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 21 
 
20 - 39% = 89 
 
40 - 59% = 2177 
 
60 - 79% = 2083 
 
80 - 99% = 611 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 5622, nodes: 4888796 
 
Average node length: 5.69, total dup: 4378658, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 284577, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 62 
 
20 - 39% = 208 
 
40 - 59% = 3541 
 
60 - 79% = 258 
 
80 - 99% = 1553 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5555, nodes: 4888796 
 
Average node length: 5.81, total dup: 4277784, max dup: 29 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 851482, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 90 
 
40 - 59% = 2479 
 
60 - 79% = 2100 
 
80 - 99% = 862 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.50, total records: 2454485 
 
Average version length: 84.39, total versions: 27787, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.65 
 
Pointer pages: 24, data page slots: 38344 
 
Data pages: 38344, average fill: 79% 
 
Primary pages: 38344, secondary pages: 0, swept pages: 24982 
 
Empty pages: 11, full pages: 36937 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 55 
 
40 - 59% = 284 
 
60 - 79% = 15999 
 
80 - 99% = 21982 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2639, nodes: 2454485 
 
Average node length: 5.15, total dup: 2397208, max dup: 161 
 
Average key length: 2.18, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 387516, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 54 
 
40 - 59% = 1572 
 
60 - 79% = 754 
 
80 - 99% = 257 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4302, nodes: 2454485 
 
Average node length: 6.22, total dup: 2013865, max dup: 14 
 
Average key length: 3.25, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 260708, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 110 
 
20 - 39% = 1809 
 
40 - 59% = 1736 
 
60 - 79% = 445 
 
80 - 99% = 202 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 2996, nodes: 2454485 
 
Average node length: 5.81, total dup: 2148069, max dup: 41 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 463654, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 32 
 
20 - 39% = 45 
 
40 - 59% = 1830 
 
60 - 79% = 779 
 
80 - 99% = 310 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.35, total records: 5188403 
 
Average version length: 85.30, total versions: 41520, 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: 50, data page slots: 80832 
 
Data pages: 80824, average fill: 80% 
 
Primary pages: 80824, secondary pages: 0, swept pages: 23819 
 
Empty pages: 119, full pages: 77033 
 
Fill distribution: 
 
0 - 19% = 203 
 
20 - 39% = 279 
 
40 - 59% = 1039 
 
60 - 79% = 18573 
 
80 - 99% = 60730 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5570, nodes: 5188403 
 
Average node length: 5.04, total dup: 5157983, max dup: 664 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 802723, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 309 
 
40 - 59% = 3242 
 
60 - 79% = 1493 
 
80 - 99% = 518 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 6460, nodes: 5188403 
 
Average node length: 5.53, total dup: 4781495, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.55 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 325127, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 73 
 
20 - 39% = 1789 
 
40 - 59% = 2701 
 
60 - 79% = 624 
 
80 - 99% = 1273 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 6256, nodes: 5188403 
 
Average node length: 5.68, total dup: 4658269, max dup: 86 
 
Average key length: 2.69, compression ratio: 3.34 
 
Average prefix length: 8.41, average data length: 0.59 
 
Clustering factor: 884033, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 266 
 
40 - 59% = 3714 
 
60 - 79% = 1673 
 
80 - 99% = 597 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (270) 
 
Primary pointer page: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.90, total records: 3484363 
 
Average version length: 84.81, total versions: 35235, 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: 34, data page slots: 54544 
 
Data pages: 54544, average fill: 79% 
 
Primary pages: 54544, secondary pages: 0, swept pages: 35340 
 
Empty pages: 14, full pages: 52281 
 
Fill distribution: 
 
0 - 19% = 34 
 
20 - 39% = 62 
 
40 - 59% = 342 
 
60 - 79% = 22238 
 
80 - 99% = 31868 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3821, nodes: 3484363 
 
Average node length: 5.03, total dup: 3467033, max dup: 1621 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 750327, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 400 
 
40 - 59% = 2110 
 
60 - 79% = 869 
 
80 - 99% = 420 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 6250, nodes: 3484363 
 
Average node length: 6.24, total dup: 2852646, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 422399, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 231 
 
20 - 39% = 2715 
 
40 - 59% = 2416 
 
60 - 79% = 570 
 
80 - 99% = 318 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4120, nodes: 3484363 
 
Average node length: 5.59, total dup: 3177992, max dup: 99 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 792896, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 332 
 
40 - 59% = 2125 
 
60 - 79% = 1178 
 
80 - 99% = 474 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.19, total records: 668852 
 
Average version length: 70.32, total versions: 3463, 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: 9160 
 
Data pages: 9160, average fill: 78% 
 
Primary pages: 9160, secondary pages: 0, swept pages: 6339 
 
Empty pages: 6, full pages: 9153 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 9061 
 
80 - 99% = 93 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 176651, depth: 3, leaf buckets: 822, nodes: 668852 
 
Average node length: 5.32, total dup: 630226, max dup: 118 
 
Average key length: 2.44, compression ratio: 3.69 
 
Average prefix length: 8.62, average data length: 0.38 
 
Clustering factor: 57458, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 195 
 
40 - 59% = 353 
 
60 - 79% = 194 
 
80 - 99% = 76 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 898, nodes: 668852 
 
Average node length: 5.93, total dup: 571416, max dup: 25 
 
Average key length: 3.05, compression ratio: 2.95 
 
Average prefix length: 8.09, average data length: 0.91 
 
Clustering factor: 63218, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 206 
 
40 - 59% = 368 
 
60 - 79% = 221 
 
80 - 99% = 101 
 
 
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 Thu Nov 16 07:07:28 2017 
 
 
Done for 50190 ms, from  7:06:38.40 to  7:07:28.59. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2212272  | 
 4100  | 
 0.1853  | 
|  DOC_LIST  | 
 672941  | 
 2030  | 
 0.3016  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 91836  | 
   22959.0000  | 
|  INVNT_TURNOVER_LOG  | 
 19567  | 
 16209  | 
 82.8384  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 63  | 
 6  | 
 9.5238  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 222008  | 
 10194  | 
 4.5917  | 
|  PERF_ESTIMATED  | 
 285102  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 11662296  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 471591  | 
 2315  | 
 0.4908  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 2295  | 
   57375.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2696  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 27347  | 
 22453  | 
 82.1040  | 
|  XQD_1000_3300  | 
 1272881  | 
 19691  | 
 1.5469  | 
|  XQD_1200_2000  | 
 75579  | 
 47513  | 
 62.8653  | 
|  XQD_2000_3300  | 
 1793917  | 
 98875  | 
 5.5116  | 
|  XQD_2100_3300  | 
 32545  | 
 29832  | 
 91.6638  | 
|  XQD_3300_3400  | 
 2826059  | 
 42320  | 
 1.4974  | 
|  XQS_1000_1200  | 
 4888796  | 
 4459  | 
 0.0912  | 
|  XQS_1000_3300  | 
 2454485  | 
 27787  | 
 1.1320  | 
|  XQS_1200_2000  | 
 5188403  | 
 41520  | 
 0.8002  | 
|  XQS_2100_3300  | 
 3484363  | 
 35235  | 
 1.0112  | 
|  XQS_3300_3400  | 
 668852  | 
 3463  | 
 0.5177  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2070 ms, from  7:07:39.32 to  7:07:41.39.  
07:07:41.49 Validation started 
 
 
07:07:41.50 Relation 140 (DOC_LIST) 
 
07:07:41.50   process pointer page    0 of    6 
 
07:07:41.63   process pointer page    1 of    6 
 
07:07:41.75   process pointer page    2 of    6 
 
07:07:41.80   process pointer page    3 of    6 
 
07:07:41.85   process pointer page    4 of    6 
 
07:07:41.89   process pointer page    5 of    6 
 
07:07:41.89 Index 1 (PK_DOC_LIST) 
 
07:07:42.00 Index 2 (DOC_LIST_ID_DESC) 
 
07:07:42.17 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:07:42.39 Relation 140 (DOC_LIST) is ok 
 
 
07:07:42.39 Relation 141 (DOC_DATA) 
 
07:07:42.39   process pointer page    0 of   15 
 
07:07:42.49   process pointer page    1 of   15 
 
07:07:42.59   process pointer page    2 of   15 
 
07:07:42.70   process pointer page    3 of   15 
 
07:07:42.80   process pointer page    4 of   15 
 
07:07:42.84   process pointer page    5 of   15 
 
07:07:42.92   process pointer page    6 of   15 
 
07:07:43.03   process pointer page    7 of   15 
 
07:07:43.13   process pointer page    8 of   15 
 
07:07:43.22   process pointer page    9 of   15 
 
07:07:43.31   process pointer page   10 of   15 
 
07:07:43.37   process pointer page   11 of   15 
 
07:07:43.42   process pointer page   12 of   15 
 
07:07:43.45   process pointer page   13 of   15 
 
07:07:43.50   process pointer page   14 of   15 
 
07:07:43.52 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:07:44.01 Index 3 (DOC_DATA_ID_DESC) 
 
07:07:44.78 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:07:45.25 Relation 141 (DOC_DATA) is ok 
 
 
07:07:45.25 Relation 147 (INVNT_SALDO) 
 
07:07:45.25   process pointer page    0 of    1 
 
07:07:45.51 Index 1 (PK_INVNT_SALDO) 
 
07:07:45.51 Relation 147 (INVNT_SALDO) is ok 
 
 
07:07:45.51 Relation 150 (PDISTR) 
 
07:07:45.51   process pointer page    0 of    2 
 
07:07:45.64   process pointer page    1 of    2 
 
07:07:45.68 Index 2 (PDISTR_SND_ID) 
 
07:07:45.76 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:07:45.84 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:07:45.89 Index 5 (PDISTR_AGENT_ID) 
 
07:07:45.90 Relation 150 (PDISTR) is ok 
 
 
07:07:45.90 Relation 151 (PSTORNED) 
 
07:07:45.90   process pointer page    0 of    4 
 
07:07:45.95   process pointer page    1 of    4 
 
07:07:46.04   process pointer page    2 of    4 
 
07:07:46.15   process pointer page    3 of    4 
 
07:07:46.20 Index 2 (PSTORNED_SND_ID) 
 
07:07:46.32 Index 3 (PSTORNED_RCV_ID) 
 
07:07:46.39 Relation 151 (PSTORNED) is ok 
 
 
07:07:46.39 Relation 156 (SEMAPHORES) 
 
07:07:46.39   process pointer page    0 of    1 
 
07:07:46.39 Index 1 (PK_SEMAPHORES) 
 
07:07:46.39 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:07:46.39 Relation 156 (SEMAPHORES) is ok 
 
 
07:07:46.39 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:07:46.39   process pointer page    0 of    2 
 
07:07:46.42   process pointer page    1 of    2 
 
07:07:46.42 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:07:46.42 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:07:46.42 Relation 160 (PERF_ESTIMATED) 
 
07:07:46.42   process pointer page    0 of    2 
 
07:07:46.46   process pointer page    1 of    2 
 
07:07:46.48 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:07:46.49 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:07:46.49 Relation 161 (PERF_ISQL_STAT) 
 
07:07:46.49   process pointer page    0 of    1 
 
07:07:46.49 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:07:46.49 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:07:46.49 Relation 162 (TRACE_STAT) 
 
07:07:46.49   process pointer page    0 of    1 
 
07:07:46.51 Relation 162 (TRACE_STAT) is ok 
 
 
07:07:46.51 Relation 163 (PERF_LOG) 
 
07:07:46.51   process pointer page    0 of  170 
 
07:07:46.54   process pointer page    1 of  170 
 
07:07:46.57   process pointer page    2 of  170 
 
07:07:46.60   process pointer page    3 of  170 
 
07:07:46.64   process pointer page    4 of  170 
 
07:07:46.67   process pointer page    5 of  170 
 
07:07:46.70   process pointer page    6 of  170 
 
07:07:46.71   process pointer page    7 of  170 
 
07:07:46.74   process pointer page    8 of  170 
 
07:07:46.78   process pointer page    9 of  170 
 
07:07:46.81   process pointer page   10 of  170 
 
07:07:46.84   process pointer page   11 of  170 
 
07:07:46.85   process pointer page   12 of  170 
 
07:07:46.88   process pointer page   13 of  170 
 
07:07:46.92   process pointer page   14 of  170 
 
07:07:46.95   process pointer page   15 of  170 
 
07:07:46.96   process pointer page   16 of  170 
 
07:07:46.99   process pointer page   17 of  170 
 
07:07:47.03   process pointer page   18 of  170 
 
07:07:47.04   process pointer page   19 of  170 
 
07:07:47.07   process pointer page   20 of  170 
 
07:07:47.10   process pointer page   21 of  170 
 
07:07:47.12   process pointer page   22 of  170 
 
07:07:47.15   process pointer page   23 of  170 
 
07:07:47.18   process pointer page   24 of  170 
 
07:07:47.20   process pointer page   25 of  170 
 
07:07:47.23   process pointer page   26 of  170 
 
07:07:47.26   process pointer page   27 of  170 
 
07:07:47.27   process pointer page   28 of  170 
 
07:07:47.31   process pointer page   29 of  170 
 
07:07:47.32   process pointer page   30 of  170 
 
07:07:47.35   process pointer page   31 of  170 
 
07:07:47.38   process pointer page   32 of  170 
 
07:07:47.40   process pointer page   33 of  170 
 
07:07:47.43   process pointer page   34 of  170 
 
07:07:47.45   process pointer page   35 of  170 
 
07:07:47.48   process pointer page   36 of  170 
 
07:07:47.51   process pointer page   37 of  170 
 
07:07:47.54   process pointer page   38 of  170 
 
07:07:47.57   process pointer page   39 of  170 
 
07:07:47.62   process pointer page   40 of  170 
 
07:07:47.65   process pointer page   41 of  170 
 
07:07:47.68   process pointer page   42 of  170 
 
07:07:47.71   process pointer page   43 of  170 
 
07:07:47.74   process pointer page   44 of  170 
 
07:07:47.77   process pointer page   45 of  170 
 
07:07:47.81   process pointer page   46 of  170 
 
07:07:47.82   process pointer page   47 of  170 
 
07:07:47.85   process pointer page   48 of  170 
 
07:07:47.91   process pointer page   49 of  170 
 
07:07:47.98   process pointer page   50 of  170 
 
07:07:48.01   process pointer page   51 of  170 
 
07:07:48.04   process pointer page   52 of  170 
 
07:07:48.09   process pointer page   53 of  170 
 
07:07:48.12   process pointer page   54 of  170 
 
07:07:48.21   process pointer page   55 of  170 
 
07:07:48.24   process pointer page   56 of  170 
 
07:07:48.27   process pointer page   57 of  170 
 
07:07:48.32   process pointer page   58 of  170 
 
07:07:48.35   process pointer page   59 of  170 
 
07:07:48.43   process pointer page   60 of  170 
 
07:07:48.48   process pointer page   61 of  170 
 
07:07:48.51   process pointer page   62 of  170 
 
07:07:48.60   process pointer page   63 of  170 
 
07:07:48.66   process pointer page   64 of  170 
 
07:07:48.71   process pointer page   65 of  170 
 
07:07:48.74   process pointer page   66 of  170 
 
07:07:48.77   process pointer page   67 of  170 
 
07:07:48.80   process pointer page   68 of  170 
 
07:07:48.83   process pointer page   69 of  170 
 
07:07:48.87   process pointer page   70 of  170 
 
07:07:48.90   process pointer page   71 of  170 
 
07:07:48.93   process pointer page   72 of  170 
 
07:07:48.96   process pointer page   73 of  170 
 
07:07:48.99   process pointer page   74 of  170 
 
07:07:49.01   process pointer page   75 of  170 
 
07:07:49.04   process pointer page   76 of  170 
 
07:07:49.07   process pointer page   77 of  170 
 
07:07:49.08   process pointer page   78 of  170 
 
07:07:49.12   process pointer page   79 of  170 
 
07:07:49.15   process pointer page   80 of  170 
 
07:07:49.18   process pointer page   81 of  170 
 
07:07:49.21   process pointer page   82 of  170 
 
07:07:49.24   process pointer page   83 of  170 
 
07:07:49.27   process pointer page   84 of  170 
 
07:07:49.30   process pointer page   85 of  170 
 
07:07:49.33   process pointer page   86 of  170 
 
07:07:49.37   process pointer page   87 of  170 
 
07:07:49.40   process pointer page   88 of  170 
 
07:07:49.43   process pointer page   89 of  170 
 
07:07:49.44   process pointer page   90 of  170 
 
07:07:49.47   process pointer page   91 of  170 
 
07:07:49.51   process pointer page   92 of  170 
 
07:07:49.52   process pointer page   93 of  170 
 
07:07:49.55   process pointer page   94 of  170 
 
07:07:49.58   process pointer page   95 of  170 
 
07:07:49.60   process pointer page   96 of  170 
 
07:07:49.63   process pointer page   97 of  170 
 
07:07:49.65   process pointer page   98 of  170 
 
07:07:49.68   process pointer page   99 of  170 
 
07:07:49.72   process pointer page  100 of  170 
 
07:07:49.76   process pointer page  101 of  170 
 
07:07:49.82   process pointer page  102 of  170 
 
07:07:49.91   process pointer page  103 of  170 
 
07:07:50.00   process pointer page  104 of  170 
 
07:07:50.04   process pointer page  105 of  170 
 
07:07:50.08   process pointer page  106 of  170 
 
07:07:50.11   process pointer page  107 of  170 
 
07:07:50.15   process pointer page  108 of  170 
 
07:07:50.24   process pointer page  109 of  170 
 
07:07:50.32   process pointer page  110 of  170 
 
07:07:50.41   process pointer page  111 of  170 
 
07:07:50.50   process pointer page  112 of  170 
 
07:07:50.57   process pointer page  113 of  170 
 
07:07:50.61   process pointer page  114 of  170 
 
07:07:50.69   process pointer page  115 of  170 
 
07:07:50.78   process pointer page  116 of  170 
 
07:07:50.88   process pointer page  117 of  170 
 
07:07:50.96   process pointer page  118 of  170 
 
07:07:51.05   process pointer page  119 of  170 
 
07:07:51.13   process pointer page  120 of  170 
 
07:07:51.16   process pointer page  121 of  170 
 
07:07:51.19   process pointer page  122 of  170 
 
07:07:51.25   process pointer page  123 of  170 
 
07:07:51.33   process pointer page  124 of  170 
 
07:07:51.42   process pointer page  125 of  170 
 
07:07:51.52   process pointer page  126 of  170 
 
07:07:51.61   process pointer page  127 of  170 
 
07:07:51.69   process pointer page  128 of  170 
 
07:07:51.77   process pointer page  129 of  170 
 
07:07:51.80   process pointer page  130 of  170 
 
07:07:51.85   process pointer page  131 of  170 
 
07:07:51.91   process pointer page  132 of  170 
 
07:07:52.00   process pointer page  133 of  170 
 
07:07:52.10   process pointer page  134 of  170 
 
07:07:52.19   process pointer page  135 of  170 
 
07:07:52.24   process pointer page  136 of  170 
 
07:07:52.30   process pointer page  137 of  170 
 
07:07:52.38   process pointer page  138 of  170 
 
07:07:52.44   process pointer page  139 of  170 
 
07:07:52.47   process pointer page  140 of  170 
 
07:07:52.50   process pointer page  141 of  170 
 
07:07:52.55   process pointer page  142 of  170 
 
07:07:52.58   process pointer page  143 of  170 
 
07:07:52.61   process pointer page  144 of  170 
 
07:07:52.69   process pointer page  145 of  170 
 
07:07:52.73   process pointer page  146 of  170 
 
07:07:52.80   process pointer page  147 of  170 
 
07:07:52.84   process pointer page  148 of  170 
 
07:07:52.88   process pointer page  149 of  170 
 
07:07:52.91   process pointer page  150 of  170 
 
07:07:52.95   process pointer page  151 of  170 
 
07:07:53.02   process pointer page  152 of  170 
 
07:07:53.11   process pointer page  153 of  170 
 
07:07:53.19   process pointer page  154 of  170 
 
07:07:53.28   process pointer page  155 of  170 
 
07:07:53.37   process pointer page  156 of  170 
 
07:07:53.47   process pointer page  157 of  170 
 
07:07:53.53   process pointer page  158 of  170 
 
07:07:53.56   process pointer page  159 of  170 
 
07:07:53.59   process pointer page  160 of  170 
 
07:07:53.69   process pointer page  161 of  170 
 
07:07:53.76   process pointer page  162 of  170 
 
07:07:53.86   process pointer page  163 of  170 
 
07:07:53.95   process pointer page  164 of  170 
 
07:07:54.05   process pointer page  165 of  170 
 
07:07:54.08   process pointer page  166 of  170 
 
07:07:54.12   process pointer page  167 of  170 
 
07:07:54.22   process pointer page  168 of  170 
 
07:07:54.29   process pointer page  169 of  170 
 
07:07:54.31 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:07:57.09 Index 2 (PERF_LOG_UNIT) 
 
07:07:59.71 Index 3 (PERF_LOG_TRN_DESC) 
 
07:08:01.92 Index 4 (PERF_LOG_GDSCODE) 
 
07:08:03.09 Relation 163 (PERF_LOG) is ok 
 
 
07:08:03.09 Relation 167 (V_STOPTEST) 
 
07:08:03.09 Relation 167 (V_STOPTEST) is ok 
 
 
07:08:03.09 Relation 184 (V_QDISTR_SOURCE) 
 
07:08:03.09 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:08:03.09 Relation 185 (V_QSTORNED_SOURCE) 
 
07:08:03.09 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:08:03.09 Relation 260 (XQD_1000_1200) 
 
07:08:03.09   process pointer page    0 of    2 
 
07:08:03.09   process pointer page    1 of    2 
 
07:08:03.14 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:08:03.16 Relation 260 (XQD_1000_1200) is ok 
 
 
07:08:03.16 Relation 261 (XQD_1200_2000) 
 
07:08:03.16   process pointer page    0 of    4 
 
07:08:03.26   process pointer page    1 of    4 
 
07:08:03.31   process pointer page    2 of    4 
 
07:08:03.33   process pointer page    3 of    4 
 
07:08:03.33 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:08:03.34 Relation 261 (XQD_1200_2000) is ok 
 
 
07:08:03.34 Relation 262 (XQD_1000_3300) 
 
07:08:03.34   process pointer page    0 of   12 
 
07:08:03.45   process pointer page    1 of   12 
 
07:08:03.53   process pointer page    2 of   12 
 
07:08:03.59   process pointer page    3 of   12 
 
07:08:03.64   process pointer page    4 of   12 
 
07:08:03.69   process pointer page    5 of   12 
 
07:08:03.75   process pointer page    6 of   12 
 
07:08:03.84   process pointer page    7 of   12 
 
07:08:03.95   process pointer page    8 of   12 
 
07:08:04.00   process pointer page    9 of   12 
 
07:08:04.06   process pointer page   10 of   12 
 
07:08:04.11   process pointer page   11 of   12 
 
07:08:04.12 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:08:04.37 Index 2 (XQD_1000_3300_DOC) 
 
07:08:04.70 Relation 262 (XQD_1000_3300) is ok 
 
 
07:08:04.70 Relation 263 (XQD_2000_3300) 
 
07:08:04.70   process pointer page    0 of   18 
 
07:08:04.76   process pointer page    1 of   18 
 
07:08:04.81   process pointer page    2 of   18 
 
07:08:04.86   process pointer page    3 of   18 
 
07:08:04.90   process pointer page    4 of   18 
 
07:08:04.93   process pointer page    5 of   18 
 
07:08:05.00   process pointer page    6 of   18 
 
07:08:05.11   process pointer page    7 of   18 
 
07:08:05.21   process pointer page    8 of   18 
 
07:08:05.32   process pointer page    9 of   18 
 
07:08:05.42   process pointer page   10 of   18 
 
07:08:05.53   process pointer page   11 of   18 
 
07:08:05.62   process pointer page   12 of   18 
 
07:08:05.68   process pointer page   13 of   18 
 
07:08:05.73   process pointer page   14 of   18 
 
07:08:05.79   process pointer page   15 of   18 
 
07:08:05.89   process pointer page   16 of   18 
 
07:08:05.99   process pointer page   17 of   18 
 
07:08:05.99 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:08:06.62 Relation 263 (XQD_2000_3300) is ok 
 
 
07:08:06.62 Relation 264 (XQD_2100_3300) 
 
07:08:06.62   process pointer page    0 of    4 
 
07:08:06.65   process pointer page    1 of    4 
 
07:08:06.65   process pointer page    2 of    4 
 
07:08:06.65   process pointer page    3 of    4 
 
07:08:06.65 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:08:06.67 Relation 264 (XQD_2100_3300) is ok 
 
 
07:08:06.67 Relation 265 (XQD_3300_3400) 
 
07:08:06.67   process pointer page    0 of   25 
 
07:08:06.70   process pointer page    1 of   25 
 
07:08:06.81   process pointer page    2 of   25 
 
07:08:06.90   process pointer page    3 of   25 
 
07:08:07.01   process pointer page    4 of   25 
 
07:08:07.04   process pointer page    5 of   25 
 
07:08:07.10   process pointer page    6 of   25 
 
07:08:07.15   process pointer page    7 of   25 
 
07:08:07.21   process pointer page    8 of   25 
 
07:08:07.26   process pointer page    9 of   25 
 
07:08:07.29   process pointer page   10 of   25 
 
07:08:07.34   process pointer page   11 of   25 
 
07:08:07.37   process pointer page   12 of   25 
 
07:08:07.40   process pointer page   13 of   25 
 
07:08:07.45   process pointer page   14 of   25 
 
07:08:07.48   process pointer page   15 of   25 
 
07:08:07.52   process pointer page   16 of   25 
 
07:08:07.62   process pointer page   17 of   25 
 
07:08:07.73   process pointer page   18 of   25 
 
07:08:07.82   process pointer page   19 of   25 
 
07:08:07.85   process pointer page   20 of   25 
 
07:08:07.90   process pointer page   21 of   25 
 
07:08:07.94   process pointer page   22 of   25 
 
07:08:07.98   process pointer page   23 of   25 
 
07:08:08.01   process pointer page   24 of   25 
 
07:08:08.04 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:08:08.41 Relation 265 (XQD_3300_3400) is ok 
 
 
07:08:08.41 Relation 266 (XQS_1000_1200) 
 
07:08:08.41   process pointer page    0 of   47 
 
07:08:08.44   process pointer page    1 of   47 
 
07:08:08.48   process pointer page    2 of   47 
 
07:08:08.51   process pointer page    3 of   47 
 
07:08:08.54   process pointer page    4 of   47 
 
07:08:08.57   process pointer page    5 of   47 
 
07:08:08.60   process pointer page    6 of   47 
 
07:08:08.63   process pointer page    7 of   47 
 
07:08:08.66   process pointer page    8 of   47 
 
07:08:08.69   process pointer page    9 of   47 
 
07:08:08.71   process pointer page   10 of   47 
 
07:08:08.74   process pointer page   11 of   47 
 
07:08:08.77   process pointer page   12 of   47 
 
07:08:08.80   process pointer page   13 of   47 
 
07:08:08.83   process pointer page   14 of   47 
 
07:08:08.87   process pointer page   15 of   47 
 
07:08:08.91   process pointer page   16 of   47 
 
07:08:08.94   process pointer page   17 of   47 
 
07:08:09.02   process pointer page   18 of   47 
 
07:08:09.07   process pointer page   19 of   47 
 
07:08:09.18   process pointer page   20 of   47 
 
07:08:09.27   process pointer page   21 of   47 
 
07:08:09.38   process pointer page   22 of   47 
 
07:08:09.46   process pointer page   23 of   47 
 
07:08:09.50   process pointer page   24 of   47 
 
07:08:09.54   process pointer page   25 of   47 
 
07:08:09.61   process pointer page   26 of   47 
 
07:08:09.71   process pointer page   27 of   47 
 
07:08:09.82   process pointer page   28 of   47 
 
07:08:09.91   process pointer page   29 of   47 
 
07:08:09.99   process pointer page   30 of   47 
 
07:08:10.02   process pointer page   31 of   47 
 
07:08:10.07   process pointer page   32 of   47 
 
07:08:10.10   process pointer page   33 of   47 
 
07:08:10.14   process pointer page   34 of   47 
 
07:08:10.18   process pointer page   35 of   47 
 
07:08:10.22   process pointer page   36 of   47 
 
07:08:10.25   process pointer page   37 of   47 
 
07:08:10.28   process pointer page   38 of   47 
 
07:08:10.32   process pointer page   39 of   47 
 
07:08:10.35   process pointer page   40 of   47 
 
07:08:10.38   process pointer page   41 of   47 
 
07:08:10.41   process pointer page   42 of   47 
 
07:08:10.44   process pointer page   43 of   47 
 
07:08:10.46   process pointer page   44 of   47 
 
07:08:10.49   process pointer page   45 of   47 
 
07:08:10.52   process pointer page   46 of   47 
 
07:08:10.52 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:08:11.06 Index 2 (XQS_1000_1200_SND_ID) 
 
07:08:11.47 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:08:11.83 Relation 266 (XQS_1000_1200) is ok 
 
 
07:08:11.83 Relation 267 (XQS_1200_2000) 
 
07:08:11.83   process pointer page    0 of   50 
 
07:08:11.86   process pointer page    1 of   50 
 
07:08:11.89   process pointer page    2 of   50 
 
07:08:11.92   process pointer page    3 of   50 
 
07:08:11.95   process pointer page    4 of   50 
 
07:08:11.99   process pointer page    5 of   50 
 
07:08:12.02   process pointer page    6 of   50 
 
07:08:12.03   process pointer page    7 of   50 
 
07:08:12.06   process pointer page    8 of   50 
 
07:08:12.09   process pointer page    9 of   50 
 
07:08:12.20   process pointer page   10 of   50 
 
07:08:12.31   process pointer page   11 of   50 
 
07:08:12.34   process pointer page   12 of   50 
 
07:08:12.39   process pointer page   13 of   50 
 
07:08:12.42   process pointer page   14 of   50 
 
07:08:12.47   process pointer page   15 of   50 
 
07:08:12.50   process pointer page   16 of   50 
 
07:08:12.58   process pointer page   17 of   50 
 
07:08:12.63   process pointer page   18 of   50 
 
07:08:12.67   process pointer page   19 of   50 
 
07:08:12.72   process pointer page   20 of   50 
 
07:08:12.81   process pointer page   21 of   50 
 
07:08:12.84   process pointer page   22 of   50 
 
07:08:12.89   process pointer page   23 of   50 
 
07:08:12.94   process pointer page   24 of   50 
 
07:08:12.97   process pointer page   25 of   50 
 
07:08:13.00   process pointer page   26 of   50 
 
07:08:13.03   process pointer page   27 of   50 
 
07:08:13.06   process pointer page   28 of   50 
 
07:08:13.11   process pointer page   29 of   50 
 
07:08:13.14   process pointer page   30 of   50 
 
07:08:13.17   process pointer page   31 of   50 
 
07:08:13.20   process pointer page   32 of   50 
 
07:08:13.23   process pointer page   33 of   50 
 
07:08:13.26   process pointer page   34 of   50 
 
07:08:13.30   process pointer page   35 of   50 
 
07:08:13.33   process pointer page   36 of   50 
 
07:08:13.36   process pointer page   37 of   50 
 
07:08:13.37   process pointer page   38 of   50 
 
07:08:13.41   process pointer page   39 of   50 
 
07:08:13.44   process pointer page   40 of   50 
 
07:08:13.47   process pointer page   41 of   50 
 
07:08:13.48   process pointer page   42 of   50 
 
07:08:13.51   process pointer page   43 of   50 
 
07:08:13.55   process pointer page   44 of   50 
 
07:08:13.58   process pointer page   45 of   50 
 
07:08:13.61   process pointer page   46 of   50 
 
07:08:13.64   process pointer page   47 of   50 
 
07:08:13.67   process pointer page   48 of   50 
 
07:08:13.70   process pointer page   49 of   50 
 
07:08:13.73 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:08:14.53 Index 2 (XQS_1200_2000_SND_ID) 
 
07:08:15.56 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:08:16.53 Relation 267 (XQS_1200_2000) is ok 
 
 
07:08:16.53 Relation 268 (XQS_1000_3300) 
 
07:08:16.53   process pointer page    0 of   24 
 
07:08:16.57   process pointer page    1 of   24 
 
07:08:16.60   process pointer page    2 of   24 
 
07:08:16.71   process pointer page    3 of   24 
 
07:08:16.77   process pointer page    4 of   24 
 
07:08:16.82   process pointer page    5 of   24 
 
07:08:16.92   process pointer page    6 of   24 
 
07:08:17.01   process pointer page    7 of   24 
 
07:08:17.04   process pointer page    8 of   24 
 
07:08:17.09   process pointer page    9 of   24 
 
07:08:17.12   process pointer page   10 of   24 
 
07:08:17.16   process pointer page   11 of   24 
 
07:08:17.20   process pointer page   12 of   24 
 
07:08:17.31   process pointer page   13 of   24 
 
07:08:17.35   process pointer page   14 of   24 
 
07:08:17.38   process pointer page   15 of   24 
 
07:08:17.43   process pointer page   16 of   24 
 
07:08:17.49   process pointer page   17 of   24 
 
07:08:17.59   process pointer page   18 of   24 
 
07:08:17.70   process pointer page   19 of   24 
 
07:08:17.79   process pointer page   20 of   24 
 
07:08:17.90   process pointer page   21 of   24 
 
07:08:17.94   process pointer page   22 of   24 
 
07:08:17.98   process pointer page   23 of   24 
 
07:08:17.99 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:08:18.48 Index 2 (XQS_1000_3300_SND_ID) 
 
07:08:19.18 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:08:19.63 Relation 268 (XQS_1000_3300) is ok 
 
 
07:08:19.63 Relation 269 (XQS_2000_3300) 
 
07:08:19.63   process pointer page    0 of    1 
 
07:08:19.63 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:08:19.63 Index 2 (XQS_2000_3300_SND_ID) 
 
07:08:19.63 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:08:19.63 Relation 269 (XQS_2000_3300) is ok 
 
 
07:08:19.63 Relation 270 (XQS_2100_3300) 
 
07:08:19.63   process pointer page    0 of   34 
 
07:08:19.72   process pointer page    1 of   34 
 
07:08:19.77   process pointer page    2 of   34 
 
07:08:19.82   process pointer page    3 of   34 
 
07:08:19.85   process pointer page    4 of   34 
 
07:08:19.89   process pointer page    5 of   34 
 
07:08:19.93   process pointer page    6 of   34 
 
07:08:19.96   process pointer page    7 of   34 
 
07:08:20.05   process pointer page    8 of   34 
 
07:08:20.10   process pointer page    9 of   34 
 
07:08:20.14   process pointer page   10 of   34 
 
07:08:20.22   process pointer page   11 of   34 
 
07:08:20.32   process pointer page   12 of   34 
 
07:08:20.43   process pointer page   13 of   34 
 
07:08:20.52   process pointer page   14 of   34 
 
07:08:20.55   process pointer page   15 of   34 
 
07:08:20.61   process pointer page   16 of   34 
 
07:08:20.64   process pointer page   17 of   34 
 
07:08:20.69   process pointer page   18 of   34 
 
07:08:20.72   process pointer page   19 of   34 
 
07:08:20.75   process pointer page   20 of   34 
 
07:08:20.78   process pointer page   21 of   34 
 
07:08:20.82   process pointer page   22 of   34 
 
07:08:20.85   process pointer page   23 of   34 
 
07:08:20.94   process pointer page   24 of   34 
 
07:08:21.02   process pointer page   25 of   34 
 
07:08:21.11   process pointer page   26 of   34 
 
07:08:21.21   process pointer page   27 of   34 
 
07:08:21.24   process pointer page   28 of   34 
 
07:08:21.30   process pointer page   29 of   34 
 
07:08:21.39   process pointer page   30 of   34 
 
07:08:21.44   process pointer page   31 of   34 
 
07:08:21.47   process pointer page   32 of   34 
 
07:08:21.50   process pointer page   33 of   34 
 
07:08:21.52 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:08:22.53 Index 2 (XQS_2100_3300_SND_ID) 
 
07:08:23.58 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:08:24.08 Relation 270 (XQS_2100_3300) is ok 
 
 
07:08:24.08 Relation 271 (XQS_3300_3400) 
 
07:08:24.08   process pointer page    0 of    6 
 
07:08:24.11   process pointer page    1 of    6 
 
07:08:24.12   process pointer page    2 of    6 
 
07:08:24.15   process pointer page    3 of    6 
 
07:08:24.18   process pointer page    4 of    6 
 
07:08:24.20   process pointer page    5 of    6 
 
07:08:24.22 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:08:24.36 Index 2 (XQS_3300_3400_SND_ID) 
 
07:08:24.53 Relation 271 (XQS_3300_3400) is ok 
 
 
07:08:24.53 Validation finished 
 
Done for 43120 ms, from  7:07:41.42 to  7:08:24.54. 
 
 Differences between old and current firebird.log 
7:08:25.74. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2017-11-16  07:08               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 Thu Nov 16 07:07:41 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Thu Nov 16 07:08:24 2017 
 
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. 
 
2017-11-16  7:08:31.61 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html