Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 30. 2016-01-26 19:44:01.16.
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.26965 Firebird 2.5
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
Classic 2.5.6 D:\OLTP-EMUL\OLTP25-SMALL.FDB ON 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-26 19:43:38.3420 -1 <null> 127.0.0.1 114363 4320 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: 2837.79 9133 510803 2016-01-26 16:43 2016-01-26 19:43
customer order: creation 66.82 64 12027 2016-01-26 16:43 2016-01-26 19:43
customer order: refuse 5.28 35 951 2016-01-26 16:43 2016-01-26 19:43
order to supplier: creation 17.30 612 3114 2016-01-26 16:43 2016-01-26 19:43
order to supplier: removal 0.66 18553 117 2016-01-26 16:43 2016-01-26 19:43
invoice (draft): creation 17.08 722 3074 2016-01-26 16:43 2016-01-26 19:43
invoice (draft): removal 8.24 140 1467 2016-01-26 16:43 2016-01-26 19:43
invoice accept: apply 10.06 146216 1811 2016-01-26 16:43 2016-01-26 19:43
invoice accept: cancel 3.41 2925 604 2016-01-26 16:43 2016-01-26 19:43
customer reserve: creation 2425.63 649 436613 2016-01-26 16:43 2016-01-26 19:43
customer reserve: removal 184.51 96 32842 2016-01-26 16:43 2016-01-26 19:43
realization accept: apply 32.29 57 5813 2016-01-26 16:43 2016-01-26 19:43
realization accept: cancel 13.90 37 2475 2016-01-26 16:43 2016-01-26 19:43
payment from customer: creation 22.73 101 4091 2016-01-26 16:43 2016-01-26 19:43
payment from customer: removal 2.24 22 392 2016-01-26 16:43 2016-01-26 19:43
payment to supplier: creation 18.85 195 3393 2016-01-26 16:43 2016-01-26 19:43
payment to supplier: removal 1.20 23 213 2016-01-26 16:43 2016-01-26 19:43
service: total inventory turnovers 5.43 1573 977 2016-01-26 16:43 2016-01-26 19:43
service: total monetary turnovers 4.54 8 818 2016-01-26 16:43 2016-01-26 19:43
service: refresh index statistics 0.07 1507 11 2016-01-26 16:43 2016-01-26 19:43
Done for 19260 ms, from 19:44:30.73 to 19:44:49.99.

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 380 8074 6837 1237 15.32 16:43:39 17:01:38
interval # 2, overall 2 998 19279 17972 1307 6.78 17:01:39 17:19:38
interval # 3, overall 3 1022 20589 18401 2188 10.63 17:19:39 17:37:38
interval # 4, overall 4 778 15859 14000 1859 11.72 17:37:39 17:55:38
interval # 5, overall 5 2978 55927 53598 2329 4.16 17:55:39 18:13:38
interval # 6, overall 6 4011 75157 72191 2966 3.95 18:13:39 18:31:38
interval # 7, overall 7 7770 140713 139859 854 0.61 18:31:39 18:49:38
interval # 8, overall 8 4652 84125 83732 393 0.47 18:49:39 19:07:38
interval # 9, overall 9 3679 67553 66220 1333 1.97 19:07:39 19:25:38
interval # 10, overall 10 2111 38131 37993 138 0.36 19:25:39 19:43:38
Done for 31990 ms, from 19:45:25.69 to 19:45:57.68.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
WARM_TIME 1 1590.99 0.3343 1.9082 1888 29
WARM_TIME 2 1652.11 0.9191 1.1146 521 13
WARM_TIME 3 1362.61 0.9012 1.0925 288 10
WARM_TIME 4 1174.01 0.9512 1.0432 142 6
WARM_TIME 5 1033.09 0.9486 1.0628 299 7
WARM_TIME 6 947.75 0.9912 1.0127 77 4
WARM_TIME 7 888.44 0.9456 1.0311 175 6
WARM_TIME 8 848.56 0.9709 1.0209 39 4
WARM_TIME 9 795.12 0.9820 1.0156 51 3
WARM_TIME 10 736.27 0.9872 1.0138 126 2
TEST_TIME 11 678.90 0.9996 1.0004 7 1
TEST_TIME 12 626.58 0.9936 1.0090 93 2
TEST_TIME 13 605.83 0.9692 1.0403 265 5
TEST_TIME 14 594.25 0.9972 1.0048 39 2
TEST_TIME 15 579.88 0.9660 1.0202 121 5
TEST_TIME 16 584.19 0.9659 1.0146 175 5
TEST_TIME 17 567.94 0.9823 1.0113 95 2
TEST_TIME 18 550.74 0.9986 1.0013 28 1
TEST_TIME 19 542.40 0.9818 1.0210 200 3
TEST_TIME 21 505.05 0.9987 1.0012 28 1
TEST_TIME 22 492.66 0.9997 1.0003 8 1
TEST_TIME 23 478.03 0.9992 1.0008 20 1
TEST_TIME 24 462.43 0.9915 1.0024 55 2
TEST_TIME 26 437.58 0.9906 1.0092 108 2
TEST_TIME 29 409.64 0.9859 1.0425 98 4
TEST_TIME 30 415.89 0.9927 1.0036 50 2
TEST_TIME 31 415.03 0.9860 1.0128 96 4
TEST_TIME 32 433.89 0.9624 1.0242 74 4
TEST_TIME 33 434.25 0.9924 1.0149 68 5
TEST_TIME 34 445.35 0.9739 1.0056 160 3
TEST_TIME 35 455.56 0.9551 1.0352 172 8
TEST_TIME 36 470.96 0.9736 1.0173 269 6
TEST_TIME 37 471.43 0.9900 1.0063 54 3
TEST_TIME 38 463.33 0.9988 1.0047 36 2
TEST_TIME 39 464.25 0.9838 1.0291 167 6
TEST_TIME 40 481.74 0.9716 1.0200 163 5
TEST_TIME 41 498.60 0.9665 1.0383 319 7
TEST_TIME 42 511.41 0.9882 1.0245 200 7
TEST_TIME 43 530.67 0.9644 1.0522 280 10
TEST_TIME 44 577.75 0.9445 1.0502 389 15
TEST_TIME 45 619.64 0.9575 1.0387 385 14
TEST_TIME 46 673.62 0.9347 1.0378 492 14
TEST_TIME 47 706.18 0.9689 1.0351 351 14
TEST_TIME 48 739.31 0.9682 1.0160 224 8
TEST_TIME 49 743.32 0.9909 1.0133 108 5
TEST_TIME 50 742.90 0.9936 1.0059 59 4
TEST_TIME 51 740.53 0.9929 1.0060 114 4
TEST_TIME 52 744.41 0.9816 1.0233 245 11
TEST_TIME 53 765.24 0.9767 1.0164 340 8
TEST_TIME 54 778.00 0.9813 1.0165 325 10
TEST_TIME 55 791.07 0.9816 1.0199 175 7
TEST_TIME 56 800.66 0.9950 1.0085 46 3
TEST_TIME 57 796.33 0.9973 1.0023 48 2
TEST_TIME 59 776.53 0.9999 1.0000 2 1
TEST_TIME 60 766.96 0.9976 1.0080 91 3
TEST_TIME 61 762.51 0.9973 1.0062 79 4
TEST_TIME 62 760.13 0.9931 1.0011 34 2
TEST_TIME 63 755.49 0.9945 1.0052 97 2
TEST_TIME 64 759.39 0.9904 1.0017 79 3
TEST_TIME 65 757.04 0.9971 1.0027 119 3
TEST_TIME 66 750.20 0.9966 1.0045 7 2
TEST_TIME 67 745.27 0.9962 1.0038 26 3
TEST_TIME 68 743.84 0.9949 1.0023 82 3
TEST_TIME 69 737.54 0.9963 1.0046 171 5
TEST_TIME 71 728.80 0.9976 1.0018 73 3
TEST_TIME 72 722.90 0.9991 1.0023 53 2
TEST_TIME 73 719.24 0.9994 1.0006 66 1
TEST_TIME 74 717.36 0.9946 1.0014 53 2
TEST_TIME 75 711.14 0.9974 1.0032 65 3
TEST_TIME 76 710.88 0.9952 1.0069 128 4
TEST_TIME 77 709.35 0.9959 1.0018 118 3
TEST_TIME 78 719.95 0.9748 1.0090 227 7
TEST_TIME 79 724.93 0.9894 1.0082 82 4
TEST_TIME 80 733.46 0.9841 1.0039 130 5
TEST_TIME 81 748.39 0.9778 1.0107 185 8
TEST_TIME 82 755.94 0.9894 1.0157 73 6
TEST_TIME 83 774.01 0.9801 1.0154 251 12
TEST_TIME 84 792.98 0.9793 1.0154 256 12
TEST_TIME 85 816.52 0.9746 1.0265 549 15
TEST_TIME 86 858.71 0.9647 1.0156 418 14
TEST_TIME 87 874.64 0.9856 1.0181 126 8
TEST_TIME 88 883.98 0.9967 1.0040 99 6
TEST_TIME 89 886.43 0.9915 1.0065 69 6
TEST_TIME 90 888.65 0.9928 1.0198 177 10
TEST_TIME 91 914.03 0.9813 1.0171 382 12
TEST_TIME 92 926.00 0.9942 1.0075 213 6
TEST_TIME 93 945.77 0.9758 1.0262 325 16
TEST_TIME 94 977.32 0.9825 1.0214 386 15
TEST_TIME 95 1006.49 0.9813 1.0233 281 16
TEST_TIME 96 1034.76 0.9850 1.0228 294 13
TEST_TIME 97 1060.58 0.9877 1.0147 147 10
TEST_TIME 98 1092.67 0.9759 1.0119 176 12
TEST_TIME 99 1117.59 0.9794 1.0157 365 16
TEST_TIME 100 1152.14 0.9756 1.0175 372 15
TEST_TIME 101 1182.83 0.9841 1.0215 424 17
TEST_TIME 102 1203.63 0.9940 1.0062 148 8
TEST_TIME 103 1229.08 0.9813 1.0156 380 15
TEST_TIME 104 1257.70 0.9830 1.0205 437 15
TEST_TIME 105 1302.81 0.9758 1.0221 520 23
TEST_TIME 106 1344.64 0.9810 1.0225 387 18
TEST_TIME 107 1401.22 0.9720 1.0243 628 25
TEST_TIME 108 1440.22 0.9874 1.0172 362 16
TEST_TIME 109 1482.67 0.9790 1.0152 429 18
TEST_TIME 110 1504.23 0.9916 1.0090 227 10
TEST_TIME 111 1513.34 0.9968 1.0022 84 5
TEST_TIME 112 1505.47 0.9990 1.0013 90 4
TEST_TIME 113 1498.42 0.9982 1.0013 54 5
TEST_TIME 114 1491.08 0.9974 1.0030 123 7
TEST_TIME 115 1493.13 0.9943 1.0048 169 10
TEST_TIME 116 1504.31 0.9890 1.0137 285 15
TEST_TIME 117 1531.05 0.9875 1.0154 423 17
TEST_TIME 118 1569.49 0.9821 1.0146 465 19
TEST_TIME 119 1614.75 0.9778 1.0216 576 25
TEST_TIME 120 1652.99 0.9897 1.0128 336 16
TEST_TIME 121 1694.56 0.9801 1.0173 523 20
TEST_TIME 122 1752.04 0.9759 1.0222 664 28
TEST_TIME 123 1804.47 0.9844 1.0153 650 24
TEST_TIME 124 1840.46 0.9874 1.0202 534 25
TEST_TIME 125 1905.78 0.9775 1.0275 727 30
TEST_TIME 126 1956.57 0.9929 1.0088 548 17
TEST_TIME 127 1977.37 0.9904 1.0108 491 18
TEST_TIME 128 2010.94 0.9862 1.0144 523 20
TEST_TIME 129 2056.14 0.9844 1.0140 493 24
TEST_TIME 130 2096.46 0.9868 1.0146 619 23
TEST_TIME 131 2164.32 0.9753 1.0199 599 25
TEST_TIME 132 2224.31 0.9849 1.0193 714 25
TEST_TIME 133 2289.10 0.9830 1.0156 702 26
TEST_TIME 134 2340.38 0.9859 1.0196 589 27
TEST_TIME 135 2394.16 0.9893 1.0097 513 19
TEST_TIME 136 2415.16 0.9947 1.0028 162 10
TEST_TIME 137 2415.49 0.9953 1.0026 264 11
TEST_TIME 138 2431.37 0.9897 1.0068 363 17
TEST_TIME 139 2457.22 0.9902 1.0051 369 14
TEST_TIME 140 2468.59 0.9934 1.0094 329 15
TEST_TIME 141 2506.70 0.9872 1.0095 436 19
TEST_TIME 142 2548.32 0.9860 1.0102 404 17
TEST_TIME 143 2584.51 0.9891 1.0125 356 19
TEST_TIME 144 2634.98 0.9862 1.0173 440 27
TEST_TIME 145 2666.54 0.9983 1.0019 248 8
TEST_TIME 146 2663.82 0.9960 1.0032 234 10
TEST_TIME 147 2664.16 0.9967 1.0035 220 12
TEST_TIME 148 2659.84 0.9985 1.0020 150 7
TEST_TIME 149 2649.69 0.9995 1.0007 24 2
TEST_TIME 150 2641.91 0.9979 1.0003 49 6
TEST_TIME 151 2636.78 0.9967 1.0031 118 8
TEST_TIME 152 2630.94 0.9987 1.0020 232 9
TEST_TIME 153 2638.46 0.9929 1.0049 230 13
TEST_TIME 154 2651.37 0.9935 1.0063 450 16
TEST_TIME 155 2667.59 0.9937 1.0058 301 13
TEST_TIME 156 2688.98 0.9914 1.0117 348 19
TEST_TIME 157 2734.30 0.9886 1.0094 366 21
TEST_TIME 158 2767.46 0.9910 1.0065 484 17
TEST_TIME 159 2791.62 0.9915 1.0129 465 24
TEST_TIME 160 2839.72 0.9895 1.0116 469 22
TEST_TIME 161 2877.71 0.9921 1.0056 418 19
TEST_TIME 162 2880.94 0.9984 1.0013 159 5
TEST_TIME 163 2874.72 0.9986 1.0012 104 5
TEST_TIME 164 2863.84 0.9998 1.0002 32 3
TEST_TIME 165 2848.56 0.9997 1.0006 42 3
TEST_TIME 166 2834.47 0.9999 1.0000 42 1
TEST_TIME 168 2805.83 0.9984 1.0042 115 5
TEST_TIME 169 2807.38 0.9980 1.0013 121 6
TEST_TIME 170 2797.43 0.9992 1.0005 170 3
TEST_TIME 171 2786.33 0.9986 1.0004 49 4
TEST_TIME 172 2772.43 0.9997 1.0001 55 3
TEST_TIME 173 2762.98 0.9979 1.0009 85 5
TEST_TIME 174 2757.97 0.9975 1.0013 176 7
TEST_TIME 175 2747.43 0.9996 1.0004 78 3
TEST_TIME 176 2739.14 0.9983 1.0007 90 4
TEST_TIME 177 2727.80 0.9998 1.0007 52 3
TEST_TIME 178 2722.70 0.9986 1.0002 57 3
TEST_TIME 180 2699.35 0.9979 1.0012 97 6
TEST_TIME 181 2702.01 0.9955 1.0027 179 11
TEST_TIME 182 2701.24 0.9980 1.0013 161 11
TEST_TIME 183 2699.02 0.9969 1.0019 174 6
TEST_TIME 184 2693.20 0.9989 1.0003 20 3
TEST_TIME 185 2682.76 0.9995 1.0000 25 2
TEST_TIME 186 2673.67 0.9982 1.0027 83 6
TEST_TIME 187 2679.98 0.9950 1.0061 203 12
TEST_TIME 188 2696.59 0.9951 1.0056 398 13
TEST_TIME 189 2716.75 0.9932 1.0077 321 14
TEST_TIME 190 2733.19 0.9964 1.0018 235 30
Done for 9440 ms, from 19:45:58.14 to 19:46:07.58.

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 83626 127642 120089 <null> 80080 <null> 5308 <null> 11818 <null> 95268 <null> 130877 178625 378438 80333 195728 1266204 <null> 16:43:39 17:01:38
fetches per second 2 77935 117036 50634 <null> 69397 104118 7234 <null> 9091 <null> 96689 100916 140810 122153 376100 232400 128444 1664119 4271 17:01:39 17:19:38
fetches per second 3 53975 <null> 151086 <null> 61361 <null> 14815 <null> 4600 <null> 110973 <null> 138976 103833 437730 <null> <null> <null> <null> 17:19:39 17:37:38
fetches per second 4 88807 104925 36794 <null> 75923 <null> 3620 <null> <null> 36934 91096 <null> 141730 137000 308173 107636 176246 1625000 <null> 17:37:39 17:55:38
fetches per second 5 61836 112832 22748 <null> 82367 88673 9590 <null> 12412 <null> 71096 73480 162220 88818 262391 176142 199106 1198444 <null> 17:55:39 18:13:38
fetches per second 6 51363 74833 52928 <null> 56037 42323 23954 15245 10926 <null> 61289 42136 127538 41464 229524 36687 171630 967428 <null> 18:13:39 18:31:38
fetches per second 7 15299 14774 25205 17547 28721 7585 26980 19602 10486 7376 20063 <null> 41003 10719 86524 25133 118147 670011 <null> 18:31:39 18:49:38
fetches per second 8 24795 <null> 28592 <null> 77307 <null> 18352 <null> 8208 13810 36990 <null> 74852 <null> 203964 <null> 105436 334878 <null> 18:49:39 19:07:38
fetches per second 9 34411 11358 32916 62345 36294 <null> 33017 <null> 4985 7946 83377 12903 99392 157857 202850 37755 102900 833376 <null> 19:07:39 19:25:38
fetches per second 10 66529 39871 48166 <null> 120075 157723 10745 24470 <null> 24887 96596 <null> 165173 <null> 236460 <null> 220825 1558600 <null> 19:25:39 19:43:38
marks per second 1 15288 11436 14471 <null> 9349 <null> 673 <null> 1050 <null> 15351 <null> 6551 25875 13332 9466 2597 11380 <null> 16:43:39 17:01:38
marks per second 2 13779 11403 4738 <null> 5443 15385 337 <null> 488 <null> 15337 12740 6110 13078 3885 23800 740 10332 339 17:01:39 17:19:38
marks per second 3 10618 <null> 19273 <null> 6684 <null> 303 <null> 344 <null> 10473 <null> 3276 12750 4033 <null> <null> <null> <null> 17:19:39 17:37:38
marks per second 4 16212 8333 4038 <null> 7917 <null> 315 <null> <null> 3913 13697 <null> 6236 12875 5685 12090 1285 15600 <null> 17:37:39 17:55:38
marks per second 5 10942 10057 2500 <null> 8904 15159 372 <null> 1301 <null> 12205 11960 10885 11958 4876 20000 1534 14333 <null> 17:55:39 18:13:38
marks per second 6 9175 7955 6374 <null> 6414 6128 882 1700 1170 <null> 8585 4990 3118 6095 2812 4281 2306 10554 <null> 18:13:39 18:31:38
marks per second 7 2808 1393 3173 2378 3308 929 566 2087 486 768 2498 <null> 1336 1217 764 2533 1256 7427 <null> 18:31:39 18:49:38
marks per second 8 4748 <null> 3428 <null> 10709 <null> 479 <null> 1072 1499 4753 <null> 1727 <null> 2056 <null> 1668 3704 <null> 18:49:39 19:07:38
marks per second 9 6097 1000 4054 11474 4272 <null> 638 <null> 338 868 8069 1487 2056 13714 4559 3587 1952 15071 <null> 19:07:39 19:25:38
marks per second 10 11937 4185 5929 <null> 13075 27695 410 2302 <null> 2790 6523 <null> 3117 <null> 5421 <null> 1265 10700 <null> 19:25:39 19:43:38
reads/fetches*100 1 4 4 4 <null> 4 <null> 14 <null> 15 <null> 6 <null> 6 3 3 3 12 0 <null> 16:43:39 17:01:38
reads/fetches*100 2 4 4 5 <null> 5 4 13 <null> 16 <null> 5 4 6 3 3 2 21 0 1 17:01:39 17:19:38
reads/fetches*100 3 6 <null> 4 <null> 5 <null> 6 <null> 17 <null> 6 <null> 6 3 3 <null> <null> <null> <null> 17:19:39 17:37:38
reads/fetches*100 4 4 4 5 <null> 4 <null> 11 <null> <null> 4 6 <null> 6 1 4 2 14 0 <null> 17:37:39 17:55:38
reads/fetches*100 5 5 5 5 <null> 4 3 7 <null> 7 <null> 7 8 6 4 4 2 13 0 <null> 17:55:39 18:13:38
reads/fetches*100 6 7 6 5 <null> 5 5 5 5 9 <null> 9 8 7 5 4 6 10 1 <null> 18:13:39 18:31:38
reads/fetches*100 7 9 9 6 3 5 8 4 3 10 9 12 <null> 7 7 4 6 8 0 <null> 18:31:39 18:49:38
reads/fetches*100 8 8 <null> 7 <null> 4 <null> 5 <null> 12 9 10 <null> 7 <null> 4 <null> 9 1 <null> 18:49:39 19:07:38
reads/fetches*100 9 9 9 6 2 6 <null> 5 <null> 13 9 10 12 7 6 4 7 9 1 <null> 19:07:39 19:25:38
reads/fetches*100 10 6 6 5 <null> 4 3 6 2 <null> 4 9 <null> 7 <null> 4 <null> 16 1 <null> 19:25:39 19:43:38
writes/marks*100 1 13 13 7 <null> 8 <null> 2 <null> 14 <null> 7 <null> 3 0 2 2 32 0 <null> 16:43:39 17:01:38
writes/marks*100 2 13 13 8 <null> 7 1 3 <null> 5 <null> 7 9 4 0 5 0 44 1 1 17:01:39 17:19:38
writes/marks*100 3 12 <null> 4 <null> 6 <null> 3 <null> 14 <null> 8 <null> 5 0 6 <null> <null> <null> <null> 17:19:39 17:37:38
writes/marks*100 4 13 16 7 <null> 7 <null> 2 <null> <null> 7 7 <null> 6 0 4 0 34 0 <null> 17:37:39 17:55:38
writes/marks*100 5 13 13 7 <null> 8 2 1 <null> 5 <null> 7 6 6 0 5 0 34 1 <null> 17:55:39 18:13:38
writes/marks*100 6 12 14 8 <null> 7 1 2 3 5 <null> 8 12 8 0 6 0 33 2 <null> 18:13:39 18:31:38
writes/marks*100 7 10 12 7 3 6 11 2 3 9 8 8 <null> 7 0 6 3 30 1 <null> 18:31:39 18:49:38
writes/marks*100 8 10 <null> 9 <null> 7 <null> 2 <null> 5 7 7 <null> 7 <null> 6 <null> 34 3 <null> 18:49:39 19:07:38
writes/marks*100 9 11 12 9 4 8 <null> 3 <null> 8 7 9 11 9 0 4 0 36 2 <null> 19:07:39 19:25:38
writes/marks*100 10 12 14 7 <null> 9 3 2 3 <null> 7 9 <null> 13 <null> 3 <null> 38 0 <null> 19:25:39 19:43:38
Done for 8390 ms, from 19:46:08.29 to 19:46:16.68.

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 304396 291212 13184 4.33 0 1992 7 13184 2016-01-26 16:43 2016-01-26 19:43
doc_list_biud 304530 291212 13318 4.37 0 63407 25 13318 2016-01-26 16:43 2016-01-26 19:43
sp_add_invoice_to_stock 2823 1811 1012 35.84 234 1825631 146216 1012 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_adding_invoice 701 604 97 13.83 15 67700 2925 97 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_client_order 1032 951 81 7.84 0 484 35 81 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_customer_reserve 42785 32842 9943 23.23 0 12249 96 9943 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_pay_from_customer 393 392 1 0.25 0 156 22 1 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_pay_to_supplier 214 213 1 0.46 0 140 23 1 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_supplier_invoice 1612 1467 145 8.99 0 1598 140 145 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_supplier_order 232 117 115 49.56 62 181581 18553 115 2016-01-26 16:43 2016-01-26 19:43
sp_cancel_write_off 5626 2475 3151 56.00 0 608 37 3151 2016-01-26 16:43 2016-01-26 19:43
sp_client_order 12027 12027 0 0.00 0 640 64 0 2016-01-26 16:43 2016-01-26 19:43
sp_customer_reserve 436613 436613 0 0.00 0 21245 649 0 2016-01-26 16:43 2016-01-26 19:43
sp_fill_shopping_cart 18215 18215 0 0.00 0 27080 101 0 2016-01-26 16:43 2016-01-26 19:43
sp_fill_shopping_cart_clo_res 436613 436613 0 0.00 0 390 2 0 2016-01-26 16:43 2016-01-26 19:43
sp_get_clo_for_invoice 1811 1811 0 0.00 0 1295 136 0 2016-01-26 16:43 2016-01-26 19:43
sp_kill_cost_storno 6871 3684 3187 46.38 0 281 5 3187 2016-01-26 16:43 2016-01-26 19:43
sp_kill_qstorno_ret_qs2qd 92838 69743 23095 24.87 0 12217 46 23095 2016-01-26 16:43 2016-01-26 19:43
sp_kill_qty_storno 59387 46080 13307 22.40 0 63407 155 13307 2016-01-26 16:43 2016-01-26 19:43
sp_lock_selected_doc 11925 10534 1391 11.66 0 78 0 1391 2016-01-26 16:43 2016-01-26 19:43
sp_make_cost_storno 15108 15108 0 0.00 0 1077 64 0 2016-01-26 16:43 2016-01-26 19:43
sp_multiply_rows_for_pdistr 15108 15108 0 0.00 0 359 10 0 2016-01-26 16:43 2016-01-26 19:43
sp_multiply_rows_for_qdistr 12027 12027 0 0.00 0 593 25 0 2016-01-26 16:43 2016-01-26 19:43
sp_pay_from_customer 4091 4091 0 0.00 15 858 101 0 2016-01-26 16:43 2016-01-26 19:43
sp_pay_to_supplier 3393 3393 0 0.00 16 1232 195 0 2016-01-26 16:43 2016-01-26 19:43
sp_payment_common 7484 7484 0 0.00 0 265 20 0 2016-01-26 16:43 2016-01-26 19:43
sp_qd_handle_on_cancel_clo 1032 951 81 7.84 0 390 12 81 2016-01-26 16:43 2016-01-26 19:43
sp_qd_handle_on_invoice_upd_sts 2499 2415 84 3.36 0 63407 1578 84 2016-01-26 16:43 2016-01-26 19:43
sp_qd_handle_on_reserve_upd_sts 5813 5813 0 0.00 0 343 10 0 2016-01-26 16:43 2016-01-26 19:43
sp_reserve_write_off 5871 5813 58 0.98 0 437 57 58 2016-01-26 16:43 2016-01-26 19:43
sp_supplier_invoice 3074 3074 0 0.00 15 27267 722 0 2016-01-26 16:43 2016-01-26 19:43
sp_supplier_order 3114 3114 0 0.00 15 11986 612 0 2016-01-26 16:43 2016-01-26 19:43
srv_find_qd_qs_mism 177811 164606 13205 7.42 0 1960 5 13205 2016-01-26 16:43 2016-01-26 19:43
srv_make_invnt_saldo 977 977 0 0.00 265 10686 1573 0 2016-01-26 16:43 2016-01-26 19:43
srv_make_money_saldo 818 818 0 0.00 0 265 8 0 2016-01-26 16:43 2016-01-26 19:43
srv_recalc_idx_stat 11 11 0 0.00 795 2387 1507 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_add_invoice_to_stock 1012 1012 0 0.00 0 202 14 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_adding_invoice 107 107 0 0.00 0 78 22 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_client_order 81 81 0 0.00 0 281 28 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_customer_reserve 4 4 0 0.00 31 124 66 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_pay_from_customer 1 1 0 0.00 0 0 0 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_pay_to_supplier 1 1 0 0.00 0 0 0 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_supplier_invoice 85 85 0 0.00 0 94 10 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_supplier_order 1510 1510 0 0.00 0 733 41 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_cancel_write_off 4 4 0 0.00 0 47 15 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-abend:sp_reserve_write_off 58 58 0 0.00 0 125 20 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_add_invoice_to_stock 1838 1838 0 0.00 0 56508 3246 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_adding_invoice 223 223 0 0.00 0 12961 698 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_client_order 951 951 0 0.00 0 327 28 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_customer_reserve 332 332 0 0.00 0 297 30 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_pay_from_customer 392 392 0 0.00 0 390 23 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_pay_to_supplier 213 213 0 0.00 0 234 20 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_supplier_invoice 177 177 0 0.00 0 234 31 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_supplier_order 117 117 0 0.00 0 133490 5316 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_cancel_write_off 505 505 0 0.00 0 315 29 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_client_order 12027 12027 0 0.00 0 608 36 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_customer_reserve 556 556 0 0.00 0 296 22 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_pay_from_customer 4091 4091 0 0.00 0 500 25 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_pay_to_supplier 3393 3393 0 0.00 0 312 24 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_reserve_write_off 5813 5813 0 0.00 0 608 33 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_supplier_invoice 3074 3074 0 0.00 0 483 35 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:sp_supplier_order 3115 3115 0 0.00 0 546 36 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:srv_make_invnt_saldo 977 977 0 0.00 0 1747 8 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:srv_make_money_saldo 818 818 0 0.00 0 172 6 0 2016-01-26 16:43 2016-01-26 19:43
t$perf-norm:srv_recalc_idx_stat 11 11 0 0.00 0 171 32 0 2016-01-26 16:43 2016-01-26 19:43
v_add_invoice_to_stock 5646 3622 2024 35.84 0 78 3 2024 2016-01-26 16:43 2016-01-26 19:43
v_all_customers 17880 17880 0 0.00 0 16 0 0 2016-01-26 16:43 2016-01-26 19:43
v_all_suppliers 12376 12376 0 0.00 0 17 0 0 2016-01-26 16:43 2016-01-26 19:43
v_all_wares 24054 24054 0 0.00 0 62 0 0 2016-01-26 16:43 2016-01-26 19:43
v_cancel_adding_invoice 506 446 60 11.85 0 125 11 60 2016-01-26 16:43 2016-01-26 19:43
v_cancel_client_order 2064 1902 162 7.84 0 35 1 162 2016-01-26 16:43 2016-01-26 19:43
v_cancel_customer_prepayment 786 784 2 0.25 0 33 1 2 2016-01-26 16:43 2016-01-26 19:43
v_cancel_customer_reserve 672 664 8 1.19 0 93 2 8 2016-01-26 16:43 2016-01-26 19:43
v_cancel_payment_to_supplier 428 426 2 0.46 0 24 1 2 2016-01-26 16:43 2016-01-26 19:43
v_cancel_supplier_invoice 524 354 170 32.44 0 100 4 170 2016-01-26 16:43 2016-01-26 19:43
v_cancel_supplier_order 464 234 230 49.56 0 109 1 230 2016-01-26 16:43 2016-01-26 19:43
v_cancel_write_off 1018 1010 8 0.78 0 109 5 8 2016-01-26 16:43 2016-01-26 19:43
v_max_id_clo_ord 3114 3114 0 0.00 0 203 2 0 2016-01-26 16:43 2016-01-26 19:43
v_max_id_clo_res 556 556 0 0.00 0 125 3 0 2016-01-26 16:43 2016-01-26 19:43
v_max_id_ord_sup 3074 3074 0 0.00 0 125 2 0 2016-01-26 16:43 2016-01-26 19:43
v_max_non_paid_invoice 3393 3393 0 0.00 0 32 2 0 2016-01-26 16:43 2016-01-26 19:43
v_max_non_paid_realizn 4091 4091 0 0.00 0 47 5 0 2016-01-26 16:43 2016-01-26 19:43
v_min_id_clo_ord 3114 3114 0 0.00 0 343 10 0 2016-01-26 16:43 2016-01-26 19:43
v_min_id_clo_res 556 556 0 0.00 0 47 2 0 2016-01-26 16:43 2016-01-26 19:43
v_min_id_ord_sup 3074 3074 0 0.00 0 530 9 0 2016-01-26 16:43 2016-01-26 19:43
v_min_non_paid_invoice 3393 3393 0 0.00 0 234 14 0 2016-01-26 16:43 2016-01-26 19:43
v_min_non_paid_realizn 4091 4091 0 0.00 0 116 10 0 2016-01-26 16:43 2016-01-26 19:43
v_our_firm 6174 6174 0 0.00 0 47 0 0 2016-01-26 16:43 2016-01-26 19:43
v_reserve_write_off 11742 11626 116 0.98 0 125 1 116 2016-01-26 16:43 2016-01-26 19:43
x_lock_depdocs_on_canc_invoice 2347 1894 453 19.30 0 110 5 453 2016-01-26 16:43 2016-01-26 19:43
x_lock_depdocs_on_canc_sup_ord 232 117 115 49.56 0 49 7 115 2016-01-26 16:43 2016-01-26 19:43
x_make_qstorno_1000_1200 3114 3114 0 0.00 0 2979 273 0 2016-01-26 16:43 2016-01-26 19:43
x_make_qstorno_1200_2000 3074 3074 0 0.00 0 9120 465 0 2016-01-26 16:43 2016-01-26 19:43
x_make_qstorno_2100_3300 436613 436613 0 0.00 0 21245 643 0 2016-01-26 16:43 2016-01-26 19:43
Done for 48020 ms, from 19:47:04.95 to 19:47:52.97.

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 10 sp_kill_cost_storno 335544336 2016-01-26 17:08 2016-01-26 19:03
deadlock 3 sp_lock_selected_doc 335544336 2016-01-26 18:17 2016-01-26 18:55
deadlock 7 sp_qd_handle_on_invoice_upd_sts 335544336 2016-01-26 17:17 2016-01-26 18:42
lock_conflict 2 sp_kill_cost_storno 335544345 2016-01-26 16:48 2016-01-26 18:30
lock_conflict 1160 sp_lock_selected_doc 335544345 2016-01-26 16:43 2016-01-26 19:43
lock_conflict 81 sp_qd_handle_on_cancel_clo 335544345 2016-01-26 16:46 2016-01-26 19:23
lock_conflict 32 sp_qd_handle_on_invoice_upd_sts 335544345 2016-01-26 16:44 2016-01-26 19:30
lock_conflict 25 x_lock_depdocs_on_canc_invoice 335544345 2016-01-26 16:48 2016-01-26 19:11
lock_conflict 72 x_lock_depdocs_on_canc_sup_ord 335544345 2016-01-26 16:46 2016-01-26 19:43
Done for 2120 ms, from 19:47:53.86 to 19:47:55.98.

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 114703
MON$OLDEST_ACTIVE 114704
MON$OLDEST_SNAPSHOT 114704
MON$NEXT_TRANSACTION 114704
MON$PAGE_BUFFERS 384
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 2015-12-11 10:02:47.3010
MON$PAGES 282041
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26965 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26965 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26965 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26965 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 119128
Page size 8192
ODS version 11.2
Oldest transaction 114705
Oldest active 114706
Oldest snapshot 114706
Next transaction 114707
Bumped transaction 1
Sequence number 0
Next attachment ID 4412
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 force write

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: 39.50, total records: 702101
Average version length: 46.90, total versions: 106758, max versions: 1
Data pages: 7493, data page slots: 7493, average fill: 76%
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 43
60 - 79% = 6333
80 - 99% = 1111

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 2862, nodes: 702101
Average data length: 12.99, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 297
20 - 39% = 19
40 - 59% = 1809
60 - 79% = 37
80 - 99% = 700

Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 2029, nodes: 702101
Average data length: 5.80, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 13
40 - 59% = 2016
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 931, nodes: 702101
Average data length: 1.45, total dup: 537624, max dup: 49
Fill distribution:
0 - 19% = 43
20 - 39% = 10
40 - 59% = 623
60 - 79% = 2
80 - 99% = 253

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 55.66, total records: 160076
Average version length: 37.79, total versions: 27333, max versions: 4
Data pages: 2035, data page slots: 2035, average fill: 79%
Fill distribution:
0 - 19% = 4
20 - 39% = 16
40 - 59% = 15
60 - 79% = 1281
80 - 99% = 719

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

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 159, nodes: 160076
Average data length: 0.01, total dup: 160026, max dup: 22073
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 129
60 - 79% = 17
80 - 99% = 13

Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 463, nodes: 160076
Average data length: 6.17, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 47
20 - 39% = 127
40 - 59% = 176
60 - 79% = 16
80 - 99% = 97

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: 62.99, total records: 400
Average version length: 15.07, total versions: 200222, max versions: 561
Data pages: 823, data page slots: 823, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 823

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: 2.21, total records: 75233
Average version length: 70.81, total versions: 72899, max versions: 1
Data pages: 1076, data page slots: 1077, average fill: 90%
Fill distribution:
0 - 19% = 2
20 - 39% = 6
40 - 59% = 20
60 - 79% = 92
80 - 99% = 956

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 180, nodes: 75233
Average data length: 8.01, total dup: 9038, max dup: 3
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 62
60 - 79% = 60
80 - 99% = 53

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

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: 0.10, total records: 2524
Average version length: 46.43, total versions: 2519, max versions: 1
Data pages: 27, data page slots: 27, average fill: 92%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 27

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 2, nodes: 2524
Average data length: 0.34, total dup: 2456, max dup: 461
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 1
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: 35.01, total records: 114332
Average version length: 33.62, total versions: 32432, max versions: 10
Data pages: 1202, data page slots: 1202, average fill: 78%
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 6
60 - 79% = 879
80 - 99% = 312

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 92, nodes: 114332
Average data length: 0.01, total dup: 114283, max dup: 21056
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 47
60 - 79% = 24
80 - 99% = 19

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 120, nodes: 114332
Average data length: 0.93, total dup: 102448, max dup: 31
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 55
60 - 79% = 28
80 - 99% = 23

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 125, nodes: 114332
Average data length: 0.93, total dup: 102448, max dup: 31
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 57
60 - 79% = 35
80 - 99% = 15

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 122, nodes: 114332
Average data length: 0.70, total dup: 102448, max dup: 31
Fill distribution:
0 - 19% = 1
20 - 39% = 22
40 - 59% = 56
60 - 79% = 29
80 - 99% = 14

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

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 33, nodes: 44438
Average data length: 0.01, total dup: 44255, max dup: 1887
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 16
60 - 79% = 11
80 - 99% = 6

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.80, total records: 3392415
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 79789, data page slots: 79789, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 79788

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 3554, nodes: 3392415
Average data length: 0.37, total dup: 2508658, max dup: 55
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 1794
60 - 79% = 1061
80 - 99% = 697

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

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 3881, nodes: 3392415
Average data length: 0.18, total dup: 3296997, max dup: 11578
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 3042
60 - 79% = 468
80 - 99% = 368

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 3767, nodes: 3392415
Average data length: 0.14, total dup: 3358848, max dup: 362064
Fill distribution:
0 - 19% = 10
20 - 39% = 1
40 - 59% = 2930
60 - 79% = 360
80 - 99% = 466

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: 48.28, total records: 106921
Average version length: 55.03, total versions: 13214, max versions: 1
Data pages: 1251, data page slots: 1251, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 1058
80 - 99% = 190

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 131, nodes: 106921
Average data length: 1.25, total dup: 86766, max dup: 270
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 104
60 - 79% = 24
80 - 99% = 3

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 98, nodes: 106921
Average data length: 0.64, total dup: 97024, max dup: 93
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 42
60 - 79% = 39
80 - 99% = 16

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: 1980, max versions: 1088
Data pages: 7, data page slots: 7, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 6

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.42, total records: 1739
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 22, data page slots: 22, average fill: 74%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 21
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: 0.63, total records: 60923
Average version length: 72.10, total versions: 60404, max versions: 1
Data pages: 845, data page slots: 1007, average fill: 94%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2
80 - 99% = 842

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 61, nodes: 60923
Average data length: 1.31, total dup: 53381, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 17
60 - 79% = 32
80 - 99% = 12

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 56.91, total records: 289165
Average version length: 69.73, total versions: 57967, max versions: 1
Data pages: 3971, data page slots: 3971, average fill: 82%
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 0
60 - 79% = 1046
80 - 99% = 2921

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 303, nodes: 289165
Average data length: 0.23, total dup: 279425, max dup: 133
Fill distribution:
0 - 19% = 1
20 - 39% = 64
40 - 59% = 132
60 - 79% = 24
80 - 99% = 82

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 366, nodes: 289165
Average data length: 1.31, total dup: 250581, max dup: 29
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 197
60 - 79% = 116
80 - 99% = 45

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 14.70, total records: 228660
Average version length: 71.02, total versions: 181771, max versions: 1
Data pages: 3132, data page slots: 3132, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 204
80 - 99% = 2925

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 246, nodes: 228660
Average data length: 1.13, total dup: 202617, max dup: 91
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 77
60 - 79% = 109
80 - 99% = 60

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 11.43, total records: 1845677
Average version length: 69.52, total versions: 1551542, max versions: 1
Data pages: 25095, data page slots: 25095, average fill: 91%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3362
80 - 99% = 21732

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 2372, nodes: 1845677
Average data length: 0.87, total dup: 1681581, max dup: 99
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2063
60 - 79% = 152
80 - 99% = 156

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 0.47, total records: 120113
Average version length: 70.46, total versions: 119312, max versions: 1
Data pages: 4752, data page slots: 5230, average fill: 32%
Fill distribution:
0 - 19% = 3015
20 - 39% = 207
40 - 59% = 127
60 - 79% = 73
80 - 99% = 1330

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 153, nodes: 120113
Average data length: 1.14, total dup: 107240, max dup: 99
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 75
60 - 79% = 58
80 - 99% = 13

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 38.50, total records: 1230813
Average version length: 69.27, total versions: 555258, max versions: 1
Data pages: 16866, data page slots: 16877, average fill: 84%
Fill distribution:
0 - 19% = 45
20 - 39% = 80
40 - 59% = 84
60 - 79% = 2986
80 - 99% = 13671

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1861, nodes: 1230813
Average data length: 1.55, total dup: 1027139, max dup: 29
Fill distribution:
0 - 19% = 4
20 - 39% = 148
40 - 59% = 1437
60 - 79% = 137
80 - 99% = 135

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.68, total records: 1299256
Average version length: 82.37, total versions: 63796, max versions: 1
Data pages: 19527, data page slots: 19527, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 6589
80 - 99% = 12937

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 1425, nodes: 1299256
Average data length: 0.15, total dup: 1270164, max dup: 184
Fill distribution:
0 - 19% = 12
20 - 39% = 0
40 - 59% = 981
60 - 79% = 358
80 - 99% = 74

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 975, nodes: 1299256
Average data length: 0.71, total dup: 1139357, max dup: 49
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 62
60 - 79% = 5
80 - 99% = 903

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1614, nodes: 1299256
Average data length: 0.72, total dup: 1139184, max dup: 44
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 1131
60 - 79% = 407
80 - 99% = 66

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 56.81, total records: 1000364
Average version length: 81.26, total versions: 301582, max versions: 1
Data pages: 15105, data page slots: 15115, average fill: 84%
Fill distribution:
0 - 19% = 41
20 - 39% = 45
40 - 59% = 57
60 - 79% = 3312
80 - 99% = 11650

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 911, nodes: 1000364
Average data length: 0.13, total dup: 982335, max dup: 463
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 264
60 - 79% = 428
80 - 99% = 217

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 1003, nodes: 1000364
Average data length: 0.98, total dup: 841230, max dup: 14
Fill distribution:
0 - 19% = 42
20 - 39% = 3
40 - 59% = 395
60 - 79% = 1
80 - 99% = 562

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 1055, nodes: 1000364
Average data length: 0.57, total dup: 906240, max dup: 77
Fill distribution:
0 - 19% = 34
20 - 39% = 0
40 - 59% = 325
60 - 79% = 499
80 - 99% = 197

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 55.47, total records: 1817099
Average version length: 83.36, total versions: 583950, max versions: 1
Data pages: 27398, data page slots: 27398, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7263
80 - 99% = 20135

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 1774, nodes: 1817099
Average data length: 0.04, total dup: 1809237, max dup: 1717
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 947
60 - 79% = 558
80 - 99% = 265

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 1378, nodes: 1817099
Average data length: 0.52, total dup: 1652604, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 195
60 - 79% = 29
80 - 99% = 1152

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1967, nodes: 1817099
Average data length: 0.50, total dup: 1659412, max dup: 266
Fill distribution:
0 - 19% = 5
20 - 39% = 2
40 - 59% = 1010
60 - 79% = 650
80 - 99% = 300

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: 58.90, total records: 1300321
Average version length: 81.62, total versions: 362108, max versions: 1
Data pages: 19689, data page slots: 19702, average fill: 84%
Fill distribution:
0 - 19% = 54
20 - 39% = 75
40 - 59% = 85
60 - 79% = 3679
80 - 99% = 15796

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 1197, nodes: 1300321
Average data length: 0.04, total dup: 1294568, max dup: 1197
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 491
60 - 79% = 407
80 - 99% = 289

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 1491, nodes: 1300321
Average data length: 1.00, total dup: 1088211, max dup: 14
Fill distribution:
0 - 19% = 78
20 - 39% = 14
40 - 59% = 789
60 - 79% = 8
80 - 99% = 602

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 1354, nodes: 1300321
Average data length: 0.54, total dup: 1182996, max dup: 99
Fill distribution:
0 - 19% = 1
20 - 39% = 9
40 - 59% = 612
60 - 79% = 405
80 - 99% = 327

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 51.45, total records: 349739
Average version length: 68.43, total versions: 87081, max versions: 1
Data pages: 4710, data page slots: 4710, average fill: 82%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2579
80 - 99% = 2130

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 323, nodes: 349739
Average data length: 0.27, total dup: 336141, max dup: 203
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 115
60 - 79% = 134
80 - 99% = 74

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 368, nodes: 349739
Average data length: 0.85, total dup: 302594, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 137
60 - 79% = 154
80 - 99% = 77

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 6400 ms, from 19:47:56.79 to 19:48:03.19.

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 702101 106758 15.2055
DOC_LIST 160076 27333 17.0750
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 200222 50055.5000
INVNT_TURNOVER_LOG 75233 72899 96.8976
MONEY_SALDO 49 9004 18375.5102
MONEY_TURNOVER_LOG 2524 2519 99.8019
OPTYPES 9 0 0.0000
PDISTR 114332 32432 28.3665
PERF_ESTIMATED 44438 2 0.0045
PERF_LOG 3392415 1 0.0000
PSTORNED 106921 13214 12.3586
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 1980 49500.0000
SETTINGS 114 0 0.0000
TRACE_STAT 1739 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 60923 60404 99.1481
XQD_1000_3300 289165 57967 20.0463
XQD_1200_2000 228660 181771 79.4940
XQD_2000_3300 1845677 1551542 84.0635
XQD_2100_3300 120113 119312 99.3331
XQD_3300_3400 1230813 555258 45.1131
XQS_1000_1200 1299256 63796 4.9101
XQS_1000_3300 1000364 301582 30.1472
XQS_1200_2000 1817099 583950 32.1363
XQS_2100_3300 1300321 362108 27.8475
XQS_3300_3400 349739 87081 24.8988
Z_USED_VIEWS 32 0 0.0000
Done for 1640 ms, from 19:48:09.11 to 19:48:10.75.

Database validation

19:48:11.16 Validation started

19:48:11.16 Relation 140 (DOC_LIST)
19:48:11.16 process pointer page 0 of 2
19:48:11.25 process pointer page 1 of 2
19:48:11.25 Index 1 (PK_DOC_LIST)
19:48:11.30 Index 2 (DOC_LIST_ID_DESC)
19:48:11.33 Index 3 (FK_DOC_LIST_AGENTS)
19:48:11.35 Relation 140 (DOC_LIST) is ok

19:48:11.35 Relation 141 (DOC_DATA)
19:48:11.35 process pointer page 0 of 4
19:48:11.39 process pointer page 1 of 4
19:48:11.44 process pointer page 2 of 4
19:48:11.49 process pointer page 3 of 4
19:48:11.52 Index 2 (DOC_DATA_DOC_WARE_UNQ)
19:48:11.63 Index 3 (DOC_DATA_ID_DESC)
19:48:11.70 Index 4 (FK_DOC_DATA_DOC_LIST)
19:48:11.77 Relation 141 (DOC_DATA) is ok

19:48:11.77 Relation 147 (INVNT_SALDO)
19:48:11.77 process pointer page 0 of 1
19:48:12.92 Index 1 (PK_INVNT_SALDO)
19:48:12.92 Relation 147 (INVNT_SALDO) is ok

19:48:12.92 Relation 150 (PDISTR)
19:48:12.92 process pointer page 0 of 1
19:48:12.98 Index 2 (PDISTR_SND_ID)
19:48:13.00 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
19:48:13.01 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
19:48:13.03 Index 5 (PDISTR_AGENT_ID)
19:48:13.03 Relation 150 (PDISTR) is ok

19:48:13.03 Relation 151 (PSTORNED)
19:48:13.03 process pointer page 0 of 1
19:48:13.09 Index 2 (PSTORNED_SND_ID)
19:48:13.11 Index 3 (PSTORNED_RCV_ID)
19:48:13.12 Relation 151 (PSTORNED) is ok

19:48:13.12 Relation 156 (SEMAPHORES)
19:48:13.12 process pointer page 0 of 1
19:48:13.12 Index 1 (PK_SEMAPHORES)
19:48:13.12 Index 2 (SEMAPHORES_TASK_UNQ)
19:48:13.12 Relation 156 (SEMAPHORES) is ok

19:48:13.12 Relation 157 (INVNT_TURNOVER_LOG)
19:48:13.12 process pointer page 0 of 1
19:48:13.16 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
19:48:13.17 Relation 157 (INVNT_TURNOVER_LOG) is ok

19:48:13.17 Relation 160 (PERF_ESTIMATED)
19:48:13.17 process pointer page 0 of 1
19:48:13.17 Index 1 (PERF_EST_MINUTE_SINCE_START)
19:48:13.19 Relation 160 (PERF_ESTIMATED) is ok

19:48:13.19 Relation 161 (PERF_ISQL_STAT)
19:48:13.19 process pointer page 0 of 1
19:48:13.19 Index 1 (PERF_ISQL_STAT_TRN)
19:48:13.19 Relation 161 (PERF_ISQL_STAT) is ok

19:48:13.19 Relation 162 (PERF_LOG)
19:48:13.19 process pointer page 0 of 42
19:48:13.22 process pointer page 1 of 42
19:48:13.25 process pointer page 2 of 42
19:48:13.28 process pointer page 3 of 42
19:48:13.31 process pointer page 4 of 42
19:48:13.33 process pointer page 5 of 42
19:48:13.36 process pointer page 6 of 42
19:48:13.39 process pointer page 7 of 42
19:48:13.40 process pointer page 8 of 42
19:48:13.44 process pointer page 9 of 42
19:48:13.47 process pointer page 10 of 42
19:48:13.50 process pointer page 11 of 42
19:48:13.51 process pointer page 12 of 42
19:48:13.55 process pointer page 13 of 42
19:48:13.58 process pointer page 14 of 42
19:48:13.61 process pointer page 15 of 42
19:48:13.69 process pointer page 16 of 42
19:48:13.75 process pointer page 17 of 42
19:48:13.76 process pointer page 18 of 42
19:48:13.79 process pointer page 19 of 42
19:48:13.83 process pointer page 20 of 42
19:48:13.89 process pointer page 21 of 42
19:48:13.94 process pointer page 22 of 42
19:48:13.97 process pointer page 23 of 42
19:48:14.00 process pointer page 24 of 42
19:48:14.06 process pointer page 25 of 42
19:48:14.14 process pointer page 26 of 42
19:48:14.20 process pointer page 27 of 42
19:48:14.26 process pointer page 28 of 42
19:48:14.34 process pointer page 29 of 42
19:48:14.40 process pointer page 30 of 42
19:48:14.48 process pointer page 31 of 42
19:48:14.54 process pointer page 32 of 42
19:48:14.59 process pointer page 33 of 42
19:48:14.62 process pointer page 34 of 42
19:48:14.65 process pointer page 35 of 42
19:48:14.68 process pointer page 36 of 42
19:48:14.75 process pointer page 37 of 42
19:48:14.81 process pointer page 38 of 42
19:48:14.89 process pointer page 39 of 42
19:48:14.92 process pointer page 40 of 42
19:48:14.93 process pointer page 41 of 42
19:48:14.95 Index 1 (PERF_LOG_DTS_BEG_DESC)
19:48:15.45 Index 2 (PERF_LOG_UNIT)
19:48:16.26 Index 3 (PERF_LOG_TRN_DESC)
19:48:16.67 Index 4 (PERF_LOG_GDSCODE)
19:48:16.93 Relation 162 (PERF_LOG) is ok

19:48:16.93 Relation 166 (V_STOPTEST)
19:48:16.93 Relation 166 (V_STOPTEST) is ok

19:48:16.93 Relation 183 (V_QDISTR_SOURCE)
19:48:16.93 Relation 183 (V_QDISTR_SOURCE) is ok

19:48:16.93 Relation 184 (V_QSTORNED_SOURCE)
19:48:16.93 Relation 184 (V_QSTORNED_SOURCE) is ok

19:48:16.93 Relation 258 (XQD_1000_1200)
19:48:16.95 process pointer page 0 of 1
19:48:17.01 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
19:48:17.04 Relation 258 (XQD_1000_1200) is ok

19:48:17.04 Relation 259 (XQD_1200_2000)
19:48:17.04 process pointer page 0 of 2
19:48:17.12 process pointer page 1 of 2
19:48:17.21 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
19:48:17.27 Relation 259 (XQD_1200_2000) is ok

19:48:17.27 Relation 260 (XQD_1000_3300)
19:48:17.27 process pointer page 0 of 3
19:48:17.37 process pointer page 1 of 3
19:48:17.49 process pointer page 2 of 3
19:48:17.49 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
19:48:17.52 Index 2 (XQD_1000_3300_DOC)
19:48:17.55 Relation 260 (XQD_1000_3300) is ok

19:48:17.55 Relation 261 (XQD_2000_3300)
19:48:17.55 process pointer page 0 of 14
19:48:17.63 process pointer page 1 of 14
19:48:17.69 process pointer page 2 of 14
19:48:17.87 process pointer page 3 of 14
19:48:17.94 process pointer page 4 of 14
19:48:18.01 process pointer page 5 of 14
19:48:18.07 process pointer page 6 of 14
19:48:18.24 process pointer page 7 of 14
19:48:18.33 process pointer page 8 of 14
19:48:18.40 process pointer page 9 of 14
19:48:18.44 process pointer page 10 of 14
19:48:18.51 process pointer page 11 of 14
19:48:18.55 process pointer page 12 of 14
19:48:18.63 process pointer page 13 of 14
19:48:18.65 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
19:48:18.90 Relation 261 (XQD_2000_3300) is ok

19:48:18.90 Relation 262 (XQD_2100_3300)
19:48:18.90 process pointer page 0 of 3
19:48:18.91 process pointer page 1 of 3
19:48:18.94 process pointer page 2 of 3
19:48:18.97 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
19:48:18.99 Relation 262 (XQD_2100_3300) is ok

19:48:18.99 Relation 263 (XQD_3300_3400)
19:48:18.99 process pointer page 0 of 9
19:48:19.05 process pointer page 1 of 9
19:48:19.11 process pointer page 2 of 9
19:48:19.16 process pointer page 3 of 9
19:48:19.21 process pointer page 4 of 9
19:48:19.24 process pointer page 5 of 9
19:48:19.29 process pointer page 6 of 9
19:48:19.33 process pointer page 7 of 9
19:48:19.43 process pointer page 8 of 9
19:48:19.47 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
19:48:19.72 Relation 263 (XQD_3300_3400) is ok

19:48:19.72 Relation 264 (XQS_1000_1200)
19:48:19.72 process pointer page 0 of 11
19:48:19.77 process pointer page 1 of 11
19:48:19.83 process pointer page 2 of 11
19:48:19.91 process pointer page 3 of 11
19:48:19.96 process pointer page 4 of 11
19:48:20.00 process pointer page 5 of 11
19:48:20.03 process pointer page 6 of 11
19:48:20.07 process pointer page 7 of 11
19:48:20.11 process pointer page 8 of 11
19:48:20.16 process pointer page 9 of 11
19:48:20.24 process pointer page 10 of 11
19:48:20.25 Index 1 (XQS_1000_1200_DOC_ID)
19:48:20.39 Index 2 (XQS_1000_1200_SND_ID)
19:48:20.52 Index 3 (XQS_1000_1200_RCV_ID)
19:48:20.60 Relation 264 (XQS_1000_1200) is ok

19:48:20.60 Relation 265 (XQS_1200_2000)
19:48:20.60 process pointer page 0 of 15
19:48:20.63 process pointer page 1 of 15
19:48:20.66 process pointer page 2 of 15
19:48:20.67 process pointer page 3 of 15
19:48:20.71 process pointer page 4 of 15
19:48:20.74 process pointer page 5 of 15
19:48:20.77 process pointer page 6 of 15
19:48:20.81 process pointer page 7 of 15
19:48:20.86 process pointer page 8 of 15
19:48:20.97 process pointer page 9 of 15
19:48:21.02 process pointer page 10 of 15
19:48:21.08 process pointer page 11 of 15
19:48:21.17 process pointer page 12 of 15
19:48:21.22 process pointer page 13 of 15
19:48:21.30 process pointer page 14 of 15
19:48:21.31 Index 1 (XQS_1200_2000_DOC_ID)
19:48:21.49 Index 2 (XQS_1200_2000_SND_ID)
19:48:21.77 Index 3 (XQS_1200_2000_RCV_ID)
19:48:22.02 Relation 265 (XQS_1200_2000) is ok

19:48:22.02 Relation 266 (XQS_1000_3300)
19:48:22.02 process pointer page 0 of 8
19:48:22.06 process pointer page 1 of 8
19:48:22.09 process pointer page 2 of 8
19:48:22.16 process pointer page 3 of 8
19:48:22.27 process pointer page 4 of 8
19:48:22.37 process pointer page 5 of 8
19:48:22.50 process pointer page 6 of 8
19:48:22.62 process pointer page 7 of 8
19:48:22.66 Index 1 (XQS_1000_3300_DOC_ID)
19:48:22.78 Index 2 (XQS_1000_3300_SND_ID)
19:48:22.87 Index 3 (XQS_1000_3300_RCV_ID)
19:48:22.95 Relation 266 (XQS_1000_3300) is ok

19:48:22.95 Relation 267 (XQS_2000_3300)
19:48:22.95 process pointer page 0 of 1
19:48:22.95 Index 1 (XQS_2000_3300_DOC_ID)
19:48:22.95 Index 2 (XQS_2000_3300_SND_ID)
19:48:22.95 Index 3 (XQS_2000_3300_RCV_ID)
19:48:22.95 Relation 267 (XQS_2000_3300) is ok

19:48:22.95 Relation 268 (XQS_2100_3300)
19:48:22.95 process pointer page 0 of 11
19:48:22.98 process pointer page 1 of 11
19:48:23.01 process pointer page 2 of 11
19:48:23.06 process pointer page 3 of 11
19:48:23.09 process pointer page 4 of 11
19:48:23.12 process pointer page 5 of 11
19:48:23.15 process pointer page 6 of 11
19:48:23.19 process pointer page 7 of 11
19:48:23.22 process pointer page 8 of 11
19:48:23.25 process pointer page 9 of 11
19:48:23.28 process pointer page 10 of 11
19:48:23.28 Index 1 (XQS_2100_3300_DOC_ID)
19:48:23.48 Index 2 (XQS_2100_3300_SND_ID)
19:48:23.75 Index 3 (XQS_2100_3300_RCV_ID)
19:48:23.93 Relation 268 (XQS_2100_3300) is ok

19:48:23.93 Relation 269 (XQS_3300_3400)
19:48:23.93 process pointer page 0 of 3
19:48:24.04 process pointer page 1 of 3
19:48:24.12 process pointer page 2 of 3
19:48:24.14 Index 1 (XQS_3300_3400_DOC_ID)
19:48:24.22 Index 2 (XQS_3300_3400_SND_ID)
19:48:24.29 Relation 269 (XQS_3300_3400) is ok

19:48:24.29 Relation 276 (TRACE_STAT)
19:48:24.29 process pointer page 0 of 1
19:48:24.29 Relation 276 (TRACE_STAT) is ok

19:48:24.29 Validation finished
Done for 13540 ms, from 19:48:10.77 to 19:48:24.31.

Differences between old and current firebird.log

19:48:24.75. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-01-26 19:48 309 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 +++
result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++

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


Remove 92 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-26 19:48:27.34 - 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