Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.02.2024 19: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 15804680 kB
MemAvailable 30267716 kB
Buffers 0 kB
Cached 15917848 kB
SwapCached 2404 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-02-22 19:09:41
DTS_END                         2024-02-22 19:09:41.0900
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51644
TRN_ID                          175660
ATT_ID                          535
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: 8981.11 22705 898111
customer order: creation 176.65 326 17665
customer order: refuse 15.48 367 1548
order to supplier: creation 45.63 1365 4563
order to supplier: removal 3.54 94859 354
invoice (draft): creation 46.59 3732 4659
invoice (draft): removal 47.36 940 4736
invoice accept: apply 42.51 21593 4251
invoice accept: cancel 42.62 943 4262
customer reserve: creation 4058.40 208 405840
customer reserve: removal 4209.96 62 420996
realization accept: apply 86.03 197 8603
realization accept: cancel 72.80 135 7280
payment from customer: creation 60.00 114 6000
payment from customer: removal 5.75 86 575
payment to supplier: creation 51.45 148 5145
payment to supplier: removal 3.27 87 327
service: total inventory turnovers 5.20 1144 520
service: total monetary turnovers 6.92 36 692
service: aggregate perf. data 0.92 17988 92
service: refresh index statistics 0.03 309774 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2024 19:10:59 to 22-02-2024 19:11:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1553
TEST_TIME 2 2935
TEST_TIME 3 3446
TEST_TIME 4 3578
TEST_TIME 5 3759
TEST_TIME 6 4322
TEST_TIME 7 4815
TEST_TIME 8 4666
TEST_TIME 9 5047
TEST_TIME 10 5005
TEST_TIME 11 5211
TEST_TIME 12 5344
TEST_TIME 13 5425
TEST_TIME 14 5682
TEST_TIME 15 5857
TEST_TIME 16 5904
TEST_TIME 17 5839
TEST_TIME 18 6093
TEST_TIME 19 6313
TEST_TIME 20 6428
TEST_TIME 21 6907
TEST_TIME 22 6911
TEST_TIME 23 6934
TEST_TIME 24 7409
TEST_TIME 25 7704
TEST_TIME 26 8232
TEST_TIME 27 8240
TEST_TIME 28 8257
TEST_TIME 29 8146
TEST_TIME 30 8555
TEST_TIME 31 9068
TEST_TIME 32 8911
TEST_TIME 33 8691
TEST_TIME 34 8842
TEST_TIME 35 8924
TEST_TIME 36 8830
TEST_TIME 37 8711
TEST_TIME 38 8737
TEST_TIME 39 8690
TEST_TIME 40 8723
TEST_TIME 41 8685
TEST_TIME 42 8794
TEST_TIME 43 8950
TEST_TIME 44 8907
TEST_TIME 45 8886
TEST_TIME 46 8774
TEST_TIME 47 8931
TEST_TIME 48 8829
TEST_TIME 49 8783
TEST_TIME 50 8788
TEST_TIME 51 8949
TEST_TIME 52 9051
TEST_TIME 53 9039
TEST_TIME 54 9028
TEST_TIME 55 9067
TEST_TIME 56 9019
TEST_TIME 57 9151
TEST_TIME 58 9214
TEST_TIME 59 9331
TEST_TIME 60 9319
TEST_TIME 61 9237
TEST_TIME 62 9147
TEST_TIME 63 9155
TEST_TIME 64 9037
TEST_TIME 65 9064
TEST_TIME 66 9039
TEST_TIME 67 9116
TEST_TIME 68 9066
TEST_TIME 69 9017
TEST_TIME 70 8995
TEST_TIME 71 9014
TEST_TIME 72 8980
TEST_TIME 73 8934
TEST_TIME 74 8956
TEST_TIME 75 8950
TEST_TIME 76 8957
TEST_TIME 77 8958
TEST_TIME 78 8980
TEST_TIME 79 8966
TEST_TIME 80 9030
TEST_TIME 81 9022
TEST_TIME 82 9109
TEST_TIME 83 9173
TEST_TIME 84 9192
TEST_TIME 85 9164
TEST_TIME 86 9197
TEST_TIME 87 9205
TEST_TIME 88 9278
TEST_TIME 89 9221
TEST_TIME 90 9131
TEST_TIME 91 9119
TEST_TIME 92 9089
TEST_TIME 93 9081
TEST_TIME 94 9037
TEST_TIME 95 9007
TEST_TIME 96 8960
TEST_TIME 97 8976
TEST_TIME 98 8975
TEST_TIME 99 9002
TEST_TIME 100 8981

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-02-2024 19:11:02 to 22-02-2024 19:11:05.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1269226 1269226 0 0.00 0 23654 7 0 0
doc_list_biud 1269226 1269226 0 0.00 0 51884 27 0 0
sp_add_invoice_to_stock 4301 4251 50 1.16 35 232396 21593 0 50
sp_cancel_adding_invoice 4262 4262 0 0.00 4 70595 943 0 0
sp_cancel_client_order 1548 1548 0 0.00 4 9169 368 0 0
sp_cancel_customer_reserve 420996 420996 0 0.00 0 27370 62 0 0
sp_cancel_pay_from_customer 575 575 0 0.00 3 4550 86 0 0
sp_cancel_pay_to_supplier 327 327 0 0.00 2 2437 88 0 0
sp_cancel_supplier_invoice 4747 4736 11 0.23 2 51890 940 0 11
sp_cancel_supplier_order 354 354 0 0.00 8 1016956 94859 0 0
sp_cancel_write_off 7280 7280 0 0.00 1 12421 135 0 0
sp_client_order 17665 17665 0 0.00 3 15831 327 0 0
sp_customer_reserve 405840 405840 0 0.00 0 92607 209 0 0
sp_fill_shopping_cart 26868 26868 0 0.00 1 13977 34 0 0
sp_fill_shopping_cart_clo_res 405839 405839 0 0.00 0 19793 14 0 0
sp_get_clo_for_invoice 4250 4250 0 0.00 0 26006 305 0 0
sp_kill_cost_storno 12444 12444 0 0.00 0 5906 66 0 0
sp_kill_qstorno_ret_qs2qd 854362 854362 0 0.00 0 51880 34 0 0
sp_kill_qty_storno 452029 452029 0 0.00 0 51882 75 0 0
sp_lock_selected_doc 17744 17744 0 0.00 0 8875 5 0 0
sp_make_cost_storno 23998 23998 0 0.00 0 23650 63 0 0
sp_multiply_rows_for_pdistr 23998 23998 0 0.00 0 8583 34 0 0
sp_multiply_rows_for_qdistr 17665 17665 0 0.00 0 13082 123 0 0
sp_pay_from_customer 6000 6000 0 0.00 4 7674 114 0 0
sp_pay_to_supplier 5145 5145 0 0.00 5 23692 149 0 0
sp_payment_common 11145 11145 0 0.00 2 16858 36 0 0
sp_qd_handle_on_cancel_clo 1548 1548 0 0.00 0 6480 333 0 0
sp_qd_handle_on_invoice_upd_sts 8512 8512 0 0.00 0 31173 356 0 0
sp_qd_handle_on_reserve_upd_sts 8603 8603 0 0.00 0 19008 66 0 0
sp_reserve_write_off 8603 8603 0 0.00 6 19039 198 0 0
sp_supplier_invoice 4659 4659 0 0.00 5 79381 3733 0 0
sp_supplier_order 4563 4563 0 0.00 5 62008 1365 0 0
srv_aggregate_perf_data 92 92 0 0.00 2137 187777 17989 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 2718 155791 38847 0 0
srv_find_qd_qs_mism 854612 854612 0 0.00 0 12529 7 0 0
srv_make_invnt_saldo 520 520 0 0.00 35 44665 1144 0 0
srv_make_money_saldo 692 692 0 0.00 1 7914 37 0 0
srv_recalc_idx_stat 3 3 0 0.00 145261 467196 309775 0 0
t$perf-abend:sp_add_invoice_to_stock 50 50 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4251 4251 0 0.00 0 11781 197 0 0
t$perf-norm:sp_cancel_adding_invoice 352 352 0 0.00 0 3434 93 0 0
t$perf-norm:sp_cancel_client_order 1548 1548 0 0.00 0 5328 19 0 0
t$perf-norm:sp_cancel_customer_reserve 601 601 0 0.00 0 2015 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 575 575 0 0.00 0 3505 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 327 327 0 0.00 0 4094 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 324 324 0 0.00 0 895 22 0 0
t$perf-norm:sp_cancel_supplier_order 354 354 0 0.00 0 21381 1712 0 0
t$perf-norm:sp_cancel_write_off 810 810 0 0.00 0 10433 23 0 0
t$perf-norm:sp_client_order 17665 17665 0 0.00 0 30557 20 0 0
t$perf-norm:sp_customer_reserve 886 886 0 0.00 0 28205 49 0 0
t$perf-norm:sp_pay_from_customer 6000 6000 0 0.00 0 3588 10 0 0
t$perf-norm:sp_pay_to_supplier 5145 5145 0 0.00 0 6722 14 0 0
t$perf-norm:sp_reserve_write_off 8603 8603 0 0.00 0 12510 17 0 0
t$perf-norm:sp_supplier_invoice 4659 4659 0 0.00 0 5553 21 0 0
t$perf-norm:sp_supplier_order 4563 4563 0 0.00 0 4903 22 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 252 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 42 1 0 0
t$perf-norm:srv_make_invnt_saldo 520 520 0 0.00 0 5060 40 0 0
t$perf-norm:srv_make_money_saldo 692 692 0 0.00 0 1254 14 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 44 16 0 0
v_add_invoice_to_stock 8600 8500 100 1.16 0 9393 18 0 100
v_all_customers 32670 32670 0 0.00 0 44 1 0 0
v_all_suppliers 26680 26680 0 0.00 0 22 1 0 0
v_all_wares 35330 35330 0 0.00 0 42 1 0 0
v_cancel_adding_invoice 704 704 0 0.00 0 296 6 0 0
v_cancel_client_order 3096 3096 0 0.00 0 1873 6 0 0
v_cancel_customer_prepayment 1150 1150 0 0.00 0 1305 5 0 0
v_cancel_customer_reserve 1202 1202 0 0.00 0 379 4 0 0
v_cancel_payment_to_supplier 654 654 0 0.00 0 2162 9 0 0
v_cancel_supplier_invoice 670 648 22 3.28 0 979 16 0 22
v_cancel_supplier_order 708 708 0 0.00 0 2044 14 0 0
v_cancel_write_off 1620 1620 0 0.00 0 909 12 0 0
v_max_id_clo_ord 4563 4563 0 0.00 0 1867 2 0 0
v_max_id_clo_res 886 886 0 0.00 0 1519 11 0 0
v_max_id_ord_sup 4640 4640 0 0.00 0 13779 8 0 0
v_max_non_paid_invoice 1008 1008 0 0.00 0 1797 5 0 0
v_max_non_paid_realizn 2962 2962 0 0.00 0 2323 5 0 0
v_min_id_clo_ord 4563 4563 0 0.00 0 1074 5 0 0
v_min_id_clo_res 886 886 0 0.00 0 4697 17 0 0
v_min_id_ord_sup 4640 4640 0 0.00 0 4931 5 0 0
v_min_non_paid_invoice 5145 5145 0 0.00 0 16853 33 0 0
v_min_non_paid_realizn 6000 6000 0 0.00 0 7610 28 0 0
v_our_firm 8736 8736 0 0.00 0 16 1 0 0
v_reserve_write_off 17206 17206 0 0.00 0 2118 6 0 0
x_lock_depdocs_on_canc_invoice 8674 8674 0 0.00 0 15179 148 0 0
x_lock_depdocs_on_canc_sup_ord 354 354 0 0.00 0 13225 373 0 0
x_make_qstorno_1000_1200 4563 4563 0 0.00 1 61997 1288 0 0
x_make_qstorno_1200_2000 4659 4659 0 0.00 2 79280 3606 0 0
x_make_qstorno_2100_3300 405840 405840 0 0.00 0 92602 191 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 22-02-2024 19:11:06 to 22-02-2024 19:11:11.

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
17:09:44 2 8192000000 8797619568 8808398848 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:46 21392 8192000000 9889980720 10198728704 979346208 10.678 100 88 176 1 1008403616 5388624 23668784
17:12:19 21487 8192000000 9950379616 10269712384 1030982112 11.178 100 92 184 0 1062642400 8088048 23572240
17:13:48 12289 8192000000 9973793296 10301177856 1058616704 11.443 100 87 175 0 1089778640 9496528 21665408
17:15:08 6943 8192000000 10021197312 10365923328 1113476688 11.965 100 77 154 0 1141317120 9583696 18256736
17:16:19 8456 8192000000 10060607648 10420293632 1154999920 12.356 100 79 157 1 1184672320 11672800 17999600
17:17:31 5384 8192000000 10123441936 10491064320 1207349696 12.845 100 81 159 1 1236942512 11882848 17709968
17:18:38 1707 8192000000 10152260064 10527518720 1244851392 13.191 100 74 149 0 1273480944 12124352 16505200
17:19:42 1674 8192000000 10188975968 10569437184 1270137456 13.423 100 92 180 1 1304104272 13939520 20027296
17:20:46 953 8192000000 10205575952 10590871552 1295208272 13.652 100 89 177 1 1327587920 12982144 19397504
17:21:48 1618 8192000000 10206731840 10605002752 1307764880 13.766 100 64 128 1 1331482016 8968512 14748624
17:22:51 5082 8192000000 10200829264 10612477952 1310825440 13.794 100 33 66 1 1324003888 5760352 7418096
17:24:01 7719 8192000000 10205023584 10623942656 1321481264 13.890 100 30 60 0 1334367056 6126848 6758944
17:25:13 62426 8192000000 10213066000 10635730944 1325402944 13.926 100 29 58 1 1337761728 6150048 6208736
17:27:17 7912 8192000000 10230016848 10646462464 1332729504 13.992 100 22 44 1 1343699392 6284960 4684928
17:28:26 7588 8192000000 10227931104 10646843392 1335248912 14.015 100 25 50 0 1347533312 5811184 6473216
17:29:36 65211 8192000000 10243017696 10649313280 1333373168 13.998 100 39 74 0 1348441376 5264000 9804208
17:31:49 6484 8192000000 10229439296 10644426752 1329516752 13.963 100 49 98 0 1349594336 8843040 11234544
17:33:04 7677 8192000000 10249285872 10658111488 1339842320 14.056 100 50 100 1 1361596512 10286656 11467536
17:34:30 3517 8192000000 10248732480 10653814784 1338504112 14.044 100 64 127 2 1366579216 13529408 14545696
17:35:37 17598 8192000000 10249245024 10662625280 1340675408 14.063 100 45 90 0 1366011408 14770160 10565840
17:37:02 25331 8192000000 10255365120 10669641728 1349496464 14.143 100 41 82 0 1373841584 14915728 9429392
17:38:30 33752 8192000000 10266864208 10691645440 1344698720 14.100 99 28 56 1 1373150880 21573344 6878816
17:40:09 11128 8192000000 10221944512 10625744896 1285675296 13.565 97 42 81 1 1313534976 18305776 9553904
17:41:28 12371 8192000000 10225073648 10626609152 1294099040 13.642 99 56 112 0 1329707280 21989520 13618720
17:42:47 3787 8192000000 10241357584 10637930496 1301901760 13.713 99 73 145 1 1342855312 24293520 16660032
17:44:06 14729 8192000000 10263008336 10667634688 1334598624 14.009 100 57 114 1 1371860272 23661136 13600512
17:45:32 7237 8192000000 10261114512 10662764544 1321546752 13.891 99 58 116 0 1362404448 26421296 14436400
17:46:46 2716 8192000000 10290905136 10687942656 1348576320 14.135 100 68 135 1 1395974000 30122560 17275120
17:47:54 3673 8192000000 10306677392 10709278720 1365596672 14.288 100 73 145 0 1411446240 28896064 16953504
17:49:07 7826 8192000000 10313450448 10725085184 1374789888 14.370 100 58 116 1 1416541008 27777952 13973168
17:50:25 8144 8192000000 10322106992 10742730752 1385564544 14.466 100 54 104 0 1431556080 33144224 12847312
17:51:43 19224 8192000000 10317063296 10745446400 1394494416 14.546 100 26 52 0 1426294352 24526352 7273584
17:53:09 3127 8192000000 10337985184 10758246400 1392808896 14.531 100 61 117 1 1443102640 35449280 14844464
17:54:14 42367 8192000000 10323835296 10759118848 1388324048 14.491 100 23 46 0 1429147728 33901360 6922320
17:55:59 8991 8192000000 10316648592 10754650112 1396948880 14.568 100 40 80 2 1425631472 19132928 9549664
17:57:17 11768 8192000000 10334772608 10767413248 1408271680 14.669 100 51 100 0 1440340624 19827552 12241392
17:58:31 19697 8192000000 10336346944 10781380608 1410391216 14.687 100 23 46 0 1444696256 28301136 6003904
17:59:53 55204 8192000000 10312466416 10783465472 1399929056 14.594 100 11 22 2 1425818496 23259632 2629808
18:01:52 62504 8192000000 10334158528 10773803008 1407095440 14.658 100 43 86 0 1427106432 9384496 10626496
18:03:57 41585 8192000000 10303036832 10761854976 1384354336 14.455 98 32 61 0 1399675280 8370240 6950704
18:05:48 90241 8192000000 10331110960 10774290432 1393435552 14.537 98 47 95 1 1419208464 14742704 11030208
18:08:26 15542 8192000000 10344947120 10791636992 1424290752 14.811 100 26 52 0 1448948176 18040032 6617392
18:09:43 47412 8192000000 10348536400 10800537600 1429821296 14.860 100 19 38 0 1456802480 22350560 4630624
18:11:47 36436 8192000000 10321014160 10787622912 1416284176 14.740 100 11 22 0 1437552400 18913168 2355056
18:13:32 20441 8192000000 10308702656 10766639104 1388452960 14.492 98 12 24 0 1404520528 12950896 3116672
18:14:55 62882 8192000000 10306561088 10758529024 1399428752 14.590 99 21 43 1 1415525280 11061232 5035296
18:18:02 34064 8192000000 10310640976 10756206592 1370719056 14.333 98 41 80 0 1397900896 18504528 8677312
18:19:36 73758 8192000000 10290579856 10750410752 1357058976 14.211 97 14 29 0 1379629920 19133728 3437216
18:22:21 39394 8192000000 10269970272 10710450176 1355604192 14.198 99 25 50 1 1368876624 8157024 5115408
18:24:08 72996 8192000000 10263174736 10691780608 1314579712 13.828 97 16 32 1 1330234240 12044976 3609552
18:26:21 32103 8192000000 10265132576 10699878400 1326189008 13.933 98 32 64 0 1345751072 12244256 7317808
18:27:56 71219 8192000000 10258293024 10699710464 1241982736 13.164 92 12 24 0 1262975008 18129840 2862432
18:30:09 155790 8192000000 10254765664 10698063872 1305688432 13.747 97 16 32 2 1319808368 11086944 3032992
18:33:54 11907 8192000000 10263671728 10710192128 1346693872 14.118 99 27 52 0 1369885680 17099760 6092048
18:35:23 18134 8192000000 10273523280 10704887808 1361292576 14.249 100 60 119 1 1388231120 12718320 14220224
18:36:50 33709 8192000000 10255377904 10704596992 1341662272 14.072 99 16 33 0 1356116880 10371664 4082944
18:38:39 36627 8192000000 10252573696 10691256320 1348962032 14.138 100 26 50 0 1363479808 9141072 5376704
18:40:17 64664 8192000000 10268755920 10716299264 1367355040 14.303 100 18 36 2 1385713456 13908896 4449520
18:42:27 65135 8192000000 10252453952 10708393984 1346740864 14.118 98 18 37 0 1361361360 10526768 4093728
18:44:33 64281 8192000000 10278720880 10733211648 1341899648 14.075 97 24 48 0 1356699328 9696192 5103488
18:46:39 38652 8192000000 10302333808 10750300160 1388786912 14.495 100 24 48 2 1403531568 9587200 5157456
18:48:29 38269 8192000000 10306373120 10758324224 1398842752 14.585 100 17 34 0 1414477456 11577952 4056752
18:50:13 56947 8192000000 10308201136 10770427904 1399974848 14.595 100 20 40 0 1420076208 15148800 4952560
18:52:11 45837 8192000000 10301941840 10759225344 1385474640 14.465 99 17 34 0 1403681088 14728528 3477920
18:53:58 56024 8192000000 10327175888 10772492288 1406600928 14.654 100 28 57 1 1422782624 10240448 5941248
18:55:56 78167 8192000000 10333914160 10800361472 1415526960 14.733 100 20 40 0 1434605216 14370448 4707808
18:58:15 123685 8192000000 10297584464 10745651200 1391729264 14.521 99 22 42 1 1408098048 11642496 4726288
19:01:25 41990 8192000000 10286148656 10745835520 1385207408 14.463 99 25 50 0 1399643248 8870064 5565776
19:03:12 32436 8192000000 10291441232 10751729664 1382615792 14.440 99 4 8 0 1389710720 6143952 950976
19:04:44 67315 8192000000 10286409216 10747195392 1375172192 14.373 99 23 46 0 1390993472 10056688 5764592
19:08:21 53668 8192000000 10262856096 10713038848 1307062144 13.759 95 29 59 2 1321023632 7316288 6645200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 22-02-2024 19:11:13 to 22-02-2024 19:11:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 50 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-02-2024 19:11:27 to 22-02-2024 19:11:29.

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          174579
MON$OLDEST_ACTIVE               176066
MON$OLDEST_SNAPSHOT             176066
MON$NEXT_TRANSACTION            176066
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                       1910048
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 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 Thu Feb 22 19:11:30 2024 
 
Database header page information: 
    Flags            0 
    Generation        91668 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174579 
    Oldest active        176066 
    Oldest snapshot        176066 
    Next transaction    176067 
    Sequence number        0 
    Next attachment ID    712 
    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.39, total records: 7785098 
    Average version length: 48.16, total versions: 81838, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87112 
    Data pages: 87112, average fill: 71% 
    Primary pages: 87112, secondary pages: 0, swept pages: 20479 
    Empty pages: 5, full pages: 65364 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 160 
    40 - 59% = 2374 
    60 - 79% = 84531 
    80 - 99% = 16 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23378, nodes: 7785098 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1722564, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 384 
        20 - 39% = 1762 
        40 - 59% = 4096 
        60 - 79% = 2356 
        80 - 99% = 14780 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13541, nodes: 7785098 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1545583, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1591 
        40 - 59% = 1995 
        60 - 79% = 1068 
        80 - 99% = 8887 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8380, nodes: 7785098 
    Average node length: 6.63, total dup: 5809995, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1538449, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 959 
        40 - 59% = 1371 
        60 - 79% = 910 
        80 - 99% = 4997 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.41, total records: 2265547 
    Average version length: 34.53, total versions: 82557, max versions: 3 
    Average fragment length: 7.33, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28880 
    Data pages: 28880, average fill: 73% 
    Primary pages: 28874, secondary pages: 6, swept pages: 10934 
    Empty pages: 5, full pages: 20428 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 145 
    40 - 59% = 2304 
    60 - 79% = 25776 
    80 - 99% = 629 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4566, nodes: 2265547 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 694690, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 899 
        40 - 59% = 831 
        60 - 79% = 740 
        80 - 99% = 2096 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2565, nodes: 2267797 
    Average node length: 4.97, total dup: 2266898, max dup: 20341 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1246252, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 275 
        40 - 59% = 1611 
        60 - 79% = 490 
        80 - 99% = 188 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2039, nodes: 2265547 
    Average node length: 4.97, total dup: 2265497, max dup: 130280 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1072292, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 105 
        40 - 59% = 1011 
        60 - 79% = 47 
        80 - 99% = 869 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4377, nodes: 2265547 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 694690, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 592 
        40 - 59% = 597 
        60 - 79% = 821 
        80 - 99% = 2260 
 
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.25, total records: 400 
    Average version length: 23.04, total versions: 239884, max versions: 624 
    Average fragment length: 2.00, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1344 
    Data pages: 1344, average fill: 89% 
    Primary pages: 7, secondary pages: 1337, swept pages: 0 
    Empty pages: 0, full pages: 1343 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1341 
 
    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: 11.66, total records: 114127 
    Average version length: 68.29, total versions: 94646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.55 
    Pointer pages: 7, data page slots: 2072 
    Data pages: 1824, average fill: 76% 
    Primary pages: 1823, secondary pages: 1, swept pages: 0 
    Empty pages: 180, full pages: 1472 
    Fill distribution: 
     0 - 19% = 216 
    20 - 39% = 64 
    40 - 59% = 40 
    60 - 79% = 154 
    80 - 99% = 1350 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709137, depth: 3, leaf buckets: 359, nodes: 114128 
    Average node length: 13.32, total dup: 7286, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 82981, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 268 
        60 - 79% = 59 
        80 - 99% = 15 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18787, max versions: 977 
    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: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 5, secondary pages: 67, swept pages: 0 
    Empty pages: 4, full pages: 67 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 9 
    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: 2.71, total records: 1277 
    Average version length: 43.21, total versions: 1200, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 21.43 
    Pointer pages: 1, data page slots: 40 
    Data pages: 24, average fill: 53% 
    Primary pages: 23, secondary pages: 1, swept pages: 0 
    Empty pages: 1, full pages: 7 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90378, depth: 2, leaf buckets: 4, nodes: 1277 
    Average node length: 4.40, total dup: 1179, max dup: 155 
    Average key length: 2.83, compression ratio: 6.72 
    Average prefix length: 18.25, average data length: 0.75 
    Clustering factor: 691, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 2 
        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.07, 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: 35.91, total records: 788079 
    Average version length: 25.51, total versions: 73271, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8056 
    Data pages: 8056, average fill: 69% 
    Primary pages: 8021, secondary pages: 35, swept pages: 1781 
    Empty pages: 90, full pages: 6155 
    Fill distribution: 
     0 - 19% = 163 
    20 - 39% = 154 
    40 - 59% = 372 
    60 - 79% = 7105 
    80 - 99% = 262 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 865, nodes: 788079 
    Average node length: 4.87, total dup: 788030, max dup: 141143 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87867, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 111 
        40 - 59% = 497 
        60 - 79% = 194 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 930, nodes: 788079 
    Average node length: 5.87, total dup: 701964, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156287, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 115 
        40 - 59% = 388 
        60 - 79% = 125 
        80 - 99% = 298 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 958, nodes: 788079 
    Average node length: 5.87, total dup: 701964, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158351, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 209 
        40 - 59% = 337 
        60 - 79% = 115 
        80 - 99% = 297 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1124, nodes: 788079 
    Average node length: 5.95, total dup: 701964, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151688, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 241 
        40 - 59% = 615 
        60 - 79% = 180 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5384 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.57, total fragments: 97, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 77, secondary pages: 19, swept pages: 49 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 67 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5384 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.01 
    Average prefix length: 34.29, average data length: 1.55 
    Clustering factor: 5090, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5384 
    Average node length: 11.14, 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: 151, 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.16, total records: 80620 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 777 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 777 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32561, depth: 2, leaf buckets: 104, nodes: 80620 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3553, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 100 
 
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: 111.22, 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.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 149.10, total records: 184890 
    Average version length: 149.12, total versions: 2687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 5200 
    Data pages: 4440, average fill: 86% 
    Primary pages: 4439, secondary pages: 1, swept pages: 1 
    Empty pages: 45, full pages: 4381 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4381 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 134.68, total records: 178956 
    Average version length: 154.59, total versions: 19234, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.59 
    Pointer pages: 7, data page slots: 5400 
    Data pages: 4320, average fill: 86% 
    Primary pages: 4320, secondary pages: 0, swept pages: 1 
    Empty pages: 62, full pages: 4240 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4239 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 143.65, total records: 149489 
    Average version length: 152.76, total versions: 6875, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.81 
    Pointer pages: 7, data page slots: 4376 
    Data pages: 3568, average fill: 86% 
    Primary pages: 3567, secondary pages: 1, swept pages: 2 
    Empty pages: 28, full pages: 3530 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3531 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 144.69, total records: 185656 
    Average version length: 153.58, total versions: 7932, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 8, data page slots: 5776 
    Data pages: 4472, average fill: 86% 
    Primary pages: 4472, secondary pages: 0, swept pages: 1 
    Empty pages: 57, full pages: 4395 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4394 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 129.87, total records: 165257 
    Average version length: 154.55, total versions: 22871, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.06 
    Pointer pages: 7, data page slots: 4744 
    Data pages: 3944, average fill: 88% 
    Primary pages: 3944, secondary pages: 0, swept pages: 2 
    Empty pages: 18, full pages: 3919 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3919 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.88, total records: 158216 
    Average version length: 148.37, total versions: 2169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 4312 
    Data pages: 3792, average fill: 86% 
    Primary pages: 3792, secondary pages: 0, swept pages: 1 
    Empty pages: 37, full pages: 3745 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3745 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.80, total records: 171215 
    Average version length: 151.03, total versions: 3630, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 6, data page slots: 5072 
    Data pages: 4112, average fill: 86% 
    Primary pages: 4112, secondary pages: 0, swept pages: 1 
    Empty pages: 43, full pages: 4051 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4051 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.90, total records: 187205 
    Average version length: 152.38, total versions: 6349, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 5920 
    Data pages: 4488, average fill: 86% 
    Primary pages: 4488, secondary pages: 0, swept pages: 3 
    Empty pages: 42, full pages: 4432 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4431 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 129.07, total records: 192605 
    Average version length: 154.65, total versions: 27951, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.14 
    Pointer pages: 7, data page slots: 5232 
    Data pages: 4632, average fill: 87% 
    Primary pages: 4632, secondary pages: 0, swept pages: 2 
    Empty pages: 48, full pages: 4571 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4571 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 144.78, total records: 185097 
    Average version length: 152.88, total versions: 7781, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 8, data page slots: 6872 
    Data pages: 4464, average fill: 86% 
    Primary pages: 4464, secondary pages: 0, swept pages: 3 
    Empty pages: 63, full pages: 4384 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4382 
 
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.93, total records: 2121438 
    Average version length: 52.98, total versions: 33162, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25632 
    Data pages: 25632, average fill: 71% 
    Primary pages: 25632, secondary pages: 0, swept pages: 10731 
    Empty pages: 247, full pages: 21137 
    Fill distribution: 
     0 - 19% = 475 
    20 - 39% = 402 
    40 - 59% = 1088 
    60 - 79% = 23396 
    80 - 99% = 271 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2604, nodes: 2121438 
    Average node length: 5.44, total dup: 1979979, max dup: 1740 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183287, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 321 
        40 - 59% = 1683 
        60 - 79% = 302 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2759, nodes: 2121438 
    Average node length: 5.69, total dup: 1904405, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 379071, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 2379 
        60 - 79% = 355 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2152, nodes: 2121438 
    Average node length: 4.96, total dup: 2121338, max dup: 27799 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180924, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 187 
        40 - 59% = 1164 
        60 - 79% = 363 
        80 - 99% = 437 
 
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: 40.70, total records: 163520 
    Average version length: 69.17, total versions: 67378, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 3, data page slots: 4256 
    Data pages: 3159, average fill: 60% 
    Primary pages: 3159, secondary pages: 0, swept pages: 363 
    Empty pages: 458, full pages: 1876 
    Fill distribution: 
     0 - 19% = 650 
    20 - 39% = 162 
    40 - 59% = 222 
    60 - 79% = 852 
    80 - 99% = 1273 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101708, depth: 3, leaf buckets: 263, nodes: 163520 
    Average node length: 6.45, total dup: 142314, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27660, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 72 
        40 - 59% = 123 
        60 - 79% = 61 
        80 - 99% = 7 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.81, total records: 6997522 
    Average version length: 68.79, total versions: 422950, 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: 63, data page slots: 102624 
    Data pages: 102624, average fill: 73% 
    Primary pages: 102624, secondary pages: 0, swept pages: 27866 
    Empty pages: 21, full pages: 71604 
    Fill distribution: 
     0 - 19% = 150 
    20 - 39% = 960 
    40 - 59% = 8076 
    60 - 79% = 87751 
    80 - 99% = 5687 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10673, nodes: 6997522 
    Average node length: 6.51, total dup: 6050867, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1551148, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1830 
        40 - 59% = 5745 
        60 - 79% = 2538 
        80 - 99% = 554 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8441, nodes: 6997522 
    Average node length: 5.40, total dup: 6715968, max dup: 166 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1347726, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1279 
        40 - 59% = 4450 
        60 - 79% = 1616 
        80 - 99% = 1086 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8490, nodes: 6997522 
    Average node length: 5.40, total dup: 6715968, max dup: 166 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1350364, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1309 
        40 - 59% = 4464 
        60 - 79% = 1632 
        80 - 99% = 1079 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.11, total records: 11922079 
    Average version length: 68.75, total versions: 320391, 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: 103, data page slots: 167344 
    Data pages: 167344, average fill: 76% 
    Primary pages: 167344, secondary pages: 0, swept pages: 80664 
    Empty pages: 9, full pages: 146041 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 439 
    40 - 59% = 4554 
    60 - 79% = 157227 
    80 - 99% = 5090 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18294, nodes: 11922079 
    Average node length: 6.58, total dup: 10391784, max dup: 67 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2351921, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2454 
        40 - 59% = 10919 
        60 - 79% = 4021 
        80 - 99% = 876 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 44.02, total records: 1572773 
    Average version length: 69.14, total versions: 571849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.86 
    Pointer pages: 26, data page slots: 41552 
    Data pages: 30232, average fill: 60% 
    Primary pages: 30232, secondary pages: 0, swept pages: 9929 
    Empty pages: 3659, full pages: 17192 
    Fill distribution: 
     0 - 19% = 5807 
    20 - 39% = 2567 
    40 - 59% = 2403 
    60 - 79% = 11162 
    80 - 99% = 8293 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2267, nodes: 1572773 
    Average node length: 5.52, total dup: 1508408, max dup: 49 
    Average key length: 2.57, compression ratio: 16.35 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 106861, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 734 
        40 - 59% = 1103 
        60 - 79% = 348 
        80 - 99% = 71 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.55, total records: 1119142 
    Average version length: 69.13, total versions: 477693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.19 
    Pointer pages: 20, data page slots: 32496 
    Data pages: 28232, average fill: 46% 
    Primary pages: 28232, secondary pages: 0, swept pages: 7297 
    Empty pages: 6165, full pages: 12525 
    Fill distribution: 
     0 - 19% = 10309 
    20 - 39% = 2941 
    40 - 59% = 1701 
    60 - 79% = 4072 
    80 - 99% = 9209 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1601, nodes: 1119142 
    Average node length: 5.78, total dup: 1045534, max dup: 99 
    Average key length: 2.85, compression ratio: 14.75 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 149195, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 448 
        40 - 59% = 745 
        60 - 79% = 319 
        80 - 99% = 84 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.72, total records: 9325125 
    Average version length: 69.00, total versions: 430564, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 88, data page slots: 143568 
    Data pages: 143552, average fill: 69% 
    Primary pages: 143552, secondary pages: 0, swept pages: 58234 
    Empty pages: 292, full pages: 85367 
    Fill distribution: 
     0 - 19% = 1051 
    20 - 39% = 5741 
    40 - 59% = 20404 
    60 - 79% = 110197 
    80 - 99% = 6159 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13494, nodes: 9325125 
    Average node length: 6.68, total dup: 7734819, max dup: 21 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2007917, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1186 
        40 - 59% = 6702 
        60 - 79% = 4844 
        80 - 99% = 760 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21145794 
    Average version length: 82.89, total versions: 9956, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318736 
    Data pages: 318736, average fill: 81% 
    Primary pages: 318736, secondary pages: 0, swept pages: 13140 
    Empty pages: 35, full pages: 317928 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 35 
    40 - 59% = 90 
    60 - 79% = 27780 
    80 - 99% = 290769 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19327, nodes: 21145794 
    Average node length: 5.72, total dup: 20664710, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281748, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8026 
        60 - 79% = 559 
        80 - 99% = 10736 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17185, nodes: 21145794 
    Average node length: 6.31, total dup: 18583523, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915071, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 810 
        60 - 79% = 266 
        80 - 99% = 16101 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21114, nodes: 21145794 
    Average node length: 6.35, total dup: 18501369, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575630, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8295 
        60 - 79% = 633 
        80 - 99% = 12180 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16090, nodes: 21145794 
    Average node length: 5.56, total dup: 21145694, max dup: 229744 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943693, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2848 
        60 - 79% = 421 
        80 - 99% = 12811 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.42, total records: 9707611 
    Average version length: 82.69, total versions: 353064, 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: 106, data page slots: 171520 
    Data pages: 171472, average fill: 70% 
    Primary pages: 171472, secondary pages: 0, swept pages: 83608 
    Empty pages: 452, full pages: 97578 
    Fill distribution: 
     0 - 19% = 1535 
    20 - 39% = 8113 
    40 - 59% = 27541 
    60 - 79% = 72792 
    80 - 99% = 61491 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11394, nodes: 9707611 
    Average node length: 5.37, total dup: 9398951, max dup: 184 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2111759, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 97 
        40 - 59% = 8156 
        60 - 79% = 3066 
        80 - 99% = 72 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13558, nodes: 9707611 
    Average node length: 6.24, total dup: 8047786, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1454980, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 4006 
        40 - 59% = 4312 
        60 - 79% = 2650 
        80 - 99% = 2453 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12713, nodes: 9707611 
    Average node length: 5.99, total dup: 8423714, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2303794, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 105 
        40 - 59% = 9206 
        60 - 79% = 3309 
        80 - 99% = 92 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10246, nodes: 9707611 
    Average node length: 5.14, total dup: 9707511, max dup: 163965 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1489829, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1297 
        40 - 59% = 5180 
        60 - 79% = 1684 
        80 - 99% = 2044 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.35, total records: 11381898 
    Average version length: 82.64, total versions: 268931, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 194200 
    Data pages: 192904, average fill: 72% 
    Primary pages: 192904, secondary pages: 0, swept pages: 75890 
    Empty pages: 3123, full pages: 142267 
    Fill distribution: 
     0 - 19% = 5459 
    20 - 39% = 8144 
    40 - 59% = 18983 
    60 - 79% = 44130 
    80 - 99% = 116188 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13144, nodes: 11381898 
    Average node length: 5.30, total dup: 11272091, max dup: 648 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2371198, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 156 
        40 - 59% = 8914 
        60 - 79% = 3896 
        80 - 99% = 176 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10492, nodes: 11381898 
    Average node length: 5.50, total dup: 10884554, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714042, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 850 
        40 - 59% = 2587 
        60 - 79% = 1840 
        80 - 99% = 5085 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15027, nodes: 11381898 
    Average node length: 6.03, total dup: 9932125, max dup: 64 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2387712, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 156 
        40 - 59% = 10469 
        60 - 79% = 4188 
        80 - 99% = 210 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10769, nodes: 11381898 
    Average node length: 5.23, total dup: 11381798, max dup: 197743 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 703428, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 837 
        40 - 59% = 4719 
        60 - 79% = 1470 
        80 - 99% = 3647 
 
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: 79.86, total records: 9811815 
    Average version length: 82.94, total versions: 341221, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 107, data page slots: 174192 
    Data pages: 174136, average fill: 70% 
    Primary pages: 174136, secondary pages: 0, swept pages: 86575 
    Empty pages: 717, full pages: 101187 
    Fill distribution: 
     0 - 19% = 2058 
    20 - 39% = 8594 
    40 - 59% = 27827 
    60 - 79% = 72813 
    80 - 99% = 62844 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11915, nodes: 9811815 
    Average node length: 5.18, total dup: 9782818, max dup: 2212 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1930855, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1540 
        40 - 59% = 7928 
        60 - 79% = 1814 
        80 - 99% = 595 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13698, nodes: 9811815 
    Average node length: 6.25, total dup: 8133888, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1443509, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 4047 
        40 - 59% = 4256 
        60 - 79% = 2662 
        80 - 99% = 2562 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12545, nodes: 9811815 
    Average node length: 5.43, total dup: 9371389, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2066400, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1462 
        40 - 59% = 8920 
        60 - 79% = 1576 
        80 - 99% = 566 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10337, nodes: 9811815 
    Average node length: 5.15, total dup: 9811715, max dup: 165587 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1526327, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1308 
        40 - 59% = 5199 
        60 - 79% = 1690 
        80 - 99% = 2102 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 578829 
    Average version length: 68.82, total versions: 2796, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 76% 
    Primary pages: 8016, secondary pages: 0, swept pages: 4057 
    Empty pages: 5, full pages: 6848 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 18 
    40 - 59% = 190 
    60 - 79% = 7760 
    80 - 99% = 41 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41534, depth: 3, leaf buckets: 743, nodes: 578829 
    Average node length: 5.95, total dup: 492787, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100822, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 535 
        60 - 79% = 92 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29572, depth: 3, leaf buckets: 766, nodes: 578829 
    Average node length: 6.15, total dup: 474597, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100875, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 546 
        60 - 79% = 90 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 578, nodes: 578829 
    Average node length: 4.86, total dup: 578729, max dup: 9680 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89584, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 353 
        60 - 79% = 88 
        80 - 99% = 118 
 
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 Thu Feb 22 19:11:54 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7785098 81838 1 0.0000 0.0000
DOC_LIST 2265547 82557 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 239884 624 59900.0000 0.0000
INVNT_TURNOVER_LOG 114127 94646 1 0.0000 0.0000
MONEY_SALDO 49 18787 977 38300.0000 0.0000
MONEY_TURNOVER_LOG 1277 1200 1 0.0000 0.0000
PDISTR 788079 73271 4 0.0000 0.0000
PERF_SPLIT_0 184890 2687 1 0.0000 0.0000
PERF_SPLIT_1 178956 19234 1 0.0000 0.0000
PERF_SPLIT_2 149489 6875 1 0.0000 0.0000
PERF_SPLIT_3 185656 7932 1 0.0000 0.0000
PERF_SPLIT_4 165257 22871 1 0.0000 0.0000
PERF_SPLIT_5 158216 2169 1 0.0000 0.0000
PERF_SPLIT_6 171215 3630 1 0.0000 0.0000
PERF_SPLIT_7 187205 6349 1 0.0000 0.0000
PERF_SPLIT_8 192605 27951 1 0.0000 0.0000
PERF_SPLIT_9 185097 7781 1 0.0000 0.0000
PSTORNED 2121438 33162 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 163520 67378 1 0.0000 0.0000
XQD_1000_3300 6997522 422950 1 0.0000 0.0000
XQD_1200_2000 11922079 320391 1 0.0000 0.0000
XQD_2000_3300 1572773 571849 1 0.0000 0.0000
XQD_2100_3300 1119142 477693 1 0.0000 0.0000
XQD_3300_3400 9325125 430564 1 0.0000 0.0000
XQS_1000_1200 21145794 9956 1 0.0000 0.0000
XQS_1000_3300 9707611 353064 1 0.0000 0.0000
XQS_1200_2000 11381898 268931 1 0.0000 0.0000
XQS_2100_3300 9811815 341221 1 0.0000 0.0000
XQS_3300_3400 578829 2796 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 ---
:985: 
:986: mscs-test-161.budzdorov.ru    Thu Feb 22 19:09:42 2024
:987:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:988: 
:989: 
:990: mscs-test-161.budzdorov.ru    Thu Feb 22 19:09:45 2024
:991:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:992: 
:993: 
:994: mscs-test-161.budzdorov.ru    Thu Feb 22 19:09:46 2024
:995:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:996: 
--- end of diff output ---

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

22.02.24 19:12:06. 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-02-22 19:12:09 No severe PSQL-related problems occured
22.02.24 19:12:10. End of report.