Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.02.2024 10:08
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 15748544 kB
MemAvailable 30294376 kB
Buffers 0 kB
Cached 16009172 kB
SwapCached 4820 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-15 10:08:00
DTS_END                         2024-02-15 10:07:48.4760
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/48758
TRN_ID                          169171
ATT_ID                          259
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: 9162.65 24932 916265
customer order: creation 169.75 430 16975
customer order: refuse 14.66 416 1466
order to supplier: creation 45.93 1283 4593
order to supplier: removal 3.50 101211 350
invoice (draft): creation 45.73 2923 4573
invoice (draft): removal 49.23 695 4923
invoice accept: apply 41.72 20514 4172
invoice accept: cancel 45.21 843 4521
customer reserve: creation 3998.87 197 399887
customer reserve: removal 4452.05 66 445205
realization accept: apply 84.44 204 8444
realization accept: cancel 82.69 118 8269
payment from customer: creation 59.96 120 5996
payment from customer: removal 5.47 99 547
payment to supplier: creation 49.25 145 4925
payment to supplier: removal 3.82 62 382
service: total inventory turnovers 3.54 4282 354
service: total monetary turnovers 5.94 595 594
service: aggregate perf. data 0.85 20272 85
service: refresh index statistics 0.04 344166 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 15-02-2024 10:09:19 to 15-02-2024 10:09:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4095
TEST_TIME 2 5105
TEST_TIME 3 4216
TEST_TIME 4 4046
TEST_TIME 5 4264
TEST_TIME 6 4715
TEST_TIME 7 4776
TEST_TIME 8 4694
TEST_TIME 9 5021
TEST_TIME 10 4935
TEST_TIME 11 5163
TEST_TIME 12 5999
TEST_TIME 13 5872
TEST_TIME 14 5905
TEST_TIME 15 6579
TEST_TIME 16 6619
TEST_TIME 17 7320
TEST_TIME 18 7414
TEST_TIME 19 7493
TEST_TIME 20 7815
TEST_TIME 21 8065
TEST_TIME 22 8791
TEST_TIME 23 8802
TEST_TIME 24 9456
TEST_TIME 25 9812
TEST_TIME 26 9928
TEST_TIME 27 9984
TEST_TIME 28 9947
TEST_TIME 29 10052
TEST_TIME 30 9844
TEST_TIME 31 9631
TEST_TIME 32 9567
TEST_TIME 33 9443
TEST_TIME 34 9499
TEST_TIME 35 9342
TEST_TIME 36 9437
TEST_TIME 37 9354
TEST_TIME 38 9230
TEST_TIME 39 9138
TEST_TIME 40 9081
TEST_TIME 41 8926
TEST_TIME 42 9323
TEST_TIME 43 9273
TEST_TIME 44 9310
TEST_TIME 45 9316
TEST_TIME 46 9194
TEST_TIME 47 9332
TEST_TIME 48 9331
TEST_TIME 49 9391
TEST_TIME 50 9354
TEST_TIME 51 9425
TEST_TIME 52 9532
TEST_TIME 53 9652
TEST_TIME 54 9646
TEST_TIME 55 9599
TEST_TIME 56 9573
TEST_TIME 57 9440
TEST_TIME 58 9423
TEST_TIME 59 9389
TEST_TIME 60 9330
TEST_TIME 61 9304
TEST_TIME 62 9222
TEST_TIME 63 9381
TEST_TIME 64 9307
TEST_TIME 65 9261
TEST_TIME 66 9301
TEST_TIME 67 9343
TEST_TIME 68 9346
TEST_TIME 69 9373
TEST_TIME 70 9375
TEST_TIME 71 9449
TEST_TIME 72 9579
TEST_TIME 73 9567
TEST_TIME 74 9570
TEST_TIME 75 9494
TEST_TIME 76 9419
TEST_TIME 77 9337
TEST_TIME 78 9314
TEST_TIME 79 9315
TEST_TIME 80 9276
TEST_TIME 81 9207
TEST_TIME 82 9175
TEST_TIME 83 9185
TEST_TIME 84 9157
TEST_TIME 85 9153
TEST_TIME 86 9200
TEST_TIME 87 9174
TEST_TIME 88 9158
TEST_TIME 89 9278
TEST_TIME 90 9346
TEST_TIME 91 9372
TEST_TIME 92 9376
TEST_TIME 93 9405
TEST_TIME 94 9410
TEST_TIME 95 9323
TEST_TIME 96 9304
TEST_TIME 97 9299
TEST_TIME 98 9256
TEST_TIME 99 9207
TEST_TIME 100 9173

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-02-2024 10:09:23 to 15-02-2024 10:09:26.

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 1283159 1283159 0 0.00 0 22795 7 0 0
doc_list_biud 1283156 1283156 0 0.00 0 46411 28 0 0
sp_add_invoice_to_stock 4339 4172 167 3.84 29 232446 20514 0 167
sp_cancel_adding_invoice 4521 4521 0 0.00 4 60578 844 0 0
sp_cancel_client_order 1466 1466 0 0.00 3 14215 417 0 0
sp_cancel_customer_reserve 445205 445205 0 0.00 0 46413 66 0 0
sp_cancel_pay_from_customer 547 547 0 0.00 2 5392 99 0 0
sp_cancel_pay_to_supplier 382 382 0 0.00 3 1154 63 0 0
sp_cancel_supplier_invoice 4942 4923 19 0.38 1 20676 695 0 19
sp_cancel_supplier_order 350 350 0 0.00 6 1098872 101211 0 0
sp_cancel_write_off 8269 8269 0 0.00 1 9166 119 0 0
sp_client_order 16975 16975 0 0.00 3 32888 430 0 0
sp_customer_reserve 399887 399887 0 0.00 0 55605 198 0 0
sp_fill_shopping_cart 26137 26137 0 0.00 1 24850 36 0 0
sp_fill_shopping_cart_clo_res 399875 399875 0 0.00 0 22541 19 0 0
sp_get_clo_for_invoice 4160 4160 0 0.00 0 23160 372 0 0
sp_kill_cost_storno 13719 13719 0 0.00 0 9024 64 0 0
sp_kill_qstorno_ret_qs2qd 903952 903952 0 0.00 0 46409 35 0 0
sp_kill_qty_storno 477336 477336 0 0.00 0 46411 74 0 0
sp_lock_selected_doc 17386 17386 0 0.00 0 7383 6 0 0
sp_make_cost_storno 23524 23524 0 0.00 0 18843 65 0 0
sp_multiply_rows_for_pdistr 23523 23523 0 0.00 0 11359 32 0 0
sp_multiply_rows_for_qdistr 16975 16975 0 0.00 0 24314 206 0 0
sp_pay_from_customer 5996 5996 0 0.00 3 19278 121 0 0
sp_pay_to_supplier 4925 4925 0 0.00 4 19928 146 0 0
sp_payment_common 10921 10921 0 0.00 1 11240 27 0 0
sp_qd_handle_on_cancel_clo 1466 1466 0 0.00 0 14207 397 0 0
sp_qd_handle_on_invoice_upd_sts 8679 8679 0 0.00 0 29808 282 0 0
sp_qd_handle_on_reserve_upd_sts 8444 8444 0 0.00 0 25272 67 0 0
sp_reserve_write_off 8444 8444 0 0.00 6 25407 204 0 0
sp_supplier_invoice 4573 4573 0 0.00 5 77966 2924 0 0
sp_supplier_order 4593 4593 0 0.00 4 41786 1283 0 0
srv_aggregate_perf_data 85 85 0 0.00 1713 498585 20273 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1973 141242 41363 0 0
srv_find_qd_qs_mism 874325 874325 0 0.00 0 22794 6 0 0
srv_make_invnt_saldo 354 354 0 0.00 21 113563 4282 0 0
srv_make_money_saldo 594 594 0 0.00 1 16678 595 0 0
srv_recalc_idx_stat 4 4 0 0.00 235092 508560 344167 0 0
t$perf-abend:sp_add_invoice_to_stock 167 167 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 19 19 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4173 4173 0 0.00 0 8045 162 0 0
t$perf-norm:sp_cancel_adding_invoice 349 349 0 0.00 0 2350 98 0 0
t$perf-norm:sp_cancel_client_order 1466 1466 0 0.00 0 1437 8 0 0
t$perf-norm:sp_cancel_customer_reserve 543 543 0 0.00 0 808 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 547 547 0 0.00 0 1744 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 382 382 0 0.00 0 522 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 326 326 0 0.00 0 1171 18 0 0
t$perf-norm:sp_cancel_supplier_order 350 350 0 0.00 0 17654 1469 0 0
t$perf-norm:sp_cancel_write_off 821 821 0 0.00 0 3374 19 0 0
t$perf-norm:sp_client_order 16975 16975 0 0.00 0 5784 16 0 0
t$perf-norm:sp_customer_reserve 838 838 0 0.00 0 281 3 0 0
t$perf-norm:sp_pay_from_customer 5996 5996 0 0.00 0 6026 7 0 0
t$perf-norm:sp_pay_to_supplier 4925 4925 0 0.00 0 3884 8 0 0
t$perf-norm:sp_reserve_write_off 8444 8444 0 0.00 0 6908 10 0 0
t$perf-norm:sp_supplier_invoice 4573 4573 0 0.00 0 5374 15 0 0
t$perf-norm:sp_supplier_order 4593 4593 0 0.00 0 6771 13 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 447 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 9 1 0 0
t$perf-norm:srv_make_invnt_saldo 354 354 0 0.00 0 3010 15 0 0
t$perf-norm:srv_make_money_saldo 594 594 0 0.00 0 4618 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 8650 8316 334 3.86 0 18365 22 0 334
v_all_customers 31856 31856 0 0.00 0 36 1 0 0
v_all_suppliers 26034 26034 0 0.00 0 18 1 0 0
v_all_wares 33950 33950 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 698 698 0 0.00 0 2103 10 0 0
v_cancel_client_order 2932 2932 0 0.00 0 2570 4 0 0
v_cancel_customer_prepayment 1094 1094 0 0.00 0 2041 7 0 0
v_cancel_customer_reserve 1086 1086 0 0.00 0 1913 8 0 0
v_cancel_payment_to_supplier 764 764 0 0.00 0 328 3 0 0
v_cancel_supplier_invoice 690 652 38 5.50 0 679 12 0 38
v_cancel_supplier_order 700 700 0 0.00 0 760 4 0 0
v_cancel_write_off 1642 1642 0 0.00 0 1849 13 0 0
v_max_id_clo_ord 4590 4590 0 0.00 0 665 1 0 0
v_max_id_clo_res 838 838 0 0.00 0 3993 19 0 0
v_max_id_ord_sup 4572 4572 0 0.00 0 5246 5 0 0
v_max_non_paid_invoice 1070 1070 0 0.00 0 5327 8 0 0
v_max_non_paid_realizn 2816 2816 0 0.00 0 4503 5 0 0
v_min_id_clo_ord 4590 4590 0 0.00 0 5042 8 0 0
v_min_id_clo_res 838 838 0 0.00 0 8983 27 0 0
v_min_id_ord_sup 4572 4572 0 0.00 0 6053 7 0 0
v_min_non_paid_invoice 4925 4925 0 0.00 0 11215 17 0 0
v_min_non_paid_realizn 5996 5996 0 0.00 0 10762 21 0 0
v_our_firm 8454 8454 0 0.00 0 51 1 0 0
v_reserve_write_off 16888 16888 0 0.00 0 8771 6 0 0
x_lock_depdocs_on_canc_invoice 9118 9118 0 0.00 0 25445 128 0 0
x_lock_depdocs_on_canc_sup_ord 350 350 0 0.00 0 11765 349 0 0
x_make_qstorno_1000_1200 4593 4593 0 0.00 1 39887 1208 0 0
x_make_qstorno_1200_2000 4573 4573 0 0.00 2 77958 2795 0 0
x_make_qstorno_2100_3300 399887 399887 0 0.00 0 53634 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-02-2024 10:09:27 to 15-02-2024 10:09:31.

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
08:07:52 4 8192000000 8803314704 8816152576 8560480 0.104 3 2 3 0 8727568 105712 61376
08:08:53 41049 8192000000 9723436224 10025377792 801419536 8.911 100 84 168 0 829155840 7329600 20406704
08:10:39 15766 8192000000 9757237104 10062557184 833129584 9.231 100 92 184 0 866452896 11545824 21777488
08:12:00 18231 8192000000 9788725456 10102185984 852298112 9.423 100 86 172 0 893629696 20894864 20436720
08:13:28 10647 8192000000 9843917232 10175672320 896488560 9.864 100 79 158 1 952549808 38082288 17978960
08:14:50 12288 8192000000 9895131632 10236755968 940544464 10.298 100 86 171 1 1004516944 46248080 17724400
08:16:06 6667 8192000000 9943975664 10299936768 976144320 10.647 100 68 136 0 1048846976 58892784 13809872
08:17:15 2648 8192000000 9987434640 10346721280 1007736464 10.953 100 85 167 0 1096813696 71855264 17221968
08:18:21 2345 8192000000 10021042864 10386849792 1029485264 11.163 100 89 175 0 1131391600 84650336 17256000
08:19:25 1450 8192000000 10024124432 10397261824 1055762048 11.416 100 88 174 0 1138437840 65435888 17239904
08:20:29 7548 8192000000 10008100144 10393374720 1062270048 11.478 100 59 114 0 1119529696 45078896 12180752
08:21:39 8743 8192000000 9980933632 10383855616 1064452240 11.499 100 33 66 0 1142693696 71488080 6753376
08:22:49 2321 8192000000 10009914512 10404593664 1071373296 11.565 100 46 92 0 1121430640 41114256 8943088
08:23:54 8741 8192000000 10006735888 10412027904 1077467008 11.623 100 28 54 0 1125018192 42178960 5372224
08:25:04 45847 8192000000 9994335472 10391605248 1085165280 11.697 100 57 113 1 1107739472 10141808 12432384
08:26:50 4519 8192000000 10003436352 10417119232 1086952080 11.714 100 33 64 1 1131507072 38061056 6493936
08:27:57 5570 8192000000 10015950608 10412482560 1093116112 11.772 100 50 97 0 1117667008 14747328 9803568
08:29:08 9778 8192000000 10058779840 10459766784 1096935936 11.809 100 57 114 0 1168564144 59535200 12093008
08:30:25 58804 8192000000 10094787104 10502275072 1107267872 11.907 99 57 110 1 1207650880 88904176 11478832
08:33:17 30005 8192000000 10151756896 10569068544 1137215808 12.189 100 37 74 0 1264737776 119317968 8204000
08:34:52 11899 8192000000 10167577728 10575183872 1120450368 12.031 98 46 89 0 1267663664 137396896 9816400
08:36:11 14699 8192000000 10193660640 10607824896 1119786784 12.025 99 40 79 1 1298191648 169219376 9185488
08:37:33 5110 8192000000 10225931088 10629079040 1114595904 11.976 99 50 100 0 1331200688 205619088 10985696
08:38:42 9295 8192000000 10227135680 10629414912 1096853088 11.808 100 53 106 1 1337481200 228529152 12098960
08:39:57 11961 8192000000 10204040896 10621743104 1095480960 11.795 99 48 92 0 1311266416 205024560 10760896
08:41:14 11038 8192000000 10233710832 10640142336 1078662752 11.635 97 53 104 1 1319303536 228950992 11689792
08:42:30 20281 8192000000 10229540816 10638594048 1110488368 11.937 100 52 104 0 1339493232 216730848 12274016
08:43:59 5845 8192000000 10249527264 10670600192 1114582496 11.976 100 66 131 0 1371315264 242064128 14668640
08:45:12 1971 8192000000 10280654144 10675552256 1134734624 12.166 100 77 153 1 1376218240 224878880 16604736
08:46:22 3659 8192000000 10306929264 10711044096 1119412224 12.021 99 72 139 1 1401568944 266373552 15783168
08:47:29 3632 8192000000 10347205104 10759880704 1133784048 12.157 100 58 116 1 1453728240 306057504 13886688
08:48:44 16438 8192000000 10330959600 10769203200 1139569616 12.211 100 30 60 0 1434258976 287064336 7625024
08:50:15 18548 8192000000 10217118064 10675331072 1107033792 11.904 99 13 26 0 1317821152 207369216 3418144
08:51:35 45577 8192000000 10067229984 10555170816 1104561248 11.881 99 7 14 0 1174867920 68939904 1366768
08:53:25 32836 8192000000 10078028176 10549760000 1108595632 11.919 99 10 18 1 1163716656 53465168 1655856
08:55:22 80856 8192000000 10064223168 10548707328 1125585648 12.080 99 9 18 1 1195236288 68032992 1617648
08:57:43 46199 8192000000 10081709984 10521059328 1129103392 12.113 100 35 69 0 1176736432 40831728 6801312
09:00:11 21224 8192000000 10070278336 10500579328 1131325776 12.134 100 34 67 0 1176393600 38492144 6575680
09:01:44 37435 8192000000 10094614848 10515439616 1142693280 12.241 100 36 71 0 1182329776 32329984 7306512
09:03:27 26603 8192000000 10097990160 10565976064 1148253184 12.293 100 28 58 1 1208517904 54318032 5946688
09:04:55 59031 8192000000 10155659408 10603794432 1162002928 12.422 100 30 60 0 1250976608 82201328 6772352
09:07:23 40218 8192000000 10237633984 10696368128 1172857344 12.524 100 19 38 0 1329772192 152322160 4592688
09:09:04 70100 8192000000 10162231168 10768023552 1162165824 12.424 100 17 34 1 1353534048 187098464 4269760
09:11:38 2369 8192000000 10112080096 10590191616 1156648656 12.372 100 67 128 2 1218816208 49113888 13053664
09:12:44 26793 8192000000 10055108224 10508632064 1124609632 12.071 98 18 34 0 1161165360 32825552 3730176
09:14:12 58791 8192000000 10085144336 10603008000 1134445840 12.163 99 24 47 0 1219080960 79948128 4686992
09:16:17 86154 8192000000 10116245728 10581860352 1112437472 11.955 96 13 26 0 1157581440 42579504 2564464
09:19:03 61857 8192000000 10099872208 10562813952 1096232832 11.802 95 11 22 0 1134621744 36330432 2058480
09:21:06 86425 8192000000 10065486960 10510532608 1061174640 11.468 93 18 36 0 1084855536 19916256 3764640
09:23:36 141242 8192000000 10109910864 10577723392 1118261328 12.011 98 42 84 0 1201584784 74682448 8641008
09:27:10 22595 8192000000 10063140384 10522472448 1118996512 12.018 99 23 47 0 1158016304 33999520 5020272
09:28:43 61792 8192000000 10086921856 10525253632 1090427760 11.747 96 13 26 0 1134220704 41068736 2724208
09:30:46 49038 8192000000 10017614736 10450579456 1056205440 11.420 95 12 24 0 1085079072 26445536 2428096
09:32:35 24073 8192000000 10061804224 10474024960 1084875024 11.694 98 43 86 0 1128461040 34391664 9194352
09:34:00 19099 8192000000 10047845552 10472423424 1074094320 11.591 98 39 76 0 1143379184 60517936 8766928
09:35:27 70803 8192000000 10060171344 10525401088 1086748048 11.712 98 45 90 0 1134989440 38930480 9310912
09:37:39 29805 8192000000 10098478368 10535424000 1096442096 11.804 99 41 82 0 1195882448 91031760 8408592
09:39:11 86945 8192000000 10052605312 10503069696 1081307312 11.660 97 17 35 0 1157622240 73020288 3294640
09:41:43 89078 8192000000 10048652880 10474041344 1092152432 11.763 98 30 60 1 1128273840 30435872 5685536
09:44:30 35479 8192000000 10037956544 10470084608 1093551216 11.776 98 23 46 1 1126114224 28109808 4453200
09:46:07 39868 8192000000 10036733344 10504425472 1120910816 12.036 100 7 14 0 1154421344 32426000 1084528
09:48:04 65315 8192000000 10056896048 10512510976 1124168896 12.066 100 8 16 0 1165986912 39939936 1878080
09:50:29 45004 8192000000 10065033600 10513293312 1120449184 12.031 99 15 28 0 1156083360 32463216 3170960
09:52:31 13012 8192000000 10119192160 10553077760 1143977200 12.253 100 37 73 1 1217459520 65600320 7882000
09:53:56 52156 8192000000 10155151328 10599276544 1157371312 12.379 100 22 44 0 1239943392 77829424 4742656
09:55:51 38493 8192000000 10155469920 10676183040 1151852768 12.327 100 29 59 0 1268556336 110068944 6634624
09:57:30 82218 8192000000 10074621024 10552078336 1139688176 12.213 99 29 60 0 1199891408 54159360 6043872
09:59:53 135530 8192000000 10091848352 10538708992 1093242800 11.773 95 16 32 0 1145240640 48790416 3207424
10:04:12 59271 8192000000 10083008832 10576408576 1132314576 12.143 99 4 8 0 1175440352 41834000 1291776
10:06:23 51638 8192000000 10045753408 10518016000 1100827824 11.845 97 12 24 0 1148751248 45403136 2520288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 15-02-2024 10:09:33 to 15-02-2024 10:09:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 167 v_add_invoice_to_stock 335544517
except 19 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-02-2024 10:09:48 to 15-02-2024 10:09:50.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          175257
MON$OLDEST_ACTIVE               175258
MON$OLDEST_SNAPSHOT             175258
MON$NEXT_TRANSACTION            175258
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-30 07:30:08.6030 GMT
MON$PAGES                       1917472
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             685
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3059 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3059 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Feb 15 10:09:51 2024 
 
Database header page information: 
    Flags            0 
    Generation        92659 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    175257 
    Oldest active        175258 
    Oldest snapshot        175258 
    Next transaction    175259 
    Sequence number        0 
    Next attachment ID    685 
    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 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.53, total records: 7688110 
    Average version length: 48.16, total versions: 72139, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88240 
    Data pages: 88240, average fill: 70% 
    Primary pages: 88239, secondary pages: 1, swept pages: 40817 
    Empty pages: 7, full pages: 65242 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 74 
    40 - 59% = 1062 
    60 - 79% = 87064 
    80 - 99% = 25 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23122, nodes: 7688110 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1663497, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 321 
        20 - 39% = 1899 
        40 - 59% = 3987 
        60 - 79% = 2536 
        80 - 99% = 14379 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13428, nodes: 7688110 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1488136, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1633 
        40 - 59% = 1918 
        60 - 79% = 1216 
        80 - 99% = 8661 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8282, nodes: 7688110 
    Average node length: 6.61, total dup: 5764456, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1481090, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 1014 
        40 - 59% = 1270 
        60 - 79% = 1012 
        80 - 99% = 4845 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.63, total records: 2215526 
    Average version length: 58.85, total versions: 36499, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28552 
    Data pages: 28552, average fill: 71% 
    Primary pages: 28550, secondary pages: 2, swept pages: 12020 
    Empty pages: 1, full pages: 16958 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 52 
    40 - 59% = 1036 
    60 - 79% = 27374 
    80 - 99% = 76 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4508, nodes: 2215526 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 673571, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 898 
        40 - 59% = 837 
        60 - 79% = 789 
        80 - 99% = 1984 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2398, nodes: 2216559 
    Average node length: 4.97, total dup: 2215660, max dup: 19764 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253555, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 199 
        40 - 59% = 1402 
        60 - 79% = 559 
        80 - 99% = 237 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1758, nodes: 2215526 
    Average node length: 4.97, total dup: 2215476, max dup: 129959 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1057099, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 606 
        60 - 79% = 44 
        80 - 99% = 1104 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4314, nodes: 2215526 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 673571, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 598 
        40 - 59% = 612 
        60 - 79% = 875 
        80 - 99% = 2129 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.33, total records: 400 
    Average version length: 28.08, total versions: 795, max versions: 3 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 39% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 9, full pages: 8 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 8 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 20.40, total records: 89546 
    Average version length: 68.29, total versions: 72329, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.31 
    Pointer pages: 7, data page slots: 3648 
    Data pages: 1632, average fill: 72% 
    Primary pages: 1631, secondary pages: 1, swept pages: 0 
    Empty pages: 165, full pages: 1137 
    Fill distribution: 
     0 - 19% = 195 
    20 - 39% = 95 
    40 - 59% = 132 
    60 - 79% = 265 
    80 - 99% = 945 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1696011, depth: 3, leaf buckets: 368, nodes: 89546 
    Average node length: 13.39, total dup: 6148, max dup: 1 
    Average key length: 10.74, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 64300, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 216 
        40 - 59% = 132 
        60 - 79% = 15 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 128, max versions: 5 
    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: 1 
    Data pages: 1, average fill: 60% 
    Primary pages: 1, 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% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 13.30, total records: 1560 
    Average version length: 43.56, total versions: 1369, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.36 
    Pointer pages: 1, data page slots: 120 
    Data pages: 40, average fill: 41% 
    Primary pages: 39, secondary pages: 1, swept pages: 7 
    Empty pages: 14, full pages: 12 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92509, depth: 2, leaf buckets: 3, nodes: 1560 
    Average node length: 4.30, total dup: 1462, max dup: 147 
    Average key length: 2.68, compression ratio: 7.09 
    Average prefix length: 18.38, average data length: 0.62 
    Clustering factor: 847, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.59, total records: 70 
    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: 49% 
    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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    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: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.41, total records: 832408 
    Average version length: 37.93, total versions: 27938, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8760 
    Data pages: 8760, average fill: 65% 
    Primary pages: 8758, secondary pages: 2, swept pages: 2404 
    Empty pages: 23, full pages: 5950 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 45 
    40 - 59% = 646 
    60 - 79% = 7969 
    80 - 99% = 65 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 878, nodes: 818582 
    Average node length: 4.88, total dup: 818533, max dup: 159415 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91301, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 141 
        40 - 59% = 446 
        60 - 79% = 187 
        80 - 99% = 104 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1002, nodes: 818582 
    Average node length: 5.89, total dup: 728755, max dup: 45 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162407, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 49 
        40 - 59% = 625 
        60 - 79% = 69 
        80 - 99% = 257 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1043, nodes: 818582 
    Average node length: 5.89, total dup: 728755, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164353, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 94 
        40 - 59% = 645 
        60 - 79% = 76 
        80 - 99% = 227 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1154, nodes: 818582 
    Average node length: 5.97, total dup: 728755, max dup: 45 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156581, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 244 
        40 - 59% = 601 
        60 - 79% = 205 
        80 - 99% = 99 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.99, total records: 5571 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.25, total fragments: 24, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 59% 
    Primary pages: 82, secondary pages: 12, swept pages: 59 
    Empty pages: 11, full pages: 62 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 75 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5571 
    Average node length: 5.53, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.16 
    Average prefix length: 34.75, average data length: 1.53 
    Clustering factor: 5233, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5571 
    Average node length: 11.17, 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: 165, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 76249 
    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: 792 
    Data pages: 792, average fill: 66% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 791 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 791 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32778, depth: 2, leaf buckets: 97, nodes: 76249 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2919, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 95 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.63, total records: 71 
    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.28 
    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: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 147.78, total records: 141523 
    Average version length: 151.23, total versions: 3136, 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: 5832 
    Data pages: 3584, average fill: 81% 
    Primary pages: 3582, secondary pages: 2, swept pages: 12 
    Empty pages: 94, full pages: 3457 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 14 
    40 - 59% = 5 
    60 - 79% = 15 
    80 - 99% = 3453 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 143.98, total records: 146408 
    Average version length: 153.66, total versions: 7772, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 8, data page slots: 4520 
    Data pages: 3688, average fill: 83% 
    Primary pages: 3684, secondary pages: 4, swept pages: 4 
    Empty pages: 65, full pages: 3594 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 6 
    40 - 59% = 12 
    60 - 79% = 6 
    80 - 99% = 3593 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.03, total records: 154454 
    Average version length: 153.04, total versions: 3471, 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: 7, data page slots: 4888 
    Data pages: 3872, average fill: 82% 
    Primary pages: 3869, secondary pages: 3, swept pages: 7 
    Empty pages: 62, full pages: 3786 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 11 
    80 - 99% = 3782 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 140.51, total records: 176815 
    Average version length: 154.00, total versions: 13497, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.07 
    Pointer pages: 7, data page slots: 5496 
    Data pages: 4392, average fill: 84% 
    Primary pages: 4390, secondary pages: 2, swept pages: 5 
    Empty pages: 31, full pages: 4345 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4344 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 146.16, total records: 145230 
    Average version length: 152.37, total versions: 5083, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 7, data page slots: 4888 
    Data pages: 3624, average fill: 83% 
    Primary pages: 3621, secondary pages: 3, swept pages: 3 
    Empty pages: 45, full pages: 3558 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 5 
    40 - 59% = 9 
    60 - 79% = 6 
    80 - 99% = 3558 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 147.54, total records: 160176 
    Average version length: 151.46, total versions: 4177, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5240 
    Data pages: 3984, average fill: 83% 
    Primary pages: 3982, secondary pages: 2, swept pages: 1 
    Empty pages: 38, full pages: 3928 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 4 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 3928 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 149.28, total records: 149894 
    Average version length: 150.57, total versions: 1674, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 5200 
    Data pages: 3736, average fill: 83% 
    Primary pages: 3734, secondary pages: 2, swept pages: 3 
    Empty pages: 54, full pages: 3669 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3669 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.12, total records: 164024 
    Average version length: 147.70, total versions: 1495, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 8, data page slots: 4248 
    Data pages: 4064, average fill: 83% 
    Primary pages: 4061, secondary pages: 3, swept pages: 3 
    Empty pages: 22, full pages: 4027 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4028 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.00, total records: 170110 
    Average version length: 153.04, total versions: 5238, 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: 6, data page slots: 4928 
    Data pages: 4272, average fill: 83% 
    Primary pages: 4270, secondary pages: 2, swept pages: 5 
    Empty pages: 73, full pages: 4175 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4175 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 143.35, total records: 158544 
    Average version length: 154.09, total versions: 8664, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 6, data page slots: 4456 
    Data pages: 3960, average fill: 83% 
    Primary pages: 3958, secondary pages: 2, swept pages: 1 
    Empty pages: 53, full pages: 3889 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3889 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.15, total records: 2066327 
    Average version length: 52.92, total versions: 28187, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25584 
    Data pages: 25584, average fill: 70% 
    Primary pages: 25566, secondary pages: 18, swept pages: 11600 
    Empty pages: 192, full pages: 21664 
    Fill distribution: 
     0 - 19% = 394 
    20 - 39% = 375 
    40 - 59% = 978 
    60 - 79% = 23577 
    80 - 99% = 260 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2553, nodes: 2066327 
    Average node length: 5.45, total dup: 1926990, max dup: 1578 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180360, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 333 
        40 - 59% = 1637 
        60 - 79% = 284 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2066327 
    Average node length: 5.70, total dup: 1854135, max dup: 63 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370456, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 2517 
        60 - 79% = 209 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2092, nodes: 2066327 
    Average node length: 4.96, total dup: 2066227, max dup: 26805 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178103, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 197 
        40 - 59% = 1103 
        60 - 79% = 368 
        80 - 99% = 421 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 41.21, total records: 152441 
    Average version length: 69.17, total versions: 70919, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.06 
    Pointer pages: 3, data page slots: 4320 
    Data pages: 3536, average fill: 53% 
    Primary pages: 3536, secondary pages: 0, swept pages: 468 
    Empty pages: 642, full pages: 1477 
    Fill distribution: 
     0 - 19% = 852 
    20 - 39% = 232 
    40 - 59% = 542 
    60 - 79% = 984 
    80 - 99% = 926 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553432, depth: 3, leaf buckets: 250, nodes: 152441 
    Average node length: 6.47, total dup: 132781, max dup: 29 
    Average key length: 3.92, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 26335, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 63 
        40 - 59% = 133 
        60 - 79% = 50 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.31, total records: 7164731 
    Average version length: 68.73, total versions: 313970, 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: 66, data page slots: 107328 
    Data pages: 107328, average fill: 72% 
    Primary pages: 107327, secondary pages: 1, swept pages: 30484 
    Empty pages: 33, full pages: 69776 
    Fill distribution: 
     0 - 19% = 285 
    20 - 39% = 806 
    40 - 59% = 4622 
    60 - 79% = 100915 
    80 - 99% = 700 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10819, nodes: 7164731 
    Average node length: 6.51, total dup: 6196321, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1701532, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1623 
        40 - 59% = 5959 
        60 - 79% = 2713 
        80 - 99% = 514 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8696, nodes: 7164731 
    Average node length: 5.39, total dup: 6882393, max dup: 157 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1495318, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1194 
        40 - 59% = 5005 
        60 - 79% = 1516 
        80 - 99% = 972 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8774, nodes: 7164731 
    Average node length: 5.39, total dup: 6882393, max dup: 157 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1497731, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1257 
        40 - 59% = 5038 
        60 - 79% = 1516 
        80 - 99% = 962 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.64, total records: 12123268 
    Average version length: 68.68, total versions: 260704, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 108, data page slots: 175992 
    Data pages: 175992, average fill: 73% 
    Primary pages: 175991, secondary pages: 1, swept pages: 80989 
    Empty pages: 1, full pages: 143352 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 305 
    40 - 59% = 4385 
    60 - 79% = 169699 
    80 - 99% = 1591 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18461, nodes: 12120844 
    Average node length: 6.62, total dup: 10567318, max dup: 58 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2469331, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 2224 
        40 - 59% = 10776 
        60 - 79% = 4634 
        80 - 99% = 811 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 50.63, total records: 1430973 
    Average version length: 69.05, total versions: 261986, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.49 
    Pointer pages: 27, data page slots: 42600 
    Data pages: 27760, average fill: 53% 
    Primary pages: 27682, secondary pages: 78, swept pages: 8788 
    Empty pages: 3637, full pages: 16320 
    Fill distribution: 
     0 - 19% = 5297 
    20 - 39% = 3707 
    40 - 59% = 2782 
    60 - 79% = 12866 
    80 - 99% = 3108 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1790, nodes: 1252259 
    Average node length: 5.53, total dup: 1201310, max dup: 49 
    Average key length: 2.58, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 84385, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 505 
        40 - 59% = 894 
        60 - 79% = 344 
        80 - 99% = 34 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 40.75, total records: 1264942 
    Average version length: 69.03, total versions: 154819, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.09 
    Pointer pages: 23, data page slots: 36816 
    Data pages: 28784, average fill: 38% 
    Primary pages: 28784, secondary pages: 0, swept pages: 7104 
    Empty pages: 5326, full pages: 7026 
    Fill distribution: 
     0 - 19% = 8182 
    20 - 39% = 5375 
    40 - 59% = 7887 
    60 - 79% = 7112 
    80 - 99% = 228 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1214, nodes: 824155 
    Average node length: 5.96, total dup: 757815, max dup: 81 
    Average key length: 3.03, compression ratio: 13.87 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 119618, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 322 
        40 - 59% = 566 
        60 - 79% = 289 
        80 - 99% = 37 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.36, total records: 8949279 
    Average version length: 68.97, total versions: 374322, 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: 89, data page slots: 143848 
    Data pages: 143768, average fill: 67% 
    Primary pages: 143745, secondary pages: 23, swept pages: 60013 
    Empty pages: 363, full pages: 65315 
    Fill distribution: 
     0 - 19% = 1391 
    20 - 39% = 6456 
    40 - 59% = 21364 
    60 - 79% = 112844 
    80 - 99% = 1713 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13424, nodes: 8945067 
    Average node length: 6.68, total dup: 7418178, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2017673, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1451 
        40 - 59% = 7180 
        60 - 79% = 4307 
        80 - 99% = 485 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21089409 
    Average version length: 82.96, total versions: 8834, 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: 318832 
    Data pages: 318832, average fill: 81% 
    Primary pages: 318829, secondary pages: 3, swept pages: 13012 
    Empty pages: 24, full pages: 318136 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 26 
    40 - 59% = 93 
    60 - 79% = 48240 
    80 - 99% = 270435 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19524, nodes: 21089409 
    Average node length: 5.72, total dup: 20609696, max dup: 137 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3274089, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8516 
        60 - 79% = 555 
        80 - 99% = 10448 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17108, nodes: 21089409 
    Average node length: 6.31, total dup: 18534469, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913452, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 761 
        60 - 79% = 268 
        80 - 99% = 16074 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21266, nodes: 21089409 
    Average node length: 6.34, total dup: 18452481, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3566856, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8715 
        60 - 79% = 604 
        80 - 99% = 11940 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16052, nodes: 21089409 
    Average node length: 5.56, total dup: 21089309, max dup: 229637 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942089, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 2858 
        60 - 79% = 386 
        80 - 99% = 12795 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.05, total records: 9321652 
    Average version length: 82.59, total versions: 299577, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 105, data page slots: 170464 
    Data pages: 170440, average fill: 68% 
    Primary pages: 170403, secondary pages: 37, swept pages: 87465 
    Empty pages: 641, full pages: 91640 
    Fill distribution: 
     0 - 19% = 2205 
    20 - 39% = 10428 
    40 - 59% = 27528 
    60 - 79% = 112190 
    80 - 99% = 18089 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11321, nodes: 9321652 
    Average node length: 5.36, total dup: 9017645, max dup: 174 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2108348, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 103 
        40 - 59% = 9136 
        60 - 79% = 2029 
        80 - 99% = 50 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13192, nodes: 9321652 
    Average node length: 6.23, total dup: 7726956, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1477991, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 4019 
        40 - 59% = 4256 
        60 - 79% = 2607 
        80 - 99% = 2193 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12630, nodes: 9321652 
    Average node length: 5.98, total dup: 8081342, max dup: 42 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2288137, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 109 
        40 - 59% = 10191 
        60 - 79% = 2271 
        80 - 99% = 57 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9828, nodes: 9321652 
    Average node length: 5.13, total dup: 9321552, max dup: 156874 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1506463, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1286 
        40 - 59% = 4825 
        60 - 79% = 1681 
        80 - 99% = 1989 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.63, total records: 11046496 
    Average version length: 82.48, total versions: 250638, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 190976 
    Data pages: 189424, average fill: 72% 
    Primary pages: 189251, secondary pages: 173, swept pages: 70681 
    Empty pages: 3233, full pages: 142775 
    Fill distribution: 
     0 - 19% = 5319 
    20 - 39% = 7332 
    40 - 59% = 16874 
    60 - 79% = 100359 
    80 - 99% = 59540 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13107, nodes: 11046496 
    Average node length: 5.29, total dup: 10937618, max dup: 701 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2305610, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 199 
        40 - 59% = 9800 
        60 - 79% = 3011 
        80 - 99% = 94 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10249, nodes: 11046496 
    Average node length: 5.48, total dup: 10563039, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 699606, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 897 
        40 - 59% = 2458 
        60 - 79% = 1899 
        80 - 99% = 4835 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14985, nodes: 11046496 
    Average node length: 6.02, total dup: 9636026, max dup: 74 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2321940, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 258 
        40 - 59% = 11381 
        60 - 79% = 3225 
        80 - 99% = 120 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10479, nodes: 11046496 
    Average node length: 5.21, total dup: 11046396, max dup: 184092 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 687650, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 808 
        40 - 59% = 4547 
        60 - 79% = 1498 
        80 - 99% = 3508 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.55, total records: 9415057 
    Average version length: 82.91, total versions: 278808, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 108, data page slots: 175560 
    Data pages: 175464, average fill: 67% 
    Primary pages: 175427, secondary pages: 37, swept pages: 94131 
    Empty pages: 1109, full pages: 89790 
    Fill distribution: 
     0 - 19% = 3218 
    20 - 39% = 12056 
    40 - 59% = 30331 
    60 - 79% = 113046 
    80 - 99% = 16813 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11545, nodes: 9415057 
    Average node length: 5.18, total dup: 9386755, max dup: 1861 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1897536, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1561 
        40 - 59% = 7792 
        60 - 79% = 1652 
        80 - 99% = 513 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13345, nodes: 9415057 
    Average node length: 6.25, total dup: 7804336, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1430010, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 3980 
        40 - 59% = 4305 
        60 - 79% = 2605 
        80 - 99% = 2289 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12114, nodes: 9415057 
    Average node length: 5.43, total dup: 8990451, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2026374, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1477 
        40 - 59% = 8528 
        60 - 79% = 1562 
        80 - 99% = 515 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9939, nodes: 9415057 
    Average node length: 5.15, total dup: 9414957, max dup: 157266 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1509247, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1389 
        40 - 59% = 4816 
        60 - 79% = 1611 
        80 - 99% = 2078 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.68, total records: 570158 
    Average version length: 68.74, total versions: 4654, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8024 
    Data pages: 8024, average fill: 74% 
    Primary pages: 8024, secondary pages: 0, swept pages: 3741 
    Empty pages: 6, full pages: 6746 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 9 
    40 - 59% = 154 
    60 - 79% = 7800 
    80 - 99% = 54 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38204, depth: 3, leaf buckets: 736, nodes: 570158 
    Average node length: 5.95, total dup: 485381, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100339, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 533 
        60 - 79% = 82 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30506, depth: 3, leaf buckets: 757, nodes: 570158 
    Average node length: 6.15, total dup: 467497, max dup: 27 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 100392, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 34 
        40 - 59% = 536 
        60 - 79% = 86 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 549, nodes: 570158 
    Average node length: 4.86, total dup: 570058, max dup: 9669 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89215, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 307 
        60 - 79% = 60 
        80 - 99% = 148 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Thu Feb 15 10:10:15 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7688110 72139 1 0.0000 0.0000
DOC_LIST 2215526 36499 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 795 3 100.0000 0.0000
INVNT_TURNOVER_LOG 89546 72329 1 0.0000 0.0000
MONEY_SALDO 49 128 5 200.0000 0.0000
MONEY_TURNOVER_LOG 1560 1369 1 0.0000 0.0000
PDISTR 832408 27938 2 0.0000 0.0000
PERF_SPLIT_0 141523 3136 1 0.0000 0.0000
PERF_SPLIT_1 146408 7772 1 0.0000 0.0000
PERF_SPLIT_2 154454 3471 1 0.0000 0.0000
PERF_SPLIT_3 176815 13497 1 0.0000 0.0000
PERF_SPLIT_4 145230 5083 1 0.0000 0.0000
PERF_SPLIT_5 160176 4177 1 0.0000 0.0000
PERF_SPLIT_6 149894 1674 1 0.0000 0.0000
PERF_SPLIT_7 164024 1495 1 0.0000 0.0000
PERF_SPLIT_8 170110 5238 1 0.0000 0.0000
PERF_SPLIT_9 158544 8664 1 0.0000 0.0000
PSTORNED 2066327 28187 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 152441 70919 1 0.0000 0.0000
XQD_1000_3300 7164731 313970 1 0.0000 0.0000
XQD_1200_2000 12123268 260704 1 0.0000 0.0000
XQD_2000_3300 1430973 261986 1 0.0000 0.0000
XQD_2100_3300 1264942 154819 1 0.0000 0.0000
XQD_3300_3400 8949279 374322 1 0.0000 0.0000
XQS_1000_1200 21089409 8834 1 0.0000 0.0000
XQS_1000_3300 9321652 299577 1 0.0000 0.0000
XQS_1200_2000 11046496 250638 1 0.0000 0.0000
XQS_2100_3300 9415057 278808 1 0.0000 0.0000
XQS_3300_3400 570158 4654 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

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