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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-07 01:09:46
DTS_END                         2024-04-07 01:09:46.8210
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43076
TRN_ID                          178114
ATT_ID                          528
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: 9352.36 22232 935236
customer order: creation 178.43 370 17843
customer order: refuse 15.71 364 1571
order to supplier: creation 47.64 1299 4764
order to supplier: removal 3.55 105394 355
invoice (draft): creation 47.77 3008 4777
invoice (draft): removal 51.82 825 5182
invoice accept: apply 42.46 20853 4246
invoice accept: cancel 46.88 846 4688
customer reserve: creation 4053.40 201 405340
customer reserve: removal 4558.28 65 455828
realization accept: apply 87.16 203 8716
realization accept: cancel 85.63 137 8563
payment from customer: creation 61.57 147 6157
payment from customer: removal 5.96 90 596
payment to supplier: creation 50.34 146 5034
payment to supplier: removal 3.43 84 343
service: total inventory turnovers 5.11 1008 511
service: total monetary turnovers 6.37 32 637
service: aggregate perf. data 0.82 20574 82
service: refresh index statistics 0.03 288990 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-04-2024 01:10:37 to 07-04-2024 01:10:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4469
TEST_TIME 2 3683
TEST_TIME 3 2862
TEST_TIME 4 3650
TEST_TIME 5 3832
TEST_TIME 6 3771
TEST_TIME 7 4520
TEST_TIME 8 5243
TEST_TIME 9 5286
TEST_TIME 10 5521
TEST_TIME 11 5715
TEST_TIME 12 5574
TEST_TIME 13 5821
TEST_TIME 14 6001
TEST_TIME 15 6074
TEST_TIME 16 6151
TEST_TIME 17 6253
TEST_TIME 18 6554
TEST_TIME 19 6886
TEST_TIME 20 6777
TEST_TIME 21 7158
TEST_TIME 22 7089
TEST_TIME 23 7345
TEST_TIME 24 7449
TEST_TIME 25 7631
TEST_TIME 26 7607
TEST_TIME 27 9358
TEST_TIME 28 9365
TEST_TIME 29 9292
TEST_TIME 30 9166
TEST_TIME 31 9088
TEST_TIME 32 8856
TEST_TIME 33 8968
TEST_TIME 34 9027
TEST_TIME 35 9123
TEST_TIME 36 9060
TEST_TIME 37 9048
TEST_TIME 38 8990
TEST_TIME 39 8899
TEST_TIME 40 8901
TEST_TIME 41 9202
TEST_TIME 42 9105
TEST_TIME 43 9130
TEST_TIME 44 9098
TEST_TIME 45 9122
TEST_TIME 46 9080
TEST_TIME 47 9108
TEST_TIME 48 9283
TEST_TIME 49 9240
TEST_TIME 50 9358
TEST_TIME 51 9321
TEST_TIME 52 9344
TEST_TIME 53 9397
TEST_TIME 54 9322
TEST_TIME 55 9575
TEST_TIME 56 9555
TEST_TIME 57 9539
TEST_TIME 58 9543
TEST_TIME 59 9399
TEST_TIME 60 9336
TEST_TIME 61 9347
TEST_TIME 62 9302
TEST_TIME 63 9316
TEST_TIME 64 9297
TEST_TIME 65 9301
TEST_TIME 66 9236
TEST_TIME 67 9225
TEST_TIME 68 9195
TEST_TIME 69 9212
TEST_TIME 70 9210
TEST_TIME 71 9231
TEST_TIME 72 9241
TEST_TIME 73 9305
TEST_TIME 74 9374
TEST_TIME 75 9435
TEST_TIME 76 9498
TEST_TIME 77 9540
TEST_TIME 78 9520
TEST_TIME 79 9515
TEST_TIME 80 9542
TEST_TIME 81 9570
TEST_TIME 82 9620
TEST_TIME 83 9512
TEST_TIME 84 9514
TEST_TIME 85 9440
TEST_TIME 86 9469
TEST_TIME 87 9429
TEST_TIME 88 9418
TEST_TIME 89 9380
TEST_TIME 90 9359
TEST_TIME 91 9312
TEST_TIME 92 9321
TEST_TIME 93 9324
TEST_TIME 94 9297
TEST_TIME 95 9278
TEST_TIME 96 9312
TEST_TIME 97 9303
TEST_TIME 98 9364
TEST_TIME 99 9381
TEST_TIME 100 9361

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-04-2024 01:10:41 to 07-04-2024 01:10:44.

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 1307805 1307805 0 0.00 0 28410 8 0 0
doc_list_biud 1307805 1307805 0 0.00 0 33789 29 0 0
sp_add_invoice_to_stock 4409 4246 163 3.69 42 181921 20853 0 163
sp_cancel_adding_invoice 4688 4688 0 0.00 4 59374 847 0 0
sp_cancel_client_order 1571 1571 0 0.00 4 13708 365 0 0
sp_cancel_customer_reserve 455828 455828 0 0.00 0 33792 66 0 0
sp_cancel_pay_from_customer 596 596 0 0.00 3 8905 91 0 0
sp_cancel_pay_to_supplier 343 343 0 0.00 3 4825 84 0 0
sp_cancel_supplier_invoice 5192 5182 10 0.19 2 17670 826 0 10
sp_cancel_supplier_order 355 355 0 0.00 10 1046890 105395 0 0
sp_cancel_write_off 8563 8563 0 0.00 1 15002 138 0 0
sp_client_order 17843 17843 0 0.00 3 18852 370 0 0
sp_customer_reserve 405340 405340 0 0.00 0 39690 202 0 0
sp_fill_shopping_cart 27383 27383 0 0.00 1 20604 36 0 0
sp_fill_shopping_cart_clo_res 405323 405323 0 0.00 0 27094 16 0 0
sp_get_clo_for_invoice 4229 4229 0 0.00 0 22321 293 0 0
sp_kill_cost_storno 14190 14190 0 0.00 0 8954 60 0 0
sp_kill_qstorno_ret_qs2qd 925756 925756 0 0.00 0 33789 36 0 0
sp_kill_qty_storno 489132 489132 0 0.00 0 33789 76 0 0
sp_lock_selected_doc 17964 17964 0 0.00 0 7317 5 0 0
sp_make_cost_storno 24136 24136 0 0.00 0 26296 69 0 0
sp_multiply_rows_for_pdistr 24136 24136 0 0.00 0 18035 34 0 0
sp_multiply_rows_for_qdistr 17843 17843 0 0.00 0 18840 169 0 0
sp_pay_from_customer 6157 6157 0 0.00 3 27195 147 0 0
sp_pay_to_supplier 5034 5034 0 0.00 4 25088 146 0 0
sp_payment_common 11191 11191 0 0.00 1 27130 35 0 0
sp_qd_handle_on_cancel_clo 1571 1571 0 0.00 0 13702 336 0 0
sp_qd_handle_on_invoice_upd_sts 8917 8917 0 0.00 0 15806 309 0 0
sp_qd_handle_on_reserve_upd_sts 8716 8716 0 0.00 0 19731 69 0 0
sp_reserve_write_off 8716 8716 0 0.00 7 26956 204 0 0
sp_supplier_invoice 4777 4777 0 0.00 8 92235 3008 0 0
sp_supplier_order 4764 4764 0 0.00 5 38650 1299 0 0
srv_aggregate_perf_data 82 82 0 0.00 1658 238672 20575 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 791 100138 35873 0 0
srv_find_qd_qs_mism 892412 892412 0 0.00 0 15589 7 0 0
srv_make_invnt_saldo 511 511 0 0.00 54 29665 1009 0 0
srv_make_money_saldo 637 637 0 0.00 1 3071 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 233603 353494 288990 0 0
t$perf-abend:sp_add_invoice_to_stock 163 163 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4246 4246 0 0.00 0 8279 161 0 0
t$perf-norm:sp_cancel_adding_invoice 360 360 0 0.00 1 13021 117 0 0
t$perf-norm:sp_cancel_client_order 1571 1571 0 0.00 0 2161 8 0 0
t$perf-norm:sp_cancel_customer_reserve 602 602 0 0.00 0 1477 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 596 596 0 0.00 0 3361 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 343 343 0 0.00 0 1332 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 327 327 0 0.00 0 2045 24 0 0
t$perf-norm:sp_cancel_supplier_order 355 355 0 0.00 0 46785 1934 0 0
t$perf-norm:sp_cancel_write_off 866 866 0 0.00 0 4708 8 0 0
t$perf-norm:sp_client_order 17843 17843 0 0.00 0 16249 16 0 0
t$perf-norm:sp_customer_reserve 864 864 0 0.00 0 539 6 0 0
t$perf-norm:sp_pay_from_customer 6157 6157 0 0.00 0 9741 12 0 0
t$perf-norm:sp_pay_to_supplier 5034 5034 0 0.00 0 3754 11 0 0
t$perf-norm:sp_reserve_write_off 8716 8716 0 0.00 0 11462 11 0 0
t$perf-norm:sp_supplier_invoice 4777 4777 0 0.00 0 6070 14 0 0
t$perf-norm:sp_supplier_order 4764 4764 0 0.00 0 3810 15 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 367 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 2867 66 0 0
t$perf-norm:srv_make_invnt_saldo 511 511 0 0.00 0 1151 20 0 0
t$perf-norm:srv_make_money_saldo 637 637 0 0.00 0 18312 50 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 8782 8456 326 3.71 0 4787 20 0 326
v_all_customers 33236 33236 0 0.00 0 115 1 0 0
v_all_suppliers 27168 27168 0 0.00 0 20 1 0 0
v_all_wares 35686 35686 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 720 720 0 0.00 0 2683 13 0 0
v_cancel_client_order 3142 3142 0 0.00 0 3717 9 0 0
v_cancel_customer_prepayment 1192 1192 0 0.00 0 2746 12 0 0
v_cancel_customer_reserve 1204 1204 0 0.00 0 5080 12 0 0
v_cancel_payment_to_supplier 686 686 0 0.00 0 4789 18 0 0
v_cancel_supplier_invoice 674 654 20 2.96 0 149 12 0 20
v_cancel_supplier_order 710 710 0 0.00 0 4591 14 0 0
v_cancel_write_off 1732 1732 0 0.00 0 2817 15 0 0
v_max_id_clo_ord 4764 4764 0 0.00 0 931 1 0 0
v_max_id_clo_res 864 864 0 0.00 0 1494 9 0 0
v_max_id_ord_sup 4776 4776 0 0.00 0 7854 6 0 0
v_max_non_paid_invoice 990 990 0 0.00 0 616 4 0 0
v_max_non_paid_realizn 2908 2908 0 0.00 0 1264 5 0 0
v_min_id_clo_ord 4764 4764 0 0.00 0 4970 7 0 0
v_min_id_clo_res 864 864 0 0.00 0 5017 19 0 0
v_min_id_ord_sup 4776 4776 0 0.00 0 2164 3 0 0
v_min_non_paid_invoice 5034 5034 0 0.00 0 15791 23 0 0
v_min_non_paid_realizn 6157 6157 0 0.00 0 16688 32 0 0
v_our_firm 8948 8948 0 0.00 0 17 1 0 0
v_reserve_write_off 17432 17432 0 0.00 0 7942 9 0 0
x_lock_depdocs_on_canc_invoice 9543 9543 0 0.00 0 26530 134 0 0
x_lock_depdocs_on_canc_sup_ord 355 355 0 0.00 0 9792 336 0 0
x_make_qstorno_1000_1200 4764 4764 0 0.00 1 38555 1209 0 0
x_make_qstorno_1200_2000 4777 4777 0 0.00 4 92224 2893 0 0
x_make_qstorno_2100_3300 405340 405340 0 0.00 0 39688 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-04-2024 01:10:45 to 07-04-2024 01:10:49.

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
23:09:50 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:51 27454 8192000000 9891469888 10200133632 974144192 10.627 100 95 190 1 1005211856 5850512 25217152
23:12:28 15226 8192000000 9952404960 10276012032 1034457280 11.211 100 85 170 0 1063933968 8131616 21345072
23:13:48 17673 8192000000 9988205872 10320388096 1070991136 11.562 100 87 174 0 1102204976 9938928 21274912
23:15:12 8092 8192000000 10031645168 10380546048 1123876416 12.064 100 76 152 0 1152807024 10812064 18118544
23:16:22 7006 8192000000 10069589776 10428178432 1158475456 12.389 100 84 168 0 1192030320 13844096 19710768
23:17:34 5796 8192000000 10103530624 10471854080 1194335008 12.724 100 73 145 1 1223726800 13512416 15879376
23:18:42 1969 8192000000 10150471584 10522263552 1235007280 13.100 100 88 174 0 1267269392 12508432 19753680
23:19:45 5535 8192000000 10183779264 10559631360 1263658096 13.364 100 81 160 0 1294710192 13986304 17065792
23:20:52 837 8192000000 10208411104 10592038912 1292862144 13.630 100 91 177 1 1327027952 13549440 20616368
23:21:53 18394 8192000000 10208597648 10603069440 1299501264 13.691 100 35 70 0 1313458496 5736512 8220720
23:23:12 7935 8192000000 10196728160 10607353856 1306912608 13.758 100 41 81 1 1323657424 8186736 8558080
23:24:23 3697 8192000000 10203317680 10613854208 1313916720 13.822 100 37 76 1 1328295072 6123440 8254912
23:25:27 12613 8192000000 10217287904 10631024640 1328642928 13.955 100 21 41 0 1338427616 5684288 4100400
23:26:45 43688 8192000000 10235361856 10641813504 1330274128 13.970 100 57 115 1 1350321440 6482592 13564720
23:28:29 7059 8192000000 10215564448 10634502144 1315172256 13.833 99 20 40 0 1326261952 6540624 4549072
23:29:37 7159 8192000000 10223612112 10637348864 1315759056 13.838 99 25 50 1 1327445616 6153824 5532736
23:30:55 20751 8192000000 10254636320 10667036672 1343192208 14.086 100 50 98 0 1366318192 12355200 10770784
23:32:18 76174 8192000000 10241914160 10662617088 1330750912 13.974 99 47 94 0 1358315120 16950064 10614144
23:34:40 7982 8192000000 10242342592 10661580800 1329995152 13.967 98 36 71 0 1350737312 12785680 7956480
23:35:55 18236 8192000000 10261355728 10677665792 1334907088 14.011 99 50 101 0 1369518816 22821920 11789808
23:37:16 22741 8192000000 10233746960 10641633280 1302267184 13.716 99 47 94 0 1326696656 14162336 10267136
23:38:42 12418 8192000000 10239351248 10642464768 1312873408 13.812 99 50 98 0 1341293584 16630480 11789696
23:40:08 30812 8192000000 10243977632 10651238400 1310072320 13.787 98 46 90 0 1341956992 21143312 10741360
23:41:45 16043 8192000000 10252502928 10657705984 1326530576 13.936 100 46 92 0 1363240016 25450640 11258800
23:43:07 12213 8192000000 10268989184 10670460928 1334625760 14.009 100 59 114 0 1377148912 28813136 13710016
23:44:30 1958 8192000000 10273417552 10668740608 1326454640 13.935 99 67 134 0 1375183632 32507728 16221264
23:45:45 1682 8192000000 10296669504 10694516736 1344200208 14.095 100 75 150 0 1401716800 39433312 18083280
23:46:51 6652 8192000000 10315644656 10721779712 1363595520 14.270 100 66 130 0 1422120704 42573168 15952016
23:48:01 2316 8192000000 10343803088 10746753024 1383849168 14.451 100 84 165 0 1444985968 39935984 21200816
23:49:07 14918 8192000000 10323677040 10740609024 1374201040 14.365 99 37 74 0 1421262368 37076480 9984848
23:50:27 789 8192000000 10356737872 10763186176 1399614240 14.592 100 86 169 2 1459850368 38595424 21640704
23:51:47 17350 8192000000 10343549200 10766540800 1396610992 14.565 100 54 105 1 1450885040 40730416 13543632
23:53:09 16520 8192000000 10340264272 10771673088 1385403152 14.465 99 31 62 0 1437697024 43289216 9004656
23:55:00 31528 8192000000 10318416416 10755911680 1370934512 14.335 100 23 47 1 1426211552 47922896 7354144
23:56:39 30263 8192000000 10280118512 10731741184 1355970304 14.201 98 19 38 0 1389111904 28759600 4382000
23:58:16 17849 8192000000 10297137104 10733535232 1369361744 14.321 99 25 48 0 1385111296 9873984 5875568
23:59:39 13340 8192000000 10314146528 10746486784 1389635456 14.503 100 61 122 0 1411335056 7586976 14112624
00:00:54 100138 8192000000 10314536176 10762100736 1392319376 14.527 100 27 54 0 1407899280 8622592 6957312
00:03:43 59860 8192000000 10302012784 10766520320 1394941104 14.550 100 30 60 0 1421213936 19657744 6615088
00:05:44 41977 8192000000 10322461344 10774487040 1404892464 14.639 100 24 49 0 1425806240 15834080 5079696
00:07:27 13360 8192000000 10323219904 10773622784 1416518576 14.742 100 40 76 3 1436498960 10682496 9297888
00:08:59 4012 8192000000 10344853984 10795433984 1429043168 14.853 100 40 80 1 1455770864 17217056 9510640
00:10:06 48321 8192000000 10317045152 10797875200 1422139568 14.792 100 15 30 0 1438957904 13187776 3630560
00:11:58 38437 8192000000 10330607184 10793439232 1419924272 14.772 100 16 32 0 1433316816 9814480 3578064
00:13:48 34132 8192000000 10317996528 10788880384 1420721728 14.779 100 9 18 0 1430079760 7337888 2020144
00:15:25 42159 8192000000 10343723600 10803900416 1429206176 14.854 100 35 70 1 1456808144 20058128 7543840
00:17:08 42270 8192000000 10324507280 10810097664 1380963472 14.425 97 12 24 0 1402665296 18443344 3258480
00:18:50 35733 8192000000 10303602320 10764099584 1382817408 14.442 98 28 56 0 1400712880 11548192 6347280
00:20:32 17798 8192000000 10311779824 10753220608 1381563952 14.431 99 40 81 1 1399154448 8958304 8632192
00:21:51 57337 8192000000 10283164064 10729336832 1349004736 14.139 98 21 42 0 1369885680 16135664 4745280
00:23:52 51149 8192000000 10283902400 10753593344 1372854880 14.353 100 22 44 0 1400593488 22376016 5362592
00:25:50 31241 8192000000 10275997648 10707853312 1334225264 14.005 98 42 80 2 1350903424 7043696 9634464
00:27:22 95624 8192000000 10256975424 10694000640 1335385200 14.016 98 23 46 0 1349253344 9079168 4788976
00:30:00 73119 8192000000 10250742352 10702884864 1308413840 13.772 97 17 34 0 1328795056 16869056 3512160
00:32:16 22729 8192000000 10227473984 10667741184 1304616288 13.737 98 30 60 0 1319682496 8863376 6202832
00:33:40 52097 8192000000 10241209152 10694496256 1347593696 14.126 100 11 22 0 1359796912 9445200 2758016
00:35:33 54137 8192000000 10233292736 10683916288 1322066176 13.895 98 10 20 0 1333409616 8636896 2706544
00:37:28 51292 8192000000 10244445392 10695438336 1297043504 13.668 96 13 26 0 1315543936 15752608 2747824
00:39:21 55365 8192000000 10264033744 10709430272 1321394688 13.889 97 11 22 0 1337465536 13794960 2275888
00:41:19 69414 8192000000 10286996384 10735996928 1367928240 14.308 99 20 40 0 1390831072 18035136 4867696
00:43:29 83067 8192000000 10275930816 10730991616 1320124480 13.878 96 13 26 0 1342213840 19098544 2990816
00:45:58 47512 8192000000 10305476224 10749853696 1384890672 14.460 100 21 42 0 1409746800 19415840 5440288
00:47:57 12705 8192000000 10306551104 10746470400 1391300640 14.517 100 34 68 0 1408402192 9659344 7442208
00:49:12 14834 8192000000 10307710544 10748370944 1377303056 14.392 99 33 66 0 1397114592 12253984 7557552
00:50:28 92891 8192000000 10298862512 10763046912 1368141856 14.310 98 11 20 0 1383740864 13027872 2571136
00:53:06 57605 8192000000 10303756208 10760138752 1381036784 14.426 99 32 62 1 1397223024 9196752 6989488
00:55:10 4057 8192000000 10305032144 10761015296 1400807568 14.602 100 28 56 0 1421072608 14349136 5915904
00:56:21 36054 8192000000 10293508768 10749014016 1379318656 14.410 98 29 58 0 1393435856 7995952 6121248
00:58:02 43936 8192000000 10295598112 10755182592 1398543488 14.582 100 17 33 0 1411993312 9887616 3562208
00:59:47 78462 8192000000 10294523184 10759897088 1395811008 14.558 100 13 26 0 1411002960 11973072 3218880
01:02:13 59493 8192000000 10285590096 10740224000 1341766864 14.073 96 11 22 0 1354272016 10519584 1985568
01:04:18 43981 8192000000 10296166064 10749022208 1365903680 14.290 98 15 30 0 1382126864 13082864 3140320
01:06:32 39381 8192000000 10250062784 10692284416 1321417344 13.890 96 31 62 0 1340176304 11754848 7004112
01:08:12 23946 8192000000 10248481472 10687299584 1294838656 13.648 95 33 66 0 1310358400 8324400 7195344
01:09:38 14240 8192000000 9065697136 9269972992 226807200 2.694 17 1 2 0 229087248 2237696 42352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 07-04-2024 01:10:51 to 07-04-2024 01:11:05.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-04-2024 01:11:06 to 07-04-2024 01:11:08.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          178419
MON$OLDEST_ACTIVE               178420
MON$OLDEST_SNAPSHOT             178420
MON$NEXT_TRANSACTION            178420
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1907680
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Apr  7 01:11:09 2024 
 
Database header page information: 
    Flags            0 
    Generation        92829 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    178419 
    Oldest active        178420 
    Oldest snapshot        178420 
    Next transaction    178421 
    Sequence number        0 
    Next attachment ID    719 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.25, total records: 7772151 
    Average version length: 48.16, total versions: 105023, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 53, data page slots: 86376 
    Data pages: 86376, average fill: 72% 
    Primary pages: 86376, secondary pages: 0, swept pages: 14829 
    Empty pages: 4, full pages: 74221 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 175 
    40 - 59% = 2087 
    60 - 79% = 84075 
    80 - 99% = 18 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23512, nodes: 7772151 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1744809, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 400 
        20 - 39% = 1842 
        40 - 59% = 4282 
        60 - 79% = 2502 
        80 - 99% = 14486 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13619, nodes: 7772151 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1566370, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1575 
        40 - 59% = 2150 
        60 - 79% = 1139 
        80 - 99% = 8755 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8414, nodes: 7772151 
    Average node length: 6.61, total dup: 5815792, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1559411, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 949 
        40 - 59% = 1484 
        60 - 79% = 953 
        80 - 99% = 4894 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.05, total records: 2247037 
    Average version length: 34.64, total versions: 105723, max versions: 3 
    Average fragment length: 3.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28184 
    Data pages: 28184, average fill: 74% 
    Primary pages: 28177, secondary pages: 7, swept pages: 8604 
    Empty pages: 7, full pages: 23827 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 152 
    40 - 59% = 1938 
    60 - 79% = 24973 
    80 - 99% = 1098 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4586, nodes: 2247037 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708291, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 900 
        40 - 59% = 909 
        60 - 79% = 764 
        80 - 99% = 2012 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2511, nodes: 2250062 
    Average node length: 4.97, total dup: 2249163, max dup: 18260 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253539, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 249 
        40 - 59% = 1523 
        60 - 79% = 552 
        80 - 99% = 185 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2028, nodes: 2247037 
    Average node length: 4.97, total dup: 2246987, max dup: 130478 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053698, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 152 
        40 - 59% = 997 
        60 - 79% = 65 
        80 - 99% = 811 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4375, nodes: 2247037 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708291, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 555 
        40 - 59% = 658 
        60 - 79% = 868 
        80 - 99% = 2180 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.08, total records: 400 
    Average version length: 22.93, total versions: 246930, max versions: 646 
    Average fragment length: 2.06, total fragments: 66, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1368 
    Data pages: 1368, average fill: 90% 
    Primary pages: 8, secondary pages: 1360, swept pages: 0 
    Empty pages: 1, full pages: 1366 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1366 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 7.66, total records: 64243 
    Average version length: 68.29, total versions: 57040, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 2008 
    Data pages: 1615, average fill: 50% 
    Primary pages: 1614, secondary pages: 1, swept pages: 0 
    Empty pages: 320, full pages: 477 
    Fill distribution: 
     0 - 19% = 406 
    20 - 39% = 196 
    40 - 59% = 299 
    60 - 79% = 288 
    80 - 99% = 426 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1825115, depth: 3, leaf buckets: 275, nodes: 64243 
    Average node length: 13.04, total dup: 3871, max dup: 2 
    Average key length: 10.83, compression ratio: 2.49 
    Average prefix length: 19.11, average data length: 7.89 
    Clustering factor: 47215, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 173 
        40 - 59% = 91 
        60 - 79% = 9 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 17775, max versions: 940 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.89, total records: 1254 
    Average version length: 43.19, total versions: 1172, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 20.04 
    Pointer pages: 1, data page slots: 40 
    Data pages: 27, average fill: 47% 
    Primary pages: 26, secondary pages: 1, swept pages: 0 
    Empty pages: 1, full pages: 6 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93687, depth: 2, leaf buckets: 4, nodes: 1254 
    Average node length: 4.74, total dup: 1156, max dup: 131 
    Average key length: 2.84, compression ratio: 6.68 
    Average prefix length: 18.23, average data length: 0.77 
    Clustering factor: 725, ratio: 0.58 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 76 
    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: 53% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 76 
    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: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.61, total records: 822337 
    Average version length: 25.32, total versions: 89650, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 6, data page slots: 8232 
    Data pages: 8232, average fill: 71% 
    Primary pages: 8204, secondary pages: 28, swept pages: 1038 
    Empty pages: 30, full pages: 7044 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 109 
    40 - 59% = 251 
    60 - 79% = 7464 
    80 - 99% = 338 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 907, nodes: 822337 
    Average node length: 4.87, total dup: 822288, max dup: 149965 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91780, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 549 
        60 - 79% = 193 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1006, nodes: 822337 
    Average node length: 5.88, total dup: 732267, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163948, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 108 
        40 - 59% = 535 
        60 - 79% = 107 
        80 - 99% = 255 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1043, nodes: 822337 
    Average node length: 5.88, total dup: 732267, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165951, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 215 
        40 - 59% = 473 
        60 - 79% = 83 
        80 - 99% = 272 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1158, nodes: 822337 
    Average node length: 5.96, total dup: 732267, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158851, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 217 
        40 - 59% = 650 
        60 - 79% = 212 
        80 - 99% = 77 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.85, total records: 5494 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.59, total fragments: 59, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 96, average fill: 57% 
    Primary pages: 75, secondary pages: 21, swept pages: 54 
    Empty pages: 13, full pages: 63 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5494 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.49, average data length: 1.54 
    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: 1504233, depth: 2, leaf buckets: 10, nodes: 5494 
    Average node length: 11.11, 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: 140, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 81107 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 780 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 781 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34750, depth: 2, leaf buckets: 104, nodes: 81107 
    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: 2932, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.62, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 133.93, total records: 181093 
    Average version length: 154.35, total versions: 20429, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.66 
    Pointer pages: 7, data page slots: 6272 
    Data pages: 4368, average fill: 86% 
    Primary pages: 4367, secondary pages: 1, swept pages: 1 
    Empty pages: 59, full pages: 4292 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4294 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 131.90, total records: 186248 
    Average version length: 154.55, total versions: 23415, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.86 
    Pointer pages: 6, data page slots: 5856 
    Data pages: 4528, average fill: 86% 
    Primary pages: 4527, secondary pages: 1, swept pages: 2 
    Empty pages: 86, full pages: 4401 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 11 
    40 - 59% = 11 
    60 - 79% = 15 
    80 - 99% = 4401 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 134.33, total records: 202824 
    Average version length: 154.28, total versions: 22609, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.63 
    Pointer pages: 7, data page slots: 7072 
    Data pages: 4952, average fill: 85% 
    Primary pages: 4952, secondary pages: 0, swept pages: 2 
    Empty pages: 112, full pages: 4799 
    Fill distribution: 
     0 - 19% = 114 
    20 - 39% = 13 
    40 - 59% = 15 
    60 - 79% = 10 
    80 - 99% = 4800 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 143.37, total records: 179329 
    Average version length: 152.04, total versions: 9208, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 7, data page slots: 5608 
    Data pages: 4376, average fill: 85% 
    Primary pages: 4376, secondary pages: 0, swept pages: 3 
    Empty pages: 104, full pages: 4239 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 14 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4238 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.11, total records: 146407 
    Average version length: 152.30, total versions: 5167, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 6, data page slots: 5760 
    Data pages: 3616, average fill: 83% 
    Primary pages: 3616, secondary pages: 0, swept pages: 4 
    Empty pages: 141, full pages: 3448 
    Fill distribution: 
     0 - 19% = 147 
    20 - 39% = 11 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3447 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.82, total records: 179057 
    Average version length: 151.65, total versions: 3941, 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: 5312 
    Data pages: 4368, average fill: 85% 
    Primary pages: 4367, secondary pages: 1, swept pages: 8 
    Empty pages: 103, full pages: 4232 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 13 
    40 - 59% = 5 
    60 - 79% = 15 
    80 - 99% = 4228 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 146.67, total records: 185830 
    Average version length: 151.59, total versions: 5518, 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: 6, data page slots: 4832 
    Data pages: 4480, average fill: 86% 
    Primary pages: 4480, secondary pages: 0, swept pages: 1 
    Empty pages: 67, full pages: 4401 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4401 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 177032 
    Average version length: 151.35, total versions: 5376, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 4976 
    Data pages: 4248, average fill: 86% 
    Primary pages: 4248, secondary pages: 0, swept pages: 4 
    Empty pages: 41, full pages: 4184 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 11 
    40 - 59% = 2 
    60 - 79% = 10 
    80 - 99% = 4182 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.17, total records: 178400 
    Average version length: 151.22, total versions: 4712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 6008 
    Data pages: 4328, average fill: 85% 
    Primary pages: 4328, secondary pages: 0, swept pages: 9 
    Empty pages: 85, full pages: 4219 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 4219 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 144.99, total records: 180277 
    Average version length: 152.88, total versions: 7449, 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: 5280 
    Data pages: 4352, average fill: 86% 
    Primary pages: 4352, secondary pages: 0, swept pages: 7 
    Empty pages: 66, full pages: 4271 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4271 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.53, total records: 2106603 
    Average version length: 52.88, total versions: 48605, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25384 
    Data pages: 25384, average fill: 71% 
    Primary pages: 25384, secondary pages: 0, swept pages: 9613 
    Empty pages: 281, full pages: 21661 
    Fill distribution: 
     0 - 19% = 535 
    20 - 39% = 398 
    40 - 59% = 887 
    60 - 79% = 23135 
    80 - 99% = 429 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2583, nodes: 2106603 
    Average node length: 5.44, total dup: 1966450, max dup: 1416 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182905, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 279 
        40 - 59% = 1704 
        60 - 79% = 308 
        80 - 99% = 290 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2753, nodes: 2106603 
    Average node length: 5.69, total dup: 1891285, max dup: 85 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 377217, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2399 
        60 - 79% = 311 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2163, nodes: 2106603 
    Average node length: 4.96, total dup: 2106503, max dup: 27651 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180279, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 202 
        40 - 59% = 1145 
        60 - 79% = 409 
        80 - 99% = 401 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 35.82, total records: 167648 
    Average version length: 69.19, total versions: 80876, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.52 
    Pointer pages: 3, data page slots: 3808 
    Data pages: 3048, average fill: 64% 
    Primary pages: 3048, secondary pages: 0, swept pages: 290 
    Empty pages: 407, full pages: 2145 
    Fill distribution: 
     0 - 19% = 564 
    20 - 39% = 102 
    40 - 59% = 77 
    60 - 79% = 865 
    80 - 99% = 1440 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553408, depth: 3, leaf buckets: 236, nodes: 167648 
    Average node length: 6.46, total dup: 145859, max dup: 14 
    Average key length: 3.92, compression ratio: 10.71 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 28760, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 23 
        40 - 59% = 114 
        60 - 79% = 72 
        80 - 99% = 25 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.25, total records: 7339340 
    Average version length: 68.79, total versions: 607565, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 65, data page slots: 104624 
    Data pages: 104624, average fill: 75% 
    Primary pages: 104624, secondary pages: 0, swept pages: 15889 
    Empty pages: 11, full pages: 89103 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 880 
    40 - 59% = 5191 
    60 - 79% = 87162 
    80 - 99% = 11306 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10767, nodes: 7339340 
    Average node length: 6.51, total dup: 6348480, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1636853, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1329 
        40 - 59% = 5758 
        60 - 79% = 3053 
        80 - 99% = 622 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8794, nodes: 7339340 
    Average node length: 5.39, total dup: 7051384, max dup: 176 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1425495, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1079 
        40 - 59% = 5057 
        60 - 79% = 1642 
        80 - 99% = 1007 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8819, nodes: 7339340 
    Average node length: 5.39, total dup: 7051384, max dup: 176 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1428029, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1111 
        40 - 59% = 5032 
        60 - 79% = 1641 
        80 - 99% = 1027 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.13, total records: 12333397 
    Average version length: 68.70, total versions: 504309, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 105, data page slots: 170976 
    Data pages: 170976, average fill: 77% 
    Primary pages: 170976, secondary pages: 0, swept pages: 64177 
    Empty pages: 6, full pages: 162585 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 519 
    40 - 59% = 2777 
    60 - 79% = 157055 
    80 - 99% = 10555 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18424, nodes: 12333397 
    Average node length: 6.59, total dup: 10751075, max dup: 78 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2415057, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1847 
        40 - 59% = 10669 
        60 - 79% = 5032 
        80 - 99% = 852 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 38.67, total records: 1847162 
    Average version length: 69.13, total versions: 814312, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.26 
    Pointer pages: 25, data page slots: 40176 
    Data pages: 28032, average fill: 76% 
    Primary pages: 28032, secondary pages: 0, swept pages: 3146 
    Empty pages: 1286, full pages: 23811 
    Fill distribution: 
     0 - 19% = 1911 
    20 - 39% = 746 
    40 - 59% = 895 
    60 - 79% = 10468 
    80 - 99% = 14012 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2209, nodes: 1847162 
    Average node length: 5.50, total dup: 1773245, max dup: 99 
    Average key length: 2.54, compression ratio: 16.51 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 122918, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 276 
        40 - 59% = 1025 
        60 - 79% = 649 
        80 - 99% = 251 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.00, total records: 1098370 
    Average version length: 69.12, total versions: 541315, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.60 
    Pointer pages: 21, data page slots: 32952 
    Data pages: 27504, average fill: 47% 
    Primary pages: 27504, secondary pages: 0, swept pages: 5383 
    Empty pages: 6346, full pages: 12980 
    Fill distribution: 
     0 - 19% = 10714 
    20 - 39% = 1702 
    40 - 59% = 868 
    60 - 79% = 5363 
    80 - 99% = 8857 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1537, nodes: 1098370 
    Average node length: 5.77, total dup: 1027912, max dup: 99 
    Average key length: 2.84, compression ratio: 14.81 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 140462, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 401 
        40 - 59% = 677 
        60 - 79% = 369 
        80 - 99% = 84 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.11, total records: 9251626 
    Average version length: 68.97, total versions: 509468, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 88, data page slots: 142288 
    Data pages: 142248, average fill: 70% 
    Primary pages: 142248, secondary pages: 0, swept pages: 45536 
    Empty pages: 245, full pages: 95435 
    Fill distribution: 
     0 - 19% = 1255 
    20 - 39% = 8292 
    40 - 59% = 20112 
    60 - 79% = 102267 
    80 - 99% = 10322 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13471, nodes: 9251626 
    Average node length: 6.67, total dup: 7677492, max dup: 25 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2021479, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1244 
        40 - 59% = 6841 
        60 - 79% = 4667 
        80 - 99% = 717 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21164936 
    Average version length: 82.90, total versions: 17720, 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: 318800 
    Data pages: 318800, average fill: 81% 
    Primary pages: 318800, secondary pages: 0, swept pages: 11495 
    Empty pages: 0, full pages: 318799 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 26849 
    80 - 99% = 291950 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19574, nodes: 21164936 
    Average node length: 5.72, total dup: 20683499, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283557, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 8482 
        60 - 79% = 564 
        80 - 99% = 10519 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17193, nodes: 21164936 
    Average node length: 6.31, total dup: 18599021, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914834, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 801 
        60 - 79% = 278 
        80 - 99% = 16107 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21322, nodes: 21164936 
    Average node length: 6.35, total dup: 18518408, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578386, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8689 
        60 - 79% = 624 
        80 - 99% = 12005 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16159, nodes: 21164936 
    Average node length: 5.56, total dup: 21164836, max dup: 229417 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943759, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2936 
        60 - 79% = 457 
        80 - 99% = 12755 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.42, total records: 9665220 
    Average version length: 82.61, total versions: 468465, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 170592 
    Data pages: 170528, average fill: 70% 
    Primary pages: 170528, secondary pages: 0, swept pages: 71883 
    Empty pages: 692, full pages: 104705 
    Fill distribution: 
     0 - 19% = 2268 
    20 - 39% = 9593 
    40 - 59% = 26040 
    60 - 79% = 62297 
    80 - 99% = 70330 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11358, nodes: 9665220 
    Average node length: 5.36, total dup: 9358132, max dup: 201 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2126270, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 80 
        40 - 59% = 8362 
        60 - 79% = 2857 
        80 - 99% = 56 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13520, nodes: 9665220 
    Average node length: 6.23, total dup: 8015216, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1478490, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 3667 
        40 - 59% = 4709 
        60 - 79% = 2726 
        80 - 99% = 2268 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12678, nodes: 9665220 
    Average node length: 5.98, total dup: 8390834, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2319914, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 102 
        40 - 59% = 9329 
        60 - 79% = 3154 
        80 - 99% = 91 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10143, nodes: 9665220 
    Average node length: 5.13, total dup: 9665120, max dup: 149649 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1513434, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1246 
        40 - 59% = 5077 
        60 - 79% = 1760 
        80 - 99% = 2008 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.71, total records: 11253543 
    Average version length: 82.54, total versions: 354304, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 118, data page slots: 191072 
    Data pages: 189504, average fill: 73% 
    Primary pages: 189504, secondary pages: 0, swept pages: 68558 
    Empty pages: 3342, full pages: 144340 
    Fill distribution: 
     0 - 19% = 5605 
    20 - 39% = 7684 
    40 - 59% = 16899 
    60 - 79% = 40263 
    80 - 99% = 119053 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13112, nodes: 11253543 
    Average node length: 5.29, total dup: 11143979, max dup: 628 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2339675, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 127 
        40 - 59% = 9340 
        60 - 79% = 3541 
        80 - 99% = 103 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10412, nodes: 11253543 
    Average node length: 5.49, total dup: 10763138, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 698209, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 855 
        40 - 59% = 2564 
        60 - 79% = 1875 
        80 - 99% = 4960 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14999, nodes: 11253543 
    Average node length: 6.01, total dup: 9822899, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2356112, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 163 
        40 - 59% = 10866 
        60 - 79% = 3860 
        80 - 99% = 105 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10727, nodes: 11253543 
    Average node length: 5.21, total dup: 11253443, max dup: 192002 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 687216, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 813 
        40 - 59% = 4774 
        60 - 79% = 1534 
        80 - 99% = 3499 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.95, total records: 9756328 
    Average version length: 82.91, total versions: 446994, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 107, data page slots: 173608 
    Data pages: 173560, average fill: 70% 
    Primary pages: 173560, secondary pages: 0, swept pages: 76985 
    Empty pages: 776, full pages: 102812 
    Fill distribution: 
     0 - 19% = 2408 
    20 - 39% = 9844 
    40 - 59% = 27157 
    60 - 79% = 66982 
    80 - 99% = 67169 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11774, nodes: 9756328 
    Average node length: 5.17, total dup: 9727748, max dup: 1988 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1950626, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1514 
        40 - 59% = 7727 
        60 - 79% = 1875 
        80 - 99% = 615 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13637, nodes: 9756328 
    Average node length: 6.24, total dup: 8090708, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1450471, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 193 
        20 - 39% = 3676 
        40 - 59% = 4680 
        60 - 79% = 2721 
        80 - 99% = 2367 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12330, nodes: 9756328 
    Average node length: 5.43, total dup: 9322856, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2082830, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1470 
        40 - 59% = 8509 
        60 - 79% = 1720 
        80 - 99% = 607 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10266, nodes: 9756328 
    Average node length: 5.14, total dup: 9756228, max dup: 152008 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1532737, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1271 
        40 - 59% = 5144 
        60 - 79% = 1791 
        80 - 99% = 2008 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.33, total records: 574252 
    Average version length: 68.83, total versions: 7076, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 75% 
    Primary pages: 7976, secondary pages: 0, swept pages: 3833 
    Empty pages: 6, full pages: 6702 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 13 
    40 - 59% = 225 
    60 - 79% = 7609 
    80 - 99% = 122 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 47418, depth: 3, leaf buckets: 733, nodes: 574252 
    Average node length: 5.95, total dup: 488952, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100092, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 505 
        60 - 79% = 100 
        80 - 99% = 91 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 37395, depth: 3, leaf buckets: 757, nodes: 574252 
    Average node length: 6.15, total dup: 471008, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100169, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 37 
        40 - 59% = 518 
        60 - 79% = 102 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 578, nodes: 574252 
    Average node length: 4.86, total dup: 574152, max dup: 9432 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88852, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 336 
        60 - 79% = 103 
        80 - 99% = 104 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Apr  7 01:11:33 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7772151 105023 1 0.0000 0.0000
DOC_LIST 2247037 105723 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 246930 646 61700.0000 0.0000
INVNT_TURNOVER_LOG 64243 57040 1 0.0000 0.0000
MONEY_SALDO 49 17775 940 36200.0000 0.0000
MONEY_TURNOVER_LOG 1254 1172 1 0.0000 0.0000
PDISTR 822337 89650 4 0.0000 0.0000
PERF_SPLIT_0 181093 20429 1 0.0000 0.0000
PERF_SPLIT_1 186248 23415 1 0.0000 0.0000
PERF_SPLIT_2 202824 22609 1 0.0000 0.0000
PERF_SPLIT_3 179329 9208 1 0.0000 0.0000
PERF_SPLIT_4 146407 5167 1 0.0000 0.0000
PERF_SPLIT_5 179057 3941 1 0.0000 0.0000
PERF_SPLIT_6 185830 5518 1 0.0000 0.0000
PERF_SPLIT_7 177032 5376 1 0.0000 0.0000
PERF_SPLIT_8 178400 4712 1 0.0000 0.0000
PERF_SPLIT_9 180277 7449 1 0.0000 0.0000
PSTORNED 2106603 48605 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 167648 80876 1 0.0000 0.0000
XQD_1000_3300 7339340 607565 1 0.0000 0.0000
XQD_1200_2000 12333397 504309 1 0.0000 0.0000
XQD_2000_3300 1847162 814312 1 0.0000 0.0000
XQD_2100_3300 1098370 541315 1 0.0000 0.0000
XQD_3300_3400 9251626 509468 1 0.0000 0.0000
XQS_1000_1200 21164936 17720 1 0.0000 0.0000
XQS_1000_3300 9665220 468465 1 0.0000 0.0000
XQS_1200_2000 11253543 354304 1 0.0000 0.0000
XQS_2100_3300 9756328 446994 1 0.0000 0.0000
XQS_3300_3400 574252 7076 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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