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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-14 19:09:50
DTS_END                         2024-04-14 19:09:50.4820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37652
TRN_ID                          173631
ATT_ID                          570
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: 9327.68 19745 932768
customer order: creation 169.97 356 16997
customer order: refuse 15.08 404 1508
order to supplier: creation 47.32 1310 4732
order to supplier: removal 3.61 94994 361
invoice (draft): creation 47.16 3290 4716
invoice (draft): removal 52.69 786 5269
invoice accept: apply 42.72 19852 4272
invoice accept: cancel 47.49 789 4749
customer reserve: creation 4055.28 191 405528
customer reserve: removal 4546.64 58 454664
realization accept: apply 86.05 208 8605
realization accept: cancel 84.30 103 8430
payment from customer: creation 59.34 140 5934
payment from customer: removal 5.71 78 571
payment to supplier: creation 49.10 180 4910
payment to supplier: removal 3.46 83 346
service: total inventory turnovers 4.77 1137 477
service: total monetary turnovers 6.12 37 612
service: aggregate perf. data 0.84 17499 84
service: refresh index statistics 0.03 253405 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-04-2024 19:10:56 to 14-04-2024 19:10:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3212
TEST_TIME 2 4176
TEST_TIME 3 5309
TEST_TIME 4 5282
TEST_TIME 5 5074
TEST_TIME 6 5326
TEST_TIME 7 4931
TEST_TIME 8 5347
TEST_TIME 9 5443
TEST_TIME 10 5522
TEST_TIME 11 5414
TEST_TIME 12 5428
TEST_TIME 13 6064
TEST_TIME 14 6217
TEST_TIME 15 6480
TEST_TIME 16 6571
TEST_TIME 17 6844
TEST_TIME 18 6968
TEST_TIME 19 7192
TEST_TIME 20 7265
TEST_TIME 21 7822
TEST_TIME 22 7882
TEST_TIME 23 8207
TEST_TIME 24 8281
TEST_TIME 25 8626
TEST_TIME 26 8792
TEST_TIME 27 8980
TEST_TIME 28 9314
TEST_TIME 29 9314
TEST_TIME 30 9250
TEST_TIME 31 9481
TEST_TIME 32 9350
TEST_TIME 33 9405
TEST_TIME 34 9382
TEST_TIME 35 9230
TEST_TIME 36 9355
TEST_TIME 37 9351
TEST_TIME 38 9341
TEST_TIME 39 9483
TEST_TIME 40 9519
TEST_TIME 41 9451
TEST_TIME 42 9465
TEST_TIME 43 9555
TEST_TIME 44 9385
TEST_TIME 45 9325
TEST_TIME 46 9255
TEST_TIME 47 9174
TEST_TIME 48 9145
TEST_TIME 49 9095
TEST_TIME 50 9082
TEST_TIME 51 9145
TEST_TIME 52 9078
TEST_TIME 53 9214
TEST_TIME 54 9191
TEST_TIME 55 9335
TEST_TIME 56 9374
TEST_TIME 57 9277
TEST_TIME 58 9204
TEST_TIME 59 9115
TEST_TIME 60 9352
TEST_TIME 61 9275
TEST_TIME 62 9278
TEST_TIME 63 9205
TEST_TIME 64 9250
TEST_TIME 65 9192
TEST_TIME 66 9142
TEST_TIME 67 9167
TEST_TIME 68 9120
TEST_TIME 69 9162
TEST_TIME 70 9148
TEST_TIME 71 9265
TEST_TIME 72 9275
TEST_TIME 73 9292
TEST_TIME 74 9271
TEST_TIME 75 9351
TEST_TIME 76 9370
TEST_TIME 77 9379
TEST_TIME 78 9457
TEST_TIME 79 9533
TEST_TIME 80 9592
TEST_TIME 81 9603
TEST_TIME 82 9608
TEST_TIME 83 9567
TEST_TIME 84 9483
TEST_TIME 85 9475
TEST_TIME 86 9448
TEST_TIME 87 9444
TEST_TIME 88 9429
TEST_TIME 89 9442
TEST_TIME 90 9392
TEST_TIME 91 9384
TEST_TIME 92 9336
TEST_TIME 93 9272
TEST_TIME 94 9281
TEST_TIME 95 9296
TEST_TIME 96 9277
TEST_TIME 97 9276
TEST_TIME 98 9288
TEST_TIME 99 9316
TEST_TIME 100 9341

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-04-2024 19:10:59 to 14-04-2024 19:11:02.

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 1301880 1301880 0 0.00 0 39591 7 0 0
doc_list_biud 1301875 1301875 0 0.00 0 32869 26 0 0
sp_add_invoice_to_stock 4370 4272 98 2.24 29 240383 19853 0 98
sp_cancel_adding_invoice 4749 4749 0 0.00 4 65120 790 0 0
sp_cancel_client_order 1508 1508 0 0.00 4 12895 404 0 0
sp_cancel_customer_reserve 454664 454664 0 0.00 0 32874 59 0 0
sp_cancel_pay_from_customer 571 571 0 0.00 3 3428 78 0 0
sp_cancel_pay_to_supplier 346 346 0 0.00 3 4659 83 0 0
sp_cancel_supplier_invoice 5276 5269 7 0.13 2 19712 787 0 7
sp_cancel_supplier_order 361 361 0 0.00 9 1025179 94995 0 0
sp_cancel_write_off 8430 8430 0 0.00 1 8555 104 0 0
sp_client_order 16997 16997 0 0.00 3 30679 356 0 0
sp_customer_reserve 405528 405528 0 0.00 0 40759 191 0 0
sp_fill_shopping_cart 26437 26437 0 0.00 1 23658 41 0 0
sp_fill_shopping_cart_clo_res 405506 405506 0 0.00 0 16442 14 0 0
sp_get_clo_for_invoice 4247 4247 0 0.00 0 35226 297 0 0
sp_kill_cost_storno 14096 14096 0 0.00 0 12657 60 0 0
sp_kill_qstorno_ret_qs2qd 923388 923388 0 0.00 0 32867 32 0 0
sp_kill_qty_storno 487833 487833 0 0.00 0 32869 70 0 0
sp_lock_selected_doc 17704 17704 0 0.00 0 7212 7 0 0
sp_make_cost_storno 23696 23696 0 0.00 0 39577 70 0 0
sp_multiply_rows_for_pdistr 23695 23695 0 0.00 0 14125 35 0 0
sp_multiply_rows_for_qdistr 16997 16997 0 0.00 0 17472 148 0 0
sp_pay_from_customer 5934 5934 0 0.00 4 12297 140 0 0
sp_pay_to_supplier 4910 4910 0 0.00 4 40712 180 0 0
sp_payment_common 10843 10843 0 0.00 1 11806 42 0 0
sp_qd_handle_on_cancel_clo 1508 1508 0 0.00 0 12890 366 0 0
sp_qd_handle_on_invoice_upd_sts 8996 8996 0 0.00 0 17819 335 0 0
sp_qd_handle_on_reserve_upd_sts 8605 8605 0 0.00 0 18734 64 0 0
sp_reserve_write_off 8605 8605 0 0.00 6 18752 209 0 0
sp_supplier_invoice 4716 4716 0 0.00 5 91904 3291 0 0
sp_supplier_order 4732 4732 0 0.00 6 97326 1311 0 0
srv_aggregate_perf_data 84 84 0 0.00 1895 227544 17499 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1206 143104 43052 0 0
srv_find_qd_qs_mism 888982 888982 0 0.00 0 27077 6 0 0
srv_make_invnt_saldo 477 477 0 0.00 39 65637 1138 0 0
srv_make_money_saldo 612 612 0 0.00 1 4827 38 0 0
srv_recalc_idx_stat 3 3 0 0.00 184561 373295 253405 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4273 4273 0 0.00 0 8741 209 0 0
t$perf-norm:sp_cancel_adding_invoice 339 339 0 0.00 0 4161 104 0 0
t$perf-norm:sp_cancel_client_order 1508 1508 0 0.00 0 3633 18 0 0
t$perf-norm:sp_cancel_customer_reserve 557 557 0 0.00 0 1633 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 571 571 0 0.00 0 1136 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 346 346 0 0.00 0 1269 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 337 337 0 0.00 0 601 13 0 0
t$perf-norm:sp_cancel_supplier_order 361 361 0 0.00 0 19572 1716 0 0
t$perf-norm:sp_cancel_write_off 833 833 0 0.00 0 2140 7 0 0
t$perf-norm:sp_client_order 16997 16997 0 0.00 0 12192 19 0 0
t$perf-norm:sp_customer_reserve 838 838 0 0.00 0 1141 5 0 0
t$perf-norm:sp_pay_from_customer 5934 5934 0 0.00 0 4368 12 0 0
t$perf-norm:sp_pay_to_supplier 4910 4910 0 0.00 0 12916 14 0 0
t$perf-norm:sp_reserve_write_off 8605 8605 0 0.00 0 3932 9 0 0
t$perf-norm:sp_supplier_invoice 4716 4716 0 0.00 0 5229 20 0 0
t$perf-norm:sp_supplier_order 4732 4732 0 0.00 0 4339 16 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 152 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 1423 56 0 0
t$perf-norm:srv_make_invnt_saldo 477 477 0 0.00 0 915 24 0 0
t$perf-norm:srv_make_money_saldo 612 612 0 0.00 0 1215 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 4 7 6 0 0
v_add_invoice_to_stock 8690 8494 196 2.25 0 7760 20 0 196
v_all_customers 31282 31282 0 0.00 0 26 1 0 0
v_all_suppliers 26530 26530 0 0.00 0 30 1 0 0
v_all_wares 33990 33990 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 678 678 0 0.00 0 1743 10 0 0
v_cancel_client_order 3016 3016 0 0.00 0 7499 11 0 0
v_cancel_customer_prepayment 1142 1142 0 0.00 0 1328 6 0 0
v_cancel_customer_reserve 1114 1114 0 0.00 0 882 5 0 0
v_cancel_payment_to_supplier 692 692 0 0.00 0 512 5 0 0
v_cancel_supplier_invoice 688 674 14 2.03 0 1400 17 0 14
v_cancel_supplier_order 722 722 0 0.00 0 2143 10 0 0
v_cancel_write_off 1666 1666 0 0.00 0 5297 17 0 0
v_max_id_clo_ord 4729 4729 0 0.00 0 12970 4 0 0
v_max_id_clo_res 838 838 0 0.00 0 2466 15 0 0
v_max_id_ord_sup 4712 4712 0 0.00 0 6017 4 0 0
v_max_non_paid_invoice 1084 1084 0 0.00 0 474 3 0 0
v_max_non_paid_realizn 3081 3081 0 0.00 0 4333 8 0 0
v_min_id_clo_ord 4729 4729 0 0.00 0 11324 17 0 0
v_min_id_clo_res 838 838 0 0.00 0 6303 14 0 0
v_min_id_ord_sup 4712 4712 0 0.00 0 4372 4 0 0
v_min_non_paid_invoice 4909 4909 0 0.00 0 8269 32 0 0
v_min_non_paid_realizn 5934 5934 0 0.00 0 10064 31 0 0
v_our_firm 8414 8414 0 0.00 0 15 1 0 0
v_reserve_write_off 17210 17210 0 0.00 0 8275 9 0 0
x_lock_depdocs_on_canc_invoice 9681 9681 0 0.00 0 17437 121 0 0
x_lock_depdocs_on_canc_sup_ord 361 361 0 0.00 0 5589 306 0 0
x_make_qstorno_1000_1200 4732 4732 0 0.00 1 97317 1207 0 0
x_make_qstorno_1200_2000 4716 4716 0 0.00 2 91883 3160 0 0
x_make_qstorno_2100_3300 405528 405528 0 0.00 0 40756 174 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:54 3 8192000000 8801736448 8813973504 7759792 0.094 2 2 3 0 7900880 66144 74944
17:10:55 15884 8192000000 9873502656 10177798144 958630752 10.476 100 89 178 0 987868400 5257824 23979824
17:12:13 26417 8192000000 9939188240 10259193856 1022325040 11.094 100 88 176 0 1052246208 7035872 22885296
17:13:49 17987 8192000000 9980001024 10308825088 1067625424 11.529 100 88 176 1 1099129456 9256640 22247392
17:15:12 14625 8192000000 10029613520 10377388032 1116245520 11.992 100 83 166 0 1146447216 9910816 20290880
17:16:33 7921 8192000000 10083893568 10443808768 1168740192 12.485 100 81 160 1 1199221136 12046112 18434832
17:17:46 3532 8192000000 10120820896 10487463936 1206162736 12.834 100 73 146 0 1235340640 13024432 16153472
17:18:51 4853 8192000000 10151994976 10529525760 1248683088 13.226 100 68 135 0 1275361392 11876816 14801488
17:19:58 1518 8192000000 10186765104 10572648448 1278263888 13.497 100 79 159 0 1307397520 11943728 17189904
17:21:01 1619 8192000000 10211300544 10597818368 1296229056 13.661 100 84 168 2 1328581056 13699632 18652368
17:22:04 4462 8192000000 10208232144 10610647040 1308201952 13.770 100 48 96 0 1333505200 15029296 10273952
17:23:13 9689 8192000000 10214586976 10624815104 1320513072 13.881 100 32 69 1 1333847184 5631680 7702432
17:24:24 8934 8192000000 10212486544 10628612096 1323880896 13.912 100 27 54 0 1335686608 6274704 5531008
17:25:36 4581 8192000000 10214698896 10635718656 1328661744 13.955 100 22 44 0 1340303408 6581472 5060192
17:26:43 10128 8192000000 10227103936 10646163456 1335519568 14.017 100 21 40 2 1345632128 5454336 4658224
17:27:53 60428 8192000000 10223241312 10646355968 1320545360 13.882 99 22 44 0 1330649072 5272656 4831056
17:29:58 28544 8192000000 10238735776 10647851008 1326496480 13.935 99 47 93 0 1345027472 8026352 10504640
17:31:36 28028 8192000000 10253405744 10664837120 1340277376 14.060 99 56 112 0 1364739056 12076768 12384912
17:33:11 34385 8192000000 10255195200 10674307072 1337564592 14.035 98 41 82 1 1358848096 11119872 10163632
17:35:09 25527 8192000000 10244580944 10663190528 1323623664 13.910 98 27 54 0 1341501808 11414096 6464048
17:36:47 7927 8192000000 10250894432 10659131392 1319574464 13.873 98 47 94 2 1345943888 15454592 10914832
17:38:02 34624 8192000000 10223535584 10628403200 1274220944 13.460 96 37 74 0 1300376976 17193264 8962768
17:39:42 13065 8192000000 10236368112 10637115392 1296545440 13.664 97 51 98 0 1328887024 21242064 11099520
17:41:00 6162 8192000000 10261238864 10666115072 1332756880 13.992 100 57 115 1 1372528704 26182864 13588960
17:42:26 3646 8192000000 10280054496 10689683456 1352841648 14.173 100 61 123 0 1395824416 27069664 15913104
17:43:37 7376 8192000000 10285420416 10690490368 1352047456 14.166 100 60 117 0 1395072112 29636784 13387872
17:44:50 1204 8192000000 10310832128 10711638016 1364002816 14.273 100 83 165 0 1416704224 33250144 19451264
17:45:56 3128 8192000000 10319024272 10720018432 1370919280 14.335 100 79 158 1 1427940752 38086544 18934928
17:47:07 8112 8192000000 10339370448 10738798592 1383291264 14.446 100 82 162 2 1443067632 40716240 19060128
17:48:19 7144 8192000000 10330394512 10738782208 1379701328 14.414 100 66 132 0 1439509856 43400112 16408416
17:49:32 3599 8192000000 10353910720 10762366976 1395681184 14.557 100 82 163 1 1461664704 45870640 20112880
17:50:39 12486 8192000000 10328576880 10756120576 1392134400 14.525 100 49 98 0 1448573680 43661152 12778128
17:52:13 14814 8192000000 10328910880 10764259328 1392720368 14.530 100 30 60 1 1449457056 48503200 8233488
17:53:36 23622 8192000000 10338269872 10775289856 1391830736 14.522 100 30 56 0 1444010672 43731680 8448256
17:55:26 23651 8192000000 10306550784 10758316032 1355514304 14.197 98 19 38 0 1397716272 36503408 5698560
17:56:53 17657 8192000000 10307778816 10753519616 1383227856 14.445 100 34 65 1 1412892480 22133584 7531040
17:58:28 34441 8192000000 10311682704 10750185472 1389987808 14.506 100 20 39 1 1411999456 17587392 4424256
18:00:12 56208 8192000000 10302940320 10748243968 1396403792 14.563 100 15 28 1 1410165248 10962336 2799120
18:02:12 112212 8192000000 10306093024 10763309056 1396640976 14.565 100 11 21 0 1408657936 10130272 1886688
18:05:04 57441 8192000000 10312453296 10770522112 1406372560 14.652 100 11 22 0 1421148800 12604160 2172080
18:07:02 37510 8192000000 10331297008 10778632192 1413571552 14.716 100 21 38 1 1429865952 11501488 4792912
18:08:44 113179 8192000000 10296167776 10749652992 1344856960 14.101 95 17 32 0 1359947056 11745920 3344176
18:11:40 143104 8192000000 10327045968 10772512768 1354796336 14.191 96 26 53 3 1369715920 8675536 6244048
18:15:06 31434 8192000000 10307877168 10751934464 1355242992 14.195 97 50 100 0 1387263024 19621696 12398336
18:16:48 21788 8192000000 10291168192 10735316992 1371327360 14.339 98 23 46 0 1389699296 13300416 5071520
18:18:13 26238 8192000000 10323021632 10757865472 1372043792 14.345 98 57 113 0 1405779216 20283328 13452096
18:19:57 37122 8192000000 10280759504 10725801984 1340555008 14.062 98 26 52 0 1370669584 23426144 6688432
18:21:47 48710 8192000000 10283446640 10729385984 1347341920 14.124 98 27 53 0 1377382368 23410080 6630368
18:23:41 52405 8192000000 10270980752 10736046080 1367659904 14.306 100 19 38 1 1395030816 22398368 4972544
18:25:37 99738 8192000000 10271701248 10719305728 1320184112 13.878 96 20 40 0 1337367680 12574016 4609552
18:28:18 70341 8192000000 10275762592 10733846528 1327645136 13.946 97 14 29 0 1357878768 26788800 3444832
18:30:31 76929 8192000000 10242931120 10700709888 1323484416 13.908 98 15 30 0 1339616960 12612512 3520032
18:33:22 49750 8192000000 10249837152 10704961536 1330223824 13.969 99 16 29 2 1347446464 14164048 3058592
18:35:24 71438 8192000000 10232248528 10682241024 1293946624 13.640 96 10 20 0 1302960256 6802608 2211024
18:37:40 33635 8192000000 10266377264 10707783680 1332449792 13.989 98 37 74 0 1350744336 10347680 7946864
18:39:18 42587 8192000000 10272617664 10714505216 1335922240 14.021 98 26 52 0 1353443792 12040800 5480752
18:41:01 64080 8192000000 10265666096 10721107968 1329661104 13.964 97 13 24 1 1343285600 10680896 2943600
18:43:06 8151 8192000000 10297846176 10731352064 1375544096 14.377 100 48 93 0 1394220480 7699568 10976816
18:44:28 60196 8192000000 10296617920 10738909184 1368906736 14.317 99 36 72 0 1387583760 10197440 8479584
18:46:28 68610 8192000000 10296605376 10745798656 1360620384 14.243 98 13 26 0 1378880496 15270880 2989232
18:48:38 77120 8192000000 10303124912 10771709952 1372222064 14.347 99 11 22 0 1397106672 22385152 2499456
18:51:01 88627 8192000000 10305381936 10763280384 1378333776 14.402 99 12 24 3 1399197392 18130448 2733168
18:53:30 96111 8192000000 10304032768 10757279744 1375976864 14.381 99 37 74 2 1396272224 12221360 8074000
18:56:07 1663 8192000000 10306551344 10761351168 1390188000 14.508 100 48 94 3 1414626640 13953984 10484656
18:57:10 22586 8192000000 10299415728 10757156864 1395734032 14.557 100 28 55 0 1409706256 8025552 5946672
18:58:36 41450 8192000000 10263006656 10729619456 1353525344 14.179 98 12 24 0 1363600384 7253296 2821744
19:00:19 67212 8192000000 10290846512 10749759488 1389686608 14.503 100 17 34 0 1408293504 14474672 4132224
19:02:30 91591 8192000000 10285287536 10747953152 1380308080 14.419 99 25 50 0 1396958832 10971312 5679440
19:05:02 64350 8192000000 10274200352 10739458048 1360700256 14.244 98 10 18 0 1369811392 7218048 1893088
19:07:15 64102 8192000000 10289388176 10745524224 1360469184 14.242 98 18 36 0 1376838400 12192624 4176592
19:09:23 31047 8192000000 8920595504 9077493760 85419808 1.031 7 1 2 0 85992176 530016 42352

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-04-2024 19:11:09 to 14-04-2024 19:11:23.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-04-2024 19:11:24 to 14-04-2024 19:11:26.

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          173953
MON$OLDEST_ACTIVE               173954
MON$OLDEST_SNAPSHOT             173954
MON$NEXT_TRANSACTION            173954
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                       1934496
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Apr 14 19:11:27 2024 
 
Database header page information: 
    Flags            0 
    Generation        90980 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    173953 
    Oldest active        173954 
    Oldest snapshot        173954 
    Next transaction    173955 
    Sequence number        0 
    Next attachment ID    709 
    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.30, total records: 7730878 
    Average version length: 48.16, total versions: 95081, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87584 
    Data pages: 87584, average fill: 71% 
    Primary pages: 87584, secondary pages: 0, swept pages: 19592 
    Empty pages: 5, full pages: 64866 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 365 
    40 - 59% = 5122 
    60 - 79% = 82025 
    80 - 99% = 39 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23256, nodes: 7730878 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1677913, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 311 
        20 - 39% = 1900 
        40 - 59% = 4105 
        60 - 79% = 2374 
        80 - 99% = 14566 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13513, nodes: 7730878 
    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: 1501752, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1634 
        40 - 59% = 1998 
        60 - 79% = 1137 
        80 - 99% = 8744 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8316, nodes: 7730878 
    Average node length: 6.61, total dup: 5786372, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1494860, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 997 
        40 - 59% = 1337 
        60 - 79% = 942 
        80 - 99% = 4924 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.16, total records: 2234255 
    Average version length: 34.69, total versions: 98599, max versions: 3 
    Average fragment length: 6.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28928 
    Data pages: 28928, average fill: 72% 
    Primary pages: 28919, secondary pages: 9, swept pages: 10737 
    Empty pages: 13, full pages: 19551 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 266 
    40 - 59% = 2999 
    60 - 79% = 24867 
    80 - 99% = 732 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4552, nodes: 2234255 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677202, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 926 
        40 - 59% = 846 
        60 - 79% = 751 
        80 - 99% = 2028 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2517, nodes: 2236970 
    Average node length: 4.97, total dup: 2236071, max dup: 19188 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1234200, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 277 
        40 - 59% = 1567 
        60 - 79% = 478 
        80 - 99% = 193 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2029, nodes: 2234255 
    Average node length: 4.97, total dup: 2234205, max dup: 130106 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1065183, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 158 
        40 - 59% = 949 
        60 - 79% = 102 
        80 - 99% = 817 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4320, nodes: 2234255 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 677202, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 592 
        40 - 59% = 571 
        60 - 79% = 870 
        80 - 99% = 2185 
 
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.33, total records: 400 
    Average version length: 23.31, total versions: 227909, max versions: 590 
    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: 1280 
    Data pages: 1280, average fill: 89% 
    Primary pages: 9, secondary pages: 1271, swept pages: 0 
    Empty pages: 2, full pages: 1277 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1276 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 6.27, total records: 111828 
    Average version length: 68.29, total versions: 101568, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 14.04 
    Pointer pages: 7, data page slots: 2064 
    Data pages: 1728, average fill: 80% 
    Primary pages: 1727, secondary pages: 1, swept pages: 0 
    Empty pages: 145, full pages: 1463 
    Fill distribution: 
     0 - 19% = 168 
    20 - 39% = 19 
    40 - 59% = 42 
    60 - 79% = 95 
    80 - 99% = 1404 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1697474, depth: 3, leaf buckets: 266, nodes: 111828 
    Average node length: 13.17, total dup: 7954, max dup: 2 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.33, average data length: 7.67 
    Clustering factor: 81095, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 110 
        60 - 79% = 72 
        80 - 99% = 83 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 17662, max versions: 895 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 8 
    80 - 99% = 55 
 
    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: 2.04, total records: 1848 
    Average version length: 43.39, total versions: 1763, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 28.37 
    Pointer pages: 1, data page slots: 48 
    Data pages: 27, average fill: 65% 
    Primary pages: 26, secondary pages: 1, swept pages: 2 
    Empty pages: 6, full pages: 18 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 16 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91875, depth: 2, leaf buckets: 5, nodes: 1848 
    Average node length: 4.38, total dup: 1750, max dup: 174 
    Average key length: 2.59, compression ratio: 7.33 
    Average prefix length: 18.46, average data length: 0.54 
    Clustering factor: 929, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.22, total records: 815810 
    Average version length: 25.46, total versions: 64478, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 71% 
    Primary pages: 8006, secondary pages: 10, swept pages: 1374 
    Empty pages: 11, full pages: 7359 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 59 
    40 - 59% = 143 
    60 - 79% = 7553 
    80 - 99% = 231 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 888, nodes: 815810 
    Average node length: 4.87, total dup: 815761, max dup: 150082 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90430, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 120 
        40 - 59% = 481 
        60 - 79% = 223 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 921, nodes: 815810 
    Average node length: 5.88, total dup: 726401, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163896, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 80 
        40 - 59% = 407 
        60 - 79% = 115 
        80 - 99% = 318 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 970, nodes: 815810 
    Average node length: 5.88, total dup: 726401, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165807, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 172 
        40 - 59% = 381 
        60 - 79% = 111 
        80 - 99% = 305 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1153, nodes: 815810 
    Average node length: 5.96, total dup: 726401, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158739, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 243 
        40 - 59% = 605 
        60 - 79% = 219 
        80 - 99% = 83 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5430 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.52, total fragments: 56, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 70, secondary pages: 18, swept pages: 49 
    Empty pages: 5, full pages: 67 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5430 
    Average node length: 5.53, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.36, average data length: 1.55 
    Clustering factor: 5079, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5430 
    Average node length: 11.15, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 145, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 79293 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 764 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 764 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31417, depth: 2, leaf buckets: 102, nodes: 79293 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3184, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.11, 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.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 134.59, total records: 187041 
    Average version length: 154.96, total versions: 20160, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.60 
    Pointer pages: 6, data page slots: 5288 
    Data pages: 4496, average fill: 87% 
    Primary pages: 4496, secondary pages: 0, swept pages: 11 
    Empty pages: 52, full pages: 4431 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4429 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 122.83, total records: 195695 
    Average version length: 154.73, total versions: 36480, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.81 
    Pointer pages: 6, data page slots: 5384 
    Data pages: 4736, average fill: 87% 
    Primary pages: 4736, secondary pages: 0, swept pages: 4 
    Empty pages: 69, full pages: 4645 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4645 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 143.59, total records: 176207 
    Average version length: 152.78, total versions: 8676, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.81 
    Pointer pages: 7, data page slots: 4680 
    Data pages: 4208, average fill: 87% 
    Primary pages: 4208, secondary pages: 0, swept pages: 4 
    Empty pages: 25, full pages: 4169 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4170 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.55, total records: 167479 
    Average version length: 151.26, total versions: 5717, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 6, data page slots: 4544 
    Data pages: 3976, average fill: 87% 
    Primary pages: 3976, secondary pages: 0, swept pages: 5 
    Empty pages: 13, full pages: 3959 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3958 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 141.12, total records: 158627 
    Average version length: 152.99, total versions: 10338, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 9, data page slots: 4232 
    Data pages: 3824, average fill: 86% 
    Primary pages: 3824, secondary pages: 0, swept pages: 4 
    Empty pages: 55, full pages: 3754 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3754 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 142.06, total records: 163339 
    Average version length: 153.03, total versions: 9448, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 6, data page slots: 5056 
    Data pages: 3976, average fill: 85% 
    Primary pages: 3976, secondary pages: 0, swept pages: 6 
    Empty pages: 88, full pages: 3848 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 13 
    40 - 59% = 14 
    60 - 79% = 9 
    80 - 99% = 3848 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.49, total records: 162799 
    Average version length: 147.22, total versions: 1709, 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: 8, data page slots: 4056 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3920, secondary pages: 0, swept pages: 8 
    Empty pages: 52, full pages: 3850 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 9 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3850 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 132.28, total records: 179942 
    Average version length: 154.23, total versions: 22257, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 7, data page slots: 4512 
    Data pages: 4304, average fill: 87% 
    Primary pages: 4304, secondary pages: 0, swept pages: 3 
    Empty pages: 23, full pages: 4267 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 4267 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 146.77, total records: 171829 
    Average version length: 151.07, total versions: 4997, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 5832 
    Data pages: 4128, average fill: 86% 
    Primary pages: 4128, secondary pages: 0, swept pages: 4 
    Empty pages: 47, full pages: 4067 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4066 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 143.20, total records: 187473 
    Average version length: 153.17, total versions: 10044, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 6, data page slots: 7392 
    Data pages: 4560, average fill: 85% 
    Primary pages: 4560, secondary pages: 0, swept pages: 3 
    Empty pages: 93, full pages: 4439 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4439 
 
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.51, total records: 2099946 
    Average version length: 52.84, total versions: 48854, 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: 25680 
    Data pages: 25680, average fill: 70% 
    Primary pages: 25680, secondary pages: 0, swept pages: 10861 
    Empty pages: 343, full pages: 20283 
    Fill distribution: 
     0 - 19% = 615 
    20 - 39% = 469 
    40 - 59% = 1306 
    60 - 79% = 22873 
    80 - 99% = 417 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2586, nodes: 2099946 
    Average node length: 5.44, total dup: 1959484, max dup: 2077 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181303, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 292 
        40 - 59% = 1720 
        60 - 79% = 270 
        80 - 99% = 300 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2759, nodes: 2099946 
    Average node length: 5.69, total dup: 1884655, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374976, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 2420 
        60 - 79% = 308 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2160, nodes: 2099946 
    Average node length: 4.96, total dup: 2099846, max dup: 28080 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179345, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 214 
        40 - 59% = 1167 
        60 - 79% = 386 
        80 - 99% = 392 
 
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: 39.06, total records: 139837 
    Average version length: 69.18, total versions: 60926, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.23 
    Pointer pages: 3, data page slots: 4128 
    Data pages: 2864, average fill: 56% 
    Primary pages: 2864, secondary pages: 0, swept pages: 477 
    Empty pages: 668, full pages: 1870 
    Fill distribution: 
     0 - 19% = 856 
    20 - 39% = 66 
    40 - 59% = 40 
    60 - 79% = 566 
    80 - 99% = 1336 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101872, depth: 3, leaf buckets: 213, nodes: 139837 
    Average node length: 6.39, total dup: 121756, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 23702, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 45 
        40 - 59% = 107 
        60 - 79% = 52 
        80 - 99% = 9 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.88, total records: 7260509 
    Average version length: 68.76, total versions: 429412, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 65, data page slots: 105632 
    Data pages: 105632, average fill: 74% 
    Primary pages: 105632, secondary pages: 0, swept pages: 28182 
    Empty pages: 24, full pages: 81935 
    Fill distribution: 
     0 - 19% = 279 
    20 - 39% = 1591 
    40 - 59% = 8240 
    60 - 79% = 88354 
    80 - 99% = 7168 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10854, nodes: 7260509 
    Average node length: 6.51, total dup: 6279788, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1600212, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1704 
        40 - 59% = 5620 
        60 - 79% = 2959 
        80 - 99% = 563 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8741, nodes: 7260509 
    Average node length: 5.39, total dup: 6974990, max dup: 157 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1399140, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1140 
        40 - 59% = 4857 
        60 - 79% = 1788 
        80 - 99% = 944 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8784, nodes: 7260509 
    Average node length: 5.39, total dup: 6974990, max dup: 157 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1401696, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1220 
        40 - 59% = 4826 
        60 - 79% = 1781 
        80 - 99% = 946 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.98, total records: 12278802 
    Average version length: 68.71, total versions: 350862, 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: 106, data page slots: 171416 
    Data pages: 171416, average fill: 76% 
    Primary pages: 171416, secondary pages: 0, swept pages: 75567 
    Empty pages: 13, full pages: 157740 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 852 
    40 - 59% = 4505 
    60 - 79% = 159549 
    80 - 99% = 6398 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18447, nodes: 12278802 
    Average node length: 6.59, total dup: 10700565, max dup: 68 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2397476, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2318 
        40 - 59% = 10234 
        60 - 79% = 4876 
        80 - 99% = 993 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.64, total records: 1632521 
    Average version length: 69.10, total versions: 649703, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 31, data page slots: 49232 
    Data pages: 28816, average fill: 65% 
    Primary pages: 28815, secondary pages: 1, swept pages: 6764 
    Empty pages: 2841, full pages: 19820 
    Fill distribution: 
     0 - 19% = 4671 
    20 - 39% = 1894 
    40 - 59% = 1407 
    60 - 79% = 10241 
    80 - 99% = 10603 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2158, nodes: 1632521 
    Average node length: 5.51, total dup: 1566501, max dup: 89 
    Average key length: 2.56, compression ratio: 16.42 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 108760, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 510 
        40 - 59% = 1043 
        60 - 79% = 446 
        80 - 99% = 151 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.75, total records: 1059408 
    Average version length: 69.14, total versions: 464526, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.25 
    Pointer pages: 21, data page slots: 34072 
    Data pages: 30208, average fill: 41% 
    Primary pages: 30208, secondary pages: 0, swept pages: 8749 
    Empty pages: 7564, full pages: 12033 
    Fill distribution: 
     0 - 19% = 13543 
    20 - 39% = 2840 
    40 - 59% = 1211 
    60 - 79% = 3783 
    80 - 99% = 8831 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1482, nodes: 1059408 
    Average node length: 5.76, total dup: 991290, max dup: 103 
    Average key length: 2.83, compression ratio: 14.82 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 141273, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 383 
        40 - 59% = 671 
        60 - 79% = 342 
        80 - 99% = 86 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.46, total records: 9074452 
    Average version length: 68.97, total versions: 450891, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 91, data page slots: 148360 
    Data pages: 148288, average fill: 66% 
    Primary pages: 148288, secondary pages: 0, swept pages: 64331 
    Empty pages: 861, full pages: 74250 
    Fill distribution: 
     0 - 19% = 2512 
    20 - 39% = 10349 
    40 - 59% = 32358 
    60 - 79% = 95630 
    80 - 99% = 7439 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13460, nodes: 9074452 
    Average node length: 6.71, total dup: 7526490, max dup: 19 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1885895, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1509 
        40 - 59% = 6812 
        60 - 79% = 4373 
        80 - 99% = 765 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21133580 
    Average version length: 82.85, total versions: 13766, 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: 318616 
    Data pages: 318616, average fill: 81% 
    Primary pages: 318616, secondary pages: 0, swept pages: 12970 
    Empty pages: 55, full pages: 317580 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 60 
    40 - 59% = 137 
    60 - 79% = 27764 
    80 - 99% = 290578 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19356, nodes: 21133580 
    Average node length: 5.72, total dup: 20653118, max dup: 142 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276419, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8110 
        60 - 79% = 562 
        80 - 99% = 10680 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17158, nodes: 21133580 
    Average node length: 6.31, total dup: 18571181, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913530, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 4 
        40 - 59% = 782 
        60 - 79% = 259 
        80 - 99% = 16108 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21117, nodes: 21133580 
    Average node length: 6.35, total dup: 18491252, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571716, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8350 
        60 - 79% = 607 
        80 - 99% = 12157 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16088, nodes: 21133580 
    Average node length: 5.56, total dup: 21133480, max dup: 230975 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942502, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2896 
        60 - 79% = 385 
        80 - 99% = 12799 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.41, total records: 9542107 
    Average version length: 82.58, total versions: 461999, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 108, data page slots: 175456 
    Data pages: 175344, average fill: 67% 
    Primary pages: 175344, secondary pages: 0, swept pages: 83731 
    Empty pages: 1081, full pages: 88358 
    Fill distribution: 
     0 - 19% = 2937 
    20 - 39% = 10760 
    40 - 59% = 35800 
    60 - 79% = 67955 
    80 - 99% = 57892 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11404, nodes: 9542107 
    Average node length: 5.40, total dup: 9234935, max dup: 189 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2057931, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 163 
        40 - 59% = 8437 
        60 - 79% = 2745 
        80 - 99% = 57 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13535, nodes: 9542107 
    Average node length: 6.26, total dup: 7908980, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1396808, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 4056 
        40 - 59% = 4358 
        60 - 79% = 2646 
        80 - 99% = 2329 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12726, nodes: 9542107 
    Average node length: 6.01, total dup: 8280161, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2248116, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 184 
        40 - 59% = 9447 
        60 - 79% = 3050 
        80 - 99% = 45 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9935, nodes: 9542107 
    Average node length: 5.16, total dup: 9542007, max dup: 144433 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1455710, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1185 
        40 - 59% = 4954 
        60 - 79% = 1573 
        80 - 99% = 2174 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.49, total records: 11149952 
    Average version length: 82.54, total versions: 380158, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 120, data page slots: 194336 
    Data pages: 192760, average fill: 71% 
    Primary pages: 192760, secondary pages: 0, swept pages: 76629 
    Empty pages: 3979, full pages: 135743 
    Fill distribution: 
     0 - 19% = 6756 
    20 - 39% = 9520 
    40 - 59% = 21309 
    60 - 79% = 43489 
    80 - 99% = 111686 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13133, nodes: 11149952 
    Average node length: 5.31, total dup: 11040333, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2312897, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 234 
        40 - 59% = 9332 
        60 - 79% = 3409 
        80 - 99% = 157 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10448, nodes: 11149952 
    Average node length: 5.51, total dup: 10662696, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 692620, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 918 
        40 - 59% = 2662 
        60 - 79% = 1848 
        80 - 99% = 4870 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15024, nodes: 11149952 
    Average node length: 6.04, total dup: 9728381, max dup: 85 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2329227, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 316 
        40 - 59% = 10742 
        60 - 79% = 3793 
        80 - 99% = 169 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10658, nodes: 11149952 
    Average node length: 5.23, total dup: 11149852, max dup: 178046 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 682170, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 849 
        40 - 59% = 4732 
        60 - 79% = 1472 
        80 - 99% = 3505 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.47, total records: 9569081 
    Average version length: 82.92, total versions: 376987, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 110, data page slots: 179008 
    Data pages: 178920, average fill: 66% 
    Primary pages: 178920, secondary pages: 0, swept pages: 97910 
    Empty pages: 1039, full pages: 83842 
    Fill distribution: 
     0 - 19% = 3019 
    20 - 39% = 12230 
    40 - 59% = 39112 
    60 - 79% = 71659 
    80 - 99% = 52900 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11760, nodes: 9569081 
    Average node length: 5.21, total dup: 9539795, max dup: 2189 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1846139, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1611 
        40 - 59% = 7755 
        60 - 79% = 1810 
        80 - 99% = 545 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13589, nodes: 9569081 
    Average node length: 6.28, total dup: 7930412, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1344178, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 4067 
        40 - 59% = 4349 
        60 - 79% = 2638 
        80 - 99% = 2373 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12357, nodes: 9569081 
    Average node length: 5.47, total dup: 9136640, max dup: 103 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 1977215, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1594 
        40 - 59% = 8537 
        60 - 79% = 1679 
        80 - 99% = 525 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10112, nodes: 9569081 
    Average node length: 5.18, total dup: 9568981, max dup: 146214 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1453499, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1343 
        40 - 59% = 5046 
        60 - 79% = 1526 
        80 - 99% = 2146 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.39, total records: 575108 
    Average version length: 68.80, total versions: 6575, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8072 
    Data pages: 8072, average fill: 75% 
    Primary pages: 8072, secondary pages: 0, swept pages: 4167 
    Empty pages: 7, full pages: 6390 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 31 
    40 - 59% = 314 
    60 - 79% = 7624 
    80 - 99% = 94 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 35292, depth: 3, leaf buckets: 745, nodes: 575108 
    Average node length: 5.95, total dup: 489684, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99762, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 536 
        60 - 79% = 94 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 25798, depth: 3, leaf buckets: 763, nodes: 575108 
    Average node length: 6.15, total dup: 471725, max dup: 22 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99815, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 544 
        60 - 79% = 94 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 564, nodes: 575108 
    Average node length: 4.86, total dup: 575008, max dup: 9608 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88685, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 322 
        60 - 79% = 81 
        80 - 99% = 124 
 
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 Sun Apr 14 19:11:50 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7730878 95081 1 0.0000 0.0000
DOC_LIST 2234255 98599 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 227909 590 56900.0000 0.0000
INVNT_TURNOVER_LOG 111828 101568 1 0.0000 0.0000
MONEY_SALDO 49 17662 895 36000.0000 0.0000
MONEY_TURNOVER_LOG 1848 1763 1 0.0000 0.0000
PDISTR 815810 64478 4 0.0000 0.0000
PERF_SPLIT_0 187041 20160 1 0.0000 0.0000
PERF_SPLIT_1 195695 36480 1 0.0000 0.0000
PERF_SPLIT_2 176207 8676 1 0.0000 0.0000
PERF_SPLIT_3 167479 5717 1 0.0000 0.0000
PERF_SPLIT_4 158627 10338 1 0.0000 0.0000
PERF_SPLIT_5 163339 9448 1 0.0000 0.0000
PERF_SPLIT_6 162799 1709 1 0.0000 0.0000
PERF_SPLIT_7 179942 22257 1 0.0000 0.0000
PERF_SPLIT_8 171829 4997 1 0.0000 0.0000
PERF_SPLIT_9 187473 10044 1 0.0000 0.0000
PSTORNED 2099946 48854 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 139837 60926 1 0.0000 0.0000
XQD_1000_3300 7260509 429412 1 0.0000 0.0000
XQD_1200_2000 12278802 350862 1 0.0000 0.0000
XQD_2000_3300 1632521 649703 1 0.0000 0.0000
XQD_2100_3300 1059408 464526 1 0.0000 0.0000
XQD_3300_3400 9074452 450891 1 0.0000 0.0000
XQS_1000_1200 21133580 13766 1 0.0000 0.0000
XQS_1000_3300 9542107 461999 1 0.0000 0.0000
XQS_1200_2000 11149952 380158 1 0.0000 0.0000
XQS_2100_3300 9569081 376987 1 0.0000 0.0000
XQS_3300_3400 575108 6575 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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