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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-10 19:09:47
DTS_END                         2024-04-10 19:09:47.1830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38952
TRN_ID                          170887
ATT_ID                          582
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: 9099.93 20425 909993
customer order: creation 168.51 419 16851
customer order: refuse 15.03 395 1503
order to supplier: creation 46.19 1484 4619
order to supplier: removal 3.49 105686 349
invoice (draft): creation 45.55 3512 4555
invoice (draft): removal 49.60 832 4960
invoice accept: apply 41.69 20684 4169
invoice accept: cancel 45.12 1035 4512
customer reserve: creation 3968.23 199 396823
customer reserve: removal 4420.01 67 442001
realization accept: apply 82.15 204 8215
realization accept: cancel 85.29 118 8529
payment from customer: creation 58.49 113 5849
payment from customer: removal 5.83 75 583
payment to supplier: creation 48.61 142 4861
payment to supplier: removal 3.50 83 350
service: total inventory turnovers 4.96 1054 496
service: total monetary turnovers 6.76 31 676
service: aggregate perf. data 0.89 16191 89
service: refresh index statistics 0.03 256167 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 10-04-2024 19:11:12 to 10-04-2024 19:11:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3704
TEST_TIME 2 4584
TEST_TIME 3 4531
TEST_TIME 4 4316
TEST_TIME 5 4512
TEST_TIME 6 4494
TEST_TIME 7 4584
TEST_TIME 8 4828
TEST_TIME 9 4748
TEST_TIME 10 5253
TEST_TIME 11 5111
TEST_TIME 12 5133
TEST_TIME 13 5151
TEST_TIME 14 5536
TEST_TIME 15 5896
TEST_TIME 16 6806
TEST_TIME 17 7050
TEST_TIME 18 7715
TEST_TIME 19 7750
TEST_TIME 20 7814
TEST_TIME 21 8162
TEST_TIME 22 8206
TEST_TIME 23 8302
TEST_TIME 24 8400
TEST_TIME 25 8471
TEST_TIME 26 8425
TEST_TIME 27 8504
TEST_TIME 28 9146
TEST_TIME 29 9482
TEST_TIME 30 9633
TEST_TIME 31 9405
TEST_TIME 32 9349
TEST_TIME 33 9344
TEST_TIME 34 9444
TEST_TIME 35 9313
TEST_TIME 36 9352
TEST_TIME 37 9244
TEST_TIME 38 9108
TEST_TIME 39 9089
TEST_TIME 40 9026
TEST_TIME 41 8866
TEST_TIME 42 8904
TEST_TIME 43 9001
TEST_TIME 44 8898
TEST_TIME 45 8833
TEST_TIME 46 8870
TEST_TIME 47 8782
TEST_TIME 48 8895
TEST_TIME 49 8998
TEST_TIME 50 8942
TEST_TIME 51 8948
TEST_TIME 52 9011
TEST_TIME 53 9026
TEST_TIME 54 9062
TEST_TIME 55 9085
TEST_TIME 56 9085
TEST_TIME 57 9267
TEST_TIME 58 9198
TEST_TIME 59 9232
TEST_TIME 60 9252
TEST_TIME 61 9246
TEST_TIME 62 9142
TEST_TIME 63 9090
TEST_TIME 64 9087
TEST_TIME 65 9035
TEST_TIME 66 8999
TEST_TIME 67 9026
TEST_TIME 68 9038
TEST_TIME 69 9050
TEST_TIME 70 9014
TEST_TIME 71 9095
TEST_TIME 72 9151
TEST_TIME 73 9137
TEST_TIME 74 9159
TEST_TIME 75 9195
TEST_TIME 76 9191
TEST_TIME 77 9225
TEST_TIME 78 9311
TEST_TIME 79 9351
TEST_TIME 80 9324
TEST_TIME 81 9328
TEST_TIME 82 9408
TEST_TIME 83 9391
TEST_TIME 84 9436
TEST_TIME 85 9369
TEST_TIME 86 9290
TEST_TIME 87 9321
TEST_TIME 88 9298
TEST_TIME 89 9282
TEST_TIME 90 9224
TEST_TIME 91 9269
TEST_TIME 92 9254
TEST_TIME 93 9208
TEST_TIME 94 9176
TEST_TIME 95 9144
TEST_TIME 96 9109
TEST_TIME 97 9097
TEST_TIME 98 9121
TEST_TIME 99 9140
TEST_TIME 100 9110

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-04-2024 19:11:16 to 10-04-2024 19:11:19.

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 1272504 1272504 0 0.00 0 27354 7 0 0
doc_list_biud 1272503 1272503 0 0.00 0 30181 29 0 0
sp_add_invoice_to_stock 4248 4169 79 1.85 40 179023 20684 0 79
sp_cancel_adding_invoice 4512 4512 0 0.00 3 82753 1035 0 0
sp_cancel_client_order 1503 1503 0 0.00 4 30192 395 0 0
sp_cancel_customer_reserve 442001 442001 0 0.00 0 23173 68 0 0
sp_cancel_pay_from_customer 583 583 0 0.00 3 2476 75 0 0
sp_cancel_pay_to_supplier 350 350 0 0.00 3 3858 83 0 0
sp_cancel_supplier_invoice 4962 4960 2 0.04 2 25061 833 0 2
sp_cancel_supplier_order 349 349 0 0.00 7 1207794 105686 0 0
sp_cancel_write_off 8529 8529 0 0.00 1 9754 119 0 0
sp_client_order 16851 16851 0 0.00 3 30185 419 0 0
sp_customer_reserve 396823 396823 0 0.00 0 30211 200 0 0
sp_fill_shopping_cart 26019 26019 0 0.00 1 13422 40 0 0
sp_fill_shopping_cart_clo_res 396809 396809 0 0.00 0 15584 16 0 0
sp_get_clo_for_invoice 4155 4155 0 0.00 0 18776 355 0 0
sp_kill_cost_storno 13974 13974 0 0.00 0 8798 64 0 0
sp_kill_qstorno_ret_qs2qd 897840 897840 0 0.00 0 25043 36 0 0
sp_kill_qty_storno 474223 474223 0 0.00 0 30180 78 0 0
sp_lock_selected_doc 17258 17258 0 0.00 0 10670 9 0 0
sp_make_cost_storno 23080 23080 0 0.00 0 26952 60 0 0
sp_multiply_rows_for_pdistr 23079 23079 0 0.00 0 5492 29 0 0
sp_multiply_rows_for_qdistr 16851 16851 0 0.00 0 29859 187 0 0
sp_pay_from_customer 5849 5849 0 0.00 4 12463 113 0 0
sp_pay_to_supplier 4861 4861 0 0.00 5 27372 143 0 0
sp_payment_common 10710 10710 0 0.00 1 8593 25 0 0
sp_qd_handle_on_cancel_clo 1503 1503 0 0.00 0 30180 362 0 0
sp_qd_handle_on_invoice_upd_sts 8667 8667 0 0.00 0 26834 351 0 0
sp_qd_handle_on_reserve_upd_sts 8214 8214 0 0.00 0 20349 67 0 0
sp_reserve_write_off 8215 8215 0 0.00 5 20685 204 0 0
sp_supplier_invoice 4555 4555 0 0.00 6 92993 3513 0 0
sp_supplier_order 4619 4619 0 0.00 6 39990 1485 0 0
srv_aggregate_perf_data 90 89 1 1.11 1369 131146 16191 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 2281 91705 39436 0 0
srv_find_qd_qs_mism 867550 867550 0 0.00 0 16415 6 0 0
srv_make_invnt_saldo 496 496 0 0.00 40 50359 1054 0 0
srv_make_money_saldo 676 676 0 0.00 0 995 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 161651 356204 256168 0 0
t$perf-abend:sp_add_invoice_to_stock 79 79 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4169 4169 0 0.00 0 8663 174 0 0
t$perf-norm:sp_cancel_adding_invoice 386 386 0 0.00 0 5068 134 0 0
t$perf-norm:sp_cancel_client_order 1503 1503 0 0.00 0 14123 20 0 0
t$perf-norm:sp_cancel_customer_reserve 566 566 0 0.00 0 1329 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 583 583 0 0.00 0 1343 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 350 350 0 0.00 0 348 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 338 338 0 0.00 0 1261 22 0 0
t$perf-norm:sp_cancel_supplier_order 349 349 0 0.00 0 26680 1966 0 0
t$perf-norm:sp_cancel_write_off 814 814 0 0.00 0 8267 14 0 0
t$perf-norm:sp_client_order 16851 16851 0 0.00 0 14392 17 0 0
t$perf-norm:sp_customer_reserve 805 805 0 0.00 0 698 5 0 0
t$perf-norm:sp_pay_from_customer 5849 5849 0 0.00 0 5889 10 0 0
t$perf-norm:sp_pay_to_supplier 4861 4861 0 0.00 0 3606 8 0 0
t$perf-norm:sp_reserve_write_off 8215 8215 0 0.00 0 5890 11 0 0
t$perf-norm:sp_supplier_invoice 4555 4555 0 0.00 0 4348 18 0 0
t$perf-norm:sp_supplier_order 4619 4619 0 0.00 0 13918 18 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 549 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 369 11 0 0
t$perf-norm:srv_make_invnt_saldo 496 496 0 0.00 0 1428 20 0 0
t$perf-norm:srv_make_money_saldo 676 676 0 0.00 0 6463 31 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 8468 8310 158 1.86 0 5454 16 0 158
v_all_customers 31170 31170 0 0.00 0 21 1 0 0
v_all_suppliers 25974 25974 0 0.00 0 23 1 0 0
v_all_wares 33700 33700 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 772 772 0 0.00 0 3932 12 0 0
v_cancel_client_order 3006 3006 0 0.00 0 1473 4 0 0
v_cancel_customer_prepayment 1166 1166 0 0.00 0 1321 7 0 0
v_cancel_customer_reserve 1132 1132 0 0.00 0 4287 8 0 0
v_cancel_payment_to_supplier 700 700 0 0.00 0 310 4 0 0
v_cancel_supplier_invoice 680 676 4 0.58 0 3225 19 0 4
v_cancel_supplier_order 698 698 0 0.00 0 353 4 0 0
v_cancel_write_off 1628 1628 0 0.00 0 2402 15 0 0
v_max_id_clo_ord 4618 4618 0 0.00 0 1739 2 0 0
v_max_id_clo_res 805 805 0 0.00 0 3042 17 0 0
v_max_id_ord_sup 4551 4551 0 0.00 0 4949 5 0 0
v_max_non_paid_invoice 1043 1043 0 0.00 0 171 2 0 0
v_max_non_paid_realizn 2879 2879 0 0.00 0 1766 5 0 0
v_min_id_clo_ord 4618 4618 0 0.00 0 10589 22 0 0
v_min_id_clo_res 805 805 0 0.00 0 6592 11 0 0
v_min_id_ord_sup 4551 4551 0 0.00 0 7762 6 0 0
v_min_non_paid_invoice 4861 4861 0 0.00 0 4214 17 0 0
v_min_non_paid_realizn 5849 5849 0 0.00 0 8590 21 0 0
v_our_firm 8470 8470 0 0.00 0 27 1 0 0
v_reserve_write_off 16428 16428 0 0.00 0 4341 6 0 0
x_lock_depdocs_on_canc_invoice 9134 9134 0 0.00 0 14081 143 0 0
x_lock_depdocs_on_canc_sup_ord 349 349 0 0.00 0 5137 356 0 0
x_make_qstorno_1000_1200 4619 4619 0 0.00 2 38561 1377 0 0
x_make_qstorno_1200_2000 4555 4555 0 0.00 4 91423 3387 0 0
x_make_qstorno_2100_3300 396823 396823 0 0.00 0 30198 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-04-2024 19:11:20 to 10-04-2024 19:11:24.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:51 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:51 45377 8192000000 9891569216 10204909568 974014736 10.626 100 92 184 0 1005046864 6285168 24746960
17:12:40 23509 8192000000 9945602608 10268213248 1023219600 11.103 100 84 168 0 1052984352 7912544 21852208
17:14:12 14682 8192000000 9984442464 10313338880 1062744480 11.483 100 89 176 1 1094178208 9512080 21921648
17:15:37 9929 8192000000 10036914736 10388578304 1120048464 12.027 100 73 144 0 1147701008 10407184 17245360
17:16:51 4521 8192000000 10076195408 10436612096 1169929296 12.496 100 78 156 0 1199951584 12052896 17969392
17:18:00 2994 8192000000 10125713632 10495205376 1215465472 12.920 100 78 156 0 1246107248 11766544 18875232
17:19:05 1890 8192000000 10164339840 10536280064 1247147152 13.212 100 87 174 0 1278871184 12767664 18956368
17:20:09 1447 8192000000 10181875648 10564583424 1272709296 13.446 100 87 169 0 1305616464 14385296 18521872
17:21:12 9259 8192000000 10199765808 10586931200 1287527360 13.582 100 67 133 1 1314532976 12459808 14545808
17:22:23 24386 8192000000 10177080016 10592370688 1294952688 13.649 100 33 66 1 1313479744 10921040 7606016
17:23:49 4720 8192000000 10200189600 10614435840 1311410944 13.799 100 23 47 2 1326274768 9996368 4867456
17:24:55 9901 8192000000 10202117184 10620624896 1320401024 13.880 100 13 26 0 1329153616 6067248 2685344
17:26:10 8464 8192000000 10208177664 10625249280 1323461136 13.908 100 19 38 0 1333718672 5733488 4524048
17:27:19 44759 8192000000 10226863472 10643836928 1329829104 13.966 100 37 70 0 1344109088 6538400 7741584
17:29:04 4232 8192000000 10219047984 10634027008 1321788656 13.893 100 32 62 0 1336112000 7599456 6723888
17:30:13 16283 8192000000 10222085360 10628915200 1309864928 13.785 99 42 83 0 1326097392 7112576 9119888
17:31:34 30083 8192000000 10199985392 10606624768 1285153744 13.560 98 45 90 0 1305129632 10219392 9756496
17:33:19 47251 8192000000 10198146976 10607194112 1267872640 13.402 97 42 79 1 1291488112 14682128 8933344
17:35:14 11069 8192000000 10235640640 10638270464 1314948400 13.831 99 47 94 1 1339902560 14574336 10379824
17:36:33 19700 8192000000 10233441760 10643247104 1307885232 13.767 98 39 78 2 1334655296 17353984 9416080
17:37:58 26817 8192000000 10255933952 10657316864 1304975712 13.740 97 55 111 1 1337459312 19522256 12961344
17:39:29 17054 8192000000 10256906128 10665484288 1336684864 14.028 100 43 86 0 1367754816 20287536 10782416
17:40:51 5353 8192000000 10271572016 10676703232 1349379568 14.142 100 50 100 0 1383073952 21866128 11828256
17:42:01 15013 8192000000 10256106560 10662105088 1332355232 13.988 100 40 81 0 1368594624 25534704 10704688
17:43:21 2471 8192000000 10298406096 10694623232 1353120960 14.176 100 82 164 1 1406107088 32856464 20129664
17:44:36 2694 8192000000 10294329824 10689007616 1338253840 14.042 99 86 171 1 1389103472 30050192 20799440
17:45:43 6552 8192000000 10298638352 10713391104 1368058144 14.310 100 53 106 0 1408263440 26763664 13441632
17:46:53 2280 8192000000 10318619968 10725478400 1374956096 14.371 100 79 157 1 1423171808 27858720 20356992
17:48:01 8900 8192000000 10312096368 10731638784 1376229504 14.383 100 54 104 2 1415700048 26518320 12952224
17:49:23 28278 8192000000 10281295360 10698551296 1344649664 14.099 99 50 100 0 1380773408 23443440 12680304
17:50:58 2357 8192000000 10308193296 10720526336 1369321760 14.321 100 80 160 0 1415130048 26556320 19251968
17:52:08 35237 8192000000 10302801008 10735878144 1368168416 14.311 99 22 44 0 1400065072 25513648 6383008
17:53:47 19294 8192000000 10316034272 10745876480 1384242544 14.454 100 36 72 0 1418491040 24982560 9265936
17:55:16 16275 8192000000 10333969360 10769346560 1400916368 14.603 100 31 62 0 1441915744 32680944 8318432
17:56:40 24895 8192000000 10334748720 10774716416 1398315872 14.580 100 25 50 0 1447004768 41906816 6782080
17:58:08 23514 8192000000 10319701824 10771267584 1392875376 14.532 100 19 38 0 1432020496 34048608 5096512
17:59:38 52992 8192000000 10307268080 10750980096 1395603632 14.556 100 57 109 0 1417755136 8464960 13686544
18:01:33 34592 8192000000 10331056672 10768183296 1407676416 14.663 100 37 74 0 1430119824 13999632 8443776
18:03:11 27686 8192000000 10312057840 10776895488 1403831184 14.629 100 11 22 0 1418786848 12537408 2418256
18:04:47 81397 8192000000 10300034768 10763943936 1390849408 14.513 99 10 20 0 1402153936 8894960 2409568
18:07:19 32779 8192000000 10335846672 10774720512 1414172112 14.721 100 31 63 1 1430663936 9744464 6747360
18:08:53 62235 8192000000 10310769888 10767904768 1395860096 14.558 99 19 39 0 1416415776 15990000 4565680
18:10:59 34758 8192000000 10328542320 10760675328 1367331824 14.303 97 63 122 3 1387224336 6484560 13407952
18:12:35 80089 8192000000 10310608944 10759012352 1380930736 14.425 98 15 30 0 1394523824 10446800 3146288
18:14:57 43772 8192000000 10274351712 10734723072 1371620320 14.342 99 19 39 0 1390286928 14331088 4335520
18:17:20 52326 8192000000 10278609904 10746011648 1365557472 14.287 98 12 24 0 1382556512 14084464 2914576
18:19:13 40356 8192000000 10297915328 10751193088 1394455984 14.546 100 15 31 1 1409444032 11507392 3480656
18:20:54 63606 8192000000 10282400464 10722828288 1319017408 13.868 95 27 54 0 1337095344 11857856 6220080
18:22:58 30471 8192000000 10270160416 10714157056 1352415520 14.169 99 33 67 0 1370406656 10507760 7483376
18:24:38 63389 8192000000 10271121824 10715811840 1317552032 13.855 96 22 44 0 1335444672 12749984 5142656
18:26:41 48337 8192000000 10270319552 10709618688 1337362784 14.034 98 15 28 0 1348406784 8026464 3017536
18:28:32 58357 8192000000 10236042304 10668982272 1247236144 13.213 92 27 53 0 1264646096 12161248 5248704
18:30:31 89922 8192000000 10247447456 10685571072 1336730784 14.028 99 36 72 1 1352822960 7276800 8815376
18:33:06 26316 8192000000 10255849680 10685931520 1338043328 14.040 99 42 84 0 1361254880 14127472 9084080
18:34:35 13946 8192000000 10267107008 10703421440 1355421584 14.196 100 37 72 0 1375974480 12421856 8131040
18:36:08 40903 8192000000 10282957840 10735349760 1373974240 14.363 100 16 33 0 1400458896 22349424 4135232
18:37:54 51571 8192000000 10272129408 10722115584 1349854528 14.146 99 14 28 0 1374065664 20622256 3588880
18:40:23 46421 8192000000 10267371920 10712494080 1312792032 13.811 96 11 22 0 1335339488 20159568 2387888
18:42:10 61110 8192000000 10275038384 10722852864 1347866752 14.128 98 29 59 0 1364312400 9532128 6913520
18:44:21 48306 8192000000 10286327232 10724577280 1363373952 14.268 99 35 70 0 1382657760 11472304 7811504
18:46:10 39758 8192000000 10285978176 10737479680 1380940992 14.425 100 30 60 0 1400412128 12725776 6745360
18:47:57 38684 8192000000 10293327648 10733867008 1368924736 14.317 99 30 60 1 1384604832 9026752 6653344
18:49:36 37006 8192000000 10294826400 10737356800 1385824368 14.469 100 40 80 1 1404009216 9740064 8444784
18:51:22 87862 8192000000 10295960448 10741817344 1363590064 14.270 98 12 24 0 1377173760 11093680 2490016
18:53:51 78301 8192000000 10309526944 10763071488 1402340368 14.616 100 11 22 0 1417404624 12433840 2630416
18:56:25 91704 8192000000 10303833552 10773577728 1385577040 14.466 99 25 49 0 1406408448 15168032 5663376
18:58:58 78317 8192000000 10289239632 10745171968 1366981360 14.300 97 14 29 0 1383047424 12545712 3520352
19:01:17 33178 8192000000 10292817872 10748051456 1384369424 14.456 99 17 34 0 1396024304 7344848 4310032
19:02:59 53277 8192000000 10290609552 10742067200 1382954704 14.443 99 26 52 1 1395913024 7243392 5714928
19:04:58 62064 8192000000 10265987504 10717663232 1303765520 13.729 94 12 22 0 1315310992 9108112 2437360
19:07:13 47810 8192000000 10257256704 10708230144 1312763536 13.811 96 18 36 0 1338329808 21170656 4395616
19:09:04 52789 8192000000 9276845520 9553305600 407575200 4.739 29 17 34 0 426097840 14693760 3828880

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 10-04-2024 19:11:26 to 10-04-2024 19:11:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 79 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-04-2024 19:11:41 to 10-04-2024 19:11:43.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Wed Apr 10 19:11:44 2024 
 
Database header page information: 
    Flags            0 
    Generation        89804 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    168789 
    Oldest active        172375 
    Oldest snapshot        172375 
    Next transaction    172376 
    Sequence number        0 
    Next attachment ID    707 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.48, total records: 7720832 
    Average version length: 48.17, total versions: 67211, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86760 
    Data pages: 86760, average fill: 71% 
    Primary pages: 86760, secondary pages: 0, swept pages: 21640 
    Empty pages: 4, full pages: 61812 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 204 
    40 - 59% = 2347 
    60 - 79% = 84174 
    80 - 99% = 9 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23244, nodes: 7720832 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1697678, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 334 
        20 - 39% = 1896 
        40 - 59% = 4021 
        60 - 79% = 2511 
        80 - 99% = 14482 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13474, nodes: 7720832 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1520946, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1610 
        40 - 59% = 1945 
        60 - 79% = 1176 
        80 - 99% = 8742 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8314, nodes: 7720832 
    Average node length: 6.61, total dup: 5783159, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1513904, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 969 
        40 - 59% = 1329 
        60 - 79% = 1022 
        80 - 99% = 4865 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.57, total records: 2227907 
    Average version length: 34.82, total versions: 66819, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28424 
    Data pages: 28424, average fill: 72% 
    Primary pages: 28417, secondary pages: 7, swept pages: 9951 
    Empty pages: 6, full pages: 18545 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 154 
    40 - 59% = 1826 
    60 - 79% = 25923 
    80 - 99% = 496 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4548, nodes: 2227907 
    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: 684858, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 940 
        40 - 59% = 828 
        60 - 79% = 774 
        80 - 99% = 2006 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2529, nodes: 2230372 
    Average node length: 4.97, total dup: 2229473, max dup: 17766 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1237334, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 288 
        40 - 59% = 1551 
        60 - 79% = 510 
        80 - 99% = 177 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2043, nodes: 2227907 
    Average node length: 4.97, total dup: 2227857, max dup: 130209 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1055488, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 96 
        40 - 59% = 1078 
        60 - 79% = 38 
        80 - 99% = 828 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4319, nodes: 2227907 
    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: 684858, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 584 
        40 - 59% = 564 
        60 - 79% = 926 
        80 - 99% = 2143 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.27, total records: 400 
    Average version length: 22.97, total versions: 238874, max versions: 623 
    Average fragment length: 2.03, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1320, average fill: 90% 
    Primary pages: 12, secondary pages: 1308, swept pages: 0 
    Empty pages: 5, full pages: 1314 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1314 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 4.34, total records: 119175 
    Average version length: 68.29, total versions: 111606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 20.28 
    Pointer pages: 7, data page slots: 2048 
    Data pages: 1880, average fill: 79% 
    Primary pages: 1879, secondary pages: 1, swept pages: 0 
    Empty pages: 20, full pages: 1472 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 91 
    40 - 59% = 120 
    60 - 79% = 272 
    80 - 99% = 1309 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704982, depth: 3, leaf buckets: 334, nodes: 119175 
    Average node length: 13.05, total dup: 7987, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.29, average data length: 7.71 
    Clustering factor: 88568, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 206 
        60 - 79% = 97 
        80 - 99% = 27 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18126, max versions: 954 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 81% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 63 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 1.95, total records: 1889 
    Average version length: 43.22, total versions: 1805, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 29.75 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 56% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 19 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 15 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90849, depth: 2, leaf buckets: 2, nodes: 1889 
    Average node length: 4.17, total dup: 1791, max dup: 203 
    Average key length: 2.55, compression ratio: 7.45 
    Average prefix length: 18.50, average data length: 0.50 
    Clustering factor: 1018, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 1 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.11, total records: 73 
    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: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.99, total records: 818470 
    Average version length: 25.45, total versions: 73199, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8152 
    Data pages: 8152, average fill: 70% 
    Primary pages: 8138, secondary pages: 14, swept pages: 1261 
    Empty pages: 70, full pages: 7516 
    Fill distribution: 
     0 - 19% = 133 
    20 - 39% = 103 
    40 - 59% = 124 
    60 - 79% = 7494 
    80 - 99% = 298 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 901, nodes: 818470 
    Average node length: 4.87, total dup: 818421, max dup: 149328 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91218, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 113 
        40 - 59% = 522 
        60 - 79% = 209 
        80 - 99% = 55 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 975, nodes: 818470 
    Average node length: 5.88, total dup: 728368, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162903, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 84 
        40 - 59% = 515 
        60 - 79% = 109 
        80 - 99% = 264 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1025, nodes: 818470 
    Average node length: 5.88, total dup: 728368, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164974, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 174 
        40 - 59% = 503 
        60 - 79% = 98 
        80 - 99% = 250 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1166, nodes: 818470 
    Average node length: 5.97, total dup: 728368, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157773, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 237 
        40 - 59% = 626 
        60 - 79% = 216 
        80 - 99% = 83 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5406 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.62, total fragments: 53, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 72, secondary pages: 16, swept pages: 51 
    Empty pages: 6, full pages: 61 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5406 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.60, compression ratio: 9.97 
    Average prefix length: 34.29, average data length: 1.56 
    Clustering factor: 5109, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5406 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 144, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.08, total records: 78863 
    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: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 759 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 759 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33846, depth: 2, leaf buckets: 103, nodes: 78863 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3040, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 142.01, total records: 173252 
    Average version length: 152.20, total versions: 10096, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 6, data page slots: 4736 
    Data pages: 4152, average fill: 86% 
    Primary pages: 4152, secondary pages: 0, swept pages: 3 
    Empty pages: 43, full pages: 4098 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4097 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 115.69, total records: 216366 
    Average version length: 154.87, total versions: 50761, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.66 
    Pointer pages: 7, data page slots: 5832 
    Data pages: 5200, average fill: 88% 
    Primary pages: 5199, secondary pages: 1, swept pages: 6 
    Empty pages: 37, full pages: 5150 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 5149 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 120.35, total records: 214493 
    Average version length: 154.11, total versions: 43675, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.09 
    Pointer pages: 7, data page slots: 5928 
    Data pages: 5136, average fill: 88% 
    Primary pages: 5136, secondary pages: 0, swept pages: 3 
    Empty pages: 27, full pages: 5096 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 5096 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 144.74, total records: 174942 
    Average version length: 152.23, total versions: 7170, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 6, data page slots: 4784 
    Data pages: 4168, average fill: 87% 
    Primary pages: 4168, secondary pages: 0, swept pages: 1 
    Empty pages: 19, full pages: 4139 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4139 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 144.81, total records: 158867 
    Average version length: 151.47, total versions: 6524, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 3816, average fill: 86% 
    Primary pages: 3816, secondary pages: 0, swept pages: 7 
    Empty pages: 41, full pages: 3758 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3757 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 141.67, total records: 169845 
    Average version length: 152.41, total versions: 10167, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 7, data page slots: 4648 
    Data pages: 4056, average fill: 87% 
    Primary pages: 4055, secondary pages: 1, swept pages: 3 
    Empty pages: 30, full pages: 4014 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 4014 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 145.57, total records: 163656 
    Average version length: 150.53, total versions: 5692, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 7, data page slots: 5160 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3912, secondary pages: 0, swept pages: 1 
    Empty pages: 34, full pages: 3868 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3867 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 141.96, total records: 207533 
    Average version length: 153.56, total versions: 12756, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.95 
    Pointer pages: 6, data page slots: 5552 
    Data pages: 4960, average fill: 87% 
    Primary pages: 4960, secondary pages: 0, swept pages: 2 
    Empty pages: 26, full pages: 4924 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4924 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 143.58, total records: 167657 
    Average version length: 151.92, total versions: 8236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.81 
    Pointer pages: 7, data page slots: 4896 
    Data pages: 4000, average fill: 87% 
    Primary pages: 4000, secondary pages: 0, swept pages: 4 
    Empty pages: 20, full pages: 3967 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3968 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.32, total records: 175616 
    Average version length: 150.94, total versions: 6430, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 8, data page slots: 4808 
    Data pages: 4208, average fill: 86% 
    Primary pages: 4207, secondary pages: 1, swept pages: 10 
    Empty pages: 41, full pages: 4147 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4146 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.83, total records: 2089809 
    Average version length: 52.93, total versions: 36537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25632 
    Data pages: 25624, average fill: 70% 
    Primary pages: 25624, secondary pages: 0, swept pages: 11714 
    Empty pages: 319, full pages: 19789 
    Fill distribution: 
     0 - 19% = 611 
    20 - 39% = 491 
    40 - 59% = 1419 
    60 - 79% = 22772 
    80 - 99% = 331 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2574, nodes: 2089809 
    Average node length: 5.44, total dup: 1950563, max dup: 1657 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180108, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 324 
        40 - 59% = 1652 
        60 - 79% = 289 
        80 - 99% = 305 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2754, nodes: 2089809 
    Average node length: 5.69, total dup: 1875390, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372864, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2452 
        60 - 79% = 272 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2182, nodes: 2089809 
    Average node length: 4.96, total dup: 2089709, max dup: 27582 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 178053, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 252 
        40 - 59% = 1167 
        60 - 79% = 377 
        80 - 99% = 383 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 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: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 35.67, total records: 132135 
    Average version length: 69.18, total versions: 64073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.53 
    Pointer pages: 3, data page slots: 4040 
    Data pages: 2680, average fill: 58% 
    Primary pages: 2680, secondary pages: 0, swept pages: 369 
    Empty pages: 465, full pages: 1737 
    Fill distribution: 
     0 - 19% = 714 
    20 - 39% = 156 
    40 - 59% = 59 
    60 - 79% = 519 
    80 - 99% = 1232 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102269, depth: 3, leaf buckets: 200, nodes: 132135 
    Average node length: 6.38, total dup: 115012, max dup: 14 
    Average key length: 3.97, compression ratio: 10.59 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22743, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 107 
        60 - 79% = 42 
        80 - 99% = 11 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.99, total records: 7150815 
    Average version length: 68.74, total versions: 411314, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 63, data page slots: 102392 
    Data pages: 102392, average fill: 75% 
    Primary pages: 102392, secondary pages: 0, swept pages: 22107 
    Empty pages: 8, full pages: 82160 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 717 
    40 - 59% = 5683 
    60 - 79% = 88907 
    80 - 99% = 7037 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10749, nodes: 7150815 
    Average node length: 6.51, total dup: 6184220, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1589992, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1634 
        40 - 59% = 5835 
        60 - 79% = 2646 
        80 - 99% = 629 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8552, nodes: 7150815 
    Average node length: 5.40, total dup: 6865802, max dup: 182 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1384385, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1039 
        40 - 59% = 4824 
        60 - 79% = 1565 
        80 - 99% = 1113 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8643, nodes: 7150815 
    Average node length: 5.40, total dup: 6865802, max dup: 182 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1386820, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1140 
        40 - 59% = 4888 
        60 - 79% = 1521 
        80 - 99% = 1087 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.93, total records: 12154040 
    Average version length: 68.72, total versions: 356484, 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: 104, data page slots: 168176 
    Data pages: 168176, average fill: 77% 
    Primary pages: 168176, secondary pages: 0, swept pages: 72280 
    Empty pages: 1, full pages: 160467 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 410 
    40 - 59% = 2437 
    60 - 79% = 157868 
    80 - 99% = 7431 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18351, nodes: 12154040 
    Average node length: 6.58, total dup: 10591137, max dup: 63 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2387776, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2219 
        40 - 59% = 10619 
        60 - 79% = 4587 
        80 - 99% = 901 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 43.94, total records: 1578808 
    Average version length: 69.09, total versions: 575771, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.87 
    Pointer pages: 27, data page slots: 43816 
    Data pages: 27864, average fill: 65% 
    Primary pages: 27864, secondary pages: 0, swept pages: 6556 
    Empty pages: 2579, full pages: 18424 
    Fill distribution: 
     0 - 19% = 4350 
    20 - 39% = 1804 
    40 - 59% = 1755 
    60 - 79% = 10803 
    80 - 99% = 9152 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2058, nodes: 1578808 
    Average node length: 5.51, total dup: 1515130, max dup: 99 
    Average key length: 2.56, compression ratio: 16.41 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 107350, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 441 
        40 - 59% = 992 
        60 - 79% = 467 
        80 - 99% = 150 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.03, total records: 1114892 
    Average version length: 69.12, total versions: 484357, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.23 
    Pointer pages: 23, data page slots: 36288 
    Data pages: 28568, average fill: 45% 
    Primary pages: 28568, secondary pages: 0, swept pages: 8321 
    Empty pages: 7534, full pages: 12547 
    Fill distribution: 
     0 - 19% = 11032 
    20 - 39% = 2164 
    40 - 59% = 1612 
    60 - 79% = 4872 
    80 - 99% = 8888 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1540, nodes: 1114892 
    Average node length: 5.80, total dup: 1039388, max dup: 99 
    Average key length: 2.87, compression ratio: 14.62 
    Average prefix length: 41.19, average data length: 0.81 
    Clustering factor: 152638, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 314 
        40 - 59% = 789 
        60 - 79% = 349 
        80 - 99% = 87 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.87, total records: 9104336 
    Average version length: 68.97, total versions: 399429, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 89, data page slots: 143656 
    Data pages: 143640, average fill: 68% 
    Primary pages: 143640, secondary pages: 0, swept pages: 59649 
    Empty pages: 321, full pages: 71549 
    Fill distribution: 
     0 - 19% = 1167 
    20 - 39% = 6140 
    40 - 59% = 25485 
    60 - 79% = 105613 
    80 - 99% = 5235 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13452, nodes: 9104336 
    Average node length: 6.68, total dup: 7552542, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1934667, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1412 
        40 - 59% = 6812 
        60 - 79% = 4647 
        80 - 99% = 581 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21136943 
    Average version length: 82.99, total versions: 11553, 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: 318592 
    Data pages: 318592, average fill: 81% 
    Primary pages: 318592, secondary pages: 0, swept pages: 12493 
    Empty pages: 25, full pages: 317786 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 41 
    40 - 59% = 110 
    60 - 79% = 27503 
    80 - 99% = 290883 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19415, nodes: 21136943 
    Average node length: 5.72, total dup: 20656276, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278458, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 8272 
        60 - 79% = 518 
        80 - 99% = 10625 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17147, nodes: 21136943 
    Average node length: 6.31, total dup: 18574199, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914284, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 773 
        60 - 79% = 252 
        80 - 99% = 16117 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21238, nodes: 21136943 
    Average node length: 6.35, total dup: 18494183, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573303, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 8622 
        60 - 79% = 558 
        80 - 99% = 12053 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16027, nodes: 21136943 
    Average node length: 5.56, total dup: 21136843, max dup: 229047 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943076, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2773 
        60 - 79% = 390 
        80 - 99% = 12858 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.35, total records: 9508836 
    Average version length: 82.63, total versions: 352555, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 103, data page slots: 167864 
    Data pages: 167840, average fill: 70% 
    Primary pages: 167840, secondary pages: 0, swept pages: 79837 
    Empty pages: 400, full pages: 91004 
    Fill distribution: 
     0 - 19% = 1361 
    20 - 39% = 6506 
    40 - 59% = 26354 
    60 - 79% = 80096 
    80 - 99% = 53523 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11327, nodes: 9508836 
    Average node length: 5.36, total dup: 9200486, max dup: 187 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2082584, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 77 
        40 - 59% = 8673 
        60 - 79% = 2524 
        80 - 99% = 51 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13391, nodes: 9508836 
    Average node length: 6.22, total dup: 7882355, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1434398, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 3933 
        40 - 59% = 4404 
        60 - 79% = 2647 
        80 - 99% = 2272 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12644, nodes: 9508836 
    Average node length: 5.98, total dup: 8244676, max dup: 36 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2269712, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 113 
        40 - 59% = 9634 
        60 - 79% = 2824 
        80 - 99% = 69 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10035, nodes: 9508836 
    Average node length: 5.12, total dup: 9508736, max dup: 155936 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1472138, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1389 
        40 - 59% = 4912 
        60 - 79% = 1684 
        80 - 99% = 2012 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.98, total records: 11218895 
    Average version length: 82.63, total versions: 315783, 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: 191440 
    Data pages: 190144, average fill: 72% 
    Primary pages: 190144, secondary pages: 0, swept pages: 74716 
    Empty pages: 3075, full pages: 139370 
    Fill distribution: 
     0 - 19% = 5382 
    20 - 39% = 7660 
    40 - 59% = 18571 
    60 - 79% = 45190 
    80 - 99% = 113341 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13120, nodes: 11218895 
    Average node length: 5.30, total dup: 11109268, max dup: 629 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2337184, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 147 
        40 - 59% = 9290 
        60 - 79% = 3575 
        80 - 99% = 106 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10387, nodes: 11218895 
    Average node length: 5.50, total dup: 10729019, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 704270, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 163 
        20 - 39% = 830 
        40 - 59% = 2596 
        60 - 79% = 1854 
        80 - 99% = 4944 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14999, nodes: 11218895 
    Average node length: 6.03, total dup: 9786171, max dup: 63 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2353670, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 172 
        40 - 59% = 10774 
        60 - 79% = 3922 
        80 - 99% = 128 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10718, nodes: 11218895 
    Average node length: 5.22, total dup: 11218795, max dup: 191349 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 693270, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 815 
        40 - 59% = 4775 
        60 - 79% = 1468 
        80 - 99% = 3528 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.67, total records: 9626088 
    Average version length: 82.93, total versions: 356548, 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: 106, data page slots: 171616 
    Data pages: 171576, average fill: 69% 
    Primary pages: 171576, secondary pages: 0, swept pages: 82688 
    Empty pages: 533, full pages: 90111 
    Fill distribution: 
     0 - 19% = 1644 
    20 - 39% = 7039 
    40 - 59% = 27965 
    60 - 79% = 82671 
    80 - 99% = 52257 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11714, nodes: 9626088 
    Average node length: 5.17, total dup: 9597314, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1890674, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1582 
        40 - 59% = 7783 
        60 - 79% = 1737 
        80 - 99% = 580 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13519, nodes: 9626088 
    Average node length: 6.24, total dup: 7979106, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1403769, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 3904 
        40 - 59% = 4423 
        60 - 79% = 2575 
        80 - 99% = 2444 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12319, nodes: 9626088 
    Average node length: 5.43, total dup: 9192748, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2023851, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1528 
        40 - 59% = 8609 
        60 - 79% = 1606 
        80 - 99% = 548 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10162, nodes: 9626088 
    Average node length: 5.14, total dup: 9625988, max dup: 158298 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1491258, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1339 
        40 - 59% = 4986 
        60 - 79% = 1800 
        80 - 99% = 1999 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.56, total records: 569658 
    Average version length: 68.80, total versions: 5025, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7968, average fill: 75% 
    Primary pages: 7968, secondary pages: 0, swept pages: 4194 
    Empty pages: 6, full pages: 6385 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 25 
    40 - 59% = 226 
    60 - 79% = 7639 
    80 - 99% = 70 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 48118, depth: 3, leaf buckets: 741, nodes: 569658 
    Average node length: 5.95, total dup: 484982, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99219, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 535 
        60 - 79% = 84 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33317, depth: 3, leaf buckets: 752, nodes: 569658 
    Average node length: 6.15, total dup: 467142, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99269, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 528 
        60 - 79% = 91 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 567, nodes: 569658 
    Average node length: 4.86, total dup: 569558, max dup: 9557 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88231, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 321 
        60 - 79% = 89 
        80 - 99% = 118 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Apr 10 19:12:08 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7720832 67211 1 0.0000 0.0000
DOC_LIST 2227907 66819 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238874 623 59700.0000 0.0000
INVNT_TURNOVER_LOG 119175 111606 1 0.0000 0.0000
MONEY_SALDO 49 18126 954 36900.0000 0.0000
MONEY_TURNOVER_LOG 1889 1805 1 0.0000 0.0000
PDISTR 818470 73199 5 0.0000 0.0000
PERF_SPLIT_0 173252 10096 1 0.0000 0.0000
PERF_SPLIT_1 216366 50761 1 0.0000 0.0000
PERF_SPLIT_2 214493 43675 1 0.0000 0.0000
PERF_SPLIT_3 174942 7170 1 0.0000 0.0000
PERF_SPLIT_4 158867 6524 1 0.0000 0.0000
PERF_SPLIT_5 169845 10167 1 0.0000 0.0000
PERF_SPLIT_6 163656 5692 1 0.0000 0.0000
PERF_SPLIT_7 207533 12756 1 0.0000 0.0000
PERF_SPLIT_8 167657 8236 1 0.0000 0.0000
PERF_SPLIT_9 175616 6430 1 0.0000 0.0000
PSTORNED 2089809 36537 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 132135 64073 1 0.0000 0.0000
XQD_1000_3300 7150815 411314 1 0.0000 0.0000
XQD_1200_2000 12154040 356484 1 0.0000 0.0000
XQD_2000_3300 1578808 575771 1 0.0000 0.0000
XQD_2100_3300 1114892 484357 1 0.0000 0.0000
XQD_3300_3400 9104336 399429 1 0.0000 0.0000
XQS_1000_1200 21136943 11553 1 0.0000 0.0000
XQS_1000_3300 9508836 352555 1 0.0000 0.0000
XQS_1200_2000 11218895 315783 1 0.0000 0.0000
XQS_2100_3300 9626088 356548 1 0.0000 0.0000
XQS_3300_3400 569658 5025 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 ---
:1035: 
:1036: mscs-test-161.budzdorov.ru    Wed Apr 10 19:10:05 2024
:1037:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1038: 
:1039: 
:1040: mscs-test-161.budzdorov.ru    Wed Apr 10 19:10:05 2024
:1041:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1042: 
:1043: 
:1044: mscs-test-161.budzdorov.ru    Wed Apr 10 19:10:15 2024
:1045:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1046: 
--- end of diff output ---

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

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