Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.02.2024 04:10
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 15634624 kB
MemAvailable 30279520 kB
Buffers 20 kB
Cached 16055828 kB
SwapCached 2424 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-02-21 04:07:46
DTS_END                         2024-02-21 04:07:46.7910
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/44338
TRN_ID                          172879
ATT_ID                          574
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: 9216.74 19214 921674
customer order: creation 182.13 438 18213
customer order: refuse 15.50 391 1550
order to supplier: creation 48.60 1381 4860
order to supplier: removal 3.74 87730 374
invoice (draft): creation 48.42 3370 4842
invoice (draft): removal 50.14 734 5014
invoice accept: apply 42.89 21542 4289
invoice accept: cancel 45.06 806 4506
customer reserve: creation 4078.63 210 407863
customer reserve: removal 4403.43 59 440343
realization accept: apply 85.56 211 8556
realization accept: cancel 80.00 135 8000
payment from customer: creation 61.77 131 6177
payment from customer: removal 5.80 66 580
payment to supplier: creation 50.51 175 5051
payment to supplier: removal 3.47 74 347
service: total inventory turnovers 3.85 3756 385
service: total monetary turnovers 6.18 528 618
service: aggregate perf. data 1.02 11973 102
service: refresh index statistics 0.04 250567 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 21-02-2024 04:10:31 to 21-02-2024 04:10:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4870
TEST_TIME 2 6248
TEST_TIME 3 5662
TEST_TIME 4 6067
TEST_TIME 5 6100
TEST_TIME 6 6006
TEST_TIME 7 6061
TEST_TIME 8 6025
TEST_TIME 9 6078
TEST_TIME 10 5979
TEST_TIME 11 5967
TEST_TIME 12 6053
TEST_TIME 13 6294
TEST_TIME 14 6770
TEST_TIME 15 7042
TEST_TIME 16 7427
TEST_TIME 17 7446
TEST_TIME 18 7549
TEST_TIME 19 7530
TEST_TIME 20 7968
TEST_TIME 21 8492
TEST_TIME 22 8619
TEST_TIME 23 8592
TEST_TIME 24 8596
TEST_TIME 25 8966
TEST_TIME 26 9702
TEST_TIME 27 9593
TEST_TIME 28 9518
TEST_TIME 29 9368
TEST_TIME 30 9332
TEST_TIME 31 9459
TEST_TIME 32 9336
TEST_TIME 33 9418
TEST_TIME 34 9739
TEST_TIME 35 9564
TEST_TIME 36 9408
TEST_TIME 37 9384
TEST_TIME 38 9297
TEST_TIME 39 9254
TEST_TIME 40 9237
TEST_TIME 41 9267
TEST_TIME 42 9296
TEST_TIME 43 9215
TEST_TIME 44 9339
TEST_TIME 45 9229
TEST_TIME 46 9165
TEST_TIME 47 9056
TEST_TIME 48 9043
TEST_TIME 49 9094
TEST_TIME 50 9073
TEST_TIME 51 9138
TEST_TIME 52 9224
TEST_TIME 53 9224
TEST_TIME 54 9391
TEST_TIME 55 9373
TEST_TIME 56 9407
TEST_TIME 57 9395
TEST_TIME 58 9502
TEST_TIME 59 9568
TEST_TIME 60 9540
TEST_TIME 61 9478
TEST_TIME 62 9364
TEST_TIME 63 9280
TEST_TIME 64 9275
TEST_TIME 65 9257
TEST_TIME 66 9189
TEST_TIME 67 9157
TEST_TIME 68 9140
TEST_TIME 69 9128
TEST_TIME 70 9083
TEST_TIME 71 9110
TEST_TIME 72 9146
TEST_TIME 73 9184
TEST_TIME 74 9165
TEST_TIME 75 9247
TEST_TIME 76 9260
TEST_TIME 77 9284
TEST_TIME 78 9274
TEST_TIME 79 9297
TEST_TIME 80 9333
TEST_TIME 81 9303
TEST_TIME 82 9234
TEST_TIME 83 9226
TEST_TIME 84 9200
TEST_TIME 85 9132
TEST_TIME 86 9085
TEST_TIME 87 9066
TEST_TIME 88 9029
TEST_TIME 89 9089
TEST_TIME 90 9053
TEST_TIME 91 9079
TEST_TIME 92 9095
TEST_TIME 93 9074
TEST_TIME 94 9100
TEST_TIME 95 9196
TEST_TIME 96 9180
TEST_TIME 97 9228
TEST_TIME 98 9273
TEST_TIME 99 9288
TEST_TIME 100 9232

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-02-2024 04:10:35 to 21-02-2024 04:10:38.

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 1296061 1296061 0 0.00 0 19376 8 0 0
doc_list_biud 1296060 1296060 0 0.00 0 83451 26 0 0
sp_add_invoice_to_stock 4380 4289 91 2.07 34 211409 21543 0 91
sp_cancel_adding_invoice 4506 4506 0 0.00 4 55628 807 0 0
sp_cancel_client_order 1550 1550 0 0.00 4 14398 391 0 0
sp_cancel_customer_reserve 440343 440343 0 0.00 0 21218 59 0 0
sp_cancel_pay_from_customer 580 580 0 0.00 2 2372 66 0 0
sp_cancel_pay_to_supplier 347 347 0 0.00 2 3625 74 0 0
sp_cancel_supplier_invoice 5023 5014 9 0.17 2 83453 734 0 9
sp_cancel_supplier_order 374 374 0 0.00 6 846112 87730 0 0
sp_cancel_write_off 8000 8000 0 0.00 1 9673 135 0 0
sp_client_order 18213 18213 0 0.00 3 21250 439 0 0
sp_customer_reserve 407863 407863 0 0.00 0 51101 210 0 0
sp_fill_shopping_cart 27907 27907 0 0.00 1 31937 41 0 0
sp_fill_shopping_cart_clo_res 407843 407843 0 0.00 0 18708 18 0 0
sp_get_clo_for_invoice 4266 4266 0 0.00 0 31324 337 0 0
sp_kill_cost_storno 13433 13433 0 0.00 0 5274 67 0 0
sp_kill_qstorno_ret_qs2qd 894074 894074 0 0.00 0 83449 32 0 0
sp_kill_qty_storno 472606 472606 0 0.00 0 83450 70 0 0
sp_lock_selected_doc 17874 17874 0 0.00 0 8214 4 0 0
sp_make_cost_storno 24048 24048 0 0.00 0 17525 66 0 0
sp_multiply_rows_for_pdistr 24047 24047 0 0.00 0 12024 35 0 0
sp_multiply_rows_for_qdistr 18213 18213 0 0.00 0 11957 214 0 0
sp_pay_from_customer 6177 6177 0 0.00 3 21222 132 0 0
sp_pay_to_supplier 5051 5051 0 0.00 5 23338 175 0 0
sp_payment_common 11228 11228 0 0.00 1 12189 20 0 0
sp_qd_handle_on_cancel_clo 1550 1550 0 0.00 0 8963 353 0 0
sp_qd_handle_on_invoice_upd_sts 8770 8770 0 0.00 0 22271 324 0 0
sp_qd_handle_on_reserve_upd_sts 8555 8555 0 0.00 0 12792 65 0 0
sp_reserve_write_off 8556 8556 0 0.00 6 19716 212 0 0
sp_supplier_invoice 4842 4842 0 0.00 6 81622 3370 0 0
sp_supplier_order 4860 4860 0 0.00 4 39217 1382 0 0
srv_aggregate_perf_data 102 102 0 0.00 1857 183727 11974 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1298 127029 37369 0 0
srv_find_qd_qs_mism 878264 878264 0 0.00 0 19376 7 0 0
srv_make_invnt_saldo 385 385 0 0.00 47 100558 3757 0 0
srv_make_money_saldo 618 618 0 0.00 1 11431 529 0 0
srv_recalc_idx_stat 4 4 0 0.00 188564 363349 250568 0 0
t$perf-abend:sp_add_invoice_to_stock 91 91 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 4289 4289 0 0.00 0 21477 202 0 0
t$perf-norm:sp_cancel_adding_invoice 355 355 0 0.00 0 5077 92 0 0
t$perf-norm:sp_cancel_client_order 1550 1550 0 0.00 0 26306 29 0 0
t$perf-norm:sp_cancel_customer_reserve 614 614 0 0.00 0 709 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 580 580 0 0.00 0 3472 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 347 347 0 0.00 0 214 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 357 357 0 0.00 0 545 10 0 0
t$perf-norm:sp_cancel_supplier_order 374 374 0 0.00 0 21470 1442 0 0
t$perf-norm:sp_cancel_write_off 879 879 0 0.00 0 2935 10 0 0
t$perf-norm:sp_client_order 18213 18213 0 0.00 0 9888 19 0 0
t$perf-norm:sp_customer_reserve 873 873 0 0.00 0 2096 8 0 0
t$perf-norm:sp_pay_from_customer 6177 6177 0 0.00 0 3565 8 0 0
t$perf-norm:sp_pay_to_supplier 5051 5051 0 0.00 0 9215 10 0 0
t$perf-norm:sp_reserve_write_off 8556 8556 0 0.00 0 25914 14 0 0
t$perf-norm:sp_supplier_invoice 4842 4842 0 0.00 0 22068 18 0 0
t$perf-norm:sp_supplier_order 4860 4860 0 0.00 0 4455 12 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 111 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 267 6 0 0
t$perf-norm:srv_make_invnt_saldo 385 385 0 0.00 0 434 6 0 0
t$perf-norm:srv_make_money_saldo 618 618 0 0.00 0 1461 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 0 20 7 0 0
v_add_invoice_to_stock 8710 8528 182 2.08 0 18004 20 0 182
v_all_customers 33814 33814 0 0.00 0 26 1 0 0
v_all_suppliers 27492 27492 0 0.00 0 37 1 0 0
v_all_wares 36424 36424 0 0.00 0 34 1 0 0
v_cancel_adding_invoice 710 710 0 0.00 0 3368 11 0 0
v_cancel_client_order 3100 3100 0 0.00 0 13248 11 0 0
v_cancel_customer_prepayment 1160 1160 0 0.00 0 770 5 0 0
v_cancel_customer_reserve 1228 1228 0 0.00 0 842 4 0 0
v_cancel_payment_to_supplier 694 694 0 0.00 0 899 6 0 0
v_cancel_supplier_invoice 732 714 18 2.45 0 427 11 0 18
v_cancel_supplier_order 748 748 0 0.00 0 2210 7 0 0
v_cancel_write_off 1758 1758 0 0.00 0 2159 15 0 0
v_max_id_clo_ord 4860 4860 0 0.00 0 945 2 0 0
v_max_id_clo_res 873 873 0 0.00 0 2758 11 0 0
v_max_id_ord_sup 4834 4834 0 0.00 0 9269 6 0 0
v_max_non_paid_invoice 999 999 0 0.00 0 267 2 0 0
v_max_non_paid_realizn 2950 2950 0 0.00 0 3832 4 0 0
v_min_id_clo_ord 4860 4860 0 0.00 0 6589 8 0 0
v_min_id_clo_res 873 873 0 0.00 0 661 3 0 0
v_min_id_ord_sup 4834 4834 0 0.00 0 4539 5 0 0
v_min_non_paid_invoice 5051 5051 0 0.00 0 12181 16 0 0
v_min_non_paid_realizn 6177 6177 0 0.00 0 8103 13 0 0
v_our_firm 9064 9064 0 0.00 0 26 1 0 0
v_reserve_write_off 17106 17106 0 0.00 0 17793 9 0 0
x_lock_depdocs_on_canc_invoice 9163 9163 0 0.00 0 14073 113 0 0
x_lock_depdocs_on_canc_sup_ord 374 374 0 0.00 0 8917 352 0 0
x_make_qstorno_1000_1200 4860 4860 0 0.00 1 33546 1303 0 0
x_make_qstorno_1200_2000 4842 4842 0 0.00 2 81610 3215 0 0
x_make_qstorno_2100_3300 407863 407863 0 0.00 0 39097 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-02-2024 04:10:39 to 21-02-2024 04:10:43.

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:50 1138 8192000000 8938074352 8997486592 11424000 0.139 4 2 4 0 11839424 120848 294576
02:08:52 5113 8192000000 9701787552 9992622080 781759056 8.711 100 88 173 0 809883952 6921200 21203696
02:10:05 27827 8192000000 9747128912 10049081344 812695120 9.025 100 84 168 0 842904320 10073184 20136016
02:11:41 13040 8192000000 9780817648 10091982848 845695504 9.357 100 89 178 0 883269552 16797168 20776880
02:13:08 11249 8192000000 9840664176 10166013952 887199168 9.771 100 78 156 0 940903792 36706976 16997648
02:14:25 11125 8192000000 9890043568 10228813824 919664640 10.093 100 78 155 1 989738256 53449952 16623664
02:15:44 5275 8192000000 9930600016 10276937728 953261760 10.423 100 79 156 0 1034182960 64396576 16524624
02:16:52 2284 8192000000 9956540608 10311921664 985289472 10.736 100 81 158 1 1060917904 59594192 16034240
02:17:55 1991 8192000000 10012097040 10374217728 1012262944 10.997 100 85 168 0 1108770160 79809472 16697744
02:18:58 1029 8192000000 10013274304 10383659008 1034857504 11.215 100 84 169 0 1111548848 59147696 17543648
02:20:01 1540 8192000000 10038266000 10411233280 1053784176 11.397 100 89 178 1 1130566144 58319680 18462288
02:21:03 3826 8192000000 9987918448 10372632576 1055003936 11.409 100 59 118 0 1089262144 21958032 12300176
02:22:08 4950 8192000000 9996524000 10393534464 1064509232 11.500 100 34 67 1 1111525792 40373968 6642592
02:23:15 4833 8192000000 9989273600 10398896128 1070021856 11.552 100 16 32 0 1103024352 29716752 3285744
02:24:22 9230 8192000000 10012954320 10418298880 1079989296 11.647 100 20 37 0 1102648112 18585920 4072896
02:25:32 44529 8192000000 10011204208 10408611840 1081192608 11.659 100 53 106 2 1109595936 16219296 12184032
02:27:18 8371 8192000000 9999319168 10411053056 1086513808 11.709 100 25 50 0 1119037664 27354864 5168992
02:28:30 3665 8192000000 10044951808 10441326592 1085738912 11.702 100 59 118 0 1142760752 44183056 12838784
02:29:42 4693 8192000000 10062997808 10463514624 1100820704 11.845 100 51 100 0 1166129360 55579040 9729616
02:30:51 26184 8192000000 10067917952 10487939072 1090955792 11.752 99 36 72 0 1176239136 78070464 7212880
02:32:31 16215 8192000000 10090713888 10506027008 1104895632 11.884 100 50 100 0 1182953344 67302480 10755232
02:33:54 10588 8192000000 10104523024 10509365248 1112968912 11.961 99 55 106 0 1203205952 78280128 11956912
02:35:08 21526 8192000000 10124534448 10536325120 1120786304 12.034 100 36 68 1 1222178432 93455712 7936416
02:36:37 14878 8192000000 10152938640 10566479872 1096776000 11.807 98 43 86 0 1245358544 139338000 9244544
02:37:54 14871 8192000000 10189740016 10602156032 1111153840 11.943 99 51 103 1 1271993264 149202176 11637248
02:39:13 13404 8192000000 10192510272 10584899584 1089070112 11.734 99 61 122 0 1283187376 180972336 13144928
02:40:37 7921 8192000000 10190240384 10604830720 1088620048 11.730 99 40 79 0 1288474640 190259792 9594800
02:42:01 20057 8192000000 10215935456 10621198336 1121225696 12.039 100 58 116 1 1319478256 186158960 12093600
02:43:32 1296 8192000000 10187009760 10591825920 1100514128 11.843 100 79 152 0 1286147680 168769712 16863840
02:44:38 3384 8192000000 10219206976 10619105280 1117126432 12.000 100 66 132 0 1324222544 193514480 13581632
02:45:44 1391 8192000000 10271152896 10666541056 1121386688 12.040 100 84 168 2 1374958784 234095792 19476304
02:46:50 6550 8192000000 10293715232 10705965056 1118392848 12.012 100 71 142 0 1384284272 249476656 16414768
02:48:01 7610 8192000000 10270149952 10698899456 1125962496 12.083 100 61 122 1 1394425184 254040880 14421808
02:49:19 1751 8192000000 10243238176 10646929408 1129226064 12.114 100 62 119 1 1342314864 199442512 13646288
02:50:24 42991 8192000000 10235584144 10658320384 1132537408 12.145 100 46 91 0 1338882800 195517024 10828368
02:52:16 28507 8192000000 10214649104 10724851712 1107934528 11.913 99 18 36 2 1309526240 196935632 4656080
02:55:34 31132 8192000000 10044946288 10491449344 1115849120 11.988 100 18 36 0 1147852800 28417072 3586608
02:57:21 13539 8192000000 10096847840 10509053952 1125959904 12.083 100 57 108 3 1187410896 49576672 11874320
02:58:38 45520 8192000000 10100796768 10534858752 1122138912 12.047 99 18 38 0 1162186688 36071168 3976608
03:00:27 49038 8192000000 10097312256 10619273216 1133953184 12.159 100 13 26 0 1282336048 145169984 3212880
03:02:23 106880 8192000000 10121986544 10565369856 1131728896 12.138 99 50 101 2 1186228112 41918352 12580864
03:05:16 73124 8192000000 10102986096 10539585536 1139763744 12.213 99 25 46 0 1185555008 40615280 5175984
03:07:33 38140 8192000000 10137032464 10563981312 1128338016 12.106 98 45 91 1 1215064912 76130640 10596256
03:09:19 32324 8192000000 10107284096 10556125184 1146914784 12.281 100 24 48 0 1203138608 50736080 5487744
03:10:58 40699 8192000000 10129125120 10578239488 1142821840 12.242 99 37 72 1 1231420224 81512480 7085904
03:12:42 30142 8192000000 10094882064 10548314112 1151376112 12.322 100 21 42 0 1197935856 42230784 4328960
03:15:16 43409 8192000000 10114521280 10586411008 1145909200 12.271 99 8 16 1 1202802272 54876640 2016432
03:17:02 23413 8192000000 10126319280 10552119296 1145691376 12.269 99 50 99 1 1218325968 61944832 10689760
03:18:25 40193 8192000000 10089110544 10547408896 1128230352 12.105 98 32 63 0 1172780400 38103952 6446096
03:20:18 24888 8192000000 10120538176 10545053696 1118577520 12.014 98 28 56 1 1177136944 52612464 5946960
03:21:43 53756 8192000000 10046784752 10512691200 1091219984 11.754 97 10 20 0 1137513024 44170272 2122768
03:23:39 44193 8192000000 10060649824 10527961088 1095926208 11.799 98 30 61 0 1167662640 65649744 6086688
03:25:40 94840 8192000000 10055059360 10532675584 1059499344 11.452 94 10 20 0 1117364960 55822512 2043104
03:28:16 127029 8192000000 10015902288 10451628032 1088106896 11.725 99 26 52 0 1139097312 45733504 5256912
03:31:24 56234 8192000000 10032253728 10524176384 1085696176 11.702 98 38 74 1 1154279696 60497952 8085568
03:33:23 23457 8192000000 10046273232 10520440832 1110334256 11.936 100 7 14 0 1158408480 46505504 1568720
03:34:53 37259 8192000000 10026522464 10489585664 1086612848 11.710 98 22 44 1 1133275312 41219776 5442688
03:36:42 40929 8192000000 10024443712 10449260544 1081829728 11.665 98 14 28 0 1110215840 24957232 3428880
03:38:23 48732 8192000000 10080486560 10515656704 1111943904 11.951 100 27 50 0 1168215280 50647792 5623584
03:40:17 63254 8192000000 10068503184 10491154432 1077404048 11.623 96 19 38 0 1114663872 33661744 3598080
03:42:27 41714 8192000000 10054392960 10488909824 1098752272 11.826 98 12 25 0 1124385856 23327888 2305696
03:44:09 69578 8192000000 10086124016 10525347840 1137322160 12.190 100 16 32 1 1214493376 73882224 3288992
03:46:24 30141 8192000000 10121151792 10579521536 1133533216 12.155 99 41 81 0 1212306704 70722624 8050864
03:48:01 89724 8192000000 10083419152 10563379200 1134182128 12.161 99 22 44 0 1191087168 52521728 4383312
03:50:31 16026 8192000000 10109638592 10561601536 1141661536 12.231 100 23 47 0 1215541216 69094864 4784816
03:52:06 49002 8192000000 10070805328 10519994368 1149912592 12.309 100 22 44 0 1179122752 24497680 4712480
03:54:25 57652 8192000000 10085804320 10568986624 1146315728 12.275 100 4 8 0 1182146528 35078000 752800
03:56:23 54776 8192000000 10102979664 10581909504 1143983008 12.253 99 8 16 0 1180413680 34860016 1570656
03:58:18 84519 8192000000 10106007696 10586714112 1155685504 12.363 100 17 34 0 1209029136 49988304 3355328
04:00:43 66655 8192000000 10182932800 10646835200 1110621200 11.938 95 26 52 0 1220535024 104102560 5811264
04:02:53 40797 8192000000 10093248080 10534219776 1126409488 12.088 98 27 54 1 1181943296 49849808 5684000
04:05:01 23998 8192000000 10104575232 10560454656 1133744576 12.157 99 30 60 0 1196711872 57129152 5838144
04:06:26 38441 8192000000 10114121824 10574159872 1092323696 11.765 96 36 70 0 1155329200 55718320 7287184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 21-02-2024 04:10:45 to 21-02-2024 04:10:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 91 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 21-02-2024 04:11:00 to 21-02-2024 04:11:02.

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          170864
MON$OLDEST_ACTIVE               173190
MON$OLDEST_SNAPSHOT             173190
MON$NEXT_TRANSACTION            173190
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                       1924192
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             694
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 Wed Feb 21 04:11:03 2024 
 
Database header page information: 
    Flags            0 
    Generation        90439 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    170864 
    Oldest active        173190 
    Oldest snapshot        173190 
    Next transaction    173191 
    Sequence number        0 
    Next attachment ID    694 
    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.70, total records: 7694942 
    Average version length: 48.15, total versions: 38622, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88624 
    Data pages: 88624, average fill: 69% 
    Primary pages: 88624, secondary pages: 0, swept pages: 46981 
    Empty pages: 4, full pages: 59405 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 75 
    40 - 59% = 1888 
    60 - 79% = 86632 
    80 - 99% = 16 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23161, nodes: 7694942 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1679533, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 344 
        20 - 39% = 1981 
        40 - 59% = 3936 
        60 - 79% = 2490 
        80 - 99% = 14410 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13461, nodes: 7694942 
    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: 1502891, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1682 
        40 - 59% = 1922 
        60 - 79% = 1182 
        80 - 99% = 8673 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8278, nodes: 7694942 
    Average node length: 6.60, total dup: 5775253, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1495971, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 1043 
        40 - 59% = 1296 
        60 - 79% = 990 
        80 - 99% = 4839 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.96, total records: 2210404 
    Average version length: 58.83, total versions: 21293, 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: 28512 
    Data pages: 28512, average fill: 71% 
    Primary pages: 28511, secondary pages: 1, swept pages: 16359 
    Empty pages: 6, full pages: 14347 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 51 
    40 - 59% = 622 
    60 - 79% = 27779 
    80 - 99% = 49 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4510, nodes: 2210404 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674674, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 954 
        40 - 59% = 789 
        60 - 79% = 772 
        80 - 99% = 1995 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2402, nodes: 2211231 
    Average node length: 4.97, total dup: 2210332, max dup: 17851 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1256605, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 235 
        40 - 59% = 1355 
        60 - 79% = 563 
        80 - 99% = 248 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1764, nodes: 2210404 
    Average node length: 4.97, total dup: 2210354, max dup: 130268 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1055587, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 609 
        60 - 79% = 48 
        80 - 99% = 1097 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4330, nodes: 2210404 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674674, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 608 
        40 - 59% = 610 
        60 - 79% = 855 
        80 - 99% = 2149 
 
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.39, total records: 400 
    Average version length: 26.99, total versions: 3428, max versions: 9 
    Average fragment length: 2.67, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 59% 
    Primary pages: 10, secondary pages: 30, swept pages: 0 
    Empty pages: 3, full pages: 17 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 19 
 
    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: 12.98, total records: 144035 
    Average version length: 68.30, total versions: 134360, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.78 
    Pointer pages: 6, data page slots: 3080 
    Data pages: 2752, average fill: 71% 
    Primary pages: 2751, secondary pages: 1, swept pages: 145 
    Empty pages: 330, full pages: 1878 
    Fill distribution: 
     0 - 19% = 414 
    20 - 39% = 111 
    40 - 59% = 200 
    60 - 79% = 336 
    80 - 99% = 1691 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702193, depth: 3, leaf buckets: 401, nodes: 144035 
    Average node length: 13.12, total dup: 12227, max dup: 2 
    Average key length: 10.53, compression ratio: 2.56 
    Average prefix length: 19.38, average data length: 7.62 
    Clustering factor: 105800, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 13 
        40 - 59% = 211 
        60 - 79% = 161 
        80 - 99% = 14 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 247, max versions: 11 
    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: 6 
    Data pages: 6, average fill: 17% 
    Primary pages: 1, secondary pages: 5, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    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: 13.78, total records: 2356 
    Average version length: 43.60, total versions: 2029, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.21 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 61% 
    Primary pages: 38, secondary pages: 2, swept pages: 0 
    Empty pages: 7, full pages: 22 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 96443, depth: 2, leaf buckets: 3, nodes: 2356 
    Average node length: 4.10, total dup: 2258, max dup: 302 
    Average key length: 2.45, compression ratio: 7.76 
    Average prefix length: 18.59, average data length: 0.41 
    Clustering factor: 1207, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        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.70, total records: 73 
    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: 51% 
    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 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    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.76, total records: 812368 
    Average version length: 37.89, total versions: 22945, 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: 8720 
    Data pages: 8720, average fill: 64% 
    Primary pages: 8719, secondary pages: 1, swept pages: 4063 
    Empty pages: 25, full pages: 3938 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 36 
    40 - 59% = 1137 
    60 - 79% = 7443 
    80 - 99% = 68 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 882, nodes: 804148 
    Average node length: 4.88, total dup: 804099, max dup: 155249 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91209, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 145 
        40 - 59% = 481 
        60 - 79% = 158 
        80 - 99% = 97 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 943, nodes: 804148 
    Average node length: 5.89, total dup: 716043, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160728, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 529 
        60 - 79% = 95 
        80 - 99% = 288 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 978, nodes: 804148 
    Average node length: 5.89, total dup: 716043, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162604, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 80 
        40 - 59% = 535 
        60 - 79% = 95 
        80 - 99% = 268 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1137, nodes: 804148 
    Average node length: 5.97, total dup: 716043, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154980, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 195 
        40 - 59% = 676 
        60 - 79% = 178 
        80 - 99% = 86 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.96, total records: 5500 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.22, total fragments: 27, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 80, secondary pages: 16, swept pages: 62 
    Empty pages: 14, full pages: 70 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5500 
    Average node length: 5.52, 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: 5285, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5500 
    Average node length: 11.16, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 169, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 79010 
    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: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 820 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 820 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37495, depth: 2, leaf buckets: 102, nodes: 79010 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3126, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
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: 111.07, 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.22 
    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: 147.87, total records: 179745 
    Average version length: 151.50, total versions: 4298, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 7, data page slots: 5720 
    Data pages: 4536, average fill: 82% 
    Primary pages: 4532, secondary pages: 4, swept pages: 6 
    Empty pages: 104, full pages: 4404 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4403 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 144.74, total records: 149836 
    Average version length: 153.43, total versions: 6600, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 7, data page slots: 5240 
    Data pages: 3752, average fill: 83% 
    Primary pages: 3750, secondary pages: 2, swept pages: 3 
    Empty pages: 60, full pages: 3668 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3668 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.00, total records: 131187 
    Average version length: 149.52, total versions: 1795, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 3632 
    Data pages: 3280, average fill: 82% 
    Primary pages: 3278, secondary pages: 2, swept pages: 1 
    Empty pages: 50, full pages: 3212 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3212 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 145.55, total records: 139834 
    Average version length: 152.55, total versions: 5470, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 6, data page slots: 4248 
    Data pages: 3504, average fill: 83% 
    Primary pages: 3502, secondary pages: 2, swept pages: 5 
    Empty pages: 57, full pages: 3425 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 3427 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 137.58, total records: 169390 
    Average version length: 154.56, total versions: 16133, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.33 
    Pointer pages: 8, data page slots: 5424 
    Data pages: 4216, average fill: 84% 
    Primary pages: 4215, secondary pages: 1, swept pages: 5 
    Empty pages: 39, full pages: 4156 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4157 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 147.95, total records: 167109 
    Average version length: 151.72, total versions: 3968, 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: 6, data page slots: 5408 
    Data pages: 4200, average fill: 82% 
    Primary pages: 4197, secondary pages: 3, swept pages: 3 
    Empty pages: 69, full pages: 4092 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 14 
    40 - 59% = 8 
    60 - 79% = 10 
    80 - 99% = 4093 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 146.70, total records: 154872 
    Average version length: 152.37, total versions: 4715, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 6, data page slots: 6064 
    Data pages: 3944, average fill: 81% 
    Primary pages: 3942, secondary pages: 2, swept pages: 3 
    Empty pages: 105, full pages: 3762 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 13 
    40 - 59% = 40 
    60 - 79% = 20 
    80 - 99% = 3762 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.67, total records: 141793 
    Average version length: 151.77, total versions: 3082, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 4032 
    Data pages: 3520, average fill: 83% 
    Primary pages: 3518, secondary pages: 2, swept pages: 9 
    Empty pages: 38, full pages: 3467 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 3464 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 144.91, total records: 156201 
    Average version length: 154.05, total versions: 6798, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 6, data page slots: 4736 
    Data pages: 3944, average fill: 82% 
    Primary pages: 3941, secondary pages: 3, swept pages: 4 
    Empty pages: 82, full pages: 3814 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 12 
    40 - 59% = 26 
    60 - 79% = 4 
    80 - 99% = 3815 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 130.77, total records: 169025 
    Average version length: 154.70, total versions: 24034, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.97 
    Pointer pages: 6, data page slots: 4688 
    Data pages: 4240, average fill: 84% 
    Primary pages: 4238, secondary pages: 2, swept pages: 7 
    Empty pages: 68, full pages: 4144 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 4145 
 
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.32, total records: 2068832 
    Average version length: 52.95, total versions: 20060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25696 
    Data pages: 25696, average fill: 69% 
    Primary pages: 25680, secondary pages: 16, swept pages: 12645 
    Empty pages: 219, full pages: 21178 
    Fill distribution: 
     0 - 19% = 424 
    20 - 39% = 361 
    40 - 59% = 1128 
    60 - 79% = 23593 
    80 - 99% = 190 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2556, nodes: 2068832 
    Average node length: 5.44, total dup: 1929805, max dup: 1773 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180014, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 314 
        40 - 59% = 1641 
        60 - 79% = 294 
        80 - 99% = 303 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2749, nodes: 2068832 
    Average node length: 5.70, total dup: 1856418, max dup: 71 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370587, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2463 
        60 - 79% = 254 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2097, nodes: 2068832 
    Average node length: 4.96, total dup: 2068732, max dup: 27513 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177854, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 215 
        40 - 59% = 1089 
        60 - 79% = 345 
        80 - 99% = 447 
 
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: 46.55, total records: 131162 
    Average version length: 69.16, total versions: 49382, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.71 
    Pointer pages: 3, data page slots: 4224 
    Data pages: 2864, average fill: 55% 
    Primary pages: 2863, secondary pages: 1, swept pages: 277 
    Empty pages: 235, full pages: 650 
    Fill distribution: 
     0 - 19% = 297 
    20 - 39% = 227 
    40 - 59% = 895 
    60 - 79% = 1198 
    80 - 99% = 247 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554405, depth: 3, leaf buckets: 228, nodes: 131162 
    Average node length: 6.57, total dup: 114090, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 23393, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 65 
        40 - 59% = 116 
        60 - 79% = 47 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.21, total records: 6991308 
    Average version length: 68.74, total versions: 203651, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 66, data page slots: 107472 
    Data pages: 106880, average fill: 70% 
    Primary pages: 106879, secondary pages: 1, swept pages: 54736 
    Empty pages: 81, full pages: 48990 
    Fill distribution: 
     0 - 19% = 138 
    20 - 39% = 553 
    40 - 59% = 7902 
    60 - 79% = 97828 
    80 - 99% = 459 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10708, nodes: 6991308 
    Average node length: 6.51, total dup: 6048401, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1642181, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1743 
        40 - 59% = 5935 
        60 - 79% = 2597 
        80 - 99% = 425 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8507, nodes: 6991308 
    Average node length: 5.40, total dup: 6711500, max dup: 128 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1452309, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1301 
        40 - 59% = 4665 
        60 - 79% = 1518 
        80 - 99% = 1018 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8590, nodes: 6991308 
    Average node length: 5.40, total dup: 6711500, max dup: 128 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1454537, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1394 
        40 - 59% = 4646 
        60 - 79% = 1535 
        80 - 99% = 1009 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.87, total records: 11994824 
    Average version length: 68.75, total versions: 213467, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 108, data page slots: 175920 
    Data pages: 175552, average fill: 73% 
    Primary pages: 175551, secondary pages: 1, swept pages: 98156 
    Empty pages: 10, full pages: 128472 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 379 
    40 - 59% = 5606 
    60 - 79% = 168206 
    80 - 99% = 1326 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18447, nodes: 11993379 
    Average node length: 6.62, total dup: 10459305, max dup: 55 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2456943, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2453 
        40 - 59% = 10680 
        60 - 79% = 4560 
        80 - 99% = 727 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 55.24, total records: 1394235 
    Average version length: 69.10, total versions: 190518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.28 
    Pointer pages: 27, data page slots: 42936 
    Data pages: 29648, average fill: 49% 
    Primary pages: 29569, secondary pages: 79, swept pages: 12977 
    Empty pages: 4153, full pages: 13913 
    Fill distribution: 
     0 - 19% = 6931 
    20 - 39% = 4201 
    40 - 59% = 3365 
    60 - 79% = 12746 
    80 - 99% = 2405 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1879, nodes: 1262163 
    Average node length: 5.53, total dup: 1210972, max dup: 49 
    Average key length: 2.57, compression ratio: 16.32 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 89068, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 610 
        40 - 59% = 935 
        60 - 79% = 316 
        80 - 99% = 11 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 48.94, total records: 929958 
    Average version length: 69.04, total versions: 97697, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.57 
    Pointer pages: 20, data page slots: 31632 
    Data pages: 25408, average fill: 36% 
    Primary pages: 25408, secondary pages: 0, swept pages: 8699 
    Empty pages: 3715, full pages: 1205 
    Fill distribution: 
     0 - 19% = 6458 
    20 - 39% = 6591 
    40 - 59% = 8791 
    60 - 79% = 3547 
    80 - 99% = 21 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1177, nodes: 716450 
    Average node length: 5.95, total dup: 660244, max dup: 60 
    Average key length: 3.02, compression ratio: 13.93 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 102761, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 428 
        40 - 59% = 597 
        60 - 79% = 141 
        80 - 99% = 11 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.40, total records: 8900689 
    Average version length: 68.90, total versions: 220340, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 89, data page slots: 144736 
    Data pages: 144712, average fill: 66% 
    Primary pages: 144693, secondary pages: 19, swept pages: 82323 
    Empty pages: 434, full pages: 56196 
    Fill distribution: 
     0 - 19% = 1511 
    20 - 39% = 6587 
    40 - 59% = 24945 
    60 - 79% = 110293 
    80 - 99% = 1376 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13468, nodes: 8898769 
    Average node length: 6.69, total dup: 7379728, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2007483, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1557 
        40 - 59% = 7296 
        60 - 79% = 4131 
        80 - 99% = 484 
 
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: 21145650 
    Average version length: 82.88, total versions: 6787, 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: 319816 
    Data pages: 319816, average fill: 81% 
    Primary pages: 319812, secondary pages: 4, swept pages: 13422 
    Empty pages: 48, full pages: 318892 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 51 
    40 - 59% = 139 
    60 - 79% = 49386 
    80 - 99% = 270169 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19516, nodes: 21145650 
    Average node length: 5.72, total dup: 20664766, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283158, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8404 
        60 - 79% = 545 
        80 - 99% = 10559 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17192, nodes: 21145650 
    Average node length: 6.31, total dup: 18582989, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917498, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 823 
        60 - 79% = 267 
        80 - 99% = 16098 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21319, nodes: 21145650 
    Average node length: 6.35, total dup: 18501722, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577040, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 3 
        40 - 59% = 8706 
        60 - 79% = 617 
        80 - 99% = 11986 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16137, nodes: 21145650 
    Average node length: 5.56, total dup: 21145550, max dup: 231227 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946251, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 12 
        40 - 59% = 2959 
        60 - 79% = 377 
        80 - 99% = 12787 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.36, total records: 9953277 
    Average version length: 82.59, total versions: 820860, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 106, data page slots: 172624 
    Data pages: 172568, average fill: 72% 
    Primary pages: 172540, secondary pages: 28, swept pages: 38563 
    Empty pages: 415, full pages: 124276 
    Fill distribution: 
     0 - 19% = 1383 
    20 - 39% = 5839 
    40 - 59% = 20795 
    60 - 79% = 110544 
    80 - 99% = 34007 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11363, nodes: 9953277 
    Average node length: 5.36, total dup: 9643850, max dup: 239 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2238515, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 24 
        40 - 59% = 7443 
        60 - 79% = 3767 
        80 - 99% = 126 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13641, nodes: 9953277 
    Average node length: 6.24, total dup: 8254127, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1573802, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 3691 
        40 - 59% = 4550 
        60 - 79% = 2609 
        80 - 99% = 2651 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12679, nodes: 9953277 
    Average node length: 5.98, total dup: 8652304, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2438973, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 33 
        40 - 59% = 8371 
        60 - 79% = 4097 
        80 - 99% = 176 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10337, nodes: 9953277 
    Average node length: 5.14, total dup: 9953177, max dup: 164361 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1599773, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1222 
        40 - 59% = 5150 
        60 - 79% = 1724 
        80 - 99% = 2202 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.07, total records: 11442180 
    Average version length: 82.45, total versions: 504431, max versions: 1 
    Average fragment length: 72.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 120, data page slots: 194464 
    Data pages: 193208, average fill: 73% 
    Primary pages: 193070, secondary pages: 138, swept pages: 57721 
    Empty pages: 2427, full pages: 150835 
    Fill distribution: 
     0 - 19% = 3989 
    20 - 39% = 5964 
    40 - 59% = 16545 
    60 - 79% = 98234 
    80 - 99% = 68476 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13126, nodes: 11442180 
    Average node length: 5.31, total dup: 11332559, max dup: 619 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2407227, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 80 
        40 - 59% = 8783 
        60 - 79% = 4111 
        80 - 99% = 147 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10503, nodes: 11442180 
    Average node length: 5.50, total dup: 10943175, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 745802, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 835 
        40 - 59% = 2561 
        60 - 79% = 1797 
        80 - 99% = 5174 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15003, nodes: 11442180 
    Average node length: 6.03, total dup: 9990292, max dup: 82 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2423634, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 101 
        40 - 59% = 10273 
        60 - 79% = 4435 
        80 - 99% = 194 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10919, nodes: 11442180 
    Average node length: 5.23, total dup: 11442080, max dup: 196661 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 734135, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 822 
        40 - 59% = 4970 
        60 - 79% = 1499 
        80 - 99% = 3542 
 
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: 76.80, total records: 10057168 
    Average version length: 82.87, total versions: 809817, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 109, data page slots: 176992 
    Data pages: 176936, average fill: 71% 
    Primary pages: 176908, secondary pages: 28, swept pages: 42190 
    Empty pages: 647, full pages: 123079 
    Fill distribution: 
     0 - 19% = 1790 
    20 - 39% = 6986 
    40 - 59% = 23698 
    60 - 79% = 110970 
    80 - 99% = 33492 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11997, nodes: 10057168 
    Average node length: 5.19, total dup: 10028161, max dup: 2234 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2066497, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1310 
        40 - 59% = 8032 
        60 - 79% = 2000 
        80 - 99% = 628 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13745, nodes: 10057168 
    Average node length: 6.26, total dup: 8339870, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1540137, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 191 
        20 - 39% = 3645 
        40 - 59% = 4531 
        60 - 79% = 2601 
        80 - 99% = 2777 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12633, nodes: 10057168 
    Average node length: 5.44, total dup: 9612344, max dup: 111 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2201971, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1334 
        40 - 59% = 8841 
        60 - 79% = 1785 
        80 - 99% = 647 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10601, nodes: 10057168 
    Average node length: 5.16, total dup: 10057068, max dup: 166753 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1633214, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1262 
        40 - 59% = 5469 
        60 - 79% = 1664 
        80 - 99% = 2155 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.12, total records: 579226 
    Average version length: 68.80, total versions: 10304, 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: 5, data page slots: 8056 
    Data pages: 8056, average fill: 75% 
    Primary pages: 8056, secondary pages: 0, swept pages: 2928 
    Empty pages: 0, full pages: 7505 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 3 
    40 - 59% = 60 
    60 - 79% = 7826 
    80 - 99% = 167 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45706, depth: 3, leaf buckets: 727, nodes: 579226 
    Average node length: 5.95, total dup: 493329, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101662, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 504 
        60 - 79% = 96 
        80 - 99% = 103 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35872, depth: 3, leaf buckets: 749, nodes: 579226 
    Average node length: 6.15, total dup: 475201, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101728, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 502 
        60 - 79% = 99 
        80 - 99% = 114 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 579226 
    Average node length: 4.86, total dup: 579126, max dup: 9389 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90411, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 26 
        40 - 59% = 329 
        60 - 79% = 62 
        80 - 99% = 142 
 
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 Wed Feb 21 04:11:27 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7694942 38622 1 0.0000 0.0000
DOC_LIST 2210404 21293 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3428 9 800.0000 0.0000
INVNT_TURNOVER_LOG 144035 134360 1 0.0000 0.0000
MONEY_SALDO 49 247 11 500.0000 0.0000
MONEY_TURNOVER_LOG 2356 2029 1 0.0000 0.0000
PDISTR 812368 22945 2 0.0000 0.0000
PERF_SPLIT_0 179745 4298 1 0.0000 0.0000
PERF_SPLIT_1 149836 6600 1 0.0000 0.0000
PERF_SPLIT_2 131187 1795 1 0.0000 0.0000
PERF_SPLIT_3 139834 5470 1 0.0000 0.0000
PERF_SPLIT_4 169390 16133 1 0.0000 0.0000
PERF_SPLIT_5 167109 3968 1 0.0000 0.0000
PERF_SPLIT_6 154872 4715 1 0.0000 0.0000
PERF_SPLIT_7 141793 3082 1 0.0000 0.0000
PERF_SPLIT_8 156201 6798 1 0.0000 0.0000
PERF_SPLIT_9 169025 24034 1 0.0000 0.0000
PSTORNED 2068832 20060 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 131162 49382 1 0.0000 0.0000
XQD_1000_3300 6991308 203651 1 0.0000 0.0000
XQD_1200_2000 11994824 213467 1 0.0000 0.0000
XQD_2000_3300 1394235 190518 1 0.0000 0.0000
XQD_2100_3300 929958 97697 1 0.0000 0.0000
XQD_3300_3400 8900689 220340 1 0.0000 0.0000
XQS_1000_1200 21145650 6787 1 0.0000 0.0000
XQS_1000_3300 9953277 820860 1 0.0000 0.0000
XQS_1200_2000 11442180 504431 1 0.0000 0.0000
XQS_2100_3300 10057168 809817 1 0.0000 0.0000
XQS_3300_3400 579226 10304 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 ---
:109: 
:110: mscs-test-161.budzdorov.ru    Wed Feb 21 04:08:04 2024
:111:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:112: 
:113: 
:114: mscs-test-161.budzdorov.ru    Wed Feb 21 04:09:01 2024
:115:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:116: 
:117: 
:118: mscs-test-161.budzdorov.ru    Wed Feb 21 04:09:02 2024
:119:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:120: 
--- end of diff output ---

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

21.02.24 04:11:39. 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-02-21 04:11:41 No severe PSQL-related problems occured
21.02.24 04:11:43. End of report.