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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15699556 kB
MemAvailable 30155204 kB
Buffers 0 kB
Cached 16036672 kB
SwapCached 2508 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-05 01:09:40
DTS_END                         2024-04-05 01:09:40.4830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43960
TRN_ID                          177376
ATT_ID                          596
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: 9054.68 22674 905468
customer order: creation 177.23 385 17723
customer order: refuse 14.90 354 1490
order to supplier: creation 46.40 1260 4640
order to supplier: removal 3.51 98924 351
invoice (draft): creation 47.72 3082 4772
invoice (draft): removal 48.02 838 4802
invoice accept: apply 42.57 20648 4257
invoice accept: cancel 43.66 891 4366
customer reserve: creation 4017.14 202 401714
customer reserve: removal 4320.13 64 432013
realization accept: apply 85.62 202 8562
realization accept: cancel 76.61 124 7661
payment from customer: creation 60.06 117 6006
payment from customer: removal 5.87 94 587
payment to supplier: creation 49.60 126 4960
payment to supplier: removal 3.20 71 320
service: total inventory turnovers 4.48 1103 448
service: total monetary turnovers 6.96 30 696
service: aggregate perf. data 0.97 11544 97
service: refresh index statistics 0.03 313422 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 05-04-2024 01:10:59 to 05-04-2024 01:11:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2472
TEST_TIME 2 2744
TEST_TIME 3 3141
TEST_TIME 4 3361
TEST_TIME 5 3534
TEST_TIME 6 3568
TEST_TIME 7 3920
TEST_TIME 8 3984
TEST_TIME 9 3968
TEST_TIME 10 5106
TEST_TIME 11 5396
TEST_TIME 12 5567
TEST_TIME 13 5447
TEST_TIME 14 5626
TEST_TIME 15 5617
TEST_TIME 16 5648
TEST_TIME 17 6098
TEST_TIME 18 6170
TEST_TIME 19 6408
TEST_TIME 20 6660
TEST_TIME 21 6949
TEST_TIME 22 7126
TEST_TIME 23 7215
TEST_TIME 24 7166
TEST_TIME 25 7398
TEST_TIME 26 7713
TEST_TIME 27 7924
TEST_TIME 28 7870
TEST_TIME 29 8331
TEST_TIME 30 8527
TEST_TIME 31 8818
TEST_TIME 32 8699
TEST_TIME 33 8666
TEST_TIME 34 8743
TEST_TIME 35 8750
TEST_TIME 36 8967
TEST_TIME 37 8961
TEST_TIME 38 8912
TEST_TIME 39 8708
TEST_TIME 40 8804
TEST_TIME 41 8691
TEST_TIME 42 8649
TEST_TIME 43 8650
TEST_TIME 44 8702
TEST_TIME 45 8801
TEST_TIME 46 8841
TEST_TIME 47 8838
TEST_TIME 48 8752
TEST_TIME 49 8718
TEST_TIME 50 8755
TEST_TIME 51 8708
TEST_TIME 52 8757
TEST_TIME 53 8934
TEST_TIME 54 8862
TEST_TIME 55 8864
TEST_TIME 56 8850
TEST_TIME 57 8959
TEST_TIME 58 8987
TEST_TIME 59 8987
TEST_TIME 60 8981
TEST_TIME 61 9115
TEST_TIME 62 9089
TEST_TIME 63 9068
TEST_TIME 64 9164
TEST_TIME 65 9069
TEST_TIME 66 8977
TEST_TIME 67 8953
TEST_TIME 68 8891
TEST_TIME 69 8842
TEST_TIME 70 8799
TEST_TIME 71 8868
TEST_TIME 72 8819
TEST_TIME 73 8866
TEST_TIME 74 8905
TEST_TIME 75 9003
TEST_TIME 76 8998
TEST_TIME 77 9035
TEST_TIME 78 9093
TEST_TIME 79 9110
TEST_TIME 80 9206
TEST_TIME 81 9239
TEST_TIME 82 9195
TEST_TIME 83 9214
TEST_TIME 84 9225
TEST_TIME 85 9247
TEST_TIME 86 9237
TEST_TIME 87 9151
TEST_TIME 88 9116
TEST_TIME 89 9117
TEST_TIME 90 9088
TEST_TIME 91 9109
TEST_TIME 92 9047
TEST_TIME 93 9026
TEST_TIME 94 8971
TEST_TIME 95 8964
TEST_TIME 96 9022
TEST_TIME 97 9024
TEST_TIME 98 8989
TEST_TIME 99 9006
TEST_TIME 100 9058

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-04-2024 01:11:03 to 05-04-2024 01:11:06.

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 1274205 1274205 0 0.00 0 18126 7 0 0
doc_list_biud 1274202 1274202 0 0.00 0 81198 28 0 0
sp_add_invoice_to_stock 4313 4257 56 1.29 20 193233 20649 0 56
sp_cancel_adding_invoice 4366 4366 0 0.00 4 71655 892 0 0
sp_cancel_client_order 1490 1490 0 0.00 4 13388 354 0 0
sp_cancel_customer_reserve 432013 432013 0 0.00 0 26501 64 0 0
sp_cancel_pay_from_customer 587 587 0 0.00 3 7648 95 0 0
sp_cancel_pay_to_supplier 320 320 0 0.00 3 4984 71 0 0
sp_cancel_supplier_invoice 4809 4802 7 0.14 2 81211 839 0 7
sp_cancel_supplier_order 351 351 0 0.00 8 834792 98924 0 0
sp_cancel_write_off 7661 7661 0 0.00 1 13374 125 0 0
sp_client_order 17723 17723 0 0.00 3 18827 385 0 0
sp_customer_reserve 401714 401714 0 0.00 0 61582 202 0 0
sp_fill_shopping_cart 27125 27125 0 0.00 1 18169 35 0 0
sp_fill_shopping_cart_clo_res 401711 401711 0 0.00 0 16427 15 0 0
sp_get_clo_for_invoice 4253 4253 0 0.00 0 23138 295 0 0
sp_kill_cost_storno 12934 12934 0 0.00 0 6253 62 0 0
sp_kill_qstorno_ret_qs2qd 876840 876840 0 0.00 0 81189 35 0 0
sp_kill_qty_storno 463498 463498 0 0.00 0 81195 76 0 0
sp_lock_selected_doc 17675 17675 0 0.00 0 10699 6 0 0
sp_make_cost_storno 23781 23781 0 0.00 0 16410 60 0 0
sp_multiply_rows_for_pdistr 23779 23779 0 0.00 0 10350 30 0 0
sp_multiply_rows_for_qdistr 17723 17723 0 0.00 0 12128 193 0 0
sp_pay_from_customer 6006 6006 0 0.00 4 10477 117 0 0
sp_pay_to_supplier 4960 4960 0 0.00 5 16418 126 0 0
sp_payment_common 10964 10964 0 0.00 1 7224 24 0 0
sp_qd_handle_on_cancel_clo 1490 1490 0 0.00 0 13380 332 0 0
sp_qd_handle_on_invoice_upd_sts 8619 8619 0 0.00 0 37473 334 0 0
sp_qd_handle_on_reserve_upd_sts 8562 8562 0 0.00 0 27105 77 0 0
sp_reserve_write_off 8562 8562 0 0.00 6 27183 203 0 0
sp_supplier_invoice 4772 4772 0 0.00 6 79621 3083 0 0
sp_supplier_order 4640 4640 0 0.00 5 20799 1260 0 0
srv_aggregate_perf_data 97 97 0 0.00 2117 54385 11544 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1235 121498 38164 0 0
srv_find_qd_qs_mism 862920 862920 0 0.00 0 18125 7 0 0
srv_make_invnt_saldo 448 448 0 0.00 52 27335 1104 0 0
srv_make_money_saldo 696 696 0 0.00 1 3161 31 0 0
srv_recalc_idx_stat 3 3 0 0.00 274204 338022 313423 0 0
t$perf-abend:sp_add_invoice_to_stock 56 56 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4257 4257 0 0.00 0 10669 185 0 0
t$perf-norm:sp_cancel_adding_invoice 386 386 0 0.00 1 1580 81 0 0
t$perf-norm:sp_cancel_client_order 1490 1490 0 0.00 0 2591 11 0 0
t$perf-norm:sp_cancel_customer_reserve 563 563 0 0.00 0 1393 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 587 587 0 0.00 0 973 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 320 320 0 0.00 0 186 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 323 323 0 0.00 0 1571 32 0 0
t$perf-norm:sp_cancel_supplier_order 351 351 0 0.00 0 15604 1438 0 0
t$perf-norm:sp_cancel_write_off 840 840 0 0.00 0 3148 7 0 0
t$perf-norm:sp_client_order 17723 17723 0 0.00 0 4094 14 0 0
t$perf-norm:sp_customer_reserve 816 816 0 0.00 0 353 3 0 0
t$perf-norm:sp_pay_from_customer 6006 6006 0 0.00 0 5361 9 0 0
t$perf-norm:sp_pay_to_supplier 4960 4960 0 0.00 0 3473 10 0 0
t$perf-norm:sp_reserve_write_off 8562 8562 0 0.00 0 3443 11 0 0
t$perf-norm:sp_supplier_invoice 4772 4772 0 0.00 0 4851 20 0 0
t$perf-norm:sp_supplier_order 4640 4640 0 0.00 0 2509 14 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 199 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 8 1 0 0
t$perf-norm:srv_make_invnt_saldo 448 448 0 0.00 0 2069 29 0 0
t$perf-norm:srv_make_money_saldo 696 696 0 0.00 0 828 10 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 16 9 0 0
v_add_invoice_to_stock 8618 8506 112 1.29 0 8406 18 0 112
v_all_customers 32426 32426 0 0.00 0 156 1 0 0
v_all_suppliers 26466 26466 0 0.00 0 96 1 0 0
v_all_wares 35444 35444 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 772 772 0 0.00 0 1755 8 0 0
v_cancel_client_order 2980 2980 0 0.00 0 2508 5 0 0
v_cancel_customer_prepayment 1174 1174 0 0.00 0 1376 7 0 0
v_cancel_customer_reserve 1126 1126 0 0.00 0 3081 10 0 0
v_cancel_payment_to_supplier 640 640 0 0.00 0 1059 6 0 0
v_cancel_supplier_invoice 660 646 14 2.12 0 311 12 0 14
v_cancel_supplier_order 702 702 0 0.00 0 213 2 0 0
v_cancel_write_off 1680 1680 0 0.00 0 3357 13 0 0
v_max_id_clo_ord 4637 4637 0 0.00 0 964 2 0 0
v_max_id_clo_res 816 816 0 0.00 0 2553 21 0 0
v_max_id_ord_sup 4765 4765 0 0.00 0 2060 3 0 0
v_max_non_paid_invoice 1128 1128 0 0.00 0 405 3 0 0
v_max_non_paid_realizn 3039 3039 0 0.00 0 7218 7 0 0
v_min_id_clo_ord 4637 4637 0 0.00 0 8779 7 0 0
v_min_id_clo_res 816 816 0 0.00 0 4416 8 0 0
v_min_id_ord_sup 4765 4765 0 0.00 0 5378 6 0 0
v_min_non_paid_invoice 4959 4959 0 0.00 0 4855 15 0 0
v_min_non_paid_realizn 6005 6005 0 0.00 0 5058 19 0 0
v_our_firm 8950 8950 0 0.00 0 23 1 0 0
v_reserve_write_off 17122 17122 0 0.00 0 4279 6 0 0
x_lock_depdocs_on_canc_invoice 8845 8845 0 0.00 0 29751 148 0 0
x_lock_depdocs_on_canc_sup_ord 351 351 0 0.00 0 3188 312 0 0
x_make_qstorno_1000_1200 4640 4640 0 0.00 1 20786 1187 0 0
x_make_qstorno_1200_2000 4772 4772 0 0.00 2 79561 2948 0 0
x_make_qstorno_2100_3300 401714 401714 0 0.00 0 61577 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-04-2024 01:11:07 to 05-04-2024 01:11:11.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
23:09:44 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:45 8979 8192000000 9859523168 10161504256 950634096 10.397 100 87 174 0 979372480 5209440 23528944
23:12:03 25827 8192000000 9929004016 10244440064 1007251408 10.949 100 91 182 0 1038401808 7430528 23719872
23:13:34 14726 8192000000 9961154800 10285862912 1043012864 11.294 100 89 178 0 1075145664 9299856 22832944
23:15:00 7767 8192000000 10019924608 10360041472 1096423296 11.804 100 72 144 0 1123777616 10047088 17307232
23:16:13 6129 8192000000 10063577984 10419138560 1152091072 12.329 100 82 164 1 1183727456 12494224 19142160
23:17:21 2101 8192000000 10106047184 10468917248 1195218656 12.732 100 78 156 0 1225100576 12665344 17216576
23:18:26 2887 8192000000 10150446576 10522902528 1235439504 13.104 100 81 162 0 1265916256 12623504 17853248
23:19:31 1049 8192000000 10171858448 10555445248 1265796608 13.383 100 72 141 0 1292722784 10765888 16160288
23:20:35 787 8192000000 10207168928 10588295168 1288990368 13.595 100 96 191 0 1325031424 14190528 21850528
23:21:37 16342 8192000000 10200604064 10596175872 1295485040 13.654 100 61 119 1 1316343072 7308512 13549520
23:22:54 7620 8192000000 10200878144 10610720768 1306671120 13.756 100 17 34 0 1316675760 6248720 3755920
23:24:02 11458 8192000000 10196451760 10613108736 1314308624 13.825 100 18 34 3 1323261360 5732608 3220128
23:25:16 12004 8192000000 10205759872 10629451776 1324898384 13.921 100 22 43 0 1336837056 6560960 5377712
23:26:28 70688 8192000000 10239148608 10649944064 1331043504 13.977 100 43 86 0 1346832960 5518992 10270464
23:28:41 3502 8192000000 10226357632 10645528576 1336472304 14.026 100 21 42 1 1346457360 5234832 4750224
23:29:47 24059 8192000000 10228820288 10638925824 1317787824 13.857 99 36 72 0 1332159472 5585856 8785792
23:31:22 27003 8192000000 10246040448 10663366656 1343315920 14.087 100 49 98 1 1363122816 9223776 10583120
23:33:08 9731 8192000000 10235161312 10647199744 1320968784 13.885 99 50 100 0 1342307504 9866032 11472688
23:34:46 32416 8192000000 10237845936 10646114304 1317756864 13.856 99 46 92 1 1340040736 11334336 10949536
23:36:22 27726 8192000000 10240165536 10646577152 1293108624 13.633 97 50 101 1 1318696416 13562752 12025040
23:37:55 20594 8192000000 10241683984 10643951616 1314775392 13.829 99 42 84 0 1341136160 15368416 10992352
23:39:27 35126 8192000000 10220203600 10633248768 1297642544 13.674 98 22 44 0 1314736176 11391152 5702480
23:41:06 12042 8192000000 10237357968 10645139456 1314544912 13.827 99 47 94 0 1338838656 13304048 10989696
23:42:29 9255 8192000000 10218363776 10617929728 1303798576 13.730 99 52 100 1 1328220640 12707568 11714496
23:43:41 3446 8192000000 10248253952 10650046464 1321069584 13.886 99 56 106 4 1346237424 12492208 12675632
23:44:52 2942 8192000000 10266401088 10667683840 1338927920 14.048 100 67 130 2 1370914608 16617072 15369616
23:46:00 12405 8192000000 10278704608 10685198336 1341826176 14.074 99 64 124 1 1382275408 25072800 15376432
23:47:21 4320 8192000000 10277553504 10675884032 1339622944 14.054 100 72 144 1 1381211360 23835488 17752928
23:48:33 5971 8192000000 10311186432 10706415616 1361734864 14.253 100 90 182 0 1407690592 24426720 21529008
23:49:43 1234 8192000000 10319091088 10719272960 1372002368 14.345 100 87 164 1 1419026032 27767280 19256384
23:50:49 21437 8192000000 10314203664 10729881600 1383951760 14.452 100 54 108 2 1420073088 22777328 13344000
23:52:19 4371 8192000000 10306346608 10729238528 1381282288 14.428 100 40 80 1 1416581712 25087104 10212320
23:53:29 12179 8192000000 10310842768 10738565120 1385735200 14.468 100 40 75 1 1423451168 27440768 10275200
23:54:44 16541 8192000000 10305666336 10735464448 1379595216 14.413 100 41 82 1 1417507392 26918736 10993440
23:56:01 23175 8192000000 10291977920 10729795584 1374012976 14.363 100 19 39 0 1400231248 21520320 4697952
23:57:40 9732 8192000000 10308826768 10744193024 1381172272 14.427 100 28 56 0 1415511968 27050320 7289376
23:59:07 42095 8192000000 10292277008 10731515904 1381122560 14.427 100 15 30 2 1400426000 16244832 3058608
00:00:52 21513 8192000000 10309455984 10742792192 1389668160 14.503 100 54 101 0 1409995600 7932608 12394832
00:02:20 33214 8192000000 10313565008 10744856576 1392305984 14.526 100 50 98 1 1414733088 10958128 11468976
00:03:56 38772 8192000000 10321956384 10762588160 1401003072 14.604 100 22 43 1 1420579808 14200944 5375792
00:05:37 55180 8192000000 10314401696 10765660160 1405132432 14.641 100 4 8 0 1414629520 8661280 835808
00:07:56 80353 8192000000 10308905184 10763976704 1395439264 14.554 99 44 86 1 1414613472 8689424 10484784
00:10:20 55050 8192000000 10297829296 10753163264 1370205296 14.329 97 18 36 0 1381146048 6864080 4076672
00:12:17 24530 8192000000 10316698048 10760818688 1405065920 14.640 100 40 79 0 1425175152 10923536 9185696
00:13:53 44549 8192000000 10298023552 10758967296 1388205696 14.490 99 36 71 0 1412315600 15550304 8559600
00:15:55 28241 8192000000 10290685104 10761805824 1372194736 14.347 98 7 14 0 1388626096 14814416 1616944
00:17:25 46254 8192000000 10292625696 10747301888 1370979136 14.336 98 24 48 0 1386110992 9697536 5434320
00:19:21 70659 8192000000 10273107312 10729771008 1338280400 14.042 97 6 12 0 1351741552 11987952 1473200
00:21:32 54997 8192000000 10265268544 10701611008 1316872496 13.848 97 15 30 0 1330640160 10367264 3400400
00:23:30 28485 8192000000 10265980352 10696450048 1322218144 13.897 97 39 77 1 1339799648 8659184 8922320
00:25:01 17775 8192000000 10259097184 10692456448 1330135936 13.968 99 38 76 2 1351231120 12997360 8097824
00:26:25 57319 8192000000 10247442544 10685665280 1281515648 13.527 95 18 34 0 1299409952 14055648 3838656
00:28:30 31061 8192000000 10244388736 10669699072 1277040016 13.486 95 34 68 2 1294820880 10774000 7006864
00:30:10 75682 8192000000 10240850336 10682134528 1295516448 13.654 97 28 56 1 1315842720 14000320 6325952
00:32:26 53843 8192000000 10262657616 10693287936 1297930352 13.676 96 34 67 0 1314023840 8937584 7155904
00:34:21 121498 8192000000 10216670496 10656690176 1272735760 13.447 95 21 42 0 1288078832 10564912 4778160
00:37:31 16210 8192000000 10247563872 10682384384 1342098688 14.076 100 32 65 0 1358242720 8903936 7240096
00:38:52 60752 8192000000 10253043744 10697236480 1344283344 14.096 99 11 22 0 1359457712 12668896 2505472
00:40:55 21926 8192000000 10264847056 10699972608 1356000672 14.201 100 26 52 2 1374493968 12609248 5884048
00:42:17 82674 8192000000 10269432352 10716528640 1357076944 14.211 99 22 44 0 1379371584 17467488 4827152
00:44:48 63884 8192000000 10316713616 10764419072 1392955152 14.532 100 21 42 0 1413182144 15196192 5030800
00:46:52 53361 8192000000 10314540336 10775482368 1393832864 14.540 100 9 18 0 1418076320 21858368 2385088
00:48:47 57287 8192000000 10316140848 10768809984 1395302160 14.553 100 22 44 0 1416850288 16258544 5289584
00:50:49 54982 8192000000 10314581856 10754363392 1383619872 14.449 99 32 63 0 1399493296 8739664 7133760
00:52:50 25727 8192000000 10300569568 10744832000 1387634144 14.485 100 23 45 0 1400953424 8608432 4710848
00:54:18 48585 8192000000 10322476992 10761535488 1399466864 14.590 100 33 67 0 1421822736 13988272 8367600
00:56:09 76751 8192000000 10297649008 10747457536 1375156944 14.373 98 26 52 0 1388920672 8036192 5727536
00:58:36 41499 8192000000 10269379584 10724855808 1354123888 14.185 98 15 30 0 1366525616 9257136 3144592
01:00:17 49040 8192000000 10273516768 10737233920 1366069584 14.292 99 9 18 0 1376616800 8480368 2066848
01:02:07 60559 8192000000 10280932736 10730455040 1336276976 14.024 96 8 16 1 1346457616 7836112 2344528
01:04:08 58614 8192000000 10274170496 10730500096 1340113424 14.058 97 7 13 0 1354651744 13191504 1346816
01:06:09 66924 8192000000 10284413728 10730582016 1316942880 13.849 95 25 51 0 1337208176 14617808 5647488
01:08:16 77899 8192000000 10283634720 10743820288 1344841664 14.101 97 13 26 0 1366636304 18973360 2821280

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 56 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

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          172966
MON$OLDEST_ACTIVE               177534
MON$OLDEST_SNAPSHOT             177534
MON$NEXT_TRANSACTION            177534
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                       1901984
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 Fri Apr  5 01:11:31 2024 
 
Database header page information: 
    Flags            0 
    Generation        92657 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172966 
    Oldest active        177534 
    Oldest snapshot        177534 
    Next transaction    177535 
    Sequence number        0 
    Next attachment ID    713 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.25, total records: 7801148 
    Average version length: 48.16, total versions: 104169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87104 
    Data pages: 87104, average fill: 72% 
    Primary pages: 87104, secondary pages: 0, swept pages: 16470 
    Empty pages: 2, full pages: 66569 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 130 
    40 - 59% = 2073 
    60 - 79% = 84859 
    80 - 99% = 26 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23354, nodes: 7801148 
    Average node length: 18.90, 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: 1740014, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 326 
        20 - 39% = 1692 
        40 - 59% = 4210 
        60 - 79% = 2361 
        80 - 99% = 14765 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13594, nodes: 7801148 
    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: 1562174, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1558 
        40 - 59% = 2123 
        60 - 79% = 1078 
        80 - 99% = 8835 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8356, nodes: 7801148 
    Average node length: 6.63, total dup: 5822091, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1555078, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 897 
        40 - 59% = 1425 
        60 - 79% = 916 
        80 - 99% = 4989 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.08, total records: 2270308 
    Average version length: 34.76, total versions: 104802, max versions: 3 
    Average fragment length: 7.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28520 
    Data pages: 28520, average fill: 74% 
    Primary pages: 28514, secondary pages: 6, swept pages: 9195 
    Empty pages: 6, full pages: 21188 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 98 
    40 - 59% = 1289 
    60 - 79% = 26152 
    80 - 99% = 957 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4579, nodes: 2270308 
    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: 702837, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 885 
        40 - 59% = 886 
        60 - 79% = 708 
        80 - 99% = 2100 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2537, nodes: 2273408 
    Average node length: 4.97, total dup: 2272509, max dup: 18748 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1258650, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 274 
        40 - 59% = 1531 
        60 - 79% = 539 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2089, nodes: 2270308 
    Average node length: 4.97, total dup: 2270258, max dup: 130428 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066613, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 70 
        40 - 59% = 1175 
        60 - 79% = 47 
        80 - 99% = 793 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4349, nodes: 2270308 
    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: 702837, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 544 
        40 - 59% = 611 
        60 - 79% = 776 
        80 - 99% = 2311 
 
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.37, total records: 400 
    Average version length: 23.41, total versions: 229712, max versions: 595 
    Average fragment length: 2.04, total fragments: 52, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1296 
    Data pages: 1288, average fill: 90% 
    Primary pages: 8, secondary pages: 1280, swept pages: 0 
    Empty pages: 1, full pages: 1285 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1284 
 
    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: 18.30, total records: 174968 
    Average version length: 68.29, total versions: 128098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.81 
    Pointer pages: 6, data page slots: 2600 
    Data pages: 2560, average fill: 82% 
    Primary pages: 2559, secondary pages: 1, swept pages: 0 
    Empty pages: 40, full pages: 2196 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 39 
    40 - 59% = 113 
    60 - 79% = 568 
    80 - 99% = 1779 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1710344, depth: 3, leaf buckets: 421, nodes: 174968 
    Average node length: 13.17, total dup: 14916, max dup: 2 
    Average key length: 10.48, compression ratio: 2.58 
    Average prefix length: 19.43, average data length: 7.57 
    Clustering factor: 124794, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 4 
        40 - 59% = 80 
        60 - 79% = 269 
        80 - 99% = 63 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 18366, max versions: 996 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 63 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.86, total records: 2785 
    Average version length: 43.60, total versions: 2609, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 20.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 82% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 27 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 25 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93814, depth: 2, leaf buckets: 4, nodes: 2785 
    Average node length: 4.09, total dup: 2687, max dup: 329 
    Average key length: 2.38, compression ratio: 7.99 
    Average prefix length: 18.65, average data length: 0.35 
    Clustering factor: 1348, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 0 
        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.99, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.94, total records: 798954 
    Average version length: 25.86, total versions: 72005, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 7824 
    Data pages: 7816, average fill: 72% 
    Primary pages: 7802, secondary pages: 14, swept pages: 1073 
    Empty pages: 16, full pages: 7447 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 36 
    40 - 59% = 80 
    60 - 79% = 7362 
    80 - 99% = 304 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 867, nodes: 798954 
    Average node length: 4.87, total dup: 798905, max dup: 147258 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88716, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 103 
        40 - 59% = 505 
        60 - 79% = 195 
        80 - 99% = 64 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 890, nodes: 798954 
    Average node length: 5.88, total dup: 711355, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158867, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 93 
        40 - 59% = 331 
        60 - 79% = 121 
        80 - 99% = 341 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 931, nodes: 798954 
    Average node length: 5.88, total dup: 711355, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160834, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 179 
        40 - 59% = 311 
        60 - 79% = 104 
        80 - 99% = 337 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1128, nodes: 798954 
    Average node length: 5.96, total dup: 711355, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153485, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 212 
        40 - 59% = 632 
        60 - 79% = 189 
        80 - 99% = 91 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5418 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.95, total fragments: 92, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 77, secondary pages: 19, swept pages: 51 
    Empty pages: 10, full pages: 66 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5418 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.34, average data length: 1.55 
    Clustering factor: 5203, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5418 
    Average node length: 11.13, 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: 157, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 80851 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 778 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 779 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36142, depth: 2, leaf buckets: 103, nodes: 80851 
    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: 3261, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.69, 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.14 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 124.11, total records: 214419 
    Average version length: 154.18, total versions: 38275, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.67 
    Pointer pages: 7, data page slots: 6400 
    Data pages: 5208, average fill: 87% 
    Primary pages: 5208, secondary pages: 0, swept pages: 1 
    Empty pages: 82, full pages: 5075 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 7 
    40 - 59% = 31 
    60 - 79% = 9 
    80 - 99% = 5074 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.03, total records: 198583 
    Average version length: 151.83, total versions: 17219, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 7, data page slots: 5808 
    Data pages: 4832, average fill: 85% 
    Primary pages: 4832, secondary pages: 0, swept pages: 3 
    Empty pages: 104, full pages: 4694 
    Fill distribution: 
     0 - 19% = 108 
    20 - 39% = 15 
    40 - 59% = 12 
    60 - 79% = 2 
    80 - 99% = 4695 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 117.65, total records: 242805 
    Average version length: 154.36, total versions: 54084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.42 
    Pointer pages: 8, data page slots: 7824 
    Data pages: 5944, average fill: 86% 
    Primary pages: 5944, secondary pages: 0, swept pages: 2 
    Empty pages: 134, full pages: 5764 
    Fill distribution: 
     0 - 19% = 134 
    20 - 39% = 21 
    40 - 59% = 10 
    60 - 79% = 16 
    80 - 99% = 5763 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 139.75, total records: 176586 
    Average version length: 150.68, total versions: 13148, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.14 
    Pointer pages: 7, data page slots: 7880 
    Data pages: 4336, average fill: 84% 
    Primary pages: 4336, secondary pages: 0, swept pages: 1 
    Empty pages: 135, full pages: 4163 
    Fill distribution: 
     0 - 19% = 136 
    20 - 39% = 17 
    40 - 59% = 11 
    60 - 79% = 8 
    80 - 99% = 4164 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 141.87, total records: 148470 
    Average version length: 149.51, total versions: 8734, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.95 
    Pointer pages: 6, data page slots: 5968 
    Data pages: 3680, average fill: 83% 
    Primary pages: 3680, secondary pages: 0, swept pages: 1 
    Empty pages: 143, full pages: 3489 
    Fill distribution: 
     0 - 19% = 145 
    20 - 39% = 21 
    40 - 59% = 14 
    60 - 79% = 14 
    80 - 99% = 3486 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 116.80, total records: 225699 
    Average version length: 154.19, total versions: 51025, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.52 
    Pointer pages: 7, data page slots: 7208 
    Data pages: 5504, average fill: 87% 
    Primary pages: 5504, secondary pages: 0, swept pages: 1 
    Empty pages: 118, full pages: 5353 
    Fill distribution: 
     0 - 19% = 118 
    20 - 39% = 17 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 5354 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 126.57, total records: 213947 
    Average version length: 153.87, total versions: 34722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.40 
    Pointer pages: 6, data page slots: 7360 
    Data pages: 5216, average fill: 86% 
    Primary pages: 5216, secondary pages: 0, swept pages: 5 
    Empty pages: 111, full pages: 5058 
    Fill distribution: 
     0 - 19% = 114 
    20 - 39% = 10 
    40 - 59% = 17 
    60 - 79% = 17 
    80 - 99% = 5058 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 142.60, total records: 189959 
    Average version length: 150.02, total versions: 10738, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 7, data page slots: 6584 
    Data pages: 4624, average fill: 85% 
    Primary pages: 4623, secondary pages: 1, swept pages: 1 
    Empty pages: 107, full pages: 4486 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 11 
    40 - 59% = 15 
    60 - 79% = 5 
    80 - 99% = 4486 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 137.99, total records: 185212 
    Average version length: 152.38, total versions: 15959, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 6, data page slots: 7032 
    Data pages: 4544, average fill: 85% 
    Primary pages: 4543, secondary pages: 1, swept pages: 1 
    Empty pages: 134, full pages: 4374 
    Fill distribution: 
     0 - 19% = 136 
    20 - 39% = 15 
    40 - 59% = 9 
    60 - 79% = 12 
    80 - 99% = 4372 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 105.82, total records: 241522 
    Average version length: 154.55, total versions: 72294, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 16.03 
    Pointer pages: 7, data page slots: 8656 
    Data pages: 5888, average fill: 87% 
    Primary pages: 5888, secondary pages: 0, swept pages: 3 
    Empty pages: 110, full pages: 5744 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 13 
    40 - 59% = 13 
    60 - 79% = 6 
    80 - 99% = 5743 
 
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.47, total records: 2127189 
    Average version length: 52.86, total versions: 51560, 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: 25544 
    Data pages: 25528, average fill: 72% 
    Primary pages: 25528, secondary pages: 0, swept pages: 9846 
    Empty pages: 251, full pages: 21620 
    Fill distribution: 
     0 - 19% = 444 
    20 - 39% = 342 
    40 - 59% = 894 
    60 - 79% = 23342 
    80 - 99% = 506 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2609, nodes: 2127189 
    Average node length: 5.44, total dup: 1985607, max dup: 1416 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183929, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 270 
        40 - 59% = 1752 
        60 - 79% = 286 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2127189 
    Average node length: 5.69, total dup: 1909743, max dup: 68 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380064, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2376 
        60 - 79% = 355 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2233, nodes: 2127189 
    Average node length: 4.96, total dup: 2127089, max dup: 28047 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181416, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 238 
        40 - 59% = 1260 
        60 - 79% = 367 
        80 - 99% = 363 
 
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: 38.85, total records: 166607 
    Average version length: 69.17, total versions: 73085, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 3, data page slots: 3504 
    Data pages: 2704, average fill: 71% 
    Primary pages: 2704, secondary pages: 0, swept pages: 219 
    Empty pages: 285, full pages: 2278 
    Fill distribution: 
     0 - 19% = 343 
    20 - 39% = 27 
    40 - 59% = 19 
    60 - 79% = 704 
    80 - 99% = 1611 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103065, depth: 3, leaf buckets: 220, nodes: 166607 
    Average node length: 6.46, total dup: 145035, max dup: 14 
    Average key length: 3.92, compression ratio: 10.71 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 28125, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 93 
        60 - 79% = 77 
        80 - 99% = 33 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.72, total records: 7086870 
    Average version length: 68.80, total versions: 435942, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 61, data page slots: 99456 
    Data pages: 99456, average fill: 76% 
    Primary pages: 99456, secondary pages: 0, swept pages: 19946 
    Empty pages: 21, full pages: 89624 
    Fill distribution: 
     0 - 19% = 115 
    20 - 39% = 525 
    40 - 59% = 2500 
    60 - 79% = 87431 
    80 - 99% = 8885 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10650, nodes: 7086870 
    Average node length: 6.51, total dup: 6129666, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1588844, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1584 
        40 - 59% = 5773 
        60 - 79% = 2725 
        80 - 99% = 565 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8488, nodes: 7086870 
    Average node length: 5.40, total dup: 6803902, max dup: 201 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1381987, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1028 
        40 - 59% = 4839 
        60 - 79% = 1536 
        80 - 99% = 1074 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8541, nodes: 7086870 
    Average node length: 5.40, total dup: 6803902, max dup: 201 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1384538, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1097 
        40 - 59% = 4827 
        60 - 79% = 1569 
        80 - 99% = 1038 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.95, total records: 11958816 
    Average version length: 68.75, total versions: 346937, 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: 102, data page slots: 165008 
    Data pages: 165008, average fill: 77% 
    Primary pages: 165008, secondary pages: 0, swept pages: 69547 
    Empty pages: 5, full pages: 159542 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 289 
    40 - 59% = 1642 
    60 - 79% = 155642 
    80 - 99% = 7403 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18354, nodes: 11958817 
    Average node length: 6.57, total dup: 10422127, max dup: 65 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2363488, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 2433 
        40 - 59% = 10887 
        60 - 79% = 4329 
        80 - 99% = 671 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.55, total records: 1743821 
    Average version length: 69.13, total versions: 696094, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 26, data page slots: 41520 
    Data pages: 29136, average fill: 69% 
    Primary pages: 29136, secondary pages: 0, swept pages: 5823 
    Empty pages: 2216, full pages: 21162 
    Fill distribution: 
     0 - 19% = 3643 
    20 - 39% = 1596 
    40 - 59% = 1478 
    60 - 79% = 10963 
    80 - 99% = 11456 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2237, nodes: 1743821 
    Average node length: 5.51, total dup: 1673468, max dup: 97 
    Average key length: 2.55, compression ratio: 16.46 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 118376, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 423 
        40 - 59% = 1091 
        60 - 79% = 567 
        80 - 99% = 146 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.43, total records: 1297924 
    Average version length: 69.14, total versions: 631777, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.56 
    Pointer pages: 19, data page slots: 30648 
    Data pages: 25160, average fill: 60% 
    Primary pages: 25160, secondary pages: 0, swept pages: 3711 
    Empty pages: 3227, full pages: 15784 
    Fill distribution: 
     0 - 19% = 5531 
    20 - 39% = 1619 
    40 - 59% = 1116 
    60 - 79% = 5248 
    80 - 99% = 11646 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1653, nodes: 1297924 
    Average node length: 5.76, total dup: 1214750, max dup: 120 
    Average key length: 2.82, compression ratio: 14.91 
    Average prefix length: 41.25, average data length: 0.75 
    Clustering factor: 177539, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 224 
        40 - 59% = 779 
        60 - 79% = 486 
        80 - 99% = 158 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.87, total records: 9376271 
    Average version length: 68.94, total versions: 546655, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 89, data page slots: 144640 
    Data pages: 144608, average fill: 69% 
    Primary pages: 144608, secondary pages: 0, swept pages: 49365 
    Empty pages: 315, full pages: 81050 
    Fill distribution: 
     0 - 19% = 1008 
    20 - 39% = 4935 
    40 - 59% = 21846 
    60 - 79% = 107465 
    80 - 99% = 9354 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13540, nodes: 9376271 
    Average node length: 6.68, total dup: 7777805, max dup: 29 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2034894, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1160 
        40 - 59% = 6721 
        60 - 79% = 4853 
        80 - 99% = 804 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21164645 
    Average version length: 82.73, total versions: 11684, 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: 318816 
    Data pages: 318816, average fill: 81% 
    Primary pages: 318816, secondary pages: 0, swept pages: 11851 
    Empty pages: 10, full pages: 318803 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 27033 
    80 - 99% = 291771 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19330, nodes: 21164645 
    Average node length: 5.72, total dup: 20683292, max dup: 158 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3282726, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8020 
        60 - 79% = 532 
        80 - 99% = 10772 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17190, nodes: 21164645 
    Average node length: 6.31, total dup: 18598718, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915669, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 799 
        60 - 79% = 260 
        80 - 99% = 16123 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21136, nodes: 21164645 
    Average node length: 6.35, total dup: 18518280, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577922, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8323 
        60 - 79% = 600 
        80 - 99% = 12206 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16239, nodes: 21164645 
    Average node length: 5.56, total dup: 21164545, max dup: 230663 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944390, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 3102 
        60 - 79% = 447 
        80 - 99% = 12681 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.91, total records: 9823561 
    Average version length: 82.63, total versions: 536513, 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: 105, data page slots: 171288 
    Data pages: 171272, average fill: 71% 
    Primary pages: 171272, secondary pages: 0, swept pages: 66232 
    Empty pages: 383, full pages: 99171 
    Fill distribution: 
     0 - 19% = 1296 
    20 - 39% = 5946 
    40 - 59% = 25313 
    60 - 79% = 76098 
    80 - 99% = 62619 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11385, nodes: 9823561 
    Average node length: 5.37, total dup: 9513340, max dup: 176 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2179880, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 62 
        40 - 59% = 7855 
        60 - 79% = 3366 
        80 - 99% = 101 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13723, nodes: 9823561 
    Average node length: 6.24, total dup: 8143843, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1511540, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 4078 
        40 - 59% = 4390 
        60 - 79% = 2553 
        80 - 99% = 2547 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12715, nodes: 9823561 
    Average node length: 5.98, total dup: 8527246, max dup: 42 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2373515, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 83 
        40 - 59% = 8822 
        60 - 79% = 3674 
        80 - 99% = 136 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10397, nodes: 9823561 
    Average node length: 5.14, total dup: 9823461, max dup: 151599 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1553002, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1356 
        40 - 59% = 5220 
        60 - 79% = 1775 
        80 - 99% = 2008 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.35, total records: 11530972 
    Average version length: 82.58, total versions: 414384, 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: 192352 
    Data pages: 190992, average fill: 74% 
    Primary pages: 190992, secondary pages: 0, swept pages: 64358 
    Empty pages: 2389, full pages: 147611 
    Fill distribution: 
     0 - 19% = 3898 
    20 - 39% = 5915 
    40 - 59% = 15881 
    60 - 79% = 43389 
    80 - 99% = 121909 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13135, nodes: 11530972 
    Average node length: 5.31, total dup: 11420692, max dup: 637 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2408615, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 75 
        40 - 59% = 8560 
        60 - 79% = 4269 
        80 - 99% = 231 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10574, nodes: 11530972 
    Average node length: 5.50, total dup: 11028884, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 730013, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 811 
        40 - 59% = 2616 
        60 - 79% = 1831 
        80 - 99% = 5182 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15020, nodes: 11530972 
    Average node length: 6.03, total dup: 10066140, max dup: 71 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2425197, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 85 
        40 - 59% = 10095 
        60 - 79% = 4585 
        80 - 99% = 253 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11017, nodes: 11530972 
    Average node length: 5.23, total dup: 11530872, max dup: 180767 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 718441, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 819 
        40 - 59% = 4994 
        60 - 79% = 1549 
        80 - 99% = 3568 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.29, total records: 9936495 
    Average version length: 82.91, total versions: 533781, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 107, data page slots: 174280 
    Data pages: 174240, average fill: 71% 
    Primary pages: 174240, secondary pages: 0, swept pages: 68823 
    Empty pages: 401, full pages: 99724 
    Fill distribution: 
     0 - 19% = 1323 
    20 - 39% = 6226 
    40 - 59% = 26309 
    60 - 79% = 78026 
    80 - 99% = 62356 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11994, nodes: 9936495 
    Average node length: 5.18, total dup: 9907307, max dup: 2122 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1986370, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1454 
        40 - 59% = 7996 
        60 - 79% = 1921 
        80 - 99% = 587 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13788, nodes: 9936495 
    Average node length: 6.25, total dup: 8237132, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1478594, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 4040 
        40 - 59% = 4291 
        60 - 79% = 2578 
        80 - 99% = 2697 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12628, nodes: 9936495 
    Average node length: 5.44, total dup: 9493261, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2121731, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1401 
        40 - 59% = 8988 
        60 - 79% = 1634 
        80 - 99% = 579 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10591, nodes: 9936495 
    Average node length: 5.15, total dup: 9936395, max dup: 152150 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1569380, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1423 
        40 - 59% = 5399 
        60 - 79% = 1768 
        80 - 99% = 1970 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.21, total records: 581345 
    Average version length: 68.78, total versions: 8247, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 76% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3520 
    Empty pages: 1, full pages: 7069 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 3 
    40 - 59% = 137 
    60 - 79% = 7710 
    80 - 99% = 149 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37434, depth: 3, leaf buckets: 745, nodes: 581345 
    Average node length: 5.95, total dup: 494962, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101273, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 531 
        60 - 79% = 104 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30267, depth: 3, leaf buckets: 769, nodes: 581345 
    Average node length: 6.15, total dup: 476738, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101326, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 530 
        60 - 79% = 106 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 596, nodes: 581345 
    Average node length: 4.86, total dup: 581245, max dup: 9781 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89857, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 382 
        60 - 79% = 66 
        80 - 99% = 108 
 
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 Fri Apr  5 01:11:55 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7801148 104169 1 0.0000 0.0000
DOC_LIST 2270308 104802 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 229712 595 57400.0000 0.0000
INVNT_TURNOVER_LOG 174968 128098 1 0.0000 0.0000
MONEY_SALDO 49 18366 996 37400.0000 0.0000
MONEY_TURNOVER_LOG 2785 2609 1 0.0000 0.0000
PDISTR 798954 72005 5 0.0000 0.0000
PERF_SPLIT_0 214419 38275 1 0.0000 0.0000
PERF_SPLIT_1 198583 17219 1 0.0000 0.0000
PERF_SPLIT_2 242805 54084 1 0.0000 0.0000
PERF_SPLIT_3 176586 13148 1 0.0000 0.0000
PERF_SPLIT_4 148470 8734 1 0.0000 0.0000
PERF_SPLIT_5 225699 51025 1 0.0000 0.0000
PERF_SPLIT_6 213947 34722 1 0.0000 0.0000
PERF_SPLIT_7 189959 10738 1 0.0000 0.0000
PERF_SPLIT_8 185212 15959 1 0.0000 0.0000
PERF_SPLIT_9 241522 72294 1 0.0000 0.0000
PSTORNED 2127189 51560 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 166607 73085 1 0.0000 0.0000
XQD_1000_3300 7086870 435942 1 0.0000 0.0000
XQD_1200_2000 11958816 346937 1 0.0000 0.0000
XQD_2000_3300 1743821 696094 1 0.0000 0.0000
XQD_2100_3300 1297924 631777 1 0.0000 0.0000
XQD_3300_3400 9376271 546655 1 0.0000 0.0000
XQS_1000_1200 21164645 11684 1 0.0000 0.0000
XQS_1000_3300 9823561 536513 1 0.0000 0.0000
XQS_1200_2000 11530972 414384 1 0.0000 0.0000
XQS_2100_3300 9936495 533781 1 0.0000 0.0000
XQS_3300_3400 581345 8247 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 ---
:801: 
:802: mscs-test-161.budzdorov.ru    Fri Apr  5 01:09:42 2024
:803:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:804: 
:805: 
:806: mscs-test-161.budzdorov.ru    Fri Apr  5 01:09:45 2024
:807:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:808: 
:809: 
:810: mscs-test-161.budzdorov.ru    Fri Apr  5 01:09:50 2024
:811:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:812: 
--- end of diff output ---

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

05.04.24 01:12:07. 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-05 01:12:09 No severe PSQL-related problems occured
05.04.24 01:12:11. End of report.