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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-30 19:09:44
DTS_END                         2024-03-30 19:09:44.9020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_WRITE_OFF(41:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55458
TRN_ID                          174352
ATT_ID                          556
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: 9145.03 21566 914503
customer order: creation 174.23 372 17423
customer order: refuse 14.13 381 1413
order to supplier: creation 45.93 1374 4593
order to supplier: removal 3.38 98265 338
invoice (draft): creation 46.73 3245 4673
invoice (draft): removal 48.74 805 4874
invoice accept: apply 42.99 22903 4299
invoice accept: cancel 43.96 996 4396
customer reserve: creation 4111.56 221 411156
customer reserve: removal 4318.55 60 431855
realization accept: apply 83.90 186 8390
realization accept: cancel 78.96 131 7896
payment from customer: creation 59.51 139 5951
payment from customer: removal 6.02 98 602
payment to supplier: creation 49.91 159 4991
payment to supplier: removal 3.74 102 374
service: total inventory turnovers 4.70 1100 470
service: total monetary turnovers 7.29 28 729
service: aggregate perf. data 0.77 20000 77
service: refresh index statistics 0.03 280759 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 30-03-2024 19:10:56 to 30-03-2024 19:10:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4024
TEST_TIME 2 3440
TEST_TIME 3 4675
TEST_TIME 4 5075
TEST_TIME 5 4382
TEST_TIME 6 4770
TEST_TIME 7 5308
TEST_TIME 8 4973
TEST_TIME 9 4919
TEST_TIME 10 5426
TEST_TIME 11 5730
TEST_TIME 12 6094
TEST_TIME 13 6033
TEST_TIME 14 6370
TEST_TIME 15 6763
TEST_TIME 16 7155
TEST_TIME 17 7659
TEST_TIME 18 7627
TEST_TIME 19 7772
TEST_TIME 20 8185
TEST_TIME 21 8527
TEST_TIME 22 8559
TEST_TIME 23 8615
TEST_TIME 24 8546
TEST_TIME 25 9214
TEST_TIME 26 9416
TEST_TIME 27 9780
TEST_TIME 28 9803
TEST_TIME 29 9637
TEST_TIME 30 9470
TEST_TIME 31 9639
TEST_TIME 32 9501
TEST_TIME 33 9398
TEST_TIME 34 9380
TEST_TIME 35 9350
TEST_TIME 36 9185
TEST_TIME 37 9278
TEST_TIME 38 9173
TEST_TIME 39 9027
TEST_TIME 40 9041
TEST_TIME 41 9013
TEST_TIME 42 8953
TEST_TIME 43 8841
TEST_TIME 44 8933
TEST_TIME 45 8868
TEST_TIME 46 8775
TEST_TIME 47 8883
TEST_TIME 48 8963
TEST_TIME 49 8916
TEST_TIME 50 9008
TEST_TIME 51 9079
TEST_TIME 52 9014
TEST_TIME 53 9013
TEST_TIME 54 9081
TEST_TIME 55 9058
TEST_TIME 56 9072
TEST_TIME 57 9078
TEST_TIME 58 9179
TEST_TIME 59 9294
TEST_TIME 60 9328
TEST_TIME 61 9265
TEST_TIME 62 9195
TEST_TIME 63 9173
TEST_TIME 64 9089
TEST_TIME 65 9058
TEST_TIME 66 9036
TEST_TIME 67 9189
TEST_TIME 68 9126
TEST_TIME 69 9123
TEST_TIME 70 9036
TEST_TIME 71 9025
TEST_TIME 72 9050
TEST_TIME 73 9048
TEST_TIME 74 9111
TEST_TIME 75 9155
TEST_TIME 76 9172
TEST_TIME 77 9176
TEST_TIME 78 9170
TEST_TIME 79 9188
TEST_TIME 80 9264
TEST_TIME 81 9329
TEST_TIME 82 9325
TEST_TIME 83 9321
TEST_TIME 84 9347
TEST_TIME 85 9383
TEST_TIME 86 9462
TEST_TIME 87 9421
TEST_TIME 88 9372
TEST_TIME 89 9298
TEST_TIME 90 9265
TEST_TIME 91 9277
TEST_TIME 92 9209
TEST_TIME 93 9200
TEST_TIME 94 9218
TEST_TIME 95 9149
TEST_TIME 96 9140
TEST_TIME 97 9168
TEST_TIME 98 9186
TEST_TIME 99 9167
TEST_TIME 100 9148

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-03-2024 19:11:00 to 30-03-2024 19:11:03.

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 1289350 1289350 0 0.00 0 15772 8 0 0
doc_list_biud 1289349 1289349 0 0.00 0 26024 26 0 0
sp_add_invoice_to_stock 4406 4299 107 2.42 39 224222 22903 0 107
sp_cancel_adding_invoice 4396 4396 0 0.00 5 71751 997 0 0
sp_cancel_client_order 1413 1413 0 0.00 5 12001 381 0 0
sp_cancel_customer_reserve 431855 431855 0 0.00 0 26026 61 0 0
sp_cancel_pay_from_customer 602 602 0 0.00 3 6948 99 0 0
sp_cancel_pay_to_supplier 374 374 0 0.00 3 9667 102 0 0
sp_cancel_supplier_invoice 4884 4874 10 0.20 2 15300 805 0 10
sp_cancel_supplier_order 338 338 0 0.00 5 1066669 98266 0 0
sp_cancel_write_off 7896 7896 0 0.00 1 13023 131 0 0
sp_client_order 17423 17423 0 0.00 3 35264 373 0 0
sp_customer_reserve 411156 411156 0 0.00 0 36433 221 0 0
sp_fill_shopping_cart 26674 26674 0 0.00 1 28767 41 0 0
sp_fill_shopping_cart_clo_res 411142 411142 0 0.00 0 12503 14 0 0
sp_get_clo_for_invoice 4285 4285 0 0.00 0 11550 287 0 0
sp_kill_cost_storno 13268 13268 0 0.00 0 12848 62 0 0
sp_kill_qstorno_ret_qs2qd 876818 876818 0 0.00 0 26012 33 0 0
sp_kill_qty_storno 463446 463446 0 0.00 0 26024 72 0 0
sp_lock_selected_doc 17509 17509 0 0.00 0 8482 6 0 0
sp_make_cost_storno 23617 23617 0 0.00 0 11233 64 0 0
sp_multiply_rows_for_pdistr 23616 23616 0 0.00 0 12376 30 0 0
sp_multiply_rows_for_qdistr 17423 17423 0 0.00 0 16203 154 0 0
sp_pay_from_customer 5951 5951 0 0.00 4 17719 139 0 0
sp_pay_to_supplier 4991 4991 0 0.00 4 11583 160 0 0
sp_payment_common 10942 10942 0 0.00 2 17701 31 0 0
sp_qd_handle_on_cancel_clo 1413 1413 0 0.00 0 11992 349 0 0
sp_qd_handle_on_invoice_upd_sts 8681 8681 0 0.00 0 21322 358 0 0
sp_qd_handle_on_reserve_upd_sts 8389 8389 0 0.00 0 8934 60 0 0
sp_reserve_write_off 8390 8390 0 0.00 7 13380 186 0 0
sp_supplier_invoice 4673 4673 0 0.00 6 86810 3246 0 0
sp_supplier_order 4593 4593 0 0.00 5 94634 1375 0 0
srv_aggregate_perf_data 77 77 0 0.00 1609 205869 20001 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 966 116599 37337 0 0
srv_find_qd_qs_mism 870448 870448 0 0.00 0 14212 7 0 0
srv_make_invnt_saldo 470 470 0 0.00 32 60881 1101 0 0
srv_make_money_saldo 729 729 0 0.00 1 372 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 208276 324499 280760 0 0
t$perf-abend:sp_add_invoice_to_stock 107 107 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4299 4299 0 0.00 0 7472 195 0 0
t$perf-norm:sp_cancel_adding_invoice 355 355 0 0.00 0 3914 109 0 0
t$perf-norm:sp_cancel_client_order 1413 1413 0 0.00 0 1152 13 0 0
t$perf-norm:sp_cancel_customer_reserve 580 580 0 0.00 0 1496 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 602 602 0 0.00 0 3344 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 374 374 0 0.00 0 1311 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 313 313 0 0.00 0 1351 15 0 0
t$perf-norm:sp_cancel_supplier_order 338 338 0 0.00 0 32586 1808 0 0
t$perf-norm:sp_cancel_write_off 864 864 0 0.00 0 4432 10 0 0
t$perf-norm:sp_client_order 17423 17423 0 0.00 0 6426 17 0 0
t$perf-norm:sp_customer_reserve 893 893 0 0.00 0 2004 8 0 0
t$perf-norm:sp_pay_from_customer 5951 5951 0 0.00 0 6430 8 0 0
t$perf-norm:sp_pay_to_supplier 4991 4991 0 0.00 0 4905 11 0 0
t$perf-norm:sp_reserve_write_off 8390 8390 0 0.00 0 4033 10 0 0
t$perf-norm:sp_supplier_invoice 4673 4673 0 0.00 0 6182 18 0 0
t$perf-norm:sp_supplier_order 4593 4593 0 0.00 0 4943 16 0 0
t$perf-norm:srv_aggregate_perf_data 77 77 0 0.00 0 60 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 1254 29 0 0
t$perf-norm:srv_make_invnt_saldo 470 470 0 0.00 0 1979 42 0 0
t$perf-norm:srv_make_money_saldo 729 729 0 0.00 0 1781 22 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 8780 8566 214 2.43 0 6662 21 0 214
v_all_customers 32452 32452 0 0.00 0 64 1 0 0
v_all_suppliers 26420 26420 0 0.00 0 39 1 0 0
v_all_wares 34846 34846 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 710 710 0 0.00 0 6623 30 0 0
v_cancel_client_order 2826 2826 0 0.00 0 2571 6 0 0
v_cancel_customer_prepayment 1204 1204 0 0.00 0 6917 19 0 0
v_cancel_customer_reserve 1160 1160 0 0.00 0 5157 12 0 0
v_cancel_payment_to_supplier 748 748 0 0.00 0 2268 12 0 0
v_cancel_supplier_invoice 646 626 20 3.09 0 9980 35 0 20
v_cancel_supplier_order 676 676 0 0.00 0 2031 7 0 0
v_cancel_write_off 1728 1728 0 0.00 0 5407 18 0 0
v_max_id_clo_ord 4586 4586 0 0.00 0 260 2 0 0
v_max_id_clo_res 893 893 0 0.00 0 1783 9 0 0
v_max_id_ord_sup 4665 4665 0 0.00 0 8900 6 0 0
v_max_non_paid_invoice 1032 1032 0 0.00 0 3655 7 0 0
v_max_non_paid_realizn 2926 2926 0 0.00 0 829 4 0 0
v_min_id_clo_ord 4586 4586 0 0.00 0 3768 8 0 0
v_min_id_clo_res 893 893 0 0.00 0 8401 13 0 0
v_min_id_ord_sup 4665 4665 0 0.00 0 5461 8 0 0
v_min_non_paid_invoice 4991 4991 0 0.00 0 9798 18 0 0
v_min_non_paid_realizn 5951 5951 0 0.00 0 8194 26 0 0
v_our_firm 8444 8444 0 0.00 0 23 1 0 0
v_reserve_write_off 16774 16774 0 0.00 0 8314 8 0 0
x_lock_depdocs_on_canc_invoice 8957 8957 0 0.00 0 11126 142 0 0
x_lock_depdocs_on_canc_sup_ord 338 338 0 0.00 0 12191 395 0 0
x_make_qstorno_1000_1200 4593 4593 0 0.00 2 94382 1283 0 0
x_make_qstorno_1200_2000 4673 4673 0 0.00 3 79077 3099 0 0
x_make_qstorno_2100_3300 411156 411156 0 0.00 0 36432 204 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-03-2024 19:11:04 to 30-03-2024 19:11:08.

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
17:09:48 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:50 26914 8192000000 9897770880 10210004992 983035680 10.714 100 84 168 0 1010670256 5646256 21988320
17:12:24 7202 8192000000 9942535872 10262573056 1025431328 11.124 100 93 186 0 1057039552 7943168 23665056
17:13:36 13239 8192000000 9969207456 10298527744 1054749712 11.406 100 88 176 0 1086476896 9319488 22407696
17:14:53 16740 8192000000 10019115200 10364456960 1103936160 11.875 100 83 166 0 1134798352 10843648 20018544
17:16:14 6182 8192000000 10058462400 10414321664 1148687936 12.297 100 79 158 1 1179608832 11846592 19074304
17:17:23 4254 8192000000 10109599776 10473148416 1194079552 12.721 100 81 162 0 1224795776 11864960 18851264
17:18:31 3091 8192000000 10143941520 10515456000 1232468784 13.077 100 80 158 0 1263776208 13471632 17835792
17:19:38 1861 8192000000 10162995616 10545709056 1252881936 13.265 100 76 152 0 1283069104 13842016 16345152
17:20:44 1467 8192000000 10196005984 10579673088 1285716944 13.565 100 87 173 1 1319176656 13135856 20323856
17:21:46 1519 8192000000 10200420928 10591379456 1290604912 13.610 100 67 133 2 1317011424 10956192 15450320
17:22:48 6381 8192000000 10206162000 10609025024 1309532720 13.782 100 47 94 1 1327241952 7471808 10237424
17:23:55 17575 8192000000 10222686000 10626867200 1314235600 13.824 100 50 98 1 1336376128 10134256 12006272
17:25:14 7226 8192000000 10212919808 10625835008 1320650032 13.883 100 13 24 0 1328227072 4875216 2701824
17:26:21 7050 8192000000 10213553824 10632830976 1326647472 13.937 100 29 57 0 1339608752 6779936 6181344
17:27:29 6866 8192000000 10219810304 10638516224 1330765808 13.974 100 17 35 0 1340665024 5489424 4409792
17:28:37 24942 8192000000 10232313696 10646278144 1330970976 13.976 100 64 129 2 1351983728 5796128 15216624
17:30:05 10235 8192000000 10238550112 10645958656 1329035408 13.958 100 61 119 0 1356048496 13693664 13319424
17:31:32 10362 8192000000 10256667136 10658783232 1334464288 14.007 100 71 141 0 1365249984 14943424 15842272
17:32:57 5395 8192000000 10258739168 10666668032 1342760800 14.082 99 49 98 0 1372203104 17784016 11658288
17:34:09 65801 8192000000 10278184784 10692190208 1357722016 14.217 100 50 100 1 1395468944 26357968 11388960
17:36:19 35170 8192000000 10239884688 10660302848 1287716928 13.583 95 28 56 0 1319569696 24702928 7149840
17:37:59 7972 8192000000 10267215360 10672852992 1328736992 13.956 98 54 108 0 1365259488 23614400 12908096
17:39:12 5643 8192000000 10295172704 10702229504 1364281536 14.276 100 62 124 1 1406844368 27161024 15401808
17:40:23 11883 8192000000 10272013568 10682163200 1345638304 14.108 100 51 104 0 1386321696 27882592 12800800
17:41:39 3963 8192000000 10273713280 10673152000 1344030000 14.094 100 56 108 0 1382683424 26182416 12471008
17:42:48 966 8192000000 10269042800 10659979264 1325742960 13.929 100 72 145 2 1374851024 31937888 17170176
17:43:54 3472 8192000000 10270649824 10664431616 1315990304 13.840 98 75 146 1 1371277104 37695152 17591648
17:45:01 1697 8192000000 10267315072 10664882176 1331548688 13.981 100 75 146 2 1380953280 31468192 17936400
17:46:08 1125 8192000000 10276902848 10665566208 1328969328 13.958 100 89 177 1 1378774096 29434480 20370288
17:47:16 2584 8192000000 10293529024 10694418432 1354465872 14.188 100 83 165 2 1400760960 27124960 19170128
17:48:22 1952 8192000000 10322683648 10720047104 1363746304 14.271 100 90 178 0 1421139792 35553184 21840304
17:49:32 2714 8192000000 10345420464 10751881216 1386547728 14.475 100 81 160 0 1447295760 40906352 19841680
17:50:37 8016 8192000000 10321123152 10746261504 1391150368 14.516 100 47 94 0 1430640896 27174304 12316224
17:51:49 19838 8192000000 10306086560 10744320000 1378611408 14.404 99 22 44 0 1414291024 29560944 6118672
17:53:29 26992 8192000000 10315997488 10754686976 1381821376 14.433 100 24 48 0 1426438480 37400464 7216640
17:55:06 20664 8192000000 10298243088 10744893440 1384996592 14.461 100 12 24 0 1413985168 25936432 3052144
17:56:32 29269 8192000000 10300220368 10750132224 1374970768 14.372 100 21 42 1 1409563008 29122944 5469296
17:58:14 24942 8192000000 10300236832 10734198784 1387527744 14.484 100 38 76 0 1406736528 10111904 9096880
17:59:41 5178 8192000000 10310241328 10742722560 1389582960 14.502 100 58 116 0 1416475392 13609328 13283104
18:00:49 23042 8192000000 10291308000 10749775872 1389511856 14.502 100 19 39 1 1408274064 14634192 4128016
18:02:19 65097 8192000000 10297346848 10755891200 1388346352 14.491 99 13 26 0 1399637872 8505584 2785936
18:04:24 48782 8192000000 10304633984 10760261632 1405327248 14.642 100 12 24 0 1417372816 9276512 2769056
18:06:14 74927 8192000000 10304816256 10764812288 1408480880 14.670 100 29 58 1 1424792176 9130816 7180480
18:08:30 61865 8192000000 10290471888 10753564672 1390017072 14.506 99 20 40 1 1403122720 8594368 4511280
18:10:32 41981 8192000000 10308900512 10769788928 1418517904 14.760 100 35 63 1 1431452160 6753840 6180416
18:12:21 20168 8192000000 10310846016 10774392832 1421346416 14.785 100 13 23 0 1430504208 6942720 2215072
18:13:49 32391 8192000000 10312770160 10777767936 1417077216 14.747 100 27 54 0 1433873504 9941104 6855184
18:15:23 67455 8192000000 10306539376 10777079808 1391918064 14.523 98 17 34 0 1414319248 17880864 4520320
18:17:32 34882 8192000000 10290233648 10752217088 1374844144 14.370 98 23 46 1 1394487728 14377136 5266448
18:19:09 69568 8192000000 10285708480 10746523648 1360017312 14.238 97 20 40 0 1382107072 17624512 4465248
18:22:12 21172 8192000000 10300011712 10736037888 1368066064 14.310 99 39 76 1 1391180576 15181824 7932688
18:23:39 19218 8192000000 10279906304 10718023680 1354394064 14.187 98 34 69 2 1370842016 9426080 7021872
18:25:01 54279 8192000000 10271284496 10706907136 1325125360 13.923 97 33 64 0 1347042400 14643008 7274032
18:27:03 62804 8192000000 10267653968 10717437952 1335621536 14.018 98 10 20 0 1361805056 23694880 2488640
18:29:06 66572 8192000000 10237927344 10676244480 1233603392 13.087 91 4 8 0 1244372336 10068928 700016
18:31:14 108999 8192000000 10240456656 10679734272 1267814112 13.402 94 17 34 1 1283579504 12232192 3533200
18:34:05 2467 8192000000 10245331360 10665336832 1319361680 13.871 99 62 124 1 1350006848 16903152 13742016
18:35:11 35328 8192000000 10263972208 10691923968 1334335680 14.006 99 41 81 0 1361696032 18203472 9156880
18:36:47 25242 8192000000 10236912096 10703081472 1335365088 14.016 100 7 14 0 1354194448 17239456 1589904
18:38:14 55954 8192000000 10240794960 10690363392 1343254448 14.087 100 17 34 0 1358852448 11338048 4259952
18:40:38 75971 8192000000 10249000752 10699399168 1340531376 14.062 99 6 12 0 1350055856 8130128 1394352
18:42:59 75312 8192000000 10267771808 10717831168 1355330096 14.195 99 22 44 0 1373020656 12850768 4839792
18:45:15 30072 8192000000 10272551472 10719670272 1371412928 14.340 100 20 40 0 1385661936 9887040 4361968
18:46:50 53646 8192000000 10302662128 10745843712 1391830080 14.522 100 20 40 0 1409986512 13859232 4297200
18:49:25 25832 8192000000 10313978960 10759139328 1391432000 14.519 100 38 76 0 1419829328 19956960 8440368
18:50:52 85039 8192000000 10315411776 10759864320 1382082752 14.435 99 17 34 0 1399783168 14628768 3071648
18:53:21 77165 8192000000 10314994992 10773364736 1406352096 14.652 100 24 48 0 1425343056 13903712 5087248
18:55:43 116599 8192000000 10308879888 10765520896 1381509024 14.430 98 15 30 0 1398045200 13194880 3341296
18:58:40 46910 8192000000 10295129920 10746306560 1359870672 14.236 97 26 52 0 1378621312 13131216 5619424
19:00:33 44090 8192000000 10291731968 10756894720 1396258928 14.562 100 16 32 0 1411601520 11871392 3471200
19:02:17 42107 8192000000 10282816160 10736410624 1369798208 14.325 98 24 48 1 1384822656 9543152 5481296
19:04:09 69242 8192000000 10285633744 10739548160 1366255376 14.293 98 20 38 0 1383553792 12552752 4745664
19:06:25 94855 8192000000 10280153680 10737553408 1325548800 13.927 95 10 21 0 1337721312 9454288 2718224
19:09:07 30658 8192000000 10270191840 10709037056 1322690400 13.901 96 28 55 0 1335936736 7657472 5588864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 30-03-2024 19:11:10 to 30-03-2024 19:11:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 107 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-03-2024 19:11:25 to 30-03-2024 19:11:27.

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          171405
MON$OLDEST_ACTIVE               174488
MON$OLDEST_SNAPSHOT             174488
MON$NEXT_TRANSACTION            174488
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                       1892736
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 Sat Mar 30 19:11:28 2024 
 
Database header page information: 
    Flags            0 
    Generation        91112 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171405 
    Oldest active        174488 
    Oldest snapshot        174488 
    Next transaction    174489 
    Sequence number        0 
    Next attachment ID    705 
    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.42, total records: 7747407 
    Average version length: 48.16, total versions: 76736, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86656 
    Data pages: 86656, average fill: 71% 
    Primary pages: 86656, secondary pages: 0, swept pages: 20231 
    Empty pages: 2, full pages: 64455 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 146 
    40 - 59% = 2008 
    60 - 79% = 84472 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23268, nodes: 7747407 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1724934, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 330 
        20 - 39% = 1988 
        40 - 59% = 3877 
        60 - 79% = 2450 
        80 - 99% = 14623 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13496, nodes: 7747407 
    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: 1547309, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1642 
        40 - 59% = 1923 
        60 - 79% = 1090 
        80 - 99% = 8841 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8323, nodes: 7747407 
    Average node length: 6.62, total dup: 5792026, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1540326, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 1016 
        40 - 59% = 1311 
        60 - 79% = 924 
        80 - 99% = 4950 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.47, total records: 2246045 
    Average version length: 34.68, total versions: 76077, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28208 
    Data pages: 28208, average fill: 74% 
    Primary pages: 28202, secondary pages: 6, swept pages: 11529 
    Empty pages: 8, full pages: 20631 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 57 
    40 - 59% = 1082 
    60 - 79% = 26476 
    80 - 99% = 579 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4555, nodes: 2246045 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 706999, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 960 
        40 - 59% = 775 
        60 - 79% = 732 
        80 - 99% = 2088 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2527, nodes: 2248381 
    Average node length: 4.97, total dup: 2247482, max dup: 20412 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250692, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 278 
        40 - 59% = 1526 
        60 - 79% = 539 
        80 - 99% = 183 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2005, nodes: 2246045 
    Average node length: 4.97, total dup: 2245995, max dup: 130127 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056509, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 69 
        40 - 59% = 1031 
        60 - 79% = 56 
        80 - 99% = 844 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4345, nodes: 2246045 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 706999, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 626 
        40 - 59% = 541 
        60 - 79% = 833 
        80 - 99% = 2232 
 
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.29, total records: 400 
    Average version length: 23.03, total versions: 231566, max versions: 605 
    Average fragment length: 2.00, total fragments: 55, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1296 
    Data pages: 1296, average fill: 89% 
    Primary pages: 11, secondary pages: 1285, swept pages: 0 
    Empty pages: 4, full pages: 1291 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1290 
 
    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: 4.52, total records: 47460 
    Average version length: 68.27, total versions: 44315, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 19.46 
    Pointer pages: 7, data page slots: 2280 
    Data pages: 1672, average fill: 36% 
    Primary pages: 1671, secondary pages: 1, swept pages: 0 
    Empty pages: 686, full pages: 453 
    Fill distribution: 
     0 - 19% = 810 
    20 - 39% = 129 
    40 - 59% = 176 
    60 - 79% = 190 
    80 - 99% = 367 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1698222, depth: 3, leaf buckets: 177, nodes: 47460 
    Average node length: 13.37, total dup: 2217, max dup: 1 
    Average key length: 10.91, compression ratio: 2.47 
    Average prefix length: 19.04, average data length: 7.96 
    Clustering factor: 35744, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 81 
        40 - 59% = 66 
        60 - 79% = 26 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18592, max versions: 984 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 61 
 
    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: 1.26, total records: 920 
    Average version length: 42.91, total versions: 893, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 46.08 
    Pointer pages: 1, data page slots: 88 
    Data pages: 29, average fill: 32% 
    Primary pages: 27, secondary pages: 2, swept pages: 0 
    Empty pages: 10, full pages: 7 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91279, depth: 2, leaf buckets: 2, nodes: 920 
    Average node length: 4.52, total dup: 822, max dup: 84 
    Average key length: 3.13, compression ratio: 6.08 
    Average prefix length: 17.98, average data length: 1.02 
    Clustering factor: 518, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        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.07, total records: 75 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.20, total records: 804885 
    Average version length: 25.54, total versions: 63700, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8072 
    Data pages: 8064, average fill: 70% 
    Primary pages: 8042, secondary pages: 22, swept pages: 1581 
    Empty pages: 61, full pages: 6749 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 104 
    40 - 59% = 238 
    60 - 79% = 7374 
    80 - 99% = 232 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 888, nodes: 804885 
    Average node length: 4.87, total dup: 804836, max dup: 147888 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89891, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 130 
        40 - 59% = 482 
        60 - 79% = 212 
        80 - 99% = 60 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 936, nodes: 804885 
    Average node length: 5.88, total dup: 716669, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160388, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 99 
        40 - 59% = 414 
        60 - 79% = 112 
        80 - 99% = 308 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 999, nodes: 804885 
    Average node length: 5.88, total dup: 716669, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162467, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 216 
        40 - 59% = 396 
        60 - 79% = 100 
        80 - 99% = 287 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1139, nodes: 804885 
    Average node length: 5.96, total dup: 716669, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155532, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 235 
        40 - 59% = 619 
        60 - 79% = 193 
        80 - 99% = 91 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5466 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.76, total fragments: 63, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 73, secondary pages: 15, swept pages: 55 
    Empty pages: 5, full pages: 67 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5466 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5116, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5466 
    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: 141, 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.10, total records: 79103 
    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: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 762 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 762 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34412, depth: 2, leaf buckets: 101, nodes: 79103 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3150, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
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: 134.87, total records: 181602 
    Average version length: 154.11, total versions: 19489, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.57 
    Pointer pages: 7, data page slots: 6016 
    Data pages: 4384, average fill: 86% 
    Primary pages: 4384, secondary pages: 0, swept pages: 3 
    Empty pages: 62, full pages: 4302 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4302 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.04, total records: 150498 
    Average version length: 149.68, total versions: 3802, 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: 4912 
    Data pages: 3616, average fill: 86% 
    Primary pages: 3616, secondary pages: 0, swept pages: 3 
    Empty pages: 42, full pages: 3552 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3552 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.11, total records: 159442 
    Average version length: 150.81, total versions: 5054, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 5, data page slots: 5800 
    Data pages: 3848, average fill: 85% 
    Primary pages: 3848, secondary pages: 0, swept pages: 1 
    Empty pages: 62, full pages: 3764 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 3765 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.42, total records: 151237 
    Average version length: 151.35, total versions: 4385, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 5, data page slots: 5008 
    Data pages: 3664, average fill: 85% 
    Primary pages: 3664, secondary pages: 0, swept pages: 1 
    Empty pages: 73, full pages: 3567 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 3567 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 141.26, total records: 178893 
    Average version length: 153.26, total versions: 12004, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.01 
    Pointer pages: 7, data page slots: 4944 
    Data pages: 4320, average fill: 86% 
    Primary pages: 4320, secondary pages: 0, swept pages: 3 
    Empty pages: 60, full pages: 4242 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4242 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 139.57, total records: 162247 
    Average version length: 152.60, total versions: 12178, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.15 
    Pointer pages: 6, data page slots: 6112 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3912, secondary pages: 0, swept pages: 5 
    Empty pages: 59, full pages: 3830 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 15 
    80 - 99% = 3828 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 144.05, total records: 158123 
    Average version length: 150.95, total versions: 6874, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 7, data page slots: 4992 
    Data pages: 3816, average fill: 85% 
    Primary pages: 3816, secondary pages: 0, swept pages: 4 
    Empty pages: 65, full pages: 3724 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 3723 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.57, total records: 164644 
    Average version length: 150.74, total versions: 4822, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 6, data page slots: 4624 
    Data pages: 3944, average fill: 86% 
    Primary pages: 3944, secondary pages: 0, swept pages: 2 
    Empty pages: 38, full pages: 3894 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 0 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 3893 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 145.93, total records: 176897 
    Average version length: 151.09, total versions: 6210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 8, data page slots: 5040 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4232, secondary pages: 0, swept pages: 3 
    Empty pages: 30, full pages: 4191 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4191 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.11, total records: 163326 
    Average version length: 150.75, total versions: 5039, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 8, data page slots: 4640 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3920, secondary pages: 0, swept pages: 3 
    Empty pages: 46, full pages: 3853 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 11 
    80 - 99% = 3852 
 
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.86, total records: 2099208 
    Average version length: 52.87, total versions: 35555, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25496 
    Data pages: 25488, average fill: 71% 
    Primary pages: 25488, secondary pages: 0, swept pages: 10873 
    Empty pages: 289, full pages: 20651 
    Fill distribution: 
     0 - 19% = 537 
    20 - 39% = 454 
    40 - 59% = 1106 
    60 - 79% = 23124 
    80 - 99% = 267 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2589, nodes: 2099208 
    Average node length: 5.44, total dup: 1958722, max dup: 1196 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182293, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 292 
        40 - 59% = 1717 
        60 - 79% = 296 
        80 - 99% = 283 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2756, nodes: 2099208 
    Average node length: 5.69, total dup: 1884159, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375681, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 2433 
        60 - 79% = 301 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2125, nodes: 2099208 
    Average node length: 4.96, total dup: 2099108, max dup: 27667 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 179799, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 208 
        40 - 59% = 1126 
        60 - 79% = 352 
        80 - 99% = 439 
 
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: 40.59, total records: 150073 
    Average version length: 69.17, total versions: 62072, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 3, data page slots: 3944 
    Data pages: 3080, average fill: 56% 
    Primary pages: 3080, secondary pages: 0, swept pages: 410 
    Empty pages: 481, full pages: 1813 
    Fill distribution: 
     0 - 19% = 746 
    20 - 39% = 258 
    40 - 59% = 161 
    60 - 79% = 675 
    80 - 99% = 1240 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98534, depth: 3, leaf buckets: 235, nodes: 150073 
    Average node length: 6.42, total dup: 130694, max dup: 29 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25858, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 51 
        40 - 59% = 121 
        60 - 79% = 58 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.24, total records: 7083121 
    Average version length: 68.76, total versions: 381818, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 64, data page slots: 102880 
    Data pages: 102880, average fill: 74% 
    Primary pages: 102880, secondary pages: 0, swept pages: 29346 
    Empty pages: 35, full pages: 76462 
    Fill distribution: 
     0 - 19% = 183 
    20 - 39% = 939 
    40 - 59% = 7295 
    60 - 79% = 88804 
    80 - 99% = 5659 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10723, nodes: 7083121 
    Average node length: 6.51, total dup: 6127650, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1559679, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1595 
        40 - 59% = 6023 
        60 - 79% = 2586 
        80 - 99% = 516 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8611, nodes: 7083121 
    Average node length: 5.40, total dup: 6800805, max dup: 174 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1355811, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 1238 
        40 - 59% = 4798 
        60 - 79% = 1533 
        80 - 99% = 1026 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8681, nodes: 7083121 
    Average node length: 5.40, total dup: 6800805, max dup: 174 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1358429, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1343 
        40 - 59% = 4803 
        60 - 79% = 1525 
        80 - 99% = 1005 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.20, total records: 12084177 
    Average version length: 68.71, total versions: 306649, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 104, data page slots: 168672 
    Data pages: 168672, average fill: 76% 
    Primary pages: 168672, secondary pages: 0, swept pages: 81589 
    Empty pages: 7, full pages: 153043 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 466 
    40 - 59% = 4049 
    60 - 79% = 158667 
    80 - 99% = 5444 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18374, nodes: 12084177 
    Average node length: 6.58, total dup: 10533731, max dup: 63 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2374502, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2137 
        40 - 59% = 10984 
        60 - 79% = 4455 
        80 - 99% = 772 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 43.63, total records: 1556528 
    Average version length: 69.11, total versions: 574614, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.89 
    Pointer pages: 26, data page slots: 42152 
    Data pages: 28135, average fill: 63% 
    Primary pages: 28135, secondary pages: 0, swept pages: 7295 
    Empty pages: 2819, full pages: 18054 
    Fill distribution: 
     0 - 19% = 4869 
    20 - 39% = 1781 
    40 - 59% = 1701 
    60 - 79% = 10790 
    80 - 99% = 8994 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2137, nodes: 1556528 
    Average node length: 5.51, total dup: 1493413, max dup: 99 
    Average key length: 2.56, compression ratio: 16.38 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 106488, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 584 
        40 - 59% = 1038 
        60 - 79% = 395 
        80 - 99% = 110 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.92, total records: 1030195 
    Average version length: 69.13, total versions: 419355, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.08 
    Pointer pages: 21, data page slots: 33856 
    Data pages: 27800, average fill: 43% 
    Primary pages: 27800, secondary pages: 0, swept pages: 7462 
    Empty pages: 6759, full pages: 10989 
    Fill distribution: 
     0 - 19% = 10833 
    20 - 39% = 3138 
    40 - 59% = 1766 
    60 - 79% = 4614 
    80 - 99% = 7449 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1540, nodes: 1030195 
    Average node length: 5.80, total dup: 960917, max dup: 104 
    Average key length: 2.87, compression ratio: 14.62 
    Average prefix length: 41.19, average data length: 0.81 
    Clustering factor: 139674, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 472 
        40 - 59% = 759 
        60 - 79% = 266 
        80 - 99% = 42 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.88, total records: 9168427 
    Average version length: 68.96, total versions: 401447, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 88, data page slots: 142568 
    Data pages: 142536, average fill: 69% 
    Primary pages: 142536, secondary pages: 0, swept pages: 60826 
    Empty pages: 335, full pages: 78654 
    Fill distribution: 
     0 - 19% = 1185 
    20 - 39% = 5635 
    40 - 59% = 22363 
    60 - 79% = 107614 
    80 - 99% = 5739 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13454, nodes: 9168427 
    Average node length: 6.68, total dup: 7603196, max dup: 18 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1987406, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1252 
        40 - 59% = 6957 
        60 - 79% = 4605 
        80 - 99% = 637 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21143115 
    Average version length: 82.95, total versions: 11909, 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: 318544 
    Data pages: 318544, average fill: 81% 
    Primary pages: 318544, secondary pages: 0, swept pages: 11618 
    Empty pages: 10, full pages: 318208 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 10 
    40 - 59% = 47 
    60 - 79% = 26989 
    80 - 99% = 291483 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19285, nodes: 21143115 
    Average node length: 5.72, total dup: 20662184, max dup: 137 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280323, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 7964 
        60 - 79% = 554 
        80 - 99% = 10761 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17165, nodes: 21143115 
    Average node length: 6.31, total dup: 18580934, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914123, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 780 
        60 - 79% = 253 
        80 - 99% = 16122 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21071, nodes: 21143115 
    Average node length: 6.35, total dup: 18499636, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574414, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 8244 
        60 - 79% = 601 
        80 - 99% = 12218 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16187, nodes: 21143115 
    Average node length: 5.56, total dup: 21143015, max dup: 230022 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942809, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 9 
        40 - 59% = 3064 
        60 - 79% = 402 
        80 - 99% = 12710 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.38, total records: 9575206 
    Average version length: 82.63, total versions: 352929, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 102, data page slots: 165832 
    Data pages: 165808, average fill: 71% 
    Primary pages: 165808, secondary pages: 0, swept pages: 78474 
    Empty pages: 421, full pages: 98357 
    Fill distribution: 
     0 - 19% = 1291 
    20 - 39% = 5235 
    40 - 59% = 22494 
    60 - 79% = 77439 
    80 - 99% = 59349 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11322, nodes: 9575206 
    Average node length: 5.35, total dup: 9267921, max dup: 204 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2155327, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 60 
        40 - 59% = 8563 
        60 - 79% = 2644 
        80 - 99% = 53 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13428, nodes: 9575206 
    Average node length: 6.22, total dup: 7936912, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1514138, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 4111 
        40 - 59% = 4190 
        60 - 79% = 2563 
        80 - 99% = 2444 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12635, nodes: 9575206 
    Average node length: 5.97, total dup: 8305954, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2341337, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 67 
        40 - 59% = 9525 
        60 - 79% = 2957 
        80 - 99% = 85 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9897, nodes: 9575206 
    Average node length: 5.12, total dup: 9575106, max dup: 162476 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1533370, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 56 
        20 - 39% = 1166 
        40 - 59% = 4785 
        60 - 79% = 1738 
        80 - 99% = 2152 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.26, total records: 11206072 
    Average version length: 82.54, total versions: 277231, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 191848 
    Data pages: 190432, average fill: 72% 
    Primary pages: 190432, secondary pages: 0, swept pages: 75601 
    Empty pages: 3298, full pages: 139859 
    Fill distribution: 
     0 - 19% = 5629 
    20 - 39% = 8220 
    40 - 59% = 18877 
    60 - 79% = 43488 
    80 - 99% = 114218 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13108, nodes: 11206072 
    Average node length: 5.30, total dup: 11096402, max dup: 643 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2335175, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 103 
        40 - 59% = 9518 
        60 - 79% = 3384 
        80 - 99% = 102 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10333, nodes: 11206072 
    Average node length: 5.49, total dup: 10716350, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 705060, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 165 
        20 - 39% = 883 
        40 - 59% = 2436 
        60 - 79% = 1864 
        80 - 99% = 4985 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14997, nodes: 11206072 
    Average node length: 6.02, total dup: 9775174, max dup: 81 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2351665, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 132 
        40 - 59% = 11061 
        60 - 79% = 3677 
        80 - 99% = 124 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10627, nodes: 11206072 
    Average node length: 5.22, total dup: 11205972, max dup: 203245 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 693758, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 840 
        40 - 59% = 4628 
        60 - 79% = 1521 
        80 - 99% = 3545 
 
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: 79.74, total records: 9687902 
    Average version length: 82.92, total versions: 351815, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 105, data page slots: 170856 
    Data pages: 170816, average fill: 70% 
    Primary pages: 170816, secondary pages: 0, swept pages: 86070 
    Empty pages: 426, full pages: 95935 
    Fill distribution: 
     0 - 19% = 1536 
    20 - 39% = 6739 
    40 - 59% = 26047 
    60 - 79% = 79744 
    80 - 99% = 56750 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11744, nodes: 9687902 
    Average node length: 5.16, total dup: 9659229, max dup: 1777 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1952286, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1572 
        40 - 59% = 7747 
        60 - 79% = 1846 
        80 - 99% = 552 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13555, nodes: 9687902 
    Average node length: 6.23, total dup: 8029651, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1470979, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 4127 
        40 - 59% = 4167 
        60 - 79% = 2550 
        80 - 99% = 2549 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12365, nodes: 9687902 
    Average node length: 5.42, total dup: 9252799, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2084068, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1479 
        40 - 59% = 8712 
        60 - 79% = 1593 
        80 - 99% = 549 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10130, nodes: 9687902 
    Average node length: 5.13, total dup: 9687802, max dup: 164032 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1550023, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1284 
        40 - 59% = 5005 
        60 - 79% = 1717 
        80 - 99% = 2086 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.45, total records: 575189 
    Average version length: 68.83, total versions: 6082, 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: 7944 
    Data pages: 7944, average fill: 76% 
    Primary pages: 7944, secondary pages: 0, swept pages: 3892 
    Empty pages: 0, full pages: 6842 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 6 
    40 - 59% = 128 
    60 - 79% = 7718 
    80 - 99% = 91 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39438, depth: 3, leaf buckets: 736, nodes: 575189 
    Average node length: 5.95, total dup: 489623, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100347, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 528 
        60 - 79% = 86 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31290, depth: 3, leaf buckets: 764, nodes: 575189 
    Average node length: 6.15, total dup: 471702, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100398, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 549 
        60 - 79% = 83 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 557, nodes: 575189 
    Average node length: 4.86, total dup: 575089, max dup: 9492 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89099, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 302 
        60 - 79% = 86 
        80 - 99% = 136 
 
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 Sat Mar 30 19:11:52 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7747407 76736 1 0.0000 0.0000
DOC_LIST 2246045 76077 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 231566 605 57800.0000 0.0000
INVNT_TURNOVER_LOG 47460 44315 1 0.0000 0.0000
MONEY_SALDO 49 18592 984 37900.0000 0.0000
MONEY_TURNOVER_LOG 920 893 1 0.0000 0.0000
PDISTR 804885 63700 4 0.0000 0.0000
PERF_SPLIT_0 181602 19489 1 0.0000 0.0000
PERF_SPLIT_1 150498 3802 1 0.0000 0.0000
PERF_SPLIT_2 159442 5054 1 0.0000 0.0000
PERF_SPLIT_3 151237 4385 1 0.0000 0.0000
PERF_SPLIT_4 178893 12004 1 0.0000 0.0000
PERF_SPLIT_5 162247 12178 1 0.0000 0.0000
PERF_SPLIT_6 158123 6874 1 0.0000 0.0000
PERF_SPLIT_7 164644 4822 1 0.0000 0.0000
PERF_SPLIT_8 176897 6210 1 0.0000 0.0000
PERF_SPLIT_9 163326 5039 1 0.0000 0.0000
PSTORNED 2099208 35555 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 150073 62072 1 0.0000 0.0000
XQD_1000_3300 7083121 381818 1 0.0000 0.0000
XQD_1200_2000 12084177 306649 1 0.0000 0.0000
XQD_2000_3300 1556528 574614 1 0.0000 0.0000
XQD_2100_3300 1030195 419355 1 0.0000 0.0000
XQD_3300_3400 9168427 401447 1 0.0000 0.0000
XQS_1000_1200 21143115 11909 1 0.0000 0.0000
XQS_1000_3300 9575206 352929 1 0.0000 0.0000
XQS_1200_2000 11206072 277231 1 0.0000 0.0000
XQS_2100_3300 9687902 351815 1 0.0000 0.0000
XQS_3300_3400 575189 6082 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 ---
:575: 
:576: mscs-test-161.budzdorov.ru    Sat Mar 30 19:09:47 2024
:577:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:578: 
:579: 
:580: mscs-test-161.budzdorov.ru    Sat Mar 30 19:09:47 2024
:581:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:582: 
--- end of diff output ---

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

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