Tests

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

Server and database settings

Server version: WI-T4.0.0.1047 Firebird 4.0 Alpha 1
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 4.0.0 D:\OLTP-EMUL\OLTP40-SMALL.FDB ON 0 786432 8192

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2018-07-06 11:17:08.8400 -1 <null> ::1/56307 388219 8976 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: 5818.27 1012 1047288 2018-07-06 08:17 2018-07-06 11:17
customer order: creation 375.34 152 67561 2018-07-06 08:17 2018-07-06 11:17
customer order: refuse 30.82 98 5547 2018-07-06 08:17 2018-07-06 11:17
order to supplier: creation 95.76 532 17236 2018-07-06 08:17 2018-07-06 11:17
order to supplier: removal 2.87 6318 517 2018-07-06 08:17 2018-07-06 11:17
invoice (draft): creation 96.84 771 17431 2018-07-06 08:17 2018-07-06 11:17
invoice (draft): removal 42.57 123 7662 2018-07-06 08:17 2018-07-06 11:17
invoice accept: apply 56.59 3179 10186 2018-07-06 08:17 2018-07-06 11:17
invoice accept: cancel 18.94 630 3410 2018-07-06 08:17 2018-07-06 11:17
customer reserve: creation 3330.73 45 599531 2018-07-06 08:17 2018-07-06 11:17
customer reserve: removal 1242.22 16 223600 2018-07-06 08:17 2018-07-06 11:17
realization accept: apply 174.17 123 31350 2018-07-06 08:17 2018-07-06 11:17
realization accept: cancel 84.34 35 15182 2018-07-06 08:17 2018-07-06 11:17
payment from customer: creation 124.88 182 22479 2018-07-06 08:17 2018-07-06 11:17
payment from customer: removal 11.74 42 2114 2018-07-06 08:17 2018-07-06 11:17
payment to supplier: creation 103.37 109 18606 2018-07-06 08:17 2018-07-06 11:17
payment to supplier: removal 7.51 51 1345 2018-07-06 08:17 2018-07-06 11:17
service: total inventory turnovers 9.69 972 1744 2018-07-06 08:17 2018-07-06 11:17
service: total monetary turnovers 9.91 20 1774 2018-07-06 08:17 2018-07-06 11:17
service: refresh index statistics 0.07 5838 13 2018-07-06 08:17 2018-07-06 11:17
Done for 87070 ms, from 11:21:48.62 to 11:23:15.69.

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 4477 94368 80592 13776 14.60 08:17:09 08:35:09
interval # 2, overall 2 5646 114964 101630 13334 11.60 08:35:10 08:53:10
interval # 3, overall 3 6323 134581 113809 20772 15.43 08:53:11 09:11:11
interval # 4, overall 4 5158 104844 92837 12007 11.45 09:11:12 09:29:12
interval # 5, overall 5 6586 138814 118553 20261 14.60 09:29:13 09:47:13
interval # 6, overall 6 6247 135590 112442 23148 17.07 09:47:14 10:05:14
interval # 7, overall 7 6952 147442 125133 22309 15.13 10:05:15 10:23:15
interval # 8, overall 8 4760 101001 85680 15321 15.17 10:23:16 10:41:16
interval # 9, overall 9 7358 154435 132435 22000 14.25 10:41:17 10:59:17
interval # 10, overall 10 4677 111514 84177 27337 24.51 10:59:18 11:17:18
Done for 193510 ms, from 11:26:28.17 to 11:29:41.68.

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 4270.98 0.5427 1.4842 2154 100
TEST_TIME 2 4126.63 0.7683 1.1841 1746 100
TEST_TIME 3 3980.55 0.8187 1.2073 1261 100
TEST_TIME 4 3892.89 0.9259 1.0941 1103 100
TEST_TIME 5 3728.65 0.9140 1.0888 1316 100
TEST_TIME 6 3694.46 0.9158 1.0747 1324 100
TEST_TIME 7 3684.68 0.9236 1.0808 1419 100
TEST_TIME 8 3790.21 0.9197 1.0808 1598 100
TEST_TIME 9 3899.16 0.9339 1.0658 1693 100
TEST_TIME 10 3971.52 0.9418 1.0613 1635 100
TEST_TIME 11 4041.23 0.9482 1.0539 1376 100
TEST_TIME 12 4094.47 0.9536 1.0399 1441 100
TEST_TIME 13 4100.97 0.9584 1.0457 1378 100
TEST_TIME 14 4139.55 0.9619 1.0390 1441 100
TEST_TIME 15 4229.15 0.9492 1.0586 1663 100
TEST_TIME 16 4381.52 0.9580 1.0449 1797 100
TEST_TIME 17 4474.67 0.9632 1.0457 1616 100
TEST_TIME 18 4591.68 0.9624 1.0425 1809 100
TEST_TIME 19 4650.78 0.9752 1.0179 1447 100
TEST_TIME 20 4623.17 0.9727 1.0249 1806 76
TEST_TIME 21 4574.45 0.9865 1.0169 484 100
TEST_TIME 22 4447.54 0.9984 1.0011 233 91
TEST_TIME 23 4356.85 0.9776 1.0196 1122 100
TEST_TIME 24 4393.73 0.9690 1.0292 1437 100
TEST_TIME 25 4467.41 0.9717 1.0313 1647 100
TEST_TIME 26 4527.77 0.9784 1.0264 1423 100
TEST_TIME 27 4582.81 0.9766 1.0219 1077 100
TEST_TIME 28 4616.03 0.9785 1.0179 1217 100
TEST_TIME 29 4642.58 0.9773 1.0199 1366 100
TEST_TIME 30 4707.67 0.9723 1.0264 1965 100
TEST_TIME 31 4827.77 0.9686 1.0245 2077 100
TEST_TIME 32 4903.48 0.9772 1.0257 1382 100
TEST_TIME 33 4977.64 0.9798 1.0233 1619 100
TEST_TIME 34 5048.76 0.9793 1.0181 1424 100
TEST_TIME 35 5073.66 0.9842 1.0173 1308 100
TEST_TIME 36 5109.90 0.9820 1.0147 1318 100
TEST_TIME 37 5145.01 0.9806 1.0185 1392 100
TEST_TIME 38 5202.15 0.9808 1.0193 1311 100
TEST_TIME 39 5255.07 0.9832 1.0156 1353 100
TEST_TIME 40 5270.68 0.9875 1.0112 1240 100
TEST_TIME 41 5271.08 0.9865 1.0118 1183 100
TEST_TIME 42 5272.65 0.9875 1.0148 1199 100
TEST_TIME 43 5285.86 0.9887 1.0091 1064 100
TEST_TIME 44 5255.42 0.9924 1.0049 1326 100
TEST_TIME 45 5226.40 0.9880 1.0163 1351 100
TEST_TIME 46 5272.62 0.9855 1.0192 1674 100
TEST_TIME 47 5336.64 0.9856 1.0133 1263 100
TEST_TIME 48 5364.13 0.9871 1.0152 1618 100
TEST_TIME 49 5426.38 0.9831 1.0155 1412 100
TEST_TIME 50 5467.96 0.9880 1.0126 1438 100
TEST_TIME 51 5475.74 0.9913 1.0105 1426 100
TEST_TIME 52 5491.70 0.9882 1.0128 1371 100
TEST_TIME 53 5503.85 0.9915 1.0101 1361 100
TEST_TIME 54 5513.89 0.9895 1.0139 1125 100
TEST_TIME 55 5537.69 0.9912 1.0090 1274 100
TEST_TIME 56 5539.16 0.9907 1.0069 1081 100
TEST_TIME 57 5532.07 0.9905 1.0095 1300 100
TEST_TIME 58 5540.34 0.9907 1.0074 1000 100
TEST_TIME 59 5536.86 0.9909 1.0087 1123 100
TEST_TIME 60 5555.15 0.9886 1.0097 1682 100
TEST_TIME 61 5605.05 0.9843 1.0146 1802 100
TEST_TIME 62 5635.02 0.9932 1.0067 1210 100
TEST_TIME 63 5585.44 0.9995 1.0003 154 81
TEST_TIME 64 5501.85 0.9996 1.0002 98 72
TEST_TIME 65 5420.09 0.9997 1.0002 80 68
TEST_TIME 66 5342.19 0.9995 1.0007 72 53
TEST_TIME 67 5302.43 0.9931 1.0045 599 100
TEST_TIME 68 5308.35 0.9887 1.0094 1881 100
TEST_TIME 69 5335.17 0.9898 1.0085 1658 100
TEST_TIME 70 5356.81 0.9901 1.0086 1304 100
TEST_TIME 71 5384.32 0.9893 1.0126 1307 100
TEST_TIME 72 5421.37 0.9917 1.0106 1287 100
TEST_TIME 73 5442.92 0.9928 1.0074 1406 100
TEST_TIME 74 5458.11 0.9914 1.0102 1258 100
TEST_TIME 75 5490.91 0.9908 1.0089 1784 100
TEST_TIME 76 5518.46 0.9907 1.0085 1941 100
TEST_TIME 77 5550.55 0.9899 1.0086 1861 100
TEST_TIME 78 5577.46 0.9909 1.0096 1556 100
TEST_TIME 79 5605.28 0.9918 1.0093 1433 100
TEST_TIME 80 5616.16 0.9948 1.0068 1440 100
TEST_TIME 81 5645.23 0.9893 1.0066 1421 100
TEST_TIME 82 5666.74 0.9908 1.0066 1219 100
TEST_TIME 83 5691.78 0.9902 1.0078 1114 100
TEST_TIME 84 5690.88 0.9959 1.0047 1352 100
TEST_TIME 85 5691.00 0.9928 1.0075 1238 100
TEST_TIME 86 5689.25 0.9961 1.0051 1298 100
TEST_TIME 87 5691.89 0.9931 1.0051 1150 100
TEST_TIME 88 5683.94 0.9950 1.0048 1156 100
TEST_TIME 89 5670.10 0.9960 1.0035 1097 100
TEST_TIME 90 5662.39 0.9937 1.0067 1730 100
TEST_TIME 91 5675.78 0.9933 1.0095 1764 100
TEST_TIME 92 5696.98 0.9949 1.0044 1441 100
TEST_TIME 93 5664.01 0.9994 1.0012 318 100
TEST_TIME 94 5613.85 0.9994 1.0005 232 97
TEST_TIME 95 5559.73 0.9996 1.0003 108 78
TEST_TIME 96 5546.70 0.9922 1.0069 1755 100
TEST_TIME 97 5569.55 0.9932 1.0059 1679 100
TEST_TIME 98 5578.44 0.9943 1.0081 1464 100
TEST_TIME 99 5599.47 0.9942 1.0074 1469 100
TEST_TIME 100 5617.01 0.9942 1.0056 1373 100
TEST_TIME 101 5639.13 0.9917 1.0058 1277 100
TEST_TIME 102 5651.93 0.9940 1.0056 1273 100
TEST_TIME 103 5664.62 0.9936 1.0058 1081 100
TEST_TIME 104 5682.58 0.9929 1.0065 1090 100
TEST_TIME 105 5695.51 0.9947 1.0056 1800 100
TEST_TIME 106 5714.52 0.9928 1.0072 1762 100
TEST_TIME 107 5737.93 0.9937 1.0068 1477 100
TEST_TIME 108 5755.74 0.9944 1.0061 1587 100
TEST_TIME 109 5780.81 0.9925 1.0043 1528 100
TEST_TIME 110 5795.19 0.9927 1.0048 1275 100
TEST_TIME 111 5806.19 0.9939 1.0051 1256 100
TEST_TIME 112 5807.31 0.9960 1.0057 1112 100
TEST_TIME 113 5821.02 0.9944 1.0045 1120 100
TEST_TIME 114 5813.54 0.9970 1.0034 1215 100
TEST_TIME 115 5810.60 0.9952 1.0071 1080 100
TEST_TIME 116 5820.56 0.9968 1.0033 1065 100
TEST_TIME 117 5815.70 0.9956 1.0037 1053 100
TEST_TIME 118 5811.88 0.9959 1.0043 1098 100
TEST_TIME 119 5815.04 0.9953 1.0040 1055 100
TEST_TIME 120 5816.77 0.9954 1.0059 1521 100
TEST_TIME 121 5839.95 0.9936 1.0076 1760 100
TEST_TIME 122 5864.89 0.9951 1.0063 1611 100
TEST_TIME 123 5886.82 0.9944 1.0044 1625 100
TEST_TIME 124 5908.41 0.9927 1.0054 1258 100
TEST_TIME 125 5918.46 0.9956 1.0038 1180 100
TEST_TIME 126 5924.61 0.9948 1.0039 1214 100
TEST_TIME 127 5927.88 0.9954 1.0044 1208 100
TEST_TIME 128 5929.10 0.9963 1.0039 1141 100
TEST_TIME 129 5949.07 0.9928 1.0042 1287 100
TEST_TIME 130 5960.70 0.9945 1.0052 1070 100
TEST_TIME 131 5970.46 0.9959 1.0038 1146 100
TEST_TIME 132 5968.13 0.9965 1.0042 1077 100
TEST_TIME 133 5962.98 0.9975 1.0038 935 100
TEST_TIME 134 5958.82 0.9970 1.0019 1014 100
TEST_TIME 135 5955.45 0.9957 1.0051 1481 100
TEST_TIME 136 5942.82 0.9998 1.0000 112 84
TEST_TIME 137 5900.39 0.9999 1.0000 75 63
TEST_TIME 138 5858.58 0.9999 1.0001 88 68
TEST_TIME 139 5817.97 0.9998 1.0001 118 81
TEST_TIME 140 5778.19 0.9998 1.0001 73 65
TEST_TIME 141 5738.23 0.9999 1.0000 92 79
TEST_TIME 142 5739.68 0.9927 1.0062 1620 100
TEST_TIME 143 5768.93 0.9941 1.0041 1616 100
TEST_TIME 144 5777.60 0.9956 1.0042 1307 100
TEST_TIME 145 5786.71 0.9959 1.0043 1366 100
TEST_TIME 146 5797.08 0.9958 1.0035 1403 100
TEST_TIME 147 5800.17 0.9962 1.0032 1259 100
TEST_TIME 148 5813.81 0.9941 1.0036 1083 100
TEST_TIME 149 5819.74 0.9958 1.0048 1189 100
TEST_TIME 150 5838.93 0.9949 1.0045 1664 100
TEST_TIME 151 5870.61 0.9925 1.0040 1586 100
TEST_TIME 152 5881.05 0.9957 1.0034 1495 100
TEST_TIME 153 5892.15 0.9950 1.0039 1574 100
TEST_TIME 154 5899.42 0.9961 1.0053 1492 100
TEST_TIME 155 5916.01 0.9960 1.0048 1299 100
TEST_TIME 156 5930.40 0.9960 1.0049 1236 100
TEST_TIME 157 5942.58 0.9965 1.0034 1169 100
TEST_TIME 158 5942.70 0.9970 1.0035 1224 100
TEST_TIME 159 5944.73 0.9968 1.0036 1108 100
TEST_TIME 160 5944.26 0.9974 1.0041 1101 100
TEST_TIME 161 5948.74 0.9971 1.0030 1103 100
TEST_TIME 162 5952.47 0.9975 1.0023 936 100
TEST_TIME 163 5946.38 0.9972 1.0023 995 100
TEST_TIME 164 5935.54 0.9981 1.0027 1031 100
TEST_TIME 165 5933.28 0.9970 1.0029 1099 100
TEST_TIME 166 5923.53 0.9985 1.0025 1824 91
TEST_TIME 167 5910.15 0.9987 1.0014 672 75
TEST_TIME 168 5883.88 0.9999 1.0000 120 44
TEST_TIME 169 5850.94 0.9997 1.0002 66 57
TEST_TIME 170 5819.84 0.9996 1.0000 70 67
TEST_TIME 171 5789.29 0.9994 1.0006 157 79
TEST_TIME 172 5798.03 0.9932 1.0040 1953 100
TEST_TIME 173 5807.27 0.9966 1.0031 1561 100
TEST_TIME 174 5810.75 0.9968 1.0029 1448 100
TEST_TIME 175 5810.10 0.9973 1.0031 1340 100
TEST_TIME 176 5814.85 0.9966 1.0030 1292 100
TEST_TIME 177 5817.22 0.9969 1.0030 1174 100
TEST_TIME 178 5822.73 0.9965 1.0041 1150 100
TEST_TIME 179 5829.19 0.9974 1.0024 1224 100
TEST_TIME 180 5815.39 0.9992 1.0004 225 100
Done for 11050 ms, from 11:29:42.50 to 11:29:53.55.

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 81833 75753 79311 <null> 83371 80246 78138 <null> 75951 89245 106136 72071 116954 136717 150059 70750 180750 268230 <null> 08:17:09 08:35:09
fetches per second 2 65995 92758 61296 <null> 75803 73189 75175 229000 30191 61127 78208 43294 58784 53077 118037 61076 225710 243442 <null> 08:35:10 08:53:10
fetches per second 3 63491 67084 71450 <null> 69153 <null> 95527 57563 115312 235285 68910 72447 94657 68900 122370 82643 238612 349153 <null> 08:53:11 09:11:11
fetches per second 4 74491 37959 58463 <null> 83776 109460 96307 <null> 140000 32093 113057 32779 78948 227285 152187 <null> 320622 <null> <null> 09:11:12 09:29:12
fetches per second 5 89377 42172 74716 <null> 79672 <null> 98277 93852 61061 152105 80230 69798 78110 50214 141941 17942 68229 690250 <null> 09:29:13 09:47:13
fetches per second 6 73054 118328 67215 <null> 70668 <null> 99996 <null> 5521 76883 81093 44817 88899 139588 133115 96555 116310 <null> <null> 09:47:14 10:05:14
fetches per second 7 68480 118322 59797 <null> 61170 <null> 77349 74852 57195 49070 82571 45040 109367 103341 83467 61692 201812 965000 <null> 10:05:15 10:23:15
fetches per second 8 66182 84138 46835 111511 83744 <null> 95025 <null> 75756 61562 82990 21648 124389 165950 69356 <null> <null> <null> <null> 10:23:16 10:41:16
fetches per second 9 70460 89932 69234 <null> 58602 5182 98216 84510 24736 135750 81831 21984 105959 91652 77048 17707 90644 219900 <null> 10:41:17 10:59:17
fetches per second 10 64433 <null> 70853 <null> 56159 82962 87746 <null> 44594 137888 87624 20316 124186 90125 101735 <null> 107784 227550 <null> 10:59:18 11:17:18
marks per second 1 18640 9364 17591 <null> 18377 14475 11874 <null> 11677 19303 19200 11535 11475 22453 15238 13083 15993 28063 <null> 08:17:09 08:35:09
marks per second 2 14836 12933 13900 <null> 17217 15594 11507 36893 4712 13042 13527 6985 5958 9499 9531 10307 22300 25252 <null> 08:35:10 08:53:10
marks per second 3 14137 8559 15789 <null> 16138 <null> 13316 9759 16155 38000 12287 14496 8774 11800 11125 15807 32661 31458 <null> 08:53:11 09:11:11
marks per second 4 16360 5084 13165 <null> 18327 28210 14120 <null> 21500 6139 13124 4270 8516 44571 15008 <null> 49016 <null> <null> 09:11:12 09:29:12
marks per second 5 19305 6379 16480 <null> 18493 <null> 14306 15658 8427 33736 13515 10920 6809 7071 12000 3634 7862 67875 <null> 09:29:13 09:47:13
marks per second 6 15266 17282 14194 <null> 15702 <null> 12419 <null> 641 14057 15409 7204 6680 27144 18274 18111 18561 <null> <null> 09:47:14 10:05:14
marks per second 7 14691 15314 12817 <null> 13441 <null> 11505 15684 8291 7605 11393 7112 7156 16226 14327 10461 21157 44500 <null> 10:05:15 10:23:15
marks per second 8 14606 10548 10071 24105 17190 <null> 14558 <null> 10400 6826 10788 3750 7244 27900 14996 <null> <null> <null> <null> 10:23:16 10:41:16
marks per second 9 15241 13226 15517 <null> 13239 1211 15073 14368 4305 22875 10370 3731 4290 13515 14938 2609 17146 40600 <null> 10:41:17 10:59:17
marks per second 10 13712 <null> 15908 <null> 11680 21093 12856 <null> 6334 22777 12657 2997 4908 16000 16695 <null> 6693 25866 <null> 10:59:18 11:17:18
reads/fetches*100 1 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 08:17:09 08:35:09
reads/fetches*100 2 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:35:10 08:53:10
reads/fetches*100 3 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:53:11 09:11:11
reads/fetches*100 4 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 <null> <null> 09:11:12 09:29:12
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 09:29:13 09:47:13
reads/fetches*100 6 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> <null> 09:47:14 10:05:14
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 10:05:15 10:23:15
reads/fetches*100 8 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> <null> <null> <null> 10:23:16 10:41:16
reads/fetches*100 9 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 10:41:17 10:59:17
reads/fetches*100 10 0 <null> 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 10:59:18 11:17:18
writes/marks*100 1 0 0 0 <null> 0 0 0 <null> 1 1 0 0 0 0 0 0 3 0 <null> 08:17:09 08:35:09
writes/marks*100 2 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 1 0 0 0 <null> 08:35:10 08:53:10
writes/marks*100 3 1 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 2 0 <null> 08:53:11 09:11:11
writes/marks*100 4 0 0 0 <null> 0 0 0 <null> 2 0 0 0 0 0 0 <null> 0 <null> <null> 09:11:12 09:29:12
writes/marks*100 5 0 0 0 <null> 1 <null> 0 0 1 0 0 0 0 0 0 0 6 0 <null> 09:29:13 09:47:13
writes/marks*100 6 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 3 <null> <null> 09:47:14 10:05:14
writes/marks*100 7 1 0 0 <null> 0 <null> 0 0 0 1 0 0 0 0 0 0 0 0 <null> 10:05:15 10:23:15
writes/marks*100 8 0 0 0 0 0 <null> 0 <null> 0 1 0 0 0 0 1 <null> <null> <null> <null> 10:23:16 10:41:16
writes/marks*100 9 0 0 0 <null> 0 0 0 0 0 1 0 0 0 0 0 0 2 0 <null> 10:41:17 10:59:17
writes/marks*100 10 0 <null> 0 <null> 1 0 0 <null> 1 1 0 0 0 0 0 <null> 7 0 <null> 10:59:18 11:17:18
Done for 9080 ms, from 11:29:55.03 to 11:30:04.11.

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 1861378 1679734 181644 9.75 0 13650 7 181644 2018-07-06 08:17 2018-07-06 11:17
doc_list_biud 1861805 1679734 182071 9.77 0 85395 4 182071 2018-07-06 08:17 2018-07-06 11:17
sp_add_invoice_to_stock 16282 10186 6096 37.44 15 319645 3179 6096 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_adding_invoice 4520 3410 1110 24.55 0 235420 630 1110 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_client_order 5670 5547 123 2.16 0 82914 98 123 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_customer_reserve 395622 223600 172022 43.48 0 85395 16 172022 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_pay_from_customer 2121 2114 7 0.33 0 8799 42 7 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_pay_to_supplier 1349 1345 4 0.29 0 16676 51 4 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_supplier_invoice 10030 7662 2368 23.60 0 37331 123 2368 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_supplier_order 1302 517 785 60.29 0 221427 6318 785 2018-07-06 08:17 2018-07-06 11:17
sp_cancel_write_off 22246 15182 7064 31.75 0 16567 35 7064 2018-07-06 08:17 2018-07-06 11:17
sp_client_order 67561 67561 0 0.00 0 107937 152 0 2018-07-06 08:17 2018-07-06 11:17
sp_customer_reserve 599531 599531 0 0.00 0 90122 45 0 2018-07-06 08:17 2018-07-06 11:17
sp_fill_shopping_cart 102533 102228 305 0.29 0 23432 25 0 2018-07-06 08:17 2018-07-06 11:17
sp_fill_shopping_cart_clo_res 599531 599531 0 0.00 0 80090 5 0 2018-07-06 08:17 2018-07-06 11:17
sp_get_clo_for_invoice 10186 10186 0 0.00 0 37034 106 0 2018-07-06 08:17 2018-07-06 11:17
sp_kill_cost_storno 29893 22051 7842 26.23 0 11076 5 7842 2018-07-06 08:17 2018-07-06 11:17
sp_kill_qstorno_ret_qs2qd 823386 470561 352825 42.85 0 83039 7 352825 2018-07-06 08:17 2018-07-06 11:17
sp_kill_qty_storno 479465 297454 182011 37.96 0 85395 19 182011 2018-07-06 08:17 2018-07-06 11:17
sp_lock_selected_doc 66316 58172 8144 12.28 0 14727 4 8144 2018-07-06 08:17 2018-07-06 11:17
sp_make_cost_storno 82621 82621 0 0.00 0 11779 71 0 2018-07-06 08:17 2018-07-06 11:17
sp_multiply_rows_for_pdistr 82621 82621 0 0.00 0 7957 11 0 2018-07-06 08:17 2018-07-06 11:17
sp_multiply_rows_for_qdistr 67561 67561 0 0.00 0 105004 63 0 2018-07-06 08:17 2018-07-06 11:17
sp_pay_from_customer 22479 22479 0 0.00 0 19750 182 0 2018-07-06 08:17 2018-07-06 11:17
sp_pay_to_supplier 18606 18606 0 0.00 0 19766 109 0 2018-07-06 08:17 2018-07-06 11:17
sp_payment_common 41085 41085 0 0.00 0 9438 19 0 2018-07-06 08:17 2018-07-06 11:17
sp_qd_handle_on_cancel_clo 5666 5547 119 2.10 0 82524 52 119 2018-07-06 08:17 2018-07-06 11:17
sp_qd_handle_on_invoice_upd_sts 14585 13596 989 6.78 0 24290 99 989 2018-07-06 08:17 2018-07-06 11:17
sp_qd_handle_on_reserve_upd_sts 31350 31350 0 0.00 0 10592 15 0 2018-07-06 08:17 2018-07-06 11:17
sp_reserve_write_off 31731 31350 381 1.20 0 21138 123 381 2018-07-06 08:17 2018-07-06 11:17
sp_supplier_invoice 17525 17431 94 0.53 0 72307 771 0 2018-07-06 08:17 2018-07-06 11:17
sp_supplier_order 17447 17236 211 1.20 0 67814 532 0 2018-07-06 08:17 2018-07-06 11:17
srv_find_qd_qs_mism 1147981 966322 181659 15.82 0 13650 4 181659 2018-07-06 08:17 2018-07-06 11:17
srv_make_invnt_saldo 1744 1744 0 0.00 16 155190 972 0 2018-07-06 08:17 2018-07-06 11:17
srv_make_money_saldo 1774 1774 0 0.00 0 1560 20 0 2018-07-06 08:17 2018-07-06 11:17
srv_recalc_idx_stat 13 13 0 0.00 1700 29640 5838 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_add_invoice_to_stock 6096 6096 0 0.00 0 15990 72 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_adding_invoice 679 679 0 0.00 0 546 23 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_client_order 123 123 0 0.00 0 93 8 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_customer_reserve 21 21 0 0.00 0 125 7 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_pay_from_customer 7 7 0 0.00 0 0 0 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 0 16 7 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_supplier_invoice 516 516 0 0.00 0 10186 83 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_supplier_order 20429 20429 0 0.00 0 26177 32 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_cancel_write_off 23 23 0 0.00 0 1107 52 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_reserve_write_off 381 381 0 0.00 0 6427 43 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_supplier_invoice 94 94 0 0.00 0 749 16 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-abend:sp_supplier_order 211 211 0 0.00 0 3682 47 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_add_invoice_to_stock 10186 10186 0 0.00 0 241427 735 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_adding_invoice 1105 1105 0 0.00 0 133958 737 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_client_order 5547 5547 0 0.00 0 17285 46 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_customer_reserve 2131 2131 0 0.00 0 8019 42 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_pay_from_customer 2114 2114 0 0.00 0 7082 38 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_pay_to_supplier 1345 1345 0 0.00 0 22995 63 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_supplier_invoice 776 776 0 0.00 0 22807 64 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_supplier_order 517 517 0 0.00 0 67766 1022 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_cancel_write_off 3101 3101 0 0.00 0 29016 55 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_client_order 67561 67561 0 0.00 0 41028 62 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_customer_reserve 3151 3151 0 0.00 0 10171 37 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_pay_from_customer 22479 22479 0 0.00 0 35802 52 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_pay_to_supplier 18606 18606 0 0.00 0 23680 46 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_reserve_write_off 31350 31350 0 0.00 0 39796 57 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_supplier_invoice 17431 17431 0 0.00 0 40966 66 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:sp_supplier_order 17236 17236 0 0.00 0 23072 59 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:srv_make_invnt_saldo 1744 1744 0 0.00 0 2964 6 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:srv_make_money_saldo 1774 1774 0 0.00 0 2979 20 0 2018-07-06 08:17 2018-07-06 11:17
t$perf-norm:srv_recalc_idx_stat 13 13 0 0.00 0 530 50 0 2018-07-06 08:17 2018-07-06 11:17
v_add_invoice_to_stock 32564 20372 12192 37.44 0 14711 7 12192 2018-07-06 08:17 2018-07-06 11:17
v_all_customers 101410 101410 0 0.00 0 515 1 0 2018-07-06 08:17 2018-07-06 11:17
v_all_suppliers 70088 69478 610 0.87 0 1170 1 0 2018-07-06 08:17 2018-07-06 11:17
v_all_wares 135122 135122 0 0.00 0 328 1 0 2018-07-06 08:17 2018-07-06 11:17
v_cancel_adding_invoice 2586 2210 376 14.53 0 10873 38 376 2018-07-06 08:17 2018-07-06 11:17
v_cancel_client_order 11340 11094 246 2.16 0 11903 7 246 2018-07-06 08:17 2018-07-06 11:17
v_cancel_customer_prepayment 4242 4228 14 0.33 0 8658 5 14 2018-07-06 08:17 2018-07-06 11:17
v_cancel_customer_reserve 4304 4262 42 0.97 0 6973 7 42 2018-07-06 08:17 2018-07-06 11:17
v_cancel_payment_to_supplier 2698 2690 8 0.29 0 14617 8 8 2018-07-06 08:17 2018-07-06 11:17
v_cancel_supplier_invoice 2584 1552 1032 39.93 0 312 5 1032 2018-07-06 08:17 2018-07-06 11:17
v_cancel_supplier_order 2604 1034 1570 60.29 0 3447 7 1570 2018-07-06 08:17 2018-07-06 11:17
v_cancel_write_off 6248 6202 46 0.73 0 14695 26 46 2018-07-06 08:17 2018-07-06 11:17
v_max_id_clo_ord 17447 17236 211 1.20 0 421 1 0 2018-07-06 08:17 2018-07-06 11:17
v_max_id_clo_res 3151 3151 0 0.00 0 8081 12 0 2018-07-06 08:17 2018-07-06 11:17
v_max_id_ord_sup 17525 17431 94 0.53 0 5710 2 0 2018-07-06 08:17 2018-07-06 11:17
v_max_non_paid_invoice 18534 18534 0 0.00 0 1124 1 0 2018-07-06 08:17 2018-07-06 11:17
v_max_non_paid_realizn 22479 22479 0 0.00 0 3760 2 0 2018-07-06 08:17 2018-07-06 11:17
v_min_id_clo_ord 17447 17236 211 1.20 0 5476 3 0 2018-07-06 08:17 2018-07-06 11:17
v_min_id_clo_res 3151 3151 0 0.00 0 66924 52 0 2018-07-06 08:17 2018-07-06 11:17
v_min_id_ord_sup 17525 17431 94 0.53 0 14930 11 0 2018-07-06 08:17 2018-07-06 11:17
v_min_non_paid_invoice 18606 18606 0 0.00 0 4836 2 0 2018-07-06 08:17 2018-07-06 11:17
v_min_non_paid_realizn 22479 22479 0 0.00 0 6771 2 0 2018-07-06 08:17 2018-07-06 11:17
v_our_firm 33712 33712 0 0.00 0 531 1 0 2018-07-06 08:17 2018-07-06 11:17
v_reserve_write_off 63462 62700 762 1.20 0 14664 5 762 2018-07-06 08:17 2018-07-06 11:17
x_lock_depdocs_on_canc_invoice 19957 10296 9661 48.40 0 1887 6 9661 2018-07-06 08:17 2018-07-06 11:17
x_lock_depdocs_on_canc_sup_ord 1302 517 785 60.29 0 6568 32 785 2018-07-06 08:17 2018-07-06 11:17
x_make_qstorno_1000_1200 17447 17236 211 1.20 0 65848 479 0 2018-07-06 08:17 2018-07-06 11:17
x_make_qstorno_1200_2000 17525 17431 94 0.53 0 68765 705 0 2018-07-06 08:17 2018-07-06 11:17
x_make_qstorno_2100_3300 599531 599531 0 0.00 0 85488 37 0 2018-07-06 08:17 2018-07-06 11:17
Done for 367970 ms, from 11:36:02.71 to 11:42:10.68.

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 60 sp_kill_cost_storno 335544336 2018-07-06 08:18 2018-07-06 11:12
deadlock 56 sp_kill_qstorno_ret_qs2qd 335544336 2018-07-06 08:17 2018-07-06 11:16
deadlock 7049 sp_lock_selected_doc 335544336 2018-07-06 08:17 2018-07-06 11:17
deadlock 119 sp_qd_handle_on_cancel_clo 335544336 2018-07-06 08:17 2018-07-06 11:15
deadlock 207 sp_qd_handle_on_invoice_upd_sts 335544336 2018-07-06 08:18 2018-07-06 11:16
deadlock 493 x_lock_depdocs_on_canc_invoice 335544336 2018-07-06 08:17 2018-07-06 11:17
deadlock 153 x_lock_depdocs_on_canc_sup_ord 335544336 2018-07-06 08:23 2018-07-06 11:14
user_exc 211 x_make_qstorno_1000_1200 335544517 2018-07-06 08:17 2018-07-06 11:17
user_exc 94 x_make_qstorno_1200_2000 335544517 2018-07-06 08:17 2018-07-06 11:15
Done for 12590 ms, from 11:42:21.12 to 11:42:33.71.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 388729
MON$OLDEST_ACTIVE 388730
MON$OLDEST_SNAPSHOT 388730
MON$NEXT_TRANSACTION 388730
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 787104
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.1047 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.1047 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.1047 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.1047 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Gstat execution time Fri Jul 06 11:42:34 2018

Database header page information:
Flags 0
Generation 388766
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 388731
Oldest active 388732
Oldest snapshot 388732
Next transaction 388733
Sequence number 0
Next attachment ID 9191
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*


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

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

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

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

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

Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.01, total records: 1902715
Average version length: 47.45, total versions: 1034, 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: 20496
Data pages: 20496, average fill: 73%
Primary pages: 20496, secondary pages: 0, swept pages: 13212
Empty pages: 4, full pages: 19569
Fill distribution:
0 - 19% = 7
20 - 39% = 14
40 - 59% = 58
60 - 79% = 20413
80 - 99% = 4

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9084, nodes: 1902715
Average node length: 19.31, total dup: 0, max dup: 0
Average key length: 16.36, compression ratio: 1.65
Average prefix length: 13.64, average data length: 13.36
Clustering factor: 242910, ratio: 0.13
Fill distribution:
0 - 19% = 793
20 - 39% = 2386
40 - 59% = 3021
60 - 79% = 1108
80 - 99% = 1776

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 6840, nodes: 1902715
Average node length: 11.66, total dup: 0, max dup: 0
Average key length: 8.71, compression ratio: 1.03
Average prefix length: 3.29, average data length: 5.71
Clustering factor: 245944, ratio: 0.13
Fill distribution:
0 - 19% = 2
20 - 39% = 3305
40 - 59% = 3361
60 - 79% = 160
80 - 99% = 12

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 172476, depth: 3, leaf buckets: 3067, nodes: 1902715
Average node length: 6.82, total dup: 1385704, max dup: 49
Average key length: 3.87, compression ratio: 2.33
Average prefix length: 7.40, average data length: 1.60
Clustering factor: 213995, ratio: 0.11
Fill distribution:
0 - 19% = 131
20 - 39% = 968
40 - 59% = 891
60 - 79% = 444
80 - 99% = 633

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.43, total records: 574878
Average version length: 61.11, total versions: 156, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7264
Data pages: 7264, average fill: 75%
Primary pages: 7263, secondary pages: 1, swept pages: 6772
Empty pages: 6, full pages: 7096
Fill distribution:
0 - 19% = 12
20 - 39% = 16
40 - 59% = 30
60 - 79% = 7202
80 - 99% = 4

Index DOC_LIST_ID_DESC (1)
Root page: 250621, depth: 3, leaf buckets: 2082, nodes: 574878
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 104302, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 1067
40 - 59% = 946
60 - 79% = 63
80 - 99% = 6

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 598, nodes: 574878
Average node length: 4.86, total dup: 574828, max dup: 31359
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 259377, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 511
60 - 79% = 67
80 - 99% = 20

Index PK_DOC_LIST (0)
Root page: 355968, depth: 3, leaf buckets: 1352, nodes: 574878
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 104302, ratio: 0.18
Fill distribution:
0 - 19% = 61
20 - 39% = 179
40 - 59% = 372
60 - 79% = 367
80 - 99% = 373

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

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

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

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

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

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

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 62.20, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 14.94, total fragments: 339, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.67
Pointer pages: 1, data page slots: 32
Data pages: 29, average fill: 23%
Primary pages: 4, secondary pages: 25, swept pages: 4
Empty pages: 6, full pages: 3
Fill distribution:
0 - 19% = 20
20 - 39% = 5
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 65.75, total records: 3675
Average version length: 71.16, total versions: 273, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.46
Pointer pages: 1, data page slots: 248
Data pages: 144, average fill: 29%
Primary pages: 144, secondary pages: 0, swept pages: 91
Empty pages: 66, full pages: 40
Fill distribution:
0 - 19% = 81
20 - 39% = 16
40 - 59% = 4
60 - 79% = 40
80 - 99% = 3

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 17, nodes: 3675
Average node length: 14.96, total dup: 178, max dup: 1
Average key length: 12.99, compression ratio: 2.08
Average prefix length: 16.95, average data length: 10.05
Clustering factor: 2396, ratio: 0.65
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 4
60 - 79% = 3
80 - 99% = 0

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

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 45.70, total records: 124
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.40
Pointer pages: 1, data page slots: 16
Data pages: 8, average fill: 15%
Primary pages: 7, secondary pages: 1, swept pages: 7
Empty pages: 1, full pages: 0
Fill distribution:
0 - 19% = 5
20 - 39% = 3
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 275, depth: 1, leaf buckets: 1, nodes: 124
Average node length: 10.43, total dup: 70, max dup: 15
Average key length: 8.69, compression ratio: 2.19
Average prefix length: 12.74, average data length: 6.26
Clustering factor: 77, ratio: 0.62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 17.46, total records: 668670
Average version length: 42.78, total versions: 282, max versions: 5
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.67
Pointer pages: 3, data page slots: 3760
Data pages: 3760, average fill: 75%
Primary pages: 3759, secondary pages: 1, swept pages: 3301
Empty pages: 6, full pages: 3654
Fill distribution:
0 - 19% = 7
20 - 39% = 1
40 - 59% = 4
60 - 79% = 3307
80 - 99% = 441

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 180, nodes: 168697
Average node length: 4.86, total dup: 168648, max dup: 7126
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 23532, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 22
40 - 59% = 112
60 - 79% = 35
80 - 99% = 11

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 192, nodes: 168697
Average node length: 5.79, total dup: 152236, max dup: 30
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 26268, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 74
60 - 79% = 66
80 - 99% = 37

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 197, nodes: 168697
Average node length: 5.79, total dup: 152236, max dup: 30
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 26285, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 79
60 - 79% = 75
80 - 99% = 27

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 197, nodes: 168697
Average node length: 5.58, total dup: 152236, max dup: 30
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 26320, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 90
60 - 79% = 69
80 - 99% = 21

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.92, total records: 224452
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2088
Data pages: 2088, average fill: 59%
Primary pages: 2088, secondary pages: 0, swept pages: 0
Empty pages: 151, full pages: 1915
Fill distribution:
0 - 19% = 172
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1916
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 291394, depth: 2, leaf buckets: 174, nodes: 224452
Average node length: 4.43, total dup: 224271, max dup: 2153
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.55, average data length: 0.00
Clustering factor: 27764, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 53
60 - 79% = 69
80 - 99% = 51

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

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

PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.51, total records: 11458446
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.19
Pointer pages: 167, data page slots: 271888
Data pages: 271888, average fill: 87%
Primary pages: 271888, secondary pages: 0, swept pages: 3
Empty pages: 7, full pages: 271880
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 271880

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 13887, nodes: 11458446
Average node length: 5.65, total dup: 10663248, max dup: 167
Average key length: 2.17, compression ratio: 3.68
Average prefix length: 7.87, average data length: 0.13
Clustering factor: 1716148, ratio: 0.15
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 10012
60 - 79% = 2438
80 - 99% = 1434

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 11402, nodes: 11458446
Average node length: 4.59, total dup: 11458442, max dup: 10142266
Average key length: 1.12, compression ratio: 0.51
Average prefix length: 0.57, average data length: 0.00
Clustering factor: 319976, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11398
60 - 79% = 1
80 - 99% = 3

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 14415, nodes: 11458446
Average node length: 5.69, total dup: 11138987, max dup: 29177
Average key length: 2.21, compression ratio: 4.07
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 602375, ratio: 0.05
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 11869
60 - 79% = 1435
80 - 99% = 1107

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 13607, nodes: 11458446
Average node length: 5.54, total dup: 11438648, max dup: 1836742
Average key length: 2.06, compression ratio: 18.38
Average prefix length: 37.88, average data length: 0.06
Clustering factor: 4867927, ratio: 0.42
Fill distribution:
0 - 19% = 11
20 - 39% = 3
40 - 59% = 11616
60 - 79% = 263
80 - 99% = 1714

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.01, total records: 399542
Average version length: 55.38, total versions: 249, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 3, data page slots: 4720
Data pages: 4720, average fill: 75%
Primary pages: 4720, secondary pages: 0, swept pages: 3570
Empty pages: 2, full pages: 4607
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 3
60 - 79% = 4715
80 - 99% = 0

Index PSTORNED_RCV_ID (2)
Root page: 741223, depth: 3, leaf buckets: 517, nodes: 399542
Average node length: 5.87, total dup: 339136, max dup: 880
Average key length: 3.11, compression ratio: 2.90
Average prefix length: 8.04, average data length: 0.96
Clustering factor: 47474, ratio: 0.12
Fill distribution:
0 - 19% = 4
20 - 39% = 29
40 - 59% = 317
60 - 79% = 118
80 - 99% = 49

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 432, nodes: 399542
Average node length: 5.61, total dup: 354221, max dup: 100
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.26, average data length: 0.74
Clustering factor: 100213, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 193
60 - 79% = 158
80 - 99% = 75

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.26, total records: 2215
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.57
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 63%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 5, full pages: 26
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 26
80 - 99% = 0

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

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

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

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

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

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

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

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

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 38.44, total records: 5729
Average version length: 72.22, total versions: 2679, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.54
Pointer pages: 1, data page slots: 216
Data pages: 159, average fill: 44%
Primary pages: 157, secondary pages: 2, swept pages: 74
Empty pages: 21, full pages: 51
Fill distribution:
0 - 19% = 54
20 - 39% = 21
40 - 59% = 15
60 - 79% = 46
80 - 99% = 23

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 12, nodes: 5729
Average node length: 6.78, total dup: 4944, max dup: 14
Average key length: 4.83, compression ratio: 7.65
Average prefix length: 34.30, average data length: 2.70
Clustering factor: 916, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 8
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.98, total records: 580386
Average version length: 71.82, total versions: 1588, 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: 8976
Data pages: 8952, average fill: 71%
Primary pages: 8952, secondary pages: 0, swept pages: 5909
Empty pages: 128, full pages: 6679
Fill distribution:
0 - 19% = 201
20 - 39% = 234
40 - 59% = 589
60 - 79% = 7918
80 - 99% = 10

Index XQD_1000_3300_DOC (1)
Root page: 678612, depth: 3, leaf buckets: 523, nodes: 580386
Average node length: 5.07, total dup: 564083, max dup: 116
Average key length: 2.20, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 65177, ratio: 0.11
Fill distribution:
0 - 19% = 6
20 - 39% = 49
40 - 59% = 201
60 - 79% = 33
80 - 99% = 234

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 261241, depth: 3, leaf buckets: 798, nodes: 580386
Average node length: 6.19, total dup: 506785, max dup: 14
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 115694, ratio: 0.20
Fill distribution:
0 - 19% = 25
20 - 39% = 159
40 - 59% = 321
60 - 79% = 142
80 - 99% = 151

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 15.02, total records: 87758
Average version length: 72.25, total versions: 5173, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 9.05
Pointer pages: 1, data page slots: 1496
Data pages: 1432, average fill: 30%
Primary pages: 1431, secondary pages: 1, swept pages: 1021
Empty pages: 119, full pages: 171
Fill distribution:
0 - 19% = 715
20 - 39% = 259
40 - 59% = 187
60 - 79% = 195
80 - 99% = 76

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 27, nodes: 14317
Average node length: 5.95, total dup: 12571, max dup: 49
Average key length: 3.90, compression ratio: 9.49
Average prefix length: 35.22, average data length: 1.78
Clustering factor: 1826, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 11
60 - 79% = 2
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 46.58, total records: 2106186
Average version length: 70.95, total versions: 13184, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.92
Pointer pages: 17, data page slots: 26128
Data pages: 25984, average fill: 64%
Primary pages: 25984, secondary pages: 0, swept pages: 7645
Empty pages: 275, full pages: 24834
Fill distribution:
0 - 19% = 408
20 - 39% = 5891
40 - 59% = 1404
60 - 79% = 15381
80 - 99% = 2900

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 192496, depth: 3, leaf buckets: 1870, nodes: 1267590
Average node length: 5.54, total dup: 1200332, max dup: 49
Average key length: 2.59, compression ratio: 14.31
Average prefix length: 36.47, average data length: 0.53
Clustering factor: 97809, ratio: 0.08
Fill distribution:
0 - 19% = 19
20 - 39% = 740
40 - 59% = 775
60 - 79% = 169
80 - 99% = 167

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.02, total records: 3842779
Average version length: 70.34, total versions: 64, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.08
Pointer pages: 16, data page slots: 24528
Data pages: 24480, average fill: 50%
Primary pages: 24480, secondary pages: 0, swept pages: 8707
Empty pages: 50, full pages: 24248
Fill distribution:
0 - 19% = 120
20 - 39% = 8829
40 - 59% = 5254
60 - 79% = 10123
80 - 99% = 154

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 6, nodes: 1382
Average node length: 11.18, total dup: 965, max dup: 20
Average key length: 8.17, compression ratio: 4.53
Average prefix length: 31.12, average data length: 5.88
Clustering factor: 259, ratio: 0.19
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.29, total records: 3004863
Average version length: 71.36, total versions: 4960, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.18
Pointer pages: 24, data page slots: 38320
Data pages: 38320, average fill: 76%
Primary pages: 38320, secondary pages: 0, swept pages: 27229
Empty pages: 49, full pages: 37055
Fill distribution:
0 - 19% = 81
20 - 39% = 333
40 - 59% = 931
60 - 79% = 34562
80 - 99% = 2413

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5355, nodes: 2573372
Average node length: 6.84, total dup: 2091381, max dup: 14
Average key length: 3.86, compression ratio: 9.58
Average prefix length: 35.32, average data length: 1.68
Clustering factor: 373187, ratio: 0.15
Fill distribution:
0 - 19% = 4
20 - 39% = 2982
40 - 59% = 1941
60 - 79% = 247
80 - 99% = 181

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.35, total records: 4125773
Average version length: 83.22, total versions: 236, 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: 63232
Data pages: 63232, average fill: 80%
Primary pages: 63232, secondary pages: 0, swept pages: 22825
Empty pages: 6, full pages: 63015
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 15
60 - 79% = 18556
80 - 99% = 44652

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4296, nodes: 4125773
Average node length: 5.15, total dup: 4032024, max dup: 125
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 608099, ratio: 0.15
Fill distribution:
0 - 19% = 16
20 - 39% = 59
40 - 59% = 2036
60 - 79% = 1814
80 - 99% = 371

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 3565, nodes: 4125773
Average node length: 5.71, total dup: 3684961, max dup: 49
Average key length: 2.73, compression ratio: 3.30
Average prefix length: 8.38, average data length: 0.62
Clustering factor: 112182, ratio: 0.03
Fill distribution:
0 - 19% = 15
20 - 39% = 54
40 - 59% = 760
60 - 79% = 205
80 - 99% = 2531

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 4790, nodes: 4125773
Average node length: 5.81, total dup: 3610132, max dup: 14
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 658620, ratio: 0.16
Fill distribution:
0 - 19% = 35
20 - 39% = 68
40 - 59% = 2185
60 - 79% = 1968
80 - 99% = 534

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.20, total records: 2519990
Average version length: 83.67, total versions: 4690, 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: 24, data page slots: 39000
Data pages: 39000, average fill: 80%
Primary pages: 39000, secondary pages: 0, swept pages: 28588
Empty pages: 26, full pages: 38397
Fill distribution:
0 - 19% = 41
20 - 39% = 36
40 - 59% = 129
60 - 79% = 12997
80 - 99% = 25797

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2670, nodes: 2519990
Average node length: 5.15, total dup: 2461081, max dup: 174
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 380894, ratio: 0.15
Fill distribution:
0 - 19% = 2
20 - 39% = 39
40 - 59% = 1545
60 - 79% = 782
80 - 99% = 302

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 3792, nodes: 2519990
Average node length: 6.23, total dup: 2064485, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 174689, ratio: 0.07
Fill distribution:
0 - 19% = 88
20 - 39% = 1214
40 - 59% = 1322
60 - 79% = 663
80 - 99% = 505

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3021, nodes: 2519990
Average node length: 5.81, total dup: 2204041, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 466300, ratio: 0.19
Fill distribution:
0 - 19% = 20
20 - 39% = 38
40 - 59% = 1757
60 - 79% = 847
80 - 99% = 359

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.50, total records: 4357039
Average version length: 84.16, total versions: 2462, 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: 42, data page slots: 67080
Data pages: 66976, average fill: 80%
Primary pages: 66976, secondary pages: 0, swept pages: 14478
Empty pages: 325, full pages: 65899
Fill distribution:
0 - 19% = 381
20 - 39% = 160
40 - 59% = 307
60 - 79% = 9635
80 - 99% = 56493

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 4423, nodes: 4357039
Average node length: 5.04, total dup: 4331548, max dup: 784
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 603412, ratio: 0.14
Fill distribution:
0 - 19% = 8
20 - 39% = 113
40 - 59% = 2337
60 - 79% = 1382
80 - 99% = 583

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 4654, nodes: 4357039
Average node length: 5.52, total dup: 4018249, max dup: 49
Average key length: 2.53, compression ratio: 3.55
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 111320, ratio: 0.03
Fill distribution:
0 - 19% = 90
20 - 39% = 933
40 - 59% = 1389
60 - 79% = 621
80 - 99% = 1621

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 4975, nodes: 4357039
Average node length: 5.70, total dup: 3899610, max dup: 72
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 674670, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 82
40 - 59% = 2662
60 - 79% = 1545
80 - 99% = 681

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.24, total records: 3104343
Average version length: 84.19, total versions: 5490, 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: 30, data page slots: 47888
Data pages: 47888, average fill: 80%
Primary pages: 47888, secondary pages: 0, swept pages: 33467
Empty pages: 42, full pages: 47263
Fill distribution:
0 - 19% = 69
20 - 39% = 46
40 - 59% = 170
60 - 79% = 12746
80 - 99% = 34857

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3355, nodes: 3104343
Average node length: 5.02, total dup: 3089293, max dup: 1246
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 554619, ratio: 0.18
Fill distribution:
0 - 19% = 20
20 - 39% = 323
40 - 59% = 1816
60 - 79% = 806
80 - 99% = 390

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 4635, nodes: 3104343
Average node length: 6.23, total dup: 2544477, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 225738, ratio: 0.07
Fill distribution:
0 - 19% = 106
20 - 39% = 1487
40 - 59% = 1592
60 - 79% = 766
80 - 99% = 684

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3734, nodes: 3104343
Average node length: 5.59, total dup: 2831640, max dup: 58
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 599959, ratio: 0.19
Fill distribution:
0 - 19% = 22
20 - 39% = 341
40 - 59% = 2021
60 - 79% = 912
80 - 99% = 438

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.39, total records: 530652
Average version length: 68.94, total versions: 211, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 5, data page slots: 7256
Data pages: 7256, average fill: 77%
Primary pages: 7256, secondary pages: 0, swept pages: 5256
Empty pages: 1, full pages: 7187
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 5
60 - 79% = 7234
80 - 99% = 11

Index XQS_3300_3400_DOC_ID (0)
Root page: 230615, depth: 3, leaf buckets: 638, nodes: 530652
Average node length: 5.30, total dup: 499053, max dup: 117
Average key length: 2.45, compression ratio: 3.67
Average prefix length: 8.60, average data length: 0.40
Clustering factor: 46017, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 148
40 - 59% = 260
60 - 79% = 153
80 - 99% = 76

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 732, nodes: 530652
Average node length: 5.91, total dup: 452833, max dup: 14
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 47977, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 175
40 - 59% = 332
60 - 79% = 157
80 - 99% = 66

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Gstat completion time Fri Jul 06 11:43:52 2018

Done for 77740 ms, from 11:42:34.36 to 11:43:52.10.

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 1902715 1034 0.0543
DOC_LIST 574878 156 0.0271
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 3675 273 7.4285
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 124 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 668670 282 0.0421
PERF_ESTIMATED 224452 0 0.0000
PERF_LOG 11458446 0 0.0000
PSTORNED 399542 249 0.0623
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 2215 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 5729 2679 46.7620
XQD_1000_3300 580386 1588 0.2736
XQD_1200_2000 87758 5173 5.8946
XQD_2000_3300 2106186 13184 0.6259
XQD_2100_3300 3842779 64 0.0016
XQD_3300_3400 3004863 4960 0.1650
XQS_1000_1200 4125773 236 0.0057
XQS_1000_3300 2519990 4690 0.1861
XQS_1200_2000 4357039 2462 0.0565
XQS_2100_3300 3104343 5490 0.1768
XQS_3300_3400 530652 211 0.0397
Z_USED_VIEWS 29 0 0.0000
Done for 2420 ms, from 11:44:02.49 to 11:44:04.91.

Database validation

11:44:05.06 Validation started

11:44:05.08 Relation 140 (DOC_LIST)
11:44:05.08 process pointer page 0 of 5
11:44:05.17 process pointer page 1 of 5
11:44:05.26 process pointer page 2 of 5
11:44:05.36 process pointer page 3 of 5
11:44:05.45 process pointer page 4 of 5
11:44:05.50 Index 1 (PK_DOC_LIST)
11:44:05.70 Index 2 (DOC_LIST_ID_DESC)
11:44:05.93 Index 3 (FK_DOC_LIST_AGENTS)
11:44:06.15 Relation 140 (DOC_LIST) is ok

11:44:06.15 Relation 141 (DOC_DATA)
11:44:06.15 process pointer page 0 of 13
11:44:06.25 process pointer page 1 of 13
11:44:06.34 process pointer page 2 of 13
11:44:06.43 process pointer page 3 of 13
11:44:06.53 process pointer page 4 of 13
11:44:06.62 process pointer page 5 of 13
11:44:06.71 process pointer page 6 of 13
11:44:06.81 process pointer page 7 of 13
11:44:06.90 process pointer page 8 of 13
11:44:06.95 process pointer page 9 of 13
11:44:07.00 process pointer page 10 of 13
11:44:07.03 process pointer page 11 of 13
11:44:07.07 process pointer page 12 of 13
11:44:07.09 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:44:07.42 Index 3 (DOC_DATA_ID_DESC)
11:44:07.67 Index 4 (FK_DOC_DATA_DOC_LIST)
11:44:07.82 Relation 141 (DOC_DATA) is ok

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

11:44:07.82 Relation 150 (PDISTR)
11:44:07.82 process pointer page 0 of 3
11:44:07.84 process pointer page 1 of 3
11:44:07.87 process pointer page 2 of 3
11:44:07.87 Index 2 (PDISTR_SND_ID)
11:44:07.90 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:44:07.92 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:44:07.93 Index 5 (PDISTR_AGENT_ID)
11:44:07.95 Relation 150 (PDISTR) is ok

11:44:07.95 Relation 151 (PSTORNED)
11:44:07.95 process pointer page 0 of 3
11:44:07.98 process pointer page 1 of 3
11:44:08.07 process pointer page 2 of 3
11:44:08.15 Index 2 (PSTORNED_SND_ID)
11:44:08.29 Index 3 (PSTORNED_RCV_ID)
11:44:08.40 Relation 151 (PSTORNED) is ok

11:44:08.40 Relation 156 (SEMAPHORES)
11:44:08.42 process pointer page 0 of 1
11:44:08.42 Index 1 (PK_SEMAPHORES)
11:44:08.42 Index 2 (SEMAPHORES_TASK_UNQ)
11:44:08.42 Relation 156 (SEMAPHORES) is ok

11:44:08.42 Relation 157 (INVNT_TURNOVER_LOG)
11:44:08.42 process pointer page 0 of 1
11:44:08.42 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:44:08.42 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:44:08.42 Relation 160 (PERF_ESTIMATED)
11:44:08.42 process pointer page 0 of 2
11:44:08.51 process pointer page 1 of 2
11:44:08.52 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:44:08.59 Relation 160 (PERF_ESTIMATED) is ok

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

11:44:08.59 Relation 162 (TRACE_STAT)
11:44:08.59 process pointer page 0 of 1
11:44:08.59 Relation 162 (TRACE_STAT) is ok

11:44:08.59 Relation 163 (PERF_LOG)
11:44:08.59 process pointer page 0 of 167
11:44:08.66 process pointer page 1 of 167
11:44:08.76 process pointer page 2 of 167
11:44:08.84 process pointer page 3 of 167
11:44:08.91 process pointer page 4 of 167
11:44:09.02 process pointer page 5 of 167
11:44:09.12 process pointer page 6 of 167
11:44:09.20 process pointer page 7 of 167
11:44:09.27 process pointer page 8 of 167
11:44:09.35 process pointer page 9 of 167
11:44:09.44 process pointer page 10 of 167
11:44:09.52 process pointer page 11 of 167
11:44:09.60 process pointer page 12 of 167
11:44:09.68 process pointer page 13 of 167
11:44:09.77 process pointer page 14 of 167
11:44:09.85 process pointer page 15 of 167
11:44:09.93 process pointer page 16 of 167
11:44:10.02 process pointer page 17 of 167
11:44:10.10 process pointer page 18 of 167
11:44:10.18 process pointer page 19 of 167
11:44:10.26 process pointer page 20 of 167
11:44:10.35 process pointer page 21 of 167
11:44:10.43 process pointer page 22 of 167
11:44:10.51 process pointer page 23 of 167
11:44:10.58 process pointer page 24 of 167
11:44:10.66 process pointer page 25 of 167
11:44:10.74 process pointer page 26 of 167
11:44:10.82 process pointer page 27 of 167
11:44:10.90 process pointer page 28 of 167
11:44:10.97 process pointer page 29 of 167
11:44:11.05 process pointer page 30 of 167
11:44:11.13 process pointer page 31 of 167
11:44:11.22 process pointer page 32 of 167
11:44:11.30 process pointer page 33 of 167
11:44:11.38 process pointer page 34 of 167
11:44:11.46 process pointer page 35 of 167
11:44:11.54 process pointer page 36 of 167
11:44:11.61 process pointer page 37 of 167
11:44:11.69 process pointer page 38 of 167
11:44:11.77 process pointer page 39 of 167
11:44:11.85 process pointer page 40 of 167
11:44:11.93 process pointer page 41 of 167
11:44:12.00 process pointer page 42 of 167
11:44:12.08 process pointer page 43 of 167
11:44:12.16 process pointer page 44 of 167
11:44:12.25 process pointer page 45 of 167
11:44:12.33 process pointer page 46 of 167
11:44:12.41 process pointer page 47 of 167
11:44:12.49 process pointer page 48 of 167
11:44:12.56 process pointer page 49 of 167
11:44:12.64 process pointer page 50 of 167
11:44:12.72 process pointer page 51 of 167
11:44:12.80 process pointer page 52 of 167
11:44:12.88 process pointer page 53 of 167
11:44:12.97 process pointer page 54 of 167
11:44:13.05 process pointer page 55 of 167
11:44:13.10 process pointer page 56 of 167
11:44:13.13 process pointer page 57 of 167
11:44:13.16 process pointer page 58 of 167
11:44:13.19 process pointer page 59 of 167
11:44:13.22 process pointer page 60 of 167
11:44:13.25 process pointer page 61 of 167
11:44:13.28 process pointer page 62 of 167
11:44:13.31 process pointer page 63 of 167
11:44:13.33 process pointer page 64 of 167
11:44:13.36 process pointer page 65 of 167
11:44:13.39 process pointer page 66 of 167
11:44:13.42 process pointer page 67 of 167
11:44:13.44 process pointer page 68 of 167
11:44:13.47 process pointer page 69 of 167
11:44:13.49 process pointer page 70 of 167
11:44:13.52 process pointer page 71 of 167
11:44:13.53 process pointer page 72 of 167
11:44:13.56 process pointer page 73 of 167
11:44:13.64 process pointer page 74 of 167
11:44:13.72 process pointer page 75 of 167
11:44:13.80 process pointer page 76 of 167
11:44:13.88 process pointer page 77 of 167
11:44:13.95 process pointer page 78 of 167
11:44:14.03 process pointer page 79 of 167
11:44:14.11 process pointer page 80 of 167
11:44:14.19 process pointer page 81 of 167
11:44:14.27 process pointer page 82 of 167
11:44:14.34 process pointer page 83 of 167
11:44:14.44 process pointer page 84 of 167
11:44:14.51 process pointer page 85 of 167
11:44:14.59 process pointer page 86 of 167
11:44:14.67 process pointer page 87 of 167
11:44:14.75 process pointer page 88 of 167
11:44:14.83 process pointer page 89 of 167
11:44:14.90 process pointer page 90 of 167
11:44:14.98 process pointer page 91 of 167
11:44:15.06 process pointer page 92 of 167
11:44:15.15 process pointer page 93 of 167
11:44:15.23 process pointer page 94 of 167
11:44:15.31 process pointer page 95 of 167
11:44:15.39 process pointer page 96 of 167
11:44:15.47 process pointer page 97 of 167
11:44:15.54 process pointer page 98 of 167
11:44:15.62 process pointer page 99 of 167
11:44:15.70 process pointer page 100 of 167
11:44:15.78 process pointer page 101 of 167
11:44:15.86 process pointer page 102 of 167
11:44:15.93 process pointer page 103 of 167
11:44:16.01 process pointer page 104 of 167
11:44:16.09 process pointer page 105 of 167
11:44:16.18 process pointer page 106 of 167
11:44:16.26 process pointer page 107 of 167
11:44:16.34 process pointer page 108 of 167
11:44:16.42 process pointer page 109 of 167
11:44:16.50 process pointer page 110 of 167
11:44:16.57 process pointer page 111 of 167
11:44:16.65 process pointer page 112 of 167
11:44:16.73 process pointer page 113 of 167
11:44:16.81 process pointer page 114 of 167
11:44:16.89 process pointer page 115 of 167
11:44:16.98 process pointer page 116 of 167
11:44:17.06 process pointer page 117 of 167
11:44:17.14 process pointer page 118 of 167
11:44:17.21 process pointer page 119 of 167
11:44:17.29 process pointer page 120 of 167
11:44:17.37 process pointer page 121 of 167
11:44:17.45 process pointer page 122 of 167
11:44:17.54 process pointer page 123 of 167
11:44:17.62 process pointer page 124 of 167
11:44:17.70 process pointer page 125 of 167
11:44:17.78 process pointer page 126 of 167
11:44:17.85 process pointer page 127 of 167
11:44:17.93 process pointer page 128 of 167
11:44:17.96 process pointer page 129 of 167
11:44:18.02 process pointer page 130 of 167
11:44:18.06 process pointer page 131 of 167
11:44:18.13 process pointer page 132 of 167
11:44:18.21 process pointer page 133 of 167
11:44:18.29 process pointer page 134 of 167
11:44:18.37 process pointer page 135 of 167
11:44:18.45 process pointer page 136 of 167
11:44:18.52 process pointer page 137 of 167
11:44:18.62 process pointer page 138 of 167
11:44:18.65 process pointer page 139 of 167
11:44:18.68 process pointer page 140 of 167
11:44:18.71 process pointer page 141 of 167
11:44:18.76 process pointer page 142 of 167
11:44:18.77 process pointer page 143 of 167
11:44:18.80 process pointer page 144 of 167
11:44:18.84 process pointer page 145 of 167
11:44:18.87 process pointer page 146 of 167
11:44:18.90 process pointer page 147 of 167
11:44:18.93 process pointer page 148 of 167
11:44:18.95 process pointer page 149 of 167
11:44:18.99 process pointer page 150 of 167
11:44:19.01 process pointer page 151 of 167
11:44:19.04 process pointer page 152 of 167
11:44:19.07 process pointer page 153 of 167
11:44:19.09 process pointer page 154 of 167
11:44:19.12 process pointer page 155 of 167
11:44:19.13 process pointer page 156 of 167
11:44:19.16 process pointer page 157 of 167
11:44:19.18 process pointer page 158 of 167
11:44:19.19 process pointer page 159 of 167
11:44:19.24 process pointer page 160 of 167
11:44:19.32 process pointer page 161 of 167
11:44:19.40 process pointer page 162 of 167
11:44:19.48 process pointer page 163 of 167
11:44:19.55 process pointer page 164 of 167
11:44:19.63 process pointer page 165 of 167
11:44:19.71 process pointer page 166 of 167
11:44:19.76 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:44:23.20 Index 2 (PERF_LOG_UNIT)
11:44:27.28 Index 3 (PERF_LOG_TRN_DESC)
11:44:29.90 Index 4 (PERF_LOG_GDSCODE)
11:44:30.96 Relation 163 (PERF_LOG) is ok

11:44:30.96 Relation 167 (V_STOPTEST)
11:44:30.96 Relation 167 (V_STOPTEST) is ok

11:44:30.96 Relation 184 (V_QDISTR_SOURCE)
11:44:30.96 Relation 184 (V_QDISTR_SOURCE) is ok

11:44:30.96 Relation 185 (V_QSTORNED_SOURCE)
11:44:30.96 Relation 185 (V_QSTORNED_SOURCE) is ok

11:44:30.96 Relation 260 (XQD_1000_1200)
11:44:30.96 process pointer page 0 of 1
11:44:30.97 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:44:30.97 Relation 260 (XQD_1000_1200) is ok

11:44:30.97 Relation 261 (XQD_1200_2000)
11:44:30.97 process pointer page 0 of 1
11:44:31.04 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:44:31.05 Relation 261 (XQD_1200_2000) is ok

11:44:31.05 Relation 262 (XQD_1000_3300)
11:44:31.05 process pointer page 0 of 6
11:44:31.13 process pointer page 1 of 6
11:44:31.22 process pointer page 2 of 6
11:44:31.32 process pointer page 3 of 6
11:44:31.39 process pointer page 4 of 6
11:44:31.49 process pointer page 5 of 6
11:44:31.52 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:44:31.72 Index 2 (XQD_1000_3300_DOC)
11:44:31.89 Relation 262 (XQD_1000_3300) is ok

11:44:31.89 Relation 263 (XQD_2000_3300)
11:44:31.89 process pointer page 0 of 17
11:44:31.97 process pointer page 1 of 17
11:44:32.07 process pointer page 2 of 17
11:44:32.14 process pointer page 3 of 17
11:44:32.22 process pointer page 4 of 17
11:44:32.30 process pointer page 5 of 17
11:44:32.38 process pointer page 6 of 17
11:44:32.46 process pointer page 7 of 17
11:44:32.55 process pointer page 8 of 17
11:44:32.63 process pointer page 9 of 17
11:44:32.70 process pointer page 10 of 17
11:44:32.78 process pointer page 11 of 17
11:44:32.88 process pointer page 12 of 17
11:44:32.95 process pointer page 13 of 17
11:44:33.03 process pointer page 14 of 17
11:44:33.11 process pointer page 15 of 17
11:44:33.20 process pointer page 16 of 17
11:44:33.20 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:44:33.59 Relation 263 (XQD_2000_3300) is ok

11:44:33.59 Relation 264 (XQD_2100_3300)
11:44:33.59 process pointer page 0 of 16
11:44:33.66 process pointer page 1 of 16
11:44:33.73 process pointer page 2 of 16
11:44:33.80 process pointer page 3 of 16
11:44:33.86 process pointer page 4 of 16
11:44:33.94 process pointer page 5 of 16
11:44:34.00 process pointer page 6 of 16
11:44:34.06 process pointer page 7 of 16
11:44:34.12 process pointer page 8 of 16
11:44:34.19 process pointer page 9 of 16
11:44:34.26 process pointer page 10 of 16
11:44:34.33 process pointer page 11 of 16
11:44:34.39 process pointer page 12 of 16
11:44:34.45 process pointer page 13 of 16
11:44:34.51 process pointer page 14 of 16
11:44:34.58 process pointer page 15 of 16
11:44:34.59 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:44:34.59 Relation 264 (XQD_2100_3300) is ok

11:44:34.59 Relation 265 (XQD_3300_3400)
11:44:34.59 process pointer page 0 of 24
11:44:34.67 process pointer page 1 of 24
11:44:34.76 process pointer page 2 of 24
11:44:34.86 process pointer page 3 of 24
11:44:34.95 process pointer page 4 of 24
11:44:35.03 process pointer page 5 of 24
11:44:35.12 process pointer page 6 of 24
11:44:35.22 process pointer page 7 of 24
11:44:35.31 process pointer page 8 of 24
11:44:35.39 process pointer page 9 of 24
11:44:35.48 process pointer page 10 of 24
11:44:35.54 process pointer page 11 of 24
11:44:35.58 process pointer page 12 of 24
11:44:35.62 process pointer page 13 of 24
11:44:35.65 process pointer page 14 of 24
11:44:35.68 process pointer page 15 of 24
11:44:35.72 process pointer page 16 of 24
11:44:35.75 process pointer page 17 of 24
11:44:35.78 process pointer page 18 of 24
11:44:35.81 process pointer page 19 of 24
11:44:35.84 process pointer page 20 of 24
11:44:35.87 process pointer page 21 of 24
11:44:35.89 process pointer page 22 of 24
11:44:35.92 process pointer page 23 of 24
11:44:35.93 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:44:36.39 Relation 265 (XQD_3300_3400) is ok

11:44:36.39 Relation 266 (XQS_1000_1200)
11:44:36.40 process pointer page 0 of 39
11:44:36.48 process pointer page 1 of 39
11:44:36.57 process pointer page 2 of 39
11:44:36.67 process pointer page 3 of 39
11:44:36.75 process pointer page 4 of 39
11:44:36.84 process pointer page 5 of 39
11:44:36.93 process pointer page 6 of 39
11:44:37.03 process pointer page 7 of 39
11:44:37.10 process pointer page 8 of 39
11:44:37.20 process pointer page 9 of 39
11:44:37.29 process pointer page 10 of 39
11:44:37.38 process pointer page 11 of 39
11:44:37.46 process pointer page 12 of 39
11:44:37.56 process pointer page 13 of 39
11:44:37.65 process pointer page 14 of 39
11:44:37.74 process pointer page 15 of 39
11:44:37.82 process pointer page 16 of 39
11:44:37.92 process pointer page 17 of 39
11:44:38.01 process pointer page 18 of 39
11:44:38.10 process pointer page 19 of 39
11:44:38.20 process pointer page 20 of 39
11:44:38.27 process pointer page 21 of 39
11:44:38.37 process pointer page 22 of 39
11:44:38.46 process pointer page 23 of 39
11:44:38.55 process pointer page 24 of 39
11:44:38.65 process pointer page 25 of 39
11:44:38.74 process pointer page 26 of 39
11:44:38.85 process pointer page 27 of 39
11:44:38.96 process pointer page 28 of 39
11:44:39.05 process pointer page 29 of 39
11:44:39.16 process pointer page 30 of 39
11:44:39.26 process pointer page 31 of 39
11:44:39.37 process pointer page 32 of 39
11:44:39.48 process pointer page 33 of 39
11:44:39.57 process pointer page 34 of 39
11:44:39.68 process pointer page 35 of 39
11:44:39.79 process pointer page 36 of 39
11:44:39.88 process pointer page 37 of 39
11:44:39.99 process pointer page 38 of 39
11:44:40.07 Index 1 (XQS_1000_1200_DOC_ID)
11:44:41.02 Index 2 (XQS_1000_1200_SND_ID)
11:44:41.49 Index 3 (XQS_1000_1200_RCV_ID)
11:44:41.78 Relation 266 (XQS_1000_1200) is ok

11:44:41.78 Relation 267 (XQS_1200_2000)
11:44:41.78 process pointer page 0 of 42
11:44:41.88 process pointer page 1 of 42
11:44:41.97 process pointer page 2 of 42
11:44:42.08 process pointer page 3 of 42
11:44:42.17 process pointer page 4 of 42
11:44:42.28 process pointer page 5 of 42
11:44:42.38 process pointer page 6 of 42
11:44:42.49 process pointer page 7 of 42
11:44:42.60 process pointer page 8 of 42
11:44:42.69 process pointer page 9 of 42
11:44:42.80 process pointer page 10 of 42
11:44:42.89 process pointer page 11 of 42
11:44:43.00 process pointer page 12 of 42
11:44:43.11 process pointer page 13 of 42
11:44:43.22 process pointer page 14 of 42
11:44:43.31 process pointer page 15 of 42
11:44:43.42 process pointer page 16 of 42
11:44:43.52 process pointer page 17 of 42
11:44:43.62 process pointer page 18 of 42
11:44:43.73 process pointer page 19 of 42
11:44:43.83 process pointer page 20 of 42
11:44:43.94 process pointer page 21 of 42
11:44:44.03 process pointer page 22 of 42
11:44:44.14 process pointer page 23 of 42
11:44:44.23 process pointer page 24 of 42
11:44:44.34 process pointer page 25 of 42
11:44:44.44 process pointer page 26 of 42
11:44:44.55 process pointer page 27 of 42
11:44:44.64 process pointer page 28 of 42
11:44:44.75 process pointer page 29 of 42
11:44:44.84 process pointer page 30 of 42
11:44:44.95 process pointer page 31 of 42
11:44:45.04 process pointer page 32 of 42
11:44:45.15 process pointer page 33 of 42
11:44:45.25 process pointer page 34 of 42
11:44:45.34 process pointer page 35 of 42
11:44:45.45 process pointer page 36 of 42
11:44:45.54 process pointer page 37 of 42
11:44:45.65 process pointer page 38 of 42
11:44:45.75 process pointer page 39 of 42
11:44:45.86 process pointer page 40 of 42
11:44:45.95 process pointer page 41 of 42
11:44:45.96 Index 1 (XQS_1200_2000_DOC_ID)
11:44:47.06 Index 2 (XQS_1200_2000_SND_ID)
11:44:47.88 Index 3 (XQS_1200_2000_RCV_ID)
11:44:48.96 Relation 267 (XQS_1200_2000) is ok

11:44:48.96 Relation 268 (XQS_1000_3300)
11:44:48.96 process pointer page 0 of 24
11:44:49.07 process pointer page 1 of 24
11:44:49.16 process pointer page 2 of 24
11:44:49.27 process pointer page 3 of 24
11:44:49.38 process pointer page 4 of 24
11:44:49.47 process pointer page 5 of 24
11:44:49.58 process pointer page 6 of 24
11:44:49.68 process pointer page 7 of 24
11:44:49.79 process pointer page 8 of 24
11:44:49.90 process pointer page 9 of 24
11:44:49.99 process pointer page 10 of 24
11:44:50.10 process pointer page 11 of 24
11:44:50.19 process pointer page 12 of 24
11:44:50.30 process pointer page 13 of 24
11:44:50.50 process pointer page 14 of 24
11:44:50.75 process pointer page 15 of 24
11:44:51.02 process pointer page 16 of 24
11:44:51.30 process pointer page 17 of 24
11:44:51.57 process pointer page 18 of 24
11:44:51.86 process pointer page 19 of 24
11:44:52.17 process pointer page 20 of 24
11:44:52.50 process pointer page 21 of 24
11:44:52.86 process pointer page 22 of 24
11:44:53.16 process pointer page 23 of 24
11:44:53.47 Index 1 (XQS_1000_3300_DOC_ID)
11:44:55.00 Index 2 (XQS_1000_3300_SND_ID)
11:44:56.67 Index 3 (XQS_1000_3300_RCV_ID)
11:44:58.20 Relation 268 (XQS_1000_3300) is ok

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

11:44:58.20 Relation 270 (XQS_2100_3300)
11:44:58.20 process pointer page 0 of 30
11:44:58.51 process pointer page 1 of 30
11:44:58.93 process pointer page 2 of 30
11:44:59.43 process pointer page 3 of 30
11:44:59.91 process pointer page 4 of 30
11:45:00.41 process pointer page 5 of 30
11:45:00.89 process pointer page 6 of 30
11:45:01.39 process pointer page 7 of 30
11:45:01.88 process pointer page 8 of 30
11:45:02.38 process pointer page 9 of 30
11:45:03.64 process pointer page 10 of 30
11:45:04.03 process pointer page 11 of 30
11:45:04.39 process pointer page 12 of 30
11:45:04.87 process pointer page 13 of 30
11:45:05.39 process pointer page 14 of 30
11:45:05.87 process pointer page 15 of 30
11:45:06.37 process pointer page 16 of 30
11:45:06.85 process pointer page 17 of 30
11:45:07.29 process pointer page 18 of 30
11:45:07.73 process pointer page 19 of 30
11:45:08.19 process pointer page 20 of 30
11:45:08.68 process pointer page 21 of 30
11:45:09.13 process pointer page 22 of 30
11:45:09.54 process pointer page 23 of 30
11:45:09.83 process pointer page 24 of 30
11:45:10.22 process pointer page 25 of 30
11:45:10.69 process pointer page 26 of 30
11:45:11.17 process pointer page 27 of 30
11:45:11.63 process pointer page 28 of 30
11:45:11.94 process pointer page 29 of 30
11:45:12.03 Index 1 (XQS_2100_3300_DOC_ID)
11:45:13.95 Index 2 (XQS_2100_3300_SND_ID)
11:45:15.40 Index 3 (XQS_2100_3300_RCV_ID)
11:45:18.04 Relation 270 (XQS_2100_3300) is ok

11:45:18.04 Relation 271 (XQS_3300_3400)
11:45:18.04 process pointer page 0 of 5
11:45:18.55 process pointer page 1 of 5
11:45:19.05 process pointer page 2 of 5
11:45:19.55 process pointer page 3 of 5
11:45:20.05 process pointer page 4 of 5
11:45:20.27 Index 1 (XQS_3300_3400_DOC_ID)
11:45:20.60 Index 2 (XQS_3300_3400_SND_ID)
11:45:20.83 Relation 271 (XQS_3300_3400) is ok

11:45:20.86 Validation finished
Done for 76230 ms, from 11:44:04.94 to 11:45:21.17.

Differences between old and current firebird.log

11:45:23.08. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2018-07-06 11:45 478 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Fri Jul 06 11:44:05 2018
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Fri Jul 06 11:45:20 2018
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2018-07-06 11:45:32.08 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html