Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.03.2024 19:11
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 15886180 kB
MemAvailable 30287016 kB
Buffers 0 kB
Cached 15874100 kB
SwapCached 2704 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-13 19:09:51
DTS_END                         2024-03-13 19:09:51.4020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45704
TRN_ID                          172951
ATT_ID                          584
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: 9228.64 20190 922864
customer order: creation 172.46 390 17246
customer order: refuse 14.39 427 1439
order to supplier: creation 46.10 1329 4610
order to supplier: removal 3.69 97949 369
invoice (draft): creation 45.75 3469 4575
invoice (draft): removal 50.68 846 5068
invoice accept: apply 42.28 21806 4228
invoice accept: cancel 45.47 886 4547
customer reserve: creation 4061.11 210 406111
customer reserve: removal 4448.29 63 444829
realization accept: apply 83.41 197 8341
realization accept: cancel 84.62 118 8462
payment from customer: creation 59.89 107 5989
payment from customer: removal 6.20 66 620
payment to supplier: creation 48.56 140 4856
payment to supplier: removal 3.51 71 351
service: total inventory turnovers 4.82 1042 482
service: total monetary turnovers 6.59 34 659
service: aggregate perf. data 0.79 20256 79
service: refresh index statistics 0.03 254393 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-03-2024 19:11:41 to 13-03-2024 19:11:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4339
TEST_TIME 2 4590
TEST_TIME 3 4608
TEST_TIME 4 3837
TEST_TIME 5 3982
TEST_TIME 6 3755
TEST_TIME 7 4046
TEST_TIME 8 4757
TEST_TIME 9 4656
TEST_TIME 10 5194
TEST_TIME 11 5082
TEST_TIME 12 5203
TEST_TIME 13 5316
TEST_TIME 14 5344
TEST_TIME 15 5722
TEST_TIME 16 6005
TEST_TIME 17 6418
TEST_TIME 18 6897
TEST_TIME 19 7219
TEST_TIME 20 7420
TEST_TIME 21 7747
TEST_TIME 22 7926
TEST_TIME 23 7905
TEST_TIME 24 8178
TEST_TIME 25 8107
TEST_TIME 26 8250
TEST_TIME 27 8556
TEST_TIME 28 9237
TEST_TIME 29 9593
TEST_TIME 30 9360
TEST_TIME 31 9261
TEST_TIME 32 9111
TEST_TIME 33 9067
TEST_TIME 34 9003
TEST_TIME 35 8893
TEST_TIME 36 8881
TEST_TIME 37 8924
TEST_TIME 38 8811
TEST_TIME 39 8818
TEST_TIME 40 8888
TEST_TIME 41 9002
TEST_TIME 42 8999
TEST_TIME 43 8893
TEST_TIME 44 8938
TEST_TIME 45 9102
TEST_TIME 46 9101
TEST_TIME 47 9115
TEST_TIME 48 9089
TEST_TIME 49 9019
TEST_TIME 50 9118
TEST_TIME 51 9237
TEST_TIME 52 9181
TEST_TIME 53 9216
TEST_TIME 54 9374
TEST_TIME 55 9345
TEST_TIME 56 9349
TEST_TIME 57 9222
TEST_TIME 58 9147
TEST_TIME 59 9079
TEST_TIME 60 9086
TEST_TIME 61 9022
TEST_TIME 62 8952
TEST_TIME 63 9055
TEST_TIME 64 9029
TEST_TIME 65 9041
TEST_TIME 66 9056
TEST_TIME 67 9090
TEST_TIME 68 9142
TEST_TIME 69 9138
TEST_TIME 70 9145
TEST_TIME 71 9238
TEST_TIME 72 9292
TEST_TIME 73 9307
TEST_TIME 74 9325
TEST_TIME 75 9307
TEST_TIME 76 9317
TEST_TIME 77 9252
TEST_TIME 78 9241
TEST_TIME 79 9210
TEST_TIME 80 9195
TEST_TIME 81 9109
TEST_TIME 82 9071
TEST_TIME 83 9015
TEST_TIME 84 9128
TEST_TIME 85 9146
TEST_TIME 86 9118
TEST_TIME 87 9167
TEST_TIME 88 9236
TEST_TIME 89 9197
TEST_TIME 90 9189
TEST_TIME 91 9267
TEST_TIME 92 9226
TEST_TIME 93 9305
TEST_TIME 94 9325
TEST_TIME 95 9389
TEST_TIME 96 9421
TEST_TIME 97 9363
TEST_TIME 98 9300
TEST_TIME 99 9292
TEST_TIME 100 9234

Performance per minute, chart


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

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 1294993 1294993 0 0.00 0 14017 7 0 0
doc_list_biud 1294993 1294993 0 0.00 0 34701 28 0 0
sp_add_invoice_to_stock 4330 4228 102 2.35 35 222713 21807 0 102
sp_cancel_adding_invoice 4547 4547 0 0.00 4 61611 887 0 0
sp_cancel_client_order 1439 1439 0 0.00 4 26119 428 0 0
sp_cancel_customer_reserve 444829 444829 0 0.00 0 34576 64 0 0
sp_cancel_pay_from_customer 620 620 0 0.00 3 1945 66 0 0
sp_cancel_pay_to_supplier 351 351 0 0.00 3 2986 72 0 0
sp_cancel_supplier_invoice 5075 5068 7 0.13 1 18587 847 0 7
sp_cancel_supplier_order 369 369 0 0.00 9 749922 97949 0 0
sp_cancel_write_off 8462 8462 0 0.00 1 13769 118 0 0
sp_client_order 17246 17246 0 0.00 3 35084 390 0 0
sp_customer_reserve 406111 406111 0 0.00 0 50627 211 0 0
sp_fill_shopping_cart 26425 26425 0 0.00 1 18835 38 0 0
sp_fill_shopping_cart_clo_res 406106 406106 0 0.00 0 34219 17 0 0
sp_get_clo_for_invoice 4220 4220 0 0.00 0 25243 293 0 0
sp_kill_cost_storno 13980 13980 0 0.00 0 9053 62 0 0
sp_kill_qstorno_ret_qs2qd 903557 903557 0 0.00 0 34570 35 0 0
sp_kill_qty_storno 477274 477274 0 0.00 0 34700 75 0 0
sp_lock_selected_doc 17412 17412 0 0.00 0 9068 5 0 0
sp_make_cost_storno 23405 23405 0 0.00 0 14000 56 0 0
sp_multiply_rows_for_pdistr 23405 23405 0 0.00 0 8424 31 0 0
sp_multiply_rows_for_qdistr 17246 17246 0 0.00 0 14821 175 0 0
sp_pay_from_customer 5989 5989 0 0.00 4 10850 107 0 0
sp_pay_to_supplier 4856 4856 0 0.00 5 14024 141 0 0
sp_payment_common 10845 10845 0 0.00 1 12605 27 0 0
sp_qd_handle_on_cancel_clo 1439 1439 0 0.00 0 26111 398 0 0
sp_qd_handle_on_invoice_upd_sts 8766 8766 0 0.00 0 34699 333 0 0
sp_qd_handle_on_reserve_upd_sts 8341 8341 0 0.00 0 20217 73 0 0
sp_reserve_write_off 8341 8341 0 0.00 6 20242 197 0 0
sp_supplier_invoice 4575 4575 0 0.00 6 90520 3469 0 0
sp_supplier_order 4610 4610 0 0.00 5 38113 1330 0 0
srv_aggregate_perf_data 80 79 1 1.25 2041 377349 20256 0 1
srv_fill_mon_cache_memory 55 55 0 0.00 1516 153053 41474 0 0
srv_find_qd_qs_mism 880230 880230 0 0.00 0 12009 6 0 0
srv_make_invnt_saldo 482 482 0 0.00 45 52774 1042 0 0
srv_make_money_saldo 659 659 0 0.00 1 4991 34 0 0
srv_recalc_idx_stat 3 3 0 0.00 114250 425663 254394 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4228 4228 0 0.00 0 8494 164 0 0
t$perf-norm:sp_cancel_adding_invoice 343 343 0 0.00 0 3493 97 0 0
t$perf-norm:sp_cancel_client_order 1439 1439 0 0.00 0 1851 13 0 0
t$perf-norm:sp_cancel_customer_reserve 592 592 0 0.00 0 7819 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 620 620 0 0.00 0 793 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 351 351 0 0.00 0 9275 32 0 0
t$perf-norm:sp_cancel_supplier_invoice 344 344 0 0.00 0 1783 18 0 0
t$perf-norm:sp_cancel_supplier_order 369 369 0 0.00 0 23434 1670 0 0
t$perf-norm:sp_cancel_write_off 794 794 0 0.00 0 251 3 0 0
t$perf-norm:sp_client_order 17246 17246 0 0.00 0 7833 14 0 0
t$perf-norm:sp_customer_reserve 877 877 0 0.00 0 2733 11 0 0
t$perf-norm:sp_pay_from_customer 5989 5989 0 0.00 0 3328 8 0 0
t$perf-norm:sp_pay_to_supplier 4856 4856 0 0.00 0 3240 9 0 0
t$perf-norm:sp_reserve_write_off 8341 8341 0 0.00 0 3685 8 0 0
t$perf-norm:sp_supplier_invoice 4575 4575 0 0.00 0 5519 17 0 0
t$perf-norm:sp_supplier_order 4610 4610 0 0.00 0 4872 15 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 380 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 28 1 0 0
t$perf-norm:srv_make_invnt_saldo 482 482 0 0.00 0 1423 27 0 0
t$perf-norm:srv_make_money_saldo 659 659 0 0.00 0 949 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 4 4 0 0
v_add_invoice_to_stock 8642 8438 204 2.36 0 3848 18 0 204
v_all_customers 32004 32004 0 0.00 0 78 1 0 0
v_all_suppliers 26066 26066 0 0.00 0 79 1 0 0
v_all_wares 34492 34492 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 686 686 0 0.00 0 2356 14 0 0
v_cancel_client_order 2878 2878 0 0.00 0 6261 9 0 0
v_cancel_customer_prepayment 1240 1240 0 0.00 0 1235 6 0 0
v_cancel_customer_reserve 1184 1184 0 0.00 0 494 4 0 0
v_cancel_payment_to_supplier 702 702 0 0.00 0 2964 12 0 0
v_cancel_supplier_invoice 702 688 14 1.99 0 1673 18 0 14
v_cancel_supplier_order 738 738 0 0.00 0 5723 15 0 0
v_cancel_write_off 1588 1588 0 0.00 0 8307 23 0 0
v_max_id_clo_ord 4608 4608 0 0.00 0 10515 4 0 0
v_max_id_clo_res 877 877 0 0.00 0 7169 38 0 0
v_max_id_ord_sup 4569 4569 0 0.00 0 5375 3 0 0
v_max_non_paid_invoice 1000 1000 0 0.00 0 915 4 0 0
v_max_non_paid_realizn 2884 2884 0 0.00 0 4543 7 0 0
v_min_id_clo_ord 4608 4608 0 0.00 0 9027 13 0 0
v_min_id_clo_res 877 877 0 0.00 0 1368 7 0 0
v_min_id_ord_sup 4569 4569 0 0.00 0 3354 6 0 0
v_min_non_paid_invoice 4856 4856 0 0.00 0 12600 20 0 0
v_min_non_paid_realizn 5989 5989 0 0.00 0 7759 21 0 0
v_our_firm 8698 8698 0 0.00 0 18 1 0 0
v_reserve_write_off 16682 16682 0 0.00 0 5591 7 0 0
x_lock_depdocs_on_canc_invoice 9271 9271 0 0.00 0 11968 138 0 0
x_lock_depdocs_on_canc_sup_ord 369 369 0 0.00 0 8647 309 0 0
x_make_qstorno_1000_1200 4610 4610 0 0.00 1 38101 1239 0 0
x_make_qstorno_1200_2000 4575 4575 0 0.00 3 90491 3338 0 0
x_make_qstorno_2100_3300 406111 406111 0 0.00 0 50627 191 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-03-2024 19:11:49 to 13-03-2024 19:11:53.

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:54 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:55 36895 8192000000 9910661408 10224484352 986271136 10.745 100 90 180 0 1016018784 6550128 23197520
17:12:37 15741 8192000000 9943246448 10267258880 1027567472 11.145 100 82 164 0 1058045440 9247984 21229984
17:14:00 11026 8192000000 9967386816 10295693312 1048875136 11.350 100 88 175 0 1080921744 9981600 22065008
17:15:18 11606 8192000000 10019499792 10363461632 1102099280 11.858 100 88 176 0 1134991952 11338640 21554032
17:16:35 7645 8192000000 10061649744 10417938432 1144735952 12.260 100 79 158 1 1175465920 12404864 18325104
17:17:46 3925 8192000000 10115567904 10480771072 1198626480 12.764 100 75 151 0 1229127392 13771312 16729600
17:18:52 1428 8192000000 10164661552 10536484864 1248118800 13.221 100 92 177 0 1280211792 12704544 19388448
17:19:56 1781 8192000000 10183633072 10562031616 1269203952 13.414 100 88 175 1 1301496944 13645648 18647344
17:20:59 1223 8192000000 10211739296 10597761024 1300355968 13.698 100 91 180 0 1333125744 12239520 20530256
17:22:02 41914 8192000000 10183464368 10603114496 1305242096 13.743 100 42 82 0 1323617648 9465392 8910160
17:23:52 5767 8192000000 10200507520 10615304192 1313269088 13.816 100 22 44 0 1324438160 6116736 5052336
17:24:58 11933 8192000000 10212696288 10626637824 1323369552 13.907 100 19 38 0 1333958336 6111264 4477520
17:26:11 12717 8192000000 10219902416 10639294464 1331393488 13.980 100 20 40 0 1341930560 5917280 4619792
17:27:26 41831 8192000000 10219782128 10647273472 1335616784 14.018 100 18 34 0 1345629808 5774896 4238128
17:29:17 6201 8192000000 10209463808 10625978368 1313859024 13.821 99 25 50 0 1325712368 6664656 5188688
17:30:28 23762 8192000000 10233349440 10642923520 1305136160 13.742 98 53 105 0 1324945904 8416736 11393008
17:32:07 12074 8192000000 10230325824 10642030592 1319026528 13.868 99 49 97 0 1339363680 9305968 11031184
17:33:26 91009 8192000000 10226224368 10640977920 1303651536 13.728 97 37 74 0 1325736928 13292320 8793072
17:36:15 40182 8192000000 10247805040 10662232064 1337714784 14.037 100 48 96 0 1365675408 17022272 10938352
17:37:58 29127 8192000000 10256200976 10673696768 1335580576 14.018 99 38 76 0 1359779712 15238928 8960208
17:39:33 10854 8192000000 10271098304 10678554624 1354621664 14.189 100 62 121 0 1383849504 14877920 14349920
17:40:54 3763 8192000000 10238661920 10631741440 1312762368 13.811 98 70 140 0 1348991616 19194208 17035040
17:42:01 9813 8192000000 10238381200 10637393920 1307668160 13.765 99 52 104 0 1344061104 23651360 12741584
17:43:17 11428 8192000000 10252300688 10651324416 1316235968 13.843 99 40 77 0 1354166416 27537040 10393408
17:44:34 3626 8192000000 10287048912 10686263296 1344830672 14.101 100 66 131 0 1392076576 31451168 15794736
17:45:55 2741 8192000000 10290616368 10685435904 1346321264 14.114 100 87 169 1 1395697984 29332560 20044160
17:47:04 3519 8192000000 10300836000 10697723904 1351514032 14.161 100 86 168 0 1404150928 31829040 20807856
17:48:14 1571 8192000000 10305377936 10705760256 1358741744 14.226 100 82 164 0 1410139024 31351648 20045632
17:49:20 3161 8192000000 10315044336 10719285248 1364503440 14.278 100 78 156 0 1415691648 31601728 19586480
17:50:26 1510 8192000000 10320811680 10727927808 1378684640 14.405 100 72 143 0 1424380464 28327808 17368016
17:51:30 14198 8192000000 10301438432 10722238464 1360736720 14.244 98 38 76 0 1395174048 24286224 10151104
17:52:52 12879 8192000000 10321623552 10744721408 1388742768 14.495 100 40 80 0 1428620048 29416608 10460672
17:54:08 33060 8192000000 10325170336 10753474560 1375309152 14.375 99 31 62 3 1421675360 37299056 9067152
17:55:47 28406 8192000000 10315246928 10753835008 1375228272 14.374 100 23 46 0 1418659248 36659616 6771360
17:57:29 30361 8192000000 10292039408 10749702144 1361758848 14.253 99 11 22 0 1395036384 30049008 3228528
17:59:07 8182 8192000000 10306277040 10730987520 1381780480 14.432 100 63 125 1 1401751648 5848800 14122368
18:00:23 137141 8192000000 10291420128 10745790464 1383912688 14.452 100 32 64 1 1401770800 10050256 7807856
18:03:48 16734 8192000000 10294605392 10744643584 1391417072 14.519 100 20 35 0 1401281760 6473552 3391136
18:05:12 6564 8192000000 10328946432 10762141696 1400239088 14.597 100 57 112 1 1429123408 16129232 12755088
18:06:25 30990 8192000000 10302216944 10758287360 1397193232 14.570 100 16 31 0 1414544672 13368016 3983424
18:08:06 31113 8192000000 10316042016 10771496960 1412761936 14.708 100 22 44 0 1435878544 18227776 4888832
18:09:42 44206 8192000000 10318851840 10770649088 1408886368 14.674 100 17 34 0 1427574736 14679744 4008624
18:11:31 43875 8192000000 10303461872 10758266880 1396050752 14.560 99 13 26 0 1405908128 6857312 3000064
18:13:18 36737 8192000000 10315361056 10777317376 1409757216 14.682 100 14 28 0 1421893008 9420768 2715024
18:14:56 84618 8192000000 10301057968 10756263936 1353007792 14.175 96 15 30 0 1365912016 10025136 2879088
18:17:45 22438 8192000000 10309618448 10742308864 1367583776 14.305 98 50 96 1 1386999744 7435632 11980336
18:19:12 44682 8192000000 10293440960 10737197056 1352043536 14.166 97 42 84 0 1376753440 15580912 9128992
18:21:00 18223 8192000000 10263392048 10700140544 1296281776 13.661 94 29 59 0 1312009824 9177424 6550624
18:22:21 56215 8192000000 10289908080 10743308288 1370084864 14.328 99 18 37 0 1388409168 14116912 4207392
18:24:22 92597 8192000000 10281592192 10715656192 1270682352 13.428 92 16 32 0 1286736624 12573632 3480640
18:26:56 109106 8192000000 10247990928 10688679936 1311656096 13.801 97 36 70 1 1332926624 13267632 8002896
18:29:51 62435 8192000000 10254019936 10706132992 1340551504 14.062 98 16 32 0 1353207728 8895856 3760368
18:31:54 53512 8192000000 10233667696 10683961344 1315201216 13.833 98 21 40 0 1334707648 14319360 5187072
18:33:52 42679 8192000000 10258917008 10709053440 1332667200 13.991 98 23 45 0 1348911488 10753888 5490400
18:35:37 62435 8192000000 10248716016 10683793408 1288309168 13.589 95 23 44 1 1302331856 8601136 5421552
18:37:47 44434 8192000000 10264084672 10699874304 1322354640 13.898 98 19 38 1 1338001296 11128976 4517680
18:39:35 31316 8192000000 10276799536 10723119104 1361968832 14.255 100 15 30 0 1379716944 14303904 3444208
18:41:39 30926 8192000000 10278819376 10723987456 1366129840 14.292 100 33 66 0 1384815984 11782176 6903968
18:43:36 75821 8192000000 10304023472 10735484928 1376597888 14.386 100 26 52 0 1392116480 9845456 5673136
18:45:56 102695 8192000000 10301307664 10751537152 1390456832 14.510 100 39 78 0 1412364752 13177248 8730672
18:48:52 39023 8192000000 10289046208 10752012288 1390357472 14.509 100 17 34 0 1409043440 14615136 4070832
18:50:45 76950 8192000000 10291865440 10751016960 1392405232 14.527 100 8 16 0 1403570240 8786848 2378160
18:54:01 41953 8192000000 10282051520 10745548800 1372621568 14.351 98 15 31 0 1389131392 13507760 3002064
18:55:48 29197 8192000000 10296402176 10743504896 1366415168 14.295 98 38 76 2 1384795008 9393472 8986368
18:57:27 65521 8192000000 10313064384 10762293248 1399347536 14.589 100 29 59 0 1414753424 8829760 6576128
18:59:33 22769 8192000000 10302888672 10746511360 1358314912 14.222 97 31 62 0 1376482272 11482416 6684944
19:01:02 49800 8192000000 10311270016 10754523136 1349916576 14.147 97 30 60 0 1367005472 10315744 6773152
19:02:52 80221 8192000000 10302398448 10763567104 1370769504 14.334 98 12 22 1 1388626624 15325920 2531200
19:05:14 153053 8192000000 10302820464 10752987136 1368610048 14.315 98 17 34 1 1386688048 14376512 3701488
19:08:53 65765 8192000000 9898666720 10296709120 997502880 10.854 72 20 40 0 1016996512 15662032 3831600

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 13-03-2024 19:11:55 to 13-03-2024 19:12:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 102 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-03-2024 19:12:09 to 13-03-2024 19:12:11.

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          173264
MON$OLDEST_ACTIVE               173265
MON$OLDEST_SNAPSHOT             173265
MON$NEXT_TRANSACTION            173265
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                       1896480
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Wed Mar 13 19:12:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        90156 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    173264 
    Oldest active        173265 
    Oldest snapshot        173265 
    Next transaction    173266 
    Sequence number        0 
    Next attachment ID    703 
    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.44, total records: 7722239 
    Average version length: 48.16, total versions: 72363, 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: 86544 
    Data pages: 86544, average fill: 71% 
    Primary pages: 86544, secondary pages: 0, swept pages: 29887 
    Empty pages: 3, full pages: 55898 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 218 
    40 - 59% = 2355 
    60 - 79% = 83917 
    80 - 99% = 26 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23299, nodes: 7722239 
    Average node length: 18.88, 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: 1712779, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 366 
        20 - 39% = 1970 
        40 - 59% = 4017 
        60 - 79% = 2456 
        80 - 99% = 14490 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13515, nodes: 7722239 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1535050, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1699 
        40 - 59% = 1946 
        60 - 79% = 1118 
        80 - 99% = 8751 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8329, nodes: 7722239 
    Average node length: 6.61, total dup: 5778352, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1528126, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 1040 
        40 - 59% = 1302 
        60 - 79% = 943 
        80 - 99% = 4924 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.50, total records: 2234491 
    Average version length: 34.63, total versions: 72209, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28232 
    Data pages: 28232, average fill: 73% 
    Primary pages: 28224, secondary pages: 8, swept pages: 13160 
    Empty pages: 7, full pages: 19562 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 113 
    40 - 59% = 1453 
    60 - 79% = 26092 
    80 - 99% = 558 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4556, nodes: 2234491 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688826, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 946 
        40 - 59% = 818 
        60 - 79% = 742 
        80 - 99% = 2050 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2497, nodes: 2236627 
    Average node length: 4.97, total dup: 2235728, max dup: 17879 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1241793, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 260 
        40 - 59% = 1506 
        60 - 79% = 528 
        80 - 99% = 201 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2015, nodes: 2234491 
    Average node length: 4.97, total dup: 2234441, max dup: 130308 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053434, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 89 
        40 - 59% = 1031 
        60 - 79% = 59 
        80 - 99% = 832 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4352, nodes: 2234491 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688826, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 609 
        40 - 59% = 591 
        60 - 79% = 821 
        80 - 99% = 2224 
 
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.43, total records: 400 
    Average version length: 22.71, total versions: 237863, max versions: 620 
    Average fragment length: 2.00, total fragments: 49, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1304 
    Data pages: 1304, average fill: 90% 
    Primary pages: 7, secondary pages: 1297, swept pages: 0 
    Empty pages: 0, full pages: 1303 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1302 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 7.18, total records: 84583 
    Average version length: 68.28, total versions: 75693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 12.25 
    Pointer pages: 7, data page slots: 2680 
    Data pages: 1720, average fill: 61% 
    Primary pages: 1719, secondary pages: 1, swept pages: 59 
    Empty pages: 267, full pages: 980 
    Fill distribution: 
     0 - 19% = 353 
    20 - 39% = 159 
    40 - 59% = 133 
    60 - 79% = 240 
    80 - 99% = 835 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703829, depth: 3, leaf buckets: 376, nodes: 84583 
    Average node length: 13.28, total dup: 6029, max dup: 2 
    Average key length: 10.73, compression ratio: 2.52 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 63796, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 275 
        40 - 59% = 91 
        60 - 79% = 9 
        80 - 99% = 0 
 
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: 17659, max versions: 923 
    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: 64 
    Data pages: 64, average fill: 88% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.05, total records: 1785 
    Average version length: 43.29, total versions: 1665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 19.03 
    Pointer pages: 1, data page slots: 56 
    Data pages: 28, average fill: 61% 
    Primary pages: 27, secondary pages: 1, swept pages: 1 
    Empty pages: 2, full pages: 12 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93596, depth: 2, leaf buckets: 3, nodes: 1785 
    Average node length: 4.36, total dup: 1687, max dup: 196 
    Average key length: 2.59, compression ratio: 7.33 
    Average prefix length: 18.46, average data length: 0.54 
    Clustering factor: 948, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.01, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.34, total records: 800463 
    Average version length: 25.46, total versions: 58229, max versions: 5 
    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: 8128 
    Data pages: 8128, average fill: 69% 
    Primary pages: 8107, secondary pages: 21, swept pages: 2467 
    Empty pages: 47, full pages: 4851 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 64 
    40 - 59% = 414 
    60 - 79% = 7373 
    80 - 99% = 195 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 904, nodes: 800463 
    Average node length: 4.87, total dup: 800414, max dup: 147383 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89308, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 149 
        40 - 59% = 515 
        60 - 79% = 193 
        80 - 99% = 47 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 997, nodes: 800463 
    Average node length: 5.88, total dup: 712800, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159612, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 117 
        40 - 59% = 512 
        60 - 79% = 112 
        80 - 99% = 250 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1057, nodes: 800463 
    Average node length: 5.88, total dup: 712800, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161623, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 240 
        40 - 59% = 503 
        60 - 79% = 92 
        80 - 99% = 222 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1154, nodes: 800463 
    Average node length: 5.96, total dup: 712800, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154380, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 267 
        40 - 59% = 602 
        60 - 79% = 205 
        80 - 99% = 80 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5425 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.53, total fragments: 58, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 71, secondary pages: 17, swept pages: 62 
    Empty pages: 7, full pages: 65 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5425 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.60, compression ratio: 9.98 
    Average prefix length: 34.35, average data length: 1.56 
    Clustering factor: 5083, 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: 5425 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 154, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 79074 
    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: 6, full pages: 761 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 761 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37748, depth: 2, leaf buckets: 100, nodes: 79074 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3022, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        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.57, 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: 132.50, total records: 182478 
    Average version length: 153.84, total versions: 22189, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.80 
    Pointer pages: 6, data page slots: 6464 
    Data pages: 4392, average fill: 87% 
    Primary pages: 4392, secondary pages: 0, swept pages: 1 
    Empty pages: 53, full pages: 4321 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4320 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 111.40, total records: 234400 
    Average version length: 154.26, total versions: 61648, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.22 
    Pointer pages: 7, data page slots: 6952 
    Data pages: 5736, average fill: 87% 
    Primary pages: 5735, secondary pages: 1, swept pages: 1 
    Empty pages: 127, full pages: 5558 
    Fill distribution: 
     0 - 19% = 132 
    20 - 39% = 12 
    40 - 59% = 20 
    60 - 79% = 13 
    80 - 99% = 5559 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 139.88, total records: 182411 
    Average version length: 150.17, total versions: 13509, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 8, data page slots: 6272 
    Data pages: 4408, average fill: 86% 
    Primary pages: 4408, secondary pages: 0, swept pages: 3 
    Empty pages: 72, full pages: 4307 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 14 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 4307 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 131.79, total records: 186941 
    Average version length: 152.13, total versions: 23960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.87 
    Pointer pages: 7, data page slots: 5080 
    Data pages: 4496, average fill: 87% 
    Primary pages: 4495, secondary pages: 1, swept pages: 6 
    Empty pages: 53, full pages: 4426 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4424 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 121.75, total records: 177407 
    Average version length: 153.93, total versions: 34232, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.93 
    Pointer pages: 8, data page slots: 4680 
    Data pages: 4272, average fill: 87% 
    Primary pages: 4272, secondary pages: 0, swept pages: 7 
    Empty pages: 44, full pages: 4202 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 12 
    80 - 99% = 4198 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 131.74, total records: 189345 
    Average version length: 152.39, total versions: 23785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.87 
    Pointer pages: 7, data page slots: 5488 
    Data pages: 4560, average fill: 86% 
    Primary pages: 4560, secondary pages: 0, swept pages: 1 
    Empty pages: 67, full pages: 4471 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4470 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 138.60, total records: 198194 
    Average version length: 150.78, total versions: 16398, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.24 
    Pointer pages: 6, data page slots: 6472 
    Data pages: 4752, average fill: 87% 
    Primary pages: 4752, secondary pages: 0, swept pages: 3 
    Empty pages: 50, full pages: 4686 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4686 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 134.13, total records: 161336 
    Average version length: 151.28, total versions: 17451, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.64 
    Pointer pages: 6, data page slots: 6600 
    Data pages: 3928, average fill: 85% 
    Primary pages: 3928, secondary pages: 0, swept pages: 1 
    Empty pages: 103, full pages: 3793 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 9 
    40 - 59% = 11 
    60 - 79% = 12 
    80 - 99% = 3793 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 135.88, total records: 182327 
    Average version length: 152.59, total versions: 17995, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.48 
    Pointer pages: 7, data page slots: 5760 
    Data pages: 4368, average fill: 87% 
    Primary pages: 4368, secondary pages: 0, swept pages: 1 
    Empty pages: 42, full pages: 4310 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4310 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 125.63, total records: 204277 
    Average version length: 153.58, total versions: 34168, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.50 
    Pointer pages: 7, data page slots: 5656 
    Data pages: 4928, average fill: 87% 
    Primary pages: 4928, secondary pages: 0, swept pages: 5 
    Empty pages: 73, full pages: 4838 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4837 
 
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: 52.08, total records: 2088935 
    Average version length: 52.87, total versions: 26386, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25304 
    Data pages: 25288, average fill: 71% 
    Primary pages: 25288, secondary pages: 0, swept pages: 11208 
    Empty pages: 283, full pages: 20603 
    Fill distribution: 
     0 - 19% = 522 
    20 - 39% = 396 
    40 - 59% = 1023 
    60 - 79% = 23128 
    80 - 99% = 219 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2587, nodes: 2088935 
    Average node length: 5.44, total dup: 1949531, max dup: 1557 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182047, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 305 
        40 - 59% = 1708 
        60 - 79% = 279 
        80 - 99% = 292 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2759, nodes: 2088935 
    Average node length: 5.69, total dup: 1874567, max dup: 70 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374674, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2441 
        60 - 79% = 285 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2157, nodes: 2088935 
    Average node length: 4.96, total dup: 2088835, max dup: 27613 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179589, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 225 
        40 - 59% = 1137 
        60 - 79% = 402 
        80 - 99% = 391 
 
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: 48.61, total records: 118686 
    Average version length: 69.16, total versions: 35334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.59 
    Pointer pages: 3, data page slots: 3872 
    Data pages: 2736, average fill: 50% 
    Primary pages: 2736, secondary pages: 0, swept pages: 475 
    Empty pages: 328, full pages: 776 
    Fill distribution: 
     0 - 19% = 488 
    20 - 39% = 411 
    40 - 59% = 710 
    60 - 79% = 619 
    80 - 99% = 508 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554456, depth: 3, leaf buckets: 215, nodes: 118686 
    Average node length: 6.52, total dup: 103180, max dup: 14 
    Average key length: 4.01, compression ratio: 10.49 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 20354, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 89 
        40 - 59% = 91 
        60 - 79% = 33 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 67.12, total records: 6949917 
    Average version length: 68.77, total versions: 185389, 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: 64, data page slots: 103280 
    Data pages: 103280, average fill: 72% 
    Primary pages: 103280, secondary pages: 0, swept pages: 58068 
    Empty pages: 10, full pages: 56791 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 458 
    40 - 59% = 7891 
    60 - 79% = 93272 
    80 - 99% = 1612 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10713, nodes: 6949917 
    Average node length: 6.51, total dup: 6012823, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1543535, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1712 
        40 - 59% = 6188 
        60 - 79% = 2416 
        80 - 99% = 391 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8542, nodes: 6949917 
    Average node length: 5.40, total dup: 6671198, max dup: 161 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1340926, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1351 
        40 - 59% = 4692 
        60 - 79% = 1596 
        80 - 99% = 895 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8608, nodes: 6949917 
    Average node length: 5.40, total dup: 6671198, max dup: 161 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1343359, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1439 
        40 - 59% = 4681 
        60 - 79% = 1576 
        80 - 99% = 905 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.77, total records: 12098189 
    Average version length: 68.71, total versions: 206772, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 105, data page slots: 170344 
    Data pages: 170344, average fill: 75% 
    Primary pages: 170344, secondary pages: 0, swept pages: 105178 
    Empty pages: 3, full pages: 141784 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 301 
    40 - 59% = 4222 
    60 - 79% = 162422 
    80 - 99% = 3379 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18425, nodes: 12098189 
    Average node length: 6.60, total dup: 10546011, max dup: 58 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2372335, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2170 
        40 - 59% = 10897 
        60 - 79% = 4535 
        80 - 99% = 793 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 52.14, total records: 1228444 
    Average version length: 69.12, total versions: 302152, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.42 
    Pointer pages: 26, data page slots: 41912 
    Data pages: 26688, average fill: 52% 
    Primary pages: 26687, secondary pages: 1, swept pages: 13100 
    Empty pages: 4507, full pages: 12144 
    Fill distribution: 
     0 - 19% = 6941 
    20 - 39% = 2726 
    40 - 59% = 2663 
    60 - 79% = 10052 
    80 - 99% = 4306 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2041, nodes: 1228444 
    Average node length: 5.53, total dup: 1178844, max dup: 97 
    Average key length: 2.58, compression ratio: 16.28 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 81455, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1054 
        40 - 59% = 790 
        60 - 79% = 165 
        80 - 99% = 19 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 51.12, total records: 845405 
    Average version length: 69.14, total versions: 219293, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.46 
    Pointer pages: 21, data page slots: 33800 
    Data pages: 26720, average fill: 37% 
    Primary pages: 26720, secondary pages: 0, swept pages: 9839 
    Empty pages: 5764, full pages: 3295 
    Fill distribution: 
     0 - 19% = 9484 
    20 - 39% = 4299 
    40 - 59% = 6153 
    60 - 79% = 5110 
    80 - 99% = 1674 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1481, nodes: 845405 
    Average node length: 5.81, total dup: 787538, max dup: 99 
    Average key length: 2.90, compression ratio: 14.50 
    Average prefix length: 41.17, average data length: 0.83 
    Clustering factor: 121922, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 742 
        40 - 59% = 630 
        60 - 79% = 99 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.51, total records: 8861773 
    Average version length: 68.96, total versions: 178012, 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: 87, data page slots: 141840 
    Data pages: 141816, average fill: 67% 
    Primary pages: 141815, secondary pages: 1, swept pages: 93610 
    Empty pages: 424, full pages: 63593 
    Fill distribution: 
     0 - 19% = 1574 
    20 - 39% = 7193 
    40 - 59% = 24555 
    60 - 79% = 106442 
    80 - 99% = 2052 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13484, nodes: 8861773 
    Average node length: 6.68, total dup: 7347280, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1897864, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1627 
        40 - 59% = 7311 
        60 - 79% = 4186 
        80 - 99% = 360 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21124122 
    Average version length: 82.99, total versions: 3690, 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: 318496 
    Data pages: 318496, average fill: 81% 
    Primary pages: 318496, secondary pages: 0, swept pages: 13419 
    Empty pages: 40, full pages: 317309 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 59 
    40 - 59% = 167 
    60 - 79% = 27972 
    80 - 99% = 290228 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19517, nodes: 21124122 
    Average node length: 5.72, total dup: 20643602, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276241, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8464 
        60 - 79% = 509 
        80 - 99% = 10539 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17154, nodes: 21124122 
    Average node length: 6.31, total dup: 18563387, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912451, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 4 
        40 - 59% = 782 
        60 - 79% = 256 
        80 - 99% = 16105 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21270, nodes: 21124122 
    Average node length: 6.35, total dup: 18482326, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3570556, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8680 
        60 - 79% = 576 
        80 - 99% = 12012 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16134, nodes: 21124122 
    Average node length: 5.56, total dup: 21124022, max dup: 229868 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941347, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2984 
        60 - 79% = 394 
        80 - 99% = 12748 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 75.81, total records: 9933915 
    Average version length: 82.62, total versions: 795465, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 104, data page slots: 168176 
    Data pages: 168136, average fill: 73% 
    Primary pages: 168136, secondary pages: 0, swept pages: 56838 
    Empty pages: 410, full pages: 117704 
    Fill distribution: 
     0 - 19% = 1221 
    20 - 39% = 5102 
    40 - 59% = 20373 
    60 - 79% = 60128 
    80 - 99% = 81312 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11327, nodes: 9933915 
    Average node length: 5.35, total dup: 9623449, max dup: 237 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2195809, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 41 
        40 - 59% = 7406 
        60 - 79% = 3758 
        80 - 99% = 118 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13629, nodes: 9933915 
    Average node length: 6.22, total dup: 8235892, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1523533, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 3770 
        40 - 59% = 4488 
        60 - 79% = 2648 
        80 - 99% = 2602 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12644, nodes: 9933915 
    Average node length: 5.96, total dup: 8634426, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2396353, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 49 
        40 - 59% = 8347 
        60 - 79% = 4094 
        80 - 99% = 152 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10352, nodes: 9933915 
    Average node length: 5.13, total dup: 9933815, max dup: 151931 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1550166, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1199 
        40 - 59% = 5264 
        60 - 79% = 1751 
        80 - 99% = 2103 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.41, total records: 10920534 
    Average version length: 82.55, total versions: 116976, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 117, data page slots: 190016 
    Data pages: 188280, average fill: 71% 
    Primary pages: 188280, secondary pages: 0, swept pages: 84821 
    Empty pages: 3663, full pages: 132548 
    Fill distribution: 
     0 - 19% = 6366 
    20 - 39% = 9159 
    40 - 59% = 20331 
    60 - 79% = 45997 
    80 - 99% = 106427 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13096, nodes: 10920534 
    Average node length: 5.29, total dup: 10811403, max dup: 663 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2274731, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 198 
        40 - 59% = 10082 
        60 - 79% = 2760 
        80 - 99% = 54 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10153, nodes: 10920534 
    Average node length: 5.48, total dup: 10443087, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 687697, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 922 
        40 - 59% = 2441 
        60 - 79% = 1808 
        80 - 99% = 4815 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14976, nodes: 10920534 
    Average node length: 6.02, total dup: 9519836, max dup: 57 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2291069, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 237 
        40 - 59% = 11687 
        60 - 79% = 2993 
        80 - 99% = 55 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10466, nodes: 10920534 
    Average node length: 5.21, total dup: 10920434, max dup: 160389 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 676978, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 926 
        40 - 59% = 4522 
        60 - 79% = 1487 
        80 - 99% = 3415 
 
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: 74.38, total records: 10290710 
    Average version length: 82.93, total versions: 1039556, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.69 
    Pointer pages: 106, data page slots: 172904 
    Data pages: 172864, average fill: 74% 
    Primary pages: 172864, secondary pages: 0, swept pages: 33900 
    Empty pages: 710, full pages: 133019 
    Fill distribution: 
     0 - 19% = 1747 
    20 - 39% = 5553 
    40 - 59% = 19512 
    60 - 79% = 47788 
    80 - 99% = 98264 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12098, nodes: 10290710 
    Average node length: 5.17, total dup: 10261409, max dup: 2077 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2052583, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1239 
        40 - 59% = 7950 
        60 - 79% = 2201 
        80 - 99% = 678 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13810, nodes: 10290710 
    Average node length: 6.24, total dup: 8531534, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1515410, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 181 
        20 - 39% = 3379 
        40 - 59% = 4663 
        60 - 79% = 2615 
        80 - 99% = 2972 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12722, nodes: 10290710 
    Average node length: 5.42, total dup: 9840416, max dup: 126 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2193867, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 1184 
        40 - 59% = 8913 
        60 - 79% = 1931 
        80 - 99% = 678 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10621, nodes: 10290710 
    Average node length: 5.14, total dup: 10290610, max dup: 158668 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1597010, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1103 
        40 - 59% = 5411 
        60 - 79% = 1828 
        80 - 99% = 2246 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.53, total records: 581354 
    Average version length: 68.78, total versions: 13961, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 7952 
    Data pages: 7952, average fill: 77% 
    Primary pages: 7952, secondary pages: 0, swept pages: 2581 
    Empty pages: 0, full pages: 7428 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 12 
    40 - 59% = 114 
    60 - 79% = 7537 
    80 - 99% = 289 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45699, depth: 3, leaf buckets: 734, nodes: 581354 
    Average node length: 5.95, total dup: 495190, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101183, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 507 
        60 - 79% = 109 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35077, depth: 3, leaf buckets: 753, nodes: 581354 
    Average node length: 6.15, total dup: 476969, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101240, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 510 
        60 - 79% = 110 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 580, nodes: 581354 
    Average node length: 4.86, total dup: 581254, max dup: 9895 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89833, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 338 
        60 - 79% = 106 
        80 - 99% = 108 
 
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 Wed Mar 13 19:12:36 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7722239 72363 1 0.0000 0.0000
DOC_LIST 2234491 72209 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237863 620 59400.0000 0.0000
INVNT_TURNOVER_LOG 84583 75693 1 0.0000 0.0000
MONEY_SALDO 49 17659 923 36000.0000 0.0000
MONEY_TURNOVER_LOG 1785 1665 1 0.0000 0.0000
PDISTR 800463 58229 5 0.0000 0.0000
PERF_SPLIT_0 182478 22189 1 0.0000 0.0000
PERF_SPLIT_1 234400 61648 1 0.0000 0.0000
PERF_SPLIT_2 182411 13509 1 0.0000 0.0000
PERF_SPLIT_3 186941 23960 1 0.0000 0.0000
PERF_SPLIT_4 177407 34232 1 0.0000 0.0000
PERF_SPLIT_5 189345 23785 1 0.0000 0.0000
PERF_SPLIT_6 198194 16398 1 0.0000 0.0000
PERF_SPLIT_7 161336 17451 1 0.0000 0.0000
PERF_SPLIT_8 182327 17995 1 0.0000 0.0000
PERF_SPLIT_9 204277 34168 1 0.0000 0.0000
PSTORNED 2088935 26386 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 118686 35334 1 0.0000 0.0000
XQD_1000_3300 6949917 185389 1 0.0000 0.0000
XQD_1200_2000 12098189 206772 1 0.0000 0.0000
XQD_2000_3300 1228444 302152 1 0.0000 0.0000
XQD_2100_3300 845405 219293 1 0.0000 0.0000
XQD_3300_3400 8861773 178012 1 0.0000 0.0000
XQS_1000_1200 21124122 3690 1 0.0000 0.0000
XQS_1000_3300 9933915 795465 1 0.0000 0.0000
XQS_1200_2000 10920534 116976 1 0.0000 0.0000
XQS_2100_3300 10290710 1039556 1 0.0000 0.0000
XQS_3300_3400 581354 13961 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

13.03.24 19:12:48. 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-13 19:12:50 No severe PSQL-related problems occured
13.03.24 19:12:52. End of report.