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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-27 10:07:49
DTS_END                         2024-02-27 10:07:49.7860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/45900
TRN_ID                          171155
ATT_ID                          512
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: 9086.71 22395 908671
customer order: creation 174.08 461 17408
customer order: refuse 15.21 400 1521
order to supplier: creation 45.75 1268 4575
order to supplier: removal 3.41 80882 341
invoice (draft): creation 46.45 3245 4645
invoice (draft): removal 46.76 662 4676
invoice accept: apply 43.02 21397 4302
invoice accept: cancel 43.08 894 4308
customer reserve: creation 4110.09 208 411009
customer reserve: removal 4267.32 53 426732
realization accept: apply 84.47 222 8447
realization accept: cancel 78.34 139 7834
payment from customer: creation 59.22 133 5922
payment from customer: removal 6.01 81 601
payment to supplier: creation 48.68 142 4868
payment to supplier: removal 3.69 111 369
service: total inventory turnovers 3.90 3801 390
service: total monetary turnovers 6.30 458 630
service: aggregate perf. data 0.90 16779 90
service: refresh index statistics 0.03 316554 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-02-2024 10:08:58 to 27-02-2024 10:09:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3272
TEST_TIME 2 3372
TEST_TIME 3 5822
TEST_TIME 4 4771
TEST_TIME 5 4473
TEST_TIME 6 4568
TEST_TIME 7 4824
TEST_TIME 8 4893
TEST_TIME 9 4960
TEST_TIME 10 4786
TEST_TIME 11 4800
TEST_TIME 12 5184
TEST_TIME 13 5426
TEST_TIME 14 5807
TEST_TIME 15 6549
TEST_TIME 16 6768
TEST_TIME 17 6828
TEST_TIME 18 6983
TEST_TIME 19 7327
TEST_TIME 20 7541
TEST_TIME 21 7707
TEST_TIME 22 8130
TEST_TIME 23 8634
TEST_TIME 24 9096
TEST_TIME 25 9262
TEST_TIME 26 9043
TEST_TIME 27 8778
TEST_TIME 28 8697
TEST_TIME 29 8561
TEST_TIME 30 8487
TEST_TIME 31 8554
TEST_TIME 32 8693
TEST_TIME 33 8790
TEST_TIME 34 8730
TEST_TIME 35 8690
TEST_TIME 36 8645
TEST_TIME 37 8519
TEST_TIME 38 8500
TEST_TIME 39 8779
TEST_TIME 40 8735
TEST_TIME 41 8724
TEST_TIME 42 8851
TEST_TIME 43 8809
TEST_TIME 44 8977
TEST_TIME 45 8962
TEST_TIME 46 9236
TEST_TIME 47 9218
TEST_TIME 48 9321
TEST_TIME 49 9471
TEST_TIME 50 9370
TEST_TIME 51 9428
TEST_TIME 52 9283
TEST_TIME 53 9177
TEST_TIME 54 9150
TEST_TIME 55 9120
TEST_TIME 56 9121
TEST_TIME 57 9067
TEST_TIME 58 8990
TEST_TIME 59 8936
TEST_TIME 60 9070
TEST_TIME 61 9124
TEST_TIME 62 9114
TEST_TIME 63 9156
TEST_TIME 64 9119
TEST_TIME 65 9149
TEST_TIME 66 9195
TEST_TIME 67 9254
TEST_TIME 68 9277
TEST_TIME 69 9352
TEST_TIME 70 9371
TEST_TIME 71 9252
TEST_TIME 72 9211
TEST_TIME 73 9153
TEST_TIME 74 9123
TEST_TIME 75 9097
TEST_TIME 76 9117
TEST_TIME 77 9099
TEST_TIME 78 9125
TEST_TIME 79 9170
TEST_TIME 80 9174
TEST_TIME 81 9130
TEST_TIME 82 9193
TEST_TIME 83 9189
TEST_TIME 84 9265
TEST_TIME 85 9238
TEST_TIME 86 9284
TEST_TIME 87 9351
TEST_TIME 88 9407
TEST_TIME 89 9333
TEST_TIME 90 9241
TEST_TIME 91 9194
TEST_TIME 92 9197
TEST_TIME 93 9176
TEST_TIME 94 9115
TEST_TIME 95 9051
TEST_TIME 96 9085
TEST_TIME 97 9099
TEST_TIME 98 9093
TEST_TIME 99 9080
TEST_TIME 100 9095

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-02-2024 10:09:01 to 27-02-2024 10:09:05.

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 1284044 1284044 0 0.00 0 20883 7 0 0
doc_list_biud 1284043 1284043 0 0.00 0 27391 23 0 0
sp_add_invoice_to_stock 4415 4302 113 2.55 37 204178 21397 0 113
sp_cancel_adding_invoice 4308 4308 0 0.00 4 90554 894 0 0
sp_cancel_client_order 1521 1521 0 0.00 4 14080 400 0 0
sp_cancel_customer_reserve 426732 426732 0 0.00 0 20651 53 0 0
sp_cancel_pay_from_customer 601 601 0 0.00 2 3154 82 0 0
sp_cancel_pay_to_supplier 369 369 0 0.00 3 11408 112 0 0
sp_cancel_supplier_invoice 4680 4676 4 0.08 1 14023 663 0 4
sp_cancel_supplier_order 341 341 0 0.00 10 742699 80882 0 0
sp_cancel_write_off 7834 7834 0 0.00 1 10892 140 0 0
sp_client_order 17408 17408 0 0.00 3 27637 462 0 0
sp_customer_reserve 411009 411009 0 0.00 0 43688 208 0 0
sp_fill_shopping_cart 26619 26619 0 0.00 1 8453 36 0 0
sp_fill_shopping_cart_clo_res 410993 410993 0 0.00 0 26286 18 0 0
sp_get_clo_for_invoice 4285 4285 0 0.00 0 36752 362 0 0
sp_kill_cost_storno 13112 13112 0 0.00 0 10490 62 0 0
sp_kill_qstorno_ret_qs2qd 866315 866315 0 0.00 0 20647 29 0 0
sp_kill_qty_storno 458143 458143 0 0.00 0 27391 62 0 0
sp_lock_selected_doc 17733 17733 0 0.00 0 9381 6 0 0
sp_make_cost_storno 23522 23522 0 0.00 0 12932 67 0 0
sp_multiply_rows_for_pdistr 23521 23521 0 0.00 0 8786 39 0 0
sp_multiply_rows_for_qdistr 17408 17408 0 0.00 0 15159 244 0 0
sp_pay_from_customer 5922 5922 0 0.00 3 10270 133 0 0
sp_pay_to_supplier 4868 4868 0 0.00 4 11270 142 0 0
sp_payment_common 10790 10790 0 0.00 1 6413 22 0 0
sp_qd_handle_on_cancel_clo 1521 1521 0 0.00 0 14071 368 0 0
sp_qd_handle_on_invoice_upd_sts 8592 8592 0 0.00 0 24496 268 0 0
sp_qd_handle_on_reserve_upd_sts 8447 8447 0 0.00 0 27389 68 0 0
sp_reserve_write_off 8447 8447 0 0.00 6 27438 223 0 0
sp_supplier_invoice 4645 4645 0 0.00 4 86716 3245 0 0
sp_supplier_order 4575 4575 0 0.00 4 30077 1269 0 0
srv_aggregate_perf_data 90 90 0 0.00 1557 306227 16779 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 2422 128673 41959 0 0
srv_find_qd_qs_mism 865219 865219 0 0.00 0 20882 7 0 0
srv_make_invnt_saldo 390 390 0 0.00 70 86603 3802 0 0
srv_make_money_saldo 630 630 0 0.00 0 13587 459 0 0
srv_recalc_idx_stat 3 3 0 0.00 170692 481222 316555 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4304 4304 0 0.00 0 17835 162 0 0
t$perf-norm:sp_cancel_adding_invoice 388 388 0 0.00 0 4542 96 0 0
t$perf-norm:sp_cancel_client_order 1521 1521 0 0.00 0 4092 15 0 0
t$perf-norm:sp_cancel_customer_reserve 614 614 0 0.00 0 1181 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 601 601 0 0.00 0 7195 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 369 369 0 0.00 0 625 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 329 329 0 0.00 0 2518 24 0 0
t$perf-norm:sp_cancel_supplier_order 341 341 0 0.00 0 25005 1606 0 0
t$perf-norm:sp_cancel_write_off 840 840 0 0.00 0 2610 8 0 0
t$perf-norm:sp_client_order 17408 17408 0 0.00 0 6525 14 0 0
t$perf-norm:sp_customer_reserve 893 893 0 0.00 0 8578 18 0 0
t$perf-norm:sp_pay_from_customer 5922 5922 0 0.00 0 8510 10 0 0
t$perf-norm:sp_pay_to_supplier 4868 4868 0 0.00 0 2611 10 0 0
t$perf-norm:sp_reserve_write_off 8447 8447 0 0.00 0 9131 11 0 0
t$perf-norm:sp_supplier_invoice 4645 4645 0 0.00 0 6655 17 0 0
t$perf-norm:sp_supplier_order 4575 4575 0 0.00 0 3468 13 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 121 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 6 1 0 0
t$perf-norm:srv_make_invnt_saldo 390 390 0 0.00 0 5066 17 0 0
t$perf-norm:srv_make_money_saldo 630 630 0 0.00 0 507 4 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 8792 8566 226 2.57 0 3601 18 0 226
v_all_customers 31990 31990 0 0.00 0 24 1 0 0
v_all_suppliers 25832 25832 0 0.00 0 41 1 0 0
v_all_wares 34814 34814 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 1521 9 0 0
v_cancel_client_order 3042 3042 0 0.00 0 3522 6 0 0
v_cancel_customer_prepayment 1202 1202 0 0.00 0 3123 11 0 0
v_cancel_customer_reserve 1228 1228 0 0.00 0 3166 8 0 0
v_cancel_payment_to_supplier 738 738 0 0.00 0 5943 15 0 0
v_cancel_supplier_invoice 666 658 8 1.20 0 4070 24 0 8
v_cancel_supplier_order 682 682 0 0.00 0 107 2 0 0
v_cancel_write_off 1680 1680 0 0.00 0 2528 15 0 0
v_max_id_clo_ord 4573 4573 0 0.00 0 1011 1 0 0
v_max_id_clo_res 893 893 0 0.00 0 5893 21 0 0
v_max_id_ord_sup 4639 4639 0 0.00 0 6942 7 0 0
v_max_non_paid_invoice 1164 1164 0 0.00 0 2555 4 0 0
v_max_non_paid_realizn 2918 2918 0 0.00 0 1834 3 0 0
v_min_id_clo_ord 4573 4573 0 0.00 0 6312 7 0 0
v_min_id_clo_res 893 893 0 0.00 0 1432 4 0 0
v_min_id_ord_sup 4639 4639 0 0.00 0 4912 7 0 0
v_min_non_paid_invoice 4868 4868 0 0.00 0 3999 12 0 0
v_min_non_paid_realizn 5922 5922 0 0.00 0 6408 18 0 0
v_our_firm 8832 8832 0 0.00 0 46 1 0 0
v_reserve_write_off 16894 16894 0 0.00 0 3636 7 0 0
x_lock_depdocs_on_canc_invoice 8655 8655 0 0.00 0 19582 130 0 0
x_lock_depdocs_on_canc_sup_ord 341 341 0 0.00 0 6188 323 0 0
x_make_qstorno_1000_1200 4575 4575 0 0.00 1 30041 1197 0 0
x_make_qstorno_1200_2000 4645 4645 0 0.00 2 82036 3110 0 0
x_make_qstorno_2100_3300 411009 411009 0 0.00 0 43685 188 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2024 10:09:06 to 27-02-2024 10:09:10.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:53 6 8192000000 8802570432 8815108096 7512160 0.091 3 2 3 0 7679200 105680 61360
08:08:54 41362 8192000000 9731001456 10032676864 804181728 8.939 100 84 168 0 831601136 7467072 19952336
08:10:44 24305 8192000000 9771318016 10079789056 844022912 9.340 100 90 180 0 879024352 13541440 21460000
08:12:12 8661 8192000000 9793905344 10111213568 863081920 9.531 100 86 172 0 908420448 25338352 20000176
08:13:24 13968 8192000000 9854161824 10185617408 907727280 9.975 100 83 166 0 965163056 39215136 18220640
08:14:42 7004 8192000000 9909442736 10252124160 948672384 10.378 100 82 162 0 1019124272 53444240 17007648
08:15:51 3033 8192000000 9949448656 10303205376 982098672 10.705 100 80 158 0 1061196576 63171504 15926400
08:16:56 3390 8192000000 9996873184 10357104640 1010072576 10.976 100 87 175 0 1109353504 81640176 17640752
08:18:01 1870 8192000000 10012421552 10382643200 1033161104 11.199 100 80 158 0 1129659136 80216848 16281184
08:19:06 1011 8192000000 10051393792 10424348672 1056021936 11.418 100 91 180 1 1163898160 88622576 19253648
08:20:08 3223 8192000000 10036477200 10416984064 1064989552 11.504 100 73 142 1 1143780544 63338368 15452624
08:21:12 19384 8192000000 9968802768 10360770560 1075115056 11.601 100 26 53 0 1102344352 22020640 5208656
08:22:33 6101 8192000000 9986967648 10389573632 1085227520 11.697 100 31 63 1 1110104768 18203744 6673504
08:23:40 3247 8192000000 10003148880 10408165376 1086789376 11.712 100 41 82 1 1123970544 28126096 9055072
08:24:45 7823 8192000000 9996305824 10408677376 1091543632 11.757 100 31 63 0 1121016688 22697984 6775072
08:25:53 42007 8192000000 10009637072 10412040192 1092396832 11.765 100 46 88 0 1116675328 14843168 9435328
08:27:39 5963 8192000000 10010088752 10416967680 1096233024 11.802 100 27 49 3 1120628352 19943408 4451920
08:28:50 40776 8192000000 10056494896 10456862720 1088229968 11.726 99 54 108 1 1146986048 47337648 11418432
08:30:33 11561 8192000000 10031617392 10441138176 1089132704 11.734 98 47 93 2 1154409616 55885104 9391808
08:31:50 33703 8192000000 10050266896 10463481856 1108824176 11.921 100 53 106 0 1164177680 44329072 11024432
08:33:31 20910 8192000000 10083204912 10496319488 1112645824 11.957 99 35 68 0 1191050144 70941968 7462352
08:35:13 8200 8192000000 10107803648 10517614592 1145289872 12.265 100 43 85 0 1216946960 62004320 9652768
08:36:23 36005 8192000000 10152294000 10564530176 1128848272 12.111 99 51 97 1 1261305584 122132624 10324688
08:38:02 40214 8192000000 10174531456 10607013888 1105235360 11.887 97 27 54 0 1262624320 151266256 6122704
08:40:05 7207 8192000000 10181733024 10583298048 1104052256 11.876 99 47 94 2 1282675264 167433312 11189696
08:41:22 7570 8192000000 10160725648 10556805120 1086984928 11.714 99 67 128 1 1263551808 161269648 15297232
08:42:39 3207 8192000000 10149879456 10540023808 1107108128 11.905 100 77 151 1 1254222864 130433504 16681232
08:43:48 5984 8192000000 10159910000 10549673984 1073435760 11.585 97 62 124 0 1248143168 161458768 13248640
08:45:03 7124 8192000000 10203925824 10617200640 1102389840 11.860 99 52 104 0 1302588144 188689248 11509056
08:46:15 4258 8192000000 10234005088 10639794176 1118852960 12.016 99 66 132 1 1344871872 211994496 14024416
08:47:23 2422 8192000000 10221373552 10625765376 1130531744 12.126 100 62 122 1 1325567712 180857408 14178560
08:48:29 6586 8192000000 10226544896 10641002496 1134646768 12.165 100 49 98 0 1329792320 184548176 10597376
08:49:41 11748 8192000000 10160337120 10597187584 1115124880 11.981 100 24 48 0 1274931040 154007504 5798656
08:51:03 51564 8192000000 10048917648 10550878208 1087064656 11.715 98 7 14 0 1201303344 112712432 1526256
08:52:58 43885 8192000000 10039241792 10451542016 1110451936 11.937 100 37 73 0 1141416352 22850512 8113904
08:54:42 42999 8192000000 10054500336 10488131584 1115729712 11.987 100 24 47 0 1155791552 35491488 4570352
08:56:27 31011 8192000000 10079903584 10509709312 1128287856 12.105 100 24 48 0 1175844160 42687440 4868864
08:58:10 37019 8192000000 10159053616 10584109056 1132465104 12.145 100 39 75 3 1237579680 96271680 8842896
08:59:56 39512 8192000000 10077600128 10557325312 1134369600 12.163 100 18 36 0 1204426624 66053152 4003872
09:01:37 34284 8192000000 10112273680 10559733760 1149549952 12.305 100 25 51 0 1211631168 56542464 5538752
09:03:15 54631 8192000000 10139605840 10577965056 1159446528 12.398 100 32 64 1 1245468384 78988096 7033760
09:05:11 59718 8192000000 10156329888 10644545536 1157097264 12.376 100 15 28 0 1287149216 126776992 3274960
09:07:43 41928 8192000000 10105947840 10561220608 1167027600 12.469 100 25 50 0 1215838816 44389104 4422112
09:09:29 35333 8192000000 10114240752 10553131008 1143449472 12.248 98 31 61 1 1219177344 69521408 6206464
09:11:09 16704 8192000000 10184822320 10633592832 1175310128 12.546 100 39 78 0 1279816944 96421296 8085520
09:12:26 47153 8192000000 10137074448 10627657728 1151070688 12.320 98 27 54 0 1223769440 67164224 5534528
09:14:15 30195 8192000000 10151384464 10589270016 1130810128 12.129 97 35 70 3 1180654416 42414064 7430224
09:15:50 49044 8192000000 10093549952 10595688448 1125304400 12.077 98 8 16 0 1183248784 56558544 1385840
09:17:40 15210 8192000000 10119215568 10534957056 1134482928 12.164 99 43 82 1 1185698640 43186992 8028720
09:18:56 77176 8192000000 10086278032 10516553728 1116578000 11.995 97 36 72 0 1162443456 37994512 7870944
09:21:37 13418 8192000000 10072111936 10508705792 1113889664 11.969 99 45 88 1 1174785648 51920016 8975968
09:22:59 55931 8192000000 10071627984 10547048448 1079568000 11.643 96 15 30 0 1168414224 85370016 3476208
09:25:19 52144 8192000000 10077014208 10509590528 1054203536 11.401 94 21 42 0 1130740688 71669712 4867440
09:27:46 93281 8192000000 10040834432 10493632512 1046951728 11.331 94 17 34 0 1097506752 46724880 3830144
09:30:23 48983 8192000000 10028703808 10465050624 1060464048 11.461 96 23 44 1 1102933056 37496160 4972848
09:32:13 45456 8192000000 10064989904 10507001856 1107042192 11.904 100 24 48 0 1168462336 56449840 4970304
09:34:07 56213 8192000000 10043920496 10503290880 1063904400 11.494 96 32 64 0 1110863008 40576080 6382528
09:36:03 100479 8192000000 10056438480 10544922624 1092520720 11.767 99 17 34 0 1142688864 46670896 3497248
09:38:47 72380 8192000000 10046090320 10483867648 1111025664 11.942 100 33 66 1 1157535792 40082928 6427200
09:41:00 43924 8192000000 10074848992 10519252992 1122904608 12.054 99 25 50 0 1189451040 61576512 4969920
09:42:54 48767 8192000000 10110552848 10567827456 1138698912 12.203 100 22 44 0 1185681296 41671952 5310432
09:44:51 59737 8192000000 10080465184 10541580288 1126012880 12.084 99 20 41 0 1178078720 47601264 4464576
09:46:52 53998 8192000000 10076338144 10527805440 1144567904 12.258 100 24 48 0 1179533296 30191984 4773408
09:48:50 62229 8192000000 10090529664 10535202816 1142823696 12.242 99 46 93 0 1225515424 73210816 9480912
09:50:55 109654 8192000000 10100340864 10565615616 1145177888 12.264 99 21 42 1 1184799888 34827984 4794016
09:53:45 71995 8192000000 10103033776 10553524224 1158642128 12.391 100 18 34 0 1214999984 52984160 3373696
09:56:17 128672 8192000000 10070769184 10504974336 1140038912 12.216 99 26 52 1 1180359552 35057760 5262880
09:59:26 46276 8192000000 10077106768 10527494144 1133949920 12.159 99 13 26 0 1166055552 29224432 2881200
10:01:13 35465 8192000000 10092058752 10556637184 1152050368 12.329 100 9 18 0 1199275808 45146944 2078496
10:02:50 57752 8192000000 10107574928 10588733440 1144026704 12.253 100 17 34 0 1206204608 58664416 3513488
10:06:25 54154 8192000000 10102972128 10561937408 1107266880 11.907 96 33 67 0 1157232512 42927888 7037744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-02-2024 10:09:26 to 27-02-2024 10:09:28.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Feb 27 10:09:29 2024 
 
Database header page information: 
    Flags            0 
    Generation        89368 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    169486 
    Oldest active        171285 
    Oldest snapshot        171285 
    Next transaction    171286 
    Sequence number        0 
    Next attachment ID    684 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.49, total records: 7753101 
    Average version length: 48.16, total versions: 79857, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 89248 
    Data pages: 89248, average fill: 69% 
    Primary pages: 89248, secondary pages: 0, swept pages: 38287 
    Empty pages: 6, full pages: 68692 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 51 
    40 - 59% = 2299 
    60 - 79% = 86828 
    80 - 99% = 61 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23217, nodes: 7753101 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1677370, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 332 
        20 - 39% = 1921 
        40 - 59% = 3923 
        60 - 79% = 2265 
        80 - 99% = 14776 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13473, nodes: 7753101 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1502300, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1619 
        40 - 59% = 1929 
        60 - 79% = 1066 
        80 - 99% = 8859 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8312, nodes: 7753101 
    Average node length: 6.62, total dup: 5792791, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1495463, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 999 
        40 - 59% = 1282 
        60 - 79% = 886 
        80 - 99% = 5010 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.51, total records: 2251041 
    Average version length: 58.84, total versions: 43445, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28736 
    Data pages: 28736, average fill: 72% 
    Primary pages: 28735, secondary pages: 1, swept pages: 10083 
    Empty pages: 6, full pages: 20345 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 28 
    40 - 59% = 426 
    60 - 79% = 28199 
    80 - 99% = 72 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4539, nodes: 2251041 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 688596, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 928 
        40 - 59% = 797 
        60 - 79% = 691 
        80 - 99% = 2123 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2452, nodes: 2252163 
    Average node length: 4.97, total dup: 2251264, max dup: 18864 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1262686, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 219 
        40 - 59% = 1414 
        60 - 79% = 586 
        80 - 99% = 229 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1794, nodes: 2251041 
    Average node length: 4.97, total dup: 2250991, max dup: 130243 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1069079, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 7 
        40 - 59% = 651 
        60 - 79% = 43 
        80 - 99% = 1091 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4387, nodes: 2251041 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 688596, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 138 
        20 - 39% = 605 
        40 - 59% = 600 
        60 - 79% = 775 
        80 - 99% = 2269 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.31, total records: 400 
    Average version length: 25.83, total versions: 2619, max versions: 7 
    Average fragment length: 2.00, total fragments: 6, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 78% 
    Primary pages: 8, secondary pages: 16, swept pages: 0 
    Empty pages: 2, full pages: 19 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 19 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 24.02, total records: 51367 
    Average version length: 68.27, total versions: 38354, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.66 
    Pointer pages: 5, data page slots: 2296 
    Data pages: 1088, average fill: 61% 
    Primary pages: 1087, secondary pages: 1, swept pages: 0 
    Empty pages: 173, full pages: 587 
    Fill distribution: 
     0 - 19% = 228 
    20 - 39% = 59 
    40 - 59% = 120 
    60 - 79% = 218 
    80 - 99% = 463 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700152, depth: 3, leaf buckets: 178, nodes: 51367 
    Average node length: 13.55, total dup: 3322, max dup: 2 
    Average key length: 10.77, compression ratio: 2.51 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 38276, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 97 
        60 - 79% = 40 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 142, max versions: 4 
    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: 1 
    Data pages: 1, average fill: 66% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.92, total records: 1070 
    Average version length: 43.16, total versions: 953, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.49 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 36% 
    Primary pages: 31, secondary pages: 1, swept pages: 4 
    Empty pages: 10, full pages: 6 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93686, depth: 2, leaf buckets: 2, nodes: 1070 
    Average node length: 4.49, total dup: 974, max dup: 122 
    Average key length: 2.97, compression ratio: 6.41 
    Average prefix length: 18.12, average data length: 0.88 
    Clustering factor: 602, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.61, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.31, total records: 792872 
    Average version length: 37.93, total versions: 28712, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8368 
    Data pages: 8368, average fill: 65% 
    Primary pages: 8367, secondary pages: 1, swept pages: 1921 
    Empty pages: 25, full pages: 6474 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 83 
    40 - 59% = 594 
    60 - 79% = 7580 
    80 - 99% = 57 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 845, nodes: 778587 
    Average node length: 4.88, total dup: 778538, max dup: 134777 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90228, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 133 
        40 - 59% = 461 
        60 - 79% = 152 
        80 - 99% = 98 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 906, nodes: 778587 
    Average node length: 5.89, total dup: 692811, max dup: 49 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157611, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 471 
        60 - 79% = 129 
        80 - 99% = 265 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 931, nodes: 778587 
    Average node length: 5.89, total dup: 692811, max dup: 49 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159391, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 101 
        40 - 59% = 446 
        60 - 79% = 131 
        80 - 99% = 253 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1085, nodes: 778587 
    Average node length: 5.97, total dup: 692811, max dup: 49 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 152344, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 213 
        40 - 59% = 578 
        60 - 79% = 198 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.72, total records: 5439 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.53, total fragments: 30, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 75, secondary pages: 13, swept pages: 62 
    Empty pages: 6, full pages: 62 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5439 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.06 
    Average prefix length: 34.38, average data length: 1.54 
    Clustering factor: 5176, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5439 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 163, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 77612 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 806 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 806 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37514, depth: 2, leaf buckets: 98, nodes: 77612 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3167, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.51, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 124.13, total records: 199519 
    Average version length: 154.46, total versions: 38107, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.66 
    Pointer pages: 6, data page slots: 6608 
    Data pages: 5088, average fill: 83% 
    Primary pages: 5085, secondary pages: 3, swept pages: 2 
    Empty pages: 150, full pages: 4896 
    Fill distribution: 
     0 - 19% = 153 
    20 - 39% = 9 
    40 - 59% = 18 
    60 - 79% = 11 
    80 - 99% = 4897 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 143.59, total records: 144735 
    Average version length: 151.50, total versions: 7610, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.81 
    Pointer pages: 7, data page slots: 6448 
    Data pages: 3680, average fill: 82% 
    Primary pages: 3677, secondary pages: 3, swept pages: 1 
    Empty pages: 107, full pages: 3539 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 15 
    40 - 59% = 8 
    60 - 79% = 8 
    80 - 99% = 3539 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.56, total records: 155012 
    Average version length: 150.87, total versions: 7006, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 5, data page slots: 5528 
    Data pages: 3880, average fill: 83% 
    Primary pages: 3877, secondary pages: 3, swept pages: 2 
    Empty pages: 60, full pages: 3785 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 8 
    40 - 59% = 12 
    60 - 79% = 13 
    80 - 99% = 3785 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 145.69, total records: 161847 
    Average version length: 150.70, total versions: 6117, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 6, data page slots: 4792 
    Data pages: 4048, average fill: 83% 
    Primary pages: 4046, secondary pages: 2, swept pages: 5 
    Empty pages: 64, full pages: 3955 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 5 
    40 - 59% = 13 
    60 - 79% = 9 
    80 - 99% = 3954 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 138.63, total records: 167368 
    Average version length: 152.96, total versions: 14746, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.23 
    Pointer pages: 5, data page slots: 4912 
    Data pages: 4176, average fill: 84% 
    Primary pages: 4174, secondary pages: 2, swept pages: 2 
    Empty pages: 53, full pages: 4105 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4105 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 144.82, total records: 155343 
    Average version length: 150.95, total versions: 6812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 7, data page slots: 8712 
    Data pages: 3912, average fill: 82% 
    Primary pages: 3909, secondary pages: 3, swept pages: 5 
    Empty pages: 79, full pages: 3788 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 10 
    40 - 59% = 12 
    60 - 79% = 20 
    80 - 99% = 3788 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 144.98, total records: 151097 
    Average version length: 150.74, total versions: 6209, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 5, data page slots: 6456 
    Data pages: 3840, average fill: 81% 
    Primary pages: 3838, secondary pages: 2, swept pages: 3 
    Empty pages: 116, full pages: 3692 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 13 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3691 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 136.13, total records: 155328 
    Average version length: 154.15, total versions: 15909, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.46 
    Pointer pages: 5, data page slots: 6200 
    Data pages: 3960, average fill: 82% 
    Primary pages: 3956, secondary pages: 4, swept pages: 5 
    Empty pages: 123, full pages: 3790 
    Fill distribution: 
     0 - 19% = 129 
    20 - 39% = 17 
    40 - 59% = 14 
    60 - 79% = 12 
    80 - 99% = 3788 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 130.04, total records: 195578 
    Average version length: 154.22, total versions: 29083, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.04 
    Pointer pages: 6, data page slots: 6960 
    Data pages: 4920, average fill: 84% 
    Primary pages: 4917, secondary pages: 3, swept pages: 4 
    Empty pages: 85, full pages: 4789 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 9 
    40 - 59% = 21 
    60 - 79% = 13 
    80 - 99% = 4789 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 144.66, total records: 168997 
    Average version length: 151.35, total versions: 7919, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 6, data page slots: 6192 
    Data pages: 4264, average fill: 82% 
    Primary pages: 4262, secondary pages: 2, swept pages: 5 
    Empty pages: 95, full pages: 4139 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 11 
    80 - 99% = 4141 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.19, total records: 2103043 
    Average version length: 53.04, total versions: 27073, 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: 25672 
    Data pages: 25672, average fill: 70% 
    Primary pages: 25662, secondary pages: 10, swept pages: 11282 
    Empty pages: 81, full pages: 22445 
    Fill distribution: 
     0 - 19% = 218 
    20 - 39% = 235 
    40 - 59% = 744 
    60 - 79% = 24203 
    80 - 99% = 272 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2586, nodes: 2103043 
    Average node length: 5.44, total dup: 1963127, max dup: 1637 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182572, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 283 
        40 - 59% = 1700 
        60 - 79% = 309 
        80 - 99% = 289 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2761, nodes: 2103043 
    Average node length: 5.69, total dup: 1887814, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375900, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2428 
        60 - 79% = 304 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2121, nodes: 2103043 
    Average node length: 4.96, total dup: 2102943, max dup: 28348 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179968, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 219 
        40 - 59% = 1060 
        60 - 79% = 411 
        80 - 99% = 427 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 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: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 44.41, total records: 137605 
    Average version length: 69.17, total versions: 56704, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.84 
    Pointer pages: 3, data page slots: 3576 
    Data pages: 2816, average fill: 59% 
    Primary pages: 2816, secondary pages: 0, swept pages: 283 
    Empty pages: 323, full pages: 1680 
    Fill distribution: 
     0 - 19% = 529 
    20 - 39% = 275 
    40 - 59% = 211 
    60 - 79% = 826 
    80 - 99% = 975 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104430, depth: 3, leaf buckets: 224, nodes: 137605 
    Average node length: 6.42, total dup: 119657, max dup: 23 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24604, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 58 
        40 - 59% = 117 
        60 - 79% = 47 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.19, total records: 6941931 
    Average version length: 68.77, total versions: 320428, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 65, data page slots: 105616 
    Data pages: 105616, average fill: 71% 
    Primary pages: 105614, secondary pages: 2, swept pages: 25062 
    Empty pages: 18, full pages: 69363 
    Fill distribution: 
     0 - 19% = 159 
    20 - 39% = 1272 
    40 - 59% = 9597 
    60 - 79% = 93805 
    80 - 99% = 783 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10627, nodes: 6941931 
    Average node length: 6.51, total dup: 6003016, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1626364, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1572 
        40 - 59% = 6137 
        60 - 79% = 2533 
        80 - 99% = 380 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8331, nodes: 6941931 
    Average node length: 5.40, total dup: 6664614, max dup: 142 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1438920, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1075 
        40 - 59% = 4717 
        60 - 79% = 1558 
        80 - 99% = 978 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8371, nodes: 6941931 
    Average node length: 5.40, total dup: 6664614, max dup: 142 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1441254, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1162 
        40 - 59% = 4616 
        60 - 79% = 1584 
        80 - 99% = 1007 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.54, total records: 12020447 
    Average version length: 68.71, total versions: 280289, 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: 107, data page slots: 173896 
    Data pages: 173896, average fill: 73% 
    Primary pages: 173894, secondary pages: 2, swept pages: 64978 
    Empty pages: 5, full pages: 156213 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 674 
    40 - 59% = 4572 
    60 - 79% = 167000 
    80 - 99% = 1586 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18271, nodes: 12018133 
    Average node length: 6.60, total dup: 10478569, max dup: 61 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2474523, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2050 
        40 - 59% = 10946 
        60 - 79% = 4379 
        80 - 99% = 863 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 48.10, total records: 1424500 
    Average version length: 69.09, total versions: 292655, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.62 
    Pointer pages: 22, data page slots: 35632 
    Data pages: 25702, average fill: 57% 
    Primary pages: 25626, secondary pages: 76, swept pages: 6105 
    Empty pages: 2521, full pages: 17714 
    Fill distribution: 
     0 - 19% = 4040 
    20 - 39% = 3429 
    40 - 59% = 2320 
    60 - 79% = 12062 
    80 - 99% = 3851 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1657, nodes: 1218681 
    Average node length: 5.52, total dup: 1169391, max dup: 49 
    Average key length: 2.57, compression ratio: 16.32 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 83394, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 421 
        40 - 59% = 777 
        60 - 79% = 396 
        80 - 99% = 57 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.57, total records: 1219635 
    Average version length: 69.05, total versions: 120621, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 18, data page slots: 28352 
    Data pages: 25760, average fill: 40% 
    Primary pages: 25760, secondary pages: 0, swept pages: 4798 
    Empty pages: 3805, full pages: 11087 
    Fill distribution: 
     0 - 19% = 7109 
    20 - 39% = 4874 
    40 - 59% = 6219 
    60 - 79% = 7327 
    80 - 99% = 231 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1184, nodes: 762279 
    Average node length: 5.95, total dup: 701779, max dup: 62 
    Average key length: 3.02, compression ratio: 13.90 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 107176, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 367 
        40 - 59% = 591 
        60 - 79% = 212 
        80 - 99% = 14 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.11, total records: 9245373 
    Average version length: 69.02, total versions: 424909, 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: 87, data page slots: 140800 
    Data pages: 140800, average fill: 70% 
    Primary pages: 140791, secondary pages: 9, swept pages: 43549 
    Empty pages: 234, full pages: 82880 
    Fill distribution: 
     0 - 19% = 578 
    20 - 39% = 1677 
    40 - 59% = 12520 
    60 - 79% = 123158 
    80 - 99% = 2867 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13494, nodes: 9241180 
    Average node length: 6.66, total dup: 7665311, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2108153, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1103 
        40 - 59% = 7141 
        60 - 79% = 4680 
        80 - 99% = 570 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21123076 
    Average version length: 82.94, total versions: 9821, 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: 319328 
    Data pages: 319328, average fill: 81% 
    Primary pages: 319323, secondary pages: 5, swept pages: 12552 
    Empty pages: 34, full pages: 318945 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 28 
    40 - 59% = 64 
    60 - 79% = 48591 
    80 - 99% = 270596 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19257, nodes: 21123076 
    Average node length: 5.72, total dup: 20642650, max dup: 138 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280389, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 7947 
        60 - 79% = 522 
        80 - 99% = 10781 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17155, nodes: 21123076 
    Average node length: 6.31, total dup: 18563067, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916767, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 788 
        60 - 79% = 288 
        80 - 99% = 16077 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20980, nodes: 21123076 
    Average node length: 6.35, total dup: 18481883, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573851, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8112 
        60 - 79% = 549 
        80 - 99% = 12312 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16140, nodes: 21123076 
    Average node length: 5.56, total dup: 21122976, max dup: 229119 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945433, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 3026 
        60 - 79% = 358 
        80 - 99% = 12739 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.49, total records: 9655189 
    Average version length: 82.65, total versions: 384019, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 103, data page slots: 167232 
    Data pages: 167200, average fill: 71% 
    Primary pages: 167185, secondary pages: 15, swept pages: 71644 
    Empty pages: 343, full pages: 98388 
    Fill distribution: 
     0 - 19% = 922 
    20 - 39% = 3438 
    40 - 59% = 17110 
    60 - 79% = 125298 
    80 - 99% = 20432 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11324, nodes: 9655189 
    Average node length: 5.37, total dup: 9347662, max dup: 183 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2205263, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 32 
        40 - 59% = 8285 
        60 - 79% = 2927 
        80 - 99% = 78 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13461, nodes: 9655189 
    Average node length: 6.24, total dup: 8003400, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1559214, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 3873 
        40 - 59% = 4299 
        60 - 79% = 2597 
        80 - 99% = 2535 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12639, nodes: 9655189 
    Average node length: 5.99, total dup: 8377682, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2391352, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 28 
        40 - 59% = 9269 
        60 - 79% = 3221 
        80 - 99% = 118 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10050, nodes: 9655189 
    Average node length: 5.14, total dup: 9655089, max dup: 155551 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1572933, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1278 
        40 - 59% = 4755 
        60 - 79% = 1801 
        80 - 99% = 2171 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.54, total records: 11221509 
    Average version length: 82.59, total versions: 268559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 117, data page slots: 190448 
    Data pages: 189136, average fill: 73% 
    Primary pages: 189051, secondary pages: 85, swept pages: 63247 
    Empty pages: 2404, full pages: 147805 
    Fill distribution: 
     0 - 19% = 4023 
    20 - 39% = 6135 
    40 - 59% = 15329 
    60 - 79% = 97691 
    80 - 99% = 65958 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13113, nodes: 11221509 
    Average node length: 5.30, total dup: 11112064, max dup: 643 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2351482, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 122 
        40 - 59% = 9453 
        60 - 79% = 3408 
        80 - 99% = 127 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10302, nodes: 11221509 
    Average node length: 5.49, total dup: 10731094, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 721537, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 831 
        40 - 59% = 2475 
        60 - 79% = 1796 
        80 - 99% = 5052 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14992, nodes: 11221509 
    Average node length: 6.02, total dup: 9790301, max dup: 80 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2367780, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 164 
        40 - 59% = 10937 
        60 - 79% = 3714 
        80 - 99% = 174 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10628, nodes: 11221509 
    Average node length: 5.22, total dup: 11221409, max dup: 196688 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 709979, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 819 
        40 - 59% = 4614 
        60 - 79% = 1475 
        80 - 99% = 3618 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.10, total records: 9732892 
    Average version length: 82.96, total versions: 347626, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 106, data page slots: 172456 
    Data pages: 172432, average fill: 70% 
    Primary pages: 172414, secondary pages: 18, swept pages: 81313 
    Empty pages: 503, full pages: 94177 
    Fill distribution: 
     0 - 19% = 1542 
    20 - 39% = 5566 
    40 - 59% = 21613 
    60 - 79% = 124037 
    80 - 99% = 19674 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11851, nodes: 9732892 
    Average node length: 5.18, total dup: 9704048, max dup: 1577 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1990463, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1547 
        40 - 59% = 7930 
        60 - 79% = 1762 
        80 - 99% = 586 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13476, nodes: 9732892 
    Average node length: 6.26, total dup: 8067669, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1515031, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 3895 
        40 - 59% = 4162 
        60 - 79% = 2621 
        80 - 99% = 2648 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12490, nodes: 9732892 
    Average node length: 5.44, total dup: 9294802, max dup: 100 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2123784, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1415 
        40 - 59% = 8934 
        60 - 79% = 1555 
        80 - 99% = 551 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10224, nodes: 9732892 
    Average node length: 5.16, total dup: 9732792, max dup: 157097 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1589499, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1331 
        40 - 59% = 4990 
        60 - 79% = 1687 
        80 - 99% = 2172 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.76, total records: 573000 
    Average version length: 68.73, total versions: 4005, 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: 5, data page slots: 8080 
    Data pages: 8080, average fill: 74% 
    Primary pages: 8080, secondary pages: 0, swept pages: 3903 
    Empty pages: 21, full pages: 6726 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 173 
    60 - 79% = 7838 
    80 - 99% = 42 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45008, depth: 3, leaf buckets: 730, nodes: 573000 
    Average node length: 5.95, total dup: 487923, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100662, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 514 
        60 - 79% = 92 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35599, depth: 3, leaf buckets: 753, nodes: 573000 
    Average node length: 6.15, total dup: 469935, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100703, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 526 
        60 - 79% = 91 
        80 - 99% = 103 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 565, nodes: 573000 
    Average node length: 4.86, total dup: 572900, max dup: 9643 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89479, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 331 
        60 - 79% = 62 
        80 - 99% = 133 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Feb 27 10:09:53 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7753101 79857 1 0.0000 0.0000
DOC_LIST 2251041 43445 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2619 7 600.0000 0.0000
INVNT_TURNOVER_LOG 51367 38354 1 0.0000 0.0000
MONEY_SALDO 49 142 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1070 953 1 0.0000 0.0000
PDISTR 792872 28712 3 0.0000 0.0000
PERF_SPLIT_0 199519 38107 1 0.0000 0.0000
PERF_SPLIT_1 144735 7610 1 0.0000 0.0000
PERF_SPLIT_2 155012 7006 1 0.0000 0.0000
PERF_SPLIT_3 161847 6117 1 0.0000 0.0000
PERF_SPLIT_4 167368 14746 1 0.0000 0.0000
PERF_SPLIT_5 155343 6812 1 0.0000 0.0000
PERF_SPLIT_6 151097 6209 1 0.0000 0.0000
PERF_SPLIT_7 155328 15909 1 0.0000 0.0000
PERF_SPLIT_8 195578 29083 1 0.0000 0.0000
PERF_SPLIT_9 168997 7919 1 0.0000 0.0000
PSTORNED 2103043 27073 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 137605 56704 1 0.0000 0.0000
XQD_1000_3300 6941931 320428 1 0.0000 0.0000
XQD_1200_2000 12020447 280289 1 0.0000 0.0000
XQD_2000_3300 1424500 292655 1 0.0000 0.0000
XQD_2100_3300 1219635 120621 1 0.0000 0.0000
XQD_3300_3400 9245373 424909 1 0.0000 0.0000
XQS_1000_1200 21123076 9821 1 0.0000 0.0000
XQS_1000_3300 9655189 384019 1 0.0000 0.0000
XQS_1200_2000 11221509 268559 1 0.0000 0.0000
XQS_2100_3300 9732892 347626 1 0.0000 0.0000
XQS_3300_3400 573000 4005 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 ---
:411: 
:412: mscs-test-161.budzdorov.ru    Tue Feb 27 10:07:54 2024
:413:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:414: 
:415: 
:416: mscs-test-161.budzdorov.ru    Tue Feb 27 10:07:57 2024
:417:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:418: 
:419: 
:420: mscs-test-161.budzdorov.ru    Tue Feb 27 10:07:58 2024
:421:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:422: 
:423: 
:424: mscs-test-161.budzdorov.ru    Tue Feb 27 10:08:00 2024
:425:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:426: 
:427: 
:428: mscs-test-161.budzdorov.ru    Tue Feb 27 10:08:00 2024
:429:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:430: 
--- end of diff output ---

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

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