Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.03.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 15847088 kB
MemAvailable 30294324 kB
Buffers 0 kB
Cached 15887280 kB
SwapCached 2696 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-03-17 01:09:44
DTS_END                         2024-03-17 01:09:44.4680
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34042
TRN_ID                          176905
ATT_ID                          540
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: 9302.43 19813 930243
customer order: creation 181.42 390 18142
customer order: refuse 15.08 375 1508
order to supplier: creation 47.22 1197 4722
order to supplier: removal 3.63 94626 363
invoice (draft): creation 48.01 3357 4801
invoice (draft): removal 52.03 781 5203
invoice accept: apply 42.43 21004 4243
invoice accept: cancel 46.97 965 4697
customer reserve: creation 4011.34 203 401134
customer reserve: removal 4550.48 59 455048
realization accept: apply 87.32 208 8732
realization accept: cancel 82.71 130 8271
payment from customer: creation 61.86 130 6186
payment from customer: removal 5.86 90 586
payment to supplier: creation 49.41 161 4941
payment to supplier: removal 3.72 81 372
service: total inventory turnovers 5.42 881 542
service: total monetary turnovers 6.77 27 677
service: aggregate perf. data 0.72 25669 72
service: refresh index statistics 0.03 245918 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2024 01:10:29 to 17-03-2024 01:10:31.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1272
TEST_TIME 2 2647
TEST_TIME 3 3836
TEST_TIME 4 4120
TEST_TIME 5 3657
TEST_TIME 6 4117
TEST_TIME 7 3952
TEST_TIME 8 4700
TEST_TIME 9 4586
TEST_TIME 10 5077
TEST_TIME 11 5340
TEST_TIME 12 5864
TEST_TIME 13 6035
TEST_TIME 14 6289
TEST_TIME 15 6751
TEST_TIME 16 7075
TEST_TIME 17 7388
TEST_TIME 18 7492
TEST_TIME 19 7716
TEST_TIME 20 7931
TEST_TIME 21 8313
TEST_TIME 22 8973
TEST_TIME 23 8754
TEST_TIME 24 9148
TEST_TIME 25 9331
TEST_TIME 26 9768
TEST_TIME 27 10114
TEST_TIME 28 9849
TEST_TIME 29 9627
TEST_TIME 30 9586
TEST_TIME 31 9933
TEST_TIME 32 9754
TEST_TIME 33 9705
TEST_TIME 34 9713
TEST_TIME 35 9635
TEST_TIME 36 9573
TEST_TIME 37 9519
TEST_TIME 38 9365
TEST_TIME 39 9364
TEST_TIME 40 9327
TEST_TIME 41 9239
TEST_TIME 42 9228
TEST_TIME 43 9260
TEST_TIME 44 9211
TEST_TIME 45 9257
TEST_TIME 46 9312
TEST_TIME 47 9315
TEST_TIME 48 9320
TEST_TIME 49 9398
TEST_TIME 50 9538
TEST_TIME 51 9491
TEST_TIME 52 9615
TEST_TIME 53 9648
TEST_TIME 54 9603
TEST_TIME 55 9560
TEST_TIME 56 9526
TEST_TIME 57 9635
TEST_TIME 58 9577
TEST_TIME 59 9473
TEST_TIME 60 9423
TEST_TIME 61 9387
TEST_TIME 62 9361
TEST_TIME 63 9354
TEST_TIME 64 9330
TEST_TIME 65 9287
TEST_TIME 66 9178
TEST_TIME 67 9112
TEST_TIME 68 9138
TEST_TIME 69 9151
TEST_TIME 70 9132
TEST_TIME 71 9182
TEST_TIME 72 9184
TEST_TIME 73 9292
TEST_TIME 74 9266
TEST_TIME 75 9259
TEST_TIME 76 9301
TEST_TIME 77 9374
TEST_TIME 78 9329
TEST_TIME 79 9363
TEST_TIME 80 9399
TEST_TIME 81 9413
TEST_TIME 82 9432
TEST_TIME 83 9379
TEST_TIME 84 9313
TEST_TIME 85 9276
TEST_TIME 86 9320
TEST_TIME 87 9300
TEST_TIME 88 9267
TEST_TIME 89 9254
TEST_TIME 90 9183
TEST_TIME 91 9185
TEST_TIME 92 9170
TEST_TIME 93 9136
TEST_TIME 94 9218
TEST_TIME 95 9216
TEST_TIME 96 9207
TEST_TIME 97 9209
TEST_TIME 98 9284
TEST_TIME 99 9289
TEST_TIME 100 9306

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2024 01:10:33 to 17-03-2024 01:10:36.

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 1298206 1298206 0 0.00 0 25085 7 0 0
doc_list_biud 1298199 1298199 0 0.00 0 62863 27 0 0
sp_add_invoice_to_stock 4311 4243 68 1.57 42 184957 21005 0 68
sp_cancel_adding_invoice 4697 4697 0 0.00 5 70895 965 0 0
sp_cancel_client_order 1508 1508 0 0.00 4 10279 376 0 0
sp_cancel_customer_reserve 455048 455048 0 0.00 0 62867 59 0 0
sp_cancel_pay_from_customer 586 586 0 0.00 2 6261 91 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 3 3364 82 0 0
sp_cancel_supplier_invoice 5211 5203 8 0.15 2 29356 782 0 8
sp_cancel_supplier_order 363 363 0 0.00 5 920079 94626 0 0
sp_cancel_write_off 8271 8271 0 0.00 1 7698 131 0 0
sp_client_order 18142 18142 0 0.00 3 25592 390 0 0
sp_customer_reserve 401134 401134 0 0.00 0 47982 204 0 0
sp_fill_shopping_cart 27646 27646 0 0.00 1 15185 37 0 0
sp_fill_shopping_cart_clo_res 401123 401123 0 0.00 0 14772 16 0 0
sp_get_clo_for_invoice 4231 4231 0 0.00 0 19718 301 0 0
sp_kill_cost_storno 13926 13926 0 0.00 0 11459 73 0 0
sp_kill_qstorno_ret_qs2qd 923933 923933 0 0.00 0 62851 32 0 0
sp_kill_qty_storno 488050 488050 0 0.00 0 62863 70 0 0
sp_lock_selected_doc 17921 17921 0 0.00 0 7027 6 0 0
sp_make_cost_storno 24090 24090 0 0.00 0 19038 69 0 0
sp_multiply_rows_for_pdistr 24088 24088 0 0.00 0 14180 32 0 0
sp_multiply_rows_for_qdistr 18142 18142 0 0.00 0 19882 188 0 0
sp_pay_from_customer 6186 6186 0 0.00 4 16044 130 0 0
sp_pay_to_supplier 4941 4941 0 0.00 5 18987 162 0 0
sp_payment_common 11125 11125 0 0.00 2 16018 46 0 0
sp_qd_handle_on_cancel_clo 1508 1508 0 0.00 0 10274 337 0 0
sp_qd_handle_on_invoice_upd_sts 8925 8925 0 0.00 0 26027 368 0 0
sp_qd_handle_on_reserve_upd_sts 8732 8732 0 0.00 0 16638 63 0 0
sp_reserve_write_off 8732 8732 0 0.00 7 19873 208 0 0
sp_supplier_invoice 4801 4801 0 0.00 7 120160 3358 0 0
sp_supplier_order 4722 4722 0 0.00 5 56504 1198 0 0
srv_aggregate_perf_data 72 72 0 0.00 1806 698027 25669 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1444 109697 40942 0 0
srv_find_qd_qs_mism 887097 887097 0 0.00 0 13440 6 0 0
srv_make_invnt_saldo 542 542 0 0.00 30 23360 882 0 0
srv_make_money_saldo 677 677 0 0.00 0 371 28 0 0
srv_recalc_idx_stat 3 3 0 0.00 146809 322381 245918 0 0
t$perf-abend:sp_add_invoice_to_stock 68 68 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4243 4243 0 0.00 0 7626 178 0 0
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 1 2972 97 0 0
t$perf-norm:sp_cancel_client_order 1508 1508 0 0.00 0 700 9 0 0
t$perf-norm:sp_cancel_customer_reserve 568 568 0 0.00 0 1851 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 586 586 0 0.00 0 496 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 618 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 331 331 0 0.00 0 3580 31 0 0
t$perf-norm:sp_cancel_supplier_order 363 363 0 0.00 0 25039 1812 0 0
t$perf-norm:sp_cancel_write_off 869 869 0 0.00 0 3191 11 0 0
t$perf-norm:sp_client_order 18142 18142 0 0.00 0 8520 16 0 0
t$perf-norm:sp_customer_reserve 909 909 0 0.00 0 5735 9 0 0
t$perf-norm:sp_pay_from_customer 6186 6186 0 0.00 0 3480 9 0 0
t$perf-norm:sp_pay_to_supplier 4941 4941 0 0.00 0 4147 10 0 0
t$perf-norm:sp_reserve_write_off 8732 8732 0 0.00 0 4621 11 0 0
t$perf-norm:sp_supplier_invoice 4801 4801 0 0.00 0 5488 16 0 0
t$perf-norm:sp_supplier_order 4722 4722 0 0.00 0 3596 13 0 0
t$perf-norm:srv_aggregate_perf_data 72 72 0 0.00 0 580 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 10 1 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 434 17 0 0
t$perf-norm:srv_make_money_saldo 677 677 0 0.00 0 956 19 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 19 7 0 0
v_add_invoice_to_stock 8582 8446 136 1.58 0 7397 18 0 136
v_all_customers 33678 33678 0 0.00 0 120 1 0 0
v_all_suppliers 26780 26780 0 0.00 0 23 1 0 0
v_all_wares 36273 36273 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 738 738 0 0.00 0 4757 17 0 0
v_cancel_client_order 3016 3016 0 0.00 0 5699 9 0 0
v_cancel_customer_prepayment 1172 1172 0 0.00 0 6232 16 0 0
v_cancel_customer_reserve 1136 1136 0 0.00 0 1218 5 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 2375 10 0 0
v_cancel_supplier_invoice 678 662 16 2.35 0 4233 23 0 16
v_cancel_supplier_order 726 726 0 0.00 0 1830 6 0 0
v_cancel_write_off 1738 1738 0 0.00 0 6526 19 0 0
v_max_id_clo_ord 4717 4717 0 0.00 0 7149 4 0 0
v_max_id_clo_res 909 909 0 0.00 0 3199 15 0 0
v_max_id_ord_sup 4790 4790 0 0.00 0 5984 5 0 0
v_max_non_paid_invoice 1056 1056 0 0.00 0 3657 7 0 0
v_max_non_paid_realizn 2923 2923 0 0.00 0 4370 7 0 0
v_min_id_clo_ord 4717 4717 0 0.00 0 9624 11 0 0
v_min_id_clo_res 909 909 0 0.00 0 4715 10 0 0
v_min_id_ord_sup 4790 4790 0 0.00 0 9350 15 0 0
v_min_non_paid_invoice 4939 4939 0 0.00 0 12816 34 0 0
v_min_non_paid_realizn 6186 6186 0 0.00 0 16012 32 0 0
v_our_firm 9120 9120 0 0.00 0 20 1 0 0
v_reserve_write_off 17464 17464 0 0.00 0 4590 7 0 0
x_lock_depdocs_on_canc_invoice 9569 9569 0 0.00 0 24577 132 0 0
x_lock_depdocs_on_canc_sup_ord 363 363 0 0.00 0 8649 384 0 0
x_make_qstorno_1000_1200 4722 4722 0 0.00 1 54694 1117 0 0
x_make_qstorno_1200_2000 4801 4801 0 0.00 3 110982 3225 0 0
x_make_qstorno_2100_3300 401134 401134 0 0.00 0 47063 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-03-2024 01:10:37 to 17-03-2024 01:10:41.

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:48 5 8192000000 8805365072 8818757632 10821808 0.131 3 2 3 0 10966320 69568 74944
23:10:49 36643 8192000000 9911280512 10226606080 986412560 10.747 100 89 178 0 1015941808 6573520 22955728
23:12:31 21437 8192000000 9946004064 10270380032 1029840784 11.167 100 91 182 0 1062268064 9095616 23331664
23:13:58 17946 8192000000 9983097952 10318782464 1067163040 11.525 100 88 176 0 1098684064 9931904 21589120
23:15:24 11224 8192000000 10037099328 10382843904 1119075952 12.018 100 88 176 1 1152477408 12439920 20961536
23:16:47 5179 8192000000 10080923920 10438713344 1170490544 12.501 100 83 167 0 1202706128 13342512 18873072
23:17:57 3218 8192000000 10116402432 10480631808 1200295776 12.779 100 86 172 0 1232707616 13229344 19182496
23:19:02 6207 8192000000 10154936592 10526892032 1238861456 13.136 100 81 162 0 1270198368 13569616 17767296
23:20:11 1196 8192000000 10183001360 10569003008 1276047472 13.477 100 78 154 0 1305899168 12424080 17427616
23:21:13 1333 8192000000 10217494832 10603798528 1301010768 13.704 100 83 165 1 1333485072 14227680 18246624
23:22:15 55060 8192000000 10219429392 10619166720 1307289776 13.761 100 48 96 0 1324934544 5459552 12185216
23:24:11 6768 8192000000 10210933424 10622812160 1316406256 13.844 100 28 57 1 1329726192 6796592 6523344
23:25:24 9771 8192000000 10215378768 10637471744 1328405520 13.953 100 20 40 0 1343010704 10540720 4064464
23:26:34 18275 8192000000 10233727344 10643210240 1335506976 14.017 100 20 38 0 1346419136 6133488 4778672
23:27:53 18318 8192000000 10230400544 10652688384 1343112944 14.085 100 27 52 3 1354745552 5517744 6114864
23:29:12 10464 8192000000 10227014688 10643439616 1306444624 13.754 97 17 35 0 1315510640 4916848 4149168
23:30:30 29569 8192000000 10255483088 10663309312 1344750400 14.100 100 51 100 2 1366370672 10958848 10661424
23:32:19 54715 8192000000 10255610656 10678784000 1331932784 13.985 98 35 69 1 1355409216 14752640 8723792
23:34:33 72322 8192000000 10253794032 10676396032 1302124592 13.715 96 32 64 2 1327425136 17655296 7645248
23:36:58 29717 8192000000 10262287024 10679963648 1334167296 14.005 99 39 76 0 1366582656 23122880 9292480
23:39:07 16603 8192000000 10269225072 10683838464 1342050144 14.076 100 49 97 0 1380155920 25870816 12234960
23:40:29 9568 8192000000 10280669088 10686476288 1346503072 14.116 100 62 119 0 1389004496 29381584 13119840
23:41:45 6275 8192000000 10288851456 10690588672 1347934400 14.129 100 70 136 1 1392283824 28639808 15709616
23:42:58 8604 8192000000 10265760352 10663120896 1323561488 13.909 100 72 142 1 1371587952 31307408 16719056
23:44:13 15466 8192000000 10273251280 10678833152 1327747312 13.947 99 62 124 0 1375710848 32775504 15188032
23:45:36 1442 8192000000 10295571792 10697207808 1352506240 14.170 100 72 144 0 1398777536 29470832 16800464
23:46:41 3537 8192000000 10293986048 10699862016 1353336032 14.177 100 66 132 1 1397147152 27929408 15881712
23:47:48 2696 8192000000 10299002656 10710265856 1356598736 14.207 100 66 131 0 1408268496 35261376 16408384
23:48:55 5267 8192000000 10312969728 10721480704 1363266208 14.267 100 69 133 1 1420871872 41299024 16306640
23:50:04 4859 8192000000 10322165072 10735828992 1370308464 14.330 100 69 135 0 1429427232 42051824 17066944
23:51:16 6002 8192000000 10325939856 10748145664 1381060768 14.426 100 49 98 0 1428735264 35602832 12071664
23:52:27 4992 8192000000 10340294672 10758561792 1394788032 14.549 100 49 98 0 1437896448 30926480 12181936
23:53:35 29259 8192000000 10312754112 10760908800 1374620544 14.368 99 25 48 0 1421379280 40136160 6622576
23:55:06 34092 8192000000 10290859408 10763853824 1371077472 14.337 100 11 22 0 1405333664 31333328 2922864
23:56:59 31195 8192000000 10291728224 10733170688 1375298976 14.374 99 19 40 0 1392562944 12379312 4884656
23:58:34 94497 8192000000 10284176912 10732285952 1368476832 14.313 99 26 52 0 1389451728 15424208 5550688
00:02:46 9978 8192000000 10296926960 10733973504 1378828752 14.406 100 55 106 1 1398384960 6925664 12630544
00:04:07 42032 8192000000 10282921760 10742378496 1390067712 14.506 100 21 42 1 1403904384 9234960 4601712
00:05:50 32709 8192000000 10298008000 10752684032 1393199888 14.534 100 16 32 0 1406135600 8792864 4142848
00:07:26 36997 8192000000 10313256304 10759405568 1400275728 14.597 100 18 36 0 1414719216 10021520 4421968
00:09:04 63407 8192000000 10300191296 10762874880 1391940080 14.523 99 26 52 0 1409101776 10410720 6750976
00:11:20 33209 8192000000 10316430960 10768846848 1410579088 14.689 100 28 56 1 1428282320 11369408 6333824
00:13:01 18320 8192000000 10295622368 10749988864 1404399488 14.634 100 29 58 0 1420752688 9470944 6882256
00:14:20 65849 8192000000 10307912592 10756325376 1363553536 14.269 97 27 50 0 1381377264 11556000 6267728
00:16:30 65250 8192000000 10301478224 10758877184 1362486736 14.260 97 17 34 0 1382729568 16251280 3991552
00:18:41 68299 8192000000 10256724208 10715144192 1312652144 13.810 95 17 34 0 1328263456 12100784 3510528
00:20:50 106861 8192000000 10267130672 10733871104 1309437184 13.781 95 17 34 0 1330179648 16912512 3829952
00:23:43 14001 8192000000 10272499632 10701774848 1335129328 14.013 98 35 70 0 1351147584 8363696 7654560
00:25:19 25907 8192000000 10281468656 10709233664 1331117456 13.977 98 37 72 0 1350382832 11572208 7693168
00:26:45 67271 8192000000 10265466256 10715267072 1320752784 13.884 97 21 42 0 1341732032 16643728 4335520
00:29:15 59330 8192000000 10269810384 10717802496 1359475616 14.233 100 16 32 0 1377694384 14939376 3279392
00:31:17 53484 8192000000 10255784816 10718191616 1349592048 14.144 99 10 20 0 1366421344 14424368 2404928
00:33:11 34174 8192000000 10259059824 10716762112 1364899536 14.281 100 13 26 0 1379538368 11506384 3132448
00:34:53 65629 8192000000 10262980368 10712981504 1346436496 14.115 98 23 46 1 1361361696 9816656 5108544
00:37:04 71435 8192000000 10257148704 10718740480 1345619088 14.108 98 9 18 0 1358537120 10848224 2069808
00:39:23 51795 8192000000 10248210896 10691981312 1315070720 13.832 96 15 30 0 1327340592 9027424 3242448
00:41:15 83071 8192000000 10255940784 10715815936 1345786528 14.110 99 11 22 1 1358571088 10450880 2333680
00:43:46 28872 8192000000 10287460928 10720579584 1356601712 14.207 99 43 86 1 1377160064 10633968 9924384
00:45:38 73401 8192000000 10278630512 10734661632 1370554960 14.332 100 25 50 0 1391970496 15949984 5465552
00:47:56 17040 8192000000 10299567696 10740723712 1382127248 14.436 100 38 76 0 1405581952 14129232 9325472
00:49:39 24304 8192000000 10292502432 10738315264 1372738064 14.352 100 38 76 1 1400036976 19327040 7971872
00:52:56 6459 8192000000 10312339504 10740498432 1388394352 14.492 100 54 108 1 1416428432 16270928 11763152
00:54:04 99490 8192000000 10290665120 10753286144 1375239696 14.374 99 21 42 0 1398752064 17725360 5787008
00:56:52 35191 8192000000 10268608320 10728366080 1365946704 14.291 99 7 14 0 1376535152 9086960 1501488
00:58:31 51253 8192000000 10285030944 10744451072 1388681328 14.494 100 10 20 0 1403319696 12420144 2218224
01:00:23 84849 8192000000 10286138640 10740387840 1368132384 14.310 98 14 28 0 1378818080 7489712 3195984
01:02:55 52306 8192000000 10270563312 10722623488 1328910784 13.957 95 20 40 0 1346327040 12593648 4822608
01:04:53 57320 8192000000 10286220240 10725855232 1354408368 14.187 98 18 36 0 1371333488 12858992 4066128
01:06:52 109697 8192000000 10280165184 10733785088 1308267600 13.770 94 20 40 0 1329805936 17052864 4485472

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-03-2024 01:10:43 to 17-03-2024 01:10:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 68 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-03-2024 01:10:58 to 17-03-2024 01:11:00.

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          175768
MON$OLDEST_ACTIVE               177057
MON$OLDEST_SNAPSHOT             177057
MON$NEXT_TRANSACTION            177057
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                       1901088
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.33736 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33736 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33736 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33736 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Mar 17 01:11:01 2024 
 
Database header page information: 
    Flags            0 
    Generation        92176 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175768 
    Oldest active        177057 
    Oldest snapshot        177057 
    Next transaction    177058 
    Sequence number        0 
    Next attachment ID    718 
    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.12, total records: 7773890 
    Average version length: 48.16, total versions: 124570, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86600 
    Data pages: 86600, average fill: 72% 
    Primary pages: 86600, secondary pages: 0, swept pages: 14360 
    Empty pages: 7, full pages: 73775 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 184 
    40 - 59% = 2825 
    60 - 79% = 83543 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23314, nodes: 7773890 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1744592, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 336 
        20 - 39% = 1687 
        40 - 59% = 4234 
        60 - 79% = 2494 
        80 - 99% = 14563 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13539, nodes: 7773890 
    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: 1566458, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1453 
        40 - 59% = 2157 
        60 - 79% = 1146 
        80 - 99% = 8783 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8344, nodes: 7773890 
    Average node length: 6.61, total dup: 5820001, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1559382, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 891 
        40 - 59% = 1459 
        60 - 79% = 950 
        80 - 99% = 4924 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.75, total records: 2245966 
    Average version length: 34.63, total versions: 128516, max versions: 3 
    Average fragment length: 5.50, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28448 
    Data pages: 28448, average fill: 73% 
    Primary pages: 28441, secondary pages: 7, swept pages: 8485 
    Empty pages: 2, full pages: 23177 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 245 
    40 - 59% = 2348 
    60 - 79% = 24323 
    80 - 99% = 1497 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4543, nodes: 2245966 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 694353, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 848 
        40 - 59% = 905 
        60 - 79% = 748 
        80 - 99% = 2042 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2541, nodes: 2249392 
    Average node length: 4.97, total dup: 2248493, max dup: 19278 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1256413, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 282 
        40 - 59% = 1566 
        60 - 79% = 528 
        80 - 99% = 163 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2014, nodes: 2245966 
    Average node length: 4.97, total dup: 2245916, max dup: 130569 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1058641, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 114 
        40 - 59% = 996 
        60 - 79% = 85 
        80 - 99% = 816 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4307, nodes: 2245966 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 694353, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 551 
        40 - 59% = 615 
        60 - 79% = 836 
        80 - 99% = 2220 
 
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.27, total records: 400 
    Average version length: 22.92, total versions: 251288, max versions: 652 
    Average fragment length: 2.00, total fragments: 57, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1400 
    Data pages: 1400, average fill: 89% 
    Primary pages: 13, secondary pages: 1387, swept pages: 0 
    Empty pages: 6, full pages: 1393 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 1392 
 
    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: 11.05, total records: 138004 
    Average version length: 68.29, total versions: 115689, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.96 
    Pointer pages: 7, data page slots: 3048 
    Data pages: 2296, average fill: 74% 
    Primary pages: 2295, secondary pages: 1, swept pages: 0 
    Empty pages: 114, full pages: 1637 
    Fill distribution: 
     0 - 19% = 170 
    20 - 39% = 153 
    40 - 59% = 185 
    60 - 79% = 421 
    80 - 99% = 1367 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1696953, depth: 3, leaf buckets: 405, nodes: 138004 
    Average node length: 13.10, total dup: 10816, max dup: 2 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.32, average data length: 7.68 
    Clustering factor: 101165, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 276 
        60 - 79% = 114 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18358, max versions: 968 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 64 
 
    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: 5.19, total records: 2424 
    Average version length: 43.55, total versions: 2144, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 11.18 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 76% 
    Primary pages: 29, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 22 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92055, depth: 2, leaf buckets: 5, nodes: 2424 
    Average node length: 4.18, total dup: 2326, max dup: 268 
    Average key length: 2.44, compression ratio: 7.78 
    Average prefix length: 18.60, average data length: 0.40 
    Clustering factor: 1244, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        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: 97.13, total records: 69 
    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: 48% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 69 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.70, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    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.44, total records: 830208 
    Average version length: 25.44, total versions: 96538, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 8160 
    Data pages: 8160, average fill: 72% 
    Primary pages: 8139, secondary pages: 21, swept pages: 944 
    Empty pages: 19, full pages: 7613 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 58 
    40 - 59% = 90 
    60 - 79% = 7539 
    80 - 99% = 431 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 917, nodes: 830208 
    Average node length: 4.87, total dup: 830159, max dup: 157861 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91964, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 131 
        40 - 59% = 517 
        60 - 79% = 204 
        80 - 99% = 64 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1009, nodes: 830208 
    Average node length: 5.88, total dup: 739206, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166092, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 103 
        40 - 59% = 539 
        60 - 79% = 97 
        80 - 99% = 268 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1051, nodes: 830208 
    Average node length: 5.88, total dup: 739206, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 168086, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 201 
        40 - 59% = 502 
        60 - 79% = 70 
        80 - 99% = 278 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1191, nodes: 830208 
    Average node length: 5.96, total dup: 739206, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 160532, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 249 
        40 - 59% = 647 
        60 - 79% = 212 
        80 - 99% = 80 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.81, total records: 5409 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.69, total fragments: 58, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 72, secondary pages: 24, swept pages: 53 
    Empty pages: 14, full pages: 59 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 65 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5409 
    Average node length: 5.45, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.35, average data length: 1.54 
    Clustering factor: 5033, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5409 
    Average node length: 11.08, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 140, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 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.09, total records: 81396 
    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: 0, full pages: 783 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 784 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37712, depth: 2, leaf buckets: 104, nodes: 81396 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3047, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.62, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.93, total records: 153633 
    Average version length: 150.99, total versions: 2823, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 6, data page slots: 4184 
    Data pages: 3712, average fill: 85% 
    Primary pages: 3712, secondary pages: 0, swept pages: 6 
    Empty pages: 64, full pages: 3623 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3622 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 146.94, total records: 159177 
    Average version length: 151.22, total versions: 4104, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 8, data page slots: 4824 
    Data pages: 3864, average fill: 85% 
    Primary pages: 3864, secondary pages: 0, swept pages: 4 
    Empty pages: 84, full pages: 3758 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 12 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3758 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 130.55, total records: 202404 
    Average version length: 153.53, total versions: 27905, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.99 
    Pointer pages: 8, data page slots: 5736 
    Data pages: 4896, average fill: 87% 
    Primary pages: 4895, secondary pages: 1, swept pages: 4 
    Empty pages: 73, full pages: 4798 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4798 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 136.53, total records: 183894 
    Average version length: 154.46, total versions: 17581, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.42 
    Pointer pages: 7, data page slots: 4936 
    Data pages: 4456, average fill: 86% 
    Primary pages: 4456, secondary pages: 0, swept pages: 5 
    Empty pages: 80, full pages: 4357 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 12 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4355 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.21, total records: 144499 
    Average version length: 149.27, total versions: 1550, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 5, data page slots: 4376 
    Data pages: 3496, average fill: 85% 
    Primary pages: 3496, secondary pages: 0, swept pages: 3 
    Empty pages: 65, full pages: 3412 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 3412 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 132.22, total records: 187896 
    Average version length: 154.61, total versions: 23190, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.83 
    Pointer pages: 7, data page slots: 6200 
    Data pages: 4520, average fill: 87% 
    Primary pages: 4520, secondary pages: 0, swept pages: 2 
    Empty pages: 46, full pages: 4448 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4449 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 135.80, total records: 185958 
    Average version length: 154.75, total versions: 18478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.49 
    Pointer pages: 6, data page slots: 5680 
    Data pages: 4480, average fill: 86% 
    Primary pages: 4479, secondary pages: 1, swept pages: 1 
    Empty pages: 56, full pages: 4405 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 4405 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.75, total records: 164468 
    Average version length: 150.86, total versions: 3437, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 6, data page slots: 4808 
    Data pages: 3936, average fill: 86% 
    Primary pages: 3936, secondary pages: 0, swept pages: 3 
    Empty pages: 34, full pages: 3885 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3884 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.82, total records: 169047 
    Average version length: 150.22, total versions: 2354, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 8, data page slots: 5184 
    Data pages: 4056, average fill: 86% 
    Primary pages: 4055, secondary pages: 1, swept pages: 1 
    Empty pages: 45, full pages: 3995 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3995 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 134.53, total records: 184263 
    Average version length: 155.22, total versions: 20054, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.61 
    Pointer pages: 7, data page slots: 5848 
    Data pages: 4472, average fill: 86% 
    Primary pages: 4472, secondary pages: 0, swept pages: 1 
    Empty pages: 82, full pages: 4368 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4366 
 
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.40, total records: 2110465 
    Average version length: 52.86, total versions: 53910, 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: 25392 
    Data pages: 25392, average fill: 72% 
    Primary pages: 25392, secondary pages: 0, swept pages: 9261 
    Empty pages: 291, full pages: 21949 
    Fill distribution: 
     0 - 19% = 522 
    20 - 39% = 398 
    40 - 59% = 833 
    60 - 79% = 23159 
    80 - 99% = 480 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2615, nodes: 2110465 
    Average node length: 5.44, total dup: 1969528, max dup: 1193 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183800, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 287 
        40 - 59% = 1754 
        60 - 79% = 296 
        80 - 99% = 274 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2755, nodes: 2110465 
    Average node length: 5.69, total dup: 1894910, max dup: 67 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 378416, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2409 
        60 - 79% = 313 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2146, nodes: 2110465 
    Average node length: 4.96, total dup: 2110365, max dup: 27747 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 181217, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 196 
        40 - 59% = 1141 
        60 - 79% = 398 
        80 - 99% = 410 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 34.93, total records: 165899 
    Average version length: 69.18, total versions: 82179, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.61 
    Pointer pages: 3, data page slots: 4192 
    Data pages: 3360, average fill: 58% 
    Primary pages: 3360, secondary pages: 0, swept pages: 527 
    Empty pages: 753, full pages: 2233 
    Fill distribution: 
     0 - 19% = 970 
    20 - 39% = 65 
    40 - 59% = 41 
    60 - 79% = 721 
    80 - 99% = 1563 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104555, depth: 3, leaf buckets: 233, nodes: 165899 
    Average node length: 6.45, total dup: 144559, max dup: 14 
    Average key length: 3.91, compression ratio: 10.74 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 28083, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 112 
        60 - 79% = 74 
        80 - 99% = 22 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.05, total records: 7404061 
    Average version length: 68.80, total versions: 526206, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 64, data page slots: 104008 
    Data pages: 104008, average fill: 76% 
    Primary pages: 104008, secondary pages: 0, swept pages: 17063 
    Empty pages: 45, full pages: 93584 
    Fill distribution: 
     0 - 19% = 236 
    20 - 39% = 713 
    40 - 59% = 3099 
    60 - 79% = 88356 
    80 - 99% = 11604 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10817, nodes: 7404061 
    Average node length: 6.50, total dup: 6408231, max dup: 41 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1648056, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1175 
        40 - 59% = 5955 
        60 - 79% = 3134 
        80 - 99% = 549 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8765, nodes: 7404061 
    Average node length: 5.39, total dup: 7116499, max dup: 205 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1428838, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 944 
        40 - 59% = 5094 
        60 - 79% = 1585 
        80 - 99% = 1126 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8817, nodes: 7404061 
    Average node length: 5.39, total dup: 7116499, max dup: 205 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1431365, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 976 
        40 - 59% = 5110 
        60 - 79% = 1587 
        80 - 99% = 1138 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.47, total records: 12319005 
    Average version length: 68.69, total versions: 443340, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 104, data page slots: 168592 
    Data pages: 168592, average fill: 78% 
    Primary pages: 168592, secondary pages: 0, swept pages: 63095 
    Empty pages: 3, full pages: 168543 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 7 
    60 - 79% = 157246 
    80 - 99% = 11335 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18436, nodes: 12319005 
    Average node length: 6.59, total dup: 10739045, max dup: 78 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2411229, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2016 
        40 - 59% = 10512 
        60 - 79% = 4969 
        80 - 99% = 910 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 36.88, total records: 2007217 
    Average version length: 69.13, total versions: 936689, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.42 
    Pointer pages: 26, data page slots: 42000 
    Data pages: 29016, average fill: 80% 
    Primary pages: 29016, secondary pages: 0, swept pages: 2316 
    Empty pages: 535, full pages: 26152 
    Fill distribution: 
     0 - 19% = 904 
    20 - 39% = 623 
    40 - 59% = 633 
    60 - 79% = 10331 
    80 - 99% = 16525 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2366, nodes: 2007217 
    Average node length: 5.50, total dup: 1926431, max dup: 99 
    Average key length: 2.54, compression ratio: 16.54 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 137649, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 223 
        40 - 59% = 1126 
        60 - 79% = 712 
        80 - 99% = 286 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 33.73, total records: 1277683 
    Average version length: 69.13, total versions: 653281, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.74 
    Pointer pages: 23, data page slots: 36304 
    Data pages: 29408, average fill: 51% 
    Primary pages: 29407, secondary pages: 1, swept pages: 6733 
    Empty pages: 7366, full pages: 16234 
    Fill distribution: 
     0 - 19% = 10793 
    20 - 39% = 940 
    40 - 59% = 456 
    60 - 79% = 5552 
    80 - 99% = 11667 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1574, nodes: 1277683 
    Average node length: 5.75, total dup: 1197204, max dup: 101 
    Average key length: 2.81, compression ratio: 14.97 
    Average prefix length: 41.26, average data length: 0.74 
    Clustering factor: 170138, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 194 
        40 - 59% = 694 
        60 - 79% = 486 
        80 - 99% = 192 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.97, total records: 9269340 
    Average version length: 68.93, total versions: 663968, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 87, data page slots: 141592 
    Data pages: 141552, average fill: 70% 
    Primary pages: 141551, secondary pages: 1, swept pages: 36315 
    Empty pages: 311, full pages: 96768 
    Fill distribution: 
     0 - 19% = 1123 
    20 - 39% = 7061 
    40 - 59% = 19964 
    60 - 79% = 99122 
    80 - 99% = 14282 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13441, nodes: 9269340 
    Average node length: 6.67, total dup: 7689753, max dup: 25 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2066702, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1080 
        40 - 59% = 6947 
        60 - 79% = 4826 
        80 - 99% = 587 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21187477 
    Average version length: 82.87, total versions: 17662, 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: 319128 
    Data pages: 319128, average fill: 81% 
    Primary pages: 319128, secondary pages: 0, swept pages: 10998 
    Empty pages: 3, full pages: 319124 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26594 
    80 - 99% = 292530 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19422, nodes: 21187477 
    Average node length: 5.72, total dup: 20705578, max dup: 138 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286583, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8134 
        60 - 79% = 595 
        80 - 99% = 10687 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17194, nodes: 21187477 
    Average node length: 6.31, total dup: 18620092, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914618, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 787 
        60 - 79% = 259 
        80 - 99% = 16142 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21219, nodes: 21187477 
    Average node length: 6.35, total dup: 18538706, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3581460, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8429 
        60 - 79% = 650 
        80 - 99% = 12133 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16133, nodes: 21187477 
    Average node length: 5.56, total dup: 21187377, max dup: 228625 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943539, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 2884 
        60 - 79% = 425 
        80 - 99% = 12820 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.66, total records: 9743835 
    Average version length: 82.60, total versions: 680592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 103, data page slots: 167184 
    Data pages: 167112, average fill: 72% 
    Primary pages: 167112, secondary pages: 0, swept pages: 50308 
    Empty pages: 319, full pages: 112331 
    Fill distribution: 
     0 - 19% = 1243 
    20 - 39% = 6912 
    40 - 59% = 21728 
    60 - 79% = 60588 
    80 - 99% = 76641 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11345, nodes: 9743835 
    Average node length: 5.35, total dup: 9436369, max dup: 216 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2196461, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 57 
        40 - 59% = 8206 
        60 - 79% = 2992 
        80 - 99% = 85 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13448, nodes: 9743835 
    Average node length: 6.21, total dup: 8078491, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1549391, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 3720 
        40 - 59% = 4543 
        60 - 79% = 2684 
        80 - 99% = 2393 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12664, nodes: 9743835 
    Average node length: 5.96, total dup: 8461847, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2389776, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 69 
        40 - 59% = 9213 
        60 - 79% = 3286 
        80 - 99% = 94 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10123, nodes: 9743835 
    Average node length: 5.12, total dup: 9743735, max dup: 154944 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1571596, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1194 
        40 - 59% = 5075 
        60 - 79% = 1726 
        80 - 99% = 2088 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.30, total records: 11425325 
    Average version length: 82.57, total versions: 555155, 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: 118, data page slots: 192392 
    Data pages: 190920, average fill: 74% 
    Primary pages: 190920, secondary pages: 0, swept pages: 60728 
    Empty pages: 2880, full pages: 147917 
    Fill distribution: 
     0 - 19% = 4927 
    20 - 39% = 7320 
    40 - 59% = 15991 
    60 - 79% = 39063 
    80 - 99% = 123619 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13138, nodes: 11425325 
    Average node length: 5.30, total dup: 11315018, max dup: 666 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2383822, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 129 
        40 - 59% = 8962 
        60 - 79% = 3818 
        80 - 99% = 226 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10603, nodes: 11425325 
    Average node length: 5.50, total dup: 10926513, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 720981, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 858 
        40 - 59% = 2695 
        60 - 79% = 1839 
        80 - 99% = 5044 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15015, nodes: 11425325 
    Average node length: 6.02, total dup: 9974495, max dup: 81 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2400403, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 158 
        40 - 59% = 10519 
        60 - 79% = 4044 
        80 - 99% = 293 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10931, nodes: 11425325 
    Average node length: 5.22, total dup: 11425225, max dup: 208570 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 708780, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 818 
        40 - 59% = 5026 
        60 - 79% = 1486 
        80 - 99% = 3513 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.16, total records: 9838772 
    Average version length: 82.88, total versions: 663532, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 106, data page slots: 171664 
    Data pages: 171536, average fill: 71% 
    Primary pages: 171536, secondary pages: 0, swept pages: 55068 
    Empty pages: 757, full pages: 111909 
    Fill distribution: 
     0 - 19% = 2136 
    20 - 39% = 8078 
    40 - 59% = 24151 
    60 - 79% = 61264 
    80 - 99% = 75907 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11769, nodes: 9838772 
    Average node length: 5.16, total dup: 9810196, max dup: 2368 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2006478, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1455 
        40 - 59% = 7686 
        60 - 79% = 1944 
        80 - 99% = 651 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13533, nodes: 9838772 
    Average node length: 6.23, total dup: 8156760, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1513290, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 196 
        20 - 39% = 3597 
        40 - 59% = 4468 
        60 - 79% = 2735 
        80 - 99% = 2537 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12466, nodes: 9838772 
    Average node length: 5.42, total dup: 9401371, max dup: 117 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2140489, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1469 
        40 - 59% = 8699 
        60 - 79% = 1696 
        80 - 99% = 577 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10197, nodes: 9838772 
    Average node length: 5.14, total dup: 9838672, max dup: 157089 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1587610, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1207 
        40 - 59% = 5030 
        60 - 79% = 1758 
        80 - 99% = 2158 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.08, total records: 579101 
    Average version length: 68.83, total versions: 9233, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 76% 
    Primary pages: 7976, secondary pages: 0, swept pages: 3260 
    Empty pages: 0, full pages: 7174 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 21 
    40 - 59% = 171 
    60 - 79% = 7624 
    80 - 99% = 157 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 49488, depth: 3, leaf buckets: 749, nodes: 579101 
    Average node length: 5.95, total dup: 493140, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101091, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 529 
        60 - 79% = 107 
        80 - 99% = 80 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 39502, depth: 3, leaf buckets: 761, nodes: 579101 
    Average node length: 6.15, total dup: 474968, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101150, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 537 
        60 - 79% = 100 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 582, nodes: 579101 
    Average node length: 4.86, total dup: 579001, max dup: 9828 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89749, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 340 
        60 - 79% = 108 
        80 - 99% = 103 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar 17 01:11:24 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7773890 124570 1 0.0000 0.0000
DOC_LIST 2245966 128516 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 251288 652 62800.0000 0.0000
INVNT_TURNOVER_LOG 138004 115689 1 0.0000 0.0000
MONEY_SALDO 49 18358 968 37400.0000 0.0000
MONEY_TURNOVER_LOG 2424 2144 1 0.0000 0.0000
PDISTR 830208 96538 4 0.0000 0.0000
PERF_SPLIT_0 153633 2823 1 0.0000 0.0000
PERF_SPLIT_1 159177 4104 1 0.0000 0.0000
PERF_SPLIT_2 202404 27905 1 0.0000 0.0000
PERF_SPLIT_3 183894 17581 1 0.0000 0.0000
PERF_SPLIT_4 144499 1550 1 0.0000 0.0000
PERF_SPLIT_5 187896 23190 1 0.0000 0.0000
PERF_SPLIT_6 185958 18478 1 0.0000 0.0000
PERF_SPLIT_7 164468 3437 1 0.0000 0.0000
PERF_SPLIT_8 169047 2354 1 0.0000 0.0000
PERF_SPLIT_9 184263 20054 1 0.0000 0.0000
PSTORNED 2110465 53910 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 165899 82179 1 0.0000 0.0000
XQD_1000_3300 7404061 526206 1 0.0000 0.0000
XQD_1200_2000 12319005 443340 1 0.0000 0.0000
XQD_2000_3300 2007217 936689 1 0.0000 0.0000
XQD_2100_3300 1277683 653281 1 0.0000 0.0000
XQD_3300_3400 9269340 663968 1 0.0000 0.0000
XQS_1000_1200 21187477 17662 1 0.0000 0.0000
XQS_1000_3300 9743835 680592 1 0.0000 0.0000
XQS_1200_2000 11425325 555155 1 0.0000 0.0000
XQS_2100_3300 9838772 663532 1 0.0000 0.0000
XQS_3300_3400 579101 9233 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 ---
:37: 
:38: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:46 2024
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:46 2024
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:48 2024
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
:49: 
:50: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:48 2024
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
:53: 
:54: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:48 2024
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
:57: 
:58: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:48 2024
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
:61: 
:62: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:48 2024
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:48 2024
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Sun Mar 17 01:09:48 2024
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
--- end of diff output ---

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

17.03.24 01:11:36. 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-03-17 01:11:39 No severe PSQL-related problems occured
17.03.24 01:11:40. End of report.