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

Server and database settinfs 


SERVER_MODE                     SuperServer 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-02-27 01:09:37
DTS_END                         2024-02-27 01:09:37.7590
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54176
TRN_ID                          177176
ATT_ID                          547
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: 9659.47 20862 965947
customer order: creation 175.27 367 17527
customer order: refuse 15.06 371 1506
order to supplier: creation 47.34 1274 4734
order to supplier: removal 3.89 95185 389
invoice (draft): creation 46.53 3469 4653
invoice (draft): removal 55.09 719 5509
invoice accept: apply 42.04 20932 4204
invoice accept: cancel 49.18 801 4918
customer reserve: creation 4067.87 198 406787
customer reserve: removal 4849.56 61 484956
realization accept: apply 86.20 213 8620
realization accept: cancel 89.08 115 8908
payment from customer: creation 61.19 152 6119
payment from customer: removal 5.91 122 591
payment to supplier: creation 49.15 168 4915
payment to supplier: removal 3.48 76 348
service: total inventory turnovers 4.88 1059 488
service: total monetary turnovers 6.89 28 689
service: aggregate perf. data 0.83 22256 83
service: refresh index statistics 0.03 269683 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2682
TEST_TIME 2 3276
TEST_TIME 3 3357
TEST_TIME 4 3608
TEST_TIME 5 4173
TEST_TIME 6 4874
TEST_TIME 7 4656
TEST_TIME 8 5254
TEST_TIME 9 5235
TEST_TIME 10 5445
TEST_TIME 11 5553
TEST_TIME 12 5712
TEST_TIME 13 5884
TEST_TIME 14 5949
TEST_TIME 15 6151
TEST_TIME 16 6446
TEST_TIME 17 6749
TEST_TIME 18 6909
TEST_TIME 19 7076
TEST_TIME 20 7246
TEST_TIME 21 7275
TEST_TIME 22 7610
TEST_TIME 23 7732
TEST_TIME 24 7723
TEST_TIME 25 8030
TEST_TIME 26 8074
TEST_TIME 27 8081
TEST_TIME 28 8967
TEST_TIME 29 9731
TEST_TIME 30 9569
TEST_TIME 31 9553
TEST_TIME 32 9594
TEST_TIME 33 9684
TEST_TIME 34 9575
TEST_TIME 35 9374
TEST_TIME 36 9370
TEST_TIME 37 9471
TEST_TIME 38 9425
TEST_TIME 39 9302
TEST_TIME 40 9330
TEST_TIME 41 9333
TEST_TIME 42 9530
TEST_TIME 43 9439
TEST_TIME 44 9409
TEST_TIME 45 9302
TEST_TIME 46 9211
TEST_TIME 47 9153
TEST_TIME 48 9053
TEST_TIME 49 9033
TEST_TIME 50 9116
TEST_TIME 51 9121
TEST_TIME 52 9218
TEST_TIME 53 9188
TEST_TIME 54 9263
TEST_TIME 55 9284
TEST_TIME 56 9343
TEST_TIME 57 9415
TEST_TIME 58 9413
TEST_TIME 59 9396
TEST_TIME 60 9475
TEST_TIME 61 9497
TEST_TIME 62 9556
TEST_TIME 63 9612
TEST_TIME 64 9488
TEST_TIME 65 9407
TEST_TIME 66 9363
TEST_TIME 67 9362
TEST_TIME 68 9299
TEST_TIME 69 9292
TEST_TIME 70 9315
TEST_TIME 71 9277
TEST_TIME 72 9446
TEST_TIME 73 9478
TEST_TIME 74 9436
TEST_TIME 75 9465
TEST_TIME 76 9501
TEST_TIME 77 9565
TEST_TIME 78 9536
TEST_TIME 79 9676
TEST_TIME 80 9762
TEST_TIME 81 9726
TEST_TIME 82 9835
TEST_TIME 83 9866
TEST_TIME 84 9818
TEST_TIME 85 9751
TEST_TIME 86 9709
TEST_TIME 87 9689
TEST_TIME 88 9661
TEST_TIME 89 9632
TEST_TIME 90 9645
TEST_TIME 91 9615
TEST_TIME 92 9540
TEST_TIME 93 9566
TEST_TIME 94 9605
TEST_TIME 95 9599
TEST_TIME 96 9592
TEST_TIME 97 9615
TEST_TIME 98 9678
TEST_TIME 99 9703
TEST_TIME 100 9665

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-02-2024 01:10:41 to 27-02-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 1338132 1338132 0 0.00 0 34083 7 0 0
doc_list_biud 1338129 1338129 0 0.00 0 60975 28 0 0
sp_add_invoice_to_stock 4310 4204 106 2.45 34 169449 20933 0 106
sp_cancel_adding_invoice 4918 4918 0 0.00 5 68320 802 0 0
sp_cancel_client_order 1506 1506 0 0.00 4 9174 371 0 0
sp_cancel_customer_reserve 484956 484956 0 0.00 0 60977 61 0 0
sp_cancel_pay_from_customer 591 591 0 0.00 2 21667 122 0 0
sp_cancel_pay_to_supplier 348 348 0 0.00 3 2999 76 0 0
sp_cancel_supplier_invoice 5513 5509 4 0.07 2 15764 720 0 4
sp_cancel_supplier_order 389 389 0 0.00 8 1034318 95185 0 0
sp_cancel_write_off 8908 8908 0 0.00 1 19266 115 0 0
sp_client_order 17527 17527 0 0.00 3 27040 367 0 0
sp_customer_reserve 406787 406787 0 0.00 0 44027 199 0 0
sp_fill_shopping_cart 26906 26906 0 0.00 1 10133 36 0 0
sp_fill_shopping_cart_clo_res 406782 406782 0 0.00 0 20656 15 0 0
sp_get_clo_for_invoice 4197 4197 0 0.00 0 16740 281 0 0
sp_kill_cost_storno 14765 14765 0 0.00 0 22661 65 0 0
sp_kill_qstorno_ret_qs2qd 984718 984718 0 0.00 0 60972 33 0 0
sp_kill_qty_storno 519002 519002 0 0.00 0 60975 71 0 0
sp_lock_selected_doc 17844 17844 0 0.00 0 9698 5 0 0
sp_make_cost_storno 23851 23851 0 0.00 0 27552 77 0 0
sp_multiply_rows_for_pdistr 23850 23850 0 0.00 0 22479 39 0 0
sp_multiply_rows_for_qdistr 17527 17527 0 0.00 0 10143 155 0 0
sp_pay_from_customer 6119 6119 0 0.00 4 22453 153 0 0
sp_pay_to_supplier 4915 4915 0 0.00 5 22573 169 0 0
sp_payment_common 11033 11033 0 0.00 1 22554 47 0 0
sp_qd_handle_on_cancel_clo 1506 1506 0 0.00 0 9141 343 0 0
sp_qd_handle_on_invoice_upd_sts 9115 9115 0 0.00 0 18865 340 0 0
sp_qd_handle_on_reserve_upd_sts 8619 8619 0 0.00 0 16985 60 0 0
sp_reserve_write_off 8620 8620 0 0.00 6 26730 213 0 0
sp_supplier_invoice 4653 4653 0 0.00 6 89939 3470 0 0
sp_supplier_order 4734 4734 0 0.00 5 25419 1274 0 0
srv_aggregate_perf_data 83 83 0 0.00 1817 259914 22257 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1234 130636 36732 0 0
srv_find_qd_qs_mism 922586 922586 0 0.00 0 13848 6 0 0
srv_make_invnt_saldo 488 488 0 0.00 40 27541 1060 0 0
srv_make_money_saldo 689 689 0 0.00 0 1295 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 244214 288690 269683 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4204 4204 0 0.00 0 11826 188 0 0
t$perf-norm:sp_cancel_adding_invoice 350 350 0 0.00 0 3033 107 0 0
t$perf-norm:sp_cancel_client_order 1506 1506 0 0.00 0 4263 16 0 0
t$perf-norm:sp_cancel_customer_reserve 591 591 0 0.00 0 1103 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 591 591 0 0.00 0 1220 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 348 348 0 0.00 0 4701 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 369 369 0 0.00 0 9506 44 0 0
t$perf-norm:sp_cancel_supplier_order 389 389 0 0.00 0 20511 1855 0 0
t$perf-norm:sp_cancel_write_off 887 887 0 0.00 0 2859 15 0 0
t$perf-norm:sp_client_order 17527 17527 0 0.00 0 16225 18 0 0
t$perf-norm:sp_customer_reserve 847 847 0 0.00 0 2703 11 0 0
t$perf-norm:sp_pay_from_customer 6119 6119 0 0.00 0 5718 12 0 0
t$perf-norm:sp_pay_to_supplier 4915 4915 0 0.00 0 3374 9 0 0
t$perf-norm:sp_reserve_write_off 8620 8620 0 0.00 0 3914 11 0 0
t$perf-norm:sp_supplier_invoice 4653 4653 0 0.00 0 4869 21 0 0
t$perf-norm:sp_supplier_order 4734 4734 0 0.00 0 5429 15 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 305 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 385 12 0 0
t$perf-norm:srv_make_invnt_saldo 488 488 0 0.00 0 6312 38 0 0
t$perf-norm:srv_make_money_saldo 689 689 0 0.00 0 1647 27 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 18 11 0 0
v_add_invoice_to_stock 8604 8392 212 2.46 0 4380 18 0 212
v_all_customers 32940 32940 0 0.00 0 200 1 0 0
v_all_suppliers 26540 26540 0 0.00 0 25 1 0 0
v_all_wares 35054 35054 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 700 700 0 0.00 0 594 6 0 0
v_cancel_client_order 3012 3012 0 0.00 0 1937 5 0 0
v_cancel_customer_prepayment 1182 1182 0 0.00 0 711 4 0 0
v_cancel_customer_reserve 1182 1182 0 0.00 0 4460 9 0 0
v_cancel_payment_to_supplier 696 696 0 0.00 0 2123 9 0 0
v_cancel_supplier_invoice 746 738 8 1.07 0 4425 25 0 8
v_cancel_supplier_order 778 778 0 0.00 0 291 4 0 0
v_cancel_write_off 1774 1774 0 0.00 0 1714 15 0 0
v_max_id_clo_ord 4730 4730 0 0.00 0 198 1 0 0
v_max_id_clo_res 847 847 0 0.00 0 943 9 0 0
v_max_id_ord_sup 4649 4649 0 0.00 0 7023 4 0 0
v_max_non_paid_invoice 1023 1023 0 0.00 0 380 3 0 0
v_max_non_paid_realizn 2832 2832 0 0.00 0 4658 10 0 0
v_min_id_clo_ord 4730 4730 0 0.00 0 5681 11 0 0
v_min_id_clo_res 847 847 0 0.00 0 3393 14 0 0
v_min_id_ord_sup 4649 4649 0 0.00 0 9583 9 0 0
v_min_non_paid_invoice 4914 4914 0 0.00 0 22545 30 0 0
v_min_non_paid_realizn 6119 6119 0 0.00 0 22375 45 0 0
v_our_firm 8688 8688 0 0.00 0 18 1 0 0
v_reserve_write_off 17234 17234 0 0.00 0 6943 6 0 0
x_lock_depdocs_on_canc_invoice 10058 10058 0 0.00 0 8601 119 0 0
x_lock_depdocs_on_canc_sup_ord 389 389 0 0.00 0 10709 400 0 0
x_make_qstorno_1000_1200 4734 4734 0 0.00 1 25405 1188 0 0
x_make_qstorno_1200_2000 4653 4653 0 0.00 3 89630 3349 0 0
x_make_qstorno_2100_3300 406787 406787 0 0.00 0 44026 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-02-2024 01:10:45 to 27-02-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:41 6 8192000000 8798878256 8810233856 5304288 0.064 2 1 2 0 5403888 56816 42784
23:10:42 45668 8192000000 9930401392 10244993024 1003336720 10.911 100 89 178 0 1031464288 5844576 22282992
23:12:33 16173 8192000000 9957485248 10279141376 1036544528 11.231 100 91 182 0 1068811920 9441584 22825808
23:13:55 15463 8192000000 9990786704 10329305088 1076375728 11.613 100 85 170 0 1107924288 10614944 20933616
23:15:14 11210 8192000000 10017215664 10363965440 1108649536 11.920 100 85 168 1 1140112208 11216576 20246096
23:16:38 4338 8192000000 10072947936 10435432448 1163625472 12.437 100 70 140 0 1191924864 12477712 15821680
23:17:46 4158 8192000000 10127204864 10499280896 1216350400 12.928 100 77 154 0 1247074528 13410800 17313328
23:18:53 1568 8192000000 10160245728 10533351424 1245754176 13.199 100 84 162 0 1276311072 13302032 17254864
23:19:57 1308 8192000000 10197953280 10579468288 1281140896 13.523 100 92 182 0 1315185136 14246784 19797456
23:21:01 1699 8192000000 10213727296 10604441600 1304074656 13.732 100 74 144 4 1330996224 11569360 15352208
23:22:04 2973 8192000000 10205001584 10611937280 1309501616 13.782 100 50 100 0 1330104720 9215936 11387168
23:23:11 5387 8192000000 10203184656 10615140352 1315231376 13.834 100 23 46 0 1326579200 6068224 5279600
23:24:17 5937 8192000000 10205202256 10623057920 1320283856 13.879 100 23 47 0 1331932176 5950032 5698288
23:25:29 9198 8192000000 10216326784 10634469376 1327601952 13.945 100 20 42 1 1338284000 6554960 4127088
23:26:40 24025 8192000000 10244846688 10647986176 1332077728 13.986 100 59 119 0 1352082032 6879360 13124944
23:28:04 7467 8192000000 10229059216 10649735168 1336570608 14.026 100 31 62 0 1349901680 6178496 7152576
23:29:12 8082 8192000000 10212466272 10633699328 1316471008 13.845 99 13 24 0 1324896240 5347152 3078080
23:30:28 5505 8192000000 10210653152 10618294272 1300928976 13.704 99 38 70 1 1317492960 7949536 8614448
23:31:42 41107 8192000000 10242364592 10647203840 1316220496 13.842 99 59 118 1 1341185296 11571968 13392832
23:33:44 18496 8192000000 10252138992 10663641088 1344030128 14.094 100 42 84 1 1363569136 9732560 9806448
23:35:36 12540 8192000000 10233212992 10645028864 1291871856 13.621 96 43 85 3 1312954880 11108320 9974704
23:36:55 13260 8192000000 10248492208 10659807232 1338777792 14.046 100 49 98 1 1365994352 15026048 12190512
23:38:13 6868 8192000000 10250405840 10655985664 1333452848 13.998 100 54 107 0 1362886768 17432960 12000960
23:39:27 20604 8192000000 10229646368 10635157504 1286861376 13.576 97 41 81 0 1312805200 16376288 9567536
23:41:03 8690 8192000000 10227930656 10630680576 1295921088 13.658 98 43 84 0 1328920480 22608400 10390992
23:42:21 9051 8192000000 10255117952 10645860352 1320649120 13.883 100 73 144 1 1361105872 23114592 17342160
23:43:39 1232 8192000000 10279593984 10671349760 1340900080 14.066 100 83 165 1 1384617584 24457264 19260240
23:44:44 5659 8192000000 10291095376 10689970176 1348080304 14.130 100 73 145 1 1394244992 28179664 17985024
23:45:58 2286 8192000000 10302537776 10704744448 1358747648 14.226 100 78 157 1 1409515424 31480160 19287616
23:47:03 2267 8192000000 10327387680 10734645248 1376129280 14.382 100 79 156 0 1429289280 34647840 18512160
23:48:09 4699 8192000000 10338908176 10753138688 1393708912 14.539 100 62 124 0 1444521360 35602768 15209680
23:49:23 9794 8192000000 10354154192 10771636224 1405721568 14.646 100 60 120 0 1458938704 38140192 15076944
23:50:37 3890 8192000000 10382185840 10793881600 1419936448 14.772 100 78 155 1 1484426688 45160480 19329760
23:51:47 1487 8192000000 10368471632 10794463232 1417907296 14.754 100 54 105 1 1472577104 40430496 14239312
23:52:50 15906 8192000000 10362398208 10795233280 1417553792 14.751 100 34 66 0 1468377376 41566048 9257536
23:54:11 22071 8192000000 10372833440 10806087680 1424373184 14.811 100 34 68 0 1481829392 48340656 9115552
23:56:26 28150 8192000000 10349979952 10798055424 1400767792 14.602 100 18 36 1 1456309664 49842928 5698944
23:57:59 28711 8192000000 10324323328 10773823488 1382608064 14.440 99 21 42 0 1424592784 36997776 4986944
23:59:32 46954 8192000000 10338237424 10775511040 1403653920 14.628 100 26 52 0 1423704688 13785280 6265488
00:01:25 29088 8192000000 10323836512 10772205568 1407804720 14.664 100 21 40 2 1422952016 10172224 4975072
00:02:55 130635 8192000000 10337172352 10785214464 1411252080 14.695 100 33 67 1 1426916336 8482512 7181744
00:06:08 76168 8192000000 10307289728 10775576576 1389822896 14.504 98 20 39 0 1403890576 9793552 4274128
00:08:26 3357 8192000000 10310686672 10778345472 1410930960 14.692 100 16 32 0 1423944656 9170768 3842928
00:09:35 35581 8192000000 10354603904 10800386048 1426372272 14.829 100 41 82 0 1450307008 14847312 9087424
00:11:15 52562 8192000000 10321175616 10803773440 1422963824 14.799 100 12 24 1 1443045168 17088352 2992992
00:13:27 12400 8192000000 10299394880 10756857856 1388364384 14.491 99 23 44 0 1403467360 10281456 4821520
00:14:40 67577 8192000000 10264936752 10723893248 1315265824 13.834 94 23 47 0 1327751360 7311920 5173616
00:16:58 34629 8192000000 10280307136 10729230336 1353351376 14.178 97 39 77 1 1369952208 7697760 8903072
00:18:36 13969 8192000000 10280052096 10726383616 1369248896 14.320 100 41 80 0 1387429840 9364080 8816864
00:19:51 47648 8192000000 10246665504 10703695872 1337073424 14.031 98 16 30 1 1349261424 9069936 3118064
00:21:40 40484 8192000000 10271936448 10723495936 1346317920 14.114 99 30 60 0 1360507792 7689632 6500240
00:23:21 39289 8192000000 10269771168 10701910016 1333105776 13.995 98 32 64 0 1351984800 11968944 6910080
00:25:04 25774 8192000000 10245874736 10675879936 1275625488 13.473 95 40 79 0 1295867232 11774144 8467600
00:26:31 38720 8192000000 10242749136 10685968384 1310310672 13.789 98 19 39 0 1321674368 7135376 4228320
00:28:14 22290 8192000000 10261126336 10689400832 1338407728 14.043 100 53 104 0 1361964976 11907808 11649440
00:29:37 97668 8192000000 10245932368 10685775872 1288394480 13.590 96 26 52 0 1305209344 11031968 5782896
00:32:15 62890 8192000000 10244498752 10693857280 1332433856 13.989 99 21 42 1 1352814304 15315200 5065248
00:34:54 34575 8192000000 10228410640 10673750016 1324648864 13.919 99 14 28 0 1340124544 12270032 3205648
00:36:30 41183 8192000000 10236647920 10690449408 1333473408 13.999 100 11 22 0 1349214688 13451216 2290064
00:38:19 63577 8192000000 10249689088 10700570624 1346265968 14.114 100 15 30 0 1363689952 13727808 3696176
00:40:23 49289 8192000000 10282585824 10727514112 1364251760 14.276 99 28 57 0 1385213920 14406176 6555984
00:42:42 58383 8192000000 10282436112 10730029056 1366317968 14.294 99 17 34 0 1378386128 8408544 3659616
00:44:50 28346 8192000000 10317551088 10753282048 1391304672 14.518 100 40 78 0 1410148320 10301184 8542464
00:46:22 65244 8192000000 10307094464 10771525632 1376982368 14.390 98 13 26 0 1399682640 19662880 3037392
00:48:27 112045 8192000000 10314833008 10783821824 1400935472 14.603 100 12 24 0 1429708592 26225744 2547376
00:51:20 98210 8192000000 10330711568 10799673344 1403028480 14.622 99 18 36 0 1431623488 24531440 4063568
00:54:15 106056 8192000000 10308531344 10764173312 1370096992 14.328 96 21 41 0 1385804656 11105088 4602576
00:57:04 17242 8192000000 10311672368 10758389760 1385895952 14.469 99 45 87 1 1405897840 9686544 10315344
00:58:22 50743 8192000000 10290605536 10759938048 1375584544 14.377 99 8 16 0 1394242400 16597088 2060768
01:00:13 53016 8192000000 10272648304 10724687872 1359407888 14.232 99 15 30 0 1373656960 10802640 3446432
01:02:10 43645 8192000000 10286207440 10750779392 1383238208 14.445 100 10 20 0 1397187808 11673328 2276272
01:03:54 58283 8192000000 10298792320 10753769472 1368903200 14.317 98 18 36 0 1381454080 8443056 4107824
01:05:56 49940 8192000000 10272977424 10735157248 1342086400 14.076 97 17 34 0 1364421616 17872624 4462592
01:07:48 31514 8192000000 10265429520 10708045824 1314698800 13.829 96 20 39 0 1328366336 9501616 4165920
01:09:21 29075 8192000000 8959498992 9117859840 130265760 1.565 10 2 4 0 132311296 1710272 335264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-02-2024 01:11:06 to 27-02-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          177921
MON$OLDEST_ACTIVE               177922
MON$OLDEST_SNAPSHOT             177922
MON$NEXT_TRANSACTION            177922
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                       1917600
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 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 Tue Feb 27 01:11:09 2024 
 
Database header page information: 
    Flags            0 
    Generation        92849 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    177921 
    Oldest active        177922 
    Oldest snapshot        177922 
    Next transaction    177923 
    Sequence number        0 
    Next attachment ID    720 
    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.03, total records: 7750383 
    Average version length: 48.16, total versions: 139318, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86904 
    Data pages: 86904, average fill: 71% 
    Primary pages: 86904, secondary pages: 0, swept pages: 14786 
    Empty pages: 1, full pages: 66676 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 178 
    40 - 59% = 2782 
    60 - 79% = 83877 
    80 - 99% = 56 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23483, nodes: 7750383 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1710284, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 382 
        20 - 39% = 1717 
        40 - 59% = 4440 
        60 - 79% = 2701 
        80 - 99% = 14243 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13607, nodes: 7750383 
    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: 1532876, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1532 
        40 - 59% = 2218 
        60 - 79% = 1222 
        80 - 99% = 8635 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8430, nodes: 7750383 
    Average node length: 6.61, total dup: 5804897, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1526044, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 885 
        40 - 59% = 1563 
        60 - 79% = 1043 
        80 - 99% = 4780 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.53, total records: 2236180 
    Average version length: 34.38, total versions: 143162, max versions: 3 
    Average fragment length: 3.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28376 
    Data pages: 28376, average fill: 73% 
    Primary pages: 28370, secondary pages: 6, swept pages: 7494 
    Empty pages: 5, full pages: 20441 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 115 
    40 - 59% = 1666 
    60 - 79% = 25420 
    80 - 99% = 1157 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4594, nodes: 2236180 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 693307, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 882 
        40 - 59% = 940 
        60 - 79% = 824 
        80 - 99% = 1948 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2521, nodes: 2239140 
    Average node length: 4.97, total dup: 2238241, max dup: 19332 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245941, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 266 
        40 - 59% = 1542 
        60 - 79% = 549 
        80 - 99% = 163 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2039, nodes: 2236180 
    Average node length: 4.97, total dup: 2236130, max dup: 130389 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056851, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 99 
        40 - 59% = 1059 
        60 - 79% = 53 
        80 - 99% = 823 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4373, nodes: 2236180 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 693307, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 534 
        40 - 59% = 717 
        60 - 79% = 917 
        80 - 99% = 2100 
 
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.30, total records: 400 
    Average version length: 22.89, total versions: 240747, max versions: 630 
    Average fragment length: 2.00, total fragments: 53, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1344 
    Data pages: 1344, average fill: 89% 
    Primary pages: 14, secondary pages: 1330, swept pages: 0 
    Empty pages: 7, full pages: 1336 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1336 
 
    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: 6.44, total records: 87934 
    Average version length: 68.30, total versions: 79644, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 13.66 
    Pointer pages: 7, data page slots: 2528 
    Data pages: 1856, average fill: 60% 
    Primary pages: 1855, secondary pages: 1, swept pages: 0 
    Empty pages: 231, full pages: 879 
    Fill distribution: 
     0 - 19% = 318 
    20 - 39% = 217 
    40 - 59% = 238 
    60 - 79% = 330 
    80 - 99% = 753 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707912, depth: 3, leaf buckets: 385, nodes: 87934 
    Average node length: 13.33, total dup: 6759, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 63499, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 267 
        40 - 59% = 107 
        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.20, total records: 49 
    Average version length: 9.00, total versions: 18003, max versions: 966 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 90% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 61 
 
    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: 4.46, total records: 1391 
    Average version length: 43.35, total versions: 1252, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 13.00 
    Pointer pages: 1, data page slots: 40 
    Data pages: 39, average fill: 35% 
    Primary pages: 38, secondary pages: 1, swept pages: 4 
    Empty pages: 16, full pages: 7 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90452, depth: 2, leaf buckets: 2, nodes: 1391 
    Average node length: 4.36, total dup: 1293, max dup: 152 
    Average key length: 2.75, compression ratio: 6.92 
    Average prefix length: 18.32, average data length: 0.68 
    Clustering factor: 765, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.00, total records: 75 
    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: 52% 
    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: 75 
    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.96, total records: 858543 
    Average version length: 25.32, total versions: 79530, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8368 
    Data pages: 8368, average fill: 72% 
    Primary pages: 8354, secondary pages: 14, swept pages: 1130 
    Empty pages: 20, full pages: 8026 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 14 
    40 - 59% = 53 
    60 - 79% = 7930 
    80 - 99% = 339 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 938, nodes: 858543 
    Average node length: 4.88, total dup: 858494, max dup: 162948 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92993, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 116 
        40 - 59% = 529 
        60 - 79% = 230 
        80 - 99% = 60 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1045, nodes: 858543 
    Average node length: 5.89, total dup: 764212, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 169478, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 75 
        40 - 59% = 603 
        60 - 79% = 108 
        80 - 99% = 253 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1074, nodes: 858543 
    Average node length: 5.89, total dup: 764212, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 171454, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 193 
        40 - 59% = 525 
        60 - 79% = 84 
        80 - 99% = 271 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1196, nodes: 858543 
    Average node length: 5.97, total dup: 764212, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 163331, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 234 
        40 - 59% = 643 
        60 - 79% = 204 
        80 - 99% = 111 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5469 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.79, total fragments: 42, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 120 
    Data pages: 112, average fill: 48% 
    Primary pages: 91, secondary pages: 21, swept pages: 49 
    Empty pages: 27, full pages: 64 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5469 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.43, average data length: 1.54 
    Clustering factor: 5095, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5469 
    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: 135, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.15, total records: 81087 
    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: 2, full pages: 781 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 781 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38820, depth: 2, leaf buckets: 105, nodes: 81087 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3407, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, 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.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 140.16, total records: 188642 
    Average version length: 153.79, total versions: 13683, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.10 
    Pointer pages: 7, data page slots: 5240 
    Data pages: 4536, average fill: 86% 
    Primary pages: 4536, secondary pages: 0, swept pages: 1 
    Empty pages: 50, full pages: 4468 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4468 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 143.47, total records: 169487 
    Average version length: 152.10, total versions: 8248, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.82 
    Pointer pages: 8, data page slots: 6016 
    Data pages: 4152, average fill: 84% 
    Primary pages: 4152, secondary pages: 0, swept pages: 2 
    Empty pages: 120, full pages: 3993 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 8 
    40 - 59% = 12 
    60 - 79% = 14 
    80 - 99% = 3993 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 127.97, total records: 201181 
    Average version length: 154.05, total versions: 30599, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.25 
    Pointer pages: 6, data page slots: 5624 
    Data pages: 4912, average fill: 86% 
    Primary pages: 4912, secondary pages: 0, swept pages: 1 
    Empty pages: 122, full pages: 4763 
    Fill distribution: 
     0 - 19% = 126 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 4761 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.30, total records: 189993 
    Average version length: 148.95, total versions: 3716, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 6208 
    Data pages: 4608, average fill: 85% 
    Primary pages: 4608, secondary pages: 0, swept pages: 4 
    Empty pages: 89, full pages: 4490 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 4491 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 140.78, total records: 159906 
    Average version length: 152.21, total versions: 10604, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 6, data page slots: 5536 
    Data pages: 3872, average fill: 85% 
    Primary pages: 3872, secondary pages: 0, swept pages: 3 
    Empty pages: 62, full pages: 3758 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 7 
    40 - 59% = 25 
    60 - 79% = 18 
    80 - 99% = 3757 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 144.86, total records: 187511 
    Average version length: 152.40, total versions: 7608, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 7, data page slots: 5784 
    Data pages: 4480, average fill: 86% 
    Primary pages: 4480, secondary pages: 0, swept pages: 2 
    Empty pages: 33, full pages: 4435 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4435 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 141.54, total records: 180391 
    Average version length: 151.70, total versions: 11003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.98 
    Pointer pages: 7, data page slots: 5232 
    Data pages: 4360, average fill: 86% 
    Primary pages: 4360, secondary pages: 0, swept pages: 5 
    Empty pages: 82, full pages: 4259 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4256 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.00, total records: 176274 
    Average version length: 151.96, total versions: 5848, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 5584 
    Data pages: 4288, average fill: 85% 
    Primary pages: 4288, secondary pages: 0, swept pages: 1 
    Empty pages: 99, full pages: 4166 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4168 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 135.19, total records: 182998 
    Average version length: 153.98, total versions: 18976, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.55 
    Pointer pages: 6, data page slots: 6912 
    Data pages: 4424, average fill: 86% 
    Primary pages: 4424, secondary pages: 0, swept pages: 3 
    Empty pages: 70, full pages: 4323 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 12 
    80 - 99% = 4323 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 139.29, total records: 175967 
    Average version length: 153.84, total versions: 13457, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.18 
    Pointer pages: 7, data page slots: 5704 
    Data pages: 4280, average fill: 85% 
    Primary pages: 4280, secondary pages: 0, swept pages: 2 
    Empty pages: 97, full pages: 4157 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 4158 
 
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.37, total records: 2073909 
    Average version length: 52.95, total versions: 53906, 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: 25472 
    Data pages: 25464, average fill: 70% 
    Primary pages: 25464, secondary pages: 0, swept pages: 10455 
    Empty pages: 365, full pages: 20292 
    Fill distribution: 
     0 - 19% = 681 
    20 - 39% = 582 
    40 - 59% = 1235 
    60 - 79% = 22510 
    80 - 99% = 456 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2576, nodes: 2073909 
    Average node length: 5.44, total dup: 1934440, max dup: 1602 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181112, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 316 
        40 - 59% = 1691 
        60 - 79% = 272 
        80 - 99% = 290 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2756, nodes: 2073909 
    Average node length: 5.69, total dup: 1861315, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372241, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2464 
        60 - 79% = 265 
        80 - 99% = 19 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2145, nodes: 2073909 
    Average node length: 4.96, total dup: 2073809, max dup: 28139 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178719, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 223 
        40 - 59% = 1150 
        60 - 79% = 374 
        80 - 99% = 394 
 
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: 37.02, total records: 156146 
    Average version length: 69.19, total versions: 72662, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.40 
    Pointer pages: 3, data page slots: 4016 
    Data pages: 2976, average fill: 61% 
    Primary pages: 2976, secondary pages: 0, swept pages: 409 
    Empty pages: 546, full pages: 1955 
    Fill distribution: 
     0 - 19% = 683 
    20 - 39% = 37 
    40 - 59% = 85 
    60 - 79% = 882 
    80 - 99% = 1289 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104740, depth: 3, leaf buckets: 223, nodes: 156146 
    Average node length: 6.46, total dup: 135874, max dup: 14 
    Average key length: 3.93, compression ratio: 10.68 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 26442, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 116 
        60 - 79% = 63 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.73, total records: 7593563 
    Average version length: 68.75, total versions: 575685, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 65, data page slots: 105344 
    Data pages: 105344, average fill: 77% 
    Primary pages: 105344, secondary pages: 0, swept pages: 16560 
    Empty pages: 5, full pages: 99509 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 207 
    40 - 59% = 1580 
    60 - 79% = 90151 
    80 - 99% = 13386 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10839, nodes: 7593563 
    Average node length: 6.51, total dup: 6568462, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1670829, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1256 
        40 - 59% = 5367 
        60 - 79% = 3395 
        80 - 99% = 817 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8904, nodes: 7593563 
    Average node length: 5.39, total dup: 7300393, max dup: 163 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1453136, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 929 
        40 - 59% = 5006 
        60 - 79% = 1811 
        80 - 99% = 1141 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8959, nodes: 7593563 
    Average node length: 5.39, total dup: 7300393, max dup: 163 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1455633, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 974 
        40 - 59% = 5009 
        60 - 79% = 1858 
        80 - 99% = 1111 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.69, total records: 12521462 
    Average version length: 68.71, total versions: 410583, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 105, data page slots: 171344 
    Data pages: 171344, average fill: 78% 
    Primary pages: 171344, secondary pages: 0, swept pages: 68110 
    Empty pages: 7, full pages: 171217 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 10 
    60 - 79% = 160919 
    80 - 99% = 10407 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18469, nodes: 12521462 
    Average node length: 6.61, total dup: 10909829, max dup: 73 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2428192, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1867 
        40 - 59% = 10175 
        60 - 79% = 5325 
        80 - 99% = 1082 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 34.63, total records: 1889763 
    Average version length: 69.14, total versions: 943373, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.64 
    Pointer pages: 28, data page slots: 43120 
    Data pages: 28264, average fill: 78% 
    Primary pages: 28264, secondary pages: 0, swept pages: 2653 
    Empty pages: 1043, full pages: 24812 
    Fill distribution: 
     0 - 19% = 1887 
    20 - 39% = 672 
    40 - 59% = 423 
    60 - 79% = 9071 
    80 - 99% = 16211 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2297, nodes: 1889763 
    Average node length: 5.51, total dup: 1814102, max dup: 99 
    Average key length: 2.54, compression ratio: 16.51 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 126409, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 311 
        40 - 59% = 1130 
        60 - 79% = 613 
        80 - 99% = 232 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.54, total records: 1290659 
    Average version length: 69.14, total versions: 644921, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.65 
    Pointer pages: 23, data page slots: 36416 
    Data pages: 28192, average fill: 54% 
    Primary pages: 28191, secondary pages: 1, swept pages: 5543 
    Empty pages: 5795, full pages: 15754 
    Fill distribution: 
     0 - 19% = 8428 
    20 - 39% = 1487 
    40 - 59% = 1168 
    60 - 79% = 6870 
    80 - 99% = 10239 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1682, nodes: 1290659 
    Average node length: 5.80, total dup: 1203837, max dup: 99 
    Average key length: 2.86, compression ratio: 14.68 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 182352, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 231 
        40 - 59% = 828 
        60 - 79% = 498 
        80 - 99% = 122 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.34, total records: 9205334 
    Average version length: 68.95, total versions: 742672, 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: 89, data page slots: 144112 
    Data pages: 144056, average fill: 69% 
    Primary pages: 144056, secondary pages: 0, swept pages: 39120 
    Empty pages: 275, full pages: 80331 
    Fill distribution: 
     0 - 19% = 1038 
    20 - 39% = 6334 
    40 - 59% = 25054 
    60 - 79% = 98796 
    80 - 99% = 12834 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13494, nodes: 9205334 
    Average node length: 6.68, total dup: 7635901, max dup: 17 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1966065, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1413 
        40 - 59% = 6763 
        60 - 79% = 4581 
        80 - 99% = 735 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21171401 
    Average version length: 82.99, total versions: 19452, 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: 318904 
    Data pages: 318904, average fill: 81% 
    Primary pages: 318904, secondary pages: 0, swept pages: 11681 
    Empty pages: 4, full pages: 318899 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 26941 
    80 - 99% = 291958 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19545, nodes: 21171401 
    Average node length: 5.72, total dup: 20689945, max dup: 155 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283786, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8443 
        60 - 79% = 551 
        80 - 99% = 10544 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17209, nodes: 21171401 
    Average node length: 6.31, total dup: 18604485, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914818, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 6 
        40 - 59% = 812 
        60 - 79% = 267 
        80 - 99% = 16119 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21364, nodes: 21171401 
    Average node length: 6.35, total dup: 18524415, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578947, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8794 
        60 - 79% = 610 
        80 - 99% = 11956 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16188, nodes: 21171401 
    Average node length: 5.56, total dup: 21171301, max dup: 231777 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943694, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 8 
        40 - 59% = 2999 
        60 - 79% = 432 
        80 - 99% = 12745 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.44, total records: 9611475 
    Average version length: 82.63, total versions: 696216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 105, data page slots: 170968 
    Data pages: 170928, average fill: 70% 
    Primary pages: 170928, secondary pages: 0, swept pages: 57586 
    Empty pages: 742, full pages: 96722 
    Fill distribution: 
     0 - 19% = 2160 
    20 - 39% = 8217 
    40 - 59% = 27890 
    60 - 79% = 68414 
    80 - 99% = 64247 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11345, nodes: 9611475 
    Average node length: 5.37, total dup: 9302589, max dup: 213 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2091478, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 76 
        40 - 59% = 8335 
        60 - 79% = 2875 
        80 - 99% = 58 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13731, nodes: 9611475 
    Average node length: 6.24, total dup: 7969485, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1440354, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 4028 
        40 - 59% = 4842 
        60 - 79% = 2624 
        80 - 99% = 2089 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12671, nodes: 9611475 
    Average node length: 5.99, total dup: 8341778, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2288264, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 115 
        40 - 59% = 9278 
        60 - 79% = 3191 
        80 - 99% = 86 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10190, nodes: 9611475 
    Average node length: 5.14, total dup: 9611375, max dup: 159750 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1486380, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1313 
        40 - 59% = 5196 
        60 - 79% = 1621 
        80 - 99% = 2008 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.13, total records: 11184340 
    Average version length: 82.59, total versions: 565786, 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: 119, data page slots: 192768 
    Data pages: 191256, average fill: 72% 
    Primary pages: 191256, secondary pages: 0, swept pages: 68913 
    Empty pages: 3590, full pages: 139318 
    Fill distribution: 
     0 - 19% = 6197 
    20 - 39% = 8729 
    40 - 59% = 19527 
    60 - 79% = 41462 
    80 - 99% = 115341 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13108, nodes: 11184340 
    Average node length: 5.30, total dup: 11074432, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2327886, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 175 
        40 - 59% = 9213 
        60 - 79% = 3595 
        80 - 99% = 124 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10487, nodes: 11184340 
    Average node length: 5.50, total dup: 10696176, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 698413, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 903 
        40 - 59% = 2715 
        60 - 79% = 1880 
        80 - 99% = 4833 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14998, nodes: 11184340 
    Average node length: 6.03, total dup: 9755376, max dup: 76 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2344244, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 225 
        40 - 59% = 10791 
        60 - 79% = 3832 
        80 - 99% = 148 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10743, nodes: 11184340 
    Average node length: 5.22, total dup: 11184240, max dup: 191915 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 687356, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 918 
        40 - 59% = 4741 
        60 - 79% = 1567 
        80 - 99% = 3417 
 
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: 76.87, total records: 9714879 
    Average version length: 82.92, total versions: 688453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 107, data page slots: 174192 
    Data pages: 174120, average fill: 69% 
    Primary pages: 174120, secondary pages: 0, swept pages: 60263 
    Empty pages: 838, full pages: 96624 
    Fill distribution: 
     0 - 19% = 2293 
    20 - 39% = 8626 
    40 - 59% = 29048 
    60 - 79% = 71320 
    80 - 99% = 62833 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11697, nodes: 9714879 
    Average node length: 5.18, total dup: 9686333, max dup: 2168 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1928822, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1517 
        40 - 59% = 7535 
        60 - 79% = 2005 
        80 - 99% = 607 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13842, nodes: 9714879 
    Average node length: 6.25, total dup: 8054438, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1417847, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 209 
        20 - 39% = 4015 
        40 - 59% = 4743 
        60 - 79% = 2630 
        80 - 99% = 2245 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12350, nodes: 9714879 
    Average node length: 5.43, total dup: 9282316, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2061143, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1485 
        40 - 59% = 8468 
        60 - 79% = 1818 
        80 - 99% = 550 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10310, nodes: 9714879 
    Average node length: 5.15, total dup: 9714779, max dup: 161968 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1512248, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1381 
        40 - 59% = 5194 
        60 - 79% = 1642 
        80 - 99% = 2042 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.32, total records: 570819 
    Average version length: 68.84, total versions: 7055, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7992 
    Data pages: 7992, average fill: 75% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3714 
    Empty pages: 0, full pages: 6529 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 52 
    40 - 59% = 273 
    60 - 79% = 7558 
    80 - 99% = 102 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40824, depth: 3, leaf buckets: 727, nodes: 570819 
    Average node length: 5.95, total dup: 485879, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99504, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 523 
        60 - 79% = 89 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28310, depth: 3, leaf buckets: 753, nodes: 570819 
    Average node length: 6.15, total dup: 468059, max dup: 29 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99557, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 535 
        60 - 79% = 89 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 570, nodes: 570819 
    Average node length: 4.86, total dup: 570719, max dup: 9871 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88470, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 317 
        60 - 79% = 90 
        80 - 99% = 119 
 
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 Tue Feb 27 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 7750383 139318 1 0.0000 0.0000
DOC_LIST 2236180 143162 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 240747 630 60100.0000 0.0000
INVNT_TURNOVER_LOG 87934 79644 1 0.0000 0.0000
MONEY_SALDO 49 18003 966 36700.0000 0.0000
MONEY_TURNOVER_LOG 1391 1252 1 0.0000 0.0000
PDISTR 858543 79530 4 0.0000 0.0000
PERF_SPLIT_0 188642 13683 1 0.0000 0.0000
PERF_SPLIT_1 169487 8248 1 0.0000 0.0000
PERF_SPLIT_2 201181 30599 1 0.0000 0.0000
PERF_SPLIT_3 189993 3716 1 0.0000 0.0000
PERF_SPLIT_4 159906 10604 1 0.0000 0.0000
PERF_SPLIT_5 187511 7608 1 0.0000 0.0000
PERF_SPLIT_6 180391 11003 1 0.0000 0.0000
PERF_SPLIT_7 176274 5848 1 0.0000 0.0000
PERF_SPLIT_8 182998 18976 1 0.0000 0.0000
PERF_SPLIT_9 175967 13457 1 0.0000 0.0000
PSTORNED 2073909 53906 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 156146 72662 1 0.0000 0.0000
XQD_1000_3300 7593563 575685 1 0.0000 0.0000
XQD_1200_2000 12521462 410583 1 0.0000 0.0000
XQD_2000_3300 1889763 943373 1 0.0000 0.0000
XQD_2100_3300 1290659 644921 1 0.0000 0.0000
XQD_3300_3400 9205334 742672 1 0.0000 0.0000
XQS_1000_1200 21171401 19452 1 0.0000 0.0000
XQS_1000_3300 9611475 696216 1 0.0000 0.0000
XQS_1200_2000 11184340 565786 1 0.0000 0.0000
XQS_2100_3300 9714879 688453 1 0.0000 0.0000
XQS_3300_3400 570819 7055 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 ---
:1219: 
:1220: mscs-test-161.budzdorov.ru    Tue Feb 27 01:09:52 2024
:1221:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1222: 
:1223: 
:1224: mscs-test-161.budzdorov.ru    Tue Feb 27 01:09:52 2024
:1225:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1226: 
--- end of diff output ---

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

27.02.24 01:11:45. 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-02-27 01:11:47 No severe PSQL-related problems occured
27.02.24 01:11:49. End of report.