Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.03.2024 04:09
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 15757184 kB
MemAvailable 30262816 kB
Buffers 20 kB
Cached 15950120 kB
SwapCached 2348 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-01 04:07:49
DTS_END                         2024-03-01 04:07:49.0960
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/54798
TRN_ID                          167495
ATT_ID                          525
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: 9130.91 21771 913091
customer order: creation 169.82 380 16982
customer order: refuse 13.83 357 1383
order to supplier: creation 44.91 1259 4491
order to supplier: removal 3.81 101684 381
invoice (draft): creation 46.43 2893 4643
invoice (draft): removal 51.30 706 5130
invoice accept: apply 41.51 22652 4151
invoice accept: cancel 46.38 809 4638
customer reserve: creation 3970.44 220 397044
customer reserve: removal 4451.13 71 445113
realization accept: apply 83.24 218 8324
realization accept: cancel 80.99 138 8099
payment from customer: creation 57.71 114 5771
payment from customer: removal 5.58 68 558
payment to supplier: creation 49.31 137 4931
payment to supplier: removal 3.49 99 349
service: total inventory turnovers 3.84 4059 384
service: total monetary turnovers 6.18 572 618
service: aggregate perf. data 0.97 12881 97
service: refresh index statistics 0.04 286099 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-03-2024 04:09:54 to 01-03-2024 04:09:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5904
TEST_TIME 2 5044
TEST_TIME 3 5529
TEST_TIME 4 5487
TEST_TIME 5 5449
TEST_TIME 6 5401
TEST_TIME 7 5788
TEST_TIME 8 5778
TEST_TIME 9 5861
TEST_TIME 10 5855
TEST_TIME 11 5762
TEST_TIME 12 5804
TEST_TIME 13 5857
TEST_TIME 14 5922
TEST_TIME 15 6015
TEST_TIME 16 6115
TEST_TIME 17 6738
TEST_TIME 18 6994
TEST_TIME 19 7137
TEST_TIME 20 7364
TEST_TIME 21 7553
TEST_TIME 22 7540
TEST_TIME 23 7620
TEST_TIME 24 8251
TEST_TIME 25 8898
TEST_TIME 26 9723
TEST_TIME 27 10077
TEST_TIME 28 9838
TEST_TIME 29 9972
TEST_TIME 30 10107
TEST_TIME 31 10004
TEST_TIME 32 9854
TEST_TIME 33 9604
TEST_TIME 34 9531
TEST_TIME 35 9574
TEST_TIME 36 9508
TEST_TIME 37 9428
TEST_TIME 38 9329
TEST_TIME 39 9431
TEST_TIME 40 9509
TEST_TIME 41 9417
TEST_TIME 42 9439
TEST_TIME 43 9328
TEST_TIME 44 9212
TEST_TIME 45 9341
TEST_TIME 46 9483
TEST_TIME 47 9461
TEST_TIME 48 9503
TEST_TIME 49 9443
TEST_TIME 50 9595
TEST_TIME 51 9694
TEST_TIME 52 9664
TEST_TIME 53 9638
TEST_TIME 54 9751
TEST_TIME 55 9717
TEST_TIME 56 9683
TEST_TIME 57 9644
TEST_TIME 58 9604
TEST_TIME 59 9505
TEST_TIME 60 9366
TEST_TIME 61 9343
TEST_TIME 62 9319
TEST_TIME 63 9312
TEST_TIME 64 9262
TEST_TIME 65 9186
TEST_TIME 66 9093
TEST_TIME 67 9269
TEST_TIME 68 9264
TEST_TIME 69 9247
TEST_TIME 70 9276
TEST_TIME 71 9352
TEST_TIME 72 9333
TEST_TIME 73 9410
TEST_TIME 74 9395
TEST_TIME 75 9361
TEST_TIME 76 9424
TEST_TIME 77 9443
TEST_TIME 78 9433
TEST_TIME 79 9342
TEST_TIME 80 9285
TEST_TIME 81 9260
TEST_TIME 82 9194
TEST_TIME 83 9133
TEST_TIME 84 9064
TEST_TIME 85 9187
TEST_TIME 86 9205
TEST_TIME 87 9202
TEST_TIME 88 9178
TEST_TIME 89 9213
TEST_TIME 90 9191
TEST_TIME 91 9243
TEST_TIME 92 9249
TEST_TIME 93 9281
TEST_TIME 94 9299
TEST_TIME 95 9313
TEST_TIME 96 9313
TEST_TIME 97 9252
TEST_TIME 98 9186
TEST_TIME 99 9195
TEST_TIME 100 9140

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-03-2024 04:09:57 to 01-03-2024 04:10:00.

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 1277168 1277168 0 0.00 0 20589 8 0 0
doc_list_biud 1277164 1277164 0 0.00 0 56617 30 0 0
sp_add_invoice_to_stock 4250 4151 99 2.32 22 223615 22652 0 99
sp_cancel_adding_invoice 4638 4638 0 0.00 4 66722 810 0 0
sp_cancel_client_order 1383 1383 0 0.00 4 7791 357 0 0
sp_cancel_customer_reserve 445113 445113 0 0.00 0 56619 72 0 0
sp_cancel_pay_from_customer 558 558 0 0.00 2 5477 68 0 0
sp_cancel_pay_to_supplier 349 349 0 0.00 2 8950 100 0 0
sp_cancel_supplier_invoice 5139 5130 9 0.17 1 20417 706 0 9
sp_cancel_supplier_order 381 381 0 0.00 7 849595 101685 0 0
sp_cancel_write_off 8099 8099 0 0.00 1 17780 138 0 0
sp_client_order 16982 16982 0 0.00 3 43598 380 0 0
sp_customer_reserve 397044 397044 0 0.00 0 84766 221 0 0
sp_fill_shopping_cart 26087 26087 0 0.00 1 13857 36 0 0
sp_fill_shopping_cart_clo_res 397030 397030 0 0.00 0 20042 17 0 0
sp_get_clo_for_invoice 4136 4136 0 0.00 0 19501 294 0 0
sp_kill_cost_storno 13644 13644 0 0.00 0 16697 71 0 0
sp_kill_qstorno_ret_qs2qd 903836 903836 0 0.00 0 56613 38 0 0
sp_kill_qty_storno 477203 477203 0 0.00 0 56617 80 0 0
sp_lock_selected_doc 17252 17252 0 0.00 0 10491 8 0 0
sp_make_cost_storno 23162 23162 0 0.00 0 20582 60 0 0
sp_multiply_rows_for_pdistr 23160 23160 0 0.00 0 7445 32 0 0
sp_multiply_rows_for_qdistr 16982 16982 0 0.00 0 21442 181 0 0
sp_pay_from_customer 5771 5771 0 0.00 4 18706 115 0 0
sp_pay_to_supplier 4931 4931 0 0.00 4 27941 137 0 0
sp_payment_common 10701 10701 0 0.00 1 8136 21 0 0
sp_qd_handle_on_cancel_clo 1383 1383 0 0.00 0 6968 327 0 0
sp_qd_handle_on_invoice_upd_sts 8773 8773 0 0.00 0 16777 273 0 0
sp_qd_handle_on_reserve_upd_sts 8324 8324 0 0.00 0 16663 84 0 0
sp_reserve_write_off 8324 8324 0 0.00 6 18233 218 0 0
sp_supplier_invoice 4643 4643 0 0.00 5 77647 2894 0 0
sp_supplier_order 4491 4491 0 0.00 4 26718 1259 0 0
srv_aggregate_perf_data 97 97 0 0.00 1528 116910 12882 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1512 117968 42701 0 0
srv_find_qd_qs_mism 871395 871395 0 0.00 0 16543 7 0 0
srv_make_invnt_saldo 384 384 0 0.00 33 98547 4059 0 0
srv_make_money_saldo 618 618 0 0.00 1 15622 572 0 0
srv_recalc_idx_stat 4 4 0 0.00 136395 437897 286100 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4151 4151 0 0.00 0 7704 165 0 0
t$perf-norm:sp_cancel_adding_invoice 363 363 0 0.00 0 1524 59 0 0
t$perf-norm:sp_cancel_client_order 1383 1383 0 0.00 0 9338 16 0 0
t$perf-norm:sp_cancel_customer_reserve 587 587 0 0.00 0 3421 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 558 558 0 0.00 0 3094 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 349 349 0 0.00 0 1228 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 609 17 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 24324 1467 0 0
t$perf-norm:sp_cancel_write_off 825 825 0 0.00 0 971 5 0 0
t$perf-norm:sp_client_order 16982 16982 0 0.00 0 9772 15 0 0
t$perf-norm:sp_customer_reserve 856 856 0 0.00 0 3709 10 0 0
t$perf-norm:sp_pay_from_customer 5771 5771 0 0.00 0 8585 11 0 0
t$perf-norm:sp_pay_to_supplier 4931 4931 0 0.00 0 11629 13 0 0
t$perf-norm:sp_reserve_write_off 8324 8324 0 0.00 0 4418 11 0 0
t$perf-norm:sp_supplier_invoice 4643 4643 0 0.00 0 4654 16 0 0
t$perf-norm:sp_supplier_order 4491 4491 0 0.00 0 5304 14 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 174 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 254 7 0 0
t$perf-norm:srv_make_invnt_saldo 384 384 0 0.00 0 1212 8 0 0
t$perf-norm:srv_make_money_saldo 618 618 0 0.00 0 629 6 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 23 7 0 0
v_add_invoice_to_stock 8466 8268 198 2.33 0 7002 17 0 198
v_all_customers 31414 31414 0 0.00 0 19 1 0 0
v_all_suppliers 26300 26300 0 0.00 0 23 1 0 0
v_all_wares 33952 33952 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 726 726 0 0.00 0 3587 12 0 0
v_cancel_client_order 2766 2766 0 0.00 0 2698 5 0 0
v_cancel_customer_prepayment 1116 1116 0 0.00 0 1020 5 0 0
v_cancel_customer_reserve 1174 1174 0 0.00 0 1236 5 0 0
v_cancel_payment_to_supplier 698 698 0 0.00 0 8912 18 0 0
v_cancel_supplier_invoice 716 698 18 2.51 0 294 11 0 18
v_cancel_supplier_order 762 762 0 0.00 0 1780 8 0 0
v_cancel_write_off 1650 1650 0 0.00 0 5364 15 0 0
v_max_id_clo_ord 4483 4483 0 0.00 0 677 2 0 0
v_max_id_clo_res 856 856 0 0.00 0 2134 7 0 0
v_max_id_ord_sup 4627 4627 0 0.00 0 8620 7 0 0
v_max_non_paid_invoice 890 890 0 0.00 0 225 2 0 0
v_max_non_paid_realizn 2795 2795 0 0.00 0 5377 6 0 0
v_min_id_clo_ord 4483 4483 0 0.00 0 3273 7 0 0
v_min_id_clo_res 856 856 0 0.00 0 5351 14 0 0
v_min_id_ord_sup 4627 4627 0 0.00 0 5519 6 0 0
v_min_non_paid_invoice 4930 4930 0 0.00 0 3983 11 0 0
v_min_non_paid_realizn 5771 5771 0 0.00 0 5525 16 0 0
v_our_firm 8490 8490 0 0.00 0 63 1 0 0
v_reserve_write_off 16644 16644 0 0.00 0 4601 7 0 0
x_lock_depdocs_on_canc_invoice 9419 9419 0 0.00 0 21014 137 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 19563 366 0 0
x_make_qstorno_1000_1200 4491 4491 0 0.00 1 26713 1184 0 0
x_make_qstorno_1200_2000 4643 4643 0 0.00 2 66447 2761 0 0
x_make_qstorno_2100_3300 397044 397044 0 0.00 0 84764 202 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-03-2024 04:10:01 to 01-03-2024 04:10:05.

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
02:07:52 3 8192000000 8796669328 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
02:08:53 33771 8192000000 9721484816 10018938880 793580976 8.831 100 87 174 0 822138896 7476720 21081200
02:10:34 17717 8192000000 9750714784 10055524352 825087600 9.150 100 88 176 0 857701184 11516816 21096768
02:11:57 22296 8192000000 9789622336 10104782848 850655360 9.407 100 86 172 0 890691520 19239760 20796400
02:13:26 13182 8192000000 9847700272 10177544192 895890464 9.858 100 78 155 0 956660912 43267312 17503136
02:14:44 8652 8192000000 9907229136 10249064448 939652320 10.290 100 80 160 0 1021574592 64411408 17510864
02:15:55 4684 8192000000 9956669232 10307829760 976021056 10.645 100 82 163 0 1065019872 72294320 16704496
02:17:03 2993 8192000000 9960068032 10322677760 1009270912 10.968 100 78 152 1 1083417840 58683072 15463856
02:18:09 1849 8192000000 10013406752 10382131200 1030958784 11.178 100 88 176 0 1123746752 74360528 18427440
02:19:13 1404 8192000000 10020293152 10394189824 1048796240 11.349 100 81 161 0 1135092192 69693888 16602064
02:20:17 4344 8192000000 10008443904 10393661440 1057972512 11.437 100 63 129 0 1133608352 62125920 13509920
02:21:22 42494 8192000000 9985979808 10391547904 1068814640 11.541 100 26 52 0 1119015136 43531584 6668912
02:23:08 6447 8192000000 9993953200 10397073408 1077343360 11.622 100 31 61 1 1106039392 22818928 5877104
02:24:17 3118 8192000000 10003374960 10398064640 1086398544 11.708 100 40 81 0 1111125456 16394336 8332576
02:25:22 9448 8192000000 10003035296 10406670336 1091424208 11.756 100 26 52 1 1120703184 23511104 5767872
02:26:32 27658 8192000000 10025852080 10418380800 1092420224 11.766 100 73 147 2 1126803776 18410928 15972624
02:28:02 6845 8192000000 10033667984 10432626688 1104763632 11.883 100 50 101 2 1142674048 28040656 9869760
02:29:17 40452 8192000000 10075805008 10483372032 1090317312 11.746 98 53 106 0 1166984432 65983776 10683344
02:31:17 14764 8192000000 10068986752 10472964096 1116842864 11.997 100 44 88 0 1179897648 52948912 10105872
02:32:43 31072 8192000000 10083432256 10487377920 1098875952 11.827 97 46 92 0 1184859984 75639648 10344384
02:34:23 38082 8192000000 10091070944 10539483136 1088000592 11.724 97 29 58 0 1203167632 108598064 6568976
02:36:12 17416 8192000000 10138359056 10540580864 1102658240 11.863 99 52 104 0 1233402896 118931984 11812672
02:37:35 23372 8192000000 10122767328 10533322752 1099683024 11.835 99 32 64 0 1223513200 116987680 6842496
02:39:05 35045 8192000000 10160423424 10568732672 1100231136 11.840 98 36 69 0 1260414560 151940928 8242496
02:40:46 4336 8192000000 10217861136 10612785152 1123312448 12.058 100 70 136 1 1318817088 180788912 14715728
02:41:58 3620 8192000000 10266896768 10656550912 1127159840 12.095 100 76 152 0 1371691872 227730864 16801168
02:43:07 1511 8192000000 10303322432 10692841472 1116996336 11.999 99 76 151 1 1405280544 270717072 17567136
02:44:13 2782 8192000000 10359780752 10772402176 1134692848 12.166 100 79 158 1 1460376416 308048960 17634608
02:45:21 4869 8192000000 10327321904 10738651136 1148535536 12.296 100 69 138 0 1426895232 262135616 16224080
02:46:31 1771 8192000000 10351853184 10755399680 1161134032 12.414 100 86 170 1 1452277904 272063312 19080560
02:47:36 6190 8192000000 10420714816 10822578176 1167924992 12.477 100 81 161 1 1509840704 323747072 18168640
02:48:45 18760 8192000000 10406216816 10844262400 1173731936 12.532 100 50 100 0 1503979040 318038240 12208864
02:50:12 21190 8192000000 10445251856 10913120256 1158340496 12.388 100 34 68 0 1536785552 369431360 9013696
02:51:39 21224 8192000000 10367512544 10935033856 1119092320 12.018 98 23 46 0 1457341568 332056944 6192304
02:56:32 66669 8192000000 10099053472 10566946816 1115265264 11.982 99 20 40 0 1168517024 49305424 3946336
02:58:40 93817 8192000000 10078551680 10544062464 1135852832 12.177 100 29 57 0 1185956656 44276576 5827248
03:01:37 70581 8192000000 10113768064 10544308224 1131974992 12.140 99 44 84 1 1211533360 70717632 8840736
03:03:51 47015 8192000000 10136137600 10557136896 1128063504 12.103 98 31 59 0 1203725744 69565744 6096496
03:05:40 23209 8192000000 10181525520 10618339328 1158510512 12.389 100 53 105 0 1281586752 111650400 11425840
03:07:07 45923 8192000000 10132187088 10580172800 1154818656 12.355 100 26 52 0 1224805664 64451568 5535440
03:08:53 78589 8192000000 10106090976 10586914816 1162096848 12.423 100 18 36 0 1225392688 59267424 4028416
03:11:14 78956 8192000000 10128546672 10631569408 1164583552 12.446 100 13 26 0 1241961264 74523312 2854400
03:13:33 46085 8192000000 10081133616 10531299328 1149853664 12.308 99 26 52 0 1173554272 18382048 5318560
03:15:25 38118 8192000000 10098203792 10552705024 1142618528 12.240 99 35 70 0 1197863184 48781520 6463136
03:17:04 23749 8192000000 10116487760 10573598720 1142308192 12.237 100 39 78 0 1229390768 79029344 8053232
03:18:29 78876 8192000000 10081915216 10560606208 1120941184 12.036 98 17 34 0 1174643568 50185264 3517120
03:20:50 42094 8192000000 10081265760 10579324928 1104859648 11.884 97 26 52 0 1187354912 77495536 4999728
03:22:34 92206 8192000000 10072385648 10554163200 1107384288 11.908 97 18 34 2 1159174208 48420112 3369808
03:25:12 37617 8192000000 10077271184 10509082624 1088956384 11.733 96 36 72 0 1151263616 55226672 7080560
03:26:56 79699 8192000000 10078647296 10513801216 1067554976 11.529 95 46 92 0 1132162608 54441840 10165792
03:29:37 45169 8192000000 10089937296 10535579648 1103661632 11.872 98 36 72 0 1170842400 58806736 8374032
03:31:35 38525 8192000000 10095357968 10578505728 1122023344 12.046 100 11 22 0 1204795104 80244096 2527664
03:33:26 55015 8192000000 10132556640 10616254464 1107676352 11.910 98 18 36 0 1234110240 122021728 4412160
03:35:57 44123 8192000000 10071150864 10497110016 1113616112 11.967 100 29 58 0 1144605248 25117904 5871232
03:37:45 53161 8192000000 10072555504 10504896512 1103328144 11.869 99 22 44 0 1183575440 75828608 4418688
03:40:23 62463 8192000000 10040638912 10496524288 1082921712 11.675 97 4 8 0 1131968272 48432848 613712
03:42:26 8334 8192000000 10090375744 10507157504 1118006144 12.008 100 61 120 0 1176990416 47090048 11894224
03:43:35 42189 8192000000 10084421296 10513203200 1132104032 12.141 100 34 68 1 1177745008 39090032 6550944
03:45:28 117968 8192000000 10057717520 10491244544 1112487632 11.956 98 27 54 0 1172346816 54920128 4939056
03:48:27 49713 8192000000 10087891680 10541223936 1126070288 12.084 99 17 34 0 1190869952 61513776 3285888
03:50:18 85027 8192000000 10159828816 10624512000 1135774880 12.176 99 16 32 0 1231815088 92740272 3299936
03:52:58 102065 8192000000 10082401024 10541875200 1120158624 12.028 98 9 18 0 1156821680 34921184 1741872
03:55:41 17406 8192000000 10079447424 10514391040 1149768464 12.307 100 41 82 0 1183378176 24583040 9026672
03:57:00 54010 8192000000 10083340256 10523172864 1148279760 12.293 99 11 23 0 1197881584 47058560 2543264
03:58:55 70524 8192000000 10105164176 10566303744 1146499504 12.277 99 21 43 0 1208750448 58091392 4159552
04:01:20 45905 8192000000 10090470800 10551959552 1118570864 12.013 98 33 66 0 1178921296 53851424 6499008
04:03:07 39567 8192000000 10079289568 10507030528 1084682592 11.692 95 27 54 0 1136920496 47255088 4982816
04:04:50 62308 8192000000 10039974528 10467807232 1105326320 11.888 98 37 74 1 1135434848 22766816 7341712
04:06:56 33141 8192000000 10043139376 10506330112 1119271760 12.020 99 7 14 0 1155977344 35555888 1149696

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 01-03-2024 04:10:07 to 01-03-2024 04:10:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 99 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-03-2024 04:10:22 to 01-03-2024 04:10:24.

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          165257
MON$OLDEST_ACTIVE               167604
MON$OLDEST_SNAPSHOT             167604
MON$NEXT_TRANSACTION            167604
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                       1909664
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             682
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 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  1 04:10:25 2024 
 
Database header page information: 
    Flags            0 
    Generation        87802 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    165257 
    Oldest active        167604 
    Oldest snapshot        167604 
    Next transaction    167605 
    Sequence number        0 
    Next attachment ID    682 
    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.78, total records: 7641653 
    Average version length: 48.16, total versions: 22237, 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: 54, data page slots: 87904 
    Data pages: 87904, average fill: 69% 
    Primary pages: 87902, secondary pages: 2, swept pages: 53553 
    Empty pages: 3, full pages: 61058 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 30 
    40 - 59% = 1468 
    60 - 79% = 86385 
    80 - 99% = 13 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23033, nodes: 7641653 
    Average node length: 18.84, total dup: 0, max dup: 0 
    Average key length: 15.85, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1668689, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 277 
        20 - 39% = 2026 
        40 - 59% = 3970 
        60 - 79% = 2631 
        80 - 99% = 14129 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13399, nodes: 7641653 
    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: 1492545, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1703 
        40 - 59% = 1899 
        60 - 79% = 1231 
        80 - 99% = 8566 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8268, nodes: 7641653 
    Average node length: 6.59, total dup: 5747643, max dup: 49 
    Average key length: 3.60, compression ratio: 2.50 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1485551, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 1079 
        40 - 59% = 1271 
        60 - 79% = 1064 
        80 - 99% = 4730 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.15, total records: 2184616 
    Average version length: 58.91, total versions: 11807, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28080 
    Data pages: 28080, average fill: 71% 
    Primary pages: 28078, secondary pages: 2, swept pages: 14984 
    Empty pages: 4, full pages: 15926 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 28 
    40 - 59% = 693 
    60 - 79% = 27333 
    80 - 99% = 14 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4488, nodes: 2184616 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 671370, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 942 
        40 - 59% = 811 
        60 - 79% = 812 
        80 - 99% = 1923 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2375, nodes: 2185331 
    Average node length: 4.97, total dup: 2184433, max dup: 16813 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254302, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 193 
        40 - 59% = 1394 
        60 - 79% = 557 
        80 - 99% = 227 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1737, nodes: 2184616 
    Average node length: 4.97, total dup: 2184566, max dup: 130037 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1040928, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 600 
        60 - 79% = 40 
        80 - 99% = 1087 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4306, nodes: 2184616 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 671370, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 611 
        40 - 59% = 650 
        60 - 79% = 888 
        80 - 99% = 2049 
 
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.36, total records: 400 
    Average version length: 31.84, total versions: 1596, max versions: 4 
    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: 61% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 2, full pages: 13 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 12 
 
    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: 26.22, total records: 56139 
    Average version length: 68.24, total versions: 39835, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.36 
    Pointer pages: 7, data page slots: 2224 
    Data pages: 1208, average fill: 60% 
    Primary pages: 1207, secondary pages: 1, swept pages: 33 
    Empty pages: 230, full pages: 696 
    Fill distribution: 
     0 - 19% = 303 
    20 - 39% = 79 
    40 - 59% = 61 
    60 - 79% = 219 
    80 - 99% = 546 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701024, depth: 3, leaf buckets: 211, nodes: 56139 
    Average node length: 13.60, total dup: 1568, max dup: 1 
    Average key length: 11.00, compression ratio: 2.45 
    Average prefix length: 18.97, average data length: 8.03 
    Clustering factor: 42405, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 67 
        40 - 59% = 117 
        60 - 79% = 26 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 113, max versions: 4 
    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: 1 
    Data pages: 1, average fill: 58% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    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: 14.93, total records: 1093 
    Average version length: 42.89, total versions: 905, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.88 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 36% 
    Primary pages: 30, secondary pages: 2, swept pages: 4 
    Empty pages: 10, full pages: 10 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92051, depth: 2, leaf buckets: 2, nodes: 1093 
    Average node length: 4.38, total dup: 995, max dup: 101 
    Average key length: 2.95, compression ratio: 6.44 
    Average prefix length: 18.14, average data length: 0.86 
    Clustering factor: 615, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        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.77, total records: 69 
    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: 48% 
    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: 69 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.70, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    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.71, total records: 809918 
    Average version length: 37.90, total versions: 21755, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8760 
    Data pages: 8760, average fill: 63% 
    Primary pages: 8758, secondary pages: 2, swept pages: 3826 
    Empty pages: 27, full pages: 4108 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 112 
    40 - 59% = 1208 
    60 - 79% = 7336 
    80 - 99% = 44 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 898, nodes: 799466 
    Average node length: 4.88, total dup: 799417, max dup: 154255 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90909, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 163 
        40 - 59% = 500 
        60 - 79% = 155 
        80 - 99% = 79 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1054, nodes: 799466 
    Average node length: 5.89, total dup: 711875, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160801, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 715 
        60 - 79% = 65 
        80 - 99% = 189 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1076, nodes: 799466 
    Average node length: 5.89, total dup: 711875, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162609, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 128 
        40 - 59% = 696 
        60 - 79% = 65 
        80 - 99% = 187 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1156, nodes: 799466 
    Average node length: 5.97, total dup: 711875, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155177, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 283 
        40 - 59% = 584 
        60 - 79% = 202 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.94, total records: 5518 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 5.06, total fragments: 16, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 82, secondary pages: 13, swept pages: 64 
    Empty pages: 12, full pages: 63 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5518 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.10 
    Average prefix length: 34.60, average data length: 1.54 
    Clustering factor: 5193, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        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: 5518 
    Average node length: 11.13, 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: 162, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        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.06, total records: 76110 
    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: 792 
    Data pages: 792, average fill: 66% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 790 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 790 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33595, depth: 2, leaf buckets: 96, nodes: 76110 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 2840, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 96 
 
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.51, 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.30 
    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: 148.31, total records: 162592 
    Average version length: 154.37, total versions: 3314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 6, data page slots: 5384 
    Data pages: 4088, average fill: 82% 
    Primary pages: 4086, secondary pages: 2, swept pages: 7 
    Empty pages: 76, full pages: 3984 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3984 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.21, total records: 141774 
    Average version length: 152.94, total versions: 2050, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 3976 
    Data pages: 3520, average fill: 83% 
    Primary pages: 3519, secondary pages: 1, swept pages: 7 
    Empty pages: 21, full pages: 3477 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 3 
    80 - 99% = 3478 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.40, total records: 141708 
    Average version length: 148.88, total versions: 441, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 6, data page slots: 5624 
    Data pages: 3552, average fill: 82% 
    Primary pages: 3550, secondary pages: 2, swept pages: 2 
    Empty pages: 65, full pages: 3466 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3466 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 147.96, total records: 166261 
    Average version length: 152.21, total versions: 3922, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 5528 
    Data pages: 4208, average fill: 82% 
    Primary pages: 4206, secondary pages: 2, swept pages: 9 
    Empty pages: 100, full pages: 4072 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 11 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 4073 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 138.97, total records: 157794 
    Average version length: 154.05, total versions: 13292, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.20 
    Pointer pages: 7, data page slots: 4192 
    Data pages: 3960, average fill: 83% 
    Primary pages: 3958, secondary pages: 2, swept pages: 9 
    Empty pages: 71, full pages: 3858 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 8 
    40 - 59% = 12 
    60 - 79% = 8 
    80 - 99% = 3857 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 150.74, total records: 146463 
    Average version length: 137.73, total versions: 375, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 7, data page slots: 4832 
    Data pages: 3672, average fill: 82% 
    Primary pages: 3671, secondary pages: 1, swept pages: 9 
    Empty pages: 63, full pages: 3588 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3589 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 149.97, total records: 143667 
    Average version length: 146.92, total versions: 971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 5704 
    Data pages: 3608, average fill: 82% 
    Primary pages: 3606, secondary pages: 2, swept pages: 12 
    Empty pages: 69, full pages: 3516 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 10 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3516 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.53, total records: 146101 
    Average version length: 147.85, total versions: 479, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 7, data page slots: 4104 
    Data pages: 3656, average fill: 82% 
    Primary pages: 3654, secondary pages: 2, swept pages: 8 
    Empty pages: 59, full pages: 3575 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 3575 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 144.55, total records: 159352 
    Average version length: 154.58, total versions: 7347, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 6, data page slots: 4504 
    Data pages: 4016, average fill: 82% 
    Primary pages: 4015, secondary pages: 1, swept pages: 7 
    Empty pages: 85, full pages: 3907 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3908 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.67, total records: 152514 
    Average version length: 150.88, total versions: 1488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 6152 
    Data pages: 3808, average fill: 83% 
    Primary pages: 3805, secondary pages: 3, swept pages: 6 
    Empty pages: 54, full pages: 3735 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3735 
 
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.51, total records: 2058147 
    Average version length: 52.90, total versions: 10937, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25408 
    Data pages: 25392, average fill: 70% 
    Primary pages: 25375, secondary pages: 17, swept pages: 12494 
    Empty pages: 137, full pages: 21112 
    Fill distribution: 
     0 - 19% = 292 
    20 - 39% = 308 
    40 - 59% = 963 
    60 - 79% = 23750 
    80 - 99% = 79 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2531, nodes: 2058147 
    Average node length: 5.44, total dup: 1919780, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179488, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 323 
        40 - 59% = 1596 
        60 - 79% = 297 
        80 - 99% = 309 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2750, nodes: 2058147 
    Average node length: 5.70, total dup: 1846533, max dup: 71 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 369148, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 11 
        40 - 59% = 2486 
        60 - 79% = 226 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2069, nodes: 2058147 
    Average node length: 4.96, total dup: 2058047, max dup: 27078 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 177248, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 188 
        40 - 59% = 1055 
        60 - 79% = 368 
        80 - 99% = 454 
 
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: 50.10, total records: 137817 
    Average version length: 69.18, total versions: 43723, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.51 
    Pointer pages: 3, data page slots: 3632 
    Data pages: 2864, average fill: 57% 
    Primary pages: 2864, secondary pages: 0, swept pages: 266 
    Empty pages: 149, full pages: 1031 
    Fill distribution: 
     0 - 19% = 258 
    20 - 39% = 374 
    40 - 59% = 773 
    60 - 79% = 982 
    80 - 99% = 477 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104263, depth: 3, leaf buckets: 232, nodes: 137817 
    Average node length: 6.49, total dup: 120104, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 24700, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 73 
        40 - 59% = 107 
        60 - 79% = 46 
        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.95, total records: 7052729 
    Average version length: 68.76, total versions: 235254, 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: 67, data page slots: 109176 
    Data pages: 109176, average fill: 69% 
    Primary pages: 109176, secondary pages: 0, swept pages: 51997 
    Empty pages: 9, full pages: 42926 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 650 
    40 - 59% = 10915 
    60 - 79% = 97187 
    80 - 99% = 364 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10863, nodes: 7052729 
    Average node length: 6.51, total dup: 6100519, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1674951, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1743 
        40 - 59% = 6125 
        60 - 79% = 2659 
        80 - 99% = 330 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8638, nodes: 7052729 
    Average node length: 5.40, total dup: 6770857, max dup: 123 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1482607, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1388 
        40 - 59% = 4592 
        60 - 79% = 1746 
        80 - 99% = 908 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8703, nodes: 7052729 
    Average node length: 5.40, total dup: 6770857, max dup: 123 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1485077, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1461 
        40 - 59% = 4612 
        60 - 79% = 1709 
        80 - 99% = 913 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.08, total records: 12113240 
    Average version length: 68.73, total versions: 174289, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 110, data page slots: 178048 
    Data pages: 178048, average fill: 72% 
    Primary pages: 178047, secondary pages: 1, swept pages: 104795 
    Empty pages: 8, full pages: 126194 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 592 
    40 - 59% = 7447 
    60 - 79% = 169133 
    80 - 99% = 843 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18579, nodes: 12112752 
    Average node length: 6.62, total dup: 10562359, max dup: 52 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2468311, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2336 
        40 - 59% = 10774 
        60 - 79% = 4712 
        80 - 99% = 730 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 58.36, total records: 1279048 
    Average version length: 69.04, total versions: 188489, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.16 
    Pointer pages: 28, data page slots: 44888 
    Data pages: 27688, average fill: 51% 
    Primary pages: 27631, secondary pages: 57, swept pages: 13143 
    Empty pages: 4032, full pages: 12677 
    Fill distribution: 
     0 - 19% = 6410 
    20 - 39% = 3111 
    40 - 59% = 3331 
    60 - 79% = 12568 
    80 - 99% = 2268 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1862, nodes: 1238545 
    Average node length: 5.53, total dup: 1188593, max dup: 49 
    Average key length: 2.57, compression ratio: 16.34 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 85485, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 678 
        40 - 59% = 868 
        60 - 79% = 293 
        80 - 99% = 15 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 44.82, total records: 810941 
    Average version length: 69.02, total versions: 108040, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.81 
    Pointer pages: 23, data page slots: 36128 
    Data pages: 24952, average fill: 31% 
    Primary pages: 24951, secondary pages: 1, swept pages: 8866 
    Empty pages: 5750, full pages: 2799 
    Fill distribution: 
     0 - 19% = 9325 
    20 - 39% = 5160 
    40 - 59% = 7054 
    60 - 79% = 3379 
    80 - 99% = 34 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1013, nodes: 592142 
    Average node length: 5.94, total dup: 546236, max dup: 55 
    Average key length: 3.02, compression ratio: 13.93 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 85001, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 451 
        40 - 59% = 458 
        60 - 79% = 94 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 68.30, total records: 8697364 
    Average version length: 68.98, total versions: 84497, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.84 
    Pointer pages: 88, data page slots: 142080 
    Data pages: 142056, average fill: 65% 
    Primary pages: 142036, secondary pages: 20, swept pages: 95561 
    Empty pages: 365, full pages: 55306 
    Fill distribution: 
     0 - 19% = 1638 
    20 - 39% = 8403 
    40 - 59% = 23241 
    60 - 79% = 108359 
    80 - 99% = 415 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13356, nodes: 8695888 
    Average node length: 6.68, total dup: 7212041, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1992389, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1840 
        40 - 59% = 7201 
        60 - 79% = 3884 
        80 - 99% = 429 
 
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: 21082893 
    Average version length: 82.96, total versions: 3447, 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: 318800 
    Data pages: 318800, average fill: 81% 
    Primary pages: 318795, secondary pages: 5, swept pages: 12716 
    Empty pages: 44, full pages: 317692 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 43 
    40 - 59% = 139 
    60 - 79% = 47895 
    80 - 99% = 270652 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19540, nodes: 21082893 
    Average node length: 5.72, total dup: 20603188, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273109, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8552 
        60 - 79% = 555 
        80 - 99% = 10428 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17118, nodes: 21082893 
    Average node length: 6.31, total dup: 18527251, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914158, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 774 
        60 - 79% = 279 
        80 - 99% = 16057 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21320, nodes: 21082893 
    Average node length: 6.34, total dup: 18446609, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3566049, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8844 
        60 - 79% = 585 
        80 - 99% = 11887 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15992, nodes: 21082893 
    Average node length: 5.56, total dup: 21082793, max dup: 229507 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942833, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 2779 
        60 - 79% = 352 
        80 - 99% = 12846 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.79, total records: 9143229 
    Average version length: 82.64, total versions: 76617, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 105, data page slots: 169904 
    Data pages: 169856, average fill: 66% 
    Primary pages: 169818, secondary pages: 38, swept pages: 114333 
    Empty pages: 887, full pages: 84440 
    Fill distribution: 
     0 - 19% = 2941 
    20 - 39% = 12298 
    40 - 59% = 28610 
    60 - 79% = 112088 
    80 - 99% = 13919 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11283, nodes: 9143229 
    Average node length: 5.36, total dup: 8840778, max dup: 174 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2099743, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 148 
        40 - 59% = 9404 
        60 - 79% = 1711 
        80 - 99% = 17 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13034, nodes: 9143229 
    Average node length: 6.22, total dup: 7578447, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1481494, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 3959 
        40 - 59% = 4350 
        60 - 79% = 2581 
        80 - 99% = 2027 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12594, nodes: 9143229 
    Average node length: 5.98, total dup: 7921322, max dup: 35 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2271805, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 157 
        40 - 59% = 10522 
        60 - 79% = 1883 
        80 - 99% = 29 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9657, nodes: 9143229 
    Average node length: 5.12, total dup: 9143129, max dup: 133507 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1510033, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1297 
        40 - 59% = 4730 
        60 - 79% = 1686 
        80 - 99% = 1892 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.79, total records: 10783745 
    Average version length: 82.58, total versions: 71766, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 119, data page slots: 192968 
    Data pages: 191072, average fill: 69% 
    Primary pages: 190881, secondary pages: 191, swept pages: 82502 
    Empty pages: 4298, full pages: 134498 
    Fill distribution: 
     0 - 19% = 7514 
    20 - 39% = 10720 
    40 - 59% = 21283 
    60 - 79% = 97561 
    80 - 99% = 53994 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13102, nodes: 10783745 
    Average node length: 5.29, total dup: 10675052, max dup: 624 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2257472, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 330 
        40 - 59% = 10220 
        60 - 79% = 2484 
        80 - 99% = 68 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10143, nodes: 10783745 
    Average node length: 5.49, total dup: 10312204, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 691039, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 189 
        20 - 39% = 953 
        40 - 59% = 2493 
        60 - 79% = 1848 
        80 - 99% = 4660 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14981, nodes: 10783745 
    Average node length: 6.02, total dup: 9398901, max dup: 63 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2273683, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 426 
        40 - 59% = 11741 
        60 - 79% = 2728 
        80 - 99% = 83 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10361, nodes: 10783745 
    Average node length: 5.21, total dup: 10783645, max dup: 176494 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 680648, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 925 
        40 - 59% = 4533 
        60 - 79% = 1438 
        80 - 99% = 3353 
 
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: 82.11, total records: 9256097 
    Average version length: 82.88, total versions: 78276, 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: 107, data page slots: 173952 
    Data pages: 173896, average fill: 66% 
    Primary pages: 173861, secondary pages: 35, swept pages: 120520 
    Empty pages: 990, full pages: 81674 
    Fill distribution: 
     0 - 19% = 3040 
    20 - 39% = 13069 
    40 - 59% = 31296 
    60 - 79% = 113139 
    80 - 99% = 13352 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11353, nodes: 9256097 
    Average node length: 5.17, total dup: 9228165, max dup: 1515 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1905628, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1687 
        40 - 59% = 7390 
        60 - 79% = 1698 
        80 - 99% = 543 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13161, nodes: 9256097 
    Average node length: 6.24, total dup: 7671989, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1444428, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 3934 
        40 - 59% = 4310 
        60 - 79% = 2627 
        80 - 99% = 2145 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 11950, nodes: 9256097 
    Average node length: 5.43, total dup: 8838161, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2031756, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1618 
        40 - 59% = 8227 
        60 - 79% = 1546 
        80 - 99% = 523 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9751, nodes: 9256097 
    Average node length: 5.14, total dup: 9255997, max dup: 135917 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1529518, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1308 
        40 - 59% = 4719 
        60 - 79% = 1723 
        80 - 99% = 1958 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.96, total records: 568416 
    Average version length: 68.85, total versions: 1986, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 74% 
    Primary pages: 8000, secondary pages: 0, swept pages: 4181 
    Empty pages: 0, full pages: 6613 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 14 
    40 - 59% = 144 
    60 - 79% = 7807 
    80 - 99% = 35 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40336, depth: 3, leaf buckets: 737, nodes: 568416 
    Average node length: 5.95, total dup: 483939, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99885, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 34 
        40 - 59% = 532 
        60 - 79% = 84 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28452, depth: 3, leaf buckets: 754, nodes: 568416 
    Average node length: 6.15, total dup: 466155, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99931, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 536 
        60 - 79% = 80 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 546, nodes: 568416 
    Average node length: 4.86, total dup: 568316, max dup: 9792 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88910, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 283 
        60 - 79% = 80 
        80 - 99% = 144 
 
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  1 04:10:48 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7641653 22237 1 0.0000 0.0000
DOC_LIST 2184616 11807 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1596 4 300.0000 0.0000
INVNT_TURNOVER_LOG 56139 39835 1 0.0000 0.0000
MONEY_SALDO 49 113 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1093 905 1 0.0000 0.0000
PDISTR 809918 21755 2 0.0000 0.0000
PERF_SPLIT_0 162592 3314 1 0.0000 0.0000
PERF_SPLIT_1 141774 2050 1 0.0000 0.0000
PERF_SPLIT_2 141708 441 1 0.0000 0.0000
PERF_SPLIT_3 166261 3922 1 0.0000 0.0000
PERF_SPLIT_4 157794 13292 1 0.0000 0.0000
PERF_SPLIT_5 146463 375 1 0.0000 0.0000
PERF_SPLIT_6 143667 971 1 0.0000 0.0000
PERF_SPLIT_7 146101 479 1 0.0000 0.0000
PERF_SPLIT_8 159352 7347 1 0.0000 0.0000
PERF_SPLIT_9 152514 1488 1 0.0000 0.0000
PSTORNED 2058147 10937 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 137817 43723 1 0.0000 0.0000
XQD_1000_3300 7052729 235254 1 0.0000 0.0000
XQD_1200_2000 12113240 174289 1 0.0000 0.0000
XQD_2000_3300 1279048 188489 1 0.0000 0.0000
XQD_2100_3300 810941 108040 1 0.0000 0.0000
XQD_3300_3400 8697364 84497 1 0.0000 0.0000
XQS_1000_1200 21082893 3447 1 0.0000 0.0000
XQS_1000_3300 9143229 76617 1 0.0000 0.0000
XQS_1200_2000 10783745 71766 1 0.0000 0.0000
XQS_2100_3300 9256097 78276 1 0.0000 0.0000
XQS_3300_3400 568416 1986 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'  

01.03.24 04:11:00. 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-01 04:11:02 No severe PSQL-related problems occured
01.03.24 04:11:04. End of report.