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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15664888 kB
MemAvailable 30219972 kB
Buffers 0 kB
Cached 16059196 kB
SwapCached 2448 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-29 07:07:50
DTS_END                         2024-03-29 07:07:50.5940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/49090
TRN_ID                          166778
ATT_ID                          473
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: 9113.53 18170 911353
customer order: creation 170.37 418 17037
customer order: refuse 14.14 429 1414
order to supplier: creation 44.95 1303 4495
order to supplier: removal 3.45 100305 345
invoice (draft): creation 46.67 2981 4667
invoice (draft): removal 50.24 741 5024
invoice accept: apply 40.64 21162 4064
invoice accept: cancel 45.25 745 4525
customer reserve: creation 3925.34 200 392534
customer reserve: removal 4472.16 62 447216
realization accept: apply 83.47 212 8347
realization accept: cancel 86.95 120 8695
payment from customer: creation 59.75 130 5975
payment from customer: removal 5.65 81 565
payment to supplier: creation 49.39 143 4939
payment to supplier: removal 3.40 102 340
service: total inventory turnovers 4.11 3607 411
service: total monetary turnovers 6.57 455 657
service: aggregate perf. data 1.00 14337 100
service: refresh index statistics 0.03 215876 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-03-2024 07:09:14 to 29-03-2024 07:09:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2362
TEST_TIME 2 2885
TEST_TIME 3 2184
TEST_TIME 4 3340
TEST_TIME 5 3540
TEST_TIME 6 4147
TEST_TIME 7 4408
TEST_TIME 8 4761
TEST_TIME 9 4703
TEST_TIME 10 5136
TEST_TIME 11 5354
TEST_TIME 12 5489
TEST_TIME 13 5998
TEST_TIME 14 6355
TEST_TIME 15 6370
TEST_TIME 16 6977
TEST_TIME 17 7059
TEST_TIME 18 7630
TEST_TIME 19 7770
TEST_TIME 20 7985
TEST_TIME 21 8227
TEST_TIME 22 8771
TEST_TIME 23 9738
TEST_TIME 24 10274
TEST_TIME 25 10138
TEST_TIME 26 9840
TEST_TIME 27 9732
TEST_TIME 28 9866
TEST_TIME 29 9806
TEST_TIME 30 9573
TEST_TIME 31 9291
TEST_TIME 32 9547
TEST_TIME 33 9388
TEST_TIME 34 9469
TEST_TIME 35 9464
TEST_TIME 36 9334
TEST_TIME 37 9381
TEST_TIME 38 9430
TEST_TIME 39 9295
TEST_TIME 40 9218
TEST_TIME 41 9188
TEST_TIME 42 9298
TEST_TIME 43 9275
TEST_TIME 44 9325
TEST_TIME 45 9308
TEST_TIME 46 9364
TEST_TIME 47 9446
TEST_TIME 48 9478
TEST_TIME 49 9487
TEST_TIME 50 9526
TEST_TIME 51 9621
TEST_TIME 52 9630
TEST_TIME 53 9673
TEST_TIME 54 9585
TEST_TIME 55 9438
TEST_TIME 56 9468
TEST_TIME 57 9427
TEST_TIME 58 9369
TEST_TIME 59 9322
TEST_TIME 60 9277
TEST_TIME 61 9187
TEST_TIME 62 9201
TEST_TIME 63 9268
TEST_TIME 64 9195
TEST_TIME 65 9209
TEST_TIME 66 9297
TEST_TIME 67 9274
TEST_TIME 68 9240
TEST_TIME 69 9358
TEST_TIME 70 9418
TEST_TIME 71 9407
TEST_TIME 72 9400
TEST_TIME 73 9447
TEST_TIME 74 9527
TEST_TIME 75 9410
TEST_TIME 76 9325
TEST_TIME 77 9309
TEST_TIME 78 9288
TEST_TIME 79 9225
TEST_TIME 80 9213
TEST_TIME 81 9150
TEST_TIME 82 9221
TEST_TIME 83 9206
TEST_TIME 84 9226
TEST_TIME 85 9207
TEST_TIME 86 9239
TEST_TIME 87 9227
TEST_TIME 88 9279
TEST_TIME 89 9256
TEST_TIME 90 9347
TEST_TIME 91 9384
TEST_TIME 92 9412
TEST_TIME 93 9426
TEST_TIME 94 9333
TEST_TIME 95 9257
TEST_TIME 96 9245
TEST_TIME 97 9214
TEST_TIME 98 9164
TEST_TIME 99 9160
TEST_TIME 100 9119

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-03-2024 07:09:18 to 29-03-2024 07:09:21.

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 1270890 1270890 0 0.00 0 19603 8 0 0
doc_list_biud 1270888 1270888 0 0.00 0 50270 27 0 0
sp_add_invoice_to_stock 4194 4064 130 3.09 43 196918 21163 0 130
sp_cancel_adding_invoice 4525 4525 0 0.00 4 60277 746 0 0
sp_cancel_client_order 1414 1414 0 0.00 4 18071 430 0 0
sp_cancel_customer_reserve 447216 447216 0 0.00 0 50272 62 0 0
sp_cancel_pay_from_customer 565 565 0 0.00 2 5593 82 0 0
sp_cancel_pay_to_supplier 340 340 0 0.00 2 4960 102 0 0
sp_cancel_supplier_invoice 5029 5024 5 0.09 1 16312 742 0 5
sp_cancel_supplier_order 345 345 0 0.00 10 932336 100305 0 0
sp_cancel_write_off 8695 8695 0 0.00 1 17508 120 0 0
sp_client_order 17037 17037 0 0.00 3 38636 419 0 0
sp_customer_reserve 392534 392534 0 0.00 0 81234 201 0 0
sp_fill_shopping_cart 26194 26194 0 0.00 1 23719 37 0 0
sp_fill_shopping_cart_clo_res 392532 392532 0 0.00 0 31102 20 0 0
sp_get_clo_for_invoice 4059 4059 0 0.00 0 54036 454 0 0
sp_kill_cost_storno 14125 14125 0 0.00 0 12006 69 0 0
sp_kill_qstorno_ret_qs2qd 908496 908496 0 0.00 0 44529 33 0 0
sp_kill_qty_storno 479622 479622 0 0.00 0 50270 71 0 0
sp_lock_selected_doc 17125 17125 0 0.00 0 9466 6 0 0
sp_make_cost_storno 23319 23319 0 0.00 0 18873 69 0 0
sp_multiply_rows_for_pdistr 23319 23319 0 0.00 0 11355 37 0 0
sp_multiply_rows_for_qdistr 17037 17037 0 0.00 0 38628 225 0 0
sp_pay_from_customer 5975 5975 0 0.00 3 13028 131 0 0
sp_pay_to_supplier 4939 4939 0 0.00 4 18987 143 0 0
sp_payment_common 10914 10914 0 0.00 1 11478 28 0 0
sp_qd_handle_on_cancel_clo 1414 1414 0 0.00 0 18063 402 0 0
sp_qd_handle_on_invoice_upd_sts 8583 8583 0 0.00 0 36270 301 0 0
sp_qd_handle_on_reserve_upd_sts 8345 8345 0 0.00 0 16516 65 0 0
sp_reserve_write_off 8347 8347 0 0.00 7 17706 212 0 0
sp_supplier_invoice 4667 4667 0 0.00 6 89604 2981 0 0
sp_supplier_order 4495 4495 0 0.00 5 44377 1304 0 0
srv_aggregate_perf_data 100 100 0 0.00 1456 269272 14338 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 740 160037 42066 0 0
srv_find_qd_qs_mism 869348 869348 0 0.00 0 19527 7 0 0
srv_make_invnt_saldo 411 411 0 0.00 31 96012 3607 0 0
srv_make_money_saldo 657 657 0 0.00 1 10499 456 0 0
srv_recalc_idx_stat 3 3 0 0.00 180569 243000 215876 0 0
t$perf-abend:sp_add_invoice_to_stock 130 130 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4064 4064 0 0.00 0 11065 154 0 0
t$perf-norm:sp_cancel_adding_invoice 325 325 0 0.00 0 4077 81 0 0
t$perf-norm:sp_cancel_client_order 1414 1414 0 0.00 0 4798 15 0 0
t$perf-norm:sp_cancel_customer_reserve 554 554 0 0.00 0 437 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 565 565 0 0.00 0 1053 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 340 340 0 0.00 0 5785 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 322 322 0 0.00 0 1039 19 0 0
t$perf-norm:sp_cancel_supplier_order 345 345 0 0.00 0 25582 1743 0 0
t$perf-norm:sp_cancel_write_off 859 859 0 0.00 0 3143 11 0 0
t$perf-norm:sp_client_order 17037 17037 0 0.00 0 11360 14 0 0
t$perf-norm:sp_customer_reserve 814 814 0 0.00 0 2639 10 0 0
t$perf-norm:sp_pay_from_customer 5975 5975 0 0.00 0 18664 10 0 0
t$perf-norm:sp_pay_to_supplier 4939 4939 0 0.00 0 6710 9 0 0
t$perf-norm:sp_reserve_write_off 8347 8347 0 0.00 0 6738 9 0 0
t$perf-norm:sp_supplier_invoice 4667 4667 0 0.00 0 2181 12 0 0
t$perf-norm:sp_supplier_order 4495 4495 0 0.00 0 8690 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 99 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 9 0 0 0
t$perf-norm:srv_make_invnt_saldo 411 411 0 0.00 0 935 8 0 0
t$perf-norm:srv_make_money_saldo 657 657 0 0.00 0 1799 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 2 2 0 0
v_add_invoice_to_stock 8376 8116 260 3.10 0 7281 17 0 260
v_all_customers 31902 31902 0 0.00 0 20 1 0 0
v_all_suppliers 26314 26314 0 0.00 0 110 1 0 0
v_all_wares 34070 34070 0 0.00 0 132 1 0 0
v_cancel_adding_invoice 650 650 0 0.00 0 274 6 0 0
v_cancel_client_order 2828 2828 0 0.00 0 6556 6 0 0
v_cancel_customer_prepayment 1130 1130 0 0.00 0 4797 7 0 0
v_cancel_customer_reserve 1108 1108 0 0.00 0 288 3 0 0
v_cancel_payment_to_supplier 680 680 0 0.00 0 4828 13 0 0
v_cancel_supplier_invoice 654 644 10 1.52 0 1541 17 0 10
v_cancel_supplier_order 690 690 0 0.00 0 3256 18 0 0
v_cancel_write_off 1718 1718 0 0.00 0 2243 16 0 0
v_max_id_clo_ord 4494 4494 0 0.00 0 316 1 0 0
v_max_id_clo_res 814 814 0 0.00 0 3218 14 0 0
v_max_id_ord_sup 4665 4665 0 0.00 0 5249 4 0 0
v_max_non_paid_invoice 941 941 0 0.00 0 243 2 0 0
v_max_non_paid_realizn 2783 2783 0 0.00 0 7070 6 0 0
v_min_id_clo_ord 4494 4494 0 0.00 0 23695 15 0 0
v_min_id_clo_res 814 814 0 0.00 0 1525 9 0 0
v_min_id_ord_sup 4665 4665 0 0.00 0 6175 9 0 0
v_min_non_paid_invoice 4939 4939 0 0.00 0 5396 16 0 0
v_min_non_paid_realizn 5975 5975 0 0.00 0 11190 22 0 0
v_our_firm 8552 8552 0 0.00 0 65 1 0 0
v_reserve_write_off 16686 16686 0 0.00 0 6091 7 0 0
x_lock_depdocs_on_canc_invoice 9227 9227 0 0.00 0 14893 109 0 0
x_lock_depdocs_on_canc_sup_ord 345 345 0 0.00 0 9061 369 0 0
x_make_qstorno_1000_1200 4495 4495 0 0.00 2 44371 1231 0 0
x_make_qstorno_1200_2000 4667 4667 0 0.00 3 89594 2845 0 0
x_make_qstorno_2100_3300 392534 392534 0 0.00 0 81230 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-03-2024 07:09:22 to 29-03-2024 07:09:26.

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:54 16 8192000000 8805496688 8819302400 7477456 0.091 4 1 2 0 7580432 67200 35776
05:08:54 28328 8192000000 9704949824 10003632128 785136624 8.745 100 89 179 0 815331296 7879360 22315312
05:10:33 16604 8192000000 9750751952 10057334784 824744176 9.146 100 92 184 0 858636272 12297280 21594816
05:11:58 14901 8192000000 9783127152 10098716672 844951296 9.349 100 83 165 0 884838784 20964976 18922512
05:13:20 8651 8192000000 9833749680 10164404224 898713424 9.886 100 74 149 0 948784592 34359632 15711536
05:14:31 11401 8192000000 9878909568 10222624768 936442544 10.258 100 82 164 0 992039168 38356704 17239920
05:15:46 6369 8192000000 9925647392 10280075264 970710320 10.594 100 80 160 0 1042220144 55072608 16437216
05:16:55 3897 8192000000 9963370848 10322395136 998547840 10.864 100 83 166 0 1081601024 67040624 16012560
05:18:00 1952 8192000000 10005851760 10370985984 1016690144 11.040 100 79 159 0 1116645328 84653936 15301248
05:19:04 1659 8192000000 10023047552 10394509312 1035073744 11.217 100 85 168 0 1137738592 86327696 16337152
05:20:09 1751 8192000000 10034719296 10410262528 1054028848 11.399 100 87 171 1 1149794832 78289440 17476544
05:21:12 1037 8192000000 10005825232 10387099648 1062542944 11.481 100 70 136 1 1119847024 43289952 14014128
05:22:14 6134 8192000000 9983626736 10374148096 1066844208 11.522 100 44 85 0 1099516128 24048144 8623776
05:23:24 6565 8192000000 9988198288 10391261184 1075452512 11.604 100 44 90 0 1112292912 27320304 9520096
05:24:34 11974 8192000000 10003699712 10402889728 1080857616 11.656 100 33 66 0 1108508912 20097040 7554256
05:25:47 11838 8192000000 9994110752 10391412736 1084794064 11.693 100 53 108 0 1104188704 7205536 12189104
05:27:00 7121 8192000000 10015141472 10425782272 1084210896 11.688 100 39 78 0 1139315632 47155920 7948816
05:28:17 17114 8192000000 10006060384 10415017984 1095347568 11.793 100 31 58 1 1121445664 19844288 6253808
05:29:49 112104 8192000000 10080344512 10500775936 1097659456 11.815 99 46 86 2 1169101520 62501040 8941024
05:32:47 56657 8192000000 10110379856 10533289984 1110757680 11.940 99 31 61 0 1223312784 105407504 7147600
05:34:51 41434 8192000000 10114541664 10522587136 1118581744 12.014 99 36 72 0 1253334672 126358032 8394896
05:36:37 16057 8192000000 10187447824 10587934720 1104116080 11.877 97 56 112 1 1286896704 171422384 11358240
05:38:07 9253 8192000000 10197844576 10593366016 1096184576 11.801 98 61 120 0 1281368704 172794656 12389472
05:39:21 4022 8192000000 10252539360 10659258368 1106913120 11.903 99 58 116 0 1348542816 228802544 12827152
05:40:28 13357 8192000000 10224456704 10621874176 1084882352 11.694 98 57 112 2 1318913824 221774688 12256784
05:41:47 3945 8192000000 10248859504 10665054208 1117952144 12.008 100 61 119 2 1366298720 234496032 13850544
05:42:54 739 8192000000 10336400816 10723446784 1120213504 12.029 100 80 160 0 1433010224 295226768 17569952
05:44:04 1681 8192000000 10348823280 10742308864 1129725728 12.119 100 83 164 0 1444563344 297074208 17763408
05:45:12 857 8192000000 10370337088 10782183424 1137452464 12.192 100 84 167 2 1472173120 315720400 19000256
05:46:17 16836 8192000000 10331507920 10762936320 1112800048 11.959 100 35 70 0 1424350992 303033760 8517184
05:47:41 2490 8192000000 10356307904 10768023552 1132837872 12.148 100 56 112 0 1451549712 305913776 12798064
05:48:46 11706 8192000000 10264871536 10733776896 1095580976 11.796 98 28 56 0 1386113856 282969584 7563296
05:50:03 25933 8192000000 10175980160 10685870080 1117997632 12.008 100 19 38 0 1296575296 174173120 4404544
05:51:31 48078 8192000000 10028772768 10544025600 1081469760 11.661 98 13 25 1 1149959344 65730384 2759200
05:53:19 39623 8192000000 10100990464 10521309184 1105658064 11.891 99 26 51 0 1174669648 64197536 4814048
05:55:02 14680 8192000000 10075023040 10518781952 1091024304 11.752 100 33 66 1 1203553312 104830640 7698368
05:56:20 160037 8192000000 10091178112 10535284736 1093459200 11.776 99 26 50 0 1188053328 89050224 5543904
06:00:44 14272 8192000000 10099888496 10525495296 1102653744 11.863 100 50 100 0 1194200624 81355152 10191728
06:02:05 51438 8192000000 10064620480 10522791936 1110654384 11.939 100 17 34 0 1162845904 48626160 3565360
06:03:58 48491 8192000000 10098336624 10560716800 1121361936 12.040 100 20 40 0 1214546592 89295632 3889024
06:05:48 46815 8192000000 10062353872 10504740864 1112489696 11.956 99 21 42 0 1186687952 69644016 4554240
06:07:55 28806 8192000000 10090266720 10537443328 1132745520 12.147 100 26 52 1 1190778912 53013152 5020240
06:09:27 37779 8192000000 10051098448 10506694656 1132674208 12.147 100 29 58 2 1161383744 21769760 6939776
06:11:05 30636 8192000000 10090537200 10522050560 1117349152 12.002 98 36 72 1 1168730896 44346880 7034864
06:12:37 35877 8192000000 10097477088 10535034880 1143208352 12.246 100 33 66 0 1203251712 53857456 6185904
06:14:13 38120 8192000000 10091450112 10569076736 1135194832 12.170 99 28 56 0 1204466816 63726528 5545456
06:15:53 24184 8192000000 10063989712 10520616960 1122841184 12.054 98 30 60 0 1175914144 47241920 5831040
06:17:20 62130 8192000000 10055642880 10561904640 1062206384 11.478 94 26 52 0 1134009904 66843616 4959904
06:19:22 43995 8192000000 10057638352 10489659392 1084425248 11.690 97 18 36 0 1117180608 29263104 3492256
06:21:08 23854 8192000000 10066302592 10490519552 1088903440 11.732 98 34 68 0 1144083312 48605680 6574192
06:22:32 63138 8192000000 10046545712 10499432448 1081906400 11.666 97 26 52 0 1153686288 66740720 5039168
06:24:36 24999 8192000000 10032700400 10481987584 1072664256 11.578 97 27 54 0 1116168032 38354464 5149312
06:26:02 67350 8192000000 10025621504 10474606592 1071345744 11.565 98 17 31 0 1130616992 56212256 3058992
06:28:14 80541 8192000000 10059206336 10525179904 1088517632 11.729 99 19 38 0 1176999136 84212864 4268640
06:30:44 33334 8192000000 10050607968 10505515008 1096068688 11.800 99 13 26 0 1152519488 53767632 2683168
06:32:19 68354 8192000000 10058267376 10498596864 1061692928 11.473 95 15 30 0 1117099072 52120288 3285856
06:34:28 40607 8192000000 10077838880 10495762432 1096504320 11.804 99 31 62 0 1146043504 43275168 6264016
06:36:13 29025 8192000000 10064107264 10500431872 1061890256 11.475 96 34 68 0 1145205504 77089536 6225712
06:37:45 58669 8192000000 10037014944 10469167104 1068512688 11.538 97 16 32 0 1113608736 42286256 2809792
06:39:45 32459 8192000000 10098423360 10526597120 1099543552 11.833 98 37 74 0 1177247440 70717664 6986224
06:41:17 111032 8192000000 10064606000 10491322368 1116426320 11.993 99 24 48 0 1158132544 36901888 4804336
06:44:33 64821 8192000000 10069721184 10558304256 1137769744 12.195 100 16 33 0 1207261280 66176160 3315376
06:46:49 36869 8192000000 10082025440 10553266176 1121198688 12.038 99 6 12 0 1172453632 50188800 1066144
06:48:27 45799 8192000000 10100726144 10541854720 1138594320 12.202 100 35 70 1 1195336416 48857344 7884752
06:50:15 43152 8192000000 10077532032 10520797184 1133450176 12.154 99 23 45 0 1167820464 30086832 4283456
06:52:00 64575 8192000000 10081578320 10515107840 1115853232 11.988 97 25 50 0 1158563616 37250752 5459632
06:54:05 81776 8192000000 10096383200 10564673536 1145015680 12.263 100 23 46 0 1191724896 42756928 3952288
06:56:30 72060 8192000000 10112411760 10597335040 1157369232 12.379 100 16 32 0 1243693344 83062768 3261344
06:58:45 46777 8192000000 10146392224 10645282816 1158640912 12.391 100 16 32 0 1240908048 79175168 3091968
07:00:32 92252 8192000000 10070578960 10549882880 1129346432 12.115 98 15 30 0 1171928064 39796144 2785488
07:03:06 45893 8192000000 10067818048 10518208512 1109956896 11.932 97 21 42 0 1152048720 37734000 4357824
07:04:59 46122 8192000000 10070567472 10536075264 1138031200 12.197 100 12 23 0 1191903856 51559744 2312912
07:07:32 22982 8192000000 9043529376 9251090432 193352864 2.305 17 6 12 0 225707472 31158064 1196544

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 130 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-03-2024 07:09:43 to 29-03-2024 07:09:45.

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          167744
MON$OLDEST_ACTIVE               168923
MON$OLDEST_SNAPSHOT             168923
MON$NEXT_TRANSACTION            168923
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                       1912416
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             679
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 Fri Mar 29 07:09:46 2024 
 
Database header page information: 
    Flags            0 
    Generation        88125 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    167744 
    Oldest active        168923 
    Oldest snapshot        168923 
    Next transaction    168924 
    Sequence number        0 
    Next attachment ID    679 
    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: 7650381 
    Average version length: 48.17, total versions: 37334, 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: 54, data page slots: 88112 
    Data pages: 88112, average fill: 69% 
    Primary pages: 88111, secondary pages: 1, swept pages: 47667 
    Empty pages: 3, full pages: 64464 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 37 
    40 - 59% = 2056 
    60 - 79% = 85991 
    80 - 99% = 21 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23034, nodes: 7650381 
    Average node length: 18.84, total dup: 0, max dup: 0 
    Average key length: 15.85, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1658802, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 284 
        20 - 39% = 2157 
        40 - 59% = 3778 
        60 - 79% = 2487 
        80 - 99% = 14328 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13404, nodes: 7650381 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1482411, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1767 
        40 - 59% = 1801 
        60 - 79% = 1156 
        80 - 99% = 8680 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8264, nodes: 7650381 
    Average node length: 6.59, total dup: 5753637, max dup: 49 
    Average key length: 3.60, compression ratio: 2.50 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1475592, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 1102 
        40 - 59% = 1236 
        60 - 79% = 983 
        80 - 99% = 4821 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.98, total records: 2187554 
    Average version length: 58.83, total versions: 19688, 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: 28248 
    Data pages: 28248, average fill: 71% 
    Primary pages: 28247, secondary pages: 1, swept pages: 14547 
    Empty pages: 34, full pages: 16569 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 28 
    40 - 59% = 629 
    60 - 79% = 27523 
    80 - 99% = 27 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4470, nodes: 2187554 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 675548, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 928 
        40 - 59% = 778 
        60 - 79% = 795 
        80 - 99% = 1969 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2400, nodes: 2188470 
    Average node length: 4.97, total dup: 2187571, max dup: 18717 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250369, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 214 
        40 - 59% = 1428 
        60 - 79% = 535 
        80 - 99% = 221 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1741, nodes: 2187554 
    Average node length: 4.97, total dup: 2187504, max dup: 130097 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1044814, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 594 
        60 - 79% = 54 
        80 - 99% = 1090 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4275, nodes: 2187554 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 675548, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 616 
        40 - 59% = 575 
        60 - 79% = 900 
        80 - 99% = 2093 
 
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.25, total records: 400 
    Average version length: 26.57, total versions: 2340, max versions: 6 
    Average fragment length: 2.00, total fragments: 6, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 55% 
    Primary pages: 14, secondary pages: 18, swept pages: 0 
    Empty pages: 7, full pages: 15 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 14 
 
    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: 11.24, total records: 70276 
    Average version length: 68.28, total versions: 67624, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.83 
    Pointer pages: 6, data page slots: 2008 
    Data pages: 1432, average fill: 67% 
    Primary pages: 1431, secondary pages: 1, swept pages: 0 
    Empty pages: 167, full pages: 840 
    Fill distribution: 
     0 - 19% = 230 
    20 - 39% = 115 
    40 - 59% = 142 
    60 - 79% = 170 
    80 - 99% = 775 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694592, depth: 3, leaf buckets: 237, nodes: 70276 
    Average node length: 13.30, total dup: 3373, max dup: 2 
    Average key length: 10.79, compression ratio: 2.50 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 51319, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 51 
        40 - 59% = 149 
        60 - 79% = 37 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 132, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 62% 
    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% = 1 
    80 - 99% = 0 
 
    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.53, total records: 1357 
    Average version length: 43.08, total versions: 1295, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.51 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 45% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 9, full pages: 11 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92021, depth: 2, leaf buckets: 2, nodes: 1357 
    Average node length: 4.38, total dup: 1259, max dup: 131 
    Average key length: 2.76, compression ratio: 6.88 
    Average prefix length: 18.31, average data length: 0.69 
    Clustering factor: 765, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        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.56, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.61, total records: 833679 
    Average version length: 37.92, total versions: 25975, max versions: 3 
    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: 8856 
    Data pages: 8856, average fill: 64% 
    Primary pages: 8853, secondary pages: 3, swept pages: 2907 
    Empty pages: 16, full pages: 5547 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 56 
    40 - 59% = 903 
    60 - 79% = 7813 
    80 - 99% = 55 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 908, nodes: 823495 
    Average node length: 4.88, total dup: 823446, max dup: 154111 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92017, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 158 
        40 - 59% = 485 
        60 - 79% = 163 
        80 - 99% = 100 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1027, nodes: 823495 
    Average node length: 5.89, total dup: 733159, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163556, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 48 
        40 - 59% = 678 
        60 - 79% = 59 
        80 - 99% = 240 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1051, nodes: 823495 
    Average node length: 5.89, total dup: 733159, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165579, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 88 
        40 - 59% = 678 
        60 - 79% = 48 
        80 - 99% = 237 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1151, nodes: 823495 
    Average node length: 5.97, total dup: 733159, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157777, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 199 
        40 - 59% = 640 
        60 - 79% = 224 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.72, total records: 5467 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.25, total fragments: 24, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 82, secondary pages: 14, swept pages: 61 
    Empty pages: 14, full pages: 60 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5467 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5160, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5467 
    Average node length: 11.10, 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: 169, 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.04, total records: 76788 
    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: 800 
    Data pages: 800, average fill: 66% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 797 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 797 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32717, depth: 2, leaf buckets: 98, nodes: 76788 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2913, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 97 
 
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.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 129.69, total records: 192514 
    Average version length: 154.47, total versions: 29453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.08 
    Pointer pages: 7, data page slots: 5960 
    Data pages: 4816, average fill: 85% 
    Primary pages: 4814, secondary pages: 2, swept pages: 4 
    Empty pages: 59, full pages: 4734 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4733 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 147.88, total records: 144838 
    Average version length: 152.06, total versions: 3196, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 4400 
    Data pages: 3600, average fill: 83% 
    Primary pages: 3598, secondary pages: 2, swept pages: 1 
    Empty pages: 33, full pages: 3552 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3552 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.27, total records: 151024 
    Average version length: 153.31, total versions: 6954, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 6, data page slots: 3912 
    Data pages: 3728, average fill: 84% 
    Primary pages: 3726, secondary pages: 2, swept pages: 3 
    Empty pages: 19, full pages: 3699 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3698 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 144.99, total records: 161012 
    Average version length: 153.22, total versions: 7068, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 7, data page slots: 4376 
    Data pages: 3976, average fill: 84% 
    Primary pages: 3974, secondary pages: 2, swept pages: 2 
    Empty pages: 13, full pages: 3955 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3955 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.48, total records: 148370 
    Average version length: 151.19, total versions: 2608, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 6, data page slots: 3992 
    Data pages: 3664, average fill: 84% 
    Primary pages: 3663, secondary pages: 1, swept pages: 2 
    Empty pages: 19, full pages: 3638 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3639 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 138.55, total records: 169756 
    Average version length: 154.36, total versions: 15011, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.24 
    Pointer pages: 7, data page slots: 4872 
    Data pages: 4216, average fill: 84% 
    Primary pages: 4214, secondary pages: 2, swept pages: 4 
    Empty pages: 33, full pages: 4168 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 4167 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 147.13, total records: 147508 
    Average version length: 150.44, total versions: 3700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 4880 
    Data pages: 3672, average fill: 83% 
    Primary pages: 3670, secondary pages: 2, swept pages: 3 
    Empty pages: 45, full pages: 3605 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3606 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 147.04, total records: 156289 
    Average version length: 152.02, total versions: 4384, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 4648 
    Data pages: 3904, average fill: 83% 
    Primary pages: 3900, secondary pages: 4, swept pages: 1 
    Empty pages: 59, full pages: 3829 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 3829 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 150.38, total records: 154215 
    Average version length: 141.67, 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.28 
    Pointer pages: 7, data page slots: 4800 
    Data pages: 3824, average fill: 83% 
    Primary pages: 3822, secondary pages: 2, swept pages: 2 
    Empty pages: 34, full pages: 3780 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3780 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 146.70, total records: 152532 
    Average version length: 151.88, total versions: 4837, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 5296 
    Data pages: 3832, average fill: 82% 
    Primary pages: 3830, secondary pages: 2, swept pages: 3 
    Empty pages: 71, full pages: 3735 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 10 
    40 - 59% = 10 
    60 - 79% = 4 
    80 - 99% = 3736 
 
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.43, total records: 2043784 
    Average version length: 52.87, total versions: 14739, 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: 25296 
    Data pages: 25296, average fill: 69% 
    Primary pages: 25283, secondary pages: 13, swept pages: 12634 
    Empty pages: 155, full pages: 20969 
    Fill distribution: 
     0 - 19% = 305 
    20 - 39% = 360 
    40 - 59% = 1101 
    60 - 79% = 23417 
    80 - 99% = 113 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2521, nodes: 2043784 
    Average node length: 5.45, total dup: 1905728, max dup: 1657 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179533, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 339 
        40 - 59% = 1583 
        60 - 79% = 278 
        80 - 99% = 320 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2043784 
    Average node length: 5.70, total dup: 1833622, max dup: 69 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 367592, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2565 
        60 - 79% = 165 
        80 - 99% = 15 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2060, nodes: 2043784 
    Average node length: 4.96, total dup: 2043684, max dup: 27458 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177198, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 218 
        40 - 59% = 1015 
        60 - 79% = 379 
        80 - 99% = 445 
 
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: 49.46, total records: 130739 
    Average version length: 69.16, total versions: 42889, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.55 
    Pointer pages: 3, data page slots: 3952 
    Data pages: 3128, average fill: 49% 
    Primary pages: 3128, secondary pages: 0, swept pages: 557 
    Empty pages: 597, full pages: 1313 
    Fill distribution: 
     0 - 19% = 818 
    20 - 39% = 352 
    40 - 59% = 448 
    60 - 79% = 895 
    80 - 99% = 615 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98125, depth: 3, leaf buckets: 213, nodes: 130739 
    Average node length: 6.44, total dup: 113591, max dup: 14 
    Average key length: 3.98, compression ratio: 10.54 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 22742, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 54 
        40 - 59% = 110 
        60 - 79% = 40 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.76, total records: 7174699 
    Average version length: 68.71, total versions: 260570, 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: 68, data page slots: 109688 
    Data pages: 109688, average fill: 70% 
    Primary pages: 109687, secondary pages: 1, swept pages: 39878 
    Empty pages: 11, full pages: 57211 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 665 
    40 - 59% = 9990 
    60 - 79% = 98314 
    80 - 99% = 658 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10842, nodes: 7174699 
    Average node length: 6.51, total dup: 6204481, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1676782, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1546 
        40 - 59% = 5982 
        60 - 79% = 2905 
        80 - 99% = 401 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8845, nodes: 7174699 
    Average node length: 5.39, total dup: 6890919, max dup: 173 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1479893, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1342 
        40 - 59% = 5081 
        60 - 79% = 1536 
        80 - 99% = 881 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8899, nodes: 7174699 
    Average node length: 5.40, total dup: 6890919, max dup: 173 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1482175, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1340 
        40 - 59% = 5101 
        60 - 79% = 1572 
        80 - 99% = 882 
 
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: 12122106 
    Average version length: 68.67, total versions: 212627, 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: 109, data page slots: 177328 
    Data pages: 177328, average fill: 73% 
    Primary pages: 177328, secondary pages: 0, swept pages: 89375 
    Empty pages: 3, full pages: 137472 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 638 
    40 - 59% = 6811 
    60 - 79% = 168675 
    80 - 99% = 1155 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18519, nodes: 12120893 
    Average node length: 6.62, total dup: 10566073, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2466812, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2142 
        40 - 59% = 10942 
        60 - 79% = 4680 
        80 - 99% = 730 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 55.26, total records: 1379406 
    Average version length: 69.07, total versions: 246644, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.28 
    Pointer pages: 26, data page slots: 41904 
    Data pages: 28071, average fill: 54% 
    Primary pages: 28003, secondary pages: 68, swept pages: 10740 
    Empty pages: 3642, full pages: 15271 
    Fill distribution: 
     0 - 19% = 5775 
    20 - 39% = 3251 
    40 - 59% = 2759 
    60 - 79% = 13119 
    80 - 99% = 3167 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1851, nodes: 1307490 
    Average node length: 5.53, total dup: 1254492, max dup: 49 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 90688, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 528 
        40 - 59% = 918 
        60 - 79% = 358 
        80 - 99% = 39 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 45.18, total records: 1017339 
    Average version length: 69.04, total versions: 119938, 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: 22, data page slots: 34840 
    Data pages: 28104, average fill: 34% 
    Primary pages: 28104, secondary pages: 0, swept pages: 8345 
    Empty pages: 5758, full pages: 6187 
    Fill distribution: 
     0 - 19% = 9485 
    20 - 39% = 5841 
    40 - 59% = 7800 
    60 - 79% = 4910 
    80 - 99% = 68 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1178, nodes: 733308 
    Average node length: 5.95, total dup: 675263, max dup: 61 
    Average key length: 3.02, compression ratio: 13.90 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 108586, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 417 
        40 - 59% = 578 
        60 - 79% = 173 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.38, total records: 8746683 
    Average version length: 68.94, total versions: 217944, 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: 87, data page slots: 141496 
    Data pages: 141480, average fill: 66% 
    Primary pages: 141460, secondary pages: 20, swept pages: 71618 
    Empty pages: 351, full pages: 57654 
    Fill distribution: 
     0 - 19% = 1335 
    20 - 39% = 7266 
    40 - 59% = 20973 
    60 - 79% = 111088 
    80 - 99% = 818 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13411, nodes: 8743698 
    Average node length: 6.68, total dup: 7248858, max dup: 14 
    Average key length: 3.68, compression ratio: 11.43 
    Average prefix length: 40.49, average data length: 1.51 
    Clustering factor: 1987462, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1801 
        40 - 59% = 7286 
        60 - 79% = 3909 
        80 - 99% = 415 
 
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: 21102392 
    Average version length: 82.90, total versions: 5850, 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: 319072 
    Data pages: 319072, average fill: 81% 
    Primary pages: 319068, secondary pages: 4, swept pages: 12769 
    Empty pages: 42, full pages: 318352 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 40 
    40 - 59% = 92 
    60 - 79% = 48356 
    80 - 99% = 270513 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19240, nodes: 21102392 
    Average node length: 5.72, total dup: 20622427, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276239, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 7926 
        60 - 79% = 547 
        80 - 99% = 10761 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17119, nodes: 21102392 
    Average node length: 6.31, total dup: 18545321, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914000, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 5 
        40 - 59% = 729 
        60 - 79% = 287 
        80 - 99% = 16094 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21014, nodes: 21102392 
    Average node length: 6.35, total dup: 18463596, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3569252, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8198 
        60 - 79% = 590 
        80 - 99% = 12220 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16038, nodes: 21102392 
    Average node length: 5.56, total dup: 21102292, max dup: 229002 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942845, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 2862 
        60 - 79% = 336 
        80 - 99% = 12827 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.24, total records: 9120759 
    Average version length: 82.61, total versions: 143866, 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: 104, data page slots: 168272 
    Data pages: 168256, average fill: 67% 
    Primary pages: 168230, secondary pages: 26, swept pages: 104608 
    Empty pages: 712, full pages: 83459 
    Fill distribution: 
     0 - 19% = 2587 
    20 - 39% = 11095 
    40 - 59% = 27516 
    60 - 79% = 112144 
    80 - 99% = 14914 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11301, nodes: 9120759 
    Average node length: 5.35, total dup: 8818782, max dup: 144 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2056643, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 127 
        40 - 59% = 9680 
        60 - 79% = 1473 
        80 - 99% = 20 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12804, nodes: 9120759 
    Average node length: 6.22, total dup: 7557938, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1438473, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 3679 
        40 - 59% = 4285 
        60 - 79% = 2523 
        80 - 99% = 2201 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12606, nodes: 9120759 
    Average node length: 5.97, total dup: 7899043, max dup: 29 
    Average key length: 2.86, compression ratio: 3.14 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2232155, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 141 
        40 - 59% = 10776 
        60 - 79% = 1655 
        80 - 99% = 33 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9664, nodes: 9120759 
    Average node length: 5.11, total dup: 9120659, max dup: 150739 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1461176, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1401 
        40 - 59% = 4651 
        60 - 79% = 1746 
        80 - 99% = 1837 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.22, total records: 10922419 
    Average version length: 82.50, total versions: 159642, 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: 117, data page slots: 190080 
    Data pages: 188536, average fill: 71% 
    Primary pages: 188412, secondary pages: 124, swept pages: 74441 
    Empty pages: 2912, full pages: 139551 
    Fill distribution: 
     0 - 19% = 5113 
    20 - 39% = 8520 
    40 - 59% = 18732 
    60 - 79% = 97874 
    80 - 99% = 58297 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13102, nodes: 10922419 
    Average node length: 5.29, total dup: 10813680, max dup: 685 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2276896, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 128 
        40 - 59% = 10284 
        60 - 79% = 2642 
        80 - 99% = 48 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10156, nodes: 10922419 
    Average node length: 5.49, total dup: 10444172, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 686334, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 896 
        40 - 59% = 2475 
        60 - 79% = 1848 
        80 - 99% = 4779 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14991, nodes: 10922419 
    Average node length: 6.02, total dup: 9522673, max dup: 80 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2293144, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 170 
        40 - 59% = 11956 
        60 - 79% = 2798 
        80 - 99% = 60 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10462, nodes: 10922419 
    Average node length: 5.21, total dup: 10922319, max dup: 187715 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 675670, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 903 
        40 - 59% = 4504 
        60 - 79% = 1556 
        80 - 99% = 3391 
 
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.71, total records: 9216403 
    Average version length: 82.91, total versions: 127842, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 107, data page slots: 173472 
    Data pages: 173400, average fill: 66% 
    Primary pages: 173370, secondary pages: 30, swept pages: 109981 
    Empty pages: 694, full pages: 82576 
    Fill distribution: 
     0 - 19% = 2849 
    20 - 39% = 14386 
    40 - 59% = 30183 
    60 - 79% = 112138 
    80 - 99% = 13844 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11331, nodes: 9216403 
    Average node length: 5.16, total dup: 9188453, max dup: 1527 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1866447, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1644 
        40 - 59% = 7513 
        60 - 79% = 1647 
        80 - 99% = 494 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 12998, nodes: 9216403 
    Average node length: 6.24, total dup: 7637528, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 1411607, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 3707 
        40 - 59% = 4301 
        60 - 79% = 2525 
        80 - 99% = 2294 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 11930, nodes: 9216403 
    Average node length: 5.42, total dup: 8798432, max dup: 92 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1993663, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1546 
        40 - 59% = 8394 
        60 - 79% = 1480 
        80 - 99% = 478 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9782, nodes: 9216403 
    Average node length: 5.13, total dup: 9216303, max dup: 152473 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1486893, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 54 
        20 - 39% = 1335 
        40 - 59% = 4741 
        60 - 79% = 1771 
        80 - 99% = 1881 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.92, total records: 565149 
    Average version length: 68.80, total versions: 2342, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7968, average fill: 74% 
    Primary pages: 7968, secondary pages: 0, swept pages: 4242 
    Empty pages: 5, full pages: 6622 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 8 
    40 - 59% = 137 
    60 - 79% = 7785 
    80 - 99% = 33 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 34847, depth: 3, leaf buckets: 726, nodes: 565149 
    Average node length: 5.95, total dup: 481101, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99940, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 516 
        60 - 79% = 81 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29584, depth: 3, leaf buckets: 743, nodes: 565149 
    Average node length: 6.15, total dup: 463574, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99988, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 515 
        60 - 79% = 83 
        80 - 99% = 108 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 566, nodes: 565149 
    Average node length: 4.86, total dup: 565049, max dup: 9686 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88770, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 335 
        60 - 79% = 83 
        80 - 99% = 114 
 
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 Fri Mar 29 07:10:10 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7650381 37334 1 0.0000 0.0000
DOC_LIST 2187554 19688 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2340 6 500.0000 0.0000
INVNT_TURNOVER_LOG 70276 67624 1 0.0000 0.0000
MONEY_SALDO 49 132 5 200.0000 0.0000
MONEY_TURNOVER_LOG 1357 1295 1 0.0000 0.0000
PDISTR 833679 25975 3 0.0000 0.0000
PERF_SPLIT_0 192514 29453 1 0.0000 0.0000
PERF_SPLIT_1 144838 3196 1 0.0000 0.0000
PERF_SPLIT_2 151024 6954 1 0.0000 0.0000
PERF_SPLIT_3 161012 7068 1 0.0000 0.0000
PERF_SPLIT_4 148370 2608 1 0.0000 0.0000
PERF_SPLIT_5 169756 15011 1 0.0000 0.0000
PERF_SPLIT_6 147508 3700 1 0.0000 0.0000
PERF_SPLIT_7 156289 4384 1 0.0000 0.0000
PERF_SPLIT_8 154215 701 1 0.0000 0.0000
PERF_SPLIT_9 152532 4837 1 0.0000 0.0000
PSTORNED 2043784 14739 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 130739 42889 1 0.0000 0.0000
XQD_1000_3300 7174699 260570 1 0.0000 0.0000
XQD_1200_2000 12122106 212627 1 0.0000 0.0000
XQD_2000_3300 1379406 246644 1 0.0000 0.0000
XQD_2100_3300 1017339 119938 1 0.0000 0.0000
XQD_3300_3400 8746683 217944 1 0.0000 0.0000
XQS_1000_1200 21102392 5850 1 0.0000 0.0000
XQS_1000_3300 9120759 143866 1 0.0000 0.0000
XQS_1200_2000 10922419 159642 1 0.0000 0.0000
XQS_2100_3300 9216403 127842 1 0.0000 0.0000
XQS_3300_3400 565149 2342 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'  

29.03.24 07:10:22. 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-29 07:10:24 No severe PSQL-related problems occured
29.03.24 07:10:26. End of report.