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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-31 13:07:51
DTS_END                         2024-03-31 13:07:51.9920
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/52286
TRN_ID                          172148
ATT_ID                          485
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: 9407.31 21332 940731
customer order: creation 173.65 449 17365
customer order: refuse 14.79 409 1479
order to supplier: creation 46.82 1341 4682
order to supplier: removal 3.71 85921 371
invoice (draft): creation 46.45 3233 4645
invoice (draft): removal 50.59 725 5059
invoice accept: apply 44.20 20625 4420
invoice accept: cancel 45.39 803 4539
customer reserve: creation 4200.51 199 420051
customer reserve: removal 4485.53 56 448553
realization accept: apply 84.72 202 8472
realization accept: cancel 80.86 123 8086
payment from customer: creation 59.68 130 5968
payment from customer: removal 5.97 77 597
payment to supplier: creation 49.89 173 4989
payment to supplier: removal 3.26 101 326
service: total inventory turnovers 3.88 3960 388
service: total monetary turnovers 6.35 471 635
service: aggregate perf. data 1.03 15444 103
service: refresh index statistics 0.03 292206 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-03-2024 13:09:16 to 31-03-2024 13:09:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1530
TEST_TIME 2 3145
TEST_TIME 3 3666
TEST_TIME 4 3235
TEST_TIME 5 3397
TEST_TIME 6 4038
TEST_TIME 7 3881
TEST_TIME 8 4146
TEST_TIME 9 4362
TEST_TIME 10 4496
TEST_TIME 11 5997
TEST_TIME 12 6770
TEST_TIME 13 7002
TEST_TIME 14 7619
TEST_TIME 15 7664
TEST_TIME 16 7868
TEST_TIME 17 7928
TEST_TIME 18 8450
TEST_TIME 19 8517
TEST_TIME 20 8555
TEST_TIME 21 8801
TEST_TIME 22 8790
TEST_TIME 23 9410
TEST_TIME 24 9419
TEST_TIME 25 9330
TEST_TIME 26 9391
TEST_TIME 27 9900
TEST_TIME 28 9950
TEST_TIME 29 9966
TEST_TIME 30 9714
TEST_TIME 31 9589
TEST_TIME 32 9846
TEST_TIME 33 9935
TEST_TIME 34 9820
TEST_TIME 35 9685
TEST_TIME 36 9866
TEST_TIME 37 9768
TEST_TIME 38 9889
TEST_TIME 39 9875
TEST_TIME 40 9911
TEST_TIME 41 9946
TEST_TIME 42 10057
TEST_TIME 43 10154
TEST_TIME 44 10041
TEST_TIME 45 9829
TEST_TIME 46 9779
TEST_TIME 47 9646
TEST_TIME 48 9601
TEST_TIME 49 9550
TEST_TIME 50 9691
TEST_TIME 51 9639
TEST_TIME 52 9617
TEST_TIME 53 9559
TEST_TIME 54 9560
TEST_TIME 55 9574
TEST_TIME 56 9484
TEST_TIME 57 9427
TEST_TIME 58 9440
TEST_TIME 59 9362
TEST_TIME 60 9285
TEST_TIME 61 9382
TEST_TIME 62 9393
TEST_TIME 63 9350
TEST_TIME 64 9442
TEST_TIME 65 9522
TEST_TIME 66 9556
TEST_TIME 67 9554
TEST_TIME 68 9575
TEST_TIME 69 9633
TEST_TIME 70 9651
TEST_TIME 71 9694
TEST_TIME 72 9695
TEST_TIME 73 9746
TEST_TIME 74 9636
TEST_TIME 75 9593
TEST_TIME 76 9521
TEST_TIME 77 9518
TEST_TIME 78 9464
TEST_TIME 79 9398
TEST_TIME 80 9369
TEST_TIME 81 9324
TEST_TIME 82 9287
TEST_TIME 83 9305
TEST_TIME 84 9278
TEST_TIME 85 9303
TEST_TIME 86 9297
TEST_TIME 87 9310
TEST_TIME 88 9415
TEST_TIME 89 9477
TEST_TIME 90 9473
TEST_TIME 91 9467
TEST_TIME 92 9506
TEST_TIME 93 9605
TEST_TIME 94 9600
TEST_TIME 95 9515
TEST_TIME 96 9457
TEST_TIME 97 9510
TEST_TIME 98 9445
TEST_TIME 99 9402
TEST_TIME 100 9412

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 31-03-2024 13:09:20 to 31-03-2024 13:09:23.

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 1324458 1324458 0 0.00 0 20896 7 0 0
doc_list_biud 1324456 1324456 0 0.00 0 37943 24 0 0
sp_add_invoice_to_stock 4545 4420 125 2.75 25 200849 20625 0 125
sp_cancel_adding_invoice 4539 4539 0 0.00 4 45747 804 0 0
sp_cancel_client_order 1479 1479 0 0.00 4 15056 410 0 0
sp_cancel_customer_reserve 448553 448553 0 0.00 0 37969 57 0 0
sp_cancel_pay_from_customer 597 597 0 0.00 2 2333 77 0 0
sp_cancel_pay_to_supplier 326 326 0 0.00 2 4084 102 0 0
sp_cancel_supplier_invoice 5071 5059 12 0.23 2 22054 726 0 12
sp_cancel_supplier_order 371 371 0 0.00 5 764125 85922 0 0
sp_cancel_write_off 8086 8086 0 0.00 1 16507 124 0 0
sp_client_order 17365 17365 0 0.00 3 40090 450 0 0
sp_customer_reserve 420051 420051 0 0.00 0 78103 199 0 0
sp_fill_shopping_cart 26685 26685 0 0.00 1 27014 42 0 0
sp_fill_shopping_cart_clo_res 420045 420045 0 0.00 0 23907 19 0 0
sp_get_clo_for_invoice 4411 4411 0 0.00 0 47770 426 0 0
sp_kill_cost_storno 13548 13548 0 0.00 0 16284 76 0 0
sp_kill_qstorno_ret_qs2qd 910622 910622 0 0.00 0 37905 30 0 0
sp_kill_qty_storno 480970 480970 0 0.00 0 37943 66 0 0
sp_lock_selected_doc 17790 17790 0 0.00 0 19694 8 0 0
sp_make_cost_storno 23840 23840 0 0.00 0 14014 67 0 0
sp_multiply_rows_for_pdistr 23840 23840 0 0.00 0 10787 35 0 0
sp_multiply_rows_for_qdistr 17365 17365 0 0.00 0 22712 211 0 0
sp_pay_from_customer 5968 5968 0 0.00 4 35095 131 0 0
sp_pay_to_supplier 4989 4989 0 0.00 4 32597 174 0 0
sp_payment_common 10957 10957 0 0.00 1 15608 21 0 0
sp_qd_handle_on_cancel_clo 1479 1479 0 0.00 0 15028 371 0 0
sp_qd_handle_on_invoice_upd_sts 8950 8950 0 0.00 0 22589 306 0 0
sp_qd_handle_on_reserve_upd_sts 8472 8472 0 0.00 0 12432 63 0 0
sp_reserve_write_off 8472 8472 0 0.00 6 14210 203 0 0
sp_supplier_invoice 4645 4645 0 0.00 7 102406 3233 0 0
sp_supplier_order 4682 4682 0 0.00 5 38992 1341 0 0
srv_aggregate_perf_data 103 103 0 0.00 1593 138553 15445 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1969 154245 40548 0 0
srv_find_qd_qs_mism 896778 896778 0 0.00 0 20883 6 0 0
srv_make_invnt_saldo 388 388 0 0.00 40 89538 3960 0 0
srv_make_money_saldo 635 635 0 0.00 1 10061 471 0 0
srv_recalc_idx_stat 3 3 0 0.00 238767 394068 292207 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4420 4420 0 0.00 0 14293 205 0 0
t$perf-norm:sp_cancel_adding_invoice 346 346 0 0.00 1 6512 133 0 0
t$perf-norm:sp_cancel_client_order 1479 1479 0 0.00 0 6446 19 0 0
t$perf-norm:sp_cancel_customer_reserve 574 574 0 0.00 0 1108 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 597 597 0 0.00 0 2497 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 326 326 0 0.00 0 6889 34 0 0
t$perf-norm:sp_cancel_supplier_invoice 354 354 0 0.00 0 1474 14 0 0
t$perf-norm:sp_cancel_supplier_order 371 371 0 0.00 0 22593 1579 0 0
t$perf-norm:sp_cancel_write_off 860 860 0 0.00 0 1083 7 0 0
t$perf-norm:sp_client_order 17365 17365 0 0.00 0 13958 17 0 0
t$perf-norm:sp_customer_reserve 850 850 0 0.00 0 3695 10 0 0
t$perf-norm:sp_pay_from_customer 5968 5968 0 0.00 0 3889 10 0 0
t$perf-norm:sp_pay_to_supplier 4989 4989 0 0.00 0 13968 13 0 0
t$perf-norm:sp_reserve_write_off 8472 8472 0 0.00 0 13975 13 0 0
t$perf-norm:sp_supplier_invoice 4645 4645 0 0.00 0 6008 20 0 0
t$perf-norm:sp_supplier_order 4682 4682 0 0.00 0 6191 18 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 625 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 108 3 0 0
t$perf-norm:srv_make_invnt_saldo 388 388 0 0.00 0 975 6 0 0
t$perf-norm:srv_make_money_saldo 635 635 0 0.00 0 1168 10 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 23 10 0 0
v_add_invoice_to_stock 9072 8822 250 2.75 0 5678 19 0 250
v_all_customers 32496 32496 0 0.00 0 30 1 0 0
v_all_suppliers 26512 26512 0 0.00 0 72 1 0 0
v_all_wares 34730 34730 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 692 692 0 0.00 0 6604 18 0 0
v_cancel_client_order 2958 2958 0 0.00 0 5788 9 0 0
v_cancel_customer_prepayment 1194 1194 0 0.00 0 2310 8 0 0
v_cancel_customer_reserve 1148 1148 0 0.00 0 3284 6 0 0
v_cancel_payment_to_supplier 652 652 0 0.00 0 1297 8 0 0
v_cancel_supplier_invoice 732 708 24 3.27 0 2422 17 0 24
v_cancel_supplier_order 742 742 0 0.00 0 108 2 0 0
v_cancel_write_off 1720 1720 0 0.00 0 4158 17 0 0
v_max_id_clo_ord 4679 4679 0 0.00 0 221 1 0 0
v_max_id_clo_res 850 850 0 0.00 0 2344 9 0 0
v_max_id_ord_sup 4640 4640 0 0.00 0 5667 6 0 0
v_max_non_paid_invoice 1052 1052 0 0.00 0 77 2 0 0
v_max_non_paid_realizn 2844 2844 0 0.00 0 5616 5 0 0
v_min_id_clo_ord 4679 4679 0 0.00 0 5658 10 0 0
v_min_id_clo_res 850 850 0 0.00 0 5111 30 0 0
v_min_id_ord_sup 4640 4640 0 0.00 0 6925 10 0 0
v_min_non_paid_invoice 4989 4989 0 0.00 0 15605 13 0 0
v_min_non_paid_realizn 5968 5968 0 0.00 0 11251 15 0 0
v_our_firm 8482 8482 0 0.00 0 32 1 0 0
v_reserve_write_off 16942 16942 0 0.00 0 6852 7 0 0
x_lock_depdocs_on_canc_invoice 9244 9244 0 0.00 0 13617 120 0 0
x_lock_depdocs_on_canc_sup_ord 371 371 0 0.00 0 8817 339 0 0
x_make_qstorno_1000_1200 4682 4682 0 0.00 1 38976 1245 0 0
x_make_qstorno_1200_2000 4645 4645 0 0.00 2 99512 3085 0 0
x_make_qstorno_2100_3300 420051 420051 0 0.00 0 78102 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-03-2024 13:09:24 to 31-03-2024 13:09:28.

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
11:07:56 8 8192000000 8805136016 8818712576 9861008 0.120 4 2 3 0 10005440 83072 61360
11:08:57 21834 8192000000 9715878848 10018025472 798397856 8.880 100 86 172 0 825173568 7102976 19672736
11:10:24 17581 8192000000 9751934160 10059886592 829636368 9.196 100 89 178 0 861448544 11109888 20702288
11:11:54 13553 8192000000 9780259200 10097938432 853142544 9.432 100 88 176 0 889072528 16226016 19703968
11:13:16 15162 8192000000 9825201840 10154741760 887150352 9.771 100 83 167 0 939399696 34125632 18123712
11:14:36 8849 8192000000 9879633808 10223271936 924123104 10.137 100 73 144 1 996186608 57422656 14640848
11:15:48 4438 8192000000 9918970080 10269323264 958878640 10.478 100 82 165 0 1029537168 54809248 15849280
11:16:55 2764 8192000000 9976609584 10337935360 988962176 10.771 100 82 163 1 1095045744 90247888 15835680
11:18:01 1555 8192000000 9976858208 10341752832 1011653072 10.991 100 85 171 1 1093287488 65398080 16236336
11:19:04 1555 8192000000 10011151328 10384207872 1031071088 11.179 100 80 158 0 1122142128 76390688 14680352
11:20:07 32524 8192000000 9993448784 10380128256 1047545056 11.337 100 63 122 1 1117804352 58080912 12178384
11:21:42 6737 8192000000 9966890576 10370260992 1057008240 11.428 100 32 65 1 1090012304 26539760 6464304
11:22:50 11245 8192000000 9978319712 10387877888 1065576480 11.510 100 32 63 1 1097610304 25422736 6611088
11:24:03 7371 8192000000 9992646736 10398674944 1078263232 11.631 100 28 56 0 1107745328 23732784 5749312
11:25:13 59793 8192000000 10004468224 10422931456 1085473376 11.700 100 45 91 0 1106037632 10792352 9771904
11:27:13 6053 8192000000 10010843232 10415452160 1095400016 11.794 100 41 81 1 1128976576 25546640 8029920
11:28:29 29025 8192000000 10020569616 10426073088 1102219552 11.859 100 38 73 1 1133799472 23933296 7646624
11:30:03 16041 8192000000 10064148000 10464915456 1094372368 11.784 99 43 86 0 1166708672 64024800 8311504
11:31:25 154245 8192000000 10144426320 10596831232 1094384608 11.784 98 38 76 0 1238129360 135359088 8385664
11:35:07 28463 8192000000 10165569760 10576785408 1118696624 12.015 100 40 80 0 1274894640 147693216 8504800
11:36:40 12677 8192000000 10199700176 10612490240 1116145840 11.991 99 44 86 1 1299691424 174438048 9107536
11:37:59 7876 8192000000 10224868912 10631077888 1100417200 11.842 98 51 100 0 1328875328 217098192 11359936
11:39:12 4689 8192000000 10185123760 10584793088 1116562512 11.995 100 76 152 1 1288474752 156160016 15752224
11:40:19 4619 8192000000 10183355408 10575745024 1111892304 11.950 100 79 158 2 1279722880 151782320 16048256
11:41:29 4270 8192000000 10173234352 10576314368 1101314480 11.850 100 60 120 1 1275871504 162300608 12256416
11:42:38 5228 8192000000 10191060704 10600517632 1111701040 11.949 100 73 144 0 1288302304 160937344 15663920
11:43:47 5230 8192000000 10196722960 10602942464 1117524704 12.004 100 62 124 1 1303878784 173271920 13082160
11:45:00 1968 8192000000 10204099856 10621063168 1107702176 11.911 100 78 156 0 1311883168 187282256 16898736
11:46:07 4257 8192000000 10204063248 10595717120 1105044944 11.885 100 63 125 0 1294840720 177182880 12612896
11:47:29 3446 8192000000 10249069392 10644750336 1110073104 11.933 100 78 154 0 1339510576 212944976 16492496
11:48:41 8597 8192000000 10223547152 10647699456 1120288832 12.030 100 52 104 0 1338136640 206259456 11588352
11:50:02 4291 8192000000 10311185280 10716807168 1122704704 12.053 100 66 132 0 1410224912 272854608 14665600
11:51:13 16253 8192000000 10220581168 10646384640 1125122800 12.075 99 57 112 1 1321900224 184669328 12108096
11:52:33 21976 8192000000 10261775504 10699616256 1136814928 12.186 100 38 75 0 1372017648 226570176 8632544
11:54:27 68551 8192000000 10081977120 10607075328 1116162624 11.991 100 15 32 0 1250301616 130566752 3572240
11:56:47 55404 8192000000 10078964640 10507542528 1118395184 12.012 99 26 53 0 1174291856 50363264 5533408
11:58:45 79321 8192000000 10096745008 10598035456 1109557568 11.928 98 16 32 0 1198658592 85217856 3883168
12:01:05 35111 8192000000 10060092320 10487537664 1134238064 12.161 100 38 77 1 1154197872 12073440 7886368
12:02:56 18570 8192000000 10125235984 10552815616 1143732544 12.251 100 40 81 0 1216090992 63775232 8583216
12:04:18 45481 8192000000 10112913392 10557100032 1148410320 12.295 100 18 36 0 1205201632 52879616 3911696
12:06:18 76143 8192000000 10093034880 10548195328 1121806944 12.044 97 26 52 1 1162706736 35849504 5050288
12:08:36 55433 8192000000 10128308336 10599157760 1145259248 12.265 99 9 18 0 1203906688 57229360 1418080
12:10:33 79453 8192000000 10063342928 10529775616 1125316752 12.077 97 13 26 0 1164243168 36364320 2562096
12:13:20 50192 8192000000 10049094080 10494914560 1105552864 11.890 96 27 51 0 1141434672 31155344 4726464
12:15:14 25963 8192000000 10107775552 10551001088 1138634960 12.203 99 33 64 0 1209543136 64660960 6247216
12:16:49 47763 8192000000 10115699952 10636509184 1109562864 11.928 96 31 62 0 1219037424 103150608 6323952
12:18:50 48415 8192000000 10106857312 10558529536 1112902752 11.960 98 32 65 0 1200714848 80345600 7466496
12:20:47 50341 8192000000 10098907904 10543296512 1091069184 11.753 96 12 24 1 1184845136 91141568 2634384
12:22:42 66250 8192000000 10090328208 10537324544 1118999696 12.018 99 14 28 0 1168414528 46541584 2873248
12:24:50 18278 8192000000 10095027968 10551873536 1122085072 12.047 100 38 75 0 1195708800 66045328 7578400
12:26:10 54976 8192000000 10078893808 10533634048 1107133776 11.905 99 28 54 0 1163658448 50536960 5987712
12:28:35 44422 8192000000 10030448144 10526232576 1071804352 11.569 96 14 27 0 1148268720 73940016 2524352
12:30:28 78172 8192000000 10048501952 10501599232 1067284832 11.526 96 29 57 1 1132551728 59347216 5919680
12:32:48 75167 8192000000 10039503216 10527612928 1060164736 11.458 95 12 24 0 1099483712 37152176 2166800
12:35:04 36045 8192000000 10074215760 10512097280 1059591984 11.453 97 36 72 0 1148693600 82134720 6966896
12:36:43 55645 8192000000 10020836784 10470785024 1066734064 11.521 98 28 56 0 1126492736 54749776 5008896
12:38:39 33791 8192000000 10049524320 10502971392 1106549200 11.900 100 11 22 0 1143790128 35697680 1543248
12:40:13 56905 8192000000 10059893024 10522701824 1093391680 11.775 98 10 20 0 1121021552 26122176 1507696
12:42:12 80427 8192000000 10038294848 10490814464 1088869952 11.732 97 31 62 0 1144391024 49759664 5761408
12:44:33 34352 8192000000 10016355392 10460426240 1112115856 11.952 100 17 33 0 1150175072 34646480 3412736
12:46:18 35917 8192000000 10036658992 10495033344 1121794528 12.044 100 7 13 1 1144665056 21883936 986592
12:47:56 16611 8192000000 10069135024 10513055744 1133093360 12.151 100 23 42 0 1172448960 34888848 4466752
12:49:12 45404 8192000000 10114447120 10588057600 1127214656 12.095 99 22 45 1 1187104624 55239696 4650272
12:51:02 37362 8192000000 10070461024 10525143040 1140169680 12.217 100 13 26 0 1186023232 42982096 2871456
12:52:39 39508 8192000000 10098100944 10578178048 1133241856 12.152 99 15 30 0 1217824288 80988176 3594256
12:54:22 75300 8192000000 10206975168 10654572544 1151371584 12.322 100 28 54 0 1280513696 123471296 5670816
12:56:38 53155 8192000000 10057466320 10490036224 1097991792 11.819 96 22 44 0 1139219632 37194912 4032928
12:58:33 24214 8192000000 10171242976 10613055488 1132088544 12.141 99 37 75 0 1245551568 106130560 7332464
12:59:59 43335 8192000000 10114472896 10604146688 1135791760 12.176 100 25 50 0 1229132960 88133984 5207216
13:01:53 79050 8192000000 10056100944 10520154112 1120205120 12.029 99 23 46 0 1191064672 66127616 4731936
13:04:50 50279 8192000000 10033020528 10528198656 1085403696 11.699 97 6 12 0 1123138912 36430096 1305120
13:06:45 66749 8192000000 9995123728 10463248384 1032507040 11.193 92 9 18 0 1054214400 20449840 1257520

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 31-03-2024 13:09:30 to 31-03-2024 13:09:44.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-03-2024 13:09:45 to 31-03-2024 13:09:47.

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          172412
MON$OLDEST_ACTIVE               172413
MON$OLDEST_SNAPSHOT             172413
MON$NEXT_TRANSACTION            172413
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                       1934624
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             691
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3082 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3082 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3082 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3082 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 Sun Mar 31 13:09:48 2024 
 
Database header page information: 
    Flags            0 
    Generation        90180 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    172412 
    Oldest active        172413 
    Oldest snapshot        172413 
    Next transaction    172414 
    Sequence number        0 
    Next attachment ID    691 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.51, total records: 7717498 
    Average version length: 48.17, total versions: 75924, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88552 
    Data pages: 88552, average fill: 70% 
    Primary pages: 88551, secondary pages: 1, swept pages: 39732 
    Empty pages: 2, full pages: 67692 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 29 
    40 - 59% = 1404 
    60 - 79% = 87076 
    80 - 99% = 37 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23144, nodes: 7717498 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1665513, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 308 
        20 - 39% = 1869 
        40 - 59% = 4001 
        60 - 79% = 2484 
        80 - 99% = 14482 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13468, nodes: 7717498 
    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: 1489818, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1649 
        40 - 59% = 1958 
        60 - 79% = 1107 
        80 - 99% = 8754 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8308, nodes: 7717498 
    Average node length: 6.61, total dup: 5778318, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1482957, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 1010 
        40 - 59% = 1321 
        60 - 79% = 967 
        80 - 99% = 4882 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.54, total records: 2229947 
    Average version length: 58.87, total versions: 41104, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28888 
    Data pages: 28888, average fill: 71% 
    Primary pages: 28886, secondary pages: 2, swept pages: 11954 
    Empty pages: 7, full pages: 18322 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 88 
    40 - 59% = 1534 
    60 - 79% = 27153 
    80 - 99% = 91 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4541, nodes: 2229947 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674468, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 940 
        40 - 59% = 834 
        60 - 79% = 736 
        80 - 99% = 2031 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2438, nodes: 2230983 
    Average node length: 4.97, total dup: 2230084, max dup: 19155 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253163, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 224 
        40 - 59% = 1434 
        60 - 79% = 548 
        80 - 99% = 229 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1795, nodes: 2229947 
    Average node length: 4.97, total dup: 2229897, max dup: 130009 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066078, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 47 
        40 - 59% = 611 
        60 - 79% = 45 
        80 - 99% = 1091 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4348, nodes: 2229947 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 674468, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 631 
        40 - 59% = 614 
        60 - 79% = 831 
        80 - 99% = 2174 
 
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.26, total records: 400 
    Average version length: 26.67, total versions: 1140, max versions: 3 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 46% 
    Primary pages: 10, secondary pages: 14, swept pages: 0 
    Empty pages: 8, full pages: 9 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 10 
 
    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: 18.60, total records: 78994 
    Average version length: 68.28, total versions: 66205, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.73 
    Pointer pages: 7, data page slots: 4264 
    Data pages: 1528, average fill: 68% 
    Primary pages: 1527, secondary pages: 1, swept pages: 2 
    Empty pages: 227, full pages: 1019 
    Fill distribution: 
     0 - 19% = 248 
    20 - 39% = 80 
    40 - 59% = 134 
    60 - 79% = 182 
    80 - 99% = 884 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1690910, depth: 3, leaf buckets: 360, nodes: 78994 
    Average node length: 13.62, total dup: 5681, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 55242, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 273 
        40 - 59% = 69 
        60 - 79% = 17 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 168, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 73% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.72, total records: 1308 
    Average version length: 43.32, total versions: 1210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.95 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 45% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 6, full pages: 10 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90418, depth: 2, leaf buckets: 7, nodes: 1308 
    Average node length: 4.34, total dup: 1210, max dup: 146 
    Average key length: 2.84, compression ratio: 6.70 
    Average prefix length: 18.23, average data length: 0.77 
    Clustering factor: 718, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.68, total records: 72 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    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.33, total records: 834238 
    Average version length: 37.93, total versions: 29015, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8712 
    Data pages: 8712, average fill: 65% 
    Primary pages: 8711, secondary pages: 1, swept pages: 1911 
    Empty pages: 7, full pages: 6645 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 29 
    40 - 59% = 557 
    60 - 79% = 8054 
    80 - 99% = 56 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 887, nodes: 818487 
    Average node length: 4.88, total dup: 818438, max dup: 153665 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92263, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 127 
        40 - 59% = 482 
        60 - 79% = 170 
        80 - 99% = 107 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 977, nodes: 818487 
    Average node length: 5.89, total dup: 728943, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164227, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 579 
        60 - 79% = 87 
        80 - 99% = 267 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1014, nodes: 818487 
    Average node length: 5.89, total dup: 728943, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166214, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 72 
        40 - 59% = 608 
        60 - 79% = 87 
        80 - 99% = 246 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1158, nodes: 818487 
    Average node length: 5.97, total dup: 728943, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158666, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 240 
        40 - 59% = 623 
        60 - 79% = 199 
        80 - 99% = 92 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.79, total records: 5490 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.09, total fragments: 34, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 58% 
    Primary pages: 82, secondary pages: 12, swept pages: 49 
    Empty pages: 8, full pages: 62 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5490 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.56, compression ratio: 10.11 
    Average prefix length: 34.50, average data length: 1.54 
    Clustering factor: 5202, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5490 
    Average node length: 11.17, 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: 166, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 77556 
    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: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 805 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 805 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33623, depth: 2, leaf buckets: 98, nodes: 77556 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2705, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.58, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 143.75, total records: 150550 
    Average version length: 150.98, total versions: 7514, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.80 
    Pointer pages: 5, data page slots: 5248 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3766, secondary pages: 2, swept pages: 4 
    Empty pages: 61, full pages: 3679 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 13 
    40 - 59% = 9 
    60 - 79% = 3 
    80 - 99% = 3680 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.92, total records: 137989 
    Average version length: 150.89, total versions: 4812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 6, data page slots: 4632 
    Data pages: 3480, average fill: 82% 
    Primary pages: 3478, secondary pages: 2, swept pages: 3 
    Empty pages: 81, full pages: 3368 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 9 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 3369 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 147.06, total records: 148261 
    Average version length: 149.84, total versions: 4143, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 10, data page slots: 4584 
    Data pages: 3736, average fill: 82% 
    Primary pages: 3734, secondary pages: 2, swept pages: 2 
    Empty pages: 85, full pages: 3629 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3629 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 141.10, total records: 160542 
    Average version length: 152.48, total versions: 11241, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 8, data page slots: 6296 
    Data pages: 4056, average fill: 82% 
    Primary pages: 4054, secondary pages: 2, swept pages: 4 
    Empty pages: 96, full pages: 3928 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 9 
    80 - 99% = 3929 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 135.68, total records: 171947 
    Average version length: 153.53, total versions: 18495, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.50 
    Pointer pages: 6, data page slots: 5680 
    Data pages: 4352, average fill: 83% 
    Primary pages: 4351, secondary pages: 1, swept pages: 1 
    Empty pages: 115, full pages: 4211 
    Fill distribution: 
     0 - 19% = 117 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 4212 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 129.07, total records: 176472 
    Average version length: 154.34, total versions: 27302, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.14 
    Pointer pages: 8, data page slots: 5944 
    Data pages: 4424, average fill: 84% 
    Primary pages: 4422, secondary pages: 2, swept pages: 2 
    Empty pages: 69, full pages: 4330 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4330 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 136.02, total records: 166879 
    Average version length: 153.30, total versions: 17478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.47 
    Pointer pages: 7, data page slots: 5352 
    Data pages: 4176, average fill: 84% 
    Primary pages: 4173, secondary pages: 3, swept pages: 5 
    Empty pages: 64, full pages: 4083 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 10 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 4084 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 139.80, total records: 153803 
    Average version length: 151.45, total versions: 12229, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.13 
    Pointer pages: 6, data page slots: 5224 
    Data pages: 3904, average fill: 82% 
    Primary pages: 3902, secondary pages: 2, swept pages: 1 
    Empty pages: 111, full pages: 3765 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 12 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3767 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 130.02, total records: 170100 
    Average version length: 153.75, total versions: 25115, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.04 
    Pointer pages: 6, data page slots: 6136 
    Data pages: 4272, average fill: 84% 
    Primary pages: 4270, secondary pages: 2, swept pages: 1 
    Empty pages: 71, full pages: 4166 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 13 
    80 - 99% = 4165 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 145.13, total records: 165339 
    Average version length: 151.83, total versions: 6881, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 7, data page slots: 5672 
    Data pages: 4184, average fill: 82% 
    Primary pages: 4181, secondary pages: 3, swept pages: 4 
    Empty pages: 110, full pages: 4043 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 4044 
 
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: 51.96, total records: 2078818 
    Average version length: 52.92, total versions: 37921, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25704 
    Data pages: 25704, average fill: 70% 
    Primary pages: 25689, secondary pages: 15, swept pages: 11668 
    Empty pages: 167, full pages: 21359 
    Fill distribution: 
     0 - 19% = 352 
    20 - 39% = 346 
    40 - 59% = 1079 
    60 - 79% = 23564 
    80 - 99% = 363 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2564, nodes: 2078818 
    Average node length: 5.44, total dup: 1938876, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180607, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 300 
        40 - 59% = 1665 
        60 - 79% = 301 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2078818 
    Average node length: 5.69, total dup: 1865624, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372139, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2495 
        60 - 79% = 232 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2104, nodes: 2078818 
    Average node length: 4.96, total dup: 2078718, max dup: 26994 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178466, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 203 
        40 - 59% = 1083 
        60 - 79% = 389 
        80 - 99% = 428 
 
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: 40.12, total records: 135363 
    Average version length: 69.16, total versions: 65415, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.14 
    Pointer pages: 3, data page slots: 4304 
    Data pages: 3048, average fill: 55% 
    Primary pages: 3048, secondary pages: 0, swept pages: 306 
    Empty pages: 384, full pages: 1306 
    Fill distribution: 
     0 - 19% = 568 
    20 - 39% = 343 
    40 - 59% = 473 
    60 - 79% = 867 
    80 - 99% = 797 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104991, depth: 3, leaf buckets: 240, nodes: 135363 
    Average node length: 6.42, total dup: 117736, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 23750, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 97 
        40 - 59% = 113 
        60 - 79% = 29 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.75, total records: 7118078 
    Average version length: 68.75, total versions: 379569, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 67, data page slots: 108168 
    Data pages: 108168, average fill: 71% 
    Primary pages: 108167, secondary pages: 1, swept pages: 26730 
    Empty pages: 144, full pages: 68276 
    Fill distribution: 
     0 - 19% = 966 
    20 - 39% = 1389 
    40 - 59% = 5963 
    60 - 79% = 98848 
    80 - 99% = 1002 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10689, nodes: 7118078 
    Average node length: 6.51, total dup: 6157730, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1664318, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1756 
        40 - 59% = 5446 
        60 - 79% = 2959 
        80 - 99% = 522 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8771, nodes: 7118078 
    Average node length: 5.39, total dup: 6838337, max dup: 177 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1471472, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1353 
        40 - 59% = 4994 
        60 - 79% = 1463 
        80 - 99% = 953 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8845, nodes: 7118078 
    Average node length: 5.39, total dup: 6838337, max dup: 177 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1473788, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1412 
        40 - 59% = 5021 
        60 - 79% = 1454 
        80 - 99% = 953 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.47, total records: 12261144 
    Average version length: 68.70, total versions: 300271, 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: 109, data page slots: 176872 
    Data pages: 176872, average fill: 74% 
    Primary pages: 176871, secondary pages: 1, swept pages: 68092 
    Empty pages: 6, full pages: 156476 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 241 
    40 - 59% = 3466 
    60 - 79% = 171037 
    80 - 99% = 2107 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18517, nodes: 12258814 
    Average node length: 6.62, total dup: 10687748, max dup: 61 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2488788, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2022 
        40 - 59% = 10701 
        60 - 79% = 4937 
        80 - 99% = 835 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 46.21, total records: 1383817 
    Average version length: 69.07, total versions: 335240, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.73 
    Pointer pages: 31, data page slots: 49240 
    Data pages: 28029, average fill: 52% 
    Primary pages: 27935, secondary pages: 94, swept pages: 9295 
    Empty pages: 4400, full pages: 15865 
    Fill distribution: 
     0 - 19% = 6282 
    20 - 39% = 3998 
    40 - 59% = 2636 
    60 - 79% = 10828 
    80 - 99% = 4285 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1772, nodes: 1191419 
    Average node length: 5.54, total dup: 1142929, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 80453, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 619 
        40 - 59% = 819 
        60 - 79% = 276 
        80 - 99% = 43 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 42.39, total records: 1082953 
    Average version length: 69.03, total versions: 137423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.97 
    Pointer pages: 22, data page slots: 35616 
    Data pages: 27856, average fill: 35% 
    Primary pages: 27856, secondary pages: 0, swept pages: 7744 
    Empty pages: 5240, full pages: 7455 
    Fill distribution: 
     0 - 19% = 8899 
    20 - 39% = 6058 
    40 - 59% = 7217 
    60 - 79% = 5480 
    80 - 99% = 202 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1167, nodes: 739926 
    Average node length: 5.92, total dup: 683103, max dup: 86 
    Average key length: 2.99, compression ratio: 14.04 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 105475, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 398 
        40 - 59% = 571 
        60 - 79% = 186 
        80 - 99% = 12 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.82, total records: 9012638 
    Average version length: 68.96, total versions: 308356, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 91, data page slots: 148176 
    Data pages: 148144, average fill: 65% 
    Primary pages: 148119, secondary pages: 25, swept pages: 73679 
    Empty pages: 417, full pages: 66676 
    Fill distribution: 
     0 - 19% = 1492 
    20 - 39% = 9115 
    40 - 59% = 28192 
    60 - 79% = 107180 
    80 - 99% = 2165 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13494, nodes: 9008860 
    Average node length: 6.71, total dup: 7471731, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1977846, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1578 
        40 - 59% = 6970 
        60 - 79% = 4309 
        80 - 99% = 635 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21123340 
    Average version length: 82.89, total versions: 13580, 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: 319304 
    Data pages: 319304, average fill: 81% 
    Primary pages: 319298, secondary pages: 6, swept pages: 12219 
    Empty pages: 18, full pages: 318945 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 20 
    40 - 59% = 55 
    60 - 79% = 48328 
    80 - 99% = 270865 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19591, nodes: 21123340 
    Average node length: 5.72, total dup: 20643071, max dup: 163 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280843, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 8588 
        60 - 79% = 555 
        80 - 99% = 10439 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17132, nodes: 21123340 
    Average node length: 6.31, total dup: 18563886, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916783, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 753 
        60 - 79% = 279 
        80 - 99% = 16097 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21369, nodes: 21123340 
    Average node length: 6.35, total dup: 18482593, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574104, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8874 
        60 - 79% = 611 
        80 - 99% = 11882 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16035, nodes: 21123340 
    Average node length: 5.56, total dup: 21123240, max dup: 229791 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945610, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2806 
        60 - 79% = 365 
        80 - 99% = 12857 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.20, total records: 9437886 
    Average version length: 82.60, total versions: 283378, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 107, data page slots: 174600 
    Data pages: 174552, average fill: 67% 
    Primary pages: 174515, secondary pages: 37, swept pages: 95679 
    Empty pages: 885, full pages: 89430 
    Fill distribution: 
     0 - 19% = 2540 
    20 - 39% = 10688 
    40 - 59% = 32343 
    60 - 79% = 111048 
    80 - 99% = 17933 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11344, nodes: 9437886 
    Average node length: 5.38, total dup: 9132463, max dup: 178 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2114490, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 86 
        40 - 59% = 8812 
        60 - 79% = 2386 
        80 - 99% = 60 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13328, nodes: 9437886 
    Average node length: 6.25, total dup: 7823968, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1468520, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 4023 
        40 - 59% = 4283 
        60 - 79% = 2528 
        80 - 99% = 2377 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12679, nodes: 9437886 
    Average node length: 6.00, total dup: 8183360, max dup: 37 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2296419, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 113 
        40 - 59% = 9845 
        60 - 79% = 2656 
        80 - 99% = 63 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9961, nodes: 9437886 
    Average node length: 5.15, total dup: 9437786, max dup: 158410 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1510095, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1341 
        40 - 59% = 4869 
        60 - 79% = 1657 
        80 - 99% = 2053 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.33, total records: 11022672 
    Average version length: 82.53, total versions: 295716, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 192416 
    Data pages: 190712, average fill: 71% 
    Primary pages: 190559, secondary pages: 153, swept pages: 71052 
    Empty pages: 3331, full pages: 141675 
    Fill distribution: 
     0 - 19% = 5822 
    20 - 39% = 8562 
    40 - 59% = 18586 
    60 - 79% = 94358 
    80 - 99% = 63384 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13120, nodes: 11022672 
    Average node length: 5.29, total dup: 10913763, max dup: 654 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2308023, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 181 
        40 - 59% = 9907 
        60 - 79% = 2974 
        80 - 99% = 58 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10185, nodes: 11022672 
    Average node length: 5.49, total dup: 10539625, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 707137, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 180 
        20 - 39% = 852 
        40 - 59% = 2478 
        60 - 79% = 1734 
        80 - 99% = 4941 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15010, nodes: 11022672 
    Average node length: 6.02, total dup: 9614408, max dup: 67 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2324285, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 206 
        40 - 59% = 11500 
        60 - 79% = 3226 
        80 - 99% = 74 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10474, nodes: 11022672 
    Average node length: 5.22, total dup: 11022572, max dup: 200630 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 695852, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 879 
        40 - 59% = 4515 
        60 - 79% = 1455 
        80 - 99% = 3537 
 
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: 80.46, total records: 9562727 
    Average version length: 82.90, total versions: 294453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 110, data page slots: 179472 
    Data pages: 179432, average fill: 66% 
    Primary pages: 179395, secondary pages: 37, swept pages: 101140 
    Empty pages: 1167, full pages: 88777 
    Fill distribution: 
     0 - 19% = 3239 
    20 - 39% = 12281 
    40 - 59% = 34296 
    60 - 79% = 111834 
    80 - 99% = 17782 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11665, nodes: 9562727 
    Average node length: 5.20, total dup: 9534015, max dup: 2065 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1927697, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1568 
        40 - 59% = 7625 
        60 - 79% = 1876 
        80 - 99% = 568 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13492, nodes: 9562727 
    Average node length: 6.27, total dup: 7926779, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1443479, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 185 
        20 - 39% = 4002 
        40 - 59% = 4291 
        60 - 79% = 2528 
        80 - 99% = 2486 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12314, nodes: 9562727 
    Average node length: 5.46, total dup: 9131819, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2058142, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1512 
        40 - 59% = 8601 
        60 - 79% = 1641 
        80 - 99% = 538 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10120, nodes: 9562727 
    Average node length: 5.17, total dup: 9562627, max dup: 161108 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1529252, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1378 
        40 - 59% = 4999 
        60 - 79% = 1568 
        80 - 99% = 2140 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.62, total records: 573123 
    Average version length: 68.78, total versions: 5353, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 74% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3788 
    Empty pages: 3, full pages: 6774 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 10 
    40 - 59% = 166 
    60 - 79% = 7821 
    80 - 99% = 64 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 51724, depth: 3, leaf buckets: 733, nodes: 573123 
    Average node length: 5.95, total dup: 488075, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100504, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 530 
        60 - 79% = 93 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 40258, depth: 3, leaf buckets: 756, nodes: 573123 
    Average node length: 6.15, total dup: 470065, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100548, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 546 
        60 - 79% = 90 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 573, nodes: 573123 
    Average node length: 4.86, total dup: 573023, max dup: 9305 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89267, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 339 
        60 - 79% = 73 
        80 - 99% = 123 
 
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 Sun Mar 31 13:10:12 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7717498 75924 1 0.0000 0.0000
DOC_LIST 2229947 41104 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1140 3 200.0000 0.0000
INVNT_TURNOVER_LOG 78994 66205 1 0.0000 0.0000
MONEY_SALDO 49 168 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1308 1210 1 0.0000 0.0000
PDISTR 834238 29015 2 0.0000 0.0000
PERF_SPLIT_0 150550 7514 1 0.0000 0.0000
PERF_SPLIT_1 137989 4812 1 0.0000 0.0000
PERF_SPLIT_2 148261 4143 1 0.0000 0.0000
PERF_SPLIT_3 160542 11241 1 0.0000 0.0000
PERF_SPLIT_4 171947 18495 1 0.0000 0.0000
PERF_SPLIT_5 176472 27302 1 0.0000 0.0000
PERF_SPLIT_6 166879 17478 1 0.0000 0.0000
PERF_SPLIT_7 153803 12229 1 0.0000 0.0000
PERF_SPLIT_8 170100 25115 1 0.0000 0.0000
PERF_SPLIT_9 165339 6881 1 0.0000 0.0000
PSTORNED 2078818 37921 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 135363 65415 1 0.0000 0.0000
XQD_1000_3300 7118078 379569 1 0.0000 0.0000
XQD_1200_2000 12261144 300271 1 0.0000 0.0000
XQD_2000_3300 1383817 335240 1 0.0000 0.0000
XQD_2100_3300 1082953 137423 1 0.0000 0.0000
XQD_3300_3400 9012638 308356 1 0.0000 0.0000
XQS_1000_1200 21123340 13580 1 0.0000 0.0000
XQS_1000_3300 9437886 283378 1 0.0000 0.0000
XQS_1200_2000 11022672 295716 1 0.0000 0.0000
XQS_2100_3300 9562727 294453 1 0.0000 0.0000
XQS_3300_3400 573123 5353 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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