Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2018-06-03 6:47:35.88.
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-03 06:46:45.4110 -1 <null> ::1/60148 439139 8733 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: 1495.19 25195 269135 2018-06-03 03:46 2018-06-03 06:46
customer order: creation 165.82 855 29847 2018-06-03 03:46 2018-06-03 06:46
customer order: refuse 13.38 626 2409 2018-06-03 03:46 2018-06-03 06:46
order to supplier: creation 42.22 19004 7600 2018-06-03 03:46 2018-06-03 06:46
order to supplier: removal 0.78 99055 140 2018-06-03 03:46 2018-06-03 06:46
invoice (draft): creation 42.62 21910 7672 2018-06-03 03:46 2018-06-03 06:46
invoice (draft): removal 10.16 2984 1829 2018-06-03 03:46 2018-06-03 06:46
invoice accept: apply 21.22 103045 3819 2018-06-03 03:46 2018-06-03 06:46
invoice accept: cancel 4.01 16460 721 2018-06-03 03:46 2018-06-03 06:46
customer reserve: creation 824.56 2412 148421 2018-06-03 03:46 2018-06-03 06:46
customer reserve: removal 157.73 457 28392 2018-06-03 03:46 2018-06-03 06:46
realization accept: apply 70.35 1839 12663 2018-06-03 03:46 2018-06-03 06:46
realization accept: cancel 27.98 970 5037 2018-06-03 03:46 2018-06-03 06:46
payment from customer: creation 54.81 3108 9865 2018-06-03 03:46 2018-06-03 06:46
payment from customer: removal 5.22 286 940 2018-06-03 03:46 2018-06-03 06:46
payment to supplier: creation 44.65 6662 8037 2018-06-03 03:46 2018-06-03 06:46
payment to supplier: removal 2.92 312 526 2018-06-03 03:46 2018-06-03 06:46
service: total inventory turnovers 0.44 132836 80 2018-06-03 03:46 2018-06-03 06:46
service: total monetary turnovers 6.26 4000 1126 2018-06-03 03:46 2018-06-03 06:46
service: refresh index statistics 0.07 61887 11 2018-06-03 03:46 2018-06-03 06:46
Done for 28300 ms, from 6:48:02.82 to 6:48:31.12.

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 859 19760 15457 4303 21.78 03:46:46 04:04:46
interval # 2, overall 2 490 10922 8817 2105 19.27 04:04:47 04:22:47
interval # 3, overall 3 725 16059 13055 3004 18.71 04:22:48 04:40:48
interval # 4, overall 4 1106 22944 19915 3029 13.20 04:40:49 04:58:49
interval # 5, overall 5 1714 34279 30844 3435 10.02 04:58:50 05:16:50
interval # 6, overall 6 1715 33024 30878 2146 6.50 05:16:51 05:34:51
interval # 7, overall 7 2163 42106 38938 3168 7.52 05:34:52 05:52:52
interval # 8, overall 8 2168 40661 39023 1638 4.03 05:52:53 06:10:53
interval # 9, overall 9 1954 39832 35168 4664 11.71 06:10:54 06:28:54
interval # 10, overall 10 2058 40665 37040 3625 8.91 06:28:55 06:46:55
Done for 52880 ms, from 6:49:22.57 to 6:50:15.45.

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 1990.50 0.1391 1.6443 2153 100
TEST_TIME 2 1977.28 0.8294 1.1882 1371 90
TEST_TIME 3 1726.60 0.9077 1.0928 1034 72
TEST_TIME 4 1534.91 0.9222 1.0668 895 69
TEST_TIME 5 1383.37 0.9469 1.0551 775 67
TEST_TIME 6 1266.35 0.9606 1.0399 683 58
TEST_TIME 7 1167.02 0.9675 1.0320 537 53
TEST_TIME 8 1082.17 0.9738 1.0236 466 46
TEST_TIME 9 1011.06 0.9739 1.0256 458 46
TEST_TIME 10 959.29 0.9730 1.0328 417 55
TEST_TIME 11 918.61 0.9808 1.0247 421 48
TEST_TIME 12 882.75 0.9778 1.0260 416 51
TEST_TIME 13 851.42 0.9822 1.0191 390 53
TEST_TIME 14 819.56 0.9832 1.0179 307 44
TEST_TIME 15 790.04 0.9857 1.0167 267 43
TEST_TIME 16 765.78 0.9836 1.0232 358 45
TEST_TIME 17 756.60 0.9747 1.0149 327 45
TEST_TIME 18 740.21 0.9798 1.0252 280 43
TEST_TIME 19 736.12 0.9768 1.0202 339 47
TEST_TIME 20 723.33 0.9864 1.0188 291 44
TEST_TIME 21 714.38 0.9825 1.0121 294 42
TEST_TIME 22 698.69 0.9904 1.0124 259 40
TEST_TIME 23 690.63 0.9798 1.0173 266 44
TEST_TIME 24 681.38 0.9881 1.0131 268 45
TEST_TIME 25 671.32 0.9872 1.0139 260 46
TEST_TIME 26 670.69 0.9759 1.0170 331 56
TEST_TIME 27 667.20 0.9844 1.0104 295 50
TEST_TIME 28 656.94 0.9896 1.0080 307 50
TEST_TIME 29 648.57 0.9858 1.0161 290 49
TEST_TIME 30 644.33 0.9887 1.0152 263 51
TEST_TIME 31 639.97 0.9891 1.0107 252 50
TEST_TIME 32 634.81 0.9871 1.0162 278 52
TEST_TIME 33 629.80 0.9933 1.0074 267 52
TEST_TIME 34 625.05 0.9853 1.0113 285 54
TEST_TIME 35 621.81 0.9878 1.0159 297 52
TEST_TIME 36 620.63 0.9896 1.0082 255 48
TEST_TIME 37 615.56 0.9890 1.0116 229 49
TEST_TIME 38 612.27 0.9903 1.0071 281 49
TEST_TIME 39 613.23 0.9797 1.0329 289 57
TEST_TIME 40 625.20 0.9878 1.0093 280 58
TEST_TIME 41 623.20 0.9878 1.0114 300 57
TEST_TIME 42 620.43 0.9918 1.0107 263 50
TEST_TIME 43 619.61 0.9885 1.0119 300 53
TEST_TIME 44 619.75 0.9887 1.0093 341 59
TEST_TIME 45 620.66 0.9855 1.0154 371 67
TEST_TIME 46 626.55 0.9840 1.0132 386 71
TEST_TIME 47 633.58 0.9808 1.0131 394 68
TEST_TIME 48 633.45 0.9922 1.0103 296 64
TEST_TIME 49 633.00 0.9904 1.0100 340 57
TEST_TIME 50 635.70 0.9856 1.0136 489 67
TEST_TIME 51 637.03 0.9917 1.0105 361 62
TEST_TIME 52 644.00 0.9804 1.0200 460 71
TEST_TIME 53 654.57 0.9846 1.0199 478 75
TEST_TIME 54 668.02 0.9809 1.0174 469 75
TEST_TIME 55 677.64 0.9848 1.0091 486 77
TEST_TIME 56 682.72 0.9837 1.0107 439 74
TEST_TIME 57 686.65 0.9873 1.0114 424 71
TEST_TIME 58 695.69 0.9813 1.0151 435 77
TEST_TIME 59 705.18 0.9845 1.0148 550 80
TEST_TIME 60 711.91 0.9884 1.0136 566 77
TEST_TIME 61 716.80 0.9902 1.0104 496 75
TEST_TIME 62 722.16 0.9868 1.0148 493 78
TEST_TIME 63 731.96 0.9853 1.0139 574 89
TEST_TIME 64 735.72 0.9930 1.0068 417 79
TEST_TIME 65 741.57 0.9835 1.0126 534 85
TEST_TIME 66 746.83 0.9902 1.0106 443 80
TEST_TIME 67 750.74 0.9903 1.0090 451 78
TEST_TIME 68 754.42 0.9893 1.0102 482 79
TEST_TIME 69 759.77 0.9886 1.0103 513 85
TEST_TIME 70 765.84 0.9880 1.0120 487 88
TEST_TIME 71 772.02 0.9898 1.0095 472 76
TEST_TIME 72 777.20 0.9888 1.0121 522 83
TEST_TIME 73 786.19 0.9869 1.0114 579 81
TEST_TIME 74 795.05 0.9866 1.0102 608 87
TEST_TIME 75 800.45 0.9900 1.0115 579 81
TEST_TIME 76 807.94 0.9890 1.0154 568 84
TEST_TIME 77 821.84 0.9853 1.0114 626 89
TEST_TIME 78 833.14 0.9855 1.0110 649 88
TEST_TIME 79 845.03 0.9842 1.0176 887 94
TEST_TIME 80 860.10 0.9873 1.0118 921 89
TEST_TIME 81 872.70 0.9849 1.0145 854 89
TEST_TIME 82 887.27 0.9856 1.0166 802 88
TEST_TIME 83 902.43 0.9875 1.0103 802 90
TEST_TIME 84 908.66 0.9914 1.0080 558 75
TEST_TIME 85 914.92 0.9893 1.0098 617 79
TEST_TIME 86 921.87 0.9906 1.0115 600 81
TEST_TIME 87 933.38 0.9876 1.0101 635 86
TEST_TIME 88 943.86 0.9876 1.0083 758 84
TEST_TIME 89 950.85 0.9897 1.0120 721 91
TEST_TIME 90 960.22 0.9910 1.0108 632 87
TEST_TIME 91 969.42 0.9902 1.0113 652 87
TEST_TIME 92 981.82 0.9877 1.0108 705 91
TEST_TIME 93 991.10 0.9909 1.0075 641 90
TEST_TIME 94 995.26 0.9926 1.0106 572 89
TEST_TIME 95 1001.61 0.9939 1.0062 566 85
TEST_TIME 96 1007.02 0.9904 1.0078 660 80
TEST_TIME 97 1011.78 0.9928 1.0073 486 81
TEST_TIME 98 1023.42 0.9857 1.0081 584 82
TEST_TIME 99 1031.32 0.9903 1.0113 578 86
TEST_TIME 100 1039.16 0.9936 1.0101 523 82
TEST_TIME 101 1046.10 0.9934 1.0109 494 85
TEST_TIME 102 1054.05 0.9935 1.0058 578 81
TEST_TIME 103 1054.18 0.9959 1.0056 451 69
TEST_TIME 104 1054.25 0.9959 1.0046 445 66
TEST_TIME 105 1056.75 0.9926 1.0063 443 74
TEST_TIME 106 1061.27 0.9926 1.0066 641 76
TEST_TIME 107 1072.82 0.9865 1.0119 759 85
TEST_TIME 108 1085.81 0.9906 1.0096 716 86
TEST_TIME 109 1094.48 0.9924 1.0062 831 88
TEST_TIME 110 1099.98 0.9921 1.0082 707 83
TEST_TIME 111 1110.06 0.9901 1.0073 711 88
TEST_TIME 112 1116.89 0.9922 1.0083 651 91
TEST_TIME 113 1122.28 0.9945 1.0060 548 80
TEST_TIME 114 1128.55 0.9916 1.0078 574 85
TEST_TIME 115 1136.53 0.9920 1.0062 658 86
TEST_TIME 116 1142.14 0.9927 1.0076 557 82
TEST_TIME 117 1150.47 0.9918 1.0080 579 82
TEST_TIME 118 1157.24 0.9939 1.0072 724 76
TEST_TIME 119 1167.74 0.9898 1.0107 664 87
TEST_TIME 120 1180.05 0.9918 1.0099 650 89
TEST_TIME 121 1191.61 0.9919 1.0058 704 76
TEST_TIME 122 1196.40 0.9936 1.0062 604 82
TEST_TIME 123 1204.40 0.9914 1.0086 681 89
TEST_TIME 124 1214.63 0.9920 1.0078 643 87
TEST_TIME 125 1225.95 0.9905 1.0085 681 86
TEST_TIME 126 1236.89 0.9916 1.0077 626 83
TEST_TIME 127 1243.90 0.9942 1.0061 611 88
TEST_TIME 128 1250.31 0.9932 1.0066 685 92
TEST_TIME 129 1255.31 0.9948 1.0063 625 83
TEST_TIME 130 1259.17 0.9955 1.0051 561 80
TEST_TIME 131 1263.11 0.9943 1.0058 519 78
TEST_TIME 132 1269.11 0.9935 1.0085 497 91
TEST_TIME 133 1277.48 0.9944 1.0063 684 87
TEST_TIME 134 1283.36 0.9943 1.0052 745 93
TEST_TIME 135 1290.04 0.9926 1.0090 685 94
TEST_TIME 136 1299.18 0.9947 1.0056 705 86
TEST_TIME 137 1304.43 0.9941 1.0064 780 83
TEST_TIME 138 1313.89 0.9919 1.0073 779 89
TEST_TIME 139 1324.37 0.9921 1.0066 730 90
TEST_TIME 140 1329.32 0.9957 1.0046 626 76
TEST_TIME 141 1334.08 0.9940 1.0070 619 81
TEST_TIME 142 1343.32 0.9931 1.0063 595 83
TEST_TIME 143 1347.84 0.9960 1.0051 517 81
TEST_TIME 144 1353.97 0.9936 1.0045 597 86
TEST_TIME 145 1356.62 0.9956 1.0057 602 83
TEST_TIME 146 1360.01 0.9965 1.0033 542 72
TEST_TIME 147 1362.06 0.9949 1.0046 470 82
TEST_TIME 148 1366.91 0.9942 1.0062 537 83
TEST_TIME 149 1372.51 0.9953 1.0042 544 85
TEST_TIME 150 1373.64 0.9967 1.0038 547 82
TEST_TIME 151 1374.93 0.9962 1.0049 518 80
TEST_TIME 152 1379.73 0.9948 1.0049 565 85
TEST_TIME 153 1381.66 0.9969 1.0038 522 78
TEST_TIME 154 1385.03 0.9949 1.0046 483 82
TEST_TIME 155 1389.52 0.9949 1.0049 567 85
TEST_TIME 156 1395.44 0.9943 1.0065 576 90
TEST_TIME 157 1401.07 0.9961 1.0052 540 83
TEST_TIME 158 1405.58 0.9957 1.0032 575 82
TEST_TIME 159 1409.00 0.9945 1.0043 545 85
TEST_TIME 160 1412.98 0.9952 1.0046 595 87
TEST_TIME 161 1414.73 0.9972 1.0030 555 76
TEST_TIME 162 1419.01 0.9939 1.0050 476 79
TEST_TIME 163 1423.04 0.9965 1.0030 599 79
TEST_TIME 164 1425.06 0.9955 1.0040 618 86
TEST_TIME 165 1429.37 0.9949 1.0047 548 89
TEST_TIME 166 1435.75 0.9942 1.0051 649 87
TEST_TIME 167 1442.29 0.9946 1.0039 740 89
TEST_TIME 168 1446.17 0.9953 1.0044 632 93
TEST_TIME 169 1449.66 0.9960 1.0047 612 87
TEST_TIME 170 1455.32 0.9949 1.0038 690 86
TEST_TIME 171 1458.20 0.9960 1.0043 595 83
TEST_TIME 172 1461.97 0.9959 1.0032 569 81
TEST_TIME 173 1462.62 0.9969 1.0026 533 74
TEST_TIME 174 1462.27 0.9972 1.0027 498 77
TEST_TIME 175 1461.35 0.9976 1.0031 591 72
TEST_TIME 176 1465.94 0.9935 1.0061 606 80
TEST_TIME 177 1472.21 0.9956 1.0035 571 79
TEST_TIME 178 1474.04 0.9966 1.0028 518 73
TEST_TIME 179 1479.24 0.9936 1.0051 591 77
TEST_TIME 180 1485.23 0.9955 1.0067 463 100
Done for 9190 ms, from 6:50:15.92 to 6:50:25.11.

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 53475 53397 60166 <null> 60248 <null> 45925 <null> 25486 12753 60335 8081 75484 56653 76554 38666 195001 146042 <null> 03:46:46 04:04:46
fetches per second 2 1638 1456 651 <null> 715 <null> 1682 <null> 1770 <null> 1308 <null> 1643 <null> 1597 <null> <null> <null> <null> 04:04:47 04:22:47
fetches per second 3 1928 1859 758 <null> 580 <null> 1886 <null> <null> <null> 1720 719 1828 <null> 1998 <null> <null> 3165 <null> 04:22:48 04:40:48
fetches per second 4 1988 1957 853 <null> 948 1540 <null> <null> 1421 1961 1811 465 2067 1834 2000 <null> 1606 <null> <null> 04:40:49 04:58:49
fetches per second 5 1835 <null> 1134 <null> 1292 <null> 2329 1457 <null> <null> 1768 455 2250 1384 1906 1906 <null> 4771 <null> 04:58:50 05:16:50
fetches per second 6 1890 1754 919 <null> 1009 <null> 2280 1945 1028 1581 1813 <null> 2201 <null> 2099 1620 <null> 4106 <null> 05:16:51 05:34:51
fetches per second 7 1775 1631 1171 <null> 1136 1198 2012 <null> 2284 <null> 1588 352 1870 1822 1813 <null> <null> <null> <null> 05:34:52 05:52:52
fetches per second 8 1821 1763 1102 <null> 1175 1333 2341 1288 1809 <null> 1726 335 2177 1576 2215 <null> <null> <null> <null> 05:52:53 06:10:53
fetches per second 9 1804 1785 957 1926 1235 <null> 2211 1258 455 1406 1611 <null> 2128 1441 1951 <null> <null> 3877 <null> 06:10:54 06:28:54
fetches per second 10 1801 2041 902 <null> 1343 <null> 2205 1331 2304 1224 1585 364 1908 <null> 1996 1022 <null> <null> <null> 06:28:55 06:46:55
marks per second 1 12294 7477 13484 <null> 14079 <null> 4323 <null> 2765 2986 13753 1793 6061 13031 2541 8833 14523 14401 <null> 03:46:46 04:04:46
marks per second 2 364 201 67 <null> 76 <null> 241 <null> 202 <null> 240 <null> 84 <null> 55 <null> <null> <null> <null> 04:04:47 04:22:47
marks per second 3 408 251 70 <null> 43 <null> 230 <null> <null> <null> 230 140 59 <null> 58 <null> <null> 25 <null> 04:22:48 04:40:48
marks per second 4 429 251 77 <null> 77 341 <null> <null> 78 436 334 97 73 564 66 <null> 257 <null> <null> 04:40:49 04:58:49
marks per second 5 405 <null> 127 <null> 171 <null> 237 278 <null> <null> 309 89 96 309 61 559 <null> 32 <null> 04:58:50 05:16:50
marks per second 6 400 286 89 <null> 100 <null> 205 363 70 340 317 <null> 102 <null> 75 401 <null> 31 <null> 05:16:51 05:34:51
marks per second 7 376 239 169 <null> 155 304 188 <null> 658 <null> 238 75 94 420 105 <null> <null> <null> <null> 05:34:52 05:52:52
marks per second 8 382 265 130 <null> 153 317 263 230 372 <null> 210 76 89 383 71 <null> <null> <null> <null> 05:52:53 06:10:53
marks per second 9 379 294 108 393 152 <null> 231 230 56 299 215 <null> 70 332 126 <null> <null> 29 <null> 06:10:54 06:28:54
marks per second 10 383 279 99 <null> 212 <null> 208 241 684 283 275 76 117 <null> 48 228 <null> <null> <null> 06:28:55 06:46:55
reads/fetches*100 1 1 2 0 <null> 1 <null> 2 <null> 3 1 2 2 2 2 1 2 0 1 <null> 03:46:46 04:04:46
reads/fetches*100 2 2 4 4 <null> 4 <null> 4 <null> 3 <null> 5 <null> 5 <null> 5 <null> <null> <null> <null> 04:04:47 04:22:47
reads/fetches*100 3 3 5 6 <null> 5 <null> 4 <null> <null> <null> 7 4 6 <null> 3 <null> <null> 1 <null> 04:22:48 04:40:48
reads/fetches*100 4 2 5 5 <null> 5 3 <null> <null> 8 5 5 4 6 3 3 <null> 22 <null> <null> 04:40:49 04:58:49
reads/fetches*100 5 2 <null> 3 <null> 3 <null> 2 3 <null> <null> 4 4 2 3 2 2 <null> 1 <null> 04:58:50 05:16:50
reads/fetches*100 6 2 4 4 <null> 4 <null> 3 3 4 4 4 <null> 3 <null> 5 2 <null> 1 <null> 05:16:51 05:34:51
reads/fetches*100 7 2 4 2 <null> 3 2 2 <null> 2 <null> 4 5 3 3 2 <null> <null> <null> <null> 05:34:52 05:52:52
reads/fetches*100 8 2 4 3 <null> 3 5 2 2 2 <null> 5 4 3 3 3 <null> <null> <null> <null> 05:52:53 06:10:53
reads/fetches*100 9 2 4 4 3 4 <null> 3 3 4 4 5 <null> 3 3 4 <null> <null> 0 <null> 06:10:54 06:28:54
reads/fetches*100 10 2 4 4 <null> 3 <null> 2 2 1 3 4 5 3 <null> 3 2 <null> <null> <null> 06:28:55 06:46:55
writes/marks*100 1 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 9 0 <null> 03:46:46 04:04:46
writes/marks*100 2 1 0 1 <null> 1 <null> 0 <null> 0 <null> 0 <null> 0 <null> 0 <null> <null> <null> <null> 04:04:47 04:22:47
writes/marks*100 3 0 0 0 <null> 0 <null> 0 <null> <null> <null> 0 0 1 <null> 0 <null> <null> 0 <null> 04:22:48 04:40:48
writes/marks*100 4 0 0 0 <null> 0 0 <null> <null> 0 0 0 0 0 0 0 <null> 0 <null> <null> 04:40:49 04:58:49
writes/marks*100 5 0 <null> 0 <null> 0 <null> 0 0 <null> <null> 0 0 0 0 0 0 <null> 0 <null> 04:58:50 05:16:50
writes/marks*100 6 1 0 0 <null> 0 <null> 0 0 3 0 0 <null> 0 <null> 0 0 <null> 0 <null> 05:16:51 05:34:51
writes/marks*100 7 0 0 0 <null> 0 0 0 <null> 0 <null> 0 0 1 0 0 <null> <null> <null> <null> 05:34:52 05:52:52
writes/marks*100 8 0 0 0 <null> 0 0 0 0 0 <null> 0 0 1 0 0 <null> <null> <null> <null> 05:52:53 06:10:53
writes/marks*100 9 0 0 0 0 0 <null> 0 0 0 1 0 <null> 0 1 0 <null> <null> 0 <null> 06:10:54 06:28:54
writes/marks*100 10 1 1 0 <null> 0 <null> 0 0 0 1 0 0 0 <null> 0 1 <null> <null> <null> 06:28:55 06:46:55
Done for 7780 ms, from 6:50:25.33 to 6:50:33.11.

Performance in DETAILS:

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL JOB_BEG JOB_END
doc_list_aiud 469496 443848 25648 5.46 0 39222 301 25200 2018-06-03 03:46 2018-06-03 06:46
doc_list_biud 469704 443848 25856 5.50 0 8596 57 25435 2018-06-03 03:46 2018-06-03 06:46
sp_add_invoice_to_stock 6981 3819 3162 45.29 125 2210029 103045 3158 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_adding_invoice 1077 721 356 33.05 15 208598 16460 356 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_client_order 2456 2409 47 1.91 0 1997 626 47 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_customer_reserve 48068 28392 19676 40.93 0 18643 457 19676 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_pay_from_customer 965 940 25 2.59 0 1154 286 25 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_pay_to_supplier 528 526 2 0.37 0 905 312 2 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_supplier_invoice 2599 1829 770 29.62 47 41951 2984 770 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_supplier_order 565 140 425 75.22 1030 608436 99055 425 2018-06-03 03:46 2018-06-03 06:46
sp_cancel_write_off 10089 5037 5052 50.07 0 7488 970 5052 2018-06-03 03:46 2018-06-03 06:46
sp_client_order 29847 29847 0 0.00 0 2621 855 0 2018-06-03 03:46 2018-06-03 06:46
sp_customer_reserve 148666 148421 245 0.16 0 46597 2412 0 2018-06-03 03:46 2018-06-03 06:46
sp_fill_shopping_cart 45158 45119 39 0.08 0 72559 3642 0 2018-06-03 03:46 2018-06-03 06:46
sp_fill_shopping_cart_clo_res 148665 148421 244 0.16 0 561 70 0 2018-06-03 03:46 2018-06-03 06:46
sp_get_clo_for_invoice 3823 3819 4 0.10 0 26133 4144 0 2018-06-03 03:46 2018-06-03 06:46
sp_kill_cost_storno 12384 7224 5160 41.66 0 998 66 5160 2018-06-03 03:46 2018-06-03 06:46
sp_kill_qstorno_ret_qs2qd 108421 63790 44631 41.16 0 7192 184 44631 2018-06-03 03:46 2018-06-03 06:46
sp_kill_qty_storno 80371 55010 25361 31.55 0 8346 394 25357 2018-06-03 03:46 2018-06-03 06:46
sp_lock_selected_doc 28987 23416 5571 19.21 0 187 15 5567 2018-06-03 03:46 2018-06-03 06:46
sp_make_cost_storno 34388 34384 4 0.01 0 39096 2728 0 2018-06-03 03:46 2018-06-03 06:46
sp_multiply_rows_for_pdistr 34388 34384 4 0.01 0 515 82 0 2018-06-03 03:46 2018-06-03 06:46
sp_multiply_rows_for_qdistr 29847 29847 0 0.00 0 1560 316 0 2018-06-03 03:46 2018-06-03 06:46
sp_pay_from_customer 9865 9865 0 0.00 15 16256 3108 0 2018-06-03 03:46 2018-06-03 06:46
sp_pay_to_supplier 8037 8037 0 0.00 15 39408 6662 0 2018-06-03 03:46 2018-06-03 06:46
sp_payment_common 17902 17902 0 0.00 0 11263 312 0 2018-06-03 03:46 2018-06-03 06:46
sp_qd_handle_on_cancel_clo 2456 2409 47 1.91 0 1420 297 47 2018-06-03 03:46 2018-06-03 06:46
sp_qd_handle_on_invoice_upd_sts 4753 4540 213 4.48 0 5678 1110 209 2018-06-03 03:46 2018-06-03 06:46
sp_qd_handle_on_reserve_upd_sts 12663 12663 0 0.00 0 1420 228 0 2018-06-03 03:46 2018-06-03 06:46
sp_reserve_write_off 13981 12663 1318 9.42 0 35802 1839 1318 2018-06-03 03:46 2018-06-03 06:46
sp_supplier_invoice 7688 7672 16 0.20 0 90264 21910 0 2018-06-03 03:46 2018-06-03 06:46
sp_supplier_order 7623 7600 23 0.30 0 89624 19004 0 2018-06-03 03:46 2018-06-03 06:46
srv_find_qd_qs_mism 265200 239745 25455 9.59 0 6661 126 25229 2018-06-03 03:46 2018-06-03 06:46
srv_make_invnt_saldo 80 80 0 0.00 0 988025 132836 0 2018-06-03 03:46 2018-06-03 06:46
srv_make_money_saldo 1126 1126 0 0.00 0 203068 4000 0 2018-06-03 03:46 2018-06-03 06:46
srv_recalc_idx_stat 11 11 0 0.00 45397 80404 61887 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_add_invoice_to_stock 3190 3190 0 0.00 0 1373 72 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_adding_invoice 466 466 0 0.00 0 1107 411 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_client_order 47 47 0 0.00 32 172 75 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_customer_reserve 98 98 0 0.00 0 281 69 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_pay_from_customer 25 25 0 0.00 47 187 99 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_pay_to_supplier 2 2 0 0.00 62 172 117 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_supplier_invoice 259 259 0 0.00 0 327 65 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_supplier_order 2904 2904 0 0.00 0 1263 545 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_cancel_write_off 30 30 0 0.00 16 140 51 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_reserve_write_off 1318 1318 0 0.00 0 453 58 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_supplier_invoice 16 16 0 0.00 15 218 80 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-abend:sp_supplier_order 23 23 0 0.00 46 171 87 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_add_invoice_to_stock 3819 3819 0 0.00 0 13775 3398 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 0 13666 3006 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_client_order 2409 2409 0 0.00 0 422 104 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_customer_reserve 841 841 0 0.00 0 390 115 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_pay_from_customer 940 940 0 0.00 0 375 80 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_pay_to_supplier 526 526 0 0.00 0 265 78 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_supplier_invoice 313 313 0 0.00 0 343 108 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_supplier_order 140 140 0 0.00 109 69485 10348 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_cancel_write_off 1396 1396 0 0.00 0 483 118 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_client_order 29847 29847 0 0.00 0 795 135 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_customer_reserve 1363 1363 0 0.00 0 437 97 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_pay_from_customer 9865 9865 0 0.00 0 546 97 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_pay_to_supplier 8037 8037 0 0.00 0 670 98 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_reserve_write_off 12663 12663 0 0.00 0 671 129 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_supplier_invoice 7672 7672 0 0.00 0 671 151 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:sp_supplier_order 7600 7600 0 0.00 0 639 146 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:srv_make_invnt_saldo 80 80 0 0.00 0 453 44 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:srv_make_money_saldo 1126 1126 0 0.00 0 281 17 0 2018-06-03 03:46 2018-06-03 06:46
t$perf-norm:srv_recalc_idx_stat 11 11 0 0.00 358 717 524 0 2018-06-03 03:46 2018-06-03 06:46
v_add_invoice_to_stock 13962 7638 6324 45.29 0 640 138 6316 2018-06-03 03:46 2018-06-03 06:46
v_all_customers 44920 44920 0 0.00 0 157 11 0 2018-06-03 03:46 2018-06-03 06:46
v_all_suppliers 30622 30544 78 0.25 0 171 14 0 2018-06-03 03:46 2018-06-03 06:46
v_all_wares 59694 59694 0 0.00 0 140 12 0 2018-06-03 03:46 2018-06-03 06:46
v_cancel_adding_invoice 1148 738 410 35.71 0 7630 1682 410 2018-06-03 03:46 2018-06-03 06:46
v_cancel_client_order 4912 4818 94 1.91 0 343 17 94 2018-06-03 03:46 2018-06-03 06:46
v_cancel_customer_prepayment 1930 1880 50 2.59 0 327 40 50 2018-06-03 03:46 2018-06-03 06:46
v_cancel_customer_reserve 1878 1682 196 10.43 0 546 60 196 2018-06-03 03:46 2018-06-03 06:46
v_cancel_payment_to_supplier 1056 1052 4 0.37 0 359 53 4 2018-06-03 03:46 2018-06-03 06:46
v_cancel_supplier_invoice 1144 626 518 45.27 0 593 147 518 2018-06-03 03:46 2018-06-03 06:46
v_cancel_supplier_order 1130 280 850 75.22 0 390 61 850 2018-06-03 03:46 2018-06-03 06:46
v_cancel_write_off 2852 2792 60 2.10 0 6380 733 60 2018-06-03 03:46 2018-06-03 06:46
v_max_id_clo_ord 7623 7600 23 0.30 0 3745 299 0 2018-06-03 03:46 2018-06-03 06:46
v_max_id_clo_res 1363 1363 0 0.00 0 343 55 0 2018-06-03 03:46 2018-06-03 06:46
v_max_id_ord_sup 7688 7672 16 0.20 0 3885 290 0 2018-06-03 03:46 2018-06-03 06:46
v_max_non_paid_invoice 8037 8037 0 0.00 0 421 28 0 2018-06-03 03:46 2018-06-03 06:46
v_max_non_paid_realizn 9865 9865 0 0.00 0 140 12 0 2018-06-03 03:46 2018-06-03 06:46
v_min_id_clo_ord 7623 7600 23 0.30 0 5741 306 0 2018-06-03 03:46 2018-06-03 06:46
v_min_id_clo_res 1363 1363 0 0.00 0 8252 406 0 2018-06-03 03:46 2018-06-03 06:46
v_min_id_ord_sup 7688 7672 16 0.20 0 3042 333 0 2018-06-03 03:46 2018-06-03 06:46
v_min_non_paid_invoice 8037 8037 0 0.00 0 5086 310 0 2018-06-03 03:46 2018-06-03 06:46
v_min_non_paid_realizn 9865 9865 0 0.00 0 3604 74 0 2018-06-03 03:46 2018-06-03 06:46
v_our_firm 14774 14774 0 0.00 0 187 14 0 2018-06-03 03:46 2018-06-03 06:46
v_reserve_write_off 27962 25326 2636 9.42 0 624 54 2636 2018-06-03 03:46 2018-06-03 06:46
x_lock_depdocs_on_canc_invoice 4716 2237 2479 52.56 0 2886 222 2479 2018-06-03 03:46 2018-06-03 06:46
x_lock_depdocs_on_canc_sup_ord 564 140 424 75.17 0 1186 253 424 2018-06-03 03:46 2018-06-03 06:46
x_make_qstorno_1000_1200 7623 7600 23 0.30 0 27925 8516 0 2018-06-03 03:46 2018-06-03 06:46
x_make_qstorno_1200_2000 7688 7672 16 0.20 0 39329 11106 0 2018-06-03 03:46 2018-06-03 06:46
x_make_qstorno_2100_3300 148666 148421 245 0.16 0 41060 2249 0 2018-06-03 03:46 2018-06-03 06:46
Done for 82430 ms, from 6:51:41.93 to 6:53:04.36.

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 72 sp_kill_cost_storno 335544336 2018-06-03 03:48 2018-06-03 06:45
deadlock 32 sp_kill_qstorno_ret_qs2qd 335544336 2018-06-03 03:47 2018-06-03 06:40
deadlock 4868 sp_lock_selected_doc 335544336 2018-06-03 03:46 2018-06-03 06:46
deadlock 47 sp_qd_handle_on_cancel_clo 335544336 2018-06-03 03:47 2018-06-03 06:42
deadlock 102 sp_qd_handle_on_invoice_upd_sts 335544336 2018-06-03 03:48 2018-06-03 06:45
deadlock 360 x_lock_depdocs_on_canc_invoice 335544336 2018-06-03 03:47 2018-06-03 06:45
deadlock 84 x_lock_depdocs_on_canc_sup_ord 335544336 2018-06-03 03:48 2018-06-03 06:44
user_exc 23 x_make_qstorno_1000_1200 335544517 2018-06-03 03:47 2018-06-03 06:39
user_exc 16 x_make_qstorno_1200_2000 335544517 2018-06-03 03:47 2018-06-03 06:42
user_exc 4 x_make_qstorno_2100_3300 335544517 2018-06-03 06:46 2018-06-03 06:46
Done for 3540 ms, from 6:53:07.47 to 6:53:11.01.

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 440270
MON$OLDEST_ACTIVE 440271
MON$OLDEST_SNAPSHOT 440271
MON$NEXT_TRANSACTION 440271
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 Sun Jun 03 06:53:11 2018

Database header page information:
Flags 0
Generation 440470
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 440272
Oldest active 440273
Oldest snapshot 440273
Next transaction 440274
Sequence number 0
Next attachment ID 8940
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.46, total records: 1200327
Average version length: 46.15, total versions: 2332, 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: 13576
Data pages: 13576, average fill: 69%
Primary pages: 13576, secondary pages: 0, swept pages: 11658
Empty pages: 2, full pages: 5216
Fill distribution:
0 - 19% = 3
20 - 39% = 19
40 - 59% = 713
60 - 79% = 12837
80 - 99% = 4

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 4480, nodes: 1200327
Average node length: 18.36, total dup: 0, max dup: 0
Average key length: 15.44, compression ratio: 1.75
Average prefix length: 14.55, average data length: 12.45
Clustering factor: 221459, ratio: 0.18
Fill distribution:
0 - 19% = 296
20 - 39% = 53
40 - 59% = 2426
60 - 79% = 379
80 - 99% = 1326

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 3903, nodes: 1200327
Average node length: 11.76, 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: 143400, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 643
40 - 59% = 3260
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 179498, depth: 3, leaf buckets: 1539, nodes: 1200327
Average node length: 6.30, total dup: 966536, max dup: 49
Average key length: 3.38, compression ratio: 2.66
Average prefix length: 7.81, average data length: 1.19
Clustering factor: 209907, ratio: 0.17
Fill distribution:
0 - 19% = 16
20 - 39% = 79
40 - 59% = 951
60 - 79% = 17
80 - 99% = 476

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 59.43, total records: 270816
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 15.65, total fragments: 23, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.62
Pointer pages: 3, data page slots: 3552
Data pages: 3552, average fill: 72%
Primary pages: 3548, secondary pages: 4, swept pages: 3500
Empty pages: 0, full pages: 1896
Fill distribution:
0 - 19% = 6
20 - 39% = 6
40 - 59% = 64
60 - 79% = 3472
80 - 99% = 4

Index DOC_LIST_ID_DESC (1)
Root page: 283959, depth: 3, leaf buckets: 908, nodes: 270816
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 9.02, compression ratio: 1.00
Average prefix length: 2.97, average data length: 6.03
Clustering factor: 39269, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 195
40 - 59% = 713
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 284, nodes: 270816
Average node length: 4.69, total dup: 270766, max dup: 27087
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 119914, ratio: 0.44
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 250
60 - 79% = 21
80 - 99% = 12

Index PK_DOC_LIST (0)
Root page: 331632, depth: 3, leaf buckets: 742, nodes: 270816
Average node length: 11.70, total dup: 0, max dup: 0
Average key length: 9.02, compression ratio: 1.00
Average prefix length: 2.97, average data length: 6.03
Clustering factor: 39269, ratio: 0.15
Fill distribution:
0 - 19% = 15
20 - 39% = 70
40 - 59% = 515
60 - 79% = 2
80 - 99% = 140

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

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 70.88, total records: 71221
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: 4072
Data pages: 2120, average fill: 38%
Primary pages: 2120, secondary pages: 0, swept pages: 1861
Empty pages: 411, full pages: 588
Fill distribution:
0 - 19% = 787
20 - 39% = 458
40 - 59% = 204
60 - 79% = 671
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 203093, depth: 3, leaf buckets: 384, nodes: 71221
Average node length: 14.05, total dup: 5229, max dup: 3
Average key length: 11.37, compression ratio: 2.38
Average prefix length: 18.55, average data length: 8.45
Clustering factor: 66434, ratio: 0.93
Fill distribution:
0 - 19% = 3
20 - 39% = 350
40 - 59% = 29
60 - 79% = 2
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.92, 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.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 19%
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: 46.07, total records: 105
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.39
Pointer pages: 1, data page slots: 24
Data pages: 18, average fill: 9%
Primary pages: 17, secondary pages: 1, swept pages: 17
Empty pages: 3, full pages: 0
Fill distribution:
0 - 19% = 17
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 178326, depth: 2, leaf buckets: 1, nodes: 105
Average node length: 10.01, total dup: 66, max dup: 14
Average key length: 8.05, compression ratio: 2.36
Average prefix length: 13.31, average data length: 5.69
Clustering factor: 56, ratio: 0.53
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.07, total records: 128516
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 33.35, total fragments: 20, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 2088
Data pages: 2088, average fill: 47%
Primary pages: 2057, secondary pages: 31, swept pages: 2038
Empty pages: 50, full pages: 22
Fill distribution:
0 - 19% = 231
20 - 39% = 359
40 - 59% = 975
60 - 79% = 523
80 - 99% = 0

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 130, nodes: 128516
Average node length: 4.36, total dup: 128467, max dup: 7922
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 19197, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 29
40 - 59% = 59
60 - 79% = 30
80 - 99% = 12

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 152, nodes: 128516
Average node length: 5.31, total dup: 115970, max dup: 37
Average key length: 2.97, compression ratio: 7.41
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 22591, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 88
60 - 79% = 39
80 - 99% = 10

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 150, nodes: 128516
Average node length: 5.31, total dup: 115970, max dup: 37
Average key length: 2.97, compression ratio: 7.41
Average prefix length: 21.13, average data length: 0.87
Clustering factor: 22606, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 22
40 - 59% = 70
60 - 79% = 47
80 - 99% = 10

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 169, nodes: 128516
Average node length: 5.09, total dup: 115970, max dup: 37
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 22639, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 47
40 - 59% = 95
60 - 79% = 23
80 - 99% = 4

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.89, total records: 98640
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 1, data page slots: 840
Data pages: 840, average fill: 65%
Primary pages: 840, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 839
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 839
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 412030, depth: 2, leaf buckets: 73, nodes: 98640
Average node length: 3.99, total dup: 98459, max dup: 2152
Average key length: 2.00, compression ratio: 1.31
Average prefix length: 2.62, average data length: 0.00
Clustering factor: 15492, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 26
60 - 79% = 33
80 - 99% = 14

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

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 4535, nodes: 4012744
Average node length: 5.47, total dup: 3189776, max dup: 57
Average key length: 2.48, compression ratio: 3.22
Average prefix length: 7.64, average data length: 0.35
Clustering factor: 2208843, ratio: 0.55
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 2991
60 - 79% = 900
80 - 99% = 642

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 3513, nodes: 4012744
Average node length: 4.04, total dup: 4012740, max dup: 3808867
Average key length: 1.05, compression ratio: 0.24
Average prefix length: 0.25, average data length: 0.00
Clustering factor: 112916, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 3509
60 - 79% = 1
80 - 99% = 2

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 4592, nodes: 4012744
Average node length: 5.35, total dup: 3813136, max dup: 6070
Average key length: 2.36, compression ratio: 3.81
Average prefix length: 8.68, average data length: 0.32
Clustering factor: 416285, ratio: 0.10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3366
60 - 79% = 667
80 - 99% = 559

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 4361, nodes: 4012744
Average node length: 5.18, total dup: 3951787, max dup: 415831
Average key length: 2.19, compression ratio: 17.11
Average prefix length: 37.34, average data length: 0.18
Clustering factor: 2912770, ratio: 0.73
Fill distribution:
0 - 19% = 8
20 - 39% = 2
40 - 59% = 3276
60 - 79% = 529
80 - 99% = 546

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.11, total records: 272711
Average version length: 54.05, total versions: 727, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.48
Pointer pages: 3, data page slots: 3376
Data pages: 3376, average fill: 71%
Primary pages: 3376, secondary pages: 0, swept pages: 3084
Empty pages: 5, full pages: 1657
Fill distribution:
0 - 19% = 6
20 - 39% = 17
40 - 59% = 247
60 - 79% = 3100
80 - 99% = 6

Index PSTORNED_RCV_ID (2)
Root page: 2270, depth: 2, leaf buckets: 386, nodes: 272711
Average node length: 5.72, total dup: 234512, max dup: 283
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 17441, ratio: 0.06
Fill distribution:
0 - 19% = 4
20 - 39% = 11
40 - 59% = 346
60 - 79% = 19
80 - 99% = 6

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 290, nodes: 272711
Average node length: 5.43, total dup: 245808, max dup: 105
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 48465, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 132
60 - 79% = 107
80 - 99% = 46

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.49, total records: 1247
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: 75%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 15
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 15
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.09, total records: 5469
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: 2536
Data pages: 360, average fill: 18%
Primary pages: 360, secondary pages: 0, swept pages: 359
Empty pages: 172, full pages: 34
Fill distribution:
0 - 19% = 261
20 - 39% = 32
40 - 59% = 22
60 - 79% = 45
80 - 99% = 0

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 16, nodes: 5469
Average node length: 6.90, total dup: 4760, max dup: 14
Average key length: 4.71, compression ratio: 7.85
Average prefix length: 34.41, average data length: 2.59
Clustering factor: 794, ratio: 0.15
Fill distribution:
0 - 19% = 2
20 - 39% = 11
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.35, total records: 678057
Average version length: 71.00, total versions: 308, 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: 10864
Data pages: 10864, average fill: 68%
Primary pages: 10864, secondary pages: 0, swept pages: 10044
Empty pages: 31, full pages: 5754
Fill distribution:
0 - 19% = 154
20 - 39% = 441
40 - 59% = 1587
60 - 79% = 8655
80 - 99% = 27

Index XQD_1000_3300_DOC (1)
Root page: 280298, depth: 3, leaf buckets: 751, nodes: 678057
Average node length: 5.10, total dup: 660642, max dup: 121
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 64843, ratio: 0.10
Fill distribution:
0 - 19% = 9
20 - 39% = 40
40 - 59% = 537
60 - 79% = 16
80 - 99% = 149

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 200402, depth: 3, leaf buckets: 933, nodes: 678057
Average node length: 6.23, total dup: 592201, max dup: 14
Average key length: 3.33, compression ratio: 11.12
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 123773, ratio: 0.18
Fill distribution:
0 - 19% = 29
20 - 39% = 103
40 - 59% = 497
60 - 79% = 166
80 - 99% = 138

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 71.56, total records: 28444
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.90
Pointer pages: 3, data page slots: 3632
Data pages: 1504, average fill: 22%
Primary pages: 1504, secondary pages: 0, swept pages: 1503
Empty pages: 604, full pages: 55
Fill distribution:
0 - 19% = 869
20 - 39% = 255
40 - 59% = 204
60 - 79% = 176
80 - 99% = 0

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 57, nodes: 28444
Average node length: 6.00, total dup: 25427, max dup: 49
Average key length: 3.48, compression ratio: 10.65
Average prefix length: 35.63, average data length: 1.37
Clustering factor: 3047, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 37
40 - 59% = 11
60 - 79% = 7
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 71.05, total records: 748156
Average version length: 69.33, total versions: 3785, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 12, data page slots: 19112
Data pages: 18712, average fill: 45%
Primary pages: 18712, secondary pages: 0, swept pages: 17104
Empty pages: 1129, full pages: 2973
Fill distribution:
0 - 19% = 3321
20 - 39% = 4525
40 - 59% = 5168
60 - 79% = 5621
80 - 99% = 77

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 191390, depth: 3, leaf buckets: 1179, nodes: 748156
Average node length: 5.67, total dup: 698570, max dup: 49
Average key length: 2.73, compression ratio: 13.54
Average prefix length: 36.33, average data length: 0.67
Clustering factor: 90150, ratio: 0.12
Fill distribution:
0 - 19% = 50
20 - 39% = 655
40 - 59% = 147
60 - 79% = 222
80 - 99% = 105

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 69.66, total records: 2705
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.95
Pointer pages: 5, data page slots: 3112
Data pages: 1184, average fill: 3%
Primary pages: 1182, secondary pages: 2, swept pages: 1182
Empty pages: 846, full pages: 0
Fill distribution:
0 - 19% = 1143
20 - 39% = 32
40 - 59% = 9
60 - 79% = 0
80 - 99% = 0

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 9, nodes: 2705
Average node length: 10.14, total dup: 1920, max dup: 20
Average key length: 7.72, compression ratio: 4.79
Average prefix length: 31.57, average data length: 5.43
Clustering factor: 618, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 5
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 69.90, total records: 1271360
Average version length: 69.03, total versions: 11900, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.95
Pointer pages: 15, data page slots: 24256
Data pages: 24256, average fill: 57%
Primary pages: 24256, secondary pages: 0, swept pages: 22654
Empty pages: 238, full pages: 5624
Fill distribution:
0 - 19% = 840
20 - 39% = 3266
40 - 59% = 7863
60 - 79% = 12027
80 - 99% = 260

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 2493, nodes: 1271360
Average node length: 6.66, total dup: 1061449, max dup: 20
Average key length: 3.71, compression ratio: 9.97
Average prefix length: 35.45, average data length: 1.55
Clustering factor: 254351, ratio: 0.20
Fill distribution:
0 - 19% = 29
20 - 39% = 1356
40 - 59% = 742
60 - 79% = 240
80 - 99% = 126

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 82.12, total records: 2625160
Average version length: 81.94, total versions: 2179, 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: 41048
Data pages: 41048, average fill: 78%
Primary pages: 41048, secondary pages: 0, swept pages: 17025
Empty pages: 16, full pages: 35330
Fill distribution:
0 - 19% = 31
20 - 39% = 83
40 - 59% = 848
60 - 79% = 17370
80 - 99% = 22716

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 2787, nodes: 2625160
Average node length: 5.15, total dup: 2565214, max dup: 123
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 384152, ratio: 0.15
Fill distribution:
0 - 19% = 20
20 - 39% = 8
40 - 59% = 1667
60 - 79% = 764
80 - 99% = 328

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 2801, nodes: 2625160
Average node length: 5.73, total dup: 2339623, max dup: 49
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 130768, ratio: 0.05
Fill distribution:
0 - 19% = 20
20 - 39% = 39
40 - 59% = 1630
60 - 79% = 41
80 - 99% = 1071

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 3149, nodes: 2625160
Average node length: 5.82, total dup: 2296731, max dup: 29
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 425104, ratio: 0.16
Fill distribution:
0 - 19% = 20
20 - 39% = 7
40 - 59% = 1903
60 - 79% = 805
80 - 99% = 414

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 80.61, total records: 1314085
Average version length: 80.60, total versions: 12574, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.69
Pointer pages: 15, data page slots: 23784
Data pages: 23784, average fill: 67%
Primary pages: 23784, secondary pages: 0, swept pages: 20679
Empty pages: 449, full pages: 13516
Fill distribution:
0 - 19% = 1112
20 - 39% = 1476
40 - 59% = 3392
60 - 79% = 10465
80 - 99% = 7339

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 1555, nodes: 1314085
Average node length: 5.14, total dup: 1283375, max dup: 199
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 121346, ratio: 0.09
Fill distribution:
0 - 19% = 5
20 - 39% = 65
40 - 59% = 1147
60 - 79% = 314
80 - 99% = 24

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 1722, nodes: 1314085
Average node length: 6.01, total dup: 1118464, max dup: 14
Average key length: 3.06, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 69643, ratio: 0.05
Fill distribution:
0 - 19% = 30
20 - 39% = 388
40 - 59% = 561
60 - 79% = 413
80 - 99% = 330

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 1791, nodes: 1314085
Average node length: 5.84, total dup: 1149997, max dup: 34
Average key length: 2.88, compression ratio: 3.12
Average prefix length: 8.24, average data length: 0.76
Clustering factor: 160338, ratio: 0.12
Fill distribution:
0 - 19% = 40
20 - 39% = 41
40 - 59% = 1343
60 - 79% = 333
80 - 99% = 34

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 82.20, total records: 2700128
Average version length: 82.70, total versions: 887, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 29, data page slots: 47296
Data pages: 47232, average fill: 70%
Primary pages: 47232, secondary pages: 0, swept pages: 20089
Empty pages: 360, full pages: 31943
Fill distribution:
0 - 19% = 1382
20 - 39% = 3075
40 - 59% = 5841
60 - 79% = 14791
80 - 99% = 22143

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 3078, nodes: 2700128
Average node length: 5.03, total dup: 2683734, max dup: 587
Average key length: 2.06, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 311671, ratio: 0.12
Fill distribution:
0 - 19% = 6
20 - 39% = 313
40 - 59% = 1996
60 - 79% = 565
80 - 99% = 198

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 2973, nodes: 2700128
Average node length: 5.66, total dup: 2437385, max dup: 49
Average key length: 2.68, compression ratio: 3.36
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 142581, ratio: 0.05
Fill distribution:
0 - 19% = 24
20 - 39% = 609
40 - 59% = 1151
60 - 79% = 124
80 - 99% = 1065

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 3499, nodes: 2700128
Average node length: 5.73, total dup: 2408085, max dup: 61
Average key length: 2.76, compression ratio: 3.26
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 384552, ratio: 0.14
Fill distribution:
0 - 19% = 3
20 - 39% = 293
40 - 59% = 2352
60 - 79% = 656
80 - 99% = 195

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.30, total records: 1965993
Average version length: 80.54, total versions: 13828, 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: 22, data page slots: 35336
Data pages: 35336, average fill: 68%
Primary pages: 35336, secondary pages: 0, swept pages: 31502
Empty pages: 391, full pages: 17872
Fill distribution:
0 - 19% = 982
20 - 39% = 1507
40 - 59% = 5578
60 - 79% = 18650
80 - 99% = 8619

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 2133, nodes: 1965993
Average node length: 5.02, total dup: 1954517, max dup: 786
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 492920, ratio: 0.25
Fill distribution:
0 - 19% = 4
20 - 39% = 130
40 - 59% = 1196
60 - 79% = 647
80 - 99% = 156

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 2947, nodes: 1965993
Average node length: 6.06, total dup: 1664446, max dup: 14
Average key length: 3.09, compression ratio: 2.92
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 160419, ratio: 0.08
Fill distribution:
0 - 19% = 95
20 - 39% = 832
40 - 59% = 1252
60 - 79% = 371
80 - 99% = 397

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 2390, nodes: 1965993
Average node length: 5.74, total dup: 1752513, max dup: 57
Average key length: 2.77, compression ratio: 3.25
Average prefix length: 8.34, average data length: 0.66
Clustering factor: 501466, ratio: 0.26
Fill distribution:
0 - 19% = 2
20 - 39% = 110
40 - 59% = 1281
60 - 79% = 791
80 - 99% = 206

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 67.80, total records: 704967
Average version length: 68.87, total versions: 12262, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.01
Pointer pages: 7, data page slots: 10872
Data pages: 10872, average fill: 69%
Primary pages: 10872, secondary pages: 0, swept pages: 8724
Empty pages: 100, full pages: 7683
Fill distribution:
0 - 19% = 433
20 - 39% = 662
40 - 59% = 1025
60 - 79% = 8454
80 - 99% = 298

Index XQS_3300_3400_DOC_ID (0)
Root page: 175329, depth: 3, leaf buckets: 808, nodes: 704967
Average node length: 5.16, total dup: 681360, max dup: 201
Average key length: 2.26, compression ratio: 3.98
Average prefix length: 8.77, average data length: 0.23
Clustering factor: 34809, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 98
40 - 59% = 420
60 - 79% = 223
80 - 99% = 67

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 917, nodes: 704967
Average node length: 5.86, total dup: 612039, max dup: 29
Average key length: 2.96, compression ratio: 3.04
Average prefix length: 8.17, average data length: 0.83
Clustering factor: 43817, ratio: 0.06
Fill distribution:
0 - 19% = 1
20 - 39% = 129
40 - 59% = 437
60 - 79% = 281
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 Sun Jun 03 06:53:23 2018

Done for 12270 ms, from 6:53:11.27 to 6:53:23.54.

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 1200327 2332 0.1942
DOC_LIST 270816 0 0.0000
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 71221 0 0.0000
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 105 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 128516 0 0.0000
PERF_ESTIMATED 98640 0 0.0000
PERF_LOG 4012744 0 0.0000
PSTORNED 272711 727 0.2665
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 1247 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 5469 0 0.0000
XQD_1000_3300 678057 308 0.0454
XQD_1200_2000 28444 0 0.0000
XQD_2000_3300 748156 3785 0.5059
XQD_2100_3300 2705 0 0.0000
XQD_3300_3400 1271360 11900 0.9360
XQS_1000_1200 2625160 2179 0.0830
XQS_1000_3300 1314085 12574 0.9568
XQS_1200_2000 2700128 887 0.0328
XQS_2100_3300 1965993 13828 0.7033
XQS_3300_3400 704967 12262 1.7393
Z_USED_VIEWS 29 0 0.0000
Done for 2270 ms, from 6:53:31.45 to 6:53:33.72.

Database validation

06:53:33.80 Validation started

06:53:33.80 Relation 140 (DOC_LIST)
06:53:33.80 process pointer page 0 of 3
06:53:33.88 process pointer page 1 of 3
06:53:33.94 process pointer page 2 of 3
06:53:33.94 Index 1 (PK_DOC_LIST)
06:53:34.02 Index 2 (DOC_LIST_ID_DESC)
06:53:34.13 Index 3 (FK_DOC_LIST_AGENTS)
06:53:34.22 Relation 140 (DOC_LIST) is ok

06:53:34.22 Relation 141 (DOC_DATA)
06:53:34.22 process pointer page 0 of 9
06:53:34.25 process pointer page 1 of 9
06:53:34.28 process pointer page 2 of 9
06:53:34.32 process pointer page 3 of 9
06:53:34.35 process pointer page 4 of 9
06:53:34.38 process pointer page 5 of 9
06:53:34.41 process pointer page 6 of 9
06:53:34.49 process pointer page 7 of 9
06:53:34.57 process pointer page 8 of 9
06:53:34.57 Index 2 (DOC_DATA_DOC_WARE_UNQ)
06:53:34.96 Index 3 (DOC_DATA_ID_DESC)
06:53:35.11 Index 4 (FK_DOC_DATA_DOC_LIST)
06:53:35.31 Relation 141 (DOC_DATA) is ok

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

06:53:35.31 Relation 150 (PDISTR)
06:53:35.31 process pointer page 0 of 2
06:53:35.39 process pointer page 1 of 2
06:53:35.41 Index 2 (PDISTR_SND_ID)
06:53:35.44 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
06:53:35.49 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
06:53:35.53 Index 5 (PDISTR_AGENT_ID)
06:53:35.56 Relation 150 (PDISTR) is ok

06:53:35.56 Relation 151 (PSTORNED)
06:53:35.56 process pointer page 0 of 3
06:53:35.66 process pointer page 1 of 3
06:53:35.74 process pointer page 2 of 3
06:53:35.74 Index 2 (PSTORNED_SND_ID)
06:53:35.81 Index 3 (PSTORNED_RCV_ID)
06:53:35.89 Relation 151 (PSTORNED) is ok

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

06:53:35.89 Relation 157 (INVNT_TURNOVER_LOG)
06:53:35.89 process pointer page 0 of 3
06:53:35.92 process pointer page 1 of 3
06:53:35.97 process pointer page 2 of 3
06:53:35.98 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
06:53:36.02 Relation 157 (INVNT_TURNOVER_LOG) is ok

06:53:36.02 Relation 160 (PERF_ESTIMATED)
06:53:36.02 process pointer page 0 of 1
06:53:36.03 Index 1 (PERF_EST_MINUTE_SINCE_START)
06:53:36.05 Relation 160 (PERF_ESTIMATED) is ok

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

06:53:36.05 Relation 162 (TRACE_STAT)
06:53:36.05 process pointer page 0 of 1
06:53:36.05 Relation 162 (TRACE_STAT) is ok

06:53:36.05 Relation 163 (PERF_LOG)
06:53:36.05 process pointer page 0 of 58
06:53:36.08 process pointer page 1 of 58
06:53:36.11 process pointer page 2 of 58
06:53:36.13 process pointer page 3 of 58
06:53:36.16 process pointer page 4 of 58
06:53:36.19 process pointer page 5 of 58
06:53:36.22 process pointer page 6 of 58
06:53:36.30 process pointer page 7 of 58
06:53:36.37 process pointer page 8 of 58
06:53:36.44 process pointer page 9 of 58
06:53:36.52 process pointer page 10 of 58
06:53:36.59 process pointer page 11 of 58
06:53:36.66 process pointer page 12 of 58
06:53:36.73 process pointer page 13 of 58
06:53:36.81 process pointer page 14 of 58
06:53:36.89 process pointer page 15 of 58
06:53:36.94 process pointer page 16 of 58
06:53:36.97 process pointer page 17 of 58
06:53:36.98 process pointer page 18 of 58
06:53:37.01 process pointer page 19 of 58
06:53:37.05 process pointer page 20 of 58
06:53:37.08 process pointer page 21 of 58
06:53:37.15 process pointer page 22 of 58
06:53:37.23 process pointer page 23 of 58
06:53:37.31 process pointer page 24 of 58
06:53:37.37 process pointer page 25 of 58
06:53:37.40 process pointer page 26 of 58
06:53:37.45 process pointer page 27 of 58
06:53:37.53 process pointer page 28 of 58
06:53:37.59 process pointer page 29 of 58
06:53:37.67 process pointer page 30 of 58
06:53:37.75 process pointer page 31 of 58
06:53:37.81 process pointer page 32 of 58
06:53:37.89 process pointer page 33 of 58
06:53:37.97 process pointer page 34 of 58
06:53:38.04 process pointer page 35 of 58
06:53:38.11 process pointer page 36 of 58
06:53:38.18 process pointer page 37 of 58
06:53:38.23 process pointer page 38 of 58
06:53:38.26 process pointer page 39 of 58
06:53:38.31 process pointer page 40 of 58
06:53:38.39 process pointer page 41 of 58
06:53:38.45 process pointer page 42 of 58
06:53:38.53 process pointer page 43 of 58
06:53:38.54 process pointer page 44 of 58
06:53:38.57 process pointer page 45 of 58
06:53:38.61 process pointer page 46 of 58
06:53:38.67 process pointer page 47 of 58
06:53:38.73 process pointer page 48 of 58
06:53:38.75 process pointer page 49 of 58
06:53:38.78 process pointer page 50 of 58
06:53:38.81 process pointer page 51 of 58
06:53:38.84 process pointer page 52 of 58
06:53:38.87 process pointer page 53 of 58
06:53:38.95 process pointer page 54 of 58
06:53:39.03 process pointer page 55 of 58
06:53:39.09 process pointer page 56 of 58
06:53:39.17 process pointer page 57 of 58
06:53:39.20 Index 1 (PERF_LOG_DTS_BEG_DESC)
06:53:40.54 Index 2 (PERF_LOG_UNIT)
06:53:42.43 Index 3 (PERF_LOG_TRN_DESC)
06:53:42.80 Index 4 (PERF_LOG_GDSCODE)
06:53:43.29 Relation 163 (PERF_LOG) is ok

06:53:43.29 Relation 167 (V_STOPTEST)
06:53:43.29 Relation 167 (V_STOPTEST) is ok

06:53:43.29 Relation 184 (V_QDISTR_SOURCE)
06:53:43.29 Relation 184 (V_QDISTR_SOURCE) is ok

06:53:43.29 Relation 185 (V_QSTORNED_SOURCE)
06:53:43.29 Relation 185 (V_QSTORNED_SOURCE) is ok

06:53:43.29 Relation 260 (XQD_1000_1200)
06:53:43.29 process pointer page 0 of 3
06:53:43.29 process pointer page 1 of 3
06:53:43.29 process pointer page 2 of 3
06:53:43.29 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
06:53:43.29 Relation 260 (XQD_1000_1200) is ok

06:53:43.29 Relation 261 (XQD_1200_2000)
06:53:43.29 process pointer page 0 of 3
06:53:43.30 process pointer page 1 of 3
06:53:43.30 process pointer page 2 of 3
06:53:43.32 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
06:53:43.33 Relation 261 (XQD_1200_2000) is ok

06:53:43.33 Relation 262 (XQD_1000_3300)
06:53:43.33 process pointer page 0 of 7
06:53:43.41 process pointer page 1 of 7
06:53:43.49 process pointer page 2 of 7
06:53:43.55 process pointer page 3 of 7
06:53:43.63 process pointer page 4 of 7
06:53:43.71 process pointer page 5 of 7
06:53:43.78 process pointer page 6 of 7
06:53:43.83 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
06:53:44.08 Index 2 (XQD_1000_3300_DOC)
06:53:44.28 Relation 262 (XQD_1000_3300) is ok

06:53:44.28 Relation 263 (XQD_2000_3300)
06:53:44.28 process pointer page 0 of 12
06:53:44.35 process pointer page 1 of 12
06:53:44.41 process pointer page 2 of 12
06:53:44.47 process pointer page 3 of 12
06:53:44.53 process pointer page 4 of 12
06:53:44.60 process pointer page 5 of 12
06:53:44.61 process pointer page 6 of 12
06:53:44.64 process pointer page 7 of 12
06:53:44.67 process pointer page 8 of 12
06:53:44.69 process pointer page 9 of 12
06:53:44.72 process pointer page 10 of 12
06:53:44.74 process pointer page 11 of 12
06:53:44.78 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
06:53:45.05 Relation 263 (XQD_2000_3300) is ok

06:53:45.05 Relation 264 (XQD_2100_3300)
06:53:45.05 process pointer page 0 of 5
06:53:45.06 process pointer page 1 of 5
06:53:45.08 process pointer page 2 of 5
06:53:45.08 process pointer page 3 of 5
06:53:45.08 process pointer page 4 of 5
06:53:45.08 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
06:53:45.08 Relation 264 (XQD_2100_3300) is ok

06:53:45.08 Relation 265 (XQD_3300_3400)
06:53:45.08 process pointer page 0 of 15
06:53:45.17 process pointer page 1 of 15
06:53:45.25 process pointer page 2 of 15
06:53:45.33 process pointer page 3 of 15
06:53:45.41 process pointer page 4 of 15
06:53:45.49 process pointer page 5 of 15
06:53:45.55 process pointer page 6 of 15
06:53:45.61 process pointer page 7 of 15
06:53:45.67 process pointer page 8 of 15
06:53:45.70 process pointer page 9 of 15
06:53:45.72 process pointer page 10 of 15
06:53:45.75 process pointer page 11 of 15
06:53:45.78 process pointer page 12 of 15
06:53:45.81 process pointer page 13 of 15
06:53:45.89 process pointer page 14 of 15
06:53:45.95 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
06:53:46.27 Relation 265 (XQD_3300_3400) is ok

06:53:46.27 Relation 266 (XQS_1000_1200)
06:53:46.27 process pointer page 0 of 26
06:53:46.30 process pointer page 1 of 26
06:53:46.33 process pointer page 2 of 26
06:53:46.36 process pointer page 3 of 26
06:53:46.39 process pointer page 4 of 26
06:53:46.42 process pointer page 5 of 26
06:53:46.45 process pointer page 6 of 26
06:53:46.51 process pointer page 7 of 26
06:53:46.59 process pointer page 8 of 26
06:53:46.67 process pointer page 9 of 26
06:53:46.75 process pointer page 10 of 26
06:53:46.83 process pointer page 11 of 26
06:53:46.90 process pointer page 12 of 26
06:53:47.00 process pointer page 13 of 26
06:53:47.08 process pointer page 14 of 26
06:53:47.15 process pointer page 15 of 26
06:53:47.23 process pointer page 16 of 26
06:53:47.31 process pointer page 17 of 26
06:53:47.39 process pointer page 18 of 26
06:53:47.47 process pointer page 19 of 26
06:53:47.54 process pointer page 20 of 26
06:53:47.62 process pointer page 21 of 26
06:53:47.70 process pointer page 22 of 26
06:53:47.73 process pointer page 23 of 26
06:53:47.76 process pointer page 24 of 26
06:53:47.79 process pointer page 25 of 26
06:53:47.81 Index 1 (XQS_1000_1200_DOC_ID)
06:53:48.26 Index 2 (XQS_1000_1200_SND_ID)
06:53:48.95 Index 3 (XQS_1000_1200_RCV_ID)
06:53:49.46 Relation 266 (XQS_1000_1200) is ok

06:53:49.46 Relation 267 (XQS_1200_2000)
06:53:49.46 process pointer page 0 of 29
06:53:49.49 process pointer page 1 of 29
06:53:49.56 process pointer page 2 of 29
06:53:49.63 process pointer page 3 of 29
06:53:49.71 process pointer page 4 of 29
06:53:49.81 process pointer page 5 of 29
06:53:49.85 process pointer page 6 of 29
06:53:49.88 process pointer page 7 of 29
06:53:49.92 process pointer page 8 of 29
06:53:49.95 process pointer page 9 of 29
06:53:49.98 process pointer page 10 of 29
06:53:49.99 process pointer page 11 of 29
06:53:50.04 process pointer page 12 of 29
06:53:50.12 process pointer page 13 of 29
06:53:50.20 process pointer page 14 of 29
06:53:50.27 process pointer page 15 of 29
06:53:50.34 process pointer page 16 of 29
06:53:50.41 process pointer page 17 of 29
06:53:50.48 process pointer page 18 of 29
06:53:50.54 process pointer page 19 of 29
06:53:50.62 process pointer page 20 of 29
06:53:50.68 process pointer page 21 of 29
06:53:50.73 process pointer page 22 of 29
06:53:50.76 process pointer page 23 of 29
06:53:50.79 process pointer page 24 of 29
06:53:50.82 process pointer page 25 of 29
06:53:50.85 process pointer page 26 of 29
06:53:50.90 process pointer page 27 of 29
06:53:50.98 process pointer page 28 of 29
06:53:51.05 Index 1 (XQS_1200_2000_DOC_ID)
06:53:51.57 Index 2 (XQS_1200_2000_SND_ID)
06:53:52.08 Index 3 (XQS_1200_2000_RCV_ID)
06:53:52.51 Relation 267 (XQS_1200_2000) is ok

06:53:52.51 Relation 268 (XQS_1000_3300)
06:53:52.51 process pointer page 0 of 15
06:53:52.54 process pointer page 1 of 15
06:53:52.57 process pointer page 2 of 15
06:53:52.60 process pointer page 3 of 15
06:53:52.65 process pointer page 4 of 15
06:53:52.72 process pointer page 5 of 15
06:53:52.80 process pointer page 6 of 15
06:53:52.88 process pointer page 7 of 15
06:53:52.96 process pointer page 8 of 15
06:53:53.02 process pointer page 9 of 15
06:53:53.10 process pointer page 10 of 15
06:53:53.18 process pointer page 11 of 15
06:53:53.24 process pointer page 12 of 15
06:53:53.32 process pointer page 13 of 15
06:53:53.39 process pointer page 14 of 15
06:53:53.43 Index 1 (XQS_1000_3300_DOC_ID)
06:53:53.58 Index 2 (XQS_1000_3300_SND_ID)
06:53:53.71 Index 3 (XQS_1000_3300_RCV_ID)
06:53:53.82 Relation 268 (XQS_1000_3300) is ok

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

06:53:53.82 Relation 270 (XQS_2100_3300)
06:53:53.82 process pointer page 0 of 22
06:53:53.85 process pointer page 1 of 22
06:53:53.88 process pointer page 2 of 22
06:53:53.91 process pointer page 3 of 22
06:53:53.94 process pointer page 4 of 22
06:53:54.00 process pointer page 5 of 22
06:53:54.07 process pointer page 6 of 22
06:53:54.11 process pointer page 7 of 22
06:53:54.14 process pointer page 8 of 22
06:53:54.17 process pointer page 9 of 22
06:53:54.21 process pointer page 10 of 22
06:53:54.24 process pointer page 11 of 22
06:53:54.25 process pointer page 12 of 22
06:53:54.33 process pointer page 13 of 22
06:53:54.39 process pointer page 14 of 22
06:53:54.41 process pointer page 15 of 22
06:53:54.44 process pointer page 16 of 22
06:53:54.47 process pointer page 17 of 22
06:53:54.50 process pointer page 18 of 22
06:53:54.56 process pointer page 19 of 22
06:53:54.66 process pointer page 20 of 22
06:53:54.74 process pointer page 21 of 22
06:53:54.80 Index 1 (XQS_2100_3300_DOC_ID)
06:53:55.20 Index 2 (XQS_2100_3300_SND_ID)
06:53:55.73 Index 3 (XQS_2100_3300_RCV_ID)
06:53:56.30 Relation 270 (XQS_2100_3300) is ok

06:53:56.30 Relation 271 (XQS_3300_3400)
06:53:56.30 process pointer page 0 of 7
06:53:56.37 process pointer page 1 of 7
06:53:56.45 process pointer page 2 of 7
06:53:56.53 process pointer page 3 of 7
06:53:56.62 process pointer page 4 of 7
06:53:56.70 process pointer page 5 of 7
06:53:56.78 process pointer page 6 of 7
06:53:56.83 Index 1 (XQS_3300_3400_DOC_ID)
06:53:56.89 Index 2 (XQS_3300_3400_SND_ID)
06:53:56.97 Relation 271 (XQS_3300_3400) is ok

06:53:56.97 Validation finished
Done for 23230 ms, from 6:53:33.75 to 6:53:56.98.

Differences between old and current firebird.log

6:53:57.76. 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-03 06:53 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 Sun Jun 03 06:53:33 2018
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sun Jun 03 06:53: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-03 6:54:01.62 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html
Subscribe