Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.04.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 15622696 kB
MemAvailable 30173232 kB
Buffers 0 kB
Cached 16087276 kB
SwapCached 2484 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-01 13:07:51
DTS_END                         2024-04-01 13:07:51.2660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/38140
TRN_ID                          176834
ATT_ID                          531
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: 9411.29 20232 941129
customer order: creation 183.88 388 18388
customer order: refuse 15.31 373 1531
order to supplier: creation 49.13 1196 4913
order to supplier: removal 3.64 80954 364
invoice (draft): creation 48.70 2766 4870
invoice (draft): removal 48.87 676 4887
invoice accept: apply 44.49 21085 4449
invoice accept: cancel 44.30 822 4430
customer reserve: creation 4338.51 200 433851
customer reserve: removal 4327.86 55 432786
realization accept: apply 89.91 185 8991
realization accept: cancel 78.95 138 7895
payment from customer: creation 63.84 119 6384
payment from customer: removal 6.37 70 637
payment to supplier: creation 52.06 144 5206
payment to supplier: removal 3.57 73 357
service: total inventory turnovers 4.54 3269 454
service: total monetary turnovers 6.39 527 639
service: aggregate perf. data 0.94 20972 94
service: refresh index statistics 0.03 270621 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-04-2024 13:08:34 to 01-04-2024 13:08:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4217
TEST_TIME 2 4614
TEST_TIME 3 4310
TEST_TIME 4 4579
TEST_TIME 5 5049
TEST_TIME 6 5747
TEST_TIME 7 6174
TEST_TIME 8 6134
TEST_TIME 9 6004
TEST_TIME 10 6550
TEST_TIME 11 6483
TEST_TIME 12 6579
TEST_TIME 13 6537
TEST_TIME 14 6540
TEST_TIME 15 6615
TEST_TIME 16 6732
TEST_TIME 17 6759
TEST_TIME 18 6976
TEST_TIME 19 7299
TEST_TIME 20 7579
TEST_TIME 21 7704
TEST_TIME 22 8270
TEST_TIME 23 8166
TEST_TIME 24 8013
TEST_TIME 25 8877
TEST_TIME 26 9415
TEST_TIME 27 9410
TEST_TIME 28 9434
TEST_TIME 29 9609
TEST_TIME 30 9442
TEST_TIME 31 9293
TEST_TIME 32 9478
TEST_TIME 33 9333
TEST_TIME 34 9825
TEST_TIME 35 9844
TEST_TIME 36 9610
TEST_TIME 37 9539
TEST_TIME 38 9525
TEST_TIME 39 9354
TEST_TIME 40 9329
TEST_TIME 41 9336
TEST_TIME 42 9365
TEST_TIME 43 9315
TEST_TIME 44 9452
TEST_TIME 45 9382
TEST_TIME 46 9420
TEST_TIME 47 9284
TEST_TIME 48 9237
TEST_TIME 49 9162
TEST_TIME 50 9219
TEST_TIME 51 9194
TEST_TIME 52 9150
TEST_TIME 53 9284
TEST_TIME 54 9276
TEST_TIME 55 9317
TEST_TIME 56 9343
TEST_TIME 57 9324
TEST_TIME 58 9536
TEST_TIME 59 9568
TEST_TIME 60 9524
TEST_TIME 61 9576
TEST_TIME 62 9608
TEST_TIME 63 9727
TEST_TIME 64 9637
TEST_TIME 65 9508
TEST_TIME 66 9471
TEST_TIME 67 9426
TEST_TIME 68 9428
TEST_TIME 69 9376
TEST_TIME 70 9367
TEST_TIME 71 9336
TEST_TIME 72 9276
TEST_TIME 73 9271
TEST_TIME 74 9261
TEST_TIME 75 9223
TEST_TIME 76 9321
TEST_TIME 77 9304
TEST_TIME 78 9316
TEST_TIME 79 9323
TEST_TIME 80 9384
TEST_TIME 81 9442
TEST_TIME 82 9455
TEST_TIME 83 9522
TEST_TIME 84 9503
TEST_TIME 85 9431
TEST_TIME 86 9407
TEST_TIME 87 9372
TEST_TIME 88 9383
TEST_TIME 89 9331
TEST_TIME 90 9331
TEST_TIME 91 9316
TEST_TIME 92 9285
TEST_TIME 93 9317
TEST_TIME 94 9325
TEST_TIME 95 9393
TEST_TIME 96 9390
TEST_TIME 97 9360
TEST_TIME 98 9461
TEST_TIME 99 9445
TEST_TIME 100 9418

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-04-2024 13:08:37 to 01-04-2024 13:08:41.

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 1336063 1336063 0 0.00 0 15741 8 0 0
doc_list_biud 1336063 1336063 0 0.00 0 42398 23 0 0
sp_add_invoice_to_stock 4639 4449 190 4.09 26 212592 21086 0 190
sp_cancel_adding_invoice 4430 4430 0 0.00 5 54843 823 0 0
sp_cancel_client_order 1531 1531 0 0.00 4 9847 374 0 0
sp_cancel_customer_reserve 432786 432786 0 0.00 0 25425 55 0 0
sp_cancel_pay_from_customer 637 637 0 0.00 2 3993 70 0 0
sp_cancel_pay_to_supplier 357 357 0 0.00 2 4520 73 0 0
sp_cancel_supplier_invoice 4907 4887 20 0.40 1 42411 676 0 20
sp_cancel_supplier_order 364 364 0 0.00 7 818643 80955 0 0
sp_cancel_write_off 7895 7895 0 0.00 0 14197 138 0 0
sp_client_order 18388 18388 0 0.00 3 31724 389 0 0
sp_customer_reserve 433851 433851 0 0.00 0 41973 201 0 0
sp_fill_shopping_cart 28170 28170 0 0.00 1 18462 37 0 0
sp_fill_shopping_cart_clo_res 433847 433847 0 0.00 0 15952 17 0 0
sp_get_clo_for_invoice 4441 4441 0 0.00 0 26375 350 0 0
sp_kill_cost_storno 13319 13319 0 0.00 0 6694 65 0 0
sp_kill_qstorno_ret_qs2qd 878718 878718 0 0.00 0 42379 30 0 0
sp_kill_qty_storno 465325 465325 0 0.00 0 42396 64 0 0
sp_lock_selected_doc 18510 18510 0 0.00 0 5470 3 0 0
sp_make_cost_storno 25022 25022 0 0.00 0 10740 56 0 0
sp_multiply_rows_for_pdistr 25022 25022 0 0.00 0 8927 34 0 0
sp_multiply_rows_for_qdistr 18388 18388 0 0.00 0 28282 211 0 0
sp_pay_from_customer 6384 6384 0 0.00 4 10132 120 0 0
sp_pay_to_supplier 5206 5206 0 0.00 4 10751 145 0 0
sp_payment_common 11590 11590 0 0.00 1 9109 23 0 0
sp_qd_handle_on_cancel_clo 1531 1531 0 0.00 0 9639 336 0 0
sp_qd_handle_on_invoice_upd_sts 8871 8871 0 0.00 0 26448 275 0 0
sp_qd_handle_on_reserve_upd_sts 8991 8991 0 0.00 0 21445 63 0 0
sp_reserve_write_off 8991 8991 0 0.00 6 21642 185 0 0
sp_supplier_invoice 4870 4870 0 0.00 5 70240 2766 0 0
sp_supplier_order 4913 4913 0 0.00 5 48549 1196 0 0
srv_aggregate_perf_data 94 94 0 0.00 1653 440134 20973 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2225 129266 40963 0 0
srv_find_qd_qs_mism 894404 894404 0 0.00 0 15740 7 0 0
srv_make_invnt_saldo 454 454 0 0.00 38 92517 3269 0 0
srv_make_money_saldo 639 639 0 0.00 1 14555 528 0 0
srv_recalc_idx_stat 3 3 0 0.00 161490 412670 270621 0 0
t$perf-abend:sp_add_invoice_to_stock 190 190 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 20 20 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4450 4450 0 0.00 0 8931 161 0 0
t$perf-norm:sp_cancel_adding_invoice 357 357 0 0.00 0 4025 90 0 0
t$perf-norm:sp_cancel_client_order 1531 1531 0 0.00 0 1772 15 0 0
t$perf-norm:sp_cancel_customer_reserve 601 601 0 0.00 0 3891 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 637 637 0 0.00 0 363 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 357 357 0 0.00 0 386 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 352 352 0 0.00 0 4186 20 0 0
t$perf-norm:sp_cancel_supplier_order 364 364 0 0.00 0 22566 1362 0 0
t$perf-norm:sp_cancel_write_off 880 880 0 0.00 0 3501 9 0 0
t$perf-norm:sp_client_order 18388 18388 0 0.00 0 3655 13 0 0
t$perf-norm:sp_customer_reserve 902 902 0 0.00 0 4055 12 0 0
t$perf-norm:sp_pay_from_customer 6384 6384 0 0.00 0 3371 8 0 0
t$perf-norm:sp_pay_to_supplier 5206 5206 0 0.00 0 2629 7 0 0
t$perf-norm:sp_reserve_write_off 8991 8991 0 0.00 0 4766 9 0 0
t$perf-norm:sp_supplier_invoice 4870 4870 0 0.00 0 2514 13 0 0
t$perf-norm:sp_supplier_order 4913 4913 0 0.00 0 4260 14 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 74 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 176 5 0 0
t$perf-norm:srv_make_invnt_saldo 454 454 0 0.00 0 2380 16 0 0
t$perf-norm:srv_make_money_saldo 639 639 0 0.00 0 3716 10 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9260 8880 380 4.10 0 5055 18 0 380
v_all_customers 34380 34380 0 0.00 0 36 0 0 0
v_all_suppliers 27940 27940 0 0.00 0 25 1 0 0
v_all_wares 36774 36774 0 0.00 0 86 1 0 0
v_cancel_adding_invoice 714 714 0 0.00 0 4368 17 0 0
v_cancel_client_order 3062 3062 0 0.00 0 9754 10 0 0
v_cancel_customer_prepayment 1274 1274 0 0.00 0 3979 9 0 0
v_cancel_customer_reserve 1202 1202 0 0.00 0 1510 5 0 0
v_cancel_payment_to_supplier 714 714 0 0.00 0 312 3 0 0
v_cancel_supplier_invoice 744 704 40 5.37 0 9731 36 0 40
v_cancel_supplier_order 728 728 0 0.00 0 833 5 0 0
v_cancel_write_off 1760 1760 0 0.00 0 2472 15 0 0
v_max_id_clo_ord 4913 4913 0 0.00 0 346 1 0 0
v_max_id_clo_res 902 902 0 0.00 0 5858 20 0 0
v_max_id_ord_sup 4870 4870 0 0.00 0 4619 3 0 0
v_max_non_paid_invoice 1019 1019 0 0.00 0 171 2 0 0
v_max_non_paid_realizn 3034 3034 0 0.00 0 3194 4 0 0
v_min_id_clo_ord 4913 4913 0 0.00 0 11716 12 0 0
v_min_id_clo_res 902 902 0 0.00 0 801 4 0 0
v_min_id_ord_sup 4870 4870 0 0.00 0 4430 7 0 0
v_min_non_paid_invoice 5206 5206 0 0.00 0 7264 13 0 0
v_min_non_paid_realizn 6384 6384 0 0.00 0 9102 19 0 0
v_our_firm 9094 9094 0 0.00 0 22 1 0 0
v_reserve_write_off 17982 17982 0 0.00 0 8435 7 0 0
x_lock_depdocs_on_canc_invoice 8965 8965 0 0.00 0 11727 105 0 0
x_lock_depdocs_on_canc_sup_ord 364 364 0 0.00 0 2264 276 0 0
x_make_qstorno_1000_1200 4913 4913 0 0.00 1 48529 1120 0 0
x_make_qstorno_1200_2000 4870 4870 0 0.00 2 69179 2631 0 0
x_make_qstorno_2100_3300 433851 433851 0 0.00 0 40615 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-04-2024 13:08:42 to 01-04-2024 13:08:46.

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:55 1053 8192000000 8944289984 9003876352 11288304 0.137 4 2 4 0 11691536 98224 305008
11:08:57 23579 8192000000 9707350176 10005073920 785975200 8.754 100 81 160 0 812114368 7046112 19093056
11:10:27 15330 8192000000 9749259488 10057449472 829746464 9.197 100 88 176 0 860235968 10502096 19987408
11:11:49 20970 8192000000 9784268560 10101981184 859713424 9.497 100 87 174 0 895278576 15983744 19581408
11:13:19 9464 8192000000 9844400416 10176917504 901493552 9.913 100 81 162 0 950903904 32107024 17303328
11:14:40 7615 8192000000 9914938560 10256723968 940862816 10.301 100 89 174 0 1022380912 63973184 17544912
11:15:50 4455 8192000000 9951556272 10302570496 976466496 10.650 100 83 165 2 1062779872 70378064 15935312
11:16:57 2527 8192000000 9982845552 10344013824 1001533248 10.893 100 81 160 0 1096264384 79140624 15590512
11:18:01 3079 8192000000 9997006688 10362589184 1022634160 11.097 100 86 171 1 1112241312 73096176 16510976
11:19:06 1929 8192000000 10002805248 10377461760 1045425200 11.317 100 85 168 0 1130420800 68630224 16365376
11:20:10 2976 8192000000 10012134128 10396364800 1056831280 11.426 100 68 136 1 1135949744 66197136 12921328
11:21:15 6724 8192000000 10010633472 10392686592 1061085904 11.467 100 78 155 1 1120763088 44631056 15046128
11:22:22 6442 8192000000 9997062016 10387386368 1065703392 11.511 100 38 76 0 1111267008 37881120 7682496
11:23:29 7117 8192000000 9963193872 10364968960 1072058576 11.572 100 24 47 0 1086583472 9254480 5270416
11:24:39 6871 8192000000 10009165072 10408013824 1077115168 11.620 100 44 91 1 1127174784 40788592 9271024
11:25:49 28319 8192000000 9999833488 10393784320 1081354432 11.660 100 54 109 2 1104682416 12104176 11223808
11:27:18 6454 8192000000 10009545888 10407976960 1079734304 11.645 99 37 76 1 1118164512 30557312 7872896
11:28:30 6909 8192000000 10035834688 10434899968 1098990048 11.828 100 52 101 0 1143840960 34356000 10494912
11:29:43 10696 8192000000 10073386944 10479484928 1110482464 11.937 100 49 98 0 1174715872 55138880 9094528
11:30:55 91143 8192000000 10105388928 10528239616 1103075040 11.867 99 44 88 0 1214045232 102296704 8673488
11:33:41 9894 8192000000 10093954016 10511781888 1105165360 11.887 99 53 106 0 1202102096 86026960 10909776
11:34:55 19373 8192000000 10077334624 10482475008 1098011760 11.819 99 54 106 0 1173437296 64713232 10712304
11:36:31 27857 8192000000 10116241152 10530103296 1111628832 11.948 100 47 93 0 1225913296 104902448 9382016
11:38:11 16696 8192000000 10121191040 10520502272 1088397152 11.727 97 51 102 0 1199234368 100351584 10485632
11:39:44 10369 8192000000 10087456896 10499678208 1084434016 11.690 99 37 75 0 1200568512 108618720 7515776
11:41:07 5569 8192000000 10075376880 10466861056 1056258864 11.421 98 43 85 1 1171347920 105863104 9225952
11:42:19 4815 8192000000 10141895648 10530701312 1066525328 11.519 99 62 124 0 1249692496 169622000 13545168
11:43:28 4086 8192000000 10178693040 10573926400 1090033984 11.743 100 53 105 0 1282131552 180243344 11854224
11:44:36 2224 8192000000 10217779024 10608115712 1089174048 11.735 99 80 161 1 1318970288 212009616 17786624
11:45:43 3267 8192000000 10254000352 10650730496 1103104528 11.867 100 77 152 1 1357057568 237392880 16560160
11:46:50 2831 8192000000 10249682928 10688946176 1110765920 11.940 100 66 132 2 1366164800 241304160 14094720
11:47:56 2888 8192000000 10300197936 10695856128 1129999664 12.121 100 79 157 0 1399723424 253579344 16144416
11:49:06 9762 8192000000 10304743104 10726469632 1117526480 12.004 100 42 83 1 1405044592 278170304 9347808
11:50:19 64729 8192000000 10265056480 10692415488 1121308720 12.039 100 27 54 1 1359403184 231186752 6907712
11:52:51 36716 8192000000 10085109600 10610966528 1086367888 11.708 98 11 22 0 1231706528 142868624 2470016
11:54:31 82650 8192000000 10070146512 10555547648 1101389920 11.851 99 14 28 0 1155540480 51308944 2841616
11:57:03 53368 8192000000 10066006624 10474827776 1093128816 11.772 97 28 53 1 1139183760 40924944 5130000
11:59:01 30806 8192000000 10159132960 10611027968 1139905056 12.215 100 20 40 0 1260062736 115993088 4164592
12:00:38 41731 8192000000 10122179664 10628952064 1133157376 12.151 100 8 16 0 1213793424 78985456 1650592
12:02:42 79791 8192000000 10055074672 10509848576 1135515088 12.173 100 17 34 0 1199084336 59891088 3678160
12:05:36 48543 8192000000 10056409104 10505105408 1143904064 12.252 100 12 20 1 1171404928 25631232 1869632
12:07:29 61441 8192000000 10172980736 10628050944 1160069648 12.404 100 30 60 0 1253216480 86791952 6354880
12:09:38 54010 8192000000 10150968944 10601132032 1133889728 12.158 98 13 26 0 1237591904 100971840 2730336
12:11:35 48708 8192000000 10111653840 10593837056 1155935792 12.365 100 11 22 0 1216242816 58066640 2240384
12:13:31 71565 8192000000 10090002464 10560684032 1153383072 12.341 100 11 23 1 1241698864 85665792 2650000
12:15:48 72774 8192000000 10120596176 10589519872 1161735248 12.420 100 23 46 0 1219441056 53513920 4191888
12:18:10 10673 8192000000 10086523584 10532151296 1151227152 12.321 100 38 74 0 1185579296 26781296 7570848
12:19:34 19733 8192000000 10114731568 10551857152 1125021792 12.074 97 44 87 0 1177856432 44442848 8391792
12:20:56 41182 8192000000 10063358592 10501730304 1054989696 11.409 92 12 24 0 1089886384 32583136 2313552
12:22:43 35016 8192000000 10103384800 10548301824 1118906400 12.017 99 22 42 0 1174008592 51021360 4080832
12:24:55 70854 8192000000 10074073904 10558185472 1079175296 11.640 96 11 23 0 1139884432 58580240 2128896
12:27:07 46386 8192000000 10066411312 10513334272 1070035552 11.552 97 35 69 0 1153713696 77086672 6591472
12:28:55 36992 8192000000 10052798400 10501980160 1063745888 11.492 97 31 62 1 1120283040 50954944 5582208
12:30:33 129266 8192000000 10050750336 10478288896 1040639200 11.271 95 23 46 0 1073860384 28788176 4433008
12:33:52 28919 8192000000 10036417568 10462056448 1087597616 11.720 99 38 76 0 1122853008 28176064 7079328
12:35:24 40111 8192000000 10040143088 10489905152 1087215312 11.716 99 22 44 1 1149913856 58570416 4128128
12:37:05 46074 8192000000 10015958256 10481496064 1075963264 11.609 98 7 14 0 1105908128 28918608 1026256
12:38:52 63472 8192000000 10002915888 10448674816 1058700336 11.444 97 10 21 0 1081749792 21053376 1996080
12:41:08 42404 8192000000 10047038608 10490433536 1081114560 11.658 98 21 42 0 1132864912 47350448 4399904
12:42:51 51603 8192000000 10073414896 10509725696 1106255248 11.897 99 34 68 0 1174246160 61044192 6946720
12:44:42 19177 8192000000 10064492528 10492903424 1104514176 11.880 99 39 77 1 1148568640 36598032 7456432
12:46:03 22665 8192000000 10102499296 10537721856 1124440464 12.069 100 41 82 0 1195637632 63545568 7651600
12:47:33 74461 8192000000 10127316192 10573025280 1124792448 12.072 99 31 61 0 1207711168 77219184 5699536
12:49:48 115640 8192000000 10098429552 10538557440 1111007232 11.942 97 27 54 0 1159288896 43006816 5274848
12:52:45 58374 8192000000 10095589984 10551373824 1140352656 12.219 99 37 74 0 1222375856 75008240 7014960
12:54:51 35122 8192000000 10095317360 10556784640 1147140832 12.283 100 9 18 0 1204801024 55770416 1889776
12:56:27 52488 8192000000 10082506496 10561884160 1129122512 12.113 98 8 17 0 1168140208 37201104 1816592
12:58:37 37864 8192000000 10086575600 10525401088 1123638224 12.061 98 15 28 1 1163500240 36911648 2950368
13:00:15 81949 8192000000 10113832336 10601439232 1119953344 12.027 98 18 36 1 1200556592 76856912 3746336
13:03:50 57205 8192000000 10138654368 10589138944 1089396304 11.737 96 25 50 0 1151917792 57691936 4829552
13:05:48 49516 8192000000 10062556832 10493202432 1079481008 11.643 96 26 53 1 1140277184 55617056 5179120
13:07:49 10555 8192000000 8956678608 9141977088 112317120 1.352 11 2 3 0 123101152 10426048 357984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 01-04-2024 13:08:48 to 01-04-2024 13:09:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 190 v_add_invoice_to_stock 335544517
except 20 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-04-2024 13:09:03 to 01-04-2024 13:09:05.

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          177118
MON$OLDEST_ACTIVE               177119
MON$OLDEST_SNAPSHOT             177119
MON$NEXT_TRANSACTION            177119
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                       1914400
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             702
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 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 Mon Apr  1 13:09:06 2024 
 
Database header page information: 
    Flags            0 
    Generation        92457 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177118 
    Oldest active        177119 
    Oldest snapshot        177119 
    Next transaction    177120 
    Sequence number        0 
    Next attachment ID    702 
    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.21, total records: 7835791 
    Average version length: 48.16, total versions: 137785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88880 
    Data pages: 88880, average fill: 71% 
    Primary pages: 88879, secondary pages: 1, swept pages: 26514 
    Empty pages: 0, full pages: 87021 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 15 
    40 - 59% = 76 
    60 - 79% = 88715 
    80 - 99% = 72 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23475, nodes: 7835791 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1723032, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 377 
        20 - 39% = 1578 
        40 - 59% = 4363 
        60 - 79% = 2272 
        80 - 99% = 14885 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13607, nodes: 7835791 
    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: 1546974, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1399 
        40 - 59% = 2277 
        60 - 79% = 1003 
        80 - 99% = 8928 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8388, nodes: 7835791 
    Average node length: 6.63, total dup: 5834545, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1540012, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 810 
        40 - 59% = 1547 
        60 - 79% = 837 
        80 - 99% = 5065 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.96, total records: 2291392 
    Average version length: 58.84, total versions: 71396, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28688 
    Data pages: 28688, average fill: 74% 
    Primary pages: 28687, secondary pages: 1, swept pages: 6529 
    Empty pages: 4, full pages: 28580 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 4 
    40 - 59% = 22 
    60 - 79% = 28479 
    80 - 99% = 175 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4605, nodes: 2291392 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 697514, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 832 
        40 - 59% = 965 
        60 - 79% = 671 
        80 - 99% = 2136 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2438, nodes: 2293433 
    Average node length: 4.97, total dup: 2292534, max dup: 21149 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1288523, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 186 
        40 - 59% = 1364 
        60 - 79% = 606 
        80 - 99% = 279 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1797, nodes: 2291392 
    Average node length: 4.97, total dup: 2291342, max dup: 130269 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1076041, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 667 
        60 - 79% = 46 
        80 - 99% = 1083 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4388, nodes: 2291392 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 697514, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 115 
        20 - 39% = 531 
        40 - 59% = 653 
        60 - 79% = 773 
        80 - 99% = 2316 
 
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.29, total records: 400 
    Average version length: 22.15, total versions: 2944, max versions: 8 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 48% 
    Primary pages: 14, secondary pages: 26, swept pages: 0 
    Empty pages: 7, full pages: 12 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 15 
 
    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: 14.50, total records: 97491 
    Average version length: 68.29, total versions: 88436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.07 
    Pointer pages: 6, data page slots: 3160 
    Data pages: 1672, average fill: 78% 
    Primary pages: 1671, secondary pages: 1, swept pages: 0 
    Empty pages: 110, full pages: 1294 
    Fill distribution: 
     0 - 19% = 141 
    20 - 39% = 71 
    40 - 59% = 88 
    60 - 79% = 172 
    80 - 99% = 1200 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700512, depth: 3, leaf buckets: 389, nodes: 97491 
    Average node length: 13.28, total dup: 7417, max dup: 2 
    Average key length: 10.66, compression ratio: 2.53 
    Average prefix length: 19.26, average data length: 7.74 
    Clustering factor: 73030, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 184 
        40 - 59% = 195 
        60 - 79% = 10 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 286, max versions: 10 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 16 
    Data pages: 16, average fill: 7% 
    Primary pages: 8, secondary pages: 8, swept pages: 0 
    Empty pages: 7, full pages: 1 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 10.22, total records: 1787 
    Average version length: 43.45, total versions: 1725, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 48% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 11, full pages: 15 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94403, depth: 2, leaf buckets: 2, nodes: 1787 
    Average node length: 4.26, total dup: 1689, max dup: 190 
    Average key length: 2.58, compression ratio: 7.36 
    Average prefix length: 18.47, average data length: 0.53 
    Clustering factor: 973, ratio: 0.54 
    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.68, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.34, total records: 826921 
    Average version length: 37.90, total versions: 44292, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 6, data page slots: 8416 
    Data pages: 8416, average fill: 67% 
    Primary pages: 8415, secondary pages: 1, swept pages: 663 
    Empty pages: 21, full pages: 7819 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 7 
    40 - 59% = 69 
    60 - 79% = 8234 
    80 - 99% = 82 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 858, nodes: 798009 
    Average node length: 4.88, total dup: 797960, max dup: 143922 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92870, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 125 
        40 - 59% = 453 
        60 - 79% = 183 
        80 - 99% = 96 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 943, nodes: 798009 
    Average node length: 5.89, total dup: 710157, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162480, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 35 
        40 - 59% = 522 
        60 - 79% = 122 
        80 - 99% = 260 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 988, nodes: 798009 
    Average node length: 5.89, total dup: 710157, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164380, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 102 
        40 - 59% = 531 
        60 - 79% = 118 
        80 - 99% = 237 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1132, nodes: 798009 
    Average node length: 5.98, total dup: 710157, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 156571, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 259 
        40 - 59% = 574 
        60 - 79% = 203 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5537 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.28, total fragments: 36, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 81, secondary pages: 15, swept pages: 49 
    Empty pages: 11, full pages: 56 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5537 
    Average node length: 5.46, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.13 
    Average prefix length: 34.61, average data length: 1.53 
    Clustering factor: 5252, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5537 
    Average node length: 11.10, 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: 161, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 80149 
    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: 840 
    Data pages: 840, average fill: 65% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 832 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 832 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35490, depth: 2, leaf buckets: 101, nodes: 80149 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3078, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.58, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 146.08, total records: 181475 
    Average version length: 152.42, total versions: 6434, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 7, data page slots: 5192 
    Data pages: 4488, average fill: 84% 
    Primary pages: 4485, secondary pages: 3, swept pages: 1 
    Empty pages: 28, full pages: 4454 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 4455 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 143.99, total records: 159673 
    Average version length: 152.35, total versions: 7996, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 4864 
    Data pages: 3952, average fill: 84% 
    Primary pages: 3949, secondary pages: 3, swept pages: 5 
    Empty pages: 24, full pages: 3916 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3916 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.80, total records: 124209 
    Average version length: 151.80, total versions: 5297, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 8, data page slots: 3288 
    Data pages: 3096, average fill: 83% 
    Primary pages: 3093, secondary pages: 3, swept pages: 1 
    Empty pages: 44, full pages: 3042 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3041 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.65, total records: 153507 
    Average version length: 152.63, total versions: 5175, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 4216 
    Data pages: 3800, average fill: 84% 
    Primary pages: 3798, secondary pages: 2, swept pages: 4 
    Empty pages: 16, full pages: 3774 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3775 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 146.38, total records: 158567 
    Average version length: 152.46, total versions: 5491, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 3960, average fill: 83% 
    Primary pages: 3958, secondary pages: 2, swept pages: 3 
    Empty pages: 51, full pages: 3891 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3891 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 146.40, total records: 150882 
    Average version length: 151.18, total versions: 4922, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5688 
    Data pages: 3800, average fill: 82% 
    Primary pages: 3799, secondary pages: 1, swept pages: 2 
    Empty pages: 70, full pages: 3680 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 11 
    40 - 59% = 31 
    60 - 79% = 7 
    80 - 99% = 3678 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 145.86, total records: 149462 
    Average version length: 152.79, total versions: 5546, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 3696, average fill: 84% 
    Primary pages: 3694, secondary pages: 2, swept pages: 5 
    Empty pages: 18, full pages: 3667 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3666 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 144.02, total records: 148723 
    Average version length: 152.76, total versions: 7100, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 6, data page slots: 5144 
    Data pages: 3784, average fill: 81% 
    Primary pages: 3782, secondary pages: 2, swept pages: 4 
    Empty pages: 122, full pages: 3627 
    Fill distribution: 
     0 - 19% = 126 
    20 - 39% = 11 
    40 - 59% = 12 
    60 - 79% = 8 
    80 - 99% = 3627 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 141.72, total records: 168042 
    Average version length: 153.82, total versions: 11380, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 9, data page slots: 5776 
    Data pages: 4208, average fill: 83% 
    Primary pages: 4205, secondary pages: 3, swept pages: 2 
    Empty pages: 63, full pages: 4124 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4125 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 146.93, total records: 154736 
    Average version length: 152.51, total versions: 4683, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 6, data page slots: 5048 
    Data pages: 3888, average fill: 82% 
    Primary pages: 3887, secondary pages: 1, swept pages: 3 
    Empty pages: 74, full pages: 3795 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3795 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.40, total records: 2144069 
    Average version length: 52.92, total versions: 66008, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25728 
    Data pages: 25728, average fill: 72% 
    Primary pages: 25716, secondary pages: 12, swept pages: 8321 
    Empty pages: 38, full pages: 24674 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 79 
    40 - 59% = 253 
    60 - 79% = 24595 
    80 - 99% = 723 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2603, nodes: 2144069 
    Average node length: 5.44, total dup: 2002601, max dup: 1341 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 184874, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 270 
        40 - 59% = 1700 
        60 - 79% = 314 
        80 - 99% = 314 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2144069 
    Average node length: 5.69, total dup: 1925793, max dup: 68 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383054, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2326 
        60 - 79% = 403 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2084, nodes: 2144069 
    Average node length: 4.96, total dup: 2143969, max dup: 28963 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182434, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 143 
        40 - 59% = 1021 
        60 - 79% = 431 
        80 - 99% = 489 
 
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: 38.07, total records: 158643 
    Average version length: 69.20, total versions: 82071, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.31 
    Pointer pages: 3, data page slots: 3904 
    Data pages: 2880, average fill: 68% 
    Primary pages: 2880, secondary pages: 0, swept pages: 233 
    Empty pages: 337, full pages: 2159 
    Fill distribution: 
     0 - 19% = 424 
    20 - 39% = 36 
    40 - 59% = 80 
    60 - 79% = 946 
    80 - 99% = 1394 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554601, depth: 3, leaf buckets: 224, nodes: 158643 
    Average node length: 6.44, total dup: 138380, max dup: 14 
    Average key length: 3.90, compression ratio: 10.77 
    Average prefix length: 40.23, average data length: 1.77 
    Clustering factor: 27906, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 115 
        60 - 79% = 67 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.98, total records: 7175665 
    Average version length: 68.81, total versions: 594934, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 66, data page slots: 107256 
    Data pages: 107256, average fill: 72% 
    Primary pages: 107255, secondary pages: 1, swept pages: 8990 
    Empty pages: 82, full pages: 95965 
    Fill distribution: 
     0 - 19% = 1021 
    20 - 39% = 3020 
    40 - 59% = 3974 
    60 - 79% = 96021 
    80 - 99% = 3220 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10711, nodes: 7175665 
    Average node length: 6.51, total dup: 6209313, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1689903, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1535 
        40 - 59% = 5805 
        60 - 79% = 2795 
        80 - 99% = 569 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8533, nodes: 7175665 
    Average node length: 5.40, total dup: 6890824, max dup: 174 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1488111, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1059 
        40 - 59% = 4746 
        60 - 79% = 1548 
        80 - 99% = 1172 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8620, nodes: 7175665 
    Average node length: 5.40, total dup: 6890824, max dup: 174 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1490542, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1166 
        40 - 59% = 4771 
        60 - 79% = 1498 
        80 - 99% = 1177 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.37, total records: 12197364 
    Average version length: 68.76, total versions: 520907, 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: 107, data page slots: 173712 
    Data pages: 173712, average fill: 75% 
    Primary pages: 173711, secondary pages: 1, swept pages: 43202 
    Empty pages: 13, full pages: 172562 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 155 
    40 - 59% = 398 
    60 - 79% = 167868 
    80 - 99% = 5243 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18488, nodes: 12192809 
    Average node length: 6.61, total dup: 10631646, max dup: 67 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2497451, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2206 
        40 - 59% = 10701 
        60 - 79% = 4679 
        80 - 99% = 872 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 38.52, total records: 2026769 
    Average version length: 69.08, total versions: 599663, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.27 
    Pointer pages: 27, data page slots: 43304 
    Data pages: 28784, average fill: 70% 
    Primary pages: 28713, secondary pages: 71, swept pages: 580 
    Empty pages: 39, full pages: 28618 
    Fill distribution: 
     0 - 19% = 130 
    20 - 39% = 4048 
    40 - 59% = 2454 
    60 - 79% = 13003 
    80 - 99% = 9149 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1861, nodes: 1594286 
    Average node length: 5.52, total dup: 1530047, max dup: 49 
    Average key length: 2.55, compression ratio: 16.47 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 112310, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 162 
        40 - 59% = 855 
        60 - 79% = 580 
        80 - 99% = 246 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 31.46, total records: 1608913 
    Average version length: 69.03, total versions: 176615, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.01 
    Pointer pages: 20, data page slots: 31960 
    Data pages: 26216, average fill: 44% 
    Primary pages: 26216, secondary pages: 0, swept pages: 4446 
    Empty pages: 4982, full pages: 16150 
    Fill distribution: 
     0 - 19% = 6972 
    20 - 39% = 2548 
    40 - 59% = 6162 
    60 - 79% = 9684 
    80 - 99% = 850 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1144, nodes: 778657 
    Average node length: 5.94, total dup: 717173, max dup: 79 
    Average key length: 3.01, compression ratio: 13.96 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 113657, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 297 
        40 - 59% = 556 
        60 - 79% = 267 
        80 - 99% = 24 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.46, total records: 9593916 
    Average version length: 68.96, total versions: 703132, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 89, data page slots: 144472 
    Data pages: 144472, average fill: 72% 
    Primary pages: 144449, secondary pages: 23, swept pages: 22013 
    Empty pages: 275, full pages: 118903 
    Fill distribution: 
     0 - 19% = 851 
    20 - 39% = 3897 
    40 - 59% = 11574 
    60 - 79% = 121885 
    80 - 99% = 6265 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13484, nodes: 9586349 
    Average node length: 6.68, total dup: 7952451, max dup: 17 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2208092, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 853 
        40 - 59% = 6419 
        60 - 79% = 5229 
        80 - 99% = 981 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21168147 
    Average version length: 82.90, total versions: 22495, 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: 197, data page slots: 319880 
    Data pages: 319880, average fill: 81% 
    Primary pages: 319875, secondary pages: 5, swept pages: 10861 
    Empty pages: 4, full pages: 319871 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 48170 
    80 - 99% = 271702 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19503, nodes: 21168147 
    Average node length: 5.72, total dup: 20686971, max dup: 154 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284710, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8364 
        60 - 79% = 553 
        80 - 99% = 10579 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17158, nodes: 21168147 
    Average node length: 6.31, total dup: 18602636, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915948, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 7 
        40 - 59% = 743 
        60 - 79% = 245 
        80 - 99% = 16159 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21263, nodes: 21168147 
    Average node length: 6.35, total dup: 18522181, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579307, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8582 
        60 - 79% = 610 
        80 - 99% = 12064 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16118, nodes: 21168147 
    Average node length: 5.56, total dup: 21168047, max dup: 231586 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944920, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 2947 
        60 - 79% = 351 
        80 - 99% = 12815 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.46, total records: 10016390 
    Average version length: 82.59, total versions: 676038, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 105, data page slots: 171328 
    Data pages: 171280, average fill: 73% 
    Primary pages: 171248, secondary pages: 32, swept pages: 43183 
    Empty pages: 416, full pages: 128283 
    Fill distribution: 
     0 - 19% = 1249 
    20 - 39% = 5073 
    40 - 59% = 17073 
    60 - 79% = 116786 
    80 - 99% = 31099 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11335, nodes: 10016390 
    Average node length: 5.36, total dup: 9704911, max dup: 223 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2298143, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 7251 
        60 - 79% = 3907 
        80 - 99% = 148 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13796, nodes: 10016390 
    Average node length: 6.23, total dup: 8304937, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1638630, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 3705 
        40 - 59% = 4706 
        60 - 79% = 2703 
        80 - 99% = 2559 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12652, nodes: 10016390 
    Average node length: 5.97, total dup: 8703643, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2493405, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 29 
        40 - 59% = 8086 
        60 - 79% = 4350 
        80 - 99% = 183 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10316, nodes: 10016390 
    Average node length: 5.13, total dup: 10016290, max dup: 166349 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1650162, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1116 
        40 - 59% = 5104 
        60 - 79% = 1860 
        80 - 99% = 2187 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.95, total records: 11580198 
    Average version length: 82.50, total versions: 528568, max versions: 1 
    Average fragment length: 73.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 118, data page slots: 191856 
    Data pages: 190584, average fill: 75% 
    Primary pages: 190483, secondary pages: 101, swept pages: 47273 
    Empty pages: 1924, full pages: 162100 
    Fill distribution: 
     0 - 19% = 3047 
    20 - 39% = 4412 
    40 - 59% = 10977 
    60 - 79% = 99815 
    80 - 99% = 72333 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13111, nodes: 11580198 
    Average node length: 5.30, total dup: 11470330, max dup: 634 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2427919, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 71 
        40 - 59% = 8440 
        60 - 79% = 4417 
        80 - 99% = 180 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10580, nodes: 11580198 
    Average node length: 5.50, total dup: 11076293, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 740253, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 785 
        40 - 59% = 2586 
        60 - 79% = 1828 
        80 - 99% = 5239 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14985, nodes: 11580198 
    Average node length: 6.02, total dup: 10116650, max dup: 76 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2444605, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 107 
        40 - 59% = 9920 
        60 - 79% = 4746 
        80 - 99% = 212 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11017, nodes: 11580198 
    Average node length: 5.22, total dup: 11580098, max dup: 202487 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 727887, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 745 
        40 - 59% = 5066 
        60 - 79% = 1538 
        80 - 99% = 3587 
 
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: 77.78, total records: 10136038 
    Average version length: 82.90, total versions: 681073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 109, data page slots: 176992 
    Data pages: 176944, average fill: 72% 
    Primary pages: 176909, secondary pages: 35, swept pages: 48086 
    Empty pages: 528, full pages: 124538 
    Fill distribution: 
     0 - 19% = 1497 
    20 - 39% = 6334 
    40 - 59% = 22681 
    60 - 79% = 116068 
    80 - 99% = 30364 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12122, nodes: 10136038 
    Average node length: 5.19, total dup: 10106837, max dup: 1841 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2103087, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1400 
        40 - 59% = 8085 
        60 - 79% = 1922 
        80 - 99% = 687 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13951, nodes: 10136038 
    Average node length: 6.25, total dup: 8403376, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1596651, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 204 
        20 - 39% = 3636 
        40 - 59% = 4716 
        60 - 79% = 2668 
        80 - 99% = 2727 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12730, nodes: 10136038 
    Average node length: 5.44, total dup: 9687111, max dup: 112 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2240582, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1288 
        40 - 59% = 8983 
        60 - 79% = 1788 
        80 - 99% = 637 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10549, nodes: 10136038 
    Average node length: 5.16, total dup: 10135938, max dup: 168588 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1672324, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1115 
        40 - 59% = 5406 
        60 - 79% = 1814 
        80 - 99% = 2172 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.25, total records: 580811 
    Average version length: 68.74, total versions: 9063, 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: 8040 
    Data pages: 8040, average fill: 76% 
    Primary pages: 8040, secondary pages: 0, swept pages: 2607 
    Empty pages: 0, full pages: 7873 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 17 
    60 - 79% = 7888 
    80 - 99% = 135 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44222, depth: 3, leaf buckets: 746, nodes: 580811 
    Average node length: 5.95, total dup: 494661, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102452, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 527 
        60 - 79% = 97 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36868, depth: 3, leaf buckets: 768, nodes: 580811 
    Average node length: 6.15, total dup: 476345, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102504, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 536 
        60 - 79% = 106 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 570, nodes: 580811 
    Average node length: 4.86, total dup: 580711, max dup: 9650 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90975, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 329 
        60 - 79% = 80 
        80 - 99% = 126 
 
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 Mon Apr  1 13:09:30 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7835791 137785 1 0.0000 0.0000
DOC_LIST 2291392 71396 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2944 8 700.0000 0.0000
INVNT_TURNOVER_LOG 97491 88436 1 0.0000 0.0000
MONEY_SALDO 49 286 10 500.0000 0.0000
MONEY_TURNOVER_LOG 1787 1725 1 0.0000 0.0000
PDISTR 826921 44292 2 0.0000 0.0000
PERF_SPLIT_0 181475 6434 1 0.0000 0.0000
PERF_SPLIT_1 159673 7996 1 0.0000 0.0000
PERF_SPLIT_2 124209 5297 1 0.0000 0.0000
PERF_SPLIT_3 153507 5175 1 0.0000 0.0000
PERF_SPLIT_4 158567 5491 1 0.0000 0.0000
PERF_SPLIT_5 150882 4922 1 0.0000 0.0000
PERF_SPLIT_6 149462 5546 1 0.0000 0.0000
PERF_SPLIT_7 148723 7100 1 0.0000 0.0000
PERF_SPLIT_8 168042 11380 1 0.0000 0.0000
PERF_SPLIT_9 154736 4683 1 0.0000 0.0000
PSTORNED 2144069 66008 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 158643 82071 1 0.0000 0.0000
XQD_1000_3300 7175665 594934 1 0.0000 0.0000
XQD_1200_2000 12197364 520907 1 0.0000 0.0000
XQD_2000_3300 2026769 599663 1 0.0000 0.0000
XQD_2100_3300 1608913 176615 1 0.0000 0.0000
XQD_3300_3400 9593916 703132 1 0.0000 0.0000
XQS_1000_1200 21168147 22495 1 0.0000 0.0000
XQS_1000_3300 10016390 676038 1 0.0000 0.0000
XQS_1200_2000 11580198 528568 1 0.0000 0.0000
XQS_2100_3300 10136038 681073 1 0.0000 0.0000
XQS_3300_3400 580811 9063 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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Mon Apr  1 13:08:07 2024
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:31: 
--- end of diff output ---

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

01.04.24 13:09:42. 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-04-01 13:09:45 No severe PSQL-related problems occured
01.04.24 13:09:46. End of report.