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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-29 10:07:48
DTS_END                         2024-02-29 10:07:48.2600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/44262
TRN_ID                          176658
ATT_ID                          521
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: 9347.90 23133 934790
customer order: creation 179.71 374 17971
customer order: refuse 15.45 374 1545
order to supplier: creation 48.68 1299 4868
order to supplier: removal 3.44 95357 344
invoice (draft): creation 47.59 2784 4759
invoice (draft): removal 50.13 705 5013
invoice accept: apply 43.89 19637 4389
invoice accept: cancel 45.60 829 4560
customer reserve: creation 4101.23 194 410123
customer reserve: removal 4505.38 59 450538
realization accept: apply 88.94 212 8894
realization accept: cancel 81.79 135 8179
payment from customer: creation 63.41 144 6341
payment from customer: removal 6.26 103 626
payment to supplier: creation 50.99 146 5099
payment to supplier: removal 3.57 110 357
service: total inventory turnovers 4.08 3987 408
service: total monetary turnovers 6.81 616 681
service: aggregate perf. data 0.92 15683 92
service: refresh index statistics 0.03 319914 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-02-2024 10:09:46 to 29-02-2024 10:09:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5709
TEST_TIME 2 6381
TEST_TIME 3 5350
TEST_TIME 4 5638
TEST_TIME 5 5708
TEST_TIME 6 5911
TEST_TIME 7 5897
TEST_TIME 8 6715
TEST_TIME 9 6599
TEST_TIME 10 6631
TEST_TIME 11 6313
TEST_TIME 12 6735
TEST_TIME 13 6553
TEST_TIME 14 6830
TEST_TIME 15 6853
TEST_TIME 16 6881
TEST_TIME 17 7156
TEST_TIME 18 7416
TEST_TIME 19 7804
TEST_TIME 20 8114
TEST_TIME 21 8297
TEST_TIME 22 8333
TEST_TIME 23 9234
TEST_TIME 24 9414
TEST_TIME 25 9468
TEST_TIME 26 9517
TEST_TIME 27 9641
TEST_TIME 28 9571
TEST_TIME 29 9439
TEST_TIME 30 9403
TEST_TIME 31 9634
TEST_TIME 32 9681
TEST_TIME 33 9633
TEST_TIME 34 9642
TEST_TIME 35 9539
TEST_TIME 36 9347
TEST_TIME 37 9304
TEST_TIME 38 9149
TEST_TIME 39 9110
TEST_TIME 40 9023
TEST_TIME 41 9231
TEST_TIME 42 9091
TEST_TIME 43 9177
TEST_TIME 44 9128
TEST_TIME 45 9299
TEST_TIME 46 9274
TEST_TIME 47 9259
TEST_TIME 48 9456
TEST_TIME 49 9498
TEST_TIME 50 9468
TEST_TIME 51 9686
TEST_TIME 52 9686
TEST_TIME 53 9693
TEST_TIME 54 9651
TEST_TIME 55 9774
TEST_TIME 56 9706
TEST_TIME 57 9609
TEST_TIME 58 9499
TEST_TIME 59 9464
TEST_TIME 60 9423
TEST_TIME 61 9450
TEST_TIME 62 9411
TEST_TIME 63 9317
TEST_TIME 64 9283
TEST_TIME 65 9320
TEST_TIME 66 9292
TEST_TIME 67 9289
TEST_TIME 68 9317
TEST_TIME 69 9260
TEST_TIME 70 9304
TEST_TIME 71 9454
TEST_TIME 72 9435
TEST_TIME 73 9491
TEST_TIME 74 9485
TEST_TIME 75 9570
TEST_TIME 76 9583
TEST_TIME 77 9643
TEST_TIME 78 9655
TEST_TIME 79 9549
TEST_TIME 80 9493
TEST_TIME 81 9435
TEST_TIME 82 9437
TEST_TIME 83 9344
TEST_TIME 84 9284
TEST_TIME 85 9211
TEST_TIME 86 9323
TEST_TIME 87 9301
TEST_TIME 88 9285
TEST_TIME 89 9253
TEST_TIME 90 9264
TEST_TIME 91 9383
TEST_TIME 92 9365
TEST_TIME 93 9313
TEST_TIME 94 9346
TEST_TIME 95 9384
TEST_TIME 96 9357
TEST_TIME 97 9382
TEST_TIME 98 9422
TEST_TIME 99 9402
TEST_TIME 100 9354

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-02-2024 10:09:49 to 29-02-2024 10:09:52.

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 1310516 1310516 0 0.00 0 13066 7 0 0
doc_list_biud 1310515 1310515 0 0.00 0 24857 26 0 0
sp_add_invoice_to_stock 4514 4389 125 2.76 27 174765 19638 0 125
sp_cancel_adding_invoice 4560 4560 0 0.00 4 84826 830 0 0
sp_cancel_client_order 1545 1545 0 0.00 4 12544 375 0 0
sp_cancel_customer_reserve 450538 450538 0 0.00 0 24859 60 0 0
sp_cancel_pay_from_customer 626 626 0 0.00 2 8610 103 0 0
sp_cancel_pay_to_supplier 357 357 0 0.00 2 9000 110 0 0
sp_cancel_supplier_invoice 5022 5013 9 0.17 1 22656 705 0 9
sp_cancel_supplier_order 344 344 0 0.00 9 1018756 95358 0 0
sp_cancel_write_off 8179 8179 0 0.00 1 15043 135 0 0
sp_client_order 17971 17971 0 0.00 3 18608 375 0 0
sp_customer_reserve 410123 410123 0 0.00 0 42986 194 0 0
sp_fill_shopping_cart 27593 27593 0 0.00 1 16424 37 0 0
sp_fill_shopping_cart_clo_res 410119 410119 0 0.00 0 14408 14 0 0
sp_get_clo_for_invoice 4380 4380 0 0.00 0 16099 326 0 0
sp_kill_cost_storno 13722 13722 0 0.00 0 7176 61 0 0
sp_kill_qstorno_ret_qs2qd 914612 914612 0 0.00 0 24856 32 0 0
sp_kill_qty_storno 483452 483452 0 0.00 0 24857 69 0 0
sp_lock_selected_doc 18371 18371 0 0.00 0 8984 5 0 0
sp_make_cost_storno 24714 24714 0 0.00 0 12846 60 0 0
sp_multiply_rows_for_pdistr 24714 24714 0 0.00 0 11621 35 0 0
sp_multiply_rows_for_qdistr 17971 17971 0 0.00 0 11067 165 0 0
sp_pay_from_customer 6341 6341 0 0.00 4 16824 145 0 0
sp_pay_to_supplier 5099 5099 0 0.00 4 16374 147 0 0
sp_payment_common 11440 11440 0 0.00 1 8032 25 0 0
sp_qd_handle_on_cancel_clo 1545 1545 0 0.00 0 7814 331 0 0
sp_qd_handle_on_invoice_upd_sts 8940 8940 0 0.00 0 21136 302 0 0
sp_qd_handle_on_reserve_upd_sts 8893 8893 0 0.00 0 15155 62 0 0
sp_reserve_write_off 8894 8894 0 0.00 6 16784 213 0 0
sp_supplier_invoice 4759 4759 0 0.00 7 54929 2785 0 0
sp_supplier_order 4868 4868 0 0.00 4 24045 1299 0 0
srv_aggregate_perf_data 92 92 0 0.00 2214 167861 15683 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1809 116919 43930 0 0
srv_find_qd_qs_mism 890776 890776 0 0.00 0 9434 7 0 0
srv_make_invnt_saldo 408 408 0 0.00 64 114953 3987 0 0
srv_make_money_saldo 681 681 0 0.00 1 13490 617 0 0
srv_recalc_idx_stat 3 3 0 0.00 268307 402769 319914 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4390 4390 0 0.00 0 13119 187 0 0
t$perf-norm:sp_cancel_adding_invoice 363 363 0 0.00 1 8629 156 0 0
t$perf-norm:sp_cancel_client_order 1545 1545 0 0.00 0 5058 18 0 0
t$perf-norm:sp_cancel_customer_reserve 609 609 0 0.00 0 2033 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 626 626 0 0.00 0 1718 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 357 357 0 0.00 0 2692 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 366 366 0 0.00 0 1525 17 0 0
t$perf-norm:sp_cancel_supplier_order 344 344 0 0.00 0 18968 1778 0 0
t$perf-norm:sp_cancel_write_off 889 889 0 0.00 0 1338 7 0 0
t$perf-norm:sp_client_order 17972 17972 0 0.00 0 7615 17 0 0
t$perf-norm:sp_customer_reserve 875 875 0 0.00 0 2098 8 0 0
t$perf-norm:sp_pay_from_customer 6341 6341 0 0.00 0 5110 12 0 0
t$perf-norm:sp_pay_to_supplier 5099 5099 0 0.00 0 6296 13 0 0
t$perf-norm:sp_reserve_write_off 8894 8894 0 0.00 0 4946 12 0 0
t$perf-norm:sp_supplier_invoice 4759 4759 0 0.00 0 3366 21 0 0
t$perf-norm:sp_supplier_order 4868 4868 0 0.00 0 5221 19 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 868 25 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 74 2 0 0
t$perf-norm:srv_make_invnt_saldo 408 408 0 0.00 0 819 9 0 0
t$perf-norm:srv_make_money_saldo 681 681 0 0.00 0 3729 11 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 12 5 0 0
v_add_invoice_to_stock 9010 8760 250 2.77 0 13401 22 0 250
v_all_customers 33400 33400 0 0.00 0 27 1 0 0
v_all_suppliers 26994 26994 0 0.00 0 22 1 0 0
v_all_wares 35942 35942 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 726 726 0 0.00 0 518 6 0 0
v_cancel_client_order 3090 3090 0 0.00 0 11777 15 0 0
v_cancel_customer_prepayment 1252 1252 0 0.00 0 4174 13 0 0
v_cancel_customer_reserve 1218 1218 0 0.00 0 14773 32 0 0
v_cancel_payment_to_supplier 714 714 0 0.00 0 2317 9 0 0
v_cancel_supplier_invoice 750 732 18 2.40 0 14763 39 0 18
v_cancel_supplier_order 688 688 0 0.00 0 13402 23 0 0
v_cancel_write_off 1778 1778 0 0.00 0 14792 24 0 0
v_max_id_clo_ord 4867 4867 0 0.00 0 337 1 0 0
v_max_id_clo_res 875 875 0 0.00 0 3170 14 0 0
v_max_id_ord_sup 4755 4755 0 0.00 0 2460 2 0 0
v_max_non_paid_invoice 1224 1224 0 0.00 0 25 1 0 0
v_max_non_paid_realizn 3160 3160 0 0.00 0 873 3 0 0
v_min_id_clo_ord 4867 4867 0 0.00 0 8835 11 0 0
v_min_id_clo_res 875 875 0 0.00 0 6595 16 0 0
v_min_id_ord_sup 4755 4755 0 0.00 0 6439 9 0 0
v_min_non_paid_invoice 5099 5099 0 0.00 0 6664 13 0 0
v_min_non_paid_realizn 6341 6341 0 0.00 0 8028 25 0 0
v_our_firm 8904 8904 0 0.00 0 18 1 0 0
v_reserve_write_off 17784 17784 0 0.00 0 16737 13 0 0
x_lock_depdocs_on_canc_invoice 9207 9207 0 0.00 0 33265 107 0 0
x_lock_depdocs_on_canc_sup_ord 344 344 0 0.00 0 3951 355 0 0
x_make_qstorno_1000_1200 4868 4868 0 0.00 1 24002 1216 0 0
x_make_qstorno_1200_2000 4759 4759 0 0.00 3 54919 2655 0 0
x_make_qstorno_2100_3300 410123 410123 0 0.00 0 42984 177 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 29-02-2024 10:09:53 to 29-02-2024 10:09:58.

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
08:07:52 14 8192000000 8802844656 8815497216 5752384 0.070 3 1 2 0 5853552 65392 35776
08:08:52 31170 8192000000 9720262064 10019790848 792023840 8.815 100 90 180 0 821435584 7317808 22093936
08:10:30 15804 8192000000 9751810256 10057527296 828398896 9.183 100 83 166 0 860125840 11837936 19889008
08:11:49 16640 8192000000 9781384048 10098696192 857007296 9.470 100 83 165 0 893089824 16905184 19177344
08:13:18 8464 8192000000 9842197328 10173349888 899449536 9.893 100 79 158 0 954480320 37309072 17721712
08:14:31 9285 8192000000 9896222896 10238222336 941623392 10.309 100 79 153 1 1003632144 45170512 16838240
08:15:43 4987 8192000000 9971654336 10322386944 983579152 10.719 100 84 168 0 1077991504 77137472 17274880
08:16:52 2669 8192000000 9992232176 10356121600 1014808544 11.022 100 84 168 1 1107018448 75641008 16568896
08:17:56 3531 8192000000 10017082320 10390102016 1041485344 11.279 100 77 152 1 1122894640 66593424 14815872
08:19:01 1399 8192000000 10034993440 10410184704 1062694416 11.482 100 88 176 0 1149155632 68393504 18067712
08:20:04 1166 8192000000 10034338192 10415349760 1077093136 11.620 100 77 154 0 1148726672 55452288 16181248
08:21:08 12187 8192000000 10012168496 10396168192 1077958160 11.628 100 72 138 1 1126399040 33940272 14500608
08:22:21 5070 8192000000 10016948192 10414137344 1086880912 11.713 100 40 79 0 1140473136 45484352 8107872
08:23:27 6746 8192000000 10009896496 10411229184 1094021744 11.781 100 31 62 0 1136302928 36273232 6007952
08:24:35 6038 8192000000 10004813056 10411024384 1096311680 11.803 100 36 71 2 1128864576 24060016 8492880
08:25:43 46711 8192000000 10025139680 10424958976 1101278208 11.850 100 58 110 1 1127332400 14654944 11399248
08:27:31 7226 8192000000 10023607648 10429112320 1099801776 11.836 100 20 40 0 1129854624 25972768 4080080
08:28:44 9528 8192000000 10065998896 10464378880 1109097984 11.924 100 60 119 1 1172921376 51591072 12232320
08:29:59 55905 8192000000 10071564752 10472558592 1083282160 11.679 97 49 96 0 1148956976 55627168 10047648
08:32:00 16557 8192000000 10092951760 10499149824 1092097600 11.763 98 47 94 0 1178719136 76995408 9626128
08:33:19 9087 8192000000 10111070256 10512101376 1106877040 11.903 99 56 110 0 1206171152 88274192 11019920
08:34:32 24246 8192000000 10129526304 10536873984 1087982160 11.723 97 43 86 1 1212683504 114509488 10191856
08:35:58 23619 8192000000 10097513536 10495860736 1084498976 11.690 98 54 105 0 1191686816 96130672 11057168
08:37:26 11980 8192000000 10127242688 10527023104 1095945456 11.799 98 41 81 0 1219633312 115114944 8572912
08:38:53 18262 8192000000 10165922944 10580209664 1107043440 11.904 99 48 95 0 1273339488 155456720 10839328
08:40:23 8220 8192000000 10200771504 10590867456 1120607072 12.033 100 72 143 0 1303141072 166845920 15688080
08:41:36 6301 8192000000 10209034688 10606866432 1115192592 11.982 100 59 115 1 1314958048 186530768 13234688
08:42:48 1809 8192000000 10237939552 10629611520 1129015168 12.112 100 76 153 1 1336427120 190925184 16486768
08:43:54 2234 8192000000 10283711744 10684096512 1135735968 12.175 100 65 126 1 1385075504 234517744 14821792
08:45:02 2363 8192000000 10332994976 10729799680 1142617104 12.240 100 87 173 0 1433528576 271382912 19528560
08:46:09 2522 8192000000 10301131760 10711678976 1140225680 12.218 100 67 132 0 1403414432 248242144 14946608
08:47:15 3140 8192000000 10306606000 10719170560 1155188048 12.358 100 71 140 0 1420706640 249892720 15625872
08:48:23 7169 8192000000 10292817168 10739306496 1151693312 12.325 100 32 60 1 1426865328 267449600 7722416
08:49:41 5695 8192000000 10310837056 10748960768 1149740656 12.307 100 49 96 0 1409069632 248025424 11303552
08:50:48 26366 8192000000 10193544768 10645372928 1130542304 12.126 99 26 49 0 1295621312 159522448 5556560
08:52:17 39467 8192000000 10104563872 10549235712 1126861296 12.092 99 24 48 1 1192359648 60000368 5497984
08:54:02 82140 8192000000 10081484352 10506498048 1136228320 12.180 100 23 46 0 1184656848 43462944 4965584
08:56:32 24287 8192000000 10101290960 10519875584 1147078880 12.282 100 47 92 1 1178073392 20804864 10189648
08:58:00 29272 8192000000 10127928256 10567077888 1154365792 12.350 100 30 60 0 1219341152 58238368 6736992
08:59:47 44842 8192000000 10086282960 10521559040 1149281824 12.303 100 12 22 0 1184398608 32989472 2127312
09:01:36 62601 8192000000 10094170720 10574848000 1132514800 12.145 98 10 20 0 1182082000 47660448 1906752
09:03:39 48946 8192000000 10101555584 10540969984 1143326064 12.247 99 42 84 2 1176165200 23787248 9051888
09:05:34 43626 8192000000 10145897520 10584883200 1169697040 12.494 100 31 63 1 1249646784 73025808 6923936
09:07:24 27931 8192000000 10211374464 10643156992 1159579392 12.399 98 44 88 0 1296044704 126854048 9611264
09:08:56 79236 8192000000 10140182592 10620239872 1091141280 11.754 94 17 35 2 1198334320 102935088 4257952
09:11:47 31503 8192000000 10079286640 10517618688 1070043120 11.552 94 19 38 0 1172710288 98308112 4359056
09:13:23 74580 8192000000 10161751824 10642817024 1125172432 12.076 98 18 36 0 1232904320 103557872 4174016
09:15:38 31683 8192000000 10102226288 10542391296 1125329568 12.077 100 10 20 0 1195256560 67670096 2256896
09:17:11 36289 8192000000 10110450144 10557190144 1108121408 11.915 98 38 76 0 1196159840 80034640 8003792
09:18:47 64145 8192000000 10059802192 10532954112 1076275376 11.612 96 22 44 0 1121256832 40526640 4454816
09:20:53 64377 8192000000 10064305040 10498035712 1052425200 11.384 95 31 60 0 1117518320 58556672 6536448
09:23:29 87717 8192000000 10028247216 10477735936 1077277744 11.622 98 24 48 0 1130209024 47668080 5263200
09:25:58 1856 8192000000 10018613312 10439446528 1089059712 11.734 100 58 110 1 1117482320 15761120 12661488
09:27:01 65346 8192000000 10082315584 10546372608 1093024848 11.771 99 14 28 0 1174442352 78155536 3261968
09:29:06 45910 8192000000 10019064080 10507202560 1086937680 11.714 99 9 18 0 1134933920 45667104 2329136
09:30:53 82804 8192000000 10055398640 10512117760 1110868640 11.941 100 11 22 0 1161621712 48238736 2514336
09:33:17 57076 8192000000 10077406992 10524434432 1098201648 11.821 98 16 32 0 1133841216 32205616 3433952
09:35:23 36966 8192000000 10054806784 10498920448 1094960576 11.790 98 16 32 0 1128218496 30126960 3130960
09:37:05 116919 8192000000 10077406128 10566373376 1124919024 12.073 99 16 32 0 1189992912 61570400 3503488
09:40:07 89082 8192000000 10087122896 10538704896 1108938112 11.922 97 15 30 0 1184490656 72557936 2994608
09:42:36 88778 8192000000 10106576848 10566651904 1115551040 11.985 97 8 16 0 1155779136 38863360 1364736
09:45:08 78840 8192000000 10055489024 10516344832 1132828672 12.148 99 12 25 2 1175848256 40598656 2420928
09:47:45 49323 8192000000 10095453744 10540941312 1144729728 12.260 100 15 30 0 1171977360 24433824 2813808
09:49:37 48963 8192000000 10101768944 10585886720 1154557104 12.352 100 10 20 0 1215481968 58565264 2359600
09:51:26 72623 8192000000 10168441520 10628710400 1151504576 12.324 99 20 40 0 1259846496 103428560 4913360
09:53:46 55643 8192000000 10071809488 10515161088 1136053552 12.178 98 23 46 1 1180729536 40139680 4536304
09:55:51 62082 8192000000 10146815264 10602344448 1138471792 12.201 98 29 56 0 1213138368 68695488 5971088
09:58:09 96920 8192000000 10068947616 10529349632 1104515120 11.880 95 15 30 0 1152982672 45540944 2926608
10:00:46 19502 8192000000 10120977648 10560212992 1133981936 12.159 99 43 86 0 1203460976 60519376 8959664
10:02:06 92353 8192000000 10056954656 10488672256 1012345184 10.998 89 32 62 1 1067368128 48646128 6376816
10:04:44 81758 8192000000 10095368752 10570792960 1065849904 11.512 96 23 46 0 1122856464 52436048 4570512
10:07:12 65729 8192000000 9470065456 9849008128 579617248 6.607 52 12 24 0 617825728 36227088 1981392

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 29-02-2024 10:10:00 to 29-02-2024 10:10:13.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-02-2024 10:10:14 to 29-02-2024 10:10:16.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          176419
MON$OLDEST_ACTIVE               176879
MON$OLDEST_SNAPSHOT             176879
MON$NEXT_TRANSACTION            176879
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1934944
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             707
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Feb 29 10:10:17 2024 
 
Database header page information: 
    Flags            0 
    Generation        92376 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    176419 
    Oldest active        176879 
    Oldest snapshot        176879 
    Next transaction    176880 
    Sequence number        0 
    Next attachment ID    707 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.59, total records: 7696491 
    Average version length: 48.16, total versions: 59096, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89016 
    Data pages: 89016, average fill: 69% 
    Primary pages: 89016, secondary pages: 0, swept pages: 47240 
    Empty pages: 6, full pages: 56406 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 62 
    40 - 59% = 2835 
    60 - 79% = 86070 
    80 - 99% = 37 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23221, nodes: 7696491 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1665655, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 319 
        20 - 39% = 2157 
        40 - 59% = 3891 
        60 - 79% = 2393 
        80 - 99% = 14461 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13482, nodes: 7696491 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1489413, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1815 
        40 - 59% = 1803 
        60 - 79% = 1097 
        80 - 99% = 8767 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8329, nodes: 7696491 
    Average node length: 6.61, total dup: 5770412, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1482297, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 1141 
        40 - 59% = 1218 
        60 - 79% = 951 
        80 - 99% = 4886 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.73, total records: 2217399 
    Average version length: 58.85, total versions: 31369, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28792 
    Data pages: 28792, average fill: 71% 
    Primary pages: 28791, secondary pages: 1, swept pages: 15624 
    Empty pages: 7, full pages: 13217 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 22 
    40 - 59% = 684 
    60 - 79% = 28022 
    80 - 99% = 51 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4544, nodes: 2217399 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 666095, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1057 
        40 - 59% = 708 
        60 - 79% = 764 
        80 - 99% = 2015 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2403, nodes: 2218058 
    Average node length: 4.97, total dup: 2217159, max dup: 19615 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1261354, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 234 
        40 - 59% = 1372 
        60 - 79% = 541 
        80 - 99% = 253 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1784, nodes: 2217399 
    Average node length: 4.97, total dup: 2217349, max dup: 130274 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062447, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 629 
        60 - 79% = 50 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4333, nodes: 2217399 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 666095, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 691 
        40 - 59% = 525 
        60 - 79% = 876 
        80 - 99% = 2145 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.17, total records: 400 
    Average version length: 23.92, total versions: 1825, max versions: 6 
    Average fragment length: 2.00, total fragments: 11, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 59% 
    Primary pages: 14, secondary pages: 10, swept pages: 0 
    Empty pages: 7, full pages: 14 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 20.70, total records: 111567 
    Average version length: 68.29, total versions: 89577, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.25 
    Pointer pages: 7, data page slots: 4088 
    Data pages: 2224, average fill: 66% 
    Primary pages: 2223, secondary pages: 1, swept pages: 172 
    Empty pages: 250, full pages: 1412 
    Fill distribution: 
     0 - 19% = 386 
    20 - 39% = 190 
    40 - 59% = 131 
    60 - 79% = 331 
    80 - 99% = 1186 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704679, depth: 3, leaf buckets: 380, nodes: 111567 
    Average node length: 13.33, total dup: 9296, max dup: 2 
    Average key length: 10.61, compression ratio: 2.54 
    Average prefix length: 19.30, average data length: 7.70 
    Clustering factor: 80736, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 57 
        40 - 59% = 272 
        60 - 79% = 49 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 68, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 42% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 13.91, total records: 1817 
    Average version length: 43.46, total versions: 1570, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.17 
    Pointer pages: 1, data page slots: 48 
    Data pages: 32, average fill: 60% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 3, full pages: 13 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 3 
    40 - 59% = 9 
    60 - 79% = 4 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92862, depth: 2, leaf buckets: 2, nodes: 1817 
    Average node length: 4.35, total dup: 1719, max dup: 230 
    Average key length: 2.57, compression ratio: 7.39 
    Average prefix length: 18.48, average data length: 0.52 
    Clustering factor: 968, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.64, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 37.07, total records: 814006 
    Average version length: 37.93, total versions: 15882, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8792 
    Data pages: 8792, average fill: 63% 
    Primary pages: 8790, secondary pages: 2, swept pages: 4583 
    Empty pages: 15, full pages: 4096 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 65 
    40 - 59% = 1287 
    60 - 79% = 7380 
    80 - 99% = 33 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 875, nodes: 807351 
    Average node length: 4.88, total dup: 807302, max dup: 155572 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90144, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 134 
        40 - 59% = 469 
        60 - 79% = 180 
        80 - 99% = 91 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 912, nodes: 807351 
    Average node length: 5.89, total dup: 718936, max dup: 53 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160486, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 25 
        40 - 59% = 468 
        60 - 79% = 94 
        80 - 99% = 323 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 947, nodes: 807351 
    Average node length: 5.89, total dup: 718936, max dup: 53 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162295, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 88 
        40 - 59% = 461 
        60 - 79% = 73 
        80 - 99% = 324 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1150, nodes: 807351 
    Average node length: 5.97, total dup: 718936, max dup: 53 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154497, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 251 
        40 - 59% = 597 
        60 - 79% = 214 
        80 - 99% = 83 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5449 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 4.35, total fragments: 20, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 128 
    Data pages: 112, average fill: 48% 
    Primary pages: 96, secondary pages: 16, swept pages: 62 
    Empty pages: 27, full pages: 68 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5449 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.42, average data length: 1.54 
    Clustering factor: 5199, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5449 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 160, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 80107 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 832 
    Data pages: 832, average fill: 66% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 831 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 832 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35158, depth: 2, leaf buckets: 103, nodes: 80107 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3379, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.55, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 125.33, total records: 173762 
    Average version length: 154.32, total versions: 31333, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.53 
    Pointer pages: 6, data page slots: 5744 
    Data pages: 4408, average fill: 84% 
    Primary pages: 4406, secondary pages: 2, swept pages: 2 
    Empty pages: 92, full pages: 4235 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 11 
    40 - 59% = 45 
    60 - 79% = 20 
    80 - 99% = 4236 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 141.33, total records: 146300 
    Average version length: 153.09, total versions: 10059, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 6, data page slots: 4632 
    Data pages: 3656, average fill: 83% 
    Primary pages: 3654, secondary pages: 2, swept pages: 2 
    Empty pages: 51, full pages: 3587 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3588 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.54, total records: 168029 
    Average version length: 152.24, total versions: 7917, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 6, data page slots: 5672 
    Data pages: 4184, average fill: 83% 
    Primary pages: 4182, secondary pages: 2, swept pages: 3 
    Empty pages: 43, full pages: 4121 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4121 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 145.72, total records: 160604 
    Average version length: 151.58, total versions: 6157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 6, data page slots: 5392 
    Data pages: 4024, average fill: 83% 
    Primary pages: 4022, secondary pages: 2, swept pages: 2 
    Empty pages: 66, full pages: 3937 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3937 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 116.23, total records: 179526 
    Average version length: 154.73, total versions: 43828, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.59 
    Pointer pages: 8, data page slots: 5464 
    Data pages: 4520, average fill: 85% 
    Primary pages: 4517, secondary pages: 3, swept pages: 4 
    Empty pages: 85, full pages: 4408 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 7 
    40 - 59% = 9 
    60 - 79% = 9 
    80 - 99% = 4408 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 139.19, total records: 186035 
    Average version length: 153.90, total versions: 15783, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.19 
    Pointer pages: 7, data page slots: 7464 
    Data pages: 4672, average fill: 83% 
    Primary pages: 4671, secondary pages: 1, swept pages: 1 
    Empty pages: 82, full pages: 4566 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4566 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 146.87, total records: 164898 
    Average version length: 151.55, total versions: 5036, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 4984 
    Data pages: 4120, average fill: 83% 
    Primary pages: 4119, secondary pages: 1, swept pages: 6 
    Empty pages: 58, full pages: 4044 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 4042 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 109.49, total records: 227709 
    Average version length: 154.62, total versions: 66748, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.49 
    Pointer pages: 6, data page slots: 6456 
    Data pages: 5688, average fill: 87% 
    Primary pages: 5686, secondary pages: 2, swept pages: 1 
    Empty pages: 61, full pages: 5611 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 5611 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 134.92, total records: 171149 
    Average version length: 154.26, total versions: 19552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.57 
    Pointer pages: 7, data page slots: 5592 
    Data pages: 4256, average fill: 84% 
    Primary pages: 4254, secondary pages: 2, swept pages: 6 
    Empty pages: 38, full pages: 4199 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 11 
    80 - 99% = 4197 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 146.88, total records: 159542 
    Average version length: 150.70, total versions: 4644, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 4952 
    Data pages: 4008, average fill: 82% 
    Primary pages: 4007, secondary pages: 1, swept pages: 3 
    Empty pages: 80, full pages: 3905 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3907 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.19, total records: 2069210 
    Average version length: 52.96, total versions: 25978, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25816 
    Data pages: 25816, average fill: 69% 
    Primary pages: 25803, secondary pages: 13, swept pages: 13446 
    Empty pages: 169, full pages: 20091 
    Fill distribution: 
     0 - 19% = 373 
    20 - 39% = 435 
    40 - 59% = 1421 
    60 - 79% = 23338 
    80 - 99% = 249 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2556, nodes: 2069210 
    Average node length: 5.45, total dup: 1929222, max dup: 1654 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 180069, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 299 
        40 - 59% = 1672 
        60 - 79% = 285 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2760, nodes: 2069210 
    Average node length: 5.70, total dup: 1856463, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370381, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2502 
        60 - 79% = 231 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2121, nodes: 2069210 
    Average node length: 4.96, total dup: 2069110, max dup: 27375 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178421, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 229 
        40 - 59% = 1084 
        60 - 79% = 398 
        80 - 99% = 407 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 52.71, total records: 109608 
    Average version length: 69.16, total versions: 30065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.39 
    Pointer pages: 3, data page slots: 4216 
    Data pages: 2992, average fill: 44% 
    Primary pages: 2992, secondary pages: 0, swept pages: 712 
    Empty pages: 401, full pages: 343 
    Fill distribution: 
     0 - 19% = 669 
    20 - 39% = 470 
    40 - 59% = 946 
    60 - 79% = 800 
    80 - 99% = 107 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553559, depth: 3, leaf buckets: 224, nodes: 109608 
    Average node length: 6.59, total dup: 95311, max dup: 14 
    Average key length: 4.02, compression ratio: 10.46 
    Average prefix length: 40.11, average data length: 1.89 
    Clustering factor: 19112, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 126 
        40 - 59% = 78 
        60 - 79% = 16 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.29, total records: 7057992 
    Average version length: 68.77, total versions: 196480, 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: 67, data page slots: 108992 
    Data pages: 108992, average fill: 69% 
    Primary pages: 108992, secondary pages: 0, swept pages: 58934 
    Empty pages: 13, full pages: 48818 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 759 
    40 - 59% = 11325 
    60 - 79% = 96075 
    80 - 99% = 728 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10694, nodes: 7057992 
    Average node length: 6.51, total dup: 6104872, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1651979, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1673 
        40 - 59% = 5776 
        60 - 79% = 2766 
        80 - 99% = 470 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8527, nodes: 7057992 
    Average node length: 5.39, total dup: 6779349, max dup: 153 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1458351, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 952 
        40 - 59% = 5072 
        60 - 79% = 1605 
        80 - 99% = 889 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8554, nodes: 7057992 
    Average node length: 5.39, total dup: 6779349, max dup: 153 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1460506, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1027 
        40 - 59% = 4986 
        60 - 79% = 1615 
        80 - 99% = 921 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.14, total records: 12059528 
    Average version length: 68.73, total versions: 159812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 109, data page slots: 177208 
    Data pages: 177208, average fill: 72% 
    Primary pages: 177208, secondary pages: 0, swept pages: 104215 
    Empty pages: 3, full pages: 128076 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 663 
    40 - 59% = 7152 
    60 - 79% = 168477 
    80 - 99% = 869 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18441, nodes: 12057682 
    Average node length: 6.62, total dup: 10512007, max dup: 73 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2462341, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2212 
        40 - 59% = 10790 
        60 - 79% = 4681 
        80 - 99% = 734 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 52.17, total records: 1298222 
    Average version length: 69.07, total versions: 186969, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.41 
    Pointer pages: 26, data page slots: 41408 
    Data pages: 28768, average fill: 46% 
    Primary pages: 28701, secondary pages: 67, swept pages: 14118 
    Empty pages: 4891, full pages: 13586 
    Fill distribution: 
     0 - 19% = 7602 
    20 - 39% = 4907 
    40 - 59% = 3162 
    60 - 79% = 10562 
    80 - 99% = 2535 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1790, nodes: 1118825 
    Average node length: 5.55, total dup: 1072984, max dup: 49 
    Average key length: 2.59, compression ratio: 16.23 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 76812, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 760 
        40 - 59% = 829 
        60 - 79% = 185 
        80 - 99% = 6 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 49.89, total records: 1060136 
    Average version length: 69.01, total versions: 87651, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 21, data page slots: 33136 
    Data pages: 28816, average fill: 36% 
    Primary pages: 28816, secondary pages: 0, swept pages: 11395 
    Empty pages: 4116, full pages: 1328 
    Fill distribution: 
     0 - 19% = 7626 
    20 - 39% = 7143 
    40 - 59% = 10155 
    60 - 79% = 3865 
    80 - 99% = 27 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1310, nodes: 809924 
    Average node length: 5.94, total dup: 747067, max dup: 56 
    Average key length: 3.00, compression ratio: 14.01 
    Average prefix length: 41.08, average data length: 0.92 
    Clustering factor: 117345, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 501 
        40 - 59% = 607 
        60 - 79% = 185 
        80 - 99% = 15 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.81, total records: 8904245 
    Average version length: 68.95, total versions: 306047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 91, data page slots: 146944 
    Data pages: 146912, average fill: 65% 
    Primary pages: 146896, secondary pages: 16, swept pages: 79490 
    Empty pages: 361, full pages: 54312 
    Fill distribution: 
     0 - 19% = 1511 
    20 - 39% = 7994 
    40 - 59% = 27425 
    60 - 79% = 108460 
    80 - 99% = 1522 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13472, nodes: 8901010 
    Average node length: 6.70, total dup: 7382548, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2008827, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1587 
        40 - 59% = 7207 
        60 - 79% = 4130 
        80 - 99% = 543 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21144565 
    Average version length: 82.94, total versions: 7270, 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: 319824 
    Data pages: 319824, average fill: 81% 
    Primary pages: 319819, secondary pages: 5, swept pages: 14035 
    Empty pages: 41, full pages: 318738 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 64 
    40 - 59% = 161 
    60 - 79% = 49509 
    80 - 99% = 270026 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19350, nodes: 21144565 
    Average node length: 5.72, total dup: 20663707, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280879, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 2 
        40 - 59% = 8068 
        60 - 79% = 534 
        80 - 99% = 10735 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17193, nodes: 21144565 
    Average node length: 6.31, total dup: 18580578, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917113, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 7 
        40 - 59% = 821 
        60 - 79% = 262 
        80 - 99% = 16099 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21156, nodes: 21144565 
    Average node length: 6.35, total dup: 18500820, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575955, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8360 
        60 - 79% = 653 
        80 - 99% = 12134 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16129, nodes: 21144565 
    Average node length: 5.56, total dup: 21144465, max dup: 229293 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945974, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 14 
        40 - 59% = 2973 
        60 - 79% = 341 
        80 - 99% = 12801 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 75.14, total records: 10043340 
    Average version length: 82.64, total versions: 993993, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 107, data page slots: 173656 
    Data pages: 173616, average fill: 73% 
    Primary pages: 173587, secondary pages: 29, swept pages: 34813 
    Empty pages: 472, full pages: 128446 
    Fill distribution: 
     0 - 19% = 1445 
    20 - 39% = 6076 
    40 - 59% = 20561 
    60 - 79% = 103107 
    80 - 99% = 42427 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11393, nodes: 10043340 
    Average node length: 5.36, total dup: 9732766, max dup: 216 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2278990, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 52 
        40 - 59% = 7160 
        60 - 79% = 4039 
        80 - 99% = 140 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13696, nodes: 10043340 
    Average node length: 6.24, total dup: 8330485, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1607054, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 153 
        20 - 39% = 3756 
        40 - 59% = 4417 
        60 - 79% = 2574 
        80 - 99% = 2796 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12720, nodes: 10043340 
    Average node length: 5.97, total dup: 8735076, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2478427, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 55 
        40 - 59% = 8163 
        60 - 79% = 4335 
        80 - 99% = 165 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10309, nodes: 10043340 
    Average node length: 5.14, total dup: 10043240, max dup: 158936 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1638587, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1065 
        40 - 59% = 5222 
        60 - 79% = 1729 
        80 - 99% = 2257 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.54, total records: 11404283 
    Average version length: 82.48, total versions: 585381, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 120, data page slots: 194344 
    Data pages: 193072, average fill: 73% 
    Primary pages: 192920, secondary pages: 152, swept pages: 60443 
    Empty pages: 2479, full pages: 149146 
    Fill distribution: 
     0 - 19% = 4216 
    20 - 39% = 6435 
    40 - 59% = 16672 
    60 - 79% = 93005 
    80 - 99% = 72744 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13142, nodes: 11404283 
    Average node length: 5.31, total dup: 11294615, max dup: 655 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2381911, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 9044 
        60 - 79% = 3829 
        80 - 99% = 184 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10420, nodes: 11404283 
    Average node length: 5.51, total dup: 10905895, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 724377, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 791 
        40 - 59% = 2482 
        60 - 79% = 1812 
        80 - 99% = 5193 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15037, nodes: 11404283 
    Average node length: 6.03, total dup: 9957351, max dup: 80 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2398263, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 105 
        40 - 59% = 10567 
        60 - 79% = 4134 
        80 - 99% = 228 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10872, nodes: 11404283 
    Average node length: 5.23, total dup: 11404183, max dup: 205132 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 712841, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 821 
        40 - 59% = 4910 
        60 - 79% = 1459 
        80 - 99% = 3599 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 75.58, total records: 10149079 
    Average version length: 82.93, total versions: 984306, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 109, data page slots: 176840 
    Data pages: 176824, average fill: 72% 
    Primary pages: 176794, secondary pages: 30, swept pages: 38331 
    Empty pages: 434, full pages: 125318 
    Fill distribution: 
     0 - 19% = 1437 
    20 - 39% = 6184 
    40 - 59% = 21912 
    60 - 79% = 105682 
    80 - 99% = 41609 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12079, nodes: 10149079 
    Average node length: 5.18, total dup: 10119663, max dup: 2080 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2092600, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1350 
        40 - 59% = 8020 
        60 - 79% = 2014 
        80 - 99% = 666 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13829, nodes: 10149079 
    Average node length: 6.25, total dup: 8417593, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1568303, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 200 
        20 - 39% = 3719 
        40 - 59% = 4394 
        60 - 79% = 2632 
        80 - 99% = 2884 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12715, nodes: 10149079 
    Average node length: 5.43, total dup: 9701268, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2228757, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1269 
        40 - 59% = 9012 
        60 - 79% = 1812 
        80 - 99% = 600 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10501, nodes: 10149079 
    Average node length: 5.15, total dup: 10148979, max dup: 162320 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1657003, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1147 
        40 - 59% = 5337 
        60 - 79% = 1703 
        80 - 99% = 2275 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.76, total records: 583703 
    Average version length: 68.84, total versions: 13893, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8080 
    Data pages: 8080, average fill: 76% 
    Primary pages: 8080, secondary pages: 0, swept pages: 2180 
    Empty pages: 6, full pages: 7903 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 2 
    40 - 59% = 31 
    60 - 79% = 7782 
    80 - 99% = 257 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 36411, depth: 3, leaf buckets: 741, nodes: 583703 
    Average node length: 5.95, total dup: 497086, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102762, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 514 
        60 - 79% = 104 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28643, depth: 3, leaf buckets: 755, nodes: 583703 
    Average node length: 6.15, total dup: 478915, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102816, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 508 
        60 - 79% = 110 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 561, nodes: 583703 
    Average node length: 4.86, total dup: 583603, max dup: 9709 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 91375, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 319 
        60 - 79% = 76 
        80 - 99% = 142 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Feb 29 10:10:41 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7696491 59096 1 0.0000 0.0000
DOC_LIST 2217399 31369 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1825 6 400.0000 0.0000
INVNT_TURNOVER_LOG 111567 89577 1 0.0000 0.0000
MONEY_SALDO 49 68 2 100.0000 0.0000
MONEY_TURNOVER_LOG 1817 1570 1 0.0000 0.0000
PDISTR 814006 15882 3 0.0000 0.0000
PERF_SPLIT_0 173762 31333 1 0.0000 0.0000
PERF_SPLIT_1 146300 10059 1 0.0000 0.0000
PERF_SPLIT_2 168029 7917 1 0.0000 0.0000
PERF_SPLIT_3 160604 6157 1 0.0000 0.0000
PERF_SPLIT_4 179526 43828 1 0.0000 0.0000
PERF_SPLIT_5 186035 15783 1 0.0000 0.0000
PERF_SPLIT_6 164898 5036 1 0.0000 0.0000
PERF_SPLIT_7 227709 66748 1 0.0000 0.0000
PERF_SPLIT_8 171149 19552 1 0.0000 0.0000
PERF_SPLIT_9 159542 4644 1 0.0000 0.0000
PSTORNED 2069210 25978 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 109608 30065 1 0.0000 0.0000
XQD_1000_3300 7057992 196480 1 0.0000 0.0000
XQD_1200_2000 12059528 159812 1 0.0000 0.0000
XQD_2000_3300 1298222 186969 1 0.0000 0.0000
XQD_2100_3300 1060136 87651 1 0.0000 0.0000
XQD_3300_3400 8904245 306047 1 0.0000 0.0000
XQS_1000_1200 21144565 7270 1 0.0000 0.0000
XQS_1000_3300 10043340 993993 1 0.0000 0.0000
XQS_1200_2000 11404283 585381 1 0.0000 0.0000
XQS_2100_3300 10149079 984306 1 0.0000 0.0000
XQS_3300_3400 583703 13893 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 ---
:1125: 
:1126: mscs-test-161.budzdorov.ru    Thu Feb 29 10:08:29 2024
:1127:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:1128: 
--- end of diff output ---

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

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