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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-01 16:09:36
DTS_END                         2024-04-01 16:09:36.9000
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53578
TRN_ID                          174413
ATT_ID                          606
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: 9067.25 21310 906725
customer order: creation 176.54 360 17654
customer order: refuse 15.19 386 1519
order to supplier: creation 46.24 1393 4624
order to supplier: removal 3.60 86595 360
invoice (draft): creation 48.13 3519 4813
invoice (draft): removal 48.54 707 4854
invoice accept: apply 42.34 20983 4234
invoice accept: cancel 43.73 788 4373
customer reserve: creation 4044.79 202 404479
customer reserve: removal 4298.27 57 429827
realization accept: apply 86.33 195 8633
realization accept: cancel 81.53 121 8153
payment from customer: creation 60.77 116 6077
payment from customer: removal 6.06 102 606
payment to supplier: creation 49.33 136 4933
payment to supplier: removal 3.31 60 331
service: total inventory turnovers 4.90 983 490
service: total monetary turnovers 6.82 24 682
service: aggregate perf. data 0.80 18135 80
service: refresh index statistics 0.03 291341 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2734
TEST_TIME 2 3308
TEST_TIME 3 3992
TEST_TIME 4 3751
TEST_TIME 5 3569
TEST_TIME 6 3638
TEST_TIME 7 4602
TEST_TIME 8 5014
TEST_TIME 9 5202
TEST_TIME 10 5957
TEST_TIME 11 6081
TEST_TIME 12 5742
TEST_TIME 13 5645
TEST_TIME 14 5526
TEST_TIME 15 5481
TEST_TIME 16 5473
TEST_TIME 17 5607
TEST_TIME 18 5630
TEST_TIME 19 5896
TEST_TIME 20 6054
TEST_TIME 21 6245
TEST_TIME 22 6667
TEST_TIME 23 6564
TEST_TIME 24 6552
TEST_TIME 25 7002
TEST_TIME 26 7019
TEST_TIME 27 7599
TEST_TIME 28 7688
TEST_TIME 29 8064
TEST_TIME 30 8227
TEST_TIME 31 8352
TEST_TIME 32 8694
TEST_TIME 33 8618
TEST_TIME 34 8515
TEST_TIME 35 8450
TEST_TIME 36 8521
TEST_TIME 37 8414
TEST_TIME 38 8448
TEST_TIME 39 8410
TEST_TIME 40 8401
TEST_TIME 41 8433
TEST_TIME 42 8489
TEST_TIME 43 8413
TEST_TIME 44 8369
TEST_TIME 45 8350
TEST_TIME 46 8603
TEST_TIME 47 8589
TEST_TIME 48 8518
TEST_TIME 49 8810
TEST_TIME 50 8743
TEST_TIME 51 8799
TEST_TIME 52 8822
TEST_TIME 53 8922
TEST_TIME 54 8931
TEST_TIME 55 8867
TEST_TIME 56 8944
TEST_TIME 57 9056
TEST_TIME 58 9103
TEST_TIME 59 9061
TEST_TIME 60 8950
TEST_TIME 61 8865
TEST_TIME 62 8783
TEST_TIME 63 8865
TEST_TIME 64 8877
TEST_TIME 65 8861
TEST_TIME 66 8802
TEST_TIME 67 8737
TEST_TIME 68 8728
TEST_TIME 69 8871
TEST_TIME 70 8886
TEST_TIME 71 8855
TEST_TIME 72 8919
TEST_TIME 73 8932
TEST_TIME 74 8915
TEST_TIME 75 8944
TEST_TIME 76 8952
TEST_TIME 77 8987
TEST_TIME 78 8983
TEST_TIME 79 9106
TEST_TIME 80 9115
TEST_TIME 81 9128
TEST_TIME 82 9182
TEST_TIME 83 9128
TEST_TIME 84 9044
TEST_TIME 85 9094
TEST_TIME 86 9082
TEST_TIME 87 9064
TEST_TIME 88 9070
TEST_TIME 89 9034
TEST_TIME 90 9019
TEST_TIME 91 8954
TEST_TIME 92 8989
TEST_TIME 93 8954
TEST_TIME 94 8954
TEST_TIME 95 8987
TEST_TIME 96 9028
TEST_TIME 97 9015
TEST_TIME 98 9077
TEST_TIME 99 9065
TEST_TIME 100 9075

Performance per minute, chart


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

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 1277630 1277630 0 0.00 0 14785 8 0 0
doc_list_biud 1277629 1277629 0 0.00 0 69722 25 0 0
sp_add_invoice_to_stock 4276 4234 42 0.98 31 191795 20984 0 42
sp_cancel_adding_invoice 4373 4373 0 0.00 5 45696 789 0 0
sp_cancel_client_order 1519 1519 0 0.00 4 14237 386 0 0
sp_cancel_customer_reserve 429827 429827 0 0.00 0 54638 58 0 0
sp_cancel_pay_from_customer 606 606 0 0.00 2 9482 103 0 0
sp_cancel_pay_to_supplier 331 331 0 0.00 2 1228 61 0 0
sp_cancel_supplier_invoice 4857 4854 3 0.06 1 70855 707 0 3
sp_cancel_supplier_order 360 360 0 0.00 6 857658 86596 0 0
sp_cancel_write_off 8153 8153 0 0.00 1 12344 122 0 0
sp_client_order 17654 17654 0 0.00 3 23448 361 0 0
sp_customer_reserve 404479 404479 0 0.00 0 59126 203 0 0
sp_fill_shopping_cart 27084 27084 0 0.00 1 21296 38 0 0
sp_fill_shopping_cart_clo_res 404468 404468 0 0.00 0 14490 16 0 0
sp_get_clo_for_invoice 4220 4220 0 0.00 0 32611 304 0 0
sp_kill_cost_storno 13463 13463 0 0.00 0 6379 61 0 0
sp_kill_qstorno_ret_qs2qd 873021 873021 0 0.00 0 69720 31 0 0
sp_kill_qty_storno 461939 461939 0 0.00 0 69721 67 0 0
sp_lock_selected_doc 17796 17796 0 0.00 0 7179 5 0 0
sp_make_cost_storno 23863 23863 0 0.00 0 14758 68 0 0
sp_multiply_rows_for_pdistr 23863 23863 0 0.00 0 8125 31 0 0
sp_multiply_rows_for_qdistr 17654 17654 0 0.00 0 20367 178 0 0
sp_pay_from_customer 6077 6077 0 0.00 3 12605 117 0 0
sp_pay_to_supplier 4933 4933 0 0.00 5 13698 136 0 0
sp_payment_common 11010 11010 0 0.00 2 8339 34 0 0
sp_qd_handle_on_cancel_clo 1519 1519 0 0.00 0 14233 358 0 0
sp_qd_handle_on_invoice_upd_sts 8593 8593 0 0.00 0 26196 315 0 0
sp_qd_handle_on_reserve_upd_sts 8633 8633 0 0.00 0 19784 59 0 0
sp_reserve_write_off 8633 8633 0 0.00 6 19897 195 0 0
sp_supplier_invoice 4813 4813 0 0.00 6 101768 3519 0 0
sp_supplier_order 4624 4624 0 0.00 5 33252 1393 0 0
srv_aggregate_perf_data 80 80 0 0.00 1743 165587 18135 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1437 134222 39469 0 0
srv_find_qd_qs_mism 863817 863817 0 0.00 0 14679 7 0 0
srv_make_invnt_saldo 490 490 0 0.00 50 48166 983 0 0
srv_make_money_saldo 682 682 0 0.00 1 1062 25 0 0
srv_recalc_idx_stat 3 3 0 0.00 147273 503351 291341 0 0
t$perf-abend:sp_add_invoice_to_stock 42 42 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4235 4235 0 0.00 0 9947 154 0 0
t$perf-norm:sp_cancel_adding_invoice 344 344 0 0.00 0 7652 93 0 0
t$perf-norm:sp_cancel_client_order 1519 1519 0 0.00 0 3162 18 0 0
t$perf-norm:sp_cancel_customer_reserve 602 602 0 0.00 0 4617 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 606 606 0 0.00 0 1241 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 331 331 0 0.00 0 3146 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 343 343 0 0.00 0 2325 26 0 0
t$perf-norm:sp_cancel_supplier_order 360 360 0 0.00 0 13894 1225 0 0
t$perf-norm:sp_cancel_write_off 838 838 0 0.00 0 3412 18 0 0
t$perf-norm:sp_client_order 17654 17654 0 0.00 0 5621 16 0 0
t$perf-norm:sp_customer_reserve 856 856 0 0.00 0 1699 9 0 0
t$perf-norm:sp_pay_from_customer 6077 6077 0 0.00 0 7491 10 0 0
t$perf-norm:sp_pay_to_supplier 4933 4933 0 0.00 0 7941 11 0 0
t$perf-norm:sp_reserve_write_off 8633 8633 0 0.00 0 7881 12 0 0
t$perf-norm:sp_supplier_invoice 4813 4813 0 0.00 0 7212 22 0 0
t$perf-norm:sp_supplier_order 4624 4624 0 0.00 0 7313 20 0 0
t$perf-norm:srv_aggregate_perf_data 80 80 0 0.00 0 272 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 251 6 0 0
t$perf-norm:srv_make_invnt_saldo 490 490 0 0.00 0 1937 23 0 0
t$perf-norm:srv_make_money_saldo 682 682 0 0.00 0 2052 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 8524 8440 84 0.98 0 7061 17 0 84
v_all_customers 32314 32314 0 0.00 0 20 0 0 0
v_all_suppliers 26684 26684 0 0.00 0 28 1 0 0
v_all_wares 35308 35308 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 688 688 0 0.00 0 414 6 0 0
v_cancel_client_order 3038 3038 0 0.00 0 2402 5 0 0
v_cancel_customer_prepayment 1212 1212 0 0.00 0 675 4 0 0
v_cancel_customer_reserve 1204 1204 0 0.00 0 411 3 0 0
v_cancel_payment_to_supplier 662 662 0 0.00 0 207 3 0 0
v_cancel_supplier_invoice 692 686 6 0.86 0 1087 12 0 6
v_cancel_supplier_order 720 720 0 0.00 0 7652 16 0 0
v_cancel_write_off 1676 1676 0 0.00 0 4480 17 0 0
v_max_id_clo_ord 4624 4624 0 0.00 0 3669 3 0 0
v_max_id_clo_res 856 856 0 0.00 0 1253 9 0 0
v_max_id_ord_sup 4806 4806 0 0.00 0 4420 4 0 0
v_max_non_paid_invoice 1021 1021 0 0.00 0 2117 6 0 0
v_max_non_paid_realizn 3147 3147 0 0.00 0 4149 4 0 0
v_min_id_clo_ord 4624 4624 0 0.00 0 13615 16 0 0
v_min_id_clo_res 856 856 0 0.00 0 549 3 0 0
v_min_id_ord_sup 4806 4806 0 0.00 0 21148 11 0 0
v_min_non_paid_invoice 4933 4933 0 0.00 0 7399 26 0 0
v_min_non_paid_realizn 6077 6077 0 0.00 0 6432 22 0 0
v_our_firm 8854 8854 0 0.00 0 17 1 0 0
v_reserve_write_off 17266 17266 0 0.00 0 5324 4 0 0
x_lock_depdocs_on_canc_invoice 8884 8884 0 0.00 0 20383 140 0 0
x_lock_depdocs_on_canc_sup_ord 360 360 0 0.00 0 7854 328 0 0
x_make_qstorno_1000_1200 4624 4624 0 0.00 1 33232 1306 0 0
x_make_qstorno_1200_2000 4813 4813 0 0.00 2 101749 3380 0 0
x_make_qstorno_2100_3300 404479 404479 0 0.00 0 59110 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-04-2024 16:10:42 to 01-04-2024 16:10:46.

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
14:09:40 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:41 27696 8192000000 9883052656 10188357632 962233456 10.511 100 91 183 0 992233008 5642784 24356768
14:12:14 20935 8192000000 9927085840 10242666496 1007647184 10.953 100 87 170 0 1038112544 7757392 22707968
14:13:43 13540 8192000000 9975428112 10304933888 1052721664 11.387 100 84 168 0 1082883408 9379808 20781936
14:15:00 7044 8192000000 10020820288 10365206528 1107244592 11.906 100 77 152 1 1136894160 11722128 17927440
14:16:13 4709 8192000000 10064400768 10419970048 1154331088 12.350 100 79 158 0 1185092720 12572496 18189136
14:17:23 3159 8192000000 10096541296 10462228480 1185983072 12.646 100 78 156 0 1216236096 12327728 17925296
14:18:28 2367 8192000000 10126096304 10501771264 1224041776 12.999 100 72 141 0 1251403728 12145344 15216608
14:19:32 1711 8192000000 10173196544 10550702080 1258626608 13.317 100 88 171 0 1289903552 12899744 18377200
14:20:36 1265 8192000000 10209614112 10592665600 1287885792 13.585 100 93 183 2 1322822992 14680176 20257024
14:21:38 26951 8192000000 10203818688 10605842432 1306208624 13.752 100 59 113 1 1326459328 7027328 13223376
14:23:07 7537 8192000000 10209584464 10622443520 1312594240 13.810 100 32 63 0 1334572992 15440752 6538000
14:24:17 14496 8192000000 10206545648 10629824512 1326020960 13.931 100 18 36 1 1335671472 5563744 4086768
14:25:32 9135 8192000000 10219876192 10640015360 1333907552 14.002 100 20 41 0 1344425872 5718128 4800192
14:26:42 57683 8192000000 10241334896 10654420992 1337876032 14.038 100 47 94 0 1355543184 5814064 11853088
14:28:41 7027 8192000000 10229894688 10659368960 1345223184 14.104 100 32 64 0 1359084288 5975776 7885328
14:29:48 37951 8192000000 10237131152 10649001984 1316551168 13.845 98 46 92 1 1333890848 6803904 10535776
14:31:36 41281 8192000000 10241741056 10662449152 1334068000 14.004 99 36 72 0 1355526192 12853760 8604432
14:33:21 91655 8192000000 10264827616 10685165568 1347399328 14.124 99 47 94 1 1370312400 12156864 10756208
14:36:05 39780 8192000000 10231148272 10642186240 1289686976 13.601 96 30 60 0 1310026560 13299280 7040304
14:37:48 16850 8192000000 10239171840 10652446720 1331307696 13.979 100 39 76 0 1352387664 12159424 8920544
14:39:11 18291 8192000000 10234945408 10650001408 1322899632 13.903 99 39 76 0 1344144960 12487104 8758224
14:40:44 54060 8192000000 10177927568 10580111360 1205555904 12.828 91 32 64 0 1222929072 10377392 6995776
14:42:46 9693 8192000000 10223149136 10633859072 1302081376 13.714 99 34 66 0 1332719920 22820592 7817952
14:44:10 7745 8192000000 10235419296 10640228352 1303768640 13.729 98 48 96 1 1337001904 21829408 11403856
14:45:21 6359 8192000000 10258629456 10667339776 1324120176 13.914 99 53 104 0 1364761152 27592640 13048336
14:46:32 5192 8192000000 10278313504 10687328256 1348371568 14.133 100 55 108 2 1391922000 29810032 13740400
14:47:45 3996 8192000000 10296759120 10700374016 1355421168 14.196 100 64 128 0 1403985328 32761232 15802928
14:48:52 3841 8192000000 10291533456 10700611584 1355216400 14.194 100 56 108 1 1403707056 34200352 14290304
14:50:05 1435 8192000000 10324072672 10725769216 1370479584 14.331 100 70 141 1 1426291472 38131024 17680864
14:51:10 2753 8192000000 10325254304 10737836032 1374877664 14.371 100 56 112 0 1433766336 45360992 13527680
14:52:21 17352 8192000000 10334893216 10752577536 1386060176 14.471 100 74 147 1 1447402144 42656496 18685472
14:54:11 20725 8192000000 10311475264 10758049792 1381841488 14.433 100 17 34 0 1433976640 47245584 4889568
14:55:40 2809 8192000000 10317234064 10736852992 1374162464 14.364 100 55 107 0 1423537552 35454512 13920576
14:56:45 31633 8192000000 10287224896 10726477824 1373228720 14.356 100 17 32 0 1409273648 31994608 4050320
14:58:22 18691 8192000000 10297139648 10731679744 1362457696 14.259 99 24 48 1 1393847024 24957744 6431584
14:59:51 22477 8192000000 10289741504 10735198208 1380625776 14.422 100 16 30 1 1400929296 16477312 3826208
15:01:27 34553 8192000000 10274808000 10720530432 1374500720 14.367 100 7 14 0 1389253152 13068768 1683664
15:03:05 32164 8192000000 10324841760 10752659456 1391259584 14.517 100 40 75 0 1408944400 9295888 8388928
15:04:41 134222 8192000000 10296774224 10740551680 1373005936 14.354 99 25 50 0 1389534784 10801360 5727488
15:07:58 20359 8192000000 10294802992 10742403072 1373840784 14.361 99 22 41 1 1392643008 14057008 4745216
15:09:23 6885 8192000000 10306588656 10741776384 1386067616 14.471 99 37 70 0 1404472192 10463424 7941152
15:10:33 17084 8192000000 10312026512 10761330688 1401563472 14.609 100 23 43 0 1420855840 14400144 4892224
15:12:26 46669 8192000000 10309623120 10759790592 1385815152 14.469 98 28 56 0 1408816032 15987296 7013584
15:14:14 45619 8192000000 10317314816 10771042304 1408781360 14.673 100 27 53 1 1434300256 18841216 6677680
15:16:17 61148 8192000000 10313648032 10767568896 1408274480 14.669 100 17 34 0 1425269104 13232688 3761936
15:18:19 77388 8192000000 10288134688 10732548096 1305670768 13.747 93 17 35 0 1317539056 7953968 3914320
15:20:40 40777 8192000000 10272552720 10709659648 1348408576 14.133 98 26 53 0 1365912816 10990112 6514128
15:22:29 76364 8192000000 10253171328 10696777728 1284282048 13.552 94 22 44 0 1305523504 16388864 4852592
15:24:47 24647 8192000000 10259034032 10696024064 1324794512 13.920 98 44 88 0 1349906400 15336368 9775520
15:26:16 44291 8192000000 10258957488 10695839744 1290141680 13.606 96 36 70 0 1314558528 16701904 7714944
15:28:02 118417 8192000000 10241268304 10679656448 1319819328 13.875 98 14 28 0 1337783120 14670752 3293040
15:31:02 8662 8192000000 10248492544 10683465728 1332681760 13.991 99 34 68 0 1348807184 8518960 7606464
15:32:13 70718 8192000000 10229348160 10684149760 1299111104 13.687 97 19 38 0 1321472464 17930192 4431168
15:34:41 33041 8192000000 10233081648 10666491904 1303871552 13.730 97 12 22 0 1318369552 12109216 2388784
15:36:14 61945 8192000000 10248828304 10691829760 1336988976 14.030 99 9 18 0 1353969344 14759648 2220720
15:38:28 70147 8192000000 10245554240 10690019328 1292810464 13.630 96 12 24 1 1309583600 14405680 2367456
15:40:41 47708 8192000000 10242899552 10683072512 1324875616 13.921 99 22 44 0 1339330656 9808336 4646704
15:42:29 43698 8192000000 10257545392 10693898240 1338939904 14.048 99 34 68 0 1356254400 10062528 7251968
15:44:24 8755 8192000000 10286531824 10714251264 1366964496 14.300 100 40 80 0 1386129056 10248368 8916192
15:45:34 7071 8192000000 10278471856 10705829888 1364137824 14.274 100 52 100 0 1385974336 10925488 10911024
15:46:47 31761 8192000000 10284148336 10713264128 1329545712 13.963 97 26 51 0 1344447424 9624576 5277136
15:48:21 55775 8192000000 10281680512 10734829568 1345111840 14.103 98 10 20 0 1363432080 16289568 2030672
15:50:18 107210 8192000000 10289694528 10745581568 1367273664 14.303 99 9 18 0 1385407840 16297664 1836512
15:53:05 113883 8192000000 10304306224 10760912896 1393365968 14.536 100 39 77 0 1416898224 14580160 8952096
15:56:02 8148 8192000000 10301458176 10766725120 1392444192 14.528 100 11 22 0 1410637344 15906128 2287024
15:57:12 50415 8192000000 10281192864 10745479168 1393094672 14.533 100 7 14 0 1404758736 10318896 1345168
15:59:17 61880 8192000000 10266668464 10716999680 1336574224 14.027 96 15 30 0 1347749248 7967312 3207712
16:01:31 47647 8192000000 10274908640 10738515968 1369217856 14.320 99 4 8 0 1379651600 9796128 637616
16:03:20 44386 8192000000 10283593456 10736705536 1382192096 14.436 100 11 22 0 1398837376 13858224 2787056
16:05:08 61556 8192000000 10251322688 10693521408 1259097888 13.322 91 12 22 0 1277203728 15103808 3002032
16:07:17 39480 8192000000 10253025904 10694516736 1330172512 13.969 99 14 28 0 1342735104 9862832 2699760
16:09:07 40660 8192000000 9060101872 9264640000 222126112 2.639 17 3 6 0 229933904 7222576 585216

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 01-04-2024 16:10:48 to 01-04-2024 16:11:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 42 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-04-2024 16:11:03 to 01-04-2024 16:11:05.

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          174711
MON$OLDEST_ACTIVE               174712
MON$OLDEST_SNAPSHOT             174712
MON$NEXT_TRANSACTION            174712
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                       1888320
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Apr  1 16:11:06 2024 
 
Database header page information: 
    Flags            0 
    Generation        90932 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174711 
    Oldest active        174712 
    Oldest snapshot        174712 
    Next transaction    174713 
    Sequence number        0 
    Next attachment ID    715 
    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.17, total records: 7800827 
    Average version length: 48.16, total versions: 117585, 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: 86544 
    Data pages: 86544, average fill: 72% 
    Primary pages: 86544, secondary pages: 0, swept pages: 14486 
    Empty pages: 6, full pages: 71489 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 74 
    40 - 59% = 981 
    60 - 79% = 85447 
    80 - 99% = 30 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23316, nodes: 7800827 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1741123, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 368 
        20 - 39% = 1594 
        40 - 59% = 4290 
        60 - 79% = 2185 
        80 - 99% = 14879 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13533, nodes: 7800827 
    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: 1563434, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1438 
        40 - 59% = 2200 
        60 - 79% = 997 
        80 - 99% = 8898 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8329, nodes: 7800827 
    Average node length: 6.63, total dup: 5819711, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1556487, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 868 
        40 - 59% = 1470 
        60 - 79% = 834 
        80 - 99% = 5039 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.93, total records: 2271400 
    Average version length: 34.85, total versions: 119898, max versions: 3 
    Average fragment length: 4.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28240 
    Data pages: 28240, average fill: 75% 
    Primary pages: 28234, secondary pages: 6, swept pages: 7918 
    Empty pages: 11, full pages: 22327 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 65 
    40 - 59% = 725 
    60 - 79% = 26122 
    80 - 99% = 1308 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4571, nodes: 2271400 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 706271, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 857 
        40 - 59% = 907 
        60 - 79% = 670 
        80 - 99% = 2137 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2529, nodes: 2275003 
    Average node length: 4.97, total dup: 2274104, max dup: 18966 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1251832, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 234 
        40 - 59% = 1531 
        60 - 79% = 567 
        80 - 99% = 195 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2033, nodes: 2271400 
    Average node length: 4.97, total dup: 2271350, max dup: 130325 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062297, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 46 
        40 - 59% = 1107 
        60 - 79% = 61 
        80 - 99% = 815 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4339, nodes: 2271400 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 706271, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 544 
        40 - 59% = 643 
        60 - 79% = 746 
        80 - 99% = 2309 
 
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.58, total records: 400 
    Average version length: 23.12, total versions: 237189, max versions: 619 
    Average fragment length: 2.00, total fragments: 40, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 90% 
    Primary pages: 11, secondary pages: 1301, swept pages: 0 
    Empty pages: 4, full pages: 1307 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1308 
 
    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: 13.12, total records: 111503 
    Average version length: 68.29, total versions: 90082, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.71 
    Pointer pages: 6, data page slots: 2360 
    Data pages: 1752, average fill: 78% 
    Primary pages: 1751, secondary pages: 1, swept pages: 0 
    Empty pages: 49, full pages: 1360 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 50 
    40 - 59% = 141 
    60 - 79% = 355 
    80 - 99% = 1131 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702676, depth: 3, leaf buckets: 389, nodes: 111503 
    Average node length: 13.06, total dup: 8258, max dup: 2 
    Average key length: 10.66, compression ratio: 2.53 
    Average prefix length: 19.26, average data length: 7.74 
    Clustering factor: 81029, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 92 
        40 - 59% = 273 
        60 - 79% = 22 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18539, max versions: 950 
    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: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 4.23, total records: 1959 
    Average version length: 43.43, total versions: 1776, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 13.71 
    Pointer pages: 1, data page slots: 40 
    Data pages: 39, average fill: 48% 
    Primary pages: 38, secondary pages: 1, swept pages: 0 
    Empty pages: 12, full pages: 17 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90496, depth: 2, leaf buckets: 2, nodes: 1959 
    Average node length: 4.14, total dup: 1861, max dup: 217 
    Average key length: 2.52, compression ratio: 7.54 
    Average prefix length: 18.53, average data length: 0.47 
    Clustering factor: 993, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        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: 96.96, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.41, total records: 803694 
    Average version length: 25.27, total versions: 95923, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 5, data page slots: 7880 
    Data pages: 7880, average fill: 72% 
    Primary pages: 7859, secondary pages: 21, swept pages: 796 
    Empty pages: 19, full pages: 7495 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 29 
    40 - 59% = 84 
    60 - 79% = 7297 
    80 - 99% = 442 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 869, nodes: 803694 
    Average node length: 4.87, total dup: 803645, max dup: 139446 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90435, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 90 
        40 - 59% = 510 
        60 - 79% = 200 
        80 - 99% = 67 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 927, nodes: 803694 
    Average node length: 5.88, total dup: 715328, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161006, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 98 
        40 - 59% = 391 
        60 - 79% = 154 
        80 - 99% = 282 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 967, nodes: 803694 
    Average node length: 5.88, total dup: 715328, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163034, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 195 
        40 - 59% = 345 
        60 - 79% = 148 
        80 - 99% = 278 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1133, nodes: 803694 
    Average node length: 5.96, total dup: 715328, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156026, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 235 
        40 - 59% = 607 
        60 - 79% = 209 
        80 - 99% = 82 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.70, total records: 5333 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.83, total fragments: 76, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 60% 
    Primary pages: 69, secondary pages: 19, swept pages: 44 
    Empty pages: 8, full pages: 62 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5333 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 9.98 
    Average prefix length: 34.17, average data length: 1.55 
    Clustering factor: 4968, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 9, nodes: 5333 
    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: 142, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        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.11, total records: 79893 
    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: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 769 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 769 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 39815, depth: 2, leaf buckets: 102, nodes: 79893 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3322, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.62, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 149.03, total records: 168223 
    Average version length: 152.27, total versions: 2149, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 5, data page slots: 5224 
    Data pages: 4016, average fill: 86% 
    Primary pages: 4016, secondary pages: 0, swept pages: 3 
    Empty pages: 25, full pages: 3977 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3978 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 146.35, total records: 168628 
    Average version length: 153.75, total versions: 5209, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 8, data page slots: 4408 
    Data pages: 4064, average fill: 86% 
    Primary pages: 4064, secondary pages: 0, swept pages: 6 
    Empty pages: 58, full pages: 3990 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3989 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 150.79, total records: 168052 
    Average version length: 143.62, total versions: 223, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 6, data page slots: 4992 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 7 
    Empty pages: 21, full pages: 3972 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3973 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 133.46, total records: 186809 
    Average version length: 155.13, total versions: 21633, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.71 
    Pointer pages: 8, data page slots: 5120 
    Data pages: 4504, average fill: 87% 
    Primary pages: 4503, secondary pages: 1, swept pages: 2 
    Empty pages: 57, full pages: 4432 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 4432 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.98, total records: 141874 
    Average version length: 151.03, total versions: 886, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4912 
    Data pages: 3416, average fill: 85% 
    Primary pages: 3416, secondary pages: 0, swept pages: 2 
    Empty pages: 49, full pages: 3353 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3353 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 149.43, total records: 162063 
    Average version length: 151.31, total versions: 1606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 4904 
    Data pages: 3896, average fill: 86% 
    Primary pages: 3896, secondary pages: 0, swept pages: 3 
    Empty pages: 50, full pages: 3830 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3829 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 150.34, total records: 158967 
    Average version length: 149.70, total versions: 699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 5224 
    Data pages: 3808, average fill: 86% 
    Primary pages: 3808, secondary pages: 0, swept pages: 1 
    Empty pages: 36, full pages: 3760 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3761 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.96, total records: 179132 
    Average version length: 153.00, total versions: 2345, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 4696 
    Data pages: 4304, average fill: 86% 
    Primary pages: 4304, secondary pages: 0, swept pages: 5 
    Empty pages: 52, full pages: 4235 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 1 
    80 - 99% = 4236 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 125.95, total records: 190071 
    Average version length: 155.00, total versions: 31592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.47 
    Pointer pages: 7, data page slots: 5488 
    Data pages: 4584, average fill: 87% 
    Primary pages: 4584, secondary pages: 0, swept pages: 2 
    Empty pages: 55, full pages: 4513 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4513 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 144.82, total records: 172764 
    Average version length: 154.53, total versions: 7122, 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: 6248 
    Data pages: 4264, average fill: 84% 
    Primary pages: 4264, secondary pages: 0, swept pages: 2 
    Empty pages: 146, full pages: 4078 
    Fill distribution: 
     0 - 19% = 149 
    20 - 39% = 13 
    40 - 59% = 12 
    60 - 79% = 13 
    80 - 99% = 4077 
 
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.39, total records: 2136201 
    Average version length: 52.85, total versions: 54931, 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: 25368 
    Data pages: 25368, average fill: 72% 
    Primary pages: 25368, secondary pages: 0, swept pages: 9206 
    Empty pages: 170, full pages: 22039 
    Fill distribution: 
     0 - 19% = 322 
    20 - 39% = 236 
    40 - 59% = 699 
    60 - 79% = 23594 
    80 - 99% = 517 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2601, nodes: 2136201 
    Average node length: 5.44, total dup: 1994879, max dup: 1496 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184416, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 260 
        40 - 59% = 1732 
        60 - 79% = 291 
        80 - 99% = 316 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2761, nodes: 2136201 
    Average node length: 5.69, total dup: 1917949, max dup: 67 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 381385, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 8 
        40 - 59% = 2298 
        60 - 79% = 421 
        80 - 99% = 32 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2182, nodes: 2136201 
    Average node length: 4.96, total dup: 2136101, max dup: 27644 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181352, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 221 
        40 - 59% = 1126 
        60 - 79% = 431 
        80 - 99% = 403 
 
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: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 35.82, total records: 175808 
    Average version length: 69.19, total versions: 84846, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.52 
    Pointer pages: 3, data page slots: 3512 
    Data pages: 2984, average fill: 69% 
    Primary pages: 2984, secondary pages: 0, swept pages: 236 
    Empty pages: 293, full pages: 2220 
    Fill distribution: 
     0 - 19% = 370 
    20 - 39% = 49 
    40 - 59% = 159 
    60 - 79% = 903 
    80 - 99% = 1503 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554354, depth: 3, leaf buckets: 244, nodes: 175808 
    Average node length: 6.47, total dup: 153018, max dup: 14 
    Average key length: 3.91, compression ratio: 10.75 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 29836, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 117 
        60 - 79% = 77 
        80 - 99% = 28 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.90, total records: 7197013 
    Average version length: 68.76, total versions: 527525, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 64, data page slots: 103200 
    Data pages: 103200, average fill: 75% 
    Primary pages: 103200, secondary pages: 0, swept pages: 17413 
    Empty pages: 16, full pages: 84061 
    Fill distribution: 
     0 - 19% = 168 
    20 - 39% = 1109 
    40 - 59% = 5994 
    60 - 79% = 85610 
    80 - 99% = 10319 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10688, nodes: 7197013 
    Average node length: 6.51, total dup: 6225862, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1583421, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1359 
        40 - 59% = 5943 
        60 - 79% = 2813 
        80 - 99% = 566 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8494, nodes: 7197013 
    Average node length: 5.39, total dup: 6913190, max dup: 175 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1378212, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 926 
        40 - 59% = 4873 
        60 - 79% = 1523 
        80 - 99% = 1159 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8544, nodes: 7197013 
    Average node length: 5.39, total dup: 6913190, max dup: 175 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1380786, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1002 
        40 - 59% = 4823 
        60 - 79% = 1570 
        80 - 99% = 1143 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.28, total records: 12066059 
    Average version length: 68.76, total versions: 467184, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 102, data page slots: 166288 
    Data pages: 166288, average fill: 77% 
    Primary pages: 166288, secondary pages: 0, swept pages: 60587 
    Empty pages: 6, full pages: 161907 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 395 
    40 - 59% = 1514 
    60 - 79% = 153351 
    80 - 99% = 10949 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18239, nodes: 12066059 
    Average node length: 6.57, total dup: 10520896, max dup: 85 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2367440, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2052 
        40 - 59% = 10847 
        60 - 79% = 4524 
        80 - 99% = 791 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.32, total records: 1955742 
    Average version length: 69.12, total versions: 843873, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.20 
    Pointer pages: 25, data page slots: 40048 
    Data pages: 29336, average fill: 77% 
    Primary pages: 29336, secondary pages: 0, swept pages: 3433 
    Empty pages: 1313, full pages: 25584 
    Fill distribution: 
     0 - 19% = 1992 
    20 - 39% = 684 
    40 - 59% = 691 
    60 - 79% = 10868 
    80 - 99% = 15101 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2342, nodes: 1955742 
    Average node length: 5.51, total dup: 1877237, max dup: 99 
    Average key length: 2.54, compression ratio: 16.52 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 132834, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 246 
        40 - 59% = 1153 
        60 - 79% = 691 
        80 - 99% = 242 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.79, total records: 1252376 
    Average version length: 69.12, total versions: 620955, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.62 
    Pointer pages: 19, data page slots: 30136 
    Data pages: 24968, average fill: 59% 
    Primary pages: 24968, secondary pages: 0, swept pages: 4111 
    Empty pages: 4190, full pages: 14808 
    Fill distribution: 
     0 - 19% = 6061 
    20 - 39% = 821 
    40 - 59% = 1138 
    60 - 79% = 6998 
    80 - 99% = 9950 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1638, nodes: 1252376 
    Average node length: 5.78, total dup: 1170699, max dup: 99 
    Average key length: 2.84, compression ratio: 14.80 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 169067, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 262 
        40 - 59% = 783 
        60 - 79% = 467 
        80 - 99% = 124 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.28, total records: 9430685 
    Average version length: 68.93, total versions: 631970, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 88, data page slots: 141992 
    Data pages: 141952, average fill: 71% 
    Primary pages: 141952, secondary pages: 0, swept pages: 38468 
    Empty pages: 327, full pages: 90077 
    Fill distribution: 
     0 - 19% = 951 
    20 - 39% = 3587 
    40 - 59% = 16299 
    60 - 79% = 110144 
    80 - 99% = 10971 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13477, nodes: 9430685 
    Average node length: 6.67, total dup: 7823381, max dup: 29 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2047699, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 933 
        40 - 59% = 6686 
        60 - 79% = 5066 
        80 - 99% = 791 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21151969 
    Average version length: 82.91, total versions: 18252, 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: 318672 
    Data pages: 318672, average fill: 81% 
    Primary pages: 318672, secondary pages: 0, swept pages: 11441 
    Empty pages: 14, full pages: 318372 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 10 
    40 - 59% = 31 
    60 - 79% = 26931 
    80 - 99% = 291680 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19359, nodes: 21151969 
    Average node length: 5.72, total dup: 20670923, max dup: 137 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281654, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 8090 
        60 - 79% = 550 
        80 - 99% = 10709 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17163, nodes: 21151969 
    Average node length: 6.31, total dup: 18589516, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913398, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 778 
        60 - 79% = 268 
        80 - 99% = 16110 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21139, nodes: 21151969 
    Average node length: 6.35, total dup: 18507427, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575669, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1 
        40 - 59% = 8353 
        60 - 79% = 611 
        80 - 99% = 12165 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16166, nodes: 21151969 
    Average node length: 5.56, total dup: 21151869, max dup: 229817 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942164, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 12 
        40 - 59% = 3001 
        60 - 79% = 409 
        80 - 99% = 12742 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.16, total records: 9883280 
    Average version length: 82.60, total versions: 629796, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 104, data page slots: 168544 
    Data pages: 168528, average fill: 73% 
    Primary pages: 168528, secondary pages: 0, swept pages: 54571 
    Empty pages: 471, full pages: 110239 
    Fill distribution: 
     0 - 19% = 1353 
    20 - 39% = 5006 
    40 - 59% = 19842 
    60 - 79% = 70047 
    80 - 99% = 72280 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11354, nodes: 9883280 
    Average node length: 5.35, total dup: 9572526, max dup: 204 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2194148, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 39 
        40 - 59% = 7686 
        60 - 79% = 3515 
        80 - 99% = 112 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13536, nodes: 9883280 
    Average node length: 6.22, total dup: 8194273, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1519976, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 3672 
        40 - 59% = 4512 
        60 - 79% = 2464 
        80 - 99% = 2728 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12686, nodes: 9883280 
    Average node length: 5.97, total dup: 8584194, max dup: 43 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2390215, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 47 
        40 - 59% = 8613 
        60 - 79% = 3894 
        80 - 99% = 130 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10324, nodes: 9883280 
    Average node length: 5.13, total dup: 9883180, max dup: 156416 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1547890, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1178 
        40 - 59% = 5247 
        60 - 79% = 1791 
        80 - 99% = 2055 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.05, total records: 11568544 
    Average version length: 82.54, total versions: 456415, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 191048 
    Data pages: 189736, average fill: 75% 
    Primary pages: 189736, secondary pages: 0, swept pages: 59627 
    Empty pages: 2151, full pages: 151685 
    Fill distribution: 
     0 - 19% = 3507 
    20 - 39% = 5487 
    40 - 59% = 14116 
    60 - 79% = 40632 
    80 - 99% = 125994 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13148, nodes: 11568544 
    Average node length: 5.30, total dup: 11458396, max dup: 638 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2414019, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 76 
        40 - 59% = 8531 
        60 - 79% = 4314 
        80 - 99% = 226 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10585, nodes: 11568544 
    Average node length: 5.50, total dup: 11064624, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 729103, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 814 
        40 - 59% = 2544 
        60 - 79% = 1838 
        80 - 99% = 5253 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15029, nodes: 11568544 
    Average node length: 6.03, total dup: 10099762, max dup: 76 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2430635, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 98 
        40 - 59% = 9980 
        60 - 79% = 4668 
        80 - 99% = 281 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11016, nodes: 11568544 
    Average node length: 5.23, total dup: 11568444, max dup: 206108 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 717589, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 82 
        20 - 39% = 761 
        40 - 59% = 5020 
        60 - 79% = 1572 
        80 - 99% = 3581 
 
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: 77.65, total records: 9982194 
    Average version length: 82.87, total versions: 613355, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 171536 
    Data pages: 171488, average fill: 72% 
    Primary pages: 171488, secondary pages: 0, swept pages: 59665 
    Empty pages: 409, full pages: 108888 
    Fill distribution: 
     0 - 19% = 1294 
    20 - 39% = 5279 
    40 - 59% = 21096 
    60 - 79% = 73260 
    80 - 99% = 70559 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11963, nodes: 9982194 
    Average node length: 5.17, total dup: 9953181, max dup: 2197 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1979309, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1427 
        40 - 59% = 7991 
        60 - 79% = 1889 
        80 - 99% = 635 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13594, nodes: 9982194 
    Average node length: 6.24, total dup: 8275782, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1475653, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 188 
        20 - 39% = 3664 
        40 - 59% = 4421 
        60 - 79% = 2432 
        80 - 99% = 2889 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12581, nodes: 9982194 
    Average node length: 5.42, total dup: 9537957, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2117575, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1351 
        40 - 59% = 8886 
        60 - 79% = 1721 
        80 - 99% = 600 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10457, nodes: 9982194 
    Average node length: 5.14, total dup: 9982094, max dup: 158318 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1558596, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1187 
        40 - 59% = 5418 
        60 - 79% = 1789 
        80 - 99% = 2018 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.03, total records: 579839 
    Average version length: 68.78, total versions: 9715, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7952 
    Data pages: 7952, average fill: 76% 
    Primary pages: 7952, secondary pages: 0, swept pages: 3228 
    Empty pages: 7, full pages: 7205 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 4 
    40 - 59% = 83 
    60 - 79% = 7669 
    80 - 99% = 189 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 50606, depth: 3, leaf buckets: 743, nodes: 579839 
    Average node length: 5.95, total dup: 493804, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101062, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 525 
        60 - 79% = 111 
        80 - 99% = 82 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 40447, depth: 3, leaf buckets: 757, nodes: 579839 
    Average node length: 6.15, total dup: 475663, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101117, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 17 
        40 - 59% = 534 
        60 - 79% = 104 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 587, nodes: 579839 
    Average node length: 4.86, total dup: 579739, max dup: 9805 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89562, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 352 
        60 - 79% = 79 
        80 - 99% = 112 
 
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 Mon Apr  1 16:11:30 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7800827 117585 1 0.0000 0.0000
DOC_LIST 2271400 119898 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237189 619 59200.0000 0.0000
INVNT_TURNOVER_LOG 111503 90082 1 0.0000 0.0000
MONEY_SALDO 49 18539 950 37800.0000 0.0000
MONEY_TURNOVER_LOG 1959 1776 1 0.0000 0.0000
PDISTR 803694 95923 4 0.0000 0.0000
PERF_SPLIT_0 168223 2149 1 0.0000 0.0000
PERF_SPLIT_1 168628 5209 1 0.0000 0.0000
PERF_SPLIT_2 168052 223 1 0.0000 0.0000
PERF_SPLIT_3 186809 21633 1 0.0000 0.0000
PERF_SPLIT_4 141874 886 1 0.0000 0.0000
PERF_SPLIT_5 162063 1606 1 0.0000 0.0000
PERF_SPLIT_6 158967 699 1 0.0000 0.0000
PERF_SPLIT_7 179132 2345 1 0.0000 0.0000
PERF_SPLIT_8 190071 31592 1 0.0000 0.0000
PERF_SPLIT_9 172764 7122 1 0.0000 0.0000
PSTORNED 2136201 54931 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 175808 84846 1 0.0000 0.0000
XQD_1000_3300 7197013 527525 1 0.0000 0.0000
XQD_1200_2000 12066059 467184 1 0.0000 0.0000
XQD_2000_3300 1955742 843873 1 0.0000 0.0000
XQD_2100_3300 1252376 620955 1 0.0000 0.0000
XQD_3300_3400 9430685 631970 1 0.0000 0.0000
XQS_1000_1200 21151969 18252 1 0.0000 0.0000
XQS_1000_3300 9883280 629796 1 0.0000 0.0000
XQS_1200_2000 11568544 456415 1 0.0000 0.0000
XQS_2100_3300 9982194 613355 1 0.0000 0.0000
XQS_3300_3400 579839 9715 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 ---
:634: 
:635: mscs-test-161.budzdorov.ru    Mon Apr  1 16:09:59 2024
:636:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:637: 
--- end of diff output ---

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

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