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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-28 16:09:47
DTS_END                         2024-03-28 16:09:37.2040
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52794
TRN_ID                          175020
ATT_ID                          274
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: 9384.73 22006 938473
customer order: creation 176.54 389 17654
customer order: refuse 15.49 352 1549
order to supplier: creation 47.02 1267 4702
order to supplier: removal 3.77 103865 377
invoice (draft): creation 46.88 3003 4688
invoice (draft): removal 50.34 823 5034
invoice accept: apply 42.29 21356 4229
invoice accept: cancel 46.07 922 4607
customer reserve: creation 4085.46 203 408546
customer reserve: removal 4579.13 68 457913
realization accept: apply 84.43 191 8443
realization accept: cancel 75.69 141 7569
payment from customer: creation 59.70 131 5970
payment from customer: removal 5.74 94 574
payment to supplier: creation 50.55 168 5055
payment to supplier: removal 3.47 68 347
service: total inventory turnovers 4.47 1201 447
service: total monetary turnovers 6.69 27 669
service: aggregate perf. data 0.97 14820 97
service: refresh index statistics 0.03 291034 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-03-2024 16:10:32 to 28-03-2024 16:10:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2450
TEST_TIME 2 2416
TEST_TIME 3 3322
TEST_TIME 4 3466
TEST_TIME 5 3873
TEST_TIME 6 3730
TEST_TIME 7 3616
TEST_TIME 8 3798
TEST_TIME 9 4363
TEST_TIME 10 4804
TEST_TIME 11 4700
TEST_TIME 12 4710
TEST_TIME 13 4973
TEST_TIME 14 5669
TEST_TIME 15 5849
TEST_TIME 16 6054
TEST_TIME 17 6218
TEST_TIME 18 6358
TEST_TIME 19 6449
TEST_TIME 20 6765
TEST_TIME 21 6906
TEST_TIME 22 7391
TEST_TIME 23 7364
TEST_TIME 24 7470
TEST_TIME 25 7875
TEST_TIME 26 8118
TEST_TIME 27 8879
TEST_TIME 28 9694
TEST_TIME 29 9571
TEST_TIME 30 9487
TEST_TIME 31 9340
TEST_TIME 32 9221
TEST_TIME 33 9327
TEST_TIME 34 9335
TEST_TIME 35 9183
TEST_TIME 36 9366
TEST_TIME 37 9244
TEST_TIME 38 9215
TEST_TIME 39 9178
TEST_TIME 40 9234
TEST_TIME 41 9126
TEST_TIME 42 9393
TEST_TIME 43 9292
TEST_TIME 44 9269
TEST_TIME 45 9187
TEST_TIME 46 9180
TEST_TIME 47 9353
TEST_TIME 48 9321
TEST_TIME 49 9376
TEST_TIME 50 9453
TEST_TIME 51 9471
TEST_TIME 52 9535
TEST_TIME 53 9499
TEST_TIME 54 9534
TEST_TIME 55 9601
TEST_TIME 56 9538
TEST_TIME 57 9586
TEST_TIME 58 9565
TEST_TIME 59 9558
TEST_TIME 60 9471
TEST_TIME 61 9408
TEST_TIME 62 9398
TEST_TIME 63 9402
TEST_TIME 64 9416
TEST_TIME 65 9357
TEST_TIME 66 9344
TEST_TIME 67 9270
TEST_TIME 68 9199
TEST_TIME 69 9189
TEST_TIME 70 9252
TEST_TIME 71 9272
TEST_TIME 72 9234
TEST_TIME 73 9291
TEST_TIME 74 9372
TEST_TIME 75 9360
TEST_TIME 76 9415
TEST_TIME 77 9402
TEST_TIME 78 9465
TEST_TIME 79 9446
TEST_TIME 80 9451
TEST_TIME 81 9489
TEST_TIME 82 9555
TEST_TIME 83 9589
TEST_TIME 84 9573
TEST_TIME 85 9486
TEST_TIME 86 9449
TEST_TIME 87 9396
TEST_TIME 88 9408
TEST_TIME 89 9351
TEST_TIME 90 9374
TEST_TIME 91 9336
TEST_TIME 92 9254
TEST_TIME 93 9328
TEST_TIME 94 9329
TEST_TIME 95 9357
TEST_TIME 96 9375
TEST_TIME 97 9374
TEST_TIME 98 9398
TEST_TIME 99 9404
TEST_TIME 100 9390

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-03-2024 16:10:36 to 28-03-2024 16:10:39.

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 1313834 1313834 0 0.00 0 33738 8 0 0
doc_list_biud 1313833 1313833 0 0.00 0 70290 29 0 0
sp_add_invoice_to_stock 4305 4229 76 1.76 43 192242 21356 0 76
sp_cancel_adding_invoice 4607 4607 0 0.00 4 90464 922 0 0
sp_cancel_client_order 1549 1549 0 0.00 4 15173 352 0 0
sp_cancel_customer_reserve 457913 457913 0 0.00 1 44687 69 0 0
sp_cancel_pay_from_customer 574 574 0 0.00 2 11170 95 0 0
sp_cancel_pay_to_supplier 347 347 0 0.00 3 4672 68 0 0
sp_cancel_supplier_invoice 5046 5034 12 0.23 1 70294 823 0 12
sp_cancel_supplier_order 377 377 0 0.00 10 1156365 103865 0 0
sp_cancel_write_off 7569 7569 0 0.00 1 19461 141 0 0
sp_client_order 17654 17654 0 0.00 3 38258 390 0 0
sp_customer_reserve 408546 408546 0 0.00 0 32505 204 0 0
sp_fill_shopping_cart 27033 27033 0 0.00 1 10805 36 0 0
sp_fill_shopping_cart_clo_res 408545 408545 0 0.00 0 19064 16 0 0
sp_get_clo_for_invoice 4224 4224 0 0.00 0 29184 315 0 0
sp_kill_cost_storno 13097 13097 0 0.00 0 11165 69 0 0
sp_kill_qstorno_ret_qs2qd 928806 928806 0 0.00 0 70287 37 0 0
sp_kill_qty_storno 489714 489714 0 0.00 0 70288 78 0 0
sp_lock_selected_doc 17666 17666 0 0.00 0 8186 5 0 0
sp_make_cost_storno 23691 23691 0 0.00 0 29875 76 0 0
sp_multiply_rows_for_pdistr 23690 23690 0 0.00 0 18241 35 0 0
sp_multiply_rows_for_qdistr 17654 17654 0 0.00 0 38253 165 0 0
sp_pay_from_customer 5970 5970 0 0.00 4 18703 132 0 0
sp_pay_to_supplier 5055 5055 0 0.00 5 29889 169 0 0
sp_payment_common 11025 11025 0 0.00 1 17897 39 0 0
sp_qd_handle_on_cancel_clo 1549 1549 0 0.00 0 15165 330 0 0
sp_qd_handle_on_invoice_upd_sts 8829 8829 0 0.00 0 25832 336 0 0
sp_qd_handle_on_reserve_upd_sts 8443 8443 0 0.00 0 25430 56 0 0
sp_reserve_write_off 8443 8443 0 0.00 6 25680 192 0 0
sp_supplier_invoice 4688 4688 0 0.00 6 59763 3004 0 0
sp_supplier_order 4702 4702 0 0.00 5 35849 1268 0 0
srv_aggregate_perf_data 97 97 0 0.00 1373 130123 14821 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1083 94766 35054 0 0
srv_find_qd_qs_mism 895806 895806 0 0.00 0 10450 7 0 0
srv_make_invnt_saldo 447 447 0 0.00 28 123609 1201 0 0
srv_make_money_saldo 669 669 0 0.00 1 760 27 0 0
srv_recalc_idx_stat 3 3 0 0.00 217625 394226 291034 0 0
t$perf-abend:sp_add_invoice_to_stock 76 76 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4229 4229 0 0.00 0 10251 192 0 0
t$perf-norm:sp_cancel_adding_invoice 372 372 0 0.00 0 2433 104 0 0
t$perf-norm:sp_cancel_client_order 1549 1549 0 0.00 0 1740 9 0 0
t$perf-norm:sp_cancel_customer_reserve 597 597 0 0.00 0 1323 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 574 574 0 0.00 0 1977 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 347 347 0 0.00 0 334 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 321 321 0 0.00 0 1824 18 0 0
t$perf-norm:sp_cancel_supplier_order 377 377 0 0.00 0 30757 1702 0 0
t$perf-norm:sp_cancel_write_off 864 864 0 0.00 0 1575 9 0 0
t$perf-norm:sp_client_order 17654 17654 0 0.00 0 13300 18 0 0
t$perf-norm:sp_customer_reserve 799 799 0 0.00 0 1476 8 0 0
t$perf-norm:sp_pay_from_customer 5970 5970 0 0.00 0 4887 12 0 0
t$perf-norm:sp_pay_to_supplier 5055 5055 0 0.00 0 7438 11 0 0
t$perf-norm:sp_reserve_write_off 8443 8443 0 0.00 0 8786 12 0 0
t$perf-norm:sp_supplier_invoice 4688 4688 0 0.00 0 7526 18 0 0
t$perf-norm:sp_supplier_order 4702 4702 0 0.00 0 5433 16 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 303 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 93 2 0 0
t$perf-norm:srv_make_invnt_saldo 447 447 0 0.00 0 841 23 0 0
t$perf-norm:srv_make_money_saldo 669 669 0 0.00 0 689 18 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8596 8444 152 1.76 0 7121 18 0 152
v_all_customers 32814 32814 0 0.00 0 19 1 0 0
v_all_suppliers 26762 26762 0 0.00 0 28 1 0 0
v_all_wares 35306 35306 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 744 744 0 0.00 0 1235 8 0 0
v_cancel_client_order 3098 3098 0 0.00 0 1664 5 0 0
v_cancel_customer_prepayment 1148 1148 0 0.00 0 1559 8 0 0
v_cancel_customer_reserve 1194 1194 0 0.00 0 2013 9 0 0
v_cancel_payment_to_supplier 694 694 0 0.00 0 330 3 0 0
v_cancel_supplier_invoice 666 642 24 3.60 0 1447 17 0 24
v_cancel_supplier_order 754 754 0 0.00 0 1384 8 0 0
v_cancel_write_off 1728 1728 0 0.00 0 3847 18 0 0
v_max_id_clo_ord 4700 4700 0 0.00 0 337 1 0 0
v_max_id_clo_res 799 799 0 0.00 0 3156 13 0 0
v_max_id_ord_sup 4680 4680 0 0.00 0 5630 5 0 0
v_max_non_paid_invoice 1054 1054 0 0.00 0 1356 4 0 0
v_max_non_paid_realizn 2848 2848 0 0.00 0 3635 6 0 0
v_min_id_clo_ord 4700 4700 0 0.00 0 4288 10 0 0
v_min_id_clo_res 799 799 0 0.00 0 2573 8 0 0
v_min_id_ord_sup 4680 4680 0 0.00 0 6554 6 0 0
v_min_non_paid_invoice 5055 5055 0 0.00 0 17871 39 0 0
v_min_non_paid_realizn 5970 5970 0 0.00 0 11945 23 0 0
v_our_firm 8736 8736 0 0.00 0 18 1 0 0
v_reserve_write_off 16886 16886 0 0.00 0 3583 6 0 0
x_lock_depdocs_on_canc_invoice 9320 9320 0 0.00 0 11375 147 0 0
x_lock_depdocs_on_canc_sup_ord 377 377 0 0.00 0 8856 341 0 0
x_make_qstorno_1000_1200 4702 4702 0 0.00 1 35842 1188 0 0
x_make_qstorno_1200_2000 4688 4688 0 0.00 3 59727 2878 0 0
x_make_qstorno_2100_3300 408546 408546 0 0.00 0 32501 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2024 16:10:40 to 28-03-2024 16:10:44.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:41 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:42 26199 8192000000 9880751216 10186883072 965704832 10.545 100 91 182 0 995905696 6184080 24016784
14:12:13 16482 8192000000 9939390112 10259537920 1022149536 11.093 100 90 180 0 1053040944 7680672 23210736
14:13:36 23309 8192000000 9967988256 10297131008 1054468160 11.404 100 83 166 0 1084977504 9348784 21160560
14:15:15 9952 8192000000 10026522048 10371641344 1113525776 11.966 100 73 146 0 1140566528 9900096 17140656
14:16:30 5228 8192000000 10077266320 10436194304 1165422304 12.454 100 79 158 0 1194968432 11583328 17962800
14:17:48 4055 8192000000 10124726880 10493829120 1217971232 12.943 100 74 145 2 1245050848 11272912 15806704
14:18:54 2351 8192000000 10159392672 10531880960 1244356240 13.186 100 84 167 2 1275643728 13598000 17689488
14:19:59 3086 8192000000 10181588000 10563465216 1266218272 13.387 100 76 149 0 1294500144 12705888 15575984
14:21:03 21799 8192000000 10204094144 10597171200 1297935248 13.676 100 69 137 1 1321507712 8282960 15289504
14:22:26 6010 8192000000 10184348048 10600329216 1300672192 13.701 100 21 42 0 1311598256 6453168 4472896
14:23:34 9738 8192000000 10193977568 10608971776 1310033952 13.786 100 18 36 0 1319709344 6013232 3662160
14:24:46 7322 8192000000 10208364720 10623864832 1319410480 13.871 100 23 46 2 1330253936 5604144 5239312
14:25:54 9454 8192000000 10208397824 10624196608 1326440368 13.935 100 28 55 0 1339434176 6258848 6734960
14:27:06 35157 8192000000 10218088240 10644951040 1328462000 13.953 100 26 50 0 1344260224 10535408 5262816
14:28:41 11434 8192000000 10223632160 10645151744 1319092400 13.868 99 18 36 0 1332862464 9871328 3898736
14:29:59 26028 8192000000 10214632656 10624888832 1305575680 13.746 99 45 87 0 1321658656 5831280 10251696
14:31:41 83123 8192000000 10256170144 10665848832 1318390864 13.862 98 36 72 0 1339517952 12218432 8908656
14:34:24 32478 8192000000 10244311920 10664206336 1328221360 13.951 99 29 58 0 1351927936 16790592 6915984
14:36:00 20832 8192000000 10270391584 10679357440 1346571872 14.117 100 59 118 0 1379556480 19434192 13550416
14:37:36 25429 8192000000 10280101152 10686529536 1330670208 13.973 98 54 108 0 1372287024 29479104 12137712
14:39:05 12681 8192000000 10260371696 10674470912 1318170608 13.860 97 43 86 0 1347475152 19102224 10202320
14:41:08 4663 8192000000 10248073360 10643140608 1298116208 13.678 97 63 124 2 1340388848 27442320 14830320
14:42:18 11773 8192000000 10246728224 10646417408 1310438240 13.790 99 42 82 0 1348841248 27902032 10500976
14:43:33 5038 8192000000 10291689856 10686251008 1350052752 14.148 100 76 150 0 1399480320 31342480 18085088
14:44:44 2216 8192000000 10304679840 10700476416 1359246416 14.231 100 69 135 0 1405640624 29815584 16578624
14:45:49 7895 8192000000 10320097952 10724442112 1371117808 14.337 100 69 136 0 1424300528 36332944 16849776
14:47:03 1110 8192000000 10336183200 10734247936 1378377584 14.402 100 80 160 0 1438029168 39758208 19893376
14:48:07 1083 8192000000 10344835536 10745335808 1378572240 14.404 100 83 164 0 1442232576 42583168 21077168
14:49:13 5551 8192000000 10351040192 10756546560 1392834288 14.531 100 76 151 1 1453936896 42137664 18964944
14:50:25 7485 8192000000 10349153568 10765082624 1395354144 14.554 100 55 110 0 1457036080 46652896 15029040
14:51:37 12601 8192000000 10337527056 10763448320 1398011136 14.577 100 46 92 0 1448185072 37619824 12554112
14:52:57 2744 8192000000 10355729040 10776776704 1401442480 14.608 100 54 108 2 1459030656 42766720 14821456
14:54:06 11633 8192000000 10335766032 10769018880 1385771856 14.468 100 26 52 1 1441453280 47637728 8043696
14:55:21 27350 8192000000 10331503344 10776125440 1389862368 14.505 100 24 48 0 1447708928 50673568 7172992
14:57:06 54077 8192000000 10280670720 10742566912 1362023360 14.256 99 9 13 2 1376904304 13665344 1215600
14:59:01 15432 8192000000 10291920880 10742812672 1386426928 14.474 100 13 26 0 1398731040 9398208 2905904
15:00:21 55280 8192000000 10318714608 10758819840 1396891584 14.567 100 43 83 0 1415357152 9522320 8943248
15:03:01 90001 8192000000 10307869136 10757267456 1393653392 14.538 100 18 36 0 1420573936 22163728 4756816
15:05:38 22804 8192000000 10303053760 10756493312 1388463456 14.492 99 37 73 0 1409274720 13243872 7567392
15:07:05 15214 8192000000 10313642784 10759659520 1403998816 14.631 100 34 67 0 1419980464 8471280 7510368
15:08:22 25679 8192000000 10306364912 10756083712 1387557584 14.484 99 35 70 1 1406797648 10996912 8243152
15:09:58 45509 8192000000 10329248096 10777448448 1406722576 14.655 99 35 69 0 1436223824 21416048 8085200
15:11:45 32546 8192000000 10306992496 10770042880 1394046448 14.542 99 6 12 0 1412043696 16914480 1082768
15:13:19 22272 8192000000 10299254080 10758868992 1395623968 14.556 99 10 20 1 1410180784 12187840 2368976
15:14:45 42256 8192000000 10306670336 10771456000 1403509136 14.626 100 14 28 0 1420536352 13645792 3381424
15:16:28 37071 8192000000 10327571344 10769526784 1398781184 14.584 99 31 60 0 1418170928 12184560 7205184
15:18:09 34646 8192000000 10310895632 10759942144 1384339808 14.455 98 30 59 0 1401962656 11139424 6483424
15:20:01 67044 8192000000 10294064096 10745630720 1321734032 13.892 94 32 64 1 1336915008 7416720 7764256
15:22:08 57546 8192000000 10295763728 10738085888 1338304144 14.042 96 31 62 0 1355602576 10749328 6549104
15:24:12 65395 8192000000 10270774816 10719592448 1284612640 13.555 93 12 25 0 1303294848 15506384 3175824
15:26:17 13611 8192000000 10279844272 10709078016 1350856432 14.155 100 63 127 0 1378226944 13290928 14079584
15:27:38 38350 8192000000 10273043328 10715926528 1316086784 13.841 97 23 46 0 1336144592 14986928 5070880
15:29:55 83745 8192000000 10259351008 10705809408 1332523312 13.990 98 28 54 1 1352325952 13889920 5912720
15:32:41 47906 8192000000 10244952704 10695720960 1331372912 13.980 98 23 46 0 1346113488 9770544 4970032
15:34:30 78308 8192000000 10242219984 10691416064 1318409472 13.862 97 17 34 0 1328885312 6521280 3954560
15:37:02 78385 8192000000 10274994016 10727772160 1375296448 14.374 100 27 54 1 1393352592 11956320 6099824
15:39:20 41468 8192000000 10263008048 10713264128 1349646272 14.144 99 6 12 0 1365925824 15006704 1272848
15:41:03 62377 8192000000 10275255696 10720411648 1350416208 14.151 98 20 40 0 1365609200 10653456 4539536
15:43:18 46788 8192000000 10276546832 10717110272 1332354000 13.988 97 28 56 1 1352255264 13190768 6710496
15:45:09 34880 8192000000 10289019840 10735726592 1364864528 14.281 99 24 48 0 1390582080 20185680 5531872
15:46:50 39219 8192000000 10291670208 10734555136 1360570688 14.242 99 29 57 0 1378671776 11530240 6570848
15:48:57 28278 8192000000 10306250160 10739597312 1375502960 14.376 99 34 66 0 1393416784 10635040 7278784
15:50:27 25495 8192000000 10301188976 10743914496 1390797600 14.513 100 23 46 1 1403358432 7949712 4611120
15:51:54 94766 8192000000 10300868432 10755350528 1364335072 14.276 98 10 20 0 1383973520 17908752 1729696
15:55:56 47339 8192000000 10298581728 10749181952 1369817296 14.325 98 26 52 0 1390257824 14882288 5558240
15:57:46 54587 8192000000 10286360576 10749493248 1370746848 14.334 98 11 22 1 1384954704 11556496 2651360
15:59:40 24518 8192000000 10300364656 10761695232 1404326320 14.633 100 16 32 0 1416864864 9163984 3374560
16:01:07 50730 8192000000 10320144160 10775236608 1413192592 14.712 100 28 56 0 1438849536 18745536 6911408
16:03:40 37155 8192000000 10284601456 10739064832 1358531792 14.224 97 21 42 0 1372328512 9243008 4553712
16:05:29 33593 8192000000 10289785856 10738044928 1364591792 14.279 98 17 34 1 1378508032 10079264 3836976
16:07:04 27748 8192000000 10307295920 10750193664 1374201904 14.365 99 32 65 1 1394604736 13170656 7232176
16:08:37 24246 8192000000 10261072080 10703888384 1328445312 13.953 97 25 50 1 1343135152 9282848 5406992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 76 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

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

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          179748
MON$OLDEST_ACTIVE               179749
MON$OLDEST_SNAPSHOT             179749
MON$NEXT_TRANSACTION            179749
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                       1906784
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Mar 28 16:11:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        94307 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    179748 
    Oldest active        179749 
    Oldest snapshot        179749 
    Next transaction    179750 
    Sequence number        0 
    Next attachment ID    710 
    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.16, total records: 7777703 
    Average version length: 48.16, total versions: 118474, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 53, data page slots: 86464 
    Data pages: 86464, average fill: 72% 
    Primary pages: 86464, secondary pages: 0, swept pages: 14568 
    Empty pages: 2, full pages: 72583 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 145 
    40 - 59% = 1962 
    60 - 79% = 84301 
    80 - 99% = 36 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23458, nodes: 7777703 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1742389, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 357 
        20 - 39% = 1885 
        40 - 59% = 4219 
        60 - 79% = 2412 
        80 - 99% = 14585 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13619, nodes: 7777703 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1564500, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1607 
        40 - 59% = 2128 
        60 - 79% = 1102 
        80 - 99% = 8782 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8417, nodes: 7777703 
    Average node length: 6.62, total dup: 5816491, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1557693, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 988 
        40 - 59% = 1424 
        60 - 79% = 910 
        80 - 99% = 4952 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.85, total records: 2251492 
    Average version length: 34.51, total versions: 124399, max versions: 3 
    Average fragment length: 6.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28120 
    Data pages: 28120, average fill: 74% 
    Primary pages: 28113, secondary pages: 7, swept pages: 8351 
    Empty pages: 7, full pages: 23988 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 198 
    40 - 59% = 1394 
    60 - 79% = 25096 
    80 - 99% = 1410 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4570, nodes: 2251492 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 701277, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 905 
        40 - 59% = 862 
        60 - 79% = 742 
        80 - 99% = 2061 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2496, nodes: 2254359 
    Average node length: 4.97, total dup: 2253460, max dup: 20871 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1256327, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 237 
        40 - 59% = 1487 
        60 - 79% = 575 
        80 - 99% = 193 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2030, nodes: 2251492 
    Average node length: 4.97, total dup: 2251442, max dup: 130208 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1054149, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 106 
        40 - 59% = 1054 
        60 - 79% = 65 
        80 - 99% = 801 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4363, nodes: 2251492 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 701277, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 545 
        40 - 59% = 641 
        60 - 79% = 827 
        80 - 99% = 2228 
 
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.68, total records: 400 
    Average version length: 23.38, total versions: 222904, max versions: 581 
    Average fragment length: 2.00, total fragments: 35, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1240, average fill: 90% 
    Primary pages: 13, secondary pages: 1227, swept pages: 0 
    Empty pages: 6, full pages: 1233 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 1233 
 
    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: 12.76, total records: 79849 
    Average version length: 68.27, total versions: 64933, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.90 
    Pointer pages: 7, data page slots: 2000 
    Data pages: 1688, average fill: 58% 
    Primary pages: 1686, secondary pages: 2, swept pages: 0 
    Empty pages: 416, full pages: 932 
    Fill distribution: 
     0 - 19% = 491 
    20 - 39% = 38 
    40 - 59% = 101 
    60 - 79% = 244 
    80 - 99% = 814 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701563, depth: 3, leaf buckets: 249, nodes: 79849 
    Average node length: 13.16, total dup: 4829, max dup: 2 
    Average key length: 10.76, compression ratio: 2.51 
    Average prefix length: 19.17, average data length: 7.83 
    Clustering factor: 59765, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 72 
        40 - 59% = 80 
        60 - 79% = 88 
        80 - 99% = 8 
 
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: 17562, max versions: 953 
    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% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 57 
 
    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.08, total records: 964 
    Average version length: 43.10, total versions: 897, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 18.83 
    Pointer pages: 1, data page slots: 104 
    Data pages: 35, average fill: 27% 
    Primary pages: 34, secondary pages: 1, swept pages: 5 
    Empty pages: 17, full pages: 6 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92394, depth: 2, leaf buckets: 3, nodes: 964 
    Average node length: 4.85, total dup: 868, max dup: 111 
    Average key length: 3.07, compression ratio: 6.19 
    Average prefix length: 18.03, average data length: 0.97 
    Clustering factor: 552, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        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.12, total records: 73 
    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: 51% 
    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: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.80, total records: 822355 
    Average version length: 25.34, total versions: 82146, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8208 
    Data pages: 8184, average fill: 71% 
    Primary pages: 8162, secondary pages: 22, swept pages: 1105 
    Empty pages: 72, full pages: 7582 
    Fill distribution: 
     0 - 19% = 148 
    20 - 39% = 82 
    40 - 59% = 87 
    60 - 79% = 7539 
    80 - 99% = 328 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 903, nodes: 822355 
    Average node length: 4.87, total dup: 822306, max dup: 154123 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90847, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 110 
        40 - 59% = 518 
        60 - 79% = 207 
        80 - 99% = 65 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 997, nodes: 822355 
    Average node length: 5.88, total dup: 732497, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163549, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 548 
        60 - 79% = 94 
        80 - 99% = 270 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1082, nodes: 822355 
    Average node length: 5.88, total dup: 732497, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165588, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 221 
        40 - 59% = 550 
        60 - 79% = 72 
        80 - 99% = 237 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1160, nodes: 822355 
    Average node length: 5.96, total dup: 732497, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158324, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 228 
        40 - 59% = 644 
        60 - 79% = 183 
        80 - 99% = 104 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5446 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.01, total fragments: 84, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 77, secondary pages: 19, swept pages: 50 
    Empty pages: 10, full pages: 64 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5446 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.40, average data length: 1.54 
    Clustering factor: 5162, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5446 
    Average node length: 11.12, 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: 149, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.11, total records: 79831 
    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: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 768 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 769 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34475, depth: 2, leaf buckets: 103, nodes: 79831 
    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: 3159, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 100 
 
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.71, 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.27 
    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: 149.89, total records: 171964 
    Average version length: 149.48, total versions: 1421, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 5136 
    Data pages: 4152, average fill: 85% 
    Primary pages: 4152, secondary pages: 0, swept pages: 2 
    Empty pages: 68, full pages: 4071 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4070 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 141.56, total records: 184197 
    Average version length: 154.28, total versions: 11542, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.98 
    Pointer pages: 7, data page slots: 5000 
    Data pages: 4424, average fill: 86% 
    Primary pages: 4423, secondary pages: 1, swept pages: 1 
    Empty pages: 50, full pages: 4364 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4364 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 143.10, total records: 168891 
    Average version length: 152.65, total versions: 8623, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 5, data page slots: 4496 
    Data pages: 4024, average fill: 87% 
    Primary pages: 4023, secondary pages: 1, swept pages: 2 
    Empty pages: 20, full pages: 3994 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3993 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.42, total records: 173999 
    Average version length: 152.78, total versions: 6552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 5, data page slots: 4656 
    Data pages: 4152, average fill: 87% 
    Primary pages: 4152, secondary pages: 0, swept pages: 4 
    Empty pages: 22, full pages: 4120 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4120 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.22, total records: 154698 
    Average version length: 150.01, total versions: 2692, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 3984 
    Data pages: 3696, average fill: 86% 
    Primary pages: 3696, secondary pages: 0, swept pages: 2 
    Empty pages: 28, full pages: 3657 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3657 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 139.92, total records: 188818 
    Average version length: 154.08, total versions: 13953, 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: 6, data page slots: 5024 
    Data pages: 4504, average fill: 87% 
    Primary pages: 4503, secondary pages: 1, swept pages: 2 
    Empty pages: 15, full pages: 4476 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 4476 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 132.72, total records: 174860 
    Average version length: 154.68, total versions: 21102, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.78 
    Pointer pages: 7, data page slots: 4464 
    Data pages: 4200, average fill: 87% 
    Primary pages: 4200, secondary pages: 0, swept pages: 1 
    Empty pages: 42, full pages: 4147 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4147 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 132.43, total records: 190446 
    Average version length: 154.86, total versions: 23481, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.81 
    Pointer pages: 8, data page slots: 5448 
    Data pages: 4544, average fill: 88% 
    Primary pages: 4544, secondary pages: 0, swept pages: 6 
    Empty pages: 12, full pages: 4521 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4521 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.54, total records: 166845 
    Average version length: 150.82, total versions: 1712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 7, data page slots: 4856 
    Data pages: 3984, average fill: 86% 
    Primary pages: 3984, secondary pages: 0, swept pages: 4 
    Empty pages: 24, full pages: 3950 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3950 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 142.78, total records: 165436 
    Average version length: 153.69, total versions: 8699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 3936, average fill: 87% 
    Primary pages: 3936, secondary pages: 0, swept pages: 3 
    Empty pages: 17, full pages: 3912 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3913 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.40, total records: 2109678 
    Average version length: 52.96, total versions: 53859, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25464 
    Data pages: 25456, average fill: 71% 
    Primary pages: 25456, secondary pages: 0, swept pages: 9516 
    Empty pages: 335, full pages: 21682 
    Fill distribution: 
     0 - 19% = 597 
    20 - 39% = 369 
    40 - 59% = 846 
    60 - 79% = 23114 
    80 - 99% = 530 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2593, nodes: 2109678 
    Average node length: 5.44, total dup: 1968852, max dup: 1698 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183026, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 297 
        40 - 59% = 1710 
        60 - 79% = 291 
        80 - 99% = 293 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2109678 
    Average node length: 5.69, total dup: 1893977, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377974, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2452 
        60 - 79% = 270 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2147, nodes: 2109678 
    Average node length: 4.96, total dup: 2109578, max dup: 28291 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 180768, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 190 
        40 - 59% = 1137 
        60 - 79% = 402 
        80 - 99% = 415 
 
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: 35.37, total records: 148259 
    Average version length: 69.21, total versions: 72531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.56 
    Pointer pages: 3, data page slots: 3984 
    Data pages: 2912, average fill: 60% 
    Primary pages: 2912, secondary pages: 0, swept pages: 367 
    Empty pages: 560, full pages: 1913 
    Fill distribution: 
     0 - 19% = 724 
    20 - 39% = 63 
    40 - 59% = 54 
    60 - 79% = 840 
    80 - 99% = 1231 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553737, depth: 3, leaf buckets: 218, nodes: 148259 
    Average node length: 6.42, total dup: 129123, max dup: 14 
    Average key length: 3.93, compression ratio: 10.68 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 25875, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 118 
        60 - 79% = 55 
        80 - 99% = 16 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.92, total records: 7286024 
    Average version length: 68.78, total versions: 532333, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 64, data page slots: 103584 
    Data pages: 103584, average fill: 75% 
    Primary pages: 103584, secondary pages: 0, swept pages: 16705 
    Empty pages: 16, full pages: 89208 
    Fill distribution: 
     0 - 19% = 228 
    20 - 39% = 906 
    40 - 59% = 4451 
    60 - 79% = 87811 
    80 - 99% = 10188 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10784, nodes: 7286024 
    Average node length: 6.50, total dup: 6306636, max dup: 38 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1636465, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1312 
        40 - 59% = 5971 
        60 - 79% = 3001 
        80 - 99% = 495 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8872, nodes: 7286024 
    Average node length: 5.39, total dup: 7001440, max dup: 184 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1426339, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1229 
        40 - 59% = 5098 
        60 - 79% = 1627 
        80 - 99% = 909 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8889, nodes: 7286024 
    Average node length: 5.39, total dup: 7001440, max dup: 184 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1428858, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1216 
        40 - 59% = 5112 
        60 - 79% = 1629 
        80 - 99% = 925 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.39, total records: 12289952 
    Average version length: 68.73, total versions: 458258, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 104, data page slots: 168744 
    Data pages: 168744, average fill: 77% 
    Primary pages: 168744, secondary pages: 0, swept pages: 61913 
    Empty pages: 4, full pages: 166766 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 135 
    40 - 59% = 590 
    60 - 79% = 157085 
    80 - 99% = 10916 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18420, nodes: 12289952 
    Average node length: 6.59, total dup: 10713211, max dup: 67 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2417754, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1937 
        40 - 59% = 10652 
        60 - 79% = 4932 
        80 - 99% = 857 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 37.91, total records: 1913763 
    Average version length: 69.11, total versions: 864274, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.32 
    Pointer pages: 28, data page slots: 44776 
    Data pages: 28582, average fill: 77% 
    Primary pages: 28582, secondary pages: 0, swept pages: 3059 
    Empty pages: 1255, full pages: 25106 
    Fill distribution: 
     0 - 19% = 1878 
    20 - 39% = 578 
    40 - 59% = 539 
    60 - 79% = 10173 
    80 - 99% = 15414 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2310, nodes: 1913763 
    Average node length: 5.51, total dup: 1836812, max dup: 99 
    Average key length: 2.54, compression ratio: 16.52 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 129289, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 283 
        40 - 59% = 1101 
        60 - 79% = 685 
        80 - 99% = 227 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 36.11, total records: 1065319 
    Average version length: 69.13, total versions: 507941, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.49 
    Pointer pages: 22, data page slots: 35000 
    Data pages: 27752, average fill: 45% 
    Primary pages: 27752, secondary pages: 0, swept pages: 6852 
    Empty pages: 7286, full pages: 12715 
    Fill distribution: 
     0 - 19% = 11375 
    20 - 39% = 1848 
    40 - 59% = 902 
    60 - 79% = 4998 
    80 - 99% = 8629 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1463, nodes: 1065319 
    Average node length: 5.74, total dup: 998662, max dup: 99 
    Average key length: 2.82, compression ratio: 14.91 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 139248, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 329 
        40 - 59% = 694 
        60 - 79% = 361 
        80 - 99% = 75 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.54, total records: 9297753 
    Average version length: 68.97, total versions: 589279, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 89, data page slots: 143784 
    Data pages: 143752, average fill: 69% 
    Primary pages: 143751, secondary pages: 1, swept pages: 44209 
    Empty pages: 422, full pages: 90197 
    Fill distribution: 
     0 - 19% = 1561 
    20 - 39% = 7380 
    40 - 59% = 20222 
    60 - 79% = 104107 
    80 - 99% = 10482 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13489, nodes: 9297753 
    Average node length: 6.68, total dup: 7714422, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2039161, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1097 
        40 - 59% = 6894 
        60 - 79% = 4822 
        80 - 99% = 675 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21160791 
    Average version length: 82.97, total versions: 19778, 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: 318856 
    Data pages: 318856, average fill: 81% 
    Primary pages: 318856, secondary pages: 0, swept pages: 12095 
    Empty pages: 26, full pages: 318444 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 14 
    40 - 59% = 37 
    60 - 79% = 27288 
    80 - 99% = 291480 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19742, nodes: 21160791 
    Average node length: 5.72, total dup: 20679746, max dup: 139 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280489, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 4 
        40 - 59% = 8848 
        60 - 79% = 535 
        80 - 99% = 10348 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17185, nodes: 21160791 
    Average node length: 6.31, total dup: 18596071, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912442, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 809 
        60 - 79% = 247 
        80 - 99% = 16121 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21515, nodes: 21160791 
    Average node length: 6.35, total dup: 18515576, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575705, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 9116 
        60 - 79% = 590 
        80 - 99% = 11801 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16100, nodes: 21160791 
    Average node length: 5.56, total dup: 21160691, max dup: 229814 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941464, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2867 
        60 - 79% = 403 
        80 - 99% = 12824 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.81, total records: 9708959 
    Average version length: 82.65, total versions: 542289, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 171536 
    Data pages: 171496, average fill: 70% 
    Primary pages: 171496, secondary pages: 0, swept pages: 64694 
    Empty pages: 1001, full pages: 104923 
    Fill distribution: 
     0 - 19% = 2685 
    20 - 39% = 9243 
    40 - 59% = 25248 
    60 - 79% = 66294 
    80 - 99% = 68026 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11343, nodes: 9708959 
    Average node length: 5.36, total dup: 9402402, max dup: 217 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2150285, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 60 
        40 - 59% = 8245 
        60 - 79% = 2948 
        80 - 99% = 86 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13639, nodes: 9708959 
    Average node length: 6.23, total dup: 8051136, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1499358, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 3870 
        40 - 59% = 4628 
        60 - 79% = 2658 
        80 - 99% = 2334 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12659, nodes: 9708959 
    Average node length: 5.98, total dup: 8430415, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2341577, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 69 
        40 - 59% = 9198 
        60 - 79% = 3292 
        80 - 99% = 96 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10126, nodes: 9708959 
    Average node length: 5.13, total dup: 9708859, max dup: 163583 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1533167, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1195 
        40 - 59% = 5081 
        60 - 79% = 1676 
        80 - 99% = 2127 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.16, total records: 11319071 
    Average version length: 82.57, total versions: 431649, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 192544 
    Data pages: 190840, average fill: 73% 
    Primary pages: 190840, secondary pages: 0, swept pages: 65583 
    Empty pages: 3519, full pages: 144734 
    Fill distribution: 
     0 - 19% = 5820 
    20 - 39% = 7767 
    40 - 59% = 17055 
    60 - 79% = 39362 
    80 - 99% = 120836 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13130, nodes: 11319071 
    Average node length: 5.30, total dup: 11209617, max dup: 643 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2354616, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 103 
        40 - 59% = 9360 
        60 - 79% = 3497 
        80 - 99% = 169 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10430, nodes: 11319071 
    Average node length: 5.49, total dup: 10824833, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 707054, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 838 
        40 - 59% = 2595 
        60 - 79% = 1796 
        80 - 99% = 5051 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15016, nodes: 11319071 
    Average node length: 6.02, total dup: 9879974, max dup: 77 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2371176, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 119 
        40 - 59% = 10887 
        60 - 79% = 3791 
        80 - 99% = 218 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10757, nodes: 11319071 
    Average node length: 5.22, total dup: 11318971, max dup: 213519 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 695673, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 90 
        20 - 39% = 767 
        40 - 59% = 4908 
        60 - 79% = 1425 
        80 - 99% = 3567 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.15, total records: 9826140 
    Average version length: 82.91, total versions: 545585, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 108, data page slots: 174744 
    Data pages: 174696, average fill: 70% 
    Primary pages: 174696, secondary pages: 0, swept pages: 68008 
    Empty pages: 920, full pages: 104355 
    Fill distribution: 
     0 - 19% = 2670 
    20 - 39% = 9488 
    40 - 59% = 26640 
    60 - 79% = 68578 
    80 - 99% = 67320 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11758, nodes: 9826140 
    Average node length: 5.17, total dup: 9797390, max dup: 2251 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1969200, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1401 
        40 - 59% = 7775 
        60 - 79% = 1956 
        80 - 99% = 595 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13828, nodes: 9826140 
    Average node length: 6.24, total dup: 8147768, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1466552, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 202 
        20 - 39% = 3899 
        40 - 59% = 4707 
        60 - 79% = 2586 
        80 - 99% = 2434 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12426, nodes: 9826140 
    Average node length: 5.43, total dup: 9388166, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2102541, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1412 
        40 - 59% = 8657 
        60 - 79% = 1753 
        80 - 99% = 581 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10291, nodes: 9826140 
    Average node length: 5.15, total dup: 9826040, max dup: 166323 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1554946, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1234 
        40 - 59% = 5238 
        60 - 79% = 1653 
        80 - 99% = 2123 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.39, total records: 578739 
    Average version length: 68.71, total versions: 6658, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 76% 
    Primary pages: 7976, secondary pages: 0, swept pages: 3433 
    Empty pages: 2, full pages: 7157 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 31 
    40 - 59% = 171 
    60 - 79% = 7652 
    80 - 99% = 118 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 33051, depth: 3, leaf buckets: 728, nodes: 578739 
    Average node length: 5.95, total dup: 492759, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100795, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 505 
        60 - 79% = 102 
        80 - 99% = 97 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29593, depth: 3, leaf buckets: 753, nodes: 578739 
    Average node length: 6.15, total dup: 474641, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100839, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 525 
        60 - 79% = 102 
        80 - 99% = 103 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 574, nodes: 578739 
    Average node length: 4.86, total dup: 578639, max dup: 9568 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89542, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 326 
        60 - 79% = 97 
        80 - 99% = 121 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Mar 28 16:11:28 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7777703 118474 1 0.0000 0.0000
DOC_LIST 2251492 124399 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 222904 581 55700.0000 0.0000
INVNT_TURNOVER_LOG 79849 64933 1 0.0000 0.0000
MONEY_SALDO 49 17562 953 35800.0000 0.0000
MONEY_TURNOVER_LOG 964 897 1 0.0000 0.0000
PDISTR 822355 82146 4 0.0000 0.0000
PERF_SPLIT_0 171964 1421 1 0.0000 0.0000
PERF_SPLIT_1 184197 11542 1 0.0000 0.0000
PERF_SPLIT_2 168891 8623 1 0.0000 0.0000
PERF_SPLIT_3 173999 6552 1 0.0000 0.0000
PERF_SPLIT_4 154698 2692 1 0.0000 0.0000
PERF_SPLIT_5 188818 13953 1 0.0000 0.0000
PERF_SPLIT_6 174860 21102 1 0.0000 0.0000
PERF_SPLIT_7 190446 23481 1 0.0000 0.0000
PERF_SPLIT_8 166845 1712 1 0.0000 0.0000
PERF_SPLIT_9 165436 8699 1 0.0000 0.0000
PSTORNED 2109678 53859 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 148259 72531 1 0.0000 0.0000
XQD_1000_3300 7286024 532333 1 0.0000 0.0000
XQD_1200_2000 12289952 458258 1 0.0000 0.0000
XQD_2000_3300 1913763 864274 1 0.0000 0.0000
XQD_2100_3300 1065319 507941 1 0.0000 0.0000
XQD_3300_3400 9297753 589279 1 0.0000 0.0000
XQS_1000_1200 21160791 19778 1 0.0000 0.0000
XQS_1000_3300 9708959 542289 1 0.0000 0.0000
XQS_1200_2000 11319071 431649 1 0.0000 0.0000
XQS_2100_3300 9826140 545585 1 0.0000 0.0000
XQS_3300_3400 578739 6658 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'  

28.03.24 16:11:39. 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-28 16:11:42 No severe PSQL-related problems occured
28.03.24 16:11:43. End of report.