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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-22 10:07:52
DTS_END                         2024-03-22 10:07:52.0070
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/38958
TRN_ID                          179158
ATT_ID                          592
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: 9220.65 20910 922065
customer order: creation 181.51 422 18151
customer order: refuse 15.45 412 1545
order to supplier: creation 49.05 1309 4905
order to supplier: removal 3.74 79953 374
invoice (draft): creation 48.38 3288 4838
invoice (draft): removal 46.44 756 4644
invoice accept: apply 44.80 20524 4480
invoice accept: cancel 42.16 795 4216
customer reserve: creation 4324.18 196 432418
customer reserve: removal 4173.65 56 417365
realization accept: apply 87.33 194 8733
realization accept: cancel 68.42 143 6842
payment from customer: creation 62.50 117 6250
payment from customer: removal 6.31 70 631
payment to supplier: creation 51.45 156 5145
payment to supplier: removal 3.63 71 363
service: total inventory turnovers 4.01 3821 401
service: total monetary turnovers 6.71 608 671
service: aggregate perf. data 0.90 17990 90
service: refresh index statistics 0.03 287311 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-03-2024 10:08:55 to 22-03-2024 10:08:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 245
TEST_TIME 2 1639
TEST_TIME 3 2950
TEST_TIME 4 3513
TEST_TIME 5 3871
TEST_TIME 6 3976
TEST_TIME 7 4377
TEST_TIME 8 4492
TEST_TIME 9 4872
TEST_TIME 10 5410
TEST_TIME 11 5364
TEST_TIME 12 5819
TEST_TIME 13 6248
TEST_TIME 14 6443
TEST_TIME 15 6766
TEST_TIME 16 6833
TEST_TIME 17 7065
TEST_TIME 18 7809
TEST_TIME 19 7801
TEST_TIME 20 7711
TEST_TIME 21 8317
TEST_TIME 22 8563
TEST_TIME 23 9020
TEST_TIME 24 9517
TEST_TIME 25 9288
TEST_TIME 26 9405
TEST_TIME 27 9802
TEST_TIME 28 9638
TEST_TIME 29 9565
TEST_TIME 30 9466
TEST_TIME 31 9312
TEST_TIME 32 9194
TEST_TIME 33 9211
TEST_TIME 34 9073
TEST_TIME 35 9134
TEST_TIME 36 9117
TEST_TIME 37 9134
TEST_TIME 38 9176
TEST_TIME 39 9336
TEST_TIME 40 9282
TEST_TIME 41 9154
TEST_TIME 42 9154
TEST_TIME 43 9364
TEST_TIME 44 9347
TEST_TIME 45 9406
TEST_TIME 46 9455
TEST_TIME 47 9536
TEST_TIME 48 9558
TEST_TIME 49 9609
TEST_TIME 50 9611
TEST_TIME 51 9682
TEST_TIME 52 9668
TEST_TIME 53 9788
TEST_TIME 54 9753
TEST_TIME 55 9618
TEST_TIME 56 9500
TEST_TIME 57 9461
TEST_TIME 58 9423
TEST_TIME 59 9352
TEST_TIME 60 9284
TEST_TIME 61 9281
TEST_TIME 62 9304
TEST_TIME 63 9243
TEST_TIME 64 9327
TEST_TIME 65 9353
TEST_TIME 66 9322
TEST_TIME 67 9395
TEST_TIME 68 9326
TEST_TIME 69 9445
TEST_TIME 70 9420
TEST_TIME 71 9509
TEST_TIME 72 9483
TEST_TIME 73 9380
TEST_TIME 74 9314
TEST_TIME 75 9306
TEST_TIME 76 9302
TEST_TIME 77 9234
TEST_TIME 78 9327
TEST_TIME 79 9324
TEST_TIME 80 9284
TEST_TIME 81 9358
TEST_TIME 82 9332
TEST_TIME 83 9390
TEST_TIME 84 9381
TEST_TIME 85 9424
TEST_TIME 86 9412
TEST_TIME 87 9446
TEST_TIME 88 9430
TEST_TIME 89 9376
TEST_TIME 90 9325
TEST_TIME 91 9290
TEST_TIME 92 9273
TEST_TIME 93 9230
TEST_TIME 94 9220
TEST_TIME 95 9181
TEST_TIME 96 9199
TEST_TIME 97 9213
TEST_TIME 98 9192
TEST_TIME 99 9209
TEST_TIME 100 9221

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-03-2024 10:08:59 to 22-03-2024 10:09:02.

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 1314613 1314613 0 0.00 0 17854 7 0 0
doc_list_biud 1314613 1314613 0 0.00 0 73499 23 0 0
sp_add_invoice_to_stock 4634 4480 154 3.32 42 197617 20525 0 154
sp_cancel_adding_invoice 4216 4216 0 0.00 5 45270 795 0 0
sp_cancel_client_order 1545 1545 0 0.00 4 22552 413 0 0
sp_cancel_customer_reserve 417365 417365 0 0.00 0 20744 56 0 0
sp_cancel_pay_from_customer 631 631 0 0.00 2 2887 70 0 0
sp_cancel_pay_to_supplier 363 363 0 0.00 3 3869 72 0 0
sp_cancel_supplier_invoice 4649 4644 5 0.10 1 73505 757 0 5
sp_cancel_supplier_order 374 374 0 0.00 11 863840 79953 0 0
sp_cancel_write_off 6842 6842 0 0.00 1 15928 144 0 0
sp_client_order 18151 18151 0 0.00 3 21113 423 0 0
sp_customer_reserve 432418 432418 0 0.00 0 45319 196 0 0
sp_fill_shopping_cart 27881 27881 0 0.00 1 19341 39 0 0
sp_fill_shopping_cart_clo_res 432416 432416 0 0.00 0 18442 16 0 0
sp_get_clo_for_invoice 4478 4478 0 0.00 0 23250 364 0 0
sp_kill_cost_storno 12052 12052 0 0.00 0 15924 76 0 0
sp_kill_qstorno_ret_qs2qd 846590 846590 0 0.00 0 73499 31 0 0
sp_kill_qty_storno 448196 448196 0 0.00 0 73499 67 0 0
sp_lock_selected_doc 18283 18283 0 0.00 0 10685 7 0 0
sp_make_cost_storno 24605 24605 0 0.00 0 16475 61 0 0
sp_multiply_rows_for_pdistr 24605 24605 0 0.00 0 8698 34 0 0
sp_multiply_rows_for_qdistr 18151 18151 0 0.00 0 21099 226 0 0
sp_pay_from_customer 6250 6250 0 0.00 3 17268 118 0 0
sp_pay_to_supplier 5145 5145 0 0.00 4 17287 156 0 0
sp_payment_common 11395 11395 0 0.00 1 6058 18 0 0
sp_qd_handle_on_cancel_clo 1545 1545 0 0.00 0 22546 356 0 0
sp_qd_handle_on_invoice_upd_sts 8693 8693 0 0.00 0 45210 318 0 0
sp_qd_handle_on_reserve_upd_sts 8733 8733 0 0.00 0 22547 55 0 0
sp_reserve_write_off 8733 8733 0 0.00 5 23988 194 0 0
sp_supplier_invoice 4838 4838 0 0.00 5 96915 3289 0 0
sp_supplier_order 4905 4905 0 0.00 4 47557 1310 0 0
srv_aggregate_perf_data 90 90 0 0.00 1586 484363 17991 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1721 156523 43578 0 0
srv_find_qd_qs_mism 875216 875216 0 0.00 0 17853 7 0 0
srv_make_invnt_saldo 401 401 0 0.00 27 118299 3822 0 0
srv_make_money_saldo 671 671 0 0.00 1 13304 609 0 0
srv_recalc_idx_stat 3 3 0 0.00 223912 347931 287312 0 0
t$perf-abend:sp_add_invoice_to_stock 154 154 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4480 4480 0 0.00 0 7434 168 0 0
t$perf-norm:sp_cancel_adding_invoice 365 365 0 0.00 0 2642 93 0 0
t$perf-norm:sp_cancel_client_order 1545 1545 0 0.00 0 8797 25 0 0
t$perf-norm:sp_cancel_customer_reserve 597 597 0 0.00 0 3168 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 631 631 0 0.00 0 1079 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 363 363 0 0.00 0 1677 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 341 341 0 0.00 0 492 14 0 0
t$perf-norm:sp_cancel_supplier_order 374 374 0 0.00 0 32246 1500 0 0
t$perf-norm:sp_cancel_write_off 857 857 0 0.00 0 3823 13 0 0
t$perf-norm:sp_client_order 18151 18151 0 0.00 0 11016 18 0 0
t$perf-norm:sp_customer_reserve 842 842 0 0.00 0 441 5 0 0
t$perf-norm:sp_pay_from_customer 6250 6250 0 0.00 0 10208 11 0 0
t$perf-norm:sp_pay_to_supplier 5145 5145 0 0.00 0 5747 9 0 0
t$perf-norm:sp_reserve_write_off 8733 8733 0 0.00 0 10160 10 0 0
t$perf-norm:sp_supplier_invoice 4838 4838 0 0.00 0 3817 16 0 0
t$perf-norm:sp_supplier_order 4905 4905 0 0.00 0 6366 13 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 756 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 160 4 0 0
t$perf-norm:srv_make_invnt_saldo 401 401 0 0.00 0 302 4 0 0
t$perf-norm:srv_make_money_saldo 671 671 0 0.00 0 966 10 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 15 7 0 0
v_add_invoice_to_stock 9262 8954 308 3.32 0 15442 20 0 308
v_all_customers 33740 33740 0 0.00 0 101 1 0 0
v_all_suppliers 27636 27636 0 0.00 0 32 1 0 0
v_all_wares 36302 36302 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 730 730 0 0.00 0 4274 20 0 0
v_cancel_client_order 3090 3090 0 0.00 0 15370 17 0 0
v_cancel_customer_prepayment 1262 1262 0 0.00 0 666 4 0 0
v_cancel_customer_reserve 1194 1194 0 0.00 0 3535 11 0 0
v_cancel_payment_to_supplier 726 726 0 0.00 0 3836 10 0 0
v_cancel_supplier_invoice 692 682 10 1.44 0 3137 20 0 10
v_cancel_supplier_order 748 748 0 0.00 0 2093 8 0 0
v_cancel_write_off 1714 1714 0 0.00 0 1847 14 0 0
v_max_id_clo_ord 4905 4905 0 0.00 0 701 1 0 0
v_max_id_clo_res 842 842 0 0.00 0 9768 17 0 0
v_max_id_ord_sup 4825 4825 0 0.00 0 2276 2 0 0
v_max_non_paid_invoice 1057 1057 0 0.00 0 192 2 0 0
v_max_non_paid_realizn 3032 3032 0 0.00 0 987 3 0 0
v_min_id_clo_ord 4905 4905 0 0.00 0 3740 5 0 0
v_min_id_clo_res 842 842 0 0.00 0 2791 6 0 0
v_min_id_ord_sup 4825 4825 0 0.00 0 4120 6 0 0
v_min_non_paid_invoice 5145 5145 0 0.00 0 6055 14 0 0
v_min_non_paid_realizn 6250 6250 0 0.00 0 4485 12 0 0
v_our_firm 8998 8998 0 0.00 0 18 1 0 0
v_reserve_write_off 17466 17466 0 0.00 0 14865 8 0 0
x_lock_depdocs_on_canc_invoice 8519 8519 0 0.00 0 15711 121 0 0
x_lock_depdocs_on_canc_sup_ord 374 374 0 0.00 0 5141 299 0 0
x_make_qstorno_1000_1200 4905 4905 0 0.00 1 41109 1230 0 0
x_make_qstorno_1200_2000 4838 4838 0 0.00 2 95086 3141 0 0
x_make_qstorno_2100_3300 432418 432418 0 0.00 0 45316 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-03-2024 10:09:03 to 22-03-2024 10:09:07.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:56 1336 8192000000 8946409168 9007448064 17064320 0.207 4 2 4 0 17428256 107072 256864
08:08:59 33455 8192000000 9706255792 10005471232 783452320 8.728 100 90 180 0 813359952 7886400 22021232
08:10:36 19449 8192000000 9751821024 10060214272 829733264 9.197 100 90 177 0 861284656 11223152 20328240
08:12:00 18144 8192000000 9789260304 10106138624 855835232 9.459 100 88 176 1 892830656 16951056 20044368
08:13:24 12572 8192000000 9844793280 10175287296 898775024 9.886 100 82 163 0 946319264 30129344 17414896
08:14:39 5164 8192000000 9870986016 10216644608 929993232 10.195 100 78 156 0 993498304 47169952 16335120
08:15:46 6167 8192000000 9931609552 10284339200 968728192 10.574 100 80 160 0 1046100160 61488672 15883296
08:16:54 2125 8192000000 9975481440 10336727040 999971168 10.878 100 85 170 0 1085383376 68518512 16893696
08:18:00 1398 8192000000 10018612320 10386612224 1034855184 11.215 100 84 169 0 1128168976 77007632 16306160
08:19:03 1237 8192000000 10004756640 10388488192 1052090880 11.381 100 72 145 0 1122122416 56224288 13807248
08:20:05 29369 8192000000 9994868240 10380210176 1065895408 11.513 100 65 126 1 1127811296 49036672 12879216
08:21:36 4895 8192000000 10012280352 10405478400 1077743952 11.626 100 45 90 2 1112959632 26141424 9074256
08:22:43 60799 8192000000 10012861968 10420019200 1080904160 11.656 100 35 70 0 1108378448 19940752 7533536
08:24:49 4866 8192000000 10030521264 10431086592 1092573312 11.767 100 54 108 2 1136966336 33190016 11203008
08:25:57 10377 8192000000 10002125616 10421022720 1091086544 11.753 100 21 40 0 1132024384 36635360 4302480
08:27:09 6769 8192000000 9997537344 10412277760 1089227376 11.735 100 25 50 0 1119791952 25335936 5228640
08:28:22 73061 8192000000 10022449312 10427719680 1073634208 11.587 98 38 74 0 1105114736 23788736 7691792
08:30:39 11694 8192000000 10060904032 10460229632 1082852224 11.675 99 55 108 1 1159624096 65578160 11193712
08:32:00 25612 8192000000 10081704512 10479935488 1087630176 11.720 99 51 100 0 1177766960 79974752 10162032
08:33:28 82110 8192000000 10106966848 10545397760 1099498336 11.833 99 35 70 0 1230833088 123631296 7703456
08:35:56 38273 8192000000 10122654016 10537500672 1093192464 11.773 99 36 72 0 1232802384 131440400 8169520
08:37:43 17357 8192000000 10115845344 10532257792 1082978064 11.676 99 44 88 0 1213856368 122292768 8585536
08:39:07 6246 8192000000 10109004656 10511294464 1069785360 11.550 99 48 96 0 1216438384 136857408 9795616
08:40:18 2153 8192000000 10149986624 10552487936 1085281904 11.698 100 78 151 1 1249475712 148440576 15753232
08:41:26 2064 8192000000 10177121536 10569846784 1100935072 11.847 100 68 130 0 1284386752 170153136 13298544
08:42:32 2089 8192000000 10194870784 10583756800 1097259680 11.812 100 65 128 1 1300652400 189045424 14347296
08:43:40 2174 8192000000 10250603152 10634051584 1098134672 11.820 100 80 160 1 1346151600 230825424 17191504
08:44:47 3898 8192000000 10275789232 10682269696 1107573456 11.909 100 62 120 0 1381646800 261133536 12939808
08:45:55 1717 8192000000 10253621024 10637602816 1122545920 12.051 100 88 171 0 1348446448 207601008 18299520
08:47:03 32501 8192000000 10281229888 10684583936 1125168080 12.076 100 52 104 0 1371216560 233717520 12330960
08:48:39 6462 8192000000 10246332048 10665304064 1132017040 12.140 100 53 106 0 1351281696 207671360 11593296
08:49:53 17846 8192000000 10209960384 10657542144 1127659584 12.099 100 22 44 0 1323764016 190669328 5435104
08:51:15 48530 8192000000 10084900656 10555068416 1103953856 11.875 99 14 26 0 1170234560 63596064 2684640
08:53:20 11312 8192000000 10127038496 10557845504 1118268672 12.011 100 34 68 0 1218721632 93132224 7320736
08:54:37 81519 8192000000 10058911568 10476711936 1120833664 12.035 100 12 24 0 1174333104 51359216 2140224
08:57:01 21116 8192000000 10085235872 10517848064 1132458144 12.145 100 37 75 0 1189961680 49641424 7862112
08:58:24 92538 8192000000 10081181104 10509316096 1108213984 11.916 98 41 80 0 1166842208 50081392 8546832
09:01:01 68074 8192000000 10137199776 10580373504 1144309968 12.256 100 32 64 0 1233644816 83320000 6014848
09:03:14 20939 8192000000 10142819424 10577264640 1147345232 12.285 100 48 92 1 1237378448 80292416 9740800
09:04:39 60437 8192000000 10135573872 10622447616 1148700608 12.297 100 22 44 0 1246055424 92954496 4400320
09:06:44 36203 8192000000 10106608256 10570514432 1138451616 12.201 99 15 28 0 1194622048 53245808 2924624
09:08:23 36929 8192000000 10105037776 10550149120 1135585952 12.174 99 26 52 0 1188518960 47291280 5641728
09:10:12 53821 8192000000 10103162256 10613866496 1148827072 12.298 100 10 20 0 1215916256 65162624 1926560
09:12:18 51877 8192000000 10089357168 10532012032 1126844416 12.092 98 18 36 0 1175451312 45177328 3429568
09:14:18 86028 8192000000 10055470880 10508447744 1048807024 11.349 92 21 42 1 1098994064 45530080 4656960
09:16:53 42544 8192000000 10111534480 10602373120 1100528352 11.843 98 28 56 0 1148402000 42341184 5532464
09:18:51 85126 8192000000 10112524240 10546216960 1039426208 11.259 92 16 32 0 1121658224 79072880 3159136
09:21:21 156523 8192000000 10047360448 10530648064 1051171744 11.372 96 30 61 0 1123761232 66945792 5643696
09:25:00 48031 8192000000 10005186656 10459152384 1062803184 11.483 97 20 40 0 1122714016 55756736 4154096
09:26:57 36718 8192000000 10018570672 10468904960 1088974352 11.733 100 12 24 0 1123975296 32845120 2155824
09:29:02 44429 8192000000 10059824896 10498727936 1091931520 11.761 99 24 49 0 1144713712 47758048 5024144
09:30:46 63612 8192000000 10036835696 10486976512 1068541856 11.538 97 19 38 0 1139481952 66992064 3948032
09:32:55 25305 8192000000 10047902672 10468765696 1071599488 11.567 97 37 74 0 1106750608 28143808 7007312
09:34:21 45464 8192000000 10026306544 10469646336 1063478720 11.490 97 28 56 0 1108808608 39937440 5392448
09:36:15 11069 8192000000 10106696736 10523992064 1084900176 11.694 99 71 136 0 1181710960 83272288 13538496
09:37:28 20012 8192000000 10084228576 10526400512 1100464912 11.842 99 36 72 0 1165688960 58418672 6805376
09:38:50 87676 8192000000 10045015984 10517524480 1119088304 12.018 100 8 16 0 1166535296 45801088 1645904
09:41:32 4576 8192000000 10050743744 10472255488 1119925728 12.026 99 46 89 0 1146328736 18239440 8163568
09:42:38 70039 8192000000 10063872544 10553593856 1130847808 12.129 100 15 28 1 1181725280 47568800 3308672
09:44:51 21492 8192000000 10118523840 10558803968 1139010464 12.206 100 47 94 1 1199611264 50704816 9895984
09:46:13 52231 8192000000 10092454112 10555555840 1143525920 12.249 100 23 47 0 1202409472 53591856 5291696
09:48:09 69167 8192000000 10119822048 10606465024 1150249792 12.312 100 22 44 0 1216763600 62633872 3879936
09:50:32 75882 8192000000 10087825520 10543472640 1135847024 12.176 99 26 51 0 1202830688 60954448 6029216
09:52:48 47536 8192000000 10081134688 10524786688 1116801760 11.997 98 22 44 1 1141472960 20671104 4000096
09:54:35 53879 8192000000 10065041120 10503741440 1116890064 11.998 99 26 52 1 1164798768 43454864 4453840
09:56:31 80363 8192000000 10049786592 10501804032 1081680800 11.663 96 19 38 0 1126932368 41610384 3641184
09:59:07 55861 8192000000 10078607792 10549293056 1121647776 12.043 100 15 30 0 1186108352 61076912 3383664
10:01:23 65113 8192000000 10056457712 10542186496 1097808960 11.817 98 14 28 1 1171044448 70103664 3131824
10:03:35 78569 8192000000 10025769424 10482212864 1088506976 11.728 97 16 32 0 1145537920 54173456 2857488
10:05:55 47845 8192000000 10086931552 10531246080 1120616592 12.033 100 31 62 0 1200633872 73733472 6283808
10:07:45 13121 8192000000 9017693104 9237590016 176085488 2.104 16 4 8 0 219473248 42535536 852224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 22-03-2024 10:09:09 to 22-03-2024 10:09:23.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 154 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-03-2024 10:09:24 to 22-03-2024 10:09:26.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Mar 22 10:09:27 2024 
 
Database header page information: 
    Flags            0 
    Generation        93685 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    179494 
    Oldest active        179495 
    Oldest snapshot        179495 
    Next transaction    179496 
    Sequence number        0 
    Next attachment ID    704 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.41, total records: 7828243 
    Average version length: 48.16, total versions: 97985, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 89336 
    Data pages: 89336, average fill: 70% 
    Primary pages: 89336, secondary pages: 0, swept pages: 31153 
    Empty pages: 8, full pages: 78127 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 44 
    40 - 59% = 869 
    60 - 79% = 88363 
    80 - 99% = 48 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23401, nodes: 7828243 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1727275, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 336 
        20 - 39% = 1457 
        40 - 59% = 4466 
        60 - 79% = 2378 
        80 - 99% = 14764 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13584, nodes: 7828243 
    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: 1551271, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1393 
        40 - 59% = 2244 
        60 - 79% = 1085 
        80 - 99% = 8862 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8406, nodes: 7828243 
    Average node length: 6.64, total dup: 5828618, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1544249, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 777 
        40 - 59% = 1598 
        60 - 79% = 899 
        80 - 99% = 4992 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.39, total records: 2291427 
    Average version length: 58.85, total versions: 51367, max versions: 3 
    Average fragment length: 9.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 29008 
    Data pages: 29008, average fill: 73% 
    Primary pages: 29007, secondary pages: 1, swept pages: 8629 
    Empty pages: 0, full pages: 22747 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 19 
    40 - 59% = 267 
    60 - 79% = 28626 
    80 - 99% = 91 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4616, nodes: 2291427 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 695424, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 845 
        40 - 59% = 964 
        60 - 79% = 689 
        80 - 99% = 2118 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2457, nodes: 2292827 
    Average node length: 4.97, total dup: 2291928, max dup: 18070 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1279680, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 194 
        40 - 59% = 1420 
        60 - 79% = 579 
        80 - 99% = 263 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1808, nodes: 2291427 
    Average node length: 4.97, total dup: 2291377, max dup: 130329 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1083704, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 661 
        60 - 79% = 39 
        80 - 99% = 1105 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4409, nodes: 2291427 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 695424, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 513 
        40 - 59% = 748 
        60 - 79% = 792 
        80 - 99% = 2259 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.29, total records: 400 
    Average version length: 29.16, total versions: 1813, max versions: 6 
    Average fragment length: 2.00, total fragments: 8, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 48% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 7, full pages: 12 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 17.20, total records: 76376 
    Average version length: 68.28, total versions: 65819, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.12 
    Pointer pages: 7, data page slots: 2248 
    Data pages: 1440, average fill: 71% 
    Primary pages: 1439, secondary pages: 1, swept pages: 0 
    Empty pages: 130, full pages: 938 
    Fill distribution: 
     0 - 19% = 173 
    20 - 39% = 83 
    40 - 59% = 146 
    60 - 79% = 228 
    80 - 99% = 810 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1706907, depth: 3, leaf buckets: 250, nodes: 76376 
    Average node length: 13.44, total dup: 4396, max dup: 2 
    Average key length: 10.80, compression ratio: 2.50 
    Average prefix length: 19.14, average data length: 7.86 
    Clustering factor: 56571, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 70 
        40 - 59% = 106 
        60 - 79% = 70 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 199, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 3 
    Data pages: 2, average fill: 42% 
    Primary pages: 1, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.15, total records: 1615 
    Average version length: 43.23, total versions: 1469, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.77 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 54% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 6, full pages: 14 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88879, depth: 2, leaf buckets: 2, nodes: 1615 
    Average node length: 4.34, total dup: 1517, max dup: 180 
    Average key length: 2.64, compression ratio: 7.19 
    Average prefix length: 18.42, average data length: 0.58 
    Clustering factor: 904, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.76, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.94, total records: 774801 
    Average version length: 37.92, total versions: 33457, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8136 
    Data pages: 8128, average fill: 65% 
    Primary pages: 8127, secondary pages: 1, swept pages: 1196 
    Empty pages: 51, full pages: 6974 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 76 
    40 - 59% = 362 
    60 - 79% = 7552 
    80 - 99% = 50 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 813, nodes: 756165 
    Average node length: 4.87, total dup: 756116, max dup: 137176 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89443, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 119 
        40 - 59% = 422 
        60 - 79% = 180 
        80 - 99% = 91 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 862, nodes: 756165 
    Average node length: 5.88, total dup: 673262, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155165, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 59 
        40 - 59% = 361 
        60 - 79% = 145 
        80 - 99% = 295 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 885, nodes: 756165 
    Average node length: 5.88, total dup: 673262, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157154, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 117 
        40 - 59% = 335 
        60 - 79% = 141 
        80 - 99% = 292 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1101, nodes: 756165 
    Average node length: 5.96, total dup: 673262, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150315, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 265 
        40 - 59% = 580 
        60 - 79% = 183 
        80 - 99% = 69 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5474 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.50, total fragments: 28, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 120 
    Data pages: 111, average fill: 49% 
    Primary pages: 95, secondary pages: 16, swept pages: 53 
    Empty pages: 24, full pages: 57 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5474 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.09 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5148, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5474 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 158, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 81266 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 848 
    Data pages: 848, average fill: 66% 
    Primary pages: 848, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 844 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 844 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36193, depth: 2, leaf buckets: 104, nodes: 81266 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2987, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.06, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.23 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.09, total records: 188022 
    Average version length: 151.67, total versions: 5110, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 6016 
    Data pages: 4656, average fill: 83% 
    Primary pages: 4653, secondary pages: 3, swept pages: 1 
    Empty pages: 40, full pages: 4603 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4603 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 132.39, total records: 189923 
    Average version length: 154.27, total versions: 24697, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.81 
    Pointer pages: 7, data page slots: 6520 
    Data pages: 4744, average fill: 84% 
    Primary pages: 4743, secondary pages: 1, swept pages: 2 
    Empty pages: 60, full pages: 4653 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 4654 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 139.23, total records: 173966 
    Average version length: 152.72, total versions: 14475, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.18 
    Pointer pages: 7, data page slots: 5384 
    Data pages: 4336, average fill: 84% 
    Primary pages: 4333, secondary pages: 3, swept pages: 3 
    Empty pages: 54, full pages: 4266 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4266 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 128.43, total records: 166403 
    Average version length: 154.64, total versions: 26412, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.21 
    Pointer pages: 7, data page slots: 4640 
    Data pages: 4120, average fill: 85% 
    Primary pages: 4117, secondary pages: 3, swept pages: 1 
    Empty pages: 25, full pages: 4089 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 4091 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 143.49, total records: 139407 
    Average version length: 151.79, total versions: 7194, 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: 6, data page slots: 3848 
    Data pages: 3440, average fill: 84% 
    Primary pages: 3438, secondary pages: 2, swept pages: 1 
    Empty pages: 16, full pages: 3415 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3415 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.94, total records: 150006 
    Average version length: 151.05, total versions: 5113, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 8, data page slots: 4920 
    Data pages: 3768, average fill: 82% 
    Primary pages: 3767, secondary pages: 1, swept pages: 1 
    Empty pages: 78, full pages: 3665 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3666 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 136.68, total records: 179421 
    Average version length: 154.11, total versions: 18183, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.41 
    Pointer pages: 8, data page slots: 4848 
    Data pages: 4456, average fill: 84% 
    Primary pages: 4453, secondary pages: 3, swept pages: 1 
    Empty pages: 35, full pages: 4407 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 4407 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 132.72, total records: 169070 
    Average version length: 153.80, total versions: 21498, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.78 
    Pointer pages: 6, data page slots: 6728 
    Data pages: 4240, average fill: 84% 
    Primary pages: 4239, secondary pages: 1, swept pages: 1 
    Empty pages: 71, full pages: 4140 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4140 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 134.16, total records: 171740 
    Average version length: 154.30, total versions: 20202, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.64 
    Pointer pages: 6, data page slots: 4792 
    Data pages: 4272, average fill: 84% 
    Primary pages: 4271, secondary pages: 1, swept pages: 1 
    Empty pages: 45, full pages: 4209 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 4210 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 145.63, total records: 167484 
    Average version length: 150.85, total versions: 6455, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 8, data page slots: 4944 
    Data pages: 4160, average fill: 83% 
    Primary pages: 4158, secondary pages: 2, swept pages: 1 
    Empty pages: 40, full pages: 4104 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4106 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.92, total records: 2153591 
    Average version length: 52.95, total versions: 40817, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25936 
    Data pages: 25936, average fill: 72% 
    Primary pages: 25924, secondary pages: 12, swept pages: 9409 
    Empty pages: 44, full pages: 24257 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 121 
    40 - 59% = 381 
    60 - 79% = 24908 
    80 - 99% = 419 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2613, nodes: 2153591 
    Average node length: 5.44, total dup: 2011052, max dup: 1469 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185407, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 269 
        40 - 59% = 1716 
        60 - 79% = 306 
        80 - 99% = 319 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2761, nodes: 2153591 
    Average node length: 5.69, total dup: 1933889, max dup: 64 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 384301, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2286 
        60 - 79% = 442 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2145, nodes: 2153591 
    Average node length: 4.96, total dup: 2153491, max dup: 28062 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 182998, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 162 
        40 - 59% = 1122 
        60 - 79% = 401 
        80 - 99% = 459 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 41.82, total records: 143689 
    Average version length: 69.19, total versions: 65400, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.01 
    Pointer pages: 3, data page slots: 3888 
    Data pages: 3120, average fill: 56% 
    Primary pages: 3119, secondary pages: 1, swept pages: 390 
    Empty pages: 493, full pages: 1847 
    Fill distribution: 
     0 - 19% = 764 
    20 - 39% = 273 
    40 - 59% = 154 
    60 - 79% = 834 
    80 - 99% = 1095 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554186, depth: 3, leaf buckets: 228, nodes: 143689 
    Average node length: 6.43, total dup: 125133, max dup: 14 
    Average key length: 3.94, compression ratio: 10.66 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25643, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 59 
        40 - 59% = 114 
        60 - 79% = 49 
        80 - 99% = 5 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.10, total records: 6904789 
    Average version length: 68.80, total versions: 445047, 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: 65, data page slots: 104544 
    Data pages: 104544, average fill: 71% 
    Primary pages: 104543, secondary pages: 1, swept pages: 14815 
    Empty pages: 196, full pages: 80502 
    Fill distribution: 
     0 - 19% = 1143 
    20 - 39% = 2093 
    40 - 59% = 6086 
    60 - 79% = 93759 
    80 - 99% = 1463 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10626, nodes: 6904789 
    Average node length: 6.51, total dup: 5971245, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1629386, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2033 
        40 - 59% = 5563 
        60 - 79% = 2500 
        80 - 99% = 523 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8353, nodes: 6904789 
    Average node length: 5.40, total dup: 6625738, max dup: 167 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1437855, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1149 
        40 - 59% = 4615 
        60 - 79% = 1626 
        80 - 99% = 959 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8412, nodes: 6904789 
    Average node length: 5.40, total dup: 6625738, max dup: 167 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1440346, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1237 
        40 - 59% = 4599 
        60 - 79% = 1620 
        80 - 99% = 947 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.18, total records: 11842567 
    Average version length: 68.76, total versions: 346538, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 105, data page slots: 170968 
    Data pages: 170968, average fill: 74% 
    Primary pages: 170967, secondary pages: 1, swept pages: 55614 
    Empty pages: 7, full pages: 156884 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 525 
    40 - 59% = 3732 
    60 - 79% = 164588 
    80 - 99% = 2081 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18329, nodes: 11839343 
    Average node length: 6.59, total dup: 10320020, max dup: 55 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2456058, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2738 
        40 - 59% = 10709 
        60 - 79% = 3990 
        80 - 99% = 869 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 44.56, total records: 1730780 
    Average version length: 69.09, total versions: 427329, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.83 
    Pointer pages: 28, data page slots: 43384 
    Data pages: 30272, average fill: 59% 
    Primary pages: 30203, secondary pages: 69, swept pages: 5720 
    Empty pages: 2320, full pages: 21408 
    Fill distribution: 
     0 - 19% = 4105 
    20 - 39% = 4008 
    40 - 59% = 3283 
    60 - 79% = 13087 
    80 - 99% = 5789 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1958, nodes: 1450671 
    Average node length: 5.52, total dup: 1391595, max dup: 97 
    Average key length: 2.57, compression ratio: 16.37 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 104898, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 470 
        40 - 59% = 948 
        60 - 79% = 449 
        80 - 99% = 81 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 36.47, total records: 1380040 
    Average version length: 69.05, total versions: 173461, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.46 
    Pointer pages: 20, data page slots: 30936 
    Data pages: 25296, average fill: 44% 
    Primary pages: 25294, secondary pages: 2, swept pages: 3965 
    Empty pages: 3696, full pages: 13813 
    Fill distribution: 
     0 - 19% = 5995 
    20 - 39% = 3539 
    40 - 59% = 6468 
    60 - 79% = 8818 
    80 - 99% = 476 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1150, nodes: 804795 
    Average node length: 5.94, total dup: 741363, max dup: 95 
    Average key length: 3.00, compression ratio: 13.98 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 114433, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 236 
        40 - 59% = 589 
        60 - 79% = 288 
        80 - 99% = 37 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.66, total records: 9520041 
    Average version length: 68.98, total versions: 509420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 88, data page slots: 143232 
    Data pages: 143200, average fill: 71% 
    Primary pages: 143190, secondary pages: 10, swept pages: 36311 
    Empty pages: 163, full pages: 92094 
    Fill distribution: 
     0 - 19% = 424 
    20 - 39% = 1276 
    40 - 59% = 10155 
    60 - 79% = 127708 
    80 - 99% = 3637 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13525, nodes: 9514613 
    Average node length: 6.67, total dup: 7891121, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2176418, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1056 
        40 - 59% = 6544 
        60 - 79% = 4976 
        80 - 99% = 947 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21162363 
    Average version length: 82.84, total versions: 10894, 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: 197, data page slots: 319960 
    Data pages: 319960, average fill: 81% 
    Primary pages: 319957, secondary pages: 3, swept pages: 12631 
    Empty pages: 20, full pages: 319405 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 21 
    40 - 59% = 81 
    60 - 79% = 49194 
    80 - 99% = 270627 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19577, nodes: 21162363 
    Average node length: 5.72, total dup: 20681077, max dup: 140 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285177, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8496 
        60 - 79% = 564 
        80 - 99% = 10509 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17203, nodes: 21162363 
    Average node length: 6.31, total dup: 18596608, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918837, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 803 
        60 - 79% = 290 
        80 - 99% = 16102 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21340, nodes: 21162363 
    Average node length: 6.35, total dup: 18516662, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579851, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 8752 
        60 - 79% = 589 
        80 - 99% = 11995 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16082, nodes: 21162363 
    Average node length: 5.56, total dup: 21162263, max dup: 228453 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947638, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 2849 
        60 - 79% = 351 
        80 - 99% = 12869 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.09, total records: 9919045 
    Average version length: 82.65, total versions: 450557, 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: 105, data page slots: 170544 
    Data pages: 170512, average fill: 72% 
    Primary pages: 170490, secondary pages: 22, swept pages: 62996 
    Empty pages: 378, full pages: 108596 
    Fill distribution: 
     0 - 19% = 1139 
    20 - 39% = 3477 
    40 - 59% = 16185 
    60 - 79% = 126225 
    80 - 99% = 23486 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11359, nodes: 9919045 
    Average node length: 5.39, total dup: 9607335, max dup: 206 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2254806, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 33 
        40 - 59% = 7361 
        60 - 79% = 3828 
        80 - 99% = 133 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13724, nodes: 9919045 
    Average node length: 6.26, total dup: 8222251, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1585419, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3738 
        40 - 59% = 4575 
        60 - 79% = 2696 
        80 - 99% = 2576 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12682, nodes: 9919045 
    Average node length: 6.00, total dup: 8615004, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2449296, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 41 
        40 - 59% = 8337 
        60 - 79% = 4118 
        80 - 99% = 183 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10292, nodes: 9919045 
    Average node length: 5.16, total dup: 9918945, max dup: 160238 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1608749, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1260 
        40 - 59% = 4901 
        60 - 79% = 1837 
        80 - 99% = 2259 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.89, total records: 11622185 
    Average version length: 82.56, total versions: 382796, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 119, data page slots: 193984 
    Data pages: 192768, average fill: 74% 
    Primary pages: 192659, secondary pages: 109, swept pages: 55298 
    Empty pages: 1871, full pages: 158379 
    Fill distribution: 
     0 - 19% = 3236 
    20 - 39% = 4941 
    40 - 59% = 12850 
    60 - 79% = 101842 
    80 - 99% = 69899 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13137, nodes: 11622185 
    Average node length: 5.32, total dup: 11511749, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2450021, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 66 
        40 - 59% = 8347 
        60 - 79% = 4456 
        80 - 99% = 265 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10681, nodes: 11622185 
    Average node length: 5.51, total dup: 11115689, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 761879, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 810 
        40 - 59% = 2643 
        60 - 79% = 1837 
        80 - 99% = 5252 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15030, nodes: 11622185 
    Average node length: 6.04, total dup: 10150287, max dup: 92 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2466569, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 85 
        40 - 59% = 9759 
        60 - 79% = 4890 
        80 - 99% = 293 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11058, nodes: 11622185 
    Average node length: 5.24, total dup: 11622085, max dup: 201015 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 749762, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 786 
        40 - 59% = 5016 
        60 - 79% = 1497 
        80 - 99% = 3665 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.38, total records: 10042988 
    Average version length: 82.94, total versions: 458275, 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: 107, data page slots: 174440 
    Data pages: 174408, average fill: 72% 
    Primary pages: 174382, secondary pages: 26, swept pages: 66396 
    Empty pages: 489, full pages: 108596 
    Fill distribution: 
     0 - 19% = 1322 
    20 - 39% = 3874 
    40 - 59% = 18870 
    60 - 79% = 126792 
    80 - 99% = 23550 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12106, nodes: 10042988 
    Average node length: 5.20, total dup: 10013475, max dup: 2289 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2059488, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1416 
        40 - 59% = 8154 
        60 - 79% = 1857 
        80 - 99% = 646 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13815, nodes: 10042988 
    Average node length: 6.27, total dup: 8324382, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1562121, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 184 
        20 - 39% = 3724 
        40 - 59% = 4477 
        60 - 79% = 2697 
        80 - 99% = 2733 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12766, nodes: 10042988 
    Average node length: 5.46, total dup: 9593673, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2197126, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1378 
        40 - 59% = 9026 
        60 - 79% = 1718 
        80 - 99% = 610 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10483, nodes: 10042988 
    Average node length: 5.17, total dup: 10042888, max dup: 162729 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1640477, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1177 
        40 - 59% = 5219 
        60 - 79% = 1827 
        80 - 99% = 2220 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.52, total records: 586046 
    Average version length: 68.83, total versions: 6526, 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: 76% 
    Primary pages: 8128, secondary pages: 0, swept pages: 2903 
    Empty pages: 7, full pages: 7684 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 34 
    60 - 79% = 7988 
    80 - 99% = 98 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42371, depth: 3, leaf buckets: 734, nodes: 586046 
    Average node length: 5.95, total dup: 499011, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102799, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 501 
        60 - 79% = 107 
        80 - 99% = 101 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35632, depth: 3, leaf buckets: 754, nodes: 586046 
    Average node length: 6.15, total dup: 480748, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102845, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 516 
        60 - 79% = 106 
        80 - 99% = 113 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 586046 
    Average node length: 4.86, total dup: 585946, max dup: 9815 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91413, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 330 
        60 - 79% = 60 
        80 - 99% = 149 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar 22 10:09:51 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7828243 97985 1 0.0000 0.0000
DOC_LIST 2291427 51367 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1813 6 400.0000 0.0000
INVNT_TURNOVER_LOG 76376 65819 1 0.0000 0.0000
MONEY_SALDO 49 199 6 400.0000 0.0000
MONEY_TURNOVER_LOG 1615 1469 1 0.0000 0.0000
PDISTR 774801 33457 3 0.0000 0.0000
PERF_SPLIT_0 188022 5110 1 0.0000 0.0000
PERF_SPLIT_1 189923 24697 1 0.0000 0.0000
PERF_SPLIT_2 173966 14475 1 0.0000 0.0000
PERF_SPLIT_3 166403 26412 1 0.0000 0.0000
PERF_SPLIT_4 139407 7194 1 0.0000 0.0000
PERF_SPLIT_5 150006 5113 1 0.0000 0.0000
PERF_SPLIT_6 179421 18183 1 0.0000 0.0000
PERF_SPLIT_7 169070 21498 1 0.0000 0.0000
PERF_SPLIT_8 171740 20202 1 0.0000 0.0000
PERF_SPLIT_9 167484 6455 1 0.0000 0.0000
PSTORNED 2153591 40817 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143689 65400 1 0.0000 0.0000
XQD_1000_3300 6904789 445047 1 0.0000 0.0000
XQD_1200_2000 11842567 346538 1 0.0000 0.0000
XQD_2000_3300 1730780 427329 1 0.0000 0.0000
XQD_2100_3300 1380040 173461 1 0.0000 0.0000
XQD_3300_3400 9520041 509420 1 0.0000 0.0000
XQS_1000_1200 21162363 10894 1 0.0000 0.0000
XQS_1000_3300 9919045 450557 1 0.0000 0.0000
XQS_1200_2000 11622185 382796 1 0.0000 0.0000
XQS_2100_3300 10042988 458275 1 0.0000 0.0000
XQS_3300_3400 586046 6526 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 ---
:267: 
:268: mscs-test-161.budzdorov.ru    Fri Mar 22 10:08:05 2024
:269:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:270: 
:271: 
:272: mscs-test-161.budzdorov.ru    Fri Mar 22 10:08:09 2024
:273:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:274: 
--- end of diff output ---

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

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