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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-25 13:07:48
DTS_END                         2024-03-25 13:07:48.5380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/53708
TRN_ID                          169677
ATT_ID                          496
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: 9125.02 21420 912502
customer order: creation 170.49 418 17049
customer order: refuse 14.97 400 1497
order to supplier: creation 45.73 1262 4573
order to supplier: removal 3.69 99134 369
invoice (draft): creation 45.72 3204 4572
invoice (draft): removal 50.64 763 5064
invoice accept: apply 40.73 20856 4073
invoice accept: cancel 45.61 844 4561
customer reserve: creation 3948.84 198 394884
customer reserve: removal 4468.75 66 446875
realization accept: apply 82.64 206 8264
realization accept: cancel 80.38 119 8038
payment from customer: creation 58.62 115 5862
payment from customer: removal 5.60 100 560
payment to supplier: creation 49.08 129 4908
payment to supplier: removal 3.17 79 317
service: total inventory turnovers 3.58 4534 358
service: total monetary turnovers 5.96 635 596
service: aggregate perf. data 0.79 18735 79
service: refresh index statistics 0.03 276611 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-03-2024 13:09:20 to 25-03-2024 13:09:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2860
TEST_TIME 2 4015
TEST_TIME 3 3736
TEST_TIME 4 3809
TEST_TIME 5 4282
TEST_TIME 6 4391
TEST_TIME 7 4825
TEST_TIME 8 5605
TEST_TIME 9 5419
TEST_TIME 10 5617
TEST_TIME 11 5537
TEST_TIME 12 5561
TEST_TIME 13 5586
TEST_TIME 14 5742
TEST_TIME 15 6005
TEST_TIME 16 6143
TEST_TIME 17 6195
TEST_TIME 18 6414
TEST_TIME 19 6723
TEST_TIME 20 6794
TEST_TIME 21 6995
TEST_TIME 22 7641
TEST_TIME 23 8103
TEST_TIME 24 8924
TEST_TIME 25 9374
TEST_TIME 26 9735
TEST_TIME 27 9689
TEST_TIME 28 10038
TEST_TIME 29 9715
TEST_TIME 30 9434
TEST_TIME 31 9202
TEST_TIME 32 9095
TEST_TIME 33 9122
TEST_TIME 34 9096
TEST_TIME 35 9179
TEST_TIME 36 9220
TEST_TIME 37 9197
TEST_TIME 38 9152
TEST_TIME 39 9149
TEST_TIME 40 9178
TEST_TIME 41 8993
TEST_TIME 42 9209
TEST_TIME 43 9216
TEST_TIME 44 9233
TEST_TIME 45 9200
TEST_TIME 46 9109
TEST_TIME 47 9248
TEST_TIME 48 9257
TEST_TIME 49 9283
TEST_TIME 50 9350
TEST_TIME 51 9428
TEST_TIME 52 9522
TEST_TIME 53 9639
TEST_TIME 54 9670
TEST_TIME 55 9648
TEST_TIME 56 9534
TEST_TIME 57 9450
TEST_TIME 58 9356
TEST_TIME 59 9424
TEST_TIME 60 9379
TEST_TIME 61 9328
TEST_TIME 62 9292
TEST_TIME 63 9230
TEST_TIME 64 9164
TEST_TIME 65 9231
TEST_TIME 66 9305
TEST_TIME 67 9326
TEST_TIME 68 9296
TEST_TIME 69 9355
TEST_TIME 70 9346
TEST_TIME 71 9519
TEST_TIME 72 9518
TEST_TIME 73 9538
TEST_TIME 74 9506
TEST_TIME 75 9528
TEST_TIME 76 9482
TEST_TIME 77 9425
TEST_TIME 78 9353
TEST_TIME 79 9348
TEST_TIME 80 9280
TEST_TIME 81 9236
TEST_TIME 82 9180
TEST_TIME 83 9218
TEST_TIME 84 9289
TEST_TIME 85 9271
TEST_TIME 86 9271
TEST_TIME 87 9292
TEST_TIME 88 9290
TEST_TIME 89 9287
TEST_TIME 90 9359
TEST_TIME 91 9315
TEST_TIME 92 9392
TEST_TIME 93 9427
TEST_TIME 94 9372
TEST_TIME 95 9277
TEST_TIME 96 9229
TEST_TIME 97 9213
TEST_TIME 98 9175
TEST_TIME 99 9173
TEST_TIME 100 9126

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-03-2024 13:09:24 to 25-03-2024 13:09:27.

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 1275026 1275026 0 0.00 0 21837 7 0 0
doc_list_biud 1275026 1275026 0 0.00 0 54333 29 0 0
sp_add_invoice_to_stock 4188 4073 115 2.74 39 227635 20857 0 115
sp_cancel_adding_invoice 4561 4561 0 0.00 5 61638 844 0 0
sp_cancel_client_order 1497 1497 0 0.00 4 8894 400 0 0
sp_cancel_customer_reserve 446875 446875 0 0.00 0 54334 67 0 0
sp_cancel_pay_from_customer 560 560 0 0.00 2 8182 101 0 0
sp_cancel_pay_to_supplier 317 317 0 0.00 3 4592 79 0 0
sp_cancel_supplier_invoice 5076 5064 12 0.23 2 18396 764 0 12
sp_cancel_supplier_order 369 369 0 0.00 5 997613 99135 0 0
sp_cancel_write_off 8038 8038 0 0.00 1 10697 119 0 0
sp_client_order 17049 17049 0 0.00 3 19951 418 0 0
sp_customer_reserve 394884 394884 0 0.00 0 61276 199 0 0
sp_fill_shopping_cart 26183 26183 0 0.00 1 21075 40 0 0
sp_fill_shopping_cart_clo_res 394880 394880 0 0.00 0 32644 18 0 0
sp_get_clo_for_invoice 4069 4069 0 0.00 0 47159 383 0 0
sp_kill_cost_storno 13476 13476 0 0.00 0 9767 67 0 0
sp_kill_qstorno_ret_qs2qd 907221 907221 0 0.00 0 54314 36 0 0
sp_kill_qty_storno 478737 478737 0 0.00 0 54333 76 0 0
sp_lock_selected_doc 17189 17189 0 0.00 0 5176 3 0 0
sp_make_cost_storno 23103 23103 0 0.00 0 16759 66 0 0
sp_multiply_rows_for_pdistr 23103 23103 0 0.00 0 13351 31 0 0
sp_multiply_rows_for_qdistr 17049 17049 0 0.00 0 16342 234 0 0
sp_pay_from_customer 5862 5862 0 0.00 3 15263 116 0 0
sp_pay_to_supplier 4908 4908 0 0.00 4 15162 130 0 0
sp_payment_common 10770 10770 0 0.00 1 15260 21 0 0
sp_qd_handle_on_cancel_clo 1497 1497 0 0.00 0 8887 375 0 0
sp_qd_handle_on_invoice_upd_sts 8630 8630 0 0.00 0 19881 308 0 0
sp_qd_handle_on_reserve_upd_sts 8264 8264 0 0.00 0 23436 82 0 0
sp_reserve_write_off 8264 8264 0 0.00 7 23465 207 0 0
sp_supplier_invoice 4572 4572 0 0.00 6 87013 3204 0 0
sp_supplier_order 4573 4573 0 0.00 4 62727 1262 0 0
srv_aggregate_perf_data 79 79 0 0.00 1857 345077 18735 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1342 129037 40051 0 0
srv_find_qd_qs_mism 871064 871064 0 0.00 0 21287 6 0 0
srv_make_invnt_saldo 358 358 0 0.00 53 151284 4535 0 0
srv_make_money_saldo 596 596 0 0.00 1 14602 636 0 0
srv_recalc_idx_stat 3 3 0 0.00 227058 310117 276611 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4073 4073 0 0.00 0 13795 191 0 0
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 0 20830 138 0 0
t$perf-norm:sp_cancel_client_order 1497 1497 0 0.00 0 1472 11 0 0
t$perf-norm:sp_cancel_customer_reserve 550 550 0 0.00 0 9229 31 0 0
t$perf-norm:sp_cancel_pay_from_customer 560 560 0 0.00 0 370 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 317 317 0 0.00 0 354 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 350 350 0 0.00 0 7478 42 0 0
t$perf-norm:sp_cancel_supplier_order 369 369 0 0.00 0 19645 1578 0 0
t$perf-norm:sp_cancel_write_off 845 845 0 0.00 0 5559 13 0 0
t$perf-norm:sp_client_order 17049 17049 0 0.00 0 5311 15 0 0
t$perf-norm:sp_customer_reserve 810 810 0 0.00 0 9681 16 0 0
t$perf-norm:sp_pay_from_customer 5862 5862 0 0.00 0 7033 12 0 0
t$perf-norm:sp_pay_to_supplier 4908 4908 0 0.00 0 4196 8 0 0
t$perf-norm:sp_reserve_write_off 8264 8264 0 0.00 0 9190 14 0 0
t$perf-norm:sp_supplier_invoice 4572 4572 0 0.00 0 9217 22 0 0
t$perf-norm:sp_supplier_order 4573 4573 0 0.00 0 9264 19 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 47 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 1326 27 0 0
t$perf-norm:srv_make_invnt_saldo 358 358 0 0.00 0 2027 21 0 0
t$perf-norm:srv_make_money_saldo 596 596 0 0.00 0 1802 5 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 12 6 0 0
v_add_invoice_to_stock 8364 8134 230 2.74 0 2582 16 0 230
v_all_customers 31750 31750 0 0.00 0 109 1 0 0
v_all_suppliers 26202 26202 0 0.00 0 30 1 0 0
v_all_wares 34098 34098 0 0.00 0 35 1 0 0
v_cancel_adding_invoice 738 738 0 0.00 0 429 7 0 0
v_cancel_client_order 2994 2994 0 0.00 0 3632 6 0 0
v_cancel_customer_prepayment 1120 1120 0 0.00 0 8147 19 0 0
v_cancel_customer_reserve 1100 1100 0 0.00 0 2518 9 0 0
v_cancel_payment_to_supplier 634 634 0 0.00 0 2413 8 0 0
v_cancel_supplier_invoice 724 700 24 3.31 0 1511 17 0 24
v_cancel_supplier_order 738 738 0 0.00 0 1104 9 0 0
v_cancel_write_off 1690 1690 0 0.00 0 1087 12 0 0
v_max_id_clo_ord 4572 4572 0 0.00 0 1641 2 0 0
v_max_id_clo_res 810 810 0 0.00 0 5677 15 0 0
v_max_id_ord_sup 4561 4561 0 0.00 0 5412 5 0 0
v_max_non_paid_invoice 940 940 0 0.00 0 507 3 0 0
v_max_non_paid_realizn 2766 2766 0 0.00 0 9140 7 0 0
v_min_id_clo_ord 4572 4572 0 0.00 0 4033 11 0 0
v_min_id_clo_res 810 810 0 0.00 0 5830 13 0 0
v_min_id_ord_sup 4561 4561 0 0.00 0 6038 10 0 0
v_min_non_paid_invoice 4908 4908 0 0.00 0 11800 14 0 0
v_min_non_paid_realizn 5862 5862 0 0.00 0 15256 16 0 0
v_our_firm 8540 8540 0 0.00 0 18 1 0 0
v_reserve_write_off 16528 16528 0 0.00 0 2408 5 0 0
x_lock_depdocs_on_canc_invoice 9275 9275 0 0.00 0 8296 114 0 0
x_lock_depdocs_on_canc_sup_ord 369 369 0 0.00 0 6641 351 0 0
x_make_qstorno_1000_1200 4573 4573 0 0.00 1 62717 1186 0 0
x_make_qstorno_1200_2000 4572 4572 0 0.00 3 85241 3053 0 0
x_make_qstorno_2100_3300 394884 394884 0 0.00 0 61272 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-03-2024 13:09:28 to 25-03-2024 13:09:32.

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
11:07:52 7 8192000000 8799930096 8811696128 4463136 0.054 2 1 2 0 4562528 63616 35776
11:08:53 22059 8192000000 9700851120 9997467648 779544112 8.689 100 84 168 0 807086992 7526448 20016432
11:10:19 15441 8192000000 9745924832 10054017024 827121120 9.170 100 90 180 0 859088112 11052896 20914096
11:11:43 18442 8192000000 9784266464 10097627136 849906960 9.399 100 89 177 1 887570976 17549648 20114368
11:13:04 9990 8192000000 9830349664 10156072960 875831280 9.658 100 77 154 0 936826304 44052976 16942048
11:14:20 9109 8192000000 9882658864 10219708416 920136592 10.097 100 82 164 0 987783936 49969344 17678000
11:15:31 3485 8192000000 9923241920 10273865728 960407072 10.493 100 81 163 0 1032044944 55831536 15806336
11:16:36 3085 8192000000 9951461408 10313871360 992519168 10.806 100 90 178 1 1068192464 57855520 17817776
11:17:41 1789 8192000000 9993498352 10360741888 1025752800 11.128 100 86 170 0 1107727424 64963712 17010912
11:18:44 1444 8192000000 10025588320 10399510528 1042898288 11.293 100 84 167 1 1144797808 85729136 16170384
11:19:47 3770 8192000000 10026302432 10403291136 1057719296 11.435 100 76 151 1 1138064304 65729696 14615312
11:20:52 9291 8192000000 10007911936 10391982080 1065274640 11.507 100 73 147 0 1126363168 45927488 15161040
11:22:02 5325 8192000000 10000029712 10391449600 1069119056 11.544 100 46 89 4 1113086416 35237472 8729888
11:23:10 7487 8192000000 9982695088 10381557760 1078123488 11.630 100 37 72 3 1103913520 17871536 7918496
11:24:18 9530 8192000000 9980861312 10392231936 1077492064 11.624 100 13 26 0 1111591936 31781232 2318640
11:25:28 56535 8192000000 9994294720 10397433856 1081728480 11.664 100 26 52 1 1104230080 17354592 5147008
11:27:25 4372 8192000000 10012724000 10415452160 1085189328 11.697 100 47 93 2 1120200080 25438256 9572496
11:28:34 25636 8192000000 10027774624 10423640064 1080580208 11.653 99 46 92 0 1122610032 33407024 8622800
11:30:04 11581 8192000000 10059857184 10455388160 1087380384 11.718 99 50 98 0 1155994256 58341776 10272096
11:31:19 43648 8192000000 10078658432 10484654080 1074099440 11.591 97 38 76 0 1166108448 84517360 7491648
11:33:08 32471 8192000000 10064590112 10478788608 1074925488 11.599 98 27 54 2 1152891872 72289376 5677008
11:34:43 19544 8192000000 10080249344 10488434688 1079591008 11.644 99 41 82 1 1187393840 99590720 8212112
11:36:04 15504 8192000000 10058819904 10454601728 1062464112 11.480 99 41 80 0 1151299760 81065584 7770064
11:37:26 14617 8192000000 10076815344 10473291776 1082583232 11.672 100 45 90 0 1187298336 95522784 9192320
11:38:46 24927 8192000000 10091997664 10487582720 1057360928 11.431 98 31 62 0 1182289200 117756480 7171792
11:40:25 6071 8192000000 10158246064 10547941376 1089356896 11.737 99 58 115 0 1251369264 149629792 12382576
11:41:34 3040 8192000000 10194002672 10597224448 1096943056 11.809 100 67 131 0 1301395808 189923520 14529232
11:42:43 2436 8192000000 10276522160 10670206976 1117831056 12.006 100 71 142 0 1379627600 246239728 15556816
11:43:54 1338 8192000000 10316964752 10707959808 1115714128 11.986 99 80 157 0 1416448768 282395408 18339232
11:45:03 3237 8192000000 10372150848 10762723328 1118298480 12.011 100 87 172 1 1467138848 329165424 19674944
11:46:10 1488 8192000000 10373494256 10768347136 1125428336 12.078 100 89 178 0 1473569680 327556560 20584784
11:47:16 7884 8192000000 10385261872 10795397120 1130374512 12.125 100 68 136 0 1485846432 340011616 15460304
11:48:29 9509 8192000000 10397786576 10810454016 1136924000 12.187 100 62 125 0 1506799296 354869840 15005456
11:49:44 9531 8192000000 10363350128 10812219392 1142556832 12.240 100 42 84 0 1459894000 307109696 10227472
11:50:56 25807 8192000000 10209408448 10738761728 1107069840 11.905 98 26 52 0 1323669984 209774640 6825504
11:52:24 28868 8192000000 10150504032 10645929984 1116872432 11.997 100 9 18 0 1253659632 134557520 2229680
11:54:00 14652 8192000000 10081474784 10502524928 1123276656 12.058 100 33 67 2 1174106288 44041472 6788160
11:55:21 103422 8192000000 10042764448 10512867328 1121501120 12.041 100 12 24 0 1216699968 92513040 2685808
11:58:17 52943 8192000000 10065881936 10498863104 1127227936 12.095 100 41 79 1 1167119968 31823024 8069008
12:00:12 33372 8192000000 10149818144 10577649664 1137802160 12.195 100 44 88 0 1243960864 97466048 8692656
12:01:49 50164 8192000000 10160296400 10618048512 1145808304 12.270 100 32 64 2 1274856560 122296176 6752080
12:04:03 16806 8192000000 10137116288 10610573312 1146703840 12.279 100 17 32 0 1238590896 88357824 3529232
12:05:24 49152 8192000000 10135506944 10605400064 1140879888 12.224 100 24 48 0 1234601504 87736112 5985504
12:07:14 35035 8192000000 10131279840 10621317120 1147612096 12.287 100 17 32 0 1245056528 94021872 3422560
12:09:19 33870 8192000000 10075462880 10571812864 1147246208 12.284 100 12 24 0 1219578736 69916240 2416288
12:10:54 76060 8192000000 10069094992 10528751616 1131148912 12.132 98 9 18 1 1168625040 36147280 1328848
12:13:13 23373 8192000000 10127173168 10558529536 1124029824 12.065 97 46 88 0 1193933680 61434672 8469184
12:14:39 48839 8192000000 10085801584 10554920960 1104073520 11.876 96 20 40 0 1152854720 45030048 3751152
12:16:34 43463 8192000000 10120573792 10546675712 1089751904 11.740 96 35 70 0 1156460144 59880304 6827936
12:18:28 61034 8192000000 10070256304 10583216128 1090363360 11.746 97 8 16 0 1159985120 68226896 1394864
12:20:37 45971 8192000000 10053636560 10486640640 1109031056 11.923 100 28 54 2 1162310864 47767248 5512560
12:22:27 109693 8192000000 10045524960 10513059840 1043051776 11.294 93 37 74 0 1098354912 47932480 7370656
12:25:18 31947 8192000000 10019345680 10444464128 1047538592 11.337 95 37 74 0 1084611760 29425920 7647248
12:27:25 46234 8192000000 10001240928 10448556032 1029384080 11.163 95 16 32 0 1075150976 42413584 3353312
12:29:12 66077 8192000000 10080019520 10524123136 1099000656 11.828 100 22 44 0 1184300768 80458608 4841504
12:31:21 44457 8192000000 10089873488 10543882240 1102501440 11.861 100 36 71 0 1171177568 61106496 7569632
12:33:06 59801 8192000000 10028397888 10454691840 1035499056 11.221 94 17 32 0 1073398240 34650416 3248768
12:35:07 29408 8192000000 10064072608 10492317696 1083537632 11.681 99 34 69 1 1150034304 59515008 6981664
12:36:40 78810 8192000000 10105559648 10549379072 1078889984 11.637 98 26 52 0 1170087072 85504800 5692288
12:39:23 129037 8192000000 10040883744 10490052608 1061947680 11.475 96 13 26 0 1095844176 31333536 2562960
12:42:33 31335 8192000000 10054613360 10470400000 1101657104 11.853 99 41 82 0 1142268176 32252512 8358560
12:44:04 99080 8192000000 10056098528 10495610880 1117958240 12.008 100 29 58 0 1189889168 66771376 5159552
12:46:46 27341 8192000000 10067558400 10529644544 1126759776 12.091 100 10 20 0 1169606112 40872816 1973520
12:48:16 47943 8192000000 10089697504 10543742976 1134375344 12.163 100 17 35 0 1180886912 42949088 3562480
12:50:04 38849 8192000000 10146210448 10599034880 1132156528 12.142 100 25 50 0 1229613504 91719472 5737504
12:52:17 35497 8192000000 10077332880 10522157056 1133955232 12.159 100 16 30 0 1175091136 37899104 3236800
12:53:53 48215 8192000000 10095617808 10551975936 1130050112 12.122 99 17 34 0 1200100656 66614304 3436240
12:55:47 44501 8192000000 10100867184 10546270208 1131711040 12.137 99 30 58 0 1178850896 41514656 5625200
12:57:45 66529 8192000000 10074626048 10506747904 1122912912 12.055 99 20 40 0 1158884592 32111792 3859888
12:59:54 123405 8192000000 10069080272 10557108224 1108122144 11.915 97 12 24 0 1183359024 72436896 2799984
13:03:54 42423 8192000000 10065312768 10537758720 1110370864 11.936 98 7 14 0 1178719696 66461152 1887680
13:05:43 47085 8192000000 10078410576 10545917952 1111125040 11.943 99 15 30 0 1158616480 44182208 3309232
13:07:37 19803 8192000000 8953563136 9173336064 117363168 1.412 11 3 6 0 142077344 24129136 585040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-03-2024 13:09:34 to 25-03-2024 13:09:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 115 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2024 13:09:49 to 25-03-2024 13:09:51.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Mar 25 13:09:52 2024 
 
Database header page information: 
    Flags            0 
    Generation        88827 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    170175 
    Oldest active        170176 
    Oldest snapshot        170176 
    Next transaction    170177 
    Sequence number        0 
    Next attachment ID    686 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.56, total records: 7692546 
    Average version length: 48.16, total versions: 66252, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88432 
    Data pages: 88432, average fill: 70% 
    Primary pages: 88431, secondary pages: 1, swept pages: 39650 
    Empty pages: 5, full pages: 68009 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 95 
    40 - 59% = 1776 
    60 - 79% = 86519 
    80 - 99% = 24 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23104, nodes: 7692546 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1655512, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 330 
        20 - 39% = 1932 
        40 - 59% = 3934 
        60 - 79% = 2420 
        80 - 99% = 14488 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13440, nodes: 7692546 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1479998, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1691 
        40 - 59% = 1877 
        60 - 79% = 1144 
        80 - 99% = 8728 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8244, nodes: 7692546 
    Average node length: 6.60, total dup: 5774310, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1473028, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 1039 
        40 - 59% = 1271 
        60 - 79% = 938 
        80 - 99% = 4898 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.67, total records: 2208582 
    Average version length: 58.87, total versions: 34283, max versions: 2 
    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: 28648 
    Data pages: 28648, average fill: 71% 
    Primary pages: 28645, secondary pages: 3, swept pages: 11319 
    Empty pages: 10, full pages: 17361 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 52 
    40 - 59% = 1623 
    60 - 79% = 26904 
    80 - 99% = 48 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4501, nodes: 2208582 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 669603, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 963 
        40 - 59% = 773 
        60 - 79% = 735 
        80 - 99% = 2030 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2403, nodes: 2209666 
    Average node length: 4.97, total dup: 2208767, max dup: 18982 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1244386, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 234 
        40 - 59% = 1386 
        60 - 79% = 515 
        80 - 99% = 266 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1777, nodes: 2208582 
    Average node length: 4.97, total dup: 2208532, max dup: 130133 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056893, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 13 
        40 - 59% = 623 
        60 - 79% = 39 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4307, nodes: 2208582 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 669603, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 610 
        40 - 59% = 617 
        60 - 79% = 818 
        80 - 99% = 2164 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.24, total records: 400 
    Average version length: 28.32, total versions: 2661, max versions: 8 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 62% 
    Primary pages: 8, secondary pages: 24, swept pages: 0 
    Empty pages: 7, full pages: 20 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 20 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.51, total records: 97616 
    Average version length: 68.29, total versions: 93481, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.64 
    Pointer pages: 7, data page slots: 2976 
    Data pages: 1760, average fill: 75% 
    Primary pages: 1759, secondary pages: 1, swept pages: 0 
    Empty pages: 108, full pages: 1256 
    Fill distribution: 
     0 - 19% = 174 
    20 - 39% = 83 
    40 - 59% = 156 
    60 - 79% = 197 
    80 - 99% = 1150 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705212, depth: 3, leaf buckets: 329, nodes: 97616 
    Average node length: 13.06, total dup: 6712, max dup: 1 
    Average key length: 10.65, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 70161, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 162 
        60 - 79% = 57 
        80 - 99% = 8 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 238, max versions: 7 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 6 
    Data pages: 5, average fill: 19% 
    Primary pages: 1, secondary pages: 4, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.10, total records: 2010 
    Average version length: 43.47, total versions: 1890, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.22 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 66% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 5, full pages: 19 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91252, depth: 2, leaf buckets: 4, nodes: 2010 
    Average node length: 4.13, total dup: 1912, max dup: 195 
    Average key length: 2.53, compression ratio: 7.52 
    Average prefix length: 18.52, average data length: 0.48 
    Clustering factor: 1078, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.78, 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% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, 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: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.61, total records: 812775 
    Average version length: 37.89, total versions: 24054, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8624 
    Data pages: 8624, average fill: 64% 
    Primary pages: 8622, secondary pages: 2, swept pages: 2421 
    Empty pages: 32, full pages: 5832 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 74 
    40 - 59% = 679 
    60 - 79% = 7776 
    80 - 99% = 35 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 876, nodes: 801052 
    Average node length: 4.88, total dup: 801003, max dup: 149005 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90062, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 134 
        40 - 59% = 482 
        60 - 79% = 169 
        80 - 99% = 90 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 945, nodes: 801052 
    Average node length: 5.89, total dup: 713159, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160324, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 34 
        40 - 59% = 532 
        60 - 79% = 99 
        80 - 99% = 278 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 973, nodes: 801052 
    Average node length: 5.89, total dup: 713159, max dup: 47 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162173, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 80 
        40 - 59% = 532 
        60 - 79% = 93 
        80 - 99% = 268 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1144, nodes: 801052 
    Average node length: 5.97, total dup: 713159, max dup: 47 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154817, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 227 
        40 - 59% = 630 
        60 - 79% = 204 
        80 - 99% = 80 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5462 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.09, total fragments: 11, 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: 76, secondary pages: 12, swept pages: 61 
    Empty pages: 6, full pages: 55 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5462 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.07 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5147, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5462 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 165, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 77225 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 802 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 802 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35582, depth: 2, leaf buckets: 99, nodes: 77225 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2762, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.66, total records: 149323 
    Average version length: 150.82, total versions: 1432, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 3848 
    Data pages: 3696, average fill: 83% 
    Primary pages: 3694, secondary pages: 2, swept pages: 1 
    Empty pages: 25, full pages: 3661 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3661 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.13, total records: 151637 
    Average version length: 152.80, total versions: 3204, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 9, data page slots: 5360 
    Data pages: 3784, average fill: 83% 
    Primary pages: 3782, secondary pages: 2, swept pages: 4 
    Empty pages: 48, full pages: 3718 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3717 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.91, total records: 153196 
    Average version length: 149.63, total versions: 1052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 3928 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3791, secondary pages: 1, swept pages: 3 
    Empty pages: 32, full pages: 3751 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3751 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.65, total records: 158607 
    Average version length: 151.51, total versions: 1575, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 8, data page slots: 4032 
    Data pages: 3928, average fill: 83% 
    Primary pages: 3926, secondary pages: 2, swept pages: 3 
    Empty pages: 31, full pages: 3888 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3889 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.37, total records: 138660 
    Average version length: 149.70, total versions: 1237, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 3600 
    Data pages: 3408, average fill: 84% 
    Primary pages: 3406, secondary pages: 2, swept pages: 2 
    Empty pages: 10, full pages: 3388 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3388 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.53, total records: 164490 
    Average version length: 147.45, total versions: 675, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 7, data page slots: 4592 
    Data pages: 4048, average fill: 84% 
    Primary pages: 4047, secondary pages: 1, swept pages: 1 
    Empty pages: 7, full pages: 4037 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 4037 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 143.82, total records: 157322 
    Average version length: 154.85, total versions: 7812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.79 
    Pointer pages: 7, data page slots: 4384 
    Data pages: 3904, average fill: 84% 
    Primary pages: 3902, secondary pages: 2, swept pages: 4 
    Empty pages: 36, full pages: 3856 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 3854 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 146.05, total records: 157489 
    Average version length: 153.24, total versions: 5339, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 6, data page slots: 5344 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3934, secondary pages: 2, swept pages: 3 
    Empty pages: 63, full pages: 3857 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3858 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 141.93, total records: 182955 
    Average version length: 154.87, total versions: 12036, 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: 8, data page slots: 4728 
    Data pages: 4568, average fill: 83% 
    Primary pages: 4565, secondary pages: 3, swept pages: 4 
    Empty pages: 59, full pages: 4496 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4496 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.49, total records: 159173 
    Average version length: 152.48, total versions: 2786, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 6, data page slots: 6152 
    Data pages: 3968, average fill: 83% 
    Primary pages: 3966, secondary pages: 2, swept pages: 3 
    Empty pages: 52, full pages: 3901 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3901 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.10, total records: 2084646 
    Average version length: 52.97, total versions: 30598, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25728 
    Data pages: 25728, average fill: 70% 
    Primary pages: 25711, secondary pages: 17, swept pages: 11449 
    Empty pages: 224, full pages: 22216 
    Fill distribution: 
     0 - 19% = 389 
    20 - 39% = 334 
    40 - 59% = 877 
    60 - 79% = 23838 
    80 - 99% = 290 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2580, nodes: 2084646 
    Average node length: 5.44, total dup: 1945289, max dup: 1812 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180944, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 308 
        40 - 59% = 1704 
        60 - 79% = 265 
        80 - 99% = 299 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2751, nodes: 2084646 
    Average node length: 5.69, total dup: 1870901, max dup: 62 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373069, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2448 
        60 - 79% = 275 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2117, nodes: 2084646 
    Average node length: 4.96, total dup: 2084546, max dup: 27665 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178651, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 182 
        40 - 59% = 1144 
        60 - 79% = 344 
        80 - 99% = 446 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 42.85, total records: 138818 
    Average version length: 69.18, total versions: 60791, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.94 
    Pointer pages: 3, data page slots: 4136 
    Data pages: 3016, average fill: 56% 
    Primary pages: 3016, secondary pages: 0, swept pages: 335 
    Empty pages: 441, full pages: 1342 
    Fill distribution: 
     0 - 19% = 557 
    20 - 39% = 249 
    40 - 59% = 517 
    60 - 79% = 864 
    80 - 99% = 829 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554197, depth: 3, leaf buckets: 216, nodes: 138818 
    Average node length: 6.45, total dup: 120786, max dup: 14 
    Average key length: 3.96, compression ratio: 10.62 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 24238, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 45 
        40 - 59% = 103 
        60 - 79% = 64 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.63, total records: 7107779 
    Average version length: 68.69, total versions: 275100, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 67, data page slots: 108192 
    Data pages: 108192, average fill: 70% 
    Primary pages: 108191, secondary pages: 1, swept pages: 35326 
    Empty pages: 4, full pages: 54694 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 450 
    40 - 59% = 8353 
    60 - 79% = 98469 
    80 - 99% = 903 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10743, nodes: 7107779 
    Average node length: 6.51, total dup: 6150073, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1674059, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1687 
        40 - 59% = 5778 
        60 - 79% = 2777 
        80 - 99% = 491 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8612, nodes: 7107779 
    Average node length: 5.39, total dup: 6828411, max dup: 146 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1476703, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1230 
        40 - 59% = 4748 
        60 - 79% = 1661 
        80 - 99% = 964 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8659, nodes: 7107779 
    Average node length: 5.39, total dup: 6828411, max dup: 146 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1478991, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1282 
        40 - 59% = 4742 
        60 - 79% = 1650 
        80 - 99% = 979 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.84, total records: 12078651 
    Average version length: 68.70, total versions: 220223, 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: 109, data page slots: 176512 
    Data pages: 176512, average fill: 73% 
    Primary pages: 176512, secondary pages: 0, swept pages: 86285 
    Empty pages: 2, full pages: 138248 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 496 
    40 - 59% = 6483 
    60 - 79% = 168360 
    80 - 99% = 1134 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18479, nodes: 12076612 
    Average node length: 6.62, total dup: 10530857, max dup: 59 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2474372, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2387 
        40 - 59% = 10643 
        60 - 79% = 4635 
        80 - 99% = 784 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 52.44, total records: 1474388 
    Average version length: 69.10, total versions: 228814, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.40 
    Pointer pages: 27, data page slots: 42728 
    Data pages: 28408, average fill: 53% 
    Primary pages: 28332, secondary pages: 76, swept pages: 9827 
    Empty pages: 2896, full pages: 16222 
    Fill distribution: 
     0 - 19% = 5062 
    20 - 39% = 4109 
    40 - 59% = 3039 
    60 - 79% = 13444 
    80 - 99% = 2754 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1848, nodes: 1293553 
    Average node length: 5.51, total dup: 1241454, max dup: 49 
    Average key length: 2.57, compression ratio: 16.34 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 89247, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 571 
        40 - 59% = 874 
        60 - 79% = 356 
        80 - 99% = 36 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 41.58, total records: 1083162 
    Average version length: 69.00, total versions: 142763, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 21, data page slots: 33720 
    Data pages: 28400, average fill: 34% 
    Primary pages: 28399, secondary pages: 1, swept pages: 8155 
    Empty pages: 6068, full pages: 6683 
    Fill distribution: 
     0 - 19% = 10144 
    20 - 39% = 5050 
    40 - 59% = 7254 
    60 - 79% = 5719 
    80 - 99% = 233 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1156, nodes: 730942 
    Average node length: 5.96, total dup: 672718, max dup: 87 
    Average key length: 3.03, compression ratio: 13.87 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 105263, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 413 
        40 - 59% = 531 
        60 - 79% = 197 
        80 - 99% = 15 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.69, total records: 8928948 
    Average version length: 68.98, total versions: 324364, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 88, data page slots: 142128 
    Data pages: 142096, average fill: 67% 
    Primary pages: 142077, secondary pages: 19, swept pages: 57050 
    Empty pages: 287, full pages: 67299 
    Fill distribution: 
     0 - 19% = 1106 
    20 - 39% = 5573 
    40 - 59% = 20370 
    60 - 79% = 113383 
    80 - 99% = 1664 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13404, nodes: 8925030 
    Average node length: 6.67, total dup: 7403500, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2008276, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1508 
        40 - 59% = 7185 
        60 - 79% = 4196 
        80 - 99% = 514 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21107868 
    Average version length: 82.95, total versions: 8057, 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: 319216 
    Data pages: 319216, average fill: 81% 
    Primary pages: 319212, secondary pages: 4, swept pages: 13120 
    Empty pages: 42, full pages: 318213 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 66 
    40 - 59% = 134 
    60 - 79% = 48594 
    80 - 99% = 270356 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19371, nodes: 21107868 
    Average node length: 5.72, total dup: 20627796, max dup: 135 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3275937, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 3 
        40 - 59% = 8165 
        60 - 79% = 567 
        80 - 99% = 10632 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17110, nodes: 21107868 
    Average node length: 6.31, total dup: 18548968, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914306, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 711 
        60 - 79% = 285 
        80 - 99% = 16106 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21120, nodes: 21107868 
    Average node length: 6.35, total dup: 18468671, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3569936, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8383 
        60 - 79% = 609 
        80 - 99% = 12123 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16051, nodes: 21107868 
    Average node length: 5.56, total dup: 21107768, max dup: 229870 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943283, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 13 
        40 - 59% = 2866 
        60 - 79% = 347 
        80 - 99% = 12823 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.12, total records: 9343119 
    Average version length: 82.65, total versions: 290240, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 105, data page slots: 169808 
    Data pages: 169752, average fill: 68% 
    Primary pages: 169724, secondary pages: 28, swept pages: 82808 
    Empty pages: 655, full pages: 93844 
    Fill distribution: 
     0 - 19% = 2058 
    20 - 39% = 9447 
    40 - 59% = 27258 
    60 - 79% = 113457 
    80 - 99% = 17532 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11313, nodes: 9343119 
    Average node length: 5.36, total dup: 9040027, max dup: 188 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2106251, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 80 
        40 - 59% = 9099 
        60 - 79% = 2091 
        80 - 99% = 41 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13169, nodes: 9343119 
    Average node length: 6.22, total dup: 7746383, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1470000, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 4117 
        40 - 59% = 4099 
        60 - 79% = 2577 
        80 - 99% = 2271 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12626, nodes: 9343119 
    Average node length: 5.98, total dup: 8100979, max dup: 35 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2289219, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 106 
        40 - 59% = 10162 
        60 - 79% = 2311 
        80 - 99% = 46 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9890, nodes: 9343119 
    Average node length: 5.12, total dup: 9343019, max dup: 156214 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1499495, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1354 
        40 - 59% = 4855 
        60 - 79% = 1705 
        80 - 99% = 1934 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.63, total records: 11071158 
    Average version length: 82.60, total versions: 250953, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 192576 
    Data pages: 190880, average fill: 71% 
    Primary pages: 190769, secondary pages: 111, swept pages: 70113 
    Empty pages: 3041, full pages: 142493 
    Fill distribution: 
     0 - 19% = 5438 
    20 - 39% = 8498 
    40 - 59% = 18059 
    60 - 79% = 97561 
    80 - 99% = 61324 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13112, nodes: 11071158 
    Average node length: 5.29, total dup: 10962316, max dup: 634 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2312321, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 179 
        40 - 59% = 9763 
        60 - 79% = 3096 
        80 - 99% = 73 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10250, nodes: 11071158 
    Average node length: 5.49, total dup: 10587325, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 703712, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 864 
        40 - 59% = 2513 
        60 - 79% = 1761 
        80 - 99% = 4943 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14989, nodes: 11071158 
    Average node length: 6.02, total dup: 9659931, max dup: 82 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2328625, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 213 
        40 - 59% = 11359 
        60 - 79% = 3321 
        80 - 99% = 96 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10529, nodes: 11071158 
    Average node length: 5.21, total dup: 11071058, max dup: 190899 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 692218, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 859 
        40 - 59% = 4590 
        60 - 79% = 1491 
        80 - 99% = 3501 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.53, total records: 9449481 
    Average version length: 82.92, total versions: 282194, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 107, data page slots: 173680 
    Data pages: 173616, average fill: 68% 
    Primary pages: 173588, secondary pages: 28, swept pages: 86943 
    Empty pages: 982, full pages: 93142 
    Fill distribution: 
     0 - 19% = 2735 
    20 - 39% = 10526 
    40 - 59% = 28172 
    60 - 79% = 115190 
    80 - 99% = 16993 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11511, nodes: 9449481 
    Average node length: 5.17, total dup: 9421251, max dup: 1537 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1918260, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1554 
        40 - 59% = 7590 
        60 - 79% = 1776 
        80 - 99% = 552 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13300, nodes: 9449481 
    Average node length: 6.24, total dup: 7833965, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1443677, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 4072 
        40 - 59% = 4054 
        60 - 79% = 2634 
        80 - 99% = 2381 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12152, nodes: 9449481 
    Average node length: 5.43, total dup: 9023747, max dup: 95 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2048240, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1534 
        40 - 59% = 8505 
        60 - 79% = 1564 
        80 - 99% = 517 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9994, nodes: 9449481 
    Average node length: 5.14, total dup: 9449381, max dup: 157553 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1520342, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1359 
        40 - 59% = 4942 
        60 - 79% = 1584 
        80 - 99% = 2061 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.68, total records: 571331 
    Average version length: 68.81, total versions: 4710, 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: 8008 
    Data pages: 8008, average fill: 75% 
    Primary pages: 8008, secondary pages: 0, swept pages: 3529 
    Empty pages: 0, full pages: 6985 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 16 
    40 - 59% = 132 
    60 - 79% = 7807 
    80 - 99% = 52 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 29103, depth: 3, leaf buckets: 730, nodes: 571331 
    Average node length: 5.95, total dup: 486228, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100858, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 525 
        60 - 79% = 86 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29895, depth: 3, leaf buckets: 754, nodes: 571331 
    Average node length: 6.15, total dup: 468553, max dup: 16 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100913, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 543 
        60 - 79% = 86 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 551, nodes: 571331 
    Average node length: 4.86, total dup: 571231, max dup: 8978 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89700, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 311 
        60 - 79% = 67 
        80 - 99% = 143 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Mar 25 13:10:16 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7692546 66252 1 0.0000 0.0000
DOC_LIST 2208582 34283 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2661 8 600.0000 0.0000
INVNT_TURNOVER_LOG 97616 93481 1 0.0000 0.0000
MONEY_SALDO 49 238 7 400.0000 0.0000
MONEY_TURNOVER_LOG 2010 1890 1 0.0000 0.0000
PDISTR 812775 24054 2 0.0000 0.0000
PERF_SPLIT_0 149323 1432 1 0.0000 0.0000
PERF_SPLIT_1 151637 3204 1 0.0000 0.0000
PERF_SPLIT_2 153196 1052 1 0.0000 0.0000
PERF_SPLIT_3 158607 1575 1 0.0000 0.0000
PERF_SPLIT_4 138660 1237 1 0.0000 0.0000
PERF_SPLIT_5 164490 675 1 0.0000 0.0000
PERF_SPLIT_6 157322 7812 1 0.0000 0.0000
PERF_SPLIT_7 157489 5339 1 0.0000 0.0000
PERF_SPLIT_8 182955 12036 1 0.0000 0.0000
PERF_SPLIT_9 159173 2786 1 0.0000 0.0000
PSTORNED 2084646 30598 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 138818 60791 1 0.0000 0.0000
XQD_1000_3300 7107779 275100 1 0.0000 0.0000
XQD_1200_2000 12078651 220223 1 0.0000 0.0000
XQD_2000_3300 1474388 228814 1 0.0000 0.0000
XQD_2100_3300 1083162 142763 1 0.0000 0.0000
XQD_3300_3400 8928948 324364 1 0.0000 0.0000
XQS_1000_1200 21107868 8057 1 0.0000 0.0000
XQS_1000_3300 9343119 290240 1 0.0000 0.0000
XQS_1200_2000 11071158 250953 1 0.0000 0.0000
XQS_2100_3300 9449481 282194 1 0.0000 0.0000
XQS_3300_3400 571331 4710 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test 

--- start of diff output ---
--- end of diff output ---

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

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