Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 4. 2016-01-13 20:17:13.85.
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-V2.5.6.26963 Firebird 2.5
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperClassic 2.5.6 D:\OLTP-EMUL\OLTP25-SMALL.FDB OFF 0 384 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp25_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB25.TMPINSTANCE\bin\
dbnm D:\OLTP-EMUL\oltp25-small.fdb
host localhost
port 3255
usr SYSDBA
pwd masterke
tmpdir e:\temp\logs.oltp25
working_mode small_03
warm_time 10
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 0
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
upload_report 1

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2016-01-13 20:17:06.8940 -1 <null> 127.0.0.1 161064 4534 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
COMMON ENABLE_MON_QUERY 0
COMMON HALT_TEST_ON_ERRORS ,CK,
COMMON LOG_PK_VIOLATION 0
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: 4554.51 969 819811 2016-01-13 17:17 2016-01-13 20:17
customer order: creation 132.00 67 23760 2016-01-13 17:17 2016-01-13 20:17
customer order: refuse 10.36 51 1855 2016-01-13 17:17 2016-01-13 20:17
order to supplier: creation 33.47 183 5991 2016-01-13 17:17 2016-01-13 20:17
order to supplier: removal 1.31 9594 235 2016-01-13 17:17 2016-01-13 20:17
invoice (draft): creation 34.04 248 6093 2016-01-13 17:17 2016-01-13 20:17
invoice (draft): removal 16.10 100 2882 2016-01-13 17:17 2016-01-13 20:17
invoice accept: apply 23.20 4884 4176 2016-01-13 17:17 2016-01-13 20:17
invoice accept: cancel 7.57 493 1363 2016-01-13 17:17 2016-01-13 20:17
customer reserve: creation 3609.73 24 649751 2016-01-13 17:17 2016-01-13 20:17
customer reserve: removal 485.23 20 87342 2016-01-13 17:17 2016-01-13 20:17
realization accept: apply 62.51 76 11252 2016-01-13 17:17 2016-01-13 20:17
realization accept: cancel 30.11 39 5420 2016-01-13 17:17 2016-01-13 20:17
payment from customer: creation 43.84 108 7892 2016-01-13 17:17 2016-01-13 20:17
payment from customer: removal 4.15 33 743 2016-01-13 17:17 2016-01-13 20:17
payment to supplier: creation 36.96 155 6652 2016-01-13 17:17 2016-01-13 20:17
payment to supplier: removal 2.59 36 464 2016-01-13 17:17 2016-01-13 20:17
service: total inventory turnovers 13.37 90 2406 2016-01-13 17:17 2016-01-13 20:17
service: total monetary turnovers 8.51 3 1523 2016-01-13 17:17 2016-01-13 20:17
service: refresh index statistics 0.07 2203 11 2016-01-13 17:17 2016-01-13 20:17
Done for 65590 ms, from 20:18:28.50 to 20:19:34.09.

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 3188 60557 57386 3171 5.24 17:17:07 17:35:07
interval # 2, overall 2 3088 67374 55580 11794 17.51 17:35:08 17:53:08
interval # 3, overall 3 3213 66948 57827 9121 13.62 17:53:09 18:11:09
interval # 4, overall 4 4016 78073 72284 5789 7.41 18:11:10 18:29:10
interval # 5, overall 5 4367 85440 78604 6836 8.00 18:29:11 18:47:11
interval # 6, overall 6 5049 99995 90877 9118 9.12 18:47:12 19:05:12
interval # 7, overall 7 5571 104605 100269 4336 4.15 19:05:13 19:23:13
interval # 8, overall 8 5989 116579 107805 8774 7.53 19:23:14 19:41:14
interval # 9, overall 9 5596 101766 100736 1030 1.01 19:41:15 19:59:15
interval # 10, overall 10 5469 105123 98443 6680 6.35 19:59:16 20:17:16
Done for 124080 ms, from 20:21:35.87 to 20:23:39.95.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
WARM_TIME 1 2354.39 0.7267 1.2835 580 4
WARM_TIME 2 1842.36 0.8204 1.1710 720 4
WARM_TIME 3 1567.24 0.9179 1.1514 427 4
WARM_TIME 4 1483.94 0.9122 1.1482 620 4
WARM_TIME 5 1516.97 0.8987 1.0898 680 4
WARM_TIME 6 1491.57 0.9237 1.1188 590 4
WARM_TIME 7 1479.65 0.9713 1.0395 184 4
WARM_TIME 8 1377.81 0.9769 1.0369 181 3
WARM_TIME 9 1409.05 0.9094 1.0845 602 4
WARM_TIME 10 1509.19 0.9114 1.0550 337 4
TEST_TIME 11 1498.75 0.9658 1.0483 337 4
TEST_TIME 12 1535.55 0.9379 1.0541 309 4
TEST_TIME 13 1558.32 0.9675 1.0231 179 4
TEST_TIME 14 1594.02 0.9288 1.0879 565 4
TEST_TIME 15 1690.08 0.9577 1.0569 198 4
TEST_TIME 16 1772.40 0.9449 1.0862 379 4
TEST_TIME 17 1929.87 0.9389 1.0627 532 4
TEST_TIME 18 2017.54 0.9629 1.0275 252 4
TEST_TIME 19 2038.46 0.9669 1.0377 445 4
TEST_TIME 20 2117.31 0.9491 1.0540 562 4
TEST_TIME 21 2219.75 0.9587 1.0277 425 4
TEST_TIME 22 2251.37 0.9673 1.0314 292 4
TEST_TIME 23 2324.99 0.9553 1.0327 429 4
TEST_TIME 24 2360.83 0.9747 1.0315 476 4
TEST_TIME 25 2442.12 0.9573 1.0431 682 4
TEST_TIME 26 2544.16 0.9627 1.0263 515 4
TEST_TIME 27 2581.59 0.9739 1.0268 689 4
TEST_TIME 28 2611.38 0.9788 1.0213 506 4
TEST_TIME 29 2613.75 0.9852 1.0197 411 4
TEST_TIME 30 2610.12 0.9871 1.0136 391 4
TEST_TIME 31 2640.18 0.9697 1.0308 567 4
TEST_TIME 32 2692.53 0.9792 1.0178 573 4
TEST_TIME 33 2709.35 0.9808 1.0161 654 4
TEST_TIME 34 2704.00 0.9882 1.0179 466 4
TEST_TIME 35 2712.95 0.9863 1.0116 465 4
TEST_TIME 36 2708.89 0.9850 1.0180 549 4
TEST_TIME 37 2723.97 0.9850 1.0119 579 3
TEST_TIME 38 2716.01 0.9882 1.0121 563 4
TEST_TIME 39 2716.08 0.9862 1.0146 445 4
TEST_TIME 40 2730.67 0.9840 1.0146 556 4
TEST_TIME 41 2754.11 0.9814 1.0127 775 4
TEST_TIME 42 2762.85 0.9855 1.0133 820 4
TEST_TIME 43 2771.07 0.9874 1.0112 699 4
TEST_TIME 44 2779.04 0.9854 1.0139 742 4
TEST_TIME 45 2788.14 0.9881 1.0152 705 4
TEST_TIME 46 2780.18 0.9959 1.0059 299 4
TEST_TIME 47 2761.83 0.9910 1.0129 555 4
TEST_TIME 48 2778.74 0.9857 1.0114 721 4
TEST_TIME 49 2785.16 0.9885 1.0124 618 4
TEST_TIME 50 2783.88 0.9926 1.0090 578 4
TEST_TIME 51 2777.02 0.9917 1.0102 574 4
TEST_TIME 52 2776.66 0.9909 1.0090 565 4
TEST_TIME 53 2780.07 0.9888 1.0076 525 4
TEST_TIME 54 2774.54 0.9909 1.0068 407 4
TEST_TIME 55 2784.45 0.9850 1.0095 706 4
TEST_TIME 56 2802.61 0.9856 1.0148 993 4
TEST_TIME 57 2831.18 0.9869 1.0116 636 4
TEST_TIME 58 2846.03 0.9890 1.0136 836 4
TEST_TIME 59 2863.12 0.9905 1.0102 744 4
TEST_TIME 60 2874.37 0.9895 1.0097 702 4
TEST_TIME 61 2894.79 0.9862 1.0125 542 4
TEST_TIME 62 2907.10 0.9919 1.0079 560 4
TEST_TIME 63 2913.52 0.9897 1.0084 655 4
TEST_TIME 64 2915.62 0.9921 1.0085 599 4
TEST_TIME 65 2918.76 0.9926 1.0093 410 4
TEST_TIME 66 2919.54 0.9938 1.0078 471 4
TEST_TIME 67 2917.51 0.9934 1.0071 562 4
TEST_TIME 68 2923.35 0.9903 1.0077 499 4
TEST_TIME 69 2935.78 0.9889 1.0111 383 4
TEST_TIME 70 2973.61 0.9840 1.0130 849 4
TEST_TIME 71 2991.16 0.9929 1.0082 453 4
TEST_TIME 72 2997.70 0.9929 1.0057 285 3
TEST_TIME 73 3005.23 0.9894 1.0128 659 4
TEST_TIME 74 3029.68 0.9910 1.0103 569 4
TEST_TIME 75 3047.15 0.9911 1.0083 464 4
TEST_TIME 76 3063.02 0.9899 1.0077 521 4
TEST_TIME 77 3072.50 0.9916 1.0101 501 4
TEST_TIME 78 3097.40 0.9891 1.0086 414 4
TEST_TIME 79 3109.06 0.9921 1.0078 403 4
TEST_TIME 80 3128.88 0.9889 1.0081 542 4
TEST_TIME 81 3138.90 0.9925 1.0103 443 4
TEST_TIME 82 3155.62 0.9927 1.0097 453 4
TEST_TIME 83 3172.63 0.9930 1.0087 530 4
TEST_TIME 84 3184.50 0.9929 1.0071 467 4
TEST_TIME 85 3207.51 0.9881 1.0073 655 4
TEST_TIME 86 3232.22 0.9890 1.0050 698 4
TEST_TIME 87 3249.61 0.9893 1.0093 547 4
TEST_TIME 88 3267.16 0.9925 1.0097 621 4
TEST_TIME 89 3291.94 0.9908 1.0081 485 4
TEST_TIME 90 3315.82 0.9897 1.0084 633 4
TEST_TIME 91 3332.85 0.9922 1.0084 619 4
TEST_TIME 92 3351.06 0.9926 1.0067 485 4
TEST_TIME 93 3354.34 0.9949 1.0047 536 4
TEST_TIME 94 3362.28 0.9917 1.0060 521 3
TEST_TIME 95 3370.04 0.9931 1.0061 458 4
TEST_TIME 96 3376.07 0.9938 1.0030 282 4
TEST_TIME 97 3359.95 0.9984 1.0008 125 2
TEST_TIME 98 3356.17 0.9918 1.0061 491 4
TEST_TIME 99 3360.13 0.9947 1.0079 529 4
TEST_TIME 100 3381.67 0.9915 1.0092 521 4
TEST_TIME 101 3407.00 0.9918 1.0103 653 4
TEST_TIME 102 3436.33 0.9929 1.0083 339 4
TEST_TIME 103 3440.65 0.9973 1.0060 306 4
TEST_TIME 104 3457.93 0.9914 1.0075 534 4
TEST_TIME 105 3473.96 0.9933 1.0049 330 4
TEST_TIME 106 3487.10 0.9916 1.0067 500 4
TEST_TIME 107 3498.68 0.9940 1.0046 448 4
TEST_TIME 108 3507.83 0.9934 1.0046 447 4
TEST_TIME 109 3506.75 0.9957 1.0078 535 4
TEST_TIME 110 3527.87 0.9938 1.0053 462 4
TEST_TIME 111 3547.12 0.9921 1.0050 388 4
TEST_TIME 112 3553.90 0.9942 1.0066 386 4
TEST_TIME 113 3568.17 0.9942 1.0064 355 4
TEST_TIME 114 3575.10 0.9957 1.0059 395 4
TEST_TIME 115 3589.49 0.9935 1.0068 361 4
TEST_TIME 116 3601.51 0.9948 1.0066 698 4
TEST_TIME 117 3616.09 0.9942 1.0063 430 4
TEST_TIME 118 3633.60 0.9930 1.0049 496 4
TEST_TIME 119 3650.84 0.9918 1.0079 461 4
TEST_TIME 120 3664.96 0.9957 1.0073 412 4
TEST_TIME 121 3667.84 0.9982 1.0016 162 4
TEST_TIME 122 3662.42 0.9955 1.0031 326 4
TEST_TIME 123 3666.18 0.9939 1.0071 405 4
TEST_TIME 124 3682.94 0.9946 1.0060 231 4
TEST_TIME 125 3700.28 0.9932 1.0047 358 4
TEST_TIME 126 3705.86 0.9952 1.0039 440 4
TEST_TIME 127 3719.18 0.9925 1.0066 196 4
TEST_TIME 128 3730.25 0.9958 1.0048 240 4
TEST_TIME 129 3741.21 0.9953 1.0029 218 4
TEST_TIME 130 3751.19 0.9935 1.0068 476 4
TEST_TIME 131 3780.55 0.9917 1.0066 519 4
TEST_TIME 132 3806.75 0.9921 1.0066 501 4
TEST_TIME 133 3828.28 0.9934 1.0053 262 4
TEST_TIME 134 3849.82 0.9922 1.0058 492 4
TEST_TIME 135 3865.95 0.9942 1.0071 606 4
TEST_TIME 136 3899.27 0.9911 1.0083 530 6
TEST_TIME 137 3922.27 0.9951 1.0055 483 4
TEST_TIME 138 3934.58 0.9951 1.0068 297 4
TEST_TIME 139 3952.11 0.9951 1.0046 373 4
TEST_TIME 140 3968.16 0.9934 1.0040 418 4
TEST_TIME 141 3970.12 0.9964 1.0038 249 4
TEST_TIME 142 3965.70 0.9978 1.0036 186 4
TEST_TIME 143 3975.78 0.9941 1.0037 350 4
TEST_TIME 144 3984.72 0.9945 1.0045 331 4
TEST_TIME 145 3997.28 0.9947 1.0058 517 4
TEST_TIME 146 4014.94 0.9948 1.0064 288 4
TEST_TIME 147 4040.42 0.9941 1.0032 407 4
TEST_TIME 148 4049.66 0.9942 1.0056 414 4
TEST_TIME 149 4059.46 0.9964 1.0071 199 4
TEST_TIME 150 4087.22 0.9951 1.0051 232 4
TEST_TIME 151 4098.95 0.9956 1.0038 377 4
TEST_TIME 152 4117.63 0.9927 1.0047 322 4
TEST_TIME 153 4124.87 0.9968 1.0032 388 4
TEST_TIME 154 4131.83 0.9957 1.0034 280 4
TEST_TIME 155 4142.32 0.9944 1.0042 269 4
TEST_TIME 156 4154.56 0.9948 1.0038 308 4
TEST_TIME 157 4156.23 0.9972 1.0020 198 4
TEST_TIME 158 4149.57 0.9973 1.0031 182 4
TEST_TIME 159 4155.99 0.9952 1.0047 228 4
TEST_TIME 160 4166.87 0.9959 1.0046 348 4
TEST_TIME 161 4174.53 0.9965 1.0056 235 4
TEST_TIME 162 4198.51 0.9941 1.0049 514 4
TEST_TIME 163 4214.78 0.9957 1.0041 439 4
TEST_TIME 164 4226.22 0.9953 1.0029 295 4
TEST_TIME 165 4228.73 0.9962 1.0039 247 4
TEST_TIME 166 4239.87 0.9952 1.0022 234 4
TEST_TIME 167 4252.55 0.9941 1.0040 299 4
TEST_TIME 168 4258.07 0.9967 1.0041 256 4
TEST_TIME 169 4276.43 0.9944 1.0014 276 4
TEST_TIME 170 4275.18 0.9959 1.0034 205 4
TEST_TIME 171 4274.87 0.9976 1.0046 171 4
TEST_TIME 172 4284.12 0.9968 1.0039 366 4
TEST_TIME 173 4287.69 0.9973 1.0020 379 4
TEST_TIME 174 4283.79 0.9972 1.0024 257 3
TEST_TIME 175 4294.63 0.9951 1.0031 444 4
TEST_TIME 176 4304.54 0.9952 1.0042 526 4
TEST_TIME 177 4316.86 0.9956 1.0042 342 4
TEST_TIME 178 4330.77 0.9954 1.0041 435 4
TEST_TIME 179 4346.14 0.9950 1.0049 375 4
TEST_TIME 180 4353.52 0.9976 1.0030 160 4
TEST_TIME 181 4355.79 0.9974 1.0035 153 4
TEST_TIME 182 4361.48 0.9969 1.0018 393 4
TEST_TIME 183 4363.53 0.9959 1.0045 240 4
TEST_TIME 184 4373.93 0.9967 1.0033 222 4
TEST_TIME 185 4384.41 0.9955 1.0028 230 4
TEST_TIME 186 4389.12 0.9963 1.0036 193 4
TEST_TIME 187 4399.85 0.9958 1.0021 326 4
TEST_TIME 188 4396.14 0.9976 1.0030 214 4
TEST_TIME 189 4401.14 0.9966 1.0027 278 4
TEST_TIME 190 4391.80 0.9999 1.0000 19 4
Done for 10020 ms, from 20:23:40.66 to 20:23:50.68.

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 33861 46854 47524 77760 57108 45332 75109 65133 36380 40001 45530 45199 57258 58806 169351 57987 250983 236604 <null> 17:17:07 17:35:07
fetches per second 2 35255 49467 43391 144278 61187 65970 69639 83124 34031 35930 38900 31502 46709 44147 180827 31132 361235 161852 <null> 17:35:08 17:53:08
fetches per second 3 38018 56194 53293 83459 70899 44111 74284 66166 25618 42681 42184 35730 54326 41146 223521 54475 377121 229071 4059 17:53:09 18:11:09
fetches per second 4 36188 53055 61445 110487 71907 65933 94644 62344 28187 52681 41418 31551 60641 38940 215749 32451 362277 194991 <null> 18:11:10 18:29:10
fetches per second 5 39803 43771 56093 118513 73498 44750 111510 59214 28406 41355 34906 25829 57349 38818 188330 36886 367392 264696 <null> 18:29:11 18:47:11
fetches per second 6 42220 48421 63477 88163 82545 91128 146560 68696 30990 50425 47122 34231 52718 49425 188890 44282 314420 252623 <null> 18:47:12 19:05:12
fetches per second 7 39081 55067 57914 105477 91230 82593 151183 62852 28104 45874 41980 28121 51767 50210 135119 52571 432382 286029 <null> 19:05:13 19:23:13
fetches per second 8 44862 57461 73118 110829 117101 86839 162440 95454 26953 46468 43714 29571 53641 43906 130463 45789 368259 302618 <null> 19:23:14 19:41:14
fetches per second 9 35732 38467 56041 90892 93332 54961 124524 61375 33427 23849 41889 17875 53746 26009 44019 27093 370541 284594 <null> 19:41:15 19:59:15
fetches per second 10 38011 45235 56255 120820 104894 51978 164784 72497 24965 25702 40197 21062 54327 31029 34000 32960 449551 226852 <null> 19:59:16 20:17:16
marks per second 1 6206 4849 8660 10582 10986 7733 5629 8314 3973 5562 7288 6133 4319 7198 2230 6887 28361 32365 <null> 17:17:07 17:35:07
marks per second 2 6396 5177 8014 21997 11646 11595 5885 9996 3831 4168 6254 3884 3465 4782 1974 3887 35439 16545 <null> 17:35:08 17:53:08
marks per second 3 6910 6135 9826 13322 13359 7564 5606 8053 2718 5399 6237 4821 3274 4490 1738 5748 34697 23493 406 17:53:09 18:11:09
marks per second 4 6585 5696 11288 15327 13647 12451 5571 7982 2955 6562 5413 3691 3896 4727 1911 3317 30934 16428 <null> 18:11:10 18:29:10
marks per second 5 7267 4624 10259 16166 14062 7382 5380 6497 2718 4483 5087 2993 3816 4053 2369 3875 37913 28695 <null> 18:29:11 18:47:11
marks per second 6 7745 5387 11569 10240 15760 14629 5169 7386 3084 5202 6179 3868 3579 5258 3142 4424 28954 23898 <null> 18:47:12 19:05:12
marks per second 7 7169 6121 10843 13138 18074 13519 4977 6887 3174 5938 5089 3358 3208 6465 4612 8318 37197 28512 <null> 19:05:13 19:23:13
marks per second 8 8143 6381 13464 14367 23109 14527 5439 10579 2796 6230 5164 3237 3344 5666 4635 5558 42787 36935 <null> 19:23:14 19:41:14
marks per second 9 6667 4228 10496 13546 16890 9882 4600 6636 4206 2559 3967 2090 3015 2870 4841 3721 25975 41707 <null> 19:41:15 19:59:15
marks per second 10 6877 5283 10353 19267 18073 9266 4491 7883 2712 2909 4126 2420 2734 3013 4381 3770 27784 26633 <null> 19:59:16 20:17:16
reads/fetches*100 1 7 5 4 1 3 4 2 2 6 6 8 6 7 5 3 4 1 3 <null> 17:17:07 17:35:07
reads/fetches*100 2 7 6 4 1 3 3 2 2 6 6 8 7 7 5 3 4 1 3 <null> 17:35:08 17:53:08
reads/fetches*100 3 7 6 4 1 3 4 2 2 6 7 9 8 8 6 3 5 1 3 2 17:53:09 18:11:09
reads/fetches*100 4 8 6 4 2 3 4 2 2 6 7 9 8 8 6 3 6 1 3 <null> 18:11:10 18:29:10
reads/fetches*100 5 8 7 4 1 4 5 2 2 6 7 10 8 8 7 3 7 1 3 <null> 18:29:11 18:47:11
reads/fetches*100 6 7 7 4 1 3 4 2 2 6 7 10 9 9 6 4 6 1 3 <null> 18:47:12 19:05:12
reads/fetches*100 7 7 7 4 2 3 3 1 2 6 7 10 8 9 6 6 5 1 3 <null> 19:05:13 19:23:13
reads/fetches*100 8 8 7 4 1 3 4 2 2 7 8 10 9 9 6 7 6 1 3 <null> 19:23:14 19:41:14
reads/fetches*100 9 8 7 4 2 4 4 2 2 7 8 12 8 9 7 6 5 1 3 <null> 19:41:15 19:59:15
reads/fetches*100 10 8 7 4 2 4 5 2 2 7 9 11 9 9 6 5 6 1 2 <null> 19:59:16 20:17:16
writes/marks*100 1 10 11 7 2 7 2 4 2 13 5 6 9 0 0 5 0 8 0 <null> 17:17:07 17:35:07
writes/marks*100 2 10 12 7 2 7 0 4 3 14 5 7 10 0 0 5 0 9 0 <null> 17:35:08 17:53:08
writes/marks*100 3 10 12 7 1 7 2 3 3 13 5 7 8 3 0 5 0 9 0 0 17:53:09 18:11:09
writes/marks*100 4 10 12 7 2 7 2 3 3 13 5 7 10 3 0 5 0 9 0 <null> 18:11:10 18:29:10
writes/marks*100 5 11 13 7 2 7 1 4 2 14 6 7 12 4 0 5 0 10 0 <null> 18:29:11 18:47:11
writes/marks*100 6 11 13 7 3 7 2 3 2 12 6 8 11 3 0 5 0 8 0 <null> 18:47:12 19:05:12
writes/marks*100 7 11 13 7 3 7 1 3 2 12 6 8 9 5 0 4 0 10 0 <null> 19:05:13 19:23:13
writes/marks*100 8 11 13 8 2 8 3 4 2 12 5 8 13 6 0 5 0 8 0 <null> 19:23:14 19:41:14
writes/marks*100 9 11 13 8 2 8 3 3 2 10 4 9 11 7 0 0 1 8 0 <null> 19:41:15 19:59:15
writes/marks*100 10 11 13 9 3 8 4 3 2 12 6 9 14 6 0 0 0 9 0 <null> 19:59:16 20:17:16
Done for 10400 ms, from 20:23:53.02 to 20:24:03.42.

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 733701 669421 64280 8.76 0 2028 5 64280 2016-01-13 17:17 2016-01-13 20:17
doc_list_biud 733820 669419 64401 8.77 0 2434 3 64401 2016-01-13 17:17 2016-01-13 20:17
sp_add_invoice_to_stock 5934 4176 1758 29.62 31 81036 4884 1758 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_adding_invoice 1862 1363 499 26.79 0 7426 493 499 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_client_order 1882 1855 27 1.43 0 936 51 27 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_customer_reserve 148797 87342 61455 41.30 0 1014 20 61455 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_pay_from_customer 745 743 2 0.26 0 421 33 2 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_pay_to_supplier 464 464 0 0.00 0 577 36 0 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_supplier_invoice 3451 2882 569 16.48 0 860 100 569 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_supplier_order 466 235 231 49.57 15 54724 9594 231 2016-01-13 17:17 2016-01-13 20:17
sp_cancel_write_off 7458 5420 2038 27.32 0 671 39 2038 2016-01-13 17:17 2016-01-13 20:17
sp_client_order 23760 23760 0 0.00 0 1950 67 0 2016-01-13 17:17 2016-01-13 20:17
sp_customer_reserve 649751 649751 0 0.00 0 2496 24 0 2016-01-13 17:17 2016-01-13 20:17
sp_fill_shopping_cart 35844 35844 0 0.00 0 1809 15 0 2016-01-13 17:17 2016-01-13 20:17
sp_fill_shopping_cart_clo_res 649751 649751 0 0.00 0 1404 2 0 2016-01-13 17:17 2016-01-13 20:17
sp_get_clo_for_invoice 4176 4176 0 0.00 0 1014 85 0 2016-01-13 17:17 2016-01-13 20:17
sp_kill_cost_storno 10377 7991 2386 22.99 0 484 6 2386 2016-01-13 17:17 2016-01-13 20:17
sp_kill_qstorno_ret_qs2qd 308606 183222 125384 40.62 0 874 8 125384 2016-01-13 17:17 2016-01-13 20:17
sp_kill_qty_storno 178903 114527 64376 35.98 0 2434 19 64376 2016-01-13 17:17 2016-01-13 20:17
sp_lock_selected_doc 23611 21314 2297 9.72 0 468 1 2297 2016-01-13 17:17 2016-01-13 20:17
sp_make_cost_storno 29973 29973 0 0.00 0 655 45 0 2016-01-13 17:17 2016-01-13 20:17
sp_multiply_rows_for_pdistr 29972 29972 0 0.00 0 1950 9 0 2016-01-13 17:17 2016-01-13 20:17
sp_multiply_rows_for_qdistr 23760 23760 0 0.00 0 1732 21 0 2016-01-13 17:17 2016-01-13 20:17
sp_pay_from_customer 7892 7892 0 0.00 15 1373 108 0 2016-01-13 17:17 2016-01-13 20:17
sp_pay_to_supplier 6652 6652 0 0.00 0 2278 155 0 2016-01-13 17:17 2016-01-13 20:17
sp_payment_common 14544 14544 0 0.00 0 2028 31 0 2016-01-13 17:17 2016-01-13 20:17
sp_qd_handle_on_cancel_clo 1882 1855 27 1.43 0 593 18 27 2016-01-13 17:17 2016-01-13 20:17
sp_qd_handle_on_invoice_upd_sts 5975 5540 435 7.28 0 2434 63 435 2016-01-13 17:17 2016-01-13 20:17
sp_qd_handle_on_reserve_upd_sts 11252 11252 0 0.00 0 687 13 0 2016-01-13 17:17 2016-01-13 20:17
sp_reserve_write_off 11322 11252 70 0.61 0 2044 76 70 2016-01-13 17:17 2016-01-13 20:17
sp_supplier_invoice 6093 6093 0 0.00 0 2621 248 0 2016-01-13 17:17 2016-01-13 20:17
sp_supplier_order 5991 5991 0 0.00 0 1155 183 0 2016-01-13 17:17 2016-01-13 20:17
srv_find_qd_qs_mism 448353 384099 64254 14.33 0 1076 3 64254 2016-01-13 17:17 2016-01-13 20:17
srv_make_invnt_saldo 2406 2406 0 0.00 0 1060 90 0 2016-01-13 17:17 2016-01-13 20:17
srv_make_money_saldo 1523 1523 0 0.00 0 390 3 0 2016-01-13 17:17 2016-01-13 20:17
srv_recalc_idx_stat 11 11 0 0.00 1202 3711 2203 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_add_invoice_to_stock 1758 1758 0 0.00 0 187 5 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_cancel_adding_invoice 149 149 0 0.00 0 124 16 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_cancel_client_order 27 27 0 0.00 0 31 3 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_cancel_customer_reserve 5 5 0 0.00 0 16 9 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_cancel_pay_from_customer 2 2 0 0.00 0 5 2 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_cancel_supplier_invoice 127 127 0 0.00 0 60 5 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_cancel_supplier_order 7280 7280 0 0.00 0 484 35 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_cancel_write_off 2 2 0 0.00 3 15 9 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-abend:sp_reserve_write_off 70 70 0 0.00 0 78 9 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_add_invoice_to_stock 4177 4177 0 0.00 0 2827 203 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_adding_invoice 360 360 0 0.00 0 1092 111 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_client_order 1855 1855 0 0.00 0 266 13 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_customer_reserve 759 759 0 0.00 0 202 13 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_pay_from_customer 743 743 0 0.00 0 889 8 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_pay_to_supplier 464 464 0 0.00 0 218 8 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_supplier_invoice 346 346 0 0.00 0 250 12 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_supplier_order 236 236 0 0.00 0 3447 481 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_cancel_write_off 1125 1125 0 0.00 0 156 9 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_client_order 23760 23760 0 0.00 0 687 15 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_customer_reserve 1093 1093 0 0.00 0 265 9 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_pay_from_customer 7893 7893 0 0.00 0 733 9 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_pay_to_supplier 6652 6652 0 0.00 0 312 7 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_reserve_write_off 11252 11252 0 0.00 0 499 10 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_supplier_invoice 6093 6093 0 0.00 0 920 15 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:sp_supplier_order 5991 5991 0 0.00 0 406 15 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:srv_make_invnt_saldo 2406 2406 0 0.00 0 218 9 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:srv_make_money_saldo 1523 1523 0 0.00 0 156 4 0 2016-01-13 17:17 2016-01-13 20:17
t$perf-norm:srv_recalc_idx_stat 11 11 0 0.00 0 94 22 0 2016-01-13 17:17 2016-01-13 20:17
v_add_invoice_to_stock 11868 8352 3516 29.62 0 265 6 3516 2016-01-13 17:17 2016-01-13 20:17
v_all_customers 35772 35772 0 0.00 0 16 0 0 2016-01-13 17:17 2016-01-13 20:17
v_all_suppliers 25154 25154 0 0.00 0 47 0 0 2016-01-13 17:17 2016-01-13 20:17
v_all_wares 47520 47520 0 0.00 0 32 0 0 2016-01-13 17:17 2016-01-13 20:17
v_cancel_adding_invoice 868 718 150 17.28 0 250 16 150 2016-01-13 17:17 2016-01-13 20:17
v_cancel_client_order 3764 3710 54 1.43 0 249 2 54 2016-01-13 17:17 2016-01-13 20:17
v_cancel_customer_prepayment 1490 1486 4 0.26 0 94 2 4 2016-01-13 17:17 2016-01-13 20:17
v_cancel_customer_reserve 1528 1518 10 0.65 0 374 2 10 2016-01-13 17:17 2016-01-13 20:17
v_cancel_payment_to_supplier 928 928 0 0.00 0 171 2 0 2016-01-13 17:17 2016-01-13 20:17
v_cancel_supplier_invoice 946 692 254 26.84 0 125 6 254 2016-01-13 17:17 2016-01-13 20:17
v_cancel_supplier_order 932 470 462 49.57 0 78 2 462 2016-01-13 17:17 2016-01-13 20:17
v_cancel_write_off 2254 2250 4 0.17 0 344 12 4 2016-01-13 17:17 2016-01-13 20:17
v_max_id_clo_ord 5991 5991 0 0.00 0 109 1 0 2016-01-13 17:17 2016-01-13 20:17
v_max_id_clo_res 1093 1093 0 0.00 0 749 6 0 2016-01-13 17:17 2016-01-13 20:17
v_max_id_ord_sup 6093 6093 0 0.00 0 110 1 0 2016-01-13 17:17 2016-01-13 20:17
v_max_non_paid_invoice 6159 6159 0 0.00 0 109 3 0 2016-01-13 17:17 2016-01-13 20:17
v_max_non_paid_realizn 7892 7892 0 0.00 0 96 10 0 2016-01-13 17:17 2016-01-13 20:17
v_min_id_clo_ord 5991 5991 0 0.00 0 94 2 0 2016-01-13 17:17 2016-01-13 20:17
v_min_id_clo_res 1093 1093 0 0.00 0 125 2 0 2016-01-13 17:17 2016-01-13 20:17
v_min_id_ord_sup 6093 6093 0 0.00 0 171 2 0 2016-01-13 17:17 2016-01-13 20:17
v_min_non_paid_invoice 6652 6652 0 0.00 0 2028 15 0 2016-01-13 17:17 2016-01-13 20:17
v_min_non_paid_realizn 7892 7892 0 0.00 0 280 14 0 2016-01-13 17:17 2016-01-13 20:17
v_our_firm 11748 11748 0 0.00 0 16 0 0 2016-01-13 17:17 2016-01-13 20:17
v_reserve_write_off 22644 22504 140 0.61 0 531 2 140 2016-01-13 17:17 2016-01-13 20:17
x_lock_depdocs_on_canc_invoice 6305 3891 2414 38.28 0 374 5 2414 2016-01-13 17:17 2016-01-13 20:17
x_lock_depdocs_on_canc_sup_ord 466 235 231 49.57 0 78 8 231 2016-01-13 17:17 2016-01-13 20:17
x_make_qstorno_1000_1200 5991 5991 0 0.00 0 1108 133 0 2016-01-13 17:17 2016-01-13 20:17
x_make_qstorno_1200_2000 6093 6093 0 0.00 0 2592 203 0 2016-01-13 17:17 2016-01-13 20:17
x_make_qstorno_2100_3300 649751 649751 0 0.00 0 2496 18 0 2016-01-13 17:17 2016-01-13 20:17
Done for 194490 ms, from 20:27:12.24 to 20:30:26.73.

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 9 sp_kill_cost_storno 335544336 2016-01-13 17:24 2016-01-13 19:37
deadlock 100 sp_lock_selected_doc 335544336 2016-01-13 17:19 2016-01-13 20:14
deadlock 64 sp_qd_handle_on_invoice_upd_sts 335544336 2016-01-13 17:17 2016-01-13 20:11
deadlock 1 x_lock_depdocs_on_canc_invoice 335544336 2016-01-13 19:16 2016-01-13 19:16
lock_conflict 2 sp_kill_cost_storno 335544345 2016-01-13 17:27 2016-01-13 18:29
lock_conflict 1863 sp_lock_selected_doc 335544345 2016-01-13 17:17 2016-01-13 20:16
lock_conflict 27 sp_qd_handle_on_cancel_clo 335544345 2016-01-13 17:33 2016-01-13 19:36
lock_conflict 25 sp_qd_handle_on_invoice_upd_sts 335544345 2016-01-13 17:20 2016-01-13 19:47
lock_conflict 172 x_lock_depdocs_on_canc_invoice 335544345 2016-01-13 17:19 2016-01-13 20:11
lock_conflict 32 x_lock_depdocs_on_canc_sup_ord 335544345 2016-01-13 17:25 2016-01-13 20:10
Done for 6730 ms, from 20:30:32.24 to 20:30:38.97.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 161258
MON$OLDEST_ACTIVE 161259
MON$OLDEST_SNAPSHOT 161259
MON$NEXT_TRANSACTION 161259
MON$PAGE_BUFFERS 384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 0
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 462265
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26963 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26963 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26963 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2

Database statistics, full


Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 165846
Page size 8192
ODS version 11.2
Oldest transaction 161260
Oldest active 161261
Oldest snapshot 161261
Next transaction 161262
Bumped transaction 1
Sequence number 0
Next attachment ID 4574
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 34.53, total records: 1142567
Average version length: 46.59, total versions: 294880, max versions: 1
Data pages: 12131, data page slots: 12131, average fill: 78%
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 10
60 - 79% = 8020
80 - 99% = 4097

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 4016, nodes: 1142567
Average data length: 13.52, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 459
20 - 39% = 0
40 - 59% = 1582
60 - 79% = 2
80 - 99% = 1973

Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 3294, nodes: 1142567
Average data length: 5.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 3291
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 1252, nodes: 1142567
Average data length: 1.69, total dup: 825456, max dup: 49
Fill distribution:
0 - 19% = 76
20 - 39% = 1
40 - 59% = 396
60 - 79% = 0
80 - 99% = 779

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 58.82, total records: 258895
Average version length: 36.32, total versions: 20500, max versions: 3
Data pages: 3242, data page slots: 3242, average fill: 78%
Fill distribution:
0 - 19% = 2
20 - 39% = 5
40 - 59% = 2
60 - 79% = 2782
80 - 99% = 451

Index DOC_LIST_ID_DESC (1)
Depth: 3, leaf buckets: 930, nodes: 258895
Average data length: 6.08, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 427
40 - 59% = 490
60 - 79% = 13
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 274, nodes: 258895
Average data length: 0.01, total dup: 258845, max dup: 29172
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 231
60 - 79% = 23
80 - 99% = 20

Index PK_DOC_LIST (0)
Depth: 3, leaf buckets: 555, nodes: 258895
Average data length: 6.07, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 43
20 - 39% = 27
40 - 59% = 77
60 - 79% = 203
80 - 99% = 205

DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 66.24, total records: 400
Average version length: 15.27, total versions: 3386, max versions: 20
Data pages: 21, data page slots: 21, average fill: 89%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 19

Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 8.71, total records: 2611
Average version length: 71.10, total versions: 2288, max versions: 1
Data pages: 64, data page slots: 66, average fill: 54%
Fill distribution:
0 - 19% = 11
20 - 39% = 9
40 - 59% = 15
60 - 79% = 18
80 - 99% = 11

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 10, nodes: 2611
Average data length: 11.29, total dup: 1, max dup: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 3
60 - 79% = 4
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 16.02, total records: 49
Average version length: 9.00, total versions: 71, max versions: 5
Data pages: 1, data page slots: 1, average fill: 43%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 7.20, total records: 97
Average version length: 46.06, total versions: 82, max versions: 1
Data pages: 2, data page slots: 2, average fill: 48%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 1, leaf buckets: 1, nodes: 97
Average data length: 4.74, total dup: 66, max dup: 27
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 42.03, total records: 84413
Average version length: 38.35, total versions: 4085, max versions: 5
Data pages: 897, data page slots: 901, average fill: 72%
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 16
60 - 79% = 873
80 - 99% = 3

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 61, nodes: 84413
Average data length: 0.01, total dup: 84364, max dup: 3061
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 16
60 - 79% = 22
80 - 99% = 20

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 91, nodes: 84413
Average data length: 0.91, total dup: 75807, max dup: 20
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 32
60 - 79% = 28
80 - 99% = 14

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 89, nodes: 84413
Average data length: 0.91, total dup: 75807, max dup: 20
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 37
60 - 79% = 25
80 - 99% = 13

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 103, nodes: 84413
Average data length: 0.69, total dup: 75807, max dup: 20
Fill distribution:
0 - 19% = 1
20 - 39% = 36
40 - 59% = 42
60 - 79% = 20
80 - 99% = 4

PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.94, total records: 84293
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 720, data page slots: 720, average fill: 64%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 719
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 59, nodes: 84293
Average data length: 0.00, total dup: 84102, max dup: 992
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 19
60 - 79% = 16
80 - 99% = 23

PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 149.94, total records: 5929383
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 139452, data page slots: 139452, average fill: 87%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 139450

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 6449, nodes: 5929383
Average data length: 0.26, total dup: 4833763, max dup: 101
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 3974
60 - 79% = 1624
80 - 99% = 850

Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 5979, nodes: 5929383
Average data length: 0.00, total dup: 5929378, max dup: 5465697
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5978
60 - 79% = 0
80 - 99% = 1

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 6846, nodes: 5929383
Average data length: 0.15, total dup: 5793874, max dup: 19953
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 5574
60 - 79% = 685
80 - 99% = 580

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 6753, nodes: 5929383
Average data length: 0.07, total dup: 5915644, max dup: 694352
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 5863
60 - 79% = 277
80 - 99% = 610

PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 44.88, total records: 188618
Average version length: 56.32, total versions: 38166, max versions: 1
Data pages: 2233, data page slots: 2233, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1460
80 - 99% = 772

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 218, nodes: 188618
Average data length: 1.06, total dup: 158224, max dup: 727
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 116
60 - 79% = 79
80 - 99% = 20

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 190, nodes: 188618
Average data length: 0.64, total dup: 170698, max dup: 100
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 75
60 - 79% = 93
80 - 99% = 22

RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 38, max versions: 31
Data pages: 1, data page slots: 1, average fill: 15%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 97.51, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
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: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.41, total records: 20529
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 253, data page slots: 253, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 253
80 - 99% = 0

WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 21.60, total records: 4719
Average version length: 72.28, total versions: 3310, max versions: 1
Data pages: 74, data page slots: 89, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 8
60 - 79% = 12
80 - 99% = 52

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 7, nodes: 4719
Average data length: 2.81, total dup: 4113, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 3
80 - 99% = 0

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 66.86, total records: 140221
Average version length: 70.72, total versions: 8975, max versions: 1
Data pages: 2110, data page slots: 2165, average fill: 73%
Fill distribution:
0 - 19% = 30
20 - 39% = 41
40 - 59% = 141
60 - 79% = 1528
80 - 99% = 370

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 165, nodes: 140221
Average data length: 0.41, total dup: 131540, max dup: 110
Fill distribution:
0 - 19% = 1
20 - 39% = 58
40 - 59% = 57
60 - 79% = 25
80 - 99% = 24

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 186, nodes: 140221
Average data length: 1.46, total dup: 119832, max dup: 20
Fill distribution:
0 - 19% = 0
20 - 39% = 17
40 - 59% = 96
60 - 79% = 63
80 - 99% = 10

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 60.87, total records: 107529
Average version length: 70.87, total versions: 16215, max versions: 1
Data pages: 1770, data page slots: 1898, average fill: 69%
Fill distribution:
0 - 19% = 40
20 - 39% = 139
40 - 59% = 240
60 - 79% = 947
80 - 99% = 404

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 157, nodes: 107529
Average data length: 1.44, total dup: 92215, max dup: 48
Fill distribution:
0 - 19% = 0
20 - 39% = 37
40 - 59% = 82
60 - 79% = 34
80 - 99% = 4

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 9.60, total records: 2798435
Average version length: 69.77, total versions: 2424310, max versions: 1
Data pages: 38061, data page slots: 38063, average fill: 92%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 1
60 - 79% = 4644
80 - 99% = 33413

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 3720, nodes: 2798435
Average data length: 0.81, total dup: 2565219, max dup: 91
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 3427
60 - 79% = 145
80 - 99% = 146

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 20.80, total records: 4667
Average version length: 70.99, total versions: 3272, max versions: 1
Data pages: 93, data page slots: 315, average fill: 63%
Fill distribution:
0 - 19% = 12
20 - 39% = 20
40 - 59% = 4
60 - 79% = 8
80 - 99% = 49

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 8, nodes: 4667
Average data length: 2.59, total dup: 4031, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 3
60 - 79% = 3
80 - 99% = 0

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 29.94, total records: 2656389
Average version length: 69.48, total versions: 1526173, max versions: 1
Data pages: 36041, data page slots: 36047, average fill: 87%
Fill distribution:
0 - 19% = 8
20 - 39% = 17
40 - 59% = 10
60 - 79% = 5319
80 - 99% = 30687

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 3977, nodes: 2656389
Average data length: 1.54, total dup: 2211736, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 3687
60 - 79% = 160
80 - 99% = 129

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 76.44, total records: 1836681
Average version length: 81.72, total versions: 120744, max versions: 1
Data pages: 27644, data page slots: 27644, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 6497
80 - 99% = 21146

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 2016, nodes: 1836681
Average data length: 0.15, total dup: 1795639, max dup: 200
Fill distribution:
0 - 19% = 13
20 - 39% = 2
40 - 59% = 1372
60 - 79% = 528
80 - 99% = 101

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 1358, nodes: 1836681
Average data length: 0.70, total dup: 1612059, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 59
60 - 79% = 2
80 - 99% = 1296

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 2278, nodes: 1836681
Average data length: 0.71, total dup: 1611621, max dup: 44
Fill distribution:
0 - 19% = 32
20 - 39% = 0
40 - 59% = 1531
60 - 79% = 598
80 - 99% = 117

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 41.80, total records: 2287263
Average version length: 81.52, total versions: 1122510, max versions: 1
Data pages: 34402, data page slots: 34407, average fill: 87%
Fill distribution:
0 - 19% = 11
20 - 39% = 16
40 - 59% = 9
60 - 79% = 1247
80 - 99% = 33119

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2123, nodes: 2287263
Average data length: 0.09, total dup: 2257856, max dup: 743
Fill distribution:
0 - 19% = 9
20 - 39% = 2
40 - 59% = 795
60 - 79% = 818
80 - 99% = 499

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2170, nodes: 2287263
Average data length: 1.02, total dup: 1899300, max dup: 14
Fill distribution:
0 - 19% = 71
20 - 39% = 4
40 - 59% = 608
60 - 79% = 2
80 - 99% = 1485

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 2286, nodes: 2287263
Average data length: 0.40, total dup: 2131182, max dup: 137
Fill distribution:
0 - 19% = 36
20 - 39% = 2
40 - 59% = 807
60 - 79% = 879
80 - 99% = 562

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 48.86, total records: 2863960
Average version length: 82.86, total versions: 1154947, max versions: 1
Data pages: 43227, data page slots: 43227, average fill: 86%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7348
80 - 99% = 35877

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 2700, nodes: 2863960
Average data length: 0.03, total dup: 2853130, max dup: 1942
Fill distribution:
0 - 19% = 1
20 - 39% = 9
40 - 59% = 1200
60 - 79% = 962
80 - 99% = 528

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 2060, nodes: 2863960
Average data length: 0.48, total dup: 2623653, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 102
60 - 79% = 19
80 - 99% = 1935

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 2964, nodes: 2863960
Average data length: 0.44, total dup: 2644518, max dup: 263
Fill distribution:
0 - 19% = 5
20 - 39% = 7
40 - 59% = 1266
60 - 79% = 1117
80 - 99% = 569

XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 43.92, total records: 2489849
Average version length: 81.47, total versions: 1156356, max versions: 1
Data pages: 37352, data page slots: 37358, average fill: 87%
Fill distribution:
0 - 19% = 10
20 - 39% = 16
40 - 59% = 12
60 - 79% = 1254
80 - 99% = 36060

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 2365, nodes: 2489849
Average data length: 0.03, total dup: 2481766, max dup: 1527
Fill distribution:
0 - 19% = 3
20 - 39% = 42
40 - 59% = 1013
60 - 79% = 853
80 - 99% = 454

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 2509, nodes: 2489849
Average data length: 1.03, total dup: 2062445, max dup: 14
Fill distribution:
0 - 19% = 60
20 - 39% = 55
40 - 59% = 735
60 - 79% = 130
80 - 99% = 1529

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 2552, nodes: 2489849
Average data length: 0.40, total dup: 2320095, max dup: 157
Fill distribution:
0 - 19% = 2
20 - 39% = 31
40 - 59% = 1029
60 - 79% = 986
80 - 99% = 504

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 34.41, total records: 405529
Average version length: 68.55, total versions: 202252, max versions: 1
Data pages: 5463, data page slots: 5463, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1265
80 - 99% = 4197

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 383, nodes: 405529
Average data length: 0.32, total dup: 386703, max dup: 121
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 143
60 - 79% = 155
80 - 99% = 85

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 443, nodes: 405529
Average data length: 0.87, total dup: 349112, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 179
60 - 79% = 192
80 - 99% = 72

ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 15480 ms, from 20:30:39.53 to 20:30:55.01.

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 1142567 294880 25.8085
DOC_LIST 258895 20500 7.9182
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 3386 846.5000
INVNT_TURNOVER_LOG 2611 2288 87.6292
MONEY_SALDO 49 71 144.8979
MONEY_TURNOVER_LOG 97 82 84.5360
OPTYPES 9 0 0.0000
PDISTR 84413 4085 4.8393
PERF_ESTIMATED 84293 2 0.0023
PERF_LOG 5929383 1 0.0000
PSTORNED 188618 38166 20.2345
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 38 950.0000
SETTINGS 114 0 0.0000
TRACE_STAT 20529 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 4719 3310 70.1419
XQD_1000_3300 140221 8975 6.4006
XQD_1200_2000 107529 16215 15.0796
XQD_2000_3300 2798435 2424310 86.6309
XQD_2100_3300 4667 3272 70.1092
XQD_3300_3400 2656389 1526173 57.4529
XQS_1000_1200 1836681 120744 6.5740
XQS_1000_3300 2287263 1122510 49.0765
XQS_1200_2000 2863960 1154947 40.3269
XQS_2100_3300 2489849 1156356 46.4428
XQS_3300_3400 405529 202252 49.8736
Z_USED_VIEWS 32 0 0.0000
Done for 2480 ms, from 20:31:04.56 to 20:31:07.04.

Database validation

20:31:07.28 Validation started

20:31:07.29 Relation 140 (DOC_LIST)
20:31:07.29 process pointer page 0 of 2
20:31:07.39 process pointer page 1 of 2
20:31:07.47 Index 1 (PK_DOC_LIST)
20:31:07.56 Index 2 (DOC_LIST_ID_DESC)
20:31:07.67 Index 3 (FK_DOC_LIST_AGENTS)
20:31:07.76 Relation 140 (DOC_LIST) is ok

20:31:07.76 Relation 141 (DOC_DATA)
20:31:07.76 process pointer page 0 of 7
20:31:07.87 process pointer page 1 of 7
20:31:07.98 process pointer page 2 of 7
20:31:08.12 process pointer page 3 of 7
20:31:08.26 process pointer page 4 of 7
20:31:08.39 process pointer page 5 of 7
20:31:08.51 process pointer page 6 of 7
20:31:08.54 Index 2 (DOC_DATA_DOC_WARE_UNQ)
20:31:09.01 Index 3 (DOC_DATA_ID_DESC)
20:31:09.42 Index 4 (FK_DOC_DATA_DOC_LIST)
20:31:09.70 Relation 141 (DOC_DATA) is ok

20:31:09.71 Relation 147 (INVNT_SALDO)
20:31:09.71 process pointer page 0 of 1
20:31:09.71 Index 1 (PK_INVNT_SALDO)
20:31:09.71 Relation 147 (INVNT_SALDO) is ok

20:31:09.71 Relation 150 (PDISTR)
20:31:09.71 process pointer page 0 of 1
20:31:09.76 Index 2 (PDISTR_SND_ID)
20:31:09.79 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
20:31:09.82 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
20:31:09.85 Index 5 (PDISTR_AGENT_ID)
20:31:09.87 Relation 150 (PDISTR) is ok

20:31:09.87 Relation 151 (PSTORNED)
20:31:09.87 process pointer page 0 of 2
20:31:09.99 process pointer page 1 of 2
20:31:10.01 Index 2 (PSTORNED_SND_ID)
20:31:10.05 Index 3 (PSTORNED_RCV_ID)
20:31:10.10 Relation 151 (PSTORNED) is ok

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

20:31:10.10 Relation 157 (INVNT_TURNOVER_LOG)
20:31:10.10 process pointer page 0 of 1
20:31:10.10 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
20:31:10.12 Relation 157 (INVNT_TURNOVER_LOG) is ok

20:31:10.12 Relation 160 (PERF_ESTIMATED)
20:31:10.12 process pointer page 0 of 1
20:31:10.15 Index 1 (PERF_EST_MINUTE_SINCE_START)
20:31:10.16 Relation 160 (PERF_ESTIMATED) is ok

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

20:31:10.16 Relation 162 (PERF_LOG)
20:31:10.16 process pointer page 0 of 73
20:31:10.23 process pointer page 1 of 73
20:31:10.30 process pointer page 2 of 73
20:31:10.38 process pointer page 3 of 73
20:31:10.46 process pointer page 4 of 73
20:31:10.54 process pointer page 5 of 73
20:31:10.62 process pointer page 6 of 73
20:31:10.68 process pointer page 7 of 73
20:31:10.76 process pointer page 8 of 73
20:31:10.83 process pointer page 9 of 73
20:31:10.91 process pointer page 10 of 73
20:31:10.98 process pointer page 11 of 73
20:31:11.05 process pointer page 12 of 73
20:31:11.12 process pointer page 13 of 73
20:31:11.19 process pointer page 14 of 73
20:31:11.26 process pointer page 15 of 73
20:31:11.33 process pointer page 16 of 73
20:31:11.40 process pointer page 17 of 73
20:31:11.47 process pointer page 18 of 73
20:31:11.54 process pointer page 19 of 73
20:31:11.61 process pointer page 20 of 73
20:31:11.68 process pointer page 21 of 73
20:31:11.76 process pointer page 22 of 73
20:31:11.82 process pointer page 23 of 73
20:31:11.90 process pointer page 24 of 73
20:31:11.96 process pointer page 25 of 73
20:31:12.04 process pointer page 26 of 73
20:31:12.10 process pointer page 27 of 73
20:31:12.18 process pointer page 28 of 73
20:31:12.24 process pointer page 29 of 73
20:31:12.32 process pointer page 30 of 73
20:31:12.38 process pointer page 31 of 73
20:31:12.46 process pointer page 32 of 73
20:31:12.52 process pointer page 33 of 73
20:31:12.60 process pointer page 34 of 73
20:31:12.66 process pointer page 35 of 73
20:31:12.72 process pointer page 36 of 73
20:31:12.80 process pointer page 37 of 73
20:31:12.86 process pointer page 38 of 73
20:31:12.94 process pointer page 39 of 73
20:31:13.00 process pointer page 40 of 73
20:31:13.08 process pointer page 41 of 73
20:31:13.14 process pointer page 42 of 73
20:31:13.22 process pointer page 43 of 73
20:31:13.28 process pointer page 44 of 73
20:31:13.36 process pointer page 45 of 73
20:31:13.42 process pointer page 46 of 73
20:31:13.50 process pointer page 47 of 73
20:31:13.57 process pointer page 48 of 73
20:31:13.64 process pointer page 49 of 73
20:31:13.71 process pointer page 50 of 73
20:31:13.77 process pointer page 51 of 73
20:31:13.85 process pointer page 52 of 73
20:31:13.91 process pointer page 53 of 73
20:31:13.99 process pointer page 54 of 73
20:31:14.05 process pointer page 55 of 73
20:31:14.13 process pointer page 56 of 73
20:31:14.19 process pointer page 57 of 73
20:31:14.27 process pointer page 58 of 73
20:31:14.33 process pointer page 59 of 73
20:31:14.39 process pointer page 60 of 73
20:31:14.47 process pointer page 61 of 73
20:31:14.53 process pointer page 62 of 73
20:31:14.61 process pointer page 63 of 73
20:31:14.67 process pointer page 64 of 73
20:31:14.74 process pointer page 65 of 73
20:31:14.81 process pointer page 66 of 73
20:31:14.88 process pointer page 67 of 73
20:31:14.95 process pointer page 68 of 73
20:31:15.02 process pointer page 69 of 73
20:31:15.09 process pointer page 70 of 73
20:31:15.16 process pointer page 71 of 73
20:31:15.23 process pointer page 72 of 73
20:31:15.27 Index 1 (PERF_LOG_DTS_BEG_DESC)
20:31:17.20 Index 2 (PERF_LOG_UNIT)
20:31:19.98 Index 3 (PERF_LOG_TRN_DESC)
20:31:21.58 Index 4 (PERF_LOG_GDSCODE)
20:31:23.02 Relation 162 (PERF_LOG) is ok

20:31:23.02 Relation 166 (V_STOPTEST)
20:31:23.02 Relation 166 (V_STOPTEST) is ok

20:31:23.02 Relation 183 (V_QDISTR_SOURCE)
20:31:23.02 Relation 183 (V_QDISTR_SOURCE) is ok

20:31:23.02 Relation 184 (V_QSTORNED_SOURCE)
20:31:23.02 Relation 184 (V_QSTORNED_SOURCE) is ok

20:31:23.02 Relation 258 (XQD_1000_1200)
20:31:23.03 process pointer page 0 of 1
20:31:23.03 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
20:31:23.05 Relation 258 (XQD_1000_1200) is ok

20:31:23.05 Relation 259 (XQD_1200_2000)
20:31:23.05 process pointer page 0 of 2
20:31:23.13 process pointer page 1 of 2
20:31:23.13 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
20:31:23.16 Relation 259 (XQD_1200_2000) is ok

20:31:23.16 Relation 260 (XQD_1000_3300)
20:31:23.16 process pointer page 0 of 2
20:31:23.25 process pointer page 1 of 2
20:31:23.27 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
20:31:23.32 Index 2 (XQD_1000_3300_DOC)
20:31:23.36 Relation 260 (XQD_1000_3300) is ok

20:31:23.36 Relation 261 (XQD_2000_3300)
20:31:23.36 process pointer page 0 of 20
20:31:23.53 process pointer page 1 of 20
20:31:23.69 process pointer page 2 of 20
20:31:23.86 process pointer page 3 of 20
20:31:24.03 process pointer page 4 of 20
20:31:24.20 process pointer page 5 of 20
20:31:24.38 process pointer page 6 of 20
20:31:24.55 process pointer page 7 of 20
20:31:24.72 process pointer page 8 of 20
20:31:24.89 process pointer page 9 of 20
20:31:25.06 process pointer page 10 of 20
20:31:25.23 process pointer page 11 of 20
20:31:25.41 process pointer page 12 of 20
20:31:25.56 process pointer page 13 of 20
20:31:25.72 process pointer page 14 of 20
20:31:25.87 process pointer page 15 of 20
20:31:26.01 process pointer page 16 of 20
20:31:26.17 process pointer page 17 of 20
20:31:26.31 process pointer page 18 of 20
20:31:26.42 process pointer page 19 of 20
20:31:26.51 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
20:31:27.37 Relation 261 (XQD_2000_3300) is ok

20:31:27.37 Relation 262 (XQD_2100_3300)
20:31:27.37 process pointer page 0 of 2
20:31:27.37 process pointer page 1 of 2
20:31:27.37 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
20:31:27.37 Relation 262 (XQD_2100_3300) is ok

20:31:27.37 Relation 263 (XQD_3300_3400)
20:31:27.37 process pointer page 0 of 19
20:31:27.53 process pointer page 1 of 19
20:31:27.68 process pointer page 2 of 19
20:31:27.84 process pointer page 3 of 19
20:31:27.99 process pointer page 4 of 19
20:31:28.14 process pointer page 5 of 19
20:31:28.29 process pointer page 6 of 19
20:31:28.43 process pointer page 7 of 19
20:31:28.56 process pointer page 8 of 19
20:31:28.71 process pointer page 9 of 19
20:31:28.84 process pointer page 10 of 19
20:31:28.98 process pointer page 11 of 19
20:31:29.12 process pointer page 12 of 19
20:31:29.25 process pointer page 13 of 19
20:31:29.39 process pointer page 14 of 19
20:31:29.52 process pointer page 15 of 19
20:31:29.64 process pointer page 16 of 19
20:31:29.76 process pointer page 17 of 19
20:31:29.86 process pointer page 18 of 19
20:31:29.94 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
20:31:30.92 Relation 263 (XQD_3300_3400) is ok

20:31:30.92 Relation 264 (XQS_1000_1200)
20:31:30.92 process pointer page 0 of 15
20:31:31.02 process pointer page 1 of 15
20:31:31.11 process pointer page 2 of 15
20:31:31.21 process pointer page 3 of 15
20:31:31.28 process pointer page 4 of 15
20:31:31.38 process pointer page 5 of 15
20:31:31.47 process pointer page 6 of 15
20:31:31.58 process pointer page 7 of 15
20:31:31.67 process pointer page 8 of 15
20:31:31.77 process pointer page 9 of 15
20:31:31.88 process pointer page 10 of 15
20:31:31.97 process pointer page 11 of 15
20:31:32.06 process pointer page 12 of 15
20:31:32.14 process pointer page 13 of 15
20:31:32.23 process pointer page 14 of 15
20:31:32.27 Index 1 (XQS_1000_1200_DOC_ID)
20:31:32.80 Index 2 (XQS_1000_1200_SND_ID)
20:31:33.36 Index 3 (XQS_1000_1200_RCV_ID)
20:31:33.76 Relation 264 (XQS_1000_1200) is ok

20:31:33.76 Relation 265 (XQS_1200_2000)
20:31:33.78 process pointer page 0 of 23
20:31:33.86 process pointer page 1 of 23
20:31:33.95 process pointer page 2 of 23
20:31:34.04 process pointer page 3 of 23
20:31:34.14 process pointer page 4 of 23
20:31:34.23 process pointer page 5 of 23
20:31:34.34 process pointer page 6 of 23
20:31:34.47 process pointer page 7 of 23
20:31:34.57 process pointer page 8 of 23
20:31:34.72 process pointer page 9 of 23
20:31:34.82 process pointer page 10 of 23
20:31:34.95 process pointer page 11 of 23
20:31:35.07 process pointer page 12 of 23
20:31:35.20 process pointer page 13 of 23
20:31:35.32 process pointer page 14 of 23
20:31:35.46 process pointer page 15 of 23
20:31:35.59 process pointer page 16 of 23
20:31:35.73 process pointer page 17 of 23
20:31:35.87 process pointer page 18 of 23
20:31:35.99 process pointer page 19 of 23
20:31:36.13 process pointer page 20 of 23
20:31:36.24 process pointer page 21 of 23
20:31:36.35 process pointer page 22 of 23
20:31:36.38 Index 1 (XQS_1200_2000_DOC_ID)
20:31:37.26 Index 2 (XQS_1200_2000_SND_ID)
20:31:38.19 Index 3 (XQS_1200_2000_RCV_ID)
20:31:38.85 Relation 265 (XQS_1200_2000) is ok

20:31:38.85 Relation 266 (XQS_1000_3300)
20:31:38.85 process pointer page 0 of 18
20:31:38.97 process pointer page 1 of 18
20:31:39.10 process pointer page 2 of 18
20:31:39.24 process pointer page 3 of 18
20:31:39.38 process pointer page 4 of 18
20:31:39.52 process pointer page 5 of 18
20:31:39.64 process pointer page 6 of 18
20:31:39.77 process pointer page 7 of 18
20:31:39.89 process pointer page 8 of 18
20:31:40.03 process pointer page 9 of 18
20:31:40.18 process pointer page 10 of 18
20:31:40.30 process pointer page 11 of 18
20:31:40.42 process pointer page 12 of 18
20:31:40.55 process pointer page 13 of 18
20:31:40.66 process pointer page 14 of 18
20:31:40.78 process pointer page 15 of 18
20:31:40.89 process pointer page 16 of 18
20:31:41.00 process pointer page 17 of 18
20:31:41.10 Index 1 (XQS_1000_3300_DOC_ID)
20:31:41.78 Index 2 (XQS_1000_3300_SND_ID)
20:31:42.55 Index 3 (XQS_1000_3300_RCV_ID)
20:31:43.12 Relation 266 (XQS_1000_3300) is ok

20:31:43.12 Relation 267 (XQS_2000_3300)
20:31:43.12 process pointer page 0 of 1
20:31:43.12 Index 1 (XQS_2000_3300_DOC_ID)
20:31:43.14 Index 2 (XQS_2000_3300_SND_ID)
20:31:43.14 Index 3 (XQS_2000_3300_RCV_ID)
20:31:43.14 Relation 267 (XQS_2000_3300) is ok

20:31:43.14 Relation 268 (XQS_2100_3300)
20:31:43.14 process pointer page 0 of 20
20:31:43.25 process pointer page 1 of 20
20:31:43.37 process pointer page 2 of 20
20:31:43.53 process pointer page 3 of 20
20:31:43.65 process pointer page 4 of 20
20:31:43.78 process pointer page 5 of 20
20:31:43.92 process pointer page 6 of 20
20:31:44.04 process pointer page 7 of 20
20:31:44.17 process pointer page 8 of 20
20:31:44.29 process pointer page 9 of 20
20:31:44.42 process pointer page 10 of 20
20:31:44.56 process pointer page 11 of 20
20:31:44.68 process pointer page 12 of 20
20:31:44.81 process pointer page 13 of 20
20:31:44.92 process pointer page 14 of 20
20:31:45.04 process pointer page 15 of 20
20:31:45.15 process pointer page 16 of 20
20:31:45.28 process pointer page 17 of 20
20:31:45.39 process pointer page 18 of 20
20:31:45.48 process pointer page 19 of 20
20:31:45.53 Index 1 (XQS_2100_3300_DOC_ID)
20:31:46.40 Index 2 (XQS_2100_3300_SND_ID)
20:31:47.35 Index 3 (XQS_2100_3300_RCV_ID)
20:31:48.01 Relation 268 (XQS_2100_3300) is ok

20:31:48.01 Relation 269 (XQS_3300_3400)
20:31:48.02 process pointer page 0 of 3
20:31:48.15 process pointer page 1 of 3
20:31:48.30 process pointer page 2 of 3
20:31:48.40 Index 1 (XQS_3300_3400_DOC_ID)
20:31:48.51 Index 2 (XQS_3300_3400_SND_ID)
20:31:48.61 Relation 269 (XQS_3300_3400) is ok

20:31:48.61 Relation 276 (TRACE_STAT)
20:31:48.61 process pointer page 0 of 1
20:31:48.63 Relation 276 (TRACE_STAT) is ok

20:31:48.63 Validation finished
Done for 41590 ms, from 20:31:07.06 to 20:31:48.65.

Differences between old and current firebird.log

20:31:49.69. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 8 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-01-13 20:31 345 oltp25_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 +++
***** E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log
4: Server version: WI-V2.5.5.26933 Firebird 2.5
5: Server version: WI-V2.5.5.26933 Firebird 2.5
***** E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
4: Server version: WI-V2.5.5.26933 Firebird 2.5
5:
6: WIN-2BE1UI8LGDL Wed Jan 13 18:10:52 2016
7: INET/inet_error: read errno = 10054
8:
9:
*****
+++ End of comparison +++

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


Remove 14 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.oltp25\oltp25_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-01-13 20:31:55.46 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html

Subscribe to IBSurgeon news

Subscribe