|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 5966.99  | 
 5226  | 
 1074058  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  customer order: creation  | 
 469.91  | 
 558  | 
 84583  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  customer order: refuse  | 
 38.12  | 
 293  | 
 6862  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  order to supplier: creation  | 
 119.84  | 
 2522  | 
 21571  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  order to supplier: removal  | 
 3.03  | 
 32870  | 
 545  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  invoice (draft): creation  | 
 120.25  | 
 3880  | 
 21645  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  invoice (draft): removal  | 
 41.75  | 
 795  | 
 7515  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  invoice accept: apply  | 
 68.44  | 
 19225  | 
 12320  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  invoice accept: cancel  | 
 18.07  | 
 4215  | 
 3235  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  customer reserve: creation  | 
 3465.94  | 
 324  | 
 623869  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  customer reserve: removal  | 
 983.95  | 
 109  | 
 177111  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  realization accept: apply  | 
 214.77  | 
 727  | 
 38658  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  realization accept: cancel  | 
 85.53  | 
 213  | 
 15395  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  payment from customer: creation  | 
 156.58  | 
 1155  | 
 28185  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  payment from customer: removal  | 
 15.09  | 
 146  | 
 2701  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  payment to supplier: creation  | 
 129.21  | 
 1265  | 
 23257  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  payment to supplier: removal  | 
 8.87  | 
 150  | 
 1588  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  service: total inventory turnovers  | 
 6.34  | 
 6490  | 
 1142  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  service: total monetary turnovers  | 
 21.47  | 
 64  | 
 3864  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 24295  | 
 12  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
 
Done for 61620 ms, from  6:49:06.70 to  6:50:08.32.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 5227  | 
 109059  | 
 94081  | 
 14978  | 
 13.73  | 
 03:46:50  | 
 04:04:50  | 
|  interval #   2, overall  | 
 2  | 
 5493  | 
 106533  | 
 98876  | 
 7657  | 
 7.19  | 
 04:04:51  | 
 04:22:51  | 
|  interval #   3, overall  | 
 3  | 
 5871  | 
 116950  | 
 105673  | 
 11277  | 
 9.64  | 
 04:22:52  | 
 04:40:52  | 
|  interval #   4, overall  | 
 4  | 
 6221  | 
 124595  | 
 111975  | 
 12620  | 
 10.13  | 
 04:40:53  | 
 04:58:53  | 
|  interval #   5, overall  | 
 5  | 
 5570  | 
 112492  | 
 100255  | 
 12237  | 
 10.88  | 
 04:58:54  | 
 05:16:54  | 
|  interval #   6, overall  | 
 6  | 
 6292  | 
 120808  | 
 113263  | 
 7545  | 
 6.25  | 
 05:16:55  | 
 05:34:55  | 
|  interval #   7, overall  | 
 7  | 
 6188  | 
 127556  | 
 111387  | 
 16169  | 
 12.68  | 
 05:34:56  | 
 05:52:56  | 
|  interval #   8, overall  | 
 8  | 
 6090  | 
 125785  | 
 109614  | 
 16171  | 
 12.86  | 
 05:52:57  | 
 06:10:57  | 
|  interval #   9, overall  | 
 9  | 
 6669  | 
 128870  | 
 120046  | 
 8824  | 
 6.85  | 
 06:10:58  | 
 06:28:58  | 
|  interval #  10, overall  | 
 10  | 
 6049  | 
 124077  | 
 108888  | 
 15189  | 
 12.24  | 
 06:28:59  | 
 06:46:59  | 
 
Done for 193230 ms, from  6:53:18.59 to  6:56:31.82.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 2640.54  | 
 0.0886  | 
 1.8098  | 
 2806  | 
 24  | 
|  TEST_TIME  | 
 2  | 
 3439.74  | 
 0.6948  | 
 1.3470  | 
 1639  | 
 99  | 
|  TEST_TIME  | 
 3  | 
 3718.97  | 
 0.8346  | 
 1.1617  | 
 1853  | 
 100  | 
|  TEST_TIME  | 
 4  | 
 3799.73  | 
 0.8532  | 
 1.1263  | 
 1665  | 
 100  | 
|  TEST_TIME  | 
 5  | 
 3876.10  | 
 0.8833  | 
 1.1068  | 
 1839  | 
 100  | 
|  TEST_TIME  | 
 6  | 
 3986.53  | 
 0.8968  | 
 1.0893  | 
 1984  | 
 100  | 
|  TEST_TIME  | 
 7  | 
 4071.63  | 
 0.9153  | 
 1.0965  | 
 1860  | 
 100  | 
|  TEST_TIME  | 
 8  | 
 4242.63  | 
 0.9207  | 
 1.0430  | 
 1956  | 
 100  | 
|  TEST_TIME  | 
 9  | 
 4149.97  | 
 0.9479  | 
 1.0633  | 
 2015  | 
 98  | 
|  TEST_TIME  | 
 10  | 
 4255.13  | 
 0.9334  | 
 1.0694  | 
 1688  | 
 100  | 
|  TEST_TIME  | 
 11  | 
 4400.37  | 
 0.9401  | 
 1.0542  | 
 1881  | 
 100  | 
|  TEST_TIME  | 
 12  | 
 4491.01  | 
 0.9480  | 
 1.0470  | 
 1718  | 
 100  | 
|  TEST_TIME  | 
 13  | 
 4557.29  | 
 0.9538  | 
 1.0426  | 
 1608  | 
 100  | 
|  TEST_TIME  | 
 14  | 
 4659.19  | 
 0.9470  | 
 1.0418  | 
 1594  | 
 100  | 
|  TEST_TIME  | 
 15  | 
 4725.98  | 
 0.9587  | 
 1.0372  | 
 1624  | 
 100  | 
|  TEST_TIME  | 
 16  | 
 4819.58  | 
 0.9535  | 
 1.0383  | 
 2042  | 
 100  | 
|  TEST_TIME  | 
 17  | 
 4917.13  | 
 0.9579  | 
 1.0519  | 
 2135  | 
 100  | 
|  TEST_TIME  | 
 18  | 
 5045.20  | 
 0.9682  | 
 1.0395  | 
 2009  | 
 100  | 
|  TEST_TIME  | 
 19  | 
 5045.32  | 
 0.9848  | 
 1.0166  | 
 1731  | 
 73  | 
|  TEST_TIME  | 
 20  | 
 5001.58  | 
 0.9742  | 
 1.0262  | 
 1588  | 
 63  | 
|  TEST_TIME  | 
 21  | 
 5066.20  | 
 0.9648  | 
 1.0276  | 
 1904  | 
 63  | 
|  TEST_TIME  | 
 22  | 
 5108.23  | 
 0.9729  | 
 1.0274  | 
 1622  | 
 71  | 
|  TEST_TIME  | 
 23  | 
 5167.20  | 
 0.9715  | 
 1.0224  | 
 1469  | 
 100  | 
|  TEST_TIME  | 
 24  | 
 5145.57  | 
 0.9839  | 
 1.0254  | 
 2028  | 
 97  | 
|  TEST_TIME  | 
 25  | 
 5165.84  | 
 0.9806  | 
 1.0316  | 
 1940  | 
 97  | 
|  TEST_TIME  | 
 26  | 
 5215.00  | 
 0.9826  | 
 1.0207  | 
 1624  | 
 100  | 
|  TEST_TIME  | 
 27  | 
 5259.24  | 
 0.9747  | 
 1.0295  | 
 1497  | 
 100  | 
|  TEST_TIME  | 
 28  | 
 5333.92  | 
 0.9788  | 
 1.0225  | 
 1658  | 
 100  | 
|  TEST_TIME  | 
 29  | 
 5359.63  | 
 0.9827  | 
 1.0127  | 
 1551  | 
 100  | 
|  TEST_TIME  | 
 30  | 
 5361.99  | 
 0.9785  | 
 1.0154  | 
 1460  | 
 100  | 
|  TEST_TIME  | 
 31  | 
 5302.17  | 
 0.9938  | 
 1.0094  | 
 1633  | 
 91  | 
|  TEST_TIME  | 
 32  | 
 5241.05  | 
 0.9893  | 
 1.0120  | 
 1753  | 
 81  | 
|  TEST_TIME  | 
 33  | 
 5228.91  | 
 0.9837  | 
 1.0253  | 
 1686  | 
 94  | 
|  TEST_TIME  | 
 34  | 
 5257.73  | 
 0.9897  | 
 1.0123  | 
 1815  | 
 92  | 
|  TEST_TIME  | 
 35  | 
 5244.07  | 
 0.9860  | 
 1.0221  | 
 1384  | 
 98  | 
|  TEST_TIME  | 
 36  | 
 5271.52  | 
 0.9886  | 
 1.0146  | 
 2021  | 
 97  | 
|  TEST_TIME  | 
 37  | 
 5294.95  | 
 0.9828  | 
 1.0236  | 
 1922  | 
 98  | 
|  TEST_TIME  | 
 38  | 
 5356.27  | 
 0.9852  | 
 1.0131  | 
 1700  | 
 100  | 
|  TEST_TIME  | 
 39  | 
 5362.49  | 
 0.9860  | 
 1.0123  | 
 1842  | 
 93  | 
|  TEST_TIME  | 
 40  | 
 5391.71  | 
 0.9877  | 
 1.0171  | 
 1483  | 
 100  | 
|  TEST_TIME  | 
 41  | 
 5387.63  | 
 0.9930  | 
 1.0112  | 
 1933  | 
 98  | 
|  TEST_TIME  | 
 42  | 
 5396.61  | 
 0.9855  | 
 1.0112  | 
 1620  | 
 97  | 
|  TEST_TIME  | 
 43  | 
 5415.25  | 
 0.9843  | 
 1.0178  | 
 1463  | 
 99  | 
|  TEST_TIME  | 
 44  | 
 5406.15  | 
 0.9964  | 
 1.0042  | 
 1369  | 
 92  | 
|  TEST_TIME  | 
 45  | 
 5338.92  | 
 0.9943  | 
 1.0071  | 
 1256  | 
 74  | 
|  TEST_TIME  | 
 46  | 
 5330.86  | 
 0.9867  | 
 1.0131  | 
 1594  | 
 91  | 
|  TEST_TIME  | 
 47  | 
 5366.16  | 
 0.9851  | 
 1.0133  | 
 2284  | 
 97  | 
|  TEST_TIME  | 
 48  | 
 5371.26  | 
 0.9912  | 
 1.0097  | 
 1971  | 
 90  | 
|  TEST_TIME  | 
 49  | 
 5407.24  | 
 0.9825  | 
 1.0121  | 
 1738  | 
 97  | 
|  TEST_TIME  | 
 50  | 
 5425.43  | 
 0.9886  | 
 1.0107  | 
 1749  | 
 99  | 
|  TEST_TIME  | 
 51  | 
 5436.66  | 
 0.9888  | 
 1.0083  | 
 1762  | 
 100  | 
|  TEST_TIME  | 
 52  | 
 5428.26  | 
 0.9904  | 
 1.0110  | 
 1596  | 
 95  | 
|  TEST_TIME  | 
 53  | 
 5473.04  | 
 0.9839  | 
 1.0070  | 
 1569  | 
 100  | 
|  TEST_TIME  | 
 54  | 
 5461.98  | 
 0.9904  | 
 1.0107  | 
 1907  | 
 99  | 
|  TEST_TIME  | 
 55  | 
 5484.91  | 
 0.9882  | 
 1.0113  | 
 1511  | 
 100  | 
|  TEST_TIME  | 
 56  | 
 5488.07  | 
 0.9927  | 
 1.0089  | 
 1511  | 
 100  | 
|  TEST_TIME  | 
 57  | 
 5501.77  | 
 0.9888  | 
 1.0101  | 
 1586  | 
 100  | 
|  TEST_TIME  | 
 58  | 
 5502.77  | 
 0.9925  | 
 1.0073  | 
 1633  | 
 99  | 
|  TEST_TIME  | 
 59  | 
 5521.96  | 
 0.9868  | 
 1.0097  | 
 1299  | 
 98  | 
|  TEST_TIME  | 
 60  | 
 5516.52  | 
 0.9939  | 
 1.0056  | 
 1594  | 
 98  | 
|  TEST_TIME  | 
 61  | 
 5525.07  | 
 0.9876  | 
 1.0068  | 
 1753  | 
 98  | 
|  TEST_TIME  | 
 62  | 
 5523.91  | 
 0.9907  | 
 1.0102  | 
 2250  | 
 92  | 
|  TEST_TIME  | 
 63  | 
 5560.99  | 
 0.9875  | 
 1.0124  | 
 2062  | 
 96  | 
|  TEST_TIME  | 
 64  | 
 5586.16  | 
 0.9921  | 
 1.0098  | 
 1853  | 
 92  | 
|  TEST_TIME  | 
 65  | 
 5599.56  | 
 0.9919  | 
 1.0099  | 
 1843  | 
 94  | 
|  TEST_TIME  | 
 66  | 
 5627.61  | 
 0.9896  | 
 1.0083  | 
 1686  | 
 94  | 
|  TEST_TIME  | 
 67  | 
 5623.37  | 
 0.9940  | 
 1.0070  | 
 1644  | 
 96  | 
|  TEST_TIME  | 
 68  | 
 5630.19  | 
 0.9910  | 
 1.0116  | 
 1584  | 
 99  | 
|  TEST_TIME  | 
 69  | 
 5647.06  | 
 0.9940  | 
 1.0059  | 
 1483  | 
 95  | 
|  TEST_TIME  | 
 70  | 
 5642.81  | 
 0.9923  | 
 1.0062  | 
 1472  | 
 86  | 
|  TEST_TIME  | 
 71  | 
 5640.90  | 
 0.9924  | 
 1.0056  | 
 1340  | 
 93  | 
|  TEST_TIME  | 
 72  | 
 5634.72  | 
 0.9927  | 
 1.0132  | 
 1305  | 
 98  | 
|  TEST_TIME  | 
 73  | 
 5654.33  | 
 0.9959  | 
 1.0030  | 
 1402  | 
 100  | 
|  TEST_TIME  | 
 74  | 
 5621.35  | 
 0.9953  | 
 1.0057  | 
 1441  | 
 95  | 
|  TEST_TIME  | 
 75  | 
 5602.96  | 
 0.9955  | 
 1.0053  | 
 1395  | 
 92  | 
|  TEST_TIME  | 
 76  | 
 5609.45  | 
 0.9909  | 
 1.0067  | 
 1707  | 
 98  | 
|  TEST_TIME  | 
 77  | 
 5619.94  | 
 0.9918  | 
 1.0071  | 
 1817  | 
 99  | 
|  TEST_TIME  | 
 78  | 
 5627.61  | 
 0.9928  | 
 1.0084  | 
 1778  | 
 98  | 
|  TEST_TIME  | 
 79  | 
 5624.53  | 
 0.9962  | 
 1.0051  | 
 1856  | 
 92  | 
|  TEST_TIME  | 
 80  | 
 5621.32  | 
 0.9931  | 
 1.0077  | 
 1652  | 
 92  | 
|  TEST_TIME  | 
 81  | 
 5645.42  | 
 0.9910  | 
 1.0061  | 
 1563  | 
 98  | 
|  TEST_TIME  | 
 82  | 
 5631.53  | 
 0.9963  | 
 1.0039  | 
 1637  | 
 88  | 
|  TEST_TIME  | 
 83  | 
 5612.32  | 
 0.9952  | 
 1.0053  | 
 1552  | 
 85  | 
|  TEST_TIME  | 
 84  | 
 5632.23  | 
 0.9898  | 
 1.0076  | 
 1427  | 
 99  | 
|  TEST_TIME  | 
 85  | 
 5633.46  | 
 0.9956  | 
 1.0061  | 
 1741  | 
 100  | 
|  TEST_TIME  | 
 86  | 
 5637.49  | 
 0.9937  | 
 1.0043  | 
 1417  | 
 91  | 
|  TEST_TIME  | 
 87  | 
 5628.30  | 
 0.9944  | 
 1.0054  | 
 1497  | 
 90  | 
|  TEST_TIME  | 
 88  | 
 5639.18  | 
 0.9921  | 
 1.0043  | 
 1372  | 
 95  | 
|  TEST_TIME  | 
 89  | 
 5635.84  | 
 0.9936  | 
 1.0076  | 
 1392  | 
 98  | 
|  TEST_TIME  | 
 90  | 
 5634.87  | 
 0.9966  | 
 1.0059  | 
 1356  | 
 98  | 
|  TEST_TIME  | 
 91  | 
 5625.30  | 
 0.9966  | 
 1.0039  | 
 1396  | 
 94  | 
|  TEST_TIME  | 
 92  | 
 5645.40  | 
 0.9897  | 
 1.0109  | 
 2047  | 
 97  | 
|  TEST_TIME  | 
 93  | 
 5674.73  | 
 0.9948  | 
 1.0047  | 
 1702  | 
 96  | 
|  TEST_TIME  | 
 94  | 
 5675.60  | 
 0.9939  | 
 1.0060  | 
 1714  | 
 96  | 
|  TEST_TIME  | 
 95  | 
 5681.63  | 
 0.9943  | 
 1.0071  | 
 1679  | 
 85  | 
|  TEST_TIME  | 
 96  | 
 5689.81  | 
 0.9952  | 
 1.0038  | 
 1634  | 
 87  | 
|  TEST_TIME  | 
 97  | 
 5688.43  | 
 0.9937  | 
 1.0060  | 
 1402  | 
 82  | 
|  TEST_TIME  | 
 98  | 
 5718.81  | 
 0.9904  | 
 1.0079  | 
 1258  | 
 99  | 
|  TEST_TIME  | 
 99  | 
 5721.33  | 
 0.9972  | 
 1.0031  | 
 1090  | 
 94  | 
|  TEST_TIME  | 
 100  | 
 5719.55  | 
 0.9935  | 
 1.0057  | 
 1333  | 
 99  | 
|  TEST_TIME  | 
 101  | 
 5724.20  | 
 0.9949  | 
 1.0069  | 
 1268  | 
 89  | 
|  TEST_TIME  | 
 102  | 
 5745.75  | 
 0.9954  | 
 1.0035  | 
 1527  | 
 95  | 
|  TEST_TIME  | 
 103  | 
 5732.92  | 
 0.9960  | 
 1.0037  | 
 1406  | 
 93  | 
|  TEST_TIME  | 
 104  | 
 5730.67  | 
 0.9945  | 
 1.0046  | 
 1312  | 
 91  | 
|  TEST_TIME  | 
 105  | 
 5721.01  | 
 0.9967  | 
 1.0035  | 
 1292  | 
 95  | 
|  TEST_TIME  | 
 106  | 
 5728.69  | 
 0.9927  | 
 1.0044  | 
 1769  | 
 97  | 
|  TEST_TIME  | 
 107  | 
 5726.24  | 
 0.9954  | 
 1.0055  | 
 1657  | 
 98  | 
|  TEST_TIME  | 
 108  | 
 5732.53  | 
 0.9951  | 
 1.0054  | 
 2007  | 
 96  | 
|  TEST_TIME  | 
 109  | 
 5747.49  | 
 0.9935  | 
 1.0047  | 
 1779  | 
 94  | 
|  TEST_TIME  | 
 110  | 
 5755.91  | 
 0.9942  | 
 1.0086  | 
 1638  | 
 99  | 
|  TEST_TIME  | 
 111  | 
 5780.66  | 
 0.9952  | 
 1.0066  | 
 1381  | 
 100  | 
|  TEST_TIME  | 
 112  | 
 5787.78  | 
 0.9966  | 
 1.0027  | 
 1718  | 
 100  | 
|  TEST_TIME  | 
 113  | 
 5765.53  | 
 0.9977  | 
 1.0024  | 
 1098  | 
 75  | 
|  TEST_TIME  | 
 114  | 
 5744.81  | 
 0.9972  | 
 1.0034  | 
 1188  | 
 76  | 
|  TEST_TIME  | 
 115  | 
 5755.68  | 
 0.9928  | 
 1.0031  | 
 1332  | 
 97  | 
|  TEST_TIME  | 
 116  | 
 5739.60  | 
 0.9972  | 
 1.0031  | 
 1580  | 
 89  | 
|  TEST_TIME  | 
 117  | 
 5742.60  | 
 0.9940  | 
 1.0046  | 
 1419  | 
 91  | 
|  TEST_TIME  | 
 118  | 
 5752.96  | 
 0.9942  | 
 1.0055  | 
 1177  | 
 100  | 
|  TEST_TIME  | 
 119  | 
 5757.87  | 
 0.9962  | 
 1.0044  | 
 1286  | 
 100  | 
|  TEST_TIME  | 
 120  | 
 5744.26  | 
 0.9984  | 
 1.0026  | 
 1332  | 
 96  | 
|  TEST_TIME  | 
 121  | 
 5758.73  | 
 0.9918  | 
 1.0041  | 
 1961  | 
 99  | 
|  TEST_TIME  | 
 122  | 
 5766.05  | 
 0.9946  | 
 1.0051  | 
 2007  | 
 91  | 
|  TEST_TIME  | 
 123  | 
 5777.86  | 
 0.9949  | 
 1.0054  | 
 1821  | 
 87  | 
|  TEST_TIME  | 
 124  | 
 5799.55  | 
 0.9963  | 
 1.0030  | 
 1844  | 
 96  | 
|  TEST_TIME  | 
 125  | 
 5788.52  | 
 0.9969  | 
 1.0033  | 
 1570  | 
 89  | 
|  TEST_TIME  | 
 126  | 
 5803.77  | 
 0.9928  | 
 1.0045  | 
 1592  | 
 96  | 
|  TEST_TIME  | 
 127  | 
 5817.26  | 
 0.9943  | 
 1.0058  | 
 1543  | 
 96  | 
|  TEST_TIME  | 
 128  | 
 5820.88  | 
 0.9973  | 
 1.0036  | 
 1782  | 
 91  | 
|  TEST_TIME  | 
 129  | 
 5819.81  | 
 0.9960  | 
 1.0054  | 
 1497  | 
 92  | 
|  TEST_TIME  | 
 130  | 
 5825.76  | 
 0.9967  | 
 1.0028  | 
 1455  | 
 95  | 
|  TEST_TIME  | 
 131  | 
 5815.72  | 
 0.9969  | 
 1.0045  | 
 1363  | 
 97  | 
|  TEST_TIME  | 
 132  | 
 5817.93  | 
 0.9965  | 
 1.0037  | 
 1492  | 
 94  | 
|  TEST_TIME  | 
 133  | 
 5813.88  | 
 0.9968  | 
 1.0029  | 
 1309  | 
 90  | 
|  TEST_TIME  | 
 134  | 
 5808.01  | 
 0.9965  | 
 1.0033  | 
 1256  | 
 94  | 
|  TEST_TIME  | 
 135  | 
 5801.81  | 
 0.9969  | 
 1.0028  | 
 1251  | 
 89  | 
|  TEST_TIME  | 
 136  | 
 5794.96  | 
 0.9966  | 
 1.0055  | 
 1073  | 
 96  | 
|  TEST_TIME  | 
 137  | 
 5812.96  | 
 0.9951  | 
 1.0050  | 
 1814  | 
 98  | 
|  TEST_TIME  | 
 138  | 
 5817.65  | 
 0.9969  | 
 1.0048  | 
 1760  | 
 89  | 
|  TEST_TIME  | 
 139  | 
 5832.98  | 
 0.9949  | 
 1.0045  | 
 1400  | 
 98  | 
|  TEST_TIME  | 
 140  | 
 5825.87  | 
 0.9986  | 
 1.0019  | 
 1426  | 
 91  | 
|  TEST_TIME  | 
 141  | 
 5826.57  | 
 0.9946  | 
 1.0043  | 
 1307  | 
 96  | 
|  TEST_TIME  | 
 142  | 
 5833.10  | 
 0.9961  | 
 1.0034  | 
 1453  | 
 98  | 
|  TEST_TIME  | 
 143  | 
 5831.53  | 
 0.9967  | 
 1.0028  | 
 1298  | 
 95  | 
|  TEST_TIME  | 
 144  | 
 5835.37  | 
 0.9952  | 
 1.0027  | 
 1365  | 
 98  | 
|  TEST_TIME  | 
 145  | 
 5837.83  | 
 0.9954  | 
 1.0035  | 
 1422  | 
 94  | 
|  TEST_TIME  | 
 146  | 
 5842.76  | 
 0.9958  | 
 1.0032  | 
 1429  | 
 95  | 
|  TEST_TIME  | 
 147  | 
 5851.05  | 
 0.9949  | 
 1.0030  | 
 1343  | 
 94  | 
|  TEST_TIME  | 
 148  | 
 5845.31  | 
 0.9972  | 
 1.0045  | 
 1303  | 
 99  | 
|  TEST_TIME  | 
 149  | 
 5843.59  | 
 0.9981  | 
 1.0019  | 
 1361  | 
 99  | 
|  TEST_TIME  | 
 150  | 
 5847.90  | 
 0.9945  | 
 1.0034  | 
 1180  | 
 97  | 
|  TEST_TIME  | 
 151  | 
 5844.22  | 
 0.9973  | 
 1.0024  | 
 1221  | 
 95  | 
|  TEST_TIME  | 
 152  | 
 5853.93  | 
 0.9941  | 
 1.0046  | 
 1702  | 
 94  | 
|  TEST_TIME  | 
 153  | 
 5853.07  | 
 0.9981  | 
 1.0028  | 
 1517  | 
 85  | 
|  TEST_TIME  | 
 154  | 
 5850.77  | 
 0.9968  | 
 1.0041  | 
 1590  | 
 87  | 
|  TEST_TIME  | 
 155  | 
 5865.85  | 
 0.9950  | 
 1.0052  | 
 1530  | 
 87  | 
|  TEST_TIME  | 
 156  | 
 5877.73  | 
 0.9967  | 
 1.0035  | 
 1476  | 
 87  | 
|  TEST_TIME  | 
 157  | 
 5889.51  | 
 0.9951  | 
 1.0042  | 
 1323  | 
 97  | 
|  TEST_TIME  | 
 158  | 
 5893.74  | 
 0.9971  | 
 1.0031  | 
 1044  | 
 99  | 
|  TEST_TIME  | 
 159  | 
 5899.10  | 
 0.9959  | 
 1.0033  | 
 1375  | 
 99  | 
|  TEST_TIME  | 
 160  | 
 5902.03  | 
 0.9965  | 
 1.0042  | 
 1285  | 
 97  | 
|  TEST_TIME  | 
 161  | 
 5916.40  | 
 0.9956  | 
 1.0036  | 
 1312  | 
 98  | 
|  TEST_TIME  | 
 162  | 
 5930.02  | 
 0.9951  | 
 1.0038  | 
 1332  | 
 99  | 
|  TEST_TIME  | 
 163  | 
 5939.09  | 
 0.9962  | 
 1.0030  | 
 1092  | 
 100  | 
|  TEST_TIME  | 
 164  | 
 5953.06  | 
 0.9946  | 
 1.0046  | 
 1064  | 
 100  | 
|  TEST_TIME  | 
 165  | 
 5967.22  | 
 0.9962  | 
 1.0015  | 
 1270  | 
 100  | 
|  TEST_TIME  | 
 166  | 
 5963.01  | 
 0.9962  | 
 1.0021  | 
 1491  | 
 98  | 
|  TEST_TIME  | 
 167  | 
 5965.74  | 
 0.9957  | 
 1.0034  | 
 1699  | 
 90  | 
|  TEST_TIME  | 
 168  | 
 5973.96  | 
 0.9960  | 
 1.0029  | 
 1194  | 
 97  | 
|  TEST_TIME  | 
 169  | 
 5979.45  | 
 0.9961  | 
 1.0025  | 
 1396  | 
 94  | 
|  TEST_TIME  | 
 170  | 
 5977.55  | 
 0.9969  | 
 1.0030  | 
 1537  | 
 94  | 
|  TEST_TIME  | 
 171  | 
 5983.89  | 
 0.9962  | 
 1.0033  | 
 1489  | 
 90  | 
|  TEST_TIME  | 
 172  | 
 5992.89  | 
 0.9961  | 
 1.0011  | 
 1292  | 
 92  | 
|  TEST_TIME  | 
 173  | 
 5975.06  | 
 0.9983  | 
 1.0018  | 
 1043  | 
 83  | 
|  TEST_TIME  | 
 174  | 
 5968.90  | 
 0.9971  | 
 1.0032  | 
 1049  | 
 84  | 
|  TEST_TIME  | 
 175  | 
 5974.81  | 
 0.9965  | 
 1.0024  | 
 1278  | 
 86  | 
|  TEST_TIME  | 
 176  | 
 5977.22  | 
 0.9963  | 
 1.0020  | 
 947  | 
 92  | 
|  TEST_TIME  | 
 177  | 
 5966.39  | 
 0.9981  | 
 1.0019  | 
 1270  | 
 97  | 
|  TEST_TIME  | 
 178  | 
 5959.49  | 
 0.9974  | 
 1.0037  | 
 919  | 
 96  | 
|  TEST_TIME  | 
 179  | 
 5968.49  | 
 0.9967  | 
 1.0026  | 
 918  | 
 98  | 
|  TEST_TIME  | 
 180  | 
 5959.18  | 
 0.9986  | 
 1.0013  | 
 1193  | 
 97  | 
 
Done for 9160 ms, from  6:56:33.05 to  6:56:42.21.  
 
 
|  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  | 
 69026  | 
 80394  | 
 68090  | 
 81686  | 
 68671  | 
 125280  | 
 76035  | 
 132316  | 
 61455  | 
 118415  | 
 64722  | 
 87351  | 
 89403  | 
 83739  | 
 171708  | 
 84427  | 
 234765  | 
 463413  | 
 <null>  | 
 03:46:50  | 
 04:04:50  | 
|  fetches per second  | 
 2  | 
 19759  | 
 10315  | 
 7141  | 
 <null>  | 
 24952  | 
 <null>  | 
 38062  | 
 75744  | 
 5570  | 
 3091  | 
 20131  | 
 7498  | 
 36883  | 
 14624  | 
 36514  | 
 18480  | 
 <null>  | 
 482504  | 
 <null>  | 
 04:04:51  | 
 04:22:51  | 
|  fetches per second  | 
 3  | 
 7423  | 
 4368  | 
 8622  | 
 <null>  | 
 8768  | 
 <null>  | 
 9707  | 
 22039  | 
 2354  | 
 10829  | 
 12065  | 
 2920  | 
 13055  | 
 4443  | 
 16971  | 
 3387  | 
 <null>  | 
 21182  | 
 <null>  | 
 04:22:52  | 
 04:40:52  | 
|  fetches per second  | 
 4  | 
 7969  | 
 5522  | 
 9386  | 
 <null>  | 
 12555  | 
 7536  | 
 17146  | 
 6369  | 
 6319  | 
 14028  | 
 10526  | 
 11222  | 
 20696  | 
 8546  | 
 14890  | 
 <null>  | 
 30262  | 
 188226  | 
 <null>  | 
 04:40:53  | 
 04:58:53  | 
|  fetches per second  | 
 5  | 
 4126  | 
 24291  | 
 8667  | 
 <null>  | 
 8124  | 
 3931  | 
 8400  | 
 <null>  | 
 1819  | 
 2766  | 
 12138  | 
 1799  | 
 22480  | 
 3339  | 
 17994  | 
 <null>  | 
 <null>  | 
 226379  | 
 <null>  | 
 04:58:54  | 
 05:16:54  | 
|  fetches per second  | 
 6  | 
 3357  | 
 9470  | 
 6454  | 
 <null>  | 
 3809  | 
 <null>  | 
 7528  | 
 <null>  | 
 10841  | 
 10586  | 
 5023  | 
 1573  | 
 9114  | 
 2996  | 
 13198  | 
 11963  | 
 <null>  | 
 321824  | 
 <null>  | 
 05:16:55  | 
 05:34:55  | 
|  fetches per second  | 
 7  | 
 12991  | 
 2826  | 
 19042  | 
 <null>  | 
 8118  | 
 <null>  | 
 18001  | 
 <null>  | 
 <null>  | 
 2360  | 
 11873  | 
 2470  | 
 8653  | 
 <null>  | 
 33285  | 
 9460  | 
 30137  | 
 35663  | 
 <null>  | 
 05:34:56  | 
 05:52:56  | 
|  fetches per second  | 
 8  | 
 3854  | 
 9454  | 
 11997  | 
 11890  | 
 5366  | 
 4459  | 
 8193  | 
 3139  | 
 15834  | 
 3986  | 
 4090  | 
 2151  | 
 9133  | 
 2068  | 
 15991  | 
 7756  | 
 9036  | 
 <null>  | 
 <null>  | 
 05:52:57  | 
 06:10:57  | 
|  fetches per second  | 
 9  | 
 4228  | 
 5348  | 
 4303  | 
 <null>  | 
 11968  | 
 2581  | 
 13381  | 
 <null>  | 
 1692  | 
 3059  | 
 5012  | 
 1953  | 
 12645  | 
 2018  | 
 7613  | 
 4613  | 
 <null>  | 
 523590  | 
 <null>  | 
 06:10:58  | 
 06:28:58  | 
|  fetches per second  | 
 10  | 
 6631  | 
 22520  | 
 6688  | 
 32047  | 
 9540  | 
 <null>  | 
 47527  | 
 <null>  | 
 8055  | 
 4607  | 
 24479  | 
 1515  | 
 10885  | 
 <null>  | 
 11127  | 
 <null>  | 
 132694  | 
 32157  | 
 <null>  | 
 06:28:59  | 
 06:46:59  | 
|  marks per second  | 
 1  | 
 14749  | 
 10548  | 
 15090  | 
 15324  | 
 15192  | 
 26320  | 
 8833  | 
 25228  | 
 7530  | 
 23039  | 
 12868  | 
 15813  | 
 7727  | 
 15147  | 
 6821  | 
 11873  | 
 15322  | 
 60157  | 
 <null>  | 
 03:46:50  | 
 04:04:50  | 
|  marks per second  | 
 2  | 
 3956  | 
 1424  | 
 1516  | 
 <null>  | 
 5270  | 
 <null>  | 
 6940  | 
 12295  | 
 654  | 
 620  | 
 2913  | 
 1216  | 
 2228  | 
 2249  | 
 1597  | 
 3634  | 
 <null>  | 
 45862  | 
 <null>  | 
 04:04:51  | 
 04:22:51  | 
|  marks per second  | 
 3  | 
 1603  | 
 566  | 
 1407  | 
 <null>  | 
 1706  | 
 <null>  | 
 1039  | 
 3584  | 
 302  | 
 1917  | 
 2079  | 
 530  | 
 517  | 
 768  | 
 767  | 
 472  | 
 <null>  | 
 961  | 
 <null>  | 
 04:22:52  | 
 04:40:52  | 
|  marks per second  | 
 4  | 
 1669  | 
 748  | 
 1620  | 
 <null>  | 
 2199  | 
 1881  | 
 1697  | 
 870  | 
 748  | 
 2225  | 
 925  | 
 1920  | 
 710  | 
 1432  | 
 420  | 
 <null>  | 
 1211  | 
 1750  | 
 <null>  | 
 04:40:53  | 
 04:58:53  | 
|  marks per second  | 
 5  | 
 804  | 
 3246  | 
 996  | 
 <null>  | 
 1153  | 
 882  | 
 662  | 
 <null>  | 
 224  | 
 454  | 
 1236  | 
 272  | 
 605  | 
 472  | 
 425  | 
 <null>  | 
 <null>  | 
 3076  | 
 <null>  | 
 04:58:54  | 
 05:16:54  | 
|  marks per second  | 
 6  | 
 710  | 
 1281  | 
 1005  | 
 <null>  | 
 553  | 
 <null>  | 
 654  | 
 <null>  | 
 2629  | 
 1750  | 
 768  | 
 237  | 
 275  | 
 494  | 
 575  | 
 1939  | 
 <null>  | 
 2714  | 
 <null>  | 
 05:16:55  | 
 05:34:55  | 
|  marks per second  | 
 7  | 
 2673  | 
 388  | 
 2351  | 
 <null>  | 
 1150  | 
 <null>  | 
 1726  | 
 <null>  | 
 <null>  | 
 408  | 
 2349  | 
 460  | 
 261  | 
 <null>  | 
 1431  | 
 1263  | 
 733  | 
 728  | 
 <null>  | 
 05:34:56  | 
 05:52:56  | 
|  marks per second  | 
 8  | 
 808  | 
 1156  | 
 1243  | 
 1715  | 
 749  | 
 993  | 
 732  | 
 417  | 
 1490  | 
 592  | 
 433  | 
 285  | 
 289  | 
 309  | 
 622  | 
 1743  | 
 269  | 
 <null>  | 
 <null>  | 
 05:52:57  | 
 06:10:57  | 
|  marks per second  | 
 9  | 
 832  | 
 697  | 
 544  | 
 <null>  | 
 1179  | 
 562  | 
 1286  | 
 <null>  | 
 91  | 
 472  | 
 858  | 
 294  | 
 399  | 
 408  | 
 361  | 
 678  | 
 <null>  | 
 6368  | 
 <null>  | 
 06:10:58  | 
 06:28:58  | 
|  marks per second  | 
 10  | 
 1300  | 
 2848  | 
 1028  | 
 4599  | 
 1633  | 
 <null>  | 
 7687  | 
 <null>  | 
 601  | 
 712  | 
 838  | 
 224  | 
 242  | 
 <null>  | 
 776  | 
 <null>  | 
 18028  | 
 712  | 
 <null>  | 
 06:28:59  | 
 06:46:59  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 03:46:50  | 
 04:04:50  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 04:04:51  | 
 04:22:51  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 04:22:52  | 
 04:40:52  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 04:40:53  | 
 04:58:53  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 <null>  | 
 04:58:54  | 
 05:16:54  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:16:55  | 
 05:34:55  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:34:56  | 
 05:52:56  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 05:52:57  | 
 06:10:57  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:10:58  | 
 06:28:58  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 06:28:59  | 
 06:46:59  | 
|  writes/marks*100  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 6  | 
 0  | 
 <null>  | 
 03:46:50  | 
 04:04:50  | 
|  writes/marks*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 04:04:51  | 
 04:22:51  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 04:22:52  | 
 04:40:52  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 3  | 
 0  | 
 <null>  | 
 04:40:53  | 
 04:58:53  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 <null>  | 
 1  | 
 <null>  | 
 04:58:54  | 
 05:16:54  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:16:55  | 
 05:34:55  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 <null>  | 
 2  | 
 0  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 05:34:56  | 
 05:52:56  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 3  | 
 <null>  | 
 <null>  | 
 05:52:57  | 
 06:10:57  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 06:10:58  | 
 06:28:58  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 3  | 
 0  | 
 <null>  | 
 06:28:59  | 
 06:46:59  | 
 
Done for 8830 ms, from  6:56:43.27 to  6:56:52.10.  
 
 
|  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  | 
 1858732  | 
 1748118  | 
 110614  | 
 5.95  | 
 0  | 
 13291  | 
 78  | 
 110614  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  doc_list_biud  | 
 1859195  | 
 1748118  | 
 111077  | 
 5.97  | 
 0  | 
 17487  | 
 25  | 
 111077  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_add_invoice_to_stock  | 
 20330  | 
 12320  | 
 8010  | 
 39.39  | 
 15  | 
 204985  | 
 19225  | 
 8010  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_adding_invoice  | 
 4054  | 
 3235  | 
 819  | 
 20.20  | 
 0  | 
 104083  | 
 4215  | 
 819  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_client_order  | 
 7013  | 
 6862  | 
 151  | 
 2.15  | 
 0  | 
 4555  | 
 293  | 
 151  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_customer_reserve  | 
 277101  | 
 177111  | 
 99990  | 
 36.08  | 
 0  | 
 14633  | 
 109  | 
 99990  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2716  | 
 2701  | 
 15  | 
 0.55  | 
 0  | 
 2355  | 
 146  | 
 15  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1594  | 
 1588  | 
 6  | 
 0.37  | 
 0  | 
 4103  | 
 150  | 
 6  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_supplier_invoice  | 
 9815  | 
 7515  | 
 2300  | 
 23.43  | 
 0  | 
 12355  | 
 795  | 
 2300  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_supplier_order  | 
 1607  | 
 545  | 
 1062  | 
 66.08  | 
 15  | 
 327648  | 
 32870  | 
 1062  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_cancel_write_off  | 
 24080  | 
 15395  | 
 8685  | 
 36.06  | 
 0  | 
 13478  | 
 213  | 
 8685  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_client_order  | 
 84583  | 
 84583  | 
 0  | 
 0.00  | 
 0  | 
 12542  | 
 558  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_customer_reserve  | 
 623869  | 
 623869  | 
 0  | 
 0.00  | 
 0  | 
 15303  | 
 324  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_fill_shopping_cart  | 
 128051  | 
 127799  | 
 252  | 
 0.19  | 
 0  | 
 3697  | 
 114  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 623869  | 
 623869  | 
 0  | 
 0.00  | 
 0  | 
 13884  | 
 24  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_get_clo_for_invoice  | 
 12320  | 
 12320  | 
 0  | 
 0.00  | 
 0  | 
 20218  | 
 445  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_kill_cost_storno  | 
 32077  | 
 22919  | 
 9158  | 
 28.55  | 
 0  | 
 12604  | 
 22  | 
 9158  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 587655  | 
 377677  | 
 209978  | 
 35.73  | 
 0  | 
 14602  | 
 42  | 
 209978  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_kill_qty_storno  | 
 372633  | 
 261641  | 
 110992  | 
 29.78  | 
 0  | 
 17487  | 
 114  | 
 110992  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_lock_selected_doc  | 
 83036  | 
 71403  | 
 11633  | 
 14.00  | 
 0  | 
 1154  | 
 8  | 
 11633  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_make_cost_storno  | 
 102420  | 
 102420  | 
 0  | 
 0.00  | 
 0  | 
 12340  | 
 691  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 102420  | 
 102420  | 
 0  | 
 0.00  | 
 0  | 
 4087  | 
 55  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 84583  | 
 84583  | 
 0  | 
 0.00  | 
 0  | 
 3510  | 
 184  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_pay_from_customer  | 
 28185  | 
 28185  | 
 0  | 
 0.00  | 
 0  | 
 10234  | 
 1155  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_pay_to_supplier  | 
 23257  | 
 23257  | 
 0  | 
 0.00  | 
 0  | 
 12433  | 
 1265  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_payment_common  | 
 51442  | 
 51442  | 
 0  | 
 0.00  | 
 0  | 
 5242  | 
 68  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 7008  | 
 6862  | 
 146  | 
 2.08  | 
 0  | 
 2434  | 
 129  | 
 146  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 16197  | 
 15555  | 
 642  | 
 3.96  | 
 0  | 
 17487  | 
 461  | 
 642  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 38658  | 
 38658  | 
 0  | 
 0.00  | 
 0  | 
 4540  | 
 59  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_reserve_write_off  | 
 40035  | 
 38658  | 
 1377  | 
 3.43  | 
 0  | 
 8315  | 
 727  | 
 1377  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_supplier_invoice  | 
 21740  | 
 21645  | 
 95  | 
 0.43  | 
 0  | 
 29968  | 
 3880  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  sp_supplier_order  | 
 21728  | 
 21571  | 
 157  | 
 0.72  | 
 0  | 
 21574  | 
 2522  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  srv_find_qd_qs_mism  | 
 1087632  | 
 977014  | 
 110618  | 
 10.17  | 
 0  | 
 13213  | 
 41  | 
 110618  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  srv_make_invnt_saldo  | 
 1142  | 
 1142  | 
 0  | 
 0.00  | 
 15  | 
 33540  | 
 6490  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  srv_make_money_saldo  | 
 3864  | 
 3864  | 
 0  | 
 0.00  | 
 0  | 
 889  | 
 64  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 2121  | 
 48563  | 
 24295  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 8010  | 
 8010  | 
 0  | 
 0.00  | 
 0  | 
 10280  | 
 93  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 784  | 
 784  | 
 0  | 
 0.00  | 
 0  | 
 2464  | 
 251  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 151  | 
 151  | 
 0  | 
 0.00  | 
 0  | 
 811  | 
 112  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 91  | 
 91  | 
 0  | 
 0.00  | 
 0  | 
 374  | 
 53  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 15  | 
 15  | 
 0  | 
 0.00  | 
 0  | 
 203  | 
 43  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 6  | 
 6  | 
 0  | 
 0.00  | 
 16  | 
 203  | 
 59  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 638  | 
 638  | 
 0  | 
 0.00  | 
 0  | 
 2012  | 
 92  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 12723  | 
 12723  | 
 0  | 
 0.00  | 
 0  | 
 9547  | 
 204  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 34  | 
 34  | 
 0  | 
 0.00  | 
 0  | 
 468  | 
 74  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1377  | 
 1377  | 
 0  | 
 0.00  | 
 0  | 
 1451  | 
 68  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 95  | 
 95  | 
 0  | 
 0.00  | 
 0  | 
 656  | 
 88  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 157  | 
 157  | 
 0  | 
 0.00  | 
 0  | 
 1747  | 
 96  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 12320  | 
 12320  | 
 0  | 
 0.00  | 
 0  | 
 21700  | 
 909  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1371  | 
 1371  | 
 0  | 
 0.00  | 
 0  | 
 18813  | 
 967  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6862  | 
 6862  | 
 0  | 
 0.00  | 
 0  | 
 6147  | 
 59  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2560  | 
 2560  | 
 0  | 
 0.00  | 
 0  | 
 1622  | 
 60  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2701  | 
 2701  | 
 0  | 
 0.00  | 
 0  | 
 1326  | 
 50  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1588  | 
 1588  | 
 0  | 
 0.00  | 
 0  | 
 1232  | 
 50  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 965  | 
 965  | 
 0  | 
 0.00  | 
 0  | 
 1841  | 
 73  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 545  | 
 545  | 
 0  | 
 0.00  | 
 0  | 
 36145  | 
 3038  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3833  | 
 3833  | 
 0  | 
 0.00  | 
 0  | 
 1295  | 
 63  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_client_order  | 
 84583  | 
 84583  | 
 0  | 
 0.00  | 
 0  | 
 15943  | 
 76  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 3807  | 
 3807  | 
 0  | 
 0.00  | 
 0  | 
 4851  | 
 53  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 28185  | 
 28185  | 
 0  | 
 0.00  | 
 0  | 
 12184  | 
 65  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 23257  | 
 23257  | 
 0  | 
 0.00  | 
 0  | 
 12168  | 
 64  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 38658  | 
 38658  | 
 0  | 
 0.00  | 
 0  | 
 12605  | 
 72  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 21645  | 
 21645  | 
 0  | 
 0.00  | 
 0  | 
 17394  | 
 78  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 21571  | 
 21571  | 
 0  | 
 0.00  | 
 0  | 
 17051  | 
 78  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1142  | 
 1142  | 
 0  | 
 0.00  | 
 0  | 
 1185  | 
 25  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 3864  | 
 3864  | 
 0  | 
 0.00  | 
 0  | 
 3869  | 
 25  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 1451  | 
 291  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_add_invoice_to_stock  | 
 40660  | 
 24640  | 
 16020  | 
 39.39  | 
 0  | 
 14867  | 
 69  | 
 16020  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_all_customers  | 
 126700  | 
 126700  | 
 0  | 
 0.00  | 
 0  | 
 578  | 
 6  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_all_suppliers  | 
 86936  | 
 86432  | 
 504  | 
 0.57  | 
 0  | 
 561  | 
 6  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_all_wares  | 
 169166  | 
 169166  | 
 0  | 
 0.00  | 
 0  | 
 608  | 
 5  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_adding_invoice  | 
 3240  | 
 2742  | 
 498  | 
 15.37  | 
 0  | 
 4166  | 
 196  | 
 498  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_client_order  | 
 14026  | 
 13724  | 
 302  | 
 2.15  | 
 0  | 
 3915  | 
 7  | 
 302  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_customer_prepayment  | 
 5432  | 
 5402  | 
 30  | 
 0.55  | 
 0  | 
 733  | 
 8  | 
 30  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_customer_reserve  | 
 5302  | 
 5120  | 
 182  | 
 3.43  | 
 0  | 
 655  | 
 9  | 
 182  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_payment_to_supplier  | 
 3188  | 
 3176  | 
 12  | 
 0.37  | 
 0  | 
 4056  | 
 10  | 
 12  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_supplier_invoice  | 
 3206  | 
 1930  | 
 1276  | 
 39.80  | 
 0  | 
 8751  | 
 73  | 
 1276  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_supplier_order  | 
 3214  | 
 1090  | 
 2124  | 
 66.08  | 
 0  | 
 359  | 
 10  | 
 2124  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_cancel_write_off  | 
 7734  | 
 7666  | 
 68  | 
 0.87  | 
 0  | 
 2621  | 
 109  | 
 68  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_max_id_clo_ord  | 
 21728  | 
 21571  | 
 157  | 
 0.72  | 
 0  | 
 562  | 
 6  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_max_id_clo_res  | 
 3807  | 
 3807  | 
 0  | 
 0.00  | 
 0  | 
 3697  | 
 23  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_max_id_ord_sup  | 
 21740  | 
 21645  | 
 95  | 
 0.43  | 
 0  | 
 967  | 
 7  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_max_non_paid_invoice  | 
 23257  | 
 23257  | 
 0  | 
 0.00  | 
 0  | 
 1935  | 
 6  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_max_non_paid_realizn  | 
 28185  | 
 28185  | 
 0  | 
 0.00  | 
 0  | 
 983  | 
 6  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_min_id_clo_ord  | 
 21728  | 
 21571  | 
 157  | 
 0.72  | 
 0  | 
 811  | 
 7  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_min_id_clo_res  | 
 3807  | 
 3807  | 
 0  | 
 0.00  | 
 0  | 
 1264  | 
 10  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_min_id_ord_sup  | 
 21740  | 
 21645  | 
 95  | 
 0.43  | 
 0  | 
 1560  | 
 8  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_min_non_paid_invoice  | 
 23257  | 
 23257  | 
 0  | 
 0.00  | 
 0  | 
 2168  | 
 9  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_min_non_paid_realizn  | 
 28185  | 
 28185  | 
 0  | 
 0.00  | 
 0  | 
 1981  | 
 9  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_our_firm  | 
 42466  | 
 42466  | 
 0  | 
 0.00  | 
 0  | 
 936  | 
 6  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  v_reserve_write_off  | 
 80070  | 
 77316  | 
 2754  | 
 3.43  | 
 0  | 
 8174  | 
 9  | 
 2754  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 17528  | 
 9785  | 
 7743  | 
 44.17  | 
 0  | 
 2137  | 
 48  | 
 7743  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1603  | 
 545  | 
 1058  | 
 66.00  | 
 0  | 
 1341  | 
 78  | 
 1058  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  x_make_qstorno_1000_1200  | 
 21728  | 
 21571  | 
 157  | 
 0.72  | 
 0  | 
 21153  | 
 2276  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  x_make_qstorno_1200_2000  | 
 21740  | 
 21645  | 
 95  | 
 0.43  | 
 0  | 
 28564  | 
 3628  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  x_make_qstorno_2100_3300  | 
 623869  | 
 623869  | 
 0  | 
 0.00  | 
 0  | 
 15225  | 
 275  | 
 0  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
 
Done for 298270 ms, from  7:01:49.56 to  7:06:47.83.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 99  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2018-05-16 03:47  | 
 2018-05-16 06:42  | 
|  deadlock  | 
 105  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2018-05-16 03:48  | 
 2018-05-16 06:46  | 
|  deadlock  | 
 10171  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2018-05-16 03:46  | 
 2018-05-16 06:46  | 
|  deadlock  | 
 146  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2018-05-16 03:49  | 
 2018-05-16 06:45  | 
|  deadlock  | 
 162  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2018-05-16 03:47  | 
 2018-05-16 06:45  | 
|  deadlock  | 
 623  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2018-05-16 03:47  | 
 2018-05-16 06:46  | 
|  deadlock  | 
 321  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2018-05-16 03:48  | 
 2018-05-16 06:45  | 
|  user_exc  | 
 157  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2018-05-16 03:47  | 
 2018-05-16 06:45  | 
|  user_exc  | 
 95  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2018-05-16 03:47  | 
 2018-05-16 06:46  | 
 
Done for 8720 ms, from  7:06:55.12 to  7:07:03.84.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          442330
 
MON$OLDEST_ACTIVE               442331
 
MON$OLDEST_SNAPSHOT             442331
 
MON$NEXT_TRANSACTION            442331
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2017-01-11 15:12:20.4040
 
MON$PAGES                       836288
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.4.32972 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.4.32972 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.4.32972 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.4.32972 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Gstat execution time Wed May 16 07:07:04 2018 
 
 
Database header page information: 
 
Flags			0 
 
Generation		442551 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	442332 
 
Oldest active		442333 
 
Oldest snapshot		442333 
 
Next transaction	442334 
 
Sequence number		0 
 
Next attachment ID	9553 
 
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.06, total records: 2210538 
 
Average version length: 47.77, total versions: 5610, 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: 24064 
 
Data pages: 24064, average fill: 72% 
 
Primary pages: 24064, secondary pages: 0, swept pages: 15684 
 
Empty pages: 6, full pages: 18522 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 7 
 
40 - 59% = 68 
 
60 - 79% = 23978 
 
80 - 99% = 3 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10753, nodes: 2210538 
 
Average node length: 19.38, total dup: 0, max dup: 0 
 
Average key length: 16.42, compression ratio: 1.64 
 
Average prefix length: 13.57, average data length: 13.43 
 
Clustering factor: 544318, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 591 
 
20 - 39% = 2070 
 
40 - 59% = 5875 
 
60 - 79% = 913 
 
80 - 99% = 1304 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7948, nodes: 2210538 
 
Average node length: 11.64, total dup: 0, max dup: 0 
 
Average key length: 8.69, compression ratio: 1.04 
 
Average prefix length: 3.31, average data length: 5.69 
 
Clustering factor: 495400, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 3779 
 
40 - 59% = 4146 
 
60 - 79% = 22 
 
80 - 99% = 1 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 174585, depth: 3, leaf buckets: 4005, nodes: 2210538 
 
Average node length: 6.85, total dup: 1598287, max dup: 49 
 
Average key length: 3.90, compression ratio: 2.31 
 
Average prefix length: 7.38, average data length: 1.62 
 
Clustering factor: 504683, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 135 
 
20 - 39% = 1344 
 
40 - 59% = 1903 
 
60 - 79% = 120 
 
80 - 99% = 503 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.26, total records: 678994 
 
Average version length: 36.00, total versions: 3277, max versions: 4 
 
Average fragment length: 12.00, total fragments: 8, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8616 
 
Data pages: 8616, average fill: 75% 
 
Primary pages: 8613, secondary pages: 3, swept pages: 7411 
 
Empty pages: 3, full pages: 7703 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 3 
 
40 - 59% = 15 
 
60 - 79% = 8560 
 
80 - 99% = 31 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 254389, depth: 3, leaf buckets: 2536, nodes: 678994 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.18, average data length: 5.82 
 
Clustering factor: 179961, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1500 
 
40 - 59% = 1024 
 
60 - 79% = 11 
 
80 - 99% = 1 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 714, nodes: 678994 
 
Average node length: 4.88, total dup: 678944, max dup: 44977 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 312283, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 609 
 
60 - 79% = 76 
 
80 - 99% = 28 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 314834, depth: 3, leaf buckets: 2261, nodes: 678994 
 
Average node length: 11.68, total dup: 0, max dup: 0 
 
Average key length: 8.81, compression ratio: 1.02 
 
Average prefix length: 3.19, average data length: 5.81 
 
Clustering factor: 179961, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 143 
 
20 - 39% = 948 
 
40 - 59% = 845 
 
60 - 79% = 119 
 
80 - 99% = 206 
 
 
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.56, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 16.65, total fragments: 380, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.64 
 
Pointer pages: 2, data page slots: 349 
 
Data pages: 20, average fill: 31% 
 
Primary pages: 7, secondary pages: 13, swept pages: 4 
 
Empty pages: 8, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 4 
 
40 - 59% = 2 
 
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: 34.05, total records: 5795 
 
Average version length: 70.97, total versions: 3023, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 2.82 
 
Pointer pages: 2, data page slots: 2160 
 
Data pages: 304, average fill: 25% 
 
Primary pages: 303, secondary pages: 1, swept pages: 161 
 
Empty pages: 63, full pages: 4 
 
Fill distribution: 
 
0 - 19% = 138 
 
20 - 39% = 85 
 
40 - 59% = 61 
 
60 - 79% = 19 
 
80 - 99% = 1 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 27, nodes: 5795 
 
Average node length: 15.49, total dup: 134, max dup: 1 
 
Average key length: 12.85, compression ratio: 2.10 
 
Average prefix length: 17.12, average data length: 9.88 
 
Clustering factor: 5265, ratio: 0.91 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 14 
 
40 - 59% = 9 
 
60 - 79% = 4 
 
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: 13.10, total records: 226 
 
Average version length: 46.28, total versions: 162, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 4.88 
 
Pointer pages: 1, data page slots: 72 
 
Data pages: 48, average fill: 6% 
 
Primary pages: 46, secondary pages: 2, swept pages: 31 
 
Empty pages: 32, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 43 
 
20 - 39% = 3 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 1 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 251317, depth: 2, leaf buckets: 1, nodes: 226 
 
Average node length: 7.59, total dup: 174, max dup: 29 
 
Average key length: 5.58, compression ratio: 3.40 
 
Average prefix length: 15.64, average data length: 3.36 
 
Clustering factor: 120, ratio: 0.53 
 
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: 41.94, total records: 256489 
 
Average version length: 28.37, total versions: 6862, max versions: 9 
 
Average fragment length: 33.87, total fragments: 15, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.53 
 
Pointer pages: 2, data page slots: 3128 
 
Data pages: 3128, average fill: 62% 
 
Primary pages: 3094, secondary pages: 34, swept pages: 2456 
 
Empty pages: 13, full pages: 703 
 
Fill distribution: 
 
0 - 19% = 61 
 
20 - 39% = 239 
 
40 - 59% = 570 
 
60 - 79% = 2246 
 
80 - 99% = 12 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 240, nodes: 256489 
 
Average node length: 4.61, total dup: 256440, max dup: 11443 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 39914, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 17 
 
40 - 59% = 100 
 
60 - 79% = 101 
 
80 - 99% = 21 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 298, nodes: 256489 
 
Average node length: 5.56, total dup: 231258, max dup: 64 
 
Average key length: 2.95, compression ratio: 7.45 
 
Average prefix length: 21.14, average data length: 0.86 
 
Clustering factor: 49344, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 19 
 
40 - 59% = 146 
 
60 - 79% = 96 
 
80 - 99% = 35 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 280, nodes: 256489 
 
Average node length: 5.55, total dup: 231258, max dup: 64 
 
Average key length: 2.95, compression ratio: 7.45 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 49404, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 16 
 
40 - 59% = 112 
 
60 - 79% = 99 
 
80 - 99% = 52 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 288, nodes: 256489 
 
Average node length: 5.34, total dup: 231258, max dup: 64 
 
Average key length: 2.74, compression ratio: 3.28 
 
Average prefix length: 8.36, average data length: 0.64 
 
Clustering factor: 49458, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 38 
 
40 - 59% = 122 
 
60 - 79% = 86 
 
80 - 99% = 41 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.98, total records: 280614 
 
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: 2400 
 
Data pages: 2400, average fill: 64% 
 
Primary pages: 2400, secondary pages: 0, swept pages: 0 
 
Empty pages: 1, full pages: 2398 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 2398 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 249069, depth: 2, leaf buckets: 224, nodes: 280614 
 
Average node length: 4.54, total dup: 280433, max dup: 2805 
 
Average key length: 2.00, compression ratio: 1.28 
 
Average prefix length: 2.57, average data length: 0.00 
 
Clustering factor: 58363, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 84 
 
60 - 79% = 66 
 
80 - 99% = 73 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 1, used formats: 1 
 
Average record length: 151.85, total records: 11403581 
 
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.17 
 
Pointer pages: 166, data page slots: 270560 
 
Data pages: 270560, average fill: 87% 
 
Primary pages: 270560, secondary pages: 0, swept pages: 3 
 
Empty pages: 6, full pages: 270553 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 270553 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 12455, nodes: 11403581 
 
Average node length: 5.66, total dup: 10535823, max dup: 150 
 
Average key length: 2.18, compression ratio: 3.66 
 
Average prefix length: 7.86, average data length: 0.13 
 
Clustering factor: 5844617, ratio: 0.51 
 
Fill distribution: 
 
0 - 19% = 18 
 
20 - 39% = 0 
 
40 - 59% = 6032 
 
60 - 79% = 4381 
 
80 - 99% = 2024 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 11240, nodes: 11403581 
 
Average node length: 4.55, total dup: 11403577, max dup: 10572437 
 
Average key length: 1.07, compression ratio: 0.34 
 
Average prefix length: 0.36, average data length: 0.00 
 
Clustering factor: 351366, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 11234 
 
60 - 79% = 3 
 
80 - 99% = 2 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 13476, nodes: 11403581 
 
Average node length: 5.72, total dup: 11027244, max dup: 23973 
 
Average key length: 2.24, compression ratio: 4.01 
 
Average prefix length: 8.79, average data length: 0.21 
 
Clustering factor: 1142260, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 2 
 
40 - 59% = 9205 
 
60 - 79% = 2310 
 
80 - 99% = 1956 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 13925, nodes: 11403581 
 
Average node length: 5.55, total dup: 11372817, max dup: 1278307 
 
Average key length: 2.07, compression ratio: 18.20 
 
Average prefix length: 37.67, average data length: 0.07 
 
Clustering factor: 7406628, ratio: 0.65 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 2 
 
40 - 59% = 11995 
 
60 - 79% = 684 
 
80 - 99% = 1222 
 
 
PHRASES (145) 
 
Primary pointer page: 266, Index root page: 267 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.86, total records: 437175 
 
Average version length: 55.72, total versions: 1559, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.46 
 
Pointer pages: 4, data page slots: 5224 
 
Data pages: 5224, average fill: 74% 
 
Primary pages: 5224, secondary pages: 0, swept pages: 3768 
 
Empty pages: 6, full pages: 4458 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 2 
 
40 - 59% = 29 
 
60 - 79% = 5185 
 
80 - 99% = 0 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 631883, depth: 3, leaf buckets: 608, nodes: 437175 
 
Average node length: 6.03, total dup: 362353, max dup: 763 
 
Average key length: 3.24, compression ratio: 2.77 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 59712, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 17 
 
20 - 39% = 25 
 
40 - 59% = 412 
 
60 - 79% = 114 
 
80 - 99% = 40 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 459, nodes: 437175 
 
Average node length: 5.59, total dup: 390601, max dup: 130 
 
Average key length: 2.80, compression ratio: 3.21 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 106381, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 9 
 
40 - 59% = 169 
 
60 - 79% = 185 
 
80 - 99% = 94 
 
 
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.94, total records: 2672 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 6.49 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 61% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 32 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 264, Index root page: 265 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.23, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.73 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 78% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 67 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.86, total dup: 0, max dup: 0 
 
Average key length: 51.84, compression ratio: 1.00 
 
Average prefix length: 2.73, average data length: 48.86 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (260) 
 
Primary pointer page: 292, Index root page: 295 
 
Total formats: 1, used formats: 1 
 
Average record length: 49.49, total records: 6336 
 
Average version length: 72.21, total versions: 1994, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.75 
 
Pointer pages: 2, data page slots: 2552 
 
Data pages: 608, average fill: 14% 
 
Primary pages: 607, secondary pages: 1, swept pages: 448 
 
Empty pages: 265, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 469 
 
20 - 39% = 65 
 
40 - 59% = 33 
 
60 - 79% = 38 
 
80 - 99% = 3 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 15, nodes: 6336 
 
Average node length: 7.44, total dup: 5470, max dup: 14 
 
Average key length: 4.66, compression ratio: 7.94 
 
Average prefix length: 34.48, average data length: 2.52 
 
Clustering factor: 1050, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 8 
 
40 - 59% = 4 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.65, total records: 1353233 
 
Average version length: 71.82, total versions: 9938, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.90 
 
Pointer pages: 13, data page slots: 21168 
 
Data pages: 21136, average fill: 71% 
 
Primary pages: 21136, secondary pages: 0, swept pages: 13698 
 
Empty pages: 231, full pages: 15050 
 
Fill distribution: 
 
0 - 19% = 442 
 
20 - 39% = 672 
 
40 - 59% = 1613 
 
60 - 79% = 18321 
 
80 - 99% = 88 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 345398, depth: 3, leaf buckets: 1573, nodes: 1353233 
 
Average node length: 5.13, total dup: 1319283, max dup: 132 
 
Average key length: 2.19, compression ratio: 4.12 
 
Average prefix length: 8.84, average data length: 0.16 
 
Clustering factor: 150685, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 92 
 
40 - 59% = 1203 
 
60 - 79% = 48 
 
80 - 99% = 208 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 238152, depth: 3, leaf buckets: 1995, nodes: 1353233 
 
Average node length: 6.26, total dup: 1182845, max dup: 19 
 
Average key length: 3.31, compression ratio: 11.17 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 258194, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 34 
 
20 - 39% = 171 
 
40 - 59% = 1554 
 
60 - 79% = 149 
 
80 - 99% = 87 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 51.12, total records: 27600 
 
Average version length: 72.15, total versions: 8030, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.66 
 
Pointer pages: 4, data page slots: 5320 
 
Data pages: 2321, average fill: 15% 
 
Primary pages: 2316, secondary pages: 5, swept pages: 1737 
 
Empty pages: 1127, full pages: 113 
 
Fill distribution: 
 
0 - 19% = 1669 
 
20 - 39% = 338 
 
40 - 59% = 143 
 
60 - 79% = 132 
 
80 - 99% = 39 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 1095, depth: 2, leaf buckets: 60, nodes: 27600 
 
Average node length: 6.51, total dup: 24396, max dup: 48 
 
Average key length: 3.58, compression ratio: 10.34 
 
Average prefix length: 35.53, average data length: 1.47 
 
Clustering factor: 3570, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 34 
 
40 - 59% = 22 
 
60 - 79% = 4 
 
80 - 99% = 0 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 68.14, total records: 1717808 
 
Average version length: 71.89, total versions: 96202, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.00 
 
Pointer pages: 18, data page slots: 29128 
 
Data pages: 29056, average fill: 66% 
 
Primary pages: 29055, secondary pages: 1, swept pages: 18197 
 
Empty pages: 332, full pages: 15373 
 
Fill distribution: 
 
0 - 19% = 875 
 
20 - 39% = 1900 
 
40 - 59% = 4890 
 
60 - 79% = 19822 
 
80 - 99% = 1569 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 196318, depth: 3, leaf buckets: 2723, nodes: 1717808 
 
Average node length: 5.61, total dup: 1615254, max dup: 63 
 
Average key length: 2.65, compression ratio: 13.94 
 
Average prefix length: 36.40, average data length: 0.60 
 
Clustering factor: 249024, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 1218 
 
40 - 59% = 1072 
 
60 - 79% = 266 
 
80 - 99% = 145 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 10.90, total records: 5018 
 
Average version length: 70.38, total versions: 4243, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 12.48 
 
Pointer pages: 4, data page slots: 4216 
 
Data pages: 720, average fill: 10% 
 
Primary pages: 716, secondary pages: 4, swept pages: 469 
 
Empty pages: 467, full pages: 24 
 
Fill distribution: 
 
0 - 19% = 608 
 
20 - 39% = 41 
 
40 - 59% = 28 
 
60 - 79% = 29 
 
80 - 99% = 14 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 15, nodes: 5018 
 
Average node length: 8.82, total dup: 3972, max dup: 38 
 
Average key length: 5.83, compression ratio: 6.34 
 
Average prefix length: 33.37, average data length: 3.63 
 
Clustering factor: 805, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 10 
 
40 - 59% = 4 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.77, total records: 2792299 
 
Average version length: 71.21, total versions: 32206, 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: 25, data page slots: 40672 
 
Data pages: 40672, average fill: 75% 
 
Primary pages: 40672, secondary pages: 0, swept pages: 30827 
 
Empty pages: 11, full pages: 33249 
 
Fill distribution: 
 
0 - 19% = 52 
 
20 - 39% = 172 
 
40 - 59% = 1061 
 
60 - 79% = 38719 
 
80 - 99% = 668 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5687, nodes: 2792299 
 
Average node length: 6.89, total dup: 2259262, max dup: 19 
 
Average key length: 3.92, compression ratio: 9.45 
 
Average prefix length: 35.27, average data length: 1.73 
 
Clustering factor: 596865, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 2913 
 
40 - 59% = 2314 
 
60 - 79% = 270 
 
80 - 99% = 180 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.76, total records: 4844254 
 
Average version length: 84.23, total versions: 3747, 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: 46, data page slots: 74568 
 
Data pages: 74568, average fill: 80% 
 
Primary pages: 74568, secondary pages: 0, swept pages: 29695 
 
Empty pages: 8, full pages: 73846 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 5 
 
40 - 59% = 40 
 
60 - 79% = 22523 
 
80 - 99% = 51989 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4933, nodes: 4844254 
 
Average node length: 5.16, total dup: 4733724, max dup: 132 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 787153, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 78 
 
40 - 59% = 2126 
 
60 - 79% = 2128 
 
80 - 99% = 579 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 5718, nodes: 4844254 
 
Average node length: 5.69, total dup: 4339040, max dup: 49 
 
Average key length: 2.71, compression ratio: 3.32 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 287098, ratio: 0.06 
 
Fill distribution: 
 
0 - 19% = 54 
 
20 - 39% = 195 
 
40 - 59% = 3843 
 
60 - 79% = 238 
 
80 - 99% = 1388 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5490, nodes: 4844254 
 
Average node length: 5.81, total dup: 4239034, max dup: 29 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 844205, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 26 
 
20 - 39% = 86 
 
40 - 59% = 2360 
 
60 - 79% = 2170 
 
80 - 99% = 848 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.53, total records: 2308021 
 
Average version length: 83.44, total versions: 17709, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.65 
 
Pointer pages: 23, data page slots: 36552 
 
Data pages: 36552, average fill: 78% 
 
Primary pages: 36552, secondary pages: 0, swept pages: 27385 
 
Empty pages: 16, full pages: 32947 
 
Fill distribution: 
 
0 - 19% = 70 
 
20 - 39% = 217 
 
40 - 59% = 616 
 
60 - 79% = 17502 
 
80 - 99% = 18147 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2470, nodes: 2308021 
 
Average node length: 5.15, total dup: 2254137, max dup: 188 
 
Average key length: 2.18, compression ratio: 4.13 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 359624, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 46 
 
40 - 59% = 1455 
 
60 - 79% = 730 
 
80 - 99% = 238 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4130, nodes: 2308021 
 
Average node length: 6.21, total dup: 1898352, max dup: 14 
 
Average key length: 3.24, compression ratio: 2.78 
 
Average prefix length: 7.93, average data length: 1.07 
 
Clustering factor: 253649, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 107 
 
20 - 39% = 1862 
 
40 - 59% = 1621 
 
60 - 79% = 386 
 
80 - 99% = 154 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 2851, nodes: 2308021 
 
Average node length: 5.81, total dup: 2020044, max dup: 36 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 428149, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 45 
 
40 - 59% = 1776 
 
60 - 79% = 757 
 
80 - 99% = 251 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.17, total records: 5160293 
 
Average version length: 85.61, total versions: 45284, 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: 51, data page slots: 81808 
 
Data pages: 81808, average fill: 78% 
 
Primary pages: 81808, secondary pages: 0, swept pages: 30953 
 
Empty pages: 163, full pages: 73559 
 
Fill distribution: 
 
0 - 19% = 337 
 
20 - 39% = 711 
 
40 - 59% = 2317 
 
60 - 79% = 22855 
 
80 - 99% = 55588 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5588, nodes: 5160293 
 
Average node length: 5.04, total dup: 5130259, max dup: 685 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 805357, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 332 
 
40 - 59% = 3271 
 
60 - 79% = 1485 
 
80 - 99% = 493 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 6579, nodes: 5160293 
 
Average node length: 5.53, total dup: 4751840, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.54 
 
Average prefix length: 8.53, average data length: 0.47 
 
Clustering factor: 351967, ratio: 0.07 
 
Fill distribution: 
 
0 - 19% = 84 
 
20 - 39% = 1993 
 
40 - 59% = 2737 
 
60 - 79% = 543 
 
80 - 99% = 1222 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 6302, nodes: 5160293 
 
Average node length: 5.68, total dup: 4634795, max dup: 98 
 
Average key length: 2.69, compression ratio: 3.34 
 
Average prefix length: 8.41, average data length: 0.59 
 
Clustering factor: 887807, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 320 
 
40 - 59% = 3788 
 
60 - 79% = 1667 
 
80 - 99% = 522 
 
 
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.05, total records: 3517301 
 
Average version length: 84.10, total versions: 24673, 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: 35, data page slots: 55840 
 
Data pages: 55840, average fill: 78% 
 
Primary pages: 55840, secondary pages: 0, swept pages: 41805 
 
Empty pages: 22, full pages: 50070 
 
Fill distribution: 
 
0 - 19% = 93 
 
20 - 39% = 178 
 
40 - 59% = 844 
 
60 - 79% = 26747 
 
80 - 99% = 27978 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3758, nodes: 3517301 
 
Average node length: 5.03, total dup: 3499461, max dup: 1278 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 806233, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 33 
 
20 - 39% = 306 
 
40 - 59% = 1988 
 
60 - 79% = 980 
 
80 - 99% = 451 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 6581, nodes: 3517301 
 
Average node length: 6.24, total dup: 2881263, max dup: 14 
 
Average key length: 3.26, compression ratio: 2.76 
 
Average prefix length: 7.92, average data length: 1.08 
 
Clustering factor: 451415, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 260 
 
20 - 39% = 3168 
 
40 - 59% = 2419 
 
60 - 79% = 507 
 
80 - 99% = 227 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4120, nodes: 3517301 
 
Average node length: 5.60, total dup: 3205271, max dup: 91 
 
Average key length: 2.62, compression ratio: 3.44 
 
Average prefix length: 8.47, average data length: 0.53 
 
Clustering factor: 841061, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 9 
 
20 - 39% = 335 
 
40 - 59% = 2074 
 
60 - 79% = 1184 
 
80 - 99% = 518 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.04, total records: 736782 
 
Average version length: 69.64, total versions: 4247, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.97 
 
Pointer pages: 7, data page slots: 10368 
 
Data pages: 10368, average fill: 75% 
 
Primary pages: 10368, secondary pages: 0, swept pages: 8025 
 
Empty pages: 10, full pages: 9353 
 
Fill distribution: 
 
0 - 19% = 63 
 
20 - 39% = 134 
 
40 - 59% = 252 
 
60 - 79% = 9818 
 
80 - 99% = 101 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 176808, depth: 3, leaf buckets: 863, nodes: 736782 
 
Average node length: 5.30, total dup: 697534, max dup: 119 
 
Average key length: 2.41, compression ratio: 3.74 
 
Average prefix length: 8.65, average data length: 0.35 
 
Clustering factor: 57991, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 162 
 
40 - 59% = 366 
 
60 - 79% = 242 
 
80 - 99% = 93 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 982, nodes: 736782 
 
Average node length: 5.93, total dup: 631400, max dup: 29 
 
Average key length: 3.03, compression ratio: 2.97 
 
Average prefix length: 8.11, average data length: 0.89 
 
Clustering factor: 63694, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 211 
 
40 - 59% = 402 
 
60 - 79% = 273 
 
80 - 99% = 93 
 
 
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 Wed May 16 07:10:09 2018 
 
 
Done for 185600 ms, from  7:07:04.19 to  7:10:09.79. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2210538  | 
 5610  | 
 0.2537  | 
|  DOC_LIST  | 
 678994  | 
 3277  | 
 0.4826  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 0  | 
 0.0000  | 
|  INVNT_TURNOVER_LOG  | 
 5795  | 
 3023  | 
 52.1656  | 
|  MONEY_SALDO  | 
 49  | 
 0  | 
 0.0000  | 
|  MONEY_TURNOVER_LOG  | 
 226  | 
 162  | 
 71.6814  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 256489  | 
 6862  | 
 2.6753  | 
|  PERF_ESTIMATED  | 
 280614  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 11403581  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 437175  | 
 1559  | 
 0.3566  | 
|  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  | 
 2672  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 6336  | 
 1994  | 
 31.4709  | 
|  XQD_1000_3300  | 
 1353233  | 
 9938  | 
 0.7343  | 
|  XQD_1200_2000  | 
 27600  | 
 8030  | 
 29.0942  | 
|  XQD_2000_3300  | 
 1717808  | 
 96202  | 
 5.6002  | 
|  XQD_2100_3300  | 
 5018  | 
 4243  | 
 84.5555  | 
|  XQD_3300_3400  | 
 2792299  | 
 32206  | 
 1.1533  | 
|  XQS_1000_1200  | 
 4844254  | 
 3747  | 
 0.0773  | 
|  XQS_1000_3300  | 
 2308021  | 
 17709  | 
 0.7672  | 
|  XQS_1200_2000  | 
 5160293  | 
 45284  | 
 0.8775  | 
|  XQS_2100_3300  | 
 3517301  | 
 24673  | 
 0.7014  | 
|  XQS_3300_3400  | 
 736782  | 
 4247  | 
 0.5764  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2030 ms, from  7:10:21.72 to  7:10:23.75.  
07:10:23.83 Validation started 
 
 
07:10:23.83 Relation 140 (DOC_LIST) 
 
07:10:23.83   process pointer page    0 of    6 
 
07:10:23.89   process pointer page    1 of    6 
 
07:10:24.00   process pointer page    2 of    6 
 
07:10:24.11   process pointer page    3 of    6 
 
07:10:24.22   process pointer page    4 of    6 
 
07:10:24.33   process pointer page    5 of    6 
 
07:10:24.36 Index 1 (PK_DOC_LIST) 
 
07:10:24.51 Index 2 (DOC_LIST_ID_DESC) 
 
07:10:24.62 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:10:24.70 Relation 140 (DOC_LIST) is ok 
 
 
07:10:24.70 Relation 141 (DOC_DATA) 
 
07:10:24.70   process pointer page    0 of   15 
 
07:10:24.73   process pointer page    1 of   15 
 
07:10:24.76   process pointer page    2 of   15 
 
07:10:24.78   process pointer page    3 of   15 
 
07:10:24.81   process pointer page    4 of   15 
 
07:10:24.84   process pointer page    5 of   15 
 
07:10:24.86   process pointer page    6 of   15 
 
07:10:24.89   process pointer page    7 of   15 
 
07:10:24.94   process pointer page    8 of   15 
 
07:10:24.97   process pointer page    9 of   15 
 
07:10:25.00   process pointer page   10 of   15 
 
07:10:25.01   process pointer page   11 of   15 
 
07:10:25.04   process pointer page   12 of   15 
 
07:10:25.08   process pointer page   13 of   15 
 
07:10:25.09   process pointer page   14 of   15 
 
07:10:25.12 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:10:26.04 Index 3 (DOC_DATA_ID_DESC) 
 
07:10:26.53 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:10:27.06 Relation 141 (DOC_DATA) is ok 
 
 
07:10:27.06 Relation 147 (INVNT_SALDO) 
 
07:10:27.07   process pointer page    0 of    2 
 
07:10:27.07   process pointer page    1 of    2 
 
07:10:27.07 Index 1 (PK_INVNT_SALDO) 
 
07:10:27.07 Relation 147 (INVNT_SALDO) is ok 
 
 
07:10:27.07 Relation 150 (PDISTR) 
 
07:10:27.07   process pointer page    0 of    2 
 
07:10:27.12   process pointer page    1 of    2 
 
07:10:27.15 Index 2 (PDISTR_SND_ID) 
 
07:10:27.18 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:10:27.21 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:10:27.24 Index 5 (PDISTR_AGENT_ID) 
 
07:10:27.26 Relation 150 (PDISTR) is ok 
 
 
07:10:27.26 Relation 151 (PSTORNED) 
 
07:10:27.26   process pointer page    0 of    4 
 
07:10:27.31   process pointer page    1 of    4 
 
07:10:27.40   process pointer page    2 of    4 
 
07:10:27.45   process pointer page    3 of    4 
 
07:10:27.46 Index 2 (PSTORNED_SND_ID) 
 
07:10:27.51 Index 3 (PSTORNED_RCV_ID) 
 
07:10:27.56 Relation 151 (PSTORNED) is ok 
 
 
07:10:27.56 Relation 156 (SEMAPHORES) 
 
07:10:27.56   process pointer page    0 of    1 
 
07:10:27.56 Index 1 (PK_SEMAPHORES) 
 
07:10:27.56 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:10:27.56 Relation 156 (SEMAPHORES) is ok 
 
 
07:10:27.56 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:10:27.56   process pointer page    0 of    2 
 
07:10:27.57   process pointer page    1 of    2 
 
07:10:27.57 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:10:27.57 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:10:27.57 Relation 160 (PERF_ESTIMATED) 
 
07:10:27.57   process pointer page    0 of    2 
 
07:10:27.65   process pointer page    1 of    2 
 
07:10:27.70 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:10:27.79 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:10:27.79 Relation 161 (PERF_ISQL_STAT) 
 
07:10:27.79   process pointer page    0 of    1 
 
07:10:27.79 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:10:27.79 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:10:27.79 Relation 162 (TRACE_STAT) 
 
07:10:27.79   process pointer page    0 of    1 
 
07:10:27.79 Relation 162 (TRACE_STAT) is ok 
 
 
07:10:27.79 Relation 163 (PERF_LOG) 
 
07:10:27.79   process pointer page    0 of  166 
 
07:10:27.87   process pointer page    1 of  166 
 
07:10:27.95   process pointer page    2 of  166 
 
07:10:28.02   process pointer page    3 of  166 
 
07:10:28.07   process pointer page    4 of  166 
 
07:10:28.10   process pointer page    5 of  166 
 
07:10:28.13   process pointer page    6 of  166 
 
07:10:28.21   process pointer page    7 of  166 
 
07:10:28.29   process pointer page    8 of  166 
 
07:10:28.37   process pointer page    9 of  166 
 
07:10:28.46   process pointer page   10 of  166 
 
07:10:28.54   process pointer page   11 of  166 
 
07:10:28.62   process pointer page   12 of  166 
 
07:10:28.70   process pointer page   13 of  166 
 
07:10:28.77   process pointer page   14 of  166 
 
07:10:28.87   process pointer page   15 of  166 
 
07:10:28.94   process pointer page   16 of  166 
 
07:10:29.02   process pointer page   17 of  166 
 
07:10:29.09   process pointer page   18 of  166 
 
07:10:29.12   process pointer page   19 of  166 
 
07:10:29.19   process pointer page   20 of  166 
 
07:10:29.27   process pointer page   21 of  166 
 
07:10:29.35   process pointer page   22 of  166 
 
07:10:29.40   process pointer page   23 of  166 
 
07:10:29.43   process pointer page   24 of  166 
 
07:10:29.46   process pointer page   25 of  166 
 
07:10:29.49   process pointer page   26 of  166 
 
07:10:29.52   process pointer page   27 of  166 
 
07:10:29.55   process pointer page   28 of  166 
 
07:10:29.57   process pointer page   29 of  166 
 
07:10:29.60   process pointer page   30 of  166 
 
07:10:29.63   process pointer page   31 of  166 
 
07:10:29.65   process pointer page   32 of  166 
 
07:10:29.68   process pointer page   33 of  166 
 
07:10:29.71   process pointer page   34 of  166 
 
07:10:29.72   process pointer page   35 of  166 
 
07:10:29.74   process pointer page   36 of  166 
 
07:10:29.77   process pointer page   37 of  166 
 
07:10:29.79   process pointer page   38 of  166 
 
07:10:29.82   process pointer page   39 of  166 
 
07:10:29.83   process pointer page   40 of  166 
 
07:10:29.87   process pointer page   41 of  166 
 
07:10:29.88   process pointer page   42 of  166 
 
07:10:29.91   process pointer page   43 of  166 
 
07:10:29.93   process pointer page   44 of  166 
 
07:10:29.94   process pointer page   45 of  166 
 
07:10:29.97   process pointer page   46 of  166 
 
07:10:29.99   process pointer page   47 of  166 
 
07:10:30.02   process pointer page   48 of  166 
 
07:10:30.04   process pointer page   49 of  166 
 
07:10:30.07   process pointer page   50 of  166 
 
07:10:30.08   process pointer page   51 of  166 
 
07:10:30.11   process pointer page   52 of  166 
 
07:10:30.13   process pointer page   53 of  166 
 
07:10:30.16   process pointer page   54 of  166 
 
07:10:30.18   process pointer page   55 of  166 
 
07:10:30.19   process pointer page   56 of  166 
 
07:10:30.22   process pointer page   57 of  166 
 
07:10:30.24   process pointer page   58 of  166 
 
07:10:30.27   process pointer page   59 of  166 
 
07:10:30.30   process pointer page   60 of  166 
 
07:10:30.33   process pointer page   61 of  166 
 
07:10:30.41   process pointer page   62 of  166 
 
07:10:30.44   process pointer page   63 of  166 
 
07:10:30.47   process pointer page   64 of  166 
 
07:10:30.50   process pointer page   65 of  166 
 
07:10:30.57   process pointer page   66 of  166 
 
07:10:30.65   process pointer page   67 of  166 
 
07:10:30.72   process pointer page   68 of  166 
 
07:10:30.80   process pointer page   69 of  166 
 
07:10:30.88   process pointer page   70 of  166 
 
07:10:30.96   process pointer page   71 of  166 
 
07:10:31.04   process pointer page   72 of  166 
 
07:10:31.13   process pointer page   73 of  166 
 
07:10:31.21   process pointer page   74 of  166 
 
07:10:31.28   process pointer page   75 of  166 
 
07:10:31.36   process pointer page   76 of  166 
 
07:10:31.44   process pointer page   77 of  166 
 
07:10:31.47   process pointer page   78 of  166 
 
07:10:31.50   process pointer page   79 of  166 
 
07:10:31.53   process pointer page   80 of  166 
 
07:10:31.57   process pointer page   81 of  166 
 
07:10:31.60   process pointer page   82 of  166 
 
07:10:31.61   process pointer page   83 of  166 
 
07:10:31.71   process pointer page   84 of  166 
 
07:10:31.75   process pointer page   85 of  166 
 
07:10:31.78   process pointer page   86 of  166 
 
07:10:31.82   process pointer page   87 of  166 
 
07:10:31.88   process pointer page   88 of  166 
 
07:10:31.96   process pointer page   89 of  166 
 
07:10:32.05   process pointer page   90 of  166 
 
07:10:32.10   process pointer page   91 of  166 
 
07:10:32.13   process pointer page   92 of  166 
 
07:10:32.16   process pointer page   93 of  166 
 
07:10:32.19   process pointer page   94 of  166 
 
07:10:32.22   process pointer page   95 of  166 
 
07:10:32.25   process pointer page   96 of  166 
 
07:10:32.28   process pointer page   97 of  166 
 
07:10:32.33   process pointer page   98 of  166 
 
07:10:32.41   process pointer page   99 of  166 
 
07:10:32.45   process pointer page  100 of  166 
 
07:10:32.49   process pointer page  101 of  166 
 
07:10:32.52   process pointer page  102 of  166 
 
07:10:32.55   process pointer page  103 of  166 
 
07:10:32.58   process pointer page  104 of  166 
 
07:10:32.61   process pointer page  105 of  166 
 
07:10:32.64   process pointer page  106 of  166 
 
07:10:32.67   process pointer page  107 of  166 
 
07:10:32.70   process pointer page  108 of  166 
 
07:10:32.74   process pointer page  109 of  166 
 
07:10:32.77   process pointer page  110 of  166 
 
07:10:32.83   process pointer page  111 of  166 
 
07:10:32.86   process pointer page  112 of  166 
 
07:10:32.89   process pointer page  113 of  166 
 
07:10:32.92   process pointer page  114 of  166 
 
07:10:32.99   process pointer page  115 of  166 
 
07:10:33.02   process pointer page  116 of  166 
 
07:10:33.11   process pointer page  117 of  166 
 
07:10:33.19   process pointer page  118 of  166 
 
07:10:33.22   process pointer page  119 of  166 
 
07:10:33.25   process pointer page  120 of  166 
 
07:10:33.28   process pointer page  121 of  166 
 
07:10:33.31   process pointer page  122 of  166 
 
07:10:33.36   process pointer page  123 of  166 
 
07:10:33.44   process pointer page  124 of  166 
 
07:10:33.52   process pointer page  125 of  166 
 
07:10:33.61   process pointer page  126 of  166 
 
07:10:33.69   process pointer page  127 of  166 
 
07:10:33.77   process pointer page  128 of  166 
 
07:10:33.84   process pointer page  129 of  166 
 
07:10:33.92   process pointer page  130 of  166 
 
07:10:34.00   process pointer page  131 of  166 
 
07:10:34.05   process pointer page  132 of  166 
 
07:10:34.08   process pointer page  133 of  166 
 
07:10:34.11   process pointer page  134 of  166 
 
07:10:34.14   process pointer page  135 of  166 
 
07:10:34.17   process pointer page  136 of  166 
 
07:10:34.20   process pointer page  137 of  166 
 
07:10:34.23   process pointer page  138 of  166 
 
07:10:34.26   process pointer page  139 of  166 
 
07:10:34.30   process pointer page  140 of  166 
 
07:10:34.33   process pointer page  141 of  166 
 
07:10:34.34   process pointer page  142 of  166 
 
07:10:34.37   process pointer page  143 of  166 
 
07:10:34.40   process pointer page  144 of  166 
 
07:10:34.45   process pointer page  145 of  166 
 
07:10:34.53   process pointer page  146 of  166 
 
07:10:34.56   process pointer page  147 of  166 
 
07:10:34.59   process pointer page  148 of  166 
 
07:10:34.62   process pointer page  149 of  166 
 
07:10:34.65   process pointer page  150 of  166 
 
07:10:34.69   process pointer page  151 of  166 
 
07:10:34.72   process pointer page  152 of  166 
 
07:10:34.76   process pointer page  153 of  166 
 
07:10:34.79   process pointer page  154 of  166 
 
07:10:34.83   process pointer page  155 of  166 
 
07:10:34.86   process pointer page  156 of  166 
 
07:10:34.92   process pointer page  157 of  166 
 
07:10:34.98   process pointer page  158 of  166 
 
07:10:35.01   process pointer page  159 of  166 
 
07:10:35.09   process pointer page  160 of  166 
 
07:10:35.12   process pointer page  161 of  166 
 
07:10:35.15   process pointer page  162 of  166 
 
07:10:35.18   process pointer page  163 of  166 
 
07:10:35.22   process pointer page  164 of  166 
 
07:10:35.23   process pointer page  165 of  166 
 
07:10:35.26 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:10:39.05 Index 2 (PERF_LOG_UNIT) 
 
07:10:42.63 Index 3 (PERF_LOG_TRN_DESC) 
 
07:10:43.91 Index 4 (PERF_LOG_GDSCODE) 
 
07:10:45.36 Relation 163 (PERF_LOG) is ok 
 
 
07:10:45.36 Relation 167 (V_STOPTEST) 
 
07:10:45.36 Relation 167 (V_STOPTEST) is ok 
 
 
07:10:45.36 Relation 184 (V_QDISTR_SOURCE) 
 
07:10:45.36 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:10:45.36 Relation 185 (V_QSTORNED_SOURCE) 
 
07:10:45.36 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:10:45.36 Relation 260 (XQD_1000_1200) 
 
07:10:45.36   process pointer page    0 of    2 
 
07:10:45.37   process pointer page    1 of    2 
 
07:10:45.37 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:10:45.37 Relation 260 (XQD_1000_1200) is ok 
 
 
07:10:45.37 Relation 261 (XQD_1200_2000) 
 
07:10:45.37   process pointer page    0 of    4 
 
07:10:45.39   process pointer page    1 of    4 
 
07:10:45.39   process pointer page    2 of    4 
 
07:10:45.40   process pointer page    3 of    4 
 
07:10:45.42 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:10:45.42 Relation 261 (XQD_1200_2000) is ok 
 
 
07:10:45.42 Relation 262 (XQD_1000_3300) 
 
07:10:45.42   process pointer page    0 of   13 
 
07:10:45.45   process pointer page    1 of   13 
 
07:10:45.48   process pointer page    2 of   13 
 
07:10:45.51   process pointer page    3 of   13 
 
07:10:45.54   process pointer page    4 of   13 
 
07:10:45.57   process pointer page    5 of   13 
 
07:10:45.61   process pointer page    6 of   13 
 
07:10:45.64   process pointer page    7 of   13 
 
07:10:45.65   process pointer page    8 of   13 
 
07:10:45.68   process pointer page    9 of   13 
 
07:10:45.71   process pointer page   10 of   13 
 
07:10:45.73   process pointer page   11 of   13 
 
07:10:45.76   process pointer page   12 of   13 
 
07:10:45.78 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:10:45.92 Index 2 (XQD_1000_3300_DOC) 
 
07:10:46.09 Relation 262 (XQD_1000_3300) is ok 
 
 
07:10:46.09 Relation 263 (XQD_2000_3300) 
 
07:10:46.09   process pointer page    0 of   18 
 
07:10:46.18   process pointer page    1 of   18 
 
07:10:46.28   process pointer page    2 of   18 
 
07:10:46.35   process pointer page    3 of   18 
 
07:10:46.40   process pointer page    4 of   18 
 
07:10:46.45   process pointer page    5 of   18 
 
07:10:46.48   process pointer page    6 of   18 
 
07:10:46.53   process pointer page    7 of   18 
 
07:10:46.56   process pointer page    8 of   18 
 
07:10:46.60   process pointer page    9 of   18 
 
07:10:46.70   process pointer page   10 of   18 
 
07:10:46.79   process pointer page   11 of   18 
 
07:10:46.88   process pointer page   12 of   18 
 
07:10:46.96   process pointer page   13 of   18 
 
07:10:47.06   process pointer page   14 of   18 
 
07:10:47.10   process pointer page   15 of   18 
 
07:10:47.13   process pointer page   16 of   18 
 
07:10:47.18   process pointer page   17 of   18 
 
07:10:47.20 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:10:47.52 Relation 263 (XQD_2000_3300) is ok 
 
 
07:10:47.52 Relation 264 (XQD_2100_3300) 
 
07:10:47.52   process pointer page    0 of    4 
 
07:10:47.52   process pointer page    1 of    4 
 
07:10:47.52   process pointer page    2 of    4 
 
07:10:47.54   process pointer page    3 of    4 
 
07:10:47.54 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:10:47.54 Relation 264 (XQD_2100_3300) is ok 
 
 
07:10:47.54 Relation 265 (XQD_3300_3400) 
 
07:10:47.54   process pointer page    0 of   25 
 
07:10:47.57   process pointer page    1 of   25 
 
07:10:47.65   process pointer page    2 of   25 
 
07:10:47.68   process pointer page    3 of   25 
 
07:10:47.71   process pointer page    4 of   25 
 
07:10:47.74   process pointer page    5 of   25 
 
07:10:47.77   process pointer page    6 of   25 
 
07:10:47.87   process pointer page    7 of   25 
 
07:10:47.93   process pointer page    8 of   25 
 
07:10:47.98   process pointer page    9 of   25 
 
07:10:48.01   process pointer page   10 of   25 
 
07:10:48.04   process pointer page   11 of   25 
 
07:10:48.07   process pointer page   12 of   25 
 
07:10:48.10   process pointer page   13 of   25 
 
07:10:48.13   process pointer page   14 of   25 
 
07:10:48.16   process pointer page   15 of   25 
 
07:10:48.23   process pointer page   16 of   25 
 
07:10:48.32   process pointer page   17 of   25 
 
07:10:48.41   process pointer page   18 of   25 
 
07:10:48.49   process pointer page   19 of   25 
 
07:10:48.59   process pointer page   20 of   25 
 
07:10:48.66   process pointer page   21 of   25 
 
07:10:48.76   process pointer page   22 of   25 
 
07:10:48.85   process pointer page   23 of   25 
 
07:10:48.93   process pointer page   24 of   25 
 
07:10:49.01 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:10:49.96 Relation 265 (XQD_3300_3400) is ok 
 
 
07:10:49.96 Relation 266 (XQS_1000_1200) 
 
07:10:49.97   process pointer page    0 of   46 
 
07:10:50.05   process pointer page    1 of   46 
 
07:10:50.10   process pointer page    2 of   46 
 
07:10:50.16   process pointer page    3 of   46 
 
07:10:50.24   process pointer page    4 of   46 
 
07:10:50.33   process pointer page    5 of   46 
 
07:10:50.41   process pointer page    6 of   46 
 
07:10:50.50   process pointer page    7 of   46 
 
07:10:50.60   process pointer page    8 of   46 
 
07:10:50.68   process pointer page    9 of   46 
 
07:10:50.72   process pointer page   10 of   46 
 
07:10:50.78   process pointer page   11 of   46 
 
07:10:50.86   process pointer page   12 of   46 
 
07:10:50.96   process pointer page   13 of   46 
 
07:10:51.00   process pointer page   14 of   46 
 
07:10:51.03   process pointer page   15 of   46 
 
07:10:51.08   process pointer page   16 of   46 
 
07:10:51.11   process pointer page   17 of   46 
 
07:10:51.17   process pointer page   18 of   46 
 
07:10:51.27   process pointer page   19 of   46 
 
07:10:51.30   process pointer page   20 of   46 
 
07:10:51.36   process pointer page   21 of   46 
 
07:10:51.46   process pointer page   22 of   46 
 
07:10:51.53   process pointer page   23 of   46 
 
07:10:51.63   process pointer page   24 of   46 
 
07:10:51.69   process pointer page   25 of   46 
 
07:10:51.72   process pointer page   26 of   46 
 
07:10:51.78   process pointer page   27 of   46 
 
07:10:51.81   process pointer page   28 of   46 
 
07:10:51.91   process pointer page   29 of   46 
 
07:10:51.99   process pointer page   30 of   46 
 
07:10:52.08   process pointer page   31 of   46 
 
07:10:52.11   process pointer page   32 of   46 
 
07:10:52.14   process pointer page   33 of   46 
 
07:10:52.17   process pointer page   34 of   46 
 
07:10:52.25   process pointer page   35 of   46 
 
07:10:52.30   process pointer page   36 of   46 
 
07:10:52.33   process pointer page   37 of   46 
 
07:10:52.38   process pointer page   38 of   46 
 
07:10:52.44   process pointer page   39 of   46 
 
07:10:52.50   process pointer page   40 of   46 
 
07:10:52.53   process pointer page   41 of   46 
 
07:10:52.56   process pointer page   42 of   46 
 
07:10:52.59   process pointer page   43 of   46 
 
07:10:52.64   process pointer page   44 of   46 
 
07:10:52.67   process pointer page   45 of   46 
 
07:10:52.69 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:10:53.95 Index 2 (XQS_1000_1200_SND_ID) 
 
07:10:54.56 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:10:54.92 Relation 266 (XQS_1000_1200) is ok 
 
 
07:10:54.92 Relation 267 (XQS_1200_2000) 
 
07:10:54.92   process pointer page    0 of   51 
 
07:10:54.93   process pointer page    1 of   51 
 
07:10:54.97   process pointer page    2 of   51 
 
07:10:54.98   process pointer page    3 of   51 
 
07:10:55.01   process pointer page    4 of   51 
 
07:10:55.04   process pointer page    5 of   51 
 
07:10:55.07   process pointer page    6 of   51 
 
07:10:55.12   process pointer page    7 of   51 
 
07:10:55.15   process pointer page    8 of   51 
 
07:10:55.20   process pointer page    9 of   51 
 
07:10:55.25   process pointer page   10 of   51 
 
07:10:55.31   process pointer page   11 of   51 
 
07:10:55.37   process pointer page   12 of   51 
 
07:10:55.40   process pointer page   13 of   51 
 
07:10:55.45   process pointer page   14 of   51 
 
07:10:55.50   process pointer page   15 of   51 
 
07:10:55.53   process pointer page   16 of   51 
 
07:10:55.57   process pointer page   17 of   51 
 
07:10:55.61   process pointer page   18 of   51 
 
07:10:55.64   process pointer page   19 of   51 
 
07:10:55.67   process pointer page   20 of   51 
 
07:10:55.78   process pointer page   21 of   51 
 
07:10:55.81   process pointer page   22 of   51 
 
07:10:55.85   process pointer page   23 of   51 
 
07:10:55.93   process pointer page   24 of   51 
 
07:10:56.00   process pointer page   25 of   51 
 
07:10:56.04   process pointer page   26 of   51 
 
07:10:56.07   process pointer page   27 of   51 
 
07:10:56.12   process pointer page   28 of   51 
 
07:10:56.21   process pointer page   29 of   51 
 
07:10:56.31   process pointer page   30 of   51 
 
07:10:56.42   process pointer page   31 of   51 
 
07:10:56.46   process pointer page   32 of   51 
 
07:10:56.51   process pointer page   33 of   51 
 
07:10:56.54   process pointer page   34 of   51 
 
07:10:56.59   process pointer page   35 of   51 
 
07:10:56.62   process pointer page   36 of   51 
 
07:10:56.65   process pointer page   37 of   51 
 
07:10:56.70   process pointer page   38 of   51 
 
07:10:56.73   process pointer page   39 of   51 
 
07:10:56.76   process pointer page   40 of   51 
 
07:10:56.79   process pointer page   41 of   51 
 
07:10:56.82   process pointer page   42 of   51 
 
07:10:57.01   process pointer page   43 of   51 
 
07:10:57.31   process pointer page   44 of   51 
 
07:10:57.65   process pointer page   45 of   51 
 
07:10:58.07   process pointer page   46 of   51 
 
07:10:58.37   process pointer page   47 of   51 
 
07:10:58.74   process pointer page   48 of   51 
 
07:10:59.07   process pointer page   49 of   51 
 
07:10:59.44   process pointer page   50 of   51 
 
07:10:59.51 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:11:02.38 Index 2 (XQS_1200_2000_SND_ID) 
 
07:11:04.87 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:11:07.52 Relation 267 (XQS_1200_2000) is ok 
 
 
07:11:07.52 Relation 268 (XQS_1000_3300) 
 
07:11:07.52   process pointer page    0 of   23 
 
07:11:08.01   process pointer page    1 of   23 
 
07:11:08.51   process pointer page    2 of   23 
 
07:11:09.02   process pointer page    3 of   23 
 
07:11:09.50   process pointer page    4 of   23 
 
07:11:10.00   process pointer page    5 of   23 
 
07:11:10.50   process pointer page    6 of   23 
 
07:11:11.00   process pointer page    7 of   23 
 
07:11:11.50   process pointer page    8 of   23 
 
07:11:12.00   process pointer page    9 of   23 
 
07:11:12.50   process pointer page   10 of   23 
 
07:11:13.00   process pointer page   11 of   23 
 
07:11:13.48   process pointer page   12 of   23 
 
07:11:13.98   process pointer page   13 of   23 
 
07:11:14.47   process pointer page   14 of   23 
 
07:11:14.93   process pointer page   15 of   23 
 
07:11:15.43   process pointer page   16 of   23 
 
07:11:15.92   process pointer page   17 of   23 
 
07:11:16.40   process pointer page   18 of   23 
 
07:11:16.88   process pointer page   19 of   23 
 
07:11:17.38   process pointer page   20 of   23 
 
07:11:17.79   process pointer page   21 of   23 
 
07:11:18.09   process pointer page   22 of   23 
 
07:11:18.23 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:11:19.54 Index 2 (XQS_1000_3300_SND_ID) 
 
07:11:20.83 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:11:22.44 Relation 268 (XQS_1000_3300) is ok 
 
 
07:11:22.44 Relation 269 (XQS_2000_3300) 
 
07:11:22.44   process pointer page    0 of    1 
 
07:11:22.44 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:11:22.44 Index 2 (XQS_2000_3300_SND_ID) 
 
07:11:22.44 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:11:22.44 Relation 269 (XQS_2000_3300) is ok 
 
 
07:11:22.44 Relation 270 (XQS_2100_3300) 
 
07:11:22.44   process pointer page    0 of   35 
 
07:11:22.92   process pointer page    1 of   35 
 
07:11:23.42   process pointer page    2 of   35 
 
07:11:23.94   process pointer page    3 of   35 
 
07:11:24.43   process pointer page    4 of   35 
 
07:11:24.93   process pointer page    5 of   35 
 
07:11:25.43   process pointer page    6 of   35 
 
07:11:25.93   process pointer page    7 of   35 
 
07:11:26.43   process pointer page    8 of   35 
 
07:11:26.93   process pointer page    9 of   35 
 
07:11:27.43   process pointer page   10 of   35 
 
07:11:27.93   process pointer page   11 of   35 
 
07:11:28.43   process pointer page   12 of   35 
 
07:11:28.82   process pointer page   13 of   35 
 
07:11:29.32   process pointer page   14 of   35 
 
07:11:29.75   process pointer page   15 of   35 
 
07:11:30.22   process pointer page   16 of   35 
 
07:11:30.71   process pointer page   17 of   35 
 
07:11:31.22   process pointer page   18 of   35 
 
07:11:31.70   process pointer page   19 of   35 
 
07:11:32.19   process pointer page   20 of   35 
 
07:11:32.67   process pointer page   21 of   35 
 
07:11:33.15   process pointer page   22 of   35 
 
07:11:33.62   process pointer page   23 of   35 
 
07:11:34.11   process pointer page   24 of   35 
 
07:11:34.59   process pointer page   25 of   35 
 
07:11:35.06   process pointer page   26 of   35 
 
07:11:35.54   process pointer page   27 of   35 
 
07:11:36.06   process pointer page   28 of   35 
 
07:11:36.51   process pointer page   29 of   35 
 
07:11:36.93   process pointer page   30 of   35 
 
07:11:37.38   process pointer page   31 of   35 
 
07:11:37.83   process pointer page   32 of   35 
 
07:11:38.24   process pointer page   33 of   35 
 
07:11:38.52   process pointer page   34 of   35 
 
07:11:38.60 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:11:40.38 Index 2 (XQS_2100_3300_SND_ID) 
 
07:11:42.23 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:11:44.64 Relation 270 (XQS_2100_3300) is ok 
 
 
07:11:44.64 Relation 271 (XQS_3300_3400) 
 
07:11:44.64   process pointer page    0 of    7 
 
07:11:45.10   process pointer page    1 of    7 
 
07:11:45.59   process pointer page    2 of    7 
 
07:11:46.06   process pointer page    3 of    7 
 
07:11:46.54   process pointer page    4 of    7 
 
07:11:47.01   process pointer page    5 of    7 
 
07:11:47.48   process pointer page    6 of    7 
 
07:11:47.63 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:11:48.07 Index 2 (XQS_3300_3400_SND_ID) 
 
07:11:48.52 Relation 271 (XQS_3300_3400) is ok 
 
 
07:11:48.57 Validation finished 
 
Done for 84860 ms, from  7:10:23.77 to  7:11:48.63. 
 
 Differences between old and current firebird.log 
7:11:50.60. 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-05-16  07:11               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 Wed May 16 07:10:23 2018 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Wed May 16 07:11:48 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-05-16  7:11:58.05 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html