Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.03.2024 07:08
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Record versions statistics    as table    as chart
  4. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  5. New in firebird.log while test was run
  6. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15667404 kB
MemAvailable 30288120 kB
Buffers 0 kB
Cached 16093756 kB
SwapCached 2180 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


SERVER_MODE                     SuperServer 4.0.5
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-08 07:07:49
DTS_END                         2024-03-08 07:07:49.1520
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/40414
TRN_ID                          171109
ATT_ID                          553
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9215.97 17738 921597
customer order: creation 172.73 398 17273
customer order: refuse 14.93 362 1493
order to supplier: creation 44.87 1303 4487
order to supplier: removal 3.60 103072 360
invoice (draft): creation 46.03 3315 4603
invoice (draft): removal 51.60 731 5160
invoice accept: apply 41.59 21256 4159
invoice accept: cancel 47.10 851 4710
customer reserve: creation 3945.37 208 394537
customer reserve: removal 4553.10 66 455310
realization accept: apply 82.11 197 8211
realization accept: cancel 86.44 136 8644
payment from customer: creation 58.13 136 5813
payment from customer: removal 5.64 68 564
payment to supplier: creation 48.27 142 4827
payment to supplier: removal 3.39 111 339
service: total inventory turnovers 3.82 3750 382
service: total monetary turnovers 6.34 504 634
service: aggregate perf. data 0.88 13391 88
service: refresh index statistics 0.03 204758 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-03-2024 07:09:22 to 08-03-2024 07:09:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3132
TEST_TIME 2 3639
TEST_TIME 3 3575
TEST_TIME 4 3994
TEST_TIME 5 4614
TEST_TIME 6 5029
TEST_TIME 7 4847
TEST_TIME 8 5263
TEST_TIME 9 5235
TEST_TIME 10 5272
TEST_TIME 11 5259
TEST_TIME 12 5459
TEST_TIME 13 5624
TEST_TIME 14 5652
TEST_TIME 15 5613
TEST_TIME 16 5872
TEST_TIME 17 6119
TEST_TIME 18 6481
TEST_TIME 19 6932
TEST_TIME 20 7595
TEST_TIME 21 7877
TEST_TIME 22 8373
TEST_TIME 23 8755
TEST_TIME 24 9498
TEST_TIME 25 9596
TEST_TIME 26 9452
TEST_TIME 27 9313
TEST_TIME 28 9301
TEST_TIME 29 9547
TEST_TIME 30 9286
TEST_TIME 31 9044
TEST_TIME 32 9209
TEST_TIME 33 8967
TEST_TIME 34 9069
TEST_TIME 35 9125
TEST_TIME 36 9148
TEST_TIME 37 9040
TEST_TIME 38 9018
TEST_TIME 39 8995
TEST_TIME 40 8967
TEST_TIME 41 8801
TEST_TIME 42 8904
TEST_TIME 43 9066
TEST_TIME 44 9236
TEST_TIME 45 9300
TEST_TIME 46 9267
TEST_TIME 47 9376
TEST_TIME 48 9444
TEST_TIME 49 9359
TEST_TIME 50 9404
TEST_TIME 51 9668
TEST_TIME 52 9678
TEST_TIME 53 9744
TEST_TIME 54 9738
TEST_TIME 55 9649
TEST_TIME 56 9544
TEST_TIME 57 9478
TEST_TIME 58 9422
TEST_TIME 59 9430
TEST_TIME 60 9404
TEST_TIME 61 9338
TEST_TIME 62 9277
TEST_TIME 63 9234
TEST_TIME 64 9314
TEST_TIME 65 9288
TEST_TIME 66 9299
TEST_TIME 67 9315
TEST_TIME 68 9388
TEST_TIME 69 9381
TEST_TIME 70 9379
TEST_TIME 71 9400
TEST_TIME 72 9410
TEST_TIME 73 9515
TEST_TIME 74 9526
TEST_TIME 75 9503
TEST_TIME 76 9574
TEST_TIME 77 9458
TEST_TIME 78 9368
TEST_TIME 79 9359
TEST_TIME 80 9291
TEST_TIME 81 9276
TEST_TIME 82 9235
TEST_TIME 83 9216
TEST_TIME 84 9273
TEST_TIME 85 9254
TEST_TIME 86 9316
TEST_TIME 87 9360
TEST_TIME 88 9365
TEST_TIME 89 9389
TEST_TIME 90 9406
TEST_TIME 91 9462
TEST_TIME 92 9450
TEST_TIME 93 9477
TEST_TIME 94 9444
TEST_TIME 95 9459
TEST_TIME 96 9395
TEST_TIME 97 9345
TEST_TIME 98 9329
TEST_TIME 99 9271
TEST_TIME 100 9223

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-03-2024 07:09:26 to 08-03-2024 07:09:29.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1283621 1283621 0 0.00 0 20716 8 0 0
doc_list_biud 1283620 1283620 0 0.00 0 55295 29 0 0
sp_add_invoice_to_stock 4282 4159 123 2.87 45 210238 21257 0 123
sp_cancel_adding_invoice 4710 4710 0 0.00 5 75136 852 0 0
sp_cancel_client_order 1493 1493 0 0.00 4 10241 363 0 0
sp_cancel_customer_reserve 455310 455310 0 0.00 0 55296 66 0 0
sp_cancel_pay_from_customer 564 564 0 0.00 2 4176 68 0 0
sp_cancel_pay_to_supplier 339 339 0 0.00 2 10155 112 0 0
sp_cancel_supplier_invoice 5172 5160 12 0.23 2 17652 732 0 12
sp_cancel_supplier_order 360 360 0 0.00 6 1005487 103073 0 0
sp_cancel_write_off 8644 8644 0 0.00 1 16792 136 0 0
sp_client_order 17273 17273 0 0.00 3 54890 399 0 0
sp_customer_reserve 394537 394537 0 0.00 0 64892 208 0 0
sp_fill_shopping_cart 26347 26347 0 0.00 1 15533 35 0 0
sp_fill_shopping_cart_clo_res 394530 394530 0 0.00 0 17831 15 0 0
sp_get_clo_for_invoice 4152 4152 0 0.00 0 17715 306 0 0
sp_kill_cost_storno 14257 14257 0 0.00 0 12258 69 0 0
sp_kill_qstorno_ret_qs2qd 924784 924784 0 0.00 0 55291 35 0 0
sp_kill_qty_storno 488040 488040 0 0.00 0 55294 75 0 0
sp_lock_selected_doc 17173 17173 0 0.00 0 10293 5 0 0
sp_make_cost_storno 23003 23003 0 0.00 0 16514 71 0 0
sp_multiply_rows_for_pdistr 23003 23003 0 0.00 0 14401 35 0 0
sp_multiply_rows_for_qdistr 17273 17273 0 0.00 0 54882 218 0 0
sp_pay_from_customer 5813 5813 0 0.00 3 16805 136 0 0
sp_pay_to_supplier 4827 4827 0 0.00 4 13377 143 0 0
sp_payment_common 10640 10640 0 0.00 1 16797 31 0 0
sp_qd_handle_on_cancel_clo 1493 1493 0 0.00 0 10141 335 0 0
sp_qd_handle_on_invoice_upd_sts 8862 8862 0 0.00 0 23050 303 0 0
sp_qd_handle_on_reserve_upd_sts 8211 8211 0 0.00 0 19536 58 0 0
sp_reserve_write_off 8211 8211 0 0.00 6 20883 198 0 0
sp_supplier_invoice 4603 4603 0 0.00 5 103148 3316 0 0
sp_supplier_order 4487 4487 0 0.00 5 46825 1304 0 0
srv_aggregate_perf_data 88 88 0 0.00 1387 147698 13392 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 2701 139791 42084 0 0
srv_find_qd_qs_mism 880069 880069 0 0.00 0 20694 7 0 0
srv_make_invnt_saldo 382 382 0 0.00 64 97878 3751 0 0
srv_make_money_saldo 634 634 0 0.00 1 17059 505 0 0
srv_recalc_idx_stat 3 3 0 0.00 92434 350482 204758 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4160 4160 0 0.00 0 15217 187 0 0
t$perf-norm:sp_cancel_adding_invoice 364 364 0 0.00 0 4284 79 0 0
t$perf-norm:sp_cancel_client_order 1493 1493 0 0.00 0 5237 16 0 0
t$perf-norm:sp_cancel_customer_reserve 537 537 0 0.00 0 16380 47 0 0
t$perf-norm:sp_cancel_pay_from_customer 564 564 0 0.00 0 4264 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 339 339 0 0.00 0 487 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 339 339 0 0.00 0 531 11 0 0
t$perf-norm:sp_cancel_supplier_order 360 360 0 0.00 0 20387 1556 0 0
t$perf-norm:sp_cancel_write_off 814 814 0 0.00 0 5074 13 0 0
t$perf-norm:sp_client_order 17273 17273 0 0.00 0 16521 17 0 0
t$perf-norm:sp_customer_reserve 860 860 0 0.00 0 2310 5 0 0
t$perf-norm:sp_pay_from_customer 5813 5813 0 0.00 0 10099 9 0 0
t$perf-norm:sp_pay_to_supplier 4827 4827 0 0.00 0 2776 7 0 0
t$perf-norm:sp_reserve_write_off 8211 8211 0 0.00 0 10110 11 0 0
t$perf-norm:sp_supplier_invoice 4603 4603 0 0.00 0 4740 17 0 0
t$perf-norm:sp_supplier_order 4487 4487 0 0.00 0 5771 13 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 741 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 22 1 0 0
t$perf-norm:srv_make_invnt_saldo 382 382 0 0.00 0 2203 16 0 0
t$perf-norm:srv_make_money_saldo 634 634 0 0.00 0 2216 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 306 105 0 0
v_add_invoice_to_stock 8550 8304 246 2.87 0 3768 15 0 246
v_all_customers 31856 31856 0 0.00 0 25 1 0 0
v_all_suppliers 25658 25658 0 0.00 0 25 1 0 0
v_all_wares 34546 34546 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 728 728 0 0.00 0 2114 13 0 0
v_cancel_client_order 2986 2986 0 0.00 0 2268 4 0 0
v_cancel_customer_prepayment 1128 1128 0 0.00 0 497 3 0 0
v_cancel_customer_reserve 1074 1074 0 0.00 0 5375 9 0 0
v_cancel_payment_to_supplier 678 678 0 0.00 0 2831 8 0 0
v_cancel_supplier_invoice 702 678 24 3.41 0 827 13 0 24
v_cancel_supplier_order 720 720 0 0.00 0 288 3 0 0
v_cancel_write_off 1628 1628 0 0.00 0 5196 17 0 0
v_max_id_clo_ord 4484 4484 0 0.00 0 2510 2 0 0
v_max_id_clo_res 860 860 0 0.00 0 6262 19 0 0
v_max_id_ord_sup 4590 4590 0 0.00 0 6072 8 0 0
v_max_non_paid_invoice 1072 1072 0 0.00 0 776 3 0 0
v_max_non_paid_realizn 2872 2872 0 0.00 0 4145 4 0 0
v_min_id_clo_ord 4484 4484 0 0.00 0 4888 9 0 0
v_min_id_clo_res 860 860 0 0.00 0 5620 28 0 0
v_min_id_ord_sup 4590 4590 0 0.00 0 6034 6 0 0
v_min_non_paid_invoice 4827 4827 0 0.00 0 9267 20 0 0
v_min_non_paid_realizn 5813 5813 0 0.00 0 10239 26 0 0
v_our_firm 8572 8572 0 0.00 0 16 1 0 0
v_reserve_write_off 16422 16422 0 0.00 0 5377 7 0 0
x_lock_depdocs_on_canc_invoice 9531 9531 0 0.00 0 24167 131 0 0
x_lock_depdocs_on_canc_sup_ord 360 360 0 0.00 0 8318 329 0 0
x_make_qstorno_1000_1200 4487 4487 0 0.00 2 46812 1224 0 0
x_make_qstorno_1200_2000 4603 4603 0 0.00 2 103141 3195 0 0
x_make_qstorno_2100_3300 394537 394537 0 0.00 0 64889 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2024 07:09:30 to 08-03-2024 07:09:34.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:07:53 5 8192000000 8804659504 8817995776 9514096 0.116 3 3 4 0 9709248 108208 86944
05:08:53 34809 8192000000 9727654208 10028101632 807967216 8.977 100 87 174 0 836018576 7366720 20684640
05:10:36 21608 8192000000 9773035008 10084061184 842810288 9.328 100 90 180 0 876151008 12509760 20830960
05:12:01 16539 8192000000 9801674992 10121748480 869056976 9.591 100 83 166 0 908112304 19861760 19193568
05:13:33 10160 8192000000 9864586736 10198376448 910080272 9.998 100 82 164 0 982885408 54591248 18213888
05:14:47 8110 8192000000 9903482352 10249646080 940839328 10.301 100 77 152 0 1016310704 59512272 15959104
05:15:58 3540 8192000000 9958514800 10313224192 987196720 10.754 100 76 150 0 1071833216 69445104 15191392
05:17:03 2621 8192000000 9971536080 10335985664 1011437904 10.989 100 78 154 0 1085000176 58077616 15484656
05:18:07 2887 8192000000 10024006368 10396434432 1029955056 11.168 100 77 152 0 1136681504 91608992 15117456
05:19:11 1625 8192000000 10028654192 10407333888 1054528224 11.404 100 75 150 0 1148325472 78758096 15039152
05:20:15 16829 8192000000 9961375408 10356518912 1059741856 11.454 100 34 67 0 1092312752 24640496 7930400
05:21:35 4720 8192000000 9993238560 10400387072 1066294304 11.517 100 29 57 0 1118304688 46270464 5739920
05:22:41 6049 8192000000 9985490080 10382958592 1074029104 11.591 100 37 72 0 1103343344 21923536 7390704
05:23:50 62217 8192000000 10001243120 10415063040 1083433584 11.680 100 22 44 1 1108837696 20795248 4608864
05:25:54 6370 8192000000 10015804656 10416168960 1086916032 11.713 100 48 98 0 1137786688 41178736 9691920
05:27:01 8978 8192000000 10011168144 10428973056 1094913344 11.789 100 37 73 0 1114765776 12254672 7597760
05:28:12 16709 8192000000 10004582512 10405638144 1087731056 11.721 100 34 64 1 1113111328 18917488 6462784
05:29:33 51150 8192000000 10058201328 10456141824 1067554784 11.529 97 52 103 1 1142153856 63844192 10754880
05:32:14 17313 8192000000 10057776272 10457939968 1084403808 11.689 98 45 91 0 1159293424 65364960 9524656
05:33:39 9831 8192000000 10064885024 10461417472 1079669424 11.644 99 47 94 1 1158908656 69183920 10055312
05:34:55 12493 8192000000 10087781168 10485018624 1087290448 11.717 100 46 89 0 1197318320 100596688 9431184
05:36:12 16973 8192000000 10099078192 10504445952 1078870192 11.637 98 41 81 2 1198692256 110523968 9298096
05:37:36 10873 8192000000 10114673856 10517766144 1099067632 11.829 100 53 106 0 1217595296 107015520 11512144
05:38:53 11706 8192000000 10147484720 10544869376 1091957408 11.761 99 54 107 0 1249999216 145861456 12180352
05:40:09 2701 8192000000 10185396576 10576904192 1090330720 11.746 99 63 121 1 1293461104 188570512 14559872
05:41:15 13573 8192000000 10232091264 10630381568 1114191968 11.972 100 42 83 0 1341344592 216920560 10232064
05:42:36 4800 8192000000 10296302672 10686627840 1118754848 12.015 100 63 124 0 1392683440 258857664 15070928
05:43:45 2898 8192000000 10321582192 10710077440 1118520832 12.013 99 77 154 0 1417976272 281687248 17768192
05:44:53 2761 8192000000 10352881648 10754330624 1121959616 12.046 100 75 149 0 1451551456 311851312 17740528
05:46:03 2986 8192000000 10360874480 10764312576 1131122096 12.132 100 91 182 1 1460312944 308485472 20705376
05:47:09 4580 8192000000 10326886016 10745384960 1131794272 12.138 100 53 106 0 1421099920 276736832 12568816
05:48:18 13712 8192000000 10274224640 10727944192 1120315200 12.030 100 60 119 0 1382042880 247853744 13873936
05:49:55 13483 8192000000 10233441168 10718396416 1128648160 12.109 100 27 54 0 1357933440 223080624 6204656
05:51:58 88853 8192000000 10054884240 10541654016 1116913776 11.998 99 9 18 0 1200131872 81205824 2012272
05:54:29 24132 8192000000 10111653680 10546040832 1131822080 12.139 100 18 36 0 1203788096 68148144 3817872
05:56:08 29774 8192000000 10046867824 10485624832 1107898608 11.913 98 19 38 0 1157935424 45671984 4364832
05:57:39 93519 8192000000 10106900912 10552688640 1121340192 12.040 99 32 64 0 1185815344 57650272 6824880
06:00:17 33438 8192000000 10091000112 10517872640 1136130400 12.179 100 45 87 1 1186332832 41155536 9046896
06:01:54 52397 8192000000 10112288880 10554413056 1144135984 12.254 100 48 94 0 1205655696 51167904 10351808
06:03:48 47903 8192000000 10132611744 10577498112 1151573232 12.324 100 20 39 0 1210857632 55219248 4065152
06:05:40 30063 8192000000 10133066656 10603065344 1154220240 12.349 100 24 46 0 1266290896 106543344 5527312
06:07:13 61005 8192000000 10198717520 10654183424 1171289872 12.509 100 20 41 0 1275233488 99248176 4695440
06:09:15 56943 8192000000 10198316192 10646327296 1159420544 12.398 100 24 48 0 1302049328 136964880 5663904
06:11:13 24928 8192000000 10066897168 10513936384 1113408912 11.965 97 21 42 0 1161912128 44493008 4010208
06:12:42 44099 8192000000 10088799904 10518646784 1111939968 11.951 98 33 62 1 1162957328 44486992 6530368
06:14:31 31966 8192000000 10090696880 10518401024 1071458944 11.566 94 31 62 1 1119926224 42555440 5911840
06:16:03 20400 8192000000 10071859312 10503790592 1111555856 11.947 99 55 109 2 1163269392 39873952 11839584
06:17:30 40606 8192000000 10148599296 10628005888 1116460736 11.994 100 25 50 0 1273819184 152094656 5263792
06:19:13 89491 8192000000 10083149424 10559971328 1086644608 11.711 97 12 24 0 1136880864 47868128 2368128
06:21:47 106968 8192000000 10042965824 10473803776 1077392560 11.623 97 28 56 0 1147280688 63887888 6000240
06:24:40 36294 8192000000 10063889152 10491965440 1109132896 11.924 99 35 70 0 1155481504 39444624 6903984
06:26:16 50580 8192000000 10081699872 10542891008 1082872864 11.675 97 32 62 0 1173342384 84354480 6115040
06:28:08 47156 8192000000 10083227520 10565738496 1104814352 11.883 99 10 20 0 1179737504 72825216 2097936
06:29:57 38384 8192000000 10079038688 10543988736 1109327936 11.926 100 25 50 1 1179553888 64448528 5777424
06:32:28 33981 8192000000 10040771552 10476003328 1078265824 11.631 97 24 48 0 1121982912 38568608 5148480
06:34:07 40120 8192000000 10037183360 10491355136 1070781520 11.560 96 22 42 1 1138668224 62764224 5122480
06:35:48 39005 8192000000 10056468944 10489253888 1113084960 11.962 100 21 43 0 1163373280 45822208 4466112
06:37:39 31810 8192000000 10092432512 10522824704 1105716240 11.892 98 41 80 1 1162357056 49010400 7630416
06:39:11 11501 8192000000 10142281968 10565431296 1131021568 12.131 100 50 100 0 1219146208 77856976 10267664
06:40:25 120681 8192000000 10107892640 10547617792 1102575456 11.862 97 20 40 0 1152983136 45760992 4646688
06:43:27 139790 8192000000 10055731392 10498154496 1126541424 12.089 99 14 28 0 1179790992 50447904 2801664
06:46:53 86437 8192000000 10116904624 10573205504 1141897472 12.233 100 10 20 0 1186134608 42128704 2108432
06:50:47 81155 8192000000 10097571472 10592137216 1116032144 11.989 97 11 22 1 1179263040 60795712 2435184
06:53:11 56658 8192000000 10096548864 10553597952 1146666336 12.278 100 16 32 0 1208565680 58301360 3597984
06:55:10 92374 8192000000 10095386112 10545606656 1117522208 12.004 97 16 32 0 1172321248 51606944 3192096
06:57:44 79003 8192000000 10073097664 10564382720 1131213872 12.133 99 14 28 0 1178613488 44715296 2684320
07:00:05 46251 8192000000 10082718912 10557091840 1099279600 11.831 96 26 52 0 1160379344 55445728 5654016
07:02:08 15043 8192000000 10140292272 10567073792 1133355520 12.153 100 48 96 0 1215952480 72826656 9770304
07:03:30 78735 8192000000 10068080240 10499289088 1102279696 11.859 98 30 60 0 1176196304 67839312 6077296
07:05:49 62531 8192000000 10050105088 10520793088 1119215136 12.020 100 12 24 0 1164845552 43179856 2450560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 08-03-2024 07:09:36 to 08-03-2024 07:09:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 123 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-03-2024 07:09:50 to 08-03-2024 07:09:52.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          171398
MON$OLDEST_ACTIVE               171399
MON$OLDEST_SNAPSHOT             171399
MON$NEXT_TRANSACTION            171399
MON$PAGE_BUFFERS                1000000
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               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1922528
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             691
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3062 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3062 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3062 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3062 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Mar  8 07:09:53 2024 
 
Database header page information: 
    Flags            0 
    Generation        89371 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171398 
    Oldest active        171399 
    Oldest snapshot        171399 
    Next transaction    171400 
    Sequence number        0 
    Next attachment ID    691 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.64, total records: 7674985 
    Average version length: 48.16, total versions: 50360, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88504 
    Data pages: 88504, average fill: 69% 
    Primary pages: 88503, secondary pages: 1, swept pages: 46849 
    Empty pages: 1, full pages: 60313 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 41 
    40 - 59% = 2077 
    60 - 79% = 86347 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23216, nodes: 7674985 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1663679, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 361 
        20 - 39% = 2090 
        40 - 59% = 3841 
        60 - 79% = 2633 
        80 - 99% = 14291 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13455, nodes: 7674985 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1487402, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1702 
        40 - 59% = 1865 
        60 - 79% = 1276 
        80 - 99% = 8611 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8297, nodes: 7674985 
    Average node length: 6.60, total dup: 5764615, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1480477, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 1086 
        40 - 59% = 1247 
        60 - 79% = 1082 
        80 - 99% = 4775 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.86, total records: 2202032 
    Average version length: 58.86, total versions: 25588, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28528 
    Data pages: 28528, average fill: 71% 
    Primary pages: 28527, secondary pages: 1, swept pages: 14985 
    Empty pages: 1, full pages: 15232 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 80 
    40 - 59% = 883 
    60 - 79% = 27521 
    80 - 99% = 33 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4520, nodes: 2202032 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677042, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 970 
        40 - 59% = 778 
        60 - 79% = 824 
        80 - 99% = 1948 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2407, nodes: 2202976 
    Average node length: 4.97, total dup: 2202077, max dup: 17882 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1247687, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 228 
        40 - 59% = 1408 
        60 - 79% = 547 
        80 - 99% = 220 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1764, nodes: 2202032 
    Average node length: 4.97, total dup: 2201982, max dup: 130165 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053904, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 612 
        60 - 79% = 53 
        80 - 99% = 1090 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4338, nodes: 2202032 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677042, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 636 
        40 - 59% = 604 
        60 - 79% = 929 
        80 - 99% = 2069 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.33, total records: 400 
    Average version length: 23.62, total versions: 1728, max versions: 5 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 57% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 6, full pages: 13 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 23.36, total records: 133891 
    Average version length: 68.29, total versions: 101448, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.77 
    Pointer pages: 6, data page slots: 3472 
    Data pages: 2296, average fill: 75% 
    Primary pages: 2295, secondary pages: 1, swept pages: 10 
    Empty pages: 226, full pages: 1827 
    Fill distribution: 
     0 - 19% = 252 
    20 - 39% = 66 
    40 - 59% = 65 
    60 - 79% = 468 
    80 - 99% = 1445 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1711372, depth: 3, leaf buckets: 385, nodes: 133891 
    Average node length: 13.13, total dup: 8671, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 101626, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 285 
        60 - 79% = 83 
        80 - 99% = 14 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 158, max versions: 8 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 38% 
    Primary pages: 1, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 17.19, total records: 2225 
    Average version length: 43.57, total versions: 1699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 48 
    Data pages: 32, average fill: 70% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 3, full pages: 24 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92073, depth: 2, leaf buckets: 2, nodes: 2225 
    Average node length: 4.14, total dup: 2127, max dup: 238 
    Average key length: 2.47, compression ratio: 7.70 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1151, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.67, total records: 70 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.57, total records: 832298 
    Average version length: 37.93, total versions: 27156, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8824 
    Data pages: 8824, average fill: 65% 
    Primary pages: 8823, secondary pages: 1, swept pages: 3167 
    Empty pages: 19, full pages: 5351 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 68 
    40 - 59% = 659 
    60 - 79% = 7994 
    80 - 99% = 67 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 896, nodes: 821757 
    Average node length: 4.88, total dup: 821708, max dup: 155166 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91367, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 135 
        40 - 59% = 508 
        60 - 79% = 154 
        80 - 99% = 99 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 965, nodes: 821757 
    Average node length: 5.89, total dup: 731653, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163448, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 30 
        40 - 59% = 568 
        60 - 79% = 80 
        80 - 99% = 285 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 987, nodes: 821757 
    Average node length: 5.89, total dup: 731653, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165282, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 80 
        40 - 59% = 553 
        60 - 79% = 76 
        80 - 99% = 277 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1142, nodes: 821757 
    Average node length: 5.97, total dup: 731653, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157681, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 210 
        40 - 59% = 603 
        60 - 79% = 233 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5451 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.95, total fragments: 20, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 85, average fill: 63% 
    Primary pages: 77, secondary pages: 8, swept pages: 55 
    Empty pages: 5, full pages: 64 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5451 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.07 
    Average prefix length: 34.42, average data length: 1.54 
    Clustering factor: 5143, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5451 
    Average node length: 11.16, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 78212 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 812 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 813 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38848, depth: 2, leaf buckets: 99, nodes: 78212 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2974, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.58, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 129.63, total records: 203770 
    Average version length: 154.09, total versions: 30849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.08 
    Pointer pages: 6, data page slots: 6192 
    Data pages: 5128, average fill: 84% 
    Primary pages: 5126, secondary pages: 2, swept pages: 4 
    Empty pages: 94, full pages: 4998 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 13 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 5001 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 143.06, total records: 156221 
    Average version length: 151.57, total versions: 8601, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.86 
    Pointer pages: 5, data page slots: 4592 
    Data pages: 3888, average fill: 83% 
    Primary pages: 3886, secondary pages: 2, swept pages: 3 
    Empty pages: 46, full pages: 3823 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3823 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 143.86, total records: 182147 
    Average version length: 150.30, total versions: 9342, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.79 
    Pointer pages: 9, data page slots: 5352 
    Data pages: 4560, average fill: 83% 
    Primary pages: 4557, secondary pages: 3, swept pages: 5 
    Empty pages: 74, full pages: 4461 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4461 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 146.05, total records: 173664 
    Average version length: 151.60, total versions: 6179, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 7, data page slots: 5248 
    Data pages: 4320, average fill: 83% 
    Primary pages: 4318, secondary pages: 2, swept pages: 12 
    Empty pages: 47, full pages: 4257 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4257 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 143.72, total records: 166218 
    Average version length: 152.05, total versions: 8172, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.80 
    Pointer pages: 6, data page slots: 5632 
    Data pages: 4176, average fill: 82% 
    Primary pages: 4174, secondary pages: 2, swept pages: 6 
    Empty pages: 89, full pages: 4059 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 8 
    80 - 99% = 4058 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 137.65, total records: 190077 
    Average version length: 153.40, total versions: 17951, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.32 
    Pointer pages: 8, data page slots: 6496 
    Data pages: 4792, average fill: 83% 
    Primary pages: 4790, secondary pages: 2, swept pages: 4 
    Empty pages: 109, full pages: 4654 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 14 
    80 - 99% = 4653 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 145.14, total records: 158754 
    Average version length: 152.52, total versions: 6276, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 3952, average fill: 83% 
    Primary pages: 3949, secondary pages: 3, swept pages: 22 
    Empty pages: 50, full pages: 3881 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 6 
    40 - 59% = 11 
    60 - 79% = 3 
    80 - 99% = 3881 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 140.93, total records: 179265 
    Average version length: 151.94, total versions: 12843, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 6, data page slots: 7088 
    Data pages: 4512, average fill: 83% 
    Primary pages: 4510, secondary pages: 2, swept pages: 16 
    Empty pages: 93, full pages: 4392 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4393 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 137.14, total records: 176181 
    Average version length: 152.89, total versions: 17116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.37 
    Pointer pages: 7, data page slots: 4960 
    Data pages: 4400, average fill: 84% 
    Primary pages: 4398, secondary pages: 2, swept pages: 1 
    Empty pages: 64, full pages: 4318 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 4318 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 134.55, total records: 184542 
    Average version length: 153.51, total versions: 21539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.61 
    Pointer pages: 7, data page slots: 5632 
    Data pages: 4656, average fill: 83% 
    Primary pages: 4655, secondary pages: 1, swept pages: 4 
    Empty pages: 103, full pages: 4521 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 7 
    40 - 59% = 10 
    60 - 79% = 13 
    80 - 99% = 4521 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.35, total records: 2052195 
    Average version length: 52.87, total versions: 18643, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25600 
    Data pages: 25584, average fill: 69% 
    Primary pages: 25569, secondary pages: 15, swept pages: 13314 
    Empty pages: 176, full pages: 20177 
    Fill distribution: 
     0 - 19% = 374 
    20 - 39% = 402 
    40 - 59% = 1271 
    60 - 79% = 23387 
    80 - 99% = 150 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2558, nodes: 2052195 
    Average node length: 5.45, total dup: 1913588, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179350, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 344 
        40 - 59% = 1628 
        60 - 79% = 303 
        80 - 99% = 277 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2760, nodes: 2052195 
    Average node length: 5.70, total dup: 1840806, max dup: 73 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 368279, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2526 
        60 - 79% = 200 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2055, nodes: 2052195 
    Average node length: 4.96, total dup: 2052095, max dup: 27873 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177183, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 207 
        40 - 59% = 1023 
        60 - 79% = 378 
        80 - 99% = 446 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 44.73, total records: 149120 
    Average version length: 69.16, total versions: 60650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.82 
    Pointer pages: 3, data page slots: 3880 
    Data pages: 3080, average fill: 58% 
    Primary pages: 3080, secondary pages: 0, swept pages: 325 
    Empty pages: 373, full pages: 1370 
    Fill distribution: 
     0 - 19% = 473 
    20 - 39% = 179 
    40 - 59% = 548 
    60 - 79% = 1138 
    80 - 99% = 742 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555245, depth: 3, leaf buckets: 240, nodes: 149120 
    Average node length: 6.49, total dup: 129834, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26126, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 53 
        40 - 59% = 124 
        60 - 79% = 56 
        80 - 99% = 5 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.51, total records: 7200348 
    Average version length: 68.71, total versions: 294157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 67, data page slots: 109224 
    Data pages: 109224, average fill: 71% 
    Primary pages: 109223, secondary pages: 1, swept pages: 41426 
    Empty pages: 12, full pages: 58936 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 496 
    40 - 59% = 7580 
    60 - 79% = 100045 
    80 - 99% = 1035 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10823, nodes: 7200348 
    Average node length: 6.51, total dup: 6227777, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1692520, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 1395 
        40 - 59% = 6197 
        60 - 79% = 2742 
        80 - 99% = 471 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8634, nodes: 7200348 
    Average node length: 5.39, total dup: 6916895, max dup: 178 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1491113, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1091 
        40 - 59% = 4917 
        60 - 79% = 1517 
        80 - 99% = 1099 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8696, nodes: 7200348 
    Average node length: 5.39, total dup: 6916895, max dup: 178 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1493366, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1129 
        40 - 59% = 4915 
        60 - 79% = 1557 
        80 - 99% = 1080 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 12136921 
    Average version length: 68.68, total versions: 221706, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 109, data page slots: 176840 
    Data pages: 176840, average fill: 73% 
    Primary pages: 176839, secondary pages: 1, swept pages: 85996 
    Empty pages: 9, full pages: 140536 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 422 
    40 - 59% = 5314 
    60 - 79% = 169826 
    80 - 99% = 1242 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18421, nodes: 12135932 
    Average node length: 6.62, total dup: 10579940, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2480633, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2072 
        40 - 59% = 10695 
        60 - 79% = 4815 
        80 - 99% = 806 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 53.47, total records: 1362937 
    Average version length: 69.09, total versions: 238668, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.36 
    Pointer pages: 26, data page slots: 40696 
    Data pages: 29624, average fill: 49% 
    Primary pages: 29528, secondary pages: 96, swept pages: 13003 
    Empty pages: 4148, full pages: 13623 
    Fill distribution: 
     0 - 19% = 7162 
    20 - 39% = 4223 
    40 - 59% = 3293 
    60 - 79% = 12068 
    80 - 99% = 2878 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1870, nodes: 1246408 
    Average node length: 5.53, total dup: 1195764, max dup: 49 
    Average key length: 2.58, compression ratio: 16.29 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 88739, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 689 
        40 - 59% = 869 
        60 - 79% = 287 
        80 - 99% = 19 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 43.24, total records: 1154142 
    Average version length: 69.07, total versions: 171196, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.91 
    Pointer pages: 21, data page slots: 32672 
    Data pages: 27264, average fill: 40% 
    Primary pages: 27263, secondary pages: 1, swept pages: 7133 
    Empty pages: 4146, full pages: 5475 
    Fill distribution: 
     0 - 19% = 6746 
    20 - 39% = 5186 
    40 - 59% = 8578 
    60 - 79% = 6599 
    80 - 99% = 155 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1251, nodes: 829704 
    Average node length: 5.93, total dup: 764670, max dup: 64 
    Average key length: 3.00, compression ratio: 14.00 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 124583, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 364 
        40 - 59% = 598 
        60 - 79% = 267 
        80 - 99% = 21 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.04, total records: 8825852 
    Average version length: 68.99, total versions: 269135, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 88, data page slots: 143224 
    Data pages: 143200, average fill: 66% 
    Primary pages: 143183, secondary pages: 17, swept pages: 72905 
    Empty pages: 415, full pages: 57470 
    Fill distribution: 
     0 - 19% = 1496 
    20 - 39% = 7181 
    40 - 59% = 21818 
    60 - 79% = 111515 
    80 - 99% = 1190 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13454, nodes: 8821463 
    Average node length: 6.68, total dup: 7314718, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2011740, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1669 
        40 - 59% = 7325 
        60 - 79% = 4103 
        80 - 99% = 352 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21125430 
    Average version length: 83.07, total versions: 4884, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319472 
    Data pages: 319472, average fill: 81% 
    Primary pages: 319468, secondary pages: 4, swept pages: 13482 
    Empty pages: 43, full pages: 318573 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 40 
    40 - 59% = 97 
    60 - 79% = 49079 
    80 - 99% = 270183 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19292, nodes: 21125430 
    Average node length: 5.72, total dup: 20644959, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279642, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8008 
        60 - 79% = 518 
        80 - 99% = 10760 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17149, nodes: 21125430 
    Average node length: 6.31, total dup: 18565856, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915854, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 763 
        60 - 79% = 277 
        80 - 99% = 16106 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21094, nodes: 21125430 
    Average node length: 6.35, total dup: 18484012, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573206, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8324 
        60 - 79% = 561 
        80 - 99% = 12203 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16097, nodes: 21125430 
    Average node length: 5.56, total dup: 21125330, max dup: 230052 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944708, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 17 
        40 - 59% = 2922 
        60 - 79% = 348 
        80 - 99% = 12807 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.77, total records: 9208292 
    Average version length: 82.69, total versions: 205656, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 105, data page slots: 170592 
    Data pages: 170568, average fill: 67% 
    Primary pages: 170542, secondary pages: 26, swept pages: 105002 
    Empty pages: 669, full pages: 83060 
    Fill distribution: 
     0 - 19% = 2522 
    20 - 39% = 11467 
    40 - 59% = 28308 
    60 - 79% = 112984 
    80 - 99% = 15287 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11336, nodes: 9208292 
    Average node length: 5.36, total dup: 8904257, max dup: 168 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2109014, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 121 
        40 - 59% = 9433 
        60 - 79% = 1757 
        80 - 99% = 23 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13130, nodes: 9208292 
    Average node length: 6.23, total dup: 7631537, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1480510, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 3965 
        40 - 59% = 4263 
        60 - 79% = 2713 
        80 - 99% = 2049 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12646, nodes: 9208292 
    Average node length: 5.98, total dup: 7976932, max dup: 38 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2284348, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 160 
        40 - 59% = 10440 
        60 - 79% = 1993 
        80 - 99% = 50 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9762, nodes: 9208292 
    Average node length: 5.12, total dup: 9208192, max dup: 150003 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1499353, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1281 
        40 - 59% = 4854 
        60 - 79% = 1725 
        80 - 99% = 1856 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.27, total records: 10934321 
    Average version length: 82.66, total versions: 152265, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 119, data page slots: 193472 
    Data pages: 191600, average fill: 70% 
    Primary pages: 191456, secondary pages: 144, swept pages: 81294 
    Empty pages: 3875, full pages: 135505 
    Fill distribution: 
     0 - 19% = 6465 
    20 - 39% = 9070 
    40 - 59% = 20743 
    60 - 79% = 99147 
    80 - 99% = 56175 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13127, nodes: 10934321 
    Average node length: 5.30, total dup: 10825163, max dup: 668 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2286542, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 251 
        40 - 59% = 9945 
        60 - 79% = 2827 
        80 - 99% = 101 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10246, nodes: 10934321 
    Average node length: 5.50, total dup: 10455370, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 697323, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 868 
        40 - 59% = 2614 
        60 - 79% = 1843 
        80 - 99% = 4745 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15009, nodes: 10934321 
    Average node length: 6.03, total dup: 9530815, max dup: 64 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2302763, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 292 
        40 - 59% = 11509 
        60 - 79% = 3076 
        80 - 99% = 129 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10534, nodes: 10934321 
    Average node length: 5.22, total dup: 10934221, max dup: 195410 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 686645, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 886 
        40 - 59% = 4706 
        60 - 79% = 1436 
        80 - 99% = 3381 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.21, total records: 9308613 
    Average version length: 82.94, total versions: 192805, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 108, data page slots: 175312 
    Data pages: 175264, average fill: 66% 
    Primary pages: 175239, secondary pages: 25, swept pages: 108522 
    Empty pages: 789, full pages: 82849 
    Fill distribution: 
     0 - 19% = 2982 
    20 - 39% = 13834 
    40 - 59% = 30900 
    60 - 79% = 112882 
    80 - 99% = 14666 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11405, nodes: 9308613 
    Average node length: 5.17, total dup: 9280557, max dup: 1542 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1894260, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1599 
        40 - 59% = 7558 
        60 - 79% = 1693 
        80 - 99% = 525 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13214, nodes: 9308613 
    Average node length: 6.24, total dup: 7714843, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1436970, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 3865 
        40 - 59% = 4300 
        60 - 79% = 2732 
        80 - 99% = 2144 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12079, nodes: 9308613 
    Average node length: 5.43, total dup: 8887090, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2023932, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1622 
        40 - 59% = 8411 
        60 - 79% = 1533 
        80 - 99% = 487 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9881, nodes: 9308613 
    Average node length: 5.14, total dup: 9308513, max dup: 152155 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1512990, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1373 
        40 - 59% = 4859 
        60 - 79% = 1647 
        80 - 99% = 1967 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.82, total records: 566740 
    Average version length: 68.75, total versions: 3260, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8032 
    Data pages: 8032, average fill: 74% 
    Primary pages: 8031, secondary pages: 1, swept pages: 4372 
    Empty pages: 7, full pages: 6178 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 8 
    40 - 59% = 200 
    60 - 79% = 7787 
    80 - 99% = 28 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39780, depth: 3, leaf buckets: 739, nodes: 566740 
    Average node length: 5.95, total dup: 482356, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99880, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 550 
        60 - 79% = 73 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 27351, depth: 3, leaf buckets: 752, nodes: 566740 
    Average node length: 6.15, total dup: 464652, max dup: 15 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99926, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 33 
        40 - 59% = 545 
        60 - 79% = 71 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 557, nodes: 566740 
    Average node length: 4.85, total dup: 566640, max dup: 9767 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88899, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 42 
        40 - 59% = 315 
        60 - 79% = 62 
        80 - 99% = 137 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar  8 07:10:17 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7674985 50360 1 0.0000 0.0000
DOC_LIST 2202032 25588 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1728 5 400.0000 0.0000
INVNT_TURNOVER_LOG 133891 101448 1 0.0000 0.0000
MONEY_SALDO 49 158 8 300.0000 0.0000
MONEY_TURNOVER_LOG 2225 1699 1 0.0000 0.0000
PDISTR 832298 27156 2 0.0000 0.0000
PERF_SPLIT_0 203770 30849 1 0.0000 0.0000
PERF_SPLIT_1 156221 8601 1 0.0000 0.0000
PERF_SPLIT_2 182147 9342 1 0.0000 0.0000
PERF_SPLIT_3 173664 6179 1 0.0000 0.0000
PERF_SPLIT_4 166218 8172 1 0.0000 0.0000
PERF_SPLIT_5 190077 17951 1 0.0000 0.0000
PERF_SPLIT_6 158754 6276 1 0.0000 0.0000
PERF_SPLIT_7 179265 12843 1 0.0000 0.0000
PERF_SPLIT_8 176181 17116 1 0.0000 0.0000
PERF_SPLIT_9 184542 21539 1 0.0000 0.0000
PSTORNED 2052195 18643 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 149120 60650 1 0.0000 0.0000
XQD_1000_3300 7200348 294157 1 0.0000 0.0000
XQD_1200_2000 12136921 221706 1 0.0000 0.0000
XQD_2000_3300 1362937 238668 1 0.0000 0.0000
XQD_2100_3300 1154142 171196 1 0.0000 0.0000
XQD_3300_3400 8825852 269135 1 0.0000 0.0000
XQS_1000_1200 21125430 4884 1 0.0000 0.0000
XQS_1000_3300 9208292 205656 1 0.0000 0.0000
XQS_1200_2000 10934321 152265 1 0.0000 0.0000
XQS_2100_3300 9308613 192805 1 0.0000 0.0000
XQS_3300_3400 566740 3260 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

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

--- start of diff output ---
--- end of diff output ---

 Final processing ISQL logs in /var/tmp/logs-oltp40 according to config parameter 'remove_isql_logs'  

08.03.24 07:10:29. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
            0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
    335544321 'string truncation'. Attempt to assign too long text into string variable.
    335544347 'not_valid'. Validation error for column.
    335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
    335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
    335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
    335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
    335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2024-03-08 07:10:31 No severe PSQL-related problems occured
08.03.24 07:10:32. End of report.