Tests

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

Server and database settings

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

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2017-10-09 06:46:57.7560 -1 <null> ::1/49637 432304 9302 2

Current test settings

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

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

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

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 179 minutes: 5817.84 3830 1041394 2017-10-09 03:47 2017-10-09 06:46
customer order: creation 451.36 538 80794 2017-10-09 03:47 2017-10-09 06:46
customer order: refuse 36.59 280 6549 2017-10-09 03:47 2017-10-09 06:46
order to supplier: creation 115.12 2361 20607 2017-10-09 03:47 2017-10-09 06:46
order to supplier: removal 2.98 25949 534 2017-10-09 03:47 2017-10-09 06:46
invoice (draft): creation 116.18 3521 20797 2017-10-09 03:47 2017-10-09 06:46
invoice (draft): removal 42.03 577 7523 2017-10-09 03:47 2017-10-09 06:46
invoice accept: apply 62.94 13543 11267 2017-10-09 03:47 2017-10-09 06:46
invoice accept: cancel 18.58 3333 3325 2017-10-09 03:47 2017-10-09 06:46
customer reserve: creation 3297.94 214 590331 2017-10-09 03:47 2017-10-09 06:46
customer reserve: removal 1050.60 83 188058 2017-10-09 03:47 2017-10-09 06:46
realization accept: apply 208.74 663 37364 2017-10-09 03:47 2017-10-09 06:46
realization accept: cancel 89.57 180 16033 2017-10-09 03:47 2017-10-09 06:46
payment from customer: creation 150.21 1049 26888 2017-10-09 03:47 2017-10-09 06:46
payment from customer: removal 14.34 149 2566 2017-10-09 03:47 2017-10-09 06:46
payment to supplier: creation 125.67 814 22495 2017-10-09 03:47 2017-10-09 06:46
payment to supplier: removal 8.46 147 1515 2017-10-09 03:47 2017-10-09 06:46
service: total inventory turnovers 8.42 3675 1508 2017-10-09 03:47 2017-10-09 06:46
service: total monetary turnovers 18.03 72 3228 2017-10-09 03:47 2017-10-09 06:46
service: refresh index statistics 0.07 15622 12 2017-10-09 03:47 2017-10-09 06:46
Done for 123890 ms, from 6:53:32.42 to 6:55:36.31.

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 4759 100405 85656 14749 14.69 03:46:58 04:04:58
interval # 2, overall 2 6436 133574 115847 17727 13.27 04:04:59 04:22:59
interval # 3, overall 3 6370 128811 114653 14158 10.99 04:23:00 04:41:00
interval # 4, overall 4 5030 101277 90546 10731 10.60 04:41:01 04:59:01
interval # 5, overall 5 5636 116070 101450 14620 12.60 04:59:02 05:17:02
interval # 6, overall 6 6339 123348 114093 9255 7.50 05:17:03 05:35:03
interval # 7, overall 7 5986 119128 107747 11381 9.55 05:35:04 05:53:04
interval # 8, overall 8 5516 109281 99280 10001 9.15 05:53:05 06:11:05
interval # 9, overall 9 5826 119074 104874 14200 11.93 06:11:06 06:29:06
interval # 10, overall 10 5958 122534 107248 15286 12.47 06:29:07 06:47:07
Done for 277540 ms, from 7:00:12.59 to 7:04:50.13.

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 1512.49 0.0046 2.0066 1907 57
TEST_TIME 2 2471.87 0.6143 1.3621 1809 74
TEST_TIME 3 2812.21 0.8050 1.2160 1852 100
TEST_TIME 4 3077.26 0.8334 1.1325 1592 100
TEST_TIME 5 3225.06 0.8645 1.1173 2033 100
TEST_TIME 6 3376.08 0.8895 1.0951 2093 100
TEST_TIME 7 3496.61 0.9065 1.0845 1603 100
TEST_TIME 8 3638.75 0.9118 1.0914 1840 100
TEST_TIME 9 3817.51 0.9248 1.0711 1855 100
TEST_TIME 10 3928.23 0.9369 1.0616 1752 100
TEST_TIME 11 4011.39 0.9451 1.0556 1737 100
TEST_TIME 12 4127.57 0.9404 1.0464 1588 100
TEST_TIME 13 4155.12 0.9595 1.0253 1493 100
TEST_TIME 14 4180.42 0.9470 1.0501 1550 100
TEST_TIME 15 4259.28 0.9620 1.0386 1442 100
TEST_TIME 16 4339.55 0.9573 1.0500 1908 100
TEST_TIME 17 4474.62 0.9585 1.0443 1988 100
TEST_TIME 18 4608.44 0.9586 1.0285 2044 100
TEST_TIME 19 4617.56 0.9725 1.0392 1687 100
TEST_TIME 20 4702.55 0.9694 1.0334 1731 100
TEST_TIME 21 4789.79 0.9663 1.0356 1917 100
TEST_TIME 22 4872.46 0.9718 1.0291 1643 100
TEST_TIME 23 4950.13 0.9694 1.0289 1611 100
TEST_TIME 24 5023.84 0.9716 1.0265 1541 100
TEST_TIME 25 5087.15 0.9732 1.0296 1430 100
TEST_TIME 26 5167.76 0.9750 1.0253 1506 100
TEST_TIME 27 5219.03 0.9776 1.0207 1447 100
TEST_TIME 28 5272.64 0.9742 1.0224 1306 100
TEST_TIME 29 5288.62 0.9842 1.0157 1372 100
TEST_TIME 30 5262.61 0.9867 1.0150 1211 100
TEST_TIME 31 5294.80 0.9763 1.0197 1673 100
TEST_TIME 32 5361.53 0.9755 1.0257 2194 100
TEST_TIME 33 5456.38 0.9774 1.0198 1910 100
TEST_TIME 34 5502.40 0.9816 1.0159 1776 100
TEST_TIME 35 5500.52 0.9872 1.0107 1824 99
TEST_TIME 36 5488.65 0.9848 1.0156 1406 96
TEST_TIME 37 5489.32 0.9898 1.0100 1648 97
TEST_TIME 38 5465.55 0.9877 1.0122 1409 90
TEST_TIME 39 5486.80 0.9824 1.0064 1276 97
TEST_TIME 40 5457.46 0.9866 1.0171 1218 100
TEST_TIME 41 5455.11 0.9927 1.0087 1457 99
TEST_TIME 42 5503.20 0.9761 1.0114 1255 100
TEST_TIME 43 5526.25 0.9838 1.0120 1262 100
TEST_TIME 44 5537.05 0.9871 1.0113 1266 100
TEST_TIME 45 5547.75 0.9869 1.0119 1368 100
TEST_TIME 46 5578.59 0.9846 1.0187 2070 100
TEST_TIME 47 5632.69 0.9875 1.0138 1978 99
TEST_TIME 48 5668.52 0.9864 1.0084 1934 100
TEST_TIME 49 5682.13 0.9855 1.0138 1648 100
TEST_TIME 50 5721.37 0.9867 1.0132 1671 100
TEST_TIME 51 5748.06 0.9887 1.0126 1595 100
TEST_TIME 52 5784.71 0.9876 1.0096 1726 100
TEST_TIME 53 5771.01 0.9929 1.0152 1442 100
TEST_TIME 54 5795.01 0.9924 1.0077 1295 100
TEST_TIME 55 5773.76 0.9948 1.0077 1407 99
TEST_TIME 56 5759.96 0.9921 1.0037 1501 99
TEST_TIME 57 5740.11 0.9895 1.0050 1334 96
TEST_TIME 58 5707.52 0.9933 1.0037 1411 93
TEST_TIME 59 5700.72 0.9882 1.0042 1160 97
TEST_TIME 60 5642.87 0.9976 1.0029 1055 72
TEST_TIME 61 5602.33 0.9936 1.0051 1546 81
TEST_TIME 62 5606.50 0.9881 1.0077 1577 97
TEST_TIME 63 5637.38 0.9923 1.0080 1881 98
TEST_TIME 64 5642.79 0.9913 1.0056 1802 100
TEST_TIME 65 5656.74 0.9877 1.0089 1747 100
TEST_TIME 66 5673.53 0.9907 1.0077 1175 100
TEST_TIME 67 5658.54 0.9953 1.0080 1734 96
TEST_TIME 68 5663.11 0.9924 1.0030 1423 100
TEST_TIME 69 5625.38 0.9951 1.0052 1414 92
TEST_TIME 70 5621.66 0.9915 1.0065 1577 98
TEST_TIME 71 5618.31 0.9929 1.0084 1395 100
TEST_TIME 72 5603.22 0.9970 1.0040 1542 99
TEST_TIME 73 5585.57 0.9934 1.0107 1243 99
TEST_TIME 74 5615.66 0.9918 1.0054 1256 100
TEST_TIME 75 5588.94 0.9968 1.0083 1353 99
TEST_TIME 76 5613.63 0.9906 1.0058 1671 99
TEST_TIME 77 5625.91 0.9906 1.0071 2030 99
TEST_TIME 78 5626.80 0.9940 1.0104 1731 99
TEST_TIME 79 5644.52 0.9945 1.0062 1793 99
TEST_TIME 80 5654.84 0.9918 1.0066 1572 100
TEST_TIME 81 5645.03 0.9959 1.0059 1781 99
TEST_TIME 82 5648.29 0.9930 1.0047 1780 95
TEST_TIME 83 5646.25 0.9930 1.0042 1524 95
TEST_TIME 84 5621.60 0.9966 1.0038 1584 94
TEST_TIME 85 5612.94 0.9935 1.0062 1438 97
TEST_TIME 86 5617.79 0.9936 1.0039 1391 100
TEST_TIME 87 5612.00 0.9934 1.0049 1095 100
TEST_TIME 88 5603.99 0.9966 1.0043 1521 99
TEST_TIME 89 5605.36 0.9928 1.0067 1150 99
TEST_TIME 90 5615.39 0.9937 1.0047 1334 100
TEST_TIME 91 5608.63 0.9949 1.0076 1768 99
TEST_TIME 92 5628.81 0.9931 1.0042 1973 100
TEST_TIME 93 5623.41 0.9943 1.0093 1647 95
TEST_TIME 94 5649.76 0.9939 1.0048 1592 99
TEST_TIME 95 5652.72 0.9937 1.0054 1350 96
TEST_TIME 96 5641.17 0.9969 1.0074 1331 95
TEST_TIME 97 5638.02 0.9976 1.0035 1587 92
TEST_TIME 98 5636.58 0.9935 1.0081 1257 98
TEST_TIME 99 5651.60 0.9952 1.0054 1510 100
TEST_TIME 100 5665.48 0.9931 1.0073 1314 100
TEST_TIME 101 5671.88 0.9962 1.0032 1599 100
TEST_TIME 102 5665.54 0.9945 1.0046 1504 96
TEST_TIME 103 5658.52 0.9960 1.0077 1438 98
TEST_TIME 104 5674.08 0.9954 1.0054 1219 100
TEST_TIME 105 5677.69 0.9952 1.0051 1217 100
TEST_TIME 106 5689.65 0.9935 1.0063 2022 100
TEST_TIME 107 5693.77 0.9962 1.0046 1955 95
TEST_TIME 108 5699.02 0.9944 1.0091 1643 92
TEST_TIME 109 5732.23 0.9944 1.0033 1758 99
TEST_TIME 110 5717.59 0.9967 1.0045 1871 94
TEST_TIME 111 5718.08 0.9953 1.0042 1708 96
TEST_TIME 112 5720.80 0.9947 1.0035 1522 90
TEST_TIME 113 5709.08 0.9966 1.0065 1324 86
TEST_TIME 114 5718.04 0.9961 1.0036 1276 100
TEST_TIME 115 5721.83 0.9942 1.0069 1250 100
TEST_TIME 116 5745.58 0.9941 1.0040 1250 99
TEST_TIME 117 5756.29 0.9936 1.0059 1206 100
TEST_TIME 118 5760.70 0.9966 1.0023 1351 100
TEST_TIME 119 5745.19 0.9965 1.0042 1371 95
TEST_TIME 120 5747.55 0.9954 1.0040 1165 90
TEST_TIME 121 5741.74 0.9967 1.0036 1333 96
TEST_TIME 122 5737.63 0.9961 1.0039 1831 96
TEST_TIME 123 5750.92 0.9935 1.0034 1699 93
TEST_TIME 124 5746.13 0.9961 1.0037 1616 83
TEST_TIME 125 5758.88 0.9935 1.0048 1360 90
TEST_TIME 126 5762.22 0.9962 1.0030 1583 93
TEST_TIME 127 5755.27 0.9963 1.0045 1532 92
TEST_TIME 128 5767.49 0.9945 1.0045 1141 100
TEST_TIME 129 5765.30 0.9971 1.0027 1551 99
TEST_TIME 130 5764.15 0.9952 1.0024 1517 100
TEST_TIME 131 5749.69 0.9973 1.0037 1585 96
TEST_TIME 132 5748.12 0.9963 1.0053 1349 94
TEST_TIME 133 5752.07 0.9970 1.0018 1419 99
TEST_TIME 134 5737.01 0.9970 1.0036 1289 98
TEST_TIME 135 5730.15 0.9974 1.0025 1095 92
TEST_TIME 136 5728.14 0.9955 1.0029 1504 97
TEST_TIME 137 5724.60 0.9962 1.0029 1657 93
TEST_TIME 138 5729.29 0.9949 1.0036 1712 98
TEST_TIME 139 5726.22 0.9969 1.0034 1710 95
TEST_TIME 140 5729.75 0.9956 1.0062 1291 97
TEST_TIME 141 5736.78 0.9979 1.0027 1515 97
TEST_TIME 142 5731.77 0.9965 1.0039 1481 89
TEST_TIME 143 5733.60 0.9965 1.0029 1471 89
TEST_TIME 144 5727.37 0.9984 1.0023 1429 95
TEST_TIME 145 5721.47 0.9965 1.0024 1495 88
TEST_TIME 146 5716.26 0.9964 1.0023 1316 94
TEST_TIME 147 5706.05 0.9973 1.0027 1313 91
TEST_TIME 148 5714.30 0.9945 1.0020 1171 95
TEST_TIME 149 5720.16 0.9943 1.0031 922 99
TEST_TIME 150 5716.81 0.9970 1.0032 1001 100
TEST_TIME 151 5721.87 0.9957 1.0047 1551 100
TEST_TIME 152 5734.42 0.9959 1.0025 1671 100
TEST_TIME 153 5736.25 0.9957 1.0042 1794 99
TEST_TIME 154 5745.00 0.9962 1.0049 1426 100
TEST_TIME 155 5749.52 0.9976 1.0033 1542 95
TEST_TIME 156 5752.17 0.9964 1.0043 1387 92
TEST_TIME 157 5748.95 0.9985 1.0023 1324 91
TEST_TIME 158 5750.34 0.9957 1.0034 1305 91
TEST_TIME 159 5748.35 0.9975 1.0027 1311 90
TEST_TIME 160 5751.98 0.9959 1.0028 1004 95
TEST_TIME 161 5746.23 0.9975 1.0016 1216 96
TEST_TIME 162 5733.90 0.9976 1.0026 1245 91
TEST_TIME 163 5738.55 0.9956 1.0013 1040 95
TEST_TIME 164 5719.33 0.9985 1.0037 898 95
TEST_TIME 165 5719.89 0.9975 1.0020 971 99
TEST_TIME 166 5718.71 0.9961 1.0036 1205 99
TEST_TIME 167 5737.68 0.9943 1.0042 1381 100
TEST_TIME 168 5755.63 0.9951 1.0058 1242 100
TEST_TIME 169 5768.11 0.9977 1.0015 1475 100
TEST_TIME 170 5758.13 0.9974 1.0021 1475 95
TEST_TIME 171 5751.01 0.9974 1.0035 1424 94
TEST_TIME 172 5759.23 0.9967 1.0020 1547 93
TEST_TIME 173 5751.41 0.9975 1.0049 1349 94
TEST_TIME 174 5768.68 0.9961 1.0034 980 100
TEST_TIME 175 5772.74 0.9970 1.0032 1222 100
TEST_TIME 176 5783.29 0.9957 1.0034 1286 100
TEST_TIME 177 5778.05 0.9986 1.0013 1291 99
TEST_TIME 178 5769.62 0.9971 1.0043 978 100
TEST_TIME 179 5772.49 0.9982 1.0017 1348 100
TEST_TIME 180 5764.08 0.9975 1.0037 1214 100
Done for 9530 ms, from 7:04:51.80 to 7:05:01.33.

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 68110 49568 62034 <null> 60355 111573 90010 127421 30146 109625 74865 73516 101513 159544 132990 <null> 169142 285415 <null> 03:46:58 04:04:58
fetches per second 2 47739 103906 41836 86155 63529 <null> 79886 <null> 64963 63411 79991 69960 88913 73277 99408 127166 18095 48824 <null> 04:04:59 04:22:59
fetches per second 3 18900 43649 21920 100549 14646 4707 52936 36808 26274 6802 23554 30355 22923 58143 66915 100937 <null> 80146 <null> 04:23:00 04:41:00
fetches per second 4 5061 7074 9980 <null> 4986 83008 18813 3991 5268 <null> 2965 3995 8742 5566 6224 6888 <null> 97100 <null> 04:41:01 04:59:01
fetches per second 5 8915 23778 13397 <null> 21104 4237 21494 5846 3552 4049 18591 17753 8138 154875 28799 3479 9429 197368 <null> 04:59:02 05:17:02
fetches per second 6 14851 21184 16915 <null> 19826 <null> 29638 2815 1263 10306 23336 1386 28930 52000 20763 2237 <null> 409921 <null> 05:17:03 05:35:03
fetches per second 7 8183 8487 3000 3641 15471 2988 19837 5197 6616 1659 8784 20001 18117 <null> 14392 2829 39466 328395 <null> 05:35:04 05:53:04
fetches per second 8 7581 4083 8979 <null> 4053 <null> 11515 <null> 7478 3657 5827 2157 13057 4895 8481 4131 <null> 98510 <null> 05:53:05 06:11:05
fetches per second 9 7150 58207 20465 <null> 6876 <null> 9683 4406 104404 7697 17329 2595 25049 7801 71103 <null> <null> 125340 <null> 06:11:06 06:29:06
fetches per second 10 12248 21528 13345 <null> 20347 <null> 43720 26867 16277 30629 21546 1975 19747 <null> 6163 2373 <null> 63742 <null> 06:29:07 06:47:07
marks per second 1 14596 7067 13871 <null> 13269 27215 11979 21339 4362 26007 13674 14486 7861 25222 4679 <null> 20025 35642 <null> 03:46:58 04:04:58
marks per second 2 10221 14293 9375 13559 14024 <null> 11358 <null> 8831 11294 12452 11488 5340 13546 6522 19166 1300 3306 <null> 04:04:59 04:22:59
marks per second 3 3952 5433 4833 16928 3034 1138 5935 5594 4353 1038 4249 5959 1231 9724 4562 14732 <null> 3685 <null> 04:23:00 04:41:00
marks per second 4 1030 919 1768 <null> 823 21621 2047 580 617 <null> 418 946 358 761 322 1288 <null> 1085 <null> 04:41:01 04:59:01
marks per second 5 1873 3016 2213 <null> 4258 985 2811 838 325 682 1211 3479 256 19875 1576 503 316 2959 <null> 04:59:02 05:17:02
marks per second 6 3213 2733 3390 <null> 3967 <null> 3297 381 158 1583 3124 214 1257 7461 1621 453 <null> 10210 <null> 05:17:03 05:35:03
marks per second 7 1732 1138 457 765 2706 670 2470 751 961 301 674 3099 707 <null> 994 624 405 18048 <null> 05:35:04 05:53:04
marks per second 8 1458 540 1004 <null> 536 <null> 865 <null> 583 553 942 319 294 706 417 724 <null> 1208 <null> 05:53:05 06:11:05
marks per second 9 1432 6100 2761 <null> 1090 <null> 779 610 10664 1144 1831 399 1033 1500 6187 <null> <null> 704 <null> 06:11:06 06:29:06
marks per second 10 2391 2821 2412 <null> 3684 <null> 4196 3789 4850 4308 2738 389 529 <null> 644 318 <null> 881 <null> 06:29:07 06:47:07
reads/fetches*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 03:46:58 04:04:58
reads/fetches*100 2 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 04:04:59 04:22:59
reads/fetches*100 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 04:23:00 04:41:00
reads/fetches*100 4 0 0 0 <null> 0 0 0 0 0 <null> 0 0 0 0 0 0 <null> 0 <null> 04:41:01 04:59:01
reads/fetches*100 5 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:59:02 05:17:02
reads/fetches*100 6 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 05:17:03 05:35:03
reads/fetches*100 7 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 05:35:04 05:53:04
reads/fetches*100 8 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 <null> 0 <null> 05:53:05 06:11:05
reads/fetches*100 9 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> <null> 0 <null> 06:11:06 06:29:06
reads/fetches*100 10 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 0 <null> 06:29:07 06:47:07
writes/marks*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> 2 0 <null> 03:46:58 04:04:58
writes/marks*100 2 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 1 1 0 2 0 <null> 04:04:59 04:22:59
writes/marks*100 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 <null> 0 <null> 04:23:00 04:41:00
writes/marks*100 4 0 0 0 <null> 0 0 0 0 1 <null> 0 0 0 0 0 0 <null> 0 <null> 04:41:01 04:59:01
writes/marks*100 5 0 0 0 <null> 0 0 0 0 2 0 0 0 0 0 0 1 5 0 <null> 04:59:02 05:17:02
writes/marks*100 6 0 0 0 <null> 0 <null> 0 0 1 2 0 0 0 0 0 0 <null> 2 <null> 05:17:03 05:35:03
writes/marks*100 7 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 05:35:04 05:53:04
writes/marks*100 8 0 0 0 <null> 0 <null> 0 <null> 1 1 0 0 0 0 0 0 <null> 0 <null> 05:53:05 06:11:05
writes/marks*100 9 1 0 0 <null> 0 <null> 0 0 1 1 0 0 0 0 0 <null> <null> 0 <null> 06:11:06 06:29:06
writes/marks*100 10 0 0 0 <null> 0 <null> 0 0 1 0 0 0 0 <null> 0 0 <null> 0 <null> 06:29:07 06:47:07
Done for 9300 ms, from 7:05:02.50 to 7:05:11.80.

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 1803436 1683753 119683 6.63 0 9188 61 119683 2017-10-09 03:47 2017-10-09 06:46
doc_list_biud 1803855 1683753 120102 6.65 0 9360 20 120102 2017-10-09 03:47 2017-10-09 06:46
sp_add_invoice_to_stock 19675 11267 8408 42.73 0 184376 13543 8408 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_adding_invoice 4147 3325 822 19.82 0 96860 3333 822 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_client_order 6708 6549 159 2.37 0 2839 280 159 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_customer_reserve 297037 188058 108979 36.68 0 6521 83 108979 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_pay_from_customer 2582 2566 16 0.61 0 2247 149 16 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_pay_to_supplier 1520 1515 5 0.32 0 1529 147 5 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_supplier_invoice 9676 7523 2153 22.25 0 9656 577 2153 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_supplier_order 1641 534 1107 67.45 31 443618 25949 1107 2017-10-09 03:47 2017-10-09 06:46
sp_cancel_write_off 24918 16033 8885 35.65 0 3884 180 8885 2017-10-09 03:47 2017-10-09 06:46
sp_client_order 80794 80794 0 0.00 0 5912 538 0 2017-10-09 03:47 2017-10-09 06:46
sp_customer_reserve 590331 590331 0 0.00 0 6801 214 0 2017-10-09 03:47 2017-10-09 06:46
sp_fill_shopping_cart 122467 122198 269 0.21 0 2918 106 0 2017-10-09 03:47 2017-10-09 06:46
sp_fill_shopping_cart_clo_res 590331 590331 0 0.00 0 3182 16 0 2017-10-09 03:47 2017-10-09 06:46
sp_get_clo_for_invoice 11267 11267 0 0.00 0 5257 358 0 2017-10-09 03:47 2017-10-09 06:46
sp_kill_cost_storno 32794 23439 9355 28.52 0 2464 24 9355 2017-10-09 03:47 2017-10-09 06:46
sp_kill_qstorno_ret_qs2qd 628235 400206 228029 36.29 0 8314 32 228029 2017-10-09 03:47 2017-10-09 06:46
sp_kill_qty_storno 390681 270653 120028 30.72 0 9345 90 120028 2017-10-09 03:47 2017-10-09 06:46
sp_lock_selected_doc 80387 68353 12034 14.97 0 2199 8 12034 2017-10-09 03:47 2017-10-09 06:46
sp_make_cost_storno 98014 98014 0 0.00 0 8923 524 0 2017-10-09 03:47 2017-10-09 06:46
sp_multiply_rows_for_pdistr 98014 98014 0 0.00 0 4040 65 0 2017-10-09 03:47 2017-10-09 06:46
sp_multiply_rows_for_qdistr 80794 80794 0 0.00 0 3635 180 0 2017-10-09 03:47 2017-10-09 06:46
sp_pay_from_customer 26888 26888 0 0.00 0 9844 1049 0 2017-10-09 03:47 2017-10-09 06:46
sp_pay_to_supplier 22495 22495 0 0.00 0 6943 814 0 2017-10-09 03:47 2017-10-09 06:46
sp_payment_common 49383 49383 0 0.00 0 2449 68 0 2017-10-09 03:47 2017-10-09 06:46
sp_qd_handle_on_cancel_clo 6704 6549 155 2.31 0 2308 123 155 2017-10-09 03:47 2017-10-09 06:46
sp_qd_handle_on_invoice_upd_sts 15230 14592 638 4.18 0 6958 395 638 2017-10-09 03:47 2017-10-09 06:46
sp_qd_handle_on_reserve_upd_sts 37364 37364 0 0.00 0 3073 57 0 2017-10-09 03:47 2017-10-09 06:46
sp_reserve_write_off 38669 37364 1305 3.37 0 8938 663 1305 2017-10-09 03:47 2017-10-09 06:46
sp_supplier_invoice 20917 20797 120 0.57 0 34398 3521 0 2017-10-09 03:47 2017-10-09 06:46
sp_supplier_order 20756 20607 149 0.71 0 16880 2361 0 2017-10-09 03:47 2017-10-09 06:46
srv_find_qd_qs_mism 1070113 950471 119642 11.18 0 4352 31 119642 2017-10-09 03:47 2017-10-09 06:46
srv_make_invnt_saldo 1508 1508 0 0.00 15 41496 3675 0 2017-10-09 03:47 2017-10-09 06:46
srv_make_money_saldo 3228 3228 0 0.00 0 2402 72 0 2017-10-09 03:47 2017-10-09 06:46
srv_recalc_idx_stat 12 12 0 0.00 1263 46504 15622 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_add_invoice_to_stock 8408 8408 0 0.00 0 3011 108 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_adding_invoice 623 623 0 0.00 0 2746 239 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_client_order 159 159 0 0.00 0 1435 138 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_customer_reserve 84 84 0 0.00 0 1919 77 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_pay_from_customer 16 16 0 0.00 0 484 95 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_pay_to_supplier 5 5 0 0.00 15 63 34 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_supplier_invoice 676 676 0 0.00 0 1279 101 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_supplier_order 13945 13945 0 0.00 0 4571 149 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_cancel_write_off 36 36 0 0.00 0 1170 128 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_reserve_write_off 1305 1305 0 0.00 0 1404 71 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_supplier_invoice 120 120 0 0.00 0 1030 94 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-abend:sp_supplier_order 149 149 0 0.00 0 717 91 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_add_invoice_to_stock 11267 11267 0 0.00 0 14430 727 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_adding_invoice 1382 1382 0 0.00 0 9375 843 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_client_order 6549 6549 0 0.00 0 1685 72 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_customer_reserve 2530 2530 0 0.00 0 1606 79 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_pay_from_customer 2566 2566 0 0.00 0 1684 55 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_pay_to_supplier 1515 1515 0 0.00 0 1669 55 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_supplier_invoice 900 900 0 0.00 0 1466 88 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_supplier_order 534 534 0 0.00 0 59639 1990 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_cancel_write_off 3746 3746 0 0.00 0 2839 74 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_client_order 80794 80794 0 0.00 0 2995 85 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_customer_reserve 3801 3801 0 0.00 0 1872 58 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_pay_from_customer 26888 26888 0 0.00 0 2496 76 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_pay_to_supplier 22495 22495 0 0.00 0 2496 69 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_reserve_write_off 37364 37364 0 0.00 0 2496 81 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_supplier_invoice 20797 20797 0 0.00 0 2636 80 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:sp_supplier_order 20607 20607 0 0.00 0 2886 82 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:srv_make_invnt_saldo 1508 1508 0 0.00 0 936 38 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:srv_make_money_saldo 3228 3228 0 0.00 0 1139 32 0 2017-10-09 03:47 2017-10-09 06:46
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 1123 137 0 2017-10-09 03:47 2017-10-09 06:46
v_add_invoice_to_stock 39350 22534 16816 42.73 0 1794 20 16816 2017-10-09 03:47 2017-10-09 06:46
v_all_customers 121044 121044 0 0.00 0 1606 6 0 2017-10-09 03:47 2017-10-09 06:46
v_all_suppliers 83490 82952 538 0.64 0 2699 6 0 2017-10-09 03:47 2017-10-09 06:46
v_all_wares 161588 161588 0 0.00 0 2309 5 0 2017-10-09 03:47 2017-10-09 06:46
v_cancel_adding_invoice 3240 2764 476 14.69 0 2855 169 476 2017-10-09 03:47 2017-10-09 06:46
v_cancel_client_order 13416 13098 318 2.37 0 1498 7 318 2017-10-09 03:47 2017-10-09 06:46
v_cancel_customer_prepayment 5164 5132 32 0.61 0 889 8 32 2017-10-09 03:47 2017-10-09 06:46
v_cancel_customer_reserve 5228 5060 168 3.21 0 1139 10 168 2017-10-09 03:47 2017-10-09 06:46
v_cancel_payment_to_supplier 3040 3030 10 0.32 0 1264 9 10 2017-10-09 03:47 2017-10-09 06:46
v_cancel_supplier_invoice 3152 1800 1352 42.89 0 889 18 1352 2017-10-09 03:47 2017-10-09 06:46
v_cancel_supplier_order 3282 1068 2214 67.45 0 437 9 2214 2017-10-09 03:47 2017-10-09 06:46
v_cancel_write_off 7564 7492 72 0.95 0 2605 110 72 2017-10-09 03:47 2017-10-09 06:46
v_max_id_clo_ord 20756 20607 149 0.71 0 687 6 0 2017-10-09 03:47 2017-10-09 06:46
v_max_id_clo_res 3801 3801 0 0.00 0 874 20 0 2017-10-09 03:47 2017-10-09 06:46
v_max_id_ord_sup 20917 20797 120 0.57 0 874 6 0 2017-10-09 03:47 2017-10-09 06:46
v_max_non_paid_invoice 22423 22423 0 0.00 0 1748 7 0 2017-10-09 03:47 2017-10-09 06:46
v_max_non_paid_realizn 26888 26888 0 0.00 0 1139 6 0 2017-10-09 03:47 2017-10-09 06:46
v_min_id_clo_ord 20756 20607 149 0.71 0 1701 8 0 2017-10-09 03:47 2017-10-09 06:46
v_min_id_clo_res 3801 3801 0 0.00 0 2168 11 0 2017-10-09 03:47 2017-10-09 06:46
v_min_id_ord_sup 20917 20797 120 0.57 0 982 7 0 2017-10-09 03:47 2017-10-09 06:46
v_min_non_paid_invoice 22495 22495 0 0.00 0 1981 10 0 2017-10-09 03:47 2017-10-09 06:46
v_min_non_paid_realizn 26888 26888 0 0.00 0 1061 9 0 2017-10-09 03:47 2017-10-09 06:46
v_our_firm 40544 40544 0 0.00 0 983 6 0 2017-10-09 03:47 2017-10-09 06:46
v_reserve_write_off 77338 74728 2610 3.37 0 2606 9 2610 2017-10-09 03:47 2017-10-09 06:46
x_lock_depdocs_on_canc_invoice 18526 9948 8578 46.30 0 2574 41 8578 2017-10-09 03:47 2017-10-09 06:46
x_lock_depdocs_on_canc_sup_ord 1638 534 1104 67.39 0 2153 81 1104 2017-10-09 03:47 2017-10-09 06:46
x_make_qstorno_1000_1200 20756 20607 149 0.71 0 16146 2126 0 2017-10-09 03:47 2017-10-09 06:46
x_make_qstorno_1200_2000 20917 20797 120 0.57 0 33681 3281 0 2017-10-09 03:47 2017-10-09 06:46
x_make_qstorno_2100_3300 590331 590331 0 0.00 0 6723 179 0 2017-10-09 03:47 2017-10-09 06:46
Done for 414620 ms, from 7:12:03.14 to 7:18:57.76.

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 95 sp_kill_cost_storno 335544336 2017-10-09 03:47 2017-10-09 06:36
deadlock 91 sp_kill_qstorno_ret_qs2qd 335544336 2017-10-09 03:48 2017-10-09 06:46
deadlock 10538 sp_lock_selected_doc 335544336 2017-10-09 03:47 2017-10-09 06:46
deadlock 155 sp_qd_handle_on_cancel_clo 335544336 2017-10-09 03:47 2017-10-09 06:40
deadlock 161 sp_qd_handle_on_invoice_upd_sts 335544336 2017-10-09 03:47 2017-10-09 06:44
deadlock 716 x_lock_depdocs_on_canc_invoice 335544336 2017-10-09 03:47 2017-10-09 06:46
deadlock 274 x_lock_depdocs_on_canc_sup_ord 335544336 2017-10-09 03:49 2017-10-09 06:46
user_exc 149 x_make_qstorno_1000_1200 335544517 2017-10-09 03:48 2017-10-09 06:45
user_exc 120 x_make_qstorno_1200_2000 335544517 2017-10-09 03:47 2017-10-09 06:46
Done for 12150 ms, from 7:19:07.63 to 7:19:19.78.

MON$DATABASE and FB VERSION info

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

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 432898
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 432729
Oldest active 432730
Oldest snapshot 432730
Next transaction 432731
Sequence number 0
Next attachment ID 9517
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write

Variable header data:
Sweep interval: 0
*END*


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

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

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

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

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

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

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

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

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

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

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

DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.06, total records: 2115410
Average version length: 47.79, total versions: 3357, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 22872
Data pages: 22872, average fill: 73%
Primary pages: 22872, secondary pages: 0, swept pages: 12646
Empty pages: 6, full pages: 20799
Fill distribution:
0 - 19% = 7
20 - 39% = 5
40 - 59% = 55
60 - 79% = 22802
80 - 99% = 3

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 10215, nodes: 2115410
Average node length: 19.26, total dup: 0, max dup: 0
Average key length: 16.30, compression ratio: 1.66
Average prefix length: 13.70, average data length: 13.30
Clustering factor: 470286, ratio: 0.22
Fill distribution:
0 - 19% = 627
20 - 39% = 2216
40 - 59% = 4994
60 - 79% = 1016
80 - 99% = 1362

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7608, nodes: 2115410
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 444835, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 3650
40 - 59% = 3884
60 - 79% = 66
80 - 99% = 8

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 172400, depth: 3, leaf buckets: 3733, nodes: 2115410
Average node length: 6.79, total dup: 1550829, max dup: 49
Average key length: 3.84, compression ratio: 2.35
Average prefix length: 7.43, average data length: 1.57
Clustering factor: 431001, ratio: 0.20
Fill distribution:
0 - 19% = 159
20 - 39% = 1204
40 - 59% = 1619
60 - 79% = 233
80 - 99% = 518

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.36, total records: 629725
Average version length: 37.16, total versions: 1502, max versions: 3
Average fragment length: 19.00, total fragments: 7, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7936
Data pages: 7936, average fill: 75%
Primary pages: 7934, secondary pages: 2, swept pages: 6993
Empty pages: 3, full pages: 7693
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 3
60 - 79% = 7912
80 - 99% = 15

Index DOC_LIST_ID_DESC (1)
Root page: 223469, depth: 3, leaf buckets: 2348, nodes: 629725
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 156270, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1362
40 - 59% = 953
60 - 79% = 31
80 - 99% = 2

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 658, nodes: 629725
Average node length: 4.87, total dup: 629675, max dup: 43218
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 286596, ratio: 0.46
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 552
60 - 79% = 84
80 - 99% = 21

Index PK_DOC_LIST (0)
Root page: 298397, depth: 3, leaf buckets: 1934, nodes: 629725
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 156270, ratio: 0.25
Fill distribution:
0 - 19% = 132
20 - 39% = 659
40 - 59% = 697
60 - 79% = 195
80 - 99% = 251

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

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

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

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

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

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

INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 64.81, total records: 400
Average version length: 20.71, total versions: 229933, max versions: 1114
Average fragment length: 17.83, total fragments: 389, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.60
Pointer pages: 1, data page slots: 1432
Data pages: 1432, average fill: 77%
Primary pages: 8, secondary pages: 1424, swept pages: 0
Empty pages: 4, full pages: 1225
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 1
60 - 79% = 1052
80 - 99% = 374

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 36.75, total records: 9883
Average version length: 70.95, total versions: 4787, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 2.61
Pointer pages: 2, data page slots: 456
Data pages: 352, average fill: 35%
Primary pages: 351, secondary pages: 1, swept pages: 99
Empty pages: 106, full pages: 82
Fill distribution:
0 - 19% = 160
20 - 39% = 50
40 - 59% = 43
60 - 79% = 35
80 - 99% = 64

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 50, nodes: 9883
Average node length: 13.90, total dup: 656, max dup: 1
Average key length: 11.94, compression ratio: 2.26
Average prefix length: 17.99, average data length: 9.01
Clustering factor: 7728, ratio: 0.78
Fill distribution:
0 - 19% = 0
20 - 39% = 37
40 - 59% = 11
60 - 79% = 2
80 - 99% = 0

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

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 4.69, total records: 773
Average version length: 45.36, total versions: 695, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 13.66
Pointer pages: 1, data page slots: 40
Data pages: 20, average fill: 37%
Primary pages: 18, secondary pages: 2, swept pages: 0
Empty pages: 8, full pages: 6
Fill distribution:
0 - 19% = 9
20 - 39% = 4
40 - 59% = 0
60 - 79% = 1
80 - 99% = 6

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 303998, depth: 2, leaf buckets: 1, nodes: 773
Average node length: 4.88, total dup: 701, max dup: 90
Average key length: 3.22, compression ratio: 5.90
Average prefix length: 17.87, average data length: 1.13
Clustering factor: 325, ratio: 0.42
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.13, total records: 227624
Average version length: 29.81, total versions: 3655, max versions: 8
Average fragment length: 34.00, total fragments: 1, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 2696
Data pages: 2696, average fill: 63%
Primary pages: 2686, secondary pages: 10, swept pages: 1965
Empty pages: 14, full pages: 646
Fill distribution:
0 - 19% = 41
20 - 39% = 132
40 - 59% = 546
60 - 79% = 1969
80 - 99% = 8

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 216, nodes: 227624
Average node length: 4.55, total dup: 227575, max dup: 10788
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 38340, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 92
60 - 79% = 81
80 - 99% = 19

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 253, nodes: 227624
Average node length: 5.49, total dup: 205451, max dup: 79
Average key length: 2.94, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 50332, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 20
40 - 59% = 111
60 - 79% = 83
80 - 99% = 39

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 249, nodes: 227624
Average node length: 5.48, total dup: 205451, max dup: 79
Average key length: 2.94, compression ratio: 7.48
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 50407, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 100
60 - 79% = 100
80 - 99% = 36

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 256, nodes: 227624
Average node length: 5.27, total dup: 205451, max dup: 79
Average key length: 2.73, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 50391, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 19
40 - 59% = 138
60 - 79% = 72
80 - 99% = 26

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.98, total records: 269685
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2312
Data pages: 2312, average fill: 64%
Primary pages: 2312, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 2304
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2304
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 120375, depth: 2, leaf buckets: 214, nodes: 269685
Average node length: 4.53, total dup: 269505, max dup: 2193
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 33629, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 79
60 - 79% = 67
80 - 99% = 67

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

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

PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.55, total records: 11175964
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: 163, data page slots: 264864
Data pages: 264864, average fill: 87%
Primary pages: 264864, secondary pages: 0, swept pages: 3
Empty pages: 2, full pages: 264861
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 264861

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 12434, nodes: 11175964
Average node length: 5.65, total dup: 10319551, max dup: 133
Average key length: 2.18, compression ratio: 3.66
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 4484983, ratio: 0.40
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 6579
60 - 79% = 3925
80 - 99% = 1921

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11008, nodes: 11175964
Average node length: 4.54, total dup: 11175960, max dup: 10278788
Average key length: 1.08, compression ratio: 0.37
Average prefix length: 0.40, average data length: 0.00
Clustering factor: 332854, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 11005
60 - 79% = 0
80 - 99% = 2

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 13388, nodes: 11175964
Average node length: 5.71, total dup: 10810197, max dup: 18874
Average key length: 2.24, compression ratio: 4.01
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 990689, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 9605
60 - 79% = 2066
80 - 99% = 1713

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13529, nodes: 11175964
Average node length: 5.54, total dup: 11146160, max dup: 1409430
Average key length: 2.07, compression ratio: 18.22
Average prefix length: 37.71, average data length: 0.07
Clustering factor: 6554261, ratio: 0.59
Fill distribution:
0 - 19% = 16
20 - 39% = 2
40 - 59% = 11596
60 - 79% = 626
80 - 99% = 1289

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.98, total records: 431137
Average version length: 55.70, total versions: 1198, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5120
Data pages: 5120, average fill: 75%
Primary pages: 5120, secondary pages: 0, swept pages: 3405
Empty pages: 2, full pages: 4848
Fill distribution:
0 - 19% = 4
20 - 39% = 6
40 - 59% = 19
60 - 79% = 5090
80 - 99% = 1

Index PSTORNED_RCV_ID (2)
Root page: 680878, depth: 3, leaf buckets: 571, nodes: 431137
Average node length: 5.98, total dup: 360049, max dup: 658
Average key length: 3.20, compression ratio: 2.82
Average prefix length: 7.97, average data length: 1.03
Clustering factor: 58628, ratio: 0.14
Fill distribution:
0 - 19% = 5
20 - 39% = 30
40 - 59% = 349
60 - 79% = 147
80 - 99% = 40

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 459, nodes: 431137
Average node length: 5.60, total dup: 383667, max dup: 105
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 107523, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 193
60 - 79% = 168
80 - 99% = 89

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

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

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

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

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

SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 1284, max versions: 1218
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: 8
Data pages: 8, average fill: 57%
Primary pages: 1, secondary pages: 7, swept pages: 0
Empty pages: 0, full pages: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 3
60 - 79% = 2
80 - 99% = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 29.93, total records: 13772
Average version length: 72.17, total versions: 8059, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.54
Pointer pages: 2, data page slots: 512
Data pages: 504, average fill: 35%
Primary pages: 503, secondary pages: 1, swept pages: 151
Empty pages: 180, full pages: 146
Fill distribution:
0 - 19% = 241
20 - 39% = 58
40 - 59% = 44
60 - 79% = 67
80 - 99% = 94

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 29, nodes: 13772
Average node length: 6.10, total dup: 11895, max dup: 14
Average key length: 4.09, compression ratio: 9.05
Average prefix length: 35.05, average data length: 1.95
Clustering factor: 2296, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 13
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.69, total records: 1194793
Average version length: 71.39, total versions: 8105, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 11, data page slots: 17784
Data pages: 17736, average fill: 74%
Primary pages: 17736, secondary pages: 0, swept pages: 10803
Empty pages: 53, full pages: 14441
Fill distribution:
0 - 19% = 107
20 - 39% = 159
40 - 59% = 662
60 - 79% = 16687
80 - 99% = 121

Index XQD_1000_3300_DOC (1)
Root page: 412280, depth: 3, leaf buckets: 1393, nodes: 1194793
Average node length: 5.12, total dup: 1164547, max dup: 126
Average key length: 2.19, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 133191, ratio: 0.11
Fill distribution:
0 - 19% = 20
20 - 39% = 97
40 - 59% = 1042
60 - 79% = 62
80 - 99% = 172

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 278232, depth: 3, leaf buckets: 1695, nodes: 1194793
Average node length: 6.25, total dup: 1043716, max dup: 16
Average key length: 3.31, compression ratio: 11.17
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 228825, ratio: 0.19
Fill distribution:
0 - 19% = 28
20 - 39% = 130
40 - 59% = 1227
60 - 79% = 165
80 - 99% = 145

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 48.60, total records: 33646
Average version length: 72.08, total versions: 10957, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.80
Pointer pages: 4, data page slots: 3200
Data pages: 1281, average fill: 32%
Primary pages: 1279, secondary pages: 2, swept pages: 625
Empty pages: 456, full pages: 256
Fill distribution:
0 - 19% = 634
20 - 39% = 162
40 - 59% = 107
60 - 79% = 267
80 - 99% = 111

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 67, nodes: 33646
Average node length: 5.84, total dup: 29294, max dup: 44
Average key length: 3.68, compression ratio: 10.06
Average prefix length: 35.45, average data length: 1.55
Clustering factor: 3755, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 43
40 - 59% = 17
60 - 79% = 3
80 - 99% = 2

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.07, total records: 1727264
Average version length: 71.76, total versions: 50647, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.94
Pointer pages: 17, data page slots: 26512
Data pages: 26480, average fill: 72%
Primary pages: 26480, secondary pages: 0, swept pages: 14400
Empty pages: 196, full pages: 20175
Fill distribution:
0 - 19% = 421
20 - 39% = 742
40 - 59% = 2059
60 - 79% = 22198
80 - 99% = 1060

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 199734, depth: 3, leaf buckets: 2707, nodes: 1727264
Average node length: 5.61, total dup: 1624830, max dup: 64
Average key length: 2.65, compression ratio: 13.96
Average prefix length: 36.41, average data length: 0.59
Clustering factor: 234113, ratio: 0.14
Fill distribution:
0 - 19% = 18
20 - 39% = 1277
40 - 59% = 1014
60 - 79% = 217
80 - 99% = 181

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 12.43, total records: 9537
Average version length: 71.12, total versions: 7850, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 10.94
Pointer pages: 3, data page slots: 1648
Data pages: 568, average fill: 22%
Primary pages: 567, secondary pages: 1, swept pages: 312
Empty pages: 292, full pages: 61
Fill distribution:
0 - 19% = 353
20 - 39% = 73
40 - 59% = 52
60 - 79% = 38
80 - 99% = 52

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 22, nodes: 9537
Average node length: 6.78, total dup: 7974, max dup: 49
Average key length: 4.74, compression ratio: 7.81
Average prefix length: 34.43, average data length: 2.57
Clustering factor: 1336, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 4
60 - 79% = 3
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.98, total records: 2614757
Average version length: 71.13, total versions: 18942, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 23, data page slots: 37256
Data pages: 37256, average fill: 76%
Primary pages: 37256, secondary pages: 0, swept pages: 26790
Empty pages: 10, full pages: 34165
Fill distribution:
0 - 19% = 27
20 - 39% = 48
40 - 59% = 425
60 - 79% = 36287
80 - 99% = 469

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5461, nodes: 2614757
Average node length: 6.88, total dup: 2118066, max dup: 14
Average key length: 3.90, compression ratio: 9.48
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 525001, ratio: 0.20
Fill distribution:
0 - 19% = 7
20 - 39% = 3041
40 - 59% = 2010
60 - 79% = 240
80 - 99% = 163

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.67, total records: 4685186
Average version length: 84.29, total versions: 2519, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 45, data page slots: 72008
Data pages: 72008, average fill: 80%
Primary pages: 72008, secondary pages: 0, swept pages: 26799
Empty pages: 7, full pages: 71773
Fill distribution:
0 - 19% = 10
20 - 39% = 7
40 - 59% = 8
60 - 79% = 21218
80 - 99% = 50765

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4774, nodes: 4685186
Average node length: 5.15, total dup: 4578295, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 757085, ratio: 0.16
Fill distribution:
0 - 19% = 19
20 - 39% = 74
40 - 59% = 2091
60 - 79% = 1994
80 - 99% = 596

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5306, nodes: 4685186
Average node length: 5.70, total dup: 4196706, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 263182, ratio: 0.06
Fill distribution:
0 - 19% = 56
20 - 39% = 179
40 - 59% = 3234
60 - 79% = 278
80 - 99% = 1559

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5314, nodes: 4685186
Average node length: 5.81, total dup: 4098618, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 812215, ratio: 0.17
Fill distribution:
0 - 19% = 24
20 - 39% = 79
40 - 59% = 2312
60 - 79% = 2074
80 - 99% = 825

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.69, total records: 2342240
Average version length: 83.65, total versions: 13287, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 23, data page slots: 36392
Data pages: 36392, average fill: 79%
Primary pages: 36392, secondary pages: 0, swept pages: 25901
Empty pages: 9, full pages: 35638
Fill distribution:
0 - 19% = 20
20 - 39% = 36
40 - 59% = 136
60 - 79% = 15349
80 - 99% = 20851

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2542, nodes: 2342240
Average node length: 5.15, total dup: 2287253, max dup: 193
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 363087, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 69
40 - 59% = 1528
60 - 79% = 733
80 - 99% = 211

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4123, nodes: 2342240
Average node length: 6.22, total dup: 1923633, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 246826, ratio: 0.11
Fill distribution:
0 - 19% = 105
20 - 39% = 1867
40 - 59% = 1507
60 - 79% = 443
80 - 99% = 201

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2912, nodes: 2342240
Average node length: 5.82, total dup: 2048708, max dup: 36
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 438306, ratio: 0.19
Fill distribution:
0 - 19% = 28
20 - 39% = 64
40 - 59% = 1812
60 - 79% = 764
80 - 99% = 244

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.37, total records: 4969895
Average version length: 85.62, total versions: 27016, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 48, data page slots: 77976
Data pages: 77968, average fill: 79%
Primary pages: 77968, secondary pages: 0, swept pages: 24850
Empty pages: 212, full pages: 73226
Fill distribution:
0 - 19% = 353
20 - 39% = 570
40 - 59% = 1422
60 - 79% = 18953
80 - 99% = 56670

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5359, nodes: 4969895
Average node length: 5.04, total dup: 4940843, max dup: 638
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 756337, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 320
40 - 59% = 3156
60 - 79% = 1384
80 - 99% = 494

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6106, nodes: 4969895
Average node length: 5.53, total dup: 4576920, max dup: 49
Average key length: 2.54, compression ratio: 3.54
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 303005, ratio: 0.06
Fill distribution:
0 - 19% = 89
20 - 39% = 1576
40 - 59% = 2585
60 - 79% = 591
80 - 99% = 1265

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 6023, nodes: 4969895
Average node length: 5.68, total dup: 4462065, max dup: 76
Average key length: 2.70, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 835808, ratio: 0.17
Fill distribution:
0 - 19% = 7
20 - 39% = 298
40 - 59% = 3582
60 - 79% = 1580
80 - 99% = 556

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.14, total records: 3277675
Average version length: 83.98, total versions: 13100, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 32, data page slots: 51128
Data pages: 51128, average fill: 79%
Primary pages: 51128, secondary pages: 0, swept pages: 36769
Empty pages: 8, full pages: 49416
Fill distribution:
0 - 19% = 23
20 - 39% = 57
40 - 59% = 315
60 - 79% = 20715
80 - 99% = 30018

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3549, nodes: 3277675
Average node length: 5.03, total dup: 3261119, max dup: 1317
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 718009, ratio: 0.22
Fill distribution:
0 - 19% = 18
20 - 39% = 350
40 - 59% = 1918
60 - 79% = 843
80 - 99% = 420

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5821, nodes: 3277675
Average node length: 6.24, total dup: 2685586, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 384257, ratio: 0.12
Fill distribution:
0 - 19% = 176
20 - 39% = 2683
40 - 59% = 2064
60 - 79% = 598
80 - 99% = 300

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3878, nodes: 3277675
Average node length: 5.60, total dup: 2984008, max dup: 93
Average key length: 2.62, compression ratio: 3.43
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 756164, ratio: 0.23
Fill distribution:
0 - 19% = 18
20 - 39% = 371
40 - 59% = 1913
60 - 79% = 1074
80 - 99% = 502

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.19, total records: 671117
Average version length: 69.74, total versions: 2357, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9368
Data pages: 9368, average fill: 76%
Primary pages: 9368, secondary pages: 0, swept pages: 7242
Empty pages: 2, full pages: 8626
Fill distribution:
0 - 19% = 25
20 - 39% = 82
40 - 59% = 205
60 - 79% = 8994
80 - 99% = 62

Index XQS_3300_3400_DOC_ID (0)
Root page: 175820, depth: 3, leaf buckets: 835, nodes: 671117
Average node length: 5.30, total dup: 633918, max dup: 114
Average key length: 2.42, compression ratio: 3.71
Average prefix length: 8.63, average data length: 0.37
Clustering factor: 55422, ratio: 0.08
Fill distribution:
0 - 19% = 4
20 - 39% = 206
40 - 59% = 369
60 - 79% = 188
80 - 99% = 68

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 926, nodes: 671117
Average node length: 5.92, total dup: 574058, max dup: 23
Average key length: 3.04, compression ratio: 2.96
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 58488, ratio: 0.09
Fill distribution:
0 - 19% = 5
20 - 39% = 225
40 - 59% = 381
60 - 79% = 228
80 - 99% = 87

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Done for 76360 ms, from 7:19:20.30 to 7:20:36.66.

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 2115410 3357 0.1586
DOC_LIST 629725 1502 0.2385
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 229933 57483.2500
INVNT_TURNOVER_LOG 9883 4787 48.4367
MONEY_SALDO 49 785 1602.0408
MONEY_TURNOVER_LOG 773 695 89.9094
OPTYPES 9 0 0.0000
PDISTR 227624 3655 1.6057
PERF_ESTIMATED 269685 0 0.0000
PERF_LOG 11175964 0 0.0000
PSTORNED 431137 1198 0.2778
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 1284 32100.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2600 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 13772 8059 58.5172
XQD_1000_3300 1194793 8105 0.6783
XQD_1200_2000 33646 10957 32.5655
XQD_2000_3300 1727264 50647 2.9322
XQD_2100_3300 9537 7850 82.3109
XQD_3300_3400 2614757 18942 0.7244
XQS_1000_1200 4685186 2519 0.0537
XQS_1000_3300 2342240 13287 0.5672
XQS_1200_2000 4969895 27016 0.5435
XQS_2100_3300 3277675 13100 0.3996
XQS_3300_3400 671117 2357 0.3512
Z_USED_VIEWS 29 0 0.0000
Done for 2620 ms, from 7:20:48.14 to 7:20:50.76.

Database validation

07:20:50.86 Validation started

07:20:50.86 Relation 140 (DOC_LIST)
07:20:50.86 process pointer page 0 of 5
07:20:50.98 process pointer page 1 of 5
07:20:51.09 process pointer page 2 of 5
07:20:51.18 process pointer page 3 of 5
07:20:51.29 process pointer page 4 of 5
07:20:51.37 Index 1 (PK_DOC_LIST)
07:20:51.64 Index 2 (DOC_LIST_ID_DESC)
07:20:51.93 Index 3 (FK_DOC_LIST_AGENTS)
07:20:52.06 Relation 140 (DOC_LIST) is ok

07:20:52.06 Relation 141 (DOC_DATA)
07:20:52.06 process pointer page 0 of 15
07:20:52.11 process pointer page 1 of 15
07:20:52.14 process pointer page 2 of 15
07:20:52.17 process pointer page 3 of 15
07:20:52.25 process pointer page 4 of 15
07:20:52.34 process pointer page 5 of 15
07:20:52.43 process pointer page 6 of 15
07:20:52.53 process pointer page 7 of 15
07:20:52.62 process pointer page 8 of 15
07:20:52.71 process pointer page 9 of 15
07:20:52.81 process pointer page 10 of 15
07:20:52.89 process pointer page 11 of 15
07:20:52.98 process pointer page 12 of 15
07:20:53.07 process pointer page 13 of 15
07:20:53.17 process pointer page 14 of 15
07:20:53.17 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:20:54.29 Index 3 (DOC_DATA_ID_DESC)
07:20:55.21 Index 4 (FK_DOC_DATA_DOC_LIST)
07:20:55.94 Relation 141 (DOC_DATA) is ok

07:20:55.94 Relation 147 (INVNT_SALDO)
07:20:55.96 process pointer page 0 of 1
07:20:56.66 Index 1 (PK_INVNT_SALDO)
07:20:56.66 Relation 147 (INVNT_SALDO) is ok

07:20:56.66 Relation 150 (PDISTR)
07:20:56.66 process pointer page 0 of 2
07:20:56.71 process pointer page 1 of 2
07:20:56.72 Index 2 (PDISTR_SND_ID)
07:20:56.79 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:20:56.86 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:20:56.94 Index 5 (PDISTR_AGENT_ID)
07:20:57.00 Relation 150 (PDISTR) is ok

07:20:57.00 Relation 151 (PSTORNED)
07:20:57.00 process pointer page 0 of 4
07:20:57.10 process pointer page 1 of 4
07:20:57.19 process pointer page 2 of 4
07:20:57.30 process pointer page 3 of 4
07:20:57.32 Index 2 (PSTORNED_SND_ID)
07:20:57.36 Index 3 (PSTORNED_RCV_ID)
07:20:57.42 Relation 151 (PSTORNED) is ok

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

07:20:57.42 Relation 157 (INVNT_TURNOVER_LOG)
07:20:57.42 process pointer page 0 of 2
07:20:57.44 process pointer page 1 of 2
07:20:57.44 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:20:57.44 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:20:57.44 Relation 160 (PERF_ESTIMATED)
07:20:57.44 process pointer page 0 of 2
07:20:57.53 process pointer page 1 of 2
07:20:57.58 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:20:57.66 Relation 160 (PERF_ESTIMATED) is ok

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

07:20:57.66 Relation 162 (TRACE_STAT)
07:20:57.66 process pointer page 0 of 1
07:20:57.66 Relation 162 (TRACE_STAT) is ok

07:20:57.66 Relation 163 (PERF_LOG)
07:20:57.66 process pointer page 0 of 163
07:20:57.75 process pointer page 1 of 163
07:20:57.83 process pointer page 2 of 163
07:20:57.91 process pointer page 3 of 163
07:20:58.00 process pointer page 4 of 163
07:20:58.08 process pointer page 5 of 163
07:20:58.16 process pointer page 6 of 163
07:20:58.24 process pointer page 7 of 163
07:20:58.33 process pointer page 8 of 163
07:20:58.41 process pointer page 9 of 163
07:20:58.49 process pointer page 10 of 163
07:20:58.56 process pointer page 11 of 163
07:20:58.66 process pointer page 12 of 163
07:20:58.74 process pointer page 13 of 163
07:20:58.81 process pointer page 14 of 163
07:20:58.89 process pointer page 15 of 163
07:20:58.98 process pointer page 16 of 163
07:20:59.06 process pointer page 17 of 163
07:20:59.14 process pointer page 18 of 163
07:20:59.22 process pointer page 19 of 163
07:20:59.33 process pointer page 20 of 163
07:20:59.36 process pointer page 21 of 163
07:20:59.39 process pointer page 22 of 163
07:20:59.42 process pointer page 23 of 163
07:20:59.48 process pointer page 24 of 163
07:20:59.56 process pointer page 25 of 163
07:20:59.64 process pointer page 26 of 163
07:20:59.72 process pointer page 27 of 163
07:20:59.81 process pointer page 28 of 163
07:20:59.89 process pointer page 29 of 163
07:20:59.97 process pointer page 30 of 163
07:21:00.05 process pointer page 31 of 163
07:21:00.12 process pointer page 32 of 163
07:21:00.20 process pointer page 33 of 163
07:21:00.30 process pointer page 34 of 163
07:21:00.37 process pointer page 35 of 163
07:21:00.45 process pointer page 36 of 163
07:21:00.53 process pointer page 37 of 163
07:21:00.61 process pointer page 38 of 163
07:21:00.69 process pointer page 39 of 163
07:21:00.76 process pointer page 40 of 163
07:21:00.84 process pointer page 41 of 163
07:21:00.92 process pointer page 42 of 163
07:21:01.01 process pointer page 43 of 163
07:21:01.09 process pointer page 44 of 163
07:21:01.17 process pointer page 45 of 163
07:21:01.25 process pointer page 46 of 163
07:21:01.32 process pointer page 47 of 163
07:21:01.42 process pointer page 48 of 163
07:21:01.50 process pointer page 49 of 163
07:21:01.57 process pointer page 50 of 163
07:21:01.65 process pointer page 51 of 163
07:21:01.75 process pointer page 52 of 163
07:21:01.82 process pointer page 53 of 163
07:21:01.90 process pointer page 54 of 163
07:21:01.98 process pointer page 55 of 163
07:21:02.06 process pointer page 56 of 163
07:21:02.14 process pointer page 57 of 163
07:21:02.21 process pointer page 58 of 163
07:21:02.29 process pointer page 59 of 163
07:21:02.39 process pointer page 60 of 163
07:21:02.46 process pointer page 61 of 163
07:21:02.54 process pointer page 62 of 163
07:21:02.62 process pointer page 63 of 163
07:21:02.70 process pointer page 64 of 163
07:21:02.79 process pointer page 65 of 163
07:21:02.87 process pointer page 66 of 163
07:21:02.95 process pointer page 67 of 163
07:21:03.03 process pointer page 68 of 163
07:21:03.10 process pointer page 69 of 163
07:21:03.20 process pointer page 70 of 163
07:21:03.27 process pointer page 71 of 163
07:21:03.35 process pointer page 72 of 163
07:21:03.43 process pointer page 73 of 163
07:21:03.51 process pointer page 74 of 163
07:21:03.60 process pointer page 75 of 163
07:21:03.68 process pointer page 76 of 163
07:21:03.76 process pointer page 77 of 163
07:21:03.84 process pointer page 78 of 163
07:21:03.91 process pointer page 79 of 163
07:21:04.01 process pointer page 80 of 163
07:21:04.09 process pointer page 81 of 163
07:21:04.16 process pointer page 82 of 163
07:21:04.26 process pointer page 83 of 163
07:21:04.34 process pointer page 84 of 163
07:21:04.41 process pointer page 85 of 163
07:21:04.51 process pointer page 86 of 163
07:21:04.55 process pointer page 87 of 163
07:21:04.59 process pointer page 88 of 163
07:21:04.68 process pointer page 89 of 163
07:21:04.76 process pointer page 90 of 163
07:21:04.83 process pointer page 91 of 163
07:21:04.91 process pointer page 92 of 163
07:21:04.99 process pointer page 93 of 163
07:21:05.07 process pointer page 94 of 163
07:21:05.15 process pointer page 95 of 163
07:21:05.24 process pointer page 96 of 163
07:21:05.32 process pointer page 97 of 163
07:21:05.40 process pointer page 98 of 163
07:21:05.47 process pointer page 99 of 163
07:21:05.55 process pointer page 100 of 163
07:21:05.65 process pointer page 101 of 163
07:21:05.72 process pointer page 102 of 163
07:21:05.80 process pointer page 103 of 163
07:21:05.88 process pointer page 104 of 163
07:21:05.96 process pointer page 105 of 163
07:21:06.05 process pointer page 106 of 163
07:21:06.13 process pointer page 107 of 163
07:21:06.21 process pointer page 108 of 163
07:21:06.29 process pointer page 109 of 163
07:21:06.36 process pointer page 110 of 163
07:21:06.44 process pointer page 111 of 163
07:21:06.54 process pointer page 112 of 163
07:21:06.61 process pointer page 113 of 163
07:21:06.69 process pointer page 114 of 163
07:21:06.77 process pointer page 115 of 163
07:21:06.86 process pointer page 116 of 163
07:21:06.94 process pointer page 117 of 163
07:21:07.02 process pointer page 118 of 163
07:21:07.11 process pointer page 119 of 163
07:21:07.19 process pointer page 120 of 163
07:21:07.27 process pointer page 121 of 163
07:21:07.35 process pointer page 122 of 163
07:21:07.42 process pointer page 123 of 163
07:21:07.52 process pointer page 124 of 163
07:21:07.60 process pointer page 125 of 163
07:21:07.67 process pointer page 126 of 163
07:21:07.75 process pointer page 127 of 163
07:21:07.83 process pointer page 128 of 163
07:21:07.92 process pointer page 129 of 163
07:21:08.00 process pointer page 130 of 163
07:21:08.08 process pointer page 131 of 163
07:21:08.17 process pointer page 132 of 163
07:21:08.25 process pointer page 133 of 163
07:21:08.34 process pointer page 134 of 163
07:21:08.42 process pointer page 135 of 163
07:21:08.50 process pointer page 136 of 163
07:21:08.58 process pointer page 137 of 163
07:21:08.67 process pointer page 138 of 163
07:21:08.75 process pointer page 139 of 163
07:21:08.83 process pointer page 140 of 163
07:21:08.92 process pointer page 141 of 163
07:21:09.00 process pointer page 142 of 163
07:21:09.08 process pointer page 143 of 163
07:21:09.16 process pointer page 144 of 163
07:21:09.25 process pointer page 145 of 163
07:21:09.33 process pointer page 146 of 163
07:21:09.41 process pointer page 147 of 163
07:21:09.50 process pointer page 148 of 163
07:21:09.58 process pointer page 149 of 163
07:21:09.66 process pointer page 150 of 163
07:21:09.69 process pointer page 151 of 163
07:21:09.72 process pointer page 152 of 163
07:21:09.76 process pointer page 153 of 163
07:21:09.80 process pointer page 154 of 163
07:21:09.83 process pointer page 155 of 163
07:21:09.89 process pointer page 156 of 163
07:21:09.97 process pointer page 157 of 163
07:21:10.05 process pointer page 158 of 163
07:21:10.14 process pointer page 159 of 163
07:21:10.22 process pointer page 160 of 163
07:21:10.29 process pointer page 161 of 163
07:21:10.37 process pointer page 162 of 163
07:21:10.40 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:21:14.82 Index 2 (PERF_LOG_UNIT)
07:21:21.06 Index 3 (PERF_LOG_TRN_DESC)
07:21:24.10 Index 4 (PERF_LOG_GDSCODE)
07:21:26.75 Relation 163 (PERF_LOG) is ok

07:21:26.75 Relation 167 (V_STOPTEST)
07:21:26.75 Relation 167 (V_STOPTEST) is ok

07:21:26.75 Relation 184 (V_QDISTR_SOURCE)
07:21:26.75 Relation 184 (V_QDISTR_SOURCE) is ok

07:21:26.75 Relation 185 (V_QSTORNED_SOURCE)
07:21:26.75 Relation 185 (V_QSTORNED_SOURCE) is ok

07:21:26.75 Relation 260 (XQD_1000_1200)
07:21:26.75 process pointer page 0 of 2
07:21:26.78 process pointer page 1 of 2
07:21:26.78 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:21:26.80 Relation 260 (XQD_1000_1200) is ok

07:21:26.80 Relation 261 (XQD_1200_2000)
07:21:26.80 process pointer page 0 of 4
07:21:26.86 process pointer page 1 of 4
07:21:26.88 process pointer page 2 of 4
07:21:26.88 process pointer page 3 of 4
07:21:26.88 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:21:26.88 Relation 261 (XQD_1200_2000) is ok

07:21:26.88 Relation 262 (XQD_1000_3300)
07:21:26.88 process pointer page 0 of 11
07:21:26.97 process pointer page 1 of 11
07:21:27.06 process pointer page 2 of 11
07:21:27.16 process pointer page 3 of 11
07:21:27.25 process pointer page 4 of 11
07:21:27.33 process pointer page 5 of 11
07:21:27.42 process pointer page 6 of 11
07:21:27.52 process pointer page 7 of 11
07:21:27.61 process pointer page 8 of 11
07:21:27.69 process pointer page 9 of 11
07:21:27.78 process pointer page 10 of 11
07:21:27.86 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:21:28.33 Index 2 (XQD_1000_3300_DOC)
07:21:28.69 Relation 262 (XQD_1000_3300) is ok

07:21:28.69 Relation 263 (XQD_2000_3300)
07:21:28.69 process pointer page 0 of 17
07:21:28.78 process pointer page 1 of 17
07:21:28.89 process pointer page 2 of 17
07:21:28.98 process pointer page 3 of 17
07:21:29.08 process pointer page 4 of 17
07:21:29.17 process pointer page 5 of 17
07:21:29.28 process pointer page 6 of 17
07:21:29.37 process pointer page 7 of 17
07:21:29.47 process pointer page 8 of 17
07:21:29.55 process pointer page 9 of 17
07:21:29.64 process pointer page 10 of 17
07:21:29.73 process pointer page 11 of 17
07:21:29.83 process pointer page 12 of 17
07:21:29.92 process pointer page 13 of 17
07:21:30.01 process pointer page 14 of 17
07:21:30.09 process pointer page 15 of 17
07:21:30.17 process pointer page 16 of 17
07:21:30.17 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:21:30.76 Relation 263 (XQD_2000_3300) is ok

07:21:30.76 Relation 264 (XQD_2100_3300)
07:21:30.76 process pointer page 0 of 3
07:21:30.79 process pointer page 1 of 3
07:21:30.81 process pointer page 2 of 3
07:21:30.81 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:21:30.81 Relation 264 (XQD_2100_3300) is ok

07:21:30.81 Relation 265 (XQD_3300_3400)
07:21:30.81 process pointer page 0 of 23
07:21:30.90 process pointer page 1 of 23
07:21:31.00 process pointer page 2 of 23
07:21:31.09 process pointer page 3 of 23
07:21:31.18 process pointer page 4 of 23
07:21:31.26 process pointer page 5 of 23
07:21:31.37 process pointer page 6 of 23
07:21:31.45 process pointer page 7 of 23
07:21:31.54 process pointer page 8 of 23
07:21:31.64 process pointer page 9 of 23
07:21:31.73 process pointer page 10 of 23
07:21:31.82 process pointer page 11 of 23
07:21:31.93 process pointer page 12 of 23
07:21:32.03 process pointer page 13 of 23
07:21:32.12 process pointer page 14 of 23
07:21:32.21 process pointer page 15 of 23
07:21:32.31 process pointer page 16 of 23
07:21:32.38 process pointer page 17 of 23
07:21:32.48 process pointer page 18 of 23
07:21:32.57 process pointer page 19 of 23
07:21:32.67 process pointer page 20 of 23
07:21:32.71 process pointer page 21 of 23
07:21:32.76 process pointer page 22 of 23
07:21:32.84 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:21:33.43 Relation 265 (XQD_3300_3400) is ok

07:21:33.43 Relation 266 (XQS_1000_1200)
07:21:33.45 process pointer page 0 of 45
07:21:33.52 process pointer page 1 of 45
07:21:33.62 process pointer page 2 of 45
07:21:33.71 process pointer page 3 of 45
07:21:33.80 process pointer page 4 of 45
07:21:33.90 process pointer page 5 of 45
07:21:33.98 process pointer page 6 of 45
07:21:34.07 process pointer page 7 of 45
07:21:34.16 process pointer page 8 of 45
07:21:34.26 process pointer page 9 of 45
07:21:34.35 process pointer page 10 of 45
07:21:34.44 process pointer page 11 of 45
07:21:34.52 process pointer page 12 of 45
07:21:34.62 process pointer page 13 of 45
07:21:34.71 process pointer page 14 of 45
07:21:34.79 process pointer page 15 of 45
07:21:34.88 process pointer page 16 of 45
07:21:34.97 process pointer page 17 of 45
07:21:35.07 process pointer page 18 of 45
07:21:35.16 process pointer page 19 of 45
07:21:35.27 process pointer page 20 of 45
07:21:35.36 process pointer page 21 of 45
07:21:35.44 process pointer page 22 of 45
07:21:35.54 process pointer page 23 of 45
07:21:35.63 process pointer page 24 of 45
07:21:35.71 process pointer page 25 of 45
07:21:35.80 process pointer page 26 of 45
07:21:35.89 process pointer page 27 of 45
07:21:35.99 process pointer page 28 of 45
07:21:36.08 process pointer page 29 of 45
07:21:36.18 process pointer page 30 of 45
07:21:36.25 process pointer page 31 of 45
07:21:36.35 process pointer page 32 of 45
07:21:36.44 process pointer page 33 of 45
07:21:36.52 process pointer page 34 of 45
07:21:36.61 process pointer page 35 of 45
07:21:36.71 process pointer page 36 of 45
07:21:36.78 process pointer page 37 of 45
07:21:36.88 process pointer page 38 of 45
07:21:36.96 process pointer page 39 of 45
07:21:36.99 process pointer page 40 of 45
07:21:37.08 process pointer page 41 of 45
07:21:37.17 process pointer page 42 of 45
07:21:37.27 process pointer page 43 of 45
07:21:37.35 process pointer page 44 of 45
07:21:37.36 Index 1 (XQS_1000_1200_DOC_ID)
07:21:38.78 Index 2 (XQS_1000_1200_SND_ID)
07:21:40.23 Index 3 (XQS_1000_1200_RCV_ID)
07:21:41.46 Relation 266 (XQS_1000_1200) is ok

07:21:41.46 Relation 267 (XQS_1200_2000)
07:21:41.46 process pointer page 0 of 48
07:21:41.56 process pointer page 1 of 48
07:21:41.65 process pointer page 2 of 48
07:21:41.74 process pointer page 3 of 48
07:21:41.84 process pointer page 4 of 48
07:21:41.93 process pointer page 5 of 48
07:21:42.03 process pointer page 6 of 48
07:21:42.13 process pointer page 7 of 48
07:21:42.23 process pointer page 8 of 48
07:21:42.32 process pointer page 9 of 48
07:21:42.43 process pointer page 10 of 48
07:21:42.54 process pointer page 11 of 48
07:21:42.65 process pointer page 12 of 48
07:21:42.76 process pointer page 13 of 48
07:21:42.85 process pointer page 14 of 48
07:21:42.96 process pointer page 15 of 48
07:21:43.07 process pointer page 16 of 48
07:21:43.18 process pointer page 17 of 48
07:21:43.29 process pointer page 18 of 48
07:21:43.40 process pointer page 19 of 48
07:21:43.51 process pointer page 20 of 48
07:21:43.62 process pointer page 21 of 48
07:21:43.73 process pointer page 22 of 48
07:21:43.83 process pointer page 23 of 48
07:21:43.94 process pointer page 24 of 48
07:21:44.05 process pointer page 25 of 48
07:21:44.16 process pointer page 26 of 48
07:21:44.24 process pointer page 27 of 48
07:21:44.29 process pointer page 28 of 48
07:21:44.40 process pointer page 29 of 48
07:21:44.51 process pointer page 30 of 48
07:21:44.57 process pointer page 31 of 48
07:21:44.65 process pointer page 32 of 48
07:21:44.74 process pointer page 33 of 48
07:21:44.86 process pointer page 34 of 48
07:21:44.97 process pointer page 35 of 48
07:21:45.07 process pointer page 36 of 48
07:21:45.18 process pointer page 37 of 48
07:21:45.27 process pointer page 38 of 48
07:21:45.35 process pointer page 39 of 48
07:21:45.41 process pointer page 40 of 48
07:21:45.49 process pointer page 41 of 48
07:21:45.58 process pointer page 42 of 48
07:21:45.68 process pointer page 43 of 48
07:21:45.78 process pointer page 44 of 48
07:21:45.89 process pointer page 45 of 48
07:21:46.00 process pointer page 46 of 48
07:21:46.11 process pointer page 47 of 48
07:21:46.19 Index 1 (XQS_1200_2000_DOC_ID)
07:21:47.91 Index 2 (XQS_1200_2000_SND_ID)
07:21:49.70 Index 3 (XQS_1200_2000_RCV_ID)
07:21:51.10 Relation 267 (XQS_1200_2000) is ok

07:21:51.10 Relation 268 (XQS_1000_3300)
07:21:51.10 process pointer page 0 of 23
07:21:51.59 process pointer page 1 of 23
07:21:52.09 process pointer page 2 of 23
07:21:52.57 process pointer page 3 of 23
07:21:53.07 process pointer page 4 of 23
07:21:53.57 process pointer page 5 of 23
07:21:54.07 process pointer page 6 of 23
07:21:54.57 process pointer page 7 of 23
07:21:54.96 process pointer page 8 of 23
07:21:55.30 process pointer page 9 of 23
07:21:55.66 process pointer page 10 of 23
07:21:56.00 process pointer page 11 of 23
07:21:56.36 process pointer page 12 of 23
07:21:56.69 process pointer page 13 of 23
07:21:57.05 process pointer page 14 of 23
07:21:57.45 process pointer page 15 of 23
07:21:57.83 process pointer page 16 of 23
07:21:58.19 process pointer page 17 of 23
07:21:58.58 process pointer page 18 of 23
07:21:58.95 process pointer page 19 of 23
07:21:59.36 process pointer page 20 of 23
07:21:59.70 process pointer page 21 of 23
07:22:00.11 process pointer page 22 of 23
07:22:00.21 Index 1 (XQS_1000_3300_DOC_ID)
07:22:01.57 Index 2 (XQS_1000_3300_SND_ID)
07:22:03.15 Index 3 (XQS_1000_3300_RCV_ID)
07:22:04.82 Relation 268 (XQS_1000_3300) is ok

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

07:22:04.82 Relation 270 (XQS_2100_3300)
07:22:04.82 process pointer page 0 of 32
07:22:05.32 process pointer page 1 of 32
07:22:05.82 process pointer page 2 of 32
07:22:06.28 process pointer page 3 of 32
07:22:06.78 process pointer page 4 of 32
07:22:07.28 process pointer page 5 of 32
07:22:07.78 process pointer page 6 of 32
07:22:08.28 process pointer page 7 of 32
07:22:08.76 process pointer page 8 of 32
07:22:09.28 process pointer page 9 of 32
07:22:09.76 process pointer page 10 of 32
07:22:10.23 process pointer page 11 of 32
07:22:10.67 process pointer page 12 of 32
07:22:11.10 process pointer page 13 of 32
07:22:11.59 process pointer page 14 of 32
07:22:12.02 process pointer page 15 of 32
07:22:12.46 process pointer page 16 of 32
07:22:12.94 process pointer page 17 of 32
07:22:13.41 process pointer page 18 of 32
07:22:13.82 process pointer page 19 of 32
07:22:14.27 process pointer page 20 of 32
07:22:14.69 process pointer page 21 of 32
07:22:15.13 process pointer page 22 of 32
07:22:15.57 process pointer page 23 of 32
07:22:16.00 process pointer page 24 of 32
07:22:16.44 process pointer page 25 of 32
07:22:16.89 process pointer page 26 of 32
07:22:17.31 process pointer page 27 of 32
07:22:17.76 process pointer page 28 of 32
07:22:18.19 process pointer page 29 of 32
07:22:18.62 process pointer page 30 of 32
07:22:19.06 process pointer page 31 of 32
07:22:19.22 Index 1 (XQS_2100_3300_DOC_ID)
07:22:20.70 Index 2 (XQS_2100_3300_SND_ID)
07:22:22.94 Index 3 (XQS_2100_3300_RCV_ID)
07:22:25.38 Relation 270 (XQS_2100_3300) is ok

07:22:25.38 Relation 271 (XQS_3300_3400)
07:22:25.38 process pointer page 0 of 6
07:22:25.88 process pointer page 1 of 6
07:22:26.38 process pointer page 2 of 6
07:22:26.89 process pointer page 3 of 6
07:22:27.34 process pointer page 4 of 6
07:22:27.81 process pointer page 5 of 6
07:22:28.17 Index 1 (XQS_3300_3400_DOC_ID)
07:22:28.61 Index 2 (XQS_3300_3400_SND_ID)
07:22:29.01 Relation 271 (XQS_3300_3400) is ok

07:22:29.04 Validation finished
Done for 98340 ms, from 7:20:50.78 to 7:22:29.12.

Differences between old and current firebird.log

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

End of gathering firebird.log AFTER test finish.

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

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

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-10-09 7:22:40.24 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html