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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-04 07:07:50
DTS_END                         2024-04-04 07:07:50.1480
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(68:17)
IP                              ::1/48154
TRN_ID                          164686
ATT_ID                          510
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: 9114.15 20748 911415
customer order: creation 164.84 444 16484
customer order: refuse 14.07 365 1407
order to supplier: creation 44.61 1408 4461
order to supplier: removal 3.47 93713 347
invoice (draft): creation 45.50 3129 4550
invoice (draft): removal 51.23 680 5123
invoice accept: apply 40.99 20814 4099
invoice accept: cancel 46.72 833 4672
customer reserve: creation 3896.92 201 389692
customer reserve: removal 4521.30 58 452130
realization accept: apply 80.19 223 8019
realization accept: cancel 79.97 119 7997
payment from customer: creation 57.18 124 5718
payment from customer: removal 5.85 76 585
payment to supplier: creation 47.20 156 4720
payment to supplier: removal 3.09 117 309
service: total inventory turnovers 3.74 3757 374
service: total monetary turnovers 6.22 598 622
service: aggregate perf. data 1.03 11111 103
service: refresh index statistics 0.03 277026 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2024 07:08:40 to 04-04-2024 07:08:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2699
TEST_TIME 2 3478
TEST_TIME 3 5049
TEST_TIME 4 3956
TEST_TIME 5 4215
TEST_TIME 6 4732
TEST_TIME 7 5485
TEST_TIME 8 5475
TEST_TIME 9 5682
TEST_TIME 10 5709
TEST_TIME 11 6090
TEST_TIME 12 6090
TEST_TIME 13 6253
TEST_TIME 14 6710
TEST_TIME 15 7059
TEST_TIME 16 6946
TEST_TIME 17 7144
TEST_TIME 18 7362
TEST_TIME 19 7516
TEST_TIME 20 7647
TEST_TIME 21 7918
TEST_TIME 22 8145
TEST_TIME 23 8443
TEST_TIME 24 9065
TEST_TIME 25 9603
TEST_TIME 26 9393
TEST_TIME 27 9159
TEST_TIME 28 8976
TEST_TIME 29 8803
TEST_TIME 30 8783
TEST_TIME 31 8735
TEST_TIME 32 8614
TEST_TIME 33 8405
TEST_TIME 34 8372
TEST_TIME 35 8198
TEST_TIME 36 8286
TEST_TIME 37 8208
TEST_TIME 38 8357
TEST_TIME 39 8315
TEST_TIME 40 8797
TEST_TIME 41 8737
TEST_TIME 42 8868
TEST_TIME 43 8859
TEST_TIME 44 9058
TEST_TIME 45 8984
TEST_TIME 46 9019
TEST_TIME 47 8994
TEST_TIME 48 9131
TEST_TIME 49 9080
TEST_TIME 50 9084
TEST_TIME 51 8961
TEST_TIME 52 8896
TEST_TIME 53 8861
TEST_TIME 54 8827
TEST_TIME 55 8736
TEST_TIME 56 8653
TEST_TIME 57 8719
TEST_TIME 58 8755
TEST_TIME 59 8761
TEST_TIME 60 8744
TEST_TIME 61 8740
TEST_TIME 62 8899
TEST_TIME 63 8860
TEST_TIME 64 9134
TEST_TIME 65 9276
TEST_TIME 66 9239
TEST_TIME 67 9266
TEST_TIME 68 9166
TEST_TIME 69 9104
TEST_TIME 70 9061
TEST_TIME 71 8991
TEST_TIME 72 8995
TEST_TIME 73 8994
TEST_TIME 74 9060
TEST_TIME 75 9033
TEST_TIME 76 9004
TEST_TIME 77 8955
TEST_TIME 78 9144
TEST_TIME 79 9144
TEST_TIME 80 9127
TEST_TIME 81 9160
TEST_TIME 82 9157
TEST_TIME 83 9233
TEST_TIME 84 9289
TEST_TIME 85 9306
TEST_TIME 86 9301
TEST_TIME 87 9208
TEST_TIME 88 9135
TEST_TIME 89 9159
TEST_TIME 90 9172
TEST_TIME 91 9120
TEST_TIME 92 9086
TEST_TIME 93 9026
TEST_TIME 94 9074
TEST_TIME 95 9081
TEST_TIME 96 9050
TEST_TIME 97 9040
TEST_TIME 98 9117
TEST_TIME 99 9120
TEST_TIME 100 9119

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-04-2024 07:08:43 to 04-04-2024 07:08:47.

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 1267365 1267365 0 0.00 0 29424 7 0 0
doc_list_biud 1267363 1267363 0 0.00 0 29526 26 0 0
sp_add_invoice_to_stock 4215 4099 116 2.75 33 229494 20814 0 116
sp_cancel_adding_invoice 4672 4672 0 0.00 4 42509 833 0 0
sp_cancel_client_order 1407 1407 0 0.00 3 6005 365 0 0
sp_cancel_customer_reserve 452130 452130 0 0.00 0 29527 58 0 0
sp_cancel_pay_from_customer 585 585 0 0.00 2 2624 77 0 0
sp_cancel_pay_to_supplier 309 309 0 0.00 3 7142 118 0 0
sp_cancel_supplier_invoice 5133 5123 10 0.19 1 29006 680 0 10
sp_cancel_supplier_order 347 347 0 0.00 6 883903 93713 0 0
sp_cancel_write_off 7997 7997 0 0.00 1 9337 120 0 0
sp_client_order 16484 16484 0 0.00 3 30398 445 0 0
sp_customer_reserve 389692 389692 0 0.00 0 64929 202 0 0
sp_fill_shopping_cart 25489 25489 0 0.00 1 15404 42 0 0
sp_fill_shopping_cart_clo_res 389686 389686 0 0.00 0 26739 18 0 0
sp_get_clo_for_invoice 4089 4089 0 0.00 0 25184 403 0 0
sp_kill_cost_storno 13563 13563 0 0.00 0 29415 66 0 0
sp_kill_qstorno_ret_qs2qd 917727 917727 0 0.00 0 29385 31 0 0
sp_kill_qty_storno 483782 483782 0 0.00 0 29524 68 0 0
sp_lock_selected_doc 16811 16811 0 0.00 0 8145 6 0 0
sp_make_cost_storno 22545 22545 0 0.00 0 17057 74 0 0
sp_multiply_rows_for_pdistr 22543 22543 0 0.00 0 8971 40 0 0
sp_multiply_rows_for_qdistr 16484 16484 0 0.00 0 29430 237 0 0
sp_pay_from_customer 5718 5718 0 0.00 4 13201 124 0 0
sp_pay_to_supplier 4720 4720 0 0.00 4 11620 157 0 0
sp_payment_common 10437 10437 0 0.00 1 11612 24 0 0
sp_qd_handle_on_cancel_clo 1407 1407 0 0.00 0 5999 339 0 0
sp_qd_handle_on_invoice_upd_sts 8759 8759 0 0.00 0 27380 324 0 0
sp_qd_handle_on_reserve_upd_sts 8019 8019 0 0.00 0 17275 64 0 0
sp_reserve_write_off 8019 8019 0 0.00 6 18724 223 0 0
sp_supplier_invoice 4550 4550 0 0.00 5 71595 3130 0 0
sp_supplier_order 4461 4461 0 0.00 4 53281 1409 0 0
srv_aggregate_perf_data 103 103 0 0.00 1606 124016 11111 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1183 110918 45195 0 0
srv_find_qd_qs_mism 869912 869912 0 0.00 0 22912 6 0 0
srv_make_invnt_saldo 374 374 0 0.00 38 80760 3757 0 0
srv_make_money_saldo 622 622 0 0.00 1 11509 599 0 0
srv_recalc_idx_stat 3 3 0 0.00 203930 366774 277026 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4099 4099 0 0.00 0 13614 180 0 0
t$perf-norm:sp_cancel_adding_invoice 378 378 0 0.00 0 2854 88 0 0
t$perf-norm:sp_cancel_client_order 1407 1407 0 0.00 0 4621 20 0 0
t$perf-norm:sp_cancel_customer_reserve 557 557 0 0.00 0 2747 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 585 585 0 0.00 0 2979 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 309 309 0 0.00 0 777 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 314 314 0 0.00 0 9081 54 0 0
t$perf-norm:sp_cancel_supplier_order 347 347 0 0.00 0 22341 1588 0 0
t$perf-norm:sp_cancel_write_off 808 808 0 0.00 0 4616 14 0 0
t$perf-norm:sp_client_order 16484 16484 0 0.00 0 9442 19 0 0
t$perf-norm:sp_customer_reserve 790 790 0 0.00 0 3892 10 0 0
t$perf-norm:sp_pay_from_customer 5718 5718 0 0.00 0 3516 7 0 0
t$perf-norm:sp_pay_to_supplier 4720 4720 0 0.00 0 13639 13 0 0
t$perf-norm:sp_reserve_write_off 8019 8019 0 0.00 0 9627 13 0 0
t$perf-norm:sp_supplier_invoice 4550 4550 0 0.00 0 5790 20 0 0
t$perf-norm:sp_supplier_order 4461 4461 0 0.00 0 7874 23 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 223 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 13 1 0 0
t$perf-norm:srv_make_invnt_saldo 374 374 0 0.00 0 4621 28 0 0
t$perf-norm:srv_make_money_saldo 622 622 0 0.00 0 2542 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 157 63 0 0
v_add_invoice_to_stock 8406 8174 232 2.75 0 4450 18 0 232
v_all_customers 30694 30694 0 0.00 0 21 1 0 0
v_all_suppliers 25286 25286 0 0.00 0 27 1 0 0
v_all_wares 32962 32962 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 756 756 0 0.00 0 1903 11 0 0
v_cancel_client_order 2814 2814 0 0.00 0 2597 7 0 0
v_cancel_customer_prepayment 1170 1170 0 0.00 0 2596 9 0 0
v_cancel_customer_reserve 1114 1114 0 0.00 0 642 4 0 0
v_cancel_payment_to_supplier 618 618 0 0.00 0 1453 6 0 0
v_cancel_supplier_invoice 648 628 20 3.08 0 866 13 0 20
v_cancel_supplier_order 694 694 0 0.00 0 492 4 0 0
v_cancel_write_off 1616 1616 0 0.00 0 1620 13 0 0
v_max_id_clo_ord 4460 4460 0 0.00 0 776 2 0 0
v_max_id_clo_res 790 790 0 0.00 0 10390 23 0 0
v_max_id_ord_sup 4547 4547 0 0.00 0 5413 7 0 0
v_max_non_paid_invoice 1081 1081 0 0.00 0 1285 4 0 0
v_max_non_paid_realizn 2758 2758 0 0.00 0 1713 4 0 0
v_min_id_clo_ord 4460 4460 0 0.00 0 8586 11 0 0
v_min_id_clo_res 790 790 0 0.00 0 3674 11 0 0
v_min_id_ord_sup 4547 4547 0 0.00 0 4241 7 0 0
v_min_non_paid_invoice 4719 4719 0 0.00 0 11609 16 0 0
v_min_non_paid_realizn 5718 5718 0 0.00 0 5815 19 0 0
v_our_firm 8188 8188 0 0.00 0 34 1 0 0
v_reserve_write_off 16038 16038 0 0.00 0 4354 7 0 0
x_lock_depdocs_on_canc_invoice 9481 9481 0 0.00 0 9912 108 0 0
x_lock_depdocs_on_canc_sup_ord 347 347 0 0.00 0 3951 320 0 0
x_make_qstorno_1000_1200 4461 4461 0 0.00 1 53275 1332 0 0
x_make_qstorno_1200_2000 4550 4550 0 0.00 2 70466 2969 0 0
x_make_qstorno_2100_3300 389692 389692 0 0.00 0 64928 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-04-2024 07:08:48 to 04-04-2024 07:08:52.

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
05:07:54 13 8192000000 8808777344 8823828480 12598544 0.153 4 4 5 0 12861104 150016 112544
05:08:55 38616 8192000000 9719097904 10017681408 797198720 8.868 100 88 176 0 826900400 7743936 21957744
05:10:36 19912 8192000000 9756550736 10066673664 833907696 9.239 100 90 180 0 866893792 11985872 21000224
05:12:03 14784 8192000000 9788536640 10109833216 862619360 9.526 100 78 155 1 896274240 16774112 16880768
05:13:32 9465 8192000000 9851009296 10184536064 902021568 9.918 100 73 145 1 962622576 45452688 15148320
05:14:50 7786 8192000000 9883897072 10228244480 938450752 10.278 100 82 163 0 998809424 43463744 16894928
05:16:00 4285 8192000000 9941954496 10294329344 972806416 10.614 100 78 156 1 1047235808 59077312 15352080
05:17:06 2282 8192000000 9985427264 10344476672 1000679456 10.885 100 87 173 1 1093194880 75779312 16736112
05:18:11 2216 8192000000 9975063632 10347081728 1026764624 11.137 100 81 161 1 1092524256 50533136 15226496
05:19:15 1695 8192000000 10033251200 10406187008 1049321168 11.354 100 91 183 0 1142126160 75236864 17568128
05:20:18 3654 8192000000 10033910816 10428760064 1059561920 11.452 100 52 102 0 1147940880 78906816 9472144
05:21:24 6442 8192000000 10006498320 10394574848 1065468640 11.509 100 51 103 2 1114226288 38869552 9888096
05:22:36 2707 8192000000 9984033088 10382626816 1074411168 11.594 100 48 96 0 1106314944 22193984 9709792
05:23:41 7388 8192000000 9997485904 10403995648 1077142608 11.620 100 29 59 0 1107257120 24518496 5596016
05:24:49 11650 8192000000 10015550720 10426351616 1081488432 11.662 100 31 62 0 1103699232 15602048 6608752
05:26:04 19500 8192000000 9997757488 10403516416 1084381072 11.689 100 23 44 0 1107753392 18254272 5118048
05:27:24 5436 8192000000 10006571504 10413211648 1087656176 11.720 100 20 40 1 1125662144 33958720 4047248
05:28:33 24092 8192000000 10048725104 10450542592 1099840048 11.836 100 56 110 0 1140021360 29125584 11055728
05:30:02 10920 8192000000 10072763008 10479218688 1099465280 11.833 99 47 94 0 1186506880 77589264 9452336
05:31:17 65805 8192000000 10084753792 10504196096 1116441200 11.993 100 52 104 2 1181584240 54124720 11018320
05:33:34 16329 8192000000 10100846272 10517467136 1102112208 11.858 99 42 84 1 1213545184 102662288 8770688
05:34:56 43442 8192000000 10150197136 10565107712 1127517632 12.098 99 54 108 0 1253079968 114693296 10869040
05:36:42 14736 8192000000 10133140784 10549768192 1121273568 12.039 99 41 80 0 1243408768 113224656 8910544
05:38:01 11657 8192000000 10113576192 10525003776 1094984608 11.790 98 29 59 0 1219182384 118191728 6006048
05:39:31 12831 8192000000 10133088464 10547503104 1109122704 11.924 100 54 108 0 1234839488 114259200 11457584
05:40:46 4407 8192000000 10159485552 10549501952 1080209440 11.649 99 70 140 0 1253679568 159193280 14276848
05:41:55 5268 8192000000 10134641408 10523938816 1082400544 11.670 100 71 138 0 1240641744 143371200 14870000
05:43:06 6802 8192000000 10180144976 10570231808 1097647824 11.815 100 59 113 0 1265941616 155605632 12688160
05:44:17 9900 8192000000 10220612048 10627362816 1086705920 11.711 100 60 120 0 1323219392 223430736 13082736
05:45:40 1929 8192000000 10202957248 10590027776 1094503056 11.785 100 83 162 2 1298347360 186038688 17805616
05:46:48 4354 8192000000 10246789568 10641678336 1107982272 11.913 100 84 168 1 1349772576 223366096 18424208
05:47:57 1176 8192000000 10299036480 10696052736 1119832896 12.025 100 81 162 0 1392800960 254436592 18531472
05:49:01 13285 8192000000 10264914064 10709110784 1126740816 12.091 100 32 64 0 1385350656 251246064 7363776
05:50:40 16652 8192000000 10204480896 10705342464 1110863744 11.941 100 19 38 0 1346289152 230467776 4957632
05:52:00 46509 8192000000 10055988736 10566516736 1094851152 11.789 99 9 17 0 1211111024 114471280 1788592
05:53:49 95440 8192000000 10044911424 10472185856 1111397120 11.946 100 30 57 0 1149025120 31227184 6400816
05:56:33 64116 8192000000 10040495344 10517389312 1102351776 11.860 99 14 28 1 1149979632 44691584 2936272
05:58:43 42011 8192000000 10057657664 10513080320 1119936912 12.026 100 16 32 0 1174659552 51518944 3203696
06:01:24 71837 8192000000 10121267504 10580000768 1127002192 12.093 100 8 16 0 1217124464 88491856 1630416
06:03:42 45915 8192000000 10166532576 10598838272 1143390464 12.247 100 27 54 0 1256531456 106496544 6644448
06:05:30 61864 8192000000 10189453536 10629595136 1144916256 12.262 100 22 44 0 1294398720 144880768 4601696
06:08:02 20161 8192000000 10070647504 10497531904 1146360800 12.275 100 54 109 0 1176147920 19139136 10647984
06:09:47 45439 8192000000 10080820064 10512351232 1139629552 12.212 99 10 18 0 1162546016 21227264 1689200
06:11:34 83229 8192000000 10079912240 10506317824 1135114672 12.170 98 23 44 0 1173260528 32926896 5218960
06:13:59 56693 8192000000 10087813728 10524454912 1112932304 11.960 97 24 46 0 1151784384 32965888 5886192
06:15:56 60573 8192000000 10088865984 10528141312 1112574416 11.957 97 26 52 0 1152827904 35115056 5138432
06:18:00 110918 8192000000 10080055280 10539724800 1134267888 12.162 99 32 64 0 1188570928 48226512 6076528
06:20:52 23795 8192000000 10063041456 10501505024 1119043088 12.018 98 17 32 0 1159775136 37345472 3386576
06:22:21 97659 8192000000 10109527136 10566623232 1115151248 11.981 99 15 27 0 1199320944 81134080 3035616
06:25:11 22372 8192000000 10044053728 10478166016 1099738912 11.835 99 12 24 0 1142685200 40113216 2833072
06:26:41 18992 8192000000 10073113568 10502356992 1077739568 11.626 96 20 40 0 1146099536 63987520 4372448
06:28:03 38934 8192000000 10142866352 10568724480 1083059184 11.677 98 30 60 0 1222531104 132564976 6906944
06:30:06 44562 8192000000 10208496080 10638483456 1109457392 11.927 100 29 58 0 1273794000 157611936 6724672
06:31:51 65015 8192000000 10022915280 10515202048 1074891504 11.599 98 4 8 0 1165540432 89761216 887712
06:34:00 39596 8192000000 10038970160 10478813184 1063863216 11.493 97 18 36 0 1110898896 43069856 3965824
06:35:47 101032 8192000000 10036421232 10475171840 1039690368 11.262 95 29 58 0 1092325424 47047392 5587664
06:38:34 48755 8192000000 10020982192 10489589760 1088486976 11.728 100 6 12 0 1157987904 68550912 950016
06:40:32 39615 8192000000 10058668064 10515070976 1107039536 11.904 100 11 22 0 1197323200 88258880 2024784
06:42:13 75604 8192000000 10084561808 10529083392 1085569408 11.701 97 15 30 0 1125046896 36439824 3037664
06:44:41 44681 8192000000 10079819584 10590912512 1101413984 11.851 99 50 101 1 1210066608 99144192 9508432
06:47:05 48427 8192000000 10081092112 10501754880 1116629200 11.995 99 20 38 0 1161325760 40769488 3927072
06:49:02 9910 8192000000 10104066448 10513219584 1133900752 12.158 100 66 130 0 1194448144 47794880 12752512
06:50:13 88663 8192000000 10084105280 10579673088 1138480432 12.201 100 14 28 0 1212307744 71239264 2588048
06:52:42 83413 8192000000 10060613360 10544611328 1130405808 12.125 99 10 20 0 1166433744 34035296 1992640
06:55:24 106483 8192000000 10097157760 10589392896 1132787136 12.148 99 16 32 0 1200020720 63725232 3508352
06:58:25 69312 8192000000 10076898672 10538942464 1131315568 12.134 99 6 12 0 1157567168 25275616 975984
07:00:35 66164 8192000000 10076851600 10589470720 1145774448 12.270 100 6 12 0 1218141824 71227824 1139552
07:02:42 46037 8192000000 10089396048 10543538176 1139485376 12.211 99 24 48 1 1177585168 33157792 4942000
07:04:28 100877 8192000000 10053373600 10506952704 1095700816 11.797 96 17 35 1 1151571952 51946752 3924384
07:07:11 47035 8192000000 8925586976 9086058496 93268528 1.125 9 4 8 0 98410640 4349200 792912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 04-04-2024 07:08:54 to 04-04-2024 07:09:08.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-04-2024 07:09:09 to 04-04-2024 07:09:11.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Apr  4 07:09:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        86094 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    165143 
    Oldest active        165144 
    Oldest snapshot        165144 
    Next transaction    165145 
    Sequence number        0 
    Next attachment ID    672 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.28, total records: 7708889 
    Average version length: 48.17, total versions: 120303, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88344 
    Data pages: 88344, average fill: 70% 
    Primary pages: 88343, secondary pages: 1, swept pages: 31952 
    Empty pages: 0, full pages: 75599 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 84 
    40 - 59% = 1698 
    60 - 79% = 86457 
    80 - 99% = 88 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22952, nodes: 7708889 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1653740, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 299 
        20 - 39% = 1618 
        40 - 59% = 4032 
        60 - 79% = 2468 
        80 - 99% = 14535 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13371, nodes: 7708889 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1478295, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1469 
        40 - 59% = 2011 
        60 - 79% = 1118 
        80 - 99% = 8773 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8194, nodes: 7708889 
    Average node length: 6.61, total dup: 5777404, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1471466, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 869 
        40 - 59% = 1324 
        60 - 79% = 978 
        80 - 99% = 4916 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.10, total records: 2220877 
    Average version length: 58.84, total versions: 61015, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28920 
    Data pages: 28912, average fill: 71% 
    Primary pages: 28910, secondary pages: 2, swept pages: 8231 
    Empty pages: 80, full pages: 20930 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 102 
    40 - 59% = 2178 
    60 - 79% = 26403 
    80 - 99% = 113 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4491, nodes: 2220877 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 666456, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 889 
        40 - 59% = 814 
        60 - 79% = 773 
        80 - 99% = 2015 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2423, nodes: 2222511 
    Average node length: 4.97, total dup: 2221612, max dup: 18586 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245752, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 223 
        40 - 59% = 1443 
        60 - 79% = 506 
        80 - 99% = 249 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1799, nodes: 2220877 
    Average node length: 4.97, total dup: 2220827, max dup: 129830 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061963, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 636 
        60 - 79% = 48 
        80 - 99% = 1079 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4268, nodes: 2220877 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 666456, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 561 
        40 - 59% = 594 
        60 - 79% = 855 
        80 - 99% = 2177 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.25, total records: 400 
    Average version length: 23.07, total versions: 3255, max versions: 9 
    Average fragment length: 2.33, total fragments: 6, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 66% 
    Primary pages: 8, secondary pages: 24, swept pages: 0 
    Empty pages: 3, full pages: 22 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 20 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 19.53, total records: 66020 
    Average version length: 68.29, total versions: 54304, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.51 
    Pointer pages: 7, data page slots: 2488 
    Data pages: 1888, average fill: 47% 
    Primary pages: 1887, secondary pages: 1, swept pages: 0 
    Empty pages: 403, full pages: 598 
    Fill distribution: 
     0 - 19% = 569 
    20 - 39% = 247 
    40 - 59% = 293 
    60 - 79% = 320 
    80 - 99% = 459 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701544, depth: 3, leaf buckets: 321, nodes: 66020 
    Average node length: 13.55, total dup: 4844, max dup: 1 
    Average key length: 10.74, compression ratio: 2.51 
    Average prefix length: 19.18, average data length: 7.82 
    Clustering factor: 48586, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 238 
        40 - 59% = 76 
        60 - 79% = 5 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 199, max versions: 7 
    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: 2 
    Data pages: 2, average fill: 42% 
    Primary pages: 1, secondary pages: 1, 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_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 15.95, total records: 2252 
    Average version length: 43.13, total versions: 1811, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.64 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 71% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 2, full pages: 24 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92611, depth: 2, leaf buckets: 2, nodes: 2252 
    Average node length: 4.16, total dup: 2154, max dup: 254 
    Average key length: 2.46, compression ratio: 7.72 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1182, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.56, total records: 70 
    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: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.12, total records: 858849 
    Average version length: 37.93, total versions: 32326, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8768 
    Data pages: 8768, average fill: 67% 
    Primary pages: 8767, secondary pages: 1, swept pages: 1245 
    Empty pages: 5, full pages: 8403 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 7 
    40 - 59% = 49 
    60 - 79% = 8642 
    80 - 99% = 63 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 885, nodes: 838493 
    Average node length: 4.89, total dup: 838444, max dup: 166413 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91864, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 119 
        40 - 59% = 468 
        60 - 79% = 183 
        80 - 99% = 113 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 976, nodes: 838493 
    Average node length: 5.89, total dup: 746561, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165897, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 595 
        60 - 79% = 63 
        80 - 99% = 295 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1000, nodes: 838493 
    Average node length: 5.89, total dup: 746561, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167802, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 59 
        40 - 59% = 586 
        60 - 79% = 69 
        80 - 99% = 285 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1162, nodes: 838493 
    Average node length: 5.98, total dup: 746561, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159679, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 209 
        40 - 59% = 639 
        60 - 79% = 223 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5489 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.67, total fragments: 18, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 112 
    Data pages: 102, average fill: 53% 
    Primary pages: 90, secondary pages: 12, swept pages: 49 
    Empty pages: 18, full pages: 52 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5489 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.48, average data length: 1.54 
    Clustering factor: 5282, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5489 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 74674 
    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: 776 
    Data pages: 776, average fill: 66% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 775 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 775 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33376, depth: 2, leaf buckets: 97, nodes: 74674 
    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: 2625, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 92 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.15, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 143.34, total records: 165317 
    Average version length: 152.23, total versions: 8697, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 6, data page slots: 6096 
    Data pages: 4128, average fill: 83% 
    Primary pages: 4126, secondary pages: 2, swept pages: 5 
    Empty pages: 60, full pages: 4041 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4042 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 135.29, total records: 173366 
    Average version length: 153.61, total versions: 19306, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.54 
    Pointer pages: 6, data page slots: 6128 
    Data pages: 4328, average fill: 84% 
    Primary pages: 4325, secondary pages: 3, swept pages: 1 
    Empty pages: 56, full pages: 4255 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4255 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 138.76, total records: 136158 
    Average version length: 152.40, total versions: 11638, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.22 
    Pointer pages: 7, data page slots: 5720 
    Data pages: 3440, average fill: 83% 
    Primary pages: 3438, secondary pages: 2, swept pages: 4 
    Empty pages: 82, full pages: 3326 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 8 
    40 - 59% = 13 
    60 - 79% = 10 
    80 - 99% = 3325 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 115.00, total records: 175342 
    Average version length: 154.09, total versions: 44479, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.75 
    Pointer pages: 7, data page slots: 5672 
    Data pages: 4440, average fill: 85% 
    Primary pages: 4438, secondary pages: 2, swept pages: 2 
    Empty pages: 103, full pages: 4302 
    Fill distribution: 
     0 - 19% = 106 
    20 - 39% = 8 
    40 - 59% = 14 
    60 - 79% = 9 
    80 - 99% = 4303 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 143.22, total records: 184038 
    Average version length: 152.25, total versions: 10641, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 7, data page slots: 4984 
    Data pages: 4576, average fill: 84% 
    Primary pages: 4574, secondary pages: 2, swept pages: 7 
    Empty pages: 36, full pages: 4521 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 9 
    80 - 99% = 4518 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 143.47, total records: 167529 
    Average version length: 152.15, total versions: 8807, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.82 
    Pointer pages: 7, data page slots: 4904 
    Data pages: 4176, average fill: 83% 
    Primary pages: 4174, secondary pages: 2, swept pages: 1 
    Empty pages: 54, full pages: 4099 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4099 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 146.55, total records: 143068 
    Average version length: 150.62, total versions: 4471, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 6, data page slots: 4664 
    Data pages: 3584, average fill: 82% 
    Primary pages: 3581, secondary pages: 3, swept pages: 1 
    Empty pages: 64, full pages: 3503 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3503 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 143.40, total records: 154881 
    Average version length: 151.54, total versions: 8250, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 5, data page slots: 4632 
    Data pages: 3856, average fill: 83% 
    Primary pages: 3853, secondary pages: 3, swept pages: 6 
    Empty pages: 46, full pages: 3792 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3792 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 140.68, total records: 174716 
    Average version length: 151.86, total versions: 13314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.06 
    Pointer pages: 7, data page slots: 4768 
    Data pages: 4392, average fill: 83% 
    Primary pages: 4389, secondary pages: 3, swept pages: 2 
    Empty pages: 78, full pages: 4295 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 4293 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 147.34, total records: 173162 
    Average version length: 150.99, total versions: 4884, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 6, data page slots: 4696 
    Data pages: 4320, average fill: 83% 
    Primary pages: 4318, secondary pages: 2, swept pages: 3 
    Empty pages: 54, full pages: 4249 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4252 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.62, total records: 2070394 
    Average version length: 52.95, total versions: 53120, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25592 
    Data pages: 25576, average fill: 70% 
    Primary pages: 25555, secondary pages: 21, swept pages: 10702 
    Empty pages: 213, full pages: 22173 
    Fill distribution: 
     0 - 19% = 413 
    20 - 39% = 352 
    40 - 59% = 887 
    60 - 79% = 23357 
    80 - 99% = 567 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2557, nodes: 2070394 
    Average node length: 5.44, total dup: 1931071, max dup: 1608 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180588, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 317 
        40 - 59% = 1650 
        60 - 79% = 285 
        80 - 99% = 301 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2745, nodes: 2070394 
    Average node length: 5.69, total dup: 1858127, max dup: 67 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371274, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2478 
        60 - 79% = 230 
        80 - 99% = 30 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2104, nodes: 2070394 
    Average node length: 4.96, total dup: 2070294, max dup: 27220 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178154, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 205 
        40 - 59% = 1097 
        60 - 79% = 375 
        80 - 99% = 426 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 41.60, total records: 153318 
    Average version length: 69.18, total versions: 70340, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 3, data page slots: 4144 
    Data pages: 3263, average fill: 57% 
    Primary pages: 3263, secondary pages: 0, swept pages: 456 
    Empty pages: 587, full pages: 2061 
    Fill distribution: 
     0 - 19% = 861 
    20 - 39% = 171 
    40 - 59% = 120 
    60 - 79% = 828 
    80 - 99% = 1283 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106045, depth: 3, leaf buckets: 224, nodes: 153318 
    Average node length: 6.46, total dup: 133426, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25903, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 119 
        60 - 79% = 58 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.01, total records: 7476476 
    Average version length: 68.74, total versions: 491740, 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: 67, data page slots: 109136 
    Data pages: 109136, average fill: 74% 
    Primary pages: 109135, secondary pages: 1, swept pages: 12049 
    Empty pages: 28, full pages: 99696 
    Fill distribution: 
     0 - 19% = 174 
    20 - 39% = 861 
    40 - 59% = 3056 
    60 - 79% = 102467 
    80 - 99% = 2578 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10794, nodes: 7476476 
    Average node length: 6.51, total dup: 6467194, max dup: 37 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1777533, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1059 
        40 - 59% = 5731 
        60 - 79% = 3404 
        80 - 99% = 586 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8703, nodes: 7476476 
    Average node length: 5.39, total dup: 7187829, max dup: 176 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1565720, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 850 
        40 - 59% = 4919 
        60 - 79% = 1718 
        80 - 99% = 1203 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8763, nodes: 7476476 
    Average node length: 5.39, total dup: 7187829, max dup: 176 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1568098, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 936 
        40 - 59% = 4867 
        60 - 79% = 1735 
        80 - 99% = 1213 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.05, total records: 12341111 
    Average version length: 68.70, total versions: 385537, 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: 108, data page slots: 175512 
    Data pages: 175512, average fill: 75% 
    Primary pages: 175511, secondary pages: 1, swept pages: 48974 
    Empty pages: 0, full pages: 174866 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 12 
    40 - 59% = 100 
    60 - 79% = 171962 
    80 - 99% = 3435 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18439, nodes: 12336971 
    Average node length: 6.63, total dup: 10752246, max dup: 59 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2517736, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1748 
        40 - 59% = 10656 
        60 - 79% = 5160 
        80 - 99% = 848 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 45.07, total records: 1695153 
    Average version length: 69.04, total versions: 400098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.80 
    Pointer pages: 24, data page slots: 38600 
    Data pages: 28623, average fill: 60% 
    Primary pages: 28558, secondary pages: 65, swept pages: 4969 
    Empty pages: 1739, full pages: 21569 
    Fill distribution: 
     0 - 19% = 3115 
    20 - 39% = 4219 
    40 - 59% = 2505 
    60 - 79% = 13361 
    80 - 99% = 5423 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1786, nodes: 1416674 
    Average node length: 5.52, total dup: 1359107, max dup: 49 
    Average key length: 2.56, compression ratio: 16.38 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 98008, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 338 
        40 - 59% = 794 
        60 - 79% = 500 
        80 - 99% = 147 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 38.45, total records: 1385176 
    Average version length: 69.02, total versions: 198555, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.28 
    Pointer pages: 20, data page slots: 31040 
    Data pages: 28688, average fill: 41% 
    Primary pages: 28686, secondary pages: 2, swept pages: 5383 
    Empty pages: 4361, full pages: 14733 
    Fill distribution: 
     0 - 19% = 8092 
    20 - 39% = 4009 
    40 - 59% = 7226 
    60 - 79% = 8851 
    80 - 99% = 510 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1286, nodes: 878209 
    Average node length: 5.95, total dup: 808770, max dup: 99 
    Average key length: 3.01, compression ratio: 13.96 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 132198, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 313 
        40 - 59% = 644 
        60 - 79% = 283 
        80 - 99% = 44 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.62, total records: 8918218 
    Average version length: 68.99, total versions: 481659, 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: 89, data page slots: 143976 
    Data pages: 143936, average fill: 67% 
    Primary pages: 143915, secondary pages: 21, swept pages: 44392 
    Empty pages: 516, full pages: 76211 
    Fill distribution: 
     0 - 19% = 1390 
    20 - 39% = 6481 
    40 - 59% = 26237 
    60 - 79% = 106422 
    80 - 99% = 3406 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13416, nodes: 8913289 
    Average node length: 6.68, total dup: 7393196, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1977061, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1427 
        40 - 59% = 7386 
        60 - 79% = 4136 
        80 - 99% = 467 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21083625 
    Average version length: 82.98, total versions: 12356, 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: 318776 
    Data pages: 318776, average fill: 81% 
    Primary pages: 318770, secondary pages: 6, swept pages: 12132 
    Empty pages: 49, full pages: 317843 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 46 
    40 - 59% = 138 
    60 - 79% = 47278 
    80 - 99% = 271239 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19231, nodes: 21083625 
    Average node length: 5.72, total dup: 20604255, max dup: 155 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273592, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 7959 
        60 - 79% = 505 
        80 - 99% = 10759 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17091, nodes: 21083625 
    Average node length: 6.31, total dup: 18528267, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914435, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 737 
        60 - 79% = 273 
        80 - 99% = 16074 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21030, nodes: 21083625 
    Average node length: 6.34, total dup: 18447509, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3566676, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8289 
        60 - 79% = 570 
        80 - 99% = 12165 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16013, nodes: 21083625 
    Average node length: 5.56, total dup: 21083525, max dup: 229136 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943135, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 2832 
        60 - 79% = 345 
        80 - 99% = 12826 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.41, total records: 9393007 
    Average version length: 82.62, total versions: 509361, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 104, data page slots: 169144 
    Data pages: 169056, average fill: 69% 
    Primary pages: 169025, secondary pages: 31, swept pages: 61702 
    Empty pages: 824, full pages: 98922 
    Fill distribution: 
     0 - 19% = 2159 
    20 - 39% = 7285 
    40 - 59% = 27875 
    60 - 79% = 107930 
    80 - 99% = 23807 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11317, nodes: 9393007 
    Average node length: 5.37, total dup: 9088168, max dup: 192 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2091597, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 79 
        40 - 59% = 8942 
        60 - 79% = 2248 
        80 - 99% = 45 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13065, nodes: 9393007 
    Average node length: 6.24, total dup: 7786229, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1448382, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 3619 
        40 - 59% = 4397 
        60 - 79% = 2613 
        80 - 99% = 2312 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12638, nodes: 9393007 
    Average node length: 5.99, total dup: 8147629, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2280926, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 103 
        40 - 59% = 10035 
        60 - 79% = 2450 
        80 - 99% = 49 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9848, nodes: 9393007 
    Average node length: 5.14, total dup: 9392907, max dup: 153810 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1476043, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1241 
        40 - 59% = 4827 
        60 - 79% = 1690 
        80 - 99% = 2042 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.80, total records: 11068483 
    Average version length: 82.56, total versions: 375755, 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: 118, data page slots: 190960 
    Data pages: 189328, average fill: 72% 
    Primary pages: 189201, secondary pages: 127, swept pages: 67265 
    Empty pages: 2830, full pages: 143182 
    Fill distribution: 
     0 - 19% = 4804 
    20 - 39% = 7381 
    40 - 59% = 17209 
    60 - 79% = 96267 
    80 - 99% = 63667 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13113, nodes: 11068483 
    Average node length: 5.29, total dup: 10959318, max dup: 627 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2313642, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 188 
        40 - 59% = 9705 
        60 - 79% = 3108 
        80 - 99% = 112 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10225, nodes: 11068483 
    Average node length: 5.49, total dup: 10583743, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 702585, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 858 
        40 - 59% = 2494 
        60 - 79% = 1736 
        80 - 99% = 4971 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14999, nodes: 11068483 
    Average node length: 6.02, total dup: 9652577, max dup: 69 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2329971, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 232 
        40 - 59% = 11311 
        60 - 79% = 3320 
        80 - 99% = 133 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10601, nodes: 11068483 
    Average node length: 5.21, total dup: 11068383, max dup: 192634 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 690679, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 908 
        40 - 59% = 4652 
        60 - 79% = 1482 
        80 - 99% = 3460 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 78.89, total records: 9490055 
    Average version length: 82.91, total versions: 493557, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 106, data page slots: 172320 
    Data pages: 172216, average fill: 69% 
    Primary pages: 172187, secondary pages: 29, swept pages: 66077 
    Empty pages: 794, full pages: 97765 
    Fill distribution: 
     0 - 19% = 2246 
    20 - 39% = 8069 
    40 - 59% = 29167 
    60 - 79% = 110335 
    80 - 99% = 22399 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11484, nodes: 9490055 
    Average node length: 5.18, total dup: 9461492, max dup: 2368 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1903497, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1462 
        40 - 59% = 7631 
        60 - 79% = 1772 
        80 - 99% = 591 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13170, nodes: 9490055 
    Average node length: 6.25, total dup: 7866355, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1423865, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 3637 
        40 - 59% = 4382 
        60 - 79% = 2566 
        80 - 99% = 2444 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12118, nodes: 9490055 
    Average node length: 5.44, total dup: 9063382, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2035422, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1463 
        40 - 59% = 8488 
        60 - 79% = 1583 
        80 - 99% = 564 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9971, nodes: 9490055 
    Average node length: 5.15, total dup: 9489955, max dup: 155256 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1499135, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1260 
        40 - 59% = 4960 
        60 - 79% = 1655 
        80 - 99% = 2059 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.53, total records: 570971 
    Average version length: 68.82, total versions: 6103, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7992 
    Data pages: 7992, average fill: 75% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3176 
    Empty pages: 5, full pages: 7190 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 20 
    40 - 59% = 136 
    60 - 79% = 7754 
    80 - 99% = 74 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 31787, depth: 3, leaf buckets: 731, nodes: 570971 
    Average node length: 5.95, total dup: 486157, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100512, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 521 
        60 - 79% = 88 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 24876, depth: 3, leaf buckets: 754, nodes: 570971 
    Average node length: 6.15, total dup: 468259, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100563, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 530 
        60 - 79% = 84 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 565, nodes: 570971 
    Average node length: 4.86, total dup: 570871, max dup: 9675 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89328, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 43 
        40 - 59% = 326 
        60 - 79% = 72 
        80 - 99% = 124 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Apr  4 07:09:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7708889 120303 1 0.0000 0.0000
DOC_LIST 2220877 61015 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3255 9 800.0000 0.0000
INVNT_TURNOVER_LOG 66020 54304 1 0.0000 0.0000
MONEY_SALDO 49 199 7 400.0000 0.0000
MONEY_TURNOVER_LOG 2252 1811 1 0.0000 0.0000
PDISTR 858849 32326 3 0.0000 0.0000
PERF_SPLIT_0 165317 8697 1 0.0000 0.0000
PERF_SPLIT_1 173366 19306 1 0.0000 0.0000
PERF_SPLIT_2 136158 11638 1 0.0000 0.0000
PERF_SPLIT_3 175342 44479 1 0.0000 0.0000
PERF_SPLIT_4 184038 10641 1 0.0000 0.0000
PERF_SPLIT_5 167529 8807 1 0.0000 0.0000
PERF_SPLIT_6 143068 4471 1 0.0000 0.0000
PERF_SPLIT_7 154881 8250 1 0.0000 0.0000
PERF_SPLIT_8 174716 13314 1 0.0000 0.0000
PERF_SPLIT_9 173162 4884 1 0.0000 0.0000
PSTORNED 2070394 53120 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 153318 70340 1 0.0000 0.0000
XQD_1000_3300 7476476 491740 1 0.0000 0.0000
XQD_1200_2000 12341111 385537 1 0.0000 0.0000
XQD_2000_3300 1695153 400098 1 0.0000 0.0000
XQD_2100_3300 1385176 198555 1 0.0000 0.0000
XQD_3300_3400 8918218 481659 1 0.0000 0.0000
XQS_1000_1200 21083625 12356 1 0.0000 0.0000
XQS_1000_3300 9393007 509361 1 0.0000 0.0000
XQS_1200_2000 11068483 375755 1 0.0000 0.0000
XQS_2100_3300 9490055 493557 1 0.0000 0.0000
XQS_3300_3400 570971 6103 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 ---
--- end of diff output ---

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

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