Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.04.2024 01: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 15827316 kB
MemAvailable 30188616 kB
Buffers 0 kB
Cached 15904888 kB
SwapCached 2484 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-02 01:09:46
DTS_END                         2024-04-02 01:09:46.1720
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58780
TRN_ID                          180144
ATT_ID                          577
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: 9232.46 18987 923246
customer order: creation 186.39 340 18639
customer order: refuse 15.42 401 1542
order to supplier: creation 48.49 1282 4849
order to supplier: removal 3.48 90411 348
invoice (draft): creation 49.48 3118 4948
invoice (draft): removal 47.61 797 4761
invoice accept: apply 44.71 21353 4471
invoice accept: cancel 42.51 837 4251
customer reserve: creation 4273.32 206 427332
customer reserve: removal 4214.72 58 421472
realization accept: apply 90.68 176 9068
realization accept: cancel 75.90 111 7590
payment from customer: creation 64.18 114 6418
payment from customer: removal 5.94 79 594
payment to supplier: creation 52.93 130 5293
payment to supplier: removal 3.85 76 385
service: total inventory turnovers 4.86 1093 486
service: total monetary turnovers 6.98 25 698
service: aggregate perf. data 0.98 13878 98
service: refresh index statistics 0.03 245248 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-04-2024 01:10:54 to 02-04-2024 01:10:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1667
TEST_TIME 2 2507
TEST_TIME 3 4097
TEST_TIME 4 4802
TEST_TIME 5 5215
TEST_TIME 6 5534
TEST_TIME 7 5551
TEST_TIME 8 6425
TEST_TIME 9 6585
TEST_TIME 10 6650
TEST_TIME 11 6867
TEST_TIME 12 6864
TEST_TIME 13 6576
TEST_TIME 14 6305
TEST_TIME 15 6229
TEST_TIME 16 6186
TEST_TIME 17 6475
TEST_TIME 18 6530
TEST_TIME 19 6712
TEST_TIME 20 6665
TEST_TIME 21 6768
TEST_TIME 22 7322
TEST_TIME 23 7293
TEST_TIME 24 7567
TEST_TIME 25 7634
TEST_TIME 26 7558
TEST_TIME 27 7783
TEST_TIME 28 7871
TEST_TIME 29 8169
TEST_TIME 30 8212
TEST_TIME 31 8256
TEST_TIME 32 8530
TEST_TIME 33 8911
TEST_TIME 34 8899
TEST_TIME 35 8828
TEST_TIME 36 8635
TEST_TIME 37 8715
TEST_TIME 38 8728
TEST_TIME 39 8702
TEST_TIME 40 8732
TEST_TIME 41 8681
TEST_TIME 42 8728
TEST_TIME 43 8663
TEST_TIME 44 8641
TEST_TIME 45 8622
TEST_TIME 46 8597
TEST_TIME 47 8733
TEST_TIME 48 8745
TEST_TIME 49 8872
TEST_TIME 50 8814
TEST_TIME 51 8799
TEST_TIME 52 8884
TEST_TIME 53 8997
TEST_TIME 54 8938
TEST_TIME 55 9045
TEST_TIME 56 9005
TEST_TIME 57 9189
TEST_TIME 58 9151
TEST_TIME 59 9111
TEST_TIME 60 9182
TEST_TIME 61 9209
TEST_TIME 62 9245
TEST_TIME 63 9162
TEST_TIME 64 9142
TEST_TIME 65 9104
TEST_TIME 66 9125
TEST_TIME 67 9138
TEST_TIME 68 9083
TEST_TIME 69 9033
TEST_TIME 70 8951
TEST_TIME 71 8915
TEST_TIME 72 9058
TEST_TIME 73 9071
TEST_TIME 74 9084
TEST_TIME 75 9116
TEST_TIME 76 9128
TEST_TIME 77 9091
TEST_TIME 78 9181
TEST_TIME 79 9170
TEST_TIME 80 9269
TEST_TIME 81 9265
TEST_TIME 82 9288
TEST_TIME 83 9278
TEST_TIME 84 9308
TEST_TIME 85 9314
TEST_TIME 86 9360
TEST_TIME 87 9276
TEST_TIME 88 9270
TEST_TIME 89 9219
TEST_TIME 90 9197
TEST_TIME 91 9234
TEST_TIME 92 9156
TEST_TIME 93 9216
TEST_TIME 94 9167
TEST_TIME 95 9146
TEST_TIME 96 9168
TEST_TIME 97 9222
TEST_TIME 98 9203
TEST_TIME 99 9216
TEST_TIME 100 9238

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-04-2024 01:10:57 to 02-04-2024 01:11:01.

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 1312758 1312758 0 0.00 0 34969 7 0 0
doc_list_biud 1312758 1312758 0 0.00 0 29970 24 0 0
sp_add_invoice_to_stock 4623 4471 152 3.28 20 183889 21353 0 152
sp_cancel_adding_invoice 4251 4251 0 0.00 4 43095 837 0 0
sp_cancel_client_order 1542 1542 0 0.00 4 19843 401 0 0
sp_cancel_customer_reserve 421472 421472 0 0.00 0 29976 59 0 0
sp_cancel_pay_from_customer 594 594 0 0.00 2 4003 79 0 0
sp_cancel_pay_to_supplier 385 385 0 0.00 3 2167 76 0 0
sp_cancel_supplier_invoice 4770 4761 9 0.18 1 24236 797 0 9
sp_cancel_supplier_order 348 348 0 0.00 11 772274 90412 0 0
sp_cancel_write_off 7590 7590 0 0.00 1 8856 111 0 0
sp_client_order 18639 18639 0 0.00 3 15887 341 0 0
sp_customer_reserve 427332 427332 0 0.00 0 95641 207 0 0
sp_fill_shopping_cart 28435 28435 0 0.00 1 12766 33 0 0
sp_fill_shopping_cart_clo_res 427320 427320 0 0.00 0 36717 15 0 0
sp_get_clo_for_invoice 4458 4458 0 0.00 0 35662 343 0 0
sp_kill_cost_storno 12820 12820 0 0.00 0 6027 53 0 0
sp_kill_qstorno_ret_qs2qd 855643 855643 0 0.00 0 29964 32 0 0
sp_kill_qty_storno 453487 453487 0 0.00 0 29970 70 0 0
sp_lock_selected_doc 18580 18580 0 0.00 0 6256 3 0 0
sp_make_cost_storno 25234 25234 0 0.00 0 34959 53 0 0
sp_multiply_rows_for_pdistr 25234 25234 0 0.00 0 7752 27 0 0
sp_multiply_rows_for_qdistr 18639 18639 0 0.00 0 12797 150 0 0
sp_pay_from_customer 6418 6418 0 0.00 4 14587 115 0 0
sp_pay_to_supplier 5293 5293 0 0.00 4 34992 131 0 0
sp_payment_common 11711 11711 0 0.00 2 10115 25 0 0
sp_qd_handle_on_cancel_clo 1542 1542 0 0.00 0 19833 381 0 0
sp_qd_handle_on_invoice_upd_sts 8706 8706 0 0.00 0 25814 327 0 0
sp_qd_handle_on_reserve_upd_sts 9068 9068 0 0.00 0 21177 67 0 0
sp_reserve_write_off 9068 9068 0 0.00 6 21222 176 0 0
sp_supplier_invoice 4948 4948 0 0.00 6 73475 3118 0 0
sp_supplier_order 4849 4849 0 0.00 5 70765 1282 0 0
srv_aggregate_perf_data 98 98 0 0.00 1850 159558 13878 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 3859 109135 37360 0 0
srv_find_qd_qs_mism 876782 876782 0 0.00 0 23755 7 0 0
srv_make_invnt_saldo 486 486 0 0.00 43 34080 1093 0 0
srv_make_money_saldo 698 698 0 0.00 0 1764 25 0 0
srv_recalc_idx_stat 3 3 0 0.00 172925 341473 245248 0 0
t$perf-abend:sp_add_invoice_to_stock 152 152 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4471 4471 0 0.00 0 13099 171 0 0
t$perf-norm:sp_cancel_adding_invoice 359 359 0 0.00 0 4616 101 0 0
t$perf-norm:sp_cancel_client_order 1542 1542 0 0.00 0 4210 23 0 0
t$perf-norm:sp_cancel_customer_reserve 581 581 0 0.00 0 1394 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 594 594 0 0.00 0 581 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 385 385 0 0.00 0 3771 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 344 344 0 0.00 0 5634 34 0 0
t$perf-norm:sp_cancel_supplier_order 348 348 0 0.00 0 15859 1506 0 0
t$perf-norm:sp_cancel_write_off 904 904 0 0.00 0 5175 16 0 0
t$perf-norm:sp_client_order 18639 18639 0 0.00 0 8004 18 0 0
t$perf-norm:sp_customer_reserve 865 865 0 0.00 0 1684 8 0 0
t$perf-norm:sp_pay_from_customer 6418 6418 0 0.00 0 16816 10 0 0
t$perf-norm:sp_pay_to_supplier 5293 5293 0 0.00 0 3416 9 0 0
t$perf-norm:sp_reserve_write_off 9068 9068 0 0.00 0 3879 9 0 0
t$perf-norm:sp_supplier_invoice 4948 4948 0 0.00 0 4188 17 0 0
t$perf-norm:sp_supplier_order 4849 4849 0 0.00 0 12160 21 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 706 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 8 1 0 0
t$perf-norm:srv_make_invnt_saldo 486 486 0 0.00 0 3446 41 0 0
t$perf-norm:srv_make_money_saldo 698 698 0 0.00 0 1472 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 9214 8910 304 3.29 0 5301 20 0 304
v_all_customers 34010 34010 0 0.00 0 18 0 0 0
v_all_suppliers 27782 27782 0 0.00 0 22 1 0 0
v_all_wares 37278 37278 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 718 718 0 0.00 0 2142 12 0 0
v_cancel_client_order 3084 3084 0 0.00 0 3146 5 0 0
v_cancel_customer_prepayment 1188 1188 0 0.00 0 2699 6 0 0
v_cancel_customer_reserve 1162 1162 0 0.00 0 2358 5 0 0
v_cancel_payment_to_supplier 770 770 0 0.00 0 2125 8 0 0
v_cancel_supplier_invoice 706 688 18 2.54 0 6818 21 0 18
v_cancel_supplier_order 696 696 0 0.00 0 587 3 0 0
v_cancel_write_off 1808 1808 0 0.00 0 3741 16 0 0
v_max_id_clo_ord 4849 4849 0 0.00 0 1035 1 0 0
v_max_id_clo_res 865 865 0 0.00 0 3250 13 0 0
v_max_id_ord_sup 4947 4947 0 0.00 0 5830 5 0 0
v_max_non_paid_invoice 1198 1198 0 0.00 0 1497 6 0 0
v_max_non_paid_realizn 3306 3306 0 0.00 0 4228 6 0 0
v_min_id_clo_ord 4849 4849 0 0.00 0 4747 6 0 0
v_min_id_clo_res 865 865 0 0.00 0 6361 9 0 0
v_min_id_ord_sup 4947 4947 0 0.00 0 3951 6 0 0
v_min_non_paid_invoice 5293 5293 0 0.00 0 4698 17 0 0
v_min_non_paid_realizn 6418 6418 0 0.00 0 6948 19 0 0
v_our_firm 9492 9492 0 0.00 0 20 1 0 0
v_reserve_write_off 18136 18136 0 0.00 0 5718 7 0 0
x_lock_depdocs_on_canc_invoice 8668 8668 0 0.00 0 31176 149 0 0
x_lock_depdocs_on_canc_sup_ord 348 348 0 0.00 0 3639 329 0 0
x_make_qstorno_1000_1200 4849 4849 0 0.00 1 65929 1206 0 0
x_make_qstorno_1200_2000 4948 4948 0 0.00 3 73431 2992 0 0
x_make_qstorno_2100_3300 427332 427332 0 0.00 0 95635 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-04-2024 01:11:02 to 02-04-2024 01:11:06.

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
23:09:50 2 8192000000 8799151968 8810627072 5546144 0.067 2 1 2 0 5645776 56848 42784
23:10:51 23160 8192000000 9883103056 10191515648 965958144 10.547 100 90 180 0 994898752 5334432 23606176
23:12:18 23894 8192000000 9932580544 10252652544 1014061184 11.015 100 92 182 1 1045437936 8061968 23314784
23:13:45 15821 8192000000 9970468208 10300182528 1056005920 11.418 100 92 183 0 1088574608 9554480 23014208
23:15:06 11385 8192000000 10021132896 10367516672 1105954800 11.894 100 80 159 0 1135531840 10689392 18887648
23:16:25 6692 8192000000 10072736096 10431950848 1164802272 12.448 100 80 160 0 1196433648 12360080 19271296
23:17:34 4266 8192000000 10109836336 10479226880 1198876064 12.766 100 69 138 0 1226372784 12359616 15137104
23:18:41 3589 8192000000 10147232016 10521362432 1239105136 13.138 100 79 156 0 1269873936 12797088 17971712
23:19:46 2786 8192000000 10182746096 10564063232 1271372336 13.434 100 81 161 0 1301428192 11670704 18385152
23:20:51 1225 8192000000 10199553328 10586140672 1291496720 13.618 100 74 146 1 1319289712 12210352 15582640
23:21:55 5452 8192000000 10209323584 10603663360 1303785280 13.730 100 49 98 0 1325483536 10986064 10712192
23:23:02 5196 8192000000 10207479856 10613907456 1316739696 13.847 100 46 91 0 1335110176 8390912 9979568
23:24:10 11317 8192000000 10216794304 10626002944 1322131376 13.896 100 43 85 0 1338447728 6254016 10062336
23:25:22 17160 8192000000 10214040096 10636722176 1325981952 13.931 100 29 58 0 1338286240 4768096 7536192
23:26:44 5509 8192000000 10233972592 10651705344 1338442752 14.043 100 31 62 0 1352796944 7786624 6567568
23:27:52 10415 8192000000 10230653840 10652639232 1340537216 14.062 100 22 44 0 1351234656 5820448 4876992
23:29:03 106246 8192000000 10243280512 10658287616 1304273776 13.734 97 31 62 2 1317569136 5920000 7375360
23:32:00 6299 8192000000 10251079712 10658865152 1339292528 14.051 99 51 98 2 1361892544 11072160 11527856
23:33:11 13821 8192000000 10254143328 10670280704 1349060016 14.139 100 44 88 0 1370578160 11583376 9934768
23:34:43 16566 8192000000 10227536176 10637250560 1257390768 13.306 93 39 78 0 1276010016 9419440 9199808
23:36:08 8521 8192000000 10244296528 10650693632 1325351664 13.925 99 55 108 2 1349943296 11891616 12700016
23:37:22 4762 8192000000 10241194352 10647453696 1322244816 13.897 99 50 100 1 1345764864 11746496 11773552
23:38:32 13302 8192000000 10221666864 10624253952 1288903360 13.594 97 43 86 0 1309665728 10548448 10213920
23:39:52 11802 8192000000 10228057712 10636484608 1316345152 13.844 100 46 92 2 1338156320 10838032 10973136
23:41:11 11215 8192000000 10239053680 10644848640 1328362032 13.952 100 49 98 1 1352082368 12499136 11221200
23:43:11 60532 8192000000 10255011440 10667335680 1328065328 13.950 98 45 88 2 1351214112 12800688 10348096
23:45:28 19626 8192000000 10277619008 10685968384 1355504576 14.197 99 46 90 1 1383150448 16552704 11093168
23:46:54 4394 8192000000 10250628896 10654466048 1335363248 14.016 100 56 109 1 1365256624 16510336 13383040
23:48:05 3858 8192000000 10289304880 10690818048 1357652032 14.216 100 68 136 0 1394651856 20302880 16696944
23:49:16 14699 8192000000 10294186352 10706374656 1369241168 14.320 100 50 100 1 1402801024 21189984 12369872
23:50:37 7023 8192000000 10313881920 10718552064 1365099024 14.283 100 82 164 1 1419517312 34185728 20232560
23:51:48 22835 8192000000 10295221328 10723651584 1381871552 14.433 100 44 88 1 1412822512 19613680 11337280
23:53:13 8964 8192000000 10286977744 10719514624 1375526000 14.377 100 28 53 1 1403191728 21115760 6549968
23:54:27 10583 8192000000 10308285168 10733494272 1385642128 14.467 100 37 74 0 1416386864 21897328 8847408
23:55:43 14031 8192000000 10316022576 10742267904 1388935056 14.496 100 40 80 3 1422923232 24025408 9962768
23:57:03 21906 8192000000 10310373360 10746712064 1385240016 14.463 100 24 46 0 1415900864 24542368 6118480
23:58:30 28553 8192000000 10314229584 10751811584 1395906096 14.559 100 15 31 0 1420436704 20526240 4004368
00:00:02 7686 8192000000 10345876752 10767597568 1406103776 14.649 100 72 136 2 1447856880 24662816 17090288
00:01:15 28138 8192000000 10304681792 10747494400 1378188896 14.400 99 14 26 0 1406819856 24991600 3639360
00:02:56 6734 8192000000 10314551120 10748248064 1397961808 14.577 100 55 111 0 1418814240 7660368 13192064
00:04:06 30937 8192000000 10325446160 10756784128 1403700224 14.628 100 64 127 1 1428026752 9847904 14478624
00:05:38 51354 8192000000 10323433296 10758373376 1403433792 14.626 100 48 93 2 1426758288 12758480 10566016
00:07:33 72574 8192000000 10308218256 10746179584 1390185376 14.508 99 22 44 1 1401724160 7515376 4023408
00:09:54 9877 8192000000 10330640640 10760548352 1394141072 14.543 99 54 108 0 1417021872 10669440 12211360
00:11:06 14473 8192000000 10331915744 10779291648 1418337760 14.758 100 33 66 0 1441134400 15478160 7318480
00:12:32 31106 8192000000 10304760464 10750799872 1373250496 14.356 97 32 64 0 1399426464 19010096 7165872
00:14:04 64991 8192000000 10288174032 10747670528 1362318256 14.258 97 14 29 1 1385755504 19823856 3613392
00:16:11 10221 8192000000 10316118704 10765926400 1400742544 14.602 100 46 92 4 1428087728 15913120 11432064
00:17:23 40354 8192000000 10276109024 10728644608 1359247776 14.231 98 18 36 1 1373215744 9903456 4064512
00:19:04 47902 8192000000 10264526544 10708856832 1325489792 13.926 97 15 32 0 1338495168 9368640 3636736
00:20:58 56556 8192000000 10242210848 10684227584 1287723568 13.583 95 36 70 1 1311274592 15769056 7781968
00:22:56 36889 8192000000 10251107008 10681647104 1284893360 13.558 95 21 40 0 1299165808 9923376 4349072
00:24:34 43593 8192000000 10273192672 10714804224 1357541312 14.215 100 31 62 0 1375317216 10563440 7212464
00:26:20 74434 8192000000 10235792256 10675253248 1252248752 13.259 92 10 20 0 1265395552 10833104 2313696
00:28:35 13363 8192000000 10270690416 10704560128 1354033040 14.184 100 40 78 0 1372003824 8952192 9018592
00:29:52 34504 8192000000 10260405312 10710233088 1339623936 14.054 99 17 34 1 1359728352 16142480 3961936
00:31:32 103082 8192000000 10238260304 10672979968 1292384096 13.626 96 23 46 0 1313454336 16499984 4570256
00:34:18 36201 8192000000 10248909808 10692358144 1343768704 14.091 100 21 42 0 1361984096 13601824 4613568
00:35:57 33827 8192000000 10247100512 10700537856 1339687072 14.055 99 29 58 0 1360917184 14341328 6888784
00:37:34 39121 8192000000 10261467024 10707042304 1352645680 14.171 99 22 44 0 1369862672 12094752 5122240
00:39:32 99337 8192000000 10284393568 10739675136 1374216992 14.365 99 22 44 1 1393786992 14092816 5477184
00:43:01 42452 8192000000 10307086016 10754834432 1395015056 14.551 100 15 30 1 1406030528 8364880 2650592
00:44:46 80933 8192000000 10303058608 10754576384 1377975520 14.398 99 9 18 0 1388062352 8216864 1869968
00:47:08 38413 8192000000 10318653888 10770620416 1405003904 14.640 100 24 48 0 1425355024 15081408 5269712
00:48:51 109133 8192000000 10333698912 10783092736 1408832112 14.674 100 25 50 0 1433644752 19267360 5545280
00:51:41 57736 8192000000 10332768416 10784686080 1389949424 14.505 98 11 22 0 1407304928 15085744 2269760
00:53:49 38320 8192000000 10345560384 10793279488 1417572624 14.751 100 47 92 0 1440828496 13264528 9991344
00:55:28 77111 8192000000 10334032176 10774650880 1405417904 14.643 99 20 40 1 1424914944 14999760 4497280
00:57:46 14392 8192000000 10287946144 10732290048 1366762816 14.298 98 53 105 0 1387356192 9099792 11493584
00:59:01 36224 8192000000 10302935280 10753122304 1396516608 14.564 100 21 42 0 1409121776 8247056 4358112
01:00:39 59547 8192000000 10289056464 10748231680 1371206272 14.338 98 7 14 0 1384440304 11529072 1704960
01:02:39 60389 8192000000 10282580128 10735038464 1366367584 14.294 98 14 28 0 1385654656 15538224 3748848
01:04:40 78641 8192000000 10289346608 10751242240 1353827024 14.182 97 19 38 1 1376506224 18105584 4573616
01:07:00 47035 8192000000 10280906576 10717528064 1331718304 13.983 97 17 34 0 1342237440 6858816 3660320
01:08:47 67068 8192000000 9235405888 9502584832 342832432 4.016 26 4 8 0 347698944 4017904 848608

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 02-04-2024 01:11:08 to 02-04-2024 01:11:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 152 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Apr  2 01:11:26 2024 
 
Database header page information: 
    Flags            0 
    Generation        94636 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    180455 
    Oldest active        180456 
    Oldest snapshot        180456 
    Next transaction    180457 
    Sequence number        0 
    Next attachment ID    724 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.24, total records: 7839984 
    Average version length: 48.16, total versions: 107486, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87016 
    Data pages: 87016, average fill: 72% 
    Primary pages: 87016, secondary pages: 0, swept pages: 15359 
    Empty pages: 1, full pages: 70333 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 20 
    40 - 59% = 779 
    60 - 79% = 86155 
    80 - 99% = 61 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23504, nodes: 7839984 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1774502, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 356 
        20 - 39% = 1675 
        40 - 59% = 4359 
        60 - 79% = 2224 
        80 - 99% = 14890 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13611, nodes: 7839984 
    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: 1596054, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1493 
        40 - 59% = 2141 
        60 - 79% = 1074 
        80 - 99% = 8903 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8427, nodes: 7839984 
    Average node length: 6.63, total dup: 5842658, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1589074, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 138 
        20 - 39% = 880 
        40 - 59% = 1515 
        60 - 79% = 839 
        80 - 99% = 5055 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.05, total records: 2289188 
    Average version length: 34.52, total versions: 108298, max versions: 3 
    Average fragment length: 3.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28368 
    Data pages: 28368, average fill: 75% 
    Primary pages: 28365, secondary pages: 3, swept pages: 8416 
    Empty pages: 49, full pages: 22266 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 21 
    40 - 59% = 347 
    60 - 79% = 26854 
    80 - 99% = 1086 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4606, nodes: 2289188 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 725505, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 896 
        40 - 59% = 903 
        60 - 79% = 645 
        80 - 99% = 2162 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2529, nodes: 2291875 
    Average node length: 4.97, total dup: 2290976, max dup: 19800 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1266567, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 217 
        40 - 59% = 1549 
        60 - 79% = 560 
        80 - 99% = 201 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2091, nodes: 2289188 
    Average node length: 4.97, total dup: 2289138, max dup: 130638 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1068264, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 60 
        40 - 59% = 1200 
        60 - 79% = 40 
        80 - 99% = 788 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4415, nodes: 2289188 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 725505, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 581 
        40 - 59% = 646 
        60 - 79% = 742 
        80 - 99% = 2323 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.30, total records: 400 
    Average version length: 23.26, total versions: 237945, max versions: 618 
    Average fragment length: 2.00, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1320, average fill: 90% 
    Primary pages: 10, secondary pages: 1310, swept pages: 0 
    Empty pages: 3, full pages: 1316 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1316 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 28.75, total records: 77683 
    Average version length: 68.26, total versions: 44973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.06 
    Pointer pages: 5, data page slots: 2664 
    Data pages: 1173, average fill: 78% 
    Primary pages: 1172, secondary pages: 1, swept pages: 0 
    Empty pages: 46, full pages: 1014 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 29 
    40 - 59% = 44 
    60 - 79% = 338 
    80 - 99% = 690 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699087, depth: 3, leaf buckets: 228, nodes: 77683 
    Average node length: 13.42, total dup: 3503, max dup: 1 
    Average key length: 10.82, compression ratio: 2.49 
    Average prefix length: 19.13, average data length: 7.87 
    Clustering factor: 56911, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 42 
        40 - 59% = 97 
        60 - 79% = 62 
        80 - 99% = 27 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 19026, max versions: 949 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 85% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 63 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 8.43, total records: 1201 
    Average version length: 42.66, total versions: 977, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.88 
    Pointer pages: 1, data page slots: 40 
    Data pages: 38, average fill: 30% 
    Primary pages: 36, secondary pages: 2, swept pages: 9 
    Empty pages: 18, full pages: 10 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 95997, depth: 2, leaf buckets: 2, nodes: 1201 
    Average node length: 4.33, total dup: 1104, max dup: 116 
    Average key length: 2.85, compression ratio: 6.67 
    Average prefix length: 18.23, average data length: 0.77 
    Clustering factor: 644, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.87, total records: 75 
    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.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.96, total records: 796312 
    Average version length: 25.34, total versions: 73872, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 7824 
    Data pages: 7824, average fill: 71% 
    Primary pages: 7805, secondary pages: 19, swept pages: 1177 
    Empty pages: 16, full pages: 7055 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 42 
    40 - 59% = 130 
    60 - 79% = 7320 
    80 - 99% = 307 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 876, nodes: 796312 
    Average node length: 4.87, total dup: 796263, max dup: 150091 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88627, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 124 
        40 - 59% = 474 
        60 - 79% = 211 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 865, nodes: 796312 
    Average node length: 5.87, total dup: 709070, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159527, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 105 
        40 - 59% = 263 
        60 - 79% = 132 
        80 - 99% = 360 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 898, nodes: 796312 
    Average node length: 5.87, total dup: 709070, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161356, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 191 
        40 - 59% = 218 
        60 - 79% = 113 
        80 - 99% = 376 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1120, nodes: 796312 
    Average node length: 5.96, total dup: 709070, max dup: 43 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153983, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 219 
        40 - 59% = 611 
        60 - 79% = 181 
        80 - 99% = 106 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.88, total records: 5499 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.94, total fragments: 50, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 136 
    Data pages: 128, average fill: 43% 
    Primary pages: 105, secondary pages: 23, swept pages: 49 
    Empty pages: 40, full pages: 67 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5499 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.09 
    Average prefix length: 34.49, average data length: 1.54 
    Clustering factor: 5209, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5499 
    Average node length: 11.11, 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: 148, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.20, total records: 82808 
    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.22 
    Pointer pages: 1, data page slots: 800 
    Data pages: 800, average fill: 71% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 798 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 798 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35104, depth: 2, leaf buckets: 106, nodes: 82808 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3854, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 104 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.17, total records: 172342 
    Average version length: 152.77, total versions: 4569, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 5, data page slots: 4536 
    Data pages: 4128, average fill: 86% 
    Primary pages: 4128, secondary pages: 0, swept pages: 4 
    Empty pages: 35, full pages: 4085 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4085 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.12, total records: 151315 
    Average version length: 148.27, total versions: 783, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 3960 
    Data pages: 3672, average fill: 85% 
    Primary pages: 3671, secondary pages: 1, swept pages: 8 
    Empty pages: 75, full pages: 3576 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3575 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 149.69, total records: 152930 
    Average version length: 150.15, total versions: 1157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 4648 
    Data pages: 3672, average fill: 86% 
    Primary pages: 3672, secondary pages: 0, swept pages: 3 
    Empty pages: 44, full pages: 3614 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 3614 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 143.53, total records: 165774 
    Average version length: 154.25, total versions: 8168, 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: 5, data page slots: 5264 
    Data pages: 3976, average fill: 86% 
    Primary pages: 3976, secondary pages: 0, swept pages: 2 
    Empty pages: 38, full pages: 3925 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3924 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.68, total records: 158351 
    Average version length: 152.99, total versions: 5647, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 6, data page slots: 4312 
    Data pages: 3808, average fill: 86% 
    Primary pages: 3808, secondary pages: 0, swept pages: 4 
    Empty pages: 46, full pages: 3750 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3750 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 150.00, total records: 169584 
    Average version length: 149.79, total versions: 1090, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 5, data page slots: 4968 
    Data pages: 4048, average fill: 86% 
    Primary pages: 4048, secondary pages: 0, swept pages: 3 
    Empty pages: 23, full pages: 4012 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4013 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 145.76, total records: 155027 
    Average version length: 153.03, total versions: 5199, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 6, data page slots: 4232 
    Data pages: 3744, average fill: 85% 
    Primary pages: 3744, secondary pages: 0, swept pages: 1 
    Empty pages: 61, full pages: 3663 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3663 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.28, total records: 156307 
    Average version length: 152.56, total versions: 3785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 4232 
    Data pages: 3776, average fill: 85% 
    Primary pages: 3776, secondary pages: 0, swept pages: 5 
    Empty pages: 51, full pages: 3687 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 8 
    40 - 59% = 22 
    60 - 79% = 1 
    80 - 99% = 3687 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 126.51, total records: 191254 
    Average version length: 154.63, total versions: 30994, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.41 
    Pointer pages: 5, data page slots: 5232 
    Data pages: 4608, average fill: 87% 
    Primary pages: 4608, secondary pages: 0, swept pages: 3 
    Empty pages: 51, full pages: 4537 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 5 
    40 - 59% = 11 
    60 - 79% = 3 
    80 - 99% = 4536 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.58, total records: 155876 
    Average version length: 153.00, total versions: 4394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 3968 
    Data pages: 3728, average fill: 86% 
    Primary pages: 3728, secondary pages: 0, swept pages: 1 
    Empty pages: 33, full pages: 3687 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3688 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.57, total records: 2130872 
    Average version length: 52.97, total versions: 47529, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25512 
    Data pages: 25496, average fill: 72% 
    Primary pages: 25496, secondary pages: 0, swept pages: 9625 
    Empty pages: 230, full pages: 21956 
    Fill distribution: 
     0 - 19% = 432 
    20 - 39% = 335 
    40 - 59% = 780 
    60 - 79% = 23499 
    80 - 99% = 450 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2621, nodes: 2130872 
    Average node length: 5.44, total dup: 1988554, max dup: 1489 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185126, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 270 
        40 - 59% = 1769 
        60 - 79% = 299 
        80 - 99% = 280 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2768, nodes: 2130872 
    Average node length: 5.69, total dup: 1913170, max dup: 76 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 381597, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2329 
        60 - 79% = 406 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2227, nodes: 2130872 
    Average node length: 4.96, total dup: 2130772, max dup: 29083 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182472, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 199 
        40 - 59% = 1279 
        60 - 79% = 393 
        80 - 99% = 355 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 39.78, total records: 153044 
    Average version length: 69.17, total versions: 65080, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.17 
    Pointer pages: 3, data page slots: 3568 
    Data pages: 2728, average fill: 65% 
    Primary pages: 2728, secondary pages: 0, swept pages: 266 
    Empty pages: 356, full pages: 2024 
    Fill distribution: 
     0 - 19% = 488 
    20 - 39% = 82 
    40 - 59% = 77 
    60 - 79% = 749 
    80 - 99% = 1332 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 97852, depth: 3, leaf buckets: 224, nodes: 153044 
    Average node length: 6.42, total dup: 133216, max dup: 14 
    Average key length: 3.93, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 26481, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 112 
        60 - 79% = 50 
        80 - 99% = 23 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.13, total records: 7019413 
    Average version length: 68.80, total versions: 492769, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 62, data page slots: 100112 
    Data pages: 100112, average fill: 75% 
    Primary pages: 100112, secondary pages: 0, swept pages: 20383 
    Empty pages: 22, full pages: 84403 
    Fill distribution: 
     0 - 19% = 135 
    20 - 39% = 827 
    40 - 59% = 5291 
    60 - 79% = 84037 
    80 - 99% = 9822 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10573, nodes: 7019413 
    Average node length: 6.51, total dup: 6070583, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1542334, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1523 
        40 - 59% = 5966 
        60 - 79% = 2553 
        80 - 99% = 528 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8315, nodes: 7019413 
    Average node length: 5.40, total dup: 6738542, max dup: 188 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1343311, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1117 
        40 - 59% = 4422 
        60 - 79% = 1579 
        80 - 99% = 1190 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8359, nodes: 7019413 
    Average node length: 5.40, total dup: 6738542, max dup: 188 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1345824, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1185 
        40 - 59% = 4373 
        60 - 79% = 1556 
        80 - 99% = 1235 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.71, total records: 11877685 
    Average version length: 68.74, total versions: 386663, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 101, data page slots: 164560 
    Data pages: 164560, average fill: 77% 
    Primary pages: 164560, secondary pages: 0, swept pages: 67460 
    Empty pages: 5, full pages: 156028 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 396 
    40 - 59% = 2510 
    60 - 79% = 153606 
    80 - 99% = 8008 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18228, nodes: 11877685 
    Average node length: 6.56, total dup: 10352337, max dup: 57 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2341038, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 2354 
        40 - 59% = 11028 
        60 - 79% = 4062 
        80 - 99% = 753 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.53, total records: 1785844 
    Average version length: 69.14, total versions: 739247, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 25, data page slots: 38952 
    Data pages: 29616, average fill: 69% 
    Primary pages: 29616, secondary pages: 0, swept pages: 5675 
    Empty pages: 1966, full pages: 21666 
    Fill distribution: 
     0 - 19% = 3353 
    20 - 39% = 1793 
    40 - 59% = 1619 
    60 - 79% = 10749 
    80 - 99% = 12102 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2270, nodes: 1785844 
    Average node length: 5.51, total dup: 1713146, max dup: 99 
    Average key length: 2.55, compression ratio: 16.45 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 122453, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 406 
        40 - 59% = 1095 
        60 - 79% = 585 
        80 - 99% = 173 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.24, total records: 1192568 
    Average version length: 69.14, total versions: 514626, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.21 
    Pointer pages: 18, data page slots: 28424 
    Data pages: 23856, average fill: 58% 
    Primary pages: 23856, secondary pages: 0, swept pages: 2982 
    Empty pages: 2696, full pages: 13309 
    Fill distribution: 
     0 - 19% = 4872 
    20 - 39% = 2098 
    40 - 59% = 1656 
    60 - 79% = 7106 
    80 - 99% = 8124 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1619, nodes: 1192568 
    Average node length: 5.76, total dup: 1116189, max dup: 140 
    Average key length: 2.82, compression ratio: 14.88 
    Average prefix length: 41.24, average data length: 0.76 
    Clustering factor: 159328, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 333 
        40 - 59% = 806 
        60 - 79% = 388 
        80 - 99% = 91 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.94, total records: 9512413 
    Average version length: 68.94, total versions: 546107, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 88, data page slots: 142464 
    Data pages: 142456, average fill: 71% 
    Primary pages: 142456, secondary pages: 0, swept pages: 47061 
    Empty pages: 219, full pages: 87697 
    Fill distribution: 
     0 - 19% = 728 
    20 - 39% = 2862 
    40 - 59% = 15420 
    60 - 79% = 114206 
    80 - 99% = 9240 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13512, nodes: 9512413 
    Average node length: 6.67, total dup: 7892812, max dup: 14 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2067840, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 946 
        40 - 59% = 6512 
        60 - 79% = 5232 
        80 - 99% = 821 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21194838 
    Average version length: 82.95, total versions: 14818, 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: 319336 
    Data pages: 319336, average fill: 81% 
    Primary pages: 319336, secondary pages: 0, swept pages: 12446 
    Empty pages: 12, full pages: 319027 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 13 
    40 - 59% = 28 
    60 - 79% = 27241 
    80 - 99% = 292035 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19304, nodes: 21194838 
    Average node length: 5.72, total dup: 20712797, max dup: 138 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288365, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 7911 
        60 - 79% = 537 
        80 - 99% = 10848 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17221, nodes: 21194838 
    Average node length: 6.31, total dup: 18625904, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916368, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 783 
        60 - 79% = 310 
        80 - 99% = 16120 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21129, nodes: 21194838 
    Average node length: 6.35, total dup: 18544377, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583308, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8280 
        60 - 79% = 571 
        80 - 99% = 12273 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16247, nodes: 21194838 
    Average node length: 5.56, total dup: 21194738, max dup: 230842 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945210, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 3087 
        60 - 79% = 437 
        80 - 99% = 12711 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.04, total records: 9955437 
    Average version length: 82.61, total versions: 529529, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 170480 
    Data pages: 170448, average fill: 72% 
    Primary pages: 170448, secondary pages: 0, swept pages: 69289 
    Empty pages: 307, full pages: 106095 
    Fill distribution: 
     0 - 19% = 1062 
    20 - 39% = 4905 
    40 - 59% = 21048 
    60 - 79% = 75911 
    80 - 99% = 67522 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11399, nodes: 9955437 
    Average node length: 5.36, total dup: 9643691, max dup: 194 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2199960, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 35 
        40 - 59% = 7541 
        60 - 79% = 3678 
        80 - 99% = 143 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13760, nodes: 9955437 
    Average node length: 6.23, total dup: 8255787, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1536306, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 3976 
        40 - 59% = 4444 
        60 - 79% = 2615 
        80 - 99% = 2602 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12734, nodes: 9955437 
    Average node length: 5.98, total dup: 8647598, max dup: 41 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2394544, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 45 
        40 - 59% = 8492 
        60 - 79% = 4022 
        80 - 99% = 172 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10446, nodes: 9955437 
    Average node length: 5.14, total dup: 9955337, max dup: 156680 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1569320, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1237 
        40 - 59% = 5308 
        60 - 79% = 1738 
        80 - 99% = 2110 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.48, total records: 11669731 
    Average version length: 82.59, total versions: 401471, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 192432 
    Data pages: 191224, average fill: 75% 
    Primary pages: 191224, secondary pages: 0, swept pages: 63319 
    Empty pages: 2301, full pages: 153023 
    Fill distribution: 
     0 - 19% = 3721 
    20 - 39% = 5139 
    40 - 59% = 13762 
    60 - 79% = 42183 
    80 - 99% = 126419 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13179, nodes: 11669731 
    Average node length: 5.31, total dup: 11559187, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2429724, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 83 
        40 - 59% = 8323 
        60 - 79% = 4473 
        80 - 99% = 299 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10715, nodes: 11669731 
    Average node length: 5.51, total dup: 11161288, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 730132, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 181 
        20 - 39% = 810 
        40 - 59% = 2607 
        60 - 79% = 1811 
        80 - 99% = 5306 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15073, nodes: 11669731 
    Average node length: 6.03, total dup: 10190552, max dup: 68 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2446245, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 126 
        40 - 59% = 9716 
        60 - 79% = 4864 
        80 - 99% = 363 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11138, nodes: 11669731 
    Average node length: 5.23, total dup: 11669631, max dup: 202098 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 717863, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 758 
        40 - 59% = 5113 
        60 - 79% = 1559 
        80 - 99% = 3621 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.42, total records: 10069633 
    Average version length: 82.88, total versions: 525912, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 107, data page slots: 173888 
    Data pages: 173848, average fill: 72% 
    Primary pages: 173848, secondary pages: 0, swept pages: 72665 
    Empty pages: 370, full pages: 106550 
    Fill distribution: 
     0 - 19% = 1209 
    20 - 39% = 5269 
    40 - 59% = 22390 
    60 - 79% = 78381 
    80 - 99% = 66599 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12055, nodes: 10069633 
    Average node length: 5.18, total dup: 10040510, max dup: 2006 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2016357, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1367 
        40 - 59% = 8096 
        60 - 79% = 1913 
        80 - 99% = 648 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13934, nodes: 10069633 
    Average node length: 6.25, total dup: 8350159, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1504727, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 208 
        20 - 39% = 3959 
        40 - 59% = 4414 
        60 - 79% = 2653 
        80 - 99% = 2700 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12703, nodes: 10069633 
    Average node length: 5.43, total dup: 9622741, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2152130, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1350 
        40 - 59% = 8952 
        60 - 79% = 1771 
        80 - 99% = 605 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10596, nodes: 10069633 
    Average node length: 5.15, total dup: 10069533, max dup: 159085 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1597553, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1279 
        40 - 59% = 5384 
        60 - 79% = 1803 
        80 - 99% = 2096 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.35, total records: 584511 
    Average version length: 68.81, total versions: 7096, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8128 
    Data pages: 8128, average fill: 75% 
    Primary pages: 8128, secondary pages: 0, swept pages: 4093 
    Empty pages: 2, full pages: 6678 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 11 
    40 - 59% = 202 
    60 - 79% = 7778 
    80 - 99% = 134 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39940, depth: 3, leaf buckets: 754, nodes: 584511 
    Average node length: 5.95, total dup: 497877, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101206, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 543 
        60 - 79% = 104 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29531, depth: 3, leaf buckets: 777, nodes: 584511 
    Average node length: 6.15, total dup: 479499, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101265, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 562 
        60 - 79% = 108 
        80 - 99% = 86 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 599, nodes: 584511 
    Average node length: 4.86, total dup: 584411, max dup: 9822 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89867, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 41 
        40 - 59% = 378 
        60 - 79% = 61 
        80 - 99% = 119 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Apr  2 01:11:49 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7839984 107486 1 0.0000 0.0000
DOC_LIST 2289188 108298 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237945 618 59400.0000 0.0000
INVNT_TURNOVER_LOG 77683 44973 1 0.0000 0.0000
MONEY_SALDO 49 19026 949 38800.0000 0.0000
MONEY_TURNOVER_LOG 1201 977 1 0.0000 0.0000
PDISTR 796312 73872 5 0.0000 0.0000
PERF_SPLIT_0 172342 4569 1 0.0000 0.0000
PERF_SPLIT_1 151315 783 1 0.0000 0.0000
PERF_SPLIT_2 152930 1157 1 0.0000 0.0000
PERF_SPLIT_3 165774 8168 1 0.0000 0.0000
PERF_SPLIT_4 158351 5647 1 0.0000 0.0000
PERF_SPLIT_5 169584 1090 1 0.0000 0.0000
PERF_SPLIT_6 155027 5199 1 0.0000 0.0000
PERF_SPLIT_7 156307 3785 1 0.0000 0.0000
PERF_SPLIT_8 191254 30994 1 0.0000 0.0000
PERF_SPLIT_9 155876 4394 1 0.0000 0.0000
PSTORNED 2130872 47529 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 153044 65080 1 0.0000 0.0000
XQD_1000_3300 7019413 492769 1 0.0000 0.0000
XQD_1200_2000 11877685 386663 1 0.0000 0.0000
XQD_2000_3300 1785844 739247 1 0.0000 0.0000
XQD_2100_3300 1192568 514626 1 0.0000 0.0000
XQD_3300_3400 9512413 546107 1 0.0000 0.0000
XQS_1000_1200 21194838 14818 1 0.0000 0.0000
XQS_1000_3300 9955437 529529 1 0.0000 0.0000
XQS_1200_2000 11669731 401471 1 0.0000 0.0000
XQS_2100_3300 10069633 525912 1 0.0000 0.0000
XQS_3300_3400 584511 7096 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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