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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-04 22:09:50
DTS_END                         2024-04-04 22:09:49.9980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_MAKE_INVNT_SALDO(40:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41848
TRN_ID                          181038
ATT_ID                          533
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: 9352.90 18959 935290
customer order: creation 187.40 349 18740
customer order: refuse 15.64 382 1564
order to supplier: creation 49.68 1206 4968
order to supplier: removal 3.53 104515 353
invoice (draft): creation 49.77 3073 4977
invoice (draft): removal 48.25 892 4825
invoice accept: apply 44.74 20382 4474
invoice accept: cancel 43.64 926 4364
customer reserve: creation 4341.58 192 434158
customer reserve: removal 4263.95 69 426395
realization accept: apply 89.54 186 8954
realization accept: cancel 74.23 135 7423
payment from customer: creation 63.94 103 6394
payment from customer: removal 6.05 89 605
payment to supplier: creation 53.43 120 5343
payment to supplier: removal 3.75 59 375
service: total inventory turnovers 5.43 994 543
service: total monetary turnovers 7.47 34 747
service: aggregate perf. data 0.85 22458 85
service: refresh index statistics 0.03 223024 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2024 22:10:38 to 04-04-2024 22:10:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5365
TEST_TIME 2 4628
TEST_TIME 3 4077
TEST_TIME 4 4242
TEST_TIME 5 4223
TEST_TIME 6 4515
TEST_TIME 7 4910
TEST_TIME 8 5181
TEST_TIME 9 5403
TEST_TIME 10 5244
TEST_TIME 11 5174
TEST_TIME 12 5355
TEST_TIME 13 5435
TEST_TIME 14 5392
TEST_TIME 15 5605
TEST_TIME 16 5731
TEST_TIME 17 5964
TEST_TIME 18 6151
TEST_TIME 19 6379
TEST_TIME 20 6825
TEST_TIME 21 6859
TEST_TIME 22 6859
TEST_TIME 23 6896
TEST_TIME 24 7180
TEST_TIME 25 7676
TEST_TIME 26 7766
TEST_TIME 27 7658
TEST_TIME 28 7539
TEST_TIME 29 8335
TEST_TIME 30 8977
TEST_TIME 31 9402
TEST_TIME 32 9292
TEST_TIME 33 9359
TEST_TIME 34 9622
TEST_TIME 35 9428
TEST_TIME 36 9357
TEST_TIME 37 9284
TEST_TIME 38 9132
TEST_TIME 39 9055
TEST_TIME 40 9079
TEST_TIME 41 9002
TEST_TIME 42 9064
TEST_TIME 43 9075
TEST_TIME 44 9047
TEST_TIME 45 8966
TEST_TIME 46 9031
TEST_TIME 47 8966
TEST_TIME 48 8812
TEST_TIME 49 8813
TEST_TIME 50 8819
TEST_TIME 51 8799
TEST_TIME 52 8789
TEST_TIME 53 8831
TEST_TIME 54 9133
TEST_TIME 55 9069
TEST_TIME 56 9063
TEST_TIME 57 9082
TEST_TIME 58 9194
TEST_TIME 59 9293
TEST_TIME 60 9327
TEST_TIME 61 9266
TEST_TIME 62 9265
TEST_TIME 63 9188
TEST_TIME 64 9119
TEST_TIME 65 9082
TEST_TIME 66 9067
TEST_TIME 67 8979
TEST_TIME 68 8976
TEST_TIME 69 8977
TEST_TIME 70 8983
TEST_TIME 71 9025
TEST_TIME 72 9025
TEST_TIME 73 9090
TEST_TIME 74 9176
TEST_TIME 75 9128
TEST_TIME 76 9157
TEST_TIME 77 9229
TEST_TIME 78 9262
TEST_TIME 79 9279
TEST_TIME 80 9288
TEST_TIME 81 9323
TEST_TIME 82 9364
TEST_TIME 83 9417
TEST_TIME 84 9369
TEST_TIME 85 9310
TEST_TIME 86 9339
TEST_TIME 87 9296
TEST_TIME 88 9292
TEST_TIME 89 9248
TEST_TIME 90 9190
TEST_TIME 91 9167
TEST_TIME 92 9163
TEST_TIME 93 9162
TEST_TIME 94 9192
TEST_TIME 95 9169
TEST_TIME 96 9250
TEST_TIME 97 9331
TEST_TIME 98 9325
TEST_TIME 99 9368
TEST_TIME 100 9361

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-04-2024 22:10:42 to 04-04-2024 22:10:45.

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 1332034 1332034 0 0.00 0 22080 7 0 0
doc_list_biud 1332033 1332033 0 0.00 0 39793 28 0 0
sp_add_invoice_to_stock 4556 4474 82 1.79 43 192739 20382 0 82
sp_cancel_adding_invoice 4364 4364 0 0.00 5 86615 927 0 0
sp_cancel_client_order 1564 1564 0 0.00 4 10147 382 0 0
sp_cancel_customer_reserve 426395 426395 0 0.00 0 29040 69 0 0
sp_cancel_pay_from_customer 605 605 0 0.00 3 7091 89 0 0
sp_cancel_pay_to_supplier 375 375 0 0.00 3 796 59 0 0
sp_cancel_supplier_invoice 4830 4825 5 0.10 2 39801 893 0 5
sp_cancel_supplier_order 353 353 0 0.00 8 1091076 104516 0 0
sp_cancel_write_off 7423 7423 0 0.00 1 8332 136 0 0
sp_client_order 18740 18740 0 0.00 3 29026 350 0 0
sp_customer_reserve 434158 434158 0 0.00 0 59087 193 0 0
sp_fill_shopping_cart 28681 28681 0 0.00 1 21722 35 0 0
sp_fill_shopping_cart_clo_res 434141 434141 0 0.00 0 12009 14 0 0
sp_get_clo_for_invoice 4456 4456 0 0.00 0 19814 285 0 0
sp_kill_cost_storno 12767 12767 0 0.00 0 8967 71 0 0
sp_kill_qstorno_ret_qs2qd 865391 865391 0 0.00 0 39790 37 0 0
sp_kill_qty_storno 458334 458334 0 0.00 0 39792 81 0 0
sp_lock_selected_doc 18568 18568 0 0.00 0 6622 4 0 0
sp_make_cost_storno 25147 25147 0 0.00 0 22068 51 0 0
sp_multiply_rows_for_pdistr 25147 25147 0 0.00 0 8985 29 0 0
sp_multiply_rows_for_qdistr 18740 18740 0 0.00 0 28433 161 0 0
sp_pay_from_customer 6394 6394 0 0.00 3 10836 104 0 0
sp_pay_to_supplier 5343 5343 0 0.00 4 9023 121 0 0
sp_payment_common 11737 11737 0 0.00 1 5829 24 0 0
sp_qd_handle_on_cancel_clo 1564 1564 0 0.00 0 10141 359 0 0
sp_qd_handle_on_invoice_upd_sts 8820 8820 0 0.00 0 22558 347 0 0
sp_qd_handle_on_reserve_upd_sts 8954 8954 0 0.00 0 21553 72 0 0
sp_reserve_write_off 8954 8954 0 0.00 6 21564 186 0 0
sp_supplier_invoice 4977 4977 0 0.00 6 75628 3074 0 0
sp_supplier_order 4968 4968 0 0.00 5 22551 1207 0 0
srv_aggregate_perf_data 85 85 0 0.00 1342 281886 22458 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 2511 104126 35403 0 0
srv_find_qd_qs_mism 888833 888833 0 0.00 0 19727 7 0 0
srv_make_invnt_saldo 543 543 0 0.00 38 77041 995 0 0
srv_make_money_saldo 747 747 0 0.00 1 5697 35 0 0
srv_recalc_idx_stat 3 3 0 0.00 206781 236524 223024 0 0
t$perf-abend:sp_add_invoice_to_stock 82 82 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4474 4474 0 0.00 0 8979 188 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 1 6387 156 0 0
t$perf-norm:sp_cancel_client_order 1564 1564 0 0.00 0 2322 14 0 0
t$perf-norm:sp_cancel_customer_reserve 603 603 0 0.00 0 476 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 605 605 0 0.00 0 2977 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 375 375 0 0.00 0 244 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 371 371 0 0.00 0 3551 21 0 0
t$perf-norm:sp_cancel_supplier_order 353 353 0 0.00 0 28225 1672 0 0
t$perf-norm:sp_cancel_write_off 896 896 0 0.00 0 502 4 0 0
t$perf-norm:sp_client_order 18740 18740 0 0.00 0 4516 18 0 0
t$perf-norm:sp_customer_reserve 910 910 0 0.00 0 1190 11 0 0
t$perf-norm:sp_pay_from_customer 6394 6394 0 0.00 0 3924 8 0 0
t$perf-norm:sp_pay_to_supplier 5343 5343 0 0.00 0 16161 15 0 0
t$perf-norm:sp_reserve_write_off 8954 8954 0 0.00 0 8417 12 0 0
t$perf-norm:sp_supplier_invoice 4977 4977 0 0.00 0 7679 23 0 0
t$perf-norm:sp_supplier_order 4968 4968 0 0.00 0 18825 19 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 643 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 44 2 0 0
t$perf-norm:srv_make_invnt_saldo 543 543 0 0.00 0 2640 31 0 0
t$perf-norm:srv_make_money_saldo 747 747 0 0.00 0 1172 22 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9074 8910 164 1.80 0 5644 17 0 164
v_all_customers 34354 34354 0 0.00 0 17 1 0 0
v_all_suppliers 28120 28120 0 0.00 0 72 1 0 0
v_all_wares 37480 37480 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 1910 9 0 0
v_cancel_client_order 3128 3128 0 0.00 0 768 3 0 0
v_cancel_customer_prepayment 1210 1210 0 0.00 0 5426 9 0 0
v_cancel_customer_reserve 1206 1206 0 0.00 0 3636 9 0 0
v_cancel_payment_to_supplier 750 750 0 0.00 0 216 3 0 0
v_cancel_supplier_invoice 752 742 10 1.32 0 5697 23 0 10
v_cancel_supplier_order 706 706 0 0.00 0 806 3 0 0
v_cancel_write_off 1792 1792 0 0.00 0 2972 13 0 0
v_max_id_clo_ord 4968 4968 0 0.00 0 21714 6 0 0
v_max_id_clo_res 910 910 0 0.00 0 2639 10 0 0
v_max_id_ord_sup 4973 4973 0 0.00 0 2661 2 0 0
v_max_non_paid_invoice 1224 1224 0 0.00 0 4174 6 0 0
v_max_non_paid_realizn 3166 3166 0 0.00 0 1905 5 0 0
v_min_id_clo_ord 4968 4968 0 0.00 0 6874 11 0 0
v_min_id_clo_res 910 910 0 0.00 0 1252 4 0 0
v_min_id_ord_sup 4973 4973 0 0.00 0 5386 5 0 0
v_min_non_paid_invoice 5343 5343 0 0.00 0 4292 16 0 0
v_min_non_paid_realizn 6394 6394 0 0.00 0 5815 19 0 0
v_our_firm 9582 9582 0 0.00 0 22 1 0 0
v_reserve_write_off 17906 17906 0 0.00 0 5910 5 0 0
x_lock_depdocs_on_canc_invoice 8818 8818 0 0.00 0 12645 137 0 0
x_lock_depdocs_on_canc_sup_ord 353 353 0 0.00 0 5107 289 0 0
x_make_qstorno_1000_1200 4968 4968 0 0.00 1 22492 1115 0 0
x_make_qstorno_1200_2000 4977 4977 0 0.00 2 75621 2955 0 0
x_make_qstorno_2100_3300 434158 434158 0 0.00 0 59085 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-04-2024 22:10:46 to 04-04-2024 22:10:50.

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
20:09:53 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:54 23398 8192000000 9901230592 10208784384 980753312 10.692 100 92 184 0 1010624448 6057072 23814064
20:12:25 21187 8192000000 9944690768 10264649728 1026208496 11.132 100 87 174 0 1056247776 7947616 22091664
20:13:56 11674 8192000000 9977585648 10307817472 1063312464 11.488 100 88 177 0 1094885104 9638992 21933648
20:15:14 9974 8192000000 10021309424 10363326464 1105385200 11.889 100 81 162 0 1135208384 10369280 19453904
20:16:26 7303 8192000000 10070461488 10427199488 1157389568 12.379 100 76 152 1 1186031776 11019792 17622416
20:17:35 3879 8192000000 10115678704 10477895680 1197855264 12.756 100 83 166 1 1230626752 13422672 19348816
20:18:41 2428 8192000000 10136125872 10508906496 1228280480 13.038 100 79 157 0 1258337712 12525280 17531952
20:19:47 1116 8192000000 10179195312 10557620224 1262045184 13.349 100 83 167 0 1294075584 13378944 18651456
20:20:50 1057 8192000000 10199743728 10581508096 1284886512 13.558 100 86 172 1 1316773952 13062064 18825376
20:21:53 31825 8192000000 10202644896 10596233216 1297253104 13.670 100 67 134 1 1322104400 9614000 15237296
20:23:26 6645 8192000000 10196650576 10605527040 1306734208 13.756 100 41 82 1 1324121696 8012720 9374768
20:24:36 9555 8192000000 10201538592 10617782272 1316313936 13.843 100 19 38 0 1326037424 5588976 4134512
20:25:48 9290 8192000000 10211445120 10626289664 1324072816 13.914 100 16 32 1 1332699120 5269872 3356432
20:26:58 18946 8192000000 10220365072 10639417344 1328847296 13.957 100 18 36 0 1338541760 5882256 3812208
20:28:17 11804 8192000000 10246749008 10652323840 1336668656 14.027 100 59 120 0 1356683376 5416720 14598000
20:29:30 3774 8192000000 10222234928 10640785408 1330284832 13.970 100 36 71 0 1346181296 7436576 8459888
20:30:43 9641 8192000000 10246894608 10657501184 1339212368 14.050 100 56 109 0 1361443216 10142336 12088512
20:31:58 10560 8192000000 10242961136 10654433280 1339299360 14.051 100 52 103 1 1360786560 9501648 11985552
20:33:10 40056 8192000000 10216158944 10629095424 1290654912 13.610 97 45 91 1 1312285216 11472048 10158256
20:35:30 30913 8192000000 10222923776 10636279808 1296402704 13.663 98 40 78 0 1320297968 14349968 9545296
20:37:04 7525 8192000000 10231926784 10634788864 1308548320 13.773 99 50 97 3 1336760080 17196064 11015696
20:38:18 21010 8192000000 10245567664 10656555008 1322420688 13.899 99 48 96 0 1356005664 21965664 11619312
20:39:44 27902 8192000000 10260687344 10670002176 1343406752 14.088 100 45 88 0 1372772848 19002592 10363504
20:41:17 6251 8192000000 10238562672 10639155200 1306464672 13.754 99 48 93 0 1340356800 22782000 11110128
20:42:32 13195 8192000000 10258281280 10656038912 1307613936 13.764 98 51 102 1 1347146080 27102688 12429456
20:43:51 8357 8192000000 10267650128 10671427584 1332928816 13.994 100 49 96 1 1376187472 30952624 12306032
20:45:05 3923 8192000000 10289168496 10678398976 1338823808 14.047 100 73 146 2 1389677424 33165056 17688560
20:46:13 6963 8192000000 10297821152 10698674176 1349993616 14.147 100 67 132 0 1405316832 38671280 16651936
20:47:23 2510 8192000000 10303929360 10706960384 1358039536 14.220 100 69 135 1 1413748576 39644160 16064880
20:48:30 3811 8192000000 10333123600 10733375488 1369362864 14.321 100 85 170 0 1437419984 47542208 20514912
20:49:45 4854 8192000000 10325418432 10727264256 1372832048 14.352 100 74 147 1 1427859072 37665104 17361920
20:50:55 7518 8192000000 10346839376 10752847872 1389698992 14.503 100 74 148 0 1448761120 41280288 17781840
20:52:07 3329 8192000000 10373384096 10775588864 1406887136 14.656 100 87 173 0 1475888032 47986256 21014640
20:53:16 8109 8192000000 10355661632 10779369472 1410548688 14.689 100 60 118 0 1473274128 47155712 15569728
20:54:37 12546 8192000000 10359041824 10786709504 1415589200 14.734 100 44 88 1 1469619984 42463984 11566800
20:55:55 17226 8192000000 10356806224 10790633472 1405359616 14.643 100 27 54 0 1462651040 49732128 7559296
20:57:42 19624 8192000000 10364571248 10801094656 1406607584 14.654 100 33 64 1 1477155712 60582304 9965824
20:59:36 26783 8192000000 10319507520 10787442688 1389390768 14.500 100 20 40 1 1431673744 36757040 5525936
21:01:18 28827 8192000000 10332014320 10774130688 1411647152 14.699 100 44 86 0 1439047280 16827328 10572800
21:02:49 38026 8192000000 10314966464 10787467264 1392985696 14.532 99 7 14 0 1418549776 23753632 1810448
21:04:35 43398 8192000000 10310055856 10757697536 1403031280 14.622 100 31 61 0 1423041600 13026624 6983696
21:06:19 104126 8192000000 10308440976 10765680640 1379766576 14.414 98 32 64 1 1397143520 9680960 7695984
21:09:08 37202 8192000000 10314483920 10766098432 1380189376 14.418 98 23 45 0 1396186224 11477536 4519312
21:11:23 12800 8192000000 10315186336 10770948096 1406523872 14.653 100 38 77 0 1425015856 9828368 8663616
21:12:39 24960 8192000000 10306017728 10762178560 1395738480 14.557 99 10 20 0 1404614048 6664752 2210816
21:14:05 24195 8192000000 10301970064 10758500352 1386190192 14.472 98 15 27 2 1396014976 6781712 3043072
21:15:30 20483 8192000000 10305025472 10762006528 1387555280 14.484 99 16 32 1 1401311936 9496272 4260384
21:16:50 82962 8192000000 10290641696 10746945536 1373460848 14.358 98 14 28 0 1384016368 7375600 3179920
21:19:21 65043 8192000000 10289314624 10747760640 1341391344 14.070 96 12 22 2 1350396592 6644352 2360896
21:21:27 16090 8192000000 10298692752 10745483264 1372605408 14.350 99 46 89 0 1401886416 19426976 9854032
21:22:45 51000 8192000000 10280640912 10734768128 1339887712 14.056 97 22 44 0 1364845136 19823680 5133744
21:24:41 15797 8192000000 10285465456 10728292352 1378569248 14.404 100 39 75 0 1395512704 8449552 8493904
21:25:58 64233 8192000000 10256203328 10698448896 1299478176 13.690 96 21 38 0 1319463184 15271408 4713600
21:28:02 28276 8192000000 10257614176 10699862016 1334672544 14.009 99 32 65 0 1357895760 15033552 8189664
21:29:36 40854 8192000000 10239347168 10667061248 1282698816 13.538 96 24 48 1 1296303440 8382224 5222400
21:31:24 78048 8192000000 10256639984 10686947328 1342366512 14.079 100 50 100 0 1366117856 12697904 11053440
21:34:08 22515 8192000000 10241033056 10679582720 1323186432 13.906 99 24 47 0 1340326624 12277216 4862976
21:35:31 54236 8192000000 10227879696 10675580928 1314215472 13.824 98 10 20 0 1323116240 6525264 2375504
21:37:27 53392 8192000000 10237281008 10697453568 1344851184 14.101 100 9 18 0 1355439168 8560736 2027248
21:39:23 33193 8192000000 10254447728 10695041024 1329378256 13.962 98 18 36 0 1338547872 5944496 3225120
21:40:57 69543 8192000000 10259142208 10713174016 1334721712 14.010 98 15 30 0 1347430464 9228432 3480320
21:43:11 77749 8192000000 10269590912 10716876800 1356150336 14.203 99 11 22 0 1373329728 14631760 2547632
21:45:30 50561 8192000000 10292794752 10737168384 1359555280 14.233 99 29 57 0 1380955200 14910432 6489488
21:47:20 67318 8192000000 10290595552 10740232192 1327102336 13.941 96 25 50 0 1347175888 15064528 5009024
21:49:34 63746 8192000000 10289956624 10733105152 1359131808 14.230 98 18 36 0 1371187072 8290256 3765008
21:51:43 45337 8192000000 10289783760 10743443456 1371799552 14.343 99 19 38 0 1387069008 11433280 3836176
21:53:30 72975 8192000000 10296077152 10741321728 1381573744 14.431 100 18 36 0 1395977248 10075328 4328176
21:55:51 45673 8192000000 10286812144 10746335232 1372609920 14.350 99 11 22 0 1389651792 14981136 2060736
21:57:38 70355 8192000000 10288602192 10751897600 1390558448 14.511 100 12 24 0 1401792944 8297008 2937488
21:59:53 52489 8192000000 10267597792 10730975232 1350110000 14.148 97 12 24 0 1359936608 7400112 2426496
22:01:46 73286 8192000000 10270716992 10731270144 1348033744 14.130 98 11 22 0 1364170944 13401248 2735952
22:04:01 20787 8192000000 10296576928 10737319936 1357877456 14.218 98 29 58 0 1375558560 11300096 6381008
22:05:24 39796 8192000000 10259302864 10718269440 1333439776 13.998 98 21 42 0 1356719712 18242992 5036944
22:07:05 73448 8192000000 10254663936 10713067520 1306241552 13.752 96 25 51 0 1326422688 14743200 5437936
22:09:19 33422 8192000000 9679360368 10032242688 772129984 8.613 57 14 28 0 781208464 5446368 3632112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 04-04-2024 22:10:52 to 04-04-2024 22:11:06.

Exceptions occured during test was in run

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

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

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          181348
MON$OLDEST_ACTIVE               181349
MON$OLDEST_SNAPSHOT             181349
MON$NEXT_TRANSACTION            181349
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                       1907296
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Apr  4 22:11:10 2024 
 
Database header page information: 
    Flags            0 
    Generation        94852 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    181348 
    Oldest active        181349 
    Oldest snapshot        181349 
    Next transaction    181350 
    Sequence number        0 
    Next attachment ID    728 
    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.10, total records: 7875248 
    Average version length: 48.16, total versions: 130921, 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: 87008 
    Data pages: 87008, average fill: 72% 
    Primary pages: 87008, secondary pages: 0, swept pages: 13549 
    Empty pages: 5, full pages: 74484 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 55 
    40 - 59% = 574 
    60 - 79% = 86309 
    80 - 99% = 55 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23593, nodes: 7875248 
    Average node length: 18.94, total dup: 0, max dup: 0 
    Average key length: 15.95, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1760190, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 357 
        20 - 39% = 1546 
        40 - 59% = 4485 
        60 - 79% = 2222 
        80 - 99% = 14983 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13682, nodes: 7875248 
    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: 1581944, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1394 
        40 - 59% = 2303 
        60 - 79% = 1019 
        80 - 99% = 8966 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8466, nodes: 7875248 
    Average node length: 6.64, total dup: 5853443, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1574940, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 809 
        40 - 59% = 1572 
        60 - 79% = 860 
        80 - 99% = 5078 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.73, total records: 2314096 
    Average version length: 34.56, total versions: 139548, max versions: 4 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28400 
    Data pages: 28400, average fill: 76% 
    Primary pages: 28393, secondary pages: 7, swept pages: 8021 
    Empty pages: 7, full pages: 25138 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 44 
    40 - 59% = 433 
    60 - 79% = 25945 
    80 - 99% = 1966 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4664, nodes: 2314096 
    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: 708135, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 875 
        40 - 59% = 956 
        60 - 79% = 651 
        80 - 99% = 2182 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2515, nodes: 2317262 
    Average node length: 4.97, total dup: 2316363, max dup: 18912 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1278540, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 188 
        40 - 59% = 1478 
        60 - 79% = 629 
        80 - 99% = 218 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2096, nodes: 2314096 
    Average node length: 4.97, total dup: 2314046, max dup: 130715 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074538, ratio: 0.46 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 15 
        40 - 59% = 1245 
        60 - 79% = 46 
        80 - 99% = 782 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4481, nodes: 2314096 
    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: 708135, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 530 
        40 - 59% = 722 
        60 - 79% = 739 
        80 - 99% = 2347 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.21, total records: 400 
    Average version length: 22.55, total versions: 256773, max versions: 667 
    Average fragment length: 2.00, total fragments: 60, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1424 
    Data pages: 1424, average fill: 89% 
    Primary pages: 9, secondary pages: 1415, swept pages: 0 
    Empty pages: 2, full pages: 1421 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1417 
 
    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: 6.90, total records: 130045 
    Average version length: 68.30, total versions: 116911, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 12.76 
    Pointer pages: 7, data page slots: 2872 
    Data pages: 2656, average fill: 61% 
    Primary pages: 2654, secondary pages: 2, swept pages: 0 
    Empty pages: 386, full pages: 1495 
    Fill distribution: 
     0 - 19% = 577 
    20 - 39% = 234 
    40 - 59% = 214 
    60 - 79% = 303 
    80 - 99% = 1328 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708655, depth: 3, leaf buckets: 408, nodes: 130045 
    Average node length: 13.29, total dup: 11501, max dup: 2 
    Average key length: 10.53, compression ratio: 2.56 
    Average prefix length: 19.38, average data length: 7.62 
    Clustering factor: 92022, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 42 
        40 - 59% = 269 
        60 - 79% = 94 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 19677, max versions: 1058 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 88% 
    Primary pages: 2, secondary pages: 70, swept pages: 0 
    Empty pages: 1, full pages: 70 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 8 
    80 - 99% = 63 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.16, total records: 1928 
    Average version length: 43.85, total versions: 1793, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 18.38 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 60% 
    Primary pages: 29, secondary pages: 2, swept pages: 0 
    Empty pages: 3, full pages: 10 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88483, depth: 2, leaf buckets: 4, nodes: 1928 
    Average node length: 4.20, total dup: 1830, max dup: 223 
    Average key length: 2.56, compression ratio: 7.43 
    Average prefix length: 18.49, average data length: 0.51 
    Clustering factor: 967, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        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.09, 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: 787801 
    Average version length: 25.43, total versions: 84706, max versions: 5 
    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: 8128 
    Data pages: 8128, average fill: 68% 
    Primary pages: 8101, secondary pages: 27, swept pages: 1260 
    Empty pages: 116, full pages: 6936 
    Fill distribution: 
     0 - 19% = 252 
    20 - 39% = 270 
    40 - 59% = 245 
    60 - 79% = 7004 
    80 - 99% = 357 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 880, nodes: 787801 
    Average node length: 4.87, total dup: 787752, max dup: 141717 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88684, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 142 
        40 - 59% = 496 
        60 - 79% = 187 
        80 - 99% = 54 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 920, nodes: 787801 
    Average node length: 5.87, total dup: 701660, max dup: 50 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156791, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 106 
        40 - 59% = 383 
        60 - 79% = 148 
        80 - 99% = 281 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 969, nodes: 787801 
    Average node length: 5.87, total dup: 701660, max dup: 50 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158747, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 200 
        40 - 59% = 368 
        60 - 79% = 131 
        80 - 99% = 270 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1127, nodes: 787801 
    Average node length: 5.95, total dup: 701660, max dup: 50 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151968, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 276 
        40 - 59% = 556 
        60 - 79% = 212 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5434 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.80, total fragments: 92, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 77, secondary pages: 19, swept pages: 51 
    Empty pages: 11, full pages: 61 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 66 
    80 - 99% = 2 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5434 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.36, average data length: 1.55 
    Clustering factor: 5164, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        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: 5434 
    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: 145, 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: 83463 
    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: 4, full pages: 803 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 804 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35040, depth: 2, leaf buckets: 106, nodes: 83463 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 3416, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        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: 110.62, 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.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.07, total records: 157932 
    Average version length: 150.52, total versions: 2606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 5392 
    Data pages: 3808, average fill: 85% 
    Primary pages: 3807, secondary pages: 1, swept pages: 4 
    Empty pages: 66, full pages: 3725 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 3723 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 140.00, total records: 174117 
    Average version length: 154.20, total versions: 12642, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.11 
    Pointer pages: 7, data page slots: 5064 
    Data pages: 4288, average fill: 84% 
    Primary pages: 4288, secondary pages: 0, swept pages: 5 
    Empty pages: 133, full pages: 4105 
    Fill distribution: 
     0 - 19% = 137 
    20 - 39% = 13 
    40 - 59% = 18 
    60 - 79% = 14 
    80 - 99% = 4106 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 131.58, total records: 193580 
    Average version length: 154.55, total versions: 25155, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.89 
    Pointer pages: 7, data page slots: 4936 
    Data pages: 4728, average fill: 86% 
    Primary pages: 4728, secondary pages: 0, swept pages: 2 
    Empty pages: 101, full pages: 4588 
    Fill distribution: 
     0 - 19% = 108 
    20 - 39% = 12 
    40 - 59% = 12 
    60 - 79% = 7 
    80 - 99% = 4589 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.09, total records: 167669 
    Average version length: 150.95, total versions: 4289, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 7, data page slots: 4688 
    Data pages: 4064, average fill: 85% 
    Primary pages: 4063, secondary pages: 1, swept pages: 4 
    Empty pages: 76, full pages: 3955 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 10 
    40 - 59% = 13 
    60 - 79% = 8 
    80 - 99% = 3954 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 144.64, total records: 145363 
    Average version length: 152.19, total versions: 5837, 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: 8, data page slots: 4472 
    Data pages: 3520, average fill: 85% 
    Primary pages: 3520, secondary pages: 0, swept pages: 5 
    Empty pages: 68, full pages: 3421 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 5 
    40 - 59% = 9 
    60 - 79% = 14 
    80 - 99% = 3421 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.54, total records: 175050 
    Average version length: 151.18, total versions: 4281, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5800 
    Data pages: 4216, average fill: 86% 
    Primary pages: 4216, secondary pages: 0, swept pages: 4 
    Empty pages: 54, full pages: 4141 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4141 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.04, total records: 166064 
    Average version length: 151.19, total versions: 3374, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 8, data page slots: 4920 
    Data pages: 4064, average fill: 84% 
    Primary pages: 4064, secondary pages: 0, swept pages: 4 
    Empty pages: 109, full pages: 3922 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 15 
    40 - 59% = 10 
    60 - 79% = 5 
    80 - 99% = 3922 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.35, total records: 170912 
    Average version length: 151.50, total versions: 5119, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 6, data page slots: 6184 
    Data pages: 4128, average fill: 85% 
    Primary pages: 4127, secondary pages: 1, swept pages: 4 
    Empty pages: 64, full pages: 4033 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 10 
    40 - 59% = 11 
    60 - 79% = 5 
    80 - 99% = 4033 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.43, total records: 171490 
    Average version length: 151.38, total versions: 4157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5392 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4136, secondary pages: 0, swept pages: 2 
    Empty pages: 61, full pages: 4055 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 4055 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.37, total records: 173750 
    Average version length: 150.60, total versions: 3245, 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: 6, data page slots: 4512 
    Data pages: 4192, average fill: 86% 
    Primary pages: 4192, secondary pages: 0, swept pages: 6 
    Empty pages: 60, full pages: 4111 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4112 
 
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.22, total records: 2160723 
    Average version length: 52.91, total versions: 62426, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25512 
    Data pages: 25512, average fill: 73% 
    Primary pages: 25512, secondary pages: 0, swept pages: 8501 
    Empty pages: 119, full pages: 22764 
    Fill distribution: 
     0 - 19% = 254 
    20 - 39% = 242 
    40 - 59% = 581 
    60 - 79% = 23818 
    80 - 99% = 617 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2641, nodes: 2160723 
    Average node length: 5.44, total dup: 2017862, max dup: 1458 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185728, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 256 
        40 - 59% = 1790 
        60 - 79% = 297 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2762, nodes: 2160723 
    Average node length: 5.69, total dup: 1940396, max dup: 72 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 385447, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2277 
        60 - 79% = 448 
        80 - 99% = 33 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2155, nodes: 2160723 
    Average node length: 4.96, total dup: 2160623, max dup: 28470 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 183303, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 143 
        40 - 59% = 1126 
        60 - 79% = 421 
        80 - 99% = 460 
 
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.70, total records: 160872 
    Average version length: 69.18, total versions: 75590, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.43 
    Pointer pages: 3, data page slots: 4296 
    Data pages: 2944, average fill: 63% 
    Primary pages: 2944, secondary pages: 0, swept pages: 398 
    Empty pages: 544, full pages: 2190 
    Fill distribution: 
     0 - 19% = 654 
    20 - 39% = 15 
    40 - 59% = 30 
    60 - 79% = 756 
    80 - 99% = 1489 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103277, depth: 3, leaf buckets: 221, nodes: 160872 
    Average node length: 6.45, total dup: 140044, max dup: 14 
    Average key length: 3.93, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27894, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 122 
        60 - 79% = 56 
        80 - 99% = 31 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.88, total records: 6965491 
    Average version length: 68.79, total versions: 512227, 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: 101056 
    Data pages: 101056, average fill: 74% 
    Primary pages: 101056, secondary pages: 0, swept pages: 16420 
    Empty pages: 164, full pages: 89437 
    Fill distribution: 
     0 - 19% = 1766 
    20 - 39% = 4017 
    40 - 59% = 3165 
    60 - 79% = 79705 
    80 - 99% = 12403 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10675, nodes: 6965491 
    Average node length: 6.51, total dup: 6027317, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1571273, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1797 
        40 - 59% = 5939 
        60 - 79% = 2443 
        80 - 99% = 488 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8355, nodes: 6965491 
    Average node length: 5.40, total dup: 6685686, max dup: 182 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1366151, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1158 
        40 - 59% = 4591 
        60 - 79% = 1553 
        80 - 99% = 1044 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8406, nodes: 6965491 
    Average node length: 5.40, total dup: 6685686, max dup: 182 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1368718, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1225 
        40 - 59% = 4538 
        60 - 79% = 1583 
        80 - 99% = 1052 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.45, total records: 11950994 
    Average version length: 68.76, total versions: 433734, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 101, data page slots: 164464 
    Data pages: 164464, average fill: 77% 
    Primary pages: 164464, secondary pages: 0, swept pages: 59984 
    Empty pages: 43, full pages: 162133 
    Fill distribution: 
     0 - 19% = 214 
    20 - 39% = 454 
    40 - 59% = 795 
    60 - 79% = 152413 
    80 - 99% = 10588 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18367, nodes: 11950994 
    Average node length: 6.57, total dup: 10418203, max dup: 56 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2378022, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 2443 
        40 - 59% = 10983 
        60 - 79% = 4221 
        80 - 99% = 688 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 36.42, total records: 1926182 
    Average version length: 69.14, total versions: 912116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.46 
    Pointer pages: 28, data page slots: 45040 
    Data pages: 28328, average fill: 79% 
    Primary pages: 28328, secondary pages: 0, swept pages: 2405 
    Empty pages: 772, full pages: 25027 
    Fill distribution: 
     0 - 19% = 1369 
    20 - 39% = 639 
    40 - 59% = 626 
    60 - 79% = 9848 
    80 - 99% = 15846 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2220, nodes: 1926182 
    Average node length: 5.50, total dup: 1848898, max dup: 99 
    Average key length: 2.54, compression ratio: 16.54 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 133853, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 172 
        40 - 59% = 1030 
        60 - 79% = 706 
        80 - 99% = 300 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.18, total records: 1257954 
    Average version length: 69.13, total versions: 634820, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.69 
    Pointer pages: 23, data page slots: 36816 
    Data pages: 29416, average fill: 50% 
    Primary pages: 29415, secondary pages: 1, swept pages: 7285 
    Empty pages: 7815, full pages: 15338 
    Fill distribution: 
     0 - 19% = 10773 
    20 - 39% = 791 
    40 - 59% = 888 
    60 - 79% = 6305 
    80 - 99% = 10659 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1550, nodes: 1257954 
    Average node length: 5.75, total dup: 1178433, max dup: 99 
    Average key length: 2.81, compression ratio: 14.94 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 165356, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 195 
        40 - 59% = 667 
        60 - 79% = 500 
        80 - 99% = 185 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.91, total records: 9741040 
    Average version length: 68.96, total versions: 704415, 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: 88, data page slots: 143584 
    Data pages: 143552, average fill: 73% 
    Primary pages: 143552, secondary pages: 0, swept pages: 35500 
    Empty pages: 229, full pages: 105289 
    Fill distribution: 
     0 - 19% = 712 
    20 - 39% = 3306 
    40 - 59% = 14062 
    60 - 79% = 111043 
    80 - 99% = 14429 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13511, nodes: 9741040 
    Average node length: 6.67, total dup: 8082218, max dup: 27 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2114413, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 791 
        40 - 59% = 6165 
        60 - 79% = 5493 
        80 - 99% = 1061 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21205766 
    Average version length: 82.92, total versions: 16215, 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: 319528 
    Data pages: 319528, average fill: 81% 
    Primary pages: 319528, secondary pages: 0, swept pages: 12511 
    Empty pages: 19, full pages: 319140 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 20 
    40 - 59% = 46 
    60 - 79% = 27403 
    80 - 99% = 292030 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19256, nodes: 21205766 
    Average node length: 5.72, total dup: 20723597, max dup: 130 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288968, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 7791 
        60 - 79% = 576 
        80 - 99% = 10882 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17231, nodes: 21205766 
    Average node length: 6.31, total dup: 18635294, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916521, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 4 
        40 - 59% = 797 
        60 - 79% = 280 
        80 - 99% = 16145 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21039, nodes: 21205766 
    Average node length: 6.35, total dup: 18554656, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3584439, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1 
        40 - 59% = 8047 
        60 - 79% = 626 
        80 - 99% = 12352 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16184, nodes: 21205766 
    Average node length: 5.56, total dup: 21205666, max dup: 229718 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945333, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2984 
        60 - 79% = 379 
        80 - 99% = 12810 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.90, total records: 10180051 
    Average version length: 82.61, total versions: 682273, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 106, data page slots: 171800 
    Data pages: 171784, average fill: 73% 
    Primary pages: 171784, secondary pages: 0, swept pages: 53423 
    Empty pages: 269, full pages: 118539 
    Fill distribution: 
     0 - 19% = 1031 
    20 - 39% = 4976 
    40 - 59% = 19814 
    60 - 79% = 64916 
    80 - 99% = 81047 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11359, nodes: 10180051 
    Average node length: 5.36, total dup: 9866312, max dup: 226 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2245691, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 6680 
        60 - 79% = 4416 
        80 - 99% = 242 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13981, nodes: 10180051 
    Average node length: 6.24, total dup: 8441941, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1566993, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 153 
        20 - 39% = 3815 
        40 - 59% = 4651 
        60 - 79% = 2626 
        80 - 99% = 2736 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12683, nodes: 10180051 
    Average node length: 5.98, total dup: 8846912, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2449839, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 28 
        40 - 59% = 7591 
        60 - 79% = 4773 
        80 - 99% = 289 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10595, nodes: 10180051 
    Average node length: 5.14, total dup: 10179951, max dup: 148996 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1604047, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1131 
        40 - 59% = 5499 
        60 - 79% = 1723 
        80 - 99% = 2194 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.73, total records: 11762557 
    Average version length: 82.53, total versions: 511708, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 119, data page slots: 193184 
    Data pages: 191936, average fill: 75% 
    Primary pages: 191936, secondary pages: 0, swept pages: 55176 
    Empty pages: 2136, full pages: 155608 
    Fill distribution: 
     0 - 19% = 3508 
    20 - 39% = 5147 
    40 - 59% = 13191 
    60 - 79% = 39394 
    80 - 99% = 130696 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13135, nodes: 11762557 
    Average node length: 5.31, total dup: 11651980, max dup: 635 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2461659, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 70 
        40 - 59% = 7921 
        60 - 79% = 4846 
        80 - 99% = 297 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10788, nodes: 11762557 
    Average node length: 5.50, total dup: 11251384, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 750651, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 814 
        40 - 59% = 2695 
        60 - 79% = 1836 
        80 - 99% = 5303 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15023, nodes: 11762557 
    Average node length: 6.03, total dup: 10274945, max dup: 76 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2478292, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 80 
        40 - 59% = 9332 
        60 - 79% = 5253 
        80 - 99% = 354 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11266, nodes: 11762557 
    Average node length: 5.23, total dup: 11762457, max dup: 192735 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 738322, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 721 
        40 - 59% = 5310 
        60 - 79% = 1570 
        80 - 99% = 3573 
 
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: 77.40, total records: 10277406 
    Average version length: 82.90, total versions: 663757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 108, data page slots: 176136 
    Data pages: 176080, average fill: 72% 
    Primary pages: 176080, secondary pages: 0, swept pages: 57323 
    Empty pages: 281, full pages: 115908 
    Fill distribution: 
     0 - 19% = 1132 
    20 - 39% = 5927 
    40 - 59% = 23072 
    60 - 79% = 67453 
    80 - 99% = 78496 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12258, nodes: 10277406 
    Average node length: 5.19, total dup: 10248228, max dup: 1876 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2060651, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 1331 
        40 - 59% = 8169 
        60 - 79% = 2070 
        80 - 99% = 671 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14120, nodes: 10277406 
    Average node length: 6.26, total dup: 8522502, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1528792, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 3852 
        40 - 59% = 4642 
        60 - 79% = 2582 
        80 - 99% = 2861 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12900, nodes: 10277406 
    Average node length: 5.44, total dup: 9823224, max dup: 112 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2199587, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1267 
        40 - 59% = 9149 
        60 - 79% = 1795 
        80 - 99% = 664 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10706, nodes: 10277406 
    Average node length: 5.16, total dup: 10277306, max dup: 151418 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1628330, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1192 
        40 - 59% = 5491 
        60 - 79% = 1694 
        80 - 99% = 2287 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.25, total records: 584979 
    Average version length: 68.79, total versions: 7955, 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: 8008 
    Data pages: 8008, average fill: 76% 
    Primary pages: 8008, secondary pages: 0, swept pages: 3350 
    Empty pages: 0, full pages: 7318 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 7 
    40 - 59% = 78 
    60 - 79% = 7786 
    80 - 99% = 136 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 30419, depth: 3, leaf buckets: 743, nodes: 584979 
    Average node length: 5.95, total dup: 498137, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101777, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 532 
        60 - 79% = 93 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26334, depth: 3, leaf buckets: 765, nodes: 584979 
    Average node length: 6.15, total dup: 479932, max dup: 27 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101824, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 545 
        60 - 79% = 94 
        80 - 99% = 103 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 581, nodes: 584979 
    Average node length: 4.86, total dup: 584879, max dup: 9768 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90416, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 347 
        60 - 79% = 85 
        80 - 99% = 118 
 
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 Thu Apr  4 22:11:34 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7875248 130921 1 0.0000 0.0000
DOC_LIST 2314096 139548 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 256773 667 64100.0000 0.0000
INVNT_TURNOVER_LOG 130045 116911 1 0.0000 0.0000
MONEY_SALDO 49 19677 1058 40100.0000 0.0000
MONEY_TURNOVER_LOG 1928 1793 1 0.0000 0.0000
PDISTR 787801 84706 5 0.0000 0.0000
PERF_SPLIT_0 157932 2606 1 0.0000 0.0000
PERF_SPLIT_1 174117 12642 1 0.0000 0.0000
PERF_SPLIT_2 193580 25155 1 0.0000 0.0000
PERF_SPLIT_3 167669 4289 1 0.0000 0.0000
PERF_SPLIT_4 145363 5837 1 0.0000 0.0000
PERF_SPLIT_5 175050 4281 1 0.0000 0.0000
PERF_SPLIT_6 166064 3374 1 0.0000 0.0000
PERF_SPLIT_7 170912 5119 1 0.0000 0.0000
PERF_SPLIT_8 171490 4157 1 0.0000 0.0000
PERF_SPLIT_9 173750 3245 1 0.0000 0.0000
PSTORNED 2160723 62426 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 160872 75590 1 0.0000 0.0000
XQD_1000_3300 6965491 512227 1 0.0000 0.0000
XQD_1200_2000 11950994 433734 1 0.0000 0.0000
XQD_2000_3300 1926182 912116 1 0.0000 0.0000
XQD_2100_3300 1257954 634820 1 0.0000 0.0000
XQD_3300_3400 9741040 704415 1 0.0000 0.0000
XQS_1000_1200 21205766 16215 1 0.0000 0.0000
XQS_1000_3300 10180051 682273 1 0.0000 0.0000
XQS_1200_2000 11762557 511708 1 0.0000 0.0000
XQS_2100_3300 10277406 663757 1 0.0000 0.0000
XQS_3300_3400 584979 7955 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 ---
:792: 
:793: mscs-test-161.budzdorov.ru    Thu Apr  4 22:09:58 2024
:794:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:795: 
--- end of diff output ---

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

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