Firebird 4.0 Performance Logs

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-04-11 11:21:32.00.
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-T4.0.0.585 Firebird 4.0 Unstable
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 4.0.0 D:\OLTP-EMUL\OLTP40-SMALL.FDB ON 0 786432 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB40.TMPINSTANCE
dbnm D:\OLTP-EMUL\oltp40-small.fdb
host localhost
port 3400
usr SYSDBA
pwd masterkey
tmpdir e:\temp\logs.oltp40
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\oltp40-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-04-11 11:17:55.1750 -1 <null> ::1/62809 448438 9219 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 179 minutes: 6353.50 3449 1137277 2017-04-11 08:18 2017-04-11 11:17
customer order: creation 480.46 474 86002 2017-04-11 08:18 2017-04-11 11:17
customer order: refuse 39.13 238 7004 2017-04-11 08:18 2017-04-11 11:17
order to supplier: creation 123.06 2092 22028 2017-04-11 08:18 2017-04-11 11:17
order to supplier: removal 3.16 24177 565 2017-04-11 08:18 2017-04-11 11:17
invoice (draft): creation 124.02 3004 22200 2017-04-11 08:18 2017-04-11 11:17
invoice (draft): removal 43.12 475 7718 2017-04-11 08:18 2017-04-11 11:17
invoice accept: apply 68.91 12390 12335 2017-04-11 08:18 2017-04-11 11:17
invoice accept: cancel 20.07 2743 3593 2017-04-11 08:18 2017-04-11 11:17
customer reserve: creation 3632.99 195 650305 2017-04-11 08:18 2017-04-11 11:17
customer reserve: removal 1153.60 73 206494 2017-04-11 08:18 2017-04-11 11:17
realization accept: apply 224.59 542 40202 2017-04-11 08:18 2017-04-11 11:17
realization accept: cancel 93.78 152 16787 2017-04-11 08:18 2017-04-11 11:17
payment from customer: creation 160.22 895 28680 2017-04-11 08:18 2017-04-11 11:17
payment from customer: removal 15.35 133 2747 2017-04-11 08:18 2017-04-11 11:17
payment to supplier: creation 132.98 990 23804 2017-04-11 08:18 2017-04-11 11:17
payment to supplier: removal 9.04 127 1618 2017-04-11 08:18 2017-04-11 11:17
service: total inventory turnovers 9.75 2948 1745 2017-04-11 08:18 2017-04-11 11:17
service: total monetary turnovers 19.21 65 3438 2017-04-11 08:18 2017-04-11 11:17
service: refresh index statistics 0.07 13812 12 2017-04-11 08:18 2017-04-11 11:17
Done for 132960 ms, from 11:23:54.28 to 11:26:07.24.

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 5381 112646 96866 15780 14.01 08:17:56 08:35:55
interval # 2, overall 2 6648 135728 119670 16058 11.83 08:35:56 08:53:55
interval # 3, overall 3 6917 137110 124497 12613 9.20 08:53:56 09:11:55
interval # 4, overall 4 6159 120564 110866 9698 8.04 09:11:56 09:29:55
interval # 5, overall 5 6345 126213 114206 12007 9.51 09:29:56 09:47:55
interval # 6, overall 6 6262 122331 112722 9609 7.85 09:47:56 10:05:55
interval # 7, overall 7 6820 140408 122759 17649 12.57 10:05:56 10:23:55
interval # 8, overall 8 6052 124658 108933 15725 12.61 10:23:56 10:41:55
interval # 9, overall 9 6220 127553 111957 15596 12.23 10:41:56 10:59:55
interval # 10, overall 10 6378 127795 114801 12994 10.17 10:59:56 11:17:55
Done for 239850 ms, from 11:30:02.09 to 11:34:01.94.

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 1702.85 0.0005 2.2033 1993 41
TEST_TIME 2 2778.41 0.7065 1.3201 2079 100
TEST_TIME 3 3151.62 0.7771 1.2482 1746 100
TEST_TIME 4 3436.44 0.8587 1.1234 1716 100
TEST_TIME 5 3445.00 0.8966 1.0941 1305 100
TEST_TIME 6 3550.29 0.8902 1.1198 1764 100
TEST_TIME 7 3788.57 0.8995 1.0873 1922 100
TEST_TIME 8 3976.57 0.9064 1.0884 2145 100
TEST_TIME 9 4194.34 0.9172 1.0793 1891 100
TEST_TIME 10 4291.86 0.9494 1.0695 1843 100
TEST_TIME 11 4446.59 0.9386 1.0568 1977 100
TEST_TIME 12 4549.00 0.9470 1.0565 1698 100
TEST_TIME 13 4649.55 0.9541 1.0392 1544 100
TEST_TIME 14 4672.58 0.9603 1.0523 1629 100
TEST_TIME 15 4865.82 0.9431 1.0341 1527 100
TEST_TIME 16 4983.58 0.9466 1.0541 2398 100
TEST_TIME 17 5183.10 0.9567 1.0406 2177 100
TEST_TIME 18 5227.05 0.9756 1.0351 1868 100
TEST_TIME 19 5291.12 0.9687 1.0368 1868 100
TEST_TIME 20 5405.83 0.9641 1.0361 1985 100
TEST_TIME 21 5494.28 0.9708 1.0283 2072 100
TEST_TIME 22 5558.81 0.9702 1.0297 1881 100
TEST_TIME 23 5633.99 0.9718 1.0310 1889 100
TEST_TIME 24 5703.21 0.9763 1.0205 1617 100
TEST_TIME 25 5722.58 0.9764 1.0191 1495 100
TEST_TIME 26 5712.84 0.9816 1.0204 1494 100
TEST_TIME 27 5694.89 0.9857 1.0230 1485 100
TEST_TIME 28 5729.10 0.9805 1.0184 1595 100
TEST_TIME 29 5746.50 0.9803 1.0176 1448 100
TEST_TIME 30 5731.86 0.9862 1.0132 1406 100
TEST_TIME 31 5755.62 0.9764 1.0264 2224 100
TEST_TIME 32 5880.98 0.9731 1.0267 2410 100
TEST_TIME 33 5970.08 0.9808 1.0188 2178 100
TEST_TIME 34 5960.12 0.9905 1.0160 1874 91
TEST_TIME 35 5952.41 0.9882 1.0161 1416 77
TEST_TIME 36 5937.29 0.9904 1.0115 1628 71
TEST_TIME 37 5950.08 0.9821 1.0158 1402 100
TEST_TIME 38 5990.60 0.9824 1.0161 1705 100
TEST_TIME 39 6041.42 0.9822 1.0151 1568 100
TEST_TIME 40 6040.60 0.9900 1.0099 1707 100
TEST_TIME 41 6027.99 0.9883 1.0086 1618 100
TEST_TIME 42 6036.57 0.9832 1.0185 1492 100
TEST_TIME 43 6096.51 0.9851 1.0130 1515 100
TEST_TIME 44 6122.91 0.9858 1.0138 1591 100
TEST_TIME 45 6142.10 0.9882 1.0109 1450 100
TEST_TIME 46 6188.31 0.9815 1.0122 1923 100
TEST_TIME 47 6195.27 0.9895 1.0147 2353 99
TEST_TIME 48 6201.26 0.9926 1.0110 2145 100
TEST_TIME 49 6242.64 0.9842 1.0118 1770 100
TEST_TIME 50 6258.01 0.9891 1.0109 1943 100
TEST_TIME 51 6274.70 0.9884 1.0084 1851 100
TEST_TIME 52 6240.56 0.9944 1.0070 1663 100
TEST_TIME 53 6215.72 0.9920 1.0089 1443 99
TEST_TIME 54 6234.40 0.9872 1.0099 1401 100
TEST_TIME 55 6206.20 0.9961 1.0060 1735 97
TEST_TIME 56 6175.10 0.9930 1.0070 1566 95
TEST_TIME 57 6208.00 0.9841 1.0107 1320 99
TEST_TIME 58 6238.40 0.9885 1.0096 1393 100
TEST_TIME 59 6239.33 0.9923 1.0078 1501 100
TEST_TIME 60 6240.71 0.9907 1.0079 1252 100
TEST_TIME 61 6244.66 0.9912 1.0060 2106 100
TEST_TIME 62 6235.22 0.9913 1.0095 2155 97
TEST_TIME 63 6281.64 0.9862 1.0059 1833 100
TEST_TIME 64 6275.21 0.9912 1.0079 1915 97
TEST_TIME 65 6269.85 0.9933 1.0091 1947 94
TEST_TIME 66 6318.46 0.9861 1.0077 1537 100
TEST_TIME 67 6339.37 0.9894 1.0100 1728 100
TEST_TIME 68 6323.15 0.9977 1.0023 1459 93
TEST_TIME 69 6281.24 0.9943 1.0024 676 95
TEST_TIME 70 6253.35 0.9924 1.0089 1484 100
TEST_TIME 71 6257.24 0.9941 1.0065 1631 100
TEST_TIME 72 6230.60 0.9968 1.0044 1478 95
TEST_TIME 73 6230.81 0.9908 1.0051 1350 98
TEST_TIME 74 6220.82 0.9931 1.0057 1165 100
TEST_TIME 75 6202.28 0.9953 1.0086 1262 100
TEST_TIME 76 6218.53 0.9929 1.0053 1956 100
TEST_TIME 77 6232.15 0.9901 1.0087 1991 100
TEST_TIME 78 6243.20 0.9940 1.0074 2199 99
TEST_TIME 79 6258.26 0.9923 1.0080 1937 98
TEST_TIME 80 6280.93 0.9918 1.0057 1674 100
TEST_TIME 81 6285.54 0.9926 1.0107 1617 100
TEST_TIME 82 6315.48 0.9937 1.0090 1634 100
TEST_TIME 83 6335.58 0.9937 1.0057 1680 100
TEST_TIME 84 6323.59 0.9957 1.0055 1513 98
TEST_TIME 85 6328.67 0.9929 1.0059 1514 99
TEST_TIME 86 6304.92 0.9979 1.0024 1358 91
TEST_TIME 87 6267.38 0.9968 1.0040 1171 80
TEST_TIME 88 6266.11 0.9927 1.0048 1294 99
TEST_TIME 89 6263.62 0.9939 1.0061 1237 100
TEST_TIME 90 6256.44 0.9961 1.0037 1380 100
TEST_TIME 91 6242.47 0.9949 1.0046 1721 99
TEST_TIME 92 6258.50 0.9912 1.0050 1965 98
TEST_TIME 93 6250.22 0.9955 1.0063 1916 98
TEST_TIME 94 6261.75 0.9938 1.0047 1992 98
TEST_TIME 95 6265.99 0.9934 1.0088 1532 96
TEST_TIME 96 6300.47 0.9931 1.0042 1566 100
TEST_TIME 97 6280.93 0.9970 1.0033 1804 96
TEST_TIME 98 6269.75 0.9950 1.0048 1782 96
TEST_TIME 99 6283.12 0.9925 1.0059 1452 100
TEST_TIME 100 6277.08 0.9968 1.0062 1616 100
TEST_TIME 101 6269.13 0.9975 1.0032 1640 96
TEST_TIME 102 6260.91 0.9947 1.0062 1362 98
TEST_TIME 103 6260.57 0.9968 1.0030 1496 100
TEST_TIME 104 6257.56 0.9939 1.0060 1271 100
TEST_TIME 105 6248.38 0.9979 1.0025 1428 100
TEST_TIME 106 6241.08 0.9942 1.0040 1721 96
TEST_TIME 107 6239.58 0.9949 1.0056 1857 97
TEST_TIME 108 6245.58 0.9954 1.0051 1823 95
TEST_TIME 109 6253.78 0.9945 1.0065 1509 99
TEST_TIME 110 6263.19 0.9959 1.0060 1634 99
TEST_TIME 111 6269.24 0.9960 1.0033 1840 98
TEST_TIME 112 6263.00 0.9953 1.0036 1629 98
TEST_TIME 113 6262.51 0.9948 1.0063 1431 100
TEST_TIME 114 6264.69 0.9972 1.0028 1625 99
TEST_TIME 115 6257.78 0.9952 1.0052 1310 100
TEST_TIME 116 6249.05 0.9979 1.0017 1234 88
TEST_TIME 117 6227.58 0.9966 1.0062 794 98
TEST_TIME 118 6249.33 0.9942 1.0041 1266 100
TEST_TIME 119 6259.55 0.9940 1.0040 1225 100
TEST_TIME 120 6268.26 0.9944 1.0044 1314 100
TEST_TIME 121 6272.61 0.9954 1.0028 2068 100
TEST_TIME 122 6292.58 0.9915 1.0052 1837 100
TEST_TIME 123 6303.35 0.9954 1.0051 1881 100
TEST_TIME 124 6326.76 0.9933 1.0033 1828 100
TEST_TIME 125 6332.60 0.9944 1.0045 1516 100
TEST_TIME 126 6340.25 0.9955 1.0021 1577 100
TEST_TIME 127 6324.85 0.9967 1.0038 1433 93
TEST_TIME 128 6330.78 0.9964 1.0025 1510 98
TEST_TIME 129 6348.41 0.9920 1.0042 1090 100
TEST_TIME 130 6342.37 0.9974 1.0020 1569 99
TEST_TIME 131 6328.45 0.9966 1.0050 1369 97
TEST_TIME 132 6333.20 0.9967 1.0034 1288 100
TEST_TIME 133 6322.13 0.9976 1.0037 1292 99
TEST_TIME 134 6325.27 0.9957 1.0027 1174 100
TEST_TIME 135 6302.48 0.9989 1.0009 1039 81
TEST_TIME 136 6278.10 0.9974 1.0046 773 98
TEST_TIME 137 6287.62 0.9957 1.0043 1886 100
TEST_TIME 138 6289.45 0.9967 1.0036 1865 95
TEST_TIME 139 6293.22 0.9958 1.0050 1580 97
TEST_TIME 140 6292.36 0.9979 1.0027 1798 96
TEST_TIME 141 6289.20 0.9961 1.0036 1631 93
TEST_TIME 142 6287.99 0.9967 1.0034 1542 90
TEST_TIME 143 6292.33 0.9957 1.0052 1370 96
TEST_TIME 144 6295.02 0.9978 1.0034 1321 96
TEST_TIME 145 6291.01 0.9971 1.0025 1404 96
TEST_TIME 146 6299.49 0.9943 1.0023 1126 100
TEST_TIME 147 6285.30 0.9977 1.0014 1400 99
TEST_TIME 148 6266.99 0.9975 1.0022 1435 90
TEST_TIME 149 6262.90 0.9961 1.0050 1288 95
TEST_TIME 150 6261.52 0.9985 1.0018 1306 86
TEST_TIME 151 6257.55 0.9958 1.0043 1162 93
TEST_TIME 152 6268.53 0.9960 1.0025 1699 97
TEST_TIME 153 6264.26 0.9967 1.0038 2095 89
TEST_TIME 154 6273.35 0.9958 1.0028 1699 87
TEST_TIME 155 6277.80 0.9956 1.0048 1605 94
TEST_TIME 156 6282.68 0.9976 1.0015 1551 97
TEST_TIME 157 6270.11 0.9971 1.0024 1573 90
TEST_TIME 158 6281.52 0.9943 1.0038 1324 100
TEST_TIME 159 6285.15 0.9969 1.0018 1395 100
TEST_TIME 160 6268.63 0.9981 1.0022 1465 100
TEST_TIME 161 6281.38 0.9957 1.0025 1341 100
TEST_TIME 162 6290.70 0.9948 1.0037 1237 100
TEST_TIME 163 6287.89 0.9981 1.0012 1479 100
TEST_TIME 164 6268.57 0.9982 1.0021 1307 92
TEST_TIME 165 6272.63 0.9954 1.0044 1193 100
TEST_TIME 166 6276.70 0.9977 1.0024 1819 100
TEST_TIME 167 6275.84 0.9965 1.0035 1894 94
TEST_TIME 168 6284.37 0.9962 1.0040 1629 95
TEST_TIME 169 6293.41 0.9966 1.0035 1827 89
TEST_TIME 170 6297.46 0.9970 1.0038 1596 94
TEST_TIME 171 6297.20 0.9980 1.0021 1565 92
TEST_TIME 172 6288.53 0.9976 1.0027 1421 87
TEST_TIME 173 6300.29 0.9950 1.0039 1219 88
TEST_TIME 174 6297.20 0.9986 1.0015 1333 94
TEST_TIME 175 6289.11 0.9971 1.0046 1164 99
TEST_TIME 176 6296.18 0.9978 1.0024 1197 99
TEST_TIME 177 6293.24 0.9972 1.0049 1239 100
TEST_TIME 178 6308.29 0.9968 1.0031 1267 100
TEST_TIME 179 6314.05 0.9967 1.0028 1283 100
TEST_TIME 180 6309.71 0.9980 1.0013 750 98
Done for 12910 ms, from 11:34:03.87 to 11:34:16.78.

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 62135 109711 57299 <null> 56066 25357 75768 <null> 47633 16238 73481 60646 72549 49099 159939 155125 157598 260451 <null> 08:17:56 08:35:55
fetches per second 2 44360 42273 40926 134822 53523 141637 62874 44278 51140 48014 59206 50546 80100 93823 108151 113714 195846 143020 <null> 08:35:56 08:53:55
fetches per second 3 45850 89093 40454 20720 28291 <null> 57382 <null> 51285 2871 28964 19839 52950 3396 54588 3367 19073 297921 <null> 08:53:56 09:11:55
fetches per second 4 20575 35517 7839 <null> 14241 6860 34935 <null> 2387 6497 23642 2125 26053 4308 31864 2950 25535 15903 <null> 09:11:56 09:29:55
fetches per second 5 10010 57341 9779 <null> 6978 <null> 17597 25044 32363 98004 9989 7167 29964 11301 23086 <null> 53113 22218 <null> 09:29:56 09:47:55
fetches per second 6 8080 70499 3071 55042 5367 2546 9423 6521 31972 4343 14282 2556 6597 36542 27831 <null> 39026 296844 <null> 09:47:56 10:05:55
fetches per second 7 23178 13041 14348 <null> 38719 <null> 34499 44742 3593 32324 31501 1692 34558 50789 65519 43087 136956 84828 <null> 10:05:56 10:23:55
fetches per second 8 3694 5068 3680 <null> 8033 6703 7360 7414 4375 4827 11895 8165 5227 7743 7617 2929 266282 151317 <null> 10:23:56 10:41:55
fetches per second 9 17716 26555 7715 13661 22707 <null> 26320 <null> 6670 6300 14934 3101 14452 3913 18154 75269 12316 41107 <null> 10:41:56 10:59:55
fetches per second 10 17165 50558 13958 3720 5633 4812 13293 <null> 32966 14329 8016 17267 20353 7052 42684 66118 43144 11890 <null> 10:59:56 11:17:55
marks per second 1 13653 14467 12592 <null> 12491 4886 11461 <null> 5919 3006 14870 11123 6297 8795 7795 27875 29652 26862 <null> 08:17:56 08:35:55
marks per second 2 9558 5974 9237 34592 12051 34161 8848 7393 9963 8746 8385 8961 7422 11957 6416 19285 38549 12953 <null> 08:35:56 08:53:55
marks per second 3 9907 11609 8931 3714 6420 <null> 8574 <null> 9222 466 4744 3067 6401 585 4192 488 2584 28671 <null> 08:53:56 09:11:55
marks per second 4 4404 4969 1508 <null> 2824 1736 4816 <null> 261 1142 3475 404 2108 751 1664 524 1424 345 <null> 09:11:56 09:29:55
marks per second 5 2038 7882 2111 <null> 1474 <null> 2309 4230 4211 16134 1293 1305 1486 2192 1210 <null> 779 497 <null> 09:29:56 09:47:55
marks per second 6 1716 8561 551 13489 865 625 1321 1062 2601 779 1027 421 335 4275 1825 <null> 838 2805 <null> 09:47:56 10:05:55
marks per second 7 4764 1977 2958 <null> 7899 <null> 4971 7487 353 5515 3472 336 2423 7443 2229 6881 7399 921 <null> 10:05:56 10:23:55
marks per second 8 759 650 584 <null> 1293 1579 950 1416 518 721 1612 1457 196 1190 340 581 8730 838 <null> 10:23:56 10:41:55
marks per second 9 3593 3904 1383 2325 4965 <null> 3648 <null> 1127 1029 2146 508 570 646 1370 11580 580 647 <null> 10:41:56 10:59:55
marks per second 10 3534 6803 2623 691 811 1069 1879 <null> 4866 2481 576 2986 1164 1086 4299 9784 6042 567 <null> 10:59:56 11:17:55
reads/fetches*100 1 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 08:17:56 08:35:55
reads/fetches*100 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:35:56 08:53:55
reads/fetches*100 3 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 08:53:56 09:11:55
reads/fetches*100 4 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 09:11:56 09:29:55
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 09:29:56 09:47:55
reads/fetches*100 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 09:47:56 10:05:55
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 10:05:56 10:23:55
reads/fetches*100 8 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 10:23:56 10:41:55
reads/fetches*100 9 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 10:41:56 10:59:55
reads/fetches*100 10 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 10:59:56 11:17:55
writes/marks*100 1 0 0 0 <null> 0 0 0 <null> 1 1 0 0 0 0 0 0 1 1 <null> 08:17:56 08:35:55
writes/marks*100 2 1 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 <null> 08:35:56 08:53:55
writes/marks*100 3 0 0 0 0 0 <null> 0 <null> 1 0 0 0 0 0 0 0 5 0 <null> 08:53:56 09:11:55
writes/marks*100 4 0 0 0 <null> 0 0 0 <null> 1 1 0 0 0 0 0 0 3 0 <null> 09:11:56 09:29:55
writes/marks*100 5 0 0 0 <null> 0 <null> 0 0 0 1 0 0 0 0 0 <null> 0 0 <null> 09:29:56 09:47:55
writes/marks*100 6 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 <null> 0 0 <null> 09:47:56 10:05:55
writes/marks*100 7 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 3 0 <null> 10:05:56 10:23:55
writes/marks*100 8 0 1 0 <null> 0 0 0 0 1 0 0 0 0 0 0 2 3 0 <null> 10:23:56 10:41:55
writes/marks*100 9 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 3 4 0 <null> 10:41:56 10:59:55
writes/marks*100 10 0 0 0 0 0 0 0 <null> 1 0 0 0 0 0 0 0 0 0 <null> 10:59:56 11:17:55
Done for 10110 ms, from 11:34:18.01 to 11:34:28.12.

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 1967934 1841953 125981 6.40 0 11575 56 125981 2017-04-11 08:17 2017-04-11 11:17
doc_list_biud 1968404 1841953 126451 6.42 0 9094 18 126451 2017-04-11 08:17 2017-04-11 11:17
sp_add_invoice_to_stock 20686 12335 8351 40.37 0 147296 12390 8351 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_adding_invoice 4440 3593 847 19.07 0 66987 2743 847 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_client_order 7175 7004 171 2.38 0 3369 238 171 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_customer_reserve 323137 206494 116643 36.09 0 8596 73 116643 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_pay_from_customer 2758 2747 11 0.39 0 2574 133 11 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_pay_to_supplier 1629 1618 11 0.67 0 1654 127 11 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_supplier_invoice 9523 7718 1805 18.95 0 9828 475 1805 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_supplier_order 1609 565 1044 64.88 31 196686 24177 1044 2017-04-11 08:17 2017-04-11 11:17
sp_cancel_write_off 24668 16787 7881 31.94 0 4383 152 7881 2017-04-11 08:17 2017-04-11 11:17
sp_client_order 86002 86002 0 0.00 0 7067 474 0 2017-04-11 08:17 2017-04-11 11:17
sp_customer_reserve 650305 650305 0 0.00 0 8845 195 0 2017-04-11 08:17 2017-04-11 11:17
sp_fill_shopping_cart 130574 130230 344 0.26 0 8518 93 0 2017-04-11 08:17 2017-04-11 11:17
sp_fill_shopping_cart_clo_res 650305 650305 0 0.00 0 2808 15 0 2017-04-11 08:17 2017-04-11 11:17
sp_get_clo_for_invoice 12335 12335 0 0.00 0 4368 330 0 2017-04-11 08:17 2017-04-11 11:17
sp_kill_cost_storno 33052 24745 8307 25.13 0 3198 17 8307 2017-04-11 08:17 2017-04-11 11:17
sp_kill_qstorno_ret_qs2qd 680159 438058 242101 35.59 0 8300 26 242101 2017-04-11 08:17 2017-04-11 11:17
sp_kill_qty_storno 421064 294698 126366 30.01 0 9079 77 126366 2017-04-11 08:17 2017-04-11 11:17
sp_lock_selected_doc 84866 73636 11230 13.23 0 1653 7 11230 2017-04-11 08:17 2017-04-11 11:17
sp_make_cost_storno 105021 105021 0 0.00 0 9516 512 0 2017-04-11 08:17 2017-04-11 11:17
sp_multiply_rows_for_pdistr 105021 105021 0 0.00 0 2683 52 0 2017-04-11 08:17 2017-04-11 11:17
sp_multiply_rows_for_qdistr 86002 86002 0 0.00 0 3900 159 0 2017-04-11 08:17 2017-04-11 11:17
sp_pay_from_customer 28680 28680 0 0.00 0 9360 895 0 2017-04-11 08:17 2017-04-11 11:17
sp_pay_to_supplier 23804 23804 0 0.00 0 7473 990 0 2017-04-11 08:17 2017-04-11 11:17
sp_payment_common 52484 52484 0 0.00 0 4805 56 0 2017-04-11 08:17 2017-04-11 11:17
sp_qd_handle_on_cancel_clo 7167 7004 163 2.27 0 3105 102 163 2017-04-11 08:17 2017-04-11 11:17
sp_qd_handle_on_invoice_upd_sts 16577 15928 649 3.91 0 9064 363 649 2017-04-11 08:17 2017-04-11 11:17
sp_qd_handle_on_reserve_upd_sts 40202 40202 0 0.00 0 2901 48 0 2017-04-11 08:17 2017-04-11 11:17
sp_reserve_write_off 40823 40202 621 1.52 0 11669 542 621 2017-04-11 08:17 2017-04-11 11:17
sp_supplier_invoice 22333 22200 133 0.59 0 25506 3004 0 2017-04-11 08:17 2017-04-11 11:17
sp_supplier_order 22239 22028 211 0.94 0 12995 2092 0 2017-04-11 08:17 2017-04-11 11:17
srv_find_qd_qs_mism 1165911 1039901 126010 10.80 0 4290 28 126010 2017-04-11 08:17 2017-04-11 11:17
srv_make_invnt_saldo 1745 1745 0 0.00 15 33213 2948 0 2017-04-11 08:17 2017-04-11 11:17
srv_make_money_saldo 3438 3438 0 0.00 0 8892 65 0 2017-04-11 08:17 2017-04-11 11:17
srv_recalc_idx_stat 12 12 0 0.00 1232 34570 13812 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_add_invoice_to_stock 8351 8351 0 0.00 0 2044 93 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_adding_invoice 797 797 0 0.00 0 1810 138 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_client_order 171 171 0 0.00 0 1030 89 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_customer_reserve 41 41 0 0.00 0 733 66 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_pay_from_customer 11 11 0 0.00 0 249 109 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_pay_to_supplier 11 11 0 0.00 0 249 34 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_supplier_invoice 670 670 0 0.00 0 2044 89 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_supplier_order 14445 14445 0 0.00 0 7020 114 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_cancel_write_off 42 42 0 0.00 0 1185 92 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_reserve_write_off 621 621 0 0.00 0 1701 78 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_supplier_invoice 133 133 0 0.00 0 1826 115 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-abend:sp_supplier_order 211 211 0 0.00 0 780 73 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_add_invoice_to_stock 12335 12335 0 0.00 0 15476 671 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_adding_invoice 1407 1407 0 0.00 0 7613 702 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_client_order 7004 7004 0 0.00 0 1888 56 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_customer_reserve 2730 2730 0 0.00 0 1467 65 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_pay_from_customer 2747 2747 0 0.00 0 1810 45 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_pay_to_supplier 1618 1618 0 0.00 0 1139 43 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_supplier_invoice 1029 1029 0 0.00 0 2605 63 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_supplier_order 565 565 0 0.00 0 71059 2180 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_cancel_write_off 3999 3999 0 0.00 0 1498 61 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_client_order 86002 86002 0 0.00 0 2948 72 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_customer_reserve 3930 3930 0 0.00 0 1716 50 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_pay_from_customer 28680 28680 0 0.00 0 2684 62 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_pay_to_supplier 23804 23804 0 0.00 0 2122 64 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_reserve_write_off 40202 40202 0 0.00 0 2574 67 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_supplier_invoice 22200 22200 0 0.00 0 2044 67 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:sp_supplier_order 22028 22028 0 0.00 0 3104 71 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:srv_make_invnt_saldo 1745 1745 0 0.00 0 1607 33 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:srv_make_money_saldo 3438 3438 0 0.00 0 1233 25 0 2017-04-11 08:17 2017-04-11 11:17
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 203 29 0 2017-04-11 08:17 2017-04-11 11:17
v_add_invoice_to_stock 41372 24670 16702 40.37 0 1435 13 16702 2017-04-11 08:17 2017-04-11 11:17
v_all_customers 129372 129372 0 0.00 0 1201 5 0 2017-04-11 08:17 2017-04-11 11:17
v_all_suppliers 89144 88456 688 0.77 0 890 5 0 2017-04-11 08:17 2017-04-11 11:17
v_all_wares 172004 172004 0 0.00 0 1560 4 0 2017-04-11 08:17 2017-04-11 11:17
v_cancel_adding_invoice 3350 2814 536 16.00 0 3869 159 536 2017-04-11 08:17 2017-04-11 11:17
v_cancel_client_order 14350 14008 342 2.38 0 1528 6 342 2017-04-11 08:17 2017-04-11 11:17
v_cancel_customer_prepayment 5516 5494 22 0.39 0 733 8 22 2017-04-11 08:17 2017-04-11 11:17
v_cancel_customer_reserve 5542 5460 82 1.47 0 1092 8 82 2017-04-11 08:17 2017-04-11 11:17
v_cancel_payment_to_supplier 3258 3236 22 0.67 0 811 9 22 2017-04-11 08:17 2017-04-11 11:17
v_cancel_supplier_invoice 3398 2058 1340 39.43 0 1154 13 1340 2017-04-11 08:17 2017-04-11 11:17
v_cancel_supplier_order 3218 1130 2088 64.88 0 593 9 2088 2017-04-11 08:17 2017-04-11 11:17
v_cancel_write_off 8082 7998 84 1.03 0 2527 96 84 2017-04-11 08:17 2017-04-11 11:17
v_max_id_clo_ord 22239 22028 211 0.94 0 1155 6 0 2017-04-11 08:17 2017-04-11 11:17
v_max_id_clo_res 3930 3930 0 0.00 0 1185 17 0 2017-04-11 08:17 2017-04-11 11:17
v_max_id_ord_sup 22333 22200 133 0.59 0 796 5 0 2017-04-11 08:17 2017-04-11 11:17
v_max_non_paid_invoice 23804 23804 0 0.00 0 1029 5 0 2017-04-11 08:17 2017-04-11 11:17
v_max_non_paid_realizn 28680 28680 0 0.00 0 655 5 0 2017-04-11 08:17 2017-04-11 11:17
v_min_id_clo_ord 22239 22028 211 0.94 0 951 7 0 2017-04-11 08:17 2017-04-11 11:17
v_min_id_clo_res 3930 3930 0 0.00 0 624 8 0 2017-04-11 08:17 2017-04-11 11:17
v_min_id_ord_sup 22333 22200 133 0.59 0 1965 8 0 2017-04-11 08:17 2017-04-11 11:17
v_min_non_paid_invoice 23804 23804 0 0.00 0 2589 7 0 2017-04-11 08:17 2017-04-11 11:17
v_min_non_paid_realizn 28680 28680 0 0.00 0 1123 6 0 2017-04-11 08:17 2017-04-11 11:17
v_our_firm 42632 42632 0 0.00 0 921 6 0 2017-04-11 08:17 2017-04-11 11:17
v_reserve_write_off 81646 80404 1242 1.52 0 1513 8 1242 2017-04-11 08:17 2017-04-11 11:17
x_lock_depdocs_on_canc_invoice 19072 10282 8790 46.08 0 3994 37 8790 2017-04-11 08:17 2017-04-11 11:17
x_lock_depdocs_on_canc_sup_ord 1606 565 1041 64.81 0 1310 63 1041 2017-04-11 08:17 2017-04-11 11:17
x_make_qstorno_1000_1200 22239 22028 211 0.94 0 12823 1884 0 2017-04-11 08:17 2017-04-11 11:17
x_make_qstorno_1200_2000 22333 22200 133 0.59 0 24726 2793 0 2017-04-11 08:17 2017-04-11 11:17
x_make_qstorno_2100_3300 650305 650305 0 0.00 0 8704 163 0 2017-04-11 08:17 2017-04-11 11:17
Done for 505760 ms, from 11:42:07.23 to 11:50:32.99.

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 79 sp_kill_cost_storno 335544336 2017-04-11 08:18 2017-04-11 11:15
deadlock 86 sp_kill_qstorno_ret_qs2qd 335544336 2017-04-11 08:19 2017-04-11 11:16
deadlock 2199 sp_lock_selected_doc 335544336 2017-04-11 08:18 2017-04-11 11:17
deadlock 163 sp_qd_handle_on_cancel_clo 335544336 2017-04-11 08:18 2017-04-11 11:15
deadlock 185 sp_qd_handle_on_invoice_upd_sts 335544336 2017-04-11 08:18 2017-04-11 11:15
deadlock 61 x_lock_depdocs_on_canc_invoice 335544336 2017-04-11 08:18 2017-04-11 11:17
deadlock 11 x_lock_depdocs_on_canc_sup_ord 335544336 2017-04-11 08:31 2017-04-11 10:48
user_exc 211 x_make_qstorno_1000_1200 335544517 2017-04-11 08:18 2017-04-11 11:16
user_exc 133 x_make_qstorno_1200_2000 335544517 2017-04-11 08:18 2017-04-11 11:17
concurrent_transaction 7549 sp_lock_selected_doc 335544878 2017-04-11 08:18 2017-04-11 11:17
concurrent_transaction 681 x_lock_depdocs_on_canc_invoice 335544878 2017-04-11 08:18 2017-04-11 11:17
concurrent_transaction 212 x_lock_depdocs_on_canc_sup_ord 335544878 2017-04-11 08:21 2017-04-11 11:17
Done for 13350 ms, from 11:50:43.66 to 11:50:57.01.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 448880
MON$OLDEST_ACTIVE 448881
MON$OLDEST_SNAPSHOT 448881
MON$NEXT_TRANSACTION 448881
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:15:54.2050
MON$PAGES 869088
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.585 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.585 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.585 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.585 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 448940
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 448882
Oldest active 448883
Oldest snapshot 448883
Next transaction 448884
Sequence number 0
Next attachment ID 9402
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:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, 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.27
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: 325, 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: 327, 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: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, 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: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
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: 323, 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: 335, Index root page: 336
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: 339, 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: 340, 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: 338, 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: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.13, total records: 2216848
Average version length: 47.61, total versions: 2482, 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: 24008
Data pages: 24008, average fill: 73%
Primary pages: 24008, secondary pages: 0, swept pages: 13099
Empty pages: 3, full pages: 21214
Fill distribution:
0 - 19% = 4
20 - 39% = 4
40 - 59% = 82
60 - 79% = 23916
80 - 99% = 2

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10793, nodes: 2216848
Average node length: 19.36, total dup: 0, max dup: 0
Average key length: 16.40, compression ratio: 1.65
Average prefix length: 13.59, average data length: 13.41
Clustering factor: 487718, ratio: 0.22
Fill distribution:
0 - 19% = 687
20 - 39% = 2324
40 - 59% = 5308
60 - 79% = 1096
80 - 99% = 1378

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7922, nodes: 2216848
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 465000, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 3683
40 - 59% = 4146
60 - 79% = 87
80 - 99% = 5

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 174775, depth: 3, leaf buckets: 3948, nodes: 2216848
Average node length: 6.85, total dup: 1605665, max dup: 49
Average key length: 3.89, compression ratio: 2.31
Average prefix length: 7.38, average data length: 1.62
Clustering factor: 447783, ratio: 0.20
Fill distribution:
0 - 19% = 143
20 - 39% = 1272
40 - 59% = 1761
60 - 79% = 266
80 - 99% = 506

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.43, total records: 679255
Average version length: 61.50, total versions: 704, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8576
Data pages: 8576, average fill: 75%
Primary pages: 8576, secondary pages: 0, swept pages: 7561
Empty pages: 7, full pages: 8152
Fill distribution:
0 - 19% = 7
20 - 39% = 2
40 - 59% = 12
60 - 79% = 8545
80 - 99% = 10

Index DOC_LIST_ID_DESC (1)
Root page: 250267, depth: 3, leaf buckets: 2510, nodes: 679255
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 172346, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1378
40 - 59% = 1091
60 - 79% = 34
80 - 99% = 7

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 711, nodes: 679255
Average node length: 4.88, total dup: 679205, max dup: 34758
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 307391, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 605
60 - 79% = 82
80 - 99% = 24

Index PK_DOC_LIST (0)
Root page: 335638, depth: 3, leaf buckets: 2054, nodes: 679255
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 172346, ratio: 0.25
Fill distribution:
0 - 19% = 138
20 - 39% = 639
40 - 59% = 760
60 - 79% = 256
80 - 99% = 261

DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
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: 321, 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: 322, 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: 320, 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: 341, Index root page: 342
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: 343, 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: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 68.08, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 20.14, total fragments: 395, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.53
Pointer pages: 1, data page slots: 360
Data pages: 52, average fill: 14%
Primary pages: 4, secondary pages: 48, swept pages: 4
Empty pages: 30, full pages: 3
Fill distribution:
0 - 19% = 33
20 - 39% = 15
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 285, 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: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 11.03, total records: 4469
Average version length: 70.79, total versions: 3776, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 8.70
Pointer pages: 2, data page slots: 656
Data pages: 168, average fill: 36%
Primary pages: 166, secondary pages: 2, swept pages: 41
Empty pages: 39, full pages: 23
Fill distribution:
0 - 19% = 60
20 - 39% = 31
40 - 59% = 40
60 - 79% = 21
80 - 99% = 16

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 24, nodes: 4469
Average node length: 14.53, total dup: 489, max dup: 1
Average key length: 12.55, compression ratio: 2.15
Average prefix length: 17.33, average data length: 9.67
Clustering factor: 3254, ratio: 0.73
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 7
60 - 79% = 0
80 - 99% = 0

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

Index PK_MONEY_SALDO (0)
Root page: 276, 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: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 4.89, total records: 257
Average version length: 47.02, total versions: 229, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 13.09
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 17%
Primary pages: 15, secondary pages: 1, swept pages: 4
Empty pages: 7, full pages: 0
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 2
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 319696, depth: 2, leaf buckets: 1, nodes: 257
Average node length: 6.44, total dup: 198, max dup: 18
Average key length: 5.40, compression ratio: 3.52
Average prefix length: 15.82, average data length: 3.18
Clustering factor: 155, ratio: 0.60
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
Primary pointer page: 356, Index root page: 357
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: 367, 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: 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_ROWSET_DESC (1)
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 MON_LOG_UNIT (3)
Root page: 366, 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: 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

MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
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: 376, 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: 374, 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: 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_TN_UNIT (3)
Root page: 375, 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: 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

OPTYPES (138)
Primary pointer page: 241, Index root page: 242
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: 244, 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: 243, 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: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.32, total records: 831968
Average version length: 42.95, total versions: 348, max versions: 7
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.49
Pointer pages: 4, data page slots: 4944
Data pages: 4944, average fill: 73%
Primary pages: 4940, secondary pages: 4, swept pages: 4195
Empty pages: 7, full pages: 4007
Fill distribution:
0 - 19% = 12
20 - 39% = 39
40 - 59% = 208
60 - 79% = 4230
80 - 99% = 455

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 247, nodes: 230989
Average node length: 4.90, total dup: 230940, max dup: 14628
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 33793, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 32
40 - 59% = 106
60 - 79% = 99
80 - 99% = 9

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 268, nodes: 230989
Average node length: 5.84, total dup: 208256, max dup: 64
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 38047, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 22
40 - 59% = 104
60 - 79% = 89
80 - 99% = 51

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 265, nodes: 230989
Average node length: 5.84, total dup: 208256, max dup: 64
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 38080, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 14
40 - 59% = 104
60 - 79% = 97
80 - 99% = 49

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 284, nodes: 230989
Average node length: 5.63, total dup: 208256, max dup: 64
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 38113, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 148
60 - 79% = 77
80 - 99% = 28

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.99, total records: 286654
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2456
Data pages: 2456, average fill: 64%
Primary pages: 2456, secondary pages: 0, swept pages: 0
Empty pages: 5, full pages: 2450
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2450
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 57807, depth: 2, leaf buckets: 233, nodes: 286654
Average node length: 4.55, total dup: 286474, max dup: 2409
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 59928, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 96
60 - 79% = 69
80 - 99% = 67

PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
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: 349, 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: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.68, total records: 12002562
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: 175, data page slots: 284696
Data pages: 284696, average fill: 87%
Primary pages: 284696, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 284695
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 284696

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 13538, nodes: 12002562
Average node length: 5.68, total dup: 11119550, max dup: 147
Average key length: 2.18, compression ratio: 3.66
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 4706494, ratio: 0.39
Fill distribution:
0 - 19% = 18
20 - 39% = 0
40 - 59% = 7358
60 - 79% = 4179
80 - 99% = 1983

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 11897, nodes: 12002562
Average node length: 4.58, total dup: 12002557, max dup: 11063158
Average key length: 1.08, compression ratio: 0.36
Average prefix length: 0.39, average data length: 0.00
Clustering factor: 355112, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 11872
60 - 79% = 0
80 - 99% = 24

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 14476, nodes: 12002562
Average node length: 5.74, total dup: 11622655, max dup: 21506
Average key length: 2.23, compression ratio: 4.03
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 1041457, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 10427
60 - 79% = 2189
80 - 99% = 1856

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 14024, nodes: 12002562
Average node length: 5.57, total dup: 11971507, max dup: 1544136
Average key length: 2.07, compression ratio: 18.24
Average prefix length: 37.72, average data length: 0.07
Clustering factor: 6915658, ratio: 0.58
Fill distribution:
0 - 19% = 19
20 - 39% = 2
40 - 59% = 11317
60 - 79% = 631
80 - 99% = 2055

PHRASES (145)
Primary pointer page: 269, Index root page: 270
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: 283, 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: 282, 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: 281, 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: 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

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.02, total records: 445962
Average version length: 55.71, total versions: 797, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5304
Data pages: 5304, average fill: 74%
Primary pages: 5304, secondary pages: 0, swept pages: 3661
Empty pages: 1, full pages: 4920
Fill distribution:
0 - 19% = 2
20 - 39% = 6
40 - 59% = 16
60 - 79% = 5279
80 - 99% = 1

Index PSTORNED_RCV_ID (2)
Root page: 661033, depth: 3, leaf buckets: 636, nodes: 445962
Average node length: 5.99, total dup: 372249, max dup: 784
Average key length: 3.20, compression ratio: 2.81
Average prefix length: 7.97, average data length: 1.03
Clustering factor: 59075, ratio: 0.13
Fill distribution:
0 - 19% = 16
20 - 39% = 35
40 - 59% = 455
60 - 79% = 102
80 - 99% = 28

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 482, nodes: 445962
Average node length: 5.60, total dup: 397455, max dup: 122
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 111436, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 212
60 - 79% = 186
80 - 99% = 78

RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
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: 310, 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: 245, Index root page: 246
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: 248, 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: 247, 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: 318, Index root page: 319
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: 330, 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: 331, 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: 238, Index root page: 239
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: 240, 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: 236, Index root page: 237
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: 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$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
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: 218, 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: 226, Index root page: 227
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: 229, 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: 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$MON_LOG_TABLE_STATS (134)
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$PERF_LOG (164)
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 TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
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

TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
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: 219, Index root page: 220
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: 222, 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: 221, 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: 211, Index root page: 212
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: 215, 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: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.76, total records: 2669
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: 61%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 32
80 - 99% = 0

WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, 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.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
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: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, 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: 277, 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: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 279, 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: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
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: 328, 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: 329, 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: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 59.19, total records: 7243
Average version length: 72.26, total versions: 1303, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.30
Pointer pages: 2, data page slots: 1080
Data pages: 320, average fill: 27%
Primary pages: 319, secondary pages: 1, swept pages: 133
Empty pages: 115, full pages: 41
Fill distribution:
0 - 19% = 162
20 - 39% = 59
40 - 59% = 37
60 - 79% = 58
80 - 99% = 4

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 16, nodes: 7243
Average node length: 6.86, total dup: 6263, max dup: 14
Average key length: 4.58, compression ratio: 8.09
Average prefix length: 34.56, average data length: 2.44
Clustering factor: 1227, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 7
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.98, total records: 1253474
Average version length: 71.94, total versions: 3520, 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: 12, data page slots: 18968
Data pages: 18936, average fill: 73%
Primary pages: 18936, secondary pages: 0, swept pages: 11455
Empty pages: 57, full pages: 15242
Fill distribution:
0 - 19% = 163
20 - 39% = 501
40 - 59% = 1051
60 - 79% = 17172
80 - 99% = 49

Index XQD_1000_3300_DOC (1)
Root page: 432198, depth: 3, leaf buckets: 1406, nodes: 1253474
Average node length: 5.13, total dup: 1221072, max dup: 122
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 144846, ratio: 0.12
Fill distribution:
0 - 19% = 16
20 - 39% = 91
40 - 59% = 1010
60 - 79% = 52
80 - 99% = 237

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 256671, depth: 3, leaf buckets: 1792, nodes: 1253474
Average node length: 6.25, total dup: 1094865, max dup: 21
Average key length: 3.32, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 244271, ratio: 0.19
Fill distribution:
0 - 19% = 31
20 - 39% = 154
40 - 59% = 1313
60 - 79% = 146
80 - 99% = 148

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 28.47, total records: 112336
Average version length: 72.04, total versions: 2609, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.78
Pointer pages: 3, data page slots: 4440
Data pages: 4000, average fill: 18%
Primary pages: 3998, secondary pages: 2, swept pages: 3029
Empty pages: 1015, full pages: 302
Fill distribution:
0 - 19% = 2993
20 - 39% = 264
40 - 59% = 254
60 - 79% = 373
80 - 99% = 116

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 62, nodes: 37743
Average node length: 5.74, total dup: 33309, max dup: 47
Average key length: 3.51, compression ratio: 10.54
Average prefix length: 35.61, average data length: 1.39
Clustering factor: 4424, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 23
60 - 79% = 8
80 - 99% = 1

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 52.79, total records: 2491903
Average version length: 71.63, total versions: 42785, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.58
Pointer pages: 21, data page slots: 33480
Data pages: 33464, average fill: 65%
Primary pages: 33464, secondary pages: 0, swept pages: 16510
Empty pages: 321, full pages: 24752
Fill distribution:
0 - 19% = 647
20 - 39% = 4273
40 - 59% = 4045
60 - 79% = 21327
80 - 99% = 3172

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 186466, depth: 3, leaf buckets: 2755, nodes: 1775286
Average node length: 5.64, total dup: 1666032, max dup: 49
Average key length: 2.67, compression ratio: 13.85
Average prefix length: 36.39, average data length: 0.61
Clustering factor: 234500, ratio: 0.13
Fill distribution:
0 - 19% = 19
20 - 39% = 1150
40 - 59% = 1162
60 - 79% = 237
80 - 99% = 187

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.08, total records: 3998907
Average version length: 71.01, total versions: 139, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 14.98
Pointer pages: 15, data page slots: 24296
Data pages: 24272, average fill: 53%
Primary pages: 24272, secondary pages: 0, swept pages: 9070
Empty pages: 13, full pages: 24202
Fill distribution:
0 - 19% = 19
20 - 39% = 6942
40 - 59% = 6006
60 - 79% = 11250
80 - 99% = 55

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 17, nodes: 5293
Average node length: 10.07, total dup: 3651, max dup: 14
Average key length: 7.07, compression ratio: 5.23
Average prefix length: 32.24, average data length: 4.76
Clustering factor: 1139, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 8
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.90, total records: 3208947
Average version length: 71.19, total versions: 15774, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.16
Pointer pages: 26, data page slots: 42016
Data pages: 42016, average fill: 75%
Primary pages: 42016, secondary pages: 0, swept pages: 30389
Empty pages: 18, full pages: 36832
Fill distribution:
0 - 19% = 58
20 - 39% = 306
40 - 59% = 1224
60 - 79% = 38156
80 - 99% = 2272

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5709, nodes: 2783712
Average node length: 6.90, total dup: 2248832, max dup: 15
Average key length: 3.92, compression ratio: 9.44
Average prefix length: 35.27, average data length: 1.73
Clustering factor: 534541, ratio: 0.19
Fill distribution:
0 - 19% = 7
20 - 39% = 2887
40 - 59% = 2355
60 - 79% = 256
80 - 99% = 204

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.78, total records: 4887666
Average version length: 84.52, total versions: 1633, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 47, data page slots: 75168
Data pages: 75168, average fill: 80%
Primary pages: 75168, secondary pages: 0, swept pages: 28276
Empty pages: 6, full pages: 75029
Fill distribution:
0 - 19% = 10
20 - 39% = 8
40 - 59% = 21
60 - 79% = 21734
80 - 99% = 53395

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4960, nodes: 4887666
Average node length: 5.15, total dup: 4776816, max dup: 128
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 789830, ratio: 0.16
Fill distribution:
0 - 19% = 18
20 - 39% = 90
40 - 59% = 2117
60 - 79% = 2144
80 - 99% = 591

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5472, nodes: 4887666
Average node length: 5.69, total dup: 4378620, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 271111, ratio: 0.06
Fill distribution:
0 - 19% = 53
20 - 39% = 151
40 - 59% = 3286
60 - 79% = 330
80 - 99% = 1652

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5532, nodes: 4887666
Average node length: 5.81, total dup: 4276457, max dup: 28
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 846061, ratio: 0.17
Fill distribution:
0 - 19% = 33
20 - 39% = 93
40 - 59% = 2369
60 - 79% = 2142
80 - 99% = 895

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.90, total records: 2433473
Average version length: 83.39, total versions: 11482, 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: 38336
Data pages: 38336, average fill: 78%
Primary pages: 38336, secondary pages: 0, swept pages: 28182
Empty pages: 18, full pages: 35295
Fill distribution:
0 - 19% = 35
20 - 39% = 79
40 - 59% = 626
60 - 79% = 17563
80 - 99% = 20033

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2605, nodes: 2433473
Average node length: 5.15, total dup: 2376765, max dup: 205
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 394139, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 49
40 - 59% = 1530
60 - 79% = 789
80 - 99% = 237

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4206, nodes: 2433473
Average node length: 6.24, total dup: 1989995, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 254435, ratio: 0.10
Fill distribution:
0 - 19% = 107
20 - 39% = 1766
40 - 59% = 1627
60 - 79% = 461
80 - 99% = 245

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2991, nodes: 2433473
Average node length: 5.81, total dup: 2128744, max dup: 35
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 469240, ratio: 0.19
Fill distribution:
0 - 19% = 20
20 - 39% = 65
40 - 59% = 1823
60 - 79% = 813
80 - 99% = 270

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.69, total records: 5167470
Average version length: 85.28, total versions: 14251, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 50, data page slots: 81400
Data pages: 81280, average fill: 79%
Primary pages: 81280, secondary pages: 0, swept pages: 23558
Empty pages: 320, full pages: 76130
Fill distribution:
0 - 19% = 567
20 - 39% = 704
40 - 59% = 1541
60 - 79% = 18412
80 - 99% = 60056

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5514, nodes: 5167470
Average node length: 5.04, total dup: 5137234, max dup: 715
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 776971, ratio: 0.15
Fill distribution:
0 - 19% = 7
20 - 39% = 294
40 - 59% = 3157
60 - 79% = 1534
80 - 99% = 522

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 6445, nodes: 5167470
Average node length: 5.53, total dup: 4759144, max dup: 49
Average key length: 2.54, compression ratio: 3.54
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 300665, ratio: 0.06
Fill distribution:
0 - 19% = 75
20 - 39% = 1816
40 - 59% = 2661
60 - 79% = 607
80 - 99% = 1286

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 6190, nodes: 5167470
Average node length: 5.68, total dup: 4639502, max dup: 76
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 857899, ratio: 0.17
Fill distribution:
0 - 19% = 8
20 - 39% = 267
40 - 59% = 3591
60 - 79% = 1668
80 - 99% = 656

XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
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: 823, 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: 825, 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: 824, 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: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.33, total records: 3427652
Average version length: 83.80, total versions: 12088, 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: 34, data page slots: 54152
Data pages: 54152, average fill: 78%
Primary pages: 54152, secondary pages: 0, swept pages: 39965
Empty pages: 32, full pages: 49166
Fill distribution:
0 - 19% = 54
20 - 39% = 86
40 - 59% = 803
60 - 79% = 24044
80 - 99% = 29165

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3729, nodes: 3427652
Average node length: 5.03, total dup: 3410502, max dup: 1135
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 732725, ratio: 0.21
Fill distribution:
0 - 19% = 22
20 - 39% = 391
40 - 59% = 2014
60 - 79% = 860
80 - 99% = 442

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 6025, nodes: 3427652
Average node length: 6.26, total dup: 2798410, max dup: 14
Average key length: 3.28, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 403916, ratio: 0.12
Fill distribution:
0 - 19% = 214
20 - 39% = 2596
40 - 59% = 2243
60 - 79% = 600
80 - 99% = 372

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4061, nodes: 3427652
Average node length: 5.59, total dup: 3125330, max dup: 95
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 774827, ratio: 0.23
Fill distribution:
0 - 19% = 17
20 - 39% = 395
40 - 59% = 2045
60 - 79% = 1085
80 - 99% = 519

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.32, total records: 649388
Average version length: 69.68, total versions: 1762, 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: 8952
Data pages: 8952, average fill: 77%
Primary pages: 8952, secondary pages: 0, swept pages: 6652
Empty pages: 2, full pages: 8538
Fill distribution:
0 - 19% = 5
20 - 39% = 13
40 - 59% = 69
60 - 79% = 8818
80 - 99% = 47

Index XQS_3300_3400_DOC_ID (0)
Root page: 216186, depth: 3, leaf buckets: 762, nodes: 649388
Average node length: 5.33, total dup: 610442, max dup: 121
Average key length: 2.46, compression ratio: 3.66
Average prefix length: 8.60, average data length: 0.40
Clustering factor: 56976, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 155
40 - 59% = 312
60 - 79% = 191
80 - 99% = 103

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 841, nodes: 649388
Average node length: 5.94, total dup: 553880, max dup: 18
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 60644, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 153
40 - 59% = 357
60 - 79% = 217
80 - 99% = 111

ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
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: 672, Index root page: 673
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: 676, Index root page: 677
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: 682, Index root page: 683
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: 692, 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: 684, Index root page: 685
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: 693, 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: 678, Index root page: 679
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: 686, 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: 687, 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: 680, Index root page: 681
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: 689, 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: 688, 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: 691, 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: 690, 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: 622, Index root page: 623
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: 620, Index root page: 621
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: 271, Index root page: 272
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: 284, 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 80370 ms, from 11:50:59.93 to 11:52:20.30.

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 2216848 2482 0.1119
DOC_LIST 679255 704 0.1036
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 4469 3776 84.4931
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 257 229 89.1050
OPTYPES 9 0 0.0000
PDISTR 831968 348 0.0418
PERF_ESTIMATED 286654 0 0.0000
PERF_LOG 12002562 0 0.0000
PSTORNED 445962 797 0.1787
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 2669 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 7243 1303 17.9897
XQD_1000_3300 1253474 3520 0.2808
XQD_1200_2000 112336 2609 2.3224
XQD_2000_3300 2491903 42785 1.7169
XQD_2100_3300 3998907 139 0.0034
XQD_3300_3400 3208947 15774 0.4915
XQS_1000_1200 4887666 1633 0.0334
XQS_1000_3300 2433473 11482 0.4718
XQS_1200_2000 5167470 14251 0.2757
XQS_2100_3300 3427652 12088 0.3526
XQS_3300_3400 649388 1762 0.2713
Z_USED_VIEWS 29 0 0.0000
Done for 4480 ms, from 11:52:35.23 to 11:52:39.71.

Database validation

11:52:40.07 Validation started

11:52:40.08 Relation 140 (DOC_LIST)
11:52:40.10 process pointer page 0 of 6
11:52:40.18 process pointer page 1 of 6
11:52:40.22 process pointer page 2 of 6
11:52:40.29 process pointer page 3 of 6
11:52:40.32 process pointer page 4 of 6
11:52:40.36 process pointer page 5 of 6
11:52:40.38 Index 1 (PK_DOC_LIST)
11:52:40.61 Index 2 (DOC_LIST_ID_DESC)
11:52:40.93 Index 3 (FK_DOC_LIST_AGENTS)
11:52:41.21 Relation 140 (DOC_LIST) is ok

11:52:41.21 Relation 141 (DOC_DATA)
11:52:41.21 process pointer page 0 of 15
11:52:41.32 process pointer page 1 of 15
11:52:41.43 process pointer page 2 of 15
11:52:41.55 process pointer page 3 of 15
11:52:41.66 process pointer page 4 of 15
11:52:41.77 process pointer page 5 of 15
11:52:41.89 process pointer page 6 of 15
11:52:42.00 process pointer page 7 of 15
11:52:42.11 process pointer page 8 of 15
11:52:42.22 process pointer page 9 of 15
11:52:42.33 process pointer page 10 of 15
11:52:42.44 process pointer page 11 of 15
11:52:42.55 process pointer page 12 of 15
11:52:42.67 process pointer page 13 of 15
11:52:42.78 process pointer page 14 of 15
11:52:42.86 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:52:44.00 Index 3 (DOC_DATA_ID_DESC)
11:52:44.94 Index 4 (FK_DOC_DATA_DOC_LIST)
11:52:45.70 Relation 141 (DOC_DATA) is ok

11:52:45.70 Relation 147 (INVNT_SALDO)
11:52:45.70 process pointer page 0 of 1
11:52:45.70 Index 1 (PK_INVNT_SALDO)
11:52:45.70 Relation 147 (INVNT_SALDO) is ok

11:52:45.70 Relation 150 (PDISTR)
11:52:45.70 process pointer page 0 of 4
11:52:45.79 process pointer page 1 of 4
11:52:45.89 process pointer page 2 of 4
11:52:46.00 process pointer page 3 of 4
11:52:46.00 Index 2 (PDISTR_SND_ID)
11:52:46.09 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:52:46.18 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:52:46.26 Index 5 (PDISTR_AGENT_ID)
11:52:46.36 Relation 150 (PDISTR) is ok

11:52:46.36 Relation 151 (PSTORNED)
11:52:46.36 process pointer page 0 of 4
11:52:46.46 process pointer page 1 of 4
11:52:46.57 process pointer page 2 of 4
11:52:46.68 process pointer page 3 of 4
11:52:46.71 Index 2 (PSTORNED_SND_ID)
11:52:46.87 Index 3 (PSTORNED_RCV_ID)
11:52:47.01 Relation 151 (PSTORNED) is ok

11:52:47.01 Relation 156 (SEMAPHORES)
11:52:47.01 process pointer page 0 of 1
11:52:47.01 Index 1 (PK_SEMAPHORES)
11:52:47.01 Index 2 (SEMAPHORES_TASK_UNQ)
11:52:47.01 Relation 156 (SEMAPHORES) is ok

11:52:47.01 Relation 157 (INVNT_TURNOVER_LOG)
11:52:47.01 process pointer page 0 of 2
11:52:47.03 process pointer page 1 of 2
11:52:47.03 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:52:47.03 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:52:47.03 Relation 160 (PERF_ESTIMATED)
11:52:47.03 process pointer page 0 of 2
11:52:47.15 process pointer page 1 of 2
11:52:47.20 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:52:47.29 Relation 160 (PERF_ESTIMATED) is ok

11:52:47.29 Relation 161 (PERF_ISQL_STAT)
11:52:47.29 process pointer page 0 of 1
11:52:47.29 Index 1 (PERF_ISQL_STAT_TRN)
11:52:47.29 Relation 161 (PERF_ISQL_STAT) is ok

11:52:47.29 Relation 162 (TRACE_STAT)
11:52:47.29 process pointer page 0 of 1
11:52:47.31 Relation 162 (TRACE_STAT) is ok

11:52:47.31 Relation 163 (PERF_LOG)
11:52:47.31 process pointer page 0 of 175
11:52:47.40 process pointer page 1 of 175
11:52:47.49 process pointer page 2 of 175
11:52:47.59 process pointer page 3 of 175
11:52:47.68 process pointer page 4 of 175
11:52:47.77 process pointer page 5 of 175
11:52:47.87 process pointer page 6 of 175
11:52:47.96 process pointer page 7 of 175
11:52:48.06 process pointer page 8 of 175
11:52:48.15 process pointer page 9 of 175
11:52:48.24 process pointer page 10 of 175
11:52:48.35 process pointer page 11 of 175
11:52:48.45 process pointer page 12 of 175
11:52:48.54 process pointer page 13 of 175
11:52:48.63 process pointer page 14 of 175
11:52:48.74 process pointer page 15 of 175
11:52:48.84 process pointer page 16 of 175
11:52:48.93 process pointer page 17 of 175
11:52:49.01 process pointer page 18 of 175
11:52:49.10 process pointer page 19 of 175
11:52:49.19 process pointer page 20 of 175
11:52:49.29 process pointer page 21 of 175
11:52:49.38 process pointer page 22 of 175
11:52:49.48 process pointer page 23 of 175
11:52:49.57 process pointer page 24 of 175
11:52:49.66 process pointer page 25 of 175
11:52:49.74 process pointer page 26 of 175
11:52:49.83 process pointer page 27 of 175
11:52:49.93 process pointer page 28 of 175
11:52:50.02 process pointer page 29 of 175
11:52:50.11 process pointer page 30 of 175
11:52:50.19 process pointer page 31 of 175
11:52:50.29 process pointer page 32 of 175
11:52:50.38 process pointer page 33 of 175
11:52:50.47 process pointer page 34 of 175
11:52:50.57 process pointer page 35 of 175
11:52:50.66 process pointer page 36 of 175
11:52:50.75 process pointer page 37 of 175
11:52:50.85 process pointer page 38 of 175
11:52:50.93 process pointer page 39 of 175
11:52:51.02 process pointer page 40 of 175
11:52:51.11 process pointer page 41 of 175
11:52:51.21 process pointer page 42 of 175
11:52:51.28 process pointer page 43 of 175
11:52:51.38 process pointer page 44 of 175
11:52:51.47 process pointer page 45 of 175
11:52:51.57 process pointer page 46 of 175
11:52:51.64 process pointer page 47 of 175
11:52:51.74 process pointer page 48 of 175
11:52:51.83 process pointer page 49 of 175
11:52:51.92 process pointer page 50 of 175
11:52:52.02 process pointer page 51 of 175
11:52:52.10 process pointer page 52 of 175
11:52:52.19 process pointer page 53 of 175
11:52:52.28 process pointer page 54 of 175
11:52:52.38 process pointer page 55 of 175
11:52:52.47 process pointer page 56 of 175
11:52:52.55 process pointer page 57 of 175
11:52:52.64 process pointer page 58 of 175
11:52:52.74 process pointer page 59 of 175
11:52:52.83 process pointer page 60 of 175
11:52:52.92 process pointer page 61 of 175
11:52:53.02 process pointer page 62 of 175
11:52:53.11 process pointer page 63 of 175
11:52:53.20 process pointer page 64 of 175
11:52:53.30 process pointer page 65 of 175
11:52:53.39 process pointer page 66 of 175
11:52:53.48 process pointer page 67 of 175
11:52:53.56 process pointer page 68 of 175
11:52:53.66 process pointer page 69 of 175
11:52:53.75 process pointer page 70 of 175
11:52:53.84 process pointer page 71 of 175
11:52:53.94 process pointer page 72 of 175
11:52:53.98 process pointer page 73 of 175
11:52:54.05 process pointer page 74 of 175
11:52:54.14 process pointer page 75 of 175
11:52:54.23 process pointer page 76 of 175
11:52:54.33 process pointer page 77 of 175
11:52:54.42 process pointer page 78 of 175
11:52:54.51 process pointer page 79 of 175
11:52:54.59 process pointer page 80 of 175
11:52:54.69 process pointer page 81 of 175
11:52:54.78 process pointer page 82 of 175
11:52:54.87 process pointer page 83 of 175
11:52:54.97 process pointer page 84 of 175
11:52:55.06 process pointer page 85 of 175
11:52:55.15 process pointer page 86 of 175
11:52:55.25 process pointer page 87 of 175
11:52:55.34 process pointer page 88 of 175
11:52:55.42 process pointer page 89 of 175
11:52:55.51 process pointer page 90 of 175
11:52:55.61 process pointer page 91 of 175
11:52:55.70 process pointer page 92 of 175
11:52:55.79 process pointer page 93 of 175
11:52:55.89 process pointer page 94 of 175
11:52:55.96 process pointer page 95 of 175
11:52:56.06 process pointer page 96 of 175
11:52:56.15 process pointer page 97 of 175
11:52:56.25 process pointer page 98 of 175
11:52:56.34 process pointer page 99 of 175
11:52:56.43 process pointer page 100 of 175
11:52:56.53 process pointer page 101 of 175
11:52:56.62 process pointer page 102 of 175
11:52:56.71 process pointer page 103 of 175
11:52:56.79 process pointer page 104 of 175
11:52:56.89 process pointer page 105 of 175
11:52:56.98 process pointer page 106 of 175
11:52:57.07 process pointer page 107 of 175
11:52:57.17 process pointer page 108 of 175
11:52:57.26 process pointer page 109 of 175
11:52:57.35 process pointer page 110 of 175
11:52:57.45 process pointer page 111 of 175
11:52:57.54 process pointer page 112 of 175
11:52:57.63 process pointer page 113 of 175
11:52:57.73 process pointer page 114 of 175
11:52:57.82 process pointer page 115 of 175
11:52:57.90 process pointer page 116 of 175
11:52:57.99 process pointer page 117 of 175
11:52:58.09 process pointer page 118 of 175
11:52:58.18 process pointer page 119 of 175
11:52:58.26 process pointer page 120 of 175
11:52:58.35 process pointer page 121 of 175
11:52:58.45 process pointer page 122 of 175
11:52:58.54 process pointer page 123 of 175
11:52:58.62 process pointer page 124 of 175
11:52:58.71 process pointer page 125 of 175
11:52:58.80 process pointer page 126 of 175
11:52:58.90 process pointer page 127 of 175
11:52:58.99 process pointer page 128 of 175
11:52:59.08 process pointer page 129 of 175
11:52:59.18 process pointer page 130 of 175
11:52:59.27 process pointer page 131 of 175
11:52:59.37 process pointer page 132 of 175
11:52:59.46 process pointer page 133 of 175
11:52:59.54 process pointer page 134 of 175
11:52:59.63 process pointer page 135 of 175
11:52:59.72 process pointer page 136 of 175
11:52:59.82 process pointer page 137 of 175
11:52:59.93 process pointer page 138 of 175
11:53:00.01 process pointer page 139 of 175
11:53:00.10 process pointer page 140 of 175
11:53:00.19 process pointer page 141 of 175
11:53:00.29 process pointer page 142 of 175
11:53:00.38 process pointer page 143 of 175
11:53:00.47 process pointer page 144 of 175
11:53:00.55 process pointer page 145 of 175
11:53:00.64 process pointer page 146 of 175
11:53:00.74 process pointer page 147 of 175
11:53:00.83 process pointer page 148 of 175
11:53:00.93 process pointer page 149 of 175
11:53:01.02 process pointer page 150 of 175
11:53:01.11 process pointer page 151 of 175
11:53:01.21 process pointer page 152 of 175
11:53:01.30 process pointer page 153 of 175
11:53:01.39 process pointer page 154 of 175
11:53:01.47 process pointer page 155 of 175
11:53:01.57 process pointer page 156 of 175
11:53:01.66 process pointer page 157 of 175
11:53:01.75 process pointer page 158 of 175
11:53:01.85 process pointer page 159 of 175
11:53:01.94 process pointer page 160 of 175
11:53:02.02 process pointer page 161 of 175
11:53:02.11 process pointer page 162 of 175
11:53:02.20 process pointer page 163 of 175
11:53:02.30 process pointer page 164 of 175
11:53:02.39 process pointer page 165 of 175
11:53:02.49 process pointer page 166 of 175
11:53:02.58 process pointer page 167 of 175
11:53:02.67 process pointer page 168 of 175
11:53:02.77 process pointer page 169 of 175
11:53:02.86 process pointer page 170 of 175
11:53:02.94 process pointer page 171 of 175
11:53:03.03 process pointer page 172 of 175
11:53:03.13 process pointer page 173 of 175
11:53:03.22 process pointer page 174 of 175
11:53:03.25 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:53:08.04 Index 2 (PERF_LOG_UNIT)
11:53:14.89 Index 3 (PERF_LOG_TRN_DESC)
11:53:18.38 Index 4 (PERF_LOG_GDSCODE)
11:53:21.27 Relation 163 (PERF_LOG) is ok

11:53:21.27 Relation 167 (V_STOPTEST)
11:53:21.27 Relation 167 (V_STOPTEST) is ok

11:53:21.27 Relation 184 (V_QDISTR_SOURCE)
11:53:21.27 Relation 184 (V_QDISTR_SOURCE) is ok

11:53:21.27 Relation 185 (V_QSTORNED_SOURCE)
11:53:21.27 Relation 185 (V_QSTORNED_SOURCE) is ok

11:53:21.27 Relation 260 (XQD_1000_1200)
11:53:21.28 process pointer page 0 of 2
11:53:21.28 process pointer page 1 of 2
11:53:21.30 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:53:21.30 Relation 260 (XQD_1000_1200) is ok

11:53:21.30 Relation 261 (XQD_1200_2000)
11:53:21.30 process pointer page 0 of 3
11:53:21.38 process pointer page 1 of 3
11:53:21.42 process pointer page 2 of 3
11:53:21.46 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:53:21.47 Relation 261 (XQD_1200_2000) is ok

11:53:21.47 Relation 262 (XQD_1000_3300)
11:53:21.47 process pointer page 0 of 12
11:53:21.58 process pointer page 1 of 12
11:53:21.67 process pointer page 2 of 12
11:53:21.78 process pointer page 3 of 12
11:53:21.89 process pointer page 4 of 12
11:53:22.00 process pointer page 5 of 12
11:53:22.09 process pointer page 6 of 12
11:53:22.20 process pointer page 7 of 12
11:53:22.30 process pointer page 8 of 12
11:53:22.41 process pointer page 9 of 12
11:53:22.52 process pointer page 10 of 12
11:53:22.61 process pointer page 11 of 12
11:53:22.67 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:53:23.17 Index 2 (XQD_1000_3300_DOC)
11:53:23.55 Relation 262 (XQD_1000_3300) is ok

11:53:23.55 Relation 263 (XQD_2000_3300)
11:53:23.55 process pointer page 0 of 21
11:53:23.65 process pointer page 1 of 21
11:53:23.75 process pointer page 2 of 21
11:53:23.86 process pointer page 3 of 21
11:53:23.97 process pointer page 4 of 21
11:53:24.06 process pointer page 5 of 21
11:53:24.17 process pointer page 6 of 21
11:53:24.28 process pointer page 7 of 21
11:53:24.37 process pointer page 8 of 21
11:53:24.47 process pointer page 9 of 21
11:53:24.58 process pointer page 10 of 21
11:53:24.67 process pointer page 11 of 21
11:53:24.78 process pointer page 12 of 21
11:53:24.87 process pointer page 13 of 21
11:53:24.97 process pointer page 14 of 21
11:53:25.06 process pointer page 15 of 21
11:53:25.15 process pointer page 16 of 21
11:53:25.25 process pointer page 17 of 21
11:53:25.36 process pointer page 18 of 21
11:53:25.45 process pointer page 19 of 21
11:53:25.54 process pointer page 20 of 21
11:53:25.59 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:53:26.24 Relation 263 (XQD_2000_3300) is ok

11:53:26.24 Relation 264 (XQD_2100_3300)
11:53:26.24 process pointer page 0 of 15
11:53:26.32 process pointer page 1 of 15
11:53:26.38 process pointer page 2 of 15
11:53:26.45 process pointer page 3 of 15
11:53:26.53 process pointer page 4 of 15
11:53:26.59 process pointer page 5 of 15
11:53:26.65 process pointer page 6 of 15
11:53:26.73 process pointer page 7 of 15
11:53:26.79 process pointer page 8 of 15
11:53:26.85 process pointer page 9 of 15
11:53:26.92 process pointer page 10 of 15
11:53:26.99 process pointer page 11 of 15
11:53:27.06 process pointer page 12 of 15
11:53:27.13 process pointer page 13 of 15
11:53:27.20 process pointer page 14 of 15
11:53:27.26 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:53:27.26 Relation 264 (XQD_2100_3300) is ok

11:53:27.26 Relation 265 (XQD_3300_3400)
11:53:27.26 process pointer page 0 of 26
11:53:27.37 process pointer page 1 of 26
11:53:27.48 process pointer page 2 of 26
11:53:27.59 process pointer page 3 of 26
11:53:27.70 process pointer page 4 of 26
11:53:27.79 process pointer page 5 of 26
11:53:27.90 process pointer page 6 of 26
11:53:28.01 process pointer page 7 of 26
11:53:28.12 process pointer page 8 of 26
11:53:28.23 process pointer page 9 of 26
11:53:28.32 process pointer page 10 of 26
11:53:28.43 process pointer page 11 of 26
11:53:28.54 process pointer page 12 of 26
11:53:28.65 process pointer page 13 of 26
11:53:28.76 process pointer page 14 of 26
11:53:28.87 process pointer page 15 of 26
11:53:28.97 process pointer page 16 of 26
11:53:29.10 process pointer page 17 of 26
11:53:29.21 process pointer page 18 of 26
11:53:29.33 process pointer page 19 of 26
11:53:29.46 process pointer page 20 of 26
11:53:29.57 process pointer page 21 of 26
11:53:29.79 process pointer page 22 of 26
11:53:30.14 process pointer page 23 of 26
11:53:30.52 process pointer page 24 of 26
11:53:30.96 process pointer page 25 of 26
11:53:31.22 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:53:33.23 Relation 265 (XQD_3300_3400) is ok

11:53:33.23 Relation 266 (XQS_1000_1200)
11:53:33.23 process pointer page 0 of 47
11:53:33.55 process pointer page 1 of 47
11:53:33.84 process pointer page 2 of 47
11:53:34.12 process pointer page 3 of 47
11:53:34.42 process pointer page 4 of 47
11:53:34.70 process pointer page 5 of 47
11:53:35.01 process pointer page 6 of 47
11:53:35.31 process pointer page 7 of 47
11:53:35.60 process pointer page 8 of 47
11:53:35.92 process pointer page 9 of 47
11:53:36.21 process pointer page 10 of 47
11:53:36.51 process pointer page 11 of 47
11:53:36.82 process pointer page 12 of 47
11:53:37.12 process pointer page 13 of 47
11:53:37.41 process pointer page 14 of 47
11:53:37.73 process pointer page 15 of 47
11:53:38.04 process pointer page 16 of 47
11:53:38.35 process pointer page 17 of 47
11:53:38.65 process pointer page 18 of 47
11:53:38.96 process pointer page 19 of 47
11:53:39.29 process pointer page 20 of 47
11:53:39.61 process pointer page 21 of 47
11:53:39.96 process pointer page 22 of 47
11:53:40.32 process pointer page 23 of 47
11:53:40.67 process pointer page 24 of 47
11:53:41.02 process pointer page 25 of 47
11:53:41.38 process pointer page 26 of 47
11:53:41.72 process pointer page 27 of 47
11:53:42.05 process pointer page 28 of 47
11:53:42.39 process pointer page 29 of 47
11:53:42.75 process pointer page 30 of 47
11:53:43.09 process pointer page 31 of 47
11:53:43.45 process pointer page 32 of 47
11:53:43.78 process pointer page 33 of 47
11:53:44.15 process pointer page 34 of 47
11:53:44.51 process pointer page 35 of 47
11:53:44.86 process pointer page 36 of 47
11:53:45.20 process pointer page 37 of 47
11:53:45.54 process pointer page 38 of 47
11:53:45.90 process pointer page 39 of 47
11:53:46.26 process pointer page 40 of 47
11:53:46.62 process pointer page 41 of 47
11:53:46.98 process pointer page 42 of 47
11:53:47.35 process pointer page 43 of 47
11:53:47.69 process pointer page 44 of 47
11:53:48.05 process pointer page 45 of 47
11:53:48.41 process pointer page 46 of 47
11:53:48.44 Index 1 (XQS_1000_1200_DOC_ID)
11:53:50.80 Index 2 (XQS_1000_1200_SND_ID)
11:53:53.30 Index 3 (XQS_1000_1200_RCV_ID)
11:53:55.51 Relation 266 (XQS_1000_1200) is ok

11:53:55.51 Relation 267 (XQS_1200_2000)
11:53:55.51 process pointer page 0 of 50
11:53:55.90 process pointer page 1 of 50
11:53:56.28 process pointer page 2 of 50
11:53:56.67 process pointer page 3 of 50
11:53:57.06 process pointer page 4 of 50
11:53:57.41 process pointer page 5 of 50
11:53:57.77 process pointer page 6 of 50
11:53:58.16 process pointer page 7 of 50
11:53:58.54 process pointer page 8 of 50
11:53:58.91 process pointer page 9 of 50
11:53:59.29 process pointer page 10 of 50
11:53:59.68 process pointer page 11 of 50
11:54:00.07 process pointer page 12 of 50
11:54:00.49 process pointer page 13 of 50
11:54:00.96 process pointer page 14 of 50
11:54:01.41 process pointer page 15 of 50
11:54:01.86 process pointer page 16 of 50
11:54:02.30 process pointer page 17 of 50
11:54:02.75 process pointer page 18 of 50
11:54:03.20 process pointer page 19 of 50
11:54:03.64 process pointer page 20 of 50
11:54:04.06 process pointer page 21 of 50
11:54:04.48 process pointer page 22 of 50
11:54:04.93 process pointer page 23 of 50
11:54:05.35 process pointer page 24 of 50
11:54:05.78 process pointer page 25 of 50
11:54:06.23 process pointer page 26 of 50
11:54:06.65 process pointer page 27 of 50
11:54:07.07 process pointer page 28 of 50
11:54:07.48 process pointer page 29 of 50
11:54:07.90 process pointer page 30 of 50
11:54:08.33 process pointer page 31 of 50
11:54:08.74 process pointer page 32 of 50
11:54:09.16 process pointer page 33 of 50
11:54:09.58 process pointer page 34 of 50
11:54:09.99 process pointer page 35 of 50
11:54:10.42 process pointer page 36 of 50
11:54:10.85 process pointer page 37 of 50
11:54:11.25 process pointer page 38 of 50
11:54:11.67 process pointer page 39 of 50
11:54:12.11 process pointer page 40 of 50
11:54:12.52 process pointer page 41 of 50
11:54:12.91 process pointer page 42 of 50
11:54:13.36 process pointer page 43 of 50
11:54:13.78 process pointer page 44 of 50
11:54:14.20 process pointer page 45 of 50
11:54:14.64 process pointer page 46 of 50
11:54:15.04 process pointer page 47 of 50
11:54:15.45 process pointer page 48 of 50
11:54:15.90 process pointer page 49 of 50
11:54:16.24 Index 1 (XQS_1200_2000_DOC_ID)
11:54:19.04 Index 2 (XQS_1200_2000_SND_ID)
11:54:22.05 Index 3 (XQS_1200_2000_RCV_ID)
11:54:24.67 Relation 267 (XQS_1200_2000) is ok

11:54:24.67 Relation 268 (XQS_1000_3300)
11:54:24.67 process pointer page 0 of 24
11:54:25.10 process pointer page 1 of 24
11:54:25.57 process pointer page 2 of 24
11:54:26.02 process pointer page 3 of 24
11:54:26.46 process pointer page 4 of 24
11:54:26.93 process pointer page 5 of 24
11:54:27.41 process pointer page 6 of 24
11:54:27.90 process pointer page 7 of 24
11:54:28.38 process pointer page 8 of 24
11:54:28.88 process pointer page 9 of 24
11:54:29.35 process pointer page 10 of 24
11:54:29.83 process pointer page 11 of 24
11:54:30.28 process pointer page 12 of 24
11:54:30.74 process pointer page 13 of 24
11:54:31.19 process pointer page 14 of 24
11:54:31.63 process pointer page 15 of 24
11:54:32.06 process pointer page 16 of 24
11:54:32.48 process pointer page 17 of 24
11:54:32.90 process pointer page 18 of 24
11:54:33.29 process pointer page 19 of 24
11:54:33.68 process pointer page 20 of 24
11:54:34.06 process pointer page 21 of 24
11:54:34.45 process pointer page 22 of 24
11:54:34.82 process pointer page 23 of 24
11:54:34.98 Index 1 (XQS_1000_3300_DOC_ID)
11:54:36.38 Index 2 (XQS_1000_3300_SND_ID)
11:54:37.91 Index 3 (XQS_1000_3300_RCV_ID)
11:54:39.50 Relation 268 (XQS_1000_3300) is ok

11:54:39.50 Relation 269 (XQS_2000_3300)
11:54:39.50 process pointer page 0 of 1
11:54:39.50 Index 1 (XQS_2000_3300_DOC_ID)
11:54:39.52 Index 2 (XQS_2000_3300_SND_ID)
11:54:39.52 Index 3 (XQS_2000_3300_RCV_ID)
11:54:39.52 Relation 269 (XQS_2000_3300) is ok

11:54:39.52 Relation 270 (XQS_2100_3300)
11:54:39.52 process pointer page 0 of 34
11:54:39.96 process pointer page 1 of 34
11:54:40.41 process pointer page 2 of 34
11:54:40.86 process pointer page 3 of 34
11:54:41.31 process pointer page 4 of 34
11:54:41.77 process pointer page 5 of 34
11:54:42.19 process pointer page 6 of 34
11:54:42.62 process pointer page 7 of 34
11:54:43.04 process pointer page 8 of 34
11:54:43.48 process pointer page 9 of 34
11:54:43.92 process pointer page 10 of 34
11:54:44.35 process pointer page 11 of 34
11:54:44.79 process pointer page 12 of 34
11:54:45.24 process pointer page 13 of 34
11:54:45.67 process pointer page 14 of 34
11:54:46.10 process pointer page 15 of 34
11:54:46.54 process pointer page 16 of 34
11:54:46.96 process pointer page 17 of 34
11:54:47.40 process pointer page 18 of 34
11:54:47.82 process pointer page 19 of 34
11:54:48.22 process pointer page 20 of 34
11:54:48.64 process pointer page 21 of 34
11:54:49.07 process pointer page 22 of 34
11:54:49.47 process pointer page 23 of 34
11:54:49.89 process pointer page 24 of 34
11:54:50.30 process pointer page 25 of 34
11:54:50.72 process pointer page 26 of 34
11:54:51.11 process pointer page 27 of 34
11:54:51.52 process pointer page 28 of 34
11:54:51.92 process pointer page 29 of 34
11:54:52.34 process pointer page 30 of 34
11:54:52.75 process pointer page 31 of 34
11:54:53.14 process pointer page 32 of 34
11:54:53.51 process pointer page 33 of 34
11:54:53.57 Index 1 (XQS_2100_3300_DOC_ID)
11:54:55.57 Index 2 (XQS_2100_3300_SND_ID)
11:54:57.71 Index 3 (XQS_2100_3300_RCV_ID)
11:54:59.91 Relation 270 (XQS_2100_3300) is ok

11:54:59.91 Relation 271 (XQS_3300_3400)
11:54:59.92 process pointer page 0 of 6
11:55:00.34 process pointer page 1 of 6
11:55:00.75 process pointer page 2 of 6
11:55:01.17 process pointer page 3 of 6
11:55:01.58 process pointer page 4 of 6
11:55:02.00 process pointer page 5 of 6
11:55:02.20 Index 1 (XQS_3300_3400_DOC_ID)
11:55:02.53 Index 2 (XQS_3300_3400_SND_ID)
11:55:02.89 Relation 271 (XQS_3300_3400) is ok

11:55:02.92 Validation finished
Done for 143230 ms, from 11:52:39.80 to 11:55:03.03.

Differences between old and current firebird.log

11:55:05.23. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_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-04-11 11:55 478 oltp40_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.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Tue Apr 11 11:52:40 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Tue Apr 11 11:55:02 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


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.oltp40\oltp40_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-04-11 11:55:16.09 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

Subscribe to IBSurgeon news

Subscribe