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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-15 22:09:43
DTS_END                         2024-03-15 22:09:43.9280
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46902
TRN_ID                          173297
ATT_ID                          589
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: 9298.50 21248 929850
customer order: creation 175.16 308 17516
customer order: refuse 14.31 372 1431
order to supplier: creation 47.21 1227 4721
order to supplier: removal 3.57 93635 357
invoice (draft): creation 46.82 3080 4682
invoice (draft): removal 50.07 748 5007
invoice accept: apply 43.34 21093 4334
invoice accept: cancel 45.41 895 4541
customer reserve: creation 4103.55 205 410355
customer reserve: removal 4472.04 59 447204
realization accept: apply 85.13 198 8513
realization accept: cancel 81.44 111 8144
payment from customer: creation 59.78 134 5978
payment from customer: removal 6.04 69 604
payment to supplier: creation 48.94 158 4894
payment to supplier: removal 3.47 79 347
service: total inventory turnovers 4.80 1070 480
service: total monetary turnovers 6.49 29 649
service: aggregate perf. data 0.90 20394 90
service: refresh index statistics 0.03 281099 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-03-2024 22:11:19 to 15-03-2024 22:11:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2513
TEST_TIME 2 3331
TEST_TIME 3 3562
TEST_TIME 4 4129
TEST_TIME 5 3923
TEST_TIME 6 4159
TEST_TIME 7 3945
TEST_TIME 8 4562
TEST_TIME 9 5344
TEST_TIME 10 5488
TEST_TIME 11 5477
TEST_TIME 12 5744
TEST_TIME 13 5668
TEST_TIME 14 5799
TEST_TIME 15 6053
TEST_TIME 16 6095
TEST_TIME 17 6564
TEST_TIME 18 6869
TEST_TIME 19 7217
TEST_TIME 20 7271
TEST_TIME 21 7693
TEST_TIME 22 7952
TEST_TIME 23 7883
TEST_TIME 24 8157
TEST_TIME 25 8119
TEST_TIME 26 8479
TEST_TIME 27 8767
TEST_TIME 28 9255
TEST_TIME 29 9255
TEST_TIME 30 9163
TEST_TIME 31 8999
TEST_TIME 32 9066
TEST_TIME 33 9531
TEST_TIME 34 9385
TEST_TIME 35 9188
TEST_TIME 36 9109
TEST_TIME 37 9066
TEST_TIME 38 9014
TEST_TIME 39 8922
TEST_TIME 40 8930
TEST_TIME 41 9018
TEST_TIME 42 9147
TEST_TIME 43 9051
TEST_TIME 44 9061
TEST_TIME 45 9011
TEST_TIME 46 9058
TEST_TIME 47 9089
TEST_TIME 48 9217
TEST_TIME 49 9171
TEST_TIME 50 9185
TEST_TIME 51 9241
TEST_TIME 52 9371
TEST_TIME 53 9417
TEST_TIME 54 9396
TEST_TIME 55 9415
TEST_TIME 56 9499
TEST_TIME 57 9492
TEST_TIME 58 9454
TEST_TIME 59 9470
TEST_TIME 60 9338
TEST_TIME 61 9289
TEST_TIME 62 9371
TEST_TIME 63 9290
TEST_TIME 64 9302
TEST_TIME 65 9258
TEST_TIME 66 9196
TEST_TIME 67 9219
TEST_TIME 68 9170
TEST_TIME 69 9150
TEST_TIME 70 9119
TEST_TIME 71 9082
TEST_TIME 72 9110
TEST_TIME 73 9164
TEST_TIME 74 9255
TEST_TIME 75 9301
TEST_TIME 76 9339
TEST_TIME 77 9332
TEST_TIME 78 9338
TEST_TIME 79 9378
TEST_TIME 80 9409
TEST_TIME 81 9437
TEST_TIME 82 9444
TEST_TIME 83 9443
TEST_TIME 84 9573
TEST_TIME 85 9472
TEST_TIME 86 9486
TEST_TIME 87 9519
TEST_TIME 88 9462
TEST_TIME 89 9447
TEST_TIME 90 9435
TEST_TIME 91 9387
TEST_TIME 92 9398
TEST_TIME 93 9402
TEST_TIME 94 9329
TEST_TIME 95 9330
TEST_TIME 96 9326
TEST_TIME 97 9371
TEST_TIME 98 9339
TEST_TIME 99 9330
TEST_TIME 100 9307

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-03-2024 22:11:22 to 15-03-2024 22:11:25.

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 1306557 1306557 0 0.00 0 35093 7 0 0
doc_list_biud 1306556 1306556 0 0.00 0 39524 26 0 0
sp_add_invoice_to_stock 4394 4334 60 1.36 42 195191 21094 0 60
sp_cancel_adding_invoice 4541 4541 0 0.00 3 58093 895 0 0
sp_cancel_client_order 1431 1431 0 0.00 4 9354 373 0 0
sp_cancel_customer_reserve 447204 447204 0 0.00 0 24298 59 0 0
sp_cancel_pay_from_customer 604 604 0 0.00 3 2584 70 0 0
sp_cancel_pay_to_supplier 347 347 0 0.00 3 3903 80 0 0
sp_cancel_supplier_invoice 5017 5007 10 0.19 2 39541 749 0 10
sp_cancel_supplier_order 357 357 0 0.00 9 1154965 93635 0 0
sp_cancel_write_off 8144 8144 0 0.00 1 15432 112 0 0
sp_client_order 17516 17516 0 0.00 3 48249 309 0 0
sp_customer_reserve 410355 410355 0 0.00 0 126595 206 0 0
sp_fill_shopping_cart 26918 26918 0 0.00 1 11728 33 0 0
sp_fill_shopping_cart_clo_res 410347 410347 0 0.00 0 17518 14 0 0
sp_get_clo_for_invoice 4325 4325 0 0.00 0 15048 251 0 0
sp_kill_cost_storno 13636 13636 0 0.00 0 13000 60 0 0
sp_kill_qstorno_ret_qs2qd 907916 907916 0 0.00 0 39514 32 0 0
sp_kill_qty_storno 479522 479522 0 0.00 0 39521 69 0 0
sp_lock_selected_doc 17701 17701 0 0.00 0 10798 4 0 0
sp_make_cost_storno 23710 23710 0 0.00 0 35077 63 0 0
sp_multiply_rows_for_pdistr 23710 23710 0 0.00 0 13424 34 0 0
sp_multiply_rows_for_qdistr 17516 17516 0 0.00 0 13983 132 0 0
sp_pay_from_customer 5978 5978 0 0.00 4 14583 134 0 0
sp_pay_to_supplier 4894 4894 0 0.00 5 35185 158 0 0
sp_payment_common 10872 10872 0 0.00 1 12414 40 0 0
sp_qd_handle_on_cancel_clo 1431 1431 0 0.00 0 9308 347 0 0
sp_qd_handle_on_invoice_upd_sts 8866 8866 0 0.00 0 18740 346 0 0
sp_qd_handle_on_reserve_upd_sts 8513 8513 0 0.00 0 22290 72 0 0
sp_reserve_write_off 8513 8513 0 0.00 6 22305 198 0 0
sp_supplier_invoice 4682 4682 0 0.00 5 83019 3080 0 0
sp_supplier_order 4721 4721 0 0.00 5 43206 1228 0 0
srv_aggregate_perf_data 90 90 0 0.00 1752 506776 20394 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1105 123961 40513 0 0
srv_find_qd_qs_mism 887129 887129 0 0.00 0 15591 7 0 0
srv_make_invnt_saldo 480 480 0 0.00 28 40653 1070 0 0
srv_make_money_saldo 649 649 0 0.00 1 1175 30 0 0
srv_recalc_idx_stat 3 3 0 0.00 193826 434966 281099 0 0
t$perf-abend:sp_add_invoice_to_stock 60 60 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4335 4335 0 0.00 0 11804 201 0 0
t$perf-norm:sp_cancel_adding_invoice 356 356 0 0.00 0 2718 104 0 0
t$perf-norm:sp_cancel_client_order 1431 1431 0 0.00 0 1019 12 0 0
t$perf-norm:sp_cancel_customer_reserve 593 593 0 0.00 0 2066 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 604 604 0 0.00 0 826 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 347 347 0 0.00 0 776 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 882 17 0 0
t$perf-norm:sp_cancel_supplier_order 357 357 0 0.00 0 24192 1714 0 0
t$perf-norm:sp_cancel_write_off 827 827 0 0.00 0 357 3 0 0
t$perf-norm:sp_client_order 17516 17516 0 0.00 0 17176 19 0 0
t$perf-norm:sp_customer_reserve 830 830 0 0.00 0 5272 10 0 0
t$perf-norm:sp_pay_from_customer 5978 5978 0 0.00 0 3788 9 0 0
t$perf-norm:sp_pay_to_supplier 4894 4894 0 0.00 0 4470 14 0 0
t$perf-norm:sp_reserve_write_off 8513 8513 0 0.00 0 4235 10 0 0
t$perf-norm:sp_supplier_invoice 4682 4682 0 0.00 0 6197 21 0 0
t$perf-norm:sp_supplier_order 4721 4721 0 0.00 0 6781 22 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 867 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 565 26 0 0
t$perf-norm:srv_make_invnt_saldo 480 480 0 0.00 0 3620 35 0 0
t$perf-norm:srv_make_money_saldo 649 649 0 0.00 0 396 14 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 8768 8648 120 1.36 0 8131 18 0 120
v_all_customers 32032 32032 0 0.00 0 60 1 0 0
v_all_suppliers 26484 26484 0 0.00 0 22 1 0 0
v_all_wares 35032 35032 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 712 712 0 0.00 0 122 6 0 0
v_cancel_client_order 2862 2862 0 0.00 0 3285 6 0 0
v_cancel_customer_prepayment 1208 1208 0 0.00 0 2575 6 0 0
v_cancel_customer_reserve 1186 1186 0 0.00 0 3372 9 0 0
v_cancel_payment_to_supplier 694 694 0 0.00 0 1335 4 0 0
v_cancel_supplier_invoice 718 698 20 2.78 0 2049 16 0 20
v_cancel_supplier_order 714 714 0 0.00 0 2556 10 0 0
v_cancel_write_off 1654 1654 0 0.00 0 1224 13 0 0
v_max_id_clo_ord 4721 4721 0 0.00 0 647 2 0 0
v_max_id_clo_res 830 830 0 0.00 0 3738 12 0 0
v_max_id_ord_sup 4681 4681 0 0.00 0 3898 5 0 0
v_max_non_paid_invoice 1054 1054 0 0.00 0 1779 6 0 0
v_max_non_paid_realizn 3046 3046 0 0.00 0 2774 5 0 0
v_min_id_clo_ord 4721 4721 0 0.00 0 1902 6 0 0
v_min_id_clo_res 830 830 0 0.00 0 8285 27 0 0
v_min_id_ord_sup 4681 4681 0 0.00 0 5751 7 0 0
v_min_non_paid_invoice 4894 4894 0 0.00 0 8524 31 0 0
v_min_non_paid_realizn 5978 5978 0 0.00 0 7500 27 0 0
v_our_firm 8864 8864 0 0.00 0 25 1 0 0
v_reserve_write_off 17026 17026 0 0.00 0 6974 6 0 0
x_lock_depdocs_on_canc_invoice 9199 9199 0 0.00 0 21903 149 0 0
x_lock_depdocs_on_canc_sup_ord 357 357 0 0.00 0 19546 430 0 0
x_make_qstorno_1000_1200 4721 4721 0 0.00 2 43191 1141 0 0
x_make_qstorno_1200_2000 4682 4682 0 0.00 2 82999 2970 0 0
x_make_qstorno_2100_3300 410355 410355 0 0.00 0 126584 188 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 15-03-2024 22:11:26 to 15-03-2024 22:11:31.

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
20:09:47 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:48 33936 8192000000 9902422720 10214526976 985548096 10.738 100 91 182 0 1014363664 5443568 23372000
20:12:36 21367 8192000000 9963124336 10288279552 1041194992 11.276 100 91 182 1 1072433344 8273392 22964960
20:14:01 10183 8192000000 9994444768 10329395200 1077506272 11.624 100 84 168 0 1108198240 9743040 20948928
20:15:18 16540 8192000000 10058215552 10410930176 1142115024 12.235 100 82 165 0 1171625856 10856784 18654048
20:16:38 6668 8192000000 10101271744 10462711808 1185135296 12.638 100 86 171 0 1217362640 13073184 19154160
20:17:47 2891 8192000000 10129231200 10498727936 1218205888 12.945 100 79 156 0 1247951840 12360464 17385488
20:18:53 2248 8192000000 10160699760 10535149568 1245863296 13.200 100 90 179 2 1280264288 15063232 19337760
20:19:57 1859 8192000000 10181525392 10565165056 1270141072 13.423 100 72 144 0 1299671392 12502736 17027584
20:21:00 1948 8192000000 10209466608 10596515840 1295857248 13.658 100 89 179 1 1328542480 12805280 19879952
20:22:03 7165 8192000000 10210780560 10604163072 1306534160 13.755 100 63 127 0 1330766016 10300080 13931776
20:23:13 8505 8192000000 10218565792 10621169664 1315668304 13.837 100 66 129 4 1337027488 5218352 16140832
20:24:22 6290 8192000000 10204292608 10623848448 1322380384 13.898 100 31 63 0 1335941840 6639744 6921712
20:25:33 4165 8192000000 10220401888 10635202560 1331880160 13.984 100 40 79 0 1348962864 8399488 8683216
20:26:38 7867 8192000000 10216662112 10640478208 1334695936 14.010 100 24 47 1 1345917088 5574000 5647152
20:27:48 46664 8192000000 10247564640 10651758592 1335422592 14.016 100 45 92 2 1351863456 5338304 11102560
20:29:35 7521 8192000000 10212887792 10635350016 1307777856 13.766 98 27 55 0 1320923760 6974704 6171200
20:30:50 12266 8192000000 10248439856 10656530432 1340129824 14.059 100 60 120 0 1363311424 9734384 13447216
20:32:09 6182 8192000000 10250108176 10656923648 1330644768 13.973 98 57 113 0 1354561168 10789152 13127248
20:33:21 33051 8192000000 10270985872 10689085440 1352520864 14.170 99 47 94 0 1377009376 14002816 10485696
20:35:04 23462 8192000000 10237359440 10656350208 1325926016 13.930 99 37 74 0 1348964176 14379168 8658992
20:36:31 19836 8192000000 10265478400 10676482048 1348828336 14.137 100 44 84 0 1374820080 16513536 9478208
20:37:57 10351 8192000000 10257076432 10675990528 1344840720 14.101 100 43 86 1 1375259504 19529280 10889504
20:39:14 28207 8192000000 10256852288 10679394304 1340556064 14.062 99 44 88 1 1369478912 18457088 10465760
20:40:48 8838 8192000000 10252532448 10664128512 1323611216 13.909 98 49 95 1 1352555744 17703488 11241040
20:42:05 2041 8192000000 10276261712 10674577408 1338725312 14.046 99 76 149 4 1376400096 19513184 18161600
20:43:25 3844 8192000000 10295883216 10700242944 1360297248 14.240 100 65 128 0 1398501008 23397712 14806048
20:44:33 5032 8192000000 10274476960 10671661056 1325598144 13.927 98 70 136 1 1370575248 28252080 16725024
20:45:45 1103 8192000000 10283396576 10671747072 1334611504 14.009 100 84 158 1 1382407936 28298304 19498128
20:46:51 3363 8192000000 10304877552 10703814656 1352776352 14.172 100 86 171 1 1409488208 36150560 20561296
20:48:01 7938 8192000000 10310592880 10713260032 1361300784 14.249 100 78 157 2 1414144080 34063504 18779792
20:49:14 2953 8192000000 10302975312 10705272832 1354991920 14.192 100 76 147 1 1408477760 34854592 18631248
20:50:22 1782 8192000000 10325604960 10730029056 1369644432 14.324 100 85 165 1 1427192192 36782448 20765312
20:51:27 20971 8192000000 10316193488 10743353344 1375646432 14.378 100 28 54 0 1423953456 40664288 7642736
20:53:00 16826 8192000000 10310473264 10744520704 1365035184 14.283 99 31 62 0 1414158736 40808304 8315248
20:54:37 20715 8192000000 10316509360 10747678720 1380670400 14.423 100 28 56 0 1424680640 36541248 7468992
20:56:00 18024 8192000000 10303208256 10746204160 1373541728 14.359 100 15 30 0 1412882464 35019504 4321232
20:57:23 29402 8192000000 10297848192 10725347328 1376421152 14.385 100 29 57 1 1393984688 10532144 7031392
20:58:59 28060 8192000000 10298670640 10730876928 1373251952 14.356 100 26 50 4 1390564384 11102720 6209712
21:00:28 17713 8192000000 10317923792 10753175552 1396094080 14.560 100 36 72 0 1423307968 18924512 8289376
21:02:02 72290 8192000000 10297502336 10760675328 1378818144 14.406 100 11 22 0 1408500944 26976400 2706400
21:04:18 95081 8192000000 10296916800 10740011008 1374665568 14.369 99 37 73 0 1391522608 7579568 9277472
21:06:55 123961 8192000000 10318623744 10764423168 1395036928 14.551 99 50 95 0 1417510240 12104304 10369008
21:10:01 34965 8192000000 10310017824 10762645504 1391755728 14.522 99 34 66 2 1418385360 17202224 9427408
21:11:48 30632 8192000000 10307966464 10760032256 1390927296 14.514 99 16 31 0 1404197840 10402272 2868272
21:13:23 91758 8192000000 10308199840 10760859648 1392118544 14.525 99 11 22 0 1408757328 14510496 2128288
21:16:02 85908 8192000000 10309012368 10779500544 1393730432 14.539 99 11 22 0 1411225024 14706416 2788176
21:18:28 43498 8192000000 10308820656 10758295552 1373750592 14.361 98 25 50 1 1390041904 10404192 5887120
21:20:22 69697 8192000000 10286587328 10749554688 1341082512 14.067 97 17 34 0 1357596576 13020800 3493264
21:22:39 35101 8192000000 10264139648 10698919936 1272497104 13.444 92 24 48 0 1286032896 8696848 4838944
21:24:14 69667 8192000000 10229294192 10680164352 1274027648 13.458 95 14 29 0 1293438992 16391328 3020016
21:26:35 37505 8192000000 10232680240 10662608896 1267546144 13.399 94 26 52 0 1283117616 10082864 5488608
21:28:13 72476 8192000000 10256706720 10696425472 1337279744 14.033 100 26 51 0 1357621024 14986112 5355168
21:31:11 80910 8192000000 10265356368 10723569664 1352915120 14.174 99 14 28 0 1372389680 15699968 3774592
21:33:37 55659 8192000000 10261133088 10714099712 1354559664 14.188 99 24 48 0 1371983760 11986640 5437456
21:35:33 64695 8192000000 10263899968 10713530368 1342508160 14.080 98 16 32 0 1357554560 11576000 3470400
21:38:56 44317 8192000000 10261646624 10705489920 1302283408 13.716 95 14 28 0 1312471568 7190432 2997728
21:40:43 51776 8192000000 10278251536 10722914304 1357249136 14.213 99 27 54 0 1379694272 16278016 6167120
21:42:39 32217 8192000000 10279640528 10725011456 1361583424 14.252 99 18 36 0 1377257952 11943600 3730928
21:44:15 65268 8192000000 10291718800 10744500224 1369816896 14.325 99 23 46 0 1386330160 11819584 4693680
21:46:20 46084 8192000000 10303273904 10748252160 1386281424 14.473 100 37 73 1 1404201424 10213008 7706992
21:48:09 62204 8192000000 10302256016 10743390208 1371422656 14.340 98 30 60 0 1388585936 10830944 6332336
21:50:16 37149 8192000000 10308604528 10762137600 1388456736 14.492 99 16 32 0 1400408048 8702336 3248976
21:52:01 41551 8192000000 10325190656 10786017280 1387351904 14.482 98 16 32 0 1411475440 20430448 3693088
21:53:45 55183 8192000000 10322738400 10802147328 1403542656 14.627 100 9 18 0 1434005104 28448928 2013520
21:56:13 83661 8192000000 10303604304 10770395136 1392868080 14.531 99 27 52 2 1417333056 18577136 5887840
21:58:38 37772 8192000000 10286310080 10745049088 1385891440 14.469 99 22 42 0 1399284128 8260000 5132688
22:00:24 44029 8192000000 10284602400 10739945472 1365956672 14.291 98 10 20 0 1375669840 7081360 2631808
22:02:22 54505 8192000000 10276198656 10740924416 1375396208 14.375 100 15 30 1 1388588384 9641104 3551072
22:04:18 53608 8192000000 10281989824 10741813248 1343847856 14.092 97 17 34 0 1361433072 13695360 3889856
22:06:24 59619 8192000000 10278630592 10738204672 1348603712 14.135 98 10 20 0 1365375600 14342464 2429424
22:08:30 73416 8192000000 10298633728 10751205376 1366779152 14.298 98 19 38 1 1384293328 13642496 3871680

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 15-03-2024 22:11:33 to 15-03-2024 22:11:46.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-03-2024 22:11:47 to 15-03-2024 22:11:49.

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          170063
MON$OLDEST_ACTIVE               173476
MON$OLDEST_SNAPSHOT             173476
MON$NEXT_TRANSACTION            173476
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                       1901920
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Mar 15 22:11:50 2024 
 
Database header page information: 
    Flags            0 
    Generation        90274 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170063 
    Oldest active        173476 
    Oldest snapshot        173476 
    Next transaction    173477 
    Sequence number        0 
    Next attachment ID    706 
    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.32, total records: 7741535 
    Average version length: 48.16, total versions: 91923, 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: 86736 
    Data pages: 86736, average fill: 71% 
    Primary pages: 86736, secondary pages: 0, swept pages: 16405 
    Empty pages: 6, full pages: 65300 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 257 
    40 - 59% = 2265 
    60 - 79% = 84167 
    80 - 99% = 15 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23288, nodes: 7741535 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1726911, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 284 
        20 - 39% = 1914 
        40 - 59% = 4153 
        60 - 79% = 2402 
        80 - 99% = 14535 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13525, nodes: 7741535 
    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: 1549531, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1637 
        40 - 59% = 1997 
        60 - 79% = 1158 
        80 - 99% = 8733 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8356, nodes: 7741535 
    Average node length: 6.62, total dup: 5790618, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1542618, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 993 
        40 - 59% = 1363 
        60 - 79% = 985 
        80 - 99% = 4880 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.23, total records: 2241650 
    Average version length: 34.63, total versions: 94028, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28344 
    Data pages: 28344, average fill: 73% 
    Primary pages: 28337, secondary pages: 7, swept pages: 8837 
    Empty pages: 10, full pages: 20232 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 113 
    40 - 59% = 1467 
    60 - 79% = 26046 
    80 - 99% = 691 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4559, nodes: 2241650 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 696893, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 944 
        40 - 59% = 819 
        60 - 79% = 748 
        80 - 99% = 2048 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2523, nodes: 2244126 
    Average node length: 4.97, total dup: 2243227, max dup: 18318 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1252475, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 274 
        40 - 59% = 1538 
        60 - 79% = 517 
        80 - 99% = 190 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2018, nodes: 2241650 
    Average node length: 4.97, total dup: 2241600, max dup: 130334 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056986, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 72 
        40 - 59% = 1053 
        60 - 79% = 48 
        80 - 99% = 840 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4345, nodes: 2241650 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 696893, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 638 
        40 - 59% = 580 
        60 - 79% = 864 
        80 - 99% = 2177 
 
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.44, total records: 400 
    Average version length: 23.26, total versions: 233958, max versions: 609 
    Average fragment length: 2.00, total fragments: 46, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1320 
    Data pages: 1312, average fill: 89% 
    Primary pages: 10, secondary pages: 1302, swept pages: 0 
    Empty pages: 3, full pages: 1308 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1306 
 
    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: 5.24, total records: 125126 
    Average version length: 68.30, total versions: 115535, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 16.80 
    Pointer pages: 6, data page slots: 3048 
    Data pages: 2072, average fill: 75% 
    Primary pages: 2071, secondary pages: 1, swept pages: 0 
    Empty pages: 122, full pages: 1526 
    Fill distribution: 
     0 - 19% = 191 
    20 - 39% = 71 
    40 - 59% = 141 
    60 - 79% = 323 
    80 - 99% = 1346 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694348, depth: 3, leaf buckets: 379, nodes: 125126 
    Average node length: 13.10, total dup: 9125, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.29, average data length: 7.71 
    Clustering factor: 91152, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 282 
        60 - 79% = 65 
        80 - 99% = 15 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18034, max versions: 943 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 81% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 11 
    80 - 99% = 54 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.26, total records: 1919 
    Average version length: 43.70, total versions: 1778, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 17.82 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 62% 
    Primary pages: 28, secondary pages: 2, swept pages: 0 
    Empty pages: 2, full pages: 16 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91717, depth: 2, leaf buckets: 3, nodes: 1919 
    Average node length: 4.19, total dup: 1821, max dup: 233 
    Average key length: 2.54, compression ratio: 7.48 
    Average prefix length: 18.51, average data length: 0.49 
    Clustering factor: 973, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.14, 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: 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: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.99, total records: 810802 
    Average version length: 25.46, total versions: 72205, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 71% 
    Primary pages: 7986, secondary pages: 14, swept pages: 1280 
    Empty pages: 59, full pages: 7635 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 47 
    40 - 59% = 52 
    60 - 79% = 7480 
    80 - 99% = 299 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 880, nodes: 810802 
    Average node length: 4.87, total dup: 810753, max dup: 154224 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90695, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 105 
        40 - 59% = 517 
        60 - 79% = 198 
        80 - 99% = 60 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 926, nodes: 810802 
    Average node length: 5.88, total dup: 721698, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162936, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 73 
        40 - 59% = 398 
        60 - 79% = 159 
        80 - 99% = 293 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 985, nodes: 810802 
    Average node length: 5.88, total dup: 721698, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164924, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 194 
        40 - 59% = 381 
        60 - 79% = 116 
        80 - 99% = 293 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1125, nodes: 810802 
    Average node length: 5.96, total dup: 721698, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157727, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 234 
        40 - 59% = 592 
        60 - 79% = 187 
        80 - 99% = 111 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5411 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.57, total fragments: 74, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 76, secondary pages: 20, swept pages: 56 
    Empty pages: 13, full pages: 65 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5411 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.00 
    Average prefix length: 34.35, average data length: 1.55 
    Clustering factor: 5085, 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: 5411 
    Average node length: 11.12, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 146, 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: 79110 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 762 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 762 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32495, depth: 2, leaf buckets: 101, nodes: 79110 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3058, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        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.21, 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.21 
    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: 147.59, total records: 168384 
    Average version length: 152.78, total versions: 4066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 5480 
    Data pages: 4072, average fill: 85% 
    Primary pages: 4072, secondary pages: 0, swept pages: 1 
    Empty pages: 64, full pages: 3982 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 11 
    80 - 99% = 3982 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.85, total records: 161469 
    Average version length: 153.87, total versions: 5654, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 5576 
    Data pages: 3912, average fill: 85% 
    Primary pages: 3912, secondary pages: 0, swept pages: 2 
    Empty pages: 66, full pages: 3816 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 13 
    80 - 99% = 3816 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 145.81, total records: 169920 
    Average version length: 152.98, total versions: 5858, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 5384 
    Data pages: 4096, average fill: 86% 
    Primary pages: 4095, secondary pages: 1, swept pages: 8 
    Empty pages: 58, full pages: 4017 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 11 
    80 - 99% = 4015 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.73, total records: 168115 
    Average version length: 152.63, total versions: 2707, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 5632 
    Data pages: 4096, average fill: 85% 
    Primary pages: 4096, secondary pages: 0, swept pages: 2 
    Empty pages: 95, full pages: 3977 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3977 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 146.49, total records: 155602 
    Average version length: 154.42, total versions: 4858, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 4464 
    Data pages: 3744, average fill: 86% 
    Primary pages: 3744, secondary pages: 0, swept pages: 2 
    Empty pages: 45, full pages: 3686 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3686 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.67, total records: 155116 
    Average version length: 152.13, total versions: 3261, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 6, data page slots: 4936 
    Data pages: 3728, average fill: 86% 
    Primary pages: 3727, secondary pages: 1, swept pages: 2 
    Empty pages: 51, full pages: 3668 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3667 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.44, total records: 166549 
    Average version length: 152.04, total versions: 1865, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 4216 
    Data pages: 3992, average fill: 86% 
    Primary pages: 3992, secondary pages: 0, swept pages: 2 
    Empty pages: 38, full pages: 3941 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 3941 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 134.44, total records: 165842 
    Average version length: 155.28, total versions: 17980, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.62 
    Pointer pages: 6, data page slots: 4712 
    Data pages: 3984, average fill: 87% 
    Primary pages: 3984, secondary pages: 0, swept pages: 3 
    Empty pages: 38, full pages: 3923 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 14 
    80 - 99% = 3922 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.43, total records: 161339 
    Average version length: 151.80, total versions: 2722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4504 
    Data pages: 3888, average fill: 85% 
    Primary pages: 3888, secondary pages: 0, swept pages: 3 
    Empty pages: 56, full pages: 3813 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 3813 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.23, total records: 158023 
    Average version length: 151.84, total versions: 2776, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 6, data page slots: 4072 
    Data pages: 3800, average fill: 86% 
    Primary pages: 3800, secondary pages: 0, swept pages: 2 
    Empty pages: 48, full pages: 3731 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 8 
    60 - 79% = 4 
    80 - 99% = 3731 
 
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.65, total records: 2103243 
    Average version length: 52.99, total versions: 43827, 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: 25496 
    Data pages: 25488, average fill: 71% 
    Primary pages: 25488, secondary pages: 0, swept pages: 11262 
    Empty pages: 219, full pages: 20126 
    Fill distribution: 
     0 - 19% = 434 
    20 - 39% = 448 
    40 - 59% = 1125 
    60 - 79% = 23099 
    80 - 99% = 382 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2596, nodes: 2103243 
    Average node length: 5.44, total dup: 1963119, max dup: 1745 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181531, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 312 
        40 - 59% = 1696 
        60 - 79% = 299 
        80 - 99% = 287 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2758, nodes: 2103243 
    Average node length: 5.69, total dup: 1887774, max dup: 63 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375319, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 2400 
        60 - 79% = 328 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2119, nodes: 2103243 
    Average node length: 4.96, total dup: 2103143, max dup: 27675 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178971, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 219 
        40 - 59% = 1059 
        60 - 79% = 393 
        80 - 99% = 444 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.47, total records: 137435 
    Average version length: 69.17, total versions: 65003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.45 
    Pointer pages: 3, data page slots: 4064 
    Data pages: 2968, average fill: 54% 
    Primary pages: 2968, secondary pages: 0, swept pages: 550 
    Empty pages: 687, full pages: 1773 
    Fill distribution: 
     0 - 19% = 900 
    20 - 39% = 156 
    40 - 59% = 84 
    60 - 79% = 604 
    80 - 99% = 1224 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103329, depth: 3, leaf buckets: 208, nodes: 137435 
    Average node length: 6.41, total dup: 119467, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 23989, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 105 
        60 - 79% = 50 
        80 - 99% = 16 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.10, total records: 7197085 
    Average version length: 68.72, total versions: 402312, 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: 64, data page slots: 103000 
    Data pages: 103000, average fill: 75% 
    Primary pages: 103000, secondary pages: 0, swept pages: 24357 
    Empty pages: 18, full pages: 85564 
    Fill distribution: 
     0 - 19% = 153 
    20 - 39% = 1161 
    40 - 59% = 5522 
    60 - 79% = 88750 
    80 - 99% = 7414 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10729, nodes: 7197085 
    Average node length: 6.51, total dup: 6225767, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1582699, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1532 
        40 - 59% = 5702 
        60 - 79% = 2979 
        80 - 99% = 511 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8648, nodes: 7197085 
    Average node length: 5.39, total dup: 6913528, max dup: 189 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1372980, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1138 
        40 - 59% = 4836 
        60 - 79% = 1642 
        80 - 99% = 1021 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8708, nodes: 7197085 
    Average node length: 5.39, total dup: 6913528, max dup: 189 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1375583, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1236 
        40 - 59% = 4826 
        60 - 79% = 1616 
        80 - 99% = 1028 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.24, total records: 12170682 
    Average version length: 68.72, total versions: 302157, 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: 104, data page slots: 169248 
    Data pages: 169248, average fill: 76% 
    Primary pages: 169248, secondary pages: 0, swept pages: 78863 
    Empty pages: 10, full pages: 157814 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 548 
    40 - 59% = 3549 
    60 - 79% = 159418 
    80 - 99% = 5679 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18396, nodes: 12170682 
    Average node length: 6.58, total dup: 10607736, max dup: 67 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2387898, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2125 
        40 - 59% = 10905 
        60 - 79% = 4469 
        80 - 99% = 874 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.37, total records: 1555922 
    Average version length: 69.13, total versions: 602616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.97 
    Pointer pages: 26, data page slots: 41944 
    Data pages: 26744, average fill: 67% 
    Primary pages: 26744, secondary pages: 0, swept pages: 6126 
    Empty pages: 2458, full pages: 18902 
    Fill distribution: 
     0 - 19% = 3722 
    20 - 39% = 1684 
    40 - 59% = 1420 
    60 - 79% = 10502 
    80 - 99% = 9416 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2110, nodes: 1555922 
    Average node length: 5.52, total dup: 1493269, max dup: 99 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 101471, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 552 
        40 - 59% = 1005 
        60 - 79% = 444 
        80 - 99% = 103 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.86, total records: 1150639 
    Average version length: 69.13, total versions: 486180, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.16 
    Pointer pages: 20, data page slots: 32304 
    Data pages: 26024, average fill: 51% 
    Primary pages: 26024, secondary pages: 0, swept pages: 5243 
    Empty pages: 4612, full pages: 11796 
    Fill distribution: 
     0 - 19% = 7061 
    20 - 39% = 2553 
    40 - 59% = 2651 
    60 - 79% = 5909 
    80 - 99% = 7850 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1639, nodes: 1150639 
    Average node length: 5.83, total dup: 1070205, max dup: 108 
    Average key length: 2.90, compression ratio: 14.49 
    Average prefix length: 41.17, average data length: 0.83 
    Clustering factor: 160767, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 363 
        40 - 59% = 847 
        60 - 79% = 378 
        80 - 99% = 50 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.00, total records: 9184177 
    Average version length: 68.98, total versions: 519332, 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: 89, data page slots: 143744 
    Data pages: 143728, average fill: 69% 
    Primary pages: 143728, secondary pages: 0, swept pages: 48390 
    Empty pages: 320, full pages: 76084 
    Fill distribution: 
     0 - 19% = 1158 
    20 - 39% = 5981 
    40 - 59% = 23287 
    60 - 79% = 105472 
    80 - 99% = 7830 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13483, nodes: 9184177 
    Average node length: 6.68, total dup: 7617959, max dup: 19 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1996393, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1251 
        40 - 59% = 6920 
        60 - 79% = 4728 
        80 - 99% = 583 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21155284 
    Average version length: 82.78, total versions: 12016, 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: 318840 
    Data pages: 318840, average fill: 81% 
    Primary pages: 318840, secondary pages: 0, swept pages: 12221 
    Empty pages: 31, full pages: 318110 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 35 
    40 - 59% = 114 
    60 - 79% = 27251 
    80 - 99% = 291392 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19436, nodes: 21155284 
    Average node length: 5.72, total dup: 20674321, max dup: 135 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279524, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8262 
        60 - 79% = 519 
        80 - 99% = 10649 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17170, nodes: 21155284 
    Average node length: 6.31, total dup: 18590521, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914131, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 774 
        60 - 79% = 274 
        80 - 99% = 16117 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21214, nodes: 21155284 
    Average node length: 6.35, total dup: 18510502, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575077, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 4 
        40 - 59% = 8519 
        60 - 79% = 588 
        80 - 99% = 12096 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16057, nodes: 21155284 
    Average node length: 5.56, total dup: 21155184, max dup: 229746 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943062, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2809 
        60 - 79% = 388 
        80 - 99% = 12851 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.12, total records: 9619635 
    Average version length: 82.63, total versions: 501200, 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: 105, data page slots: 170688 
    Data pages: 170632, average fill: 70% 
    Primary pages: 170632, secondary pages: 0, swept pages: 67350 
    Empty pages: 405, full pages: 94300 
    Fill distribution: 
     0 - 19% = 1586 
    20 - 39% = 8098 
    40 - 59% = 27277 
    60 - 79% = 74777 
    80 - 99% = 58894 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11360, nodes: 9619635 
    Average node length: 5.36, total dup: 9311741, max dup: 199 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2118312, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 103 
        40 - 59% = 8394 
        60 - 79% = 2789 
        80 - 99% = 72 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13534, nodes: 9619635 
    Average node length: 6.23, total dup: 7974480, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1468084, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 4095 
        40 - 59% = 4335 
        60 - 79% = 2600 
        80 - 99% = 2380 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12696, nodes: 9619635 
    Average node length: 5.98, total dup: 8347414, max dup: 59 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2309293, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 120 
        40 - 59% = 9429 
        60 - 79% = 3072 
        80 - 99% = 72 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10064, nodes: 9619635 
    Average node length: 5.13, total dup: 9619535, max dup: 148297 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1507912, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1283 
        40 - 59% = 4961 
        60 - 79% = 1675 
        80 - 99% = 2105 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.76, total records: 11194482 
    Average version length: 82.50, total versions: 345804, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 118, data page slots: 191488 
    Data pages: 189992, average fill: 72% 
    Primary pages: 189992, secondary pages: 0, swept pages: 72214 
    Empty pages: 3419, full pages: 139100 
    Fill distribution: 
     0 - 19% = 5698 
    20 - 39% = 7599 
    40 - 59% = 18585 
    60 - 79% = 43906 
    80 - 99% = 114204 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13117, nodes: 11194482 
    Average node length: 5.30, total dup: 11084827, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2329010, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 146 
        40 - 59% = 9408 
        60 - 79% = 3454 
        80 - 99% = 108 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10374, nodes: 11194482 
    Average node length: 5.49, total dup: 10705949, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 699645, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 855 
        40 - 59% = 2602 
        60 - 79% = 1775 
        80 - 99% = 4985 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14994, nodes: 11194482 
    Average node length: 6.02, total dup: 9765053, max dup: 72 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2345495, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 175 
        40 - 59% = 10970 
        60 - 79% = 3717 
        80 - 99% = 132 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10666, nodes: 11194482 
    Average node length: 5.22, total dup: 11194382, max dup: 180650 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 688517, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 884 
        40 - 59% = 4727 
        60 - 79% = 1448 
        80 - 99% = 3522 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.73, total records: 9700560 
    Average version length: 82.95, total versions: 469647, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 107, data page slots: 174608 
    Data pages: 174568, average fill: 69% 
    Primary pages: 174568, secondary pages: 0, swept pages: 74502 
    Empty pages: 472, full pages: 90325 
    Fill distribution: 
     0 - 19% = 1802 
    20 - 39% = 8484 
    40 - 59% = 30804 
    60 - 79% = 78660 
    80 - 99% = 54818 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11807, nodes: 9700560 
    Average node length: 5.18, total dup: 9671777, max dup: 1652 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1923662, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1579 
        40 - 59% = 7844 
        60 - 79% = 1804 
        80 - 99% = 556 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13673, nodes: 9700560 
    Average node length: 6.25, total dup: 8041393, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1425718, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 4091 
        40 - 59% = 4349 
        60 - 79% = 2554 
        80 - 99% = 2497 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12426, nodes: 9700560 
    Average node length: 5.43, total dup: 9265349, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2055844, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1498 
        40 - 59% = 8769 
        60 - 79% = 1578 
        80 - 99% = 556 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10203, nodes: 9700560 
    Average node length: 5.15, total dup: 9700460, max dup: 150021 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1521327, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1311 
        40 - 59% = 5091 
        60 - 79% = 1675 
        80 - 99% = 2085 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.32, total records: 573137 
    Average version length: 68.85, total versions: 7069, 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: 7992 
    Data pages: 7992, average fill: 75% 
    Primary pages: 7992, secondary pages: 0, swept pages: 4025 
    Empty pages: 1, full pages: 6421 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 16 
    40 - 59% = 202 
    60 - 79% = 7640 
    80 - 99% = 131 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 32775, depth: 3, leaf buckets: 734, nodes: 573137 
    Average node length: 5.95, total dup: 487774, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99756, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 522 
        60 - 79% = 93 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 24476, depth: 3, leaf buckets: 762, nodes: 573137 
    Average node length: 6.15, total dup: 469847, max dup: 29 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99809, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 539 
        60 - 79% = 99 
        80 - 99% = 90 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 567, nodes: 573137 
    Average node length: 4.86, total dup: 573037, max dup: 9817 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88558, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 335 
        60 - 79% = 84 
        80 - 99% = 120 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar 15 22:12:14 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7741535 91923 1 0.0000 0.0000
DOC_LIST 2241650 94028 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 233958 609 58400.0000 0.0000
INVNT_TURNOVER_LOG 125126 115535 1 0.0000 0.0000
MONEY_SALDO 49 18034 943 36800.0000 0.0000
MONEY_TURNOVER_LOG 1919 1778 1 0.0000 0.0000
PDISTR 810802 72205 4 0.0000 0.0000
PERF_SPLIT_0 168384 4066 1 0.0000 0.0000
PERF_SPLIT_1 161469 5654 1 0.0000 0.0000
PERF_SPLIT_2 169920 5858 1 0.0000 0.0000
PERF_SPLIT_3 168115 2707 1 0.0000 0.0000
PERF_SPLIT_4 155602 4858 1 0.0000 0.0000
PERF_SPLIT_5 155116 3261 1 0.0000 0.0000
PERF_SPLIT_6 166549 1865 1 0.0000 0.0000
PERF_SPLIT_7 165842 17980 1 0.0000 0.0000
PERF_SPLIT_8 161339 2722 1 0.0000 0.0000
PERF_SPLIT_9 158023 2776 1 0.0000 0.0000
PSTORNED 2103243 43827 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 137435 65003 1 0.0000 0.0000
XQD_1000_3300 7197085 402312 1 0.0000 0.0000
XQD_1200_2000 12170682 302157 1 0.0000 0.0000
XQD_2000_3300 1555922 602616 1 0.0000 0.0000
XQD_2100_3300 1150639 486180 1 0.0000 0.0000
XQD_3300_3400 9184177 519332 1 0.0000 0.0000
XQS_1000_1200 21155284 12016 1 0.0000 0.0000
XQS_1000_3300 9619635 501200 1 0.0000 0.0000
XQS_1200_2000 11194482 345804 1 0.0000 0.0000
XQS_2100_3300 9700560 469647 1 0.0000 0.0000
XQS_3300_3400 573137 7069 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 ---
:376: 
:377: mscs-test-161.budzdorov.ru    Fri Mar 15 22:09:52 2024
:378:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:379: 
:380: 
:381: mscs-test-161.budzdorov.ru    Fri Mar 15 22:09:56 2024
:382:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:383: 
:384: 
:385: mscs-test-161.budzdorov.ru    Fri Mar 15 22:09:57 2024
:386:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:387: 
--- end of diff output ---

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

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