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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-12 16:09:44
DTS_END                         2024-03-12 16:09:44.5390
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58396
TRN_ID                          181043
ATT_ID                          621
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: 9355.55 20134 935555
customer order: creation 186.99 370 18699
customer order: refuse 16.30 369 1630
order to supplier: creation 49.25 1331 4925
order to supplier: removal 3.34 95425 334
invoice (draft): creation 49.40 3501 4940
invoice (draft): removal 49.19 733 4919
invoice accept: apply 44.96 23061 4496
invoice accept: cancel 43.85 832 4385
customer reserve: creation 4284.44 223 428444
customer reserve: removal 4317.58 57 431758
realization accept: apply 88.57 199 8857
realization accept: cancel 82.48 138 8248
payment from customer: creation 63.61 123 6361
payment from customer: removal 6.05 113 605
payment to supplier: creation 52.79 131 5279
payment to supplier: removal 3.64 65 364
service: total inventory turnovers 5.00 1245 500
service: total monetary turnovers 7.15 40 715
service: aggregate perf. data 0.93 20595 93
service: refresh index statistics 0.03 254137 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-03-2024 16:10:39 to 12-03-2024 16:10:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6131
TEST_TIME 2 3958
TEST_TIME 3 3516
TEST_TIME 4 4313
TEST_TIME 5 4197
TEST_TIME 6 5102
TEST_TIME 7 5881
TEST_TIME 8 5918
TEST_TIME 9 5944
TEST_TIME 10 5960
TEST_TIME 11 6123
TEST_TIME 12 6806
TEST_TIME 13 6890
TEST_TIME 14 7200
TEST_TIME 15 7286
TEST_TIME 16 7242
TEST_TIME 17 7559
TEST_TIME 18 7578
TEST_TIME 19 7804
TEST_TIME 20 7786
TEST_TIME 21 7896
TEST_TIME 22 7865
TEST_TIME 23 8044
TEST_TIME 24 8332
TEST_TIME 25 8434
TEST_TIME 26 8397
TEST_TIME 27 8482
TEST_TIME 28 8640
TEST_TIME 29 8839
TEST_TIME 30 9551
TEST_TIME 31 9395
TEST_TIME 32 9173
TEST_TIME 33 9049
TEST_TIME 34 9143
TEST_TIME 35 9169
TEST_TIME 36 9136
TEST_TIME 37 9013
TEST_TIME 38 8920
TEST_TIME 39 8924
TEST_TIME 40 8878
TEST_TIME 41 8939
TEST_TIME 42 9100
TEST_TIME 43 9045
TEST_TIME 44 8993
TEST_TIME 45 9101
TEST_TIME 46 9089
TEST_TIME 47 9188
TEST_TIME 48 9275
TEST_TIME 49 9399
TEST_TIME 50 9516
TEST_TIME 51 9385
TEST_TIME 52 9337
TEST_TIME 53 9428
TEST_TIME 54 9585
TEST_TIME 55 9513
TEST_TIME 56 9681
TEST_TIME 57 9662
TEST_TIME 58 9567
TEST_TIME 59 9446
TEST_TIME 60 9433
TEST_TIME 61 9386
TEST_TIME 62 9334
TEST_TIME 63 9293
TEST_TIME 64 9356
TEST_TIME 65 9313
TEST_TIME 66 9256
TEST_TIME 67 9181
TEST_TIME 68 9152
TEST_TIME 69 9209
TEST_TIME 70 9211
TEST_TIME 71 9241
TEST_TIME 72 9220
TEST_TIME 73 9323
TEST_TIME 74 9307
TEST_TIME 75 9341
TEST_TIME 76 9334
TEST_TIME 77 9386
TEST_TIME 78 9477
TEST_TIME 79 9452
TEST_TIME 80 9541
TEST_TIME 81 9487
TEST_TIME 82 9496
TEST_TIME 83 9559
TEST_TIME 84 9470
TEST_TIME 85 9442
TEST_TIME 86 9440
TEST_TIME 87 9387
TEST_TIME 88 9404
TEST_TIME 89 9385
TEST_TIME 90 9341
TEST_TIME 91 9326
TEST_TIME 92 9264
TEST_TIME 93 9236
TEST_TIME 94 9265
TEST_TIME 95 9336
TEST_TIME 96 9324
TEST_TIME 97 9346
TEST_TIME 98 9352
TEST_TIME 99 9403
TEST_TIME 100 9367

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-03-2024 16:10:43 to 12-03-2024 16:10:46.

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 1326390 1326390 0 0.00 0 27724 7 0 0
doc_list_biud 1326390 1326390 0 0.00 0 44926 25 0 0
sp_add_invoice_to_stock 4637 4496 141 3.04 44 245913 23062 0 141
sp_cancel_adding_invoice 4385 4385 0 0.00 5 51872 832 0 0
sp_cancel_client_order 1630 1630 0 0.00 5 9764 369 0 0
sp_cancel_customer_reserve 431758 431758 0 0.00 0 29142 58 0 0
sp_cancel_pay_from_customer 605 605 0 0.00 2 8732 113 0 0
sp_cancel_pay_to_supplier 364 364 0 0.00 3 1330 66 0 0
sp_cancel_supplier_invoice 4933 4919 14 0.28 1 30916 733 0 14
sp_cancel_supplier_order 334 334 0 0.00 8 843050 95426 0 0
sp_cancel_write_off 8248 8248 0 0.00 1 28303 139 0 0
sp_client_order 18699 18699 0 0.00 3 26955 371 0 0
sp_customer_reserve 428444 428444 0 0.00 0 77504 223 0 0
sp_fill_shopping_cart 28563 28563 0 0.00 1 14964 36 0 0
sp_fill_shopping_cart_clo_res 428434 428434 0 0.00 0 22612 15 0 0
sp_get_clo_for_invoice 4483 4483 0 0.00 0 32349 287 0 0
sp_kill_cost_storno 13602 13602 0 0.00 0 5814 58 0 0
sp_kill_qstorno_ret_qs2qd 877017 877017 0 0.00 0 30906 31 0 0
sp_kill_qty_storno 464612 464612 0 0.00 0 44925 69 0 0
sp_lock_selected_doc 18562 18562 0 0.00 0 8724 6 0 0
sp_make_cost_storno 24978 24978 0 0.00 0 27715 60 0 0
sp_multiply_rows_for_pdistr 24978 24978 0 0.00 0 11652 29 0 0
sp_multiply_rows_for_qdistr 18699 18699 0 0.00 0 15336 154 0 0
sp_pay_from_customer 6361 6361 0 0.00 4 12850 123 0 0
sp_pay_to_supplier 5279 5279 0 0.00 5 23103 132 0 0
sp_payment_common 11640 11640 0 0.00 2 4781 28 0 0
sp_qd_handle_on_cancel_clo 1630 1630 0 0.00 0 9752 346 0 0
sp_qd_handle_on_invoice_upd_sts 8866 8866 0 0.00 0 44923 353 0 0
sp_qd_handle_on_reserve_upd_sts 8857 8857 0 0.00 0 24521 71 0 0
sp_reserve_write_off 8857 8857 0 0.00 6 27733 199 0 0
sp_supplier_invoice 4940 4940 0 0.00 6 88641 3502 0 0
sp_supplier_order 4925 4925 0 0.00 6 31665 1332 0 0
srv_aggregate_perf_data 93 93 0 0.00 1262 319808 20595 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 1261 122846 34716 0 0
srv_find_qd_qs_mism 889200 889200 0 0.00 0 22023 7 0 0
srv_make_invnt_saldo 500 500 0 0.00 52 50304 1246 0 0
srv_make_money_saldo 715 715 0 0.00 1 5107 41 0 0
srv_recalc_idx_stat 3 3 0 0.00 229001 295828 254137 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4497 4497 0 0.00 0 14557 212 0 0
t$perf-norm:sp_cancel_adding_invoice 341 341 0 0.00 0 7134 101 0 0
t$perf-norm:sp_cancel_client_order 1630 1630 0 0.00 0 2455 18 0 0
t$perf-norm:sp_cancel_customer_reserve 666 666 0 0.00 0 2109 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 605 605 0 0.00 0 786 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 364 364 0 0.00 0 208 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 2303 18 0 0
t$perf-norm:sp_cancel_supplier_order 334 334 0 0.00 0 27036 1718 0 0
t$perf-norm:sp_cancel_write_off 900 900 0 0.00 0 564 3 0 0
t$perf-norm:sp_client_order 18699 18699 0 0.00 0 9119 19 0 0
t$perf-norm:sp_customer_reserve 931 931 0 0.00 0 2891 9 0 0
t$perf-norm:sp_pay_from_customer 6361 6361 0 0.00 0 4436 9 0 0
t$perf-norm:sp_pay_to_supplier 5279 5279 0 0.00 0 4229 10 0 0
t$perf-norm:sp_reserve_write_off 8857 8857 0 0.00 0 6232 11 0 0
t$perf-norm:sp_supplier_invoice 4940 4940 0 0.00 0 4451 19 0 0
t$perf-norm:sp_supplier_order 4925 4925 0 0.00 0 7361 19 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 2640 37 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 37 1 0 0
t$perf-norm:srv_make_invnt_saldo 500 500 0 0.00 0 1148 34 0 0
t$perf-norm:srv_make_money_saldo 715 715 0 0.00 0 4147 38 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 5 0 0
v_add_invoice_to_stock 9244 8962 282 3.05 0 5428 18 0 282
v_all_customers 34418 34418 0 0.00 0 71 1 0 0
v_all_suppliers 27752 27752 0 0.00 0 56 1 0 0
v_all_wares 37396 37396 0 0.00 0 57 1 0 0
v_cancel_adding_invoice 682 682 0 0.00 0 3101 18 0 0
v_cancel_client_order 3260 3260 0 0.00 0 2701 4 0 0
v_cancel_customer_prepayment 1210 1210 0 0.00 0 8706 15 0 0
v_cancel_customer_reserve 1332 1332 0 0.00 0 6615 12 0 0
v_cancel_payment_to_supplier 728 728 0 0.00 0 1081 7 0 0
v_cancel_supplier_invoice 798 770 28 3.50 0 1005 14 0 28
v_cancel_supplier_order 668 668 0 0.00 0 2769 11 0 0
v_cancel_write_off 1800 1800 0 0.00 0 2732 14 0 0
v_max_id_clo_ord 4925 4925 0 0.00 0 557 2 0 0
v_max_id_clo_res 931 931 0 0.00 0 1955 16 0 0
v_max_id_ord_sup 4939 4939 0 0.00 0 4227 5 0 0
v_max_non_paid_invoice 1267 1267 0 0.00 0 470 3 0 0
v_max_non_paid_realizn 3174 3174 0 0.00 0 3520 7 0 0
v_min_id_clo_ord 4925 4925 0 0.00 0 7308 13 0 0
v_min_id_clo_res 931 931 0 0.00 0 2153 11 0 0
v_min_id_ord_sup 4939 4939 0 0.00 0 5937 6 0 0
v_min_non_paid_invoice 5279 5279 0 0.00 0 3863 15 0 0
v_min_non_paid_realizn 6361 6361 0 0.00 0 4047 21 0 0
v_our_firm 9352 9352 0 0.00 0 19 1 0 0
v_reserve_write_off 17712 17712 0 0.00 0 9159 6 0 0
x_lock_depdocs_on_canc_invoice 8919 8919 0 0.00 0 12140 146 0 0
x_lock_depdocs_on_canc_sup_ord 334 334 0 0.00 0 12933 388 0 0
x_make_qstorno_1000_1200 4925 4925 0 0.00 1 28908 1234 0 0
x_make_qstorno_1200_2000 4940 4940 0 0.00 3 88437 3385 0 0
x_make_qstorno_2100_3300 428443 428443 0 0.00 0 77503 205 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-03-2024 16:10:47 to 12-03-2024 16:10:51.

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
14:09:48 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:49 34555 8192000000 9903659552 10217480192 982280448 10.706 100 85 170 0 1011503024 6544912 22677664
14:12:28 10906 8192000000 9952730768 10274365440 1030433520 11.173 100 85 170 0 1060861104 8553840 21873744
14:13:45 12190 8192000000 9983723648 10318368768 1068437200 11.537 100 86 172 1 1099877888 10037872 21402816
14:15:00 12555 8192000000 10022337008 10369388544 1107270336 11.907 100 75 150 0 1135501072 10185344 18045392
14:16:20 6443 8192000000 10069428480 10426568704 1155748112 12.363 100 81 162 1 1186758912 12745648 18265152
14:17:31 3386 8192000000 10113636832 10477096960 1197533456 12.753 100 87 174 0 1230333552 12529520 20270576
14:18:37 2754 8192000000 10144319472 10515423232 1232223712 13.075 100 83 164 0 1264415904 13624480 18567712
14:19:42 4821 8192000000 10177529968 10555428864 1259645264 13.327 100 89 177 0 1292931328 14294336 18991728
14:20:49 933 8192000000 10205454480 10586025984 1287626624 13.583 100 93 186 0 1321127472 13628240 19872608
14:21:52 7630 8192000000 10211123552 10603601920 1302050384 13.714 100 71 143 2 1327008320 9783776 15174160
14:23:00 3774 8192000000 10215278000 10614616064 1311014208 13.795 100 44 88 1 1328306176 6988128 10303840
14:24:05 6935 8192000000 10214167408 10628374528 1324576096 13.918 100 31 59 0 1341630912 10688144 6366672
14:25:13 6894 8192000000 10216355008 10633252864 1331016960 13.976 100 22 43 2 1343254096 5067280 7169856
14:26:25 40438 8192000000 10232401328 10649751552 1339081568 14.049 100 37 75 0 1354722912 7222736 8418608
14:28:07 9980 8192000000 10237155040 10661138432 1347673184 14.127 100 30 60 0 1361786864 7456640 6657040
14:29:17 7050 8192000000 10222100576 10642632704 1322200880 13.897 99 16 32 0 1330725248 5135568 3388800
14:30:31 6214 8192000000 10249484336 10668638208 1355120704 14.194 100 35 68 1 1370098080 7364128 7613248
14:31:41 104404 8192000000 10254184320 10685251584 1361234224 14.248 100 34 68 0 1379754864 10860976 7659664
14:34:33 3849 8192000000 10249390048 10661941248 1335364416 14.016 99 47 90 0 1356540928 11043648 10132864
14:35:41 12302 8192000000 10245836096 10658123776 1332339072 13.988 100 47 92 1 1357360144 14674880 10346192
14:36:57 9307 8192000000 10247502784 10654515200 1314942304 13.831 98 50 100 1 1338873424 13412016 10519104
14:38:10 7412 8192000000 10209655712 10611597312 1287782384 13.584 98 50 100 0 1317263504 18054720 11426400
14:39:22 13119 8192000000 10227317168 10620620800 1303449456 13.727 100 68 132 2 1340502384 22308240 14744688
14:40:41 11603 8192000000 10171171840 10562224128 1233076288 13.082 96 46 92 0 1264281088 20286464 10918336
14:41:56 3218 8192000000 10232068016 10626674688 1304210320 13.734 100 78 151 2 1339010272 17549024 17250928
14:43:03 1632 8192000000 10227217616 10617024512 1299021296 13.686 100 71 138 2 1335681616 20752928 15907392
14:44:09 1607 8192000000 10262172208 10659737600 1326715232 13.937 100 76 148 0 1363277296 20069072 16492992
14:45:16 6084 8192000000 10290618672 10689241088 1347215104 14.122 100 77 154 0 1390515792 24441952 18858736
14:46:29 2761 8192000000 10297565840 10697486336 1362632272 14.261 100 75 149 2 1400232096 20198480 17401344
14:47:45 1383 8192000000 10307037040 10716909568 1372402160 14.349 100 68 132 2 1415240080 26390544 16447376
14:48:56 2763 8192000000 10314989200 10729439232 1386288304 14.473 100 69 134 0 1427933968 25908288 15737376
14:50:08 3993 8192000000 10330129920 10744414208 1393459408 14.537 100 70 138 1 1434401808 25097920 15844480
14:51:18 9823 8192000000 10315479072 10730754048 1383071840 14.444 99 67 133 1 1423980304 25311568 15596896
14:52:44 12681 8192000000 10329236896 10758848512 1399199040 14.588 100 42 84 0 1442206752 33016080 9991632
14:54:01 27700 8192000000 10327493056 10768982016 1406146464 14.650 100 21 42 1 1437627808 26326000 5155344
14:55:31 13426 8192000000 10332049344 10770776064 1407193680 14.659 100 23 46 0 1439397136 25721472 6481984
14:56:55 12355 8192000000 10336667936 10775715840 1407774352 14.664 100 30 58 0 1444567968 29141600 7652016
14:58:17 20078 8192000000 10321888880 10768302080 1402505248 14.617 100 13 26 0 1432364320 26069680 3789392
14:59:39 34841 8192000000 10322389184 10755010560 1400470384 14.599 100 31 62 1 1416324208 8796192 7057632
15:01:20 12828 8192000000 10329878752 10763505664 1406214368 14.650 100 55 109 0 1429130576 9999376 12916832
15:02:34 105421 8192000000 10314050832 10770288640 1414947520 14.728 100 33 66 0 1438073824 15782032 7344272
15:05:24 61319 8192000000 10313133296 10760298496 1395106992 14.551 99 29 58 0 1412392048 9773216 7511840
15:07:37 1259 8192000000 10319154336 10759385088 1402960720 14.621 100 56 110 0 1428790224 12343792 13485712
15:08:40 17887 8192000000 10336012672 10771046400 1408880496 14.674 100 39 76 0 1435661584 17531840 9249248
15:09:59 17947 8192000000 10330425632 10773008384 1410422224 14.688 100 39 77 0 1439031840 18909472 9700144
15:11:26 77744 8192000000 10291513648 10747465728 1358491568 14.224 97 14 28 0 1374670960 12870320 3309072
15:13:45 17258 8192000000 10306366736 10748686336 1377396448 14.393 100 37 75 1 1412105232 25733168 8975616
15:15:03 46492 8192000000 10297304880 10749214720 1371721424 14.342 99 15 31 0 1397128240 21474224 3932592
15:16:50 46666 8192000000 10296712256 10757173248 1370340096 14.330 99 16 32 0 1396766784 22410112 4016576
15:18:44 57281 8192000000 10281351792 10737004544 1338817680 14.047 96 8 16 0 1354321856 13716256 1787920
15:20:52 22915 8192000000 10294946960 10733285376 1379053600 14.408 100 56 112 0 1403244688 11620768 12570320
15:22:15 14300 8192000000 10290424336 10724102144 1355222048 14.194 99 39 78 0 1378436384 14137696 9076640
15:23:30 84254 8192000000 10257937104 10705367040 1300915632 13.704 95 11 22 0 1324944336 21628080 2400624
15:26:19 29536 8192000000 10275832640 10705231872 1335223360 14.014 98 30 60 1 1352403440 10538400 6641680
15:27:55 88150 8192000000 10242702096 10677633024 1297744432 13.675 96 40 78 2 1315705088 8455696 9504960
15:30:34 49809 8192000000 10252222736 10697064448 1337246416 14.033 99 26 51 0 1354132464 11290560 5595488
15:32:27 27770 8192000000 10270043104 10705936384 1354696128 14.190 100 43 86 0 1375982368 11625248 9660992
15:33:57 50075 8192000000 10245739056 10698313728 1332466704 13.989 98 10 20 0 1344797424 10067904 2262816
15:35:53 22694 8192000000 10256184256 10706362368 1340978320 14.066 98 18 36 0 1358205616 13431920 3795376
15:37:17 40496 8192000000 10252479904 10705530880 1338797296 14.047 98 11 22 0 1357150176 15525200 2827680
15:39:00 38683 8192000000 10269753680 10716540928 1359486512 14.233 99 13 25 0 1372760656 10389536 2884608
15:41:09 54336 8192000000 10304005520 10753097728 1389084192 14.498 99 34 68 0 1407226768 9846032 8296544
15:43:37 48478 8192000000 10301554528 10753126400 1374019552 14.363 98 17 35 0 1387828496 10065856 3743088
15:45:27 52748 8192000000 10321456496 10770407424 1395686528 14.557 99 24 46 0 1414128704 13398144 5044032
15:47:26 79836 8192000000 10323354432 10781339648 1401182208 14.606 99 11 22 0 1425934480 22428992 2323280
15:49:49 78514 8192000000 10330711792 10776113152 1396305328 14.562 99 26 52 0 1415523472 13635600 5582544
15:52:14 122846 8192000000 10315206304 10760843264 1372940544 14.353 98 24 48 0 1390579280 12466000 5172736
15:55:29 32989 8192000000 10288057472 10731507712 1346556944 14.116 97 32 64 0 1360886272 7194848 7134480
15:57:26 36907 8192000000 10273892688 10733301760 1362776400 14.262 98 39 78 2 1379122960 7204704 9141856
15:59:07 45856 8192000000 10275514144 10735378432 1373313936 14.357 99 14 28 0 1384843104 8265728 3263440
16:00:53 39225 8192000000 10280769472 10736140288 1368026944 14.309 99 17 34 0 1380047776 7113920 4906912
16:02:34 89658 8192000000 10287692736 10753232896 1362630032 14.261 98 15 30 0 1385265376 19108736 3526608
16:05:05 57461 8192000000 10265940224 10717347840 1315978624 13.840 95 22 43 0 1331203856 10399616 4825616
16:07:53 29529 8192000000 10266054272 10707439616 1331541728 13.981 97 25 50 0 1347742576 10748352 5452496
16:09:25 26446 8192000000 8964848016 9142263808 132013408 1.585 10 2 4 0 136455664 4028976 413280

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 12-03-2024 16:10:53 to 12-03-2024 16:11:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-03-2024 16:11:08 to 12-03-2024 16:11:10.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Mar 12 16:11:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        95247 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    182500 
    Oldest active        182501 
    Oldest snapshot        182501 
    Next transaction    182502 
    Sequence number        0 
    Next attachment ID    729 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.23, total records: 7840882 
    Average version length: 48.16, total versions: 109560, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87032 
    Data pages: 87032, average fill: 72% 
    Primary pages: 87032, secondary pages: 0, swept pages: 14625 
    Empty pages: 7, full pages: 70203 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 23 
    40 - 59% = 736 
    60 - 79% = 86241 
    80 - 99% = 24 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23586, nodes: 7840882 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1775865, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 394 
        20 - 39% = 1628 
        40 - 59% = 4428 
        60 - 79% = 2290 
        80 - 99% = 14846 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13651, nodes: 7840882 
    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: 1597224, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1505 
        40 - 59% = 2187 
        60 - 79% = 1061 
        80 - 99% = 8898 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8453, nodes: 7840882 
    Average node length: 6.64, total dup: 5835808, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1590423, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 869 
        40 - 59% = 1523 
        60 - 79% = 872 
        80 - 99% = 5041 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.06, total records: 2295342 
    Average version length: 34.65, total versions: 111758, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28544 
    Data pages: 28544, average fill: 75% 
    Primary pages: 28539, secondary pages: 5, swept pages: 7983 
    Empty pages: 9, full pages: 23026 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 50 
    40 - 59% = 835 
    60 - 79% = 26463 
    80 - 99% = 1177 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4654, nodes: 2295342 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 714506, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 932 
        40 - 59% = 906 
        60 - 79% = 693 
        80 - 99% = 2123 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2566, nodes: 2298308 
    Average node length: 4.97, total dup: 2297409, max dup: 19818 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1275835, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 243 
        40 - 59% = 1563 
        60 - 79% = 579 
        80 - 99% = 179 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2060, nodes: 2295342 
    Average node length: 4.97, total dup: 2295292, max dup: 130576 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073768, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 21 
        40 - 59% = 1158 
        60 - 79% = 49 
        80 - 99% = 825 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4480, nodes: 2295342 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 714506, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 591 
        40 - 59% = 694 
        60 - 79% = 772 
        80 - 99% = 2284 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 81.84, total records: 400 
    Average version length: 23.07, total versions: 245138, max versions: 635 
    Average fragment length: 2.00, total fragments: 80, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1528 
    Data pages: 1400, average fill: 88% 
    Primary pages: 9, secondary pages: 1391, swept pages: 0 
    Empty pages: 2, full pages: 1397 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1395 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 7.75, total records: 76148 
    Average version length: 68.29, total versions: 67507, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 2856 
    Data pages: 2208, average fill: 44% 
    Primary pages: 2207, secondary pages: 1, swept pages: 0 
    Empty pages: 669, full pages: 708 
    Fill distribution: 
     0 - 19% = 819 
    20 - 39% = 217 
    40 - 59% = 300 
    60 - 79% = 298 
    80 - 99% = 574 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709335, depth: 3, leaf buckets: 360, nodes: 76148 
    Average node length: 13.20, total dup: 4917, max dup: 1 
    Average key length: 10.78, compression ratio: 2.51 
    Average prefix length: 19.15, average data length: 7.85 
    Clustering factor: 55606, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 296 
        40 - 59% = 57 
        60 - 79% = 5 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 18304, max versions: 1010 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 81% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 64 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 6.62, total records: 2218 
    Average version length: 43.65, total versions: 1882, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 8.77 
    Pointer pages: 1, data page slots: 40 
    Data pages: 28, average fill: 74% 
    Primary pages: 27, secondary pages: 1, swept pages: 2 
    Empty pages: 3, full pages: 21 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91242, depth: 2, leaf buckets: 3, nodes: 2218 
    Average node length: 4.27, total dup: 2120, max dup: 246 
    Average key length: 2.48, compression ratio: 7.67 
    Average prefix length: 18.57, average data length: 0.43 
    Clustering factor: 1099, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 76 
    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: 53% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 76 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.61, total records: 802095 
    Average version length: 25.27, total versions: 88083, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7952, average fill: 71% 
    Primary pages: 7933, secondary pages: 19, swept pages: 1045 
    Empty pages: 54, full pages: 7413 
    Fill distribution: 
     0 - 19% = 106 
    20 - 39% = 63 
    40 - 59% = 72 
    60 - 79% = 7311 
    80 - 99% = 400 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 870, nodes: 802095 
    Average node length: 4.87, total dup: 802046, max dup: 145276 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89113, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 118 
        40 - 59% = 476 
        60 - 79% = 201 
        80 - 99% = 74 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 914, nodes: 802095 
    Average node length: 5.88, total dup: 714092, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158984, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 106 
        40 - 59% = 360 
        60 - 79% = 137 
        80 - 99% = 309 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 963, nodes: 802095 
    Average node length: 5.88, total dup: 714092, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161016, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 196 
        40 - 59% = 342 
        60 - 79% = 118 
        80 - 99% = 307 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1138, nodes: 802095 
    Average node length: 5.96, total dup: 714092, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153984, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 246 
        40 - 59% = 614 
        60 - 79% = 189 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.87, total records: 5479 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.78, total fragments: 69, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 71, secondary pages: 17, swept pages: 50 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5479 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.05 
    Average prefix length: 34.49, average data length: 1.55 
    Clustering factor: 5211, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5479 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 154, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.11, total records: 83376 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 808 
    Data pages: 808, average fill: 71% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 802 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 802 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34862, depth: 2, leaf buckets: 109, nodes: 83376 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3756, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 104 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.10, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 120.37, total records: 204206 
    Average version length: 154.85, total versions: 41454, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.09 
    Pointer pages: 6, data page slots: 5552 
    Data pages: 4960, average fill: 87% 
    Primary pages: 4959, secondary pages: 1, swept pages: 4 
    Empty pages: 83, full pages: 4853 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4851 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.56, total records: 182097 
    Average version length: 152.34, total versions: 6841, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 7, data page slots: 5960 
    Data pages: 4448, average fill: 85% 
    Primary pages: 4448, secondary pages: 0, swept pages: 5 
    Empty pages: 109, full pages: 4305 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 9 
    40 - 59% = 11 
    60 - 79% = 11 
    80 - 99% = 4304 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 138.17, total records: 181683 
    Average version length: 154.13, total versions: 15443, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.28 
    Pointer pages: 7, data page slots: 6496 
    Data pages: 4456, average fill: 85% 
    Primary pages: 4456, secondary pages: 0, swept pages: 2 
    Empty pages: 128, full pages: 4297 
    Fill distribution: 
     0 - 19% = 129 
    20 - 39% = 13 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 4295 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 172071 
    Average version length: 152.32, total versions: 5205, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 5656 
    Data pages: 4168, average fill: 85% 
    Primary pages: 4168, secondary pages: 0, swept pages: 4 
    Empty pages: 76, full pages: 4059 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 11 
    80 - 99% = 4059 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 144.60, total records: 162211 
    Average version length: 152.83, total versions: 6957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 7, data page slots: 6456 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3918, secondary pages: 2, swept pages: 3 
    Empty pages: 64, full pages: 3836 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3835 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 146.54, total records: 172680 
    Average version length: 152.54, total versions: 5181, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 5248 
    Data pages: 4224, average fill: 84% 
    Primary pages: 4224, secondary pages: 0, swept pages: 1 
    Empty pages: 111, full pages: 4076 
    Fill distribution: 
     0 - 19% = 119 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 12 
    80 - 99% = 4076 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 143.15, total records: 163813 
    Average version length: 153.21, total versions: 8368, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 6, data page slots: 5152 
    Data pages: 3968, average fill: 85% 
    Primary pages: 3968, secondary pages: 0, swept pages: 5 
    Empty pages: 75, full pages: 3864 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 6 
    40 - 59% = 12 
    60 - 79% = 10 
    80 - 99% = 3864 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 149.79, total records: 183078 
    Average version length: 149.40, total versions: 1750, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 8, data page slots: 5120 
    Data pages: 4408, average fill: 86% 
    Primary pages: 4407, secondary pages: 1, swept pages: 4 
    Empty pages: 55, full pages: 4333 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4332 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.13, total records: 180382 
    Average version length: 150.09, total versions: 2574, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 5016 
    Data pages: 4312, average fill: 86% 
    Primary pages: 4312, secondary pages: 0, swept pages: 3 
    Empty pages: 26, full pages: 4270 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4269 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.40, total records: 175956 
    Average version length: 151.56, total versions: 3092, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4640 
    Data pages: 4224, average fill: 86% 
    Primary pages: 4224, secondary pages: 0, swept pages: 1 
    Empty pages: 46, full pages: 4163 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4163 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.44, total records: 2138476 
    Average version length: 52.89, total versions: 53364, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25592 
    Data pages: 25592, average fill: 72% 
    Primary pages: 25592, secondary pages: 0, swept pages: 9246 
    Empty pages: 237, full pages: 22243 
    Fill distribution: 
     0 - 19% = 443 
    20 - 39% = 325 
    40 - 59% = 841 
    60 - 79% = 23499 
    80 - 99% = 484 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2635, nodes: 2138476 
    Average node length: 5.44, total dup: 1996835, max dup: 1406 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185089, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 263 
        40 - 59% = 1790 
        60 - 79% = 299 
        80 - 99% = 280 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2138476 
    Average node length: 5.69, total dup: 1919787, max dup: 67 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 382263, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2300 
        60 - 79% = 427 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2198, nodes: 2138476 
    Average node length: 4.96, total dup: 2138376, max dup: 28756 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 182535, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 206 
        40 - 59% = 1195 
        60 - 79% = 410 
        80 - 99% = 386 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.55, total records: 159493 
    Average version length: 69.18, total versions: 75311, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.45 
    Pointer pages: 3, data page slots: 4456 
    Data pages: 3384, average fill: 55% 
    Primary pages: 3384, secondary pages: 0, swept pages: 580 
    Empty pages: 817, full pages: 2096 
    Fill distribution: 
     0 - 19% = 1054 
    20 - 39% = 77 
    40 - 59% = 68 
    60 - 79% = 785 
    80 - 99% = 1400 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106174, depth: 3, leaf buckets: 236, nodes: 159493 
    Average node length: 6.43, total dup: 139006, max dup: 25 
    Average key length: 3.91, compression ratio: 10.75 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 27283, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 44 
        40 - 59% = 110 
        60 - 79% = 59 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.85, total records: 7017715 
    Average version length: 68.80, total versions: 521238, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 62, data page slots: 99712 
    Data pages: 99712, average fill: 75% 
    Primary pages: 99712, secondary pages: 0, swept pages: 16379 
    Empty pages: 15, full pages: 85045 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 761 
    40 - 59% = 4634 
    60 - 79% = 83194 
    80 - 99% = 11029 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10603, nodes: 7017715 
    Average node length: 6.51, total dup: 6071479, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1551081, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1666 
        40 - 59% = 5736 
        60 - 79% = 2655 
        80 - 99% = 533 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8216, nodes: 7017715 
    Average node length: 5.40, total dup: 6737315, max dup: 160 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1349409, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 996 
        40 - 59% = 4277 
        60 - 79% = 1786 
        80 - 99% = 1142 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8290, nodes: 7017715 
    Average node length: 5.40, total dup: 6737315, max dup: 160 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1351773, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1108 
        40 - 59% = 4252 
        60 - 79% = 1785 
        80 - 99% = 1141 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.58, total records: 11985421 
    Average version length: 68.75, total versions: 413668, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 101, data page slots: 164728 
    Data pages: 164728, average fill: 77% 
    Primary pages: 164728, secondary pages: 0, swept pages: 62284 
    Empty pages: 4, full pages: 162155 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 172 
    40 - 59% = 824 
    60 - 79% = 153917 
    80 - 99% = 9787 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18230, nodes: 11985421 
    Average node length: 6.57, total dup: 10448628, max dup: 69 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2369308, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 2362 
        40 - 59% = 10659 
        60 - 79% = 4237 
        80 - 99% = 930 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 37.18, total records: 1780814 
    Average version length: 69.15, total versions: 823551, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.39 
    Pointer pages: 26, data page slots: 41848 
    Data pages: 29039, average fill: 71% 
    Primary pages: 29039, secondary pages: 0, swept pages: 4402 
    Empty pages: 2026, full pages: 22273 
    Fill distribution: 
     0 - 19% = 3271 
    20 - 39% = 1399 
    40 - 59% = 1245 
    60 - 79% = 9414 
    80 - 99% = 13710 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2205, nodes: 1780814 
    Average node length: 5.51, total dup: 1708778, max dup: 99 
    Average key length: 2.55, compression ratio: 16.47 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 121795, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 340 
        40 - 59% = 1071 
        60 - 79% = 574 
        80 - 99% = 210 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.69, total records: 1211428 
    Average version length: 69.14, total versions: 550027, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.34 
    Pointer pages: 19, data page slots: 30800 
    Data pages: 27408, average fill: 51% 
    Primary pages: 27408, secondary pages: 0, swept pages: 5546 
    Empty pages: 5382, full pages: 14423 
    Fill distribution: 
     0 - 19% = 8950 
    20 - 39% = 1687 
    40 - 59% = 969 
    60 - 79% = 6339 
    80 - 99% = 9463 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1634, nodes: 1211428 
    Average node length: 5.75, total dup: 1134507, max dup: 133 
    Average key length: 2.82, compression ratio: 14.91 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 160225, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 335 
        40 - 59% = 782 
        60 - 79% = 408 
        80 - 99% = 106 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.83, total records: 9569278 
    Average version length: 68.96, total versions: 564839, 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: 89, data page slots: 144560 
    Data pages: 144528, average fill: 71% 
    Primary pages: 144528, secondary pages: 0, swept pages: 43040 
    Empty pages: 260, full pages: 92530 
    Fill distribution: 
     0 - 19% = 897 
    20 - 39% = 4109 
    40 - 59% = 18654 
    60 - 79% = 110639 
    80 - 99% = 10229 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13538, nodes: 9569278 
    Average node length: 6.68, total dup: 7941728, max dup: 27 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2099354, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 919 
        40 - 59% = 6490 
        60 - 79% = 5223 
        80 - 99% = 905 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21200365 
    Average version length: 82.94, total versions: 16950, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319472 
    Data pages: 319472, average fill: 81% 
    Primary pages: 319472, secondary pages: 0, swept pages: 12524 
    Empty pages: 13, full pages: 318925 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 23 
    40 - 59% = 71 
    60 - 79% = 27322 
    80 - 99% = 292032 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19254, nodes: 21200365 
    Average node length: 5.72, total dup: 20718234, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3289542, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 7798 
        60 - 79% = 569 
        80 - 99% = 10882 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17246, nodes: 21200365 
    Average node length: 6.31, total dup: 18632072, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917546, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 846 
        60 - 79% = 287 
        80 - 99% = 16109 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21047, nodes: 21200365 
    Average node length: 6.35, total dup: 18549871, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3584309, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8065 
        60 - 79% = 653 
        80 - 99% = 12324 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16169, nodes: 21200365 
    Average node length: 5.56, total dup: 21200265, max dup: 228542 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946195, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2979 
        60 - 79% = 381 
        80 - 99% = 12800 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.07, total records: 9985661 
    Average version length: 82.61, total versions: 527188, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 106, data page slots: 172792 
    Data pages: 172744, average fill: 71% 
    Primary pages: 172744, secondary pages: 0, swept pages: 66909 
    Empty pages: 409, full pages: 103630 
    Fill distribution: 
     0 - 19% = 1165 
    20 - 39% = 5546 
    40 - 59% = 24963 
    60 - 79% = 72067 
    80 - 99% = 69003 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11444, nodes: 9985661 
    Average node length: 5.37, total dup: 9672865, max dup: 225 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2209375, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 75 
        40 - 59% = 7472 
        60 - 79% = 3722 
        80 - 99% = 173 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13907, nodes: 9985661 
    Average node length: 6.24, total dup: 8282369, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1545313, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 4054 
        40 - 59% = 4492 
        60 - 79% = 2721 
        80 - 99% = 2503 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12781, nodes: 9985661 
    Average node length: 5.99, total dup: 8673053, max dup: 51 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2404398, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 79 
        40 - 59% = 8402 
        60 - 79% = 4094 
        80 - 99% = 204 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10378, nodes: 9985661 
    Average node length: 5.14, total dup: 9985561, max dup: 152408 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1581346, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1134 
        40 - 59% = 5342 
        60 - 79% = 1684 
        80 - 99% = 2181 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.39, total records: 11605779 
    Average version length: 82.55, total versions: 411263, 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: 120, data page slots: 194960 
    Data pages: 193616, average fill: 74% 
    Primary pages: 193616, secondary pages: 0, swept pages: 69105 
    Empty pages: 2464, full pages: 146705 
    Fill distribution: 
     0 - 19% = 4322 
    20 - 39% = 6723 
    40 - 59% = 17171 
    60 - 79% = 44096 
    80 - 99% = 121304 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13159, nodes: 11605779 
    Average node length: 5.31, total dup: 11495125, max dup: 641 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2422281, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 8346 
        60 - 79% = 4426 
        80 - 99% = 285 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10699, nodes: 11605779 
    Average node length: 5.51, total dup: 11100745, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 733694, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 853 
        40 - 59% = 2582 
        60 - 79% = 1907 
        80 - 99% = 5206 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15041, nodes: 11605779 
    Average node length: 6.04, total dup: 10131833, max dup: 80 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2438854, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 122 
        40 - 59% = 9713 
        60 - 79% = 4869 
        80 - 99% = 337 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11056, nodes: 11605779 
    Average node length: 5.24, total dup: 11605679, max dup: 198445 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 721890, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 786 
        40 - 59% = 5073 
        60 - 79% = 1492 
        80 - 99% = 3617 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.18, total records: 10134019 
    Average version length: 82.91, total versions: 558167, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 108, data page slots: 176048 
    Data pages: 176000, average fill: 71% 
    Primary pages: 176000, secondary pages: 0, swept pages: 69384 
    Empty pages: 363, full pages: 103250 
    Fill distribution: 
     0 - 19% = 1127 
    20 - 39% = 5407 
    40 - 59% = 24763 
    60 - 79% = 78689 
    80 - 99% = 66014 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12196, nodes: 10134019 
    Average node length: 5.19, total dup: 10104779, max dup: 1507 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2029720, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1452 
        40 - 59% = 8171 
        60 - 79% = 1914 
        80 - 99% = 631 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14045, nodes: 10134019 
    Average node length: 6.26, total dup: 8404330, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1516737, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 180 
        20 - 39% = 4012 
        40 - 59% = 4444 
        60 - 79% = 2733 
        80 - 99% = 2676 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12820, nodes: 10134019 
    Average node length: 5.44, total dup: 9683516, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2166251, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1411 
        40 - 59% = 8981 
        60 - 79% = 1782 
        80 - 99% = 621 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10548, nodes: 10134019 
    Average node length: 5.16, total dup: 10133919, max dup: 155114 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1611329, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1200 
        40 - 59% = 5351 
        60 - 79% = 1746 
        80 - 99% = 2216 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.20, total records: 579702 
    Average version length: 68.80, total versions: 8289, 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: 8048 
    Data pages: 8048, average fill: 75% 
    Primary pages: 8048, secondary pages: 0, swept pages: 3579 
    Empty pages: 1, full pages: 6842 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 22 
    40 - 59% = 249 
    60 - 79% = 7630 
    80 - 99% = 145 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 33119, depth: 3, leaf buckets: 744, nodes: 579702 
    Average node length: 5.95, total dup: 493670, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100890, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 528 
        60 - 79% = 101 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 24000, depth: 3, leaf buckets: 767, nodes: 579702 
    Average node length: 6.15, total dup: 475395, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100935, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 539 
        60 - 79% = 104 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 583, nodes: 579702 
    Average node length: 4.86, total dup: 579602, max dup: 9962 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89590, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 338 
        60 - 79% = 104 
        80 - 99% = 105 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 12 16:11:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7840882 109560 1 0.0000 0.0000
DOC_LIST 2295342 111758 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 245138 635 61200.0000 0.0000
INVNT_TURNOVER_LOG 76148 67507 1 0.0000 0.0000
MONEY_SALDO 49 18304 1010 37300.0000 0.0000
MONEY_TURNOVER_LOG 2218 1882 1 0.0000 0.0000
PDISTR 802095 88083 4 0.0000 0.0000
PERF_SPLIT_0 204206 41454 1 0.0000 0.0000
PERF_SPLIT_1 182097 6841 1 0.0000 0.0000
PERF_SPLIT_2 181683 15443 1 0.0000 0.0000
PERF_SPLIT_3 172071 5205 1 0.0000 0.0000
PERF_SPLIT_4 162211 6957 1 0.0000 0.0000
PERF_SPLIT_5 172680 5181 1 0.0000 0.0000
PERF_SPLIT_6 163813 8368 1 0.0000 0.0000
PERF_SPLIT_7 183078 1750 1 0.0000 0.0000
PERF_SPLIT_8 180382 2574 1 0.0000 0.0000
PERF_SPLIT_9 175956 3092 1 0.0000 0.0000
PSTORNED 2138476 53364 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 159493 75311 1 0.0000 0.0000
XQD_1000_3300 7017715 521238 1 0.0000 0.0000
XQD_1200_2000 11985421 413668 1 0.0000 0.0000
XQD_2000_3300 1780814 823551 1 0.0000 0.0000
XQD_2100_3300 1211428 550027 1 0.0000 0.0000
XQD_3300_3400 9569278 564839 1 0.0000 0.0000
XQS_1000_1200 21200365 16950 1 0.0000 0.0000
XQS_1000_3300 9985661 527188 1 0.0000 0.0000
XQS_1200_2000 11605779 411263 1 0.0000 0.0000
XQS_2100_3300 10134019 558167 1 0.0000 0.0000
XQS_3300_3400 579702 8289 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 ---
:218: 
:219: mscs-test-161.budzdorov.ru    Tue Mar 12 16:09:57 2024
:220:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:221: 
--- end of diff output ---

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

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