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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-16 16:14:15
DTS_END                         2024-03-16 16:13:11.3180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56038
TRN_ID                          175429
ATT_ID                          274
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: 9602.10 20575 960210
customer order: creation 172.53 326 17253
customer order: refuse 15.03 375 1503
order to supplier: creation 45.73 1285 4573
order to supplier: removal 3.76 101261 376
invoice (draft): creation 45.83 3281 4583
invoice (draft): removal 56.22 743 5622
invoice accept: apply 41.43 20056 4143
invoice accept: cancel 50.91 865 5091
customer reserve: creation 3948.85 192 394885
customer reserve: removal 4914.68 59 491468
realization accept: apply 84.23 241 8423
realization accept: cancel 92.61 141 9261
payment from customer: creation 60.06 163 6006
payment from customer: removal 5.86 104 586
payment to supplier: creation 48.99 182 4899
payment to supplier: removal 3.15 132 315
service: total inventory turnovers 4.66 1038 466
service: total monetary turnovers 6.75 29 675
service: aggregate perf. data 0.79 25245 79
service: refresh index statistics 0.03 255772 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-03-2024 16:15:25 to 16-03-2024 16:15:27.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3909
TEST_TIME 2 4206
TEST_TIME 3 3766
TEST_TIME 4 3666
TEST_TIME 5 4282
TEST_TIME 6 3994
TEST_TIME 7 4389
TEST_TIME 8 5277
TEST_TIME 9 5669
TEST_TIME 10 5659
TEST_TIME 11 5794
TEST_TIME 12 6038
TEST_TIME 13 6314
TEST_TIME 14 6418
TEST_TIME 15 6356
TEST_TIME 16 6433
TEST_TIME 17 6542
TEST_TIME 18 6526
TEST_TIME 19 6776
TEST_TIME 20 7017
TEST_TIME 21 7466
TEST_TIME 22 7676
TEST_TIME 23 7966
TEST_TIME 24 8019
TEST_TIME 25 8162
TEST_TIME 26 8860
TEST_TIME 27 9090
TEST_TIME 28 9296
TEST_TIME 29 9506
TEST_TIME 30 9939
TEST_TIME 31 9827
TEST_TIME 32 9924
TEST_TIME 33 9976
TEST_TIME 34 10082
TEST_TIME 35 9921
TEST_TIME 36 9985
TEST_TIME 37 9887
TEST_TIME 38 9871
TEST_TIME 39 9754
TEST_TIME 40 9829
TEST_TIME 41 9778
TEST_TIME 42 9741
TEST_TIME 43 9590
TEST_TIME 44 9636
TEST_TIME 45 9616
TEST_TIME 46 9547
TEST_TIME 47 9568
TEST_TIME 48 9551
TEST_TIME 49 9513
TEST_TIME 50 9669
TEST_TIME 51 9674
TEST_TIME 52 9641
TEST_TIME 53 9547
TEST_TIME 54 9467
TEST_TIME 55 9470
TEST_TIME 56 9515
TEST_TIME 57 9430
TEST_TIME 58 9380
TEST_TIME 59 9441
TEST_TIME 60 9402
TEST_TIME 61 9440
TEST_TIME 62 9398
TEST_TIME 63 9379
TEST_TIME 64 9525
TEST_TIME 65 9541
TEST_TIME 66 9539
TEST_TIME 67 9576
TEST_TIME 68 9584
TEST_TIME 69 9552
TEST_TIME 70 9628
TEST_TIME 71 9638
TEST_TIME 72 9678
TEST_TIME 73 9800
TEST_TIME 74 9705
TEST_TIME 75 9619
TEST_TIME 76 9623
TEST_TIME 77 9584
TEST_TIME 78 9598
TEST_TIME 79 9569
TEST_TIME 80 9499
TEST_TIME 81 9508
TEST_TIME 82 9424
TEST_TIME 83 9440
TEST_TIME 84 9459
TEST_TIME 85 9457
TEST_TIME 86 9445
TEST_TIME 87 9438
TEST_TIME 88 9484
TEST_TIME 89 9508
TEST_TIME 90 9539
TEST_TIME 91 9532
TEST_TIME 92 9550
TEST_TIME 93 9592
TEST_TIME 94 9571
TEST_TIME 95 9667
TEST_TIME 96 9697
TEST_TIME 97 9748
TEST_TIME 98 9769
TEST_TIME 99 9699
TEST_TIME 100 9604

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-03-2024 16:15:29 to 16-03-2024 16:15:32.

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 1323334 1323334 0 0.00 0 37080 8 0 0
doc_list_biud 1323334 1323334 0 0.00 0 59196 28 0 0
sp_add_invoice_to_stock 4259 4143 116 2.72 20 179236 20056 0 116
sp_cancel_adding_invoice 5091 5091 0 0.00 4 76933 866 0 0
sp_cancel_client_order 1503 1503 0 0.00 3 11658 375 0 0
sp_cancel_customer_reserve 491468 491468 0 0.00 0 59198 60 0 0
sp_cancel_pay_from_customer 586 586 0 0.00 2 6897 105 0 0
sp_cancel_pay_to_supplier 315 315 0 0.00 3 12645 132 0 0
sp_cancel_supplier_invoice 5632 5622 10 0.17 1 20140 743 0 10
sp_cancel_supplier_order 376 376 0 0.00 22 1163722 101261 0 0
sp_cancel_write_off 9261 9261 0 0.00 1 29292 142 0 0
sp_client_order 17253 17253 0 0.00 3 22703 326 0 0
sp_customer_reserve 394885 394885 0 0.00 0 37847 192 0 0
sp_fill_shopping_cart 26406 26406 0 0.00 1 25064 36 0 0
sp_fill_shopping_cart_clo_res 394883 394883 0 0.00 0 13258 14 0 0
sp_get_clo_for_invoice 4141 4141 0 0.00 0 36280 303 0 0
sp_kill_cost_storno 15253 15253 0 0.00 0 14248 70 0 0
sp_kill_qstorno_ret_qs2qd 998195 998195 0 0.00 0 59194 32 0 0
sp_kill_qty_storno 525885 525885 0 0.00 0 59196 70 0 0
sp_lock_selected_doc 17426 17426 0 0.00 0 7633 5 0 0
sp_make_cost_storno 23469 23469 0 0.00 0 35854 90 0 0
sp_multiply_rows_for_pdistr 23469 23469 0 0.00 0 14387 40 0 0
sp_multiply_rows_for_qdistr 17253 17253 0 0.00 0 22690 138 0 0
sp_pay_from_customer 6006 6006 0 0.00 4 17958 164 0 0
sp_pay_to_supplier 4899 4899 0 0.00 4 17824 183 0 0
sp_payment_common 10905 10905 0 0.00 1 17596 53 0 0
sp_qd_handle_on_cancel_clo 1503 1503 0 0.00 0 9609 329 0 0
sp_qd_handle_on_invoice_upd_sts 9232 9232 0 0.00 0 19881 369 0 0
sp_qd_handle_on_reserve_upd_sts 8423 8423 0 0.00 0 28139 59 0 0
sp_reserve_write_off 8423 8423 0 0.00 6 28161 241 0 0
sp_supplier_invoice 4583 4583 0 0.00 6 76571 3282 0 0
sp_supplier_order 4573 4573 0 0.00 4 27079 1286 0 0
srv_aggregate_perf_data 79 79 0 0.00 1768 381282 25246 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1541 95275 38848 0 0
srv_find_qd_qs_mism 918708 918708 0 0.00 0 10322 6 0 0
srv_make_invnt_saldo 466 466 0 0.00 30 27692 1038 0 0
srv_make_money_saldo 675 675 0 0.00 0 1011 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 235415 271096 255773 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4143 4143 0 0.00 0 21533 201 0 0
t$perf-norm:sp_cancel_adding_invoice 346 346 0 0.00 0 4363 106 0 0
t$perf-norm:sp_cancel_client_order 1503 1503 0 0.00 0 4425 17 0 0
t$perf-norm:sp_cancel_customer_reserve 515 515 0 0.00 0 3532 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 586 586 0 0.00 0 6953 27 0 0
t$perf-norm:sp_cancel_pay_to_supplier 315 315 0 0.00 0 943 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 353 353 0 0.00 0 543 9 0 0
t$perf-norm:sp_cancel_supplier_order 376 376 0 0.00 0 25169 2170 0 0
t$perf-norm:sp_cancel_write_off 868 868 0 0.00 0 3689 9 0 0
t$perf-norm:sp_client_order 17253 17253 0 0.00 0 20231 21 0 0
t$perf-norm:sp_customer_reserve 797 797 0 0.00 0 1053 8 0 0
t$perf-norm:sp_pay_from_customer 6006 6006 0 0.00 0 6925 11 0 0
t$perf-norm:sp_pay_to_supplier 4899 4899 0 0.00 0 12564 14 0 0
t$perf-norm:sp_reserve_write_off 8423 8423 0 0.00 0 5810 11 0 0
t$perf-norm:sp_supplier_invoice 4583 4583 0 0.00 0 6945 22 0 0
t$perf-norm:sp_supplier_order 4573 4573 0 0.00 0 3917 17 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 945 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 559 15 0 0
t$perf-norm:srv_make_invnt_saldo 466 466 0 0.00 0 1320 32 0 0
t$perf-norm:srv_make_money_saldo 675 675 0 0.00 0 5855 24 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 5 0 0
v_add_invoice_to_stock 8514 8282 232 2.72 0 8525 23 0 232
v_all_customers 32108 32108 0 0.00 0 63 1 0 0
v_all_suppliers 26086 26086 0 0.00 0 19 1 0 0
v_all_wares 34506 34506 0 0.00 0 28 1 0 0
v_cancel_adding_invoice 692 692 0 0.00 0 2105 14 0 0
v_cancel_client_order 3006 3006 0 0.00 0 11555 14 0 0
v_cancel_customer_prepayment 1172 1172 0 0.00 0 6880 15 0 0
v_cancel_customer_reserve 1030 1030 0 0.00 0 2078 6 0 0
v_cancel_payment_to_supplier 630 630 0 0.00 0 408 4 0 0
v_cancel_supplier_invoice 726 706 20 2.75 0 6877 34 0 20
v_cancel_supplier_order 752 752 0 0.00 0 8653 15 0 0
v_cancel_write_off 1736 1736 0 0.00 0 6915 22 0 0
v_max_id_clo_ord 4572 4572 0 0.00 0 1046 1 0 0
v_max_id_clo_res 797 797 0 0.00 0 2263 13 0 0
v_max_id_ord_sup 4580 4580 0 0.00 0 3429 4 0 0
v_max_non_paid_invoice 1008 1008 0 0.00 0 2831 7 0 0
v_max_non_paid_realizn 2901 2901 0 0.00 0 3419 8 0 0
v_min_id_clo_ord 4572 4572 0 0.00 0 4625 9 0 0
v_min_id_clo_res 797 797 0 0.00 0 1670 5 0 0
v_min_id_ord_sup 4580 4580 0 0.00 0 4920 12 0 0
v_min_non_paid_invoice 4899 4899 0 0.00 0 12563 36 0 0
v_min_non_paid_realizn 6006 6006 0 0.00 0 17588 49 0 0
v_our_firm 8608 8608 0 0.00 0 18 1 0 0
v_reserve_write_off 16846 16846 0 0.00 0 11322 9 0 0
x_lock_depdocs_on_canc_invoice 10360 10360 0 0.00 0 24257 141 0 0
x_lock_depdocs_on_canc_sup_ord 376 376 0 0.00 0 4638 339 0 0
x_make_qstorno_1000_1200 4573 4573 0 0.00 1 27069 1197 0 0
x_make_qstorno_1200_2000 4583 4583 0 0.00 2 72500 3162 0 0
x_make_qstorno_2100_3300 394885 394885 0 0.00 0 35654 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-03-2024 16:15:33 to 16-03-2024 16:15:37.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:13:15 8 8192000000 8806946928 8820985856 11536112 0.140 4 3 4 0 11721344 78128 107104
14:14:16 31234 8192000000 9894686160 10203635712 975267552 10.638 100 85 170 0 1003319776 5743040 22309184
14:16:00 18801 8192000000 9948590976 10270773248 1027401824 11.143 100 89 178 0 1059639936 9339088 22899024
14:17:31 12471 8192000000 9967535360 10300514304 1053791216 11.397 100 82 164 0 1084779952 9952160 21036576
14:18:48 9613 8192000000 10022728752 10369880064 1109058128 11.923 100 85 170 0 1141011648 11077216 20876304
14:20:02 5003 8192000000 10061597984 10416365568 1148570096 12.296 100 75 150 0 1177698224 11869136 17258992
14:21:13 2821 8192000000 10111432032 10477457408 1201398704 12.789 100 77 155 0 1231161664 12784224 16978736
14:22:17 8825 8192000000 10151172832 10531495936 1245736704 13.199 100 77 152 0 1274854704 12750192 16367808
14:23:29 1417 8192000000 10196526992 10576601088 1282100640 13.532 100 89 178 0 1315292208 13887232 19304336
14:24:33 14363 8192000000 10193779392 10585522176 1287916480 13.585 100 59 117 2 1309035504 7358848 13760176
14:25:49 7195 8192000000 10194514176 10595971072 1298468080 13.681 100 45 91 1 1314452352 5390576 10593696
14:27:01 6878 8192000000 10190075520 10599845888 1303922016 13.731 100 23 43 1 1315272032 5618016 5732000
14:28:09 12114 8192000000 10197234688 10615558144 1316735504 13.847 100 17 34 1 1326716416 6367776 3613136
14:29:22 52481 8192000000 10233712576 10640334848 1323105408 13.905 100 47 92 1 1339785712 5329360 11350944
14:31:15 6208 8192000000 10227685488 10642399232 1332215184 13.987 100 43 86 2 1350422992 7960560 10247248
14:32:24 3368 8192000000 10212208576 10628214784 1319914176 13.876 100 16 33 0 1328719616 5186656 3618784
14:33:34 40755 8192000000 10196531568 10608476160 1281038224 13.522 97 31 62 0 1294550480 5311488 8200768
14:35:36 32156 8192000000 10214783360 10625720320 1295521728 13.655 98 50 96 2 1315119360 7328160 12269472
14:37:12 10401 8192000000 10228139232 10632994816 1317813072 13.857 100 56 113 1 1341902880 11147536 12942272
14:38:26 36881 8192000000 10223993840 10643374080 1320791632 13.884 99 31 62 0 1339804576 11893440 7119504
14:40:06 12032 8192000000 10225621376 10635870208 1289490896 13.600 97 35 69 0 1314486208 16962000 8033312
14:41:29 25236 8192000000 10194060592 10603065344 1264260416 13.369 95 34 67 1 1291312768 18925072 8127280
14:42:59 16432 8192000000 10231147408 10630635520 1303264800 13.725 99 53 107 0 1332831408 17298544 12268064
14:44:20 3555 8192000000 10224354576 10625482752 1294712336 13.647 98 43 86 0 1325235840 20264720 10258784
14:45:27 22042 8192000000 10228339344 10628280320 1293908384 13.640 99 53 101 0 1330094752 24055344 12131024
14:46:52 3664 8192000000 10259948400 10658451456 1323541632 13.909 99 67 129 2 1362627040 24186032 14899376
14:48:00 18028 8192000000 10274512880 10677067776 1341136016 14.068 100 54 107 0 1375409488 21878944 12394528
14:49:23 3916 8192000000 10302790144 10698469376 1359624656 14.234 100 67 133 1 1403241392 27527408 16089328
14:50:31 6981 8192000000 10311767600 10712186880 1360046896 14.238 99 78 153 1 1407914192 29359040 18508256
14:51:44 2249 8192000000 10300355952 10699374592 1350363840 14.151 99 72 141 3 1401955872 33714000 17878032
14:52:57 3379 8192000000 10341090448 10747097088 1386654000 14.476 100 72 142 1 1443687696 38938736 18094960
14:54:07 1540 8192000000 10356185456 10759151616 1396462848 14.563 100 87 174 4 1460012320 41572624 21976848
14:55:12 7913 8192000000 10348177008 10765410304 1399155520 14.587 100 56 111 0 1452051856 38754496 14141840
14:56:51 18617 8192000000 10340323968 10772951040 1400598832 14.600 100 33 66 0 1448284240 38150800 9534608
14:58:22 1597 8192000000 10384044576 10797191168 1411247472 14.695 100 87 173 1 1484691648 50662336 22781840
14:59:28 6563 8192000000 10361485680 10789937152 1416172704 14.739 100 51 102 0 1465732768 36704112 12855952
15:00:44 13977 8192000000 10342582752 10793029632 1409494448 14.679 100 29 58 1 1454213472 36955568 7763456
15:02:12 27045 8192000000 10323331152 10779197440 1399879968 14.594 100 18 36 1 1434881104 29995168 5005968
15:03:44 32070 8192000000 10311674688 10772865024 1398062960 14.578 100 22 44 1 1417380880 14665888 4652032
15:05:52 24562 8192000000 10317506320 10773635072 1403628224 14.627 100 18 38 0 1423821824 15926656 4266944
15:07:21 82909 8192000000 10326176496 10760769536 1376686912 14.387 98 25 51 0 1394150912 11592560 5871440
15:09:44 63429 8192000000 10305566128 10757328896 1374005008 14.363 98 11 22 0 1387115136 10667792 2442336
15:11:50 52095 8192000000 10298900048 10742050816 1354986224 14.192 97 14 28 0 1368929216 11072240 2870752
15:13:48 95271 8192000000 10315440192 10772488192 1385031856 14.462 99 14 29 0 1404467024 16517664 2917504
15:16:28 71614 8192000000 10316196224 10770649088 1381562000 14.431 99 33 65 0 1411952624 23149856 7240768
15:18:45 61690 8192000000 10281544720 10730455040 1371690272 14.342 98 36 72 0 1390586944 10809952 8086720
15:20:48 42126 8192000000 10316561728 10765987840 1401152448 14.605 100 25 48 0 1418901616 11743520 6005648
15:22:31 29516 8192000000 10295133952 10746261504 1380213296 14.418 99 44 88 1 1405263296 14575744 10474256
15:24:03 38177 8192000000 10275151056 10740875264 1358590512 14.225 98 22 43 0 1373335664 9901408 4843744
15:25:44 42854 8192000000 10266089488 10720878592 1330288496 13.970 97 13 27 0 1342372528 8913856 3170176
15:27:27 76191 8192000000 10269480416 10723364864 1357060912 14.211 100 13 26 0 1374803456 14264096 3478448
15:30:02 61384 8192000000 10256297600 10706280448 1313756720 13.820 96 24 48 0 1336355344 16859360 5739264
15:32:24 55999 8192000000 10239436896 10702102528 1312196768 13.806 97 10 20 0 1323792416 9343280 2252368
15:34:24 54965 8192000000 10239606160 10689470464 1290121808 13.605 95 15 30 0 1302494848 8757648 3615392
15:36:21 21137 8192000000 10257175888 10698985472 1332155632 13.987 99 40 80 0 1354506736 13244992 9106112
15:37:46 43478 8192000000 10236429024 10687193088 1284580688 13.555 95 10 20 0 1301961504 14998592 2382224
15:39:51 39882 8192000000 10269525440 10720346112 1354659648 14.189 100 31 61 0 1371843616 10478528 6705440
15:41:43 39227 8192000000 10273960608 10706538496 1318127584 13.860 97 41 80 1 1337831504 10361008 9342912
15:43:41 73108 8192000000 10280301648 10719219712 1330723200 13.974 97 16 32 0 1347925920 13992112 3210608
15:45:54 79396 8192000000 10294161136 10740989952 1345195552 14.104 98 6 10 1 1369668048 23828240 644256
15:48:20 72301 8192000000 10289912528 10747355136 1378483456 14.403 100 30 60 0 1394868368 9674272 6710640
15:50:35 3780 8192000000 10293124288 10739183616 1372257904 14.347 99 37 74 2 1391562432 10972960 8331568
15:51:39 66617 8192000000 10291546272 10760798208 1384485552 14.457 99 12 24 0 1401005536 13930304 2589680
15:54:06 40382 8192000000 10302002256 10763542528 1387650640 14.485 99 19 36 1 1401820352 10377440 3792272
15:56:00 76670 8192000000 10297455104 10772021248 1405265184 14.642 100 13 26 1 1422553072 13721328 3566560
15:58:17 68735 8192000000 10289933712 10748067840 1345337456 14.106 96 13 26 0 1358985520 10580224 3067840
16:00:52 51047 8192000000 10303823456 10768642048 1397554224 14.573 100 16 32 0 1419440608 17803168 4083216
16:02:51 49661 8192000000 10295435888 10751635456 1379637984 14.413 99 18 36 0 1392326288 9125600 3562704
16:04:42 45168 8192000000 10296721856 10754158592 1366771712 14.298 98 29 58 0 1384104096 10901040 6431344
16:06:28 70347 8192000000 10307707104 10756771840 1367476368 14.304 98 22 44 0 1383908800 11268528 5163904
16:08:40 72140 8192000000 10276327360 10725609472 1326648304 13.937 96 7 14 0 1343703728 15434080 1621344
16:11:07 62519 8192000000 10297798464 10761662464 1382587424 14.440 100 9 18 1 1400295216 15403664 2304128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 16-03-2024 16:15:39 to 16-03-2024 16:15:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-03-2024 16:15:54 to 16-03-2024 16:15:56.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          175325
MON$OLDEST_ACTIVE               179584
MON$OLDEST_SNAPSHOT             179584
MON$NEXT_TRANSACTION            179584
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1945184
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sat Mar 16 16:15:57 2024 
 
Database header page information: 
    Flags            0 
    Generation        94598 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175325 
    Oldest active        179584 
    Oldest snapshot        179584 
    Next transaction    179585 
    Sequence number        0 
    Next attachment ID    706 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.58, total records: 7633557 
    Average version length: 48.16, total versions: 49003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87680 
    Data pages: 87680, average fill: 70% 
    Primary pages: 87680, secondary pages: 0, swept pages: 40693 
    Empty pages: 4, full pages: 47210 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 850 
    40 - 59% = 6454 
    60 - 79% = 80325 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23301, nodes: 7633557 
    Average node length: 18.84, total dup: 0, max dup: 0 
    Average key length: 15.85, compression ratio: 1.70 
    Average prefix length: 14.15, average data length: 12.85 
    Clustering factor: 1643957, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 351 
        20 - 39% = 2478 
        40 - 59% = 3766 
        60 - 79% = 2624 
        80 - 99% = 14082 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13516, nodes: 7633557 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1467758, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1977 
        40 - 59% = 1725 
        60 - 79% = 1271 
        80 - 99% = 8543 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8352, nodes: 7633557 
    Average node length: 6.59, total dup: 5746490, max dup: 49 
    Average key length: 3.60, compression ratio: 2.50 
    Average prefix length: 7.65, average data length: 1.35 
    Clustering factor: 1460734, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 1279 
        40 - 59% = 1171 
        60 - 79% = 1067 
        80 - 99% = 4717 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.62, total records: 2182675 
    Average version length: 34.67, total versions: 58640, max versions: 3 
    Average fragment length: 13.67, total fragments: 6, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28792 
    Data pages: 28792, average fill: 70% 
    Primary pages: 28784, secondary pages: 8, swept pages: 16408 
    Empty pages: 5, full pages: 15285 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 374 
    40 - 59% = 3589 
    60 - 79% = 24369 
    80 - 99% = 421 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4538, nodes: 2182675 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 657118, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1030 
        40 - 59% = 777 
        60 - 79% = 843 
        80 - 99% = 1887 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2491, nodes: 2184514 
    Average node length: 4.97, total dup: 2183615, max dup: 19716 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1223275, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 320 
        40 - 59% = 1514 
        60 - 79% = 477 
        80 - 99% = 178 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2023, nodes: 2182675 
    Average node length: 4.97, total dup: 2182625, max dup: 130349 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1050079, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 314 
        40 - 59% = 788 
        60 - 79% = 82 
        80 - 99% = 836 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4323, nodes: 2182675 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 657118, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 653 
        40 - 59% = 589 
        60 - 79% = 958 
        80 - 99% = 2021 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.61, total records: 400 
    Average version length: 23.21, total versions: 238208, max versions: 621 
    Average fragment length: 2.05, total fragments: 38, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 91% 
    Primary pages: 10, secondary pages: 1302, swept pages: 0 
    Empty pages: 3, full pages: 1308 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1309 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 4.07, total records: 80431 
    Average version length: 68.30, total versions: 75640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 21.61 
    Pointer pages: 7, data page slots: 2640 
    Data pages: 1688, average fill: 60% 
    Primary pages: 1687, secondary pages: 1, swept pages: 148 
    Empty pages: 239, full pages: 825 
    Fill distribution: 
     0 - 19% = 302 
    20 - 39% = 181 
    40 - 59% = 213 
    60 - 79% = 275 
    80 - 99% = 717 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705614, depth: 3, leaf buckets: 359, nodes: 80431 
    Average node length: 13.50, total dup: 6679, max dup: 1 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 57627, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 263 
        40 - 59% = 81 
        60 - 79% = 14 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 18899, max versions: 991 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 5, secondary pages: 67, swept pages: 0 
    Empty pages: 4, full pages: 67 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.01, total records: 1237 
    Average version length: 43.89, total versions: 1153, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 19.26 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 40% 
    Primary pages: 29, secondary pages: 1, swept pages: 1 
    Empty pages: 7, full pages: 6 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90628, depth: 2, leaf buckets: 2, nodes: 1237 
    Average node length: 4.41, total dup: 1142, max dup: 156 
    Average key length: 2.83, compression ratio: 6.71 
    Average prefix length: 18.24, average data length: 0.76 
    Clustering factor: 644, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.15, 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: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, 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: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 37.16, total records: 839316 
    Average version length: 25.83, total versions: 27772, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.45 
    Pointer pages: 6, data page slots: 8488 
    Data pages: 8488, average fill: 68% 
    Primary pages: 8470, secondary pages: 18, swept pages: 4772 
    Empty pages: 11, full pages: 4283 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 52 
    40 - 59% = 558 
    60 - 79% = 7744 
    80 - 99% = 110 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 944, nodes: 839316 
    Average node length: 4.88, total dup: 839267, max dup: 160138 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90970, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 150 
        40 - 59% = 549 
        60 - 79% = 181 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1068, nodes: 839316 
    Average node length: 5.89, total dup: 747394, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164945, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 100 
        40 - 59% = 642 
        60 - 79% = 125 
        80 - 99% = 199 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1109, nodes: 839316 
    Average node length: 5.89, total dup: 747394, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166870, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 219 
        40 - 59% = 587 
        60 - 79% = 90 
        80 - 99% = 213 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1185, nodes: 839316 
    Average node length: 5.97, total dup: 747394, max dup: 43 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159429, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 239 
        40 - 59% = 643 
        60 - 79% = 213 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.81, total records: 5442 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.35, total fragments: 55, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 74, secondary pages: 22, swept pages: 64 
    Empty pages: 13, full pages: 59 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5442 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.40, average data length: 1.55 
    Clustering factor: 5084, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5442 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 144, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.22, total records: 80414 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.22 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 776 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 776 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37776, depth: 2, leaf buckets: 103, nodes: 80414 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3317, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.71, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.27 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 149.81, total records: 170802 
    Average version length: 149.18, total versions: 1293, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 4416 
    Data pages: 4120, average fill: 85% 
    Primary pages: 4119, secondary pages: 1, swept pages: 1 
    Empty pages: 61, full pages: 4040 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4040 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 146.79, total records: 170227 
    Average version length: 151.78, total versions: 4353, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 5008 
    Data pages: 4104, average fill: 85% 
    Primary pages: 4104, secondary pages: 0, swept pages: 1 
    Empty pages: 67, full pages: 4018 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4018 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 149.75, total records: 183737 
    Average version length: 151.14, total versions: 1598, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 5192 
    Data pages: 4440, average fill: 85% 
    Primary pages: 4440, secondary pages: 0, swept pages: 2 
    Empty pages: 77, full pages: 4346 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4346 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 150.56, total records: 182729 
    Average version length: 144.31, total versions: 608, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 4712 
    Data pages: 4416, average fill: 85% 
    Primary pages: 4416, secondary pages: 0, swept pages: 3 
    Empty pages: 73, full pages: 4324 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4323 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.20, total records: 174484 
    Average version length: 151.75, total versions: 2576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 4936 
    Data pages: 4184, average fill: 86% 
    Primary pages: 4184, secondary pages: 0, swept pages: 1 
    Empty pages: 32, full pages: 4139 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 4140 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.94, total records: 171388 
    Average version length: 150.88, total versions: 2240, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 8, data page slots: 4488 
    Data pages: 4128, average fill: 85% 
    Primary pages: 4128, secondary pages: 0, swept pages: 1 
    Empty pages: 62, full pages: 4051 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4052 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.00, total records: 162280 
    Average version length: 151.69, total versions: 1794, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 8, data page slots: 4488 
    Data pages: 3904, average fill: 85% 
    Primary pages: 3904, secondary pages: 0, swept pages: 1 
    Empty pages: 55, full pages: 3829 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3830 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 139.54, total records: 205237 
    Average version length: 154.69, total versions: 15932, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.15 
    Pointer pages: 7, data page slots: 6528 
    Data pages: 4960, average fill: 86% 
    Primary pages: 4960, secondary pages: 0, swept pages: 1 
    Empty pages: 68, full pages: 4863 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 12 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4863 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 116.32, total records: 220721 
    Average version length: 154.88, total versions: 50579, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.58 
    Pointer pages: 7, data page slots: 6992 
    Data pages: 5336, average fill: 87% 
    Primary pages: 5336, secondary pages: 0, swept pages: 1 
    Empty pages: 70, full pages: 5245 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 11 
    80 - 99% = 5243 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.85, total records: 180973 
    Average version length: 150.31, total versions: 1400, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 5112 
    Data pages: 4336, average fill: 86% 
    Primary pages: 4336, secondary pages: 0, swept pages: 1 
    Empty pages: 38, full pages: 4281 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 0 
    80 - 99% = 4281 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.14, total records: 2036247 
    Average version length: 52.93, total versions: 23498, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25680 
    Data pages: 25672, average fill: 68% 
    Primary pages: 25672, secondary pages: 0, swept pages: 14274 
    Empty pages: 359, full pages: 17606 
    Fill distribution: 
     0 - 19% = 789 
    20 - 39% = 814 
    40 - 59% = 2011 
    60 - 79% = 21867 
    80 - 99% = 191 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2573, nodes: 2036247 
    Average node length: 5.45, total dup: 1898501, max dup: 1586 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 176437, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 361 
        40 - 59% = 1647 
        60 - 79% = 314 
        80 - 99% = 245 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2036247 
    Average node length: 5.70, total dup: 1826319, max dup: 70 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 364213, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 2526 
        60 - 79% = 196 
        80 - 99% = 16 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2120, nodes: 2036247 
    Average node length: 4.96, total dup: 2036147, max dup: 27934 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 174647, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 228 
        40 - 59% = 1151 
        60 - 79% = 370 
        80 - 99% = 368 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 54.39, total records: 114685 
    Average version length: 69.19, total versions: 24561, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.32 
    Pointer pages: 3, data page slots: 4608 
    Data pages: 3616, average fill: 36% 
    Primary pages: 3615, secondary pages: 1, swept pages: 1230 
    Empty pages: 997, full pages: 355 
    Fill distribution: 
     0 - 19% = 1296 
    20 - 39% = 406 
    40 - 59% = 999 
    60 - 79% = 754 
    80 - 99% = 161 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104047, depth: 3, leaf buckets: 227, nodes: 114685 
    Average node length: 6.57, total dup: 99571, max dup: 14 
    Average key length: 4.01, compression ratio: 10.48 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 20077, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 118 
        40 - 59% = 90 
        60 - 79% = 18 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 67.79, total records: 7236413 
    Average version length: 68.73, total versions: 123111, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 67, data page slots: 108056 
    Data pages: 108056, average fill: 71% 
    Primary pages: 108056, secondary pages: 0, swept pages: 74709 
    Empty pages: 1, full pages: 56738 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 532 
    40 - 59% = 9321 
    60 - 79% = 96762 
    80 - 99% = 1404 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10891, nodes: 7236413 
    Average node length: 6.51, total dup: 6260197, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1578184, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1723 
        40 - 59% = 5789 
        60 - 79% = 2783 
        80 - 99% = 586 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8912, nodes: 7236413 
    Average node length: 5.39, total dup: 6951517, max dup: 143 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1379797, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1327 
        40 - 59% = 5076 
        60 - 79% = 1590 
        80 - 99% = 906 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8998, nodes: 7236413 
    Average node length: 5.39, total dup: 6951517, max dup: 143 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1382191, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1413 
        40 - 59% = 5085 
        60 - 79% = 1632 
        80 - 99% = 862 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 68.24, total records: 12352723 
    Average version length: 68.73, total versions: 128223, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 108, data page slots: 174936 
    Data pages: 174936, average fill: 75% 
    Primary pages: 174936, secondary pages: 0, swept pages: 121958 
    Empty pages: 11, full pages: 138618 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 341 
    40 - 59% = 5348 
    60 - 79% = 166968 
    80 - 99% = 2246 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18631, nodes: 12352723 
    Average node length: 6.62, total dup: 10768162, max dup: 49 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2390755, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 2132 
        40 - 59% = 10702 
        60 - 79% = 4757 
        80 - 99% = 1004 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 51.78, total records: 1223086 
    Average version length: 69.09, total versions: 307304, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.43 
    Pointer pages: 31, data page slots: 49248 
    Data pages: 28824, average fill: 48% 
    Primary pages: 28824, secondary pages: 0, swept pages: 16124 
    Empty pages: 6125, full pages: 12351 
    Fill distribution: 
     0 - 19% = 9223 
    20 - 39% = 2881 
    40 - 59% = 2510 
    60 - 79% = 9659 
    80 - 99% = 4551 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2152, nodes: 1223086 
    Average node length: 5.54, total dup: 1173447, max dup: 97 
    Average key length: 2.59, compression ratio: 16.25 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 79178, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1219 
        40 - 59% = 791 
        60 - 79% = 119 
        80 - 99% = 9 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 53.03, total records: 842869 
    Average version length: 69.15, total versions: 195375, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.38 
    Pointer pages: 24, data page slots: 38760 
    Data pages: 29936, average fill: 33% 
    Primary pages: 29936, secondary pages: 0, swept pages: 15161 
    Empty pages: 7874, full pages: 2409 
    Fill distribution: 
     0 - 19% = 12155 
    20 - 39% = 4783 
    40 - 59% = 6912 
    60 - 79% = 5050 
    80 - 99% = 1036 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1514, nodes: 842869 
    Average node length: 5.87, total dup: 782992, max dup: 97 
    Average key length: 2.93, compression ratio: 14.34 
    Average prefix length: 41.14, average data length: 0.86 
    Clustering factor: 121774, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 783 
        40 - 59% = 601 
        60 - 79% = 123 
        80 - 99% = 0 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.52, total records: 8535682 
    Average version length: 69.00, total versions: 170803, 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: 92, data page slots: 148688 
    Data pages: 148648, average fill: 62% 
    Primary pages: 148648, secondary pages: 0, swept pages: 111597 
    Empty pages: 825, full pages: 49711 
    Fill distribution: 
     0 - 19% = 3376 
    20 - 39% = 16513 
    40 - 59% = 35003 
    60 - 79% = 91899 
    80 - 99% = 1857 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13380, nodes: 8535682 
    Average node length: 6.71, total dup: 7078447, max dup: 14 
    Average key length: 3.68, compression ratio: 11.43 
    Average prefix length: 40.49, average data length: 1.51 
    Clustering factor: 1793565, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2281 
        40 - 59% = 6820 
        60 - 79% = 3868 
        80 - 99% = 407 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21139469 
    Average version length: 82.97, total versions: 2488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318824 
    Data pages: 318824, average fill: 81% 
    Primary pages: 318824, secondary pages: 0, swept pages: 14413 
    Empty pages: 67, full pages: 317435 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 67 
    40 - 59% = 237 
    60 - 79% = 28309 
    80 - 99% = 290102 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19788, nodes: 21139469 
    Average node length: 5.72, total dup: 20658470, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280083, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8940 
        60 - 79% = 583 
        80 - 99% = 10259 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17202, nodes: 21139469 
    Average node length: 6.31, total dup: 18577793, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914703, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 841 
        60 - 79% = 294 
        80 - 99% = 16064 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21515, nodes: 21139469 
    Average node length: 6.35, total dup: 18496145, max dup: 27 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574033, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 9099 
        60 - 79% = 616 
        80 - 99% = 11791 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16046, nodes: 21139469 
    Average node length: 5.56, total dup: 21139369, max dup: 230497 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943447, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2777 
        60 - 79% = 397 
        80 - 99% = 12864 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 72.63, total records: 10000557 
    Average version length: 82.62, total versions: 1186229, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.73 
    Pointer pages: 108, data page slots: 175848 
    Data pages: 175824, average fill: 71% 
    Primary pages: 175824, secondary pages: 0, swept pages: 39723 
    Empty pages: 836, full pages: 115753 
    Fill distribution: 
     0 - 19% = 2555 
    20 - 39% = 10125 
    40 - 59% = 27788 
    60 - 79% = 45632 
    80 - 99% = 89724 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11401, nodes: 10000557 
    Average node length: 5.38, total dup: 9691893, max dup: 243 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2154528, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 94 
        40 - 59% = 7046 
        60 - 79% = 4150 
        80 - 99% = 106 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13829, nodes: 10000557 
    Average node length: 6.26, total dup: 8293235, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1479027, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 3714 
        40 - 59% = 4721 
        60 - 79% = 2643 
        80 - 99% = 2600 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12731, nodes: 10000557 
    Average node length: 5.99, total dup: 8703901, max dup: 55 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2365461, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 114 
        40 - 59% = 7976 
        60 - 79% = 4520 
        80 - 99% = 118 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10335, nodes: 10000557 
    Average node length: 5.16, total dup: 10000457, max dup: 154652 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1534934, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1199 
        40 - 59% = 5110 
        60 - 79% = 1676 
        80 - 99% = 2308 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 75.96, total records: 11362881 
    Average version length: 82.54, total versions: 873736, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 119, data page slots: 192704 
    Data pages: 191568, average fill: 73% 
    Primary pages: 191568, secondary pages: 0, swept pages: 55786 
    Empty pages: 3387, full pages: 144998 
    Fill distribution: 
     0 - 19% = 5784 
    20 - 39% = 7648 
    40 - 59% = 16699 
    60 - 79% = 38250 
    80 - 99% = 123187 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13119, nodes: 11362881 
    Average node length: 5.31, total dup: 11253385, max dup: 631 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2357476, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 90 
        40 - 59% = 8959 
        60 - 79% = 3939 
        80 - 99% = 130 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10433, nodes: 11362881 
    Average node length: 5.51, total dup: 10867587, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 701039, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 781 
        40 - 59% = 2576 
        60 - 79% = 1842 
        80 - 99% = 5100 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15004, nodes: 11362881 
    Average node length: 6.03, total dup: 9922377, max dup: 76 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2374023, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 130 
        40 - 59% = 10466 
        60 - 79% = 4243 
        80 - 99% = 161 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10797, nodes: 11362881 
    Average node length: 5.23, total dup: 11362781, max dup: 186571 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 690368, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 77 
        20 - 39% = 817 
        40 - 59% = 4805 
        60 - 79% = 1510 
        80 - 99% = 3588 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 73.12, total records: 10099430 
    Average version length: 82.92, total versions: 1173561, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.72 
    Pointer pages: 110, data page slots: 179496 
    Data pages: 179456, average fill: 71% 
    Primary pages: 179456, secondary pages: 0, swept pages: 42600 
    Empty pages: 712, full pages: 113709 
    Fill distribution: 
     0 - 19% = 2387 
    20 - 39% = 10477 
    40 - 59% = 30522 
    60 - 79% = 49624 
    80 - 99% = 86446 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12073, nodes: 10099430 
    Average node length: 5.20, total dup: 10070028, max dup: 2139 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1998533, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1404 
        40 - 59% = 7886 
        60 - 79% = 2123 
        80 - 99% = 629 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13938, nodes: 10099430 
    Average node length: 6.27, total dup: 8373888, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1443766, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 186 
        20 - 39% = 3725 
        40 - 59% = 4663 
        60 - 79% = 2624 
        80 - 99% = 2740 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12664, nodes: 10099430 
    Average node length: 5.46, total dup: 9655378, max dup: 110 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2133683, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1302 
        40 - 59% = 8834 
        60 - 79% = 1892 
        80 - 99% = 615 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10509, nodes: 10099430 
    Average node length: 5.18, total dup: 10099330, max dup: 154603 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1552263, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1202 
        40 - 59% = 5291 
        60 - 79% = 1702 
        80 - 99% = 2269 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.10, total records: 578452 
    Average version length: 68.80, total versions: 17462, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8064, secondary pages: 0, swept pages: 2643 
    Empty pages: 1, full pages: 6791 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 34 
    40 - 59% = 319 
    60 - 79% = 7389 
    80 - 99% = 317 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 47195, depth: 3, leaf buckets: 743, nodes: 578452 
    Average node length: 5.95, total dup: 492567, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100282, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 524 
        60 - 79% = 104 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 38388, depth: 3, leaf buckets: 756, nodes: 578452 
    Average node length: 6.15, total dup: 474370, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100343, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 525 
        60 - 79% = 99 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 560, nodes: 578452 
    Average node length: 4.86, total dup: 578352, max dup: 9876 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89106, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 309 
        60 - 79% = 93 
        80 - 99% = 133 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Mar 16 16:16:20 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7633557 49003 1 0.0000 0.0000
DOC_LIST 2182675 58640 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238208 621 59500.0000 0.0000
INVNT_TURNOVER_LOG 80431 75640 1 0.0000 0.0000
MONEY_SALDO 49 18899 991 38500.0000 0.0000
MONEY_TURNOVER_LOG 1237 1153 1 0.0000 0.0000
PDISTR 839316 27772 5 0.0000 0.0000
PERF_SPLIT_0 170802 1293 1 0.0000 0.0000
PERF_SPLIT_1 170227 4353 1 0.0000 0.0000
PERF_SPLIT_2 183737 1598 1 0.0000 0.0000
PERF_SPLIT_3 182729 608 1 0.0000 0.0000
PERF_SPLIT_4 174484 2576 1 0.0000 0.0000
PERF_SPLIT_5 171388 2240 1 0.0000 0.0000
PERF_SPLIT_6 162280 1794 1 0.0000 0.0000
PERF_SPLIT_7 205237 15932 1 0.0000 0.0000
PERF_SPLIT_8 220721 50579 1 0.0000 0.0000
PERF_SPLIT_9 180973 1400 1 0.0000 0.0000
PSTORNED 2036247 23498 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 114685 24561 1 0.0000 0.0000
XQD_1000_3300 7236413 123111 1 0.0000 0.0000
XQD_1200_2000 12352723 128223 1 0.0000 0.0000
XQD_2000_3300 1223086 307304 1 0.0000 0.0000
XQD_2100_3300 842869 195375 1 0.0000 0.0000
XQD_3300_3400 8535682 170803 1 0.0000 0.0000
XQS_1000_1200 21139469 2488 1 0.0000 0.0000
XQS_1000_3300 10000557 1186229 1 0.0000 0.0000
XQS_1200_2000 11362881 873736 1 0.0000 0.0000
XQS_2100_3300 10099430 1173561 1 0.0000 0.0000
XQS_3300_3400 578452 17462 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Mar 16 16:14:17 2024
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

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