Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.03.2024 07:09
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 15709268 kB
MemAvailable 30247712 kB
Buffers 0 kB
Cached 16021372 kB
SwapCached 2476 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-03-27 07:07:51
DTS_END                         2024-03-27 07:07:51.3540
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/49698
TRN_ID                          172985
ATT_ID                          540
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: 9154.88 21286 915488
customer order: creation 172.34 428 17234
customer order: refuse 15.14 372 1514
order to supplier: creation 46.95 1255 4695
order to supplier: removal 3.16 96553 316
invoice (draft): creation 47.08 3382 4708
invoice (draft): removal 48.86 746 4886
invoice accept: apply 43.07 21248 4307
invoice accept: cancel 43.74 739 4374
customer reserve: creation 4158.24 204 415824
customer reserve: removal 4287.22 57 428722
realization accept: apply 82.92 202 8292
realization accept: cancel 76.16 128 7616
payment from customer: creation 60.03 145 6003
payment from customer: removal 5.79 71 579
payment to supplier: creation 49.62 174 4962
payment to supplier: removal 3.54 120 354
service: total inventory turnovers 4.38 3333 438
service: total monetary turnovers 5.84 592 584
service: aggregate perf. data 0.77 19744 77
service: refresh index statistics 0.03 276225 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-03-2024 07:09:28 to 27-03-2024 07:09:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6008
TEST_TIME 2 4964
TEST_TIME 3 5953
TEST_TIME 4 6106
TEST_TIME 5 5886
TEST_TIME 6 5517
TEST_TIME 7 5340
TEST_TIME 8 5469
TEST_TIME 9 5817
TEST_TIME 10 5529
TEST_TIME 11 5625
TEST_TIME 12 5823
TEST_TIME 13 5908
TEST_TIME 14 6122
TEST_TIME 15 6345
TEST_TIME 16 6826
TEST_TIME 17 7047
TEST_TIME 18 7345
TEST_TIME 19 7253
TEST_TIME 20 7506
TEST_TIME 21 7643
TEST_TIME 22 8112
TEST_TIME 23 8080
TEST_TIME 24 8903
TEST_TIME 25 8992
TEST_TIME 26 9012
TEST_TIME 27 9289
TEST_TIME 28 9629
TEST_TIME 29 9404
TEST_TIME 30 9335
TEST_TIME 31 9079
TEST_TIME 32 8933
TEST_TIME 33 9141
TEST_TIME 34 9032
TEST_TIME 35 9237
TEST_TIME 36 9149
TEST_TIME 37 9187
TEST_TIME 38 9083
TEST_TIME 39 9038
TEST_TIME 40 9092
TEST_TIME 41 9066
TEST_TIME 42 9051
TEST_TIME 43 9158
TEST_TIME 44 9255
TEST_TIME 45 9204
TEST_TIME 46 9167
TEST_TIME 47 9222
TEST_TIME 48 9403
TEST_TIME 49 9350
TEST_TIME 50 9393
TEST_TIME 51 9459
TEST_TIME 52 9472
TEST_TIME 53 9484
TEST_TIME 54 9595
TEST_TIME 55 9529
TEST_TIME 56 9399
TEST_TIME 57 9330
TEST_TIME 58 9284
TEST_TIME 59 9295
TEST_TIME 60 9274
TEST_TIME 61 9190
TEST_TIME 62 9186
TEST_TIME 63 9132
TEST_TIME 64 9102
TEST_TIME 65 9098
TEST_TIME 66 9091
TEST_TIME 67 9200
TEST_TIME 68 9186
TEST_TIME 69 9202
TEST_TIME 70 9178
TEST_TIME 71 9242
TEST_TIME 72 9282
TEST_TIME 73 9323
TEST_TIME 74 9396
TEST_TIME 75 9381
TEST_TIME 76 9321
TEST_TIME 77 9235
TEST_TIME 78 9247
TEST_TIME 79 9208
TEST_TIME 80 9145
TEST_TIME 81 9095
TEST_TIME 82 9076
TEST_TIME 83 9062
TEST_TIME 84 9075
TEST_TIME 85 9034
TEST_TIME 86 9157
TEST_TIME 87 9358
TEST_TIME 88 9323
TEST_TIME 89 9401
TEST_TIME 90 9362
TEST_TIME 91 9457
TEST_TIME 92 9435
TEST_TIME 93 9492
TEST_TIME 94 9401
TEST_TIME 95 9325
TEST_TIME 96 9315
TEST_TIME 97 9270
TEST_TIME 98 9188
TEST_TIME 99 9211
TEST_TIME 100 9161

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-03-2024 07:09:31 to 27-03-2024 07:09:35.

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 1294639 1294639 0 0.00 0 15655 7 0 0
doc_list_biud 1294633 1294633 0 0.00 0 25045 24 0 0
sp_add_invoice_to_stock 4420 4307 113 2.55 50 180277 21248 0 113
sp_cancel_adding_invoice 4374 4374 0 0.00 5 55912 739 0 0
sp_cancel_client_order 1514 1514 0 0.00 4 11711 373 0 0
sp_cancel_customer_reserve 428722 428722 0 0.00 0 25046 57 0 0
sp_cancel_pay_from_customer 579 579 0 0.00 2 2133 72 0 0
sp_cancel_pay_to_supplier 354 354 0 0.00 3 3571 121 0 0
sp_cancel_supplier_invoice 4894 4886 8 0.16 1 19900 746 0 8
sp_cancel_supplier_order 316 316 0 0.00 11 650561 96554 0 0
sp_cancel_write_off 7616 7616 0 0.00 1 10205 128 0 0
sp_client_order 17234 17234 0 0.00 3 34561 429 0 0
sp_customer_reserve 415824 415824 0 0.00 0 48345 204 0 0
sp_fill_shopping_cart 26621 26621 0 0.00 1 11574 38 0 0
sp_fill_shopping_cart_clo_res 415815 415815 0 0.00 0 16976 17 0 0
sp_get_clo_for_invoice 4295 4295 0 0.00 0 21305 399 0 0
sp_kill_cost_storno 12923 12923 0 0.00 0 5421 62 0 0
sp_kill_qstorno_ret_qs2qd 870262 870262 0 0.00 0 25043 31 0 0
sp_kill_qty_storno 460015 460015 0 0.00 0 25045 66 0 0
sp_lock_selected_doc 17445 17445 0 0.00 0 8069 5 0 0
sp_make_cost_storno 23552 23552 0 0.00 0 14621 69 0 0
sp_multiply_rows_for_pdistr 23550 23550 0 0.00 0 7425 33 0 0
sp_multiply_rows_for_qdistr 17234 17234 0 0.00 0 34528 226 0 0
sp_pay_from_customer 6003 6003 0 0.00 4 13173 145 0 0
sp_pay_to_supplier 4962 4962 0 0.00 4 16075 175 0 0
sp_payment_common 10963 10963 0 0.00 1 10107 28 0 0
sp_qd_handle_on_cancel_clo 1514 1514 0 0.00 0 10983 330 0 0
sp_qd_handle_on_invoice_upd_sts 8669 8669 0 0.00 0 22936 272 0 0
sp_qd_handle_on_reserve_upd_sts 8292 8292 0 0.00 0 12561 54 0 0
sp_reserve_write_off 8292 8292 0 0.00 6 13324 203 0 0
sp_supplier_invoice 4708 4708 0 0.00 6 86606 3383 0 0
sp_supplier_order 4695 4695 0 0.00 4 49447 1255 0 0
srv_aggregate_perf_data 77 77 0 0.00 1494 236526 19744 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1532 108907 41513 0 0
srv_find_qd_qs_mism 871388 871388 0 0.00 0 10923 7 0 0
srv_make_invnt_saldo 438 438 0 0.00 60 98074 3333 0 0
srv_make_money_saldo 584 584 0 0.00 1 20947 592 0 0
srv_recalc_idx_stat 3 3 0 0.00 126749 388207 276225 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4307 4307 0 0.00 0 12948 164 0 0
t$perf-norm:sp_cancel_adding_invoice 330 330 0 0.00 1 2967 77 0 0
t$perf-norm:sp_cancel_client_order 1514 1514 0 0.00 0 4746 13 0 0
t$perf-norm:sp_cancel_customer_reserve 562 562 0 0.00 0 1216 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 579 579 0 0.00 0 2328 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 354 354 0 0.00 0 372 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 355 355 0 0.00 0 2564 19 0 0
t$perf-norm:sp_cancel_supplier_order 316 316 0 0.00 0 18647 1629 0 0
t$perf-norm:sp_cancel_write_off 848 848 0 0.00 0 372 3 0 0
t$perf-norm:sp_client_order 17234 17234 0 0.00 0 5963 16 0 0
t$perf-norm:sp_customer_reserve 864 864 0 0.00 0 4798 20 0 0
t$perf-norm:sp_pay_from_customer 6003 6003 0 0.00 0 4399 9 0 0
t$perf-norm:sp_pay_to_supplier 4962 4962 0 0.00 0 8252 13 0 0
t$perf-norm:sp_reserve_write_off 8292 8292 0 0.00 0 6323 11 0 0
t$perf-norm:sp_supplier_invoice 4708 4708 0 0.00 0 10312 18 0 0
t$perf-norm:sp_supplier_order 4695 4695 0 0.00 0 5386 16 0 0
t$perf-norm:srv_aggregate_perf_data 77 77 0 0.00 0 410 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 4 0 0 0
t$perf-norm:srv_make_invnt_saldo 438 438 0 0.00 0 3034 16 0 0
t$perf-norm:srv_make_money_saldo 584 584 0 0.00 0 793 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 8816 8590 226 2.56 0 13090 24 0 226
v_all_customers 32060 32060 0 0.00 0 53 1 0 0
v_all_suppliers 26296 26296 0 0.00 0 70 1 0 0
v_all_wares 34464 34464 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 660 660 0 0.00 0 331 6 0 0
v_cancel_client_order 3028 3028 0 0.00 0 11333 13 0 0
v_cancel_customer_prepayment 1158 1158 0 0.00 0 365 4 0 0
v_cancel_customer_reserve 1124 1124 0 0.00 0 2847 8 0 0
v_cancel_payment_to_supplier 708 708 0 0.00 0 3558 19 0 0
v_cancel_supplier_invoice 726 710 16 2.20 0 12593 41 0 16
v_cancel_supplier_order 632 632 0 0.00 0 3236 10 0 0
v_cancel_write_off 1696 1696 0 0.00 0 1926 16 0 0
v_max_id_clo_ord 4693 4693 0 0.00 0 541 1 0 0
v_max_id_clo_res 864 864 0 0.00 0 2102 17 0 0
v_max_id_ord_sup 4696 4696 0 0.00 0 6834 7 0 0
v_max_non_paid_invoice 1203 1203 0 0.00 0 3772 5 0 0
v_max_non_paid_realizn 2895 2895 0 0.00 0 1577 3 0 0
v_min_id_clo_ord 4693 4693 0 0.00 0 1405 5 0 0
v_min_id_clo_res 864 864 0 0.00 0 4427 9 0 0
v_min_id_ord_sup 4696 4696 0 0.00 0 6881 9 0 0
v_min_non_paid_invoice 4962 4962 0 0.00 0 6148 20 0 0
v_min_non_paid_realizn 6001 6001 0 0.00 0 10103 22 0 0
v_our_firm 8616 8616 0 0.00 0 70 1 0 0
v_reserve_write_off 16584 16584 0 0.00 0 13115 14 0 0
x_lock_depdocs_on_canc_invoice 8905 8905 0 0.00 0 15052 117 0 0
x_lock_depdocs_on_canc_sup_ord 316 316 0 0.00 0 8542 392 0 0
x_make_qstorno_1000_1200 4695 4695 0 0.00 1 49106 1190 0 0
x_make_qstorno_1200_2000 4708 4708 0 0.00 3 86574 3231 0 0
x_make_qstorno_2100_3300 415824 415824 0 0.00 0 48341 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-03-2024 07:09:36 to 27-03-2024 07:09:40.

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
05:07:55 2 8192000000 8797318112 8808026112 3180608 0.038 1 1 2 0 3278224 61840 35776
05:08:56 46381 8192000000 9722491072 10024079360 792609808 8.821 100 89 178 0 821644736 7932880 21102048
05:10:46 11914 8192000000 9763609264 10073743360 838899680 9.289 100 88 176 0 872038064 12929472 20208912
05:11:59 26363 8192000000 9801952464 10121805824 861152256 9.512 100 91 182 0 905279008 23659616 20467136
05:13:31 8164 8192000000 9855149488 10184736768 890495808 9.804 100 81 160 0 960293632 52295536 17502288
05:14:50 7983 8192000000 9881473904 10223067136 927722688 10.172 100 76 151 1 995807424 52533104 15551632
05:16:01 4468 8192000000 9930360960 10286473216 972222096 10.608 100 65 128 0 1036298768 51891024 12185648
05:17:10 1699 8192000000 9977118096 10342215680 1006095408 10.938 100 76 152 0 1085744560 64445056 15204096
05:18:13 2312 8192000000 10008581872 10378928128 1031759536 11.185 100 89 176 0 1122886384 73927200 17199648
05:19:17 1817 8192000000 10036909472 10411102208 1054349920 11.402 100 91 182 1 1151960448 79446832 18163696
05:20:21 20960 8192000000 10005909952 10405318656 1057937456 11.437 100 46 93 0 1126855584 60504096 8414032
05:21:44 6093 8192000000 9978322208 10377273344 1067370976 11.527 100 40 79 0 1103745872 28097552 8277344
05:22:50 7252 8192000000 9974938976 10383196160 1067062432 11.524 100 30 59 0 1097898848 24610432 6225984
05:23:58 4469 8192000000 9987506880 10395881472 1076589488 11.615 100 26 52 0 1097336624 15193408 5553728
05:25:03 32430 8192000000 10008683184 10401165312 1083116448 11.677 100 71 144 0 1117286912 18340816 15829648
05:26:36 7485 8192000000 9987977616 10403090432 1072480928 11.576 99 26 53 0 1108055456 30014624 5559904
05:27:47 5540 8192000000 9998594224 10408136704 1079027792 11.638 100 44 88 0 1105386928 16564752 9794384
05:28:54 23175 8192000000 10012342416 10411905024 1068585488 11.539 98 51 102 1 1092790864 14004480 10200896
05:30:27 12478 8192000000 10022610512 10420973568 1074240832 11.593 99 47 94 0 1133289008 49751456 9296720
05:31:43 4593 8192000000 10023389552 10411442176 1063739568 11.492 99 65 130 1 1144430336 68076480 12614288
05:32:53 28046 8192000000 10023674880 10421600256 1049216832 11.353 97 50 100 0 1119560400 60046384 10297184
05:34:28 42752 8192000000 10083148800 10493878272 1061935904 11.475 97 50 100 0 1170366864 97073296 11357664
05:36:18 31866 8192000000 10071806720 10471960576 1021431280 11.086 94 33 67 0 1152136960 123251216 7454464
05:37:56 34498 8192000000 10065614016 10458857472 1007896032 10.955 95 31 62 0 1122112176 107676464 6539680
05:39:35 16908 8192000000 10091316544 10496593920 1062503520 11.480 99 43 84 1 1190220992 118560016 9157456
05:40:57 9575 8192000000 10154563824 10540068864 1080816000 11.655 100 65 130 0 1243979056 149642368 13520688
05:42:10 9413 8192000000 10141339760 10536681472 1049504352 11.356 98 49 96 0 1233296224 173392240 10399632
05:43:28 3459 8192000000 10161690720 10565148672 1098440320 11.823 100 79 156 0 1260413840 146022304 15951216
05:44:35 8946 8192000000 10236898816 10630643712 1109285648 11.926 100 73 145 0 1326488352 202153008 15049696
05:45:48 1532 8192000000 10217418128 10615586816 1116894752 11.998 100 69 134 1 1316334544 185845168 13594624
05:46:55 7012 8192000000 10259470480 10658955264 1126609808 12.089 100 76 150 3 1363598816 218555136 18433872
05:48:06 2704 8192000000 10247061488 10665086976 1124448928 12.069 100 61 121 1 1353052800 215576544 13027328
05:49:24 20958 8192000000 10237697440 10670505984 1122213632 12.048 100 33 63 0 1347858048 218201808 7442608
05:50:46 44536 8192000000 10130954736 10644295680 1104714464 11.882 99 10 20 0 1272742864 165503216 2525184
05:52:33 17405 8192000000 10075066096 10537902080 1115377504 11.983 100 12 24 0 1216305168 98171616 2756048
05:53:55 8739 8192000000 10133559712 10555363328 1119052320 12.018 99 24 46 1 1224506640 100193136 5261184
05:55:07 73675 8192000000 10042654608 10502139904 1110915424 11.941 99 11 22 0 1201735392 88226288 2593680
05:57:22 47214 8192000000 10088611408 10527612928 1124119296 12.066 100 35 69 0 1203516784 71943488 7454000
05:59:46 32748 8192000000 10137297664 10569482240 1129236272 12.114 100 39 78 0 1226449280 89841488 7371520
06:01:55 6903 8192000000 10141371296 10566819840 1141411520 12.229 100 77 153 0 1241677744 83544944 16721280
06:03:03 45632 8192000000 10103565264 10554847232 1143161232 12.245 100 17 35 0 1209480256 62601776 3717248
06:04:50 72689 8192000000 10126172448 10574213120 1135158112 12.170 99 13 26 0 1209080816 70974016 2948688
06:07:04 57516 8192000000 10114905280 10563239936 1149265776 12.303 100 26 49 1 1220107184 65113568 5727840
06:09:03 55586 8192000000 10109421232 10582081536 1152926176 12.337 100 15 30 0 1249747552 93414416 3406960
06:11:08 50066 8192000000 10062927280 10555719680 1123603680 12.061 98 21 42 0 1187634048 59970176 4060192
06:13:01 46715 8192000000 10098202896 10530959360 1105593376 11.891 97 40 80 0 1160444832 46825552 8025904
06:14:49 44236 8192000000 10073483872 10567524352 1106007600 11.895 98 17 34 0 1204753312 94938384 3807328
06:16:41 17653 8192000000 10075484272 10488537088 1101163392 11.849 99 71 140 0 1147803088 32522688 14117008
06:18:01 36561 8192000000 10060971360 10519695360 1095683584 11.797 99 38 76 2 1167344720 64288096 7373040
06:19:47 33859 8192000000 10073515488 10498744320 1090936592 11.752 98 28 56 0 1144328368 47986112 5405664
06:21:22 43026 8192000000 10038288976 10507743232 1041764128 11.282 94 33 66 0 1118057232 70043504 6249600
06:23:06 92026 8192000000 9998991952 10445148160 1052901872 11.388 97 27 54 1 1095937392 37528336 5507184
06:25:47 16332 8192000000 10022293472 10461298688 1081045872 11.657 99 35 70 0 1132918224 44844800 7027552
06:27:10 39656 8192000000 10020882752 10483994624 1063290640 11.488 97 12 23 0 1125105824 59606464 2208720
06:28:50 59078 8192000000 10040411856 10486444032 1083637776 11.682 99 32 64 0 1142590976 51616784 7336416
06:31:13 80452 8192000000 10066007712 10555006976 1083572800 11.682 99 18 36 0 1136489584 49030320 3886464
06:34:31 62408 8192000000 10026804544 10485075968 1071700640 11.568 98 15 28 0 1162625728 88064128 2860960
06:36:34 38522 8192000000 10026794560 10438660096 1050215968 11.363 96 36 72 0 1086868064 29811696 6840400
06:38:14 31070 8192000000 10057324736 10489278464 1086711664 11.711 99 35 70 0 1148181600 54909456 6560480
06:39:47 68918 8192000000 10043550544 10492588032 1095698400 11.797 99 14 28 0 1165413664 67061984 2653280
06:41:56 78954 8192000000 10054770496 10481299456 1115464576 11.984 100 26 50 1 1184045744 63513888 5067280
06:44:17 78789 8192000000 10069480608 10513489920 1109967952 11.932 99 41 82 1 1200302128 81854144 8480032
06:46:40 72596 8192000000 10046412320 10502488064 1120452544 12.031 100 6 12 0 1158523872 36882784 1188544
06:48:53 71803 8192000000 10111302624 10548342784 1125024816 12.074 99 20 41 0 1186337440 56818560 4494064
06:51:05 49325 8192000000 10191448048 10630234112 1150537424 12.315 100 28 55 2 1284272944 127973376 5762144
06:53:06 62751 8192000000 10173132624 10748731392 1140085408 12.216 99 30 58 0 1354288464 207170096 7032960
06:55:16 103325 8192000000 10073243360 10569228288 1135123280 12.170 99 14 28 0 1188494976 50609952 2761744
06:58:04 35367 8192000000 10090299872 10554740736 1095262672 11.793 96 41 82 0 1179848064 76587168 7998224
06:59:44 108907 8192000000 10027765728 10519465984 1045138768 11.314 94 12 24 0 1083036352 35859408 2038176
07:02:35 33069 8192000000 10024435952 10438475776 1070949920 11.561 97 39 79 1 1096604240 17966240 7688080
07:04:12 85329 8192000000 10069942944 10517385216 1104054640 11.876 99 13 27 0 1167346192 60453840 2837712
07:07:02 57756 8192000000 9248913264 9565966336 382013600 4.455 35 6 10 1 431306576 47862704 1430272

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 27-03-2024 07:09:42 to 27-03-2024 07:09:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-03-2024 07:09:57 to 27-03-2024 07:09:59.

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          173311
MON$OLDEST_ACTIVE               173312
MON$OLDEST_SNAPSHOT             173312
MON$NEXT_TRANSACTION            173312
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                       1913504
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             695
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3082 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3082 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3082 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3082 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 Wed Mar 27 07:10:00 2024 
 
Database header page information: 
    Flags            0 
    Generation        90427 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    173311 
    Oldest active        173312 
    Oldest snapshot        173312 
    Next transaction    173313 
    Sequence number        0 
    Next attachment ID    695 
    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.70, total records: 7734036 
    Average version length: 48.16, total versions: 38216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89032 
    Data pages: 89032, average fill: 69% 
    Primary pages: 89031, secondary pages: 1, swept pages: 47484 
    Empty pages: 0, full pages: 63979 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 31 
    40 - 59% = 1929 
    60 - 79% = 87053 
    80 - 99% = 16 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23311, nodes: 7734036 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1677725, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 325 
        20 - 39% = 2010 
        40 - 59% = 3983 
        60 - 79% = 2446 
        80 - 99% = 14547 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13505, nodes: 7734036 
    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: 1502380, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1703 
        40 - 59% = 1854 
        60 - 79% = 1168 
        80 - 99% = 8780 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8342, nodes: 7734036 
    Average node length: 6.62, total dup: 5783073, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1495377, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 1049 
        40 - 59% = 1272 
        60 - 79% = 982 
        80 - 99% = 4913 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.99, total records: 2242480 
    Average version length: 58.85, total versions: 21198, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28912 
    Data pages: 28912, average fill: 71% 
    Primary pages: 28911, secondary pages: 1, swept pages: 14359 
    Empty pages: 5, full pages: 16843 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 20 
    40 - 59% = 626 
    60 - 79% = 28224 
    80 - 99% = 36 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4573, nodes: 2242480 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688779, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 967 
        40 - 59% = 800 
        60 - 79% = 754 
        80 - 99% = 2052 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2430, nodes: 2243323 
    Average node length: 4.97, total dup: 2242424, max dup: 19066 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259040, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 213 
        40 - 59% = 1408 
        60 - 79% = 564 
        80 - 99% = 243 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1796, nodes: 2242480 
    Average node length: 4.97, total dup: 2242430, max dup: 130188 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1071118, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 640 
        60 - 79% = 51 
        80 - 99% = 1101 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4372, nodes: 2242480 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 688779, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 92 
        20 - 39% = 647 
        40 - 59% = 600 
        60 - 79% = 855 
        80 - 99% = 2178 
 
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.30, total records: 400 
    Average version length: 29.38, total versions: 1931, max versions: 5 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 67% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 0, full pages: 14 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 4 
    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: 14.14, total records: 88271 
    Average version length: 68.28, total versions: 80621, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.23 
    Pointer pages: 6, data page slots: 3176 
    Data pages: 1632, average fill: 73% 
    Primary pages: 1631, secondary pages: 1, swept pages: 34 
    Empty pages: 100, full pages: 1122 
    Fill distribution: 
     0 - 19% = 157 
    20 - 39% = 138 
    40 - 59% = 164 
    60 - 79% = 142 
    80 - 99% = 1031 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1714366, depth: 3, leaf buckets: 285, nodes: 88271 
    Average node length: 13.56, total dup: 5195, max dup: 2 
    Average key length: 10.75, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 65131, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 59 
        40 - 59% = 139 
        60 - 79% = 75 
        80 - 99% = 10 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 206, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 85% 
    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: 10.08, total records: 1481 
    Average version length: 43.51, total versions: 1434, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.75 
    Pointer pages: 1, data page slots: 56 
    Data pages: 40, average fill: 40% 
    Primary pages: 39, secondary pages: 1, swept pages: 4 
    Empty pages: 15, full pages: 15 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92276, depth: 2, leaf buckets: 3, nodes: 1481 
    Average node length: 4.25, total dup: 1384, max dup: 178 
    Average key length: 2.71, compression ratio: 7.01 
    Average prefix length: 18.35, average data length: 0.65 
    Clustering factor: 817, 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.53, 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.55, total records: 794923 
    Average version length: 37.94, total versions: 25055, 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: 8472 
    Data pages: 8472, average fill: 64% 
    Primary pages: 8470, secondary pages: 2, swept pages: 2611 
    Empty pages: 25, full pages: 5479 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 86 
    40 - 59% = 767 
    60 - 79% = 7497 
    80 - 99% = 62 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 852, nodes: 783346 
    Average node length: 4.88, total dup: 783297, max dup: 140102 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89816, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 120 
        40 - 59% = 480 
        60 - 79% = 159 
        80 - 99% = 92 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 887, nodes: 783346 
    Average node length: 5.89, total dup: 697159, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157943, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 442 
        60 - 79% = 133 
        80 - 99% = 289 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 930, nodes: 783346 
    Average node length: 5.89, total dup: 697159, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159706, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 90 
        40 - 59% = 446 
        60 - 79% = 121 
        80 - 99% = 272 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1111, nodes: 783346 
    Average node length: 5.97, total dup: 697159, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152777, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 227 
        40 - 59% = 593 
        60 - 79% = 205 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.79, total records: 5437 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.43, total fragments: 14, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 81, secondary pages: 7, swept pages: 55 
    Empty pages: 8, full pages: 60 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5437 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.39, average data length: 1.55 
    Clustering factor: 5054, ratio: 0.93 
    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: 5437 
    Average node length: 11.12, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 153, 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.06, total records: 78599 
    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: 824 
    Data pages: 824, average fill: 65% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 816 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 816 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38963, depth: 2, leaf buckets: 102, nodes: 78599 
    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: 3485, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 98 
 
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.07, 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.22 
    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: 148.80, total records: 168670 
    Average version length: 151.62, total versions: 2638, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 5, data page slots: 4824 
    Data pages: 4208, average fill: 83% 
    Primary pages: 4206, secondary pages: 2, swept pages: 5 
    Empty pages: 58, full pages: 4135 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4135 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.63, total records: 165426 
    Average version length: 150.90, total versions: 1764, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 4512 
    Data pages: 4096, average fill: 83% 
    Primary pages: 4094, secondary pages: 2, swept pages: 5 
    Empty pages: 27, full pages: 4057 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4057 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.73, total records: 155198 
    Average version length: 138.96, total versions: 294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 6, data page slots: 4304 
    Data pages: 3840, average fill: 83% 
    Primary pages: 3838, secondary pages: 2, swept pages: 6 
    Empty pages: 27, full pages: 3803 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3803 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.71, total records: 137713 
    Average version length: 152.15, total versions: 2666, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 8, data page slots: 4768 
    Data pages: 3448, average fill: 82% 
    Primary pages: 3446, secondary pages: 2, swept pages: 2 
    Empty pages: 65, full pages: 3362 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3361 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.10, total records: 149524 
    Average version length: 147.76, total versions: 701, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 3800 
    Data pages: 3680, average fill: 84% 
    Primary pages: 3678, secondary pages: 2, swept pages: 3 
    Empty pages: 12, full pages: 3660 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3660 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 148.75, total records: 164072 
    Average version length: 152.36, total versions: 2440, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 9, data page slots: 4112 
    Data pages: 4056, average fill: 83% 
    Primary pages: 4053, secondary pages: 3, swept pages: 13 
    Empty pages: 24, full pages: 4018 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4018 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 130.01, total records: 195637 
    Average version length: 154.78, total versions: 29135, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.05 
    Pointer pages: 7, data page slots: 6168 
    Data pages: 4912, average fill: 84% 
    Primary pages: 4910, secondary pages: 2, swept pages: 3 
    Empty pages: 83, full pages: 4805 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4807 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 138.17, total records: 187806 
    Average version length: 154.69, total versions: 17230, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.27 
    Pointer pages: 7, data page slots: 6088 
    Data pages: 4720, average fill: 83% 
    Primary pages: 4718, secondary pages: 2, swept pages: 1 
    Empty pages: 84, full pages: 4608 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 4608 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 148.78, total records: 182908 
    Average version length: 151.76, total versions: 3065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 5456 
    Data pages: 4536, average fill: 83% 
    Primary pages: 4535, secondary pages: 1, swept pages: 1 
    Empty pages: 42, full pages: 4481 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4481 
 
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: 173883 
    Average version length: 153.86, total versions: 6401, 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: 6, data page slots: 5120 
    Data pages: 4336, average fill: 83% 
    Primary pages: 4333, secondary pages: 3, swept pages: 7 
    Empty pages: 53, full pages: 4265 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4264 
 
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.41, total records: 2087564 
    Average version length: 52.95, total versions: 16218, 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: 25776 
    Data pages: 25768, average fill: 70% 
    Primary pages: 25751, secondary pages: 17, swept pages: 12451 
    Empty pages: 152, full pages: 21432 
    Fill distribution: 
     0 - 19% = 338 
    20 - 39% = 312 
    40 - 59% = 1074 
    60 - 79% = 23899 
    80 - 99% = 145 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2569, nodes: 2087564 
    Average node length: 5.44, total dup: 1947472, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181608, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 309 
        40 - 59% = 1652 
        60 - 79% = 314 
        80 - 99% = 291 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2764, nodes: 2087564 
    Average node length: 5.69, total dup: 1873356, max dup: 67 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373701, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2454 
        60 - 79% = 278 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2112, nodes: 2087564 
    Average node length: 4.96, total dup: 2087464, max dup: 26801 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179482, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 214 
        40 - 59% = 1087 
        60 - 79% = 375 
        80 - 99% = 436 
 
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: 1 
    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: 45.20, total records: 123498 
    Average version length: 69.17, total versions: 49260, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.79 
    Pointer pages: 3, data page slots: 3672 
    Data pages: 2904, average fill: 52% 
    Primary pages: 2904, secondary pages: 0, swept pages: 347 
    Empty pages: 250, full pages: 1001 
    Fill distribution: 
     0 - 19% = 498 
    20 - 39% = 518 
    40 - 59% = 580 
    60 - 79% = 722 
    80 - 99% = 586 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 312275, depth: 3, leaf buckets: 226, nodes: 123498 
    Average node length: 6.43, total dup: 107423, max dup: 14 
    Average key length: 3.99, compression ratio: 10.54 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 21333, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 93 
        40 - 59% = 109 
        60 - 79% = 24 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.53, total records: 6803251 
    Average version length: 68.74, total versions: 276047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 64, data page slots: 103296 
    Data pages: 103296, average fill: 71% 
    Primary pages: 103295, secondary pages: 1, swept pages: 30798 
    Empty pages: 2, full pages: 55276 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 363 
    40 - 59% = 7684 
    60 - 79% = 94571 
    80 - 99% = 667 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10613, nodes: 6803251 
    Average node length: 6.52, total dup: 5880969, max dup: 29 
    Average key length: 3.53, compression ratio: 11.90 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1619699, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1938 
        40 - 59% = 5937 
        60 - 79% = 2303 
        80 - 99% = 424 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8280, nodes: 6803251 
    Average node length: 5.40, total dup: 6527228, max dup: 138 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1438689, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1265 
        40 - 59% = 4551 
        60 - 79% = 1472 
        80 - 99% = 990 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8321, nodes: 6803251 
    Average node length: 5.40, total dup: 6527228, max dup: 138 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1440912, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1287 
        40 - 59% = 4543 
        60 - 79% = 1530 
        80 - 99% = 955 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.88, total records: 11870551 
    Average version length: 68.73, total versions: 211995, 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: 107, data page slots: 173872 
    Data pages: 173872, average fill: 73% 
    Primary pages: 173871, secondary pages: 1, swept pages: 81966 
    Empty pages: 3, full pages: 133017 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 578 
    40 - 59% = 6347 
    60 - 79% = 165937 
    80 - 99% = 969 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18306, nodes: 11869635 
    Average node length: 6.61, total dup: 10344248, max dup: 55 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2450119, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 2515 
        40 - 59% = 10655 
        60 - 79% = 4282 
        80 - 99% = 817 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.85, total records: 1238780 
    Average version length: 69.09, total versions: 210487, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.30 
    Pointer pages: 25, data page slots: 39168 
    Data pages: 26608, average fill: 50% 
    Primary pages: 26556, secondary pages: 52, swept pages: 10872 
    Empty pages: 4122, full pages: 13379 
    Fill distribution: 
     0 - 19% = 6557 
    20 - 39% = 3193 
    40 - 59% = 2692 
    60 - 79% = 11570 
    80 - 99% = 2596 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1710, nodes: 1154772 
    Average node length: 5.53, total dup: 1107892, max dup: 49 
    Average key length: 2.58, compression ratio: 16.28 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 81523, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 591 
        40 - 59% = 811 
        60 - 79% = 270 
        80 - 99% = 30 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 48.12, total records: 933195 
    Average version length: 69.04, total versions: 113670, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.62 
    Pointer pages: 20, data page slots: 31384 
    Data pages: 25400, average fill: 36% 
    Primary pages: 25399, secondary pages: 1, swept pages: 6986 
    Empty pages: 3288, full pages: 6445 
    Fill distribution: 
     0 - 19% = 7400 
    20 - 39% = 6393 
    40 - 59% = 6797 
    60 - 79% = 4723 
    80 - 99% = 87 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1146, nodes: 721960 
    Average node length: 5.93, total dup: 665912, max dup: 57 
    Average key length: 3.00, compression ratio: 13.99 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 100372, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 424 
        40 - 59% = 521 
        60 - 79% = 184 
        80 - 99% = 17 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.51, total records: 9133127 
    Average version length: 68.96, total versions: 208454, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 89, data page slots: 143800 
    Data pages: 143784, average fill: 68% 
    Primary pages: 143768, secondary pages: 16, swept pages: 68455 
    Empty pages: 248, full pages: 65944 
    Fill distribution: 
     0 - 19% = 741 
    20 - 39% = 3323 
    40 - 59% = 21079 
    60 - 79% = 117882 
    80 - 99% = 759 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13474, nodes: 9130629 
    Average node length: 6.68, total dup: 7574733, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2071842, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1390 
        40 - 59% = 6902 
        60 - 79% = 4578 
        80 - 99% = 603 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21128204 
    Average version length: 82.94, total versions: 4144, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319504 
    Data pages: 319504, average fill: 81% 
    Primary pages: 319503, secondary pages: 1, swept pages: 13500 
    Empty pages: 26, full pages: 318526 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 29 
    40 - 59% = 109 
    60 - 79% = 49022 
    80 - 99% = 270289 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19039, nodes: 21128204 
    Average node length: 5.72, total dup: 20647675, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279351, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 7453 
        60 - 79% = 579 
        80 - 99% = 10998 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17140, nodes: 21128204 
    Average node length: 6.31, total dup: 18567091, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916270, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 764 
        60 - 79% = 245 
        80 - 99% = 16124 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20821, nodes: 21128204 
    Average node length: 6.35, total dup: 18486218, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573436, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 7768 
        60 - 79% = 571 
        80 - 99% = 12475 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16170, nodes: 21128204 
    Average node length: 5.56, total dup: 21128104, max dup: 228741 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945205, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 3075 
        60 - 79% = 347 
        80 - 99% = 12740 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.94, total records: 9569461 
    Average version length: 82.57, total versions: 192996, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 105, data page slots: 170104 
    Data pages: 170064, average fill: 69% 
    Primary pages: 170035, secondary pages: 29, swept pages: 90442 
    Empty pages: 555, full pages: 89709 
    Fill distribution: 
     0 - 19% = 1643 
    20 - 39% = 5597 
    40 - 59% = 22582 
    60 - 79% = 124331 
    80 - 99% = 15911 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11367, nodes: 9569461 
    Average node length: 5.37, total dup: 9260491, max dup: 159 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2217349, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 67 
        40 - 59% = 8564 
        60 - 79% = 2650 
        80 - 99% = 82 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13485, nodes: 9569461 
    Average node length: 6.23, total dup: 7934268, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1573722, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 4076 
        40 - 59% = 4288 
        60 - 79% = 2658 
        80 - 99% = 2327 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12686, nodes: 9569461 
    Average node length: 5.99, total dup: 8296121, max dup: 38 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2396391, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 91 
        40 - 59% = 9567 
        60 - 79% = 2911 
        80 - 99% = 115 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10083, nodes: 9569461 
    Average node length: 5.14, total dup: 9569361, max dup: 149200 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1589746, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1329 
        40 - 59% = 4946 
        60 - 79% = 1692 
        80 - 99% = 2063 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.42, total records: 11179274 
    Average version length: 82.45, total versions: 134375, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 119, data page slots: 192672 
    Data pages: 191144, average fill: 72% 
    Primary pages: 191007, secondary pages: 137, swept pages: 74393 
    Empty pages: 2338, full pages: 142466 
    Fill distribution: 
     0 - 19% = 4450 
    20 - 39% = 7511 
    40 - 59% = 18136 
    60 - 79% = 101658 
    80 - 99% = 59389 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13120, nodes: 11179274 
    Average node length: 5.32, total dup: 11069215, max dup: 651 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2339917, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 168 
        40 - 59% = 9316 
        60 - 79% = 3472 
        80 - 99% = 163 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10383, nodes: 11179274 
    Average node length: 5.51, total dup: 10690755, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 717643, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 898 
        40 - 59% = 2499 
        60 - 79% = 1828 
        80 - 99% = 4987 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15002, nodes: 11179274 
    Average node length: 6.04, total dup: 9748603, max dup: 61 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2356124, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 206 
        40 - 59% = 10756 
        60 - 79% = 3844 
        80 - 99% = 194 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10739, nodes: 11179274 
    Average node length: 5.24, total dup: 11179174, max dup: 187834 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 705928, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 911 
        40 - 59% = 4683 
        60 - 79% = 1520 
        80 - 99% = 3513 
 
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: 81.28, total records: 9684899 
    Average version length: 82.90, total versions: 192575, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 107, data page slots: 173936 
    Data pages: 173888, average fill: 69% 
    Primary pages: 173862, secondary pages: 26, swept pages: 97157 
    Empty pages: 554, full pages: 90024 
    Fill distribution: 
     0 - 19% = 1816 
    20 - 39% = 6804 
    40 - 59% = 24504 
    60 - 79% = 125409 
    80 - 99% = 15355 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11787, nodes: 9684899 
    Average node length: 5.17, total dup: 9656341, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1999224, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1580 
        40 - 59% = 7825 
        60 - 79% = 1757 
        80 - 99% = 592 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13576, nodes: 9684899 
    Average node length: 6.24, total dup: 8029574, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1539357, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 177 
        20 - 39% = 4062 
        40 - 59% = 4158 
        60 - 79% = 2728 
        80 - 99% = 2451 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12410, nodes: 9684899 
    Average node length: 5.43, total dup: 9248677, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2131230, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1509 
        40 - 59% = 8641 
        60 - 79% = 1679 
        80 - 99% = 551 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10278, nodes: 9684899 
    Average node length: 5.14, total dup: 9684799, max dup: 150906 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1601514, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1341 
        40 - 59% = 5159 
        60 - 79% = 1797 
        80 - 99% = 1949 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.93, total records: 572454 
    Average version length: 68.82, total versions: 2305, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8024 
    Data pages: 8024, average fill: 75% 
    Primary pages: 8024, secondary pages: 0, swept pages: 3933 
    Empty pages: 4, full pages: 6866 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 3 
    40 - 59% = 114 
    60 - 79% = 7867 
    80 - 99% = 36 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41442, depth: 3, leaf buckets: 723, nodes: 572454 
    Average node length: 5.95, total dup: 487350, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100939, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 508 
        60 - 79% = 91 
        80 - 99% = 101 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30144, depth: 3, leaf buckets: 756, nodes: 572454 
    Average node length: 6.15, total dup: 469508, max dup: 15 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100992, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 37 
        40 - 59% = 531 
        60 - 79% = 87 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 575, nodes: 572454 
    Average node length: 4.86, total dup: 572354, max dup: 10004 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89798, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 340 
        60 - 79% = 85 
        80 - 99% = 113 
 
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 Wed Mar 27 07:10:24 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7734036 38216 1 0.0000 0.0000
DOC_LIST 2242480 21198 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1931 5 400.0000 0.0000
INVNT_TURNOVER_LOG 88271 80621 1 0.0000 0.0000
MONEY_SALDO 49 206 6 400.0000 0.0000
MONEY_TURNOVER_LOG 1481 1434 1 0.0000 0.0000
PDISTR 794923 25055 2 0.0000 0.0000
PERF_SPLIT_0 168670 2638 1 0.0000 0.0000
PERF_SPLIT_1 165426 1764 1 0.0000 0.0000
PERF_SPLIT_2 155198 294 1 0.0000 0.0000
PERF_SPLIT_3 137713 2666 1 0.0000 0.0000
PERF_SPLIT_4 149524 701 1 0.0000 0.0000
PERF_SPLIT_5 164072 2440 1 0.0000 0.0000
PERF_SPLIT_6 195637 29135 1 0.0000 0.0000
PERF_SPLIT_7 187806 17230 1 0.0000 0.0000
PERF_SPLIT_8 182908 3065 1 0.0000 0.0000
PERF_SPLIT_9 173883 6401 1 0.0000 0.0000
PSTORNED 2087564 16218 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 123498 49260 1 0.0000 0.0000
XQD_1000_3300 6803251 276047 1 0.0000 0.0000
XQD_1200_2000 11870551 211995 1 0.0000 0.0000
XQD_2000_3300 1238780 210487 1 0.0000 0.0000
XQD_2100_3300 933195 113670 1 0.0000 0.0000
XQD_3300_3400 9133127 208454 1 0.0000 0.0000
XQS_1000_1200 21128204 4144 1 0.0000 0.0000
XQS_1000_3300 9569461 192996 1 0.0000 0.0000
XQS_1200_2000 11179274 134375 1 0.0000 0.0000
XQS_2100_3300 9684899 192575 1 0.0000 0.0000
XQS_3300_3400 572454 2305 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'  

27.03.24 07:10:36. 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-03-27 07:10:38 No severe PSQL-related problems occured
27.03.24 07:10:40. End of report.