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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15658244 kB
MemAvailable 30292320 kB
Buffers 0 kB
Cached 16091760 kB
SwapCached 2412 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-02-23 10:07:48
DTS_END                         2024-02-23 10:07:48.9640
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/47086
TRN_ID                          175411
ATT_ID                          561
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: 9442.45 18291 944245
customer order: creation 181.67 413 18167
customer order: refuse 14.48 320 1448
order to supplier: creation 48.15 1306 4815
order to supplier: removal 3.38 100469 338
invoice (draft): creation 48.46 3087 4846
invoice (draft): removal 51.48 760 5148
invoice accept: apply 43.81 18772 4381
invoice accept: cancel 46.50 824 4650
customer reserve: creation 4205.01 180 420501
customer reserve: removal 4494.99 60 449499
realization accept: apply 86.46 218 8646
realization accept: cancel 81.49 126 8149
payment from customer: creation 62.73 118 6273
payment from customer: removal 6.18 150 618
payment to supplier: creation 52.27 134 5227
payment to supplier: removal 3.64 79 364
service: total inventory turnovers 3.82 3985 382
service: total monetary turnovers 6.87 445 687
service: aggregate perf. data 1.03 12681 103
service: refresh index statistics 0.03 221695 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-02-2024 10:10:33 to 23-02-2024 10:10:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5830
TEST_TIME 2 4392
TEST_TIME 3 3567
TEST_TIME 4 4046
TEST_TIME 5 3960
TEST_TIME 6 4146
TEST_TIME 7 4825
TEST_TIME 8 4906
TEST_TIME 9 5013
TEST_TIME 10 5248
TEST_TIME 11 5362
TEST_TIME 12 5503
TEST_TIME 13 5672
TEST_TIME 14 5727
TEST_TIME 15 5939
TEST_TIME 16 6446
TEST_TIME 17 6584
TEST_TIME 18 6929
TEST_TIME 19 7056
TEST_TIME 20 7583
TEST_TIME 21 7750
TEST_TIME 22 8258
TEST_TIME 23 9075
TEST_TIME 24 9252
TEST_TIME 25 9732
TEST_TIME 26 9883
TEST_TIME 27 9636
TEST_TIME 28 9504
TEST_TIME 29 9818
TEST_TIME 30 9875
TEST_TIME 31 9721
TEST_TIME 32 9508
TEST_TIME 33 9363
TEST_TIME 34 9221
TEST_TIME 35 9223
TEST_TIME 36 9180
TEST_TIME 37 9165
TEST_TIME 38 9253
TEST_TIME 39 9140
TEST_TIME 40 9237
TEST_TIME 41 9103
TEST_TIME 42 9337
TEST_TIME 43 9323
TEST_TIME 44 9561
TEST_TIME 45 9526
TEST_TIME 46 9549
TEST_TIME 47 9487
TEST_TIME 48 9734
TEST_TIME 49 9799
TEST_TIME 50 9820
TEST_TIME 51 9816
TEST_TIME 52 9861
TEST_TIME 53 9937
TEST_TIME 54 9919
TEST_TIME 55 9753
TEST_TIME 56 9706
TEST_TIME 57 9702
TEST_TIME 58 9629
TEST_TIME 59 9715
TEST_TIME 60 9635
TEST_TIME 61 9612
TEST_TIME 62 9566
TEST_TIME 63 9486
TEST_TIME 64 9408
TEST_TIME 65 9435
TEST_TIME 66 9446
TEST_TIME 67 9437
TEST_TIME 68 9475
TEST_TIME 69 9453
TEST_TIME 70 9462
TEST_TIME 71 9477
TEST_TIME 72 9551
TEST_TIME 73 9589
TEST_TIME 74 9557
TEST_TIME 75 9549
TEST_TIME 76 9601
TEST_TIME 77 9628
TEST_TIME 78 9702
TEST_TIME 79 9665
TEST_TIME 80 9569
TEST_TIME 81 9543
TEST_TIME 82 9566
TEST_TIME 83 9540
TEST_TIME 84 9478
TEST_TIME 85 9417
TEST_TIME 86 9386
TEST_TIME 87 9460
TEST_TIME 88 9420
TEST_TIME 89 9420
TEST_TIME 90 9504
TEST_TIME 91 9497
TEST_TIME 92 9528
TEST_TIME 93 9544
TEST_TIME 94 9644
TEST_TIME 95 9646
TEST_TIME 96 9670
TEST_TIME 97 9623
TEST_TIME 98 9529
TEST_TIME 99 9493
TEST_TIME 100 9452

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-02-2024 10:10:37 to 23-02-2024 10:10:40.

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 1328626 1328626 0 0.00 0 28722 7 0 0
doc_list_biud 1328611 1328611 0 0.00 0 61931 26 0 0
sp_add_invoice_to_stock 4482 4381 101 2.25 37 157827 18772 0 101
sp_cancel_adding_invoice 4650 4650 0 0.00 4 86045 825 0 0
sp_cancel_client_order 1448 1448 0 0.00 4 9512 321 0 0
sp_cancel_customer_reserve 449499 449499 0 0.00 0 61933 61 0 0
sp_cancel_pay_from_customer 618 618 0 0.00 2 15413 150 0 0
sp_cancel_pay_to_supplier 364 364 0 0.00 2 5423 80 0 0
sp_cancel_supplier_invoice 5155 5148 7 0.13 1 14273 760 0 7
sp_cancel_supplier_order 338 338 0 0.00 10 1161195 100470 0 0
sp_cancel_write_off 8149 8149 0 0.00 1 21673 127 0 0
sp_client_order 18167 18167 0 0.00 3 21555 414 0 0
sp_customer_reserve 420501 420501 0 0.00 0 40257 181 0 0
sp_fill_shopping_cart 27820 27820 0 0.00 1 20211 39 0 0
sp_fill_shopping_cart_clo_res 420490 420490 0 0.00 0 23924 17 0 0
sp_get_clo_for_invoice 4370 4370 0 0.00 0 34791 368 0 0
sp_kill_cost_storno 13781 13781 0 0.00 0 21776 68 0 0
sp_kill_qstorno_ret_qs2qd 912633 912633 0 0.00 0 57364 33 0 0
sp_kill_qty_storno 482247 482247 0 0.00 0 61931 70 0 0
sp_lock_selected_doc 17900 17900 0 0.00 0 8929 7 0 0
sp_make_cost_storno 24515 24515 0 0.00 0 28707 68 0 0
sp_multiply_rows_for_pdistr 24515 24515 0 0.00 0 19367 35 0 0
sp_multiply_rows_for_qdistr 18163 18163 0 0.00 0 15866 232 0 0
sp_pay_from_customer 6273 6273 0 0.00 4 16145 118 0 0
sp_pay_to_supplier 5227 5227 0 0.00 4 20457 134 0 0
sp_payment_common 11500 11500 0 0.00 1 13604 26 0 0
sp_qd_handle_on_cancel_clo 1448 1448 0 0.00 0 9507 298 0 0
sp_qd_handle_on_invoice_upd_sts 9019 9019 0 0.00 0 12689 292 0 0
sp_qd_handle_on_reserve_upd_sts 8646 8646 0 0.00 0 27619 60 0 0
sp_reserve_write_off 8646 8646 0 0.00 6 29140 219 0 0
sp_supplier_invoice 4846 4846 0 0.00 7 94832 3087 0 0
sp_supplier_order 4815 4815 0 0.00 5 50360 1306 0 0
srv_aggregate_perf_data 103 103 0 0.00 1675 126766 12682 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1963 146932 42381 0 0
srv_find_qd_qs_mism 899205 899205 0 0.00 0 11732 6 0 0
srv_make_invnt_saldo 382 382 0 0.00 37 97833 3986 0 0
srv_make_money_saldo 687 687 0 0.00 1 10536 446 0 0
srv_recalc_idx_stat 3 3 0 0.00 77629 300298 221695 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4382 4382 0 0.00 0 13817 158 0 0
t$perf-norm:sp_cancel_adding_invoice 338 338 0 0.00 0 7917 96 0 0
t$perf-norm:sp_cancel_client_order 1448 1448 0 0.00 0 7039 16 0 0
t$perf-norm:sp_cancel_customer_reserve 604 604 0 0.00 0 604 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 618 618 0 0.00 0 196 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 364 364 0 0.00 0 13396 49 0 0
t$perf-norm:sp_cancel_supplier_invoice 333 333 0 0.00 0 2631 32 0 0
t$perf-norm:sp_cancel_supplier_order 338 338 0 0.00 0 51399 1951 0 0
t$perf-norm:sp_cancel_write_off 842 842 0 0.00 0 733 6 0 0
t$perf-norm:sp_client_order 18167 18167 0 0.00 0 7005 14 0 0
t$perf-norm:sp_customer_reserve 903 903 0 0.00 0 3048 6 0 0
t$perf-norm:sp_pay_from_customer 6273 6273 0 0.00 0 7324 8 0 0
t$perf-norm:sp_pay_to_supplier 5227 5227 0 0.00 0 4940 8 0 0
t$perf-norm:sp_reserve_write_off 8646 8646 0 0.00 0 3730 9 0 0
t$perf-norm:sp_supplier_invoice 4846 4846 0 0.00 0 4671 16 0 0
t$perf-norm:sp_supplier_order 4815 4815 0 0.00 0 10038 19 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 276 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 147 4 0 0
t$perf-norm:srv_make_invnt_saldo 382 382 0 0.00 0 1628 10 0 0
t$perf-norm:srv_make_money_saldo 687 687 0 0.00 0 5600 14 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 8940 8738 202 2.25 0 4935 17 0 202
v_all_customers 33774 33774 0 0.00 0 115 1 0 0
v_all_suppliers 27470 27470 0 0.00 0 117 1 0 0
v_all_wares 36326 36326 0 0.00 0 208 1 0 0
v_cancel_adding_invoice 676 676 0 0.00 0 1379 8 0 0
v_cancel_client_order 2896 2896 0 0.00 0 4059 5 0 0
v_cancel_customer_prepayment 1236 1236 0 0.00 0 4484 9 0 0
v_cancel_customer_reserve 1208 1208 0 0.00 0 273 3 0 0
v_cancel_payment_to_supplier 728 728 0 0.00 0 1226 9 0 0
v_cancel_supplier_invoice 680 666 14 2.05 0 2276 16 0 14
v_cancel_supplier_order 676 676 0 0.00 0 161 2 0 0
v_cancel_write_off 1684 1684 0 0.00 0 4200 19 0 0
v_max_id_clo_ord 4811 4811 0 0.00 0 2704 3 0 0
v_max_id_clo_res 903 903 0 0.00 0 5921 15 0 0
v_max_id_ord_sup 4846 4846 0 0.00 0 4087 3 0 0
v_max_non_paid_invoice 1149 1149 0 0.00 0 549 2 0 0
v_max_non_paid_realizn 3034 3034 0 0.00 0 738 3 0 0
v_min_id_clo_ord 4811 4811 0 0.00 0 11707 20 0 0
v_min_id_clo_res 903 903 0 0.00 0 7166 17 0 0
v_min_id_ord_sup 4846 4846 0 0.00 0 5194 6 0 0
v_min_non_paid_invoice 5227 5227 0 0.00 0 13599 22 0 0
v_min_non_paid_realizn 6273 6273 0 0.00 0 8549 19 0 0
v_our_firm 9030 9030 0 0.00 0 25 1 0 0
v_reserve_write_off 17292 17292 0 0.00 0 5334 6 0 0
x_lock_depdocs_on_canc_invoice 9465 9465 0 0.00 0 17843 109 0 0
x_lock_depdocs_on_canc_sup_ord 338 338 0 0.00 0 8323 329 0 0
x_make_qstorno_1000_1200 4815 4815 0 0.00 2 50347 1212 0 0
x_make_qstorno_1200_2000 4846 4846 0 0.00 3 94813 2955 0 0
x_make_qstorno_2100_3300 420501 420501 0 0.00 0 40256 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-02-2024 10:10:41 to 23-02-2024 10:10:45.

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
08:07:52 3 8192000000 8799250320 8810582016 5257232 0.064 2 1 2 0 5356656 63648 35776
08:08:53 35736 8192000000 9719394272 10017443840 791950992 8.815 100 85 170 0 820016128 7300960 20764176
08:10:34 13236 8192000000 9757542304 10065428480 832667760 9.226 100 84 168 0 864111648 11352944 20090944
08:11:54 8454 8192000000 9784499632 10101694464 863003584 9.530 100 84 168 0 899370992 17331904 19035504
08:13:10 14539 8192000000 9840883024 10170347520 900301008 9.901 100 83 165 1 956575920 37705648 18569264
08:14:31 9582 8192000000 9904406624 10243866624 932375024 10.218 100 72 144 0 1016287344 68466352 15445968
08:15:45 3192 8192000000 9921387968 10271428608 961861376 10.507 100 79 157 0 1036626224 58607328 16157520
08:16:50 3345 8192000000 9977321840 10334830592 997788400 10.857 100 85 167 1 1088361824 73290800 17282624
08:17:55 1587 8192000000 10000226848 10368880640 1026172128 11.132 100 77 154 0 1117670480 75041712 16456640
08:18:59 1133 8192000000 10013903792 10385653760 1051328400 11.373 100 84 168 0 1134802288 66599792 16874096
08:20:01 2156 8192000000 10055761536 10434252800 1070471696 11.557 100 82 164 1 1172793424 86582688 15739040
08:21:05 7342 8192000000 10009625696 10414497792 1071596448 11.567 100 43 86 3 1133623424 53444160 8582816
08:22:14 4952 8192000000 10020263280 10427396096 1075673968 11.606 100 35 70 0 1129672688 47075680 6923040
08:23:23 5839 8192000000 10020147312 10418429952 1083074896 11.677 100 40 80 1 1129194592 37703376 8416320
08:24:30 32832 8192000000 10004374912 10396655616 1083161872 11.678 100 46 91 3 1101516576 8755808 9598896
08:26:05 7010 8192000000 10011474496 10418835456 1091106192 11.753 100 39 79 0 1116161312 15944960 9110160
08:27:13 5729 8192000000 10011397968 10410332160 1090998368 11.752 100 33 67 0 1129158224 31307168 6852688
08:28:22 5788 8192000000 10015877744 10404474880 1076768000 11.617 99 54 106 0 1122159280 34485776 10905504
08:29:32 107435 8192000000 10023880816 10445918208 1062384560 11.479 97 30 60 0 1123346368 54361120 6600688
08:32:24 7792 8192000000 10077913968 10478862336 1095271856 11.793 99 42 84 0 1166396432 62322304 8802272
08:33:34 9316 8192000000 10101874464 10501353472 1094460368 11.785 100 46 93 0 1212722592 108518496 9743728
08:34:46 12185 8192000000 10090253216 10491375616 1095030032 11.790 99 43 84 2 1191193216 86836176 9327008
08:36:03 14424 8192000000 10167131568 10565763072 1081511920 11.662 97 50 101 0 1244392608 151936896 10943792
08:37:21 16978 8192000000 10171656112 10573549568 1097256560 11.812 98 45 88 0 1255377632 148245680 9875392
08:38:40 21542 8192000000 10191777840 10604126208 1083988512 11.685 97 39 76 1 1267955392 175209008 8757872
08:40:05 11646 8192000000 10220945648 10632978432 1095127104 11.791 98 51 103 1 1327298192 220469200 11701888
08:41:27 6071 8192000000 10229779024 10627485696 1107301408 11.907 100 54 108 0 1332719376 212994960 12423008
08:42:41 1950 8192000000 10291742272 10685210624 1124015392 12.065 100 80 160 1 1393311872 251322880 17973600
08:43:48 2594 8192000000 10310394400 10722721792 1126768640 12.091 100 83 165 1 1415840176 270352560 18718976
08:44:54 2796 8192000000 10337349200 10728591360 1127428864 12.097 100 85 166 2 1431499328 286074160 17996304
08:46:00 12846 8192000000 10332097760 10765811712 1126388448 12.087 100 39 78 0 1437909120 301825840 9694832
08:47:18 6436 8192000000 10343452512 10750160896 1113149952 11.962 99 70 137 1 1431799200 303516736 15132512
08:48:29 10560 8192000000 10295340896 10707341312 1113884960 11.969 99 52 100 1 1395862240 270310672 11666608
08:49:42 4633 8192000000 10311849872 10768269312 1132438080 12.144 100 64 126 1 1408412176 260550960 15423136
08:50:48 16497 8192000000 10170279120 10600931328 1132424656 12.144 100 33 66 0 1278858160 138358560 8074944
08:52:52 70564 8192000000 10067881568 10549735424 1133544960 12.155 100 6 12 0 1203131712 68209552 1377200
08:55:05 6744 8192000000 10103599680 10521739264 1143817312 12.251 100 56 112 1 1196471120 40204496 12449312
08:56:15 69794 8192000000 10083015600 10572468224 1133248176 12.152 99 8 16 0 1190713280 55927888 1537216
08:58:31 109299 8192000000 10082248784 10528423936 1149440464 12.304 100 36 70 0 1191009728 33707648 7861616
09:01:23 29120 8192000000 10099173584 10543001600 1155133424 12.358 100 17 32 1 1198828736 40394592 3300720
09:02:57 40052 8192000000 10171823408 10611417088 1158908944 12.393 99 34 69 0 1253680992 87557264 7214784
09:04:40 62386 8192000000 10202951392 10673238016 1168245072 12.480 100 16 32 0 1308405232 135978256 4181904
09:06:46 32608 8192000000 10204120752 10644963328 1141658112 12.231 98 21 42 0 1281204928 135131424 4415392
09:08:24 26590 8192000000 10187822288 10629283840 1154441584 12.351 99 23 47 0 1274398752 114214752 5742416
09:09:52 44574 8192000000 10147088768 10595045376 1114261632 11.973 96 15 30 0 1198495120 81253856 2979632
09:11:37 50261 8192000000 10075212064 10517381120 1101038640 11.847 95 15 28 0 1137504048 33899296 2566112
09:13:28 31140 8192000000 10085535520 10533642240 1117523264 12.004 98 20 40 0 1152084144 30620064 3940816
09:15:04 47085 8192000000 10130433728 10649112576 1094150608 11.782 96 33 66 0 1230107056 128976656 6979792
09:17:04 66323 8192000000 10063590928 10512928768 1082546624 11.672 96 16 32 0 1127812464 42361904 2903936
09:19:12 43203 8192000000 10060113072 10508021760 1107996048 11.913 98 25 48 1 1164884688 51706736 5181904
09:20:56 72017 8192000000 10049030752 10563014656 1102019936 11.857 98 4 8 0 1141385616 38746800 618880
09:23:08 78394 8192000000 10065440832 10542952448 1069501488 11.547 96 34 69 2 1155940768 79045840 7393440
09:25:47 11868 8192000000 10081480848 10496917504 1094299264 11.784 99 68 137 1 1145034736 36658736 14076736
09:27:06 37178 8192000000 10026012096 10512142336 1096569200 11.805 99 4 8 0 1136542336 39349968 623168
09:28:44 53616 8192000000 10057034496 10497105920 1085460880 11.699 97 13 26 0 1133924336 45707088 2756368
09:31:36 85125 8192000000 10050748416 10546208768 1097372368 11.813 99 11 22 0 1172984512 73120992 2491152
09:34:03 62668 8192000000 10063752640 10518073344 1086230112 11.707 97 19 38 0 1127366304 37265872 3870320
09:36:09 30588 8192000000 10059034912 10485510144 1103442912 11.870 99 25 50 0 1128499344 20332304 4724128
09:37:42 27134 8192000000 10085960208 10521444352 1118303280 12.011 99 32 62 0 1160430944 36168736 5958928
09:39:12 61267 8192000000 10084292304 10533974016 1109070768 11.924 98 17 32 0 1167573552 55409040 3093744
09:41:24 17360 8192000000 10073527456 10495127552 1136545872 12.183 100 44 87 1 1170382704 25456128 8380704
09:42:43 48915 8192000000 10077299472 10535235584 1141330592 12.228 100 33 66 0 1226428848 78880064 6218192
09:44:32 93392 8192000000 10100008176 10587385856 1130213840 12.123 99 17 32 0 1203779504 69839664 3726000
09:47:17 124659 8192000000 10090004896 10590822400 1124960224 12.074 98 18 34 0 1178518000 50028720 3529056
09:50:22 64445 8192000000 10107728560 10578014208 1149814624 12.308 100 9 18 0 1214937520 63386272 1736624
09:53:42 45492 8192000000 10139056432 10612101120 1131386624 12.134 97 28 56 0 1239391024 101295776 6708624
09:55:49 47045 8192000000 10128093600 10579378176 1082175904 11.668 95 39 76 0 1203536352 112985408 8375040
09:57:36 68812 8192000000 10110212000 10558558208 1105665584 11.891 97 26 53 1 1197374096 86041936 5666576
09:59:46 64193 8192000000 10133183360 10605649920 1115850464 11.988 97 27 52 0 1207937632 86784128 5303040
10:01:50 46739 8192000000 10056648320 10523115520 1104060576 11.876 98 12 24 0 1160428544 53741216 2626752
10:03:40 146932 8192000000 10007545456 10436669440 1047433712 11.336 94 15 29 0 1065067904 14124080 3510112
10:07:07 41869 8192000000 10050797920 10508185600 1116713808 11.996 100 12 25 1 1160020400 40751408 2555184

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 23-02-2024 10:10:47 to 23-02-2024 10:11:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

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          175187
MON$OLDEST_ACTIVE               176211
MON$OLDEST_SNAPSHOT             176211
MON$NEXT_TRANSACTION            176211
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                       1927136
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             707
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 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 Fri Feb 23 10:11:05 2024 
 
Database header page information: 
    Flags            0 
    Generation        91963 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    175187 
    Oldest active        176211 
    Oldest snapshot        176211 
    Next transaction    176212 
    Sequence number        0 
    Next attachment ID    707 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.69, total records: 7699545 
    Average version length: 48.16, total versions: 39906, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88928 
    Data pages: 88928, average fill: 69% 
    Primary pages: 88927, secondary pages: 1, swept pages: 49551 
    Empty pages: 4, full pages: 56132 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 50 
    40 - 59% = 2336 
    60 - 79% = 86507 
    80 - 99% = 19 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23336, nodes: 7699545 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1658936, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 345 
        20 - 39% = 1971 
        40 - 59% = 4116 
        60 - 79% = 2684 
        80 - 99% = 14220 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13540, nodes: 7699545 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1482684, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1680 
        40 - 59% = 2012 
        60 - 79% = 1232 
        80 - 99% = 8616 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8349, nodes: 7699545 
    Average node length: 6.61, total dup: 5771858, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1475741, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 995 
        40 - 59% = 1404 
        60 - 79% = 1047 
        80 - 99% = 4782 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.95, total records: 2220159 
    Average version length: 58.86, total versions: 21774, 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: 28768 
    Data pages: 28768, average fill: 71% 
    Primary pages: 28766, secondary pages: 2, swept pages: 16077 
    Empty pages: 8, full pages: 13102 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 60 
    40 - 59% = 674 
    60 - 79% = 27980 
    80 - 99% = 30 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4576, nodes: 2220159 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 669123, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 964 
        40 - 59% = 857 
        60 - 79% = 820 
        80 - 99% = 1935 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2428, nodes: 2220642 
    Average node length: 4.97, total dup: 2219745, max dup: 18238 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254552, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 238 
        40 - 59% = 1398 
        60 - 79% = 551 
        80 - 99% = 238 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1792, nodes: 2220159 
    Average node length: 4.97, total dup: 2220109, max dup: 130368 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062320, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 8 
        40 - 59% = 645 
        60 - 79% = 45 
        80 - 99% = 1091 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4362, nodes: 2220159 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 669123, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 596 
        40 - 59% = 645 
        60 - 79% = 924 
        80 - 99% = 2085 
 
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.19, total records: 400 
    Average version length: 10.67, total versions: 86, max versions: 1 
    Average fragment length: 2.00, total fragments: 11, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 16, average fill: 33% 
    Primary pages: 7, secondary pages: 9, swept pages: 0 
    Empty pages: 7, full pages: 6 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 6 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 19.02, total records: 106093 
    Average version length: 68.29, total versions: 88155, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.63 
    Pointer pages: 7, data page slots: 3256 
    Data pages: 2064, average fill: 68% 
    Primary pages: 2063, secondary pages: 1, swept pages: 37 
    Empty pages: 180, full pages: 1173 
    Fill distribution: 
     0 - 19% = 246 
    20 - 39% = 149 
    40 - 59% = 224 
    60 - 79% = 423 
    80 - 99% = 1022 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1706254, depth: 3, leaf buckets: 395, nodes: 106093 
    Average node length: 13.16, total dup: 7113, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 77434, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 137 
        40 - 59% = 242 
        60 - 79% = 10 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 46, max versions: 1 
    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: 1 
    Data pages: 1, average fill: 37% 
    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 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.39, total records: 2115 
    Average version length: 43.58, total versions: 1973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.09 
    Pointer pages: 1, data page slots: 48 
    Data pages: 40, average fill: 56% 
    Primary pages: 39, secondary pages: 1, swept pages: 6 
    Empty pages: 9, full pages: 19 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90940, depth: 2, leaf buckets: 3, nodes: 2115 
    Average node length: 4.15, total dup: 2017, max dup: 213 
    Average key length: 2.49, compression ratio: 7.63 
    Average prefix length: 18.55, average data length: 0.45 
    Clustering factor: 1113, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        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.65, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 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: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.96, total records: 799001 
    Average version length: 37.93, total versions: 16019, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8616 
    Data pages: 8616, average fill: 63% 
    Primary pages: 8615, secondary pages: 1, swept pages: 4070 
    Empty pages: 29, full pages: 4272 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 82 
    40 - 59% = 1191 
    60 - 79% = 7270 
    80 - 99% = 26 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 883, nodes: 790037 
    Average node length: 4.88, total dup: 789988, max dup: 144341 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90770, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 151 
        40 - 59% = 512 
        60 - 79% = 127 
        80 - 99% = 91 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 932, nodes: 790037 
    Average node length: 5.89, total dup: 703097, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158654, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 48 
        40 - 59% = 502 
        60 - 79% = 105 
        80 - 99% = 276 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 956, nodes: 790037 
    Average node length: 5.89, total dup: 703097, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160521, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 91 
        40 - 59% = 492 
        60 - 79% = 104 
        80 - 99% = 268 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1136, nodes: 790037 
    Average node length: 5.97, total dup: 703097, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 153235, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 277 
        40 - 59% = 568 
        60 - 79% = 192 
        80 - 99% = 95 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5440 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 4.27, total fragments: 22, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 62% 
    Primary pages: 74, secondary pages: 13, swept pages: 62 
    Empty pages: 5, full pages: 61 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5440 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.38, average data length: 1.54 
    Clustering factor: 5150, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5440 
    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: 169, 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.05, total records: 80508 
    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: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 836 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 836 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34957, depth: 2, leaf buckets: 103, nodes: 80508 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2972, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 101 
 
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.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 143.52, total records: 172321 
    Average version length: 152.07, total versions: 9259, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.82 
    Pointer pages: 7, data page slots: 5888 
    Data pages: 4376, average fill: 82% 
    Primary pages: 4373, secondary pages: 3, swept pages: 92 
    Empty pages: 124, full pages: 4203 
    Fill distribution: 
     0 - 19% = 127 
    20 - 39% = 14 
    40 - 59% = 10 
    60 - 79% = 23 
    80 - 99% = 4202 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 146.35, total records: 150225 
    Average version length: 150.56, total versions: 4910, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 6, data page slots: 6776 
    Data pages: 3752, average fill: 83% 
    Primary pages: 3748, secondary pages: 4, swept pages: 43 
    Empty pages: 59, full pages: 3674 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 3677 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.56, total records: 166441 
    Average version length: 152.04, total versions: 7653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 7, data page slots: 5504 
    Data pages: 4208, average fill: 82% 
    Primary pages: 4205, secondary pages: 3, swept pages: 69 
    Empty pages: 106, full pages: 4068 
    Fill distribution: 
     0 - 19% = 108 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 18 
    80 - 99% = 4068 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 138.86, total records: 169148 
    Average version length: 153.32, total versions: 14568, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.21 
    Pointer pages: 7, data page slots: 5400 
    Data pages: 4248, average fill: 83% 
    Primary pages: 4246, secondary pages: 2, swept pages: 43 
    Empty pages: 74, full pages: 4144 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4146 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 134.79, total records: 164890 
    Average version length: 153.37, total versions: 18568, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.58 
    Pointer pages: 6, data page slots: 5640 
    Data pages: 4144, average fill: 83% 
    Primary pages: 4142, secondary pages: 2, swept pages: 44 
    Empty pages: 88, full pages: 4030 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 12 
    80 - 99% = 4031 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 143.13, total records: 166542 
    Average version length: 152.39, total versions: 9414, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 8, data page slots: 6464 
    Data pages: 4248, average fill: 81% 
    Primary pages: 4245, secondary pages: 3, swept pages: 133 
    Empty pages: 137, full pages: 4065 
    Fill distribution: 
     0 - 19% = 138 
    20 - 39% = 16 
    40 - 59% = 13 
    60 - 79% = 15 
    80 - 99% = 4066 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 147.32, total records: 157484 
    Average version length: 149.92, total versions: 3976, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 5, data page slots: 5288 
    Data pages: 4032, average fill: 81% 
    Primary pages: 4029, secondary pages: 3, swept pages: 88 
    Empty pages: 145, full pages: 3844 
    Fill distribution: 
     0 - 19% = 154 
    20 - 39% = 11 
    40 - 59% = 10 
    60 - 79% = 12 
    80 - 99% = 3845 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 139.24, total records: 164026 
    Average version length: 153.35, total versions: 13483, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.18 
    Pointer pages: 6, data page slots: 5936 
    Data pages: 4128, average fill: 83% 
    Primary pages: 4125, secondary pages: 3, swept pages: 54 
    Empty pages: 85, full pages: 4013 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 8 
    80 - 99% = 4015 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.66, total records: 164881 
    Average version length: 150.05, total versions: 4037, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 5704 
    Data pages: 4152, average fill: 82% 
    Primary pages: 4150, secondary pages: 2, swept pages: 64 
    Empty pages: 91, full pages: 4040 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4040 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 146.04, total records: 158199 
    Average version length: 150.89, total versions: 5576, 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: 5920 
    Data pages: 4064, average fill: 81% 
    Primary pages: 4061, secondary pages: 3, swept pages: 128 
    Empty pages: 163, full pages: 3866 
    Fill distribution: 
     0 - 19% = 166 
    20 - 39% = 16 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 3868 
 
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.50, total records: 2074299 
    Average version length: 52.88, total versions: 12039, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25808 
    Data pages: 25792, average fill: 69% 
    Primary pages: 25778, secondary pages: 14, swept pages: 13642 
    Empty pages: 177, full pages: 20329 
    Fill distribution: 
     0 - 19% = 386 
    20 - 39% = 361 
    40 - 59% = 1219 
    60 - 79% = 23746 
    80 - 99% = 80 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2582, nodes: 2074299 
    Average node length: 5.44, total dup: 1934835, max dup: 1391 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180177, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 312 
        40 - 59% = 1713 
        60 - 79% = 268 
        80 - 99% = 285 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2074299 
    Average node length: 5.70, total dup: 1860990, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371269, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2461 
        60 - 79% = 271 
        80 - 99% = 18 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2102, nodes: 2074299 
    Average node length: 4.96, total dup: 2074199, max dup: 27412 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 178252, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 212 
        40 - 59% = 1073 
        60 - 79% = 384 
        80 - 99% = 432 
 
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: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 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: 48.36, total records: 129457 
    Average version length: 69.17, total versions: 44872, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.61 
    Pointer pages: 3, data page slots: 4368 
    Data pages: 2976, average fill: 52% 
    Primary pages: 2976, secondary pages: 0, swept pages: 446 
    Empty pages: 277, full pages: 752 
    Fill distribution: 
     0 - 19% = 421 
    20 - 39% = 388 
    40 - 59% = 820 
    60 - 79% = 1035 
    80 - 99% = 312 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555918, depth: 3, leaf buckets: 241, nodes: 129457 
    Average node length: 6.56, total dup: 112585, max dup: 14 
    Average key length: 4.00, compression ratio: 10.51 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 22233, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 88 
        40 - 59% = 127 
        60 - 79% = 24 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.23, total records: 6985938 
    Average version length: 68.71, total versions: 200841, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 66, data page slots: 107304 
    Data pages: 107304, average fill: 70% 
    Primary pages: 107303, secondary pages: 1, swept pages: 56015 
    Empty pages: 9, full pages: 43070 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 597 
    40 - 59% = 8525 
    60 - 79% = 97794 
    80 - 99% = 338 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10691, nodes: 6985938 
    Average node length: 6.52, total dup: 6038417, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1653960, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1682 
        40 - 59% = 6060 
        60 - 79% = 2450 
        80 - 99% = 496 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8514, nodes: 6985938 
    Average node length: 5.40, total dup: 6703782, max dup: 126 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1457954, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1239 
        40 - 59% = 4662 
        60 - 79% = 1684 
        80 - 99% = 915 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8535, nodes: 6985938 
    Average node length: 5.40, total dup: 6703782, max dup: 126 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1460238, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1313 
        40 - 59% = 4571 
        60 - 79% = 1701 
        80 - 99% = 943 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.20, total records: 11900110 
    Average version length: 68.73, total versions: 147204, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 108, data page slots: 175232 
    Data pages: 175232, average fill: 72% 
    Primary pages: 175231, secondary pages: 1, swept pages: 103685 
    Empty pages: 8, full pages: 121364 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 513 
    40 - 59% = 7035 
    60 - 79% = 167137 
    80 - 99% = 505 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18401, nodes: 11899367 
    Average node length: 6.62, total dup: 10370165, max dup: 62 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2449125, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 2461 
        40 - 59% = 10999 
        60 - 79% = 4127 
        80 - 99% = 792 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 60.57, total records: 1252698 
    Average version length: 69.09, total versions: 143284, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.08 
    Pointer pages: 27, data page slots: 42792 
    Data pages: 28904, average fill: 47% 
    Primary pages: 28837, secondary pages: 67, swept pages: 15191 
    Empty pages: 4686, full pages: 11663 
    Fill distribution: 
     0 - 19% = 7399 
    20 - 39% = 3768 
    40 - 59% = 3756 
    60 - 79% = 12570 
    80 - 99% = 1411 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1851, nodes: 1216983 
    Average node length: 5.53, total dup: 1167697, max dup: 49 
    Average key length: 2.58, compression ratio: 16.30 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 87085, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 691 
        40 - 59% = 868 
        60 - 79% = 266 
        80 - 99% = 20 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 50.54, total records: 931776 
    Average version length: 69.04, total versions: 119673, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.49 
    Pointer pages: 21, data page slots: 34080 
    Data pages: 28336, average fill: 34% 
    Primary pages: 28335, secondary pages: 1, swept pages: 10995 
    Empty pages: 4234, full pages: 2558 
    Fill distribution: 
     0 - 19% = 8171 
    20 - 39% = 8007 
    40 - 59% = 8564 
    60 - 79% = 3552 
    80 - 99% = 42 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1238, nodes: 764581 
    Average node length: 5.95, total dup: 704015, max dup: 53 
    Average key length: 3.01, compression ratio: 13.93 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 113726, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 440 
        40 - 59% = 617 
        60 - 79% = 174 
        80 - 99% = 6 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 8834195 
    Average version length: 69.01, total versions: 152183, 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: 89, data page slots: 143760 
    Data pages: 143728, average fill: 66% 
    Primary pages: 143711, secondary pages: 17, swept pages: 88897 
    Empty pages: 351, full pages: 51351 
    Fill distribution: 
     0 - 19% = 1186 
    20 - 39% = 5623 
    40 - 59% = 26313 
    60 - 79% = 110062 
    80 - 99% = 544 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13419, nodes: 8831655 
    Average node length: 6.68, total dup: 7322299, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1976211, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1651 
        40 - 59% = 7171 
        60 - 79% = 4136 
        80 - 99% = 459 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21144773 
    Average version length: 82.71, total versions: 1391, 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: 319856 
    Data pages: 319856, average fill: 81% 
    Primary pages: 319851, secondary pages: 5, swept pages: 13575 
    Empty pages: 47, full pages: 318605 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 74 
    40 - 59% = 185 
    60 - 79% = 49143 
    80 - 99% = 270374 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19419, nodes: 21144773 
    Average node length: 5.72, total dup: 20663788, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283877, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 0 
        40 - 59% = 8203 
        60 - 79% = 541 
        80 - 99% = 10663 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17190, nodes: 21144773 
    Average node length: 6.31, total dup: 18581255, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917572, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 7 
        40 - 59% = 809 
        60 - 79% = 269 
        80 - 99% = 16102 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21173, nodes: 21144773 
    Average node length: 6.35, total dup: 18500514, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577799, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 8419 
        60 - 79% = 624 
        80 - 99% = 12125 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16103, nodes: 21144773 
    Average node length: 5.56, total dup: 21144673, max dup: 227668 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946480, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 19 
        40 - 59% = 2901 
        60 - 79% = 353 
        80 - 99% = 12828 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.41, total records: 9262410 
    Average version length: 82.62, total versions: 126421, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 105, data page slots: 170832 
    Data pages: 170808, average fill: 67% 
    Primary pages: 170769, secondary pages: 39, swept pages: 114746 
    Empty pages: 720, full pages: 76405 
    Fill distribution: 
     0 - 19% = 2200 
    20 - 39% = 8528 
    40 - 59% = 30361 
    60 - 79% = 116155 
    80 - 99% = 13564 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11323, nodes: 9262410 
    Average node length: 5.37, total dup: 8955719, max dup: 165 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2080842, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 143 
        40 - 59% = 9116 
        60 - 79% = 2025 
        80 - 99% = 38 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13292, nodes: 9262410 
    Average node length: 6.23, total dup: 7674923, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1445229, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 4054 
        40 - 59% = 4445 
        60 - 79% = 2640 
        80 - 99% = 2034 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12646, nodes: 9262410 
    Average node length: 5.99, total dup: 8023808, max dup: 44 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2257332, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 185 
        40 - 59% = 10090 
        60 - 79% = 2316 
        80 - 99% = 53 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9882, nodes: 9262410 
    Average node length: 5.13, total dup: 9262310, max dup: 138127 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1475722, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1403 
        40 - 59% = 4836 
        60 - 79% = 1719 
        80 - 99% = 1876 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.67, total records: 11061616 
    Average version length: 82.43, total versions: 95310, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 119, data page slots: 194200 
    Data pages: 192568, average fill: 70% 
    Primary pages: 192439, secondary pages: 129, swept pages: 83640 
    Empty pages: 2922, full pages: 136469 
    Fill distribution: 
     0 - 19% = 5293 
    20 - 39% = 8791 
    40 - 59% = 21319 
    60 - 79% = 102906 
    80 - 99% = 54259 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13127, nodes: 11061616 
    Average node length: 5.31, total dup: 10951928, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2325552, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 235 
        40 - 59% = 9500 
        60 - 79% = 3309 
        80 - 99% = 83 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10429, nodes: 11061616 
    Average node length: 5.51, total dup: 10577843, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 720830, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 937 
        40 - 59% = 2663 
        60 - 79% = 1884 
        80 - 99% = 4770 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15011, nodes: 11061616 
    Average node length: 6.04, total dup: 9643674, max dup: 73 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2341825, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 303 
        40 - 59% = 10995 
        60 - 79% = 3593 
        80 - 99% = 116 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10772, nodes: 11061616 
    Average node length: 5.23, total dup: 11061516, max dup: 184992 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 710306, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 961 
        40 - 59% = 4836 
        60 - 79% = 1562 
        80 - 99% = 3301 
 
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: 81.81, total records: 9366379 
    Average version length: 82.94, total versions: 118680, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 108, data page slots: 174808 
    Data pages: 174744, average fill: 66% 
    Primary pages: 174709, secondary pages: 35, swept pages: 122620 
    Empty pages: 788, full pages: 75776 
    Fill distribution: 
     0 - 19% = 2555 
    20 - 39% = 10336 
    40 - 59% = 31500 
    60 - 79% = 117302 
    80 - 99% = 13051 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11554, nodes: 9366379 
    Average node length: 5.17, total dup: 9337944, max dup: 1549 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1867814, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1727 
        40 - 59% = 7586 
        60 - 79% = 1707 
        80 - 99% = 504 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13415, nodes: 9366379 
    Average node length: 6.25, total dup: 7761248, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1412366, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 180 
        20 - 39% = 4070 
        40 - 59% = 4372 
        60 - 79% = 2624 
        80 - 99% = 2169 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12200, nodes: 9366379 
    Average node length: 5.43, total dup: 8940314, max dup: 95 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1997524, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1747 
        40 - 59% = 8354 
        60 - 79% = 1561 
        80 - 99% = 506 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9989, nodes: 9366379 
    Average node length: 5.14, total dup: 9366279, max dup: 139433 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1491297, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1439 
        40 - 59% = 4868 
        60 - 79% = 1695 
        80 - 99% = 1944 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.98, total records: 570077 
    Average version length: 68.80, total versions: 1850, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8072 
    Data pages: 8072, average fill: 74% 
    Primary pages: 8072, secondary pages: 0, swept pages: 4612 
    Empty pages: 7, full pages: 6312 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 9 
    40 - 59% = 206 
    60 - 79% = 7836 
    80 - 99% = 12 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45909, depth: 3, leaf buckets: 740, nodes: 570077 
    Average node length: 5.95, total dup: 485180, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100305, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 548 
        60 - 79% = 74 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 40403, depth: 3, leaf buckets: 757, nodes: 570077 
    Average node length: 6.15, total dup: 467478, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 100347, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 548 
        60 - 79% = 80 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 570077 
    Average node length: 4.86, total dup: 569977, max dup: 9712 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89293, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 48 
        40 - 59% = 307 
        60 - 79% = 77 
        80 - 99% = 128 
 
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 Fri Feb 23 10:11:28 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7699545 39906 1 0.0000 0.0000
DOC_LIST 2220159 21774 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 86 1 0.0000 0.0000
INVNT_TURNOVER_LOG 106093 88155 1 0.0000 0.0000
MONEY_SALDO 49 46 1 0.0000 0.0000
MONEY_TURNOVER_LOG 2115 1973 1 0.0000 0.0000
PDISTR 799001 16019 2 0.0000 0.0000
PERF_SPLIT_0 172321 9259 1 0.0000 0.0000
PERF_SPLIT_1 150225 4910 1 0.0000 0.0000
PERF_SPLIT_2 166441 7653 1 0.0000 0.0000
PERF_SPLIT_3 169148 14568 1 0.0000 0.0000
PERF_SPLIT_4 164890 18568 1 0.0000 0.0000
PERF_SPLIT_5 166542 9414 1 0.0000 0.0000
PERF_SPLIT_6 157484 3976 1 0.0000 0.0000
PERF_SPLIT_7 164026 13483 1 0.0000 0.0000
PERF_SPLIT_8 164881 4037 1 0.0000 0.0000
PERF_SPLIT_9 158199 5576 1 0.0000 0.0000
PSTORNED 2074299 12039 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 129457 44872 1 0.0000 0.0000
XQD_1000_3300 6985938 200841 1 0.0000 0.0000
XQD_1200_2000 11900110 147204 1 0.0000 0.0000
XQD_2000_3300 1252698 143284 1 0.0000 0.0000
XQD_2100_3300 931776 119673 1 0.0000 0.0000
XQD_3300_3400 8834195 152183 1 0.0000 0.0000
XQS_1000_1200 21144773 1391 1 0.0000 0.0000
XQS_1000_3300 9262410 126421 1 0.0000 0.0000
XQS_1200_2000 11061616 95310 1 0.0000 0.0000
XQS_2100_3300 9366379 118680 1 0.0000 0.0000
XQS_3300_3400 570077 1850 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 ---
:191: 
:192: mscs-test-161.budzdorov.ru    Fri Feb 23 10:08:31 2024
:193:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:194: 
--- end of diff output ---

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

23.02.24 10:11:40. 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-02-23 10:11:42 No severe PSQL-related problems occured
23.02.24 10:11:43. End of report.