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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-15 01:09:48
DTS_END                         2024-04-15 01:09:48.2060
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41000
TRN_ID                          166244
ATT_ID                          528
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: 9100.63 25998 910063
customer order: creation 160.07 453 16007
customer order: refuse 14.09 416 1409
order to supplier: creation 43.53 1441 4353
order to supplier: removal 3.70 107232 370
invoice (draft): creation 41.72 3479 4172
invoice (draft): removal 51.94 870 5194
invoice accept: apply 38.83 21399 3883
invoice accept: cancel 47.93 975 4793
customer reserve: creation 3724.36 205 372436
customer reserve: removal 4689.17 67 468917
realization accept: apply 78.34 207 7834
realization accept: cancel 82.81 126 8281
payment from customer: creation 56.45 156 5645
payment from customer: removal 5.40 81 540
payment to supplier: creation 47.23 185 4723
payment to supplier: removal 3.09 102 309
service: total inventory turnovers 4.61 1193 461
service: total monetary turnovers 6.29 94 629
service: aggregate perf. data 1.04 13664 104
service: refresh index statistics 0.03 367611 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-04-2024 01:10:56 to 15-04-2024 01:10:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1688
TEST_TIME 2 3669
TEST_TIME 3 3691
TEST_TIME 4 3717
TEST_TIME 5 4892
TEST_TIME 6 4625
TEST_TIME 7 4558
TEST_TIME 8 4746
TEST_TIME 9 4656
TEST_TIME 10 5108
TEST_TIME 11 5042
TEST_TIME 12 5281
TEST_TIME 13 5540
TEST_TIME 14 5636
TEST_TIME 15 5781
TEST_TIME 16 5882
TEST_TIME 17 6107
TEST_TIME 18 6474
TEST_TIME 19 6450
TEST_TIME 20 6794
TEST_TIME 21 6930
TEST_TIME 22 7383
TEST_TIME 23 7562
TEST_TIME 24 7520
TEST_TIME 25 7710
TEST_TIME 26 8001
TEST_TIME 27 8111
TEST_TIME 28 8108
TEST_TIME 29 8683
TEST_TIME 30 9498
TEST_TIME 31 9562
TEST_TIME 32 9343
TEST_TIME 33 9206
TEST_TIME 34 9243
TEST_TIME 35 9267
TEST_TIME 36 9125
TEST_TIME 37 8953
TEST_TIME 38 8908
TEST_TIME 39 8871
TEST_TIME 40 8936
TEST_TIME 41 8971
TEST_TIME 42 8886
TEST_TIME 43 8842
TEST_TIME 44 8833
TEST_TIME 45 8664
TEST_TIME 46 8641
TEST_TIME 47 8600
TEST_TIME 48 8623
TEST_TIME 49 8701
TEST_TIME 50 8610
TEST_TIME 51 8844
TEST_TIME 52 8819
TEST_TIME 53 8822
TEST_TIME 54 8986
TEST_TIME 55 8946
TEST_TIME 56 8983
TEST_TIME 57 9056
TEST_TIME 58 8960
TEST_TIME 59 9114
TEST_TIME 60 9128
TEST_TIME 61 9078
TEST_TIME 62 9031
TEST_TIME 63 9080
TEST_TIME 64 9037
TEST_TIME 65 8993
TEST_TIME 66 8957
TEST_TIME 67 8979
TEST_TIME 68 8941
TEST_TIME 69 8885
TEST_TIME 70 8947
TEST_TIME 71 8922
TEST_TIME 72 8898
TEST_TIME 73 8962
TEST_TIME 74 8992
TEST_TIME 75 8967
TEST_TIME 76 9022
TEST_TIME 77 9116
TEST_TIME 78 9077
TEST_TIME 79 9124
TEST_TIME 80 9138
TEST_TIME 81 9165
TEST_TIME 82 9191
TEST_TIME 83 9208
TEST_TIME 84 9243
TEST_TIME 85 9343
TEST_TIME 86 9271
TEST_TIME 87 9247
TEST_TIME 88 9186
TEST_TIME 89 9184
TEST_TIME 90 9151
TEST_TIME 91 9192
TEST_TIME 92 9160
TEST_TIME 93 9121
TEST_TIME 94 9106
TEST_TIME 95 9056
TEST_TIME 96 9127
TEST_TIME 97 9120
TEST_TIME 98 9136
TEST_TIME 99 9135
TEST_TIME 100 9105

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-04-2024 01:11:00 to 15-04-2024 01:11:03.

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 1252163 1252163 0 0.00 0 29362 7 0 0
doc_list_biud 1252159 1252159 0 0.00 0 67647 32 0 0
sp_add_invoice_to_stock 3975 3883 92 2.31 18 197115 21400 0 92
sp_cancel_adding_invoice 4793 4793 0 0.00 4 65690 976 0 0
sp_cancel_client_order 1409 1409 0 0.00 4 13519 417 0 0
sp_cancel_customer_reserve 468917 468917 0 0.00 0 26396 68 0 0
sp_cancel_pay_from_customer 540 540 0 0.00 2 6265 81 0 0
sp_cancel_pay_to_supplier 309 309 0 0.00 3 6986 102 0 0
sp_cancel_supplier_invoice 5201 5194 7 0.13 2 67651 871 0 7
sp_cancel_supplier_order 370 370 0 0.00 5 1112765 107232 0 0
sp_cancel_write_off 8281 8281 0 0.00 1 10106 127 0 0
sp_client_order 16007 16007 0 0.00 3 30505 453 0 0
sp_customer_reserve 372436 372436 0 0.00 0 39775 205 0 0
sp_fill_shopping_cart 24527 24527 0 0.00 1 11857 39 0 0
sp_fill_shopping_cart_clo_res 372432 372432 0 0.00 0 12688 17 0 0
sp_get_clo_for_invoice 3878 3878 0 0.00 0 18382 360 0 0
sp_kill_cost_storno 13923 13923 0 0.00 0 8564 67 0 0
sp_kill_qstorno_ret_qs2qd 951679 951679 0 0.00 0 67645 36 0 0
sp_kill_qty_storno 500675 500675 0 0.00 0 67647 79 0 0
sp_lock_selected_doc 16307 16307 0 0.00 0 4402 3 0 0
sp_make_cost_storno 22080 22080 0 0.00 0 29360 80 0 0
sp_multiply_rows_for_pdistr 22080 22080 0 0.00 0 12387 38 0 0
sp_multiply_rows_for_qdistr 16005 16005 0 0.00 0 11599 190 0 0
sp_pay_from_customer 5645 5645 0 0.00 4 17706 157 0 0
sp_pay_to_supplier 4723 4723 0 0.00 5 24237 186 0 0
sp_payment_common 10368 10368 0 0.00 2 23746 38 0 0
sp_qd_handle_on_cancel_clo 1409 1409 0 0.00 0 13512 395 0 0
sp_qd_handle_on_invoice_upd_sts 8670 8670 0 0.00 0 22758 387 0 0
sp_qd_handle_on_reserve_upd_sts 7834 7834 0 0.00 0 10864 68 0 0
sp_reserve_write_off 7834 7834 0 0.00 6 29368 208 0 0
sp_supplier_invoice 4172 4172 0 0.00 7 86594 3479 0 0
sp_supplier_order 4353 4353 0 0.00 5 49684 1441 0 0
srv_aggregate_perf_data 105 104 1 0.95 1939 88647 13664 0 1
srv_fill_mon_cache_memory 56 56 0 0.00 1357 131913 41469 0 0
srv_find_qd_qs_mism 870814 870814 0 0.00 0 26395 6 0 0
srv_make_invnt_saldo 461 461 0 0.00 45 36196 1193 0 0
srv_make_money_saldo 629 629 0 0.00 1 21678 94 0 0
srv_recalc_idx_stat 3 3 0 0.00 257562 533267 367611 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3883 3883 0 0.00 0 16567 231 0 0
t$perf-norm:sp_cancel_adding_invoice 349 349 0 0.00 0 12000 166 0 0
t$perf-norm:sp_cancel_client_order 1409 1409 0 0.00 0 1925 14 0 0
t$perf-norm:sp_cancel_customer_reserve 509 509 0 0.00 0 3549 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 540 540 0 0.00 0 1859 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 309 309 0 0.00 0 2420 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 302 302 0 0.00 0 803 20 0 0
t$perf-norm:sp_cancel_supplier_order 370 370 0 0.00 0 24761 1963 0 0
t$perf-norm:sp_cancel_write_off 808 808 0 0.00 0 8045 26 0 0
t$perf-norm:sp_client_order 16008 16008 0 0.00 0 5746 18 0 0
t$perf-norm:sp_customer_reserve 797 797 0 0.00 0 5424 18 0 0
t$perf-norm:sp_pay_from_customer 5645 5645 0 0.00 0 17076 16 0 0
t$perf-norm:sp_pay_to_supplier 4723 4723 0 0.00 0 5837 13 0 0
t$perf-norm:sp_reserve_write_off 7834 7834 0 0.00 0 16831 18 0 0
t$perf-norm:sp_supplier_invoice 4172 4172 0 0.00 0 9973 18 0 0
t$perf-norm:sp_supplier_order 4353 4353 0 0.00 0 4558 18 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 613 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 177 4 0 0
t$perf-norm:srv_make_invnt_saldo 461 461 0 0.00 0 1147 21 0 0
t$perf-norm:srv_make_money_saldo 629 629 0 0.00 0 6952 35 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 7936 7752 184 2.31 0 7084 20 0 184
v_all_customers 29922 29922 0 0.00 0 101 1 0 0
v_all_suppliers 24556 24556 0 0.00 0 90 1 0 0
v_all_wares 32010 32010 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 698 698 0 0.00 0 1435 10 0 0
v_cancel_client_order 2818 2818 0 0.00 0 3122 5 0 0
v_cancel_customer_prepayment 1080 1080 0 0.00 0 558 4 0 0
v_cancel_customer_reserve 1018 1018 0 0.00 0 121 3 0 0
v_cancel_payment_to_supplier 618 618 0 0.00 0 1487 5 0 0
v_cancel_supplier_invoice 618 604 14 2.26 0 4855 34 0 14
v_cancel_supplier_order 740 740 0 0.00 0 2619 9 0 0
v_cancel_write_off 1616 1616 0 0.00 0 4958 17 0 0
v_max_id_clo_ord 4352 4352 0 0.00 0 747 2 0 0
v_max_id_clo_res 797 797 0 0.00 0 3768 22 0 0
v_max_id_ord_sup 4169 4169 0 0.00 0 4213 5 0 0
v_max_non_paid_invoice 966 966 0 0.00 0 988 4 0 0
v_max_non_paid_realizn 2692 2692 0 0.00 0 1978 5 0 0
v_min_id_clo_ord 4352 4352 0 0.00 0 8520 14 0 0
v_min_id_clo_res 797 797 0 0.00 0 1840 5 0 0
v_min_id_ord_sup 4169 4169 0 0.00 0 3182 5 0 0
v_min_non_paid_invoice 4723 4723 0 0.00 0 23740 30 0 0
v_min_non_paid_realizn 5645 5645 0 0.00 0 17698 34 0 0
v_our_firm 7994 7994 0 0.00 0 17 1 0 0
v_reserve_write_off 15668 15668 0 0.00 0 6973 7 0 0
x_lock_depdocs_on_canc_invoice 9685 9685 0 0.00 0 17048 150 0 0
x_lock_depdocs_on_canc_sup_ord 370 370 0 0.00 0 5097 367 0 0
x_make_qstorno_1000_1200 4353 4353 0 0.00 1 49676 1349 0 0
x_make_qstorno_1200_2000 4172 4172 0 0.00 3 86419 3347 0 0
x_make_qstorno_2100_3300 372436 372436 0 0.00 0 34148 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-04-2024 01:11:04 to 15-04-2024 01:11:08.

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
23:09:52 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:53 38631 8192000000 9907569456 10218176512 984771504 10.731 100 89 178 0 1013773072 6236672 22764896
23:12:39 12441 8192000000 9940227184 10262888448 1023632064 11.107 100 85 170 0 1053768608 8630144 21506400
23:13:57 6978 8192000000 9964105776 10291187712 1046843984 11.330 100 86 172 0 1078539392 10145696 21549712
23:15:09 11122 8192000000 10013163408 10357702656 1097928048 11.818 100 83 166 0 1128780432 11157952 19694432
23:16:25 5421 8192000000 10060940304 10416611328 1151747136 12.326 100 81 162 0 1182807936 11804864 19255936
23:17:39 4440 8192000000 10108127600 10475454464 1199098528 12.768 100 81 162 0 1229776224 12324768 18352928
23:18:49 1202 8192000000 10148982864 10521038848 1238742944 13.135 100 86 169 2 1270163184 13097088 18323152
23:19:52 1779 8192000000 10183139792 10565779456 1265970704 13.385 100 80 159 2 1295385152 11528416 17886032
23:20:56 1260 8192000000 10206387440 10590576640 1285802224 13.566 100 91 181 0 1320074016 13719696 20552096
23:21:59 30657 8192000000 10209189984 10604290048 1300131808 13.696 100 50 99 0 1318241056 6605072 11504176
23:23:31 6986 8192000000 10200171440 10609315840 1307595296 13.764 100 30 61 0 1320614640 6107216 6912128
23:24:38 16730 8192000000 10202586368 10621054976 1315619408 13.837 100 14 26 1 1324175696 4822544 3733744
23:25:57 62696 8192000000 10221992736 10637139968 1321743104 13.892 100 24 48 1 1332356608 4705520 5907984
23:28:12 2658 8192000000 10233844432 10647465984 1331352128 13.979 100 41 82 0 1347360816 6887472 9121216
23:29:17 3610 8192000000 10230612960 10644930560 1319851360 13.875 99 30 60 0 1332909504 5580352 7477792
23:30:25 27072 8192000000 10227532816 10635784192 1317817376 13.857 99 45 90 0 1335581344 6996208 10767760
23:32:00 48013 8192000000 10236712624 10652708864 1312061968 13.805 98 52 102 0 1335384768 10963360 12359440
23:33:56 12097 8192000000 10230162160 10642182144 1299673280 13.692 97 48 96 1 1324417424 13676864 11067280
23:35:21 22378 8192000000 10227106048 10633732096 1293681280 13.638 97 38 75 0 1314361232 12346640 8333312
23:36:50 32452 8192000000 10250236032 10658861056 1327417712 13.944 99 51 101 2 1357409296 18425680 11565904
23:38:32 17833 8192000000 10259001408 10673250304 1341165936 14.068 100 47 94 0 1374979952 21674096 12139920
23:40:04 19315 8192000000 10256386384 10669264896 1322659088 13.901 98 45 90 1 1352435040 18695232 11080720
23:41:28 10664 8192000000 10256130064 10662121472 1326938752 13.939 99 54 106 2 1361109760 21395200 12775808
23:42:44 4961 8192000000 10263406848 10667102208 1325308032 13.925 99 60 116 1 1364386224 24965888 14112304
23:43:55 2171 8192000000 10271396096 10675007488 1340190464 14.059 100 64 130 2 1382884528 26761616 15932448
23:45:01 1357 8192000000 10272786224 10665328640 1326473456 13.935 100 79 154 0 1377312368 31649024 19189888
23:46:05 2568 8192000000 10308917248 10708377600 1360053472 14.238 100 79 158 0 1414261712 35421520 18786720
23:47:14 2193 8192000000 10314128624 10715004928 1360169552 14.239 100 88 176 0 1418055776 35769680 22116544
23:48:20 2968 8192000000 10316709440 10724954112 1368971296 14.318 100 65 130 0 1424837504 39890336 15975872
23:49:32 3394 8192000000 10347319184 10753122304 1382919584 14.443 100 76 149 0 1452595760 50978288 18697888
23:50:40 2305 8192000000 10375127536 10783989760 1407485408 14.662 100 70 140 1 1475317360 50547344 17284608
23:51:44 11995 8192000000 10361002176 10785619968 1405131088 14.641 99 33 66 0 1459923920 45870560 8922272
23:53:01 16890 8192000000 10376720752 10808320000 1422485168 14.795 100 42 83 0 1482109472 48268016 11356288
23:54:43 13055 8192000000 10376101952 10819506176 1420162720 14.774 100 34 69 0 1490355920 60189696 10003504
23:55:59 15666 8192000000 10362113328 10810970112 1414449056 14.723 100 31 62 0 1480020832 56805776 8766000
23:57:19 18164 8192000000 10366707888 10800812032 1394535104 14.546 99 41 82 1 1460670800 54974480 11161216
23:58:51 21034 8192000000 10326211040 10791653376 1395613104 14.556 100 24 48 0 1461209232 58672048 6924080
00:00:13 22109 8192000000 10320336512 10765295616 1398430928 14.581 100 26 52 1 1433208640 28821248 5956464
00:02:08 111700 8192000000 10305606880 10762633216 1406194480 14.650 100 29 58 0 1429979952 16616640 7168832
00:05:04 71416 8192000000 10309677584 10764468224 1412994208 14.711 100 22 42 1 1425845872 8151808 4699856
00:07:30 24035 8192000000 10331104576 10785107968 1418550416 14.760 100 23 47 0 1440032096 16135872 5345808
00:09:16 51870 8192000000 10324524160 10777759744 1415908896 14.736 100 35 71 0 1438879392 14907552 8062944
00:11:09 43516 8192000000 10291321424 10752102400 1372924624 14.353 97 11 22 0 1386321232 11120816 2275792
00:13:05 113780 8192000000 10310037584 10772598784 1398676544 14.583 99 7 14 0 1409356784 9250272 1429968
00:16:02 48886 8192000000 10319129968 10784280576 1424011520 14.808 100 12 24 0 1433988048 7403360 2573168
00:17:52 73465 8192000000 10312574672 10769969152 1369430352 14.322 96 22 44 0 1389940800 15710752 4799696
00:20:07 108708 8192000000 10286997856 10749263872 1306668032 13.756 93 11 22 0 1326714464 17307040 2739392
00:23:04 131912 8192000000 10277437024 10729414656 1314675968 13.828 94 18 36 0 1335141216 16233776 4231472
00:26:17 57678 8192000000 10280822096 10724851712 1319761872 13.875 96 18 36 1 1336087936 11611152 4714912
00:28:15 60659 8192000000 10263691600 10713018368 1294475584 13.645 95 32 64 0 1320344224 18230112 7638528
00:30:16 49886 8192000000 10231616032 10679439360 1292186160 13.624 96 17 34 4 1307689504 11583280 3920064
00:32:10 112141 8192000000 10247664528 10704044032 1345605408 14.108 99 16 32 0 1360648496 11752432 3290656
00:35:03 33786 8192000000 10221641392 10658869248 1310897776 13.794 98 17 34 0 1326084288 11399216 3787296
00:36:37 58481 8192000000 10238053200 10684604416 1325217008 13.924 98 14 28 0 1343067424 14911712 2938704
00:38:47 65656 8192000000 10261121184 10720505856 1361769552 14.253 100 23 46 1 1381193904 13853696 5570656
00:40:58 13517 8192000000 10285829360 10714853376 1372064096 14.346 100 49 94 1 1389173456 6630128 10479232
00:42:13 74429 8192000000 10248337120 10710769664 1307116784 13.760 95 13 26 1 1318675472 8860848 2697840
00:44:27 29045 8192000000 10260486704 10699333632 1320701808 13.883 97 26 48 0 1336329824 10037632 5590384
00:45:56 65771 8192000000 10274299376 10720468992 1345974992 14.111 98 24 47 1 1371299056 19432272 5891792
00:48:18 46448 8192000000 10293918480 10736857088 1382299888 14.437 100 23 46 0 1398013136 10610032 5103216
00:50:08 63374 8192000000 10300885360 10766516224 1380034160 14.417 99 14 28 0 1399060464 15978656 3047648
00:52:13 28394 8192000000 10297699088 10742951936 1376945280 14.389 99 29 58 0 1395212736 11970336 6297120
00:53:41 32423 8192000000 10311728512 10767253504 1399309808 14.589 100 25 51 1 1421228288 15958624 5959856
00:55:17 99469 8192000000 10307347856 10763128832 1375357840 14.375 98 21 42 0 1397618880 17420720 4840320
00:58:04 59772 8192000000 10308861712 10769100800 1406963552 14.657 100 20 40 0 1423269888 11747584 4558752
01:00:05 29004 8192000000 10303156352 10767843328 1391240976 14.517 99 16 31 0 1405746976 10971216 3534784
01:01:34 37423 8192000000 10306805472 10766069760 1404547200 14.635 100 17 34 0 1422798016 14240304 4010512
01:03:11 52412 8192000000 10326636816 10782224384 1417879888 14.754 100 13 24 1 1432144048 11315120 2949040
01:05:13 69444 8192000000 10313697616 10792374272 1419356688 14.767 100 15 30 0 1437173312 14170784 3645840
01:07:39 39216 8192000000 10302632992 10757623808 1389318336 14.500 99 24 48 0 1403983792 9087968 5577488
01:09:19 33871 8192000000 9021039584 9216655360 188258528 2.246 14 7 12 0 193562832 3918624 1385680

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 15-04-2024 01:11:10 to 15-04-2024 01:11:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 92 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-04-2024 01:11:25 to 15-04-2024 01:11:27.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Apr 15 01:11:28 2024 
 
Database header page information: 
    Flags            0 
    Generation        86754 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    166544 
    Oldest active        166545 
    Oldest snapshot        166545 
    Next transaction    166546 
    Sequence number        0 
    Next attachment ID    690 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.21, total records: 7675708 
    Average version length: 48.16, total versions: 108808, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 53, data page slots: 86400 
    Data pages: 86400, average fill: 71% 
    Primary pages: 86400, secondary pages: 0, swept pages: 17395 
    Empty pages: 6, full pages: 64392 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 284 
    40 - 59% = 3931 
    60 - 79% = 82112 
    80 - 99% = 48 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23075, nodes: 7675708 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1698054, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 339 
        20 - 39% = 1903 
        40 - 59% = 3994 
        60 - 79% = 2475 
        80 - 99% = 14364 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13388, nodes: 7675708 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1521384, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1607 
        40 - 59% = 1920 
        60 - 79% = 1193 
        80 - 99% = 8668 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8241, nodes: 7675708 
    Average node length: 6.60, total dup: 5763936, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1514315, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 1008 
        40 - 59% = 1294 
        60 - 79% = 976 
        80 - 99% = 4850 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.97, total records: 2201331 
    Average version length: 34.60, total versions: 107097, max versions: 3 
    Average fragment length: 5.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28320 
    Data pages: 28320, average fill: 72% 
    Primary pages: 28314, secondary pages: 6, swept pages: 8949 
    Empty pages: 5, full pages: 19672 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 233 
    40 - 59% = 2736 
    60 - 79% = 24487 
    80 - 99% = 827 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4482, nodes: 2201331 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 682091, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 939 
        40 - 59% = 799 
        60 - 79% = 759 
        80 - 99% = 1984 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2508, nodes: 2204179 
    Average node length: 4.97, total dup: 2203280, max dup: 17254 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1232208, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 280 
        40 - 59% = 1556 
        60 - 79% = 496 
        80 - 99% = 174 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1976, nodes: 2201331 
    Average node length: 4.97, total dup: 2201281, max dup: 129891 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1045881, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 152 
        40 - 59% = 899 
        60 - 79% = 99 
        80 - 99% = 825 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4298, nodes: 2201331 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 682091, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 623 
        40 - 59% = 598 
        60 - 79% = 850 
        80 - 99% = 2123 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.95, total records: 400 
    Average version length: 23.28, total versions: 228334, max versions: 595 
    Average fragment length: 2.00, total fragments: 19, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 1264 
    Data pages: 1264, average fill: 91% 
    Primary pages: 7, secondary pages: 1257, swept pages: 0 
    Empty pages: 0, full pages: 1263 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1263 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 12.47, total records: 53840 
    Average version length: 68.27, total versions: 44011, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.06 
    Pointer pages: 7, data page slots: 2224 
    Data pages: 1112, average fill: 60% 
    Primary pages: 1111, secondary pages: 1, swept pages: 0 
    Empty pages: 229, full pages: 656 
    Fill distribution: 
     0 - 19% = 295 
    20 - 39% = 46 
    40 - 59% = 70 
    60 - 79% = 159 
    80 - 99% = 542 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1711209, depth: 3, leaf buckets: 170, nodes: 53840 
    Average node length: 13.48, total dup: 2840, max dup: 1 
    Average key length: 10.91, compression ratio: 2.48 
    Average prefix length: 19.04, average data length: 7.96 
    Clustering factor: 40219, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 96 
        60 - 79% = 50 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 17270, max versions: 920 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 87% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 58 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 7.93, total records: 1036 
    Average version length: 42.70, total versions: 849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 7.31 
    Pointer pages: 1, data page slots: 32 
    Data pages: 23, average fill: 42% 
    Primary pages: 22, secondary pages: 1, swept pages: 1 
    Empty pages: 7, full pages: 8 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94993, depth: 2, leaf buckets: 2, nodes: 1036 
    Average node length: 4.36, total dup: 939, max dup: 97 
    Average key length: 3.00, compression ratio: 6.33 
    Average prefix length: 18.09, average data length: 0.91 
    Clustering factor: 565, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.04, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.21, total records: 841002 
    Average version length: 25.36, total versions: 67101, max versions: 4 
    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: 8264 
    Data pages: 8264, average fill: 71% 
    Primary pages: 8252, secondary pages: 12, swept pages: 1379 
    Empty pages: 23, full pages: 7499 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 46 
    40 - 59% = 111 
    60 - 79% = 7775 
    80 - 99% = 277 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 926, nodes: 841002 
    Average node length: 4.88, total dup: 840953, max dup: 156075 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91314, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 111 
        40 - 59% = 551 
        60 - 79% = 192 
        80 - 99% = 69 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1009, nodes: 841002 
    Average node length: 5.88, total dup: 748705, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165801, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 88 
        40 - 59% = 548 
        60 - 79% = 96 
        80 - 99% = 274 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1057, nodes: 841002 
    Average node length: 5.89, total dup: 748705, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167735, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 195 
        40 - 59% = 515 
        60 - 79% = 80 
        80 - 99% = 267 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1178, nodes: 841002 
    Average node length: 5.97, total dup: 748705, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 160009, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 245 
        40 - 59% = 614 
        60 - 79% = 218 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.81, total records: 5471 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.83, total fragments: 84, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 168 
    Data pages: 104, average fill: 52% 
    Primary pages: 81, secondary pages: 23, swept pages: 51 
    Empty pages: 21, full pages: 64 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5471 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5200, 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: 1504233, depth: 2, leaf buckets: 10, nodes: 5471 
    Average node length: 11.10, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 75582 
    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: 736 
    Data pages: 736, average fill: 71% 
    Primary pages: 736, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 728 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 728 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38393, depth: 2, leaf buckets: 96, nodes: 75582 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3053, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 95 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.60, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 137.43, total records: 191274 
    Average version length: 153.78, total versions: 17354, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.34 
    Pointer pages: 7, data page slots: 5136 
    Data pages: 4632, average fill: 86% 
    Primary pages: 4632, secondary pages: 0, swept pages: 1 
    Empty pages: 78, full pages: 4525 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 7 
    40 - 59% = 10 
    60 - 79% = 11 
    80 - 99% = 4525 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 133.37, total records: 182464 
    Average version length: 154.27, total versions: 21430, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.72 
    Pointer pages: 7, data page slots: 5672 
    Data pages: 4464, average fill: 85% 
    Primary pages: 4464, secondary pages: 0, swept pages: 3 
    Empty pages: 105, full pages: 4320 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 18 
    40 - 59% = 8 
    60 - 79% = 10 
    80 - 99% = 4319 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 135.85, total records: 175882 
    Average version length: 154.55, total versions: 17529, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.48 
    Pointer pages: 7, data page slots: 7024 
    Data pages: 4312, average fill: 85% 
    Primary pages: 4311, secondary pages: 1, swept pages: 1 
    Empty pages: 113, full pages: 4149 
    Fill distribution: 
     0 - 19% = 115 
    20 - 39% = 14 
    40 - 59% = 22 
    60 - 79% = 12 
    80 - 99% = 4149 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 144.10, total records: 196239 
    Average version length: 152.97, total versions: 9296, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 7, data page slots: 6368 
    Data pages: 4704, average fill: 86% 
    Primary pages: 4704, secondary pages: 0, swept pages: 2 
    Empty pages: 27, full pages: 4641 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 10 
    40 - 59% = 13 
    60 - 79% = 12 
    80 - 99% = 4639 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.35, total records: 163147 
    Average version length: 149.04, total versions: 3011, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 8, data page slots: 4640 
    Data pages: 3936, average fill: 85% 
    Primary pages: 3936, secondary pages: 0, swept pages: 1 
    Empty pages: 59, full pages: 3855 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 3855 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 146.52, total records: 176366 
    Average version length: 151.66, total versions: 5427, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 5040 
    Data pages: 4288, average fill: 85% 
    Primary pages: 4288, secondary pages: 0, swept pages: 1 
    Empty pages: 90, full pages: 4170 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 4170 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 144.27, total records: 171680 
    Average version length: 150.81, total versions: 7493, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 8, data page slots: 5888 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4136, secondary pages: 0, swept pages: 1 
    Empty pages: 61, full pages: 4054 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 4056 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 136.04, total records: 188921 
    Average version length: 154.32, total versions: 18707, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.47 
    Pointer pages: 7, data page slots: 5976 
    Data pages: 4584, average fill: 86% 
    Primary pages: 4584, secondary pages: 0, swept pages: 3 
    Empty pages: 87, full pages: 4473 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4472 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.62, total records: 167847 
    Average version length: 150.04, total versions: 3604, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 6, data page slots: 6880 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 1 
    Empty pages: 57, full pages: 3967 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3967 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.84, total records: 186595 
    Average version length: 150.52, total versions: 4364, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 8, data page slots: 4800 
    Data pages: 4464, average fill: 86% 
    Primary pages: 4464, secondary pages: 0, swept pages: 3 
    Empty pages: 27, full pages: 4420 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4422 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.46, total records: 2071143 
    Average version length: 52.90, total versions: 50102, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25432 
    Data pages: 25424, average fill: 70% 
    Primary pages: 25424, secondary pages: 0, swept pages: 11146 
    Empty pages: 329, full pages: 19767 
    Fill distribution: 
     0 - 19% = 639 
    20 - 39% = 533 
    40 - 59% = 1316 
    60 - 79% = 22504 
    80 - 99% = 432 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2568, nodes: 2071143 
    Average node length: 5.44, total dup: 1931963, max dup: 1455 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179453, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 328 
        40 - 59% = 1661 
        60 - 79% = 310 
        80 - 99% = 269 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2752, nodes: 2071143 
    Average node length: 5.69, total dup: 1858819, max dup: 100 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370623, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2500 
        60 - 79% = 220 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2081, nodes: 2071143 
    Average node length: 4.96, total dup: 2071043, max dup: 26801 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177241, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 188 
        40 - 59% = 1072 
        60 - 79% = 379 
        80 - 99% = 442 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 38.23, total records: 146831 
    Average version length: 69.18, total versions: 65737, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.30 
    Pointer pages: 3, data page slots: 4160 
    Data pages: 3344, average fill: 51% 
    Primary pages: 3344, secondary pages: 0, swept pages: 554 
    Empty pages: 810, full pages: 1726 
    Fill distribution: 
     0 - 19% = 1108 
    20 - 39% = 148 
    40 - 59% = 141 
    60 - 79% = 774 
    80 - 99% = 1173 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104534, depth: 3, leaf buckets: 235, nodes: 146831 
    Average node length: 6.42, total dup: 127826, max dup: 14 
    Average key length: 3.94, compression ratio: 10.66 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25221, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 55 
        40 - 59% = 120 
        60 - 79% = 57 
        80 - 99% = 3 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.96, total records: 7506937 
    Average version length: 68.74, total versions: 434565, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 66, data page slots: 106160 
    Data pages: 106160, average fill: 76% 
    Primary pages: 106160, secondary pages: 0, swept pages: 24037 
    Empty pages: 13, full pages: 92369 
    Fill distribution: 
     0 - 19% = 114 
    20 - 39% = 768 
    40 - 59% = 4159 
    60 - 79% = 92962 
    80 - 99% = 8157 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10935, nodes: 7506937 
    Average node length: 6.51, total dup: 6493500, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1670559, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1357 
        40 - 59% = 5736 
        60 - 79% = 3088 
        80 - 99% = 749 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8844, nodes: 7506937 
    Average node length: 5.39, total dup: 7216366, max dup: 159 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1454987, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 943 
        40 - 59% = 5030 
        60 - 79% = 1744 
        80 - 99% = 1117 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8917, nodes: 7506937 
    Average node length: 5.39, total dup: 7216366, max dup: 159 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1457413, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1004 
        40 - 59% = 5042 
        60 - 79% = 1768 
        80 - 99% = 1097 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.00, total records: 12486899 
    Average version length: 68.67, total versions: 352165, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 106, data page slots: 172424 
    Data pages: 172424, average fill: 77% 
    Primary pages: 172424, secondary pages: 0, swept pages: 73848 
    Empty pages: 7, full pages: 165758 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 351 
    40 - 59% = 1997 
    60 - 79% = 162575 
    80 - 99% = 7460 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18530, nodes: 12486899 
    Average node length: 6.61, total dup: 10880343, max dup: 60 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2419284, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1879 
        40 - 59% = 10430 
        60 - 79% = 5163 
        80 - 99% = 1025 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.19, total records: 1633351 
    Average version length: 69.09, total versions: 684079, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.13 
    Pointer pages: 26, data page slots: 41344 
    Data pages: 29152, average fill: 65% 
    Primary pages: 29152, secondary pages: 0, swept pages: 7762 
    Empty pages: 3145, full pages: 19566 
    Fill distribution: 
     0 - 19% = 4963 
    20 - 39% = 1759 
    40 - 59% = 1542 
    60 - 79% = 10185 
    80 - 99% = 10703 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2140, nodes: 1633351 
    Average node length: 5.52, total dup: 1566883, max dup: 99 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 108528, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 489 
        40 - 59% = 1000 
        60 - 79% = 499 
        80 - 99% = 149 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.09, total records: 1124201 
    Average version length: 69.12, total versions: 471097, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.14 
    Pointer pages: 23, data page slots: 36352 
    Data pages: 30336, average fill: 43% 
    Primary pages: 30336, secondary pages: 0, swept pages: 7628 
    Empty pages: 7406, full pages: 12314 
    Fill distribution: 
     0 - 19% = 12241 
    20 - 39% = 2788 
    40 - 59% = 1522 
    60 - 79% = 6228 
    80 - 99% = 7557 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1574, nodes: 1124201 
    Average node length: 5.83, total dup: 1045720, max dup: 101 
    Average key length: 2.90, compression ratio: 14.50 
    Average prefix length: 41.17, average data length: 0.83 
    Clustering factor: 161388, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 386 
        40 - 59% = 710 
        60 - 79% = 372 
        80 - 99% = 101 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.51, total records: 8909730 
    Average version length: 69.00, total versions: 565335, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 87, data page slots: 141944 
    Data pages: 141928, average fill: 67% 
    Primary pages: 141927, secondary pages: 1, swept pages: 52070 
    Empty pages: 441, full pages: 74249 
    Fill distribution: 
     0 - 19% = 1553 
    20 - 39% = 7922 
    40 - 59% = 26213 
    60 - 79% = 97067 
    80 - 99% = 9173 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13418, nodes: 8909730 
    Average node length: 6.68, total dup: 7388901, max dup: 29 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1912232, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1668 
        40 - 59% = 7061 
        60 - 79% = 4142 
        80 - 99% = 547 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21085705 
    Average version length: 82.91, total versions: 15547, 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: 195, data page slots: 317896 
    Data pages: 317896, average fill: 81% 
    Primary pages: 317896, secondary pages: 0, swept pages: 11812 
    Empty pages: 56, full pages: 316774 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 71 
    40 - 59% = 161 
    60 - 79% = 27236 
    80 - 99% = 290336 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19339, nodes: 21085705 
    Average node length: 5.72, total dup: 20605942, max dup: 131 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3271808, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8178 
        60 - 79% = 511 
        80 - 99% = 10643 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17094, nodes: 21085705 
    Average node length: 6.31, total dup: 18530055, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912855, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 738 
        60 - 79% = 288 
        80 - 99% = 16064 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21105, nodes: 21085705 
    Average node length: 6.34, total dup: 18449023, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3565065, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8426 
        60 - 79% = 573 
        80 - 99% = 12098 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 15859, nodes: 21085705 
    Average node length: 5.56, total dup: 21085605, max dup: 228316 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941513, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2492 
        60 - 79% = 384 
        80 - 99% = 12976 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.40, total records: 9362509 
    Average version length: 82.65, total versions: 566863, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 103, data page slots: 167336 
    Data pages: 167296, average fill: 69% 
    Primary pages: 167296, secondary pages: 0, swept pages: 67200 
    Empty pages: 751, full pages: 94507 
    Fill distribution: 
     0 - 19% = 2147 
    20 - 39% = 8864 
    40 - 59% = 28075 
    60 - 79% = 68014 
    80 - 99% = 60196 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11330, nodes: 9362509 
    Average node length: 5.35, total dup: 9058433, max dup: 212 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2046352, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 139 
        40 - 59% = 9061 
        60 - 79% = 2105 
        80 - 99% = 23 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13156, nodes: 9362509 
    Average node length: 6.22, total dup: 7759369, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1412648, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 3923 
        40 - 59% = 4312 
        60 - 79% = 2609 
        80 - 99% = 2211 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12640, nodes: 9362509 
    Average node length: 5.97, total dup: 8119769, max dup: 44 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2238318, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 157 
        40 - 59% = 10105 
        60 - 79% = 2343 
        80 - 99% = 34 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9792, nodes: 9362509 
    Average node length: 5.12, total dup: 9362409, max dup: 149121 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1444319, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1258 
        40 - 59% = 4785 
        60 - 79% = 1710 
        80 - 99% = 1995 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.41, total records: 10889277 
    Average version length: 82.55, total versions: 379514, 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: 117, data page slots: 190264 
    Data pages: 188768, average fill: 71% 
    Primary pages: 188768, secondary pages: 0, swept pages: 76846 
    Empty pages: 3829, full pages: 132004 
    Fill distribution: 
     0 - 19% = 6697 
    20 - 39% = 9605 
    40 - 59% = 21398 
    60 - 79% = 42764 
    80 - 99% = 108304 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13111, nodes: 10889277 
    Average node length: 5.30, total dup: 10780713, max dup: 619 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2264475, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 238 
        40 - 59% = 10114 
        60 - 79% = 2697 
        80 - 99% = 62 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10111, nodes: 10889277 
    Average node length: 5.49, total dup: 10412373, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 682085, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 174 
        20 - 39% = 826 
        40 - 59% = 2477 
        60 - 79% = 1862 
        80 - 99% = 4772 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14999, nodes: 10889277 
    Average node length: 6.03, total dup: 9493043, max dup: 67 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2280768, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 293 
        40 - 59% = 11672 
        60 - 79% = 2961 
        80 - 99% = 69 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10275, nodes: 10889277 
    Average node length: 5.22, total dup: 10889177, max dup: 175265 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 671955, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 864 
        40 - 59% = 4303 
        60 - 79% = 1411 
        80 - 99% = 3580 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.00, total records: 9446751 
    Average version length: 82.94, total versions: 539364, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 104, data page slots: 169688 
    Data pages: 169640, average fill: 69% 
    Primary pages: 169640, secondary pages: 0, swept pages: 73709 
    Empty pages: 540, full pages: 92837 
    Fill distribution: 
     0 - 19% = 1915 
    20 - 39% = 8681 
    40 - 59% = 29517 
    60 - 79% = 71147 
    80 - 99% = 58380 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11457, nodes: 9446751 
    Average node length: 5.16, total dup: 9417976, max dup: 1733 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1867140, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1566 
        40 - 59% = 7560 
        60 - 79% = 1723 
        80 - 99% = 582 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13271, nodes: 9446751 
    Average node length: 6.23, total dup: 7828588, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1377487, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 3952 
        40 - 59% = 4212 
        60 - 79% = 2686 
        80 - 99% = 2259 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12060, nodes: 9446751 
    Average node length: 5.42, total dup: 9021375, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 1995874, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1489 
        40 - 59% = 8435 
        60 - 79% = 1575 
        80 - 99% = 541 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9901, nodes: 9446751 
    Average node length: 5.13, total dup: 9446651, max dup: 151162 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1459925, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1333 
        40 - 59% = 4757 
        60 - 79% = 1690 
        80 - 99% = 2071 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.14, total records: 571544 
    Average version length: 68.84, total versions: 8552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7936 
    Data pages: 7936, average fill: 75% 
    Primary pages: 7936, secondary pages: 0, swept pages: 3730 
    Empty pages: 2, full pages: 6710 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 16 
    40 - 59% = 211 
    60 - 79% = 7540 
    80 - 99% = 162 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46589, depth: 3, leaf buckets: 740, nodes: 571544 
    Average node length: 5.95, total dup: 486606, max dup: 96 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99542, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 541 
        60 - 79% = 77 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34849, depth: 3, leaf buckets: 759, nodes: 571544 
    Average node length: 6.15, total dup: 468749, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99603, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 549 
        60 - 79% = 80 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 577, nodes: 571544 
    Average node length: 4.86, total dup: 571444, max dup: 9870 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88395, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 335 
        60 - 79% = 90 
        80 - 99% = 111 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Apr 15 01:11:51 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7675708 108808 1 0.0000 0.0000
DOC_LIST 2201331 107097 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 228334 595 57000.0000 0.0000
INVNT_TURNOVER_LOG 53840 44011 1 0.0000 0.0000
MONEY_SALDO 49 17270 920 35200.0000 0.0000
MONEY_TURNOVER_LOG 1036 849 1 0.0000 0.0000
PDISTR 841002 67101 4 0.0000 0.0000
PERF_SPLIT_0 191274 17354 1 0.0000 0.0000
PERF_SPLIT_1 182464 21430 1 0.0000 0.0000
PERF_SPLIT_2 175882 17529 1 0.0000 0.0000
PERF_SPLIT_3 196239 9296 1 0.0000 0.0000
PERF_SPLIT_4 163147 3011 1 0.0000 0.0000
PERF_SPLIT_5 176366 5427 1 0.0000 0.0000
PERF_SPLIT_6 171680 7493 1 0.0000 0.0000
PERF_SPLIT_7 188921 18707 1 0.0000 0.0000
PERF_SPLIT_8 167847 3604 1 0.0000 0.0000
PERF_SPLIT_9 186595 4364 1 0.0000 0.0000
PSTORNED 2071143 50102 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 146831 65737 1 0.0000 0.0000
XQD_1000_3300 7506937 434565 1 0.0000 0.0000
XQD_1200_2000 12486899 352165 1 0.0000 0.0000
XQD_2000_3300 1633351 684079 1 0.0000 0.0000
XQD_2100_3300 1124201 471097 1 0.0000 0.0000
XQD_3300_3400 8909730 565335 1 0.0000 0.0000
XQS_1000_1200 21085705 15547 1 0.0000 0.0000
XQS_1000_3300 9362509 566863 1 0.0000 0.0000
XQS_1200_2000 10889277 379514 1 0.0000 0.0000
XQS_2100_3300 9446751 539364 1 0.0000 0.0000
XQS_3300_3400 571544 8552 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 ---
:1233: 
:1234: mscs-test-161.budzdorov.ru    Mon Apr 15 01:09:55 2024
:1235:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1236: 
:1237: 
:1238: mscs-test-161.budzdorov.ru    Mon Apr 15 01:09:58 2024
:1239:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1240: 
:1241: 
:1242: mscs-test-161.budzdorov.ru    Mon Apr 15 01:09:59 2024
:1243:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1244: 
--- end of diff output ---

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

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