Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.02.2024 16:11
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 15585728 kB
MemAvailable 30273600 kB
Buffers 0 kB
Cached 16159468 kB
SwapCached 2528 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 3.0.12
DB_NAME                         /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-18 16:09:40
DTS_END                         2024-02-18 16:09:40.6170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51422
TRN_ID                          176758
ATT_ID                          576
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: 9404.67 22616 940467
customer order: creation 179.42 360 17942
customer order: refuse 16.05 370 1605
order to supplier: creation 47.46 1323 4746
order to supplier: removal 3.56 106379 356
invoice (draft): creation 48.29 3392 4829
invoice (draft): removal 51.39 801 5139
invoice accept: apply 43.41 22778 4341
invoice accept: cancel 46.55 948 4655
customer reserve: creation 4150.99 219 415099
customer reserve: removal 4505.10 67 450510
realization accept: apply 87.27 206 8727
realization accept: cancel 90.80 124 9080
payment from customer: creation 62.09 124 6209
payment from customer: removal 6.09 113 609
payment to supplier: creation 49.86 142 4986
payment to supplier: removal 3.36 106 336
service: total inventory turnovers 5.26 1037 526
service: total monetary turnovers 6.89 34 689
service: aggregate perf. data 0.80 19998 80
service: refresh index statistics 0.03 293794 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-02-2024 16:11:28 to 18-02-2024 16:11:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3793
TEST_TIME 2 4137
TEST_TIME 3 4748
TEST_TIME 4 4779
TEST_TIME 5 4947
TEST_TIME 6 5516
TEST_TIME 7 5635
TEST_TIME 8 5942
TEST_TIME 9 6145
TEST_TIME 10 6217
TEST_TIME 11 6454
TEST_TIME 12 6396
TEST_TIME 13 6579
TEST_TIME 14 6453
TEST_TIME 15 7361
TEST_TIME 16 7346
TEST_TIME 17 7201
TEST_TIME 18 7368
TEST_TIME 19 7583
TEST_TIME 20 7734
TEST_TIME 21 7815
TEST_TIME 22 7927
TEST_TIME 23 7958
TEST_TIME 24 8120
TEST_TIME 25 8292
TEST_TIME 26 8413
TEST_TIME 27 8332
TEST_TIME 28 8376
TEST_TIME 29 8335
TEST_TIME 30 8604
TEST_TIME 31 9396
TEST_TIME 32 10058
TEST_TIME 33 10163
TEST_TIME 34 10085
TEST_TIME 35 9977
TEST_TIME 36 9868
TEST_TIME 37 9725
TEST_TIME 38 9720
TEST_TIME 39 9631
TEST_TIME 40 9726
TEST_TIME 41 9723
TEST_TIME 42 9668
TEST_TIME 43 9560
TEST_TIME 44 9528
TEST_TIME 45 9602
TEST_TIME 46 9575
TEST_TIME 47 9529
TEST_TIME 48 9518
TEST_TIME 49 9453
TEST_TIME 50 9493
TEST_TIME 51 9511
TEST_TIME 52 9367
TEST_TIME 53 9643
TEST_TIME 54 9546
TEST_TIME 55 9499
TEST_TIME 56 9604
TEST_TIME 57 9587
TEST_TIME 58 9526
TEST_TIME 59 9530
TEST_TIME 60 9513
TEST_TIME 61 9651
TEST_TIME 62 9625
TEST_TIME 63 9703
TEST_TIME 64 9773
TEST_TIME 65 9788
TEST_TIME 66 9744
TEST_TIME 67 9659
TEST_TIME 68 9609
TEST_TIME 69 9640
TEST_TIME 70 9562
TEST_TIME 71 9491
TEST_TIME 72 9465
TEST_TIME 73 9435
TEST_TIME 74 9437
TEST_TIME 75 9465
TEST_TIME 76 9416
TEST_TIME 77 9447
TEST_TIME 78 9419
TEST_TIME 79 9494
TEST_TIME 80 9440
TEST_TIME 81 9528
TEST_TIME 82 9555
TEST_TIME 83 9584
TEST_TIME 84 9551
TEST_TIME 85 9571
TEST_TIME 86 9651
TEST_TIME 87 9687
TEST_TIME 88 9733
TEST_TIME 89 9721
TEST_TIME 90 9707
TEST_TIME 91 9618
TEST_TIME 92 9584
TEST_TIME 93 9549
TEST_TIME 94 9531
TEST_TIME 95 9469
TEST_TIME 96 9438
TEST_TIME 97 9484
TEST_TIME 98 9435
TEST_TIME 99 9433
TEST_TIME 100 9405

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-02-2024 16:11:32 to 18-02-2024 16:11:35.

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 1319808 1319808 0 0.00 0 22407 8 0 0
doc_list_biud 1319807 1319807 0 0.00 0 45738 29 0 0
sp_add_invoice_to_stock 4481 4341 140 3.12 22 216504 22778 0 140
sp_cancel_adding_invoice 4655 4655 0 0.00 5 75525 949 0 0
sp_cancel_client_order 1605 1605 0 0.00 4 15864 371 0 0
sp_cancel_customer_reserve 450510 450510 0 0.00 0 45740 67 0 0
sp_cancel_pay_from_customer 609 609 0 0.00 2 6770 114 0 0
sp_cancel_pay_to_supplier 336 336 0 0.00 3 6284 107 0 0
sp_cancel_supplier_invoice 5145 5139 6 0.11 2 13883 801 0 6
sp_cancel_supplier_order 356 356 0 0.00 6 1004500 106380 0 0
sp_cancel_write_off 9080 9080 0 0.00 1 7912 124 0 0
sp_client_order 17942 17942 0 0.00 3 61862 361 0 0
sp_customer_reserve 415099 415099 0 0.00 0 108913 220 0 0
sp_fill_shopping_cart 27510 27510 0 0.00 1 39786 39 0 0
sp_fill_shopping_cart_clo_res 415094 415094 0 0.00 0 12565 14 0 0
sp_get_clo_for_invoice 4336 4336 0 0.00 0 30895 268 0 0
sp_kill_cost_storno 14680 14680 0 0.00 0 6463 66 0 0
sp_kill_qstorno_ret_qs2qd 915595 915595 0 0.00 0 45733 36 0 0
sp_kill_qty_storno 484407 484407 0 0.00 0 45737 78 0 0
sp_lock_selected_doc 18115 18115 0 0.00 0 5164 4 0 0
sp_make_cost_storno 24258 24258 0 0.00 0 15430 61 0 0
sp_multiply_rows_for_pdistr 24257 24257 0 0.00 0 7197 30 0 0
sp_multiply_rows_for_qdistr 17942 17942 0 0.00 0 61492 146 0 0
sp_pay_from_customer 6209 6209 0 0.00 4 13431 124 0 0
sp_pay_to_supplier 4986 4986 0 0.00 4 14534 143 0 0
sp_payment_common 11195 11195 0 0.00 2 12719 33 0 0
sp_qd_handle_on_cancel_clo 1605 1605 0 0.00 0 15856 347 0 0
sp_qd_handle_on_invoice_upd_sts 8991 8991 0 0.00 0 34740 365 0 0
sp_qd_handle_on_reserve_upd_sts 8726 8726 0 0.00 0 19598 85 0 0
sp_reserve_write_off 8727 8727 0 0.00 7 19609 206 0 0
sp_supplier_invoice 4829 4829 0 0.00 8 114757 3393 0 0
sp_supplier_order 4746 4746 0 0.00 4 37907 1323 0 0
srv_aggregate_perf_data 80 80 0 0.00 2251 176467 19999 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 879 146121 36393 0 0
srv_find_qd_qs_mism 896042 896042 0 0.00 0 16125 7 0 0
srv_make_invnt_saldo 526 526 0 0.00 44 55648 1037 0 0
srv_make_money_saldo 689 689 0 0.00 1 969 35 0 0
srv_recalc_idx_stat 3 3 0 0.00 148246 463341 293794 0 0
t$perf-abend:sp_add_invoice_to_stock 140 140 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4342 4342 0 0.00 0 11236 203 0 0
t$perf-norm:sp_cancel_adding_invoice 360 360 0 0.00 1 2937 78 0 0
t$perf-norm:sp_cancel_client_order 1605 1605 0 0.00 0 4614 18 0 0
t$perf-norm:sp_cancel_customer_reserve 600 600 0 0.00 0 1296 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 609 609 0 0.00 0 626 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 336 336 0 0.00 0 1794 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 323 323 0 0.00 0 2234 24 0 0
t$perf-norm:sp_cancel_supplier_order 356 356 0 0.00 0 23519 1745 0 0
t$perf-norm:sp_cancel_write_off 865 865 0 0.00 0 3527 8 0 0
t$perf-norm:sp_client_order 17942 17942 0 0.00 0 4170 16 0 0
t$perf-norm:sp_customer_reserve 876 876 0 0.00 0 2829 15 0 0
t$perf-norm:sp_pay_from_customer 6209 6209 0 0.00 0 3314 9 0 0
t$perf-norm:sp_pay_to_supplier 4986 4986 0 0.00 0 5148 10 0 0
t$perf-norm:sp_reserve_write_off 8727 8727 0 0.00 0 8379 10 0 0
t$perf-norm:sp_supplier_invoice 4829 4829 0 0.00 0 3756 20 0 0
t$perf-norm:sp_supplier_order 4746 4746 0 0.00 0 10080 21 0 0
t$perf-norm:srv_aggregate_perf_data 80 80 0 0.00 0 64 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 232 7 0 0
t$perf-norm:srv_make_invnt_saldo 526 526 0 0.00 0 1523 33 0 0
t$perf-norm:srv_make_money_saldo 689 689 0 0.00 0 4749 30 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 8950 8670 280 3.12 0 3168 18 0 280
v_all_customers 33350 33350 0 0.00 0 134 1 0 0
v_all_suppliers 26762 26762 0 0.00 0 24 1 0 0
v_all_wares 35884 35884 0 0.00 0 133 1 0 0
v_cancel_adding_invoice 720 720 0 0.00 0 657 8 0 0
v_cancel_client_order 3210 3210 0 0.00 0 3573 5 0 0
v_cancel_customer_prepayment 1218 1218 0 0.00 0 2506 9 0 0
v_cancel_customer_reserve 1200 1200 0 0.00 0 1002 6 0 0
v_cancel_payment_to_supplier 672 672 0 0.00 0 749 4 0 0
v_cancel_supplier_invoice 658 646 12 1.82 0 2606 20 0 12
v_cancel_supplier_order 712 712 0 0.00 0 583 6 0 0
v_cancel_write_off 1730 1730 0 0.00 0 1285 15 0 0
v_max_id_clo_ord 4746 4746 0 0.00 0 2372 2 0 0
v_max_id_clo_res 876 876 0 0.00 0 1852 12 0 0
v_max_id_ord_sup 4822 4822 0 0.00 0 2801 3 0 0
v_max_non_paid_invoice 1173 1173 0 0.00 0 2287 8 0 0
v_max_non_paid_realizn 2993 2993 0 0.00 0 5741 8 0 0
v_min_id_clo_ord 4746 4746 0 0.00 0 1159 7 0 0
v_min_id_clo_res 876 876 0 0.00 0 1092 5 0 0
v_min_id_ord_sup 4822 4822 0 0.00 0 3404 5 0 0
v_min_non_paid_invoice 4986 4986 0 0.00 0 6372 20 0 0
v_min_non_paid_realizn 6209 6209 0 0.00 0 12714 26 0 0
v_our_firm 8966 8966 0 0.00 0 29 1 0 0
v_reserve_write_off 17452 17452 0 0.00 0 2796 6 0 0
x_lock_depdocs_on_canc_invoice 9471 9471 0 0.00 0 17759 150 0 0
x_lock_depdocs_on_canc_sup_ord 356 356 0 0.00 0 11315 388 0 0
x_make_qstorno_1000_1200 4746 4746 0 0.00 1 37900 1237 0 0
x_make_qstorno_1200_2000 4829 4829 0 0.00 4 103278 3253 0 0
x_make_qstorno_2100_3300 415099 415099 0 0.00 0 108911 202 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-02-2024 16:11:36 to 18-02-2024 16:11:40.

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
14:09:44 24 8192000000 8831249856 8854282240 27427552 0.333 12 5 5 0 27667136 100304 139280
14:10:45 29833 8192000000 9906127216 10219151360 986675600 10.749 100 87 174 0 1016273024 6084912 23512512
14:12:18 25379 8192000000 9954258048 10277470208 1036234736 11.228 100 89 176 0 1067201104 8475280 22491088
14:13:46 16627 8192000000 9999420896 10334482432 1077034864 11.619 100 85 168 1 1107386192 9720800 20630528
14:15:10 10919 8192000000 10041122992 10391564288 1126635008 12.090 100 79 157 1 1155589968 10530560 18424400
14:16:25 4863 8192000000 10082014304 10441535488 1168848896 12.486 100 83 167 0 1200857664 13070832 18937936
14:17:32 3166 8192000000 10121064336 10489368576 1210611424 12.875 100 80 156 2 1240776576 12807920 17357232
14:18:38 1703 8192000000 10151033520 10527334400 1242341520 13.168 100 75 147 0 1271101504 12268432 16491552
14:19:42 1352 8192000000 10192941328 10571923456 1271347440 13.434 100 92 183 1 1305605968 13970160 20288368
14:20:45 851 8192000000 10203340240 10585403392 1291873440 13.621 100 91 178 1 1325047984 12628816 20545728
14:21:48 997 8192000000 10206575680 10598707200 1300127376 13.696 100 74 149 1 1325407664 7810768 17469520
14:22:50 6059 8192000000 10198764640 10607341568 1306966144 13.759 100 29 58 1 1321221600 7923792 6331664
14:23:57 9258 8192000000 10212127712 10618953728 1316573776 13.846 100 18 38 0 1326275104 6060416 3640912
14:25:07 18482 8192000000 10217852000 10631995392 1323006848 13.904 100 37 73 0 1336825824 5854400 7964576
14:26:26 7485 8192000000 10226964080 10644877312 1329548928 13.963 100 27 55 0 1346158272 9442032 7167312
14:27:36 4884 8192000000 10217076544 10641707008 1331748576 13.983 100 22 45 0 1343413904 6517360 5147968
14:28:42 57762 8192000000 10219489584 10642993152 1329355360 13.961 100 36 73 0 1343663168 4784208 9523600
14:30:49 28167 8192000000 10240534192 10653646848 1328558144 13.954 99 48 95 0 1348005920 9164256 10283520
14:32:33 21604 8192000000 10260397968 10674683904 1350515904 14.152 100 46 92 0 1369656416 9060864 10079648
14:34:00 9935 8192000000 10252115520 10660413440 1337601232 14.036 100 59 118 2 1362499856 11935792 12962832
14:35:14 35577 8192000000 10242656000 10658156544 1334070080 14.004 100 44 87 0 1361056240 17008672 9977488
14:36:53 4184 8192000000 10252912720 10651963392 1322957200 13.903 99 64 127 0 1352424048 15345424 14121424
14:38:07 6519 8192000000 10234684944 10638372864 1310642000 13.792 99 52 104 0 1339164256 16173536 12348720
14:39:17 7277 8192000000 10231925280 10636439552 1301727888 13.711 98 50 98 0 1330388080 17624768 11035424
14:40:30 10951 8192000000 10233540816 10638589952 1319776416 13.875 100 45 89 0 1346769040 17000592 9992032
14:41:53 15218 8192000000 10257106736 10660048896 1322738480 13.901 99 62 123 0 1361841232 24596064 14506688
14:43:14 10480 8192000000 10260603072 10659373056 1324999936 13.922 100 66 132 0 1369693520 28541024 16152560
14:44:32 11114 8192000000 10279113296 10686480384 1348125136 14.131 100 55 110 0 1384937888 23896800 12915952
14:45:55 4126 8192000000 10284334192 10689789952 1349379104 14.142 100 63 124 3 1389732752 26175008 14178640
14:47:03 3556 8192000000 10308324944 10711023616 1367626544 14.306 100 75 146 0 1414270800 28657456 17986800
14:48:11 5802 8192000000 10315654272 10722254848 1371091920 14.337 100 70 140 0 1420588192 32587328 16908944
14:49:25 9570 8192000000 10319448896 10730758144 1377030352 14.390 100 57 111 0 1421410736 30763728 13616656
14:50:41 2623 8192000000 10340356480 10747392000 1387928480 14.487 100 80 157 0 1443240400 36241616 19070304
14:51:47 3589 8192000000 10344059968 10761875456 1391402464 14.518 100 67 130 2 1448496736 41036368 16057904
14:52:58 878 8192000000 10369325088 10776289280 1403895712 14.630 100 88 170 1 1469421760 44551760 20974288
14:54:11 4333 8192000000 10368784560 10779869184 1400769648 14.602 100 69 138 1 1464261392 45512656 17979088
14:55:18 24365 8192000000 10357490944 10788413440 1414125968 14.721 100 47 94 1 1467798368 41525776 12146624
14:56:46 14409 8192000000 10362304816 10793025536 1412158544 14.703 100 35 70 0 1469425904 47847120 9420240
14:58:31 18200 8192000000 10357448432 10799226880 1404719920 14.637 100 27 54 1 1465587408 52881552 7985936
14:59:52 25489 8192000000 10327543264 10784337920 1390007888 14.506 100 19 38 0 1448745040 53064496 5672656
15:01:32 26214 8192000000 10297651072 10750885888 1388451232 14.492 100 10 20 1 1412283424 21826912 2005280
15:03:07 47804 8192000000 10294945440 10741366784 1385532800 14.466 100 14 28 0 1396708752 8141824 3034128
15:05:10 52361 8192000000 10307301504 10755223552 1398194144 14.579 100 45 90 1 1417692560 9090784 10407632
15:07:03 102610 8192000000 10306735664 10760663040 1382478016 14.439 99 34 68 1 1402941888 11696576 8767296
15:09:47 47773 8192000000 10306920032 10754699264 1394772320 14.548 100 33 65 0 1415252080 13460336 7019424
15:11:44 74264 8192000000 10315095584 10759503872 1382735392 14.441 98 39 76 3 1399632880 8625008 8272480
15:14:00 20714 8192000000 10294063840 10742870016 1385062352 14.462 100 40 79 1 1409871760 14922720 9886688
15:15:23 31284 8192000000 10274362320 10730057728 1353638464 14.180 98 29 58 0 1371703200 11796368 6268368
15:17:00 35657 8192000000 10265860352 10710077440 1321876704 13.894 96 32 64 1 1340755904 11129792 7749408
15:18:37 42534 8192000000 10259742336 10703564800 1334892896 14.011 98 15 31 0 1353127792 14277312 3957584
15:20:21 53204 8192000000 10251042064 10698117120 1339296416 14.051 99 20 40 0 1358718304 14468256 4953632
15:22:37 64187 8192000000 10238185120 10670440448 1267592208 13.400 94 13 24 0 1279830608 9620368 2618032
15:24:43 36390 8192000000 10232818672 10668343296 1286753696 13.575 96 33 66 0 1311208704 17087248 7367760
15:27:10 48528 8192000000 10235349728 10664468480 1301883856 13.712 97 33 66 0 1318505328 9015600 7605872
15:29:02 62405 8192000000 10239832112 10686898176 1307251136 13.761 97 18 36 0 1332177264 20570928 4355200
15:31:10 33977 8192000000 10272779968 10709712896 1341438992 14.070 99 35 69 0 1365213712 15890480 7884240
15:32:45 74434 8192000000 10258582576 10711838720 1299699312 13.693 96 11 22 1 1323676128 22021264 1955552
15:35:00 80529 8192000000 10263478512 10713063424 1355557232 14.197 100 24 48 1 1373671984 13250192 4864560
15:37:50 49066 8192000000 10282105856 10724384768 1365893216 14.290 100 25 50 0 1382848496 11287696 5667584
15:39:51 5163 8192000000 10275506144 10718003200 1372646992 14.351 100 25 49 0 1383951776 6788304 4516480
15:40:56 96246 8192000000 10283888752 10738245632 1372628704 14.351 99 20 40 0 1388313744 10542160 5142880
15:43:34 40737 8192000000 10279601760 10742890496 1385131280 14.462 100 9 18 0 1398401168 11257504 2012384
15:45:19 31919 8192000000 10295079264 10741260288 1368998848 14.318 99 21 41 0 1384516096 11413568 4103680
15:46:58 42281 8192000000 10300766544 10741190656 1363340128 14.267 98 35 70 0 1379826048 8743600 7742320
15:48:42 36913 8192000000 10301147440 10753642496 1390066656 14.506 100 31 60 1 1407209744 9395632 7747456
15:50:19 42011 8192000000 10302278192 10758791168 1386289504 14.473 99 27 54 1 1405124064 12707872 6126688
15:52:06 58549 8192000000 10311058592 10772443136 1402547952 14.618 100 14 28 0 1415749888 10417296 2784640
15:54:05 104555 8192000000 10328204544 10789502976 1381551072 14.430 98 17 34 0 1405306656 19802144 3953440
15:56:58 146119 8192000000 10321034912 10785705984 1367187456 14.302 97 6 12 0 1390003184 21565152 1250576
16:01:27 42290 8192000000 10273344320 10713849856 1327731840 13.947 96 34 66 0 1346640432 11912928 6995664
16:03:14 29178 8192000000 10260721744 10708291584 1346501840 14.116 98 22 43 0 1362175488 11022112 4651536
16:04:45 54973 8192000000 10272303568 10726871040 1365694960 14.288 99 10 20 0 1381573056 13634144 2243952
16:06:40 50349 8192000000 10278687792 10723856384 1371221904 14.338 100 13 26 0 1388486544 13801920 3462720
16:08:39 31152 8192000000 10286756208 10747760640 1376075904 14.381 100 11 22 0 1397163568 18355648 2732016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 18-02-2024 16:11:42 to 18-02-2024 16:11:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 140 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-02-2024 16:11:57 to 18-02-2024 16:11:59.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          176425
MON$OLDEST_ACTIVE               177327
MON$OLDEST_SNAPSHOT             177327
MON$NEXT_TRANSACTION            177327
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-03 16:41:55.3470
MON$PAGES                       1930144
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.12.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Feb 18 16:12:00 2024 
 
Database header page information: 
    Flags            0 
    Generation        92748 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176425 
    Oldest active        177327 
    Oldest snapshot        177327 
    Next transaction    177328 
    Sequence number        0 
    Next attachment ID    712 
    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 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    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: 1504311, 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: 1504313, 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: 1504312, 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: 1504310, 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: 1504309, 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: 504, Index root page: 505 
    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: 1504242, 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: 1504244, 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: 1504243, 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: 1504241, 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: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.37, total records: 7753865 
    Average version length: 48.16, total versions: 85126, 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: 54, data page slots: 87336 
    Data pages: 87336, average fill: 71% 
    Primary pages: 87336, secondary pages: 0, swept pages: 24121 
    Empty pages: 7, full pages: 58912 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 297 
    40 - 59% = 3381 
    60 - 79% = 83618 
    80 - 99% = 11 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23359, nodes: 7753865 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1722816, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 302 
        20 - 39% = 2046 
        40 - 59% = 4017 
        60 - 79% = 2346 
        80 - 99% = 14648 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13572, nodes: 7753865 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1545583, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1720 
        40 - 59% = 1929 
        60 - 79% = 1139 
        80 - 99% = 8784 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8376, nodes: 7753865 
    Average node length: 6.62, total dup: 5799038, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1538514, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 1098 
        40 - 59% = 1266 
        60 - 79% = 925 
        80 - 99% = 4965 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.28, total records: 2245904 
    Average version length: 34.64, total versions: 90229, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28608 
    Data pages: 28608, average fill: 73% 
    Primary pages: 28602, secondary pages: 6, swept pages: 10834 
    Empty pages: 8, full pages: 19778 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 142 
    40 - 59% = 1966 
    60 - 79% = 25787 
    80 - 99% = 693 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4588, nodes: 2245904 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 693344, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1014 
        40 - 59% = 771 
        60 - 79% = 721 
        80 - 99% = 2082 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2540, nodes: 2248287 
    Average node length: 4.97, total dup: 2247388, max dup: 20129 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1258556, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 285 
        40 - 59% = 1538 
        60 - 79% = 537 
        80 - 99% = 176 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2061, nodes: 2245904 
    Average node length: 4.97, total dup: 2245854, max dup: 130402 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1063705, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 161 
        40 - 59% = 1029 
        60 - 79% = 47 
        80 - 99% = 821 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4386, nodes: 2245904 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 693344, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 678 
        40 - 59% = 559 
        60 - 79% = 822 
        80 - 99% = 2220 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    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: 1504315, 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: 1504316, 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: 1504314, 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: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, 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.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, 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: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.10, total records: 400 
    Average version length: 23.01, total versions: 245114, max versions: 634 
    Average fragment length: 2.00, total fragments: 66, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1392 
    Data pages: 1392, average fill: 88% 
    Primary pages: 10, secondary pages: 1382, swept pages: 0 
    Empty pages: 3, full pages: 1388 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1386 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 20.94, total records: 122892 
    Average version length: 68.28, total versions: 85226, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.20 
    Pointer pages: 7, data page slots: 3680 
    Data pages: 1832, average fill: 80% 
    Primary pages: 1831, secondary pages: 1, swept pages: 6 
    Empty pages: 21, full pages: 1562 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 57 
    40 - 59% = 77 
    60 - 79% = 379 
    80 - 99% = 1236 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705197, depth: 3, leaf buckets: 330, nodes: 122892 
    Average node length: 12.98, total dup: 10356, max dup: 2 
    Average key length: 10.51, compression ratio: 2.57 
    Average prefix length: 19.41, average data length: 7.59 
    Clustering factor: 89461, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 209 
        60 - 79% = 75 
        80 - 99% = 44 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18686, max versions: 986 
    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: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, 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: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 11.08, total records: 2133 
    Average version length: 43.28, total versions: 1606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.23 
    Pointer pages: 1, data page slots: 40 
    Data pages: 27, average fill: 72% 
    Primary pages: 26, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 19 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 16 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91591, depth: 2, leaf buckets: 2, nodes: 2133 
    Average node length: 4.32, total dup: 2036, max dup: 240 
    Average key length: 2.49, compression ratio: 7.64 
    Average prefix length: 18.56, average data length: 0.44 
    Clustering factor: 1097, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.22, total records: 74 
    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: 52% 
    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: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    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: 520, Index root page: 521 
    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: 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 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, 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: 1504226, 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: 1504228, 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: 1504225, 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: 522, Index root page: 523 
    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: 1504224, 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: 1504222, 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: 1504221, 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: 1504223, 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: 1504220, 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: 468, Index root page: 469 
    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: 1544805, 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: 1544804, 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: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.68, total records: 811465 
    Average version length: 26.03, total versions: 45066, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8448 
    Data pages: 8440, average fill: 67% 
    Primary pages: 8404, secondary pages: 36, swept pages: 2784 
    Empty pages: 96, full pages: 6126 
    Fill distribution: 
     0 - 19% = 222 
    20 - 39% = 276 
    40 - 59% = 486 
    60 - 79% = 7319 
    80 - 99% = 137 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 917, nodes: 811465 
    Average node length: 4.87, total dup: 811416, max dup: 142649 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89394, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 142 
        40 - 59% = 523 
        60 - 79% = 201 
        80 - 99% = 49 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1009, nodes: 811465 
    Average node length: 5.88, total dup: 722239, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159241, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 123 
        40 - 59% = 520 
        60 - 79% = 162 
        80 - 99% = 201 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1061, nodes: 811465 
    Average node length: 5.89, total dup: 722239, max dup: 42 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.08, average data length: 0.92 
    Clustering factor: 161159, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 203 
        40 - 59% = 519 
        60 - 79% = 149 
        80 - 99% = 189 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1146, nodes: 811465 
    Average node length: 5.96, total dup: 722239, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154022, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 231 
        40 - 59% = 624 
        60 - 79% = 210 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5471 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.73, total fragments: 75, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 74, secondary pages: 22, swept pages: 59 
    Empty pages: 12, full pages: 66 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 67 
    80 - 99% = 2 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5471 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.44, average data length: 1.54 
    Clustering factor: 5097, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5471 
    Average node length: 11.11, 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: 143, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.21, total records: 81006 
    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.22 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 781 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 781 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34586, depth: 2, leaf buckets: 105, nodes: 81006 
    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: 3207, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    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: 1504239, 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: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, 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: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 124.53, total records: 206798 
    Average version length: 155.11, total versions: 36384, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.62 
    Pointer pages: 8, data page slots: 5248 
    Data pages: 4968, average fill: 88% 
    Primary pages: 4967, secondary pages: 1, swept pages: 1 
    Empty pages: 35, full pages: 4914 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4915 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 127.94, total records: 204062 
    Average version length: 154.60, total versions: 31531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.26 
    Pointer pages: 8, data page slots: 5928 
    Data pages: 4952, average fill: 87% 
    Primary pages: 4952, secondary pages: 0, swept pages: 18 
    Empty pages: 78, full pages: 4843 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 10 
    80 - 99% = 4844 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 145.09, total records: 179217 
    Average version length: 153.71, total versions: 7444, 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: 5584 
    Data pages: 4368, average fill: 85% 
    Primary pages: 4368, secondary pages: 0, swept pages: 1 
    Empty pages: 95, full pages: 4240 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 11 
    80 - 99% = 4240 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.51, total records: 152876 
    Average version length: 151.81, total versions: 3318, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 8, data page slots: 3944 
    Data pages: 3736, average fill: 84% 
    Primary pages: 3736, secondary pages: 0, swept pages: 2 
    Empty pages: 101, full pages: 3604 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 10 
    40 - 59% = 11 
    60 - 79% = 7 
    80 - 99% = 3604 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.55, total records: 155376 
    Average version length: 151.38, total versions: 1537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 4224 
    Data pages: 3728, average fill: 86% 
    Primary pages: 3728, secondary pages: 0, swept pages: 1 
    Empty pages: 37, full pages: 3675 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3676 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 137.79, total records: 181616 
    Average version length: 154.44, total versions: 16015, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.31 
    Pointer pages: 8, data page slots: 5008 
    Data pages: 4360, average fill: 87% 
    Primary pages: 4360, secondary pages: 0, swept pages: 1 
    Empty pages: 39, full pages: 4304 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4305 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 136.61, total records: 190574 
    Average version length: 154.77, total versions: 18573, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.41 
    Pointer pages: 8, data page slots: 5624 
    Data pages: 4616, average fill: 86% 
    Primary pages: 4615, secondary pages: 1, swept pages: 2 
    Empty pages: 72, full pages: 4524 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4523 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 144.91, total records: 157509 
    Average version length: 152.89, total versions: 6174, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 6, data page slots: 5832 
    Data pages: 3816, average fill: 85% 
    Primary pages: 3816, secondary pages: 0, swept pages: 1 
    Empty pages: 74, full pages: 3714 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 12 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3714 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 145.36, total records: 170125 
    Average version length: 153.54, total versions: 6329, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 8, data page slots: 4416 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4072, secondary pages: 0, swept pages: 3 
    Empty pages: 30, full pages: 4025 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4025 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.05, total records: 154729 
    Average version length: 150.21, total versions: 1770, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 3832 
    Data pages: 3704, average fill: 86% 
    Primary pages: 3704, secondary pages: 0, swept pages: 2 
    Empty pages: 34, full pages: 3654 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 1 
    80 - 99% = 3656 
 
PHRASES (143) 
    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 PHRASES_ID_DESC (3) 
    Root page: 1510354, 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: 1510353, 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: 1510352, 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: 1510351, 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: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.89, total records: 2083070 
    Average version length: 52.87, total versions: 34045, 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: 25688 
    Data pages: 25688, average fill: 70% 
    Primary pages: 25688, secondary pages: 0, swept pages: 12220 
    Empty pages: 367, full pages: 19658 
    Fill distribution: 
     0 - 19% = 719 
    20 - 39% = 569 
    40 - 59% = 1380 
    60 - 79% = 22731 
    80 - 99% = 289 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2589, nodes: 2083070 
    Average node length: 5.44, total dup: 1943796, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180527, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 327 
        40 - 59% = 1697 
        60 - 79% = 276 
        80 - 99% = 285 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2083070 
    Average node length: 5.70, total dup: 1869060, max dup: 70 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372670, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2459 
        60 - 79% = 274 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2164, nodes: 2083070 
    Average node length: 4.96, total dup: 2082970, max dup: 28310 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178434, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 247 
        40 - 59% = 1155 
        60 - 79% = 374 
        80 - 99% = 385 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    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: 1504317, 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: 470, Index root page: 471 
    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: 1544803, 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: 1544802, 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: 500, Index root page: 501 
    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: 1504305, 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: 1504306, 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: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, 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: 2 
    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: 525, 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: 1544806, 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: 454, Index root page: 455 
    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: 1544810, 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: 460, Index root page: 461 
    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: 1544807, 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: 462, Index root page: 463 
    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: 464, Index root page: 465 
    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: 518, Index root page: 519 
    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: 516, Index root page: 517 
    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: 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 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    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: 456, Index root page: 457 
    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: 1544809, 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: 1544808, 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: 452, Index root page: 453 
    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: 1544811, 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: 528, Index root page: 529 
    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: 1504214, 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: 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 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    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: 1552159, 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: 1510355, 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: 1510360, 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: 1510358, 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: 498, Index root page: 499 
    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: 1504307, 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: 1504308, 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: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 45.71, total records: 134020 
    Average version length: 69.18, total versions: 45529, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.76 
    Pointer pages: 3, data page slots: 4552 
    Data pages: 3048, average fill: 51% 
    Primary pages: 3048, secondary pages: 0, swept pages: 579 
    Empty pages: 552, full pages: 1134 
    Fill distribution: 
     0 - 19% = 765 
    20 - 39% = 290 
    40 - 59% = 396 
    60 - 79% = 876 
    80 - 99% = 721 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105762, depth: 3, leaf buckets: 227, nodes: 134020 
    Average node length: 6.43, total dup: 116552, max dup: 14 
    Average key length: 3.97, compression ratio: 10.59 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22748, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 70 
        40 - 59% = 113 
        60 - 79% = 40 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.40, total records: 7000340 
    Average version length: 68.76, total versions: 260354, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 64, data page slots: 103400 
    Data pages: 103400, average fill: 72% 
    Primary pages: 103400, secondary pages: 0, swept pages: 44805 
    Empty pages: 22, full pages: 66762 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 958 
    40 - 59% = 9058 
    60 - 79% = 90246 
    80 - 99% = 3044 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10705, nodes: 7000340 
    Average node length: 6.51, total dup: 6053819, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1548827, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1839 
        40 - 59% = 5736 
        60 - 79% = 2586 
        80 - 99% = 532 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8449, nodes: 7000340 
    Average node length: 5.40, total dup: 6721908, max dup: 157 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1351316, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1132 
        40 - 59% = 4701 
        60 - 79% = 1663 
        80 - 99% = 945 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8525, nodes: 7000340 
    Average node length: 5.40, total dup: 6721908, max dup: 157 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1353780, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1225 
        40 - 59% = 4690 
        60 - 79% = 1669 
        80 - 99% = 936 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.74, total records: 11962427 
    Average version length: 68.76, total versions: 211268, 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: 104, data page slots: 168832 
    Data pages: 168832, average fill: 75% 
    Primary pages: 168832, secondary pages: 0, swept pages: 95191 
    Empty pages: 15, full pages: 143708 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 621 
    40 - 59% = 6044 
    60 - 79% = 159154 
    80 - 99% = 2931 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18452, nodes: 11962427 
    Average node length: 6.58, total dup: 10427139, max dup: 73 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2359549, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 2536 
        40 - 59% = 10909 
        60 - 79% = 4242 
        80 - 99% = 730 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 49.08, total records: 1437673 
    Average version length: 69.12, total versions: 417378, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.57 
    Pointer pages: 30, data page slots: 47408 
    Data pages: 28512, average fill: 57% 
    Primary pages: 28510, secondary pages: 2, swept pages: 11191 
    Empty pages: 3875, full pages: 16003 
    Fill distribution: 
     0 - 19% = 6437 
    20 - 39% = 2458 
    40 - 59% = 2026 
    60 - 79% = 11035 
    80 - 99% = 6556 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2221, nodes: 1437673 
    Average node length: 5.53, total dup: 1379403, max dup: 49 
    Average key length: 2.57, compression ratio: 16.34 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 95528, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 947 
        40 - 59% = 923 
        60 - 79% = 315 
        80 - 99% = 28 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 43.13, total records: 1047450 
    Average version length: 69.14, total versions: 392887, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.92 
    Pointer pages: 23, data page slots: 37008 
    Data pages: 29328, average fill: 41% 
    Primary pages: 29328, secondary pages: 0, swept pages: 10076 
    Empty pages: 6720, full pages: 9230 
    Fill distribution: 
     0 - 19% = 10966 
    20 - 39% = 3992 
    40 - 59% = 3147 
    60 - 79% = 4532 
    80 - 99% = 6691 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1637, nodes: 1047450 
    Average node length: 5.79, total dup: 977618, max dup: 99 
    Average key length: 2.86, compression ratio: 14.66 
    Average prefix length: 41.20, average data length: 0.80 
    Clustering factor: 142494, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 575 
        40 - 59% = 793 
        60 - 79% = 236 
        80 - 99% = 28 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.89, total records: 9135157 
    Average version length: 68.97, total versions: 398551, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 91, data page slots: 146936 
    Data pages: 146920, average fill: 67% 
    Primary pages: 146919, secondary pages: 1, swept pages: 68157 
    Empty pages: 316, full pages: 70423 
    Fill distribution: 
     0 - 19% = 1306 
    20 - 39% = 9230 
    40 - 59% = 27386 
    60 - 79% = 104372 
    80 - 99% = 4626 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13534, nodes: 9135157 
    Average node length: 6.70, total dup: 7577851, max dup: 23 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1984813, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1366 
        40 - 59% = 6983 
        60 - 79% = 4533 
        80 - 99% = 650 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21151554 
    Average version length: 82.73, total versions: 6917, 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: 318832 
    Data pages: 318832, average fill: 81% 
    Primary pages: 318832, secondary pages: 0, swept pages: 13967 
    Empty pages: 43, full pages: 318083 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 33 
    40 - 59% = 109 
    60 - 79% = 27973 
    80 - 99% = 290659 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19552, nodes: 21151554 
    Average node length: 5.72, total dup: 20670490, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282629, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8472 
        60 - 79% = 522 
        80 - 99% = 10554 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17212, nodes: 21151554 
    Average node length: 6.31, total dup: 18587504, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917364, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 836 
        60 - 79% = 272 
        80 - 99% = 16094 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21357, nodes: 21151554 
    Average node length: 6.35, total dup: 18507101, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3576844, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8765 
        60 - 79% = 622 
        80 - 99% = 11961 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16199, nodes: 21151554 
    Average node length: 5.56, total dup: 21151454, max dup: 231903 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945921, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 3042 
        60 - 79% = 427 
        80 - 99% = 12722 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.68, total records: 9500326 
    Average version length: 82.60, total versions: 315523, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 107, data page slots: 174280 
    Data pages: 174232, average fill: 67% 
    Primary pages: 174232, secondary pages: 0, swept pages: 97538 
    Empty pages: 697, full pages: 85264 
    Fill distribution: 
     0 - 19% = 2265 
    20 - 39% = 11084 
    40 - 59% = 34204 
    60 - 79% = 76216 
    80 - 99% = 50463 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11430, nodes: 9500326 
    Average node length: 5.38, total dup: 9193112, max dup: 171 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2090512, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 149 
        40 - 59% = 8752 
        60 - 79% = 2487 
        80 - 99% = 42 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13507, nodes: 9500326 
    Average node length: 6.25, total dup: 7876096, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1450892, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 4275 
        40 - 59% = 4215 
        60 - 79% = 2557 
        80 - 99% = 2349 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12769, nodes: 9500326 
    Average node length: 6.00, total dup: 8237330, max dup: 38 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2273248, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 184 
        40 - 59% = 9743 
        60 - 79% = 2774 
        80 - 99% = 67 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10097, nodes: 9500326 
    Average node length: 5.15, total dup: 9500226, max dup: 161110 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1505775, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1450 
        40 - 59% = 4914 
        60 - 79% = 1689 
        80 - 99% = 2003 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.47, total records: 11225212 
    Average version length: 82.48, total versions: 250685, 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: 120, data page slots: 194888 
    Data pages: 193144, average fill: 71% 
    Primary pages: 193144, secondary pages: 0, swept pages: 80302 
    Empty pages: 3497, full pages: 137462 
    Fill distribution: 
     0 - 19% = 6235 
    20 - 39% = 9370 
    40 - 59% = 21197 
    60 - 79% = 44532 
    80 - 99% = 111810 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13145, nodes: 11225212 
    Average node length: 5.31, total dup: 11115556, max dup: 637 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2340389, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 118 
        40 - 59% = 9541 
        60 - 79% = 3356 
        80 - 99% = 130 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10422, nodes: 11225212 
    Average node length: 5.50, total dup: 10735184, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 710974, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 929 
        40 - 59% = 2476 
        60 - 79% = 1825 
        80 - 99% = 5020 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15028, nodes: 11225212 
    Average node length: 6.03, total dup: 9791185, max dup: 65 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2356750, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 127 
        40 - 59% = 11059 
        60 - 79% = 3685 
        80 - 99% = 157 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10749, nodes: 11225212 
    Average node length: 5.23, total dup: 11225112, max dup: 204828 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 700509, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 919 
        40 - 59% = 4716 
        60 - 79% = 1480 
        80 - 99% = 3529 
 
XQS_2000_3300 (185) 
    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 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, 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: 1361755, 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: 1361754, 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: 1361752, 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: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 80.04, total records: 9613166 
    Average version length: 82.91, total versions: 313497, 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: 178640 
    Data pages: 178592, average fill: 67% 
    Primary pages: 178592, secondary pages: 0, swept pages: 103757 
    Empty pages: 828, full pages: 84414 
    Fill distribution: 
     0 - 19% = 2641 
    20 - 39% = 12291 
    40 - 59% = 36369 
    60 - 79% = 78170 
    80 - 99% = 49121 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11810, nodes: 9613166 
    Average node length: 5.19, total dup: 9584648, max dup: 1867 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1898514, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1667 
        40 - 59% = 7786 
        60 - 79% = 1787 
        80 - 99% = 530 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13727, nodes: 9613166 
    Average node length: 6.27, total dup: 7969358, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1400249, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 195 
        20 - 39% = 4327 
        40 - 59% = 4125 
        60 - 79% = 2635 
        80 - 99% = 2445 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12405, nodes: 9613166 
    Average node length: 5.45, total dup: 9180471, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2027317, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1505 
        40 - 59% = 8709 
        60 - 79% = 1654 
        80 - 99% = 509 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10263, nodes: 9613166 
    Average node length: 5.17, total dup: 9613066, max dup: 162519 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1509793, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1415 
        40 - 59% = 5156 
        60 - 79% = 1618 
        80 - 99% = 2029 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.45, total records: 569090 
    Average version length: 68.68, total versions: 6027, 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: 5, data page slots: 8088 
    Data pages: 8088, average fill: 74% 
    Primary pages: 8088, secondary pages: 0, swept pages: 4271 
    Empty pages: 5, full pages: 6063 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 62 
    40 - 59% = 461 
    60 - 79% = 7474 
    80 - 99% = 79 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 34793, depth: 3, leaf buckets: 748, nodes: 569090 
    Average node length: 5.95, total dup: 484326, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 98764, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 550 
        60 - 79% = 83 
        80 - 99% = 75 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 27077, depth: 3, leaf buckets: 769, nodes: 569090 
    Average node length: 6.15, total dup: 466573, max dup: 15 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 98813, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 45 
        40 - 59% = 554 
        60 - 79% = 86 
        80 - 99% = 84 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 577, nodes: 569090 
    Average node length: 4.86, total dup: 568990, max dup: 9211 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 87844, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 47 
        40 - 59% = 334 
        60 - 79% = 84 
        80 - 99% = 111 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    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: 535, Index root page: 536 
    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: 539, Index root page: 540 
    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: 545, Index root page: 546 
    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: 1504207, 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: 547, Index root page: 548 
    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: 1504206, 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: 541, Index root page: 542 
    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: 1504212, 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: 1504213, 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: 543, Index root page: 544 
    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: 1504209, 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: 1504208, 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: 1504211, 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: 1504210, 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: 533, Index root page: 534 
    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: 531, Index root page: 532 
    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: 484, Index root page: 485 
    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: 1510350, 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 Feb 18 16:12:23 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7753865 85126 1 0.0000 0.0000
DOC_LIST 2245904 90229 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 245114 634 61200.0000 0.0000
INVNT_TURNOVER_LOG 122892 85226 1 0.0000 0.0000
MONEY_SALDO 49 18686 986 38100.0000 0.0000
MONEY_TURNOVER_LOG 2133 1606 1 0.0000 0.0000
PDISTR 811465 45066 4 0.0000 0.0000
PERF_SPLIT_0 206798 36384 1 0.0000 0.0000
PERF_SPLIT_1 204062 31531 1 0.0000 0.0000
PERF_SPLIT_2 179217 7444 1 0.0000 0.0000
PERF_SPLIT_3 152876 3318 1 0.0000 0.0000
PERF_SPLIT_4 155376 1537 1 0.0000 0.0000
PERF_SPLIT_5 181616 16015 1 0.0000 0.0000
PERF_SPLIT_6 190574 18573 1 0.0000 0.0000
PERF_SPLIT_7 157509 6174 1 0.0000 0.0000
PERF_SPLIT_8 170125 6329 1 0.0000 0.0000
PERF_SPLIT_9 154729 1770 1 0.0000 0.0000
PSTORNED 2083070 34045 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 134020 45529 1 0.0000 0.0000
XQD_1000_3300 7000340 260354 1 0.0000 0.0000
XQD_1200_2000 11962427 211268 1 0.0000 0.0000
XQD_2000_3300 1437673 417378 1 0.0000 0.0000
XQD_2100_3300 1047450 392887 1 0.0000 0.0000
XQD_3300_3400 9135157 398551 1 0.0000 0.0000
XQS_1000_1200 21151554 6917 1 0.0000 0.0000
XQS_1000_3300 9500326 315523 1 0.0000 0.0000
XQS_1200_2000 11225212 250685 1 0.0000 0.0000
XQS_2100_3300 9613166 313497 1 0.0000 0.0000
XQS_3300_3400 569090 6027 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 ---
:764: 
:765: mscs-test-161.budzdorov.ru    Sun Feb 18 16:09:55 2024
:766:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:767: 
--- end of diff output ---

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

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