Tests

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

Server and database settings

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

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2018-07-03 06:46:59.8090 -1 <null> ::1/57939 832426 9133 2

Current test settings

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

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

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

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 5716.46 1146 1028963 2018-07-03 03:47 2018-07-03 06:47
customer order: creation 368.08 158 66255 2018-07-03 03:47 2018-07-03 06:47
customer order: refuse 29.99 87 5369 2018-07-03 03:47 2018-07-03 06:47
order to supplier: creation 94.02 562 16829 2018-07-03 03:47 2018-07-03 06:47
order to supplier: removal 2.91 7708 521 2018-07-03 03:47 2018-07-03 06:47
invoice (draft): creation 95.54 797 17102 2018-07-03 03:47 2018-07-03 06:47
invoice (draft): removal 41.01 175 7340 2018-07-03 03:47 2018-07-03 06:47
invoice accept: apply 54.58 3475 9770 2018-07-03 03:47 2018-07-03 06:47
invoice accept: cancel 19.08 702 3415 2018-07-03 03:47 2018-07-03 06:47
customer reserve: creation 3256.41 48 582897 2018-07-03 03:47 2018-07-03 06:47
customer reserve: removal 1254.85 17 224618 2018-07-03 03:47 2018-07-03 06:47
realization accept: apply 173.79 181 31109 2018-07-03 03:47 2018-07-03 06:47
realization accept: cancel 82.57 50 14780 2018-07-03 03:47 2018-07-03 06:47
payment from customer: creation 123.59 256 22246 2018-07-03 03:47 2018-07-03 06:47
payment from customer: removal 11.90 53 2130 2018-07-03 03:47 2018-07-03 06:47
payment to supplier: creation 101.87 181 18234 2018-07-03 03:47 2018-07-03 06:47
payment to supplier: removal 7.22 43 1293 2018-07-03 03:47 2018-07-03 06:47
service: total inventory turnovers 13.93 847 2508 2018-07-03 03:47 2018-07-03 06:47
service: total monetary turnovers 14.16 24 2535 2018-07-03 03:47 2018-07-03 06:47
service: refresh index statistics 0.07 6411 12 2018-07-03 03:47 2018-07-03 06:47
Done for 90630 ms, from 6:51:42.98 to 6:53:13.61.

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 3635 75971 65424 10547 13.88 03:47:00 04:05:00
interval # 2, overall 2 5165 105418 92978 12440 11.80 04:05:01 04:23:01
interval # 3, overall 3 6654 144114 119768 24346 16.89 04:23:02 04:41:02
interval # 4, overall 4 5574 123750 100331 23419 18.92 04:41:03 04:59:03
interval # 5, overall 5 5919 126651 106543 20108 15.88 04:59:04 05:17:04
interval # 6, overall 6 6504 141151 117063 24088 17.07 05:17:05 05:35:05
interval # 7, overall 7 6336 141547 114048 27499 19.43 05:35:06 05:53:06
interval # 8, overall 8 5925 133488 106655 26833 20.10 05:53:07 06:11:07
interval # 9, overall 9 5422 114525 97599 16926 14.78 06:11:08 06:29:08
interval # 10, overall 10 6031 137651 108554 29097 21.14 06:29:09 06:47:09
Done for 238480 ms, from 6:57:11.75 to 7:01:10.23.

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 1678.61 0.0017 2.1702 2115 10
TEST_TIME 2 2573.30 0.7080 1.3142 1608 16
TEST_TIME 3 2863.33 0.7875 1.1456 1608 19
TEST_TIME 4 2896.18 0.8499 1.1132 1067 24
TEST_TIME 5 2740.57 0.9412 1.0767 1056 25
TEST_TIME 6 2678.63 0.9181 1.0699 1037 26
TEST_TIME 7 2569.09 0.9562 1.0511 893 26
TEST_TIME 8 2460.80 0.9603 1.0578 694 26
TEST_TIME 9 2509.59 0.9221 1.0554 844 99
TEST_TIME 10 2538.03 0.9392 1.0718 908 100
TEST_TIME 11 2686.15 0.9308 1.0681 1174 100
TEST_TIME 12 2841.06 0.9258 1.0530 1165 100
TEST_TIME 13 2923.97 0.9445 1.0495 1298 100
TEST_TIME 14 3033.83 0.9393 1.0537 1217 100
TEST_TIME 15 3135.81 0.9531 1.0403 1090 100
TEST_TIME 16 3240.24 0.9440 1.0523 1694 100
TEST_TIME 17 3404.41 0.9434 1.0464 1428 100
TEST_TIME 18 3496.20 0.9623 1.0395 1513 100
TEST_TIME 19 3597.81 0.9570 1.0408 1543 100
TEST_TIME 20 3684.95 0.9654 1.0367 1434 100
TEST_TIME 21 3761.66 0.9672 1.0386 1180 100
TEST_TIME 22 3844.95 0.9700 1.0313 1250 100
TEST_TIME 23 3920.51 0.9675 1.0268 1333 100
TEST_TIME 24 3965.37 0.9738 1.0308 1038 100
TEST_TIME 25 3943.75 0.9981 1.0022 145 94
TEST_TIME 26 3804.98 0.9989 1.0012 78 78
TEST_TIME 27 3780.62 0.9704 1.0313 1352 100
TEST_TIME 28 3851.30 0.9763 1.0349 1271 100
TEST_TIME 29 3929.38 0.9794 1.0180 972 100
TEST_TIME 30 3955.36 0.9776 1.0198 1060 100
TEST_TIME 31 4024.22 0.9700 1.0260 1454 100
TEST_TIME 32 4098.68 0.9763 1.0301 1389 100
TEST_TIME 33 4153.09 0.9858 1.0203 978 100
TEST_TIME 34 4161.32 0.9883 1.0152 1513 100
TEST_TIME 35 4216.41 0.9733 1.0221 1365 48
TEST_TIME 36 4291.57 0.9763 1.0229 1434 25
TEST_TIME 37 4363.04 0.9790 1.0201 1666 24
TEST_TIME 38 4398.74 0.9852 1.0217 1082 91
TEST_TIME 39 4469.63 0.9799 1.0229 1351 100
TEST_TIME 40 4531.41 0.9837 1.0192 1362 100
TEST_TIME 41 4579.03 0.9841 1.0181 1346 100
TEST_TIME 42 4621.25 0.9852 1.0136 1257 100
TEST_TIME 43 4650.15 0.9839 1.0149 1302 100
TEST_TIME 44 4676.96 0.9861 1.0107 1201 100
TEST_TIME 45 4671.58 0.9895 1.0130 1186 100
TEST_TIME 46 4715.45 0.9818 1.0197 1804 100
TEST_TIME 47 4805.98 0.9792 1.0167 1562 100
TEST_TIME 48 4856.42 0.9852 1.0173 1743 100
TEST_TIME 49 4904.65 0.9867 1.0162 1474 100
TEST_TIME 50 4943.52 0.9882 1.0138 1387 100
TEST_TIME 51 4982.58 0.9862 1.0132 1546 100
TEST_TIME 52 5021.84 0.9860 1.0131 1346 100
TEST_TIME 53 5064.81 0.9859 1.0116 1358 100
TEST_TIME 54 5084.82 0.9890 1.0101 1341 100
TEST_TIME 55 5116.34 0.9856 1.0164 1232 100
TEST_TIME 56 5163.48 0.9895 1.0092 1289 100
TEST_TIME 57 5158.07 0.9926 1.0103 1253 100
TEST_TIME 58 5158.05 0.9929 1.0094 1155 100
TEST_TIME 59 5165.46 0.9909 1.0090 1110 100
TEST_TIME 60 5169.24 0.9915 1.0071 1054 100
TEST_TIME 61 5149.49 0.9945 1.0074 1372 95
TEST_TIME 62 5140.82 0.9928 1.0046 870 64
TEST_TIME 63 5084.32 0.9997 1.0008 87 71
TEST_TIME 64 5024.49 0.9969 1.0031 415 100
TEST_TIME 65 5040.92 0.9845 1.0131 2123 100
TEST_TIME 66 5083.42 0.9895 1.0094 1639 100
TEST_TIME 67 5117.33 0.9877 1.0123 1658 100
TEST_TIME 68 5144.82 0.9921 1.0085 1588 100
TEST_TIME 69 5157.07 0.9915 1.0080 1478 100
TEST_TIME 70 5165.47 0.9920 1.0094 1389 100
TEST_TIME 71 5184.31 0.9916 1.0078 1338 100
TEST_TIME 72 5205.31 0.9898 1.0089 1420 100
TEST_TIME 73 5222.67 0.9920 1.0100 1260 100
TEST_TIME 74 5246.73 0.9918 1.0133 1095 100
TEST_TIME 75 5274.26 0.9946 1.0047 1071 100
TEST_TIME 76 5290.71 0.9892 1.0123 1627 100
TEST_TIME 77 5345.81 0.9889 1.0099 1779 100
TEST_TIME 78 5401.85 0.9868 1.0102 1554 100
TEST_TIME 79 5437.25 0.9909 1.0128 1499 100
TEST_TIME 80 5480.00 0.9923 1.0084 1391 100
TEST_TIME 81 5489.48 0.9943 1.0037 1555 99
TEST_TIME 82 5475.13 0.9941 1.0062 1330 92
TEST_TIME 83 5470.22 0.9955 1.0062 1137 99
TEST_TIME 84 5463.94 0.9954 1.0041 1210 100
TEST_TIME 85 5423.48 0.9997 1.0002 149 85
TEST_TIME 86 5363.57 0.9996 1.0002 81 71
TEST_TIME 87 5339.21 0.9932 1.0032 1065 100
TEST_TIME 88 5331.05 0.9934 1.0089 1281 100
TEST_TIME 89 5351.74 0.9937 1.0049 1299 100
TEST_TIME 90 5347.84 0.9944 1.0068 1199 100
TEST_TIME 91 5370.90 0.9915 1.0095 1644 100
TEST_TIME 92 5403.63 0.9928 1.0078 1723 100
TEST_TIME 93 5427.57 0.9928 1.0061 1536 100
TEST_TIME 94 5448.13 0.9916 1.0062 1503 100
TEST_TIME 95 5460.26 0.9936 1.0087 1603 100
TEST_TIME 96 5486.24 0.9935 1.0064 1308 100
TEST_TIME 97 5503.04 0.9930 1.0048 1134 100
TEST_TIME 98 5510.35 0.9932 1.0060 1167 100
TEST_TIME 99 5519.26 0.9942 1.0058 1211 100
TEST_TIME 100 5529.88 0.9938 1.0055 1167 100
TEST_TIME 101 5528.64 0.9958 1.0036 1186 100
TEST_TIME 102 5519.08 0.9957 1.0045 1184 100
TEST_TIME 103 5513.50 0.9957 1.0042 1165 100
TEST_TIME 104 5504.04 0.9963 1.0066 1155 100
TEST_TIME 105 5510.25 0.9959 1.0035 1037 100
TEST_TIME 106 5525.19 0.9913 1.0075 1198 100
TEST_TIME 107 5545.87 0.9944 1.0055 1612 100
TEST_TIME 108 5552.42 0.9950 1.0029 1319 100
TEST_TIME 109 5519.23 0.9997 1.0005 186 80
TEST_TIME 110 5487.42 0.9972 1.0010 611 99
TEST_TIME 111 5477.35 0.9938 1.0056 1732 96
TEST_TIME 112 5496.55 0.9932 1.0053 1362 100
TEST_TIME 113 5503.95 0.9951 1.0042 1532 100
TEST_TIME 114 5521.22 0.9923 1.0055 1275 100
TEST_TIME 115 5548.78 0.9918 1.0046 1171 100
TEST_TIME 116 5554.40 0.9950 1.0054 1170 100
TEST_TIME 117 5560.36 0.9958 1.0061 1265 100
TEST_TIME 118 5579.03 0.9944 1.0047 1064 100
TEST_TIME 119 5580.67 0.9960 1.0037 1127 100
TEST_TIME 120 5577.54 0.9958 1.0044 1110 100
TEST_TIME 121 5593.83 0.9932 1.0057 1633 100
TEST_TIME 122 5605.66 0.9953 1.0057 1680 100
TEST_TIME 123 5624.29 0.9942 1.0054 1428 100
TEST_TIME 124 5632.45 0.9958 1.0039 1407 100
TEST_TIME 125 5639.19 0.9947 1.0048 1247 100
TEST_TIME 126 5641.94 0.9963 1.0036 1316 100
TEST_TIME 127 5657.87 0.9929 1.0051 1309 100
TEST_TIME 128 5666.63 0.9957 1.0064 1204 100
TEST_TIME 129 5679.28 0.9964 1.0031 1286 99
TEST_TIME 130 5654.46 0.9998 1.0003 140 96
TEST_TIME 131 5615.49 0.9996 1.0001 104 92
TEST_TIME 132 5588.09 0.9974 1.0029 855 100
TEST_TIME 133 5578.80 0.9970 1.0034 1322 100
TEST_TIME 134 5572.75 0.9972 1.0035 1269 99
TEST_TIME 135 5573.13 0.9960 1.0059 1068 100
TEST_TIME 136 5588.14 0.9958 1.0023 1717 100
TEST_TIME 137 5594.11 0.9939 1.0063 1267 100
TEST_TIME 138 5619.62 0.9945 1.0063 1547 100
TEST_TIME 139 5638.70 0.9957 1.0051 1731 100
TEST_TIME 140 5664.08 0.9934 1.0054 1259 100
TEST_TIME 141 5672.86 0.9967 1.0047 1406 100
TEST_TIME 142 5680.68 0.9962 1.0033 1130 100
TEST_TIME 143 5679.16 0.9965 1.0040 1354 100
TEST_TIME 144 5686.22 0.9958 1.0039 1269 100
TEST_TIME 145 5689.24 0.9964 1.0043 1194 100
TEST_TIME 146 5704.29 0.9948 1.0040 1145 100
TEST_TIME 147 5707.90 0.9965 1.0040 1167 100
TEST_TIME 148 5712.20 0.9965 1.0056 1127 100
TEST_TIME 149 5723.75 0.9969 1.0034 1099 100
TEST_TIME 150 5730.55 0.9955 1.0033 1020 100
TEST_TIME 151 5737.83 0.9954 1.0038 1620 100
TEST_TIME 152 5746.58 0.9957 1.0034 1710 100
TEST_TIME 153 5753.03 0.9957 1.0038 1524 100
TEST_TIME 154 5747.94 0.9982 1.0019 1624 98
TEST_TIME 155 5723.10 0.9998 1.0001 73 48
TEST_TIME 156 5687.85 0.9999 1.0000 34 34
TEST_TIME 157 5658.75 0.9988 1.0022 153 84
TEST_TIME 158 5660.40 0.9959 1.0029 1946 100
TEST_TIME 159 5661.57 0.9964 1.0040 1374 100
TEST_TIME 160 5657.07 0.9985 1.0021 1484 95
TEST_TIME 161 5649.84 0.9971 1.0038 1355 83
TEST_TIME 162 5660.52 0.9974 1.0032 945 100
TEST_TIME 163 5659.59 0.9972 1.0024 1237 99
TEST_TIME 164 5652.56 0.9975 1.0051 1165 100
TEST_TIME 165 5668.85 0.9962 1.0038 1023 100
TEST_TIME 166 5680.79 0.9957 1.0057 1513 100
TEST_TIME 167 5701.79 0.9960 1.0039 1598 100
TEST_TIME 168 5714.76 0.9956 1.0046 1531 100
TEST_TIME 169 5723.64 0.9971 1.0023 1628 100
TEST_TIME 170 5730.55 0.9954 1.0041 1351 100
TEST_TIME 171 5736.84 0.9972 1.0030 1273 100
TEST_TIME 172 5736.23 0.9972 1.0027 1252 100
TEST_TIME 173 5721.06 0.9996 1.0007 395 99
TEST_TIME 174 5693.43 0.9998 1.0002 101 94
TEST_TIME 175 5685.72 0.9958 1.0014 899 100
TEST_TIME 176 5688.17 0.9954 1.0042 1264 100
TEST_TIME 177 5697.58 0.9969 1.0025 1128 100
TEST_TIME 178 5700.69 0.9963 1.0030 1151 100
TEST_TIME 179 5700.69 0.9974 1.0037 1158 100
TEST_TIME 180 5707.88 0.9969 1.0014 1080 100
TEST_TIME 181 5684.86 0.9999 1.0000 73 73
Done for 10130 ms, from 7:01:11.80 to 7:01:21.93.

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 63567 55948 65630 <null> 70153 <null> 74609 74002 73047 71732 64059 44821 74455 40261 101367 73937 194548 371791 <null> 03:47:00 04:05:00
fetches per second 2 55533 34302 39145 84277 54149 90217 81626 20019 47583 37768 51529 27144 53782 88789 76051 30470 44536 411019 <null> 04:05:01 04:23:01
fetches per second 3 75663 58752 65161 104710 51477 15416 83791 105763 54552 58965 85085 37800 97973 56729 135400 11086 141339 428958 <null> 04:23:02 04:41:02
fetches per second 4 58273 105138 68104 <null> 82699 196590 75606 60493 38441 75558 63691 14505 77895 78714 117824 64729 <null> 567777 <null> 04:41:03 04:59:03
fetches per second 5 50451 123949 50471 <null> 69547 52994 78185 89032 23292 <null> 63877 <null> 58266 43388 105441 69313 129853 420666 <null> 04:59:04 05:17:04
fetches per second 6 58505 81107 48641 96992 52409 <null> 82898 69198 76187 24600 70516 21196 64863 22713 122538 <null> 100717 1237500 <null> 05:17:05 05:35:05
fetches per second 7 58316 55422 55558 <null> 60723 <null> 84999 <null> 67020 2771 83304 64791 77001 35233 93389 118000 62437 <null> <null> 05:35:06 05:53:06
fetches per second 8 44440 94333 41395 <null> 54897 <null> 61741 <null> 6336 65611 60767 41234 70241 72500 48953 <null> 112549 215378 <null> 05:53:07 06:11:07
fetches per second 9 40393 97923 46000 <null> 35063 6458 78696 <null> 26678 <null> 58400 39828 56165 56315 82638 602 <null> <null> <null> 06:11:08 06:29:08
fetches per second 10 73179 95309 64437 <null> 63613 <null> 57416 93456 51646 85196 68491 31803 103239 12604 96433 8702 319479 376687 <null> 06:29:09 06:47:09
marks per second 1 14443 8870 14821 <null> 15729 <null> 9625 13536 6387 17030 10927 9125 6659 10509 5579 20125 13137 28497 <null> 03:47:00 04:05:00
marks per second 2 12668 4892 9064 17162 12464 23630 11874 4093 10043 9819 10001 5643 4044 21659 6363 7470 8401 43090 <null> 04:05:01 04:23:01
marks per second 3 16794 9273 15070 22076 11957 3513 11564 20015 8267 13114 14694 7359 10158 14291 8661 2652 7430 62104 <null> 04:23:02 04:41:02
marks per second 4 12871 16130 15773 <null> 19767 52954 11561 10931 6915 19852 11179 3377 7980 20142 6592 15642 <null> 36465 <null> 04:41:03 04:59:03
marks per second 5 11057 20022 11009 <null> 15523 12672 9990 16478 3576 <null> 11715 <null> 4442 11208 6226 16523 5565 51000 <null> 04:59:04 05:17:04
marks per second 6 12755 12042 11180 21665 11923 <null> 11342 13781 11205 5657 8026 4630 4120 6858 10861 <null> 18614 62000 <null> 05:17:05 05:35:05
marks per second 7 13046 9789 12427 <null> 12801 <null> 10784 <null> 9668 590 9895 11825 4378 8152 13298 27000 4632 <null> <null> 05:35:06 05:53:06
marks per second 8 9601 12866 8984 <null> 11909 <null> 6719 <null> 1262 15537 6378 8987 2982 15500 9402 <null> 11760 17849 <null> 05:53:07 06:11:07
marks per second 9 9038 13121 10247 <null> 7509 1759 9055 <null> 2964 <null> 6906 5200 2612 13652 13452 132 <null> <null> <null> 06:11:08 06:29:08
marks per second 10 15540 15439 13607 <null> 14238 <null> 8858 18185 10232 16543 12997 7048 5860 3291 15026 2364 24554 19229 <null> 06:29:09 06:47:09
reads/fetches*100 1 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 03:47:00 04:05:00
reads/fetches*100 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:05:01 04:23:01
reads/fetches*100 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:23:02 04:41:02
reads/fetches*100 4 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 04:41:03 04:59:03
reads/fetches*100 5 0 0 0 <null> 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 <null> 04:59:04 05:17:04
reads/fetches*100 6 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 05:17:05 05:35:05
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> <null> 05:35:06 05:53:06
reads/fetches*100 8 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 05:53:07 06:11:07
reads/fetches*100 9 0 0 0 <null> 0 0 0 <null> 0 <null> 0 0 0 0 0 0 <null> <null> <null> 06:11:08 06:29:08
reads/fetches*100 10 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 06:29:09 06:47:09
writes/marks*100 1 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 5 0 <null> 03:47:00 04:05:00
writes/marks*100 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 2 0 <null> 04:05:01 04:23:01
writes/marks*100 3 0 0 1 0 0 0 1 0 1 0 0 0 0 0 0 0 7 2 <null> 04:23:02 04:41:02
writes/marks*100 4 0 0 0 <null> 0 0 0 0 1 0 0 0 0 2 0 0 <null> 0 <null> 04:41:03 04:59:03
writes/marks*100 5 0 0 0 <null> 0 0 0 0 2 <null> 0 <null> 0 0 0 0 1 0 <null> 04:59:04 05:17:04
writes/marks*100 6 0 0 0 0 0 <null> 0 0 1 1 0 0 0 4 0 <null> 3 1 <null> 05:17:05 05:35:05
writes/marks*100 7 0 0 0 <null> 0 <null> 0 <null> 1 2 0 0 0 0 0 0 6 <null> <null> 05:35:06 05:53:06
writes/marks*100 8 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 05:53:07 06:11:07
writes/marks*100 9 0 0 0 <null> 0 0 0 <null> 0 <null> 0 0 0 0 0 0 <null> <null> <null> 06:11:08 06:29:08
writes/marks*100 10 1 0 0 <null> 0 <null> 0 0 2 0 0 1 0 0 0 0 1 0 <null> 06:29:09 06:47:09
Done for 8770 ms, from 7:01:23.28 to 7:01:32.05.

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 1849305 1643177 206128 11.14 0 28798 11 206128 2018-07-03 03:46 2018-07-03 06:47
doc_list_biud 1849735 1643177 206558 11.16 0 21747 5 206558 2018-07-03 03:46 2018-07-03 06:47
sp_add_invoice_to_stock 16066 9770 6296 39.18 15 179338 3475 6296 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_adding_invoice 4460 3415 1045 23.43 0 37269 702 1045 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_client_order 5472 5369 103 1.88 0 4836 87 103 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_customer_reserve 420009 224618 195391 46.52 0 21747 17 195391 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_pay_from_customer 2136 2130 6 0.28 0 8642 53 6 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_pay_to_supplier 1295 1293 2 0.15 0 1654 43 2 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_supplier_invoice 9634 7340 2294 23.81 0 13697 175 2294 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_supplier_order 1362 521 841 61.74 15 214594 7708 841 2018-07-03 03:46 2018-07-03 06:47
sp_cancel_write_off 23188 14780 8408 36.26 0 6911 50 8408 2018-07-03 03:46 2018-07-03 06:47
sp_client_order 66255 66255 0 0.00 0 21684 158 0 2018-07-03 03:46 2018-07-03 06:47
sp_customer_reserve 582897 582897 0 0.00 0 46286 48 0 2018-07-03 03:46 2018-07-03 06:47
sp_fill_shopping_cart 100425 100186 239 0.23 0 8783 36 0 2018-07-03 03:46 2018-07-03 06:47
sp_fill_shopping_cart_clo_res 582897 582897 0 0.00 0 15693 3 0 2018-07-03 03:46 2018-07-03 06:47
sp_get_clo_for_invoice 9770 9770 0 0.00 0 7940 95 0 2018-07-03 03:46 2018-07-03 06:47
sp_kill_cost_storno 30700 21618 9082 29.58 0 8626 6 9082 2018-07-03 03:46 2018-07-03 06:47
sp_kill_qstorno_ret_qs2qd 872637 471877 400760 45.92 0 21731 7 400760 2018-07-03 03:46 2018-07-03 06:47
sp_kill_qty_storno 503435 296922 206513 41.02 0 21747 21 206513 2018-07-03 03:46 2018-07-03 06:47
sp_lock_selected_doc 65983 57280 8703 13.18 0 4508 3 8703 2018-07-03 03:46 2018-07-03 06:47
sp_make_cost_storno 81359 81359 0 0.00 0 8658 112 0 2018-07-03 03:46 2018-07-03 06:47
sp_multiply_rows_for_pdistr 81359 81359 0 0.00 0 10218 16 0 2018-07-03 03:46 2018-07-03 06:47
sp_multiply_rows_for_qdistr 66255 66255 0 0.00 0 21309 52 0 2018-07-03 03:46 2018-07-03 06:47
sp_pay_from_customer 22246 22246 0 0.00 0 10015 256 0 2018-07-03 03:46 2018-07-03 06:47
sp_pay_to_supplier 18234 18234 0 0.00 0 11263 181 0 2018-07-03 03:46 2018-07-03 06:47
sp_payment_common 40480 40480 0 0.00 0 7066 27 0 2018-07-03 03:46 2018-07-03 06:47
sp_qd_handle_on_cancel_clo 5469 5369 100 1.82 0 4165 36 100 2018-07-03 03:46 2018-07-03 06:47
sp_qd_handle_on_invoice_upd_sts 14079 13185 894 6.34 0 19734 112 894 2018-07-03 03:46 2018-07-03 06:47
sp_qd_handle_on_reserve_upd_sts 31109 31109 0 0.00 0 19906 18 0 2018-07-03 03:46 2018-07-03 06:47
sp_reserve_write_off 31787 31109 678 2.13 0 20062 181 678 2018-07-03 03:46 2018-07-03 06:47
sp_supplier_invoice 17180 17102 78 0.45 0 37534 797 0 2018-07-03 03:46 2018-07-03 06:47
sp_supplier_order 16990 16829 161 0.94 0 26380 562 0 2018-07-03 03:46 2018-07-03 06:47
srv_find_qd_qs_mism 1154348 948098 206250 17.86 0 28798 6 206250 2018-07-03 03:46 2018-07-03 06:47
srv_make_invnt_saldo 2508 2508 0 0.00 0 144613 847 0 2018-07-03 03:46 2018-07-03 06:47
srv_make_money_saldo 2535 2535 0 0.00 0 1358 24 0 2018-07-03 03:46 2018-07-03 06:47
srv_recalc_idx_stat 12 12 0 0.00 1638 31263 6411 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_add_invoice_to_stock 6296 6296 0 0.00 0 15522 35 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_adding_invoice 655 655 0 0.00 0 6848 82 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_client_order 103 103 0 0.00 0 624 31 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_customer_reserve 51 51 0 0.00 0 62 7 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_pay_from_customer 6 6 0 0.00 0 16 7 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_pay_to_supplier 2 2 0 0.00 0 15 7 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_supplier_invoice 491 491 0 0.00 0 624 21 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_supplier_order 23265 23265 0 0.00 0 21778 33 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_cancel_write_off 22 22 0 0.00 0 499 42 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_reserve_write_off 678 678 0 0.00 0 3167 27 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_supplier_invoice 78 78 0 0.00 0 172 18 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-abend:sp_supplier_order 161 161 0 0.00 0 1778 28 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_add_invoice_to_stock 9770 9770 0 0.00 0 147670 588 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_adding_invoice 1087 1087 0 0.00 0 82431 377 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_client_order 5369 5369 0 0.00 0 30919 37 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_customer_reserve 2178 2178 0 0.00 0 12136 24 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_pay_from_customer 2130 2130 0 0.00 0 8393 35 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_pay_to_supplier 1293 1293 0 0.00 0 1419 14 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_supplier_invoice 763 763 0 0.00 0 3104 17 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_supplier_order 521 521 0 0.00 0 175484 1909 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_cancel_write_off 3060 3060 0 0.00 0 26614 33 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_client_order 66255 66255 0 0.00 0 44804 37 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_customer_reserve 3156 3156 0 0.00 0 3151 15 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_pay_from_customer 22246 22246 0 0.00 0 27035 30 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_pay_to_supplier 18234 18234 0 0.00 0 27035 26 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_reserve_write_off 31109 31109 0 0.00 0 37440 36 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_supplier_invoice 17102 17102 0 0.00 0 24819 32 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:sp_supplier_order 16829 16829 0 0.00 0 32916 34 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:srv_make_invnt_saldo 2508 2508 0 0.00 0 8112 9 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:srv_make_money_saldo 2535 2535 0 0.00 0 6957 13 0 2018-07-03 03:46 2018-07-03 06:47
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 32 11 0 2018-07-03 03:46 2018-07-03 06:47
v_add_invoice_to_stock 32132 19540 12592 39.18 0 4587 6 12592 2018-07-03 03:46 2018-07-03 06:47
v_all_customers 99534 99534 0 0.00 0 422 2 0 2018-07-03 03:46 2018-07-03 06:47
v_all_suppliers 70266 69788 478 0.68 0 639 2 0 2018-07-03 03:46 2018-07-03 06:47
v_all_wares 132510 132510 0 0.00 0 842 2 0 2018-07-03 03:46 2018-07-03 06:47
v_cancel_adding_invoice 2600 2174 426 16.38 0 3994 57 426 2018-07-03 03:46 2018-07-03 06:47
v_cancel_client_order 10944 10738 206 1.88 0 1014 2 206 2018-07-03 03:46 2018-07-03 06:47
v_cancel_customer_prepayment 4272 4260 12 0.28 0 920 3 12 2018-07-03 03:46 2018-07-03 06:47
v_cancel_customer_reserve 4458 4356 102 2.28 0 2262 3 102 2018-07-03 03:46 2018-07-03 06:47
v_cancel_payment_to_supplier 2590 2586 4 0.15 0 577 3 4 2018-07-03 03:46 2018-07-03 06:47
v_cancel_supplier_invoice 2508 1526 982 39.15 0 967 7 982 2018-07-03 03:46 2018-07-03 06:47
v_cancel_supplier_order 2724 1042 1682 61.74 0 250 2 1682 2018-07-03 03:46 2018-07-03 06:47
v_cancel_write_off 6164 6120 44 0.71 0 4041 38 44 2018-07-03 03:46 2018-07-03 06:47
v_max_id_clo_ord 16990 16829 161 0.94 0 2652 2 0 2018-07-03 03:46 2018-07-03 06:47
v_max_id_clo_res 3156 3156 0 0.00 0 2122 8 0 2018-07-03 03:46 2018-07-03 06:47
v_max_id_ord_sup 17180 17102 78 0.45 0 343 2 0 2018-07-03 03:46 2018-07-03 06:47
v_max_non_paid_invoice 17271 17271 0 0.00 0 312 2 0 2018-07-03 03:46 2018-07-03 06:47
v_max_non_paid_realizn 22246 22246 0 0.00 0 968 2 0 2018-07-03 03:46 2018-07-03 06:47
v_min_id_clo_ord 16990 16829 161 0.94 0 2854 3 0 2018-07-03 03:46 2018-07-03 06:47
v_min_id_clo_res 3156 3156 0 0.00 0 577 4 0 2018-07-03 03:46 2018-07-03 06:47
v_min_id_ord_sup 17180 17102 78 0.45 0 8752 6 0 2018-07-03 03:46 2018-07-03 06:47
v_min_non_paid_invoice 18234 18234 0 0.00 0 7066 3 0 2018-07-03 03:46 2018-07-03 06:47
v_min_non_paid_realizn 22246 22246 0 0.00 0 1107 3 0 2018-07-03 03:46 2018-07-03 06:47
v_our_firm 32976 32976 0 0.00 0 436 2 0 2018-07-03 03:46 2018-07-03 06:47
v_reserve_write_off 63574 62218 1356 2.13 0 6926 3 1356 2018-07-03 03:46 2018-07-03 06:47
x_lock_depdocs_on_canc_invoice 19509 9992 9517 48.78 0 1514 11 9517 2018-07-03 03:46 2018-07-03 06:47
x_lock_depdocs_on_canc_sup_ord 1360 521 839 61.69 0 406 17 839 2018-07-03 03:46 2018-07-03 06:47
x_make_qstorno_1000_1200 16990 16829 161 0.94 0 26380 482 0 2018-07-03 03:46 2018-07-03 06:47
x_make_qstorno_1200_2000 17180 17102 78 0.45 0 37503 713 0 2018-07-03 03:46 2018-07-03 06:47
x_make_qstorno_2100_3300 582897 582897 0 0.00 0 46286 42 0 2018-07-03 03:46 2018-07-03 06:47
Done for 314590 ms, from 7:06:22.88 to 7:11:37.47.

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 61 sp_kill_cost_storno 335544336 2018-07-03 03:47 2018-07-03 06:35
deadlock 74 sp_kill_qstorno_ret_qs2qd 335544336 2018-07-03 03:50 2018-07-03 06:41
deadlock 7548 sp_lock_selected_doc 335544336 2018-07-03 03:47 2018-07-03 06:47
deadlock 100 sp_qd_handle_on_cancel_clo 335544336 2018-07-03 03:50 2018-07-03 06:33
deadlock 176 sp_qd_handle_on_invoice_upd_sts 335544336 2018-07-03 03:47 2018-07-03 06:46
deadlock 569 x_lock_depdocs_on_canc_invoice 335544336 2018-07-03 03:47 2018-07-03 06:47
deadlock 170 x_lock_depdocs_on_canc_sup_ord 335544336 2018-07-03 03:48 2018-07-03 06:45
user_exc 161 x_make_qstorno_1000_1200 335544517 2018-07-03 03:47 2018-07-03 06:43
user_exc 78 x_make_qstorno_1200_2000 335544517 2018-07-03 03:47 2018-07-03 06:44
Done for 11960 ms, from 7:11:47.63 to 7:11:59.59.

MON$DATABASE and FB VERSION info

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

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Gstat execution time Tue Jul 03 07:12:00 2018

Database header page information:
Flags 0
Generation 833299
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 833157
Oldest active 833158
Oldest snapshot 833158
Next transaction 833159
Sequence number 0
Next attachment ID 9342
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write

Variable header data:
Sweep interval: 0
*END*


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

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

Index AGENTS_IS_OUR_FIRM (4)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.01, total records: 1904397
Average version length: 47.38, total versions: 830, 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: 13, data page slots: 20512
Data pages: 20512, average fill: 73%
Primary pages: 20512, secondary pages: 0, swept pages: 12237
Empty pages: 5, full pages: 19642
Fill distribution:
0 - 19% = 6
20 - 39% = 7
40 - 59% = 85
60 - 79% = 20410
80 - 99% = 4

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 8870, nodes: 1904397
Average node length: 19.18, total dup: 0, max dup: 0
Average key length: 16.23, compression ratio: 1.66
Average prefix length: 13.77, average data length: 13.23
Clustering factor: 263477, ratio: 0.14
Fill distribution:
0 - 19% = 666
20 - 39% = 2298
40 - 59% = 3044
60 - 79% = 1114
80 - 99% = 1748

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 6816, nodes: 1904397
Average node length: 11.63, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 254679, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 3258
40 - 59% = 3404
60 - 79% = 146
80 - 99% = 8

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 169053, depth: 3, leaf buckets: 3032, nodes: 1904397
Average node length: 6.75, total dup: 1406289, max dup: 49
Average key length: 3.80, compression ratio: 2.37
Average prefix length: 7.46, average data length: 1.54
Clustering factor: 233104, ratio: 0.12
Fill distribution:
0 - 19% = 129
20 - 39% = 983
40 - 59% = 841
60 - 79% = 434
80 - 99% = 645

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.45, total records: 555843
Average version length: 35.90, total versions: 166, max versions: 2
Average fragment length: 36.81, total fragments: 21, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7016
Data pages: 7016, average fill: 75%
Primary pages: 7008, secondary pages: 8, swept pages: 6590
Empty pages: 0, full pages: 6866
Fill distribution:
0 - 19% = 8
20 - 39% = 7
40 - 59% = 16
60 - 79% = 6974
80 - 99% = 11

Index DOC_LIST_ID_DESC (1)
Root page: 242625, depth: 3, leaf buckets: 2017, nodes: 555843
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.85, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 110048, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1054
40 - 59% = 887
60 - 79% = 70
80 - 99% = 6

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 576, nodes: 555843
Average node length: 4.85, total dup: 555793, max dup: 38021
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 253517, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 483
60 - 79% = 73
80 - 99% = 20

Index PK_DOC_LIST (0)
Root page: 332307, depth: 3, leaf buckets: 1340, nodes: 555843
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 110048, ratio: 0.20
Fill distribution:
0 - 19% = 63
20 - 39% = 228
40 - 59% = 352
60 - 79% = 340
80 - 99% = 357

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

Index DOC_STATES_MCODE_UNQ (1)
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

FB_ERRORS (159)
Primary pointer page: 338, Index root page: 339
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 64.90, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.46, total fragments: 342, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.60
Pointer pages: 1, data page slots: 32
Data pages: 20, average fill: 31%
Primary pages: 4, secondary pages: 16, swept pages: 4
Empty pages: 6, full pages: 3
Fill distribution:
0 - 19% = 10
20 - 39% = 4
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 292, ratio: 0.73
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 49.89, total records: 1314
Average version length: 71.10, total versions: 392, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.92
Pointer pages: 1, data page slots: 152
Data pages: 144, average fill: 12%
Primary pages: 144, secondary pages: 0, swept pages: 98
Empty pages: 84, full pages: 2
Fill distribution:
0 - 19% = 112
20 - 39% = 16
40 - 59% = 14
60 - 79% = 0
80 - 99% = 2

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 7, nodes: 1314
Average node length: 17.91, total dup: 16, max dup: 1
Average key length: 16.04, compression ratio: 1.68
Average prefix length: 13.95, average data length: 13.05
Clustering factor: 1089, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 3
60 - 79% = 1
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
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% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 44.57, total records: 28
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: 64.00, compression ratio: 1.44
Pointer pages: 1, data page slots: 8
Data pages: 8, average fill: 6%
Primary pages: 8, secondary pages: 0, swept pages: 6
Empty pages: 3, full pages: 0
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 190980, depth: 2, leaf buckets: 1, nodes: 28
Average node length: 11.71, total dup: 12, max dup: 4
Average key length: 10.68, compression ratio: 1.78
Average prefix length: 10.86, average data length: 8.14
Clustering factor: 17, ratio: 0.61
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.56, total records: 146138
Average version length: 30.89, total versions: 408, max versions: 4
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.50
Pointer pages: 2, data page slots: 1656
Data pages: 1656, average fill: 65%
Primary pages: 1649, secondary pages: 7, swept pages: 1272
Empty pages: 13, full pages: 859
Fill distribution:
0 - 19% = 69
20 - 39% = 119
40 - 59% = 60
60 - 79% = 1406
80 - 99% = 2

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 121, nodes: 146138
Average node length: 4.27, total dup: 146089, max dup: 7544
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 27272, ratio: 0.19
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 43
60 - 79% = 50
80 - 99% = 21

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 156, nodes: 146138
Average node length: 5.21, total dup: 131827, max dup: 54
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 38395, ratio: 0.26
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 64
60 - 79% = 55
80 - 99% = 23

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 161, nodes: 146138
Average node length: 5.21, total dup: 131827, max dup: 54
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 38451, ratio: 0.26
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 75
60 - 79% = 51
80 - 99% = 18

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 156, nodes: 146138
Average node length: 5.00, total dup: 131827, max dup: 54
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 38431, ratio: 0.26
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 75
60 - 79% = 46
80 - 99% = 17

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 236838, depth: 2, leaf buckets: 176, nodes: 221383
Average node length: 4.42, total dup: 221202, max dup: 2122
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 23390, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 67
60 - 79% = 58
80 - 99% = 50

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

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

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

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 13659, nodes: 11481548
Average node length: 5.65, total dup: 10691327, max dup: 152
Average key length: 2.17, compression ratio: 3.69
Average prefix length: 7.87, average data length: 0.12
Clustering factor: 1955062, ratio: 0.17
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 9374
60 - 79% = 2689
80 - 99% = 1592

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11468, nodes: 11481548
Average node length: 4.61, total dup: 11481544, max dup: 9992022
Average key length: 1.13, compression ratio: 0.57
Average prefix length: 0.65, average data length: 0.00
Clustering factor: 327435, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11465
60 - 79% = 2
80 - 99% = 1

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 14438, nodes: 11481548
Average node length: 5.69, total dup: 11161467, max dup: 28158
Average key length: 2.21, compression ratio: 4.07
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 616457, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11815
60 - 79% = 1492
80 - 99% = 1131

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13894, nodes: 11481548
Average node length: 5.54, total dup: 11462254, max dup: 1788228
Average key length: 2.06, compression ratio: 18.40
Average prefix length: 37.92, average data length: 0.06
Clustering factor: 5018798, ratio: 0.44
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 12138
60 - 79% = 321
80 - 99% = 1425

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 55.05, total records: 430381
Average version length: 55.92, total versions: 232, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5096
Data pages: 5096, average fill: 75%
Primary pages: 5096, secondary pages: 0, swept pages: 3366
Empty pages: 7, full pages: 4936
Fill distribution:
0 - 19% = 12
20 - 39% = 3
40 - 59% = 12
60 - 79% = 5068
80 - 99% = 1

Index PSTORNED_RCV_ID (2)
Root page: 546031, depth: 3, leaf buckets: 542, nodes: 430381
Average node length: 5.81, total dup: 369748, max dup: 997
Average key length: 3.03, compression ratio: 2.97
Average prefix length: 8.11, average data length: 0.89
Clustering factor: 48998, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 28
40 - 59% = 330
60 - 79% = 129
80 - 99% = 55

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 449, nodes: 430381
Average node length: 5.59, total dup: 383722, max dup: 133
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 98877, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 180
60 - 79% = 175
80 - 99% = 91

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

Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

Index SETTINGS_MODE_CODE (0)
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.65, total records: 2583
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.52
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 74%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 31
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 31
80 - 99% = 0

WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

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

Index PK_WARE_GROUPS (0)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 56.77, total records: 5891
Average version length: 72.13, total versions: 1260, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.40
Pointer pages: 1, data page slots: 176
Data pages: 152, average fill: 46%
Primary pages: 152, secondary pages: 0, swept pages: 105
Empty pages: 11, full pages: 45
Fill distribution:
0 - 19% = 36
20 - 39% = 35
40 - 59% = 17
60 - 79% = 56
80 - 99% = 8

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 12, nodes: 5891
Average node length: 6.76, total dup: 5087, max dup: 14
Average key length: 4.80, compression ratio: 7.70
Average prefix length: 34.33, average data length: 2.67
Clustering factor: 997, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 5
60 - 79% = 2
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 72.03, total records: 546580
Average version length: 71.75, total versions: 1071, 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: 6, data page slots: 8192
Data pages: 8112, average fill: 74%
Primary pages: 8112, secondary pages: 0, swept pages: 5470
Empty pages: 24, full pages: 6603
Fill distribution:
0 - 19% = 37
20 - 39% = 65
40 - 59% = 392
60 - 79% = 7611
80 - 99% = 7

Index XQD_1000_3300_DOC (1)
Root page: 675160, depth: 3, leaf buckets: 536, nodes: 546580
Average node length: 5.08, total dup: 529834, max dup: 114
Average key length: 2.22, compression ratio: 4.05
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 61102, ratio: 0.11
Fill distribution:
0 - 19% = 15
20 - 39% = 65
40 - 59% = 229
60 - 79% = 34
80 - 99% = 193

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 318729, depth: 3, leaf buckets: 728, nodes: 546580
Average node length: 6.19, total dup: 476391, max dup: 14
Average key length: 3.33, compression ratio: 11.10
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 106727, ratio: 0.20
Fill distribution:
0 - 19% = 26
20 - 39% = 155
40 - 59% = 241
60 - 79% = 117
80 - 99% = 189

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 60.97, total records: 19692
Average version length: 71.90, total versions: 3040, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.23
Pointer pages: 2, data page slots: 904
Data pages: 688, average fill: 34%
Primary pages: 688, secondary pages: 0, swept pages: 516
Empty pages: 76, full pages: 57
Fill distribution:
0 - 19% = 226
20 - 39% = 195
40 - 59% = 141
60 - 79% = 116
80 - 99% = 10

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 37, nodes: 19692
Average node length: 5.81, total dup: 17112, max dup: 44
Average key length: 3.83, compression ratio: 9.67
Average prefix length: 35.30, average data length: 1.70
Clustering factor: 2700, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 21
40 - 59% = 12
60 - 79% = 4
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 71.04, total records: 1287641
Average version length: 71.15, total versions: 20447, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 12, data page slots: 18504
Data pages: 18408, average fill: 77%
Primary pages: 18408, secondary pages: 0, swept pages: 5485
Empty pages: 111, full pages: 17671
Fill distribution:
0 - 19% = 154
20 - 39% = 100
40 - 59% = 225
60 - 79% = 17577
80 - 99% = 352

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 188945, depth: 3, leaf buckets: 1963, nodes: 1287641
Average node length: 5.57, total dup: 1213210, max dup: 49
Average key length: 2.63, compression ratio: 14.05
Average prefix length: 36.42, average data length: 0.58
Clustering factor: 117914, ratio: 0.09
Fill distribution:
0 - 19% = 13
20 - 39% = 895
40 - 59% = 738
60 - 79% = 146
80 - 99% = 171

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 27.19, total records: 2248
Average version length: 71.97, total versions: 1392, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 5.00
Pointer pages: 4, data page slots: 664
Data pages: 400, average fill: 8%
Primary pages: 399, secondary pages: 1, swept pages: 214
Empty pages: 221, full pages: 5
Fill distribution:
0 - 19% = 359
20 - 39% = 17
40 - 59% = 12
60 - 79% = 8
80 - 99% = 4

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 6, nodes: 2248
Average node length: 8.09, total dup: 1840, max dup: 40
Average key length: 6.17, compression ratio: 6.00
Average prefix length: 33.01, average data length: 3.99
Clustering factor: 365, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 71.24, total records: 2440508
Average version length: 70.50, total versions: 5858, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 22, data page slots: 34400
Data pages: 34400, average fill: 77%
Primary pages: 34400, secondary pages: 0, swept pages: 24985
Empty pages: 11, full pages: 32637
Fill distribution:
0 - 19% = 25
20 - 39% = 81
40 - 59% = 327
60 - 79% = 33773
80 - 99% = 194

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 4948, nodes: 2440508
Average node length: 6.84, total dup: 1981645, max dup: 14
Average key length: 3.87, compression ratio: 9.56
Average prefix length: 35.32, average data length: 1.68
Clustering factor: 387520, ratio: 0.16
Fill distribution:
0 - 19% = 7
20 - 39% = 2623
40 - 59% = 1816
60 - 79% = 293
80 - 99% = 209

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.33, total records: 4084574
Average version length: 83.78, total versions: 471, 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: 39, data page slots: 62560
Data pages: 62560, average fill: 80%
Primary pages: 62560, secondary pages: 0, swept pages: 21361
Empty pages: 2, full pages: 62417
Fill distribution:
0 - 19% = 6
20 - 39% = 4
40 - 59% = 11
60 - 79% = 18072
80 - 99% = 44467

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4397, nodes: 4084574
Average node length: 5.15, total dup: 3991255, max dup: 134
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 597691, ratio: 0.15
Fill distribution:
0 - 19% = 26
20 - 39% = 86
40 - 59% = 2383
60 - 79% = 1632
80 - 99% = 270

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 3690, nodes: 4084574
Average node length: 5.73, total dup: 3630848, max dup: 49
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 118356, ratio: 0.03
Fill distribution:
0 - 19% = 18
20 - 39% = 88
40 - 59% = 1015
60 - 79% = 220
80 - 99% = 2349

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 4897, nodes: 4084574
Average node length: 5.81, total dup: 3573491, max dup: 22
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 653130, ratio: 0.16
Fill distribution:
0 - 19% = 25
20 - 39% = 93
40 - 59% = 2536
60 - 79% = 1909
80 - 99% = 334

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 83.21, total records: 2536337
Average version length: 82.83, total versions: 3619, 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: 25, data page slots: 39336
Data pages: 39336, average fill: 79%
Primary pages: 39336, secondary pages: 0, swept pages: 28724
Empty pages: 9, full pages: 38410
Fill distribution:
0 - 19% = 20
20 - 39% = 44
40 - 59% = 160
60 - 79% = 14834
80 - 99% = 24278

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2688, nodes: 2536337
Average node length: 5.15, total dup: 2476759, max dup: 169
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 380442, ratio: 0.15
Fill distribution:
0 - 19% = 3
20 - 39% = 32
40 - 59% = 1588
60 - 79% = 770
80 - 99% = 295

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3820, nodes: 2536337
Average node length: 6.22, total dup: 2079958, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 183640, ratio: 0.07
Fill distribution:
0 - 19% = 89
20 - 39% = 1188
40 - 59% = 1343
60 - 79% = 710
80 - 99% = 490

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 3081, nodes: 2536337
Average node length: 5.81, total dup: 2217469, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 469507, ratio: 0.19
Fill distribution:
0 - 19% = 12
20 - 39% = 44
40 - 59% = 1895
60 - 79% = 817
80 - 99% = 313

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.46, total records: 4301406
Average version length: 84.22, total versions: 3394, 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: 41, data page slots: 66056
Data pages: 65904, average fill: 80%
Primary pages: 65904, secondary pages: 0, swept pages: 12970
Empty pages: 191, full pages: 65334
Fill distribution:
0 - 19% = 239
20 - 39% = 83
40 - 59% = 146
60 - 79% = 10590
80 - 99% = 54846

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 4413, nodes: 4301406
Average node length: 5.04, total dup: 4276157, max dup: 642
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 601743, ratio: 0.14
Fill distribution:
0 - 19% = 7
20 - 39% = 88
40 - 59% = 2431
60 - 79% = 1377
80 - 99% = 510

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 4659, nodes: 4301406
Average node length: 5.53, total dup: 3954278, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 118837, ratio: 0.03
Fill distribution:
0 - 19% = 111
20 - 39% = 923
40 - 59% = 1441
60 - 79% = 622
80 - 99% = 1562

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 4980, nodes: 4301406
Average node length: 5.72, total dup: 3830327, max dup: 87
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.37, average data length: 0.63
Clustering factor: 677645, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 97
40 - 59% = 2710
60 - 79% = 1551
80 - 99% = 618

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.25, total records: 3033117
Average version length: 82.51, total versions: 3155, 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: 29, data page slots: 46968
Data pages: 46968, average fill: 79%
Primary pages: 46968, secondary pages: 0, swept pages: 33490
Empty pages: 62, full pages: 46059
Fill distribution:
0 - 19% = 92
20 - 39% = 60
40 - 59% = 212
60 - 79% = 15295
80 - 99% = 31309

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3288, nodes: 3033117
Average node length: 5.02, total dup: 3018349, max dup: 1312
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 589431, ratio: 0.19
Fill distribution:
0 - 19% = 19
20 - 39% = 326
40 - 59% = 1780
60 - 79% = 819
80 - 99% = 344

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 4570, nodes: 3033117
Average node length: 6.22, total dup: 2489250, max dup: 14
Average key length: 3.24, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 236630, ratio: 0.08
Fill distribution:
0 - 19% = 116
20 - 39% = 1484
40 - 59% = 1543
60 - 79% = 825
80 - 99% = 602

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3650, nodes: 3033117
Average node length: 5.60, total dup: 2758911, max dup: 53
Average key length: 2.62, compression ratio: 3.43
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 631534, ratio: 0.21
Fill distribution:
0 - 19% = 17
20 - 39% = 337
40 - 59% = 1942
60 - 79% = 941
80 - 99% = 413

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.20, total records: 596397
Average version length: 68.72, total versions: 1085, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 5, data page slots: 8152
Data pages: 8152, average fill: 77%
Primary pages: 8152, secondary pages: 0, swept pages: 6004
Empty pages: 6, full pages: 8068
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 12
60 - 79% = 8106
80 - 99% = 28

Index XQS_3300_3400_DOC_ID (0)
Root page: 169384, depth: 3, leaf buckets: 720, nodes: 596397
Average node length: 5.28, total dup: 564317, max dup: 119
Average key length: 2.41, compression ratio: 3.73
Average prefix length: 8.64, average data length: 0.36
Clustering factor: 47512, ratio: 0.08
Fill distribution:
0 - 19% = 1
20 - 39% = 168
40 - 59% = 298
60 - 79% = 183
80 - 99% = 70

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 822, nodes: 596397
Average node length: 5.90, total dup: 510731, max dup: 19
Average key length: 3.03, compression ratio: 2.97
Average prefix length: 8.11, average data length: 0.89
Clustering factor: 49969, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 215
40 - 59% = 344
60 - 79% = 187
80 - 99% = 73

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Gstat completion time Tue Jul 03 07:14:30 2018

Done for 150010 ms, from 7:12:00.01 to 7:14:30.02.

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 1904397 830 0.0435
DOC_LIST 555843 166 0.0298
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 1314 392 29.8325
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 28 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 146138 408 0.2791
PERF_ESTIMATED 221383 0 0.0000
PERF_LOG 11481548 0 0.0000
PSTORNED 430381 232 0.0539
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 2583 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 5891 1260 21.3885
XQD_1000_3300 546580 1071 0.1959
XQD_1200_2000 19692 3040 15.4377
XQD_2000_3300 1287641 20447 1.5879
XQD_2100_3300 2248 1392 61.9217
XQD_3300_3400 2440508 5858 0.2400
XQS_1000_1200 4084574 471 0.0115
XQS_1000_3300 2536337 3619 0.1426
XQS_1200_2000 4301406 3394 0.0789
XQS_2100_3300 3033117 3155 0.1040
XQS_3300_3400 596397 1085 0.1819
Z_USED_VIEWS 29 0 0.0000
Done for 1950 ms, from 7:14:39.96 to 7:14:41.91.

Database validation

07:14:41.99 Validation started

07:14:42.00 Relation 140 (DOC_LIST)
07:14:42.00 process pointer page 0 of 5
07:14:42.08 process pointer page 1 of 5
07:14:42.19 process pointer page 2 of 5
07:14:42.28 process pointer page 3 of 5
07:14:42.39 process pointer page 4 of 5
07:14:42.41 Index 1 (PK_DOC_LIST)
07:14:42.63 Index 2 (DOC_LIST_ID_DESC)
07:14:42.86 Index 3 (FK_DOC_LIST_AGENTS)
07:14:43.08 Relation 140 (DOC_LIST) is ok

07:14:43.08 Relation 141 (DOC_DATA)
07:14:43.08 process pointer page 0 of 13
07:14:43.17 process pointer page 1 of 13
07:14:43.27 process pointer page 2 of 13
07:14:43.36 process pointer page 3 of 13
07:14:43.45 process pointer page 4 of 13
07:14:43.53 process pointer page 5 of 13
07:14:43.63 process pointer page 6 of 13
07:14:43.72 process pointer page 7 of 13
07:14:43.81 process pointer page 8 of 13
07:14:43.89 process pointer page 9 of 13
07:14:43.98 process pointer page 10 of 13
07:14:44.08 process pointer page 11 of 13
07:14:44.16 process pointer page 12 of 13
07:14:44.22 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:14:45.17 Index 3 (DOC_DATA_ID_DESC)
07:14:45.48 Index 4 (FK_DOC_DATA_DOC_LIST)
07:14:45.65 Relation 141 (DOC_DATA) is ok

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

07:14:45.65 Relation 150 (PDISTR)
07:14:45.65 process pointer page 0 of 2
07:14:45.69 process pointer page 1 of 2
07:14:45.69 Index 2 (PDISTR_SND_ID)
07:14:45.70 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:14:45.72 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:14:45.72 Index 5 (PDISTR_AGENT_ID)
07:14:45.73 Relation 150 (PDISTR) is ok

07:14:45.73 Relation 151 (PSTORNED)
07:14:45.73 process pointer page 0 of 4
07:14:45.76 process pointer page 1 of 4
07:14:45.79 process pointer page 2 of 4
07:14:45.81 process pointer page 3 of 4
07:14:45.81 Index 2 (PSTORNED_SND_ID)
07:14:45.89 Index 3 (PSTORNED_RCV_ID)
07:14:46.01 Relation 151 (PSTORNED) is ok

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

07:14:46.01 Relation 157 (INVNT_TURNOVER_LOG)
07:14:46.01 process pointer page 0 of 1
07:14:46.01 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:14:46.01 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:14:46.01 Relation 160 (PERF_ESTIMATED)
07:14:46.01 process pointer page 0 of 2
07:14:46.11 process pointer page 1 of 2
07:14:46.12 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:14:46.18 Relation 160 (PERF_ESTIMATED) is ok

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

07:14:46.18 Relation 162 (TRACE_STAT)
07:14:46.18 process pointer page 0 of 1
07:14:46.18 Relation 162 (TRACE_STAT) is ok

07:14:46.18 Relation 163 (PERF_LOG)
07:14:46.18 process pointer page 0 of 168
07:14:46.26 process pointer page 1 of 168
07:14:46.36 process pointer page 2 of 168
07:14:46.43 process pointer page 3 of 168
07:14:46.51 process pointer page 4 of 168
07:14:46.59 process pointer page 5 of 168
07:14:46.68 process pointer page 6 of 168
07:14:46.76 process pointer page 7 of 168
07:14:46.84 process pointer page 8 of 168
07:14:46.93 process pointer page 9 of 168
07:14:47.04 process pointer page 10 of 168
07:14:47.12 process pointer page 11 of 168
07:14:47.20 process pointer page 12 of 168
07:14:47.28 process pointer page 13 of 168
07:14:47.37 process pointer page 14 of 168
07:14:47.45 process pointer page 15 of 168
07:14:47.53 process pointer page 16 of 168
07:14:47.62 process pointer page 17 of 168
07:14:47.70 process pointer page 18 of 168
07:14:47.78 process pointer page 19 of 168
07:14:47.87 process pointer page 20 of 168
07:14:47.95 process pointer page 21 of 168
07:14:48.03 process pointer page 22 of 168
07:14:48.10 process pointer page 23 of 168
07:14:48.20 process pointer page 24 of 168
07:14:48.27 process pointer page 25 of 168
07:14:48.35 process pointer page 26 of 168
07:14:48.45 process pointer page 27 of 168
07:14:48.52 process pointer page 28 of 168
07:14:48.60 process pointer page 29 of 168
07:14:48.68 process pointer page 30 of 168
07:14:48.77 process pointer page 31 of 168
07:14:48.85 process pointer page 32 of 168
07:14:48.93 process pointer page 33 of 168
07:14:49.01 process pointer page 34 of 168
07:14:49.10 process pointer page 35 of 168
07:14:49.18 process pointer page 36 of 168
07:14:49.26 process pointer page 37 of 168
07:14:49.34 process pointer page 38 of 168
07:14:49.43 process pointer page 39 of 168
07:14:49.51 process pointer page 40 of 168
07:14:49.59 process pointer page 41 of 168
07:14:49.66 process pointer page 42 of 168
07:14:49.74 process pointer page 43 of 168
07:14:49.83 process pointer page 44 of 168
07:14:49.91 process pointer page 45 of 168
07:14:49.99 process pointer page 46 of 168
07:14:50.07 process pointer page 47 of 168
07:14:50.15 process pointer page 48 of 168
07:14:50.22 process pointer page 49 of 168
07:14:50.30 process pointer page 50 of 168
07:14:50.40 process pointer page 51 of 168
07:14:50.47 process pointer page 52 of 168
07:14:50.55 process pointer page 53 of 168
07:14:50.63 process pointer page 54 of 168
07:14:50.71 process pointer page 55 of 168
07:14:50.79 process pointer page 56 of 168
07:14:50.88 process pointer page 57 of 168
07:14:50.96 process pointer page 58 of 168
07:14:50.99 process pointer page 59 of 168
07:14:51.04 process pointer page 60 of 168
07:14:51.07 process pointer page 61 of 168
07:14:51.10 process pointer page 62 of 168
07:14:51.13 process pointer page 63 of 168
07:14:51.16 process pointer page 64 of 168
07:14:51.18 process pointer page 65 of 168
07:14:51.21 process pointer page 66 of 168
07:14:51.24 process pointer page 67 of 168
07:14:51.27 process pointer page 68 of 168
07:14:51.29 process pointer page 69 of 168
07:14:51.32 process pointer page 70 of 168
07:14:51.35 process pointer page 71 of 168
07:14:51.36 process pointer page 72 of 168
07:14:51.39 process pointer page 73 of 168
07:14:51.41 process pointer page 74 of 168
07:14:51.44 process pointer page 75 of 168
07:14:51.46 process pointer page 76 of 168
07:14:51.49 process pointer page 77 of 168
07:14:51.52 process pointer page 78 of 168
07:14:51.57 process pointer page 79 of 168
07:14:51.64 process pointer page 80 of 168
07:14:51.72 process pointer page 81 of 168
07:14:51.80 process pointer page 82 of 168
07:14:51.89 process pointer page 83 of 168
07:14:51.97 process pointer page 84 of 168
07:14:52.05 process pointer page 85 of 168
07:14:52.13 process pointer page 86 of 168
07:14:52.21 process pointer page 87 of 168
07:14:52.28 process pointer page 88 of 168
07:14:52.36 process pointer page 89 of 168
07:14:52.46 process pointer page 90 of 168
07:14:52.53 process pointer page 91 of 168
07:14:52.61 process pointer page 92 of 168
07:14:52.69 process pointer page 93 of 168
07:14:52.77 process pointer page 94 of 168
07:14:52.85 process pointer page 95 of 168
07:14:52.94 process pointer page 96 of 168
07:14:53.02 process pointer page 97 of 168
07:14:53.10 process pointer page 98 of 168
07:14:53.17 process pointer page 99 of 168
07:14:53.25 process pointer page 100 of 168
07:14:53.33 process pointer page 101 of 168
07:14:53.42 process pointer page 102 of 168
07:14:53.50 process pointer page 103 of 168
07:14:53.58 process pointer page 104 of 168
07:14:53.66 process pointer page 105 of 168
07:14:53.73 process pointer page 106 of 168
07:14:53.81 process pointer page 107 of 168
07:14:53.91 process pointer page 108 of 168
07:14:53.98 process pointer page 109 of 168
07:14:54.06 process pointer page 110 of 168
07:14:54.14 process pointer page 111 of 168
07:14:54.22 process pointer page 112 of 168
07:14:54.30 process pointer page 113 of 168
07:14:54.37 process pointer page 114 of 168
07:14:54.45 process pointer page 115 of 168
07:14:54.53 process pointer page 116 of 168
07:14:54.62 process pointer page 117 of 168
07:14:54.70 process pointer page 118 of 168
07:14:54.78 process pointer page 119 of 168
07:14:54.86 process pointer page 120 of 168
07:14:54.94 process pointer page 121 of 168
07:14:55.01 process pointer page 122 of 168
07:14:55.09 process pointer page 123 of 168
07:14:55.19 process pointer page 124 of 168
07:14:55.26 process pointer page 125 of 168
07:14:55.34 process pointer page 126 of 168
07:14:55.42 process pointer page 127 of 168
07:14:55.50 process pointer page 128 of 168
07:14:55.58 process pointer page 129 of 168
07:14:55.67 process pointer page 130 of 168
07:14:55.75 process pointer page 131 of 168
07:14:55.83 process pointer page 132 of 168
07:14:55.90 process pointer page 133 of 168
07:14:55.98 process pointer page 134 of 168
07:14:56.07 process pointer page 135 of 168
07:14:56.15 process pointer page 136 of 168
07:14:56.23 process pointer page 137 of 168
07:14:56.31 process pointer page 138 of 168
07:14:56.40 process pointer page 139 of 168
07:14:56.48 process pointer page 140 of 168
07:14:56.56 process pointer page 141 of 168
07:14:56.61 process pointer page 142 of 168
07:14:56.64 process pointer page 143 of 168
07:14:56.67 process pointer page 144 of 168
07:14:56.70 process pointer page 145 of 168
07:14:56.73 process pointer page 146 of 168
07:14:56.76 process pointer page 147 of 168
07:14:56.79 process pointer page 148 of 168
07:14:56.82 process pointer page 149 of 168
07:14:56.85 process pointer page 150 of 168
07:14:56.89 process pointer page 151 of 168
07:14:56.92 process pointer page 152 of 168
07:14:56.93 process pointer page 153 of 168
07:14:56.96 process pointer page 154 of 168
07:14:57.00 process pointer page 155 of 168
07:14:57.03 process pointer page 156 of 168
07:14:57.06 process pointer page 157 of 168
07:14:57.07 process pointer page 158 of 168
07:14:57.10 process pointer page 159 of 168
07:14:57.12 process pointer page 160 of 168
07:14:57.15 process pointer page 161 of 168
07:14:57.17 process pointer page 162 of 168
07:14:57.20 process pointer page 163 of 168
07:14:57.24 process pointer page 164 of 168
07:14:57.34 process pointer page 165 of 168
07:14:57.42 process pointer page 166 of 168
07:14:57.49 process pointer page 167 of 168
07:14:57.49 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:15:01.13 Index 2 (PERF_LOG_UNIT)
07:15:05.51 Index 3 (PERF_LOG_TRN_DESC)
07:15:08.12 Index 4 (PERF_LOG_GDSCODE)
07:15:09.85 Relation 163 (PERF_LOG) is ok

07:15:09.85 Relation 167 (V_STOPTEST)
07:15:09.85 Relation 167 (V_STOPTEST) is ok

07:15:09.85 Relation 184 (V_QDISTR_SOURCE)
07:15:09.85 Relation 184 (V_QDISTR_SOURCE) is ok

07:15:09.85 Relation 185 (V_QSTORNED_SOURCE)
07:15:09.85 Relation 185 (V_QSTORNED_SOURCE) is ok

07:15:09.85 Relation 260 (XQD_1000_1200)
07:15:09.85 process pointer page 0 of 1
07:15:09.87 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:15:09.87 Relation 260 (XQD_1000_1200) is ok

07:15:09.87 Relation 261 (XQD_1200_2000)
07:15:09.87 process pointer page 0 of 2
07:15:09.90 process pointer page 1 of 2
07:15:09.90 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:15:09.91 Relation 261 (XQD_1200_2000) is ok

07:15:09.91 Relation 262 (XQD_1000_3300)
07:15:09.91 process pointer page 0 of 6
07:15:09.99 process pointer page 1 of 6
07:15:10.08 process pointer page 2 of 6
07:15:10.16 process pointer page 3 of 6
07:15:10.26 process pointer page 4 of 6
07:15:10.33 process pointer page 5 of 6
07:15:10.33 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:15:10.54 Index 2 (XQD_1000_3300_DOC)
07:15:10.69 Relation 262 (XQD_1000_3300) is ok

07:15:10.69 Relation 263 (XQD_2000_3300)
07:15:10.69 process pointer page 0 of 12
07:15:10.79 process pointer page 1 of 12
07:15:10.88 process pointer page 2 of 12
07:15:10.96 process pointer page 3 of 12
07:15:11.05 process pointer page 4 of 12
07:15:11.14 process pointer page 5 of 12
07:15:11.24 process pointer page 6 of 12
07:15:11.33 process pointer page 7 of 12
07:15:11.41 process pointer page 8 of 12
07:15:11.50 process pointer page 9 of 12
07:15:11.58 process pointer page 10 of 12
07:15:11.67 process pointer page 11 of 12
07:15:11.71 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:15:12.13 Relation 263 (XQD_2000_3300) is ok

07:15:12.13 Relation 264 (XQD_2100_3300)
07:15:12.13 process pointer page 0 of 4
07:15:12.14 process pointer page 1 of 4
07:15:12.14 process pointer page 2 of 4
07:15:12.14 process pointer page 3 of 4
07:15:12.14 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:15:12.14 Relation 264 (XQD_2100_3300) is ok

07:15:12.14 Relation 265 (XQD_3300_3400)
07:15:12.14 process pointer page 0 of 22
07:15:12.24 process pointer page 1 of 22
07:15:12.31 process pointer page 2 of 22
07:15:12.41 process pointer page 3 of 22
07:15:12.50 process pointer page 4 of 22
07:15:12.60 process pointer page 5 of 22
07:15:12.69 process pointer page 6 of 22
07:15:12.77 process pointer page 7 of 22
07:15:12.86 process pointer page 8 of 22
07:15:12.95 process pointer page 9 of 22
07:15:13.05 process pointer page 10 of 22
07:15:13.14 process pointer page 11 of 22
07:15:13.22 process pointer page 12 of 22
07:15:13.31 process pointer page 13 of 22
07:15:13.41 process pointer page 14 of 22
07:15:13.50 process pointer page 15 of 22
07:15:13.59 process pointer page 16 of 22
07:15:13.64 process pointer page 17 of 22
07:15:13.67 process pointer page 18 of 22
07:15:13.72 process pointer page 19 of 22
07:15:13.75 process pointer page 20 of 22
07:15:13.78 process pointer page 21 of 22
07:15:13.78 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:15:14.08 Relation 265 (XQD_3300_3400) is ok

07:15:14.08 Relation 266 (XQS_1000_1200)
07:15:14.08 process pointer page 0 of 39
07:15:14.11 process pointer page 1 of 39
07:15:14.14 process pointer page 2 of 39
07:15:14.16 process pointer page 3 of 39
07:15:14.19 process pointer page 4 of 39
07:15:14.22 process pointer page 5 of 39
07:15:14.31 process pointer page 6 of 39
07:15:14.40 process pointer page 7 of 39
07:15:14.48 process pointer page 8 of 39
07:15:14.58 process pointer page 9 of 39
07:15:14.67 process pointer page 10 of 39
07:15:14.75 process pointer page 11 of 39
07:15:14.84 process pointer page 12 of 39
07:15:14.94 process pointer page 13 of 39
07:15:15.01 process pointer page 14 of 39
07:15:15.11 process pointer page 15 of 39
07:15:15.20 process pointer page 16 of 39
07:15:15.29 process pointer page 17 of 39
07:15:15.37 process pointer page 18 of 39
07:15:15.47 process pointer page 19 of 39
07:15:15.54 process pointer page 20 of 39
07:15:15.64 process pointer page 21 of 39
07:15:15.73 process pointer page 22 of 39
07:15:15.81 process pointer page 23 of 39
07:15:15.90 process pointer page 24 of 39
07:15:16.00 process pointer page 25 of 39
07:15:16.07 process pointer page 26 of 39
07:15:16.17 process pointer page 27 of 39
07:15:16.26 process pointer page 28 of 39
07:15:16.34 process pointer page 29 of 39
07:15:16.43 process pointer page 30 of 39
07:15:16.53 process pointer page 31 of 39
07:15:16.60 process pointer page 32 of 39
07:15:16.70 process pointer page 33 of 39
07:15:16.79 process pointer page 34 of 39
07:15:16.87 process pointer page 35 of 39
07:15:16.96 process pointer page 36 of 39
07:15:17.04 process pointer page 37 of 39
07:15:17.13 process pointer page 38 of 39
07:15:17.17 Index 1 (XQS_1000_1200_DOC_ID)
07:15:18.37 Index 2 (XQS_1000_1200_SND_ID)
07:15:19.27 Index 3 (XQS_1000_1200_RCV_ID)
07:15:19.62 Relation 266 (XQS_1000_1200) is ok

07:15:19.62 Relation 267 (XQS_1200_2000)
07:15:19.62 process pointer page 0 of 41
07:15:19.66 process pointer page 1 of 41
07:15:19.69 process pointer page 2 of 41
07:15:19.72 process pointer page 3 of 41
07:15:19.74 process pointer page 4 of 41
07:15:19.77 process pointer page 5 of 41
07:15:19.80 process pointer page 6 of 41
07:15:19.82 process pointer page 7 of 41
07:15:19.91 process pointer page 8 of 41
07:15:20.01 process pointer page 9 of 41
07:15:20.11 process pointer page 10 of 41
07:15:20.22 process pointer page 11 of 41
07:15:20.33 process pointer page 12 of 41
07:15:20.43 process pointer page 13 of 41
07:15:20.54 process pointer page 14 of 41
07:15:20.64 process pointer page 15 of 41
07:15:20.74 process pointer page 16 of 41
07:15:20.85 process pointer page 17 of 41
07:15:20.96 process pointer page 18 of 41
07:15:21.08 process pointer page 19 of 41
07:15:21.14 process pointer page 20 of 41
07:15:21.21 process pointer page 21 of 41
07:15:21.32 process pointer page 22 of 41
07:15:21.42 process pointer page 23 of 41
07:15:21.52 process pointer page 24 of 41
07:15:21.63 process pointer page 25 of 41
07:15:21.74 process pointer page 26 of 41
07:15:21.83 process pointer page 27 of 41
07:15:21.94 process pointer page 28 of 41
07:15:22.03 process pointer page 29 of 41
07:15:22.14 process pointer page 30 of 41
07:15:22.25 process pointer page 31 of 41
07:15:22.35 process pointer page 32 of 41
07:15:22.45 process pointer page 33 of 41
07:15:22.56 process pointer page 34 of 41
07:15:22.66 process pointer page 35 of 41
07:15:22.77 process pointer page 36 of 41
07:15:22.86 process pointer page 37 of 41
07:15:22.97 process pointer page 38 of 41
07:15:23.06 process pointer page 39 of 41
07:15:23.17 process pointer page 40 of 41
07:15:23.22 Index 1 (XQS_1200_2000_DOC_ID)
07:15:24.64 Index 2 (XQS_1200_2000_SND_ID)
07:15:25.31 Index 3 (XQS_1200_2000_RCV_ID)
07:15:26.01 Relation 267 (XQS_1200_2000) is ok

07:15:26.01 Relation 268 (XQS_1000_3300)
07:15:26.01 process pointer page 0 of 25
07:15:26.12 process pointer page 1 of 25
07:15:26.23 process pointer page 2 of 25
07:15:26.34 process pointer page 3 of 25
07:15:26.45 process pointer page 4 of 25
07:15:26.54 process pointer page 5 of 25
07:15:26.65 process pointer page 6 of 25
07:15:26.76 process pointer page 7 of 25
07:15:26.87 process pointer page 8 of 25
07:15:26.96 process pointer page 9 of 25
07:15:27.07 process pointer page 10 of 25
07:15:27.18 process pointer page 11 of 25
07:15:27.29 process pointer page 12 of 25
07:15:27.38 process pointer page 13 of 25
07:15:27.49 process pointer page 14 of 25
07:15:27.60 process pointer page 15 of 25
07:15:27.70 process pointer page 16 of 25
07:15:27.81 process pointer page 17 of 25
07:15:27.91 process pointer page 18 of 25
07:15:28.01 process pointer page 19 of 25
07:15:28.12 process pointer page 20 of 25
07:15:28.23 process pointer page 21 of 25
07:15:28.32 process pointer page 22 of 25
07:15:28.43 process pointer page 23 of 25
07:15:28.54 process pointer page 24 of 25
07:15:28.54 Index 1 (XQS_1000_3300_DOC_ID)
07:15:29.47 Index 2 (XQS_1000_3300_SND_ID)
07:15:30.29 Index 3 (XQS_1000_3300_RCV_ID)
07:15:30.80 Relation 268 (XQS_1000_3300) is ok

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

07:15:30.80 Relation 270 (XQS_2100_3300)
07:15:30.80 process pointer page 0 of 29
07:15:30.83 process pointer page 1 of 29
07:15:30.88 process pointer page 2 of 29
07:15:30.91 process pointer page 3 of 29
07:15:30.94 process pointer page 4 of 29
07:15:30.97 process pointer page 5 of 29
07:15:31.00 process pointer page 6 of 29
07:15:31.03 process pointer page 7 of 29
07:15:31.07 process pointer page 8 of 29
07:15:31.10 process pointer page 9 of 29
07:15:31.13 process pointer page 10 of 29
07:15:31.14 process pointer page 11 of 29
07:15:31.17 process pointer page 12 of 29
07:15:31.21 process pointer page 13 of 29
07:15:31.32 process pointer page 14 of 29
07:15:31.41 process pointer page 15 of 29
07:15:31.52 process pointer page 16 of 29
07:15:31.63 process pointer page 17 of 29
07:15:31.74 process pointer page 18 of 29
07:15:31.83 process pointer page 19 of 29
07:15:31.94 process pointer page 20 of 29
07:15:32.03 process pointer page 21 of 29
07:15:32.14 process pointer page 22 of 29
07:15:32.25 process pointer page 23 of 29
07:15:32.34 process pointer page 24 of 29
07:15:32.45 process pointer page 25 of 29
07:15:32.55 process pointer page 26 of 29
07:15:32.66 process pointer page 27 of 29
07:15:32.75 process pointer page 28 of 29
07:15:32.84 Index 1 (XQS_2100_3300_DOC_ID)
07:15:33.98 Index 2 (XQS_2100_3300_SND_ID)
07:15:35.22 Index 3 (XQS_2100_3300_RCV_ID)
07:15:36.15 Relation 270 (XQS_2100_3300) is ok

07:15:36.15 Relation 271 (XQS_3300_3400)
07:15:36.17 process pointer page 0 of 5
07:15:36.26 process pointer page 1 of 5
07:15:36.31 process pointer page 2 of 5
07:15:36.35 process pointer page 3 of 5
07:15:36.39 process pointer page 4 of 5
07:15:36.43 Index 1 (XQS_3300_3400_DOC_ID)
07:15:36.49 Index 2 (XQS_3300_3400_SND_ID)
07:15:36.59 Relation 271 (XQS_3300_3400) is ok

07:15:36.59 Validation finished
Done for 54830 ms, from 7:14:41.93 to 7:15:36.76.

Differences between old and current firebird.log

7:15:37.87. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2018-07-03 07:15 471 oltp30_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Tue Jul 03 07:14:41 2018
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Tue Jul 03 07:15:36 2018
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2018-07-03 7:15:46.79 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html
Subscribe