|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 6177.97  | 
 1992  | 
 1112034  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  customer order: creation  | 
 444.99  | 
 350  | 
 80098  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  customer order: refuse  | 
 36.79  | 
 183  | 
 6622  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  order to supplier: creation  | 
 114.84  | 
 1411  | 
 20672  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  order to supplier: removal  | 
 3.01  | 
 14054  | 
 535  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  invoice (draft): creation  | 
 114.04  | 
 1932  | 
 20528  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  invoice (draft): removal  | 
 40.80  | 
 311  | 
 7303  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  invoice accept: apply  | 
 62.78  | 
 6618  | 
 11301  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  invoice accept: cancel  | 
 19.95  | 
 1764  | 
 3591  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  customer reserve: creation  | 
 3511.74  | 
 94  | 
 632114  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  customer reserve: removal  | 
 1214.53  | 
 41  | 
 218616  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  realization accept: apply  | 
 205.22  | 
 401  | 
 36940  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  realization accept: cancel  | 
 90.79  | 
 105  | 
 16342  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  payment from customer: creation  | 
 148.04  | 
 612  | 
 26647  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  payment from customer: removal  | 
 14.12  | 
 99  | 
 2542  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  payment to supplier: creation  | 
 123.18  | 
 311  | 
 22172  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  payment to supplier: removal  | 
 8.69  | 
 107  | 
 1565  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  service: total inventory turnovers  | 
 10.15  | 
 1744  | 
 1827  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  service: total monetary turnovers  | 
 14.48  | 
 54  | 
 2607  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 7660  | 
 12  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
 
Done for 95960 ms, from  6:49:00.93 to  6:50:36.89.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4607  | 
 98660  | 
 82919  | 
 15741  | 
 15.95  | 
 03:46:38  | 
 04:04:37  | 
|  interval #   2, overall  | 
 2  | 
 6150  | 
 124664  | 
 110695  | 
 13969  | 
 11.21  | 
 04:04:38  | 
 04:22:37  | 
|  interval #   3, overall  | 
 3  | 
 6346  | 
 133017  | 
 114221  | 
 18796  | 
 14.13  | 
 04:22:38  | 
 04:40:37  | 
|  interval #   4, overall  | 
 4  | 
 6729  | 
 142157  | 
 121120  | 
 21037  | 
 14.80  | 
 04:40:38  | 
 04:58:37  | 
|  interval #   5, overall  | 
 5  | 
 6455  | 
 140657  | 
 116185  | 
 24472  | 
 17.40  | 
 04:58:38  | 
 05:16:37  | 
|  interval #   6, overall  | 
 6  | 
 6771  | 
 143430  | 
 121875  | 
 21555  | 
 15.03  | 
 05:16:38  | 
 05:34:37  | 
|  interval #   7, overall  | 
 7  | 
 6345  | 
 130866  | 
 114217  | 
 16649  | 
 12.72  | 
 05:34:38  | 
 05:52:37  | 
|  interval #   8, overall  | 
 8  | 
 5901  | 
 121595  | 
 106219  | 
 15376  | 
 12.65  | 
 05:52:38  | 
 06:10:37  | 
|  interval #   9, overall  | 
 9  | 
 6446  | 
 137221  | 
 116021  | 
 21200  | 
 15.45  | 
 06:10:38  | 
 06:28:37  | 
|  interval #  10, overall  | 
 10  | 
 6031  | 
 123888  | 
 108562  | 
 15326  | 
 12.37  | 
 06:28:38  | 
 06:46:37  | 
 
Done for 237690 ms, from  6:54:33.32 to  6:58:31.01.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 1843.32  | 
 0.1746  | 
 1.8564  | 
 1934  | 
 99  | 
|  TEST_TIME  | 
 2  | 
 2606.71  | 
 0.6563  | 
 1.3027  | 
 1629  | 
 99  | 
|  TEST_TIME  | 
 3  | 
 3126.66  | 
 0.7242  | 
 1.1984  | 
 1600  | 
 99  | 
|  TEST_TIME  | 
 4  | 
 3225.45  | 
 0.8713  | 
 1.1101  | 
 1329  | 
 99  | 
|  TEST_TIME  | 
 5  | 
 3303.22  | 
 0.8673  | 
 1.0941  | 
 1319  | 
 99  | 
|  TEST_TIME  | 
 6  | 
 3301.29  | 
 0.9124  | 
 1.0934  | 
 1291  | 
 99  | 
|  TEST_TIME  | 
 7  | 
 3404.91  | 
 0.9089  | 
 1.0927  | 
 1623  | 
 99  | 
|  TEST_TIME  | 
 8  | 
 3563.87  | 
 0.9147  | 
 1.0756  | 
 1275  | 
 99  | 
|  TEST_TIME  | 
 9  | 
 3657.51  | 
 0.9317  | 
 1.0652  | 
 1334  | 
 99  | 
|  TEST_TIME  | 
 10  | 
 3759.08  | 
 0.9336  | 
 1.0634  | 
 1486  | 
 99  | 
|  TEST_TIME  | 
 11  | 
 3850.57  | 
 0.9438  | 
 1.0593  | 
 1574  | 
 99  | 
|  TEST_TIME  | 
 12  | 
 3948.02  | 
 0.9471  | 
 1.0527  | 
 1451  | 
 99  | 
|  TEST_TIME  | 
 13  | 
 4040.85  | 
 0.9510  | 
 1.0469  | 
 1290  | 
 99  | 
|  TEST_TIME  | 
 14  | 
 4119.54  | 
 0.9551  | 
 1.0384  | 
 1385  | 
 99  | 
|  TEST_TIME  | 
 15  | 
 4188.97  | 
 0.9546  | 
 1.0360  | 
 1280  | 
 99  | 
|  TEST_TIME  | 
 16  | 
 4262.79  | 
 0.9552  | 
 1.0411  | 
 1938  | 
 99  | 
|  TEST_TIME  | 
 17  | 
 4402.42  | 
 0.9488  | 
 1.0493  | 
 2058  | 
 99  | 
|  TEST_TIME  | 
 18  | 
 4562.79  | 
 0.9571  | 
 1.0395  | 
 1956  | 
 99  | 
|  TEST_TIME  | 
 19  | 
 4681.46  | 
 0.9605  | 
 1.0214  | 
 1750  | 
 99  | 
|  TEST_TIME  | 
 20  | 
 4663.68  | 
 0.9744  | 
 1.0299  | 
 1420  | 
 98  | 
|  TEST_TIME  | 
 21  | 
 4733.90  | 
 0.9717  | 
 1.0257  | 
 1587  | 
 99  | 
|  TEST_TIME  | 
 22  | 
 4775.51  | 
 0.9708  | 
 1.0323  | 
 1520  | 
 99  | 
|  TEST_TIME  | 
 23  | 
 4835.19  | 
 0.9757  | 
 1.0235  | 
 1517  | 
 99  | 
|  TEST_TIME  | 
 24  | 
 4875.97  | 
 0.9726  | 
 1.0325  | 
 1516  | 
 99  | 
|  TEST_TIME  | 
 25  | 
 4929.70  | 
 0.9804  | 
 1.0246  | 
 1221  | 
 99  | 
|  TEST_TIME  | 
 26  | 
 4963.83  | 
 0.9785  | 
 1.0220  | 
 1367  | 
 99  | 
|  TEST_TIME  | 
 27  | 
 4969.28  | 
 0.9831  | 
 1.0202  | 
 1404  | 
 99  | 
|  TEST_TIME  | 
 28  | 
 4998.30  | 
 0.9782  | 
 1.0169  | 
 1233  | 
 99  | 
|  TEST_TIME  | 
 29  | 
 4988.72  | 
 0.9838  | 
 1.0171  | 
 1252  | 
 99  | 
|  TEST_TIME  | 
 30  | 
 4985.66  | 
 0.9842  | 
 1.0166  | 
 1350  | 
 99  | 
|  TEST_TIME  | 
 31  | 
 5021.61  | 
 0.9767  | 
 1.0270  | 
 2097  | 
 99  | 
|  TEST_TIME  | 
 32  | 
 5098.26  | 
 0.9799  | 
 1.0210  | 
 1753  | 
 99  | 
|  TEST_TIME  | 
 33  | 
 5186.80  | 
 0.9732  | 
 1.0221  | 
 1884  | 
 99  | 
|  TEST_TIME  | 
 34  | 
 5234.86  | 
 0.9830  | 
 1.0221  | 
 1553  | 
 99  | 
|  TEST_TIME  | 
 35  | 
 5291.79  | 
 0.9822  | 
 1.0183  | 
 1568  | 
 99  | 
|  TEST_TIME  | 
 36  | 
 5348.17  | 
 0.9796  | 
 1.0184  | 
 1632  | 
 99  | 
|  TEST_TIME  | 
 37  | 
 5355.03  | 
 0.9896  | 
 1.0077  | 
 1560  | 
 99  | 
|  TEST_TIME  | 
 38  | 
 5347.93  | 
 0.9825  | 
 1.0160  | 
 1139  | 
 99  | 
|  TEST_TIME  | 
 39  | 
 5358.83  | 
 0.9882  | 
 1.0128  | 
 1313  | 
 99  | 
|  TEST_TIME  | 
 40  | 
 5360.71  | 
 0.9871  | 
 1.0118  | 
 1135  | 
 99  | 
|  TEST_TIME  | 
 41  | 
 5336.43  | 
 0.9916  | 
 1.0090  | 
 1254  | 
 98  | 
|  TEST_TIME  | 
 42  | 
 5317.93  | 
 0.9884  | 
 1.0114  | 
 1250  | 
 99  | 
|  TEST_TIME  | 
 43  | 
 5306.20  | 
 0.9900  | 
 1.0130  | 
 1192  | 
 99  | 
|  TEST_TIME  | 
 44  | 
 5315.58  | 
 0.9882  | 
 1.0114  | 
 1335  | 
 99  | 
|  TEST_TIME  | 
 45  | 
 5315.84  | 
 0.9889  | 
 1.0124  | 
 1354  | 
 99  | 
|  TEST_TIME  | 
 46  | 
 5333.01  | 
 0.9872  | 
 1.0136  | 
 1931  | 
 99  | 
|  TEST_TIME  | 
 47  | 
 5384.70  | 
 0.9826  | 
 1.0184  | 
 1848  | 
 99  | 
|  TEST_TIME  | 
 48  | 
 5452.27  | 
 0.9849  | 
 1.0146  | 
 1644  | 
 99  | 
|  TEST_TIME  | 
 49  | 
 5504.29  | 
 0.9845  | 
 1.0156  | 
 1672  | 
 99  | 
|  TEST_TIME  | 
 50  | 
 5553.83  | 
 0.9865  | 
 1.0122  | 
 1567  | 
 99  | 
|  TEST_TIME  | 
 51  | 
 5581.42  | 
 0.9874  | 
 1.0137  | 
 1387  | 
 99  | 
|  TEST_TIME  | 
 52  | 
 5627.82  | 
 0.9860  | 
 1.0120  | 
 1520  | 
 99  | 
|  TEST_TIME  | 
 53  | 
 5661.01  | 
 0.9871  | 
 1.0124  | 
 1429  | 
 99  | 
|  TEST_TIME  | 
 54  | 
 5680.11  | 
 0.9903  | 
 1.0085  | 
 1458  | 
 99  | 
|  TEST_TIME  | 
 55  | 
 5705.57  | 
 0.9861  | 
 1.0115  | 
 1320  | 
 99  | 
|  TEST_TIME  | 
 56  | 
 5720.79  | 
 0.9910  | 
 1.0088  | 
 1360  | 
 99  | 
|  TEST_TIME  | 
 57  | 
 5725.65  | 
 0.9902  | 
 1.0088  | 
 1152  | 
 99  | 
|  TEST_TIME  | 
 58  | 
 5711.66  | 
 0.9938  | 
 1.0074  | 
 1305  | 
 99  | 
|  TEST_TIME  | 
 59  | 
 5709.33  | 
 0.9922  | 
 1.0081  | 
 1163  | 
 99  | 
|  TEST_TIME  | 
 60  | 
 5717.61  | 
 0.9899  | 
 1.0089  | 
 1057  | 
 99  | 
|  TEST_TIME  | 
 61  | 
 5712.47  | 
 0.9932  | 
 1.0080  | 
 1440  | 
 98  | 
|  TEST_TIME  | 
 62  | 
 5725.79  | 
 0.9894  | 
 1.0095  | 
 1607  | 
 99  | 
|  TEST_TIME  | 
 63  | 
 5754.79  | 
 0.9887  | 
 1.0090  | 
 1635  | 
 99  | 
|  TEST_TIME  | 
 64  | 
 5779.31  | 
 0.9890  | 
 1.0166  | 
 1738  | 
 99  | 
|  TEST_TIME  | 
 65  | 
 5838.76  | 
 0.9913  | 
 1.0083  | 
 1573  | 
 99  | 
|  TEST_TIME  | 
 66  | 
 5872.75  | 
 0.9873  | 
 1.0083  | 
 1374  | 
 99  | 
|  TEST_TIME  | 
 67  | 
 5880.21  | 
 0.9920  | 
 1.0098  | 
 1420  | 
 99  | 
|  TEST_TIME  | 
 68  | 
 5895.19  | 
 0.9927  | 
 1.0071  | 
 1408  | 
 99  | 
|  TEST_TIME  | 
 69  | 
 5897.59  | 
 0.9921  | 
 1.0071  | 
 1359  | 
 99  | 
|  TEST_TIME  | 
 70  | 
 5904.66  | 
 0.9915  | 
 1.0070  | 
 1282  | 
 99  | 
|  TEST_TIME  | 
 71  | 
 5922.74  | 
 0.9901  | 
 1.0094  | 
 1237  | 
 99  | 
|  TEST_TIME  | 
 72  | 
 5940.74  | 
 0.9924  | 
 1.0090  | 
 1163  | 
 99  | 
|  TEST_TIME  | 
 73  | 
 5957.20  | 
 0.9926  | 
 1.0068  | 
 1123  | 
 99  | 
|  TEST_TIME  | 
 74  | 
 5949.40  | 
 0.9945  | 
 1.0081  | 
 996  | 
 99  | 
|  TEST_TIME  | 
 75  | 
 5959.66  | 
 0.9930  | 
 1.0038  | 
 1038  | 
 99  | 
|  TEST_TIME  | 
 76  | 
 5974.23  | 
 0.9910  | 
 1.0095  | 
 1599  | 
 99  | 
|  TEST_TIME  | 
 77  | 
 6010.09  | 
 0.9905  | 
 1.0069  | 
 1533  | 
 99  | 
|  TEST_TIME  | 
 78  | 
 6035.21  | 
 0.9899  | 
 1.0096  | 
 1618  | 
 99  | 
|  TEST_TIME  | 
 79  | 
 6063.41  | 
 0.9922  | 
 1.0082  | 
 1629  | 
 99  | 
|  TEST_TIME  | 
 80  | 
 6076.04  | 
 0.9935  | 
 1.0073  | 
 1383  | 
 99  | 
|  TEST_TIME  | 
 81  | 
 6079.32  | 
 0.9944  | 
 1.0052  | 
 1407  | 
 99  | 
|  TEST_TIME  | 
 82  | 
 6075.71  | 
 0.9935  | 
 1.0071  | 
 1296  | 
 99  | 
|  TEST_TIME  | 
 83  | 
 6080.93  | 
 0.9941  | 
 1.0065  | 
 1360  | 
 99  | 
|  TEST_TIME  | 
 84  | 
 6079.98  | 
 0.9947  | 
 1.0044  | 
 1331  | 
 99  | 
|  TEST_TIME  | 
 85  | 
 6057.52  | 
 0.9963  | 
 1.0047  | 
 1375  | 
 98  | 
|  TEST_TIME  | 
 86  | 
 6057.33  | 
 0.9935  | 
 1.0050  | 
 1020  | 
 99  | 
|  TEST_TIME  | 
 87  | 
 6041.05  | 
 0.9961  | 
 1.0051  | 
 1287  | 
 99  | 
|  TEST_TIME  | 
 88  | 
 6038.34  | 
 0.9941  | 
 1.0064  | 
 1342  | 
 99  | 
|  TEST_TIME  | 
 89  | 
 6048.64  | 
 0.9934  | 
 1.0052  | 
 1411  | 
 99  | 
|  TEST_TIME  | 
 90  | 
 6047.12  | 
 0.9943  | 
 1.0049  | 
 1308  | 
 99  | 
|  TEST_TIME  | 
 91  | 
 6063.28  | 
 0.9912  | 
 1.0076  | 
 2270  | 
 99  | 
|  TEST_TIME  | 
 92  | 
 6067.56  | 
 0.9959  | 
 1.0051  | 
 2208  | 
 96  | 
|  TEST_TIME  | 
 93  | 
 6067.73  | 
 0.9943  | 
 1.0059  | 
 1901  | 
 93  | 
|  TEST_TIME  | 
 94  | 
 6103.26  | 
 0.9917  | 
 1.0069  | 
 1673  | 
 99  | 
|  TEST_TIME  | 
 95  | 
 6124.80  | 
 0.9930  | 
 1.0064  | 
 1447  | 
 99  | 
|  TEST_TIME  | 
 96  | 
 6138.28  | 
 0.9938  | 
 1.0070  | 
 1556  | 
 99  | 
|  TEST_TIME  | 
 97  | 
 6172.36  | 
 0.9912  | 
 1.0067  | 
 1425  | 
 99  | 
|  TEST_TIME  | 
 98  | 
 6200.79  | 
 0.9919  | 
 1.0044  | 
 1363  | 
 99  | 
|  TEST_TIME  | 
 99  | 
 6190.23  | 
 0.9960  | 
 1.0036  | 
 1363  | 
 98  | 
|  TEST_TIME  | 
 100  | 
 6183.27  | 
 0.9947  | 
 1.0041  | 
 1310  | 
 97  | 
|  TEST_TIME  | 
 101  | 
 6179.74  | 
 0.9947  | 
 1.0032  | 
 1182  | 
 99  | 
|  TEST_TIME  | 
 102  | 
 6153.99  | 
 0.9976  | 
 1.0062  | 
 1222  | 
 98  | 
|  TEST_TIME  | 
 103  | 
 6158.54  | 
 0.9957  | 
 1.0040  | 
 1376  | 
 99  | 
|  TEST_TIME  | 
 104  | 
 6145.26  | 
 0.9965  | 
 1.0039  | 
 1293  | 
 98  | 
|  TEST_TIME  | 
 105  | 
 6138.26  | 
 0.9955  | 
 1.0035  | 
 1151  | 
 99  | 
|  TEST_TIME  | 
 106  | 
 6133.79  | 
 0.9947  | 
 1.0051  | 
 1573  | 
 99  | 
|  TEST_TIME  | 
 107  | 
 6152.09  | 
 0.9927  | 
 1.0073  | 
 1727  | 
 99  | 
|  TEST_TIME  | 
 108  | 
 6171.77  | 
 0.9948  | 
 1.0045  | 
 1623  | 
 99  | 
|  TEST_TIME  | 
 109  | 
 6180.37  | 
 0.9939  | 
 1.0045  | 
 1878  | 
 99  | 
|  TEST_TIME  | 
 110  | 
 6167.71  | 
 0.9974  | 
 1.0034  | 
 1838  | 
 95  | 
|  TEST_TIME  | 
 111  | 
 6164.66  | 
 0.9948  | 
 1.0070  | 
 1748  | 
 97  | 
|  TEST_TIME  | 
 112  | 
 6175.39  | 
 0.9963  | 
 1.0033  | 
 1436  | 
 99  | 
|  TEST_TIME  | 
 113  | 
 6176.72  | 
 0.9942  | 
 1.0059  | 
 1524  | 
 99  | 
|  TEST_TIME  | 
 114  | 
 6191.87  | 
 0.9947  | 
 1.0043  | 
 1539  | 
 99  | 
|  TEST_TIME  | 
 115  | 
 6187.91  | 
 0.9962  | 
 1.0054  | 
 1426  | 
 99  | 
|  TEST_TIME  | 
 116  | 
 6199.53  | 
 0.9948  | 
 1.0046  | 
 1329  | 
 99  | 
|  TEST_TIME  | 
 117  | 
 6196.23  | 
 0.9965  | 
 1.0016  | 
 1394  | 
 99  | 
|  TEST_TIME  | 
 118  | 
 6181.06  | 
 0.9955  | 
 1.0041  | 
 1159  | 
 98  | 
|  TEST_TIME  | 
 119  | 
 6175.37  | 
 0.9966  | 
 1.0037  | 
 1315  | 
 99  | 
|  TEST_TIME  | 
 120  | 
 6173.09  | 
 0.9957  | 
 1.0038  | 
 1175  | 
 99  | 
|  TEST_TIME  | 
 121  | 
 6182.75  | 
 0.9940  | 
 1.0055  | 
 1622  | 
 99  | 
|  TEST_TIME  | 
 122  | 
 6180.90  | 
 0.9976  | 
 1.0025  | 
 2097  | 
 98  | 
|  TEST_TIME  | 
 123  | 
 6169.21  | 
 0.9962  | 
 1.0066  | 
 1449  | 
 87  | 
|  TEST_TIME  | 
 124  | 
 6193.09  | 
 0.9946  | 
 1.0025  | 
 1483  | 
 99  | 
|  TEST_TIME  | 
 125  | 
 6175.98  | 
 0.9972  | 
 1.0036  | 
 1797  | 
 91  | 
|  TEST_TIME  | 
 126  | 
 6178.92  | 
 0.9952  | 
 1.0067  | 
 1430  | 
 98  | 
|  TEST_TIME  | 
 127  | 
 6188.73  | 
 0.9972  | 
 1.0020  | 
 1770  | 
 99  | 
|  TEST_TIME  | 
 128  | 
 6169.49  | 
 0.9973  | 
 1.0032  | 
 1587  | 
 91  | 
|  TEST_TIME  | 
 129  | 
 6177.59  | 
 0.9941  | 
 1.0029  | 
 1455  | 
 97  | 
|  TEST_TIME  | 
 130  | 
 6182.67  | 
 0.9944  | 
 1.0058  | 
 1395  | 
 99  | 
|  TEST_TIME  | 
 131  | 
 6180.98  | 
 0.9984  | 
 1.0021  | 
 1473  | 
 99  | 
|  TEST_TIME  | 
 132  | 
 6159.77  | 
 0.9980  | 
 1.0022  | 
 1594  | 
 92  | 
|  TEST_TIME  | 
 133  | 
 6148.30  | 
 0.9966  | 
 1.0049  | 
 1339  | 
 97  | 
|  TEST_TIME  | 
 134  | 
 6156.30  | 
 0.9961  | 
 1.0037  | 
 1197  | 
 99  | 
|  TEST_TIME  | 
 135  | 
 6152.13  | 
 0.9969  | 
 1.0038  | 
 1279  | 
 99  | 
|  TEST_TIME  | 
 136  | 
 6165.92  | 
 0.9942  | 
 1.0039  | 
 1629  | 
 99  | 
|  TEST_TIME  | 
 137  | 
 6170.02  | 
 0.9959  | 
 1.0041  | 
 1991  | 
 98  | 
|  TEST_TIME  | 
 138  | 
 6174.17  | 
 0.9962  | 
 1.0025  | 
 1796  | 
 99  | 
|  TEST_TIME  | 
 139  | 
 6169.16  | 
 0.9961  | 
 1.0028  | 
 1720  | 
 97  | 
|  TEST_TIME  | 
 140  | 
 6176.02  | 
 0.9964  | 
 1.0020  | 
 1750  | 
 99  | 
|  TEST_TIME  | 
 141  | 
 6170.52  | 
 0.9958  | 
 1.0039  | 
 1423  | 
 99  | 
|  TEST_TIME  | 
 142  | 
 6169.03  | 
 0.9970  | 
 1.0017  | 
 1636  | 
 99  | 
|  TEST_TIME  | 
 143  | 
 6147.81  | 
 0.9981  | 
 1.0024  | 
 1573  | 
 84  | 
|  TEST_TIME  | 
 144  | 
 6150.17  | 
 0.9950  | 
 1.0044  | 
 1380  | 
 97  | 
|  TEST_TIME  | 
 145  | 
 6152.43  | 
 0.9971  | 
 1.0015  | 
 1429  | 
 99  | 
|  TEST_TIME  | 
 146  | 
 6143.29  | 
 0.9961  | 
 1.0031  | 
 1503  | 
 97  | 
|  TEST_TIME  | 
 147  | 
 6147.40  | 
 0.9964  | 
 1.0037  | 
 1264  | 
 99  | 
|  TEST_TIME  | 
 148  | 
 6149.51  | 
 0.9965  | 
 1.0034  | 
 1324  | 
 99  | 
|  TEST_TIME  | 
 149  | 
 6152.87  | 
 0.9962  | 
 1.0033  | 
 1265  | 
 99  | 
|  TEST_TIME  | 
 150  | 
 6141.37  | 
 0.9985  | 
 1.0030  | 
 1533  | 
 98  | 
|  TEST_TIME  | 
 151  | 
 6135.90  | 
 0.9973  | 
 1.0035  | 
 1849  | 
 97  | 
|  TEST_TIME  | 
 152  | 
 6142.23  | 
 0.9973  | 
 1.0036  | 
 2222  | 
 98  | 
|  TEST_TIME  | 
 153  | 
 6143.78  | 
 0.9968  | 
 1.0051  | 
 1709  | 
 95  | 
|  TEST_TIME  | 
 154  | 
 6170.50  | 
 0.9942  | 
 1.0028  | 
 1241  | 
 99  | 
|  TEST_TIME  | 
 155  | 
 6162.67  | 
 0.9976  | 
 1.0025  | 
 1240  | 
 99  | 
|  TEST_TIME  | 
 156  | 
 6164.38  | 
 0.9958  | 
 1.0032  | 
 1470  | 
 99  | 
|  TEST_TIME  | 
 157  | 
 6166.25  | 
 0.9965  | 
 1.0054  | 
 1440  | 
 99  | 
|  TEST_TIME  | 
 158  | 
 6177.58  | 
 0.9972  | 
 1.0029  | 
 1408  | 
 99  | 
|  TEST_TIME  | 
 159  | 
 6179.02  | 
 0.9964  | 
 1.0048  | 
 1246  | 
 99  | 
|  TEST_TIME  | 
 160  | 
 6177.20  | 
 0.9988  | 
 1.0015  | 
 1304  | 
 95  | 
|  TEST_TIME  | 
 161  | 
 6177.29  | 
 0.9976  | 
 1.0048  | 
 1045  | 
 99  | 
|  TEST_TIME  | 
 162  | 
 6188.39  | 
 0.9969  | 
 1.0016  | 
 1349  | 
 99  | 
|  TEST_TIME  | 
 163  | 
 6180.97  | 
 0.9967  | 
 1.0030  | 
 1228  | 
 99  | 
|  TEST_TIME  | 
 164  | 
 6178.13  | 
 0.9973  | 
 1.0023  | 
 1306  | 
 99  | 
|  TEST_TIME  | 
 165  | 
 6170.16  | 
 0.9975  | 
 1.0017  | 
 1302  | 
 99  | 
|  TEST_TIME  | 
 166  | 
 6182.60  | 
 0.9939  | 
 1.0035  | 
 1667  | 
 99  | 
|  TEST_TIME  | 
 167  | 
 6189.70  | 
 0.9964  | 
 1.0027  | 
 1973  | 
 99  | 
|  TEST_TIME  | 
 168  | 
 6188.26  | 
 0.9970  | 
 1.0027  | 
 1890  | 
 93  | 
|  TEST_TIME  | 
 169  | 
 6192.28  | 
 0.9961  | 
 1.0031  | 
 1661  | 
 93  | 
|  TEST_TIME  | 
 170  | 
 6196.89  | 
 0.9964  | 
 1.0032  | 
 1646  | 
 96  | 
|  TEST_TIME  | 
 171  | 
 6193.41  | 
 0.9980  | 
 1.0021  | 
 1698  | 
 95  | 
|  TEST_TIME  | 
 172  | 
 6193.24  | 
 0.9963  | 
 1.0030  | 
 1327  | 
 99  | 
|  TEST_TIME  | 
 173  | 
 6191.14  | 
 0.9975  | 
 1.0019  | 
 1357  | 
 99  | 
|  TEST_TIME  | 
 174  | 
 6191.44  | 
 0.9961  | 
 1.0022  | 
 1333  | 
 99  | 
|  TEST_TIME  | 
 175  | 
 6182.37  | 
 0.9979  | 
 1.0020  | 
 1359  | 
 93  | 
|  TEST_TIME  | 
 176  | 
 6191.74  | 
 0.9948  | 
 1.0029  | 
 1111  | 
 99  | 
|  TEST_TIME  | 
 177  | 
 6184.40  | 
 0.9984  | 
 1.0009  | 
 1228  | 
 99  | 
|  TEST_TIME  | 
 178  | 
 6184.58  | 
 0.9952  | 
 1.0037  | 
 1118  | 
 99  | 
|  TEST_TIME  | 
 179  | 
 6185.57  | 
 0.9980  | 
 1.0024  | 
 1175  | 
 99  | 
|  TEST_TIME  | 
 180  | 
 6171.01  | 
 0.9991  | 
 1.0011  | 
 952  | 
 98  | 
 
Done for 10920 ms, from  6:58:32.38 to  6:58:43.30.  
 
 
|  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  | 
 73070  | 
 74448  | 
 70429  | 
 <null>  | 
 63001  | 
 56750  | 
 85038  | 
 <null>  | 
 47372  | 
 100003  | 
 81429  | 
 64012  | 
 107388  | 
 115109  | 
 158242  | 
 185250  | 
 64559  | 
 557950  | 
 <null>  | 
 03:46:38  | 
 04:04:37  | 
|  fetches per second  | 
 2  | 
 70461  | 
 99114  | 
 55392  | 
 <null>  | 
 64338  | 
 122888  | 
 87087  | 
 115041  | 
 64853  | 
 89316  | 
 83678  | 
 67230  | 
 78107  | 
 94125  | 
 167007  | 
 96138  | 
 154800  | 
 136095  | 
 <null>  | 
 04:04:38  | 
 04:22:37  | 
|  fetches per second  | 
 3  | 
 54016  | 
 46962  | 
 55343  | 
 <null>  | 
 36628  | 
 114344  | 
 86952  | 
 145106  | 
 30343  | 
 161300  | 
 72599  | 
 22725  | 
 96875  | 
 116958  | 
 128340  | 
 74428  | 
 9317  | 
 249513  | 
 <null>  | 
 04:22:38  | 
 04:40:37  | 
|  fetches per second  | 
 4  | 
 53211  | 
 64688  | 
 52844  | 
 131679  | 
 54886  | 
 113153  | 
 103531  | 
 132768  | 
 2900  | 
 45076  | 
 66419  | 
 7571  | 
 85516  | 
 25570  | 
 87065  | 
 50600  | 
 171623  | 
 617083  | 
 <null>  | 
 04:40:38  | 
 04:58:37  | 
|  fetches per second  | 
 5  | 
 40947  | 
 38477  | 
 48919  | 
 <null>  | 
 35174  | 
 67888  | 
 98790  | 
 55259  | 
 48315  | 
 81811  | 
 85763  | 
 27974  | 
 88739  | 
 97750  | 
 66550  | 
 <null>  | 
 105499  | 
 514875  | 
 <null>  | 
 04:58:38  | 
 05:16:37  | 
|  fetches per second  | 
 6  | 
 30189  | 
 42310  | 
 39528  | 
 73752  | 
 33455  | 
 <null>  | 
 65548  | 
 <null>  | 
 25249  | 
 5576  | 
 26786  | 
 10209  | 
 60303  | 
 26942  | 
 40592  | 
 3147  | 
 <null>  | 
 37581  | 
 <null>  | 
 05:16:38  | 
 05:34:37  | 
|  fetches per second  | 
 7  | 
 26735  | 
 52554  | 
 26636  | 
 37470  | 
 31030  | 
 <null>  | 
 21499  | 
 <null>  | 
 83577  | 
 <null>  | 
 32959  | 
 27685  | 
 46447  | 
 10092  | 
 45529  | 
 1894  | 
 40553  | 
 151135  | 
 <null>  | 
 05:34:38  | 
 05:52:37  | 
|  fetches per second  | 
 8  | 
 15800  | 
 51517  | 
 22046  | 
 17829  | 
 12754  | 
 <null>  | 
 19488  | 
 <null>  | 
 9506  | 
 4006  | 
 12252  | 
 3456  | 
 17265  | 
 4037  | 
 15992  | 
 3022  | 
 <null>  | 
 56713  | 
 <null>  | 
 05:52:38  | 
 06:10:37  | 
|  fetches per second  | 
 9  | 
 31202  | 
 47688  | 
 48020  | 
 <null>  | 
 16164  | 
 <null>  | 
 87011  | 
 7483  | 
 7327  | 
 59487  | 
 43941  | 
 50391  | 
 67529  | 
 95428  | 
 57256  | 
 5972  | 
 123129  | 
 205325  | 
 <null>  | 
 06:10:38  | 
 06:28:37  | 
|  fetches per second  | 
 10  | 
 17500  | 
 1944  | 
 11101  | 
 <null>  | 
 34125  | 
 <null>  | 
 41436  | 
 <null>  | 
 8743  | 
 5227  | 
 28754  | 
 15847  | 
 21696  | 
 40310  | 
 30418  | 
 153571  | 
 <null>  | 
 79539  | 
 <null>  | 
 06:28:38  | 
 06:46:37  | 
|  marks per second  | 
 1  | 
 15756  | 
 9091  | 
 15584  | 
 <null>  | 
 14043  | 
 11093  | 
 12223  | 
 <null>  | 
 5761  | 
 19795  | 
 13583  | 
 11322  | 
 9300  | 
 22683  | 
 10366  | 
 26250  | 
 8329  | 
 53425  | 
 <null>  | 
 03:46:38  | 
 04:04:37  | 
|  marks per second  | 
 2  | 
 14923  | 
 12962  | 
 12507  | 
 <null>  | 
 14307  | 
 18444  | 
 10623  | 
 17974  | 
 9340  | 
 14695  | 
 13715  | 
 10046  | 
 6252  | 
 22000  | 
 6229  | 
 12458  | 
 11799  | 
 12375  | 
 <null>  | 
 04:04:38  | 
 04:22:37  | 
|  marks per second  | 
 3  | 
 11557  | 
 6218  | 
 11971  | 
 <null>  | 
 8172  | 
 30333  | 
 10064  | 
 20368  | 
 3921  | 
 32050  | 
 9499  | 
 3696  | 
 6281  | 
 16550  | 
 7809  | 
 11594  | 
 717  | 
 17892  | 
 <null>  | 
 04:22:38  | 
 04:40:37  | 
|  marks per second  | 
 4  | 
 11149  | 
 8962  | 
 11601  | 
 25051  | 
 11805  | 
 23205  | 
 14330  | 
 20975  | 
 386  | 
 6769  | 
 9381  | 
 1037  | 
 6243  | 
 4150  | 
 8582  | 
 7466  | 
 13633  | 
 28000  | 
 <null>  | 
 04:40:38  | 
 04:58:37  | 
|  marks per second  | 
 5  | 
 8721  | 
 4680  | 
 11085  | 
 <null>  | 
 7295  | 
 16864  | 
 11887  | 
 8173  | 
 5162  | 
 11828  | 
 7198  | 
 4727  | 
 4871  | 
 16000  | 
 11870  | 
 <null>  | 
 14871  | 
 65208  | 
 <null>  | 
 04:58:38  | 
 05:16:37  | 
|  marks per second  | 
 6  | 
 5883  | 
 5228  | 
 8154  | 
 12521  | 
 6861  | 
 <null>  | 
 7027  | 
 <null>  | 
 3040  | 
 942  | 
 4432  | 
 1690  | 
 2625  | 
 5369  | 
 5100  | 
 447  | 
 <null>  | 
 1047  | 
 <null>  | 
 05:16:38  | 
 05:34:37  | 
|  marks per second  | 
 7  | 
 5487  | 
 6096  | 
 5188  | 
 5459  | 
 6606  | 
 <null>  | 
 2694  | 
 <null>  | 
 7027  | 
 <null>  | 
 4029  | 
 4244  | 
 2147  | 
 1584  | 
 6328  | 
 321  | 
 4317  | 
 2153  | 
 <null>  | 
 05:34:38  | 
 05:52:37  | 
|  marks per second  | 
 8  | 
 3229  | 
 6673  | 
 4154  | 
 3458  | 
 2617  | 
 <null>  | 
 2118  | 
 <null>  | 
 1068  | 
 566  | 
 1808  | 
 539  | 
 737  | 
 613  | 
 2530  | 
 707  | 
 <null>  | 
 1443  | 
 <null>  | 
 05:52:38  | 
 06:10:37  | 
|  marks per second  | 
 9  | 
 6410  | 
 7464  | 
 10218  | 
 <null>  | 
 3309  | 
 <null>  | 
 8723  | 
 1027  | 
 1042  | 
 7991  | 
 6432  | 
 7502  | 
 2617  | 
 14285  | 
 5707  | 
 992  | 
 8662  | 
 17734  | 
 <null>  | 
 06:10:38  | 
 06:28:37  | 
|  marks per second  | 
 10  | 
 3648  | 
 258  | 
 2175  | 
 <null>  | 
 6290  | 
 <null>  | 
 4638  | 
 <null>  | 
 852  | 
 922  | 
 3484  | 
 2190  | 
 671  | 
 6571  | 
 3223  | 
 36000  | 
 <null>  | 
 888  | 
 <null>  | 
 06:28:38  | 
 06:46:37  | 
|  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:38  | 
 04:04:37  | 
|  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:38  | 
 04:22:37  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:22:38  | 
 04:40:37  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:40:38  | 
 04:58:37  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:58:38  | 
 05:16:37  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:16:38  | 
 05:34:37  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:34:38  | 
 05:52:37  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:52:38  | 
 06:10:37  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:10:38  | 
 06:28:37  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:28:38  | 
 06:46:37  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 8  | 
 1  | 
 <null>  | 
 03:46:38  | 
 04:04:37  | 
|  writes/marks*100  | 
 2  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 04:04:38  | 
 04:22:37  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 4  | 
 0  | 
 <null>  | 
 04:22:38  | 
 04:40:37  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 5  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 04:40:38  | 
 04:58:37  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 1  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 <null>  | 
 04:58:38  | 
 05:16:37  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:16:38  | 
 05:34:37  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:34:38  | 
 05:52:37  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:52:38  | 
 06:10:37  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 9  | 
 0  | 
 <null>  | 
 06:10:38  | 
 06:28:37  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:28:38  | 
 06:46:37  | 
 
Done for 9590 ms, from  6:58:44.11 to  6:58:53.70.  
 
 
|  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  | 
 1962017  | 
 1789616  | 
 172401  | 
 8.78  | 
 0  | 
 9890  | 
 30  | 
 172401  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  doc_list_biud  | 
 1962424  | 
 1789616  | 
 172808  | 
 8.80  | 
 0  | 
 10218  | 
 11  | 
 172808  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_add_invoice_to_stock  | 
 19319  | 
 11301  | 
 8018  | 
 41.50  | 
 15  | 
 111931  | 
 6618  | 
 8018  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_adding_invoice  | 
 4716  | 
 3591  | 
 1125  | 
 23.85  | 
 0  | 
 68718  | 
 1764  | 
 1125  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_client_order  | 
 6765  | 
 6622  | 
 143  | 
 2.11  | 
 0  | 
 4430  | 
 183  | 
 143  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_customer_reserve  | 
 380419  | 
 218616  | 
 161803  | 
 42.53  | 
 0  | 
 4992  | 
 41  | 
 161803  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2553  | 
 2542  | 
 11  | 
 0.43  | 
 0  | 
 2917  | 
 99  | 
 11  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1572  | 
 1565  | 
 7  | 
 0.44  | 
 0  | 
 2808  | 
 107  | 
 7  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_supplier_invoice  | 
 9405  | 
 7303  | 
 2102  | 
 22.34  | 
 0  | 
 10732  | 
 311  | 
 2102  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_supplier_order  | 
 1503  | 
 535  | 
 968  | 
 64.40  | 
 31  | 
 156967  | 
 14054  | 
 968  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_cancel_write_off  | 
 24867  | 
 16342  | 
 8525  | 
 34.28  | 
 0  | 
 3885  | 
 105  | 
 8525  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_client_order  | 
 80098  | 
 80098  | 
 0  | 
 0.00  | 
 0  | 
 5475  | 
 350  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_customer_reserve  | 
 632114  | 
 632114  | 
 0  | 
 0.00  | 
 0  | 
 6427  | 
 94  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_fill_shopping_cart  | 
 121633  | 
 121298  | 
 335  | 
 0.27  | 
 0  | 
 4524  | 
 69  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 632114  | 
 632114  | 
 0  | 
 0.00  | 
 0  | 
 2917  | 
 7  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_get_clo_for_invoice  | 
 11301  | 
 11301  | 
 0  | 
 0.00  | 
 0  | 
 5008  | 
 215  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_kill_cost_storno  | 
 33314  | 
 24040  | 
 9274  | 
 27.83  | 
 0  | 
 2839  | 
 14  | 
 9274  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 794738  | 
 461412  | 
 333326  | 
 41.94  | 
 0  | 
 10203  | 
 15  | 
 333326  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_kill_qty_storno  | 
 473990  | 
 301250  | 
 172740  | 
 36.44  | 
 0  | 
 10203  | 
 46  | 
 172740  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_lock_selected_doc  | 
 79198  | 
 67966  | 
 11232  | 
 14.18  | 
 0  | 
 2122  | 
 5  | 
 11232  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_make_cost_storno  | 
 97060  | 
 97060  | 
 0  | 
 0.00  | 
 0  | 
 9501  | 
 260  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 97060  | 
 97060  | 
 0  | 
 0.00  | 
 0  | 
 4243  | 
 41  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 80098  | 
 80098  | 
 0  | 
 0.00  | 
 0  | 
 4633  | 
 117  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_pay_from_customer  | 
 26647  | 
 26647  | 
 0  | 
 0.00  | 
 0  | 
 10359  | 
 612  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_pay_to_supplier  | 
 22172  | 
 22172  | 
 0  | 
 0.00  | 
 0  | 
 7270  | 
 311  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_payment_common  | 
 48819  | 
 48819  | 
 0  | 
 0.00  | 
 0  | 
 3479  | 
 48  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 6762  | 
 6622  | 
 140  | 
 2.07  | 
 0  | 
 2933  | 
 78  | 
 140  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 15860  | 
 14892  | 
 968  | 
 6.10  | 
 0  | 
 6240  | 
 237  | 
 968  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 36940  | 
 36940  | 
 0  | 
 0.00  | 
 0  | 
 4680  | 
 36  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_reserve_write_off  | 
 38024  | 
 36940  | 
 1084  | 
 2.85  | 
 0  | 
 10311  | 
 401  | 
 1084  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_supplier_invoice  | 
 20640  | 
 20528  | 
 112  | 
 0.54  | 
 0  | 
 49795  | 
 1932  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  sp_supplier_order  | 
 20895  | 
 20672  | 
 223  | 
 1.06  | 
 0  | 
 17285  | 
 1411  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  srv_find_qd_qs_mism  | 
 1191312  | 
 1018970  | 
 172342  | 
 14.46  | 
 0  | 
 3884  | 
 16  | 
 172342  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  srv_make_invnt_saldo  | 
 1827  | 
 1827  | 
 0  | 
 0.00  | 
 16  | 
 50279  | 
 1744  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  srv_make_money_saldo  | 
 2607  | 
 2607  | 
 0  | 
 0.00  | 
 0  | 
 1950  | 
 54  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 1732  | 
 26583  | 
 7660  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 8018  | 
 8018  | 
 0  | 
 0.00  | 
 0  | 
 2106  | 
 78  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 732  | 
 732  | 
 0  | 
 0.00  | 
 0  | 
 2324  | 
 91  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 143  | 
 143  | 
 0  | 
 0.00  | 
 0  | 
 1123  | 
 72  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 79  | 
 79  | 
 0  | 
 0.00  | 
 0  | 
 1123  | 
 73  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 11  | 
 11  | 
 0  | 
 0.00  | 
 0  | 
 203  | 
 31  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 7  | 
 7  | 
 0  | 
 0.00  | 
 0  | 
 608  | 
 127  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 666  | 
 666  | 
 0  | 
 0.00  | 
 0  | 
 1420  | 
 74  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 19558  | 
 19558  | 
 0  | 
 0.00  | 
 0  | 
 2527  | 
 62  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 24  | 
 24  | 
 0  | 
 0.00  | 
 0  | 
 999  | 
 80  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1084  | 
 1084  | 
 0  | 
 0.00  | 
 0  | 
 1451  | 
 42  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 112  | 
 112  | 
 0  | 
 0.00  | 
 0  | 
 702  | 
 61  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 223  | 
 223  | 
 0  | 
 0.00  | 
 0  | 
 1186  | 
 52  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 11301  | 
 11301  | 
 0  | 
 0.00  | 
 0  | 
 12604  | 
 391  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1333  | 
 1333  | 
 0  | 
 0.00  | 
 0  | 
 7987  | 
 447  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6622  | 
 6622  | 
 0  | 
 0.00  | 
 0  | 
 2855  | 
 50  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2494  | 
 2494  | 
 0  | 
 0.00  | 
 0  | 
 2293  | 
 52  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2542  | 
 2542  | 
 0  | 
 0.00  | 
 0  | 
 2496  | 
 46  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1565  | 
 1565  | 
 0  | 
 0.00  | 
 0  | 
 2356  | 
 38  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 940  | 
 940  | 
 0  | 
 0.00  | 
 0  | 
 2465  | 
 49  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 535  | 
 535  | 
 0  | 
 0.00  | 
 0  | 
 46675  | 
 1278  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3694  | 
 3694  | 
 0  | 
 0.00  | 
 0  | 
 3916  | 
 52  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_client_order  | 
 80098  | 
 80098  | 
 0  | 
 0.00  | 
 0  | 
 4929  | 
 57  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 3736  | 
 3736  | 
 0  | 
 0.00  | 
 0  | 
 2044  | 
 42  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 26647  | 
 26647  | 
 0  | 
 0.00  | 
 0  | 
 2995  | 
 49  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 22172  | 
 22172  | 
 0  | 
 0.00  | 
 0  | 
 3292  | 
 46  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 36940  | 
 36940  | 
 0  | 
 0.00  | 
 0  | 
 4914  | 
 58  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 20528  | 
 20528  | 
 0  | 
 0.00  | 
 0  | 
 2559  | 
 47  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 20672  | 
 20672  | 
 0  | 
 0.00  | 
 0  | 
 3260  | 
 50  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1827  | 
 1827  | 
 0  | 
 0.00  | 
 0  | 
 843  | 
 17  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 2607  | 
 2607  | 
 0  | 
 0.00  | 
 0  | 
 1778  | 
 22  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 296  | 
 45  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_add_invoice_to_stock  | 
 38638  | 
 22602  | 
 16036  | 
 41.50  | 
 0  | 
 1404  | 
 21  | 
 16036  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_all_customers  | 
 120198  | 
 120198  | 
 0  | 
 0.00  | 
 0  | 
 983  | 
 4  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_all_suppliers  | 
 84850  | 
 84180  | 
 670  | 
 0.78  | 
 0  | 
 1014  | 
 4  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_all_wares  | 
 160196  | 
 160196  | 
 0  | 
 0.00  | 
 0  | 
 1232  | 
 3  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_adding_invoice  | 
 3130  | 
 2666  | 
 464  | 
 14.82  | 
 0  | 
 2932  | 
 137  | 
 464  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_client_order  | 
 13530  | 
 13244  | 
 286  | 
 2.11  | 
 0  | 
 1107  | 
 5  | 
 286  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_customer_prepayment  | 
 5106  | 
 5084  | 
 22  | 
 0.43  | 
 0  | 
 1029  | 
 6  | 
 22  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_customer_reserve  | 
 5146  | 
 4988  | 
 158  | 
 3.07  | 
 0  | 
 968  | 
 7  | 
 158  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_payment_to_supplier  | 
 3144  | 
 3130  | 
 14  | 
 0.44  | 
 0  | 
 936  | 
 8  | 
 14  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_supplier_invoice  | 
 3212  | 
 1880  | 
 1332  | 
 41.46  | 
 0  | 
 1560  | 
 20  | 
 1332  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_supplier_order  | 
 3006  | 
 1070  | 
 1936  | 
 64.40  | 
 0  | 
 1233  | 
 6  | 
 1936  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_cancel_write_off  | 
 7436  | 
 7388  | 
 48  | 
 0.64  | 
 0  | 
 3104  | 
 80  | 
 48  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_max_id_clo_ord  | 
 20895  | 
 20672  | 
 223  | 
 1.06  | 
 0  | 
 936  | 
 4  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_max_id_clo_res  | 
 3736  | 
 3736  | 
 0  | 
 0.00  | 
 0  | 
 1747  | 
 14  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_max_id_ord_sup  | 
 20640  | 
 20528  | 
 112  | 
 0.54  | 
 0  | 
 952  | 
 4  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_max_non_paid_invoice  | 
 21282  | 
 21282  | 
 0  | 
 0.00  | 
 0  | 
 1497  | 
 4  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_max_non_paid_realizn  | 
 26647  | 
 26647  | 
 0  | 
 0.00  | 
 0  | 
 733  | 
 4  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_min_id_clo_ord  | 
 20895  | 
 20672  | 
 223  | 
 1.06  | 
 0  | 
 811  | 
 5  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_min_id_clo_res  | 
 3736  | 
 3736  | 
 0  | 
 0.00  | 
 0  | 
 1997  | 
 9  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_min_id_ord_sup  | 
 20640  | 
 20528  | 
 112  | 
 0.54  | 
 0  | 
 1778  | 
 6  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_min_non_paid_invoice  | 
 22172  | 
 22172  | 
 0  | 
 0.00  | 
 0  | 
 3385  | 
 8  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_min_non_paid_realizn  | 
 26647  | 
 26647  | 
 0  | 
 0.00  | 
 0  | 
 3073  | 
 7  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_our_firm  | 
 39998  | 
 39998  | 
 0  | 
 0.00  | 
 0  | 
 748  | 
 4  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  v_reserve_write_off  | 
 76048  | 
 73880  | 
 2168  | 
 2.85  | 
 0  | 
 1466  | 
 6  | 
 2168  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 19115  | 
 9954  | 
 9161  | 
 47.92  | 
 0  | 
 1623  | 
 24  | 
 9161  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1502  | 
 535  | 
 967  | 
 64.38  | 
 0  | 
 1700  | 
 41  | 
 967  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  x_make_qstorno_1000_1200  | 
 20895  | 
 20672  | 
 223  | 
 1.06  | 
 0  | 
 16053  | 
 1257  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  x_make_qstorno_1200_2000  | 
 20640  | 
 20528  | 
 112  | 
 0.54  | 
 0  | 
 49078  | 
 1776  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  x_make_qstorno_2100_3300  | 
 632114  | 
 632114  | 
 0  | 
 0.00  | 
 0  | 
 6053  | 
 78  | 
 0  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
 
Done for 361840 ms, from  7:04:53.49 to  7:10:55.33.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 58  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2018-03-17 03:47  | 
 2018-03-17 06:45  | 
|  deadlock  | 
 72  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2018-03-17 03:47  | 
 2018-03-17 06:43  | 
|  deadlock  | 
 9887  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2018-03-17 03:46  | 
 2018-03-17 06:46  | 
|  deadlock  | 
 140  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2018-03-17 03:47  | 
 2018-03-17 06:42  | 
|  deadlock  | 
 200  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2018-03-17 03:47  | 
 2018-03-17 06:45  | 
|  deadlock  | 
 676  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2018-03-17 03:47  | 
 2018-03-17 06:46  | 
|  deadlock  | 
 191  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2018-03-17 03:52  | 
 2018-03-17 06:45  | 
|  user_exc  | 
 223  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2018-03-17 03:47  | 
 2018-03-17 06:45  | 
|  user_exc  | 
 112  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2018-03-17 03:47  | 
 2018-03-17 06:46  | 
 
Done for 11030 ms, from  7:11:05.08 to  7:11:16.11.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          435186
 
MON$OLDEST_ACTIVE               435187
 
MON$OLDEST_SNAPSHOT             435187
 
MON$NEXT_TRANSACTION            435187
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2017-01-11 15:12:20.4040
 
MON$PAGES                       819904
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.4.32931 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.4.32931 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.4.32931 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.4.32931 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Gstat execution time Sat Mar 17 07:11:16 2018 
 
 
Database header page information: 
 
Flags			0 
 
Generation		435342 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	435188 
 
Oldest active		435189 
 
Oldest snapshot		435189 
 
Next transaction	435190 
 
Sequence number		0 
 
Next attachment ID	9501 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Jan 11, 2017 15:12:20 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 33.58, total records: 50 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 344.00, compression ratio: 10.24 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 44 
 
Average key length: 2.04, compression ratio: 0.54 
 
Average prefix length: 1.04, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.16, total dup: 0, max dup: 0 
 
Average key length: 15.86, compression ratio: 0.92 
 
Average prefix length: 1.44, average data length: 13.16 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 107.00, total records: 19 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1236.00, compression ratio: 11.55 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 29% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BO_UNIT_UNQ (1) 
 
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.08, total records: 2123372 
 
Average version length: 47.92, total versions: 2322, 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: 22944 
 
Data pages: 22944, average fill: 73% 
 
Primary pages: 22944, secondary pages: 0, swept pages: 13029 
 
Empty pages: 5, full pages: 21482 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 14 
 
40 - 59% = 78 
 
60 - 79% = 22842 
 
80 - 99% = 3 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10253, nodes: 2123372 
 
Average node length: 19.28, total dup: 0, max dup: 0 
 
Average key length: 16.33, compression ratio: 1.65 
 
Average prefix length: 13.67, average data length: 13.33 
 
Clustering factor: 376010, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 768 
 
20 - 39% = 2432 
 
40 - 59% = 4260 
 
60 - 79% = 1244 
 
80 - 99% = 1549 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7566, nodes: 2123372 
 
Average node length: 11.64, total dup: 0, max dup: 0 
 
Average key length: 8.68, compression ratio: 1.04 
 
Average prefix length: 3.31, average data length: 5.69 
 
Clustering factor: 365513, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 3432 
 
40 - 59% = 4009 
 
60 - 79% = 113 
 
80 - 99% = 9 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 176949, depth: 3, leaf buckets: 3592, nodes: 2123372 
 
Average node length: 6.80, total dup: 1551997, max dup: 49 
 
Average key length: 3.85, compression ratio: 2.34 
 
Average prefix length: 7.42, average data length: 1.58 
 
Clustering factor: 340299, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 140 
 
20 - 39% = 1104 
 
40 - 59% = 1416 
 
60 - 79% = 361 
 
80 - 99% = 571 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.42, total records: 636477 
 
Average version length: 35.92, total versions: 987, max versions: 3 
 
Average fragment length: 30.73, total fragments: 11, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 5, data page slots: 8040 
 
Data pages: 8040, average fill: 75% 
 
Primary pages: 8032, secondary pages: 8, swept pages: 7234 
 
Empty pages: 5, full pages: 7704 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 3 
 
40 - 59% = 15 
 
60 - 79% = 7993 
 
80 - 99% = 15 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 245178, depth: 3, leaf buckets: 2328, nodes: 636477 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.82, compression ratio: 1.02 
 
Average prefix length: 3.17, average data length: 5.83 
 
Clustering factor: 142686, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1248 
 
40 - 59% = 1025 
 
60 - 79% = 47 
 
80 - 99% = 7 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 667, nodes: 636477 
 
Average node length: 4.87, total dup: 636427, max dup: 42667 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 291127, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 570 
 
60 - 79% = 83 
 
80 - 99% = 14 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 341279, depth: 3, leaf buckets: 1727, nodes: 636477 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.82, compression ratio: 1.02 
 
Average prefix length: 3.18, average data length: 5.82 
 
Clustering factor: 142686, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 111 
 
20 - 39% = 378 
 
40 - 59% = 600 
 
60 - 79% = 325 
 
80 - 99% = 313 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 270, Index root page: 271 
 
Total formats: 1, used formats: 1 
 
Average record length: 63.69, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 16.74, total fragments: 373, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.63 
 
Pointer pages: 1, data page slots: 304 
 
Data pages: 132, average fill: 6% 
 
Primary pages: 4, secondary pages: 128, swept pages: 4 
 
Empty pages: 100, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 117 
 
20 - 39% = 11 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.24, total records: 884 
 
Average version length: 71.33, total versions: 12, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.37 
 
Pointer pages: 1, data page slots: 584 
 
Data pages: 96, average fill: 12% 
 
Primary pages: 95, secondary pages: 1, swept pages: 78 
 
Empty pages: 27, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 79 
 
20 - 39% = 8 
 
40 - 59% = 5 
 
60 - 79% = 4 
 
80 - 99% = 0 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 6, nodes: 884 
 
Average node length: 19.55, total dup: 0, max dup: 0 
 
Average key length: 17.55, compression ratio: 1.54 
 
Average prefix length: 12.44, average data length: 14.56 
 
Clustering factor: 748, ratio: 0.85 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 2 
 
40 - 59% = 3 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.02, total records: 49 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 32.00, compression ratio: 2.13 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 20% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 260, Index root page: 261 
 
Total formats: 1, used formats: 1 
 
Average record length: 8.81, total records: 391 
 
Average version length: 45.10, total versions: 314, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 7.26 
 
Pointer pages: 1, data page slots: 24 
 
Data pages: 16, average fill: 24% 
 
Primary pages: 16, secondary pages: 0, swept pages: 7 
 
Empty pages: 6, full pages: 2 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 3 
 
40 - 59% = 0 
 
60 - 79% = 2 
 
80 - 99% = 1 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 501688, depth: 2, leaf buckets: 1, nodes: 391 
 
Average node length: 5.47, total dup: 329, max dup: 35 
 
Average key length: 4.29, compression ratio: 4.42 
 
Average prefix length: 16.86, average data length: 2.14 
 
Clustering factor: 205, ratio: 0.52 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (165) 
 
Primary pointer page: 354, Index root page: 355 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_DTS (4) 
 
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (166) 
 
Primary pointer page: 366, Index root page: 367 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 42.55, total records: 212831 
 
Average version length: 29.96, total versions: 846, max versions: 7 
 
Average fragment length: 34.00, total fragments: 1, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.50 
 
Pointer pages: 2, data page slots: 2456 
 
Data pages: 2456, average fill: 65% 
 
Primary pages: 2434, secondary pages: 22, swept pages: 1848 
 
Empty pages: 33, full pages: 1106 
 
Fill distribution: 
 
0 - 19% = 113 
 
20 - 39% = 178 
 
40 - 59% = 110 
 
60 - 79% = 2052 
 
80 - 99% = 3 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 206, nodes: 212831 
 
Average node length: 4.51, total dup: 212782, max dup: 10544 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 36775, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 23 
 
40 - 59% = 100 
 
60 - 79% = 72 
 
80 - 99% = 11 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 221, nodes: 212831 
 
Average node length: 5.44, total dup: 191927, max dup: 64 
 
Average key length: 2.94, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 49361, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 13 
 
40 - 59% = 72 
 
60 - 79% = 88 
 
80 - 99% = 48 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 225, nodes: 212831 
 
Average node length: 5.44, total dup: 191927, max dup: 64 
 
Average key length: 2.94, compression ratio: 7.47 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 49454, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 14 
 
40 - 59% = 78 
 
60 - 79% = 89 
 
80 - 99% = 43 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 234, nodes: 212831 
 
Average node length: 5.23, total dup: 191927, max dup: 64 
 
Average key length: 2.73, compression ratio: 3.29 
 
Average prefix length: 8.36, average data length: 0.64 
 
Clustering factor: 49401, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 24 
 
40 - 59% = 113 
 
60 - 79% = 66 
 
80 - 99% = 30 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.98, total records: 264652 
 
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: 2264 
 
Data pages: 2264, average fill: 64% 
 
Primary pages: 2264, secondary pages: 0, swept pages: 0 
 
Empty pages: 2, full pages: 2261 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 2261 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 168880, depth: 2, leaf buckets: 211, nodes: 264652 
 
Average node length: 4.52, total dup: 264471, max dup: 2269 
 
Average key length: 2.00, compression ratio: 1.30 
 
Average prefix length: 2.59, average data length: 0.00 
 
Clustering factor: 33691, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 77 
 
60 - 79% = 73 
 
80 - 99% = 60 
 
 
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.61, total records: 12063046 
 
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: 176, data page slots: 286184 
 
Data pages: 286184, average fill: 87% 
 
Primary pages: 286184, secondary pages: 0, swept pages: 3 
 
Empty pages: 6, full pages: 286177 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 286177 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 13844, nodes: 12063046 
 
Average node length: 5.67, total dup: 11222800, max dup: 152 
 
Average key length: 2.17, compression ratio: 3.69 
 
Average prefix length: 7.87, average data length: 0.12 
 
Clustering factor: 3165910, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 0 
 
40 - 59% = 8163 
 
60 - 79% = 3723 
 
80 - 99% = 1949 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 12047, nodes: 12063046 
 
Average node length: 4.61, total dup: 12063042, max dup: 10799053 
 
Average key length: 1.11, compression ratio: 0.47 
 
Average prefix length: 0.52, average data length: 0.00 
 
Clustering factor: 350636, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 12044 
 
60 - 79% = 0 
 
80 - 99% = 3 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 14908, nodes: 12063046 
 
Average node length: 5.73, total dup: 11700232, max dup: 20861 
 
Average key length: 2.22, compression ratio: 4.05 
 
Average prefix length: 8.81, average data length: 0.19 
 
Clustering factor: 834712, ratio: 0.07 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 3 
 
40 - 59% = 11506 
 
60 - 79% = 1911 
 
80 - 99% = 1488 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 14600, nodes: 12063046 
 
Average node length: 5.57, total dup: 12038015, max dup: 1744480 
 
Average key length: 2.07, compression ratio: 18.32 
 
Average prefix length: 37.81, average data length: 0.07 
 
Clustering factor: 6020506, ratio: 0.50 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 1 
 
40 - 59% = 12532 
 
60 - 79% = 490 
 
80 - 99% = 1560 
 
 
PHRASES (145) 
 
Primary pointer page: 266, Index root page: 267 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 55.17, total records: 452486 
 
Average version length: 56.05, total versions: 482, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.45 
 
Pointer pages: 4, data page slots: 5400 
 
Data pages: 5400, average fill: 74% 
 
Primary pages: 5400, secondary pages: 0, swept pages: 3604 
 
Empty pages: 0, full pages: 4984 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 11 
 
40 - 59% = 43 
 
60 - 79% = 5341 
 
80 - 99% = 0 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 657475, depth: 3, leaf buckets: 586, nodes: 452486 
 
Average node length: 5.90, total dup: 383719, max dup: 657 
 
Average key length: 3.11, compression ratio: 2.90 
 
Average prefix length: 8.05, average data length: 0.95 
 
Clustering factor: 57201, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 42 
 
40 - 59% = 340 
 
60 - 79% = 138 
 
80 - 99% = 61 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 486, nodes: 452486 
 
Average node length: 5.60, total dup: 403399, max dup: 111 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 111736, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 7 
 
40 - 59% = 212 
 
60 - 79% = 185 
 
80 - 99% = 82 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 338.00, compression ratio: 9.87 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 3% 
 
Primary pages: 1, secondary pages: 0, swept pages: 1 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.31, total records: 114 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1347.00, compression ratio: 13.70 
 
Pointer pages: 1, data page slots: 2 
 
Data pages: 2, average fill: 80% 
 
Primary pages: 2, secondary pages: 0, swept pages: 2 
 
Empty pages: 0, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index SETTINGS_MODE_CODE (0) 
 
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.11, total dup: 0, max dup: 0 
 
Average key length: 26.10, compression ratio: 1.70 
 
Average prefix length: 21.18, average data length: 23.11 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (162) 
 
Primary pointer page: 347, Index root page: 348 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.47, total records: 2396 
 
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.54 
 
Pointer pages: 1, data page slots: 32 
 
Data pages: 32, average fill: 68% 
 
Primary pages: 32, secondary pages: 0, swept pages: 0 
 
Empty pages: 3, full pages: 28 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 29 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 264, Index root page: 265 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.23, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.73 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 78% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 67 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.86, total dup: 0, max dup: 0 
 
Average key length: 51.84, compression ratio: 1.00 
 
Average prefix length: 2.73, average data length: 48.86 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (260) 
 
Primary pointer page: 292, Index root page: 295 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.53, total records: 4873 
 
Average version length: 72.05, total versions: 112, 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: 2, data page slots: 768 
 
Data pages: 304, average fill: 19% 
 
Primary pages: 303, secondary pages: 1, swept pages: 269 
 
Empty pages: 120, full pages: 29 
 
Fill distribution: 
 
0 - 19% = 210 
 
20 - 39% = 41 
 
40 - 59% = 15 
 
60 - 79% = 37 
 
80 - 99% = 1 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 14, nodes: 4873 
 
Average node length: 7.50, total dup: 4241, max dup: 14 
 
Average key length: 4.74, compression ratio: 7.81 
 
Average prefix length: 34.39, average data length: 2.61 
 
Clustering factor: 789, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 9 
 
40 - 59% = 3 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 72.03, total records: 954074 
 
Average version length: 72.05, total versions: 1912, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.89 
 
Pointer pages: 9, data page slots: 14592 
 
Data pages: 14576, average fill: 72% 
 
Primary pages: 14576, secondary pages: 0, swept pages: 9493 
 
Empty pages: 119, full pages: 11061 
 
Fill distribution: 
 
0 - 19% = 235 
 
20 - 39% = 308 
 
40 - 59% = 956 
 
60 - 79% = 13054 
 
80 - 99% = 23 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 563032, depth: 3, leaf buckets: 1080, nodes: 954074 
 
Average node length: 5.11, total dup: 928937, max dup: 120 
 
Average key length: 2.19, compression ratio: 4.10 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 109347, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 87 
 
40 - 59% = 776 
 
60 - 79% = 45 
 
80 - 99% = 163 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 256818, depth: 3, leaf buckets: 1337, nodes: 954074 
 
Average node length: 6.23, total dup: 833223, max dup: 17 
 
Average key length: 3.31, compression ratio: 11.17 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 185554, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 28 
 
20 - 39% = 138 
 
40 - 59% = 872 
 
60 - 79% = 147 
 
80 - 99% = 152 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 62.70, total records: 9228 
 
Average version length: 72.10, total versions: 1198, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.17 
 
Pointer pages: 3, data page slots: 4168 
 
Data pages: 776, average fill: 14% 
 
Primary pages: 776, secondary pages: 0, swept pages: 481 
 
Empty pages: 439, full pages: 33 
 
Fill distribution: 
 
0 - 19% = 601 
 
20 - 39% = 57 
 
40 - 59% = 35 
 
60 - 79% = 78 
 
80 - 99% = 5 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 22, nodes: 9228 
 
Average node length: 6.80, total dup: 8323, max dup: 45 
 
Average key length: 3.88, compression ratio: 9.53 
 
Average prefix length: 35.21, average data length: 1.79 
 
Clustering factor: 1144, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 15 
 
40 - 59% = 6 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.74, total records: 1649578 
 
Average version length: 71.46, total versions: 33091, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.92 
 
Pointer pages: 17, data page slots: 26192 
 
Data pages: 26136, average fill: 70% 
 
Primary pages: 26135, secondary pages: 1, swept pages: 13163 
 
Empty pages: 641, full pages: 19421 
 
Fill distribution: 
 
0 - 19% = 1118 
 
20 - 39% = 1173 
 
40 - 59% = 2154 
 
60 - 79% = 21112 
 
80 - 99% = 579 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 170435, depth: 3, leaf buckets: 2651, nodes: 1649578 
 
Average node length: 5.64, total dup: 1546601, max dup: 49 
 
Average key length: 2.68, compression ratio: 13.80 
 
Average prefix length: 36.38, average data length: 0.62 
 
Clustering factor: 186572, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 1348 
 
40 - 59% = 957 
 
60 - 79% = 153 
 
80 - 99% = 177 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 66.43, total records: 473 
 
Average version length: 72.12, total versions: 33, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.05 
 
Pointer pages: 3, data page slots: 992 
 
Data pages: 280, average fill: 3% 
 
Primary pages: 280, secondary pages: 0, swept pages: 233 
 
Empty pages: 197, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 277 
 
20 - 39% = 3 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 3, nodes: 473 
 
Average node length: 11.97, total dup: 337, max dup: 15 
 
Average key length: 9.25, compression ratio: 4.00 
 
Average prefix length: 30.03, average data length: 6.97 
 
Clustering factor: 117, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 2 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.22, total records: 2697612 
 
Average version length: 71.23, total versions: 9825, 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: 24, data page slots: 38520 
 
Data pages: 38520, average fill: 76% 
 
Primary pages: 38520, secondary pages: 0, swept pages: 28197 
 
Empty pages: 31, full pages: 34797 
 
Fill distribution: 
 
0 - 19% = 71 
 
20 - 39% = 129 
 
40 - 59% = 748 
 
60 - 79% = 37312 
 
80 - 99% = 260 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5558, nodes: 2697612 
 
Average node length: 6.86, total dup: 2185192, max dup: 17 
 
Average key length: 3.89, compression ratio: 9.51 
 
Average prefix length: 35.30, average data length: 1.70 
 
Clustering factor: 464777, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 2939 
 
40 - 59% = 2140 
 
60 - 79% = 277 
 
80 - 99% = 195 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.65, total records: 4643447 
 
Average version length: 84.70, total versions: 938, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 44, data page slots: 71296 
 
Data pages: 71296, average fill: 80% 
 
Primary pages: 71296, secondary pages: 0, swept pages: 25756 
 
Empty pages: 5, full pages: 71107 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 2 
 
40 - 59% = 15 
 
60 - 79% = 20474 
 
80 - 99% = 50798 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4784, nodes: 4643447 
 
Average node length: 5.15, total dup: 4537489, max dup: 127 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 724060, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 28 
 
20 - 39% = 80 
 
40 - 59% = 2175 
 
60 - 79% = 1996 
 
80 - 99% = 505 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 4699, nodes: 4643447 
 
Average node length: 5.70, total dup: 4153890, max dup: 49 
 
Average key length: 2.72, compression ratio: 3.31 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 203607, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 36 
 
20 - 39% = 119 
 
40 - 59% = 2135 
 
60 - 79% = 329 
 
80 - 99% = 2080 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5298, nodes: 4643447 
 
Average node length: 5.81, total dup: 4062752, max dup: 28 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 778701, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 24 
 
20 - 39% = 88 
 
40 - 59% = 2335 
 
60 - 79% = 2107 
 
80 - 99% = 744 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.11, total records: 2555256 
 
Average version length: 83.75, total versions: 8089, 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: 25, data page slots: 40384 
 
Data pages: 40384, average fill: 78% 
 
Primary pages: 40384, secondary pages: 0, swept pages: 30373 
 
Empty pages: 60, full pages: 36897 
 
Fill distribution: 
 
0 - 19% = 125 
 
20 - 39% = 194 
 
40 - 59% = 773 
 
60 - 79% = 16830 
 
80 - 99% = 22462 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2726, nodes: 2555256 
 
Average node length: 5.15, total dup: 2495645, max dup: 165 
 
Average key length: 2.18, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 393234, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 60 
 
40 - 59% = 1583 
 
60 - 79% = 805 
 
80 - 99% = 277 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4171, nodes: 2555256 
 
Average node length: 6.23, total dup: 2092663, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 219598, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 96 
 
20 - 39% = 1542 
 
40 - 59% = 1613 
 
60 - 79% = 587 
 
80 - 99% = 333 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 3141, nodes: 2555256 
 
Average node length: 5.81, total dup: 2234996, max dup: 30 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 478711, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 69 
 
40 - 59% = 1934 
 
60 - 79% = 820 
 
80 - 99% = 295 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.71, total records: 4930634 
 
Average version length: 84.93, total versions: 5617, 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: 48, data page slots: 77784 
 
Data pages: 77624, average fill: 78% 
 
Primary pages: 77624, secondary pages: 0, swept pages: 20127 
 
Empty pages: 608, full pages: 72331 
 
Fill distribution: 
 
0 - 19% = 876 
 
20 - 39% = 725 
 
40 - 59% = 1620 
 
60 - 79% = 14029 
 
80 - 99% = 60374 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5131, nodes: 4930634 
 
Average node length: 5.04, total dup: 4901547, max dup: 647 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 696490, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 175 
 
40 - 59% = 2887 
 
60 - 79% = 1458 
 
80 - 99% = 605 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 5741, nodes: 4930634 
 
Average node length: 5.53, total dup: 4538541, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.54 
 
Average prefix length: 8.53, average data length: 0.47 
 
Clustering factor: 208789, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 85 
 
20 - 39% = 1178 
 
40 - 59% = 2448 
 
60 - 79% = 611 
 
80 - 99% = 1419 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5756, nodes: 4930634 
 
Average node length: 5.69, total dup: 4420724, max dup: 69 
 
Average key length: 2.70, compression ratio: 3.33 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 776813, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 160 
 
40 - 59% = 3265 
 
60 - 79% = 1585 
 
80 - 99% = 742 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (270) 
 
Primary pointer page: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.37, total records: 3314123 
 
Average version length: 83.70, total versions: 6033, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.63 
 
Pointer pages: 33, data page slots: 52328 
 
Data pages: 52320, average fill: 78% 
 
Primary pages: 52320, secondary pages: 0, swept pages: 38804 
 
Empty pages: 55, full pages: 47622 
 
Fill distribution: 
 
0 - 19% = 109 
 
20 - 39% = 237 
 
40 - 59% = 1065 
 
60 - 79% = 20034 
 
80 - 99% = 30875 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3621, nodes: 3314123 
 
Average node length: 5.02, total dup: 3297946, max dup: 1197 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 649508, ratio: 0.20 
 
Fill distribution: 
 
0 - 19% = 25 
 
20 - 39% = 368 
 
40 - 59% = 1975 
 
60 - 79% = 859 
 
80 - 99% = 394 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5394, nodes: 3314123 
 
Average node length: 6.24, total dup: 2711641, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 304399, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 158 
 
20 - 39% = 1995 
 
40 - 59% = 2003 
 
60 - 79% = 732 
 
80 - 99% = 506 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4008, nodes: 3314123 
 
Average node length: 5.59, total dup: 3022342, max dup: 73 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 694004, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 426 
 
40 - 59% = 2087 
 
60 - 79% = 1045 
 
80 - 99% = 432 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.37, total records: 621399 
 
Average version length: 68.97, total versions: 1096, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.96 
 
Pointer pages: 6, data page slots: 8648 
 
Data pages: 8648, average fill: 76% 
 
Primary pages: 8648, secondary pages: 0, swept pages: 6647 
 
Empty pages: 5, full pages: 7960 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 42 
 
40 - 59% = 166 
 
60 - 79% = 8402 
 
80 - 99% = 23 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 177151, depth: 3, leaf buckets: 754, nodes: 621399 
 
Average node length: 5.32, total dup: 585037, max dup: 119 
 
Average key length: 2.44, compression ratio: 3.68 
 
Average prefix length: 8.61, average data length: 0.39 
 
Clustering factor: 52648, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 174 
 
40 - 59% = 314 
 
60 - 79% = 186 
 
80 - 99% = 79 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 837, nodes: 621399 
 
Average node length: 5.92, total dup: 530404, max dup: 24 
 
Average key length: 3.05, compression ratio: 2.95 
 
Average prefix length: 8.09, average data length: 0.91 
 
Clustering factor: 55008, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 190 
 
40 - 59% = 342 
 
60 - 79% = 221 
 
80 - 99% = 82 
 
 
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 Sat Mar 17 07:13:44 2018 
 
 
Done for 148270 ms, from  7:11:16.55 to  7:13:44.82. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2123372  | 
 2322  | 
 0.1093  | 
|  DOC_LIST  | 
 636477  | 
 987  | 
 0.1550  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 884  | 
 12  | 
 1.3574  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 391  | 
 314  | 
 80.3069  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 212831  | 
 846  | 
 0.3974  | 
|  PERF_ESTIMATED  | 
 264652  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 12063046  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 452486  | 
 482  | 
 0.1065  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 0  | 
 0.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2396  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 4873  | 
 112  | 
 2.2983  | 
|  XQD_1000_3300  | 
 954074  | 
 1912  | 
 0.2004  | 
|  XQD_1200_2000  | 
 9228  | 
 1198  | 
 12.9822  | 
|  XQD_2000_3300  | 
 1649578  | 
 33091  | 
 2.0060  | 
|  XQD_2100_3300  | 
 473  | 
 33  | 
 6.9767  | 
|  XQD_3300_3400  | 
 2697612  | 
 9825  | 
 0.3642  | 
|  XQS_1000_1200  | 
 4643447  | 
 938  | 
 0.0202  | 
|  XQS_1000_3300  | 
 2555256  | 
 8089  | 
 0.3165  | 
|  XQS_1200_2000  | 
 4930634  | 
 5617  | 
 0.1139  | 
|  XQS_2100_3300  | 
 3314123  | 
 6033  | 
 0.1820  | 
|  XQS_3300_3400  | 
 621399  | 
 1096  | 
 0.1763  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 1730 ms, from  7:13:56.51 to  7:13:58.24.  
07:13:58.38 Validation started 
 
 
07:13:58.40 Relation 140 (DOC_LIST) 
 
07:13:58.40   process pointer page    0 of    5 
 
07:13:58.51   process pointer page    1 of    5 
 
07:13:58.60   process pointer page    2 of    5 
 
07:13:58.71   process pointer page    3 of    5 
 
07:13:58.82   process pointer page    4 of    5 
 
07:13:58.88 Index 1 (PK_DOC_LIST) 
 
07:13:59.08 Index 2 (DOC_LIST_ID_DESC) 
 
07:13:59.27 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:13:59.41 Relation 140 (DOC_LIST) is ok 
 
 
07:13:59.41 Relation 141 (DOC_DATA) 
 
07:13:59.41   process pointer page    0 of   15 
 
07:13:59.47   process pointer page    1 of   15 
 
07:13:59.52   process pointer page    2 of   15 
 
07:13:59.55   process pointer page    3 of   15 
 
07:13:59.63   process pointer page    4 of   15 
 
07:13:59.72   process pointer page    5 of   15 
 
07:13:59.82   process pointer page    6 of   15 
 
07:13:59.91   process pointer page    7 of   15 
 
07:14:00.00   process pointer page    8 of   15 
 
07:14:00.03   process pointer page    9 of   15 
 
07:14:00.08   process pointer page   10 of   15 
 
07:14:00.11   process pointer page   11 of   15 
 
07:14:00.14   process pointer page   12 of   15 
 
07:14:00.19   process pointer page   13 of   15 
 
07:14:00.22   process pointer page   14 of   15 
 
07:14:00.24 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:14:01.31 Index 3 (DOC_DATA_ID_DESC) 
 
07:14:02.19 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:14:02.87 Relation 141 (DOC_DATA) is ok 
 
 
07:14:02.87 Relation 147 (INVNT_SALDO) 
 
07:14:02.87   process pointer page    0 of    1 
 
07:14:02.89 Index 1 (PK_INVNT_SALDO) 
 
07:14:02.89 Relation 147 (INVNT_SALDO) is ok 
 
 
07:14:02.89 Relation 150 (PDISTR) 
 
07:14:02.89   process pointer page    0 of    2 
 
07:14:02.97   process pointer page    1 of    2 
 
07:14:02.98 Index 2 (PDISTR_SND_ID) 
 
07:14:03.01 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:14:03.05 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:14:03.06 Index 5 (PDISTR_AGENT_ID) 
 
07:14:03.09 Relation 150 (PDISTR) is ok 
 
 
07:14:03.09 Relation 151 (PSTORNED) 
 
07:14:03.09   process pointer page    0 of    4 
 
07:14:03.12   process pointer page    1 of    4 
 
07:14:03.15   process pointer page    2 of    4 
 
07:14:03.23   process pointer page    3 of    4 
 
07:14:03.25 Index 2 (PSTORNED_SND_ID) 
 
07:14:03.31 Index 3 (PSTORNED_RCV_ID) 
 
07:14:03.37 Relation 151 (PSTORNED) is ok 
 
 
07:14:03.37 Relation 156 (SEMAPHORES) 
 
07:14:03.37   process pointer page    0 of    1 
 
07:14:03.37 Index 1 (PK_SEMAPHORES) 
 
07:14:03.37 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:14:03.37 Relation 156 (SEMAPHORES) is ok 
 
 
07:14:03.37 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:14:03.37   process pointer page    0 of    1 
 
07:14:03.37 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:14:03.37 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:14:03.37 Relation 160 (PERF_ESTIMATED) 
 
07:14:03.37   process pointer page    0 of    2 
 
07:14:03.40   process pointer page    1 of    2 
 
07:14:03.42 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:14:03.45 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:14:03.45 Relation 161 (PERF_ISQL_STAT) 
 
07:14:03.45   process pointer page    0 of    1 
 
07:14:03.45 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:14:03.45 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:14:03.45 Relation 162 (TRACE_STAT) 
 
07:14:03.45   process pointer page    0 of    1 
 
07:14:03.45 Relation 162 (TRACE_STAT) is ok 
 
 
07:14:03.45 Relation 163 (PERF_LOG) 
 
07:14:03.45   process pointer page    0 of  176 
 
07:14:03.48   process pointer page    1 of  176 
 
07:14:03.51   process pointer page    2 of  176 
 
07:14:03.54   process pointer page    3 of  176 
 
07:14:03.58   process pointer page    4 of  176 
 
07:14:03.59   process pointer page    5 of  176 
 
07:14:03.65   process pointer page    6 of  176 
 
07:14:03.73   process pointer page    7 of  176 
 
07:14:03.81   process pointer page    8 of  176 
 
07:14:03.90   process pointer page    9 of  176 
 
07:14:03.98   process pointer page   10 of  176 
 
07:14:04.06   process pointer page   11 of  176 
 
07:14:04.14   process pointer page   12 of  176 
 
07:14:04.23   process pointer page   13 of  176 
 
07:14:04.31   process pointer page   14 of  176 
 
07:14:04.39   process pointer page   15 of  176 
 
07:14:04.47   process pointer page   16 of  176 
 
07:14:04.56   process pointer page   17 of  176 
 
07:14:04.64   process pointer page   18 of  176 
 
07:14:04.71   process pointer page   19 of  176 
 
07:14:04.81   process pointer page   20 of  176 
 
07:14:04.89   process pointer page   21 of  176 
 
07:14:04.96   process pointer page   22 of  176 
 
07:14:05.04   process pointer page   23 of  176 
 
07:14:05.12   process pointer page   24 of  176 
 
07:14:05.20   process pointer page   25 of  176 
 
07:14:05.28   process pointer page   26 of  176 
 
07:14:05.35   process pointer page   27 of  176 
 
07:14:05.43   process pointer page   28 of  176 
 
07:14:05.51   process pointer page   29 of  176 
 
07:14:05.59   process pointer page   30 of  176 
 
07:14:05.67   process pointer page   31 of  176 
 
07:14:05.76   process pointer page   32 of  176 
 
07:14:05.84   process pointer page   33 of  176 
 
07:14:05.92   process pointer page   34 of  176 
 
07:14:05.99   process pointer page   35 of  176 
 
07:14:06.07   process pointer page   36 of  176 
 
07:14:06.10   process pointer page   37 of  176 
 
07:14:06.13   process pointer page   38 of  176 
 
07:14:06.17   process pointer page   39 of  176 
 
07:14:06.20   process pointer page   40 of  176 
 
07:14:06.23   process pointer page   41 of  176 
 
07:14:06.26   process pointer page   42 of  176 
 
07:14:06.32   process pointer page   43 of  176 
 
07:14:06.38   process pointer page   44 of  176 
 
07:14:06.42   process pointer page   45 of  176 
 
07:14:06.49   process pointer page   46 of  176 
 
07:14:06.57   process pointer page   47 of  176 
 
07:14:06.65   process pointer page   48 of  176 
 
07:14:06.73   process pointer page   49 of  176 
 
07:14:06.76   process pointer page   50 of  176 
 
07:14:06.82   process pointer page   51 of  176 
 
07:14:06.91   process pointer page   52 of  176 
 
07:14:06.99   process pointer page   53 of  176 
 
07:14:07.07   process pointer page   54 of  176 
 
07:14:07.15   process pointer page   55 of  176 
 
07:14:07.23   process pointer page   56 of  176 
 
07:14:07.30   process pointer page   57 of  176 
 
07:14:07.38   process pointer page   58 of  176 
 
07:14:07.48   process pointer page   59 of  176 
 
07:14:07.51   process pointer page   60 of  176 
 
07:14:07.54   process pointer page   61 of  176 
 
07:14:07.57   process pointer page   62 of  176 
 
07:14:07.60   process pointer page   63 of  176 
 
07:14:07.63   process pointer page   64 of  176 
 
07:14:07.66   process pointer page   65 of  176 
 
07:14:07.69   process pointer page   66 of  176 
 
07:14:07.71   process pointer page   67 of  176 
 
07:14:07.74   process pointer page   68 of  176 
 
07:14:07.77   process pointer page   69 of  176 
 
07:14:07.80   process pointer page   70 of  176 
 
07:14:07.83   process pointer page   71 of  176 
 
07:14:07.87   process pointer page   72 of  176 
 
07:14:07.90   process pointer page   73 of  176 
 
07:14:07.91   process pointer page   74 of  176 
 
07:14:07.94   process pointer page   75 of  176 
 
07:14:07.99   process pointer page   76 of  176 
 
07:14:08.02   process pointer page   77 of  176 
 
07:14:08.05   process pointer page   78 of  176 
 
07:14:08.07   process pointer page   79 of  176 
 
07:14:08.10   process pointer page   80 of  176 
 
07:14:08.13   process pointer page   81 of  176 
 
07:14:08.15   process pointer page   82 of  176 
 
07:14:08.18   process pointer page   83 of  176 
 
07:14:08.21   process pointer page   84 of  176 
 
07:14:08.24   process pointer page   85 of  176 
 
07:14:08.27   process pointer page   86 of  176 
 
07:14:08.35   process pointer page   87 of  176 
 
07:14:08.44   process pointer page   88 of  176 
 
07:14:08.49   process pointer page   89 of  176 
 
07:14:08.52   process pointer page   90 of  176 
 
07:14:08.60   process pointer page   91 of  176 
 
07:14:08.69   process pointer page   92 of  176 
 
07:14:08.77   process pointer page   93 of  176 
 
07:14:08.85   process pointer page   94 of  176 
 
07:14:08.93   process pointer page   95 of  176 
 
07:14:09.00   process pointer page   96 of  176 
 
07:14:09.08   process pointer page   97 of  176 
 
07:14:09.16   process pointer page   98 of  176 
 
07:14:09.22   process pointer page   99 of  176 
 
07:14:09.25   process pointer page  100 of  176 
 
07:14:09.30   process pointer page  101 of  176 
 
07:14:09.33   process pointer page  102 of  176 
 
07:14:09.36   process pointer page  103 of  176 
 
07:14:09.38   process pointer page  104 of  176 
 
07:14:09.41   process pointer page  105 of  176 
 
07:14:09.44   process pointer page  106 of  176 
 
07:14:09.47   process pointer page  107 of  176 
 
07:14:09.49   process pointer page  108 of  176 
 
07:14:09.52   process pointer page  109 of  176 
 
07:14:09.55   process pointer page  110 of  176 
 
07:14:09.63   process pointer page  111 of  176 
 
07:14:09.71   process pointer page  112 of  176 
 
07:14:09.78   process pointer page  113 of  176 
 
07:14:09.86   process pointer page  114 of  176 
 
07:14:09.96   process pointer page  115 of  176 
 
07:14:10.03   process pointer page  116 of  176 
 
07:14:10.11   process pointer page  117 of  176 
 
07:14:10.19   process pointer page  118 of  176 
 
07:14:10.28   process pointer page  119 of  176 
 
07:14:10.36   process pointer page  120 of  176 
 
07:14:10.44   process pointer page  121 of  176 
 
07:14:10.52   process pointer page  122 of  176 
 
07:14:10.60   process pointer page  123 of  176 
 
07:14:10.67   process pointer page  124 of  176 
 
07:14:10.75   process pointer page  125 of  176 
 
07:14:10.85   process pointer page  126 of  176 
 
07:14:10.92   process pointer page  127 of  176 
 
07:14:11.00   process pointer page  128 of  176 
 
07:14:11.08   process pointer page  129 of  176 
 
07:14:11.16   process pointer page  130 of  176 
 
07:14:11.25   process pointer page  131 of  176 
 
07:14:11.33   process pointer page  132 of  176 
 
07:14:11.38   process pointer page  133 of  176 
 
07:14:11.42   process pointer page  134 of  176 
 
07:14:11.45   process pointer page  135 of  176 
 
07:14:11.50   process pointer page  136 of  176 
 
07:14:11.59   process pointer page  137 of  176 
 
07:14:11.67   process pointer page  138 of  176 
 
07:14:11.75   process pointer page  139 of  176 
 
07:14:11.83   process pointer page  140 of  176 
 
07:14:11.91   process pointer page  141 of  176 
 
07:14:12.00   process pointer page  142 of  176 
 
07:14:12.08   process pointer page  143 of  176 
 
07:14:12.16   process pointer page  144 of  176 
 
07:14:12.23   process pointer page  145 of  176 
 
07:14:12.31   process pointer page  146 of  176 
 
07:14:12.39   process pointer page  147 of  176 
 
07:14:12.48   process pointer page  148 of  176 
 
07:14:12.56   process pointer page  149 of  176 
 
07:14:12.64   process pointer page  150 of  176 
 
07:14:12.72   process pointer page  151 of  176 
 
07:14:12.80   process pointer page  152 of  176 
 
07:14:12.87   process pointer page  153 of  176 
 
07:14:12.97   process pointer page  154 of  176 
 
07:14:13.05   process pointer page  155 of  176 
 
07:14:13.12   process pointer page  156 of  176 
 
07:14:13.20   process pointer page  157 of  176 
 
07:14:13.28   process pointer page  158 of  176 
 
07:14:13.36   process pointer page  159 of  176 
 
07:14:13.44   process pointer page  160 of  176 
 
07:14:13.51   process pointer page  161 of  176 
 
07:14:13.58   process pointer page  162 of  176 
 
07:14:13.61   process pointer page  163 of  176 
 
07:14:13.68   process pointer page  164 of  176 
 
07:14:13.76   process pointer page  165 of  176 
 
07:14:13.79   process pointer page  166 of  176 
 
07:14:13.84   process pointer page  167 of  176 
 
07:14:13.92   process pointer page  168 of  176 
 
07:14:14.01   process pointer page  169 of  176 
 
07:14:14.09   process pointer page  170 of  176 
 
07:14:14.17   process pointer page  171 of  176 
 
07:14:14.25   process pointer page  172 of  176 
 
07:14:14.32   process pointer page  173 of  176 
 
07:14:14.40   process pointer page  174 of  176 
 
07:14:14.50   process pointer page  175 of  176 
 
07:14:14.51 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:14:17.77 Index 2 (PERF_LOG_UNIT) 
 
07:14:21.75 Index 3 (PERF_LOG_TRN_DESC) 
 
07:14:24.99 Index 4 (PERF_LOG_GDSCODE) 
 
07:14:27.15 Relation 163 (PERF_LOG) is ok 
 
 
07:14:27.15 Relation 167 (V_STOPTEST) 
 
07:14:27.15 Relation 167 (V_STOPTEST) is ok 
 
 
07:14:27.15 Relation 184 (V_QDISTR_SOURCE) 
 
07:14:27.15 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:14:27.15 Relation 185 (V_QSTORNED_SOURCE) 
 
07:14:27.15 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:14:27.15 Relation 260 (XQD_1000_1200) 
 
07:14:27.16   process pointer page    0 of    2 
 
07:14:27.16   process pointer page    1 of    2 
 
07:14:27.16 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:14:27.16 Relation 260 (XQD_1000_1200) is ok 
 
 
07:14:27.16 Relation 261 (XQD_1200_2000) 
 
07:14:27.16   process pointer page    0 of    3 
 
07:14:27.16   process pointer page    1 of    3 
 
07:14:27.18   process pointer page    2 of    3 
 
07:14:27.18 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:14:27.18 Relation 261 (XQD_1200_2000) is ok 
 
 
07:14:27.18 Relation 262 (XQD_1000_3300) 
 
07:14:27.18   process pointer page    0 of    9 
 
07:14:27.21   process pointer page    1 of    9 
 
07:14:27.29   process pointer page    2 of    9 
 
07:14:27.37   process pointer page    3 of    9 
 
07:14:27.46   process pointer page    4 of    9 
 
07:14:27.54   process pointer page    5 of    9 
 
07:14:27.62   process pointer page    6 of    9 
 
07:14:27.71   process pointer page    7 of    9 
 
07:14:27.74   process pointer page    8 of    9 
 
07:14:27.79 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:14:28.15 Index 2 (XQD_1000_3300_DOC) 
 
07:14:28.35 Relation 262 (XQD_1000_3300) is ok 
 
 
07:14:28.35 Relation 263 (XQD_2000_3300) 
 
07:14:28.35   process pointer page    0 of   17 
 
07:14:28.40   process pointer page    1 of   17 
 
07:14:28.44   process pointer page    2 of   17 
 
07:14:28.54   process pointer page    3 of   17 
 
07:14:28.63   process pointer page    4 of   17 
 
07:14:28.71   process pointer page    5 of   17 
 
07:14:28.80   process pointer page    6 of   17 
 
07:14:28.88   process pointer page    7 of   17 
 
07:14:28.97   process pointer page    8 of   17 
 
07:14:29.05   process pointer page    9 of   17 
 
07:14:29.13   process pointer page   10 of   17 
 
07:14:29.22   process pointer page   11 of   17 
 
07:14:29.30   process pointer page   12 of   17 
 
07:14:29.36   process pointer page   13 of   17 
 
07:14:29.39   process pointer page   14 of   17 
 
07:14:29.44   process pointer page   15 of   17 
 
07:14:29.47   process pointer page   16 of   17 
 
07:14:29.47 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:14:29.67 Relation 263 (XQD_2000_3300) is ok 
 
 
07:14:29.67 Relation 264 (XQD_2100_3300) 
 
07:14:29.67   process pointer page    0 of    3 
 
07:14:29.67   process pointer page    1 of    3 
 
07:14:29.67   process pointer page    2 of    3 
 
07:14:29.67 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:14:29.67 Relation 264 (XQD_2100_3300) is ok 
 
 
07:14:29.67 Relation 265 (XQD_3300_3400) 
 
07:14:29.67   process pointer page    0 of   24 
 
07:14:29.71   process pointer page    1 of   24 
 
07:14:29.74   process pointer page    2 of   24 
 
07:14:29.77   process pointer page    3 of   24 
 
07:14:29.80   process pointer page    4 of   24 
 
07:14:29.83   process pointer page    5 of   24 
 
07:14:29.88   process pointer page    6 of   24 
 
07:14:29.89   process pointer page    7 of   24 
 
07:14:29.92   process pointer page    8 of   24 
 
07:14:29.96   process pointer page    9 of   24 
 
07:14:29.99   process pointer page   10 of   24 
 
07:14:30.02   process pointer page   11 of   24 
 
07:14:30.03   process pointer page   12 of   24 
 
07:14:30.06   process pointer page   13 of   24 
 
07:14:30.10   process pointer page   14 of   24 
 
07:14:30.13   process pointer page   15 of   24 
 
07:14:30.17   process pointer page   16 of   24 
 
07:14:30.27   process pointer page   17 of   24 
 
07:14:30.35   process pointer page   18 of   24 
 
07:14:30.44   process pointer page   19 of   24 
 
07:14:30.53   process pointer page   20 of   24 
 
07:14:30.61   process pointer page   21 of   24 
 
07:14:30.70   process pointer page   22 of   24 
 
07:14:30.74   process pointer page   23 of   24 
 
07:14:30.77 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:14:31.44 Relation 265 (XQD_3300_3400) is ok 
 
 
07:14:31.44 Relation 266 (XQS_1000_1200) 
 
07:14:31.44   process pointer page    0 of   44 
 
07:14:31.50   process pointer page    1 of   44 
 
07:14:31.56   process pointer page    2 of   44 
 
07:14:31.59   process pointer page    3 of   44 
 
07:14:31.62   process pointer page    4 of   44 
 
07:14:31.67   process pointer page    5 of   44 
 
07:14:31.77   process pointer page    6 of   44 
 
07:14:31.84   process pointer page    7 of   44 
 
07:14:31.94   process pointer page    8 of   44 
 
07:14:32.03   process pointer page    9 of   44 
 
07:14:32.11   process pointer page   10 of   44 
 
07:14:32.20   process pointer page   11 of   44 
 
07:14:32.28   process pointer page   12 of   44 
 
07:14:32.34   process pointer page   13 of   44 
 
07:14:32.37   process pointer page   14 of   44 
 
07:14:32.40   process pointer page   15 of   44 
 
07:14:32.44   process pointer page   16 of   44 
 
07:14:32.50   process pointer page   17 of   44 
 
07:14:32.58   process pointer page   18 of   44 
 
07:14:32.61   process pointer page   19 of   44 
 
07:14:32.69   process pointer page   20 of   44 
 
07:14:32.78   process pointer page   21 of   44 
 
07:14:32.86   process pointer page   22 of   44 
 
07:14:32.90   process pointer page   23 of   44 
 
07:14:32.97   process pointer page   24 of   44 
 
07:14:33.04   process pointer page   25 of   44 
 
07:14:33.14   process pointer page   26 of   44 
 
07:14:33.22   process pointer page   27 of   44 
 
07:14:33.31   process pointer page   28 of   44 
 
07:14:33.39   process pointer page   29 of   44 
 
07:14:33.48   process pointer page   30 of   44 
 
07:14:33.56   process pointer page   31 of   44 
 
07:14:33.65   process pointer page   32 of   44 
 
07:14:33.73   process pointer page   33 of   44 
 
07:14:33.82   process pointer page   34 of   44 
 
07:14:33.90   process pointer page   35 of   44 
 
07:14:34.00   process pointer page   36 of   44 
 
07:14:34.04   process pointer page   37 of   44 
 
07:14:34.07   process pointer page   38 of   44 
 
07:14:34.11   process pointer page   39 of   44 
 
07:14:34.15   process pointer page   40 of   44 
 
07:14:34.21   process pointer page   41 of   44 
 
07:14:34.29   process pointer page   42 of   44 
 
07:14:34.37   process pointer page   43 of   44 
 
07:14:34.40 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:14:35.60 Index 2 (XQS_1000_1200_SND_ID) 
 
07:14:36.69 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:14:37.46 Relation 266 (XQS_1000_1200) is ok 
 
 
07:14:37.46 Relation 267 (XQS_1200_2000) 
 
07:14:37.47   process pointer page    0 of   48 
 
07:14:37.55   process pointer page    1 of   48 
 
07:14:37.65   process pointer page    2 of   48 
 
07:14:37.72   process pointer page    3 of   48 
 
07:14:37.82   process pointer page    4 of   48 
 
07:14:37.91   process pointer page    5 of   48 
 
07:14:38.01   process pointer page    6 of   48 
 
07:14:38.04   process pointer page    7 of   48 
 
07:14:38.08   process pointer page    8 of   48 
 
07:14:38.11   process pointer page    9 of   48 
 
07:14:38.21   process pointer page   10 of   48 
 
07:14:38.30   process pointer page   11 of   48 
 
07:14:38.38   process pointer page   12 of   48 
 
07:14:38.47   process pointer page   13 of   48 
 
07:14:38.57   process pointer page   14 of   48 
 
07:14:38.64   process pointer page   15 of   48 
 
07:14:38.74   process pointer page   16 of   48 
 
07:14:38.83   process pointer page   17 of   48 
 
07:14:38.91   process pointer page   18 of   48 
 
07:14:39.00   process pointer page   19 of   48 
 
07:14:39.05   process pointer page   20 of   48 
 
07:14:39.08   process pointer page   21 of   48 
 
07:14:39.13   process pointer page   22 of   48 
 
07:14:39.21   process pointer page   23 of   48 
 
07:14:39.30   process pointer page   24 of   48 
 
07:14:39.39   process pointer page   25 of   48 
 
07:14:39.47   process pointer page   26 of   48 
 
07:14:39.57   process pointer page   27 of   48 
 
07:14:39.63   process pointer page   28 of   48 
 
07:14:39.66   process pointer page   29 of   48 
 
07:14:39.71   process pointer page   30 of   48 
 
07:14:39.74   process pointer page   31 of   48 
 
07:14:39.78   process pointer page   32 of   48 
 
07:14:39.86   process pointer page   33 of   48 
 
07:14:39.96   process pointer page   34 of   48 
 
07:14:40.05   process pointer page   35 of   48 
 
07:14:40.08   process pointer page   36 of   48 
 
07:14:40.13   process pointer page   37 of   48 
 
07:14:40.16   process pointer page   38 of   48 
 
07:14:40.19   process pointer page   39 of   48 
 
07:14:40.22   process pointer page   40 of   48 
 
07:14:40.25   process pointer page   41 of   48 
 
07:14:40.28   process pointer page   42 of   48 
 
07:14:40.31   process pointer page   43 of   48 
 
07:14:40.35   process pointer page   44 of   48 
 
07:14:40.38   process pointer page   45 of   48 
 
07:14:40.39   process pointer page   46 of   48 
 
07:14:40.42   process pointer page   47 of   48 
 
07:14:40.44 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:14:40.88 Index 2 (XQS_1200_2000_SND_ID) 
 
07:14:42.23 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:14:43.31 Relation 267 (XQS_1200_2000) is ok 
 
 
07:14:43.31 Relation 268 (XQS_1000_3300) 
 
07:14:43.31   process pointer page    0 of   25 
 
07:14:43.39   process pointer page    1 of   25 
 
07:14:43.48   process pointer page    2 of   25 
 
07:14:43.56   process pointer page    3 of   25 
 
07:14:43.65   process pointer page    4 of   25 
 
07:14:43.75   process pointer page    5 of   25 
 
07:14:43.82   process pointer page    6 of   25 
 
07:14:43.92   process pointer page    7 of   25 
 
07:14:44.00   process pointer page    8 of   25 
 
07:14:44.09   process pointer page    9 of   25 
 
07:14:44.17   process pointer page   10 of   25 
 
07:14:44.26   process pointer page   11 of   25 
 
07:14:44.34   process pointer page   12 of   25 
 
07:14:44.43   process pointer page   13 of   25 
 
07:14:44.51   process pointer page   14 of   25 
 
07:14:44.57   process pointer page   15 of   25 
 
07:14:44.62   process pointer page   16 of   25 
 
07:14:44.65   process pointer page   17 of   25 
 
07:14:44.71   process pointer page   18 of   25 
 
07:14:44.79   process pointer page   19 of   25 
 
07:14:44.88   process pointer page   20 of   25 
 
07:14:44.96   process pointer page   21 of   25 
 
07:14:45.06   process pointer page   22 of   25 
 
07:14:45.13   process pointer page   23 of   25 
 
07:14:45.21   process pointer page   24 of   25 
 
07:14:45.29 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:14:45.79 Index 2 (XQS_1000_3300_SND_ID) 
 
07:14:46.57 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:14:47.22 Relation 268 (XQS_1000_3300) is ok 
 
 
07:14:47.22 Relation 269 (XQS_2000_3300) 
 
07:14:47.22   process pointer page    0 of    1 
 
07:14:47.22 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:14:47.24 Index 2 (XQS_2000_3300_SND_ID) 
 
07:14:47.24 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:14:47.24 Relation 269 (XQS_2000_3300) is ok 
 
 
07:14:47.24 Relation 270 (XQS_2100_3300) 
 
07:14:47.24   process pointer page    0 of   33 
 
07:14:47.32   process pointer page    1 of   33 
 
07:14:47.41   process pointer page    2 of   33 
 
07:14:47.49   process pointer page    3 of   33 
 
07:14:47.58   process pointer page    4 of   33 
 
07:14:47.66   process pointer page    5 of   33 
 
07:14:47.76   process pointer page    6 of   33 
 
07:14:47.83   process pointer page    7 of   33 
 
07:14:47.93   process pointer page    8 of   33 
 
07:14:47.96   process pointer page    9 of   33 
 
07:14:48.04   process pointer page   10 of   33 
 
07:14:48.11   process pointer page   11 of   33 
 
07:14:48.21   process pointer page   12 of   33 
 
07:14:48.29   process pointer page   13 of   33 
 
07:14:48.38   process pointer page   14 of   33 
 
07:14:48.47   process pointer page   15 of   33 
 
07:14:48.55   process pointer page   16 of   33 
 
07:14:48.64   process pointer page   17 of   33 
 
07:14:48.72   process pointer page   18 of   33 
 
07:14:48.82   process pointer page   19 of   33 
 
07:14:48.93   process pointer page   20 of   33 
 
07:14:49.02   process pointer page   21 of   33 
 
07:14:49.13   process pointer page   22 of   33 
 
07:14:49.22   process pointer page   23 of   33 
 
07:14:49.28   process pointer page   24 of   33 
 
07:14:49.33   process pointer page   25 of   33 
 
07:14:49.36   process pointer page   26 of   33 
 
07:14:49.41   process pointer page   27 of   33 
 
07:14:49.44   process pointer page   28 of   33 
 
07:14:49.50   process pointer page   29 of   33 
 
07:14:49.55   process pointer page   30 of   33 
 
07:14:49.63   process pointer page   31 of   33 
 
07:14:49.75   process pointer page   32 of   33 
 
07:14:49.77 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:14:50.95 Index 2 (XQS_2100_3300_SND_ID) 
 
07:14:51.42 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:14:52.03 Relation 270 (XQS_2100_3300) is ok 
 
 
07:14:52.03 Relation 271 (XQS_3300_3400) 
 
07:14:52.03   process pointer page    0 of    6 
 
07:14:52.11   process pointer page    1 of    6 
 
07:14:52.19   process pointer page    2 of    6 
 
07:14:52.26   process pointer page    3 of    6 
 
07:14:52.34   process pointer page    4 of    6 
 
07:14:52.42   process pointer page    5 of    6 
 
07:14:52.44 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:14:52.62 Index 2 (XQS_3300_3400_SND_ID) 
 
07:14:52.78 Relation 271 (XQS_3300_3400) is ok 
 
 
07:14:52.78 Validation finished 
 
Done for 54510 ms, from  7:13:58.27 to  7:14:52.78. 
 
 Differences between old and current firebird.log 
7:14:53.96. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2018-03-17  07:14               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 Sat Mar 17 07:13:58 2018 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Sat Mar 17 07:14:52 2018 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 401 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2018-03-17  7:15:01.25 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html