Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.03.2024 16: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 15779488 kB
MemAvailable 30286988 kB
Buffers 0 kB
Cached 15953780 kB
SwapCached 2320 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-11 16:09:36
DTS_END                         2024-03-11 16:09:36.5010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44112
TRN_ID                          181822
ATT_ID                          583
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: 9506.67 20402 950667
customer order: creation 186.60 325 18660
customer order: refuse 15.89 371 1589
order to supplier: creation 49.60 1236 4960
order to supplier: removal 3.63 93450 363
invoice (draft): creation 49.52 3090 4952
invoice (draft): removal 51.66 815 5166
invoice accept: apply 44.77 19271 4477
invoice accept: cancel 46.61 920 4661
customer reserve: creation 4172.06 190 417206
customer reserve: removal 4577.56 58 457756
realization accept: apply 90.68 188 9068
realization accept: cancel 77.03 123 7703
payment from customer: creation 64.59 119 6459
payment from customer: removal 5.91 80 591
payment to supplier: creation 53.57 149 5357
payment to supplier: removal 3.83 60 383
service: total inventory turnovers 4.90 1239 490
service: total monetary turnovers 7.46 56 746
service: aggregate perf. data 0.77 22281 77
service: refresh index statistics 0.03 264012 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-03-2024 16:10:35 to 11-03-2024 16:10:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4380
TEST_TIME 2 4789
TEST_TIME 3 6391
TEST_TIME 4 6174
TEST_TIME 5 6332
TEST_TIME 6 6285
TEST_TIME 7 6135
TEST_TIME 8 6110
TEST_TIME 9 5965
TEST_TIME 10 5698
TEST_TIME 11 5925
TEST_TIME 12 6079
TEST_TIME 13 5867
TEST_TIME 14 5926
TEST_TIME 15 6125
TEST_TIME 16 6302
TEST_TIME 17 6543
TEST_TIME 18 6932
TEST_TIME 19 6888
TEST_TIME 20 7251
TEST_TIME 21 7817
TEST_TIME 22 7903
TEST_TIME 23 7945
TEST_TIME 24 7970
TEST_TIME 25 7970
TEST_TIME 26 8196
TEST_TIME 27 8435
TEST_TIME 28 9445
TEST_TIME 29 9703
TEST_TIME 30 9598
TEST_TIME 31 9807
TEST_TIME 32 9528
TEST_TIME 33 9555
TEST_TIME 34 9531
TEST_TIME 35 9574
TEST_TIME 36 9605
TEST_TIME 37 9407
TEST_TIME 38 9415
TEST_TIME 39 9349
TEST_TIME 40 9396
TEST_TIME 41 9473
TEST_TIME 42 9509
TEST_TIME 43 9479
TEST_TIME 44 9379
TEST_TIME 45 9285
TEST_TIME 46 9414
TEST_TIME 47 9407
TEST_TIME 48 9337
TEST_TIME 49 9316
TEST_TIME 50 9393
TEST_TIME 51 9405
TEST_TIME 52 9433
TEST_TIME 53 9563
TEST_TIME 54 9560
TEST_TIME 55 9595
TEST_TIME 56 9602
TEST_TIME 57 9609
TEST_TIME 58 9799
TEST_TIME 59 9751
TEST_TIME 60 9795
TEST_TIME 61 9669
TEST_TIME 62 9604
TEST_TIME 63 9662
TEST_TIME 64 9575
TEST_TIME 65 9515
TEST_TIME 66 9537
TEST_TIME 67 9568
TEST_TIME 68 9506
TEST_TIME 69 9451
TEST_TIME 70 9516
TEST_TIME 71 9434
TEST_TIME 72 9450
TEST_TIME 73 9410
TEST_TIME 74 9474
TEST_TIME 75 9464
TEST_TIME 76 9543
TEST_TIME 77 9488
TEST_TIME 78 9585
TEST_TIME 79 9568
TEST_TIME 80 9564
TEST_TIME 81 9597
TEST_TIME 82 9580
TEST_TIME 83 9669
TEST_TIME 84 9670
TEST_TIME 85 9683
TEST_TIME 86 9795
TEST_TIME 87 9703
TEST_TIME 88 9664
TEST_TIME 89 9663
TEST_TIME 90 9649
TEST_TIME 91 9622
TEST_TIME 92 9577
TEST_TIME 93 9530
TEST_TIME 94 9530
TEST_TIME 95 9542
TEST_TIME 96 9488
TEST_TIME 97 9454
TEST_TIME 98 9520
TEST_TIME 99 9551
TEST_TIME 100 9520

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-03-2024 16:10:38 to 11-03-2024 16:10:42.

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 1332023 1332023 0 0.00 0 13444 7 0 0
doc_list_biud 1332023 1332023 0 0.00 0 59380 26 0 0
sp_add_invoice_to_stock 4601 4477 124 2.69 56 162860 19271 0 124
sp_cancel_adding_invoice 4661 4661 0 0.00 4 68575 921 0 0
sp_cancel_client_order 1589 1589 0 0.00 4 20962 372 0 0
sp_cancel_customer_reserve 457756 457756 0 0.00 0 44297 58 0 0
sp_cancel_pay_from_customer 591 591 0 0.00 3 4773 80 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 3 3404 61 0 0
sp_cancel_supplier_invoice 5174 5166 8 0.15 1 59390 815 0 8
sp_cancel_supplier_order 363 363 0 0.00 5 1136544 93450 0 0
sp_cancel_write_off 7703 7703 0 0.00 1 11902 124 0 0
sp_client_order 18660 18660 0 0.00 3 14188 326 0 0
sp_customer_reserve 417206 417206 0 0.00 0 33716 191 0 0
sp_fill_shopping_cart 28566 28566 0 0.00 1 8512 32 0 0
sp_fill_shopping_cart_clo_res 417186 417186 0 0.00 0 13410 14 0 0
sp_get_clo_for_invoice 4457 4457 0 0.00 0 13320 250 0 0
sp_kill_cost_storno 13338 13338 0 0.00 0 6810 67 0 0
sp_kill_qstorno_ret_qs2qd 928744 928744 0 0.00 0 59377 32 0 0
sp_kill_qty_storno 490763 490763 0 0.00 0 59379 69 0 0
sp_lock_selected_doc 18705 18705 0 0.00 0 7171 6 0 0
sp_make_cost_storno 25341 25341 0 0.00 0 12528 60 0 0
sp_multiply_rows_for_pdistr 25341 25341 0 0.00 0 7647 31 0 0
sp_multiply_rows_for_qdistr 18660 18660 0 0.00 0 11909 158 0 0
sp_pay_from_customer 6459 6459 0 0.00 4 12801 119 0 0
sp_pay_to_supplier 5357 5357 0 0.00 5 12809 149 0 0
sp_payment_common 11816 11816 0 0.00 1 12788 35 0 0
sp_qd_handle_on_cancel_clo 1589 1589 0 0.00 0 20948 347 0 0
sp_qd_handle_on_invoice_upd_sts 9118 9118 0 0.00 0 43461 330 0 0
sp_qd_handle_on_reserve_upd_sts 9068 9068 0 0.00 0 14494 56 0 0
sp_reserve_write_off 9068 9068 0 0.00 6 14687 189 0 0
sp_supplier_invoice 4952 4952 0 0.00 7 74886 3090 0 0
sp_supplier_order 4960 4960 0 0.00 5 50497 1236 0 0
srv_aggregate_perf_data 77 77 0 0.00 1819 353992 22282 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1086 142046 38953 0 0
srv_find_qd_qs_mism 905002 905002 0 0.00 0 13441 6 0 0
srv_make_invnt_saldo 490 490 0 0.00 40 94104 1240 0 0
srv_make_money_saldo 746 746 0 0.00 0 13237 57 0 0
srv_recalc_idx_stat 3 3 0 0.00 207225 336244 264012 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4477 4477 0 0.00 0 34593 241 0 0
t$perf-norm:sp_cancel_adding_invoice 387 387 0 0.00 0 2515 81 0 0
t$perf-norm:sp_cancel_client_order 1589 1589 0 0.00 0 10140 16 0 0
t$perf-norm:sp_cancel_customer_reserve 618 618 0 0.00 0 9362 44 0 0
t$perf-norm:sp_cancel_pay_from_customer 591 591 0 0.00 0 7017 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 457 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 366 366 0 0.00 0 4696 27 0 0
t$perf-norm:sp_cancel_supplier_order 363 363 0 0.00 0 27535 1757 0 0
t$perf-norm:sp_cancel_write_off 883 883 0 0.00 0 2548 7 0 0
t$perf-norm:sp_client_order 18660 18660 0 0.00 0 11291 22 0 0
t$perf-norm:sp_customer_reserve 846 846 0 0.00 0 3969 10 0 0
t$perf-norm:sp_pay_from_customer 6459 6459 0 0.00 0 8350 13 0 0
t$perf-norm:sp_pay_to_supplier 5357 5357 0 0.00 0 10710 13 0 0
t$perf-norm:sp_reserve_write_off 9068 9068 0 0.00 0 7611 12 0 0
t$perf-norm:sp_supplier_invoice 4952 4952 0 0.00 0 6945 25 0 0
t$perf-norm:sp_supplier_order 4960 4960 0 0.00 0 7902 19 0 0
t$perf-norm:srv_aggregate_perf_data 77 77 0 0.00 0 129 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 15 1 0 0
t$perf-norm:srv_make_invnt_saldo 490 490 0 0.00 0 2910 29 0 0
t$perf-norm:srv_make_money_saldo 746 746 0 0.00 0 1528 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 9162 8914 248 2.70 0 5383 18 0 248
v_all_customers 34366 34366 0 0.00 0 20 1 0 0
v_all_suppliers 28266 28266 0 0.00 0 26 1 0 0
v_all_wares 37320 37320 0 0.00 0 118 1 0 0
v_cancel_adding_invoice 774 774 0 0.00 0 2870 9 0 0
v_cancel_client_order 3178 3178 0 0.00 0 3235 5 0 0
v_cancel_customer_prepayment 1182 1182 0 0.00 0 2796 5 0 0
v_cancel_customer_reserve 1236 1236 0 0.00 0 2917 8 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 334 3 0 0
v_cancel_supplier_invoice 748 732 16 2.13 0 2589 18 0 16
v_cancel_supplier_order 726 726 0 0.00 0 2541 12 0 0
v_cancel_write_off 1766 1766 0 0.00 0 2118 15 0 0
v_max_id_clo_ord 4959 4959 0 0.00 0 3657 3 0 0
v_max_id_clo_res 846 846 0 0.00 0 13336 24 0 0
v_max_id_ord_sup 4947 4947 0 0.00 0 6100 4 0 0
v_max_non_paid_invoice 1130 1130 0 0.00 0 4887 12 0 0
v_max_non_paid_realizn 3275 3275 0 0.00 0 2732 5 0 0
v_min_id_clo_ord 4959 4959 0 0.00 0 2270 6 0 0
v_min_id_clo_res 846 846 0 0.00 0 4387 13 0 0
v_min_id_ord_sup 4947 4947 0 0.00 0 4017 5 0 0
v_min_non_paid_invoice 5357 5357 0 0.00 0 8275 24 0 0
v_min_non_paid_realizn 6459 6459 0 0.00 0 12777 29 0 0
v_our_firm 9322 9322 0 0.00 0 118 1 0 0
v_reserve_write_off 18136 18136 0 0.00 0 3434 8 0 0
x_lock_depdocs_on_canc_invoice 9461 9461 0 0.00 0 13509 130 0 0
x_lock_depdocs_on_canc_sup_ord 363 363 0 0.00 0 3407 296 0 0
x_make_qstorno_1000_1200 4960 4960 0 0.00 1 50469 1154 0 0
x_make_qstorno_1200_2000 4952 4952 0 0.00 2 74870 2984 0 0
x_make_qstorno_2100_3300 417206 417206 0 0.00 0 33686 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-03-2024 16:10:43 to 11-03-2024 16:10:47.

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
14:09:40 2 8192000000 8801486656 8814034944 5651072 0.068 3 1 2 0 5751888 58032 42784
14:10:41 18787 8192000000 9925452432 10238906368 989756256 10.779 100 90 180 0 1022889312 9792048 23341008
14:12:05 29293 8192000000 9967586272 10293317632 1029987808 11.168 100 83 166 1 1059510544 7975280 21547456
14:13:41 6862 8192000000 9997126560 10330435584 1065256000 11.507 100 88 176 0 1101322464 13886000 22180464
14:14:52 16962 8192000000 10020693968 10367213568 1097430624 11.813 100 82 164 0 1126933184 9998096 19504464
14:16:18 7813 8192000000 10068740960 10428039168 1147277584 12.284 100 74 142 1 1175475920 12081808 16116528
14:17:28 2746 8192000000 10103081488 10474057728 1191617072 12.698 100 72 143 1 1219302112 12269392 15415648
14:18:32 3224 8192000000 10152905856 10530516992 1229147392 13.046 100 71 142 0 1255984976 11465520 15372064
14:19:37 1729 8192000000 10187328144 10569609216 1264516336 13.371 100 76 152 0 1294744832 13217408 17011088
14:20:40 1931 8192000000 10205193728 10595307520 1284388640 13.553 100 76 152 0 1314021856 12193792 17439424
14:21:45 5885 8192000000 10215047344 10611589120 1299664832 13.692 100 66 127 2 1323411376 9586432 14160112
14:22:51 20525 8192000000 10197683888 10610946048 1301005664 13.704 100 26 51 0 1312532032 5443792 6082576
14:24:13 6903 8192000000 10204993280 10620514304 1307638736 13.765 100 28 54 0 1320050864 6720496 5691632
14:25:27 7807 8192000000 10202911296 10626682880 1312425856 13.808 100 16 32 0 1322258800 5682256 4150688
14:26:37 14773 8192000000 10207579184 10631659520 1314620784 13.828 100 15 30 0 1323644944 5602544 3421616
14:27:52 41423 8192000000 10229766144 10653179904 1327088832 13.941 100 44 83 0 1341139632 4710272 9340528
14:29:34 32735 8192000000 10239019440 10650963968 1311680624 13.801 99 29 56 0 1325182576 6712528 6789424
14:31:13 17823 8192000000 10260373568 10664722432 1325760880 13.929 100 61 122 0 1351314432 12283376 13270176
14:32:42 19174 8192000000 10256464672 10668568576 1321096672 13.887 99 56 113 1 1342909376 8769408 13043296
14:34:03 34635 8192000000 10262084176 10681466880 1338036896 14.040 100 44 87 1 1359628656 11917104 9674656
14:35:49 15347 8192000000 10262376432 10672865280 1312171264 13.806 98 47 94 0 1337245408 14435360 10638784
14:37:14 14886 8192000000 10245308768 10654420992 1316326032 13.843 100 40 79 0 1343254208 18098640 8829536
14:38:33 25148 8192000000 10229828832 10643066880 1279131440 13.505 97 31 62 0 1308253040 21345856 7775744
14:40:15 24152 8192000000 10223462240 10632032256 1258366544 13.315 96 29 58 0 1288603872 22821520 7415808
14:41:44 13021 8192000000 10236199488 10646745088 1296847440 13.667 99 35 70 1 1330715200 24922336 8945424
14:43:02 2792 8192000000 10256864912 10652561408 1323908576 13.912 100 63 126 0 1365399792 26152112 15339104
14:44:09 1086 8192000000 10279518256 10674003968 1335707920 14.019 99 74 147 1 1382977296 29302912 17966464
14:45:16 5664 8192000000 10290173680 10695708672 1350202704 14.149 100 58 112 0 1396026320 32142288 13681328
14:46:24 7563 8192000000 10309622400 10707849216 1355964800 14.201 100 67 131 2 1412298800 39094096 17239904
14:47:39 2235 8192000000 10331176960 10734358528 1377789184 14.397 100 77 150 0 1434159440 38005408 18364848
14:48:49 2710 8192000000 10347784672 10749939712 1381934640 14.434 100 80 161 0 1448586080 46379920 20271520
14:50:03 5062 8192000000 10346259376 10755559424 1377364144 14.393 99 67 134 1 1442282864 47491776 17426944
14:51:14 11173 8192000000 10336637312 10755641344 1397637520 14.574 100 59 117 1 1445028400 33048736 14342144
14:52:28 13902 8192000000 10325763904 10753839104 1380668672 14.423 99 38 72 4 1422923280 33262832 8991776
14:53:49 8950 8192000000 10324256128 10751938560 1388971920 14.497 100 36 70 1 1430119328 32755616 8391792
14:55:03 17102 8192000000 10330697696 10767806464 1385295984 14.464 100 23 46 0 1435394016 42948432 7149600
14:56:27 56332 8192000000 10327927312 10768998400 1373996496 14.363 100 13 26 0 1421719440 43924976 3797968
14:58:27 43133 8192000000 10302441968 10745049088 1375285984 14.374 99 9 18 0 1389380560 11788704 2305872
15:00:12 18275 8192000000 10310152416 10760380416 1395055152 14.551 100 21 42 1 1416982448 17168368 4758928
15:01:41 105411 8192000000 10312009440 10751733760 1389014672 14.497 100 31 62 0 1405322880 9389408 6918800
15:04:29 27915 8192000000 10321515072 10753208320 1397843664 14.576 100 40 78 1 1420481632 11850704 10787264
15:05:58 69895 8192000000 10308229872 10761252864 1401044368 14.604 100 18 34 1 1421899328 16832560 4022400
15:08:10 31674 8192000000 10341322512 10780172288 1413212704 14.712 100 42 84 0 1442969536 20159920 9596912
15:09:44 7773 8192000000 10329192928 10770096128 1407099088 14.658 100 37 74 2 1431547248 16224640 8223520
15:10:53 19041 8192000000 10310172016 10759151616 1404967344 14.639 100 21 41 0 1422940416 13115200 4857872
15:12:18 31572 8192000000 10291701872 10748928000 1397357024 14.571 100 28 56 1 1414947216 11041856 6548336
15:14:17 67432 8192000000 10256069920 10714382336 1323865888 13.912 95 13 26 0 1340412112 13088176 3458048
15:16:28 40416 8192000000 10257839808 10699960320 1328879936 13.957 97 22 44 2 1348875248 14510544 5484768
15:18:14 35059 8192000000 10270456352 10715250688 1342597760 14.081 98 18 36 0 1357477120 11117600 3761760
15:19:51 46496 8192000000 10256142224 10698080256 1306566160 13.755 96 25 50 1 1326646304 14077728 6002416
15:21:39 48058 8192000000 10256753968 10711281664 1339271664 14.051 99 17 34 0 1357177712 14099904 3806144
15:23:28 31528 8192000000 10268343504 10703208448 1305692176 13.747 96 33 65 1 1321485760 8687216 7106368
15:25:00 63738 8192000000 10260404608 10704195584 1326286528 13.934 98 16 32 0 1343768528 13715312 3766688
15:27:05 142046 8192000000 10267815376 10718445568 1300586832 13.701 96 8 16 0 1323163872 21261408 1315632
15:30:28 112182 8192000000 10267795248 10706243584 1337072624 14.031 98 28 56 0 1356849040 13131888 6644528
15:34:58 36783 8192000000 10269887504 10702508032 1340036336 14.058 99 44 88 0 1372439456 21976512 10426608
15:36:39 75373 8192000000 10266194400 10715664384 1361300576 14.249 100 21 41 1 1375889152 9753808 4834768
15:38:54 80628 8192000000 10271947392 10731888640 1357039280 14.211 99 11 22 1 1376277088 17273936 1963872
15:41:18 24994 8192000000 10281072400 10727391232 1372297600 14.348 100 25 50 0 1395597584 17830864 5469120
15:42:45 55891 8192000000 10288792112 10739126272 1363134288 14.265 98 12 24 0 1376138048 10611920 2391840
15:44:41 62689 8192000000 10283004240 10732916736 1367403648 14.304 98 17 35 0 1387572704 16173888 3995168
15:46:45 19389 8192000000 10314461152 10753806336 1395226032 14.552 100 51 102 1 1419834928 13217456 11391440
15:48:09 58082 8192000000 10293813600 10740629504 1339382592 14.052 96 17 34 0 1354652768 11653376 3616800
15:50:08 26110 8192000000 10280325184 10717343744 1354811568 14.191 98 30 60 1 1371004064 9865104 6327392
15:51:37 9703 8192000000 10318971200 10750726144 1380201024 14.418 99 59 120 1 1406750656 14227408 12322224
15:52:48 113858 8192000000 10311778480 10762784768 1367939456 14.309 98 14 29 0 1381120560 10347136 2833968
15:55:44 94368 8192000000 10291012256 10748297216 1385539152 14.466 99 13 26 0 1398390480 9814976 3036352
15:58:37 59720 8192000000 10287287536 10744233984 1351698144 14.163 97 35 71 0 1371810528 11933440 8178944
16:01:08 37718 8192000000 10233025664 10683441152 1317545488 13.854 96 6 12 0 1328418288 9380448 1492352
16:02:47 63135 8192000000 10242447616 10695143424 1316315792 13.843 96 23 46 0 1334676704 12237296 6123616
16:05:01 45422 8192000000 10251162384 10699923456 1300763120 13.702 96 12 24 0 1314044496 10623584 2657792
16:06:55 53619 8192000000 10226726448 10682822656 1304180048 13.733 96 20 40 0 1323250208 13944496 5125664
16:08:49 29643 8192000000 10253589760 10689011712 1315809904 13.839 98 46 85 0 1334289504 9117632 9361968

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 11-03-2024 16:10:49 to 11-03-2024 16:11:03.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-03-2024 16:11:04 to 11-03-2024 16:11:06.

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          179745
MON$OLDEST_ACTIVE               181978
MON$OLDEST_SNAPSHOT             181978
MON$NEXT_TRANSACTION            181978
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                       1909216
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.33735 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33735 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33735 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33735 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 Mon Mar 11 16:11:07 2024 
 
Database header page information: 
    Flags            0 
    Generation        95173 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    179745 
    Oldest active        181978 
    Oldest snapshot        181978 
    Next transaction    181979 
    Sequence number        0 
    Next attachment ID    732 
    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.34, total records: 7756150 
    Average version length: 48.16, total versions: 89291, 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: 86800 
    Data pages: 86800, average fill: 71% 
    Primary pages: 86800, secondary pages: 0, swept pages: 18716 
    Empty pages: 3, full pages: 66145 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 285 
    40 - 59% = 2086 
    60 - 79% = 84378 
    80 - 99% = 24 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23414, nodes: 7756150 
    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: 1717873, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 369 
        20 - 39% = 1973 
        40 - 59% = 4050 
        60 - 79% = 2542 
        80 - 99% = 14480 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13580, nodes: 7756150 
    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: 1540084, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1699 
        40 - 59% = 1969 
        60 - 79% = 1191 
        80 - 99% = 8721 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8394, nodes: 7756150 
    Average node length: 6.61, total dup: 5808830, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1532998, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 153 
        20 - 39% = 1080 
        40 - 59% = 1280 
        60 - 79% = 1002 
        80 - 99% = 4879 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.30, total records: 2238381 
    Average version length: 34.65, total versions: 88048, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28408 
    Data pages: 28408, average fill: 73% 
    Primary pages: 28399, secondary pages: 9, swept pages: 10521 
    Empty pages: 9, full pages: 20853 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 185 
    40 - 59% = 1981 
    60 - 79% = 25446 
    80 - 99% = 759 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4582, nodes: 2238381 
    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: 696483, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 979 
        40 - 59% = 823 
        60 - 79% = 807 
        80 - 99% = 1973 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2513, nodes: 2241007 
    Average node length: 4.97, total dup: 2240108, max dup: 19164 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1244908, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 244 
        40 - 59% = 1528 
        60 - 79% = 585 
        80 - 99% = 153 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2043, nodes: 2238381 
    Average node length: 4.97, total dup: 2238331, max dup: 130581 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056908, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 150 
        40 - 59% = 1011 
        60 - 79% = 51 
        80 - 99% = 826 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4377, nodes: 2238381 
    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: 696483, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 637 
        40 - 59% = 614 
        60 - 79% = 883 
        80 - 99% = 2136 
 
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.26, total records: 400 
    Average version length: 23.36, total versions: 238906, max versions: 624 
    Average fragment length: 2.00, total fragments: 57, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1464 
    Data pages: 1328, average fill: 90% 
    Primary pages: 8, secondary pages: 1320, swept pages: 0 
    Empty pages: 1, full pages: 1326 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1325 
 
    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: 3.65, total records: 86902 
    Average version length: 68.30, total versions: 82260, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 24.12 
    Pointer pages: 6, data page slots: 2312 
    Data pages: 1712, average fill: 64% 
    Primary pages: 1711, secondary pages: 1, swept pages: 0 
    Empty pages: 244, full pages: 1041 
    Fill distribution: 
     0 - 19% = 350 
    20 - 39% = 158 
    40 - 59% = 92 
    60 - 79% = 148 
    80 - 99% = 964 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1707043, depth: 3, leaf buckets: 365, nodes: 86902 
    Average node length: 13.12, total dup: 6509, max dup: 1 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 64910, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 236 
        40 - 59% = 107 
        60 - 79% = 21 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18511, max versions: 990 
    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: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.27, total records: 1474 
    Average version length: 43.47, total versions: 1398, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 25.55 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 47% 
    Primary pages: 29, secondary pages: 2, swept pages: 0 
    Empty pages: 6, full pages: 13 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90076, depth: 2, leaf buckets: 3, nodes: 1474 
    Average node length: 4.25, total dup: 1376, max dup: 170 
    Average key length: 2.70, compression ratio: 7.02 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 787, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.96, 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.16 
    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: 35.65, total records: 825511 
    Average version length: 25.46, total versions: 87467, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8144 
    Data pages: 8144, average fill: 71% 
    Primary pages: 8124, secondary pages: 20, swept pages: 1141 
    Empty pages: 10, full pages: 7062 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 38 
    40 - 59% = 216 
    60 - 79% = 7534 
    80 - 99% = 337 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 919, nodes: 825511 
    Average node length: 4.87, total dup: 825462, max dup: 157313 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90357, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 136 
        40 - 59% = 532 
        60 - 79% = 194 
        80 - 99% = 56 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 976, nodes: 825511 
    Average node length: 5.88, total dup: 735428, max dup: 44 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163296, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 96 
        40 - 59% = 462 
        60 - 79% = 111 
        80 - 99% = 304 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1014, nodes: 825511 
    Average node length: 5.88, total dup: 735428, max dup: 44 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165268, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 211 
        40 - 59% = 398 
        60 - 79% = 92 
        80 - 99% = 312 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1148, nodes: 825511 
    Average node length: 5.96, total dup: 735428, max dup: 44 
    Average key length: 3.09, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157864, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 238 
        40 - 59% = 573 
        60 - 79% = 253 
        80 - 99% = 83 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5463 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.52, total fragments: 61, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 72, secondary pages: 16, swept pages: 51 
    Empty pages: 5, full pages: 69 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5463 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.44, average data length: 1.55 
    Clustering factor: 5182, 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: 5463 
    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: 149, 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: 83176 
    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: 808 
    Data pages: 808, average fill: 71% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 801 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 801 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33950, depth: 2, leaf buckets: 105, nodes: 83176 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3490, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 105 
 
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.12, 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.22 
    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: 143.16, total records: 157805 
    Average version length: 152.34, total versions: 7970, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 5, data page slots: 5608 
    Data pages: 3776, average fill: 86% 
    Primary pages: 3776, secondary pages: 0, swept pages: 4 
    Empty pages: 30, full pages: 3724 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 3 
    40 - 59% = 10 
    60 - 79% = 9 
    80 - 99% = 3722 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 147.09, total records: 169137 
    Average version length: 151.47, total versions: 4073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 5, data page slots: 5400 
    Data pages: 4032, average fill: 86% 
    Primary pages: 4032, secondary pages: 0, swept pages: 5 
    Empty pages: 28, full pages: 3998 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3997 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.64, total records: 182044 
    Average version length: 150.78, total versions: 5534, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 8, data page slots: 5344 
    Data pages: 4360, average fill: 86% 
    Primary pages: 4360, secondary pages: 0, swept pages: 2 
    Empty pages: 37, full pages: 4311 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4310 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.46, total records: 167153 
    Average version length: 150.30, total versions: 3833, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 8, data page slots: 5736 
    Data pages: 4000, average fill: 86% 
    Primary pages: 3999, secondary pages: 1, swept pages: 6 
    Empty pages: 35, full pages: 3947 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 3947 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 130.13, total records: 166531 
    Average version length: 154.21, total versions: 22967, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.03 
    Pointer pages: 7, data page slots: 5888 
    Data pages: 4008, average fill: 87% 
    Primary pages: 4008, secondary pages: 0, swept pages: 7 
    Empty pages: 46, full pages: 3946 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3945 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 144.30, total records: 156585 
    Average version length: 151.67, total versions: 6686, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 6, data page slots: 4720 
    Data pages: 3760, average fill: 86% 
    Primary pages: 3760, secondary pages: 0, swept pages: 3 
    Empty pages: 51, full pages: 3700 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3699 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 142.87, total records: 170499 
    Average version length: 153.28, total versions: 9216, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 8, data page slots: 5312 
    Data pages: 4080, average fill: 87% 
    Primary pages: 4080, secondary pages: 0, swept pages: 3 
    Empty pages: 34, full pages: 4039 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4037 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 144.04, total records: 185521 
    Average version length: 152.97, total versions: 8647, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 9, data page slots: 6248 
    Data pages: 4432, average fill: 87% 
    Primary pages: 4432, secondary pages: 0, swept pages: 3 
    Empty pages: 29, full pages: 4393 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4393 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.29, total records: 160939 
    Average version length: 152.19, total versions: 7157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 7, data page slots: 5056 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3848, secondary pages: 0, swept pages: 2 
    Empty pages: 30, full pages: 3806 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 3806 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 131.88, total records: 188788 
    Average version length: 154.26, total versions: 23659, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.86 
    Pointer pages: 7, data page slots: 5888 
    Data pages: 4528, average fill: 87% 
    Primary pages: 4528, secondary pages: 0, swept pages: 6 
    Empty pages: 13, full pages: 4436 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 5 
    40 - 59% = 49 
    60 - 79% = 28 
    80 - 99% = 4433 
 
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.79, total records: 2102649 
    Average version length: 52.94, total versions: 38174, 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: 25552 
    Data pages: 25544, average fill: 71% 
    Primary pages: 25544, secondary pages: 0, swept pages: 10408 
    Empty pages: 316, full pages: 21103 
    Fill distribution: 
     0 - 19% = 616 
    20 - 39% = 463 
    40 - 59% = 1034 
    60 - 79% = 23124 
    80 - 99% = 307 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2575, nodes: 2102649 
    Average node length: 5.45, total dup: 1960961, max dup: 1645 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183139, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 289 
        40 - 59% = 1671 
        60 - 79% = 319 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2102649 
    Average node length: 5.69, total dup: 1887268, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376713, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2406 
        60 - 79% = 329 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2171, nodes: 2102649 
    Average node length: 4.96, total dup: 2102549, max dup: 27247 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180878, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 224 
        40 - 59% = 1162 
        60 - 79% = 402 
        80 - 99% = 383 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.33, total records: 153157 
    Average version length: 69.20, total versions: 72794, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.47 
    Pointer pages: 3, data page slots: 4272 
    Data pages: 3152, average fill: 57% 
    Primary pages: 3152, secondary pages: 0, swept pages: 390 
    Empty pages: 625, full pages: 1782 
    Fill distribution: 
     0 - 19% = 787 
    20 - 39% = 128 
    40 - 59% = 186 
    60 - 79% = 868 
    80 - 99% = 1183 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98776, depth: 3, leaf buckets: 231, nodes: 153157 
    Average node length: 6.46, total dup: 133347, max dup: 14 
    Average key length: 3.93, compression ratio: 10.68 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25837, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 41 
        40 - 59% = 101 
        60 - 79% = 69 
        80 - 99% = 16 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.74, total records: 7265567 
    Average version length: 68.78, total versions: 445094, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 65, data page slots: 104920 
    Data pages: 104920, average fill: 74% 
    Primary pages: 104920, secondary pages: 0, swept pages: 24462 
    Empty pages: 30, full pages: 81682 
    Fill distribution: 
     0 - 19% = 197 
    20 - 39% = 1127 
    40 - 59% = 6844 
    60 - 79% = 89593 
    80 - 99% = 7159 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10764, nodes: 7265567 
    Average node length: 6.51, total dup: 6286856, max dup: 29 
    Average key length: 3.52, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1607198, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1402 
        40 - 59% = 5893 
        60 - 79% = 2833 
        80 - 99% = 629 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8522, nodes: 7265567 
    Average node length: 5.39, total dup: 6982092, max dup: 188 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1402313, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 846 
        40 - 59% = 4838 
        60 - 79% = 1855 
        80 - 99% = 973 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8589, nodes: 7265567 
    Average node length: 5.39, total dup: 6982092, max dup: 188 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1404806, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 867 
        40 - 59% = 4900 
        60 - 79% = 1880 
        80 - 99% = 938 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.67, total records: 12243209 
    Average version length: 68.77, total versions: 405220, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 105, data page slots: 171200 
    Data pages: 171200, average fill: 76% 
    Primary pages: 171200, secondary pages: 0, swept pages: 72861 
    Empty pages: 9, full pages: 155108 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 699 
    40 - 59% = 4681 
    60 - 79% = 158274 
    80 - 99% = 7467 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18463, nodes: 12243209 
    Average node length: 6.59, total dup: 10672925, max dup: 59 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2401780, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 2117 
        40 - 59% = 10657 
        60 - 79% = 4828 
        80 - 99% = 830 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 42.23, total records: 1680532 
    Average version length: 69.15, total versions: 654588, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.98 
    Pointer pages: 26, data page slots: 40968 
    Data pages: 27336, average fill: 70% 
    Primary pages: 27335, secondary pages: 1, swept pages: 4574 
    Empty pages: 1718, full pages: 21060 
    Fill distribution: 
     0 - 19% = 3124 
    20 - 39% = 1306 
    40 - 59% = 941 
    60 - 79% = 10697 
    80 - 99% = 11268 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2177, nodes: 1680532 
    Average node length: 5.52, total dup: 1612592, max dup: 99 
    Average key length: 2.55, compression ratio: 16.45 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 114981, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 423 
        40 - 59% = 1080 
        60 - 79% = 518 
        80 - 99% = 144 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.23, total records: 1201327 
    Average version length: 69.15, total versions: 553367, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.38 
    Pointer pages: 21, data page slots: 33488 
    Data pages: 26768, average fill: 52% 
    Primary pages: 26768, secondary pages: 0, swept pages: 6124 
    Empty pages: 5714, full pages: 14321 
    Fill distribution: 
     0 - 19% = 8642 
    20 - 39% = 1448 
    40 - 59% = 1051 
    60 - 79% = 5410 
    80 - 99% = 10217 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1544, nodes: 1201327 
    Average node length: 5.77, total dup: 1123303, max dup: 99 
    Average key length: 2.83, compression ratio: 14.83 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 160814, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 252 
        40 - 59% = 702 
        60 - 79% = 428 
        80 - 99% = 157 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.56, total records: 9114644 
    Average version length: 69.02, total versions: 440785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 88, data page slots: 143576 
    Data pages: 143504, average fill: 68% 
    Primary pages: 143504, secondary pages: 0, swept pages: 57476 
    Empty pages: 554, full pages: 82444 
    Fill distribution: 
     0 - 19% = 1718 
    20 - 39% = 8357 
    40 - 59% = 24098 
    60 - 79% = 101168 
    80 - 99% = 8163 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13460, nodes: 9114644 
    Average node length: 6.67, total dup: 7563843, max dup: 27 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1933666, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1379 
        40 - 59% = 6941 
        60 - 79% = 4527 
        80 - 99% = 612 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21194637 
    Average version length: 83.01, total versions: 11351, 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: 319264 
    Data pages: 319264, average fill: 81% 
    Primary pages: 319264, secondary pages: 0, swept pages: 12145 
    Empty pages: 2, full pages: 319261 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 27191 
    80 - 99% = 292070 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19615, nodes: 21194637 
    Average node length: 5.72, total dup: 20712643, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286422, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8525 
        60 - 79% = 577 
        80 - 99% = 10508 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17212, nodes: 21194637 
    Average node length: 6.31, total dup: 18625342, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915780, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 787 
        60 - 79% = 272 
        80 - 99% = 16148 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21378, nodes: 21194637 
    Average node length: 6.35, total dup: 18544507, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582112, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1 
        40 - 59% = 8745 
        60 - 79% = 601 
        80 - 99% = 12020 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16326, nodes: 21194637 
    Average node length: 5.56, total dup: 21194537, max dup: 231706 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944848, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 3217 
        60 - 79% = 497 
        80 - 99% = 12604 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.55, total records: 9582005 
    Average version length: 82.69, total versions: 448142, 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: 105, data page slots: 170736 
    Data pages: 170600, average fill: 69% 
    Primary pages: 170600, secondary pages: 0, swept pages: 77687 
    Empty pages: 864, full pages: 99416 
    Fill distribution: 
     0 - 19% = 2472 
    20 - 39% = 9400 
    40 - 59% = 27896 
    60 - 79% = 66358 
    80 - 99% = 64474 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11380, nodes: 9582005 
    Average node length: 5.36, total dup: 9274657, max dup: 168 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2067631, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 89 
        40 - 59% = 8645 
        60 - 79% = 2567 
        80 - 99% = 76 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13406, nodes: 9582005 
    Average node length: 6.23, total dup: 7946338, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1414194, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 3939 
        40 - 59% = 4268 
        60 - 79% = 2646 
        80 - 99% = 2389 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12706, nodes: 9582005 
    Average node length: 5.98, total dup: 8311779, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2261302, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 9669 
        60 - 79% = 2852 
        80 - 99% = 83 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9988, nodes: 9582005 
    Average node length: 5.13, total dup: 9581905, max dup: 160811 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1456409, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1299 
        40 - 59% = 4899 
        60 - 79% = 1586 
        80 - 99% = 2155 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.90, total records: 11252212 
    Average version length: 82.57, total versions: 328460, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 118, data page slots: 192064 
    Data pages: 190168, average fill: 73% 
    Primary pages: 190168, secondary pages: 0, swept pages: 70051 
    Empty pages: 3732, full pages: 143998 
    Fill distribution: 
     0 - 19% = 6106 
    20 - 39% = 7704 
    40 - 59% = 16989 
    60 - 79% = 41342 
    80 - 99% = 118027 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13130, nodes: 11252212 
    Average node length: 5.29, total dup: 11142620, max dup: 694 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2341731, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 141 
        40 - 59% = 9373 
        60 - 79% = 3470 
        80 - 99% = 143 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10426, nodes: 11252212 
    Average node length: 5.49, total dup: 10760302, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 702196, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 864 
        40 - 59% = 2579 
        60 - 79% = 1822 
        80 - 99% = 4985 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15015, nodes: 11252212 
    Average node length: 6.01, total dup: 9818396, max dup: 75 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2358277, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 184 
        40 - 59% = 10941 
        60 - 79% = 3722 
        80 - 99% = 166 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10703, nodes: 11252212 
    Average node length: 5.21, total dup: 11252112, max dup: 204631 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 691494, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 867 
        40 - 59% = 4722 
        60 - 79% = 1507 
        80 - 99% = 3522 
 
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.89, total records: 9700681 
    Average version length: 82.96, total versions: 450833, 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: 107, data page slots: 174224 
    Data pages: 174096, average fill: 69% 
    Primary pages: 174096, secondary pages: 0, swept pages: 82418 
    Empty pages: 959, full pages: 98178 
    Fill distribution: 
     0 - 19% = 2571 
    20 - 39% = 9645 
    40 - 59% = 29034 
    60 - 79% = 70382 
    80 - 99% = 62464 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11721, nodes: 9700681 
    Average node length: 5.17, total dup: 9672029, max dup: 1632 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1884276, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1454 
        40 - 59% = 7803 
        60 - 79% = 1819 
        80 - 99% = 604 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13491, nodes: 9700681 
    Average node length: 6.24, total dup: 8044431, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1377351, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 3916 
        40 - 59% = 4247 
        60 - 79% = 2621 
        80 - 99% = 2534 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12354, nodes: 9700681 
    Average node length: 5.43, total dup: 9265603, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2017411, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1464 
        40 - 59% = 8659 
        60 - 79% = 1633 
        80 - 99% = 574 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10183, nodes: 9700681 
    Average node length: 5.14, total dup: 9700581, max dup: 162657 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1471074, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1358 
        40 - 59% = 5038 
        60 - 79% = 1622 
        80 - 99% = 2120 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.53, total records: 581459 
    Average version length: 68.79, total versions: 5470, 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: 8016 
    Data pages: 8016, average fill: 76% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3732 
    Empty pages: 2, full pages: 7115 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 15 
    40 - 59% = 174 
    60 - 79% = 7740 
    80 - 99% = 83 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44276, depth: 3, leaf buckets: 741, nodes: 581459 
    Average node length: 5.95, total dup: 495285, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101123, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 515 
        60 - 79% = 103 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33870, depth: 3, leaf buckets: 757, nodes: 581459 
    Average node length: 6.15, total dup: 476931, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101170, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 520 
        60 - 79% = 97 
        80 - 99% = 108 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 576, nodes: 581459 
    Average node length: 4.86, total dup: 581359, max dup: 9822 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89739, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 339 
        60 - 79% = 96 
        80 - 99% = 118 
 
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 Mon Mar 11 16:11:30 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7756150 89291 1 0.0000 0.0000
DOC_LIST 2238381 88048 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238906 624 59700.0000 0.0000
INVNT_TURNOVER_LOG 86902 82260 1 0.0000 0.0000
MONEY_SALDO 49 18511 990 37700.0000 0.0000
MONEY_TURNOVER_LOG 1474 1398 1 0.0000 0.0000
PDISTR 825511 87467 6 0.0000 0.0000
PERF_SPLIT_0 157805 7970 1 0.0000 0.0000
PERF_SPLIT_1 169137 4073 1 0.0000 0.0000
PERF_SPLIT_2 182044 5534 1 0.0000 0.0000
PERF_SPLIT_3 167153 3833 1 0.0000 0.0000
PERF_SPLIT_4 166531 22967 1 0.0000 0.0000
PERF_SPLIT_5 156585 6686 1 0.0000 0.0000
PERF_SPLIT_6 170499 9216 1 0.0000 0.0000
PERF_SPLIT_7 185521 8647 1 0.0000 0.0000
PERF_SPLIT_8 160939 7157 1 0.0000 0.0000
PERF_SPLIT_9 188788 23659 1 0.0000 0.0000
PSTORNED 2102649 38174 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 153157 72794 1 0.0000 0.0000
XQD_1000_3300 7265567 445094 1 0.0000 0.0000
XQD_1200_2000 12243209 405220 1 0.0000 0.0000
XQD_2000_3300 1680532 654588 1 0.0000 0.0000
XQD_2100_3300 1201327 553367 1 0.0000 0.0000
XQD_3300_3400 9114644 440785 1 0.0000 0.0000
XQS_1000_1200 21194637 11351 1 0.0000 0.0000
XQS_1000_3300 9582005 448142 1 0.0000 0.0000
XQS_1200_2000 11252212 328460 1 0.0000 0.0000
XQS_2100_3300 9700681 450833 1 0.0000 0.0000
XQS_3300_3400 581459 5470 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 ---
:154: 
:155: mscs-test-161.budzdorov.ru    Mon Mar 11 16:09:36 2024
:156:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:157: 
:158: 
:159: mscs-test-161.budzdorov.ru    Mon Mar 11 16:09:39 2024
:160:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:161: 
:162: 
:163: mscs-test-161.budzdorov.ru    Mon Mar 11 16:09:39 2024
:164:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:165: 
--- end of diff output ---

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

11.03.24 16:11:42. 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-11 16:11:45 No severe PSQL-related problems occured
11.03.24 16:11:46. End of report.