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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-14 01:09:44
DTS_END                         2024-03-14 01:09:44.3550
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49176
TRN_ID                          184595
ATT_ID                          611
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: 9373.84 20995 937384
customer order: creation 187.54 339 18754
customer order: refuse 15.80 333 1580
order to supplier: creation 50.39 1254 5039
order to supplier: removal 3.33 96717 333
invoice (draft): creation 50.48 3148 5048
invoice (draft): removal 49.59 769 4959
invoice accept: apply 45.20 19422 4520
invoice accept: cancel 44.63 826 4463
customer reserve: creation 4213.01 191 421301
customer reserve: removal 4405.19 56 440519
realization accept: apply 89.69 180 8969
realization accept: cancel 78.29 129 7829
payment from customer: creation 64.10 116 6410
payment from customer: removal 6.12 73 612
payment to supplier: creation 52.99 126 5299
payment to supplier: removal 3.92 74 392
service: total inventory turnovers 5.49 931 549
service: total monetary turnovers 7.19 40 719
service: aggregate perf. data 0.86 18903 86
service: refresh index statistics 0.03 276270 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-03-2024 01:10:40 to 14-03-2024 01:10:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2591
TEST_TIME 2 3425
TEST_TIME 3 4842
TEST_TIME 4 4097
TEST_TIME 5 3774
TEST_TIME 6 3288
TEST_TIME 7 4302
TEST_TIME 8 4915
TEST_TIME 9 5335
TEST_TIME 10 5838
TEST_TIME 11 5741
TEST_TIME 12 5858
TEST_TIME 13 6269
TEST_TIME 14 6788
TEST_TIME 15 7132
TEST_TIME 16 7583
TEST_TIME 17 8251
TEST_TIME 18 8098
TEST_TIME 19 8271
TEST_TIME 20 8624
TEST_TIME 21 8928
TEST_TIME 22 8912
TEST_TIME 23 9003
TEST_TIME 24 9757
TEST_TIME 25 9780
TEST_TIME 26 9623
TEST_TIME 27 9402
TEST_TIME 28 9374
TEST_TIME 29 9362
TEST_TIME 30 9215
TEST_TIME 31 9415
TEST_TIME 32 9295
TEST_TIME 33 9205
TEST_TIME 34 9061
TEST_TIME 35 9073
TEST_TIME 36 8927
TEST_TIME 37 9093
TEST_TIME 38 9034
TEST_TIME 39 9157
TEST_TIME 40 9175
TEST_TIME 41 9119
TEST_TIME 42 9147
TEST_TIME 43 9308
TEST_TIME 44 9347
TEST_TIME 45 9408
TEST_TIME 46 9507
TEST_TIME 47 9448
TEST_TIME 48 9414
TEST_TIME 49 9454
TEST_TIME 50 9438
TEST_TIME 51 9406
TEST_TIME 52 9395
TEST_TIME 53 9428
TEST_TIME 54 9496
TEST_TIME 55 9547
TEST_TIME 56 9520
TEST_TIME 57 9357
TEST_TIME 58 9428
TEST_TIME 59 9333
TEST_TIME 60 9278
TEST_TIME 61 9305
TEST_TIME 62 9303
TEST_TIME 63 9277
TEST_TIME 64 9229
TEST_TIME 65 9172
TEST_TIME 66 9150
TEST_TIME 67 9289
TEST_TIME 68 9253
TEST_TIME 69 9238
TEST_TIME 70 9187
TEST_TIME 71 9283
TEST_TIME 72 9330
TEST_TIME 73 9480
TEST_TIME 74 9491
TEST_TIME 75 9460
TEST_TIME 76 9554
TEST_TIME 77 9579
TEST_TIME 78 9597
TEST_TIME 79 9549
TEST_TIME 80 9554
TEST_TIME 81 9598
TEST_TIME 82 9569
TEST_TIME 83 9474
TEST_TIME 84 9442
TEST_TIME 85 9402
TEST_TIME 86 9411
TEST_TIME 87 9368
TEST_TIME 88 9331
TEST_TIME 89 9306
TEST_TIME 90 9319
TEST_TIME 91 9284
TEST_TIME 92 9268
TEST_TIME 93 9267
TEST_TIME 94 9253
TEST_TIME 95 9268
TEST_TIME 96 9240
TEST_TIME 97 9236
TEST_TIME 98 9344
TEST_TIME 99 9348
TEST_TIME 100 9377

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-03-2024 01:10:44 to 14-03-2024 01:10:47.

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 1322453 1322453 0 0.00 0 22071 7 0 0
doc_list_biud 1322453 1322453 0 0.00 0 52286 24 0 0
sp_add_invoice_to_stock 4647 4520 127 2.73 36 223833 19422 0 127
sp_cancel_adding_invoice 4463 4463 0 0.00 3 58834 827 0 0
sp_cancel_client_order 1580 1580 0 0.00 3 6821 334 0 0
sp_cancel_customer_reserve 440519 440519 0 0.00 0 52296 57 0 0
sp_cancel_pay_from_customer 612 612 0 0.00 2 4022 74 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 3741 75 0 0
sp_cancel_supplier_invoice 4965 4959 6 0.12 1 14325 769 0 6
sp_cancel_supplier_order 333 333 0 0.00 5 783485 96718 0 0
sp_cancel_write_off 7829 7829 0 0.00 1 12063 129 0 0
sp_client_order 18754 18754 0 0.00 3 21177 339 0 0
sp_customer_reserve 421301 421301 0 0.00 0 104365 192 0 0
sp_fill_shopping_cart 28825 28825 0 0.00 1 30119 39 0 0
sp_fill_shopping_cart_clo_res 421297 421297 0 0.00 0 20840 15 0 0
sp_get_clo_for_invoice 4513 4513 0 0.00 0 34526 291 0 0
sp_kill_cost_storno 13296 13296 0 0.00 0 8728 61 0 0
sp_kill_qstorno_ret_qs2qd 894159 894159 0 0.00 0 51594 31 0 0
sp_kill_qty_storno 473164 473164 0 0.00 0 52277 68 0 0
sp_lock_selected_doc 18651 18651 0 0.00 0 5140 3 0 0
sp_make_cost_storno 25190 25190 0 0.00 0 11021 54 0 0
sp_multiply_rows_for_pdistr 25190 25190 0 0.00 0 13179 31 0 0
sp_multiply_rows_for_qdistr 18754 18754 0 0.00 0 12321 156 0 0
sp_pay_from_customer 6410 6410 0 0.00 4 13206 116 0 0
sp_pay_to_supplier 5299 5299 0 0.00 4 8214 127 0 0
sp_payment_common 11709 11709 0 0.00 1 11668 28 0 0
sp_qd_handle_on_cancel_clo 1580 1580 0 0.00 0 6810 305 0 0
sp_qd_handle_on_invoice_upd_sts 8975 8975 0 0.00 0 36370 335 0 0
sp_qd_handle_on_reserve_upd_sts 8969 8969 0 0.00 0 15767 64 0 0
sp_reserve_write_off 8969 8969 0 0.00 6 17251 180 0 0
sp_supplier_invoice 5048 5048 0 0.00 6 97991 3149 0 0
sp_supplier_order 5039 5039 0 0.00 4 25658 1255 0 0
srv_aggregate_perf_data 86 86 0 0.00 1668 283064 18903 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 689 131966 39165 0 0
srv_find_qd_qs_mism 891460 891460 0 0.00 0 22070 7 0 0
srv_make_invnt_saldo 549 549 0 0.00 30 31786 931 0 0
srv_make_money_saldo 719 719 0 0.00 1 2398 41 0 0
srv_recalc_idx_stat 3 3 0 0.00 217396 381892 276270 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4521 4521 0 0.00 0 15693 207 0 0
t$perf-norm:sp_cancel_adding_invoice 357 357 0 0.00 0 6078 102 0 0
t$perf-norm:sp_cancel_client_order 1580 1580 0 0.00 0 4195 16 0 0
t$perf-norm:sp_cancel_customer_reserve 612 612 0 0.00 0 1229 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 612 612 0 0.00 0 3673 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 1252 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 887 13 0 0
t$perf-norm:sp_cancel_supplier_order 333 333 0 0.00 0 32975 1946 0 0
t$perf-norm:sp_cancel_write_off 911 911 0 0.00 0 3434 11 0 0
t$perf-norm:sp_client_order 18754 18754 0 0.00 0 7247 16 0 0
t$perf-norm:sp_customer_reserve 859 859 0 0.00 0 1858 7 0 0
t$perf-norm:sp_pay_from_customer 6410 6410 0 0.00 0 6710 8 0 0
t$perf-norm:sp_pay_to_supplier 5299 5299 0 0.00 0 10876 10 0 0
t$perf-norm:sp_reserve_write_off 8969 8969 0 0.00 0 6111 11 0 0
t$perf-norm:sp_supplier_invoice 5048 5048 0 0.00 0 5983 18 0 0
t$perf-norm:sp_supplier_order 5039 5039 0 0.00 0 3247 16 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 226 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 129 3 0 0
t$perf-norm:srv_make_invnt_saldo 549 549 0 0.00 0 897 23 0 0
t$perf-norm:srv_make_money_saldo 719 719 0 0.00 0 5971 27 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 11 5 0 0
v_add_invoice_to_stock 9278 9024 254 2.73 0 3847 17 0 254
v_all_customers 34386 34386 0 0.00 0 77 1 0 0
v_all_suppliers 28290 28290 0 0.00 0 167 1 0 0
v_all_wares 37500 37500 0 0.00 0 75 1 0 0
v_cancel_adding_invoice 714 714 0 0.00 0 1145 10 0 0
v_cancel_client_order 3160 3160 0 0.00 0 3922 8 0 0
v_cancel_customer_prepayment 1224 1224 0 0.00 0 3639 7 0 0
v_cancel_customer_reserve 1224 1224 0 0.00 0 1430 4 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 3711 13 0 0
v_cancel_supplier_invoice 760 748 12 1.57 0 533 13 0 12
v_cancel_supplier_order 666 666 0 0.00 0 605 4 0 0
v_cancel_write_off 1822 1822 0 0.00 0 642 14 0 0
v_max_id_clo_ord 5036 5036 0 0.00 0 674 2 0 0
v_max_id_clo_res 859 859 0 0.00 0 5729 25 0 0
v_max_id_ord_sup 5039 5039 0 0.00 0 3495 2 0 0
v_max_non_paid_invoice 1229 1229 0 0.00 0 699 3 0 0
v_max_non_paid_realizn 3179 3179 0 0.00 0 3610 6 0 0
v_min_id_clo_ord 5036 5036 0 0.00 0 7942 13 0 0
v_min_id_clo_res 859 859 0 0.00 0 2248 5 0 0
v_min_id_ord_sup 5039 5039 0 0.00 0 9381 14 0 0
v_min_non_paid_invoice 5299 5299 0 0.00 0 5849 20 0 0
v_min_non_paid_realizn 6410 6410 0 0.00 0 11660 21 0 0
v_our_firm 9576 9576 0 0.00 0 17 1 0 0
v_reserve_write_off 17936 17936 0 0.00 0 5043 6 0 0
x_lock_depdocs_on_canc_invoice 9048 9048 0 0.00 0 15284 139 0 0
x_lock_depdocs_on_canc_sup_ord 333 333 0 0.00 0 5808 357 0 0
x_make_qstorno_1000_1200 5039 5039 0 0.00 1 25637 1166 0 0
x_make_qstorno_1200_2000 5048 5048 0 0.00 2 97975 3013 0 0
x_make_qstorno_2100_3300 421301 421301 0 0.00 0 104363 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2024 01:10:48 to 14-03-2024 01:10:52.

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
23:09:48 12 8192000000 8814238496 8831012864 16611328 0.202 6 2 3 0 16761344 75056 74960
23:10:49 34090 8192000000 9901057216 10212315136 983673088 10.720 100 87 174 0 1012156512 6099888 22383536
23:12:30 17277 8192000000 9949474624 10274840576 1032966560 11.197 100 88 176 0 1064547984 8812912 22768512
23:13:53 14125 8192000000 9981872080 10317094912 1067467296 11.528 100 87 174 0 1099746032 10703152 21575584
23:15:11 12248 8192000000 10030555728 10381287424 1116825040 11.997 100 81 162 0 1147897184 11827424 19244720
23:16:32 6803 8192000000 10085348016 10443935744 1171901104 12.515 100 75 150 1 1201121024 12003600 17216320
23:17:41 2665 8192000000 10130267504 10498449408 1213436624 12.901 100 85 169 1 1249915360 18103200 18375536
23:18:45 1281 8192000000 10159785936 10534555648 1244381024 13.187 100 82 162 0 1275301840 13327136 17593680
23:19:48 882 8192000000 10200739280 10585960448 1286013632 13.568 100 88 175 0 1317710400 12773424 18923344
23:20:49 849 8192000000 10218028432 10608259072 1307492960 13.763 100 78 148 2 1334229552 10686720 16049872
23:21:51 5682 8192000000 10212044336 10615644160 1317587584 13.855 100 39 79 0 1333226544 7054064 8584896
23:22:58 6584 8192000000 10209756384 10622664704 1324575280 13.918 100 35 70 0 1338814928 6816032 7423616
23:24:41 4862 8192000000 10225117040 10639953920 1329377088 13.962 100 37 72 0 1345978448 8813664 7787696
23:25:48 7295 8192000000 10240269808 10657595392 1342072320 14.076 100 31 62 2 1354942496 5222528 7647648
23:26:57 10638 8192000000 10224955088 10651582464 1330418432 13.971 99 15 29 0 1339532928 6121216 2993280
23:28:08 24177 8192000000 10234240416 10659598336 1345944576 14.111 100 39 78 1 1361652448 6758400 8949472
23:29:35 10152 8192000000 10225307392 10642616320 1322747072 13.902 99 26 53 0 1334705312 5444064 6514176
23:30:52 1706 8192000000 10258392592 10664951808 1345491488 14.107 100 66 131 0 1370981904 10716080 14774336
23:31:57 5783 8192000000 10258223040 10670878720 1349964480 14.147 100 50 101 1 1374625344 13242320 11418544
23:33:07 32997 8192000000 10268739152 10682753024 1357027600 14.211 100 36 72 0 1377740752 12219888 8493264
23:34:44 131965 8192000000 10261220208 10691604480 1311067888 13.796 96 36 72 0 1347256624 27097328 9091408
23:38:56 5729 8192000000 10238628512 10636943360 1307536080 13.764 99 60 120 0 1344790864 23340432 13914352
23:40:13 3696 8192000000 10217613280 10612445184 1294211744 13.643 100 63 122 1 1332005552 23063808 14730000
23:41:23 5574 8192000000 10258690768 10654433280 1323910160 13.912 100 61 122 0 1364537712 26119456 14508096
23:42:34 2044 8192000000 10280646624 10670010368 1332062176 13.986 100 90 169 1 1383469200 31357808 20049216
23:43:40 1293 8192000000 10278459216 10678767616 1338154896 14.041 100 63 125 0 1385450272 32305936 14989440
23:44:50 2358 8192000000 10294137328 10700546048 1354236304 14.186 100 62 122 0 1400058304 30941712 14880288
23:45:59 683 8192000000 10313752080 10711465984 1364008592 14.273 100 93 182 0 1415155920 29137024 22010304
23:47:03 7384 8192000000 10299234288 10718294016 1360409424 14.241 100 46 90 1 1401829552 30542256 10877872
23:48:13 2931 8192000000 10325865696 10736369664 1381437328 14.429 100 69 138 0 1428461312 30421680 16602304
23:49:29 1762 8192000000 10330828416 10739503104 1381260720 14.428 100 91 181 2 1432979376 28269056 23449600
23:50:33 13436 8192000000 10298190032 10734227456 1380293824 14.419 100 32 64 0 1411695888 23499424 7902640
23:51:53 38668 8192000000 10297149408 10744147968 1366683120 14.297 99 15 30 1 1402274208 31292432 4298656
23:53:34 39212 8192000000 10286807440 10740207616 1378712800 14.405 100 18 36 0 1407422976 23791232 4918944
23:55:28 17061 8192000000 10307343904 10739060736 1388856928 14.496 100 40 80 0 1408276096 10829744 8589424
23:56:54 50264 8192000000 10293045136 10732285952 1364655088 14.279 98 53 107 1 1389412928 12495712 12262128
23:58:49 98305 8192000000 10306130352 10751819776 1395207104 14.552 100 37 74 0 1419439264 15004272 9227888
00:01:38 16030 8192000000 10313718272 10762260480 1406319632 14.651 100 33 66 1 1429503776 15889344 7294800
00:02:57 47234 8192000000 10312957920 10764808192 1408151328 14.668 100 14 28 0 1426074336 14488656 3434352
00:04:50 28764 8192000000 10340171408 10779570176 1411229984 14.695 100 32 62 1 1439947072 20915744 7801344
00:06:20 23994 8192000000 10322683712 10782461952 1411120912 14.694 100 24 49 0 1437497168 20475536 5900720
00:07:45 50338 8192000000 10328425104 10787598336 1414000896 14.719 100 26 51 1 1448411632 27570080 6840656
00:09:41 38647 8192000000 10307159360 10760871936 1378087504 14.399 98 25 50 0 1404335824 20365280 5883040
00:11:20 22012 8192000000 10309018096 10763845632 1401500368 14.608 100 24 49 0 1425797952 18787056 5510528
00:12:59 99178 8192000000 10294023760 10756292608 1348417504 14.133 97 17 34 1 1373508192 21109520 3981168
00:15:38 51935 8192000000 10278515360 10720317440 1309964240 13.786 94 13 26 0 1322729280 9972416 2792624
00:17:36 12188 8192000000 10285860208 10718658560 1365161504 14.284 100 46 92 0 1385877312 10713456 10002352
00:18:53 80928 8192000000 10246758624 10679365632 1270185376 13.423 93 24 48 0 1285707456 9481696 6040384
00:21:16 23767 8192000000 10261740832 10688487424 1334662320 14.009 99 37 75 0 1353342784 10716800 7963664
00:22:45 35247 8192000000 10242215808 10676346880 1285815776 13.566 96 24 48 0 1302356624 11178560 5362288
00:24:27 118364 8192000000 10230860368 10672869376 1303292992 13.725 98 14 29 0 1321345616 14848816 3203808
00:27:48 93211 8192000000 10239148272 10681249792 1333458432 13.998 100 25 51 2 1356181552 17118688 5604432
00:30:24 60820 8192000000 10251468592 10699735040 1355813856 14.200 100 18 36 0 1371135312 11192928 4128528
00:32:32 35816 8192000000 10251024800 10692452352 1331274336 13.979 98 14 28 0 1346208272 11668064 3265872
00:34:12 54755 8192000000 10255195168 10707968000 1332351312 13.988 98 17 34 2 1355813248 19065312 4396624
00:36:08 38896 8192000000 10265597184 10722324480 1359840752 14.236 100 12 24 0 1378875248 16427536 2606960
00:37:49 17285 8192000000 10270558592 10710192128 1362939184 14.264 100 23 46 0 1377020720 9148736 4932800
00:39:08 41286 8192000000 10301730272 10736824320 1376206160 14.383 99 28 60 0 1397908832 15551232 6151440
00:40:50 70770 8192000000 10301072256 10746085376 1384930064 14.461 100 14 28 0 1405688192 17803024 2955104
00:43:44 31907 8192000000 10318017264 10760065024 1396098848 14.560 100 29 58 0 1417799632 15294080 6406704
00:45:17 38320 8192000000 10314942160 10757300224 1390493472 14.510 100 34 66 0 1417843616 20141920 7208224
00:47:02 87301 8192000000 10310619840 10746433536 1357607488 14.216 97 25 50 0 1376440064 13456016 5376560
00:49:29 34842 8192000000 10330162112 10767564800 1389542592 14.502 99 36 72 0 1409272176 12314688 7414896
00:51:07 90316 8192000000 10297455488 10754650112 1394062032 14.542 100 13 24 0 1411081920 14417200 2602688
00:53:44 25991 8192000000 10306936368 10762059776 1395366480 14.554 100 25 50 1 1416598656 15998848 5233328
00:55:10 58263 8192000000 10304456304 10769858560 1409738192 14.682 100 18 36 0 1425882368 12324368 3819808
00:57:59 56235 8192000000 10261295008 10709004288 1336837312 14.029 96 11 22 0 1351707536 12100192 2770032
00:59:55 41121 8192000000 10232590832 10681036800 1312949488 13.813 95 10 20 0 1324659488 9676624 2033376
01:01:36 46425 8192000000 10285132464 10730504192 1366453216 14.295 99 22 44 1 1379517344 8154688 4909440
01:03:31 35409 8192000000 10256729408 10702159872 1313853888 13.821 96 15 30 0 1324603952 7606016 3144048
01:05:07 45804 8192000000 10263515936 10703306752 1308294448 13.771 96 27 54 0 1324576752 10064528 6217776
01:07:07 77818 8192000000 10268891936 10710650880 1301539792 13.709 95 11 21 0 1318811216 14787600 2483824
01:09:25 28138 8192000000 9060781440 9295511552 158230624 1.894 12 2 4 0 160824800 2329584 264592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 14-03-2024 01:10:54 to 14-03-2024 01:11:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          184891
MON$OLDEST_ACTIVE               184892
MON$OLDEST_SNAPSHOT             184892
MON$NEXT_TRANSACTION            184892
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                       1908960
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Mar 14 01:11:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        96362 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    184891 
    Oldest active        184892 
    Oldest snapshot        184892 
    Next transaction    184893 
    Sequence number        0 
    Next attachment ID    731 
    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.04, total records: 7860928 
    Average version length: 48.16, total versions: 139892, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86920 
    Data pages: 86920, average fill: 72% 
    Primary pages: 86920, secondary pages: 0, swept pages: 12167 
    Empty pages: 2, full pages: 73845 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 18 
    40 - 59% = 513 
    60 - 79% = 86345 
    80 - 99% = 37 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23566, nodes: 7860928 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1774097, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 348 
        20 - 39% = 1664 
        40 - 59% = 4367 
        60 - 79% = 2246 
        80 - 99% = 14941 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13672, nodes: 7860928 
    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: 1595248, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1421 
        40 - 59% = 2311 
        60 - 79% = 1002 
        80 - 99% = 8938 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8466, nodes: 7860928 
    Average node length: 6.63, total dup: 5853666, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1588091, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 895 
        40 - 59% = 1537 
        60 - 79% = 822 
        80 - 99% = 5070 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.64, total records: 2298691 
    Average version length: 34.54, total versions: 141808, max versions: 3 
    Average fragment length: 7.50, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28592 
    Data pages: 28592, average fill: 75% 
    Primary pages: 28588, secondary pages: 4, swept pages: 7557 
    Empty pages: 0, full pages: 22846 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 46 
    40 - 59% = 823 
    60 - 79% = 26097 
    80 - 99% = 1620 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4650, nodes: 2298691 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708931, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 904 
        40 - 59% = 929 
        60 - 79% = 677 
        80 - 99% = 2140 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2545, nodes: 2302087 
    Average node length: 4.97, total dup: 2301188, max dup: 21154 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1267678, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 247 
        40 - 59% = 1521 
        60 - 79% = 566 
        80 - 99% = 208 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2036, nodes: 2298691 
    Average node length: 4.97, total dup: 2298641, max dup: 130822 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1075578, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 14 
        40 - 59% = 1102 
        60 - 79% = 57 
        80 - 99% = 858 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4412, nodes: 2298691 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 708931, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 98 
        20 - 39% = 572 
        40 - 59% = 656 
        60 - 79% = 778 
        80 - 99% = 2308 
 
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.36, total records: 400 
    Average version length: 22.64, total versions: 261247, max versions: 684 
    Average fragment length: 2.04, total fragments: 52, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1592 
    Data pages: 1456, average fill: 89% 
    Primary pages: 10, secondary pages: 1446, swept pages: 0 
    Empty pages: 3, full pages: 1452 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1449 
 
    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.13, total records: 126515 
    Average version length: 68.30, total versions: 104058, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.25 
    Pointer pages: 7, data page slots: 1824 
    Data pages: 1800, average fill: 86% 
    Primary pages: 1799, secondary pages: 1, swept pages: 0 
    Empty pages: 39, full pages: 1692 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 11 
    40 - 59% = 16 
    60 - 79% = 179 
    80 - 99% = 1545 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702973, depth: 3, leaf buckets: 331, nodes: 126515 
    Average node length: 13.24, total dup: 11044, max dup: 2 
    Average key length: 10.52, compression ratio: 2.57 
    Average prefix length: 19.39, average data length: 7.61 
    Clustering factor: 91931, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 180 
        60 - 79% = 92 
        80 - 99% = 58 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 18525, max versions: 1025 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 61 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 4.72, total records: 2098 
    Average version length: 43.39, total versions: 1880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 12.28 
    Pointer pages: 1, data page slots: 56 
    Data pages: 34, average fill: 58% 
    Primary pages: 33, secondary pages: 1, swept pages: 6 
    Empty pages: 9, full pages: 20 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91311, depth: 2, leaf buckets: 3, nodes: 2098 
    Average node length: 4.37, total dup: 2000, max dup: 265 
    Average key length: 2.49, compression ratio: 7.62 
    Average prefix length: 18.55, average data length: 0.45 
    Clustering factor: 1014, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.99, 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.66, total records: 788503 
    Average version length: 25.53, total versions: 82837, 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: 5, data page slots: 7928 
    Data pages: 7920, average fill: 70% 
    Primary pages: 7876, secondary pages: 44, swept pages: 936 
    Empty pages: 77, full pages: 7279 
    Fill distribution: 
     0 - 19% = 148 
    20 - 39% = 147 
    40 - 59% = 120 
    60 - 79% = 7195 
    80 - 99% = 310 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 864, nodes: 788503 
    Average node length: 4.87, total dup: 788454, max dup: 136251 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89851, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 117 
        40 - 59% = 496 
        60 - 79% = 196 
        80 - 99% = 55 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 909, nodes: 788503 
    Average node length: 5.88, total dup: 701806, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158556, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 111 
        40 - 59% = 340 
        60 - 79% = 165 
        80 - 99% = 288 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 949, nodes: 788503 
    Average node length: 5.88, total dup: 701806, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160503, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 198 
        40 - 59% = 319 
        60 - 79% = 150 
        80 - 99% = 282 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1121, nodes: 788503 
    Average node length: 5.96, total dup: 701806, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153684, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 235 
        40 - 59% = 595 
        60 - 79% = 196 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5439 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.46, total fragments: 78, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 78, secondary pages: 17, swept pages: 53 
    Empty pages: 11, full pages: 63 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5439 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.38, average data length: 1.55 
    Clustering factor: 5105, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5439 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 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: 84506 
    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: 816 
    Data pages: 816, average fill: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 813 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 814 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38055, depth: 2, leaf buckets: 108, nodes: 84506 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3401, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 106 
 
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.60, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 149.41, total records: 177792 
    Average version length: 147.08, total versions: 2112, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 5592 
    Data pages: 4264, average fill: 86% 
    Primary pages: 4264, secondary pages: 0, swept pages: 1 
    Empty pages: 39, full pages: 4207 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4207 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 148.75, total records: 182276 
    Average version length: 152.66, total versions: 2996, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 6, data page slots: 5880 
    Data pages: 4408, average fill: 85% 
    Primary pages: 4408, secondary pages: 0, swept pages: 1 
    Empty pages: 68, full pages: 4308 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 6 
    40 - 59% = 14 
    60 - 79% = 8 
    80 - 99% = 4308 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 111.02, total records: 238338 
    Average version length: 154.99, total versions: 63297, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 15.28 
    Pointer pages: 6, data page slots: 6392 
    Data pages: 5848, average fill: 87% 
    Primary pages: 5848, secondary pages: 0, swept pages: 7 
    Empty pages: 141, full pages: 5670 
    Fill distribution: 
     0 - 19% = 145 
    20 - 39% = 9 
    40 - 59% = 14 
    60 - 79% = 13 
    80 - 99% = 5667 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 138.95, total records: 174572 
    Average version length: 154.36, total versions: 13792, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.21 
    Pointer pages: 6, data page slots: 5504 
    Data pages: 4240, average fill: 85% 
    Primary pages: 4240, secondary pages: 0, swept pages: 1 
    Empty pages: 89, full pages: 4130 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4130 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.09, total records: 153603 
    Average version length: 147.20, total versions: 1851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 5640 
    Data pages: 3704, average fill: 85% 
    Primary pages: 3704, secondary pages: 0, swept pages: 2 
    Empty pages: 57, full pages: 3627 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3626 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.57, total records: 168435 
    Average version length: 151.87, total versions: 3844, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 5024 
    Data pages: 4072, average fill: 85% 
    Primary pages: 4070, secondary pages: 2, swept pages: 2 
    Empty pages: 68, full pages: 3981 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3981 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 143.93, total records: 192896 
    Average version length: 153.41, total versions: 9168, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 6, data page slots: 5584 
    Data pages: 4688, average fill: 85% 
    Primary pages: 4688, secondary pages: 0, swept pages: 3 
    Empty pages: 99, full pages: 4566 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4565 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 128.22, total records: 197780 
    Average version length: 154.79, total versions: 29847, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.23 
    Pointer pages: 9, data page slots: 5872 
    Data pages: 4776, average fill: 87% 
    Primary pages: 4776, secondary pages: 0, swept pages: 3 
    Empty pages: 59, full pages: 4686 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 11 
    40 - 59% = 7 
    60 - 79% = 13 
    80 - 99% = 4685 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 142.64, total records: 183519 
    Average version length: 153.28, total versions: 10137, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 7, data page slots: 5904 
    Data pages: 4464, average fill: 85% 
    Primary pages: 4464, secondary pages: 0, swept pages: 1 
    Empty pages: 97, full pages: 4335 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 10 
    40 - 59% = 9 
    60 - 79% = 10 
    80 - 99% = 4337 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.08, total records: 186245 
    Average version length: 151.65, total versions: 5016, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 8, data page slots: 5152 
    Data pages: 4504, average fill: 85% 
    Primary pages: 4504, secondary pages: 0, swept pages: 4 
    Empty pages: 74, full pages: 4403 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 13 
    80 - 99% = 4402 
 
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.32, total records: 2156782 
    Average version length: 52.97, total versions: 58691, 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: 25584 
    Data pages: 25584, average fill: 73% 
    Primary pages: 25584, secondary pages: 0, swept pages: 9049 
    Empty pages: 175, full pages: 22544 
    Fill distribution: 
     0 - 19% = 320 
    20 - 39% = 257 
    40 - 59% = 642 
    60 - 79% = 23802 
    80 - 99% = 563 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2637, nodes: 2156782 
    Average node length: 5.44, total dup: 2014361, max dup: 1416 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 185876, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 294 
        40 - 59% = 1738 
        60 - 79% = 310 
        80 - 99% = 293 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2768, nodes: 2156782 
    Average node length: 5.69, total dup: 1936674, max dup: 67 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 384667, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2270 
        60 - 79% = 454 
        80 - 99% = 40 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2216, nodes: 2156782 
    Average node length: 4.96, total dup: 2156682, max dup: 28474 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 183035, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 188 
        40 - 59% = 1240 
        60 - 79% = 400 
        80 - 99% = 387 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.84, total records: 168358 
    Average version length: 69.17, total versions: 78764, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.42 
    Pointer pages: 3, data page slots: 4224 
    Data pages: 2832, average fill: 69% 
    Primary pages: 2832, secondary pages: 0, swept pages: 255 
    Empty pages: 376, full pages: 2328 
    Fill distribution: 
     0 - 19% = 449 
    20 - 39% = 5 
    40 - 59% = 10 
    60 - 79% = 805 
    80 - 99% = 1563 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104107, depth: 3, leaf buckets: 222, nodes: 168358 
    Average node length: 6.44, total dup: 146794, max dup: 29 
    Average key length: 3.90, compression ratio: 10.77 
    Average prefix length: 40.23, average data length: 1.77 
    Clustering factor: 28454, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 84 
        60 - 79% = 82 
        80 - 99% = 35 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.79, total records: 7161579 
    Average version length: 68.81, total versions: 536679, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 62, data page slots: 99816 
    Data pages: 99816, average fill: 77% 
    Primary pages: 99816, secondary pages: 0, swept pages: 13314 
    Empty pages: 16, full pages: 94317 
    Fill distribution: 
     0 - 19% = 140 
    20 - 39% = 634 
    40 - 59% = 2034 
    60 - 79% = 84578 
    80 - 99% = 12430 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10619, nodes: 7161579 
    Average node length: 6.50, total dup: 6200763, max dup: 41 
    Average key length: 3.51, compression ratio: 11.97 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1595773, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1753 
        40 - 59% = 5241 
        60 - 79% = 2901 
        80 - 99% = 716 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8517, nodes: 7161579 
    Average node length: 5.39, total dup: 6881250, max dup: 189 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1388287, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1070 
        40 - 59% = 4688 
        60 - 79% = 1679 
        80 - 99% = 1069 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8582, nodes: 7161579 
    Average node length: 5.39, total dup: 6881250, max dup: 189 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1390828, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1157 
        40 - 59% = 4676 
        60 - 79% = 1694 
        80 - 99% = 1050 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.19, total records: 12046374 
    Average version length: 68.73, total versions: 482871, 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: 102, data page slots: 165040 
    Data pages: 165040, average fill: 78% 
    Primary pages: 165040, secondary pages: 0, swept pages: 55682 
    Empty pages: 3, full pages: 164387 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 36 
    40 - 59% = 168 
    60 - 79% = 152913 
    80 - 99% = 11920 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18167, nodes: 12046374 
    Average node length: 6.57, total dup: 10500885, max dup: 84 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2385087, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2386 
        40 - 59% = 10260 
        60 - 79% = 4519 
        80 - 99% = 969 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 36.47, total records: 2056699 
    Average version length: 69.12, total versions: 971899, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.45 
    Pointer pages: 26, data page slots: 41448 
    Data pages: 31592, average fill: 76% 
    Primary pages: 31592, secondary pages: 0, swept pages: 3434 
    Empty pages: 1309, full pages: 26602 
    Fill distribution: 
     0 - 19% = 2372 
    20 - 39% = 1225 
    40 - 59% = 885 
    60 - 79% = 10401 
    80 - 99% = 16709 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2416, nodes: 2056699 
    Average node length: 5.50, total dup: 1973631, max dup: 99 
    Average key length: 2.54, compression ratio: 16.55 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 144248, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 219 
        40 - 59% = 1165 
        60 - 79% = 741 
        80 - 99% = 277 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.32, total records: 1319952 
    Average version length: 69.15, total versions: 644401, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.57 
    Pointer pages: 19, data page slots: 30664 
    Data pages: 26392, average fill: 58% 
    Primary pages: 26392, secondary pages: 0, swept pages: 4607 
    Empty pages: 4290, full pages: 16537 
    Fill distribution: 
     0 - 19% = 6694 
    20 - 39% = 1443 
    40 - 59% = 784 
    60 - 79% = 5776 
    80 - 99% = 11695 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1668, nodes: 1319952 
    Average node length: 5.71, total dup: 1240925, max dup: 120 
    Average key length: 2.77, compression ratio: 15.17 
    Average prefix length: 41.29, average data length: 0.71 
    Clustering factor: 177433, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 257 
        40 - 59% = 783 
        60 - 79% = 447 
        80 - 99% = 179 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.70, total records: 9609252 
    Average version length: 68.98, total versions: 724175, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 89, data page slots: 144200 
    Data pages: 144192, average fill: 72% 
    Primary pages: 144192, secondary pages: 0, swept pages: 37526 
    Empty pages: 281, full pages: 96286 
    Fill distribution: 
     0 - 19% = 885 
    20 - 39% = 3890 
    40 - 59% = 17067 
    60 - 79% = 107738 
    80 - 99% = 14612 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13556, nodes: 9609252 
    Average node length: 6.68, total dup: 7972971, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2108928, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 922 
        40 - 59% = 6437 
        60 - 79% = 5197 
        80 - 99% = 999 
 
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: 21223729 
    Average version length: 82.91, total versions: 20693, 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: 319704 
    Data pages: 319704, average fill: 81% 
    Primary pages: 319704, secondary pages: 0, swept pages: 12098 
    Empty pages: 4, full pages: 319700 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 27097 
    80 - 99% = 292603 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19525, nodes: 21223729 
    Average node length: 5.72, total dup: 20741302, max dup: 129 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3292269, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8311 
        60 - 79% = 571 
        80 - 99% = 10640 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17268, nodes: 21223729 
    Average node length: 6.31, total dup: 18651216, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918645, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 851 
        60 - 79% = 282 
        80 - 99% = 16132 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21308, nodes: 21223729 
    Average node length: 6.35, total dup: 18570390, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3588347, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 8549 
        60 - 79% = 657 
        80 - 99% = 12100 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16229, nodes: 21223729 
    Average node length: 5.56, total dup: 21223629, max dup: 233527 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947468, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 3023 
        60 - 79% = 420 
        80 - 99% = 12777 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.84, total records: 10024321 
    Average version length: 82.63, total versions: 679635, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 105, data page slots: 170776 
    Data pages: 170736, average fill: 73% 
    Primary pages: 170736, secondary pages: 0, swept pages: 55681 
    Empty pages: 409, full pages: 113291 
    Fill distribution: 
     0 - 19% = 1289 
    20 - 39% = 5232 
    40 - 59% = 20812 
    60 - 79% = 66489 
    80 - 99% = 76914 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11433, nodes: 10024321 
    Average node length: 5.36, total dup: 9711455, max dup: 200 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2222025, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 55 
        40 - 59% = 7396 
        60 - 79% = 3829 
        80 - 99% = 150 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13789, nodes: 10024321 
    Average node length: 6.23, total dup: 8313123, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1550170, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 3866 
        40 - 59% = 4419 
        60 - 79% = 2689 
        80 - 99% = 2670 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12764, nodes: 10024321 
    Average node length: 5.97, total dup: 8708015, max dup: 52 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2422197, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 69 
        40 - 59% = 8324 
        60 - 79% = 4206 
        80 - 99% = 162 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10436, nodes: 10024321 
    Average node length: 5.13, total dup: 10024221, max dup: 166546 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1575077, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1231 
        40 - 59% = 5270 
        60 - 79% = 1737 
        80 - 99% = 2155 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.56, total records: 11757873 
    Average version length: 82.57, total versions: 536687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 120, data page slots: 194504 
    Data pages: 193144, average fill: 75% 
    Primary pages: 193144, secondary pages: 0, swept pages: 59096 
    Empty pages: 2314, full pages: 154120 
    Fill distribution: 
     0 - 19% = 3847 
    20 - 39% = 5391 
    40 - 59% = 14567 
    60 - 79% = 41225 
    80 - 99% = 128114 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13202, nodes: 11757873 
    Average node length: 5.31, total dup: 11647103, max dup: 647 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2454073, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 71 
        40 - 59% = 8243 
        60 - 79% = 4493 
        80 - 99% = 393 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10788, nodes: 11757873 
    Average node length: 5.51, total dup: 11245761, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 742825, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 170 
        20 - 39% = 776 
        40 - 59% = 2673 
        60 - 79% = 1835 
        80 - 99% = 5334 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15101, nodes: 11757873 
    Average node length: 6.03, total dup: 10269072, max dup: 77 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2470809, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 87 
        40 - 59% = 9723 
        60 - 79% = 4825 
        80 - 99% = 461 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11236, nodes: 11757873 
    Average node length: 5.23, total dup: 11757773, max dup: 213181 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 731122, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 848 
        40 - 59% = 5075 
        60 - 79% = 1585 
        80 - 99% = 3635 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.11, total records: 10151647 
    Average version length: 82.91, total versions: 690812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 107, data page slots: 174472 
    Data pages: 174448, average fill: 72% 
    Primary pages: 174448, secondary pages: 0, swept pages: 56461 
    Empty pages: 452, full pages: 113738 
    Fill distribution: 
     0 - 19% = 1431 
    20 - 39% = 5658 
    40 - 59% = 22447 
    60 - 79% = 68977 
    80 - 99% = 75935 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12171, nodes: 10151647 
    Average node length: 5.18, total dup: 10122028, max dup: 1709 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2029242, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1396 
        40 - 59% = 8188 
        60 - 79% = 1901 
        80 - 99% = 662 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13918, nodes: 10151647 
    Average node length: 6.25, total dup: 8417412, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1519987, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 177 
        20 - 39% = 3824 
        40 - 59% = 4447 
        60 - 79% = 2666 
        80 - 99% = 2804 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12791, nodes: 10151647 
    Average node length: 5.43, total dup: 9699405, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2168103, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1324 
        40 - 59% = 9059 
        60 - 79% = 1739 
        80 - 99% = 635 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10637, nodes: 10151647 
    Average node length: 5.15, total dup: 10151547, max dup: 168779 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1599598, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1265 
        40 - 59% = 5464 
        60 - 79% = 1701 
        80 - 99% = 2173 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.17, total records: 584387 
    Average version length: 68.82, total versions: 8629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8056 
    Data pages: 8056, average fill: 76% 
    Primary pages: 8056, secondary pages: 0, swept pages: 3433 
    Empty pages: 1, full pages: 7092 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 12 
    40 - 59% = 143 
    60 - 79% = 7758 
    80 - 99% = 142 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 49002, depth: 3, leaf buckets: 751, nodes: 584387 
    Average node length: 5.95, total dup: 497799, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101453, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 539 
        60 - 79% = 104 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 41491, depth: 3, leaf buckets: 771, nodes: 584387 
    Average node length: 6.15, total dup: 479426, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101496, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 540 
        60 - 79% = 99 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 589, nodes: 584387 
    Average node length: 4.86, total dup: 584287, max dup: 9932 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90066, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 366 
        60 - 79% = 64 
        80 - 99% = 120 
 
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 14 01:11:36 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7860928 139892 1 0.0000 0.0000
DOC_LIST 2298691 141808 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 261247 684 65300.0000 0.0000
INVNT_TURNOVER_LOG 126515 104058 1 0.0000 0.0000
MONEY_SALDO 49 18525 1025 37800.0000 0.0000
MONEY_TURNOVER_LOG 2098 1880 1 0.0000 0.0000
PDISTR 788503 82837 4 0.0000 0.0000
PERF_SPLIT_0 177792 2112 1 0.0000 0.0000
PERF_SPLIT_1 182276 2996 1 0.0000 0.0000
PERF_SPLIT_2 238338 63297 1 0.0000 0.0000
PERF_SPLIT_3 174572 13792 1 0.0000 0.0000
PERF_SPLIT_4 153603 1851 1 0.0000 0.0000
PERF_SPLIT_5 168435 3844 1 0.0000 0.0000
PERF_SPLIT_6 192896 9168 1 0.0000 0.0000
PERF_SPLIT_7 197780 29847 1 0.0000 0.0000
PERF_SPLIT_8 183519 10137 1 0.0000 0.0000
PERF_SPLIT_9 186245 5016 1 0.0000 0.0000
PSTORNED 2156782 58691 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 168358 78764 1 0.0000 0.0000
XQD_1000_3300 7161579 536679 1 0.0000 0.0000
XQD_1200_2000 12046374 482871 1 0.0000 0.0000
XQD_2000_3300 2056699 971899 1 0.0000 0.0000
XQD_2100_3300 1319952 644401 1 0.0000 0.0000
XQD_3300_3400 9609252 724175 1 0.0000 0.0000
XQS_1000_1200 21223729 20693 1 0.0000 0.0000
XQS_1000_3300 10024321 679635 1 0.0000 0.0000
XQS_1200_2000 11757873 536687 1 0.0000 0.0000
XQS_2100_3300 10151647 690812 1 0.0000 0.0000
XQS_3300_3400 584387 8629 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 ---
:305: 
:306: mscs-test-161.budzdorov.ru    Thu Mar 14 01:09:56 2024
:307:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:308: 
--- end of diff output ---

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

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