Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.04.2024 04:08
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 15626044 kB
MemAvailable 30140912 kB
Buffers 20 kB
Cached 16039448 kB
SwapCached 2480 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-02 04:07:49
DTS_END                         2024-04-02 04:07:49.4110
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(68:17)
IP                              ::1/47174
TRN_ID                          173581
ATT_ID                          564
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: 9095.15 16888 909515
customer order: creation 183.17 391 18317
customer order: refuse 15.30 384 1530
order to supplier: creation 47.26 1325 4726
order to supplier: removal 3.49 86261 349
invoice (draft): creation 50.02 2971 5002
invoice (draft): removal 48.10 746 4810
invoice accept: apply 43.60 21860 4360
invoice accept: cancel 43.17 829 4317
customer reserve: creation 4139.59 213 413959
customer reserve: removal 4222.28 56 422228
realization accept: apply 87.37 165 8737
realization accept: cancel 78.22 128 7822
payment from customer: creation 61.01 101 6101
payment from customer: removal 5.68 89 568
payment to supplier: creation 51.58 128 5158
payment to supplier: removal 3.61 127 361
service: total inventory turnovers 4.01 3858 401
service: total monetary turnovers 6.71 531 671
service: aggregate perf. data 0.95 16688 95
service: refresh index statistics 0.03 200913 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-04-2024 04:09:19 to 02-04-2024 04:09:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3235
TEST_TIME 2 4247
TEST_TIME 3 3440
TEST_TIME 4 4288
TEST_TIME 5 4688
TEST_TIME 6 5192
TEST_TIME 7 5786
TEST_TIME 8 6071
TEST_TIME 9 6616
TEST_TIME 10 6823
TEST_TIME 11 6907
TEST_TIME 12 7449
TEST_TIME 13 7309
TEST_TIME 14 7175
TEST_TIME 15 7569
TEST_TIME 16 7704
TEST_TIME 17 7507
TEST_TIME 18 7749
TEST_TIME 19 7966
TEST_TIME 20 7986
TEST_TIME 21 7913
TEST_TIME 22 8518
TEST_TIME 23 9065
TEST_TIME 24 9487
TEST_TIME 25 9634
TEST_TIME 26 10184
TEST_TIME 27 10062
TEST_TIME 28 9814
TEST_TIME 29 9797
TEST_TIME 30 9715
TEST_TIME 31 9508
TEST_TIME 32 9536
TEST_TIME 33 9378
TEST_TIME 34 9345
TEST_TIME 35 9361
TEST_TIME 36 9337
TEST_TIME 37 9407
TEST_TIME 38 9316
TEST_TIME 39 9351
TEST_TIME 40 9409
TEST_TIME 41 9414
TEST_TIME 42 9245
TEST_TIME 43 9282
TEST_TIME 44 9339
TEST_TIME 45 9343
TEST_TIME 46 9362
TEST_TIME 47 9445
TEST_TIME 48 9450
TEST_TIME 49 9507
TEST_TIME 50 9541
TEST_TIME 51 9584
TEST_TIME 52 9529
TEST_TIME 53 9713
TEST_TIME 54 9696
TEST_TIME 55 9670
TEST_TIME 56 9512
TEST_TIME 57 9451
TEST_TIME 58 9490
TEST_TIME 59 9439
TEST_TIME 60 9361
TEST_TIME 61 9343
TEST_TIME 62 9279
TEST_TIME 63 9204
TEST_TIME 64 9304
TEST_TIME 65 9312
TEST_TIME 66 9270
TEST_TIME 67 9266
TEST_TIME 68 9313
TEST_TIME 69 9282
TEST_TIME 70 9379
TEST_TIME 71 9357
TEST_TIME 72 9385
TEST_TIME 73 9444
TEST_TIME 74 9508
TEST_TIME 75 9461
TEST_TIME 76 9374
TEST_TIME 77 9323
TEST_TIME 78 9310
TEST_TIME 79 9270
TEST_TIME 80 9198
TEST_TIME 81 9191
TEST_TIME 82 9190
TEST_TIME 83 9153
TEST_TIME 84 9225
TEST_TIME 85 9155
TEST_TIME 86 9196
TEST_TIME 87 9148
TEST_TIME 88 9130
TEST_TIME 89 9183
TEST_TIME 90 9152
TEST_TIME 91 9175
TEST_TIME 92 9175
TEST_TIME 93 9202
TEST_TIME 94 9237
TEST_TIME 95 9144
TEST_TIME 96 9153
TEST_TIME 97 9144
TEST_TIME 98 9111
TEST_TIME 99 9094
TEST_TIME 100 9101

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-04-2024 04:09:23 to 02-04-2024 04:09:26.

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 1289103 1289103 0 0.00 0 23482 8 0 0
doc_list_biud 1289103 1289103 0 0.00 0 45807 24 0 0
sp_add_invoice_to_stock 4433 4360 73 1.64 24 214876 21861 0 73
sp_cancel_adding_invoice 4317 4317 0 0.00 4 59023 829 0 0
sp_cancel_client_order 1530 1530 0 0.00 4 12851 384 0 0
sp_cancel_customer_reserve 422228 422228 0 0.00 0 30088 57 0 0
sp_cancel_pay_from_customer 568 568 0 0.00 3 9934 89 0 0
sp_cancel_pay_to_supplier 361 361 0 0.00 2 11694 128 0 0
sp_cancel_supplier_invoice 4819 4810 9 0.18 2 45821 746 0 9
sp_cancel_supplier_order 349 349 0 0.00 22 804612 86262 0 0
sp_cancel_write_off 7822 7822 0 0.00 1 17695 128 0 0
sp_client_order 18317 18317 0 0.00 3 33905 392 0 0
sp_customer_reserve 413959 413959 0 0.00 0 41900 213 0 0
sp_fill_shopping_cart 28037 28037 0 0.00 1 19199 36 0 0
sp_fill_shopping_cart_clo_res 413951 413951 0 0.00 0 28576 20 0 0
sp_get_clo_for_invoice 4346 4346 0 0.00 0 18251 333 0 0
sp_kill_cost_storno 13068 13068 0 0.00 0 21138 63 0 0
sp_kill_qstorno_ret_qs2qd 857437 857437 0 0.00 0 45804 31 0 0
sp_kill_qty_storno 454139 454139 0 0.00 0 45806 66 0 0
sp_lock_selected_doc 18116 18116 0 0.00 0 8253 4 0 0
sp_make_cost_storno 24342 24342 0 0.00 0 23023 56 0 0
sp_multiply_rows_for_pdistr 24342 24342 0 0.00 0 7741 29 0 0
sp_multiply_rows_for_qdistr 18317 18317 0 0.00 0 33895 214 0 0
sp_pay_from_customer 6101 6101 0 0.00 3 10992 101 0 0
sp_pay_to_supplier 5158 5158 0 0.00 4 23028 129 0 0
sp_payment_common 11259 11259 0 0.00 1 7130 17 0 0
sp_qd_handle_on_cancel_clo 1530 1530 0 0.00 0 12844 345 0 0
sp_qd_handle_on_invoice_upd_sts 8663 8663 0 0.00 0 20448 282 0 0
sp_qd_handle_on_reserve_upd_sts 8737 8737 0 0.00 0 18779 48 0 0
sp_reserve_write_off 8737 8737 0 0.00 5 23488 165 0 0
sp_supplier_invoice 5002 5002 0 0.00 6 79029 2971 0 0
sp_supplier_order 4726 4726 0 0.00 4 29555 1325 0 0
srv_aggregate_perf_data 95 95 0 0.00 1627 360006 16689 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 2444 137968 40801 0 0
srv_find_qd_qs_mism 865533 865533 0 0.00 0 17779 8 0 0
srv_make_invnt_saldo 401 401 0 0.00 44 100261 3858 0 0
srv_make_money_saldo 671 671 0 0.00 1 14150 531 0 0
srv_recalc_idx_stat 3 3 0 0.00 94932 304054 200913 0 0
t$perf-abend:sp_add_invoice_to_stock 73 73 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4360 4360 0 0.00 0 5870 161 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 0 1446 72 0 0
t$perf-norm:sp_cancel_client_order 1530 1530 0 0.00 0 1954 13 0 0
t$perf-norm:sp_cancel_customer_reserve 598 598 0 0.00 0 2392 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 568 568 0 0.00 0 1928 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 361 361 0 0.00 0 3989 30 0 0
t$perf-norm:sp_cancel_supplier_invoice 340 340 0 0.00 0 2274 19 0 0
t$perf-norm:sp_cancel_supplier_order 349 349 0 0.00 0 21279 1491 0 0
t$perf-norm:sp_cancel_write_off 887 887 0 0.00 0 4279 12 0 0
t$perf-norm:sp_client_order 18317 18317 0 0.00 0 9919 15 0 0
t$perf-norm:sp_customer_reserve 896 896 0 0.00 0 2311 7 0 0
t$perf-norm:sp_pay_from_customer 6101 6101 0 0.00 0 4501 8 0 0
t$perf-norm:sp_pay_to_supplier 5158 5158 0 0.00 0 5351 10 0 0
t$perf-norm:sp_reserve_write_off 8737 8737 0 0.00 0 11594 10 0 0
t$perf-norm:sp_supplier_invoice 5002 5002 0 0.00 0 6924 19 0 0
t$perf-norm:sp_supplier_order 4726 4726 0 0.00 0 4948 11 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 280 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 2 0 0 0
t$perf-norm:srv_make_invnt_saldo 401 401 0 0.00 0 954 10 0 0
t$perf-norm:srv_make_money_saldo 671 671 0 0.00 0 5405 13 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8836 8690 146 1.65 0 6432 17 0 146
v_all_customers 33596 33596 0 0.00 0 118 1 0 0
v_all_suppliers 27488 27488 0 0.00 0 119 1 0 0
v_all_wares 36630 36630 0 0.00 0 78 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 723 8 0 0
v_cancel_client_order 3060 3060 0 0.00 0 4251 6 0 0
v_cancel_customer_prepayment 1136 1136 0 0.00 0 4747 14 0 0
v_cancel_customer_reserve 1196 1196 0 0.00 0 2861 8 0 0
v_cancel_payment_to_supplier 722 722 0 0.00 0 7427 19 0 0
v_cancel_supplier_invoice 698 680 18 2.57 0 3068 18 0 18
v_cancel_supplier_order 698 698 0 0.00 0 278 3 0 0
v_cancel_write_off 1774 1774 0 0.00 0 1826 13 0 0
v_max_id_clo_ord 4726 4726 0 0.00 0 1564 2 0 0
v_max_id_clo_res 896 896 0 0.00 0 928 7 0 0
v_max_id_ord_sup 4996 4996 0 0.00 0 6167 6 0 0
v_max_non_paid_invoice 1136 1136 0 0.00 0 78 1 0 0
v_max_non_paid_realizn 3033 3033 0 0.00 0 6098 7 0 0
v_min_id_clo_ord 4726 4726 0 0.00 0 3754 9 0 0
v_min_id_clo_res 896 896 0 0.00 0 10536 27 0 0
v_min_id_ord_sup 4996 4996 0 0.00 0 5896 10 0 0
v_min_non_paid_invoice 5158 5158 0 0.00 0 5171 11 0 0
v_min_non_paid_realizn 6101 6101 0 0.00 0 3866 10 0 0
v_our_firm 9170 9170 0 0.00 0 16 1 0 0
v_reserve_write_off 17474 17474 0 0.00 0 12610 7 0 0
x_lock_depdocs_on_canc_invoice 8787 8787 0 0.00 0 9793 124 0 0
x_lock_depdocs_on_canc_sup_ord 349 349 0 0.00 0 10262 370 0 0
x_make_qstorno_1000_1200 4726 4726 0 0.00 1 29542 1252 0 0
x_make_qstorno_1200_2000 5002 5002 0 0.00 3 79010 2842 0 0
x_make_qstorno_2100_3300 413959 413959 0 0.00 0 38394 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-04-2024 04:09:27 to 02-04-2024 04:09: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
02:07:53 2 8192000000 8797910368 8808878080 4076656 0.049 2 1 2 0 4176048 63616 35776
02:08:54 36290 8192000000 9709736672 10007232512 788717072 8.782 100 90 180 0 818374944 7806736 21851136
02:10:36 23864 8192000000 9751725072 10059755520 822998112 9.129 100 84 167 0 854138656 11354080 19786464
02:12:06 18030 8192000000 9781485952 10098855936 857514160 9.475 100 84 168 0 892089904 15390624 19185120
02:13:38 11236 8192000000 9844101792 10174730240 899853776 9.897 100 78 157 0 951328608 34919744 16555088
02:14:56 9789 8192000000 9878881136 10228756480 935025120 10.244 100 76 150 2 1000138048 50074240 15038688
02:16:10 5300 8192000000 9912702432 10272321536 975103664 10.636 100 76 149 0 1030809552 40399760 15306128
02:17:19 1776 8192000000 9989464512 10352959488 1008193712 10.958 100 83 164 1 1102445040 78260352 15990976
02:18:23 5835 8192000000 9994732992 10365014016 1023627472 11.107 100 77 154 0 1117635216 79283904 14723840
02:19:31 1389 8192000000 10019131248 10392231936 1055552640 11.414 100 88 174 2 1131293120 58764384 16976096
02:20:34 2466 8192000000 10031509872 10417414144 1062425632 11.480 100 67 131 2 1136889984 62039232 12425120
02:21:38 5785 8192000000 9977324032 10376916992 1068552672 11.538 100 35 69 0 1108746976 33070288 7124016
02:22:45 6372 8192000000 9988931312 10387161088 1072773424 11.579 100 24 47 0 1105946016 28502128 4670464
02:23:52 8170 8192000000 9978023776 10376671232 1077849888 11.627 100 30 63 0 1093520704 9145184 6525632
02:25:01 49150 8192000000 10005538640 10400026624 1082927920 11.675 100 39 78 2 1108998560 16854640 9216000
02:26:53 4688 8192000000 9999973008 10410913792 1088329664 11.727 100 43 87 0 1113124352 15631552 9163136
02:28:00 11815 8192000000 10010292304 10410041344 1090730048 11.750 100 53 106 0 1127817568 26311520 10776000
02:29:19 7931 8192000000 10082147024 10479013888 1102424400 11.861 100 66 130 0 1186081664 70711040 12946224
02:30:29 94519 8192000000 10060725008 10508267520 1099312768 11.831 99 31 62 1 1203468304 97659744 6495792
02:33:12 13833 8192000000 10100522672 10516160512 1091723200 11.759 99 46 91 1 1200090112 99530368 8836544
02:34:43 11788 8192000000 10085422432 10483384320 1099953712 11.837 100 63 126 0 1190678416 78269216 12455488
02:36:02 3299 8192000000 10128098272 10529759232 1115013040 11.980 100 59 115 2 1237829632 111210160 11606432
02:37:07 3273 8192000000 10123630512 10524016640 1102038240 11.857 100 59 118 0 1235338160 121705488 11594432
02:38:24 6348 8192000000 10088018000 10482724864 1063966480 11.494 98 48 93 0 1188958544 114387360 10604704
02:39:33 2442 8192000000 10134212704 10556186624 1100173232 11.839 100 61 122 1 1236980368 124195344 12611792
02:40:38 3076 8192000000 10150914816 10544267264 1105088768 11.886 100 60 120 0 1250243344 132978704 12175872
02:41:44 3675 8192000000 10156018032 10553831424 1096965552 11.809 100 55 109 3 1262826784 153852272 12008960
02:42:55 2836 8192000000 10160451616 10549157888 1070132640 11.553 98 60 118 1 1261839376 178788400 12918336
02:44:03 2456 8192000000 10209102976 10596507648 1103733584 11.873 100 75 148 1 1305424480 186191408 15499488
02:45:07 2742 8192000000 10253537008 10642620416 1112181200 11.953 100 77 149 1 1354631152 225288336 17161616
02:46:13 8338 8192000000 10245004176 10663616512 1115337952 11.983 99 39 78 0 1348649120 224178672 9132496
02:47:36 5441 8192000000 10305179456 10707574784 1132388064 12.144 100 57 114 1 1412198768 267154368 12656336
02:48:43 5231 8192000000 10314914608 10728017920 1130590112 12.127 100 48 95 1 1415991584 274149824 11251648
02:49:54 7562 8192000000 10264715872 10711932928 1136087968 12.179 100 29 57 0 1388354752 244818208 7448576
02:51:30 22102 8192000000 10180175120 10655137792 1135072560 12.169 100 19 38 0 1283964784 144685840 4206384
02:53:05 52014 8192000000 10080343072 10629922816 1123748208 12.062 100 4 8 0 1186661456 62060112 853136
02:54:58 27586 8192000000 10068820592 10499497984 1119300384 12.020 99 41 85 0 1162362288 34555552 8506352
02:56:27 54462 8192000000 10075549520 10525487104 1117845056 12.007 99 37 74 1 1171807968 47125264 6837648
02:58:35 88020 8192000000 10068944640 10525253632 1135189536 12.170 100 31 62 0 1193323104 51978240 6155328
03:01:08 10175 8192000000 10102257584 10546380800 1144406240 12.257 100 44 88 0 1198725792 45187568 9131984
03:02:24 27179 8192000000 10122845664 10558455808 1145642320 12.269 100 36 70 0 1217432576 63846592 7943664
03:03:58 30379 8192000000 10142989152 10603163648 1153724752 12.344 100 36 72 0 1226221296 64206016 8290528
03:05:31 52802 8192000000 10157681808 10625769472 1154012640 12.347 100 19 37 0 1254152160 96107392 4032128
03:07:24 30685 8192000000 10119275072 10610307072 1161810688 12.420 100 21 42 1 1275875424 109817392 4247344
03:09:24 82416 8192000000 10079210128 10542374912 1162789504 12.429 100 17 34 0 1218620656 52772736 3058416
03:12:18 35263 8192000000 10085893248 10539745280 1130065360 12.122 98 42 82 0 1181744192 43921120 7757712
03:13:58 24649 8192000000 10077731440 10520788992 1112408384 11.955 98 37 72 0 1172278128 52122688 7747056
03:15:52 61441 8192000000 10084982704 10563473408 1089323440 11.736 96 27 54 0 1160855056 65885152 5646464
03:17:57 100415 8192000000 10033895920 10465189888 1009478512 10.970 90 16 31 0 1070291824 57632928 3180384
03:20:38 89235 8192000000 10028280864 10471059456 1027317168 11.143 93 10 18 2 1052323056 23043840 1962048
03:23:17 137968 8192000000 10058120496 10503417856 1079557552 11.643 99 36 73 0 1187579904 101223408 6798944
03:26:36 36850 8192000000 10024783216 10479718400 1082934208 11.675 99 10 20 0 1139110432 54131472 2044752
03:28:27 47125 8192000000 10044427136 10488639488 1065992336 11.514 97 16 31 0 1101239568 32408784 2838448
03:31:11 60993 8192000000 10035357264 10570477568 1093226560 11.773 99 7 14 0 1164184688 69585472 1372656
03:33:13 16825 8192000000 10016461376 10445791232 1090092688 11.744 99 25 48 1 1118306928 23351376 4862864
03:34:32 45668 8192000000 10088116272 10552262656 1081757056 11.664 98 35 70 0 1144612688 55718800 7136832
03:36:18 89299 8192000000 10036310000 10489466880 1057392736 11.432 95 27 54 0 1121429152 59242480 4793936
03:38:48 4298 8192000000 10091134320 10489217024 1097467184 11.814 99 66 130 0 1160951536 50921136 12563216
03:39:53 44495 8192000000 10092843824 10542632960 1109603472 11.929 100 32 64 0 1181103856 65581440 5918944
03:41:41 55720 8192000000 10077178544 10494812160 1113584944 11.966 99 44 87 0 1159574224 37547600 8441680
03:43:39 73585 8192000000 10051730912 10486657024 1115845328 11.988 99 40 80 0 1169554704 45444272 8265104
03:45:56 36009 8192000000 10042035760 10513395712 1132312016 12.143 100 7 14 0 1163513968 29678736 1523216
03:47:32 29849 8192000000 10073040944 10519044096 1140436992 12.220 100 15 28 0 1168831440 25793504 2600944
03:49:12 57404 8192000000 10092527536 10544607232 1135595328 12.174 99 18 36 0 1164566032 25611520 3359184
03:51:14 92955 8192000000 10079971792 10519236608 1121973200 12.046 98 15 30 0 1191243200 65810704 3459296
03:53:52 84624 8192000000 10114755856 10553839616 1126753360 12.091 98 18 36 1 1171642784 41289424 3600000
03:56:17 88458 8192000000 10062752976 10527752192 1072572352 11.577 94 19 37 0 1109615568 33306112 3737104
03:58:48 31754 8192000000 10063500672 10505060352 1102721520 11.863 98 23 46 1 1154843984 47571792 4550672
04:00:20 80004 8192000000 10127381200 10648354816 1089124160 11.734 96 16 32 0 1180157440 87812768 3220512
04:02:43 77316 8192000000 10068972608 10543243264 1097529936 11.814 98 21 42 1 1185292160 82959712 4802512
04:05:05 66095 8192000000 10037214272 10492923904 1097351632 11.813 99 5 10 0 1132328176 34129056 847488
04:07:19 42055 8192000000 9120140272 9376358400 258378832 3.057 23 5 10 0 292855248 33435456 1040960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 02-04-2024 04:09:33 to 02-04-2024 04:09:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 73 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-04-2024 04:09:48 to 02-04-2024 04:09:50.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          176022
MON$OLDEST_ACTIVE               176023
MON$OLDEST_SNAPSHOT             176023
MON$NEXT_TRANSACTION            176023
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-30 07:30:08.6030 GMT
MON$PAGES                       1906784
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             700
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Apr  2 04:09:51 2024 
 
Database header page information: 
    Flags            0 
    Generation        91866 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    176022 
    Oldest active        176023 
    Oldest snapshot        176023 
    Next transaction    176024 
    Sequence number        0 
    Next attachment ID    700 
    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 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.49, total records: 7770503 
    Average version length: 48.16, total versions: 81368, 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: 55, data page slots: 89120 
    Data pages: 89120, average fill: 70% 
    Primary pages: 89119, secondary pages: 1, swept pages: 38245 
    Empty pages: 6, full pages: 69769 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 34 
    40 - 59% = 1209 
    60 - 79% = 87771 
    80 - 99% = 94 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23210, nodes: 7770503 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1687800, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 333 
        20 - 39% = 1743 
        40 - 59% = 3992 
        60 - 79% = 2371 
        80 - 99% = 14771 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13506, nodes: 7770503 
    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: 1511708, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1587 
        40 - 59% = 1974 
        60 - 79% = 1094 
        80 - 99% = 8850 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8339, nodes: 7770503 
    Average node length: 6.62, total dup: 5807353, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1504574, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 960 
        40 - 59% = 1361 
        60 - 79% = 890 
        80 - 99% = 4995 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.51, total records: 2255174 
    Average version length: 58.83, total versions: 43586, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28696 
    Data pages: 28696, average fill: 72% 
    Primary pages: 28694, secondary pages: 2, swept pages: 10440 
    Empty pages: 1, full pages: 19807 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 11 
    40 - 59% = 212 
    60 - 79% = 28374 
    80 - 99% = 96 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4543, nodes: 2255174 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687464, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 921 
        40 - 59% = 800 
        60 - 79% = 712 
        80 - 99% = 2110 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2441, nodes: 2256410 
    Average node length: 4.97, total dup: 2255511, max dup: 18663 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1269275, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 192 
        40 - 59% = 1451 
        60 - 79% = 564 
        80 - 99% = 232 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1795, nodes: 2255174 
    Average node length: 4.97, total dup: 2255124, max dup: 130435 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1069043, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 664 
        60 - 79% = 36 
        80 - 99% = 1089 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4344, nodes: 2255174 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687464, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 542 
        40 - 59% = 628 
        60 - 79% = 818 
        80 - 99% = 2244 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.24, total records: 400 
    Average version length: 25.51, total versions: 2273, max versions: 6 
    Average fragment length: 2.00, total fragments: 9, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 53% 
    Primary pages: 13, secondary pages: 19, swept pages: 0 
    Empty pages: 6, full pages: 14 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 20.89, total records: 90365 
    Average version length: 68.30, total versions: 72241, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.21 
    Pointer pages: 7, data page slots: 2136 
    Data pages: 1920, average fill: 62% 
    Primary pages: 1919, secondary pages: 1, swept pages: 0 
    Empty pages: 239, full pages: 1004 
    Fill distribution: 
     0 - 19% = 300 
    20 - 39% = 203 
    40 - 59% = 219 
    60 - 79% = 384 
    80 - 99% = 814 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699600, depth: 3, leaf buckets: 378, nodes: 90365 
    Average node length: 13.11, total dup: 6140, max dup: 1 
    Average key length: 10.67, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 64840, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 253 
        40 - 59% = 112 
        60 - 79% = 13 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 193, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 81% 
    Primary pages: 1, 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% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 13.78, total records: 1345 
    Average version length: 43.46, total versions: 1160, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.21 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 45% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 8 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90015, depth: 2, leaf buckets: 3, nodes: 1345 
    Average node length: 4.41, total dup: 1248, max dup: 164 
    Average key length: 2.77, compression ratio: 6.86 
    Average prefix length: 18.30, average data length: 0.70 
    Clustering factor: 741, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.57, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 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% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, 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: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.41, total records: 797173 
    Average version length: 37.90, total versions: 28102, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8456 
    Data pages: 8456, average fill: 65% 
    Primary pages: 8455, secondary pages: 1, swept pages: 2661 
    Empty pages: 5, full pages: 4939 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 55 
    40 - 59% = 852 
    60 - 79% = 7478 
    80 - 99% = 57 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 847, nodes: 784957 
    Average node length: 4.88, total dup: 784908, max dup: 143280 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88857, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 137 
        40 - 59% = 443 
        60 - 79% = 162 
        80 - 99% = 104 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 918, nodes: 784957 
    Average node length: 5.88, total dup: 699015, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156230, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 54 
        40 - 59% = 481 
        60 - 79% = 98 
        80 - 99% = 285 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 954, nodes: 784957 
    Average node length: 5.88, total dup: 699015, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158022, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 106 
        40 - 59% = 479 
        60 - 79% = 101 
        80 - 99% = 268 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1138, nodes: 784957 
    Average node length: 5.97, total dup: 699015, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150891, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 273 
        40 - 59% = 592 
        60 - 79% = 174 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.72, total records: 5408 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.27, total fragments: 44, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 86, average fill: 62% 
    Primary pages: 74, secondary pages: 12, swept pages: 52 
    Empty pages: 4, full pages: 57 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5408 
    Average node length: 5.54, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.32, average data length: 1.55 
    Clustering factor: 5088, 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: 1504255, depth: 2, leaf buckets: 10, nodes: 5408 
    Average node length: 11.17, 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: 162, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 80449 
    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: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 835 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 835 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32606, depth: 2, leaf buckets: 102, nodes: 80449 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3177, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.15, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 142.86, total records: 150226 
    Average version length: 152.00, total versions: 8367, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 5, data page slots: 5928 
    Data pages: 3744, average fill: 83% 
    Primary pages: 3742, secondary pages: 2, swept pages: 2 
    Empty pages: 55, full pages: 3674 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 3674 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 131.52, total records: 162262 
    Average version length: 154.06, total versions: 22282, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.90 
    Pointer pages: 7, data page slots: 4544 
    Data pages: 4040, average fill: 85% 
    Primary pages: 4037, secondary pages: 3, swept pages: 3 
    Empty pages: 42, full pages: 3983 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3984 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 139.99, total records: 171652 
    Average version length: 153.08, total versions: 13433, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 7, data page slots: 5880 
    Data pages: 4280, average fill: 84% 
    Primary pages: 4278, secondary pages: 2, swept pages: 1 
    Empty pages: 55, full pages: 4208 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 4210 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 139.30, total records: 169056 
    Average version length: 152.26, total versions: 13973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.18 
    Pointer pages: 8, data page slots: 5264 
    Data pages: 4280, average fill: 82% 
    Primary pages: 4277, secondary pages: 3, swept pages: 3 
    Empty pages: 107, full pages: 4139 
    Fill distribution: 
     0 - 19% = 118 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4139 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 144.92, total records: 157619 
    Average version length: 151.76, total versions: 6511, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 6, data page slots: 4168 
    Data pages: 3928, average fill: 83% 
    Primary pages: 3926, secondary pages: 2, swept pages: 5 
    Empty pages: 53, full pages: 3856 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3857 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 138.66, total records: 174585 
    Average version length: 153.49, total versions: 15081, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.23 
    Pointer pages: 6, data page slots: 4936 
    Data pages: 4392, average fill: 83% 
    Primary pages: 4391, secondary pages: 1, swept pages: 4 
    Empty pages: 88, full pages: 4280 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4280 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 142.90, total records: 139958 
    Average version length: 151.50, total versions: 7714, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 3488, average fill: 83% 
    Primary pages: 3486, secondary pages: 2, swept pages: 3 
    Empty pages: 48, full pages: 3419 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 3419 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 124.28, total records: 172912 
    Average version length: 154.30, total versions: 32144, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.65 
    Pointer pages: 6, data page slots: 6288 
    Data pages: 4312, average fill: 85% 
    Primary pages: 4310, secondary pages: 2, swept pages: 3 
    Empty pages: 53, full pages: 4239 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 4240 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 139.94, total records: 165926 
    Average version length: 152.02, total versions: 12925, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 6, data page slots: 5856 
    Data pages: 4120, average fill: 84% 
    Primary pages: 4118, secondary pages: 2, swept pages: 1 
    Empty pages: 34, full pages: 4067 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 4066 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 145.92, total records: 148529 
    Average version length: 151.75, total versions: 4937, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 5, data page slots: 5016 
    Data pages: 3680, average fill: 83% 
    Primary pages: 3678, secondary pages: 2, swept pages: 3 
    Empty pages: 35, full pages: 3624 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3624 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.09, total records: 2110797 
    Average version length: 53.04, total versions: 31978, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25616 
    Data pages: 25616, average fill: 71% 
    Primary pages: 25609, secondary pages: 7, swept pages: 10982 
    Empty pages: 75, full pages: 22823 
    Fill distribution: 
     0 - 19% = 146 
    20 - 39% = 179 
    40 - 59% = 599 
    60 - 79% = 24356 
    80 - 99% = 336 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2565, nodes: 2110797 
    Average node length: 5.44, total dup: 1970312, max dup: 1552 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182880, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 273 
        40 - 59% = 1676 
        60 - 79% = 292 
        80 - 99% = 322 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2110797 
    Average node length: 5.69, total dup: 1894586, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377512, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2396 
        60 - 79% = 330 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2100, nodes: 2110797 
    Average node length: 4.96, total dup: 2110697, max dup: 27731 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180747, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 181 
        40 - 59% = 1043 
        60 - 79% = 411 
        80 - 99% = 465 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, 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: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 44.98, total records: 140631 
    Average version length: 69.18, total versions: 56606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.80 
    Pointer pages: 3, data page slots: 4192 
    Data pages: 3256, average fill: 52% 
    Primary pages: 3255, secondary pages: 1, swept pages: 493 
    Empty pages: 572, full pages: 1371 
    Fill distribution: 
     0 - 19% = 791 
    20 - 39% = 277 
    40 - 59% = 472 
    60 - 79% = 933 
    80 - 99% = 783 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105457, depth: 3, leaf buckets: 234, nodes: 140631 
    Average node length: 6.47, total dup: 122320, max dup: 14 
    Average key length: 3.96, compression ratio: 10.59 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24634, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 59 
        40 - 59% = 125 
        60 - 79% = 43 
        80 - 99% = 5 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.25, total records: 7000736 
    Average version length: 68.75, total versions: 315266, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 65, data page slots: 105384 
    Data pages: 105384, average fill: 71% 
    Primary pages: 105384, secondary pages: 0, swept pages: 28599 
    Empty pages: 12, full pages: 62441 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 429 
    40 - 59% = 6293 
    60 - 79% = 97627 
    80 - 99% = 964 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10579, nodes: 7000736 
    Average node length: 6.51, total dup: 6055334, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1650915, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1670 
        40 - 59% = 5679 
        60 - 79% = 2692 
        80 - 99% = 528 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8433, nodes: 7000736 
    Average node length: 5.40, total dup: 6720908, max dup: 168 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1454917, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1186 
        40 - 59% = 4622 
        60 - 79% = 1579 
        80 - 99% = 1032 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8484, nodes: 7000736 
    Average node length: 5.40, total dup: 6720908, max dup: 168 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1457354, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1210 
        40 - 59% = 4655 
        60 - 79% = 1581 
        80 - 99% = 1033 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.67, total records: 11861921 
    Average version length: 68.75, total versions: 251355, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 106, data page slots: 172112 
    Data pages: 172112, average fill: 73% 
    Primary pages: 172112, secondary pages: 0, swept pages: 70896 
    Empty pages: 6, full pages: 148083 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 427 
    40 - 59% = 4872 
    60 - 79% = 165332 
    80 - 99% = 1451 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18316, nodes: 11859276 
    Average node length: 6.60, total dup: 10340705, max dup: 61 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2449302, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2584 
        40 - 59% = 10633 
        60 - 79% = 4345 
        80 - 99% = 727 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 49.12, total records: 1685906 
    Average version length: 69.05, total versions: 307228, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.57 
    Pointer pages: 28, data page slots: 43928 
    Data pages: 29840, average fill: 57% 
    Primary pages: 29758, secondary pages: 82, swept pages: 8301 
    Empty pages: 2683, full pages: 20379 
    Fill distribution: 
     0 - 19% = 4227 
    20 - 39% = 4285 
    40 - 59% = 2747 
    60 - 79% = 14260 
    80 - 99% = 4321 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1993, nodes: 1431570 
    Average node length: 5.53, total dup: 1373807, max dup: 84 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 99746, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 532 
        40 - 59% = 981 
        60 - 79% = 417 
        80 - 99% = 53 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.83, total records: 1208884 
    Average version length: 69.00, total versions: 146363, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.09 
    Pointer pages: 20, data page slots: 32272 
    Data pages: 26144, average fill: 40% 
    Primary pages: 26143, secondary pages: 1, swept pages: 5772 
    Empty pages: 4619, full pages: 7976 
    Fill distribution: 
     0 - 19% = 6731 
    20 - 39% = 4331 
    40 - 59% = 8133 
    60 - 79% = 6764 
    80 - 99% = 185 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1163, nodes: 787808 
    Average node length: 5.95, total dup: 724790, max dup: 62 
    Average key length: 3.02, compression ratio: 13.89 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 114513, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 288 
        40 - 59% = 593 
        60 - 79% = 256 
        80 - 99% = 26 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.24, total records: 9202144 
    Average version length: 68.98, total versions: 404518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 88, data page slots: 142192 
    Data pages: 142152, average fill: 69% 
    Primary pages: 142139, secondary pages: 13, swept pages: 48064 
    Empty pages: 235, full pages: 81159 
    Fill distribution: 
     0 - 19% = 873 
    20 - 39% = 3716 
    40 - 59% = 14588 
    60 - 79% = 120437 
    80 - 99% = 2538 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13465, nodes: 9198359 
    Average node length: 6.67, total dup: 7630615, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2112506, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1333 
        40 - 59% = 6783 
        60 - 79% = 4668 
        80 - 99% = 680 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21169404 
    Average version length: 82.92, total versions: 9037, 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: 197, data page slots: 319992 
    Data pages: 319992, average fill: 81% 
    Primary pages: 319988, secondary pages: 4, swept pages: 12531 
    Empty pages: 8, full pages: 319879 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 6 
    40 - 59% = 17 
    60 - 79% = 49534 
    80 - 99% = 270424 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19401, nodes: 21169404 
    Average node length: 5.72, total dup: 20688051, max dup: 133 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287285, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8159 
        60 - 79% = 529 
        80 - 99% = 10707 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17205, nodes: 21169404 
    Average node length: 6.31, total dup: 18604376, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919135, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 816 
        60 - 79% = 275 
        80 - 99% = 16110 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21222, nodes: 21169404 
    Average node length: 6.35, total dup: 18522789, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3581272, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8498 
        60 - 79% = 596 
        80 - 99% = 12123 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16193, nodes: 21169404 
    Average node length: 5.56, total dup: 21169304, max dup: 229240 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947916, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 11 
        40 - 59% = 3047 
        60 - 79% = 377 
        80 - 99% = 12755 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.27, total records: 9665920 
    Average version length: 82.64, total versions: 414432, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 105, data page slots: 170144 
    Data pages: 170128, average fill: 70% 
    Primary pages: 170098, secondary pages: 30, swept pages: 68565 
    Empty pages: 508, full pages: 108346 
    Fill distribution: 
     0 - 19% = 1736 
    20 - 39% = 6945 
    40 - 59% = 20917 
    60 - 79% = 118441 
    80 - 99% = 22089 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11340, nodes: 9665920 
    Average node length: 5.36, total dup: 9357578, max dup: 203 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2198255, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 50 
        40 - 59% = 8301 
        60 - 79% = 2909 
        80 - 99% = 77 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13278, nodes: 9665920 
    Average node length: 6.23, total dup: 8013536, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1542922, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 3753 
        40 - 59% = 4202 
        60 - 79% = 2698 
        80 - 99% = 2521 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12651, nodes: 9665920 
    Average node length: 5.97, total dup: 8388594, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2389028, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 75 
        40 - 59% = 9236 
        60 - 79% = 3240 
        80 - 99% = 97 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10072, nodes: 9665920 
    Average node length: 5.13, total dup: 9665820, max dup: 156323 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1564829, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1211 
        40 - 59% = 5025 
        60 - 79% = 1727 
        80 - 99% = 2078 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.29, total records: 11445137 
    Average version length: 82.60, total versions: 313895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 119, data page slots: 193912 
    Data pages: 192432, average fill: 73% 
    Primary pages: 192308, secondary pages: 124, swept pages: 60753 
    Empty pages: 2048, full pages: 153299 
    Fill distribution: 
     0 - 19% = 3909 
    20 - 39% = 6557 
    40 - 59% = 14858 
    60 - 79% = 100399 
    80 - 99% = 66709 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13114, nodes: 11445137 
    Average node length: 5.31, total dup: 11335275, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2403132, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 96 
        40 - 59% = 8745 
        60 - 79% = 4089 
        80 - 99% = 183 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10517, nodes: 11445137 
    Average node length: 5.50, total dup: 10946364, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 740504, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 788 
        40 - 59% = 2607 
        60 - 79% = 1775 
        80 - 99% = 5180 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15002, nodes: 11445137 
    Average node length: 6.03, total dup: 9989980, max dup: 69 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2419619, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 128 
        40 - 59% = 10225 
        60 - 79% = 4447 
        80 - 99% = 200 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10985, nodes: 11445137 
    Average node length: 5.23, total dup: 11445037, max dup: 190134 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 728335, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 827 
        40 - 59% = 4986 
        60 - 79% = 1567 
        80 - 99% = 3502 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.57, total records: 9785130 
    Average version length: 82.93, total versions: 419675, 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: 107, data page slots: 174224 
    Data pages: 174208, average fill: 70% 
    Primary pages: 174176, secondary pages: 32, swept pages: 70851 
    Empty pages: 545, full pages: 107543 
    Fill distribution: 
     0 - 19% = 1865 
    20 - 39% = 7774 
    40 - 59% = 23573 
    60 - 79% = 119265 
    80 - 99% = 21731 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11843, nodes: 9785130 
    Average node length: 5.17, total dup: 9756302, max dup: 2133 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1992071, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1448 
        40 - 59% = 7998 
        60 - 79% = 1755 
        80 - 99% = 602 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13428, nodes: 9785130 
    Average node length: 6.24, total dup: 8111765, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1501941, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 3719 
        40 - 59% = 4220 
        60 - 79% = 2718 
        80 - 99% = 2622 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12448, nodes: 9785130 
    Average node length: 5.43, total dup: 9346886, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2126584, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1402 
        40 - 59% = 8860 
        60 - 79% = 1602 
        80 - 99% = 563 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10214, nodes: 9785130 
    Average node length: 5.14, total dup: 9785030, max dup: 159061 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1579876, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1170 
        40 - 59% = 5170 
        60 - 79% = 1752 
        80 - 99% = 2081 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.68, total records: 576393 
    Average version length: 68.82, total versions: 4779, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3650 
    Empty pages: 2, full pages: 7071 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 5 
    40 - 59% = 108 
    60 - 79% = 7884 
    80 - 99% = 64 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38871, depth: 3, leaf buckets: 740, nodes: 576393 
    Average node length: 5.95, total dup: 490778, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101442, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 516 
        60 - 79% = 102 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30735, depth: 3, leaf buckets: 755, nodes: 576393 
    Average node length: 6.15, total dup: 472828, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101492, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 520 
        60 - 79% = 98 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 563, nodes: 576393 
    Average node length: 4.86, total dup: 576293, max dup: 9378 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90110, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 312 
        60 - 79% = 86 
        80 - 99% = 132 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Tue Apr  2 04:10:15 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7770503 81368 1 0.0000 0.0000
DOC_LIST 2255174 43586 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2273 6 500.0000 0.0000
INVNT_TURNOVER_LOG 90365 72241 1 0.0000 0.0000
MONEY_SALDO 49 193 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1345 1160 1 0.0000 0.0000
PDISTR 797173 28102 2 0.0000 0.0000
PERF_SPLIT_0 150226 8367 1 0.0000 0.0000
PERF_SPLIT_1 162262 22282 1 0.0000 0.0000
PERF_SPLIT_2 171652 13433 1 0.0000 0.0000
PERF_SPLIT_3 169056 13973 1 0.0000 0.0000
PERF_SPLIT_4 157619 6511 1 0.0000 0.0000
PERF_SPLIT_5 174585 15081 1 0.0000 0.0000
PERF_SPLIT_6 139958 7714 1 0.0000 0.0000
PERF_SPLIT_7 172912 32144 1 0.0000 0.0000
PERF_SPLIT_8 165926 12925 1 0.0000 0.0000
PERF_SPLIT_9 148529 4937 1 0.0000 0.0000
PSTORNED 2110797 31978 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 140631 56606 1 0.0000 0.0000
XQD_1000_3300 7000736 315266 1 0.0000 0.0000
XQD_1200_2000 11861921 251355 1 0.0000 0.0000
XQD_2000_3300 1685906 307228 1 0.0000 0.0000
XQD_2100_3300 1208884 146363 1 0.0000 0.0000
XQD_3300_3400 9202144 404518 1 0.0000 0.0000
XQS_1000_1200 21169404 9037 1 0.0000 0.0000
XQS_1000_3300 9665920 414432 1 0.0000 0.0000
XQS_1200_2000 11445137 313895 1 0.0000 0.0000
XQS_2100_3300 9785130 419675 1 0.0000 0.0000
XQS_3300_3400 576393 4779 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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