Firebird 4.0 Performance Logs

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-06-24 11:20:39.68.
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.680 Firebird 4.0 Alpha 1
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-06-24 11:16:54.1890 -1 <null> ::1/58457 412071 9065 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: 5641.44 4148 1009818 2017-06-24 08:17 2017-06-24 11:16
customer order: creation 428.69 562 76735 2017-06-24 08:17 2017-06-24 11:16
customer order: refuse 34.97 279 6259 2017-06-24 08:17 2017-06-24 11:16
order to supplier: creation 109.64 2497 19625 2017-06-24 08:17 2017-06-24 11:16
order to supplier: removal 2.72 24770 486 2017-06-24 08:17 2017-06-24 11:16
invoice (draft): creation 109.65 3671 19628 2017-06-24 08:17 2017-06-24 11:16
invoice (draft): removal 37.62 542 6734 2017-06-24 08:17 2017-06-24 11:16
invoice accept: apply 60.81 13724 10885 2017-06-24 08:17 2017-06-24 11:16
invoice accept: cancel 17.38 3471 3111 2017-06-24 08:17 2017-06-24 11:16
customer reserve: creation 3250.51 213 581841 2017-06-24 08:17 2017-06-24 11:16
customer reserve: removal 995.02 82 178109 2017-06-24 08:17 2017-06-24 11:16
realization accept: apply 200.84 608 35951 2017-06-24 08:17 2017-06-24 11:16
realization accept: cancel 80.26 198 14367 2017-06-24 08:17 2017-06-24 11:16
payment from customer: creation 144.05 1109 25785 2017-06-24 08:17 2017-06-24 11:16
payment from customer: removal 13.82 148 2473 2017-06-24 08:17 2017-06-24 11:16
payment to supplier: creation 118.32 625 21179 2017-06-24 08:17 2017-06-24 11:16
payment to supplier: removal 8.45 161 1512 2017-06-24 08:17 2017-06-24 11:16
service: total inventory turnovers 10.07 2930 1803 2017-06-24 08:17 2017-06-24 11:16
service: total monetary turnovers 18.56 75 3323 2017-06-24 08:17 2017-06-24 11:16
service: refresh index statistics 0.07 23144 12 2017-06-24 08:17 2017-06-24 11:16
Done for 118520 ms, from 11:23:38.19 to 11:25:36.71.

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 5007 103150 90121 13029 12.63 08:16:55 08:34:54
interval # 2, overall 2 5970 123385 107463 15922 12.90 08:34:55 08:52:54
interval # 3, overall 3 6200 128614 111593 17021 13.23 08:52:55 09:10:54
interval # 4, overall 4 6270 127145 112867 14278 11.23 09:10:55 09:28:54
interval # 5, overall 5 5649 112546 101689 10857 9.65 09:28:55 09:46:54
interval # 6, overall 6 5970 125539 107468 18071 14.39 09:46:55 10:04:54
interval # 7, overall 7 5031 103963 90554 13409 12.90 10:04:55 10:22:54
interval # 8, overall 8 5259 113674 94658 19016 16.73 10:22:55 10:40:54
interval # 9, overall 9 5268 105185 94823 10362 9.85 10:40:55 10:58:54
interval # 10, overall 10 5477 107503 98582 8921 8.30 10:58:55 11:16:54
Done for 221260 ms, from 11:29:23.17 to 11:33:04.43.

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 1704.96 0.0005 2.0364 2376 20
TEST_TIME 2 2490.28 0.6973 1.3247 1923 20
TEST_TIME 3 2591.97 0.8486 1.1738 1323 19
TEST_TIME 4 2780.48 0.8208 1.1348 1222 19
TEST_TIME 5 2890.01 0.8735 1.1181 1411 13
TEST_TIME 6 2995.05 0.8992 1.0887 1073 15
TEST_TIME 7 3103.63 0.9006 1.0928 1412 16
TEST_TIME 8 3255.05 0.9118 1.0940 1461 14
TEST_TIME 9 3448.44 0.9179 1.0767 1772 16
TEST_TIME 10 3687.67 0.9072 1.0880 1850 16
TEST_TIME 11 4015.13 0.9084 1.0699 1787 19
TEST_TIME 12 4241.25 0.9293 1.0726 2143 16
TEST_TIME 13 4492.57 0.9347 1.0700 2063 20
TEST_TIME 14 4676.56 0.9545 1.0479 1663 19
TEST_TIME 15 4755.24 0.9619 1.0451 1706 22
TEST_TIME 16 4832.60 0.9641 1.0375 1512 30
TEST_TIME 17 4853.58 0.9722 1.0308 1257 74
TEST_TIME 18 4842.88 0.9757 1.0338 1510 99
TEST_TIME 19 4858.05 0.9763 1.0235 1085 100
TEST_TIME 20 4853.92 0.9733 1.0258 1226 100
TEST_TIME 21 4865.07 0.9748 1.0270 1277 100
TEST_TIME 22 4887.00 0.9760 1.0237 1188 100
TEST_TIME 23 4912.85 0.9741 1.0234 1404 100
TEST_TIME 24 4940.14 0.9753 1.0172 2287 100
TEST_TIME 25 4948.01 0.9749 1.0277 2019 99
TEST_TIME 26 5046.47 0.9689 1.0326 1748 100
TEST_TIME 27 5166.56 0.9712 1.0279 1886 100
TEST_TIME 28 5224.30 0.9812 1.0185 2051 100
TEST_TIME 29 5245.28 0.9794 1.0278 1501 100
TEST_TIME 30 5351.11 0.9739 1.0234 1642 100
TEST_TIME 31 5413.03 0.9790 1.0228 1659 100
TEST_TIME 32 5456.56 0.9830 1.0170 1584 100
TEST_TIME 33 5467.03 0.9842 1.0091 1526 100
TEST_TIME 34 5426.18 0.9868 1.0143 1171 100
TEST_TIME 35 5445.60 0.9818 1.0155 1238 100
TEST_TIME 36 5408.24 0.9941 1.0096 1258 93
TEST_TIME 37 5408.73 0.9823 1.0074 1048 99
TEST_TIME 38 5347.45 0.9921 1.0094 1310 91
TEST_TIME 39 5364.18 0.9804 1.0192 1637 100
TEST_TIME 40 5362.56 0.9940 1.0071 1860 92
TEST_TIME 41 5349.19 0.9850 1.0211 1411 100
TEST_TIME 42 5457.43 0.9777 1.0154 1586 100
TEST_TIME 43 5499.05 0.9842 1.0192 1696 100
TEST_TIME 44 5562.10 0.9848 1.0122 1451 100
TEST_TIME 45 5588.46 0.9855 1.0153 1701 100
TEST_TIME 46 5618.48 0.9879 1.0134 1618 99
TEST_TIME 47 5638.17 0.9884 1.0117 1522 100
TEST_TIME 48 5646.61 0.9891 1.0106 1493 100
TEST_TIME 49 5670.03 0.9859 1.0103 1459 100
TEST_TIME 50 5692.01 0.9862 1.0128 1230 100
TEST_TIME 51 5698.10 0.9919 1.0114 1253 100
TEST_TIME 52 5724.57 0.9874 1.0057 1076 100
TEST_TIME 53 5694.42 0.9920 1.0059 1218 98
TEST_TIME 54 5682.64 0.9894 1.0077 1354 99
TEST_TIME 55 5678.89 0.9912 1.0067 1887 100
TEST_TIME 56 5678.79 0.9887 1.0167 1458 100
TEST_TIME 57 5720.17 0.9916 1.0093 1510 100
TEST_TIME 58 5723.05 0.9915 1.0082 1645 100
TEST_TIME 59 5693.69 0.9962 1.0122 1335 96
TEST_TIME 60 5705.24 0.9933 1.0084 1486 99
TEST_TIME 61 5679.64 0.9963 1.0052 1583 98
TEST_TIME 62 5671.76 0.9904 1.0135 1243 100
TEST_TIME 63 5722.22 0.9887 1.0121 1305 100
TEST_TIME 64 5741.04 0.9930 1.0047 1590 100
TEST_TIME 65 5727.42 0.9916 1.0096 1368 100
TEST_TIME 66 5734.74 0.9930 1.0090 1287 100
TEST_TIME 67 5747.83 0.9917 1.0066 1274 100
TEST_TIME 68 5743.90 0.9925 1.0073 1269 100
TEST_TIME 69 5761.88 0.9897 1.0063 2127 100
TEST_TIME 70 5757.52 0.9927 1.0106 2083 98
TEST_TIME 71 5788.55 0.9910 1.0109 1695 100
TEST_TIME 72 5805.50 0.9940 1.0112 1661 100
TEST_TIME 73 5851.15 0.9897 1.0078 1612 100
TEST_TIME 74 5861.91 0.9924 1.0072 1435 100
TEST_TIME 75 5847.28 0.9962 1.0074 1389 99
TEST_TIME 76 5847.11 0.9942 1.0062 1343 100
TEST_TIME 77 5839.56 0.9944 1.0066 1230 99
TEST_TIME 78 5824.52 0.9963 1.0046 1383 100
TEST_TIME 79 5815.55 0.9934 1.0028 1343 98
TEST_TIME 80 5805.96 0.9920 1.0034 1287 99
TEST_TIME 81 5779.91 0.9955 1.0076 1187 100
TEST_TIME 82 5777.91 0.9956 1.0027 1433 100
TEST_TIME 83 5757.79 0.9940 1.0031 1292 97
TEST_TIME 84 5738.05 0.9945 1.0040 1268 97
TEST_TIME 85 5756.54 0.9936 1.0060 1669 100
TEST_TIME 86 5761.79 0.9934 1.0067 1695 100
TEST_TIME 87 5750.74 0.9971 1.0044 1706 94
TEST_TIME 88 5739.30 0.9951 1.0051 1625 95
TEST_TIME 89 5751.08 0.9918 1.0079 1459 100
TEST_TIME 90 5771.19 0.9933 1.0062 1467 100
TEST_TIME 91 5764.71 0.9963 1.0075 1577 98
TEST_TIME 92 5764.92 0.9965 1.0037 1432 96
TEST_TIME 93 5745.42 0.9962 1.0092 1165 100
TEST_TIME 94 5759.68 0.9960 1.0042 1168 100
TEST_TIME 95 5758.01 0.9939 1.0056 1063 100
TEST_TIME 96 5760.39 0.9947 1.0033 1089 100
TEST_TIME 97 5745.80 0.9966 1.0034 1301 97
TEST_TIME 98 5723.36 0.9971 1.0040 1152 89
TEST_TIME 99 5761.22 0.9918 1.0037 1508 100
TEST_TIME 100 5758.34 0.9942 1.0063 1435 95
TEST_TIME 101 5782.84 0.9934 1.0057 1502 99
TEST_TIME 102 5795.06 0.9937 1.0034 1590 95
TEST_TIME 103 5800.52 0.9928 1.0035 1424 99
TEST_TIME 104 5799.75 0.9940 1.0054 1489 99
TEST_TIME 105 5809.44 0.9942 1.0047 1312 100
TEST_TIME 106 5818.51 0.9937 1.0053 1285 100
TEST_TIME 107 5834.25 0.9932 1.0046 1235 99
TEST_TIME 108 5819.38 0.9979 1.0030 1436 96
TEST_TIME 109 5815.17 0.9946 1.0048 1193 100
TEST_TIME 110 5813.12 0.9969 1.0036 1092 100
TEST_TIME 111 5808.35 0.9953 1.0027 1340 99
TEST_TIME 112 5787.17 0.9974 1.0023 1259 99
TEST_TIME 113 5790.23 0.9929 1.0055 915 100
TEST_TIME 114 5782.12 0.9981 1.0049 1003 99
TEST_TIME 115 5781.58 0.9963 1.0028 1710 100
TEST_TIME 116 5771.45 0.9959 1.0043 1683 90
TEST_TIME 117 5779.57 0.9943 1.0021 1338 99
TEST_TIME 118 5767.02 0.9957 1.0032 1379 86
TEST_TIME 119 5775.43 0.9933 1.0055 1168 97
TEST_TIME 120 5781.00 0.9961 1.0024 1409 96
TEST_TIME 121 5768.96 0.9962 1.0029 1228 95
TEST_TIME 122 5752.44 0.9975 1.0019 1275 89
TEST_TIME 123 5730.73 0.9975 1.0042 1009 92
TEST_TIME 124 5722.84 0.9975 1.0015 1313 92
TEST_TIME 125 5702.03 0.9971 1.0028 1126 81
TEST_TIME 126 5693.49 0.9963 1.0036 1196 90
TEST_TIME 127 5701.12 0.9944 1.0051 1082 93
TEST_TIME 128 5693.25 0.9986 1.0017 1187 94
TEST_TIME 129 5673.93 0.9974 1.0027 1326 85
TEST_TIME 130 5678.13 0.9942 1.0043 1414 100
TEST_TIME 131 5683.09 0.9958 1.0030 1516 100
TEST_TIME 132 5669.64 0.9978 1.0045 1761 92
TEST_TIME 133 5675.66 0.9963 1.0053 1384 97
TEST_TIME 134 5682.55 0.9966 1.0034 1432 98
TEST_TIME 135 5673.11 0.9976 1.0028 1447 91
TEST_TIME 136 5678.27 0.9968 1.0057 1266 100
TEST_TIME 137 5686.51 0.9969 1.0032 1347 100
TEST_TIME 138 5672.62 0.9984 1.0038 1489 99
TEST_TIME 139 5678.71 0.9963 1.0038 1254 99
TEST_TIME 140 5680.86 0.9962 1.0044 1140 100
TEST_TIME 141 5688.77 0.9960 1.0040 1205 100
TEST_TIME 142 5688.61 0.9969 1.0027 1163 100
TEST_TIME 143 5670.65 0.9988 1.0009 1123 93
TEST_TIME 144 5643.09 0.9988 1.0013 990 74
TEST_TIME 145 5647.44 0.9954 1.0025 1225 95
TEST_TIME 146 5638.39 0.9972 1.0028 1474 89
TEST_TIME 147 5650.13 0.9944 1.0018 1281 99
TEST_TIME 148 5639.43 0.9969 1.0026 1708 93
TEST_TIME 149 5634.14 0.9968 1.0028 1530 96
TEST_TIME 150 5635.55 0.9959 1.0021 1328 93
TEST_TIME 151 5622.61 0.9978 1.0028 1531 87
TEST_TIME 152 5613.14 0.9979 1.0027 1328 90
TEST_TIME 153 5622.14 0.9945 1.0018 1153 96
TEST_TIME 154 5605.57 0.9983 1.0019 1284 85
TEST_TIME 155 5602.06 0.9960 1.0025 1212 92
TEST_TIME 156 5595.48 0.9973 1.0030 1279 89
TEST_TIME 157 5588.52 0.9979 1.0020 1182 88
TEST_TIME 158 5600.74 0.9944 1.0040 983 100
TEST_TIME 159 5595.09 0.9986 1.0016 1274 98
TEST_TIME 160 5585.88 0.9969 1.0027 1706 94
TEST_TIME 161 5586.30 0.9964 1.0041 1621 96
TEST_TIME 162 5603.83 0.9954 1.0024 1539 99
TEST_TIME 163 5594.64 0.9979 1.0022 1544 89
TEST_TIME 164 5599.83 0.9952 1.0046 1211 95
TEST_TIME 165 5604.98 0.9975 1.0031 1365 90
TEST_TIME 166 5604.58 0.9971 1.0018 1335 86
TEST_TIME 167 5591.04 0.9982 1.0017 1303 78
TEST_TIME 168 5585.59 0.9967 1.0031 1237 89
TEST_TIME 169 5589.61 0.9964 1.0033 1258 93
TEST_TIME 170 5588.62 0.9975 1.0017 1265 97
TEST_TIME 171 5580.15 0.9973 1.0042 1121 93
TEST_TIME 172 5582.00 0.9980 1.0022 1134 93
TEST_TIME 173 5576.89 0.9973 1.0034 1160 98
TEST_TIME 174 5576.72 0.9977 1.0021 1575 98
TEST_TIME 175 5572.40 0.9972 1.0032 1884 90
TEST_TIME 176 5581.21 0.9960 1.0071 1289 85
TEST_TIME 177 5600.64 0.9980 1.0025 1163 90
TEST_TIME 178 5596.93 0.9975 1.0017 1298 99
TEST_TIME 179 5586.43 0.9979 1.0024 1582 96
TEST_TIME 180 5581.91 0.9976 1.0050 1278 95
Done for 10760 ms, from 11:33:06.40 to 11:33:17.16.

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 50765 61626 49285 <null> 49846 22594 65864 80419 51756 79770 59753 47623 76521 80875 102817 45050 319424 546004 <null> 08:16:55 08:34:54
fetches per second 2 33976 76886 30281 <null> 27167 47505 64755 18687 76543 72556 72304 <null> 38993 37633 96263 <null> 69329 28641 <null> 08:34:55 08:52:54
fetches per second 3 36550 93122 33077 <null> 33732 36833 50467 46713 21922 2403 34295 <null> 59349 35080 51645 3276 17075 180172 <null> 08:52:55 09:10:54
fetches per second 4 23652 28915 32382 61121 28544 1606 38014 4319 2122 34701 15938 1881 33617 54202 36133 6240 104775 25357 <null> 09:10:55 09:28:54
fetches per second 5 16515 6360 9043 <null> 3951 3962 18813 80836 6975 6404 8237 1755 18529 9385 13721 6927 <null> 51164 <null> 09:28:55 09:46:54
fetches per second 6 19993 3367 15952 <null> 20366 <null> 24839 <null> 2399 <null> 35211 <null> 32159 108571 31991 4324 260664 113637 <null> 09:46:55 10:04:54
fetches per second 7 6623 5096 5388 <null> 13454 <null> 8381 2028 41381 <null> 15112 7535 19464 52168 23137 816 70398 111070 <null> 10:04:55 10:22:54
fetches per second 8 14420 55172 16875 <null> 16474 <null> 22301 2444 33185 <null> 12768 1288 16608 47634 39765 3147 135265 43223 <null> 10:22:55 10:40:54
fetches per second 9 8623 3010 14563 <null> 6104 <null> 6771 <null> 1727 91615 6721 1153 11208 25835 4364 4305 <null> 57883 <null> 10:40:55 10:58:54
fetches per second 10 5220 6401 5315 7485 6439 <null> 23565 2974 6576 21911 8716 1973 4370 2829 14630 2136 <null> 64490 <null> 10:58:55 11:16:54
marks per second 1 11486 8414 9664 <null> 9673 5012 7990 16985 7155 15437 12794 8128 4350 14168 6030 8950 9725 15695 <null> 08:16:55 08:34:54
marks per second 2 7307 10489 6719 <null> 6149 10747 10713 3849 12089 14961 11301 <null> 2620 7330 8703 <null> 8136 931 <null> 08:34:55 08:52:54
marks per second 3 7982 12255 7137 <null> 7426 7833 6733 8665 3350 556 6344 <null> 6515 6052 4305 479 3890 11491 <null> 08:52:55 09:10:54
marks per second 4 5266 4359 6859 11068 5514 361 5632 838 288 5318 2512 306 2007 9276 3941 1119 2534 456 <null> 09:10:55 09:28:54
marks per second 5 3752 962 1751 <null> 718 783 2754 14137 831 1058 1162 294 1297 1546 1666 1423 <null> 774 <null> 09:28:55 09:46:54
marks per second 6 4351 452 3283 <null> 4020 <null> 3581 <null> 324 <null> 7074 <null> 912 17142 3711 882 10033 3908 <null> 09:46:55 10:04:54
marks per second 7 1402 736 760 <null> 1872 <null> 1039 358 4265 <null> 1580 1371 526 8150 2604 171 1508 930 <null> 10:04:55 10:22:54
marks per second 8 3068 6941 2914 <null> 3213 <null> 3089 399 3814 <null> 2316 198 996 6697 5894 719 4740 819 <null> 10:22:55 10:40:54
marks per second 9 1886 272 2011 <null> 1135 <null> 841 <null> 252 16692 796 207 519 4162 545 790 <null> 646 <null> 10:40:55 10:58:54
marks per second 10 1129 906 776 1348 955 <null> 2517 533 829 3605 827 305 200 490 2666 368 <null> 544 <null> 10:58:55 11:16:54
reads/fetches*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:16:55 08:34:54
reads/fetches*100 2 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 0 <null> 0 0 <null> 08:34:55 08:52:54
reads/fetches*100 3 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 <null> 08:52:55 09:10:54
reads/fetches*100 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 09:10:55 09:28:54
reads/fetches*100 5 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 09:28:55 09:46:54
reads/fetches*100 6 0 0 0 <null> 0 <null> 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 <null> 09:46:55 10:04:54
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> 10:04:55 10:22:54
reads/fetches*100 8 0 0 0 <null> 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> 10:22:55 10:40:54
reads/fetches*100 9 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 <null> 0 <null> 10:40:55 10:58:54
reads/fetches*100 10 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 10:58:55 11:16:54
writes/marks*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 4 0 <null> 08:16:55 08:34:54
writes/marks*100 2 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 0 <null> 2 0 <null> 08:34:55 08:52:54
writes/marks*100 3 0 0 0 <null> 0 0 0 0 1 0 0 <null> 0 0 0 0 2 0 <null> 08:52:55 09:10:54
writes/marks*100 4 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 3 0 <null> 09:10:55 09:28:54
writes/marks*100 5 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 09:28:55 09:46:54
writes/marks*100 6 0 0 0 <null> 0 <null> 0 <null> 1 <null> 0 <null> 0 0 0 0 4 0 <null> 09:46:55 10:04:54
writes/marks*100 7 0 0 0 <null> 0 <null> 0 0 1 <null> 0 0 0 0 0 0 3 0 <null> 10:04:55 10:22:54
writes/marks*100 8 0 0 0 <null> 0 <null> 0 0 1 <null> 0 0 0 1 0 0 2 0 <null> 10:22:55 10:40:54
writes/marks*100 9 1 0 0 <null> 0 <null> 0 <null> 1 1 0 0 0 0 0 0 <null> 0 <null> 10:40:55 10:58:54
writes/marks*100 10 0 0 0 0 0 <null> 0 0 1 0 0 0 0 0 0 0 <null> 0 <null> 10:58:55 11:16:54
Done for 10570 ms, from 11:33:18.45 to 11:33:29.02.

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 1763371 1632859 130512 7.40 0 33197 58 130512 2017-06-24 08:16 2017-06-24 11:16
doc_list_biud 1763756 1632859 130897 7.42 0 27003 20 130897 2017-06-24 08:16 2017-06-24 11:16
sp_add_invoice_to_stock 18436 10885 7551 40.95 16 266776 13724 7551 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_adding_invoice 4021 3111 910 22.63 0 83242 3471 910 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_client_order 6412 6259 153 2.38 0 3978 279 153 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_customer_reserve 299254 178109 121145 40.48 0 26583 82 121145 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_pay_from_customer 2480 2473 7 0.28 0 1872 148 7 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_pay_to_supplier 1514 1512 2 0.13 0 2153 161 2 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_supplier_invoice 8719 6734 1985 22.76 0 9719 542 1985 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_supplier_order 1464 486 978 66.80 15 188245 24770 978 2017-06-24 08:16 2017-06-24 11:16
sp_cancel_write_off 21801 14367 7434 34.09 0 21091 198 7434 2017-06-24 08:16 2017-06-24 11:16
sp_client_order 76735 76735 0 0.00 0 22121 562 0 2017-06-24 08:16 2017-06-24 11:16
sp_customer_reserve 581841 581841 0 0.00 0 24259 213 0 2017-06-24 08:16 2017-06-24 11:16
sp_fill_shopping_cart 116244 115988 256 0.22 0 7768 113 0 2017-06-24 08:16 2017-06-24 11:16
sp_fill_shopping_cart_clo_res 581841 581841 0 0.00 0 2792 16 0 2017-06-24 08:16 2017-06-24 11:16
sp_get_clo_for_invoice 10885 10885 0 0.00 0 21325 383 0 2017-06-24 08:16 2017-06-24 11:16
sp_kill_cost_storno 29484 21463 8021 27.20 0 25038 23 8021 2017-06-24 08:16 2017-06-24 11:16
sp_kill_qstorno_ret_qs2qd 628756 377805 250951 39.91 0 26567 30 250951 2017-06-24 08:16 2017-06-24 11:16
sp_kill_qty_storno 386736 255902 130834 33.83 0 26988 90 130834 2017-06-24 08:16 2017-06-24 11:16
sp_lock_selected_doc 75837 65870 9967 13.14 0 5741 9 9967 2017-06-24 08:16 2017-06-24 11:16
sp_make_cost_storno 93800 93800 0 0.00 0 32807 470 0 2017-06-24 08:16 2017-06-24 11:16
sp_multiply_rows_for_pdistr 93800 93800 0 0.00 0 23275 63 0 2017-06-24 08:16 2017-06-24 11:16
sp_multiply_rows_for_qdistr 76735 76735 0 0.00 0 21544 188 0 2017-06-24 08:16 2017-06-24 11:16
sp_pay_from_customer 25785 25785 0 0.00 15 33415 1109 0 2017-06-24 08:16 2017-06-24 11:16
sp_pay_to_supplier 21179 21179 0 0.00 0 24726 625 0 2017-06-24 08:16 2017-06-24 11:16
sp_payment_common 46964 46964 0 0.00 0 7457 69 0 2017-06-24 08:16 2017-06-24 11:16
sp_qd_handle_on_cancel_clo 6408 6259 149 2.32 0 2043 119 149 2017-06-24 08:16 2017-06-24 11:16
sp_qd_handle_on_invoice_upd_sts 14738 13996 742 5.03 0 26957 421 742 2017-06-24 08:16 2017-06-24 11:16
sp_qd_handle_on_reserve_upd_sts 35951 35951 0 0.00 0 5616 57 0 2017-06-24 08:16 2017-06-24 11:16
sp_reserve_write_off 36416 35951 465 1.27 0 24867 608 465 2017-06-24 08:16 2017-06-24 11:16
sp_supplier_invoice 19740 19628 112 0.56 0 41995 3671 0 2017-06-24 08:16 2017-06-24 11:16
sp_supplier_order 19769 19625 144 0.72 0 29609 2497 0 2017-06-24 08:16 2017-06-24 11:16
srv_find_qd_qs_mism 1049340 918906 130434 12.43 0 24477 32 130434 2017-06-24 08:16 2017-06-24 11:16
srv_make_invnt_saldo 1803 1803 0 0.00 15 36582 2930 0 2017-06-24 08:16 2017-06-24 11:16
srv_make_money_saldo 3323 3323 0 0.00 0 15226 75 0 2017-06-24 08:16 2017-06-24 11:16
srv_recalc_idx_stat 12 12 0 0.00 2823 43945 23144 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_add_invoice_to_stock 7551 7551 0 0.00 0 9345 108 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_adding_invoice 673 673 0 0.00 0 2480 251 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_client_order 153 153 0 0.00 0 1155 128 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_customer_reserve 25 25 0 0.00 0 656 112 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_pay_from_customer 7 7 0 0.00 0 327 66 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_pay_to_supplier 2 2 0 0.00 62 124 93 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_supplier_invoice 537 537 0 0.00 0 1450 94 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_supplier_order 14961 14961 0 0.00 0 3993 123 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_cancel_write_off 24 24 0 0.00 0 234 38 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_reserve_write_off 465 465 0 0.00 0 1482 85 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_supplier_invoice 112 112 0 0.00 0 1295 102 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-abend:sp_supplier_order 144 144 0 0.00 0 1170 98 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_add_invoice_to_stock 10885 10885 0 0.00 0 22387 699 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_adding_invoice 1302 1302 0 0.00 0 11778 836 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_client_order 6259 6259 0 0.00 0 8300 69 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_customer_reserve 2463 2463 0 0.00 0 1684 72 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_pay_from_customer 2473 2473 0 0.00 0 1560 52 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_pay_to_supplier 1512 1512 0 0.00 0 1357 53 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_supplier_invoice 910 910 0 0.00 0 1154 78 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_supplier_order 486 486 0 0.00 0 34024 2236 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_cancel_write_off 3629 3629 0 0.00 0 1575 72 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_client_order 76735 76735 0 0.00 0 18658 85 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_customer_reserve 3585 3585 0 0.00 0 1732 57 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_pay_from_customer 25785 25785 0 0.00 0 15194 75 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_pay_to_supplier 21179 21179 0 0.00 0 2059 65 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_reserve_write_off 35951 35951 0 0.00 0 24992 79 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_supplier_invoice 19628 19628 0 0.00 0 10858 77 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:sp_supplier_order 19625 19625 0 0.00 0 4165 81 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:srv_make_invnt_saldo 1803 1803 0 0.00 0 1544 30 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:srv_make_money_saldo 3323 3323 0 0.00 0 1451 26 0 2017-06-24 08:16 2017-06-24 11:16
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 1107 257 0 2017-06-24 08:16 2017-06-24 11:16
v_add_invoice_to_stock 36872 21770 15102 40.95 0 8471 16 15102 2017-06-24 08:16 2017-06-24 11:16
v_all_customers 115310 115310 0 0.00 0 14961 7 0 2017-06-24 08:16 2017-06-24 11:16
v_all_suppliers 79458 78946 512 0.64 0 1341 7 0 2017-06-24 08:16 2017-06-24 11:16
v_all_wares 153470 153470 0 0.00 0 2543 5 0 2017-06-24 08:16 2017-06-24 11:16
v_cancel_adding_invoice 3054 2604 450 14.73 0 2839 172 450 2017-06-24 08:16 2017-06-24 11:16
v_cancel_client_order 12824 12518 306 2.38 0 1575 7 306 2017-06-24 08:16 2017-06-24 11:16
v_cancel_customer_prepayment 4960 4946 14 0.28 0 1076 10 14 2017-06-24 08:16 2017-06-24 11:16
v_cancel_customer_reserve 4976 4926 50 1.00 0 2418 11 50 2017-06-24 08:16 2017-06-24 11:16
v_cancel_payment_to_supplier 3028 3024 4 0.13 0 1592 11 4 2017-06-24 08:16 2017-06-24 11:16
v_cancel_supplier_invoice 2894 1820 1074 37.11 0 749 14 1074 2017-06-24 08:16 2017-06-24 11:16
v_cancel_supplier_order 2928 972 1956 66.80 0 592 9 1956 2017-06-24 08:16 2017-06-24 11:16
v_cancel_write_off 7306 7258 48 0.65 0 6520 121 48 2017-06-24 08:16 2017-06-24 11:16
v_max_id_clo_ord 19769 19625 144 0.72 0 1451 7 0 2017-06-24 08:16 2017-06-24 11:16
v_max_id_clo_res 3585 3585 0 0.00 0 1357 23 0 2017-06-24 08:16 2017-06-24 11:16
v_max_id_ord_sup 19740 19628 112 0.56 0 874 6 0 2017-06-24 08:16 2017-06-24 11:16
v_max_non_paid_invoice 20959 20959 0 0.00 0 1030 6 0 2017-06-24 08:16 2017-06-24 11:16
v_max_non_paid_realizn 25785 25785 0 0.00 0 7441 7 0 2017-06-24 08:16 2017-06-24 11:16
v_min_id_clo_ord 19769 19625 144 0.72 0 1435 9 0 2017-06-24 08:16 2017-06-24 11:16
v_min_id_clo_res 3585 3585 0 0.00 0 2356 12 0 2017-06-24 08:16 2017-06-24 11:16
v_min_id_ord_sup 19740 19628 112 0.56 0 1279 8 0 2017-06-24 08:16 2017-06-24 11:16
v_min_non_paid_invoice 21179 21179 0 0.00 0 905 8 0 2017-06-24 08:16 2017-06-24 11:16
v_min_non_paid_realizn 25785 25785 0 0.00 0 1155 7 0 2017-06-24 08:16 2017-06-24 11:16
v_our_firm 38160 38160 0 0.00 0 967 7 0 2017-06-24 08:16 2017-06-24 11:16
v_reserve_write_off 72832 71902 930 1.27 0 21357 10 930 2017-06-24 08:16 2017-06-24 11:16
x_lock_depdocs_on_canc_invoice 16949 8935 8014 47.28 0 2138 41 8014 2017-06-24 08:16 2017-06-24 11:16
x_lock_depdocs_on_canc_sup_ord 1464 486 978 66.80 0 2652 74 978 2017-06-24 08:16 2017-06-24 11:16
x_make_qstorno_1000_1200 19769 19625 144 0.72 0 28766 2245 0 2017-06-24 08:16 2017-06-24 11:16
x_make_qstorno_1200_2000 19740 19628 112 0.56 0 40685 3418 0 2017-06-24 08:16 2017-06-24 11:16
x_make_qstorno_2100_3300 581841 581841 0 0.00 0 24181 178 0 2017-06-24 08:16 2017-06-24 11:16
Done for 426140 ms, from 11:40:31.53 to 11:47:37.67.

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 67 sp_kill_cost_storno 335544336 2017-06-24 08:17 2017-06-24 11:16
deadlock 89 sp_kill_qstorno_ret_qs2qd 335544336 2017-06-24 08:20 2017-06-24 11:13
deadlock 8611 sp_lock_selected_doc 335544336 2017-06-24 08:17 2017-06-24 11:16
deadlock 149 sp_qd_handle_on_cancel_clo 335544336 2017-06-24 08:17 2017-06-24 11:14
deadlock 166 sp_qd_handle_on_invoice_upd_sts 335544336 2017-06-24 08:17 2017-06-24 11:13
deadlock 578 x_lock_depdocs_on_canc_invoice 335544336 2017-06-24 08:17 2017-06-24 11:16
deadlock 299 x_lock_depdocs_on_canc_sup_ord 335544336 2017-06-24 08:18 2017-06-24 11:16
user_exc 144 x_make_qstorno_1000_1200 335544517 2017-06-24 08:17 2017-06-24 11:16
user_exc 112 x_make_qstorno_1200_2000 335544517 2017-06-24 08:17 2017-06-24 11:16
Done for 12570 ms, from 11:47:48.11 to 11:48:00.68.

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 416330
MON$OLDEST_ACTIVE 416331
MON$OLDEST_SNAPSHOT 416331
MON$NEXT_TRANSACTION 416331
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 803520
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.680 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.680 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.680 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.680 Firebird 4.0 Alpha 1/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 416387
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 416332
Oldest active 416333
Oldest snapshot 416333
Next transaction 416334
Sequence number 0
Next attachment ID 9305
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.03, total records: 2061442
Average version length: 47.63, total versions: 2662, 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: 14, data page slots: 22304
Data pages: 22304, average fill: 73%
Primary pages: 22304, secondary pages: 0, swept pages: 13160
Empty pages: 7, full pages: 19257
Fill distribution:
0 - 19% = 9
20 - 39% = 2
40 - 59% = 65
60 - 79% = 22224
80 - 99% = 4

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9983, nodes: 2061442
Average node length: 19.31, total dup: 0, max dup: 0
Average key length: 16.35, compression ratio: 1.65
Average prefix length: 13.64, average data length: 13.36
Clustering factor: 435470, ratio: 0.21
Fill distribution:
0 - 19% = 688
20 - 39% = 2206
40 - 59% = 4670
60 - 79% = 1044
80 - 99% = 1375

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7381, nodes: 2061442
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 404495, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 3447
40 - 59% = 3870
60 - 79% = 54
80 - 99% = 10

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175962, depth: 3, leaf buckets: 3624, nodes: 2061442
Average node length: 6.82, total dup: 1502839, max dup: 49
Average key length: 3.87, compression ratio: 2.33
Average prefix length: 7.40, average data length: 1.60
Clustering factor: 399763, ratio: 0.19
Fill distribution:
0 - 19% = 141
20 - 39% = 1171
40 - 59% = 1580
60 - 79% = 209
80 - 99% = 523

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.39, total records: 621205
Average version length: 61.51, total versions: 545, 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: 5, data page slots: 7856
Data pages: 7856, average fill: 75%
Primary pages: 7855, secondary pages: 1, swept pages: 7338
Empty pages: 5, full pages: 7296
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 20
60 - 79% = 7814
80 - 99% = 15

Index DOC_LIST_ID_DESC (1)
Root page: 251941, depth: 3, leaf buckets: 2292, nodes: 621205
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 149249, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 1250
40 - 59% = 1014
60 - 79% = 24
80 - 99% = 4

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 650, nodes: 621205
Average node length: 4.87, total dup: 621155, max dup: 34244
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 280357, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 552
60 - 79% = 80
80 - 99% = 18

Index PK_DOC_LIST (0)
Root page: 319794, depth: 3, leaf buckets: 1874, nodes: 621205
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.83, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 149249, ratio: 0.24
Fill distribution:
0 - 19% = 138
20 - 39% = 559
40 - 59% = 703
60 - 79% = 223
80 - 99% = 251

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: 65.26, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 17.65, total fragments: 378, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.59
Pointer pages: 1, data page slots: 1072
Data pages: 20, average fill: 32%
Primary pages: 4, secondary pages: 16, swept pages: 4
Empty pages: 7, full pages: 3
Fill distribution:
0 - 19% = 11
20 - 39% = 1
40 - 59% = 4
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: 69.14, total records: 7737
Average version length: 70.93, total versions: 222, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.39
Pointer pages: 1, data page slots: 952
Data pages: 600, average fill: 16%
Primary pages: 599, secondary pages: 1, swept pages: 532
Empty pages: 101, full pages: 36
Fill distribution:
0 - 19% = 472
20 - 39% = 51
40 - 59% = 15
60 - 79% = 62
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 32, nodes: 7737
Average node length: 14.23, total dup: 397, max dup: 1
Average key length: 12.23, compression ratio: 2.21
Average prefix length: 17.72, average data length: 9.28
Clustering factor: 6437, ratio: 0.83
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 11
60 - 79% = 3
80 - 99% = 2

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.08, 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.12
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% = 0
20 - 39% = 1
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: 26.31, total records: 223
Average version length: 45.48, total versions: 99, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 2.43
Pointer pages: 1, data page slots: 40
Data pages: 32, average fill: 8%
Primary pages: 30, secondary pages: 2, swept pages: 23
Empty pages: 17, full pages: 1
Fill distribution:
0 - 19% = 29
20 - 39% = 1
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 266040, depth: 2, leaf buckets: 1, nodes: 223
Average node length: 7.65, total dup: 164, max dup: 24
Average key length: 5.72, compression ratio: 3.32
Average prefix length: 15.54, average data length: 3.46
Clustering factor: 108, ratio: 0.48
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.96, total records: 795292
Average version length: 42.75, total versions: 372, max versions: 4
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.38
Pointer pages: 3, data page slots: 4760
Data pages: 4760, average fill: 74%
Primary pages: 4759, secondary pages: 1, swept pages: 4249
Empty pages: 8, full pages: 4107
Fill distribution:
0 - 19% = 11
20 - 39% = 32
40 - 59% = 72
60 - 79% = 4261
80 - 99% = 384

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 251, nodes: 236737
Average node length: 4.88, total dup: 236688, max dup: 13124
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 33305, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 29
40 - 59% = 130
60 - 79% = 75
80 - 99% = 17

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 279, nodes: 236737
Average node length: 5.83, total dup: 213395, max dup: 57
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 37565, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 29
40 - 59% = 106
60 - 79% = 103
80 - 99% = 39

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 274, nodes: 236737
Average node length: 5.83, total dup: 213395, max dup: 57
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 37634, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 25
40 - 59% = 102
60 - 79% = 91
80 - 99% = 54

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 264, nodes: 236737
Average node length: 5.62, total dup: 213395, max dup: 57
Average key length: 2.75, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 37764, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 21
40 - 59% = 102
60 - 79% = 95
80 - 99% = 45

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 255731
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: 2192
Data pages: 2192, average fill: 64%
Primary pages: 2192, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 2185
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2185
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 146507, depth: 2, leaf buckets: 204, nodes: 255731
Average node length: 4.50, total dup: 255551, max dup: 2375
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 34026, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 79
60 - 79% = 63
80 - 99% = 61

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.64, total records: 10934353
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: 159, data page slots: 259296
Data pages: 259296, average fill: 87%
Primary pages: 259296, secondary pages: 0, swept pages: 3
Empty pages: 7, full pages: 259288
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 259288

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 12195, nodes: 10934353
Average node length: 5.65, total dup: 10050785, max dup: 143
Average key length: 2.20, compression ratio: 3.64
Average prefix length: 7.85, average data length: 0.14
Clustering factor: 4277863, ratio: 0.39
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 6508
60 - 79% = 3821
80 - 99% = 1859

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 10761, nodes: 10934353
Average node length: 4.54, total dup: 10934349, max dup: 9970451
Average key length: 1.09, compression ratio: 0.40
Average prefix length: 0.44, average data length: 0.00
Clustering factor: 324076, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 10757
60 - 79% = 3
80 - 99% = 1

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 13156, nodes: 10934353
Average node length: 5.69, total dup: 10583742, max dup: 20101
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 928386, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 9606
60 - 79% = 1961
80 - 99% = 1586

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 13076, nodes: 10934353
Average node length: 5.53, total dup: 10903217, max dup: 1382498
Average key length: 2.07, compression ratio: 18.22
Average prefix length: 37.73, average data length: 0.07
Clustering factor: 6366551, ratio: 0.58
Fill distribution:
0 - 19% = 20
20 - 39% = 2
40 - 59% = 11035
60 - 79% = 606
80 - 99% = 1413

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: 54.98, total records: 406707
Average version length: 55.86, total versions: 934, 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: 3, data page slots: 4840
Data pages: 4840, average fill: 74%
Primary pages: 4840, secondary pages: 0, swept pages: 3249
Empty pages: 1, full pages: 4400
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 16
60 - 79% = 4819
80 - 99% = 2

Index PSTORNED_RCV_ID (2)
Root page: 542792, depth: 3, leaf buckets: 548, nodes: 406707
Average node length: 5.93, total dup: 341675, max dup: 409
Average key length: 3.16, compression ratio: 2.84
Average prefix length: 7.99, average data length: 1.01
Clustering factor: 48769, ratio: 0.12
Fill distribution:
0 - 19% = 6
20 - 39% = 25
40 - 59% = 381
60 - 79% = 94
80 - 99% = 42

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 424, nodes: 406707
Average node length: 5.60, total dup: 361738, max dup: 92
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 94925, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 153
60 - 79% = 187
80 - 99% = 81

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.78, total records: 2671
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% = 7
20 - 39% = 1
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: 62.86, total records: 3849
Average version length: 72.15, total versions: 498, 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: 2, data page slots: 1096
Data pages: 328, average fill: 14%
Primary pages: 327, secondary pages: 1, swept pages: 302
Empty pages: 152, full pages: 18
Fill distribution:
0 - 19% = 249
20 - 39% = 39
40 - 59% = 19
60 - 79% = 15
80 - 99% = 6

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 10, nodes: 3849
Average node length: 7.00, total dup: 3307, max dup: 14
Average key length: 4.99, compression ratio: 7.41
Average prefix length: 34.14, average data length: 2.86
Clustering factor: 629, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 8
40 - 59% = 2
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.88, total records: 1082680
Average version length: 71.53, total versions: 4479, 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: 10, data page slots: 16040
Data pages: 16040, average fill: 74%
Primary pages: 16040, secondary pages: 0, swept pages: 10274
Empty pages: 17, full pages: 13005
Fill distribution:
0 - 19% = 62
20 - 39% = 145
40 - 59% = 578
60 - 79% = 15167
80 - 99% = 88

Index XQD_1000_3300_DOC (1)
Root page: 446977, depth: 3, leaf buckets: 1250, nodes: 1082680
Average node length: 5.12, total dup: 1054600, max dup: 123
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 124791, ratio: 0.12
Fill distribution:
0 - 19% = 20
20 - 39% = 94
40 - 59% = 921
60 - 79% = 44
80 - 99% = 171

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 243472, depth: 3, leaf buckets: 1546, nodes: 1082680
Average node length: 6.24, total dup: 946092, max dup: 23
Average key length: 3.31, compression ratio: 11.17
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 209709, ratio: 0.19
Fill distribution:
0 - 19% = 17
20 - 39% = 149
40 - 59% = 1112
60 - 79% = 137
80 - 99% = 131

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 27.57, total records: 109293
Average version length: 71.78, total versions: 9277, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.93
Pointer pages: 3, data page slots: 4320
Data pages: 3776, average fill: 20%
Primary pages: 3774, secondary pages: 2, swept pages: 2513
Empty pages: 1037, full pages: 400
Fill distribution:
0 - 19% = 2530
20 - 39% = 559
40 - 59% = 196
60 - 79% = 322
80 - 99% = 169

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 82, nodes: 42822
Average node length: 6.25, total dup: 37365, max dup: 49
Average key length: 3.60, compression ratio: 10.27
Average prefix length: 35.52, average data length: 1.48
Clustering factor: 4593, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 42
40 - 59% = 29
60 - 79% = 8
80 - 99% = 3

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 53.10, total records: 2169484
Average version length: 71.61, total versions: 43690, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.56
Pointer pages: 18, data page slots: 28136
Data pages: 28136, average fill: 68%
Primary pages: 28136, secondary pages: 0, swept pages: 13600
Empty pages: 79, full pages: 22434
Fill distribution:
0 - 19% = 209
20 - 39% = 2941
40 - 59% = 2735
60 - 79% = 19408
80 - 99% = 2843

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 189991, depth: 3, leaf buckets: 2437, nodes: 1563925
Average node length: 5.65, total dup: 1466765, max dup: 49
Average key length: 2.68, compression ratio: 13.81
Average prefix length: 36.38, average data length: 0.62
Clustering factor: 216204, ratio: 0.14
Fill distribution:
0 - 19% = 13
20 - 39% = 949
40 - 59% = 1115
60 - 79% = 231
80 - 99% = 129

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.04, total records: 3568137
Average version length: 71.07, total versions: 990, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.05
Pointer pages: 14, data page slots: 21952
Data pages: 21944, average fill: 52%
Primary pages: 21944, secondary pages: 0, swept pages: 7742
Empty pages: 0, full pages: 21402
Fill distribution:
0 - 19% = 33
20 - 39% = 6521
40 - 59% = 5675
60 - 79% = 9670
80 - 99% = 45

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 12, nodes: 3292
Average node length: 10.19, total dup: 2350, max dup: 31
Average key length: 7.18, compression ratio: 5.15
Average prefix length: 32.10, average data length: 4.90
Clustering factor: 664, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 2
60 - 79% = 2
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 63.09, total records: 2972407
Average version length: 71.23, total versions: 14277, 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: 24, data page slots: 38888
Data pages: 38888, average fill: 76%
Primary pages: 38888, secondary pages: 0, swept pages: 28556
Empty pages: 8, full pages: 34487
Fill distribution:
0 - 19% = 25
20 - 39% = 237
40 - 59% = 1019
60 - 79% = 35538
80 - 99% = 2069

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5330, nodes: 2592900
Average node length: 6.88, total dup: 2100285, max dup: 23
Average key length: 3.90, compression ratio: 9.48
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 488431, ratio: 0.19
Fill distribution:
0 - 19% = 8
20 - 39% = 2761
40 - 59% = 2166
60 - 79% = 212
80 - 99% = 183

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.60, total records: 4495638
Average version length: 84.35, total versions: 1704, 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: 43, data page slots: 69072
Data pages: 69072, average fill: 80%
Primary pages: 69072, secondary pages: 0, swept pages: 25020
Empty pages: 9, full pages: 68587
Fill distribution:
0 - 19% = 13
20 - 39% = 3
40 - 59% = 30
60 - 79% = 20278
80 - 99% = 48748

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4630, nodes: 4495638
Average node length: 5.15, total dup: 4393244, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 717414, ratio: 0.16
Fill distribution:
0 - 19% = 19
20 - 39% = 115
40 - 59% = 2155
60 - 79% = 1761
80 - 99% = 580

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5020, nodes: 4495638
Average node length: 5.70, total dup: 4020061, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 246336, ratio: 0.05
Fill distribution:
0 - 19% = 50
20 - 39% = 170
40 - 59% = 2962
60 - 79% = 274
80 - 99% = 1564

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5162, nodes: 4495638
Average node length: 5.81, total dup: 3933681, max dup: 27
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 774052, ratio: 0.17
Fill distribution:
0 - 19% = 34
20 - 39% = 121
40 - 59% = 2360
60 - 79% = 1846
80 - 99% = 801

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.75, total records: 2301352
Average version length: 83.65, total versions: 9931, 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: 23, data page slots: 36176
Data pages: 36176, average fill: 78%
Primary pages: 36176, secondary pages: 0, swept pages: 26903
Empty pages: 26, full pages: 33614
Fill distribution:
0 - 19% = 77
20 - 39% = 144
40 - 59% = 494
60 - 79% = 16020
80 - 99% = 19441

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2485, nodes: 2301352
Average node length: 5.15, total dup: 2247396, max dup: 160
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 360977, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 45
40 - 59% = 1497
60 - 79% = 716
80 - 99% = 225

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 3969, nodes: 2301352
Average node length: 6.23, total dup: 1887183, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 230361, ratio: 0.10
Fill distribution:
0 - 19% = 112
20 - 39% = 1628
40 - 59% = 1536
60 - 79% = 481
80 - 99% = 212

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2822, nodes: 2301352
Average node length: 5.81, total dup: 2012597, max dup: 29
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 432395, ratio: 0.19
Fill distribution:
0 - 19% = 14
20 - 39% = 50
40 - 59% = 1745
60 - 79% = 762
80 - 99% = 251

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.46, total records: 4745194
Average version length: 85.44, total versions: 15403, 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: 46, data page slots: 73880
Data pages: 73872, average fill: 79%
Primary pages: 73872, secondary pages: 0, swept pages: 22403
Empty pages: 104, full pages: 70004
Fill distribution:
0 - 19% = 180
20 - 39% = 302
40 - 59% = 1074
60 - 79% = 17396
80 - 99% = 54920

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5082, nodes: 4745194
Average node length: 5.04, total dup: 4717256, max dup: 722
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 708491, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 246
40 - 59% = 2991
60 - 79% = 1388
80 - 99% = 451

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5813, nodes: 4745194
Average node length: 5.54, total dup: 4359757, max dup: 49
Average key length: 2.56, compression ratio: 3.52
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 274493, ratio: 0.06
Fill distribution:
0 - 19% = 87
20 - 39% = 1481
40 - 59% = 2470
60 - 79% = 531
80 - 99% = 1244

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5687, nodes: 4745194
Average node length: 5.69, total dup: 4250461, max dup: 86
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 789952, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 204
40 - 59% = 3328
60 - 79% = 1597
80 - 99% = 552

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.12, total records: 3217715
Average version length: 84.14, total versions: 10461, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 32, data page slots: 50632
Data pages: 50632, average fill: 78%
Primary pages: 50632, secondary pages: 0, swept pages: 37800
Empty pages: 30, full pages: 46923
Fill distribution:
0 - 19% = 66
20 - 39% = 140
40 - 59% = 663
60 - 79% = 22104
80 - 99% = 27659

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3481, nodes: 3217715
Average node length: 5.03, total dup: 3201575, max dup: 1199
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 675227, ratio: 0.21
Fill distribution:
0 - 19% = 17
20 - 39% = 316
40 - 59% = 1918
60 - 79% = 809
80 - 99% = 421

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5632, nodes: 3217715
Average node length: 6.25, total dup: 2633929, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 364274, ratio: 0.11
Fill distribution:
0 - 19% = 196
20 - 39% = 2353
40 - 59% = 2166
60 - 79% = 597
80 - 99% = 320

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3840, nodes: 3217715
Average node length: 5.61, total dup: 2926279, max dup: 88
Average key length: 2.63, compression ratio: 3.42
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 716335, ratio: 0.22
Fill distribution:
0 - 19% = 15
20 - 39% = 353
40 - 59% = 1962
60 - 79% = 1046
80 - 99% = 464

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.25, total records: 630380
Average version length: 69.47, total versions: 1749, 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: 8720
Data pages: 8720, average fill: 77%
Primary pages: 8720, secondary pages: 0, swept pages: 6484
Empty pages: 4, full pages: 8260
Fill distribution:
0 - 19% = 12
20 - 39% = 39
40 - 59% = 115
60 - 79% = 8514
80 - 99% = 40

Index XQS_3300_3400_DOC_ID (0)
Root page: 215617, depth: 3, leaf buckets: 740, nodes: 630380
Average node length: 5.32, total dup: 593278, max dup: 119
Average key length: 2.45, compression ratio: 3.67
Average prefix length: 8.61, average data length: 0.39
Clustering factor: 53775, ratio: 0.09
Fill distribution:
0 - 19% = 4
20 - 39% = 126
40 - 59% = 323
60 - 79% = 211
80 - 99% = 76

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 833, nodes: 630380
Average node length: 5.93, total dup: 538001, max dup: 14
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 59588, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 165
40 - 59% = 350
60 - 79% = 223
80 - 99% = 92

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 84570 ms, from 11:48:01.29 to 11:49:25.86.

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 2061442 2662 0.1291
DOC_LIST 621205 545 0.0877
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 7737 222 2.8693
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 223 99 44.3946
OPTYPES 9 0 0.0000
PDISTR 795292 372 0.0467
PERF_ESTIMATED 255731 0 0.0000
PERF_LOG 10934353 0 0.0000
PSTORNED 406707 934 0.2296
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 2671 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 3849 498 12.9384
XQD_1000_3300 1082680 4479 0.4136
XQD_1200_2000 109293 9277 8.4881
XQD_2000_3300 2169484 43690 2.0138
XQD_2100_3300 3568137 990 0.0277
XQD_3300_3400 2972407 14277 0.4803
XQS_1000_1200 4495638 1704 0.0379
XQS_1000_3300 2301352 9931 0.4315
XQS_1200_2000 4745194 15403 0.3246
XQS_2100_3300 3217715 10461 0.3251
XQS_3300_3400 630380 1749 0.2774
Z_USED_VIEWS 29 0 0.0000
Done for 3230 ms, from 11:49:37.96 to 11:49:41.19.

Database validation

11:49:41.44 Validation started

11:49:41.49 Relation 140 (DOC_LIST)
11:49:41.49 process pointer page 0 of 5
11:49:41.60 process pointer page 1 of 5
11:49:41.69 process pointer page 2 of 5
11:49:41.79 process pointer page 3 of 5
11:49:41.90 process pointer page 4 of 5
11:49:41.97 Index 1 (PK_DOC_LIST)
11:49:42.10 Index 2 (DOC_LIST_ID_DESC)
11:49:42.21 Index 3 (FK_DOC_LIST_AGENTS)
11:49:42.29 Relation 140 (DOC_LIST) is ok

11:49:42.29 Relation 141 (DOC_DATA)
11:49:42.29 process pointer page 0 of 14
11:49:42.35 process pointer page 1 of 14
11:49:42.44 process pointer page 2 of 14
11:49:42.54 process pointer page 3 of 14
11:49:42.63 process pointer page 4 of 14
11:49:42.72 process pointer page 5 of 14
11:49:42.82 process pointer page 6 of 14
11:49:42.91 process pointer page 7 of 14
11:49:43.00 process pointer page 8 of 14
11:49:43.10 process pointer page 9 of 14
11:49:43.17 process pointer page 10 of 14
11:49:43.27 process pointer page 11 of 14
11:49:43.36 process pointer page 12 of 14
11:49:43.46 process pointer page 13 of 14
11:49:43.52 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:49:44.53 Index 3 (DOC_DATA_ID_DESC)
11:49:45.37 Index 4 (FK_DOC_DATA_DOC_LIST)
11:49:46.06 Relation 141 (DOC_DATA) is ok

11:49:46.06 Relation 147 (INVNT_SALDO)
11:49:46.08 process pointer page 0 of 1
11:49:46.08 Index 1 (PK_INVNT_SALDO)
11:49:46.08 Relation 147 (INVNT_SALDO) is ok

11:49:46.08 Relation 150 (PDISTR)
11:49:46.08 process pointer page 0 of 3
11:49:46.15 process pointer page 1 of 3
11:49:46.25 process pointer page 2 of 3
11:49:46.33 Index 2 (PDISTR_SND_ID)
11:49:46.42 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:49:46.50 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:49:46.59 Index 5 (PDISTR_AGENT_ID)
11:49:46.67 Relation 150 (PDISTR) is ok

11:49:46.67 Relation 151 (PSTORNED)
11:49:46.67 process pointer page 0 of 3
11:49:46.76 process pointer page 1 of 3
11:49:46.86 process pointer page 2 of 3
11:49:46.93 Index 2 (PSTORNED_SND_ID)
11:49:47.07 Index 3 (PSTORNED_RCV_ID)
11:49:47.20 Relation 151 (PSTORNED) is ok

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

11:49:47.20 Relation 157 (INVNT_TURNOVER_LOG)
11:49:47.20 process pointer page 0 of 1
11:49:47.22 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:49:47.22 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:49:47.22 Relation 160 (PERF_ESTIMATED)
11:49:47.22 process pointer page 0 of 2
11:49:47.31 process pointer page 1 of 2
11:49:47.36 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:49:47.42 Relation 160 (PERF_ESTIMATED) is ok

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

11:49:47.42 Relation 162 (TRACE_STAT)
11:49:47.42 process pointer page 0 of 1
11:49:47.42 Relation 162 (TRACE_STAT) is ok

11:49:47.42 Relation 163 (PERF_LOG)
11:49:47.42 process pointer page 0 of 159
11:49:47.51 process pointer page 1 of 159
11:49:47.59 process pointer page 2 of 159
11:49:47.67 process pointer page 3 of 159
11:49:47.75 process pointer page 4 of 159
11:49:47.84 process pointer page 5 of 159
11:49:47.92 process pointer page 6 of 159
11:49:48.00 process pointer page 7 of 159
11:49:48.09 process pointer page 8 of 159
11:49:48.17 process pointer page 9 of 159
11:49:48.24 process pointer page 10 of 159
11:49:48.34 process pointer page 11 of 159
11:49:48.42 process pointer page 12 of 159
11:49:48.49 process pointer page 13 of 159
11:49:48.59 process pointer page 14 of 159
11:49:48.67 process pointer page 15 of 159
11:49:48.74 process pointer page 16 of 159
11:49:48.84 process pointer page 17 of 159
11:49:48.92 process pointer page 18 of 159
11:49:48.99 process pointer page 19 of 159
11:49:49.09 process pointer page 20 of 159
11:49:49.17 process pointer page 21 of 159
11:49:49.24 process pointer page 22 of 159
11:49:49.32 process pointer page 23 of 159
11:49:49.41 process pointer page 24 of 159
11:49:49.49 process pointer page 25 of 159
11:49:49.57 process pointer page 26 of 159
11:49:49.66 process pointer page 27 of 159
11:49:49.74 process pointer page 28 of 159
11:49:49.84 process pointer page 29 of 159
11:49:49.91 process pointer page 30 of 159
11:49:49.99 process pointer page 31 of 159
11:49:50.09 process pointer page 32 of 159
11:49:50.16 process pointer page 33 of 159
11:49:50.24 process pointer page 34 of 159
11:49:50.32 process pointer page 35 of 159
11:49:50.40 process pointer page 36 of 159
11:49:50.49 process pointer page 37 of 159
11:49:50.57 process pointer page 38 of 159
11:49:50.65 process pointer page 39 of 159
11:49:50.73 process pointer page 40 of 159
11:49:50.82 process pointer page 41 of 159
11:49:50.90 process pointer page 42 of 159
11:49:50.97 process pointer page 43 of 159
11:49:51.05 process pointer page 44 of 159
11:49:51.15 process pointer page 45 of 159
11:49:51.22 process pointer page 46 of 159
11:49:51.30 process pointer page 47 of 159
11:49:51.40 process pointer page 48 of 159
11:49:51.47 process pointer page 49 of 159
11:49:51.57 process pointer page 50 of 159
11:49:51.65 process pointer page 51 of 159
11:49:51.72 process pointer page 52 of 159
11:49:51.80 process pointer page 53 of 159
11:49:51.90 process pointer page 54 of 159
11:49:52.00 process pointer page 55 of 159
11:49:52.08 process pointer page 56 of 159
11:49:52.18 process pointer page 57 of 159
11:49:52.25 process pointer page 58 of 159
11:49:52.33 process pointer page 59 of 159
11:49:52.41 process pointer page 60 of 159
11:49:52.50 process pointer page 61 of 159
11:49:52.58 process pointer page 62 of 159
11:49:52.68 process pointer page 63 of 159
11:49:52.75 process pointer page 64 of 159
11:49:52.83 process pointer page 65 of 159
11:49:52.92 process pointer page 66 of 159
11:49:53.00 process pointer page 67 of 159
11:49:53.10 process pointer page 68 of 159
11:49:53.17 process pointer page 69 of 159
11:49:53.27 process pointer page 70 of 159
11:49:53.35 process pointer page 71 of 159
11:49:53.42 process pointer page 72 of 159
11:49:53.50 process pointer page 73 of 159
11:49:53.60 process pointer page 74 of 159
11:49:53.67 process pointer page 75 of 159
11:49:53.75 process pointer page 76 of 159
11:49:53.83 process pointer page 77 of 159
11:49:53.94 process pointer page 78 of 159
11:49:54.03 process pointer page 79 of 159
11:49:54.11 process pointer page 80 of 159
11:49:54.19 process pointer page 81 of 159
11:49:54.27 process pointer page 82 of 159
11:49:54.34 process pointer page 83 of 159
11:49:54.44 process pointer page 84 of 159
11:49:54.52 process pointer page 85 of 159
11:49:54.59 process pointer page 86 of 159
11:49:54.67 process pointer page 87 of 159
11:49:54.77 process pointer page 88 of 159
11:49:54.84 process pointer page 89 of 159
11:49:54.92 process pointer page 90 of 159
11:49:55.00 process pointer page 91 of 159
11:49:55.09 process pointer page 92 of 159
11:49:55.17 process pointer page 93 of 159
11:49:55.25 process pointer page 94 of 159
11:49:55.33 process pointer page 95 of 159
11:49:55.41 process pointer page 96 of 159
11:49:55.50 process pointer page 97 of 159
11:49:55.58 process pointer page 98 of 159
11:49:55.65 process pointer page 99 of 159
11:49:55.73 process pointer page 100 of 159
11:49:55.83 process pointer page 101 of 159
11:49:55.90 process pointer page 102 of 159
11:49:55.98 process pointer page 103 of 159
11:49:56.06 process pointer page 104 of 159
11:49:56.14 process pointer page 105 of 159
11:49:56.22 process pointer page 106 of 159
11:49:56.31 process pointer page 107 of 159
11:49:56.39 process pointer page 108 of 159
11:49:56.47 process pointer page 109 of 159
11:49:56.54 process pointer page 110 of 159
11:49:56.64 process pointer page 111 of 159
11:49:56.72 process pointer page 112 of 159
11:49:56.79 process pointer page 113 of 159
11:49:56.87 process pointer page 114 of 159
11:49:56.97 process pointer page 115 of 159
11:49:57.04 process pointer page 116 of 159
11:49:57.12 process pointer page 117 of 159
11:49:57.20 process pointer page 118 of 159
11:49:57.29 process pointer page 119 of 159
11:49:57.37 process pointer page 120 of 159
11:49:57.45 process pointer page 121 of 159
11:49:57.54 process pointer page 122 of 159
11:49:57.62 process pointer page 123 of 159
11:49:57.70 process pointer page 124 of 159
11:49:57.78 process pointer page 125 of 159
11:49:57.87 process pointer page 126 of 159
11:49:57.95 process pointer page 127 of 159
11:49:58.03 process pointer page 128 of 159
11:49:58.10 process pointer page 129 of 159
11:49:58.20 process pointer page 130 of 159
11:49:58.28 process pointer page 131 of 159
11:49:58.35 process pointer page 132 of 159
11:49:58.43 process pointer page 133 of 159
11:49:58.53 process pointer page 134 of 159
11:49:58.60 process pointer page 135 of 159
11:49:58.68 process pointer page 136 of 159
11:49:58.77 process pointer page 137 of 159
11:49:58.85 process pointer page 138 of 159
11:49:58.93 process pointer page 139 of 159
11:49:59.02 process pointer page 140 of 159
11:49:59.10 process pointer page 141 of 159
11:49:59.18 process pointer page 142 of 159
11:49:59.26 process pointer page 143 of 159
11:49:59.35 process pointer page 144 of 159
11:49:59.43 process pointer page 145 of 159
11:49:59.51 process pointer page 146 of 159
11:49:59.60 process pointer page 147 of 159
11:49:59.68 process pointer page 148 of 159
11:49:59.76 process pointer page 149 of 159
11:49:59.85 process pointer page 150 of 159
11:49:59.93 process pointer page 151 of 159
11:50:00.01 process pointer page 152 of 159
11:50:00.09 process pointer page 153 of 159
11:50:00.18 process pointer page 154 of 159
11:50:00.26 process pointer page 155 of 159
11:50:00.33 process pointer page 156 of 159
11:50:00.41 process pointer page 157 of 159
11:50:00.51 process pointer page 158 of 159
11:50:00.57 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:50:04.48 Index 2 (PERF_LOG_UNIT)
11:50:10.54 Index 3 (PERF_LOG_TRN_DESC)
11:50:13.64 Index 4 (PERF_LOG_GDSCODE)
11:50:16.06 Relation 163 (PERF_LOG) is ok

11:50:16.06 Relation 167 (V_STOPTEST)
11:50:16.06 Relation 167 (V_STOPTEST) is ok

11:50:16.06 Relation 184 (V_QDISTR_SOURCE)
11:50:16.06 Relation 184 (V_QDISTR_SOURCE) is ok

11:50:16.06 Relation 185 (V_QSTORNED_SOURCE)
11:50:16.06 Relation 185 (V_QSTORNED_SOURCE) is ok

11:50:16.06 Relation 260 (XQD_1000_1200)
11:50:16.06 process pointer page 0 of 2
11:50:16.06 process pointer page 1 of 2
11:50:16.06 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:50:16.08 Relation 260 (XQD_1000_1200) is ok

11:50:16.08 Relation 261 (XQD_1200_2000)
11:50:16.08 process pointer page 0 of 3
11:50:16.09 process pointer page 1 of 3
11:50:16.15 process pointer page 2 of 3
11:50:16.18 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:50:16.20 Relation 261 (XQD_1200_2000) is ok

11:50:16.20 Relation 262 (XQD_1000_3300)
11:50:16.20 process pointer page 0 of 10
11:50:16.28 process pointer page 1 of 10
11:50:16.37 process pointer page 2 of 10
11:50:16.47 process pointer page 3 of 10
11:50:16.56 process pointer page 4 of 10
11:50:16.65 process pointer page 5 of 10
11:50:16.70 process pointer page 6 of 10
11:50:16.73 process pointer page 7 of 10
11:50:16.76 process pointer page 8 of 10
11:50:16.81 process pointer page 9 of 10
11:50:16.89 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:50:17.29 Index 2 (XQD_1000_3300_DOC)
11:50:17.60 Relation 262 (XQD_1000_3300) is ok

11:50:17.60 Relation 263 (XQD_2000_3300)
11:50:17.60 process pointer page 0 of 18
11:50:17.68 process pointer page 1 of 18
11:50:17.78 process pointer page 2 of 18
11:50:17.87 process pointer page 3 of 18
11:50:17.98 process pointer page 4 of 18
11:50:18.07 process pointer page 5 of 18
11:50:18.17 process pointer page 6 of 18
11:50:18.24 process pointer page 7 of 18
11:50:18.34 process pointer page 8 of 18
11:50:18.42 process pointer page 9 of 18
11:50:18.51 process pointer page 10 of 18
11:50:18.60 process pointer page 11 of 18
11:50:18.70 process pointer page 12 of 18
11:50:18.79 process pointer page 13 of 18
11:50:18.88 process pointer page 14 of 18
11:50:18.96 process pointer page 15 of 18
11:50:19.05 process pointer page 16 of 18
11:50:19.13 process pointer page 17 of 18
11:50:19.16 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:50:19.73 Relation 263 (XQD_2000_3300) is ok

11:50:19.73 Relation 264 (XQD_2100_3300)
11:50:19.73 process pointer page 0 of 14
11:50:19.79 process pointer page 1 of 14
11:50:19.85 process pointer page 2 of 14
11:50:19.93 process pointer page 3 of 14
11:50:19.99 process pointer page 4 of 14
11:50:20.05 process pointer page 5 of 14
11:50:20.13 process pointer page 6 of 14
11:50:20.19 process pointer page 7 of 14
11:50:20.26 process pointer page 8 of 14
11:50:20.32 process pointer page 9 of 14
11:50:20.38 process pointer page 10 of 14
11:50:20.44 process pointer page 11 of 14
11:50:20.52 process pointer page 12 of 14
11:50:20.58 process pointer page 13 of 14
11:50:20.61 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:50:20.61 Relation 264 (XQD_2100_3300) is ok

11:50:20.61 Relation 265 (XQD_3300_3400)
11:50:20.61 process pointer page 0 of 24
11:50:20.71 process pointer page 1 of 24
11:50:20.80 process pointer page 2 of 24
11:50:20.90 process pointer page 3 of 24
11:50:20.99 process pointer page 4 of 24
11:50:21.08 process pointer page 5 of 24
11:50:21.18 process pointer page 6 of 24
11:50:21.27 process pointer page 7 of 24
11:50:21.36 process pointer page 8 of 24
11:50:21.46 process pointer page 9 of 24
11:50:21.54 process pointer page 10 of 24
11:50:21.63 process pointer page 11 of 24
11:50:21.72 process pointer page 12 of 24
11:50:21.82 process pointer page 13 of 24
11:50:21.91 process pointer page 14 of 24
11:50:22.02 process pointer page 15 of 24
11:50:22.10 process pointer page 16 of 24
11:50:22.21 process pointer page 17 of 24
11:50:22.30 process pointer page 18 of 24
11:50:22.39 process pointer page 19 of 24
11:50:22.49 process pointer page 20 of 24
11:50:22.58 process pointer page 21 of 24
11:50:22.69 process pointer page 22 of 24
11:50:22.80 process pointer page 23 of 24
11:50:22.88 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:50:24.03 Relation 265 (XQD_3300_3400) is ok

11:50:24.03 Relation 266 (XQS_1000_1200)
11:50:24.03 process pointer page 0 of 43
11:50:24.14 process pointer page 1 of 43
11:50:24.23 process pointer page 2 of 43
11:50:24.34 process pointer page 3 of 43
11:50:24.45 process pointer page 4 of 43
11:50:24.56 process pointer page 5 of 43
11:50:24.67 process pointer page 6 of 43
11:50:24.76 process pointer page 7 of 43
11:50:24.87 process pointer page 8 of 43
11:50:24.98 process pointer page 9 of 43
11:50:25.09 process pointer page 10 of 43
11:50:25.20 process pointer page 11 of 43
11:50:25.31 process pointer page 12 of 43
11:50:25.40 process pointer page 13 of 43
11:50:25.51 process pointer page 14 of 43
11:50:25.62 process pointer page 15 of 43
11:50:25.73 process pointer page 16 of 43
11:50:25.84 process pointer page 17 of 43
11:50:25.93 process pointer page 18 of 43
11:50:26.04 process pointer page 19 of 43
11:50:26.15 process pointer page 20 of 43
11:50:26.26 process pointer page 21 of 43
11:50:26.36 process pointer page 22 of 43
11:50:26.46 process pointer page 23 of 43
11:50:26.57 process pointer page 24 of 43
11:50:26.68 process pointer page 25 of 43
11:50:26.95 process pointer page 26 of 43
11:50:27.24 process pointer page 27 of 43
11:50:27.56 process pointer page 28 of 43
11:50:27.85 process pointer page 29 of 43
11:50:28.20 process pointer page 30 of 43
11:50:28.46 process pointer page 31 of 43
11:50:28.74 process pointer page 32 of 43
11:50:29.05 process pointer page 33 of 43
11:50:29.38 process pointer page 34 of 43
11:50:29.69 process pointer page 35 of 43
11:50:30.07 process pointer page 36 of 43
11:50:30.38 process pointer page 37 of 43
11:50:30.72 process pointer page 38 of 43
11:50:31.07 process pointer page 39 of 43
11:50:31.39 process pointer page 40 of 43
11:50:31.72 process pointer page 41 of 43
11:50:32.07 process pointer page 42 of 43
11:50:32.17 Index 1 (XQS_1000_1200_DOC_ID)
11:50:34.55 Index 2 (XQS_1000_1200_SND_ID)
11:50:37.04 Index 3 (XQS_1000_1200_RCV_ID)
11:50:39.30 Relation 266 (XQS_1000_1200) is ok

11:50:39.30 Relation 267 (XQS_1200_2000)
11:50:39.30 process pointer page 0 of 46
11:50:39.72 process pointer page 1 of 46
11:50:40.18 process pointer page 2 of 46
11:50:40.61 process pointer page 3 of 46
11:50:41.04 process pointer page 4 of 46
11:50:41.46 process pointer page 5 of 46
11:50:41.88 process pointer page 6 of 46
11:50:42.33 process pointer page 7 of 46
11:50:42.77 process pointer page 8 of 46
11:50:43.20 process pointer page 9 of 46
11:50:43.62 process pointer page 10 of 46
11:50:44.06 process pointer page 11 of 46
11:50:44.48 process pointer page 12 of 46
11:50:44.90 process pointer page 13 of 46
11:50:45.33 process pointer page 14 of 46
11:50:45.73 process pointer page 15 of 46
11:50:46.17 process pointer page 16 of 46
11:50:46.59 process pointer page 17 of 46
11:50:47.04 process pointer page 18 of 46
11:50:47.48 process pointer page 19 of 46
11:50:47.95 process pointer page 20 of 46
11:50:48.40 process pointer page 21 of 46
11:50:48.88 process pointer page 22 of 46
11:50:49.37 process pointer page 23 of 46
11:50:49.83 process pointer page 24 of 46
11:50:50.30 process pointer page 25 of 46
11:50:50.79 process pointer page 26 of 46
11:50:51.24 process pointer page 27 of 46
11:50:51.67 process pointer page 28 of 46
11:50:52.14 process pointer page 29 of 46
11:50:52.59 process pointer page 30 of 46
11:50:53.03 process pointer page 31 of 46
11:50:53.47 process pointer page 32 of 46
11:50:53.97 process pointer page 33 of 46
11:50:54.40 process pointer page 34 of 46
11:50:54.83 process pointer page 35 of 46
11:50:55.23 process pointer page 36 of 46
11:50:55.67 process pointer page 37 of 46
11:50:56.07 process pointer page 38 of 46
11:50:56.51 process pointer page 39 of 46
11:50:56.93 process pointer page 40 of 46
11:50:57.38 process pointer page 41 of 46
11:50:57.79 process pointer page 42 of 46
11:50:58.23 process pointer page 43 of 46
11:50:58.65 process pointer page 44 of 46
11:50:59.08 process pointer page 45 of 46
11:50:59.16 Index 1 (XQS_1200_2000_DOC_ID)
11:51:01.92 Index 2 (XQS_1200_2000_SND_ID)
11:51:04.40 Index 3 (XQS_1200_2000_RCV_ID)
11:51:07.06 Relation 267 (XQS_1200_2000) is ok

11:51:07.06 Relation 268 (XQS_1000_3300)
11:51:07.06 process pointer page 0 of 23
11:51:07.56 process pointer page 1 of 23
11:51:08.05 process pointer page 2 of 23
11:51:08.55 process pointer page 3 of 23
11:51:09.05 process pointer page 4 of 23
11:51:09.55 process pointer page 5 of 23
11:51:10.04 process pointer page 6 of 23
11:51:10.53 process pointer page 7 of 23
11:51:11.03 process pointer page 8 of 23
11:51:11.53 process pointer page 9 of 23
11:51:12.02 process pointer page 10 of 23
11:51:12.52 process pointer page 11 of 23
11:51:13.00 process pointer page 12 of 23
11:51:13.50 process pointer page 13 of 23
11:51:13.98 process pointer page 14 of 23
11:51:14.48 process pointer page 15 of 23
11:51:14.95 process pointer page 16 of 23
11:51:15.40 process pointer page 17 of 23
11:51:15.87 process pointer page 18 of 23
11:51:16.37 process pointer page 19 of 23
11:51:16.84 process pointer page 20 of 23
11:51:17.31 process pointer page 21 of 23
11:51:17.73 process pointer page 22 of 23
11:51:17.79 Index 1 (XQS_1000_3300_DOC_ID)
11:51:19.24 Index 2 (XQS_1000_3300_SND_ID)
11:51:20.80 Index 3 (XQS_1000_3300_RCV_ID)
11:51:22.45 Relation 268 (XQS_1000_3300) is ok

11:51:22.45 Relation 269 (XQS_2000_3300)
11:51:22.45 process pointer page 0 of 1
11:51:22.45 Index 1 (XQS_2000_3300_DOC_ID)
11:51:22.45 Index 2 (XQS_2000_3300_SND_ID)
11:51:22.47 Index 3 (XQS_2000_3300_RCV_ID)
11:51:22.47 Relation 269 (XQS_2000_3300) is ok

11:51:22.47 Relation 270 (XQS_2100_3300)
11:51:22.47 process pointer page 0 of 32
11:51:22.95 process pointer page 1 of 32
11:51:23.45 process pointer page 2 of 32
11:51:23.95 process pointer page 3 of 32
11:51:24.43 process pointer page 4 of 32
11:51:24.93 process pointer page 5 of 32
11:51:25.43 process pointer page 6 of 32
11:51:25.92 process pointer page 7 of 32
11:51:26.42 process pointer page 8 of 32
11:51:26.90 process pointer page 9 of 32
11:51:27.38 process pointer page 10 of 32
11:51:27.87 process pointer page 11 of 32
11:51:28.37 process pointer page 12 of 32
11:51:28.86 process pointer page 13 of 32
11:51:29.35 process pointer page 14 of 32
11:51:29.85 process pointer page 15 of 32
11:51:30.36 process pointer page 16 of 32
11:51:30.85 process pointer page 17 of 32
11:51:31.33 process pointer page 18 of 32
11:51:31.81 process pointer page 19 of 32
11:51:32.30 process pointer page 20 of 32
11:51:32.76 process pointer page 21 of 32
11:51:33.22 process pointer page 22 of 32
11:51:33.67 process pointer page 23 of 32
11:51:34.12 process pointer page 24 of 32
11:51:34.57 process pointer page 25 of 32
11:51:35.01 process pointer page 26 of 32
11:51:35.46 process pointer page 27 of 32
11:51:35.90 process pointer page 28 of 32
11:51:36.34 process pointer page 29 of 32
11:51:36.77 process pointer page 30 of 32
11:51:37.07 process pointer page 31 of 32
11:51:37.07 Index 1 (XQS_2100_3300_DOC_ID)
11:51:39.10 Index 2 (XQS_2100_3300_SND_ID)
11:51:41.24 Index 3 (XQS_2100_3300_RCV_ID)
11:51:43.59 Relation 270 (XQS_2100_3300) is ok

11:51:43.59 Relation 271 (XQS_3300_3400)
11:51:43.59 process pointer page 0 of 6
11:51:44.09 process pointer page 1 of 6
11:51:44.62 process pointer page 2 of 6
11:51:45.09 process pointer page 3 of 6
11:51:45.57 process pointer page 4 of 6
11:51:46.01 process pointer page 5 of 6
11:51:46.15 Index 1 (XQS_3300_3400_DOC_ID)
11:51:46.51 Index 2 (XQS_3300_3400_SND_ID)
11:51:46.90 Relation 271 (XQS_3300_3400) is ok

11:51:46.91 Validation finished
Done for 125820 ms, from 11:49:41.22 to 11:51:47.04.

Differences between old and current firebird.log

11:51:48.83. 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-06-24 11:51 477 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 Sat Jun 24 11:49:41 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat Jun 24 11:51:46 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-06-24 11:51:58.89 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html
Subscribe