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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15810272 kB
MemAvailable 30299060 kB
Buffers 0 kB
Cached 15921852 kB
SwapCached 2620 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-22 19:09:46
DTS_END                         2024-03-22 19:09:46.5580
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57254
TRN_ID                          178589
ATT_ID                          542
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: 9481.60 22518 948160
customer order: creation 178.01 369 17801
customer order: refuse 15.19 391 1519
order to supplier: creation 48.07 1335 4807
order to supplier: removal 3.70 105954 370
invoice (draft): creation 47.25 2953 4725
invoice (draft): removal 51.32 898 5132
invoice accept: apply 42.74 20926 4274
invoice accept: cancel 46.46 800 4646
customer reserve: creation 4125.09 201 412509
customer reserve: removal 4620.42 66 462042
realization accept: apply 85.08 172 8508
realization accept: cancel 84.15 117 8415
payment from customer: creation 61.20 130 6120
payment from customer: removal 5.92 111 592
payment to supplier: creation 50.61 136 5061
payment to supplier: removal 3.90 170 390
service: total inventory turnovers 4.67 1112 467
service: total monetary turnovers 6.84 25 684
service: aggregate perf. data 0.95 15485 95
service: refresh index statistics 0.03 299005 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1942
TEST_TIME 2 2372
TEST_TIME 3 2789
TEST_TIME 4 3745
TEST_TIME 5 5143
TEST_TIME 6 5506
TEST_TIME 7 5722
TEST_TIME 8 5740
TEST_TIME 9 5679
TEST_TIME 10 5560
TEST_TIME 11 5410
TEST_TIME 12 6285
TEST_TIME 13 6132
TEST_TIME 14 6208
TEST_TIME 15 6439
TEST_TIME 16 6436
TEST_TIME 17 6405
TEST_TIME 18 6435
TEST_TIME 19 6913
TEST_TIME 20 6815
TEST_TIME 21 6960
TEST_TIME 22 7274
TEST_TIME 23 7245
TEST_TIME 24 7264
TEST_TIME 25 7863
TEST_TIME 26 7967
TEST_TIME 27 8507
TEST_TIME 28 9790
TEST_TIME 29 9738
TEST_TIME 30 9646
TEST_TIME 31 9519
TEST_TIME 32 9591
TEST_TIME 33 9579
TEST_TIME 34 9352
TEST_TIME 35 9385
TEST_TIME 36 9467
TEST_TIME 37 9296
TEST_TIME 38 9452
TEST_TIME 39 9358
TEST_TIME 40 9414
TEST_TIME 41 9366
TEST_TIME 42 9367
TEST_TIME 43 9345
TEST_TIME 44 9255
TEST_TIME 45 9249
TEST_TIME 46 9190
TEST_TIME 47 9141
TEST_TIME 48 9195
TEST_TIME 49 9178
TEST_TIME 50 9300
TEST_TIME 51 9251
TEST_TIME 52 9217
TEST_TIME 53 9404
TEST_TIME 54 9393
TEST_TIME 55 9454
TEST_TIME 56 9475
TEST_TIME 57 9476
TEST_TIME 58 9528
TEST_TIME 59 9564
TEST_TIME 60 9583
TEST_TIME 61 9675
TEST_TIME 62 9630
TEST_TIME 63 9549
TEST_TIME 64 9485
TEST_TIME 65 9462
TEST_TIME 66 9464
TEST_TIME 67 9415
TEST_TIME 68 9400
TEST_TIME 69 9348
TEST_TIME 70 9321
TEST_TIME 71 9306
TEST_TIME 72 9276
TEST_TIME 73 9332
TEST_TIME 74 9354
TEST_TIME 75 9357
TEST_TIME 76 9434
TEST_TIME 77 9432
TEST_TIME 78 9503
TEST_TIME 79 9483
TEST_TIME 80 9527
TEST_TIME 81 9556
TEST_TIME 82 9523
TEST_TIME 83 9564
TEST_TIME 84 9682
TEST_TIME 85 9670
TEST_TIME 86 9674
TEST_TIME 87 9588
TEST_TIME 88 9549
TEST_TIME 89 9523
TEST_TIME 90 9519
TEST_TIME 91 9473
TEST_TIME 92 9456
TEST_TIME 93 9412
TEST_TIME 94 9381
TEST_TIME 95 9482
TEST_TIME 96 9450
TEST_TIME 97 9508
TEST_TIME 98 9510
TEST_TIME 99 9534
TEST_TIME 100 9492

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-03-2024 19:10:54 to 22-03-2024 19:10:57.

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 1325705 1325705 0 0.00 0 20996 7 0 0
doc_list_biud 1325700 1325700 0 0.00 0 47098 29 0 0
sp_add_invoice_to_stock 4366 4274 92 2.10 23 197112 20926 0 92
sp_cancel_adding_invoice 4646 4646 0 0.00 5 71512 800 0 0
sp_cancel_client_order 1519 1519 0 0.00 4 20855 391 0 0
sp_cancel_customer_reserve 462042 462042 0 0.00 0 50150 67 0 0
sp_cancel_pay_from_customer 592 592 0 0.00 3 7509 112 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 3 19034 170 0 0
sp_cancel_supplier_invoice 5142 5132 10 0.19 2 19789 898 0 10
sp_cancel_supplier_order 370 370 0 0.00 8 1041872 105955 0 0
sp_cancel_write_off 8415 8415 0 0.00 1 14003 117 0 0
sp_client_order 17801 17801 0 0.00 3 40331 370 0 0
sp_customer_reserve 412509 412509 0 0.00 0 101124 201 0 0
sp_fill_shopping_cart 27328 27328 0 0.00 1 15084 35 0 0
sp_fill_shopping_cart_clo_res 412489 412489 0 0.00 0 12460 15 0 0
sp_get_clo_for_invoice 4253 4253 0 0.00 0 20742 275 0 0
sp_kill_cost_storno 14043 14043 0 0.00 0 6662 61 0 0
sp_kill_qstorno_ret_qs2qd 938001 938001 0 0.00 0 47094 36 0 0
sp_kill_qty_storno 494883 494883 0 0.00 0 47098 77 0 0
sp_lock_selected_doc 17760 17760 0 0.00 0 4394 5 0 0
sp_make_cost_storno 23941 23941 0 0.00 0 12059 56 0 0
sp_multiply_rows_for_pdistr 23940 23940 0 0.00 0 7683 27 0 0
sp_multiply_rows_for_qdistr 17801 17801 0 0.00 0 40323 150 0 0
sp_pay_from_customer 6120 6120 0 0.00 4 19842 130 0 0
sp_pay_to_supplier 5061 5061 0 0.00 4 19358 136 0 0
sp_payment_common 11181 11181 0 0.00 1 14237 25 0 0
sp_qd_handle_on_cancel_clo 1519 1519 0 0.00 0 8661 328 0 0
sp_qd_handle_on_invoice_upd_sts 8897 8897 0 0.00 0 18817 329 0 0
sp_qd_handle_on_reserve_upd_sts 8508 8508 0 0.00 0 10440 49 0 0
sp_reserve_write_off 8508 8508 0 0.00 6 19353 172 0 0
sp_supplier_invoice 4725 4725 0 0.00 7 83049 2954 0 0
sp_supplier_order 4807 4807 0 0.00 5 40695 1336 0 0
srv_aggregate_perf_data 95 95 0 0.00 2534 136594 15485 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 802 120957 37853 0 0
srv_find_qd_qs_mism 904220 904220 0 0.00 0 20996 6 0 0
srv_make_invnt_saldo 467 467 0 0.00 24 57327 1113 0 0
srv_make_money_saldo 684 684 0 0.00 1 614 25 0 0
srv_recalc_idx_stat 3 3 0 0.00 271014 350099 299005 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4275 4275 0 0.00 0 15076 171 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 1 3623 127 0 0
t$perf-norm:sp_cancel_client_order 1519 1519 0 0.00 0 1870 14 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 2102 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 592 592 0 0.00 0 5576 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 4068 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 348 348 0 0.00 0 733 16 0 0
t$perf-norm:sp_cancel_supplier_order 370 370 0 0.00 0 26796 1851 0 0
t$perf-norm:sp_cancel_write_off 828 828 0 0.00 0 2781 10 0 0
t$perf-norm:sp_client_order 17801 17801 0 0.00 0 9742 15 0 0
t$perf-norm:sp_customer_reserve 808 808 0 0.00 0 3942 17 0 0
t$perf-norm:sp_pay_from_customer 6120 6120 0 0.00 0 11121 12 0 0
t$perf-norm:sp_pay_to_supplier 5061 5061 0 0.00 0 8733 16 0 0
t$perf-norm:sp_reserve_write_off 8509 8509 0 0.00 0 9035 15 0 0
t$perf-norm:sp_supplier_invoice 4725 4725 0 0.00 0 8308 19 0 0
t$perf-norm:sp_supplier_order 4808 4808 0 0.00 0 5403 14 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 268 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 155 6 0 0
t$perf-norm:srv_make_invnt_saldo 467 467 0 0.00 0 1007 23 0 0
t$perf-norm:srv_make_money_saldo 684 684 0 0.00 0 969 14 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 12 5 0 0
v_add_invoice_to_stock 8678 8494 184 2.12 0 16447 22 0 184
v_all_customers 32772 32772 0 0.00 0 15 1 0 0
v_all_suppliers 27388 27388 0 0.00 0 87 1 0 0
v_all_wares 35602 35602 0 0.00 0 82 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 18057 47 0 0
v_cancel_client_order 3038 3038 0 0.00 0 18986 25 0 0
v_cancel_customer_prepayment 1184 1184 0 0.00 0 3500 9 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 2354 7 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 18989 63 0 0
v_cancel_supplier_invoice 716 696 20 2.79 0 313 13 0 20
v_cancel_supplier_order 740 740 0 0.00 0 18492 37 0 0
v_cancel_write_off 1656 1656 0 0.00 0 2871 14 0 0
v_max_id_clo_ord 4805 4805 0 0.00 0 661 2 0 0
v_max_id_clo_res 808 808 0 0.00 0 1890 13 0 0
v_max_id_ord_sup 4722 4722 0 0.00 0 2456 3 0 0
v_max_non_paid_invoice 891 891 0 0.00 0 1574 5 0 0
v_max_non_paid_realizn 3022 3022 0 0.00 0 729 3 0 0
v_min_id_clo_ord 4805 4805 0 0.00 0 3792 9 0 0
v_min_id_clo_res 808 808 0 0.00 0 4484 8 0 0
v_min_id_ord_sup 4722 4722 0 0.00 0 6119 8 0 0
v_min_non_paid_invoice 5061 5061 0 0.00 0 6548 16 0 0
v_min_non_paid_realizn 6120 6120 0 0.00 0 6614 20 0 0
v_our_firm 9026 9026 0 0.00 0 23 1 0 0
v_reserve_write_off 17016 17016 0 0.00 0 18983 12 0 0
x_lock_depdocs_on_canc_invoice 9430 9430 0 0.00 0 28107 145 0 0
x_lock_depdocs_on_canc_sup_ord 370 370 0 0.00 0 4578 334 0 0
x_make_qstorno_1000_1200 4807 4807 0 0.00 1 40689 1258 0 0
x_make_qstorno_1200_2000 4725 4725 0 0.00 3 81846 2832 0 0
x_make_qstorno_2100_3300 412508 412508 0 0.00 0 101120 183 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 22-03-2024 19:10:58 to 22-03-2024 19:11:03.

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
17:09:50 1 8192000000 8798022496 8809054208 4677920 0.057 2 1 2 0 4777520 56816 42784
17:10:51 22975 8192000000 9878169792 10182057984 963738128 10.526 100 92 182 0 993914192 5807104 24368960
17:12:28 9603 8192000000 9925862576 10242056192 1008646464 10.962 100 89 178 0 1039542720 7866800 23029456
17:13:50 16057 8192000000 9966278048 10296651776 1050859744 11.369 100 83 166 0 1081116480 9328544 20928192
17:15:10 8331 8192000000 10021269024 10364678144 1105925712 11.894 100 84 168 1 1137589152 11466352 20197088
17:16:21 6439 8192000000 10077498384 10432892928 1161500304 12.417 100 80 157 2 1192135696 12249328 18386064
17:17:33 4064 8192000000 10115640912 10485329920 1212096752 12.889 100 82 165 0 1242126016 11834560 18194704
17:18:40 1788 8192000000 10158649984 10533097472 1244093248 13.184 100 82 164 0 1274793104 13258816 17441040
17:19:43 1637 8192000000 10175657616 10554339328 1260687024 13.336 100 80 158 0 1290749600 13277840 16784736
17:20:47 1767 8192000000 10203946560 10586882048 1291543696 13.618 100 91 181 1 1325787632 14407824 19836112
17:21:49 19000 8192000000 10188973888 10596741120 1299482528 13.691 100 33 62 2 1313822256 6935552 7404176
17:23:09 4700 8192000000 10205565264 10617114624 1317645008 13.855 100 38 76 2 1332732688 6225488 8862192
17:24:17 5548 8192000000 10217566800 10631643136 1329636816 13.964 100 26 52 0 1342498320 7103712 5757792
17:25:25 44370 8192000000 10227086192 10647973888 1333225232 13.996 100 27 54 0 1348739648 9330704 6183712
17:27:10 7329 8192000000 10233282400 10655055872 1342787248 14.083 100 22 43 1 1353445776 6215456 4443072
17:28:19 11447 8192000000 10219320464 10642366464 1313792144 13.820 98 21 40 0 1323541104 5418896 4330064
17:29:31 7642 8192000000 10222890288 10630696960 1311785264 13.802 99 44 81 1 1331666016 9271344 10609408
17:30:42 44993 8192000000 10237961696 10647654400 1335949344 14.021 100 51 101 0 1355425056 8956224 10519488
17:32:32 23028 8192000000 10239951920 10647539712 1309514784 13.782 97 53 106 0 1336789728 15636832 11638112
17:33:59 16710 8192000000 10220900544 10627170304 1275590848 13.473 95 38 76 0 1303600672 18534816 9475008
17:35:19 800 8192000000 10247546768 10642362368 1319586784 13.873 100 72 144 0 1356071392 20627616 15856992
17:36:24 11669 8192000000 10235313248 10633142272 1306057296 13.750 99 58 116 0 1338980656 19860160 13063200
17:37:39 9789 8192000000 10236461920 10638225408 1320458320 13.881 100 59 118 1 1355437568 21506912 13472336
17:38:53 34051 8192000000 10242226272 10647375872 1292356048 13.626 97 42 83 1 1323319504 20568080 10395376
17:40:54 23374 8192000000 10276656144 10681593856 1338616896 14.045 99 44 86 2 1380537120 30830304 11089920
17:42:25 3792 8192000000 10247482416 10646953984 1307697472 13.765 97 58 116 1 1344172464 23098432 13376560
17:43:50 3925 8192000000 10296646752 10697420800 1360355696 14.241 100 82 163 0 1405705552 26105088 19244768
17:45:10 22345 8192000000 10271231024 10674237440 1327292624 13.943 98 55 110 0 1368038864 27261712 13484528
17:46:38 4038 8192000000 10329221376 10732179456 1368975664 14.318 99 74 147 0 1423188144 35441264 18771216
17:47:52 5259 8192000000 10340442048 10748448768 1384224656 14.454 100 73 141 1 1447965712 46084208 17656848
17:49:04 7669 8192000000 10333624784 10749997056 1387294480 14.482 99 52 101 2 1432935088 31705728 13934880
17:50:21 6054 8192000000 10359017216 10773626880 1408740464 14.673 100 81 162 1 1469964528 40754672 20469392
17:51:37 26096 8192000000 10349636704 10777505792 1409716624 14.681 100 31 62 0 1456629696 38215120 8697952
17:53:07 14987 8192000000 10350805104 10774781952 1394747344 14.548 100 33 66 0 1452565664 48347968 9470352
17:54:42 10607 8192000000 10344947440 10777030656 1394589824 14.547 100 38 76 0 1454603984 49773904 10240256
17:56:13 18274 8192000000 10334169024 10780495872 1378465504 14.403 100 26 49 1 1445906208 60367440 7073264
17:57:34 10081 8192000000 10302131520 10750332928 1384819968 14.460 100 35 70 2 1418634064 25254832 8559264
17:58:49 40275 8192000000 10303962432 10752053248 1391510672 14.519 100 21 42 1 1406259872 10252416 4496784
18:00:33 42651 8192000000 10313242032 10766462976 1402166320 14.614 100 41 79 1 1422921312 12069072 8685920
18:02:34 120957 8192000000 10313620928 10769211392 1402614944 14.618 100 27 54 0 1421483840 12693328 6175568
18:05:40 45576 8192000000 10313126704 10768498688 1403394752 14.625 100 38 76 1 1423499632 10901120 9203760
18:07:34 12418 8192000000 10305835680 10766344192 1405456400 14.644 100 20 36 0 1415560352 6239136 3864816
18:09:06 8970 8192000000 10324600224 10778873856 1412665040 14.708 100 48 96 0 1434765696 11199552 10901104
18:10:17 53062 8192000000 10318542048 10784804864 1418760096 14.762 100 19 38 0 1436090336 13412304 3917936
18:12:27 41515 8192000000 10309249584 10772606976 1412253472 14.704 100 14 28 1 1422407456 6898944 3255040
18:14:10 51672 8192000000 10301385408 10778550272 1383579136 14.449 98 14 26 0 1393696288 7698336 2418816
18:16:03 58678 8192000000 10297272976 10769031168 1399595792 14.591 100 16 32 1 1415750928 12712448 3442688
18:18:06 28861 8192000000 10302579312 10765963264 1379788208 14.415 98 32 62 0 1395180704 7976288 7416208
18:19:42 41666 8192000000 10306059616 10757124096 1391059792 14.515 100 21 42 0 1406690832 11358240 4272800
18:21:25 32883 8192000000 10285306176 10731532288 1342497920 14.080 97 39 78 0 1366728720 15169920 9060880
18:23:02 22721 8192000000 10276595616 10716192768 1321015024 13.886 96 21 42 0 1334806144 8988960 4802160
18:24:27 65636 8192000000 10260541216 10711109632 1278854784 13.503 93 25 50 0 1300172752 15596448 5721520
18:26:34 39091 8192000000 10261242704 10699366400 1308819440 13.775 97 35 70 0 1332956784 16333888 7803456
18:28:32 10665 8192000000 10263651504 10690228224 1332423904 13.989 100 43 84 0 1358944944 16863840 9657200
18:29:43 116001 8192000000 10247077120 10705981440 1275046992 13.468 94 13 26 0 1300560880 22451440 3062448
18:33:19 40105 8192000000 10238769936 10677673984 1315320480 13.834 98 30 58 1 1330801744 9557040 5924224
18:34:59 61330 8192000000 10235483824 10693349376 1338805696 14.047 100 13 26 0 1351234512 9572992 2855824
18:37:03 33880 8192000000 10236249616 10680913920 1334857872 14.011 99 20 38 1 1345944768 6666448 4420448
18:38:49 85580 8192000000 10257618848 10710151168 1336398192 14.025 98 26 52 0 1351148720 8874176 5876352
18:41:48 69136 8192000000 10280586448 10738147328 1378535200 14.403 100 12 24 0 1391847744 10622048 2690496
18:43:58 14463 8192000000 10296246368 10744573952 1387895888 14.487 100 58 114 1 1409016128 6191376 14928864
18:45:19 64182 8192000000 10303019648 10766479360 1377721200 14.396 99 21 42 0 1402449104 19629840 5098064
18:47:23 39435 8192000000 10313105744 10765840384 1399283312 14.589 100 25 50 0 1414053216 9031344 5738560
18:49:26 112085 8192000000 10327723664 10774933504 1405732480 14.646 100 19 36 0 1421258992 11616880 3909632
18:52:21 56731 8192000000 10319468160 10780205056 1366327744 14.294 97 9 18 0 1391713840 22545888 2840208
18:54:19 18888 8192000000 10315211472 10759057408 1382401472 14.438 98 32 64 0 1396911472 7442512 7067488
18:55:38 81751 8192000000 10321532768 10769797120 1409081568 14.676 100 13 26 0 1426851824 14744032 3026224
18:58:03 52593 8192000000 10312833648 10772467712 1402136720 14.614 99 29 59 0 1419119744 10762448 6220576
18:59:56 60842 8192000000 10300785328 10762625024 1373745648 14.361 97 13 26 0 1386062032 9484848 2831536
19:01:58 47813 8192000000 10291077856 10742837248 1360864928 14.245 97 11 22 0 1377198752 13509040 2824784
19:03:47 67843 8192000000 10279309200 10751455232 1372412704 14.349 99 19 38 0 1393942496 16733616 4796176
19:06:19 45391 8192000000 10243819632 10708557824 1326151872 13.932 97 14 28 0 1342361328 13106496 3102960
19:08:05 36827 8192000000 10267855776 10719227904 1358178944 14.221 99 33 66 0 1375396688 9995552 7222192

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 22-03-2024 19:11:05 to 22-03-2024 19:11:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 92 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-03-2024 19:11:19 to 22-03-2024 19:11:21.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          175178
MON$OLDEST_ACTIVE               178940
MON$OLDEST_SNAPSHOT             178940
MON$NEXT_TRANSACTION            178940
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1904864
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Mar 22 19:11:22 2024 
 
Database header page information: 
    Flags            0 
    Generation        93039 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175178 
    Oldest active        178940 
    Oldest snapshot        178940 
    Next transaction    178941 
    Sequence number        0 
    Next attachment ID    719 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.35, total records: 7751182 
    Average version length: 48.15, total versions: 88434, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86824 
    Data pages: 86824, average fill: 71% 
    Primary pages: 86824, secondary pages: 0, swept pages: 18273 
    Empty pages: 2, full pages: 67350 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 270 
    40 - 59% = 2955 
    60 - 79% = 83537 
    80 - 99% = 36 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23481, nodes: 7751182 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1716666, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 348 
        20 - 39% = 1971 
        40 - 59% = 4264 
        60 - 79% = 2499 
        80 - 99% = 14399 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13636, nodes: 7751182 
    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: 1538971, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1719 
        40 - 59% = 2062 
        60 - 79% = 1170 
        80 - 99% = 8685 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8393, nodes: 7751182 
    Average node length: 6.61, total dup: 5802595, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1531855, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 1026 
        40 - 59% = 1409 
        60 - 79% = 984 
        80 - 99% = 4855 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.23, total records: 2240196 
    Average version length: 34.58, total versions: 93443, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28288 
    Data pages: 28288, average fill: 73% 
    Primary pages: 28280, secondary pages: 8, swept pages: 9211 
    Empty pages: 6, full pages: 21270 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 149 
    40 - 59% = 1836 
    60 - 79% = 25560 
    80 - 99% = 716 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4597, nodes: 2240196 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 693525, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 957 
        40 - 59% = 866 
        60 - 79% = 785 
        80 - 99% = 1989 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2500, nodes: 2242626 
    Average node length: 4.97, total dup: 2241727, max dup: 18552 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249303, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 245 
        40 - 59% = 1515 
        60 - 79% = 558 
        80 - 99% = 181 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2086, nodes: 2240196 
    Average node length: 4.97, total dup: 2240146, max dup: 130574 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1054945, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 140 
        40 - 59% = 1120 
        60 - 79% = 62 
        80 - 99% = 762 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4385, nodes: 2240196 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 693525, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 607 
        40 - 59% = 665 
        60 - 79% = 880 
        80 - 99% = 2137 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.45, total records: 400 
    Average version length: 23.29, total versions: 232727, max versions: 606 
    Average fragment length: 2.00, total fragments: 45, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1304 
    Data pages: 1304, average fill: 90% 
    Primary pages: 14, secondary pages: 1290, swept pages: 0 
    Empty pages: 7, full pages: 1296 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1295 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 4.14, total records: 69426 
    Average version length: 68.28, total versions: 65216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 21.26 
    Pointer pages: 6, data page slots: 3208 
    Data pages: 1968, average fill: 45% 
    Primary pages: 1967, secondary pages: 1, swept pages: 0 
    Empty pages: 606, full pages: 726 
    Fill distribution: 
     0 - 19% = 760 
    20 - 39% = 160 
    40 - 59% = 171 
    60 - 79% = 292 
    80 - 99% = 585 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709846, depth: 3, leaf buckets: 263, nodes: 69426 
    Average node length: 13.23, total dup: 3832, max dup: 2 
    Average key length: 10.83, compression ratio: 2.49 
    Average prefix length: 19.11, average data length: 7.89 
    Clustering factor: 51516, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 119 
        40 - 59% = 118 
        60 - 79% = 21 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18356, max versions: 972 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 1.07, total records: 1390 
    Average version length: 43.33, total versions: 1356, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 54.25 
    Pointer pages: 1, data page slots: 72 
    Data pages: 28, average fill: 48% 
    Primary pages: 27, secondary pages: 1, swept pages: 2 
    Empty pages: 7, full pages: 12 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93152, depth: 2, leaf buckets: 3, nodes: 1390 
    Average node length: 4.41, total dup: 1292, max dup: 116 
    Average key length: 2.75, compression ratio: 6.91 
    Average prefix length: 18.32, average data length: 0.68 
    Clustering factor: 747, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.18, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.18, total records: 815038 
    Average version length: 25.36, total versions: 66026, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8104 
    Data pages: 8096, average fill: 70% 
    Primary pages: 8073, secondary pages: 23, swept pages: 1396 
    Empty pages: 57, full pages: 7306 
    Fill distribution: 
     0 - 19% = 117 
    20 - 39% = 82 
    40 - 59% = 125 
    60 - 79% = 7507 
    80 - 99% = 265 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 879, nodes: 815038 
    Average node length: 4.87, total dup: 814989, max dup: 154687 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90425, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 114 
        40 - 59% = 486 
        60 - 79% = 205 
        80 - 99% = 72 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 974, nodes: 815038 
    Average node length: 5.88, total dup: 725736, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163216, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 99 
        40 - 59% = 476 
        60 - 79% = 133 
        80 - 99% = 263 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1016, nodes: 815038 
    Average node length: 5.88, total dup: 725736, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165166, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 200 
        40 - 59% = 440 
        60 - 79% = 107 
        80 - 99% = 268 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1167, nodes: 815038 
    Average node length: 5.96, total dup: 725736, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157940, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 269 
        40 - 59% = 618 
        60 - 79% = 188 
        80 - 99% = 90 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5455 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.54, total fragments: 109, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 73, secondary pages: 15, swept pages: 51 
    Empty pages: 6, full pages: 66 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 69 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5455 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.41, average data length: 1.54 
    Clustering factor: 5164, 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: 1504233, depth: 2, leaf buckets: 10, nodes: 5455 
    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: 146, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 81773 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 788 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 788 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 39450, depth: 2, leaf buckets: 105, nodes: 81773 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3201, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.21, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 149.57, total records: 168138 
    Average version length: 146.03, total versions: 1436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 4424 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 2 
    Empty pages: 21, full pages: 3974 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3974 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 146.98, total records: 166244 
    Average version length: 151.40, total versions: 4185, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 5, data page slots: 4576 
    Data pages: 4008, average fill: 85% 
    Primary pages: 4008, secondary pages: 0, swept pages: 4 
    Empty pages: 64, full pages: 3928 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 3927 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 128.79, total records: 202489 
    Average version length: 153.91, total versions: 29767, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.17 
    Pointer pages: 7, data page slots: 5208 
    Data pages: 4864, average fill: 87% 
    Primary pages: 4864, secondary pages: 0, swept pages: 3 
    Empty pages: 49, full pages: 4799 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4798 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 144.23, total records: 180242 
    Average version length: 153.21, total versions: 7981, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 8, data page slots: 5368 
    Data pages: 4320, average fill: 86% 
    Primary pages: 4320, secondary pages: 0, swept pages: 6 
    Empty pages: 37, full pages: 4259 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 6 
    40 - 59% = 10 
    60 - 79% = 6 
    80 - 99% = 4257 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 144.17, total records: 155983 
    Average version length: 152.87, total versions: 6788, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 7, data page slots: 6224 
    Data pages: 3752, average fill: 86% 
    Primary pages: 3752, secondary pages: 0, swept pages: 6 
    Empty pages: 53, full pages: 3685 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3682 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.68, total records: 190139 
    Average version length: 151.75, total versions: 4170, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 6168 
    Data pages: 4544, average fill: 86% 
    Primary pages: 4544, secondary pages: 0, swept pages: 4 
    Empty pages: 33, full pages: 4499 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 4500 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 146.41, total records: 181934 
    Average version length: 151.90, total versions: 5589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 8, data page slots: 5496 
    Data pages: 4392, average fill: 86% 
    Primary pages: 4392, secondary pages: 0, swept pages: 5 
    Empty pages: 67, full pages: 4299 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 8 
    40 - 59% = 10 
    60 - 79% = 6 
    80 - 99% = 4298 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.95, total records: 157563 
    Average version length: 152.51, total versions: 5035, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 8, data page slots: 4384 
    Data pages: 3776, average fill: 86% 
    Primary pages: 3776, secondary pages: 0, swept pages: 8 
    Empty pages: 39, full pages: 3721 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3721 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.71, total records: 191754 
    Average version length: 151.76, total versions: 8268, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 6, data page slots: 4904 
    Data pages: 4624, average fill: 86% 
    Primary pages: 4624, secondary pages: 0, swept pages: 6 
    Empty pages: 63, full pages: 4539 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4540 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.40, total records: 171598 
    Average version length: 152.59, total versions: 5021, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5920 
    Data pages: 4168, average fill: 85% 
    Primary pages: 4168, secondary pages: 0, swept pages: 4 
    Empty pages: 90, full pages: 4050 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4050 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.75, total records: 2097936 
    Average version length: 52.90, total versions: 39526, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25568 
    Data pages: 25560, average fill: 71% 
    Primary pages: 25560, secondary pages: 0, swept pages: 10523 
    Empty pages: 329, full pages: 20910 
    Fill distribution: 
     0 - 19% = 619 
    20 - 39% = 487 
    40 - 59% = 1165 
    60 - 79% = 22925 
    80 - 99% = 364 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2578, nodes: 2097936 
    Average node length: 5.44, total dup: 1957714, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181492, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 300 
        40 - 59% = 1660 
        60 - 79% = 311 
        80 - 99% = 301 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2753, nodes: 2097936 
    Average node length: 5.69, total dup: 1883055, max dup: 61 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374937, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2377 
        60 - 79% = 338 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2165, nodes: 2097936 
    Average node length: 4.96, total dup: 2097836, max dup: 27015 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179270, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 193 
        40 - 59% = 1214 
        60 - 79% = 371 
        80 - 99% = 385 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 38.14, total records: 141683 
    Average version length: 69.18, total versions: 63612, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.30 
    Pointer pages: 3, data page slots: 3840 
    Data pages: 2664, average fill: 62% 
    Primary pages: 2664, secondary pages: 0, swept pages: 329 
    Empty pages: 413, full pages: 1891 
    Fill distribution: 
     0 - 19% = 590 
    20 - 39% = 98 
    40 - 59% = 51 
    60 - 79% = 653 
    80 - 99% = 1272 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106296, depth: 3, leaf buckets: 196, nodes: 141683 
    Average node length: 6.41, total dup: 123293, max dup: 14 
    Average key length: 3.95, compression ratio: 10.63 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 23802, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 19 
        40 - 59% = 90 
        60 - 79% = 66 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.03, total records: 7199741 
    Average version length: 68.75, total versions: 410417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 64, data page slots: 102824 
    Data pages: 102824, average fill: 75% 
    Primary pages: 102824, secondary pages: 0, swept pages: 23561 
    Empty pages: 2, full pages: 85024 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 772 
    40 - 59% = 5961 
    60 - 79% = 88957 
    80 - 99% = 7074 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10685, nodes: 7199741 
    Average node length: 6.51, total dup: 6227020, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1607002, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1431 
        40 - 59% = 5716 
        60 - 79% = 2957 
        80 - 99% = 569 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8589, nodes: 7199741 
    Average node length: 5.39, total dup: 6914184, max dup: 163 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1402653, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1272 
        40 - 59% = 4533 
        60 - 79% = 1563 
        80 - 99% = 1210 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8650, nodes: 7199741 
    Average node length: 5.39, total dup: 6914184, max dup: 163 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1405182, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1324 
        40 - 59% = 4530 
        60 - 79% = 1583 
        80 - 99% = 1205 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.01, total records: 12223825 
    Average version length: 68.71, total versions: 343944, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 104, data page slots: 169112 
    Data pages: 169112, average fill: 77% 
    Primary pages: 169112, secondary pages: 0, swept pages: 72867 
    Empty pages: 7, full pages: 161176 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 357 
    40 - 59% = 2484 
    60 - 79% = 159181 
    80 - 99% = 7053 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18377, nodes: 12223825 
    Average node length: 6.59, total dup: 10653540, max dup: 65 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2409122, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2043 
        40 - 59% = 10660 
        60 - 79% = 4836 
        80 - 99% = 813 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.58, total records: 1714648 
    Average version length: 69.08, total versions: 683827, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 27, data page slots: 42192 
    Data pages: 27248, average fill: 72% 
    Primary pages: 27248, secondary pages: 0, swept pages: 4813 
    Empty pages: 1557, full pages: 21385 
    Fill distribution: 
     0 - 19% = 2719 
    20 - 39% = 1082 
    40 - 59% = 1018 
    60 - 79% = 10904 
    80 - 99% = 11525 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2122, nodes: 1714648 
    Average node length: 5.51, total dup: 1645830, max dup: 99 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 113169, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 319 
        40 - 59% = 1038 
        60 - 79% = 564 
        80 - 99% = 194 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.93, total records: 1049983 
    Average version length: 69.11, total versions: 472766, 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: 22, data page slots: 35840 
    Data pages: 27279, average fill: 45% 
    Primary pages: 27279, secondary pages: 0, swept pages: 6340 
    Empty pages: 6661, full pages: 10886 
    Fill distribution: 
     0 - 19% = 10262 
    20 - 39% = 2281 
    40 - 59% = 1622 
    60 - 79% = 6241 
    80 - 99% = 6873 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1459, nodes: 1049983 
    Average node length: 5.78, total dup: 980758, max dup: 99 
    Average key length: 2.86, compression ratio: 14.70 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 140930, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 306 
        40 - 59% = 743 
        60 - 79% = 334 
        80 - 99% = 73 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.40, total records: 9157521 
    Average version length: 68.94, total versions: 464699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 88, data page slots: 143608 
    Data pages: 143584, average fill: 68% 
    Primary pages: 143584, secondary pages: 0, swept pages: 53548 
    Empty pages: 301, full pages: 78406 
    Fill distribution: 
     0 - 19% = 1280 
    20 - 39% = 7021 
    40 - 59% = 23842 
    60 - 79% = 104373 
    80 - 99% = 7068 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13466, nodes: 9157521 
    Average node length: 6.68, total dup: 7597185, max dup: 25 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1961687, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1332 
        40 - 59% = 6941 
        60 - 79% = 4559 
        80 - 99% = 631 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21186816 
    Average version length: 82.94, total versions: 15422, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319256 
    Data pages: 319256, average fill: 81% 
    Primary pages: 319256, secondary pages: 0, swept pages: 12288 
    Empty pages: 24, full pages: 318801 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 24 
    40 - 59% = 55 
    60 - 79% = 27321 
    80 - 99% = 291822 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19487, nodes: 21186816 
    Average node length: 5.72, total dup: 20705106, max dup: 142 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286361, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8279 
        60 - 79% = 581 
        80 - 99% = 10622 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17208, nodes: 21186816 
    Average node length: 6.31, total dup: 18618650, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916599, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 802 
        60 - 79% = 269 
        80 - 99% = 16132 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21246, nodes: 21186816 
    Average node length: 6.35, total dup: 18538107, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3581631, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8500 
        60 - 79% = 621 
        80 - 99% = 12120 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16185, nodes: 21186816 
    Average node length: 5.56, total dup: 21186716, max dup: 228974 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945426, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 12 
        40 - 59% = 2995 
        60 - 79% = 393 
        80 - 99% = 12783 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.31, total records: 9625745 
    Average version length: 82.57, total versions: 479319, 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: 105, data page slots: 170840 
    Data pages: 170792, average fill: 70% 
    Primary pages: 170792, secondary pages: 0, swept pages: 69859 
    Empty pages: 732, full pages: 98860 
    Fill distribution: 
     0 - 19% = 2171 
    20 - 39% = 8601 
    40 - 59% = 27528 
    60 - 79% = 69768 
    80 - 99% = 62724 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11343, nodes: 9625745 
    Average node length: 5.37, total dup: 9317286, max dup: 196 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2106679, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 91 
        40 - 59% = 8304 
        60 - 79% = 2877 
        80 - 99% = 68 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13725, nodes: 9625745 
    Average node length: 6.23, total dup: 7980630, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1451859, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 4185 
        40 - 59% = 4552 
        60 - 79% = 2669 
        80 - 99% = 2170 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12669, nodes: 9625745 
    Average node length: 5.98, total dup: 8351278, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2296746, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 106 
        40 - 59% = 9338 
        60 - 79% = 3133 
        80 - 99% = 89 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10155, nodes: 9625745 
    Average node length: 5.13, total dup: 9625645, max dup: 141632 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1491949, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1330 
        40 - 59% = 5072 
        60 - 79% = 1704 
        80 - 99% = 1998 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.44, total records: 11259904 
    Average version length: 82.51, total versions: 391046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 191712 
    Data pages: 190272, average fill: 73% 
    Primary pages: 190272, secondary pages: 0, swept pages: 66931 
    Empty pages: 3459, full pages: 143193 
    Fill distribution: 
     0 - 19% = 5779 
    20 - 39% = 7789 
    40 - 59% = 17686 
    60 - 79% = 39863 
    80 - 99% = 119155 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13105, nodes: 11259904 
    Average node length: 5.30, total dup: 11150196, max dup: 680 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2340276, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 121 
        40 - 59% = 9216 
        60 - 79% = 3667 
        80 - 99% = 101 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10472, nodes: 11259904 
    Average node length: 5.49, total dup: 10768773, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 698016, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 922 
        40 - 59% = 2639 
        60 - 79% = 1799 
        80 - 99% = 4953 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14990, nodes: 11259904 
    Average node length: 6.02, total dup: 9824637, max dup: 75 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2356739, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 163 
        40 - 59% = 10680 
        60 - 79% = 4012 
        80 - 99% = 133 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10830, nodes: 11259904 
    Average node length: 5.22, total dup: 11259804, max dup: 185050 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 686551, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 841 
        40 - 59% = 4910 
        60 - 79% = 1586 
        80 - 99% = 3388 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.71, total records: 9735445 
    Average version length: 82.89, total versions: 474625, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 108, data page slots: 175080 
    Data pages: 175024, average fill: 69% 
    Primary pages: 175024, secondary pages: 0, swept pages: 75241 
    Empty pages: 897, full pages: 97688 
    Fill distribution: 
     0 - 19% = 2526 
    20 - 39% = 9598 
    40 - 59% = 29622 
    60 - 79% = 73077 
    80 - 99% = 60201 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11744, nodes: 9735445 
    Average node length: 5.18, total dup: 9706743, max dup: 1571 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1919667, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1474 
        40 - 59% = 7741 
        60 - 79% = 1888 
        80 - 99% = 610 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13854, nodes: 9735445 
    Average node length: 6.25, total dup: 8071110, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1416667, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 170 
        20 - 39% = 4228 
        40 - 59% = 4469 
        60 - 79% = 2686 
        80 - 99% = 2301 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12380, nodes: 9735445 
    Average node length: 5.44, total dup: 9300277, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2052671, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1433 
        40 - 59% = 8615 
        60 - 79% = 1717 
        80 - 99% = 588 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10285, nodes: 9735445 
    Average node length: 5.15, total dup: 9735345, max dup: 143744 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1511716, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1275 
        40 - 59% = 5272 
        60 - 79% = 1715 
        80 - 99% = 1982 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.47, total records: 573930 
    Average version length: 68.78, total versions: 5932, 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: 7992 
    Data pages: 7992, average fill: 75% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3781 
    Empty pages: 7, full pages: 6752 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 31 
    40 - 59% = 275 
    60 - 79% = 7583 
    80 - 99% = 96 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46607, depth: 3, leaf buckets: 729, nodes: 573930 
    Average node length: 5.95, total dup: 488587, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100012, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 507 
        60 - 79% = 88 
        80 - 99% = 101 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35311, depth: 3, leaf buckets: 748, nodes: 573930 
    Average node length: 6.15, total dup: 470705, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100059, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 512 
        60 - 79% = 88 
        80 - 99% = 111 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 575, nodes: 573930 
    Average node length: 4.86, total dup: 573830, max dup: 9886 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88837, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 345 
        60 - 79% = 85 
        80 - 99% = 112 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar 22 19:11:46 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7751182 88434 1 0.0000 0.0000
DOC_LIST 2240196 93443 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 232727 606 58100.0000 0.0000
INVNT_TURNOVER_LOG 69426 65216 1 0.0000 0.0000
MONEY_SALDO 49 18356 972 37400.0000 0.0000
MONEY_TURNOVER_LOG 1390 1356 1 0.0000 0.0000
PDISTR 815038 66026 4 0.0000 0.0000
PERF_SPLIT_0 168138 1436 1 0.0000 0.0000
PERF_SPLIT_1 166244 4185 1 0.0000 0.0000
PERF_SPLIT_2 202489 29767 1 0.0000 0.0000
PERF_SPLIT_3 180242 7981 1 0.0000 0.0000
PERF_SPLIT_4 155983 6788 1 0.0000 0.0000
PERF_SPLIT_5 190139 4170 1 0.0000 0.0000
PERF_SPLIT_6 181934 5589 1 0.0000 0.0000
PERF_SPLIT_7 157563 5035 1 0.0000 0.0000
PERF_SPLIT_8 191754 8268 1 0.0000 0.0000
PERF_SPLIT_9 171598 5021 1 0.0000 0.0000
PSTORNED 2097936 39526 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 141683 63612 1 0.0000 0.0000
XQD_1000_3300 7199741 410417 1 0.0000 0.0000
XQD_1200_2000 12223825 343944 1 0.0000 0.0000
XQD_2000_3300 1714648 683827 1 0.0000 0.0000
XQD_2100_3300 1049983 472766 1 0.0000 0.0000
XQD_3300_3400 9157521 464699 1 0.0000 0.0000
XQS_1000_1200 21186816 15422 1 0.0000 0.0000
XQS_1000_3300 9625745 479319 1 0.0000 0.0000
XQS_1200_2000 11259904 391046 1 0.0000 0.0000
XQS_2100_3300 9735445 474625 1 0.0000 0.0000
XQS_3300_3400 573930 5932 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 ---
:127: 
:128: mscs-test-161.budzdorov.ru    Fri Mar 22 19:09:48 2024
:129:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:130: 
:131: 
:132: mscs-test-161.budzdorov.ru    Fri Mar 22 19:09:53 2024
:133:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:134: 
--- end of diff output ---

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

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