Tests

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

Server and database settings

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

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2018-06-05 06:46:41.0500 -1 <null> ::1/55207 441712 8736 2

Current test settings

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

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

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

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 1500.31 27627 270056 2018-06-05 03:46 2018-06-05 06:46
customer order: creation 167.81 874 30206 2018-06-05 03:46 2018-06-05 06:46
customer order: refuse 13.58 636 2444 2018-06-05 03:46 2018-06-05 06:46
order to supplier: creation 42.64 18602 7675 2018-06-05 03:46 2018-06-05 06:46
order to supplier: removal 0.74 89942 131 2018-06-05 03:46 2018-06-05 06:46
invoice (draft): creation 43.32 20994 7797 2018-06-05 03:46 2018-06-05 06:46
invoice (draft): removal 8.81 2877 1586 2018-06-05 03:46 2018-06-05 06:46
invoice accept: apply 21.73 96665 3912 2018-06-05 03:46 2018-06-05 06:46
invoice accept: cancel 3.68 18577 663 2018-06-05 03:46 2018-06-05 06:46
customer reserve: creation 846.28 2237 152330 2018-06-05 03:46 2018-06-05 06:46
customer reserve: removal 133.97 529 24114 2018-06-05 03:46 2018-06-05 06:46
realization accept: apply 71.41 1887 12853 2018-06-05 03:46 2018-06-05 06:46
realization accept: cancel 28.65 1024 5157 2018-06-05 03:46 2018-06-05 06:46
payment from customer: creation 56.76 3857 10216 2018-06-05 03:46 2018-06-05 06:46
payment from customer: removal 5.18 290 933 2018-06-05 03:46 2018-06-05 06:46
payment to supplier: creation 45.78 7491 8241 2018-06-05 03:46 2018-06-05 06:46
payment to supplier: removal 3.22 331 579 2018-06-05 03:46 2018-06-05 06:46
service: total inventory turnovers 0.31 191323 56 2018-06-05 03:46 2018-06-05 06:46
service: total monetary turnovers 6.39 3645 1151 2018-06-05 03:46 2018-06-05 06:46
service: refresh index statistics 0.07 63136 12 2018-06-05 03:46 2018-06-05 06:46
Done for 30120 ms, from 6:48:50.25 to 6:49:20.37.

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 866 19847 15579 4268 21.50 03:46:41 04:04:41
interval # 2, overall 2 557 11668 10031 1637 14.03 04:04:42 04:22:42
interval # 3, overall 3 1054 21659 18970 2689 12.42 04:22:43 04:40:43
interval # 4, overall 4 1482 29435 26671 2764 9.39 04:40:44 04:58:44
interval # 5, overall 5 1743 33704 31372 2332 6.92 04:58:45 05:16:45
interval # 6, overall 6 1929 37943 34715 3228 8.51 05:16:46 05:34:46
interval # 7, overall 7 1725 34272 31058 3214 9.38 05:34:47 05:52:47
interval # 8, overall 8 1730 33627 31144 2483 7.38 05:52:48 06:10:48
interval # 9, overall 9 1950 37202 35100 2102 5.65 06:10:49 06:28:49
interval # 10, overall 10 1968 38212 35416 2796 7.32 06:28:50 06:46:50
Done for 49110 ms, from 6:50:04.52 to 6:50:53.63.

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 1759.18 0.3962 1.4819 1843 99
TEST_TIME 2 1624.61 0.8023 1.1922 1354 81
TEST_TIME 3 1480.45 0.8727 1.1264 1092 73
TEST_TIME 4 1352.16 0.9253 1.0756 897 70
TEST_TIME 5 1243.59 0.9356 1.0654 699 61
TEST_TIME 6 1156.66 0.9546 1.0443 659 59
TEST_TIME 7 1080.17 0.9587 1.0523 523 63
TEST_TIME 8 1035.88 0.9602 1.0423 474 55
TEST_TIME 9 994.85 0.9650 1.0460 454 58
TEST_TIME 10 962.43 0.9733 1.0297 465 55
TEST_TIME 11 925.71 0.9735 1.0260 444 52
TEST_TIME 12 895.03 0.9727 1.0237 355 50
TEST_TIME 13 876.45 0.9650 1.0282 394 51
TEST_TIME 14 852.24 0.9821 1.0204 355 51
TEST_TIME 15 824.81 0.9842 1.0200 328 52
TEST_TIME 16 800.19 0.9858 1.0135 318 46
TEST_TIME 17 791.65 0.9644 1.0217 295 47
TEST_TIME 18 773.30 0.9879 1.0184 339 45
TEST_TIME 19 758.16 0.9841 1.0171 333 49
TEST_TIME 20 747.88 0.9796 1.0167 321 51
TEST_TIME 21 739.17 0.9797 1.0260 344 53
TEST_TIME 22 744.00 0.9769 1.0149 385 57
TEST_TIME 23 736.41 0.9808 1.0115 402 54
TEST_TIME 24 723.84 0.9869 1.0120 348 50
TEST_TIME 25 711.39 0.9887 1.0101 255 51
TEST_TIME 26 697.33 0.9909 1.0088 223 43
TEST_TIME 27 688.68 0.9838 1.0136 335 52
TEST_TIME 28 684.99 0.9827 1.0187 300 55
TEST_TIME 29 684.80 0.9839 1.0134 388 55
TEST_TIME 30 679.38 0.9876 1.0156 339 57
TEST_TIME 31 677.14 0.9861 1.0172 358 57
TEST_TIME 32 679.74 0.9826 1.0142 427 63
TEST_TIME 33 676.64 0.9880 1.0113 422 64
TEST_TIME 34 671.14 0.9896 1.0130 357 63
TEST_TIME 35 670.70 0.9847 1.0129 397 68
TEST_TIME 36 672.28 0.9825 1.0200 437 75
TEST_TIME 37 675.89 0.9872 1.0112 455 67
TEST_TIME 38 676.15 0.9843 1.0194 489 70
TEST_TIME 39 684.89 0.9806 1.0219 474 73
TEST_TIME 40 692.92 0.9848 1.0127 461 71
TEST_TIME 41 692.78 0.9882 1.0154 402 66
TEST_TIME 42 695.03 0.9881 1.0126 359 63
TEST_TIME 43 699.52 0.9827 1.0153 340 67
TEST_TIME 44 704.95 0.9846 1.0175 550 72
TEST_TIME 45 711.01 0.9864 1.0146 562 73
TEST_TIME 46 715.77 0.9859 1.0143 529 71
TEST_TIME 47 723.77 0.9817 1.0199 556 76
TEST_TIME 48 735.70 0.9825 1.0193 534 76
TEST_TIME 49 747.40 0.9831 1.0205 514 82
TEST_TIME 50 759.70 0.9846 1.0139 540 70
TEST_TIME 51 770.14 0.9805 1.0228 535 84
TEST_TIME 52 783.82 0.9857 1.0123 652 78
TEST_TIME 53 791.36 0.9838 1.0143 680 84
TEST_TIME 54 803.00 0.9811 1.0157 690 80
TEST_TIME 55 816.25 0.9811 1.0171 642 85
TEST_TIME 56 824.18 0.9893 1.0134 591 83
TEST_TIME 57 832.51 0.9857 1.0158 491 83
TEST_TIME 58 849.45 0.9784 1.0162 761 88
TEST_TIME 59 863.70 0.9826 1.0160 799 93
TEST_TIME 60 873.68 0.9877 1.0103 712 86
TEST_TIME 61 883.55 0.9826 1.0188 727 92
TEST_TIME 62 896.54 0.9879 1.0150 674 91
TEST_TIME 63 907.81 0.9870 1.0128 734 95
TEST_TIME 64 917.57 0.9864 1.0135 644 91
TEST_TIME 65 926.49 0.9884 1.0105 581 85
TEST_TIME 66 935.45 0.9857 1.0127 615 85
TEST_TIME 67 945.57 0.9870 1.0104 593 85
TEST_TIME 68 951.64 0.9892 1.0102 593 84
TEST_TIME 69 959.83 0.9871 1.0167 488 83
TEST_TIME 70 974.53 0.9871 1.0103 548 89
TEST_TIME 71 977.36 0.9932 1.0070 522 78
TEST_TIME 72 976.36 0.9941 1.0059 538 71
TEST_TIME 73 975.58 0.9929 1.0074 523 74
TEST_TIME 74 978.76 0.9906 1.0116 554 83
TEST_TIME 75 987.06 0.9897 1.0129 522 89
TEST_TIME 76 999.41 0.9873 1.0077 591 83
TEST_TIME 77 1007.28 0.9872 1.0117 763 82
TEST_TIME 78 1024.16 0.9823 1.0147 854 90
TEST_TIME 79 1040.34 0.9872 1.0092 818 89
TEST_TIME 80 1047.63 0.9897 1.0119 793 84
TEST_TIME 81 1059.47 0.9883 1.0116 623 85
TEST_TIME 82 1067.71 0.9916 1.0086 669 79
TEST_TIME 83 1073.95 0.9907 1.0098 554 71
TEST_TIME 84 1087.07 0.9858 1.0133 630 82
TEST_TIME 85 1099.27 0.9903 1.0100 658 91
TEST_TIME 86 1103.85 0.9941 1.0078 512 80
TEST_TIME 87 1109.08 0.9915 1.0088 521 82
TEST_TIME 88 1116.05 0.9911 1.0094 578 90
TEST_TIME 89 1120.64 0.9939 1.0065 647 78
TEST_TIME 90 1123.90 0.9931 1.0068 566 77
TEST_TIME 91 1125.45 0.9944 1.0084 438 73
TEST_TIME 92 1135.28 0.9888 1.0089 597 85
TEST_TIME 93 1143.94 0.9905 1.0103 819 85
TEST_TIME 94 1158.58 0.9869 1.0106 833 88
TEST_TIME 95 1170.78 0.9895 1.0086 737 86
TEST_TIME 96 1181.46 0.9890 1.0084 771 90
TEST_TIME 97 1186.83 0.9935 1.0079 636 82
TEST_TIME 98 1191.78 0.9935 1.0088 562 86
TEST_TIME 99 1198.23 0.9932 1.0078 621 80
TEST_TIME 100 1204.91 0.9922 1.0071 593 79
TEST_TIME 101 1212.72 0.9908 1.0092 672 92
TEST_TIME 102 1220.86 0.9927 1.0078 594 88
TEST_TIME 103 1227.11 0.9930 1.0113 618 90
TEST_TIME 104 1236.36 0.9941 1.0069 602 91
TEST_TIME 105 1239.60 0.9947 1.0061 591 86
TEST_TIME 106 1244.43 0.9928 1.0070 632 92
TEST_TIME 107 1247.71 0.9949 1.0052 605 90
TEST_TIME 108 1249.79 0.9943 1.0072 619 84
TEST_TIME 109 1260.08 0.9898 1.0082 614 91
TEST_TIME 110 1265.36 0.9949 1.0041 460 81
TEST_TIME 111 1264.05 0.9961 1.0052 412 78
TEST_TIME 112 1268.03 0.9943 1.0059 539 86
TEST_TIME 113 1270.07 0.9954 1.0067 481 85
TEST_TIME 114 1272.34 0.9961 1.0051 501 86
TEST_TIME 115 1273.42 0.9955 1.0047 371 77
TEST_TIME 116 1278.07 0.9927 1.0050 449 83
TEST_TIME 117 1279.85 0.9950 1.0045 473 90
TEST_TIME 118 1279.88 0.9959 1.0047 512 86
TEST_TIME 119 1281.88 0.9947 1.0079 558 89
TEST_TIME 120 1289.06 0.9939 1.0049 663 89
TEST_TIME 121 1291.48 0.9948 1.0075 675 86
TEST_TIME 122 1298.05 0.9945 1.0070 635 87
TEST_TIME 123 1306.90 0.9918 1.0082 712 91
TEST_TIME 124 1313.20 0.9953 1.0051 682 84
TEST_TIME 125 1317.06 0.9942 1.0062 594 88
TEST_TIME 126 1321.51 0.9948 1.0053 501 78
TEST_TIME 127 1327.58 0.9929 1.0061 607 83
TEST_TIME 128 1331.85 0.9950 1.0060 538 83
TEST_TIME 129 1336.76 0.9946 1.0037 541 84
TEST_TIME 130 1341.06 0.9928 1.0059 530 89
TEST_TIME 131 1344.03 0.9960 1.0046 517 86
TEST_TIME 132 1346.63 0.9951 1.0044 522 83
TEST_TIME 133 1346.32 0.9971 1.0033 464 80
TEST_TIME 134 1349.20 0.9937 1.0048 503 88
TEST_TIME 135 1352.91 0.9946 1.0055 503 88
TEST_TIME 136 1356.66 0.9953 1.0044 493 82
TEST_TIME 137 1358.34 0.9960 1.0040 572 85
TEST_TIME 138 1361.24 0.9946 1.0049 519 86
TEST_TIME 139 1364.75 0.9951 1.0047 603 86
TEST_TIME 140 1368.21 0.9951 1.0040 562 84
TEST_TIME 141 1369.96 0.9956 1.0036 500 82
TEST_TIME 142 1370.26 0.9963 1.0029 418 73
TEST_TIME 143 1370.07 0.9960 1.0038 354 70
TEST_TIME 144 1370.32 0.9967 1.0032 405 70
TEST_TIME 145 1371.18 0.9957 1.0035 391 73
TEST_TIME 146 1373.79 0.9947 1.0040 383 72
TEST_TIME 147 1373.85 0.9971 1.0039 378 77
TEST_TIME 148 1374.65 0.9966 1.0032 437 77
TEST_TIME 149 1375.33 0.9960 1.0039 392 85
TEST_TIME 150 1375.77 0.9969 1.0039 418 72
TEST_TIME 151 1380.06 0.9942 1.0058 584 85
TEST_TIME 152 1385.88 0.9950 1.0051 604 87
TEST_TIME 153 1390.08 0.9955 1.0049 576 85
TEST_TIME 154 1397.07 0.9934 1.0073 564 91
TEST_TIME 155 1404.49 0.9955 1.0037 547 85
TEST_TIME 156 1407.52 0.9952 1.0041 577 82
TEST_TIME 157 1409.84 0.9961 1.0039 612 85
TEST_TIME 158 1414.44 0.9943 1.0064 609 84
TEST_TIME 159 1420.77 0.9956 1.0065 601 85
TEST_TIME 160 1429.64 0.9940 1.0046 702 89
TEST_TIME 161 1431.70 0.9969 1.0044 658 85
TEST_TIME 162 1438.00 0.9939 1.0046 804 92
TEST_TIME 163 1441.79 0.9958 1.0041 683 84
TEST_TIME 164 1445.28 0.9956 1.0038 538 78
TEST_TIME 165 1448.20 0.9957 1.0042 634 83
TEST_TIME 166 1450.03 0.9969 1.0029 567 75
TEST_TIME 167 1452.28 0.9953 1.0047 547 82
TEST_TIME 168 1458.59 0.9944 1.0047 520 83
TEST_TIME 169 1462.86 0.9959 1.0038 583 80
TEST_TIME 170 1467.56 0.9947 1.0046 536 88
TEST_TIME 171 1475.47 0.9934 1.0045 588 89
TEST_TIME 172 1477.48 0.9973 1.0047 508 84
TEST_TIME 173 1481.79 0.9960 1.0041 526 88
TEST_TIME 174 1485.56 0.9958 1.0034 456 81
TEST_TIME 175 1488.66 0.9956 1.0041 633 91
TEST_TIME 176 1491.37 0.9966 1.0029 632 89
TEST_TIME 177 1494.11 0.9954 1.0035 573 88
TEST_TIME 178 1495.11 0.9972 1.0034 487 79
TEST_TIME 179 1496.70 0.9967 1.0035 461 87
TEST_TIME 180 1497.23 0.9975 1.0020 411 100
Done for 9850 ms, from 6:50:54.11 to 6:51:03.96.

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 46605 76583 38220 <null> 45431 <null> 45974 213 14259 37629 38594 4212 37603 8997 75375 59650 <null> 361987 <null> 03:46:41 04:04:41
fetches per second 2 1464 1587 786 <null> 663 <null> 1675 <null> <null> <null> 1736 847 1860 <null> 1766 <null> <null> <null> <null> 04:04:42 04:22:42
fetches per second 3 1733 1717 925 <null> 984 <null> 1924 <null> 2166 1086 1484 <null> 2051 1637 1772 <null> <null> 5632 <null> 04:22:43 04:40:43
fetches per second 4 1920 1936 1049 1970 1152 <null> 2038 <null> 1148 1741 1696 1374 2463 1505 2182 <null> <null> 4421 <null> 04:40:44 04:58:44
fetches per second 5 1758 1761 1150 <null> 1188 <null> 2251 1936 1532 1889 1714 530 2362 1511 1813 <null> <null> 4029 <null> 04:58:45 05:16:45
fetches per second 6 1795 1845 1226 2053 1183 1605 2316 2049 1965 <null> 1477 452 1989 2021 2088 1019 <null> 3751 <null> 05:16:46 05:34:46
fetches per second 7 1789 2277 938 <null> 1225 1636 2234 <null> 1097 <null> 1368 512 2196 <null> 1946 1169 <null> 5760 <null> 05:34:47 05:52:47
fetches per second 8 1859 1199 877 <null> 1028 <null> 2338 <null> 2013 1349 1592 733 1893 1356 2049 1082 <null> 3079 <null> 05:52:48 06:10:48
fetches per second 9 1863 1807 1019 <null> 1221 <null> 2110 1824 2006 1661 1560 211 1878 1365 2047 <null> <null> 3884 <null> 06:10:49 06:28:49
fetches per second 10 1825 1880 991 <null> 1207 <null> 2019 1120 1435 2013 1644 744 2091 <null> 1846 <null> <null> <null> <null> 06:28:50 06:46:50
marks per second 1 10921 11926 9037 <null> 10767 <null> 3979 45 1421 8556 8421 884 2121 2258 2145 13753 <null> 28994 <null> 03:46:41 04:04:41
marks per second 2 319 217 72 <null> 61 <null> 275 <null> <null> <null> 285 160 108 <null> 41 <null> <null> <null> <null> 04:04:42 04:22:42
marks per second 3 371 255 107 <null> 119 <null> 307 <null> 279 242 220 <null> 87 503 124 <null> <null> 40 <null> 04:22:43 04:40:43
marks per second 4 410 286 112 358 131 <null> 279 <null> 141 385 266 312 72 368 33 <null> <null> 21 <null> 04:40:44 04:58:44
marks per second 5 383 265 140 <null> 158 <null> 254 346 186 419 304 109 101 367 60 <null> <null> 27 <null> 04:58:45 05:16:45
marks per second 6 382 246 162 370 155 398 203 347 503 <null> 258 97 54 432 45 222 <null> 23 <null> 05:16:46 05:34:46
marks per second 7 379 303 105 <null> 143 396 177 <null> 118 <null> 223 105 128 <null> 55 250 <null> 34 <null> 05:34:47 05:52:47
marks per second 8 395 219 86 <null> 111 <null> 166 <null> 116 309 233 152 59 368 37 241 <null> 24 <null> 05:52:48 06:10:48
marks per second 9 398 274 133 <null> 164 <null> 212 300 47 402 261 44 51 305 42 <null> <null> 21 <null> 06:10:49 06:28:49
marks per second 10 389 299 120 <null> 153 <null> 142 195 102 450 251 135 79 <null> 65 <null> <null> <null> <null> 06:28:50 06:46:50
reads/fetches*100 1 1 2 1 <null> 1 <null> 2 4 2 3 2 3 3 1 2 1 <null> 0 <null> 03:46:41 04:04:41
reads/fetches*100 2 2 5 5 <null> 4 <null> 2 <null> <null> <null> 5 4 5 <null> 3 <null> <null> <null> <null> 04:04:42 04:22:42
reads/fetches*100 3 2 4 4 <null> 3 <null> 4 <null> 5 3 4 <null> 2 3 5 <null> <null> 1 <null> 04:22:43 04:40:43
reads/fetches*100 4 2 4 3 4 4 <null> 3 <null> 3 3 4 4 2 3 3 <null> <null> 0 <null> 04:40:44 04:58:44
reads/fetches*100 5 2 4 3 <null> 3 <null> 2 4 3 4 4 5 3 3 3 <null> <null> 1 <null> 04:58:45 05:16:45
reads/fetches*100 6 2 5 2 3 3 4 2 2 2 <null> 5 3 4 2 3 3 <null> 1 <null> 05:16:46 05:34:46
reads/fetches*100 7 2 6 4 <null> 4 4 3 <null> 3 <null> 4 4 3 <null> 5 4 <null> 0 <null> 05:34:47 05:52:47
reads/fetches*100 8 2 3 4 <null> 4 <null> 3 <null> 3 3 5 3 4 3 3 3 <null> 1 <null> 05:52:48 06:10:48
reads/fetches*100 9 2 5 3 <null> 4 <null> 2 3 3 3 5 5 5 2 2 <null> <null> 1 <null> 06:10:49 06:28:49
reads/fetches*100 10 2 5 3 <null> 4 <null> 3 2 3 4 5 3 3 <null> 4 <null> <null> <null> <null> 06:28:50 06:46:50
writes/marks*100 1 0 1 0 <null> 0 <null> 0 0 1 0 0 0 0 0 0 0 <null> 2 <null> 03:46:41 04:04:41
writes/marks*100 2 0 0 0 <null> 0 <null> 0 <null> <null> <null> 0 0 0 <null> 0 <null> <null> <null> <null> 04:04:42 04:22:42
writes/marks*100 3 0 0 0 <null> 0 <null> 0 <null> 0 0 0 <null> 0 0 0 <null> <null> 1 <null> 04:22:43 04:40:43
writes/marks*100 4 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> <null> 0 <null> 04:40:44 04:58:44
writes/marks*100 5 0 0 0 <null> 0 <null> 0 0 1 1 0 0 0 0 0 <null> <null> 1 <null> 04:58:45 05:16:45
writes/marks*100 6 0 0 0 0 0 0 0 0 0 <null> 0 2 0 0 0 0 <null> 0 <null> 05:16:46 05:34:46
writes/marks*100 7 0 0 0 <null> 0 0 0 <null> 0 <null> 0 0 0 <null> 0 0 <null> 2 <null> 05:34:47 05:52:47
writes/marks*100 8 0 1 0 <null> 0 <null> 0 <null> 1 1 0 0 0 0 0 1 <null> 0 <null> 05:52:48 06:10:48
writes/marks*100 9 0 1 0 <null> 0 <null> 0 0 0 1 0 0 0 1 0 <null> <null> 0 <null> 06:10:49 06:28:49
writes/marks*100 10 1 0 0 <null> 0 <null> 0 0 1 0 0 0 0 <null> 0 <null> <null> <null> <null> 06:28:50 06:46:50
Done for 8240 ms, from 6:51:04.17 to 6:51:12.41.

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 469190 447483 21707 4.62 0 29172 339 21707 2018-06-05 03:46 2018-06-05 06:46
doc_list_biud 469404 447483 21921 4.66 0 13712 56 21921 2018-06-05 03:46 2018-06-05 06:46
sp_add_invoice_to_stock 7275 3912 3363 46.22 171 1542520 96665 3363 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_adding_invoice 1008 663 345 34.22 0 228594 18577 345 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_client_order 2480 2444 36 1.45 0 4649 636 36 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_customer_reserve 41442 24114 17328 41.81 0 16317 529 17328 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_pay_from_customer 943 933 10 1.06 0 1513 290 10 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_pay_to_supplier 579 579 0 0.00 0 1872 331 0 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_supplier_invoice 2193 1586 607 27.67 0 36116 2877 607 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_supplier_order 539 131 408 75.69 967 572076 89942 408 2018-06-05 03:46 2018-06-05 06:46
sp_cancel_write_off 9252 5157 4095 44.26 0 8018 1024 4095 2018-06-05 03:46 2018-06-05 06:46
sp_client_order 30206 30206 0 0.00 0 6911 874 0 2018-06-05 03:46 2018-06-05 06:46
sp_customer_reserve 152330 152330 0 0.00 0 36114 2237 0 2018-06-05 03:46 2018-06-05 06:46
sp_fill_shopping_cart 45709 45678 31 0.06 0 61409 3517 0 2018-06-05 03:46 2018-06-05 06:46
sp_fill_shopping_cart_clo_res 152330 152330 0 0.00 0 3401 72 0 2018-06-05 03:46 2018-06-05 06:46
sp_get_clo_for_invoice 3912 3912 0 0.00 0 27791 4230 0 2018-06-05 03:46 2018-06-05 06:46
sp_kill_cost_storno 11503 7332 4171 36.26 0 2886 70 4171 2018-06-05 03:46 2018-06-05 06:46
sp_kill_qstorno_ret_qs2qd 93967 55102 38865 41.36 0 13462 208 38865 2018-06-05 03:46 2018-06-05 06:46
sp_kill_qty_storno 72734 50860 21874 30.07 0 13618 423 21874 2018-06-05 03:46 2018-06-05 06:46
sp_lock_selected_doc 29510 23833 5677 19.23 0 562 16 5677 2018-06-05 03:46 2018-06-05 06:46
sp_make_cost_storno 35222 35222 0 0.00 0 28689 3148 0 2018-06-05 03:46 2018-06-05 06:46
sp_multiply_rows_for_pdistr 35222 35222 0 0.00 0 1123 85 0 2018-06-05 03:46 2018-06-05 06:46
sp_multiply_rows_for_qdistr 30206 30206 0 0.00 0 2231 321 0 2018-06-05 03:46 2018-06-05 06:46
sp_pay_from_customer 10216 10216 0 0.00 15 27955 3857 0 2018-06-05 03:46 2018-06-05 06:46
sp_pay_to_supplier 8241 8241 0 0.00 15 27736 7491 0 2018-06-05 03:46 2018-06-05 06:46
sp_payment_common 18457 18457 0 0.00 0 12355 281 0 2018-06-05 03:46 2018-06-05 06:46
sp_qd_handle_on_cancel_clo 2480 2444 36 1.45 0 2184 300 36 2018-06-05 03:46 2018-06-05 06:46
sp_qd_handle_on_invoice_upd_sts 4770 4575 195 4.08 0 8159 1106 195 2018-06-05 03:46 2018-06-05 06:46
sp_qd_handle_on_reserve_upd_sts 12853 12853 0 0.00 0 4134 240 0 2018-06-05 03:46 2018-06-05 06:46
sp_reserve_write_off 14143 12853 1290 9.12 0 32885 1887 1290 2018-06-05 03:46 2018-06-05 06:46
sp_supplier_invoice 7812 7797 15 0.19 15 80847 20994 0 2018-06-05 03:46 2018-06-05 06:46
sp_supplier_order 7691 7675 16 0.20 15 77159 18602 0 2018-06-05 03:46 2018-06-05 06:46
srv_find_qd_qs_mism 260963 239187 21776 8.34 0 13119 129 21776 2018-06-05 03:46 2018-06-05 06:46
srv_make_invnt_saldo 56 56 0 0.00 0 1070283 191323 0 2018-06-05 03:46 2018-06-05 06:46
srv_make_money_saldo 1151 1151 0 0.00 0 131479 3645 0 2018-06-05 03:46 2018-06-05 06:46
srv_recalc_idx_stat 12 12 0 0.00 40341 84693 63136 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_add_invoice_to_stock 3363 3363 0 0.00 0 437 68 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_cancel_adding_invoice 457 457 0 0.00 16 1341 408 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_cancel_client_order 36 36 0 0.00 31 203 95 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_cancel_customer_reserve 93 93 0 0.00 16 266 54 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_cancel_pay_from_customer 10 10 0 0.00 47 125 76 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_cancel_supplier_invoice 241 241 0 0.00 0 312 62 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_cancel_supplier_order 2525 2525 0 0.00 15 2637 544 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_cancel_write_off 28 28 0 0.00 31 172 63 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_reserve_write_off 1290 1290 0 0.00 0 1076 62 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_supplier_invoice 15 15 0 0.00 31 125 67 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-abend:sp_supplier_order 16 16 0 0.00 47 187 88 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_add_invoice_to_stock 3912 3912 0 0.00 0 18580 3411 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_adding_invoice 363 363 0 0.00 15 14820 3116 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_client_order 2444 2444 0 0.00 0 1435 105 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_customer_reserve 848 848 0 0.00 0 390 118 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_pay_from_customer 933 933 0 0.00 0 359 81 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_pay_to_supplier 579 579 0 0.00 0 531 85 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_supplier_invoice 313 313 0 0.00 15 390 110 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_supplier_order 131 131 0 0.00 31 52807 8432 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_cancel_write_off 1457 1457 0 0.00 0 1404 122 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_client_order 30206 30206 0 0.00 0 2948 137 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_customer_reserve 1431 1431 0 0.00 0 2995 104 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_pay_from_customer 10216 10216 0 0.00 0 2464 98 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_pay_to_supplier 8241 8241 0 0.00 0 2450 100 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_reserve_write_off 12853 12853 0 0.00 0 3058 131 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_supplier_invoice 7797 7797 0 0.00 0 2356 150 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:sp_supplier_order 7675 7675 0 0.00 0 1419 151 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:srv_make_invnt_saldo 56 56 0 0.00 0 312 52 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:srv_make_money_saldo 1151 1151 0 0.00 0 374 18 0 2018-06-05 03:46 2018-06-05 06:46
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 344 546 431 0 2018-06-05 03:46 2018-06-05 06:46
v_add_invoice_to_stock 14550 7824 6726 46.22 0 827 174 6726 2018-06-05 03:46 2018-06-05 06:46
v_all_customers 45238 45238 0 0.00 0 172 11 0 2018-06-05 03:46 2018-06-05 06:46
v_all_suppliers 31006 30944 62 0.19 0 188 14 0 2018-06-05 03:46 2018-06-05 06:46
v_all_wares 60412 60412 0 0.00 0 187 12 0 2018-06-05 03:46 2018-06-05 06:46
v_cancel_adding_invoice 1142 726 416 36.42 0 9172 1616 416 2018-06-05 03:46 2018-06-05 06:46
v_cancel_client_order 4960 4888 72 1.45 0 328 17 72 2018-06-05 03:46 2018-06-05 06:46
v_cancel_customer_prepayment 1886 1866 20 1.06 0 281 44 20 2018-06-05 03:46 2018-06-05 06:46
v_cancel_customer_reserve 1882 1696 186 9.88 0 671 61 186 2018-06-05 03:46 2018-06-05 06:46
v_cancel_payment_to_supplier 1158 1158 0 0.00 0 687 61 0 2018-06-05 03:46 2018-06-05 06:46
v_cancel_supplier_invoice 1108 626 482 43.50 0 593 177 482 2018-06-05 03:46 2018-06-05 06:46
v_cancel_supplier_order 1078 262 816 75.69 0 484 59 816 2018-06-05 03:46 2018-06-05 06:46
v_cancel_write_off 2970 2914 56 1.88 0 5710 697 56 2018-06-05 03:46 2018-06-05 06:46
v_max_id_clo_ord 7691 7675 16 0.20 0 2636 303 0 2018-06-05 03:46 2018-06-05 06:46
v_max_id_clo_res 1431 1431 0 0.00 0 405 53 0 2018-06-05 03:46 2018-06-05 06:46
v_max_id_ord_sup 7812 7797 15 0.19 0 2839 285 0 2018-06-05 03:46 2018-06-05 06:46
v_max_non_paid_invoice 8241 8241 0 0.00 0 250 26 0 2018-06-05 03:46 2018-06-05 06:46
v_max_non_paid_realizn 10216 10216 0 0.00 0 172 12 0 2018-06-05 03:46 2018-06-05 06:46
v_min_id_clo_ord 7691 7675 16 0.20 0 3697 306 0 2018-06-05 03:46 2018-06-05 06:46
v_min_id_clo_res 1431 1431 0 0.00 0 6115 249 0 2018-06-05 03:46 2018-06-05 06:46
v_min_id_ord_sup 7812 7797 15 0.19 0 3885 337 0 2018-06-05 03:46 2018-06-05 06:46
v_min_non_paid_invoice 8241 8241 0 0.00 0 3603 248 0 2018-06-05 03:46 2018-06-05 06:46
v_min_non_paid_realizn 10216 10216 0 0.00 0 1669 73 0 2018-06-05 03:46 2018-06-05 06:46
v_our_firm 15174 15174 0 0.00 0 187 14 0 2018-06-05 03:46 2018-06-05 06:46
v_reserve_write_off 28286 25706 2580 9.12 0 624 54 2580 2018-06-05 03:46 2018-06-05 06:46
x_lock_depdocs_on_canc_invoice 4094 1936 2158 52.71 0 3713 214 2158 2018-06-05 03:46 2018-06-05 06:46
x_lock_depdocs_on_canc_sup_ord 539 131 408 75.69 0 1654 232 408 2018-06-05 03:46 2018-06-05 06:46
x_make_qstorno_1000_1200 7691 7675 16 0.20 0 29281 8471 0 2018-06-05 03:46 2018-06-05 06:46
x_make_qstorno_1200_2000 7812 7797 15 0.19 0 44008 10593 0 2018-06-05 03:46 2018-06-05 06:46
x_make_qstorno_2100_3300 152330 152330 0 0.00 0 35708 2075 0 2018-06-05 03:46 2018-06-05 06:46
Done for 85380 ms, from 6:52:28.24 to 6:53:53.62.

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 45 sp_kill_cost_storno 335544336 2018-06-05 03:47 2018-06-05 06:46
deadlock 20 sp_kill_qstorno_ret_qs2qd 335544336 2018-06-05 03:48 2018-06-05 06:34
deadlock 5020 sp_lock_selected_doc 335544336 2018-06-05 03:46 2018-06-05 06:46
deadlock 36 sp_qd_handle_on_cancel_clo 335544336 2018-06-05 03:47 2018-06-05 06:39
deadlock 104 sp_qd_handle_on_invoice_upd_sts 335544336 2018-06-05 03:48 2018-06-05 06:36
deadlock 362 x_lock_depdocs_on_canc_invoice 335544336 2018-06-05 03:47 2018-06-05 06:44
deadlock 86 x_lock_depdocs_on_canc_sup_ord 335544336 2018-06-05 03:48 2018-06-05 06:45
user_exc 16 x_make_qstorno_1000_1200 335544517 2018-06-05 03:47 2018-06-05 06:46
user_exc 15 x_make_qstorno_1200_2000 335544517 2018-06-05 03:48 2018-06-05 06:46
Done for 3680 ms, from 6:53:55.59 to 6:53:59.27.

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 444998
MON$OLDEST_ACTIVE 444999
MON$OLDEST_SNAPSHOT 444999
MON$NEXT_TRANSACTION 444999
MON$PAGE_BUFFERS 8192
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 426496
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.4.32984 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.4.32984 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.4.32984 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.4.32984 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Gstat execution time Tue Jun 05 06:53:59 2018

Database header page information:
Flags 0
Generation 445167
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 445000
Oldest active 445001
Oldest snapshot 445001
Next transaction 445002
Sequence number 0
Next attachment ID 8946
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: 46.42, total records: 1216681
Average version length: 46.31, total versions: 2061, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.38
Pointer pages: 9, data page slots: 13360
Data pages: 13360, average fill: 71%
Primary pages: 13360, secondary pages: 0, swept pages: 10520
Empty pages: 3, full pages: 6679
Fill distribution:
0 - 19% = 4
20 - 39% = 11
40 - 59% = 212
60 - 79% = 13132
80 - 99% = 1

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 4546, nodes: 1216681
Average node length: 18.42, total dup: 0, max dup: 0
Average key length: 15.50, compression ratio: 1.74
Average prefix length: 14.50, average data length: 12.50
Clustering factor: 237312, ratio: 0.20
Fill distribution:
0 - 19% = 310
20 - 39% = 42
40 - 59% = 2426
60 - 79% = 452
80 - 99% = 1316

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 3926, nodes: 1216681
Average node length: 11.77, total dup: 0, max dup: 0
Average key length: 8.85, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 162568, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 481
40 - 59% = 3445
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 177294, depth: 3, leaf buckets: 1561, nodes: 1216681
Average node length: 6.33, total dup: 974584, max dup: 49
Average key length: 3.41, compression ratio: 2.64
Average prefix length: 7.79, average data length: 1.21
Clustering factor: 224700, ratio: 0.18
Fill distribution:
0 - 19% = 20
20 - 39% = 35
40 - 59% = 1004
60 - 79% = 27
80 - 99% = 475

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 59.38, total records: 279447
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 5.83, total fragments: 12, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.62
Pointer pages: 3, data page slots: 3616
Data pages: 3616, average fill: 73%
Primary pages: 3615, secondary pages: 1, swept pages: 3546
Empty pages: 7, full pages: 2180
Fill distribution:
0 - 19% = 9
20 - 39% = 5
40 - 59% = 25
60 - 79% = 3568
80 - 99% = 9

Index DOC_LIST_ID_DESC (1)
Root page: 282978, depth: 3, leaf buckets: 920, nodes: 279447
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 9.02, compression ratio: 1.00
Average prefix length: 2.98, average data length: 6.02
Clustering factor: 38737, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 138
40 - 59% = 782
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 289, nodes: 279447
Average node length: 4.70, total dup: 279397, max dup: 27514
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 123249, ratio: 0.44
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 254
60 - 79% = 15
80 - 99% = 20

Index PK_DOC_LIST (0)
Root page: 333084, depth: 3, leaf buckets: 755, nodes: 279447
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 9.01, compression ratio: 1.00
Average prefix length: 2.98, average data length: 6.02
Clustering factor: 38737, ratio: 0.14
Fill distribution:
0 - 19% = 13
20 - 39% = 36
40 - 59% = 566
60 - 79% = 1
80 - 99% = 139

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: 65.22, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.41, total fragments: 391, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.59
Pointer pages: 1, data page slots: 136
Data pages: 20, average fill: 30%
Primary pages: 8, secondary pages: 12, swept pages: 4
Empty pages: 7, full pages: 3
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 3
60 - 79% = 1
80 - 99% = 3

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 70.98, total records: 35795
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: 96.00, compression ratio: 1.35
Pointer pages: 3, data page slots: 3080
Data pages: 1193, average fill: 34%
Primary pages: 1193, secondary pages: 0, swept pages: 981
Empty pages: 153, full pages: 169
Fill distribution:
0 - 19% = 442
20 - 39% = 342
40 - 59% = 128
60 - 79% = 281
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 201900, depth: 3, leaf buckets: 154, nodes: 35795
Average node length: 14.43, total dup: 1197, max dup: 2
Average key length: 11.75, compression ratio: 2.30
Average prefix length: 18.21, average data length: 8.79
Clustering factor: 32735, ratio: 0.91
Fill distribution:
0 - 19% = 2
20 - 39% = 84
40 - 59% = 47
60 - 79% = 20
80 - 99% = 1

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

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 44.57, total records: 35
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.44
Pointer pages: 1, data page slots: 64
Data pages: 16, average fill: 3%
Primary pages: 16, secondary pages: 0, swept pages: 12
Empty pages: 11, full pages: 0
Fill distribution:
0 - 19% = 15
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 178591, depth: 2, leaf buckets: 1, nodes: 35
Average node length: 11.40, total dup: 19, max dup: 9
Average key length: 9.37, compression ratio: 2.03
Average prefix length: 12.06, average data length: 6.94
Clustering factor: 9, ratio: 0.26
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.04, total records: 149296
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 33.00, total fragments: 16, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 2136
Data pages: 2136, average fill: 53%
Primary pages: 2125, secondary pages: 11, swept pages: 2118
Empty pages: 10, full pages: 19
Fill distribution:
0 - 19% = 21
20 - 39% = 176
40 - 59% = 1411
60 - 79% = 528
80 - 99% = 0

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 155, nodes: 149296
Average node length: 4.48, total dup: 149247, max dup: 9430
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 22377, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 33
40 - 59% = 69
60 - 79% = 45
80 - 99% = 7

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 180, nodes: 149296
Average node length: 5.43, total dup: 134872, max dup: 43
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 26387, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 24
40 - 59% = 86
60 - 79% = 56
80 - 99% = 14

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 181, nodes: 149296
Average node length: 5.43, total dup: 134872, max dup: 43
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 26392, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 79
60 - 79% = 51
80 - 99% = 19

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 195, nodes: 149296
Average node length: 5.21, total dup: 134872, max dup: 43
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 26391, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 48
40 - 59% = 105
60 - 79% = 37
80 - 99% = 5

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.95, total records: 100300
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: 1, data page slots: 960
Data pages: 960, average fill: 57%
Primary pages: 960, secondary pages: 0, swept pages: 0
Empty pages: 90, full pages: 855
Fill distribution:
0 - 19% = 103
20 - 39% = 0
40 - 59% = 2
60 - 79% = 855
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 409558, depth: 2, leaf buckets: 70, nodes: 100300
Average node length: 3.99, total dup: 100119, max dup: 1842
Average key length: 2.00, compression ratio: 1.30
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 19621, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 18
60 - 79% = 35
80 - 99% = 17

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: 148.60, total records: 3998925
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.41
Pointer pages: 58, data page slots: 93240
Data pages: 93240, average fill: 87%
Primary pages: 93240, secondary pages: 0, swept pages: 3
Empty pages: 2, full pages: 93237
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 93237

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 4526, nodes: 3998925
Average node length: 5.48, total dup: 3170508, max dup: 57
Average key length: 2.49, compression ratio: 3.21
Average prefix length: 7.64, average data length: 0.35
Clustering factor: 2215894, ratio: 0.55
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 2966
60 - 79% = 900
80 - 99% = 657

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 3497, nodes: 3998925
Average node length: 4.03, total dup: 3998921, max dup: 3821046
Average key length: 1.04, compression ratio: 0.21
Average prefix length: 0.22, average data length: 0.00
Clustering factor: 110752, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 3496
60 - 79% = 0
80 - 99% = 0

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 4553, nodes: 3998925
Average node length: 5.36, total dup: 3797618, max dup: 5703
Average key length: 2.37, compression ratio: 3.80
Average prefix length: 8.68, average data length: 0.32
Clustering factor: 409957, ratio: 0.10
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 3289
60 - 79% = 684
80 - 99% = 578

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 4345, nodes: 3998925
Average node length: 5.17, total dup: 3941652, max dup: 418110
Average key length: 2.18, compression ratio: 17.16
Average prefix length: 37.32, average data length: 0.17
Clustering factor: 2899366, ratio: 0.73
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 3255
60 - 79% = 539
80 - 99% = 541

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: 53.73, total records: 261450
Average version length: 54.15, total versions: 2037, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.49
Pointer pages: 2, data page slots: 3136
Data pages: 3136, average fill: 73%
Primary pages: 3136, secondary pages: 0, swept pages: 2274
Empty pages: 4, full pages: 2144
Fill distribution:
0 - 19% = 7
20 - 39% = 2
40 - 59% = 87
60 - 79% = 3033
80 - 99% = 7

Index PSTORNED_RCV_ID (2)
Root page: 2270, depth: 2, leaf buckets: 369, nodes: 261450
Average node length: 5.75, total dup: 222694, max dup: 669
Average key length: 3.11, compression ratio: 2.90
Average prefix length: 8.04, average data length: 0.96
Clustering factor: 18577, ratio: 0.07
Fill distribution:
0 - 19% = 7
20 - 39% = 5
40 - 59% = 320
60 - 79% = 30
80 - 99% = 7

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 272, nodes: 261450
Average node length: 5.41, total dup: 235502, max dup: 122
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 47331, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 114
60 - 79% = 102
80 - 99% = 50

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TRACE_STAT (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 61.48, total records: 1112
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.12
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 67%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 13
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 14
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: 72.18, total records: 5837
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: 136.00, compression ratio: 1.88
Pointer pages: 3, data page slots: 2240
Data pages: 360, average fill: 19%
Primary pages: 360, secondary pages: 0, swept pages: 349
Empty pages: 185, full pages: 50
Fill distribution:
0 - 19% = 267
20 - 39% = 20
40 - 59% = 9
60 - 79% = 64
80 - 99% = 0

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 17, nodes: 5837
Average node length: 7.69, total dup: 5085, max dup: 14
Average key length: 4.69, compression ratio: 7.90
Average prefix length: 34.44, average data length: 2.56
Clustering factor: 865, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 3
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.12, total records: 661830
Average version length: 71.17, total versions: 2121, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 7, data page slots: 10960
Data pages: 10960, average fill: 66%
Primary pages: 10960, secondary pages: 0, swept pages: 9427
Empty pages: 17, full pages: 4863
Fill distribution:
0 - 19% = 132
20 - 39% = 625
40 - 59% = 2141
60 - 79% = 7970
80 - 99% = 92

Index XQD_1000_3300_DOC (1)
Root page: 280605, depth: 3, leaf buckets: 719, nodes: 661830
Average node length: 5.10, total dup: 645371, max dup: 127
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 57239, ratio: 0.09
Fill distribution:
0 - 19% = 17
20 - 39% = 38
40 - 59% = 491
60 - 79% = 6
80 - 99% = 167

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 197488, depth: 3, leaf buckets: 924, nodes: 661830
Average node length: 6.23, total dup: 578255, max dup: 24
Average key length: 3.32, compression ratio: 11.14
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 116870, ratio: 0.18
Fill distribution:
0 - 19% = 30
20 - 39% = 103
40 - 59% = 516
60 - 79% = 154
80 - 99% = 121

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 72.05, total records: 12193
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: 136.00, compression ratio: 1.89
Pointer pages: 3, data page slots: 4592
Data pages: 904, average fill: 16%
Primary pages: 904, secondary pages: 0, swept pages: 852
Empty pages: 350, full pages: 12
Fill distribution:
0 - 19% = 599
20 - 39% = 203
40 - 59% = 73
60 - 79% = 29
80 - 99% = 0

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 26, nodes: 12193
Average node length: 6.65, total dup: 11018, max dup: 48
Average key length: 3.69, compression ratio: 10.02
Average prefix length: 35.40, average data length: 1.60
Clustering factor: 1472, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 10
60 - 79% = 2
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.72, total records: 744150
Average version length: 69.49, total versions: 5428, 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: 13, data page slots: 20824
Data pages: 18135, average fill: 46%
Primary pages: 18135, secondary pages: 0, swept pages: 15700
Empty pages: 1404, full pages: 3879
Fill distribution:
0 - 19% = 3592
20 - 39% = 3954
40 - 59% = 4183
60 - 79% = 6263
80 - 99% = 143

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 185734, depth: 3, leaf buckets: 1179, nodes: 744150
Average node length: 5.69, total dup: 692585, max dup: 49
Average key length: 2.77, compression ratio: 13.38
Average prefix length: 36.30, average data length: 0.70
Clustering factor: 82501, ratio: 0.11
Fill distribution:
0 - 19% = 32
20 - 39% = 588
40 - 59% = 263
60 - 79% = 205
80 - 99% = 91

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 0.45, total records: 125665
Average version length: 70.83, total versions: 124862, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 304.47
Pointer pages: 4, data page slots: 3360
Data pages: 2720, average fill: 60%
Primary pages: 2718, secondary pages: 2, swept pages: 582
Empty pages: 581, full pages: 1583
Fill distribution:
0 - 19% = 716
20 - 39% = 153
40 - 59% = 140
60 - 79% = 373
80 - 99% = 1338

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 106194, depth: 3, leaf buckets: 217, nodes: 125665
Average node length: 5.49, total dup: 114221, max dup: 99
Average key length: 3.09, compression ratio: 11.99
Average prefix length: 36.00, average data length: 1.00
Clustering factor: 15727, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 121
40 - 59% = 87
60 - 79% = 9
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.18, total records: 1306304
Average version length: 68.82, total versions: 5918, 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: 26304
Data pages: 26304, average fill: 54%
Primary pages: 26304, secondary pages: 0, swept pages: 25577
Empty pages: 550, full pages: 4699
Fill distribution:
0 - 19% = 1697
20 - 39% = 4103
40 - 59% = 8316
60 - 79% = 12089
80 - 99% = 99

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 2467, nodes: 1306304
Average node length: 6.69, total dup: 1089178, max dup: 17
Average key length: 3.72, compression ratio: 9.95
Average prefix length: 35.45, average data length: 1.55
Clustering factor: 268615, ratio: 0.21
Fill distribution:
0 - 19% = 38
20 - 39% = 1065
40 - 59% = 994
60 - 79% = 218
80 - 99% = 152

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 82.04, total records: 2640469
Average version length: 81.32, total versions: 1139, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 26, data page slots: 41120
Data pages: 41120, average fill: 78%
Primary pages: 41120, secondary pages: 0, swept pages: 16909
Empty pages: 14, full pages: 35991
Fill distribution:
0 - 19% = 28
20 - 39% = 73
40 - 59% = 737
60 - 79% = 17045
80 - 99% = 23237

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 2769, nodes: 2640469
Average node length: 5.15, total dup: 2580283, max dup: 127
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 387623, ratio: 0.15
Fill distribution:
0 - 19% = 17
20 - 39% = 11
40 - 59% = 1574
60 - 79% = 804
80 - 99% = 363

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 2811, nodes: 2640469
Average node length: 5.73, total dup: 2354065, max dup: 49
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 132486, ratio: 0.05
Fill distribution:
0 - 19% = 26
20 - 39% = 30
40 - 59% = 1616
60 - 79% = 59
80 - 99% = 1080

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 3138, nodes: 2640469
Average node length: 5.82, total dup: 2309960, max dup: 27
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 428298, ratio: 0.16
Fill distribution:
0 - 19% = 18
20 - 39% = 14
40 - 59% = 1836
60 - 79% = 821
80 - 99% = 449

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 80.90, total records: 1333667
Average version length: 80.16, total versions: 6989, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.68
Pointer pages: 15, data page slots: 23200
Data pages: 23200, average fill: 70%
Primary pages: 23200, secondary pages: 0, swept pages: 19809
Empty pages: 306, full pages: 14667
Fill distribution:
0 - 19% = 841
20 - 39% = 1088
40 - 59% = 2489
60 - 79% = 10723
80 - 99% = 8059

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 1560, nodes: 1333667
Average node length: 5.14, total dup: 1302487, max dup: 201
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 130301, ratio: 0.10
Fill distribution:
0 - 19% = 3
20 - 39% = 54
40 - 59% = 1149
60 - 79% = 315
80 - 99% = 39

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 1778, nodes: 1333667
Average node length: 6.02, total dup: 1133036, max dup: 14
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 76321, ratio: 0.06
Fill distribution:
0 - 19% = 35
20 - 39% = 292
40 - 59% = 723
60 - 79% = 451
80 - 99% = 277

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 1798, nodes: 1333667
Average node length: 5.84, total dup: 1166732, max dup: 29
Average key length: 2.88, compression ratio: 3.12
Average prefix length: 8.24, average data length: 0.76
Clustering factor: 168515, ratio: 0.13
Fill distribution:
0 - 19% = 37
20 - 39% = 41
40 - 59% = 1331
60 - 79% = 348
80 - 99% = 41

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 82.06, total records: 2734037
Average version length: 81.92, total versions: 1727, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 29, data page slots: 46304
Data pages: 46240, average fill: 72%
Primary pages: 46240, secondary pages: 0, swept pages: 16234
Empty pages: 297, full pages: 34117
Fill distribution:
0 - 19% = 1080
20 - 39% = 2235
40 - 59% = 4578
60 - 79% = 13949
80 - 99% = 24398

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 3036, nodes: 2734037
Average node length: 5.03, total dup: 2717561, max dup: 587
Average key length: 2.06, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 310966, ratio: 0.11
Fill distribution:
0 - 19% = 8
20 - 39% = 221
40 - 59% = 1938
60 - 79% = 622
80 - 99% = 247

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 2994, nodes: 2734037
Average node length: 5.66, total dup: 2466346, max dup: 49
Average key length: 2.69, compression ratio: 3.35
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 143802, ratio: 0.05
Fill distribution:
0 - 19% = 29
20 - 39% = 496
40 - 59% = 1273
60 - 79% = 147
80 - 99% = 1049

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 3434, nodes: 2734037
Average node length: 5.73, total dup: 2440004, max dup: 90
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 385211, ratio: 0.14
Fill distribution:
0 - 19% = 3
20 - 39% = 194
40 - 59% = 2263
60 - 79% = 709
80 - 99% = 265

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: 81.58, total records: 1998351
Average version length: 80.80, total versions: 5566, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.67
Pointer pages: 21, data page slots: 33704
Data pages: 33704, average fill: 72%
Primary pages: 33704, secondary pages: 0, swept pages: 29348
Empty pages: 180, full pages: 21674
Fill distribution:
0 - 19% = 558
20 - 39% = 772
40 - 59% = 2761
60 - 79% = 19822
80 - 99% = 9791

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 2122, nodes: 1998351
Average node length: 5.02, total dup: 1986738, max dup: 851
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 504956, ratio: 0.25
Fill distribution:
0 - 19% = 3
20 - 39% = 116
40 - 59% = 1149
60 - 79% = 662
80 - 99% = 192

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 3007, nodes: 1998351
Average node length: 6.06, total dup: 1689772, max dup: 14
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 181404, ratio: 0.09
Fill distribution:
0 - 19% = 80
20 - 39% = 700
40 - 59% = 1497
60 - 79% = 411
80 - 99% = 319

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 2400, nodes: 1998351
Average node length: 5.74, total dup: 1781801, max dup: 50
Average key length: 2.77, compression ratio: 3.25
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 513777, ratio: 0.26
Fill distribution:
0 - 19% = 1
20 - 39% = 86
40 - 59% = 1300
60 - 79% = 798
80 - 99% = 215

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 68.32, total records: 699204
Average version length: 68.76, total versions: 6805, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.99
Pointer pages: 7, data page slots: 11024
Data pages: 11024, average fill: 67%
Primary pages: 11024, secondary pages: 0, swept pages: 8648
Empty pages: 152, full pages: 7511
Fill distribution:
0 - 19% = 552
20 - 39% = 800
40 - 59% = 1102
60 - 79% = 8417
80 - 99% = 153

Index XQS_3300_3400_DOC_ID (0)
Root page: 174099, depth: 3, leaf buckets: 803, nodes: 699204
Average node length: 5.16, total dup: 675595, max dup: 147
Average key length: 2.26, compression ratio: 3.98
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 34980, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 112
40 - 59% = 397
60 - 79% = 235
80 - 99% = 58

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 911, nodes: 699204
Average node length: 5.86, total dup: 606873, max dup: 29
Average key length: 2.96, compression ratio: 3.04
Average prefix length: 8.17, average data length: 0.83
Clustering factor: 44429, ratio: 0.06
Fill distribution:
0 - 19% = 2
20 - 39% = 149
40 - 59% = 411
60 - 79% = 280
80 - 99% = 69

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Gstat completion time Tue Jun 05 06:54:24 2018

Done for 25220 ms, from 6:53:59.54 to 6:54:24.76.

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 1216681 2061 0.1693
DOC_LIST 279447 0 0.0000
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 35795 0 0.0000
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 35 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 149296 0 0.0000
PERF_ESTIMATED 100300 0 0.0000
PERF_LOG 3998925 0 0.0000
PSTORNED 261450 2037 0.7791
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 0 0.0000
SETTINGS 114 0 0.0000
TRACE_STAT 1112 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 5837 0 0.0000
XQD_1000_3300 661830 2121 0.3204
XQD_1200_2000 12193 0 0.0000
XQD_2000_3300 744150 5428 0.7294
XQD_2100_3300 125665 124862 99.3609
XQD_3300_3400 1306304 5918 0.4530
XQS_1000_1200 2640469 1139 0.0431
XQS_1000_3300 1333667 6989 0.5240
XQS_1200_2000 2734037 1727 0.0631
XQS_2100_3300 1998351 5566 0.2785
XQS_3300_3400 699204 6805 0.9732
Z_USED_VIEWS 29 0 0.0000
Done for 1590 ms, from 6:54:32.66 to 6:54:34.25.

Database validation

06:54:34.36 Validation started

06:54:34.36 Relation 140 (DOC_LIST)
06:54:34.36 process pointer page 0 of 3
06:54:34.40 process pointer page 1 of 3
06:54:34.43 process pointer page 2 of 3
06:54:34.45 Index 1 (PK_DOC_LIST)
06:54:34.56 Index 2 (DOC_LIST_ID_DESC)
06:54:34.67 Index 3 (FK_DOC_LIST_AGENTS)
06:54:34.78 Relation 140 (DOC_LIST) is ok

06:54:34.78 Relation 141 (DOC_DATA)
06:54:34.78 process pointer page 0 of 9
06:54:34.87 process pointer page 1 of 9
06:54:34.96 process pointer page 2 of 9
06:54:35.00 process pointer page 3 of 9
06:54:35.04 process pointer page 4 of 9
06:54:35.07 process pointer page 5 of 9
06:54:35.10 process pointer page 6 of 9
06:54:35.14 process pointer page 7 of 9
06:54:35.17 process pointer page 8 of 9
06:54:35.17 Index 2 (DOC_DATA_DOC_WARE_UNQ)
06:54:35.45 Index 3 (DOC_DATA_ID_DESC)
06:54:35.88 Index 4 (FK_DOC_DATA_DOC_LIST)
06:54:36.09 Relation 141 (DOC_DATA) is ok

06:54:36.09 Relation 147 (INVNT_SALDO)
06:54:36.09 process pointer page 0 of 1
06:54:36.09 Index 1 (PK_INVNT_SALDO)
06:54:36.09 Relation 147 (INVNT_SALDO) is ok

06:54:36.09 Relation 150 (PDISTR)
06:54:36.09 process pointer page 0 of 2
06:54:36.12 process pointer page 1 of 2
06:54:36.12 Index 2 (PDISTR_SND_ID)
06:54:36.13 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
06:54:36.17 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
06:54:36.20 Index 5 (PDISTR_AGENT_ID)
06:54:36.24 Relation 150 (PDISTR) is ok

06:54:36.24 Relation 151 (PSTORNED)
06:54:36.24 process pointer page 0 of 2
06:54:36.32 process pointer page 1 of 2
06:54:36.40 Index 2 (PSTORNED_SND_ID)
06:54:36.48 Index 3 (PSTORNED_RCV_ID)
06:54:36.56 Relation 151 (PSTORNED) is ok

06:54:36.56 Relation 156 (SEMAPHORES)
06:54:36.56 process pointer page 0 of 1
06:54:36.56 Index 1 (PK_SEMAPHORES)
06:54:36.56 Index 2 (SEMAPHORES_TASK_UNQ)
06:54:36.56 Relation 156 (SEMAPHORES) is ok

06:54:36.56 Relation 157 (INVNT_TURNOVER_LOG)
06:54:36.56 process pointer page 0 of 3
06:54:36.57 process pointer page 1 of 3
06:54:36.59 process pointer page 2 of 3
06:54:36.59 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
06:54:36.62 Relation 157 (INVNT_TURNOVER_LOG) is ok

06:54:36.62 Relation 160 (PERF_ESTIMATED)
06:54:36.62 process pointer page 0 of 1
06:54:36.66 Index 1 (PERF_EST_MINUTE_SINCE_START)
06:54:36.70 Relation 160 (PERF_ESTIMATED) is ok

06:54:36.70 Relation 161 (PERF_ISQL_STAT)
06:54:36.70 process pointer page 0 of 1
06:54:36.70 Index 1 (PERF_ISQL_STAT_TRN)
06:54:36.70 Relation 161 (PERF_ISQL_STAT) is ok

06:54:36.70 Relation 162 (TRACE_STAT)
06:54:36.70 process pointer page 0 of 1
06:54:36.70 Relation 162 (TRACE_STAT) is ok

06:54:36.70 Relation 163 (PERF_LOG)
06:54:36.70 process pointer page 0 of 58
06:54:36.77 process pointer page 1 of 58
06:54:36.84 process pointer page 2 of 58
06:54:36.90 process pointer page 3 of 58
06:54:36.93 process pointer page 4 of 58
06:54:36.95 process pointer page 5 of 58
06:54:36.98 process pointer page 6 of 58
06:54:37.01 process pointer page 7 of 58
06:54:37.04 process pointer page 8 of 58
06:54:37.07 process pointer page 9 of 58
06:54:37.15 process pointer page 10 of 58
06:54:37.21 process pointer page 11 of 58
06:54:37.29 process pointer page 12 of 58
06:54:37.37 process pointer page 13 of 58
06:54:37.43 process pointer page 14 of 58
06:54:37.51 process pointer page 15 of 58
06:54:37.57 process pointer page 16 of 58
06:54:37.60 process pointer page 17 of 58
06:54:37.63 process pointer page 18 of 58
06:54:37.71 process pointer page 19 of 58
06:54:37.79 process pointer page 20 of 58
06:54:37.87 process pointer page 21 of 58
06:54:37.93 process pointer page 22 of 58
06:54:38.01 process pointer page 23 of 58
06:54:38.08 process pointer page 24 of 58
06:54:38.16 process pointer page 25 of 58
06:54:38.24 process pointer page 26 of 58
06:54:38.30 process pointer page 27 of 58
06:54:38.38 process pointer page 28 of 58
06:54:38.46 process pointer page 29 of 58
06:54:38.49 process pointer page 30 of 58
06:54:38.52 process pointer page 31 of 58
06:54:38.55 process pointer page 32 of 58
06:54:38.58 process pointer page 33 of 58
06:54:38.61 process pointer page 34 of 58
06:54:38.66 process pointer page 35 of 58
06:54:38.74 process pointer page 36 of 58
06:54:38.82 process pointer page 37 of 58
06:54:38.90 process pointer page 38 of 58
06:54:38.94 process pointer page 39 of 58
06:54:38.96 process pointer page 40 of 58
06:54:38.99 process pointer page 41 of 58
06:54:39.02 process pointer page 42 of 58
06:54:39.05 process pointer page 43 of 58
06:54:39.08 process pointer page 44 of 58
06:54:39.11 process pointer page 45 of 58
06:54:39.16 process pointer page 46 of 58
06:54:39.24 process pointer page 47 of 58
06:54:39.30 process pointer page 48 of 58
06:54:39.38 process pointer page 49 of 58
06:54:39.46 process pointer page 50 of 58
06:54:39.52 process pointer page 51 of 58
06:54:39.60 process pointer page 52 of 58
06:54:39.66 process pointer page 53 of 58
06:54:39.74 process pointer page 54 of 58
06:54:39.82 process pointer page 55 of 58
06:54:39.88 process pointer page 56 of 58
06:54:39.93 process pointer page 57 of 58
06:54:39.93 Index 1 (PERF_LOG_DTS_BEG_DESC)
06:54:40.53 Index 2 (PERF_LOG_UNIT)
06:54:42.37 Index 3 (PERF_LOG_TRN_DESC)
06:54:43.22 Index 4 (PERF_LOG_GDSCODE)
06:54:43.70 Relation 163 (PERF_LOG) is ok

06:54:43.70 Relation 167 (V_STOPTEST)
06:54:43.70 Relation 167 (V_STOPTEST) is ok

06:54:43.70 Relation 184 (V_QDISTR_SOURCE)
06:54:43.70 Relation 184 (V_QDISTR_SOURCE) is ok

06:54:43.70 Relation 185 (V_QSTORNED_SOURCE)
06:54:43.70 Relation 185 (V_QSTORNED_SOURCE) is ok

06:54:43.70 Relation 260 (XQD_1000_1200)
06:54:43.70 process pointer page 0 of 3
06:54:43.70 process pointer page 1 of 3
06:54:43.72 process pointer page 2 of 3
06:54:43.72 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
06:54:43.72 Relation 260 (XQD_1000_1200) is ok

06:54:43.72 Relation 261 (XQD_1200_2000)
06:54:43.72 process pointer page 0 of 3
06:54:43.72 process pointer page 1 of 3
06:54:43.72 process pointer page 2 of 3
06:54:43.72 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
06:54:43.73 Relation 261 (XQD_1200_2000) is ok

06:54:43.73 Relation 262 (XQD_1000_3300)
06:54:43.73 process pointer page 0 of 7
06:54:43.79 process pointer page 1 of 7
06:54:43.84 process pointer page 2 of 7
06:54:43.87 process pointer page 3 of 7
06:54:43.95 process pointer page 4 of 7
06:54:44.03 process pointer page 5 of 7
06:54:44.11 process pointer page 6 of 7
06:54:44.17 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
06:54:44.40 Index 2 (XQD_1000_3300_DOC)
06:54:44.61 Relation 262 (XQD_1000_3300) is ok

06:54:44.61 Relation 263 (XQD_2000_3300)
06:54:44.61 process pointer page 0 of 13
06:54:44.68 process pointer page 1 of 13
06:54:44.75 process pointer page 2 of 13
06:54:44.81 process pointer page 3 of 13
06:54:44.85 process pointer page 4 of 13
06:54:44.87 process pointer page 5 of 13
06:54:44.89 process pointer page 6 of 13
06:54:44.90 process pointer page 7 of 13
06:54:44.93 process pointer page 8 of 13
06:54:44.98 process pointer page 9 of 13
06:54:45.01 process pointer page 10 of 13
06:54:45.03 process pointer page 11 of 13
06:54:45.06 process pointer page 12 of 13
06:54:45.07 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
06:54:45.28 Relation 263 (XQD_2000_3300) is ok

06:54:45.28 Relation 264 (XQD_2100_3300)
06:54:45.28 process pointer page 0 of 4
06:54:45.46 process pointer page 1 of 4
06:54:45.53 process pointer page 2 of 4
06:54:45.54 process pointer page 3 of 4
06:54:45.54 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
06:54:45.57 Relation 264 (XQD_2100_3300) is ok

06:54:45.57 Relation 265 (XQD_3300_3400)
06:54:45.57 process pointer page 0 of 17
06:54:45.59 process pointer page 1 of 17
06:54:45.62 process pointer page 2 of 17
06:54:45.65 process pointer page 3 of 17
06:54:45.68 process pointer page 4 of 17
06:54:45.70 process pointer page 5 of 17
06:54:45.73 process pointer page 6 of 17
06:54:45.76 process pointer page 7 of 17
06:54:45.81 process pointer page 8 of 17
06:54:45.87 process pointer page 9 of 17
06:54:45.93 process pointer page 10 of 17
06:54:45.96 process pointer page 11 of 17
06:54:45.99 process pointer page 12 of 17
06:54:46.02 process pointer page 13 of 17
06:54:46.04 process pointer page 14 of 17
06:54:46.07 process pointer page 15 of 17
06:54:46.10 process pointer page 16 of 17
06:54:46.12 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
06:54:46.48 Relation 265 (XQD_3300_3400) is ok

06:54:46.48 Relation 266 (XQS_1000_1200)
06:54:46.49 process pointer page 0 of 26
06:54:46.57 process pointer page 1 of 26
06:54:46.65 process pointer page 2 of 26
06:54:46.73 process pointer page 3 of 26
06:54:46.82 process pointer page 4 of 26
06:54:46.88 process pointer page 5 of 26
06:54:46.91 process pointer page 6 of 26
06:54:46.95 process pointer page 7 of 26
06:54:47.01 process pointer page 8 of 26
06:54:47.04 process pointer page 9 of 26
06:54:47.09 process pointer page 10 of 26
06:54:47.15 process pointer page 11 of 26
06:54:47.18 process pointer page 12 of 26
06:54:47.26 process pointer page 13 of 26
06:54:47.34 process pointer page 14 of 26
06:54:47.41 process pointer page 15 of 26
06:54:47.48 process pointer page 16 of 26
06:54:47.51 process pointer page 17 of 26
06:54:47.58 process pointer page 18 of 26
06:54:47.66 process pointer page 19 of 26
06:54:47.74 process pointer page 20 of 26
06:54:47.79 process pointer page 21 of 26
06:54:47.82 process pointer page 22 of 26
06:54:47.85 process pointer page 23 of 26
06:54:47.88 process pointer page 24 of 26
06:54:47.91 process pointer page 25 of 26
06:54:47.91 Index 1 (XQS_1000_1200_DOC_ID)
06:54:48.30 Index 2 (XQS_1000_1200_SND_ID)
06:54:48.90 Index 3 (XQS_1000_1200_RCV_ID)
06:54:49.27 Relation 266 (XQS_1000_1200) is ok

06:54:49.27 Relation 267 (XQS_1200_2000)
06:54:49.27 process pointer page 0 of 29
06:54:49.35 process pointer page 1 of 29
06:54:49.44 process pointer page 2 of 29
06:54:49.52 process pointer page 3 of 29
06:54:49.60 process pointer page 4 of 29
06:54:49.64 process pointer page 5 of 29
06:54:49.68 process pointer page 6 of 29
06:54:49.71 process pointer page 7 of 29
06:54:49.78 process pointer page 8 of 29
06:54:49.82 process pointer page 9 of 29
06:54:49.85 process pointer page 10 of 29
06:54:49.88 process pointer page 11 of 29
06:54:49.96 process pointer page 12 of 29
06:54:50.03 process pointer page 13 of 29
06:54:50.11 process pointer page 14 of 29
06:54:50.14 process pointer page 15 of 29
06:54:50.17 process pointer page 16 of 29
06:54:50.21 process pointer page 17 of 29
06:54:50.27 process pointer page 18 of 29
06:54:50.35 process pointer page 19 of 29
06:54:50.41 process pointer page 20 of 29
06:54:50.49 process pointer page 21 of 29
06:54:50.55 process pointer page 22 of 29
06:54:50.63 process pointer page 23 of 29
06:54:50.69 process pointer page 24 of 29
06:54:50.77 process pointer page 25 of 29
06:54:50.83 process pointer page 26 of 29
06:54:50.86 process pointer page 27 of 29
06:54:50.91 process pointer page 28 of 29
06:54:50.91 Index 1 (XQS_1200_2000_DOC_ID)
06:54:51.24 Index 2 (XQS_1200_2000_SND_ID)
06:54:51.67 Index 3 (XQS_1200_2000_RCV_ID)
06:54:51.91 Relation 267 (XQS_1200_2000) is ok

06:54:51.91 Relation 268 (XQS_1000_3300)
06:54:51.91 process pointer page 0 of 15
06:54:51.92 process pointer page 1 of 15
06:54:51.94 process pointer page 2 of 15
06:54:51.97 process pointer page 3 of 15
06:54:52.00 process pointer page 4 of 15
06:54:52.02 process pointer page 5 of 15
06:54:52.09 process pointer page 6 of 15
06:54:52.17 process pointer page 7 of 15
06:54:52.25 process pointer page 8 of 15
06:54:52.33 process pointer page 9 of 15
06:54:52.41 process pointer page 10 of 15
06:54:52.48 process pointer page 11 of 15
06:54:52.58 process pointer page 12 of 15
06:54:52.61 process pointer page 13 of 15
06:54:52.64 process pointer page 14 of 15
06:54:52.64 Index 1 (XQS_1000_3300_DOC_ID)
06:54:52.90 Index 2 (XQS_1000_3300_SND_ID)
06:54:53.17 Index 3 (XQS_1000_3300_RCV_ID)
06:54:53.42 Relation 268 (XQS_1000_3300) is ok

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

06:54:53.42 Relation 270 (XQS_2100_3300)
06:54:53.42 process pointer page 0 of 21
06:54:53.50 process pointer page 1 of 21
06:54:53.58 process pointer page 2 of 21
06:54:53.61 process pointer page 3 of 21
06:54:53.64 process pointer page 4 of 21
06:54:53.67 process pointer page 5 of 21
06:54:53.70 process pointer page 6 of 21
06:54:53.73 process pointer page 7 of 21
06:54:53.79 process pointer page 8 of 21
06:54:53.82 process pointer page 9 of 21
06:54:53.90 process pointer page 10 of 21
06:54:53.98 process pointer page 11 of 21
06:54:54.06 process pointer page 12 of 21
06:54:54.09 process pointer page 13 of 21
06:54:54.12 process pointer page 14 of 21
06:54:54.15 process pointer page 15 of 21
06:54:54.18 process pointer page 16 of 21
06:54:54.21 process pointer page 17 of 21
06:54:54.25 process pointer page 18 of 21
06:54:54.26 process pointer page 19 of 21
06:54:54.34 process pointer page 20 of 21
06:54:54.37 Index 1 (XQS_2100_3300_DOC_ID)
06:54:54.79 Index 2 (XQS_2100_3300_SND_ID)
06:54:55.34 Index 3 (XQS_2100_3300_RCV_ID)
06:54:55.60 Relation 270 (XQS_2100_3300) is ok

06:54:55.60 Relation 271 (XQS_3300_3400)
06:54:55.60 process pointer page 0 of 7
06:54:55.68 process pointer page 1 of 7
06:54:55.76 process pointer page 2 of 7
06:54:55.85 process pointer page 3 of 7
06:54:55.93 process pointer page 4 of 7
06:54:56.01 process pointer page 5 of 7
06:54:56.07 process pointer page 6 of 7
06:54:56.13 Index 1 (XQS_3300_3400_DOC_ID)
06:54:56.32 Index 2 (XQS_3300_3400_SND_ID)
06:54:56.52 Relation 271 (XQS_3300_3400) is ok

06:54:56.52 Validation finished
Done for 22260 ms, from 6:54:34.28 to 6:54:56.54.

Differences between old and current firebird.log

6:54:57.48. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2018-06-05 06:54 471 oltp30_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

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

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2018-06-05 6:55:00.86 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html