Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.03.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 15512572 kB
MemAvailable 30188552 kB
Buffers 0 kB
Cached 16176636 kB
SwapCached 2448 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-03-29 10:07:54
DTS_END                         2024-03-29 10:07:54.0680
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/50870
TRN_ID                          180381
ATT_ID                          502
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: 9306.13 22236 930613
customer order: creation 185.41 433 18541
customer order: refuse 15.90 374 1590
order to supplier: creation 48.97 1288 4897
order to supplier: removal 3.59 84207 359
invoice (draft): creation 49.14 3032 4914
invoice (draft): removal 51.38 607 5138
invoice accept: apply 43.93 20971 4393
invoice accept: cancel 46.36 790 4636
customer reserve: creation 4064.55 210 406455
customer reserve: removal 4488.24 55 448824
realization accept: apply 90.98 197 9098
realization accept: cancel 81.81 126 8181
payment from customer: creation 62.61 120 6261
payment from customer: removal 5.95 87 595
payment to supplier: creation 51.95 131 5195
payment to supplier: removal 3.63 75 363
service: total inventory turnovers 4.35 3647 435
service: total monetary turnovers 6.47 574 647
service: aggregate perf. data 0.87 16315 87
service: refresh index statistics 0.04 311481 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 29-03-2024 10:08:44 to 29-03-2024 10:08:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3159
TEST_TIME 2 3695
TEST_TIME 3 3290
TEST_TIME 4 3883
TEST_TIME 5 3934
TEST_TIME 6 4132
TEST_TIME 7 4451
TEST_TIME 8 4925
TEST_TIME 9 5318
TEST_TIME 10 6043
TEST_TIME 11 6265
TEST_TIME 12 6387
TEST_TIME 13 7001
TEST_TIME 14 7268
TEST_TIME 15 7662
TEST_TIME 16 7947
TEST_TIME 17 8290
TEST_TIME 18 8473
TEST_TIME 19 8456
TEST_TIME 20 8579
TEST_TIME 21 8782
TEST_TIME 22 8622
TEST_TIME 23 8668
TEST_TIME 24 8906
TEST_TIME 25 8663
TEST_TIME 26 8774
TEST_TIME 27 9527
TEST_TIME 28 9488
TEST_TIME 29 9393
TEST_TIME 30 9175
TEST_TIME 31 9282
TEST_TIME 32 9285
TEST_TIME 33 9297
TEST_TIME 34 9512
TEST_TIME 35 9620
TEST_TIME 36 9708
TEST_TIME 37 9575
TEST_TIME 38 9464
TEST_TIME 39 9390
TEST_TIME 40 9337
TEST_TIME 41 9189
TEST_TIME 42 9148
TEST_TIME 43 9146
TEST_TIME 44 9147
TEST_TIME 45 9159
TEST_TIME 46 9204
TEST_TIME 47 9136
TEST_TIME 48 9018
TEST_TIME 49 8924
TEST_TIME 50 9042
TEST_TIME 51 9007
TEST_TIME 52 8980
TEST_TIME 53 9027
TEST_TIME 54 9074
TEST_TIME 55 9162
TEST_TIME 56 9207
TEST_TIME 57 9334
TEST_TIME 58 9331
TEST_TIME 59 9433
TEST_TIME 60 9479
TEST_TIME 61 9471
TEST_TIME 62 9488
TEST_TIME 63 9521
TEST_TIME 64 9542
TEST_TIME 65 9405
TEST_TIME 66 9415
TEST_TIME 67 9342
TEST_TIME 68 9367
TEST_TIME 69 9316
TEST_TIME 70 9242
TEST_TIME 71 9250
TEST_TIME 72 9156
TEST_TIME 73 9102
TEST_TIME 74 9240
TEST_TIME 75 9253
TEST_TIME 76 9240
TEST_TIME 77 9198
TEST_TIME 78 9204
TEST_TIME 79 9354
TEST_TIME 80 9343
TEST_TIME 81 9438
TEST_TIME 82 9405
TEST_TIME 83 9425
TEST_TIME 84 9452
TEST_TIME 85 9360
TEST_TIME 86 9287
TEST_TIME 87 9336
TEST_TIME 88 9300
TEST_TIME 89 9219
TEST_TIME 90 9190
TEST_TIME 91 9170
TEST_TIME 92 9231
TEST_TIME 93 9202
TEST_TIME 94 9244
TEST_TIME 95 9217
TEST_TIME 96 9222
TEST_TIME 97 9206
TEST_TIME 98 9316
TEST_TIME 99 9291
TEST_TIME 100 9310

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-03-2024 10:08:48 to 29-03-2024 10:08:51.

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 1304788 1304788 0 0.00 0 26222 8 0 0
doc_list_biud 1304787 1304787 0 0.00 0 35177 24 0 0
sp_add_invoice_to_stock 4543 4393 150 3.30 18 241478 20972 0 150
sp_cancel_adding_invoice 4636 4636 0 0.00 3 66299 790 0 0
sp_cancel_client_order 1590 1590 0 0.00 3 10124 375 0 0
sp_cancel_customer_reserve 448824 448824 0 0.00 0 28551 55 0 0
sp_cancel_pay_from_customer 595 595 0 0.00 2 7242 88 0 0
sp_cancel_pay_to_supplier 363 363 0 0.00 3 3411 76 0 0
sp_cancel_supplier_invoice 5153 5138 15 0.29 1 35187 608 0 15
sp_cancel_supplier_order 359 359 0 0.00 16 757167 84207 0 0
sp_cancel_write_off 8181 8181 0 0.00 1 5423 126 0 0
sp_client_order 18541 18541 0 0.00 3 27372 433 0 0
sp_customer_reserve 406455 406455 0 0.00 0 92287 211 0 0
sp_fill_shopping_cart 28333 28333 0 0.00 1 21612 34 0 0
sp_fill_shopping_cart_clo_res 406446 406446 0 0.00 0 13130 15 0 0
sp_get_clo_for_invoice 4384 4384 0 0.00 0 27777 298 0 0
sp_kill_cost_storno 13775 13775 0 0.00 0 8632 63 0 0
sp_kill_qstorno_ret_qs2qd 911326 911326 0 0.00 0 35175 29 0 0
sp_kill_qty_storno 482209 482209 0 0.00 0 35177 63 0 0
sp_lock_selected_doc 18643 18643 0 0.00 0 13988 5 0 0
sp_make_cost_storno 24938 24938 0 0.00 0 12224 65 0 0
sp_multiply_rows_for_pdistr 24938 24938 0 0.00 0 11444 32 0 0
sp_multiply_rows_for_qdistr 18541 18541 0 0.00 0 12803 201 0 0
sp_pay_from_customer 6261 6261 0 0.00 4 10866 120 0 0
sp_pay_to_supplier 5195 5195 0 0.00 5 12374 131 0 0
sp_payment_common 11456 11456 0 0.00 1 4881 22 0 0
sp_qd_handle_on_cancel_clo 1590 1590 0 0.00 0 10116 352 0 0
sp_qd_handle_on_invoice_upd_sts 9020 9020 0 0.00 0 26453 273 0 0
sp_qd_handle_on_reserve_upd_sts 9097 9097 0 0.00 0 25648 60 0 0
sp_reserve_write_off 9098 9098 0 0.00 6 25688 198 0 0
sp_supplier_invoice 4914 4914 0 0.00 5 100332 3032 0 0
sp_supplier_order 4897 4897 0 0.00 5 38789 1289 0 0
srv_aggregate_perf_data 87 87 0 0.00 2036 144840 16315 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 895 129564 41593 0 0
srv_find_qd_qs_mism 887300 887300 0 0.00 0 26222 7 0 0
srv_make_invnt_saldo 435 435 0 0.00 51 100622 3647 0 0
srv_make_money_saldo 647 647 0 0.00 1 16170 575 0 0
srv_recalc_idx_stat 4 4 0 0.00 180902 475295 311482 0 0
t$perf-abend:sp_add_invoice_to_stock 150 150 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4393 4393 0 0.00 0 9033 165 0 0
t$perf-norm:sp_cancel_adding_invoice 380 380 0 0.00 1 4059 90 0 0
t$perf-norm:sp_cancel_client_order 1590 1590 0 0.00 0 2490 11 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 346 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 595 595 0 0.00 0 1529 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 363 363 0 0.00 0 1510 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 359 359 0 0.00 0 1596 15 0 0
t$perf-norm:sp_cancel_supplier_order 359 359 0 0.00 0 21237 1320 0 0
t$perf-norm:sp_cancel_write_off 896 896 0 0.00 0 8043 23 0 0
t$perf-norm:sp_client_order 18542 18542 0 0.00 0 8696 15 0 0
t$perf-norm:sp_customer_reserve 934 934 0 0.00 0 2391 10 0 0
t$perf-norm:sp_pay_from_customer 6261 6261 0 0.00 0 8093 12 0 0
t$perf-norm:sp_pay_to_supplier 5195 5195 0 0.00 0 5622 11 0 0
t$perf-norm:sp_reserve_write_off 9098 9098 0 0.00 0 8066 11 0 0
t$perf-norm:sp_supplier_invoice 4914 4914 0 0.00 0 3766 18 0 0
t$perf-norm:sp_supplier_order 4897 4897 0 0.00 0 6909 16 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 458 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 362 15 0 0
t$perf-norm:srv_make_invnt_saldo 435 435 0 0.00 0 2207 13 0 0
t$perf-norm:srv_make_money_saldo 647 647 0 0.00 0 1663 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 1 0 0
v_add_invoice_to_stock 9068 8768 300 3.30 0 8462 19 0 300
v_all_customers 34054 34054 0 0.00 0 17 1 0 0
v_all_suppliers 27536 27536 0 0.00 0 55 1 0 0
v_all_wares 37082 37082 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 760 760 0 0.00 0 2026 11 0 0
v_cancel_client_order 3180 3180 0 0.00 0 3190 5 0 0
v_cancel_customer_prepayment 1190 1190 0 0.00 0 3308 7 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 186 3 0 0
v_cancel_payment_to_supplier 726 726 0 0.00 0 3200 8 0 0
v_cancel_supplier_invoice 748 718 30 4.01 0 1790 15 0 30
v_cancel_supplier_order 718 718 0 0.00 0 3483 9 0 0
v_cancel_write_off 1792 1792 0 0.00 0 3316 17 0 0
v_max_id_clo_ord 4891 4891 0 0.00 0 3291 2 0 0
v_max_id_clo_res 934 934 0 0.00 0 2093 12 0 0
v_max_id_ord_sup 4900 4900 0 0.00 0 5464 7 0 0
v_max_non_paid_invoice 1218 1218 0 0.00 0 400 2 0 0
v_max_non_paid_realizn 3128 3128 0 0.00 0 2322 4 0 0
v_min_id_clo_ord 4891 4891 0 0.00 0 3258 8 0 0
v_min_id_clo_res 934 934 0 0.00 0 6441 28 0 0
v_min_id_ord_sup 4900 4900 0 0.00 0 6281 10 0 0
v_min_non_paid_invoice 5195 5195 0 0.00 0 4111 12 0 0
v_min_non_paid_realizn 6261 6261 0 0.00 0 4879 18 0 0
v_our_firm 9294 9294 0 0.00 0 17 1 0 0
v_reserve_write_off 18190 18190 0 0.00 0 4258 7 0 0
x_lock_depdocs_on_canc_invoice 9415 9415 0 0.00 0 24596 128 0 0
x_lock_depdocs_on_canc_sup_ord 359 359 0 0.00 0 5269 287 0 0
x_make_qstorno_1000_1200 4897 4897 0 0.00 1 38779 1215 0 0
x_make_qstorno_1200_2000 4914 4914 0 0.00 3 99792 2910 0 0
x_make_qstorno_2100_3300 406455 406455 0 0.00 0 92285 193 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 29-03-2024 10:08:52 to 29-03-2024 10:08:57.

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:58 1162 8192000000 8947358624 9009864704 11174608 0.136 3 1 2 0 11324416 114032 35776
08:09:00 22515 8192000000 9705649360 10003226624 783990848 8.734 100 85 170 0 812572752 7606160 20975744
08:10:31 21538 8192000000 9749737520 10057912320 827019792 9.169 100 88 174 0 860346640 13193312 20133536
08:11:58 18562 8192000000 9783840208 10099175424 852814176 9.428 100 87 174 0 891156960 18778368 19564416
08:13:43 9910 8192000000 9860767616 10190118912 901787712 9.916 100 83 166 0 962277232 42813808 17675712
08:14:58 6624 8192000000 9898972256 10244616192 943277792 10.325 100 76 150 1 1010737744 51922784 15537168
08:16:07 4518 8192000000 9957100416 10311331840 983961552 10.723 100 81 160 0 1062197216 62788144 15447520
08:17:15 1913 8192000000 9993579376 10361413632 1015565840 11.029 100 81 156 0 1112058128 81604816 14887472
08:18:19 1600 8192000000 10028192480 10396860416 1038009312 11.246 100 87 171 0 1143442512 89047360 16385840
08:19:22 971 8192000000 10041721376 10416029696 1057177712 11.429 100 97 190 2 1151985616 75784432 19023472
08:20:24 20015 8192000000 10007068208 10404814848 1066963936 11.523 100 52 105 1 1136758816 59222448 10572432
08:21:48 3446 8192000000 9992246880 10389659648 1077522944 11.624 100 41 82 0 1112069088 26178288 8367856
08:22:53 5391 8192000000 9999709696 10401726464 1080833968 11.655 100 43 84 1 1125841728 36244064 8763696
08:23:59 7858 8192000000 10005687056 10411700224 1083190960 11.678 100 29 58 0 1115266576 25780624 6294992
08:25:10 40910 8192000000 10009997376 10414460928 1088431136 11.728 100 41 82 0 1119621824 22549392 8641296
08:26:52 3722 8192000000 10022145184 10419335168 1088552144 11.729 100 56 107 2 1130168048 30735184 10880720
08:27:59 7629 8192000000 10002916912 10399801344 1080996672 11.657 100 49 97 1 1109311616 18693248 9621696
08:29:15 9408 8192000000 10039890304 10438066176 1090259936 11.745 100 46 92 1 1151158720 51454272 9444512
08:30:28 39994 8192000000 10076584688 10476748800 1092066880 11.762 99 61 120 0 1173882256 68823472 12991904
08:32:19 48799 8192000000 10093763728 10499006464 1081196592 11.659 97 42 84 0 1163764016 74236384 8331040
08:34:11 9873 8192000000 10098795536 10499379200 1083141312 11.677 99 51 102 1 1192751968 99444096 10166560
08:35:36 5168 8192000000 10114933968 10509762560 1084888992 11.694 100 57 114 0 1225770288 129389616 11491680
08:36:51 11040 8192000000 10131306752 10526949376 1068563760 11.538 97 58 114 1 1217653184 137691968 11397456
08:38:07 9446 8192000000 10099009344 10497105920 1060738128 11.464 98 53 106 0 1189129968 117057296 11334544
08:39:21 1706 8192000000 10126527632 10506874880 1057608272 11.434 99 84 166 2 1224646976 150539664 16499040
08:40:31 3525 8192000000 10173115488 10560581632 1091053904 11.753 100 73 145 0 1265593824 159794496 14745424
08:41:39 9145 8192000000 10143652080 10546331648 1098806416 11.826 100 71 142 1 1247490960 133569184 15115360
08:42:59 9452 8192000000 10133908304 10534084608 1105920336 11.894 100 41 78 0 1233764512 119459360 8384816
08:44:15 4949 8192000000 10139056864 10541707264 1084403968 11.689 99 74 143 2 1250267872 150653040 15210864
08:45:23 894 8192000000 10193979648 10583191552 1104529184 11.881 100 88 176 2 1289616288 166076640 19010464
08:46:25 5579 8192000000 10201036720 10622500864 1119973536 12.027 100 50 96 1 1315845168 184462640 11408992
08:47:39 12449 8192000000 10234840656 10636484608 1130080080 12.122 100 70 138 1 1331346816 186120624 15146112
08:49:00 20228 8192000000 10232626288 10651095040 1137757280 12.194 100 36 70 0 1329305488 183840448 7707760
08:50:23 25981 8192000000 10259347744 10670800896 1136439728 12.182 100 46 91 0 1367448128 220953984 10054416
08:51:52 19715 8192000000 10203186032 10639646720 1127843968 12.101 100 21 41 0 1307783808 175048848 4890992
08:54:00 26064 8192000000 10103530496 10668642304 1118827552 12.016 100 11 22 0 1292556064 171328976 2399536
08:55:35 48568 8192000000 10057302464 10475253760 1128606224 12.108 100 29 55 2 1150263632 16223984 5433424
08:57:27 33006 8192000000 10082104784 10498314240 1134031936 12.159 100 56 111 0 1172025136 27085712 10907488
08:59:08 83730 8192000000 10087267248 10531180544 1144914960 12.262 100 19 38 1 1197180000 48257328 4007712
09:01:34 129564 8192000000 10084096944 10569437184 1113580416 11.966 97 10 20 0 1171515360 56030240 1904704
09:04:45 35353 8192000000 10090334384 10526154752 1139121152 12.207 100 28 56 1 1194581936 50191504 5269280
09:06:24 45578 8192000000 10071446960 10512285696 1131696240 12.137 99 37 74 1 1169589440 29725376 8167824
09:08:21 35850 8192000000 10075033680 10510770176 1130947120 12.130 99 27 54 0 1161042208 24519232 5575856
09:09:58 26161 8192000000 10088920048 10522685440 1128873984 12.111 99 45 89 0 1208823488 69305504 10644000
09:12:24 79746 8192000000 10049928592 10517553152 1089723824 11.740 96 16 32 0 1135661440 42858480 3079136
09:14:55 97841 8192000000 10085942176 10547056640 1059619152 11.453 94 21 42 0 1122665632 58387600 4658880
09:17:37 44509 8192000000 10030074784 10500980736 1099218848 11.830 99 8 17 1 1140003952 39341184 1443920
09:19:27 29249 8192000000 10087175664 10529509376 1091701008 11.759 98 30 58 0 1160776944 63569040 5506896
09:20:56 40456 8192000000 10025625968 10447347712 1002952624 10.907 91 18 36 0 1049225584 42499952 3773008
09:22:40 44242 8192000000 10068754832 10514903040 1090057168 11.743 99 33 66 0 1128734032 32527680 6149184
09:24:28 64004 8192000000 10051509824 10513539072 1092679456 11.768 98 14 28 0 1137117376 41983392 2454528
09:26:35 47671 8192000000 10074942192 10558271488 1081632128 11.663 97 25 48 1 1179777248 93585072 4560048
09:28:27 33571 8192000000 10074709504 10503094272 1096870480 11.808 99 40 79 0 1155199424 50936944 7392000
09:30:04 16907 8192000000 10062813088 10520403968 1095225136 11.792 100 50 100 0 1162929152 58010176 9693840
09:31:23 105455 8192000000 10064123104 10496397312 1107626528 11.910 100 25 51 0 1135924336 23118272 5179536
09:34:30 35956 8192000000 10077659136 10524839936 1106807152 11.902 99 35 67 0 1175038272 61153184 7077936
09:36:14 47110 8192000000 10037057344 10486562816 1091529248 11.757 98 18 36 0 1133498528 38217472 3751808
09:38:01 46506 8192000000 10065131360 10541178880 1114077936 11.971 100 23 47 1 1192138752 72787136 5273680
09:39:52 65785 8192000000 10121692256 10579841024 1105179472 11.887 98 16 32 0 1194419360 85889600 3350288
09:42:09 53746 8192000000 10051892672 10507571200 1101938992 11.856 99 11 21 0 1140443040 36509520 1994528
09:44:37 51116 8192000000 10130588384 10576044032 1126897184 12.092 100 33 66 1 1214398032 81010128 6490720
09:46:32 74235 8192000000 10071833504 10541125632 1102377136 11.860 98 17 34 1 1149677632 44365952 2934544
09:48:54 110323 8192000000 10052280224 10502426624 1119632992 12.024 99 16 31 0 1167288016 44835808 2819216
09:51:48 83453 8192000000 10144821120 10608472064 1124994768 12.074 99 49 98 0 1218141296 83944656 9201872
09:54:11 13840 8192000000 10089079392 10536824832 1128722896 12.109 100 31 61 0 1195855312 61872784 5259632
09:55:26 56627 8192000000 10068918640 10523422720 1127841104 12.101 99 14 28 0 1167180624 36928192 2411328
09:57:27 87981 8192000000 10112013824 10582552576 1094866480 11.789 96 14 28 0 1176647632 78732016 3049136
09:59:55 48837 8192000000 10063612720 10495631360 1093074976 11.772 97 18 36 0 1142056928 44953040 4028912
10:01:55 67362 8192000000 10050987696 10501357568 1079248752 11.640 96 16 32 0 1131972048 49555312 3167984
10:04:08 33911 8192000000 10082461888 10511519744 1084512656 11.690 98 55 110 0 1168896304 73410432 10973216
10:05:47 88302 8192000000 10064368480 10535628800 1017539040 11.048 92 16 32 0 1084549216 63773184 3236992

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 29-03-2024 10:08:59 to 29-03-2024 10:09:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 150 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

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

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          178397
MON$OLDEST_ACTIVE               180494
MON$OLDEST_SNAPSHOT             180494
MON$NEXT_TRANSACTION            180494
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                       1928544
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             713
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3082 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3082 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3082 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3082 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 Fri Mar 29 10:09:16 2024 
 
Database header page information: 
    Flags            0 
    Generation        94308 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    178397 
    Oldest active        180494 
    Oldest snapshot        180494 
    Next transaction    180495 
    Sequence number        0 
    Next attachment ID    713 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.06, total records: 7829825 
    Average version length: 48.16, total versions: 168548, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 89032 
    Data pages: 89032, average fill: 71% 
    Primary pages: 89031, secondary pages: 1, swept pages: 26448 
    Empty pages: 1, full pages: 86069 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 79 
    40 - 59% = 685 
    60 - 79% = 88127 
    80 - 99% = 128 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23313, nodes: 7829825 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1708518, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 314 
        20 - 39% = 1622 
        40 - 59% = 4195 
        60 - 79% = 2274 
        80 - 99% = 14908 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13576, nodes: 7829825 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1531829, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1459 
        40 - 59% = 2148 
        60 - 79% = 1023 
        80 - 99% = 8946 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8357, nodes: 7829825 
    Average node length: 6.63, total dup: 5840801, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1524884, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 881 
        40 - 59% = 1425 
        60 - 79% = 870 
        80 - 99% = 5053 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.61, total records: 2280684 
    Average version length: 58.84, total versions: 86812, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28864 
    Data pages: 28864, average fill: 73% 
    Primary pages: 28862, secondary pages: 2, swept pages: 6792 
    Empty pages: 20, full pages: 26320 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 26 
    40 - 59% = 355 
    60 - 79% = 28216 
    80 - 99% = 235 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4572, nodes: 2280684 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687808, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 879 
        40 - 59% = 860 
        60 - 79% = 663 
        80 - 99% = 2170 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2432, nodes: 2282614 
    Average node length: 4.97, total dup: 2281715, max dup: 20735 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1280245, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 169 
        40 - 59% = 1416 
        60 - 79% = 565 
        80 - 99% = 280 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1794, nodes: 2280684 
    Average node length: 4.97, total dup: 2280634, max dup: 130572 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1077539, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 643 
        60 - 79% = 58 
        80 - 99% = 1092 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4394, nodes: 2280684 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687808, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 589 
        40 - 59% = 620 
        60 - 79% = 721 
        80 - 99% = 2341 
 
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.30, total records: 400 
    Average version length: 25.26, total versions: 3299, max versions: 9 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 55% 
    Primary pages: 14, secondary pages: 26, swept pages: 0 
    Empty pages: 7, full pages: 21 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 21 
 
    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.74, total records: 99578 
    Average version length: 68.28, total versions: 79885, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.24 
    Pointer pages: 6, data page slots: 3080 
    Data pages: 2048, average fill: 64% 
    Primary pages: 2047, secondary pages: 1, swept pages: 0 
    Empty pages: 366, full pages: 1267 
    Fill distribution: 
     0 - 19% = 451 
    20 - 39% = 85 
    40 - 59% = 135 
    60 - 79% = 327 
    80 - 99% = 1050 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1710714, depth: 3, leaf buckets: 360, nodes: 99578 
    Average node length: 13.24, total dup: 7917, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 74342, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 125 
        40 - 59% = 195 
        60 - 79% = 37 
        80 - 99% = 3 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 222, max versions: 7 
    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: 4 
    Data pages: 3, average fill: 30% 
    Primary pages: 1, secondary pages: 2, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    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.61, total records: 1413 
    Average version length: 43.33, total versions: 1233, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.26 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 47% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 9 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93258, depth: 2, leaf buckets: 3, nodes: 1413 
    Average node length: 4.53, total dup: 1316, max dup: 180 
    Average key length: 2.75, compression ratio: 6.92 
    Average prefix length: 18.32, average data length: 0.68 
    Clustering factor: 756, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        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.73, 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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    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 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    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: 35.41, total records: 844584 
    Average version length: 37.90, total versions: 45838, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 6, data page slots: 8568 
    Data pages: 8568, average fill: 67% 
    Primary pages: 8566, secondary pages: 2, swept pages: 819 
    Empty pages: 3, full pages: 8432 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 5 
    40 - 59% = 22 
    60 - 79% = 8440 
    80 - 99% = 92 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 868, nodes: 816950 
    Average node length: 4.88, total dup: 816901, max dup: 146857 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92376, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 116 
        40 - 59% = 450 
        60 - 79% = 197 
        80 - 99% = 103 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 934, nodes: 816950 
    Average node length: 5.89, total dup: 727454, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164478, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 498 
        60 - 79% = 99 
        80 - 99% = 306 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 973, nodes: 816950 
    Average node length: 5.89, total dup: 727454, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166358, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 78 
        40 - 59% = 517 
        60 - 79% = 90 
        80 - 99% = 288 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1131, nodes: 816950 
    Average node length: 5.97, total dup: 727454, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158893, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 219 
        40 - 59% = 580 
        60 - 79% = 227 
        80 - 99% = 103 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.94, total records: 5522 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.54, total fragments: 26, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 83, secondary pages: 13, swept pages: 51 
    Empty pages: 16, full pages: 53 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5522 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.11 
    Average prefix length: 34.62, average data length: 1.54 
    Clustering factor: 5235, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5522 
    Average node length: 11.12, 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: 155, 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.06, total records: 82008 
    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: 856 
    Data pages: 856, average fill: 66% 
    Primary pages: 856, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 851 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 851 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36609, depth: 2, leaf buckets: 106, nodes: 82008 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2972, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 102 
 
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.54, 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.30 
    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: 149.42, total records: 172740 
    Average version length: 153.12, total versions: 1836, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 5320 
    Data pages: 4296, average fill: 83% 
    Primary pages: 4294, secondary pages: 2, swept pages: 7 
    Empty pages: 52, full pages: 4228 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4226 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 135.61, total records: 168231 
    Average version length: 155.07, total versions: 18312, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.51 
    Pointer pages: 6, data page slots: 4576 
    Data pages: 4200, average fill: 84% 
    Primary pages: 4197, secondary pages: 3, swept pages: 3 
    Empty pages: 49, full pages: 4130 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 11 
    40 - 59% = 7 
    60 - 79% = 3 
    80 - 99% = 4129 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.57, total records: 160535 
    Average version length: 148.95, total versions: 796, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 6, data page slots: 4568 
    Data pages: 4000, average fill: 83% 
    Primary pages: 3999, secondary pages: 1, swept pages: 3 
    Empty pages: 45, full pages: 3936 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3938 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 122.32, total records: 186704 
    Average version length: 155.02, total versions: 37584, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.87 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 4656, average fill: 85% 
    Primary pages: 4654, secondary pages: 2, swept pages: 3 
    Empty pages: 51, full pages: 4589 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4587 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.49, total records: 165245 
    Average version length: 152.40, total versions: 1993, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 4968 
    Data pages: 4144, average fill: 82% 
    Primary pages: 4142, secondary pages: 2, swept pages: 4 
    Empty pages: 74, full pages: 4050 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4050 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 151.47, total records: 182024 
    Average version length: 135.82, total versions: 211, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.20 
    Pointer pages: 8, data page slots: 5144 
    Data pages: 4520, average fill: 83% 
    Primary pages: 4519, secondary pages: 1, swept pages: 2 
    Empty pages: 28, full pages: 4477 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4477 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.05, total records: 158538 
    Average version length: 154.27, total versions: 1913, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4832 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3933, secondary pages: 3, swept pages: 7 
    Empty pages: 46, full pages: 3880 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3880 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 148.92, total records: 164045 
    Average version length: 151.89, total versions: 2630, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 5832 
    Data pages: 4112, average fill: 82% 
    Primary pages: 4110, secondary pages: 2, swept pages: 3 
    Empty pages: 68, full pages: 4021 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4021 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 151.05, total records: 169261 
    Average version length: 136.17, total versions: 264, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 6, data page slots: 4648 
    Data pages: 4200, average fill: 83% 
    Primary pages: 4198, secondary pages: 2, swept pages: 1 
    Empty pages: 34, full pages: 4154 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4155 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 150.46, total records: 150721 
    Average version length: 145.02, total versions: 345, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 6, data page slots: 4688 
    Data pages: 3712, average fill: 83% 
    Primary pages: 3710, secondary pages: 2, swept pages: 1 
    Empty pages: 16, full pages: 3691 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3691 
 
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: 51.40, total records: 2129399 
    Average version length: 52.91, total versions: 65573, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25744 
    Data pages: 25744, average fill: 72% 
    Primary pages: 25733, secondary pages: 11, swept pages: 8710 
    Empty pages: 99, full pages: 24392 
    Fill distribution: 
     0 - 19% = 187 
    20 - 39% = 156 
    40 - 59% = 382 
    60 - 79% = 24346 
    80 - 99% = 673 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2610, nodes: 2129399 
    Average node length: 5.44, total dup: 1987889, max dup: 1648 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185046, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 270 
        40 - 59% = 1756 
        60 - 79% = 285 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2129399 
    Average node length: 5.69, total dup: 1911829, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 381324, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2351 
        60 - 79% = 367 
        80 - 99% = 30 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2150, nodes: 2129399 
    Average node length: 4.96, total dup: 2129299, max dup: 28816 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182659, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 170 
        40 - 59% = 1170 
        60 - 79% = 395 
        80 - 99% = 414 
 
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: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 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: 40.65, total records: 167833 
    Average version length: 69.18, total versions: 79624, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 3, data page slots: 4272 
    Data pages: 3208, average fill: 64% 
    Primary pages: 3208, secondary pages: 0, swept pages: 354 
    Empty pages: 497, full pages: 2341 
    Fill distribution: 
     0 - 19% = 642 
    20 - 39% = 70 
    40 - 59% = 77 
    60 - 79% = 990 
    80 - 99% = 1429 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554046, depth: 3, leaf buckets: 235, nodes: 167833 
    Average node length: 6.46, total dup: 146341, max dup: 14 
    Average key length: 3.90, compression ratio: 10.77 
    Average prefix length: 40.23, average data length: 1.77 
    Clustering factor: 28516, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 122 
        60 - 79% = 67 
        80 - 99% = 27 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.76, total records: 7475453 
    Average version length: 68.80, total versions: 648621, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 66, data page slots: 107128 
    Data pages: 107088, average fill: 76% 
    Primary pages: 107087, secondary pages: 1, swept pages: 7069 
    Empty pages: 31, full pages: 106693 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 27 
    40 - 59% = 33 
    60 - 79% = 102020 
    80 - 99% = 4970 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10769, nodes: 7475453 
    Average node length: 6.50, total dup: 6470525, max dup: 41 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1741746, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1057 
        40 - 59% = 5787 
        60 - 79% = 3218 
        80 - 99% = 698 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8662, nodes: 7475453 
    Average node length: 5.38, total dup: 7188255, max dup: 179 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1528218, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 882 
        40 - 59% = 4719 
        60 - 79% = 1850 
        80 - 99% = 1204 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8722, nodes: 7475453 
    Average node length: 5.38, total dup: 7188255, max dup: 179 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1530558, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 936 
        40 - 59% = 4722 
        60 - 79% = 1861 
        80 - 99% = 1195 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.51, total records: 12303368 
    Average version length: 68.72, total versions: 498119, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 108, data page slots: 175064 
    Data pages: 175064, average fill: 75% 
    Primary pages: 175064, secondary pages: 0, swept pages: 43904 
    Empty pages: 3, full pages: 174875 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 13 
    60 - 79% = 170216 
    80 - 99% = 4831 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18363, nodes: 12298020 
    Average node length: 6.62, total dup: 10719904, max dup: 70 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2499873, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1831 
        40 - 59% = 10493 
        60 - 79% = 5077 
        80 - 99% = 933 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 37.91, total records: 2141474 
    Average version length: 69.06, total versions: 592526, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.32 
    Pointer pages: 28, data page slots: 44352 
    Data pages: 30216, average fill: 69% 
    Primary pages: 30138, secondary pages: 78, swept pages: 674 
    Empty pages: 12, full pages: 30121 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 5229 
    40 - 59% = 2241 
    60 - 79% = 13704 
    80 - 99% = 8954 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1957, nodes: 1621994 
    Average node length: 5.52, total dup: 1555864, max dup: 49 
    Average key length: 2.56, compression ratio: 16.44 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 114409, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 238 
        40 - 59% = 926 
        60 - 79% = 579 
        80 - 99% = 203 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 32.44, total records: 1756363 
    Average version length: 69.02, total versions: 213913, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.88 
    Pointer pages: 20, data page slots: 32288 
    Data pages: 26992, average fill: 49% 
    Primary pages: 26992, secondary pages: 0, swept pages: 3315 
    Empty pages: 3837, full pages: 17232 
    Fill distribution: 
     0 - 19% = 5725 
    20 - 39% = 2890 
    40 - 59% = 5245 
    60 - 79% = 12211 
    80 - 99% = 921 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1288, nodes: 899951 
    Average node length: 5.92, total dup: 830644, max dup: 79 
    Average key length: 2.98, compression ratio: 14.09 
    Average prefix length: 41.10, average data length: 0.90 
    Clustering factor: 133141, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 293 
        40 - 59% = 640 
        60 - 79% = 318 
        80 - 99% = 37 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 63.74, total records: 9468353 
    Average version length: 68.94, total versions: 807350, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 91, data page slots: 147040 
    Data pages: 147016, average fill: 70% 
    Primary pages: 146996, secondary pages: 20, swept pages: 24678 
    Empty pages: 470, full pages: 107128 
    Fill distribution: 
     0 - 19% = 1314 
    20 - 39% = 5706 
    40 - 59% = 17406 
    60 - 79% = 115662 
    80 - 99% = 6928 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13495, nodes: 9461754 
    Average node length: 6.69, total dup: 7852737, max dup: 14 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2159811, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 828 
        40 - 59% = 6770 
        60 - 79% = 5113 
        80 - 99% = 784 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21182933 
    Average version length: 82.90, total versions: 21535, 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: 197, data page slots: 320160 
    Data pages: 320160, average fill: 81% 
    Primary pages: 320155, secondary pages: 5, swept pages: 11999 
    Empty pages: 5, full pages: 320152 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 49305 
    80 - 99% = 270848 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19449, nodes: 21182933 
    Average node length: 5.72, total dup: 20701141, max dup: 140 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288596, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 8223 
        60 - 79% = 553 
        80 - 99% = 10664 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17215, nodes: 21182933 
    Average node length: 6.31, total dup: 18615212, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917929, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 810 
        60 - 79% = 268 
        80 - 99% = 16131 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21222, nodes: 21182933 
    Average node length: 6.35, total dup: 18534479, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583265, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8478 
        60 - 79% = 610 
        80 - 99% = 12130 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16190, nodes: 21182933 
    Average node length: 5.56, total dup: 21182833, max dup: 231784 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946833, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 3046 
        60 - 79% = 366 
        80 - 99% = 12769 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.68, total records: 9882022 
    Average version length: 82.63, total versions: 771471, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 108, data page slots: 174840 
    Data pages: 174784, average fill: 71% 
    Primary pages: 174757, secondary pages: 27, swept pages: 44142 
    Empty pages: 558, full pages: 115998 
    Fill distribution: 
     0 - 19% = 1683 
    20 - 39% = 7566 
    40 - 59% = 24704 
    60 - 79% = 110146 
    80 - 99% = 30685 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11405, nodes: 9882022 
    Average node length: 5.37, total dup: 9572783, max dup: 217 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2250584, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 61 
        40 - 59% = 7788 
        60 - 79% = 3437 
        80 - 99% = 114 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13628, nodes: 9882022 
    Average node length: 6.24, total dup: 8196518, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1588320, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 3946 
        40 - 59% = 4268 
        60 - 79% = 2579 
        80 - 99% = 2700 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12721, nodes: 9882022 
    Average node length: 5.98, total dup: 8585754, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2444464, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 64 
        40 - 59% = 8683 
        60 - 79% = 3821 
        80 - 99% = 151 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10323, nodes: 9882022 
    Average node length: 5.14, total dup: 9881922, max dup: 163687 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1619434, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1155 
        40 - 59% = 5324 
        60 - 79% = 1690 
        80 - 99% = 2108 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.48, total records: 11543865 
    Average version length: 82.61, total versions: 601303, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 119, data page slots: 193760 
    Data pages: 192472, average fill: 74% 
    Primary pages: 192382, secondary pages: 90, swept pages: 50369 
    Empty pages: 2550, full pages: 159853 
    Fill distribution: 
     0 - 19% = 4181 
    20 - 39% = 5505 
    40 - 59% = 12517 
    60 - 79% = 96128 
    80 - 99% = 74141 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13155, nodes: 11543865 
    Average node length: 5.30, total dup: 11434064, max dup: 632 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2419296, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 97 
        40 - 59% = 8676 
        60 - 79% = 4161 
        80 - 99% = 220 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10519, nodes: 11543865 
    Average node length: 5.49, total dup: 11040592, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 743419, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 775 
        40 - 59% = 2539 
        60 - 79% = 1834 
        80 - 99% = 5231 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15041, nodes: 11543865 
    Average node length: 6.02, total dup: 10081931, max dup: 70 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2435801, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 114 
        40 - 59% = 10199 
        60 - 79% = 4463 
        80 - 99% = 263 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10912, nodes: 11543865 
    Average node length: 5.22, total dup: 11543765, max dup: 211341 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 731368, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 776 
        40 - 59% = 4868 
        60 - 79% = 1509 
        80 - 99% = 3671 
 
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: 77.08, total records: 9992887 
    Average version length: 82.90, total versions: 765831, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 110, data page slots: 178192 
    Data pages: 178152, average fill: 70% 
    Primary pages: 178125, secondary pages: 27, swept pages: 45902 
    Empty pages: 910, full pages: 122772 
    Fill distribution: 
     0 - 19% = 2390 
    20 - 39% = 8668 
    40 - 59% = 26110 
    60 - 79% = 109508 
    80 - 99% = 31476 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11984, nodes: 9992887 
    Average node length: 5.19, total dup: 9963848, max dup: 1564 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2080585, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1369 
        40 - 59% = 8047 
        60 - 79% = 1894 
        80 - 99% = 642 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13785, nodes: 9992887 
    Average node length: 6.25, total dup: 8287593, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1576904, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 3936 
        40 - 59% = 4319 
        60 - 79% = 2579 
        80 - 99% = 2779 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12643, nodes: 9992887 
    Average node length: 5.44, total dup: 9549283, max dup: 122 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2215065, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1396 
        40 - 59% = 8901 
        60 - 79% = 1673 
        80 - 99% = 645 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10475, nodes: 9992887 
    Average node length: 5.16, total dup: 9992787, max dup: 165945 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1656952, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1252 
        40 - 59% = 5307 
        60 - 79% = 1692 
        80 - 99% = 2175 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.43, total records: 579973 
    Average version length: 68.69, total versions: 7321, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8080 
    Data pages: 8080, average fill: 75% 
    Primary pages: 8080, secondary pages: 0, swept pages: 2793 
    Empty pages: 7, full pages: 7722 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 10 
    40 - 59% = 97 
    60 - 79% = 7869 
    80 - 99% = 95 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40225, depth: 3, leaf buckets: 741, nodes: 579973 
    Average node length: 5.95, total dup: 493985, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102315, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 523 
        60 - 79% = 92 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33026, depth: 3, leaf buckets: 754, nodes: 579973 
    Average node length: 6.15, total dup: 475619, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102354, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 514 
        60 - 79% = 105 
        80 - 99% = 108 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 568, nodes: 579973 
    Average node length: 4.86, total dup: 579873, max dup: 9746 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90957, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 330 
        60 - 79% = 83 
        80 - 99% = 132 
 
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 Fri Mar 29 10:09:40 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7829825 168548 1 0.0000 0.0000
DOC_LIST 2280684 86812 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3299 9 800.0000 0.0000
INVNT_TURNOVER_LOG 99578 79885 1 0.0000 0.0000
MONEY_SALDO 49 222 7 400.0000 0.0000
MONEY_TURNOVER_LOG 1413 1233 1 0.0000 0.0000
PDISTR 844584 45838 3 0.0000 0.0000
PERF_SPLIT_0 172740 1836 1 0.0000 0.0000
PERF_SPLIT_1 168231 18312 1 0.0000 0.0000
PERF_SPLIT_2 160535 796 1 0.0000 0.0000
PERF_SPLIT_3 186704 37584 1 0.0000 0.0000
PERF_SPLIT_4 165245 1993 1 0.0000 0.0000
PERF_SPLIT_5 182024 211 1 0.0000 0.0000
PERF_SPLIT_6 158538 1913 1 0.0000 0.0000
PERF_SPLIT_7 164045 2630 1 0.0000 0.0000
PERF_SPLIT_8 169261 264 1 0.0000 0.0000
PERF_SPLIT_9 150721 345 1 0.0000 0.0000
PSTORNED 2129399 65573 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 167833 79624 1 0.0000 0.0000
XQD_1000_3300 7475453 648621 1 0.0000 0.0000
XQD_1200_2000 12303368 498119 1 0.0000 0.0000
XQD_2000_3300 2141474 592526 1 0.0000 0.0000
XQD_2100_3300 1756363 213913 1 0.0000 0.0000
XQD_3300_3400 9468353 807350 1 0.0000 0.0000
XQS_1000_1200 21182933 21535 1 0.0000 0.0000
XQS_1000_3300 9882022 771471 1 0.0000 0.0000
XQS_1200_2000 11543865 601303 1 0.0000 0.0000
XQS_2100_3300 9992887 765831 1 0.0000 0.0000
XQS_3300_3400 579973 7321 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 ---
:155: 
:156: mscs-test-161.budzdorov.ru    Fri Mar 29 10:07:54 2024
:157:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:158: 
:159: 
:160: mscs-test-161.budzdorov.ru    Fri Mar 29 10:07:55 2024
:161:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:162: 
:163: 
:164: mscs-test-161.budzdorov.ru    Fri Mar 29 10:07:55 2024
:165:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:166: 
:167: 
:168: mscs-test-161.budzdorov.ru    Fri Mar 29 10:08:11 2024
:169:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:170: 
--- end of diff output ---

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

29.03.24 10:09:53. 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-03-29 10:09:55 No severe PSQL-related problems occured
29.03.24 10:09:57. End of report.