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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-03 13:07:49
DTS_END                         2024-03-03 13:07:49.9060
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/59440
TRN_ID                          170961
ATT_ID                          536
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: 9350.61 19101 935061
customer order: creation 173.73 410 17373
customer order: refuse 15.17 345 1517
order to supplier: creation 46.13 1264 4613
order to supplier: removal 3.53 86947 353
invoice (draft): creation 46.58 2700 4658
invoice (draft): removal 52.40 657 5240
invoice accept: apply 41.52 20645 4152
invoice accept: cancel 47.20 748 4720
customer reserve: creation 3989.84 198 398984
customer reserve: removal 4631.28 53 463128
realization accept: apply 84.90 192 8490
realization accept: cancel 88.81 120 8881
payment from customer: creation 59.70 121 5970
payment from customer: removal 5.79 71 579
payment to supplier: creation 50.09 133 5009
payment to supplier: removal 3.11 57 311
service: total inventory turnovers 3.85 3303 385
service: total monetary turnovers 6.13 535 613
service: aggregate perf. data 0.81 14623 81
service: refresh index statistics 0.04 248892 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-03-2024 13:09:08 to 03-03-2024 13:09:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3573
TEST_TIME 2 3741
TEST_TIME 3 3253
TEST_TIME 4 3581
TEST_TIME 5 3784
TEST_TIME 6 4214
TEST_TIME 7 4123
TEST_TIME 8 4642
TEST_TIME 9 4782
TEST_TIME 10 5059
TEST_TIME 11 5341
TEST_TIME 12 5677
TEST_TIME 13 6039
TEST_TIME 14 6064
TEST_TIME 15 6674
TEST_TIME 16 6925
TEST_TIME 17 7521
TEST_TIME 18 8169
TEST_TIME 19 8093
TEST_TIME 20 8297
TEST_TIME 21 8394
TEST_TIME 22 8427
TEST_TIME 23 8823
TEST_TIME 24 9034
TEST_TIME 25 8964
TEST_TIME 26 9510
TEST_TIME 27 9581
TEST_TIME 28 9450
TEST_TIME 29 9325
TEST_TIME 30 9236
TEST_TIME 31 9151
TEST_TIME 32 9099
TEST_TIME 33 8895
TEST_TIME 34 8936
TEST_TIME 35 8851
TEST_TIME 36 9289
TEST_TIME 37 9283
TEST_TIME 38 9169
TEST_TIME 39 9211
TEST_TIME 40 9291
TEST_TIME 41 9323
TEST_TIME 42 9449
TEST_TIME 43 9358
TEST_TIME 44 9412
TEST_TIME 45 9422
TEST_TIME 46 9612
TEST_TIME 47 9617
TEST_TIME 48 9663
TEST_TIME 49 9620
TEST_TIME 50 9700
TEST_TIME 51 9762
TEST_TIME 52 9639
TEST_TIME 53 9555
TEST_TIME 54 9506
TEST_TIME 55 9460
TEST_TIME 56 9420
TEST_TIME 57 9359
TEST_TIME 58 9418
TEST_TIME 59 9405
TEST_TIME 60 9336
TEST_TIME 61 9290
TEST_TIME 62 9368
TEST_TIME 63 9325
TEST_TIME 64 9350
TEST_TIME 65 9402
TEST_TIME 66 9454
TEST_TIME 67 9475
TEST_TIME 68 9632
TEST_TIME 69 9589
TEST_TIME 70 9624
TEST_TIME 71 9756
TEST_TIME 72 9739
TEST_TIME 73 9675
TEST_TIME 74 9559
TEST_TIME 75 9498
TEST_TIME 76 9532
TEST_TIME 77 9455
TEST_TIME 78 9392
TEST_TIME 79 9386
TEST_TIME 80 9437
TEST_TIME 81 9432
TEST_TIME 82 9398
TEST_TIME 83 9457
TEST_TIME 84 9461
TEST_TIME 85 9464
TEST_TIME 86 9497
TEST_TIME 87 9493
TEST_TIME 88 9580
TEST_TIME 89 9592
TEST_TIME 90 9586
TEST_TIME 91 9580
TEST_TIME 92 9590
TEST_TIME 93 9530
TEST_TIME 94 9488
TEST_TIME 95 9445
TEST_TIME 96 9386
TEST_TIME 97 9335
TEST_TIME 98 9361
TEST_TIME 99 9401
TEST_TIME 100 9356

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-03-2024 13:09:12 to 03-03-2024 13:09:15.

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 1301654 1301654 0 0.00 0 20709 7 0 0
doc_list_biud 1301653 1301653 0 0.00 0 35381 24 0 0
sp_add_invoice_to_stock 4247 4152 95 2.23 33 192626 20646 0 95
sp_cancel_adding_invoice 4720 4720 0 0.00 4 76196 748 0 0
sp_cancel_client_order 1517 1517 0 0.00 4 11330 346 0 0
sp_cancel_customer_reserve 463128 463128 0 0.00 0 35383 54 0 0
sp_cancel_pay_from_customer 579 579 0 0.00 2 1806 71 0 0
sp_cancel_pay_to_supplier 311 311 0 0.00 3 2336 57 0 0
sp_cancel_supplier_invoice 5249 5240 9 0.17 1 21950 657 0 9
sp_cancel_supplier_order 353 353 0 0.00 6 794319 86948 0 0
sp_cancel_write_off 8881 8881 0 0.00 1 17681 121 0 0
sp_client_order 17373 17373 0 0.00 3 42197 411 0 0
sp_customer_reserve 398984 398984 0 0.00 0 43762 199 0 0
sp_fill_shopping_cart 26638 26638 0 0.00 0 12764 34 0 0
sp_fill_shopping_cart_clo_res 398982 398982 0 0.00 0 17681 20 0 0
sp_get_clo_for_invoice 4145 4145 0 0.00 0 47597 344 0 0
sp_kill_cost_storno 14491 14491 0 0.00 0 10663 60 0 0
sp_kill_qstorno_ret_qs2qd 940730 940730 0 0.00 0 35378 29 0 0
sp_kill_qty_storno 496472 496472 0 0.00 0 35381 62 0 0
sp_lock_selected_doc 17437 17437 0 0.00 0 8089 7 0 0
sp_make_cost_storno 23612 23612 0 0.00 0 13503 58 0 0
sp_multiply_rows_for_pdistr 23612 23612 0 0.00 0 6378 33 0 0
sp_multiply_rows_for_qdistr 17373 17373 0 0.00 0 36501 217 0 0
sp_pay_from_customer 5970 5970 0 0.00 4 13946 121 0 0
sp_pay_to_supplier 5009 5009 0 0.00 4 11800 134 0 0
sp_payment_common 10979 10979 0 0.00 1 8684 18 0 0
sp_qd_handle_on_cancel_clo 1517 1517 0 0.00 0 7918 307 0 0
sp_qd_handle_on_invoice_upd_sts 8863 8863 0 0.00 0 27546 250 0 0
sp_qd_handle_on_reserve_upd_sts 8490 8490 0 0.00 0 16502 54 0 0
sp_reserve_write_off 8490 8490 0 0.00 6 17244 193 0 0
sp_supplier_invoice 4658 4658 0 0.00 6 75236 2700 0 0
sp_supplier_order 4613 4613 0 0.00 4 42000 1264 0 0
srv_aggregate_perf_data 81 81 0 0.00 1678 106191 14624 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1044 104150 45046 0 0
srv_find_qd_qs_mism 893130 893130 0 0.00 0 20708 6 0 0
srv_make_invnt_saldo 385 385 0 0.00 48 139235 3304 0 0
srv_make_money_saldo 613 613 0 0.00 1 10850 536 0 0
srv_recalc_idx_stat 4 4 0 0.00 186643 387431 248893 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 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 4153 4153 0 0.00 0 20074 174 0 0
t$perf-norm:sp_cancel_adding_invoice 345 345 0 0.00 0 18392 221 0 0
t$perf-norm:sp_cancel_client_order 1517 1517 0 0.00 0 5324 17 0 0
t$perf-norm:sp_cancel_customer_reserve 540 540 0 0.00 0 327 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 579 579 0 0.00 0 191 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 311 311 0 0.00 0 6934 23 0 0
t$perf-norm:sp_cancel_supplier_invoice 324 324 0 0.00 0 1261 10 0 0
t$perf-norm:sp_cancel_supplier_order 353 353 0 0.00 0 18134 1453 0 0
t$perf-norm:sp_cancel_write_off 835 835 0 0.00 0 1691 7 0 0
t$perf-norm:sp_client_order 17373 17373 0 0.00 0 20321 17 0 0
t$perf-norm:sp_customer_reserve 878 878 0 0.00 0 4366 12 0 0
t$perf-norm:sp_pay_from_customer 5970 5970 0 0.00 0 16020 13 0 0
t$perf-norm:sp_pay_to_supplier 5009 5009 0 0.00 0 4907 10 0 0
t$perf-norm:sp_reserve_write_off 8490 8490 0 0.00 0 17485 13 0 0
t$perf-norm:sp_supplier_invoice 4658 4658 0 0.00 0 7116 17 0 0
t$perf-norm:sp_supplier_order 4613 4613 0 0.00 0 3640 15 0 0
t$perf-norm:srv_aggregate_perf_data 81 81 0 0.00 0 579 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 316 7 0 0
t$perf-norm:srv_make_invnt_saldo 385 385 0 0.00 0 2288 14 0 0
t$perf-norm:srv_make_money_saldo 613 613 0 0.00 0 418 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 20 11 0 0
v_add_invoice_to_stock 8476 8286 190 2.24 0 9418 18 0 190
v_all_customers 31876 31876 0 0.00 0 23 1 0 0
v_all_suppliers 26664 26664 0 0.00 0 22 1 0 0
v_all_wares 34742 34742 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 690 690 0 0.00 0 2769 12 0 0
v_cancel_client_order 3034 3034 0 0.00 0 3517 6 0 0
v_cancel_customer_prepayment 1158 1158 0 0.00 0 1776 10 0 0
v_cancel_customer_reserve 1080 1080 0 0.00 0 5745 11 0 0
v_cancel_payment_to_supplier 622 622 0 0.00 0 2258 8 0 0
v_cancel_supplier_invoice 666 648 18 2.70 0 2185 21 0 18
v_cancel_supplier_order 706 706 0 0.00 0 2553 11 0 0
v_cancel_write_off 1670 1670 0 0.00 0 3103 16 0 0
v_max_id_clo_ord 4610 4610 0 0.00 0 683 1 0 0
v_max_id_clo_res 878 878 0 0.00 0 4694 18 0 0
v_max_id_ord_sup 4657 4657 0 0.00 0 3458 4 0 0
v_max_non_paid_invoice 944 944 0 0.00 0 1840 5 0 0
v_max_non_paid_realizn 2974 2974 0 0.00 0 4261 4 0 0
v_min_id_clo_ord 4610 4610 0 0.00 0 3427 7 0 0
v_min_id_clo_res 878 878 0 0.00 0 6648 10 0 0
v_min_id_ord_sup 4657 4657 0 0.00 0 3902 6 0 0
v_min_non_paid_invoice 5009 5009 0 0.00 0 8427 9 0 0
v_min_non_paid_realizn 5970 5970 0 0.00 0 4168 15 0 0
v_our_firm 8858 8858 0 0.00 0 19 1 0 0
v_reserve_write_off 16980 16980 0 0.00 0 5694 9 0 0
x_lock_depdocs_on_canc_invoice 9636 9636 0 0.00 0 13851 101 0 0
x_lock_depdocs_on_canc_sup_ord 353 353 0 0.00 0 11350 365 0 0
x_make_qstorno_1000_1200 4613 4613 0 0.00 1 41992 1192 0 0
x_make_qstorno_1200_2000 4658 4658 0 0.00 3 75221 2581 0 0
x_make_qstorno_2100_3300 398984 398984 0 0.00 0 40180 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-03-2024 13:09:16 to 03-03-2024 13:09:20.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
11:07:53 1188 8192000000 8949591056 9010155520 10811552 0.131 3 2 4 0 11224912 102000 311360
11:08:56 31665 8192000000 9703299248 9994219520 773512448 8.627 100 91 182 0 803773264 7618848 22641968
11:10:32 14961 8192000000 9737065120 10038599680 813062880 9.028 100 91 182 0 846607296 11327968 22216448
11:11:54 20359 8192000000 9780449216 10093834240 849503408 9.395 100 88 176 0 886341776 15868544 20969824
11:13:18 14136 8192000000 9837868304 10167492608 894144688 9.840 100 69 138 0 939345504 30091616 15109200
11:14:41 11373 8192000000 9889472368 10230087680 943163440 10.324 100 82 164 0 1000903136 39984992 17754704
11:15:54 5187 8192000000 9952901920 10301992960 975301120 10.638 100 89 178 1 1070018880 76005728 18712032
11:17:02 2188 8192000000 9975102992 10335432704 1007690416 10.953 100 83 165 0 1085798800 61298544 16809840
11:18:07 1717 8192000000 10009250736 10377277440 1033311680 11.200 100 79 155 0 1126309504 77584768 15413056
11:19:09 1335 8192000000 10028447040 10397265920 1056981728 11.428 100 89 178 1 1138135952 63088880 18065344
11:20:11 789 8192000000 10074901264 10449911808 1066185136 11.516 100 95 185 2 1185175456 100155936 18834384
11:21:13 11227 8192000000 9998368352 10386718720 1075211040 11.602 100 51 104 1 1110936448 24348128 11377280
11:22:26 5324 8192000000 9994757088 10398584832 1079761552 11.645 100 22 44 1 1108877232 24643088 4472592
11:23:32 8389 8192000000 10004888720 10417000448 1087995648 11.724 100 38 73 0 1109037712 13228896 7813168
11:24:41 59854 8192000000 10016310512 10414149632 1094945040 11.790 100 48 95 0 1116527056 11549168 10032848
11:26:42 4150 8192000000 10012512224 10417557504 1097758720 11.816 100 41 80 0 1128858032 21840864 9258448
11:27:46 11399 8192000000 10012897680 10417541120 1098369920 11.822 100 29 57 0 1121686928 17120960 6196048
11:29:04 9057 8192000000 10043060336 10442362880 1101909584 11.856 100 56 112 0 1152966752 39378176 11678992
11:30:23 76969 8192000000 10077724304 10492248064 1102853744 11.865 99 40 79 1 1193097360 81965952 8277664
11:32:42 35581 8192000000 10080838304 10500034560 1106351296 11.898 99 35 69 0 1182788256 69335680 7101280
11:34:39 58742 8192000000 10167200256 10596147200 1127385760 12.097 100 49 98 0 1274505584 136190992 10928832
11:36:45 14608 8192000000 10206105632 10612715520 1130735872 12.128 99 52 103 0 1303065104 160984016 11345216
11:38:20 30011 8192000000 10189387968 10610421760 1090524000 11.748 96 44 86 1 1249756512 149625488 9607024
11:39:57 6466 8192000000 10174535200 10587475968 1108038880 11.914 99 45 89 0 1282903360 165049664 9814816
11:41:11 5547 8192000000 10185804240 10588782592 1098116112 11.820 99 55 109 0 1282846144 172662720 12067312
11:42:22 1042 8192000000 10192569296 10599395328 1103037440 11.866 100 92 183 0 1285561776 162455472 20068864
11:43:26 2707 8192000000 10251808944 10649374720 1127054928 12.094 100 81 159 1 1349274944 205336016 16884000
11:44:33 4353 8192000000 10225119392 10628882432 1124412176 12.069 100 78 149 2 1325142064 184509936 16219952
11:45:39 11634 8192000000 10144769760 10575540224 1109681648 11.929 100 36 70 0 1257834016 140276112 7876256
11:46:54 5800 8192000000 10166720224 10570133504 1107452864 11.908 99 51 101 1 1264614752 146022336 11139552
11:48:06 14267 8192000000 10149133920 10559303680 1089998464 11.743 98 30 60 0 1230912240 134380864 6532912
11:49:40 22448 8192000000 10162404352 10604707840 1111512960 11.947 100 12 24 0 1273337488 158911120 2913408
11:51:04 42487 8192000000 10136613552 10586845184 1105241888 11.887 99 10 17 0 1232916784 125679888 1995008
11:52:51 32598 8192000000 10118686144 10586689536 1114128432 11.971 100 19 38 0 1251538944 133261712 4148800
11:54:33 54433 8192000000 10054766768 10494517248 1120606576 12.033 100 16 31 0 1172306384 48371040 3328768
11:56:34 72335 8192000000 10065764304 10504937472 1111171280 11.944 99 43 86 0 1159164976 38506400 9487296
11:58:59 31736 8192000000 10121361984 10555875328 1133854944 12.158 100 60 118 1 1202191040 55414896 12921200
12:00:42 9242 8192000000 10158318352 10582122496 1139018448 12.206 99 55 108 0 1242737776 92212112 11507216
12:01:55 31337 8192000000 10233551328 10666356736 1159628288 12.400 100 49 97 1 1328688896 157109456 11951152
12:03:31 40290 8192000000 10160642400 10654724096 1149935120 12.309 100 20 40 0 1318276768 163198912 5142736
12:05:17 58089 8192000000 10173166768 10622504960 1152807536 12.336 100 14 28 0 1266710016 110808704 3093776
12:07:16 52952 8192000000 10120480816 10621464576 1150078320 12.310 100 8 16 0 1238140832 85970480 2092032
12:09:09 56549 8192000000 10079686208 10545016832 1149621888 12.306 100 20 38 0 1191634816 37969904 4043024
12:11:22 65589 8192000000 10124836896 10602332160 1145214352 12.265 99 13 26 0 1221731616 73707760 2809504
12:13:28 44627 8192000000 10060250016 10488061952 1088489184 11.728 94 24 45 0 1112775296 20124608 4161504
12:15:18 73163 8192000000 10074331376 10528096256 1045494432 11.317 92 15 30 1 1080111136 31970896 2645808
12:17:38 86580 8192000000 10043298080 10471526400 1058304368 11.440 94 10 18 0 1092670720 32477728 1888624
12:20:09 104150 8192000000 10059277056 10489421824 1094883376 11.789 98 35 67 0 1158237792 56591040 6763376
12:22:56 6527 8192000000 10042626064 10494590976 1098937952 11.828 99 21 42 1 1146225536 42876624 4410960
12:24:41 56485 8192000000 10079312832 10553597952 1069453616 11.547 97 19 38 1 1167443872 93739264 4250992
12:27:26 46648 8192000000 10054201808 10516619264 1101106688 11.848 100 14 28 1 1149491008 45549216 2835104
12:29:30 59274 8192000000 10052515344 10486722560 1061253408 11.468 96 12 25 0 1101751808 37470016 3028384
12:32:02 54251 8192000000 10065306384 10516611072 1076534800 11.614 97 15 28 0 1140010048 60661072 2814176
12:34:08 61406 8192000000 10144403824 10627416064 1120444144 12.031 100 27 52 1 1234970464 108700976 5825344
12:36:15 44809 8192000000 10078199936 10502197248 1095898864 11.799 98 27 54 0 1149229408 47720848 5609696
12:38:06 83611 8192000000 10067200240 10519379968 1090768624 11.750 98 25 50 0 1159494624 64098560 4627440
12:40:31 78516 8192000000 10085245664 10512838656 1108277360 11.916 99 50 100 0 1151792848 33291040 10224448
12:42:54 43880 8192000000 10039995120 10513022976 1113458672 11.965 100 23 46 2 1201741632 83726560 4556400
12:44:40 46165 8192000000 10054654224 10504441856 1123437856 12.059 100 10 20 0 1158682704 33641568 1603280
12:46:31 57146 8192000000 10095807296 10545270784 1122497792 12.051 99 18 35 1 1194989200 68625008 3866400
12:48:29 77302 8192000000 10111095872 10564317184 1141656016 12.231 100 22 44 0 1194149936 48093280 4400640
12:50:51 63731 8192000000 10092305568 10526429184 1137073392 12.188 99 25 49 0 1164043712 22353504 4616816
12:52:57 49449 8192000000 10094290960 10540167168 1155717008 12.363 100 23 46 0 1239072976 77859616 5496352
12:54:54 102545 8192000000 10121962816 10585944064 1119854496 12.026 97 18 36 0 1164334032 41260208 3219328
12:58:04 74527 8192000000 10119412656 10560811008 1086294864 11.707 94 15 30 1 1156116288 66742256 3079168
13:00:23 49850 8192000000 10096414896 10590162944 1133960512 12.159 100 32 64 0 1205407216 65083312 6363392
13:02:13 63564 8192000000 10099294128 10560364544 1135831472 12.176 99 26 50 1 1196456896 55313920 5311504
13:04:17 87242 8192000000 10086167664 10593669120 1111550752 11.947 97 12 24 0 1190499472 75880448 3068272
13:07:43 13664 8192000000 8973730864 9180729344 140428800 1.685 13 3 6 0 162105376 21170288 506288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 95 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 03-03-2024 13:09:37 to 03-03-2024 13:09:39.

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          171305
MON$OLDEST_ACTIVE               171306
MON$OLDEST_SNAPSHOT             171306
MON$NEXT_TRANSACTION            171306
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                       1917792
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             688
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sun Mar  3 13:09:40 2024 
 
Database header page information: 
    Flags            0 
    Generation        89356 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171305 
    Oldest active        171306 
    Oldest snapshot        171306 
    Next transaction    171307 
    Sequence number        0 
    Next attachment ID    688 
    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.53, total records: 7677090 
    Average version length: 48.16, total versions: 70491, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88368 
    Data pages: 88368, average fill: 69% 
    Primary pages: 88367, secondary pages: 1, swept pages: 38567 
    Empty pages: 5, full pages: 69654 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 47 
    40 - 59% = 2032 
    60 - 79% = 86237 
    80 - 99% = 33 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23081, nodes: 7677090 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1660689, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 328 
        20 - 39% = 1922 
        40 - 59% = 3868 
        60 - 79% = 2640 
        80 - 99% = 14323 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13428, nodes: 7677090 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1484603, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1649 
        40 - 59% = 1922 
        60 - 79% = 1210 
        80 - 99% = 8647 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8259, nodes: 7677090 
    Average node length: 6.59, total dup: 5771665, max dup: 49 
    Average key length: 3.61, compression ratio: 2.50 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1477858, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 1030 
        40 - 59% = 1246 
        60 - 79% = 1043 
        80 - 99% = 4818 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.64, total records: 2195387 
    Average version length: 58.91, total versions: 35010, 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: 28592 
    Data pages: 28592, average fill: 71% 
    Primary pages: 28590, secondary pages: 2, swept pages: 11670 
    Empty pages: 5, full pages: 16794 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 112 
    40 - 59% = 1529 
    60 - 79% = 26865 
    80 - 99% = 69 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4486, nodes: 2195387 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 670207, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 900 
        40 - 59% = 827 
        60 - 79% = 802 
        80 - 99% = 1957 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2407, nodes: 2196374 
    Average node length: 4.97, total dup: 2195476, max dup: 17579 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1242307, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 230 
        40 - 59% = 1394 
        60 - 79% = 556 
        80 - 99% = 224 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1778, nodes: 2195387 
    Average node length: 4.97, total dup: 2195337, max dup: 130202 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1052262, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 54 
        40 - 59% = 593 
        60 - 79% = 48 
        80 - 99% = 1083 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4268, nodes: 2195387 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 670207, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 609 
        40 - 59% = 569 
        60 - 79% = 919 
        80 - 99% = 2090 
 
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.31, total records: 400 
    Average version length: 32.03, total versions: 1631, max versions: 5 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 47% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 8, full pages: 14 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 14 
 
    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: 11.99, total records: 92911 
    Average version length: 68.30, total versions: 88216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.34 
    Pointer pages: 6, data page slots: 2864 
    Data pages: 2024, average fill: 63% 
    Primary pages: 2023, secondary pages: 1, swept pages: 0 
    Empty pages: 278, full pages: 1055 
    Fill distribution: 
     0 - 19% = 404 
    20 - 39% = 174 
    40 - 59% = 247 
    60 - 79% = 216 
    80 - 99% = 983 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704694, depth: 3, leaf buckets: 352, nodes: 92911 
    Average node length: 13.24, total dup: 6926, max dup: 1 
    Average key length: 10.66, compression ratio: 2.53 
    Average prefix length: 19.27, average data length: 7.73 
    Clustering factor: 67509, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 165 
        40 - 59% = 149 
        60 - 79% = 37 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 156, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 69% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 9.67, total records: 1666 
    Average version length: 43.85, total versions: 1633, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.00 
    Pointer pages: 1, data page slots: 48 
    Data pages: 32, average fill: 56% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 6, full pages: 13 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91256, depth: 2, leaf buckets: 2, nodes: 1666 
    Average node length: 4.32, total dup: 1570, max dup: 180 
    Average key length: 2.62, compression ratio: 7.25 
    Average prefix length: 18.44, average data length: 0.56 
    Clustering factor: 870, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.48, total records: 69 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 48% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 69 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.70, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.66, total records: 850355 
    Average version length: 37.95, total versions: 25003, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8928 
    Data pages: 8928, average fill: 65% 
    Primary pages: 8927, secondary pages: 1, swept pages: 2141 
    Empty pages: 22, full pages: 7163 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 49 
    40 - 59% = 502 
    60 - 79% = 8277 
    80 - 99% = 51 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 905, nodes: 839617 
    Average node length: 4.89, total dup: 839568, max dup: 161783 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92452, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 130 
        40 - 59% = 471 
        60 - 79% = 205 
        80 - 99% = 97 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1013, nodes: 839617 
    Average node length: 5.89, total dup: 747561, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166200, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 17 
        40 - 59% = 665 
        60 - 79% = 60 
        80 - 99% = 268 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1041, nodes: 839617 
    Average node length: 5.89, total dup: 747561, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 168063, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 64 
        40 - 59% = 665 
        60 - 79% = 56 
        80 - 99% = 255 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1178, nodes: 839617 
    Average node length: 5.97, total dup: 747561, max dup: 44 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 160035, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 208 
        40 - 59% = 664 
        60 - 79% = 215 
        80 - 99% = 86 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.94, total records: 5507 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.56, total fragments: 9, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 62% 
    Primary pages: 77, secondary pages: 10, swept pages: 53 
    Empty pages: 7, full pages: 57 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5507 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.06 
    Average prefix length: 34.58, average data length: 1.55 
    Clustering factor: 5168, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 2 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5507 
    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: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 77599 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 806 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 806 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33473, depth: 2, leaf buckets: 98, nodes: 77599 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2944, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.83, total records: 156533 
    Average version length: 150.83, total versions: 3459, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 5928 
    Data pages: 3864, average fill: 84% 
    Primary pages: 3860, secondary pages: 4, swept pages: 4 
    Empty pages: 16, full pages: 3835 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3835 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.60, total records: 132956 
    Average version length: 149.39, total versions: 2052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 3656 
    Data pages: 3328, average fill: 82% 
    Primary pages: 3326, secondary pages: 2, swept pages: 2 
    Empty pages: 58, full pages: 3249 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3250 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.39, total records: 145857 
    Average version length: 150.51, total versions: 1864, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 4680 
    Data pages: 3616, average fill: 83% 
    Primary pages: 3615, secondary pages: 1, swept pages: 4 
    Empty pages: 25, full pages: 3581 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3581 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 149.99, total records: 156548 
    Average version length: 148.21, total versions: 1193, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 5416 
    Data pages: 3904, average fill: 83% 
    Primary pages: 3903, secondary pages: 1, swept pages: 2 
    Empty pages: 53, full pages: 3838 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3838 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 150.15, total records: 160746 
    Average version length: 146.51, total versions: 1019, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 4440 
    Data pages: 4000, average fill: 83% 
    Primary pages: 3998, secondary pages: 2, swept pages: 3 
    Empty pages: 45, full pages: 3938 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3939 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 148.49, total records: 159751 
    Average version length: 150.91, total versions: 2733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 7, data page slots: 4512 
    Data pages: 3944, average fill: 83% 
    Primary pages: 3942, secondary pages: 2, swept pages: 1 
    Empty pages: 20, full pages: 3914 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3915 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 148.60, total records: 159123 
    Average version length: 152.80, total versions: 2688, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 4416 
    Data pages: 3944, average fill: 83% 
    Primary pages: 3942, secondary pages: 2, swept pages: 4 
    Empty pages: 35, full pages: 3896 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 3895 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.19, total records: 140292 
    Average version length: 145.95, total versions: 611, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 8, data page slots: 3920 
    Data pages: 3464, average fill: 83% 
    Primary pages: 3462, secondary pages: 2, swept pages: 1 
    Empty pages: 21, full pages: 3434 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3434 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 137.01, total records: 175192 
    Average version length: 154.59, total versions: 17564, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.38 
    Pointer pages: 6, data page slots: 5728 
    Data pages: 4368, average fill: 84% 
    Primary pages: 4366, secondary pages: 2, swept pages: 3 
    Empty pages: 47, full pages: 4305 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4305 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 148.11, total records: 164635 
    Average version length: 152.12, total versions: 3836, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 8, data page slots: 5144 
    Data pages: 4136, average fill: 82% 
    Primary pages: 4132, secondary pages: 4, swept pages: 2 
    Empty pages: 72, full pages: 4040 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4041 
 
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.01, total records: 2050463 
    Average version length: 52.91, total versions: 34613, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25576 
    Data pages: 25568, average fill: 69% 
    Primary pages: 25547, secondary pages: 21, swept pages: 11719 
    Empty pages: 293, full pages: 21377 
    Fill distribution: 
     0 - 19% = 511 
    20 - 39% = 383 
    40 - 59% = 1099 
    60 - 79% = 23228 
    80 - 99% = 347 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2540, nodes: 2050463 
    Average node length: 5.45, total dup: 1911906, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179789, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 339 
        40 - 59% = 1601 
        60 - 79% = 300 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2749, nodes: 2050463 
    Average node length: 5.70, total dup: 1839626, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 368569, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2524 
        60 - 79% = 190 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2069, nodes: 2050463 
    Average node length: 4.96, total dup: 2050363, max dup: 27323 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177652, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 216 
        40 - 59% = 1023 
        60 - 79% = 394 
        80 - 99% = 434 
 
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: 44.64, total records: 129014 
    Average version length: 69.18, total versions: 52690, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.82 
    Pointer pages: 3, data page slots: 3624 
    Data pages: 2968, average fill: 53% 
    Primary pages: 2967, secondary pages: 1, swept pages: 320 
    Empty pages: 343, full pages: 1246 
    Fill distribution: 
     0 - 19% = 564 
    20 - 39% = 458 
    40 - 59% = 475 
    60 - 79% = 740 
    80 - 99% = 731 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105751, depth: 3, leaf buckets: 214, nodes: 129014 
    Average node length: 6.40, total dup: 112211, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22544, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 66 
        40 - 59% = 97 
        60 - 79% = 47 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.61, total records: 7205832 
    Average version length: 68.75, total versions: 281595, 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: 67, data page slots: 109168 
    Data pages: 109168, average fill: 71% 
    Primary pages: 109167, secondary pages: 1, swept pages: 30878 
    Empty pages: 9, full pages: 68780 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 847 
    40 - 59% = 9167 
    60 - 79% = 98001 
    80 - 99% = 1048 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10795, nodes: 7205832 
    Average node length: 6.51, total dup: 6232017, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1680378, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1527 
        40 - 59% = 5863 
        60 - 79% = 2943 
        80 - 99% = 462 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8751, nodes: 7205832 
    Average node length: 5.39, total dup: 6921509, max dup: 128 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1489356, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1166 
        40 - 59% = 5118 
        60 - 79% = 1462 
        80 - 99% = 999 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8772, nodes: 7205832 
    Average node length: 5.39, total dup: 6921509, max dup: 128 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1491695, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1205 
        40 - 59% = 5037 
        60 - 79% = 1489 
        80 - 99% = 1034 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.94, total records: 12246986 
    Average version length: 68.68, total versions: 202508, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 110, data page slots: 177936 
    Data pages: 177936, average fill: 73% 
    Primary pages: 177935, secondary pages: 1, swept pages: 78614 
    Empty pages: 2, full pages: 153884 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 714 
    40 - 59% = 5876 
    60 - 79% = 170133 
    80 - 99% = 1148 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18559, nodes: 12244614 
    Average node length: 6.62, total dup: 10672918, max dup: 53 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2491857, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2054 
        40 - 59% = 10737 
        60 - 79% = 5004 
        80 - 99% = 734 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 50.05, total records: 1439061 
    Average version length: 69.10, total versions: 251824, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.52 
    Pointer pages: 27, data page slots: 42744 
    Data pages: 28824, average fill: 51% 
    Primary pages: 28726, secondary pages: 98, swept pages: 10243 
    Empty pages: 3262, full pages: 15360 
    Fill distribution: 
     0 - 19% = 5469 
    20 - 39% = 4820 
    40 - 59% = 3916 
    60 - 79% = 11592 
    80 - 99% = 3027 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1839, nodes: 1233981 
    Average node length: 5.52, total dup: 1184273, max dup: 49 
    Average key length: 2.57, compression ratio: 16.32 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 86411, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 676 
        40 - 59% = 874 
        60 - 79% = 250 
        80 - 99% = 33 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 41.15, total records: 1093675 
    Average version length: 69.04, total versions: 137698, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.06 
    Pointer pages: 20, data page slots: 32560 
    Data pages: 27408, average fill: 35% 
    Primary pages: 27407, secondary pages: 1, swept pages: 7705 
    Empty pages: 5933, full pages: 9902 
    Fill distribution: 
     0 - 19% = 9749 
    20 - 39% = 4445 
    40 - 59% = 6610 
    60 - 79% = 6400 
    80 - 99% = 204 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1122, nodes: 723682 
    Average node length: 5.96, total dup: 665148, max dup: 97 
    Average key length: 3.04, compression ratio: 13.81 
    Average prefix length: 41.04, average data length: 0.96 
    Clustering factor: 103866, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 342 
        40 - 59% = 570 
        60 - 79% = 194 
        80 - 99% = 13 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.24, total records: 8904261 
    Average version length: 69.00, total versions: 388804, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 88, data page slots: 143232 
    Data pages: 143192, average fill: 67% 
    Primary pages: 143177, secondary pages: 15, swept pages: 54829 
    Empty pages: 364, full pages: 66023 
    Fill distribution: 
     0 - 19% = 1417 
    20 - 39% = 7168 
    40 - 59% = 20387 
    60 - 79% = 112116 
    80 - 99% = 2104 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13435, nodes: 8898770 
    Average node length: 6.68, total dup: 7381304, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2005533, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1511 
        40 - 59% = 7335 
        60 - 79% = 4163 
        80 - 99% = 425 
 
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: 21114927 
    Average version length: 82.76, total versions: 7981, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319304 
    Data pages: 319304, average fill: 81% 
    Primary pages: 319299, secondary pages: 5, swept pages: 13244 
    Empty pages: 39, full pages: 318286 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 37 
    40 - 59% = 134 
    60 - 79% = 48783 
    80 - 99% = 270294 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19431, nodes: 21114927 
    Average node length: 5.72, total dup: 20634631, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278265, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8311 
        60 - 79% = 507 
        80 - 99% = 10609 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17122, nodes: 21114927 
    Average node length: 6.31, total dup: 18555466, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915825, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 728 
        60 - 79% = 269 
        80 - 99% = 16116 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21169, nodes: 21114927 
    Average node length: 6.35, total dup: 18474673, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3572013, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 8450 
        60 - 79% = 629 
        80 - 99% = 12081 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16005, nodes: 21114927 
    Average node length: 5.56, total dup: 21114827, max dup: 230600 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944730, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2793 
        60 - 79% = 317 
        80 - 99% = 12886 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.36, total records: 9351517 
    Average version length: 82.61, total versions: 387509, max versions: 1 
    Average fragment length: 73.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 105, data page slots: 171048 
    Data pages: 170992, average fill: 68% 
    Primary pages: 170960, secondary pages: 32, swept pages: 77065 
    Empty pages: 511, full pages: 92593 
    Fill distribution: 
     0 - 19% = 1974 
    20 - 39% = 10423 
    40 - 59% = 28051 
    60 - 79% = 112505 
    80 - 99% = 18039 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11333, nodes: 9351517 
    Average node length: 5.37, total dup: 9047166, max dup: 198 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2091037, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 104 
        40 - 59% = 9118 
        60 - 79% = 2078 
        80 - 99% = 31 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13198, nodes: 9351517 
    Average node length: 6.23, total dup: 7752116, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1459244, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 3729 
        40 - 59% = 4538 
        60 - 79% = 2615 
        80 - 99% = 2170 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12640, nodes: 9351517 
    Average node length: 5.98, total dup: 8106882, max dup: 44 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2280002, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 116 
        40 - 59% = 10186 
        60 - 79% = 2297 
        80 - 99% = 39 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9938, nodes: 9351517 
    Average node length: 5.13, total dup: 9351417, max dup: 158101 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1479350, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1404 
        40 - 59% = 4888 
        60 - 79% = 1694 
        80 - 99% = 1915 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.57, total records: 10898627 
    Average version length: 82.49, total versions: 255765, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 193472 
    Data pages: 191728, average fill: 70% 
    Primary pages: 191560, secondary pages: 168, swept pages: 77965 
    Empty pages: 3824, full pages: 135290 
    Fill distribution: 
     0 - 19% = 6572 
    20 - 39% = 9817 
    40 - 59% = 21379 
    60 - 79% = 95707 
    80 - 99% = 58253 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13106, nodes: 10898627 
    Average node length: 5.30, total dup: 10789561, max dup: 633 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2281666, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 222 
        40 - 59% = 10107 
        60 - 79% = 2718 
        80 - 99% = 58 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10159, nodes: 10898627 
    Average node length: 5.49, total dup: 10421312, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 695663, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 168 
        20 - 39% = 865 
        40 - 59% = 2532 
        60 - 79% = 1825 
        80 - 99% = 4769 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14985, nodes: 10898627 
    Average node length: 6.03, total dup: 9497523, max dup: 57 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2297963, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 245 
        40 - 59% = 11734 
        60 - 79% = 2925 
        80 - 99% = 77 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10426, nodes: 10898627 
    Average node length: 5.22, total dup: 10898527, max dup: 193929 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 685156, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 962 
        40 - 59% = 4449 
        60 - 79% = 1505 
        80 - 99% = 3409 
 
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: 79.76, total records: 9456675 
    Average version length: 82.94, total versions: 381954, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 107, data page slots: 174152 
    Data pages: 174112, average fill: 68% 
    Primary pages: 174077, secondary pages: 35, swept pages: 79136 
    Empty pages: 840, full pages: 96671 
    Fill distribution: 
     0 - 19% = 2595 
    20 - 39% = 11502 
    40 - 59% = 28624 
    60 - 79% = 112943 
    80 - 99% = 18448 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11479, nodes: 9456675 
    Average node length: 5.17, total dup: 9428254, max dup: 2166 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1918924, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1577 
        40 - 59% = 7457 
        60 - 79% = 1844 
        80 - 99% = 567 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13270, nodes: 9456675 
    Average node length: 6.24, total dup: 7838934, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1442524, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 3726 
        40 - 59% = 4433 
        60 - 79% = 2675 
        80 - 99% = 2286 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12108, nodes: 9456675 
    Average node length: 5.43, total dup: 9030560, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2049373, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1565 
        40 - 59% = 8328 
        60 - 79% = 1652 
        80 - 99% = 536 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10144, nodes: 9456675 
    Average node length: 5.14, total dup: 9456575, max dup: 159794 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1507758, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1471 
        40 - 59% = 5046 
        60 - 79% = 1673 
        80 - 99% = 1902 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.46, total records: 571482 
    Average version length: 68.82, total versions: 6727, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8048, average fill: 74% 
    Primary pages: 8048, secondary pages: 0, swept pages: 3483 
    Empty pages: 5, full pages: 6914 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 20 
    40 - 59% = 182 
    60 - 79% = 7742 
    80 - 99% = 96 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40837, depth: 3, leaf buckets: 733, nodes: 571482 
    Average node length: 5.94, total dup: 486874, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100330, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 504 
        60 - 79% = 106 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31774, depth: 3, leaf buckets: 760, nodes: 571482 
    Average node length: 6.14, total dup: 468952, max dup: 21 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100390, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 535 
        60 - 79% = 90 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 571482 
    Average node length: 4.86, total dup: 571382, max dup: 9885 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89167, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 315 
        60 - 79% = 83 
        80 - 99% = 129 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar  3 13:10:03 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7677090 70491 1 0.0000 0.0000
DOC_LIST 2195387 35010 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1631 5 400.0000 0.0000
INVNT_TURNOVER_LOG 92911 88216 1 0.0000 0.0000
MONEY_SALDO 49 156 6 300.0000 0.0000
MONEY_TURNOVER_LOG 1666 1633 1 0.0000 0.0000
PDISTR 850355 25003 2 0.0000 0.0000
PERF_SPLIT_0 156533 3459 1 0.0000 0.0000
PERF_SPLIT_1 132956 2052 1 0.0000 0.0000
PERF_SPLIT_2 145857 1864 1 0.0000 0.0000
PERF_SPLIT_3 156548 1193 1 0.0000 0.0000
PERF_SPLIT_4 160746 1019 1 0.0000 0.0000
PERF_SPLIT_5 159751 2733 1 0.0000 0.0000
PERF_SPLIT_6 159123 2688 1 0.0000 0.0000
PERF_SPLIT_7 140292 611 1 0.0000 0.0000
PERF_SPLIT_8 175192 17564 1 0.0000 0.0000
PERF_SPLIT_9 164635 3836 1 0.0000 0.0000
PSTORNED 2050463 34613 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 129014 52690 1 0.0000 0.0000
XQD_1000_3300 7205832 281595 1 0.0000 0.0000
XQD_1200_2000 12246986 202508 1 0.0000 0.0000
XQD_2000_3300 1439061 251824 1 0.0000 0.0000
XQD_2100_3300 1093675 137698 1 0.0000 0.0000
XQD_3300_3400 8904261 388804 1 0.0000 0.0000
XQS_1000_1200 21114927 7981 1 0.0000 0.0000
XQS_1000_3300 9351517 387509 1 0.0000 0.0000
XQS_1200_2000 10898627 255765 1 0.0000 0.0000
XQS_2100_3300 9456675 381954 1 0.0000 0.0000
XQS_3300_3400 571482 6727 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 ---
:120: 
:121: mscs-test-161.budzdorov.ru    Sun Mar  3 13:07:58 2024
:122:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:123: 
--- end of diff output ---

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

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