Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-05-19 6:51:22.34.
Common Performance Final Results
  1. Test configuration
  2. Test Finish details
  3. Test workload details
  4. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score
  2. Performance, DYNAMIC, 10 intervals
  3. Performance, per MINUTE, since launch
  4. Performance, TRACE data for ISQL #1
  5. Performance, DETAILS per units
  6. MON$-analysis, per business units
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Ratio "Versions / Records" for tables
  4. Database Validation Results
  5. New in firebird.log while test was run
  6. Final processing of ISQL logs

Server and database settings

Server version: WI-V3.0.3.32724 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 3.0.3 D:\OLTP-EMUL\OLTP30-SMALL.FDB ON 0 786432 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB30.TMPINSTANCE
dbnm D:\OLTP-EMUL\oltp30-small.fdb
host localhost
port 3333
usr SYSDBA
pwd masterkey
tmpdir e:\temp\logs.oltp30
working_mode small_03
warm_time 0
test_time 180
idle_time 0
use_mtee 0
is_embed 0
remove_isql_logs if_no_severe_errors
no_auto_undo 1
detailed_info 0
mon_unit_perf 0
trc_unit_perf 1
init_buff 32768
create_with_fw sync
create_with_sweep 0
wait_if_not_exists 0
wait_after_create 0
init_docs 100000
wait_for_copy 0
create_with_debug_objects 1
create_with_split_heavy_tabs 1
create_with_separate_qdistr_idx 0
create_with_compound_columns_order most_selective_first
make_html 1
run_db_statistics 1
run_db_validation 1
file_name_with_test_params regular
file_name_this_host_info cpu_8x3Ghz_ram_16gb
upload_report 1
max_snapshots_to_store 720
replace_instance 1
etalon_dbnm E:\OLTP-EMUL\oltp30-docs_100000-fw__ON.fdb
used_in_replication 0

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2017-05-19 06:48:16.7400 -1 <null> ::1/52054 434388 9356 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
COMMON ENABLE_MON_QUERY 0
COMMON HALT_TEST_ON_ERRORS ,CK,
COMMON QMISM_VERIFY_BITSET 1
COMMON RECALC_IDX_MIN_INTERVAL 15
COMMON ENABLE_RESERVES_WHEN_ADD_INVOICE 1
COMMON ORDER_FOR_OUR_FIRM_PERCENT 25
COMMON ENABLE_FILL_PHRASES 0
COMMON RANDOM_SEEK_VIA_ROWS_LIMIT 0
COMMON C_INVOICE_MIN_PURCHASE 1000
COMMON C_INVOICE_MAX_PURCHASE 2000
COMMON C_INVOICE_MIN_PROFIT_PRC 35
COMMON C_INVOICE_MAX_PROFIT_PRC 80
COMMON C_MIN_COST_TO_BE_SPLITTED 1000
COMMON C_ROWS_TO_MULTIPLY 10
COMMON C_PAYMENT_FROM_CLIENT_MIN_TOTAL 1000
COMMON C_PAYMENT_FROM_CLIENT_MAX_TOTAL 5000
COMMON C_PAYMENT_TO_SUPPLIER_MIN_TOTAL 2000
COMMON C_PAYMENT_TO_SUPPLIER_MAX_TOTAL 15000
COMMON BUILD_WITH_SPLIT_HEAVY_TABS 1
COMMON BUILD_WITH_SEPAR_QDISTR_IDX 0
COMMON BUILD_WITH_QD_COMPOUND_ORDR MOST_SELECTIVE_FIRST
SMALL_03 C_WARES_MAX_ID 400
SMALL_03 C_CUSTOMER_DOC_MAX_ROWS 10
SMALL_03 C_SUPPLIER_DOC_MAX_ROWS 50
SMALL_03 C_CUSTOMER_DOC_MAX_QTY 15
SMALL_03 C_SUPPLIER_DOC_MAX_QTY 50
SMALL_03 C_NUMBER_OF_AGENTS 50

Index(es) for heavy-loaded table(s)

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_DOC DOC_ID
XQD_1000_3300 XQD_1000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1200_2000 XQD_1200_2000_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 5997.00 3564 1079460 2017-05-19 03:48 2017-05-19 06:48
customer order: creation 452.11 489 81379 2017-05-19 03:48 2017-05-19 06:48
customer order: refuse 37.17 251 6691 2017-05-19 03:48 2017-05-19 06:48
order to supplier: creation 113.75 2155 20475 2017-05-19 03:48 2017-05-19 06:48
order to supplier: removal 3.12 22963 561 2017-05-19 03:48 2017-05-19 06:48
invoice (draft): creation 117.97 3220 21235 2017-05-19 03:48 2017-05-19 06:48
invoice (draft): removal 42.65 540 7677 2017-05-19 03:48 2017-05-19 06:48
invoice accept: apply 63.41 11820 11413 2017-05-19 03:48 2017-05-19 06:48
invoice accept: cancel 18.51 2840 3332 2017-05-19 03:48 2017-05-19 06:48
customer reserve: creation 3428.40 178 617112 2017-05-19 03:48 2017-05-19 06:48
customer reserve: removal 1090.43 70 196278 2017-05-19 03:48 2017-05-19 06:48
realization accept: apply 208.81 592 37585 2017-05-19 03:48 2017-05-19 06:48
realization accept: cancel 87.71 169 15788 2017-05-19 03:48 2017-05-19 06:48
payment from customer: creation 152.28 1024 27411 2017-05-19 03:48 2017-05-19 06:48
payment from customer: removal 14.55 138 2619 2017-05-19 03:48 2017-05-19 06:48
payment to supplier: creation 125.67 1375 22621 2017-05-19 03:48 2017-05-19 06:48
payment to supplier: removal 8.54 131 1537 2017-05-19 03:48 2017-05-19 06:48
service: total inventory turnovers 11.62 2495 2091 2017-05-19 03:48 2017-05-19 06:48
service: total monetary turnovers 20.24 55 3643 2017-05-19 03:48 2017-05-19 06:48
service: refresh index statistics 0.07 17209 12 2017-05-19 03:48 2017-05-19 06:48
Done for 121770 ms, from 6:54:17.27 to 6:56:19.04.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 5331 112409 95953 16456 14.64 03:48:17 04:06:17
interval # 2, overall 2 6874 139141 123733 15408 11.07 04:06:18 04:24:18
interval # 3, overall 3 6084 126694 109509 17185 13.56 04:24:19 04:42:19
interval # 4, overall 4 6070 120232 109255 10977 9.13 04:42:20 05:00:20
interval # 5, overall 5 6344 125718 114187 11531 9.17 05:00:21 05:18:21
interval # 6, overall 6 5570 116812 100251 16561 14.18 05:18:22 05:36:22
interval # 7, overall 7 5803 115083 104456 10627 9.23 05:36:23 05:54:23
interval # 8, overall 8 5797 115170 104340 10830 9.40 05:54:24 06:12:24
interval # 9, overall 9 6084 122875 109516 13359 10.87 06:12:25 06:30:25
interval # 10, overall 10 6014 124334 108260 16074 12.93 06:30:26 06:48:26
Done for 281850 ms, from 7:01:00.51 to 7:05:42.36.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
TEST_TIME 1 4242.58 0.5972 1.4882 2255 23
TEST_TIME 2 3804.11 0.8300 1.1711 1636 22
TEST_TIME 3 3482.20 0.8530 1.1518 1459 22
TEST_TIME 4 3483.88 0.8635 1.1274 1561 20
TEST_TIME 5 3450.91 0.9106 1.0771 1490 16
TEST_TIME 6 3448.24 0.8996 1.0806 1257 19
TEST_TIME 7 3611.34 0.8844 1.1001 1591 20
TEST_TIME 8 3846.79 0.9037 1.0892 1794 14
TEST_TIME 9 4070.76 0.9150 1.0694 1857 23
TEST_TIME 10 4164.81 0.9407 1.0551 1592 18
TEST_TIME 11 4306.02 0.9287 1.0689 1664 15
TEST_TIME 12 4483.93 0.9409 1.0627 1615 18
TEST_TIME 13 4640.75 0.9478 1.0539 1942 19
TEST_TIME 14 4808.49 0.9445 1.0480 1794 20
TEST_TIME 15 4962.07 0.9479 1.0473 1911 15
TEST_TIME 16 5125.55 0.9506 1.0375 1825 21
TEST_TIME 17 5250.21 0.9537 1.0444 1897 14
TEST_TIME 18 5393.40 0.9602 1.0326 1645 24
TEST_TIME 19 5479.27 0.9629 1.0354 1647 26
TEST_TIME 20 5530.32 0.9746 1.0266 1596 39
TEST_TIME 21 5515.60 0.9815 1.0204 1149 96
TEST_TIME 22 5539.34 0.9724 1.0226 1561 100
TEST_TIME 23 5561.54 0.9743 1.0273 1484 100
TEST_TIME 24 5536.27 0.9891 1.0093 1501 100
TEST_TIME 25 5468.21 0.9810 1.0250 1335 100
TEST_TIME 26 5499.65 0.9800 1.0201 1343 100
TEST_TIME 27 5505.43 0.9813 1.0189 1407 100
TEST_TIME 28 5572.17 0.9707 1.0306 2412 100
TEST_TIME 29 5684.78 0.9753 1.0221 2324 100
TEST_TIME 30 5795.13 0.9692 1.0264 1908 100
TEST_TIME 31 5891.09 0.9776 1.0221 1978 100
TEST_TIME 32 5965.39 0.9782 1.0200 1776 100
TEST_TIME 33 6034.05 0.9785 1.0186 1596 100
TEST_TIME 34 6073.89 0.9822 1.0164 1705 100
TEST_TIME 35 6111.06 0.9813 1.0167 1454 100
TEST_TIME 36 6135.13 0.9846 1.0121 1579 100
TEST_TIME 37 6131.81 0.9853 1.0113 1250 100
TEST_TIME 38 6120.27 0.9866 1.0109 1324 100
TEST_TIME 39 6103.60 0.9883 1.0101 1218 100
TEST_TIME 40 6078.54 0.9890 1.0062 1330 100
TEST_TIME 41 6048.44 0.9865 1.0071 1215 100
TEST_TIME 42 5982.73 0.9939 1.0066 1231 98
TEST_TIME 43 5991.88 0.9817 1.0117 1754 99
TEST_TIME 44 5986.55 0.9896 1.0136 2285 96
TEST_TIME 45 6010.75 0.9871 1.0102 1780 98
TEST_TIME 46 6015.59 0.9874 1.0113 1534 99
TEST_TIME 47 6049.86 0.9842 1.0146 1657 100
TEST_TIME 48 6076.93 0.9891 1.0126 1773 100
TEST_TIME 49 6098.66 0.9885 1.0117 1642 100
TEST_TIME 50 6112.62 0.9892 1.0131 1551 100
TEST_TIME 51 6126.92 0.9910 1.0099 1571 100
TEST_TIME 52 6129.15 0.9901 1.0122 1353 100
TEST_TIME 53 6134.47 0.9923 1.0065 1419 100
TEST_TIME 54 6118.29 0.9905 1.0093 1305 100
TEST_TIME 55 6102.87 0.9936 1.0062 1409 98
TEST_TIME 56 6085.90 0.9910 1.0090 1193 100
TEST_TIME 57 6066.35 0.9945 1.0038 1197 100
TEST_TIME 58 6034.47 0.9917 1.0099 1414 100
TEST_TIME 59 6079.18 0.9855 1.0155 1927 100
TEST_TIME 60 6107.45 0.9939 1.0067 2122 98
TEST_TIME 61 6101.78 0.9911 1.0105 1617 86
TEST_TIME 62 6113.92 0.9929 1.0081 1613 100
TEST_TIME 63 6102.88 0.9938 1.0068 2005 100
TEST_TIME 64 6100.90 0.9914 1.0112 1605 98
TEST_TIME 65 6116.92 0.9930 1.0062 1479 99
TEST_TIME 66 6093.82 0.9947 1.0049 1688 100
TEST_TIME 67 6069.82 0.9939 1.0058 1664 97
TEST_TIME 68 6056.65 0.9931 1.0100 1492 98
TEST_TIME 69 6055.08 0.9957 1.0098 1498 99
TEST_TIME 70 6060.59 0.9945 1.0084 1277 100
TEST_TIME 71 6086.35 0.9900 1.0084 1156 100
TEST_TIME 72 6100.69 0.9921 1.0083 1245 100
TEST_TIME 73 6116.42 0.9919 1.0077 1877 100
TEST_TIME 74 6105.27 0.9959 1.0059 1803 92
TEST_TIME 75 6126.34 0.9932 1.0052 1822 100
TEST_TIME 76 6148.43 0.9885 1.0069 1510 94
TEST_TIME 77 6150.03 0.9935 1.0044 1629 98
TEST_TIME 78 6133.28 0.9944 1.0087 1515 98
TEST_TIME 79 6132.32 0.9960 1.0041 1601 92
TEST_TIME 80 6117.64 0.9939 1.0076 1349 90
TEST_TIME 81 6123.79 0.9944 1.0040 1495 97
TEST_TIME 82 6102.24 0.9952 1.0055 1499 95
TEST_TIME 83 6090.85 0.9953 1.0047 1486 93
TEST_TIME 84 6113.07 0.9892 1.0061 1125 100
TEST_TIME 85 6128.50 0.9920 1.0043 1243 100
TEST_TIME 86 6134.30 0.9917 1.0058 1167 100
TEST_TIME 87 6128.64 0.9952 1.0052 1284 100
TEST_TIME 88 6133.59 0.9930 1.0067 1923 100
TEST_TIME 89 6129.84 0.9960 1.0055 1912 94
TEST_TIME 90 6132.73 0.9938 1.0055 1737 94
TEST_TIME 91 6132.71 0.9945 1.0076 1666 93
TEST_TIME 92 6147.13 0.9944 1.0059 1366 100
TEST_TIME 93 6152.25 0.9942 1.0047 1510 100
TEST_TIME 94 6136.80 0.9965 1.0033 1795 97
TEST_TIME 95 6129.10 0.9940 1.0034 1630 98
TEST_TIME 96 6111.16 0.9959 1.0050 1356 94
TEST_TIME 97 6103.52 0.9965 1.0020 1289 100
TEST_TIME 98 6094.81 0.9932 1.0039 1362 98
TEST_TIME 99 6079.66 0.9962 1.0067 1281 99
TEST_TIME 100 6091.95 0.9947 1.0026 1240 100
TEST_TIME 101 6065.00 0.9971 1.0066 1266 100
TEST_TIME 102 6071.03 0.9957 1.0026 1416 100
TEST_TIME 103 6053.72 0.9957 1.0036 1529 97
TEST_TIME 104 6066.22 0.9920 1.0052 1585 100
TEST_TIME 105 6062.69 0.9962 1.0027 1987 100
TEST_TIME 106 6050.94 0.9951 1.0050 1774 95
TEST_TIME 107 6058.30 0.9944 1.0030 1827 95
TEST_TIME 108 6043.81 0.9961 1.0036 1719 94
TEST_TIME 109 6031.21 0.9965 1.0034 1495 93
TEST_TIME 110 6046.97 0.9917 1.0041 995 100
TEST_TIME 111 6031.82 0.9976 1.0027 1529 98
TEST_TIME 112 6015.58 0.9964 1.0038 1458 97
TEST_TIME 113 6024.15 0.9935 1.0060 1236 98
TEST_TIME 114 6027.32 0.9967 1.0039 1229 100
TEST_TIME 115 6027.13 0.9952 1.0049 1251 100
TEST_TIME 116 6019.60 0.9974 1.0029 1266 98
TEST_TIME 117 6004.56 0.9968 1.0050 1158 97
TEST_TIME 118 5996.73 0.9984 1.0021 1592 96
TEST_TIME 119 5994.81 0.9940 1.0047 1469 92
TEST_TIME 120 6020.27 0.9957 1.0032 1431 94
TEST_TIME 121 6023.18 0.9944 1.0033 1549 99
TEST_TIME 122 6014.48 0.9965 1.0040 1538 89
TEST_TIME 123 6020.44 0.9949 1.0054 1508 96
TEST_TIME 124 6020.26 0.9974 1.0041 1591 99
TEST_TIME 125 6017.29 0.9966 1.0031 1438 100
TEST_TIME 126 6013.49 0.9973 1.0018 1282 99
TEST_TIME 127 6002.54 0.9957 1.0027 1619 98
TEST_TIME 128 5988.61 0.9972 1.0026 1515 95
TEST_TIME 129 5979.54 0.9963 1.0043 1300 98
TEST_TIME 130 5981.93 0.9962 1.0026 1394 99
TEST_TIME 131 5988.73 0.9939 1.0061 1037 100
TEST_TIME 132 5996.53 0.9972 1.0036 1120 100
TEST_TIME 133 6005.53 0.9946 1.0035 1802 100
TEST_TIME 134 5997.49 0.9974 1.0042 1940 94
TEST_TIME 135 6009.45 0.9948 1.0031 1607 95
TEST_TIME 136 5998.83 0.9975 1.0030 1473 91
TEST_TIME 137 6011.22 0.9970 1.0018 1317 98
TEST_TIME 138 5998.35 0.9967 1.0028 1514 92
TEST_TIME 139 5990.03 0.9969 1.0050 1066 97
TEST_TIME 140 5993.26 0.9973 1.0018 1477 100
TEST_TIME 141 5975.39 0.9977 1.0029 1602 96
TEST_TIME 142 5969.10 0.9968 1.0076 1268 99
TEST_TIME 143 5992.84 0.9966 1.0019 1318 100
TEST_TIME 144 5983.51 0.9965 1.0044 1245 100
TEST_TIME 145 6005.96 0.9938 1.0050 1112 100
TEST_TIME 146 6019.44 0.9959 1.0056 1066 100
TEST_TIME 147 6032.48 0.9967 1.0016 1152 100
TEST_TIME 148 6013.40 0.9980 1.0027 1446 94
TEST_TIME 149 6011.36 0.9963 1.0062 1820 97
TEST_TIME 150 6024.64 0.9973 1.0025 1954 100
TEST_TIME 151 6017.89 0.9970 1.0034 1749 95
TEST_TIME 152 6017.73 0.9968 1.0039 1388 90
TEST_TIME 153 6015.26 0.9978 1.0024 1482 91
TEST_TIME 154 6009.20 0.9969 1.0059 1366 94
TEST_TIME 155 6016.91 0.9982 1.0015 1518 99
TEST_TIME 156 6005.44 0.9970 1.0028 1461 91
TEST_TIME 157 6001.39 0.9971 1.0026 1466 86
TEST_TIME 158 5997.94 0.9968 1.0060 1149 92
TEST_TIME 159 6008.59 0.9979 1.0031 991 100
TEST_TIME 160 6007.19 0.9971 1.0020 1231 100
TEST_TIME 161 6000.18 0.9970 1.0028 1176 96
TEST_TIME 162 5990.66 0.9982 1.0018 1163 95
TEST_TIME 163 5988.56 0.9960 1.0040 1225 95
TEST_TIME 164 5997.12 0.9969 1.0021 1691 99
TEST_TIME 165 5995.20 0.9964 1.0028 1799 97
TEST_TIME 166 5997.32 0.9964 1.0038 1646 94
TEST_TIME 167 5999.10 0.9975 1.0024 1663 85
TEST_TIME 168 5997.38 0.9967 1.0036 1389 83
TEST_TIME 169 6000.74 0.9971 1.0019 1201 91
TEST_TIME 170 5998.10 0.9981 1.0016 1281 98
TEST_TIME 171 5990.63 0.9969 1.0018 1466 95
TEST_TIME 172 5978.43 0.9980 1.0025 1439 90
TEST_TIME 173 5978.26 0.9967 1.0035 1225 94
TEST_TIME 174 5993.68 0.9952 1.0039 988 100
TEST_TIME 175 6008.45 0.9957 1.0033 906 100
TEST_TIME 176 6008.24 0.9976 1.0012 1200 99
TEST_TIME 177 5996.46 0.9975 1.0038 1060 99
TEST_TIME 178 5993.80 0.9986 1.0018 1436 98
TEST_TIME 179 5994.22 0.9961 1.0048 1564 88
TEST_TIME 180 5995.01 0.9996 1.0003 521 86
Done for 10750 ms, from 7:05:43.84 to 7:05:54.59.

Performance from TRACE for ISQL instance #1:

TRACED_DATA ITRV_NO SP_CLIENT_ORDER SP_CANCEL_CLIENT_ORDER SP_SUPPLIER_ORDER SP_CANCEL_SUPPLIER_ORDER SP_SUPPLIER_INVOICE SP_CANCEL_SUPPLIER_INVOICE SP_ADD_INVOICE_TO_STOCK SP_CANCEL_ADDING_INVOICE SP_CUSTOMER_RESERVE SP_CANCEL_CUSTOMER_RESERVE SP_RESERVE_WRITE_OFF SP_CANCEL_WRITE_OFF SP_PAY_FROM_CUSTOMER SP_CANCEL_PAY_FROM_CUSTOMER SP_PAY_TO_SUPPLIER SP_CANCEL_PAY_TO_SUPPLIER SRV_MAKE_INVNT_SALDO SRV_MAKE_MONEY_SALDO SRV_RECALC_IDX_STAT ITRV_BEG ITRV_END
fetches per second 1 39753 53436 35361 149402 37724 45112 53669 17845 30363 33196 47245 48360 60315 76494 86646 72419 213536 417134 <null> 03:48:17 04:06:17
fetches per second 2 44480 65072 36254 52123 27824 17885 36893 51542 29787 11340 46227 21805 45398 30703 82136 86874 125915 309604 <null> 04:06:18 04:24:18
fetches per second 3 23223 8821 33518 64198 35057 140950 42426 11988 31998 56055 47900 41111 63399 <null> 77118 <null> <null> 11370 <null> 04:24:19 04:42:19
fetches per second 4 23006 64258 23383 <null> 14187 77700 44270 7548 11466 3359 22350 8387 43701 82502 130255 7540 127518 9007 <null> 04:42:20 05:00:20
fetches per second 5 16109 22623 20899 43200 26451 <null> 11523 <null> 48905 16924 31770 1350 28396 6997 23806 <null> <null> 123649 <null> 05:00:21 05:18:21
fetches per second 6 12251 25765 7929 <null> 10810 <null> 10963 10168 32416 17007 12132 2481 32368 73500 32161 <null> 24021 94759 <null> 05:18:22 05:36:22
fetches per second 7 15660 7096 9249 3963 12783 <null> 27638 <null> <null> 3665 12125 30999 10056 6661 10975 7284 18608 88051 <null> 05:36:23 05:54:23
fetches per second 8 10069 7694 8936 <null> 13420 <null> 33227 <null> 1902 6936 4992 1804 38046 <null> 16287 <null> 19049 86032 <null> 05:54:24 06:12:24
fetches per second 9 15751 3550 5211 <null> 16590 <null> 10692 12686 8793 4480 28332 1771 17964 30958 13433 4873 <null> 30524 <null> 06:12:25 06:30:25
fetches per second 10 7231 10057 9156 <null> 18444 11787 9538 33187 7641 4555 20814 6680 23051 3964 21005 3408 19503 153140 <null> 06:30:26 06:48:26
marks per second 1 8746 6835 7159 32344 7410 10307 7080 2852 4351 6266 7490 8573 4666 12772 3078 11839 5389 13737 <null> 03:48:17 04:06:17
marks per second 2 9761 8614 7764 9203 5882 3977 4784 7549 5360 2249 6757 3485 2796 5707 2668 12833 15283 20166 <null> 04:06:18 04:24:18
marks per second 3 4878 1068 7395 14556 7379 30700 6035 1632 3911 8111 6647 7274 4132 <null> 3881 <null> <null> 725 <null> 04:24:19 04:42:19
marks per second 4 4559 8330 4578 <null> 2710 12350 5396 1066 2348 641 1975 877 2153 18792 13850 1074 4146 481 <null> 04:42:20 05:00:20
marks per second 5 3270 2985 4445 9603 4860 <null> 1308 <null> 9074 2632 3669 210 1160 1087 803 <null> <null> 1420 <null> 05:00:21 05:18:21
marks per second 6 2545 3428 1409 <null> 1996 <null> 1098 1482 3551 2629 1544 387 1457 13000 778 <null> 543 10164 <null> 05:18:22 05:36:22
marks per second 7 3133 995 1179 853 2538 <null> 2254 <null> <null> 643 1431 4443 283 1128 496 1019 609 966 <null> 05:36:23 05:54:23
marks per second 8 2079 901 1859 <null> 2297 <null> 3233 <null> 242 1002 752 286 1581 <null> 347 <null> 627 1366 <null> 05:54:24 06:12:24
marks per second 9 3307 490 893 <null> 2661 <null> 964 1898 1180 746 2291 261 722 4458 703 586 <null> 623 <null> 06:12:25 06:30:25
marks per second 10 1501 1356 1785 <null> 3520 2828 782 4843 402 670 1464 602 514 588 967 455 434 6482 <null> 06:30:26 06:48:26
reads/fetches*100 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 03:48:17 04:06:17
reads/fetches*100 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:06:18 04:24:18
reads/fetches*100 3 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> <null> 0 <null> 04:24:19 04:42:19
reads/fetches*100 4 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:42:20 05:00:20
reads/fetches*100 5 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> <null> 0 <null> 05:00:21 05:18:21
reads/fetches*100 6 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 05:18:22 05:36:22
reads/fetches*100 7 0 0 0 0 0 <null> 0 <null> <null> 0 0 0 0 0 0 0 0 0 <null> 05:36:23 05:54:23
reads/fetches*100 8 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 <null> 0 <null> 0 0 <null> 05:54:24 06:12:24
reads/fetches*100 9 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 06:12:25 06:30:25
reads/fetches*100 10 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 06:30:26 06:48:26
writes/marks*100 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 4 0 <null> 03:48:17 04:06:17
writes/marks*100 2 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 3 0 <null> 04:06:18 04:24:18
writes/marks*100 3 0 0 1 0 0 0 0 0 1 0 0 0 0 <null> 0 <null> <null> 0 <null> 04:24:19 04:42:19
writes/marks*100 4 0 0 0 <null> 0 0 0 0 0 1 0 0 0 0 0 0 4 0 <null> 04:42:20 05:00:20
writes/marks*100 5 0 0 0 0 0 <null> 0 <null> 1 0 0 0 0 0 0 <null> <null> 0 <null> 05:00:21 05:18:21
writes/marks*100 6 0 0 0 <null> 0 <null> 0 0 1 1 0 0 0 0 0 <null> 2 0 <null> 05:18:22 05:36:22
writes/marks*100 7 1 0 0 0 0 <null> 0 <null> <null> 0 0 0 0 0 0 0 6 0 <null> 05:36:23 05:54:23
writes/marks*100 8 0 0 0 <null> 0 <null> 0 <null> 1 0 0 0 0 <null> 0 <null> 2 0 <null> 05:54:24 06:12:24
writes/marks*100 9 0 0 0 <null> 0 <null> 0 0 1 0 0 0 0 3 0 0 <null> 0 <null> 06:12:25 06:30:25
writes/marks*100 10 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 3 1 <null> 06:30:26 06:48:26
Done for 11470 ms, from 7:05:55.63 to 7:06:07.10.

Performance in DETAILS:

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL JOB_BEG JOB_END
doc_list_aiud 1870935 1743845 127090 6.79 0 14056 64 127090 2017-05-19 03:48 2017-05-19 06:48
doc_list_biud 1871354 1743845 127509 6.81 0 6646 18 127509 2017-05-19 03:48 2017-05-19 06:48
sp_add_invoice_to_stock 19779 11413 8366 42.29 15 128248 11820 8366 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_adding_invoice 4226 3332 894 21.15 0 62603 2840 894 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_client_order 6841 6691 150 2.19 0 2730 251 150 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_customer_reserve 314314 196278 118036 37.55 0 3572 70 118036 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_pay_from_customer 2631 2619 12 0.45 0 4711 138 12 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_pay_to_supplier 1541 1537 4 0.25 0 2122 131 4 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_supplier_invoice 9719 7677 2042 21.01 0 7005 540 2042 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_supplier_order 1596 561 1035 64.84 32 200414 22963 1035 2017-05-19 03:48 2017-05-19 06:48
sp_cancel_write_off 23054 15788 7266 31.51 0 5102 169 7266 2017-05-19 03:48 2017-05-19 06:48
sp_client_order 81379 81379 0 0.00 0 4477 489 0 2017-05-19 03:48 2017-05-19 06:48
sp_customer_reserve 617112 617112 0 0.00 0 5413 178 0 2017-05-19 03:48 2017-05-19 06:48
sp_fill_shopping_cart 123368 123089 279 0.22 0 3728 99 0 2017-05-19 03:48 2017-05-19 06:48
sp_fill_shopping_cart_clo_res 617112 617112 0 0.00 0 3011 14 0 2017-05-19 03:48 2017-05-19 06:48
sp_get_clo_for_invoice 11413 11413 0 0.00 0 5850 341 0 2017-05-19 03:48 2017-05-19 06:48
sp_kill_cost_storno 31098 23276 7822 25.15 0 4212 17 7822 2017-05-19 03:48 2017-05-19 06:48
sp_kill_qstorno_ret_qs2qd 661016 416582 244434 36.97 0 6614 27 244434 2017-05-19 03:48 2017-05-19 06:48
sp_kill_qty_storno 406768 279325 127443 31.33 0 6630 78 127443 2017-05-19 03:48 2017-05-19 06:48
sp_lock_selected_doc 80383 68902 11481 14.28 0 4337 7 11481 2017-05-19 03:48 2017-05-19 06:48
sp_make_cost_storno 99030 99030 0 0.00 0 12449 641 0 2017-05-19 03:48 2017-05-19 06:48
sp_multiply_rows_for_pdistr 99030 99030 0 0.00 0 3573 57 0 2017-05-19 03:48 2017-05-19 06:48
sp_multiply_rows_for_qdistr 81379 81379 0 0.00 0 3308 160 0 2017-05-19 03:48 2017-05-19 06:48
sp_pay_from_customer 27411 27411 0 0.00 0 8019 1024 0 2017-05-19 03:48 2017-05-19 06:48
sp_pay_to_supplier 22621 22621 0 0.00 0 11965 1375 0 2017-05-19 03:48 2017-05-19 06:48
sp_payment_common 50032 50032 0 0.00 0 3354 63 0 2017-05-19 03:48 2017-05-19 06:48
sp_qd_handle_on_cancel_clo 6839 6691 148 2.16 0 2480 109 148 2017-05-19 03:48 2017-05-19 06:48
sp_qd_handle_on_invoice_upd_sts 15490 14745 745 4.80 0 5304 366 745 2017-05-19 03:48 2017-05-19 06:48
sp_qd_handle_on_reserve_upd_sts 37585 37585 0 0.00 0 2059 49 0 2017-05-19 03:48 2017-05-19 06:48
sp_reserve_write_off 38509 37585 924 2.39 0 9781 592 924 2017-05-19 03:48 2017-05-19 06:48
sp_supplier_invoice 21354 21235 119 0.55 0 34367 3220 0 2017-05-19 03:48 2017-05-19 06:48
sp_supplier_order 20635 20475 160 0.77 0 14539 2155 0 2017-05-19 03:48 2017-05-19 06:48
srv_find_qd_qs_mism 1111555 984491 127064 11.43 0 4602 29 127064 2017-05-19 03:48 2017-05-19 06:48
srv_make_invnt_saldo 2091 2091 0 0.00 0 27706 2495 0 2017-05-19 03:48 2017-05-19 06:48
srv_make_money_saldo 3643 3643 0 0.00 0 2028 55 0 2017-05-19 03:48 2017-05-19 06:48
srv_recalc_idx_stat 12 12 0 0.00 1716 35506 17209 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_add_invoice_to_stock 8366 8366 0 0.00 0 1825 97 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_adding_invoice 622 622 0 0.00 0 2449 157 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_client_order 150 150 0 0.00 0 1857 124 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_customer_reserve 68 68 0 0.00 0 1061 60 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_pay_from_customer 12 12 0 0.00 0 452 57 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 0 203 70 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_supplier_invoice 670 670 0 0.00 0 1373 96 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_supplier_order 14668 14668 0 0.00 0 3464 117 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_cancel_write_off 41 41 0 0.00 0 983 116 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_reserve_write_off 924 924 0 0.00 0 1700 73 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_supplier_invoice 119 119 0 0.00 0 811 78 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-abend:sp_supplier_order 160 160 0 0.00 0 1435 86 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_add_invoice_to_stock 11413 11413 0 0.00 0 12215 638 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_adding_invoice 1293 1293 0 0.00 0 8767 784 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_client_order 6691 6691 0 0.00 0 1716 61 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_customer_reserve 2531 2531 0 0.00 0 2075 66 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_pay_from_customer 2619 2619 0 0.00 0 1778 55 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_pay_to_supplier 1537 1537 0 0.00 0 1341 51 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_supplier_invoice 874 874 0 0.00 0 1388 69 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_supplier_order 561 561 0 0.00 0 48906 1971 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_cancel_write_off 3798 3798 0 0.00 0 2808 67 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_client_order 81379 81379 0 0.00 0 2949 75 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_customer_reserve 3773 3773 0 0.00 0 1622 54 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_pay_from_customer 27411 27411 0 0.00 0 2402 68 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_pay_to_supplier 22621 22621 0 0.00 0 2699 66 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_reserve_write_off 37585 37585 0 0.00 0 3494 71 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_supplier_invoice 21235 21235 0 0.00 0 2824 67 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:sp_supplier_order 20475 20475 0 0.00 0 2715 72 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:srv_make_invnt_saldo 2091 2091 0 0.00 0 780 28 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:srv_make_money_saldo 3643 3643 0 0.00 0 843 25 0 2017-05-19 03:48 2017-05-19 06:48
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 1388 308 0 2017-05-19 03:48 2017-05-19 06:48
v_add_invoice_to_stock 39558 22826 16732 42.29 0 2714 10 16732 2017-05-19 03:48 2017-05-19 06:48
v_all_customers 121710 121710 0 0.00 0 1653 6 0 2017-05-19 03:48 2017-05-19 06:48
v_all_suppliers 83978 83420 558 0.66 0 748 6 0 2017-05-19 03:48 2017-05-19 06:48
v_all_wares 162758 162758 0 0.00 0 1560 5 0 2017-05-19 03:48 2017-05-19 06:48
v_cancel_adding_invoice 3008 2586 422 14.02 0 3323 160 422 2017-05-19 03:48 2017-05-19 06:48
v_cancel_client_order 13682 13382 300 2.19 0 640 6 300 2017-05-19 03:48 2017-05-19 06:48
v_cancel_customer_prepayment 5262 5238 24 0.45 0 4227 11 24 2017-05-19 03:48 2017-05-19 06:48
v_cancel_customer_reserve 5198 5062 136 2.61 0 764 9 136 2017-05-19 03:48 2017-05-19 06:48
v_cancel_payment_to_supplier 3082 3074 8 0.25 0 921 8 8 2017-05-19 03:48 2017-05-19 06:48
v_cancel_supplier_invoice 3088 1748 1340 43.39 0 4165 16 1340 2017-05-19 03:48 2017-05-19 06:48
v_cancel_supplier_order 3192 1122 2070 64.84 0 3822 12 2070 2017-05-19 03:48 2017-05-19 06:48
v_cancel_write_off 7678 7596 82 1.06 0 3697 109 82 2017-05-19 03:48 2017-05-19 06:48
v_max_id_clo_ord 20635 20475 160 0.77 0 608 6 0 2017-05-19 03:48 2017-05-19 06:48
v_max_id_clo_res 3773 3773 0 0.00 0 1139 17 0 2017-05-19 03:48 2017-05-19 06:48
v_max_id_ord_sup 21354 21235 119 0.55 0 671 5 0 2017-05-19 03:48 2017-05-19 06:48
v_max_non_paid_invoice 22621 22621 0 0.00 0 640 6 0 2017-05-19 03:48 2017-05-19 06:48
v_max_non_paid_realizn 27411 27411 0 0.00 0 2527 6 0 2017-05-19 03:48 2017-05-19 06:48
v_min_id_clo_ord 20635 20475 160 0.77 0 1232 7 0 2017-05-19 03:48 2017-05-19 06:48
v_min_id_clo_res 3773 3773 0 0.00 0 764 9 0 2017-05-19 03:48 2017-05-19 06:48
v_min_id_ord_sup 21354 21235 119 0.55 0 1763 7 0 2017-05-19 03:48 2017-05-19 06:48
v_min_non_paid_invoice 22621 22621 0 0.00 0 2932 8 0 2017-05-19 03:48 2017-05-19 06:48
v_min_non_paid_realizn 27411 27411 0 0.00 0 1138 7 0 2017-05-19 03:48 2017-05-19 06:48
v_our_firm 41048 41048 0 0.00 0 749 6 0 2017-05-19 03:48 2017-05-19 06:48
v_reserve_write_off 77018 75170 1848 2.39 0 3635 8 1848 2017-05-19 03:48 2017-05-19 06:48
x_lock_depdocs_on_canc_invoice 18512 10135 8377 45.25 0 1607 35 8377 2017-05-19 03:48 2017-05-19 06:48
x_lock_depdocs_on_canc_sup_ord 1592 561 1031 64.76 0 2060 66 1031 2017-05-19 03:48 2017-05-19 06:48
x_make_qstorno_1000_1200 20635 20475 160 0.77 0 12495 1937 0 2017-05-19 03:48 2017-05-19 06:48
x_make_qstorno_1200_2000 21354 21235 119 0.55 0 33275 2996 0 2017-05-19 03:48 2017-05-19 06:48
x_make_qstorno_2100_3300 617112 617112 0 0.00 0 5164 146 0 2017-05-19 03:48 2017-05-19 06:48
Done for 430300 ms, from 7:13:04.65 to 7:20:14.95.

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

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 69 sp_kill_cost_storno 335544336 2017-05-19 03:48 2017-05-19 06:43
deadlock 99 sp_kill_qstorno_ret_qs2qd 335544336 2017-05-19 03:49 2017-05-19 06:47
deadlock 2171 sp_lock_selected_doc 335544336 2017-05-19 03:48 2017-05-19 06:48
deadlock 148 sp_qd_handle_on_cancel_clo 335544336 2017-05-19 03:49 2017-05-19 06:47
deadlock 164 sp_qd_handle_on_invoice_upd_sts 335544336 2017-05-19 03:48 2017-05-19 06:45
deadlock 32 x_lock_depdocs_on_canc_invoice 335544336 2017-05-19 03:48 2017-05-19 06:47
deadlock 9 x_lock_depdocs_on_canc_sup_ord 335544336 2017-05-19 04:14 2017-05-19 06:32
user_exc 160 x_make_qstorno_1000_1200 335544517 2017-05-19 03:48 2017-05-19 06:42
user_exc 119 x_make_qstorno_1200_2000 335544517 2017-05-19 03:48 2017-05-19 06:47
concurrent_transaction 7921 sp_lock_selected_doc 335544878 2017-05-19 03:48 2017-05-19 06:48
concurrent_transaction 569 x_lock_depdocs_on_canc_invoice 335544878 2017-05-19 03:48 2017-05-19 06:48
concurrent_transaction 293 x_lock_depdocs_on_canc_sup_ord 335544878 2017-05-19 03:50 2017-05-19 06:48
Done for 12780 ms, from 7:20:25.91 to 7:20:38.69.

MON$DATABASE and FB VERSION info

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

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 435032
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 434846
Oldest active 434847
Oldest snapshot 434847
Next transaction 434848
Sequence number 0
Next attachment ID 9530
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.03, total records: 2150262
Average version length: 47.78, total versions: 3196, 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: 23304
Data pages: 23304, average fill: 73%
Primary pages: 23304, secondary pages: 0, swept pages: 14607
Empty pages: 3, full pages: 19563
Fill distribution:
0 - 19% = 5
20 - 39% = 2
40 - 59% = 98
60 - 79% = 23197
80 - 99% = 2

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 10436, nodes: 2150262
Average node length: 19.30, total dup: 0, max dup: 0
Average key length: 16.34, compression ratio: 1.65
Average prefix length: 13.65, average data length: 13.35
Clustering factor: 448941, ratio: 0.21
Fill distribution:
0 - 19% = 632
20 - 39% = 2414
40 - 59% = 4999
60 - 79% = 977
80 - 99% = 1414

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7680, nodes: 2150262
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: 420892, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 3574
40 - 59% = 4022
60 - 79% = 78
80 - 99% = 5

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175113, depth: 3, leaf buckets: 3833, nodes: 2150262
Average node length: 6.81, total dup: 1568726, max dup: 49
Average key length: 3.86, compression ratio: 2.33
Average prefix length: 7.41, average data length: 1.59
Clustering factor: 411525, ratio: 0.19
Fill distribution:
0 - 19% = 184
20 - 39% = 1299
40 - 59% = 1600
60 - 79% = 205
80 - 99% = 545

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.36, total records: 647365
Average version length: 35.89, total versions: 1667, max versions: 3
Average fragment length: 11.67, total fragments: 6, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8200
Data pages: 8200, average fill: 75%
Primary pages: 8195, secondary pages: 5, swept pages: 7394
Empty pages: 5, full pages: 7483
Fill distribution:
0 - 19% = 11
20 - 39% = 3
40 - 59% = 26
60 - 79% = 8144
80 - 99% = 16

Index DOC_LIST_ID_DESC (1)
Root page: 244555, depth: 3, leaf buckets: 2389, nodes: 647365
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 151743, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 1335
40 - 59% = 1011
60 - 79% = 40
80 - 99% = 3

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 683, nodes: 647365
Average node length: 4.88, total dup: 647315, max dup: 43835
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 296980, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 579
60 - 79% = 85
80 - 99% = 19

Index PK_DOC_LIST (0)
Root page: 323891, depth: 3, leaf buckets: 1965, nodes: 647365
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 151743, ratio: 0.23
Fill distribution:
0 - 19% = 132
20 - 39% = 643
40 - 59% = 706
60 - 79% = 241
80 - 99% = 243

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.81, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.96, total fragments: 374, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.63
Pointer pages: 1, data page slots: 928
Data pages: 20, average fill: 32%
Primary pages: 9, secondary pages: 11, swept pages: 4
Empty pages: 6, full pages: 3
Fill distribution:
0 - 19% = 9
20 - 39% = 5
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: 57.87, total records: 305
Average version length: 71.00, total versions: 57, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.66
Pointer pages: 2, data page slots: 936
Data pages: 64, average fill: 7%
Primary pages: 64, secondary pages: 0, swept pages: 52
Empty pages: 28, full pages: 1
Fill distribution:
0 - 19% = 58
20 - 39% = 5
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 3, nodes: 305
Average node length: 23.47, total dup: 0, max dup: 0
Average key length: 21.45, compression ratio: 1.26
Average prefix length: 8.54, average data length: 18.46
Clustering factor: 243, ratio: 0.80
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

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

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 2.75, total records: 476
Average version length: 45.84, total versions: 446, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 23.27
Pointer pages: 1, data page slots: 56
Data pages: 40, average fill: 12%
Primary pages: 39, secondary pages: 1, swept pages: 25
Empty pages: 30, full pages: 4
Fill distribution:
0 - 19% = 34
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 5

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 341460, depth: 2, leaf buckets: 1, nodes: 476
Average node length: 5.77, total dup: 411, max dup: 61
Average key length: 3.93, compression ratio: 4.83
Average prefix length: 17.20, average data length: 1.80
Clustering factor: 200, ratio: 0.42
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.46, total records: 254856
Average version length: 29.61, total versions: 974, max versions: 6
Average fragment length: 33.00, total fragments: 2, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.51
Pointer pages: 2, data page slots: 2904
Data pages: 2904, average fill: 65%
Primary pages: 2901, secondary pages: 3, swept pages: 2768
Empty pages: 2, full pages: 422
Fill distribution:
0 - 19% = 8
20 - 39% = 54
40 - 59% = 419
60 - 79% = 2416
80 - 99% = 7

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 237, nodes: 254856
Average node length: 4.62, total dup: 254807, max dup: 13284
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 44346, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 36
40 - 59% = 56
60 - 79% = 115
80 - 99% = 29

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 284, nodes: 254856
Average node length: 5.56, total dup: 229818, max dup: 65
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 56977, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 121
60 - 79% = 94
80 - 99% = 48

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 281, nodes: 254856
Average node length: 5.56, total dup: 229818, max dup: 65
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 56994, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 20
40 - 59% = 117
60 - 79% = 91
80 - 99% = 53

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 306, nodes: 254856
Average node length: 5.35, total dup: 229818, max dup: 65
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 57076, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 54
40 - 59% = 135
60 - 79% = 91
80 - 99% = 25

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.92, total records: 271481
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.15
Pointer pages: 2, data page slots: 2320
Data pages: 2320, average fill: 64%
Primary pages: 2320, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 2316
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2317
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 267985, depth: 2, leaf buckets: 217, nodes: 271481
Average node length: 4.53, total dup: 271300, max dup: 2411
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 22330, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 81
60 - 79% = 71
80 - 99% = 65

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

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

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

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 12821, nodes: 11511391
Average node length: 5.66, total dup: 10654258, max dup: 157
Average key length: 2.18, compression ratio: 3.67
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 4473071, ratio: 0.39
Fill distribution:
0 - 19% = 12
20 - 39% = 0
40 - 59% = 6818
60 - 79% = 4013
80 - 99% = 1978

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11364, nodes: 11511391
Average node length: 4.56, total dup: 11511386, max dup: 10564562
Average key length: 1.08, compression ratio: 0.38
Average prefix length: 0.41, average data length: 0.00
Clustering factor: 342967, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11337
60 - 79% = 1
80 - 99% = 26

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 13877, nodes: 11511391
Average node length: 5.72, total dup: 11143105, max dup: 20934
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 971625, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 10076
60 - 79% = 2094
80 - 99% = 1707

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13970, nodes: 11511391
Average node length: 5.55, total dup: 11482082, max dup: 1479743
Average key length: 2.07, compression ratio: 18.24
Average prefix length: 37.73, average data length: 0.07
Clustering factor: 6644507, ratio: 0.58
Fill distribution:
0 - 19% = 13
20 - 39% = 1
40 - 59% = 11975
60 - 79% = 647
80 - 99% = 1334

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.87, total records: 396963
Average version length: 55.39, total versions: 658, 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: 3, data page slots: 4712
Data pages: 4712, average fill: 74%
Primary pages: 4712, secondary pages: 0, swept pages: 3395
Empty pages: 7, full pages: 4285
Fill distribution:
0 - 19% = 7
20 - 39% = 2
40 - 59% = 26
60 - 79% = 4675
80 - 99% = 2

Index PSTORNED_RCV_ID (2)
Root page: 723076, depth: 3, leaf buckets: 563, nodes: 396963
Average node length: 6.06, total dup: 326161, max dup: 740
Average key length: 3.30, compression ratio: 2.73
Average prefix length: 7.88, average data length: 1.12
Clustering factor: 53123, ratio: 0.13
Fill distribution:
0 - 19% = 18
20 - 39% = 34
40 - 59% = 384
60 - 79% = 95
80 - 99% = 32

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 422, nodes: 396963
Average node length: 5.55, total dup: 355323, max dup: 192
Average key length: 2.79, compression ratio: 3.22
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 94406, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 191
60 - 79% = 150
80 - 99% = 76

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.80, total records: 3236
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.51
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 74%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 39
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 39
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: 39.04, total records: 6048
Average version length: 72.19, total versions: 2779, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.48
Pointer pages: 2, data page slots: 1376
Data pages: 448, average fill: 17%
Primary pages: 447, secondary pages: 1, swept pages: 359
Empty pages: 280, full pages: 67
Fill distribution:
0 - 19% = 341
20 - 39% = 22
40 - 59% = 14
60 - 79% = 46
80 - 99% = 25

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 14, nodes: 6048
Average node length: 6.94, total dup: 5168, max dup: 14
Average key length: 4.89, compression ratio: 7.57
Average prefix length: 34.25, average data length: 2.75
Clustering factor: 978, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 5
60 - 79% = 1
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.96, total records: 1131987
Average version length: 71.35, total versions: 3483, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 11, data page slots: 17232
Data pages: 17232, average fill: 72%
Primary pages: 17232, secondary pages: 0, swept pages: 11462
Empty pages: 119, full pages: 13009
Fill distribution:
0 - 19% = 269
20 - 39% = 293
40 - 59% = 935
60 - 79% = 15699
80 - 99% = 36

Index XQD_1000_3300_DOC (1)
Root page: 457602, depth: 3, leaf buckets: 1287, nodes: 1131987
Average node length: 5.13, total dup: 1102897, max dup: 128
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 125913, ratio: 0.11
Fill distribution:
0 - 19% = 17
20 - 39% = 73
40 - 59% = 952
60 - 79% = 52
80 - 99% = 193

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 278251, depth: 3, leaf buckets: 1656, nodes: 1131987
Average node length: 6.25, total dup: 989019, max dup: 22
Average key length: 3.31, compression ratio: 11.17
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 215794, ratio: 0.19
Fill distribution:
0 - 19% = 14
20 - 39% = 223
40 - 59% = 1159
60 - 79% = 170
80 - 99% = 90

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 43.82, total records: 21220
Average version length: 72.01, total versions: 8337, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.10
Pointer pages: 3, data page slots: 4000
Data pages: 1824, average fill: 14%
Primary pages: 1821, secondary pages: 3, swept pages: 1505
Empty pages: 1105, full pages: 158
Fill distribution:
0 - 19% = 1395
20 - 39% = 181
40 - 59% = 69
60 - 79% = 83
80 - 99% = 96

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 43, nodes: 21220
Average node length: 6.30, total dup: 18594, max dup: 45
Average key length: 3.77, compression ratio: 9.82
Average prefix length: 35.35, average data length: 1.65
Clustering factor: 2619, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 26
40 - 59% = 10
60 - 79% = 4
80 - 99% = 2

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.35, total records: 1722845
Average version length: 71.55, total versions: 43633, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.93
Pointer pages: 17, data page slots: 26768
Data pages: 26752, average fill: 71%
Primary pages: 26751, secondary pages: 1, swept pages: 16145
Empty pages: 213, full pages: 18729
Fill distribution:
0 - 19% = 422
20 - 39% = 781
40 - 59% = 2542
60 - 79% = 22030
80 - 99% = 977

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 194787, depth: 3, leaf buckets: 2719, nodes: 1722845
Average node length: 5.62, total dup: 1619090, max dup: 49
Average key length: 2.66, compression ratio: 13.91
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 230030, ratio: 0.13
Fill distribution:
0 - 19% = 5
20 - 39% = 1196
40 - 59% = 1104
60 - 79% = 296
80 - 99% = 118

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 12.43, total records: 2725
Average version length: 70.74, total versions: 2243, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 10.94
Pointer pages: 3, data page slots: 2200
Data pages: 432, average fill: 8%
Primary pages: 431, secondary pages: 1, swept pages: 327
Empty pages: 335, full pages: 30
Fill distribution:
0 - 19% = 380
20 - 39% = 18
40 - 59% = 3
60 - 79% = 11
80 - 99% = 20

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 9, nodes: 2725
Average node length: 8.65, total dup: 2170, max dup: 49
Average key length: 6.29, compression ratio: 5.88
Average prefix length: 32.91, average data length: 4.09
Clustering factor: 378, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.96, total records: 2651025
Average version length: 71.29, total versions: 16476, 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: 24, data page slots: 37880
Data pages: 37880, average fill: 76%
Primary pages: 37880, secondary pages: 0, swept pages: 27896
Empty pages: 15, full pages: 34000
Fill distribution:
0 - 19% = 46
20 - 39% = 134
40 - 59% = 593
60 - 79% = 36671
80 - 99% = 436

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5560, nodes: 2651025
Average node length: 6.90, total dup: 2141251, max dup: 16
Average key length: 3.92, compression ratio: 9.43
Average prefix length: 35.27, average data length: 1.73
Clustering factor: 517805, ratio: 0.20
Fill distribution:
0 - 19% = 5
20 - 39% = 3026
40 - 59% = 2176
60 - 79% = 206
80 - 99% = 147

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.65, total records: 4699983
Average version length: 84.41, total versions: 1331, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 45, data page slots: 72280
Data pages: 72280, average fill: 80%
Primary pages: 72280, secondary pages: 0, swept pages: 27130
Empty pages: 10, full pages: 71673
Fill distribution:
0 - 19% = 13
20 - 39% = 8
40 - 59% = 43
60 - 79% = 21437
80 - 99% = 50779

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4838, nodes: 4699983
Average node length: 5.16, total dup: 4592720, max dup: 128
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 748397, ratio: 0.16
Fill distribution:
0 - 19% = 19
20 - 39% = 123
40 - 59% = 2176
60 - 79% = 1967
80 - 99% = 553

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5235, nodes: 4699983
Average node length: 5.70, total dup: 4203056, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 247116, ratio: 0.05
Fill distribution:
0 - 19% = 55
20 - 39% = 177
40 - 59% = 3048
60 - 79% = 312
80 - 99% = 1643

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5393, nodes: 4699983
Average node length: 5.81, total dup: 4111730, max dup: 19
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 806084, ratio: 0.17
Fill distribution:
0 - 19% = 23
20 - 39% = 114
40 - 59% = 2478
60 - 79% = 1978
80 - 99% = 800

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.80, total records: 2404055
Average version length: 83.83, total versions: 9331, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 24, data page slots: 37792
Data pages: 37792, average fill: 78%
Primary pages: 37792, secondary pages: 0, swept pages: 27858
Empty pages: 30, full pages: 35351
Fill distribution:
0 - 19% = 87
20 - 39% = 162
40 - 59% = 544
60 - 79% = 16632
80 - 99% = 20367

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2589, nodes: 2404055
Average node length: 5.15, total dup: 2347774, max dup: 170
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 375632, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 53
40 - 59% = 1535
60 - 79% = 751
80 - 99% = 246

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4089, nodes: 2404055
Average node length: 6.24, total dup: 1968652, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 241770, ratio: 0.10
Fill distribution:
0 - 19% = 110
20 - 39% = 1553
40 - 59% = 1714
60 - 79% = 488
80 - 99% = 224

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2972, nodes: 2404055
Average node length: 5.82, total dup: 2102755, max dup: 29
Average key length: 2.84, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 451370, ratio: 0.19
Fill distribution:
0 - 19% = 25
20 - 39% = 60
40 - 59% = 1830
60 - 79% = 810
80 - 99% = 247

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.56, total records: 4987267
Average version length: 85.27, total versions: 13947, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 48, data page slots: 77944
Data pages: 77888, average fill: 79%
Primary pages: 77888, secondary pages: 0, swept pages: 23924
Empty pages: 135, full pages: 73594
Fill distribution:
0 - 19% = 282
20 - 39% = 428
40 - 59% = 1214
60 - 79% = 18250
80 - 99% = 57714

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5286, nodes: 4987267
Average node length: 5.04, total dup: 4958394, max dup: 636
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 748350, ratio: 0.15
Fill distribution:
0 - 19% = 7
20 - 39% = 228
40 - 59% = 3070
60 - 79% = 1465
80 - 99% = 516

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6118, nodes: 4987267
Average node length: 5.54, total dup: 4585759, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 283256, ratio: 0.06
Fill distribution:
0 - 19% = 86
20 - 39% = 1631
40 - 59% = 2488
60 - 79% = 597
80 - 99% = 1316

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5954, nodes: 4987267
Average node length: 5.69, total dup: 4468453, max dup: 86
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 833128, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 199
40 - 59% = 3481
60 - 79% = 1682
80 - 99% = 588

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.12, total records: 3304886
Average version length: 84.19, total versions: 11260, 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: 32, data page slots: 51880
Data pages: 51880, average fill: 78%
Primary pages: 51880, secondary pages: 0, swept pages: 37491
Empty pages: 22, full pages: 48631
Fill distribution:
0 - 19% = 67
20 - 39% = 150
40 - 59% = 634
60 - 79% = 21640
80 - 99% = 29389

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3589, nodes: 3304886
Average node length: 5.03, total dup: 3288268, max dup: 1199
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 689268, ratio: 0.21
Fill distribution:
0 - 19% = 23
20 - 39% = 354
40 - 59% = 1923
60 - 79% = 891
80 - 99% = 398

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5750, nodes: 3304886
Average node length: 6.26, total dup: 2700373, max dup: 14
Average key length: 3.28, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 372637, ratio: 0.11
Fill distribution:
0 - 19% = 202
20 - 39% = 2313
40 - 59% = 2258
60 - 79% = 638
80 - 99% = 339

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3921, nodes: 3304886
Average node length: 5.61, total dup: 3003589, max dup: 64
Average key length: 2.63, compression ratio: 3.42
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 729392, ratio: 0.22
Fill distribution:
0 - 19% = 12
20 - 39% = 332
40 - 59% = 2022
60 - 79% = 1074
80 - 99% = 481

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.25, total records: 660650
Average version length: 69.53, total versions: 1573, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 6, data page slots: 9200
Data pages: 9200, average fill: 76%
Primary pages: 9200, secondary pages: 0, swept pages: 6961
Empty pages: 12, full pages: 8512
Fill distribution:
0 - 19% = 25
20 - 39% = 65
40 - 59% = 171
60 - 79% = 8902
80 - 99% = 37

Index XQS_3300_3400_DOC_ID (0)
Root page: 175735, depth: 3, leaf buckets: 813, nodes: 660650
Average node length: 5.31, total dup: 623043, max dup: 119
Average key length: 2.43, compression ratio: 3.70
Average prefix length: 8.62, average data length: 0.38
Clustering factor: 54867, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 208
40 - 59% = 339
60 - 79% = 175
80 - 99% = 91

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 914, nodes: 660650
Average node length: 5.93, total dup: 564480, max dup: 27
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 60028, ratio: 0.09
Fill distribution:
0 - 19% = 5
20 - 39% = 237
40 - 59% = 383
60 - 79% = 199
80 - 99% = 90

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Done for 75850 ms, from 7:20:38.95 to 7:21:54.80.

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

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 2150262 3196 0.1486
DOC_LIST 647365 1667 0.2575
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 305 57 18.6885
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 476 446 93.6974
OPTYPES 9 0 0.0000
PDISTR 254856 974 0.3821
PERF_ESTIMATED 271481 0 0.0000
PERF_LOG 11511391 0 0.0000
PSTORNED 396963 658 0.1657
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 3236 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 6048 2779 45.9490
XQD_1000_3300 1131987 3483 0.3076
XQD_1200_2000 21220 8337 39.2884
XQD_2000_3300 1722845 43633 2.5326
XQD_2100_3300 2725 2243 82.3119
XQD_3300_3400 2651025 16476 0.6214
XQS_1000_1200 4699983 1331 0.0283
XQS_1000_3300 2404055 9331 0.3881
XQS_1200_2000 4987267 13947 0.2796
XQS_2100_3300 3304886 11260 0.3407
XQS_3300_3400 660650 1573 0.2380
Z_USED_VIEWS 29 0 0.0000
Done for 2460 ms, from 7:22:07.94 to 7:22:10.40.

Database validation

07:22:10.48 Validation started

07:22:10.50 Relation 140 (DOC_LIST)
07:22:10.50 process pointer page 0 of 6
07:22:10.56 process pointer page 1 of 6
07:22:10.65 process pointer page 2 of 6
07:22:10.70 process pointer page 3 of 6
07:22:10.74 process pointer page 4 of 6
07:22:10.78 process pointer page 5 of 6
07:22:10.78 Index 1 (PK_DOC_LIST)
07:22:11.03 Index 2 (DOC_LIST_ID_DESC)
07:22:11.31 Index 3 (FK_DOC_LIST_AGENTS)
07:22:11.57 Relation 140 (DOC_LIST) is ok

07:22:11.57 Relation 141 (DOC_DATA)
07:22:11.57 process pointer page 0 of 15
07:22:11.67 process pointer page 1 of 15
07:22:11.76 process pointer page 2 of 15
07:22:11.85 process pointer page 3 of 15
07:22:11.95 process pointer page 4 of 15
07:22:12.04 process pointer page 5 of 15
07:22:12.13 process pointer page 6 of 15
07:22:12.23 process pointer page 7 of 15
07:22:12.30 process pointer page 8 of 15
07:22:12.34 process pointer page 9 of 15
07:22:12.38 process pointer page 10 of 15
07:22:12.41 process pointer page 11 of 15
07:22:12.45 process pointer page 12 of 15
07:22:12.48 process pointer page 13 of 15
07:22:12.51 process pointer page 14 of 15
07:22:12.52 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:22:13.46 Index 3 (DOC_DATA_ID_DESC)
07:22:14.40 Index 4 (FK_DOC_DATA_DOC_LIST)
07:22:14.97 Relation 141 (DOC_DATA) is ok

07:22:14.97 Relation 147 (INVNT_SALDO)
07:22:14.97 process pointer page 0 of 1
07:22:14.97 Index 1 (PK_INVNT_SALDO)
07:22:14.97 Relation 147 (INVNT_SALDO) is ok

07:22:14.97 Relation 150 (PDISTR)
07:22:14.97 process pointer page 0 of 2
07:22:15.02 process pointer page 1 of 2
07:22:15.03 Index 2 (PDISTR_SND_ID)
07:22:15.13 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:22:15.22 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:22:15.30 Index 5 (PDISTR_AGENT_ID)
07:22:15.38 Relation 150 (PDISTR) is ok

07:22:15.38 Relation 151 (PSTORNED)
07:22:15.38 process pointer page 0 of 3
07:22:15.47 process pointer page 1 of 3
07:22:15.57 process pointer page 2 of 3
07:22:15.64 Index 2 (PSTORNED_SND_ID)
07:22:15.77 Index 3 (PSTORNED_RCV_ID)
07:22:15.89 Relation 151 (PSTORNED) is ok

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

07:22:15.89 Relation 157 (INVNT_TURNOVER_LOG)
07:22:15.89 process pointer page 0 of 2
07:22:15.91 process pointer page 1 of 2
07:22:15.91 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:22:15.91 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:22:15.91 Relation 160 (PERF_ESTIMATED)
07:22:15.91 process pointer page 0 of 2
07:22:16.00 process pointer page 1 of 2
07:22:16.03 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:22:16.11 Relation 160 (PERF_ESTIMATED) is ok

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

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

07:22:16.11 Relation 163 (PERF_LOG)
07:22:16.11 process pointer page 0 of 168
07:22:16.19 process pointer page 1 of 168
07:22:16.27 process pointer page 2 of 168
07:22:16.35 process pointer page 3 of 168
07:22:16.42 process pointer page 4 of 168
07:22:16.52 process pointer page 5 of 168
07:22:16.59 process pointer page 6 of 168
07:22:16.67 process pointer page 7 of 168
07:22:16.75 process pointer page 8 of 168
07:22:16.83 process pointer page 9 of 168
07:22:16.91 process pointer page 10 of 168
07:22:17.00 process pointer page 11 of 168
07:22:17.08 process pointer page 12 of 168
07:22:17.16 process pointer page 13 of 168
07:22:17.23 process pointer page 14 of 168
07:22:17.31 process pointer page 15 of 168
07:22:17.39 process pointer page 16 of 168
07:22:17.47 process pointer page 17 of 168
07:22:17.56 process pointer page 18 of 168
07:22:17.64 process pointer page 19 of 168
07:22:17.72 process pointer page 20 of 168
07:22:17.80 process pointer page 21 of 168
07:22:17.87 process pointer page 22 of 168
07:22:17.97 process pointer page 23 of 168
07:22:18.05 process pointer page 24 of 168
07:22:18.12 process pointer page 25 of 168
07:22:18.20 process pointer page 26 of 168
07:22:18.28 process pointer page 27 of 168
07:22:18.37 process pointer page 28 of 168
07:22:18.45 process pointer page 29 of 168
07:22:18.53 process pointer page 30 of 168
07:22:18.61 process pointer page 31 of 168
07:22:18.69 process pointer page 32 of 168
07:22:18.78 process pointer page 33 of 168
07:22:18.86 process pointer page 34 of 168
07:22:18.93 process pointer page 35 of 168
07:22:19.01 process pointer page 36 of 168
07:22:19.09 process pointer page 37 of 168
07:22:19.17 process pointer page 38 of 168
07:22:19.25 process pointer page 39 of 168
07:22:19.32 process pointer page 40 of 168
07:22:19.42 process pointer page 41 of 168
07:22:19.50 process pointer page 42 of 168
07:22:19.57 process pointer page 43 of 168
07:22:19.65 process pointer page 44 of 168
07:22:19.75 process pointer page 45 of 168
07:22:19.82 process pointer page 46 of 168
07:22:19.90 process pointer page 47 of 168
07:22:19.98 process pointer page 48 of 168
07:22:20.10 process pointer page 49 of 168
07:22:20.18 process pointer page 50 of 168
07:22:20.26 process pointer page 51 of 168
07:22:20.34 process pointer page 52 of 168
07:22:20.42 process pointer page 53 of 168
07:22:20.49 process pointer page 54 of 168
07:22:20.57 process pointer page 55 of 168
07:22:20.65 process pointer page 56 of 168
07:22:20.73 process pointer page 57 of 168
07:22:20.81 process pointer page 58 of 168
07:22:20.88 process pointer page 59 of 168
07:22:20.96 process pointer page 60 of 168
07:22:21.04 process pointer page 61 of 168
07:22:21.12 process pointer page 62 of 168
07:22:21.20 process pointer page 63 of 168
07:22:21.27 process pointer page 64 of 168
07:22:21.37 process pointer page 65 of 168
07:22:21.45 process pointer page 66 of 168
07:22:21.52 process pointer page 67 of 168
07:22:21.60 process pointer page 68 of 168
07:22:21.68 process pointer page 69 of 168
07:22:21.76 process pointer page 70 of 168
07:22:21.84 process pointer page 71 of 168
07:22:21.91 process pointer page 72 of 168
07:22:21.99 process pointer page 73 of 168
07:22:22.09 process pointer page 74 of 168
07:22:22.16 process pointer page 75 of 168
07:22:22.24 process pointer page 76 of 168
07:22:22.32 process pointer page 77 of 168
07:22:22.40 process pointer page 78 of 168
07:22:22.48 process pointer page 79 of 168
07:22:22.52 process pointer page 80 of 168
07:22:22.57 process pointer page 81 of 168
07:22:22.65 process pointer page 82 of 168
07:22:22.73 process pointer page 83 of 168
07:22:22.80 process pointer page 84 of 168
07:22:22.88 process pointer page 85 of 168
07:22:22.96 process pointer page 86 of 168
07:22:23.05 process pointer page 87 of 168
07:22:23.13 process pointer page 88 of 168
07:22:23.21 process pointer page 89 of 168
07:22:23.29 process pointer page 90 of 168
07:22:23.37 process pointer page 91 of 168
07:22:23.44 process pointer page 92 of 168
07:22:23.52 process pointer page 93 of 168
07:22:23.60 process pointer page 94 of 168
07:22:23.69 process pointer page 95 of 168
07:22:23.77 process pointer page 96 of 168
07:22:23.85 process pointer page 97 of 168
07:22:23.93 process pointer page 98 of 168
07:22:24.00 process pointer page 99 of 168
07:22:24.08 process pointer page 100 of 168
07:22:24.16 process pointer page 101 of 168
07:22:24.24 process pointer page 102 of 168
07:22:24.32 process pointer page 103 of 168
07:22:24.41 process pointer page 104 of 168
07:22:24.49 process pointer page 105 of 168
07:22:24.57 process pointer page 106 of 168
07:22:24.64 process pointer page 107 of 168
07:22:24.72 process pointer page 108 of 168
07:22:24.80 process pointer page 109 of 168
07:22:24.88 process pointer page 110 of 168
07:22:24.96 process pointer page 111 of 168
07:22:25.03 process pointer page 112 of 168
07:22:25.11 process pointer page 113 of 168
07:22:25.19 process pointer page 114 of 168
07:22:25.28 process pointer page 115 of 168
07:22:25.36 process pointer page 116 of 168
07:22:25.44 process pointer page 117 of 168
07:22:25.52 process pointer page 118 of 168
07:22:25.60 process pointer page 119 of 168
07:22:25.67 process pointer page 120 of 168
07:22:25.75 process pointer page 121 of 168
07:22:25.83 process pointer page 122 of 168
07:22:25.91 process pointer page 123 of 168
07:22:26.00 process pointer page 124 of 168
07:22:26.08 process pointer page 125 of 168
07:22:26.16 process pointer page 126 of 168
07:22:26.24 process pointer page 127 of 168
07:22:26.31 process pointer page 128 of 168
07:22:26.39 process pointer page 129 of 168
07:22:26.47 process pointer page 130 of 168
07:22:26.56 process pointer page 131 of 168
07:22:26.64 process pointer page 132 of 168
07:22:26.72 process pointer page 133 of 168
07:22:26.80 process pointer page 134 of 168
07:22:26.88 process pointer page 135 of 168
07:22:26.95 process pointer page 136 of 168
07:22:27.03 process pointer page 137 of 168
07:22:27.12 process pointer page 138 of 168
07:22:27.20 process pointer page 139 of 168
07:22:27.28 process pointer page 140 of 168
07:22:27.36 process pointer page 141 of 168
07:22:27.44 process pointer page 142 of 168
07:22:27.51 process pointer page 143 of 168
07:22:27.59 process pointer page 144 of 168
07:22:27.67 process pointer page 145 of 168
07:22:27.76 process pointer page 146 of 168
07:22:27.84 process pointer page 147 of 168
07:22:27.92 process pointer page 148 of 168
07:22:28.00 process pointer page 149 of 168
07:22:28.08 process pointer page 150 of 168
07:22:28.15 process pointer page 151 of 168
07:22:28.25 process pointer page 152 of 168
07:22:28.33 process pointer page 153 of 168
07:22:28.40 process pointer page 154 of 168
07:22:28.48 process pointer page 155 of 168
07:22:28.56 process pointer page 156 of 168
07:22:28.64 process pointer page 157 of 168
07:22:28.72 process pointer page 158 of 168
07:22:28.79 process pointer page 159 of 168
07:22:28.89 process pointer page 160 of 168
07:22:28.97 process pointer page 161 of 168
07:22:29.04 process pointer page 162 of 168
07:22:29.12 process pointer page 163 of 168
07:22:29.20 process pointer page 164 of 168
07:22:29.28 process pointer page 165 of 168
07:22:29.36 process pointer page 166 of 168
07:22:29.43 process pointer page 167 of 168
07:22:29.46 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:22:33.72 Index 2 (PERF_LOG_UNIT)
07:22:40.07 Index 3 (PERF_LOG_TRN_DESC)
07:22:43.07 Index 4 (PERF_LOG_GDSCODE)
07:22:45.63 Relation 163 (PERF_LOG) is ok

07:22:45.63 Relation 167 (V_STOPTEST)
07:22:45.63 Relation 167 (V_STOPTEST) is ok

07:22:45.63 Relation 184 (V_QDISTR_SOURCE)
07:22:45.63 Relation 184 (V_QDISTR_SOURCE) is ok

07:22:45.63 Relation 185 (V_QSTORNED_SOURCE)
07:22:45.63 Relation 185 (V_QSTORNED_SOURCE) is ok

07:22:45.63 Relation 260 (XQD_1000_1200)
07:22:45.64 process pointer page 0 of 2
07:22:45.66 process pointer page 1 of 2
07:22:45.66 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:22:45.66 Relation 260 (XQD_1000_1200) is ok

07:22:45.66 Relation 261 (XQD_1200_2000)
07:22:45.66 process pointer page 0 of 3
07:22:45.70 process pointer page 1 of 3
07:22:45.74 process pointer page 2 of 3
07:22:45.74 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:22:45.75 Relation 261 (XQD_1200_2000) is ok

07:22:45.75 Relation 262 (XQD_1000_3300)
07:22:45.75 process pointer page 0 of 11
07:22:45.83 process pointer page 1 of 11
07:22:45.92 process pointer page 2 of 11
07:22:46.00 process pointer page 3 of 11
07:22:46.09 process pointer page 4 of 11
07:22:46.17 process pointer page 5 of 11
07:22:46.25 process pointer page 6 of 11
07:22:46.34 process pointer page 7 of 11
07:22:46.44 process pointer page 8 of 11
07:22:46.52 process pointer page 9 of 11
07:22:46.61 process pointer page 10 of 11
07:22:46.66 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:22:47.08 Index 2 (XQD_1000_3300_DOC)
07:22:47.40 Relation 262 (XQD_1000_3300) is ok

07:22:47.40 Relation 263 (XQD_2000_3300)
07:22:47.40 process pointer page 0 of 17
07:22:47.50 process pointer page 1 of 17
07:22:47.59 process pointer page 2 of 17
07:22:47.69 process pointer page 3 of 17
07:22:47.78 process pointer page 4 of 17
07:22:47.87 process pointer page 5 of 17
07:22:47.97 process pointer page 6 of 17
07:22:48.06 process pointer page 7 of 17
07:22:48.14 process pointer page 8 of 17
07:22:48.23 process pointer page 9 of 17
07:22:48.33 process pointer page 10 of 17
07:22:48.42 process pointer page 11 of 17
07:22:48.51 process pointer page 12 of 17
07:22:48.61 process pointer page 13 of 17
07:22:48.68 process pointer page 14 of 17
07:22:48.78 process pointer page 15 of 17
07:22:48.86 process pointer page 16 of 17
07:22:48.90 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:22:49.51 Relation 263 (XQD_2000_3300) is ok

07:22:49.51 Relation 264 (XQD_2100_3300)
07:22:49.51 process pointer page 0 of 3
07:22:49.53 process pointer page 1 of 3
07:22:49.54 process pointer page 2 of 3
07:22:49.54 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:22:49.54 Relation 264 (XQD_2100_3300) is ok

07:22:49.54 Relation 265 (XQD_3300_3400)
07:22:49.54 process pointer page 0 of 24
07:22:49.62 process pointer page 1 of 24
07:22:49.71 process pointer page 2 of 24
07:22:49.81 process pointer page 3 of 24
07:22:49.90 process pointer page 4 of 24
07:22:49.99 process pointer page 5 of 24
07:22:50.07 process pointer page 6 of 24
07:22:50.17 process pointer page 7 of 24
07:22:50.26 process pointer page 8 of 24
07:22:50.35 process pointer page 9 of 24
07:22:50.43 process pointer page 10 of 24
07:22:50.52 process pointer page 11 of 24
07:22:50.62 process pointer page 12 of 24
07:22:50.71 process pointer page 13 of 24
07:22:50.81 process pointer page 14 of 24
07:22:50.88 process pointer page 15 of 24
07:22:50.98 process pointer page 16 of 24
07:22:51.07 process pointer page 17 of 24
07:22:51.16 process pointer page 18 of 24
07:22:51.26 process pointer page 19 of 24
07:22:51.34 process pointer page 20 of 24
07:22:51.43 process pointer page 21 of 24
07:22:51.52 process pointer page 22 of 24
07:22:51.62 process pointer page 23 of 24
07:22:51.63 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:22:52.77 Relation 265 (XQD_3300_3400) is ok

07:22:52.77 Relation 266 (XQS_1000_1200)
07:22:52.77 process pointer page 0 of 45
07:22:52.86 process pointer page 1 of 45
07:22:52.96 process pointer page 2 of 45
07:22:53.04 process pointer page 3 of 45
07:22:53.13 process pointer page 4 of 45
07:22:53.22 process pointer page 5 of 45
07:22:53.30 process pointer page 6 of 45
07:22:53.40 process pointer page 7 of 45
07:22:53.49 process pointer page 8 of 45
07:22:53.58 process pointer page 9 of 45
07:22:53.66 process pointer page 10 of 45
07:22:53.75 process pointer page 11 of 45
07:22:53.85 process pointer page 12 of 45
07:22:53.93 process pointer page 13 of 45
07:22:54.02 process pointer page 14 of 45
07:22:54.11 process pointer page 15 of 45
07:22:54.21 process pointer page 16 of 45
07:22:54.28 process pointer page 17 of 45
07:22:54.38 process pointer page 18 of 45
07:22:54.47 process pointer page 19 of 45
07:22:54.55 process pointer page 20 of 45
07:22:54.64 process pointer page 21 of 45
07:22:54.74 process pointer page 22 of 45
07:22:54.81 process pointer page 23 of 45
07:22:54.91 process pointer page 24 of 45
07:22:55.00 process pointer page 25 of 45
07:22:55.08 process pointer page 26 of 45
07:22:55.17 process pointer page 27 of 45
07:22:55.27 process pointer page 28 of 45
07:22:55.35 process pointer page 29 of 45
07:22:55.44 process pointer page 30 of 45
07:22:55.53 process pointer page 31 of 45
07:22:55.61 process pointer page 32 of 45
07:22:55.70 process pointer page 33 of 45
07:22:55.80 process pointer page 34 of 45
07:22:55.88 process pointer page 35 of 45
07:22:55.97 process pointer page 36 of 45
07:22:56.06 process pointer page 37 of 45
07:22:56.16 process pointer page 38 of 45
07:22:56.25 process pointer page 39 of 45
07:22:56.34 process pointer page 40 of 45
07:22:56.42 process pointer page 41 of 45
07:22:56.52 process pointer page 42 of 45
07:22:56.61 process pointer page 43 of 45
07:22:56.69 process pointer page 44 of 45
07:22:56.72 Index 1 (XQS_1000_1200_DOC_ID)
07:22:58.14 Index 2 (XQS_1000_1200_SND_ID)
07:22:59.59 Index 3 (XQS_1000_1200_RCV_ID)
07:23:00.81 Relation 266 (XQS_1000_1200) is ok

07:23:00.81 Relation 267 (XQS_1200_2000)
07:23:00.81 process pointer page 0 of 48
07:23:00.90 process pointer page 1 of 48
07:23:00.99 process pointer page 2 of 48
07:23:01.09 process pointer page 3 of 48
07:23:01.18 process pointer page 4 of 48
07:23:01.26 process pointer page 5 of 48
07:23:01.35 process pointer page 6 of 48
07:23:01.44 process pointer page 7 of 48
07:23:01.54 process pointer page 8 of 48
07:23:01.63 process pointer page 9 of 48
07:23:01.74 process pointer page 10 of 48
07:23:01.85 process pointer page 11 of 48
07:23:01.94 process pointer page 12 of 48
07:23:02.05 process pointer page 13 of 48
07:23:02.16 process pointer page 14 of 48
07:23:02.26 process pointer page 15 of 48
07:23:02.37 process pointer page 16 of 48
07:23:02.47 process pointer page 17 of 48
07:23:02.57 process pointer page 18 of 48
07:23:02.68 process pointer page 19 of 48
07:23:02.77 process pointer page 20 of 48
07:23:02.88 process pointer page 21 of 48
07:23:02.99 process pointer page 22 of 48
07:23:03.08 process pointer page 23 of 48
07:23:03.19 process pointer page 24 of 48
07:23:03.30 process pointer page 25 of 48
07:23:03.39 process pointer page 26 of 48
07:23:03.50 process pointer page 27 of 48
07:23:03.61 process pointer page 28 of 48
07:23:03.71 process pointer page 29 of 48
07:23:03.82 process pointer page 30 of 48
07:23:03.93 process pointer page 31 of 48
07:23:04.02 process pointer page 32 of 48
07:23:04.13 process pointer page 33 of 48
07:23:04.22 process pointer page 34 of 48
07:23:04.33 process pointer page 35 of 48
07:23:04.44 process pointer page 36 of 48
07:23:04.53 process pointer page 37 of 48
07:23:04.64 process pointer page 38 of 48
07:23:04.75 process pointer page 39 of 48
07:23:04.85 process pointer page 40 of 48
07:23:04.95 process pointer page 41 of 48
07:23:05.05 process pointer page 42 of 48
07:23:05.16 process pointer page 43 of 48
07:23:05.25 process pointer page 44 of 48
07:23:05.36 process pointer page 45 of 48
07:23:05.45 process pointer page 46 of 48
07:23:05.55 process pointer page 47 of 48
07:23:05.63 Index 1 (XQS_1200_2000_DOC_ID)
07:23:07.00 Index 2 (XQS_1200_2000_SND_ID)
07:23:08.67 Index 3 (XQS_1200_2000_RCV_ID)
07:23:10.27 Relation 267 (XQS_1200_2000) is ok

07:23:10.27 Relation 268 (XQS_1000_3300)
07:23:10.27 process pointer page 0 of 24
07:23:10.76 process pointer page 1 of 24
07:23:11.24 process pointer page 2 of 24
07:23:11.71 process pointer page 3 of 24
07:23:12.19 process pointer page 4 of 24
07:23:12.68 process pointer page 5 of 24
07:23:13.16 process pointer page 6 of 24
07:23:13.63 process pointer page 7 of 24
07:23:14.11 process pointer page 8 of 24
07:23:14.60 process pointer page 9 of 24
07:23:15.08 process pointer page 10 of 24
07:23:15.55 process pointer page 11 of 24
07:23:16.02 process pointer page 12 of 24
07:23:16.50 process pointer page 13 of 24
07:23:16.97 process pointer page 14 of 24
07:23:17.43 process pointer page 15 of 24
07:23:17.90 process pointer page 16 of 24
07:23:18.37 process pointer page 17 of 24
07:23:18.84 process pointer page 18 of 24
07:23:19.31 process pointer page 19 of 24
07:23:19.77 process pointer page 20 of 24
07:23:20.26 process pointer page 21 of 24
07:23:20.71 process pointer page 22 of 24
07:23:21.16 process pointer page 23 of 24
07:23:21.23 Index 1 (XQS_1000_3300_DOC_ID)
07:23:22.72 Index 2 (XQS_1000_3300_SND_ID)
07:23:24.38 Index 3 (XQS_1000_3300_RCV_ID)
07:23:26.11 Relation 268 (XQS_1000_3300) is ok

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

07:23:26.12 Relation 270 (XQS_2100_3300)
07:23:26.12 process pointer page 0 of 32
07:23:26.59 process pointer page 1 of 32
07:23:27.08 process pointer page 2 of 32
07:23:27.54 process pointer page 3 of 32
07:23:28.03 process pointer page 4 of 32
07:23:28.50 process pointer page 5 of 32
07:23:28.98 process pointer page 6 of 32
07:23:29.46 process pointer page 7 of 32
07:23:29.93 process pointer page 8 of 32
07:23:30.41 process pointer page 9 of 32
07:23:30.90 process pointer page 10 of 32
07:23:31.38 process pointer page 11 of 32
07:23:31.86 process pointer page 12 of 32
07:23:32.40 process pointer page 13 of 32
07:23:32.88 process pointer page 14 of 32
07:23:33.35 process pointer page 15 of 32
07:23:33.81 process pointer page 16 of 32
07:23:34.31 process pointer page 17 of 32
07:23:34.78 process pointer page 18 of 32
07:23:35.25 process pointer page 19 of 32
07:23:35.70 process pointer page 20 of 32
07:23:36.17 process pointer page 21 of 32
07:23:36.62 process pointer page 22 of 32
07:23:37.08 process pointer page 23 of 32
07:23:37.53 process pointer page 24 of 32
07:23:37.98 process pointer page 25 of 32
07:23:38.45 process pointer page 26 of 32
07:23:38.90 process pointer page 27 of 32
07:23:39.37 process pointer page 28 of 32
07:23:39.81 process pointer page 29 of 32
07:23:40.26 process pointer page 30 of 32
07:23:40.71 process pointer page 31 of 32
07:23:41.05 Index 1 (XQS_2100_3300_DOC_ID)
07:23:43.00 Index 2 (XQS_2100_3300_SND_ID)
07:23:45.33 Index 3 (XQS_2100_3300_RCV_ID)
07:23:47.81 Relation 270 (XQS_2100_3300) is ok

07:23:47.81 Relation 271 (XQS_3300_3400)
07:23:47.81 process pointer page 0 of 6
07:23:48.26 process pointer page 1 of 6
07:23:48.73 process pointer page 2 of 6
07:23:49.18 process pointer page 3 of 6
07:23:49.63 process pointer page 4 of 6
07:23:50.10 process pointer page 5 of 6
07:23:50.38 Index 1 (XQS_3300_3400_DOC_ID)
07:23:50.77 Index 2 (XQS_3300_3400_SND_ID)
07:23:51.19 Relation 271 (XQS_3300_3400) is ok

07:23:51.21 Validation finished
Done for 100870 ms, from 7:22:10.43 to 7:23:51.30.

Differences between old and current firebird.log

7:23:53.52. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-05-19 07:23 471 oltp30_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

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

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


Remove 401 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-05-19 7:24:03.08 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html